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 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 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 Page_BeforeInitialize(&$sender)
{
$Page_BeforeInitialize = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_payment_receipt;
//Compatibility
//End Page_BeforeInitialize
//FlashChart1 Initialization @686-E035C57E
if ('t_payment_receiptFlashChart1' == CCGetParam('callbackControl')) {
global $CCSLocales;
$Service = new Service();
$formatter = new TemplateFormatter();
$formatter->SetTemplate(file_get_contents(RelativePath . "/trans/" . "t_payment_receiptFlashChart1.xml"));
$Service->SetFormatter($formatter);
//End FlashChart1 Initialization
//FlashChart1 DataSource @686-6D9BE062
$Service->DataSource = new clsDBConnSIKP();
$Service->ds =& $Service->DataSource;
$Service->DataSource->Parameters["urlp_finance_period_id"] = CCGetFromGet("p_finance_period_id", NULL);
$Service->DataSource->Parameters["urlp_vat_type_id"] = CCGetFromGet("p_vat_type_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->wp->AddParameter("2", "urlp_vat_type_id", ccsFloat, "", "", $Service->DataSource->Parameters["urlp_vat_type_id"], 0, false);
$Service->DataSource->SQL = "select b.vat_code, count(1) as jml_wp\n" . "from t_cust_account a, p_vat_type b\n" . "where\n" . "\t(not exists(\n" . "\t\tselect 1 from t_payment_receipt x\n" . "\t\twhere x.t_cust_account_id = a.t_cust_account_id\n" . "\t\tand x.p_finance_period_id = " . $Service->DataSource->SQLValue($Service->DataSource->wp->GetDBValue("1"), ccsFloat) . "\n" . "\t))\n" . "\tand \n" . "\t(a.p_vat_type_id <> " . $Service->DataSource->SQLValue($Service->DataSource->wp->GetDBValue("2"), ccsFloat) . ")\n" . "group by b.vat_code, b.description";
$Service->DataSource->Order = "";
$Service->DataSource->PageSize = 25;
$Service->SetDataSourceQuery($Service->DataSource->OptimizeSQL(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order)));
//End FlashChart1 DataSource
//FlashChart1 Execution @686-8BA5D20B
$Service->AddDataSetValue("Title", "Laporan Rekap Tunggakan");
$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 @686-27890EF8
exit;
}
//End FlashChart1 Tail
//Close Page_BeforeInitialize @1-23E6A029
return $Page_BeforeInitialize;
}
function Page_BeforeInitialize(&$sender)
{
$Page_BeforeInitialize = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $index;
//Compatibility
//End Page_BeforeInitialize
//YahooAutocomplete1 Initialization @169-663F79D3
if ('sex_occupation_patient1s_keywordYahooAutocomplete1' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete1 Initialization
//YahooAutocomplete1 DataSource @169-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 @169-7B8C1313
$Service->AddDataSourceField('surname');
//End YahooAutocomplete1 DataFields
//YahooAutocomplete1 Execution @169-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete1 Execution
//YahooAutocomplete1 Tail @169-27890EF8
exit;
}
//End YahooAutocomplete1 Tail
//YahooAutocomplete2 Initialization @170-F89F3274
if ('sex_occupation_patient1s_keywordYahooAutocomplete2' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete2 Initialization
//YahooAutocomplete2 DataSource @170-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 @170-6D762D08
$Service->AddDataSourceField('other_names');
//End YahooAutocomplete2 DataFields
//YahooAutocomplete2 Execution @170-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete2 Execution
//YahooAutocomplete2 Tail @170-27890EF8
exit;
}
//End YahooAutocomplete2 Tail
//YahooAutocomplete3 Initialization @171-8D00F4E9
if ('sex_occupation_patient1s_keywordYahooAutocomplete3' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete3 Initialization
//YahooAutocomplete3 DataSource @171-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 @171-BAEED557
$Service->AddDataSourceField('hospital_no');
//End YahooAutocomplete3 DataFields
//YahooAutocomplete3 Execution @171-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete3 Execution
//YahooAutocomplete3 Tail @171-27890EF8
exit;
}
//End YahooAutocomplete3 Tail
//YahooAutocomplete1 Initialization @172-3ED9C29E
if ('title_status_users_result1s_patient_idYahooAutocomplete1' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete1 Initialization
//YahooAutocomplete1 DataSource @172-EB18E68D
$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, "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 YahooAutocomplete1 DataSource
//YahooAutocomplete1 DataFields @172-2A140E80
$Service->AddDataSourceField('patient_id');
//End YahooAutocomplete1 DataFields
//YahooAutocomplete1 Execution @172-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete1 Execution
//YahooAutocomplete1 Tail @172-27890EF8
exit;
}
//End YahooAutocomplete1 Tail
//Close Page_BeforeInitialize @1-23E6A029
return $Page_BeforeInitialize;
}
function Page_BeforeInitialize(&$sender)
{
$Page_BeforeInitialize = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_status_pelaporan_transaksi_belum_lapor;
//Compatibility
//End Page_BeforeInitialize
//belum_lapor Initialization @678-9A0DF879
if ('t_status_pelaporan_transaksi_belum_laporbelum_lapor' == CCGetParam('callbackControl')) {
global $CCSLocales;
$Service = new Service();
$formatter = new TemplateFormatter();
$formatter->SetTemplate(file_get_contents(RelativePath . "/trans/" . "t_status_pelaporan_transaksi_belum_laporbelum_lapor.xml"));
$Service->SetFormatter($formatter);
//End belum_lapor Initialization
//belum_lapor DataSource @678-61AC9D24
$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 vat_code, jml_wp from f_status_belum_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 belum_lapor DataSource
//belum_lapor Execution @678-9CB114EB
$Service->AddDataSetValue("Title", "Jumlah Belum Lapor");
$Service->AddHttpHeader("Cache-Control", "cache, must-revalidate");
$Service->AddHttpHeader("Pragma", "public");
$Service->AddHttpHeader("Content-type", "text/xml");
$Service->DisplayHeaders();
echo $Service->Execute();
//End belum_lapor Execution
//belum_lapor Tail @678-27890EF8
exit;
}
//End belum_lapor 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_sudah_bayar;
//Compatibility
//End Page_BeforeInitialize
//jml_wp_bayar Initialization @704-65F72402
if ('t_status_pembayaran_pajak_sudah_bayarjml_wp_bayar' == CCGetParam('callbackControl')) {
global $CCSLocales;
$Service = new Service();
$formatter = new TemplateFormatter();
$formatter->SetTemplate(file_get_contents(RelativePath . "/trans/" . "t_status_pembayaran_pajak_sudah_bayarjml_wp_bayar.xml"));
$Service->SetFormatter($formatter);
//End jml_wp_bayar Initialization
//jml_wp_bayar DataSource @704-41F1AB11
$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 tgl, jml_wp_bayar from f_status_sudah_bayar(" . $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_wp_bayar DataSource
//jml_wp_bayar Execution @704-B290AEA6
$Service->AddDataSetValue("Title", "Jumlah WP Bayar");
$Service->AddHttpHeader("Cache-Control", "cache, must-revalidate");
$Service->AddHttpHeader("Pragma", "public");
$Service->AddHttpHeader("Content-type", "text/xml");
$Service->DisplayHeaders();
echo $Service->Execute();
//End jml_wp_bayar Execution
//jml_wp_bayar Tail @704-27890EF8
exit;
}
//End jml_wp_bayar Tail
//nilai_ketetapan Initialization @713-8C56F3BE
if ('t_status_pembayaran_pajak_sudah_bayarnilai_ketetapan' == CCGetParam('callbackControl')) {
global $CCSLocales;
$Service = new Service();
$formatter = new TemplateFormatter();
$formatter->SetTemplate(file_get_contents(RelativePath . "/trans/" . "t_status_pembayaran_pajak_sudah_bayarnilai_ketetapan.xml"));
$Service->SetFormatter($formatter);
//End nilai_ketetapan Initialization
//nilai_ketetapan DataSource @713-C7525F4D
$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 tgl, nilai_ketetapan from f_status_sudah_bayar(2)";
$Service->DataSource->Order = "";
$Service->DataSource->PageSize = 25;
$Service->SetDataSourceQuery($Service->DataSource->OptimizeSQL(CCBuildSQL($Service->DataSource->SQL, $Service->DataSource->Where, $Service->DataSource->Order)));
//End nilai_ketetapan DataSource
//nilai_ketetapan Execution @713-09450E0B
$Service->AddDataSetValue("Title", "Nilai Ketetapan");
$Service->AddHttpHeader("Cache-Control", "cache, must-revalidate");
$Service->AddHttpHeader("Pragma", "public");
$Service->AddHttpHeader("Content-type", "text/xml");
$Service->DisplayHeaders();
echo $Service->Execute();
//End nilai_ketetapan Execution
//nilai_ketetapan Tail @713-27890EF8
exit;
}
//End nilai_ketetapan Tail
//nilai_bayar Initialization @706-86231EDE
if ('t_status_pembayaran_pajak_sudah_bayarnilai_bayar' == CCGetParam('callbackControl')) {
global $CCSLocales;
$Service = new Service();
$formatter = new TemplateFormatter();
$formatter->SetTemplate(file_get_contents(RelativePath . "/trans/" . "t_status_pembayaran_pajak_sudah_bayarnilai_bayar.xml"));
$Service->SetFormatter($formatter);
//End nilai_bayar Initialization
//nilai_bayar DataSource @706-32F27338
$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 tgl, nilai_bayar from f_status_sudah_bayar(" . $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_bayar DataSource
//nilai_bayar Execution @706-007551B3
$Service->AddDataSetValue("Title", "Nilai Bayar");
$Service->AddHttpHeader("Cache-Control", "cache, must-revalidate");
$Service->AddHttpHeader("Pragma", "public");
$Service->AddHttpHeader("Content-type", "text/xml");
$Service->DisplayHeaders();
echo $Service->Execute();
//End nilai_bayar Execution
//nilai_bayar Tail @706-27890EF8
exit;
}
//End nilai_bayar Tail
//nilai_denda Initialization @720-AFB7C068
if ('t_status_pembayaran_pajak_sudah_bayarnilai_denda' == CCGetParam('callbackControl')) {
global $CCSLocales;
$Service = new Service();
$formatter = new TemplateFormatter();
$formatter->SetTemplate(file_get_contents(RelativePath . "/trans/" . "t_status_pembayaran_pajak_sudah_bayarnilai_denda.xml"));
$Service->SetFormatter($formatter);
//End nilai_denda Initialization
//nilai_denda DataSource @720-9FC846E5
$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 tgl, nilai_denda from f_status_sudah_bayar(2)";
$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 @720-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 @720-27890EF8
exit;
}
//End nilai_denda Tail
//Close Page_BeforeInitialize @1-23E6A029
return $Page_BeforeInitialize;
}
function Page_BeforeInitialize(&$sender)
{
$Page_BeforeInitialize = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $index;
//Compatibility
//End Page_BeforeInitialize
//YahooAutocomplete1 Initialization @74-299480B3
if ('title_user_group_departme1s_keywordYahooAutocomplete1' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete1 Initialization
//YahooAutocomplete1 DataSource @74-23A485AF
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM users {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, "first_name", $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 @74-A2FDBB32
$Service->AddDataSourceField('first_name');
//End YahooAutocomplete1 DataFields
//YahooAutocomplete1 Execution @74-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete1 Execution
//YahooAutocomplete1 Tail @74-27890EF8
exit;
}
//End YahooAutocomplete1 Tail
//YahooAutocomplete2 Initialization @75-B734CB14
if ('title_user_group_departme1s_keywordYahooAutocomplete2' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete2 Initialization
//YahooAutocomplete2 DataSource @75-E4ED46DB
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM users {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, "last_name", $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 @75-0BC99D58
$Service->AddDataSourceField('last_name');
//End YahooAutocomplete2 DataFields
//YahooAutocomplete2 Execution @75-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete2 Execution
//YahooAutocomplete2 Tail @75-27890EF8
exit;
}
//End YahooAutocomplete2 Tail
//YahooAutocomplete3 Initialization @76-C2AB0D89
if ('title_user_group_departme1s_keywordYahooAutocomplete3' == CCGetParam('callbackControl')) {
$Service = new Service();
$Service->SetFormatter(new JsonFormatter());
//End YahooAutocomplete3 Initialization
//YahooAutocomplete3 DataSource @76-1B31722E
$Service->DataSource = new clsDBConnection1();
$Service->ds =& $Service->DataSource;
$Service->DataSource->SQL = "SELECT * \n" . "FROM department {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, "department", $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 @76-6EE6BEC7
$Service->AddDataSourceField('department');
//End YahooAutocomplete3 DataFields
//YahooAutocomplete3 Execution @76-73F24F96
echo '{"Result":' . $Service->Execute() . '}';
//End YahooAutocomplete3 Execution
//YahooAutocomplete3 Tail @76-27890EF8
exit;
}
//End YahooAutocomplete3 Tail
//Close Page_BeforeInitialize @1-23E6A029
return $Page_BeforeInitialize;
}