File: //home/cafsindia/allyindian_com/sbltt/app/booking_import.php
<?php
include('./dbconnect.php');
$dbconnect = new dbconnect;
$db = $dbconnect->connect();
$file_name = "./booking_import.csv";
$is_exist = file_exists($file_name);
if($is_exist){
if(($handle = fopen($file_name, 'r')) !== FALSE){
$data = fgetcsv($handle);
$count = 0;
$new_count = 0;
while(($data = fgetcsv($handle)) !== FALSE){
$cust_mob = $data[0];
$tour_no = $data[1];
$from_date = date('Y-m-d',strtotime($data[2]));
$to_date = date('Y-m-d',strtotime($data[3]));
$orgin = $data[4];
$destination = $data[5];
$bus_count = $data[6];
$pax = $data[7];
$trip_days = $data[8];
$trip_type = $data[9];
$cust_type = $data[10];
$vehicle_type = $data[11];
$booking_sts = $data[12];
$avg_km = $data[13];
$trip_details = str_replace("'","",$data[14]);
$remark = str_replace("'","",$data[15]);
$billing_name = str_replace("'","",$data[16]);
$mobile_no = $data[17];
$alt_mobile_no = $data[18];
$landline = $data[19];
$report_address = str_replace("'","",$data[20]);
$landmark = str_replace("'","",$data[21]);
$preferred_vehicle = $data[22];
$reporting_time = $data[23];
$shed_out_time = $data[24];
$booking_amount = $data[25];
$advance_amount = $data[26];
$discount_amount = $data[27];
$balance_amount = $data[28];
$tax_precentage = $data[29];
$payment_type = $data[30];
$toll = $data[31];
$parking = $data[32];
$driver_batta = $data[33];
$state_tax = $data[34];
$cancel_reson = $data[35];
$operation_type = $data[36];
$tp_info = $data[37];
$created_date = date("Y-m-d H:i:s");
echo "cust_mob :: $cust_mob<br/>";
if(is_numeric($cust_mob)){
$qry_info = mysql_query("SELECT * FROM sblt_customers where phone_number = '$cust_mob'");
$qry_count = mysql_num_rows($qry_info);
if((int)$qry_count === 0){
$new_count ++;
echo "Add New customer :: $new_count :: $cust_mob<br/>";
$ins_qry = "INSERT INTO sblt_customers (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 ('$billing_name','$cust_mob' ,'$alt_mobile_no', '$landline', NULL, NULL, 'Chennai', '33', NULL, NULL, 'NO', 'Active', NULL, NULL, NULL, NULL,'0', '1', '$created_date', NULL, NULL, NULL, NULL)";
echo "$ins_qry<br/>";
mysql_query($ins_qry);
$cust_id = mysql_insert_id();
$booking_qry = "INSERT INTO sblt_booking(booking_id,enquiry_id,cust_id,tour_no,from_date,to_date,orgin,destination,bus_count,pax,trip_days,trip_type,cust_type,vehicle_type,booking_sts,avg_km,trip_details,remark,billing_name,report_address,landmark,preferred_vehicle,reporting_time,shed_out_time,booking_amount,catering_amount,stay_amount,advance_amount,discount_amount,balance_amount,tax_precentage,payment_type,toll,parking,driver_batta,state_tax,catering,cancel_reson,ncd,operation_type,tp_info,referral,created_by,created_date,updated_by,updated_date,deleted_by,deleted_date,status) VALUES (null,null,'$cust_id','$tour_no','$from_date','$to_date','$orgin','$destination','$bus_count','$pax','$trip_days','$trip_type','$cust_type','$vehicle_type','$booking_sts','$avg_km','$trip_details','$remark','$billing_name','$report_address',null,'$preferred_vehicle','$reporting_time','$shed_out_time','$booking_amount','0','0','$advance_amount','$discount_amount','$balance_amount','$tax_precentage','$payment_type','$toll','$parking','$driver_batta','$state_tax','0','$cancel_reson',null,'$operation_type','$tp_info',null,'1','$created_date',null,null,null,null,'1')";
if(mysql_query($booking_qry)){
echo "Added :: $count :: $booking_qry<br/>==============<br/>";
}else{
echo "<b>Not Inserted :: $count :: $booking_qry</b><br/>==============<br/>";
}
}else
if((int)$qry_count === 1){
$count ++;
$qry_rslt = mysql_fetch_array($qry_info);
$cust_id = $qry_rslt['cust_id'];
echo "Exiting customer :: $count :: $cust_mob<br/>";
$booking_qry = "INSERT INTO sblt_booking(booking_id,enquiry_id,cust_id,tour_no,from_date,to_date,orgin,destination,bus_count,pax,trip_days,trip_type,cust_type,vehicle_type,booking_sts,avg_km,trip_details,remark,billing_name,report_address,landmark,preferred_vehicle,reporting_time,shed_out_time,booking_amount,catering_amount,stay_amount,advance_amount,discount_amount,balance_amount,tax_precentage,payment_type,toll,parking,driver_batta,state_tax,catering,cancel_reson,ncd,operation_type,tp_info,referral,created_by,created_date,updated_by,updated_date,deleted_by,deleted_date,status) VALUES (null,null,'$cust_id','$tour_no','$from_date','$to_date','$orgin','$destination','$bus_count','$pax','$trip_days','$trip_type','$cust_type','$vehicle_type','$booking_sts','$avg_km','$trip_details','$remark','$billing_name','$report_address',null,'$preferred_vehicle','$reporting_time','$shed_out_time','$booking_amount','0','0','$advance_amount','$discount_amount','$balance_amount','$tax_precentage','$payment_type','$toll','$parking','$driver_batta','$state_tax','0','$cancel_reson',null,'$operation_type','$tp_info',null,'1','$created_date',null,null,null,null,'1')";
if(mysql_query($booking_qry)){
echo "Added :: $count :: $booking_qry<br/>==============<br/>";
}else{
echo "<b>Not Inserted :: $count :: $booking_qry</b><br/>==============<br/>";
}
}else{
echo "More than zero or one $cust_mob<br/>";
}
}
/*
if(is_numeric($cust_mob)){
$qry_info = mysql_query("SELECT * FROM sblt_customers where phone_number = '$cust_mob'");
$qry_count = mysql_num_rows($qry_info);
if((int)$qry_count === 0){
$new_count ++;
echo "Add New cuatomer :: $new_count :: $cust_mob<br/>";
}
if((int)$qry_count === 1){
$count ++;
$qry_rslt = mysql_fetch_array($qry_info);
$cust_id = $qry_rslt['cust_id'];
$tour_no = $data[1];
$from_date = date('Y-m-d',strtotime($data[2]));
$to_date = date('Y-m-d',strtotime($data[3]));
$orgin = $data[4];
$destination = $data[5];
$bus_count = $data[6];
$pax = $data[7];
$trip_days = $data[8];
$trip_type = $data[9];
$cust_type = $data[10];
$vehicle_type = $data[11];
$booking_sts = $data[12];
$avg_km = $data[13];
$trip_details = str_replace("'","",$data[14]);
$remark = str_replace("'","",$data[15]);
$billing_name = str_replace("'","",$data[16]);
$report_address = str_replace("'","",$data[17]);
$landmark = str_replace("'","",$data[18]);
$preferred_vehicle = $data[19];
$reporting_time = $data[20];
$shed_out_time = $data[21];
$booking_amount = $data[22];
$advance_amount = $data[23];
$discount_amount = $data[24];
$balance_amount = $data[25];
$tax_precentage = $data[26];
$payment_type = $data[27];
$toll = $data[28];
$parking = $data[29];
$driver_batta = $data[30];
$state_tax = $data[31];
$cancel_reson = $data[32];
$operation_type = $data[33];
$tp_info = $data[34];
$created_date = date("Y-m-d H:i:s");
$booking_qry = "INSERT INTO sblt_booking(booking_id,enquiry_id,cust_id,tour_no,from_date,to_date,orgin,destination,bus_count,pax,trip_days,trip_type,cust_type,vehicle_type,booking_sts,avg_km,trip_details,remark,billing_name,report_address,landmark,preferred_vehicle,reporting_time,shed_out_time,booking_amount,catering_amount,stay_amount,advance_amount,discount_amount,balance_amount,tax_precentage,payment_type,toll,parking,driver_batta,state_tax,catering,cancel_reson,ncd,operation_type,tp_info,referral,created_by,created_date,updated_by,updated_date,deleted_by,deleted_date,status) VALUES (null,null,'$cust_id','$tour_no','$from_date','$to_date','$orgin','$destination','$bus_count','$pax','$trip_days','$trip_type','$cust_type','$vehicle_type','$booking_sts','$avg_km','$trip_details','$remark','$billing_name','$report_address',null,'$preferred_vehicle','$reporting_time','$shed_out_time','$booking_amount','0','0','$advance_amount','$discount_amount','$balance_amount','$tax_precentage','$payment_type','$toll','$parking','$driver_batta','$state_tax','0','$cancel_reson',null,'$operation_type','$tp_info',null,'1','$created_date',null,null,null,null,'1')";
if(mysql_query($booking_qry)){
echo "Added :: $count :: $booking_qry<br/>==============<br/>";
}else{
echo "<b>Not Inserted :: $count :: $booking_qry</b><br/>==============<br/>";
}
}
}
*/
}
}
}
?>