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;
 }
$pdf->SetMargins(20, 20);
$db = new PgDB();
//QUERY PARA LOS ESTUDIANTES DEL PERIODO ACTIVO
/*$query = "SELECT nombre, apellido, cedula, m01_registrada ::timestamp::date, m02_aceptada ::timestamp::date, m03_numero_asignado ::timestamp::date, m05_entrego_copia ::timestamp::date,
            m06_entrego_borrador ::timestamp::date, m07_retiro_borrador ::timestamp::date,  m08_entrega_final ::timestamp::date, m09_carga_nota ::timestamp::date, aprobada
            FROM usuario INNER JOIN pasantia ON usuario.id = pasantia.usuario_id AND usuario.tipo = 'estudiante' INNER JOIN periodo ON periodo.id = pasantia.periodo_id AND periodo.activo = TRUE";


$reco = pg_query($query);
$row = pg_fetch_array($reco);
*/
//QUERY PARA EL PERIDO ACTIVO
$queryPer = "SELECT tipo, anio FROM periodo WHERE activo = TRUE";
$recoPer = pg_query($queryPer);
$rowPer = pg_fetch_array($recoPer);
$pdf->SetFont('Arial', 'B', 12);
$pdf->MultiCell(0, 5, utf8_decode("\nRepública Bolivariana de Venezuela\nUniversidad del Zulia\nFacultad Experimental de Ciencias\nDivisión de Programas Especiales\nSistema de Pasantías\n"), 0, "C", 0);
$pdf->MultiCell(165, 5, utf8_decode("\n\nReporte General"), 0, "C", 0);
$pdf->MultiCell(165, 5, utf8_decode("\n{$rowPer['tipo']} - {$rowPer['anio']}"), 0, "C", 0);
$pdf->Ln();
$inscritos = contar("SELECT COUNT(*) FROM pasantia INNER JOIN periodo ON periodo.id = pasantia.periodo_id AND periodo.activo = TRUE WHERE pasantia.m01_registrada IS NOT NULL");
$aprobados = contar("SELECT COUNT(*) FROM pasantia INNER JOIN periodo ON periodo.id = pasantia.periodo_id AND periodo.activo = TRUE WHERE pasantia.aprobada = TRUE");
$reprobados = contar("SELECT COUNT(*) FROM pasantia INNER JOIN periodo ON periodo.id = pasantia.periodo_id AND periodo.activo = TRUE WHERE pasantia.aprobada = FALSE");
$pdf->Image("logotipo.jpg", 20, 12, -280);
//GENERAR LA TABLA
$pdf->SetXY(57, 70);
$pdf->SetFont('Arial', 'B', 12);
$pdf->SetWidths(array(30, 30, 30));
$pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C'));
$pdf->Row(array("Inscritos", "Aprobados", "Reprobados"));
$pdf->SetX(57);
Exemplo n.º 5
0
<?php

define('FPDF_FONTPATH', 'fpdf/font/');
require 'mc_table.php';
$pdf = new PDF_MC_Table('P', 'cm', "Legal");
$pdf->Open();
$pdf->AddPage();
$pdf->AliasNbPages();
$pdf->SetMargins(1, 1, 1);
$pdf->SetFont('times', 'B', 12);
$pdf->Cell(0, 0.9, 'Laporan Barang', 0, 0, 'C');
$pdf->Ln();
$tgl = date('Y-m-d');
$pdf->SetFont('times', 'B', 8);
$pdf->SetFont('times', 'B', 10);
$pdf->SetWidths(array(1, 8, 1.8, 2.1));
$pdf->SetHeight(0.1);
$pdf->Row(array("NO", "NAMA", "SATUAN", "STOK"));
$pdf->SetFont('times', '', 10);
$pdf->Row(array("1", "Buku Tulis Matematika Kualitas ABCD Kiki 80 gram 1 Lusin ", "Lusin", "100"));
$pdf->Output();
?>

Exemplo n.º 6
0
require 'mc_table.php';
function GenerateWord()
{
    //Get a random word
    $nb = rand(3, 10);
    $w = '';
    for ($i = 1; $i <= $nb; $i++) {
        $w .= chr(rand(ord('a'), ord('z')));
    }
    return $w;
}
function GenerateSentence()
{
    //Get a random sentence
    $nb = rand(1, 10);
    $s = '';
    for ($i = 1; $i <= $nb; $i++) {
        $s .= GenerateWord() . ' ';
    }
    return substr($s, 0, -1);
}
$pdf = new PDF_MC_Table();
$pdf->AddPage();
$pdf->SetFont('Arial', '', 14);
//Table with 20 rows and 4 columns
$pdf->SetWidths(array(30, 50, 30, 40));
srand(microtime() * 1000000);
for ($i = 0; $i < 20; $i++) {
    $pdf->Row(array(GenerateSentence(), GenerateSentence(), GenerateSentence(), GenerateSentence()));
}
$pdf->Output();
Exemplo n.º 7
0
	GNU General Public License for more details.

	You should have received a copy of the GNU General Public License
	along with this program; if not, write to the Free Software
	Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/
