PHP CCBuildSQL函數代碼示例

function Page_BeforeInitialize(&$sender)
{
    $Page_BeforeInitialize = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_status_pelaporan_transaksi;
    //Compatibility
    //End Page_BeforeInitialize
    //transaksi Initialization @686-17D9D5EC
    if ('t_status_pelaporan_transaksitransaksi' == CCGetParam('callbackControl')) {
        global $CCSLocales;
        $Service = new Service();
        $formatter = new TemplateFormatter();
        $formatter->SetTemplate(file_get_contents(RelativePath . "/trans/" . "t_status_pelaporan_transaksitransaksi.xml"));
        $Service->SetFormatter($formatter);
        //End transaksi Initialization
        //transaksi DataSource @686-6D3BDEF8
        $Service->DataSource = new clsDBConnSIKP();
        $Service->ds =& $Service->DataSource;
        $Service->DataSource->Parameters["urlp_finance_period_id"] = CCGetFromGet("p_finance_period_id", NULL);
        $Service->DataSource->wp = new clsSQLParameters();
        $Service->DataSource->wp->AddParameter("1", "urlp_finance_period_id", ccsFloat, "", "", $Service->DataSource->Parameters["urlp_finance_period_id"], 0, false);
        $Service->DataSource->SQL = "select STATUS_LAPOR , JML\n" . "from \n" . "(\n" . "select 'SUDAH LAPOR TRANSAKSI' as STATUS_LAPOR , count(*) as JML\n" . "from t_cust_account a\n" . "where exists (select 1 \n" . "  from t_cust_acc_dtl_trans x\n" . "  where x.t_cust_account_id = a.t_cust_account_id\n" . "\t\tand exists (select 1 from p_finance_period y where (trunc(x.trans_date) between trunc(y.start_date) and y.end_date) and y.p_finance_period_id = " . $Service->DataSource->SQLValue($Service->DataSource->wp->GetDBValue("1"), ccsFloat) . " --:periode_id dari pilihan\n" . "\t\t\t\t   ) \n" . "  )\n" . "UNION ALL\n" . "select 'BELUM LAPOR TRANSAKSI' as STATUS_LAPOR , count(*) as JML\n" . "from t_cust_account a\n" . "where not exists (select 1 \n" . "  from t_cust_acc_dtl_trans x\n" . "  where x.t_cust_account_id = a.t_cust_account_id\n" . "\t\tand exists (select 1 from p_finance_period y where (trunc(x.trans_date) between trunc(y.start_date) and y.end_date) and y.p_finance_period_id = " . $Service->DataSource->SQLValue($Service->DataSource->wp->GetDBValue("1"), ccsFloat) . " --:periode_id dari pilihan\n" . "\t\t\t\t   )\n" . "  )\n" . ")\n" . "";
        $Service->DataSource->Order = "";
        $Service->DataSource->PageSize = 25;
        $Service->SetDataSourceQuery($Service->DataSource->OptimizeSQL(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order)));
        //End transaksi DataSource
        //transaksi Execution @686-8C1C1AD2
        $Service->AddDataSetValue("Title", "Status Pelaporan Transaksi");
        $Service->AddHttpHeader("Cache-Control", "cache, must-revalidate");
        $Service->AddHttpHeader("Pragma", "public");
        $Service->AddHttpHeader("Content-type", "text/xml");
        $Service->DisplayHeaders();
        echo $Service->Execute();
        //End transaksi Execution
        //transaksi Tail @686-27890EF8
        exit;
    }
    //End transaksi Tail
    //Close Page_BeforeInitialize @1-23E6A029
    return $Page_BeforeInitialize;
}

