$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'];
