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;
}
if ($rowPas['tiempo_completo'] == TRUE) {
$this->SetWidths(array(45, 45, 17.5, 45, 17.5));
$this->SetAligns(array('L'));
$this->Row(array(utf8_decode("\nTiempo de pasantÃa: "), utf8_decode("\nTiempo completo: "), utf8_decode(" \n X "), utf8_decode("\nMedio tiempo: "), utf8_decode("\n")));
} else {
$this->SetWidths(array(45, 45, 17.5, 45, 17.5));
$this->SetAligns(array('L'));
$this->Row(array(utf8_decode("\nTiempo de pasantÃa: "), utf8_decode("\nTiempo completo: "), utf8_decode("\n"), utf8_decode("\nMedio tiempo: "), utf8_decode(" \n X ")));
}
$this->SetX(20);
$this->SetWidths(array(170));
$this->SetAligns(array('L'));
$this->Row(array(utf8_decode("\nHorario de trabajo del Pasante: {$rowPas['horario']}")));
$this->SetX(20);
$this->SetWidths(array(170));
$this->SetAligns(array('L'));
$this->Row(array(utf8_decode("\nActividades a realizar por el pasante: \n\n{$rowPas['actividades']}")));
$this->SetX(20);
$this->SetWidths(array(56, 57, 57));
$this->SetAligns(array('L'));
$this->Row(array(utf8_decode("\nFirma del Pasante: "), utf8_decode("\nFirma del Supervisor Inmediato: \n\n\n\n\n "), utf8_decode("\nFirma del Coordinador de PasantÃas: ")));
}
}
//Main
$pdf = new PDF_MC_Table('P', 'mm', 'Letter');
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->Membrete();
$pdf->formatoTabla();
$pdf->Output("formato_dpe_pas_002.pdf", "D");
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($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;
}
}
}
$prezzoSenzaProvvigioni2[$k] = $prezzoSenzaProvvigioni / (($iva + 100) / 100);
$sku[$k] = $item->getSku();
$nome[$k] = $item->getName();
$id_ordine[$k] = $check[$i];
$totalePrezzoIvato = $totalePrezzoIvato + $prezzoIvato[$k];
$totalePrezzoPercentuale = $totalePrezzoPercentuale + $prezzoPercentuale[$k];
$totalePrezzoSenzaProvvigioni = $totalePrezzoSenzaProvvigioni + $prezzoSenzaProvvigioni2[$k];
$k = $k + 1;
}
}
define('EURO', chr(128));
$pdf = new PDF_MC_Table();
$pdf->AddPage();
$pdf->SetFont('Arial', 'B', 16);
$pdf->Cell(40, 7, 'NOTA VENDITA', 0, 1);
$pdf->Ln(7);
$pdf->SetWidths(array(22, 40, 30, 40, 30, 30));
srand(microtime() * 1000000);
$pdf->SetFont('Arial', 'B', 10);
$pdf->Row(array('ID ORDINE', 'PRODOTTO', 'PREZZO IVATO', 'PREZZO IMPONIBILE', '% 3C', 'DA FATT. A 3C'));
$pdf->SetFont('Arial', '', 10);
for ($i = 0; $i < count($sku); $i++) {
$prodotto = $sku[$i] . "\n" . $nome[$i];
$pdf->Row(array($id_ordine[$i], $prodotto, number_format($prezzoIvato[$i], 2, ",", "") . " " . EURO, $prezzoImponibile2[$i] . " " . EURO, $percentuale[$i] . " - " . number_format($prezzoPercentuale[$i], 2, ",", "") . " " . EURO, number_format($prezzoSenzaProvvigioni2[$i], 2, ",", "") . " " . EURO));
}
$pdf->SetFont('Arial', 'B', 10);
$pdf->Row(array("TOTALE", "", number_format($totalePrezzoIvato, 2, ",", "") . " " . EURO, number_format($totalePrezzoImponibile, 2, ",", "") . " " . EURO, number_format($totalePrezzoPercentuale, 2, ",", "") . " " . EURO, number_format($totalePrezzoSenzaProvvigioni, 2, ",", "") . " " . EURO));
$pdf->Output('nota_vendita.pdf', 'D');
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;
}
}
$pdf->Ln(5);
// Message
//
$pdf->SetFont($PDFFont, '', $PDFFontsize1);
$pdf->SetWidths(array(195));
$pdf->SetAligns(array('C'));
if (isset($MESSAGEID)) {
$pdf->Row(array($MESSAGEID));
}
// PDF Subject, Creator etc.
//
$pdf->SetTitle($Subject);
$pdf->SetSubject($Subject);
$pdf->SetAuthor($CompanyName);
$pdf->SetCreator($a['programname']);
// Check where to send the pdf output
//
if (!empty($sendfile)) {
// Send output to file
//
$pdf->Output("{$sendfile}", "F");
} else {
// Send output to browser. If you choose
// save as, this is the default file name
// format: date-id.pdf example 20071113-1.pdf
// if pdf plugin is used, only the filename
// will be displayed e.g. print_pdf.php
//
$pdf->Output("{$PrintD}-{$ID}.pdf", "I");
}
$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);
if ($items['p_settlement_type_id'] == 1) {
$pdf->RowMultiBorderWithHeight(array("*Nomor pembayaran dan denda pajak yang tertera pada slip ini berlaku sampai dengan tanggal " . $items['payment_due_day']), 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, " . date('d-M-y')), array(''), 6);
$pdf->SetFont('helvetica', '', 12);
$pdf->RowMultiBorderWithHeight(array("BAYAR PAJAK MUDAH BANDUNG JUARA"), array(''), 6);
$pdf->Image('http://' . $_SERVER['HTTP_HOST'] . '/mpd/include/qrcode/generate-qr.php?param=' . $no_bayar . '', 175, 13, 25, 25, 'PNG');
$pdf->Output(time() . "_kwitansi_" . $no_bayar, "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 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;
}
/**
* Init function
*/
function __construct($json)
{
require 'mc_table.php';
parent::__construct($json);
// Get Config
$conf = isset($_SESSION['pluginsConfig']) && isset($_SESSION['pluginsConfig']['export']) && isset($_SESSION['pluginsConfig']['export']['PDF']) ? $_SESSION['pluginsConfig']['export'] : array('PDF' => array());
$defaultFont = isset($conf['PDF']['defaultFont']) ? $conf['PDF']['defaultFont'] : 'FreeSans';
$defaultFontSize = isset($conf['PDF']['defaultFontSize']) ? $conf['PDF']['defaultFontSize'] : 9;
$headerFont = isset($conf['PDF']['headerFont']) ? $conf['PDF']['headerFont'] : $defaultFont;
$headerFontSize = isset($conf['PDF']['headerFontSize']) ? $conf['PDF']['headerFontSize'] : $defaultFontSize;
$headerFontStyle = isset($conf['PDF']['headerFontStyle']) ? $conf['PDF']['headerFontStyle'] : '';
$layerFont = isset($conf['PDF']['layerFont']) ? $conf['PDF']['layerFont'] : $defaultFont;
$layerFontSize = isset($conf['PDF']['layerFontSize']) ? $conf['PDF']['layerFontSize'] : $defaultFontSize;
$layerFontStyle = isset($conf['PDF']['layerFontStyle']) ? $conf['PDF']['layerFontStyle'] : '';
// Write to table
$pdf = new PDF_MC_Table();
// only for tcpdf version >= 3
// - font not well defined --> errors
// - header and footer printed = lines on top and bottom
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->Open();
$groups = (array) $this->jsonList[0];
foreach ($groups as $grp) {
$ret = $this->prepareData4PDF($grp);
$colsPerc = $ret[0];
$data = $ret[1];
$header = $data['header'];
$records = $data['records'];
$pdfW = 180;
// orientation detection
$orientation = 'P';
$colsum = $ret[2];
$maxSize = max($headerFontSize, $defaultFontSize);
$widthTmp = $colsum * $maxSize / 4;
if ($widthTmp > 1.5 * $pdfW) {
$pdfW = 270;
$orientation = 'L';
}
$pdf->AddPage($orientation);
$cols = array();
foreach ($colsPerc as $cp) {
$cols[] = $cp * $pdfW;
}
// add group name:
$pdf->SetFont($layerFont, $layerFontStyle, $layerFontSize);
$x = $pdf->GetX();
$y = $pdf->GetY();
$pdf->Cell(0, 0, $grp->description);
$pdf->SetXY($x, $y + 9);
// Calculate column widths
$pdf->SetWidths($cols);
// Add header
$pdf->SetFont($headerFont, $headerFontStyle, $headerFontSize);
$pdf->Row($header);
// Add records
$pdf->SetFont($defaultFont, '', $defaultFontSize);
foreach ($records as $row) {
$pdf->Row($row);
}
}
$pdfFilePath = $this->tempFilePath . '.pdf';
$this->tempFileLocation .= '.pdf';
$pdf->Output($pdfFilePath, 'F');
}
if ($total == 0) {
$total = '';
}
$pdf->Cell(5, 0.7, "{$total}", 1, 1, 'C');
$totalkeseluruhan += $total;
$no++;
}
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetX(1.5);
$pdf->Cell(8, 0.7, "TOTAL", 1, 0, 'C');
$str = "select id, area from gl_area ";
if ($area != '') {
$str .= " where id='{$area}' ";
}
$str .= " order by area asc ";
$querysub = mysql_query($str) or die(mysql_error());
$total = 0;
while (list($idarea, $namaarea) = mysql_fetch_row($querysub)) {
list($jmlunit) = mysql_fetch_row(mysql_query("select count(*) from gl_masterkendaraan where area='{$idarea}'"));
if ($jmlunit == 0) {
$jmlunit = '';
}
$pdf->Cell(5, 0.7, "{$jmlunit}", 1, 0, 'C');
$total += $jmlunit;
}
if ($total == 0) {
$total = '';
}
$pdf->Cell(5, 0.7, "{$total}", 1, 1, 'C');
$pdf->Output('Laporan Status Unit Kendaraan TLI Cabang ' . $row_data['area'] . '.pdf', 'D');
function reporteKardexProduccion()
{
$txtFechaInicio = $_REQUEST['txtFechaInicio'];
$txtFechaFinal = $_REQUEST['txtFechaFinal'];
$idProducto = $_REQUEST['idProducto'];
$idTipoMovimiento = $_REQUEST['idTipoMovimiento'];
$idTipoOperacion = $_REQUEST['idTipoOperacion'];
$txtDescripcion = $_REQUEST['txtDescripcion'];
$reporte = $this->AutoLoadModel('reporte');
$datos = $reporte->reporteKardexProduccion($txtFechaInicio, $txtFechaFinal, $idProducto, $idTipoMovimiento, $idTipoOperacion);
$cantidadData = count($datos);
$pdf = new PDF_MC_Table("L", "mm", "A4");
$titulos = array('#', 'FECHA', 'T. MOV.', 'CONCEPTO', 'ORDEN', 'RAZON SOCIAL', 'DEVOLUCION', 'PRECIO', 'CANT. ', 'SALDO', 'IMPORTE S/.');
$pdf->SetFont('Helvetica', 'B', 7.5);
$ancho = array(8, 18, 20, 30, 18, 70, 20, 20, 15, 15, 20);
$orientacion = array('', 'C', 'C', '', 'C', '', 'C', 'R', 'C', 'C', 'R');
$tipoCambioVentas = $this->configIni($this->configIni('Globals', 'Modo'), 'TipoCambio');
$pdf->SetWidths($ancho);
if (!empty($txtFechaFinal) || !empty($txtFechaInicio)) {
$fecha1 = !empty($txtFechaInicio) ? $txtFechaInicio : utf8_decode('?');
$fecha2 = !empty($txtFechaFinal) ? $txtFechaFinal : utf8_decode('?');
$pdf->_fecha = 'Rango Fecha: ' . $fecha1 . ' - ' . $fecha2;
}
$pdf->_titulo = "REPORTE::KARDEX DE PRODUCCION";
$pdf->_datoPie = $txtDescripcion . ' ' . 'Impreso el :' . date('Y-m-d H:m:s');
$pdf->AddPage();
$pdf->_titulos = $titulos;
$relleno = true;
$pdf->fill($relleno);
$pdf->SetFillColor(0224, 235, 255);
$pdf->SetTextColor(0);
$pdf->SetDrawColor(12, 78, 139);
$pdf->SetLineWidth(0.3);
$pdf->_orientacion = $orientacion;
$pdf->SetAligns($orientacion);
$pdf->SetTitulos($titulos);
$pdf->SetFillColor(0224, 235, 255);
$pdf->SetTextColor(0);
$pdf->SetDrawColor(12, 78, 139);
$importeFactura = 0;
$importeBoleta = 0;
for ($i = 0; $i < $cantidadData; $i++) {
$modoFactura = "";
$fila = array($i + 1, $datos[$i]['fecha'], $datos[$i]['tipo movimiento'], $datos[$i]['concepto movimiento'], $datos[$i]['codigov'], html_entity_decode($datos[$i]['razon social'], ENT_QUOTES, 'UTF-8'), $datos[$i]['devolucion'], number_format($datos[$i]['precio'], 2), $datos[$i]['cantidad'], $datos[$i]['saldo'], number_format(round($datos[$i]['precio'], 2) * $datos[$i]['cantidad'], 2));
$pdf->Row($fila);
$relleno = !$relleno;
$pdf->fill($relleno);
}
$pdf->AliasNbPages();
$pdf->Output();
}
function afficherPDF($vpdf)
{
require 'fpdf/mc_table.php';
$pdf = ob_get_clean();
$pdf = new PDF_MC_Table();
$pdf->AddPage();
$pdf->SetFont('Times', '', 12);
$pdf->Image("images/logo.png", 7, 5, 50.9);
$pdf->SetXY(9, 15);
$pdf->RoundedRect(95, 54, 110, 35, 2, 'D');
$pdf->SetXY(9, 40);
$pdf->MultiCell(80, 5, utf8_decode("Siège social : GSB\nPhiladelphie, \nPennsylvanie, Etats-Unis\ngsb_galaxybourdin@gmail.com "), 0, "L", 0);
$pdf->SetXY(100, 57);
$pdf->MultiCell(100, 7, utf8_decode("Client : " . $vpdf['nom'] . " " . $vpdf['prenom'] . "\nAdresse : " . $vpdf['adresse'] . "\nCode postal : " . $vpdf['cp'] . "\nVille : " . $vpdf['ville']), 0, "L", 0);
$pdf->SetXY(9, 100);
$pdf->MultiCell(80, 5, utf8_decode("Remboursement du : " . $vpdf['numMois'] . " / " . $vpdf['numAnnee']), 0, "L", 0);
$pdf->SetWidths(array(47.5, 47.5, 47.5, 47.5));
srand(microtime() * 1000000);
$pdf->SetXY(10, 110);
$pdf->MultiCell(190, 7, utf8_decode('Eléments forfaitisés'), 1, "L", 0);
$pdf->Row2(array('Frais forfaitaires', utf8_decode('Quantité'), 'Montant unitaire', 'Montant total'));
$pdf->Row2(array($vpdf['libelle'][0], utf8_decode($vpdf['quantite'][0]), $vpdf['montant'][0], $vpdf['montantT'][0] . " " . html_entity_decode($vpdf['euros'])));
$pdf->Row2(array(utf8_decode($vpdf['libelle'][1]), utf8_decode($vpdf['quantite'][1]), $vpdf['montant'][1], $vpdf['montantT'][1] . " " . html_entity_decode($vpdf['euros'])));
$pdf->Row2(array(utf8_decode($vpdf['libelle'][2]), utf8_decode($vpdf['quantite'][2]), $vpdf['montant'][2], $vpdf['montantT'][2] . " " . html_entity_decode($vpdf['euros'])));
$pdf->Row2(array(utf8_decode($vpdf['libelle'][3]), utf8_decode($vpdf['quantite'][3]), $vpdf['montant'][3], $vpdf['montantT'][3] . " " . html_entity_decode($vpdf['euros'])));
$pdf->SetXY(10, 157);
mysql_connect('localhost', 'root', '');
mysql_select_db('gsbv2');
//First table: put all columns automatically
$pdf->MultiCell(190, 7, utf8_decode('Eléments hors forfait'), 1, "L", 0);
$prop = array('HeaderColor' => array(205, 216, 211), 'color1' => array(255, 255, 255), 'color2' => array(255, 255, 250), 'padding' => 2);
$pdf->AddCol('date', 35, '', 'Date');
$pdf->AddCol('libelle', 105, 'Libelle');
$pdf->AddCol('montant', 50, 'Montant', 'R');
$pdf->Table("select date,libelle,montant from lignefraishorsforfait lf where lf.mois='" . $vpdf['mois'] . "' and lf.idVisiteur='" . $vpdf['id'] . "' " . "UNION ALL (select date,libelle,montant as idlfr from lignefraishorsforfaitrefuse lfr where lfr.mois='" . $vpdf['mois'] . "' and lfr.idVisiteur='" . $vpdf['id'] . "')", $prop);
$pdf->SetXY(10, 200);
$pdf->SetXY(130, 230);
$pdf->MultiCell(70, 7, "Total du " . $vpdf['numMois'] . " / " . $vpdf['numAnnee'] . " : " . $vpdf['montVal'] . " " . html_entity_decode($vpdf['euros']) . "\nNombre de justificatifs : " . $vpdf['nbJust'] . " fiche(s)" . utf8_decode("\nMontant refusé : ") . $vpdf['montRefuse'] . " " . html_entity_decode($vpdf['euros']) . "\nFait le : " . $vpdf['dateNow'] . "", 1, "R", 0);
$pdf->Output();
}
}
list($jmlcorporate) = mysql_fetch_row(mysql_query($strsub2));
if ($jmlcorporate == 0) {
$jmlcorporate = "";
}
//echo "<td align='center'>$jmlcorporate</td>";
$strsub2 = "select count(*) from gl_masterkendaraan where merk='{$idmerk}' and tipekendaraan='{$idtipe}' and jeniskendaraan='{$idjenis}' and unitstok='3' and cabang='{$idgudang}' ";
if ($area != '') {
$strsub2 .= " and area='{$area}' ";
}
list($jmloperational) = mysql_fetch_row(mysql_query($strsub2));
if ($jmloperational == 0) {
$jmloperational = "";
}
//echo "<td align='center'>$jmloperational</td>";
$strsub2 = "select count(*) from gl_masterkendaraan where merk='{$idmerk}' and tipekendaraan='{$idtipe}' and jeniskendaraan='{$idjenis}' and unitstok='4' and cabang='{$idgudang}' ";
if ($area != '') {
$strsub2 .= " and area='{$area}' ";
}
list($jmlcargo) = mysql_fetch_row(mysql_query($strsub2));
if ($jmlcargo == 0) {
$jmlcargo = "";
}
//echo "<td align='center'>$jmlcargo</td>";
}
}
}
$no++;
}
$pdf->Output('Laporan Stok kendaraan Cabang ' . $row_data['area'] . '.pdf', 'D');
public function generar_pdf($archivo = FALSE)
{
///// INICIO - Factura Detallada
/// Creamos el PDF y escribimos sus metadatos
ob_end_clean();
$pdf_doc = new PDF_MC_Table('P', 'mm', 'A4');
define('EEURO', chr(128));
$lineas = $this->factura->get_lineas();
if ($this->impresion['print_dto']) {
$this->impresion['print_dto'] = FALSE;
/// leemos las lÃneas para ver si de verdad mostramos los descuentos
foreach ($lineas as $lin) {
if ($lin->dtopor != 0) {
$this->impresion['print_dto'] = TRUE;
break;
}
}
}
$pdf_doc->SetTitle('Factura: ' . $this->factura->codigo . " " . $this->factura->numero2);
$pdf_doc->SetSubject('Factura del cliente: ' . $this->factura->nombrecliente);
$pdf_doc->SetAuthor($this->empresa->nombre);
$pdf_doc->SetCreator('FacturaSctipts V_' . $this->version());
$pdf_doc->Open();
$pdf_doc->AliasNbPages();
$pdf_doc->SetAutoPageBreak(true, 40);
// Definimos el color de relleno (gris, rojo, verde, azul)
$pdf_doc->SetColorRelleno('azul');
/// Definimos todos los datos de la cabecera de la factura
/// Datos de la empresa
$pdf_doc->fde_nombre = $this->empresa->nombre;
$pdf_doc->fde_FS_CIFNIF = FS_CIFNIF;
$pdf_doc->fde_cifnif = $this->empresa->cifnif;
$pdf_doc->fde_direccion = $this->empresa->direccion;
$pdf_doc->fde_codpostal = $this->empresa->codpostal;
$pdf_doc->fde_ciudad = $this->empresa->ciudad;
$pdf_doc->fde_provincia = $this->empresa->provincia;
$pdf_doc->fde_telefono = 'Teléfono: ' . $this->empresa->telefono;
$pdf_doc->fde_fax = 'Fax: ' . $this->empresa->fax;
$pdf_doc->fde_email = $this->empresa->email;
$pdf_doc->fde_web = $this->empresa->web;
$pdf_doc->fde_piefactura = $this->empresa->pie_factura;
/// Insertamos el Logo y Marca de Agua
if (file_exists('tmp/' . FS_TMP_NAME . 'logo.png') or file_exists('tmp/' . FS_TMP_NAME . 'logo.jpg')) {
$pdf_doc->fdf_verlogotipo = '1';
// 1/0 --> Mostrar Logotipo
$pdf_doc->fdf_Xlogotipo = '15';
// Valor X para Logotipo
$pdf_doc->fdf_Ylogotipo = '35';
// Valor Y para Logotipo
$pdf_doc->fdf_vermarcaagua = '1';
// 1/0 --> Mostrar Marca de Agua
$pdf_doc->fdf_Xmarcaagua = '25';
// Valor X para Marca de Agua
$pdf_doc->fdf_Ymarcaagua = '110';
// Valor Y para Marca de Agua
} else {
$pdf_doc->fdf_verlogotipo = '0';
$pdf_doc->fdf_Xlogotipo = '0';
$pdf_doc->fdf_Ylogotipo = '0';
$pdf_doc->fdf_vermarcaagua = '0';
$pdf_doc->fdf_Xmarcaagua = '0';
$pdf_doc->fdf_Ymarcaagua = '0';
}
// Tipo de Documento
$pdf_doc->fdf_tipodocumento = 'FACTURA';
// (FACTURA, FACTURA PROFORMA, ¿ALBARAN, PRESUPUESTO?...)
$pdf_doc->fdf_codigo = $this->factura->codigo . " " . $this->factura->numero2;
// Fecha, Codigo Cliente y observaciones de la factura
$pdf_doc->fdf_fecha = $this->factura->fecha;
$pdf_doc->fdf_codcliente = $this->factura->codcliente;
$pdf_doc->fdf_observaciones = iconv("UTF-8", "CP1252", $this->fix_html($this->factura->observaciones));
// Datos del Cliente
$pdf_doc->fdf_nombrecliente = $this->fix_html($this->factura->nombrecliente);
$pdf_doc->fdf_FS_CIFNIF = FS_CIFNIF;
$pdf_doc->fdf_cifnif = $this->factura->cifnif;
$pdf_doc->fdf_direccion = $this->fix_html($this->factura->direccion);
$pdf_doc->fdf_codpostal = $this->factura->codpostal;
$pdf_doc->fdf_ciudad = $this->factura->ciudad;
$pdf_doc->fdf_provincia = $this->factura->provincia;
$pdf_doc->fdc_telefono1 = $this->cliente->telefono1;
$pdf_doc->fdc_telefono2 = $this->cliente->telefono2;
$pdf_doc->fdc_fax = $this->cliente->fax;
$pdf_doc->fdc_email = $this->cliente->email;
$pdf_doc->fdf_epago = $pdf_doc->fdf_divisa = $pdf_doc->fdf_pais = '';
// Forma de Pago de la Factura
$pago = new forma_pago();
$epago = $pago->get($this->factura->codpago);
if ($epago) {
$pdf_doc->fdf_epago = $epago->descripcion;
}
// Divisa de la Factura
$divisa = new divisa();
$edivisa = $divisa->get($this->factura->coddivisa);
if ($edivisa) {
$pdf_doc->fdf_divisa = $edivisa->descripcion;
}
// Pais de la Factura
$pais = new pais();
$epais = $pais->get($this->factura->codpais);
if ($epais) {
$pdf_doc->fdf_pais = $epais->nombre;
}
// Cabecera Titulos Columnas
if ($this->impresion['print_dto']) {
$pdf_doc->Setdatoscab(array('ALB', 'DESCRIPCION', 'CANT', 'PRECIO', 'DTO', FS_IVA, 'IMPORTE'));
$pdf_doc->SetWidths(array(16, 102, 10, 20, 10, 10, 22));
$pdf_doc->SetAligns(array('C', 'L', 'R', 'R', 'R', 'R', 'R'));
$pdf_doc->SetColors(array('6|47|109', '6|47|109', '6|47|109', '6|47|109', '6|47|109', '6|47|109', '6|47|109'));
} else {
$pdf_doc->Setdatoscab(array('ALB', 'DESCRIPCION', 'CANT', 'PRECIO', FS_IVA, 'IMPORTE'));
$pdf_doc->SetWidths(array(16, 107, 10, 20, 15, 22));
$pdf_doc->SetAligns(array('C', 'L', 'R', 'R', 'R', 'R'));
$pdf_doc->SetColors(array('6|47|109', '6|47|109', '6|47|109', '6|47|109', '6|47|109', '6|47|109'));
}
/// Definimos todos los datos del PIE de la factura
/// Lineas de IVA
$lineas_iva = $this->factura->get_lineas_iva();
if (count($lineas_iva) > 3) {
$pdf_doc->fdf_lineasiva = $lineas_iva;
} else {
$filaiva = array();
$i = 0;
foreach ($lineas_iva as $li) {
$i++;
$filaiva[$i][0] = $li->iva ? FS_IVA . $li->iva : '';
$filaiva[$i][1] = $li->neto ? $this->ckeckEuro($li->neto) : '';
$filaiva[$i][2] = $li->iva ? $li->iva . "%" : '';
$filaiva[$i][3] = $li->totaliva ? $this->ckeckEuro($li->totaliva) : '';
$filaiva[$i][4] = $li->recargo ? $li->recargo . "%" : '';
$filaiva[$i][5] = $li->totalrecargo ? $this->ckeckEuro($li->totalrecargo) : '';
$filaiva[$i][6] = '';
//// POR CREARRRRRR
$filaiva[$i][7] = '';
//// POR CREARRRRRR
$filaiva[$i][8] = $li->totallinea ? $this->ckeckEuro($li->totallinea) : '';
}
if ($filaiva) {
$filaiva[1][6] = $this->factura->irpf . ' %';
$filaiva[1][7] = $this->ckeckEuro(0 - $this->factura->totalirpf);
}
$pdf_doc->fdf_lineasiva = $filaiva;
}
// Total factura numerico
$pdf_doc->fdf_numtotal = $this->ckeckEuro($this->factura->total);
// Total factura numeros a texto
$pdf_doc->fdf_textotal = $this->factura->total;
/// Agregamos la pagina inicial de la factura
$pdf_doc->AddPage();
// Lineas de la Factura
//$lineas = $this->factura->get_lineas();
if ($lineas) {
$neto = 0;
for ($i = 0; $i < count($lineas); $i++) {
$neto += $lineas[$i]->pvptotal;
$pdf_doc->neto = $this->ckeckEuro($neto);
$articulo = new articulo();
$art = $articulo->get($lineas[$i]->referencia);
if ($art) {
$observa = "\n" . utf8_decode($this->fix_html($art->observaciones));
} else {
// $observa = null; // No mostrar mensaje de error
$observa = "\n";
}
if ($this->impresion['print_dto']) {
$lafila = array('0' => utf8_decode($lineas[$i]->albaran_numero()), '1' => utf8_decode(strtoupper($lineas[$i]->descripcion)) . $observa, '2' => utf8_decode($lineas[$i]->cantidad), '3' => $this->ckeckEuro($lineas[$i]->pvpunitario), '4' => utf8_decode($this->show_numero($lineas[$i]->dtopor, 0) . " %"), '5' => utf8_decode($this->show_numero($lineas[$i]->iva, 0) . " %"), '6' => $this->ckeckEuro($lineas[$i]->total_iva()));
} else {
$lafila = array('0' => utf8_decode($lineas[$i]->albaran_numero()), '1' => utf8_decode(strtoupper($lineas[$i]->descripcion)) . $observa, '2' => utf8_decode($lineas[$i]->cantidad), '3' => $this->ckeckEuro($lineas[$i]->pvpunitario), '4' => utf8_decode($this->show_numero($lineas[$i]->iva, 0) . " %"), '5' => $this->ckeckEuro($lineas[$i]->total_iva()));
}
$pdf_doc->Row($lafila, '1');
// Row(array, Descripcion del Articulo -- ultimo valor a imprimir)
}
$pdf_doc->piepagina = true;
}
// Damos salida al archivo PDF
if ($archivo) {
if (!file_exists('tmp/' . FS_TMP_NAME . 'enviar')) {
mkdir('tmp/' . FS_TMP_NAME . 'enviar');
}
$pdf_doc->Output('tmp/' . FS_TMP_NAME . 'enviar/' . $archivo, 'F');
} else {
$pdf_doc->Output();
}
}
$totalbyr = $totalbyr + $result['totalbayar'];
$totalsisa = $totalsisa + $result['sisakekurangan'];
}
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetWidths(array(20.5, 2.6, 2.6, 2.6));
$pdf->Row(array("SUBTOTAL", number_format($totalsw, 0, ',', '.') . ",-", number_format($totalbyr, 0, ',', '.') . ",-", number_format($totalsisa, 0, ',', '.') . ",-"));
$pdf->SetWidths(array(28.3));
$pdf->Row(array("SEWA KENDARAAN NON RETAIL"));
$pdf->SetFont('Arial', '', 9);
$pdf->SetWidths(array(2.3, 2.5, 2.5, 2.5, 3.7, 2.2, 2.2, 2.6, 2.6, 2.6, 2.6));
$pdf->SetHeight(0.1);
$pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C'));
$query_datakorporate = $getquerykorporate;
$querykorp = mysql_query($query_datakorporate) or die("Query gagal");
while ($resultkorp = mysql_fetch_array($querykorp)) {
$pdf->Row(array($resultkorp['marketing'], DateToIndoAngka($resultkorp['mulai']), $resultkorp['no_ref'], $resultkorp['kendaraan'], $resultkorp['merk'] . '-' . $resultkorp['tipekendaraan'], DateToIndoAngka($resultkorp['mulai']), DateToIndoAngka($resultkorp['sampai']), $resultkorp['nama'], number_format($resultkorp['total'], 0, ',', '.') . ",-", number_format($resultkorp['totalbayar'], 0, ',', '.') . ",-", number_format($resultkorp['sisakekurangan'], 0, ',', '.') . ",-"));
$totalswkorporate = $totalswkorporate + $resultkorp['total'];
$totalbyrkorporate = $totalbyrkorporate + $resultkorp['totalbayar'];
$totalsisakorporate = $totalsisakorporate + $resultkorp['sisakekurangan'];
}
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetWidths(array(20.5, 2.6, 2.6, 2.6));
$pdf->Row(array("SUBTOTAL", number_format($totalswkorporate, 0, ',', '.') . ",-", number_format($totalbyrkorporate, 0, ',', '.') . ",-", number_format($totalsisakorporate, 0, ',', '.') . ",-"));
$pdf->SetWidths(array(28.3));
$pdf->Row(array(""));
$pdf->SetWidths(array(20.5, 2.6, 2.6, 2.6));
$pdf->SetFont('Arial', 'B', 10);
$pdf->Row(array("GRAND TOTAL", number_format($totalsw + $totalswkorporate, 0, ',', '.') . ",-", number_format($totalbyr + $totalbyrkorporate, 0, ',', '.') . ",-", number_format($totalsisa + $totalsisakorporate, 0, ',', '.') . ",-"));
$pdf->Ln();
$pdf->Output('Laporan Hasil Sewa Cabang ' . $gudang . ' Periode ' . DateToIndo($mulai) . " - " . DateToIndo($akhir) . '.pdf', 'D');
$pdf->SetFont('NewsGotT', 'B', 9);
$pdf->Text($x_texto1 - strlen($alumno->apellidos) / 2, $y_texto1, $alumno->apellidos);
$pdf->SetFont('NewsGotT', '', 9);
$pdf->Text($x_texto1 - strlen($alumno->nombre) / 2, $y_texto1 + 4, $alumno->nombre);
// Texto
$x_texto1 += 37;
if ($ln) {
$x_texto1 = 29.5;
$y_texto1 += 43;
}
// Imagen
$x_image += 37;
if ($ln) {
$x_image = 20;
$y_image += 43;
}
// En una hoja caben 30 fotos, se añade una nueva hoja y se reinicializan las variables
if ($i % 30 == 0) {
$pdf->AddPage('P', 'A4');
$pdf->Ln(10);
$x_texto1 = 29.5;
$y_texto1 = 56;
$x_image = 20;
$y_image = 21;
}
$i++;
}
mysqli_free_result($result);
}
$pdf->Output('Fotos de alumnos.pdf', 'I');
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 search_pdf($VAR, $construct, $type)
{
# include fpdf class:
include_once PATH_CORE . 'fpdf.inc.php';
# set the field list for this method:
$arr = $construct->method["{$type}"];
# loop through the field list to create the sql queries
$field_list = '';
$heading_list = '';
$width_list = '';
$i = 0;
while (list($key, $value) = each($arr)) {
if ($i == 0) {
$field_var = $construct->table . '_' . $value;
$field_list .= $value;
$heading_list .= strtoupper($value);
// <- translate
$width_list .= $construct->field[$value]['pdf_width'];
} else {
$field_var = $construct->table . '_' . $value;
$field_list .= "," . $value;
$heading_list .= "," . strtoupper($value);
// <- translate
$width_list .= "," . $construct->field[$value]['pdf_width'];
}
$i++;
}
# start the new PDF class...
$pdf = new PDF_MC_Table();
$pdf->Open();
$pdf->AddPage();
# Determine the number of columns and width for each one...
$SetWidths = explode(",", $width_list);
$pdf->SetWidths($SetWidths);
# Define the table heading
$TableHeading = explode(",", $heading_list);
# Define the Properties for the table heading cells:
# set the font:
$pdf->HeadFontFamily = "Arial";
$pdf->HeadFontStyle = "BI";
$pdf->HeadFontSize = 8;
# set the font color:
$pdf->HeadTextColor1 = 255;
$pdf->HeadTextColor2 = 255;
$pdf->HeadTextColor3 = 255;
# set the bg color:
$pdf->HeadFillColor1 = 90;
$pdf->HeadFillColor2 = 90;
$pdf->HeadFillColor3 = 90;
# set the hieght
$pdf->HeadHeight = 6;
# Print the Heading:
$pdf->HeadRow($TableHeading);
# Define the row settings for the rest of the cells...
# define the font settings
$pdf->SetFontFamily = "Arial";
$pdf->SetFontStyle = "";
$pdf->SetFontSize = "7";
# set the hieght
$pdf->RowHeight = 4;
/************** BEGIN STANDARD EXPORT SEARCH CODE *********************/
# set the field list for this method:
$arr = $construct->method["{$type}"];
# loop through the field list to create the sql queries
$arr = $construct->method[$type];
$field_list = '';
$i = 0;
while (list($key, $value) = each($arr)) {
if ($i == 0) {
$field_var = $construct->table . '_' . $value;
$field_list .= AGILE_DB_PREFIX . $construct->table . '.' . $value;
// determine if this record is linked to another table/field
if ($construct->field[$value]["asso_table"] != "") {
$this->linked[] = array('field' => $value, 'link_table' => $construct->field[$value]["asso_table"], 'link_field' => $construct->field[$value]["asso_field"]);
}
} else {
$field_var = $construct->table . '_' . $value;
$field_list .= "," . AGILE_DB_PREFIX . $construct->table . "." . $value;
// determine if this record is linked to another table/field
if ($construct->field[$value]["asso_table"] != "") {
$this->linked[] = array('field' => $value, 'link_table' => $construct->field[$value]["asso_table"], 'link_field' => $construct->field[$value]["asso_field"]);
}
}
$i++;
}
# get the search details:
if (isset($VAR['search_id'])) {
include_once PATH_CORE . 'search.inc.php';
$search = new CORE_search();
$search->get($VAR['search_id']);
} else {
echo '<BR> The search terms submitted were invalid!';
}
# get the sort order details:
if (isset($VAR['order_by']) && $VAR['order_by'] != "") {
$order_by = ' ORDER BY ' . AGILE_DB_PREFIX . $construct->table . '.' . $VAR['order_by'];
$smarty_order = $VAR['order_by'];
} else {
$order_by = ' ORDER BY ' . AGILE_DB_PREFIX . $construct->table . '.' . $construct->order_by;
$smarty_order = $search->order_by;
}
# format saved search string
$sql = explode(" WHERE ", $search->sql);
# generate the full query
$q = preg_replace("/%%fieldList%%/i", $field_list, $search->sql);
$q = preg_replace("/%%tableList%%/i", AGILE_DB_PREFIX . $construct->table, $q);
$q = preg_replace("/%%whereList%%/i", "", $q);
$q .= " " . AGILE_DB_PREFIX . $construct->table . ".site_id = '" . DEFAULT_SITE . "'";
$q .= $order_by;
$db =& DB();
$result = $db->Execute($q);
# error reporting
if ($result === false) {
global $C_debug;
$C_debug->error('core:export.inc.php', 'search_xml', $db->ErrorMsg() . '<br><br>' . $q);
echo "An SQL error has occured!";
return;
}
# put the results into an array
$i = 0;
$class_name = TRUE;
$results = '';
while (!$result->EOF) {
$results[$i] = $result->fields;
$result->MoveNext();
$i++;
}
# get any linked fields
if ($i > 0) {
$this->result = $results;
$db_join = new CORE_database();
$this->result = $db_join->join_fields($results, $this->linked);
} else {
$this->result = $results;
}
/************** END STANDARD EXPORT SEARCH CODE *********************/
# LOOP THROUGH THE RESULTS & DISPLAY AS PDF
$results = $result->RecordCount();
$BackAlt = TRUE;
while (!$result->EOF) {
# get the data for each cell:
reset($arr);
$CurrRow = '';
$i = 0;
while (list($key, $value) = each($arr)) {
if ($i == 0) {
$CurrRow .= $result->fields["{$key}"];
} else {
$CurrRow .= "::" . $result->fields["{$key}"];
}
$i++;
}
$ThisRow = explode("::", $CurrRow);
# set the colors & fonts
if ($BackAlt) {
# alternating row 1:
$pdf->SetTextColorVar1 = "50";
$pdf->SetTextColorVar2 = "50";
$pdf->SetTextColorVar3 = "50";
$pdf->SetFillColorVar1 = 255;
$pdf->SetFillColorVar2 = 255;
$pdf->SetFillColorVar3 = 255;
$BackAlt = FALSE;
} else {
# alternating row 2:
$pdf->SetTextColorVar1 = "0";
$pdf->SetTextColorVar2 = "0";
$pdf->SetTextColorVar3 = "0";
$pdf->SetFillColorVar1 = 240;
$pdf->SetFillColorVar2 = 240;
$pdf->SetFillColorVar3 = 240;
$BackAlt = TRUE;
}
# check for needed page break
$nb = 0;
for ($ii = 0; $ii < count($dataarr); $ii++) {
$nb = max($nb, $pdf->NbLines($pdf->widths[$ii], $dataarr[$ii]));
}
$h = 5 * $nb;
# Issue a page break first if needed
if ($pdf->CheckPageBreak($h)) {
# print the Table Heading again
$pdf->HeadRow($TableHeading);
}
$pdf->Row($ThisRow);
# Next record
$result->MoveNext();
}
# Dispay the output
$pdf->Output();
exit;
}
$pdf->RowMultiBorderWithHeight(array("", "", "---------------------------------------------------------------------", ""), array("", "", "", ""), $_HEIGHT);
$pdf->SetWidths(array(5, 45, 15, 60, 70));
$pdf->SetAligns(array("L", "L", "L", "R", "L"));
$pdf->RowMultiBorderWithHeight(array("", "TOTAL TAGIHAN", ": RP.", number_format($data['total_tagihan'], 0, ",", "."), ""), array("", "", "", "", ""), $_HEIGHT);
$pdf->SetWidths(array(5, 45, 15, 60, 70));
$pdf->SetAligns(array("L", "L", "L", "R", "L"));
$pdf->RowMultiBorderWithHeight(array("", "BIAYA ADMIN BANK", ": RP.", "0", ""), array("", "", "", "", ""), $_HEIGHT);
$pdf->SetWidths(array(5, 45, 75, 70));
$pdf->SetAligns(array("L", "L", "L"));
$pdf->RowMultiBorderWithHeight(array("", "", "---------------------------------------------------------------------", ""), array("", "", "", ""), $_HEIGHT);
$pdf->SetWidths(array(5, 45, 15, 60, 70));
$pdf->SetAligns(array("L", "L", "L", "R", "L"));
$pdf->RowMultiBorderWithHeight(array("", "TOTAL BAYAR", ": RP.", number_format($data['total_tagihan'], 0, ",", "."), ""), array("", "", "", "", ""), $_HEIGHT);
$pdf->SetWidths(array(5, 45, 145));
$pdf->SetAligns(array("L", "L", "L"));
$pdf->RowMultiBorderWithHeight(array("", "TERBILANG", ": " . $data['dengan_huruf']), array("", "", ""), $_HEIGHT);
$pdf->ln();
$pdf->SetWidths(array(5, 45, 145));
$pdf->SetAligns(array("L", "L", "L"));
$pdf->RowMultiBorderWithHeight(array("", "KODE/NAMA REKENING", ": " . $data['kode_rekening'] . " / " . $data['nama_rekening']), array("", "", ""), $_HEIGHT);
$pdf->SetWidths(array(5, 45, 145));
$pdf->SetAligns(array("L", "L", "L"));
$pdf->RowMultiBorderWithHeight(array("", "MASA AWAL/AKHIR PJK", ": " . $data['start_period'] . " / " . $data['end_period']), array("", "", ""), $_HEIGHT);
$pdf->SetWidths(array(5, 190));
$pdf->SetAligns(array("L", "L"));
$pdf->RowMultiBorderWithHeight(array("", "--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"), array("", ""), 3);
$pdf->SetWidths(array(5, 190));
$pdf->SetAligns(array("L", "C"));
$pdf->RowMultiBorderWithHeight(array("", "*BUKTI PEMBAYARAN/SETORAN INI HARAP DISIMPAN SEBAGAI BUKTI PEMBAYARAN YANG SAH*"), array("", ""), 3);
$pdf->Output("", "I");
exit;
$pdf->Write(5, "Remarks");
$pdf->SetXY(250, 50);
$pdf->Write(5, "System Engr.");
$pdf->Ln(7);
$query = "select * from reports order by report_id asc";
$result = odbc_exec($conn, $query);
$counter = 1;
$total = 0;
while ($data = odbc_fetch_array($result)) {
$report_id = $data['report_id'];
$report_date = $data['report_date'];
$report_location = $data['report_location'];
$machine = $data['machine'];
$serial_no = $data['serial_no'];
$program = $data['program'];
$problem = $data['problem'];
$diagnosis = $data['diagnosis'];
$work_done = $data['work_done'];
$remarks = $data['remarks'];
$system_engineer = $data['system_engineer'];
$pdf->SetFont('Arial', '', 12);
$pdf->SetX(10);
$pdf->SetWidths(array(15, 25, 20, 30, 30, 30, 30, 30, 30, 30, 40));
$pdf->Row(array($counter, $report_date, $report_location, $machine, $serial_no, $program, $problem, $diagnosis, $remarks, $system_engineer));
$total++;
$counter++;
}
$pdf->Ln(4);
$pdf->Cell(0, 10, "Total number of record: " . $total, 0, 1, "R");
$s = $pdf->Output('file.pdf', 'I');
// die();
$pdf->Row(array($a['invoice_amount'] . ':', Format_Number($TotalPosAmount) . ' ' . $Currency));
}
}
}
}
}
}
}
$pdf->SetFont($PDFFont, '', $PDFFontsize2);
$pdf->Ln(5);
// PDF Subject, Creator etc.
//
$pdf->SetTitle($Subject);
$pdf->SetSubject($Subject);
$pdf->SetAuthor($CompanyName);
$pdf->SetCreator($a['programname']);
// Check where to send the pdf output
//
if (!empty($sendfile)) {
// Send output to file
//
$pdf->Output("{$sendfile}", "F");
} else {
// Send output to browser. If you choose
// save as, this is the default file name
// format: date-id.pdf example 20071113-1.pdf
// if pdf plugin is used, only the filename
// will be displayed e.g. print_pdf.php
//
$pdf->Output("{$Type}.pdf", "I");
}
for ($i = 1; $i < 6; $i++) {
$result = mysqli_query($db_con, "SELECT DISTINCT a_asig, asig FROM horw WHERE a_grupo='{$unidad}' AND dia='{$i}' AND hora='{$hora}'");
unset($asignaturas);
while ($asignatura = mysqli_fetch_array($result)) {
$asignaturas .= $asignatura[0] . " | ";
}
$asignaturas = trim($asignaturas, " | ");
$row[$i] = $asignaturas . "\n\n\n";
}
$pdf->Row(array($row[1], $row[2], $row[3], $row[4], $row[5]));
}
$pdf->SetTextColor(0, 0, 0);
$pdf->Ln(5);
$pdf->SetFillColor(61, 61, 61);
$pdf->SetTextColor(255, 255, 255);
$pdf->SetFont('NewsGotT', 'B', 10);
$pdf->SetWidths(array(273));
$pdf->SetAligns(array('C'));
$pdf->Row(array('OBSERVACIONES'), 'DF');
$pdf->SetWidths(array(54.6, 54.6, 54.6, 54.6, 54.6));
$pdf->SetAligns(array('C', 'C', 'C', 'C', 'C'));
$pdf->SetTextColor(0, 0, 0);
$pdf->Row(array("LUNES", 'MARTES', 'MIÉRCOLES', 'JUEVES', 'VIERNES'));
$pdf->Row(array("\n\n\n\n\n\n", '', '', '', '', '', ''));
$pdf->Ln(5);
$pdf->SetFont('NewsGotT', 'B', 9);
$pdf->Cell(273, 5, "A - Ir al Aseo. B - Ir a beber agua. F - Falta de Asistencia. R - Retraso injustificado. J - Viene de Jefatura.", 0, 0, 'C');
mysqli_free_result($result);
}
$pdf->Output('Parte de faltas semanal ' . $inicio . '.pdf', 'I');
$pdf->Cell(90, 5, "", "BLR", 0, 'C');
$pdf->Cell(10, 5, "", "", 0, 'C');
$pdf->Cell(90, 5, "", "BLR", 0, 'C');
$pdf->Ln(7);
$pdf->SetWidths(array(190));
$pdf->SetAligns(array("C"));
$pdf->RowMultiBorderWithHeight(array("--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"), array(""), $_HEIGHT);
$pdf->Ln(2);
$pdf->SetFont('Arial', 'B', 14);
$pdf->RowMultiBorderWithHeight(array("\nTANDA TERIMA KARTU NPWPD\n"), array("TLR"), $_HEIGHT);
$pdf->SetFont('Arial', '', 10);
$pdf->SetWidths(array(10, 40, 130, 10));
$pdf->SetAligns(array("L", "L", "L", "L"));
$pdf->RowMultiBorderWithHeight(array("", "\nNPWPD\r\n\t\t\nMerk Dagang\r\n\t\t\nAlamat\r\n\t\t", "\n: " . $data['npwpd'] . "\r\n\t\t\n: " . $data['company_brand'] . "\r\n\t\t\n: " . $data['brand_address_name'] . "\r\n\t\t\n", ""), array("L", "", "", "R"), $_HEIGHT);
$pdf->SetWidths(array(70, 120));
$pdf->SetAligns(array("L", "C"));
$pdf->RowMultiBorderWithHeight(array("", "Bandung, " . date('d-m-Y') . "\r\n\t\t\nYang menerima\r\n\t\t\n\r\n\t\t\n\r\n\t\t" . $data['company_name'] . "\r\n\t\t\n"), array("BL", "BR"), $_HEIGHT);
//$pdf->Output("","I");
if (!empty($_GET['save'])) {
$name_of_file = "print_kartu_pdf_" . time() . ".pdf";
try {
$dbConn->query("INSERT INTO t_print_queue(t_customer_order_id, file_name, status) VALUES (" . $t_customer_order_id . ",'" . $name_of_file . "', 'SAVED');");
$dbConn->next_record();
$pdf->Output('D:\\work\\list_pdf\\' . $name_of_file, 'F');
} catch (Exception $e) {
@unlink('D:\\work\\list_pdf\\' . $name_of_file);
}
} else {
$pdf->Output("", "I");
}
exit;
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetWidths(array(14.5, 2.2, 2.6, 2.3, 2.6, 2.6, 2.6, 2.6, 2.6));
$pdf->Row(array("SUBTOTAL", number_format($totalangsuran, 0, ',', '.') . ",-", number_format($totaluangmuka, 0, ',', '.') . ",-", "0,-", "0,-", number_format($totaltunai, 0, ',', '.') . ",-", number_format($totaltrasfer, 0, ',', '.') . ",-", number_format($totaloperasional, 0, ',', '.') . ",-", number_format($total, 0, ',', '.') . ",-"));
$pdf->SetWidths(array(34.6));
$pdf->Row(array("SEWA KENDARAAN NON RETAIL (CORPORATE)"));
$pdf->SetFont('Arial', '', 9);
$pdf->SetWidths(array(2.3, 2.5, 2.5, 2.5, 2.5, 2.2, 2.2, 2.6, 2.3, 2.6, 2.6, 2.6, 2.6, 2.6));
$pdf->SetHeight(0.1);
$pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C'));
$query_datakorporate = $getquerykorporate;
$querykorp = mysql_query($query_datakorporate) or die("Query gagal");
while ($resultkorp = mysql_fetch_array($querykorp)) {
$pdf->Row(array($resultkorp['user'], $resultkorp['customer'], $resultkorp['no_ref'], DateToIndoAngka($resultkorp['periodeawal']), DateToIndoAngka($resultkorp['periodeakhir']), $resultkorp['kendaraan'], number_format($resultkorp['angsuran'], 0, ',', '.') . ",-", number_format($resultkorp['uangmuka'], 0, ',', '.') . ",-", "0,-", "0,-", number_format($resultkorp['tunai'], 0, ',', '.') . ",-", number_format($resultkorp['transfer'], 0, ',', '.') . ",-", number_format($resultkorp['operasional'], 0, ',', '.') . ",-", number_format($resultkorp['total'], 0, ',', '.') . ",-"));
$totalangsurankorporate += $resultkorp['angsuran'];
$totaluangmukakorporate += $resultkorp['uangmuka'];
$totaltrasferkorporate += $resultkorp['transfer'];
$totaltunaikorporate += $resultkorp['tunai'];
$totaloperasionalkorporate += $resultkorp['operasional'];
$totalkorporate += $resultkorp['total'];
}
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetWidths(array(14.5, 2.2, 2.6, 2.3, 2.6, 2.6, 2.6, 2.6, 2.6));
$pdf->Row(array("SUBTOTAL", number_format($totalangsurankorporate, 0, ',', '.') . ",-", number_format($totaluangmukakorporate, 0, ',', '.') . ",-", "0,-", "0,-", number_format($totaltunaikorporate, 0, ',', '.') . ",-", number_format($totaltrasferkorporate, 0, ',', '.') . ",-", number_format($totaloperasionalkorporate, 0, ',', '.') . ",-", number_format($totalkorporate, 0, ',', '.') . ",-"));
$pdf->SetWidths(array(34.6));
$pdf->Row(array(""));
$pdf->SetWidths(array(14.5, 2.2, 2.6, 2.3, 2.6, 2.6, 2.6, 2.6, 2.6));
$pdf->SetFont('Arial', 'B', 10);
$pdf->Row(array("GRAND TOTAL", number_format($totalangsuran + $totalangsurankorporate, 0, ',', '.') . ",-", number_format($totaluangmuka + $totaluangmukakorporate, 0, ',', '.') . ",-", "0,-", "0,-", number_format($totaltunai + $totaltunaikorporate, 0, ',', '.') . ",-", number_format($totaltrasfer + $totaltrasferkorporate, 0, ',', '.') . ",-", number_format($totaloperasional + $totaloperasionalkorporate, 0, ',', '.') . ",-", number_format($total + $totalkorporate, 0, ',', '.') . ",-"));
$pdf->Ln();
$pdf->Output('Laporan Penerimaan Hasil Sewa Cabang ' . $row_data['gudang'] . ' Periode ' . DateToIndo($mulai) . " - " . DateToIndo($akhir) . '.pdf', 'D');
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 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;
}
require 'mc_table.php';
// Load data
function LoadData($file)
{
// Read file lines
$datas = explode('end', trim($file));
foreach ($datas as $line) {
$line = substr($line, 0, -3);
$line_br = str_replace("<br>", "\r\n", explode('$@$', trim($line)));
$data[] = str_replace(" ", " ", $line_br);
}
return $data;
}
$hed = explode('end', $heds);
$line = substr($hed[0], 0, -3);
$header = explode('$@$', $line);
$data = LoadData($bdy);
//$header = array('Bill-To','Ship-To/Ship-To Location','PO #','Order/Quote/Plant','Planned/Est. Arr Shipping','Status');
$pdf = new PDF_MC_Table();
$pdf->SetWidths(array(40, 70, 40, 50, 55, 25));
$pdf->AddPage('L');
$pdf->SetFont('Arial', '', '');
$pdf->Image('../../images/madix-logo300.png', 10, 12, 50, 0, '', '');
$pdf->SetTopMargin(35);
$pdf->Row($header);
foreach ($data as $row) {
$pdf->Rows($row);
}
$pdf->Output();
header('Content-type: application/pdf');
header('Content-Disposition: attachment; filename="Order_list.pdf"');
$sql3 = "SELECT COUNT(tahun) FROM gl_masterkendaraan WHERE tipekendaraan = '{$tipekend}' AND tahun = '{$i}'";
list($jmltahun) = mysql_fetch_row(mysql_query($sql3));
if ($jmltahun == '0') {
$jmltahun = '';
}
$pdf->Cell(3, 0.7, "{$jmltahun}", 1, 0, 'C');
}
$pdf->Ln();
$no++;
}
$pdf->SetX(1.5);
$pdf->SetFont('Arial', 'B', 9);
$pdf->Cell(11, 0.7, "Total", 1, 0, 'C');
$total = array();
while (list($tipekend) = mysql_fetch_row($query)) {
list($namakend) = mysql_fetch_row(mysql_query("SELECT tipekendaraan FROM gl_tipekendaraan WHERE id = '{$tipekend}'"));
for ($i = $awal; $i <= $akhir; $i++) {
list($jmltahun) = mysql_fetch_row(mysql_query("SELECT COUNT(tahun) FROM gl_masterkendaraan WHERE tipekendaraan = '{$tipekend}' AND tahun = '{$i}'"));
if ($jmltahun == '0') {
$jmltahun = '';
}
$total[$i] = $jmltahun;
}
}
for ($i = $awal; $i <= $akhir; $i++) {
list($jml) = mysql_fetch_row(mysql_query("SELECT COUNT(tahun) FROM gl_masterkendaraan WHERE tahun = '{$i}'"));
$pdf->Cell(3, 0.7, "{$jml}", 1, 0, 'C');
}
$pdf->Ln();
$pdf->Output('Laporan Data unit Per Tahun Periode ' . $awal . " - " . $akhir . '.pdf', 'D');
