« Back to History
saree_quality_design_manage.php
|
20260920_164915.php
Initial Domain Snapshot
Copy Code
<?php require_once __DIR__ . '/modules/auth/page_acl.php'; $ctx = page_require_access('saree_quality_design'); require_once __DIR__ . '/modules/activity/activity_logger.php'; $pdo = $ctx['pdo']; $company_id = (int)$ctx['company_id']; $user_id = (int)($ctx['user']['id'] ?? 0); function h($s){ return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8'); } // CSRF Token if (empty($_SESSION['csrf_token'])) { $_SESSION['csrf_token'] = bin2hex(random_bytes(32)); } // ================= FETCH QUALITIES (For Dropdown) ================= $stmt = $pdo->prepare("SELECT id, quality_name FROM saree_quality WHERE company_id = ? AND status = 1 ORDER BY quality_name ASC"); $stmt->execute([$company_id]); $qualities = $stmt->fetchAll(PDO::FETCH_ASSOC); // ================= SAVE / UPDATE LOGIC ================= if ($_SERVER['REQUEST_METHOD'] === 'POST') { if (!hash_equals($_SESSION['csrf_token'], $_POST['csrf_token'] ?? '')) { die('Invalid CSRF token'); } $id = (int)($_POST['id'] ?? 0); $quality_id = (int)($_POST['quality_id'] ?? 0); $design_name = trim($_POST['design_name'] ?? ''); $status = ($_POST['status'] === '1') ? 1 : 0; if ($design_name !== '' && $quality_id > 0) { if ($id > 0) { $stmt = $pdo->prepare("UPDATE saree_quality_design SET quality_id = ?, design_name = ?, status = ?, updated_at = NOW() WHERE id = ? AND company_id = ?"); $stmt->execute([$quality_id, $design_name, $status, $id, $company_id]); activity_log([ 'company_id' => $company_id, 'user_id' => $user_id, 'module' => 'saree', 'action_name' => 'edit', 'entity_type' => 'saree_quality_design', 'entity_id' => $id, 'remarks' => 'Updated saree quality design' ]); } else { $stmt = $pdo->prepare("INSERT INTO saree_quality_design (company_id, quality_id, design_name, status, created_at) VALUES (?, ?, ?, ?, NOW())"); $stmt->execute([$company_id, $quality_id, $design_name, $status]); activity_log([ 'company_id' => $company_id, 'user_id' => $user_id, 'module' => 'saree', 'action_name' => 'create', 'entity_type' => 'saree_quality_design', 'entity_id' => (int)$pdo->lastInsertId(), 'remarks' => 'Created saree quality design' ]); } header("Location: " . $_SERVER['PHP_SELF']); exit; } } // ================= DELETE LOGIC ================= if (isset($_GET['delete'])) { $delete_id = (int)$_GET['delete']; $stmt = $pdo->prepare("DELETE FROM saree_quality_design WHERE id = ? AND company_id = ?"); $stmt->execute([$delete_id, $company_id]); activity_log([ 'company_id' => $company_id, 'user_id' => $user_id, 'module' => 'saree', 'action_name' => 'delete', 'entity_type' => 'saree_quality_design', 'entity_id' => $delete_id, 'remarks' => 'Deleted saree quality design' ]); header("Location: " . $_SERVER['PHP_SELF']); exit; } // ================= EDIT FETCH ================= $edit = null; if (isset($_GET['edit'])) { $stmt = $pdo->prepare("SELECT * FROM saree_quality_design WHERE id = ? AND company_id = ?"); $stmt->execute([(int)$_GET['edit'], $company_id]); $edit = $stmt->fetch(PDO::FETCH_ASSOC); } // ================= LIST FETCH (With Join for Quality Name) ================= $stmt = $pdo->prepare(" SELECT d.*, q.quality_name FROM saree_quality_design d LEFT JOIN saree_quality q ON d.quality_id = q.id WHERE d.company_id = ? ORDER BY d.id DESC "); $stmt->execute([$company_id]); $rows = $stmt->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-dark text-white py-3"> <h5 class="mb-0 fw-bold"><?= $edit ? 'Edit Design' : 'Add New Design' ?></h5> </div> <div class="card-body"> <form method="post"> <input type="hidden" name="csrf_token" value="<?=h($_SESSION['csrf_token'])?>"> <input type="hidden" name="id" value="<?=h($edit['id'] ?? 0)?>"> <div class="mb-3"> <label class="form-label small fw-bold">Select Quality *</label> <select name="quality_id" class="form-select" required> <option value="">-- Choose Quality --</option> <?php foreach ($qualities as $q): ?> <option value="<?= $q['id'] ?>" <?= ($edit && $edit['quality_id'] == $q['id']) ? 'selected' : '' ?>> <?= h($q['quality_name']) ?> </option> <?php endforeach; ?> </select> </div> <div class="mb-3"> <label class="form-label small fw-bold">Design Name *</label> <input type="text" name="design_name" class="form-control" value="<?=h($edit['design_name'] ?? '')?>" required placeholder="e.g. Butti, Floral"> </div> <div class="mb-3"> <label class="form-label small fw-bold">Status</label> <select name="status" class="form-select"> <option value="1" <?=($edit && $edit['status'] == 1) ? 'selected' : ''?>>Active</option> <option value="0" <?=($edit && $edit['status'] == 0 && isset($edit)) ? 'selected' : ''?>>Inactive</option> </select> </div> <div class="d-grid gap-2"> <button type="submit" class="btn btn-primary"><?= $edit ? 'Update Design' : 'Save Design' ?></button> <?php if($edit): ?> <a href="<?=h($_SERVER['PHP_SELF'])?>" class="btn btn-secondary">Cancel</a> <?php endif; ?> </div> </form> </div> </div> </div> <div class="col-md-8"> <div class="card shadow-sm border-0"> <div class="card-header bg-white py-3 d-flex justify-content-between align-items-center"> <h5 class="mb-0 fw-bold">Saree Quality Designs</h5> </div> <div class="card-body p-0"> <div class="table-responsive"> <table class="table table-hover align-middle mb-0"> <thead class="table-light text-secondary"> <tr> <th class="ps-3" width="80">ID</th> <th>Quality</th> <th>Design Name</th> <th>Status</th> <th class="text-center">Action</th> </tr> </thead> <tbody> <?php foreach ($rows as $r): ?> <tr> <td class="ps-3"><?= $r['id'] ?></td> <td><span class="badge bg-info text-dark"><?= h($r['quality_name'] ?? 'N/A') ?></span></td> <td class="fw-bold"><?= h($r['design_name']) ?></td> <td> <span class="badge <?= $r['status'] == 1 ? 'bg-success' : 'bg-danger' ?>"> <?= $r['status'] == 1 ? 'Active' : 'Inactive' ?> </span> </td> <td class="text-center"> <a href="?edit=<?=$r['id']?>" class="btn btn-sm btn-outline-primary me-1">Edit</a> <a href="?delete=<?=$r['id']?>" class="btn btn-sm btn-outline-danger" onclick="return confirm('Delete this design?')">Delete</a> </td> </tr> <?php endforeach; ?> <?php if(empty($rows)): ?> <tr><td colspan="5" class="text-center py-4">No designs found.</td></tr> <?php endif; ?> </tbody> </table> </div> </div> </div> </div> </div> </div> <?php require_once __DIR__ . '/partials/footer.php'; ?>