require_once '../../include/phprechnung.inc.php';
define('FPDF_FONTPATH', '../../include/font/');
define('EUR', chr(128));
require_once 'mc_table.php';
$pdf = new PDF_MC_Table();
$pdf->Open();
$pdf->AddPage();
$pdf->AliasNbPages();
$pdf->SetY(45);
$pdf->SetFont($PDFFont, '', $PDFFontsize1);
require_once 'pos_pdf.inc.php';
$pdf->Ln();
$pdf->SetFont($PDFFont, '', $PDFFontsize2);
$pdf->SetWidths(array(50, 30));
$pdf->SetAligns(array('L', 'R'));
// Total amount
//
if (isset($CompanyCurrency) && $CompanyCurrency == 'EUR') {
    $Currency = EUR;
} else {
    $Currency = $CompanyCurrency;
}
if (isset($Type) && $Type == 'Booking_Details' or $Type == 'Customer_Booking_Details') {
    $pdf->SetFont($PDFFont, 'BU');
    $pdf->Row(array($a['invoice_amount'] . ':', Format_Number($TotalAmount) . ' ' . $Currency));
    $data["nama_rekening"] = $dbConn->f("nama_rekening");
    $data["start_period"] = $dbConn->f("start_period");
    $data["end_period"] = $dbConn->f("end_period");
}
$_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('P', array(210, 296));
//$pdf->AddPage('P',array(210,296));
$pdf->SetFont('helvetica', '', $_FONTSIZE);
$pdf->SetRightMargin($_HEIGHT);
$pdf->SetLeftMargin($_HEIGHT);
$pdf->SetAutoPageBreak(false, 0);
$pdf->SetFont('Arial', '', 9);
//$pdf->Image('../images/logo_pemda.png',10,5,20,20);
$pdf->ln(20);
$pdf->SetWidths(array(5, 130, 60));
$pdf->SetAligns(array("L", "L", "L"));
$pdf->RowMultiBorderWithHeight(array("", "USER ID : " . $data["p_cg_terminal_id"], "TGL CETAK : " . date('d/m/Y')), array("", "", ""), $_HEIGHT);
$pdf->SetWidths(array(5, 130, 60));
$pdf->SetAligns(array("L", "L", "L"));
$pdf->RowMultiBorderWithHeight(array("", "DISYANJAK", "JAM CETAK : " . date('H:i:s')), array("", "", ""), $_HEIGHT);
$pdf->ln();
$pdf->SetWidths(array(5, 130, 60));
$pdf->SetAligns(array("L", "L", "L"));
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;
}
Exemplo n.º 10
0
$pdf->SetDisplayMode(100, "single");
$pdf->SetTitle("Netherhall House");
$border = 1;
$high = 6;
$width1 = 180;
$width2 = $width1 / 2;
$width3 = $width1 / 3;
$width4 = $width1 / 4;
/*
$pdf->SetFont('Arial','B',12);
$pdf->Cell(180,$high,"OUTSTANDING SUMMARY",0,0,'C',true);
$pdf->Ln();
$pdf->Ln();
*/
$pdf->SetFillColor(255, 255, 255);
$pdf->SetFont('Arial', 'B', 18);
$pdf->Cell(180, $high, $arrResident[name] . " " . $arrResident[surname], 0, 0, '', true);
$pdf->SetFont('Arial', '', 8);
$pdf->Ln();
$pdf->Ln();
$pdf->SetFillColor(230, 230, 230);
$pdf->Cell(16, $high, "Arrival", $border, 0, '', true);
$pdf->Cell(16, $high, "Departure", $border, 0, '', true);
$pdf->Cell(9, $high, "Days", $border, 0, 'R', true);
$pdf->Cell(10, $high, "Room", $border, 0, '', true);
$pdf->Cell(13, $high, "W. Rate", $border, 0, 'R', true);
$pdf->Cell(15, $high, "Total", $border, 0, 'R', true);
$pdf->Cell(13, $high, "Laundry", $border, 0, 'R', true);
$pdf->Cell(13, $high, "HC", $border, 0, 'R', true);
$pdf->Cell(13, $high, "Printing", $border, 0, 'R', true);
$pdf->Cell(13, $high, "Extra", $border, 0, 'R', true);
Exemplo n.º 11
0
 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();
 }
