编辑文件 - install-1.1.0.php

✏️ 正在编辑: install-1.1.0.php

路径: /home/bpioifn/www/pigmentse/modules/axepta/upgrade/install-1.1.0.php
提示: 您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。

<?php

/**
 * 1961-2020 BNP Paribas
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0) that is available
 * through the world-wide-web at this URL: http://www.opensource.org/licenses/OSL-3.0
 * If you are unable to obtain it through the world-wide-web, please send an email
 * to modules@quadra-informatique.fr so we can send you a copy immediately.
 *
 *  @author    Quadra Informatique <modules@quadra-informatique.fr>
 *  @copyright 1961-2020 BNP Paribas
 *  @license   http://opensource.org/licenses/afl-3.0.php  Academic Free License (AFL 3.0)
 */

if (!defined('_PS_VERSION_')) {
    exit;
}

require_once _PS_MODULE_DIR_ . 'axepta/classes/AxeptaLogger.php';

function upgrade_module_1_1_0($module)
{
    AxeptaLogger::log('Start', AxeptaLogger::LOG_DEBUG , AxeptaLogger::FILE_DEBUG);

// set secure_exemption
    // set secure_exemption_amount
    // set all account into secure mode
    $data = [
        [
            'query' => ['table' => 'axepta_configuration_account', 'column' => 'secure_exemption'],
            'sql' => 'axepta_configuration_account` CHANGE `secure` `secure_exemption` tinyint(1)'
        ],
        [
            'query' => ['table' => 'axepta_configuration_account', 'column' => 'secure_exemption_amount'],
            'sql' => 'axepta_configuration_account` ADD `secure_exemption_amount` FLOAT AFTER `secure_exemption`'
        ],
    ];

$sqlQueries = [];

foreach ($data as $datum) {
        $query = '
            SELECT * FROM INFORMATION_SCHEMA.COLUMNS
            WHERE COLUMN_NAME= "' . $datum['query']['column'] . '"
            AND TABLE_NAME= "'._DB_PREFIX_ . $datum['query']['table'] .'"
            AND TABLE_SCHEMA = "'._DB_NAME_.'"
        ';
        if (!Db::getInstance()->ExecuteS($query)) {
            $sqlQueries[] = 'ALTER TABLE `' . _DB_PREFIX_. $datum['sql'];
        }
    }

if (!empty($sqlQueries)) {
        $sqlQueries[] = 'UPDATE `'._DB_PREFIX_. 'axepta_configuration_account` SET `secure_exemption` = 0 WHERE `secure_exemption` = 1';
    }

$query = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'axepta_iso_country` (
        `id_country` INT(10) UNSIGNED NOT NULL,
        `name` VARCHAR(64) NOT NULL,
        `iso_code_2` VARCHAR(3) NOT NULL,
        `iso_code_3` VARCHAR(3) NOT NULL,
        `num_code` INT(10) NOT NULL,
        `latitude` INT(10) NOT NULL,
        `longitude` INT(10) NOT NULL,
        PRIMARY KEY (`id_country`)
    ) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utf8';
    if (Db::getInstance()->execute($query) == false) {
        return false;
    }

