#I LOVE YOU EVERDAY#

<?php
session_start();
require("config.php"); 
if(!isset($_SESSION['auser']))
{
	header("location:index.php");
}
///code
$error="";
$msg="";
if(isset($_POST['insert']))
{
	$adrid = $_GET['id'];
	
	$name=$_POST['name'];
	$address=$_POST['address'];
	$email=$_POST['email'];
	$phone=$_POST['phone'];
	$date=$_POST['date'];	
	$project_no=$_POST['project_no'];
	$flat_no=$_POST['flat_no'];
	$flat_id=$_POST['flat_id'];
	$flat_value=$_POST['flat_value'];
	$gst=$_POST['gst'];
	$total=$_POST['total'];
	$remarks=$_POST['remarks'];	
	
	
	if(!empty($name)){
		$sql="UPDATE advance_receive SET name = '{$name}' ,address = '{$address}',email = '{$email}',phone = '{$phone}',date = '{$date}',project_no = '{$project_no}',flat_no = '{$flat_no}',flat_id = '{$flat_id}',flat_value = '{$flat_value}',gst = '{$gst}',total = '{$total}',remarks = '{$remarks}' WHERE adrid = {$adrid}";
		$result=mysqli_query($con,$sql);
		if($result)
			{
				$msg="<p class='alert alert-success'>Advance Received Updated Successfully</p>";
				header("Location:advance_receive.php?msg=$msg");
						
			}
			else
			{
				$error="<p class='alert alert-warning'>*Advance Received Not Updated</p>";
				header("Location:advance_receive.php?msg=$error");
			}
	}
	else{
		$error = "<p class='alert alert-warning'>* Fill all the Fields</p>";
	}
	
}
?>
<!DOCTYPE html>
<html lang="en">

<head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">
        <title>SRHousing - Advance Received List Tables</title>
		
		
        <link rel="shortcut icon" type="image/x-icon" href="assets/img/favicon.png">
		
		
        <link rel="stylesheet" href="assets/css/bootstrap.min.css">
		
		
        <link rel="stylesheet" href="assets/css/font-awesome.min.css">
		
		
        <link rel="stylesheet" href="assets/css/feathericon.min.css">
		
		
		<link rel="stylesheet" href="assets/plugins/datatables/dataTables.bootstrap4.min.css">
		<link rel="stylesheet" href="assets/plugins/datatables/responsive.bootstrap4.min.css">
		<link rel="stylesheet" href="assets/plugins/datatables/select.bootstrap4.min.css">
		<link rel="stylesheet" href="assets/plugins/datatables/buttons.bootstrap4.min.css">
		
		
        <link rel="stylesheet" href="assets/css/style.css">
		
		
    </head>
    <body>

<?php include("header.php");?>	
			
			
			
            <div class="page-wrapper">
                <div class="content container-fluid">

