<?php

include 'load.php';
require_once 'db_connection.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>Seller Wise Sales Report | Eat More Resturant   | Pos & Invetory System | Dashboard
</title>


	<?php
	require_once 'headercss.php';
	?>
</head>

<body>
	<div id="global-loader">
		<div class="whirly-loader"> </div>
	</div>

	<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>Seller Wise Sales Report</h4>
						<h6>Manage your Sales</h6>
					</div>
				</div>

				<div class="card">
					<div class="card-body">
						<div class="table-top">

						</div>

						<div class="row">
									<div class="col-lg-12 col-sm-12">
										<form method="POST" 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" value="<?php echo $_POST['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" value="<?php echo $_POST['end_date']; ?>"
															class="form-control">
													</div>
												</div>
												
                                                <div class="col-lg-4 col-sm-5 col-12">
													<div class="form-group">
													<label for="">Seller</label>
														<select class="select select2" name="sellerid">
															<option selected value="">Choose Seller</option>
															<?php

															$stmt = $DB_con->prepare('SELECT * FROM mobileusers where status="1" ORDER BY user_id');

															$stmt->execute();

															if ($stmt->rowCount() > 0) {

																while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

																	extract($row);

																	if($_POST['sellerid']==$row['user_id']){ ?>
                                                                         <option value="<?php echo $row['user_id']; ?>" selected><?php echo $row['fullname']; ?></option>
                                                                    <?php }else{ ?>
                                                                        <option value="<?php echo $row['user_id']; ?>"><?php echo $row['fullname']; ?></option>
                                                                    <?php }?>
																	
																	<?php
																}
															}
															?>
														</select>
													</div>
												</div>            
												<div class="col-lg-2 col-sm-6 col-12">
													<div class="form-group">
														<button type="submit" name="search" class="btn btn-success btn-md btn-block ms-auto" style="margin-top: 33px;width:100%;"><i class="fa fa-search"></i> Search</button>
													</div>
												</div>
											</div>
										</form>
									</div>
								</div>

						<div class="table-responsive">
<table class="table" id="betable">
<thead>
									<tr>
										<th>#ID</th>
										<th>Order No</th>
                                        <th>Seller</th>
										<th>Pay Type</th>
                                        <th>Date</th>
										<th>Profit</th>
										<th>Amount</th>
										
									</tr>
								</thead>
								<tbody>
									<?php
                                   
									if (isset($_POST['search'])) {
										
										$count=0;
										
										$sellerid = $_POST['sellerid'];
										
                                        $start_date = $_POST['start_date'];
                                        $end_date = $_POST['end_date'];
                                        
                                        if(!empty($sellerid)){
                                            $searchsellerid = "AND mobileorders.user_id='$sellerid'";
                                        }else{
                                            $searchsellerid = "";
                                        }
                                        if(!empty($start_date) && !empty($end_date)){
                                            if($start_date==$end_date){
                                                $searchdate = "AND DATE(mobileorders.create_at) = '$start_date'";
                                            }else{
                                                $searchdate = "AND mobileorders.create_at BETWEEN '$start_date' AND '$end_date'";
                                            }
                                        }else{
                                            $searchdate = "";
                                        }
  
                                        $sales = mysqli_query($conn, "SELECT * FROM mobileorders,mobileusers WHERE mobileorders.user_id=mobileusers.user_id $searchsellerid $searchdate"); 
                                        if ($sales->num_rows > 0) {
                                           
                                            while($row = $sales->fetch_assoc()) {


                                        $oooid = $row['order_id'];
										$orders = mysqli_fetch_array(mysqli_query($conn, "SELECT SUM(amount) as amount FROM mobileorders WHERE order_id='$oooid'"));
										$productcost = mysqli_fetch_array(mysqli_query($conn, "SELECT SUM(mobileproducts.price * mobiletemporarycart.pro_qty) as cost
														FROM mobiletemporarycart
														JOIN mobileproducts ON mobiletemporarycart.proid = mobileproducts.prid WHERE mobiletemporarycart.orderid='$oooid'"));
										$profit = $orders['amount'] - $productcost['cost'];
										
										$count++;
										
                                        ?>
                                        <tr>
                                            <td><?php echo number_format($count,0); ?></td>
											<td><?php echo $row['order_id']; ?></td>
                                            <td><?php echo $row['fullname']; ?></td>
                                            <td><span class="label label-success"><?php echo $row['pay_option']; ?></span></td>
                                            <td><?php echo $row['create_at']; ?></td>
                                            <td>Rs.<?php echo number_format((float)$profit, 2); ?></td>
                                            <td>Rs.<?php echo number_format((float)$row['amount'], 2); ?></td>
                                        </tr>
                                   <?php } 
                                        }
                                        
									}else{
										
										$count=0;
										
                                        $sales = mysqli_query($conn, "SELECT * FROM mobileorders,mobileusers WHERE mobileorders.user_id=mobileusers.user_id"); 
                                        if ($sales->num_rows > 0) {
                                           
                                            while($row = $sales->fetch_assoc()) {


                                        $oooid = $row['order_id'];
										$orders = mysqli_fetch_array(mysqli_query($conn, "SELECT SUM(amount) as amount FROM mobileorders WHERE order_id='$oooid'"));
										$productcost = mysqli_fetch_array(mysqli_query($conn, "SELECT SUM(mobileproducts.price * mobiletemporarycart.pro_qty) as cost
														FROM mobiletemporarycart
														JOIN mobileproducts ON mobiletemporarycart.proid = mobileproducts.prid WHERE mobiletemporarycart.orderid='$oooid'"));
										$profit = $orders['amount'] - $productcost['cost'];
										
										$count++;
										
                                        ?>
                                        <tr>
											<td><?php echo number_format($count,0); ?></td>
                                            <td><?php echo $row['order_id']; ?></td>
                                            <td><?php echo $row['fullname']; ?></td>
                                            <td><span class="label label-success"><?php echo $row['pay_option']; ?></span></td>
                                            <td><?php echo $row['create_at']; ?></td>
                                            <td>Rs.<?php echo number_format((float)$profit, 2); ?></td>
                                            <td>Rs.<?php echo number_format((float)$row['amount'], 2); ?></td>
                                        </tr>
                                   <?php } 
                                        }
                                    }
									?>
								</tbody>
							</table>
						</div>
					</div>
				</div>

			</div>
		</div>
	</div>
<style>
    .label-success {
    background-color: #5cb85c;
}
.label {
    display: inline;
    padding: .2em .6em .3em;
    font-size: 75%;
    font-weight: 700;
    line-height: 1;
    color: #fff;
    text-align: center;
    white-space: nowrap;
    vertical-align: baseline;
    border-radius: .25em;
}
</style>

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

</body>

</html>