<?php
class ModelExtensionPaymentCardConnect extends Model
{

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

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

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

        $method_data = array();

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

        return $method_data;
    }

    public function getCardTypes()
    {
        $cards = array();

        $cards[] = array(
          'text'  => 'Visa',
          'value' => 'VISA'
        );

        $cards[] = array(
          'text'  => 'MasterCard',
          'value' => 'MASTERCARD'
        );

        $cards[] = array(
          'text'  => 'Discover Card',
          'value' => 'DISCOVER'
        );

        $cards[] = array(
          'text'  => 'American Express',
          'value' => 'AMEX'
        );

        return $cards;
    }

    public function getMonths()
    {
        $months = array();

        for ($i = 1; $i <= 12; $i++) {
            $months[] = array(
              'text'  => strftime('%B', mktime(0, 0, 0, $i, 1, 2000)),
              'value' => sprintf('%02d', $i)
            );
        }

        return $months;
    }

    public function getYears()
    {
        $years = array();

        $today = getdate();

        for ($i = $today['year']; $i < $today['year'] + 11; $i++) {
            $years[] = array(
              'text'  => strftime('%Y', mktime(0, 0, 0, 1, 1, $i)),
              'value' => strftime('%y', mktime(0, 0, 0, 1, 1, $i))
            );
        }

        return $years;
    }

    public function getCard($token, $customer_id)
    {
        $query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "cardconnect_card` WHERE `token` = '" . $this->db->escape($token) . "' AND `customer_id` = '" . (int)$customer_id . "'");

        if ($query->num_rows) {
            return $query->row;
        } else {
            return false;
        }
    }

    public function getCards($customer_id)
    {
        $query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "cardconnect_card` WHERE `customer_id` = '" . (int)$customer_id . "'");

        return $query->rows;
    }

    public function addCard($cardconnect_order_id, $customer_id, $profileid, $token, $type, $account, $expiry)
    {
        $this->db->query("INSERT INTO `" . DB_PREFIX . "cardconnect_card` SET `cardconnect_order_id` = '" . (int)$cardconnect_order_id . "', `customer_id` = '" . (int)$customer_id . "', `profileid` = '" . $this->db->escape($profileid) . "', `token` = '" . $this->db->escape($token) . "', `type` = '" . $this->db->escape($type) . "', `account` = '" . $this->db->escape($account) . "', `expiry` = '" . $this->db->escape($expiry) . "', `date_added` = NOW()");
    }

    public function deleteCard($token, $customer_id)
    {
        $this->db->query("DELETE FROM `" . DB_PREFIX . "cardconnect_card` WHERE `token` = '" . $this->db->escape($token) . "' AND `customer_id` = '" . (int)$customer_id . "'");
    }

    public function addOrder($order_info, $payment_method)
    {
        $this->db->query("INSERT INTO `" . DB_PREFIX . "cardconnect_order` SET `order_id` = '" . (int)$order_info['order_id'] . "', `customer_id` = '" . (int)$this->customer->getId() . "', `payment_method` = '" . $this->db->escape($payment_method) . "', `retref` = '" . $this->db->escape($order_info['retref']) . "', `authcode` = '" . $this->db->escape($order_info['authcode']) . "', `currency_code` = '" . $this->db->escape($order_info['currency_code']) . "', `total` = '" . $this->currency->format($order_info['total'],
            $order_info['currency_code'], false, false) . "', `date_added` = NOW()");

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

    public function addTransaction($cardconnect_order_id, $type, $status, $order_info)
    {
        $this->db->query("INSERT INTO `" . DB_PREFIX . "cardconnect_order_transaction` SET `cardconnect_order_id` = '" . (int)$cardconnect_order_id . "', `type` = '" . $this->db->escape($type) . "', `retref` = '" . $this->db->escape($order_info['retref']) . "', `amount` = '" . (float)$this->currency->format($order_info['total'],
            $order_info['currency_code'], false,
            false) . "', `status` = '" . $this->db->escape($status) . "', `date_modified` = NOW(), `date_added` = NOW()");
    }

    public function getSettlementStatuses($merchant_id, $date)
    {
        $this->log('Getting settlement statuses from CardConnect');

        $url = 'https://' . $this->config->get('cardconnect_site') . '.cardconnect.com:' . (($this->config->get('cardconnect_environment') == 'live') ? 8443 : 6443) . '/cardconnect/rest/settlestat?merchid=' . $merchant_id . '&date=' . $date;

        $header = array();

        $header[] = 'Content-type: application/json';
        $header[] = 'Authorization: Basic ' . base64_encode($this->config->get('cardconnect_api_username') . ':' . $this->config->get('cardconnect_api_password'));

        $this->model_extension_payment_cardconnect->log('Header: ' . print_r($header, true));

        $this->model_extension_payment_cardconnect->log('URL: ' . $url);

        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
        curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'GET');
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($ch, CURLOPT_TIMEOUT, 30);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        $response_data = curl_exec($ch);
        if (curl_errno($ch)) {
            $this->model_extension_payment_cardconnect->log('cURL error: ' . curl_errno($ch));
        }
        curl_close($ch);

        $response_data = json_decode($response_data, true);

        $this->log('Response: ' . print_r($response_data, true));

        return $response_data;
    }

    public function updateTransactionStatusByRetref($retref, $status)
    {
        $this->db->query("UPDATE `" . DB_PREFIX . "cardconnect_order_transaction` SET `status` = '" . $this->db->escape($status) . "', `date_modified` = NOW() WHERE `retref` = '" . $this->db->escape($retref) . "'");
    }

    public function updateCronRunTime()
    {
        $this->db->query("DELETE FROM `" . DB_PREFIX . "setting` WHERE `key` = 'cardconnect_cron_time'");

        $this->db->query("INSERT INTO `" . DB_PREFIX . "setting` SET `store_id` = '0', `code` = 'cardconnect', `key` = 'cardconnect_cron_time', `value` = NOW(), `serialized` = '0'");
    }

    public function log($data)
    {
        if ($this->config->get('cardconnect_logging')) {
            $log = new Log('cardconnect.log');

            $log->write($data);
        }
    }

}