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;
}
//End nilai_denda Tail
//Close Page_BeforeInitialize @1-23E6A029
return $Page_BeforeInitialize;
}
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);
}
function Open()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect");
$this->SQL = "SELECT * " . "FROM settings_images";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect");
$this->query(CCBuildSQL($this->SQL, $this->Where, $this->Order));
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect");
$this->MoveToPage($this->AbsolutePage);
}
function Open()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
$this->CountSQL = "SELECT COUNT(*) FROM ((SELECT t_revenue_target_id, p_year_period_id, p_vat_type_id, vat_code, year_code, target_amount, realisasi_amt\n" . "FROM v_revenue_target_vs_realisasi\n" . "WHERE p_year_period_id = " . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . "\n" . "and p_vat_group_id=" . $this->SQLValue($this->wp->GetDBValue("2"), ccsInteger) . "\n" . "ORDER BY p_vat_type_id)\n" . "UNION\n" . "(SELECT\n" . "\t'999',\n" . "\t" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . "\n" . "\t,\n" . "\tMAX (p_vat_type_id),\n" . "\t'DENDA',\n" . "\t'',\n" . "\t0,\n" . "\tSUM (round(jml_sd_hari_ini))\n" . "FROM\n" . "\tsikp.f_rep_lap_harian_bdhr_baru (" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . ")\n" . "where nomor_ayat IN('140701','140702','140703','140707')\n" . "and p_vat_group_id = " . $this->SQLValue($this->wp->GetDBValue("2"), ccsInteger) . ")) cnt";
$this->SQL = "(SELECT t_revenue_target_id, p_year_period_id, p_vat_type_id, vat_code, year_code, target_amount, realisasi_amt\n" . "FROM v_revenue_target_vs_realisasi\n" . "WHERE p_year_period_id = " . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . "\n" . "and p_vat_group_id=" . $this->SQLValue($this->wp->GetDBValue("2"), ccsInteger) . "\n" . "ORDER BY p_vat_type_id)\n" . "UNION\n" . "(SELECT\n" . "\t'999',\n" . "\t" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . "\n" . "\t,\n" . "\tMAX (p_vat_type_id),\n" . "\t'DENDA',\n" . "\t'',\n" . "\t0,\n" . "\tSUM (round(jml_sd_hari_ini))\n" . "FROM\n" . "\tsikp.f_rep_lap_harian_bdhr_baru (" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . ")\n" . "where nomor_ayat IN('140701','140702','140703','140707')\n" . "and p_vat_group_id = " . $this->SQLValue($this->wp->GetDBValue("2"), ccsInteger) . ")";
$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->SQL = "SELECT a.t_cacc_dtl_restaurant_id, a.t_cust_account_id, a.service_type_desc, \n" . "\t to_char(a.valid_from,'DD-MON-YYYY')as valid_from, to_char(a.valid_to,'DD-MON-YYYY')as valid_to,\t\n" . "\t a.seat_qty, a.table_qty, a.max_service_qty, a.avg_subscription, a.description, to_char(a.creation_date, 'DD-MON-YYYY') AS creation_date, \n" . "\t a.created_by, to_char(a.updated_date, 'DD-MON-YYYY') AS updated_date, a.updated_by,\n" . "\t min_food_price,max_food_price,min_beverage_price,max_beverage_price\n" . " FROM t_cacc_dtl_restaurant a, t_cust_account c\n" . " WHERE a.t_cust_account_id = c.t_cust_account_id \n" . " AND a.t_cacc_dtl_restaurant_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->SQL = "SELECT v.p_region_id as p_region_id_per, *,b.code AS nama_jabatan,\n" . "p.region_name as nama_kota_owner,\n" . "q.region_name as nama_kecamatan_owner,\n" . "r.region_name as nama_kelurahan_owner\n" . "FROM v_masa_jab_detail_update v\n" . "LEFT JOIN p_job_position b ON v.p_job_position_id = b.p_job_position_id\n" . "left join p_region p on p.p_region_id = v.p_region_id_owner\n" . "left join p_region q on q.p_region_id = v.p_region_id_kec_owner\n" . "left join p_region r on r.p_region_id = v.p_region_id_kel_owner\n" . "WHERE v.t_cust_account_id = " . $this->SQLValue($this->wp->GetDBValue("2"), ccsInteger) . "\n" . "AND v.t_cust_acc_masa_jab_id = " . $this->SQLValue($this->wp->GetDBValue("1"), ccsInteger) . "\n" . "";
$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 Page_BeforeInitialize(&$sender)
{
$Page_BeforeInitialize = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $index;
//Compatibility
//End Page_BeforeInitialize
//YahooAutocomplete1 Initialization @65-2A144B48
if ('sex_department_patient_re1s_surnameYahooAutocomplete1' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete1 Initialization
//YahooAutocomplete1 DataSource @65-D7716879
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM patient {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "surname", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete1 DataSource
//YahooAutocomplete1 DataFields @65-7B8C1313
$Service->AddDataSourceField('surname');
//End YahooAutocomplete1 DataFields
//YahooAutocomplete1 Execution @65-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete1 Execution
//YahooAutocomplete1 Tail @65-27890EF8
exit;
}
//End YahooAutocomplete1 Tail
//YahooAutocomplete2 Initialization @66-4B9AF09F
if ('sex_department_patient_re1s_other_namesYahooAutocomplete2' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete2 Initialization
//YahooAutocomplete2 DataSource @66-A29C63C1
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM patient {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "other_names", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete2 DataSource
//YahooAutocomplete2 DataFields @66-6D762D08
$Service->AddDataSourceField('other_names');
//End YahooAutocomplete2 DataFields
//YahooAutocomplete2 Execution @66-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete2 Execution
//YahooAutocomplete2 Tail @66-27890EF8
exit;
}
//End YahooAutocomplete2 Tail
//YahooAutocomplete3 Initialization @67-604AB22E
if ('sex_department_patient_re1s_hospital_noYahooAutocomplete3' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete3 Initialization
//YahooAutocomplete3 DataSource @67-6F74E980
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM patient {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "hospital_no", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete3 DataSource
//YahooAutocomplete3 DataFields @67-BAEED557
$Service->AddDataSourceField('hospital_no');
//End YahooAutocomplete3 DataFields
//YahooAutocomplete3 Execution @67-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete3 Execution
//YahooAutocomplete3 Tail @67-27890EF8
exit;
}
//End YahooAutocomplete3 Tail
//YahooAutocomplete4 Initialization @68-EEC841F4
if ('sex_department_patient_re1s_patient_idYahooAutocomplete4' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete4 Initialization
//YahooAutocomplete4 DataSource @68-54A4C37F
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM result {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "patient_id", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete4 DataSource
//YahooAutocomplete4 DataFields @68-2A140E80
$Service->AddDataSourceField('patient_id');
//End YahooAutocomplete4 DataFields
//YahooAutocomplete4 Execution @68-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete4 Execution
//YahooAutocomplete4 Tail @68-27890EF8
exit;
}
//End YahooAutocomplete4 Tail
//YahooAutocomplete5 Initialization @69-45F7FEB1
if ('sex_department_patient_re1s_result_idYahooAutocomplete5' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete5 Initialization
//YahooAutocomplete5 DataSource @69-96886DBA
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM result {SQL_Where} {SQL_OrderBy}";
$Service->DataSource->Parameters["urlquery"] = CCGetFromGet("query", NULL);
$Service->DataSource->wp = new clsSQLParameters();
$Service->DataSource->wp->AddParameter("1", "urlquery", ccsText, "", "", $Service->DataSource->Parameters["urlquery"], -1, false);
$Service->DataSource->wp->Criterion[1] = $Service->DataSource->wp->Operation(opBeginsWith, "result_id", $Service->DataSource->wp->GetDBValue("1"), $Service->DataSource->ToSQL($Service->DataSource->wp->GetDBValue("1"), ccsText), false);
$Service->DataSource->Where = $Service->DataSource->wp->Criterion[1];
$Service->SetDataSourceQuery(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order));
//End YahooAutocomplete5 DataSource
//YahooAutocomplete5 DataFields @69-F2E2F41D
$Service->AddDataSourceField('result_id');
//End YahooAutocomplete5 DataFields
//YahooAutocomplete5 Execution @69-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete5 Execution
//YahooAutocomplete5 Tail @69-27890EF8
exit;
}
//End YahooAutocomplete5 Tail
//Close Page_BeforeInitialize @1-23E6A029
return $Page_BeforeInitialize;
}
function Open()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
$this->SQL = "SELECT p_organization_type_id, code, listing_no, description, \n" . "to_char(creation_date,'DD-MON-YYYY')as creation_date, created_by, to_char(updated_date,'DD-MON-YYYY')as updated_date, updated_by\n" . "FROM p_organization_type\n" . "WHERE p_organization_type_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 p_survey_question \n" . "WHERE p_survey_type_id=2) cnt";
$this->SQL = "select * from p_survey_question \n" . "WHERE p_survey_type_id=2 {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 Open()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
$this->SQL = "SELECT to_char(creation_date,'DD-MON-YYYY') AS creation_date, to_char(updated_date,'DD-MON-YYYY') AS updated_date, p_order_status_id,\n\n" . "code, description, created_by, updated_by \n\n" . "FROM p_order_status {SQL_Where} {SQL_OrderBy}";
$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 * from p_block_piutang where block_id=1";
$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->SQL = "SELECT *, user_id \n\n" . "FROM users {SQL_Where} {SQL_OrderBy}";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
$this->query(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_document_type";
$this->SQL = "SELECT * \n\n" . "FROM p_document_type {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 Open()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
$this->CountSQL = "SELECT COUNT(*) FROM (SELECT display_name, description, decode(is_active,'Y','YA','TIDAK') AS is_active, p_procedure_id \n" . "FROM p_procedure\n" . "WHERE upper(display_name) LIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%') cnt";
$this->SQL = "SELECT display_name, description, decode(is_active,'Y','YA','TIDAK') AS is_active, p_procedure_id \n" . "FROM p_procedure\n" . "WHERE upper(display_name) LIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%' {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 Open()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
$this->SQL = "SELECT t_vat_setllement_id, t_customer_order_id,\n" . "to_char(settlement_date,'YYYY-MM-DD') AS settlement_date, p_finance_period_id, t_cust_account_id,\n" . "npwd, total_trans_amount, total_vat_amount, creation_date,\n" . "created_by, updated_date, updated_by, is_anomali,\n" . "is_authorized, no_kohir, p_settlement_type_id,\n" . "debt_vat_amt, cr_adjustment, cr_payment, cr_others,\n" . "cr_stp, db_interest_charge, db_increasing_charge,\n" . "db_admin_penalty, due_date, is_settled, start_period,\n" . "end_period, qty_room_sold, total_penalty_amount, doc_no,\n" . "p_vat_type_dtl_id, old_id\n" . "FROM t_vat_setllement\n" . "WHERE t_vat_setllement_id = " . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "";
$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->SQL = "SELECT * \n\n" . "FROM t_order_log_kronologis {SQL_Where} {SQL_OrderBy}";
$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 p_module WHERE upper(code) LIKE upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%') OR description LIKE upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%')) cnt";
$this->SQL = "SELECT * FROM p_module WHERE upper(code) LIKE upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%') OR description LIKE upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%') {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);
}
