Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.3.30

User:

u231988116

Directory:

/home/u231988116/domains/ominteriorstudio.in/public_html/crm

Free Space:

7.42 TB

🔧 Quick Actions

✏️ Editing: designcost.php

<?php
session_start();
if (!isset($_SESSION['user_id'])) {
    header("Location: index");
    exit;
}

// Include database connection
include 'db.php';

// Verify role-based access
checkAccess();

// Verify project access if project_id is provided
if (isset($_GET['project_id']) && !empty($_GET['project_id'])) {
    verifyProjectAccess($_GET['project_id'], $conn);
}
if (isset($_POST['project_id']) && !empty($_POST['project_id'])) {
    verifyProjectAccess($_POST['project_id'], $conn);
}

// Get logged-in user name
$user_name = 'Admin User';
if (isset($_SESSION['user_id'])) {
    $userQuery = "SELECT name FROM users WHERE id = ?";
    $stmt = mysqli_prepare($conn, $userQuery);
    mysqli_stmt_bind_param($stmt, 'i', $_SESSION['user_id']);
    mysqli_stmt_execute($stmt);
    $userResult = mysqli_stmt_get_result($stmt);
    if ($userResult && mysqli_num_rows($userResult) > 0) {
        $user = mysqli_fetch_assoc($userResult);
        $user_name = $user['name'];
    }
    mysqli_stmt_close($stmt);
}

// Initialize variables
$selectedProject = null;
$designCosts = [];
$alertMessage = '';
$alertType = '';

// Handle design cost deletion (POST)
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'delete_design_cost') {
    header('Content-Type: application/json');
    $designId = intval($_POST['design_id']);

if ($designId <= 0) {
        echo json_encode(['success' => false, 'message' => 'Invalid design ID']);
        exit;
    }

// Get the design to check ownership and get image path
    $selectQuery = "SELECT image_path FROM design_costs WHERE id = ?";
    $stmt = mysqli_prepare($conn, $selectQuery);
    mysqli_stmt_bind_param($stmt, 'i', $designId);
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);

if ($result && mysqli_num_rows($result) > 0) {
        $design = mysqli_fetch_assoc($result);

// Delete the design record
        $deleteQuery = "DELETE FROM design_costs WHERE id = ?";
        $stmt = mysqli_prepare($conn, $deleteQuery);
        mysqli_stmt_bind_param($stmt, 'i', $designId);

if (mysqli_stmt_execute($stmt)) {
            // Delete associated image file if it exists
            if ($design['image_path'] && file_exists($design['image_path'])) {
                unlink($design['image_path']);
            }
            echo json_encode(['success' => true, 'message' => 'Design cost record deleted successfully']);
        } else {
            echo json_encode(['success' => false, 'message' => 'Error deleting design cost record']);
        }
        mysqli_stmt_close($stmt);
    } else {
        echo json_encode(['success' => false, 'message' => 'Design not found or access denied']);
    }
    exit;
}

// Handle design cost editing (POST)
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'edit_design_cost') {
    header('Content-Type: application/json');
    $designId = intval($_POST['design_id']);
    $designName = mysqli_real_escape_string($conn, $_POST['designName']);
    $originalSqft = floatval($_POST['designSqft']);
    $materialDetails = mysqli_real_escape_string($conn, $_POST['materialDetails']);
    $areasApplied = mysqli_real_escape_string($conn, $_POST['areas']);
    $costPerSqft = floatval($_POST['costPerSqft']);
    $userSqft = floatval($_POST['userSqft']);
    $description = mysqli_real_escape_string($conn, $_POST['designDescription']);
    $totalCost = $costPerSqft * $userSqft;

// Validation
    if ($designId <= 0) {
        echo json_encode(['success' => false, 'message' => 'Invalid design ID']);
        exit;
    }
    if (empty($designName) || $originalSqft <= 0 || $costPerSqft <= 0 || $userSqft <= 0) {
        echo json_encode(['success' => false, 'message' => 'All required fields must be filled with valid values']);
        exit;
    }
    if (empty($materialDetails) || empty($areasApplied) || empty($description)) {
        echo json_encode(['success' => false, 'message' => 'Material details, areas applied, and description are required']);
        exit;
    }

// Handle file upload if present
    $imagePath = null;
    $updateImage = false;
    if (isset($_FILES['design_image']) && $_FILES['design_image']['error'] === UPLOAD_ERR_OK) {
        $uploadDir = 'uploads/';
        if (!is_dir($uploadDir)) {
            mkdir($uploadDir, 0755, true);
        }

$fileName = uniqid() . '_' . basename($_FILES['design_image']['name']);
        $targetPath = $uploadDir . $fileName;

if (move_uploaded_file($_FILES['design_image']['tmp_name'], $targetPath)) {
            $imagePath = $targetPath;
            $updateImage = true;
        }
    }

// Update the design cost record
    if ($updateImage) {
        // Get old image path to delete it
        $selectQuery = "SELECT image_path FROM design_costs WHERE id = ?";
        $stmt = mysqli_prepare($conn, $selectQuery);
        mysqli_stmt_bind_param($stmt, 'i', $designId);
        mysqli_stmt_execute($stmt);
        $result = mysqli_stmt_get_result($stmt);
        if ($result && mysqli_num_rows($result) > 0) {
            $oldDesign = mysqli_fetch_assoc($result);
            if ($oldDesign['image_path'] && file_exists($oldDesign['image_path'])) {
                unlink($oldDesign['image_path']);
            }
        }
        mysqli_stmt_close($stmt);

$updateQuery = "UPDATE design_costs SET design_name = ?, original_sqft = ?, material_details = ?, areas_applied = ?, cost_per_sqft = ?, user_sqft = ?, total_cost = ?, image_path = ?, description = ? WHERE id = ?";
        $stmt = mysqli_prepare($conn, $updateQuery);
        mysqli_stmt_bind_param($stmt, 'sdsssddssi', $designName, $originalSqft, $materialDetails, $areasApplied, $costPerSqft, $userSqft, $totalCost, $imagePath, $description, $designId);
    } else {
        $updateQuery = "UPDATE design_costs SET design_name = ?, original_sqft = ?, material_details = ?, areas_applied = ?, cost_per_sqft = ?, user_sqft = ?, total_cost = ?, description = ? WHERE id = ?";
        $stmt = mysqli_prepare($conn, $updateQuery);
        mysqli_stmt_bind_param($stmt, 'sdsssddsi', $designName, $originalSqft, $materialDetails, $areasApplied, $costPerSqft, $userSqft, $totalCost, $description, $designId);
    }

if (mysqli_stmt_execute($stmt)) {
        echo json_encode(['success' => true, 'message' => 'Design cost record updated successfully']);
    } else {
        echo json_encode(['success' => false, 'message' => 'Error updating design cost record']);
    }
    mysqli_stmt_close($stmt);
    exit;
}

