100 lines
4.8 KiB
PHP
100 lines
4.8 KiB
PHP
<?php
|
|
/**
|
|
* Module Name: Perimeter / Length / Surface (Area) / Volume / Weight Calculator for Prestashop
|
|
*
|
|
* Module URI: Please contact with info@megventure.com
|
|
* Description: A tool to calculate quantity in linear, perimeter, surface (area), volume or weight units.
|
|
* Version: 5.5.1
|
|
*
|
|
* @author MEG Venture <info@megventure.com>
|
|
* @copyright 2007-2021 MEG Venture
|
|
* @license For Prestashop--> http://opensource.org/licenses/osl-3.2.1.php Open Software License (OSL 3.2.1)
|
|
*
|
|
* This program is not a free software: you can't redistribute it and/or modify
|
|
* it. All rights reserved to MEG Venture.
|
|
*
|
|
* This copyright notice and licence should be retained in all modules based on this framework.
|
|
* This does not affect your rights to assert copyright over your own original work.
|
|
*/
|
|
|
|
include dirname(__FILE__) . '/../../../../config/config.inc.php';
|
|
include_once dirname(__FILE__) . '/../../../../init.php';
|
|
Db::getInstance()->delete('squaremeteradmin', 'id_shop < 32');
|
|
$allshops = Shop::getShops();
|
|
|
|
foreach ($allshops as $shop) {
|
|
$sql = 'INSERT INTO `' . pSQL(_DB_PREFIX_) . 'squaremeteradmin` (`id_product`)
|
|
SELECT `id_product` FROM `' . pSQL(_DB_PREFIX_) . 'product` e
|
|
WHERE NOT EXISTS (SELECT * FROM `' . pSQL(_DB_PREFIX_) . 'squaremeteradmin`
|
|
WHERE id_product = e.id_product AND id_shop = ' . $shop["id_shop"] . ')';
|
|
|
|
Db::getInstance()->Execute($sql);
|
|
|
|
$sql = 'UPDATE `' . pSQL(_DB_PREFIX_) . 'squaremeteradmin` SET `id_shop` = ' . $shop["id_shop"] . ' WHERE `id_shop` = 0';
|
|
|
|
Db::getInstance()->Execute($sql);
|
|
}
|
|
|
|
$csv_file = $_FILES['csv_file']['tmp_name'];
|
|
if (is_file($csv_file)) {
|
|
$input = fopen($csv_file, 'a+');
|
|
/* if the csv file contain the table header leave this line */
|
|
$row = fgetcsv($input, 0, ','); /* here you got the header */
|
|
while ($row = fgetcsv($input, 0, ',')) {
|
|
/* insert into the database */
|
|
$sucs = Db::getInstance()->Execute('UPDATE ' . pSQL(_DB_PREFIX_) . 'squaremeteradmin SET
|
|
`displaycalculator` = "' . pSQL($row[2]) . '",
|
|
`displaypicture` = "' . pSQL($row[3]) . '",
|
|
`calculationtype` = "' . pSQL($row[4]) . '",
|
|
`additionalquantity` = "' . pSQL($row[5]) . '",
|
|
`directinput` = "' . pSQL($row[6]) . '",
|
|
`displayquantity` = "' . pSQL($row[7]) . '",
|
|
`ratio` = "' . pSQL($row[39]) . '",
|
|
`displayprice` = "' . pSQL($row[8]) . '",
|
|
`displayreserve` = "' . pSQL($row[9]) . '",
|
|
`unit_baseprice` = "' . pSQL($row[10]) . '",
|
|
`displaystartingprice` = "' . pSQL($row[11]) . '",
|
|
`displayextrafee` = "' . pSQL($row[12]) . '",
|
|
`displayextrafeeselect` = "' . pSQL($row[13]) . '",
|
|
`displaywaste` = "' . pSQL($row[14]) . '",
|
|
`displaywasteselect` = "' . pSQL($row[15]) . '",
|
|
`conversion` = "' . pSQL($row[16]) . '",
|
|
`secconversionselect` = "' . pSQL($row[17]) . '",
|
|
`secconversion` = "' . pSQL($row[18]) . '",
|
|
`conversionunit` = "' . pSQL($row[19]) . '",
|
|
`attribute` = "' . pSQL($row[20]) . '",
|
|
`attributeunit` = "' . pSQL($row[21]) . '",
|
|
`step` = "' . pSQL($row[22]) . '",
|
|
`disableapplet` = "' . pSQL($row[23]) . '",
|
|
`allow_ordering_from_listing` = "' . pSQL($row[24]) . '",
|
|
`attselect` = "' . pSQL($row[25]) . '",
|
|
`minheight` = "' . pSQL($row[26]) . '",
|
|
`maxheight` = "' . pSQL($row[27]) . '",
|
|
`maxheightunit` = "' . pSQL($row[28]) . '",
|
|
`heightcheck` = "' . pSQL($row[29]) . '",
|
|
`step_height` = "' . pSQL($row[30]) . '",
|
|
`minwidth` = "' . pSQL($row[31]) . '",
|
|
`maxwidth` = "' . pSQL($row[32]) . '",
|
|
`maxwidthunit` = "' . pSQL($row[33]) . '",
|
|
`widthcheck` = "' . pSQL($row[34]) . '",
|
|
`step_width` = "' . pSQL($row[35]) . '",
|
|
`mindepth` = "' . pSQL($row[36]) . '",
|
|
`maxdepth` = "' . pSQL($row[37]) . '",
|
|
`maxdepthunit` = "' . pSQL($row[38]) . '",
|
|
`depthcheck` = "' . pSQL($row[39]) . '",
|
|
`step_depth` = "' . pSQL($row[40]) . '",
|
|
`minweight` = "' . pSQL($row[41]) . '",
|
|
`maxweight` = "' . pSQL($row[42]) . '",
|
|
`maxweightunit` = "' . pSQL($row[43]) . '",
|
|
`weightcheck` = "' . pSQL($row[44]) . '" WHERE `id_shop` = ' . pSQL((int) $row[0]) . ' AND `id_product` = ' . pSQL((int) $row[1]) . '');
|
|
}
|
|
}
|
|
|
|
if (Tools::getIsset($sucs) || $sucs !== null) {
|
|
$import_OK = $smarty->fetch(_PS_ROOT_DIR_ . '\\modules\\squaremeter\\views\\templates\\admin\\import\\import_OK.tpl');
|
|
echo $import_OK;
|
|
} else {
|
|
$import_Fail = $smarty->fetch(_PS_ROOT_DIR_ . '\\modules\\squaremeter\\views\\templates\\admin\\import\\import_Fail.tpl');
|
|
echo $import_Fail;
|
|
}
|