$this->SetFont('Arial', 'B', 11); $this->Cell(0, 0.5, 'INVENTARIS', 0, 0, 'C'); $this->Ln(); $this->Ln(); $this->Ln(); $this->Ln(); $this->Ln(); $this->Ln(); $this->Ln(); $this->SetFont('Arial', '', 9); $this->Cell(0, 0.5, 'INDONESIA POWER', 0, 0, 'C'); } } $pdf = new PDF('L', 'mm', 'A4'); $pdf->Open(); $pdf->text(10, 25, 'LAPORAN DATA BARANG'); $pdf->AddPage(); $pdf->SetFont('Arial', 'B', 12); $yi = 30; $ya = 24; $pdf->setFont('Arial', '', 9); $pdf->setFillColor(222, 222, 222); $pdf->setXY(10, $ya); $pdf->Cell(8, 5, 'NO', 1, 0, 'C', 1); $pdf->Cell(15, 5, 'Kode', 1, 0, 'C', 1); $pdf->Cell(30, 5, 'No Extracom', 1, 0, 'C', 1); $pdf->Cell(20, 5, 'Header', 1, 0, 'C', 1); $pdf->Cell(20, 5, 'NO Urut', 1, 0, 'C', 1); $pdf->Cell(40, 5, 'Nama Barang', 1, 0, 'C', 1); $pdf->Cell(10, 5, 'Merk', 1, 0, 'C', 1); $pdf->Cell(15, 5, 'Jumlah', 1, 0, 'C', 1);
$Ausencia = pg_result($consulta, $i, 'sal_aus'); $Permiso = pg_result($consulta, $i, 'sal_pyt'); $Judicial = pg_result($consulta, $i, 'sal_jud'); $ASO = pg_result($consulta, $i, 'sal_aso'); $Reposo = pg_result($consulta, $i, 'sal_rep'); $TotalDes = pg_result($consulta, $i, 'total_descuentos'); $Odescuentos = pg_result($consulta, $i, 'ode_mon'); $Neto = pg_result($consulta, $i, 'sal_neto'); //******************************************************************************** $pdf = new PDF(); $pdf->AddPage('P', 'recibo'); $pdf->AliasNbPages(); $pdf->SetFont('Arial', '', 10); $pdf->Cell(0, 0, 'Fecha:', 0, 0, 'L', false); //Fecha $pdf->text(23, 36, $fecha); $pdf->Ln(4); $pdf->Cell(0, 0, 'Nombre Funcionario:', 0, 0, 'L', false); //Nombre de Funcionario $pdf->text(45, 40, $funcionario); $pdf->text(147, 40, 'Ficha:'); $pdf->text(158, 40, $ficha); $pdf->Ln(4); $pdf->Cell(0, 0, 'C.I.:', 0, 0, 'L', false); //numero de cedula de identidad $pdf->text(19, 44, $CI); $pdf->Ln(4); $pdf->Cell(0, 0, utf8_decode('Descripción:'), 0, 0, 'L', false); //descripcion..este campo no se usa $pdf->Ln(4); $pdf->Cell(0, 0, utf8_decode('Liquidacion y Pagos por: SUELDOS'), 0, 0, 'L', false);
public function actionDownload() { parent::actionDownload(); $pdf = new PDF(); $pdf->title = 'Employee Informal List'; $pdf->AddPage('P'); $sql1 = "select splettername, description, validperiod\r\n from splettertype a"; $pdf->setFont('Arial', 'B', 8); $connection = Yii::app()->db; $command1 = $connection->createCommand($sql1); $dataReader1 = $command1->queryAll(); $pdf->text(10, 40, 'Course / Trainig / skill List'); $pdf->SetY(45); $pdf->setaligns(array('C', 'C', 'C')); $pdf->setwidths(array(50, 40, 30)); $pdf->Row(array('SP Letter Name', 'Description', 'Period')); $pdf->setaligns(array('L', 'L', 'L')); foreach ($dataReader1 as $row1) { $pdf->row(array($row1['splettername'], $row1['description'], $row1['validperiod'])); } // me-render ke browser $pdf->Output('splettertype.pdf', 'D'); }
<td align=\'left\'>' . $value_urusan->kd_urusan . '</td> <td align=\'left\' colspan=26>' . $value_urusan->nm_urusan . '</td> </tr>'; $query_bidang = DB::query("SELECT\n a.tahun,\n bidang.kd_bidang,\n bidang.nm_bidang\n FROM\n tabel_dpa AS a\n INNER JOIN bidang ON bidang.kd_urusan = a.kd_urusan AND bidang.kd_bidang = a.kd_bidang\n WHERE\n CONCAT(a.kd_unit,kd_sub_unit) = {$req->skpd} AND\n a.tahun = {$req->tahun} AND \n a.kd_urusan = {$value_urusan->kd_urusan} AND\n a.kd_program > 14\n GROUP BY a.kd_urusan,a.kd_bidang"); $result_bidang = $query_bidang->fetchAll(); foreach ($result_bidang as $value_bidang) { $htmlTemplate .= '<tr> <td align=\'center\'></td> <td align=\'left\'>' . $value_urusan->kd_urusan . '.' . $value_bidang->kd_bidang . '</td> <td align=\'left\' colspan=26>' . $value_bidang->nm_bidang . '</td> </tr>'; } } /** * */ require_once 'library/lib/fpdf.inc.php'; require_once 'library/lib/pdftable.inc.php'; require_once 'library/lib/pdf.inc.php'; require_once 'library/lib/color.inc.php'; require_once 'library/lib/htmlparser.inc.php'; $p = new PDF(); $p->SetMargins(20, 10, 10); $p->AddPage(); $p->setStyle('small'); $p->text(0, 'Formulir Evaluasi Hasil Renja SKPD', 0, 'C'); $p->text(0, 'SKPD ' . Suggest::getSatker($req->skpd), 0, 'C'); $p->text(0, 'Periode Kegiatan Tahun ' . $req->tahun, 0, 'C'); $p->SetFont('helvetica', '', '5'); $p->htmltable($htmlTemplate); $p->output(NAMA_LAPORAN, 'F');
<?php require_once 'lib/pdf.inc.php'; $p = new PDF(); $p->SetMargins(15, 15, 15); $p->AddPage('L'); $p->setStyle('title'); $p->text(0, 'BAÛNG KEÂ HOÙA ÑÔN, CHÖÙNG TÖØ HAØNG HOÙA, DÒCH VUÏ MUAVAØO', 0, 'C'); $p->setfont('vni_times', '', 10); $p->text(0, "(Keøm theo tôø khai thueá GTGT)\n(Duøng cho cô sôû tính thueá GTGT theo phöông phaùp khaáu tröø thueá keá khai haøng thaùng)\nThaùng {$this->month} naêm {$this->year}", 0, 'C'); $html = "\n<table width={$p->width}>\n<tr><td width=18>Teân ñôn vò<td width=180>: " . VNCode::UTF8VNI(getinfo(ADR_NAME)) . "<td width=13>Maãu soá<td>: " . ($this->hdvao ? '03' : '02') . "/GTGT\n<tr><td>Ñòa chæ<td>: " . VNCode::UTF8VNI(getinfo(ADR_ADDRESS)) . "<td>Maõ soá<td>: " . getinfo(ADR_CODE) . "\n<tr><td>Ñieän thoaïi<td>: " . getinfo(ADR_TELL) . "\n"; $p->htmltable($html); $p->Ln(3); $vr1 = $this->hdvao ? 'mua' : 'baùn'; $vr2 = $this->hdvao ? 'baùn' : 'mua'; $html = ' <table width=' . $p->width . ' align=center> <tr bgcolor=#eeeeee repeat=1> <td align=center border=1111 rowspan=2 width=1>S<br>T<br>T <td align=center border=1110 colspan=3>Hoùa ñôn chöùng töø ' . $vr1 . ' <td align=center border=1110 rowspan=2 width=50>Teân ngöôøi ' . $vr2 . ' <td align=center border=1110 rowspan=2>Maõ soá thueá <td align=center border=1110 rowspan=2 width=50>Maët haøng <td align=center border=1110 rowspan=2>Doanh soá ' . $vr1 . ' chöa coù thueá <td align=center border=1110 rowspan=2 nowrap>Thueá<br>suaát <td align=center border=1110 rowspan=2>Thueá GTGT <td align=center border=1110 rowspan=2 width=10>Ghi chuù <tr bgcolor=#eeeeee repeat=1> <td align=center border=0110>Kyù hieäu <td align=center border=0110>Soá hoùa ñôn <td align=center border=0110>Ngaøy phaùt haønh
//Position at 1.5 cm from bottom $this->SetY(-15); //Arial italic 8 $this->SetFont('Arial', 'I', 8); //Page number $this->Cell(0, 10, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C'); } } $tgl = date('d - m - Y'); $pdf = new PDF(); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetFont('Times', '', 12); //$pdf->text(90,30,'PT. NYALINDUNG'); $tahun = $_GET['tahun']; $pdf->text(55, 36, 'LAPORAN ANGGOTA KOPERASI PT. MEDAN JAYA ' . $tahun); $yi = 50; $ya = 44; $pdf->setFont('Arial', '', 6); $pdf->setFillColor(222, 222, 222); $pdf->setXY(35, $ya); $pdf->CELL(20, 5, 'NO ANGGOTA', 1, 0, 'C', 1); $pdf->CELL(20, 5, 'NAMA', 1, 0, 'C', 1); $pdf->CELL(25, 5, 'NO KTP', 1, 0, 'C', 1); $pdf->CELL(30, 5, 'ALAMAT', 1, 0, 'C', 1); $pdf->CELL(15, 5, 'KOTA', 1, 0, 'C', 1); $pdf->CELL(15, 5, 'AKTIVASI', 1, 0, 'C', 1); $ya = $yi + $row; include "../config/koneksi.php"; $tahun = $_GET['tahun']; $sql = mysql_query("select * from mst_anggota where status_pegawai = 0") or die("salah sql");
//Position at 1.5 cm from bottom $this->SetY(-15); //Arial italic 8 $this->SetFont('Arial', 'I', 8); //Page number $this->Cell(0, 10, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C'); } } $tgl = date('d - m - Y'); $pdf = new PDF(); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetFont('Times', '', 12); //$pdf->text(90,30,'PT. NYALINDUNG'); $tahun = $_GET['tahun']; $pdf->text(55, 36, 'LAPORAN ANGGOTA KREDIT KOPERASI MITRA SETIA ' . $tahun); $yi = 50; $ya = 44; $pdf->setFont('Arial', '', 6); $pdf->setFillColor(222, 222, 222); $pdf->setXY(35, $ya); $pdf->CELL(20, 5, 'NIP', 1, 0, 'C', 1); $pdf->CELL(20, 5, 'NO ANGGOTA', 1, 0, 'C', 1); $pdf->CELL(20, 5, 'NAMA', 1, 0, 'C', 1); $pdf->CELL(25, 5, 'NO KTP', 1, 0, 'C', 1); $pdf->CELL(30, 5, 'ALAMAT', 1, 0, 'C', 1); $pdf->CELL(15, 5, 'JABATAN', 1, 0, 'C', 1); $pdf->CELL(15, 5, 'GOLONGAN', 1, 0, 'C', 1); $ya = $yi + $row; include "../config/koneksi.php"; $tahun = $_GET['tahun'];
public function actionDownload() { parent::actionDownload(); $pdf = new PDF(); $pdf->title = 'Form Permintaan (Barang/Jasa)'; $pdf->AddPage('P'); $pdf->setFont('Arial', 'B', 12); // definisi font $pdf->setFont('Arial', 'B', 8); // menuliskan tabel $connection = Yii::app()->db; $sql = "select a.dano,a.dadate,a.headernote,a.deliveryadviceid\n from deliveryadvice a\n where deliveryadviceid = " . $_GET['id']; $command = $connection->createCommand($sql); $dataReader = $command->queryAll(); foreach ($dataReader as $row) { $pdf->setFont('Arial', 'B', 8); $pdf->text(10, 30, 'No '); $pdf->text(50, 30, ': ' . $row['dano']); $pdf->text(10, 35, 'Date '); $pdf->text(50, 35, ': ' . $row['dadate']); $pdf->text(10, 40, 'Note '); $pdf->text(50, 40, ': ' . $row['headernote']); $sql1 = "select b.productname, a.qty, c.uomcode, a.itemtext\n from deliveryadvicedetail a\n left join product b on b.productid = a.productid\n left join unitofmeasure c on c.unitofmeasureid = a.unitofmeasureid\n where deliveryadviceid = " . $row['deliveryadviceid']; $command1 = $connection->createCommand($sql1); $dataReader1 = $command1->queryAll(); $pdf->text(10, 50, 'Items'); $pdf->SetY(55); $pdf->setFont('Arial', 'B', 6); $pdf->setaligns(array('C', 'C', 'C', 'C', 'C')); $pdf->setwidths(array(10, 90, 25, 25, 40)); $pdf->setFont('Arial', '', 6); $pdf->Row(array('No', 'Items', 'Qty', 'Unit', 'Remark')); $pdf->setaligns(array('L', 'L', 'L', 'L', 'L')); $i = 0; foreach ($dataReader1 as $row1) { $i = $i + 1; $pdf->row(array($i, $row1['productname'], Yii::app()->numberFormatter->format(Yii::app()->params["defaultnumberqty"], $row1['qty']), $row1['uomcode'], $row1['itemtext'])); } $pdf->text(100, $pdf->gety() + 5, 'Jakarta, ' . $row['dadate']); $pdf->text(10, $pdf->gety() + 10, 'Approved By'); $pdf->text(100, $pdf->gety() + 10, 'Proposed By'); $pdf->text(10, $pdf->gety() + 20, '------------ '); $pdf->text(100, $pdf->gety() + 20, '------------'); $pdf->AddPage('P'); } $pdf->Output(); }
//Position at 1.5 cm from bottom $this->SetY(-15); //Arial italic 8 $this->SetFont('Arial', 'I', 8); //Page number $this->Cell(0, 10, 'Page ' . $this->PageNo() . '/{nb}', 0, 0, 'C'); } } $tgl = date('d - m - Y'); $pdf = new PDF(); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetFont('Times', '', 12); //$pdf->text(90,30,'PT. NYALINDUNG'); $tahun = $_GET['tahun']; $pdf->text(55, 36, 'LAPORAN PEMBAYARAN LUNAS KOPERASI MITRA SETIA ' . $tahun); $yi = 50; $ya = 44; $pdf->setFont('Arial', '', 6); $pdf->setFillColor(222, 222, 222); $pdf->setXY(35, $ya); $pdf->CELL(20, 5, 'NIP', 1, 0, 'C', 1); $pdf->CELL(20, 5, 'NO ANGGOTA', 1, 0, 'C', 1); $pdf->CELL(20, 5, 'NAMA', 1, 0, 'C', 1); $pdf->CELL(25, 5, 'NO KTP', 1, 0, 'C', 1); $pdf->CELL(30, 5, 'ALAMAT', 1, 0, 'C', 1); $pdf->CELL(15, 5, 'JABATAN', 1, 0, 'C', 1); $pdf->CELL(15, 5, 'GOLONGAN', 1, 0, 'C', 1); $ya = $yi + $row; include "../config/koneksi.php"; $tahun = $_GET['tahun'];