function updateTracking($static = false, $idShop = 0, $idGroupShop = 0)
{
$api = new ShipwireTracking();
$api->retrieveFull();
$d = $api->sendData();
if ($d['Status']) {
if ($static) {
return false;
} else {
die('KO');
}
}
if ($d['TotalOrders'] > 0) {
foreach ($d['Order'] as $order) {
$o = array();
if (isset($order['@attributes'])) {
$o = $order['@attributes'];
}
if (!isset($o['id'])) {
Logger::addLog('Shipwire: Order ID not defined. >>>>' . print_r($d, true) . '<<<<', 4);
continue;
}
$orderExists = Db::getInstance()->ExecuteS('SELECT `id_order`
FROM `' . _DB_PREFIX_ . 'shipwire_order`
WHERE `id_order` = ' . (int) $o['id'] . ' LIMIT 1');
if (isset($orderExists[0]['id_order']) && !empty($orderExists[0]['id_order'])) {
Db::getInstance()->Execute('UPDATE `' . _DB_PREFIX_ . 'shipwire_order` SET ' . (isset($order['TrackingNumber']) ? '`tracking_number` = \'' . pSQL($order['TrackingNumber']) . '\',' : '') . (isset($o['shipped']) ? '`shipped` = \'' . pSQL($o['shipped']) . '\'' : '') . (isset($o['shipper']) ? ',`shipper` = \'' . pSQL($o['shipper']) . '\'' : '') . (isset($o['shipDate']) ? ',`shipDate` = \'' . pSQL($o['shipDate']) . '\'' : '') . (isset($o['expectedDeliveryDate']) ? ',`expectedDeliveryDate` = \'' . pSQL($o['expectedDeliveryDate']) . '\'' : '') . (isset($o['href']) ? ',`href` = \'' . pSQL($o['href']) . '\'' : '') . (isset($o['shipperFullName']) ? ',`shipperFullName` = \'' . pSQL($o['shipperFullName']) . '\'' : '') . ' WHERE `id_order` = ' . (int) $o['id']);
} else {
Db::getInstance()->Execute('INSERT INTO `' . _DB_PREFIX_ . 'shipwire_order`
(`id_order`, `id_shop`, `id_group_shop`, `tracking_number`, `shipped`, `shipper`, `shipDate`, `expectedDeliveryDate`, `href`, `shipperFullName`)
VALUES (
\'' . pSQL($o['id']) . '\'' . ',' . (int) $idShop . ',' . (int) $idGroupShop . (isset($order['TrackingNumber']) ? ',\'' . pSQL($order['TrackingNumber']) . '\'' : ',\'\'') . (isset($o['shipped']) ? ',\'' . pSQL($o['shipped']) . '\'' : ',\'\'') . (isset($o['shipper']) ? ',\'' . pSQL($o['shipper']) . '\'' : ',\'\'') . (isset($o['shipDate']) ? ',\'' . pSQL($o['shipDate']) . '\'' : ',\'\'') . (isset($o['expectedDeliveryDate']) ? ',\'' . pSQL($o['expectedDeliveryDate']) . '\'' : ',\'\'') . (isset($o['href']) ? ',\'' . pSQL($o['href']) . '\'' : ',\'\'') . (isset($o['shipperFullName']) ? ',\'' . pSQL($o['shipperFullName']) . '\'' : ',\'\'') . ')');
}
$result = Db::getInstance()->getValue('SELECT `transaction_ref`
FROM `' . _DB_PREFIX_ . 'shipwire_order`
WHERE `id_order` = ' . (int) $o['id']);
if (empty($result)) {
$module = new Shipwire();
$module->updateOrderStatus((int) $o['id'], true);
}
if (isset($order['TrackingNumber'])) {
Db::getInstance()->Execute('UPDATE `' . _DB_PREFIX_ . 'orders`
SET `shipping_number` = \'' . pSQL($order['TrackingNumber']) . '\'
WHERE `id_order` = ' . (int) $o['id']);
if ($o['id']) {
$psOrder = new Order($o['id']);
if ($psOrder->id) {
$history = new OrderHistory();
$history->id_order = $o['id'];
if (isset($o['shipped']) && $o['shipped'] == 'YES') {
$history->changeIdOrderState(Configuration::get('SHIPWIRE_SENT_ID'), $o['id']);
}
$history->addWithemail();
}
}
}
}
}
if (Configuration::get('PS_CIPHER_ALGORITHM')) {
$cipherTool = new Rijndael(_RIJNDAEL_KEY_, _RIJNDAEL_IV_);
} else {
$cipherTool = new Blowfish(_COOKIE_KEY_, _COOKIE_IV_);
}
$shipWireInventoryUpdate = new ShipwireInventoryUpdate(Configuration::get('SHIPWIRE_API_USER'), $cipherTool->decrypt(Configuration::get('SHIPWIRE_API_PASSWD')));
$shipWireInventoryUpdate->getInventory();
if ($static) {
return true;
} else {
die('OK');
}
}
* 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-2012 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 dirname(__FILE__) . '/../../config/config.inc.php';
if (isset($_GET['secure_key']) || isset($_ARGV[1])) {
$secureKey = md5(_COOKIE_KEY_ . Configuration::get('PS_SHOP_NAME'));
if (!empty($secureKey) && ($secureKey == $_GET['secure_key'] || isset($_ARGV[1]) && $secureKey == $_ARGV[1])) {
// Clean logs
$logDeleteDate = date('Y-m-d', mktime(0, 0, 0, date('n'), date('j') - Configuration::get('SHIPWIRE_LOG_LIFE'), date('Y'))) . ' 00:00:00';
Db::getInstance()->Execute('DELETE FROM `' . _DB_PREFIX_ . 'shipwire_log` WHERE `date_added` < \'' . pSQL($logDeleteDate) . '\'');
if (!class_exists('Shipwire')) {
require_once dirname(__FILE__) . '/shipwire.php';
}
require_once dirname(__FILE__) . '/lib/ShipwireApi.php';
require_once dirname(__FILE__) . '/lib/ShipwireTracking.php';
$m = new Shipwire();
$d = Db::getInstance()->ExecuteS('SELECT `id_order` FROM `' . _DB_PREFIX_ . 'shipwire_order` WHERE `transaction_ref` IS NULL OR `transaction_ref` = \'\'');
foreach ($d as $line) {
$m->updateOrderStatus($line['id_order']);
}
ShipwireTracking::updateTracking();
// This will be called directly thru the browser or cronjob
}
die('Invalid key.');
}
