<?php
session_start();
include 'load.php';
$branch_id = $_SESSION['branch_id'];
?>

<!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>Stock List | 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>Product Stock list</h4>
						<h6>View/Search product productid</h6>
					</div>
					<div class="page-btn">
						<a href="addstock.php" class="btn btn-added"><img src="assets/img/icons/plus.svg" class="me-2"
								alt="img"> Add Stock</a>
					</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-6 col-sm-6 col-12">
													<div class="form-group">
														<label for="start-date">Supplier</label>
														<select class="form-control select2" name="supplier" required> 
														<option value="">Select Supplier</option>
														<?php 
				
														$sql = "SELECT * FROM mobilesuppliers";
														$result = $conn->query($sql);

														if ($result->num_rows > 0) {
														while($row = $result->fetch_assoc()) { ?>
														<option value="<?php echo $row['spid']; ?>"><?php echo $row['spname']; ?></option>
														<?php }
														}
														?>
														</select>
													</div>
												</div>
												<div class="col-lg-2 col-sm-2 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>Action</th>
										<th>Product Name</th>
										<th>Supplier</th>
										<th>Open Stock/Qty</th>
										<th>Current Stock/Qty</th>
										<th>Added Date</th>
									</tr>
								</thead>
								<tbody>
										<?php
										
										if (isset($_GET['search'])) {
									
										$count=0;
										
										$totalrowopenstock=0;
										$totalrowcurrentstock=0;
										
										$supplier = $_GET['supplier'];

										$stmt = $DB_con->prepare("SELECT tst.stock_id,tst.prid as tstprid,tst.qty as tstqty,tst.branch_id,tst.add_date,mpr.prid as mprprid,mpr.prcode,mpr.itemcode,mpr.proname,mpr.qty mprqty,mpr.supplier FROM tbl_stock tst INNER JOIN mobileproducts mpr ON tst.prid=mpr.prid WHERE tst.branch_id = '$branch_id' AND mpr.supplier='$supplier' ORDER BY tst.stock_id ASC");

										$stmt->execute();

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

										{

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

										{

										extract($row);
										
										$totalrowopenstock=$totalrowopenstock+$row['mprqty'];
										$totalrowcurrentstock=$totalrowcurrentstock+$row['tstqty'];
										
										$count++;
										
										?>
										<tr>
											<td>
											<?php echo number_format($count,0); ?>
											</td>
											<td>
											<a href="editstock.php?stock_id=<?php echo $row['stock_id']; ?>"
													class="btn btn-block btn-outline-primary active btn-sm text-white"><i
														class="fa fa-edit" data-bs-toggle="tooltip" title=""
														data-bs-original-title="fa fa-edit"
														aria-label="fa fa-edit"></i></a>

												<a href="deletestock.php?stock_id=<?php echo $row['stock_id']; ?>"
													class="btn btn-block btn-outline-danger active btn-sm text-white"><i
														class="fa fa-trash" data-bs-toggle="tooltip" title=""
														data-bs-original-title="fa fa-trash"
														aria-label="fa fa-trash"></i></a>

											</td>
											<td>
											<?php echo $row["prcode"]; ?> | <?php echo $row["itemcode"]; ?> | <?php echo $row["proname"]; ?>
											</td>
											<td><?php
											if($row['supplier'] == "0"){
													
											}else{	
												
											$id = $row['supplier'];  

											$query = $DB_con->prepare('SELECT spname FROM mobilesuppliers WHERE spid='.$id);

											$query->execute();

											$result = $query->fetch();

											echo $result['spname'];
}
											?></td>
											<td><?php echo $row["mprqty"]; ?></td>
											<td><?php echo $row["tstqty"]; ?></td>
											<td><?php echo date_format(date_create($row['add_date']), "M d, Y | h:i:s "); ?></td>
										</tr>
										<?php
										
										}
										
										}
										
										}else{
									
										$count=0;
										
										$totalrowopenstock=0;
										$totalrowcurrentstock=0;

										$stmt = $DB_con->prepare("SELECT tst.stock_id,tst.prid as tstprid,tst.qty as tstqty,tst.branch_id,tst.add_date,mpr.prid as mprprid,mpr.prcode,mpr.itemcode,mpr.proname,mpr.qty mprqty,mpr.supplier FROM tbl_stock tst INNER JOIN mobileproducts mpr ON tst.prid=mpr.prid WHERE tst.branch_id = '$branch_id' ORDER BY tst.stock_id ASC");

										$stmt->execute();

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

										{

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

										{

										extract($row);
										
										$totalrowopenstock=$totalrowopenstock+$row['mprqty'];
										$totalrowcurrentstock=$totalrowcurrentstock+$row['tstqty'];
										
										$count++;
										
										?>
										<tr>
											<td>
											<?php echo number_format($count,0); ?>
											</td>
											<td>
											<a href="editstock.php?stock_id=<?php echo $row['stock_id']; ?>"
													class="btn btn-block btn-outline-primary active btn-sm text-white"><i
														class="fa fa-edit" data-bs-toggle="tooltip" title=""
														data-bs-original-title="fa fa-edit"
														aria-label="fa fa-edit"></i></a>

												<a href="deletestock.php?stock_id=<?php echo $row['stock_id']; ?>"
													class="btn btn-block btn-outline-danger active btn-sm text-white"><i
														class="fa fa-trash" data-bs-toggle="tooltip" title=""
														data-bs-original-title="fa fa-trash"
														aria-label="fa fa-trash"></i></a>

											</td>
											<td>
											<?php echo $row["prcode"]; ?> | <?php echo $row["itemcode"]; ?> | <?php echo $row["proname"]; ?>
											</td>
											<td><?php
											if($row['supplier'] == "0"){
													
											}else{	
												
											$id = $row['supplier'];  

											$query = $DB_con->prepare('SELECT spname FROM mobilesuppliers WHERE spid='.$id);

											$query->execute();

											$result = $query->fetch();

											echo $result['spname'];
}
											?></td>
											<td><?php echo number_format((float)$row["mprqty"],2); ?></td>
											<td><?php echo number_format((float)$row["tstqty"],2); ?></td>
											<td>
											<?php echo date_format(date_create($row['add_date']), "M d, Y | h:i:s "); ?>
											</td>
										</tr>
										<?php 
										}
										}
										}
										?>
								</tbody>
								<tfoot style="background-color:#008b0b;color:#ffffff;">
									<tr>
										<th></th>
										<th></th>
										<th></th>
										<th><strong>All Total</strong></th>
										<th><?php echo number_format((float)$totalrowopenstock,2); ?></th>
										<th><?php echo number_format((float)$totalrowcurrentstock,2); ?></th>
										<th></th>
									</tr>
								</tfoot>
							</table>
						</div>
					</div>
				</div>

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

</body>

</html>