<?php  include("homeheader.php"); ?>

  <body class="nav-md">
    <div class="container body">
      <div class="main_container">
        <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>Welcome,</span>
			<h2> <?php $fname = $dat['fname']; $lname = $dat['lname']; $comp = $dat['company'];  if(empty($comp)){ echo ucwords($fname." ".$lname); }else{ echo ucwords($comp); }  ?> </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">
			  <br/>
                <h3>General</h3>
                <ul class="nav side-menu">
                  <li ><a  href="homepage.php" ><i class="fa fa-home"></i>  Home <span class="fa fa-chevron-right"></span></a> </li>
                  <li ><a><i class="fa fa-building"></i> My Contacts <span class="fa fa-chevron-down"></span></a> 
				  <ul class="nav child_menu">
					    <li><a  href="addcontact.php" ><i class="fa fa-user-plus"></i>Add New Contact<span class="fa fa-chevron-right"></span></a> </li>
						<li><a  href="addnewcontact.php" ><i class="fa fa-eye"></i>View Contacts<span class="fa fa-chevron-right"></span></a>
					   </ul>
				  </li>
                  <li ><a><i class="fa fa-users"></i> Groups <span class="fa fa-chevron-down"></span></a> 
				        <ul class="nav child_menu">
					   <li><a  href="creategroup.php" ><i class="fa fa-paw"></i>Create Group<span class="fa fa-chevron-right"></span></a> </li>
						<li><a  href="viewgroups.php" ><i class="fa fa-eye"></i>View Groups<span class="fa fa-chevron-right"></span></a> </li>
					   </ul>
				  </li>
                  <li><a><i class="fa fa-table"></i> Topup <span class="fa fa-chevron-down"></span></a>  
				   <ul class="nav child_menu">
						<li><a  href="sendtogroup.php"><i class="fa fa-cloud-download"></i>Top-up Group Contacts<span class="fa fa-chevron-right"></span></a> </li>
						<li><a href="selectcontacttosend.php" ><i class="fa fa-building"></i>Select Contact(s)<span class="fa fa-chevron-right"></span></a> </li>
						 <li><a  href="sendtome.php"  ><i class="fa fa-mobile"></i> Top-up My Line<span class="fa fa-chevron-right"></span></a> </li>
						 <li><a href="autosend-airtime.php" ><i class="fa fa-recycle"></i> Auto-Send Airtime <span class="fa fa-chevron-right"></span></a> </li>
					   </ul>				  
				  </li>
                   <li><a><i class="fa fa-gg"></i> Billing <span class="fa fa-chevron-down"></span></a> 
				   <ul class="nav child_menu">
                     <li  ><a  href="purchasetome.php" ><i class="fa fa-server"></i> Top-up My Account<span class="fa fa-chevron-right"></span></a> </li>
					   </ul>
				  </li>
				   <li class="active"><a><i class="fa fa-bar-chart-o"></i> History <span class="fa fa-chevron-down"></span></a>  
				      <!--  <ul class="nav side-menu"> -->
					   <ul class="nav child_menu">
					    <li><a  href="creditassignment.php" ><i class="fa fa-bars"></i>Credit Assignment<span class="fa fa-chevron-right"></span></a> </li>
						
					   </ul>
				   </li>
                </ul>
              </div>

            </div>
			 </div>
        </div>
		
		<?php
        include("topmenubar.php");

         ?>
		 
		 
		 <!-- page content -->
        <div class="right_col" role="main">
		  <!-- /top navigation -->
		     <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>
	
          <!-- /top tiles -->
		 
		  <div class="x_title">
                    <h2> <b>Airtime Assignment History </b> </h2>
                    <div class="clearfix"></div>
                  </div>
		 
				 <div class="col-md-12 col-sm-12 col-xs-12">
                <div class="x_panel">
                  <div class="x_title">
                    <h2>
					 <a href="detailedsummary.php"> <button type="submit" class="btn btn-success " name="sendairtime">Detailed Topup History</button>  </a>
					</h2>
					           <h2>
					 <a target="_blank" href="print_to_pdf/print_crassignment.php"> <button type="submit" class="btn btn-success " name="sendairtime">Export PDF</button>  </a>
					</h2>
					  <div class="dropdown pull-right">
						<button class="btn btn-default dropdown-toggle" type="button" data-toggle="dropdown">Tools <span class="caret"></span></button>
							<ul class="dropdown-menu">
								<li class="active"><a target="_blank" href="pdf/assignmentreport.php">Export PDF</a></li>
								<li><a href="excel/exportexcel.php" title="Export to Excel" >Export Excel</a></li>
								<li><a href="excel/exportcsv.php"> Export CSV</a></li>
							</ul>
					</div>
					
                    <div class="clearfix"></div>
                  </div>
				  
				 
				  
				  
                  <div class="x_content">
	
                    
                    <table id="datatable" class="table table-striped table-bordered" >
                      <thead>
                        <tr>
						  <th>Request ID</th>
                          <th>Date</th>
                          <th>Airtime sent</th>
                          <th>Recipient</th>
                          <th>Name</th>
                          <th>Group     <?php echo $session_id;    ?>   </th>
                          <th>Status</th>
                          <!--th>Delete</th-->
                        </tr>
                      </thead>
                      <tbody>
                      <?php
                      //    include("check_number.php");
					  $sql = mysql_query("select * from airtime_sending_records where customer_id = '$session_id' order by r_id DESC limit 2000");
					  while($dt=mysql_fetch_array($sql)){
						  $phone = $dt['recipient'];
						  $id = $dt['r_id'];
						  
						 /*   $numdata = number_checker($phone);
                        	$pno1 = $numdata[0];  
                			$pno2 = $numdata[1];
                			$pno3 = $numdata[2]; */
                            
						  $no_ckeck = substr($phone, 0, 1);
						   if($no_ckeck == "0")
						   {
                    			$pno = substr($phone, 1);  // remove first character
                    			$pno1 = $pno;  // 727992036
                    			$pno2 = "+254".$pno;  //+254727992036
                    			$pno3 = "254".$pno; 		//254727992036
                    		}
                    		elseif($no_ckeck == "2")
                    		{
                    			$pno = substr($phone, 3);  // remove first 3 characters
                    			$pno3 = "+".$phone; // +254727992036
                    			$pno1 = $pno;   // 727992036
                    			$pno2 = "0".$pno;   // 0727992036
                    			
                    		}
                    		elseif($no_ckeck == "7")
                    		{
                    			$pno1 = "0".$phone;  // 0727992036
                    			$pno2 = "+254".$phone;  //+254727992036
                    			$pno3 = "254".$phone; 		//254727992036
                    		}
                    		elseif($no_ckeck == "+")
                    		{
                    			$pno = substr($phone, 4);  // remove first 4 characters
                    			$pno1 = $pno;  // 727992036
                    			$pno2 = "0".$pno;  // 0727992036
                    			$pno3 = "254".$pno;  //254727992036
                    		} 
                    		else{} 
						  
						  $s = mysql_query("select * from airtime_contacts where customer_id = '$session_id' and (contact = '$phone' or contact = '$pno1' or contact = '$pno2' or contact = '$pno3') ");
						  $rwdt=mysql_fetch_array($s);
						  $gid=$rwdt['group_id'];
						  
						  $grp = "";
						  if($rwdt['group_id'] == 0 ){
						       $grp = "Not Allocated";
						  }else{
						      
						       $s2 = mysql_query("select * from airtime_groups where group_id='$gid' and customer_id='$session_id' ");
						      $rw= mysql_fetch_array($s2);
						      $grp = $rw['name'];
						  }
						  
						  
							  
								echo "<tr>";
								echo '<td><b>' . $dt['requestid'] . '</b></td>';
								echo '<td><b>' . $dt['date_sent'] . '</b></td>';
								echo '<td>' . $dt['airtime_sent'] . '</td>';
								echo '<td>'. $dt['recipient'] . '</td>';
								echo '<td><b>' . $rwdt['fname'].'</b></td>';
								echo '<td><b style="color:green;">'. $grp. '</b></td>';
									echo '<td> <b style="color:green;">'.$dt['status']. '</b></td>';
								?>
								<!--td>
									<a rel="tooltip" title="Delete Record" id="<?php echo $id  ?>" href="#deletedata<?php echo $id  ?>" data-toggle="modal" >
										<i class='fa fa-trash'></i> </a> 
									<?php include('delete_record.php'); ?>
								</td-->
								<?php
							}
					  
                       echo "</table>";
					  
					  ?>  
                       
                       
                        
                      </tbody>
                    </table>
                  </div>
                </div>
				</div>
	
		  </div>
		  
		  
		  
		  
		  
		  </div>
		  
		  </div>
	</div>	          <!-- /page content. End of main -->

     <?php include("footerlinks.php"); ?>

	  <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>
	
	  <script src="vendors/datatables.net/js/jquery.dataTables.min.js"></script>
    <script src="vendors/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
    <script src="vendors/datatables.net-buttons/js/dataTables.buttons.min.js"></script>
    <script src="vendors/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script>
    <script src="vendors/datatables.net-buttons/js/buttons.flash.min.js"></script>
    <script src="vendors/datatables.net-buttons/js/buttons.html5.min.js"></script>
    <script src="vendors/datatables.net-buttons/js/buttons.print.min.js"></script>
    <script src="vendors/datatables.net-fixedheader/js/dataTables.fixedHeader.min.js"></script>
    <script src="vendors/datatables.net-keytable/js/dataTables.keyTable.min.js"></script>
    <script src="vendors/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
    <script src="vendors/datatables.net-responsive-bs/js/responsive.bootstrap.js"></script>
    <script src="vendors/datatables.net-scroller/js/datatables.scroller.min.js"></script>
    <script src="vendors/jszip/dist/jszip.min.js"></script>
    <script src="vendors/pdfmake/build/pdfmake.min.js"></script>
    <script src="vendors/pdfmake/build/vfs_fonts.js"></script>
	
	    <script src="vendors/select2/dist/js/select2.full.min.js"></script>
	   
	
		  <!-- Datatables -->
	 <script>
      $(document).ready(function() {
        var handleDataTableButtons = function() {
          if ($("#datatable-buttons").length) {
            $("#datatable-buttons").DataTable({
              dom: "Bfrtip",
              buttons: [
                {
                  extend: "copy",
                  className: "btn-sm"
                },
                {
                  extend: "csv",
                  className: "btn-sm"
                },
                {
                  extend: "excel",
                  className: "btn-sm"
                },
                {
                  extend: "pdfHtml5",
                  className: "btn-sm"
                },
                {
                  extend: "print",
                  className: "btn-sm"
                },
              ],
              responsive: true
            });
          }
        };

        TableManageButtons = function() {
          "use strict";
          return {
            init: function() {
              handleDataTableButtons();
            }
          };
        }();

        $('#datatable').dataTable({"ordering": false});
        $('#datatable-keytable').DataTable({
          keys: true
        });

        $('#datatable-responsive').DataTable();

        $('#datatable-scroller').DataTable({
          ajax: "js/datatables/json/scroller-demo.json",
          deferRender: true,
          scrollY: 380,
          scrollCollapse: true,
          scroller: true
        });

        var table = $('#datatable-fixed-header').DataTable({
          fixedHeader: true
        });

        TableManageButtons.init();
      });
    </script>	
	
    <!-- Select2 -->
    <script>
      $(document).ready(function() {
        $(".select2_single").select2({
          placeholder: "Select a state",
          allowClear: true
        });
        $(".select2_group").select2({});
        $(".select2_multiple").select2({
       placeholder: "Chose Contacts to topup",
          allowClear: true
        });
      });
    </script> 
	</body>