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'); }