<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>SSA Admin | Dashboard</title>
  <!-- Tell the browser to be responsive to screen width -->
  <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  	  <!-- Select2 -->
  <link rel="stylesheet" href="plugins/select2/select2.min.css">
  <link rel="stylesheet" href="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.min.css">
  <!-- Bootstrap 3.3.7 -->
  <link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
  <!-- Font Awesome -->
 <link rel="stylesheet" href="font-awesome-4.7.0/css/font-awesome.min.css">
  <!-- Ionicons -->
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">
  <!-- jvectormap -->
  <link rel="stylesheet" href="plugins/jvectormap/jquery-jvectormap-1.2.2.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="dist/css/AdminLTE.min.css">
  <!-- AdminLTE Skins. Choose a skin from the css/skins
       folder instead of downloading all of them to reduce the load. -->
  <link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">
  <!-- bootstrap wysihtml5 - text editor -->

  <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
  <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
  <!--[if lt IE 9]>
  <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
  <![endif]-->
  

  <!-- daterange picker -->
  <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker.css">
  <!-- bootstrap datepicker -->
  <link rel="stylesheet" href="plugins/datepicker/datepicker3.css">
  <!-- iCheck for checkboxes and radio inputs -->
  <link rel="stylesheet" href="plugins/iCheck/all.css">
  <!-- Bootstrap Color Picker -->
  <link rel="stylesheet" href="plugins/colorpicker/bootstrap-colorpicker.min.css">
  <!-- Bootstrap time Picker -->
  <link rel="stylesheet" href="plugins/timepicker/bootstrap-timepicker.min.css">
	
	  <!-- DataTables -->
  <link rel="stylesheet" href="plugins/datatables/dataTables.bootstrap.css">
  <style>
	.hide-lg{display:none}
	.hide-sm{display:block}
	@media only screen and (max-width:602px){.hide-lg{display:block;}.hide-sm{display:none;}}
  </style>
</head>
<?php include("../dbconnection/dbconnection.php");$name='';if(isset($_SESSION["id"])){  $user=strtolower($_SESSION['type']); if($user==="admin"){$id=$_SESSION['id'];include("../steam_functions/steam_functions.php");$team=(staff_team($connect));$loggedin=staff_loggedin($id,$connect);$students=few_students($connect);}else if($user=="staff"){header("location:../pages/staff_login.php");}else{ header("location:../pages/staff_login.php"); }}else{header("location:../pages/staff_login.php");}

