diff options
Diffstat (limited to 'public/admin/model/extension/payment/bluepay_hosted.php')
| -rw-r--r-- | public/admin/model/extension/payment/bluepay_hosted.php | 235 |
1 files changed, 235 insertions, 0 deletions
diff --git a/public/admin/model/extension/payment/bluepay_hosted.php b/public/admin/model/extension/payment/bluepay_hosted.php new file mode 100644 index 0000000..d1a85ac --- /dev/null +++ b/public/admin/model/extension/payment/bluepay_hosted.php @@ -0,0 +1,235 @@ +<?php +class ModelExtensionPaymentBluePayHosted extends Model { + public function install() { + $this->db->query(" + CREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "bluepay_hosted_order` ( + `bluepay_hosted_order_id` INT(11) NOT NULL AUTO_INCREMENT, + `order_id` INT(11) NOT NULL, + `transaction_id` VARCHAR(50), + `date_added` DATETIME NOT NULL, + `date_modified` DATETIME NOT NULL, + `release_status` INT(1) DEFAULT 0, + `void_status` INT(1) DEFAULT 0, + `rebate_status` INT(1) DEFAULT 0, + `currency_code` CHAR(3) NOT NULL, + `total` DECIMAL( 10, 2 ) NOT NULL, + PRIMARY KEY (`bluepay_hosted_order_id`) + ) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci;"); + + $this->db->query(" + CREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "bluepay_hosted_order_transaction` ( + `bluepay_hosted_order_transaction_id` INT(11) NOT NULL AUTO_INCREMENT, + `bluepay_hosted_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 (`bluepay_hosted_order_transaction_id`) + ) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci;"); + + $this->db->query(" + CREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "bluepay_hosted_card` ( + `card_id` INT(11) NOT NULL AUTO_INCREMENT, + `customer_id` INT(11) NOT NULL, + `token` VARCHAR(50) NOT NULL, + `digits` VARCHAR(4) NOT NULL, + `expiry` VARCHAR(5) NOT NULL, + `type` VARCHAR(50) NOT NULL, + PRIMARY KEY (`card_id`) + ) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci;"); + } + + public function uninstall() { + $this->db->query("DROP TABLE IF EXISTS `" . DB_PREFIX . "bluepay_hosted_order`;"); + $this->db->query("DROP TABLE IF EXISTS `" . DB_PREFIX . "bluepay_hosted_order_transaction`;"); + $this->db->query("DROP TABLE IF EXISTS `" . DB_PREFIX . "bluepay_hosted_card`;"); + } + + public function void($order_id) { + $bluepay_hosted_order = $this->getOrder($order_id); + + if (!empty($bluepay_hosted_order) && $bluepay_hosted_order['release_status'] == 1) { + + $void_data = array(); + + $void_data['MERCHANT'] = $this->config->get('payment_bluepay_hosted_account_id'); + $void_data["TRANSACTION_TYPE"] = 'VOID'; + $void_data["MODE"] = strtoupper($this->config->get('payment_bluepay_hosted_test')); + $void_data["RRNO"] = $bluepay_hosted_order['transaction_id']; + + $void_data['APPROVED_URL'] = HTTP_CATALOG . 'index.php?route=extension/payment/bluepay_hosted/adminCallback'; + $void_data['DECLINED_URL'] = HTTP_CATALOG . 'index.php?route=extension/payment/bluepay_hosted/adminCallback'; + $void_data['MISSING_URL'] = HTTP_CATALOG . 'index.php?route=extension/payment/bluepay_hosted/adminCallback'; + + if (isset($this->request->server["REMOTE_ADDR"])) { + $void_data["REMOTE_IP"] = $this->request->server["REMOTE_ADDR"]; + } + + $tamper_proof_data = $this->config->get('payment_bluepay_hosted_secret_key') . $void_data['MERCHANT'] . $void_data["TRANSACTION_TYPE"] . $void_data["RRNO"] . $void_data["MODE"]; + + $void_data["TAMPER_PROOF_SEAL"] = md5($tamper_proof_data); + + $this->logger('$void_data:\r\n' . print_r($void_data, 1)); + + $response_data = $this->sendCurl('https://secure.bluepay.com/interfaces/bp10emu', $void_data); + + return $response_data; + } else { + return false; + } + } + + public function updateVoidStatus($bluepay_hosted_order_id, $status) { + $this->logger('$bluepay_hosted_order_id:\r\n' . print_r($bluepay_hosted_order_id, 1)); + $this->logger('$status:\r\n' . print_r($status, 1)); + $this->db->query("UPDATE `" . DB_PREFIX . "bluepay_hosted_order` SET `void_status` = '" . (int)$status . "' WHERE `bluepay_hosted_order_id` = '" . (int)$bluepay_hosted_order_id . "'"); + } + + public function release($order_id, $amount) { + $bluepay_hosted_order = $this->getOrder($order_id); + $total_released = $this->getTotalReleased($bluepay_hosted_order['bluepay_hosted_order_id']); + + if (!empty($bluepay_hosted_order) && $bluepay_hosted_order['release_status'] == 0 && ($total_released + $amount <= $bluepay_hosted_order['total'])) { + $release_data = array(); + + $release_data['MERCHANT'] = $this->config->get('payment_bluepay_hosted_account_id'); + $release_data["TRANSACTION_TYPE"] = 'CAPTURE'; + $release_data["MODE"] = strtoupper($this->config->get('payment_bluepay_hosted_test')); + $release_data["RRNO"] = $bluepay_hosted_order['transaction_id']; + + $release_data['APPROVED_URL'] = HTTP_CATALOG . 'index.php?route=extension/payment/bluepay_hosted/adminCallback'; + $release_data['DECLINED_URL'] = HTTP_CATALOG . 'index.php?route=extension/payment/bluepay_hosted/adminCallback'; + $release_data['MISSING_URL'] = HTTP_CATALOG . 'index.php?route=extension/payment/bluepay_hosted/adminCallback'; + + if (isset($this->request->server["REMOTE_ADDR"])) { + $release_data["REMOTE_IP"] = $this->request->server["REMOTE_ADDR"]; + } + + $tamper_proof_data = $this->config->get('payment_bluepay_hosted_secret_key') . $release_data['MERCHANT'] . $release_data["TRANSACTION_TYPE"] . $release_data["RRNO"] . $release_data["MODE"]; + + $release_data["TAMPER_PROOF_SEAL"] = md5($tamper_proof_data); + + $response_data = $this->sendCurl('https://secure.bluepay.com/interfaces/bp10emu', $release_data); + + return $response_data; + } else { + return false; + } + } + + public function updateReleaseStatus($bluepay_hosted_order_id, $status) { + $this->db->query("UPDATE `" . DB_PREFIX . "bluepay_hosted_order` SET `release_status` = '" . (int)$status . "' WHERE `bluepay_hosted_order_id` = '" . (int)$bluepay_hosted_order_id . "'"); + } + + public function rebate($order_id, $amount) { + $bluepay_hosted_order = $this->getOrder($order_id); + + if (!empty($bluepay_hosted_order) && $bluepay_hosted_order['rebate_status'] != 1) { + $rebate_data = array(); + + $rebate_data['MERCHANT'] = $this->config->get('payment_bluepay_hosted_account_id'); + $rebate_data["TRANSACTION_TYPE"] = 'REFUND'; + $rebate_data["MODE"] = strtoupper($this->config->get('payment_bluepay_hosted_test')); + $rebate_data["RRNO"] = $bluepay_hosted_order['transaction_id']; + $rebate_data["AMOUNT"] = $amount; + $rebate_data['APPROVED_URL'] = HTTP_CATALOG . 'index.php?route=extension/payment/bluepay_hosted/adminCallback'; + $rebate_data['DECLINED_URL'] = HTTP_CATALOG . 'index.php?route=extension/payment/bluepay_hosted/adminCallback'; + $rebate_data['MISSING_URL'] = HTTP_CATALOG . 'index.php?route=extension/payment/bluepay_hosted/adminCallback'; + + if (isset($this->request->server["REMOTE_ADDR"])) { + $rebate_data["REMOTE_IP"] = $this->request->server["REMOTE_ADDR"]; + } + + $tamper_proof_data = $this->config->get('payment_bluepay_hosted_secret_key') . $rebate_data['MERCHANT'] . $rebate_data["TRANSACTION_TYPE"] . $rebate_data['AMOUNT'] . $rebate_data["RRNO"] . $rebate_data["MODE"]; + + $rebate_data["TAMPER_PROOF_SEAL"] = md5($tamper_proof_data); + + $response_data = $this->sendCurl('https://secure.bluepay.com/interfaces/bp10emu', $rebate_data); + + return $response_data; + } else { + return false; + } + } + + public function updateRebateStatus($bluepay_hosted_order_id, $status) { + $this->db->query("UPDATE `" . DB_PREFIX . "bluepay_hosted_order` SET `rebate_status` = '" . (int)$status . "' WHERE `bluepay_hosted_order_id` = '" . (int)$bluepay_hosted_order_id . "'"); + } + + public function updateTransactionId($bluepay_hosted_order_id, $transaction_id) { + $this->db->query("UPDATE `" . DB_PREFIX . "bluepay_hosted_order` SET `transaction_id` = '" . (int)$transaction_id . "' WHERE `bluepay_hosted_order_id` = '" . (int)$bluepay_hosted_order_id . "'"); + } + + public function getOrder($order_id) { + + $qry = $this->db->query("SELECT * FROM `" . DB_PREFIX . "bluepay_hosted_order` WHERE `order_id` = '" . (int)$order_id . "' LIMIT 1"); + + if ($qry->num_rows) { + $order = $qry->row; + $order['transactions'] = $this->getTransactions($order['bluepay_hosted_order_id']); + + return $order; + } else { + return false; + } + } + + private function getTransactions($bluepay_hosted_order_id) { + $qry = $this->db->query("SELECT * FROM `" . DB_PREFIX . "bluepay_hosted_order_transaction` WHERE `bluepay_hosted_order_id` = '" . (int)$bluepay_hosted_order_id . "'"); + + if ($qry->num_rows) { + return $qry->rows; + } else { + return false; + } + } + + public function addTransaction($bluepay_hosted_order_id, $type, $total) { + $this->logger('$type:\r\n' . print_r($type, 1)); + $this->logger('$total:\r\n' . print_r($total, 1)); + $this->db->query("INSERT INTO `" . DB_PREFIX . "bluepay_hosted_order_transaction` SET `bluepay_hosted_order_id` = '" . (int)$bluepay_hosted_order_id . "', `date_added` = now(), `type` = '" . $this->db->escape($type) . "', `amount` = '" . (float)$total . "'"); + } + + public function getTotalReleased($bluepay_hosted_order_id) { + $query = $this->db->query("SELECT SUM(`amount`) AS `total` FROM `" . DB_PREFIX . "bluepay_hosted_order_transaction` WHERE `bluepay_hosted_order_id` = '" . (int)$bluepay_hosted_order_id . "' AND (`type` = 'payment' OR `type` = 'rebate')"); + + return (float)$query->row['total']; + } + + public function getTotalRebated($bluepay_hosted_order_id) { + $query = $this->db->query("SELECT SUM(`amount`) AS `total` FROM `" . DB_PREFIX . "bluepay_hosted_order_transaction` WHERE `bluepay_hosted_order_id` = '" . (int)$bluepay_hosted_order_id . "' AND 'rebate'"); + + return (float)$query->row['total']; + } + + public function sendCurl($url, $post_data) { + $curl = curl_init($url); + + curl_setopt($curl, CURLOPT_PORT, 443); + curl_setopt($curl, CURLOPT_HEADER, 0); + curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, 0); + curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); + curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true); + curl_setopt($curl, CURLOPT_FORBID_REUSE, 1); + curl_setopt($curl, CURLOPT_FRESH_CONNECT, 1); + curl_setopt($curl, CURLOPT_POST, 1); + curl_setopt($curl, CURLOPT_POSTFIELDS, http_build_query($post_data)); + + $response_data = curl_exec($curl); + + curl_close($curl); + + return json_decode($response_data, true); + } + + public function adminCallback() { + $this->response->addHeader('Content-Type: application/json'); + $this->response->setOutput(json_encode($this->request->get)); + } + + public function logger($message) { + if ($this->config->get('payment_bluepay_hosted_debug') == 1) { + $log = new Log('bluepay_hosted.log'); + $log->write($message); + } + } +}
\ No newline at end of file |