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;
}
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;
}
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;
}
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_rep_bpps;
//Compatibility
//End Page_BeforeShow
//Custom Code @568-2A29BDB7
// -------------------------
// Write your own code here.
global $Label1;
$cetak = CCGetFromGet('cetak');
if ($cetak == 'html') {
$Label1->SetText(PageCetak());
}
if ($cetak == 'excel') {
PageCetak();
}
// -------------------------
//End Custom Code
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
