« Back to History
contractor_payment_detail.php
|
20260921_175631.php
Initial Domain Snapshot
Copy Code
<?php require_once __DIR__ . '/modules/auth/page_acl.php'; $ctx = page_require_access('contractor_payment_detail'); $pdo = $ctx['pdo']; $company_id = (int)$ctx['company_id']; function h($s){ return htmlspecialchars((string)$s, ENT_QUOTES); } /* ================= FILTERS ================= */ $contractor_id = isset($_GET['contractor_id']) ? (int)$_GET['contractor_id'] : 0; $month = $_GET['month'] ?? ''; $from_date = $_GET['from_date'] ?? ''; $to_date = $_GET['to_date'] ?? ''; /* ================= CONTRACTOR LIST ================= */ $cq = $pdo->prepare(" SELECT DISTINCT contractor_id FROM contractor_payment WHERE cid = :cid ORDER BY contractor_id "); $cq->execute([':cid'=>$company_id]); $contractor_list = $cq->fetchAll(PDO::FETCH_COLUMN); /* ================= BUILD QUERY ================= */ $sql = " SELECT cp.contractor_id, ce.employee_name, ce.department, SUM(cp.amount) as total_paid FROM contractor_payment cp JOIN contractor_employee ce ON cp.contractor_employee_id = ce.id AND ce.cid = :cid WHERE cp.cid = :cid "; $params = [':cid'=>$company_id]; /* Contractor filter */ if($contractor_id > 0){ $sql .= " AND cp.contractor_id = :contractor_id "; $params[':contractor_id'] = $contractor_id; } /* Month filter (YYYY-MM) */ if($month){ $sql .= " AND DATE_FORMAT(cp.payment_date,'%Y-%m') = :month "; $params[':month'] = $month; } /* Period filter */ if($from_date && $to_date){ $sql .= " AND cp.payment_date BETWEEN :from AND :to "; $params[':from'] = $from_date; $params[':to'] = $to_date; } $sql .= " GROUP BY cp.contractor_id, cp.contractor_employee_id ORDER BY cp.contractor_id, ce.employee_name "; $stmt = $pdo->prepare($sql); $stmt->execute($params); $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); /* ================= ORGANIZE DATA ================= */ $data = []; foreach($rows as $r){ $data[$r['contractor_id']][] = $r; } ?> <?php require_once __DIR__ . '/partials/header.php'; ?> <div class="container mt-4"> <div class="card shadow-sm"> <div class="card-header bg-primary text-white"> <h5 class="mb-0">Contractor Payment Detail</h5> </div> <div class="card-body"> <!-- FILTER SECTION --> <form method="get" class="row g-3 mb-4"> <div class="col-md-3"> <select name="contractor_id" class="form-select"> <option value="0">All Contractors</option> <?php foreach($contractor_list as $cid): ?> <option value="<?= $cid ?>" <?= $contractor_id==$cid?'selected':'' ?>> Contractor ID <?= h($cid) ?> </option> <?php endforeach; ?> </select> </div> <div class="col-md-3"> <input type="month" name="month" value="<?= h($month) ?>" class="form-control"> </div> <div class="col-md-2"> <input type="date" name="from_date" value="<?= h($from_date) ?>" class="form-control"> </div> <div class="col-md-2"> <input type="date" name="to_date" value="<?= h($to_date) ?>" class="form-control"> </div> <div class="col-md-2"> <button class="btn btn-primary w-100">Filter</button> </div> </form> <?php if(empty($data)): ?> <div class="alert alert-warning">No Payment Found</div> <?php else: ?> <?php foreach($data as $cid => $employees): ?> <div class="mb-4"> <h5 class="border-bottom pb-2"> Contractor ID: <?= h($cid) ?> </h5> <table class="table table-bordered table-striped"> <thead class="table-light"> <tr> <th>Employee</th> <th>Department</th> <th class="text-end">Total Amount</th> </tr> </thead> <tbody> <?php $grand = 0; foreach($employees as $emp): $grand += $emp['total_paid']; ?> <tr> <td><?= h($emp['employee_name']) ?></td> <td><?= h($emp['department']) ?></td> <td class="text-end"><?= number_format($emp['total_paid'],2) ?></td> </tr> <?php endforeach; ?> <tr class="fw-bold table-secondary"> <td colspan="2" class="text-end">Contractor Total</td> <td class="text-end"><?= number_format($grand,2) ?></td> </tr> </tbody> </table> </div> <?php endforeach; ?> <?php endif; ?> </div> </div> </div> <?php require_once __DIR__ . '/partials/footer.php'; ?>