realex.php | searchcode

/upload/admin/model/payment/realex.php

https://gitlab.com/m.mirsamie/opencart
PHP | 265 lines | 216 code | 48 blank | 1 comment | 24 complexity | e9bbf7cd0ff40f1e3778ad16cf6a7deb MD5 | raw file

<?php
class ModelPaymentRealex 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,
			  `created` DATETIME NOT NULL,
			  `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,
			  `created` 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('realex_merchant_id');
			$secret = $this->config->get('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('realex_merchant_id');
			$secret = $this->config->get('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('realex_merchant_id');
			$secret = $this->config->get('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('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."', `created` = now(), `type` = '".$this->db->escape($type)."', `amount` = '".(double)$total."'");
	}

	public function logger($message) {
		if ($this->config->get('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 (double)$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 (double)$query->row['total'];
	}
}