$query = 'SELECT * FROM `' . _DB_PREFIX_ . 'axepta_iso_country` WHERE `id_country` = 1';
    if (!Db::getInstance()->ExecuteS($query)) {
        $sqlQueries[] = "INSERT INTO `" . _DB_PREFIX_ . "axepta_iso_country` (`id_country`, `name`, `iso_code_2`, `iso_code_3`, `num_code`, `latitude`, `longitude`) VALUES 
            ('231','Afghanistan','AF','AFG','4','33','65'),
            ('230','Albania','AL','ALB','8','41','20'),
            ('38','Algeria','DZ','DZA','12','28','3'),
            ('39','American Samoa','AS','ASM','16','-14.3333','-170'),
            ('40','Andorra','AD','AND','20','42.5','1.6'),
            ('41','Angola','AO','AGO','24','-12.5','18.5'),
            ('42','Anguilla','AI','AIA','660','18.25','-63.1667'),
            ('232','Antarctica','AQ','ATA','10','-90','0'),
            ('43','Antigua and Barbuda','AG','ATG','28','17.05','-61.8'),
            ('44','Argentina','AR','ARG','32','-34','-64'),
            ('45','Armenia','AM','ARM','51','40','45'),
            ('46','Aruba','AW','ABW','533','12.5','-69.9667'),
            ('24','Australia','AU','AUS','36','-27','133'),
            ('2','Austria','AT','AUT','40','47.3333','13.3333'),
            ('47','Azerbaijan','AZ','AZE','31','40.5','47.5'),
            ('48','Bahamas','BS','BHS','44','24.25','-76'),
            ('49','Bahrain','BH','BHR','48','26','50.55'),
            ('50','Bangladesh','BD','BGD','50','24','90'),
            ('51','Barbados','BB','BRB','52','13.1667','-59.5333'),
            ('52','Belarus','BY','BLR','112','53','28'),
            ('3','Belgium','BE','BEL','56','50.8333','4'),
            ('53','Belize','BZ','BLZ','84','17.25','-88.75'),
            ('54','Benin','BJ','BEN','204','9.5','2.25'),
            ('55','Bermuda','BM','BMU','60','32.3333','-64.75'),
            ('56','Bhutan','BT','BTN','64','27.5','90.5'),
            ('34','Bolivia','BO','BOL','68','-17','-65'),
            ('233','Bosnia and Herzegovina','BA','BIH','70','44','18'),
            ('57','Botswana','BW','BWA','72','-22','24'),
            ('234','Bouvet Island','BV','BVT','74','-54.4333','3.4'),
            ('58','Brazil','BR','BRA','76','-10','-55'),
            ('235','British Indian Ocean Territory','IO','IOT','86','-6','71.5'),
            ('59','Brunei','BN','BRN','96','4.5','114.6667'),
            ('236','Bulgaria','BG','BGR','100','43','25'),
            ('60','Burkina Faso','BF','BFA','854','13','-2'),
            ('62','Burundi','BI','BDI','108','-3.5','30'),
            ('63','Cambodia','KH','KHM','116','13','105'),
            ('64','Cameroon','CM','CMR','120','6','12'),
            ('4','Canada','CA','CAN','124','60','-95'),
            ('65','Cape Verde','CV','CPV','132','16','-24'),
            ('237','Cayman Islands','KY','CYM','136','19.5','-80.5'),
            ('66','Central African Republic','CF','CAF','140','7','21'),
            ('67','Chad','TD','TCD','148','15','19'),
            ('68','Chile','CL','CHL','152','-30','-71'),
            ('5','China','CN','CHN','156','35','105'),
            ('238','Christmas Island','CX','CXR','162','-10.5','105.6667'),
            ('239','Cocos (Keeling), Islands','CC','CCK','166','-12.5','96.8333'),
            ('69','Colombia','CO','COL','170','4','-72'),
            ('70','Comoros','KM','COM','174','-12.1667','44.25'),
            ('72','Congo','CG','COG','178','-1','15'),
            ('71','Congo, the Democratic Republic of the','CD','COD','180','0','25'),
            ('240','Cook Islands','CK','COK','184','-21.2333','-159.7667'),
            ('73','Costa Rica','CR','CRI','188','10','-84'),
            ('32','Ivory Coast','CI','CIV','384','8','-5'),
            ('74','Croatia','HR','HRV','191','45.1667','15.5'),
            ('75','Cuba','CU','CUB','192','21.5','-80'),
            ('76','Cyprus','CY','CYP','196','35','33'),
            ('16','Czech Republic','CZ','CZE','203','49.75','15.5'),
            ('20','Denmark','DK','DNK','208','56','10'),
            ('77','Djibouti','DJ','DJI','262','11.5','43'),
            ('78','Dominica','DM','DMA','212','15.4167','-61.3333'),
            ('79','Dominican Republic','DO','DOM','214','19','-70.6667'),
            ('81','Ecuador','EC','ECU','218','-2','-77.5'),
            ('82','Egypt','EG','EGY','818','27','30'),
            ('83','El Salvador','SV','SLV','222','13.8333','-88.9167'),
            ('84','Equatorial Guinea','GQ','GNQ','226','2','10'),
            ('85','Eritrea','ER','ERI','232','15','39'),
            ('86','Estonia','EE','EST','233','59','26'),
            ('87','Ethiopia','ET','ETH','231','8','38'),
            ('88','Falkland Islands (Malvinas),','FK','FLK','238','-51.75','-59'),
            ('89','Faroe Islands','FO','FRO','234','62','-7'),
            ('90','Fiji','FJ','FJI','242','-18','175'),
            ('7','Finland','FI','FIN','246','64','26'),
            ('8','France','FR','FRA','250','46','2'),
            ('241','French Guiana','GF','GUF','254','4','-53'),
            ('242','French Polynesia','PF','PYF','258','-15','-140'),
            ('243','French Southern Territories','TF','ATF','260','-43','67'),
            ('91','Gabon','GA','GAB','266','-1','11.75'),
            ('92','Gambia','GM','GMB','270','13.4667','-16.5667'),
            ('93','Georgia','GE','GEO','268','42','43.5'),
            ('1','Germany','DE','DEU','276','51','9'),
            ('94','Ghana','GH','GHA','288','8','-2'),
            ('97','Gibraltar','GI','GIB','292','36.1833','-5.3667'),
            ('9','Greece','GR','GRC','300','39','22'),
            ('96','Greenland','GL','GRL','304','72','-40'),
            ('95','Grenada','GD','GRD','308','12.1167','-61.6667'),
            ('98','Guadeloupe','GP','GLP','312','16.25','-61.5833'),
            ('99','Guam','GU','GUM','316','13.4667','144.7833'),
            ('100','Guatemala','GT','GTM','320','15.5','-90.25'),
            ('101','Guernsey','GG','GGY','831','49.5','-2.56'),
            ('102','Guinea','GN','GIN','324','11','-10'),
            ('103','Guinea-Bissau','GW','GNB','624','12','-15'),
            ('104','Guyana','GY','GUY','328','5','-59'),
            ('105','Haiti','HT','HTI','332','19','-72.4167'),
            ('106','Heard Island and McDonald Islands','HM','HMD','334','-53.1','72.5167'),
            ('107','Holy See (Vatican City State),','VA','VAT','336','41.9','12.45'),
            ('108','Honduras','HN','HND','340','15','-86.5'),
            ('22','Hong Kong','HK','HKG','344','22.25','114.1667'),
            ('143','Hungary','HU','HUN','348','47','20'),
            ('109','Iceland','IS','ISL','352','65','-18'),
            ('110','India','IN','IND','356','20','77'),
            ('111','Indonesia','ID','IDN','360','-5','120'),
            ('112','Iran, Islamic Republic of','IR','IRN','364','32','53'),
            ('113','Iraq','IQ','IRQ','368','33','44'),
            ('26','Ireland','IE','IRL','372','53','-8'),
            ('114','Isle of Man','IM','IMN','833','54.23','-4.55'),
            ('29','Israel','IL','ISR','376','31.5','34.75'),
            ('10','Italy','IT','ITA','380','42.8333','12.8333'),
            ('115','Jamaica','JM','JAM','388','18.25','-77.5'),
            ('11','Japan','JP','JPN','392','36','138'),
            ('116','Jersey','JE','JEY','832','49.21','-2.13'),
            ('117','Jordan','JO','JOR','400','31','36'),
            ('118','Kazakhstan','KZ','KAZ','398','48','68'),
            ('119','Kenya','KE','KEN','404','1','38'),
            ('120','Kiribati','KI','KIR','296','1.4167','173'),
            ('121','Korea, Democratic People\'s Republic of','KP','PRK','408','40','127'),
            ('28','South Korea','KR','KOR','410','37','127.5'),
            ('122','Kuwait','KW','KWT','414','29.3375','47.6581'),
            ('123','Kyrgyzstan','KG','KGZ','417','41','75'),
            ('124','Lao People\'s Democratic Republic','LA','LAO','418','18','105'),
            ('125','Latvia','LV','LVA','428','57','25'),
            ('126','Lebanon','LB','LBN','422','33.8333','35.8333'),
            ('127','Lesotho','LS','LSO','426','-29.5','28.5'),
            ('128','Liberia','LR','LBR','430','6.5','-9.5'),
            ('129','Libya','LY','LBY','434','25','17'),
            ('130','Liechtenstein','LI','LIE','438','47.1667','9.5333'),
            ('131','Lithuania','LT','LTU','440','56','24'),
            ('12','Luxembourg','LU','LUX','442','49.75','6.1667'),
            ('132','Macao','MO','MAC','446','22.1667','113.55'),
            ('133','Macedonia, the former Yugoslav Republic of','MK','MKD','807','41.8333','22'),
            ('134','Madagascar','MG','MDG','450','-20','47'),
            ('135','Malawi','MW','MWI','454','-13.5','34'),
            ('136','Malaysia','MY','MYS','458','2.5','112.5'),
            ('137','Maldives','MV','MDV','462','3.25','73'),
            ('138','Mali','ML','MLI','466','17','-4'),
            ('139','Malta','MT','MLT','470','35.8333','14.5833'),
            ('140','Marshall Islands','MH','MHL','584','9','168'),
            ('141','Martinique','MQ','MTQ','474','14.6667','-61'),
            ('142','Mauritania','MR','MRT','478','20','-12'),
            ('35','Mauritius','MU','MUS','480','-20.2833','57.55'),
            ('144','Mayotte','YT','MYT','175','-12.8333','45.1667'),
            ('145','Mexico','MX','MEX','484','23','-102'),
            ('146','Micronesia, Federated States of','FM','FSM','583','6.9167','158.25'),
            ('147','Moldova, Republic of','MD','MDA','498','47','29'),
            ('148','Monaco','MC','MCO','492','43.7333','7.4'),
            ('149','Mongolia','MN','MNG','496','46','105'),
            ('150','Montenegro','ME','MNE','499','42','19'),
            ('151','Montserrat','MS','MSR','500','16.75','-62.2'),
            ('152','Morocco','MA','MAR','504','32','-5'),
            ('153','Mozambique','MZ','MOZ','508','-18.25','35'),
            ('61','Myanmar','MM','MMR','104','22','98'),
            ('154','Namibia','NA','NAM','516','-22','17'),
            ('155','Nauru','NR','NRU','520','-0.5333','166.9167'),
            ('156','Nepal','NP','NPL','524','28','84'),
            ('13','Netherlands','NL','NLD','528','52.5','5.75'),
            ('157','Netherlands Antilles','AN','ANT','530','12.25','-68.75'),
            ('158','New Caledonia','NC','NCL','540','-21.5','165.5'),
            ('27','New Zealand','NZ','NZL','554','-41','174'),
            ('159','Nicaragua','NI','NIC','558','13','-85'),
            ('160','Niger','NE','NER','562','16','8'),
            ('31','Nigeria','NG','NGA','566','10','8'),
            ('161','Niue','NU','NIU','570','-19.0333','-169.8667'),
            ('162','Norfolk Island','NF','NFK','574','-29.0333','167.95'),
            ('163','Northern Mariana Islands','MP','MNP','580','15.2','145.75'),
            ('23','Norway','NO','NOR','578','62','10'),
            ('164','Oman','OM','OMN','512','21','57'),
            ('165','Pakistan','PK','PAK','586','30','70'),
            ('166','Palau','PW','PLW','585','7.5','134.5'),
            ('167','Palestinian Territory, Occupied','PS','PSE','275','32','35.25'),
            ('168','Panama','PA','PAN','591','9','-80'),
            ('169','Papua New Guinea','PG','PNG','598','-6','147'),
            ('170','Paraguay','PY','PRY','600','-23','-58'),
            ('171','Peru','PE','PER','604','-10','-76'),
            ('172','Philippines','PH','PHL','608','13','122'),
            ('173','Pitcairn','PN','PCN','612','-24.7','-127.4'),
            ('14','Poland','PL','POL','616','52','20'),
            ('15','Portugal','PT','PRT','620','39.5','-8'),
            ('174','Puerto Rico','PR','PRI','630','18.25','-66.5'),
            ('175','Qatar','QA','QAT','634','25.5','51.25'),
            ('176','Réunion','RE','REU','638','-21.1','55.6'),
            ('36','Romania','RO','ROU','642','46','25'),
            ('177','Russia','RU','RUS','643','60','100'),
            ('178','Rwanda','RW','RWA','646','-2','30'),
            ('180','Saint Kitts and Nevis','KN','KNA','659','17.3333','-62.75'),
            ('181','Saint Lucia','LC','LCA','662','13.8833','-61.1333'),
            ('183','Saint Pierre and Miquelon','PM','SPM','666','46.8333','-56.3333'),
            ('184','Saint Vincent and the Grenadines','VC','VCT','670','13.25','-61.2'),
            ('185','Samoa','WS','WSM','882','-13.5833','-172.3333'),
            ('186','San Marino','SM','SMR','674','43.7667','12.4167'),
            ('187','Sao Tome and Principe','ST','STP','678','1','7'),
            ('188','Saudi Arabia','SA','SAU','682','25','45'),
            ('189','Senegal','SN','SEN','686','14','-14'),
            ('190','Serbia','RS','SRB','688','44','21'),
            ('191','Seychelles','SC','SYC','690','-4.5833','55.6667'),
            ('192','Sierra Leone','SL','SLE','694','8.5','-11.5'),
            ('25','Singapore','SG','SGP','702','1.3667','103.8'),
            ('37','Slovakia','SK','SVK','703','48.6667','19.5'),
            ('193','Slovenia','SI','SVN','705','46','15'),
            ('194','Solomon Islands','SB','SLB','90','-8','159'),
            ('195','Somalia','SO','SOM','706','10','49'),
            ('30','South Africa','ZA','ZAF','710','-29','24'),
            ('196','South Georgia and the South Sandwich Islands','GS','SGS','239','-54.5','-37'),
            ('6','Spain','ES','ESP','724','40','-4'),
            ('197','Sri Lanka','LK','LKA','144','7','81'),
            ('198','Sudan','SD','SDN','736','15','30'),
            ('199','Suriname','SR','SUR','740','4','-56'),
            ('200','Svalbard and Jan Mayen','SJ','SJM','744','78','20'),
            ('201','Swaziland','SZ','SWZ','748','-26.5','31.5'),
            ('18','Sweden','SE','SWE','752','62','15'),
            ('19','Switzerland','CH','CHE','756','47','8'),
            ('202','Syrian Arab Republic','SY','SYR','760','35','38'),
            ('203','Taiwan','TW','TWN','158','23.5','121'),
            ('204','Tajikistan','TJ','TJK','762','39','71'),
            ('205','Tanzania, United Republic of','TZ','TZA','834','-6','35'),
            ('206','Thailand','TH','THA','764','15','100'),
            ('80','Timor-Leste','TL','TLS','626','-8.55','125.5167'),
            ('33','Togo','TG','TGO','768','8','1.1667'),
            ('207','Tokelau','TK','TKL','772','-9','-172'),
            ('208','Tonga','TO','TON','776','-20','-175'),
            ('209','Trinidad and Tobago','TT','TTO','780','11','-61'),
            ('210','Tunisia','TN','TUN','788','34','9'),
            ('211','Turkey','TR','TUR','792','39','35'),
            ('212','Turkmenistan','TM','TKM','795','40','60'),
            ('213','Turks and Caicos Islands','TC','TCA','796','21.75','-71.5833'),
            ('214','Tuvalu','TV','TUV','798','-8','178'),
            ('215','Uganda','UG','UGA','800','1','32'),
            ('216','Ukraine','UA','UKR','804','49','32'),
            ('217','United Arab Emirates','AE','ARE','784','24','54'),
            ('17','United Kingdom','GB','GBR','826','54','-2'),
            ('21','United States','US','USA','840','38','-97'),
            ('218','Uruguay','UY','URY','858','-33','-56'),
            ('219','Uzbekistan','UZ','UZB','860','41','64'),
            ('220','Vanuatu','VU','VUT','548','-16','167'),
            ('221','Venezuela','VE','VEN','862','8','-66'),
            ('222','Vietnam','VN','VNM','704','16','106'),
            ('223','Virgin Islands, British','VG','VGB','92','18.5','-64.5'),
            ('224','Virgin Islands, U.S.','VI','VIR','850','18.3333','-64.8333'),
            ('225','Wallis and Futuna','WF','WLF','876','-13.3','-176.2'),
            ('226','Western Sahara','EH','ESH','732','24.5','-13'),
            ('227','Yemen','YE','YEM','887','15','48'),
            ('228','Zimbabwe','ZW','ZWE','716','-20','30')
        "; 
    }
    
    foreach ($sqlQueries as $query) {
        if (Db::getInstance()->execute($query) == false) {
            return false;
        }
    }

return true;
}

← 返回文件管理器