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 bulanan penerimaan sptpd"), 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_pencetakan_bulanan(1," . $param_arr['year_code'] . ",'" . $param_arr['date_start'] . "', '" . $param_arr['date_end'] . "')"; //print_r($query); //exit; $dbConn->query($query); $items = array(); $pdf->SetFont('helvetica', '', 9); $pdf->ln(2); $pdf->SetWidths(array(10, 24, 20, 15, 40, 18, 22, 25, 20, 61, 61, 27)); $pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C')); $pdf->SetWidths(array(10, 40, 35, 15, 40, 18, 18, 18, 18, 18, 18, 18, 18, 18, 18, 18, 18)); $pdf->SetFont('arial', '', 7); $pdf->RowMultiBorderWithHeight(array("NO", "NAMA", "ALAMAT", "NPWPD", "DESEMBER THN SEBELUMNYA", "JANUARI", "FEBRUARI", "MARET", "APRIL", "MEI", "JUNI", "JULI", "AGUSTUS", "SEPTEMBER", "OKTOBER", "NOVEMBER"), array('LTB', 'LTB', 'LBT', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLBR'), 9); $pdf->SetFont('arial', '', 8); $no = 1; $pdf->SetAligns(array('C', 'L', 'L', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C')); $jumlah = 0; $jumlah = 0; while ($dbConn->next_record()) { $items[] = $item = array('nama' => $dbConn->f("nama"), 'alamat' => $dbConn->f("alamat"), 'npwpd' => $dbConn->f("npwpd"), 'last_desember' => $dbConn->f("last_desember"), 'januari' => $dbConn->f("januari"), 'februari' => $dbConn->f("februari"), 'maret' => $dbConn->f("maret"), 'april' => $dbConn->f("april"), 'mei' => $dbConn->f("mei"), 'juni' => $dbConn->f("juni"), 'juli' => $dbConn->f("juli"), 'agustus' => $dbConn->f("agustus"), 'september' => $dbConn->f("september"), 'oktober' => $dbConn->f("oktober"), 'november' => $dbConn->f("november")); $pdf->RowMultiBorderWithHeight(array($no, $item['nama'], $item['alamat'], $item['npwpd'], $item['last_desember'], $item['januari'], $item['februari'], $item['maret'], $item['april'], $item['mei'], $item['juni'], $item['juli'], $item['agustus'], $item['september'], $item['oktober'], $item['november']), array('LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LBR'), 6); $jumlah += $dbConn->f("amount"); // $jumlah_wp+=$dbConn->f("jumlah_wp"); $no++; } //print_r($items); //exit; $pdf->SetWidths(array(250, 70)); $pdf->ln(8); $pdf->RowMultiBorderWithHeight(array("", "KASIE VOP"), array('', '', '', '', '', '', ''), 6); $pdf->Output("", "I"); exit; }
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, $param2) { include "lib/fpdf17/mc_table.php"; $_BORDER = 0; $_FONT = 'Times'; $_FONTSIZE = 10; $pdf = new PDF_MC_Table(); $size = $pdf->_getpagesize('A4'); $pdf->DefPageSize = $size; $pdf->CurPageSize = $size; $pdf->AddPage('Portrait', 'A4'); $pdf->SetFont('helvetica', '', $_FONTSIZE); $pdf->SetRightMargin(5); $pdf->SetLeftMargin(9); $pdf->SetAutoPageBreak(false, 0); $pdf->SetFont('helvetica', '', 15); $pdf->SetWidths(array(200)); $pdf->ln(1); $pdf->RowMultiBorderWithHeight(array("Laporan Transaksi Harian"), array('', ''), 6); $pdf->SetFont('helvetica', '', 12); $pdf->SetWidths(array(40, 10, 200)); $pdf->ln(1); $pdf->RowMultiBorderWithHeight(array("NPWP", ":", $param2['username']), array('', '', ''), 6); $pdf->RowMultiBorderWithHeight(array("Tanggal", ":", $param2['date_start'] . ' s/d ' . $param2['date_end']), array('', '', ''), 6); $pdf->ln(8); $pdf->SetWidths(array(10, 40, 40, 60)); $pdf->SetAligns(array('C', 'C', 'C', 'C')); $pdf->RowMultiBorderWithHeight(array("No", "Tanggal Transaksi", "No Faktur", "Nilai Transaksi"), array('LTBR', 'LTBR', 'LTBR'), 6); $i = 1; $pdf->SetAligns(array('L', 'L', 'L', 'R')); foreach ($param_arr as $item) { if ($item['bill_no_end'] != '') { $bill_no = $item['bill_no'] . '-' . $item['bill_no_end']; } else { $bill_no = $item['bill_no']; } $pdf->RowMultiBorderWithHeight(array($i, $item['trans_date'], $bill_no, 'Rp. ' . number_format($item['service_charge'], 2, '.', ',')), array('LTBR', 'LTBR', 'LTBR'), 6); $i++; } $pdf->Output("", "I"); 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); $textFilter = ''; if (!empty($param_arr['filter_lap'])) { if ($param_arr['filter_lap'] == 1) { //sudah bayar $textFilter = '(Sudah Bayar)'; } if ($param_arr['filter_lap'] == 2) { //belum bayar $textFilter = '(Belum Bayar)'; } if ($param_arr['filter_lap'] == 3) { //belum bayar $textFilter = '(Nihil)'; } } $pdf->SetFont('helvetica', '', 12); $pdf->SetWidths(array(200)); $pdf->ln(1); $pdf->RowMultiBorderWithHeight(array("DAFTAR NOTA VERIFIKASI BPHTB " . $textFilter), array('', ''), 6); //$pdf->ln(8); $pdf->SetWidths(array(40, 200)); $pdf->ln(4); $pdf->RowMultiBorderWithHeight(array("TANGGAL", ": " . dateToString($param_arr['date_start'], "-") . " s/d " . dateToString($param_arr['date_end'], "-")), array('', ''), 6); $dbConn = new clsDBConnSIKP(); $whereClause = ''; if (!empty($param_arr['date_start']) && !empty($param_arr['date_end'])) { $whereClause .= " AND (trunc(reg_bphtb.creation_date) BETWEEN '" . $param_arr['date_start'] . "'"; $whereClause .= " AND '" . $param_arr['date_end'] . "')"; } else { if (!empty($param_arr['date_start']) && empty($param_arr['date_end'])) { $whereClause .= " AND trunc(reg_bphtb.creation_date) >= '" . $param_arr['date_start'] . "'"; } else { if (empty($param_arr['date_start']) && !empty($param_arr['date_end'])) { $whereClause .= " AND trunc(reg_bphtb.creation_date) <= '" . $param_arr['date_end'] . "'"; } } } if (!empty($param_arr['filter_lap'])) { if ($param_arr['filter_lap'] == 1) { //sudah bayar $whereClause .= " AND (payment.receipt_no is not null or payment.receipt_no <> '') "; $whereClause .= " AND ( bphtb_amt_final > 0 ) "; } if ($param_arr['filter_lap'] == 2) { //belum bayar $whereClause .= " AND ( payment.receipt_no is null or payment.receipt_no = '') "; $whereClause .= " AND ( bphtb_amt_final > 0 ) "; } if ($param_arr['filter_lap'] == 3) { //nihil $whereClause .= " AND ( bphtb_amt_final < 1 ) "; } } $query = "SELECT\r\n\t\t\t\tto_char(reg_bphtb.creation_date, 'YYYY-MM-DD') as creation_date,\r\n\t\t\t\tregistration_no,\r\n\t\t\t\twp_name,\r\n\t\t\t\treg_bphtb.p_bphtb_legal_doc_type_id,\r\n\t\t\t\tbphtb_doc.description,\r\n\t\t\t\tnjop_pbb,\r\n\t\t\t\tland_area,\r\n\t\t\t\tland_total_price,\r\n\t\t\t\tbuilding_area,\r\n\t\t\t\tbuilding_total_price,\r\n\t\t\t\tmarket_price,\r\n\t\t\t\tbphtb_amt_final,\r\n\t\t\t\tland_price_per_m,\r\n\t\t\t\tbuilding_price_per_m\r\n\t\t\tFROM\r\n\t\t\t\tsikp.t_bphtb_registration reg_bphtb\r\n\t\t\tLEFT JOIN p_bphtb_legal_doc_type bphtb_doc on bphtb_doc.p_bphtb_legal_doc_type_id = reg_bphtb.p_bphtb_legal_doc_type_id\r\n\t\t\tLEFT JOIN t_customer_order cust_order ON cust_order.t_customer_order_id = reg_bphtb.t_customer_order_id \r\n\t\t\tLEFT JOIN t_payment_receipt_bphtb payment ON reg_bphtb.t_bphtb_registration_id = payment.t_bphtb_registration_id \r\n\t\t\tWHERE cust_order.p_order_status_id <> 1"; $query .= $whereClause; $query .= " order by trunc(reg_bphtb.creation_date) ASC,upper(wp_name) ASC"; $dbConn->query($query); $items = array(); $pdf->SetFont('helvetica', '', 9); $pdf->ln(2); $pdf->SetWidths(array(10, 24, 20, 15, 40, 18, 22, 25, 20, 61, 61, 27)); $pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C')); $pdf->SetWidths(array(10, 24, 23, 37, 30, 35, 18, 28, 24, 28, 25, 40, 18, 18, 18, 18, 18)); $pdf->SetFont('arial', '', 7); $pdf->RowMultiBorderWithHeight(array("NO", "TANGGAL", "NO.REGISTRASI", "NAMA WP", "JENIS TRANSAKSI", "NOP", "LT / LB", "HARGA TANAH / m2 (Rp)", "HARGA BANGUNAN / m2 (Rp)", "TOTAL NJOP (Rp)", "HARGA PASAR / TRANSAKSI / LELANG (Rp)", "NILAI PAJAK YANG HARUS DIBAYAR(Rp)"), array('LTB', 'LTB', 'LBT', 'LTB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLB', 'TLBR'), 5); $pdf->SetFont('arial', '', 8); $no = 1; $pdf->SetAligns(array('C', 'L', 'L', 'L', 'L', 'L', 'R', 'R', 'R', 'R', 'R', 'R', 'R', 'R', 'R', 'R', 'R', 'R')); $jumlah = 0; $jumlah = 0; $total_nilai_pajak = 0; $nilai_njop = 0; while ($dbConn->next_record()) { $items[] = $item = array('creation_date' => $dbConn->f("creation_date"), 'registration_no' => $dbConn->f("registration_no"), 'wp_name' => $dbConn->f("wp_name"), 'p_bphtb_legal_doc_type_id' => $dbConn->f("p_bphtb_legal_doc_type_id"), 'description' => $dbConn->f("description"), 'njop_pbb' => $dbConn->f("njop_pbb"), 'land_area' => $dbConn->f("land_area"), 'land_total_price' => $dbConn->f("land_total_price"), 'building_area' => $dbConn->f("building_area"), 'building_total_price' => $dbConn->f("building_total_price"), 'market_price' => $dbConn->f("market_price"), 'bphtb_amt_final' => $dbConn->f("bphtb_amt_final"), 'land_price_per_m' => $dbConn->f("land_price_per_m"), 'building_price_per_m' => $dbConn->f("building_price_per_m")); $nilai_njop = $dbConn->f("building_total_price") + $dbConn->f("land_total_price"); $pdf->RowMultiBorderWithHeight(array($no, dateToString($item['creation_date']), $item['registration_no'], $item['wp_name'], $item['description'], $item['njop_pbb'], number_format($item['land_area'], 0, ",", ".") . " / " . number_format($item['building_area'], 0, ",", "."), number_format($item['land_price_per_m'], 2, ",", "."), number_format($item['building_price_per_m'], 2, ",", "."), number_format($nilai_njop, 2, ",", "."), number_format($item['market_price'], 2, ",", "."), number_format($item['bphtb_amt_final'], 2, ",", ".")), array('LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LBR'), 6); $jumlah += $dbConn->f("amount"); // $jumlah_wp+=$dbConn->f("jumlah_wp"); $total_nilai_pajak += $item['bphtb_amt_final']; $no++; } $pdf->SetWidths(array(282, 40)); $pdf->SetAligns(array('C', 'R')); $pdf->SetFont('arial', 'B', 8); $pdf->RowMultiBorderWithHeight(array("TOTAL", number_format($total_nilai_pajak, 2, ",", ".")), array('LB', 'LBR'), 6); /*print_r($items); exit;*/ //$pdf->SetWidths(array(250,70)); $pdf->ln(12); $pdf->SetAligns(array("C", "C")); $pdf->SetWidths(array(169, 163)); $pdf->RowMultiBorderWithHeight(array("Mengetahui, \n Kepala Seksi Penyelesaian Piutang \n\n\n\n\n\n\n\n RACHMAT SATIADI, SIP, M.Si. \n ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ ", "\n Koordinator BPHTB" . "\n\n\n\n\n\n\n\n ZAENAL MANSUR \n ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ "), array("", ""), 4); $pdf->RowMultiBorderWithHeight(array("NIP : 19691104.1998.03.1.007", "NIP : 19630817.1989.01.1.006"), array("", ""), 1); //$pdf->RowMultiBorderWithHeight(array("","KASIE VOP"),array('','','','','','',''),6); $pdf->Output("", "I"); exit; }
$dbConn->close(); } //print_r($data);exit; $_HEIGHT = 4; $_BORDER = 0; $_FONT = 'Times'; $_FONTSIZE = 10; $pdf = new PDF_MC_Table(); $size = $pdf->_getpagesize('Legal'); $size[1] = 6; $pdf->DefPageSize = $size; $pdf->CurPageSize = $size; $pdf->AddPage('L', array(200, 150)); //$pdf->AddPage('P',array(210,296)); $pdf->SetFont('helvetica', '', $_FONTSIZE); $pdf->SetRightMargin($_HEIGHT); $pdf->SetLeftMargin($_HEIGHT); $pdf->SetAutoPageBreak(false, 0); $pdf->Ln(0); $pdf->Image('../images/Logo.png', 7, 10, 15, 15); $pdf->SetFont('Arial', 'B', 6); $pdf->Cell(10, 5, "", "TL", 0, 'L'); $pdf->Cell(80, 5, "PEMERINTAH KOTA BANDUNG", "TR", 0, 'C'); $pdf->Cell(10, 5, "", "", 0, 'L'); $pdf->Cell(90, 5, "", "TLR", 0, 'L'); $pdf->Ln(); $pdf->SetFont('Arial', 'B', 10); $pdf->Cell(10, 5, "", "L", 0, 'L'); $pdf->Cell(80, 5, "DINAS PELAYANAN PAJAK", "R", 0, 'C'); $pdf->Cell(10, 5, "", "", 0, 'L'); $pdf->Cell(90, 5, "PERHATIAN", "LR", 0, 'C');
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'); $size[1] = 6; $pdf->DefPageSize = $size; $pdf->CurPageSize = $size; $pdf->AddPage('Landscape', array(150, 40)); $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); $items = explode('#', $param_arr); foreach ($items as $item) { $pdf->RowMultiBorderWithHeight(array($item), array('', ''), 6); } //$pdf->ln(8); $handle = printer_open("HP Deskjet 930c"); $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 BPHTB "), array('', ''), 6); //$pdf->ln(8); $pdf->SetWidths(array(40, 200)); $pdf->ln(4); $pdf->RowMultiBorderWithHeight(array("TANGGAL", ": " . dateToString(date("Y-m-d"), true)), array('', ''), 6); $pdf->RowMultiBorderWithHeight(array("NAMA USER", ": " . $param_arr['uid']), array('', ''), 6); $dbConn = new clsDBConnSIKP(); $whereClause = " WHERE "; $whereClause .= " to_char(a.payment_date, 'YYYY-mm-dd') = '" . date("Y-m-d") . "'"; $whereClause .= " AND a.p_cg_terminal_id = '" . $param_arr['uid'] . "'"; $query = "SELECT a.receipt_no, b.njop_pbb, to_char(a.payment_date, 'YYYY-MM-DD') AS payment_date,\r\n\t\t\t\t\tb.wp_name, b.wp_address_name, kelurahan.region_name AS kelurahan_name, kecamatan.region_name AS kecamatan_name, b.land_area, b.building_area, b.land_total_price, a.payment_amount \r\n\t\t\t\t\tFROM t_payment_receipt_bphtb AS a\r\n\t\t\tLEFT JOIN t_bphtb_registration AS b ON a.t_bphtb_registration_id = b.t_bphtb_registration_id\r\n\t\t\tLEFT JOIN p_region AS kelurahan ON b.wp_p_region_id_kel = kelurahan.p_region_id\r\n\t\t\tLEFT JOIN p_region AS kecamatan ON b.wp_p_region_id_kec = kecamatan.p_region_id"; $query .= $whereClause; $query .= " ORDER BY a.receipt_no ASC"; // die($query); $dbConn->query($query); $items = array(); $pdf->SetFont('helvetica', '', 9); $pdf->ln(2); /* HEADER */ $pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C')); $pdf->SetWidths(array(10, 28, 35, 21, 41, 51, 28, 28, 21, 21, 25, 28)); $pdf->SetFont('arial', 'B', 7); $pdf->RowMultiBorderWithHeight(array("NO", "NO TRANSAKSI", "NOP", "TGL", "NAMA", "ALAMAT", "KELURAHAN", "KECAMATAN", "LUAS TANAH", "LUAS BGN", "NJOP (Rp)", "TOTAL BAYAR (Rp)"), array('LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'TLBR'), 5); /* END HEADER */ /* CONTENTS */ $pdf->SetFont('arial', '', 8); $no = 1; $pdf->SetAligns(array('C', 'L', 'L', 'C', 'L', 'L', 'L', 'L', 'R', 'R', 'R', 'R')); $total_nilai_penerimaan = 0; while ($dbConn->next_record()) { $items[] = $item = array('receipt_no' => $dbConn->f("receipt_no"), 'njop_pbb' => $dbConn->f("njop_pbb"), 'payment_date' => $dbConn->f("payment_date"), 'wp_name' => $dbConn->f("wp_name"), 'wp_address_name' => $dbConn->f("wp_address_name"), 'kelurahan_name' => $dbConn->f("kelurahan_name"), 'kecamatan_name' => $dbConn->f("kecamatan_name"), 'land_area' => $dbConn->f("land_area"), 'building_area' => $dbConn->f("building_area"), 'land_total_price' => $dbConn->f("land_total_price"), 'payment_amount' => $dbConn->f("payment_amount")); $pdf->RowMultiBorderWithHeight(array($no, $item['receipt_no'], $item['njop_pbb'], dateToString($item['payment_date']), trim(strtoupper($item['wp_name'])), $item['wp_address_name'], $item['kelurahan_name'], $item['kecamatan_name'], number_format($item['land_area'], 0), number_format($item['building_area'], 0), number_format($item['land_total_price'], 0, ",", "."), number_format($item['payment_amount'], 2, ",", ".")), array('LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LBR'), 6); $total_nilai_penerimaan += $item['payment_amount']; $no++; } /* END CONTENTS */ /* BOTTOM */ $pdf->SetWidths(array(309, 28)); $pdf->SetAligns(array('C', 'R')); $pdf->SetFont('arial', 'B', 8); $pdf->RowMultiBorderWithHeight(array("TOTAL", number_format($total_nilai_penerimaan, 2, ",", ".")), array('LB', 'LBR'), 6); /* END BOTTOM */ $pdf->ln(8); $pdf->Output("", "I"); 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 BPHTB "), array('', ''), 6); //$pdf->ln(8); $pdf->SetWidths(array(40, 200)); $pdf->ln(4); $pdf->RowMultiBorderWithHeight(array("TANGGAL", ": " . dateToString($param_arr['date_start'], true) . " s/d " . dateToString($param_arr['date_end'], true)), array('', ''), 6); $dbConn = new clsDBConnSIKP(); $whereClause = ''; $criteria = array(); if (!empty($param_arr['date_start']) && !empty($param_arr['date_end'])) { $criteria[] = " (trunc(a.payment_date) BETWEEN '" . $param_arr['date_start'] . "' AND '" . $param_arr['date_end'] . "') "; } else { if (!empty($param_arr['date_start']) && empty($param_arr['date_end'])) { $criteria[] = " trunc(a.payment_date) >= '" . $param_arr['date_start'] . "' "; } else { if (empty($param_arr['date_start']) && !empty($param_arr['date_end'])) { $criteria[] = " trunc(a.payment_date) <= '" . $param_arr['date_end'] . "' "; } } } if (!empty($param_arr['receipt_no'])) { $criteria[] = " a.receipt_no ILIKE '%" . $param_arr['receipt_no'] . "%' "; } if (!empty($param_arr['njop_pbb'])) { $criteria[] = " b.njop_pbb = '" . $param_arr['njop_pbb'] . "' "; } if (!empty($param_arr['wp_name'])) { $criteria[] = " b.wp_name ILIKE '%" . $param_arr['wp_name'] . "%' "; } if (!empty($param_arr['p_region_id_kecamatan'])) { $criteria[] = " b.wp_p_region_id_kec = " . $param_arr['p_region_id_kecamatan']; } if (!empty($param_arr['p_region_id_kelurahan'])) { $criteria[] = " b.wp_p_region_id_kel = " . $param_arr['p_region_id_kelurahan']; } if ($param_arr['p_bphtb_legal_doc_type_id'] != 0) { $criteria[] = " b.p_bphtb_legal_doc_type_id = " . $param_arr['p_bphtb_legal_doc_type_id']; } $whereClause = join(" AND ", $criteria); $query = "SELECT a.receipt_no, b.njop_pbb, to_char(a.payment_date, 'YYYY-MM-DD') AS payment_date, to_char(b.creation_date, 'YYYY-MM-DD') AS creation_date,\r\n\t\t\t\t\tb.wp_name, b.wp_address_name, kelurahan.region_name AS kelurahan_name, kecamatan.region_name AS kecamatan_name, b.land_area, b.building_area, b.land_total_price, a.payment_amount \r\n\t\t\t\t\tFROM t_payment_receipt_bphtb AS a\r\n\t\t\tLEFT JOIN t_bphtb_registration AS b ON a.t_bphtb_registration_id = b.t_bphtb_registration_id\r\n\t\t\tLEFT JOIN p_region AS kelurahan ON b.wp_p_region_id_kel = kelurahan.p_region_id\r\n\t\t\tLEFT JOIN p_region AS kecamatan ON b.wp_p_region_id_kec = kecamatan.p_region_id"; if (!empty($whereClause)) { $query .= " WHERE " . $whereClause; } $query .= " order by trunc(b.creation_date) ASC, upper(b.wp_name) ASC"; //print_r($query); //exit; $dbConn->query($query); $items = array(); $pdf->SetFont('helvetica', '', 9); $pdf->ln(2); /* HEADER */ $pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C')); $pdf->SetWidths(array(10, 28, 35, 19, 19, 41, 51, 28, 28, 15, 15, 25, 28)); $pdf->SetFont('arial', 'B', 7); $pdf->RowMultiBorderWithHeight(array("NO", "NO TRANSAKSI", "NOP", "TGL BAYAR", "TGL DAFTAR", "NAMA", "ALAMAT", "KELURAHAN", "KECAMATAN", "LUAS TNH", "LUAS BGN", "NJOP (Rp)", "TOTAL BAYAR (Rp)"), array('LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'TLBR'), 5); /* END HEADER */ /* CONTENTS */ $pdf->SetFont('arial', '', 8); $no = 1; $pdf->SetAligns(array('C', 'L', 'L', 'C', 'C', 'L', 'L', 'L', 'L', 'R', 'R', 'R', 'R')); $total_nilai_penerimaan = 0; while ($dbConn->next_record()) { $items[] = $item = array('receipt_no' => $dbConn->f("receipt_no"), 'njop_pbb' => $dbConn->f("njop_pbb"), 'payment_date' => $dbConn->f("payment_date"), 'creation_date' => $dbConn->f("creation_date"), 'wp_name' => $dbConn->f("wp_name"), 'wp_address_name' => $dbConn->f("wp_address_name"), 'kelurahan_name' => $dbConn->f("kelurahan_name"), 'kecamatan_name' => $dbConn->f("kecamatan_name"), 'land_area' => $dbConn->f("land_area"), 'building_area' => $dbConn->f("building_area"), 'land_total_price' => $dbConn->f("land_total_price"), 'payment_amount' => $dbConn->f("payment_amount")); $pdf->RowMultiBorderWithHeight(array($no, $item['receipt_no'], $item['njop_pbb'], dateToString($item['payment_date']), dateToString($item['creation_date']), trim(strtoupper($item['wp_name'])), $item['wp_address_name'], $item['kelurahan_name'], $item['kecamatan_name'], number_format($item['land_area'], 0), number_format($item['building_area'], 0), number_format($item['land_total_price'], 0, ",", "."), number_format($item['payment_amount'], 0, ",", ".")), array('LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LB', 'LBR'), 6); $total_nilai_penerimaan += $item['payment_amount']; $no++; } /* END CONTENTS */ /* BOTTOM */ $pdf->SetWidths(array(314, 28)); $pdf->SetAligns(array('C', 'R')); $pdf->SetFont('arial', 'B', 8); $pdf->RowMultiBorderWithHeight(array("TOTAL", number_format($total_nilai_penerimaan, 0, ",", ".")), array('LB', 'LBR'), 6); /* END BOTTOM */ $pdf->ln(12); $pdf->SetAligns(array("C", "C")); $pdf->SetWidths(array(169, 163)); if ($param_arr['date_start'] == '') { $pdf->RowMultiBorderWithHeight(array("Mengetahui, \n Kepala Seksi Penyelesaian Piutang \n\n\n\n\n\n\n\n DIN KAMADIANTINI S.IP, MM \n ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ ", "\n Admin Penerimaan BPHTB" . "\n\n\n\n\n\n\n\n INDRA WISNU, SE. \n ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ "), array("", ""), 4); $pdf->RowMultiBorderWithHeight(array("NIP : 19710320.199803.2.006", "NIP : 19731031.2009.1.1001"), array("", ""), 1); } else { if (date(strtotime($param_arr['date_start'])) < date(strtotime('01-06-2015'))) { $pdf->RowMultiBorderWithHeight(array("Mengetahui, \n Kepala Seksi Penyelesaian Piutang \n\n\n\n\n\n\n\n RACHMAT SATIADI, S.IP, M.Si \n ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ ", "\n Admin Penerimaan BPHTB" . "\n\n\n\n\n\n\n\n INDRA WISNU, SE. \n ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ "), array("", ""), 4); $pdf->RowMultiBorderWithHeight(array("NIP : 19691104.199803.1.007", "NIP : 19731031.2009.1.1001"), array("", ""), 1); } else { $pdf->RowMultiBorderWithHeight(array("Mengetahui, \n Kepala Seksi Penyelesaian Piutang \n\n\n\n\n\n\n\n DIN KAMADIANTINI S.IP, MM \n ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ ", "\n Admin Penerimaan BPHTB" . "\n\n\n\n\n\n\n\n INDRA WISNU, SE. \n ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ "), array("", ""), 4); $pdf->RowMultiBorderWithHeight(array("NIP : 19710320.199803.2.006", "NIP : 19731031.2009.1.1001"), array("", ""), 1); } } $pdf->Output("", "I"); 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 PIUTANG PAJAK"), 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(); /*echo '<pre>'; print_r($param_arr); exit;*/ $query = "select *,to_char(tgl_tap,'dd-mm-yyyy') as tgl_tap_formated,to_char(tgl_bayar,'dd-mm-yyyy') as tgl_bayar_formated from t_piutang_pajak_penetapan_final where p_vat_type_id=" . $param_arr['p_vat_type_id'] . " and p_year_period_id = " . $param_arr['year_period_id']; $dbConn->query($query); $items = array(); $pdf->SetFont('helvetica', '', 9); $pdf->ln(2); $pdf->SetWidths(array(28, 43, 23, 23, 35, 35, 25, 35, 35, 25, 20)); $pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C')); $pdf->RowMultiBorderWithHeight(array("NPWD", "MASA PAJAK", "TGL TAP", "NO KOHIR", "BESARNYA", "REALISASI PIUTANG", "TGL BAYAR", "SISA PIUTANG", "KETERANGAN", "TAHUN"), array('LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTBR'), 6); $pdf->SetFont('helvetica', '', 9); $no = 1; $pdf->SetAligns(array('C', 'L', 'C', 'L', 'R', 'R', 'C', 'R', 'R', 'L', 'L')); $jumlah_omzet = 0; $jumlah_ketetapan = 0; while ($dbConn->next_record()) { $items[] = $item = array("npwd" => $dbConn->f("npwd"), "masa_pajak" => $dbConn->f("masa_pajak"), "tgl_tap" => $dbConn->f("tgl_tap_formated"), "no_kohir" => $dbConn->f("no_kohir"), "realisasi_piutang" => $dbConn->f("realisasi_piutang"), "tgl_bayar" => $dbConn->f("tgl_bayar_formated"), "nilai_piutang" => $dbConn->f("nilai_piutang"), "sisa_piutang" => $dbConn->f("sisa_piutang"), "keterangan" => $dbConn->f("keterangan"), "p_year_period_id" => $dbConn->f("p_year_period_id"), "year_code" => $dbConn->f("year_code")); $pdf->RowMultiBorderWithHeight(array($item["npwd"], $item["masa_pajak"], $item["tgl_tap"], $item["no_kohir"], 'Rp ' . number_format($item["nilai_piutang"], 2, ',', '.'), 'Rp ' . number_format($item["realisasi_piutang"], 2, ',', '.'), $item["tgl_bayar"], 'Rp ' . number_format($item["sisa_piutang"], 2, ',', '.'), $item["keterangan"], $item["year_code"]), array('LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTBR'), 6); /*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->RowMultiBorderWithHeight(array('JUMLAH', 'Rp ' . number_format($jumlah_omzet, 2, ',', '.'), 'Rp ' . number_format($jumlah_ketetapan, 2, ',', '.')),array('LB','LB','LBR'),6); //signature $pdf->SetWidths(array(259,80)); $pdf->SetAligns(Array('C','C')); $pdf->RowMultiBorderWithHeight(array('', ''),array('',''),12); $pdf->RowMultiBorderWithHeight(array('', 'Bandung' . ', ' . date('d F Y')),array('',''),6); $pdf->RowMultiBorderWithHeight(array('', ''),array('',''),36); $pdf->SetAligns(Array('C','L')); $pdf->RowMultiBorderWithHeight(array('', 'Nama:'),array('','T'),6); $pdf->RowMultiBorderWithHeight(array('', 'Jabatan:'),array('',''),6);*/ $pdf->Output("", "I"); echo 'tes'; exit; }
echo '</script> </head> </html>'; exit; } $items = $data; $_BORDER = 0; $_FONT = 'Times'; $_FONTSIZE = 10; $pdf = new PDF_MC_Table(); $size = $pdf->_getpagesize('Legal'); $pdf->DefPageSize = $size; $pdf->CurPageSize = $size; $pdf->AddPage('Landscape', array(160, 210)); $pdf->SetFont('helvetica', '', $_FONTSIZE); $pdf->SetRightMargin(5); $pdf->SetLeftMargin(5); $pdf->SetTopMargin(-20); $pdf->SetAutoPageBreak(false, 0); $pdf->Image('../images/logo_pemda_warna.png', 12, 15, 20, 20); $pdf->SetFont('helvetica', 'B', 14); $pdf->SetWidths(array(10, 165)); $pdf->SetAligns(array("C", "C")); $pdf->RowMultiBorderWithHeight(array("", "PEMERINTAH KOTA BANDUNG\nDINAS PELAYANAN PAJAK"), array('', ''), 6); $pdf->SetFont('helvetica', '', 12); $pdf->SetWidths(array(15, 165)); $pdf->SetAligns(array("C", "C")); $pdf->RowMultiBorderWithHeight(array("", "Jalan Wastukancana No.2\nTelp. 022-4235052 - Bandung"), array('', ''), 6); $pdf->SetWidths(array(15, 165, 20)); $pdf->RowMultiBorderWithHeight(array("", "", ""), array('B', 'B', 'B'), 6); $pdf->ln(2);
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($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; }
public function printNoBayar() { include "lib/fpdf17/mc_table.php"; include "lib/qrcode/generate-qr-file.php"; $_GET['payment_key'] = $_GET['no_bayar']; $items = self::read(); $no_bayar = wbRequest::getVarClean('no_bayar', 'str', ''); $data = array('items' => array(), 'total' => 0, 'success' => false, 'message' => ''); try { $ws_client = self::getNusoap(); $params = array('search' => '', 'getParams' => json_encode($_GET), 'controller' => json_encode(array('module' => 'bds', 'class' => 't_vat_settlement', 'method' => 'getPaymentInfo', 'type' => 'json')), 'postParams' => json_encode($_POST), 'jsonItems' => '', 'start' => $start, 'limit' => $limit); $ws_data = self::getResultData($ws_client, $params); //throw new Exception ($ws_data['da']); $data['items'] = $ws_data['data']; $data['total'] = $ws_data['total']; $data['message'] = $ws_data['message']; $data['success'] = $ws_data['success']; $data['msg'] = $data['message']; } catch (Exception $e) { $data['message'] = $e->getMessage(); } $items = $data['items']; $_BORDER = 0; $_FONT = 'Times'; $_FONTSIZE = 10; $pdf = new PDF_MC_Table(); $size = $pdf->_getpagesize('Legal'); $pdf->DefPageSize = $size; $pdf->CurPageSize = $size; $pdf->AddPage('Landscape', array(160, 210)); $pdf->SetFont('helvetica', '', $_FONTSIZE); $pdf->SetRightMargin(5); $pdf->SetLeftMargin(5); $pdf->SetTopMargin(-20); $pdf->SetAutoPageBreak(false, 0); $pdf->Image('images/logo_pemda_warna.png', 12, 15, 20, 20); $pdf->SetFont('helvetica', 'B', 14); $pdf->SetWidths(array(10, 165)); $pdf->SetAligns(array("C", "C")); $pdf->RowMultiBorderWithHeight(array("", "PEMERINTAH KOTA BANDUNG\nDINAS PELAYANAN PAJAK"), array('', ''), 6); $pdf->SetFont('helvetica', '', 12); $pdf->SetWidths(array(15, 165)); $pdf->SetAligns(array("C", "C")); $pdf->RowMultiBorderWithHeight(array("", "Jalan Wastukancana No.2\nTelp. 022-4235052 - Bandung"), array('', ''), 6); $pdf->SetWidths(array(15, 165, 20)); $pdf->RowMultiBorderWithHeight(array("", "", ""), array('B', 'B', 'B'), 6); $pdf->ln(2); $pdf->SetFont('helvetica', '', 12); $pdf->SetAligns(array("L", "L", "L")); $pdf->SetWidths(array(40, 4, 80)); $pdf->ln(2); $pdf->RowMultiBorderWithHeight(array("MERK DAGANG", ":", $items['company_brand']), array('', '', ''), 6); $pdf->RowMultiBorderWithHeight(array("ALAMAT", ":", $items['brand_address_name'] . " " . $items['brand_address_no']), array('', '', ''), 6); $pdf->SetAligns(array("L", "L", "L", "C")); $pdf->SetWidths(array(40, 4, 80, 70)); $pdf->RowMultiBorderWithHeight(array("NPWPD", ":", $items['npwd'], "NOMOR PEMBAYARAN"), array('', '', '', 'BLTR'), 6); $pdf->SetAligns(array("L", "L", "L")); $pdf->SetWidths(array(40, 4, 80)); //$pdf->RowMultiBorderWithHeight(array("JENIS PAJAK",":",$items['items'][0]['vat_code']),array('','',''),6); $pdf->Cell(40, 6, 'JENIS PAJAK', "", 0, 'l'); $pdf->Cell(4, 6, ':', "", 0, 'L'); $pdf->Cell(80, 6, $items['vat_code'], "", 0, 'L'); $pdf->SetFont('helvetica', 'B', 26); $pdf->SetTextColor(255, 0, 0); $pdf->Cell(70, 15, $no_bayar, "BLTR", 0, 'C'); $pdf->SetFont('helvetica', '', 12); $pdf->SetTextColor(0, 0, 0); $pdf->ln(6); $pdf->RowMultiBorderWithHeight(array("MASA PAJAK", ":", $items['code']), array('', '', ''), 6); $pdf->SetAligns(array("L", "L", "R")); $pdf->SetWidths(array(40, 4, 40)); $pdf->RowMultiBorderWithHeight(array("JUMLAH (Rp)", ":", number_format($items['total_vat_amount'], 2, ",", ".")), array('', '', ''), 6); $pdf->RowMultiBorderWithHeight(array("DENDA (Rp)", ":", number_format($items['total_penalty_amount'], 2, ",", ".")), array('', '', ''), 6); $pdf->RowMultiBorderWithHeight(array("TOTAL (Rp)", ":", number_format($items['total_bayar'], 2, ",", ".")), array('', '', ''), 6); $pdf->SetAligns(array("L", "L", "L")); $pdf->SetWidths(array(40, 4, 80)); $pdf->RowMultiBorderWithHeight(array("TERBILANG", ":", ucwords($items['dengan_huruf'] . ' rupiah')), array('', '', ''), 6); //$pdf->RowMultiBorderWithHeight(array("BATAS WAKTU PEMBAYARAN",":",$items['items'][0]['pay_due_date']),array('','',''),6); $pdf->SetWidths(array(200)); $pdf->SetAligns(array("L")); $pdf->SetFont('helvetica', '', 10); $pdf->ln(6); $pdf->RowMultiBorderWithHeight(array("*Nomor pembayaran dan denda pajak yang tertera pada slip ini hanya berlaku pada hari ini, tanggal " . $items['settlement_date'] . " sampai dengan pukul 23:59 WIB"), array(''), 6); //$pdf->RowMultiBorderWithHeight(array("**Keterlambatan pembayaran melewati tanggal jatuh tempo akan dikenakan denda sesuai administrasi berupa bunga sebesar 2% (dua persen) setiap bulannya."), //array(''),6); $pdf->ln(8); $pdf->SetFont('helvetica', '', 12); $pdf->SetAligns(array("C")); $pdf->RowMultiBorderWithHeight(array("Bandung, " . $items['settlement_date'] . " Pukul " . $items['pukul']), array(''), 6); $pdf->SetFont('helvetica', '', 12); $pdf->RowMultiBorderWithHeight(array("BAYAR PAJAK MUDAH BANDUNG JUARA"), array(''), 6); $pdf->Image('http://' . $_SERVER['HTTP_HOST'] . '/mpd-wp/client/lib/qrcode/generate-qr.php?param=' . $no_bayar . '', 175, 13, 25, 25, 'PNG'); $pdf->Output(time() . "_kwitansi_" . $no_bayar, "I"); exit; }