function Page_BeforeInitialize(&$sender)
{
    $Page_BeforeInitialize = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_status_pembayaran_pajak;
    //Compatibility
    //End Page_BeforeInitialize
    //status_bayar Initialization @686-5476742C
    if ('t_status_pembayaran_pajakstatus_bayar' == CCGetParam('callbackControl')) {
        global $CCSLocales;
        $Service = new Service();
        $formatter = new TemplateFormatter();
        $formatter->SetTemplate(file_get_contents(RelativePath . "/trans/" . "t_status_pembayaran_pajakstatus_bayar.xml"));
        $Service->SetFormatter($formatter);
        //End status_bayar Initialization
        //status_bayar DataSource @686-E80AEE0A
        $Service->DataSource = new clsDBConnSIKP();
        $Service->ds =& $Service->DataSource;
        $Service->DataSource->Parameters["urlp_finance_period_id"] = CCGetFromGet("p_finance_period_id", NULL);
        $Service->DataSource->wp = new clsSQLParameters();
        $Service->DataSource->wp->AddParameter("1", "urlp_finance_period_id", ccsFloat, "", "", $Service->DataSource->Parameters["urlp_finance_period_id"], 0, false);
        $Service->DataSource->SQL = "select STATUS_BAYAR , JML\n" . "from \n" . "(\n" . "  select 'SUDAH BAYAR' as STATUS_BAYAR , count(*) as JML\n" . "  from t_cust_account a\n" . "  where exists (select 1 \n" . "              from t_payment_receipt x\n" . "              where x.t_cust_account_id = a.t_cust_account_id\n" . "                    and x.p_finance_period_id = " . $Service->DataSource->SQLValue($Service->DataSource->wp->GetDBValue("1"), ccsFloat) . "\n" . "              )\n" . "        -- and trunc(a.registration_date) < (select end_date from p_finance_period where p_finance_period_id = " . $Service->DataSource->SQLValue($Service->DataSource->wp->GetDBValue("1"), ccsFloat) . "\n" . "        --                               )\n" . "  UNION ALL\n" . "  select 'BELUM BAYAR' as STATUS_BAYAR , count(*) as JML\n" . "  from t_cust_account a\n" . "  where not exists (select 1 \n" . "              from t_payment_receipt x\n" . "              where x.t_cust_account_id = a.t_cust_account_id\n" . "                    and x.p_finance_period_id = " . $Service->DataSource->SQLValue($Service->DataSource->wp->GetDBValue("1"), ccsFloat) . "\n" . "              )\n" . "        -- and trunc(a.registration_date) < (select end_date from p_finance_period where p_finance_period_id = " . $Service->DataSource->SQLValue($Service->DataSource->wp->GetDBValue("1"), ccsFloat) . "\n" . "        --                               )\n" . ")";
        $Service->DataSource->Order = "";
        $Service->DataSource->PageSize = 25;
        $Service->SetDataSourceQuery($Service->DataSource->OptimizeSQL(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order)));
        //End status_bayar DataSource
        //status_bayar Execution @686-31DF2758
        $Service->AddDataSetValue("Title", "Status Pembayaran Pajak");
        $Service->AddHttpHeader("Cache-Control", "cache, must-revalidate");
        $Service->AddHttpHeader("Pragma", "public");
        $Service->AddHttpHeader("Content-type", "text/xml");
        $Service->DisplayHeaders();
        echo $Service->Execute();
        //End status_bayar Execution
        //status_bayar Tail @686-27890EF8
        exit;
    }
    //End status_bayar Tail
    //Close Page_BeforeInitialize @1-23E6A029
    return $Page_BeforeInitialize;
}

