<?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="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 href="#"><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> </li>
					   </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 class="active" ><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 href="#"><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><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>
		  </div>
          <!-- /top tiles -->
		 
		 <div class="x_title">
                    <h2>Select Contact to Send Airtime </h2>
                    <div class="clearfix"></div>
                  </div>
		  
		  <div class="col-md-12 col-sm-12 col-xs-12">
		    <a href="topupselected.php" ><button class="btn btn-success" name="sendairtime">Select Contacts To Topup</button>  </a>  <b> OR </b>
		 <?php  $sql1 = mysql_query("select * from airtime_contacts where customer_id = '$session_id' and contact != '' ");
				  $conts = mysql_num_rows($sql1);
				  ?>
		  <form method="post" >
		 
                <div class="x_panel">
                  <div class="x_title">
                     <div class="col-md-3 col-sm-3 col-xs-3">
                          <input type="text" id="amount" name="amountx" required="required" placeholder="Ksh" class="form-control col-md-3 col-xs-3">
                        </div>
					  <button type="submit" class="btn btn-primary " name="sendairtime">Topup All Contacts <?php  echo "(".$conts." Contacts in Total)"; ?> </button>  
					 
					</h2>
                    <div class="clearfix"></div>
                  </div>
                  <div class="x_content">
	
                    
                    <table id="datatable" class="table table-striped table-bordered">
                      <thead>
                        <tr>
                          <th>Name</th>
                          <th>Contact</th>
                          <th>Group</th>
                        </tr>
                      </thead>
                      <tbody>
                      <?php
					  
					  $sql = "select * from airtime_contacts where customer_id='$session_id' limit 1000";
					  $result = mysql_query($sql);
					   while($row = mysql_fetch_array($result)) {
						   $gr = $row['group_id'];
						   
						   $grp = "";
						   if($row['group_id'] == 0){
						       $grp = "Not Allocated";
						     
						   }else{
						       $s = mysql_query("select * from airtime_groups where group_id='$gr' and customer_id='$session_id' ");
						      $rw = mysql_fetch_array($s);  
						        $grp = $rw['name'];
						   }
						   
						 
                       echo "<tr>";
				        echo '<td> <b>' .$row['fname']. '</b></td>';
                        echo '<td> <b>'.$row['contact']. '</b></td>';
				       echo '<td> <b style="color:green;">' .$grp. '</b></td>';
					   
				         echo "</tr>";
				       }  
					  
					  ?>  
                       
                      </tbody>
                    </table>
                  </div>
                </div>
			</form>	
				  <?php
		          if(isset($_POST['sendairtime'])){
				    $amnt=$_POST['amountx'];
					
					$bal = $usrcr['amount'];
					
			       
					if($bal==0){
						// no credit
						?>
						<script>
						alert("Error! Your account balance is insufficient. Please topup your account.");
							window.location="selectcontacttosend.php";
						</script>
						<?php
					}else{
						  $sql = mysql_query("select * from airtime_contacts where customer_id = '$session_id' ");
						  $dt=mysql_fetch_array($sql);
						//  $phone = $dt['contact'];
						  $nums = mysql_num_rows($sql);
						  
						  $amount = (int)$amnt;
						  $total_amount = $amount * $nums;
						  	
						  
						  if( $total_amount > $bal){
							  ?>
							  	<script>
									alert("Error! Your account balance is insufficient to send <?php echo "Ksh. ".$total_amount; ?>. Your account balance is <?php echo "Ksh. ".$bal; ?>. Please topup your account.");
									window.location="selectcontacttosend.php";
								</script>
							<?php  
						  }else{
							  
							   $int = (int)$amnt;
							   if( $int < 5 ){
									// error message
									?>
										<script>
											alert("Minimum Amount to send is Ksh. 5.");
										
										</script>
									<?php
								}
								else{
									// send airtime
								
									$username = $get_credentials['username'];
									$password = $get_credentials['password'];
									$send_amnt = $_POST['amountx'];
									$amount = (int)$amnt;
									$ch = curl_init();
									
									$sql1 = mysql_query("select * from airtime_contacts where customer_id = '$session_id' ");
									while($dt1=mysql_fetch_array($sql1)){
									 $phone = $dt1['contact'];
									 // check phone number 
									$no_ckeck = substr($phone, 0, 1);
									
										if ($no_ckeck == "+"){
											$pno = substr($phone, 1);
											$phne = $pno;
										}elseif($no_ckeck == "7"){
											$phne = "0".$phone;
										}else{
											$phne = $phone;
										}
									    	
										 // send airtime
										$parameters = "username=$username&password=$password&recipient=$phne&amount=$send_amnt&user=$session_id";
										$url = "http://www.mobisky.biz/api/sendairtime.php?$parameters";
										
										//fopen("$url","r"); 
							
										// set URL and other appropriate options
										curl_setopt($ch, CURLOPT_URL, "$url");
										curl_setopt($ch, CURLOPT_HEADER, 0);
										// Pass it to the browser
										curl_exec($ch);
									
										if(curl_error($ch)) {
											//	echo 'error:' . curl_error($ch);
												  //insert data 
												  ?>
												<script>
													alert("One Error Occured while sending airtime.");
												</script>
												<?php
												$query =	mysql_query("insert into airtime_sending_records (customer_id,requestid,airtime_sent,recipient,date_sent,status) values('$session_id','None',$amount','$phone',Now(),'Error sending request') ");
										    }
											else{
										 	  //insert data 
											//	$query =	mysql_query("insert into airtime_sending_records (customer_id,airtime_sent,recipient,date_sent,status) values('$session_id','$amount','$phone',Now(),'1') ");
									
												$qry = mysql_query("select * from airtime_logs where id='$session_lid' ");
												$sdata=mysql_fetch_array($qry);
												
												$actions = $sdata['user_actions'];
												mysql_query("update airtime_logs set user_actions='$actions Sent Airtime to phone no. $phone, Ksh. $amount.' where id='$session_lid' ");
											}
								
									
									}
											file_put_contents("checkairtime.log",$session_id,FILE_APPEND);
											?>
												<script>
											
													alert("Done Sending Airtime.");
													window.location="selectcontacttosend.php";
												</script>
												
											<?php
										    
										// close cURL resource, and free up system resources
											curl_close($ch);
						
									}
						  
								}  
						 
					 }
				
					}
		        ?>
		 
		  
	
		  
		  </div>
	
		  
		  
		          <!-- /page content. End of main -->

     <?php include("footerlinks.php"); ?>
	 
	  </div>
  </div>
 </div>
 <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>

	 <!-- 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>
    <!-- Datatables -->
    <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();
        $('#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>
    <!-- /Select2 -->	
