Untitled

<!DOCTYPE html>
<html>


	<link rel="stylesheet" type="text/css" href="assets/css/jquery.dataTables.css">

<body class="hold-transition skin-blue sidebar-mini">
<!-- Site wrapper -->


<head>
	<link rel="stylesheet" type="text/css" href="assets/css/jquery.dataTables.css">
<link rel="stylesheet" href="css/gaya.css" type="text/css" media="screen"  />
	<script type="text/javascript" src="assets/js/jquery.min.js"></script>
	<script type="text/javascript" src="assets/js/jquery.dataTables.min.js"></script>
	<link rel="stylesheet" href="assets/js/style.css" type="text/css" />

	<link rel="stylesheet" href="bootstrap/css/bootstrap.css" type="text/css" />
</head>
  <!-- /.content-wrapper -->

  <script>
function cetak(el){
    var restorepage = document.body.innerHTML;
    var cetak= document.getElementById(el).innerHTML;
    document.body.innerHTML = cetak;
    window.print();
    document.body.innerHTML = restorepage;
}
</script>
<?php
	function tgl_indo($tgl){
			$tanggal = substr($tgl,8,2);
			$bulan = getBulan(substr($tgl,5,2));
			$tahun = substr($tgl,0,4);
			return $tanggal.' '.$bulan.' '.$tahun;
	}

	function getBulan($bln){
				switch ($bln){
					case 1:
						return "Januari";
						break;
					case 2:
						return "Februari";
						break;
					case 3:
						return "Maret";
						break;
					case 4:
						return "April";
						break;
					case 5:
						return "Mei";
						break;
					case 6:
						return "Juni";
						break;
					case 7:
						return "Juli";
						break;
					case 8:
						return "Agustus";
						break;
					case 9:
						return "September";
						break;
					case 10:
						return "Oktober";
						break;
					case 11:
						return "November";
						break;
					case 12:
						return "Desember";
						break;
				}
			}

date_default_timezone_set('Asia/Jakarta'); // PHP 6 mengharuskan penyebutan timezone.
$seminggu = array("Minggu","Senin","Selasa","Rabu","Kamis","Jumat","Sabtu");
$hari = date("w");
$hari_ini = $seminggu[$hari];

$tgl_sekarang = date("Ymd");
$tgl_skrg     = date("d");
$bln_sekarang = date("m");
$thn_sekarang = date("Y");
$jam_sekarang = date("H:i:s");

$nama_bln=array(1=> "Januari", "Februari", "Maret", "April", "Mei",
                    "Juni", "Juli", "Agustus", "September",
                    "Oktober", "November", "Desember");
?>
<?php
$tanggal1 = Date("d/m/y");
$tanggal2 = Date("Y");
?>
    <section class="content-header">
	<br>
	   <br>
	   <br>
	   <div style='margin-left:2%;margin-right:2%;margin-top:2%;'>
		<div id='ini_laporan'>

<?php
$tanggal1 = Date("d/m/y");
$tanggal2 = Date("Y");
?>
<h3 align="center"> Daftar No.SSPD Yang Akan Di Setorkan</h3>
	<table style="font-size:13px;" width="60%" border="0" cellspacing="0" cellpadding="5">
		<thead>
		<tr class="top_tr">
			<td width='15%'>Nomor Laporan<td>: LPP/<?php Echo  $tanggal1; ?>/DPMPTSP<tr>
			<td width='15%' >Nomor Pajak<td>: <?php echo "Kebumen, $hari_ini  " . tgl_indo(date("Y m d")). "" ; ?><tr>
			<td width='15%' >Nmama Laporan<td>: Laporan Pajak SPPD<tr>
		<td>
		</table>

	<table style="font-size:13px;" width="100%" border="1" cellspacing="0" cellpadding="5">
		<thead>
		<tr class="top_tr">
			<th><center>No.</center></th>
			<th><center>Nomor Identitas</center></th>
			<th><center>Nomor Pajak</center></th>
			<th><center>Nama Objek</center></th>
			<th><center>Nama Pemilik</center></th>
			<th><center>Omset Pendapatan</center></th>
			<th><center>Tanggal Input</center></th>
			<th><center>Tanggal Habis</center></th>
			<th><center>Jumlah Pajak</center></th>
		</tr>
		</thead>

		<?php
		function format_indo($date){
			$BulanIndo = array("Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember");

			$tahun = substr($date, 0, 4);
			$bulan = substr($date, 5, 2);
			$tgl   = substr($date, 8, 2);
			$result = $tgl . "-" . $BulanIndo[(int)$bulan-1]. "-". $tahun;
			return($result);
			}
		?>

	<?php
	include("koneksi.php");
	if(isset($_POST['cek']))
	{
	$cek=$_POST['cek'];
	if($_POST['submit']=="Tampilkan")
	{
	$no=1;
		$i=0;
		while($i<sizeof($cek))
		{

		$tampil=mysql_query("SELECT * FROM sptpd WHERE npwpd='$cek[$i]'");
		while($data = mysql_fetch_array($tampil))

		{
		$tgl1 = $data['tanggal'];// pendefinisian tanggal awal
		$data1 = date('Y-m-d', strtotime('+1 year +1 day', strtotime($tgl1)));
		$data2=format_indo($data1);
		$data3=format_indo($data['tanggal']);
		$data4=number_format($data['j_omset']);
		$data5=number_format($data['j_tagihan']);
			echo"<tr><td>$no</td>
			<td align='center'>$data[npwpd]</td>
			<td align='center'>$data[npwpd1]</td>
			<td align='center'>$data[n_objek]</td>
			<td align='center'>$data[nama_pemilik]</td>
			<td align='center'>Rp. $data4</td>
			<td align='center'>$data3</td>
			<td align='center'>$data2</td>
			<td align='center'>Rp. $data5</td>

			</tr>";

		}
		$i++;
	$no++;
	}
}
}
else
{
	echo"<tr><td colspan='9'>Pilih Data Terlebih Dahulu</td></tr>";
}
?>
</tr>
<tr>
<td colspan='8' align='center'>JUMLAH</td>
<?php
if(isset($_POST['cek']))
	{
	$cek=$_POST['cek'];
	if($_POST['submit']=="Tampilkan")
	{


		$tampil=mysql_query("SELECT SUM(j_tagihan='$cek') as jumlah FROM sptpd WHERE j_tagihan ");
		while($data = mysql_fetch_array($tampil))

		{
		echo '<td>Rp. '.number_format ($data['jumlah']).'</td>';

		}

}
}
?>
</tr>

</table>
<br>

</div>
<div style="margin-bottom:1%;">
<button class='btn btn-warning glyphicon glyphicon-new-window' onClick="cetak('ini_laporan')">Cetak</button>
<a class="btn btn-primary" href="daftar_pajak.php">Kembali</a>
</body>