<?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>Payment 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>Payment Report</h4>

						<h6>Manage your Payments</h6>

					</div>

				</div>



				<div class="card">

					<div class="card-body">

						<div class="table-top">



						</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 style="font-weight:bold;color:#000000;">Payment Option</label>

                                                    <select class="form-select" id="cash_type" name="paymentmethod">

                                                        <option value="cash">Cash</option>

                                                        <option value="credit">Credit</option>

                                                        <option value="card">Card</option>

                                                        <option value="banktransfer">Bank Transfer</option>

                                                        <option value="cheques">Cheques</option>

                                                    </select>

													</div>

												</div>-->

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

													<div class="form-group">

														<div class="form-group">

														<button type="submit" name="search" class="btn btn-block btn-outline-success active btn-md text-white" style="margin-top:33px;width:100%;" class="btn btn-filters ms-auto">

														<i class="fa fa-search" aria-hidden="true"></i> Search

														</button>

													</div>

													</div>

												</div>

											</div>

										</form>



									</div>

								</div>

							</div>

						</div>

                        <div class="table-responsive">

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

<thead>

									<tr>

										<th>#ID</th>

										<th>Payment Option</th>

										<th>Paid Amount</th>

										<th>Date</th>

										<th>Customer</th>

									</tr>

								</thead>

								<tbody>

                                    <?php  

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

										

										$count=0;

										

                                        $startdate = $_GET['start_date'];

                                        $enddate = $_GET['end_date'];

										

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

                                    

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

                                     //   $customer = $_GET['customer'];

                                       

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

                                    //}else{

                                    //    $customerchage = "";

                                    //}

                                    

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

                                           $paymentmethod = $_GET['paymentmethod'];

                                          

                                           $customerchage = "AND mobileorders.pay_option='$paymentmethod'";

                                    }else{

                                           $customerchage = "";

                                       }

                                    $rs = mysqli_query($conn, "SELECT * FROM mobileorders,mobilecustomers WHERE mobileorders.customer=mobilecustomers.coid AND mobileorders.pay_option='cash' $datechage"); 

                                        if ($rs->num_rows > 0) {

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

											

											$count++;

											

											?>

                                             <tr>

                                                <td><?php echo number_format($count,0); ?></td>

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

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

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

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

                                             </tr>           

                                         <?php }

                                        }

                                    }

                                    ?>

                                </tbody>

                            </table>

                        </div>

						</div>

					</div>

				</div>



			</div>

		</div>

	</div>



<?php require_once 'footerjs.php'; ?>



</body>



</html>