<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');	
}	
$slm=$_SESSION['slm'];	
$jabat=$_SESSION['jabat'];

if (isset($_SESSION['custno'])) {
		
    $query = mysqli_query($con,"SELECT a.kdterm,a.kdharga,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,a.kdwil 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();
}
?>
<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>
 <SCRIPT language=Javascript>
<!--
function isNumberKey(evt)
{
var charCode = (evt.which) ? evt.which : event.keyCode
if (charCode > 31 && (charCode < 48 || charCode > 57))

return false;
return true;
}
//-->
</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:10px;
	#font-weight:bold;
	font-style:normal;
	height:15px;
	line-height:15px;
	width:30px;
	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>
<?php

if (isset($_GET['id']))

{
$nobuk=$_GET['id'];
}
else {

	
	$kode=mysqli_query($con,"select concat('SOM',date_format(curdate(),'%y%m')) as kode;");
	$kode1= mysqli_fetch_array($kode);
	
	$_kode=$kode1['kode'];
	
		
	$nomourut= mysqli_query($con,"Select func_getid('$_kode','$_cbg') AS nobukti;");
	$nobukti=mysqli_fetch_array($nomourut);
	$nosimpan=$nobukti['nobukti'];
	$nobuk=$nosimpan;
	// $simpan=mysqli_query($con,"insert into somobileheader(cabang,nobukti,custno,tgl,kdslm,stat,kdharga,kdwil,ppn,kdsupplier) 
	//								   values ('$_cbg','$nosimpan','$data[custno]','$data[tgl1]','$_SESSION[yuser]','0','$data[kdharga]','$data[kdwil]',10,'99';");
	
	
}
if ($jabat=='1') {
$simpan=mysqli_query($con,"call sp_insert_somobileheader('$_cbg','$nobuk','$data[kdterm]','$data[custno]','$data[tgl1]','$_SESSION[yuser]','0','$data[kdharga]','$data[kdwil]',10,'99');");}
else {
	$simpan=mysqli_query($con,"call sp_insert_somobileheader('$_cbg','$nobuk','$data[kdterm]','$data[custno]','$data[tgl1]','$slm','0','$data[kdharga]','$data[kdwil]',10,'99');");}
// $simpanok=mysqli_fetch_array($simpan);
//echo $_cbg.$nobuk.$data['custno'].$data['tgl1'].$_SESSION['yuser'].'0'.$data['kdharga'].$data['kdwil'].'10'.'99';
	
?>
<?php
	if ($jabat=='1') {$kdslm=$_SESSION['yuser'];}
	else {$kdslm=$slm;}
	$_SESSION['nobukti'] = $nobuk;	
	$_SESSION['cbg'] = $_cbg;	
	$_SESSION['gudang'] = $_gdg;	
	$_SESSION['kdharga'] = $data['kdharga'];		
	$_SESSION['kdwil'] = $data['kdwil'];		
	$_SESSION['kdslm'] = $kdslm;
	$_SESSION['custno'] = $data['custno'];		
	
?>	
</head>
<body>
<?php
	$total=mysqli_query($con,"select netto from somobileheader where nobukti='$nobuk';");
	$tnetto= mysqli_fetch_array($total);
	$_SESSION['netto'] = $tnetto['netto'];		
?>
<div style="margin: auto;">
	<div>
		<div style="float:left;margin-left:10px;">
				<td>
					<button  style='width:200px' readonly><font size="5" color='blue' >Rp.<?php echo number_format($tnetto['netto']);?></font> </button>
				</td>
		</div>		
		
		<div  style="float:right;margin-right:10px;">
				<td align='center'  type='submit' style='width:70px'><a class='timbul' href="prosesorderkanvas.php?id=<?php echo $nobuk; ?>">SIMPAN</a></td>
				
	</div>  
    <table border='1'>
		<thead>
		<p><tr><td>No.Bukti</td><td>: </td><td><?php echo $nobuk; ?></td></tr></p>
		<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>
		<p><tr><td>Kode Harga</td><td>: </td><td><?php echo $data['kdharga']; ?></td></tr></p>
		</thead>
       
	</table>	

	
</div> 
							
<table border='1'>
				
		<form action='simpansodetailkanvas.php' method='GET' return>
				<table>
					<div style="float:right;">
						<tr>
						<td>
							<input type='text' autocomplete='off' name='kdbrg' onkeyup='autoComplete();' id='kdbrg' style='float:left;width:350px' placeholder='Ketikan Nama Barang ...'  /> <div id='hasil'></div>
						</td>
						</tr>
						</table>
						<table>
						<td>
							<input type='number' autocomplete='off' name='qtyb' id='qtyb' style='width:75px' pattern="[0-9]*" placeholder='Qty Carton...'/>				
						</td>
						<td>
							<input type='number' autocomplete='off' name='qtym' id='qtym' style='width:75px' pattern="[0-9]*" placeholder='Qty Pack...'/>				
						</td>
						<td>
							<input type='number' autocomplete='off' name='qtyk' id='qtyk' style='width:75px' pattern="[0-9]*" placeholder='Qty  Pcs...'/>				
						</td>
						<td>																							
							<button type='submit' style='width:70px' ><i class='fa fa-paper-plane'></i>TAMBAH</a></button>
						</td>
						</table>
					</div>									
				</table>	
							
				<table >					
					<td>
						<input type='text' name='namabrg1' id='namabrg1' style='width:350px' placeholder='Nama Barang ...' readonly/>
					</td>									
				</table>	
		</form>	
				
</table>
			
<table border="1" style='margin-top:1px;'>

    <thead>
		
        <tr>
            <th>No.</th>
            <th>Keterangan</th>
			<th>Harga</th>
			<th>Qty</th>
			<th>Total</th>
			<th>Aksi</th>
        </tr>
    </thead>
     
    <tbody>
	
<?php

$tampil = "SELECT a.nourut,a.cabang,a.nobukti,a.kdbrg,a.qty,a.hs,b.namabrg1,a.total,a.ppn from somobiledetail a,barang b 
where a.kdbrg=b.kdbrg and a.nobukti = '$nobuk' order by a.nourut;";


$sql0 = mysqli_query($con,$tampil);  

$satu=mysqli_num_rows($sql0);
if ($satu>0) {
$ppn=0;
$dppn=1;
$no = 1; // Untuk penomoran tabel, di awal set dengan 1
while($data = mysqli_fetch_array($sql0)){
	$custno=$data['nobukti'];
	$kdbrg= $data['kdbrg'];
	$ppn=$data['ppn'];
	if ($ppn==10) { $dppn=1.1;}
    if  ($ppn==0) {$dppn=1;}
	$hs=$data['hs']*$dppn;
	$total=$data['total']*$dppn;
	$_SESSION['kdbrghapus'] = $kdbrg;		
	// $nilait=$nilait+$data['jumlah'];
	
				echo "<tr>";
				echo "<td>".$no++."</td>";
				echo "<td>".$data['namabrg1']."</td>";
				echo "<td align ='right'>".number_format($hs)."</td>";
				echo "<td align ='right'>".number_format($data['qty'])."</td>";				
				echo "<td align ='right'>".number_format($total)."</td>";
				echo "<td align='center'>
                <a href='hapussokanvas.php?id=$data[nourut]' class='classname'>Del</a></td>";
				echo "</tr>";
	
	}	
				$no++; // Tambah 1 setiap kali looping
			}

	?>

</body>

 </html>