<?php 
ob_start(); session_start();
include('session.php');
include("dbconnection.php");
     $rows = mysql_query("select * from airtime_customer where customer_id = '$session_id' ") or die (mysql_error());
				$dat = mysql_fetch_array($rows);
				
		$date =date('Y-m-d');
   //   echo "Current date :: ".$date."<br>";
     $month =date("M",strtotime($date))."(".date("m",strtotime($date)).")";
   //  echo "Month : ".$month;
       $id=$dat['customer_id'];
	   $target = '../profileimages/';
	  $img = $dat['image'];
	  $photo= $target.$img; 

?>
<!DOCTYPE html>
<html lang="en">
  <head><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    
    <!-- Meta, title, CSS, favicons, etc. -->
    
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">

    <title>Airtime Portal </title>

    <!-- Bootstrap -->
    <link href="../vendors/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
    <!-- Font Awesome -->
    <link href="../vendors/font-awesome/css/font-awesome.min.css" rel="stylesheet">
    <!-- iCheck -->
    <link href="../vendors/iCheck/skins/flat/green.css" rel="stylesheet">
    <!-- bootstrap-progressbar -->
    <link href="../vendors/bootstrap-progressbar/css/bootstrap-progressbar-3.3.4.min.css" rel="stylesheet">
    <!-- jVectorMap -->
    <link href="../css/maps/jquery-jvectormap-2.0.3.css" rel="stylesheet"/>

    <!-- Custom Theme Style -->
    <link href="../css/custom.css" rel="stylesheet">
  </head>

  <body class="nav-md">
    <div class="container body">
      <div class="main_container">
			
			<?php 
			$user = $dat['company'];
			$qry=mysql_query("select * from airtime_admin where username='$user' and account='Mobisky' ");
			
			if(mysql_num_rows($qry)> 0){
				// mobisky admin dashboard
				?>
		<div class="col-md-3 left_col">
          <div class="left_col scroll-view">
            <!--div class="navbar nav_title" style="border: 0;">
              <a href="index.html" class="site_title">
			    <div class="profile_pic" style="margin-top:-10px;">
					<img src="../images/mlogo.png" alt="" class="img-circle profile_img" />
			    </div>
			  <!--i class="fa fa-paw"></i--> <!--span>Instant Airtime </span></a>
            </div-->
            <div class="clearfix"></div>
            <!-- menu profile quick info -->
            <div class="profile">
              <div class="profile_pic">
			    <?php 
			  if($img == ""){
				  ?>
				   <img src="../profileimages/noimage.gif" alt="..." class="img-circle profile_img">
				  <?php
			  }else{
				?>
				 <img src="<?php echo $photo ?>" alt="..." class="img-circle profile_img" width="40px;" height="60px;">
            <?php				
			  }
			  ?>
              </div>
              <div class="profile_info">
                <span>Mobisky Admin </span>
				<h2> <?php $fname = $dat['fname']; $lname = $dat['lname']; echo $fname." ".$lname ?> </h2>
             <!--   <h2>John Doe</h2> -->
              </div>
            </div>
            <!-- /menu profile quick info -->
            <br/>	
				  <!-- sidebar menu -->
            <div id="sidebar-menu" class="main_menu_side hidden-print main_menu">
              <div class="menu_section">
			  
          	 <?php include("sidebar.php"); ?>
              </div>
            </div>
			<!--end side menubar -->
			</div>
        </div>
		
		 <!-- top navigation -->
			<div class="top_nav">
				<div class="nav_menu">
					<nav class="" role="navigation">
						<div class="nav toggle">
							<a id="menu_toggle"><i class="fa fa-bars"></i></a>
						</div>
					<?php //include('checkbalance.php'); ?>
						<ul class="nav navbar-nav navbar-right">
							<div style="margin-top:30px;font-size:22px;"> <label class="btn btn-danger" > Account Balance: <?php echo " "."Ksh. ".$bal;    ?> </label> </div>
								<div style="margin-top:-25px;">
									<li class="">
										<a href="javascript:;" class="user-profile dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
											<span> Mobisky Innovations <!--?php $fname = $dat['fname']; $lname = $dat['lname']; echo $fname." ".$lname ?--> 
											<span class=" fa fa-angle-down"></span>
										</a>
										<ul class="dropdown-menu dropdown-usermenu pull-right">
											<li><a href="adminprofile.php">  Profile</a></li> 
											<li> <a href="addnewadmin.php">Register New Admin</a> </li>
											<li><a href="../logout.php"><i class="fa fa-sign-out pull-right"></i> Log Out</a> </li>
										</ul>
									</li>
								</div>
						</ul>
					</nav>
				</div>
			</div>
        <!-- /top navigation -->
		
			<!-- page content -->
        <div class="right_col" role="main">
             <div class="row">
          <!-- top tiles -->
          <div class="row tile_count">
            <div class="col-md-2 col-sm-4 col-xs-6 tile_stats_count">
              <p> </p>
            </div>
            
          </div>
		  </div>
		  <hr/>
          <!-- /top tiles -->

          <div class="row">
		    <div class="col-md-4 col-sm-4 col-xs-12">
              <div class="x_panel tile fixed_height_320">
                <div class="x_title">
                  <h2>Account Statistics</h2>
                  <ul class="nav navbar-right panel_toolbox">
                    <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a>
                    </li>
                    <li class="dropdown">
                      <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false"><i class="fa fa-wrench"></i></a>
                      <ul class="dropdown-menu" role="menu">
                        <li><a href="#">Settings 1</a>
                        </li>
                        <li><a href="#">Settings 2</a>
                        </li>
                      </ul>
                    </li>
                    <li><a class="close-link"><i class="fa fa-close"></i></a>
                    </li>
                  </ul>
                  <div class="clearfix"></div>
                </div>
                <div class="x_content">
                      <h4>Account Current Status</h4>
                  <div class="widget_summary">
                    <div class="w_left w_25">
                      <span>1</span>
                    </div>
                    <div class="w_center w_55">
                        <div   style="width: 66%;">
                          <span> <b>Groups</b></span>
                        </div>
                    </div>
                    <div class="w_right w_20">
          <?php 
          //find company
          $find_shop = mysql_query("select * from airtime_customer where customer_id='$session_id' ");
          $found = mysql_fetch_array($find_shop);
          $shopname = $found['company'];
          
          //find user to get groups created
          $group_has = mysql_query("select * from airtime_customer where company='$shopname' ");
          $founduser = mysql_fetch_array($group_has);
          $userid = $founduser['customer_id'];
          echo "UID:" .$userid;
					$s=mysql_query("select * from airtime_groups where customer_id='$userid' ");
					$nums=mysql_num_rows($s);
					?>
                      <span><?php echo $nums; echo "Session:".$session_id;
          echo "Co.".$shopname;?></span>
                    </div>
                    <div class="clearfix"></div>
                  </div>

                  <div class="widget_summary">
                    <div class="w_left w_25">
                      <span>2</span>
                    </div>
                    <div class="w_center w_55">
                        <div  style="width: 66%;">
                          <span ><b>Contacts</b></span>
                        </div>
                    </div>
                    <div class="w_right w_20">
					<?php 
					$s2=mysql_query("select * from airtime_contacts where customer_id='$userid' ");
					$nums2=mysql_num_rows($s2);
					?>
                      <span><?php echo $nums2; ?></span>
                    </div>
                    <div class="clearfix"></div>
                  </div>
				  
                  <div class="widget_summary">
                    <div class="w_left w_25">
                      <span>3</span>
                    </div>
                    <div class="w_center w_55">
                        <div  style="width: 66%;">
                          Credit Received (Ksh) 
                        </div>
                    </div>
                    <div class="w_right w_20">
					<?php 
					$result = mysql_query("SELECT SUM(amount_awarded) AS value_sum FROM airtime_accounts where account_id='$userid' and status='Done' "); 
						$row = mysql_fetch_assoc($result); 
						$sum = $row['value_sum'];
					?>
                      <span><?php echo $sum; ?></span>
                    </div>
                    <div class="clearfix"></div>
                  </div>
				  
                  <div class="widget_summary">
                    <div class="w_left w_25">
                      <span>4</span>
                    </div>
                    <div class="w_center w_55">
                        <div  style="width: 66%;">
                          <span>Total Credit Sent (Ksh)</span>
                        </div>
                    </div>
                    <div class="w_right w_20">
					<?php
						$bal=$adcr['current_amount'];
						$total =$sum;
						$sent =  $total - (int)$bal;
					 ?>
                      <span><?php echo $sent; ?></span>
                    </div>
                    <div class="clearfix"></div>
                  </div>
				  
                  <div class="widget_summary">
                    <div class="w_left w_25">
                      <span>5</span>
                    </div>
                    <div class="w_center w_55">
                        <div  style="width: 66%;">
                          <span >Credit Balance (Ksh)</span>
                        </div>
                    </div>
                    <div class="w_right w_20">
					<?php 
					$bal=$adcr['current_amount'];
					$rem = (int)$bal;
					?>
                      <span><?php echo $rem;?></span>
                    </div>
                    <div class="clearfix"></div>
                  </div>
                </div>
              </div>
            </div>
			
			   <div class="col-md-4 col-sm-4 col-xs-12">
              <div class="x_panel tile fixed_height_320 overflow_hidden">
                <div class="x_title">
                  <h2>Recent Account Topups</h2>
                  <ul class="nav navbar-right panel_toolbox">
                    <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a>
                    </li>
                    <li class="dropdown">
                      <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false"><i class="fa fa-wrench"></i></a>
                      <ul class="dropdown-menu" role="menu">
                        <li><a href="#">Settings 1</a>
                        </li>
                        <li><a href="#">Settings 2</a>
                        </li>
                      </ul>
                    </li>
                    <li><a class="close-link"><i class="fa fa-close"></i></a>
                    </li>
                  </ul>
                  <div class="clearfix"></div>
                </div>
                <div class="x_content">
                  <table class="table table-hover">
                      <thead>
                        <tr>
                          <th>Date</th>
                          <th>Amount Credited (Ksh)</th>
                        </tr>
                      </thead>
                      <tbody>
						<?php
					       $s=mysql_query("select * from airtime_accounts where account_id='$session_id' and amount_awarded !='' order by date_awarded desc limit 5");
							while($data=mysql_fetch_array($s)){
								?>
								 <tr>
									<td><?php echo $data['date_awarded']; ?> </td>
									<td> <?php echo $data['amount_awarded']; ?> </td>
								</tr>
								<?php
							}
						?>
                      
                      </tbody>
                    </table>
                </div>
              </div>
            </div>
			
            <div class="col-md-4 col-sm-4 col-xs-12">
              <div class="x_panel tile fixed_height_320">
                <div class="x_title">
                  <h2>Recent Credit Transfers</h2>
                  <ul class="nav navbar-right panel_toolbox">
                    <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a>
                    </li>
                    <li class="dropdown">
                      <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false"><i class="fa fa-wrench"></i></a>
                      <ul class="dropdown-menu" role="menu">
                        <li><a href="#">Settings 1</a>
                        </li>
                        <li><a href="#">Settings 2</a>
                        </li>
                      </ul>
                    </li>
                    <li><a class="close-link"><i class="fa fa-close"></i></a>
                    </li>
                  </ul>
                  <div class="clearfix"></div>
                </div>
                <div class="x_content">
                 <table class="table table-hover">
                      <thead>
                        <tr>
						 <th>Date</th>
                          <th>Account For</th>
                          <th>Amount Credited (Ksh)</th>
                        </tr>
                      </thead>
                      <tbody>
						<?php 
						 $frm = $dat['company']; 
					        $s1=mysql_query("select * from airtime_topup_requests where company='$frm' and amount_awarded !='' order by date_awarded desc limit 5");
								while($data=mysql_fetch_array($s1)){
									$customer = $data['customer_id'];
									
									$s=mysql_query("select * from airtime_customer where customer_id='$customer' ");
									$dt=mysql_fetch_array($s);
									$fname=$dt['fname'];
									$lname=$dt['lname'];
									
								 ?>
									 <tr>
									   <td> <?php echo $data['date_awarded']; ?> </td>
										<td> <?php echo $fname." ".$lname; ?> </td>
										<td> <?php echo $data['amount_awarded']; ?> </td>
									</tr>
								<?php
								}
						?>
                      </tbody>
                    </table>
				  
                </div>
              </div>
            </div>
		
		  </div>
		  
		  <div class="row">
		     <div class="col-md-8">
                <div class="x_panel">
                  <div class="x_title">
                    <h2>Pending Topup Requests </h2>
                    <div class="clearfix"></div>
                  </div>
                  <div class="x_content">
				  
				  <?php 
				   $frm = $dat['company']; 
				   $dte = date("Y-m-d");
				   
				   $month = date("M");
				   $current_month = date('d'); 
				   
				    $s=mysql_query("select * from airtime_accounts where status ='Pending'  ") or die(mysql_error());
					while($rws = mysql_fetch_array($s)){
						$a_id = $rws['account_id'];
						$amnt = $rws['amount_requested'];
						$rid= $rws['id'];
						
						$u = mysql_query("select * from airtime_customer where customer_id='$a_id' ");
						$rw = mysql_fetch_array($u);
						$fname= $rw['fname'];
						$lname= $rw['lname'];
						$msg = $rw['company'];
						
						echo '
						   <article class="media event">
							<a class="pull-left date">
								<p class="month"> '.  $month .'</p>
								<p class="day">'. $current_month  .'</p>
							</a>
								<div class="media-body">
									<a class="title" href="#">Account For: '."&nbsp". $fname." ".$lname.' </a>
									<p>Company: '."&nbsp". $msg .'<br/>
									   Amount Requested:  '."&nbsp". "Ksh. ".$amnt.' </p>
									    <a title="Update Account" rel="tooltip" href="requests.php" type="button" class="btn btn-primary btn-xs pull-right" style="margin-top:-60px;"> Update Request
                              </a>
								</div>
							</article>
						';
					}
				
				   ?>
                   
                  </div>
                </div>
              </div>
		  </div>
       </div>
	   <!--end page content -->
		
		
		<?php			
				
			}else{
				// customer admin account's dashboard
				?>
		<div class="col-md-3 left_col">
          <div class="left_col scroll-view">
            <!--div class="navbar nav_title" style="border: 0;">
              <a href="index.html" class="site_title">
			    <div class="profile_pic" style="margin-top:-10px;">
					<img src="../images/mlogo.png" alt="" class="img-circle profile_img" />
			    </div>
			  <!--i class="fa fa-paw"></i--> <!--span>Instant Airtime </span></a>
            </div-->
            <div class="clearfix"></div>
            <!-- menu profile quick info -->
            <div class="profile">
              <div class="profile_pic">
			    <?php 
			  if($img == ""){
				  ?>
				   <img src="../profileimages/noimage.gif" alt="..." class="img-circle profile_img">
				  <?php
			  }else{
				?>
				 <img src="<?php echo $photo ?>" alt="..." class="img-circle profile_img" width="40px;" height="60px;">
            <?php				
			  }
			  ?>
              </div>
              <div class="profile_info">
                <span>Admin </span>
				<h2> <?php $fname = $dat['fname']; $lname = $dat['lname']; echo $fname." ".$lname ?> </h2>
             <!--   <h2>John Doe</h2> -->
              </div>
            </div>
            <!-- /menu profile quick info -->
            <br/>	
				  <!-- sidebar menu -->
            <div id="sidebar-menu" class="main_menu_side hidden-print main_menu">
              <div class="menu_section">
			  
                <h3>General</h3>
                <ul class="nav side-menu">
                  <li class="active"><a  href="adminpage.php" ><i class="fa fa-home"></i>  Home <span class="fa fa-chevron-right"></span></a> </li>
                  <li><a href="#">  Users <span class="fa fa-chevron-down"></span></a> 
				  <ul class="nav child_menu">
					    <li><a  href="adduser.php" ><i class="fa fa-bug"></i>Create User<span class="fa fa-chevron-right"></span></a> </li>
						<li><a  href="viewuser.php" ><i class="fa fa-edit"></i>View Users<span class="fa fa-chevron-down"></span></a> </li>
					   </ul>
				  </li>
                  <li><a href="contacts.php">  View Contacts <span class="fa fa-chevron-right"></span> </a> </li>
                  <li><a href="groups.php"> View Groups  <span class="fa fa-chevron-right"></span> </a>   </li>
                  <!--li><a href="requests.php">Topup Requests  <span class="fa fa-chevron-right"></span> </a>   </li>
				  <li><a href="topupaccount.php">Topup My account <span class="fa fa-chevron-right"></span> </a>   </li-->
				   <!--li><a> Reports <span class="fa fa-chevron-down"></span></a>  
				     
					   <ul class="nav child_menu">
					    <li><a  href="buyinghistory.php" > Purchase History <span class="fa fa-chevron-right"></span> </a> </li>
						<li><a  href="sendinghistory.php" > Sending History <span class="fa fa-chevron-right"></span> </a></li>
					   </ul>
				   </li-->
                </ul>
              </div>
            </div>
			<!--end side menubar -->
			</div>
        </div>
			
			 <!-- top navigation -->
			<div class="top_nav">
				<div class="nav_menu">
					<nav class="" role="navigation">
						<div class="nav toggle">
							<a id="menu_toggle"><i class="fa fa-bars"></i></a>
						</div>
					<?php include('checkbalance.php'); ?>
						<ul class="nav navbar-nav navbar-right">
							<div style="margin-top:30px;font-size:22px;"> <label class="btn btn-danger" > Account Balance: <?php echo " "."Ksh. ".$bal;    ?> </label> </div>
								<div style="margin-top:-25px;">
									<li class="">
										<a href="javascript:;" class="user-profile dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
											<span> Welcome Admin <!--?php $fname = $dat['fname']; $lname = $dat['lname']; echo $fname." ".$lname ?--> 
											<span class=" fa fa-angle-down"></span>
										</a>
										<ul class="dropdown-menu dropdown-usermenu pull-right">
											<li><a href="adminprofile.php">  Profile</a></li> 
											<li> <a href="newadmin.php">Register New Admin</a> </li>
											<li><a href="../logout.php"><i class="fa fa-sign-out pull-right"></i> Log Out</a> </li>
										</ul>
									</li>
								</div>
						</ul>
					</nav>
				</div>
			</div>
        <!-- /top navigation -->
		
		<!-- page content -->
        <div class="right_col" role="main">
             <div class="row">
          <!-- top tiles -->
          <div class="row tile_count">
            <div class="col-md-2 col-sm-4 col-xs-6 tile_stats_count">
              <p> </p>
            </div>
            
          </div>
		  </div>
		  <hr/>
          <!-- /top tiles -->

          <div class="row">
		    <div class="col-md-4 col-sm-4 col-xs-12">
              <div class="x_panel tile fixed_height_320">
                <div class="x_title">
                  <h2>Account Statistics</h2>
                  <ul class="nav navbar-right panel_toolbox">
                    <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a>
                    </li>
                    <li class="dropdown">
                      <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false"><i class="fa fa-wrench"></i></a>
                      <ul class="dropdown-menu" role="menu">
                        <li><a href="#">Settings 1</a>
                        </li>
                        <li><a href="#">Settings 2</a>
                        </li>
                      </ul>
                    </li>
                    <li><a class="close-link"><i class="fa fa-close"></i></a>
                    </li>
                  </ul>
                  <div class="clearfix"></div>
                </div>
                <div class="x_content">
                      <h4>Account Current Status</h4>
                  <div class="widget_summary">
                    <div class="w_left w_25">
                      <span>1</span>
                    </div>
                    <div class="w_center w_55">
                        <div   style="width: 66%;">
                          <span> <b>Groups</b></span>
                        </div>
                    </div>
                    <div class="w_right w_20">
					<?php 
					$s=mysql_query("select * from airtime_groups where customer_id='$session_id' ");
					$nums=mysql_num_rows($s);
					?>
                      <span><?php echo $nums; ?></span>
                    </div>
                    <div class="clearfix"></div>
                  </div>

                  <div class="widget_summary">
                    <div class="w_left w_25">
                      <span>2</span>
                    </div>
                    <div class="w_center w_55">
                        <div  style="width: 66%;">
                          <span ><b>Contacts</b></span>
                        </div>
                    </div>
                    <div class="w_right w_20">
					<?php 
					$s2=mysql_query("select * from airtime_contacts where customer_id='$session_id' ");
					$nums2=mysql_num_rows($s2);
					?>
                      <span><?php echo $nums2; ?></span>
                    </div>
                    <div class="clearfix"></div>
                  </div>
				  
                  <div class="widget_summary">
                    <div class="w_left w_25">
                      <span>3</span>
                    </div>
                    <div class="w_center w_55">
                        <div  style="width: 66%;">
                          Credit Received (Ksh) 
                        </div>
                    </div>
                    <div class="w_right w_20">
					<?php 
					$result = mysql_query("SELECT SUM(amount_awarded) AS value_sum FROM airtime_accounts where account_id='$session_id' and status='Done' "); 
						$row = mysql_fetch_assoc($result); 
						$sum = $row['value_sum'];
					?>
                      <span><?php echo $sum; ?></span>
                    </div>
                    <div class="clearfix"></div>
                  </div>
				  
                  <div class="widget_summary">
                    <div class="w_left w_25">
                      <span>4</span>
                    </div>
                    <div class="w_center w_55">
                        <div  style="width: 66%;">
                          <span>Total Credit Sent (Ksh)</span>
                        </div>
                    </div>
                    <div class="w_right w_20">
					<?php
						$bal=$adcr['current_amount'];
						$total =$sum;
						$sent =  $total - (int)$bal;
					 ?>
                      <span><?php echo $sent; ?></span>
                    </div>
                    <div class="clearfix"></div>
                  </div>
				  
                  <div class="widget_summary">
                    <div class="w_left w_25">
                      <span>5</span>
                    </div>
                    <div class="w_center w_55">
                        <div  style="width: 66%;">
                          <span >Credit Balance (Ksh)</span>
                        </div>
                    </div>
                    <div class="w_right w_20">
					<?php 
					$bal=$adcr['current_amount'];
					$rem = (int)$bal;
					?>
                      <span><?php echo $rem;?></span>
                    </div>
                    <div class="clearfix"></div>
                  </div>
                </div>
              </div>
            </div>
			
			   <div class="col-md-4 col-sm-4 col-xs-12">
              <div class="x_panel tile fixed_height_320 overflow_hidden">
                <div class="x_title">
                  <h2>Recent Account Topups</h2>
                  <ul class="nav navbar-right panel_toolbox">
                    <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a>
                    </li>
                    <li class="dropdown">
                      <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false"><i class="fa fa-wrench"></i></a>
                      <ul class="dropdown-menu" role="menu">
                        <li><a href="#">Settings 1</a>
                        </li>
                        <li><a href="#">Settings 2</a>
                        </li>
                      </ul>
                    </li>
                    <li><a class="close-link"><i class="fa fa-close"></i></a>
                    </li>
                  </ul>
                  <div class="clearfix"></div>
                </div>
                <div class="x_content">
                  <table class="table table-hover">
                      <thead>
                        <tr>
                          <th>Date</th>
                          <th>Amount Credited (Ksh)</th>
                        </tr>
                      </thead>
                      <tbody>
						<?php
					       $s=mysql_query("select * from airtime_accounts where account_id='$session_id' and amount_awarded !='' order by date_awarded desc limit 5");
							while($data=mysql_fetch_array($s)){
								?>
								 <tr>
									<td><?php echo $data['date_awarded']; ?> </td>
									<td> <?php echo $data['amount_awarded']; ?> </td>
								</tr>
								<?php
							}
						?>
                      
                      </tbody>
                    </table>
                </div>
              </div>
            </div>
			
            <div class="col-md-4 col-sm-4 col-xs-12">
              <div class="x_panel tile fixed_height_320">
                <div class="x_title">
                  <h2>Recent Credit Transfers</h2>
                  <ul class="nav navbar-right panel_toolbox">
                    <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a>
                    </li>
                    <li class="dropdown">
                      <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false"><i class="fa fa-wrench"></i></a>
                      <ul class="dropdown-menu" role="menu">
                        <li><a href="#">Settings 1</a>
                        </li>
                        <li><a href="#">Settings 2</a>
                        </li>
                      </ul>
                    </li>
                    <li><a class="close-link"><i class="fa fa-close"></i></a>
                    </li>
                  </ul>
                  <div class="clearfix"></div>
                </div>
                <div class="x_content">
                 <table class="table table-hover">
                      <thead>
                        <tr>
						 <th>Date</th>
                          <th>Account For</th>
                          <th>Amount Credited (Ksh)</th>
                        </tr>
                      </thead>
                      <tbody>
						<?php 
						 $frm = $dat['company']; 
					        $s1=mysql_query("select * from airtime_topup_requests where company='$frm' and amount_awarded !='' order by date_awarded desc limit 5");
								while($data=mysql_fetch_array($s1)){
									$customer = $data['customer_id'];
									
									$s=mysql_query("select * from airtime_customer where customer_id='$customer' ");
									$dt=mysql_fetch_array($s);
									$fname=$dt['fname'];
									$lname=$dt['lname'];
									
								 ?>
									 <tr>
									   <td> <?php echo $data['date_awarded']; ?> </td>
										<td> <?php echo $fname." ".$lname; ?> </td>
										<td> <?php echo $data['amount_awarded']; ?> </td>
									</tr>
								<?php
								}
						?>
                      </tbody>
                    </table>
				  
                </div>
              </div>
            </div>
		
		  </div>
		  
		  <div class="row">
		     <div class="col-md-8">
                <div class="x_panel">
                  <div class="x_title">
                    <h2>Pending Topup Requests </h2>
                    <div class="clearfix"></div>
                  </div>
                  <div class="x_content">
				  
				  <?php 
				   $frm = $dat['company']; 
				   $dte = date("Y-m-d");
				   
				   $month = date("M");
				   $current_month = date('d'); 
				   
				    $s=mysql_query("select * from airtime_topup_requests where company='$frm' and amount_requested !='' and status='Pending'  ") or die(mysql_error());
					while($rws = mysql_fetch_array($s)){
						$aid = $rws['customer_id'];
						$msg = $rws['message'];
						$amnt = $rws['amount_requested'];
						$id= $rws['request_id'];
						
						$u = mysql_query("select * from airtime_customer where customer_id='$aid' ");
						$rw = mysql_fetch_array($u);
						$fname= $rw['fname'];
						$lname= $rw['lname'];
						
						echo '
						   <article class="media event">
							<a class="pull-left date">
								<p class="month"> '.  $month .'</p>
								<p class="day">'. $current_month  .'</p>
							</a>
								<div class="media-body">
									<a class="title" href="#">Account For: '."&nbsp". $fname." ".$lname.' </a>
									<p>Message: '."&nbsp". $msg .'<br/>
									   Amount Requested:  '."&nbsp". "Ksh. ".$amnt.' </p>
									    <a title="Update Account" rel="tooltip" href="requests.php"  type="button" class="btn btn-primary btn-xs pull-right" style="margin-top:-60px;"> Update Request
                              </a>
								</div>
							</article>
						';
					}
				
				   ?>
                   
                  </div>
                </div>
              </div>
		  </div>
       </div>
	   <!--end page content -->
			
			
			
			
			<?php	
			}
			
			
			?>

          

       


        
	   
	   
	   </div>
        </div>
        <!-- /page content. End of main -->

           <!-- footer content -->
        <footer>
          <div class="pull-right">
            Mobisky Innovations Airtime Portal 
          </div>
          <div class="clearfix"></div>
        </footer>
        <!-- /footer content -->
     

    <!-- jQuery -->
    <script src="../vendors/jquery/dist/jquery.min.js"></script>
    <!-- Bootstrap -->
    <script src="../vendors/bootstrap/dist/js/bootstrap.min.js"></script>
    <!-- FastClick -->
    <script src="../vendors/fastclick/lib/fastclick.js"></script>
    <!-- NProgress -->
    <script src="../vendors/nprogress/nprogress.js"></script>
    <!-- Chart.js -->
    <script src="../vendors/Chart.js/dist/Chart.min.js"></script>
    <!-- gauge.js -->
    <script src="../vendors/bernii/gauge.js/dist/gauge.min.js"></script>
    <!-- bootstrap-progressbar -->
    <script src="../vendors/bootstrap-progressbar/bootstrap-progressbar.min.js"></script>
    <!-- iCheck -->
    <script src="../vendors/iCheck/icheck.min.js"></script>
    <!-- Skycons -->
    <script src="../vendors/skycons/skycons.js"></script>
    <!-- Flot -->
    <script src="../vendors/Flot/jquery.flot.js"></script>
    <script src="../vendors/Flot/jquery.flot.pie.js"></script>
    <script src="../vendors/Flot/jquery.flot.time.js"></script>
    <script src="../vendors/Flot/jquery.flot.stack.js"></script>
    <script src="../vendors/Flot/jquery.flot.resize.js"></script>
    <!-- Flot plugins -->
    <script src="../js/flot/jquery.flot.orderBars.js"></script>
    <script src="../js/flot/date.js"></script>
    <script src="../js/flot/jquery.flot.spline.js"></script>
    <script src="../js/flot/curvedLines.js"></script>
    <!-- jVectorMap -->
    <script src="../js/maps/jquery-jvectormap-2.0.3.min.js"></script>
    <!-- bootstrap-daterangepicker -->
    <script src="../js/moment/moment.min.js"></script>
    <script src="../js/datepicker/daterangepicker.js"></script>


    <!-- Custom Theme Scripts -->
    <script src="../js/custom.js"></script>

    <!-- Flot -->
    <script>
      $(document).ready(function() {
        var data1 = [
          [gd(2012, 1, 1), 17],
          [gd(2012, 1, 2), 74],
          [gd(2012, 1, 3), 6],
          [gd(2012, 1, 4), 39],
          [gd(2012, 1, 5), 20],
          [gd(2012, 1, 6), 85],
          [gd(2012, 1, 7), 7]
        ];

        var data2 = [
          [gd(2012, 1, 1), 82],
          [gd(2012, 1, 2), 23],
          [gd(2012, 1, 3), 66],
          [gd(2012, 1, 4), 9],
          [gd(2012, 1, 5), 119],
          [gd(2012, 1, 6), 6],
          [gd(2012, 1, 7), 9]
        ];
        $("#canvas_dahs").length && $.plot($("#canvas_dahs"), [
          data1, data2
        ], {
          series: {
            lines: {
              show: false,
              fill: true
            },
            splines: {
              show: true,
              tension: 0.4,
              lineWidth: 1,
              fill: 0.4
            },
            points: {
              radius: 0,
              show: true
            },
            shadowSize: 2
          },
          grid: {
            verticalLines: true,
            hoverable: true,
            clickable: true,
            tickColor: "#d5d5d5",
            borderWidth: 1,
            color: '#fff'
          },
          colors: ["rgba(38, 185, 154, 0.38)", "rgba(3, 88, 106, 0.38)"],
          xaxis: {
            tickColor: "rgba(51, 51, 51, 0.06)",
            mode: "time",
            tickSize: [1, "day"],
            //tickLength: 10,
            axisLabel: "Date",
            axisLabelUseCanvas: true,
            axisLabelFontSizePixels: 12,
            axisLabelFontFamily: 'Verdana, Arial',
            axisLabelPadding: 10
          },
          yaxis: {
            ticks: 8,
            tickColor: "rgba(51, 51, 51, 0.06)",
          },
          tooltip: false
        });

        function gd(year, month, day) {
          return new Date(year, month - 1, day).getTime();
        }
      });
    </script>
    <!-- /Flot -->

    <!-- jVectorMap -->
    <script src="../js/maps/jquery-jvectormap-world-mill-en.js"></script>
    <script src="../js/maps/jquery-jvectormap-us-aea-en.js"></script>
    <script src="../js/maps/gdp-data.js"></script>
    <script>
      $(document).ready(function(){
        $('#world-map-gdp').vectorMap({
          map: 'world_mill_en',
          backgroundColor: 'transparent',
          zoomOnScroll: false,
          series: {
            regions: [{
              values: gdpData,
              scale: ['#E6F2F0', '#149B7E'],
              normalizeFunction: 'polynomial'
            }]
          },
          onRegionTipShow: function(e, el, code) {
            el.html(el.html() + ' (GDP - ' + gdpData[code] + ')');
          }
        });
      });
    </script>
    <!-- /jVectorMap -->

    <!-- Skycons -->
    <script>
      $(document).ready(function() {
        var icons = new Skycons({
            "color": "#73879C"
          }),
          list = [
            "clear-day", "clear-night", "partly-cloudy-day",
            "partly-cloudy-night", "cloudy", "rain", "sleet", "snow", "wind",
            "fog"
          ],
          i;

        for (i = list.length; i--;)
          icons.set(list[i], list[i]);

        icons.play();
      });
    </script>
    <!-- /Skycons -->

    <!-- Doughnut Chart -->
    <script>
      $(document).ready(function(){
        var options = {
          legend: false,
          responsive: false
        };

        new Chart(document.getElementById("canvas1"), {
          type: 'doughnut',
          tooltipFillColor: "rgba(51, 51, 51, 0.55)",
          data: {
            labels: [
              "Symbian",
              "Blackberry",
              "Other",
              "Android",
              "IOS"
            ],
            datasets: [{
              data: [15, 20, 30, 10, 30],
              backgroundColor: [
                "#BDC3C7",
                "#9B59B6",
                "#E74C3C",
                "#26B99A",
                "#3498DB"
              ],
              hoverBackgroundColor: [
                "#CFD4D8",
                "#B370CF",
                "#E95E4F",
                "#36CAAB",
                "#49A9EA"
              ]
            }]
          },
          options: options
        });
      });
    </script>
    <!-- /Doughnut Chart -->
    
    <!-- bootstrap-daterangepicker -->
    <script>
      $(document).ready(function() {

        var cb = function(start, end, label) {
          console.log(start.toISOString(), end.toISOString(), label);
          $('#reportrange span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
        };

        var optionSet1 = {
          startDate: moment().subtract(29, 'days'),
          endDate: moment(),
          minDate: '01/01/2012',
          maxDate: '12/31/2015',
          dateLimit: {
            days: 60
          },
          showDropdowns: true,
          showWeekNumbers: true,
          timePicker: false,
          timePickerIncrement: 1,
          timePicker12Hour: true,
          ranges: {
            'Today': [moment(), moment()],
            'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
            'Last 7 Days': [moment().subtract(6, 'days'), moment()],
            'Last 30 Days': [moment().subtract(29, 'days'), moment()],
            'This Month': [moment().startOf('month'), moment().endOf('month')],
            'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
          },
          opens: 'left',
          buttonClasses: ['btn btn-default'],
          applyClass: 'btn-small btn-primary',
          cancelClass: 'btn-small',
          format: 'MM/DD/YYYY',
          separator: ' to ',
          locale: {
            applyLabel: 'Submit',
            cancelLabel: 'Clear',
            fromLabel: 'From',
            toLabel: 'To',
            customRangeLabel: 'Custom',
            daysOfWeek: ['Su', 'Mo', 'Tu', 'We', 'Th', 'Fr', 'Sa'],
            monthNames: ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'],
            firstDay: 1
          }
        };
        $('#reportrange span').html(moment().subtract(29, 'days').format('MMMM D, YYYY') + ' - ' + moment().format('MMMM D, YYYY'));
        $('#reportrange').daterangepicker(optionSet1, cb);
        $('#reportrange').on('show.daterangepicker', function() {
          console.log("show event fired");
        });
        $('#reportrange').on('hide.daterangepicker', function() {
          console.log("hide event fired");
        });
        $('#reportrange').on('apply.daterangepicker', function(ev, picker) {
          console.log("apply event fired, start/end dates are " + picker.startDate.format('MMMM D, YYYY') + " to " + picker.endDate.format('MMMM D, YYYY'));
        });
        $('#reportrange').on('cancel.daterangepicker', function(ev, picker) {
          console.log("cancel event fired");
        });
        $('#options1').click(function() {
          $('#reportrange').data('daterangepicker').setOptions(optionSet1, cb);
        });
        $('#options2').click(function() {
          $('#reportrange').data('daterangepicker').setOptions(optionSet2, cb);
        });
        $('#destroy').click(function() {
          $('#reportrange').data('daterangepicker').remove();
        });
      });
    </script>
    <!-- /bootstrap-daterangepicker -->

    <!-- gauge.js -->
    <script>
      var opts = {
          lines: 12,
          angle: 0,
          lineWidth: 0.4,
          pointer: {
              length: 0.75,
              strokeWidth: 0.042,
              color: '#1D212A'
          },
          limitMax: 'false',
          colorStart: '#1ABC9C',
          colorStop: '#1ABC9C',
          strokeColor: '#F0F3F3',
          generateGradient: true
      };
      var target = document.getElementById('foo'),
          gauge = new Gauge(target).setOptions(opts);

      gauge.maxValue = 6000;
      gauge.animationSpeed = 32;
      gauge.set(3200);
      gauge.setTextField(document.getElementById("gauge-text"));
    </script>
    <!-- /gauge.js -->
  </body>
</html>
	