View Code - 20260722

saree_out_party_manage.php | 20260722_120325.php Initial Domain Snapshot

<?php
require_once __DIR__ . '/modules/auth/page_acl.php';
$ctx = page_require_access('saree_out_party');
require_once __DIR__ . '/modules/activity/activity_logger.php';
$pdo = $ctx['pdo'];
$company_id = (int)$ctx['company_id'];
$user_id = $ctx['user_id'] ?? $_SESSION['user_id'] ?? 0;

// SAVE / UPDATE Logic
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $id = (int)($_POST['id'] ?? 0);
    if ($id > 0) {
        $stmt = $pdo->prepare("UPDATE saree_out_party SET party_name=?, contact_person=?, mobile=?, address=?, city=?, gst_no=? WHERE id=? AND company_id=?");
        $stmt->execute([$_POST['party_name'], $_POST['contact_person'], $_POST['mobile'], $_POST['address'], $_POST['city'], $_POST['gst_no'], $id, $company_id]);
        activity_log([
            'company_id'  => $company_id,
            'user_id'     => (int)$user_id,
            'module'      => 'saree',
            'action_name' => 'edit',
            'entity_type' => 'saree_out_party',
            'entity_id'   => $id,
            'remarks'     => 'Updated saree out party'
        ]);
    } else {
        $stmt = $pdo->prepare("INSERT INTO saree_out_party (company_id, party_name, contact_person, mobile, address, city, gst_no, status, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, 1, NOW())");
        $stmt->execute([$company_id, $_POST['party_name'], $_POST['contact_person'], $_POST['mobile'], $_POST['address'], $_POST['city'], $_POST['gst_no']]);
        activity_log([
            'company_id'  => $company_id,
            'user_id'     => (int)$user_id,
            'module'      => 'saree',
            'action_name' => 'create',
            'entity_type' => 'saree_out_party',
            'entity_id'   => (int)$pdo->lastInsertId(),
            'remarks'     => 'Created saree out party'
        ]);
    }
    header("Location: " . $_SERVER['PHP_SELF']); exit;
}

// DELETE Logic
if (isset($_GET['delete'])) {
    $delete_id = (int)$_GET['delete'];
    $stmt = $pdo->prepare("DELETE FROM saree_out_party WHERE id=? AND company_id=?");
    $stmt->execute([$delete_id, $company_id]);
    activity_log([
        'company_id'  => $company_id,
        'user_id'     => (int)$user_id,
        'module'      => 'saree',
        'action_name' => 'delete',
        'entity_type' => 'saree_out_party',
        'entity_id'   => $delete_id,
        'remarks'     => 'Deleted saree out party'
    ]);
    header("Location: " . $_SERVER['PHP_SELF']); exit;
}

// FETCH for Edit
$edit = null;
if (isset($_GET['edit'])) {
    $stmt = $pdo->prepare("SELECT * FROM saree_out_party WHERE id=? AND company_id=?");
    $stmt->execute([(int)$_GET['edit'], $company_id]);
    $edit = $stmt->fetch(PDO::FETCH_ASSOC);
}

$parties = $pdo->prepare("SELECT * FROM saree_out_party WHERE company_id=? ORDER BY id DESC");
$parties->execute([$company_id]);
$rows = $parties->fetchAll(PDO::FETCH_ASSOC);

require_once __DIR__ . '/partials/header.php';
?>
<div class="container-fluid mt-4">
    <div class="row">
        <div class="col-md-4">
            <div class="card shadow-sm border-0 mb-4">
                <div class="card-header bg-primary text-white fw-bold"><?= $edit ? 'Edit Party' : 'Add New Party' ?></div>
                <div class="card-body">
                    <form method="post" class="row g-3">
                        <input type="hidden" name="id" value="<?= $edit['id'] ?? '' ?>">
                        <div class="col-12 text-black">
                            <label class="form-label small fw-bold">Party Name</label>
                            <input type="text" name="party_name" class="form-control" value="<?= $edit['party_name'] ?? '' ?>" required>
                        </div>
                        <div class="col-md-6">
                            <label class="form-label small fw-bold">Mobile</label>
                            <input type="text" name="mobile" class="form-control" value="<?= $edit['mobile'] ?? '' ?>">
                        </div>
                        <div class="col-md-6">
                            <label class="form-label small fw-bold">City</label>
                            <input type="text" name="city" class="form-control" value="<?= $edit['city'] ?? '' ?>">
                        </div>
                        <div class="col-12">
                            <button type="submit" class="btn btn-success w-100"><?= $edit ? 'Update' : 'Save' ?></button>
                        </div>
                    </form>
                </div>
            </div>
        </div>
        <div class="col-md-8">
            <div class="card shadow-sm border-0">
                <div class="table-responsive">
                    <table class="table table-hover align-middle mb-0">
                        <thead class="table-light">
                            <tr>
                                <th>Party Name</th>
                                <th>Mobile</th>
                                <th>City</th>
                                <th class="text-center">Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach($rows as $r): ?>
                            <tr>
                                <td class="fw-bold"><?= htmlspecialchars($r['party_name']) ?></td>
                                <td><?= htmlspecialchars($r['mobile']) ?></td>
                                <td><?= htmlspecialchars($r['city']) ?></td>
                                <td class="text-center">
                                    <a href="?edit=<?= $r['id'] ?>" class="btn btn-sm btn-outline-primary">Edit</a>
                                    <a href="?delete=<?= $r['id'] ?>" class="btn btn-sm btn-outline-danger" onclick="return confirm('Delete?')">Del</a>
                                </td>
                            </tr>
                            <?php endforeach; ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
<?php require_once __DIR__ . '/partials/footer.php'; ?>