function print_laporan($param_arr)
{
include "../include/fpdf17/mc_table.php";
$_BORDER = 0;
$_FONT = 'Times';
$_FONTSIZE = 10;
$pdf = new PDF_MC_Table();
$pdf->AddPage('Landscape', 'Letter');
$pdf->SetFont('helvetica', '', $_FONTSIZE);
$pdf->SetRightMargin(5);
$pdf->SetLeftMargin(5);
$pdf->SetAutoPageBreak(false, 0);
$pdf->SetFont('helvetica', '', 12);
$pdf->SetWidths(array(200));
$pdf->ln(1);
$pdf->RowMultiBorderWithHeight(array("Penerimaan Global per WP"), array('', ''), 6);
//$pdf->ln(8);
$pdf->SetWidths(array(30, 200));
$pdf->ln(4);
$pdf->RowMultiBorderWithHeight(array("Jenis Pajak", ": " . $param_arr['rqst_type_code']), array('', ''), 6);
$pdf->RowMultiBorderWithHeight(array("Tanggal", ": " . dateToString($param_arr['date_start']) . " s/d " . dateToString($param_arr['date_end'])), array('', ''), 6);
$dbConn = new clsDBConnSIKP();
$query = "select a.*, f_get_wilayah(b.npwd) as kode_wilayah , to_char(b.active_date,'dd-mm-yyyy') as active_date,\r\n\t\t\tb.brand_address_name ||' '|| nvl(b.brand_address_no,'') as alamat_new\r\n\t\t\tfrom sikp.f_laporan_global_wp2(" . $param_arr['p_rqst_type_id'] . ",'" . $param_arr['date_start'] . "', '" . $param_arr['date_end'] . "') a\r\n\t\t\tleft join t_cust_account b on a.npwpd = b.npwd\r\n\t\t\twhere f_get_wilayah_id(b.npwd) = " . $param_arr['kode_wilayah'] . " order by jenis_pajak,TRIM(company_brand)";
//echo $query;exit;
$dbConn->query($query);
$items = array();
$pdf->SetFont('helvetica', '', 8);
$pdf->ln(2);
$pdf->SetWidths(array(10, 45, 50, 23, 25, 18, 50, 25, 23));
$pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C'));
$pdf->RowMultiBorderWithHeight(array("NO", "NAMA WP", "ALAMAT", "NPWPD", "BESARNYA", "JML SSPD", "NAMA AYAT", "PENGUKUHAN", "KETERANGAN"), array('LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTBR'), 6);
$pdf->SetFont('helvetica', '', 8);
$no = 1;
$pdf->SetAligns(array('C', 'L', 'L', 'R', 'R', 'R', 'L'));
$jumlah = 0;
$jumlah = 0;
while ($dbConn->next_record()) {
$items[] = array('nama_wp' => $dbConn->f("nama_wp"), 'alamat_new' => $dbConn->f("alamat_new"), 'npwpd' => $dbConn->f("npwpd"), 'amount' => $dbConn->f("amount"), 'tot_sspd' => $dbConn->f("tot_sspd"), 'active_date' => $dbConn->f("active_date"), 'kode_wilayah' => $dbConn->f("kode_wilayah"), 'jenis_pajak' => $dbConn->f("jenis_pajak"));
$pdf->RowMultiBorderWithHeight(array($no, $dbConn->f("nama_wp"), $dbConn->f("alamat_new"), $dbConn->f("npwpd"), 'Rp. ' . number_format($dbConn->f("amount"), 2, ',', '.'), $dbConn->f("tot_sspd"), $dbConn->f('jenis_pajak'), $dbConn->f("active_date"), $dbConn->f("kode_wilayah")), array('LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LBR'), 6);
$jumlah += $dbConn->f("amount");
$jumlah_wp += $dbConn->f("tot_sspd");
$no++;
}
$pdf->SetAligns(array('C', 'R', 'R', 'R', 'R', 'L'));
$pdf->SetWidths(array(128, 25, 18));
$pdf->RowMultiBorderWithHeight(array('Jumlah', 'Rp. ' . number_format($jumlah, 2, ',', '.'), number_format($jumlah_wp, 0, ',', '.')), array('LB', 'LB', 'LBR'), 6);
$pdf->SetWidths(array(123, 50));
$pdf->SetAligns('L');
$pdf->ln(5);
$pdf->SetWidtHs(array(200, 70));
$pdf->SetAligns(array("C", "C", "C", "C", "C"));
$pdf->RowMultiBorderWithHeight(array("", "KEPALA SEKSI VERIFIKASI OTORISASI DAN PEMBUKUAN\n\n\n\n\n(Drs. H. UGAS RAHMANSYAH, SAP, MAP)\n(NIP 19640127 199703 1001)"), array("", ""), 5);
$pdf->Output("", "I");
echo 'tes';
exit;
}
function print_laporan($param_arr)
{
include "../include/fpdf17/mc_table.php";
$_BORDER = 0;
$_FONT = 'Times';
$_FONTSIZE = 10;
$pdf = new PDF_MC_Table();
$size = $pdf->_getpagesize('Legal');
$pdf->DefPageSize = $size;
$pdf->CurPageSize = $size;
$pdf->AddPage('Landscape', 'Legal');
$pdf->SetFont('helvetica', '', $_FONTSIZE);
$pdf->SetRightMargin(5);
$pdf->SetLeftMargin(9);
$pdf->SetAutoPageBreak(false, 0);
$pdf->SetFont('helvetica', '', 12);
$pdf->SetWidths(array(200));
$pdf->ln(1);
$pdf->RowMultiBorderWithHeight(array("LAPORAN PENCETAKAN PENERIMAAN"), array('', ''), 6);
//$pdf->ln(8);
$pdf->SetWidths(array(40, 200));
$pdf->ln(4);
//$pdf->RowMultiBorderWithHeight(array("DAFTAR SPTPD",": ".$param_arr['vat_code_dtl']),array('',''),6);
//$pdf->RowMultiBorderWithHeight(array("TAHUN",": ".$param_arr['year_code']),array('',''),6);
$pdf->RowMultiBorderWithHeight(array("TANGGAL", ": " . dateToString($param_arr['date_start']) . " s/d " . dateToString($param_arr['date_end'])), array('', ''), 6);
$dbConn = new clsDBConnSIKP();
if (empty($param_arr['p_vat_type_id'])) {
$param_arr['p_vat_type_id'] = 'null';
}
if (!empty($param_arr['p_vat_type_dtl_id'])) {
$query = "select *,to_char(start_period, 'DD-MM-YYYY') as start_period_formated,to_char(end_period, 'DD-MM-YYYY') as end_period_formated,to_char(tanggal, 'DD-MM-YYYY') as date_settle_formated from sikp.f_laporan_harian_sptpd(1," . $param_arr['year_code'] . ",'" . $param_arr['date_start'] . "', '" . $param_arr['date_end'] . "'," . $param_arr['p_vat_type_dtl_id'] . ") ORDER BY tanggal, jenis ASC";
} else {
$query = "select *,to_char(start_period, 'DD-MM-YYYY') as start_period_formated,to_char(end_period, 'DD-MM-YYYY') as end_period_formated,to_char(tanggal, 'DD-MM-YYYY') as date_settle_formated from sikp.f_laporan_harian_sptpd(" . $param_arr['p_vat_type_id'] . ",2001,'" . $param_arr['date_start'] . "', '" . $param_arr['date_end'] . "') ORDER BY trunc(tanggal),ayat_code_dtl, jenis ASC";
}
//$dbConn->query($query);
$items = array();
$pdf->SetFont('helvetica', '', 10);
$pdf->ln(2);
$pdf->SetWidths(array(10, 80, 60, 40, 50, 80));
$pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C'));
$pdf->RowMultiBorderWithHeight(array("NO", "NAMA BADAN ", "PERIODE TRANSAKSI", "TGL PELAPORAN", "TOTAL PAJAK", "NO.KWITANSI"), array('LTB', 'LTB', 'LTB', 'LTB', 'LTBR'), 6);
$pdf->SetFont('helvetica', '', 10);
$no = 1;
$pdf->SetAligns(array('C', 'L', 'L', 'L', 'L', 'L', 'L', 'C', 'L', 'R', 'R'));
$jumlah_omzet = 0;
$jumlah_ketetapan = 0;
/*while($dbConn->next_record()){
$start_period = $dbConn->f("start_period_formated");
$end_period = $dbConn->f("end_period_formated");
$date_settle = $dbConn->f("date_settle_formated");
$items[]= $item = array('tanggal' => $date_settle,
'no_order' => $dbConn->f("no_order"),
'nama' => $dbConn->f("nama"),
'alamat' => $dbConn->f("alamat"),
'npwpd' => $dbConn->f("npwpd"),
'omzet' => $dbConn->f("omzet"),
'ketetapan' => $dbConn->f("ketetapan"),
'kohir' => $dbConn->f("kohir"),
'start_period' => $start_period,
'end_period' => $end_period,
'jenis_pajak' => $dbConn->f("jenis"),
'jenis_pajak_dtl' => $dbConn->f("jenis_dtl"),
'ayat_code' => $dbConn->f("ayat_code"),
'ayat_code_dtl' => $dbConn->f("ayat_code_dtl")
);
if(!empty($param_arr['p_vat_type_dtl_id'])){
$pdf->RowMultiBorderWithHeight(array($no,$item['tanggal'],$item['no_order'],$item['nama'],$item['alamat'],$item['npwpd'], 2, ',', '.'),$item['kohir'],$item['start_period'].' - '.$item['end_period'],$item['jenis_pajak'],'Rp '.number_format($item['omzet'], 2, ',', '.'),'Rp '.number_format($item['ketetapan']),array('LB','LB','LB','LB','LB','LB','LB','LB','LB','LB','LBR'),6);
}else{
$pdf->RowMultiBorderWithHeight(array($no,$item['tanggal'],$item['ayat_code'].'.'.$item['ayat_code_dtl'],$item['nama'],$item['alamat'],$item['npwpd'],$item['kohir'],$item['start_period'].' - '.$item['end_period'],$item['jenis_pajak'],'Rp '.number_format($item['omzet'], 2, ',', '.'),'Rp '.number_format($item['ketetapan'], 2, ',', '.')),array('LB','LB','LB','LB','LB','LB','LB','LB','LB','LB','LBR'),6);
}
$jumlah_omzet += $dbConn->f("omzet");
$jumlah_ketetapan += $dbConn->f("ketetapan");
$no++;
}*/
$pdf->SetWidths(array(259, 40, 40));
$pdf->SetAligns(array('C', 'R', 'R'));
$pdf->ln(5);
$pdf->SetWidtHs(array(239, 90));
$pdf->SetAligns(array("C", "C", "C", "C", "C"));
//$pdf->RowMultiBorderWithHeight(array("","KEPALA SEKSI VERIFIKASI OTORISASI DAN PEMBUKUAN\n\n\n\n\n(Drs. H. UGAS RAHMANSYAH, SAP, MAP)\n(NIP 19640127 199703 1001)"),array("",""),5);
$pdf->Output("", "I");
echo 'tes';
exit;
}
function print_laporan($p_rqst_type_id, $year_code, $year_period_id, $date_start, $date_end, $jenis_tahun, $rqst_type_code)
{
include "../include/fpdf17/mc_table.php";
$_BORDER = 0;
$_FONT = 'Times';
$_FONTSIZE = 8;
$pdf = new PDF_MC_Table();
$pdf->AddPage('Portrait', 'Letter');
$pdf->SetFont('helvetica', '', $_FONTSIZE);
$pdf->SetRightMargin(5);
$pdf->SetLeftMargin(5);
$pdf->SetAutoPageBreak(false, 0);
$pdf->SetFont('helvetica', '', 9);
$pdf->SetWidths(array(200));
$pdf->ln(1);
if ($jenis_tahun == 'pajak') {
$pdf->RowMultiBorderWithHeight(array("Laporan Penerimaan Global per Masa Pajak"), array('', ''), 6);
} else {
if ($jenis_tahun == 'bayar') {
$pdf->RowMultiBorderWithHeight(array("Laporan Penerimaan Global per Tanggal / Penerimaan"), array('', ''), 6);
}
}
//$pdf->ln(8);
$pdf->SetWidths(array(30, 200));
$pdf->ln(4);
$pdf->RowMultiBorderWithHeight(array("Jenis Pajak", ": " . $rqst_type_code), array('', ''), 6);
//$pdf->RowMultiBorderWithHeight(array("Tahun",": ".$year_code),array('',''),6);
$pdf->RowMultiBorderWithHeight(array("Tanggal", ": " . dateToString($date_start) . " s/d " . dateToString($date_end)), array('', ''), 6);
$dbConn = new clsDBConnSIKP();
if ($jenis_tahun == 'pajak') {
$query = "select * from sikp.f_laporan_per_thn_pajak(" . $p_rqst_type_id . "," . $year_period_id . ",'" . $date_start . "', '" . $date_end . "')";
} else {
if ($jenis_tahun == 'bayar') {
$query = "select * from sikp.f_laporan_per_thn_bayar(" . $p_rqst_type_id . ",2013,'" . $date_start . "', '" . $date_end . "')";
}
}
$dbConn->query($query);
$items = array();
$pdf->SetFont('helvetica', '', 8);
$pdf->ln(2);
$pdf->SetWidths(array(10, 40, 40, 33, 37, 40));
$pdf->RowMultiBorderWithHeight(array("NO", "BULAN", "BESARNYA", "JUMLAH WP", "JUMLAH SSPD", "KETERANGAN"), array('LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTBR'), 6);
$pdf->SetFont('helvetica', '', 8);
$no = 1;
$pdf->SetAligns(array('C', 'L', 'R', 'R', 'R', 'L'));
$jumlah = 0;
$jumlah = 0;
while ($dbConn->next_record()) {
$items[] = array('bulan_wp' => $dbConn->f("bulan_wp"), 'total_amount' => $dbConn->f("total_amount"), 'jumlah_wp' => $dbConn->f("jumlah_wp"));
$pdf->RowMultiBorderWithHeight(array($no, $dbConn->f("bulan_wp"), 'Rp. ' . number_format($dbConn->f("total_amount"), 2, ',', '.'), $dbConn->f("jumlah_wp"), '', ''), array('LB', 'LB', 'LB', 'LB', 'LB', 'LBR'), 6);
$jumlah += $dbConn->f("total_amount");
$jumlah_wp += $dbConn->f("jumlah_wp");
$no++;
}
$pdf->SetAligns(array('C', 'R', 'R', 'R', 'R', 'L'));
$pdf->SetWidths(array(50, 40, 33, 37, 40));
$pdf->RowMultiBorderWithHeight(array('Jumlah', 'Rp. ' . number_format($jumlah, 2, ',', '.'), $jumlah_wp, '', ''), array('LB', 'LB', 'LB', 'LB', 'LBR'), 6);
$pdf->SetWidths(array(123, 50));
$pdf->SetAligns('L');
$pdf->ln(5);
$pdf->SetWidtHs(array(130, 70));
$pdf->SetAligns(array("C", "C", "C", "C", "C"));
//$pdf->RowMultiBorderWithHeight(array("","KEPALA SEKSI VERIFIKASI OTORISASI DAN PEMBUKUAN\n\n\n\n\n(Drs. H. UGAS RAHMANSYAH, SAP, MAP)\n(NIP 19640127 199703 1001)"),array("",""),5);
$pdf->RowMultiBorderWithHeight(array("", "KEPALA SEKSI VERIFIKASI OTORISASI DAN PEMBUKUAN\n\n\n\n\n(Drs. H. Deden Saepulloh, MM.)\n(NIP 19681210 199010 001)"), array("", ""), 5);
$pdf->Output("", "I");
echo 'tes';
exit;
}
function print_laporan($param_arr)
{
include "../include/fpdf17/mc_table.php";
$_BORDER = 0;
$_FONT = 'Times';
$_FONTSIZE = 10;
$pdf = new PDF_MC_Table();
$size = $pdf->_getpagesize('Legal');
$pdf->DefPageSize = $size;
$pdf->CurPageSize = $size;
$pdf->AddPage('Landscape', 'Legal');
$pdf->SetFont('helvetica', '', $_FONTSIZE);
$pdf->SetRightMargin(5);
$pdf->SetLeftMargin(9);
$pdf->SetAutoPageBreak(false, 0);
$pdf->SetFont('helvetica', '', 12);
$pdf->SetWidths(array(200));
$pdf->ln(1);
$pdf->RowMultiBorderWithHeight(array("Laporan penerimaan"), array('', ''), 6);
//$pdf->ln(8);
$pdf->SetWidths(array(40, 200));
$pdf->ln(4);
$pdf->RowMultiBorderWithHeight(array("DAFTAR SPTPD", ": "), array('', ''), 6);
//$pdf->RowMultiBorderWithHeight(array("TAHUN",": ".$param_arr['year_code']),array('',''),6);
//$pdf->RowMultiBorderWithHeight(array("TANGGAL",": ".dateToString($param_arr['date_start'])." s/d ".dateToString($param_arr['date_end'])),array('',''),6);
$dbConn = new clsDBConnSIKP();
//$query="select * from sikp.f_laporan_harian_denda(1,".$param_arr['year_code'].",'".$param_arr['date_start']."', '".$param_arr['date_end']."')";
$query = "\r\nSELECT\r\n\tnama,\r\n\talamat,\r\n\tnpwpd,\r\n\tto_char(\r\n\t\ttrunc(start_period),\r\n\t\t'DD-MM-YYYY'\r\n\t) AS start_period_formated,\r\n\tto_char(\r\n\t\ttrunc(end_period),\r\n\t\t'DD-MM-YYYY'\r\n\t) AS end_period_formated,\r\n\tno_kohir,\r\n\tto_char(\r\n\t\ttrunc(tgl_masuk),\r\n\t\t'DD-MM-YYYY'\r\n\t) AS tgl_masuk_formated,\r\n\tto_char(\r\n\t\ttrunc(jatuh_tempo),\r\n\t\t'DD-MM-YYYY'\r\n\t) AS jatuh_tempo_formated,\r\n\tto_char(\r\n\t\ttrunc(tgl_bayar),\r\n\t\t'DD-MM-YYYY'\r\n\t) AS tgl_bayar_formated,\r\n\tskpdkb_amount,\r\n\tto_char(\r\n\t\ttrunc(skpdkb_tgl_tap),\r\n\t\t'DD-MM-YYYY'\r\n\t) AS skpdkb_tgl_tap_formated,\r\n\tto_char(\r\n\t\ttrunc(skpdkb_tgl_bayar),\r\n\t\t'DD-MM-YYYY'\r\n\t) AS skpdkb_tgl_bayar_formated,\r\n\tdenda_amount,\r\n\tto_char(\r\n\t\ttrunc(denda_tgl_tap),\r\n\t\t'DD-MM-YYYY'\r\n\t) AS denda_tgl_tap_formated,\r\n\tto_char(\r\n\t\ttrunc(denda_tgl_bayar),\r\n\t\t'DD-MM-YYYY'\r\n\t) AS denda_tgl_bayar_formated,\r\n\tsptpd_amount,\r\n\tpayment_amount\r\nfrom sikp.f_laporan_harian_denda_v2(" . $param_arr['p_vat_type_id'] . ",2014,'" . $param_arr['date_start'] . "','" . $param_arr['date_end'] . "')\r\nORDER BY\r\n\tnama,\r\n\ttrunc(start_period) ASC";
/*"select *,
to_char(start_period, 'DD-MM-YYYY') AS start_period_formated,
to_char(end_period, 'DD-MM-YYYY') AS end_period_formated,
to_char(tgl_masuk, 'DD-MM-YYYY') AS tgl_masuk_formated,
to_char(jatuh_tempo, 'DD-MM-YYYY') AS jatuh_tempo_formated,
to_char(tgl_bayar, 'DD-MM-YYYY') AS tgl_bayar_formated,
to_char(skpdkb_tgl_tap, 'DD-MM-YYYY') AS skpdkb_tgl_tap_formated,
to_char(skpdkb_tgl_bayar, 'DD-MM-YYYY') AS skpdkb_tgl_bayar_formated,
to_char(denda_tgl_tap, 'DD-MM-YYYY') AS denda_tgl_tap_formated,
to_char(denda_tgl_bayar, 'DD-MM-YYYY') AS denda_tgl_bayar_formated from sikp.f_laporan_harian_denda(1,2014,'1-1-2014','30-12-2014')";
*/
//echo $query;
//exit;
$dbConn->query($query);
$items = array();
$pdf->SetFont('arial', '', 8);
$pdf->ln(2);
$pdf->SetWidths(array(10, 24, 20, 15, 37, 18, 18, 19, 22, 19, 61, 61, 17));
$pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C'));
$pdf->RowMultiBorderWithHeight(array("", "", "", "", "", "", "", "", "", "", "", "", ""), array('LT', 'LT', 'LT', 'LT', 'LT', 'LT', 'LT', 'LT', 'LT', 'LT', 'LT', 'LT', 'LTR'), 6);
$pdf->RowMultiBorderWithHeight(array("", "", "", "", "", "", "", "", "", "", "SKPDKB", "DENDA", "SELISIH"), array('L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'LR'), 4);
$pdf->RowMultiBorderWithHeight(array("NO", "NAMA", "ALAMAT", "NPWPD", "MASA PAJAK", "NO KOHIR", "BESARNYA", "TGL MASUK", "JATUH TEMPO", "TGL BAYAR", "", "", ""), array('L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'LR'), 4);
$pdf->SetWidths(array(10, 24, 20, 15, 37, 18, 18, 19, 22, 19, 16, 15, 14, 16, 16, 15, 14, 16, 17));
$pdf->SetFont('arial', '', 7);
$pdf->RowMultiBorderWithHeight(array("", "", "", "", "", "", "", "", "", "", "BESARNYA", "NO KOHIR", "TGL TAP", "TGL BAYAR", "BESARNYA", "NO KOHIR", "TGL TAP", "TGL BAYAR", ""), array('LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLBR'), 9);
$pdf->SetFont('arial', '', 8);
$no = 1;
$pdf->SetAligns(array('C', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L', 'L'));
$jumlah = 0;
$jumlah = 0;
$jumlah_selisih = 0;
$total_skpdkb = 0;
$total_sptpd = 0;
$total_denda = 0;
while ($dbConn->next_record()) {
$items[] = $item = array('nama' => $dbConn->f("nama"), 'alamat' => $dbConn->f("alamat"), 'npwpd' => $dbConn->f("npwpd"), 'start_period' => $dbConn->f("start_period_formated"), 'end_period' => $dbConn->f("end_period_formated"), 'no_kohir' => $dbConn->f("no_kohir"), 'tgl_masuk' => $dbConn->f("tgl_masuk_formated"), 'jatuh_tempo' => $dbConn->f("jatuh_tempo_formated"), 'tgl_bayar' => $dbConn->f("tgl_bayar_formated"), 'skpdkb_amount' => $dbConn->f("skpdkb_amount"), 'skpdkb_no_kohir' => $dbConn->f("skpdkb_no_kohir"), 'skpdkb_tgl_tap' => $dbConn->f("skpdkb_tgl_tap_formated"), 'skpdkb_tgl_bayar' => $dbConn->f("skpdkb_tgl_bayar_formated"), 'denda_amount' => $dbConn->f("denda_amount"), 'denda_no_kohir' => $dbConn->f("denda_no_kohir"), 'denda_tgl_tap' => $dbConn->f("denda_tgl_tap_formated"), 'denda_tgl_bayar' => $dbConn->f("denda_tgl_bayar_formated"), 'sptpd_amount' => $dbConn->f("sptpd_amount"), 'payment_amount' => $dbConn->f("payment_amount"));
//$pdf->RowMultiBorderWithHeight(array($no,$item['tanggal'],$item['no_order'],$item['nama'],$item['alamat'],$item['npwpd'],'Rp. '.number_format($item['omzet'], 2, ',', '.'),'Rp. '.number_format($item['ketetapan'], 2, ',', '.'),$item['kohir'],$item['start_period'].' - '.$item['end_period'],$item['jenis_pajak']),array('LB','LB','LB','LB','LB','LB','LB','LB','LB','LB','LBR'),6);
if ($item['skpdkb_amount'] == 0) {
$item['skpdkb_no_kohir'] = "";
$item['skpdkb_tgl_tap'] = "";
$item['skpdkb_tgl_bayar'] = "";
}
if ($item['denda_amount'] == 0) {
$item['denda_no_kohir'] = "";
$item['denda_tgl_tap'] = "";
$item['denda_tgl_bayar'] = "";
}
$jumlah = $item['skpdkb_amount'] + $item['sptpd_amount'] + $item['denda_amount'] - $item['payment_amount'];
$jumlah_selisih += $jumlah;
$pdf->RowMultiBorderWithHeight(array($no, $item['nama'], $item['alamat'], $item['npwpd'], $item['start_period'] . " s/d " . $item['end_period'], $item['no_kohir'], 'Rp. ' . number_format($item['sptpd_amount'], 2, ',', '.'), $item['tgl_masuk'], $item['jatuh_tempo'], $item['tgl_bayar'], 'Rp. ' . number_format($item['skpdkb_amount'], 2, ',', '.'), $item['skpdkb_no_kohir'], $item['skpdkb_tgl_tap'], $item['skpdkb_tgl_bayar'], 'Rp. ' . number_format($item['denda_amount'], 2, ',', '.'), $item['denda_no_kohir'], $item['denda_tgl_tap'], $item['denda_tgl_bayar'], 'Rp. ' . number_format($jumlah, 2, ',', '.')), array('LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLBR'), 6);
$total_skpdkb += $item['skpdkb_amount'];
$total_sptpd += $item['sptpd_amount'];
$total_denda += $item['denda_amount'];
// $jumlah_wp+=$dbConn->f("jumlah_wp");
$no++;
}
$pdf->SetWidths(array(10 + 24 + 20 + 15 + 37 + 18, 18, 19 + 22 + 19, 16, 15 + 14 + 16, 16, 15 + 14 + 16, 17));
$pdf->RowMultiBorderWithHeight(array("", 'Rp. ' . number_format($total_sptpd, 2, ',', '.'), "", 'Rp. ' . number_format($total_skpdkb, 2, ',', '.'), "", 'Rp. ' . number_format($total_denda, 2, ',', '.'), "", 'Rp. ' . number_format($jumlah_selisih, 2, ',', '.')), array('LRTBR', 'LTBR', 'LTBR', 'LTBR', 'LTBR', 'LTBR', 'LTBR', 'LTBR'), 6);
$pdf->SetWidths(array(250, 70));
$pdf->ln(8);
$pdf->SetWidtHs(array(239, 90));
$pdf->SetAligns(array("C", "C", "C", "C", "C"));
$pdf->RowMultiBorderWithHeight(array("", "KEPALA SEKSI VERIFIKASI OTORISASI DAN PEMBUKUAN\n\n\n\n\n(Drs. H. UGAS RAHMANSYAH, SAP, MAP)\n(NIP 19640127 199703 1001)"), array("", ""), 5);
//$pdf->RowMultiBorderWithHeight(array("","KASIE VOP"),array('','','','','','',''),6);
$pdf->Output("", "I");
echo 'tes';
exit;
}