<div class="page-header">
						<div class="row">
							<div class="col">
								<h3 class="page-title">Advance Received</h3>
								<ul class="breadcrumb">
									<li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
									<li class="breadcrumb-item active">Advance Received</li>
								</ul>
							</div>
						</div>
					</div>
					
					
				 
					<div class="row">
						<div class="col-md-12">
							<div class="card">
								<div class="card-header">
									<h1 class="card-title">Add Advance Received</h1>
									<?php echo $error;?>
									<?php echo $msg;?>
									<?php 
										if(isset($_GET['msg']))	
										echo $msg;	
									?>
								</div>
								<?php 
								$adrid = $_GET['id'];
								$sql = "SELECT * FROM advance_receive where adrid = {$adrid}";
								$result = mysqli_query($con, $sql);
								while($row = mysqli_fetch_row($result))
								{
								?>
								<form method="post" id="insert product" enctype="multipart/form-data">
									<div class="card-body">
									<h5 class="card-title">Advance Received Details</h5>
											<div class="row">
												<div class="col-xl-6">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Advance Received Name</label>
														<div class="col-lg-9">
															<input type="text" class="form-control" name="name" value="<?php echo $row['1']; ?>">
														</div>
													</div>
												</div>
												<div class="col-xl-6">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Address</label>
														<div class="col-lg-9">
															<input type="text" class="form-control" name="address" value="<?php echo $row['2']; ?>">
														</div>
													</div>
												</div>
											</div>
											<div class="row">
												<div class="col-xl-6">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Email ID</label>
														<div class="col-lg-9">
															<input type="text" class="form-control" name="email" value="<?php echo $row['3']; ?>">
														</div>
													</div>
												</div>
												<div class="col-xl-6">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Phone</label>
														<div class="col-lg-9">
															<input type="text" class="form-control" name="phone" value="<?php echo $row['4']; ?>">
														</div>
													</div>
												</div>
											</div>
											<div class="row">
												<div class="col-xl-6">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Date of Advance Received</label>
														<div class="col-lg-9">
															<input type="date" class="form-control" name="date" value="<?php echo $row['5']; ?>">
														</div>
													</div>
												</div>
												<div class="col-xl-6">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Project No.</label>
														<div class="col-lg-9">
															<select class="form-control" name="project_no" id="project_no">
																<option value="">Select</option>
																<?php
																		$query1=mysqli_query($con,"select * from project_master");
																		while($row1=mysqli_fetch_row($query1))
																			{
																	?>
																<option value="<?php echo $row1['0']; ?>" class="text-captalize" <?php if($row1['0'] == $row['6']){?> selected="selected" <?php } ?>><?php echo $row1['1'] ."--". $row1['3']; ?></option>
																<?php } ?>
															</select>
														</div>
													</div>
												</div>
											</div>
											<div class="row">
												<div class="col-xl-3" style="display: none;">
													<div class="form-group row">
														<label class="col-lg-6 col-form-label">Total Flats</label>
														<div class="col-lg-6">
															<input type="text" class="form-control" name="flat_no" id="flat_no" readonly value="<?php echo $row['7']; ?>">
														</div>
													</div>
												</div>
												<div class="col-xl-3">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Flat No.</label>
														<div class="col-lg-9">
															<select class="form-control" name="flat_id" id="flat_id">
																<option value="">Select Flat No.</option>
																<?php
																		$query3=mysqli_query($con,"select * from flat_master");
																		while($row3=mysqli_fetch_row($query3))
																			{
																	?>
																<option value="<?php echo $row3['0']; ?>" class="text-captalize" <?php if($row3['0'] == $row['8']){?> selected="selected" <?php } ?>><?php echo $row3['1']; ?></option>
																<?php } ?>
															</select>
														</div>
													</div>
												</div>
												<div class="col-xl-3">
													<div class="form-group row">
														<label class="col-lg-6 col-form-label">Amount</label>
														<div class="col-lg-6">
															<input type="text" class="form-control" name="flat_value" id="flat_value" value="<?php echo $row['9']; ?>">
														</div>
													</div>
												</div>
												<div class="col-xl-3">
													<div class="form-group row">
														<label class="col-lg-6 col-form-label">GST(1%)</label>
														<div class="col-lg-6">
															<input type="text" class="form-control" name="gst" id="gst" readonly value="<?php echo $row['10']; ?>">
														</div>
													</div>
												</div>
												<div class="col-xl-3">
													<div class="form-group row">
														<label class="col-lg-6 col-form-label">Total Amount</label>
														<div class="col-lg-6">
															<input type="text" class="form-control" name="total" id="total" readonly value="<?php echo $row['11']; ?>">
														</div>
													</div>
												</div>
											</div>
											<div class="row">
												<div class="col-xl-12">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Remarks</label>
														<div class="col-lg-9">
															<textarea id="remarks" name="remarks" class="form-control" rows="4" cols="150"><?php echo $row['12']; ?></textarea>
														</div>
													</div>
												</div>												
											</div>
											<div class="text-left">
												<input type="submit" class="btn btn-primary"  value="Submit" name="insert" style="margin-left:200px;">
											</div>
									</div>
								</form>
								<?php } ?>								
							</div>
						</div>
					</div>
				
				
				
				
				
				</div>			
			</div>

<script src="assets/js/jquery-3.2.1.min.js"></script>
		
		
        <script src="assets/js/popper.min.js"></script>
        <script src="assets/js/bootstrap.min.js"></script>
		
		
        <script src="assets/plugins/slimscroll/jquery.slimscroll.min.js"></script>
		
		
		
		<script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>
		<script src="assets/plugins/datatables/dataTables.bootstrap4.min.js"></script>
		<script src="assets/plugins/datatables/dataTables.responsive.min.js"></script>
		<script src="assets/plugins/datatables/responsive.bootstrap4.min.js"></script>
		
		<script src="assets/plugins/datatables/dataTables.select.min.js"></script>
		
		<script src="assets/plugins/datatables/dataTables.buttons.min.js"></script>
		<script src="assets/plugins/datatables/buttons.bootstrap4.min.js"></script>
		<script src="assets/plugins/datatables/buttons.html5.min.js"></script>
		<script src="assets/plugins/datatables/buttons.flash.min.js"></script>
		<script src="assets/plugins/datatables/buttons.print.min.js"></script>
		
		
		<script  src="assets/js/script.js"></script>
		<script>
        // Attach a change event listener to the select element
        $("#project_no").change(function() {
            var selectedValue = $(this).val(); // Get the selected value

// Use jQuery AJAX to send the data to the server
			if(selectedValue){
            $.ajax({
                url: 'submit_data.php', // The server-side script URL
                type: 'POST', // Use the POST method
                data: {
                    optionValue: selectedValue,                    
                }, // Data to send
                success: function(response) {
                    // This function runs on a successful AJAX request
                    $("#flat_no").val(response);
					$("#flat_value").val(0);
					$("#gst").val(0);
					$("#total").val(0);
					
                    console.log("Success:", response);
                },
                error: function(error) {
                    // This function runs if the AJAX request fails
                    $("#flat_no").val("Nil");
                    console.log("Error:", error);
                }
            });

$.ajax({
                    type:'POST',
                    url:'get_flats.php', // PHP file to fetch states
                    data:{ selected_option: selectedValue },
                    success:function(html){
                        $('#flat_id').html(html);
                    }
                });
			}
        });
		$("#flat_value").on("input", function(){
		// Get the value and convert to a number
		var value = parseFloat($(this).val());
		var flat_no = parseFloat($("#flat_no").val());
						
		// Check if value is above 100
		if(value >= 4500000 || flat_no > 12) {
				$("#gst").val(value * 5/100);
				//$("#total").val(gst + value);
			} else {
				// Optional: Clear or reset if value is 100 or less
				$("#gst").val(value * 1/100);
				//$("#gst").val(0);
			}
			var gst = parseFloat($("#gst").val());
			$("#total").val(gst + value);
		});
					
    </script>
    </body>
</html>