<?php
    include "ominterior_db.php";
?>


<!doctype html>
<html lang="en" dir="ltr">

<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">

<link rel="icon" href="assets/images/black-logo.png" type="image/x-icon"/>

<title>OM INTERIOR - Dashborad</title>

<!-- Bootstrap Core and vandor -->
<link rel="stylesheet" href="assets/plugins/bootstrap/css/bootstrap.min.css" />

<!-- Plugins css -->
<link rel="stylesheet" href="assets/plugins/charts-c3/c3.min.css"/>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">

<!-- Core css -->
<link rel="stylesheet" href="assets/css/main2.css"/>
<link rel="stylesheet" href="assets/css/theme1.css"/>
</head>

<body class="font-montserrat">
<!-- Page Loader -->
<div class="page-loader-wrapper">
    <div class="loader">
    </div>
</div>

<div id="main_content">

<?php include 'haderTop_logo.php'?>
    
    <?php include 'rightside_menu.php'?>
    
    <?php include 'leftside_menu.php' ?>
    
        <div class="page">
            <div id="page_top" class="section-body top_dark">
                <div class="container-fluid">
                    <div class="page-header">
                        <div class="left">
                            <a href="javascript:void(0)" class="icon menu_toggle mr-3"><i class="fa  fa-align-left"></i></a>
                            <h1 class="page-title">Project</h1>                        
                        </div>
                        <div class="right">
                            <?php include 'dropdown_flex_menu.php' ?>
                        </div>
                    </div>
                </div>
            </div>
    

        <div class="row clearfix">
            <div class="col-12 col-sm-12">
                <div class="card">
                    <div class="card-header">
                        <h3 class="card-title">Add New Project</h3>
                    </div>
                </div>
                <div class="card">
                    <div class="card-body">
                        <form id="projectForm" method="post" enctype="multipart/form-data">

                            <!-- Project Client Name -->
                            <div class="mb-3">
                                <label for="cname" class="form-label"><strong>Project Client Name</strong></label>
                                <input type="text" class="form-control" name="cname" id="cname" placeholder="Project Client Name (Unique)" required>
                            </div>

                            <!-- Project Category -->
                            <!-- Include Bootstrap & jQuery -->
                            <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" />
                            <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

                            <div class="container py-4">
                                <!-- Project Category -->
                                <div class="mb-3">
                                    <label for="Category" class="form-label"><strong>Project Category</strong></label>
                                    <select class="form-select w-100" name="Category" id="Category" required>
                                        <option value="architecture" selected>Architecture</option>
                                        <option value="interior">Interior</option>
                                        <option value="3d_design">3D Designs</option>
                                    </select>
                                </div>

                                <!-- Project Type -->
                                <div class="mb-3">
                                    <label for="ptype" class="form-label"><strong>Project Type</strong></label>
                                    <select class="form-select w-100" name="ptype" id="ptype" required>
                                        <!-- Default options based on initial category -->
                                    </select>
                                </div>
                            </div>

                            <script>
                                const projectTypes = {
                                    architecture: ['Residential', 'Commercial', 'Industrial'],
                                    interior: ['Living Room', 'Kitchen', 'Bedroom'],
                                    '3d_design': ['Walkthrough', 'Rendering', 'Animation']
                                };

                                function updateProjectTypeOptions(category) {
                                    const typeSelect = $('#ptype');
                                    typeSelect.empty(); // Clear current options
                                    projectTypes[category].forEach(type => {
                                        typeSelect.append(`<option value="${type.toLowerCase().replace(/\s+/g, '_')}">${type}</option>`);
                                    });
                                }

                                // On page load
                                $(document).ready(function () {
                                    updateProjectTypeOptions($('#Category').val());

                                    $('#Category').on('change', function () {
                                        const selectedCategory = $(this).val();
                                        updateProjectTypeOptions(selectedCategory);
                                    });
                                });
                            </script>


                            <!-- Project Name -->
                            <div class="mb-3">
                                <label for="pname" class="form-label"><strong>Project Name</strong></label>
                                <input type="text" class="form-control" name="pname" id="pname" placeholder="Project Name (Unique)" required>
                            </div>

                            <!-- Project Images -->
                            <div class="mb-3">
                                <label for="images" class="form-label"><strong>Upload Project Images</strong></label>
                                <input class="form-control" type="file" name="images[]" id="images" multiple>
                                <small class="form-text text-muted">Choose up to 5 images</small>
                            </div>

                            <!-- Project Description -->
                            <div class="mb-3">
                                <label for="pdes" class="form-label"><strong>Project Description</strong></label>
                                <textarea class="form-control" name="pdes" id="pdes" rows="4" placeholder="Enter project description"></textarea>
                            </div>

                            <!-- Submit Button -->
                            <button type="submit" class="btn btn-primary">Submit</button>

                        </form>
                    </div>
                </div>
            </div>
        </div>

        </div>
                
        <div class="section-body">
            <footer class="footer">
                <div class="container-fluid">
                    <div class="row">
                        <div class="col-md-12 col-sm-12 text-md-right">
                            <ul class="list-inline mb-0">
                                <li class="list-inline-item"><a href="doc/index.html">OM INTERIOR</a></li>
                            </ul>
                        </div>
                    </div>
                </div>
            </footer>
        </div>
    </div>    
