« Back to History
contractor_employee_add.php
|
20260921_175631.php
Initial Domain Snapshot
Copy Code
<?php require_once __DIR__ . '/modules/auth/page_acl.php'; $ctx = page_require_access('contractor_employee_add'); $pdo = $ctx['pdo'] ?? null; $company_id = (int)($ctx['company_id'] ?? 0); if (!$pdo) { require_once __DIR__ . '/core/db.php'; } require_once __DIR__ . '/helpers/activity_helper.php'; /* helper */ function h($s){ return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8'); } /* CSRF */ if (empty($_SESSION['csrf_token'])) { $_SESSION['csrf_token'] = bin2hex(random_bytes(32)); } $csrf = $_SESSION['csrf_token']; /* Contractor list (company employee acting as contractor) */ $cStmt = $pdo->prepare(" SELECT id, name FROM company_employee_master WHERE company_id = ? ORDER BY name "); $cStmt->execute([$company_id]); $contractors = $cStmt->fetchAll(PDO::FETCH_ASSOC); $msg = ''; $err = ''; /* 1. DELETE ACTION */ if (isset($_GET['action']) && $_GET['action'] === 'delete' && isset($_GET['id'])) { $delete_id = (int)$_GET['id']; try { $pdo->beginTransaction(); // Safety check with company_id segregation $stmt = $pdo->prepare("DELETE FROM contractor_employee WHERE id = ? AND cid = ?"); $stmt->execute([$delete_id, $company_id]); activity_create('payment', 'contractor_employee_delete', $delete_id, 'Deleted contractor employee'); $pdo->commit(); $msg = 'Contractor employee deleted successfully'; } catch (Exception $e) { $pdo->rollBack(); $err = 'Error deleting record: ' . $e->getMessage(); } } /* 2. SUBMIT / POST ACTION (ADD & UPDATE) */ if ($_SERVER['REQUEST_METHOD'] === 'POST') { if (!hash_equals($_SESSION['csrf_token'], $_POST['csrf_token'] ?? '')) { $err = 'Invalid CSRF token'; } else { $action = trim($_POST['action'] ?? 'add'); $contractor_id = (int)($_POST['contractor_id'] ?? 0); $department = trim($_POST['department'] ?? ''); $employee_name = trim($_POST['employee_name'] ?? ''); $bene_name = trim($_POST['bene_name'] ?? ''); $account_no = trim($_POST['account_no'] ?? ''); $ifsc_code = trim($_POST['ifsc_code'] ?? ''); if ( !$contractor_id || $department === '' || $employee_name === '' || $bene_name === '' || $account_no === '' || $ifsc_code === '' ) { $err = 'All fields are mandatory'; } else { try { $pdo->beginTransaction(); if ($action === 'update') { /* UPDATE LOGIC */ $edit_id = (int)$_POST['id']; $upd = $pdo->prepare(" UPDATE contractor_employee SET contractor_id = :contractor_id, department = :department, employee_name = :employee_name, bene_name = :bene_name, account_no = :account_no, ifsc_code = :ifsc_code WHERE id = :id AND cid = :cid "); $upd->execute([ ':contractor_id' => $contractor_id, ':department' => $department, ':employee_name' => $employee_name, ':bene_name' => $bene_name, ':account_no' => $account_no, ':ifsc_code' => strtoupper($ifsc_code), ':id' => $edit_id, ':cid' => $company_id ]); activity_create('payment', 'contractor_employee_update', $edit_id, 'Updated contractor employee'); $msg = 'Contractor employee updated successfully'; } else { /* INSERT LOGIC */ $ins = $pdo->prepare(" INSERT INTO contractor_employee (cid, contractor_id, department, employee_name, bene_name, account_no, ifsc_code) VALUES (:cid, :contractor_id, :department, :employee_name, :bene_name, :account_no, :ifsc_code) "); $ins->execute([ ':cid' => $company_id, ':contractor_id' => $contractor_id, ':department' => $department, ':employee_name' => $employee_name, ':bene_name' => $bene_name, ':account_no' => $account_no, ':ifsc_code' => strtoupper($ifsc_code), ]); activity_create('payment', 'contractor_employee_create', (int)$pdo->lastInsertId(), 'Added contractor employee'); $msg = 'Contractor employee added successfully'; } $pdo->commit(); } catch (Exception $e) { $pdo->rollBack(); $err = 'Database Error: ' . $e->getMessage(); } } } } /* 3. FETCH SINGLE RECORD FOR EDIT MODAL */ $edit_record = null; if (isset($_GET['action']) && $_GET['action'] === 'edit' && isset($_GET['id'])) { $edit_id = (int)$_GET['id']; $stmt = $pdo->prepare("SELECT * FROM contractor_employee WHERE id = ? AND cid = ? LIMIT 1"); $stmt->execute([$edit_id, $company_id]); $edit_record = $stmt->fetch(PDO::FETCH_ASSOC); } /* 4. FETCH ALL RECORDS FOR LISTING */ $records = []; try { $stmt = $pdo->prepare(" SELECT ce.*, cem.name as contractor_name FROM contractor_employee ce LEFT JOIN company_employee_master cem ON ce.contractor_id = cem.id WHERE ce.cid = ? ORDER BY ce.id DESC "); $stmt->execute([$company_id]); $records = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (Exception $e) { $err = 'Error fetching records: ' . $e->getMessage(); } ?> <?php require_once __DIR__ . '/partials/header.php'; ?> <div class="container py-4"> <?php if ($err): ?> <div class="alert alert-danger alert-dismissible fade show" role="alert"> <i class="bi bi-exclamation-triangle-fill me-2"></i> <?= h($err) ?> <button type="button" class="btn-close" data-bs-dismiss="alert"></button> </div> <?php endif; ?> <?php if ($msg): ?> <div class="alert alert-success alert-dismissible fade show" role="alert"> <i class="bi bi-check-circle-fill me-2"></i> <?= h($msg) ?> <button type="button" class="btn-close" data-bs-dismiss="alert"></button> </div> <?php endif; ?> <div class="card border-0 shadow-sm mb-5"> <div class="card-header bg-primary text-white py-3"> <h5 class="mb-0"><i class="bi bi-person-plus-fill me-2"></i>Contractor Employee Add</h5> </div> <div class="card-body p-4"> <form method="post"> <input type="hidden" name="csrf_token" value="<?= h($csrf) ?>"> <input type="hidden" name="action" value="add"> <div class="row g-3"> <div class="col-md-4"> <label class="form-label small fw-bold">Contractor (Company Employee)</label> <select name="contractor_id" class="form-select border-primary-subtle shadow-sm" required> <option value="">Select Contractor</option> <?php foreach ($contractors as $c): ?> <option value="<?= $c['id'] ?>"><?= h($c['name']) ?></option> <?php endforeach; ?> </select> </div> <div class="col-md-4"> <label class="form-label small fw-bold">Contractor Department</label> <select name="department" class="form-select border-primary-subtle" required> <option value="">Select Department</option> <option value="pissing">Pissing</option> <option value="zari">Zari</option> <option value="pasaria">Pasaria</option> <option value="warping">Warping</option> <option value="other">Other</option> </select> </div> <div class="col-md-4"> <label class="form-label small fw-bold">Contractor Employee Name</label> <input type="text" name="employee_name" class="form-control" placeholder="Enter name" required> </div> <div class="col-12 my-2"> <hr class="opacity-10"> <div class="small fw-bold text-muted text-uppercase mb-2">Banking Details</div> </div> <div class="col-md-4"> <label class="form-label small fw-bold text-secondary">Beneficiary Name</label> <input type="text" name="bene_name" class="form-control border-secondary-subtle" placeholder="As per bank record" required> </div> <div class="col-md-4"> <label class="form-label small fw-bold text-secondary">Account No</label> <input type="text" name="account_no" class="form-control border-secondary-subtle" placeholder="Enter account number" required> </div> <div class="col-md-4"> <label class="form-label small fw-bold text-secondary">IFSC Code</label> <input type="text" name="ifsc_code" class="form-control border-secondary-subtle" placeholder="e.g. SBIN0001234" required> </div> <div class="col-12 mt-4 text-end"> <hr class="mb-4 opacity-10"> <button type="submit" class="btn btn-primary btn-lg px-5 shadow-sm"> <i class="bi bi-cloud-check me-2"></i>Save Contractor Employee </button> </div> </div> </form> </div> </div> <div class="card border-0 shadow-sm"> <div class="card-header bg-dark text-white py-3"> <h5 class="mb-0"><i class="bi bi-list-stars me-2"></i>Contractor Employee List</h5> </div> <div class="card-body p-0"> <div class="table-responsive"> <table class="table table-striped table-hover align-middle mb-0 text-center"> <thead class="table-light"> <tr> <th>SR</th> <th>Contractor</th> <th>Employee Name</th> <th>Department</th> <th>Bank Account</th> <th>IFSC</th> <th>Actions</th> </tr> </thead> <tbody> <?php if (count($records) > 0): ?> <?php $sr = 1; foreach ($records as $row): ?> <tr> <td><?= $sr++; ?></td> <td><?= h($row['contractor_name']); ?></td> <td><strong><?= h($row['employee_name']); ?></strong></td> <td><span class="badge bg-secondary text-uppercase"><?= h($row['department']); ?></span></td> <td><?= h($row['account_no']); ?> <br><small class="text-muted">(<?= h($row['bene_name']); ?>)</small></td> <td><code class="text-dark fw-bold"><?= h($row['ifsc_code']); ?></code></td> <td> <a href="?action=edit&id=<?= $row['id']; ?>" class="btn btn-sm btn-warning me-1"> <i class="bi bi-pencil-square"></i> Edit </a> <a href="?action=delete&id=<?= $row['id']; ?>" class="btn btn-sm btn-danger" onclick="return confirm('Are you sure you want to delete this employee?');"> <i class="bi bi-trash"></i> Delete </a> </td> </tr> <?php endforeach; ?> <?php else: ?> <tr> <td colspan="7" class="text-muted py-4">No records found.</td> </tr> <?php endif; ?> </tbody> </table> </div> </div> </div> </div> <?php if ($edit_record): ?> <div class="modal fade show d-block" id="editModal" tabindex="-1" style="background: rgba(0,0,0,0.5);" aria-modal="true" role="dialog"> <div class="modal-dialog modal-dialog-centered modal-lg"> <div class="modal-content border-0 shadow-lg"> <div class="modal-header bg-warning text-dark"> <h5 class="modal-title fw-bold"><i class="bi bi-pencil-square me-2"></i>Edit Contractor Employee</h5> <a href="?" class="btn-close" aria-label="Close"></a> </div> <form method="POST" action="?"> <input type="hidden" name="csrf_token" value="<?= h($csrf) ?>"> <input type="hidden" name="action" value="update"> <input type="hidden" name="id" value="<?= $edit_record['id']; ?>"> <div class="modal-body p-4"> <div class="row g-3"> <div class="col-md-6"> <label class="form-label small fw-bold">Contractor</label> <select name="contractor_id" class="form-select border-primary-subtle" required> <?php foreach ($contractors as $c): ?> <option value="<?= $c['id'] ?>" <?= $edit_record['contractor_id'] == $c['id'] ? 'selected' : '' ?>> <?= h($c['name']) ?> </option> <?php endforeach; ?> </select> </div> <div class="col-md-6"> <label class="form-label small fw-bold">Department</label> <select name="department" class="form-select border-primary-subtle" required> <option value="pissing" <?= $edit_record['department'] === 'pissing' ? 'selected' : '' ?>>Pissing</option> <option value="zari" <?= $edit_record['department'] === 'zari' ? 'selected' : '' ?>>Zari</option> <option value="pasaria" <?= $edit_record['department'] === 'pasaria' ? 'selected' : '' ?>>Pasaria</option> <option value="warping" <?= $edit_record['department'] === 'warping' ? 'selected' : '' ?>>Warping</option> <option value="other" <?= $edit_record['department'] === 'other' ? 'selected' : '' ?>>Other</option> </select> </div> <div class="col-md-12"> <label class="form-label small fw-bold">Employee Name</label> <input type="text" name="employee_name" class="form-control" value="<?= h($edit_record['employee_name']); ?>" required> </div> <div class="col-12 my-2"> <hr class="opacity-10"> <div class="small fw-bold text-muted text-uppercase">Banking Details</div> </div> <div class="col-md-4"> <label class="form-label small fw-bold text-secondary">Beneficiary Name</label> <input type="text" name="bene_name" class="form-control text-dark" value="<?= h($edit_record['bene_name']); ?>" required> </div> <div class="col-md-4"> <label class="form-label small fw-bold text-secondary">Account No</label> <input type="text" name="account_no" class="form-control text-dark" value="<?= h($edit_record['account_no']); ?>" required> </div> <div class="col-md-4"> <label class="form-label small fw-bold text-secondary">IFSC Code</label> <input type="text" name="ifsc_code" class="form-control text-dark" value="<?= h($edit_record['ifsc_code']); ?>" required> </div> </div> </div> <div class="modal-footer bg-light"> <a href="?" class="btn btn-secondary px-4">Cancel</a> <button type="submit" class="btn btn-primary px-4">Save Changes</button> </div> </form> </div> </div> </div> <?php endif; ?> <?php require_once __DIR__ . '/partials/footer.php'; ?>