X
ORA_PConnect();
if (!$ora_res){
echo "
Error : " . htmlspecialchars($ora_obj->last_error_msg) . "
";
exit();
}
initAjaxParamTemplate($_REQUEST['action']);
if ($_REQUEST['action'] == "getList") {
$result = getList($ora_obj);
} else {
$result = -1;
}
echo $result;
unset($_SESSION['TEMPLATE_ARRAY_ADDR']);
if ($ora_obj->conn) {
$ora_obj->ORA_Close();
#echo "connection closed.
";
}
function initAjaxParamTemplate($action) {
if ($action == "getList") {
$ajaxParamTemplate['HEADLIST'] = <<< params
params;
$ajaxParamTemplate['ELEMENT'] = <<< params
<>. |
<> |
<> <> |
<> |
<> <> |
<> |
<> <> |
<> |
params;
$ajaxParamTemplate['ELEMENT_NORESULT'] = <<< params
NO DATA FOUND |
params;
}
$_SESSION['TEMPLATE_ARRAY_ADDR'] = &$ajaxParamTemplate;
}
function getList(&$ora_obj){
$templObj = new PregReplaceCallbackClass('');
$templObj->SetTemplateArray('TEMPLATE_ARRAY_ADDR');
$paramSQL = <<< sql
SELECT job_id, user_posting, ipnum,
to_char(date_posting, 'DD-MM-YYYY') date_posting,
to_char(date_posting, 'HH24:MI:SS') time_posting,
(CASE WHEN status=0 THEN 'PROCESSING' WHEN status=1 THEN 'DONE' ELSE 'FAILED' END) status,
to_char(date_finished, 'DD-MM-YYYY') date_finished,
to_char(date_finished, 'HH24:MI:SS') time_finished,
(SELECT nama_user FROM v_prm_user WHERE kd_user = user_posting) nama_user,
err_msg
FROM transaction_job t, transaction_id g
WHERE t.process_id = g.process_id
AND g.process_id = {$_REQUEST['PROCESS_ID']}
ORDER BY t.job_id desc
sql;
$paramArray = $ora_obj->ORA_SelectData($paramSQL,null,null,OCI_FETCHSTATEMENT_BY_ROW);
$_SESSION['ARRAY_ADDR_VAR'] = &$variable_array;
if ($ora_obj->nrows>0) {
foreach ($paramArray as $pkey => $pval) {
$variable_array['COUNTER']++;
foreach ($pval as $tkey => $tval) {
$variable_array[$tkey] = htmlspecialchars($tval);
}
$templObj->SetFormatName('ELEMENT');
$list .= $templObj->PregReplaceCallback();
}
$variable_array['LIST'] = $list;
$templObj->SetFormatName('HEADLIST');
$result = $templObj->PregReplaceCallback();
} else {
$templObj->SetFormatName('ELEMENT_NORESULT');
$list = $templObj->PregReplaceCallback();
$variable_array['LIST'] = $list;
$templObj->SetFormatName('HEADLIST');
$result = $templObj->PregReplaceCallback();
}
return $result;
}
?>