ORA_PConnect(); if (!$ora_res){ echo "
Error : " . htmlspecialchars($ora_obj->last_error_msg) . "
"; exit(); } initAjaxParamTemplate($_REQUEST['action']); if ($_REQUEST['action'] == "getData") { $result = getData($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) { $ajaxParamTemplate['TABLEDATA'] = <<< params

<>
Parameter	:
Tipe Data	:
Nilai	:	> dbname="PARAMVALUE" display="block" class="font11" onkeyup='javascript:chgAttr(DATAFORM.saveData)'><<PARAMVALUE>>
<>

params; $_SESSION['TEMPLATE_ARRAY_ADDR'] = &$ajaxParamTemplate; } function getData(&$ora_obj){ $templObj = new PregReplaceCallbackClass(''); $templObj->SetTemplateArray('TEMPLATE_ARRAY_ADDR'); $paramSQL = <<< sql SELECT paramid, paramdesc, paramvalue, paramtype, decode(paramtype, 'N', 'Numeric', 'I', 'Integer', 'S', 'String', 'D','Date', 'Character') typedesc, TO_CHAR(tgl_update, 'YYYYMMDDHH24MISS') tgl_update FROM prm_system WHERE paramid = '{$_REQUEST['PARAMID']}' sql; $paramArray = $ora_obj->ORA_SelectData($paramSQL,null,null,OCI_FETCHSTATEMENT_BY_ROW); if ($ora_obj->nrows > 0) { $_SESSION['ARRAY_ADDR_VAR'] = &$variable_array; $templObj->SetFormatName('TABLEDATA'); foreach ($paramArray as $pkey => $pval) { foreach ($pval as $rkey => $rval) { $variable_array[$rkey] = htmlspecialchars($rval); } if ($variable_array['TGL_UPDATE'] <> $_REQUEST['LAST_TGL_UPDATE']) { $variable_array['ERR_MSG'] = 'Data Sudah Diubah oleh user lain. Close untuk refresh'; $variable_array['BUTTON_CONTAINER'] = create_button('3'); $variable_array['READ_ONLY'] = 'readonly'; } else { $variable_array['BUTTON_CONTAINER'] = create_button('2'); $variable_array['READ_ONLY'] = ''; } $result .= $templObj->PregReplaceCallback(); } } else { $result = -1; } return $result; } ?>