[]]);
exit;
}
require_once '../includes/db_assessment.php';
require_once '../includes/db_hosoffice.php';
$filter_year = $_GET['year'] ?? (date('Y')+543);
$rules = $pdo_assess->query("SELECT id FROM it_rules ORDER BY order_no ASC")->fetchAll(PDO::FETCH_ASSOC);
$slas = $pdo_assess->query("SELECT id FROM it_slas ORDER BY order_no ASC")->fetchAll(PDO::FETCH_ASSOC);
$assessments = [];
try {
$stmt = $pdo_assess->prepare("SELECT * FROM it_assessments WHERE assess_year = :year ORDER BY created_at DESC");
$stmt->execute(['year' => $filter_year]);
$assessments = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (Exception $e) { }
$data = [];
$no = 1;
foreach ($assessments as $row) {
$rules_data = json_decode($row['rules_data'], true) ?: [];
$sla_data = json_decode($row['sla_data'], true) ?: [];
$rowData = [];
$rowData[] = ''.$no++.'
';
$rowData[] = ''.htmlspecialchars($row['assess_year']).'
';
$rowData[] = htmlspecialchars($row['fullname']);
$rowData[] = htmlspecialchars($row['position']);
$rowData[] = htmlspecialchars($row['department']);
if($row['computer_use'] == '1'){
$rowData[] = 'ใช้
';
} else {
$rowData[] = 'ไม่ใช้
';
}
foreach($rules as $r){
$r_id = $r['id'];
$k = $rules_data[$r_id]['k'] ?? '-';
$u = $rules_data[$r_id]['u'] ?? '-';
$p = $rules_data[$r_id]['p'] ?? '-';
$rowData[] = ''.($k == 'yes' ? '✔️' : ($k == 'no' ? '❌' : '-')).'
';
$rowData[] = ''.($u == 'yes' ? '✔️' : ($u == 'no' ? '❌' : '-')).'
';
$rowData[] = ''.($p == 'yes' ? '✔️' : ($p == 'no' ? '❌' : '-')).'
';
}
foreach($slas as $s){
$s_id = $s['id'];
$score = $sla_data[$s_id]['score'] ?? '-';
$comment = $sla_data[$s_id]['comment'] ?? '-';
$rowData[] = ''.htmlspecialchars($score).'
';
$rowData[] = htmlspecialchars($comment);
}
$rowData[] = ''.date('d/m/Y H:i', strtotime($row['created_at'])).'
';
$deleteForm = '';
$rowData[] = $deleteForm;
$data[] = $rowData;
}
ob_clean(); header("Content-Type: application/json; charset=utf-8"); echo json_encode(["data" => $data]);