<?php
include("connection.php");
include("header.php");

$pro_id = isset($_GET['p_id']) ? intval($_GET['p_id']) : 0;

// Fetch existing product
$sql = "SELECT * FROM product WHERE p_id = '$pro_id'";
$query = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($query);

// Slug generator
function generateSlug($string)
{
    $slug = preg_replace('/[^A-Za-z0-9-]+/', '-', strtolower($string));
    return trim($slug, '-');
}

if (isset($_POST['update'])) {

    $title       = mysqli_real_escape_string($con, $_POST['title']);
    $inputSlug   = mysqli_real_escape_string($con, $_POST['slug']);
    $description = mysqli_real_escape_string($con, $_POST['description']);
    $top_cat_id  = intval($_POST['top_cat_id']);
    $old_image   = $_POST['old_image'];

    // Generate unique slug
    $baseSlug = empty($inputSlug) ? generateSlug($title) : generateSlug($inputSlug);
    $slug = $baseSlug;
    $counter = 1;

    while (true) {
        $checkSlug = mysqli_query($con, "SELECT COUNT(*) as total FROM product WHERE slug='$slug' AND p_id != '$pro_id'");
        $slugRow = mysqli_fetch_assoc($checkSlug);

        if ($slugRow['total'] == 0) break;

        $slug = $baseSlug . '-' . $counter;
        $counter++;
    }

    // Image Upload
    if (!empty($_FILES['Image']['name'])) {

        $originalName = $_FILES['Image']['name'];
        $ext = strtolower(pathinfo($originalName, PATHINFO_EXTENSION));

        // Allowed extensions (optional but recommended)
        $allowed = ['jpg', 'jpeg', 'png', 'webp'];
        if (!in_array($ext, $allowed)) {
            die("Invalid file format.");
        }

        $uniqueName = 'service_' . time() . '_' . uniqid() . '.' . $ext;
        $img_path = "./assets/images/service/" . $uniqueName;

        if (move_uploaded_file($_FILES['Image']['tmp_name'], $img_path)) {

            // Delete old image
            if (!empty($old_image) && file_exists("./assets/images/service/" . $old_image)) {
                unlink("./assets/images/service/" . $old_image);
            }

            $Image = $uniqueName;
        } else {
            $Image = $old_image;
        }
    } else {
        $Image = $old_image;
    }

    // Update query
    $sql1 = "UPDATE product SET 
                Image='$Image',
                title='$title',
                slug='$slug',
                description='$description',
                t_id='$top_cat_id'
            WHERE p_id='$pro_id'";

    $query1 = mysqli_query($con, $sql1);

    if ($query1) {
        header("Location: view_product.php");
        exit();
    } else {
        echo "Update failed: " . mysqli_error($con);
    }
}
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8" />
    <title>Service Update</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <meta content="" name="description" />
    <meta content="" name="author" />
    <!-- App favicon -->
    <!-- <link rel="shortcut icon" href="assets/images/favicon.ico" /> -->

    <!-- Plugins css -->
    <link href="assets/libs/dropzone/dropzone.css" rel="stylesheet" type="text/css" />
    <link rel="stylesheet" type="text/css" href="https://use.fontawesome.com/releases/v5.8.1/css/all.css">
    <link rel="shortcut icon" href="./assets/logo/fav.png" />

    <!-- Bootstrap Css -->
    <link href="assets/css/bootstrap.min.css" id="bootstrap-style" rel="stylesheet" type="text/css" />
    <!-- Icons Css -->
    <link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />
    <!-- App Css-->
    <link href="assets/css/app.min.css" id="app-style" rel="stylesheet" type="text/css" />
    <!-- App js -->
    <!-- <script src="assets/js/plugin.js"></script> -->
    <style>
        .form .input {
            width: 100%;
            background: white;
            border: none;
            padding: 15px 20px;
            border-radius: 20px;
            margin-bottom: 9px;
            margin-top: 15px;
            box-shadow: rgba(0, 0, 0, 0.24) 0px 3px 8px;
            border-inline: 2px solid transparent;
        }

        input[name='Image'] {
            display: none;

        }

        div#upload {
            cursor: pointer;

        }

        ::-webkit-file-upload-button {
            display: none;
        }

        /* 
        .form .input::-moz-placeholder {
            color: rgb(170, 170, 170);
        }

        .form .input::placeholder {
            color: rgb(170, 170, 170);
        }

        .form .input:focus {
            outline: none;
            border-inline: 2px solid #12b1d1;
        } */

        .filepath {
            display: none;
        }

        img[alt="img"] {
            width: clamp(50px, 15%, 100px);
            aspect-ratio: 1/0.70;
        }
    </style>
