<meta name="viewport" content="width=device-width, initial-scale=1">
<?php
include 'connect.php';
define('YBASE',true);
session_start();


if (isset($_SESSION['yuser'])) {
			include_once 'config/log.php';
	$mtime = microtime(); $mtime = explode (" ", $mtime); $mtime = $mtime[1] + $mtime[0]; $tstart = $mtime;
} else {
	header('location:login.php');	
}	

if (isset($_SESSION['custno'])) {
		
    $query = mysqli_query($con,"SELECT a.custno,a.custname,a.alamat1,a.alamat2,a.lmt,DATE_FORMAT(b.tgl,'%d-%m-%Y') as tgl,b.tgl as tgl1, b.cekin,b.cekout,a.kdharga FROM customer a
	left join customer_log b on b.custno=a.custno 
	WHERE a.custno = '$_SESSION[custno]' order by b.tgl desc limit 1;");
    $data  = mysqli_fetch_array($query);
	
	$system="Select cabang,kdgudang from system limit 1";
	$dsystem=mysqli_query($con,$system);  
	$datasystem= mysqli_fetch_array($dsystem);
	$_cbg=$datasystem['cabang'];
	$_gdg=$datasystem['kdgudang'];
		
} else {
    echo "ID tidak tersedia!
<a href='listcustomer.php'>Kembali</a>";
    exit();
} 
if ($data === false) {
    echo "Data tidak ditemukan!
<a href='listcustomer.php'>Kembali</a>";
    exit();
}
$slm=$_SESSION['slm'];	
$jabat=$_SESSION['jabat'];
?>
<html>
 <head>
  <title>IBS</title>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<link rel="stylesheet" type="text/css" href="css/layout.css">
    <link rel="stylesheet" type="text/css" href="css/stylesheet.css">
    <link rel="stylesheet" type="text/css" href="css/easyui.css">
    <link rel="stylesheet" type="text/css" href="css/icon.css">
	<link rel="stylesheet" type="text/css" href="css/jquery-ui-1.css">
    <link rel="stylesheet" type="text/css" href="css/jquery_notification.css">
    <link rel="stylesheet" type="text/css" href="css/jquery.autocomplete.css"/>
    <link rel="stylesheet" type="text/css" href="css/jpaging.css">
    <link rel="stylesheet" type="text/css" href="css/ui.datepicker.css"/>
    <link rel="stylesheet" type="text/css" href="css/bootstrap.css"/>
	<link rel="stylesheet" type="text/css" href="css/jquery-ui.css"/>   
	<script type="text/javascript" src="js/jquery-1.7.2.min.js"></script>
    <script type="text/javascript" src="js/jquery-ui-1.8.20.custom.min.js"></script>
    <script type='text/javascript' src='js/jquery.paginate.js'></script>
    <script type="text/javascript" src="js/ui.core.js"></script>
    <script type='text/javascript' src="js/jquery.autocomplete.js"></script>
    <script type="text/javascript" src="js/ui.datepicker.js"></script>
    <script type="text/javascript" src="js/jquery.PrintArea.js"></script>
	<script type="text/javascript" src="js/jquery.easyui.min.js"></script>
	<script type="text/javascript" src="js/clock.js"></script>
    <script type="text/javascript" src="js/jquery_notification_v.1.js"></script>
	<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
    <script type="text/javascript" src="js/jquery-ui.min.js"></script>
    <script language="JavaScript">
    var ajaxRequest;
    function getAjax() { //fungsi untuk mengecek AJAX pada browser
        try {
            ajaxRequest = new XMLHttpRequest();
        } catch (e) {
            try {
                ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
            }
            catch (e) {
                try {
                    ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
                } catch (e) {
                    alert("Your browser broke!");
                    return false;
                }
            }
        }
    }
    function autoComplete() { //fungsi menangkap input search dan menampilkan hasil search
        getAjax();
        input = document.getElementById('kdbrg').value;if (input == "") {
            document.getElementById("hasil").innerHTML = "";
        }
        else {
            ajaxRequest.open("GET","cari.php?input="+input);
            ajaxRequest.onreadystatechange = function() {
                document.getElementById("hasil").innerHTML = ajaxRequest.responseText;
            }
            ajaxRequest.send(null);
        }
    }
    function autoInsert(kdbrg,namabrg1,isi3,hrgbeli,gabung) { //fungsi mengisi input text dengan hasil pencarian yang dipilih
        document.getElementById("kdbrg").value = kdbrg;
        document.getElementById("namabrg1").value = gabung;
		document.getElementById("hasil").innerHTML = "";
    }
 </script>
	<script type="text/javascript">    
	
    //fungsi displayTime yang dipanggil di bodyOnLoad dieksekusi tiap 1000ms = 1detik
    function tampilkanwaktu(){
        //buat object date berdasarkan waktu saat ini
        var waktu = new Date();
        //ambil nilai jam, 
        //tambahan script + "" supaya variable sh bertipe string sehingga bisa dihitung panjangnya : sh.length
        var sh = waktu.getHours() + ""; 
        //ambil nilai menit
        var sm = waktu.getMinutes() + "";
        //ambil nilai detik
        var ss = waktu.getSeconds() + "";
        //tampilkan jam:menit:detik dengan menambahkan angka 0 jika angkanya cuma satu digit (0-9)
        document.getElementById("clock").innerHTML = (sh.length==1?"0"+sh:sh) + "." + (sm.length==1?"0"+sm:sm) + "." + (ss.length==1?"0"+ss:ss);
    }
</script>
	<style type="text/css">
.classname {
	-moz-box-shadow:inset 0px 1px 0px 0px #cae3fc;
	-webkit-box-shadow:inset 0px 1px 0px 0px #cae3fc;
	box-shadow:inset 0px 1px 0px 0px #cae3fc;
	background:-webkit-gradient( linear, left top, left bottom, color-stop(0.05, #FF0000), color-stop(1, #4197ee) );
	background:-moz-linear-gradient( center top, #FF0000 5%, #4197ee 100% );
	filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#79bbff', endColorstr='#4197ee');
	background-color:#FF0000;
	-webkit-border-top-left-radius:20px;
	-moz-border-radius-topleft:20px;
	border-top-left-radius:20px;
	-webkit-border-top-right-radius:20px;
	-moz-border-radius-topright:20px;
	border-top-right-radius:20px;
	-webkit-border-bottom-right-radius:20px;
	-moz-border-radius-bottomright:20px;
	border-bottom-right-radius:20px;
	-webkit-border-bottom-left-radius:20px;
	-moz-border-radius-bottomleft:20px;
	border-bottom-left-radius:20px;
	text-indent:0;
	border:1px solid #469df5;
	display:inline-block;
	color:#ffffff;
	font-family:Verdana;
	font-size:15px;
	font-weight:bold;
	font-style:normal;
	height:25px;
	line-height:25px;
	width:130px;
	text-decoration:none;
	text-align:top-center;
	text-shadow:1px 1px 0px #287ace;
}
.classname:hover {
	background:-webkit-gradient( linear, left top, left bottom, color-stop(0.05, #4197ee), color-stop(1, #79bbff) );
	background:-moz-linear-gradient( center top, #4197ee 5%, #79bbff 100% );
	filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#4197ee', endColorstr='#79bbff');
	background-color:#4197ee;
}.classname:active {
	position:relative;
	#top:1px;
}

    tbody > tr:nth-child(2n+1) > td, tbody > tr:nth-child(2n+1) > th {
        background-color: #ededed;
    }
    table{
        width: 95%;
        margin: auto;
        border-collapse: collapse;
        box-shadow: darkgrey 3px;
    }
    thead tr {
        background-color: #36c2ff;
    }
	
</style>

<style type="text/css">
.timbul {
	-moz-box-shadow:inset 0px 1px 0px 0px #fce2c1;
	-webkit-box-shadow:inset 0px 1px 0px 0px #fce2c1;
	box-shadow:inset 0px 1px 0px 0px #fce2c1;
	background:-webkit-gradient( linear, left top, left bottom, color-stop(0.05, #3a0cf0), color-stop(1, #176157) );
	background:-moz-linear-gradient( center top, #3a0cf0 5%, #176157 100% );
	filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#3a0cf0', endColorstr='#176157');
	background-color:#3a0cf0;
	-webkit-border-top-left-radius:10px;
	-moz-border-radius-topleft:10px;
	border-top-left-radius:10px;
	-webkit-border-top-right-radius:10px;
	-moz-border-radius-topright:10px;
	border-top-right-radius:10px;
	-webkit-border-bottom-right-radius:10px;
	-moz-border-radius-bottomright:10px;
	border-bottom-right-radius:10px;
	-webkit-border-bottom-left-radius:10px;
	-moz-border-radius-bottomleft:10px;
	border-bottom-left-radius:10px;
	text-indent:0px;
	border:2px solid #ed5197;
	display:inline-block;
	color:#dcdeed;
	font-family:Arial Black;
	font-size:12px;
	font-weight:bold;
	font-style:normal;
	height:25px;
	line-height:25px;
	width:100px;
	text-decoration:none;
	text-align:center;
	text-shadow:0px 1px 0px #cc9f52;
}
.timbul:hover {
	background:-webkit-gradient( linear, left top, left bottom, color-stop(0.05, #176157), color-stop(1, #3a0cf0) );
	background:-moz-linear-gradient( center top, #176157 5%, #3a0cf0 100% );
	filter:progid:DXImageTransform.Microsoft.gradient(startColorstr='#176157', endColorstr='#3a0cf0');
	background-color:#176157;
}.timbul:active {
	position:relative;
	top:1px;
}</style>
</head>
<body>
<?php
	if ($jabat=='1') {
	$total=mysqli_query($con,"select sum(netto) from somobileheader where custno='$_SESSION[custno]' and tgl=curdate() and kdslm='$_SESSION[yuser]' and jns='1' group by custno;");
	} else {
		$total=mysqli_query($con,"select sum(netto) from somobileheader where custno='$_SESSION[custno]' and tgl=curdate() and kdslm='$slm' and jns='1' group by custno;");
	}
	$tnetto= mysqli_fetch_array($total);
?>
<div align='center'>
	<td>
	<font size='4' color='red'> List Sales Order by Customer </font>
	</td>
	
</div>		
<div style="margin: auto;">
	
    <table border='1'>
		<thead>
		<p><tr><td>Tanggal</td><td>: </td><td><?php echo $data['tgl']; ?></td></tr></p>
        <p><tr><td>Kode</td><td>: </td><td><?php echo $data['custno']; ?></td></tr></p>
        <p><tr><td>Nama</td><td>: </td><td><?php echo $data['custname']; ?></td></tr></p>
        <p><tr><td>Alamat</td><td>: </td><td><?php echo $data['alamat1']; ?></td></tr></p>
		</thead>
         
	</table>	

	
</div> 
							
<table border='1'>
	<div>
	<td align='center'  type='submit' style='width:70px'><a class='timbul' href="salesorderkanvas.php">NEW</a></td>
	<td align='center'  type='submit' style='width:70px'><a class='timbul' href="cekinkanvas.php?id=<?php echo $data['custno']; ?>">NEXT</a></td>
	</div>
	</div>					
</table>
			
<table border="1" style='margin-top:1px;'>

    <thead>
		
        <tr>
            
            <th>Nobukti</th>
			<th>Customer</th>
			<th>Total</th>
			<th>Aksi</th>
        </tr>
    </thead>
     
    <tbody>
	
<?php
if ($jabat=='1') {
$tampil = "SELECT a.cabang,a.nobukti,a.tgl,a.custno,b.custname,a.netto,a.stat from somobileheader a,customer b 
where a.custno=b.custno and a.custno='$_SESSION[custno]' and a.tgl=curdate() and a.kdslm='$_SESSION[yuser]' and a.jns='1' order by a.nobukti;";
} else {
	$tampil = "SELECT a.cabang,a.nobukti,a.tgl,a.custno,b.custname,a.netto,a.stat from somobileheader a,customer b 
where a.custno=b.custno and a.custno='$_SESSION[custno]' and a.tgl=curdate() and a.kdslm='$slm' and a.jns='1' order by a.nobukti;";
}


$sql0 = mysqli_query($con,$tampil);  

$satu=mysqli_num_rows($sql0);
if ($satu>0) {

$no = 1; // Untuk penomoran tabel, di awal set dengan 1
while($data = mysqli_fetch_array($sql0)){
	$custno=$data['nobukti'];
	$stat=$data['stat'];
	// $nilait=$nilait+$data['jumlah'];
		if ($stat=='0') {
				echo "<tr>";
				echo "<td align ='right'>".$data['nobukti']."</td>";
				echo "<td>".$data['custname']."</td>";
				echo "<td align ='right'>"."Rp.".number_format($data['netto'])."</td>";
				echo "<td align='center'>
                <a href='salesorder.php?id=$custno'><button><font color='blue'>Edit</font></button></a></td>";
				echo "</tr>";
		}
		else {
			echo "<tr>";
				echo "<td align ='right'>".$data['nobukti']."</td>";
				echo "<td>".$data['custname']."</td>";
				echo "<td align ='right'>"."Rp.".number_format($data['netto'])."</td>";
				echo "<td align='center'> <button><font color='blue'>Faktur</font></button> </td>";
                echo "</tr>";
		}
	}	
				$no++; // Tambah 1 setiap kali looping
			}

	?>

</body>

 </html>