<?php require dirname(__DIR__).'/app/core.php';$rows=$pdo->query("SELECT r.designated_at,r.workflow_type,a.serial_number FROM recertification_workflows r JOIN afguards a ON a.id=r.afguard_id WHERE r.workflow_status IN('Received','Awaiting Test','Testing') ORDER BY r.designated_at,a.serial_number")->fetchAll();$annual=count(array_filter($rows,fn($x)=>$x['workflow_type']==='Annual Recertification'));?><!doctype html><html><head><meta charset="utf-8"><meta name="viewport" content="width=device-width"><meta http-equiv="refresh" content="30"><title>Lab Board</title><link rel="stylesheet" href="<?=e(u('assets/board.css'))?>"></head><body><main><header><div><small>AFGUARD TRACKING</small><h1>Recertification Laboratory</h1></div><div class="clock"><span id="date"></span><b id="time"></b></div></header><section class="summary"><span>Sensors in laboratory queue</span><strong><?=count($rows)?></strong><em>ANNUAL <?=$annual?> · INTERIM <?=count($rows)-$annual?></em></section><?php foreach($rows as $i=>$x):?><article class="sensor <?=$i===0?'oldest':''?>"><div><b><?=e($x['serial_number'])?></b><i class="<?=$x['workflow_type']==='Annual Recertification'?'annual':'interim'?>"><?=$x['workflow_type']==='Annual Recertification'?'ANNUAL RECERT':'INTERIM RECERT'?></i></div><time data-start="<?=e($x['designated_at'])?>"></time></article><?php endforeach;?></main><script src="<?=e(u('assets/board.js'))?>"></script></body></html>