« Back to History
saree_out.php
|
20260920_164915.php
Initial Domain Snapshot
Copy Code
<?php require_once __DIR__ . '/modules/auth/page_acl.php'; $ctx = page_require_access('saree_out'); $pdo = $ctx['pdo']; $company_id = (int)$ctx['company_id']; $user_id = $ctx['user_id'] ?? $_SESSION['user_id'] ?? 0; function h($s){ return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8'); } // ================= AJAX: Get Colors Grid with Real-time Stock Check ================= if (isset($_GET['action']) && $_GET['action'] == 'get_color_grid') { $d_id = (int)$_GET['d_id']; // Query jo color name aur uska current stock (In - Out) dono laayegi $query = " SELECT c.id, c.color_name, ( COALESCE((SELECT SUM(saree_qty) FROM saree_stock_in WHERE color = c.id AND company_id = ?), 0) - COALESCE((SELECT SUM(total_saree) FROM saree_out WHERE color = c.id AND company_id = ?), 0) ) as current_balance FROM saree_quality_design_color c WHERE c.design_id = ? AND c.company_id = ? AND c.status = 1"; $stmt = $pdo->prepare($query); $stmt->execute([$company_id, $company_id, $d_id, $company_id]); $colors = $stmt->fetchAll(PDO::FETCH_ASSOC); if(empty($colors)) { echo '<div class="alert alert-warning">Is design mein koi color nahi mila.</div>'; } else { echo '<table class="table table-sm table-bordered align-middle" id="outTable">'; echo '<thead class="table-danger text-dark"> <tr> <th>Color Name</th> <th class="text-center">Current Stock</th> <th width="150">Out Qty (PCS)</th> </tr> </thead>'; echo '<tbody>'; foreach($colors as $c) { $balance = (float)$c['current_balance']; $is_out_of_stock = ($balance <= 0) ? 'table-secondary' : ''; echo '<tr class="'.$is_out_of_stock.'">'; echo '<td>'.h($c['color_name']).'</td>'; echo '<td class="text-center fw-bold"><span class="badge bg-info text-dark">'.$balance.'</span></td>'; echo '<td> <input type="number" step="0.01" name="qtys['.$c['id'].']" class="form-control form-control-sm text-end qty-input" value="0" min="0" max="'.$balance.'" '.($balance <= 0 ? 'disabled' : '').' oninput="checkMax(this, '.$balance.')"> </td>'; echo '</tr>'; } echo '</tbody></table>'; } exit; } // (Get Designs AJAX remains same as your code) if (isset($_GET['action']) && $_GET['action'] == 'get_designs') { $stmt = $pdo->prepare("SELECT id, design_name FROM saree_quality_design WHERE quality_id = ? AND company_id = ? AND status = 1"); $stmt->execute([(int)$_GET['q_id'], $company_id]); echo json_encode($stmt->fetchAll(PDO::FETCH_ASSOC)); exit; } // ================= SAVE LOGIC ================= if ($_SERVER['REQUEST_METHOD'] === 'POST') { $out_date = $_POST['date'] ?? date('Y-m-d'); $party_name = $_POST['name'] ?? ''; $quality_id = (int)$_POST['quality']; $design_id = (int)$_POST['design']; $qtys = $_POST['qtys'] ?? []; $remark = trim($_POST['remark'] ?? ''); $pdo->beginTransaction(); try { $stmt = $pdo->prepare("INSERT INTO saree_out (company_id, date, name, quality, design, color, total_saree, remark, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, NOW())"); foreach ($qtys as $color_id => $qty) { if ($qty > 0) { // Backend validation: Phir se check karein stock hai ya nahi $check = $pdo->prepare("SELECT (COALESCE((SELECT SUM(saree_qty) FROM saree_stock_in WHERE color = ?),0) - COALESCE((SELECT SUM(total_saree) FROM saree_out WHERE color = ?),0)) as bal"); $check->execute([$color_id, $color_id]); $current_bal = $check->fetchColumn(); if($qty > $current_bal) { throw new Exception("Stock insufficient for color ID: $color_id"); } $stmt->execute([$company_id, $out_date, $party_name, $quality_id, $design_id, (int)$color_id, (float)$qty, $remark]); } } $pdo->commit(); header("Location: " . $_SERVER['PHP_SELF'] . "?success=1"); exit; } catch (Exception $e) { $pdo->rollBack(); die("Error: " . $e->getMessage()); } } // (Fetch Parties & Qualities remains same) $parties = $pdo->prepare("SELECT party_name FROM saree_out_party WHERE company_id = ? AND status = 1"); $parties->execute([$company_id]); $party_list = $parties->fetchAll(PDO::FETCH_ASSOC); $qualities = $pdo->prepare("SELECT id, quality_name FROM saree_quality WHERE company_id = ? AND status = 1"); $qualities->execute([$company_id]); $quality_list = $qualities->fetchAll(PDO::FETCH_ASSOC); require_once __DIR__ . '/partials/header.php'; ?> <div class="container-fluid mt-4"> <div class="d-flex justify-content-between align-items-center mb-3"> <h4 class="fw-bold text-danger">Saree Stock Out (Stock Check Enabled)</h4> </div> <form method="post" id="stockOutForm"> <div class="row"> <div class="col-md-4"> <div class="card shadow-sm border-0 mb-3"> <div class="card-body"> <div class="mb-3"> <label class="form-label small fw-bold">Out Date</label> <input type="date" name="date" class="form-control" value="<?= date('Y-m-d') ?>" required> </div> <div class="mb-3"> <label class="form-label small fw-bold">Party Name</label> <select name="name" class="form-select" required> <option value="">-- Select Party --</option> <?php foreach($party_list as $p): ?> <option value="<?= h($p['party_name']) ?>"><?= h($p['party_name']) ?></option> <?php endforeach; ?> </select> </div> <hr> <div class="mb-3"> <label class="form-label small fw-bold">Quality</label> <select name="quality" id="qSelect" class="form-select" required> <option value="">-- Choose Quality --</option> <?php foreach($quality_list as $q): ?> <option value="<?= $q['id'] ?>"><?= h($q['quality_name']) ?></option> <?php endforeach; ?> </select> </div> <div class="mb-3"> <label class="form-label small fw-bold">Design</label> <select name="design" id="dSelect" class="form-select" required disabled> <option value="">-- First Select Quality --</option> </select> </div> </div> </div> </div> <div class="col-md-8"> <div class="card shadow-sm border-0"> <div class="card-header bg-danger text-white fw-bold">Fill Color-wise Out PCS</div> <div class="card-body"> <div id="colorGrid" class="text-center text-muted py-5">Design select karein...</div> <div id="actionBtn" class="mt-3 d-none"> <button type="submit" class="btn btn-danger btn-lg w-100 fw-bold">PROCESS STOCK OUT</button> </div> </div> </div> </div> </div> </form> </div> <script> // Javascript for cascading remains same const qSelect = document.getElementById('qSelect'); const dSelect = document.getElementById('dSelect'); const colorGrid = document.getElementById('colorGrid'); const actionBtn = document.getElementById('actionBtn'); qSelect.addEventListener('change', function() { dSelect.disabled = true; if(this.value) { fetch('?action=get_designs&q_id=' + this.value) .then(r => r.json()) .then(data => { dSelect.innerHTML = '<option value="">-- Choose Design --</option>'; data.forEach(d => { dSelect.innerHTML += `<option value="${d.id}">${d.design_name}</option>`; }); dSelect.disabled = false; }); } }); dSelect.addEventListener('change', function() { if(this.value) { colorGrid.innerHTML = 'Fetching Stock...'; fetch('?action=get_color_grid&d_id=' + this.value) .then(r => r.text()) .then(html => { colorGrid.innerHTML = html; actionBtn.classList.remove('d-none'); }); } }); // NEW: Validation Function function checkMax(input, maxVal) { if (parseFloat(input.value) > maxVal) { alert("Stock se zyada out nahi kar sakte! Available: " + maxVal); input.value = maxVal; // Max par set kar dega } } // Enter key logic stays same document.addEventListener('keydown', function(e) { if (e.key === 'Enter' && e.target.classList.contains('qty-input')) { e.preventDefault(); const inputs = Array.from(document.querySelectorAll('.qty-input:not([disabled])')); const index = inputs.indexOf(e.target); if (index > -1 && index < inputs.length - 1) { inputs[index + 1].focus(); inputs[index + 1].select(); } else { document.querySelector('button[type="submit"]').focus(); } } }); </script> <?php require_once __DIR__ . '/partials/footer.php'; ?>