« Back to History
parcel_send_entry_add.php
|
20260920_164915.php
Initial Domain Snapshot
Copy Code
<?php /* ====================================================================== FILE: /erp/parcel_send_entry_add.php PURPOSE: Parcel Send Entry with Searchable Select (Select2) ====================================================================== */ error_reporting(E_ALL); ini_set('display_errors', 1); /* ---------- 1. AUTH + DB ---------- */ require_once __DIR__ . '/modules/auth/page_acl.php'; require_once __DIR__ . '/helpers/activity_helper.php'; // After successful send entry add (insert), add: // activity_create('parcel', 'parcel_send_entry_add', 0, 'Parcel send entry added'); $ctx = page_require_access('parcel_send_entry_add'); $pdo = $ctx['pdo']; $COMPANY_ID = (int)$ctx['company_id']; $USER_ID = (int)$ctx['user']['id']; function h($s){ return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8'); } function buildParcelSendRemark($sendFromLocation, $remark) { $parts = []; if ($sendFromLocation !== '') { $parts[] = 'Send From: ' . preg_replace('/\s+/', ' ', $sendFromLocation); } if ($remark !== '') { $parts[] = preg_replace('/\s+/', ' ', $remark); } return $parts ? implode(' | ', $parts) : null; } /* ---------- 2. DEFAULT FORM STATE ---------- */ $selected_vehicle = ''; $selected_date = date('Y-m-d'); $selected_send_from = ''; $msg = $err = ''; /* ---------- 3. SAVE LOGIC (POST) ---------- */ if ($_SERVER['REQUEST_METHOD'] === 'POST') { $bill_no = trim($_POST['bill_no'] ?? ''); $vehicle_no = trim($_POST['vehicle_no'] ?? ''); $send_date = $_POST['send_date'] ?? ''; $send_from_location = trim($_POST['send_from_location'] ?? ''); $remark = trim($_POST['remark'] ?? ''); $stored_remark = buildParcelSendRemark($send_from_location, $remark); $selected_vehicle = $vehicle_no; $selected_date = $send_date ?: $selected_date; $selected_send_from = $send_from_location; if ($bill_no === '' || $vehicle_no === '' || $send_date === '') { $err = 'Bill No, Vehicle and Send Date are required.'; } else { try { $pdo->beginTransaction(); $stDel = $pdo->prepare("DELETE FROM parcel_send_entry WHERE bill_no = ? AND company_id = ?"); $stDel->execute([$bill_no, $COMPANY_ID]); $sqlIns = "INSERT INTO parcel_send_entry (company_id, bill_no, vehicle_no, send_date, remark, created_at, created_by) VALUES (?, ?, ?, ?, ?, NOW(), ?)"; $pdo->prepare($sqlIns)->execute([ $COMPANY_ID, $bill_no, $vehicle_no, $send_date, $stored_remark, $USER_ID ]); $upd = $pdo->prepare(" UPDATE parcel_stock_in SET status = 'out' WHERE company_id = ? AND bill_no = ? AND status = 'in' "); $upd->execute([$COMPANY_ID, $bill_no]); $pdo->commit(); activity_create('parcel', 'parcel_send_entry_add', 0, "Bill: $bill_no, Vehicle: $vehicle_no, Send Date: $send_date, Remark: $stored_remark"); $msg = "Parcel sent successfully for Bill #$bill_no."; $bill_no = ''; } catch (Exception $e) { if ($pdo->inTransaction()) $pdo->rollBack(); $err = "Database Error: " . $e->getMessage(); } } } /* ---------- 4. FETCH DROPDOWN DATA ---------- */ $stB = $pdo->prepare(" SELECT DISTINCT bill_no FROM parcel_stock_in WHERE company_id = ? AND status = 'in' AND cleared_unknown = 0 ORDER BY bill_no "); $stB->execute([$COMPANY_ID]); $bills = $stB->fetchAll(PDO::FETCH_ASSOC); $stV = $pdo->prepare(" SELECT vehicle_no FROM vehicle_data WHERE company_id = ? AND is_active = 1 ORDER BY vehicle_no "); $stV->execute([$COMPANY_ID]); $vehicles = $stV->fetchAll(PDO::FETCH_ASSOC); /* ---------- 5. RENDER ---------- */ require_once __DIR__ . '/partials/header.php'; ?> <link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" /> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/select2-bootstrap-5-theme@1.3.0/dist/select2-bootstrap-5-theme.min.css" /> <div class="wrap"> <div class="d-flex justify-content-between align-items-center mb-4"> <h2 class="fw-bold">Parcel Send Entry</h2> <span class="badge bg-primary">Company ID: <?= $COMPANY_ID ?></span> </div> <?php if ($msg): ?> <div class="alert alert-success shadow-sm border-start border-4 border-success"> <i class="bi bi-check-circle-fill me-2"></i> <?= $msg ?> </div> <?php endif; ?> <?php if ($err): ?> <div class="alert alert-danger shadow-sm border-start border-4 border-danger"> <i class="bi bi-exclamation-triangle-fill me-2"></i> <?= h($err) ?> </div> <?php endif; ?> <div class="card shadow-sm border-0"> <div class="card-body p-4"> <form method="post" class="row g-4" autocomplete="off"> <div class="col-md-3"> <label class="form-label fw-bold small text-uppercase text-muted">Bill No</label> <select name="bill_no" class="form-select search-select" required> <option value="">Search Bill…</option> <?php foreach ($bills as $b): ?> <option value="<?= h($b['bill_no']) ?>"><?= h($b['bill_no']) ?></option> <?php endforeach; ?> </select> </div> <div class="col-md-3"> <label class="form-label fw-bold small text-uppercase text-muted">Vehicle No</label> <select name="vehicle_no" class="form-select search-select" required> <option value="">Search Vehicle…</option> <?php foreach ($vehicles as $v): ?> <option value="<?= h($v['vehicle_no']) ?>" <?= ($v['vehicle_no'] === $selected_vehicle ? 'selected' : '') ?>> <?= h($v['vehicle_no']) ?> </option> <?php endforeach; ?> </select> </div> <div class="col-md-3"> <label class="form-label fw-bold small text-uppercase text-muted">Send Date</label> <input type="date" name="send_date" class="form-control" value="<?= h($selected_date) ?>" required> </div> <div class="col-md-3"> <label class="form-label fw-bold small text-uppercase text-muted">Remark</label> <input type="text" name="remark" class="form-control" placeholder="Optional notes..."> </div> <div class="col-md-6"> <label class="form-label fw-bold small text-uppercase text-muted">Send From Branch / Godown</label> <input type="text" name="send_from_location" class="form-control" placeholder="e.g. Surat Branch / Main Godown" value="<?= h($selected_send_from) ?>"> </div> <div class="col-12 text-end"> <hr class="my-4 text-muted opacity-25"> <button type="submit" class="btn btn-primary px-5 fw-bold"> <i class="bi bi-send-fill me-2"></i> Save Entry </button> </div> </form> </div> </div> </div> <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script> <script> $(document).ready(function() { $('.search-select').select2({ theme: 'bootstrap-5', width: '100%', placeholder: 'Type to search...' }); }); </script> <?php require_once __DIR__ . '/partials/footer.php'; ?>