View Code - 20260721

transport_company_add.php | 20260721_154033.php Initial Bulk Import

<?php
/* ======================================================================
   FILE: /erp/transport_company_add.php
   PURPOSE: Transport Company Master Entry
   ====================================================================== */

error_reporting(E_ALL);
ini_set('display_errors', 1);

/* ---------- AUTH + DB ---------- */
require_once __DIR__ . '/modules/auth/page_acl.php';
require_once __DIR__ . '/helpers/activity_helper.php';
$ctx = page_require_access('transport_company_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'); }

/* ---------- SAVE ---------- */
$msg = $err = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {

$name   = trim($_POST['name'] ?? '');
  $remark = trim($_POST['remark'] ?? '');

if ($name === '') {
        $err = 'Transport company name is required.';
    } else {
        /* ---- DUPLICATE CHECK (COMPANY SCOPED) ---- */
        $chk = $pdo->prepare("
            SELECT id
            FROM transport_companies
            WHERE company_id = ?
                AND name = ?
                AND is_active = 1
            LIMIT 1
        ");
        $chk->execute([$COMPANY_ID, $name]);

if ($chk->fetch()) {
            $err = 'Transport company already exists.';
        } else {

$pdo->prepare("
                INSERT INTO transport_companies
                (company_id, name, remark, created_by, created_at)
                VALUES (?,?,?,?, NOW())
            ")->execute([
                $COMPANY_ID,
                $name,
                $remark ?: null,
                $USER_ID
            ]);

activity_create('parcel', 'transport_company_add', 0, 'Transport company added: ' . $name);

$msg = 'Transport company added successfully.';
        }
    }
}

/* ---------- HEADER ---------- */
require_once __DIR__ . '/partials/header.php';
?>

<div class="wrap">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h2 class="fw-bold m-0">
            <i class="bi bi-truck-front text-primary me-2"></i> Transport Company Entry
        </h2>
        <div class="text-muted small">Master Data Management</div>
    </div>

<?php if ($msg): ?>
        <div class="alert alert-success shadow-sm border-start border-4 border-success rounded-3">
            <i class="bi bi-check-circle-fill me-2"></i> <?= h($msg) ?>
        </div>
    <?php endif; ?>

<?php if ($err): ?>
        <div class="alert alert-danger shadow-sm border-start border-4 border-danger rounded-3">
            <i class="bi bi-exclamation-triangle-fill me-2"></i> <?= h($err) ?>
        </div>
    <?php endif; ?>

<div class="col-md-6">
                    <label class="form-label small fw-bold text-muted text-uppercase">
                        Transport Company Name <span class="text-danger">*</span>
                    </label>
                    <div class="input-group">
                        <span class="input-group-text bg-light border-end-0"><i class="bi bi-building"></i></span>
                        <input type="text" 
                               name="name" 
                               class="form-control border-start-0 ps-0" 
                               placeholder="e.g. Mahadev Logistics" 
                               required>
                    </div>
                    <div class="form-text mt-1 small">Enter the official registered name.</div>
                </div>

<div class="col-md-6">
                    <label class="form-label small fw-bold text-muted text-uppercase">Remark</label>
                    <div class="input-group">
                        <span class="input-group-text bg-light border-end-0"><i class="bi bi-chat-dots"></i></span>
                        <input type="text" 
                               name="remark" 
                               class="form-control border-start-0 ps-0" 
                               placeholder="Additional details...">
                    </div>
                </div>

<div class="col-12 mt-4 text-end">
                    <hr class="mb-4 opacity-25">
                    <button type="reset" class="btn btn-light px-4 me-2">Clear</button>
                    <button type="submit" class="btn btn-primary px-5 fw-bold shadow-sm">
                        <i class="bi bi-save2 me-2"></i> Save Company
                    </button>
                </div>

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