<?php
include('./dbconnect.php');
$dbconnect = new dbconnect;
$db = $dbconnect->connect();

$file_name = "./customer_data.csv";
$is_exist  = file_exists($file_name);
if($is_exist){
	if(($handle = fopen($file_name, 'r')) !== FALSE){
		$data = fgetcsv($handle);
		$count = 0;
		$In_count = 0;
		while(($data = fgetcsv($handle)) !== FALSE){
			
			$customer_name  = $data[0];
			$phone_number   = $data[1];
			$alt_number     = $data[2];
			$land_line      = $data[3];
			$cust_email     = $data[4];
			$cust_address   = $data[5];
			$city           = $data[6];
			$state          = $data[7];
			$dob            = $data[8];
			$cust_type      = $data[9];
			$referral_type  = $data[10];
			$allow_contract = $data[11];
			$cust_sts       = $data[12];
			$includ_gst     = $data[13];
			$cust_zone      = $data[14];
			$csut_gst       = $data[15];
			$csut_pan       = $data[16];
			if(is_numeric($phone_number)){				
				$qry_info = mysql_query("SELECT * FROM sblt_customers where phone_number = '$phone_number'");
				$qry_count = mysql_num_rows($qry_info);
				if((int)$qry_count === 0){
					$count++;
					
					if($dob){
						$dob = date('Y-m-d',strtotime($dob));
					}
					$created_date  = date("Y-m-d H:i:s");
					$cust_address = str_replace("'","",$cust_address);
					if($includ_gst === "1"){
						$includ_gst = "1";
					}else{
						$includ_gst = "0";
					}
					if($dob === ""){
						$cust_qry = "INSERT INTO sblt_customers(cust_id,customer_name,phone_number,alt_number,land_line,cust_email,cust_address,city,state,dob,referral_type,allow_contract,cust_sts,includ_gst,cust_zone,csut_gst,csut_pan,deleted,created_by,created_date,updated_by,updated_date,deleted_by,deleted_date) VALUES (null,'$customer_name','$phone_number','$alt_number','$land_line','$cust_email','$cust_address','$city','$state',null,'$referral_type','$allow_contract','$cust_sts','$includ_gst','$cust_zone','$csut_gst','$csut_pan','0','1','$created_date',null,null,null,null)";
					}else{
						$cust_qry = "INSERT INTO sblt_customers(cust_id,customer_name,phone_number,alt_number,land_line,cust_email,cust_address,city,state,dob,referral_type,allow_contract,cust_sts,includ_gst,cust_zone,csut_gst,csut_pan,deleted,created_by,created_date,updated_by,updated_date,deleted_by,deleted_date) VALUES (null,'$customer_name','$phone_number','$alt_number','$land_line','$cust_email','$cust_address','$city','$state','$dob','$referral_type','$allow_contract','$cust_sts','$includ_gst','$cust_zone','$csut_gst','$csut_pan','0','1','$created_date',null,null,null,null)";
					}
					
					mysql_query($cust_qry);
					echo "$count :: $cust_qry <br/>==============<br/>";
				}else{
					$In_count++;
					echo "$In_count :: Already Inserted<br/>";
				}
			}
			
		}
	}
}else{
	echo "Not exist";
}
?>