<?php include('header.php');?>
<html>
<head>
	<title></title>
	
	<link rel="stylesheet" href="../bootstrap/js/jquery/jquery-ui.css">
	<script src="../bootstrap/js/jquery/jquery-ui.min.js"></script>

</head>
<body>


<?php
$select_store_type = "SELECT * FROM store_type";
$query_store_type = mysqli_query($conn, $select_store_type);
$row_store_type = mysqli_num_rows($query_store_type);

$select_dept = "SELECT * FROM department WHERE access='ON'";
$query_dept = mysqli_query($conn, $select_dept);
$row_dept = mysqli_num_rows($query_dept);

$select_siv_no = "SELECT * FROM siv_no ORDER BY id DESC";
$query_siv_no = mysqli_query($conn, $select_siv_no);
$row_siv_no = mysqli_num_rows($query_siv_no);
$fetch_siv_no = mysqli_fetch_array($query_siv_no);
$siv_no = $fetch_siv_no['siv_no'];

$select_siv = "SELECT * FROM siv WHERE siv_no = '$siv_no' ORDER BY id DESC";
$query_siv = mysqli_query($conn, $select_siv);
$row_siv = mysqli_num_rows($query_siv);

$select_siv2 = "SELECT * FROM siv ORDER BY siv_no DESC";
$query_siv2 = mysqli_query($conn, $select_siv2);
$fetch_siv2 = mysqli_fetch_array($query_siv2);

$select_item = "SELECT * FROM item";
$query_item = mysqli_query($conn, $select_item);
$row_item = mysqli_num_rows($query_item);
?>

<!-- INSERT DATA CODE -->

<?php

if(isset($_POST['insert'])){
	
	$siv = mysqli_real_escape_string($conn,$_POST['siv']);
	$item_id = mysqli_real_escape_string($conn,$_POST['item_id']);
	$quantity = mysqli_real_escape_string($conn,$_POST['quantity']);
	$unit_selling_price = mysqli_real_escape_string($conn,$_POST['unit_selling_price']);
	  
	$remark=mysqli_real_escape_string($conn,$_POST['remark']);
	$date=mysqli_real_escape_string($conn,$_POST['date_pic']);
	
	$itembal_tbl_id=mysqli_real_escape_string($conn,$_POST['itembal_tbl_id']);



	$ck_issued_qty ="SELECT * FROM itembal_tbl ib WHERE ib.Number ='$itembal_tbl_id'";
	$ck_query = mysqli_query ($conn,$ck_issued_qty);
	$ck_row = mysqli_num_rows($ck_query);
   
	if($ck_row > 0){
		$ck_fetch = mysqli_fetch_array($ck_query);
		
		$bal_id = $ck_fetch['Number'];
		$Balance_no = $ck_fetch['Balance_no'];

		$total_price = $quantity * $unit_selling_price;

		$remain_balance = $Balance_no - $quantity;

		if($Balance_no >= $quantity ){

		echo	$update_bal = "UPDATE itembal_tbl SET Balance_no='$remain_balance' WHERE Number='$bal_id' ";
			$updatebal_query = mysqli_query($conn,$update_bal);

		echo	$add_SIV = "INSERT INTO siv (`siv_no`, `item_id`, `issued_qty`, `unit_purchase_price`, `unit_selling_price`, `total_price`, `date`, `user_id`, `remark`) VALUES ('$siv', '$item_id', '$quantity', '".$ck_fetch['Unit_price']."', '$unit_selling_price', '$total_price', '$date', '".$_SESSION['User_ID']."', '$remark')";
			$SIV_query = mysqli_query ($conn, $add_SIV);

		}
		else {
			?><div class="container"><ol class="breadcrumb alert alert-danger">
			<li class="breadcrumb-item "> <strong> Check! </strong>Current Balance </li> </ol></div><?php 
		}
	}
?>

<meta http-equiv="refresh" content="0;URL='siv.php'">

<?php
}
?>

