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

						<h6>Manage your Purchase Order</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-1 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>Suppler</th>

										<th>Invoice No</th>

										<th>Item Count</th>

										<th>Total</th>

										<th>Date/Time</th>

									</tr>

								</thead>

								<tbody>

                                    <?php 

									

									$count=0;

									

									$tot = 0;

									

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

                                    

									$startdate = $_GET['start_date'];

                                    $enddate = $_GET['end_date'];

									

                                    $datechage = "WHERE added_date BETWEEN '$startdate' AND '$enddate'";



                                    $rs = mysqli_query($conn, "SELECT * FROM mobile_purchase_order $datechage"); 

                                        if ($rs->num_rows > 0) {

											

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

											

                                               $suppler_id =  $row['suppler_id'];

                                               $oid = $row['purchase_order_id'];

											   

                                               $supinfo = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM mobilesuppliers WHERE spid ='$suppler_id'"));

                                               $itemcount = mysqli_num_rows(mysqli_query($conn, "SELECT * FROM purchase_order_items WHERE purchase_order_id ='$oid'"));

											   

											   $count++;

                                                

											?>

                                             <tr>

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

                                                <td><?php echo $supinfo['spname']; ?></td>

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

                                                <td><?php echo $itemcount; ?></td>

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

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

                                             </tr>           

                                         <?php 

										$tot = $tot + $row['total_amount']; 

										}

                                        }

                                    }

                                    ?>

                                </tbody>

								<tfoot>

                                    <tr>

                                    <td></td>

                                    <td></td>

                                    <td></td>

                                    <td>Total</td>

                                    <td><?php echo $tot;?></td>

									<td></td>

                                    </tr>

                                </tfoot>

                            </table>

                        </div>

						</div>

					</div>

				</div>



			</div>

		</div>

	</div>



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

	

</body>

</html>