« Back to History
material_out_denier_report.php
|
20261118_125741.php
Initial Domain Snapshot
Copy Code
<?php /* ============================================================ Report: Material OUT – Denier & Color Summary Type : REPORT PAGE (STRICT) Tables: yarn_out / tfo_out / tpm_out / zari_out ============================================================ */ /* ---------------- AUTH / BOOTSTRAP ---------------- */ require_once __DIR__ . '/modules/auth/page_acl.php'; $ctx = page_require_access('material_out_denier_report'); $pdo = $ctx['pdo']; $company_id = (int)$ctx['company_id']; /* ---------------- INPUTS ---------------- */ $from = $_GET['from'] ?? date('Y-m-01'); $to = $_GET['to'] ?? date('Y-m-d'); $stock_type = $_GET['stock_type'] ?? 'yarn'; $assigns = $_GET['assign'] ?? []; $deniers = $_GET['denier'] ?? []; $colors = $_GET['color'] ?? []; $allowed = ['yarn','tfo','tpm','zari']; if (!in_array($stock_type,$allowed,true)) { $stock_type = 'yarn'; } $table = $stock_type.'_out'; /* ---------------- HELPERS ---------------- */ function h($v){ return htmlspecialchars((string)$v,ENT_QUOTES,'UTF-8'); } function bindIn(array $vals, string $prefix, array &$bind){ $out=[]; foreach($vals as $i=>$v){ $k=":$prefix$i"; $out[]=$k; $bind[$k]=$v; } return $out ? '('.implode(',',$out).')' : ''; } /* ---------------- BASE WHERE ---------------- */ $where = [ 'company_id = :cid', 'txn_date BETWEEN :d1 AND :d2' ]; $bind = [ ':cid'=>$company_id, ':d1'=>$from, ':d2'=>$to ]; if ($assigns) { $where[] = 'assign_to IN '.bindIn($assigns,'a',$bind); } if ($deniers) { $where[] = 'denier IN '.bindIn($deniers,'d',$bind); } if ($colors) { $where[] = 'color IN '.bindIn($colors,'c',$bind); } $where_sql = implode(' AND ',$where); /* ============================================================ PRINT VIEW (BROWSER) ============================================================ */ if (isset($_GET['print_view'])) { $sql = " SELECT denier, color, SUM(weight) total_weight, SUM(boxes) total_boxes FROM `$table` WHERE $where_sql GROUP BY denier, color ORDER BY denier, color "; $st = $pdo->prepare($sql); $st->execute($bind); ob_start(); ?> <!doctype html> <html> <head> <meta charset="utf-8"> <style> body{font-family:Arial;font-size:12px} table{width:100%;border-collapse:collapse} th,td{border:1px solid #000;padding:6px} th{background:#eee;text-align:center} </style> </head> <body> <h2 style="text-align:center;">Material OUT Report (<?= strtoupper($stock_type) ?>)</h2> <div style="text-align:center;"><?=h($from)?> — <?=h($to)?></div> <table> <tr> <th>Denier</th> <th>Color</th> <th>Weight</th> <th>Boxes</th> </tr> <?php foreach($st as $r): ?> <tr> <td><?=h($r['denier'])?></td> <td><?=h($r['color'])?></td> <td style="text-align:right"><?=number_format($r['total_weight'],3)?></td> <td style="text-align:right"><?=number_format($r['total_boxes'],3)?></td> </tr> <?php endforeach; ?> </table> <script>window.print()</script> </body> </html> <?php echo ob_get_clean(); exit; } /* ============================================================ CSV EXPORT ============================================================ */ if (isset($_GET['export']) && $_GET['export']==='csv') { $sql = " SELECT denier, color, SUM(weight) total_weight, SUM(boxes) total_boxes FROM `$table` WHERE $where_sql GROUP BY denier, color ORDER BY denier, color "; $st = $pdo->prepare($sql); $st->execute($bind); header('Content-Type: text/csv'); header('Content-Disposition: attachment; filename=material_out_'.$stock_type.'.csv'); $out = fopen('php://output','w'); fputcsv($out,['Denier','Color','Weight','Boxes']); foreach($st as $r){ fputcsv($out,[ $r['denier'], $r['color'], $r['total_weight'], $r['total_boxes'] ]); } fclose($out); exit; } /* ============================================================ SCREEN DATA ============================================================ */ /* --- Denier-wise --- */ $sql_denier = " SELECT denier, SUM(weight) total_weight, SUM(boxes) total_boxes FROM `$table` WHERE $where_sql GROUP BY denier ORDER BY denier "; $st_den = $pdo->prepare($sql_denier); $st_den->execute($bind); $denier_rows = $st_den->fetchAll(); /* --- Denier + Color --- */ $sql_dc = " SELECT denier, color, SUM(weight) total_weight, SUM(boxes) total_boxes FROM `$table` WHERE $where_sql GROUP BY denier, color ORDER BY denier, color "; $st_dc = $pdo->prepare($sql_dc); $st_dc->execute($bind); $dc_rows = $st_dc->fetchAll(); /* --- Dropdown data --- */ $assign_opts = $pdo->query("SELECT DISTINCT assign_to v FROM `$table` WHERE company_id=$company_id AND assign_to<>'' ORDER BY v")->fetchAll(PDO::FETCH_COLUMN); $denier_opts = $pdo->query("SELECT DISTINCT denier v FROM `$table` WHERE company_id=$company_id AND denier<>'' ORDER BY v")->fetchAll(PDO::FETCH_COLUMN); $color_opts = $pdo->query("SELECT DISTINCT color v FROM `$table` WHERE company_id=$company_id AND color<>'' ORDER BY v")->fetchAll(PDO::FETCH_COLUMN); /* ============================================================ HTML ============================================================ */ require_once __DIR__ . '/partials/header.php'; ?> <form class="card report-toolbar no-print" method="get"> <div class="report-toolbar-row report-toolbar-filters"> <label>From <input type="date" name="from" value="<?=h($from)?>"> </label> <label>To <input type="date" name="to" value="<?=h($to)?>"> </label> <label>Material <select name="stock_type"> <?php foreach($allowed as $m): ?> <option value="<?=$m?>" <?=$m==$stock_type?'selected':''?>><?=strtoupper($m)?></option> <?php endforeach; ?> </select> </label> <label>Assign <select name="assign[]" multiple> <?php foreach($assign_opts as $v): ?> <option value="<?=h($v)?>" <?=in_array($v,$assigns)?'selected':''?>><?=h($v)?></option> <?php endforeach; ?> </select> </label> <label>Denier <select name="denier[]" multiple> <?php foreach($denier_opts as $v): ?> <option value="<?=h($v)?>" <?=in_array($v,$deniers)?'selected':''?>><?=h($v)?></option> <?php endforeach; ?> </select> </label> <label>Color <select name="color[]" multiple> <?php foreach($color_opts as $v): ?> <option value="<?=h($v)?>" <?=in_array($v,$colors)?'selected':''?>><?=h($v)?></option> <?php endforeach; ?> </select> </label> <button class="btn">Load</button> <a class="btn" target="_blank" href="?<?=h(http_build_query(array_merge($_GET,['print_view'=>1])))?>"> Print </a> </div> <div class="report-toolbar-row report-toolbar-export"> <button class="btn" name="export" value="csv">CSV</button> </div> </form> <div class="report-body"> <div class="card"> <h3>Denier-wise Total</h3> <div class="tablewrap"> <table class="table"> <tr><th>Denier</th><th>Weight</th><th>Boxes</th></tr> <?php foreach($denier_rows as $r): ?> <tr> <td><?=h($r['denier'])?></td> <td class="right"><?=number_format($r['total_weight'],3)?></td> <td class="right"><?=number_format($r['total_boxes'],3)?></td> </tr> <?php endforeach; ?> </table> </div> </div> <div class="card"> <h3>Denier + Color-wise Total</h3> <div class="tablewrap"> <table class="table"> <tr><th>Denier</th><th>Color</th><th>Weight</th><th>Boxes</th></tr> <?php foreach($dc_rows as $r): ?> <tr> <td><?=h($r['denier'])?></td> <td><?=h($r['color'])?></td> <td class="right"><?=number_format($r['total_weight'],3)?></td> <td class="right"><?=number_format($r['total_boxes'],3)?></td> </tr> <?php endforeach; ?> </table> </div> </div> </div> <?php require_once __DIR__ . '/partials/footer.php'; ?>