View Code - 20260723

yarn_stockn.php | 20260723_000646.php Initial Domain Snapshot

<?php
/* =========================================================
   File: /erp/yarn_stock.php
   Purpose: Stock = IN - OUT (by type) + All Reports view + PDF + CSV + print-friendly view
   Changes:
    - Added Stock Type filter (All/Yarn/TFO/TPM/Zari)
    - Added Show Zero filter (with_zero / without_zero)
    - Table columns separated: Boxes | Weight | AVG/Box
    - CSV/PDF/Print respect filters
    - print=1 renders minimal page (no header/footer) for clean printing
   ========================================================= */
error_reporting(E_ALL); ini_set('display_errors', 1);

/* ---- Header include toggle (ALWAYS ON unless print=1) ---- */
$print_only = (isset($_GET['print']) && (int)$_GET['print']===1);
$USE_HEADER = !$print_only;

/* ---- Auth + scope (AUTH FILES UNTOUCHED) ---- */
require_once __DIR__ . '/modules/auth/page_acl.php';
$ctx        = page_require_access('yarn_entry'); // same ACL as entry
$company_id = (int)($ctx['company_id'] ?? 0);
$u          = $ctx['user'] ?? null;

/* ---- PDO bootstrap (robust) ---- */
$pdo = $ctx['pdo'] ?? null;
if (!($pdo instanceof PDO)) {
  $tryInclude = function(string $path) use (&$pdo) {
    @include_once $path;
    if ($pdo instanceof PDO) return true;
    if (isset($db)  && $db  instanceof PDO) { $pdo = $db;  return true; }
    if (isset($dbh) && $dbh instanceof PDO) { $pdo = $dbh; return true; }
    if (isset($conn) && $conn instanceof PDO){ $pdo = $conn; return true; }
    return false;
  };
  foreach ([__DIR__.'/core/db.php', __DIR__.'/db.php', __DIR__.'/config/db.php', __DIR__.'/config.php'] as $p) {
    if (is_file($p) && $tryInclude($p)) { break; }
  }
  if (!($pdo instanceof PDO)) {
    $constSets = [['DB_HOST','DB_NAME','DB_USER','DB_PASS'],['DB_HOSTNAME','DB_DATABASE','DB_USERNAME','DB_PASSWORD']];
    foreach ($constSets as $cs) {
      [$H,$N,$U,$P] = $cs;
      if (defined($H)&&defined($N)&&defined($U)&&defined($P)) {
        try {
          $pdo = new PDO(
            'mysql:host='.constant($H).';dbname='.constant($N).';charset=utf8mb4',
            constant($U), constant($P),
            [
              PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION,
              PDO::ATTR_DEFAULT_FETCH_MODE=>PDO::FETCH_ASSOC,
              PDO::ATTR_EMULATE_PREPARES=>false,
            ]
          );
          break;
        } catch (Throwable $e) { error_log('[yarn_stock] PDO build failed: '.$e->getMessage()); }
      }
    }
  }
  if (!($pdo instanceof PDO)) { http_response_code(500); exit('DB bootstrap failed.'); }
}

/* ---- Schema helpers (page-local) ---- */
function table_cols(PDO $pdo, string $t): array {
  static $cache = [];
  if (isset($cache[$t])) return $cache[$t];
  try {
    $rows = $pdo->query("DESCRIBE `$t`")->fetchAll(PDO::FETCH_ASSOC);
    $cache[$t] = array_map(fn($r)=>$r['Field'], $rows);
  } catch (Throwable $e) { $cache[$t] = []; }
  return $cache[$t];
}
function has_col(PDO $pdo, string $t, string $c): bool { return in_array($c, table_cols($pdo,$t), true); }
function table_exists(PDO $pdo, string $t): bool {
  try { $pdo->query("SELECT 1 FROM `$t` LIMIT 1"); return true; } catch(Throwable $e){ return false; }
}

