作者：4v4t4
项目：CTF-LC
function Header_BeforeShow()
{
//Header_BeforeShow @1-86E61FAE
//Custom Code @22-2A29BDB7
global $now;
global $accounting;
global $regcharges;
global $Tpl;
include "../Version.php";
$Tpl->SetVar("versions", $ItechclVersion);
$Tpl->SetVar("sitename", $now["sitename"]);
$Tpl->SetVar("siteemail", $now["siteemail"]);
$Tpl->SetVar("homeurl", $now["homeurl"]);
$Tpl->SetVar("secureurl", $now["secureurl"]);
$Tpl->SetVar("notifyemail", $now["notifyemail"]);
$Tpl->SetVar("paypal", $accounting["paypal"]);
$Tpl->SetVar("listing_fee", $regcharges["listing_fee"]);
$Tpl->SetVar("homepage_fee", $regcharges["home_fee"]);
$Tpl->SetVar("category_fee", $regcharges["cat_fee"]);
$Tpl->SetVar("gallery_fee", $regcharges["gallery_fee"]);
$Tpl->SetVar("image_preview_fee", $regcharges["image_pre_fee"]);
$Tpl->SetVar("slide_fee", $regcharges["slide_fee"]);
$Tpl->SetVar("counter_fee", $regcharges["counter_fee"]);
$Tpl->SetVar("bold_fee", $regcharges["bold_fee"]);
$Tpl->SetVar("highlight_fee", $regcharges["high_fee"]);
$Tpl->SetVar("upload_fee", $regcharges["upload_fee"]);
$Tpl->SetVar("make_offer_image", $images["make_offer_image"]);
$Tpl->SetVar("currency", $regcharges["currency"]);
$Tpl->SetVar("AdminName", CCGetUserLogin());
//End Custom Code
}
作者：rayminam
项目：mpd-onlin
function LOV_BeforeShow(&$sender)
{
$LOV_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $LOV;
//Compatibility
//End LOV_BeforeShow
//Custom Code @8-2A29BDB7
// -------------------------
// Write your own code here.
$i_vat_setllement = CCGetFromGet('i_vat_setllement_id');
$ubah = CCGetFromGet('ubah');
$in_flag_numeric = CCGetFromGet('in_flag_numeric');
$is_desc = CCGetFromGet('is_desc');
if ($ubah == 'T') {
$user = CCGetUserLogin();
$data = array();
$dbConn = new clsDBConnSIKP();
$query = "select f_update_increasing_amt({$i_vat_setllement},{$in_flag_numeric},'{$is_desc}','{$user}') as msg";
$dbConn->query($query);
while ($dbConn->next_record()) {
echo "<script> \r\n\t\t\talert('" . $dbConn->f('msg') . "');\r\n\t\t\twindow.close();\r\n\t\t</script>";
exit;
}
}
// -------------------------
//End Custom Code
//Close LOV_BeforeShow @3-91C2A156
return $LOV_BeforeShow;
}
作者：rayminam
项目：mpd-onlin
function LOV_Button1_OnClick(&$sender)
{
$LOV_Button1_OnClick = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $LOV;
//Compatibility
//End LOV_Button1_OnClick
//Custom Code @24-2A29BDB7
// -------------------------
// Write your own code here.
$t_bphtb_registration_id = CCGetFromGet("t_bphtb_registration_id");
$alasan = $LOV->alasan->GetValue();
$user = CCGetUserLogin();
$dbConn = new clsDBConnSIKP();
if ($t_bphtb_registration_id != "" && $alasan != "" && $user != "") {
$query = "select f_delete_bphtb from \r\n\t\t\tf_delete_bphtb(" . $t_bphtb_registration_id . ",'" . $alasan . "','" . $user . "')";
//echo $query;exit;
$dbConn->query($query);
$dbConn->next_record();
$result = $dbConn->f("f_delete_bphtb");
} else {
$result = "id bphtb, alasan atau user login tidak boleh kosong";
}
echo "<script> \r\n\t\talert('" . $result . "');\r\n\t\twindow.opener.location.reload();\r\n\t\twindow.close();\r\n\t</script>";
exit;
// -------------------------
//End Custom Code
//Close LOV_Button1_OnClick @16-408DE5C8
return $LOV_Button1_OnClick;
}
作者：rayminam
项目：mpd-onlin
function Initialize()
{
if (!$this->Visible) {
return;
}
$this->DataSource->Parameters["expr30"] = CCGetUserLogin();
}
作者：rayminam
项目：mpd-onlin
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_wp_registration_list;
//Compatibility
//End Page_BeforeShow
//Custom Code @562-2A29BDB7
// -------------------------
// Write your own code here.
global $Label1;
$tampil = CCGetFromGet('tampil');
if ($tampil == 'T') {
$Label1->SetText("<table border=1><tr><td>tes</td></tr></table>");
$tgl_penerimaan = CCGetFromGet("tgl_penerimaan", "");
//'15-12-2013';
$tgl_penerimaan_last = CCGetFromGet("tgl_penerimaan_last", "");
//'15-12-2013';
$jenis_pajak = CCGetFromGet("jenis_pajak", 0);
// $tgl_penerimaan = '15-12-2013';
$user = CCGetUserLogin();
$data = array();
$dbConn = new clsDBConnSIKP();
if ($jenis_pajak == 0 || $jenis_pajak == "") {
$query = "select a.*, b.vat_code, c.code as account_status from t_vat_registration a\r\n\t\t\tleft join p_vat_type_dtl z on z.p_vat_type_dtl_id = a.p_vat_type_dtl_id\r\n\t\t\tleft join p_vat_type b on b.p_vat_type_id = z.p_vat_type_id\r\n\t\t\tleft join t_customer_order y on y.t_customer_order_id = a.t_customer_order_id\r\n\t\t\tLEFT JOIN p_order_status C ON C .p_order_status_id = y .p_order_status_id\r\n\t\t\twhere trunc(registration_date) >= to_date('{$tgl_penerimaan}')\r\n\t\t\tAND trunc(registration_date) <= to_date('{$tgl_penerimaan_last}')\r\n\t\t\tORDER BY registration_date ASC";
} else {
$query = "select a.*, b.vat_code, c.code as account_status from t_vat_registration a\r\n\t\t\tleft join p_vat_type_dtl z on z.p_vat_type_dtl_id = a.p_vat_type_dtl_id\r\n\t\t\tleft join p_vat_type b on b.p_vat_type_id = z.p_vat_type_id\r\n\t\t\tleft join t_customer_order y on y.t_customer_order_id = a.t_customer_order_id\r\n\t\t\tLEFT JOIN p_order_status C ON C .p_order_status_id = y .p_order_status_id\r\n\t\t\twhere trunc(registration_date) >= to_date('{$tgl_penerimaan}')\r\n\t\t\tAND trunc(registration_date) <= to_date('{$tgl_penerimaan_last}')\r\n\t\t\tAND a.p_vat_type_dtl_id in (select p_vat_type_dtl_id from p_vat_type_dtl\r\n\t\t\t\twhere p_vat_type_id = {$jenis_pajak})\r\n\t\t\tORDER BY registration_date ASC";
}
//echo $query;
//exit;
$tgl_penerimaan = str_replace("'", "", $tgl_penerimaan);
$dbConn->query($query);
while ($dbConn->next_record()) {
$data["t_cust_account_id"][] = $dbConn->f("t_cust_account_id");
$data["t_customer_id"][] = $dbConn->f("t_customer_id");
$data["npwd"][] = $dbConn->f("npwpd");
$data["vat_code"][] = $dbConn->f("vat_code");
$data["registration_date"][] = $dbConn->f("registration_date");
$data["wp_name"][] = $dbConn->f("wp_name");
$data["wp_address_name"][] = $dbConn->f("wp_address_name");
$data["company_name"][] = $dbConn->f("company_name");
$data["address_name"][] = $dbConn->f("address_name");
$data["account_status"][] = $dbConn->f("account_status");
}
$dbConn->close();
$Label1->SetText(PageCetak($data, $user, $tgl_penerimaan, $tgl_penerimaan_last));
}
// -------------------------
//End Custom Code
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
作者：rayminam
项目：mpd-onlin
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_rep_lap_harian;
//Compatibility
//End Page_BeforeShow
//Custom Code @562-2A29BDB7
// -------------------------
// Write your own code here.
global $Label1;
$tampil = CCGetFromGet('tampil');
if ($tampil == 'T') {
$Label1->SetText("<table border=1><tr><td>tes</td></tr></table>");
$tgl_penerimaan = CCGetFromGet("tgl_penerimaan", "");
//'15-12-2013';
$kode_bank = CCGetFromGet("kode_bank", "");
// $tgl_penerimaan = '15-12-2013';
$user = CCGetUserLogin();
$data = array();
$dbConn = new clsDBConnSIKP();
$query = "select * from f_rep_lap_harian_bdhr_mod_2('{$tgl_penerimaan}','{$kode_bank}') order by nomor_ayat";
$tgl_penerimaan = str_replace("'", "", $tgl_penerimaan);
$dbConn->query($query);
while ($dbConn->next_record()) {
$data["nomor_ayat"][] = $dbConn->f("nomor_ayat");
$data["nama_ayat"][] = $dbConn->f("nama_ayat");
$data["nama_jns_pajak"][] = $dbConn->f("nama_jns_pajak");
$data["kode_jns_pajak"][] = $dbConn->f("kode_jns_pajak");
$data["jns_pajak"][] = $dbConn->f("jns_pajak");
$data["type_ayat"][] = $dbConn->f("type_ayat");
$data["p_vat_type_id"][] = $dbConn->f("p_vat_type_id");
$data["p_vat_type_dtl_id"][] = $dbConn->f("p_vat_type_dtl_id");
$data["bulan"][] = $dbConn->f("bulan");
$data["tahun"][] = $dbConn->f("tahun");
$data["jml_hari_ini"][] = $dbConn->f("jml_hari_ini");
$data["jml_sd_hari_lalu"][] = $dbConn->f("jml_sd_hari_lalu");
$data["jml_sd_hari_ini"][] = $dbConn->f("jml_sd_hari_ini");
$data["jml_transaksi"][] = $dbConn->f("jml_transaksi");
$data["jml_transaksi_sampai_kemarin"][] = $dbConn->f("jml_transaksi_sampai_kemarin");
$data["jml_transaksi_sampai_hari_ini"][] = $dbConn->f("jml_transaksi_sampai_hari_ini");
}
$dbConn->close();
$Label1->SetText(PageCetak($data, $user, $tgl_penerimaan));
}
// -------------------------
//End Custom Code
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
作者：rayminam
项目：mpd-onlin
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_rep_lap_bpps_piutang2;
//Compatibility
//End Page_BeforeShow
global $Label1;
// -------------------------
// Write your own code here.
$doAction = CCGetFromGet('doAction', '');
if ($doAction != '') {
$p_vat_type_id = CCGetFromGet("p_vat_type_id", "");
$p_year_period_id = CCGetFromGet("p_year_period_id", "");
$tgl_penerimaan = CCGetFromGet("tgl_penerimaan", "");
$tgl_penerimaan_last = CCGetFromGet("tgl_penerimaan_last", "");
$year_code = CCGetFromGet("year_code", "");
$kode_wilayah = CCGetFromGet("kode_wilayah", "");
$tgl_penerimaan = "'" . $tgl_penerimaan . "'";
$tgl_penerimaan_last = "'" . $tgl_penerimaan_last . "'";
$kode_wilayah = "'" . $kode_wilayah . "'";
$date_start = str_replace("'", "", $year_code);
$year_date = $year_code;
$user = CCGetUserLogin();
$data = array();
$dbConn = new clsDBConnSIKP();
$jenis_laporan = CCGetFromGet("jenis_laporan", "all");
$query = "select to_char(active_date,'dd-mm-yyyy') as active_date2,*,\r\n\t\t\tcase \r\n\t\t\t\twhen payment_date is not null then to_char(payment_date,'dd-mm-yyyy')\r\n\t\t\t\telse ''\r\n\t\t\tend as payment_date \r\n\t\tfrom f_rep_bpps_piutang2new_mod_2_per_wilayah({$p_vat_type_id}, {$p_year_period_id}, {$tgl_penerimaan}, {$tgl_penerimaan_last}, 1,{$kode_wilayah}) a\r\n\t\tleft join t_cust_account x on a.npwpd = x.npwd \r\n\t\torder by kode_ayat, npwpd, masa_pajak";
//echo $query; exit;
$dbConn->query($query);
$tgl_penerimaan = str_replace("'", "", $tgl_penerimaan);
$tgl_penerimaan_last = str_replace("'", "", $tgl_penerimaan_last);
$tahun = date("Y", strtotime($tgl_penerimaan));
while ($dbConn->next_record()) {
$data[] = array("address" => $dbConn->f("address"), "company_name" => $dbConn->f("company_name"), "kode_jns_trans" => $dbConn->f("kode_jns_trans"), "jns_trans" => $dbConn->f("jns_trans"), "kode_jns_pajak" => $dbConn->f("kode_jns_pajak"), "kode_ayat" => $dbConn->f("kode_ayat"), "jns_pajak" => $dbConn->f("jns_pajak"), "jns_ayat" => $dbConn->f("jns_ayat"), "nama_ayat" => $dbConn->f("nama_ayat"), "no_kohir" => $dbConn->f("no_kohir"), "wp_name" => $dbConn->f("company_brand"), "wp_address_name" => $dbConn->f("brand_address_name"), "wp_address_no" => $dbConn->f("brand_address_no"), "active_date2" => $dbConn->f("active_date2"), "npwpd" => $dbConn->f("npwpd"), "jumlah_terima" => $dbConn->f("jumlah_terima"), "masa_pajak" => $dbConn->f("masa_pajak"), "kd_tap" => $dbConn->f("kd_tap"), "keterangan" => $dbConn->f("keterangan"), "payment_date" => $dbConn->f("payment_date"), "jam" => $dbConn->f("jam"));
}
}
if ($doAction == 'view_html2') {
$Label1->SetText(GetCetakHTML2($data));
}
if ($doAction == 'view_excel') {
GetCetakHTML2($data);
}
// -------------------------
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
作者：rayminam
项目：mpd-onlin
function t_vat_setllementForm_Button1_OnClick(&$sender)
{
$t_vat_setllementForm_Button1_OnClick = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_vat_setllementForm;
//Compatibility
//End t_vat_setllementForm_Button1_OnClick
//Custom Code @165-2A29BDB7
// -------------------------
// Write your own code here.
// -------------------------
//End Custom Code
// -------------------------
// Write your own code here.
$dbConn = new clsDBConnSIKP();
$cusAccId = $t_vat_setllementForm->t_cust_account_id->GetValue();
$User = CCGetUserLogin();
$p_account_status_id = $t_vat_setllementForm->p_account_status_id->GetValue();
$reason_status_id = $t_vat_setllementForm->reason_status_id->GetValue();
$reason_description = $t_vat_setllementForm->reason_description->GetValue();
$errorMsg = '';
//new fix
if (!isset($p_vat_type_dtl_cls_id) || $p_vat_type_dtl_cls_id == '') {
$p_vat_type_dtl_cls_id = 'NULL';
}
if (empty($kamar)) {
$kamar = 0;
}
//cek alasan lainnya
if ($reason_status_id == 4 and !isset($reason_description) || $reason_description == '') {
echo "<script> \r\n\t\t\talert('Keterangan harus diisi jika memilih alasan Lainnya');\r\n\t\t</script>";
} else {
$sql = "select * from f_entry_mutasi_status_wp(" . $cusAccId . ",15," . $p_account_status_id . "," . $reason_status_id . ",'" . $reason_description . "','" . $User . "')";
//echo $sql;
//die($sql);
$dbConn->query($sql);
$dbConn->next_record();
$cust_id = $dbConn->f("o_cust_order_id");
$mess = $dbConn->f("o_mess");
//modified by wiliam
echo "<script> \r\n\t\t\talert('" . $mess . "');\r\n\t\t\twindow.opener.location.reload();\r\n\t\t\twindow.close();\r\n\t\t</script>";
exit;
}
// -------------------------
//Close t_vat_setllementForm_Button1_OnClick @164-6DBB2532
//return $t_vat_setllementForm_Button1_OnClick;
}
作者：rayminam
项目：mpd-onlin
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_rep_lap_harian_v2;
//Compatibility
//End Page_BeforeShow
//Custom Code @562-2A29BDB7
// -------------------------
// Write your own code here.
global $Label1;
$tampil = CCGetFromGet('tampil');
if ($tampil == 'T') {
$Label1->SetText("<table border=1><tr><td>tes</td></tr></table>");
$tgl_penerimaan = CCGetFromGet("tgl_penerimaan", "");
//'15-12-2013';
// $tgl_penerimaan = '15-12-2013';
$user = CCGetUserLogin();
$data = array();
$dbConn = new clsDBConnSIKP();
$tgl_penerimaan = str_replace("'", "", $tgl_penerimaan);
$query = " \r\n\t\t\t\tselect\r\n\t\t\t\t\tnama_jns_pajak,sum(jml_sd_hari_ini) as realisasi,p_vat_type_id \r\n\t\t\t\tfrom f_rep_lap_harian_bdhr_mod_1('" . $tgl_penerimaan . "') \r\n\t\t\t\twhere p_vat_type_id in (1,2,3,4,5,6)\r\n\t\t\t\tGROUP BY nama_jns_pajak,p_vat_type_id\r\n\t\t\t\tORDER BY p_vat_type_id";
//echo $query;exit;
$tgl_penerimaan = str_replace("'", "", $tgl_penerimaan);
$dbConn->query($query);
while ($dbConn->next_record()) {
$data['nama_jns_pajak'][] = $dbConn->f('nama_jns_pajak');
$data['realisasi'][] = $dbConn->f('realisasi');
$data['p_vat_type_id'][] = $dbConn->f('p_vat_type_id');
}
$dbConn->close();
$excel = CCGetFromGet('excel');
if ($excel == 'T') {
GetCetakExcel($data, $user, $tgl_penerimaan);
} else {
$Label1->SetText(PageCetak($data, $user, $tgl_penerimaan));
}
}
// -------------------------
//End Custom Code
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
作者：rayminam
项目：mpd-onlin
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_rep_lap_bpps_piutang2;
//Compatibility
//End Page_BeforeShow
global $Label1;
// -------------------------
// Write your own code here.
$doAction = CCGetFromGet('doAction');
if ($doAction == 'view_html') {
$p_vat_type_id = CCGetFromGet("p_vat_type_id", "");
//$year_code = CCGetFromGet("year_code", "");
$tgl_penerimaan = "'01-01-2010'";
$tgl_penerimaan_last = "'31-12-2014'";
$i_flag_setoran = 1;
$p_year_period_id = 4;
//year_period_id 4 = 2013
//year_period_id 16 = 2014
$date_start = str_replace("'", "", $year_code);
//$year_date = DateTime::createFromFormat('d-m-Y', $date_start)->format('Y');
$year_date = $year_code;
$user = CCGetUserLogin();
$data = array();
$dbConn = new clsDBConnSIKP();
$jenis_laporan = "all";
$query = "select *,trunc(payment_date) \r\n\t\t\tfrom f_rep_bpps_piutang2new_rm_masuk_resto({$p_vat_type_id}, {$p_year_period_id}, {$tgl_penerimaan}, to_char(sysdate,'dd-mm-yyyy'), {$i_flag_setoran}) \r\n\t\t\torder by p_vat_type_dtl_id, wp_name,npwpd, payment_date";
//echo $query; exit;
$dbConn->query($query);
$tgl_penerimaan = str_replace("'", "", $tgl_penerimaan);
$tgl_penerimaan_last = str_replace("'", "", $tgl_penerimaan_last);
$tahun = date("Y", strtotime($tgl_penerimaan));
while ($dbConn->next_record()) {
$data[] = array("address" => $dbConn->f("address"), "company_name" => $dbConn->f("company_name"), "kode_jns_trans" => $dbConn->f("kode_jns_trans"), "jns_trans" => $dbConn->f("jns_trans"), "kode_jns_pajak" => $dbConn->f("kode_jns_pajak"), "kode_ayat" => $dbConn->f("kode_ayat"), "jns_pajak" => $dbConn->f("jns_pajak"), "jns_ayat" => $dbConn->f("jns_ayat"), "nama_ayat" => $dbConn->f("nama_ayat"), "no_kohir" => $dbConn->f("no_kohir"), "wp_name" => $dbConn->f("wp_name"), "wp_address_name" => $dbConn->f("wp_address_name"), "wp_address_no" => $dbConn->f("wp_address_no"), "npwpd" => $dbConn->f("npwpd"), "jumlah_terima" => $dbConn->f("jumlah_terima"), "masa_pajak" => $dbConn->f("masa_pajak"), "kd_tap" => $dbConn->f("kd_tap"), "keterangan" => $dbConn->f("keterangan"), "payment_date" => $dbConn->f("payment_date"), "jam" => $dbConn->f("jam"));
}
$dbConn->close();
$Label1->SetText(GetCetakHTML($data));
}
// -------------------------
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
作者：rayminam
项目：mpd-onlin
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_bphtb_registration_list_check_date;
//Compatibility
//End Page_BeforeShow
//Custom Code @703-2A29BDB7
// -------------------------
// Write your own code here.
global $Label1;
if (CCGetFromGet("doAction") == "html") {
$s_keyword = CCGetFromGet("s_keyword", "");
$date_start_laporan = CCGetFromGet("date_start_laporan", "");
$date_end_laporan = CCGetFromGet("date_end_laporan", "");
$user = CCGetUserLogin();
$data = array();
$dbConn = new clsDBConnSIKP();
$query = "SELECT * FROM t_payment_receipt_bphtb x\r\n\t\t\tLEFT JOIN t_bphtb_registration y ON y.t_bphtb_registration_id = x.t_bphtb_registration_id\r\n\t\t\tLEFT JOIN t_customer_order z ON y.t_customer_order_id = z.t_customer_order_id\r\n\t\t\tWHERE\r\n\t\t\t\tcheck_date IS NOT NULL\r\n\t\t\tAND wp_name ILIKE '%{$s_keyword}%'";
if ($date_end_laporan != "" && $date_start_laporan != "") {
$query .= "AND(check_date BETWEEN to_date ('{$date_start_laporan}') AND ('{$date_end_laporan}'))";
} else {
if ($date_end_laporan != "") {
$query .= "AND(check_date <= to_date ('{$date_end_laporan}') )";
}
if ($date_start_laporan != "") {
$query .= "AND(check_date >= to_date ('{$date_start_laporan}') )";
}
}
$dbConn->query($query);
while ($dbConn->next_record()) {
$data[] = array("wp_name" => $dbConn->f("wp_name"), "order_no" => $dbConn->f("order_no"), "receipt_no" => $dbConn->f("receipt_no"), "check_date" => $dbConn->f("check_date"), "wp_address_name" => $dbConn->f("wp_address_name"), "t_payment_receipt_id" => $dbConn->f("t_payment_receipt_id"), "t_bphtb_registration_id" => $dbConn->f("t_bphtb_registration_id"), "bphtb_registration_no" => $dbConn->f("bphtb_registration_no"), "t_customer_order_id" => $dbConn->f("t_customer_order_id"), "payment_date" => $dbConn->f("payment_date"), "payment_vat_amount" => $dbConn->f("payment_vat_amount"));
}
$dbConn->close();
$Label1->SetText(GetCetakHTML($data));
}
// -------------------------
//End Custom Code
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
作者：rayminam
项目：chumani
function MasterPage_OnInitializeView(&$sender)
{
$MasterPage_OnInitializeView = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $MasterPage;
//Compatibility
//End MasterPage_OnInitializeView
//Custom Code @8-2A29BDB7
// -------------------------
// Write your own code here.
if (CCGetUserLogin() == "") {
header("Location: login.php");
exit;
}
// -------------------------
//End Custom Code
//Close MasterPage_OnInitializeView @1-CF24638A
return $MasterPage_OnInitializeView;
}
作者：rayminam
项目：mpd-onlin
function t_vat_registrationForm_Button7_OnClick(&$sender)
{
$t_vat_registrationForm_Button7_OnClick = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_vat_registrationForm;
//Compatibility
//End t_vat_registrationForm_Button7_OnClick
$sql = "select f_update_acc_status(" . $t_vat_registrationForm->t_cust_account_id->Value . ",3,'TUTUP SEMENTARA POSISI PIUTANG',sysdate, '" . CCGetUserLogin() . "')";
$dbConn = new clsDBConnSIKP();
if ($dbConn->query($sql)) {
$dbConn->next_record();
if ($dbConn->Record['o_result_msg'] != 'OK') {
$t_vat_registrationForm->Errors->addError($dbConn->Record['o_result_msg']);
}
} else {
$t_vat_registrationForm->Errors->addError('Gagal update status');
}
//Close t_vat_registrationForm_Button7_OnClick @961-41E34245
return $t_vat_registrationForm_Button7_OnClick;
}
作者：rayminam
项目：mpd-onlin
function t_vat_setllementForm_Button1_OnClick(&$sender)
{
$t_vat_setllementForm_Button1_OnClick = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_vat_setllementForm;
//Compatibility
//End t_vat_setllementForm_Button1_OnClick
//Custom Code @165-2A29BDB7
// -------------------------
// Write your own code here.
// -------------------------
//End Custom Code
// -------------------------
// Write your own code here.
$dbConn = new clsDBConnSIKP();
$User = CCGetUserLogin();
$t_bphtb_registration_id = $t_vat_setllementForm->t_bphtb_registration_id->GetValue();
$alasan = $t_vat_setllementForm->alasan->GetValue();
$njop_pbb = $t_vat_setllementForm->njop_pbb->GetValue();
$bphtb_amt_final = $t_vat_setllementForm->bphtb_amt_final->GetValue();
$bphtb_amt_final_keberatan = $t_vat_setllementForm->bphtb_amt_final_keberatan->GetValue();
$errorMsg = '';
$sql = "select * from f_insert_bphtb_keberatan(" . $t_bphtb_registration_id . ",19," . $bphtb_amt_final_keberatan . "," . $bphtb_amt_final . ",'" . $alasan . "','" . $User . "')";
//echo $sql;
//die($sql);
$dbConn->query($sql);
$dbConn->next_record();
$t_bphtb_keberatan_id = $dbConn->f("o_t_bphtb_keberatan_id");
$t_customer_order_id = $dbConn->f("o_t_customer_order_id");
$mess = $dbConn->f("o_mess");
$sql = "select sikp.f_first_submit_engine(511," . $t_customer_order_id . ",'" . CCGetSession('UserLogin') . "')";
$dbConn->query($sql);
//modified by wiliam
echo "<script> \r\n\t\talert('" . $mess . "');\r\n\t\twindow.opener.location.reload();\r\n\t\twindow.close();\r\n\t</script>";
// -------------------------
//Close t_vat_setllementForm_Button1_OnClick @164-6DBB2532
//return $t_vat_setllementForm_Button1_OnClick;
}
作者：rayminam
项目：mpd-onlin
function Update()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$this->cp["p_vat_type_id"] = new clsSQLParameter("ctrlp_vat_type_id", ccsFloat, "", "", $this->p_vat_type_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["registration_date"] = new clsSQLParameter("ctrlregistration_date", ccsText, "", "", $this->registration_date->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["company_name"] = new clsSQLParameter("ctrlcompany_name", ccsText, "", "", $this->company_name->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["company_brand"] = new clsSQLParameter("ctrlcompany_brand", ccsText, "", "", $this->company_brand->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["address_no"] = new clsSQLParameter("ctrladdress_no", ccsText, "", "", $this->address_no->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["address_name"] = new clsSQLParameter("ctrladdress_name", ccsText, "", "", $this->address_name->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["address_rt"] = new clsSQLParameter("ctrladdress_rt", ccsText, "", "", $this->address_rt->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["address_rw"] = new clsSQLParameter("ctrladdress_rw", ccsText, "", "", $this->address_rw->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["p_region_id_kelurahan"] = new clsSQLParameter("ctrlp_region_id_kelurahan", ccsText, "", "", $this->p_region_id_kelurahan->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["p_region_id_kecamatan"] = new clsSQLParameter("ctrlp_region_id_kecamatan", ccsText, "", "", $this->p_region_id_kecamatan->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["p_region_id"] = new clsSQLParameter("ctrlp_region_id", ccsText, "", "", $this->p_region_id->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["phone_no"] = new clsSQLParameter("ctrlphone_no", ccsText, "", "", $this->phone_no->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["mobile_no"] = new clsSQLParameter("ctrlmobile_no", ccsText, "", "", $this->mobile_no->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["fax_no"] = new clsSQLParameter("ctrlfax_no", ccsText, "", "", $this->fax_no->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["zip_code"] = new clsSQLParameter("ctrlzip_code", ccsText, "", "", $this->zip_code->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["updated_by"] = new clsSQLParameter("ctrlupdated_by", ccsText, "", "", $this->updated_by->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["t_cust_account_id"] = new clsSQLParameter("ctrlt_cust_account_id", ccsText, "", "", $this->t_cust_account_id->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["npwd"] = new clsSQLParameter("ctrlnpwd", ccsText, "", "", $this->npwd->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["wp_name"] = new clsSQLParameter("ctrlwp_name", ccsText, "", "", $this->wp_name->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["wp_address_name"] = new clsSQLParameter("ctrlwp_address_name", ccsText, "", "", $this->wp_address_name->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["wp_address_no"] = new clsSQLParameter("ctrlwp_address_no", ccsText, "", "", $this->wp_address_no->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["wp_address_rt"] = new clsSQLParameter("ctrlwp_address_rt", ccsText, "", "", $this->wp_address_rt->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["wp_address_rw"] = new clsSQLParameter("ctrlwp_address_rw", ccsText, "", "", $this->wp_address_rw->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["wp_p_region_id_kelurahan"] = new clsSQLParameter("ctrlwp_p_region_id_kelurahan", ccsFloat, "", "", $this->wp_p_region_id_kelurahan->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["wp_p_region_id_kecamatan"] = new clsSQLParameter("ctrlwp_p_region_id_kecamatan", ccsFloat, "", "", $this->wp_p_region_id_kecamatan->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["wp_p_region_id"] = new clsSQLParameter("ctrlwp_p_region_id", ccsFloat, "", "", $this->wp_p_region_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["wp_phone_no"] = new clsSQLParameter("ctrlwp_phone_no", ccsText, "", "", $this->wp_phone_no->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["wp_mobile_no"] = new clsSQLParameter("ctrlwp_mobile_no", ccsText, "", "", $this->wp_mobile_no->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["wp_fax_no"] = new clsSQLParameter("ctrlwp_fax_no", ccsText, "", "", $this->wp_fax_no->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["wp_zip_code"] = new clsSQLParameter("ctrlwp_zip_code", ccsText, "", "", $this->wp_zip_code->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["wp_email"] = new clsSQLParameter("ctrlwp_email", ccsText, "", "", $this->wp_email->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["brand_address_name"] = new clsSQLParameter("ctrlbrand_address_name", ccsText, "", "", $this->brand_address_name->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["brand_address_no"] = new clsSQLParameter("ctrlbrand_address_no", ccsText, "", "", $this->brand_address_no->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["brand_address_rt"] = new clsSQLParameter("ctrlbrand_address_rt", ccsText, "", "", $this->brand_address_rt->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["brand_address_rw"] = new clsSQLParameter("ctrlbrand_address_rw", ccsText, "", "", $this->brand_address_rw->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["brand_p_region_id_kel"] = new clsSQLParameter("ctrlbrand_p_region_id_kel", ccsFloat, "", "", $this->brand_p_region_id_kel->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["brand_p_region_id_kec"] = new clsSQLParameter("ctrlbrand_p_region_id_kec", ccsFloat, "", "", $this->brand_p_region_id_kec->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["brand_p_region_id"] = new clsSQLParameter("ctrlbrand_p_region_id", ccsFloat, "", "", $this->brand_p_region_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["brand_phone_no"] = new clsSQLParameter("ctrlbrand_phone_no", ccsText, "", "", $this->brand_phone_no->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["brand_mobile_no"] = new clsSQLParameter("ctrlbrand_mobile_no", ccsText, "", "", $this->brand_mobile_no->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["brand_fax_no"] = new clsSQLParameter("ctrlbrand_fax_no", ccsText, "", "", $this->brand_fax_no->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["brand_zip_code"] = new clsSQLParameter("ctrlbrand_zip_code", ccsText, "", "", $this->brand_zip_code->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["p_account_status_id"] = new clsSQLParameter("ctrlp_account_status_id", ccsFloat, "", "", $this->p_account_status_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["activation_no"] = new clsSQLParameter("ctrlactivation_no", ccsText, "", "", $this->activation_no->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["p_vat_type_dtl_id"] = new clsSQLParameter("ctrlp_vat_type_dtl_id", ccsFloat, "", "", $this->p_vat_type_dtl_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["modification_by"] = new clsSQLParameter("expr651", ccsText, "", "", CCGetUserLogin(), "", false, $this->ErrorBlock);
$this->cp["company_owner"] = new clsSQLParameter("ctrlcompany_owner", ccsText, "", "", $this->company_owner->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["p_job_position_id"] = new clsSQLParameter("ctrlp_job_position_id", ccsInteger, "", "", $this->p_job_position_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["address_name_owner"] = new clsSQLParameter("ctrladdress_name_owner", ccsText, "", "", $this->address_name_owner->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["address_no_owner"] = new clsSQLParameter("ctrladdress_no_owner", ccsText, "", "", $this->address_no_owner->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["address_rt_owner"] = new clsSQLParameter("ctrladdress_rt_owner", ccsText, "", "", $this->address_rt_owner->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["address_rw_owner"] = new clsSQLParameter("ctrladdress_rw_owner", ccsText, "", "", $this->address_rw_owner->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["p_region_id_owner"] = new clsSQLParameter("ctrlp_region_id_owner", ccsInteger, "", "", $this->p_region_id_owner->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["p_region_id_kec_owner"] = new clsSQLParameter("ctrlp_region_id_kec_owner", ccsInteger, "", "", $this->p_region_id_kec_owner->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["p_region_id_kel_owner"] = new clsSQLParameter("ctrlp_region_id_kel_owner", ccsInteger, "", "", $this->p_region_id_kel_owner->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["phone_no_owner"] = new clsSQLParameter("ctrlphone_no_owner", ccsText, "", "", $this->phone_no_owner->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["fax_no_owner"] = new clsSQLParameter("ctrlfax_no_owner", ccsText, "", "", $this->fax_no_owner->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["mobile_no_owner"] = new clsSQLParameter("ctrlmobile_no_owner", ccsText, "", "", $this->mobile_no_owner->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["email_address"] = new clsSQLParameter("ctrlemail_address", ccsText, "", "", $this->email_address->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["zip_code_owner"] = new clsSQLParameter("ctrlzip_code_owner", ccsText, "", "", $this->zip_code_owner->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["t_customer_id"] = new clsSQLParameter("ctrlt_customer_id", ccsInteger, "", "", $this->t_customer_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["t_cust_acc_masa_jab_detail_id"] = new clsSQLParameter("ctrlt_cust_acc_masa_jab_detail_id", ccsInteger, "", "", $this->t_cust_acc_masa_jab_detail_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
if (!is_null($this->cp["p_vat_type_id"]->GetValue()) and !strlen($this->cp["p_vat_type_id"]->GetText()) and !is_bool($this->cp["p_vat_type_id"]->GetValue())) {
$this->cp["p_vat_type_id"]->SetValue($this->p_vat_type_id->GetValue(true));
}
if (!strlen($this->cp["p_vat_type_id"]->GetText()) and !is_bool($this->cp["p_vat_type_id"]->GetValue(true))) {
$this->cp["p_vat_type_id"]->SetText(0);
}
if (!is_null($this->cp["registration_date"]->GetValue()) and !strlen($this->cp["registration_date"]->GetText()) and !is_bool($this->cp["registration_date"]->GetValue())) {
$this->cp["registration_date"]->SetValue($this->registration_date->GetValue(true));
}
if (!is_null($this->cp["company_name"]->GetValue()) and !strlen($this->cp["company_name"]->GetText()) and !is_bool($this->cp["company_name"]->GetValue())) {
$this->cp["company_name"]->SetValue($this->company_name->GetValue(true));
}
if (!is_null($this->cp["company_brand"]->GetValue()) and !strlen($this->cp["company_brand"]->GetText()) and !is_bool($this->cp["company_brand"]->GetValue())) {
$this->cp["company_brand"]->SetValue($this->company_brand->GetValue(true));
}
if (!is_null($this->cp["address_no"]->GetValue()) and !strlen($this->cp["address_no"]->GetText()) and !is_bool($this->cp["address_no"]->GetValue())) {
$this->cp["address_no"]->SetValue($this->address_no->GetValue(true));
}
if (!is_null($this->cp["address_name"]->GetValue()) and !strlen($this->cp["address_name"]->GetText()) and !is_bool($this->cp["address_name"]->GetValue())) {
$this->cp["address_name"]->SetValue($this->address_name->GetValue(true));
}
if (!is_null($this->cp["address_rt"]->GetValue()) and !strlen($this->cp["address_rt"]->GetText()) and !is_bool($this->cp["address_rt"]->GetValue())) {
$this->cp["address_rt"]->SetValue($this->address_rt->GetValue(true));
}
if (!is_null($this->cp["address_rw"]->GetValue()) and !strlen($this->cp["address_rw"]->GetText()) and !is_bool($this->cp["address_rw"]->GetValue())) {
$this->cp["address_rw"]->SetValue($this->address_rw->GetValue(true));
}
if (!is_null($this->cp["p_region_id_kelurahan"]->GetValue()) and !strlen($this->cp["p_region_id_kelurahan"]->GetText()) and !is_bool($this->cp["p_region_id_kelurahan"]->GetValue())) {
$this->cp["p_region_id_kelurahan"]->SetValue($this->p_region_id_kelurahan->GetValue(true));
}
if (!is_null($this->cp["p_region_id_kecamatan"]->GetValue()) and !strlen($this->cp["p_region_id_kecamatan"]->GetText()) and !is_bool($this->cp["p_region_id_kecamatan"]->GetValue())) {
$this->cp["p_region_id_kecamatan"]->SetValue($this->p_region_id_kecamatan->GetValue(true));
//.........这里部分代码省略.........
作者：rayminam
项目：mpd-onlin
<?php
define("RelativePath", "..");
define("PathToCurrentPage", "/report/");
define("FileName", "cetak_rep_bpps.php");
include_once RelativePath . "/Common.php";
// include_once("../include/fpdf.php");
require "../include/qrcode/fpdf17/fpdf.php";
$t_bphtb_registration_id = CCGetFromGet("t_bphtb_registration_id", "");
// $t_bphtb_registration_id = 23;
$user = CCGetUserLogin();
$data = array();
$dbConn = new clsDBConnSIKP();
$query = "select a.*,\r\nb.region_name as wp_region,\r\nc.region_name as wp_region_kec,\r\nd.region_name as wp_region_kel,\r\ne.region_name as object_region,\r\nf.region_name as object_region_kec,\r\ng.region_name as object_region_kel,\r\nh.description as doc_name,\r\n(a.bphtb_amt - a.bphtb_discount) AS bphtb_amt_final_old,\r\nj.payment_vat_amount AS prev_payment_amount\r\n\r\n\r\nfrom t_bphtb_registration as a \r\nleft join p_region as b\r\n\ton a.wp_p_region_id = b.p_region_id\r\nleft join p_region as c\r\n\ton a.wp_p_region_id_kec = c.p_region_id\r\nleft join p_region as d\r\n\ton a.wp_p_region_id_kel = d.p_region_id\r\nleft join p_region as e\r\n\ton a.object_p_region_id = e.p_region_id\r\nleft join p_region as f\r\n\ton a.object_p_region_id_kec = f.p_region_id\r\nleft join p_region as g\r\n\ton a.object_p_region_id_kel = g.p_region_id\r\nleft join p_bphtb_legal_doc_type as h\r\n\ton a.p_bphtb_legal_doc_type_id = h.p_bphtb_legal_doc_type_id\r\nleft join t_bphtb_registration as i\r\n\ton a.registration_no_ref = i.registration_no\r\nleft join t_payment_receipt_bphtb as j\r\n\ton i.t_bphtb_registration_id = j.t_bphtb_registration_id\r\nwhere a.t_bphtb_registration_id = {$t_bphtb_registration_id}";
$dbConn->query($query);
while ($dbConn->next_record()) {
$data["wp_name"] = $dbConn->f("wp_name");
$data["npwp"] = $dbConn->f("npwp");
$data["wp_address_name"] = $dbConn->f("wp_address_name");
$data["wp_rt"] = $dbConn->f("wp_rt");
$data["wp_rw"] = $dbConn->f("wp_rw");
$data["wp_region"] = $dbConn->f("wp_region");
$data["wp_region_kec"] = $dbConn->f("wp_region_kec");
$data["wp_region_kel"] = $dbConn->f("wp_region_kel");
$data["njop_pbb"] = $dbConn->f("njop_pbb");
$data["object_address_name"] = $dbConn->f("object_address_name");
$data["object_rt"] = $dbConn->f("object_rt");
$data["object_rw"] = $dbConn->f("object_rw");
$data["object_region"] = $dbConn->f("object_region");
$data["object_region_kec"] = $dbConn->f("object_region_kec");
$data["object_region_kel"] = $dbConn->f("object_region_kel");
作者：rayminam
项目：mpd-onlin
function Update()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$this->cp["block_status"] = new clsSQLParameter("ctrlblock_status", ccsText, "", "", $this->block_status->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["alasan"] = new clsSQLParameter("ctrlalasan", ccsText, "", "", $this->alasan->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["username"] = new clsSQLParameter("expr47", ccsText, "", "", CCGetUserLogin(), "", false, $this->ErrorBlock);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
if (!is_null($this->cp["block_status"]->GetValue()) and !strlen($this->cp["block_status"]->GetText()) and !is_bool($this->cp["block_status"]->GetValue())) {
$this->cp["block_status"]->SetValue($this->block_status->GetValue(true));
}
if (!is_null($this->cp["alasan"]->GetValue()) and !strlen($this->cp["alasan"]->GetText()) and !is_bool($this->cp["alasan"]->GetValue())) {
$this->cp["alasan"]->SetValue($this->alasan->GetValue(true));
}
if (!is_null($this->cp["username"]->GetValue()) and !strlen($this->cp["username"]->GetText()) and !is_bool($this->cp["username"]->GetValue())) {
$this->cp["username"]->SetValue(CCGetUserLogin());
}
$this->SQL = "select * from f_update_block_piutang\n" . "('" . $this->SQLValue($this->cp["block_status"]->GetDBValue(), ccsText) . "','" . $this->SQLValue($this->cp["alasan"]->GetDBValue(), ccsText) . "','" . $this->SQLValue($this->cp["username"]->GetDBValue(), ccsText) . "')";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
if ($this->Errors->Count() == 0 && $this->CmdExecution) {
$this->query($this->SQL);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
}
}
作者：rayminam
项目：mpd-onlin
function Update()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$this->cp["code"] = new clsSQLParameter("ctrlcode", ccsText, "", "", $this->code->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["value"] = new clsSQLParameter("ctrlvalue", ccsText, "", "", $this->value->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["type_1"] = new clsSQLParameter("ctrltype_1", ccsText, "", "", $this->type_1->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["is_range"] = new clsSQLParameter("ctrlis_range", ccsText, "", "", $this->is_range->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["value_2"] = new clsSQLParameter("ctrlvalue_2", ccsText, "", "", $this->value_2->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["description"] = new clsSQLParameter("ctrldescription", ccsText, "", "", $this->description->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["updated_by"] = new clsSQLParameter("expr198", ccsText, "", "", CCGetUserLogin(), "", false, $this->ErrorBlock);
$this->cp["p_global_param_id"] = new clsSQLParameter("ctrlp_global_param_id", ccsFloat, "", "", $this->p_global_param_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
if (!is_null($this->cp["code"]->GetValue()) and !strlen($this->cp["code"]->GetText()) and !is_bool($this->cp["code"]->GetValue())) {
$this->cp["code"]->SetValue($this->code->GetValue(true));
}
if (!is_null($this->cp["value"]->GetValue()) and !strlen($this->cp["value"]->GetText()) and !is_bool($this->cp["value"]->GetValue())) {
$this->cp["value"]->SetValue($this->value->GetValue(true));
}
if (!is_null($this->cp["type_1"]->GetValue()) and !strlen($this->cp["type_1"]->GetText()) and !is_bool($this->cp["type_1"]->GetValue())) {
$this->cp["type_1"]->SetValue($this->type_1->GetValue(true));
}
if (!is_null($this->cp["is_range"]->GetValue()) and !strlen($this->cp["is_range"]->GetText()) and !is_bool($this->cp["is_range"]->GetValue())) {
$this->cp["is_range"]->SetValue($this->is_range->GetValue(true));
}
if (!is_null($this->cp["value_2"]->GetValue()) and !strlen($this->cp["value_2"]->GetText()) and !is_bool($this->cp["value_2"]->GetValue())) {
$this->cp["value_2"]->SetValue($this->value_2->GetValue(true));
}
if (!is_null($this->cp["description"]->GetValue()) and !strlen($this->cp["description"]->GetText()) and !is_bool($this->cp["description"]->GetValue())) {
$this->cp["description"]->SetValue($this->description->GetValue(true));
}
if (!is_null($this->cp["updated_by"]->GetValue()) and !strlen($this->cp["updated_by"]->GetText()) and !is_bool($this->cp["updated_by"]->GetValue())) {
$this->cp["updated_by"]->SetValue(CCGetUserLogin());
}
if (!is_null($this->cp["p_global_param_id"]->GetValue()) and !strlen($this->cp["p_global_param_id"]->GetText()) and !is_bool($this->cp["p_global_param_id"]->GetValue())) {
$this->cp["p_global_param_id"]->SetValue($this->p_global_param_id->GetValue(true));
}
if (!strlen($this->cp["p_global_param_id"]->GetText()) and !is_bool($this->cp["p_global_param_id"]->GetValue(true))) {
$this->cp["p_global_param_id"]->SetText(0);
}
$this->SQL = "update p_global_param \n" . "set code=upper('" . $this->SQLValue($this->cp["code"]->GetDBValue(), ccsText) . "'), \n" . "value='" . $this->SQLValue($this->cp["value"]->GetDBValue(), ccsText) . "', \n" . "type_1='" . $this->SQLValue($this->cp["type_1"]->GetDBValue(), ccsText) . "', \n" . "is_range='" . $this->SQLValue($this->cp["is_range"]->GetDBValue(), ccsText) . "', \n" . "value_2='" . $this->SQLValue($this->cp["value_2"]->GetDBValue(), ccsText) . "', \n" . "description='" . $this->SQLValue($this->cp["description"]->GetDBValue(), ccsText) . "', \n" . "updated_date=sysdate,\n" . "updated_by='" . $this->SQLValue($this->cp["updated_by"]->GetDBValue(), ccsText) . "'\n" . "where p_global_param_id = " . $this->SQLValue($this->cp["p_global_param_id"]->GetDBValue(), ccsFloat) . "";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
if ($this->Errors->Count() == 0 && $this->CmdExecution) {
$this->query($this->SQL);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
}
}
作者：rayminam
项目：mpd-onlin
function Update()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$this->cp["t_cacc_dtl_restaurant_id"] = new clsSQLParameter("ctrlt_cacc_dtl_restaurant_id", ccsFloat, "", "", $this->t_cacc_dtl_restaurant_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["description"] = new clsSQLParameter("ctrldescription", ccsText, "", "", $this->description->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["updated_by"] = new clsSQLParameter("expr804", ccsText, "", "", CCGetUserLogin(), "", false, $this->ErrorBlock);
$this->cp["t_cust_account_id"] = new clsSQLParameter("ctrlt_cust_account_id", ccsFloat, "", "", $this->t_cust_account_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["table_qty"] = new clsSQLParameter("ctrltable_qty", ccsText, "", "", $this->table_qty->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["avg_subscription"] = new clsSQLParameter("ctrlavg_subscription", ccsFloat, "", "", $this->avg_subscription->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["seat_qty"] = new clsSQLParameter("ctrlseat_qty", ccsFloat, "", "", $this->seat_qty->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["max_service_qty"] = new clsSQLParameter("ctrlmax_service_qty", ccsFloat, "", "", $this->max_service_qty->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["valid_from"] = new clsSQLParameter("ctrlvalid_from", ccsText, "", "", $this->valid_from->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["valid_to"] = new clsSQLParameter("ctrlvalid_to", ccsText, "", "", $this->valid_to->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["min_food_price"] = new clsSQLParameter("ctrlmin_food_price", ccsFloat, "", "", $this->min_food_price->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["max_food_price"] = new clsSQLParameter("ctrlmax_food_price", ccsFloat, "", "", $this->max_food_price->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["min_beverage_price"] = new clsSQLParameter("ctrlmin_beverage_price", ccsFloat, "", "", $this->min_beverage_price->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["max_beverage_price"] = new clsSQLParameter("ctrlmax_beverage_price", ccsFloat, "", "", $this->max_beverage_price->GetValue(true), 0, false, $this->ErrorBlock);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
if (!is_null($this->cp["t_cacc_dtl_restaurant_id"]->GetValue()) and !strlen($this->cp["t_cacc_dtl_restaurant_id"]->GetText()) and !is_bool($this->cp["t_cacc_dtl_restaurant_id"]->GetValue())) {
$this->cp["t_cacc_dtl_restaurant_id"]->SetValue($this->t_cacc_dtl_restaurant_id->GetValue(true));
}
if (!strlen($this->cp["t_cacc_dtl_restaurant_id"]->GetText()) and !is_bool($this->cp["t_cacc_dtl_restaurant_id"]->GetValue(true))) {
$this->cp["t_cacc_dtl_restaurant_id"]->SetText(0);
}
if (!is_null($this->cp["description"]->GetValue()) and !strlen($this->cp["description"]->GetText()) and !is_bool($this->cp["description"]->GetValue())) {
$this->cp["description"]->SetValue($this->description->GetValue(true));
}
if (!is_null($this->cp["updated_by"]->GetValue()) and !strlen($this->cp["updated_by"]->GetText()) and !is_bool($this->cp["updated_by"]->GetValue())) {
$this->cp["updated_by"]->SetValue(CCGetUserLogin());
}
if (!is_null($this->cp["t_cust_account_id"]->GetValue()) and !strlen($this->cp["t_cust_account_id"]->GetText()) and !is_bool($this->cp["t_cust_account_id"]->GetValue())) {
$this->cp["t_cust_account_id"]->SetValue($this->t_cust_account_id->GetValue(true));
}
if (!strlen($this->cp["t_cust_account_id"]->GetText()) and !is_bool($this->cp["t_cust_account_id"]->GetValue(true))) {
$this->cp["t_cust_account_id"]->SetText(0);
}
if (!is_null($this->cp["table_qty"]->GetValue()) and !strlen($this->cp["table_qty"]->GetText()) and !is_bool($this->cp["table_qty"]->GetValue())) {
$this->cp["table_qty"]->SetValue($this->table_qty->GetValue(true));
}
if (!is_null($this->cp["avg_subscription"]->GetValue()) and !strlen($this->cp["avg_subscription"]->GetText()) and !is_bool($this->cp["avg_subscription"]->GetValue())) {
$this->cp["avg_subscription"]->SetValue($this->avg_subscription->GetValue(true));
}
if (!is_null($this->cp["seat_qty"]->GetValue()) and !strlen($this->cp["seat_qty"]->GetText()) and !is_bool($this->cp["seat_qty"]->GetValue())) {
$this->cp["seat_qty"]->SetValue($this->seat_qty->GetValue(true));
}
if (!is_null($this->cp["max_service_qty"]->GetValue()) and !strlen($this->cp["max_service_qty"]->GetText()) and !is_bool($this->cp["max_service_qty"]->GetValue())) {
$this->cp["max_service_qty"]->SetValue($this->max_service_qty->GetValue(true));
}
if (!is_null($this->cp["valid_from"]->GetValue()) and !strlen($this->cp["valid_from"]->GetText()) and !is_bool($this->cp["valid_from"]->GetValue())) {
$this->cp["valid_from"]->SetValue($this->valid_from->GetValue(true));
}
if (!is_null($this->cp["valid_to"]->GetValue()) and !strlen($this->cp["valid_to"]->GetText()) and !is_bool($this->cp["valid_to"]->GetValue())) {
$this->cp["valid_to"]->SetValue($this->valid_to->GetValue(true));
}
if (!is_null($this->cp["min_food_price"]->GetValue()) and !strlen($this->cp["min_food_price"]->GetText()) and !is_bool($this->cp["min_food_price"]->GetValue())) {
$this->cp["min_food_price"]->SetValue($this->min_food_price->GetValue(true));
}
if (!strlen($this->cp["min_food_price"]->GetText()) and !is_bool($this->cp["min_food_price"]->GetValue(true))) {
$this->cp["min_food_price"]->SetText(0);
}
if (!is_null($this->cp["max_food_price"]->GetValue()) and !strlen($this->cp["max_food_price"]->GetText()) and !is_bool($this->cp["max_food_price"]->GetValue())) {
$this->cp["max_food_price"]->SetValue($this->max_food_price->GetValue(true));
}
if (!strlen($this->cp["max_food_price"]->GetText()) and !is_bool($this->cp["max_food_price"]->GetValue(true))) {
$this->cp["max_food_price"]->SetText(0);
}
if (!is_null($this->cp["min_beverage_price"]->GetValue()) and !strlen($this->cp["min_beverage_price"]->GetText()) and !is_bool($this->cp["min_beverage_price"]->GetValue())) {
$this->cp["min_beverage_price"]->SetValue($this->min_beverage_price->GetValue(true));
}
if (!strlen($this->cp["min_beverage_price"]->GetText()) and !is_bool($this->cp["min_beverage_price"]->GetValue(true))) {
$this->cp["min_beverage_price"]->SetText(0);
}
if (!is_null($this->cp["max_beverage_price"]->GetValue()) and !strlen($this->cp["max_beverage_price"]->GetText()) and !is_bool($this->cp["max_beverage_price"]->GetValue())) {
$this->cp["max_beverage_price"]->SetValue($this->max_beverage_price->GetValue(true));
}
if (!strlen($this->cp["max_beverage_price"]->GetText()) and !is_bool($this->cp["max_beverage_price"]->GetValue(true))) {
$this->cp["max_beverage_price"]->SetText(0);
}
$this->SQL = "UPDATE t_cacc_dtl_restaurant\n" . "SET description='" . $this->SQLValue($this->cp["description"]->GetDBValue(), ccsText) . "', \n" . "updated_by='" . $this->SQLValue($this->cp["updated_by"]->GetDBValue(), ccsText) . "', \n" . "updated_date=sysdate, \n" . "t_cust_account_id=" . $this->SQLValue($this->cp["t_cust_account_id"]->GetDBValue(), ccsFloat) . ", \n" . "table_qty='" . $this->SQLValue($this->cp["table_qty"]->GetDBValue(), ccsText) . "', \n" . "avg_subscription=" . $this->SQLValue($this->cp["avg_subscription"]->GetDBValue(), ccsFloat) . ", \n" . "seat_qty=" . $this->SQLValue($this->cp["seat_qty"]->GetDBValue(), ccsFloat) . ", \n" . "max_service_qty=" . $this->SQLValue($this->cp["max_service_qty"]->GetDBValue(), ccsFloat) . ",\n" . "valid_from = to_date('" . $this->SQLValue($this->cp["valid_from"]->GetDBValue(), ccsText) . "','DD-MON-YYYY'),\n" . "valid_to=case when '" . $this->SQLValue($this->cp["valid_to"]->GetDBValue(), ccsText) . "' = '' then null else to_date('" . $this->SQLValue($this->cp["valid_to"]->GetDBValue(), ccsText) . "','dd-mon-yyyy') end,\n" . "min_food_price=" . $this->SQLValue($this->cp["min_food_price"]->GetDBValue(), ccsFloat) . ",\n" . "max_food_price=" . $this->SQLValue($this->cp["max_food_price"]->GetDBValue(), ccsFloat) . ",\n" . "min_beverage_price=" . $this->SQLValue($this->cp["min_beverage_price"]->GetDBValue(), ccsFloat) . ",\n" . "max_beverage_price=" . $this->SQLValue($this->cp["max_beverage_price"]->GetDBValue(), ccsFloat) . "\n" . "WHERE t_cacc_dtl_restaurant_id=" . $this->SQLValue($this->cp["t_cacc_dtl_restaurant_id"]->GetDBValue(), ccsFloat) . "";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
if ($this->Errors->Count() == 0 && $this->CmdExecution) {
$this->query($this->SQL);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
}
}
作者：rayminam
项目：mpd-onlin
function Update()
{
global $CCSLocales;
global $DefaultDateFormat;
$this->CmdExecution = true;
$this->cp["p_vat_type_id"] = new clsSQLParameter("ctrlp_vat_type_id", ccsFloat, "", "", $this->p_vat_type_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["due_in_day"] = new clsSQLParameter("ctrldue_in_day", ccsFloat, "", "", $this->due_in_day->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["debt_letter1_in_day"] = new clsSQLParameter("ctrldebt_letter1_in_day", ccsFloat, "", "", $this->debt_letter1_in_day->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["debt_letter2_in_day"] = new clsSQLParameter("ctrldebt_letter2_in_day", ccsFloat, "", "", $this->debt_letter2_in_day->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["debt_letter3_in_day"] = new clsSQLParameter("ctrldebt_letter3_in_day", ccsFloat, "", "", $this->debt_letter3_in_day->GetValue(true), 0, false, $this->ErrorBlock);
$this->cp["valid_from"] = new clsSQLParameter("ctrlvalid_from", ccsText, "", "", $this->valid_from->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["valid_to"] = new clsSQLParameter("ctrlvalid_to", ccsText, "", "", $this->valid_to->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["description"] = new clsSQLParameter("ctrldescription", ccsText, "", "", $this->description->GetValue(true), "", false, $this->ErrorBlock);
$this->cp["updated_by"] = new clsSQLParameter("expr182", ccsText, "", "", CCGetUserLogin(), "", false, $this->ErrorBlock);
$this->cp["p_settlement_due_date_id"] = new clsSQLParameter("ctrlp_settlement_due_date_id", ccsFloat, "", "", $this->p_settlement_due_date_id->GetValue(true), 0, false, $this->ErrorBlock);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildUpdate", $this->Parent);
if (!is_null($this->cp["p_vat_type_id"]->GetValue()) and !strlen($this->cp["p_vat_type_id"]->GetText()) and !is_bool($this->cp["p_vat_type_id"]->GetValue())) {
$this->cp["p_vat_type_id"]->SetValue($this->p_vat_type_id->GetValue(true));
}
if (!strlen($this->cp["p_vat_type_id"]->GetText()) and !is_bool($this->cp["p_vat_type_id"]->GetValue(true))) {
$this->cp["p_vat_type_id"]->SetText(0);
}
if (!is_null($this->cp["due_in_day"]->GetValue()) and !strlen($this->cp["due_in_day"]->GetText()) and !is_bool($this->cp["due_in_day"]->GetValue())) {
$this->cp["due_in_day"]->SetValue($this->due_in_day->GetValue(true));
}
if (!strlen($this->cp["due_in_day"]->GetText()) and !is_bool($this->cp["due_in_day"]->GetValue(true))) {
$this->cp["due_in_day"]->SetText(0);
}
if (!is_null($this->cp["debt_letter1_in_day"]->GetValue()) and !strlen($this->cp["debt_letter1_in_day"]->GetText()) and !is_bool($this->cp["debt_letter1_in_day"]->GetValue())) {
$this->cp["debt_letter1_in_day"]->SetValue($this->debt_letter1_in_day->GetValue(true));
}
if (!strlen($this->cp["debt_letter1_in_day"]->GetText()) and !is_bool($this->cp["debt_letter1_in_day"]->GetValue(true))) {
$this->cp["debt_letter1_in_day"]->SetText(0);
}
if (!is_null($this->cp["debt_letter2_in_day"]->GetValue()) and !strlen($this->cp["debt_letter2_in_day"]->GetText()) and !is_bool($this->cp["debt_letter2_in_day"]->GetValue())) {
$this->cp["debt_letter2_in_day"]->SetValue($this->debt_letter2_in_day->GetValue(true));
}
if (!strlen($this->cp["debt_letter2_in_day"]->GetText()) and !is_bool($this->cp["debt_letter2_in_day"]->GetValue(true))) {
$this->cp["debt_letter2_in_day"]->SetText(0);
}
if (!is_null($this->cp["debt_letter3_in_day"]->GetValue()) and !strlen($this->cp["debt_letter3_in_day"]->GetText()) and !is_bool($this->cp["debt_letter3_in_day"]->GetValue())) {
$this->cp["debt_letter3_in_day"]->SetValue($this->debt_letter3_in_day->GetValue(true));
}
if (!strlen($this->cp["debt_letter3_in_day"]->GetText()) and !is_bool($this->cp["debt_letter3_in_day"]->GetValue(true))) {
$this->cp["debt_letter3_in_day"]->SetText(0);
}
if (!is_null($this->cp["valid_from"]->GetValue()) and !strlen($this->cp["valid_from"]->GetText()) and !is_bool($this->cp["valid_from"]->GetValue())) {
$this->cp["valid_from"]->SetValue($this->valid_from->GetValue(true));
}
if (!is_null($this->cp["valid_to"]->GetValue()) and !strlen($this->cp["valid_to"]->GetText()) and !is_bool($this->cp["valid_to"]->GetValue())) {
$this->cp["valid_to"]->SetValue($this->valid_to->GetValue(true));
}
if (!is_null($this->cp["description"]->GetValue()) and !strlen($this->cp["description"]->GetText()) and !is_bool($this->cp["description"]->GetValue())) {
$this->cp["description"]->SetValue($this->description->GetValue(true));
}
if (!is_null($this->cp["updated_by"]->GetValue()) and !strlen($this->cp["updated_by"]->GetText()) and !is_bool($this->cp["updated_by"]->GetValue())) {
$this->cp["updated_by"]->SetValue(CCGetUserLogin());
}
if (!is_null($this->cp["p_settlement_due_date_id"]->GetValue()) and !strlen($this->cp["p_settlement_due_date_id"]->GetText()) and !is_bool($this->cp["p_settlement_due_date_id"]->GetValue())) {
$this->cp["p_settlement_due_date_id"]->SetValue($this->p_settlement_due_date_id->GetValue(true));
}
if (!strlen($this->cp["p_settlement_due_date_id"]->GetText()) and !is_bool($this->cp["p_settlement_due_date_id"]->GetValue(true))) {
$this->cp["p_settlement_due_date_id"]->SetText(0);
}
$this->SQL = "UPDATE p_settlement_due_date SET\n" . "p_vat_type_id = " . $this->SQLValue($this->cp["p_vat_type_id"]->GetDBValue(), ccsFloat) . ", \n" . "due_in_day = " . $this->SQLValue($this->cp["due_in_day"]->GetDBValue(), ccsFloat) . ",\n" . "debt_letter1_in_day = " . $this->SQLValue($this->cp["debt_letter1_in_day"]->GetDBValue(), ccsFloat) . ",\n" . "debt_letter2_in_day = " . $this->SQLValue($this->cp["debt_letter2_in_day"]->GetDBValue(), ccsFloat) . ",\n" . "debt_letter3_in_day = " . $this->SQLValue($this->cp["debt_letter3_in_day"]->GetDBValue(), ccsFloat) . ",\n" . "valid_from = to_date('" . $this->SQLValue($this->cp["valid_from"]->GetDBValue(), ccsText) . "','DD-MON-YYYY'), \n" . "valid_to = to_date('" . $this->SQLValue($this->cp["valid_to"]->GetDBValue(), ccsText) . "','DD-MON-YYYY'), \n" . "description = '" . $this->SQLValue($this->cp["description"]->GetDBValue(), ccsText) . "', \n" . "updated_date = sysdate, \n" . "updated_by = '" . $this->SQLValue($this->cp["updated_by"]->GetDBValue(), ccsText) . "'\n" . "WHERE p_settlement_due_date_id = " . $this->SQLValue($this->cp["p_settlement_due_date_id"]->GetDBValue(), ccsFloat) . "";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteUpdate", $this->Parent);
if ($this->Errors->Count() == 0 && $this->CmdExecution) {
$this->query($this->SQL);
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteUpdate", $this->Parent);
}
}
