<?php 
include_once('config.php');
	if (!isLoggedIn()) {
		$_SESSION['msg'] = "You must log in first";
		header('location: login.php');
	}
	
if ($_SERVER["REQUEST_METHOD"] === "POST") {
    if (isset($_POST['active'])) {
       // Handle the active logic here
       $checkedIDs = $_POST['checkedIDs'];
   
       foreach ($checkedIDs as $pageID) {
           $sql = "UPDATE tbl_services SET industry_status='Active' WHERE sr_id='$pageID'";
           $result = mysqli_query($db, $sql) or die("Query unsuccessful");
       }
   
       if ($result) {
           echo ("<script>
            window.onload = function() {
                    Swal.fire({
                        icon: 'success',
                        text: 'Activate successfully.',
                        showConfirmButton: false,
                        timer: 1500,
                        timerProgressBar: true,
                        background: '#0f1535',
                        color: '#fefefe',
                        willClose: () => {
                            window.location.href = 'manage-property.php';
                        }
                    });
                }
            </script>");
       }
     }
   
      if (isset($_POST['inactive'])) {
       // Handle the inactive logic here
       $checkedIDs = $_POST['checkedIDs'];
   
       foreach ($checkedIDs as $pageID) {
           $sql = "UPDATE tbl_services SET industry_status='Inactive' WHERE sr_id='$pageID'";
           $result = mysqli_query($db, $sql) or die("Query unsuccessful");
       }
   
       if ($result) {
           echo ("<script>
            window.onload = function() {
                    Swal.fire({
                        icon: 'success',
                        text: 'Deactivated successfully.',
                        showConfirmButton: false,
                        timer: 1500,
                        timerProgressBar: true,
                        background: '#0f1535',
                        color: '#fefefe',
                        willClose: () => {
                            window.location.href = 'manage-property.php';
                        }
                    });
                }
            </script>");
       }
     }
     
    if (isset($_POST['delete'])) {
        // Handle the inactive logic here
        $checkedIDs = $_POST['checkedIDs'];
    
        foreach ($checkedIDs as $pageID) {
            $existing_images_query = "SELECT `img1` FROM `tbl_services` WHERE sr_id='$pageID'";
            $existing_images_result = mysqli_query($db, $existing_images_query) or die("Query unsuccessful");
            $existing_images_row = mysqli_fetch_assoc($existing_images_result);
    
            if (!empty($existing_images_row['img1'])) {
                unlink('images/services/' . $existing_images_row['img1']);
            }
            
            $sql = "DELETE FROM `tbl_services` WHERE sr_id='$pageID'";
            $result = mysqli_query($db, $sql) or die("Query unsuccessful");
        }
    
        if ($result) {
            echo ("<script>
                window.onload = function() {
                    Swal.fire({
                        icon: 'success',
                        text: 'Deleted successfully.',
                        showConfirmButton: false,
                        timer: 1500,
                        timerProgressBar: true,
                        background: '#0f1535',
                        color: '#fefefe',
                        willClose: () => {
                            window.location.href = 'manage-property.php';
                        }
                    });
                }
            </script>");
        }
    }

    
    if (isset($_POST['Update-order'])) {
    $pageIDs = $_POST['paID'];
    $tour_orders = $_POST['tour_order'];

    if (count($pageIDs) === count($tour_orders)) {
        $stmt = mysqli_prepare($db, "UPDATE tbl_services SET tour_order = ? WHERE sr_id = ?");
        if ($stmt === false) {
            die("Prepare failed: " . mysqli_error($db));
        }

        for ($i = 0; $i < count($pageIDs); $i++) {
            $pageID = $pageIDs[$i];
            $orderValue = $tour_orders[$i];
            mysqli_stmt_bind_param($stmt, 'ii', $orderValue, $pageID);
            $result = mysqli_stmt_execute($stmt);
            if (!$result) {
                die("Query unsuccessful: " . mysqli_stmt_error($stmt));
            }
        }
        mysqli_stmt_close($stmt);
        header("Location: manage-property.php");
        exit();
    }
    }
}

?>
<!DOCTYPE html>
<html lang="en">

<head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>Admin</title>

    <!-- Custom fonts for this template-->
    <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
    <link
        href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i"
        rel="stylesheet">

    <!-- Custom styles for this template-->
    <link href="css/sb-admin-2.min.css" rel="stylesheet">

    <style>
        div.dataTables_wrapper div.dataTables_filter input {
            box-shadow: 0px 0 0 !important;
            transform: translate(-123px,1px);
        }
    </style>

    
    <link href="vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet">

</head>

<body id="page-top">

    <!-- Page Wrapper -->
    <div id="wrapper">

       <?php include_once('sidebar.php')?>

        <!-- Content Wrapper -->
        <div id="content-wrapper" class="d-flex flex-column">

            <!-- Main Content -->
            <div id="content">

                <!-- Topbar -->
                <?php include_once('topbar.php')?>
                <!-- End of Topbar -->

                <!-- Begin Page Content -->
                <div class="container-fluid">

                    <!-- Page Heading -->
                    <div class="d-sm-flex align-items-center justify-content-between mb-4">
                        <h1 class="h3 mb-0 text-gray-800 ">Manage Events</h1>
                         <a href="add-property.php" class="d-none d-sm-inline-block btn btn-sm btn-primary shadow-sm"><i class="fas fa-plus fa-sm text-white-50"></i>Add New Events</a> 
                    </div>
                    
                    <!-- DataTales Example -->
                    <div class="card shadow mb-4">
                        <!-- <div class="card-header py-3">
                            <h6 class="m-0 font-weight-bold text-primary">Company</h6>
                        </div> -->
                        <div class="card-body">
                            <div class="table-responsive">
                                <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                                    <thead>
                                        <tr>
                                            <th>Sr. No.</th>
                                            <th>Events Name</th>
                                            <th>Events Image</th>
                                            <!--<th>Product Image-2</th>-->
                                            <!--<th>Product Description</th>-->
                                            <th>Order By</th>
                                            <!--<th>Status</th>-->
                                            <th>Edit</th>
                                            <th><input type="checkbox" id="select-all"></th>
                                        </tr>
                                    </thead>
                                    <form method="POST" action="<?php $_PHP_SELF?>" onsubmit="return validateForm()">
                                    <tbody>
                                        <?php
                                            $sql = "SELECT * FROM `tbl_services` ORDER BY tour_order ASC";
                                            $run = mysqli_query($db,$sql) or die("Query Not run");
                                            $count=0;
                                            while($data = mysqli_fetch_assoc($run)){
                                            if(mysqli_num_rows($run) > 0){
                                            $count++;
                                        ?>
                                        <tr>
                                            <td><?php echo $count; ?></td>
                                            <td><?php echo $data['property_name']?></td>
                                            <td><img width="50px;" heigh"50px;" src="images/<?php echo $data['img1'];?>"></td>
                                            <td>
                                                <input type="text" name="tour_order[]" value="<?php echo htmlspecialchars($data['tour_order']); ?>" style="width:40px; outline:none;">
                                                <input type="hidden" name="paID[]" value="<?php echo htmlspecialchars($data['sr_id']); ?>">
                                            </td>
                                            <td>
                                                <a style="color:green;" href="edit-property.php?id=<?php echo $data['sr_id']?>"><i class="fa fa-edit"></i></a>
                                            </td>
                                            <td>
                                               <input type="checkbox" name="checkedIDs[]" value="<?php echo $data["sr_id"]?>" class=" row-checkbox" >
                                               <input type="hidden" name="pageID[]" value="<?php echo $data["sr_id"]?>">
                                            </td>
                                            <!--<td>-->
                                            <!--    <a style="color:red; padding-left:10px;" href="delete-service.php?id=<?php echo $data['sr_id']?>"><i class="fa fa-trash"></i></a>-->
                                            <!--</td>-->
                                        </tr>
                                        <?php
                                            }else{
                                                echo "<h1>No Data Found</h1>";
                                            }
                                        }
                                        ?>
                                        <tfoot>
                                        <tr> 
                                            <td colspan="10" class="text-right">
                                                <button type="submit" name="Update-order" class="btn btn-success pull-right mr5" >Update Order</button>
                                                <!--<button type="submit" name="inactive" class="btn btn-danger pull-right mr5" >Events Inactive</button>-->
                                                <!--<button type="submit" name="active" class="btn btn-success pull-right mr5" >Events Active</button>-->
                                                <button type="submit" name="delete" class="btn btn-danger pull-right mr5" >Delete</button>
                                            </td>
                                        </tr> 
                                        <tfoot>
                                    </tbody>
                                        </form>
                                </table>
                            </div>
                        </div>
                    </div>


                </div>
                <!-- /.container-fluid -->

            </div>
            <script>
                function validateForm() {
                    var checkboxes = document.getElementsByName('checkedIDs[]');
                    var checked = false;
                    for (var i = 0; i < checkboxes.length; i++) {
                        if (checkboxes[i].checked) {
                            checked = true;
                            break;
                        }
                    }
                    if (!checked && event.submitter.name !== "Update-order") {
                        alert('Check at least one box');
                        return false;
                    }
                    return true;
                }
            </script>
            <script>
        document.getElementById('select-all').addEventListener('change', function() {
            let checkboxes = document.querySelectorAll('.row-checkbox');
            for (let checkbox of checkboxes) {
                checkbox.checked = this.checked;
            }
        });
    </script>
            
            <?php include_once('footer.php')?>

</body>

</html>