<!-- UPDATE DATA CODE -->
<?php
if(isset($_POST['update'])){
	
	$id = mysqli_real_escape_string($conn, $_POST['id']);
	$siv=mysqli_real_escape_string($conn,$_POST['siv']);
	$quantity=mysqli_real_escape_string($conn,$_POST['quantity']);
	$date_pic = mysqli_real_escape_string($conn, $_POST['date_pic']);
	$remark=mysqli_real_escape_string($conn,$_POST['remark']);
	
	$previous_qua = mysqli_real_escape_string($conn,$_POST['Previous_qua']);
	$item_id = mysqli_real_escape_string($conn,$_POST['item_id']);
	$unit_purchase_price = mysqli_real_escape_string($conn, $_POST['unit_purchase_price']);
	$unit_selling_price = mysqli_real_escape_string($conn, $_POST['unit_selling_price']);
	
	$total_price = $quantity * $unit_selling_price;
	
	$find_itemid = "SELECT * FROM itembal_tbl WHERE Item_id ='$item_id' AND Unit_price = '$unit_purchase_price'";
	$itemid_query = mysqli_query($conn,$find_itemid);
	
	if(mysqli_num_rows($itemid_query)==0){	}
	else {
		
		$fetch_Balance = mysqli_fetch_array($itemid_query);
		
		$DB_balance = $fetch_Balance['Balance_no'];
		$data_row = $fetch_Balance['Number'];
		
		$up_qua = $previous_qua - $quantity;
		$cur_bal = $DB_balance + $up_qua;
		
		$check = $quantity - $previous_qua;
		
		if($DB_balance >= $check ){
			$update_bal = "UPDATE itembal_tbl SET Balance_no='$cur_bal' WHERE Number ='$data_row' ";
			$updatebal_query = mysqli_query($conn,$update_bal);
			
			$update_siv = "UPDATE siv SET siv_no='$siv', issued_qty='$quantity', unit_selling_price='$unit_selling_price', total_price='$total_price', date='$date_pic', remark='$remark' WHERE id='$id'";
			$query_update_siv = mysqli_query($conn, $update_siv);

		}
		else {
			?><div class="container"><ol class="breadcrumb alert alert-danger">
            <li class="breadcrumb-item "> <strong> Check! </strong>Current Balance </li> </ol></div><?php 
		}
	
	}	?>
		
	<meta http-equiv="refresh" content="0;URL='siv.php'">	<?php
	
	if (!$query_update_siv) {
		echo "not updating";
	}
}
?>

<!-- DELETE QUERY /remove one siv line from siv table/ -->
<?php
if(isset($_POST['remove_siv'])){
	
	$siv_id=mysqli_real_escape_string($conn,$_POST['siv_id']);
	
	$item_id = mysqli_real_escape_string($conn,$_POST['item_id']); 
	$unit_purchase_price = mysqli_real_escape_string($conn,$_POST['unit_purchase_price']);
	$quantity = mysqli_real_escape_string($conn,$_POST['quantity']);
	
	$del_sql="DELETE FROM siv WHERE id='$siv_id'";
	$delquery=mysqli_query($conn,$del_sql);
	
	$find_itemid = "SELECT * FROM itembal_tbl WHERE Item_id ='$item_id' AND Unit_price = '$unit_purchase_price' ";
	$itemid_query = mysqli_query($conn,$find_itemid);
	
	if(mysqli_num_rows($itemid_query)==0){ }
	else {
		
		$fetch_Balance = mysqli_fetch_array($itemid_query);
		
		$DB_balance = $fetch_Balance['Balance_no'];
		$data_row = $fetch_Balance['Number'];
		
		$cur_bal = $DB_balance + $quantity;
		
		$update_bal = "UPDATE itembal_tbl SET Balance_no='$cur_bal' WHERE Number ='$data_row' ";
		$updatebal_query = mysqli_query($conn,$update_bal);
	
	}	?>
		
	<meta http-equiv="refresh" content="0;URL='siv.php'">	<?php
}
?>


<!-- AFTER CLICK DONE BUTTON /siv_no table add by 1 data && new table desplay / -->
<?php
//store_edit table delete siv_no
if (isset($_POST['btn_edit_sno'])) {
	$del_stedit = "UPDATE store_edit SET siv_no = '0' WHERE 1";
	$que_stedit = mysqli_query($conn, $del_stedit);
}

