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');
}
}
