You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Bluepay Redirect payment method getting wrong totals from transactions table for (total released)
There is no need to get (auth) type transactions for the total amount released as this shows as it was released when it really wasn't and prevents from (release) function from actually working.
File: admin/model/payment/bluepay_redirect.php - line 182
CHANGE
public function getTotalReleased($bluepay_redirect_order_id) {
$query = $this->db->query("SELECT SUM(amount) AS total FROM " . DB_PREFIX . "bluepay_redirect_order_transaction WHERE bluepay_redirect_order_id = '" . (int)$bluepay_redirect_order_id . "' AND (type = 'sale' OR type = 'rebate' OR type = 'auth')");
return (float)$query->row['total'];
}
TO:
public function getTotalReleased($bluepay_redirect_order_id) {
$query = $this->db->query("SELECT SUM(amount) AS total FROM " . DB_PREFIX . "bluepay_redirect_order_transaction WHERE bluepay_redirect_order_id = '" . (int)$bluepay_redirect_order_id . "' AND (type = 'sale' OR type = 'rebate')");
return (float)$query->row['total'];
}
The text was updated successfully, but these errors were encountered:
Bluepay Redirect payment method getting wrong totals from transactions table for (total released)
There is no need to get (auth) type transactions for the total amount released as this shows as it was released when it really wasn't and prevents from (release) function from actually working.
File: admin/model/payment/bluepay_redirect.php - line 182
CHANGE
public function getTotalReleased($bluepay_redirect_order_id) {
$query = $this->db->query("SELECT SUM(
amount
) AStotal
FROM" . DB_PREFIX . "bluepay_redirect_order_transaction
WHEREbluepay_redirect_order_id
= '" . (int)$bluepay_redirect_order_id . "' AND (type
= 'sale' ORtype
= 'rebate' ORtype
= 'auth')");TO:
public function getTotalReleased($bluepay_redirect_order_id) {
$query = $this->db->query("SELECT SUM(
amount
) AStotal
FROM" . DB_PREFIX . "bluepay_redirect_order_transaction
WHEREbluepay_redirect_order_id
= '" . (int)$bluepay_redirect_order_id . "' AND (type
= 'sale' ORtype
= 'rebate')");The text was updated successfully, but these errors were encountered: