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