<?php
require_once __DIR__.'/../shared/lib/graduation.php';
function check($v,$message){if(!$v)throw new RuntimeException($message);}
function denied($fn){try{$fn();}catch(InvalidArgumentException $e){return;}throw new RuntimeException('Invalid action accepted');}
$reason='Reviewed source and requirements in detail.';
check(graduation_transition('submitted','verify',$reason)==='verified','verification');
check(graduation_transition('verified','defence_pass',$reason)==='defended_pass','defence');
check(graduation_transition('defended_pass','approve',$reason)==='approved','approval');
foreach(['submitted','verified','defended_fail'] as $state)denied(fn()=>graduation_transition($state,'approve',$reason));
foreach(['submitted','verified','defended_fail','defended_pass'] as $state)check(graduation_transition($state,'reject',$reason)==='rejected','rejection');
foreach(['approved','rejected'] as $state)denied(fn()=>graduation_transition($state,'verify',$reason));
denied(fn()=>graduation_transition('submitted','reject','short'));
[$scope,$args]=graduation_scope(['role'=>'hod','id'=>7]);check(str_contains($scope,'department_id')&&!str_contains($scope,'campus'),'HOD all-campus department scope');
[$scope,$args]=graduation_scope(['role'=>'student','id'=>9]);check(str_contains($scope,'year_of_study')&&str_contains($scope,'department_id'),'student targeting');
check(graduation_scope(['role'=>'staff','id'=>1])[0]==='1=1','staff access');
denied(fn()=>graduation_datetime('2026-02-31T10:00:00Z',false));
denied(fn()=>graduation_datetime('2020-01-01T10:00:00Z',true));
check(graduation_datetime('2020-01-01T10:00:00Z',false)->format('H:i')==='10:00','UTC defence date');
echo "PASS: graduation transitions, mandatory reasons, role targeting and dates.\n";

check(graduation_can_delete(['id'=>1,'role'=>'staff'],9),'staff deletion');
check(graduation_can_delete(['id'=>1,'role'=>'admin'],9),'admin deletion');
check(graduation_can_delete(['id'=>9,'role'=>'hod'],9),'creator HOD deletion');
check(!graduation_can_delete(['id'=>8,'role'=>'hod'],9),'unrelated HOD blocked');
check(!graduation_can_delete(['id'=>9,'role'=>'student'],9),'student deletion blocked');
echo "PASS: deletion permission matrix.\n";

$columns=[];foreach(['graduation_requirements'=>['id','department_id','course_id','requirements','requirements_delta','deadline','created_by'],'graduation_requirement_years'=>['requirement_id','year_of_study'],'graduation_submissions'=>['project_id','requirement_id'],'graduation_reviews'=>['project_id','action'],'student_projects'=>['course_id']] as $table=>$fields)foreach($fields as $field)$columns[$table][$field]='YES';
check(graduation_schema_issues($columns)===[],'complete schema accepted');unset($columns['graduation_requirements']['requirements_delta']);$columns['graduation_requirements']['course_id']='NO';$issues=graduation_schema_issues($columns);check(in_array('graduation_requirements.requirements_delta',$issues,true),'missing editor column identified');check(in_array('graduation_requirements.course_id must allow NULL',$issues,true),'old course requirement identified');
check(str_contains(graduation_error_message(new RuntimeException('private SQL details',1054),'TEST'),'complete_repair.sql'),'schema failure actionable');check(!str_contains(graduation_error_message(new RuntimeException('private SQL details',999),'TEST'),'private SQL'),'SQL details withheld');
echo "PASS: original-only migration detected, complete schema accepted and actionable safe errors.\n";
