OpenCart Community

Code: Select all

$data = array();
		
		$data['VendorTxCode'] = $this->session->data['order_id'];
		$data['ReferrerID'] = 'E511AF91-E4A0-42DE-80B0-09C981A3FB61';
		$data['Amount'] = $this->currency->format($order_info['total'], $order_info['currency_code'], $order_info['currency_value'], false);
		$data['Currency'] = $order_info['currency_code'];
		$data['Description'] = sprintf($this->language->get('text_description'), date($this->language->get('date_format_short')), $this->session->data['order_id']);
		$data['SuccessURL'] = str_replace('&', '&', $this->url->link('payment/sagepay/success', 'order_id=' . $this->session->data['order_id']));
		$data['FailureURL'] = str_replace('&', '&', $this->url->link('checkout/checkout', '', 'SSL'));
		
		$data['CustomerName'] = html_entity_decode($order_info['payment_firstname'] . ' ' . $order_info['payment_lastname'], ENT_QUOTES, 'UTF-8');
		$data['SendEMail'] = '1';
		$data['CustomerEMail'] = $order_info['email'];
		$data['VendorEMail'] = $this->config->get('config_email');  
		
		$data['BillingFirstnames'] = $order_info['payment_firstname'];
        $data['BillingSurname'] = $order_info['payment_lastname'];
        $data['BillingAddress1'] = $order_info['payment_address_1'];
		
		if ($order_info['payment_address_2']) {
        	$data['BillingAddress2'] = $order_info['payment_address_2'];
		}
		
		$data['BillingCity'] = $order_info['payment_city'];
       	$data['BillingPostCode'] = $order_info['payment_postcode'];	
        $data['BillingCountry'] = $order_info['payment_iso_code_2'];
		
		if ($order_info['payment_iso_code_2'] == 'US') {
			$data['BillingState'] = $order_info['payment_zone_code'];
		}
		
		$data['BillingPhone'] = $order_info['telephone'];
		
		if ($this->cart->hasShipping()) {
			$data['DeliveryFirstnames'] = $order_info['shipping_firstname'];
        	$data['DeliverySurname'] = $order_info['shipping_lastname'];
        	$data['DeliveryAddress1'] = $order_info['shipping_address_1'];
		
			if ($order_info['shipping_address_2']) {
        		$data['DeliveryAddress2'] = $order_info['shipping_address_2'];
			}
		
        	$data['DeliveryCity'] = $order_info['shipping_city'];
        	$data['DeliveryPostCode'] = $order_info['shipping_postcode'];
        	$data['DeliveryCountry'] = $order_info['shipping_iso_code_2'];
		
			if ($order_info['shipping_iso_code_2'] == 'US') {
				$data['DeliveryState'] = $order_info['shipping_zone_code'];
			}
		
			$data['DeliveryPhone'] = $order_info['telephone'];
		} else {
			$data['DeliveryFirstnames'] = $order_info['payment_firstname'];
        	$data['DeliverySurname'] = $order_info['payment_lastname'];
        	$data['DeliveryAddress1'] = $order_info['payment_address_1'];
		
			if ($order_info['payment_address_2']) {
        		$data['DeliveryAddress2'] = $order_info['payment_address_2'];
			}
		
        	$data['DeliveryCity'] = $order_info['payment_city'];
        	$data['DeliveryPostCode'] = $order_info['payment_postcode'];
        	$data['DeliveryCountry'] = $order_info['payment_iso_code_2'];
		
			if ($order_info['payment_iso_code_2'] == 'US') {
				$data['DeliveryState'] = $order_info['payment_zone_code'];
			}
		
			$data['DeliveryPhone'] = $order_info['telephone'];			
		}
		
		$data['AllowGiftAid'] = '0';
		
		if (!$this->config->get('sagepay_transaction')) {
			$data['ApplyAVSCV2'] = '0';
		}
		
 		$data['Apply3DSecure'] = '0';
		
		$this->data['transaction'] = $this->config->get('sagepay_transaction');
		$this->data['vendor'] = $vendor;
		
		$crypt_data = array();
   
		foreach($data as $key => $value){
   			$crypt_data[] = $key . '=' . $value;
		}

		$this->data['crypt'] = base64_encode($this->simpleXor(utf8_decode(implode('&', $crypt_data)), $password));

Code: Select all

 <input type="hidden" name="Crypt" value="<?php echo $crypt; ?>" />

Code: Select all

$data['Basket'] = Number of lines of detail in the basket field:[sku]Item 1 Description:Quantity of item 1:Unit cost item 1 without tax:Tax applied to item 1:Cost of Item 1 including tax:Total cost of item 1 (Quantity x cost including tax):

