upgrade/php/migrate_orders.php

39 …$col_order_detail_old = Db::getInstance()->executeS('SHOW FIELDS FROM `'._DB_PREFIX_.'order_detail…
53     $col_orders_old = Db::getInstance()->executeS('SHOW FIELDS FROM `'._DB_PREFIX_.'orders`');
72     $wrapping_tax_rate = 1 + ((float)Db::getInstance()->getValue('SELECT value
77 …  $count_orders = Db::getInstance()->getValue('SELECT count(id_order) FROM '._DB_PREFIX_.'orders');
83 …$order_res = Db::getInstance()->query('SELECT * FROM `'._DB_PREFIX_.'orders` LIMIT '.(int)$start.'…
87         while ($order = Db::getInstance()->nextRow($order_res)) {
92             $order_details_list = Db::getInstance()->query('
97             while ($order_details = Db::getInstance()->nextRow($order_details_list)) {
122                             $order_details[$k] = Db::getInstance()->escape($order_details[$k]);
158             $order['gift_message'] = Db::getInstance()->escape($order['gift_message']);
159             $order['payment'] = Db::getInstance()->escape($order['payment']);
160             $order['module'] = Db::getInstance()->escape($order['module']);
170 …if (isset($values_order_detail) && count($values_order_detail) && !Db::getInstance()->execute($ins…
172                     $array_errors[] = '[insert order detail 1] - '.Db::getInstance()->getMsgError();
174 …if (isset($values_order) && count($values_order) && !Db::getInstance()->execute($insert_order. imp…
176                     $array_errors[] = '[insert order 2] - '.Db::getInstance()->getMsgError();
188 …if (isset($values_order_detail) && count($values_order_detail) && !Db::getInstance()->execute($ins…
190         $array_errors[] = '[insert order detail 3] - '.Db::getInstance()->getMsgError();
192 …if (isset($values_order) && count($values_order) && !Db::getInstance()->execute($insert_order. imp…
194         $array_errors[] = '[insert order 4] - '.Db::getInstance()->getMsgError();
224         $ps_price_round_mode = Db::getInstance()->getValue('SELECT value
242     $res &= Db::getInstance()->execute('CREATE TABLE
244     $res &= Db::getInstance()->execute('CREATE TABLE
253     $res &= Db::getInstance()->execute('DROP TABLE `'._DB_PREFIX_.'orders`');
254     $res &= Db::getInstance()->execute('DROP TABLE `'._DB_PREFIX_.'order_detail`');
256 …$res &= Db::getInstance()->execute('RENAME TABLE `'._DB_PREFIX_.'orders_2` TO `'._DB_PREFIX_.'orde…
257 …$res &= Db::getInstance()->execute('RENAME TABLE `'._DB_PREFIX_.'order_detail_2` TO `'._DB_PREFIX_…
266 …$cache[$id_customer] = Db::getInstance()->getValue('SELECT `id_default_group` FROM `'._DB_PREFIX_.…
277         $cache[$id_group] = Db::getInstance()->getValue('