<?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 - Payroll | Pos & Invetory System | Dashboard
">
	<meta name="keywords" content="Payroll | Pos & Invetory System | Dashboard
">
	<meta name="author" content="Payroll | 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 Return Stock list</h4>
						<h6>View/Search product productid</h6>
					</div>
					<div class="page-btn">
						<a href="add-sales-return.php" class="btn btn-added"><img src="assets/img/icons/plus.svg" class="me-2"
								alt="img"> Add Return Stock</a>
					</div>
				</div>
				
				<div class="card">
					<div class="card-body">
						<div class="table-top">
							<div class="search-set">
								<div class="search-path">
									<a class="btn btn-filter" id="filter_search">
										<img src="assets/img/icons/filter.svg" alt="img">
										<span><img src="assets/img/icons/closes.svg" alt="img"></span>
									</a>
								</div>
								<div class="search-input">
									<a class="btn btn-searchset"><img src="assets/img/icons/search-white.svg"
											alt="img"></a>
								</div>
							</div>
							<div class="wordset">
								<ul>
									<li>
										<a data-bs-toggle="tooltip" data-bs-placement="top" title="pdf"><img
												src="assets/img/icons/pdf.svg" alt="img"></a>
									</li>
									<li>
										<a data-bs-toggle="tooltip" data-bs-placement="top" title="excel"><img
												src="assets/img/icons/excel.svg" alt="img"></a>
									</li>
									<li>
										<a data-bs-toggle="tooltip" data-bs-placement="top" title="print"
											onclick="printDiv('printableArea')"><img src="assets/img/icons/printer.svg"
												alt="img"></a>
									</li>
								</ul>
							</div>
						</div>
						
						

						<div class="table-responsive">
							<table class="table datanew">
								<thead>
									<tr>
										<th>#</th>
										
										<th>Product Name</th>
										<th>Order Id</th>
										<th>Return Stock/Qty</th>
										<th>Return Type</th>
                                        <th>Return Reson</th>
										<th>Added Date</th>
									</tr>
								</thead>
								<tbody>
										<?php
										
										
									
										$count=0;
										
										$totalrowopenstock=0;
										$totalrowcurrentstock=0;

										$stmt = $DB_con->prepare("SELECT * FROM tbl_return_items");

										$stmt->execute();

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

										{

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

										{

										extract($row);
										
										
										
										$count++;
										
										?>
										<tr>
											<td>
											<?php echo number_format($count,0); ?>
											</td>
											
											<td>
											<?php 
                                            $prid = $row['prid'];
                                            $productinfo = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM mobileproducts WHERE prid='$prid'"));
                                           
                                            
                                            
                                            echo $productinfo["prcode"]; ?> | <?php echo $productinfo["itemcode"]; ?> | <?php echo $productinfo["proname"]; ?>
											</td>
											<td><?php
											echo $row["order_id"];

											?></td>
											<td><?php echo $row["qty"]; ?></td>
											<td><?php if($row["return_type"]==1){
                                                echo "Return";
                                            }else if($row["return_type"]==2){
                                                echo "Good Return";
                                            }else if($row["return_type"]==3){
                                                echo "Market Return";
                                            } ?></td>
                                            <td>
											<?php echo $row["return_reson"]; ?>
											</td>
											<td>
											<?php echo date_format(date_create($row['added_date']), "M d, Y | h:i:s "); ?>
											</td>
										</tr>
										<?php 
										}
										}
										
										?>
								</tbody>
								
							</table>
						</div>
					</div>
				</div>

			</div>
		</div>
	</div>


	<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/dataTables.bootstrap4.min.js"></script>

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

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

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

	<script src="assets/js/script.js"></script>
	<script>
	$(".select2").select2({
          
      });
</script>
</body>

</html>