« Back to History
missing_gray_id.php
|
20261118_125741.php
Initial Domain Snapshot
Copy Code
<?php require_once __DIR__ . '/modules/auth/page_acl.php'; // Access control check $ctx = page_require_access('missing_gray_id'); $pdo = $ctx['pdo']; $company_id = (int)$ctx['company_id']; /* ===== FILTER LOGIC ===== */ $from_date = $_GET['from_date'] ?? date('Y-m-01'); $to_date = $_GET['to_date'] ?? date('Y-m-d'); // Default first load par Date aur Party wise grouped summary dikhane ke liye $is_first_load = empty($_GET); $group_date = isset($_GET['group_date']) ? 1 : ($is_first_load ? 1 : 0); $group_party = isset($_GET['group_party']) ? 1 : ($is_first_load ? 1 : 0); $group_quality = isset($_GET['group_quality']) ? 1 : 0; /* ===== QUERY BUILDER ===== */ $selects = []; $groups = []; $orders = []; if ($group_date) { $selects[] = "v.send_date"; $groups[] = "v.send_date"; $orders[] = "v.send_date DESC"; } if ($group_party) { $selects[] = "v.party_name"; $groups[] = "v.party_name"; $orders[] = "v.party_name ASC"; } if ($group_quality) { $selects[] = "q.quality_name"; $groups[] = "v.quality"; $orders[] = "q.quality_name ASC"; } $is_summary = !empty($groups); $params = [':cid' => $company_id, ':f' => $from_date, ':t' => $to_date]; // Condition for missing Gray IDs $where_sql = "v.company_id = :cid AND v.send_date BETWEEN :f AND :t AND (v.grey_id IS NULL OR v.grey_id = '' OR v.grey_id = 0) AND (v.mgray_detail IS NULL OR v.mgray_detail = '')"; if ($is_summary) { // Summary Mode: GROUP_CONCAT se saare challan numbers ek sath jod diye hain $select_sql = implode(', ', $selects) . ", GROUP_CONCAT(DISTINCT v.challan_no ORDER BY v.challan_no SEPARATOR ', ') as all_challans, SUM(v.pcs) as total_pcs, COUNT(DISTINCT v.challan_no) as total_challans"; $group_sql = "GROUP BY " . implode(', ', $groups); $order_sql = "ORDER BY " . implode(', ', $orders); } else { // Detail Mode $select_sql = "v.send_date, v.challan_no, v.party_name, q.quality_name, v.pcs as total_pcs, v.remark"; $group_sql = ""; $order_sql = "ORDER BY v.send_date DESC, v.id DESC"; } $sql = "SELECT $select_sql FROM va_send_entry v LEFT JOIN fabric_quality_master q ON q.id = v.quality WHERE $where_sql $group_sql $order_sql"; $stmt = $pdo->prepare($sql); $stmt->execute($params); $records = $stmt->fetchAll(PDO::FETCH_ASSOC); $grand_total_pcs = 0; $grand_total_challans = 0; require_once __DIR__ . '/partials/header.php'; ?> <div class="container-fluid mt-4"> <div class="card p-3 mb-3 border-0 shadow-sm bg-light"> <form method="get" class="row g-3 align-items-end"> <div class="col-md-2"> <label class="small fw-bold text-muted">From Date</label> <input type="date" name="from_date" value="<?= $from_date ?>" class="form-control form-control-sm"> </div> <div class="col-md-2"> <label class="small fw-bold text-muted">To Date</label> <input type="date" name="to_date" value="<?= $to_date ?>" class="form-control form-control-sm"> </div> <div class="col-md-5"> <label class="small fw-bold text-muted d-block mb-2">Summary Grouping (Select Multiple)</label> <div class="form-check form-check-inline"> <input class="form-check-input" type="checkbox" name="group_date" id="group_date" value="1" <?= $group_date ? 'checked' : '' ?>> <label class="form-check-label fw-bold text-primary" for="group_date">Date Wise</label> </div> <div class="form-check form-check-inline"> <input class="form-check-input" type="checkbox" name="group_party" id="group_party" value="1" <?= $group_party ? 'checked' : '' ?>> <label class="form-check-label fw-bold text-success" for="group_party">Party Wise</label> </div> <div class="form-check form-check-inline"> <input class="form-check-input" type="checkbox" name="group_quality" id="group_quality" value="1" <?= $group_quality ? 'checked' : '' ?>> <label class="form-check-label fw-bold text-danger" for="group_quality">Quality Wise</label> </div> </div> <div class="col-md-3 d-flex gap-2"> <button type="submit" class="btn btn-danger btn-sm w-100 fw-bold">VIEW MISSING GRAY ENTRIES</button> <a href="missing_gray_id.php" class="btn btn-outline-secondary btn-sm fw-bold">RESET</a> </div> </form> </div> <div class="card p-3 border-0 shadow-sm"> <div class="d-flex justify-content-between align-items-center mb-3"> <h5 class="m-0 text-danger fw-bold"> <i class="bi bi-exclamation-triangle-fill me-2"></i> <?= $is_summary ? 'Missing Gray ID - Summary Report' : 'Missing Gray ID - Detailed Report' ?> </h5> <span class="badge bg-secondary p-2">Period: <?= date('d-m-Y', strtotime($from_date)) ?> to <?= date('d-m-Y', strtotime($to_date)) ?></span> </div> <div class="table-responsive"> <table class="table table-bordered table-hover align-middle"> <thead class="table-dark"> <tr> <th style="width: 50px;" class="text-center">#</th> <?php if ($group_date || !$is_summary): ?> <th>Date</th> <?php endif; ?> <th>Challan No</th> <?php if ($group_party || !$is_summary): ?> <th>Party Name</th> <?php endif; ?> <?php if ($group_quality || !$is_summary): ?> <th>Quality</th> <?php endif; ?> <th class="text-end" style="width: 150px;">Pending PCS</th> <?php if (!$is_summary): ?> <th>Remark</th> <?php endif; ?> </tr> </thead> <tbody> <?php if (empty($records)): ?> <tr> <td colspan="10" class="text-center text-success fw-bold py-4"> <i class="bi bi-check-circle-fill me-1"></i> All VA Send entries are perfectly linked with Gray IDs! </td> </tr> <?php else: ?> <?php foreach ($records as $index => $row): $pcs = (float)$row['total_pcs']; $grand_total_pcs += $pcs; if ($is_summary) { $grand_total_challans += (int)$row['total_challans']; } ?> <tr> <td class="text-center fw-bold text-muted"><?= $index + 1 ?></td> <?php if ($group_date || !$is_summary): ?> <td class="fw-bold"><?= date('d-m-Y', strtotime($row['send_date'])) ?></td> <?php endif; ?> <td class="text-primary fw-bold"> <?php if (!$is_summary): ?> <span class="badge bg-danger-subtle text-danger border border-danger-subtle px-2 py-1"> <?= htmlspecialchars($row['challan_no']) ?> </span> <?php else: ?> <div class="small text-dark fw-normal"><?= htmlspecialchars($row['all_challans']) ?></div> <span class="badge bg-secondary mt-1">Total: <?= $row['total_challans'] ?></span> <?php endif; ?> </td> <?php if ($group_party || !$is_summary): ?> <td class="text-success fw-bold"><?= htmlspecialchars($row['party_name']) ?></td> <?php endif; ?> <?php if ($group_quality || !$is_summary): ?> <td class="text-danger fw-bold"><?= htmlspecialchars($row['quality_name'] ?? 'Unknown Quality') ?></td> <?php endif; ?> <td class="text-end fw-bold text-danger" style="font-size: 1.1em;"> <?= sprintf('%g', $pcs) ?> </td> <?php if (!$is_summary): ?> <td class="small text-muted"><?= htmlspecialchars($row['remark'] ?? '') ?></td> <?php endif; ?> </tr> <?php endforeach; ?> <?php endif; ?> </tbody> <?php if (!empty($records)): ?> <tfoot class="table-light"> <tr> <?php $colspan = 1; if ($group_date || !$is_summary) $colspan++; ?> <td colspan="<?= $colspan ?>" class="text-end fw-bold fs-5 text-dark">GRAND TOTAL:</td> <td class="text-start fw-bold text-dark fs-6"> <?php if ($is_summary): ?> Total Unique Challans: <?= $grand_total_challans ?> <?php endif; ?> </td> <?php $remaining_colspan = 0; if ($group_party || !$is_summary) $remaining_colspan++; if ($group_quality || !$is_summary) $remaining_colspan++; if ($remaining_colspan > 0): ?> <td colspan="<?= $remaining_colspan ?>"></td> <?php endif; ?> <td class="text-end fw-bold fs-5 text-danger"><?= sprintf('%g', $grand_total_pcs) ?></td> <?php if (!$is_summary): ?> <td></td> <?php endif; ?> </tr> </tfoot> <?php endif; ?> </table> </div> </div> </div> <?php require_once __DIR__ . '/partials/footer.php'; ?>