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; }