</tr> <tr> <td width="20%">Lokasi</td> <td><?php echo show_lokasi($hsl_data->Lokasi_ID);?></td> </tr> <tr> <td width="20%">Nama/Jenis Barang</td> <td><?php echo show_kelompok($hsl_data->Kelompok_ID);?></td> </tr> <tr> <td width="20%">Spesifikasi</td> <td><?php echo $hsl_data->Merk;?></td> </tr> <tr> <td>No Rekening</td> <td>[<?php echo show_koderekening($hsl_data->KodeRekening);?>]-<?php echo show_namarekening($hsl_data->KodeRekening);?></td> </tr> <tr> <td>Jumlah Barang Berdasarkan RKB</td> <td><?php echo $hsl_data->Kuantitas;?></td> </tr> <tr> <td>Harga Pemeliharaan</td> <td> <?php $query_shpb = "SELECT Pemeliharaan FROM StandarHarga WHERE Kelompok_ID=".$hsl_data->Kelompok_ID." AND Spesifikasi='".$hsl_data->Merk."' "; $result = mysql_query($query_shpb); if($result){ $hasil = mysql_fetch_array($result); echo number_format($hasil['Pemeliharaan'],2,',','.');
public function retrieve_html_dkpbmd($dataArr,$gambar){ if($dataArr!="") { include ('../../../function/tanggal/tanggal.php'); $head = " <html> <head> <style> table { font-size:10pt; font-family:Arial; border-collapse: collapse; border-spacing:0; } h3 { font-family:Arial; font-size:13pt; color:#000; } p { font-size:10pt; font-family:Arial; font-weight:bold; } </style> </head> "; /*foreach ($dataArr['data_pejabat'] as $value) { foreach ($value as $data) { //echo $data->NamaJabatan.'<br>'; //echo $data->NamaPejabat; } }*/ $no=1; $skpdeh=""; $barangTotal=0; $biayaTotal=0; foreach ($dataArr as $row) { if ($skpdeh =="" && $no==1){ $body=""; $skpdeh = $row->NamaSatker; $satker_id=$row->Satker_ID; list($nip_kepala_daerah,$nama_jabatan_kepala_daerah)=$this->get_jabatan($satker_id,"5"); list($nip_pengelola_bmd,$nama_jabatan_pengelola_bmd)=$this->get_jabatan($satker_id,"6"); if($nip_kepala_daerah!="") { $nip_kepala_daerah_fix=$nip_kepala_daerah; } else { $nip_kepala_daerah_fix='........................................'; } if($nip_pengelola_bmd!="") { $nip_pengelola_bmd_fix=$nip_pengelola_bmd; } else { $nip_pengelola_bmd_fix='........................................'; } if($nama_jabatan_kepala_daerah!="") { $nama_jabatan_kepala_daerah_fix=$nama_jabatan_kepala_daerah; } else { $nama_jabatan_kepala_daerah_fix='........................................'; } if($nama_jabatan_pengelola_bmd!="") { $nama_jabatan_pengelola_bmd_fix=$nama_jabatan_pengelola_bmd; } else { $nama_jabatan_pengelola_bmd_fix='........................................'; } $body=" <body> <table style=\"text-align: left; width: 100%;\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"> <tr> <td style=\"width: 10%;\"><img style=\"width: 80px; height: 85px;\" alt=\"\" src=\"$gambar\"></td> <td style=\"width: 90%; text-align: center;\"> <h3>DAFTAR KEBUTUHAN PEMELIHARAAN BARANG MILIK DAERAH (DKPBMD)</h3> <h3>TAHUN ANGGARAN $f_tahun</h3> </td> </tr> </table> <br /> <br /> <table border=\"0\" width=\"100%\" > <tr> <td style=\"font-weight: bold; width=15%\"> <p>UNIT</p> </td> <td width=\"65%\"> <p>: $row->NamaSatker </p> </td> <td width=\"20%\"> </td> </tr> <tr align=\"left\"> <td > <p>KABUPATEN/KOTA</p> </td> <td width=\"65%\"> <p>: $this->NAMA_KABUPATEN</p> </td> <td width=\"20%\"> </td> </tr> <tr align=\"left\"> <td > <p>PROVINSI</p> </td> <td width=\"65%\"> <p>: $this->NAMA_PROVINSI</p> </td> <td width=\"20%\"> </td> </tr> </table> <br /> <br /> <table style=\"text-align: left; border-collapse: collapse; margin-left: auto; margin-right: auto; width: 100%;\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\"> <thead> <tr> <td style=\"font-weight: bold; text-align: center; width: 30px\">No<br></td> <td style=\"font-weight: bold; text-align: center; width: 150px\">Nama / Jenis Barang</td> <td style=\"font-weight: bold; text-align: center; width: 100px\">Kode Barang</td> <td style=\"font-weight: bold; text-align: center; width: 180px\">Uraian / Pemeliharaan </td> <td style=\"font-weight: bold; text-align: center;\">Jumlah Barang</td> <td style=\"font-weight: bold; text-align: center;\">Harga Satuan (Rp)</td> <td style=\"font-weight: bold; text-align: center;\">Jumlah Biaya (Rp)</td> <td style=\"font-weight: bold; text-align: center;\">Kode Rekening</td> <td style=\"font-weight: bold; text-align: center;\">Keterangan</td> </tr> <tr> <td style=\"font-weight: bold; text-align: center; width: 30px\">1</td> <td style=\"font-weight: bold; text-align: center; width: 150px\">2</td> <td style=\"font-weight: bold; text-align: center; width: 100px\">3</td> <td style=\"font-weight: bold; text-align: center; width: 5%\">4</td> <td style=\"font-weight: bold; text-align: center;\">5</td> <td style=\"font-weight: bold; text-align: center;\">6</td> <td style=\"font-weight: bold; text-align: center;\">7</td> <td style=\"font-weight: bold; text-align: center;\">8</td> <td style=\"font-weight: bold; text-align: center;\">9</td> </tr> </thead>"; } //uda dites footer disini if ($skpdeh != $row->NamaSatker && $no>1){ $printbarang = number_format($barangTotal); $printbiaya = number_format($biayaTotal); $tabletotal= "<tr > <td style =\"text-align: center;\"colspan=\"4\" >Total</td> <td style =\"text-align: center;\">$printbarang</td> <td> </td> <td style =\"text-align: right;\">$printbiaya</td> <td colspan=\"2\"></td> </tr> </table>"; $foot="<table border=\"0\"> <tr> <td colspan=\"8\"> </td> </tr> </table>"; $footer =" <table style=\"text-align: left; border-collapse: collapse; width: 1024px; height: 90px;\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"> <tr> <td style=\"text-align: center;\" colspan=\"3\" width=\"400px\">Mengetahui</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td style=\"text-align: center;\" colspan=\"3\" width=\"400px\">$f_tanggal $f_bulan $f_tahun</td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">Kepala Daerah</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td style=\"text-align: center;\" colspan=\"3\">Pengelola BMD</td> </tr> <tr> <td colspan=\"11\" style=\"height: 80px\"></td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">$nama_jabatan_kepala_daerah_fix</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td style=\"text-align: center;\" colspan=\"3\">$nama_jabatan_pengelola_bmd_fix</td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">______________________________</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td style=\"text-align: center;\" colspan=\"3\">______________________________</td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">NIP. $nip_kepala_daerah_fix</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td style=\"text-align: center;\" colspan=\"3\">NIP. $nip_pengelola_bmd_fix</td> </tr> </table>"; $footer= $this->set_footer_to_png($this->path, $this->url_rewrite, $footer); $akhir_footer=" </body> </html>"; //udah dites footer $barangTotal=0; $biayaTotal=0; $no=1; if($status_print==0) $html[]=$head.$body.$tabletotal.$foot.$footer; else $html[]=$body.$tabletotal.$foot.$footer; $skpdeh = $row->NamaSatker; $satker_id=$row->Satker_ID; list($nip_kepala_daerah,$nama_jabatan_kepala_daerah)=$this->get_jabatan($satker_id,"5"); list($nip_pengelola_bmd,$nama_jabatan_pengelola_bmd)=$this->get_jabatan($satker_id,"6"); $body=""; $body.=" <body> <table style=\"text-align: left; width: 100%;\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"> <tr> <td style=\"width: 10%;\"><img style=\"width: 80px; height: 85px;\" alt=\"\" src=\"$gambar\"></td> <td style=\"width: 90%; text-align: center;\"> <h3>DAFTAR KEBUTUHAN PEMELIHARAAN BARANG MILIK DAERAH (DKPBMD)</h3> <h3>TAHUN ANGGARAN $f_tahun</h3> </td> </tr> </table> <br /> <br /> <table border=\"0\" width=\"100%\" > <tr> <td style=\"font-weight: bold; width=15%\"> <p>UNIT</p> </td> <td width=\"65%\"> <p>: $row->NamaSatker </p> </td> <td width=\"20%\"> </td> </tr> <tr align=\"left\"> <td > <p>KABUPATEN/KOTA</p> </td> <td width=\"65%\"> <p>: $this->NAMA_KABUPATEN</p> </td> <td width=\"20%\"> </td> </tr> <tr align=\"left\"> <td > <p>PROVINSI</p> </td> <td width=\"65%\"> <p>: $this->NAMA_PROVINSI</p> </td> <td width=\"20%\"> </td> </tr> </table> <br /> <br /> <table style=\"text-align: left; border-collapse: collapse; margin-left: auto; margin-right: auto; width: 100%;\" border=\"1\" cellpadding=\"0\" cellspacing=\"0\"> <thead> <tr> <td style=\"font-weight: bold; text-align: center; width: 30px\">No<br></td> <td style=\"font-weight: bold; text-align: center; width: 150px\">Nama / Jenis Barang</td> <td style=\"font-weight: bold; text-align: center; width: 100px\">Kode Barang</td> <td style=\"font-weight: bold; text-align: center; width: 180px\">Uraian / Pemeliharaan </td> <td style=\"font-weight: bold; text-align: center;\">Jumlah Barang</td> <td style=\"font-weight: bold; text-align: center;\">Harga Satuan (Rp)</td> <td style=\"font-weight: bold; text-align: center;\">Jumlah Biaya (Rp)</td> <td style=\"font-weight: bold; text-align: center;\">Kode Rekening</td> <td style=\"font-weight: bold; text-align: center;\">Keterangan</td> </tr> <tr> <td style=\"font-weight: bold; text-align: center; width: 30px\">1</td> <td style=\"font-weight: bold; text-align: center; width: 150px\">2</td> <td style=\"font-weight: bold; text-align: center; width: 100px\">3</td> <td style=\"font-weight: bold; text-align: center;width: 5%\">4</td> <td style=\"font-weight: bold; text-align: center;\">5</td> <td style=\"font-weight: bold; text-align: center;\">6</td> <td style=\"font-weight: bold; text-align: center;\">7</td> <td style=\"font-weight: bold; text-align: center;\">8</td> <td style=\"font-weight: bold; text-align: center;\">9</td> </tr> </thead>"; //udah dites disini footer $skpdeh = $row->NamaSatker; $status_print++; } //udah dites //var untuk jumlah barang $barang = number_format($row->Kuantitas); $barangTotal = $barangTotal + $row->Kuantitas; //var untuk harga //$hargaSatuan = number_format($row->NilaiStandar); $hargaSatuan = $row->Pemeliharaan; $harga=number_format($hargaSatuan); //var untuk jumlah $jmlbiaya = $hargaSatuan * $barang; $jmlbiaya_1 = number_format($jmlbiaya); $biayaTotal = $biayaTotal + $jmlbiaya; ($row->Uraian == '') ? $datanamabarang = "-" : $datanamabarang = $row->Uraian; ($row->UraianPemeliharaan == '') ? $datapemeliharaan = "-" : $datapemeliharaan = $row->UraianPemeliharaan; ($row->NamaLokasi == '') ? $datanamalokasi = "-" : $datanamalokasi = $row->NamaLokasi; ($row->Kode == '') ? $datakode = "-" : $datakode = $row->Kode; ($row->Kuantitas == '') ? $datakuantitas = "-" : $datakuantitas = $row->Kuantitas; ($row->KodeRekening == '') ? $datakoderekening = "-" : $datakoderekening = $row->KodeRekening; ($row->KeteranganPerencanaan == '') ? $dataketerangan = "-" : $dataketerangan = $row->KeteranganPerencanaan; $body.=" <tr> <td style=\"width: 30px; text-align: center;\">$no</td> <td style=\"width: 150px; text-align: left;\">$datanamabarang</td> <td style=\"text-align: center; width: 100px\">$datakode</td> <td style=\"text-align: left;\">$datapemeliharaan</td> <td style=\"width: 70px; text-align: center;\">$datakuantitas</td> <td style=\"width: 92px; text-align: right;\">$hargaSatuan</td> <td style=\"width: 119px; text-align: right;\">$jmlbiaya_1</td> <td style=\"width: 75px; text-align: center;\">".show_koderekening($datakoderekening)."</td> <td style=\"width: 75px; text-align: left;\">$dataketerangan</td> </tr> "; $no++; } //udah dicoba ga muncul $printbarang = number_format($barangTotal); $printbiaya = number_format($biayaTotal); $tabletotal= "<tr> <td style =\"text-align: center;\"colspan=\"4\" >Total</td> <td style =\"text-align: center;\">$printbarang</td> <td> </td> <td style =\"text-align: right;\">$printbiaya</td> <td colspan=\"2\"></td> </tr> </table>"; $foot="<table border=\"0\"> <tr> <td colspan=\"8\"> </td> </tr> </table>"; $footer =" <table style=\"text-align: left; border-collapse: collapse; width: 1024px; height: 90px;\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"> <tr> <td style=\"text-align: center;\" colspan=\"3\" width=\"400px\">Mengetahui</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td style=\"text-align: center;\" colspan=\"3\" width=\"400px\">$f_tanggal $f_bulan $f_tahun</td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">Kepala Daerah</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td style=\"text-align: center;\" colspan=\"3\">Pengelola BMD</td> </tr> <tr> <td colspan=\"11\" style=\"height: 80px\"></td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">$nama_jabatan_kepala_daerah_fix</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td style=\"text-align: center;\" colspan=\"3\">$nama_jabatan_pengelola_bmd_fix</td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">______________________________</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td style=\"text-align: center;\" colspan=\"3\">______________________________</td> </tr> <tr> <td style=\"text-align: center;\" colspan=\"3\">NIP. $nip_kepala_daerah_fix</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td style=\"text-align: center;\" colspan=\"3\">NIP. $nip_pengelola_bmd_fix</td> </tr> </table>"; $footer= $this->set_footer_to_png($this->path, $this->url_rewrite, $footer); $akhir_footer=" </body> </html>"; if($status_print==0){ $html[]=$head.$body.$tabletotal.$foot.$footer; }else{ $html[]=$body.$tabletotal.$foot.$footer; } $html[]=$akhir_footer; return $html; } }