<?php
declare(strict_types=1);
require_once __DIR__.'/../shared/lib/login_attendance.php';
function verify_attendance($ok){if(!$ok)throw new RuntimeException('Attendance assertion failed');}
$now=new DateTimeImmutable('2026-10-16 12:00:00',new DateTimeZone('Africa/Lusaka'));
$days=attendance_days('2026-10','2026-10-12','2026-10-13',['2026-10-14'=>'2026-10-14 06:00:00'],$now);verify_attendance(count($days)===31);verify_attendance($days[11]['status']==='not_tracked');verify_attendance($days[12]['status']==='absent');verify_attendance($days[13]['status']==='present');verify_attendance($days[15]['status']==='pending');verify_attendance($days[16]['status']==='upcoming');
$closed=attendance_days('2026-10','2026-10-12','2026-10-13',[],new DateTimeImmutable('2026-11-01 00:00:00',new DateTimeZone('Africa/Lusaka')));verify_attendance($closed[30]['status']==='absent');verify_attendance(!in_array('pending',array_column($closed,'status'),true));
verify_attendance(count(attendance_days('2024-02','2024-02-01','2024-02-01',[],$now))===29);
foreach(['staff','admin'] as $role)verify_attendance(attendance_scope(['id'=>1,'role'=>$role])===['1=1',[]]);verify_attendance(attendance_scope(['id'=>7,'role'=>'student'])===['s.user_id=?',[7]]);verify_attendance(str_contains(attendance_scope(['id'=>9,'role'=>'hod'])[0],'hod_assignments'));
try{attendance_days('2026-13','2026-01-01','2026-01-01',[],$now);throw new RuntimeException('Invalid month accepted');}catch(InvalidArgumentException $e){}
$utc=new DateTimeImmutable('2026-10-16 22:05:00',new DateTimeZone('UTC'));verify_attendance($utc->setTimezone(new DateTimeZone('Africa/Lusaka'))->format('Y-m-d')==='2026-10-17');
echo "PASS: daily statuses, enrollment/tracking boundaries, month closure, leap year, Zambia midnight and role scopes.\n";
class AttendanceMemoryDb {
 public array $snapshots=[],$activity=[],$loginWrites=[];
 function prepare($sql){return new AttendanceMemoryQuery($this,$sql);}
}
class AttendanceMemoryQuery {
 public array $args=[];
 function __construct(public AttendanceMemoryDb $database,public string $sql){}
 function execute($args){$this->args=$args;if(str_contains($this->sql,'INSERT IGNORE INTO student_login_receipts'))$this->database->snapshots[$args[0].':'.$args[1]]??=$args[3];if(str_contains($this->sql,'INSERT IGNORE INTO student_login_days'))$this->database->loginWrites[]=$args;}
 function fetchColumn(){return $this->database->snapshots[$this->args[0].':'.$this->args[1]]??false;}
 function fetchAll(){return $this->database->activity;}
}
$memory=new AttendanceMemoryDb();function db(){return $GLOBALS['memory'];}
$_SESSION=[];record_student_login(['id'=>5,'role'=>'staff']);verify_attendance(count($memory->loginWrites)===0);record_student_login(['id'=>5,'role'=>'student']);record_student_login(['id'=>5,'role'=>'student']);verify_attendance(count($memory->loginWrites)===1);
$student=['user_id'=>5,'created_at'=>'2026-10-01 00:00:00','full_name'=>'Student','student_number'=>'S5','campus_name'=>'Ndola','department_name'=>'ICT'];$memory->activity=[['attendance_date'=>'2026-10-14','first_seen_at'=>'2026-10-14 07:00:00']];
$nextMonth=new DateTimeImmutable('2026-11-01',new DateTimeZone('Africa/Lusaka'));$r=attendance_receipt($student,'2026-10','2026-10-01',$nextMonth);verify_attendance($r['closed']&&$r['present']===1&&$r['absent']===30);$memory->activity=[];$student['full_name']='Changed name';$saved=attendance_receipt($student,'2026-10','2026-10-01',$nextMonth);verify_attendance($saved===$r);verify_attendance(count($memory->snapshots)===1);
echo "PASS: daily activity deduplication, staff views do not record student logins and closed snapshots remain immutable.\n";
