<?php
include_once('include/config.php');
if (!isLoggedIn()) {
    $_SESSION['msg'] = "You must log in first";
    header('location: login.php');
}
if (!isAdmin()) {
    $_SESSION['msg'] = "You are not Admin";
    header('location: login.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_customer SET cust_status='Active' WHERE cus_id='$pageID'";
           $result = mysqli_query($db, $sql) or die("Query unsuccessful");
           
           mysqli_query($db, "INSERT INTO `notification`(`emp_id`, `cus_id`, `info`, `action`, `action_by`, `user_type`, `date`)
            VALUES ('Null','$pageID','Active Customer','Customer','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
       }
   
       if ($result) {
           echo "<script>
                   window.alert('Activated successfully.');
                   window.location.href = 'manage-customer.php';
                 </script>";
       }
     }
   
      if (isset($_POST['inactive'])) {
       // Handle the inactive logic here
       $checkedIDs = $_POST['checkedIDs'];
   
       foreach ($checkedIDs as $pageID) {
           $sql = "UPDATE tbl_customer SET cust_status='Inactive' WHERE cus_id='$pageID'";
           $result = mysqli_query($db, $sql) or die("Query unsuccessful");
           
           mysqli_query($db, "INSERT INTO `notification`(`emp_id`, `cus_id`, `info`, `action`, `action_by`, `user_type`, `date`)
            VALUES ('Null','$pageID','Inactive Customer','Customer','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
       }
   
       if ($result) {
           echo "<script>
                   window.alert('Deactivated successfully.');
                   window.location.href = 'manage-customer.php';
                 </script>";
       }
     }
     
     if (isset($_POST['archive'])) {
       // Handle the inactive logic here
       $checkedIDs = $_POST['checkedIDs'];
   
       foreach ($checkedIDs as $pageID) {
           $sql = "UPDATE tbl_customer SET cust_status='Archive' WHERE cus_id='$pageID'";
           $result = mysqli_query($db, $sql) or die("Query unsuccessful");
           
           mysqli_query($db, "INSERT INTO `notification`(`emp_id`, `cus_id`, `info`, `action`, `action_by`, `user_type`, `date`)
            VALUES ('Null','$pageID','Archive Customer','Customer','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
       }
   
       if ($result) {
           echo "<script>
                   window.alert('Archive successfully.');
                   window.location.href = 'manage-customer.php';
                 </script>";
       }
     }
     
    if (isset($_POST['delete'])) {
       // Handle the inactive logic here
       $checkedIDs = $_POST['checkedIDs'];
   
       foreach ($checkedIDs as $pageID) {
           $sql = "DELETE FROM `tbl_customer` WHERE cus_id='$pageID'";
           $result = mysqli_query($db, $sql) or die("Query unsuccessful");
           
           mysqli_query($db, "INSERT INTO `notification`(`emp_id`, `cus_id`, `info`, `action`, `action_by`, `user_type`, `date`)
            VALUES ('Null','$pageID','Delete Customer','Customer','".$_SESSION['user']['id']."','".$_SESSION['user']['user_type']."','$currentDate')");
       }
   
       if($result){
          echo "<script>
                window.alert('Deleted successfully.');
                window.location.href = 'manage-customer.php';
                </script>";	
         }
     }
    
    
    if (isset($_POST['Update-order'])) {
    $pageIDs = $_POST['paID'];
    $site_pages_order_bys = $_POST['site_pages_order_by'];
    $stmt = my_prepared("UPDATE tbl_customer SET cust_order = ? WHERE cus_id = ?");

    for ($i = 0; $i < count($pageIDs); $i++) {
        $pageID = $pageIDs[$i];
        $orderValue = $site_pages_order_bys[$i];

        mysqli_stmt_bind_param($stmt, 'ii', $orderValue, $pageID);
        $result = mysqli_stmt_execute($stmt);

        if (!$result) {
            die("Query unsuccessful: " . mysqli_error($db));
        }
     }
     mysqli_stmt_close($stmt);
     header("Location: manage-customer.php");
     exit();
  }

}

?>
<!DOCTYPE html>
<html lang="en">
    
<head>
    <?php include "top-links.php"?>
</head>

<body>
    <div class="wrapper">
    <?php include "header.php"?>

    <?php include "sidebar.php"?>

        <div class="content-page">
            <div class="content">

                <!-- Start Content-->
                <div class="container-fluid">
                <div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-header">
                                    <h4 class="header-title">Manage Customers</h4>
                                    <button  onclick="window.location.href='add-customer.php'" class="float-left"> + Add Customer</button>
                                </div>
                                <div class="card-body">
                                    <!-- Dropdown for selecting entries per page -->
                                    <div class="row">
                                        <div class="col-6">
                                            <div class="form-group" style="width:100px;">
                                                <label for="entriesPerPage">Show entries:</label>
                                                <select class="form-control" id="entriesPerPage" onchange="changeEntriesPerPage(this.value)">
                                                    <option value="20" <?php if ($limit == 20) echo "selected"; ?>>20</option>
                                                    <option value="50" <?php if ($limit == 50) echo "selected"; ?>>50</option>
                                                    <option value="100" <?php if ($limit == 100) echo "selected"; ?>>100</option>
                                                    <option value="500" <?php if ($limit == 500) echo "selected"; ?>>500</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-6">
                                            <!--<div class="form-group" style="width:100px;">-->
                                            <!--    <input type="text" id="searchInput" placeholder="Search Data">-->
                                            <!--</div>-->
                                            <div class="app-search  d-lg-block">
                                            <label for="entriesPerPage">Search Data:</label>
                                                <div class="input-group">
                                                    <input type="text" class="form-control" id="searchInput" placeholder="Search..." onkeydown="if(event.keyCode==13){ search(); }">
                                                    <!--<span class="ri-search-line search-icon text-muted"></span>-->
                                                </div>
                                            </div>
                                        </div>
                                    </div><hr>
                                    
                                    <table id="basic-datatable" class="table table-striped dt-responsive nowrap w-100">
                                        <thead>
                                            <tr>
                                                <th>Sr No</th>
                                                <!--<th>Cus_id</th>-->
                                                <th>Customer Name</th>
                                                <!--<th>Image</th>-->
                                                <th>Mobile No</th>
                                                <th>Email</th> 
                                                <th>Address</th>
                                                <th>State</th>
                                                <th>Status</th>
                                                <th><input type="checkbox" id="selectAll"/></th>
                                                <th>Edit</th>
                                                <!--<th>Delete</th>-->
                                            </tr>
                                        </thead>
                                        <form method="POST" action="<?php $_PHP_SELF?>" onsubmit="return validateForm()">
                                        <tbody>
                                            <?php
                                                $limit = isset($_GET['entries']) ? $_GET['entries'] : 20;
                                                $page = isset($_GET['page']) ? $_GET['page'] : 1;
                                                $start = ($page - 1) * $limit; 
                                                $searchTerm = isset($_GET['search']) ? $_GET['search'] : '';
                                                $sql = "SELECT * FROM `tbl_customer` WHERE `cus_id`!=0";
                                                if (!empty($searchTerm)) {
                                                    $sql .= " AND `cp_name` LIKE '%$searchTerm%'";
                                                    $sql .= " OR `cust_phone` LIKE '%$searchTerm%'";
                                                    $sql .= " OR `cust_email` LIKE '%$searchTerm%'";
                                                    $sql .= " OR `cust_address` LIKE '%$searchTerm%'";
                                                    $sql .= " OR `cust_state` LIKE '%$searchTerm%'";
                                                }
                                                $sql .= " LIMIT $start, $limit";
                                                $run = mysqli_query($db, $sql) or die("Query Not run");
                                                $count = $start;
                                                while ($data = mysqli_fetch_assoc($run)) {
                                                    $count++;
                                            ?>
                                                    <tr>
                                                        <td><?php echo $count; ?></td>
                                                        <!--<td><?php echo $data['cus_id']; ?></td>-->
                                                        <td><?php echo $data['cp_name']; ?></td>
                                                        <!--<td>-->
                                                        <!--    <?php if (!empty($data['cust_photo'])) : ?>-->
                                                        <!--        <img src="images/customer/<?php echo $data['cust_photo']; ?>" style="border-radius:50%; width:50px; height:50px;">-->
                                                        <!--    <?php else : ?>-->
                                                        <!--        <img src="images/user-default.png" style="border-radius:50%; width:50px; height:50px;">-->
                                                        <!--    <?php endif; ?>-->
                                                        <!--</td>-->
                                                        <td><?php echo $data['cust_phone']; ?></td>
                                                        <td><?php echo $data['cust_email']; ?></td>
                                                        <td><?php echo $data['cust_address']; ?></td>
                                                        <td><?php echo $data['cust_state']; ?></td>
                                                        <td class="text-center">
                                                            <?php if($data["cust_status"]=="Active"){?>
                                                            <button type="button" class="btn btn-primary"><span class="label label-default">Active</span></button>
                                                            <?php }elseif($data["cust_status"]=="Archive"){?>
                                                            <button type="button" class="btn btn-warning"><span class="label label-default">Archive</span></button>
                                                            <?php }else{?>
                                                            <button type="button" class="btn btn-danger"><span class="label label-default">Inactive</span></button>
                                                            <?php }?>
                                                        </td>
                                                        <td class="text-center">
                                                            <input type="checkbox" name="checkedIDs[]" class="selectItem" value="<?php echo $data["cus_id"]?>" title="Select Check Box"/>
                                                            <input type="hidden" name="pageID[]" value="<?php echo $data["cus_id"]?>">
                                                        </td>
                                                        <td><a href="edit-customer.php?id=<?php echo $data['cus_id']; ?>"><i class="ri-edit-fill" title="Edit" style="font-size: medium; color: green;"></i> </a></td>
                                                        <!--<td>-->
                                                            <!--<form action="" method="POST">-->
                                                            <!--    <input type="hidden" name="id" value="">-->
                                                            <!--    <button name="delete_employee" type="submit" style="border:none;"><i class="ri-delete-bin-fill" style="font-size: medium; color: red;"></i></button>-->
                                                            <!--</form>-->
                                                        <!--</td>-->
                                
                                                    </tr>
                                            <?php
                                                }
                                            ?>
                                        </tbody>
                                        <tfoot>
                                        <tr style="text-align: right;"> 
                                            <td colspan="10" class="text-right">
                                                <button type="submit" name="active" class="btn btn-success pull-right mr5" >Active</button>
                                                <button type="submit" name="inactive" class="btn btn-danger pull-right mr5" >Inactive</button>
                                                <button type="submit" name="archive" class="btn btn-warning pull-right mr5" >Archive</button>
                                                <button type="submit" name="delete" class="btn btn-danger pull-right mr5" >Delete</button>
                                            </td>
                                        </tr> 
                                        <tfoot>
                                        </form>
                                    </table>
                                
                                    <?php
                                    // Set the limit and page number
                                    $limit = isset($_GET['entries']) ? (int)$_GET['entries'] : 20;
                                    $page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
                                    $start = ($page - 1) * $limit;
                                    
                                    // Search term
                                    $searchTerm = isset($_GET['search']) ? $_GET['search'] : '';
                                    
                                    // Count total records
                                    $sqlCount = "SELECT COUNT(*) AS total FROM `tbl_customer`";
                                    if (!empty($searchTerm)) {
                                        $sqlCount .= " WHERE `cp_name` LIKE '%$searchTerm%' OR `cust_phone` LIKE '%$searchTerm%' OR `cust_email` LIKE '%$searchTerm%' OR `cust_address` LIKE '%$searchTerm%' OR `cust_state` LIKE '%$searchTerm%'";
                                    }
                                    $result = mysqli_query($db, $sqlCount);
                                    $row = mysqli_fetch_assoc($result);
                                    $total_records = $row['total'];
                                    
                                    // Calculate total pages
                                    $total_pages = ceil($total_records / $limit);
                                    $range = 10;
                                    
                                    if ($total_pages > 1) { // Only show pagination if there's more than one page
                                        echo "<ul class='pagination' style='text-align: right;'>";
                                    
                                        // First and Previous links
                                        if ($page > 1) {
                                            echo "<li class='page-item'><a class='page-link' href='?page=1&entries=$limit&search=$searchTerm'>First</a></li>";
                                            echo "<li class='page-item'><a class='page-link' href='?page=" . ($page - 1) . "&entries=$limit&search=$searchTerm'>&laquo;</a></li>";
                                        }
                                    
                                        // Page number links
                                        for ($i = max(1, $page - $range); $i <= min($page + $range, $total_pages); $i++) {
                                            $activeClass = ($page == $i) ? "active" : "";
                                            echo "<li class='page-item $activeClass'><a class='page-link' href='?page=$i&entries=$limit&search=$searchTerm'>$i</a></li>";
                                        }
                                    
                                        // Next and Last links
                                        if ($page < $total_pages) {
                                            echo "<li class='page-item'><a class='page-link' href='?page=" . ($page + 1) . "&entries=$limit&search=$searchTerm'>&raquo;</a></li>";
                                            echo "<li class='page-item'><a class='page-link' href='?page=$total_pages&entries=$limit&search=$searchTerm'>Last</a></li>";
                                        }
                                    
                                        echo "</ul>";
                                    }
                                    ?>

                                </div>
                                
                                 <!-- end card body-->
                            </div> <!-- end card -->
                        </div><!-- end col-->
                    </div> 
                    </div>
                    </div>
    </div>
</div>

<?php include "footer.php"?>

</body>
</html>