/catalog/model/extension/payment/cardconnect.php

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

		}

	}

}