if (isset($_POST['btn_siv_no'])) {
	$siv_no_sum = $siv_no + 1;
	$insert_siv_no = "INSERT INTO siv_no VALUES ('', $siv_no_sum)";
	$query_insert_siv_no = mysqli_query($conn, $insert_siv_no);
	?>
	
	<div class="container">

	<form action='' method="POST" role="form" class="form-horizontal">
		<br>
		<button type="button" name="print" onclick="printfunction(printpage)"  class="btn btn-info" id="EditUser"><i class="fas fa-print"></i> Print</button>
		<a type="button" href="siv.php" class="float-right btn btn-danger" > Close </a>
		<br><br>
	
		<div class="row">  &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
			<div class="col-sm-3">
				<input class="form-control form-control-sm" name="delivered_by" type="text" id="deli" placeholder="Delivered by" required>
			</div>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
			<div class="col-sm-3">
				<input class="form-control form-control-sm" name="prn" type="text" placeholder="P.R.No." required>
			</div>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
			<div class="col-sm-3">
				<input class="form-control form-control-sm" name="pon" type="text" placeholder="P.O.No." required>
			</div>
		</div>
	</form>
	
	<table class="table table-hover table-sm">
		<thead><tr><th>No</th><th>Sales no</th><th>Item List Name</th><th>Issued_Qty</th><th>Unit Price</th><th>Total Price</th></tr></thead>
			<tbody>
				<tr>
					<?php	
					$number = 1;
		 //siv_no 	item_id 	issued_qty 	unit_purchase_price 	total_price 	dept_id 	reci_user 	date 	remark
				
					while($fetch_siv=mysqli_fetch_array($query_siv)){
						$it_id = $fetch_siv['item_id'];
					?>
					<td><?php echo $number; ?></td>
					<td><?php echo $fetch_siv[1];?></td>
					<?php						
						$select_item3 = "SELECT * FROM item WHERE id = '$it_id'";
						$query_item3 = mysqli_query($conn, $select_item3);
						$fetch_item3 = mysqli_fetch_array($query_item3);
						?>
					<td><?php echo $fetch_item3['name'];?></td>
					<td><?php echo $fetch_siv['issued_qty'];?></td>
					<td><?php echo $fetch_siv['unit_selling_price'];?></td>
					<td><?php echo $fetch_siv['total_price'];?></td>
				</tr>
				<?php
				$number = $number +1 ;
					} ?>
			</tbody>
	</table>
	</div>

<?php
}
else {
	?>

	<!-- SIV INSERTION FORM -->
	<div class="container"> <br>
		<form enctype="multipart/form-data" action='' method="POST" role="form" class="form-horizontal">
			
			<div class="row">
				<div class="col-sm-1"></div>
				
				<?php 
				$sel_date_siv = "SELECT * FROM siv WHERE siv_no = '$siv_no' ORDER BY id DESC";
				$query_date_siv = mysqli_query($conn, $sel_date_siv);
				$fetch_date_siv = mysqli_fetch_array($query_date_siv);
				?>
				
				<label for="example-text-input" class=" col-form-label-sm">Date : </label>
				<div class="col-sm-2">
				
					<?php
					if (mysqli_num_rows($query_date_siv) >= 1) { ?>
						<input class="form-control form-control-md" type="text" name="date_pic"  id="getlastdate" value="<?php echo $fetch_date_siv['date']; ?>"> <?php					
					}
					else { ?>
						<input class="form-control form-control-md" type="text" name="date_pic" id="getdate" > <?php
					}
					?>
					
				</div>
				
				<div class="col-sm-2"></div>
				<div class="">
					
					<h4><i class="fas fa-user fa-1x"></i> Sales  Form </h4>
				</div>
			</div>  <hr>	
		
			<div class="row">  &nbsp&nbsp&nbsp&nbsp&nbsp
				<div class="col-md-6">
				
				<div class="row form-group">
					<label for="example-text-input" class="col-sm-3 col-form-label-sm">Order No</label>
					<div class="col-sm-8">
					
					<?php
					$sel_store = "SELECT * FROM store_edit";
					$que_store = mysqli_query($conn, $sel_store);
					$fet_store = mysqli_fetch_array($que_store);
					
					if($fet_store['siv_no'] == 0) { ?>
						<input class="form-control form-control-sm" type="text" value="<?php echo $siv_no; ?>" name="siv" readonly="">
					<?php }
					else { ?>
						<input class="form-control form-control-sm" type="text" value="<?php echo $fet_store['siv_no']; ?>" name="siv" readonly="">
					<?php } ?>					
						
					</div>
				</div>
				<div class="form-group row" required>
					<label for="example-text-input" class="col-sm-3 col-form-label-sm">Category</label>
					<div class="col-sm-8">
						<select class="form-control form-control-sm" id="store_type" name="store_type" required>
							<option selected value disabled > Please Select Category </option>
							<?php 
							$select_store_type2 = "SELECT * FROM store_type WHERE access = 'ON'";
							$query_store_type2 = mysqli_query($conn, $select_store_type2);
							
							while ($fetch_store_type = mysqli_fetch_array($query_store_type2)) { ?>
							<option class="red" value="<?php echo $fetch_store_type['id']; ?>"><?php echo $fetch_store_type['type']; ?></option>
							<?php } ?>
						</select>
					</div>
				</div>
				<div class="form-group row" required>
					<label for="example-text-input" class="col-sm-3 col-form-label-sm">Item List</label>
					<div class="col-sm-8">
						<select class="form-control form-control-sm" id="item_name" name="item_id" required>
						<option selected value disabled > 1st Select Category </option>
						</select>
					</div>
				</div>
				<div class="form-group row">
					<label for="example-text-input" class="col-sm-3 col-form-label-sm">Balance</label>
					<div class="col-sm-8">
						<select class="form-control form-control-sm" id="itembal_tbl_id" name="itembal_tbl_id" required>
							<option selected value disabled > Select Item List </option>
						</select>
					</div>
				</div>
				</div>

			 &nbsp&nbsp&nbsp&nbsp&nbsp
				<div class="col-md-5">
				<div class="form-group row">
					<label for="example-text-input" class="col-sm-4 col-form-label-sm">Quantity Issued</label>
					<div class="col-sm-8">
						<input class="form-control form-control-sm"  type="number" step="any" id="quantity"  name="quantity" placeholder="Piece / Kg. / Li." required>
					</div>
				</div>	
				<div class="form-group row">
					<label for="example-text-input" class="col-sm-4 col-form-label-sm" >Selling Price</label>
					<div class="col-sm-8">
						<input class="form-control form-control-sm" type="float" name="unit_selling_price" value="" required>
					</div>					
				</div>	
				<div class="form-group row">
					<label for="example-text-input" class="col-sm-4 col-form-label-sm">Remark</label>
					<div class="col-sm-8">
						<input class="form-control form-control-sm" type="text" name="remark" placeholder="Remark">
					</div>
				</div>
			
			
			<input class=" " type="float"  name="purchase_price" id="itembal_id" hidden>	
			
<script>

$(document).ready(function() {
	
	$("#itembal_tbl_id").change(function(){
		var balaid = $(this).val();
		$("#itembal_id").val(balaid);
		
	});
	
});
	
	
</script>				
				
				
				</div>

				<div class="float-left mx-auto" style="width: 100%; border: 0px solid black;">
					<center>
						<input class="btn btn-success col-sm-2" type="submit" name="insert" value="Insert">
					</center>	
				</div>	
			</div>
		</form>
		<hr class="hr-primary" />
	</div>



	<!-- FETCH SIV DATA CODE -->
<div class="container">
	<?php
	
	$sivno_chk = "SELECT siv_no.siv_no, store_edit.siv_no AS store_edit_siv
					FROM siv_no, store_edit GROUP BY siv_no.siv_no ORDER BY siv_no.siv_no DESC";
	$que_sivchk = mysqli_query($conn, $sivno_chk);
	$fet_sivchk = mysqli_fetch_array($que_sivchk);
	$chk_sivno = $fet_sivchk['siv_no'];
	$chk_storesno = $fet_sivchk['store_edit_siv'];
	
	if($chk_storesno == 0 && $row_siv == 0){	?>
		<ol class="breadcrumb alert alert-danger">
		<li class="breadcrumb-item "> <strong> sorry! </strong>there is no Sales inserted with this Sales no</li> </ol><?php
	}

	else {
		if($chk_storesno == 0) {
			
			$select_siv4 = "SELECT * FROM siv WHERE siv_no = '$chk_sivno' ORDER BY id DESC";
			$query_siv4 = mysqli_query($conn, $select_siv4);
			$row_siv4 = mysqli_num_rows($query_siv4);

		}
		else{
			
			$select_siv4 = "SELECT * FROM siv WHERE siv_no = '$chk_storesno' ORDER BY id DESC";
			$query_siv4 = mysqli_query($conn, $select_siv4);
			$row_siv4 = mysqli_num_rows($query_siv4);

		}
	?>

		<table id="example" class="table table-striped table-hover table-sm" style="font-size: 15px;" width="100%">
			<thead><tr><th>No</th><th>Sales no</th><th>Item List Name</th><th>Qty</th><th>Purchase Price</th><th>Selling Price</th><th>Total Saling Price</th><th>Date</th><th>Edit</th><th>Delete</th></tr></thead>
			<tbody>
				<tr>
					<?php
					$number = 1;
		 //siv_no 	item_id 	issued_qty 	unit_purchase_price 	total_price 	dept_id 	reci_user 	date 	remark
				
					while($fetch_siv=mysqli_fetch_array($query_siv4)){
						$it_id = $fetch_siv['item_id'];
						$sno = $fetch_siv['siv_no'];
					?>
					<td><?php echo $number; ?></td>
					<td><?php echo $fetch_siv[1];?></td>
					<?php						
						$select_item3 = "SELECT * FROM item WHERE id = '$it_id'";
						$query_item3 = mysqli_query($conn, $select_item3);
						$fetch_item3 = mysqli_fetch_array($query_item3);
						?>
					<td><?php echo $fetch_item3['name'];?></td>
					<td><?php echo $fetch_siv['issued_qty'];?></td>
					<td><?php echo number_format($fetch_siv['unit_purchase_price'], 2);?></td>
					<td><?php echo number_format($fetch_siv['unit_selling_price'], 2);?></td> 
					<td><?php echo number_format($fetch_siv['total_price'], 2);?></td>
					<td><?php echo $fetch_siv['date'];?></td>
					<td>
					<a class="text-primary" href="#" data-toggle="modal" data-target="#update<?php echo $fetch_siv[0]; ?>">Edit</a>

<!-- UPDATE MODAL -->

	<div class="modal fade " id="update<?php echo $fetch_siv[0]; ?>" tabindex="-1" role="dialog" aria-labelledby="user" aria-hidden="true">
		<div class="modal-dialog modal-lg" role="document">
		<div class="modal-content">
			<div class="modal-header">
				<h5 class="modal-title text-primary" id="exampleModalLabel">Update Sales Item List</h5>
				<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
			</div>
			<div class="modal-body">
			
<!-- UPDATE FORM -->
			<form enctype="multipart/form-data" action='' method="POST" name="insert" role="form" class="form-horizontal">
			
			<input type="number" hidden name="Previous_qua" value="<?php echo $fetch_siv['issued_qty']; ?>">
			<input type="number" hidden name="item_id" value="<?php echo $it_id; ?>">
			<input type="number" hidden name="unit_purchase_price" value="<?php echo $fetch_siv['unit_purchase_price']; ?>" >
			<input type="number" hidden name="unit_selling_price" value="<?php echo $fetch_siv['unit_selling_price']; ?>" >
	
			<div class="row">
				<div class="col-md-6">
					<input type="text" name="id" value="<?php echo $fetch_siv['id'];?>" hidden></input>
					<div class="row form-group">
						<label for="example-text-input" class="col-sm-4 col-form-label-sm">Sales No</label>
						<div class="col-sm-7">
							<input class="form-control form-control-sm" type="text" value="<?php echo $sno; ?>" name="siv" readonly="">
						</div>
					</div>
					<div class="form-group row">
						<label for="example-text-input" class="col-sm-4 col-form-label-sm">Purchase Price</label>
						<div class="col-sm-7">
							<input class="form-control form-control-sm" type="float" step="any" name="unit_purchase_price" placeholder="Unit Price" value="<?php echo $fetch_siv['unit_purchase_price']; ?>" readonly>
						</div>
					</div>
					<div class="form-group row">
						<label for="example-text-input" class="col-sm-4 col-form-label-sm">Selling Price</label>
						<div class="col-sm-7">
							<input class="form-control form-control-sm" type="float" step="any" name="unit_selling_price" placeholder="Unit Price" value="<?php echo $fetch_siv['unit_selling_price']; ?>" required>
						</div>
					</div>
					<div class="form-group row">
						<label for="example-text-input" class="col-sm-4 col-form-label-sm">Quantity</label>
						<div class="col-sm-7">
							<input class="form-control form-control-sm" type="number" step="any" name="quantity" placeholder="Piece / Kg. / Li." required value="<?php echo $fetch_siv['issued_qty']; ?>">
						</div>
					</div>
				</div>
				<div class="col-md-5">
					<div class="form-group row">
						<label for="example-text-input" class="col-sm-4 col-form-label-sm">Total Price</label>
						<div class="col-sm-8">
							<input class="form-control form-control-sm" type="float" step="any" name="total_price" placeholder="Unit Price" value="<?php echo $fetch_siv['total_price']; ?>" readonly>
						</div>
					</div>
					<div class="form-group row">
						<label for="example-text-input" class="col-sm-4 col-form-label-sm">Date : </label>
						<div class="col-sm-8">
							<input class="form-control form-control-sm" type="date" value="<?php echo $fetch_siv['date']; ?>" name="date_pic" required >
						</div>
					</div>
					<div class="form-group row">
						<label for="example-text-input" class="col-sm-4 col-form-label-sm">Remark</label>
						<div class="col-sm-8">
							<input class="form-control form-control-sm" type="text" name="remark" placeholder="Remark" value="<?php echo $fetch_siv['remark']; ?>">
						</div>
					</div>
					<div class="float-left mx-auto" style="width: 100%; border: 0px solid black;">
						
						<input class="btn btn-success btn-sm col-sm-4" type="submit" name="update" value="Update"> &nbsp&nbsp&nbsp
						<input class="btn btn-danger btn-sm col-sm-4" type="submit" name="close" value="Close">
						
					</div>
				</div>
	
			</div> <a class="text-warning" style="font-size: 12px;">N.B :- to change the Unit_Price you have to delete the row and insert it again</a>
			</form>
			
			</div>
		</div>
		</div>
	</div>
					</td>
					<td>
					<a class="text-danger" href="#" data-toggle="modal" data-target="#delete<?php echo $fetch_siv[0]; ?>">Delete</a>

	<!-- DELETE MODAL -->

	<div class="modal fade " id="delete<?php echo $fetch_siv[0]; ?>" tabindex="-1" role="dialog" aria-labelledby="user" aria-hidden="true">
		<div class="modal-dialog" role="document">
		<div class="modal-content">
			<div class="modal-header">
				<h5 class="modal-title text-danger" id="exampleModalLabel">Remove Sales Item List</h5>
				<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
			</div>
			<div class="modal-body">
			
			<form action='' data-toggle="validator" method="POST" name="newform" role="form" class="form-horizontal">
						
			<input type="number" hidden name="item_id" value="<?php echo $it_id; ?>">
			<input type="number" hidden name="unit_purchase_price" value="<?php echo $fetch_siv['unit_purchase_price']; ?>">
			<input type="number" hidden name="quantity" value="<?php echo $fetch_siv['issued_qty']; ?>">
			
				<div class="container-fluid">
					<div class="row form-group">
						<label for="inputName" class="control-label">Are You Sure to remove &nbsp </label>
						<label for="inputName" class="control-label"><b><?php echo $fetch_item3['name']; ?></b></label>
						
							<input type="text" class="form-control form-control-sm col-6" name="siv_id" id="siv_id" value="<?php echo $fetch_siv['id']; ?>" hidden />
					</div>
					<div class="modal-footer">
						<button type="submit" class="btn btn-primary"  name="remove_siv" > Yes</button>
						<button type="submit" class="btn btn-primary" data-dismiss="modal">No</button>
					</div>
				</div>
			</form>
			</div>
		</div>
		</div>
	</div>

					</td>
				</tr>
			</tbody>
				<?php 	$number = $number +1 ;
					} ?>
		</table>

		<!-- SIV_NO INSERTION BUTTON -->
		<?php
		if($chk_storesno == 0) { ?>
			<form action="" method="post"> <center>
				<button class="btn btn-primary btn sm" name="btn_siv_no" onClick = "this.style.visibility= 'hidden';"> DONE </button>
			</center></form>
		<?php }
		else { ?>
			<form action="" method="post"> <center>
				<button class="btn btn-secondary btn sm" name="btn_edit_sno" onClick = "this.style.visibility= 'hidden';"> Done Edit </button>
			</center></form>
		<?php } ?>
			 
	<?php
	}
		
}
?>

