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;
}
예제 #3
0
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;
}
예제 #4
0
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;
}
예제 #7
0
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;
}
예제 #10
0
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;
}