dwh/audit_trail_plugin.php

<?php
$PARENT_SCRIPTNAME='audit_trail.php';
include_once 'script_auth.php';

include_once 'class/PregReplaceCallbackClass.php';
include_once 'init/initialisation_parameter.php';
include_once 'incl.php';
include_once 'incl_rep.php';

$ora_obj = new ORAConnectionClass('init/ORA_INIT.php');
$ora_res = $ora_obj->ORA_PConnect();
if (!$ora_res){
    echo "<BR>Error : " . htmlspecialchars($ora_obj->last_error_msg) . "<br>";
    exit();
}
initParamTemplate();

$result = prepare($ora_obj);
echo $result;

unset($_SESSION['TEMPLATE_ARRAY_ADDR']);
if ($ora_obj->conn) {
    $ora_obj->ORA_Close();
    #echo "connection closed.<br>";
}

function initParamTemplate(){
    $paramTemplate['CONTAINER'] = <<< params
    <table width="100%" cellpadding="2" cellspacing="1" border="0" style="layout:auto">
        <span id="PARAM"><<PARAM>></span>
    </table>
params;

    $paramTemplate['PARAM'] = <<< params
    <tr>
        <td align=left class="orangetitle" nowrap>Audit Trail</td>
        <td align=right>
            <input type="hidden" name="ACTION" dbname="">
        </td>
    </tr>
    <tr>
        <td>
        <form name="rep_param">
        <table width="65%" cellpadding="2" cellspacing="1" border="0" style="layout:auto" class="font11">
            <tr>
                <td align=left>Group Data</td>
                <td>:</td>
                <td align=left>
                    <SELECT NAME="GROUP" class="font11" note="Group Data" ATTRIB="SM" dbname="GROUP_DATA" display="block">
                        <<OPTION_GROUP>>
                    </SELECT>
                </td>
            </tr>
            <tr>
                <td align=left>Periode Audit</td>
                <td>:</td>
                <td align=left>
                    <input type="text" name="TGL_AWAL" value="<<BOM>>" note="Tanggal Awal" ATTRIB="DM" dbname="TGL_AWAL" readonly display="block" class="font11" onclick="javascript:displayCalendar(this,'dd-mm-yyyy',this);">                
                    s/d 
                    <input type="text" name="TGL_AKHIR" value="<<EOM>>" note="Tanggal Akhir" ATTRIB="DM" dbname="TGL_AKHIR" readonly display="block" class="font11" onclick="javascript:displayCalendar(this,'dd-mm-yyyy',this);">
                </td>
            </tr>
            <tr>
                <td align=left>Aktifitas</td>
                <td>:</td>
                <td align=left>
                    <input type="text" name="ACTIVITY" note="Aktifitas" ATTRIB="S-" class="font11" dbname="ACTIVITY">
                </td>
            </tr>
            <tr>
                <td align=left>Jml Baris per Halaman</td>
                <td>:</td>
                <td align=left>
                    <input type="text" name="NUM_ROWS" value="<<REP_LINES>>" note="Jml Baris" ATTRIB="NM" class="font11" dbname="NUM_ROWS" display="block">
                </td>
            </tr>
            <tr>
                <td colspan=5>
                    <button id="SUBMIT_BTN" name="executeReport" dbname="" onclick="javascript:execute_report();">
                        <img src="images/button_execute.gif" width="12" height="12">
                        <span class="font11">&nbsp;Execute</span>
                    </button>
                </td>
            </tr>
        </table>
        </form>
        </td>
    </tr>
params;

    $_SESSION['TEMPLATE_ARRAY_ADDR'] = &$paramTemplate;
}

function prepare(&$ora_obj){
    $templObj = new PregReplaceCallbackClass('');
    $templObj->SetTemplateArray('TEMPLATE_ARRAY_ADDR');
    
    $variable_array['PARAM'] = build_param($ora_obj);
    $_SESSION['ARRAY_ADDR_VAR'] = &$variable_array;
    $templObj->SetFormatName('CONTAINER');
    $list = $templObj->PregReplaceCallback();
    return $list; 
}

function build_param (&$ora_obj) {
    $templObj = new PregReplaceCallbackClass('');
    $templObj->SetTemplateArray('TEMPLATE_ARRAY_ADDR');
    
    $groupHash = get_group_audit($ora_obj);
    $OPTION_GROUP = format_html_option($groupHash);

    $bom = show_tanggal("BOY");
    $eom = show_tanggal("C");

    $_SESSION['ARRAY_ADDR_VAR'] = &$variable_array;    
    $variable_array['OPTION_GROUP'] = $OPTION_GROUP;
    $variable_array['BOM'] = $bom;
    $variable_array['EOM'] = $eom;
    $variable_array['REP_LINES'] = REP_LINES;
    $templObj->SetFormatName('PARAM');
    $result = $templObj->PregReplaceCallback();

    return $result;
}

function get_group_audit(&$ora_obj) {
    $MultiDArrayFixed = null;
    $stmt = "SELECT param_id, keterangan FROM auditparam UNION SELECT 'ALL', 'SEMUA' FROM DUAL 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['PARAM_ID'][$p_key];
                $MultiDArrayFixed[$group_key] = $MultiDArray['KETERANGAN'][$p_key];
            }
        }
    }
    return $MultiDArrayFixed;
}


?>