/admin/model/payment/bluepay_hosted.php
PHP | 235 lines | 182 code | 53 blank | 0 comment | 22 complexity | ac9ff5fa8e6cc177513398310a043e8b MD5 | raw file
- <?php
- class ModelPaymentBluePayHosted 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('bluepay_hosted_account_id');
- $void_data["TRANSACTION_TYPE"] = 'VOID';
- $void_data["MODE"] = strtoupper($this->config->get('bluepay_hosted_test'));
- $void_data["RRNO"] = $bluepay_hosted_order['transaction_id'];
- $void_data['APPROVED_URL'] = HTTP_CATALOG . 'index.php?route=payment/bluepay_hosted/adminCallback';
- $void_data['DECLINED_URL'] = HTTP_CATALOG . 'index.php?route=payment/bluepay_hosted/adminCallback';
- $void_data['MISSING_URL'] = HTTP_CATALOG . 'index.php?route=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('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('bluepay_hosted_account_id');
- $release_data["TRANSACTION_TYPE"] = 'CAPTURE';
- $release_data["MODE"] = strtoupper($this->config->get('bluepay_hosted_test'));
- $release_data["RRNO"] = $bluepay_hosted_order['transaction_id'];
- $release_data['APPROVED_URL'] = HTTP_CATALOG . 'index.php?route=payment/bluepay_hosted/adminCallback';
- $release_data['DECLINED_URL'] = HTTP_CATALOG . 'index.php?route=payment/bluepay_hosted/adminCallback';
- $release_data['MISSING_URL'] = HTTP_CATALOG . 'index.php?route=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('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('bluepay_hosted_account_id');
- $rebate_data["TRANSACTION_TYPE"] = 'REFUND';
- $rebate_data["MODE"] = strtoupper($this->config->get('bluepay_hosted_test'));
- $rebate_data["RRNO"] = $bluepay_hosted_order['transaction_id'];
- $rebate_data["AMOUNT"] = $amount;
- $rebate_data['APPROVED_URL'] = HTTP_CATALOG . 'index.php?route=payment/bluepay_hosted/adminCallback';
- $rebate_data['DECLINED_URL'] = HTTP_CATALOG . 'index.php?route=payment/bluepay_hosted/adminCallback';
- $rebate_data['MISSING_URL'] = HTTP_CATALOG . 'index.php?route=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('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('bluepay_hosted_debug') == 1) {
- $log = new Log('bluepay_hosted.log');
- $log->write($message);
- }
- }
- }