/* Resolve company name (prefer header-provided; fallback DB; never show ID) */
function resolve_company_name(PDO $pdo, $u, int $company_id): string {
  if (isset($GLOBALS['company']['name']) && $GLOBALS['company']['name']) return (string)$GLOBALS['company']['name'];
  if (is_array($u) && !empty($u['company_name'])) return (string)$u['company_name'];
  foreach (['companies','company','company_master'] as $tbl) {
    if (table_exists($pdo, $tbl) && has_col($pdo,$tbl,'name')) {
      try {
        $st=$pdo->prepare("SELECT name FROM `$tbl` WHERE id=? LIMIT 1");
        $st->execute([$company_id]); if($r=$st->fetch()){ return (string)$r['name']; }
      } catch(Throwable $e){}
    }
  }
  return 'Company';
}

/* Decide which tables to use for a given stock type */
function in_out_tables_for(PDO $pdo, string $stock_type): array {
  // stock_type 'All' means we'll iterate outside
  $stock_type = ucfirst(strtolower($stock_type));
  $unified = table_exists($pdo,'yarn_in') && has_col($pdo,'yarn_in','stock_type') && table_exists($pdo,'yarn_out') && has_col($pdo,'yarn_out','stock_type');
  if ($unified) return ['yarn_in','yarn_out', true];
  switch ($stock_type) {
    case 'Tfo':  return ['tfo_in','tfo_out',   false];
    case 'Tpm':  return ['tpm_in','tpm_out',   false];
    case 'Zari': return ['zari_in','zari_out', false];
    default:     return ['yarn_in','yarn_out', false];
  }
}

/* ---- Filters (including new ones) ---- */
$flt_type   = trim($_GET['yarn_type'] ?? '');
$flt_comp   = trim($_GET['company']   ?? '');
$flt_denier = trim($_GET['denier']    ?? '');
$flt_color  = trim($_GET['color']     ?? '');
$view       = strtolower(trim($_GET['view'] ?? 'single')); // 'single' or 'all'
$flt_stock_type = trim($_GET['stock_type'] ?? 'Yarn'); // All, Yarn, TFO, TPM, Zari
if ($flt_stock_type === '') $flt_stock_type = 'Yarn';
$flt_show_zero = trim($_GET['show_zero'] ?? 'with_zero'); // 'with_zero' | 'without_zero'

/* ---- Dropdown options from yarn_company_data (Yarn only) ---- */
function fetchDistinct(PDO $pdo, $company_id, $col, $parents=[], $stock_type_filter=null) {
  $map = ['yarn_type'=>'yarn_types','company'=>'company_name','denier'=>'denier','color'=>'color'];
  $filters = ['company_id = :cid']; $params = [':cid'=>$company_id];
  // When asking yarn_company_data for yarn types, we can optionally filter by stock_type (if provided)
  if ($stock_type_filter && in_array('stock_type', table_cols($pdo,'yarn_company_data'), true)) {
    if (strtolower($stock_type_filter) !== 'all') {
      $filters[] = 'TRIM(stock_type) = TRIM(:_st)';
      $params[':_st'] = $stock_type_filter;
    }
  }
  foreach (['yarn_type','company','denier'] as $k) {
    if (!empty($parents[$k])) { $filters[]="`{$map[$k]}`= :$k"; $params[":$k"]=$parents[$k]; }
  }
  $sql="SELECT DISTINCT `{$map[$col]}` AS v FROM yarn_company_data WHERE ".implode(' AND ', $filters)." ORDER BY v";
  $st=$pdo->prepare($sql); $st->execute($params); $out=[]; while($r=$st->fetch()){ if($r['v']!=='') $out[]=$r['v']; }
  return $out;
}

