/** * Get orders details to create Tickets * * @static * @param array $orderIdList * @param int $filterEntries * @param int $weight_coefficient * @return array */ public static function getOrders($orderIdList = array(), $filterEntries = MondialRelay::NO_FILTER, $weight_coefficient = 0) { $account_shop = MondialRelay::getAccountDetail(); $id_order_state = $account_shop['MR_ORDER_STATE']; $sql = MondialRelay::getBaseOrdersSQLQuery($id_order_state, $weight_coefficient); if (count($orderIdList)) { $sql .= ' AND o.id_order IN ('; foreach ($orderIdList as $id_order) { $sql .= (int) $id_order . ', '; } $sql = rtrim($sql, ', ') . ')'; } switch ($filterEntries) { case MondialRelay::WITHOUT_HOME_DELIVERY: $sql .= 'AND mr.mr_ModeLiv != "LD1" AND mr.mr_ModeLiv != "LDS"'; break; } $sql .= ' GROUP BY o.`id_order` ORDER BY o.`date_add` ASC'; return Db::getInstance()->executeS($sql); }
* * Do not edit or add to this file if you wish to upgrade PrestaShop to newer * versions in the future. If you wish to customize PrestaShop for your * needs please refer to http://www.prestashop.com for more information. * * @author PrestaShop SA <*****@*****.**> * @copyright 2007-2013 PrestaShop SA * @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0) * International Registered Trademark & Property of PrestaShop SA */ include_once '../../config/config.inc.php'; include_once 'mondialrelay.php'; if (Tools::getValue('secure_key') != Configuration::get('MONDIAL_RELAY_SECURE_KEY')) { exit; } $account_shop = MondialRelay::getAccountDetail(); $expeditions = Db::getInstance()->executeS(' SELECT ms.`exp_number`, ms.`id_cart`, o.`id_order` FROM `' . _DB_PREFIX_ . 'mr_selected` ms LEFT JOIN `' . _DB_PREFIX_ . 'orders` o ON (o.`id_cart` = ms.`id_cart`) WHERE `exp_number` != 0'); if (empty($expeditions)) { exit; } $params = array('Enseigne' => $account_shop['MR_ENSEIGNE_WEBSERVICE'], 'Langue' => 'FR'); require_once dirname(__FILE__) . '/lib/nusoap/nusoap.php'; $client_mr = new nusoap_client("http://www.mondialrelay.fr/webservice/Web_Services.asmx?WSDL", true); $client_mr->soap_defencoding = 'UTF-8'; $client_mr->decode_utf8 = false; foreach ($expeditions as $expedition) { if ($expedition['id_order'] == NULL) {