<?php
	include'session.php';
	include'../connection.php';
	include'../functions.php';
?>
<html>
<head>
	<title>Edit Lapu</title>
	<!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    
	<link rel="icon" href="images/logo.png" type="image/gif" sizes="16x16">
	
	<!-- Admin CSS File Link -->
	<link rel="stylesheet" href="css/style.css">
	
	<!-- User JAVA SCRIPT File Link -->
	<script type="text/javascript" src="js/script.js"></script>

	
	<!-- Font Awesome Icone -->
	<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
	
	<style>
		.div1{
			background:#f7f7f7;
			width:50%;
			height:500px;
			float:left;
			text-align:center;
		}
		.subDiv1{
			background:#6b5127;
			color:white;
			width:30%;
			height:40px;
			line-height:40px;
			margin:15px 0px 0px 10px;
			border-radius:;
			font-size:17px;
			float:left;
		}
		.subDiv1Add{
			background:#6b5127;
			color:white;
			width:30%;
			height:100px;
			line-height:100px;
			margin:10px 0px 10px 10px;
			border-radius:;
			font-size:17px;
			float:left;
		}
		.subDiv2{
			color:white;
			width:64%;
			height:40px;
			line-height:40px;
			margin:15px 0px 0px 0px;
			border-radius:;
			font-size:19px;
			float:left;
		}
		
		.subDiv2Add{
			color:white;
			width:64%;
			height:100px;
			line-height:100px;
			margin:10px 0px 10px 0px;
			border-radius:;
			font-size:19px;
			float:left;
		}
		.div1 input, .div1 select, .div1 p{
			color:black;
			text-align:left;
			width:100%;
			height:40px;
			margin:0px;
			padding:2px 10px;
			border:1px solid #6b5127;
			font-size:17px;
		}
		input[type=file]
		{
			border:none;
		}
		.div1 textarea{
			width:100%;
			height:100px;
			padding:2px 10px;
			border:1px solid #6b5127;
			font-size:19px;
		}
		.divImg{
			background:white;
			width:94%;
			height:100px;
			margin:15px 10px;
			padding:8px;
			border:1px solid #6b5127;
			font-size:19px;
			text-align:left;
		}
		.divImg img{
			width:19%;
			height:80px;
			float:left;
		}
		.divImg input{
			width:70%;
			float:right;
			font-size:15px;
		}
		input[type=submit]{
			background:#6b5127;
			width:94%;
			margin:15px 10px 10px 0px;
			padding:2px;
			color:white;
			font-size:25px;
			transition:1s;
			text-align:center;
		}
		input[type=submit]:hover{
			background:white;
			color:#6b5127;
			border:1px solid #6b5127;
			cursor:pointer;
			transition:1s;
		}
		
		@media(max-width:768px)
		{
			.div1{
				width:100%;
				height:auto;
			}
			.nav,.container{
				height:auto;
			}
			.subDiv1{width:35%; font-size:15px;}
			.subDiv2{width:59%; font-size:15px;}
			.subDiv1Add{width:35%; font-size:15px;}
			.subDiv2Add{width:59%; font-size:15px;}
			input[type=submit]{width:94%; margin:15px 2%;}
		}
	</style>
	
	<link rel="stylesheet" href="css/mediaStyle.css">
