<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<?php
session_start();
// if dont have session user..then
if(! isset($_SESSION['manname']))
{
session_write_close();
die("<script>alert('Please login as manager first before proceed!');window.location.href='login.html';</script>");
}
?>

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />

<!-- Bootstrap -->
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css"
    integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">

<link rel="shortcut icon" href="images/logo.png" type="image/x-icon" />
<link rel="stylesheet" href="style.css">
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.20/css/dataTables.bootstrap4.min.css">
<script src="https://kit.fontawesome.com/0c641bf868.js" crossorigin="anonymous"></script>
<link href="https://fonts.googleapis.com/css?family=Poppins&display=swap" rel="stylesheet">
<link href="https://fonts.googleapis.com/css?family=Acme&display=swap" rel="stylesheet">


<title>Manager - User Information</title>

<style>
    hr.style17 {
        border-top: 1px solid #8c8b8b;
        text-align: center;
        width: 100%;
        margin-top: 40px;
    }
    hr.style17:after {
        content: '§';
        display: inline-block;
        position: relative;
        top: -14px;
        padding: 0 10px;
        background: #f0f0f0;
        color: #8c8b8b;
        font-size: 18px;
        -webkit-transform: rotate(60deg);
        -moz-transform: rotate(60deg);
        transform: rotate(60deg);
    }
    /*style for animated background*/
    .animatedbg{
        width: 100%;
        min-height: 87vh;
        background: linear-gradient(-45deg, #EE7752, #E73C7E, #23A6D5, #23D5AB);
        background-size: 400% 400%;
        animation: change 10s ease-in-out infinite;
        padding-top:40px;
        padding-bottom: 40px;
        font-family: 'Acme', sans-serif;
    }
    @keyframes change{
        0%{
            background-position: 0 50%;
        }
        50%{
            background-position: 100% 50%;
        }
        100%{
            background-position: 0 50%;
        }
    }
    .card {
        /* Add shadows to create the "card" effect */
        box-shadow: 0 4px 8px 0 rgba(0,0,0,0.2);
        transition: 0.3s;
        min-height:500px;
        width: 1400px;
        padding: 20px;
        margin: auto;
        margin-top: 50px;
        margin-bottom: 20px;
        background-color: #d9d9d9;
        
    }
    /* On mouse-over, add a deeper shadow */
    .card:hover {
        box-shadow: 0 12px 32px 0 lightblue;
        }
        .center {
        display: block;
        margin-left: auto;
        margin-right: auto;
        width: 50%;
    }
    .card button
    {
        border: none;
        outline: none;
        height: 35px;
        width: 120px;
        background: #CF161E;
        color: #fff;
        font-size: 14px;
        margin-top: 15px;
    }
    .card button:hover
    {
        cursor: pointer;
        background: #ffc107;
        color: #000;
    }
    .content-table
    {
        border-collapse: collapse;
        font-size: 0.9em;
        width: 1300px;
        border-radius: 5px 5px 0 0;
        overflow: hidden;
        box-shadow: 0 0 20px rgba(0, 0, 0, 0.15);
        text-align:center;
        margin-top:-10px;
    }
    .content-table thead tr
    {
        background-color:#009879;
        color: #fff;
        text-align: center;
        font-weight: bold;
    }
    .content-table th,
    .content-table td
    {
        padding: 12px 15px;
    }
    .content-table tbody tr
    {
        border-bottom: 1px solid #dddddd;
    }
    .content-table tbody tr:nth-of-type(even)
    {
        background-color:#f3f3f3;
    }
    .content-table tbody tr:last-of-type
    {
        border-bottom: 2px solid #009879;
    }

    .content-table2
    {
        border-collapse: collapse;
        margin: 25px 0;
        font-size: 0.9em;
        width: 1300px;
        border-radius: 5px 5px 0 0;
        overflow: hidden;
        box-shadow: 0 0 20px rgba(0, 0, 0, 0.15);
        text-align:center;
    }
    .content-table2 thead tr
    {
        background-color:#3235db;
        color: #fff;
        text-align: center;
        font-weight: bold;
    }
    .content-table2 th,
    .content-table2 td
    {
        padding: 12px 15px;
    }
    .content-table2 tbody tr
    {
        border-bottom: 1px solid #dddddd;
    }
    .content-table2 tbody tr:nth-of-type(even)
    {
        background-color:#f3f3f3;
    }
    .content-table2 tbody tr:last-of-type
    {
        border-bottom: 2px solid #3235db;
    }
</style>
</head>

<body>
<!--Navigation Bar-->
<nav class="navbar navbar-expand-lg navbar-dark bg-dark sticky-top">
    <a class="navbar-brand" href="manager_userinfo.php"><img alt="Brand" src="images/logo.png"
            style="width: 80px; height: 80px;"></a>
    <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent"
        aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
        <span class="navbar-toggler-icon"></span>
    </button>

    <div class="collapse navbar-collapse" id="navbarSupportedContent">
        <ul class="navbar-nav ml-auto" style="padding-right: 50px;">
            <li class="nav-item active">
                <a class="nav-link" href="manager_userinfo.php">User Info <span class="sr-only">(current)</span></a>
            </li>
            <li class="nav-item dropdown">
                <a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown"
                    aria-haspopup="true" aria-expanded="false">
                    Court Booking
                </a>
                <div class="dropdown-menu" aria-labelledby="navbarDropdown">
                    <a class="dropdown-item" href="manager_badminton_court_booking_management.php">Badminton Booking Management</a>
                    <div class="dropdown-divider"></div>
                    <a class="dropdown-item" href="manager_volleyball_court_booking_management.php">Volleyball Booking Management</a>
                    <div class="dropdown-divider"></div>
                    <a class="dropdown-item" href="manager_squash_court_booking_management.php">Squash Booking Management</a>
                    <div class="dropdown-divider"></div>
                    <a class="dropdown-item" href="manager_futsal_court_booking_management.php">Futsal Booking Management</a>
                    <div class="dropdown-divider"></div>
                    <a class="dropdown-item" href="manager_court_booking_report.php">Court Booking Report</a>
                    
                </div>
            </li>
            <li class="nav-item dropdown">
                <a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown"
                    aria-haspopup="true" aria-expanded="false">
                    Sales
                </a>
                <div class="dropdown-menu" aria-labelledby="navbarDropdown">
                    <a class="dropdown-item" href="manager_online_sales_management.php">Sales Management</a>
                    <div class="dropdown-divider"></div>
                    <a class="dropdown-item" href="Manager_online_sales_report.php">Sales Report</a>
                </div>
            </li>
            <li class="nav-item">
                <a class="nav-link" href="logout.php">Logout</a>
            </li>
        </ul>
    </div>
</nav>



<!--Contents here-->
<section class="animatedbg">
    <div class="card">
            <h2 style="text-align:center;color:red;margin-top:15px;">Member Information</h2>
            <table id="tableid1" class="table" style="text-align:center;">
            <?php 
                include("conn.php");//add connection to the php page
                $sql = "Select * from member";
                $result = mysqli_query($conn, $sql);
            ?>
                <thead class="thead-dark">
                    <tr>
                    <th scope="col">Member ID</th>
                    <th scope="col">Member Name</th>
                    <th scope="col">Address</th>
                    <th scope="col">Email</th>
                    <th scope="col">Phone</th>
                    <th scope="col">Last Login Time</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                        if($result)
                        {
                            foreach($result as $row)
                            {
                    ?>
                    <tr>
                        <td><?php echo $row['Mem_ID']?></td>
                        <td><?php echo $row['Mem_Name']?></td>
                        <td><?php echo $row['Mem_Address']?></td>
                        <td><?php echo $row['Mem_Email']?></td>
                        <td><?php echo $row['Mem_Phone']?></td>
                        <td><?php echo $row['User_Last_Login']?></td>
                    </tr>
                    
                    <?php
                            }
                        }
                    ?>
                </tbody>
            </table>
            
            <hr class="style17">
            <h2 style="text-align:center;color:red;margin-top:15px;">Staff Information</h2>
            <table id="tableid2" class="table" style="text-align:center;">
            <?php 
                include("conn.php");//add connection to the php page
                $sql = "Select * from staff";
                $result = mysqli_query($conn, $sql);
            ?>
                <thead class="thead-dark">
                    <tr>
                    <th scope="col">Staff ID</th>
                    <th scope="col">Staff Name</th>
                    <th scope="col">Address</th>
                    <th scope="col">Email</th>
                    <th scope="col">Phone</th>
                    <th scope="col">Last Login Time</th>
                    </tr>
                </thead>
                <tbody>
                    <?php
                        if($result)
                        {
                            foreach($result as $row)
                            {
                    ?>
                    <tr>
                        <td><?php echo $row['Sta_ID']?></td>
                        <td><?php echo $row['Sta_Name']?></td>
                        <td><?php echo $row['Sta_Address']?></td>
                        <td><?php echo $row['Sta_Email']?></td>
                        <td><?php echo $row['Sta_Phone']?></td>
                        <td><?php echo $row['User_Last_Login']?></td>
                    </tr>
                    
                    <?php
                            }
                        }
                    ?>
                </tbody>
            </table>
    </div>
</section>


<!--Bootstrap js-->
<script src="https://code.jquery.com/jquery-3.4.1.slim.min.js"
    integrity="sha384-J6qa4849blE2+poT4WnyKhv5vZF5SrPo0iEjwBvKU7imGFAV0wwj1yYfoRSJoZ+n"
    crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js"
    integrity="sha384-Q6E9RHvbIyZFJoft+2mJbHaEWldlvI9IOYy5n3zV9zzTtmI3UksdQRVvoxMfooAo"
    crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js"
    integrity="sha384-wfSDF2E50Y2D1uUdj0O3uMBJnjuUD4Ih7YwaYd1iqfktj0Uod8GCExl3Og8ifwB6"
    crossorigin="anonymous"></script>
<script src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.10.20/js/dataTables.bootstrap4.min.js"></script>

<!--To make dropdown menu become hover accross-->
<script>
    const $dropdown = $(".dropdown");
    const $dropdownToggle = $(".dropdown-toggle");
    const $dropdownMenu = $(".dropdown-menu");
    const showClass = "show";

    $(window).on("load resize", function () {
        if (this.matchMedia("(min-width: 768px)").matches) {
            $dropdown.hover(
                function () {
                    const $this = $(this);
                    $this.addClass(showClass);
                    $this.find($dropdownToggle).attr("aria-expanded", "true");
                    $this.find($dropdownMenu).addClass(showClass);
                },
                function () {
                    const $this = $(this);
                    $this.removeClass(showClass);
                    $this.find($dropdownToggle).attr("aria-expanded", "false");
                    $this.find($dropdownMenu).removeClass(showClass);
                }
            );
        } else {
            $dropdown.off("mouseenter mouseleave");
        }
    });

    $(document).ready(function() {
        $('#tableid1').DataTable({
            "pagingType": "full_numbers",
            "lengthMenu": [
                [5, 10 ,25, -1],
                [5, 10, 25, "All"]
            ],
            language:{
                search:"_INPUT_",
                searchPlaceholder: "Keywords/Date",
            }
        });
    } );

    $(document).ready(function() {
        $('#tableid2').DataTable({
            "pagingType": "full_numbers",
            "lengthMenu": [
                [5, 10 ,25, -1],
                [5, 10, 25, "All"]
            ],
            language:{
                search:"_INPUT_",
                searchPlaceholder: "Keywords/Date",
            }
        });
    } );
</script>

</body>

</html>