PHP CCGetDBValue函数代码示例

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (SELECT a.p_finance_period_id, a.p_year_period_id, a.code, to_char(a.start_date,'DD-MON-YYYY') start_date,\n" . "to_char(a.end_date,'DD-MON-YYYY') end_date, a.description,\n" . "to_char(a.updated_date,'DD-MON-YYYY') updated_date,\n" . "a.updated_by,to_char(a.creation_date,'DD-MON-YYYY') creation_date, a.created_by,\n" . "b.code status_code, a.p_status_list_id,\n" . "nvl(a.due_in_day,0) as due_in_day, nvl(a.debt_letter_1,0) as debt_letter_1, nvl(a.debt_letter_2,0) as debt_letter_2, nvl(a.debt_letter_3,0) as debt_letter_3\n" . "FROM p_finance_period a, p_status_list b, p_year_period c \n" . "WHERE a.p_status_list_id = b.p_status_list_id AND \n" . "a.p_year_period_id = c.p_year_period_id AND\n" . "a.p_year_period_id = " . $this->SQLValue($this->wp->GetDBValue("2"), ccsFloat) . " AND\n" . "(upper(a.code) LIKE upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%')\n" . "OR upper(b.code) LIKE upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%') )) cnt";
     $this->SQL = "SELECT a.p_finance_period_id, a.p_year_period_id, a.code, to_char(a.start_date,'DD-MON-YYYY') start_date,\n" . "to_char(a.end_date,'DD-MON-YYYY') end_date, a.description,\n" . "to_char(a.updated_date,'DD-MON-YYYY') updated_date,\n" . "a.updated_by,to_char(a.creation_date,'DD-MON-YYYY') creation_date, a.created_by,\n" . "b.code status_code, a.p_status_list_id,\n" . "nvl(a.due_in_day,0) as due_in_day, nvl(a.debt_letter_1,0) as debt_letter_1, nvl(a.debt_letter_2,0) as debt_letter_2, nvl(a.debt_letter_3,0) as debt_letter_3\n" . "FROM p_finance_period a, p_status_list b, p_year_period c \n" . "WHERE a.p_status_list_id = b.p_status_list_id AND \n" . "a.p_year_period_id = c.p_year_period_id AND\n" . "a.p_year_period_id = " . $this->SQLValue($this->wp->GetDBValue("2"), ccsFloat) . " AND\n" . "(upper(a.code) LIKE upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%')\n" . "OR upper(b.code) LIKE upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%') ){SQL_OrderBy}";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*)\n\n" . "FROM p_order_status";
     $this->SQL = "SELECT updated_by, to_char(updated_date,'DD-MON-YYYY') AS updated_date, p_order_status_id, code, description \n\n" . "FROM p_order_status {SQL_Where} {SQL_OrderBy}";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (SELECT display_name, description, decode(is_active,'Y','YA','TIDAK') AS is_active, p_procedure_id \n" . "FROM p_procedure\n" . "WHERE upper(display_name) LIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%') cnt";
     $this->SQL = "SELECT display_name, description, decode(is_active,'Y','YA','TIDAK') AS is_active, p_procedure_id \n" . "FROM p_procedure\n" . "WHERE upper(display_name) LIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%'  {SQL_OrderBy}";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*)\n\n" . "FROM title";
     $this->SQL = "SELECT * \n\n" . "FROM title {SQL_Where} {SQL_OrderBy}";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query(CCBuildSQL($this->SQL, $this->Where, $this->Order));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
     $this->MoveToPage($this->AbsolutePage);
 }

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

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (SELECT p_debt_letter_type_id, leter_type, sequnce_no, \n" . "description, to_char(creation_date,'DD-MON-YYYY')as creation_date, created_by, \n" . "to_char(updated_date,'DD-MON-YYYY')as updated_date, updated_by \n" . "FROM p_debt_letter_type\n" . "WHERE upper(leter_type) LIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%'\n" . "OR upper(description) LIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%') cnt";
     $this->SQL = "SELECT p_debt_letter_type_id, leter_type, sequnce_no, \n" . "description, to_char(creation_date,'DD-MON-YYYY')as creation_date, created_by, \n" . "to_char(updated_date,'DD-MON-YYYY')as updated_date, updated_by \n" . "FROM p_debt_letter_type\n" . "WHERE upper(leter_type) LIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%'\n" . "OR upper(description) LIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%'  {SQL_OrderBy}";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (SELECT * FROM p_module WHERE upper(code) LIKE upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%') OR description LIKE upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%')) cnt";
     $this->SQL = "SELECT * FROM p_module WHERE upper(code) LIKE upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%') OR description LIKE upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%') {SQL_OrderBy}";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (select a.mobile_no as hp,a.*, a.npwd, d.vat_code as nama_ayat\n" . "FROM t_cust_account a\n" . "LEFT JOIN p_vat_type_dtl d ON a.p_vat_type_dtl_id = d.p_vat_type_dtl_id\n" . "\n" . "WHERE upper(a.wp_address_name) like upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%')\n" . "       and upper(a.npwd) like upper('%" . $this->SQLValue($this->wp->GetDBValue("2"), ccsText) . "%')\n" . "       and upper(a.wp_name) like upper('%" . $this->SQLValue($this->wp->GetDBValue("3"), ccsText) . "%')\n" . "       and upper(a.company_name) like upper('%" . $this->SQLValue($this->wp->GetDBValue("4"), ccsText) . "%')\n" . "       and upper(a.company_brand) like upper('%" . $this->SQLValue($this->wp->GetDBValue("5"), ccsText) . "%')) cnt";
     $this->SQL = "select a.mobile_no as hp,a.*, a.npwd, d.vat_code as nama_ayat\n" . "FROM t_cust_account a\n" . "LEFT JOIN p_vat_type_dtl d ON a.p_vat_type_dtl_id = d.p_vat_type_dtl_id\n" . "\n" . "WHERE upper(a.wp_address_name) like upper('%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%')\n" . "       and upper(a.npwd) like upper('%" . $this->SQLValue($this->wp->GetDBValue("2"), ccsText) . "%')\n" . "       and upper(a.wp_name) like upper('%" . $this->SQLValue($this->wp->GetDBValue("3"), ccsText) . "%')\n" . "       and upper(a.company_name) like upper('%" . $this->SQLValue($this->wp->GetDBValue("4"), ccsText) . "%')\n" . "       and upper(a.company_brand) like upper('%" . $this->SQLValue($this->wp->GetDBValue("5"), ccsText) . "%')";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

function CCDLookUp($field_name, $table_name, $where_condition, &$db)
{
    $sql = "SELECT " . $field_name . ($table_name ? " FROM " . $table_name : "") . ($where_condition ? " WHERE " . $where_condition : "");
    return CCGetDBValue($sql, $db);
}

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (select t_cust_acc_dtl_trans_id, t_cust_account_id, bill_no, service_desc, service_charge, vat_charge, description\n" . "from f_get_cust_acc_dtl_trans(" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . ",'" . $this->SQLValue($this->wp->GetDBValue("2"), ccsText) . "')AS tbl (t_cust_acc_dtl_trans_id)) cnt";
     $this->SQL = "select t_cust_acc_dtl_trans_id, t_cust_account_id, bill_no, service_desc, service_charge, vat_charge, description\n" . "from f_get_cust_acc_dtl_trans(" . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . ",'" . $this->SQLValue($this->wp->GetDBValue("2"), ccsText) . "')AS tbl (t_cust_acc_dtl_trans_id)";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (select 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 = " . $this->SQLValue($this->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 = " . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . " --:periode_id dari pilihan\n" . "\t\t\t\t   )\n" . "  )\n" . ")\n" . ") cnt";
     $this->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 = " . $this->SQLValue($this->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 = " . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . " --:periode_id dari pilihan\n" . "\t\t\t\t   )\n" . "  )\n" . ")\n" . "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     global $Tpl;
     global $terms;
     global $savedresults;
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect");
     $this->CountSQL = "SELECT COUNT(*)  " . "FROM items";
     $this->SQL = "SELECT *  " . "FROM items";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect");
     $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     $this->query(CCBuildSQL($this->SQL, $this->Where, $this->Order));
     //print CCBuildSQL($this->SQL, $this->Where, $this->Order);
     if ($terms && !$savedresults || $terms && $_GET["refreshresults"]) {
         $db = new clsDBNetConnect();
         $db->query(CCBuildSQL($this->SQL, $this->Where, $this->Order));
         $resultstring = "";
         while ($db->next_record()) {
             $resultstring .= $db->f("ItemNum") . " ::!:!: " . $db->f("title") . " :!:!:: ";
         }
         $db->query("update search_history set `results` = '" . mysql_escape_string($resultstring) . "' where `id` = '" . $_GET["search_id"] . "'");
     }
     $Tpl->SetVar("Results", $this->nf());
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect");
     $this->MoveToPage($this->AbsolutePage);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (select p_account_status_id, code, description \n" . "from p_account_status\n" . "where p_account_status_id not in (1,5) and\n" . "upper(code) like '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%'\n" . ") cnt";
     $this->SQL = "select p_account_status_id, code, description \n" . "from p_account_status\n" . "where p_account_status_id not in (1,5) and\n" . "upper(code) like '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%'\n" . "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (SELECT a.no_kohir,d.wp_name, a.t_vat_setllement_id, a.t_customer_order_id, \n" . "a.settlement_date, a.p_finance_period_id, \n" . "a.t_cust_account_id, a.npwd, a.total_trans_amount, a.total_penalty_amount,\n" . "a.total_vat_amount, b.code as finance_period_code, c.order_no, c.p_rqst_type_id, e.code as rqst_type_code, d.p_vat_type_id\n" . "FROM t_vat_setllement a, p_finance_period b, t_customer_order c, t_cust_account d, p_rqst_type e\n" . "WHERE a.p_finance_period_id = b.p_finance_period_id AND\n" . "a.t_customer_order_id = c.t_customer_order_id AND\n" . "a.t_cust_account_id = d.t_cust_account_id AND\n" . "c.p_rqst_type_id = e.p_rqst_type_id AND\n" . "a.t_customer_order_id = " . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . ") cnt";
     $this->SQL = "SELECT a.no_kohir,d.wp_name, a.t_vat_setllement_id, a.t_customer_order_id, \n" . "a.settlement_date, a.p_finance_period_id, \n" . "a.t_cust_account_id, a.npwd, a.total_trans_amount, a.total_penalty_amount,\n" . "a.total_vat_amount, b.code as finance_period_code, c.order_no, c.p_rqst_type_id, e.code as rqst_type_code, d.p_vat_type_id\n" . "FROM t_vat_setllement a, p_finance_period b, t_customer_order c, t_cust_account d, p_rqst_type e\n" . "WHERE a.p_finance_period_id = b.p_finance_period_id AND\n" . "a.t_customer_order_id = c.t_customer_order_id AND\n" . "a.t_cust_account_id = d.t_cust_account_id AND\n" . "c.p_rqst_type_id = e.p_rqst_type_id AND\n" . "a.t_customer_order_id = " . $this->SQLValue($this->wp->GetDBValue("1"), ccsFloat) . "";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }

 function Open()
 {
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
     $this->CountSQL = "SELECT COUNT(*) FROM (SELECT to_char(a.updated_date,'DD-MON-YYYY') AS updated_date, b.vat_code, a.p_vat_penalty_id, \n" . "a.month_qty,\n" . "a.penalty_pct,\n" . "a.penalty_amt,\n" . "a.description,\n" . "a.updated_by\n" . "FROM p_vat_penalty a INNER JOIN p_vat_type b ON\n" . "a.p_vat_type_id = b.p_vat_type_id\n" . "WHERE upper(b.vat_code) LIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%'\n" . "OR upper(a.description) LIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%') cnt";
     $this->SQL = "SELECT to_char(a.updated_date,'DD-MON-YYYY') AS updated_date, b.vat_code, a.p_vat_penalty_id, \n" . "a.month_qty,\n" . "a.penalty_pct,\n" . "a.penalty_amt,\n" . "a.description,\n" . "a.updated_by\n" . "FROM p_vat_penalty a INNER JOIN p_vat_type b ON\n" . "a.p_vat_type_id = b.p_vat_type_id\n" . "WHERE upper(b.vat_code) LIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%'\n" . "OR upper(a.description) LIKE '%" . $this->SQLValue($this->wp->GetDBValue("1"), ccsText) . "%'  {SQL_OrderBy}";
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
     if ($this->CountSQL) {
         $this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
     } else {
         $this->RecordsCount = "CCS not counted";
     }
     $this->query($this->OptimizeSQL(CCBuildSQL($this->SQL, $this->Where, $this->Order)));
     $this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
 }