";print_r($csvMimes);die;
if(!empty($_FILES['csv_file']['name']) && in_array($_FILES['csv_file']['type'], $csvMimes)){
$curTime = date('Y-m-d');
$destination_file = $_FILES["csv_file"]["name"]."_".$curTime.".csv";
//$destination_file = "/ubr_inventory/in_files/".$storagename;
//move_uploaded_file($target_file,$destination_file);
$target_file = $_FILES['csv_file']['tmp_name'];
$store_code = $_REQUEST['store_code'];
$csvArr = parse_csv_file($target_file);
$cntCsvArr = count($csvArr);
echo "==ff=";
//print_r($csvArr);die;
move_uploaded_file($_FILES["csv_file"]["tmp_name"], "ubr_inventory/in_files/" . $destination_file);
//if(is_uploaded_file($_FILES['csv_file']['tmp_name'])) {
$obj->query("DELETE FROM `dordsh_inv_automnup` WHERE `store_id` LIKE '$store_code'");
//}
foreach($csvArr as $csvArrs) {
$lookup_code=$csvArrs['sku_id'];
$storeIdStr = explode('-',$store_code);
$storeId = $storeIdStr[0];
$store_identifier=$storeId;
$price=$csvArrs['price'];
$item_name=mysqli_real_escape_string($GLOBALS['conn'],$csvArrs['name']);
$cost_unit=$csvArrs['cost_unit'];
$size=$csvArrs['size'];
$available=$csvArrs['is_active'];
$par_weight=$csvArrs['is_weighted_item'];
$is_alcohol=$csvArrs['is_alcohol'];
$department=mysqli_real_escape_string($GLOBALS['conn'],$csvArrs['department']);
$aisle=mysqli_real_escape_string($GLOBALS['conn'],$csvArrs['aisle']);
$item_details=mysqli_real_escape_string($GLOBALS['conn'],$csvArrs['description']);
$remote_image_URL=mysqli_real_escape_string($GLOBALS['conn'],$csvArrs['image_URL']);
$createdAT = date('Y-m-d_H:i:s');
$updatedAT = date('Y-m-d_H:i:s');
$catIdSql = $obj->query("SELECT id,parent_id,maincategory FROM `tbl_maincategory` WHERE `maincategory` LIKE '$department'");
$catIdArr=$obj->fetchNextObject($catIdSql);
$mainCategory =$catIdArr->id;
$subcatIdSql = $obj->query("SELECT id,parent_id,maincategory FROM `tbl_maincategory` WHERE `maincategory` LIKE '$aisle'");
$subcatIdArr=$obj->fetchNextObject($subcatIdSql);
$subCategory =$subcatIdArr->id;
//echo "==ff=";
//print_r($catIdArr);
//print_r($subcatIdArr);
//die;
//echo "==ff=";
//print_r($csvArr);
if($cntCsvArr > 0 && $storeId !="" ) {
echo $insSql = "INSERT INTO dordsh_inv_automnup set sku_id='$lookup_code', store_id='$store_code',price='$price',name='$item_name'
,cost_unit='$cost_unit',size='$size',is_active='$available',is_weighted_item='$par_weight',department='$department'
,aisle='$aisle',description='$item_details',image_URL='$remote_image_URL',store_identifier='$storeId',create_at='$createdAT',updtaed_at='$updatedAT'
,cat_id='$mainCategory',subcat_id='$subCategory' ";
}
$obj->query($insSql);
//die;
}
/*$sql = "INSERT INTO `caubff_inventory_sync_20250106` (`id`, `lookup_code`, `store_identifier`, `price`, `brand_name`, `
item_name`, `cost_unit`, `size`, `size_uom`, `balance_on_hand`, `available`, `
par_weight`, `department`, `aisle`, `item_details`, `remote_image_URL`,
`additional_images_url`, `store_id`, `create_at`, `updtaed_at`, `status`, `ubr_store_id`)";*/
$_SESSION['sess_msg'] = "File processed successfully!".'
';
header("location:ddautom_ffupldprs.php");
exit;
//echo "==ff=";
//print_r($csvArr);
//die;
} else {
$_SESSION['sess_msg'] = "Invalid csv file.Please upload valid csv file!".'
';
header("location:ddautom_ffupldprs.php");
exit;
}
}
function parse_csv_file($csvfile) {
$csv = Array();
$rowcount = 0;
if (($handle = fopen($csvfile, "r")) !== FALSE) {
$max_line_length = defined('MAX_LINE_LENGTH') ? MAX_LINE_LENGTH : 100000;
$header = fgetcsv($handle, $max_line_length);
$header = str_replace(' ', '_', $header);
$header = str_replace('/', '_', $header);
$header_colcount = count($header);
while (($row = fgetcsv($handle, $max_line_length)) !== FALSE) {
$row_colcount = count($row);
if ($row_colcount == $header_colcount) {
$entry = array_combine($header, $row);
$csv[] = $entry;
}
else {
error_log("csvreader: Invalid number of columns at line " . ($rowcount + 2) . " (row " . ($rowcount + 1) . "). Expected=$header_colcount Got=$row_colcount");
return null;
}
$rowcount++;
}
//echo "Totally $rowcount rows found\n";
fclose($handle);
}
else {
error_log("csvreader: Could not read CSV \"$csvfile\"");
return null;
}
return $csv;
}
?>
<?php echo SITE_TITLE; ?>
 Admin: DoDash
|
|
|
|
|