View Code - 20260721

pending_report.php | 20260721_154033.php Initial Bulk Import

<?php
$st = $pdo->prepare("
  SELECT psi.id, psi.bill_no, psi.bill_date,
         psi.party, psi.transport, psi.station
  FROM parcel_stock_in psi
  LEFT JOIN parcel_send_entry pse
    ON pse.company_id = psi.company_id
   AND psi.bill_no = pse.bill_no
  WHERE psi.company_id = ?
    AND pse.id IS NULL
    AND psi.cleared_unknown = 0
  ORDER BY psi.bill_date
");

$st->execute([$company_id]);

echo "<table class='table table-sm table-bordered table-striped'>
<thead>
<tr>
<th>Bill</th><th>Date</th><th>Party</th>
<th>Transport</th><th>Station</th><th>Action</th>
</tr>
</thead><tbody>";

foreach ($st as $r) {

echo "<tr>
      <td>".h($r['bill_no'])."</td>
      <td>".h($r['bill_date'])."</td>
      <td>".h($r['party'])."</td>
      <td>".h($r['transport'])."</td>
      <td>".h($r['station'])."</td>
      <td>
        <form method='post' action='parcel_clear.php'>
          <input type='hidden' name='id' value='".(int)$r['id']."'>
          <button class='btn btn-sm btn-success'>Clear</button>
        </form>
      </td>
    </tr>";
}

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