Kryptronic Software Support Forum

Hi guys, at the moment the HSBC checkout module in CCP6 does not pass over the shipping address as filled out in the CCP shopping cart, it passes the billing address from the checkout into both the billing and shipping addresses in HSBC. What we would like to do is pass over the correct shipping address in HSBC so that that can be security checked also.

The original code in the HSBC checkout module is as follows:-

<?php

// +--
// | This processor integration references an external
// | URL for processing.  All external processing gateways
// | work in the same manner.  An order information array
// | is made available globally under the the global name
// | 'ecom.order_summary'.
// |
// | This must set a global variable named 'ecom.olpform'
// | which contains the form information to be posted to
// | the external gateway URL.
// |
// | Anything printed within this code will be printed
// | above the form instructions on the payment information
// | page.
// +--

// +--
// | The username entered for HSBC should be in the
// | following format:
// |
// | HSBC Store ID
// +--

// +--
// | THERE IS NO NEED TO EDIT THE CODE BELOW THIS POINT TO
// | ACTIVATE THIS INTEGRATION.  ONLY EDIT THIS CODE TO MODIFY
// | HOW THIS INTEGRATION WORKS.  BE SURE YOU KNOW WHAT YOU'RE
// | DOING!
// +--

// +--
// | Get a few global variables.
// +--

$app      = $this->globals('khxc.app');
$eol      = $this->globals('khxc.eol');
$order    = $this->globals('ecom.order_summary');
$tmp=array();
$private_path       = $this->globals('khxc.path_private');

if ($this->debug) {$this->debugger("hsbcform: Private Path '{$private_path}'");}
require_once($private_path . '/apps/' . $app . '/GBU_OLP/ext/hsbc_crypto.php');

// +--
// | Printable form instructions.
// +--

$instructions = "After verifying your order information and clicking the 'Continue' button, you will be directed to our online processing partner's secure site to enter your payment information. Once your payment information is entered and verified, you will be directed back to this web site for your order confirmation.";

// +--
// | Create our relay URL.
// +--

$url_relay  = $this->globals('khxc.url_ssl') . '/relay/' . $app . '.php';

// +--
// | Set up the olpform array.
// +--

$olpform = array('url'    => 'https://www.cpi.hsbc.com/servlet',
                 'button' => 'Continue',
                 'fields' => array());



// +--
// | Create the HIDDEN fields for the form.
// +--

$olpform['fields']['HIDDEN'][] = array('name'  => 'StorefrontId',
                                       'value' => $order['gateway']['userid']);
$tmp[0] = $order['gateway']['userid'];

$olpform['fields']['HIDDEN'][] = array('name'  => 'CpiDirectResultUrl',
                                       'value' => $url_relay);
$tmp[1] = $url_relay;

$olpform['fields']['HIDDEN'][] = array('name'  => 'CpiReturnUrl',
                                       'value' => $url_relay);
$tmp[2] = $url_relay;

$tmp[3] = 'P';
$olpform['fields']['HIDDEN'][] = array('name'  => 'Mode',
                                       'value' => $tmp[3]);

$tmp[4] = $order['order']['id'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'OrderId',
                                       'value' => $tmp[4]);

$amount = $order['order']['ordertotal'] * 100;
$tmp[5] = $amount;
$olpform['fields']['HIDDEN'][] = array('name'  => 'PurchaseAmount',
                                       'value' => $amount);

$tmp[6] = 'Capture';
$olpform['fields']['HIDDEN'][] = array('name'  => 'TransactionType',
                                       'value' => $tmp[6]);

$tmp[7] = $order['order']['epochorder']."000";
$olpform['fields']['HIDDEN'][] = array('name'  => 'TimeStamp',
                                       'value' => $tmp[7]);

$tmp[8] = $order['order']['fname'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'BillingFirstName',
                                       'value' => $order['order']['fname'] );

$tmp[9] = $order['order']['lname'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'BillingLastName',
                                       'value' => $order['order']['lname']);

$tmp[10] = $order['order']['addone'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'BillingAddress1',
                                       'value' => $order['order']['addone']);

$tmp[11] = $order['order']['addtwo'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'BillingAddress2',
                                       'value' => $order['order']['addtwo']);

$tmp[12] = $order['order']['city'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'BillingCity',
                                       'value' => $order['order']['city']);

$tmp[13] = $order['order']['stateprov'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'BillingCounty',
                                       'value' => $order['order']['stateprov']);

// +--
// | Load the DB class.
// +--

if (!($this->KHXC_DB)) {

     $this->KHXC_DB =& $this->quick_object('KHXC_DB','khxc','KHXC_DB_1');

     if ($this->IsError($this->KHXC_DB)) {return $this->KHXC_DB;}

} // End of if statement.
// Need to find the HSBC Country code
$table = $app . '_country';

$column_string = $this->KHXC_DB->table_column_string($table);

