File Manager

✏️ Edit File: /home/rla105zs937x/public_html/pillai_ceramics/admin/stocks/current.php

<style>

</style>
<div class="card card-outline card-primary">
	<div class="card-body">
	<form  method="GET">
		<div class="row">
			<div class="form-group col-4">
				
				<label for="godown" class="control-label text-info">Godown Name</label>
				<select name="godown" id="godown" class="form-control form-control-sm rounded-0" onchange="getstock()">
					<option value=""> Select Godown </option>
					<?php
					if(isset($_GET['id']))
						{
							$godown=$_GET['id']; 
						}
						$item = $conn->query("SELECT * FROM `godown_list` where status = 1 order by `name` asc");
						while($row=$item->fetch_assoc()):
						$selected=isset($godown) && $godown==$row['id']? 'Selected' : '';
						echo '<option value="'.$row['id'].'" '.$selected.'>'.$row['name'].'</option>';
						endwhile;
					?>
				</select>
				
			</div>
			<div class="form-group col-4 mt-4">
				<button type='button' onclick="getstock()" value="Stock" class="btn btn-success"> Get Stock </button>
			</div>
		</div>
	</form>
	</div>
	<div class="card-header">
		<h3 class="card-title">List of Stocks</h3>
        
	</div>
	<div class="card-body">
		<div class="container-fluid">
			<div class="container-fluid">
				<div class="row">
					<div class='col-md-4'>
					<label> Search </label> : <input id="myInput" type="text" class="form-control" placeholder="Search..">
					</div>
					<div class='col-md-4'>

</div>
					<div class='col-md-4 text-right'>
					<button id="exportBtn"><img src="../uploads/excel.png" style="width:80px;"></button>
					</div>
					
				</div>
			
<br>
			<form action="" id="stock-form">
				<div class="table-responsive">

<table id="myTable" class="table table-bordered table-stripped">
						<colgroup>
						<col width="5%">
						<col width="35%">
						<col width="5%">
						<col width="10%">
						<col width="8%">
						<col width="8%">
						<col width="8%">
						<col width="8%">
                    </colgroup>
                    <thead>
						<tr>
							<th>#</th>
                            <th>Item Name</th>
							<th>Godown</th>
							<th>Current Stocks (A+B+C-D)</th>
                            <th>Opening Stocks (A)</th>
							<th>Total PO (B)</th>
							<th>Total RO (C)</th>
							<th>Total SO (D)</th>
							<th>PO Hold</th>
							<th>SO Hold</th>
							<th>RO Hold</th>
						</tr>
					</thead>
                    <tbody>
					<?php
						$return_hold_map = [];
						$returned_qty_map = [];

$ret_qry = $conn->query("SELECT stock_ids, sales_returns_count FROM sales_returns WHERE sales_returns_status = 2");
						while ($ret_row = $ret_qry->fetch_assoc()) {
						    $stock_ids_arr = explode(',', $ret_row['stock_ids']);
						    $return_qtys_arr = explode(',', $ret_row['sales_returns_count']);
						
						    foreach ($stock_ids_arr as $index => $sid) {
						        $qty = isset($return_qtys_arr[$index]) ? (int)$return_qtys_arr[$index] : 0;
						        if (!isset($returned_qty_map[$sid])) {
						            $returned_qty_map[$sid] = 0;
						        }
						        $returned_qty_map[$sid] += $qty;
						    }
						}

$ret_hold_qry = $conn->query("SELECT stock_ids, sales_returns_count FROM sales_returns WHERE sales_returns_status = 1");
						while ($ret_row = $ret_hold_qry->fetch_assoc()) {
						    $stock_ids_arr = explode(',', $ret_row['stock_ids']);
						    $return_qtys_arr = explode(',', $ret_row['sales_returns_count']);
						
						    foreach ($stock_ids_arr as $index => $sid) {
						        $qty = isset($return_qtys_arr[$index]) ? (int)$return_qtys_arr[$index] : 0;
						        if (!isset($return_hold_map[$sid])) {
						            $return_hold_map[$sid] = 0;
						        }
						        $return_hold_map[$sid] += $qty;
						    }
						}

