๐ File Manager
Editing:
/home/wvl7mof7402e/public_html/chem/admin/add_industry.php
<?php /* |-------------------------------------------------------------------------- | PURE CHEMICAL - INDUSTRY MANAGEMENT |-------------------------------------------------------------------------- | Existing tables only: | industries, media, industry_media | Shared sidebar: admin/sidebar.php |-------------------------------------------------------------------------- */ if (session_status() !== PHP_SESSION_ACTIVE) { session_start(); } $page_title = 'Industry Management'; $active_menu = 'industries'; error_reporting(E_ALL); ini_set('display_errors', '0'); if (!isset($_SESSION['industry_csrf'])) { $_SESSION['industry_csrf'] = bin2hex(random_bytes(32)); } /* ----------------------------------------------------------------------- DATABASE CONNECTION ----------------------------------------------------------------------- */ $pdo = $pdo ?? null; if (!$pdo instanceof PDO) { $connectionFiles = [ __DIR__ . '/config/database.php', __DIR__ . '/config/db.php', __DIR__ . '/includes/database.php', __DIR__ . '/includes/db.php', dirname(__DIR__) . '/config/database.php', dirname(__DIR__) . '/config/db.php', dirname(__DIR__) . '/includes/database.php', dirname(__DIR__) . '/includes/db.php', dirname(__DIR__) . '/db.php', dirname(__DIR__) . '/connection.php', ]; foreach ($connectionFiles as $connectionFile) { if (!is_file($connectionFile)) { continue; } require_once $connectionFile; if (($pdo ?? null) instanceof PDO) { break; } if (($conn ?? null) instanceof PDO) { $pdo = $conn; break; } if (($db ?? null) instanceof PDO) { $pdo = $db; break; } } } if (!$pdo instanceof PDO) { http_response_code(500); exit( 'Database connection nahi mila. Apne project ke existing database ' . 'connection file ka path is page ke connection section mein add karein.' ); } $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); /* ----------------------------------------------------------------------- HELPERS ----------------------------------------------------------------------- */ function e($value): string { return htmlspecialchars((string)($value ?? ''), ENT_QUOTES, 'UTF-8'); } function dbColumns(PDO $pdo, string $table): array { $allowed = ['industries', 'media', 'industry_media']; if (!in_array($table, $allowed, true)) { throw new RuntimeException('Invalid table name.'); } $columns = []; $stmt = $pdo->query("SHOW COLUMNS FROM `$table`"); foreach ($stmt->fetchAll() as $column) { $columns[$column['Field']] = $column; } return $columns; } function columnExists(array $columns, string $name): bool { return isset($columns[$name]); } function columnEnumValues(array $column): array { $type = (string)($column['Type'] ?? ''); if (stripos($type, 'enum(') !== 0) { return []; } preg_match_all("/'((?:[^'\\\\]|\\\\.)*)'/", $type, $matches); return array_map( static fn($value) => stripcslashes($value), $matches[1] ?? [] ); } function slugBase(string $value): string { $value = trim(mb_strtolower($value, 'UTF-8')); if (function_exists('iconv')) { $converted = iconv('UTF-8', 'ASCII//TRANSLIT//IGNORE', $value); if ($converted !== false) { $value = $converted; } } $value = preg_replace('/[^a-z0-9]+/', '-', $value) ?? ''; $value = trim($value, '-'); return $value !== '' ? $value : 'industry'; } function uniqueIndustrySlug( PDO $pdo, string $name, array $industryColumns, int $excludeId = 0 ): string { $base = slugBase($name); $candidate = $base; $number = 2; while (true) { $sql = 'SELECT id FROM industries WHERE slug = :slug'; $params = [':slug' => $candidate]; if ($excludeId > 0) { $sql .= ' AND id <> :exclude_id'; $params[':exclude_id'] = $excludeId; } $sql .= ' LIMIT 1'; $stmt = $pdo->prepare($sql); $stmt->execute($params); if (!$stmt->fetch()) { return $candidate; } $candidate = $base . '-' . $number; $number++; } } function redirectToPage(array $params = []): never { $url = 'add_industry.php'; if ($params) { $url .= '?' . http_build_query($params); } header('Location: ' . $url); exit; } function flashMessage(string $type, string $message): void { $_SESSION['industry_flash'] = [ 'type' => $type, 'message' => $message, ]; } function makeDirectory(string $path): void { if (!is_dir($path) && !mkdir($path, 0755, true) && !is_dir($path)) { throw new RuntimeException('Upload folder create nahi ho saka.'); } } /* ----------------------------------------------------------------------- MEDIA UPLOAD ----------------------------------------------------------------------- */ function uploadIndustryMedia( PDO $pdo, array $file, string $role, array $mediaColumns ): int { if ( !isset($file['error']) || is_array($file['error']) || $file['error'] !== UPLOAD_ERR_OK ) { throw new RuntimeException('File upload nahi ho saka.'); } if (($file['size'] ?? 0) <= 0 || $file['size'] > 10 * 1024 * 1024) { throw new RuntimeException('Image ka size 10 MB se kam hona chahiye.'); } $tmp = $file['tmp_name'] ?? ''; if (!$tmp || !is_uploaded_file($tmp)) { throw new RuntimeException('Invalid uploaded file.'); } $finfo = new finfo(FILEINFO_MIME_TYPE); $mime = $finfo->file($tmp); $allowedTypes = [ 'image/jpeg' => 'jpg', 'image/png' => 'png', 'image/webp' => 'webp', 'image/gif' => 'gif', ]; if (!isset($allowedTypes[$mime])) { throw new RuntimeException('Sirf JPG, PNG, WEBP aur GIF images allowed hain.'); } $extension = $allowedTypes[$mime]; $originalName = basename((string)($file['name'] ?? 'image')); $newName = bin2hex(random_bytes(16)) . '.' . $extension; $projectRoot = dirname(__DIR__); $uploadDirectory = $projectRoot . '/uploads/industries'; makeDirectory($uploadDirectory); $destination = $uploadDirectory . '/' . $newName; if (!move_uploaded_file($tmp, $destination)) { throw new RuntimeException('Image ko upload folder mein save nahi kar sake.'); } $relativePath = 'uploads/industries/' . $newName; $imageInfo = @getimagesize($destination); $width = $imageInfo ? (int)$imageInfo[0] : null; $height = $imageInfo ? (int)$imageInfo[1] : null; $values = [ 'original_name' => $originalName, 'file_name' => $newName, 'file_path' => $relativePath, 'mime_type' => $mime, 'file_type' => 'image', 'extension' => $extension, 'file_size' => (int)$file['size'], 'width' => $width, 'height' => $height, 'alt_text' => pathinfo($originalName, PATHINFO_FILENAME), 'title' => pathinfo($originalName, PATHINFO_FILENAME), 'caption' => null, 'thumbnail_path' => null, ]; $insertValues = []; foreach ($values as $column => $value) { if (columnExists($mediaColumns, $column)) { $insertValues[$column] = $value; } } foreach (['original_name', 'file_name', 'file_path'] as $requiredColumn) { if (!columnExists($mediaColumns, $requiredColumn)) { @unlink($destination); throw new RuntimeException( "media table mein required column missing hai: $requiredColumn" ); } } foreach ($mediaColumns as $name => $column) { if ( ($column['Null'] ?? 'YES') === 'NO' && ($column['Default'] ?? null) === null && ($column['Extra'] ?? '') !== 'auto_increment' && !array_key_exists($name, $insertValues) ) { $type = strtolower((string)$column['Type']); if (str_contains($type, 'enum(')) { $enumValues = columnEnumValues($column); if ($name === 'status') { foreach (['active', 'published', 'enabled', 'approved'] as $choice) { if (in_array($choice, $enumValues, true)) { $insertValues[$name] = $choice; break; } } } if (!array_key_exists($name, $insertValues) && $enumValues) { $insertValues[$name] = $enumValues[0]; } } elseif ( str_contains($type, 'int') || str_contains($type, 'decimal') || str_contains($type, 'float') || str_contains($type, 'double') ) { $insertValues[$name] = 0; } elseif (str_contains($type, 'date') || str_contains($type, 'time')) { if (str_contains($type, 'timestamp') || str_contains($type, 'datetime')) { $insertValues[$name] = date('Y-m-d H:i:s'); } else { $insertValues[$name] = date('Y-m-d'); } } else { $insertValues[$name] = ''; } } } $names = array_keys($insertValues); $quotedNames = array_map(static fn($name) => "`$name`", $names); $placeholders = array_map(static fn($name) => ':' . $name, $names); $sql = 'INSERT INTO media (' . implode(', ', $quotedNames) . ') VALUES (' . implode(', ', $placeholders) . ')'; try { $stmt = $pdo->prepare($sql); $params = []; foreach ($insertValues as $name => $value) { $params[':' . $name] = $value; } $stmt->execute($params); return (int)$pdo->lastInsertId(); } catch (Throwable $exception) { @unlink($destination); throw $exception; } } /* ----------------------------------------------------------------------- DATABASE SCHEMA CHECK ----------------------------------------------------------------------- */ try { $industryColumns = dbColumns($pdo, 'industries'); $mediaColumns = dbColumns($pdo, 'media'); $industryMediaColumns = dbColumns($pdo, 'industry_media'); foreach ([ 'id', 'name', 'slug', 'parent_id', 'short_description', 'description', 'banner_id', 'featured_image_id', 'status', 'featured', 'sort_order' ] as $required) { if (!columnExists($industryColumns, $required)) { throw new RuntimeException( "industries table mein required column missing hai: $required" ); } } foreach (['industry_id', 'media_id', 'media_role', 'sort_order'] as $required) { if (!columnExists($industryMediaColumns, $required)) { throw new RuntimeException( "industry_media table mein required column missing hai: $required" ); } } } catch (Throwable $exception) { http_response_code(500); exit('Database schema check failed: ' . e($exception->getMessage())); } /* ----------------------------------------------------------------------- FLASH MESSAGE ----------------------------------------------------------------------- */ $flash = $_SESSION['industry_flash'] ?? null; unset($_SESSION['industry_flash']); $errorMessage = ''; /* ----------------------------------------------------------------------- POST ACTIONS ----------------------------------------------------------------------- */ if ($_SERVER['REQUEST_METHOD'] === 'POST') { try { $csrf = (string)($_POST['csrf_token'] ?? ''); if (!hash_equals((string)$_SESSION['industry_csrf'], $csrf)) { throw new RuntimeException('Security token expire ho gaya. Page refresh karke dobara try karein.'); } $action = (string)($_POST['action'] ?? ''); if ($action === 'save') { $id = max(0, (int)($_POST['id'] ?? 0)); $name = trim((string)($_POST['name'] ?? '')); $shortDescription = trim((string)($_POST['short_description'] ?? '')); $description = trim((string)($_POST['description'] ?? '')); $status = (string)($_POST['status'] ?? 'draft'); $featured = isset($_POST['featured']) ? 1 : 0; $sortOrder = max(0, (int)($_POST['sort_order'] ?? 0)); $parentId = (int)($_POST['parent_id'] ?? 0); $parentId = $parentId > 0 ? $parentId : null; if ($name === '') { throw new RuntimeException('Industry name required hai.'); } if (mb_strlen($name) > 190) { throw new RuntimeException('Industry name 190 characters se chhota rakhein.'); } if ($id > 0) { $existingStmt = $pdo->prepare('SELECT id FROM industries WHERE id = :id'); $existingStmt->execute([':id' => $id]); if (!$existingStmt->fetch()) { throw new RuntimeException('Industry record nahi mila.'); } } if ($parentId !== null) { if ($parentId === $id) { throw new RuntimeException('Industry ko khud ka parent nahi bana sakte.'); } $parentStmt = $pdo->prepare('SELECT id FROM industries WHERE id = :id'); $parentStmt->execute([':id' => $parentId]); if (!$parentStmt->fetch()) { throw new RuntimeException('Selected parent industry valid nahi hai.'); } } $statusColumn = $industryColumns['status']; $allowedStatuses = columnEnumValues($statusColumn); if (!$allowedStatuses) { $allowedStatuses = ['active', 'inactive', 'draft']; } if (!in_array($status, $allowedStatuses, true)) { $status = in_array('draft', $allowedStatuses, true) ? 'draft' : $allowedStatuses[0]; } $slug = uniqueIndustrySlug($pdo, $name, $industryColumns, $id); $pdo->beginTransaction(); if ($id > 0) { $sql = 'UPDATE industries SET parent_id = :parent_id, name = :name, slug = :slug, short_description = :short_description, description = :description, status = :status, featured = :featured, sort_order = :sort_order'; $params = [ ':parent_id' => $parentId, ':name' => $name, ':slug' => $slug, ':short_description' => $shortDescription !== '' ? $shortDescription : null, ':description' => $description !== '' ? $description : null, ':status' => $status, ':featured' => $featured, ':sort_order' => $sortOrder, ':id' => $id, ]; if (columnExists($industryColumns, 'updated_at')) { $sql .= ', updated_at = NOW()'; } $sql .= ' WHERE id = :id'; $stmt = $pdo->prepare($sql); $stmt->execute($params); } else { $stmt = $pdo->prepare( 'INSERT INTO industries (parent_id, name, slug, short_description, description, status, featured, sort_order) VALUES (:parent_id, :name, :slug, :short_description, :description, :status, :featured, :sort_order)' ); $stmt->execute([ ':parent_id' => $parentId, ':name' => $name, ':slug' => $slug, ':short_description' => $shortDescription !== '' ? $shortDescription : null, ':description' => $description !== '' ? $description : null, ':status' => $status, ':featured' => $featured, ':sort_order' => $sortOrder, ]); $id = (int)$pdo->lastInsertId(); } /* Featured image and banner */ $singleUploads = [ 'featured_image' => 'featured_image_id', 'banner_image' => 'banner_id', ]; foreach ($singleUploads as $inputName => $targetColumn) { if ( isset($_FILES[$inputName]) && ($_FILES[$inputName]['error'] ?? UPLOAD_ERR_NO_FILE) !== UPLOAD_ERR_NO_FILE ) { $mediaId = uploadIndustryMedia( $pdo, $_FILES[$inputName], 'image', $mediaColumns ); $update = $pdo->prepare( "UPDATE industries SET `$targetColumn` = :media_id WHERE id = :id" ); $update->execute([ ':media_id' => $mediaId, ':id' => $id, ]); } } /* Multiple gallery images */ if ( isset($_FILES['gallery_images']['name']) && is_array($_FILES['gallery_images']['name']) ) { $total = count($_FILES['gallery_images']['name']); if ($total > 30) { throw new RuntimeException('Ek baar mein maximum 30 gallery images upload karein.'); } $roleValues = columnEnumValues($industryMediaColumns['media_role']); $galleryRole = in_array('gallery', $roleValues, true) ? 'gallery' : (in_array('image', $roleValues, true) ? 'image' : ($roleValues[0] ?? 'image')); for ($i = 0; $i < $total; $i++) { $fileError = $_FILES['gallery_images']['error'][$i] ?? UPLOAD_ERR_NO_FILE; if ($fileError === UPLOAD_ERR_NO_FILE) { continue; } $file = [ 'name' => $_FILES['gallery_images']['name'][$i], 'type' => $_FILES['gallery_images']['type'][$i] ?? '', 'tmp_name' => $_FILES['gallery_images']['tmp_name'][$i], 'error' => $fileError, 'size' => $_FILES['gallery_images']['size'][$i] ?? 0, ]; $mediaId = uploadIndustryMedia( $pdo, $file, $galleryRole, $mediaColumns ); $linkValues = [ 'industry_id' => $id, 'media_id' => $mediaId, 'media_role' => $galleryRole, 'sort_order' => $i, ]; $linkColumns = []; $linkPlaceholders = []; $linkParams = []; foreach ($linkValues as $column => $value) { if (columnExists($industryMediaColumns, $column)) { $linkColumns[] = "`$column`"; $linkPlaceholders[] = ':' . $column; $linkParams[':' . $column] = $value; } } $linkSql = 'INSERT INTO industry_media (' . implode(', ', $linkColumns) . ') VALUES (' . implode(', ', $linkPlaceholders) . ')'; $linkStmt = $pdo->prepare($linkSql); $linkStmt->execute($linkParams); } } $pdo->commit(); flashMessage('success', $id > 0 ? 'Industry successfully update ho gayi.' : 'New industry successfully create ho gayi.'); redirectToPage(['edit' => $id]); } if ($action === 'delete') { $id = (int)($_POST['id'] ?? 0); if ($id <= 0) { throw new RuntimeException('Invalid industry ID.'); } $pdo->beginTransaction(); $checkChildren = $pdo->prepare( 'SELECT COUNT(*) FROM industries WHERE parent_id = :id' ); $checkChildren->execute([':id' => $id]); if ((int)$checkChildren->fetchColumn() > 0) { throw new RuntimeException( 'Is industry ke andar sub-industries hain. Pehle unka parent change karein.' ); } $deleteLinks = $pdo->prepare( 'DELETE FROM industry_media WHERE industry_id = :id' ); $deleteLinks->execute([':id' => $id]); $deleteIndustry = $pdo->prepare( 'DELETE FROM industries WHERE id = :id' ); $deleteIndustry->execute([':id' => $id]); $pdo->commit(); flashMessage('success', 'Industry delete ho gayi. Media files ko jaanbujhkar delete nahi kiya gaya.'); redirectToPage(); } throw new RuntimeException('Invalid action.'); } catch (Throwable $exception) { if ($pdo->inTransaction()) { $pdo->rollBack(); } $errorMessage = $exception->getMessage(); } } /* ----------------------------------------------------------------------- EDIT RECORD ----------------------------------------------------------------------- */ $editIndustry = null; $editId = (int)($_GET['edit'] ?? 0); if ($editId > 0) { $editStmt = $pdo->prepare('SELECT * FROM industries WHERE id = :id'); $editStmt->execute([':id' => $editId]); $editIndustry = $editStmt->fetch() ?: null; } /* ----------------------------------------------------------------------- SEARCH / FILTER / PAGINATION ----------------------------------------------------------------------- */ $search = trim((string)($_GET['q'] ?? '')); $filterStatus = trim((string)($_GET['status'] ?? '')); $page = max(1, (int)($_GET['page'] ?? 1)); $perPage = 10; $where = []; $params = []; if ($search !== '') { $where[] = '(i.name LIKE :search OR i.slug LIKE :search OR i.short_description LIKE :search)'; $params[':search'] = '%' . $search . '%'; } if ($filterStatus !== '' && in_array( $filterStatus, columnEnumValues($industryColumns['status']), true )) { $where[] = 'i.status = :status_filter'; $params[':status_filter'] = $filterStatus; } $whereSql = $where ? 'WHERE ' . implode(' AND ', $where) : ''; $countStmt = $pdo->prepare("SELECT COUNT(*) FROM industries i $whereSql"); $countStmt->execute($params); $totalRows = (int)$countStmt->fetchColumn(); $totalPages = max(1, (int)ceil($totalRows / $perPage)); $page = min($page, $totalPages); $offset = ($page - 1) * $perPage; $listSql = " SELECT i.*, parent.name AS parent_name, fm.file_path AS featured_path, bm.file_path AS banner_path FROM industries i LEFT JOIN industries parent ON parent.id = i.parent_id LEFT JOIN media fm ON fm.id = i.featured_image_id LEFT JOIN media bm ON bm.id = i.banner_id $whereSql ORDER BY i.sort_order ASC, i.id DESC LIMIT $perPage OFFSET $offset "; $listStmt = $pdo->prepare($listSql); $listStmt->execute($params); $industries = $listStmt->fetchAll(); $parentsStmt = $pdo->prepare( 'SELECT id, name FROM industries ORDER BY name ASC' ); $parentsStmt->execute(); $parentOptions = $parentsStmt->fetchAll(); $statusOptions = columnEnumValues($industryColumns['status']); if (!$statusOptions) { $statusOptions = ['active', 'inactive', 'draft']; } $galleryCountStmt = $pdo->prepare( "SELECT COUNT(*) FROM industry_media WHERE industry_id = :id" ); function industryImageUrl(?string $path): string { if (!$path) { return ''; } if (preg_match('~^https?://~i', $path)) { return $path; } return '../' . ltrim($path, '/'); } function industryStatusClass(string $status): string { return match (strtolower($status)) { 'active', 'published', 'enabled' => 'status-active', 'inactive', 'disabled' => 'status-inactive', default => 'status-draft', }; } ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title><?= e($page_title) ?> | Pure Chemical Admin</title> <style> :root{ --pi-primary:#6257e8; --pi-primary-dark:#4e43ce; --pi-bg:#f5f7fc; --pi-card:#fff; --pi-text:#20253a; --pi-muted:#7a8197; --pi-border:#e8ebf3; --pi-green:#0c9c6b; --pi-red:#dc465b; --pi-radius:16px; --pi-shadow:0 4px 20px rgba(31,42,75,.04); } *{box-sizing:border-box} body{ margin:0; background:var(--pi-bg); color:var(--pi-text); font-family:Inter,-apple-system,BlinkMacSystemFont,"Segoe UI",sans-serif; font-size:14px; } a{color:inherit;text-decoration:none} button,input,textarea,select{font:inherit} /* Prime UI Modern Sidebar + Main Layout Fix */ .pi-layout{ display:flex; min-height:100vh; width:100%; position:relative; } /* Sidebar wrapper styling agar sidebar.php fixed/absolute ya float ho toh overlap na ho */ .pi-layout > aside, .pi-layout > div.sidebar, .pi-layout > .sidebar-container { flex-shrink:0; width:260px; background:#fff; border-right:1px solid var(--pi-border); position:sticky; top:0; height:100vh; overflow-y:auto; z-index:100; } .pi-main{ flex-grow:1; min-width:0; display:flex; flex-direction:column; background:var(--pi-bg); } .pi-topbar{ min-height:78px; padding:17px 30px; display:flex; align-items:center; justify-content:space-between; gap:16px; background:#fff; border-bottom:1px solid var(--pi-border); position:sticky; top:0; z-index:19; } .pi-topbar h1{margin:0;font-size:21px;font-weight:800;letter-spacing:-.55px} .pi-topbar p{margin:6px 0 0;color:var(--pi-muted);font-size:12px} .pi-top-actions{display:flex;align-items:center;gap:10px;flex-wrap:wrap} .pi-admin-chip,.pi-view-link{ display:inline-flex;align-items:center;gap:8px; padding:10px 13px;border-radius:11px;font-size:12px;font-weight:750; } .pi-admin-chip{background:#f3f4fa;color:#48506a} .pi-view-link{background:#eeedff;color:var(--pi-primary)} .pi-dot{width:8px;height:8px;background:#13ae77;border-radius:50%} .pi-content{max-width:1600px;width:100%;margin:auto;padding:26px 30px 42px} .pi-page-heading{ display:flex;align-items:flex-start;justify-content:space-between; gap:18px;margin-bottom:22px;flex-wrap:wrap; } .pi-page-heading h2{font-size:23px;letter-spacing:-.6px;margin:0;font-weight:850} .pi-page-heading p{margin:7px 0 0;color:var(--pi-muted);font-size:13px} .pi-btn{ border:0;display:inline-flex;align-items:center;justify-content:center; gap:8px;padding:11px 16px;border-radius:10px;cursor:pointer; font-weight:750;font-size:12px;transition:.18s ease; white-space:nowrap; } .pi-btn-primary{background:var(--pi-primary);color:#fff;box-shadow:0 4px 12px rgba(98,87,232,0.25)} .pi-btn-primary:hover{background:var(--pi-primary-dark);transform:translateY(-1px)} .pi-btn-light{background:#f0f2f8;color:#4b536b} .pi-btn-light:hover{background:#e4e7f2} .pi-btn-danger{background:#fff0f1;color:var(--pi-red)} .pi-btn-danger:hover{background:#ffe3e6} .pi-btn-small{padding:7px 12px;font-size:11px;border-radius:8px} .pi-alert{padding:14px 17px;border-radius:12px;margin-bottom:18px;font-weight:650;line-height:1.55} .pi-alert-success{background:#eaf9f2;color:#087c53;border:1px solid #c8f0dd} .pi-alert-error{background:#fff0f1;color:#b52f45;border:1px solid #ffd9df} .pi-stats{display:grid;grid-template-columns:repeat(3,minmax(0,1fr));gap:16px;margin-bottom:20px} .pi-stat{ background:#fff;border:1px solid var(--pi-border);border-radius:var(--pi-radius); padding:19px 20px;box-shadow:var(--pi-shadow); } .pi-stat-label{color:var(--pi-muted);font-size:12px;font-weight:650} .pi-stat-value{font-size:27px;font-weight:850;letter-spacing:-.7px;margin-top:10px} .pi-card{background:var(--pi-card);border:1px solid var(--pi-border);border-radius:var(--pi-radius);box-shadow:var(--pi-shadow);overflow:hidden} .pi-card-head{ display:flex;align-items:center;justify-content:space-between;gap:14px; padding:19px 21px;border-bottom:1px solid var(--pi-border);flex-wrap:wrap; } .pi-card-head h3{margin:0;font-size:15px;font-weight:800} .pi-card-head p{margin:5px 0 0;color:var(--pi-muted);font-size:12px} .pi-form-body{padding:22px} .pi-form-grid{display:grid;grid-template-columns:repeat(2,minmax(0,1fr));gap:19px} .pi-field{min-width:0} .pi-field-full{grid-column:1/-1} .pi-field label{display:block;font-size:12px;font-weight:750;margin-bottom:8px;color:#414960} .pi-required{color:var(--pi-red)} .pi-input,.pi-select,.pi-textarea{ width:100%;border:1px solid #e1e5ef;border-radius:11px; background:#fff;color:var(--pi-text);padding:12px 13px; outline:none;transition:.2s; } .pi-input:focus,.pi-select:focus,.pi-textarea:focus{ border-color:var(--pi-primary);box-shadow:0 0 0 3px #6257e817 } .pi-textarea{resize:vertical;min-height:110px;line-height:1.65} .pi-help{font-size:11px;color:var(--pi-muted);margin-top:7px;line-height:1.5} .pi-check-row{display:flex;gap:10px;align-items:center;padding:12px 14px;background:#f8f9fd;border-radius:11px;border:1px solid var(--pi-border)} .pi-check-row input{accent-color:var(--pi-primary);width:16px;height:16px} .pi-check-row label{margin:0;font-size:12px} .pi-form-footer{ display:flex;align-items:center;justify-content:flex-end;gap:10px; padding-top:21px;margin-top:22px;border-top:1px solid var(--pi-border);flex-wrap:wrap } .pi-toolbar{padding:17px 21px;border-bottom:1px solid var(--pi-border)} .pi-filter-form{display:flex;align-items:center;gap:10px;flex-wrap:wrap} .pi-filter-form .pi-input{max-width:320px;flex:1;min-width:170px} .pi-filter-form .pi-select{width:auto;min-width:140px} .pi-table-wrap{overflow-x:auto} .pi-table{width:100%;border-collapse:collapse;white-space:nowrap} .pi-table th{ background:#fafbfe;text-align:left;padding:13px 17px;color:#8990a4; font-size:10px;letter-spacing:.7px;text-transform:uppercase;font-weight:800 } .pi-table td{padding:15px 17px;border-top:1px solid #eff1f6;vertical-align:middle} .pi-table tbody tr:hover{background:#fcfcff} .pi-industry{display:flex;align-items:center;gap:12px;min-width:210px} .pi-thumb{ width:47px;height:47px;border-radius:12px;object-fit:cover; background:#eff1f7;flex-shrink:0;border:1px solid var(--pi-border) } .pi-thumb-placeholder{ width:47px;height:47px;border-radius:12px;background:#eeedff;color:var(--pi-primary); display:grid;place-items:center;font-weight:850;font-size:18px;flex-shrink:0 } .pi-name{font-weight:800;font-size:12px;max-width:260px;overflow:hidden;text-overflow:ellipsis} .pi-sub{font-size:11px;color:var(--pi-muted);margin-top:5px} .pi-slug{font-size:11px;color:#747c92;font-family:ui-monospace,monospace} .pi-status{display:inline-flex;padding:6px 9px;border-radius:30px;font-size:10px;font-weight:800;text-transform:capitalize} .status-active{background:#e7f8f0;color:#09865c} .status-inactive{background:#fff0f1;color:#c23c50} .status-draft{background:#fff5df;color:#996c13} .pi-featured{color:#9a741b;background:#fff4d9;border-radius:30px;padding:6px 9px;font-size:10px;font-weight:800} .pi-actions{display:flex;align-items:center;gap:7px} .pi-inline{display:inline} .pi-empty{text-align:center;padding:52px 20px} .pi-empty-icon{width:56px;height:56px;display:grid;place-items:center;background:#f0efff;color:var(--pi-primary);border-radius:17px;margin:0 auto 14px;font-size:23px} .pi-empty h3{font-size:15px;margin:0} .pi-empty p{font-size:12px;color:var(--pi-muted);margin:8px 0 18px} .pi-pagination{display:flex;align-items:center;justify-content:space-between;gap:12px;padding:16px 21px;border-top:1px solid var(--pi-border);flex-wrap:wrap} .pi-pagination-info{font-size:11px;color:var(--pi-muted)} .pi-pages{display:flex;gap:6px;align-items:center} .pi-page-link{padding:8px 11px;border:1px solid var(--pi-border);border-radius:9px;font-size:11px;font-weight:750} .pi-page-link.current{background:var(--pi-primary);color:#fff;border-color:var(--pi-primary)} .pi-section-gap{margin-top:23px} .pi-upload-note{padding:12px;border-radius:11px;background:#f7f8fc;border:1px dashed #dfe3ef;color:var(--pi-muted);font-size:11px;line-height:1.6} .pi-image-preview{display:flex;gap:10px;align-items:center;margin-top:10px;flex-wrap:wrap} .pi-image-preview img{width:76px;height:58px;object-fit:cover;border-radius:9px;border:1px solid var(--pi-border)} .pi-footer-note{text-align:center;color:#969caf;font-size:11px;padding:22px 0 0} @media(max-width:1000px){ .pi-layout{flex-direction:column} .pi-layout > aside, .pi-layout > div.sidebar, .pi-layout > .sidebar-container { width:100%; height:auto; position:relative; } .pi-content{padding:22px 18px} .pi-topbar{padding:15px 18px} } @media(max-width:680px){ .pi-topbar{align-items:flex-start;flex-direction:column} .pi-topbar h1{font-size:19px} .pi-content{padding:17px 12px 30px} .pi-stats{grid-template-columns:1fr} .pi-form-grid{grid-template-columns:1fr} .pi-field-full{grid-column:auto} .pi-form-body{padding:16px} .pi-card-head{padding:16px} .pi-toolbar{padding:14px} .pi-filter-form{align-items:stretch} .pi-filter-form .pi-input,.pi-filter-form .pi-select{max-width:none;width:100%} .pi-page-heading h2{font-size:21px} .pi-table th,.pi-table td{padding:12px} } </style> </head> <body> <div class="pi-layout"> <?php $sidebarFile = __DIR__ . '/sidebar.php'; if (is_file($sidebarFile)) { require_once $sidebarFile; } ?> <main class="pi-main"> <header class="pi-topbar"> <div> <h1>Industry Management</h1> <p>Manage industry categories, images and descriptions</p> </div> <div class="pi-top-actions"> <a class="pi-view-link" href="../index.php" target="_blank" rel="noopener"> โ View Website </a> <span class="pi-admin-chip"><span class="pi-dot"></span> Admin Panel</span> </div> </header> <div class="pi-content"> <?php if ($flash): ?> <div class="pi-alert pi-alert-success"> <?= e($flash['message'] ?? '') ?> </div> <?php endif; ?> <?php if ($errorMessage !== ''): ?> <div class="pi-alert pi-alert-error"> <?= e($errorMessage) ?> </div> <?php endif; ?> <div class="pi-page-heading"> <div> <h2><?= $editIndustry ? 'Edit Industry' : 'Industries' ?></h2> <p> <?= $editIndustry ? 'Industry details aur images update karein.' : 'Create, organize and manage your industry sections.' ?> </p> </div> <?php if ($editIndustry): ?> <a class="pi-btn pi-btn-light" href="add_industry.php">๏ผ New Industry</a> <?php else: ?> <a class="pi-btn pi-btn-primary" href="#industry-form">๏ผ Add Industry</a> <?php endif; ?> </div> <div class="pi-stats"> <div class="pi-stat"> <div class="pi-stat-label">Total Industries</div> <div class="pi-stat-value"><?= number_format($totalRows) ?></div> </div> <div class="pi-stat"> <div class="pi-stat-label">Current Page</div> <div class="pi-stat-value"><?= $page ?> <span style="font-size:13px;color:var(--pi-muted)">/ <?= $totalPages ?></span></div> </div> <div class="pi-stat"> <div class="pi-stat-label">Items Per Page</div> <div class="pi-stat-value"><?= $perPage ?></div> </div> </div> <section class="pi-card" id="industry-form"> <div class="pi-card-head"> <div> <h3><?= $editIndustry ? 'Update Industry Details' : 'Create New Industry' ?></h3> <p>Basic information, featured image, banner and gallery</p> </div> <?php if ($editIndustry): ?> <span class="pi-status status-active">ID #<?= (int)$editIndustry['id'] ?></span> <?php endif; ?> </div> <form method="post" enctype="multipart/form-data"> <input type="hidden" name="csrf_token" value="<?= e($_SESSION['industry_csrf']) ?>"> <input type="hidden" name="action" value="save"> <input type="hidden" name="id" value="<?= (int)($editIndustry['id'] ?? 0) ?>"> <div class="pi-form-body"> <div class="pi-form-grid"> <div class="pi-field"> <label for="name">Industry Name <span class="pi-required">*</span></label> <input class="pi-input" id="name" name="name" required maxlength="190" placeholder="e.g. Industrial Chemicals" value="<?= e($editIndustry['name'] ?? '') ?>"> <div class="pi-help">Slug automatically unique generate hoga.</div> </div> <div class="pi-field"> <label for="parent_id">Parent Industry</label> <select class="pi-select" id="parent_id" name="parent_id"> <option value="0">โ No Parent (Main Industry) โ</option> <?php foreach ($parentOptions as $parent): ?> <?php if ((int)$parent['id'] === (int)($editIndustry['id'] ?? 0)) continue; ?> <option value="<?= (int)$parent['id'] ?>" <?= (int)($editIndustry['parent_id'] ?? 0) === (int)$parent['id'] ? 'selected' : '' ?>> <?= e($parent['name']) ?> </option> <?php endforeach; ?> </select> </div> <div class="pi-field"> <label for="status">Status</label> <select class="pi-select" id="status" name="status"> <?php foreach ($statusOptions as$statusOption): ?> <option value="<?= e($statusOption) ?>" <?= ($editIndustry['status'] ?? ($statusOptions[0] ?? 'draft')) ===$statusOption ? 'selected' : '' ?>> <?= e(ucfirst($statusOption)) ?> </option> <?php endforeach; ?> </select> </div> <div class="pi-field"> <label for="sort_order">Sort Order</label> <input class="pi-input" type="number" min="0" id="sort_order" name="sort_order" value="<?= e($editIndustry['sort_order'] ?? 0) ?>"> <div class="pi-help">Chhota number pehle display hoga.</div> </div> <div class="pi-field pi-field-full"> <label for="short_description">Short Description</label> <textarea class="pi-textarea" id="short_description" name="short_description" rows="3" placeholder="Write a short introduction..."><?= e($editIndustry['short_description'] ?? '') ?></textarea> </div> <div class="pi-field pi-field-full"> <label for="description">Full Description</label> <textarea class="pi-textarea" id="description" name="description" rows="6" placeholder="Write the complete industry description..."><?= e($editIndustry['description'] ?? '') ?></textarea> </div> <div class="pi-field"> <label for="featured_image">Featured Image</label> <input class="pi-input" type="file" id="featured_image" name="featured_image" accept=".jpg,.jpeg,.png,.webp,.gif,image/jpeg,image/png,image/webp,image/gif"> <div class="pi-help">JPG, PNG, WEBP, GIF โ maximum 10 MB. Empty chhodne par current image rahegi.</div> <?php if (!empty($editIndustry['featured_image_id'])): ?> <?php $featuredPreviewStmt =$pdo->prepare('SELECT file_path FROM media WHERE id = :id'); $featuredPreviewStmt->execute([':id' =>$editIndustry['featured_image_id']]); $featuredPreview =$featuredPreviewStmt->fetchColumn(); ?> <?php if ($featuredPreview): ?> <div class="pi-image-preview"> <img src="<?= e(industryImageUrl((string)$featuredPreview)) ?>" alt="Featured image"> <span class="pi-help">Current featured image</span> </div> <?php endif; ?> <?php endif; ?> </div> <div class="pi-field"> <label for="banner_image">Banner Image</label> <input class="pi-input" type="file" id="banner_image" name="banner_image" accept=".jpg,.jpeg,.png,.webp,.gif,image/jpeg,image/png,image/webp,image/gif"> <div class="pi-help">Wide banner image recommended. Maximum 10 MB.</div> <?php if (!empty($editIndustry['banner_id'])): ?> <?php $bannerPreviewStmt =$pdo->prepare('SELECT file_path FROM media WHERE id = :id'); $bannerPreviewStmt->execute([':id' =>$editIndustry['banner_id']]); $bannerPreview =$bannerPreviewStmt->fetchColumn(); ?> <?php if ($bannerPreview): ?> <div class="pi-image-preview"> <img src="<?= e(industryImageUrl((string)$bannerPreview)) ?>" alt="Banner image"> <span class="pi-help">Current banner</span> </div> <?php endif; ?> <?php endif; ?> </div> <div class="pi-field pi-field-full"> <label for="gallery_images">Gallery Images</label> <input class="pi-input" type="file" id="gallery_images" name="gallery_images[]" multiple accept=".jpg,.jpeg,.png,.webp,.gif,image/jpeg,image/png,image/webp,image/gif"> <div class="pi-help">Multiple images select kar sakte hain. Ek baar mein maximum 30 images, har image 10 MB tak.</div> <div class="pi-upload-note"> Gallery images existing gallery mein add hongi. Is form se pehle se uploaded gallery images remove nahi hongi. </div> </div> <div class="pi-field pi-field-full"> <div class="pi-check-row"> <input type="checkbox" id="featured" name="featured" value="1" <?= !empty($editIndustry['featured']) ? 'checked' : '' ?>> <label for="featured">Mark as Featured Industry</label> </div> </div> </div> <div class="pi-form-footer"> <?php if ($editIndustry): ?> <a class="pi-btn pi-btn-light" href="add_industry.php">Cancel</a> <?php endif; ?> <button class="pi-btn pi-btn-primary" type="submit"> <?= $editIndustry ? 'โ Save Changes' : '๏ผ Create Industry' ?> </button> </div> </div> </form> </section> <section class="pi-card pi-section-gap"> <div class="pi-card-head"> <div> <h3>All Industries</h3> <p>Search, filter and manage existing records</p> </div> <span class="pi-status status-active"><?= number_format($totalRows) ?> records</span> </div> <div class="pi-toolbar"> <form class="pi-filter-form" method="get"> <input class="pi-input" type="search" name="q" value="<?= e($search) ?>" placeholder="Search name, slug or description..."> <select class="pi-select" name="status"> <option value="">All statuses</option> <?php foreach ($statusOptions as$statusOption): ?> <option value="<?= e($statusOption) ?>" <?= $filterStatus ===$statusOption ? 'selected' : '' ?>> <?= e(ucfirst($statusOption)) ?> </option> <?php endforeach; ?> </select> <button class="pi-btn pi-btn-primary" type="submit">โ Search</button> <a class="pi-btn pi-btn-light" href="add_industry.php">Reset</a> </form> </div> <?php if (!$industries): ?> <div class="pi-empty"> <div class="pi-empty-icon">โ</div> <h3>No industries found</h3> <p>Search change karein ya nayi industry create karein.</p> <a class="pi-btn pi-btn-primary" href="#industry-form">๏ผ Add Industry</a> </div> <?php else: ?> <div class="pi-table-wrap"> <table class="pi-table"> <thead> <tr> <th>Industry</th> <th>Parent</th> <th>Status</th> <th>Featured</th> <th>Sort</th> <th>Actions</th> </tr> </thead> <tbody> <?php foreach ($industries as$industry): ?> <tr> <td> <div class="pi-industry"> <?php if (!empty($industry['featured_path'])): ?> <img class="pi-thumb" src="<?= e(industryImageUrl((string)$industry['featured_path'])) ?>" alt="<?= e($industry['name']) ?>"> <?php else: ?> <div class="pi-thumb-placeholder"> <?= e(mb_strtoupper(mb_substr((string)$industry['name'], 0, 1))) ?> </div> <?php endif; ?> <div> <div class="pi-name"><?= e($industry['name']) ?></div> <div class="pi-sub">ID #<?= (int)$industry['id'] ?></div> <div class="pi-slug"><?= e($industry['slug']) ?></div> </div> </div> </td> <td> <?php if (!empty($industry['parent_name'])): ?> <?= e($industry['parent_name']) ?> <?php else: ?> <span class="pi-sub">Main industry</span> <?php endif; ?> </td> <td> <span class="pi-status <?= e(industryStatusClass((string)$industry['status'])) ?>"> <?= e($industry['status']) ?> </span> </td> <td> <?php if (!empty($industry['featured'])): ?> <span class="pi-featured">โ Featured</span> <?php else: ?> <span class="pi-sub">โ</span> <?php endif; ?> </td> <td><?= (int)$industry['sort_order'] ?></td> <td> <div class="pi-actions"> <a class="pi-btn pi-btn-light pi-btn-small" href="add_industry.php?edit=<?= (int)$industry['id'] ?>">โ Edit</a> <form class="pi-inline" method="post" onsubmit="return confirm('Is industry ko delete karna hai? Iske gallery links bhi remove honge. Media files delete nahi hongi.');"> <input type="hidden" name="csrf_token" value="<?= e($_SESSION['industry_csrf']) ?>"> <input type="hidden" name="action" value="delete"> <input type="hidden" name="id" value="<?= (int)$industry['id'] ?>"> <button class="pi-btn pi-btn-danger pi-btn-small" type="submit">โซ Delete</button> </form> </div> </td> </tr> <?php endforeach; ?> </tbody> </table> </div> <div class="pi-pagination"> <div class="pi-pagination-info"> Showing <?= $totalRows ? $offset + 1 : 0 ?>โ<?= min($offset + $perPage,$totalRows) ?> of <?= number_format($totalRows) ?> industries </div> <div class="pi-pages"> <?php $baseParams = ['q' => $search, 'status' =>$filterStatus]; if ($page > 1): ?> <a class="pi-page-link" href="?<?= e(http_build_query($baseParams + ['page' =>$page - 1])) ?>">โ Prev</a> <?php endif; ?> <?php $startPage = max(1, $page - 2);$endPage = min($totalPages,$page + 2); for ($p = $startPage; $p <= $endPage; $p++): ?> <a class="pi-page-link <?= $p ===$page ? 'current' : '' ?>" href="?<?= e(http_build_query($baseParams + ['page' =>$p])) ?>"> <?= $p ?> </a> <?php endfor; ?> <?php if ($page <$totalPages): ?> <a class="pi-page-link" href="?<?= e(http_build_query($baseParams + ['page' =>$page + 1])) ?>">Next โ</a> <?php endif; ?> </div> </div> <?php endif; ?> </section> <div class="pi-footer-note"> Pure Chemical Admin ยท Industry Management </div> </div> </main> </div> <script> document.querySelectorAll('input[type="file"]').forEach(function(input) { input.addEventListener('change', function() { const files = Array.from(this.files || []); const maxSize = 10 * 1024 * 1024; const oversized = files.filter(function(file) { return file.size > maxSize; }); if (oversized.length) { alert('Har image ka size 10 MB se kam hona chahiye.'); this.value = ''; return; } if (this.multiple && files.length > 30) { alert('Ek baar mein maximum 30 gallery images select karein.'); this.value = ''; } }); }); </script> </body> </html>
Save
Cancel