<?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']; 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">
			  <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 class="active"><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 href="#"><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><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 -->
		  
		
		    <br/>
			<div class="x_title">
                    <h2>Upload New Contacts  </h2>
                    <div class="clearfix"></div>
                  </div>
				    <div style="margin-left:20px;"> <p>Prepare your contacts List in excel with columns: <b>Name and Phone Number.</b> Name Field can be blank but must be there. Save the excel file with <b>.csv(Comma Delimited) </b> extension.</p></div>
				   <b style="margin-left:20px;color:green">Phone Number Must Start with 07... No International Numbers</b> 
				   <br/>   <br/>
				   <b style="margin-left:20px;color:red;">Download a Sample Template</b> &nbsp;&nbsp;<a href="example.csv" download >Click to Download</a>
				   <br/>   <br/>
				   
				 <form name="contactsx" data-parsley-validate class="form-horizontal form-label-left" method="post" action="import.php" enctype="multipart/form-data">
						<div class="form-group">
										<label class="control-label col-md-3 col-sm-3 col-xs-3" for="last-name"> Select Group</label>
											<div class="col-md-4 col-sm-4 col-xs-5">
												<select class="form-control" name="grup" required="required" >
													<option>--Select Group--</option>
													<?php 
														$grps = mysql_query("select * from airtime_groups where customer_id = '$session_id' order by group_id");
															$numrows = mysql_num_rows($grps);
																if($numrows == 0){
														         echo ' <div class="col-md-offset-3 col-md-9">
																	<button id="btn-signup" type="button" class="btn btn-error"><i class="icon-hand-right"></i>Invalid! You Have Not Created Any Group Yet! </button>
                                         
																	</div>';
																}
																else{
																	while($record = mysql_fetch_array($grps)){
																		
																			echo ' <option value="'.$record['group_id'].'">'.$record['name'].'</option>';
																	}
																}
														
						 
													?>    
												</select>
											</div>
						</div>
						<br/> 
						<div class="form-group">
							<label class="control-label col-md-3 col-sm-3 col-xs-3" for="first-name">Upload CSV/Excel File: <span class="required"> </span></label>
								<div class="col-md-4 col-sm-4 col-xs-5">
										<input type="file" name="file" id="file" required="required"  class="form-control col-md-3 col-xs-3" >
								</div>
                      </div>
					 
					   <br/> <br/>
					   <div class="form-group">
							<div class="col-md-6 col-sm-6 col-xs-12 col-md-offset-3">
								<input type="reset"  class="btn btn-primary" name="cancel" value="Cancel" />
								<input type="submit"  class="btn btn-success" name="Upload_Data" value="Upload File"/>
							</div>
                      </div>
			  </form>
				<?php
					if(isset($_POST['send'])) {
						$name= $_POST['name'];
						$desc= $_POST['desc'];
						if($name != null){
							$sql1 = mysql_query("select * from airtime_groups where customer_id='$session_id' and name='$name'");
							$numrows = mysql_num_rows($sql1);
				if($numrows > 0){
					 echo ' <div class="col-md-offset-3 col-md-9">
                      <button id="btn-signup" type="button" class="btn btn-error"><i class="icon-hand-right"></i> This Group Exists! Create a Different Group!</button>
                                         
                    </div>';
				}else{
					$sql =mysql_query("insert into airtime_groups values('', '$session_id', '$name','$desc')");
					if($sql){
						$qry = mysql_query("select * from airtime_logs where id='$session_lid' ");
								$sdata=mysql_fetch_array($qry);
												
									if($sdata['user_actions'] == ""){
										mysql_query("update airtime_logs set user_actions='Created a new group, name - $name.' where id='$session_lid'  ");
											?>
												<script>
													alert("Group Successfully Created.");
												</script>
											<?php
												}else{
													$actions=$sdata['user_actions'];
													mysql_query("update airtime_logs set user_actions='$actions Created a new group, name - $name.' where id='$session_lid'  ");
													?>
														<script>
															alert("Group Successfully Created.");
														</script>
													<?php
												}
						
					}else{
						?>
								<script>
										alert("Error creating this Group. Please try Again.");
										window.location="creategroup.php";
								</script>
						<?php
					}
				}
				
			}
		}
		
		?>
		  <?php// include("newgroup.php"); ?>
		 
		  
		  </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>
	
		  
		  