</div>

<script src="assets/bundles/lib.vendor.bundle.js"></script>

<script src="assets/bundles/apexcharts.bundle.js"></script>
<script src="assets/bundles/counterup.bundle.js"></script>
<script src="assets/bundles/knobjs.bundle.js"></script>
<script src="assets/bundles/c3.bundle.js"></script>

<script src="assets/js/core.js"></script>
<script src="assets/js/page/project-index.js"></script>
</body>
</html>

<?php

include 'ominterior_db.php'; // Ensure connection is established

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $client = $_POST['cname'];
    $category = $_POST['Category'];
    $ptype = $_POST['ptype'];
    $pname = $_POST['pname'];
    $pdes = $_POST['pdes'];
    $values = [];
   

    $uploadDir = "uploads/projects/$pname/";
    if (!is_dir($uploadDir)) {
        mkdir($uploadDir, 0777, true);
    }
    
    $values = [];
    
    foreach ($_FILES['images']['tmp_name'] as $key => $tmp_name) {
        $originalName = basename($_FILES['images']['name'][$key]);
        $fileType = pathinfo($originalName, PATHINFO_EXTENSION);
    
        // Allow certain file formats
        $allowTypes = array('jpg', 'png', 'jpeg', 'gif', 'webp');
        if (in_array(strtolower($fileType), $allowTypes)) {
            // Generate unique name using timestamp + random ID
            $uniqueName = uniqid('img_') . "_" . time() . "." . $fileType;
            $targetFilePath = $uploadDir . $uniqueName;
    
            if (move_uploaded_file($tmp_name, $targetFilePath)) {
                $values[] = "'$uniqueName'";
            }
        }
    }
    
    if (!empty($values)) {
        echo "Images uploaded successfully!";
    }
    
    if (!empty($category) && !empty($ptype) && !empty($pname) && !empty($pdes) &&!empty($values)) {
        $stmt = $conn->prepare("INSERT INTO project_list (client_name, project_category, project_type, project_title, project_description, project_images) VALUES (?, ?, ?, ?, ?, ?)");
        
        if (!$stmt) {
            die("Statement preparation failed: " . $conn->error);
        }

        $stmt->bind_param("ssssss",$client, $category, $ptype, $pname, $pdes, implode(",",$values));

        if ($stmt->execute()) {
            echo "Project added successfully!";
        } else {
            echo "Error executing statement: " . $stmt->error;
        }
        $stmt->close();
    } 
}
?>

?>