<?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 - ඇදුම්  Hub | Pos & Invetory System | Dashboard

">

	<meta name="keywords" content="ඇදුම්  Hub | Pos & Invetory System | Dashboard

">

	<meta name="author" content="ඇදුම්  Hub | Pos & Invetory System | Dashboard

">

	<meta name="robots" content="noindex, nofollow">



	<title>Stock List | Payroll | 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 Srock</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 class="search-set">

							</div>

							<div class="wordset">



							</div>

						</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-8 col-12">
												<div class="form-group">
														<label for="branch">Branch</label>
														<select class="form-control" id="branch" name="branch">
														<option value="">Select Branch</option>
														<option value="all">All</option>
															<?php $bra = mysqli_query($conn, "SELECT * FROM branch WHERE status='1'"); 
															if ($bra->num_rows > 0) {
																while($row = $bra->fetch_assoc()) { 
																	$branch = $_GET['branch'] ?? '';
																	if($branch==$row['branch_id']){ ?>
																		<option value="<?php echo $row['branch_id']; ?>" selected><?php echo $row['branch_name']; ?></option>
																	<?php } else{ ?>
																		<option value="<?php echo $row['branch_id']; ?>"><?php echo $row['branch_name']; ?></option>
																		<?php } 
															
															} 
															
																} ?>


														</select>
												</div>
													</div>
												<div class="col-lg-4 col-sm-4 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>#</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;

										if(isset($_GET['branch'])){
											$branch = $_GET['branch'];
											if($branch=="all"){
												$branchestext = "";
											}else{
												$branchestext = "AND tst.branch_id='$branch'";
											}

										}else{
											$branchestext = "AND tst.branch_id='$branch_id'";
										}

										$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.prid!='148' $branchestext 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>

											</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' AND tst.prid!='148' 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>

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

	

<script>

		function printDiv(printableArea) {



			var printContents = document.getElementById(printableArea).innerHTML;

			var originalContents = document.body.innerHTML;



			document.body.innerHTML = printContents;



			window.print();



			document.body.innerHTML = originalContents;



		}

	</script>

	<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>

	<script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.1.0-rc.0/js/select2.min.js"></script>



	<script>

	// Initialize Select2 plugin with typing search functionality

	$('.select2').select2();

	</script>

	

	<script data-cfasync="false" src="../../cdn-cgi/scripts/5c5dd728/cloudflare-static/email-decode.min.js"></script>

							

	<script src="assets/js/jquery-3.6.0.min.js"></script>



	<script src="assets/js/feather.min.js"></script>



	<script src="assets/js/jquery.slimscroll.min.js"></script>



	<script src="assets/js/jquery.dataTables.min.js"></script>

	<script src="assets/js/buttons.dataTables.js"></script>

	<script src="assets/js/dataTables.bootstrap4.min.js"></script>



	<script src="assets/js/bootstrap.bundle.min.js"></script>



	<script src="assets/js/moment.min.js"></script>

	<script src="assets/js/bootstrap-datetimepicker.min.js"></script>

	<script src="assets/js/pdfmake.min.js"></script>

	<script src="assets/plugins/select2/js/select2.min.js"></script>

	<script src="assets/js/vfs_fonts.js"></script>



	<script src="assets/plugins/sweetalert/sweetalert2.all.min.js"></script>

	<script src="assets/plugins/sweetalert/sweetalerts.min.js"></script>

	<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>

	<script src="assets/js/dataTables.buttons.min.js"></script>

	<script src="assets/js/jszip.min.js"></script>

	<script src="assets/js/buttons.html5.min.js"></script>

	<script src="assets/js/script.js"></script>

	

	<link href="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/toastr.min.css" rel="stylesheet">

    <script src="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/toastr.min.js"></script>



	<script>

		



		$(document).ready( function() {

			$('#betable').DataTable({

        dom: 'Bfrtip', 

        buttons: [

            'copy', 

            'csv',  

            {

                extend: 'excelHtml5', 

                customize: function(xlsx) {

                    var sheet = xlsx.xl.worksheets['sheet1.xml']; 

                    $('row c[r^="C"]', sheet).attr('s', '2'); 

                }

            },

            'pdf',  

            'print' 

        ]

    });

	} );

	</script>

	

	<style>

	#betable_filter{

		margin-bottom: 20px;

	}

	</style>



</body>



</html>