Exemplo n.º 12
0
 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();
 }
Exemplo n.º 13
0
 public function generateReport($field_names, $field_data, $field_widths, $data = array())
 {
     try {
         $main_heading = '';
         //require('mc_table.php');
         defined('FPDF_FONTPATH') || define('FPDF_FONTPATH', 'FPDF/font');
         if (isset($data['grid_no']) && $data['grid_no'] == 1 || isset($data['grid_count']) && $data['grid_count'] == 1) {
             $pdf = new PDF_MC_Table();
             $pdf->AddPage();
             // Headings
             $pdf->SetFont('Arial', '', 21);
             if (!empty($data['project_name'])) {
                 $main_heading .= $data['project_name'];
                 $pdf->Row(array($main_heading), $data);
             }
         } elseif (isset($data['pdf_object'])) {
             $pdf = $data['pdf_object'];
             $pdf->Ln(10);
         }
         $pdf->Ln(4);
         // Sub heading
         $pdf->SetFont('Arial', '', 15);
         $pdf->SetTextColor(20);
         $pdf->Cell(60, 10, $data['object_name'], 0, 0);
         $pdf->Cell(88);
         $pdf->SetFont('Arial', '', 9);
         $pdf->Cell(32, 10, date("F jS, Y", time()), 0, 1);
         // To show report generated date
         $pdf->Ln(5);
         if (isset($data['count_emp_reporting'])) {
             $pdf->Cell(60, 10, "My Team Count : " . $data['count_emp_reporting'], 0, 1);
             $pdf->Ln(5);
         }
         $pdf->SetFont('Arial', '', 9);
         //Table with 20 rows and 4 columns
         $pdf->SetWidths($field_widths);
         srand(microtime() * 1000000);
         // Header
         // Colors, line width and bold font
         $pdf->SetFillColor(249, 249, 249);
         $pdf->SetTextColor(20);
         $pdf->SetDrawColor(198, 200, 201);
         $pdf->SetLineWidth(0.3);
         $pdf->SetFont('', 'B');
         foreach ($field_names as $field_name) {
             $pdf->field_names[] = strtoupper($field_name['field_label']);
         }
         if (isset($data['field_name_align'])) {
             $pdf->SetAligns($data['field_name_align']);
             $pdf->Row($pdf->field_names);
             $pdf->field_name_align = $data['field_name_align'];
         } else {
             $pdf->Row($pdf->field_names);
         }
         //Data
         // Color and font restoration
         $pdf->SetFillColor(249, 249, 249);
         $pdf->SetTextColor(68);
         $pdf->SetFont('');
         if ($field_data) {
             foreach ($field_data as $rec) {
                 $row_values = array();
                 foreach ($field_names as $field_name) {
                     if (isset($field_name['field_name'])) {
                         if (isset($data['field_value_align'])) {
                             $pdf->SetAligns($data['field_value_align']);
                             $pdf->field_value_align = $data['field_value_align'];
                         } else {
                             //$pdf->SetAligns(array());
                         }
                         if (is_object($rec[$field_name['field_name']])) {
                             $rec[$field_name['field_name']] = $rec[$field_name['field_name']]->format('m-d-Y');
                         }
                         $row_values[] = $rec[$field_name['field_name']] == '' ? "--" : $rec[$field_name['field_name']];
                     }
                 }
                 $pdf->Row($row_values);
             }
         }
         if (isset($data['grid_no']) && $data['grid_no'] == 'last' || isset($data['grid_count']) && $data['grid_count'] == 1) {
             // AJAX download
             $file = BASE_PATH . '/downloads/reports/' . $data['file_name'];
             $pdf->Output($file, 'F');
             // Normal download
             /*$pdf->Output($data['file_name'],'D');
             		exit();*/
         } else {
             return $pdf;
         }
     } catch (Exception $e) {
         exit($e->getMessage());
     }
 }
    $rs->movenext();
}
//-----------------------------------------------------------------------------
//-----------------------Inicio pdf---------------------------------------------
$pdf = new PDF_MC_Table('L', 'mm', 'Letter');
$pdf->AddFont('GillSans', '', 'GillSans.php');
$pdf->AddFont('GillSans', 'B', 'GillSans_B.php');
$pdf->AddFont('GillSans', 'BI', 'GillSans_BI.php');
$pdf->AddFont('GillSans', 'I', 'GillSans_I.php');
$pdf->AddFont('GillSans', 'L', 'GillSans_L.php');
$pdf->AddFont('GillSans', 'LI', 'GillSans_LI.php');
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetLeftMargin(25);
//----------------------------------------------
$pdf->SetFont('GillSans', '', 10);
$pdf->SetFillColor(249, 250, 252);
$pdf->Cell(70, 4, ' Estructura Programática ', 0, 0, 'L', 0);
$pdf->Cell(70, 4, 'Ejercicio: 2015 ', 0, 0, 'L', 0);
$pdf->Ln(5);
$pdf->SetFont('GillSans', 'B', 10);
$pdf->Cell(240, 4, 'Catálogo de Programas', 1, 1, 'C', 1);
$pdf->SetFont('GillSans', '', 10);
$y = $pdf->GetY();
$x = $pdf->GetX();
$pdf->MultiCell(20, 8, 'ID', 1, 'C', 1);
$pdf->SetXY($x + 20, $y);
$pdf->MultiCell(40, 8, 'Clave', 1, 'C', 1);
$pdf->SetXY($x + 60, $y);
$pdf->MultiCell(150, 8, 'Descripción', 1, 'C', 1);
$pdf->SetXY($x + 210, $y);
Exemplo n.º 15
0
{
    return iconv('UTF-8', 'windows-1251', $val);
}
$month_rus = array("января", "февраля", "марта", "апреля", "мая", "июня", "июля", "августа", "сентября", "октября", "ноября", "декабря");
define('FPDF_FONTPATH', './font/');
require './mc_table/mc_table.php';
if (isset($_POST['jsonstring'])) {
    $_SESSION['applydata'] = json_decode($_POST['jsonstring']);
}
if (isset($_GET['getpdf'])) {
    $applyData = $_SESSION['applydata'];
    $pdf = new PDF_MC_Table('P');
    $pdf->SetMargins(25, 10, 10);
    $pdf->AddFont('TimesNewRomanPSMT', '', 'times.php');
    $pdf->AddPage();
    $pdf->SetFont('TimesNewRomanPSMT', '', 12);
    $pdf->SetX(110);
    $pdf->MultiCell(88, 5, sav2_convert("Государственное бюджетное учреждение \n Республики Коми \"Центр по предоставлению \n государственных услуг в сфере \n социальной защиты населения "), 0, 'R');
    $pdf->SetX(110);
    $pdf->SetTextColor(0, 0, 255);
    $pdf->MultiCell(88, 6, sav2_convert($applyData->{'org-town'} . "\""), 'B', 'R');
    $pdf->SetTextColor(0, 0, 0);
    $pdf->Ln();
    $pdf->MultiCell($width, 5, sav2_convert("ЗАЯВЛЕНИЕ \n о признании семьи или одиноко проживающего гражданина \n малоимущими и назначении государственной социальной помощи"), 0, 'C');
    $pdf->Ln();
    $pdf->Cell(6, 5, sav2_convert('от'), 0);
    $pdf->SetTextColor(0, 0, 255);
    $pdf->MultiCell($width, 5, sav2_convert($applyData->{'customer-fio'}), 'B', 'C');
    $pdf->SetTextColor(0, 0, 0);
    $pdf->Cell($width, 5, sav2_convert("(фамилия, имя, отчество)"), 0, 1, 'C');
    $pdf->Cell($width, 6, sav2_convert("зарегистрированного(ой) по месту жительства (месту пребывания) по адресу:"), 0, 1, 'L');
Exemplo n.º 16
0
    return $result;
}
//get query dan variabel
$mulai = $_GET['mulai'];
$akhir = $_GET['akhir'];
$gudang = $_GET['gudang'];
$decode_cr = $_GET['cr_txt'];
$getquery = str_replace("+", " ", $_GET[query]);
$getquerykorporate = str_replace("+", " ", $_GET[query_korporate]);
//instansiasi fpdf
$pdf = new PDF_MC_Table('L', 'cm', 'A4');
$pdf->AliasNbPages();
$pdf->AddPage();
$pdf->SetMargins(0.7, 0.7, 0.7, 0.7);
#tampilkan judul laporan
$pdf->SetFont('Arial', 'B', '16');
$pdf->Cell(0, 0, "CIPAGANTI RENTAL CAR & TRAVEL", '0', 1, 'C');
$pdf->Cell(0, 2, "HASIL SEWA KENDARAAN", '0', 1, 'C');
$pdf->SetFont('Arial', 'B', '12');
$pdf->Cell(3, 3, "CABANG : " . $gudang, 0, 0, 'L');
$pdf->Cell(25.2, 3, "PERIODE : " . DateToIndo($mulai) . " - " . DateToIndo($akhir), 0, 0, 'R');
//membuat kop tabel
$y = $pdf->GetY();
$pdf->SetY($y + 2.5);
$pdf->SetFont('Arial', 'B', 11);
$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'));
$pdf->Row(array("CSO", "Berangkat", "No. Order", "No. Kendaraan", "Merk Kendaraan", "Periode Awal", "Periode Akhir", "Customer", "T.Sewa", "T.Bayar", "Piutang"));
$pdf->SetFont('Arial', 'B', 9);
$pdf->SetWidths(array(28.3));
Exemplo n.º 17
0
                }
            }
        }
        $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($param_arr)
{
    include "../include/fpdf17/mc_table.php";
    $_BORDER = 0;
    $_FONT = 'Times';
    $_FONTSIZE = 10;
    $pdf = new PDF_MC_Table();
    $size = $pdf->_getpagesize('Legal');
    $pdf->DefPageSize = $size;
    $pdf->CurPageSize = $size;
    $pdf->AddPage('Landscape', 'Legal');
    $pdf->SetFont('helvetica', '', $_FONTSIZE);
    $pdf->SetRightMargin(5);
    $pdf->SetLeftMargin(9);
    $pdf->SetAutoPageBreak(false, 0);
    $pdf->SetFont('helvetica', '', 12);
    $pdf->SetWidths(array(200));
    $pdf->ln(1);
    $pdf->RowMultiBorderWithHeight(array("LAPORAN PENCETAKAN PENERIMAAN"), array('', ''), 6);
    //$pdf->ln(8);
    $pdf->SetWidths(array(40, 200));
    $pdf->ln(4);
    //$pdf->RowMultiBorderWithHeight(array("DAFTAR SPTPD",": ".$param_arr['vat_code_dtl']),array('',''),6);
    //$pdf->RowMultiBorderWithHeight(array("TAHUN",": ".$param_arr['year_code']),array('',''),6);
    $pdf->RowMultiBorderWithHeight(array("TANGGAL", ": " . dateToString($param_arr['date_start']) . " s/d " . dateToString($param_arr['date_end'])), array('', ''), 6);
    $dbConn = new clsDBConnSIKP();
    if (empty($param_arr['p_vat_type_id'])) {
        $param_arr['p_vat_type_id'] = 'null';
    }
    if (!empty($param_arr['p_vat_type_dtl_id'])) {
        $query = "select *,to_char(start_period, 'DD-MM-YYYY') as start_period_formated,to_char(end_period, 'DD-MM-YYYY') as end_period_formated,to_char(tanggal, 'DD-MM-YYYY') as date_settle_formated from sikp.f_laporan_harian_sptpd(1," . $param_arr['year_code'] . ",'" . $param_arr['date_start'] . "', '" . $param_arr['date_end'] . "'," . $param_arr['p_vat_type_dtl_id'] . ") ORDER BY tanggal, jenis ASC";
    } else {
        $query = "select *,to_char(start_period, 'DD-MM-YYYY') as start_period_formated,to_char(end_period, 'DD-MM-YYYY') as end_period_formated,to_char(tanggal, 'DD-MM-YYYY') as date_settle_formated from sikp.f_laporan_harian_sptpd(" . $param_arr['p_vat_type_id'] . ",2001,'" . $param_arr['date_start'] . "', '" . $param_arr['date_end'] . "') ORDER BY trunc(tanggal),ayat_code_dtl, jenis ASC";
    }
    //$dbConn->query($query);
    $items = array();
    $pdf->SetFont('helvetica', '', 10);
    $pdf->ln(2);
    $pdf->SetWidths(array(10, 80, 60, 40, 50, 80));
    $pdf->SetAligns(array('C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C', 'C'));
    $pdf->RowMultiBorderWithHeight(array("NO", "NAMA BADAN ", "PERIODE TRANSAKSI", "TGL PELAPORAN", "TOTAL PAJAK", "NO.KWITANSI"), array('LTB', 'LTB', 'LTB', 'LTB', 'LTBR'), 6);
    $pdf->SetFont('helvetica', '', 10);
    $no = 1;
    $pdf->SetAligns(array('C', 'L', 'L', 'L', 'L', 'L', 'L', 'C', 'L', 'R', 'R'));
    $jumlah_omzet = 0;
    $jumlah_ketetapan = 0;
    /*while($dbConn->next_record()){
    		$start_period = $dbConn->f("start_period_formated");
    		$end_period = $dbConn->f("end_period_formated");
    		$date_settle = $dbConn->f("date_settle_formated");
    		$items[]= $item = array('tanggal' => $date_settle,
    					   'no_order' => $dbConn->f("no_order"),
    					   'nama' => $dbConn->f("nama"),
    					   'alamat' => $dbConn->f("alamat"),
    					   'npwpd' => $dbConn->f("npwpd"),
    					   'omzet' => $dbConn->f("omzet"),
    					   'ketetapan' => $dbConn->f("ketetapan"),
    					   'kohir' => $dbConn->f("kohir"),
    					   'start_period' => $start_period,
    					   'end_period' => $end_period,
    					   'jenis_pajak' => $dbConn->f("jenis"),
    					   'jenis_pajak_dtl' => $dbConn->f("jenis_dtl"),
    					   'ayat_code' => $dbConn->f("ayat_code"),
    					   'ayat_code_dtl' => $dbConn->f("ayat_code_dtl")
    						);
    		if(!empty($param_arr['p_vat_type_dtl_id'])){
    			$pdf->RowMultiBorderWithHeight(array($no,$item['tanggal'],$item['no_order'],$item['nama'],$item['alamat'],$item['npwpd'], 2, ',', '.'),$item['kohir'],$item['start_period'].' - '.$item['end_period'],$item['jenis_pajak'],'Rp '.number_format($item['omzet'], 2, ',', '.'),'Rp '.number_format($item['ketetapan']),array('LB','LB','LB','LB','LB','LB','LB','LB','LB','LB','LBR'),6);			
    		}else{
    			$pdf->RowMultiBorderWithHeight(array($no,$item['tanggal'],$item['ayat_code'].'.'.$item['ayat_code_dtl'],$item['nama'],$item['alamat'],$item['npwpd'],$item['kohir'],$item['start_period'].' - '.$item['end_period'],$item['jenis_pajak'],'Rp '.number_format($item['omzet'], 2, ',', '.'),'Rp '.number_format($item['ketetapan'], 2, ',', '.')),array('LB','LB','LB','LB','LB','LB','LB','LB','LB','LB','LBR'),6);
    		}
    		$jumlah_omzet += $dbConn->f("omzet");
    		$jumlah_ketetapan += $dbConn->f("ketetapan");
    		$no++;
    	}*/
    $pdf->SetWidths(array(259, 40, 40));
    $pdf->SetAligns(array('C', 'R', 'R'));
    $pdf->ln(5);
    $pdf->SetWidtHs(array(239, 90));
    $pdf->SetAligns(array("C", "C", "C", "C", "C"));
    //$pdf->RowMultiBorderWithHeight(array("","KEPALA SEKSI VERIFIKASI OTORISASI DAN PEMBUKUAN\n\n\n\n\n(Drs. H. UGAS RAHMANSYAH, SAP, MAP)\n(NIP 19640127 199703 1001)"),array("",""),5);
    $pdf->Output("", "I");
    echo 'tes';
    exit;
}
function print_laporan($p_rqst_type_id, $year_code, $year_period_id, $date_start, $date_end, $jenis_tahun, $rqst_type_code)
{
    include "../include/fpdf17/mc_table.php";
    $_BORDER = 0;
    $_FONT = 'Times';
    $_FONTSIZE = 8;
    $pdf = new PDF_MC_Table();
    $pdf->AddPage('Portrait', 'Letter');
    $pdf->SetFont('helvetica', '', $_FONTSIZE);
    $pdf->SetRightMargin(5);
    $pdf->SetLeftMargin(5);
    $pdf->SetAutoPageBreak(false, 0);
    $pdf->SetFont('helvetica', '', 9);
    $pdf->SetWidths(array(200));
    $pdf->ln(1);
    if ($jenis_tahun == 'pajak') {
        $pdf->RowMultiBorderWithHeight(array("Laporan Penerimaan Global per Masa Pajak"), array('', ''), 6);
    } else {
        if ($jenis_tahun == 'bayar') {
            $pdf->RowMultiBorderWithHeight(array("Laporan Penerimaan Global per Tanggal / Penerimaan"), array('', ''), 6);
        }
    }
    //$pdf->ln(8);
    $pdf->SetWidths(array(30, 200));
    $pdf->ln(4);
    $pdf->RowMultiBorderWithHeight(array("Jenis Pajak", ": " . $rqst_type_code), array('', ''), 6);
    //$pdf->RowMultiBorderWithHeight(array("Tahun",": ".$year_code),array('',''),6);
    $pdf->RowMultiBorderWithHeight(array("Tanggal", ": " . dateToString($date_start) . " s/d " . dateToString($date_end)), array('', ''), 6);
    $dbConn = new clsDBConnSIKP();
    if ($jenis_tahun == 'pajak') {
        $query = "select * from sikp.f_laporan_per_thn_pajak(" . $p_rqst_type_id . "," . $year_period_id . ",'" . $date_start . "', '" . $date_end . "')";
    } else {
        if ($jenis_tahun == 'bayar') {
            $query = "select * from sikp.f_laporan_per_thn_bayar(" . $p_rqst_type_id . ",2013,'" . $date_start . "', '" . $date_end . "')";
        }
    }
    $dbConn->query($query);
    $items = array();
    $pdf->SetFont('helvetica', '', 8);
    $pdf->ln(2);
    $pdf->SetWidths(array(10, 40, 40, 33, 37, 40));
    $pdf->RowMultiBorderWithHeight(array("NO", "BULAN", "BESARNYA", "JUMLAH WP", "JUMLAH SSPD", "KETERANGAN"), array('LTB', 'LTB', 'LTB', 'LTB', 'LTB', 'LTBR'), 6);
    $pdf->SetFont('helvetica', '', 8);
    $no = 1;
    $pdf->SetAligns(array('C', 'L', 'R', 'R', 'R', 'L'));
    $jumlah = 0;
    $jumlah = 0;
    while ($dbConn->next_record()) {
        $items[] = array('bulan_wp' => $dbConn->f("bulan_wp"), 'total_amount' => $dbConn->f("total_amount"), 'jumlah_wp' => $dbConn->f("jumlah_wp"));
        $pdf->RowMultiBorderWithHeight(array($no, $dbConn->f("bulan_wp"), 'Rp. ' . number_format($dbConn->f("total_amount"), 2, ',', '.'), $dbConn->f("jumlah_wp"), '', ''), array('LB', 'LB', 'LB', 'LB', 'LB', 'LBR'), 6);
        $jumlah += $dbConn->f("total_amount");
        $jumlah_wp += $dbConn->f("jumlah_wp");
        $no++;
    }
    $pdf->SetAligns(array('C', 'R', 'R', 'R', 'R', 'L'));
    $pdf->SetWidths(array(50, 40, 33, 37, 40));
    $pdf->RowMultiBorderWithHeight(array('Jumlah', 'Rp. ' . number_format($jumlah, 2, ',', '.'), $jumlah_wp, '', ''), array('LB', 'LB', 'LB', 'LB', 'LBR'), 6);
    $pdf->SetWidths(array(123, 50));
    $pdf->SetAligns('L');
    $pdf->ln(5);
    $pdf->SetWidtHs(array(130, 70));
    $pdf->SetAligns(array("C", "C", "C", "C", "C"));
    //$pdf->RowMultiBorderWithHeight(array("","KEPALA SEKSI VERIFIKASI OTORISASI DAN PEMBUKUAN\n\n\n\n\n(Drs. H. UGAS RAHMANSYAH, SAP, MAP)\n(NIP 19640127 199703 1001)"),array("",""),5);
    $pdf->RowMultiBorderWithHeight(array("", "KEPALA SEKSI VERIFIKASI OTORISASI DAN PEMBUKUAN\n\n\n\n\n(Drs. H. Deden Saepulloh, MM.)\n(NIP 19681210 199010 001)"), array("", ""), 5);
    $pdf->Output("", "I");
    echo 'tes';
    exit;
}
Exemplo n.º 20
0
 /**
  * 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');
 }
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;
}
Exemplo n.º 22
0
    echo 'location.href="../trans/t_survey_kepuasan_pelanggan_pelaporan_pertanyaan.php?payment_key="+"' . $no_bayar . '";';
    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);
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;
}
Exemplo n.º 24
0
        $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 = new PDF_MC_Table();
$pdf->Open();
$pdf->AddPage();
//$pdf->Image($picture,20,5,20,20);
$pdf->SetFont("Arial", "B", "16");
$pdf->Cell(0, 10, "Broadcast System & Maintenance", 0, 1, "C");
$pdf->SetFont("Arial", "", "12");
$pdf->Cell(0, 10, "Technical Operation Division", 0, 1, "C");
$pdf->SetFont("Arial", "", "14");
$pdf->SetXY(10, 40);
$pdf->Cell(0, 10, "Date: ", 0, 1);
$pdf->SetFont("Arial", "B", "14");
$pdf->SetXY(25, 40);
$pdf->Cell(0, 10, $report_date, 0, 1);
$pdf->SetFont("Arial", "", "14");
$pdf->SetXY(10, 60);
$pdf->Cell(0, 10, "Location: ", 0, 1);
$pdf->SetFont("Arial", "U", "14");
$pdf->SetXY(40, 60);
$pdf->Cell(0, 10, "    " . $report_location . "    ", 0, 1);
Exemplo n.º 25
0
    $data = array('npwpd' => $dbConn->f("npwpd"), 'company_name' => $dbConn->f("company_owner"), 'company_brand' => $dbConn->f("company_brand"), 'brand_address_name' => $dbConn->f("brand_address_name") . ' ' . $dbConn->f("brand_address_no"), 'registration_date' => $dbConn->f("registration_date_2"), 'vat_code' => $dbConn->f("vat_code"));
    $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');
Exemplo n.º 26
0
<?php

require "database.php";
require_once "mc_table.php";
require_once "linegraph.php";
require_once "diagram.php";
require_once "/fpdf/fpdf.php";
//$picture = "D://xampp//htdocs//BroadcastSystem//images//abs_cbn logo.png";
$pdf = new PDF_MC_Table();
$pdf->Open();
$pdf->AddPage('L');
//$pdf->Image($picture,20,5,20,20);
$pdf->SetFont("Arial", "B", "16");
$pdf->Cell(0, 10, "Broadcast System & Maintenance", 0, 1, "C");
$pdf->SetFont("Arial", "", "12");
$pdf->Cell(0, 10, "Technical Operation Division", 0, 1, "C");
$pdf->SetFont("Arial", "B", "14");
$pdf->SetXY(10, 35);
$pdf->SetTextColor(255, 255, 255);
$pdf->SetFillColor(64, 64, 64);
$pdf->Cell(0, 10, "List of All Reports", 0, 1, "C", 1);
$pdf->SetTextColor(0, 0, 0);
$pdf->SetFont("Arial", "B", "12");
$pdf->SetXY(10, 50);
$pdf->Write(5, "Rep#");
$pdf->SetXY(30, 50);
$pdf->Write(5, "Date");
$pdf->SetXY(50, 50);
$pdf->Write(5, "Location");
$pdf->SetXY(75, 50);
$pdf->Write(5, "Machine");
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;
}
Exemplo n.º 28
0
 $unidad = $unidad[0];
 $pdf->AddPage('L', 'A4');
 // CABECERA DEL DOCUMENTO
 // Obtenemos la fecha inicial y final de la semana en curso
 list($anio, $mes, $dia, $semana, $sdia) = explode(':', date('Y:m:d:W:w'));
 $inicio = strtotime("{$anio}-{$mes}-{$dia} 12:00am");
 $inicio += (1 - $sdia) * 86400;
 $fin = $inicio + 6 * 86400;
 $inicio = date('d-m-Y', $inicio);
 $fin = date('d-m-Y', $fin);
 // Consultamos el tutor del grupo
 $result = mysqli_query($db_con, "SELECT TUTOR FROM FTUTORES WHERE unidad='{$unidad}'");
 $tutor = mysqli_fetch_array($result);
 mysqli_free_result($result);
 // Impresi�n de la cabecera
 $pdf->SetFont('NewsGotT', 'B', 10);
 $pdf->Cell(96, 5, "PARTE DE FALTAS DEL GRUPO {$unidad}", 0, 0, 'L');
 $pdf->Cell(81, 5, "SEMANA: _______________________", 0, 0, 'C');
 $pdf->Cell(96, 5, "TUTOR/A: {$tutor['0']}", 0, 1, 'R');
 $pdf->Ln(1);
 $pdf->SetLineWidth(0.6);
 // Grosor de linea
 for ($i = 0; $i < 6; $i++) {
     $pdf->Line(74 + 42 * $i, 16.2, 74 + 42 * $i, 16 + 10);
 }
 $pdf->SetLineWidth(0.2);
 // Grosor por defecto
 // PRIMERA FILA
 $pdf->SetFont('NewsGotT', 'B', 10);
 $pdf->SetWidths(array(63, 42, 42, 42, 42, 42));
 $pdf->SetAligns(array('L', 'C', 'C', 'C', 'C', 'C'));
Exemplo n.º 29
0
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("&nbsp;", " ", $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"');
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;
}