« Back to History
contractor_employees.php
|
20260722_120325.php
Initial Domain Snapshot
Copy Code
<?php error_reporting(E_ALL); ini_set('display_errors', 1); require_once __DIR__ . '/../modules/auth/page_acl.php'; $ctx = page_require_access('contractor_payment'); $pdo = $ctx['pdo']; $cid = (int)$ctx['company_id']; $contractorId = (int)($_GET['contractor_id'] ?? 0); if (!$contractorId) { echo json_encode([]); exit; } /* IMPORTANT MAPPING: contractor_info.employee_id ↓ contractor_employee.contractor_id */ $st = $pdo->prepare(" SELECT ce.id, ce.employee_name, ce.account_no, ce.ifsc_code AS ifsc FROM contractor_employee ce WHERE ce.cid = :cid AND ce.contractor_id = :contractor_id ORDER BY ce.employee_name "); $st->execute([ ':cid' => $cid, ':contractor_id' => $contractorId ]); echo json_encode($st->fetchAll(PDO::FETCH_ASSOC));