OpenCart 🇺🇦

$this->db->query("INSERT INTO `" . DB_PREFIX . "paypal_iframe_order_transaction` SET `paypal_iframe_order_id` = '" . (int)$transaction_data['paypal_iframe_order_id'] . "', `transaction_id` = '" . $this->db->escape($transaction_data['transaction_id']) . "', `parent_transaction_id` = '" . $this->db->escape($transaction_data['parent_transaction_id']) . "', `created` = NOW(), `note` = '" . $this->db->escape($transaction_data['note']) . "', `msgsubid` = '" . $this->db->escape($transaction_data['msgsubid']) . "', `receipt_id` = '" . $this->db->escape($transaction_data['receipt_id']) . "', `payment_type` = '" . $this->db->escape($transaction_data['payment_type']) . "', `payment_status` = '" . $this->db->escape($transaction_data['payment_status']) . "', `pending_reason` = '" . $this->db->escape($transaction_data['pending_reason']) . "', `transaction_entity` = '" . $this->db->escape($transaction_data['transaction_entity']) . "', `amount` = '" . (double)$transaction_data['amount'] . "', `debug_data` = '" . $this->db->escape($transaction_data['debug_data']) . "'");

$paypal_iframe_order_transaction_id = $this->db->getLastId();

if ($request_data) {
	$serialized_data = serialize($request_data);

	$this->db->query("
		UPDATE " . DB_PREFIX . "paypal_iframe_order_transaction
		SET call_data = '" . $this->db->escape($serialized_data) . "'
		WHERE paypal_iframe_order_transaction_id = " . (int)$paypal_iframe_order_transaction_id . "
		LIMIT 1
	");
}

return $paypal_iframe_order_transaction_id;