public function bend29()
{
$id = Input::get('nomor');
if (substr($id, 0, 3) == 'ALO') {
$data = DB::table('pkm_alokasi')->where('nomor', $id)->first();
$dtl = DB::table('pkm_alokasidtl')->join('aset_data', 'pkm_alokasidtl.id_inventori', '=', 'aset_data.id')->where('nomor', $id)->where('tipe', 'aset')->get();
} else {
$data = DB::table('aset_keluar')->where('nomor', $id)->first();
$dtl = DB::table('aset_keluardtl')->join('aset_data', 'aset_keluardtl.id_inventori', '=', 'aset_data.id')->where('nomor', $id)->select('aset_data.*')->get();
}
$ka1 = DB::table('pkm_pegawai')->where('id_unit', $data->id_puskesmas)->where('jabatan', 1)->first();
$ka2 = DB::table('pkm_pegawai')->where('id_unit', $data->id_unit)->where('jabatan', 1)->first();
$pb1 = DB::table('pkm_pegawai')->where('id', Input::get('pihak1'))->first();
$pb2 = DB::table('pkm_pegawai')->where('id', Input::get('pihak2'))->first();
$header = '
<table>
<tr style="font-weight: bold">
<td colspan="7" style="text-align: left"><br><br><br><br><br><br><br><br><br></td>
</tr>
<tr style="font-weight: bold">
<td colspan="4" style="text-align: left">PEMERINTAH KOTA SURABAYA</td>
<td colspan="3" style="text-align: right">BEND. 29</td>
</tr>
<tr style="font-weight: bold">
<td colspan="4" style="text-align: left"> </td>
<td colspan="3" style="text-align: right">NOMOR JURNAL : ' . $id . '</td>
</tr>
<tr style="font-size: large;font-weight: bold">
<td colspan="7" style="text-align: center">BUKTI PENYERAHAN BARANG DARI DAERAH/UNIT: ' . $data->nama_puskesmas . '</td>
</tr>
<tr style="font-size: large;font-weight: bold">
<td colspan="7" style="text-align: center">KEPADA DAERAH:UNIT : ' . $data->nama_unit . '</td>
</tr>
<tr style="font-size: large;font-weight: bold">
<td colspan="7" style="text-align: center">NO BERITA ACARA SERAH TERIMA: 028/ .24/436.6.3/2014</td>
</tr>
<tr style="font-size: large;font-weight: bold">
<td colspan="7" style="text-align: center"> </td>
</tr>
</table>
<table border="1" cellspacing="3">
<thead>
<tr style="font-weight: bold;text-align: center;">
<th rowspan="2" style="width: 10%">NO</th>
<th rowspan="2" style="width: 10%">TANGGAL</th>
<th rowspan="2" style="width: 30%">Nama & Spesifikasi Barang <br> (Merk, Tipe, Kode, Kode Neraca, No Reg Induk)</th>
<th rowspan="2" style="width: 10%">SATUAN</th>
<th colspan="2" style="width: 20%">JUMLAH</th>
<th rowspan="2" style="width: 20%">NILAI (Rp)</th>
</tr>
<tr style="font-weight: bold;text-align: center;">
<th style="width: 10%">ANGKA</th>
<th style="width: 10%">HURUF</th>
</tr>
</thead>
';
$footer = '</table>';
$content = '';
for ($i = 0; $i < count($dtl); $i++) {
$jml = $dtl[$i]->jumlah * $dtl[$i]->h_satuan;
$content .= '
<tr style="text-align: center;">
<td style="width: 10%">' . ($i + 1) . '</td>
<td style="width: 10%">' . $data->tanggal . '</td>
<td style="width: 30%;text-align: left;"> ' . $dtl[$i]->nama . '<br> ' . $dtl[$i]->kode_bidang . '<br> ' . $dtl[$i]->kode_perwali . '<br> ' . $dtl[$i]->no_register . '</td>
<td style="width: 10%">' . $dtl[$i]->satuan . '</td>
<td style="width: 10%">' . $dtl[$i]->jumlah . '</td>
<td style="width: 10%">' . Terbilang::rupiah($dtl[$i]->jumlah) . '</td>
<td style="width: 20%;text-align: right;">' . number_format($jml + $jml * $dtl[$i]->ppn / 100) . '</td>
</tr>
';
}
//$peg1 = DB::table('pkm_pegawai')->where('id_unit', $data->id_unit)->where('jabatan', 2)->first();
if (Auth::user()->id_puskesmas == '0999') {
$tt = '<tr>
<td style="width: 20%"></td>
<td style="width: 60%">
<table cellpadding="5">
<tr><td colspan="3"> </td></tr>
<tr>
<td style="text-align: right">Mengetahui,</td>
<td style="width: 2%"></td>
<td></td>
</tr>
<tr><td colspan="3"> </td></tr>
<tr><td colspan="3"> </td></tr>
<tr><td colspan="3"> </td></tr>
<tr>
<td>Tanda Tangan</td>
<td style="width: 2%">:</td>
<td>............................</td>
</tr>
<tr>
<td>NAMA</td>
<td style="width: 2%">:</td>
<td>NANIK SUKRISTINA, SKM</td>
</tr>
<tr>
<td>NIP</td>
<td style="width: 2%">:</td>
<td>19700117 199403 2 008</td>
</tr>
<tr>
<td>PANGKAT</td>
<td style="width: 2%">:</td>
<td>PEMBINA / IV A</td>
</tr>
</table>
</td>
<td style="width: 20%"></td>
</tr>';
} else {
$tt = '<tr>
<td colspan="3" style="width: 48%">
<table cellpadding="5">
<tr>
<td colspan="3">Mengetahui,</td>
</tr>
<tr>
<td>Tanda Tangan</td>
<td style="width: 2%">:</td>
<td>............................</td>
</tr>
<tr>
<td>NAMA</td>
<td style="width: 2%">:</td>
<td>' . $ka2->nama_pegawai . '</td>
</tr>
<tr>
<td>NIP</td>
<td style="width: 2%">:</td>
<td>' . $ka2->nip . '</td>
</tr>
<tr>
<td>PANGKAT</td>
<td style="width: 2%">:</td>
<td>' . $ka2->pangkat . '</td>
</tr>
</table>
</td>
<td style="width: 5%"> </td>
<td colspan="3" style="width: 47%">
<table cellpadding="5">
<tr>
<td colspan="3">Yang Menyerahkan,</td>
</tr>
<tr>
<td>Tanda Tangan</td>
<td style="width: 2%">:</td>
<td>............................</td>
</tr>
<tr>
<td>NAMA</td>
<td style="width: 2%">:</td>
<td>' . $ka1->nama_pegawai . '</td>
</tr>
<tr>
<td>NIP</td>
<td style="width: 2%">:</td>
<td>' . $ka1->nip . '</td>
</tr>
<tr>
<td>PANGKAT</td>
<td style="width: 2%">:</td>
<td>' . $ka1->pangkat . '</td>
</tr>
</table>
</td>
</tr>';
}
$ttd = '
<table>
<tr><td colspan="7"> </td></tr>
<tr><td colspan="7"> </td></tr>
<tr>
<td colspan="3" style="width: 48%">
<table cellpadding="5">
<tr>
<td>DAERAH</td>
<td style="width: 2%">:</td>
<td style="width: 90%">KOTA SURABAYA</td>
</tr>
<tr>
<td>UNIT</td>
<td style="width: 2%">:</td>
<td>' . $data->nama_puskesmas . '</td>
</tr>
<tr>
<td>TANGGAL</td>
<td style="width: 2%">:</td>
<td>' . date("d/m/Y") . '</td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3">Yang Menerima,</td>
</tr>
<tr>
<td>Tanda Tangan</td>
<td style="width: 2%">:</td>
<td>............................</td>
</tr>
<tr>
<td>NAMA</td>
<td style="width: 2%">:</td>
<td>' . $pb2->nama_pegawai . '</td>
</tr>
<tr>
<td>NIP</td>
<td style="width: 2%">:</td>
<td>' . $pb2->nip . '</td>
</tr>
<tr>
<td>PANGKAT</td>
<td style="width: 2%">:</td>
<td>' . $pb2->pangkat . '</td>
</tr>
</table>
</td>
<td style="width: 5%"> </td>
<td colspan="3" style="width: 47%">
<table cellpadding="5">
<tr>
<td></td><td></td><td></td>
</tr>
<tr>
<td>Dibuat di</td>
<td style="width: 2%">:</td>
<td>SURABAYA</td>
</tr>
<tr>
<td>TANGGAL</td>
<td style="width: 2%">:</td>
<td>' . date("d/m/Y") . '</td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3">Yang Menyerahkan,</td>
</tr>
<tr>
<td>Tanda Tangan</td>
<td style="width: 2%">:</td>
<td>............................</td>
</tr>
<tr>
<td>NAMA</td>
<td style="width: 2%">:</td>
<td>' . $pb1->nama_pegawai . '</td>
</tr>
<tr>
<td>NIP</td>
<td style="width: 2%">:</td>
<td>' . $pb1->nip . '</td>
</tr>
<tr>
<td>PANGKAT</td>
<td style="width: 2%">:</td>
<td>' . $pb1->pangkat . '</td>
</tr>
</table>
</td>
</tr>
' . $tt . '
</table>
';
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor(PDF_AUTHOR);
$pdf->SetTitle('Gudang DKK');
$pdf->SetSubject('Laporan Penerimaan Barang Pengadaan');
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
$pdf->SetMargins(PDF_MARGIN_LEFT, 10, PDF_MARGIN_RIGHT);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
$pdf->SetAutoPageBreak(TRUE, 8);
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// CONTENT-------------------------------------------
$pdf->AddPage('P', 'A4');
/*$pdf->SetFont('helvetica', 'B', 10);
$pdf->Write(0, "PEMERINTAH KOTA SURABAYA", '', 0, 'C', true, 0, false, false, 0);
$pdf->SetFont('helvetica', 'B', 12);
$pdf->Write(0, "DINAS KESEHATAN KOTA SURABAYA", '', 0, 'C', true, 0, false, false, 0);
$pdf->SetFont('helvetica', 'U', 10);
$pdf->Write(0, "JL. JEMURSARI NO 197 Tlp (031)8439473, 8439372, Fax. (031)8494965", '', 0, 'C', true, 0, false, false, 0);
$pdf->SetFont('helvetica', 'B', 10);
$pdf->Write(0, , '', 0, 'C', true, 0, false, false, 0);*/
$pdf->ln();
$pdf->SetFont('helvetica', '', 8);
$pdf->writeHTML($header . $content . $footer . $ttd, true, false, false, false, '');
$pdf->Output('ben29' . date('d-m-Y') . ' . pdf', 'I');
}
