<?php
include("connection.php");
include("header.php");
 
function generateSlug($string)
{
    $slug = preg_replace('/[^A-Za-z0-9-]+/', '-', strtolower($string));
    return trim($slug, '-');
}


if(isset($_POST['submit']))
{
    $category_id   = intval($_POST['category_id']);
    $location_name = mysqli_real_escape_string($con,$_POST['location_name']);
    $description   = mysqli_real_escape_string($con,$_POST['description']);
    $status        = intval($_POST['status']);

    // Generate slug
    $inputSlug = trim($_POST['slug']);

    if(empty($inputSlug))
    {
        $slug = generateSlug($location_name);
    }
    else
    {
        $slug = generateSlug($inputSlug);
    }

    // Check slug uniqueness
    $checkSlug = mysqli_query(
        $con,
        "SELECT COUNT(*) AS total
         FROM tbl_location_pages
         WHERE slug='$slug'"
    );

    $slugRow = mysqli_fetch_assoc($checkSlug);

    if($slugRow['total'] > 0)
    {
        $slug .= '-' . time();
    }

    // Image Upload
    $Image = '';

    if(isset($_FILES['Image']) && $_FILES['Image']['error']==0)
    {
        $originalName = $_FILES['Image']['name'];
        $tmpName      = $_FILES['Image']['tmp_name'];

        $extension = strtolower(
            pathinfo($originalName, PATHINFO_EXTENSION)
        );

        $Image = 'loc_' . time() . '_' . uniqid() . '.' . $extension;

        $uploadPath = "./assets/images/location/" . $Image;

        move_uploaded_file($tmpName,$uploadPath);
    }

    $sql = "
        INSERT INTO tbl_location_pages
        (
            category_id,
            location_name,
            slug,
            description,
            image,
            status
        )
        VALUES
        (
            '$category_id',
            '$location_name',
            '$slug',
            '$description',
            '$Image',
            '$status'
        )
    ";

    $query = mysqli_query($con,$sql);

    if($query)
    {
        echo "<script>
                alert('Location Page Added Successfully');
                window.location='view_service_location_pages.php';
              </script>";
        exit;
    }
    else
    {
        echo mysqli_error($con);
    }
}

?>
 
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8" />
    <title>ADD service</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <meta content="Premium Multipurpose Admin & Dashboard Template" name="description" />
    <meta content="Themesbrand" name="author" />
    <!-- App favicon -->
    <link rel="shortcut icon" href="./assets/logo/fav.png" />

    <!-- 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">

    <!-- 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 {
            /* width: 100%;
            height: 100%; */
            display: none;
            /* color: transparent; */
        }

        /* 
        .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">Add Services Location </h4>


                            </div>
                        </div>
                    </div>
                    <!-- end page title -->

                    <div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">

                                    <div>
                                        <form class="form" action="" method="POST" enctype="multipart/form-data">
                                            <div class="dropzone">
                                                <div class="fallback">
                                                    <input placeholder="Image" name="Image" type="file" required="" />
                                                </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>
                                            <div class="filepath">
                                                <img src="" alt="img">

                                                <span id="filename"></span>
                                            </div>
                                            <br>
                                            <div class="row">
                                                <div class="col-lg-3">
                                                    <label for="">Select Service</label>
                                                    <select name="category_id" class="form-control">
                                                        <option>Select Service</option>
                                                    <?php
                                                    $q=mysqli_query($con,"SELECT * FROM tbl_top_category");
                                                    while($row=mysqli_fetch_assoc($q)){
                                                    ?>
                                                    <option value="<?= $row['t_id']; ?>">
                                                        <?= $row['cat_name']; ?>
                                                    </option>
                                                    <?php } ?>
                                                    </select>
                                                </div>

                                                <div class="col-lg-5">
                                                    <label for="">Location Name</label> 
                                                    <input type="text" name="location_name" id="location_name" class="form-control" placeholder="Noida"  onkeyup="generateSlug()">
                                                </div>
                                                <div class="col-lg-4"> 
                                                    <label for="">Slug</label>
                                                    <input type="text" class="form-control" name="slug" id="slug" placeholder="Enter Your slug" />
                                                </div>
                                                
                                           


                                            </div>
                                            <br>
                                           

                                            <label for="">Description</label>
                                            <textarea name="description" id="description"></textarea>
                                               
                                                        
                                            <br>
                                            
                                                  
                                            <div class="col-lg-3">
                                                 </br>
                                                <label for="">Select Status</label>
                                                <select name="status" class="form-control">
                                                   <option value="1">Active</option>
                                                    <option value="0">Inactive</option>
                                                </select>
                                                </br>
                                            </div>
                                                    

                                            <div class="text-center mt-4">
                                                <button type="submit" name="submit" class="btn btn-primary" value="submit">
                                                    submit
                                                </button>
                                                <a href="viewservice.php"><button type="button" class="btn btn-danger">
                                                        View Data
                                                    </button></a>
                                            </div>

                                        </form>

                                    </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>
        ['description', 'Experience1', 'Experience2', 'Experience3'].forEach(function(id) {
            CKEDITOR.replace(id);
        });
    </script>

    <script>
        var img = document.querySelector("input[name='Image']");
        document.getElementById('upload').onclick = () => {
            img.click();
        }

        img.oninput = () => {
            //show path element
            document.getElementById('filename').innerHTML = img.value.replace(/(C:\\fakepath\\)/, "");
            // alert(img.value);

            document.querySelector(".filepath").style.display = 'block';
            // image src

            let file = img.files[0];
            let fileSrc = URL.createObjectURL(file);
            console.log(fileSrc)

            document.querySelector("img[alt='img']").src = fileSrc;

        }
    </script>
    <!-- auto slug add -->
    <script>
        function generateSlug()
        {
            let location =
                document.getElementById('location_name').value;
        
            let slug = location.toLowerCase()
                .replace(/[^a-z0-9\s-]/g,'')
                .replace(/\s+/g,'-')
                .replace(/-+/g,'-')
                .trim();
        
            document.getElementById('slug').value = slug;
        }    
    </script>
    <!-- end slug add -->
</body>

</html>