function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_debt_letter_view_excel;
//Compatibility
//End Page_BeforeShow
//Custom Code @68-2A29BDB7
// -------------------------
// Write your own code here.
$cetak_excel = CCGetFromGet("cetak_excel", 0);
$t_customer_order_id = CCGetFromGet("t_customer_order_id", 0);
$p_vat_type_id = CCGetFromGet("p_vat_type_id", 0);
$param_arr = array();
if ($cetak_excel == 1) {
$param_arr['p_vat_type_id'] = $p_vat_type_id;
$param_arr['t_customer_order_id'] = $t_customer_order_id;
print_excel($param_arr);
}
// -------------------------
//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_laporan_piutang_pajak_all;
//Compatibility
//End Page_BeforeShow
//Custom Code @10-2A29BDB7
// -------------------------
// Write your own code here.
// -------------------------
//End Custom Code
$cetak_laporan = CCGetFromGet('cetak_laporan');
global $Label1;
// -------------------------
// Write your own code here.
if ($cetak_laporan == 'view_html') {
$param_arr = array();
$param_arr['p_vat_type_id'] = CCGetFromGet("p_vat_type_id", 1);
$param_arr['vat_code'] = CCGetFromGet("vat_code", "");
$Label1->SetText(view_html($param_arr));
} else {
if ($cetak_laporan == 'download_excel') {
$param_arr = array();
$param_arr['p_vat_type_id'] = CCGetFromGet("p_vat_type_id", 1);
$param_arr['vat_code'] = CCGetFromGet("vat_code", "");
print_excel($param_arr);
}
}
// -------------------------
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_laporan_penerimaan_bphtb_teller;
//Compatibility
//End Page_BeforeShow
//Custom Code @10-2A29BDB7
// -------------------------
// Write your own code here.
// -------------------------
//End Custom Code
// -------------------------
$param_arr = array();
if (empty($param_arr['uid'])) {
$param_arr['uid'] = CCGetFromGet('uid');
}
if (empty($param_arr['report_type'])) {
$param_arr['report_type'] = CCGetFromGet('report_type');
}
if ($param_arr['report_type'] == 'excel') {
print_excel($param_arr);
} else {
print_laporan($param_arr);
}
// -------------------------
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_rep_lap_bpps_piutang;
//Compatibility
//End Page_BeforeShow
//Custom Code @570-2A29BDB7
// -------------------------
$cetak_laporan = CCGetFromGet('cetak_laporan');
if ($cetak_laporan == 'download_excel') {
$param_arr = array();
$param_arr['tgl_penerimaan'] = CCGetFromGet('tgl_penerimaan');
$param_arr['p_year_period_id'] = CCGetFromGet('p_year_period_id');
$param_arr['p_vat_type_id'] = CCGetFromGet('p_vat_type_id');
$param_arr['i_flag_setoran'] = CCGetFromGet('i_flag_setoran');
$param_arr['tgl_penerimaan_last'] = CCGetFromGet('tgl_penerimaan_last');
$param_arr['jenis_laporan'] = CCGetFromGet('jenis_laporan', 'all');
print_excel($param_arr);
}
// -------------------------
//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_teller;
//Compatibility
//End Page_BeforeShow
//Custom Code @562-2A29BDB7
// -------------------------
// Write your own code here.
global $Label1;
$tampil = CCGetFromGet('tampil');
$tgl_penerimaan = CCGetFromGet('tgl_penerimaan');
$nama_teller = CCGetFromGet('nama_teller');
$p_payment_type_id = CCGetFromGet('p_payment_type_id');
$param_arr = array();
$param_arr['tgl_penerimaan'] = CCGetFromGet('tgl_penerimaan');
$param_arr['nama_teller'] = CCGetFromGet('nama_teller');
$param_arr['p_payment_type_id'] = CCGetFromGet('p_payment_type_id');
if ($tampil == 'T') {
$Label1->SetText(GetCetakGeneralHTML($param_arr));
} elseif ($tampil == 'download_excel') {
print_excel($param_arr);
}
// -------------------------
//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_realisasi_harian_per_jenis_pajak;
//Compatibility
//End Page_BeforeShow
//Custom Code @568-2A29BDB7
// -------------------------
// Write your own code here.
// -------------------------
//End Custom Code
$doAction = CCGetFromGet('doAction');
if ($doAction == 'download_excel') {
$param_arr = array();
$param_arr['p_vat_type_id'] = CCGetFromGet('p_vat_type_id');
$param_arr['p_year_period_id'] = CCGetFromGet('p_year_period_id');
$param_arr['tgl_penerimaan'] = CCGetFromGet('tgl_penerimaan');
$param_arr['i_flag_setoran'] = CCGetFromGet('i_flag_setoran');
$param_arr['tgl_penerimaan_last'] = CCGetFromGet('tgl_penerimaan_last');
$param_arr['jenis_laporan'] = CCGetFromGet("jenis_laporan", "all");
print_excel($param_arr);
}
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_laporan_daftar_bphtb;
//Compatibility
//End Page_BeforeShow
//Custom Code @10-2A29BDB7
// -------------------------
if ($t_laporan_daftar_bphtb->cetak_laporan->GetValue() == 'T') {
$param_arr = array();
if (empty($param_arr['date_start'])) {
$param_arr['date_start'] = CCGetFromGet('date_start');
}
if (empty($param_arr['date_end'])) {
$param_arr['date_end'] = CCGetFromGet('date_end');
}
print_excel($param_arr);
}
// -------------------------
//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_laporan_rekap_bphtb;
//Compatibility
//End Page_BeforeShow
global $Label1;
//Custom Code @10-2A29BDB7
// -------------------------
// Write your own code here.
$doAction = CCGetFromGet('doAction');
if ($doAction == 'view_html') {
$param_arr = array();
if (empty($param_arr['date_start'])) {
$param_arr['date_start'] = CCGetFromGet('date_start');
}
if (empty($param_arr['date_end'])) {
$param_arr['date_end'] = CCGetFromGet('date_end');
}
$param_arr['filter_lap'] = CCGetFromGet('filter_lap');
$Label1->SetText(GetCetakHTML($param_arr));
$t_laporan_rekap_bphtb->date_start_laporan->SetValue($param_arr['date_start']);
$t_laporan_rekap_bphtb->date_end_laporan->SetValue($param_arr['date_end']);
$t_laporan_rekap_bphtb->ListBox1->SetValue($param_arr['filter_lap']);
} else {
if ($doAction == 'print_excel') {
$param_arr = array();
if (empty($param_arr['date_start'])) {
$param_arr['date_start'] = CCGetFromGet('date_start');
}
if (empty($param_arr['date_end'])) {
$param_arr['date_end'] = CCGetFromGet('date_end');
}
$param_arr['filter_lap'] = CCGetFromGet('filter_lap');
$t_laporan_rekap_bphtb->date_start_laporan->SetValue($param_arr['date_start']);
$t_laporan_rekap_bphtb->date_end_laporan->SetValue($param_arr['date_end']);
$t_laporan_rekap_bphtb->ListBox1->SetValue($param_arr['filter_lap']);
print_excel($param_arr);
} else {
if ($t_laporan_rekap_bphtb->cetak_laporan->GetValue() == 'T') {
$param_arr = array();
if (empty($param_arr['date_start'])) {
$param_arr['date_start'] = CCGetFromGet('date_start');
}
if (empty($param_arr['date_end'])) {
$param_arr['date_end'] = CCGetFromGet('date_end');
}
$param_arr['filter_lap'] = CCGetFromGet('filter_lap');
print_laporan($param_arr);
}
}
}
// -------------------------
//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_laporan_harian_sptpd;
//Compatibility
//End Page_BeforeShow
//Custom Code @10-2A29BDB7
// -------------------------
// Write your own code here.
// -------------------------
//End Custom Code
$cetak_laporan = CCGetFromGet("cetak_laporan", "");
// -------------------------
// Write your own code here.
if ($cetak_laporan == 'excel') {
$param_arr = array();
$param_arr['year_code'] = $t_laporan_harian_sptpd->year_code->GetValue();
$param_arr['year_period_id'] = $t_laporan_harian_sptpd->p_year_period_id->GetValue();
$param_arr['date_start'] = $t_laporan_harian_sptpd->date_start_laporan->GetValue();
$param_arr['date_end'] = $t_laporan_harian_sptpd->date_end_laporan->GetValue();
$param_arr['p_vat_type_id'] = $t_laporan_harian_sptpd->p_vat_type_id->GetValue();
$param_arr['p_vat_type_dtl_id'] = $t_laporan_harian_sptpd->p_vat_type_dtl_id->GetValue();
$param_arr['vat_code_dtl'] = $t_laporan_harian_sptpd->vat_code_dtl->GetValue();
if (empty($param_arr['date_start'])) {
$param_arr['date_start'] = $param_arr['year_code'] . '-01-01';
}
if (empty($param_arr['date_end'])) {
$param_arr['date_end'] = $param_arr['year_code'] . '-12-31';
}
print_excel($param_arr);
} else {
if ($t_laporan_harian_sptpd->cetak_laporan->GetValue() == 'T') {
$param_arr = array();
$param_arr['year_code'] = $t_laporan_harian_sptpd->year_code->GetValue();
$param_arr['year_period_id'] = $t_laporan_harian_sptpd->p_year_period_id->GetValue();
$param_arr['date_start'] = $t_laporan_harian_sptpd->date_start_laporan->GetValue();
$param_arr['date_end'] = $t_laporan_harian_sptpd->date_end_laporan->GetValue();
$param_arr['p_vat_type_id'] = $t_laporan_harian_sptpd->p_vat_type_id->GetValue();
$param_arr['p_vat_type_dtl_id'] = $t_laporan_harian_sptpd->p_vat_type_dtl_id->GetValue();
$param_arr['vat_code_dtl'] = $t_laporan_harian_sptpd->vat_code_dtl->GetValue();
if (empty($param_arr['date_start'])) {
$param_arr['date_start'] = $param_arr['year_code'] . '-01-01';
}
if (empty($param_arr['date_end'])) {
$param_arr['date_end'] = $param_arr['year_code'] . '-12-31';
}
print_laporan($param_arr);
}
}
// -------------------------
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_laporan_penerimaan_bphtb;
//Compatibility
//End Page_BeforeShow
//Custom Code @10-2A29BDB7
// -------------------------
$type_cetak = CCGetFromGet('cetak_laporan');
if ($type_cetak == 'excel') {
$param_arr = array();
if (empty($param_arr['date_start'])) {
$param_arr['date_start'] = CCGetFromGet('date_start');
}
if (empty($param_arr['date_end'])) {
$param_arr['date_end'] = CCGetFromGet('date_end');
}
$param_arr['receipt_no'] = CCGetFromGet('receipt_no');
$param_arr['njop_pbb'] = CCGetFromGet('njop_pbb');
$param_arr['wp_name'] = CCGetFromGet('wp_name');
$param_arr['p_region_id_kecamatan'] = CCGetFromGet('p_region_id_kecamatan');
$param_arr['p_region_id_kelurahan'] = CCGetFromGet('p_region_id_kelurahan');
$param_arr['p_bphtb_legal_doc_type_id'] = CCGetFromGet('p_bphtb_legal_doc_type_id', 0);
$param_arr['verificated_by'] = CCGetFromGet('verificated_by', '0');
print_excel($param_arr);
} else {
if ($t_laporan_penerimaan_bphtb->cetak_laporan->GetValue() == 'T') {
$param_arr = array();
if (empty($param_arr['date_start'])) {
$param_arr['date_start'] = CCGetFromGet('date_start');
}
if (empty($param_arr['date_end'])) {
$param_arr['date_end'] = CCGetFromGet('date_end');
}
$param_arr['receipt_no'] = CCGetFromGet('receipt_no');
$param_arr['njop_pbb'] = CCGetFromGet('njop_pbb');
$param_arr['wp_name'] = CCGetFromGet('wp_name');
$param_arr['p_region_id_kecamatan'] = CCGetFromGet('p_region_id_kecamatan');
$param_arr['p_region_id_kelurahan'] = CCGetFromGet('p_region_id_kelurahan');
$param_arr['p_bphtb_legal_doc_type_id'] = CCGetFromGet('p_bphtb_legal_doc_type_id', 0);
print_laporan($param_arr);
}
}
// -------------------------
//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_idx_kepatuhan_wp;
//Compatibility
//End Page_BeforeShow
global $Label1;
global $t_rep_idx_kepatuhan_wpSearch;
//Custom Code @566-2A29BDB7
// -------------------------
// Write your own code here.
// -------------------------
//End Custom Code
$doAction = CCGetFromGet('doAction');
$data = array();
$param_arr = array();
$param_arr['p_year_period_id'] = CCGetFromGet('p_year_period_id');
$param_arr['p_vat_type_id'] = CCGetFromGet('p_vat_type_id');
$param_arr['status'] = CCGetFromGet('status');
$param_arr['tahun_periode'] = CCGetFromGet('tahun_periode');
$param_arr['jenis_pajak'] = CCGetFromGet('jenis_pajak');
$param_arr['status_text'] = CCGetFromGet('status_text');
$t_rep_idx_kepatuhan_wpSearch->p_year_period_id->SetValue($param_arr['p_year_period_id']);
$t_rep_idx_kepatuhan_wpSearch->year_code->SetValue($param_arr['tahun_periode']);
$t_rep_idx_kepatuhan_wpSearch->p_vat_type_id->SetValue($param_arr['p_vat_type_id']);
$t_rep_idx_kepatuhan_wpSearch->vat_code->SetValue($param_arr['jenis_pajak']);
$t_rep_idx_kepatuhan_wpSearch->ListBox1->SetValue($param_arr['status']);
if ($doAction == 'download_excel') {
if (!empty($param_arr['p_year_period_id']) and !empty($param_arr['p_vat_type_id']) and !empty($param_arr['status'])) {
print_excel($param_arr);
} else {
/* Tampilkan Alert */
echo '<script> alert("Semua Filter Harus Diisi"); </script>';
}
} else {
//do nothing
}
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
<?php
error_reporting(E_ALL);
set_time_limit(0);
date_default_timezone_set('Europe/London');
/** Include path **/
set_include_path(get_include_path() . PATH_SEPARATOR . 'Classes/');
/** PHPExcel_IOFactory */
include 'PHPExcel/IOFactory.php';
?>
<?php
function print_excel($Myfilename)
{
$Myfilename = 'examplefile.xlsx';
$inputFileName = './Uploads/' . $Myfilename;
echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory to identify the format<br />';
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
echo '<hr />';
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);
var_dump($sheetData);
//echo $sheetData[1]["A"];
echo '<pre>';
print_r($sheetData);
echo '</pre>';
}
print_excel('asda');
function Page_BeforeShow(&$sender)
{
$Page_BeforeShow = true;
$Component =& $sender;
$Container =& CCGetParentContainer($sender);
global $t_customer_report;
//Compatibility
//End Page_BeforeShow
//Custom Code @538-2A29BDB7
// -------------------------
if (CCGetFromGet('view_report') == 'cetak_excel') {
$param_arr = array();
$param_arr['s_npwd'] = CCGetFromGet('s_npwd');
$param_arr['p_vat_type_id'] = CCGetFromGet('p_vat_type_id');
$param_arr['p_vat_type_dtl_id'] = CCGetFromGet('p_vat_type_dtl_id');
$param_arr['s_wp_name'] = CCGetFromGet('s_wp_name');
$param_arr['s_company_name'] = CCGetFromGet('s_company_name');
$param_arr['s_company_brand'] = CCGetFromGet('s_company_brand');
$param_arr['s_keyword'] = CCGetFromGet('s_keyword');
print_excel($param_arr);
}
// -------------------------
//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_trans_histories;
//Compatibility
//End Page_BeforeShow
//Custom Code @146-2A29BDB7
// -------------------------
// Write your own code here.
if (CCGetFromGet('view_report') == 'cetak_excel') {
$param_arr = array();
$param_arr['t_cust_acc_id'] = CCGetFromGet('t_cust_acc_id', '');
if ($param_arr['t_cust_acc_id'] != '') {
print_excel($param_arr);
} else {
exit;
}
}
// -------------------------
//End Custom Code
//Close Page_BeforeShow @1-4BC230CD
return $Page_BeforeShow;
}
