<?php require dirname(__DIR__).'/app/core.php';$rows=$pdo->query("SELECT a.*,c.name client,co.name country FROM afguards a LEFT JOIN clients c ON c.id=a.owner_client_id LEFT JOIN countries co ON co.code=c.country_code ORDER BY a.serial_number")->fetchAll();$title='Assets';require dirname(__DIR__).'/views/head.php';?><h1>Assets</h1><div class="toolbar"><a class="btn" href="<?=e(u('asset-form.php'))?>">Add Sensor</a><a class="btn secondary" href="<?=e(u('asset-export.php'))?>">Export CSV</a></div><div class="wrap"><table><tr><th>Serial</th><th>Owned By</th><th>Client</th><th>Country</th><th>Model</th><th>Condition</th><th>Designation</th><th>Location</th><th>Annual Expiration</th><th>Action</th></tr><?php foreach($rows as $a):?><tr><td><?=e($a['serial_number'])?></td><td><?=e(ucfirst($a['owned_by']))?></td><td><?=e($a['client']??'—')?></td><td><?=e($a['country']??'—')?></td><td><?=e($a['model'])?></td><td><?=e($a['asset_condition'])?></td><td><?=e($a['designation']??'—')?></td><td><?=e($a['current_location'])?></td><td><?=e($a['recertification_expiration_date']??'—')?></td><td><a href="<?=e(u('asset-form.php?id='.(int)$a['id']))?>">Edit</a></td></tr><?php endforeach;?></table></div><?php require dirname(__DIR__).'/views/foot.php';?>