« Back to History
machine_wise_production.php
|
20261118_125741.php
Initial Domain Snapshot
Copy Code
<?php /* ============================================================================= Machine-wise Loom Production Report (Half-month, Karigar-wise grid) - Uses line-level dates from lines_json [{"karigar_id","meter","date"}] - Khata label shows khata_code (e.g., MST1) from loom_karigar_master - Karigar names from loom_karigar_master (fallback: employees/users) Scope: Page-local only. Multi-company aware. No global/base changes. ============================================================================= */ error_reporting(E_ALL); ini_set('display_errors', 1); /* [1] AUTH & PDO */ require __DIR__ . '/../modules/auth/auth.php'; require_login(); $u = auth_user(); $company_id = (int)$u['company_id']; $pdo = $GLOBALS['pdo'] ?? null; if (!$pdo) { require __DIR__ . '/../core/db.php'; } /* [2] HELPERS */ function h($s){ return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8'); } function half_month_range(int $y,int $m,int $half){ $start=sprintf('%04d-%02d-%02d',$y,$m,$half===1?1:16); $end=sprintf('%04d-%02d-%02d',$y,$m,$half===1?15:(int)date('t',strtotime("$y-$m-01"))); return [$start,$end]; } function date_list($s,$e){ $o=[];$t=strtotime($s);$E=strtotime($e); while($t<=$E){ $o[]=date('Y-m-d',$t); $t=strtotime('+1 day',$t);} return $o; } function norm_line_date($val,int $Y,int $M,$row_entry){ $s=is_string($val)||is_int($val)?trim((string)$val):''; if($s===''){ return $row_entry?:''; } if(preg_match('/^\d{4}-\d{2}-\d{2}$/',$s)) return $s; if(preg_match('/^\d{1,2}$/',$s)){ $d=max(1,min(31,(int)$s)); $last=(int)date('t',strtotime("$Y-$M-01")); $d=min($d,$last); return sprintf('%04d-%02d-%02d',$Y,$M,$d); } $t=strtotime($s); return $t?date('Y-m-d',$t):($row_entry?:''); } /* Machines (id, machine_no, khata_id?) */ function load_machines(PDO $pdo,int $co){ foreach ([ "SELECT id,machine_no,khata_id FROM machines WHERE company_id=? ORDER BY machine_no", "SELECT id,code AS machine_no,khata_id FROM machines WHERE company_id=? ORDER BY code", ] as $sql){ try{$st=$pdo->prepare($sql);$st->execute([$co]);$r=$st->fetchAll(PDO::FETCH_ASSOC); if($r) return $r;}catch(Throwable $e){} } try{ $st=$pdo->prepare("SELECT DISTINCT machine_id AS id, machine_id AS machine_no, NULL AS khata_id FROM loom_production_entry WHERE company_id=? ORDER BY machine_id"); $st->execute([$co]); return $st->fetchAll(PDO::FETCH_ASSOC); }catch(Throwable $e){return[];} } /* Khatas with code label from loom_karigar_master */ function load_khatas(PDO $pdo,int $co): array { try{ $st=$pdo->prepare("SELECT DISTINCT khata_id AS id, khata_code FROM loom_karigar_master WHERE company_id=? AND khata_id IS NOT NULL AND khata_code<>'' ORDER BY khata_id"); $st->execute([$co]); $rows = $st->fetchAll(PDO::FETCH_ASSOC); if ($rows) { foreach($rows as &$r){ $r['name']=$r['khata_code']; } return $rows; } }catch(Throwable $e){} foreach ([ "SELECT id, name FROM khatas WHERE company_id=? ORDER BY id", "SELECT id, name FROM khata WHERE company_id=? ORDER BY id", ] as $sql){ try{ $st=$pdo->prepare($sql); $st->execute([$co]); $r=$st->fetchAll(PDO::FETCH_ASSOC); if($r) return $r; }catch(Throwable $e){} } try{ $st=$pdo->prepare("SELECT DISTINCT khata_id AS id FROM loom_production_entry WHERE company_id=? AND khata_id IS NOT NULL ORDER BY khata_id"); $st->execute([$co]); $rows=$st->fetchAll(PDO::FETCH_ASSOC); if ($rows){ foreach($rows as &$r){ $r+=['name'=>"Khata ".$r['id']]; } return $rows; } }catch(Throwable $e){} return []; } /* Karigar names (prefer loom_karigar_master) */ function karigar_names(PDO $pdo,int $co,array $ids): array { $ids=array_values(array_unique(array_map('intval',$ids))); if(!$ids) return []; $in=implode(',',array_fill(0,count($ids),'?')); try{ $st=$pdo->prepare("SELECT id, karigar_name FROM loom_karigar_master WHERE company_id=? AND id IN ($in)"); $st->execute(array_merge([$co],$ids)); $m=[]; foreach($st as $r){ $m[(int)$r['id']] = (string)$r['karigar_name']; } if ($m) return $m; }catch(Throwable $e){} try{ $st=$pdo->prepare("SELECT id, name FROM employees WHERE company_id=? AND id IN ($in)"); $st->execute(array_merge([$co],$ids)); $m=[]; foreach($st as $r){ $m[(int)$r['id']] = (string)$r['name']; } if ($m) return $m; }catch(Throwable $e){} try{ $st=$pdo->prepare("SELECT id, name FROM users WHERE company_id=? AND id IN ($in)"); $st->execute(array_merge([$co],$ids)); $m=[]; foreach($st as $r){ $m[(int)$r['id']] = (string)$r['name']; } return $m; }catch(Throwable $e){ return []; } } /* [3] FILTERS + (optional) DEBUG FLAG */ $debug = isset($_GET['debug']) ? 1 : 0; $khatas = load_khatas($pdo,$company_id); $machines = load_machines($pdo,$company_id); $sel_khata = isset($_GET['khata_id']) ? (int)$_GET['khata_id'] : ( $khatas[0]['id'] ?? 0 ); $sel_machine = isset($_GET['machine_id']) ? (int)$_GET['machine_id'] : ( $machines[0]['id'] ?? 0 ); $sel_year = isset($_GET['year']) ? (int)$_GET['year'] : (int)date('Y'); $sel_month = isset($_GET['month']) ? (int)$_GET['month'] : (int)date('n'); $sel_half = isset($_GET['half']) ? (int)$_GET['half'] : 1; [$from_date,$to_date] = half_month_range($sel_year,$sel_month,$sel_half); $month_start = sprintf('%04d-%02d-01',$sel_year,$sel_month); $month_end = sprintf('%04d-%02d-%02d',$sel_year,$sel_month,(int)date('t',strtotime($month_start))); /* [4] READ & AGGREGATE (line-level date) */ $matrix=[]; $kar_ids=[]; $dbg=null; try{ $sql = "SELECT entry_date,khata_id,lines_json FROM loom_production_entry WHERE company_id=? AND machine_id=? AND entry_date BETWEEN ? AND ?"; $params = [$company_id,$sel_machine,$month_start,$month_end]; if ($sel_khata) { $sql .= " AND (khata_id=? OR khata_id IS NULL)"; $params[]=$sel_khata; } $sql .= " ORDER BY entry_date"; $st=$pdo->prepare($sql); $st->execute($params); while($r=$st->fetch(PDO::FETCH_ASSOC)){ $row_entry = $r['entry_date'] ?? ''; $arr = json_decode((string)$r['lines_json'], true); if (!is_array($arr)) continue; foreach($arr as $ln){ $kid = isset($ln['karigar_id']) ? (int)$ln['karigar_id'] : 0; $mtr = isset($ln['meter']) ? (float)$ln['meter'] : 0.0; $ld = norm_line_date($ln['date'] ?? '', $sel_year,$sel_month,$row_entry); if ($kid<=0 || $mtr<=0 || !$ld) continue; if ($ld < $from_date || $ld > $to_date) continue; $matrix[$ld][$kid] = ($matrix[$ld][$kid] ?? 0) + $mtr; $kar_ids[] = $kid; } } if ($debug){ $dbg = [ 'filters'=>compact('sel_khata','sel_machine','sel_year','sel_month','sel_half','from_date','to_date','month_start','month_end'), 'sql'=>$sql,'params'=>$params, 'unique_karigars'=>array_values(array_unique($kar_ids)), 'dates'=>['first'=>$from_date,'last'=>$to_date,'count'=>count(date_list($from_date,$to_date))] ]; } }catch(Throwable $e){ if ($debug){ $dbg = ['error'=>$e->getMessage()]; } } /* Build columns from DATA */ $kar_cols = array_values(array_unique($kar_ids)); sort($kar_cols); $kar_map = karigar_names($pdo,$company_id,$kar_cols); $dates = date_list($from_date,$to_date); /* [5] HTML */ ?> <!doctype html> <html> <head> <meta charset="utf-8"> <title>Machine-wise Loom Production (Half-month)</title> <meta name="viewport" content="width=device-width, initial-scale=1"> <style> :root{ --mm-primary:#34A853; --mm-bg:#F5FFF7; --mm-text:#333; --mm-sub:#5F6368; --mm-accent:#A7D8DE; --mm-hi:#FFF9C4; --card:#fff; --bd:#e6e6e6; } *{box-sizing:border-box} body{font-family:system-ui,Segoe UI,Roboto,Arial,sans-serif;background:var(--mm-bg);color:var(--mm-text);margin:0;padding:16px;} .wrap{max-width:1100px;margin:auto;} h1{margin:0 0 12px;font-size:22px;color:var(--mm-primary)} .card{background:var(--card);border:1px solid var(--bd);border-radius:14px;box-shadow:0 2px 10px rgba(0,0,0,.04);padding:12px;margin-bottom:14px;} /* Filters - responsive grid */ .filters{display:grid;grid-template-columns:repeat(7,minmax(120px,1fr));gap:10px;align-items:end} label{font-size:12px;color:var(--mm-sub);display:block;margin-bottom:4px} select,button,input[type=checkbox]{padding:10px 12px;border:1px solid var(--bd);border-radius:12px;font-size:14px;background:#fff} /* Button + spinner animation */ .btn{background:var(--mm-primary);color:#fff;border:none;border-radius:12px;cursor:pointer;position:relative;overflow:hidden;transition:transform .08s ease, box-shadow .2s} .btn:active{transform:scale(0.98)} .btn.loading{pointer-events:none;opacity:.9} .btn .spinner{display:none;width:16px;height:16px;border:2px solid #fff;border-right-color:transparent;border-radius:50%;position:absolute;right:12px;top:50%;transform:translateY(-50%);animation:spin .8s linear infinite} .btn.loading .spinner{display:inline-block} @keyframes spin{to{transform:translateY(-50%) rotate(360deg)}} .help{font-size:12px;color:var(--mm-sub);margin-top:6px} .pill{display:inline-block;padding:2px 8px;border-radius:999px;background:#e8f5ee;color:var(--mm-primary);font-size:12px} /* Table (responsive with horizontal scroll) */ .tbl-wrap{overflow-x:auto;border:1px solid var(--bd);border-radius:12px} table{width:100%;border-collapse:collapse;margin-top:10px;font-size:14px;min-width:720px} th,td{border:1px solid var(--bd);padding:8px 10px;text-align:right} th.date,td.date{text-align:left;white-space:nowrap;position:sticky;left:0;background:#fff;z-index:2} thead th{background:var(--mm-accent);font-weight:600} tbody tr:nth-child(odd){background:#fafafa} .total{background:var(--mm-hi);font-weight:600} /* Mobile tweaks */ @media (max-width: 900px){ .filters{grid-template-columns:repeat(2,1fr)} table{font-size:13px;min-width:600px} .btn{padding-right:40px} } @media (max-width: 420px){ table{font-size:12px;min-width:540px} } </style> </head> <body> <div class="wrap"> <h1>Machine-wise Loom Production </h1> <div class="card"> <form method="get" class="filters" id="filtersForm"> <div> <label>Khata</label> <select name="khata_id" id="khata_id"> <?php foreach($khatas as $k): $label = $k['khata_code'] ?? $k['name'] ?? ('Khata '.$k['id']); ?> <option value="<?= (int)$k['id'] ?>" <?= $sel_khata==(int)$k['id']?'selected':'' ?>><?= h($label) ?></option> <?php endforeach; ?> </select> </div> <div> <label>Machine</label> <select name="machine_id" id="machine_id"> <?php foreach($machines as $m): ?> <option value="<?= (int)$m['id'] ?>" data-khata="<?= h($m['khata_id'] ?? '') ?>" <?= $sel_machine==(int)$m['id']?'selected':'' ?>> <?= 'MC '.h($m['machine_no']) ?> </option> <?php endforeach; ?> </select> </div> <div> <label>Month</label> <select name="month"><?php $mn=[1=>"Jan",2=>"Feb",3=>"Mar",4=>"Apr",5=>"May",6=>"Jun",7=>"Jul",8=>"Aug",9=>"Sep",10=>"Oct",11=>"Nov",12=>"Dec"]; foreach($mn as $i=>$nm): ?> <option value="<?= $i ?>" <?= $sel_month==$i?'selected':'' ?>><?= $nm ?></option><?php endforeach; ?> </select> </div> <div> <label>Half</label> <select name="half"> <option value="1" <?= $sel_half==1?'selected':'' ?>>1–15</option> <option value="2" <?= $sel_half==2?'selected':'' ?>>16–EOM</option> </select> </div> <div> <label>Year</label> <select name="year"><?php foreach([date('Y')-1,date('Y'),date('Y')+1] as $yr): ?> <option value="<?= (int)$yr ?>" <?= $sel_year==$yr?'selected':'' ?>><?= (int)$yr ?></option><?php endforeach; ?> </select> </div> <div style="display:flex;align-items:center;gap:8px"> <label><input type="checkbox" name="debug" value="1" <?= $debug?'checked':'' ?> /> Show Debug</label> </div> <div> <button type="submit" class="btn" id="showBtn">Show Report <span class="spinner" aria-hidden="true"></span></button> <div class="help">Range: <span class="pill"><?= h($from_date) ?> → <?= h($to_date) ?></span> (line-level dates)</div> </div> </form> </div> <div class="card tbl-wrap"> <?php $colTotals = array_fill_keys($kar_cols, 0.0); $grand = 0.0; ?> <table> <thead> <tr> <th class="date">Date</th> <?php foreach($kar_cols as $kid): ?> <th><?= h($kar_map[$kid] ?? ('Karigar '.$kid)) ?></th> <?php endforeach; ?> <th>Total</th> </tr> </thead> <tbody> <?php foreach($dates as $d): ?> <?php $rowTotal=0.0; ?> <tr> <td class="date"><?= date('d-M', strtotime($d)) ?></td> <?php foreach($kar_cols as $kid): $val=isset($matrix[$d][$kid])?(float)$matrix[$d][$kid]:0.0; $rowTotal+=$val; $colTotals[$kid]+=$val; $grand+=$val; ?> <td><?= $val>0 ? number_format($val,0) : '' ?></td> <?php endforeach; ?> <td class="total"><?= $rowTotal>0?number_format($rowTotal,0):'' ?></td> </tr> <?php endforeach; ?> <tr class="total"> <td class="date">Total</td> <?php foreach($kar_cols as $kid): ?> <td><?= $colTotals[$kid]>0?number_format($colTotals[$kid],0):'' ?></td> <?php endforeach; ?> <td><?= $grand>0?number_format($grand,0):'' ?></td> </tr> </tbody> </table> </div> <?php if($debug): ?> <!-- ============ DEBUG SECTION START (keep separate; safe to delete later) ============ --> <div class="card" style="border-style:dashed"> <h3 style="margin:0 0 8px 0;color:#5F6368">Debug</h3> <pre style="white-space:pre-wrap;background:#fafafa;border:1px dashed #e6e6e6;padding:10px;border-radius:10px"> <?= h(json_encode($dbg, JSON_PRETTY_PRINT|JSON_UNESCAPED_SLASHES)) ?> </pre> <div style="font-size:12px;color:#5F6368">Tips: यदि कॉलम खाली हों तो देखें: • filters/sql/params सही हैं? • unique_karigars सूची में IDs? • lines_json में date चुने हुए half में है?</div> </div> <!-- ============ DEBUG SECTION END ============ --> <?php endif; ?> </div> <script> /* Machine list को Khata के हिसाब से फ़िल्टर (यदि data-khata मौजूद) */ (function(){ const selKhata=document.getElementById('khata_id'); const selMach=document.getElementById('machine_id'); if(!selKhata||!selMach) return; function applyFilter(){ const k=selKhata.value; let first=null; [...selMach.options].forEach(o=>{ const ok=!o.dataset.khata||o.dataset.khata===''||o.dataset.khata===k; o.hidden=!ok; if(ok && !first) first=o; }); if(selMach.selectedOptions[0]?.hidden && first){ first.selected=true; } } selKhata.addEventListener('change',applyFilter); applyFilter(); })(); /* Show Report button loading animation */ (function(){ const form = document.getElementById('filtersForm'); const btn = document.getElementById('showBtn'); if(!form || !btn) return; form.addEventListener('submit', function(){ btn.classList.add('loading'); const els = form.querySelectorAll('select,button,input'); els.forEach(el=>{ if(el!==btn) el.disabled=true; }); }); })(); </script> </body> </html>