Admin Control Panel v2.0

✎ Editing: convert.php ← Back

<?php 
include("includes/inc.config.php");
$year = date("Y", time());
$month = date("m", time());
$day = date("d", time());

if(isset($_GET['action']) && $_GET['action'] == 'update_items'){
$files = array();
foreach (glob("../POS-Backup/INVENTORIA/Inventoria-Backup-$year-$month-$day/*.csv") as $file) {
  
  $files = file_get_contents($file);
$bkdata = array_map("str_getcsv", preg_split('/\r*\n+|\r+/', $files));

foreach($bkdata as $items){
	$name = urldecode($items[3]);
	$code = $items[0];
	$price = number_format($items[2],2);
	$sku = $items[4];
echo $code." - ".$price." - $files<br />";
	$exist = $database->execute("select * from products where code = '".$code."'");
	if($database->num($exist) == 0){
	#$database->execute("insert into products (`name`, `code`, `price`, `sku`, `status`) values ('".$name."', '".$code."', '".$price."', '".$sku."', '1')");
	}else{
	#$database->execute("update products set `name` = '".$name."', `code` = '".$code."', `price` = '".$price."', `sku` = '".$sku."', `status` = '1' where code = '".$code."'");	
	}
}

}
}else if(isset($_GET['action']) && $_GET['action'] == 'update_sqt'){
	$files = array();
	$csvd_arr = '"Location","Category","Ref","Item","Description","Quantity","Cost Value","Line Total"<br />';	
foreach (glob("Items/*.dat") as $file) {
  
  $files = file_get_contents($file);

parse_str($files, $out);

$i = 0;
$fields= array();
foreach ($out as $key => $value) {
	$fields[$key] = $value;
	$i++;
}

$name = urldecode($fields["Description"]);
	$code = $fields['Name'];
	$newcost = substr_replace($fields["Value"], ".", -2, 0);
	$newstr = substr_replace($fields["Price"], ".", -2, 0);
	$cost = number_format($newcost,2);
	$price = number_format($newstr,2);
	$Measure = $fields["Measure"];
	$sku = $fields["Quantity"];
    
	$arr_inv['Location'] = 'Miorita';
	$arr_inv['Location'] = 'Miorita';
	$arr_inv['Location'] = 'Miorita';
	$arr_inv['Location'] = 'Miorita';
	$arr_inv['Location'] = 'Miorita';
	$arr_inv['Location'] = 'Miorita';
	$arr_inv['Location'] = 'Miorita';
	$arr_inv['Location'] = 'Miorita';
	
$csvd_arr .= '"Miorita","1","'.$code.'","'.$code.'","'.$name.'","'.$sku.'","'.$cost.'","'.$price.'"<br />';
/*	
echo $code." - ".$price." - <br />";
	$exist = $database->execute("select * from products where code = '".$code."'");
	if($database->num($exist) == 0){
	$database->execute("insert into products (`name`, `code`, `price`, `measure`, `sku`, `status`) values ('".$database->sanitize($name)."', '".$code."', '".$price."', '$Measure', '".$sku."', '1')");
	}else{
	$database->execute("update products set `name` = '".$database->sanitize($name)."', `code` = '".$code."', `price` = '".$price."', `measure` = '".$Measure."', `sku` = '".$sku."', `status` = '1' where code = '".$code."'");	
	}

}
}
echo $csvd_arr;
/*
header('Content-Type: application/excel');
header('Content-Disposition: attachment; filename="sample.csv"');
$data = array(
        $csvd_arr
);

$fp = fopen('php://output', 'w');
foreach ( $csvd_arr as $line ) {
    $val = explode(",", $line);
    fputcsv($fp, $val);
}
fclose($fp);
?>

Cancel