if ($this->IsError($column_string)) {return $column_string;}

$sql   = "SELECT {$column_string} FROM {$table} WHERE id=";
$sql  .= $this->KHXC_DB->quote($order['order']['country']);

$result = $this->KHXC_DB->sql_do(array('sql'   => $sql,
                                       'table' => $table,
                                       'order' => array('id' => 'ASC')));

if ($this->IsError($result)) {return $result;}


// +--
// | Loop through and see if we get a hit on a response code field.
// +--
foreach ($result as $num => $row) {

     $tmp[14] = $row['hsbccode'];

}
$olpform['fields']['HIDDEN'][] = array('name'  => 'BillingCountry',
                                       'value' => $tmp[14]);

$tmp[15] = $order['order']['postalcode'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'BillingPostal',
                                       'value' => $order['order']['postalcode']);
$tmp[16] = $this->globals('khxc_user.id');
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShopperEmail',
                                       'value' => $this->globals('khxc_user.id'));
$tmp[17] = '826';
$olpform['fields']['HIDDEN'][] = array('name'  => 'PurchaseCurrency',
                                       'value' => $tmp[17]);
$tmp[18] = 'Online Order';
$olpform['fields']['HIDDEN'][] = array('name'  => 'OrderDesc',
                                       'value' => $tmp[18]);

$tmp[19] = $order['order']['addone'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingAddress1',
                                       'value' => $order['order']['addone']);

$tmp[20] = $order['order']['addtwo'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingAddress2',
                                       'value' => $order['order']['addtwo']);

$tmp[21] = $order['order']['city'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingCity',
                                       'value' => $order['order']['city']);
$tmp[22] = '826';
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingCountry',
                                       'value' => $tmp[22]);


$tmp[23] = $order['order']['stateprov'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingCounty',
                                       'value' => $order['order']['stateprov']);
$tmp[24] = $order['order']['fname'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingFirstName',
                                       'value' => $order['order']['fname'] );

$tmp[25] = $order['order']['lname'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingLastName',
                                       'value' => $order['order']['lname']);
$tmp[26] = $order['order']['postalcode'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingPostal',
                                       'value' => $order['order']['postalcode']);
                                      



if ($this->debug) {$this->debugger("HSBC: Order Hash Array: " . print_r($tmp,1));}

$orderhash = generateHash($tmp, $order['gateway']['transkey']);
unset($tmp);
if ($this->debug) {$this->debugger("HSBC: Order Hash: '{$orderhash}'");}

$olpform['fields']['HIDDEN'][] = array('name'  => 'OrderHash',
                                       'value' => $orderhash);

// +--
// | Create the DISPLAY fields for the form.
// +--

$olpform['fields']['DISPLAY'][] = array('type'   => 'PAYFORMCONTINUE',
                                        'params' => array('name'     => 'ecom_continue',
                                                          'required' => 1,
                                                          'display'  => 'Payment Information',
                                                          'desc'     => $instructions,
                                                          'option'   => 'Enter Payment Information'));

// +--
// | Globalize the $olpform array and return.
// +--

$this->globals('ecom.olpform',$olpform);

?>






I notice that the shipping address information that we need is in the $order = $this->globals('ecom.order_summary');    array, so i am wondering why we cant substitute in $order['items']['0']['addone']  and $order['items']['0']['addtwo']  etc, assuming that all items are shipped to the same address ofcourse, which is how we have it set up. So we would substitute the following into the code at the shiping addy bit near the bottom....

$tmp[19] = $order['items']['0']['addone'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingAddress1',
                                       'value' => $order['items']['0']['addone']);

$tmp[20] = $order['items']['0']['addtwo'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingAddress2',
                                       'value' => $order['items']['0']['addtwo']);

$tmp[21] = $order['items']['0']['city'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingCity',
                                       'value' => $order['items']['0']['city']);
$tmp[22] = '826';
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingCountry',
                                       'value' => $tmp[22]);


$tmp[23] = $order['items']['0']['stateprov'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingCounty',
                                       'value' => $order['items']['0']['stateprov']);
$tmp[24] = $order['items']['0']['fname'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingFirstName',
                                       'value' => $order['items']['0']['fname']);

$tmp[25] = $order['items']['0']['lname'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingLastName',
                                       'value' => $order['items']['0']['lname']);
$tmp[26] = $order['items']['0']['postalcode'];
$olpform['fields']['HIDDEN'][] = array('name'  => 'ShippingPostal',
                                       'value' => $order['items']['0']['postalcode']);
                                      




When testing this however, the HSBC system throws it straight back to CCP6 with an error. Any ideas Howard or anyone, because when i echo out all the array values that ive substituted the i get the data back that i want... when it goes into the hsbc module to get sent to hsbc thouugh it doesnt work, cant really see where its going wrong? Thanks in advance, Andy