public function shippingCapture()
{
if ($this->capture_mode == 'after_shipping') {
$q = 'SELECT DISTINCT ao.amazon_order_reference_id FROM ' . _DB_PREFIX_ . 'orders o
JOIN ' . _DB_PREFIX_ . 'amz_orders ao ON o.id_order = ao.id_order
JOIN ' . _DB_PREFIX_ . 'amz_transactions AS a1 ON (ao.amazon_order_reference_id = a1.amz_tx_order_reference AND a1.amz_tx_type = \'auth\' AND a1.amz_tx_status = \'Open\')
LEFT JOIN ' . _DB_PREFIX_ . 'amz_transactions AS a2 ON (ao.amazon_order_reference_id = a2.amz_tx_order_reference AND a2.amz_tx_type = \'capture\')
WHERE
ao.amazon_order_reference_id != \'\'
AND
o.current_state = \'' . pSQL($this->capture_status_id) . '\'
AND
a2.amz_tx_id IS NULL';
$rs = Db::getInstance()->ExecuteS($q);
foreach ($rs as $r) {
$ramz = AmazonTransactions::getAuthorizationForCapture($r['amazon_order_reference_id']);
$auth_id = $ramz['amz_tx_amz_id'];
AmazonTransactions::captureTotalFromAuth($this, $this->getService(), $auth_id);
}
}
}