// Handle design cost addition (POST)
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'add_design_cost') {
    $projectId = intval($_POST['project_id']);
    $designName = mysqli_real_escape_string($conn, $_POST['designName']);
    $originalSqft = floatval($_POST['designSqft']);
    $materialDetails = mysqli_real_escape_string($conn, $_POST['materialDetails']);
    $areasApplied = mysqli_real_escape_string($conn, $_POST['areas']);
    $costPerSqft = floatval($_POST['costPerSqft']);
    $userSqft = floatval($_POST['userSqft']);
    $description = mysqli_real_escape_string($conn, $_POST['designDescription']);
    $totalCost = $costPerSqft * $userSqft;

// Validation
    if ($projectId <= 0) {
        $alertMessage = 'Please select a valid project.';
        $alertType = 'danger';
    } elseif (empty($designName) || $originalSqft <= 0 || $costPerSqft <= 0 || $userSqft <= 0) {
        $alertMessage = 'All required fields must be filled with valid values.';
        $alertType = 'danger';
    } elseif (empty($materialDetails) || empty($areasApplied) || empty($description)) {
        $alertMessage = 'Material details, areas applied, and description are required.';
        $alertType = 'danger';
    } else {
        // Handle file upload if present
        $imagePath = null;
        if (isset($_FILES['designImage']) && $_FILES['designImage']['error'] === UPLOAD_ERR_OK) {
            $uploadDir = 'uploads/';
            if (!is_dir($uploadDir)) {
                mkdir($uploadDir, 0755, true);
            }

$fileName = uniqid() . '_' . basename($_FILES['designImage']['name']);
            $targetPath = $uploadDir . $fileName;

if (move_uploaded_file($_FILES['designImage']['tmp_name'], $targetPath)) {
                $imagePath = $targetPath;
            }
        }

// Insert design cost record
        $insertQuery = "INSERT INTO design_costs (project_id, design_name, original_sqft, material_details, areas_applied, cost_per_sqft, user_sqft, total_cost, image_path, description, created_by_user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
        $stmt = mysqli_prepare($conn, $insertQuery);
        mysqli_stmt_bind_param($stmt, 'isdsssdddsi', $projectId, $designName, $originalSqft, $materialDetails, $areasApplied, $costPerSqft, $userSqft, $totalCost, $imagePath, $description, $_SESSION['user_id']);

if (mysqli_stmt_execute($stmt)) {
            $alertMessage = 'Design cost record added successfully!';
            $alertType = 'success';
            // Redirect to reload the page with current project
            header("Location:".BASE_URL."designcost/" . $projectId);
            exit;
        } else {
            $alertMessage = 'Error adding design cost record: ' . mysqli_error($conn);
            $alertType = 'danger';
        }
        mysqli_stmt_close($stmt);
    }
}

// Handle project selection (GET)
if (isset($_GET['project_id'])) {
    // Access verified at top of script
    $projectId = intval($_GET['project_id']);
    if ($projectId > 0) {
        // Fetch project details
        $projectQuery = "SELECT p.id, p.project_name, c.client_name FROM projects p JOIN clients c ON p.client_id = c.id WHERE p.id = ?";
        $stmt = mysqli_prepare($conn, $projectQuery);
        mysqli_stmt_bind_param($stmt, 'i', $projectId);
        mysqli_stmt_execute($stmt);
        $projectResult = mysqli_stmt_get_result($stmt);
        if ($projectResult && mysqli_num_rows($projectResult) > 0) {
            $selectedProject = mysqli_fetch_assoc($projectResult);
            $selectedProject['project_id_display'] = 'PRJ-' . str_pad($selectedProject['id'], 3, '0', STR_PAD_LEFT);
        }
        mysqli_stmt_close($stmt);

// Fetch design costs for the project
        $designQuery = "SELECT id, design_name, original_sqft, material_details, areas_applied, cost_per_sqft, user_sqft, total_cost, image_path, description, created_at FROM design_costs WHERE project_id = ? ORDER BY created_at DESC";
        $stmt = mysqli_prepare($conn, $designQuery);
        mysqli_stmt_bind_param($stmt, 'i', $projectId);
        mysqli_stmt_execute($stmt);
        $designResult = mysqli_stmt_get_result($stmt);
        if ($designResult) {
            while ($row = mysqli_fetch_assoc($designResult)) {
                $designCosts[] = $row;
            }
        }
        mysqli_stmt_close($stmt);
    }
}

// Query to get projects with client information
$projects = getUserProjects($conn);
$projectOptions = '';
$projectDataJS = '';

