#I LOVE YOU EVERDAY#

<?php
session_start();
require("config.php"); 
if(!isset($_SESSION['auser']))
{
	header("location:index.php");
}
///code
date_default_timezone_set('Asia/Kolkata');

$selected_option = $_POST['tran_type'] ?? ''; // Get selected value after post
$error="";
$msg="";
if(isset($_POST['insert']))
{
	$tran_date=$_POST['tran_date'];
	$tran_type=$_POST['tran_type'];
	$mode_of_pay=$_POST['mode_of_pay'] ?? null;
	$bank_name=$_POST['bank_name'] ?? null;
	$cheque_no=$_POST['cheque_no'] ?? 0;
	$issue_bank=$_POST['issue_bank'] ?? null;
	$Instru_date=$_POST['Instru_date'] ?? null;	
	$account_master=$_POST['account_master'];	
	$party_name=$_POST['party_name'];		
	$project_no=$_POST['project_no'] ?? 0;
	$flat_no=$_POST['flat_no'] ?? 0;
	$flat_number=$_POST['flat_number'] ?? 0;
	$flat_value=$_POST['flat_value'] ?? 0;
	$gst=$_POST['gst'] ?? 0;
	$total=$_POST['total'] ?? 0;
	$remarks=$_POST['remarks'];	
	
	
	if(!empty($party_name)){
		$sql="insert into transaction_entry (tran_date,tran_type,mode_of_pay,bank_name,cheque_no,issue_bank,Instru_date,account_master,party_name,project_no,flat_no,flat_number,flat_value,gst,total,remarks) values('$tran_date','$tran_type','$mode_of_pay','$bank_name','$cheque_no','$issue_bank','$Instru_date','$account_master','$party_name','$project_no','$flat_no','$flat_number','$flat_value','$gst','$total','$remarks')";
		$result=mysqli_query($con,$sql);
		if($result)
			{
				$msg="<p class='alert alert-success'>Transaction Inserted Successfully</p>";
						
			}
			else
			{
				$error="<p class='alert alert-warning'>* Transaction Not Inserted</p>";
			}
	}
	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 - Transaction 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">Transaction</h3>
								<ul class="breadcrumb">
									<li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
									<li class="breadcrumb-item active">Transaction</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 Transaction</h1>
									<?php echo $error;?>
									<?php echo $msg;?>
									<?php 
										if(isset($_GET['msg']))	
										echo $_GET['msg'];	
									?>
								</div>
								<form method="post" id="insert product" enctype="multipart/form-data">
									<div class="card-body">
									<h5 class="card-title">Transaction Details</h5>
											<div class="row">
												<div class="col-xl-6">
													<div class="form-group row">
														<label class="col-lg-5 col-form-label">Date of Transaction</label>
														<div class="col-lg-7">
															<input type="date" class="form-control" name="tran_date" value="<?php echo date('Y-m-d'); ?>">
														</div>
													</div>
												</div>
												<div class="col-xl-6">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Type.</label>
														<div class="col-lg-9">
															<select class="form-control" name="tran_type" id="tran_type" onchange="this.form.submit()">
																<option value="">Select Transactipn Type</option>																
																<option value="1" class="text-captalize" <?php if($selected_option == 1){?> selected="selected" <?php } ?>>Payment</option>
																<option value="2" class="text-captalize" <?php if($selected_option == 2){?> selected="selected" <?php } ?>>Receipt</option>																
															</select>
														</div>
													</div>
												</div>
											</div>
											<?php if ($selected_option == '1') { ?>
											<div class="row">
												<div class="col-xl-4">
													<div class="form-group row">
														<label class="col-lg-4 col-form-label">Bank/Cash</label>
														<div class="col-lg-8">
															<select class="form-control" name="mode_of_pay" id="mode_of_pay" onchange="showDivs()">
																<option value="">Select Bank / Cash</option>																
																<option value="1" class="text-captalize">Bank</option>
																<option value="2" class="text-captalize">Cash</option>																
															</select>
														</div>
													</div>
												</div>
												<div class="col-xl-5" id="content" style="display: none;">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Bank Name</label>
														<div class="col-lg-9">
															<select class="form-control" name="bank_name" id="bank_name">
																<option value="">Select</option>
																<?php
																		$query1=mysqli_query($con,"select * from bank_type");
																		while($row1=mysqli_fetch_row($query1))
																			{
																	?>
																<option value="<?php echo $row1['0']; ?>" class="text-captalize"><?php echo $row1['1'] ."--". $row1['3']; ?></option>
																<?php } ?>
															</select>
														</div>
													</div>
												</div>
												<div class="col-xl-3" id="content1" style="display: none;">
													<div class="form-group row">
														<label class="col-lg-5 col-form-label">Cheque No</label>
														<div class="col-lg-7">
															<input type="text" class="form-control" name="cheque_no">
														</div>
													</div>
												</div>
											</div>											
											<div class="row">
												<div class="col-xl-4">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Account Master.</label>
														<div class="col-lg-9">
															<select class="form-control" name="account_master" id="account_master">
																<option value="">Select</option>
																<?php
																		$query1=mysqli_query($con,"SELECT * FROM group_type WHERE gid IN (1, 2, 6, 7, 9, 11) ORDER BY gid");
																		while($row1=mysqli_fetch_row($query1))
																			{
																	?>
																<option value="<?php echo $row1['0']; ?>" class="text-captalize"><?php echo $row1['1']; ?></option>
																<?php } ?>
															</select>
														</div>
													</div>
												</div>
												<div class="col-xl-4">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Party Name</label>
														<div class="col-lg-9">
															<select class="form-control" name="party_name" id="party_name">
																<option value="">Select Party Name</option>
															</select>
														</div>
													</div>
												</div>
												<div class="col-xl-4">
													<div class="form-group row">
														<label class="col-lg-6 col-form-label">Amount(Rs.)</label>
														<div class="col-lg-6">
															<input type="text" class="form-control" name="flat_value" id="flat_value">
														</div>
													</div>
												</div>
											</div>											
											<?php } elseif ($selected_option == '2') { ?>
											<div class="row">
												<div class="col-xl-4">
													<div class="form-group row">
														<label class="col-lg-4 col-form-label">Bank/Cash</label>
														<div class="col-lg-8">
															<select class="form-control" name="mode_of_pay" id="mode_of_pay" onchange="showDivs1()">
																<option value="">Select Bank / Cash</option>																
																<option value="1" class="text-captalize">Bank</option>
																<option value="2" class="text-captalize">Cash</option>																
															</select>
														</div>
													</div>
												</div>
												<div class="col-xl-5" id="content" style="display: none;">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Bank Name</label>
														<div class="col-lg-9">
															<select class="form-control" name="bank_name" id="bank_name">
																<option value="">Select</option>
																<?php
																		$query1=mysqli_query($con,"select * from bank_type");
																		while($row1=mysqli_fetch_row($query1))
																			{
																	?>
																<option value="<?php echo $row1['0']; ?>" class="text-captalize"><?php echo $row1['1'] ."--". $row1['3']; ?></option>
																<?php } ?>
															</select>
														</div>
													</div>
												</div>
												<div class="col-xl-3" id="content1" style="display: none;">
													<div class="form-group row">
														<label class="col-lg-5 col-form-label">Cheque No</label>
														<div class="col-lg-7">
															<input type="text" class="form-control" name="cheque_no">
														</div>
													</div>
												</div>
											</div>
											<div class="row">												
												<div class="col-xl-6" id="content2" style="display: none;">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Bank</label>
														<div class="col-lg-9">
															<input type="text" class="form-control" name="issue_bank">
														</div>
													</div>
												</div>
												<div class="col-xl-6" id="content3" style="display: none;">
													<div class="form-group row">
														<label class="col-lg-4 col-form-label">Instrument Date</label>
														<div class="col-lg-8">
															<input type="date" class="form-control" name="Instru_date">
														</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">Account Master.</label>
														<div class="col-lg-9">
															<select class="form-control" name="account_master" id="account_master">
																<option value="">Select</option>
																<?php
																		$query1=mysqli_query($con,"SELECT * FROM group_type WHERE gid IN (3) ORDER BY gid");
																		while($row1=mysqli_fetch_row($query1))
																			{
																	?>
																<option value="<?php echo $row1['0']; ?>" class="text-captalize"><?php echo $row1['1']; ?></option>
																<?php } ?>
															</select>
														</div>
													</div>
												</div>
												<div class="col-xl-6">
													<div class="form-group row">
														<label class="col-lg-3 col-form-label">Party Name</label>
														<div class="col-lg-9">
															<select class="form-control" name="party_name" id="party_name">
																<option value="">Select Party Name</option>
															</select>
														</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">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 echo $row1['1'] ."--". $row1['3']; ?></option>
																<?php } ?>
															</select>
														</div>
													</div>
												</div>
												<div class="col-xl-3">
													<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>
														</div>
													</div>
												</div>
												<div class="col-xl-3">
													<div class="form-group row">
														<label class="col-lg-5 col-form-label">Flat No.</label>
														<div class="col-lg-7">
															<select class="form-control" name="flat_number" id="flat_number">
																<option value="">Select Flat No.</option>
															</select>
														</div>
													</div>
												</div>
											</div>
											<div class="row">												
												<div class="col-xl-4">
													<div class="form-group row">
														<label class="col-lg-6 col-form-label">Amount(Rs.)</label>
														<div class="col-lg-6">
															<input type="text" class="form-control" name="flat_value" id="flat_value">
														</div>
													</div>
												</div>
												<div class="col-xl-4">
													<div class="form-group row">
														<label class="col-lg-6 col-form-label">GST Amount</label>
														<div class="col-lg-6">
															<input type="text" class="form-control" name="gst" id="gst" readonly>
														</div>
													</div>
												</div>
												<div class="col-xl-4">
													<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>
														</div>
													</div>
												</div>
											</div>
											<?php } ?>
											<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"></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>
							</div>
						</div>
					</div>
				
				
				
				<div class="row">
						<div class="col-sm-12">
							<div class="card">
								<div class="card-header">
									<h4 class="card-title">Tesnsaction List for Customers</h4>
									
								</div>
								<div class="card-body">

<table id="basic-datatable" class="table table-bordered table-hover">
                                            <thead>
                                                <tr>
                                                    <th>#</th>
                                                    <th>Date</th>
													<th>Transaction Type</th>		
													<th>Payment Mode</th>	
													<th>Master Data</th>
													<th>Customer name</th>													
													<th>Amount(Rs.)</th>													
													<th>Remarks</th>
													<th>Actions</th>
                                                </tr>
                                            </thead>
                                        
                                        
                                            <tbody>
											<?php
													
												$query=mysqli_query($con,"select * from  transaction_entry");
												$cnt=1;
												while($row=mysqli_fetch_row($query))
													{
														if($row['2'] == 1){
															$transaction = 'Payment';
														} else {
															$transaction = 'Receipt';
														}
														if($row['3'] == 1){
															$mod = 'Bank';
														} else {
															$mod = 'Cash';
														}
														$query2=mysqli_query($con,"select * from group_type where gid = '" . $row['8'] . "'");
															while($row2=mysqli_fetch_row($query2))
																{
																	$masterdata = $row2['1'];
																	$database = basename($row2['2'], ".php"); // Outputs: index
																	if($database == 'advance_receive'){
																		$id = 'adrid';
																	} else if($database == 'rent'){
																		$id = 'reid';
																	} else if($database == 'advance'){
																		$database = 'advanced';
																		$id = 'adid';
																	} else if($database == 'labour'){
																		$id = 'lid';
																	} else if($database == 'suppliers'){
																		$id = 'sid';
																	} else if($database == 'agent'){
																		$id = 'aid';
																	} else {
																		$id = 'exid';
																	}
																	
																	$query3=mysqli_query($con,"select * from " . $database . " where " . $id . " = '" . $row['9'] . "'");
																	while($row3=mysqli_fetch_row($query3))
																		{
																			$customer_name = $row3['1'];
																		}
																}
											?>
                                                <tr>
                                                    
                                                    <td><?php echo $cnt; ?></td>
                                                    <td><?php echo $row['1']; ?></td>													
													<td><?php echo $transaction; ?></td>
													<td><?php echo $mod; ?></td>
													<td><?php echo $masterdata; ?></td>
													<td><?php echo $customer_name; ?></td>
													<td><?php echo $row['13']; ?></td>
													<td><?php echo $row['16']; ?></td>
													<td><a href="transaction_entry_edit.php?id=<?php echo $row['0']; ?>&type=<?php echo $row['2']; ?>"><img src="edit-icon.png" alt="Edit" width="20" height="20"></a>
													<a href="<?php if($row['2'] == 1) { ; ?>print_payment.php<?php } else { ?>print_receipt.php<?php } ?>?id=<?php echo $row['0']; ?>&type=<?php echo $row['2']; ?>" target="_blank"><img src="printer.png" alt="Edit" width="20" height="20"></a>
                                                    <a href="#.php?id=<?php echo $row['0']; ?>"><img src="red-trash-can-icon.png" alt="Delete" width="20" height="20"></a></td>
                                                </tr>
                                                <?php $cnt=$cnt+1; } ?>