</head>
<body>
	<!--Header Divison-->
	<?php
		require'header.php';
	?>
	
	<!--Container Division-->
	<div class="container">
	    <?php
			include'menu.php';
			$LapuId = $_GET['LapuId'];
			
			$IJsfNsl  = "INNER JOIN seller_firm ON seller_firm.Id=seller_lapu.FirmId";
			$data_sl  = "seller_lapu.Id, seller_lapu.LapuNo, seller_lapu.SellerId, seller_lapu.FirmId, seller_lapu.LapuType, seller_lapu.LapuBal,";
			$data_sf  = "seller_firm.FirmName";
			$quLapu   = "SELECT $data_sl $data_sf FROM seller_lapu $IJsfNsl WHERE seller_lapu.Id='$LapuId'";
			$reLapu   = mysqli_query($con,$quLapu);
			$dataLapu = mysqli_fetch_array($reLapu);
			$LapuNo   = $dataLapu['LapuNo'];
			$SellerId = $dataLapu['SellerId'];
			$FirmId   = $dataLapu['FirmId'];
			$LapuType = $dataLapu['LapuType'];
			$LapuBal  = $dataLapu['LapuBal'];
			$FirmName = $dataLapu['FirmName'];
			
			
			if(isset($_POST['submit']))
			{
			    $Seller = $_POST['Seller'];
			    $firm   = $_POST['firm'];
			    $Lapu   = $_POST['Lapu'];
			    $Type   = $_POST['Type'];
			    $Bal    = $_POST['Bal'];
				    
			    $quUpdate = "UPDATE seller_lapu SET SellerId='$Seller', FirmId='$firm', LapuNo='$Lapu', LapuType='$Type', LapuBal='$Bal' WHERE Id='$LapuId'";
			    if(mysqli_query($con,$quUpdate))
			    {
			        echo "<div class='msg-div'>
				        <form method='post'>
					        <h3>Lapu Updated Successfully !</h3><br>
					        <i class='fa fa-check-circle' aria-hidden='true' id='okIcon'></i><br><br>
					        <button type='submit' class='btnPopup'>OK</button><br><br>
				        </form>
		            </div>";
				}
				else
				{
				    echo "<div class='msg-div'>
			            <form method='post'>
				            <h3>Something Error !</h3><br>
				            <i class='fa fa-ban' aria-hidden='true' id='NotokIcon'></i><br><br>
				            <button type='submit' class='btnPopup'>OK</button><br><br>
			            </form>
		            </div>";
				}
			}	
			   
		?>
		<script>
			        function sellerFirm()
			        {
			            var AjaxName      = "Ajax8";
			            var Progtype      = "";
			            var sellerid      = document.getElementById("sellerid").value;
						var xmlhttpSeller = new XMLHttpRequest();
						xmlhttpSeller.open("GET","Ajax.php?AjaxName="+AjaxName+"&Progtype="+Progtype+"&sellerid="+sellerid, false)
						xmlhttpSeller.send(null);
						alert(xmlhttpSeller.responseText);
						document.getElementById("firmPlace").innerHTML = xmlhttpSeller.responseText;
			        }
		</script>
				
		<div class="content">
			<div class="head">
				<div class="title"><p>Edit Lapu :-</p></div>
				<div class="msg"><marquee><?php include'../msg.php'; ?></marquee></msg>
			</div><hr>
			<div class="data-content">
				<form method="post" enctype="multipart/form-data">
					<div class="div1">
						<div class="subDiv1">Lapu Id. : </div><div class="subDiv2"><p><?php echo $LapuId; ?></p></div>
						<div class="subDiv1">Lapu No. : </div><div class="subDiv2"><input type="text" name="Lapu" value="<?php echo $LapuNo; ?>"></div>
						<div class="subDiv1">Seller : </div>
						    <div class="subDiv2">
						        <select name='Seller' onchange="sellerFirm()" id="sellerid">
						            <option>--Select Seller--</option>
						        <?php
						            $quSeller="SELECT * FROM Seller WHERE Status='ACTIVE'";
						            $reSeller=mysqli_query($con,$quSeller);
						            while($dataSeller=mysqli_fetch_array($reSeller))
						            {
						                if($dataSeller['Id']==$SellerId)
						                {
						                    echo"<option value='".$dataSeller['Id']."' selected>".$dataSeller['Name']."- ".$dataSeller['City']."</option>";
						                }
						                else
						                {
						                    echo"<option value='".$dataSeller['Id']."' >".$dataSeller['Name']."- ".$dataSeller['City']."</option>";
						                }
						            }
						        ?>
						        </select>
						</div>
						<div class="subDiv1">Firm : </div>
						    <div class="subDiv2">
						        <select name='firm' id='firmPlace'>
						            <option><?php echo $FirmName; ?></option>
						        </select>
						</div>
						<div class="subDiv1">Lapu Type : </div><div class="subDiv2"><input type="text" name="Type" value="<?php echo $LapuType; ?>"></div>
						<div class="subDiv1">Lapu Bal : </div><div class="subDiv2"><input type="text" name="Bal" value="<?php echo $LapuBal; ?>"></div>
						<div class="subDiv2"><input type="submit" name="submit" value="Submit"  onclick='showLoader()'></div>
					</div>
				</form>
			</div>
		</div>
	</div>
	<?php
		require'footer.php';
	?>
</body>
</html>