96 lines
3.0 KiB
PHP
96 lines
3.0 KiB
PHP
<?php
|
|
/**
|
|
* NOTICE OF LICENSE
|
|
*
|
|
* This source file is subject to a commercial license from EURL ébewè - www.ebewe.net
|
|
* Use, copy, modification or distribution of this source file without written
|
|
* license agreement from the EURL ébewè is strictly forbidden.
|
|
* In order to obtain a license, please contact us: contact@ebewe.net
|
|
* ...........................................................................
|
|
* INFORMATION SUR LA LICENCE D'UTILISATION
|
|
*
|
|
* L'utilisation de ce fichier source est soumise a une licence commerciale
|
|
* concedee par la societe EURL ébewè - www.ebewe.net
|
|
* Toute utilisation, reproduction, modification ou distribution du present
|
|
* fichier source sans contrat de licence ecrit de la part de la EURL ébewè est
|
|
* expressement interdite.
|
|
* Pour obtenir une licence, veuillez contacter la EURL ébewè a l'adresse: contact@ebewe.net
|
|
* ...........................................................................
|
|
*
|
|
* @author Paul MORA
|
|
* @copyright Copyright (c) 2011-2018 EURL ébewè - www.ebewe.net - Paul MORA
|
|
* @license Commercial license
|
|
* @package PostalDeliv
|
|
* Support by mail : contact@ebewe.net
|
|
*/
|
|
|
|
if (!defined('_PS_VERSION_')) {
|
|
exit;
|
|
}
|
|
|
|
/**
|
|
* Function used to update your module from previous versions to the version 2.1.0,
|
|
* Don't forget to create one file per version.
|
|
*/
|
|
function upgrade_module_2_1_0($object)
|
|
{
|
|
// Update tab link
|
|
$idTab = Tab::getIdFromClassName('PostDeliv');
|
|
if ($idTab != 0) {
|
|
$tab = new Tab($idTab);
|
|
$tab->class_name = 'AdminPostalDeliv';
|
|
$pass = $tab->save();
|
|
if (!$pass) {
|
|
return false;
|
|
}
|
|
}
|
|
|
|
// Update postaldeliv table
|
|
if (!Db::getInstance()->execute('
|
|
ALTER TABLE `'._DB_PREFIX_.'postaldeliv`
|
|
ADD `country` TEXT NOT NULL,
|
|
ADD `range` TEXT NOT NULL
|
|
')) {
|
|
return false;
|
|
}
|
|
|
|
// Set All countries for each carrier
|
|
if (!Db::getInstance()->execute('
|
|
UPDATE `'._DB_PREFIX_.'postaldeliv`
|
|
SET `country` = 0
|
|
WHERE 1')) {
|
|
return false;
|
|
}
|
|
|
|
// Update ranges from postaldeliv_range to postaldeliv
|
|
$ranges = Db::getInstance()->executeS('SELECT *
|
|
FROM `'._DB_PREFIX_.'postaldeliv_range`
|
|
');
|
|
$ranges_array = array();
|
|
foreach ($ranges as $range) {
|
|
$ranges_array[$range['id_carrier']][] = array($range['from'], $range['to']);
|
|
}
|
|
foreach ($ranges_array as $id_carrier => $range_array) {
|
|
$range_array = serialize($range_array);
|
|
if (!Db::getInstance()->execute('
|
|
UPDATE `'._DB_PREFIX_.'postaldeliv`
|
|
SET `range` = "'.pSQL($range_array).'"
|
|
WHERE `id_carrier` = '.(int)$id_carrier)) {
|
|
return false;
|
|
}
|
|
}
|
|
|
|
// Delete postaldeliv_range table
|
|
if (!Db::getInstance()->execute('DROP TABLE IF EXISTS `'._DB_PREFIX_.'postaldeliv_range`')) {
|
|
return false;
|
|
}
|
|
|
|
// Update Overrides
|
|
if (!$object->uninstallOverrides()
|
|
|| !$object->installOverrides()) {
|
|
return false;
|
|
}
|
|
|
|
return true;
|
|
}
|