View Code - 20260721

va_send_soft.php | 20260721_154033.php Initial Bulk Import

<?php
require_once __DIR__ . '/modules/auth/page_acl.php';
$ctx = page_require_access('va_send_entry');

$pdo = $ctx['pdo'];
$company_id = (int)$ctx['company_id'];

require_once __DIR__ . '/partials/header.php';

$msg = '';

/* 1. Date reset na ho isliye variable set kiya */
$selected_date = $_POST['send_date'] ?? date('Y-m-d', strtotime('-1 day'));

/* ===== SAVE (No stock check) ===== */
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    try {
        // Prepare statement ko variable mein sahi se assign kiya
        $stmt = $pdo->prepare("
            INSERT INTO va_send_entry 
            (company_id, send_date, challan_no, party_name, quality, pcs, remark) 
            VALUES (:cid, :dt, :ch, :party, :q, :pcs, :rm)
        ");

$stmt->execute([
            ':cid'    => $company_id,
            ':dt'     => $_POST['send_date'],
            ':ch'     => $_POST['challan_no'],
            ':party'  => $_POST['party_name'],
            ':q'      => $_POST['quality'], 
            ':pcs'    => $_POST['pcs'],
            ':rm'     => $_POST['remark']
        ]);

$msg = "Saved Successfully";
        
        // Save hone ke baad agla challan number set karne ke liye
        $last_no = (int)$_POST['challan_no'];

// PCS reset logic: Save hone ke baad $_POST['pcs'] ko khali kar diya
        $_POST['pcs'] = '';

} catch (PDOException $e) {
        $msg = "Error: " . $e->getMessage();
    }
}

/* ===== AUTO CHALLAN ===== */
if (!isset($last_no)) {
    $last = $pdo->prepare("SELECT MAX(challan_no) FROM va_send_entry WHERE company_id=:cid");
    $last->execute([':cid' => $company_id]);
    $last_no = (int)$last->fetchColumn();
}
$new_challan = $last_no + 1;

/* ===== PARTY LIST ===== */
$parties = $pdo->prepare("SELECT party_name FROM job_work_party_master WHERE company_id=:cid AND is_active=1 ORDER BY party_name");
$parties->execute([':cid' => $company_id]);
$parties = $parties->fetchAll(PDO::FETCH_COLUMN);

/* ===== QUALITY LIST ===== */
$qualities = $pdo->prepare("
    SELECT id, quality_name 
    FROM fabric_quality_master 
    WHERE company_id=:cid 
    ORDER BY quality_name
");
$qualities->execute([':cid' => $company_id]);
$qualities = $qualities->fetchAll(PDO::FETCH_ASSOC);
?>

<div class="container mt-4">
    <div class="card p-3 shadow-sm">
        <div class="d-flex justify-content-between align-items-center mb-3">
            <h4 class="mb-0">VA Send Entry</h4>
            <a href="va_send_list.php" class="btn btn-sm btn-secondary">View List</a>
        </div>

<?php if ($msg): ?>
            <div class="alert alert-success alert-dismissible fade show" role="alert">
                <?= htmlspecialchars($msg) ?>
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
        <?php endif; ?>

<form method="post" id="form" class="row g-3">
            <div class="col-md-2">
                <label class="form-label">Date</label>
                <input type="date" name="send_date" value="<?= htmlspecialchars($selected_date) ?>" class="form-control" required>
            </div>

<div class="col-md-2">
                <label class="form-label">Challan No</label>
                <input type="text" name="challan_no" value="<?= $new_challan ?>" class="form-control" required>
            </div>

<div class="col-md-3">
                <label class="form-label">Party</label>
                <select name="party_name" class="form-select" required>
                    <option value="">Select</option>
                    <?php foreach ($parties as $p): ?>
                        <option value="<?= $p ?>" <?= (isset($_POST['party_name']) && $_POST['party_name'] == $p) ? 'selected' : '' ?>>
                            <?= htmlspecialchars($p) ?>
                        </option>
                    <?php endforeach; ?>
                </select>
            </div>

<div class="col-md-3">
                <label class="form-label">Quality</label>
                <select id="quality" name="quality" class="form-select" required>
                    <option value="">Select</option>
                    <?php foreach ($qualities as $q): ?>
                        <option value="<?= $q['id'] ?>" <?= (isset($_POST['quality']) && $_POST['quality'] == $q['id']) ? 'selected' : '' ?>>
                            <?= htmlspecialchars($q['quality_name']) ?>
                        </option>
                    <?php endforeach; ?>
                </select>
            </div>

<div class="col-md-2">
                <label class="form-label">PCS</label>
                <input type="number" id="pcs" name="pcs" class="form-control" value="<?= htmlspecialchars($_POST['pcs'] ?? '') ?>" required>
            </div>

<div class="col-md-12">
                <label class="form-label">Remark</label>
                <input type="text" name="remark" class="form-control" value="<?= htmlspecialchars($_POST['remark'] ?? '') ?>">
            </div>

<div class="col-md-12">
                <button type="submit" id="btn" class="btn btn-primary px-4">Save Entry</button>
            </div>
        </form>
    </div>
</div>

// Auto focus on PCS for faster entry after save
<?php if ($msg === "Saved Successfully"): ?>
    document.getElementById('pcs').focus();
<?php endif; ?>
</script>

<?php require_once __DIR__ . '/partials/footer.php'; ?>