
<body onLoad="window.print()">
<?php

require_once ("../../koneksi/koneksi.php");
if(isset($_GET['id_paket']))
{
	$rs=mysql_query("Select * from paket where id_paket='".$_GET['id_paket']."'");
	$aa=mysql_fetch_array($rs);
	$pak=$aa['id_paket'];

}

//Array Hari
$array_hari = array(1=>"Senin","Selasa","Rabu","Kamis","Jumat", "Sabtu","Minggu");
$hari = $array_hari[date("N")];
//Format Tanggal
$tanggal = date ("j");
//Array Bulan
$array_bulan = array(1=>"Januari","Februari","Maret", "April", "Mei", "Juni","Juli","Agustus","September","Oktober", "November","Desember");
$bulan = $array_bulan[date("n")];
//Format Tahun
$tahun = date("Y");

?>
<style>
.paket {height:85px; width:90%; margin:auto; margin-top:20px;}
.paket p{ margin-top:20px;}
.header { height:85px; width:90%; margin:auto; margin-bottom:20px;}
.header img {height:80px!important; float:left; margin-right:10px;}
.header h2{line-height:35px; text-align:center; margin-right:70px; margin-top:50px; font-weight:bold;}
.header p {text-align:center; font-weight:bold; margin:auto;padding:1px!important;}
.header span {padding-top:10px;}
.table {border: solid 1px #000; width:90%;margin:auto; border-collapse:collapse;}
.table th {border-right:solid 1px #000; border-bottom:solid 1px #000; background:#D3D3D3 ;color:#000;font-size:16px; padding:5px;text-align:center;
text-transform:capitalize;}
.table td {border-right:solid 1px #000;border-bottom:solid 1px #000; padding:8px;word-wrap:break-word;
font-family:Arial, Helvetica, sans-serif;font-size:15px;}
p {margin:0px;padding:4px!important; font-size:15px;font-family:Arial, Helvetica, sans-serif;text-transform:capitalize}
.ttd {height:85px; width:90%; margin:auto; margin-top:20px;}	
.ttd p {margin-top:10px; line-height:25px; margin-right:50px; text-align:right;}	
.ttd h4 {margin-top:70px; line-height:25px; margin-right:110px; text-align:right;}
</style>
<div class="container">
	<div class="row">
<center>
<h2></br> Laporan Administrasi</h2>
</center>

</span>
</div>

<div class="paket">
<p>Nama Paket &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:
<?php echo $aa['nama_paket'];?></br>Nama Proyek &nbsp;&nbsp;&nbsp;:
<?php echo $aa['nama_proyek'];?></br>Hps &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:
<?php echo "Rp. "; echo number_format($aa['hps']);?></br>Keterangan &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:
<?php echo $aa['kecamatan'];?>
</p>

</div>

	<table class="table" width="100%" >
<thead>
<tr >
<th align="center" valign="middle">No</th>
<th align="center" valign="middle">Nama Perusahaan</th>
<th align="center" valign="middle">SKK 1</th>
<th align="center" valign="middle">SKK 2</th>
<th  align="center" valign="middle">SKK 3</th>
<th  align="center" valign="middle">SKK 4</th>
<th  align="center" valign="middle">SKK 5</th>
<th  align="center" valign="middle">Jumlah</th>
<th  align="center" valign="middle">Keterangan</th>
<th  align="center" valign="middle">Alasan Gugur</th>
</tr></thead>
<tbody>
<?php 
$sql = mysql_query("Select * from paket 
        join administrasi on paket.id_paket=administrasi.id_paket 
        join perusahaan on administrasi.id_perusahaan=perusahaan.id_perusahaan
        where administrasi.id_paket='$pak'
        ");
$no=0;
$tgl=date("d-m-Y");
while($datapost=mysql_fetch_array($sql)){$no++;

?>
<tr>
<td><?PHP echo $no;?></td>
<td><?PHP echo $datapost['nama'];?></td>
<td><?PHP echo $datapost['ska1'];?></td>
<td><?PHP echo $datapost['ska2'];?></td>
<td><?PHP echo $datapost['ska3'];?></td>
<td><?PHP echo $datapost['ska4'];?></td>
<td><?PHP echo $datapost['ska5'];?></td>
<td><?PHP echo number_format($datapost['jumlah_adm']);?></td>
<td><?PHP echo $datapost['keterangan_adm'];?></td>
<td><?PHP echo $datapost['alasan_adm'];?></td>
</tr><?PHP }?>
</tbody></table>

<div class="ttd">
<p>Semarang, <?php echo $tanggal; echo" "; echo $bulan; echo" "; echo $tahun;?></p>
<h4>PIMPINAN</h4>
</div>
<br />
</div></div>