function Page_BeforeInitialize(&$sender)
{
    $Page_BeforeInitialize = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $single_free1;
    //Compatibility
    //End Page_BeforeInitialize
    //FlashChart1 Initialization @5-857F56FE
    if ('single_free1FlashChart1' == CCGetParam('callbackControl')) {
        global $CCSLocales;
        $Service = new Service();
        $formatter = new TemplateFormatter();
        $formatter->SetTemplate(file_get_contents(RelativePath . "/" . "single_free1FlashChart1.xml"));
        $Service->SetFormatter($formatter);
        //End FlashChart1 Initialization
        //FlashChart1 DataSource @5-DA6D444A
        $Service->DataSource = new clsDBConnection1();
        $Service->ds =& $Service->DataSource;
        $Service->DataSource->SQL = "SELECT statistical_conclusion_id, patient_id, result_id \n" . "FROM result {SQL_Where} {SQL_OrderBy}";
        $Service->DataSource->PageSize = 25;
        $Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
        //End FlashChart1 DataSource
        //FlashChart1 Execution @5-BBF3D7D9
        $Service->AddDataSetValue("Title", "Chart Title");
        $Service->AddHttpHeader("Cache-Control", "cache, must-revalidate");
        $Service->AddHttpHeader("Pragma", "public");
        $Service->AddHttpHeader("Content-type", "text/xml");
        $Service->DisplayHeaders();
        echo $Service->Execute();
        //End FlashChart1 Execution
        //FlashChart1 Tail @5-27890EF8
        exit;
    }
    //End FlashChart1 Tail
    //Close Page_BeforeInitialize @1-23E6A029
    return $Page_BeforeInitialize;
}

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect");
     $this->CountSQL = "SELECT COUNT(*)  " . "FROM feedback";
     $this->SQL = "SELECT *  " . "FROM feedback";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect");
     $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     $this->query(CCBuildSQL($this->SQL, $this->Where, $this->Order));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect");
     $this->MoveToPage($this->AbsolutePage);
 }

 function Delete()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $wp = new clsSQLParameters($this->ErrorBlock);
     $wp->AddParameter("1", "ctrlp_user_attribute_id", ccsFloat, "", "", $this->p_user_attribute_id->GetValue(true), "", false);
     if (!$wp->AllParamsSet()) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildDelete", $this->Parent);
     $wp->Criterion[1] = $wp->Operation(opEqual, "p_user_attribute_id", $wp->GetDBValue("1"), $this->ToSQL($wp->GetDBValue("1"), ccsFloat), false);
     $Where = $wp->Criterion[1];
     $this->SQL = "DELETE FROM p_user_attribute";
     $this->SQL = CCBuildSQL($this->SQL, $Where, "");
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteDelete", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteDelete", $this->Parent);
     }
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->SQL = "SELECT t_cust_order_legal_doc_id, t_customer_order_id, p_legal_doc_type_id, \n" . "legal_doc_desc, origin_file_name, \n" . "file_folder, description,\n" . "file_name, to_char(creation_date, 'DD-MON-YYYY')as creation_date, \n" . "created_by, to_char(updated_date,'DD-MON-YYYY')as updated_date, updated_by \n" . "FROM t_cust_order_legal_doc\n" . "WHERE t_cust_order_legal_doc_id = " . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . " ";
     $this->Order = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     $this->PageSize = 1;
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (select to_char(i,'dd') as tanggal,nvl(realisasi_harian,0) as realisasi \n" . "from (select i::date from generate_series((select start_date from p_finance_period where p_finance_period_id=" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . "), \n" . "  (select end_date from p_finance_period where p_finance_period_id=" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . "), '1 day'::interval) i) as hari\n" . "left join \n" . "\t(select \n" . "\t\ttrunc(b.payment_date)as tanggal_bayar,\n" . "\t\tcount(b.payment_amount) as realisasi_harian \n" . "\t\tfrom t_vat_setllement a\n" . "\t\tleft join t_payment_receipt b on a.t_vat_setllement_id=b.t_vat_setllement_id\n" . "\t\twhere a.p_vat_type_dtl_id in (select p_vat_type_dtl_id from p_vat_type_dtl where p_vat_type_id=" . $this->SQLValue($this->wp->GetDBValue("2"), ccsInteger) . ")\n" . "\t\tand b.t_vat_setllement_id is not null\n" . "\t\tand b.payment_date \n" . "\t\t\tBETWEEN \n" . "\t\t\t\t(select start_date from p_finance_period where p_finance_period_id=" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . ")\n" . "\t\t\tand \n" . "\t\t\t\t(select end_date from p_finance_period where p_finance_period_id=" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . ")\n" . "\t\tGROUP BY tanggal_bayar\n" . "\t\tORDER BY tanggal_bayar) pembayaran\n" . "\tON pembayaran.tanggal_bayar=hari.i) cnt";
     $this->SQL = "select to_char(i,'dd') as tanggal,nvl(realisasi_harian,0) as realisasi \n" . "from (select i::date from generate_series((select start_date from p_finance_period where p_finance_period_id=" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . "), \n" . "  (select end_date from p_finance_period where p_finance_period_id=" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . "), '1 day'::interval) i) as hari\n" . "left join \n" . "\t(select \n" . "\t\ttrunc(b.payment_date)as tanggal_bayar,\n" . "\t\tcount(b.payment_amount) as realisasi_harian \n" . "\t\tfrom t_vat_setllement a\n" . "\t\tleft join t_payment_receipt b on a.t_vat_setllement_id=b.t_vat_setllement_id\n" . "\t\twhere a.p_vat_type_dtl_id in (select p_vat_type_dtl_id from p_vat_type_dtl where p_vat_type_id=" . $this->SQLValue($this->wp->GetDBValue("2"), ccsInteger) . ")\n" . "\t\tand b.t_vat_setllement_id is not null\n" . "\t\tand b.payment_date \n" . "\t\t\tBETWEEN \n" . "\t\t\t\t(select start_date from p_finance_period where p_finance_period_id=" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . ")\n" . "\t\t\tand \n" . "\t\t\t\t(select end_date from p_finance_period where p_finance_period_id=" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . ")\n" . "\t\tGROUP BY tanggal_bayar\n" . "\t\tORDER BY tanggal_bayar) pembayaran\n" . "\tON pembayaran.tanggal_bayar=hari.i";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*)\n\n" . "FROM (p_role_menu INNER JOIN p_menu ON\n\n" . "p_role_menu.p_menu_id = p_menu.p_menu_id) INNER JOIN p_role ON\n\n" . "p_role_menu.p_role_id = p_role.p_role_id";
     $this->SQL = "SELECT p_role.code AS role_name, p_role_menu.*, p_menu.code AS menu_name \n\n" . "FROM (p_role_menu INNER JOIN p_menu ON\n\n" . "p_role_menu.p_menu_id = p_menu.p_menu_id) INNER JOIN p_role ON\n\n" . "p_role_menu.p_role_id = p_role.p_role_id {SQL_Where} {SQL_OrderBy}";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Delete()
 {
     global $CCSLocales;
     global $DefaultDateFormat;
     $this->CmdExecution = true;
     $Where = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildDelete", $this->Parent);
     $SelectWhere = $this->Where;
     $this->Where = "title_id=" . $this->ToSQL($this->CachedColumns["title_id"], ccsInteger);
     $this->SQL = "DELETE FROM title";
     $this->SQL = CCBuildSQL($this->SQL, $this->Where, "");
     if (!strlen($this->Where) && $this->Errors->Count() == 0) {
         $this->Errors->addError($CCSLocales->GetText("CCS_CustomOperationError_MissingParameters"));
     }
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteDelete", $this->Parent);
     if ($this->Errors->Count() == 0 && $this->CmdExecution) {
         $this->query($this->SQL);
         $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteDelete", $this->Parent);
     }
     $this->Where = $SelectWhere;
 }