</tbody>
                                        </table>
								</div>
							</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_number').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);
		});
		
		$("#account_master").change(function() {
            var selectedValue = $(this).val(); // Get the selected value

// Use jQuery AJAX to send the data to the server
			$.ajax({
                    type:'POST',
                    url:'get_name.php', // PHP file to fetch states
                    data:{ selected_option: selectedValue },
                    success:function(html){
                        $('#party_name').html(html);
                    }
                });
        });
    </script>
	<script>
	function showDivs() {
	  var selectElement = document.getElementById("mode_of_pay");
	  var divElement = document.getElementById("content");
	  var divElement1 = document.getElementById("content1");
	  var selectedValue = selectElement.value; // Get the selected option's value

// Check the selected value and set the display style accordingly
	  if (selectedValue === "1") {
		divElement.style.display = "block"; // Or "flex", "inline-block", etc.
		divElement1.style.display = "block"; // Or "flex", "inline-block", etc.
	  } else {
		divElement.style.display = "none";
		divElement1.style.display = "none";
	  }
	}
	
	function showDivs1() {
	  var selectElement = document.getElementById("mode_of_pay");
	  var divElement = document.getElementById("content");
	  var divElement1 = document.getElementById("content1");
	  var divElement2 = document.getElementById("content2");
	  var divElement3 = document.getElementById("content3");
	  var selectedValue = selectElement.value; // Get the selected option's value

// Check the selected value and set the display style accordingly
	  if (selectedValue === "1") {
		divElement.style.display = "block"; // Or "flex", "inline-block", etc.
		divElement1.style.display = "block"; // Or "flex", "inline-block", etc.
		divElement2.style.display = "block"; // Or "flex", "inline-block", etc.
		divElement3.style.display = "block"; // Or "flex", "inline-block", etc.
	  } else {
		divElement.style.display = "none";
		divElement1.style.display = "none";
		divElement2.style.display = "none";
		divElement3.style.display = "none";
	  }
	}

</script>
    </body>
</html>