</div>

<!-- COMBO BOX FETCH Category AND ITEM List -->
<script>
$(document).ready(function() {
	$("#store_type").change(function() {
		var store_type_id = $(this).val();
		if(store_type_id != "") {
			$.ajax({
				url:"get-item.php",
				data:{st_id:store_type_id},
				type:'POST',
				success:function(response) {
					var resp = $.trim(response);
					$("#item_name").html(resp);
				}
			});
		} else {
			$("#item_name").html("<option value=''>---- No SIV inserted -----</option>");
		}
	});

	$("#item_name").change(function(){
		var item_id = $(this).val();
		if(item_id !=""){
			$.ajax({
				url:"get_itembalance.php",
				data:{itemID:item_id},
				type:'POST',
				success:function(response){
					var return_curbal = $.trim(response);
						$("#itembal_tbl_id").html(return_curbal);
					}
			});
		} 
		
	});
	/*
	$("#itembal_tbl_id").change(function(){
		var pur = $(this).val();
		if(pur !=""){
			$.ajax({
				url:"get_itembalance.php",
				data:{PUR:pur},
				type:'POST',
				success:function(response){
					var purbal = $.trim(response);
						$("#pur_price").html(purbal);
					}
			});
		} 
		
	});
	*/
	
});
	
</script>	


