format("Y/m/d"); error_reporting(0); //echo "Active ID :".$activeID; //$ext = explode('.', $_FILES['file']['name']); //$allow_ext = array('PNG','png','JPG' ,'jpg','GIF', 'gif'); //$target_path = basename( $_FILES['file']['name']); //$target_path = mysql_real_escape_string($target_path); //$filename = $_FILES['file']['name']; //$fext = pathinfo($filename, PATHINFO_EXTENSION); //$itemCode = $_POST['custID']; $checkIfExist=0; if (isset($_POST["import"])) { $fileName = $_FILES["file"]["tmp_name"]; if ($_FILES["file"]["size"] > 0) { $ext = explode('.', $_FILES['file']['name']); $allow_ext = array('CSV','csv'); $target_path = basename( $_FILES['file']['name']); $target_path = mysql_real_escape_string($target_path); $filename = $_FILES['file']['name']; $fext = pathinfo($filename, PATHINFO_EXTENSION); $itemCode = $_POST['custID']; $duplicate=0; $fileTotal=0; if(!in_array($fext,$allow_ext)){ echo ''; }else { $file = fopen($fileName, "r"); while (($column = fgetcsv($file, 5000, ",")) !== FALSE) { if($column[0] === 'BRAND' || $column[1]==='MODEL'){ }else{ $fileTotal = $fileTotal + 1; //$chkStatus = $column[2]; //if($chkStatus == 'Incoming'){ // $incoming = 1 ; //}else { // $incoming = 0 ; //} $chkStatus = $column[2]; $chkStatusNew = "Available"; if($chkStatus === 'DEMO' || $chkStatus === 'Demo' || $chkStatus === 'demo'){ $ZeorOrOne = 0; $chkStatusNew = "Demo"; }else { $chkOneOrZero = $column[10]; if($chkOneOrZero == '1'){ $chkStatusNew = "Incoming"; $ZeorOrOne = 1; }else { $ZeorOrOne = 0; } } if(TRIM($column[16]== 1)){ $chkStatusNew = "Reserved"; } if(TRIM($column[7]!='')){ $inventoryDate=$column[7]; $invDate = date("Y/m/d", strtotime($inventoryDate)); }else{ $invDate = $toDate; } $chkBrand = TRIM($column[0]);//NISSAN $chkModel = TRIM($column[1]);//ALMERA $chkColor = TRIM($column[6]);//ALPINE WHITE $chkBrandIfExist = mysql_result(mysql_query("SELECT COUNT('b_id') FROM `vts_brands` WHERE `b_name` LIKE '%$chkBrand%'"),0); $chkModelIfExist = mysql_result(mysql_query("SELECT COUNT('m_id') FROM `vts_model` WHERE `m_name` LIKE '%$chkModel%'"),0); $chkColorIfExist = mysql_result(mysql_query("SELECT COUNT('c_id') FROM `vts_colors` WHERE `c_name` LIKE '%$chkColor%'"),0); if($chkBrandIfExist === '0'){ $sqlInsertB = "INSERT into vts_brands(`b_name`, `b_desc`, `b_status`, `date`, `group_brand`) values ('".TRIM($column[0])."','ALL ".$column[0]." PRODUCTS','1','".$toDate ."', 'Yes')"; mysqli_query($conn, $sqlInsertB); } if($chkModelIfExist == 0){ $brandID = mysql_result(mysql_query("SELECT `b_id` FROM `vts_brands` WHERE `b_name`='$chkBrand'"),0); $sqlInsertM = "INSERT into vts_model(`m_name`, `m_desc`, `b_id`, `m_status`, `date`,`brand_id`) values ('".TRIM($column[1])."','ALL ".$column[1]." VARIANT','".$brandID."','1','".$toDate ."', '".$brandID."')"; mysqli_query($conn, $sqlInsertM); } if($chkColorIfExist == 0){ $sqlInsertC = "INSERT into vts_colors(`C_name`, `C_desc`, `C_status`, `date`) values ('".TRIM($column[6])."','".$column[6]."','1','".$toDate ."')"; mysqli_query($conn, $sqlInsertC); } $srpPrice = str_replace(',', '', $column[11]); $disPrice = str_replace(',', '', $column[12]); $comPrice = str_replace(',', '', $column[13]); $myCSNumber = TRIM($column[3]); $myBrand = TRIM($column[0]); $checkIfExist = mysql_result(mysql_query("SELECT COUNT(id) FROM `db_vehicle_inventory` WHERE `cs_number` LIKE '%$myCSNumber%' AND `returned` = 0 AND `brand`='$myBrand'"),0); if($checkIfExist > 0 ){ $duplicate = $duplicate + 1; }else{ mysql_query("INSERT into db_vehicle_inventory(`brand`, `brand_code`, `status`, `cs_number`, `year_model`, `description`, `color`, `date_received`, `selling_dealer`, `remarks`, `incoming_unit`, `price`, `discount`, `commission`,`company`,`dealer`, `reserved`) values ('".TRIM($column[0])."','".TRIM($column[1])."','".$chkStatusNew."','".TRIM($column[3])."','".TRIM($column[4])."','".TRIM($column[5])."','".TRIM($column[6])."','".$invDate."','".$column[8]."','".$column[9]."','".$ZeorOrOne."','".$srpPrice."','".$disPrice."','".$comPrice."','".$column[14]."','".$column[15]."','".$column[16]."')"); //$result = mysqli_query($conn, $sqlInsert); } //echo ""; } } $AddedFile = $fileTotal - $duplicate; // if($type === 'success'){ echo ''; //}else{ // echo ''; //} } } } ?>

1 && $upLoad==1){echo "

".$uploadCount." Records has been uploaded

";}else{}?>