<?php
    session_start();
    include "../../db.php";
    date_default_timezone_set('Asia/Kolkata');
    $currentTime = date('M j, Y g:i a');

    if ( !isset($_SESSION['uid']) && !isset($_SESSION['uref']) && !isset($_SESSION['utype']) ) {
        header("Location: logout.php");
        exit();
    }
    if ( $_SESSION['utype'] != 'master_admin' && $_SESSION['uref'] != 'fssdf4543frts' ) {
        header("Location: logout.php");
        exit();
    }
?>
<!DOCTYPE html>
<html lang="en">
<head>
 <?php include "includes/meta.php"; ?>             
    <?php include "includes/css.php"; ?>
    <link href="css/all.min.css" rel="stylesheet" type="text/css">
    <link href="css/alltable.css" rel="stylesheet"> 
       
 
    
</head>

<body id="page-top" class="mt-55">

  <!--==========================
  Header
  ============================-->
  
  <?php include "includes/header2.php"; ?>

            <div class="container">
            <div class="row mx-0 just ify-content-center">
                <div class="col-12 col-sm-12 col-md-12">
                        <div class="card-body">

                        
                            <h1 class="h3 mb-2 text-gray-800 text-center text-sm-left" style="margin-top: 70px">Nav Header Master</h1>
                            <hr>

                            <?php
                                if ( isset($_GET["edit_id"]) ) {
                                    $edit_run = mysqli_query($con, "SELECT * FROM `nav_page_type_master` WHERE `id` = '$_GET[edit_id]'");
                                    $edit_row = mysqli_fetch_assoc($edit_run);
                                    ?>
                                    <form class="user" method="post" enctype="multipart/form-data">
                                        <h4 class="mb-3 badge badge-secondary">Edit Nav Header</h4>
                                        <div class="form-group row">
                                            <div class="col-sm-6 mb-1 mb-sm-0">
                                                <input type="text" class="form-control form-control-sm mb-2" id="hname" placeholder="Enter Nav Header Name * *" name="hname" value="<?php echo $edit_row["page_header_name"]; ?>" required>
                                            </div>
                                            <div class="col-sm-6 mb-1 mb-sm-0">
                                                <input type="text" class="form-control form-control-sm mb-2" id="htype" placeholder="Enter Nav Header Type (in a single word)*" name="htype" value="<?php echo $edit_row["page_type"]; ?>" required>
                                            </div>
                                        </div>
                                        <button type="submit" class="btn btn-success btn-user m-2" name="edit_cat">
                                            <i class="far fa-image"></i> Update Nav Header
                                        </button>
                                        <a href="category.php" class="btn btn-warning btn-user m-2"> <i class="fas fa-ban"></i> Cancel </a>
                                    </form>
                                    <?php
                                } else {
                                    ?>
                                    <form class="user" method="post" enctype="multipart/form-data">
                                        <h4 class="mb-2 badge badge-secondary" data-toggle="collapse" data-target="#target" style="cursor:pointer;">Add New Nav Header</h4>
                                        <p class="small"> <i class="fas fa-hand-point-up"></i> Tap Here to add New Nav Header </p>
                                        <div class="collapse" id="target">
                                            <div class="form-group row">
                                                <div class="col-sm-6 mb-1 mb-sm-0">
                                                    <input type="text" class="form-control form-control-sm mb-2" id="hname" placeholder="Enter Nav Header Name *" name="hname" required>
                                                </div>
                                                <div class="col-sm-6 mb-1 mb-sm-0">
                                                    <input type="text" class="form-control form-control-sm mb-2" id="htype" placeholder="Enter Nav Header Type (in a single word)  *" name="htype" required>
                                                </div>
                                            </div>
                                            <button type="submit" class="btn btn-primary btn-user m-2" name="new_category">
                                                <i class="fas fa-user-plus"></i> Add New Nav Header
                                            </button>
                                            <a href="#target" data-toggle="collapse" class="btn btn-warning btn-user m-2"> <i class="fas fa-ban"></i> Cancel </a>
                                        </div>
                                    </form>
                                    <?php
                                }
                            ?>

                            <hr>

                            <div class="row m-0">

                                <div class="col-md-12 p-0">
                                    <div class="table-responsive">
                                        <table class="table table-hover table-bordered table-sm" id="thisismytable">
                                            <thead>
                                                <tr>
                                                    <th>No.</th>
                                                    <th>Header Name</th>
                                                    <th>Header Type</th>
                                                    <th>Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php
                                                    $sql = "SELECT * FROM `nav_page_type_master`
                                                             ORDER BY `page_header_name` ASC";
                                                    $run = mysqli_query($con, $sql);

                                                    $c = 1;
                                                    while ( $rows = mysqli_fetch_assoc($run) ) {
                                                        echo "
                                                        <tr id='$rows[id]'>
                                                            <td>
                                                                <span class='badge badge-info badge-pill'>$c</span>
                                                            </td>
                                                            <td class='text-center align-middle'>
                                                                $rows[page_header_name]
                                                            </td>
                                                            <td class='text-center align-middle'>
                                                                $rows[page_type]
                                                            </td>
                                                            <td class='text-center align-middle'>
                                                                <a href='nav_header_master.php?edit_id=$rows[id]' class='m-2 btn btn-success btn-sm rounded-circle' title='Click to Edit'> <i class='fas fa-pencil-alt'></i> </a>

                                                               
                                                            </td>
                                                        </tr>
                                                        ";
                                                        $c++;
                                                    }
                                                ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                </div>

            </div>

            <?php include "includes/ft.php"; ?>
            <?php include "includes/js.php"; ?>



    <div class="modal fade" id="show-img" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-body">
                    <img src="" alt="sliderImage" id="image_modal" class="w-100">
                    <p class="small mt-3 mb-2" id="dimension"> <span class="font-weight-bold"> Name </span> : </p>
                    <p class="small mb-2" id="dimension"> <span class="font-weight-bold"> Dimension </span> : </p>
                    <p class="small mb-2" id="dimension"> <span class="font-weight-bold"> Size </span> : </p>
                </div>
                <div class="modal-footer">
                    <button type="close" class="btn btn-secondary" data-dismiss="modal"> Close </button>
                </div>
            </div>
        </div>
    </div>




    <script>
        function checkFileDetails() {
            var fi = document.getElementById('file');
            if (fi.files.length > 0) {
                for (var i = 0; i <= fi.files.length - 1; i++) {
                    var fileName, fileExtension, fileSize, fileType, dateModified;
                    fileName = fi.files.item(i).name;
                    fileExtension = fileName.replace(/^.*\./, '');
                    if (fileExtension == 'png' || fileExtension == 'jpg' || fileExtension == 'jpeg') {
                        readImageFile(fi.files.item(i));
                    }
                }
                function readImageFile(file) {
                    var reader = new FileReader();
                    reader.onload = function (e) {
                        var img = new Image();
                        img.src = e.target.result;
                        img.onload = function () {
                            var imgWidth = this.width;
                            var imgHeight = this.height;

                            if ( imgWidth == 1200 && imgHeight == 512 || imgWidth == 1500 && imgHeight == 640 ) {
                                var imgCheck = "<i class='fas fa-check-circle text-success'></i>";
                            } else {
                                var imgCheck = "<i class='fas fa-times-circle text-danger'></i>";
                            }
                            document.getElementById('fileInfo').innerHTML =
                                document.getElementById('fileInfo').innerHTML + '<br> ' +
                                'Name: <b>' + file.name + '</b> <br>' +
                                'Size: <b>' + Math.round((file.size / 1024)) + '</b> KB <br>' +
                                'Dimension: <b>' + imgWidth + '</b> x <b>' + imgHeight + '</b> ' + imgCheck + ' <br>';
                        }
                    };
                    reader.readAsDataURL(file);
                }
            }
        }
    </script>




    <script>
        $(document).ready(function(){
            $('#thisismytable').DataTable();
            $('#show-img').on('show.bs.modal', function (e) {
                var src = $(e.relatedTarget).attr('src');
                $(this).find('.modal-body > img').attr('src', src);
            });
        });

        // var $sortable = $("#thisismytable > tbody");

        // $sortable.sortable({
        //     stop: function ( event, ui ) {
        //         var parameters = $sortable.sortable( "toArray" );
        //         $.post("slider_position.php",{value:parameters},function(result){
        //             $(document).ready(function() {
        //                 const Toast = Swal.mixin({
        //                     toast: true,
        //                     position: 'bottom',
        //                     showConfirmButton: false,
        //                     timer: 2000
        //                 });
        //                 Toast.fire({
        //                     type: 'success',
        //                     title: result
        //                 });
        //             });
        //         });
        //     }
        // });
    </script>

