include 'includes/header.php';
include 'config.php';
// ADD WORKER
if ($_SERVER["REQUEST_METHOD"] == "POST") {

    $name = $_POST['name'];
    $phone = $_POST['phone'];
    $worker_type = $_POST['worker_type'];
    $monthly_salary = $_POST['monthly_salary'] ?? 0;
    $per_piece_rate = $_POST['per_piece_rate'] ?? 0;

    $stmt = $pdo->prepare("INSERT INTO workers 
        (name, phone, worker_type, monthly_salary, per_piece_rate) 
        VALUES (?, ?, ?, ?, ?)");

    $stmt->execute([$name, $phone, $worker_type, $monthly_salary, $per_piece_rate]);

    echo "<div class='alert alert-success'>Worker Added Successfully</div>";
}

// FETCH WORKERS
$stmt = $pdo->query("SELECT * FROM workers ORDER BY worker_id DESC");
$workers = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>

<div class="container-fluid">

    <h2 class="mb-4 fw-bold">Workers Management</h2>

    <!-- Add Worker Card -->
    <div class="card shadow-sm border-0 rounded-4 p-4 mb-4">
        <h5 class="mb-3">Add New Worker</h5>

        <form method="POST">
            <div class="row g-3">

                <div class="col-md-4">
                    <label class="form-label">Worker Name</label>
                    <input type="text" name="name" class="form-control" required>
                </div>

                <div class="col-md-3">
                    <label class="form-label">Phone</label>
                    <input type="text" name="phone" class="form-control">
                </div>

                <div class="col-md-3">
                    <label class="form-label">Worker Type</label>
                    <select name="worker_type" id="workerType" class="form-select" required>
                        <option value="">Select Type</option>
                        <option value="monthly">Monthly</option>
                        <option value="per_piece">Per Piece</option>
                    </select>
                </div>

                <div class="col-md-3" id="monthlyField" style="display:none;">
                    <label class="form-label">Monthly Salary</label>
                    <input type="number" step="0.01" name="monthly_salary" class="form-control">
                </div>

                <div class="col-md-3" id="pieceField" style="display:none;">
                    <label class="form-label">Per Piece Rate</label>
                    <input type="number" step="0.01" name="per_piece_rate" class="form-control">
                </div>

            </div>

            <div class="mt-3">
                <button type="submit" class="btn btn-primary px-4">Add Worker</button>
            </div>
        </form>
    </div>

    <!-- Workers List -->
    <div class="card shadow-sm border-0 rounded-4 p-4">
        <h5 class="mb-3">Workers List</h5>

        <div class="table-responsive">
            <table class="table table-hover align-middle">
                <thead class="table-light">
                    <tr>
                        <th>Name</th>
                        <th>Phone</th>
                        <th>Type</th>
                        <th>Monthly Salary</th>
                        <th>Per Piece Rate</th>
                    </tr>
                </thead>
                <tbody>
                    <br />
<b>Notice</b>:  Undefined variable: workers in <b>/home/getaplus/public_html/workers.php</b> on line <b>97</b><br />
<br />
<b>Warning</b>:  Invalid argument supplied for foreach() in <b>/home/getaplus/public_html/workers.php</b> on line <b>97</b><br />
                </tbody>
            </table>
        </div>

    </div>

</div>

<script>
document.getElementById('workerType').addEventListener('change', function() {
    document.getElementById('monthlyField').style.display = 
        this.value === 'monthly' ? 'block' : 'none';

    document.getElementById('pieceField').style.display = 
        this.value === 'per_piece' ? 'block' : 'none';
});
</script>
if ($_SERVER["REQUEST_METHOD"] == "POST") {

    $name = $_POST['name'] ?? '';
    $phone = $_POST['phone'] ?? '';
    $worker_type = $_POST['worker_type'] ?? '';

    $monthly_salary = 0;
    $per_piece_rate = 0;

    if ($worker_type === 'monthly') {
        $monthly_salary = $_POST['monthly_salary'] ?? 0;
    }

    if ($worker_type === 'per_piece') {
        $per_piece_rate = $_POST['per_piece_rate'] ?? 0;
    }

    try {
        $stmt = $pdo->prepare("INSERT INTO workers 
            (name, phone, worker_type, monthly_salary, per_piece_rate) 
            VALUES (?, ?, ?, ?, ?)");

        $stmt->execute([
            $name,
            $phone,
            $worker_type,
            $monthly_salary,
            $per_piece_rate
        ]);

        echo "<div class='alert alert-success'>Worker Added Successfully</div>";

    } catch (PDOException $e) {
        echo "<div class='alert alert-danger'>Error: " . $e->getMessage() . "</div>";
    }
}

</div>

<script src="../assets/js/bootstrap.bundle.min.js"></script>
</body>
</html>