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); } elseif ($_REQUEST['action'] == "newData") { $result = newData($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 == "getData") { $ajaxParamTemplate['TABLEDATA'] = <<< params

<>
Nama Table	:
Modul	:	<>
Methode Posting	:	<>
Proses Purging	:	<>
Field untuk Purging	:
Tipe Data Field untuk Purging	:	<>
<>

params; } else { $ajaxParamTemplate['TABLEDATA'] = <<< params

Nama Table	:
Modul	:	<>
Methode Posting	:	<>
Proses Purging	:	<>
Field untuk Purging	:
Tipe Data Field untuk Purging	:	<>
<>

params; } $_SESSION['TEMPLATE_ARRAY_ADDR'] = &$ajaxParamTemplate; } function getData(&$ora_obj){ $templObj = new PregReplaceCallbackClass(''); $templObj->SetTemplateArray('TEMPLATE_ARRAY_ADDR'); $paramSQL = <<< sql SELECT i.tab_name, i.purging_type, i.modul, i.purging_field, i.purging_data_type, i.purging_filter, i.method FROM external_data_tab i WHERE i.tab_name = '{$_REQUEST['TAB_NAME']}' ORDER BY i.tab_name sql; $paramArray = $ora_obj->ORA_SelectData($paramSQL,null,null,OCI_FETCHSTATEMENT_BY_ROW); if ($ora_obj->nrows>0) { $flagModul = Option_Modul(); $OPTION_MODUL = format_html_option($flagModul, $paramArray[0]['MODUL']); $flagPurgingType = Option_Ya_Tidak(); $OPTION_PURGING_TYPE = format_html_option($flagPurgingType, $paramArray[0]['PURGING_TYPE']); $flagDataType = Option_DataType(); $OPTION_PURGING_DATA_TYPE = format_html_option($flagDataType, $paramArray[0]['PURGING_DATA_TYPE']); $flagMethod = Option_Method(); $OPTION_METHOD = format_html_option($flagMethod, $paramArray[0]['METHOD']); $_SESSION['ARRAY_ADDR_VAR'] = &$variable_array; $templObj->SetFormatName('TABLEDATA'); foreach ($paramArray as $pkey => $pval) { foreach ($pval as $rkey => $rval) { $variable_array[$rkey] = htmlspecialchars($rval); } $variable_array['BUTTON_CONTAINER'] = create_button('0'); $variable_array['READ_ONLY'] = ''; $variable_array['OPTION_MODUL'] = $OPTION_MODUL; $variable_array['OPTION_METHOD'] = $OPTION_METHOD; $variable_array['OPTION_PURGING_TYPE'] = $OPTION_PURGING_TYPE; $variable_array['OPTION_PURGING_DATA_TYPE'] = $OPTION_PURGING_DATA_TYPE; $result .= $templObj->PregReplaceCallback(); } } else { $result = -1; } return $result; } function newData(&$ora_obj){ $templObj = new PregReplaceCallbackClass(''); $templObj->SetTemplateArray('TEMPLATE_ARRAY_ADDR'); $flagModul = Option_Modul(); $OPTION_MODUL = format_html_option($flagModul); $flagMethod = Option_Method(); $OPTION_METHOD = format_html_option($flagMethod); $flagPurgingType = Option_Ya_Tidak(); $OPTION_PURGING_TYPE = format_html_option($flagPurgingType); $flagDataType = Option_DataType(); $OPTION_PURGING_DATA_TYPE = format_html_option($flagDataType); $_SESSION['ARRAY_ADDR_VAR'] = &$variable_array; $templObj->SetFormatName('TABLEDATA'); $variable_array['OPTION_MODUL'] = $OPTION_MODUL; $variable_array['OPTION_METHOD'] = $OPTION_METHOD; $variable_array['OPTION_PURGING_TYPE'] = $OPTION_PURGING_TYPE; $variable_array['OPTION_PURGING_DATA_TYPE'] = $OPTION_PURGING_DATA_TYPE; $variable_array['BUTTON_CONTAINER'] = create_button('1'); $result .= $templObj->PregReplaceCallback(); return $result; } ?>