<?php require dirname(__DIR__).'/app/core.php';$rows=$pdo->query("SELECT s.*,a.serial_number,d.name destination,c.name client FROM shipments s JOIN afguards a ON a.id=s.afguard_id LEFT JOIN shipping_destinations d ON d.id=s.destination_id LEFT JOIN clients c ON c.id=s.client_id WHERE s.shipping_status IN('Required','Preparing','Ready') ORDER BY s.record_created")->fetchAll();$title='Shipping';require dirname(__DIR__).'/views/head.php';?><h1>Shipping</h1><div class="wrap"><table><tr><th>Serial</th><th>Type</th><th>Destination</th><th>Sales Order</th><th>Voucher</th><th>Tracking / Action</th></tr><?php foreach($rows as $s):?><tr><td><?=e($s['serial_number'])?></td><td><?=e($s['shipment_type'])?></td><td><?=e($s['destination']??$s['client']??'Client')?></td><td><?=e($s['sales_order_number']??'—')?></td><td><?=e($s['voucher_number']??'Not required')?></td><td><form method="post" action="<?=e(u('ship-save.php'))?>"><input type="hidden" name="csrf" value="<?=e(token())?>"><input type="hidden" name="shipment_id" value="<?=$s['id']?>"><input name="tracking_number" required placeholder="Tracking number"><button>Mark Shipped</button></form></td></tr><?php endforeach;?></table></div><?php require dirname(__DIR__).'/views/foot.php';?>