function Page_BeforeInitialize(&$sender)
{
    $Page_BeforeInitialize = true;
    $Component =& $sender;
    $Container =& CCGetParentContainer($sender);
    global $t_status_pelaporan_transaksi_sudah_lapor;
    //Compatibility
    //End Page_BeforeInitialize
    //jml_lapor Initialization @703-768D0E02
    if ('t_status_pelaporan_transaksi_sudah_laporjml_lapor' == CCGetParam('callbackControl')) {
        global $CCSLocales;
        $Service = new Service();
        $formatter = new TemplateFormatter();
        $formatter->SetTemplate(file_get_contents(RelativePath . "/trans/" . "t_status_pelaporan_transaksi_sudah_laporjml_lapor.xml"));
        $Service->SetFormatter($formatter);
        //End jml_lapor Initialization
        //jml_lapor DataSource @703-D5D090C8
        $Service->DataSource = new clsDBConnSIKP();
        $Service->ds =& $Service->DataSource;
        $Service->DataSource->Parameters["urlp_finance_period_id"] = CCGetFromGet("p_finance_period_id", NULL);
        $Service->DataSource->wp = new clsSQLParameters();
        $Service->DataSource->wp->AddParameter("1", "urlp_finance_period_id", ccsFloat, "", "", $Service->DataSource->Parameters["urlp_finance_period_id"], 0, false);
        $Service->DataSource->SQL = "select * from f_status_sudah_transaksi(" . $Service->DataSource->SQLValue($Service->DataSource->wp->GetDBValue("1"), ccsFloat) . ")";
        $Service->DataSource->Order = "";
        $Service->DataSource->PageSize = 25;
        $Service->SetDataSourceQuery($Service->DataSource->OptimizeSQL(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order)));
        //End jml_lapor DataSource
        //jml_lapor Execution @703-D9A734B1
        $Service->AddDataSetValue("Title", "Jumlah Lapor");
        $Service->AddHttpHeader("Cache-Control", "cache, must-revalidate");
        $Service->AddHttpHeader("Pragma", "public");
        $Service->AddHttpHeader("Content-type", "text/xml");
        $Service->DisplayHeaders();
        echo $Service->Execute();
        //End jml_lapor Execution
        //jml_lapor Tail @703-27890EF8
        exit;
    }
    //End jml_lapor Tail
    //nilai_lapor Initialization @705-287E77A8
    if ('t_status_pelaporan_transaksi_sudah_lapornilai_lapor' == CCGetParam('callbackControl')) {
        global $CCSLocales;
        $Service = new Service();
        $formatter = new TemplateFormatter();
        $formatter->SetTemplate(file_get_contents(RelativePath . "/trans/" . "t_status_pelaporan_transaksi_sudah_lapornilai_lapor.xml"));
        $Service->SetFormatter($formatter);
        //End nilai_lapor Initialization
        //nilai_lapor DataSource @705-D5D090C8
        $Service->DataSource = new clsDBConnSIKP();
        $Service->ds =& $Service->DataSource;
        $Service->DataSource->Parameters["urlp_finance_period_id"] = CCGetFromGet("p_finance_period_id", NULL);
        $Service->DataSource->wp = new clsSQLParameters();
        $Service->DataSource->wp->AddParameter("1", "urlp_finance_period_id", ccsFloat, "", "", $Service->DataSource->Parameters["urlp_finance_period_id"], 0, false);
        $Service->DataSource->SQL = "select * from f_status_sudah_transaksi (" . $Service->DataSource->SQLValue($Service->DataSource->wp->GetDBValue("1"), ccsFloat) . ")";
        $Service->DataSource->Order = "";
        $Service->DataSource->PageSize = 25;
        $Service->SetDataSourceQuery($Service->DataSource->OptimizeSQL(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order)));
        //End nilai_lapor DataSource
        //nilai_lapor Execution @705-63CC0B5D
        $Service->AddDataSetValue("Title", "Nilai Pajak");
        $Service->AddHttpHeader("Cache-Control", "cache, must-revalidate");
        $Service->AddHttpHeader("Pragma", "public");
        $Service->AddHttpHeader("Content-type", "text/xml");
        $Service->DisplayHeaders();
        echo $Service->Execute();
        //End nilai_lapor Execution
        //nilai_lapor Tail @705-27890EF8
        exit;
    }
    //End nilai_lapor Tail
    //nilai_denda Initialization @707-0F4AFEA6
    if ('t_status_pelaporan_transaksi_sudah_lapornilai_denda' == CCGetParam('callbackControl')) {
        global $CCSLocales;
        $Service = new Service();
        $formatter = new TemplateFormatter();
        $formatter->SetTemplate(file_get_contents(RelativePath . "/trans/" . "t_status_pelaporan_transaksi_sudah_lapornilai_denda.xml"));
        $Service->SetFormatter($formatter);
        //End nilai_denda Initialization
        //nilai_denda DataSource @707-D5D090C8
        $Service->DataSource = new clsDBConnSIKP();
        $Service->ds =& $Service->DataSource;
        $Service->DataSource->Parameters["urlp_finance_period_id"] = CCGetFromGet("p_finance_period_id", NULL);
        $Service->DataSource->wp = new clsSQLParameters();
        $Service->DataSource->wp->AddParameter("1", "urlp_finance_period_id", ccsFloat, "", "", $Service->DataSource->Parameters["urlp_finance_period_id"], 0, false);
        $Service->DataSource->SQL = "select * from f_status_sudah_transaksi(" . $Service->DataSource->SQLValue($Service->DataSource->wp->GetDBValue("1"), ccsFloat) . ")";
        $Service->DataSource->Order = "";
        $Service->DataSource->PageSize = 25;
        $Service->SetDataSourceQuery($Service->DataSource->OptimizeSQL(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order)));
        //End nilai_denda DataSource
        //nilai_denda Execution @707-F0889278
        $Service->AddDataSetValue("Title", "Nilai Denda");
        $Service->AddHttpHeader("Cache-Control", "cache, must-revalidate");
        $Service->AddHttpHeader("Pragma", "public");
        $Service->AddHttpHeader("Content-type", "text/xml");
        $Service->DisplayHeaders();
        echo $Service->Execute();
        //End nilai_denda Execution
        //nilai_denda Tail @707-27890EF8
        exit;
    }
