ORA_PConnect(); if (!$ora_res){ echo "
Error : " . htmlspecialchars($ora_obj->last_error_msg) . "
"; exit(); } initParamTemplate(); $result = getList($ora_obj); echo $result; unset($_SESSION['TEMPLATE_ARRAY_ADDR']); if ($ora_obj->conn) { $ora_obj->ORA_Close(); #echo "connection closed.
"; } function initParamTemplate(){ $paramTemplate['CONTAINER'] = <<< params

Log Proses			Print
Jenis Proses : <>    Refresh Data

params; $_SESSION['TEMPLATE_ARRAY_ADDR'] = &$paramTemplate; } function getList(&$ora_obj) { $templObj = new PregReplaceCallbackClass(''); $templObj->SetTemplateArray('TEMPLATE_ARRAY_ADDR'); $GroupHash = get_process($ora_obj); $OPTION_GROUP = format_html_option($GroupHash); $_SESSION['ARRAY_ADDR_VAR'] = &$variable_array; $templObj->SetFormatName('CONTAINER'); $variable_array['OPTION_GROUP'] = $OPTION_GROUP; $result .= $templObj->PregReplaceCallback(); return $result; } function get_process(&$ora_obj) { $MultiDArrayFixed = null; $stmt = "SELECT process_id, process_desc FROM transaction_id ORDER BY 1"; $MultiDArray = $ora_obj->ORA_SelectData($stmt); if ($ora_obj->nrows >0) { foreach ($MultiDArray as $key => $val) { foreach ($val as $p_key => $p_val) { $group_key = $MultiDArray['PROCESS_ID'][$p_key]; $MultiDArrayFixed[$group_key] = $MultiDArray['PROCESS_DESC'][$p_key]; } } } return $MultiDArrayFixed; } ?>