<!-- PRINT CODE JAVA SCRIPT -->
<script>  
function printfunction(printpage){
		var content=document.getElementById("printpage").innerHTML;

		var header='';
		var footer ="<hr><br><div align='center'> </div>";

		var popupWin = window.open('', '_blank', 'width=595,height=842');
		popupWin.document.open();
		popupWin.document.write('<html><head><style > table { width:80%; border:solid #000 !important; border-width:1px 1px 1px 1px !important; } th, td { border:solid #000 !important; border-width:1px 1px 1px 1px !important; }'+
			'</style><link href="../bootstrap/css/bootstrap.min.css" rel="stylesheet"><link href="../bootstrap/css/dataTables.bootstrap4.min.css" rel="stylesheet">'+
			'</head>  <body style="font-family:Calibri ; font-size:16px; " onload="window.print()">'+ header +'<div align="center1">' +content + '</div></html>' + footer);
		popupWin.document.close(); 
		return false;
}
</script>



<!-- DATE PICKER-->
<script>
	$(function(){
	$("#getlastdate").datepicker(
	{
		dateFormat: 'yy-mm-dd',
		changeMonth:true,
		changeYear:true
	})
	});
</script>


<!-- DATE PICKER-->
<script>
	$(function(){
	$("#getdate").datepicker(
	{
		dateFormat: 'yy-mm-dd',
		changeMonth:true,
		changeYear:true
	}).datepicker('setDate','0');
	});
</script>

	
	
<!-- REVENT RESUBMIT ON REFRESH-->
<script>
if (window.history.replaceState) {
	window.history.replaceState (null, null, window.location.href);
}
</script>

</body>
</html>