$opts_type   = fetchDistinct($pdo, $company_id, 'yarn_type', [], ($flt_stock_type?:null));
$opts_comp   = fetchDistinct($pdo, $company_id, 'company',   ['yarn_type'=>$flt_type], ($flt_stock_type?:null));
$opts_denier = fetchDistinct($pdo, $company_id, 'denier',    ['yarn_type'=>$flt_type,'company'=>$flt_comp], ($flt_stock_type?:null));
$opts_color  = fetchDistinct($pdo, $company_id, 'color',     ['yarn_type'=>$flt_type,'company'=>$flt_comp,'denier'=>$flt_denier], ($flt_stock_type?:null));

/* ---- Aggregator (schema-aware) ----
   build_stock now supports $stock_type === 'All' to combine results across types,
   and $hide_zero to exclude rows where both boxes and weight are zero.
*/
function build_stock(PDO $pdo, int $company_id, array $filters, string $stock_type, bool $hide_zero=false): array {
  $stock_type = ucfirst(strtolower($stock_type));
  $types_to_process = [];
  if (strtolower($stock_type) === 'all') {
    $types_to_process = ['Yarn','TFO','TPM','Zari'];
  } else {
    $types_to_process = [$stock_type];
  }

$merged_rows = [];
  $tot_boxes = 0.0; $tot_weight = 0.0;
  foreach ($types_to_process as $stype) {
    [$in_tbl, $out_tbl, $use_stock_type] = in_out_tables_for($pdo, $stype);
    // build where clauses separately
    $where_in   = ["company_id = :cid_in"];  $params_in  = [':cid_in'=>$company_id];
    $where_out  = ["company_id = :cid_out"]; $params_out = [':cid_out'=>$company_id];
    if ($use_stock_type) {
      $where_in[]  = "stock_type = :stype_in";
      $where_out[] = "stock_type = :stype_out";
      $params_in[':stype_in']   = ucfirst(strtolower($stype));
      $params_out[':stype_out'] = ucfirst(strtolower($stype));
    }
    foreach (['yarn_type'=>'yt','company'=>'co','denier'=>'de','color'=>'cl'] as $col => $tag) {
      if (($filters[$col] ?? '') !== '') {
        $where_in[]  = "$col = :{$tag}_in";  $params_in[":{$tag}_in"]   = $filters[$col];
        $where_out[] = "$col = :{$tag}_out"; $params_out[":{$tag}_out"] = $filters[$col];
      }
    }

// Query aggregated in/out for this type
    $sql = "
      SELECT
        i.yarn_type, i.company, i.denier, i.color,
        i.boxes_in, i.weight_in,
        COALESCE(o.boxes_out,0)  AS boxes_out,
        COALESCE(o.weight_out,0) AS weight_out
      FROM
        (SELECT yarn_type, company, denier, color,
                SUM(boxes)  AS boxes_in,
                SUM(weight) AS weight_in
         FROM `$in_tbl`
         WHERE ".implode(' AND ', $where_in)."
         GROUP BY yarn_type, company, denier, color) i
      LEFT JOIN
        (SELECT yarn_type, company, denier, color,
                SUM(boxes)  AS boxes_out,
                SUM(weight) AS weight_out
         FROM `$out_tbl`
         WHERE ".implode(' AND ', $where_out)."
         GROUP BY yarn_type, company, denier, color) o
      ON  i.yarn_type=o.yarn_type AND i.company=o.company AND i.denier=o.denier AND i.color=o.color
      ORDER BY i.yarn_type, i.company, i.denier, i.color
    ";
    $st = $pdo->prepare($sql);
    $st->execute($params_in + $params_out);
    $rows = $st->fetchAll();

foreach ($rows as $r) {
      $cur_boxes  = max(0,(float)$r['boxes_in']  - (float)$r['boxes_out']);
      $cur_weight = max(0,(float)$r['weight_in'] - (float)$r['weight_out']);
      $avg        = $cur_boxes>0 ? $cur_weight/$cur_boxes : 0.0;

if ($hide_zero && $cur_boxes==0 && $cur_weight==0) {
        // skip empty row
        continue;
      }

$status = 'OK';
      if($cur_boxes==0 && $cur_weight>0) $status='Check';
      if($cur_boxes==0 && $cur_weight==0) $status='Empty';

$merged_rows[] = [
        'stock_type'   => $stype,
        'yarn_type'    => $r['yarn_type'],
        'company'      => $r['company'],
        'denier'       => $r['denier'],
        'color'        => $r['color'],
        'cur_boxes'    => $cur_boxes,
        'cur_weight'   => $cur_weight,
        'avg_per_box'  => $avg,
        'status'       => $status,
        '_boxes_in'    => (float)$r['boxes_in'],
        '_weight_in'   => (float)$r['weight_in'],
        '_boxes_out'   => (float)$r['boxes_out'],
        '_weight_out'  => (float)$r['weight_out'],
      ];

$tot_boxes  += $cur_boxes;
      $tot_weight += $cur_weight;
    }
  } // end foreach type

$tot_avg = $tot_boxes>0 ? $tot_weight/$tot_boxes : 0.0;
  return ['rows'=>$merged_rows, 'tot_boxes'=>$tot_boxes, 'tot_weight'=>$tot_weight, 'tot_avg'=>$tot_avg];
}

/* ---------- CSV export ---------- */
if (isset($_GET['export']) && $_GET['export'] === 'csv') {
  $today = date('Y-m-d'); $view_q = strtolower(trim($_GET['view'] ?? 'single'));
  $flt_type   = trim($_GET['yarn_type'] ?? '');
  $flt_comp   = trim($_GET['company']   ?? '');
  $flt_denier = trim($_GET['denier']    ?? '');
  $flt_color  = trim($_GET['color']     ?? '');
  $flt_stock_type = trim($_GET['stock_type'] ?? 'Yarn');
  $flt_show_zero = trim($_GET['show_zero'] ?? 'with_zero');
  $hide_zero = ($flt_show_zero === 'without_zero');

$filename = ($view_q==='all') ? "all_stock_$today.csv" : "yarn_stock_$today.csv";
  header('Content-Type: text/csv; charset=utf-8');
  header('Content-Disposition: attachment; filename="'.$filename.'"');
  $out = fopen('php://output', 'w');

if ($view_q === 'all') {
    fputcsv($out, ['Stock Type','Yarn Type','Company','Denier','Color','Current Boxes','Current Weight','AVG/Box','Status']);
    $b = build_stock($pdo, $company_id, ['yarn_type'=>$flt_type,'company'=>$flt_comp,'denier'=>$flt_denier,'color'=>$flt_color], $flt_stock_type, $hide_zero);
    foreach ($b['rows'] as $v) {
      fputcsv($out, [
        $v['stock_type'], $v['yarn_type'], $v['company'], $v['denier'], $v['color'],
        number_format($v['cur_boxes'],3,'.',''),
        number_format($v['cur_weight'],3,'.',''),
        number_format($v['avg_per_box'],3,'.',''),
        $v['status']
      ]);
    }
    fputcsv($out, ['TOTAL','','','','', number_format($b['tot_boxes'],3,'.',''), number_format($b['tot_weight'],3,'.',''), '', '']);
  } else {
    $b = build_stock($pdo, $company_id, ['yarn_type'=>$flt_type,'company'=>$flt_comp,'denier'=>$flt_denier,'color'=>$flt_color], $flt_stock_type, $hide_zero);
    fputcsv($out, ['Stock Type','Yarn Type','Company','Denier','Color','Current Boxes','Current Weight','AVG/Box','Status']);
    foreach ($b['rows'] as $v) {
      fputcsv($out, [
        $v['stock_type'], $v['yarn_type'], $v['company'], $v['denier'], $v['color'],
        number_format($v['cur_boxes'],3,'.',''),
        number_format($v['cur_weight'],3,'.',''),
        number_format($v['avg_per_box'],3,'.',''),
        $v['status']
      ]);
    }
    fputcsv($out, ['TOTAL','','','','', number_format($b['tot_boxes'],3,'.',''), number_format($b['tot_weight'],3,'.',''), '', '']);
  }
  fclose($out); exit;
}

/* ---------- PDF export (ALL view or single with stock_type param) ---------- */
if (isset($_GET['export']) && $_GET['export'] === 'pdf') {
  // PDF should respect filters (stock_type + show_zero)
  $companyName = resolve_company_name($pdo, $u, $company_id);
  $todayHuman  = date('d M Y');
  $flt_stock_type = trim($_GET['stock_type'] ?? 'All');
  if ($flt_stock_type === '') $flt_stock_type = 'All';
  $flt_show_zero = trim($_GET['show_zero'] ?? 'with_zero');
  $hide_zero = ($flt_show_zero === 'without_zero');

$b = build_stock($pdo, $company_id, ['yarn_type'=>trim($_GET['yarn_type'] ?? ''),'company'=>trim($_GET['company'] ?? ''),'denier'=>trim($_GET['denier'] ?? ''),'color'=>trim($_GET['color'] ?? '')], $flt_stock_type, $hide_zero);

// Build simple printable HTML, no header/footer
  ob_start();
  ?>
  <!doctype html>
  <html><head><meta charset="utf-8">
  <style>
    body{font-family:DejaVu Sans,Arial,Helvetica,sans-serif;font-size:12px;color:#202124;margin:18px}
    table{width:100%;border-collapse:collapse;margin-top:8px}
    th,td{border:1px solid #ddd;padding:6px 8px;text-align:left}
    th{background:#f6f8fa}
    .center{text-align:center}
    .right{text-align:right}
    h1,h2{margin:0;padding:0}
    .meta{margin:8px 0 18px;color:#444}
  </style>
  </head><body>
    <h1 class="center"><?=htmlspecialchars($companyName)?> Stock Report</h1>
    <div class="meta center">Date: <?=htmlspecialchars($todayHuman)?> &nbsp; | &nbsp; Stock Type: <?=htmlspecialchars($flt_stock_type)?> &nbsp; | &nbsp; Show Zero: <?=htmlspecialchars($flt_show_zero)?></div>
    <table>
      <thead><tr>
        <th>Stock Type</th><th>Yarn Type</th><th>Company</th><th>Denier</th><th>Color</th>
        <th class="right">Boxes</th><th class="right">Weight (kg)</th><th class="right">AVG/Box</th><th>Status</th>
      </tr></thead>
      <tbody>
        <?php if (!$b['rows']): ?>
          <tr><td colspan="9" class="center">No data.</td></tr>
        <?php else: foreach($b['rows'] as $v): ?>
          <tr>
            <td><?=htmlspecialchars($v['stock_type'])?></td>
            <td><?=htmlspecialchars($v['yarn_type'])?></td>
            <td><?=htmlspecialchars($v['company'])?></td>
            <td><?=htmlspecialchars($v['denier'])?></td>
            <td><?=htmlspecialchars($v['color'])?></td>
            <td class="right"><?=number_format($v['cur_boxes'],3)?></td>
            <td class="right"><?=number_format($v['cur_weight'],3)?></td>
            <td class="right"><?=number_format($v['avg_per_box'],3)?></td>
            <td><?=htmlspecialchars($v['status'])?></td>
          </tr>
        <?php endforeach; endif; ?>
      </tbody>
    </table>
    <div style="margin-top:12px;text-align:center">Total Boxes: <b><?=number_format($b['tot_boxes'],3)?></b> &nbsp; &nbsp; Total Weight: <b><?=number_format($b['tot_weight'],3)?></b></div>
  </body></html>
  <?php
  $html = ob_get_clean();

// Try dompdf if available, else render HTML for browser
  $dompdf_ok = false;
  foreach (['/vendor/autoload.php','/lib/dompdf/autoload.inc.php'] as $rel) {
    $p = __DIR__.$rel; if (is_file($p)) { require_once $p; $dompdf_ok = true; break; }
  }
  if (class_exists('\\Dompdf\\Dompdf')) $dompdf_ok = true;

if ($dompdf_ok) {
    $dompdf = new \Dompdf\Dompdf(['isRemoteEnabled'=>true,'isHtml5ParserEnabled'=>true]);
    $dompdf->loadHtml($html);
    $dompdf->setPaper('A4','portrait');
    $dompdf->render();
    $dompdf->stream('stock-report-'.date('Y-m-d').'.pdf', ['Attachment'=>true]);
    exit;
  } else {
    header('Content-Type: text/html; charset=utf-8');
    echo $html; exit;
  }
}

/* ---- Page heading dates ---- */
$todayPrint = date('d M Y');
$companyName = resolve_company_name($pdo, $u, $company_id);

/* ---- If print=1 then don't include header/footer (clean page for print) ---- */
?><!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Stock Report</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<?php if (!$print_only): ?>
  
  <link rel="stylesheet" href="/erp/public/assets/css/main.css?v=<?=date('Ymd')?>">
<?php else: ?>
  <style>
    /* minimal print styles */
    body{font-family:Arial,Helvetica,sans-serif;font-size:12px;color:#202124;margin:18px}
    table{width:100%;border-collapse:collapse;margin-top:8px}
    th,td{border:1px solid #ddd;padding:6px 8px;text-align:left}
    th{background:#f6f8fa}
    .center{text-align:center}
    .right{text-align:right}
  </style>
<?php endif; ?>
</head>
<body>
<?php if ($USE_HEADER) { $header_path = __DIR__ . '/partials/header.php'; if (file_exists($header_path)) include $header_path; } ?>

<div class="wrap" style="max-width:1100px;margin:18px auto;padding:12px">
  <div class="card">
    <div style="display:flex;justify-content:space-between;align-items:center;gap:12px;flex-wrap:wrap">
      <h2 style="margin:0">Stock Reports</h2>

<div>
        
        <a class="btn" href="?<?=http_build_query(array_merge($_GET,['view'=>'single','print'=>0]))?>">Single View</a>
        <a class="btn" href="?<?=http_build_query(array_merge($_GET,['view'=>'all','print'=>0]))?>">All Reports</a>
      </div>
    </div>

<form method="get" id="fltForm" style="margin-top:12px;display:flex;gap:10px;flex-wrap:wrap;align-items:center">
      <input type="hidden" name="view" value="<?=htmlspecialchars($view)?>">
      <label>Stock Type
        <select name="stock_type" onchange="this.form.submit()">
          <?php foreach(['All','Yarn','TFO','TPM','Zari'] as $s): $sel = ($s===$flt_stock_type)?'selected':''; ?>
            <option <?=$sel?>><?=htmlspecialchars($s)?></option>
          <?php endforeach; ?>
        </select>
      </label>

<label>Yarn Type
        <select name="yarn_type" onchange="this.form.submit()">
          <option value="">— All —</option>
          <?php foreach($opts_type as $v){ $sel=($v===$flt_type)?'selected':''; echo "<option value=\"".htmlspecialchars($v)."\" $sel>".htmlspecialchars($v)."</option>"; } ?>
        </select>
      </label>

<label>Company
        <select name="company" onchange="this.form.submit()">
          <option value="">— All —</option>
          <?php foreach($opts_comp as $v){ $sel=($v===$flt_comp)?'selected':''; echo "<option value=\"".htmlspecialchars($v)."\" $sel>".htmlspecialchars($v)."</option>"; } ?>
        </select>
      </label>

<label>Denier
        <select name="denier" onchange="this.form.submit()">
          <option value="">— All —</option>
          <?php foreach($opts_denier as $v){ $sel=($v===$flt_denier)?'selected':''; echo "<option value=\"".htmlspecialchars($v)."\" $sel>".htmlspecialchars($v)."</option>"; } ?>
        </select>
      </label>

<label>Color
        <select name="color" onchange="this.form.submit()">
          <option value="">— All —</option>
          <?php foreach($opts_color as $v){ $sel=($v===$flt_color)?'selected':''; echo "<option value=\"".htmlspecialchars($v)."\" $sel>".htmlspecialchars($v)."</option>"; } ?>
        </select>
      </label>

<label>Show Zero
        <select name="show_zero" onchange="this.form.submit()">
          <option value="with_zero" <?=($flt_show_zero==='with_zero')?'selected':''?>>With Zero</option>
          <option value="without_zero" <?=($flt_show_zero==='without_zero')?'selected':''?>>Without Zero</option>
        </select>
      </label>

<div style="display:flex;gap:8px;align-items:center">
        <button class="btn primary" type="submit">Apply</button>
        <a class="btn ghost" href="?<?=http_build_query(array_merge($_GET,['export'=>'csv']))?>">Export CSV</a>
        <a class="btn" href="?<?=http_build_query(array_merge($_GET,['export'=>'pdf']))?>" target="_blank">Export PDF</a>
        <a class="btn" href="?<?=http_build_query(array_merge($_GET,['print'=>1]))?>" target="_blank">Print (clean)</a>
      </div>
    </form>

<?php
      // Build stock based on filters
      $hide_zero = ($flt_show_zero === 'without_zero');
      $b = build_stock($pdo, $company_id, ['yarn_type'=>$flt_type,'company'=>$flt_comp,'denier'=>$flt_denier,'color'=>$flt_color], $flt_stock_type, $hide_zero);
    ?>

<div style="margin-top:14px">
      <div><strong><?=htmlspecialchars($companyName)?> </strong> Stock Report (<?=htmlspecialchars($todayPrint)?>)</div>
      <div class="totals" style="margin-top:6px">Total Boxes: <b><?=number_format($b['tot_boxes'],3)?></b> &nbsp; &nbsp; Total Weight (kg): <b><?=number_format($b['tot_weight'],3)?></b></div>
    </div>

<table class="stock-table" style="margin-top:12px">
      <thead>
        <tr>
          <th>Stock Type</th><th>Yarn Type</th><th>Company</th><th>Denier</th><th>Color</th>
          <th style="text-align:right">Boxes</th>
          <th style="text-align:right">Weight (kg)</th>
          <th style="text-align:right">AVG/Box</th>
          <th>Status</th>
        </tr>
      </thead>
      <tbody>
        <?php if(empty($b['rows'])): ?>
          <tr><td colspan="9" style="color:#777">No data.</td></tr>
        <?php else: foreach($b['rows'] as $v): 
          $pillClass='pill ok'; if($v['status']==='Check') $pillClass='pill warn'; if($v['status']==='Empty') $pillClass='pill bad'; ?>
          <tr data-boxes-in="<?=htmlspecialchars($v['_boxes_in'])?>" data-weight-in="<?=htmlspecialchars($v['_weight_in'])?>" data-boxes-out="<?=htmlspecialchars($v['_boxes_out'])?>" data-weight-out="<?=htmlspecialchars($v['_weight_out'])?>">
            <td><?=htmlspecialchars($v['stock_type'])?></td>
            <td><?=htmlspecialchars($v['yarn_type'])?></td>
            <td><?=htmlspecialchars($v['company'])?></td>
            <td><?=htmlspecialchars($v['denier'])?></td>
            <td><?=htmlspecialchars($v['color'])?></td>
            <td style="text-align:right"><?=number_format($v['cur_boxes'],3)?></td>
            <td style="text-align:right"><?=number_format($v['cur_weight'],3)?></td>
            <td style="text-align:right"><?=number_format($v['avg_per_box'],3)?></td>
            <td><span class="<?= $pillClass ?>"><?=htmlspecialchars($v['status'])?></span></td>
          </tr>
        <?php endforeach; endif; ?>
      </tbody>
    </table>

</div>
</div>

<?php
if ($USE_HEADER) {
  $footer_path = __DIR__ . '/partials/footer.php';
  if (file_exists($footer_path)) include $footer_path;
}
?>
</body>
</html>