foreach ($projects as $project) {
    $projectId = 'PRJ-' . str_pad($project['id'], 3, '0', STR_PAD_LEFT);
    $projectOptions .= '<option value="' . $project['id'] . '"' . (isset($_GET['project_id']) && $_GET['project_id'] == $project['id'] ? ' selected' : '') . '>' . htmlspecialchars($project['project_name']) . ' - ' . htmlspecialchars($project['client_name']) . '</option>';
    $projectDataJS .= "'" . $project['id'] . "': { name: '" . addslashes($project['project_name']) . "', client: '" . addslashes($project['client_name']) . "', id: '" . $projectId . "' },";
}
if (!empty($projectDataJS)) {
    $projectDataJS = rtrim($projectDataJS, ',');
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Design Uploader - ConstructCRM</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.css">

* {
        margin: 0;
        padding: 0;
        box-sizing: border-box;
    }

body {
        font-family: 'Inter', sans-serif;
        background-color: #f5f7fa;
        color: #333;
        font-size: 14px;
        line-height: 1.4;
        overflow-x: hidden;
    }

/* Header */
    .header {
        background-color: #fff;
        box-shadow: 0 2px 10px rgba(0, 0, 0, 0.05);
        position: fixed;
        top: 0;
        left: 0;
        right: 0;
        height: var(--header-height);
        z-index: 1000;
        display: flex;
        align-items: center;
        padding: 0 20px;
    }

.logo {
        display: flex;
        align-items: center;
        font-weight: 700;
        font-size: 20px;
        color: var(--primary-color);
        text-decoration: none;
    }

.logo i {
        font-size: 24px;
        margin-right: 10px;
    }

.header-actions {
        margin-left: auto;
        display: flex;
        align-items: center;
    }

.mobile-menu-toggle {
        display: none;
        background: none;
        border: none;
        font-size: 24px;
        color: var(--primary-color);
        margin-right: 15px;
        cursor: pointer;
    }

/* User Dropdown */
    .user-dropdown {
        position: relative;
    }

.user-profile {
        display: flex;
        align-items: center;
        cursor: pointer;
        padding: 5px 10px;
        border-radius: var(--border-radius);
        transition: var(--transition);
    }

.user-profile:hover {
        background-color: #f8f9fa;
    }

.user-avatar {
        width: 36px;
        height: 36px;
        border-radius: 50%;
        background-color: var(--primary-color);
        color: white;
        display: flex;
        align-items: center;
        justify-content: center;
        font-weight: 600;
        margin-right: 10px;
    }

.user-name {
        font-weight: 500;
        margin-right: 5px;
    }

.dropdown-arrow {
        font-size: 12px;
        color: #666;
        transition: var(--transition);
    }

.user-dropdown.show .dropdown-arrow {
        transform: rotate(180deg);
    }

.user-dropdown-menu {
        position: absolute;
        top: 100%;
        right: 0;
        background-color: #fff;
        border-radius: var(--border-radius);
        box-shadow: 0 5px 15px rgba(0, 0, 0, 0.1);
        min-width: 180px;
        padding: 8px 0;
        margin-top: 5px;
        opacity: 0;
        visibility: hidden;
        transform: translateY(-10px);
        transition: var(--transition);
        z-index: 1001;
    }

.user-dropdown.show .user-dropdown-menu {
        opacity: 1;
        visibility: visible;
        transform: translateY(0);
    }

.dropdown-item {
        display: flex;
        align-items: center;
        padding: 10px 20px;
        color: #555;
        text-decoration: none;
        transition: var(--transition);
    }

.dropdown-item:hover {
        background-color: #f8f9fa;
        color: var(--primary-color);
    }

.dropdown-item i {
        margin-right: 10px;
        font-size: 16px;
    }

.dropdown-divider {
        height: 1px;
        background-color: #eee;
        margin: 8px 0;
    }

/* Main Layout */
    .main-container {
        display: flex;
        min-height: calc(100vh - var(--header-height));
        margin-top: var(--header-height);
    }

/* Sidebar Navigation */
    .sidebar-nav {
        width: var(--nav-width);
        background-color: #fff;
        box-shadow: 2px 0 10px rgba(0, 0, 0, 0.05);
        position: fixed;
        top: var(--header-height);
        left: 0;
        bottom: 0;
        z-index: 999;
        overflow-y: auto;
        transition: var(--transition);
        display: block;
    }

.nav-section {
        padding: 15px 0;
    }

.nav-section:last-child {
        padding-bottom: 20px;
    }

.nav-title {
        font-size: 11px;
        font-weight: 600;
        text-transform: uppercase;
        letter-spacing: 0.5px;
        color: #999;
        padding: 0 20px;
        margin-bottom: 10px;
    }

.nav-list {
        list-style: none;
    }

.nav-item {
        margin-bottom: 5px;
    }

.nav-link {
        display: flex;
        align-items: center;
        padding: 12px 20px;
        color: #555;
        text-decoration: none;
        font-weight: 500;
        transition: var(--transition);
        position: relative;
    }

.nav-link i {
        font-size: 18px;
        margin-right: 12px;
        width: 20px;
        text-align: center;
    }

.nav-link:hover {
        background-color: rgba(151, 124, 73, 0.05);
        color: var(--primary-color);
    }

.nav-link.active {
        background-color: rgba(151, 124, 73, 0.1);
        color: var(--primary-color);
    }

.nav-link.active::before {
        content: '';
        position: absolute;
        left: 0;
        top: 0;
        bottom: 0;
        width: 4px;
        background-color: var(--primary-color);
    }

/* Content Wrapper */
    .content-wrapper {
        flex: 1;
        margin-left: var(--nav-width);
        display: flex;
        flex-direction: column;
        transition: var(--transition);
    }

.content-header {
        background-color: #fff;
        padding: 20px 30px;
        border-bottom: 1px solid #eee;
        display: flex;
        align-items: center;
        justify-content: space-between;
    }

.page-title {
        font-size: 24px;
        font-weight: 600;
        color: #333;
    }

.breadcrumb {
        background-color: transparent;
        padding: 0;
        margin: 0;
        font-size: 13px;
    }

.breadcrumb-item {
        color: #999;
    }

.breadcrumb-item a {
        color: #999;
        text-decoration: none;
        transition: var(--transition);
    }

.breadcrumb-item a:hover {
        color: var(--primary-color);
    }

.breadcrumb-item.active {
        color: var(--primary-color);
    }

.breadcrumb-item + .breadcrumb-item::before {
        content: "›";
        color: #ccc;
    }

/* Main Content */
    .main-content {
        flex: 1;
        padding: 30px;
        overflow-y: auto;
    }

/* Project Info Card */
    .project-info-card {
        background-color: #fff;
        border-radius: var(--border-radius);
        box-shadow: var(--box-shadow);
        margin-bottom: 30px;
        overflow: hidden;
    }

.project-info-header {
        background-color: var(--primary-color);
        color: white;
        padding: 15px 20px;
        font-weight: 600;
        font-size: 18px;
    }

.project-info-body {
        padding: 30px;
        display: flex;
        align-items: center;
    }

.project-name {
        font-size: 16px;
        font-weight: 500;
    }

.project-id {
        margin-left: auto;
        background-color: var(--primary-light);
        color: var(--primary-color);
        padding: 5px 10px;
        border-radius: 20px;
        font-size: 12px;
        font-weight: 600;
    }

/* Form Container - ENHANCED */
    .form-container {
        background: linear-gradient(135deg, #fff 0%, #f9f9f9 100%);
        border-radius: var(--border-radius);
        box-shadow: var(--box-shadow);
        overflow: hidden;
        margin-bottom: 30px;
        border: 1px solid rgba(151, 124, 73, 0.1);
    }

.form-header {
        background: linear-gradient(135deg, var(--primary-color), var(--primary-dark));
        color: white;
        padding: 25px 30px;
        display: flex;
        align-items: center;
        position: relative;
        overflow: hidden;
    }

.form-header::before {
        content: '';
        position: absolute;
        top: 0;
        left: 0;
        right: 0;
        bottom: 0;
        background: url('data:image/svg+xml,<svg xmlns="http://www.w3.org/2000/svg" width="100" height="100" viewBox="0 0 100 100"><rect width="100" height="100" fill="none"/><path d="M0,0 L100,100 M100,0 L0,100" stroke="rgba(255,255,255,0.1)" stroke-width="1"/></svg>');
        opacity: 0.2;
    }

.form-title {
        font-size: 20px;
        font-weight: 600;
        margin: 0;
        position: relative;
        z-index: 1;
        display: flex;
        align-items: center;
        gap: 12px;
    }

.form-body {
        padding: 35px;
        position: relative;
    }

.form-section {
        margin-bottom: 35px;
        padding-bottom: 25px;
        border-bottom: 1px dashed #e9ecef;
    }

.form-section:last-child {
        border-bottom: none;
        margin-bottom: 0;
        padding-bottom: 0;
    }

.section-title {
        font-size: 16px;
        font-weight: 600;
        color: var(--primary-color);
        margin-bottom: 20px;
        display: flex;
        align-items: center;
        gap: 10px;
    }

.section-title i {
        font-size: 20px;
    }

.form-group {
        margin-bottom: 25px;
    }

.form-label {
        font-weight: 600;
        color: var(--dark-color);
        margin-bottom: 10px;
        font-size: 14px;
        display: flex;
        align-items: center;
        gap: 8px;
    }

.form-label i {
        color: var(--primary-color);
        font-size: 16px;
    }

.form-control, .form-select {
        border: 2px solid #e9ecef;
        border-radius: var(--border-radius);
        padding: 12px 16px;
        font-size: 14px;
        transition: var(--transition);
        background: #fff;
    }

.form-control:focus, .form-select:focus {
        border-color: var(--primary-color);
        box-shadow: 0 0 0 4px rgba(151, 124, 73, 0.1);
        outline: none;
    }

.form-control:focus, .form-select:focus {
        border-color: var(--primary-color);
        box-shadow: 0 0 0 4px rgba(151, 124, 73, 0.15);
        outline: none;
        transform: translateY(-2px);
    }

.form-control:hover, .form-select:hover {
        border-color: #d6d6d6;
    }

.input-group-text {
        background-color: var(--primary-light);
        border: 2px solid #e9ecef;
        color: var(--primary-color);
        font-weight: 600;
    }

.btn {
        border-radius: var(--border-radius);
        font-weight: 600;
        padding: 12px 24px;
        font-size: 14px;
        transition: var(--transition);
        cursor: pointer;
        border: none;
        display: inline-flex;
        align-items: center;
        gap: 8px;
    }

.btn-primary {
        background: linear-gradient(135deg, var(--primary-color), var(--primary-dark));
        color: white;
        box-shadow: 0 4px 12px rgba(151, 124, 73, 0.3);
    }

.btn-primary:active {
        transform: translateY(-1px);
    }

/* Design List Container */
    .design-list-container {
        background: linear-gradient(135deg, #fff 0%, #f8f9fa 100%);
        border-radius: var(--border-radius);
        box-shadow: var(--box-shadow);
        overflow: hidden;
        display: flex;
        flex-direction: column;
    }

.design-list-header {
        background: linear-gradient(135deg, var(--primary-color), var(--primary-dark));
        color: white;
        padding: 20px 30px;
        display: flex;
        align-items: center;
        justify-content: space-between;
    }

.design-list-title {
        font-size: 20px;
        font-weight: 600;
        margin: 0;
        display: flex;
        align-items: center;
        gap: 12px;
    }

.design-list-body {
        padding: 20px;
        flex: 1;
        overflow-y: auto;
        max-height: 600px;
    }

.design-item {
        background: #fff;
        border-radius: var(--border-radius);
        padding: 20px;
        margin-bottom: 15px;
        border: 2px solid transparent;
        transition: var(--transition);
        cursor: pointer;
        position: relative;
    }

.design-item::before {
        content: '';
        position: absolute;
        left: 0;
        top: 0;
        bottom: 0;
        width: 4px;
        background: linear-gradient(180deg, var(--primary-color), var(--primary-dark));
        border-radius: 2px 0 0 2px;
        opacity: 0;
        transition: var(--transition);
    }

.design-item:hover {
        transform: translateX(5px);
        box-shadow: 0 6px 20px rgba(0, 0, 0, 0.1);
        border-color: var(--primary-light);
    }

.design-item:hover::before {
        opacity: 1;
    }

.design-header {
        display: flex;
        justify-content: space-between;
        align-items: flex-start;
        margin-bottom: 15px;
    }

.design-image {
        width: 80px;
        height: 80px;
        border-radius: var(--border-radius);
        overflow: hidden;
        flex-shrink: 0;
        border: 1px solid #eee;
    }

.design-image img {
        width: 100%;
        height: 100%;
        object-fit: cover;
    }

.design-info {
        flex-grow: 1;
        padding-left: 15px;
    }

.design-name {
        font-size: 18px;
        font-weight: 600;
        color: var(--primary-color);
        margin-bottom: 5px;
    }

.design-meta {
        font-size: 13px;
        color: #666;
        margin-bottom: 10px;
    }

.design-description {
        font-size: 14px;
        line-height: 1.5;
        margin-bottom: 15px;
    }

.design-details {
        background: var(--primary-light);
        border-radius: var(--border-radius);
        padding: 15px;
        margin-bottom: 15px;
    }

.design-details h5 {
        font-size: 16px;
        font-weight: 600;
        color: var(--dark-color);
        margin-bottom: 10px;
    }

.detail-item {
        display: flex;
        justify-content: space-between;
        margin-bottom: 8px;
    }

.detail-label {
        font-weight: 500;
        color: #555;
    }

.detail-value {
        font-weight: 600;
        color: var(--primary-color);
    }

.design-actions {
        display: flex;
        gap: 10px;
        margin-top: 15px;
    }

.btn-edit {
        background: linear-gradient(135deg, #ffc107, #e0a800);
        color: white;
    }

.btn-edit:hover {
        transform: translateY(-2px);
        box-shadow: 0 4px 12px rgba(255, 193, 7, 0.3);
    }

.btn-delete {
        background: linear-gradient(135deg, var(--danger-color), #c82333);
        color: white;
    }

.btn-delete:hover {
        transform: translateY(-2px);
        box-shadow: 0 4px 12px rgba(220, 53, 69, 0.3);
    }

/* Image Upload Section - ENHANCED */
    .image-upload-section {
        margin-bottom: 30px;
    }

.image-upload-card {
        background: linear-gradient(135deg, #fff 0%, #f9f9f9 100%);
        border: 3px dashed #ddd;
        border-radius: var(--border-radius);
        padding: 40px 20px;
        text-align: center;
        cursor: pointer;
        transition: var(--transition);
        position: relative;
        overflow: hidden;
    }

.image-upload-card::before {
        content: '';
        position: absolute;
        top: 0;
        left: 0;
        right: 0;
        bottom: 0;
        background: linear-gradient(135deg, rgba(151, 124, 73, 0.05) 0%, rgba(151, 124, 73, 0.1) 100%);
        opacity: 0;
        transition: var(--transition);
    }

.image-upload-card:hover {
        border-color: var(--primary-color);
        transform: translateY(-3px);
        box-shadow: 0 8px 25px rgba(151, 124, 73, 0.15);
    }

.image-upload-card:hover::before {
        opacity: 1;
    }

.upload-icon {
        font-size: 56px;
        color: var(--primary-color);
        margin-bottom: 20px;
        position: relative;
        z-index: 1;
    }

.upload-text {
        font-size: 18px;
        font-weight: 600;
        color: #333;
        margin-bottom: 8px;
        position: relative;
        z-index: 1;
    }

.upload-subtext {
        font-size: 14px;
        color: #666;
        position: relative;
        z-index: 1;
    }

/* Cost Summary Card - ENHANCED */
    .cost-summary-card {
        background: linear-gradient(135deg, #f8f9fa 0%, #e9ecef 100%);
        border-radius: var(--border-radius);
        padding: 25px;
        box-shadow: 0 4px 12px rgba(0, 0, 0, 0.05);
        border: 1px solid #e9ecef;
        position: relative;
        overflow: hidden;
    }

.cost-summary-card::before {
        content: '';
        position: absolute;
        top: 0;
        left: 0;
        width: 8px;
        height: 100%;
        background: linear-gradient(180deg, var(--success-color), #1e7e34);
    }

.cost-summary-title {
        font-size: 16px;
        font-weight: 600;
        color: #495057;
        margin-bottom: 15px;
        display: flex;
        align-items: center;
        gap: 10px;
    }

.cost-summary-title i {
        color: var(--success-color);
    }

.cost-value {
        font-size: 32px;
        font-weight: 700;
        color: var(--success-color);
        margin-bottom: 5px;
    }

.cost-details {
        font-size: 14px;
        color: #6c757d;
    }

/* Empty State */
    .empty-state {
        text-align: center;
        padding: 40px 20px;
        color: #999;
    }

.empty-state i {
        font-size: 48px;
        margin-bottom: 15px;
        color: #ddd;
    }

.empty-state h3 {
        font-size: 18px;
        margin-bottom: 10px;
        color: #666;
    }

.empty-state p {
        margin: 0;
        font-size: 14px;
    }

/* Alert styling */
    .alert-fixed {
        position: fixed;
        top: 90px;
        right: 30px;
        z-index: 1050;
        min-width: 300px;
        opacity: 0;
        transform: translateX(100%);
        transition: all 0.5s cubic-bezier(0.68, -0.55, 0.265, 1.55);
        border-radius: var(--border-radius);
        border: none;
        box-shadow: 0 10px 30px rgba(0, 0, 0, 0.2);
    }

.alert-fixed.show {
        opacity: 1;
        transform: translateX(0);
    }

/* Modal Styling */
    .modal-content {
        border-radius: var(--border-radius);
        border: none;
        box-shadow: 0 20px 40px rgba(0, 0, 0, 0.2);
    }

.modal-header {
        background: linear-gradient(135deg, var(--primary-color), var(--primary-dark));
        color: white;
        border-radius: var(--border-radius) var(--border-radius) 0 0;
        border: none;
    }

.modal-title {
        font-weight: 600;
    }

.btn-close-white {
        filter: invert(1);
    }

/* Responsive */
    @media (max-width: 768px) {
        .mobile-menu-toggle {
            display: block;
        }
        
        .sidebar-nav {
            transform: translateX(-100%);
            width: 280px;
            z-index: 1001;
        }
        
        .sidebar-nav.show {
            transform: translateX(0);
        }
        
        .content-wrapper {
            margin-left: 0;
        }

.overlay {
            z-index: 1000;
        }

.overlay.show {
            display: block;
        }

.content-header {
            padding: 15px 20px;
            flex-direction: column;
            align-items: flex-start;
        }

.page-title {
            font-size: 20px;
            margin-bottom: 10px;
        }

.main-content {
            padding: 20px;
        }

.header {
            padding: 0 15px;
        }

.logo {
            font-size: 18px;
        }

.logo i {
            font-size: 20px;
        }

.user-name {
            display: none;
        }

.user-avatar {
            width: 32px;
            height: 32px;
            font-size: 14px;
        }

.form-body {
            padding: 25px 20px;
        }

.cost-value {
            font-size: 24px;
        }
    }

/* Custom scrollbar */
    ::-webkit-scrollbar {
        width: 8px;
        height: 8px;
    }

::-webkit-scrollbar-track {
        background: #f1f1f1;
    }

::-webkit-scrollbar-thumb {
        background: #ddd;
        border-radius: 4px;
    }

::-webkit-scrollbar-thumb:hover {
        background: #ccc;
    }

/* Overlay for mobile menu */
    .overlay {
        display: none;
        position: fixed;
        top: 0;
        left: 0;
        right: 0;
        bottom: 0;
        background-color: rgba(0, 0, 0, 0.5);
        z-index: 998;
    }

.overlay.show {
        display: block;
    }
    </style>
</head>
<body>
    
    <header class="header">
        <button class="mobile-menu-toggle" id="mobileMenuToggle">
            <i class="bi bi-list"></i>
        </button>
        <a href="<?= BASE_URL ?>crmdashboard" class="logo">
            <img src="<?= BASE_URL ?>assets/logo.png" alt="ConstructCRM Logo" style="height: 60px; width: 85px;">
        </a>
        <div class="header-actions">
            
            <div class="user-dropdown" id="userDropdown">
                <div class="user-profile" id="userProfile">
                    <div class="user-avatar"><?php echo strtoupper(substr($user_name, 0, 1)); ?></div>
                    <span class="user-name"><?php echo htmlspecialchars($user_name); ?></span>
                    <i class="bi bi-chevron-down dropdown-arrow"></i>
                </div>
                <div class="user-dropdown-menu">
                    <a href="<?= BASE_URL ?>profile" class="dropdown-item">
                        <i class="bi bi-person"></i>
                        <span>Profile</span>
                    </a>
                    <a href="<?= BASE_URL ?>settings" class="dropdown-item">
                        <i class="bi bi-gear"></i>
                        <span>Settings</span>
                    </a>
                    <div class="dropdown-divider"></div>
                    <a href="<?= BASE_URL ?>signin?logout=true" class="dropdown-item">
                        <i class="bi bi-box-arrow-right"></i>
                        <span>Logout</span>
                    </a>
                </div>
            </div>
        </div>
    </header>

<nav class="sidebar-nav" id="sidebarNav">
            <div class="nav-section">
                <div class="nav-title">Main</div>
                <ul class="nav-list">
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>crmdashboard" class="nav-link">
                            <i class="bi bi-speedometer2"></i>
                            <span>Dashboard</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>dashboard" class="nav-link">
                            <i class="bi bi-grid-1x2-fill"></i>
                            <span>Client</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>projectlist" class="nav-link">
                            <i class="bi bi-list-ul"></i>
                            <span>Project List</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>designimages" class="nav-link">
                            <i class="bi bi-palette-fill"></i>
                            <span>Design images</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>assignmentcalendar" class="nav-link">
                            <i class="bi bi-calendar-event-fill"></i>
                            <span>Assignment Calendar</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>place_order" class="nav-link">
                            <i class="bi bi-cart-check"></i> 
                            <span>Place Order</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>financetracker" class="nav-link">
                            <i class="bi bi-cash-stack"></i>
                            <span>Finance Tracker</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>imagepin" class="nav-link">
                            <i class="bi bi-pin-map-fill"></i>
                            <span>Image Pin & Comment</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>designcost" class="nav-link active">
                            <i class="bi bi-palette-fill"></i>
                            <span>Designs Cost</span>
                        </a>
                    </li>
                </ul>
            </div>
            
            <div class="nav-section">
                <div class="nav-title">Management</div>
                <ul class="nav-list">
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>taskmanager" class="nav-link">
                            <i class="bi bi-check2-square"></i>
                            <span>Task Manager</span>
                        </a>
                    </li>
                    <?php if (($_SESSION['user_role'] ?? '') === 'Admin'): ?>
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>users" class="nav-link">
                            <i class="bi bi-people-fill"></i>
                            <span>Users</span>
                        </a>
                    </li>
                    <?php endif; ?>
                </ul>
            </div>
            
            <div class="nav-section">
                <div class="nav-title">Vendor Management</div>
                <ul class="nav-list">
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>addvendors" class="nav-link">
                            <i class="bi bi-person-plus-fill"></i>
                            <span>Add New Vendor</span>
                        </a>
                    </li>
                    <li class="nav-item">
                        <a href="<?= BASE_URL ?>viewvendors" class="nav-link">
                            <i class="bi bi-card-list"></i>
                            <span>View All Vendors</span>
                        </a>
                    </li>
                </ul>
            </div>
        </nav>

<div class="content-wrapper">
            
            <div class="content-header">
                <h1 class="page-title">Design Uploader</h1>
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="#">Home</a></li>
                        <li class="breadcrumb-item"><a href="#">Management</a></li>
                        <li class="breadcrumb-item active" aria-current="page">Design Uploader</li>
                    </ol>
                </nav>
            </div>

<div class="main-content">
                
                <div class="project-info-card">
                    <div class="project-info-header">
                        <i class="bi bi-folder"></i> Select Project
                    </div>
                    <div class="project-info-body">
                        <div class="row align-items-center">
                            <div class="col-md-8">
                                <label for="projectSelect" class="form-label">Choose Project:</label>
                                <select class="form-select" id="projectSelect" name="projectSelect">
                                    <option value="" selected disabled>Select a project...</option>
                                    <?php echo $projectOptions; ?>
                                </select>
                            </div>
                            <div class="col-md-4 text-end">
                                <button class="btn btn-primary" id="loadProjectBtn" disabled style="width: 200px;margin-top: 26px;">
                                    <i class="bi bi-arrow-right-circle"></i> Load Project
                                </button>
                            </div>
                        </div>
                    </div>
                </div>

<div class="project-info-card" id="selectedProjectInfo" style="display: <?php echo $selectedProject ? 'block' : 'none'; ?>;">
                    <div class="project-info-header">
                        Project Information
                    </div>
                    <div class="project-info-body">
                        <div class="project-name"><?php echo $selectedProject ? htmlspecialchars($selectedProject['project_name'] . ' - ' . $selectedProject['client_name']) : 'My Sample Project'; ?></div>
                        <div class="project-id"><?php echo $selectedProject ? htmlspecialchars($selectedProject['project_id_display']) : 'PRJ-001'; ?></div>
                    </div>
                </div>

<div class="form-container">
                    <div class="form-header">
                        <h4 class="form-title">
                            <i class="bi bi-palette-fill"></i>
                            Upload New Design
                        </h4>
                    </div>
                    <div class="form-body">
                        <?php if (!$selectedProject): ?>
                        <div class="alert alert-info" style="margin-bottom: 20px;">
                            <i class="bi bi-info-circle"></i>
                            Please select a project to upload designs
                        </div>
                        <?php endif; ?>
                        <form id="designUploadForm" method="POST" enctype="multipart/form-data" action="">
                            <input type="hidden" name="action" value="add_design_cost">
                            <input type="hidden" name="project_id" value="<?php echo $selectedProject ? $selectedProject['id'] : ''; ?>">
                            
                            <div class="form-section">
                                <div class="section-title">
                                    <i class="bi bi-image"></i>
                                    Design Image
                                </div>
                                <div class="image-upload-section">
                                    <div class="image-upload-card" id="uploadArea">
                                        <i class="bi bi-cloud-upload upload-icon"></i>
                                        <div class="upload-text">Upload Design Image</div>
                                        <div class="upload-subtext">Click or drag and drop your image here</div>
                                        <input type="file" id="designImage" name="designImage" accept="image/*" style="display: none;">
                                    </div>
                                    <div id="imagePreview" class="mt-3"></div>
                                </div>
                            </div>

<div class="form-section">
                                <div class="section-title">
                                    <i class="bi bi-info-circle"></i>
                                    Basic Information
                                </div>
                                <div class="row">
                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <label for="designName" class="form-label">
                                                <i class="bi bi-tag"></i>
                                                Design Name
                                            </label>
                                            <input type="text" id="designName" name="designName" class="form-control" placeholder="e.g., Luxury Bathroom Vanity" required>
                                        </div>
                                    </div>
                                    <div class="col-md-6">
                                        <div class="form-group">
                                            <label for="designSqft" class="form-label">
                                                <i class="bi bi-rulers"></i>
                                                Original Design SqFt
                                            </label>
                                            <input type="number" id="designSqft" name="designSqft" class="form-control" placeholder="200" required min="1">
                                        </div>
                                    </div>
                                </div>
                                <div class="form-group">
                                    <label for="designDescription" class="form-label">
                                        <i class="bi bi-card-text"></i>
                                        Description
                                    </label>
                                    <textarea id="designDescription" name="designDescription" class="form-control" rows="3" placeholder="Detailed description of style, features, and target project." required></textarea>
                                </div>
                            </div>

<div class="form-section">
                                <div class="section-title">
                                    <i class="bi bi-box-seam"></i>
                                    Materials & Application
                                </div>
                                <div class="form-group">
                                    <label for="materialDetails" class="form-label">
                                        <i class="bi bi-box-seam"></i>
                                        Type of Materials Used
                                    </label>
                                    <textarea id="materialDetails" name="materialDetails" class="form-control" rows="2" placeholder="List of primary materials (e.g., Marble, Walnut wood, Copper piping)" required></textarea>
                                </div>
                                <div class="form-group">
                                    <label for="areas" class="form-label">
                                        <i class="bi bi-geo-alt"></i>
                                        Areas/Rooms Applied
                                    </label>
                                    <input type="text" id="areas" name="areas" class="form-control" placeholder="e.g., Kitchen, Master Bath, Hallway (comma separated)" required>
                                </div>
                            </div>

<div class="form-section">
                                <div class="section-title">
                                    <i class="bi bi-cash-stack"></i>
                                    Cost Calculation
                                </div>
                                <div class="row">
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label for="costPerSqft" class="form-label">
                                                <i class="bi bi-currency-rupee"></i>
                                                Cost per SqFt (₹)
                                            </label>
                                            <div class="input-group">
                                                <span class="input-group-text">₹</span>
                                                <input type="number" id="costPerSqft" name="costPerSqft" class="form-control" placeholder="1500.00" step="0.01" required min="0">
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="form-group">
                                            <label for="userSqft" class="form-label">
                                                <i class="bi bi-arrows-angle-expand"></i>
                                                Total User SqFt Required
                                            </label>
                                            <input type="number" id="userSqft" name="userSqft" class="form-control" placeholder="Enter required area" required min="1">
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                            <div class="cost-summary-card">
                                            <div class="cost-summary-title">
                                                <i class="bi bi-calculator"></i>
                                                Total Cost
                                            </div>
                                            <div class="cost-value" id="calculatedTotalCost">₹0.00</div>
                                            <div class="cost-details">
                                                <span id="costPerSqftDisplay">₹0</span> × <span id="userSqftDisplay">0</span> sqft
                    </div>
                </div>

<div class="project-status-card" style="margin-top: 30px; text-align: center; padding: 20px; background: linear-gradient(135deg, #f8f9fa 0%, #e9ecef 100%); border-radius: var(--border-radius); box-shadow: var(--box-shadow);">
                    <?php if ($selectedProject): ?>
                        <div style="color: var(--success-color); font-weight: 600; font-size: 16px;">
                            <i class="bi bi-check-circle-fill"></i>
                            Project "<?php echo htmlspecialchars($selectedProject['project_name']); ?>" is loaded
                        </div>
                        <div style="color: #666; margin-top: 5px;">
                            You can now add and view design costs for this project.
                        </div>
                    <?php else: ?>
                        <div style="color: var(--warning-color); font-weight: 600; font-size: 16px;">
                            <i class="bi bi-exclamation-triangle-fill"></i>
                            No Project Selected
                        </div>
                        <div style="color: #666; margin-top: 5px;">
                            Please select a project from the dropdown above and load it to view design costs.
                        </div>
                    <?php endif; ?>
                </div>
            </div>
        </div>
    </div>

<div class="form-section">
                                <div class="d-flex justify-content-end">
                                    <button type="reset" class="btn btn-outline-secondary me-3">
                                        <i class="bi bi-x-circle"></i>
                                        Reset Form
                                    </button>
                                    <button type="submit" class="btn btn-primary btn-lg" id="saveButton" <?php echo !$selectedProject ? 'disabled' : ''; ?>>
                                        <i class="bi bi-save-fill"></i>
                                        Save Design Record
                                    </button>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>

<div class="design-list-container">
                    <div class="design-list-header">
                        <h4 class="design-list-title">
                            <i class="bi bi-list-check"></i>
                            Saved Design Records
                        </h4>
                    </div>
                    <div class="design-list-body">
                        <?php if (empty($designCosts)): ?>
                        <div class="empty-state">
                            <i class="bi bi-inbox"></i>
                            <h3>No Designs Yet</h3>
                            <p>Start by uploading your first design using the form above</p>
                        </div>
                        <?php else: ?>
                        <?php foreach ($designCosts as $design): ?>
                        <div class="design-item" data-id="<?php echo $design['id']; ?>">
                            <div class="design-header">
                                <?php if ($design['image_path']): ?>
                                <div class="design-image">
                                    <img src="<?php echo htmlspecialchars($design['image_path']); ?>" alt="Design Image" >
                                </div>
                                <?php endif; ?>
                                <div class="design-info">
                                    <div class="design-name"><?php echo htmlspecialchars($design['design_name'] ?? ''); ?></div>
                                    <div class="design-meta">
                                        <i class="bi bi-calendar"></i> <?php echo date('M d, Y', strtotime($design['created_at'] ?? '')); ?> |
                                        <i class="bi bi-rulers"></i> <?php echo htmlspecialchars($design['original_sqft'] ?? ''); ?> sqft original |
                                        <i class="bi bi-cash"></i> ₹<?php echo number_format($design['total_cost'] ?? 0, 2); ?>
                                    </div>
                                </div>
                            </div>
                            <div class="design-description">
                                <?php echo htmlspecialchars($design['description'] ?? ''); ?>
                            </div>
                            <div class="design-details">
                                <h5><i class="bi bi-info-circle"></i> Details</h5>
                                <div class="detail-item">
                                    <span class="detail-label">Materials:</span>
                                    <span class="detail-value"><?php echo htmlspecialchars($design['material_details'] ?? ''); ?></span>
                                </div>
                                <div class="detail-item">
                                    <span class="detail-label">Areas Applied:</span>
                                    <span class="detail-value"><?php echo htmlspecialchars($design['areas_applied'] ?? ''); ?></span>
                                </div>
                                <div class="detail-item">
                                    <span class="detail-label">Cost per SqFt:</span>
                                    <span class="detail-value">₹<?php echo number_format($design['cost_per_sqft'] ?? 0, 2); ?></span>
                                </div>
                                <div class="detail-item">
                                    <span class="detail-label">User SqFt:</span>
                                    <span class="detail-value"><?php echo htmlspecialchars($design['user_sqft'] ?? ''); ?> sqft</span>
                                </div>
                                <div class="detail-item">
                                    <span class="detail-label">Total Cost:</span>
                                    <span class="detail-value">₹<?php echo number_format($design['total_cost'] ?? 0, 2); ?></span>
                                </div>
                            </div>
                            <div class="design-actions">
                                <button class="btn btn-edit btn-sm" 
                                    data-id="<?php echo $design['id']; ?>"
                                    data-name="<?php echo htmlspecialchars($design['design_name']); ?>"
                                    data-sqft="<?php echo htmlspecialchars($design['original_sqft']); ?>"
                                    data-materials="<?php echo htmlspecialchars($design['material_details']); ?>"
                                    data-areas="<?php echo htmlspecialchars($design['areas_applied']); ?>"
                                    data-cost="<?php echo htmlspecialchars($design['cost_per_sqft']); ?>"
                                    data-usersqft="<?php echo htmlspecialchars($design['user_sqft']); ?>"
                                    data-desc="<?php echo htmlspecialchars($design['description']); ?>">
                                    <i class="bi bi-pencil"></i> Edit
                                </button>
                                <button class="btn btn-delete btn-sm" data-id="<?php echo $design['id']; ?>">
                                    <i class="bi bi-trash"></i> Delete
                                </button>
                            </div>
                        </div>
                        <?php endforeach; ?>
                        <?php endif; ?>
                    </div>
                </div>
            </div>
        </div>
    </div>

<div class="modal fade" id="editDesignModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Edit Design Cost</h5>
                    <button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <form id="editDesignForm" enctype="multipart/form-data">
                        <input type="hidden" name="action" value="edit_design_cost">
                        <input type="hidden" name="design_id" id="editDesignId">
                        
                        <div class="row">
                            <div class="col-md-6 mb-3">
                                <label class="form-label">Design Name</label>
                                <input type="text" class="form-control" name="designName" id="editDesignName" required>
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="form-label">Original SqFt</label>
                                <input type="number" class="form-control" name="designSqft" id="editDesignSqft" required>
                            </div>
                        </div>
                        <div class="mb-3">
                            <label class="form-label">Description</label>
                            <textarea class="form-control" name="designDescription" id="editDesignDescription" rows="3" required></textarea>
                        </div>
                        <div class="mb-3">
                            <label class="form-label">Materials</label>
                            <textarea class="form-control" name="materialDetails" id="editMaterialDetails" rows="2" required></textarea>
                        </div>
                        <div class="mb-3">
                            <label class="form-label">Areas Applied</label>
                            <input type="text" class="form-control" name="areas" id="editAreas" required>
                        </div>
                        <div class="row">
                            <div class="col-md-6 mb-3">
                                <label class="form-label">Cost per SqFt</label>
                                <input type="number" class="form-control" name="costPerSqft" id="editCostPerSqft" step="0.01" required>
                            </div>
                            <div class="col-md-6 mb-3">
                                <label class="form-label">User SqFt</label>
                                <input type="number" class="form-control" name="userSqft" id="editUserSqft" required>
                            </div>
                        </div>
                        <div class="mb-3">
                            <label class="form-label">Update Image (Optional)</label>
                            <input type="file" class="form-control" name="design_image">
                            <small class="text-muted">Leave blank to keep current image.</small>
                        </div>
                    </form>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="button" class="btn btn-primary" id="saveEditDesignBtn">Save Changes</button>
                </div>
            </div>
        </div>
    </div>

<div class="modal fade" id="deleteDesignModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Confirm Delete</h5>
                    <button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <p>Are you sure you want to delete this design cost record? This action cannot be undone.</p>
                    <input type="hidden" id="deleteDesignId">
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="button" class="btn btn-danger" id="confirmDeleteBtn">Delete</button>
                </div>
            </div>
        </div>
    </div>

<div id="top-status-message" class="alert-fixed alert d-none" role="alert"></div>

// Cost calculation elements
            const costPerSqftInput = document.getElementById('costPerSqft');
            const userSqftInput = document.getElementById('userSqft');
            const calculatedTotalCost = document.getElementById('calculatedTotalCost');
            const costPerSqftDisplay = document.getElementById('costPerSqftDisplay');
            const userSqftDisplay = document.getElementById('userSqftDisplay');

// Project data from database
            const projectData = {
                <?php echo $projectDataJS; ?>
            };

// Function to calculate and update total cost
            function updateTotalCost() {
                const costPerSqft = parseFloat(costPerSqftInput.value) || 0;
                const userSqft = parseFloat(userSqftInput.value) || 0;
                const totalCost = costPerSqft * userSqft;

// Update the total cost display
                calculatedTotalCost.textContent = '₹' + totalCost.toLocaleString('en-IN', { minimumFractionDigits: 2, maximumFractionDigits: 2 });

// Update the cost details
                costPerSqftDisplay.textContent = '₹' + costPerSqft.toLocaleString('en-IN', { minimumFractionDigits: 2, maximumFractionDigits: 2 });
                userSqftDisplay.textContent = userSqft.toLocaleString('en-IN');
            }

// Add event listeners for cost calculation
            costPerSqftInput.addEventListener('input', updateTotalCost);
            userSqftInput.addEventListener('input', updateTotalCost);

// Enable/disable load button based on project selection
            projectSelect.addEventListener('change', () => {
                const selectedValue = projectSelect.value;
                loadProjectBtn.disabled = !selectedValue;
            });

// Handle load project button click
            loadProjectBtn.addEventListener('click', () => {
                const selectedValue = projectSelect.value;
                if (selectedValue) {
                    // Redirect to load the project
                    window.location.href = `<?= BASE_URL ?>designcost/${selectedValue}`;
                }
            });

// Mobile menu toggle
            const mobileMenuToggle = document.getElementById('mobileMenuToggle');
            const sidebarNav = document.getElementById('sidebarNav');
            const overlay = document.getElementById('overlay');
            const userDropdown = document.getElementById('userDropdown');
            const userProfile = document.getElementById('userProfile');

// --- Mobile Menu Toggle ---
            mobileMenuToggle.addEventListener('click', () => {
                sidebarNav.classList.toggle('show');
                overlay.classList.toggle('show');
            });

overlay.addEventListener('click', () => {
                sidebarNav.classList.remove('show');
                overlay.classList.remove('show');
            });

// Close sidebar when clicking a nav link on mobile
            document.querySelectorAll('.nav-link').forEach(link => {
                link.addEventListener('click', () => {
                    if (window.innerWidth <= 768) {
                        sidebarNav.classList.remove('show');
                        overlay.classList.remove('show');
                    }
                });
            });

// --- User Dropdown Toggle ---
            userProfile.addEventListener('click', (e) => {
                e.stopPropagation();
                userDropdown.classList.toggle('show');
            });

// Close dropdown when clicking outside
            document.addEventListener('click', () => {
                userDropdown.classList.remove('show');
            });

// --- Helper: Show Status Message ---
            function showStatusMessage(message, type) {
                const alertDiv = document.getElementById('top-status-message');
                alertDiv.textContent = message;
                alertDiv.className = `alert-fixed alert alert-${type} show`;
                alertDiv.classList.remove('d-none');
                setTimeout(() => {
                    alertDiv.classList.remove('show');
                    setTimeout(() => alertDiv.classList.add('d-none'), 500);
                }, 3000);
            }

// --- Image Upload Functionality ---
            const uploadArea = document.getElementById('uploadArea');
            const designImageInput = document.getElementById('designImage');
            const imagePreview = document.getElementById('imagePreview');

// Click on upload area to trigger file input
            if (uploadArea && designImageInput) {
                uploadArea.addEventListener('click', function() {
                    designImageInput.click();
                });

// Handle file selection
                designImageInput.addEventListener('change', function(e) {
                    const file = e.target.files[0];
                    if (file) {
                        // Validate file type
                        if (!file.type.startsWith('image/')) {
                            showStatusMessage('Please select a valid image file', 'danger');
                            return;
                        }

// Show preview
                        const reader = new FileReader();
                        reader.onload = function(e) {
                            if (imagePreview) {
                                imagePreview.innerHTML = `
                                    <div class="position-relative d-inline-block">
                                        <img src="${e.target.result}" alt="Preview" style="max-width: 200px; max-height: 200px; border-radius: 12px; border: 2px solid #977C49; padding: 5px;">
                                        <button type="button" class="btn btn-sm btn-danger position-absolute" style="top: -10px; right: -10px; border-radius: 50%;" onclick="removeImage()">
                                            <i class="bi bi-x"></i>
                                        </button>
                                    </div>
                                    <p class="text-success mt-2"><i class="bi bi-check-circle"></i> ${file.name} selected</p>
                                `;
                            }
                            
                            // Update upload area styling to show selected state
                            if (uploadArea) {
                                uploadArea.style.borderColor = '#28a745';
                                uploadArea.style.background = 'linear-gradient(135deg, rgba(40, 167, 69, 0.1) 0%, rgba(40, 167, 69, 0.05) 100%)';
                            }
                        };
                        reader.readAsDataURL(file);
                    }
                });

// Drag and drop functionality
                uploadArea.addEventListener('dragover', function(e) {
                    e.preventDefault();
                    uploadArea.style.borderColor = '#977C49';
                    uploadArea.style.transform = 'translateY(-3px)';
                });

uploadArea.addEventListener('dragleave', function(e) {
                    e.preventDefault();
                    uploadArea.style.borderColor = '#ddd';
                    uploadArea.style.transform = 'translateY(0)';
                });

uploadArea.addEventListener('drop', function(e) {
                    e.preventDefault();
                    uploadArea.style.borderColor = '#ddd';
                    uploadArea.style.transform = 'translateY(0)';
                    
                    const files = e.dataTransfer.files;
                    if (files.length > 0) {
                        designImageInput.files = files;
                        // Trigger change event manually
                        const event = new Event('change', { bubbles: true });
                        designImageInput.dispatchEvent(event);
                    }
                });
            }

// Function to remove selected image
            window.removeImage = function() {
                if (designImageInput) {
                    designImageInput.value = '';
                }
                if (imagePreview) {
                    imagePreview.innerHTML = '';
                }
                if (uploadArea) {
                    uploadArea.style.borderColor = '#ddd';
                    uploadArea.style.background = '';
                }
            };

// --- Edit Design Functionality ---
            const editModalEl = document.getElementById('editDesignModal');
            const editModal = new bootstrap.Modal(editModalEl);
            
            document.querySelectorAll('.btn-edit').forEach(btn => {
                btn.addEventListener('click', function() {
                    document.getElementById('editDesignId').value = this.dataset.id;
                    document.getElementById('editDesignName').value = this.dataset.name;
                    document.getElementById('editDesignSqft').value = this.dataset.sqft;
                    document.getElementById('editMaterialDetails').value = this.dataset.materials;
                    document.getElementById('editAreas').value = this.dataset.areas;
                    document.getElementById('editCostPerSqft').value = this.dataset.cost;
                    document.getElementById('editUserSqft').value = this.dataset.usersqft;
                    document.getElementById('editDesignDescription').value = this.dataset.desc;
                    
                    editModal.show();
                });
            });

document.getElementById('saveEditDesignBtn').addEventListener('click', function() {
                const form = document.getElementById('editDesignForm');
                const formData = new FormData(form);

fetch('designcost.php', {
                    method: 'POST',
                    body: formData
                })
                .then(response => response.json())
                .then(data => {
                    editModal.hide();
                    if (data.success) {
                        showStatusMessage(data.message, 'success');
                        setTimeout(() => location.reload(), 1000);
                    } else {
                        showStatusMessage(data.message, 'danger');
                    }
                })
                .catch(error => {
                    editModal.hide();
                    showStatusMessage('An error occurred', 'danger');
                    console.error('Error:', error);
                });
            });

// --- Delete Design Functionality ---
            const deleteModalEl = document.getElementById('deleteDesignModal');
            const deleteModal = new bootstrap.Modal(deleteModalEl);

document.querySelectorAll('.btn-delete').forEach(btn => {
                btn.addEventListener('click', function() {
                    document.getElementById('deleteDesignId').value = this.dataset.id;
                    deleteModal.show();
                });
            });

document.getElementById('confirmDeleteBtn').addEventListener('click', function() {
                const id = document.getElementById('deleteDesignId').value;
                const formData = new FormData();
                formData.append('action', 'delete_design_cost');
                formData.append('design_id', id);

fetch('designcost.php', {
                    method: 'POST',
                    body: formData
                })
                .then(response => response.json())
                .then(data => {
                    deleteModal.hide();
                    if (data.success) {
                        showStatusMessage(data.message, 'success');
                        // Remove the item from DOM immediately for better UX
                        const item = document.querySelector(`.design-item[data-id="${id}"]`);
                        if (item) item.remove();
                        
                        // Reload to ensure sync if needed, or just let it be
                        setTimeout(() => location.reload(), 1000);
                    } else {
                        showStatusMessage(data.message, 'danger');
                    }
                })
                .catch(error => {
                    deleteModal.hide();
                    showStatusMessage('An error occurred', 'danger');
                    console.error('Error:', error);
                });
            });
        });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: designcost.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation