33 lines
1.4 KiB
PHP
33 lines
1.4 KiB
PHP
<?php
|
|
require_once 'includes/db_hosoffice.php';
|
|
$completed_cids = [];
|
|
$sql = "SELECT a.HR_CID, e.HR_PREFIX_NAME, a.HR_FNAME, a.HR_LNAME,
|
|
p.HR_POSITION_NAME,
|
|
COALESCE(d.HR_DEPARTMENT_SUB_SUB_NAME, d2.HR_DEPARTMENT_SUB_NAME, '-') as DEPARTMENT_NAME
|
|
FROM hr_person a
|
|
LEFT OUTER JOIN hr_prefix e ON a.HR_PREFIX_ID=e.HR_PREFIX_ID
|
|
LEFT OUTER JOIN hr_position p ON a.HR_POSITION_ID=p.HR_POSITION_ID
|
|
LEFT OUTER JOIN hr_department_sub d2 ON a.HR_DEPARTMENT_SUB_ID=d2.HR_DEPARTMENT_SUB_ID
|
|
LEFT OUTER JOIN hr_department_sub_sub d ON a.HR_DEPARTMENT_SUB_SUB_ID=d.HR_DEPARTMENT_SUB_SUB_ID
|
|
WHERE a.HR_STATUS_ID = '01' ORDER BY DEPARTMENT_NAME, a.HR_FNAME";
|
|
$stmt_un = $pdo_hos->query($sql);
|
|
$unassessed_users = $stmt_un->fetchAll(PDO::FETCH_ASSOC);
|
|
|
|
$data = [];
|
|
$no = 1;
|
|
foreach($unassessed_users as $u) {
|
|
$fullname = trim(($u['HR_PREFIX_NAME'] ?? '') . $u['HR_FNAME'] . ' ' . $u['HR_LNAME']);
|
|
$data[] = [
|
|
'<div class="text-center">'.$no++.'</div>',
|
|
htmlspecialchars($fullname),
|
|
htmlspecialchars($u['HR_POSITION_NAME'] ?? '-'),
|
|
htmlspecialchars($u['DEPARTMENT_NAME'] ?? '-')
|
|
];
|
|
}
|
|
$json = json_encode(["data" => $data, "count" => count($data)]);
|
|
if ($json === false) {
|
|
echo "JSON Encode Error: " . json_last_error_msg() . "\n";
|
|
} else {
|
|
echo "JSON OK, length: " . strlen($json) . "\n";
|
|
}
|