Code: Select all

 $count_total_products = 0;
		  //get total product quantities
		   foreach ($this->cart->getProducts() as $product) {
			
			$count_total_products +=  $product['quantity'];
					
			}	
			$productsting = '';
			//sagepay requires colon delimiter. The last 3 fields are left empty with ':' If you want to use those fields then you will need to run another forloop to fetch the totals for combined product quantities. Below is just for name, quantity, and base price.
			foreach ($this->cart->getProducts() as $product) {
			
			$productsting .= $product['name'].':'.$product['quantity'].':'. $this->currency->format($product['price'], $order_info['currency_code'], false, false).':'.':'.':';
					
			}
			//this is the string you will send in the end.
			$main_string_to_send =	$count_total_products.':'.$productsting;
			//send here
			$data['Basket'] = $main_string_to_send;

Code: Select all

$count_total_products = 0;
        //get total rows to be sent in string
         foreach ($this->cart->getProducts() as $product) {
         
         $count_total_products++;
               
         }   
         $productstring = '';
         //sagepay requires colon delimiter. The last 3 fields are left empty with ':' If you want to use those fields then you will need to run another forloop to fetch the totals for combined product quantities. Below is just for name, quantity, and base price.
         foreach ($this->cart->getProducts() as $product) {
         //gather SKU for each product.  ugh.....
		 $sku = $this->model_checkout_order->getSku($product['product_id']);
         $productstring .= '['.$sku.']'.$product['name'].':'.$product['quantity'].':'. $this->currency->format($product['price'], $order_info['currency_code'], false, false).':'.'---'.':'.'---'.':'.'---'.':';
               
         }
         //this is the string you will send in the end.
         $main_string_to_send =   $count_total_products.':'.substr_replace($productstring ,"",-1);
         //send here
         $data['Basket'] = $main_string_to_send;

Code: Select all

public function getSku($product_id) {
		$query = $this->db->query("SELECT sku AS code FROM " . DB_PREFIX . "product WHERE product_id = '" . (int)$product_id . "'");

		return $query->row['code'];
	}	

Code: Select all

$count_total_products = 0;
        //get total rows to be sent in string
         foreach ($this->cart->getProducts() as $product) {
         
         $count_total_products++;
               
         }   
         $productstring = '';
         //sagepay requires colon delimiter. The last 3 fields are left empty with ':' If you want to use those fields then you will need to run another forloop to fetch the totals for combined product quantities. Below is just for name, quantity, and base price.
         foreach ($this->cart->getProducts() as $product) {
         //gather SKU for each product.  ugh.....
		// $sku = $this->model_checkout_order->getSku($product['product_id']);
         $productstring .= $product['name'].':'.$product['quantity'].':'. $this->currency->format($product['price'], $order_info['currency_code'], false, false).':'.'---'.':'.'---'.':'.'---'.':';
               
         }
         //this is the string you will send in the end.
         $main_string_to_send =   $count_total_products.':'.substr_replace($productstring ,"",-1);
         //send here
         $data['Basket'] = $main_string_to_send;

Code: Select all

$count_total_products = 0;
        //get total rows to be sent in string
         foreach ($this->cart->getProducts() as $product) {
         
         $count_total_products++;
               
         }   
         $productstring = '';
		
         //sagepay requires colon delimiter. The last 3 fields are left empty with ':' If you want to use those fields then you will need to run another forloop to fetch the totals for combined product quantities. Below is just for name, quantity, and base price.
		
         foreach ($this->cart->getProducts() as $product) {
         //gather Option SKU for each product.  If no option sku, use normal skuugh.....		 
			
					$sku = $this->model_checkout_order->getOptionSku($product['product_id']);
					if($sku){
					foreach ($sku as $value){
			       $skucode = $value['ob_sku'];
					}
					}else{
						$skucode = $this->model_checkout_order->getSku($product['product_id']);;
					}
					
					$baseprice = $this->currency->format($product['price'], $order_info['currency_code'], false, false);
					
					
				
				$line_total = $this->currency->format($product['price']  * $product['quantity'], $order_info['currency_code'], $order_info['currency_value']);
				
				
			
		 	//set up Basket String
         $productstring .= '['.$skucode.']'.$product['name'].':'.$product['quantity'].':'.$baseprice.':'.'---'.':'.$line_total.':'.$line_total.':';
               
         }
         //this is the string you will send in the end.
         $main_string_to_send =   $count_total_products.':'.substr_replace($productstring ,"",-1);

         //send here
         $data['Basket'] = $main_string_to_send;

Code: Select all

public function getSku($product_id) {
		$query = $this->db->query("SELECT sku AS code FROM " . DB_PREFIX . "product WHERE product_id = '" . (int)$product_id . "'");

		return $query->row['code'];
	}
	public function getOptionSku($product_value_id) {
		$query = $this->db->query("SELECT ob_sku FROM " . DB_PREFIX . "product_option_value WHERE product_id = '" . (int)$product_value_id."'");

		return $query->rows;
	}