foreach($loggedin as $row){
	
	$staff_name=ucwords(strtolower($row["fname"]." ".$row["other_names"]));
	$gender=$row["gender"];
	$profile=$row["photo"];
if(empty($row["photo"]) or $row["photo"]==''){
						if($row["gender"]=="male"){  $profile='../../images/img_avatar3.png';}else{  $profile='../../images/img_avatar5.png';}
					}else{
					$profile="pages/".$row["photo"];
					}
}
?>
<body class="hold-transition  skin-green-light sidebar-mini">
<div class="wrapper">

  <header class="main-header">

    <!-- Logo -->
    <a href="javascript:void(0)" class="logo">
      <!-- mini logo for sidebar mini 50x50 pixels -->
      <span class="logo-mini"><b>S</b>SA</span>
      <!-- logo for regular state and mobile devices -->
      <span class="logo-lg"><b>STEAM</b> Save Africa</span>
    </a>

    <!-- Header Navbar: style can be found in header.less -->
    <nav class="navbar navbar-static-top">
      <!-- Sidebar toggle button-->
      <a href="#" class="sidebar-toggle" data-toggle="offcanvas" role="button"></a>
      <!-- Navbar Right Menu -->
      <div class="navbar-custom-menu">
        <ul class="nav navbar-nav">
          <!-- Messages: style can be found in dropdown.less-->
          <li class="dropdown messages-menu">
            <a href="#" class="dropdown-toggle" data-toggle="dropdown">
              <i class="fa fa-envelope-o"></i>
              <span class="label bg-aqua">4</span>
            </a>
            <ul class="dropdown-menu">
              <li class="header">You have 4 messages</li>
              <li>
                <!-- inner menu: contains the actual data -->
                <ul class="menu">
                  <li><!-- start message -->
                    <a href="#">
                      <div class="pull-left">
                        <img src="dist/img/user2-160x160.jpg" class="img-circle" alt="User Image">
                      </div>
                      <h4>
                        Support Team
                        <small><i class="fa fa-clock-o"></i> 5 mins</small>
                      </h4>
                      <p>Why not buy a new awesome theme?</p>
                    </a>
                  </li>
                  <!-- end message -->
                  <li>
                    <a href="#">
                      <div class="pull-left">
                        <img src="dist/img/user3-128x128.jpg" class="img-circle" alt="User Image">
                      </div>
                      <h4>
                        AdminLTE Design Team
                        <small><i class="fa fa-clock-o"></i> 2 hours</small>
                      </h4>
                      <p>Why not buy a new awesome theme?</p>
                    </a>
                  </li>
                  <li>
                    <a href="#">
                      <div class="pull-left">
                        <img src="dist/img/user4-128x128.jpg" class="img-circle" alt="User Image">
                      </div>
                      <h4>
                        Developers
                        <small><i class="fa fa-clock-o"></i> Today</small>
                      </h4>
                      <p>Why not buy a new awesome theme?</p>
                    </a>
                  </li>
                  <li>
                    <a href="#">
                      <div class="pull-left">
                        <img src="dist/img/user3-128x128.jpg" class="img-circle" alt="User Image">
                      </div>
                      <h4>
                        Sales Department
                        <small><i class="fa fa-clock-o"></i> Yesterday</small>
                      </h4>
                      <p>Why not buy a new awesome theme?</p>
                    </a>
                  </li>
                  <li>
                    <a href="#">
                      <div class="pull-left">
                        <img src="dist/img/user4-128x128.jpg" class="img-circle" alt="User Image">
                      </div>
                      <h4>
                        Reviewers
                        <small><i class="fa fa-clock-o"></i> 2 days</small>
                      </h4>
                      <p>Why not buy a new awesome theme?</p>
                    </a>
                  </li>
                </ul>
              </li>
              <li class="footer"><a href="#">See All Messages</a></li>
            </ul>
          </li>
          <!-- Notifications: style can be found in dropdown.less -->
          <li class="dropdown notifications-menu">
            <a href="#" class="dropdown-toggle" data-toggle="dropdown">
              <i class="fa fa-bell-o"></i>
              <span class="label label-warning">10</span>
            </a>
            <ul class="dropdown-menu">
              <li class="header">You have 10 notifications</li>
              <li>
                <!-- inner menu: contains the actual data -->
                <ul class="menu">
                  <li>
                    <a href="#">
                      <i class="fa fa-users text-aqua"></i> 5 new members joined today
                    </a>
                  </li>
                  <li>
                    <a href="#">
                      <i class="fa fa-warning text-yellow"></i> Very long description here that may not fit into the
                      page and may cause design problems
                    </a>
                  </li>
                  <li>
                    <a href="#">
                      <i class="fa fa-users text-red"></i> 5 new members joined
                    </a>
                  </li>
                  <li>
                    <a href="#">
                      <i class="fa fa-shopping-cart text-green"></i> 25 sales made
                    </a>
                  </li>
                  <li>
                    <a href="#">
                      <i class="fa fa-user text-red"></i> You changed your username
                    </a>
                  </li>
                </ul>
              </li>
              <li class="footer"><a href="#">View all</a></li>
            </ul>
          </li>
          <!-- Tasks: style can be found in dropdown.less -->
          <li class="dropdown tasks-menu">
            <a href="#" class="dropdown-toggle" data-toggle="dropdown">
              <i class="fa fa-flag-o"></i>
              <span class="label label-danger">9</span>
            </a>
            <ul class="dropdown-menu">
              <li class="header">You have 9 tasks</li>
              <li>
                <!-- inner menu: contains the actual data -->
                <ul class="menu">
                  <li><!-- Task item -->
                    <a href="#">
                      <h3>
                        Design some buttons
                        <small class="pull-right">20%</small>
                      </h3>
                      <div class="progress xs">
                        <div class="progress-bar progress-bar-aqua" style="width: 20%" role="progressbar" aria-valuenow="20" aria-valuemin="0" aria-valuemax="100">
                          <span class="sr-only">20% Complete</span>
                        </div>
                      </div>
                    </a>
                  </li>
                  <!-- end task item -->
                  <li><!-- Task item -->
                    <a href="#">
                      <h3>
                        Create a nice theme
                        <small class="pull-right">40%</small>
                      </h3>
                      <div class="progress xs">
                        <div class="progress-bar progress-bar-green" style="width: 40%" role="progressbar" aria-valuenow="20" aria-valuemin="0" aria-valuemax="100">
                          <span class="sr-only">40% Complete</span>
                        </div>
                      </div>
                    </a>
                  </li>
                  <!-- end task item -->
                  <li><!-- Task item -->
                    <a href="#">
                      <h3>
                        Some task I need to do
                        <small class="pull-right">60%</small>
                      </h3>
                      <div class="progress xs">
                        <div class="progress-bar progress-bar-red" style="width: 60%" role="progressbar" aria-valuenow="20" aria-valuemin="0" aria-valuemax="100">
                          <span class="sr-only">60% Complete</span>
                        </div>
                      </div>
                    </a>
                  </li>
                  <!-- end task item -->
                  <li><!-- Task item -->
                    <a href="#">
                      <h3>
                        Make beautiful transitions
                        <small class="pull-right">80%</small>
                      </h3>
                      <div class="progress xs">
                        <div class="progress-bar progress-bar-yellow" style="width: 80%" role="progressbar" aria-valuenow="20" aria-valuemin="0" aria-valuemax="100">
                          <span class="sr-only">80% Complete</span>
                        </div>
                      </div>
                    </a>
                  </li>
                  <!-- end task item -->
                </ul>
              </li>
              <li class="footer">
                <a href="#">View all tasks</a>
              </li>
            </ul>
          </li>
          <!-- User Account: style can be found in dropdown.less -->
          <li class="dropdown user user-menu">
            <a href="#" class="dropdown-toggle" data-toggle="dropdown">
              <img src="<?php echo $profile;?>" class="user-image" alt="User Image">
              <span class="hidden-xs"> <?php echo $staff_name;?></span>
            </a>
            <ul class="dropdown-menu">
              <!-- User image -->
              <li class="user-header">
                <img src="<?php echo $profile;?>" class="img-circle" alt="User Image">

                <p>
                  <?php echo $staff_name;?>
                  <small><?php echo date("M Y",$row["date"]);?></small>
                </p>
              </li>
              
              <!-- Menu Footer-->
              <li class="user-footer">
                <div class="pull-left">
                  <a  href="pages/profile/profile.php" class="btn btn-default btn-flat">Profile</a>
                </div>
                <div class="pull-right">
                  <a  href="logout.php"  class="btn btn-default btn-flat">Sign out</a>
                </div>
              </li>
            </ul>
          </li>
          <!-- Control Sidebar Toggle Button -->
          <li>
            <a href="pages/settings/settings.php" ><i class="fa fa-gears"></i></a>
          </li>
        </ul>
      </div>

    </nav>
  </header>
  <!-- Left side column. contains the logo and sidebar -->
  <aside class="main-sidebar" style='position:'>
    <!-- sidebar: style can be found in sidebar.less -->
    <section class="sidebar">
      <!-- Sidebar user panel -->
      <div class="user-panel">
        <div class="pull-left image">
          <img src="<?php echo $profile;?>" class="img-circle" alt="User Image">
        </div>
        <div class="pull-left info">
          <p><?php echo $staff_name;?></p>
          <a href="#"><i class="fa fa-circle text-success"></i> Online</a>
        </div>
      </div>
      <!-- search form -->
      <form action="#" method="get" class="sidebar-form">
        <div class="input-group">
          <input type="text" name="q" class="form-control" placeholder="Search...">
              <span class="input-group-btn">
                <button type="submit" name="search" id="search-btn" class="btn btn-flat"><i class="fa fa-search"></i>
                </button>
              </span>
        </div>
      </form>
      <!-- /.search form -->
      <!-- sidebar menu: : style can be found in sidebar.less -->
      <ul class="sidebar-menu">
        <li class="header">MAIN NAVIGATION</li>
     
		<li >
          <a class='active' href="javascript:void(0)" onclick="document.location='../'">
            <i class="fa fa-home"></i> <span>Home</span>
            
          </a>
        </li>
		     <li class="active">
          <a class='active' href="javascript:void(0)" onclick="get_element('dashboard')">
            <i class="fa fa-dashboard"></i> <span>Dashboard</span>
            
          </a>
        </li> 
		
        <li class="treeview">
          <a href="#">
            <i class="fa fa-user-o"></i> <span>Users</span>
            <span class="pull-right-container">
              <i class="fa fa-angle-left pull-right"></i>
            </span>
          </a>
          <ul class="treeview-menu">
            <li><a href="pages/users/staff.php" ><i class="fa fa-circle-o"></i>Staff Members</a></li>
            <li><a  href="pages/users/students.php" ><i class="fa fa-circle-o"></i> Students</a></li>
            <li><a href="pages/users/subscribers.php" ><i class="fa fa-circle-o"></i>Subscribers</a></li>
            <li><a href="pages/tables/data.html"><i class="fa fa-circle-o"></i>Other Users</a></li>
          </ul>
        </li>
		     <li class="">
          <a href="pages/services/services.php" >
            <i class="fa fa-folder"></i> <span>Services</span>
            <span class="pull-right-container hide">
              <i class="fa fa-angle-left pull-right"></i>
            </span>
          </a>
		 </li>

       
		     <li>
          <a href="javascript:void(0)" onclick="get_element('pages/notes/editor.php')">
            <i class="fa fa-edit"></i> <span>NOTES</span>
            <span class="pull-right-container">
              <small class="label pull-right bg-green">new</small>
            </span>
          </a>
        </li>
		
		
		
		        <li class="treeview">
          <a href="#">
            <i class="fa fa-share"></i> <span>Posts</span>
            <span class="pull-right-container">
              <i class="fa fa-angle-left pull-right"></i>
            </span>
          </a>
          <ul class="treeview-menu">
            <li><a href="#"><i class="fa fa-circle-o"></i> Level One</a></li>
            <li>
              <a href="#"><i class="fa fa-circle-o"></i> Level One
                <span class="pull-right-container">
                  <i class="fa fa-angle-left pull-right"></i>
                </span>
              </a>
              <ul class="treeview-menu">
                <li><a href="#"><i class="fa fa-circle-o"></i> Level Two</a></li>
                <li>
                  <a href="#"><i class="fa fa-circle-o"></i> Level Two
                    <span class="pull-right-container">
                      <i class="fa fa-angle-left pull-right"></i>
                    </span>
                  </a>
                  <ul class="treeview-menu">
                    <li><a href="#"><i class="fa fa-circle-o"></i> Level Three</a></li>
                    <li><a href="#"><i class="fa fa-circle-o"></i> Level Three</a></li>
                  </ul>
                </li>
              </ul>
            </li>
            <li><a href="#"><i class="fa fa-circle-o"></i> Level One</a></li>
          </ul>
        </li>
		
		   
		<li>
          <a href="pages/gallery/gallery.php">
            <i class="fa fa-edit"></i> <span>GALLERY</span>
            <span class="pull-right-container">
              <small class="label pull-right bg-green">new</small>
            </span>
          </a>
        </li>
		
        <li>
          <a href="pages/events/events.php" >
            <i class="fa fa-calendar"></i> <span>Events</span>
            <span class="pull-right-container">
              <small class="label pull-right bg-purple">3</small>
              <small class="label pull-right bg-blue">17</small>
            </span>
          </a>
        </li>      

		<li>
          <a href="pages/calendar.html">
            <i class="fa fa-flag-o"></i> <span>Tasks</span>
            <span class="pull-right-container">
              <small class="label pull-right bg-red">17</small>
            </span>
          </a>
        </li>
        <li>
          <a href="pages/mailbox/mailbox.php" >
            <i class="fa fa-envelope"></i> <span>Mailbox</span>
            <span class="pull-right-container">
              <small class="label pull-right bg-yellow">12</small>
            </span>
          </a>
        </li>
        <li>
          <a href="pages/chatbox/chatbox.php" >
            <i class="fa fa-envelope-o"></i> <span>Chatbox</span>
            <span class="pull-right-container">
              <small class="label pull-right bg-green">5</small>
            </span>
          </a>
        </li>
   
	 <li>
          <a href="pages/widgets.html">
            <i class="fa fa-bell-o"></i> <span>Notifications</span>
            <span class="pull-right-container">
              <small class="label pull-right bg-green">new</small>
            </span>
          </a>
        </li> 
		
        <li class='header' style='border-bottom:solid 0px black'>Account</a></li>
		    <li><a href="pages/profile/profile.php" ><i class="fa fa-adjust"></i> <span>Profle</span></a></li>
		    <li><a href="pages/examples/login.html"><i class="fa fa-key"></i><span>Login</span></a></li>
            <li><a href="logout.php"><i class="fa fa-sign-out"></i> <span>Sign Out</span></a></li>
            <li><a href="pages/settings/settings.php" ><i class="fa fa-wrench"></i> <span>Settings</span></a></li>
           
      </ul>
    </section>
    <!-- /.sidebar -->
  </aside>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper"  style='min-height:auto'>
	<div class="" id='dashboard'>
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <h1>
        Dashboard
        <small>Admin</small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="#" class='active'><i class="fa fa-dashboard"></i> Dashboard</a></li>
      </ol>
    </section>

    <!-- Main content -->
    <section class="content" style=''>
      
      <!-- Small boxes (Stat box) -->
      <div class="row" style=''>
        <div class="col-lg-3 col-xs-6">
          <!-- small box -->
          <div class="small-box bg-aqua">
            <div class="inner">
              <h3><?php echo count(services($connect));?></h3>

              <p>SERVICES</p>
            </div>
            <div class="icon">
              <i class="ion ion-bag"></i>
            </div>
            <a href="pages/services/services.php"  class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
          </div>
        </div>
        <!-- ./col -->
        <div class="col-lg-3 col-xs-6">
          <!-- small box -->
          <div class="small-box bg-green">
            <div class="inner">
              <h3><?php echo $count=count($team);?><sup style="font-size: 20px"></sup></h3>

              <p>STAFF MEMBERS</p>
            </div>
            <div class="icon">
              <i class="ion ion-stats-bars"></i>
            </div>
            <a href="pages/users/staff.php" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
          </div>
        </div>
        <!-- ./col -->
        <div class="col-lg-3 col-xs-6">
          <!-- small box -->
          <div class="small-box bg-yellow">
            <div class="inner">
              <h3><?php echo count(students($connect));?></h3>

              <p>STUDENTS</p>
            </div>
            <div class="icon">
              <i class="ion ion-person-add"></i>
            </div>
            <a href="pages/users/students.php"  class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
          </div>
        </div>
        <!-- ./col -->
        <div class="col-lg-3 col-xs-6">
          <!-- small box -->
          <div class="small-box bg-red">
            <div class="inner">
              <h3><?php echo count(subscribers($connect));?></h3>

              <p>Subscribers</p>
            </div>
            <div class="icon">
              <i class="ion ion-pie-graph"></i>
            </div>
            <a href="pages/users/subscribers.php" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
          </div>
        </div>
        <!-- ./col -->
      </div>
      <!-- /.row -->
      <!-- Main row -->
      <div class="row" style='display:table;'>
        <!-- Left col -->
        <div class="col-md-12">

          <div class="row">
		      <div class="col-md-6 ">
              <!-- USERS LIST -->
              <div class="box box-danger">
                <div class="box-header with-border">
                  <h3 class="box-title">Staff Members</h3>

                  <div class="box-tools pull-right">
                    <span class="label label-success"><?php echo $count=count($team);?> Members</span>
                    <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i>
                    </button>
                  </div>
                </div>
                <!-- /.box-header -->
                <div class="box-body no-padding">
                  <ul class="users-list clearfix">
					<?php $count=count($team);
					// do{
						foreach($team as $row){
							 $name=ucwords($row["fname"]." ".$row["other_names"]);
							  $rank=ucwords($row["rank"]);
							?>
					<li>
                      <img src="../images/img_avatar3.png" alt="User Image" style='max-height:128px;'>
                      <a class="users-list-name" href="#"><?php echo $name;?></a>
                      <span class="users-list-date" style='min-height:35px'><?php echo $rank;?></span>
                    </li>
						<?php }		?>	
					
                  </ul>
                  <!-- /.users-list -->
                </div>
                <!-- /.box-body -->
					<?php if($count>8){;?>
                <div class="box-footer text-center">
                  <a href="javascript:void(0)" class="uppercase">View All Staff</a>
                </div>
					<?php }?>
                <!-- /.box-footer -->
              </div>
              <!--/.box -->
            </div>
            <!-- /.col -->
		  		      <div class="col-md-6 ">
              <!-- USERS LIST -->
              <div class="box box-danger">
                <div class="box-header with-border">
                  <h3 class="box-title">Students</h3>

                  <div class="box-tools pull-right">
                    <span class="label label-danger"><?php echo count($students);?>  Members</span>
                    <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i>
                    </button>
                  </div>
                </div>
                <!-- /.box-header -->
                <div class="box-body no-padding">
                  <ul class="users-list clearfix">
        					<?php $count=count($students);
					// do{
						foreach($students as $row){
							 $name=ucwords($row["fname"]." ".$row["lname"]);
							  $date=date("d-m-Y",$row["date"]);
							?>
					<li>
                      <img src="../images/img_avatar3.png" alt="User Image" style='max-height:128px;'>
                      <a class="users-list-name" href="#"><?php echo $name;?></a>
                      <span class="users-list-date" style='min-height:35px'><?php echo $date;?></span>
                    </li>
						<?php 	}		?>	
                  </ul>
                  <!-- /.users-list -->
                </div>
                <!-- /.box-body -->
					<?php if($count>8){ ?>
                <div class="box-footer text-center">
                  <a href="javascript:void(0)" class="uppercase">View All Students</a>
                </div>
					<?php }?>
                <!-- /.box-footer -->
              </div>
              <!--/.box -->
            </div>
            <!-- /.col -->
		  
		  
            <div class="col-md-6 hide">
						 <!-- Calendar -->
				  <div class="box box-solid bg-green-gradient ">
					<div class="box-header">
					  <i class="fa fa-calendar"></i>

					  <h3 class="box-title">Events</h3>
					  <!-- tools box -->
					  <div class="pull-right box-tools">
						<!-- button with a dropdown -->
						<div class="btn-group">
						  <button type="button" class="btn btn-success btn-sm dropdown-toggle" data-toggle="dropdown">
							<i class="fa fa-bars"></i></button>
						  <ul class="dropdown-menu pull-right" role="menu">
							<li><a href="#">Add new event</a></li>
							<li><a href="#">Clear events</a></li>
							<li class="divider"></li>
							<li><a href="#">View calendar</a></li>
						  </ul>
						</div>
						<button type="button" class="btn btn-success btn-sm" data-widget="collapse"><i class="fa fa-minus"></i>
						</button>
					  </div>
					  <!-- /. tools -->
					</div>
					<!-- /.box-header -->
					<div class="box-body no-padding">
					  <!--The calendar -->
					  <div id="calendar" style="width: 100%"></div>
					</div>
					<!-- /.box-body -->
					<div class="box-footer text-black">
					  <div class="row">
						<div class="col-sm-6">
						  <!-- Progress bars -->
						  <div class="clearfix">
							<span class="pull-left">Task #1</span>
							<small class="pull-right">90%</small>
						  </div>
						  <div class="progress xs">
							<div class="progress-bar progress-bar-green" style="width: 90%;"></div>
						  </div>

						  <div class="clearfix">
							<span class="pull-left">Task #2</span>
							<small class="pull-right">70%</small>
						  </div>
						  <div class="progress xs">
							<div class="progress-bar progress-bar-green" style="width: 70%;"></div>
						  </div>
						</div>
						<!-- /.col -->
						<div class="col-sm-6">
						  <div class="clearfix">
							<span class="pull-left">Task #3</span>
							<small class="pull-right">60%</small>
						  </div>
						  <div class="progress xs">
							<div class="progress-bar progress-bar-green" style="width: 60%;"></div>
						  </div>

						  <div class="clearfix">
							<span class="pull-left">Task #4</span>
							<small class="pull-right">40%</small>
						  </div>
						  <div class="progress xs">
							<div class="progress-bar progress-bar-green" style="width: 40%;"></div>
						  </div>
						</div>
						<!-- /.col -->
					  </div>
					  <!-- /.row -->
					</div>
				  </div>
				  <!-- /.box -->
            </div>
            <!-- /.col -->		  
            <div class="col-md-6 hide">
						 <!-- Calendar -->
				  <div class="box box-solid bg-yellow-gradient ">
					<div class="box-header">
					  <i class="fa fa-calendar"></i>

					  <h3 class="box-title">Tasks</h3>
					  <!-- tools box -->
					  <div class="pull-right box-tools">
						<!-- button with a dropdown -->
						<div class="btn-group">
						  <button type="button" class="btn btn-warning btn-sm dropdown-toggle" data-toggle="dropdown">
							<i class="fa fa-bars"></i></button>
						  <ul class="dropdown-menu pull-right" role="menu">
							<li><a href="#">Add new event</a></li>
							<li><a href="#">Clear events</a></li>
							<li class="divider"></li>
							<li><a href="#">View calendar</a></li>
						  </ul>
						</div>
						<button type="button" class="btn btn-warning btn-sm" data-widget="collapse"><i class="fa fa-minus"></i>
						</button>
					  </div>
					  <!-- /. tools -->
					</div>
					<!-- /.box-header -->
					<div class="box-body no-padding">
					  <!--The calendar -->
					  <div id="calendar" style="width: 100%"></div>
					</div>
					<!-- /.box-body -->
					<div class="box-footer text-black">
					  <div class="row">
						<div class="col-sm-6">
						  <!-- Progress bars -->
						  <div class="clearfix">
							<span class="pull-left">Task #1</span>
							<small class="pull-right">90%</small>
						  </div>
						  <div class="progress xs">
							<div class="progress-bar progress-bar-yellow" style="width: 90%;"></div>
						  </div>

						  <div class="clearfix">
							<span class="pull-left">Task #2</span>
							<small class="pull-right">70%</small>
						  </div>
						  <div class="progress xs">
							<div class="progress-bar progress-bar-yellow" style="width: 70%;"></div>
						  </div>
						</div>
						<!-- /.col -->
						<div class="col-sm-6">
						  <div class="clearfix">
							<span class="pull-left">Task #3</span>
							<small class="pull-right">60%</small>
						  </div>
						  <div class="progress xs">
							<div class="progress-bar progress-bar-yellow" style="width: 60%;"></div>
						  </div>

						  <div class="clearfix">
							<span class="pull-left">Task #4</span>
							<small class="pull-right">40%</small>
						  </div>
						  <div class="progress xs">
							<div class="progress-bar progress-bar-yellow" style="width: 40%;"></div>
						  </div>
						</div>
						<!-- /.col -->
					  </div>
					  <!-- /.row -->
					</div>
				  </div>
				  <!-- /.box -->
            </div>
            <!-- /.col -->

			
			

		

	
        
          </div>
          <!-- /.row -->

		  
		  
	<div class="row hide">
	
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box bg-aqua">
            <span class="info-box-icon"><i class="fa fa-bookmark-o"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">Bookmarks</span>
              <span class="info-box-number">41,410</span>

              <div class="progress">
                <div class="progress-bar" style="width: 70%"></div>
              </div>
                  <span class="progress-description">
                    70% Increase in 30 Days
                  </span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
		<!-- /.col -->
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box bg-green">
            <span class="info-box-icon"><i class="fa fa-thumbs-o-up"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">Likes</span>
              <span class="info-box-number">41,410</span>

              <div class="progress">
                <div class="progress-bar" style="width: 70%"></div>
              </div>
                  <span class="progress-description">
                    70% Increase in 30 Days
                  </span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box bg-yellow">
            <span class="info-box-icon"><i class="fa fa-calendar"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">Events</span>
              <span class="info-box-number">41,410</span>

              <div class="progress">
                <div class="progress-bar" style="width: 70%"></div>
              </div>
                  <span class="progress-description">
                    70% Increase in 30 Days
                  </span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box bg-red">
            <span class="info-box-icon"><i class="fa fa-comments-o"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">Comments</span>
              <span class="info-box-number">41,410</span>

              <div class="progress">
                <div class="progress-bar" style="width: 70%"></div>
              </div>
                  <span class="progress-description">
                    70% Increase in 30 Days
                  </span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
		
        </div>
		  
		  
		        <div class="row hide">
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box">
            <span class="info-box-icon bg-aqua"><i class="fa fa-envelope-o"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">Messages</span>
              <span class="info-box-number">1,410</span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box">
            <span class="info-box-icon bg-green"><i class="fa fa-flag-o"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">Bookmarks</span>
              <span class="info-box-number">410</span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box">
            <span class="info-box-icon bg-yellow"><i class="fa fa-files-o"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">Uploads</span>
              <span class="info-box-number">13,648</span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box">
            <span class="info-box-icon bg-red"><i class="fa fa-star-o"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">Subscribers</span>
              <span class="info-box-number">93,139</span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
      </div>
      <!-- /.row -->

      <!-- =========================================================== -->		       

			<?php
									
										foreach(school_details($connect) as $row){
											$sch_id=$row["id"];
											$sch=$row["name"];
											$mission=$row["mission"];
											$vision=$row["vision"];
											$about=$row["about"];
											$tel=$row["tel"];
											$whatsapp=$row["whatsapp"];
											$email=$row["email"];
											$fb=$row["fb"];
											$twitter=$row["twitter"];
											$ig=$row["ig"];
											$ln=$row["ln"];
											$youtube=$row["youtube"];
										}
			
					?>
	  <div class="row">
	    <div class="box-header with-border">
              <h3 class="box-title">Contacts</h3>
              <!-- /.box-tools -->
            </div>
		
        <div class="col-md-4 col-sm-6 col-xs-12">
          <div class="info-box bg-aqua">
            <span class="info-box-icon"><i class="fa fa-phone"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">Phone</span>
				<span class=" info-box-number"> <?php echo $tel;?></span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
		 <div class="col-md-4 col-sm-6 col-xs-12">
          <div class="info-box bg-green">
            <span class="info-box-icon"><i class="fa fa-whatsapp"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">whatsapp</span>
              <span class="info-box-number"><?php echo $whatsapp;?></span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
		
        <div class="col-md-4 col-sm-6 col-xs-12">
          <div class="info-box bg-yellow">
            <span class="info-box-icon "><i class="fa fa-envelope-o"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">email</span>
              <span class="info-box-number progress-description"><?php echo $email;?></span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
      </div>
      <!-- /.row -->

      <!-- =========================================================== -->
	
	
		
	  <div class="row">
	    <div class="box-header with-border">
              <h3 class="box-title">Social Media</h3>
              <!-- /.box-tools -->
            </div>
			<?php if($fb!=""){?>
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box btn-facebook ">
            <span class="info-box-icon"><i class="fa fa-facebook"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">Facebook</span>
				<span class="progress-description"> <?php echo $fb;?></span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
			<?php
			}
		if($twitter!=""){
		
		?>
		 <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box btn-twitter">
            <span class="info-box-icon"><i class="fa fa-twitter"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">Twitter</span>
              <span class="info-box-number"><?php echo $twitter;?></span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
		<?php
			}
		if($ln!=""){
		
		?>
		
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box btn-linkedin">
            <span class="info-box-icon "><i class="fa fa-linkedin"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">linkedin</span>
              <span class="info-box-number"><?php echo $ln;?></span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
		<?php
			}
		if($youtube!=""){
		
		?>
        <div class="col-md-3 col-sm-6 col-xs-12 hide">
          <div class="info-box btn-google">
            <span class="info-box-icon"><i class="fa fa-youtube"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">youtube</span>
              <span class="info-box-number"><?php echo $youtube;?></span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->  
<?php
			}
		if($ig!=""){
		
		?>		
        <div class="col-md-3 col-sm-6 col-xs-12">
          <div class="info-box btn-instagram">
            <span class="info-box-icon"><i class="fa fa-instagram"></i></span>

            <div class="info-box-content">
              <span class="info-box-text">instagram</span>
              <span class="info-box-number"><?php echo $ig;?></span>
            </div>
            <!-- /.info-box-content -->
          </div>
          <!-- /.info-box -->
        </div>
        <!-- /.col -->
		
		<?php
		}
		?>
		
      </div>
      <!-- /.row -->

      <!-- =========================================================== -->
	  
	  
	  
	  	  <div class="row">
			  <div class="col-md-6 ">
				  <!-- AREA CHART -->
				  <div class="box box-primary">
					<div class="box-header with-border ">
					  <h3 class="box-title">Mission</h3>
					</div>
					<div class="box-body chart-responsive">
					<p><?php echo $mission;?></p>
					</div>
					<!-- /.box-body -->
										    <!-- /.box-footer -->
					<div class="box-footer">
					</div>
				  </div>
				  <!-- /.box -->
			   </div>
		  	
			<div class="col-md-6 ">
				  <!-- AREA CHART -->
				  <div class="box box-warning">
					<div class="box-header with-border ">
					  <h3 class="box-title">Vision</h3>
					</div>
					<div class="box-body chart-responsive">
					<p><?php echo $vision;?></p></div>
					<!-- /.box-body -->
										    <!-- /.box-footer -->
					<div class="box-footer">
					</div>
				  </div>
				  <!-- /.box -->
			 </div>
			 
		  			<div class="col-md-6 ">
				  <!-- AREA CHART -->
				  <div class="box box-danger">
					<div class="box-header with-border ">
					  <h3 class="box-title">About Us</h3>
					</div>
					<div class="box-body chart-responsive">
					<p><?php echo $about;?></p>
						</div>
					<!-- /.box-body -->
					    <!-- /.box-footer -->
					<div class="box-footer">
					</div>
            <!-- /.box-footer -->
				  </div>
				  <!-- /.box -->
			 </div>
		  

		  </div>
      <!-- /.row -->

      <!-- =========================================================== -->
	  
		  
		  

        </div>
        <!-- /.col -->
		
		
     

      </div>
      <!-- /.row -->
    </section>
  <!-- /.content -->

  </div>
      <!-- /.Dashboard -->
	  
	  <div class="" id='data_load'>
	  
  
	  </div>
	  <!-- /.content-wrapper --> 
  </div>
  <!-- /.content-wrapper -->

 <footer class="main-footer">
    <div class="pull-right hidden-xs">
      <b>Version</b> 2.3.12
    </div>
    <strong>Copyright &copy; <?php echo date("Y",time());?> <a href="http://mabnets.com"> Mabnets Technologies </a>.</strong> All rights reserved.
  </footer>



  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-light">
    <!-- Create the tabs -->
    <ul class="nav nav-tabs nav-justified control-sidebar-tabs">
      <li><a href="#control-sidebar-home-tab" data-toggle="tab"><i class="fa fa-home"></i></a></li>
      <li><a href="#control-sidebar-settings-tab" data-toggle="tab"><i class="fa fa-gears"></i></a></li>
    </ul>
    <!-- Tab panes -->
    <div class="tab-content">
      <!-- Home tab content -->
      <div class="tab-pane" id="control-sidebar-home-tab">
        <h3 class="control-sidebar-heading">Recent Activity</h3>
        <ul class="control-sidebar-menu">
          <li>
            <a href="javascript:void(0)">
              <i class="menu-icon fa fa-birthday-cake bg-red"></i>

              <div class="menu-info">
                <h4 class="control-sidebar-subheading">Langdon's Birthday</h4>

                <p>Will be 23 on April 24th</p>
              </div>
            </a>
          </li>
          <li>
            <a href="javascript:void(0)">
              <i class="menu-icon fa fa-user bg-yellow"></i>

              <div class="menu-info">
                <h4 class="control-sidebar-subheading">Frodo Updated His Profile</h4>

                <p>New phone +1(800)555-1234</p>
              </div>
            </a>
          </li>
          <li>
            <a href="javascript:void(0)">
              <i class="menu-icon fa fa-envelope-o bg-light-blue"></i>

              <div class="menu-info">
                <h4 class="control-sidebar-subheading">Nora Joined Mailing List</h4>

                <p>nora@example.com</p>
              </div>
            </a>
          </li>
          <li>
            <a href="javascript:void(0)">
              <i class="menu-icon fa fa-file-code-o bg-green"></i>

              <div class="menu-info">
                <h4 class="control-sidebar-subheading">Cron Job 254 Executed</h4>

                <p>Execution time 5 seconds</p>
              </div>
            </a>
          </li>
        </ul>
        <!-- /.control-sidebar-menu -->

        <h3 class="control-sidebar-heading">Tasks Progress</h3>
        <ul class="control-sidebar-menu">
          <li>
            <a href="javascript:void(0)">
              <h4 class="control-sidebar-subheading">
                Custom Template Design
                <span class="label label-danger pull-right">70%</span>
              </h4>

              <div class="progress progress-xxs">
                <div class="progress-bar progress-bar-danger" style="width: 70%"></div>
              </div>
            </a>
          </li>
          <li>
            <a href="javascript:void(0)">
              <h4 class="control-sidebar-subheading">
                Update Resume
                <span class="label label-success pull-right">95%</span>
              </h4>

              <div class="progress progress-xxs">
                <div class="progress-bar progress-bar-success" style="width: 95%"></div>
              </div>
            </a>
          </li>
          <li>
            <a href="javascript:void(0)">
              <h4 class="control-sidebar-subheading">
                Laravel Integration
                <span class="label label-warning pull-right">50%</span>
              </h4>

              <div class="progress progress-xxs">
                <div class="progress-bar progress-bar-warning" style="width: 50%"></div>
              </div>
            </a>
          </li>
          <li>
            <a href="javascript:void(0)">
              <h4 class="control-sidebar-subheading">
                Back End Framework
                <span class="label label-primary pull-right">68%</span>
              </h4>

              <div class="progress progress-xxs">
                <div class="progress-bar progress-bar-primary" style="width: 68%"></div>
              </div>
            </a>
          </li>
        </ul>
        <!-- /.control-sidebar-menu -->

      </div>
      <!-- /.tab-pane -->

      <!-- Settings tab content -->
      <div class="tab-pane" id="control-sidebar-settings-tab">
        <form method="post">
          <h3 class="control-sidebar-heading">General Settings</h3>

          <div class="form-group">
            <label class="control-sidebar-subheading">
              Report panel usage
              <input type="checkbox" class="pull-right" checked>
            </label>

            <p>
              Some information about this general settings option
            </p>
          </div>
          <!-- /.form-group -->

          <div class="form-group">
            <label class="control-sidebar-subheading">
              Allow mail redirect
              <input type="checkbox" class="pull-right" checked>
            </label>

            <p>
              Other sets of options are available
            </p>
          </div>
          <!-- /.form-group -->

          <div class="form-group">
            <label class="control-sidebar-subheading">
              Expose author name in posts
              <input type="checkbox" class="pull-right" checked>
            </label>

            <p>
              Allow the user to show his name in blog posts
            </p>
          </div>
          <!-- /.form-group -->

          <h3 class="control-sidebar-heading">Chat Settings</h3>

          <div class="form-group">
            <label class="control-sidebar-subheading">
              Show me as online
              <input type="checkbox" class="pull-right" checked>
            </label>
          </div>
          <!-- /.form-group -->

          <div class="form-group">
            <label class="control-sidebar-subheading">
              Turn off notifications
              <input type="checkbox" class="pull-right">
            </label>
          </div>
          <!-- /.form-group -->

          <div class="form-group">
            <label class="control-sidebar-subheading">
              Delete chat history
              <a href="javascript:void(0)" class="text-red pull-right"><i class="fa fa-trash-o"></i></a>
            </label>
          </div>
          <!-- /.form-group -->
        </form>
      </div>
      <!-- /.tab-pane -->
    </div>
  </aside>
  <!-- /.control-sidebar -->
  <!-- Add the sidebar's background. This div must be placed
       immediately after the control sidebar -->

  <div class="control-sidebar-bg"></div> 
  
 
