aboutsummaryrefslogtreecommitdiffstats
path: root/public/admin/model/extension/payment/realex.php
diff options
context:
space:
mode:
Diffstat (limited to 'public/admin/model/extension/payment/realex.php')
-rw-r--r--public/admin/model/extension/payment/realex.php265
1 files changed, 265 insertions, 0 deletions
diff --git a/public/admin/model/extension/payment/realex.php b/public/admin/model/extension/payment/realex.php
new file mode 100644
index 0000000..d2b7a7a
--- /dev/null
+++ b/public/admin/model/extension/payment/realex.php
@@ -0,0 +1,265 @@
+<?php
+class ModelExtensionPaymentRealex extends Model {
+ public function install() {
+ $this->db->query("
+ CREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "realex_order` (
+ `realex_order_id` INT(11) NOT NULL AUTO_INCREMENT,
+ `order_id` INT(11) NOT NULL,
+ `order_ref` CHAR(50) NOT NULL,
+ `order_ref_previous` CHAR(50) NOT NULL,
+ `pasref` VARCHAR(50) NOT NULL,
+ `pasref_previous` VARCHAR(50) NOT NULL,
+ `date_added` DATETIME NOT NULL,
+ `date_modified` DATETIME NOT NULL,
+ `capture_status` INT(1) DEFAULT NULL,
+ `void_status` INT(1) DEFAULT NULL,
+ `settle_type` INT(1) DEFAULT NULL,
+ `rebate_status` INT(1) DEFAULT NULL,
+ `currency_code` CHAR(3) NOT NULL,
+ `authcode` VARCHAR(30) NOT NULL,
+ `account` VARCHAR(30) NOT NULL,
+ `total` DECIMAL( 10, 2 ) NOT NULL,
+ PRIMARY KEY (`realex_order_id`)
+ ) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci;");
+
+ $this->db->query("
+ CREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "realex_order_transaction` (
+ `realex_order_transaction_id` INT(11) NOT NULL AUTO_INCREMENT,
+ `realex_order_id` INT(11) NOT NULL,
+ `date_added` DATETIME NOT NULL,
+ `type` ENUM('auth', 'payment', 'rebate', 'void') DEFAULT NULL,
+ `amount` DECIMAL( 10, 2 ) NOT NULL,
+ PRIMARY KEY (`realex_order_transaction_id`)
+ ) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci;");
+ }
+
+ public function void($order_id) {
+ $realex_order = $this->getOrder($order_id);
+
+ if (!empty($realex_order)) {
+ $timestamp = strftime("%Y%m%d%H%M%S");
+ $merchant_id = $this->config->get('payment_realex_merchant_id');
+ $secret = $this->config->get('payment_realex_secret');
+
+ $this->logger('Void hash construct: ' . $timestamp . '.' . $merchant_id . '.' . $realex_order['order_ref'] . '...');
+
+ $tmp = $timestamp . '.' . $merchant_id . '.' . $realex_order['order_ref'] . '...';
+ $hash = sha1($tmp);
+ $tmp = $hash . '.' . $secret;
+ $hash = sha1($tmp);
+
+ $xml = '';
+ $xml .= '<request type="void" timestamp="' . $timestamp . '">';
+ $xml .= '<merchantid>' . $merchant_id . '</merchantid>';
+ $xml .= '<account>' . $realex_order['account'] . '</account>';
+ $xml .= '<orderid>' . $realex_order['order_ref'] . '</orderid>';
+ $xml .= '<pasref>' . $realex_order['pasref'] . '</pasref>';
+ $xml .= '<authcode>' . $realex_order['authcode'] . '</authcode>';
+ $xml .= '<sha1hash>' . $hash . '</sha1hash>';
+ $xml .= '</request>';
+
+ $this->logger('Void XML request:\r\n' . print_r(simplexml_load_string($xml), 1));
+
+ $ch = curl_init();
+ curl_setopt($ch, CURLOPT_URL, "https://epage.payandshop.com/epage-remote.cgi");
+ curl_setopt($ch, CURLOPT_POST, 1);
+ curl_setopt($ch, CURLOPT_USERAGENT, "OpenCart " . VERSION);
+ curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
+ curl_setopt($ch, CURLOPT_POSTFIELDS, $xml);
+ curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
+ $response = curl_exec ($ch);
+ curl_close ($ch);
+
+ return simplexml_load_string($response);
+ } else {
+ return false;
+ }
+ }
+
+ public function updateVoidStatus($realex_order_id, $status) {
+ $this->db->query("UPDATE `" . DB_PREFIX . "realex_order` SET `void_status` = '" . (int)$status . "' WHERE `realex_order_id` = '" . (int)$realex_order_id . "'");
+ }
+
+ public function capture($order_id, $amount) {
+ $realex_order = $this->getOrder($order_id);
+
+ if (!empty($realex_order) && $realex_order['capture_status'] == 0) {
+ $timestamp = strftime("%Y%m%d%H%M%S");
+ $merchant_id = $this->config->get('payment_realex_merchant_id');
+ $secret = $this->config->get('payment_realex_secret');
+
+ if ($realex_order['settle_type'] == 2) {
+ $this->logger('Capture hash construct: ' . $timestamp . '.' . $merchant_id . '.' . $realex_order['order_ref'] . '.' . (int)round($amount*100) . '.' . (string)$realex_order['currency_code'] . '.');
+
+ $tmp = $timestamp . '.' . $merchant_id . '.' . $realex_order['order_ref'] . '.' . (int)round($amount*100) . '.' . (string)$realex_order['currency_code'] . '.';
+ $hash = sha1($tmp);
+ $tmp = $hash . '.' . $secret;
+ $hash = sha1($tmp);
+
+ $settle_type = 'multisettle';
+ $xml_amount = '<amount currency="' . (string)$realex_order['currency_code'] . '">' . (int)round($amount*100) . '</amount>';
+ } else {
+ //$this->logger('Capture hash construct: ' . $timestamp . '.' . $merchant_id . '.' . $realex_order['order_ref'] . '...');
+ $this->logger('Capture hash construct: ' . $timestamp . '.' . $merchant_id . '.' . $realex_order['order_ref'] . '.' . (int)round($amount*100) . '.' . (string)$realex_order['currency_code'] . '.');
+
+ $tmp = $timestamp . '.' . $merchant_id . '.' . $realex_order['order_ref'] . '.' . (int)round($amount*100) . '.' . (string)$realex_order['currency_code'] . '.';
+ $hash = sha1($tmp);
+ $tmp = $hash . '.' . $secret;
+ $hash = sha1($tmp);
+
+ $settle_type = 'settle';
+ $xml_amount = '<amount currency="' . (string)$realex_order['currency_code'] . '">' . (int)round($amount*100) . '</amount>';
+ }
+
+ $xml = '';
+ $xml .= '<request type="' . $settle_type . '" timestamp="' . $timestamp . '">';
+ $xml .= '<merchantid>' . $merchant_id . '</merchantid>';
+ $xml .= '<account>' . $realex_order['account'] . '</account>';
+ $xml .= '<orderid>' . $realex_order['order_ref'] . '</orderid>';
+ $xml .= $xml_amount;
+ $xml .= '<pasref>' . $realex_order['pasref'] . '</pasref>';
+ $xml .= '<autosettle flag="1" />';
+ $xml .= '<authcode>' . $realex_order['authcode'] . '</authcode>';
+ $xml .= '<sha1hash>' . $hash . '</sha1hash>';
+ $xml .= '</request>';
+
+ $this->logger('Settle XML request:\r\n' . print_r(simplexml_load_string($xml), 1));
+
+ $ch = curl_init();
+ curl_setopt($ch, CURLOPT_URL, "https://epage.payandshop.com/epage-remote.cgi");
+ curl_setopt($ch, CURLOPT_POST, 1);
+ curl_setopt($ch, CURLOPT_USERAGENT, "OpenCart " . VERSION);
+ curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
+ curl_setopt($ch, CURLOPT_POSTFIELDS, $xml);
+ curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
+ $response = curl_exec ($ch);
+ curl_close ($ch);
+
+ return simplexml_load_string($response);
+ } else {
+ return false;
+ }
+ }
+
+ public function updateCaptureStatus($realex_order_id, $status) {
+ $this->db->query("UPDATE `" . DB_PREFIX . "realex_order` SET `capture_status` = '" . (int)$status . "' WHERE `realex_order_id` = '" . (int)$realex_order_id . "'");
+ }
+
+ public function updateForRebate($realex_order_id, $pas_ref, $order_ref) {
+ $this->db->query("UPDATE `" . DB_PREFIX . "realex_order` SET `order_ref_previous` = '_multisettle_" . $this->db->escape($order_ref) . "', `pasref_previous` = '" . $this->db->escape($pas_ref) . "' WHERE `realex_order_id` = '" . (int)$realex_order_id . "' LIMIT 1");
+ }
+
+ public function rebate($order_id, $amount) {
+ $realex_order = $this->getOrder($order_id);
+
+ if (!empty($realex_order) && $realex_order['rebate_status'] != 1) {
+ $timestamp = strftime("%Y%m%d%H%M%S");
+ $merchant_id = $this->config->get('payment_realex_merchant_id');
+ $secret = $this->config->get('payment_realex_secret');
+
+ if ($realex_order['settle_type'] == 2) {
+ $order_ref = '_multisettle_' . $realex_order['order_ref'];
+
+ if (empty($realex_order['pasref_previous'])) {
+ $pas_ref = $realex_order['pasref'];
+ } else {
+ $pas_ref = $realex_order['pasref_previous'];
+ }
+ } else {
+ $order_ref = $realex_order['order_ref'];
+ $pas_ref = $realex_order['pasref'];
+ }
+
+ $this->logger('Rebate hash construct: ' . $timestamp . '.' . $merchant_id . '.' . $order_ref . '.' . (int)round($amount*100) . '.' . $realex_order['currency_code'] . '.');
+
+ $tmp = $timestamp . '.' . $merchant_id . '.' . $order_ref . '.' . (int)round($amount*100) . '.' . $realex_order['currency_code'] . '.';
+ $hash = sha1($tmp);
+ $tmp = $hash . '.' . $secret;
+ $hash = sha1($tmp);
+
+ $rebate_hash = sha1($this->config->get('payment_realex_rebate_password'));
+
+ $xml = '';
+ $xml .= '<request type="rebate" timestamp="' . $timestamp . '">';
+ $xml .= '<merchantid>' . $merchant_id . '</merchantid>';
+ $xml .= '<account>' . $realex_order['account'] . '</account>';
+ $xml .= '<orderid>' . $order_ref . '</orderid>';
+ $xml .= '<pasref>' . $pas_ref . '</pasref>';
+ $xml .= '<authcode>' . $realex_order['authcode'] . '</authcode>';
+ $xml .= '<amount currency="' . (string)$realex_order['currency_code'] . '">' . (int)round($amount*100) . '</amount>';
+ $xml .= '<refundhash>' . $rebate_hash . '</refundhash>';
+ $xml .= '<sha1hash>' . $hash . '</sha1hash>';
+ $xml .= '</request>';
+
+ $this->logger('Rebate XML request:\r\n' . print_r(simplexml_load_string($xml), 1));
+
+ $ch = curl_init();
+ curl_setopt($ch, CURLOPT_URL, "https://epage.payandshop.com/epage-remote.cgi");
+ curl_setopt($ch, CURLOPT_POST, 1);
+ curl_setopt($ch, CURLOPT_USERAGENT, "OpenCart " . VERSION);
+ curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
+ curl_setopt($ch, CURLOPT_POSTFIELDS, $xml);
+ curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
+ $response = curl_exec ($ch);
+ curl_close ($ch);
+
+ return simplexml_load_string($response);
+ } else {
+ return false;
+ }
+ }
+
+ public function updateRebateStatus($realex_order_id, $status) {
+ $this->db->query("UPDATE `" . DB_PREFIX . "realex_order` SET `rebate_status` = '" . (int)$status . "' WHERE `realex_order_id` = '" . (int)$realex_order_id . "'");
+ }
+
+ public function getOrder($order_id) {
+ $this->logger('getOrder - ' . $order_id);
+
+ $qry = $this->db->query("SELECT * FROM `" . DB_PREFIX . "realex_order` WHERE `order_id` = '" . (int)$order_id . "' LIMIT 1");
+
+ if ($qry->num_rows) {
+ $order = $qry->row;
+ $order['transactions'] = $this->getTransactions($order['realex_order_id']);
+
+ $this->logger(print_r($order, 1));
+
+ return $order;
+ } else {
+ return false;
+ }
+ }
+
+ private function getTransactions($realex_order_id) {
+ $qry = $this->db->query("SELECT * FROM `" . DB_PREFIX . "realex_order_transaction` WHERE `realex_order_id` = '" . (int)$realex_order_id . "'");
+
+ if ($qry->num_rows) {
+ return $qry->rows;
+ } else {
+ return false;
+ }
+ }
+
+ public function addTransaction($realex_order_id, $type, $total) {
+ $this->db->query("INSERT INTO `" . DB_PREFIX . "realex_order_transaction` SET `realex_order_id` = '" . (int)$realex_order_id . "', `date_added` = now(), `type` = '" . $this->db->escape($type) . "', `amount` = '" . (float)$total . "'");
+ }
+
+ public function logger($message) {
+ if ($this->config->get('payment_realex_debug') == 1) {
+ $log = new Log('realex.log');
+ $log->write($message);
+ }
+ }
+
+ public function getTotalCaptured($realex_order_id) {
+ $query = $this->db->query("SELECT SUM(`amount`) AS `total` FROM `" . DB_PREFIX . "realex_order_transaction` WHERE `realex_order_id` = '" . (int)$realex_order_id . "' AND (`type` = 'payment' OR `type` = 'rebate')");
+
+ return (float)$query->row['total'];
+ }
+
+ public function getTotalRebated($realex_order_id) {
+ $query = $this->db->query("SELECT SUM(`amount`) AS `total` FROM `" . DB_PREFIX . "realex_order_transaction` WHERE `realex_order_id` = '" . (int)$realex_order_id . "' AND 'rebate'");
+
+ return (float)$query->row['total'];
+ }
+} \ No newline at end of file
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-03 06:03:21 +0000