</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;
}
}
