« Back to History
pending.php
|
20261118_125741.php
Initial Domain Snapshot
Copy Code
<?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'>"; echo "<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>";