<?php
include 'load.php';
?>



<!DOCTYPE html>

<html lang="en">



<head>



	<meta charset="utf-8">

	<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">

	<meta name="description" content="POS - Eat More Resturant   | Pos & Invetory System | Dashboard">

	<meta name="keywords" content="Eat More Resturant   | Pos & Invetory System | Dashboard">

	<meta name="author" content="Eat More Resturant   | Pos & Invetory System | Dashboard">

	<meta name="robots" content="noindex, nofollow">



	<title>Credit Update Report | Eat More Resturant   | Pos & Invetory System | Dashboard</title>



	<?php

	require_once 'headercss.php';

	?>



</head>



<body>



	<div class="main-wrapper">

		<?php

		require_once 'header.php';

		?>



		<?php

		require_once 'navbar.php';

		?>



		<div class="page-wrapper">

			<div class="content">

				<div class="page-header">

					<div class="page-title">

						<h4>Credit Update Report</h4>

						<h6>Manage your Credit</h6>

					</div>

				</div>



				<div class="card">

					<div class="card-body">

						<div class="table-top">

							<div class="search-set">

								<div class="search-path">

									<a class="btn btn-filter" id="filter_search">

										<img src="assets/img/icons/filter.svg" alt="img">

										<span><img src="assets/img/icons/closes.svg" alt="img"></span>

									</a>

								</div>

								<div class="search-input">

									<a class="btn btn-searchset"><img src="assets/img/icons/search-white.svg"

											alt="img"></a>

								</div>

							</div>

							<div class="wordset">

								<ul>

									<li>

										<a data-bs-toggle="tooltip" href="export_sales_report.php"

											data-bs-placement="top" title="excel"><img src="assets/img/icons/excel.svg"

												alt="img"></a>

									</li>

									<li>

										<a data-bs-toggle="tooltip" data-bs-placement="top" title="print"

											onclick="printDiv('printableArea')"><img src="assets/img/icons/printer.svg"

												alt="img"></a>

									</li>

								</ul>

							</div>

						</div>



						<div class="card mb-0" id="filter_inputs" style="display:block;">

							<div class="card-body pb-0">

								<div class="row">

									<div class="col-lg-12 col-sm-12">

										<form method="get" enctype="multipart/form-data">

											<div class="row">

												<div class="col-lg-3 col-sm-6 col-12">

													<div class="form-group">

														<label for="start-date">Start Date:</label>

														<input type="date" id="start-date" name="start_date"

															class="form-control">

													</div>

												</div>

												<div class="col-lg-3 col-sm-6 col-12">

													<div class="form-group">

														<label for="end-date">End Date:</label>

														<input type="date" id="end-date" name="end_date"

															class="form-control">

													</div>

												</div>

                                                <div class="col-lg-3 col-sm-6 col-12">

													<div class="form-group">

														<label for="end-date">Customer</label>

														<select class="form-control select2" id="customer" name="customer">

                                                                <option value="">Select Customer</option>

                                                                <?php

                                                                $cus2 = "SELECT * FROM mobilecustomers WHERE status=1";

                                                                $result = $conn->query($cus2);

                                                                if ($result->num_rows > 0) {

                                                                    while ($row = $result->fetch_assoc()) {

                                                                        $coid = $row["coid"];

                                                                        echo $cname = $row["cname"];

                                                                        $cphone = $row["cphone"];

                                                                        echo '<option value="' . $coid . '">' . $cname . ' | ' . $cphone . '</option>';

                                                                    }

                                                                }

                                                                //$conn->close();

                                                                ?>

				</select>

													</div>

												</div>

												<div class="col-lg-1 col-sm-6 col-12">

													<div class="form-group">

														<button type="submit" style="margin-top:30px;"

															class="btn btn-filters ms-auto">

															<img src="assets/img/icons/search-whites.svg" alt="img">

														</button>

													</div>

												</div>

											</div>

										</form>



									</div>

								</div>

							</div>

						</div>

                        <div class="table-responsive">

							<table class="table" id="betable">

								<thead>

									<tr>

										<th>#ID</th>

										<th>Customer</th>

										<th>Amount</th>

										<th>Date</th>

										

									</tr>

								</thead>

								<tbody>

                                    <?php  

                                    if(!empty($_GET['start_date']) && !empty($_GET['end_date'])){

                                        $startdate = $_GET['start_date'];

                                        $enddate = $_GET['end_date'];

                                        $datechage = "AND mobile_credit_payments.added_date BETWEEN '$startdate' AND '$enddate'";

                                    }else{

                                        $datechage = "";

                                    }

                                    if(!empty($_GET['customer'])){

                                        $customer = $_GET['customer'];

                                       

                                        $customerchage = "AND mobile_credit_payments.customer_id='$customer'";

                                    }else{

                                        $customerchage = "";

                                    }

                                    

									if(!empty($_GET['start_date']) && !empty($_GET['end_date']) || !empty($_GET['customer'])){

                                    $rs = mysqli_query($conn, "SELECT * FROM mobile_credit_payments,mobilecustomers WHERE mobile_credit_payments.customer_id=mobilecustomers.coid $datechage $customerchage"); 

                                        if ($rs->num_rows > 0) {

                                            while($row = $rs->fetch_assoc()) { ?>

                                             <tr>

                                                <td><?php echo $row['credit_payment_id']; ?></td>

                                                <td><?php echo $row['cname']; ?></td>

                                                <td><?php echo $row['amount']; ?></td>

                                                <td><?php echo $row['added_date']; ?></td>

                                             </tr>           

                                         <?php }

                                        }

									}

                                    ?>

                                </tbody>

                            </table>

                        </div>

						



                        <div id="printableArea" style="display:none;">

                        <table class="table  datanew">

								<thead>

									<tr>

										<th>#ID</th>

										<th>Customer</th>

										<th>Amount</th>

										<th>Date</th>

										

									</tr>

								</thead>

								<tbody>

                                    <?php  

                                    if(!empty($_GET['start_date']) && !empty($_GET['end_date'])){

                                        $startdate = $_GET['start_date'];

                                        $enddate = $_GET['end_date'];

                                        $datechage = "AND mobile_credit_payments.added_date BETWEEN '$startdate' AND '$enddate'";

                                    }else{

                                        $datechage = "";

                                    }

                                    if(!empty($_GET['customer'])){

                                        $customer = $_GET['customer'];

                                       

                                        $customerchage = "AND mobile_credit_payments.customer_id='$customer'";

                                    }else{

                                        $customerchage = "";

                                    }

                                    

                                    if(!empty($_GET['start_date']) && !empty($_GET['end_date']) || !empty($_GET['customer'])){

										$rs = mysqli_query($conn, "SELECT * FROM mobile_credit_payments,mobilecustomers WHERE mobile_credit_payments.customer_id=mobilecustomers.coid $datechage $customerchage"); 

											if ($rs->num_rows > 0) {

												while($row = $rs->fetch_assoc()) { ?>

												 <tr>

													<td><?php echo $row['credit_payment_id']; ?></td>

													<td><?php echo $row['cname']; ?></td>

													<td><?php echo $row['amount']; ?></td>

													<td><?php echo $row['added_date']; ?></td>

												 </tr>           

											 <?php }

											}

										}

                                    ?>

                                </tbody>

                            </table>

                        </div>































						</div>

					</div>

				</div>



			</div>

		</div>

	</div>



	<script>

		function printDiv(printableArea) {



			var printContents = document.getElementById(printableArea).innerHTML;

			var originalContents = document.body.innerHTML;



			document.body.innerHTML = printContents;



			window.print();



			document.body.innerHTML = originalContents;



		}

	</script>

	<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>

	<script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.1.0-rc.0/js/select2.min.js"></script>



	<script>

	// Initialize Select2 plugin with typing search functionality

	$('.select2').select2();

	</script>

	

	<script data-cfasync="false" src="../../cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script>

							

	<script src="assets/js/jquery-3.6.0.min.js"></script>



	<script src="assets/js/feather.min.js"></script>



	<script src="assets/js/jquery.slimscroll.min.js"></script>



	<script src="assets/js/jquery.dataTables.min.js"></script>

	<script src="assets/js/buttons.dataTables.js"></script>

	<script src="assets/js/dataTables.bootstrap4.min.js"></script>



	<script src="assets/js/bootstrap.bundle.min.js"></script>



	<script src="assets/js/moment.min.js"></script>

	<script src="assets/js/bootstrap-datetimepicker.min.js"></script>

	<script src="assets/js/pdfmake.min.js"></script>

	<script src="assets/plugins/select2/js/select2.min.js"></script>

	<script src="assets/js/vfs_fonts.js"></script>



	<script src="assets/plugins/sweetalert/sweetalert2.all.min.js"></script>

	<script src="assets/plugins/sweetalert/sweetalerts.min.js"></script>

	<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>

	<script src="assets/js/dataTables.buttons.min.js"></script>

	<script src="assets/js/jszip.min.js"></script>

	<script src="assets/js/buttons.html5.min.js"></script>

	<script src="assets/js/script.js"></script>

	

	<link href="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/toastr.min.css" rel="stylesheet">

    <script src="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/toastr.min.js"></script>



	<script>

		



		$(document).ready( function() {

			$('#betable').DataTable({

        dom: 'Bfrtip', 

        buttons: [

            'copy', 

            'csv',  

            {

                extend: 'excelHtml5', 

                customize: function(xlsx) {

                    var sheet = xlsx.xl.worksheets['sheet1.xml']; 

                    $('row c[r^="C"]', sheet).attr('s', '2'); 

                }

            },

            'pdf',  

            'print' 

        ]

    });

	} );

	</script>

	

	<style>

	#betable_filter{

		margin-bottom: 20px;

	}

	</style>

</body>



</html>