prepare("UPDATE quotations SET status = ? WHERE id = ?"); $stmt->execute([$status, $id]); $msg = "
Status updated.
"; } catch(Exception $e) { $msg = "
Error updating status.
"; } } if (isset($_GET['id'])) { // Single View $id = $_GET['id']; $stmt = $pdo->prepare("SELECT * FROM quotations WHERE id = ?"); $stmt->execute([$id]); $quote = $stmt->fetch(); if (!$quote) { echo "
Quotation not found.
"; require_once 'footer.php'; exit; } // Fetch files $stmt = $pdo->prepare("SELECT * FROM quotation_files WHERE quotation_id = ?"); $stmt->execute([$id]); $files = $stmt->fetchAll(); ?>

Quotation # Details

Back to List
Client Information & Requirements
Service Type:
Client Name:
Location:
Contact Number:
Pantry Shape:
Length:
Side A:
Side B:
Side A:
Middle:
Side C:
Height:
Width:
Additional Requirements:None' ?>
Uploaded Reference Files

No files uploaded for this request.

File
Update Status
query("SELECT * FROM quotations ORDER BY id DESC"); $quotes = $stmt->fetchAll(); } catch (PDOException $e) { if ($e->getCode() == '42S02') { $pdo->exec("CREATE TABLE IF NOT EXISTS `quotations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `quotation_type` enum('Pantry Cupboard','TV Wall','Wardrobe','Partition Wall') NOT NULL, `name` varchar(150) NOT NULL, `location` varchar(255) NOT NULL, `contact_number` varchar(20) NOT NULL, `shape` enum('Straight','L-Shape','U-Shape') DEFAULT NULL, `side1` varchar(50) DEFAULT NULL, `side2` varchar(50) DEFAULT NULL, `side3` varchar(50) DEFAULT NULL, `height` varchar(50) DEFAULT NULL, `width` varchar(50) DEFAULT NULL, `additional_req` text DEFAULT NULL, `status` enum('Pending','Reviewed','Completed') NOT NULL DEFAULT 'Pending', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4"); $quotes = []; } else { echo "
Database Error: " . htmlspecialchars($e->getMessage()) . "
"; $quotes = []; } } ?>

All Quotation Requests

ID Date Client Name Service Location Status Action
# Pending Reviewed Completed View Details