<?php 
$conn=mysql_connect("localhost","aetholq5_intelli","intel@2017$#") or die("Could not connect");
mysql_select_db("aetholq5_intellilead",$conn) or die("could not connect database");

include('../template/header.php');
 
if(isset($_POST["Import"])){
//print_r($_POST); die;		
		$filename=$_FILES["file"]["tmp_name"];
		$mimes = array('application/vnd.ms-excel','text/csv');
		if(in_array($_FILES['file']['type'],$mimes)){			
		 if($_FILES["file"]["size"] > 0)
		 {
		  	$file = fopen($filename, "r");
	         while (($emapData = fgetcsv($file, 10000, ",")) !== FALSE)
	         {
	    
	        //It wiil insert a row to our leads table from our csv file`
	           $sql = "INSERT into tmp_leads (lead_code,project_name,source,name,email,mobile,phone,city,country,status,tol,tsr,msg,plan_to_buy,contacted_by,msg_date,interested,budget,high_lead,pref_loc,look_for,subject,other_detail,company_id,user_id) 
	            	values('AA','$emapData[0]','$emapData[1]','$emapData[2]','$emapData[3]','$emapData[4]','$emapData[5]','$emapData[6]','$emapData[7]','$emapData[8]','$emapData[9]','$emapData[10]','$emapData[11]','$emapData[12]','$emapData[13]','$emapData[14]','$emapData[15]','$emapData[16]','$emapData[17]','$emapData[18]','$emapData[19]','$emapData[20]','$emapData[21]','".$_SESSION['company_id']."','".$_SESSION['user_id']."')";
	         //we are using mysql_query function. it returns a resource on true else False on error
	          $result = mysql_query( $sql, $conn );
				if(!$result)
				{
					echo "<script type=\"text/javascript\">
							alert(\"Invalid File : Please Upload CSV File.\");
							window.location = \"upload.php\"
						</script>";
				
				}
	         }
	         fclose($file);
	         //throws a message if data successfully imported to mysql database from excel file
	         echo "<script type=\"text/javascript\">
						alert(\"CSV File has been successfully Imported.\");
						window.location = \"upload_lead.php\"
					</script>";
	        
			 
			 //close of connection
			mysql_close($conn); 
				
		 	
			
		 }
		 
		} else {
				  echo "<script type=\"text/javascript\">
							alert(\"Invalid File : Please Upload CSV File.\");
							window.location = \"upload.php\"
						</script>";
	    } 
		 
	}	
?>	
 <!-- page heading start-->
             <div class="panel box-shadow-none content-header">
                  <div class="panel-body">
                    <div class="col-md-12">
                        <h3 class="animated fadeInLeft">Upload Leads</h3>
                        <p class="animated fadeInDown">
                          Leads <span class="fa-angle-right fa"></span>Upload Leads
                        </p>
                    </div>
                  </div>
              </div>
         <!-- page heading end-->
		 
		 <div class="col-md-12">
              <div class="panel">
                  <div class="panel-heading"></div>
                  <div class="panel-body">
                      <div class="row">
					  <form method="post" action="upload.php" enctype="multipart/form-data">
                        <div class="col-lg-6">
                          <div class="input-group fileupload-v1">
                            <input type="file" name="file" class="fileupload-v1-file hidden"/>
                            <input type="text" class="form-control fileupload-v1-path" placeholder="File Path..." disabled>
                            <span class="input-group-btn">
                              <button class="btn fileupload-v1-btn" type="button"><i class="fa fa-folder"></i> Choose File</button>
                            </span>
                          </div><!-- /input-group -->
                        </div><!-- /.col-lg-6 -->
						
						<div class="col-md-3">
                                   <button class="btn ripple btn-raised btn-success" type="submit" name="Import"  >
                                    <div>
                                      <span>Upload Data</span>
                                    </div>
                                  </button>
								  
                              </div>
						 </form>	  
                      </div><!-- /.row -->		  
					 
			  
                  </div>
              </div>              
							
          </div>
		            <div class="col-md-12">						 												 
                        <a class="btn ripple-infinite btn-gradient btn-info" href="SampleLeadFile.csv">
                            <div>
                                <span>Click Here to download Sample data file.</span>
                            </div>
                         </a>                 
						 
				
				
	</div>
					
 <!--body wrapper end-->
<?php include('../template/footer.php');?>