</div>
<!-- ./wrapper -->


<!-- jQuery 2.2.3 -->
<script src="plugins/jQuery/jquery-2.2.3.min.js"></script>
<!-- Bootstrap 3.3.7 -->
<script src="bootstrap/js/bootstrap.min.js"></script>
<!-- FastClick -->
<script src="plugins/fastclick/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/app.min.js"></script>
<!-- Sparkline -->
<script src="plugins/sparkline/jquery.sparkline.min.js"></script>
<!-- jvectormap -->
<script src="plugins/jvectormap/jquery-jvectormap-1.2.2.min.js"></script>
<script src="plugins/jvectormap/jquery-jvectormap-world-mill-en.js"></script>
<!-- SlimScroll 1.3.0 -->
<script src="plugins/slimScroll/jquery.slimscroll.min.js"></script>
<!-- ChartJS 1.0.1 -->
<script src="plugins/chartjs/Chart.min.js"></script>
<!-- AdminLTE dashboard demo (This is only for demo purposes) -->
<script src="dist/js/pages/dashboard2.js"></script>

<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<!-- Bootstrap WYSIHTML5 -->
<script src="plugins/bootstrap-wysihtml5/bootstrap3-wysihtml5.all.min.js"></script>


<!-- InputMask -->
<script src="plugins/input-mask/jquery.inputmask.js"></script>
<script src="plugins/input-mask/jquery.inputmask.date.extensions.js"></script>
<script src="plugins/input-mask/jquery.inputmask.extensions.js"></script>
<!-- date-range-picker -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.11.2/moment.min.js"></script>
<script src="plugins/daterangepicker/daterangepicker.js"></script>
<!-- bootstrap datepicker -->
<!-- bootstrap color picker -->
<script src="plugins/colorpicker/bootstrap-colorpicker.min.js"></script>
<!-- bootstrap time picker -->
<script src="plugins/timepicker/bootstrap-timepicker.min.js"></script>
<!-- iCheck 1.0.1 -->
<script src="plugins/iCheck/icheck.min.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/app.min.js"></script>
</body>
</html>
<script>
function get_element(link){
<!-- var link=id+".html"; -->
if(link=="dashboard"){
	
	$("#dashboard").show();
	$("#data_load").hide();
	
}else{
	$("#data_load").html("");
	$.ajax({
	url:link,
	method:"post",
	success:function(data){
	<!-- alert(data); -->
	$("#dashboard").hide();
	
	$("#data_load").show();
	
	$("#data_load").html(data);
	
	}
	
	})
}
}


</script>