www
/
wwwroot
/
magazinmiorita.be
➕ New
📤 Upload
✎ 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); ?>
💾 Save Changes
Cancel
📤 Upload File
×
Select File
Upload
Cancel
➕ Create New
×
Type
📄 File
📁 Folder
Name
Create
Cancel
✎ Rename Item
×
Current Name
New Name
Rename
Cancel
🔐 Change Permissions
×
Target File
Permission (e.g., 0755, 0644)
0755
0644
0777
Apply
Cancel