</head>

<body data-sidebar="dark">
    <!-- <body data-layout="horizontal" data-topbar="dark"> -->

    <!-- Begin page -->
    <div id="layout-wrapper">

        <div class="w-80 ">
            <div class="page-content" style="width: 80%;margin-left: 260px;">
                <div class="container">
                    <!-- start page title -->
                    <div class="row">
                        <div class="col-12">
                            <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                                <h4 class="mb-sm-0 font-size-18">update Product</h4>


                            </div>
                        </div>
                    </div>
                    <!-- end page title -->

                    <div class="row">

                        <div class="tab-content" id="myTabContent">
                            <div class="tab-pane fade show active" id="home" role="tabpanel" aria-labelledby="home-tab">
                                <div class="col-12">
                                    <div class="card">
                                        <div class="card-body">

                                            <div>
                                                <form class="form" action="" method="POST" enctype="multipart/form-data">
                                                    <!-- Hidden for old image -->
                                                    <input type="hidden" name="old_image" value="<?php echo $row['Image']; ?>">

                                                    <div class="dropzone">
                                                        <div class="fallback">
                                                            <input type="file" name="Image" id="imageInput" />
                                                        </div>
                                                        <div class="dz-message needsclick" id="upload">
                                                            <div class="mb-3">
                                                                <i class="display-4 text-muted bx bxs-cloud-upload"></i>
                                                            </div>
                                                            <h4>Drop files here or click to upload.</h4>
                                                        </div>
                                                    </div>

                                                    <ul class="list-unstyled mb-0" id="dropzone-preview"></ul>

                                                    <!-- Preview -->
                                                    <div class="filepath" style="display:block; margin-top:10px;">
                                                        <img id="previewImg" src="./assets/images/service/<?php echo $row['Image']; ?>" alt="img" style="max-height:150px;">
                                                        <span id="filename"><?php echo $row['Image']; ?></span>
                                                    </div>

                                                    <br>

                                                    <div class="row">

                                                        <div class="col-lg-4">
                                                            <label class="form-label">Select Top Category</label>
                                                            <select class="form-select" name="top_cat_id" id="top_category" required>
                                                                <option value="">Select Top Level Category</option>
                                                                <?php
                                                                $qr = "SELECT * FROM tbl_top_category ORDER BY cat_name ASC";
                                                                $results = mysqli_query($con, $qr);

                                                                while ($rows = mysqli_fetch_assoc($results)) {
                                                                    $selected = ($row['t_id'] == $rows['t_id']) ? 'selected' : '';
                                                                    echo '<option ' . $selected . ' value="' . $rows['t_id'] . '">' . $rows['cat_name'] . '</option>';
                                                                }
                                                                ?>
                                                            </select>
                                                        </div>

                                                        <div class="col-lg-4">
                                                            <label for="">Title</label>
                                                            <input type="text" class="form-control" id="title" name="title" value="<?php echo $row['title']; ?>" placeholder="Enter Your title" onkeyup="generateSlug()" />
                                                        </div>
                                                        <div class="col-lg-4">
                                                            <label for="">Slug</label>
                                                            <input type="text" class="form-control" id="slug" name="slug" value="<?php echo $row['slug']; ?>" placeholder="Enter Your slug" />
                                                        </div>


                                                    </div>
                                                    <br>

                                                    <br>
                                                    <label for="">Description</label>
                                                    <textarea name="description" id="Experience"><?php echo htmlspecialchars($row['description'] ?? ''); ?></textarea>


                                                    <div class="text-center mt-4">
                                                        <button type="submit" name="update" class="btn btn-primary" value="submit">
                                                            Update
                                                        </button>
                                                        <a href="view_product.php"><button type="button" class="btn btn-danger">View Data</button></a>
                                                    </div>
                                                </form>
                                            </div>

                                        </div>
                                    </div>
                                </div>
                            </div>

                        </div>
                        <!-- end col -->
                    </div>
                    <!-- end row -->
                </div>
                <!-- container-fluid -->
            </div>
            <!-- End Page-content -->


        </div>
        <!-- end main content-->
    </div>
    <!-- END layout-wrapper -->




    <!-- JAVASCRIPT -->
    <script src="assets/libs/jquery/jquery.min.js"></script>
    <script src="assets/libs/bootstrap/js/bootstrap.bundle.min.js"></script>
    <script src="assets/libs/metismenu/metisMenu.min.js"></script>
    <script src="assets/libs/simplebar/simplebar.min.js"></script>
    <script src="assets/libs/node-waves/waves.min.js"></script>

    <!-- Plugins js -->
    <script src="assets/libs/dropzone/dropzone-min.js"></script>

    <!-- Form file upload init js -->
    <script src="assets/js/pages/form-file-upload.init.js"></script>

    <script src="assets/js/app.js"></script>
    <script src="./ck editor/ckeditor.js"></script>
    <script>
        ['Experience', 'Experience1', 'Experience2', 'Experience3'].forEach(function(id) {
            CKEDITOR.replace(id);
        });
    </script>
    <script>
        const imgInput = document.querySelector("input[name='Image']");
        const uploadBox = document.getElementById('upload');
        const previewImg = document.getElementById('previewImg');
        const filenameSpan = document.getElementById('filename');

        uploadBox.onclick = () => imgInput.click();

        imgInput.onchange = () => {
            if (imgInput.files.length > 0) {
                const file = imgInput.files[0];
                const fileURL = URL.createObjectURL(file);
                previewImg.src = fileURL;
                filenameSpan.textContent = file.name;
                document.querySelector(".filepath").style.display = 'block';
            }
        };
    </script>

    <!-- slug auto -->
    <script>
        function generateSlug() {
            let title = document.getElementById("title").value;
            let slug = title.toLowerCase()
                .replace(/[^a-z0-9\s-]/g, '')
                .replace(/\s+/g, '-')
                .replace(/-+/g, '-')
                .trim();
            document.getElementById("slug").value = slug;
        }
    </script>
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

    <script>
        $(document).ready(function() {

            function loadMidCategory(topCatId, selectedMid = '') {
                if (topCatId != "") {
                    $.ajax({
                        url: "get_mid_categories.php",
                        type: "POST",
                        data: {
                            t_id: topCatId
                        },
                        success: function(data) {
                            $("#mid_category").html(data);

                            if (selectedMid != '') {
                                $("#mid_category").val(selectedMid);
                            }
                        }
                    });
                }
            }

            // On change
            $("#top_category").change(function() {
                var topCatId = $(this).val();
                loadMidCategory(topCatId);
            });

            // 🔥 AUTO LOAD ON EDIT PAGE
            var selectedTop = "<?php echo $row['t_id']; ?>";
            var selectedMid = "<?php echo $row['m_id']; ?>";

            if (selectedTop != "") {
                loadMidCategory(selectedTop, selectedMid);
            }

        });
    </script>


    <script>
        document.getElementById('l_id').addEventListener('change', function() {

            const locationId = this.value;

            if (!locationId) {
                document.getElementById('l_description').value = '';
                return;
            }

            fetch('get-pro-location.php', {
                    method: 'POST',
                    headers: {
                        'Content-Type': 'application/x-www-form-urlencoded'
                    },
                    body: 'pro_id=<?= $pro_id ?>&l_id=' + locationId
                })
                .then(res => res.json())
                .then(data => {

                    console.log(data);

                    if (CKEDITOR.instances['Experience2']) {
                        CKEDITOR.instances['Experience2'].setData(data.l_description ?? '');
                    }

                })
                .catch(err => console.error(err));
        });
    </script>



    <!--  -->
</body>

</html>