//.........這裏部分代碼省略.........

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->SQL = "SELECT p_settlement_due_date_id, \n" . "a.p_vat_type_id, \n" . "due_in_day, \n" . "debt_letter1_in_day, \n" . "debt_letter2_in_day, \n" . "debt_letter3_in_day,\n" . "a.description, \n" . "a.updated_by, \n" . "a.created_by, \n" . "vat_code, \n" . "to_char(valid_from, 'DD-MON-YYYY') AS valid_from,\n" . "to_char(valid_to, 'DD-MON-YYYY') AS valid_to, \n" . "to_char(a.updated_date, 'DD-MON-YYYY') AS updated_date, \n" . "to_char(a.creation_date, 'DD-MON-YYYY') AS creation_date\n" . "\n" . "FROM p_settlement_due_date a INNER JOIN p_vat_type b ON\n" . "a.p_vat_type_id = b.p_vat_type_id\n" . "WHERE p_settlement_due_date_id = " . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . " {SQL_OrderBy}";
     $this->Order = "p_settlement_due_date_id";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     $this->PageSize = 1;
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->SQL = "SELECT to_char(a.updated_date,'DD-MON-YYYY') AS updated_date, to_char(a.creation_date,'DD-MON-YYYY') AS creation_date, b.vat_code, a.p_vat_penalty_id, \n" . "a.is_percentage,\n" . "a.month_qty,\n" . "a.penalty_pct,\n" . "a.penalty_amt,\n" . "a.description,\n" . "a.updated_by,\n" . "a.created_by,\n" . "b.p_vat_type_id\n" . "FROM p_vat_penalty a INNER JOIN p_vat_type b ON\n" . "a.p_vat_type_id = b.p_vat_type_id\n" . "WHERE p_vat_penalty_id = " . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . "";
     $this->Order = "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     $this->PageSize = 1;
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (select * from f_status_sudah_transaksi(" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . ")) cnt";
     $this->SQL = "select * from f_status_sudah_transaksi(" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . ")";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (SELECT a.t_bphtb_registration_id, a.payment_vat_amount,\n" . "b.registration_no, b.wp_name, b.njop_pbb\n" . "FROM t_payment_receipt_bphtb AS a\n" . "LEFT JOIN t_bphtb_registration AS b ON a.t_bphtb_registration_id = b.t_bphtb_registration_id\n" . "\n" . "WHERE (b.registration_no ILIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%' OR\n" . "b.njop_pbb ILIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%' OR\n" . "b.wp_name ILIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%'\n" . ") ) cnt";
     $this->SQL = "SELECT a.t_bphtb_registration_id, a.payment_vat_amount,\n" . "b.registration_no, b.wp_name, b.njop_pbb\n" . "FROM t_payment_receipt_bphtb AS a\n" . "LEFT JOIN t_bphtb_registration AS b ON a.t_bphtb_registration_id = b.t_bphtb_registration_id\n" . "\n" . "WHERE (b.registration_no ILIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%' OR\n" . "b.njop_pbb ILIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%' OR\n" . "b.wp_name ILIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%'\n" . ") ";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (SELECT x.receipt_no,\n" . "x.p_finance_period_id,\n" . "x.description,\n" . "f_per.*\n" . "FROM p_finance_period f_per,\n" . "(select sett.p_finance_period_id,\n" . "receipt_no,sett_type.description\n" . "\t\t\t\t\t\tfrom\n" . "\t\t\t\t\t\t\tt_vat_setllement sett,\n" . "\t\t\t\t\t\t\tp_settlement_type sett_type,\n" . "t_payment_receipt rec\n" . "\t\t\t\t\t\t\tWHERE sett.t_cust_account_id = " . $this->SQLValue($this->wp->GetDBValue("2"), ccsText) . "\n" . "\t\t\t\t\t\t\tand sett.p_settlement_type_id = sett_type.p_settlement_type_id\n" . "\t\t\t\t\t\t\tand sett.t_vat_setllement_id = rec.t_vat_setllement_id (+)\n" . "\t\t\t\t\t\t\tand sett.p_settlement_type_id <> 7) as x\n" . "\t\t\t\t\twhere f_per.p_finance_period_id = x.p_finance_period_id(+)\n" . "\t\t\t\t\tand f_per.end_date < (select start_date from p_finance_period where p_finance_period_id = " . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . ")\n" . "\t\t\t\t\tand f_per.start_date >= '01-01-2013'\n" . "\t\t\t\t\tand (receipt_no is null or receipt_no ='')\n" . "\t\t\t\t\tand f_per.start_date >= '" . $this->SQLValue($this->wp->GetDBValue("3"), ccsText) . "') cnt";
     $this->SQL = "SELECT x.receipt_no,\n" . "x.p_finance_period_id,\n" . "x.description,\n" . "f_per.*\n" . "FROM p_finance_period f_per,\n" . "(select sett.p_finance_period_id,\n" . "receipt_no,sett_type.description\n" . "\t\t\t\t\t\tfrom\n" . "\t\t\t\t\t\t\tt_vat_setllement sett,\n" . "\t\t\t\t\t\t\tp_settlement_type sett_type,\n" . "t_payment_receipt rec\n" . "\t\t\t\t\t\t\tWHERE sett.t_cust_account_id = " . $this->SQLValue($this->wp->GetDBValue("2"), ccsText) . "\n" . "\t\t\t\t\t\t\tand sett.p_settlement_type_id = sett_type.p_settlement_type_id\n" . "\t\t\t\t\t\t\tand sett.t_vat_setllement_id = rec.t_vat_setllement_id (+)\n" . "\t\t\t\t\t\t\tand sett.p_settlement_type_id <> 7) as x\n" . "\t\t\t\t\twhere f_per.p_finance_period_id = x.p_finance_period_id(+)\n" . "\t\t\t\t\tand f_per.end_date < (select start_date from p_finance_period where p_finance_period_id = " . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . ")\n" . "\t\t\t\t\tand f_per.start_date >= '01-01-2013'\n" . "\t\t\t\t\tand (receipt_no is null or receipt_no ='')\n" . "\t\t\t\t\tand f_per.start_date >= '" . $this->SQLValue($this->wp->GetDBValue("3"), ccsText) . "'\n" . "\t\t\t\t\t {SQL_OrderBy}";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }