View Code - 20260721

mesr_stock_body.php | 20260721_154033.php Initial Bulk Import

<?php
/* ==========================================================
   MESR STOCK – BODY
   Used by: Screen / Print / PDF
   ========================================================== */

/* ================= KASAB STOCK ================= */
if ($section_type === 'kasab') {

$st = $pdo->prepare("
    SELECT
      location_id,
      machine_id,
      denier,
      color,
      total_roll,
      per_two_roll_weight,
      total_weight
    FROM mesr_kasab_stock
    WHERE company_id = ?
      AND month = ?
    ORDER BY id
  ");
  $st->execute([$company_id, $month]);

echo "<table class='table'><thead><tr>
    <th>Location</th>
    <th>Machine</th>
    <th>Denier</th>
    <th>Color</th>
    <th>Total Roll</th>
    <th>Per 2 Roll Wt</th>
    <th>Total Weight</th>
  </tr></thead><tbody>";

foreach ($st as $r) {
    echo "<tr>
      <td>".h($r['location_id'])."</td>
      <td>".h($r['machine_id'])."</td>
      <td>".h($r['denier'])."</td>
      <td>".h($r['color'])."</td>
      <td style='text-align:center'>".h($r['total_roll'])."</td>
      <td style='text-align:right'>".h($r['per_two_roll_weight'])."</td>
      <td style='text-align:right'>".h($r['total_weight'])."</td>
    </tr>";
  }

echo "</tbody></table>";

/* ================= YARN IN MACHINE ================= */
} elseif ($section_type === 'machine') {

$st = $pdo->prepare("
    SELECT machine_type,machine_id,denier,color,total_cons,per_cone_weight,empty_cone_weight
    FROM machine_in_yarn
    WHERE company_id=? AND month=?
  ");
  $st->execute([$company_id,$month]);

echo "<table class='table'><thead><tr>
    <th>Machine</th><th>Denier</th><th>Color</th>
    <th>Total Cons</th><th>Per Cone</th><th>Empty Cone</th>
  </tr></thead><tbody>";

foreach($st as $r){
    echo '<tr>
      <td>'.h($r['machine_type']).'</td>
      <td>'.h($r['denier']).'</td>
      <td>'.h($r['color']).'</td>
      <td>'.h($r['total_cons']).'</td>
      <td>'.h($r['per_cone_weight']).'</td>
      <td>'.h($r['empty_cone_weight']).'</td>
    </tr>';
  }
  echo "</tbody></table>";

}