« Back to History
loom_salary.php
|
20260921_175631.php
Initial Domain Snapshot
Copy Code
<?php /* ============================================================================ File: /erp/loom_salary.php Title: Loom Salary (mode switch: production_entry / loom_production_entry) ============================================================================ */ header('X-Frame-Options: SAMEORIGIN'); error_reporting(E_ALL); ini_set('display_errors',1); /* ERP AUTH SYSTEM */ require_once __DIR__ . '/modules/auth/page_acl.php'; $ctx = page_require_access('loom_salary'); /* STANDARD VARIABLES */ $pdo = $ctx['pdo']; $company_id = (int)$ctx['company_id']; $u = $ctx['user']; /* 2. Provide local variables used by the page (header may set $ctx; fallback to auth_user()) */ $user_id = (int)($u['id'] ?? 0); $pdo = $ctx['pdo'] ?? ($GLOBALS['pdo'] ?? null); if (!$pdo) { require __DIR__ . '/core/db.php'; $pdo = $GLOBALS['pdo'] ?? $pdo; } /* [0a] Composer autoload (for Dompdf) — page local */ $PDF_AVAILABLE = false; $dompdf_autoloaders = [ __DIR__ . '/lib/dompdf/autoload.inc.php', __DIR__ . '/vendor/autoload.php', ]; foreach ($dompdf_autoloaders as $autoload) { if (is_file($autoload)) { require_once $autoload; if (class_exists(\Dompdf\Dompdf::class)) { $PDF_AVAILABLE = true; break; } } } /* [1] Helpers */ function h($s){ return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8'); } function gv($k,$d=null){ return isset($_GET[$k])?trim((string)$_GET[$k]):$d; } function pv($k,$d=null){ return isset($_POST[$k])?trim((string)$_POST[$k]):$d; } function safe_json($s){ $a=json_decode($s,true); return is_array($a)?$a:[]; } function yrmo_half_range(int $y,int $m,string $half): array { $start = sprintf('%04d-%02d-01',$y,$m); $end = date('Y-m-t', strtotime($start)); if($half==='2'){ $start = sprintf('%04d-%02d-16',$y,$m); } if($half==='1'){ $end = sprintf('%04d-%02d-15',$y,$m); } return [$start,$end]; } function label_for_period(int $y,int $m,string $half,string $from,string $to): string { if ($half==='F') return 'FULL '.date('M', mktime(0,0,0,$m,1,$y)).' '.$y; if ($half==='1') return '1-15 '.date('M', mktime(0,0,0,$m,1,$y)).' '.$y; if ($half==='2') return '16-END '.date('M', mktime(0,0,0,$m,1,$y)).' '.$y; return $from.' to '.$to; } function fmt2($value): string { $number = (float)$value; $formatted = number_format($number, 2, '.', ''); $formatted = rtrim(rtrim($formatted, '0'), '.'); return $formatted === '-0' ? '0' : $formatted; } function fmt2_blank_zero($value): string { $number = (float)$value; return abs($number) < 0.00001 ? '' : fmt2($number); } function _norm_date($s){ // '2025-08-04' or '04-08-2025' → '2025-08-04' $s = trim((string)$s); if($s==='') return null; if (preg_match('/^\d{4}-\d{2}-\d{2}$/',$s)) return $s; if (preg_match('/^(\d{1,2})[\/\-](\d{1,2})[\/\-](\d{4})$/',$s,$m)) return sprintf('%04d-%02d-%02d',$m[3],$m[2],$m[1]); $ts = strtotime($s); return $ts ? date('Y-m-d',$ts) : null; } /* Ensure master_salary_snapshots table exists with report_type */ $snapshot_ddl = <<<SQL CREATE TABLE IF NOT EXISTS master_salary_snapshots ( id INT AUTO_INCREMENT PRIMARY KEY, company_id BIGINT UNSIGNED NOT NULL, salary_year INT NOT NULL, salary_month INT NOT NULL, period VARCHAR(20) NOT NULL, report_type VARCHAR(50) NOT NULL, report_html LONGTEXT NOT NULL, created_by BIGINT UNSIGNED NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, UNIQUE KEY unique_report (company_id, salary_year, salary_month, period, report_type) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; SQL; $pdo->exec($snapshot_ddl); /* feature-flag (page-local): queue adjust read */ $FF_USE_QUEUE_ADJ = true; /* [2] Filters (GET) */ $year = (int)gv('year', date('Y')); $month = (int)gv('month', date('n')); $half = gv('half','F'); // default full month [$date_from,$date_to] = yrmo_half_range($year,$month,$half); $khata_id = (int)gv('khata_id', 0); $machine_id= (int)gv('machine_id', 0); $period_label = label_for_period($year,$month,$half,$date_from,$date_to); /* Mode switch: machine-wise (production_entry) OR taka-wise (loom_production_entry) */ $mode = gv('mode','machine'); $mode = in_array($mode,['machine','taka'],true) ? $mode : 'machine'; $src_table = ($mode === 'taka') ? 'loom_production_entry' : 'production_entry'; /* Handle Save Snapshot Action with report_type = 'Loom Karigar' */ if (($_POST['action'] ?? '') === 'save_snapshot') { $report_html = $_POST['report_html'] ?? ''; $raw_half = $_POST['half'] ?? $half; // Map period code to match Master Salary Report format ('Monthly', 'H1', 'H2') $snapshot_period = 'Monthly'; if ($raw_half === '1') { $snapshot_period = 'H1'; } elseif ($raw_half === '2') { $snapshot_period = 'H2'; } $report_type = 'Loom Karigar'; if (!empty($report_html)) { try { $stmt = $pdo->prepare(" INSERT INTO master_salary_snapshots (company_id, salary_year, salary_month, period, report_type, report_html, created_by) VALUES (?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE report_html = VALUES(report_html), created_by = VALUES(created_by), created_at = NOW() "); $stmt->execute([$company_id, $year, $month, $snapshot_period, $report_type, $report_html, $user_id]); header("Location: loom_salary.php?mode={$mode}&year={$year}&month={$month}&half={$raw_half}&khata_id={$khata_id}&machine_id={$machine_id}&snapshot_saved=1"); exit; } catch (Throwable $e) { http_response_code(500); exit("Error saving snapshot: " . htmlspecialchars($e->getMessage())); } } } /* [3] Company name (for header) */ $company_name = "Company #$company_id"; try{ $st = $pdo->prepare("SELECT name FROM companies WHERE id=?"); $st->execute([$company_id]); $nm = $st->fetchColumn(); if($nm){ $company_name = $nm; } }catch(Exception $e){} /* [4] Masters */ $QUALS=[]; $QUAL_RATE=[]; $q = $pdo->prepare("SELECT quality_id AS id, quality_name AS name, rate FROM quality_rates WHERE company_id=? ORDER BY quality_name"); $q->execute([$company_id]); foreach($q as $r){ $id=(int)$r['id']; $QUALS[$id]=$r['name']; $QUAL_RATE[$id]=(float)$r['rate']; } $KAR_NAME=[]; $KAR_ENTRY=[]; $KAR_KHATA_CODE=[]; $KAR_KHATA_ID=[]; $st=$pdo->prepare("SELECT id, karigar_name, entry_name, khata_code, khata_id FROM loom_karigar_master WHERE company_id=? ORDER BY karigar_name"); $st->execute([$company_id]); foreach($st as $r){ $id=(int)$r['id']; $KAR_NAME[$id] = $r['karigar_name'] ?: ("Karigar #$id"); $KAR_ENTRY[$id] = $r['entry_name'] ?? ''; $KAR_KHATA_CODE[$id] = $r['khata_code'] ?? ''; $KAR_KHATA_ID[$id] = (int)($r['khata_id'] ?? 0); } /* ================= MACHINES MASTER ================= */ $MACH_NAME = []; try { $st2 = $pdo->prepare("SELECT id, machine_code FROM machines WHERE company_id=? ORDER BY id"); $st2->execute([$company_id]); foreach($st2 as $r){ $MACH_NAME[(int)$r['id']] = $r['machine_code'] ?: ('MC '.$r['id']); } } catch(Exception $e){} /* ================= MACHINE -> QUALITY MAP (loom_quality_master) ================= */ $MACH_QUALITY = []; try { $st3 = $pdo->prepare("SELECT machine_id, quality_id FROM loom_quality_master WHERE (company_id = :cid OR company_id IS NULL) AND machine_id > 0 AND quality_id > 0"); $st3->execute([':cid'=>$company_id]); foreach($st3 as $r){ $MACH_QUALITY[(int)$r['machine_id']] = (int)$r['quality_id']; } } catch(Exception $e){} /* ================= BANK AVAILABILITY (Direct from Master Table) ================= */ $HAS_BANK = []; $st = $pdo->prepare(" SELECT id FROM loom_karigar_master WHERE company_id = ? AND COALESCE(beneficiary_ac_number,'') <> '' AND COALESCE(ifsc_code,'') <> '' "); $st->execute([$company_id]); foreach ($st as $r) { $HAS_BANK[(int)$r['id']] = true; } /* ====================================================================== [5] FETCH LINES — READ FROM $src_table ====================================================================== */ $_skipped_bad_date = 0; $_skipped_out_range = 0; $MTR = []; $MTR_KAR_TOT = []; $karigar_set = []; $quality_set = []; $KAR_MACHINES = []; $from_ts = strtotime($date_from . ' 00:00:00'); $to_ts = strtotime($date_to . ' 23:59:59'); try { $sql = "SELECT id, company_id, khata_id, machine_id, quality_id, entry_date, meter_total, lines_json FROM `$src_table` WHERE company_id = :cid AND entry_date BETWEEN :d1 AND :d2"; $params = [':cid' => $company_id, ':d1' => $date_from, ':d2' => $date_to]; if ($khata_id > 0) { $sql .= " AND khata_id = :khata"; $params[':khata'] = $khata_id; } if ($machine_id > 0) { $sql .= " AND machine_id = :mc"; $params[':mc'] = $machine_id; } $sql .= " ORDER BY entry_date, machine_id, id"; $st = $pdo->prepare($sql); $st->execute($params); foreach ($st as $row) { $qid = (int)($row['quality_id'] ?? 0); $mc_id = (int)($row['machine_id'] ?? 0); if ($qid <= 0) { $qid = $MACH_QUALITY[$mc_id] ?? 0; } $entry_date = _norm_date($row['entry_date'] ?? ''); if (!$entry_date) { $_skipped_bad_date++; continue; } $ets = strtotime($entry_date . ' 00:00:00'); if ($ets < $from_ts || $ets > $to_ts) { $_skipped_out_range++; continue; } $lines = safe_json($row['lines_json'] ?? ''); if (!is_array($lines) || count($lines) === 0) { continue; } foreach ($lines as $li) { $kid = (int)($li['karigar_id'] ?? 0); $m = (float)($li['meter'] ?? 0.0); if ($kid <= 0 || $m <= 0.0) continue; $use_q = (int)($li['quality_id'] ?? 0); if ($use_q <= 0) $use_q = $qid; if ($use_q <= 0) continue; $karigar_set[$kid] = true; $quality_set[$use_q] = true; if ($mc_id > 0 && isset($MACH_NAME[$mc_id])) { $KAR_MACHINES[$kid][$MACH_NAME[$mc_id]] = true; } $MTR[$kid][$use_q] = ($MTR[$kid][$use_q] ?? 0.0) + $m; $MTR_KAR_TOT[$kid] = ($MTR_KAR_TOT[$kid] ?? 0.0) + $m; } } } catch (Throwable $e) { error_log("{$src_table} read failed: " . $e->getMessage()); } /* Build dimensions for table */ $quality_ids = array_keys($quality_set); usort($quality_ids, fn($a,$b)=>strcasecmp($QUALS[$a]??'', $QUALS[$b]??'')); $kar_list = array_keys($karigar_set); usort($kar_list, fn($a,$b)=>strcasecmp($KAR_NAME[$a]??("K$a"), $KAR_NAME[$b]??("K$b"))); /* [7] Money (Extra/Deduction/Advance) */ $EXTRA=[]; $DEDUCT=[]; $ADV=[]; $__adj_source = 'none'; $__adj_counts = ['extra'=>0,'deduction'=>0]; if ($FF_USE_QUEUE_ADJ) { try{ $__adj_source = 'queue'; $sq = $pdo->prepare(" SELECT karigar_id, type, SUM(amount) amt FROM salary_adjust_queue WHERE company_id=? AND person_type='karigar' AND apply_start=? AND apply_end=? GROUP BY karigar_id, type "); $sq->execute([$company_id,$date_from,$date_to]); foreach($sq as $r){ $kid = (int)$r['karigar_id']; if ($kid<=0) continue; $t = (string)$r['type']; $amt = (float)$r['amt']; if ($t==='extra'){ $EXTRA[$kid]=($EXTRA[$kid]??0)+$amt; $__adj_counts['extra']++; } if ($t==='deduction'){ $DEDUCT[$kid]=($DEDUCT[$kid]??0)+$amt; $__adj_counts['deduction']++; } } }catch(Exception $e){ $__adj_source = 'error-queue'; } } /* ================= BANK MISSING KARIGAR ================= */ $BANK_MISSING_IDS = []; foreach ($kar_list as $kid) { if (empty($HAS_BANK[$kid])) { $BANK_MISSING_IDS[] = $kid; } } /* Util to sum from tables */ function sum_money_tbl($pdo,$company_id,$tbl,$kid,$from,$to,$date_cols=['date','entry_date',],$amt_cols=['amount','amt','value']){ foreach($date_cols as $dc){ foreach($amt_cols as $ac){ try{ $st=$pdo->prepare("SELECT SUM($ac) s FROM $tbl WHERE company_id=? AND karigar_id=? AND $dc BETWEEN ? AND ?"); $st->execute([$company_id,$kid,$from,$to]); $v=$st->fetchColumn(); if($v!==false && $v!==null) return (float)$v; }catch(Exception $e){} }} return 0.0; } /* Merge: use karigar tables (karigar_extra / karigar_deduction) + advance_data unchanged */ foreach($kar_list as $kid){ $EXTRA[$kid] = ($EXTRA[$kid] ?? 0) + sum_money_tbl($pdo, $company_id, 'karigar_extra', $kid, $date_from, $date_to); $DEDUCT[$kid] = ($DEDUCT[$kid] ?? 0) + sum_money_tbl($pdo, $company_id, 'karigar_deduction', $kid, $date_from, $date_to); $ADV[$kid] = sum_money_tbl($pdo, $company_id, 'karigar_advance', $kid, $date_from, $date_to); } /* [8] Gross/Net per karigar — EXACT (no rounding) */ $GROSS=[]; $NET=[]; $bank_total=0.0; $cash_total=0.0; $grand_net=0.0; foreach($kar_list as $kid){ $g=0.0; foreach($quality_ids as $qid){ $g += ($MTR[$kid][$qid] ?? 0) * ($QUAL_RATE[$qid] ?? 0); } $GROSS[$kid]=$g; $n = $g + ($EXTRA[$kid]??0) - ($DEDUCT[$kid]??0) - ($ADV[$kid]??0); $NET[$kid] = $n; $grand_net += $n; if(!empty($HAS_BANK[$kid])) $bank_total += $n; else $cash_total += $n; } $TOT_METERS_BY_Q=[]; $GRAND_GROSS=0.0; foreach($quality_ids as $qid){ $s=0.0; foreach($kar_list as $kid){ $s += $MTR[$kid][$qid] ?? 0; } $TOT_METERS_BY_Q[$qid] = $s; $GRAND_GROSS += $s * ($QUAL_RATE[$qid] ?? 0.0); } $grand_mtr = array_sum($TOT_METERS_BY_Q); $TOT_EXTRA = array_sum(array_intersect_key($EXTRA, array_flip($kar_list))); $TOT_DED = array_sum(array_intersect_key($DEDUCT, array_flip($kar_list))); $TOT_ADV = array_sum(array_intersect_key($ADV, array_flip($kar_list))); $SHOW_EXTRA_COL = abs($TOT_EXTRA) > 0.00001; $SHOW_DEDUCT_COL = abs($TOT_DED) > 0.00001; $SHOW_ADV_COL = abs($TOT_ADV) > 0.00001; $pdf_quality_width = count($quality_ids) >= 6 ? '5.4%' : '6.2%'; $pdf_numeric_width = count($quality_ids) >= 6 ? '5.8%' : '6.6%'; $pdf_karigar_width = count($quality_ids) >= 6 ? '22%' : '24%'; $pdf_note_colspan = 4 + count($quality_ids) + ($SHOW_EXTRA_COL ? 1 : 0) + ($SHOW_DEDUCT_COL ? 1 : 0) + ($SHOW_ADV_COL ? 1 : 0); $pdf_col_count = count($quality_ids) + 4 + ($SHOW_EXTRA_COL ? 1 : 0) + ($SHOW_DEDUCT_COL ? 1 : 0) + ($SHOW_ADV_COL ? 1 : 0); $pdf_font_size = 10.2; $pdf_header_font_size = 9.6; $pdf_summary_font_size = 11.4; $pdf_cell_padding = '5px 3px'; if ($pdf_col_count >= 16) { $pdf_font_size = 6.8; $pdf_header_font_size = 6.4; $pdf_summary_font_size = 8.9; $pdf_cell_padding = '4px 1px'; } elseif ($pdf_col_count >= 13) { $pdf_font_size = 7.6; $pdf_header_font_size = 7.1; $pdf_summary_font_size = 9.8; $pdf_cell_padding = '4px 2px'; } elseif ($pdf_col_count >= 10) { $pdf_font_size = 8.3; $pdf_header_font_size = 7.8; $pdf_summary_font_size = 10.4; $pdf_cell_padding = '4px 2px'; } if (gv('export') === 'pdf') { if (!$PDF_AVAILABLE) { http_response_code(503); header('Content-Type: text/html; charset=UTF-8'); echo '<h3>PDF export unavailable</h3><p>Dompdf is not installed on this server.</p>'; exit; } ob_start(); ?> <!doctype html> <html> <head> <meta charset="utf-8"> <title>Loom Salary PDF</title> <style> @page{margin:14px 18px} body{margin:0;font-family:DejaVu Sans, sans-serif;font-size:<?= $pdf_font_size ?>px;color:#000} h2{text-align:center;margin:0 0 4px;font-size:<?= max($pdf_summary_font_size + 1.2, 9) ?>px} .period{text-align:center;margin:0 0 8px;font-size:<?= $pdf_summary_font_size ?>px} .summary-box{border:1px solid #000;padding:7px 8px;margin-bottom:10px;font-size:<?= $pdf_summary_font_size ?>px} .summary-box div{margin:1px 0} .missing-box{border:1px solid #000;padding:7px 8px;margin-bottom:10px;font-size:<?= max($pdf_summary_font_size - 1, 8) ?>px} .missing-box ul{margin:4px 0 0 15px;padding:0} table{width:100%;border-collapse:collapse;table-layout:fixed} th,td{border:1px solid #000;padding:<?= $pdf_cell_padding ?>;font-size:<?= $pdf_font_size ?>px;line-height:1.22;vertical-align:middle} th{background:#e6f4ea;font-size:<?= $pdf_header_font_size ?>px;line-height:1.2;word-break:break-word} tfoot td{font-weight:bold;background:#fff3cd} .text-right{text-align:right} .small-note{font-size:<?= max($pdf_font_size - 0.6, 5.5) ?>px;text-align:left} .col-karigar{width:<?= $pdf_karigar_width ?>} .col-quality{width:<?= $pdf_quality_width ?>} .col-number{width:<?= $pdf_numeric_width ?>} .karigar-name{white-space:normal;word-break:break-word;line-height:1.25} .nowrap{white-space:nowrap} </style> </head> <body> <h2>Loom Karigar Salary Report</h2> <div class="period"><?= h($company_name) ?> | <?= h($period_label) ?></div> <div class="summary-box"> <div><strong>Total Salary:</strong> Rs. <?= fmt2($grand_net) ?></div> <div><strong>Bank Payment:</strong> Rs. <?= fmt2($bank_total) ?></div> <div><strong>Cash Payment:</strong> Rs. <?= fmt2($cash_total) ?></div> </div> <?php if (!empty($BANK_MISSING_IDS)): ?> <div class="missing-box"> <strong>Bank Detail Missing (<?= count($BANK_MISSING_IDS) ?>):</strong> <ul> <?php foreach ($BANK_MISSING_IDS as $kid): $m_info = !empty($KAR_ENTRY[$kid]) ? $KAR_ENTRY[$kid] : (!empty($KAR_MACHINES[$kid]) ? implode(', ', array_keys($KAR_MACHINES[$kid])) : 'N/A'); ?> <li><?= h($KAR_NAME[$kid] ?? "Karigar #$kid") ?> (<strong>Machine:</strong> <?= h($m_info) ?>)</li> <?php endforeach; ?> </ul> </div> <?php endif; ?> <table> <colgroup> <col class="col-karigar"> <?php foreach ($quality_ids as $qid): ?> <col class="col-quality"> <?php endforeach; ?> <col class="col-number"> <col class="col-number"> <?php if($SHOW_EXTRA_COL): ?><col class="col-number"><?php endif; ?> <?php if($SHOW_DEDUCT_COL): ?><col class="col-number"><?php endif; ?> <?php if($SHOW_ADV_COL): ?><col class="col-number"><?php endif; ?> <col class="col-number"> </colgroup> <thead> <tr> <th>Karigar</th> <?php foreach($quality_ids as $qid): ?> <th> <?= h($QUALS[$qid] ?? ("Q$qid")) ?><br> @ <?= fmt2($QUAL_RATE[$qid] ?? 0) ?> </th> <?php endforeach; ?> <th>Total Mtr</th> <th>Gross</th> <?php if($SHOW_EXTRA_COL): ?><th>Extra</th><?php endif; ?> <?php if($SHOW_DEDUCT_COL): ?><th>Deduction</th><?php endif; ?> <?php if($SHOW_ADV_COL): ?><th>Advance</th><?php endif; ?> <th>Payable (Net)</th> </tr> </thead> <tbody> <?php foreach($kar_list as $kid): ?> <tr> <td class="karigar-name"><?= h($KAR_NAME[$kid] ?? ("Karigar #$kid")) ?></td> <?php foreach($quality_ids as $qid): $m = $MTR[$kid][$qid] ?? 0; ?> <td class="text-right nowrap"><?= fmt2_blank_zero($m) ?></td> <?php endforeach; ?> <td class="text-right nowrap"><?= fmt2_blank_zero($MTR_KAR_TOT[$kid] ?? 0) ?></td> <td class="text-right nowrap"><?= fmt2_blank_zero($GROSS[$kid] ?? 0) ?></td> <?php if($SHOW_EXTRA_COL): ?><td class="text-right nowrap"><?= fmt2_blank_zero($EXTRA[$kid] ?? 0) ?></td><?php endif; ?> <?php if($SHOW_DEDUCT_COL): ?><td class="text-right nowrap"><?= fmt2_blank_zero($DEDUCT[$kid] ?? 0) ?></td><?php endif; ?> <?php if($SHOW_ADV_COL): ?><td class="text-right nowrap"><?= fmt2_blank_zero($ADV[$kid] ?? 0) ?></td><?php endif; ?> <td class="text-right nowrap"><?= fmt2_blank_zero($NET[$kid] ?? 0) ?></td> </tr> <?php endforeach; ?> </tbody> <tfoot> <tr> <td>TOTAL</td> <?php foreach($quality_ids as $qid): ?> <td class="text-right nowrap"><?= fmt2_blank_zero($TOT_METERS_BY_Q[$qid] ?? 0) ?></td> <?php endforeach; ?> <td class="text-right nowrap"><?= fmt2_blank_zero($grand_mtr) ?></td> <td class="text-right nowrap"><?= fmt2_blank_zero($GRAND_GROSS) ?></td> <?php if($SHOW_EXTRA_COL): ?><td class="text-right nowrap"><?= fmt2_blank_zero($TOT_EXTRA) ?></td><?php endif; ?> <?php if($SHOW_DEDUCT_COL): ?><td class="text-right nowrap"><?= fmt2_blank_zero($TOT_DED) ?></td><?php endif; ?> <?php if($SHOW_ADV_COL): ?><td class="text-right nowrap"><?= fmt2_blank_zero($TOT_ADV) ?></td><?php endif; ?> <td class="text-right nowrap"><?= fmt2_blank_zero($grand_net) ?></td> </tr> <tr> <td colspan="<?= $pdf_note_colspan ?>" class="small-note"> Amount (= Sum Meters x Rate). Rates from quality_rates. Lines from <?= h($src_table) ?>. </td> </tr> </tfoot> </table> </body> </html> <?php $pdfHtml = ob_get_clean(); $dompdf = new \Dompdf\Dompdf([ 'isRemoteEnabled' => false, 'defaultFont' => 'DejaVu Sans', ]); $dompdf->loadHtml($pdfHtml, 'UTF-8'); $dompdf->setPaper('A4', 'portrait'); $dompdf->render(); $filename = 'loom_salary_' . $year . '_' . str_pad((string)$month, 2, '0', STR_PAD_LEFT) . '_' . $half . '.pdf'; $dompdf->stream($filename, ['Attachment' => true]); exit; } require_once __DIR__ . '/partials/header.php'; /* ============================== HTML ============================== */ ?> <!doctype html> <html> <head> <meta charset="utf-8"> <title>Loom Salary </title> <meta name="viewport" content="width=device-width, initial-scale=1"> <style> :root{ --green:#34A853; --mint:#F5FFF7; --stone:#5F6368; --sage:#D0E8D0; --sky:#A7D8DE; --yellow:#FFF9C4; } *{box-sizing:border-box} body{margin:0;background:var(--mint);color:#222;font-family:system-ui,-apple-system,Segoe UI,Roboto,Ubuntu,Arial} /* layout wrapper */ .wrap{max-width:1600px;margin:20px auto;padding:0 12px} .h1{color:#2c7d3f;margin:6px 0 12px} /* header bar */ .hbar{display:flex;gap:12px;align-items:flex-end;flex-wrap:wrap;background:#e9f7ee;border:1px solid #d6f0dd;padding:12px;border-radius:12px} .hbar label{font-size:12px;color:#333;display:block;margin-bottom:4px} .hbar select{padding:8px 10px;border:1px solid #cfe8d0;border-radius:10px;background:#fff;min-width:140px} /* buttons */ .btn{background:var(--green);color:#fff;border:none;border-radius:12px;padding:9px 14px;font-weight:600;cursor:pointer;text-decoration:none;display:inline-block} .btn.gray{background:#5F6368} .btn.warn{background:#ef4444} /* card container: allow scrolling but keep payable visible */ .card{background:#fff;border:1px solid #ecf2ec;border-radius:14px;overflow:auto;margin-top:16px;width:100%;max-width:100%;padding-bottom:10px;} /* table: make it fit parent and reduce extra spacing */ .table{ width:100%; border-collapse:separate; border-spacing:0; min-width:0; table-layout:auto; } .table col.col-karigar{width:22%} .table col.col-quality{width:5.5%} .table col.col-number{width:6%} .table th, .table td{ padding:6px 6px; border-bottom:1px solid #eef5ef; white-space:nowrap; vertical-align:middle; overflow:hidden; text-overflow:ellipsis; } /* header sticky at top */ .table thead th{ position:sticky; top:0; background:#cfe9d7; color:#1b4d2a; text-align:right; z-index:3; padding:10px; } .table thead th:first-child{text-align:left} /* text alignment */ .table tbody td{text-align:right} .table tbody td:first-child{text-align:left} /* reduce gratuitous column width by capping widths with ellipsis */ .table tbody td{max-width:110px} .table tbody td:first-child{max-width:260px; white-space:normal} /* make last column (payable) always visible by sticking it to the right */ .table th:last-child, .table td:last-child{ position: -webkit-sticky; position: sticky; right: 0; z-index: 4; min-width:88px; max-width:112px; white-space:nowrap; overflow:hidden; text-overflow:ellipsis; background: linear-gradient(180deg,#cfe9d7,#ffffff); text-align:right; border-left:1px solid #e6efe6; } /* footer row style */ .table tfoot td{background:#fff9e8;font-weight:700} /* small helpers */ .head2{background:#b7dcd0;color:#0f4230} .subrate{font-size:12px;opacity:.8} .totalcol{background:#f3faf4;font-weight:700} .small{font-size:13px;color:#555} .kentry{display:block;font-size:12px;color:#666} .summary{background:#f1f9f2;border:1px dashed #cde8cf;padding:8px 12px;border-radius:10px;margin:10px 0;color:#165c30} /* print tweaks */ @media print { .hbar, .flash, form[action="/erp/loom_payment_export.php"] + * { display:none !important; } .wrap{max-width:100%} .card{border:none;overflow:visible;padding-bottom:0} .table{min-width:0; white-space:normal} } </style> <script> function printReportWindow() { const cardEl = document.querySelector('.card'); if (!cardEl) { alert('Report table not found'); return; } const w = window.open('', '_blank', 'toolbar=0,location=0,menubar=0,width=1200,height=800'); const doc = w.document; doc.open(); doc.write(`<!doctype html> <html> <head> <meta charset="utf-8"> <title>Loom Karigar Salary Report</title> <style> body{ font-family: Arial, sans-serif; padding:20px; color:#000; } h2{ text-align:center; margin:0; } .period{ text-align:center; margin-bottom:12px; font-size:14px; } .summary-box{ border:1px solid #000; padding:10px; margin-bottom:15px; font-size:14px; } table{ width:100%; border-collapse:collapse; margin-bottom:15px; } th, td{ border:1px solid #000; padding:6px 8px; font-size:13px; } th{ background:#e6f4ea; } tfoot td{ font-weight:bold; background:#fff3cd; } .quality-summary th{ background:#d1ecf1; } </style> </head> <body> <h2>Loom Karigar Salary Report</h2> <div class="period"> <?= date('F Y', strtotime($date_from)) ?> – <?= h($period_label) ?> </div> <div class="summary-box"> <b>Total Salary:</b> ₹ <?= fmt2($grand_net) ?><br> <b>Bank Payment:</b> ₹ <?= fmt2($bank_total) ?><br> <b>Cash Payment:</b> ₹ <?= fmt2($cash_total) ?> </div> ${cardEl.querySelector('table').outerHTML} <script> function closeAfterPrint(){ setTimeout(function(){ window.close(); },500); } window.onafterprint = closeAfterPrint; window.print(); <\/script> </body> </html>`); doc.close(); w.focus(); } function saveReportSnapshot() { const reportContent = document.getElementById('reportContent').innerHTML; document.getElementById('reportHtmlField').value = reportContent; document.getElementById('snapshotForm').submit(); } </script> </head> <body> <div class="wrap"> <h2 class="h1">Loom Salary <span class="small"></span></h2> <div class="small" style="margin-bottom:8px;"><b>Company:</b> <?= h($company_name) ?></div> <?php if (isset($_GET['snapshot_saved'])): ?> <div class="alert alert-success alert-dismissible fade show border-0 shadow-sm" role="alert" style="background:#d4edda;color:#155724;padding:10px;border-radius:8px;margin-bottom:12px;"> <i class="bi bi-cloud-check-fill me-2"></i> Successfully saved to Master Salary Report! </div> <?php endif; ?> <!-- Filters + Actions --> <form class="hbar" method="get" action=""> <div> <label>Mode</label> <select name="mode" title="Source entries: machine-wise or taka-wise"> <option value="machine" <?= $mode!=='taka'?'selected':'' ?>>Machine Wise</option> <option value="taka" <?= $mode==='taka'?'selected':'' ?>>Taka Wise</option> </select> </div> <div> <label>Khata</label> <select name="khata_id"> <option value="0">All</option> <?php $KHATAS=[]; try{ $kq=$pdo->prepare("SELECT DISTINCT khata_id, khata_code FROM loom_karigar_master WHERE company_id=? AND khata_id IS NOT NULL ORDER BY khata_code"); $kq->execute([$company_id]); foreach($kq as $r){ $KHATAS[(int)$r['khata_id']] = $r['khata_code']; } }catch(Exception $e){} foreach($KHATAS as $id=>$code): ?> <option value="<?= $id ?>" <?= $khata_id===$id?'selected':''?>><?= h($code) ?></option> <?php endforeach; ?> </select> </div> <div> <label>Machine</label> <select name="machine_id"> <option value="0">All Machines</option> <?php $MACH=[]; try{ $st2=$pdo->prepare("SELECT id, machine_code FROM machines WHERE company_id=? ORDER BY id"); $st2->execute([$company_id]); foreach($st2 as $r){ $MACH[(int)$r['id']] = $r['machine_code'] ?: ('MC '.$r['id']); } }catch(Exception $e){} foreach($MACH as $id=>$label): ?> <option value="<?= $id ?>" <?= $machine_id===$id?'selected':''?>><?= h($label) ?></option> <?php endforeach; ?> </select> </div> <div> <label>Month</label> <select name="month"> <?php for($m=1;$m<=12;$m++): ?> <option value="<?= $m ?>" <?= $m===$month?'selected':''?>><?= date('M', mktime(0,0,0,$m,1,$year)) ?></option> <?php endfor; ?> </select> </div> <div> <label>Period</label> <select name="half" title="Choose 1-15, 16-End, or Full month"> <option value="1" <?= $half==='1'?'selected':''?>>1–15</option> <option value="2" <?= $half==='2'?'selected':''?>>16–End</option> <option value="F" <?= $half==='F'?'selected':''?>>Full month</option> </select> </div> <div> <label>Year</label> <select name="year"> <?php for($y=date('Y')-2;$y<=date('Y')+1;$y++): ?> <option value="<?= $y ?>" <?= $y===$year?'selected':''?>><?= $y ?></option> <?php endfor; ?> </select> </div> <button class="btn right" type="submit">Show Report</button> <?php $export_rows = []; foreach ($kar_list as $kid) { $amt = (float)($NET[$kid] ?? 0); if ($amt != 0.0) $export_rows[] = ['employee_id' => $kid, 'amount' => round($amt,2)]; } $export_payload = json_encode($export_rows, JSON_UNESCAPED_UNICODE); $pdf_qs = http_build_query([ 'mode'=>$mode,'khata_id'=>$khata_id,'machine_id'=>$machine_id,'month'=>$month,'half'=>$half,'year'=>$year,'export'=>'pdf' ]); ?> <button class="btn gray" type="button" onclick="printReportWindow()">Print</button> <a class="btn gray" href="?<?= h($pdf_qs) ?>" <?= $PDF_AVAILABLE? '' : 'onclick="alert(\'Install dompdf/dompdf first.\'); return false;"' ?>>Export PDF</a> <button class="btn gray" type="submit" form="exportForm">Export Excel</button> <button class="btn" type="button" onclick="saveReportSnapshot()" style="background:#212529;">Save to Master Salary</button> </form> <form id="snapshotForm" method="post" action="loom_salary.php?mode=<?=$mode?>&year=<?=$year?>&month=<?=$month?>&half=<?=$half?>&khata_id=<?=$khata_id?>&machine_id=<?=$machine_id?>" style="display:none;"> <input type="hidden" name="action" value="save_snapshot"> <input type="hidden" name="half" value="<?= h($half) ?>"> <textarea name="report_html" id="reportHtmlField"></textarea> </form> <form id="exportForm" method="post" action="/erp/loom_payment_export.php" style="display:none"> <input type="hidden" name="salary_rows" value='<?= h($export_payload) ?>'> <input type="hidden" name="period_label" value="<?= h($period_label) ?>"> <input type="hidden" name="period_start" value="<?= h($date_from) ?>"> <input type="hidden" name="period_end" value="<?= h($date_to) ?>"> </form> <!-- REPORT CONTENT WRAPPER FOR SNAPSHOT (Includes Summary & Table) --> <div id="reportContent"> <!-- Minimal Summary: only total --> <div class="summary"> <b>Total Salary:</b> ₹ <?= fmt2($grand_net) ?><br> <b>Bank Payment:</b> ₹ <?= fmt2($bank_total) ?><br> <b>Cash Payment:</b> ₹ <?= fmt2($cash_total) ?> <?php if (!empty($BANK_MISSING_IDS)): ?> <br><b>Bank Detail Missing (<?= count($BANK_MISSING_IDS) ?>):</b> <ul> <?php foreach ($BANK_MISSING_IDS as $kid): $m_info = !empty($KAR_ENTRY[$kid]) ? $KAR_ENTRY[$kid] : (!empty($KAR_MACHINES[$kid]) ? implode(', ', array_keys($KAR_MACHINES[$kid])) : 'N/A'); ?> <li><?= htmlspecialchars($KAR_NAME[$kid] ?? "Karigar #$kid") ?> (<b>Machine:</b> <?= htmlspecialchars($m_info) ?>)</li> <?php endforeach; ?> </ul> <?php endif; ?> </div> <div class="card"> <table class="table"> <colgroup> <col class="col-karigar"> <?php foreach($quality_ids as $qid): ?> <col class="col-quality"> <?php endforeach; ?> <col class="col-number"> <col class="col-number"> <?php if($SHOW_EXTRA_COL): ?><col class="col-number"><?php endif; ?> <?php if($SHOW_DEDUCT_COL): ?><col class="col-number"><?php endif; ?> <?php if($SHOW_ADV_COL): ?><col class="col-number"><?php endif; ?> <col class="col-number"> </colgroup> <thead> <tr> <th>Karigar</th> <?php foreach($quality_ids as $qid): ?> <th class="head2 col-quality"> <?= h($QUALS[$qid] ?? ("Q$qid")) ?><br> <span class="subrate">@ <?= fmt2($QUAL_RATE[$qid]??0) ?></span> </th> <?php endforeach; ?> <th class="col-number">Total Mtr</th> <th class="col-number">Gross</th> <?php if($SHOW_EXTRA_COL): ?><th class="col-number">Extra</th><?php endif; ?> <?php if($SHOW_DEDUCT_COL): ?><th class="col-number">Deduction</th><?php endif; ?> <?php if($SHOW_ADV_COL): ?><th class="col-number">Advance</th><?php endif; ?> <th class="col-number">Payable (Net)</th> </tr> </thead> <tbody> <?php foreach($kar_list as $kid): ?> <tr> <td> <?= h($KAR_NAME[$kid] ?? ("Karigar #$kid")) ?> <?php if(!empty($KAR_ENTRY[$kid])): ?> <span class="kentry"><?= h($KAR_ENTRY[$kid]) ?></span> <?php endif; ?> </td> <?php foreach($quality_ids as $qid): $m=$MTR[$kid][$qid] ?? 0; ?> <td><?= fmt2_blank_zero($m) ?></td> <?php endforeach; ?> <td class="totalcol"><?= fmt2_blank_zero($MTR_KAR_TOT[$kid]??0) ?></td> <td><?= fmt2_blank_zero($GROSS[$kid]??0) ?></td> <?php if($SHOW_EXTRA_COL): ?><td><?= fmt2_blank_zero($EXTRA[$kid]??0) ?></td><?php endif; ?> <?php if($SHOW_DEDUCT_COL): ?><td><?= fmt2_blank_zero($DEDUCT[$kid]??0) ?></td><?php endif; ?> <?php if($SHOW_ADV_COL): ?><td><?= fmt2_blank_zero($ADV[$kid]??0) ?></td><?php endif; ?> <td class="totalcol"><?= fmt2_blank_zero($NET[$kid] ?? 0.0) ?></td> </tr> <?php endforeach; ?> </tbody> <tfoot> <tr> <td>TOTAL</td> <?php foreach($quality_ids as $qid): ?> <td><?= fmt2_blank_zero($TOT_METERS_BY_Q[$qid] ?? 0) ?></td> <?php endforeach; ?> <td class="totalcol"><?= fmt2_blank_zero($grand_mtr) ?></td> <td><?= fmt2_blank_zero($GRAND_GROSS) ?></td> <?php if($SHOW_EXTRA_COL): ?><td><?= fmt2_blank_zero($TOT_EXTRA) ?></td><?php endif; ?> <?php if($SHOW_DEDUCT_COL): ?><td><?= fmt2_blank_zero($TOT_DED) ?></td><?php endif; ?> <?php if($SHOW_ADV_COL): ?><td><?= fmt2_blank_zero($TOT_ADV) ?></td><?php endif; ?> <td class="totalcol"><?= fmt2_blank_zero($grand_net) ?></td> </tr> <tr> <td colspan="<?= 4 + count($quality_ids) + ($SHOW_EXTRA_COL ? 1 : 0) + ($SHOW_DEDUCT_COL ? 1 : 0) + ($SHOW_ADV_COL ? 1 : 0) ?>" class="small" style="text-align:left;padding:12px"> Amount (= Σ Meters × Rate). Rates from <code>quality_rates</code>. Lines from <code><?= h($src_table) ?></code>. <br>Skipped (diagnostic): Bad Date = <?= (int)$_skipped_bad_date ?>, Out of Range = <?= (int)$_skipped_out_range ?>. </td> </tr> </tfoot> </table> </div> </div> </div> </body> </html> <?php /* include footer (correct path) */ require_once __DIR__ . '/partials/footer.php';