</body>
</html>



<?php


     if(isset($_POST['new_category'])){

        $hname = mysqli_real_escape_string($con, strip_tags($_POST['hname']));
        $htype = mysqli_real_escape_string($con, strip_tags($_POST['htype']));

        $ins_sql = "INSERT INTO `nav_page_type_master`  (page_type, page_header_name) VALUES ('$htype', '$hname')";

        if(mysqli_query($con, $ins_sql)){
            ?>
            <script>window.location = 'nav_header_master.php';</script>
            <?php
        }
        else{
            ?>
            <script>
                alert('OOPS !!!!');
                setTimeout(() => {
                    window.location = 'nav_header_master.php';
                }, 1200);
            </script>
            <?php
        }
    }

    if(isset($_POST['edit_cat'])){

        $hname = mysqli_real_escape_string($con, strip_tags($_POST['hname']));
        $htype = mysqli_real_escape_string($con, strip_tags($_POST['htype']));

        $up_sql = "UPDATE `nav_page_type_master` SET `page_type` = '$htype' ,  `page_header_name` = '$hname'   WHERE `id` = '$_GET[edit_id]'";

        if(mysqli_query($con, $up_sql)){
            ?>
            <script>window.location = 'nav_header_master.php';</script>
            <?php
        }
        else{
            ?>
            <script>
                alert('OOPS !!!!');
                setTimeout(() => {
                    window.location = 'nav_header_master.php?edit_id=<?php echo $_GET["edit_id"]; ?>';
                }, 500);
            </script>
            <?php
        }
    }


    if(isset($_POST['new_admin'])){
        $uname = mysqli_real_escape_string($con, strip_tags($_POST['uname']));
        $uphone = mysqli_real_escape_string($con, strip_tags($_POST['uphone']));
        $upass = mysqli_real_escape_string($con, strip_tags($_POST['upass']));
        $uabout = mysqli_real_escape_string($con, strip_tags($_POST['uabout']));
        $chk_ph = mysqli_query($con, "SELECT uphone FROM users WHERE uphone = '$uphone'");
        $chk_ph_count = mysqli_num_rows($chk_ph);
        if ( $chk_ph_count < 1 ) {
            $uref = rand().'_'.time();

            $ins_sql = "INSERT INTO users (uname, uphone, upass, uref, utype, uabout, ucreated) VALUES ('$uname', '$uphone', '$upass', '$uref', 'basic_lvl_admin', '$uabout', '$currentTime')";

            if(mysqli_query($con, $ins_sql)){
                ?>
                <script>window.location = 'admin_lvl2.php';</script>
                <?php
            }
            else{
                ?>
                <script>
                    alert('OOPS !!!!');
                    setTimeout(() => {
                        window.location = 'admin_lvl2.php';
                    }, 1200);
                </script>
                <?php
            }
        } else {
            ?>
            <script>
                alert('Mobile Number Exists');
                setTimeout(() => {
                    window.location = 'admin_lvl2.php';
                }, 500);
            </script>
            <?php
        }
    }




    if ( isset($_GET["del_id"]) ) {

        $del_sql = "DELETE FROM users WHERE uid = '$_GET[del_id]'";

        if ( mysqli_query($con, $del_sql) ) {
            ?>
            <script>window.location = "admin_lvl2.php";</script>
            <?php
        } else {
            ?>
            <script>
                alert('OOPS !!!!');
                setTimeout(() => {
                    window.location = 'admin_lvl2.php';
                }, 1200);
            </script>
            <?php
        }
        
    }





    if(isset($_POST['edit_users'])){
        $uname = mysqli_real_escape_string($con, strip_tags($_POST['uname']));
        $uphone = mysqli_real_escape_string($con, strip_tags($_POST['uphone']));
        $upass = mysqli_real_escape_string($con, strip_tags($_POST['upass']));
        $uabout = mysqli_real_escape_string($con, strip_tags($_POST['uabout']));
        $chk_ph = mysqli_query($con, "SELECT uphone FROM users WHERE uname != '$uname' AND uphone = '$uphone'");
        $chk_ph_count = mysqli_num_rows($chk_ph);
        if ( $chk_ph_count < 1 ) {
            $up_sql = "UPDATE users SET uname = '$uname', uphone = '$uphone', upass = '$upass', uabout = '$uabout' WHERE uid = '$_GET[edit_id]'";
    
            if(mysqli_query($con, $up_sql)){
                ?>
                <script>window.location = 'admin_lvl2.php';</script>
                <?php
            }
            else{
                ?>
                <script>
                    alert('OOPS !!!!');
                    setTimeout(() => {
                        window.location = 'admin_lvl2.php';
                    }, 1200);
                </script>
                <?php
            }
        } else {
            ?>
            <script>
                alert('Mobile Number Exists');
                setTimeout(() => {
                    window.location = 'admin_lvl2.php?edit_id=<?php echo $_GET["edit_id"]; ?>';
                }, 500);
            </script>
            <?php
        }
    }

?>