<?php
class ModelExtensionPaymentRealexRemote extends Model
{

    public function getMethod($address, $total)
    {
        $this->load->language('extension/payment/realex_remote');

        $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "zone_to_geo_zone WHERE geo_zone_id = '" . (int)$this->config->get('realex_geo_zone_id') . "' AND country_id = '" . (int)$address['country_id'] . "' AND (zone_id = '" . (int)$address['zone_id'] . "' OR zone_id = '0')");

        if ($this->config->get('realex_remote_total') > 0 && $this->config->get('realex_remote_total') > $total) {
            $status = false;
        } elseif (!$this->config->get('realex_remote_geo_zone_id')) {
            $status = true;
        } elseif ($query->num_rows) {
            $status = true;
        } else {
            $status = false;
        }

        $method_data = array();

        if ($status) {
            $method_data = array(
              'code'       => 'realex_remote',
              'title'      => $this->language->get('text_title'),
              'terms'      => '',
              'sort_order' => $this->config->get('realex_remote_sort_order')
            );
        }

        return $method_data;
    }

    public function checkEnrollment($account, $amount, $currency, $order_ref)
    {
        $timestamp = strftime("%Y%m%d%H%M%S");
        $merchant_id = $this->config->get('realex_remote_merchant_id');
        $secret = $this->config->get('realex_remote_secret');

        $tmp = $timestamp . '.' . $merchant_id . '.' . $order_ref . '.' . $amount . '.' . $currency . '.' . $this->request->post['cc_number'];
        $hash = sha1($tmp);
        $tmp = $hash . '.' . $secret;
        $hash = sha1($tmp);

        $xml = '';
        $xml .= '<request type="3ds-verifyenrolled" timestamp="' . $timestamp . '">';
        $xml .= '<merchantid>' . $merchant_id . '</merchantid>';
        $xml .= '<account>' . $account . '</account>';
        $xml .= '<orderid>' . $order_ref . '</orderid>';
        $xml .= '<amount currency="' . $currency . '">' . $amount . '</amount>';
        $xml .= '<card>';
        $xml .= '<number>' . $this->request->post['cc_number'] . '</number>';
        $xml .= '<expdate>' . $this->request->post['cc_expire_date_month'] . $this->request->post['cc_expire_date_year'] . '</expdate>';
        $xml .= '<type>' . $this->request->post['cc_type'] . '</type>';
        $xml .= '<chname>' . $this->request->post['cc_name'] . '</chname>';
        $xml .= '</card>';
        $xml .= '<sha1hash>' . $hash . '</sha1hash>';
        $xml .= '</request>';

        $this->logger('checkEnrollment call');
        $this->logger(simplexml_load_string($xml));
        $this->logger($xml);

        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, "https://epage.payandshop.com/epage-3dsecure.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);

        $this->logger('checkEnrollment xml response');
        $this->logger($response);

        return simplexml_load_string($response);
    }

    public function enrollmentSignature(
      $account,
      $amount,
      $currency,
      $order_ref,
      $card_number,
      $card_expire,
      $card_type,
      $card_name,
      $pares
    ) {
        $this->load->model('checkout/order');

        $timestamp = strftime("%Y%m%d%H%M%S");
        $merchant_id = $this->config->get('realex_remote_merchant_id');
        $secret = $this->config->get('realex_remote_secret');

        $tmp = $timestamp . '.' . $merchant_id . '.' . $order_ref . '.' . $amount . '.' . $currency . '.' . $card_number;
        $hash = sha1($tmp);
        $tmp = $hash . '.' . $secret;
        $hash = sha1($tmp);

        $xml = '';
        $xml .= '<request type="3ds-verifysig" timestamp="' . $timestamp . '">';
        $xml .= '<merchantid>' . $merchant_id . '</merchantid>';
        $xml .= '<account>' . $account . '</account>';
        $xml .= '<orderid>' . $order_ref . '</orderid>';
        $xml .= '<amount currency="' . $currency . '">' . (int)$amount . '</amount>';
        $xml .= '<card>';
        $xml .= '<number>' . $card_number . '</number>';
        $xml .= '<expdate>' . $card_expire . '</expdate>';
        $xml .= '<type>' . $card_type . '</type>';
        $xml .= '<chname>' . $card_name . '</chname>';
        $xml .= '</card>';
        $xml .= '<pares>' . $pares . '</pares>';
        $xml .= '<sha1hash>' . $hash . '</sha1hash>';
        $xml .= '</request>';

        $this->logger('enrollmentSignature call');
        $this->logger(simplexml_load_string($xml));
        $this->logger($xml);

        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, "https://epage.payandshop.com/epage-3dsecure.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);

        $this->logger('enrollmentSignature xml response');
        $this->logger($response);

        return simplexml_load_string($response);
    }

    public function capturePayment(
      $account,
      $amount,
      $currency,
      $order_id,
      $order_ref,
      $card_number,
      $expire,
      $name,
      $type,
      $cvv,
      $issue,
      $eci_ref,
      $eci = '',
      $cavv = '',
      $xid = ''
    ) {
        $this->load->model('checkout/order');

        $timestamp = strftime("%Y%m%d%H%M%S");
        $merchant_id = $this->config->get('realex_remote_merchant_id');
        $secret = $this->config->get('realex_remote_secret');

        $tmp = $timestamp . '.' . $merchant_id . '.' . $order_ref . '.' . $amount . '.' . $currency . '.' . $card_number;
        $hash = sha1($tmp);
        $tmp = $hash . '.' . $secret;
        $hash = sha1($tmp);

        $order_info = $this->model_checkout_order->getOrder($order_id);

        $xml = '';
        $xml .= '<request type="auth" timestamp="' . $timestamp . '">';
        $xml .= '<merchantid>' . $merchant_id . '</merchantid>';
        $xml .= '<account>' . $account . '</account>';
        $xml .= '<orderid>' . $order_ref . '</orderid>';
        $xml .= '<amount currency="' . $currency . '">' . $amount . '</amount>';
        $xml .= '<comments>';
        $xml .= '<comment id="1">OpenCart</comment>';
        $xml .= '</comments>';
        $xml .= '<card>';
        $xml .= '<number>' . $card_number . '</number>';
        $xml .= '<expdate>' . $expire . '</expdate>';
        $xml .= '<type>' . $type . '</type>';
        $xml .= '<chname>' . $name . '</chname>';
        $xml .= '<cvn>';
        $xml .= '<number>' . (int)$cvv . '</number>';
        $xml .= '<presind>2</presind>';
        $xml .= '</cvn>';
        if (!empty($issue)) {
            $xml .= '<issueno>' . (int)$issue . '</issueno>';
        }
        $xml .= '</card>';

        if ($this->config->get('realex_remote_auto_settle') == 0) {
            $xml .= '<autosettle flag="0" />';
        } elseif ($this->config->get('realex_remote_auto_settle') == 1) {
            $xml .= '<autosettle flag="1" />';
        } elseif ($this->config->get('realex_remote_auto_settle') == 2) {
            $xml .= '<autosettle flag="MULTI" />';
        }

        if ($eci != '' || $cavv != '' || $xid != '') {
            $xml .= '<mpi>';
            if ($eci != '') {
                $xml .= '<eci>' . (string)$eci . '</eci>';
            }
            if ($cavv != '') {
                $xml .= '<cavv>' . (string)$cavv . '</cavv>';
            }
            if ($xid != '') {
                $xml .= '<xid>' . (string)$xid . '</xid>';
            }
            $xml .= '</mpi>';
        }

        $xml .= '<sha1hash>' . $hash . '</sha1hash>';

        if ($this->config->get('realex_remote_tss_check') == 1) {
            $xml .= '<tssinfo>';
            $xml .= '<custipaddress>' . $order_info['ip'] . '</custipaddress>';

            if ($this->customer->getId() > 0) {
                $xml .= '<custnum>' . (int)$this->customer->getId() . '</custnum>';
            }

            if ((isset($order_info['payment_iso_code_2']) && !empty($order_info['payment_iso_code_2'])) || (isset($order_info['payment_postcode']) && !empty($order_info['payment_postcode']))) {
                $xml .= '<address type="billing">';
                if ((isset($order_info['payment_postcode']) && !empty($order_info['payment_postcode']))) {
                    $xml .= '<code>' . filter_var($order_info['payment_postcode'],
                        FILTER_SANITIZE_NUMBER_INT) . '|' . filter_var($order_info['payment_address_1'],
                        FILTER_SANITIZE_NUMBER_INT) . '</code>';
                }
                if ((isset($order_info['payment_iso_code_2']) && !empty($order_info['payment_iso_code_2']))) {
                    $xml .= '<country>' . $order_info['payment_iso_code_2'] . '</country>';
                }
                $xml .= '</address>';
            }
            if ((isset($order_info['shipping_iso_code_2']) && !empty($order_info['shipping_iso_code_2'])) || (isset($order_info['shipping_postcode']) && !empty($order_info['shipping_postcode']))) {
                $xml .= '<address type="shipping">';
                if ((isset($order_info['shipping_postcode']) && !empty($order_info['shipping_postcode']))) {
                    $xml .= '<code>' . filter_var($order_info['shipping_postcode'],
                        FILTER_SANITIZE_NUMBER_INT) . '|' . filter_var($order_info['shipping_address_1'],
                        FILTER_SANITIZE_NUMBER_INT) . '</code>';
                }
                if ((isset($order_info['shipping_iso_code_2']) && !empty($order_info['shipping_iso_code_2']))) {
                    $xml .= '<country>' . $order_info['shipping_iso_code_2'] . '</country>';
                }
                $xml .= '</address>';
            }
            $xml .= '</tssinfo>';
        }

        $xml .= '</request>';

        $this->logger('capturePayment call');
        $this->logger(simplexml_load_string($xml));
        $this->logger($xml);

        $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);

        $this->logger('capturePayment xml response');
        $this->logger($response);

        $response = simplexml_load_string($response);

        $this->load->language('extension/payment/realex_remote');

        $message = '<strong>' . $this->language->get('text_result') . ':</strong> ' . (int)$response->result;
        $message .= '<br /><strong>' . $this->language->get('text_message') . ':</strong> ' . (string)$response->message;
        $message .= '<br /><strong>' . $this->language->get('text_order_ref') . ':</strong> ' . (string)$order_ref;

        if (isset($response->cvnresult) && !empty($response->cvnresult)) {
            $message .= '<br /><strong>' . $this->language->get('text_cvn_result') . ':</strong> ' . (string)$response->cvnresult;
        }

        if (isset($response->avspostcoderesponse) && !empty($response->avspostcoderesponse)) {
            $message .= '<br /><strong>' . $this->language->get('text_avs_postcode') . ':</strong> ' . (string)$response->avspostcoderesponse;
        }

        if (isset($response->avsaddressresponse) && !empty($response->avsaddressresponse)) {
            $message .= '<br /><strong>' . $this->language->get('text_avs_address') . ':</strong> ' . (string)$response->avsaddressresponse;
        }

        if (isset($response->authcode) && !empty($response->authcode)) {
            $message .= '<br /><strong>' . $this->language->get('text_auth_code') . ':</strong> ' . (string)$response->authcode;
        }

        if (!empty($eci_ref)) {
            $message .= '<br /><strong>' . $this->language->get('text_eci') . ':</strong> (' . (int)$eci . ') ' . $this->language->get('text_3d_s' . (int)$eci_ref);
        }

        if (isset($response->tss->result) && !empty($response->tss->result)) {
            $message .= '<br /><strong>' . $this->language->get('text_tss') . ':</strong> ' . (int)$response->tss->result;
        }

        $message .= '<br /><strong>' . $this->language->get('text_timestamp') . ':</strong> ' . (string)$timestamp;

        if ($this->config->get('realex_remote_card_data_status') == 1) {
            $message .= '<br /><strong>' . $this->language->get('entry_cc_type') . ':</strong> ' . (string)$type;
            $message .= '<br /><strong>' . $this->language->get('text_last_digits') . ':</strong> ' . (string)substr($card_number,
                -4);
            $message .= '<br /><strong>' . $this->language->get('entry_cc_expire_date') . ':</strong> ' . (string)$expire;
            $message .= '<br /><strong>' . $this->language->get('entry_cc_name') . ':</strong> ' . (string)$name;

            if (isset($response->cardissuer->bank) && !empty($response->cardissuer->bank)) {
                $message .= '<br /><strong>' . $this->language->get('text_card_bank') . ':</strong> ' . (string)$response->cardissuer->bank;
            }

            if (isset($response->cardissuer->country) && !empty($response->cardissuer->country)) {
                $message .= '<br /><strong>' . $this->language->get('text_card_country') . ':</strong> ' . (string)$response->cardissuer->country;
            }

            if (isset($response->cardissuer->region) && !empty($response->cardissuer->region)) {
                $message .= '<br /><strong>' . $this->language->get('text_card_region') . ':</strong> ' . (string)$response->cardissuer->region;
            }
        }

        if ($response->result == '00') {
            $this->model_checkout_order->addOrderHistory($order_id, $this->config->get('config_order_status_id'));

            $realex_order_id = $this->addOrder($order_info, $response, $account, $order_ref);

            if ($this->config->get('realex_remote_auto_settle') == 1) {
                $this->addTransaction($realex_order_id, 'payment', $order_info);
                $this->model_checkout_order->addOrderHistory($order_id,
                  $this->config->get('realex_remote_order_status_success_settled_id'), $message);
            } else {
                $this->addTransaction($realex_order_id, 'auth', 0);
                $this->model_checkout_order->addOrderHistory($order_id,
                  $this->config->get('realex_remote_order_status_success_unsettled_id'), $message);
            }
        } elseif ($response->result == "101") {
            // Decline
            $this->addHistory($order_id, $this->config->get('realex_remote_order_status_decline_id'), $message);
        } elseif ($response->result == "102") {
            // Referal B
            $this->addHistory($order_id, $this->config->get('realex_remote_order_status_decline_pending_id'), $message);
        } elseif ($response->result == "103") {
            // Referal A
            $this->addHistory($order_id, $this->config->get('realex_remote_order_status_decline_stolen_id'), $message);
        } elseif ($response->result == "200") {
            // Error Connecting to Bank
            $this->addHistory($order_id, $this->config->get('realex_remote_order_status_decline_bank_id'), $message);
        } elseif ($response->result == "204") {
            // Error Connecting to Bank
            $this->addHistory($order_id, $this->config->get('realex_remote_order_status_decline_bank_id'), $message);
        } elseif ($response->result == "205") {
            // Comms Error
            $this->addHistory($order_id, $this->config->get('realex_remote_order_status_decline_bank_id'), $message);
        } else {
            // Other
            $this->addHistory($order_id, $this->config->get('realex_remote_order_status_decline_id'), $message);
        }

        return $response;
    }

    public function addOrder($order_info, $response, $account, $order_ref)
    {
        if ($this->config->get('realex_remote_auto_settle') == 1) {
            $settle_status = 1;
        } else {
            $settle_status = 0;
        }

        $this->db->query("INSERT INTO `" . DB_PREFIX . "realex_remote_order` SET `order_id` = '" . (int)$order_info['order_id'] . "', `settle_type` = '" . (int)$this->config->get('realex_remote_auto_settle') . "', `order_ref` = '" . $this->db->escape($order_ref) . "', `order_ref_previous` = '" . $this->db->escape($order_ref) . "', `date_added` = now(), `date_modified` = now(), `capture_status` = '" . (int)$settle_status . "', `currency_code` = '" . $this->db->escape($order_info['currency_code']) . "', `pasref` = '" . $this->db->escape($response->pasref) . "', `pasref_previous` = '" . $this->db->escape($response->pasref) . "', `authcode` = '" . $this->db->escape($response->authcode) . "', `account` = '" . $this->db->escape($account) . "', `total` = '" . $this->currency->format($order_info['total'],
            $order_info['currency_code'], $order_info['currency_value'], false) . "'");

        return $this->db->getLastId();
    }

    public function addTransaction($realex_remote_order_id, $type, $order_info)
    {
        $this->db->query("INSERT INTO `" . DB_PREFIX . "realex_remote_order_transaction` SET `realex_remote_order_id` = '" . (int)$realex_remote_order_id . "', `date_added` = now(), `type` = '" . $this->db->escape($type) . "', `amount` = '" . $this->currency->format($order_info['total'],
            $order_info['currency_code'], $order_info['currency_value'], false) . "'");
    }

    public function logger($message)
    {
        if ($this->config->get('realex_remote_debug') == 1) {
            $log = new Log('realex_remote.log');
            $log->write($message);
        }
    }

    public function addHistory($order_id, $order_status_id, $comment)
    {
        $this->db->query("INSERT INTO " . DB_PREFIX . "order_history SET order_id = '" . (int)$order_id . "', order_status_id = '" . (int)$order_status_id . "', notify = '0', comment = '" . $this->db->escape($comment) . "', date_added = NOW()");
    }

}