<?php require dirname(__DIR__).'/app/core.php';require_login();$x=$pdo->query("SELECT (SELECT COUNT(*) FROM afguards) assets,(SELECT COUNT(*) FROM recertification_workflows WHERE workflow_status IN('Awaiting Test','Testing')) lab,(SELECT COUNT(*) FROM shipments WHERE shipping_status='Required') shipping")->fetch();$title='Dashboard';require dirname(__DIR__).'/views/head.php';?><h1>Dashboard</h1><div class="cards"><a class="card" href="assets.php">Sensors<b><?=$x['assets']?></b></a><a class="card" href="recertification.php">Lab Queue<b><?=$x['lab']?></b></a><a class="card" href="shipping.php">Shipping<b><?=$x['shipping']?></b></a></div><?php require dirname(__DIR__).'/views/foot.php';?>