 <?php include('header.php');?>
 <?php include('sidebar.php');?>
<style type="text/css">
    .link {
        color:#fff!important;
        padding:5px 10px!important;
    }   
    
</style>
  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <h1>
        Dashboard
        <small>Control panel</small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active">Dashboard</li>
      </ol>
    </section>

    <!-- Main content -->
    <section class="content">
     
      <!--<div class="row">
       <div class="col-lg-3 col-xs-6">
          
          <div class="small-box bg-aqua">
            <div class="inner">
              <h3><?php  echo $helper->numberofhotels("tbl_users","int_user_id > 1"); ?></h3>
              <p>Registered Users</p>
            </div>
            <div class="icon">
              <i class="fa fa-hotel"></i>
            </div>
              <a href="users.php" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
          </div>
        </div>  
          <div class="col-lg-3 col-xs-6">
          
          <div class="small-box bg-aqua">
            <div class="inner">
              <h3><?php  echo $helper->numberofhotels("tbl_users","plan = 2"); ?></h3>
              <p>Tial Period Users</p>
            </div>
            <div class="icon">
              <i class="fa fa-hotel"></i>
            </div>
              <a href="users.php?plan=2" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
          </div>
        </div>
          <div class="col-lg-3 col-xs-6">
          
          <div class="small-box bg-green">
            <div class="inner">
              <h3><?php  echo $helper->numberofhotels("tbl_users","plan = 1 and status=1"); ?></h3>
              <p>Active Users</p>
            </div>
            <div class="icon">
              <i class="fa fa-hotel"></i>
            </div>
              <a href="users.php?plan=1&status=1" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
          </div>
        </div>
          <div class="col-lg-3 col-xs-6">
          
          <div class="small-box bg-green">
            <div class="inner">
              <h3><?php  echo $helper->numberofhotels("tbl_users","status=0"); ?></h3>
              <p>Pending Approvals</p>
            </div>
            <div class="icon">
              <i class="fa fa-hotel"></i>
            </div>
              <a href="users.php?type=pending" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
          </div>
        </div>
          <div class="col-lg-3 col-xs-6">
         
          <div class="small-box bg-red">
            <div class="inner">
              <h3><?php  echo $helper->numberofhotels("tbl_users","expirydate < CURRENT_DATE()"); ?></h3>
              <p>Expired Users</p>
            </div>
            <div class="icon">
              <i class="fa fa-hotel"></i>
            </div>
              <a href="users.php?expire=1" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
          </div>
        </div>
          <div class="col-lg-3 col-xs-6">
         
          <div class="small-box bg-orange">
            <div class="inner">
              <h3><?php  echo $helper->numberofhotels("tbl_users","expirydate BETWEEN CURRENT_DATE()AND DATE_ADD(CURRENT_DATE(), INTERVAL 30 DAY)"); ?></h3>
              <p>Expire in 30 days</p>
            </div>
            <div class="icon">
              <i class="fa fa-hotel"></i>
            </div>
              <a href="users.php?expire=30" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
          </div>
        </div>
           
          
          
          
         
       
          
          
          
      
        
      </div>-->
      

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

  
  <?php
  include('footer.php');
  ?>