<?php 
    include'include/session.php';
    
    $tableName="staff";
    $tableName1="class";
    $tableName2="semisterperiod";
    $tableName3="faculty";
    $tableName4="course";
    $tableName5="unit";
    $tableName6="coursework";
    $tableName7="pass";
    $tableName8="school_leave_type";
    
    $sql = "SELECT COUNT(*) as num FROM $tableName WHERE category != 'Admin'"; 
    $pages = mysql_fetch_array(mysql_query($sql));
    $totalStaff = $pages['num'];
    
    $sql1 = "SELECT COUNT(*) as num FROM $tableName1"; 
    $pages1 = mysql_fetch_array(mysql_query($sql1));
    $totalClasses = $pages1['num'];
    
    $sql2 = "SELECT start,end FROM $tableName2 ORDER BY periodID DESC LIMIT 1"; 
    $pages2 = mysql_fetch_array(mysql_query($sql2));
    
    $sql3 = "SELECT COUNT(*) as num FROM $tableName3"; 
    $pages3 = mysql_fetch_array(mysql_query($sql3));
    $totalFaculty = $pages3['num'];
    
    $sql4 = "SELECT COUNT(*) as num FROM $tableName4"; 
    $pages4 = mysql_fetch_array(mysql_query($sql4));
    $totalCourse = $pages4['num'];
    
    $sql5 = "SELECT COUNT(*) as num FROM $tableName5"; 
    $pages5 = mysql_fetch_array(mysql_query($sql5));
    $totalUnit = $pages5['num'];
    
    $sql6 = "SELECT COUNT(*) as num FROM $tableName6"; 
    $pages6 = mysql_fetch_array(mysql_query($sql6));
    $totalCourseWork = $pages6['num'];
    
    $sql7 = "SELECT COUNT(*) as num FROM $tableName7"; 
    $pages7 = mysql_fetch_array(mysql_query($sql7));
    $totalPass = $pages7['num'];
    
    $sql8 = "SELECT COUNT(*) as num FROM $tableName8"; 
    $pages8 = mysql_fetch_array(mysql_query($sql8));
    $totalLeave = $pages8['num'];
?>
<!DOCTYPE html>
<html>

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Dashboard | Administrator | WAKA CMEC</title>
    <link rel="shortcut icon" href="../../../assets/img/logo.png" />
    <link rel="stylesheet" href="../../../assets/bootstrap/css/bootstrap.min.css">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:300,400,700">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto+Slab:300,400|Roboto:300,400,700">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto+Slab:300,400">
    <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Romanesco">
    <link rel="stylesheet" href="../../../assets/fonts/font-awesome.min.css">
    <link rel="stylesheet" href="../../../assets/fonts/material-icons.css">
    <link rel="stylesheet" href="../../../assets/css/ebs-simple-login-form1.css">
    <link rel="stylesheet" href="../../../assets/css/ebs-simple-login-form2.css">
    <link rel="stylesheet" href="../../../assets/css/Data-Table.css">
    <link rel="stylesheet" href="../../../assets/css/Data-Table1.css">
    <link rel="stylesheet" href="../../../assets/css/ebs-simple-login-form.css">
    <link rel="stylesheet" href="../../../assets/css/FPE-Gentella-form-elements.css">
    <link rel="stylesheet" href="../../../assets/css/FPE-Gentella-form-elements1.css">
    <link rel="stylesheet" href="https://cdn.datatables.net/1.10.15/css/dataTables.bootstrap.min.css">
    <link rel="stylesheet" href="../../../assets/css/MUSA_no-more-tables.css">
    <link rel="stylesheet" href="../../../assets/css/MUSA_no-more-tables1.css">
    <link rel="stylesheet" href="../../../assets/css/MUSA_panel-table.css">
    <link rel="stylesheet" href="../../../assets/css/MUSA_panel-table1.css">
    <link rel="stylesheet" href="../../../assets/css/nav.css">
    <link rel="stylesheet" href="../../../assets/css/Navbar---App-Toolbar--LG--MD---Mobile-Nav--SM--XS.css">
    <link rel="stylesheet" href="../../../assets/css/JLX-Fixed-Nav-on-Scroll.css">
    <link rel="stylesheet" href="../../../assets/css/Navbar---App-Toolbar--LG--MD---Mobile-Nav--SM--XS1.css">
    <link rel="stylesheet" href="../../../assets/css/Navbar-Fixed-Side1.css">
    <link rel="stylesheet" href="../../../assets/css/Pretty-Table.css">
    <link rel="stylesheet" href="../../../assets/css/Pretty-Table1.css">
    <link rel="stylesheet" href="../../../assets/css/Profile-Edit.css">
    <link rel="stylesheet" href="../../../assets/css/Profile-Edit1.css">
    <link rel="stylesheet" href="../../../assets/css/Responsive-Form.css">
    <link rel="stylesheet" href="../../../assets/css/Responsive-Form1.css">
    <link rel="stylesheet" href="../../../assets/css/Sidebar-Menu.css">
    <link rel="stylesheet" href="../../../assets/css/Sidebar-Menu1.css">
    <link rel="stylesheet" href="../../../assets/css/styles.css">
    <link rel="stylesheet" href="../../../assets/css/tabela-mloureiro1973.css">
    <link rel="stylesheet" href="../../../assets/css/Team-Clean.css">
</head>

<body style="background-color:rgba(42,63,84,0);">
    <nav class="navbar navbar-default" style="background-color:rgb(62,140,228);">
        <div class="container-fluid">
            <div class="navbar-header"><a class="navbar-brand navbar-link" href="#" style="font-weight:bold;background-color:rgb(62,140,228);">Administrator | Waka CMEC Training Institute</a>
                <button class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navcol-2" style="background-color:rgb(62,140,228);color:rgb(255,255,255);"><span class="sr-only">Toggle navigation</span><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></button>
            </div>
            <div class="collapse navbar-collapse" id="navcol-2">
                <ul class="nav navbar-nav hidden-xs hidden-sm navbar-right" id="desktop-toolbar">
                    <li class="dropdown">
                        <a class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false" href="#"> <i class="fa fa-user"></i> &nbsp; <?php echo $pro;?>  <i class="fa fa-chevron-down fa-fw"></i></a>
                        <ul class="dropdown-menu" role="menu" style="background-color:rgb(249,249,249);">
                            <li role="presentation"><a href="settings.php"><i class="fa fa-user fa-fw"></i> Profile </a></li>
                            <li role="presentation"><a href="password.php"><i class="fa fa-lock fa-fw"></i> Password</a></li>
                            <li role="presentation"><a href="../validate/logout.php"><i class="fa fa-power-off fa-fw"></i>Logout </a></li>
                        </ul>
                    </li>
                </ul>
                <ul class="nav navbar-nav visible-xs-block visible-sm-block" id="mobile-nav">
                    
                    <li class="dropdown">
                        <a class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false" href="#"> <i class="fa fa-user"></i> &nbsp; <?php echo $pro;?> </i> <i class="fa fa-chevron-down fa-fw"></i></a>
                        <ul class="dropdown-menu" role="menu" style="background-color:rgb(249,249,249);">
                            <li role="presentation"><a href="settings.php"><i class="fa fa-user fa-fw"></i> Profile </a></li>
                            <li role="presentation"><a href="password.php"><i class="fa fa-lock fa-fw"></i> Password</a></li>
                            <li role="presentation"><a href="../validate/logout.php"><i class="fa fa-power-off fa-fw"></i>Logout </a></li>
                        </ul>
                    </li>
                    <li role="presentation"><a>&nbsp;</a></li>
                    <li role="presentation"><a>&nbsp;</a></li>
                    
                </ul>
            </div>
        </div>
    </nav>
    <div class="top">
        <nav class="navbar navbar-default" id="navbar-main">
            <div class="container-fluid">
                <div class="navbar-header">
                    <a class="navbar-brand hidden navbar-link" href="#" style="padding:0px;"> </a>
                    <button class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navcol-1"><span class="sr-only">Toggle navigation</span><span class="icon-bar"></span><span class="icon-bar"></span><span class="icon-bar"></span></button>
                </div>
                <div class="collapse navbar-collapse" id="navcol-1">
                    <ul class="nav navbar-nav">
                        <li class="active" role="presentation">
                            <a href="index.php">
                                <i class="fa fa-table" style="margin-right:5px;"></i>
                                Dashboard
                            </a>
                        </li>
                        <li role="presentation">
                            <a href="staff.php">
                                <i class="fa fa-users" style="margin-right:5px;"></i>
                                Staff 
                            </a>
                        </li>
                        <li role="presentation">
                            <a href="faculty.php">Faculty</a>
                        </li>
                        <li role="presentation">
                            <a href="course.php">Course</a>
                        </li>
                        <li role="presentation">
                            <a href="class.php">Class</a>
                        </li>
                        <li role="presentation">
                            <a href="unit.php">Unit</a>
                        </li>
                        <li role="presentation">
                            <a href="assigned-unit.php">
                                <i class="fa fa-bookmark" style="margin-right:5px;"></i>
                                Assigned Units
                            </a>
                        </li>
                        <li role="presentation">
                            <a href="period.php">Block Period</a>
                        </li>
                        <li class="dropdown">
                            <a class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false" href="#">
                                Others <span class="badge bg-red" id="notificationCounter"></span>
                                <span class="caret"></span>
                            </a>
                            <ul class="dropdown-menu" role="menu">
                                <li role="presentation"><a href="pass-request.php">Gate Pass Request <span class="badge bg-red" id="requestCounter"></span></a></li>
                                <li role="presentation"><a href="expired-pass.php">Expired Gate Pass &nbsp;<span class="badge bg-red" id="expiredCounter"></span></a></li>
                                <li role="presentation"><a href="leave-request.php">Staff Leave Request <span class="badge bg-red" id="requestLeaveCounter"></span></a></li>
                                <li role="presentation"><a href="expired-leave.php">Expired Staff Leave &nbsp;<span class="badge bg-red" id="expiredLeaveCounter"></span></a></li>
                                <li role="presentation"><a href="pass.php">Gate Pass</a></li>
                                <li role="presentation"><a href="leave.php">Leave Type</a></li>
                            </ul>
                        </li>
                    </ul>
                </div>
            </div>
        </nav>
    </div>
    <div class="row" style="width:98%;margin-right:auto;margin-left:auto;padding-bottom:5%;-webkit-box-shadow:0px 4px 4px 0px rgba(0,0,0,1);-moz-box-shadow:0px 4px 4px 0px rgba(0,0,0,1);box-shadow:0px 4px 4px 0px rgba(0,0,0,1);margin-bottom:5%;overflow:hidden;">
        <div style="margin-bottom:1%;padding-top:2px;padding-bottom:2px;background-color:rgb(239,239,239);">
            <h2 style="margin-left:1%;font-size:16px;color:rgb(1,1,1);font-weight:bold;"><i class="fa fa-dashboard"></i>&nbsp; Dashboard</h2>
        </div>
        
        <div class="container">
            <div class="row" style="margin-right:0px;margin-left:0px;">
                <div class="col-md-3 col-xs-3">
                    <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                        <p class="text-center" style="color:rgb(3,3,3);background-color:rgb(52,73,94);color:white;font-size:24px;font-weight:bold;">Block </p>
                        <?php
                            if($pages2['end']==NULL && $pages2['start']==NULL )
                            {
                        ?>
                            <p class="bg-warning text-warning" style="font-weight:normal;font-size:16px;text-align:center;"> 
                                <i class="fa fa-warning text-warning"></i> &nbsp;Enter Block Period
                            </p>
                        <?php 
                            }else
                            if(date_format(date_create($pages2['end']),"Y-m-d") < date('Y-m-d'))
                            {
                        ?>
                            <p class="bg-warning text-warning" style="font-weight:normal;font-size:16px;text-align:center;"> 
                                <i class="fa fa-warning text-warning"></i> &nbsp;Enter Next Block Period
                            </p>
                        <?php }else{?>
                             <p style="font-weight:bold;font-size:16px;text-align:center;"> 
                                <?php echo date_format(date_create($pages2['start']),"M. Y")." -to- ".date_format(date_create($pages2['end']),"M. Y");?>
                            </p>
                        <?php }?>
                        <a href="add-sem.php">
                            <button style="width:100%;margin:auto;padding:8px 0px;color:rgb(1,1,1);">Add</button>
                        </a>
                    </div>
                </div>
                
                <div class="col-md-3 col-xs-3">
                    <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                        <p class="text-center" style="color:rgb(3,3,3);background-color:rgb(52,73,94);color:white;font-size:24px;font-weight:bold;">Classes</p>
                        <p style="font-weight:bold;font-size:16px;text-align:center;"> 
                            <?php 
                                    echo $totalClasses;
                                
                            ?> 
                        </p>
                        <a href="add-class.php">
                            <button style="width:100%;margin:auto;padding:8px 0px;color:rgb(1,1,1);">Add</button>
                        </a>
                    </div>
                </div>
                <div class="col-md-2 col-xs-2">
                    <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                        <p class="text-center" style="color:rgb(3,3,3);background-color:rgb(52,73,94);color:white;font-size:24px;font-weight:bold;">Faculty </p>
                        <p style="font-weight:bold;font-size:16px;text-align:center;"> <?php echo $totalFaculty; ?> </p>
                        <a href="add-faculty.php">
                            <button style="width:100%;margin:auto;padding:8px 0px;color:rgb(1,1,1);">Add</button>
                        </a>
                    </div>
                </div>
                <div class="col-md-2 col-xs-2">
                    <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                        <p class="text-center" style="color:rgb(3,3,3);background-color:rgb(52,73,94);color:white;font-size:24px;font-weight:bold;">Course </p>
                        <p style="font-weight:bold;font-size:16px;text-align:center;"> <?php echo $totalCourse; ?> </p>
                        <a href="add-course.php">
                            <button style="width:100%;margin:auto;padding:8px 0px;color:rgb(1,1,1);">Add</button>
                        </a>
                    </div>
                </div>
                <div class="col-md-2 col-xs-2">
                    <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                        <p class="text-center" style="color:rgb(3,3,3);background-color:rgb(52,73,94);color:white;font-size:24px;font-weight:bold;">Units</p>
                        <p style="font-weight:bold;font-size:16px;text-align:center;"> <?php echo $totalUnit; ?> </p>
                        <a href="add-unit.php">
                            <button style="width:100%;margin:auto;padding:8px 0px;color:rgb(1,1,1);">Add</button>
                        </a>
                    </div>
                </div>
            </div>
        </div>
        <hr>
        <div class="container">
            <div class="row" style="margin-right:0px;margin-left:0px;">
                <div class="col-md-3 col-xs-3">
                    <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                        <p class="text-center" style="color:rgb(3,3,3);background-color:rgb(52,73,94);color:white;font-size:24px;font-weight:bold;">Course Work</p>
                        <p style="font-weight:bold;font-size:16px;text-align:center;"> <?php echo $totalCourseWork; ?> </p>
                        <a href="course-work.php">
                            <button style="width:100%;margin:auto;padding:8px 0px;color:rgb(1,1,1);">Add</button>
                        </a>
                    </div>
                </div>
                <div class="col-md-3 col-xs-3">
                    <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                        <p class="text-center" style="color:rgb(3,3,3);background-color:rgb(52,73,94);color:white;font-size:24px;font-weight:bold;">Staff</p>
                        <p style="font-weight:bold;font-size:16px;text-align:center;"> 
                            <?php 
                                if($totalStaff > 999 && $totalStaff <= 999999) {
                                    echo number_format(($totalStaff / 1000),1). ' K';
                                }else
                                if($totalStaff > 999999 && $totalStaff <= 999999999) {
                                    echo number_format(($totalStaff / 1000000),1). ' M';
                                }else
                                if($totalStaff > 999999999 && $totalStaff <= 999999999999) {
                                    echo number_format(($totalStaff / 1000000000),1). ' B';
                                }else
                                if($totalStaff > 999999999999 && $totalStaff <= 999999999999999) {
                                    echo number_format(($totalStaff / 1000000000000),1). ' T';
                                }else {echo $totalStaff;}
                            ?> 
                        </p>
                        <a href="add-staff.php">
                            <button style="width:100%;margin:auto;padding:8px 0px;color:rgb(1,1,1);">Add</button>
                        </a>
                    </div>
                </div>
                <div class="col-md-3 col-xs-3">
                    <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                        <p class="text-center" style="color:rgb(3,3,3);background-color:rgb(52,73,94);color:white;font-size:24px;font-weight:bold;">Gate Pass Types</p>
                        <p style="font-weight:bold;font-size:16px;text-align:center;"> 
                            <?php 
                                if($totalPass > 999 && $totalPass <= 999999) {
                                    echo number_format(($totalPass / 1000),1). ' K';
                                }else
                                if($totalPass > 999999 && $totalPass <= 999999999) {
                                    echo number_format(($totalPass / 1000000),1). ' M';
                                }else
                                if($totalPass > 999999999 && $totalPass <= 999999999999) {
                                    echo number_format(($totalPass / 1000000000),1). ' B';
                                }else
                                if($totalPass > 999999999999 && $totalPass <= 999999999999999) {
                                    echo number_format(($totalPass / 1000000000000),1). ' T';
                                }else {echo $totalPass;}
                            ?> 
                        </p>
                        <a href="add-pass.php">
                            <button style="width:100%;margin:auto;padding:8px 0px;color:rgb(1,1,1);">Add</button>
                        </a>
                    </div>
                </div>
                <div class="col-md-3 col-xs-3">
                    <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                        <p class="text-center" style="color:rgb(3,3,3);background-color:rgb(52,73,94);color:white;font-size:24px;font-weight:bold;">Staff Leave Type</p>
                        <p style="font-weight:bold;font-size:16px;text-align:center;"> <?php echo $totalLeave; ?> </p>
                        <a href="add-leave.php">
                            <button style="width:100%;margin:auto;padding:8px 0px;color:rgb(1,1,1);">Add</button>
                        </a>
                    </div>
                </div>
            </div> 
        </div>
        
        <hr>       
            <div class="row" style="margin-right:0px;margin-left:0px;">
                <div class="col-md-12 col-xs-12"> 
                    <h4 class="bg-orange" style="padding:5px;">Track Changes</h4>
                </div>
                <div class="col-md-12 col-xs-12"> 
                    <div class="col-md-2 col-xs-2">
                        <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                            <p class="text-center" style="color:rgb(3,3,3);background-color:#2eb9b9;color:white;font-size:24px;font-weight:bold;">
                                Accounts
                            </p>
                            <div class="dropdown" style="width:100%;margin-top:5px;">
                                <button class="btn btn-info dropdown-toggle" data-toggle="dropdown" aria-expanded="false" type="button" style="width:100%;color:white;font-weight:normal;font-size:12px;padding:5px">
                                    <div class="col-md-10 text-center">
                                        <i class="fa fa-search"></i> 
                                        &nbsp; View
                                    </div>    
                                    <div class="col-md-2 text-right">
                                        <span class="caret"></span>
                                    </div>
                                </button>
                                <ul role="menu" class="dropdown-menu dropdown-menu-right">
                                    <li role="presentation"><a href="acc-class.php">Students Fee Balance</a></li>
                                    <li role="presentation"><a href="acc-fee.php">Tuition Fee</a></li>
                                    <li role="presentation"><a href="acc-misc.php">Miscellaneous</a></li>
                                    <li role="presentation"><a href="acc-misc_fee.php">Miscellaneous Fee</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                
                    <div class="col-md-2 col-xs-2">
                        <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                            <p class="text-center" style="color:rgb(3,3,3);background-color:#2eb9b9;color:white;font-size:24px;font-weight:bold;">
                                Admissions
                            </p>
                            <div class="dropdown" style="width:100%;margin-top:5px;">
                                <button class="btn btn-info dropdown-toggle" data-toggle="dropdown" aria-expanded="false" type="button" style="width:100%;color:white;font-weight:normal;font-size:12px;padding:5px">
                                    <div class="col-md-10 text-center">
                                        <i class="fa fa-search"></i> 
                                        &nbsp; View
                                    </div>    
                                    <div class="col-md-2 text-right">
                                        <span class="caret"></span>
                                    </div>
                                </button>
                                <ul role="menu" class="dropdown-menu dropdown-menu-right">
                                    <li role="presentation">
                                        <b>&nbsp; Students</b>
                                    </li>
                                    <li role="presentation">
                                        <a href="adm-students.php?ip=preadmitted">Pre Admitted Students</a>
                                    </li>
                                    <li role="presentation">
                                        <a href="adm-students.php?id=admitted">Admitted Students</a>
                                    </li>
                                    <li role="presentation">
                                        <a href="adm-students.php?ia=alumni">Alumni</a>
                                    </li>
                                    
                                    <li role="presentation">
                                        <b>&nbsp; Classes</b>
                                    </li>
                                    <li role="presentation">
                                        <a href="adm-class.php">Classes</a>
                                    </li>
                                </ul>
                            </div>
                        </div>
                    </div>
                
                    <div class="col-md-2 col-xs-2">
                        <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                            <p class="text-center" style="color:rgb(3,3,3);background-color:#2eb9b9;color:white;font-size:24px;font-weight:bold;">
                                Lecturer</p>
                            <div class="dropdown" style="width:100%;margin-top:5px;">
                                <button class="btn btn-info dropdown-toggle" data-toggle="dropdown" aria-expanded="false" type="button" style="width:100%;color:white;font-weight:normal;font-size:12px;padding:5px">
                                    <div class="col-md-10 text-center">
                                        <i class="fa fa-search"></i> 
                                        &nbsp; View
                                    </div>    
                                    <div class="col-md-2 text-right">
                                        <span class="caret"></span>
                                    </div>
                                </button>
                                <ul role="menu" class="dropdown-menu dropdown-menu-right">
                                    <li role="presentation"><a href="lec-assignment.php">Assignments</a></li>
                                    <li role="presentation"><a href="lec-exam.php">Exam Results</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                
                    <div class="col-md-2 col-xs-2">
                        <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                            <p class="text-center" style="color:rgb(3,3,3);background-color:#2eb9b9;color:white;font-size:24px;font-weight:bold;">
                                Library</p>
                            <div class="dropdown" style="width:100%;margin-top:5px;">
                                <button class="btn btn-info dropdown-toggle" data-toggle="dropdown" aria-expanded="false" type="button" style="width:100%;color:white;font-weight:normal;font-size:12px;padding:5px">
                                    <div class="col-md-10 text-center">
                                        <i class="fa fa-search"></i> 
                                        &nbsp; View
                                    </div>    
                                    <div class="col-md-2 text-right">
                                        <span class="caret"></span>
                                    </div>
                                </button>
                                <ul role="menu" class="dropdown-menu dropdown-menu-right">
                                    <li role="presentation"><a href="lib-books.php">Books</a></li>
                                    <li role="presentation"><a href="lib-item.php">Items</a></li>
                                    <li role="presentation"><a href="lib-bb_items.php">Items Borrowed by Staff</a></li>
                                    <li role="presentation"><a href="lib-bb_staff.php">Books Borrowed by Staff</a></li>
                                    <li role="presentation"><a href="lib-bb_student.php">Books Borrowed by Students</a></li>
                                    <li role="presentation"><a href="lib-author.php">Authors</a></li>
                                    <li role="presentation"><a href="lib-publisher.php">Publishers</a></li>
                                    <li role="presentation"><a href="lib-shelf.php">Shelves</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-md-2 col-xs-2">
                        <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                            <p class="text-center" style="color:rgb(3,3,3);background-color:#2eb9b9;color:white;font-size:24px;font-weight:bold;">
                                Procurement</p>
                            <div class="dropdown" style="width:100%;margin-top:5px;">
                                <button class="btn btn-info dropdown-toggle" data-toggle="dropdown" aria-expanded="false" type="button" style="width:100%;color:white;font-weight:normal;font-size:12px;padding:5px">
                                    <div class="col-md-10 text-center">
                                        <i class="fa fa-search"></i> 
                                        &nbsp; View &nbsp;<span class="badge bg-red" style="color:white;" id="StockCounter1"></span>
                                    </div>    
                                    <div class="col-md-2 text-right">
                                        <span class="caret"></span>
                                    </div>
                                </button>
                                <ul role="menu" class="dropdown-menu dropdown-menu-right">
                                    <li role="presentation"><a href="pro-items.php">Items</a></li>
                                    <li role="presentation"><a href="pro-received.php">Received Items</a></li>
                                    <li role="presentation"><a href="pro-os_items.php" title="Out of Stock items">O/S Items  &nbsp;<span class="badge bg-red" id="StockCounter2"></span></a></li>
                                    <li role="presentation"><a href="pro-requisitioned.php">Requisitioned</a></li>
                                    <li role="presentation"><a href="pro-supplier.php">Suppliers</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-md-2 col-xs-2">
                        <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                            <p class="text-center" style="color:rgb(3,3,3);background-color:#2eb9b9;color:white;font-size:24px;font-weight:bold;">
                                Time Tabler</p>
                            <div class="dropdown" style="width:100%;margin-top:5px;">
                                <button class="btn btn-info dropdown-toggle" data-toggle="dropdown" aria-expanded="false" type="button" style="width:100%;color:white;font-weight:normal;font-size:12px;padding:5px">
                                    <div class="col-md-10 text-center">
                                        <i class="fa fa-search"></i> 
                                        &nbsp; View
                                    </div>    
                                    <div class="col-md-2 text-right">
                                        <span class="caret"></span>
                                    </div>
                                </button>
                                <ul role="menu" class="dropdown-menu dropdown-menu-right">
                                    <li role="presentation"><a href="tt-exam.php">Exams (online)</a></li>
                                    <li role="presentation"><a href="tt-ett.php">Exams Time Tables</a></li>
                                    <li role="presentation"><a href="tt-ltt.php">Lectures Time Tables</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>
                
                <div class="col-md-12 col-xs-12"> <br></div>
                
                <div class="col-md-12 col-xs-12">
                    <!--<div class="col-md-2 col-xs-2">
                        <div style="border:1px solid rgb(52,73,94);border-radius:5px;">
                            <p class="text-center" style="color:rgb(3,3,3);background-color:#2eb9b9;color:white;font-size:24px;font-weight:bold;">
                                Students
                            </p>
                            <div class="dropdown" style="width:100%;margin-top:5px;">
                                <button class="btn btn-info dropdown-toggle" data-toggle="dropdown" aria-expanded="false" type="button" style="width:100%;color:white;font-weight:normal;font-size:12px;padding:5px">
                                    <div class="col-md-10 text-center">
                                        <i class="fa fa-search"></i> 
                                        &nbsp; View
                                    </div>    
                                    <div class="col-md-2 text-right">
                                        <span class="caret"></span>
                                    </div>
                                </button>
                                <ul role="menu" class="dropdown-menu dropdown-menu-right">
                                    <li role="presentation"><a href="">Exams Time Tables</a></li>
                                    <li role="presentation"><a href="">Completed Students</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>-->
                </div> 
                <div class="col-md-12 col-xs-12"> <br><br><br></div>
            </div>
    </div>
    <script src="../../../assets/js/jquery.min.js"></script>
    <script src="../../../assets/bootstrap/js/bootstrap.min.js"></script>
    <script src="https://cdn.datatables.net/1.10.15/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.10.15/js/dataTables.bootstrap.min.js"></script>
    <script src="../../../assets/js/ebs-simple-login-form.js"></script>
    <script src="../../../assets/js/JLX-Fixed-Nav-on-Scroll.js"></script>
    <script src="../../../assets/js/Profile-Edit.js"></script>
    <script src="../../../assets/js/Sidebar-Menu.js"></script>
    
    <script type="text/javascript">
            $(document).ready(function(){
            setInterval(function(){
               $("#notificationCounter").load("include/counter_3.php");
                $("#requestCounter").load("include/counter.php");
                $("#expiredCounter").load("include/counter_2.php");
                $("#expiredLeaveCounter").load("include/counter_2_1.php");
                $("#requestLeaveCounter").load("include/counter_4.php");
                $("#StockCounter").load("include/count_stock.php");
                $("#StockCounter1").load("include/count_stock.php");
                $("#StockCounter2").load("include/count_stock.php");
            }, 500); /* time in milliseconds (ie 2 seconds)*/
        });
    </script>
</body>

</html>