public function retrieve_html_kib_f($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>
";
//$no=1;
$skpdeh="NULL";
$no=1;
$status_print=0;
$luasTotal=0;
$perolehanTotal=0;
foreach ($dataArr as $row)
{
if ($skpdeh == "NULL" && $no==1){
$body="";
$skpdeh = $row->NamaSatker;
$satker_id=$row->LastSatker_ID;
list($nip_pengurus,$nama_jabatan_pengurus)=$this->get_jabatan($satker_id,"3");
list($nip_pengguna,$nama_jabatan_pengguna)=$this->get_jabatan($satker_id,"4");
if($nip_pengurus!="")
{
$nip_pengurus_fix=$nip_pengurus;
}
else
{
$nip_pengurus_fix='........................................';
}
if($nip_pengguna!="")
{
$nip_pengguna_fix=$nip_pengguna;
}
else
{
$nip_pengguna_fix='........................................';
}
if($nama_jabatan_pengguna!="")
{
$nama_jabatan_pengguna_fix=$nama_jabatan_pengguna;
}
else
{
$nama_jabatan_pengguna_fix='........................................';
}
if($nama_jabatan_pengurus!="")
{
$nama_jabatan_pengurus_fix=$nama_jabatan_pengurus;
}
else
{
$nama_jabatan_pengurus_fix='........................................';
}
$body="
<body>
<table style=\"text-align: left; width: 100%;\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
<tr>
<td style=\"width: 10%;\"><img style=\"width: 60px; height: 79px;\" alt=\"\" src=\"$gambar\"></td>
<td style=\"width: 90%; text-align: center;\">
<h3>KARTU INVENTARIS BARANG (KIB) F</h3>
<h3>KONSTRUKSI DALAM PENGERJAAN</h3>
</td>
</tr>
</table>
<br />
<br />
<table border=\"0\" width=\"100%\" >
<tr>
<td style=\"font-weight: bold; width=15%\">
<p>KABUPATEN/KOTA</p>
</td>
<td width=\"65%\">
<p>: $this->NAMA_KABUPATEN ||$skpdeh 99999 $satker_id NIP Pengurus=$nip_pengurus|
NIP Pengguna==$nip_pengguna
|NAMA Penggurus===$nama_jabatan_pengurus|NAMA Pengguna$nama_jabatan_pengguna</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>
<tr align=\"left\">
<td >
<p>NO. KODE LOKASI</p>
</td>
<td width=\"65%\">
<p>: $this->KODE_PROVINSI."."$this->KODE_KABUPATEN."."$row->KodeSatker".""."-"."$row->NamaSatker</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 colspan=\"1\" rowspan=\"2\"style=\"width: 30px;font-weight: bold; text-align: center;\"><br><br>No<br>Urut</td>
<td colspan=\"1\" rowspan=\"2\"style=\"width: 120px;font-weight: bold; text-align: center;\"><br><br>Nama Barang /
<br>
Jenis Barang /<br>
Pekerjaan</td>
<td colspan=\"1\" rowspan=\"2\"style=\"font-weight: bold; text-align: center;\"><br><br>Bangunan<br>
(P,SP,D)</td>
<td colspan=\"2\" rowspan=\"1\"style=\"font-weight: bold; text-align: center;\">Konstruksi</td>
<td colspan=\"1\" rowspan=\"2\"style=\"width: 50px;font-weight: bold; text-align: center;\"><br><br>Luas<br>(m2)</td>
<td colspan=\"1\" rowspan=\"2\"style=\"width: 90px;font-weight: bold; text-align: center;\"><br><br>Letak / Lokasi<br>
Alamat</td>
<td colspan=\"2\" rowspan=\"1\"style=\"font-weight: bold; text-align: center;\">Dokumen Gedung</td>
<td colspan=\"1\" rowspan=\"2\"style=\"font-weight: bold; text-align: center;\"><br><br>Tgl Bulan<br>
Thn Mutasi</td>
<td colspan=\"1\" rowspan=\"2\"style=\"font-weight: bold; text-align: center;\"><br><br>Status <br>
Tanah</td>
<td colspan=\"1\" rowspan=\"2\"style=\"width: 90px;font-weight: bold; text-align: center;\"><br><br>Nomor Kode <br>
Tanah</td>
<td colspan=\"1\" rowspan=\"2\"style=\"font-weight: bold; text-align: center;\"><br><br>Asal Usul<br>
Pembayaran</td>
<td colspan=\"1\" rowspan=\"2\"style=\"font-weight: bold; text-align: center;\"><br><br>Nilai BMD (Rp.)<br>
</td>
<td colspan=\"1\" rowspan=\"2\"style=\"width: 90px;font-weight: bold; text-align: center;\"><br><br>Ket</td>
</tr>
<tr>
<td style=\"font-weight: bold; text-align: center;\">Bertingkat/<br>
Tidak</td>
<td style=\"font-weight: bold; text-align: center;\">Beton/<br>
Tidak</td>
<td style=\"font-weight: bold; text-align: center;\">Tanggal</td>
<td style=\"font-weight: bold; text-align: center;\">Nomor</td>
</tr>
<tr>
<td style=\"text-align: center; font-weight: bold;\">1</td>
<td style=\"text-align: center; font-weight: bold;\">2</td>
<td style=\"text-align: center; font-weight: bold;\">3</td>
<td style=\"text-align: center; font-weight: bold;\">4</td>
<td style=\"text-align: center; font-weight: bold;\">5</td>
<td style=\"text-align: center; font-weight: bold;\">6</td>
<td style=\"text-align: center; font-weight: bold;\">7</td>
<td style=\"text-align: center; font-weight: bold;\">8</td>
<td style=\"text-align: center; font-weight: bold;\">9</td>
<td style=\"text-align: center; font-weight: bold;\">10</td>
<td style=\"text-align: center; font-weight: bold;\">11</td>
<td style=\"text-align: center; font-weight: bold;\">12</td>
<td style=\"text-align: center; font-weight: bold;\">13</td>
<td style=\"text-align: center; font-weight: bold;\">14</td>
<td style=\"text-align: center; font-weight: bold;\">15</td>
</tr>
</thead>";
}
if ($skpdeh != $row->NamaSatker && $no>1){
$printluas= number_format($luasTotal);
$printperolehanTotal= number_format($perolehanTotal);
$tabletotal="
<tr align=\"center\">
<td colspan=\"5\">Total</td>
<td>$printluas</td>
<td colspan=\"7\"></td>
<td>$printperolehanTotal</td>
</tr></table>";
//echo $printluasLantai;
$foot="<table border=\"0\">
<tr>
<td colspan=\"14\"> </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\">Pengguna Barang</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td style=\"text-align: center;\" colspan=\"3\">Pengurus Barang</td>
</tr>
<tr>
<td colspan=\"11\" style=\"height: 80px\"></td>
</tr>
<tr>
<td style=\"text-align: center;\" colspan=\"3\">$nama_jabatan_pengguna_fix</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td style=\"text-align: center;\" colspan=\"3\">$nama_jabatan_pengurus_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_pengguna_fix</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td style=\"text-align: center;\" colspan=\"3\">NIP. $nip_pengurus_fix</td>
</tr>
</table>";
$footer= $this->set_footer_to_png($this->path, $this->url_rewrite, $footer);
$footer.="
</body>
</html>";
//udah dites footer
$jumlahTotal=0;
$perolehanTotal=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->LastSatker_ID;
list($nip_pengurus,$nama_jabatan_pengurus)=$this->get_jabatan($satker_id,"3");
list($nip_pengguna,$nama_jabatan_pengguna)=$this->get_jabatan($satker_id,"4");
$body="";
$body.="
<body>
<table style=\"text-align: left; width: 100%;\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
<tr>
<td style=\"width: 10%;\"><img style=\"width: 60px; height: 79px;\" alt=\"\" src=\"$gambar\"></td>
<td style=\"width: 90%; text-align: center;\">
<h3>KARTU INVENTARIS BARANG (KIB) F</h3>
<h3>KONSTRUKSI DALAM PENGERJAAN</h3>
</td>
</tr>
</table>
<br />
<br />
<table border=\"0\" width=\"100%\" >
<tr>
<td style=\"font-weight: bold; width=15%\">
<p>KABUPATEN/KOTA</p>
</td>
<td width=\"65%\">
<p>: $this->NAMA_KABUPATEN ||$skpdeh 99999 $satker_id NIP Pengurus=$nip_pengurus|
NIP Pengguna==$nip_pengguna
|NAMA Penggurus===$nama_jabatan_pengurus|NAMA Pengguna$nama_jabatan_pengguna</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>
<tr align=\"left\">
<td >
<p>NO. KODE LOKASI</p>
</td>
<td width=\"65%\">
<p>: $this->KODE_PROVINSI."."$this->KODE_KABUPATEN."."$row->KodeSatker".""."-"."$row->NamaSatker</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 colspan=\"1\" rowspan=\"2\"style=\"width: 30px;font-weight: bold; text-align: center;\"><br><br>No<br>Urut</td>
<td colspan=\"1\" rowspan=\"2\"style=\"width: 120px;font-weight: bold; text-align: center;\"><br><br>Nama Barang /
<br>
Jenis Barang /<br>
Pekerjaan</td>
<td colspan=\"1\" rowspan=\"2\"style=\"font-weight: bold; text-align: center;\"><br><br>Bangunan<br>
(P,SP,D)</td>
<td colspan=\"2\" rowspan=\"1\"style=\"font-weight: bold; text-align: center;\">Konstruksi</td>
<td colspan=\"1\" rowspan=\"2\"style=\"width: 50px;font-weight: bold; text-align: center;\"><br><br>Luas<br>(m2)</td>
<td colspan=\"1\" rowspan=\"2\"style=\"width: 90px;font-weight: bold; text-align: center;\"><br><br>Letak / Lokasi<br>
Alamat</td>
<td colspan=\"2\" rowspan=\"1\"style=\"font-weight: bold; text-align: center;\">Dokumen Gedung</td>
<td colspan=\"1\" rowspan=\"2\"style=\"font-weight: bold; text-align: center;\"><br><br>Tgl Bulan<br>
Thn Mutasi</td>
<td colspan=\"1\" rowspan=\"2\"style=\"font-weight: bold; text-align: center;\"><br><br>Status <br>
Tanah</td>
<td colspan=\"1\" rowspan=\"2\"style=\"width: 90px;font-weight: bold; text-align: center;\"><br><br>Nomor Kode <br>
Tanah</td>
<td colspan=\"1\" rowspan=\"2\"style=\"font-weight: bold; text-align: center;\"><br><br>Asal Usul<br>
Pembayaran</td>
<td colspan=\"1\" rowspan=\"2\"style=\"font-weight: bold; text-align: center;\"><br><br>Nilai BMD (Rp.)<br>
</td>
<td colspan=\"1\" rowspan=\"2\"style=\"width: 90px;font-weight: bold; text-align: center;\"><br><br>Ket</td>
</tr>
<tr>
<td style=\"font-weight: bold; text-align: center;\">Bertingkat/<br>
Tidak</td>
<td style=\"font-weight: bold; text-align: center;\">Beton/<br>
Tidak</td>
<td style=\"font-weight: bold; text-align: center;\">Tanggal</td>
<td style=\"font-weight: bold; text-align: center;\">Nomor</td>
</tr>
<tr>
<td style=\"text-align: center; font-weight: bold;\">1</td>
<td style=\"text-align: center; font-weight: bold;\">2</td>
<td style=\"text-align: center; font-weight: bold;\">3</td>
<td style=\"text-align: center; font-weight: bold;\">4</td>
<td style=\"text-align: center; font-weight: bold;\">5</td>
<td style=\"text-align: center; font-weight: bold;\">6</td>
<td style=\"text-align: center; font-weight: bold;\">7</td>
<td style=\"text-align: center; font-weight: bold;\">8</td>
<td style=\"text-align: center; font-weight: bold;\">9</td>
<td style=\"text-align: center; font-weight: bold;\">10</td>
<td style=\"text-align: center; font-weight: bold;\">11</td>
<td style=\"text-align: center; font-weight: bold;\">12</td>
<td style=\"text-align: center; font-weight: bold;\">13</td>
<td style=\"text-align: center; font-weight: bold;\">14</td>
<td style=\"text-align: center; font-weight: bold;\">15</td>
</tr>
</thead>";
//udah dites disini footer
$skpdeh = $row->NamaSatker;
$status_print++;
}
//udah dites
$bertingkat = get_bertingkat_tidak($row->JumlahLantai);
$beton = get_beton_tidak($row->Beton);
$status_tanah = get_status_tanah($row->StatusTanah);
$konstruksi_tanah= get_konstruksi($row->Konstruksi);
$luasTotal = $luasTotal + $row->LuasLantai;
$luas = number_format($row->LuasLantai);
//$panjangTotal = $panjangTotal + $row->Panjang;
$perolehanTotal = $perolehanTotal + $row->NilaiPerolehan;
$perolehan = number_format($row->NilaiPerolehan);
$body.="
<tr align=\"center\">
<td style=\"width: 30px;font-weight: \">$no</td>
<td style=\"width: 120px;font-weight: \">$row->NamaAset</td>
<td style=\"width: 79px;font-weight: \">$konstruksi_tanah</td>
<td style=\"width: 80px;font-weight: \">$bertingkat_tidak</td>
<td style=\"width: 78px; font-weight: \">$beton_tidak</td>
<td style=\"width: 51px; font-weight: \">$luas</td>
<td style=\"width: 90px; font-weight: \">$row->Alamat</td>
<td style=\"width: 79px; font-weight: \">$row->TglSertifikat</td>
<td style=\"width: 80px;font-weight: \">$row->NoSertifikat</td>
<td style=\"width: 78px; font-weight: \"></td>
<td style=\"width: 80px;font-weight: \">$status_tanah</td>
<td style=\"width: 90px; font-weight: \"></td>
<td style=\"width: 79px;font-weight: \">$row->SumberDana</td>
<td style=\"width: 80px;font-weight: \">$perolehan</td>
<td style=\"width: 90px;font-weight: \">$row->Info</td>
</tr>";
$no++;
//coba
}
$printluas= number_format($luasTotal);
$printperolehanTotal= number_format($perolehanTotal);
$tabletotal="
<tr align=\"center\">
<td colspan=\"5\">Total</td>
<td>$printluas</td>
<td colspan=\"7\"></td>
<td>$printperolehanTotal</td>
</tr></table>";
$foot="<table border=\"0\">
<tr>
<td colspan=\"15\"> </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\">Pengguna Barang</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td style=\"text-align: center;\" colspan=\"3\">Pengurus Barang</td>
</tr>
<tr>
<td colspan=\"11\" style=\"height: 80px\"></td>
</tr>
<tr>
<td style=\"text-align: center;\" colspan=\"3\">$nama_jabatan_pengguna_fix</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td style=\"text-align: center;\" colspan=\"3\">$nama_jabatan_pengurus_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_pengguna_fix</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td style=\"text-align: center;\" colspan=\"3\">NIP. $nip_pengurus_fix</td>
</tr>
</table>";
$footer= $this->set_footer_to_png($this->path, $this->url_rewrite, $footer);
$footer.="
</body>
</html>";
if($status_print==0){
$html[]=$head.$body.$tabletotal.$foot.$footer;
}else{
$html[]=$body.$tabletotal.$foot.$footer;
}
return $html;
}
}
";
$skpdeh = $row->NamaSatker;
$status_print++;
}
$luasTotal = $luasTotal + $row->LuasLantai;
//$panjangTotal = $panjangTotal + $row->Panjang;
$perolehanTotal = $perolehanTotal + $row->NilaiPerolehan;
$status_tanah = get_status_tanah($row->StatusTanah);
$perolehan = number_format($row->NilaiPerolehan);
//$panjang = number_format($row->Panjang);
//$lebar = number_format($row->Lebar);
$luas = number_format($row->LuasLantai);
$bertingkat_tidak = get_bertingkat_tidak($row->JumlahLantai);
$beton_tidak = get_beton_tidak($row->Beton);
$konstruksi_tanah= get_konstruksi($row->Konstruksi);
$body.="
<tr align=\"center\">
<td style=\"width: 30px;font-weight: \">$no</td>
<td style=\"width: 120px;font-weight: \">$row->NamaAset</td>
<td style=\"width: 79px;font-weight: \">$konstruksi_tanah</td>
<td style=\"width: 80px;font-weight: \">$bertingkat_tidak</td>
<td style=\"width: 78px; font-weight: \">$beton_tidak</td>
<td style=\"width: 51px; font-weight: \">$luas</td>
<td style=\"width: 90px; font-weight: \">$row->Alamat</td>
<td style=\"width: 79px; font-weight: \">$row->TglSertifikat</td>
<td style=\"width: 80px;font-weight: \">$row->NoSertifikat</td>
<td style=\"width: 78px; font-weight: \">-</td>
<td style=\"width: 80px;font-weight: \">$status_tanah</td>