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

						<h6>Manage your Expenses</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-2 col-sm-6 col-12">

													<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>

										</form>



									</div>

								</div>

							</div>

						</div>

                        <div class="table-responsive">

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

<thead>

									<tr>

										<th>#ID</th>

                                        <th>Expense</th>

										<th>Category</th>

                                        <th>Ref Number</th>

										<th>Amount</th>

                                        <th>Added Date</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 mobileexpense.add_date BETWEEN '$startdate' AND '$enddate'";

        

										$sql = "SELECT * FROM mobileexpense,mobileexpensecategory

										WHERE mobileexpense.expcategory = mobileexpensecategory.epid $datechage

										";

										$rs = $conn->query($sql);

                                        if ($rs->num_rows > 0) {

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

											

											$count++;



											?>

                                             <tr>

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

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

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

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

												<td class="text-red">Rs.<?php echo number_format((float) $row['amount'], 2); ?></td>

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

                                             </tr>           

                                    <?php 

									}

                                    }

                                    }

                                    ?>

                                </tbody>

                            </table>

                        </div>

						</div>

					</div>

				</div>



			</div>

		</div>

	</div>

	

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

	

</body>

</html>