if (isset($_GET['id'])) {
						    $godown = $_GET['id'];
						    $i = 1;
						    $qry = $conn->query("SELECT i.*, c.name as category FROM `item_list` i LEFT JOIN category_list c ON i.category_id = c.id");
						    while ($row = $qry->fetch_assoc()):
						        $qry1 = $conn->query("SELECT id, quantity as available FROM `opening_stock` WHERE godown = '$godown' AND item_id = '{$row['id']}'");
						        $stock = $qry1->fetch_assoc();
						        $ops = isset($stock['id']) ? $stock['available'] : 0;
							
						        $in = $conn->query("SELECT SUM(quantity) as total FROM stock_list WHERE godown = '$godown' AND item_id = '{$row['id']}' AND type = 1")->fetch_array()['total'];
						        $out = $conn->query("SELECT SUM(quantity) as total FROM stock_list WHERE godown = '$godown' AND item_id = '{$row['id']}' AND type = 2")->fetch_array()['total'];
						        $po = $conn->query("SELECT SUM(pi.quantity) as total FROM po_items as pi LEFT JOIN purchase_order_list as pol ON pi.po_id = pol.id WHERE pi.godown = '$godown' AND pi.item_id = '{$row['id']}' AND pol.status = 2")->fetch_array()['total'];
						        $pohold = $conn->query("SELECT SUM(pi.quantity) as total FROM po_items as pi LEFT JOIN purchase_order_list as pol ON pi.po_id = pol.id WHERE pi.godown = '$godown' AND pi.item_id = '{$row['id']}' AND pol.status = 0")->fetch_array()['total'];
						        $gn = $conn->query("SELECT name as gdname FROM godown_list WHERE id = '$godown'")->fetch_array()['gdname'];
							
						        // Calculate Approved Return Quantity (rtg)
						        $rtg = 0;
						        $stk_qry = $conn->query("SELECT id FROM stock_list WHERE item_id = '{$row['id']}' AND godown = '$godown' AND type = 2");
						        while ($stk = $stk_qry->fetch_assoc()) {
						            $sid = $stk['id'];
						            if (isset($returned_qty_map[$sid])) {
						                $rtg += $returned_qty_map[$sid];
						            }
						        }
							
						        // Calculate Return Hold Quantity (rth)
						        $rth = 0;
						        $stk_qry2 = $conn->query("SELECT id FROM stock_list WHERE item_id = '{$row['id']}' AND godown = '$godown' AND type = 2");
						        while ($stk = $stk_qry2->fetch_assoc()) {
						            $sid = $stk['id'];
						            if (isset($return_hold_map[$sid])) {
						                $rth += $return_hold_map[$sid];
						            }
						        }
							
						        $current_stock = $ops + $po + $rtg - $out;
						        if ($current_stock != 0):
						?>
						<tr>
						    <td class="text-center"><?php echo $i++; ?></td>
						    <td>
						        <img src="../<?= ($row['photo']) ? $row['photo'] : 'uploads/product/default.jpg'; ?>" style='width:100px;'>
						        <?php echo $row['name'] ?>, <br>
						        Category: <?php echo $row['category'] ?>, <br>
						        Brand: <?php echo $row['brand'] ?>, <br>
						        Size: <?php echo $row['size'] ?>, <br>
						        <?php echo $row['description'] ?>
						    </td>
						    <td class="text-center">
						        <?php
						        $gn_label = ($gn == 'GODOWN 1') ? 'GD1' : (($gn == 'GODOWN 2') ? 'GD2' : $gn);
						        echo $gn_label;
						        ?>
						    </td>
						    <td class="text-center"><?php echo number_format($current_stock); ?></td>
						    <td class="text-center"><?php echo number_format($ops); ?></td>
						    <td class="text-center"><?php echo number_format($po); ?></td>
						    <td class="text-center"><?php echo number_format($rtg); ?></td>
						    <td class="text-center"><?php echo number_format($out); ?></td>
						    <td class="text-center"><?php echo number_format($pohold); ?></td>
						    <td class="text-center"><?php echo number_format($in); ?></td>
						    <td class="text-center"><?php echo number_format($rth); ?></td>
						</tr>
						<?php
						        endif;
						    endwhile;
						}
						?>

</tbody>
				</table>
			</div>
				 
				</form>
			</div>
		</div>
	</div>
</div>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.0/xlsx.full.min.js"></script>

$('#godown').on('change', function() {
        getstock();
    });

</script>

Batal

⬅ Naik ke admin 3 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘current.php	php	9.3 KB	2025-04-28 17:50	✏️ Edit 👁️ View
🐘current_old.php	php	9.3 KB	2025-04-11 10:24	✏️ Edit 👁️ View
🐘opening.php	php	5.7 KB	2025-04-28 16:42	✏️ Edit 👁️ View