quomo Posted September 3, 2003 Posted September 3, 2003 I read loads of topics and cant find an answer to why Im not able to see the orders. I create this piece of PHP from authorizenet.php in order to establish a conection with EUROCONEX (if I fix this it would be my first contribution). Everything works alright. The only problem is that it seems that * the shooping cart is not empty after a transaction * I get no orders appearing in any of the status * The order history of the customers account is empty Am I missing any step? Any ideas of where to check? I enclosed the piece of code that conect me to EUROCONEX. <?php/* $Id: euroconex.php,v 1.47 2003/09/02 05:51:31 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ class euroconex { var $code, $title, $description, $enabled; // class constructor function euroconex() { global $order; $this->code = 'euroconex'; $this->title = MODULE_PAYMENT_EUROCONEX_TEXT_TITLE; $this->description = MODULE_PAYMENT_EUROCONEX_TEXT_DESCRIPTION; $this->enabled = ((MODULE_PAYMENT_EUROCONEX_STATUS == 'True') ? true : false); $this->sort_order = MODULE_PAYMENT_EUROCONEX_SORT_ORDER; if ((int)MODULE_PAYMENT_EUROCONEX_ORDER_STATUS_ID > 0) { $this->order_status = MODULE_PAYMENT_EUROCONEX_ORDER_STATUS_ID; } if (is_object($order)) $this->update_status(); $this->form_action_url = 'http://testclikpay.euroconex.com/process.asp'; } // Euroconex utility functions // DISCLAIMER: // This code is a modification of the module authorizenet.php to create and manage a conection with EUROCONEX-CLIKPAY. // // function InsertFP ($loginid, $txnkey, $amount, $sequence) - Insert HTML form elements required for SIM // function CalculateFP ($loginid, $txnkey, $amount, $sequence, $tstamp) - Returns Fingerprint. // compute HMAC-MD5 // Uses PHP mhash extension. Pl sure to enable the extension // function hmac ($key, $data) { // return (bin2hex (mhash(MHASH_MD5, $data, $key))); //} // Thanks is lance from http://www.php.net/manual/en/function.mhash.php //lance_rushing at hot* spamfree *mail dot com //27-Nov-2002 09:36 // //Want to Create a md5 HMAC, but don't have hmash installed? // //Use this: function hmac ($key, $data) { // RFC 2104 HMAC implementation for php. // Creates an md5 HMAC. // Eliminates the need to install mhash to compute a HMAC // Hacked by Lance Rushing $b = 64; // byte length for md5 if (strlen($key) > $b) { $key = pack("H*",md5($key)); } $key = str_pad($key, $b, chr(0x00)); $ipad = str_pad('', $b, chr(0x36)); $opad = str_pad('', $b, chr(0x5c)); $k_ipad = $key ^ $ipad ; $k_opad = $key ^ $opad; return md5($k_opad . pack("H*",md5($k_ipad . $data))); } // end code from lance (resume Euroconex code) // Calculate and return fingerprint // Use when you need control on the HTML output function CalculateFP ($clikpayid, $amount, $sequence, $tstamp, $currency = "") { return ($this->hmac ($clikpayid . "^" . $sequence . "^" . $tstamp . "^" . $amount . "^" . $currency)); } // Inserts the hidden variables in the HTML FORM required for SIM // Invokes hmac function to calculate fingerprint. function InsertFP ($clikpayid, $amount, $sequence, $currency = "") { $tstamp = time (); $fingerprint = $this->hmac ($clikpayid . "^" . $sequence . "^" . $tstamp . "^" . $amount . "^" . $currency); $str = tep_draw_hidden_field('x_fp_sequence', $sequence) . tep_draw_hidden_field('x_fp_timestamp', $tstamp) . tep_draw_hidden_field('x_fp_hash', $fingerprint); return $str; } // end Euroconex code // class methods function update_status() { global $order; if ( ($this->enabled == true) && ((int)MODULE_PAYMENT_EUROCONEX_ZONE > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_PAYMENT_EUROCONEX_ZONE . "' and zone_country_id = '" . $order->billing['country']['id'] . "' order by zone_id"); while ($check = tep_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->billing['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } } function javascript_validation() { $js = ' if (payment_value == "' . $this->code . '") {' . "n" . ' var cc_owner = document.checkout_payment.EUROCONEX_cc_owner.value;' . "n" . ' var cc_number = document.checkout_payment.EUROCONEX_cc_number.value;' . "n" . ' if (cc_owner == "" || cc_owner.length < ' . CC_OWNER_MIN_LENGTH . ') {' . "n" . ' error_message = error_message + "' . MODULE_PAYMENT_EUROCONEX_TEXT_JS_CC_OWNER . '";' . "n" . ' error = 1;' . "n" . ' }' . "n" . ' if (cc_number == "" || cc_number.length < ' . CC_NUMBER_MIN_LENGTH . ') {' . "n" . ' error_message = error_message + "' . MODULE_PAYMENT_EUROCONEX_TEXT_JS_CC_NUMBER . '";' . "n" . ' error = 1;' . "n" . ' }' . "n" . ' }' . "n"; return $js; } function selection() { global $order; for ($i=1; $i<13; $i++) { $expires_month[] = array('id' => sprintf('%02d', $i), 'text' => strftime('%B',mktime(0,0,0,$i,1,2000))); } $today = getdate(); for ($i=$today['year']; $i < $today['year']+10; $i++) { $expires_year[] = array('id' => strftime('%y',mktime(0,0,0,1,1,$i)), 'text' => strftime('%Y',mktime(0,0,0,1,1,$i))); } $selection = array('id' => $this->code, 'module' => $this->title, 'fields' => array(array('title' => MODULE_PAYMENT_EUROCONEX_TEXT_CREDIT_CARD_OWNER, 'field' => tep_draw_input_field('euroconex_cc_owner', $order->billing['firstname'] . ' ' . $order->billing['lastname'])), array('title' => MODULE_PAYMENT_EUROCONEX_TEXT_CREDIT_CARD_NUMBER, 'field' => tep_draw_input_field('euroconex_cc_number')), array('title' => MODULE_PAYMENT_EUROCONEX_TEXT_CREDIT_CARD_EXPIRES, 'field' => tep_draw_pull_down_menu('euroconex_cc_expires_month', $expires_month) . ' ' . tep_draw_pull_down_menu('euroconex_cc_expires_year', $expires_year)))); return $selection; } function pre_confirmation_check() { global $HTTP_POST_VARS; include(DIR_WS_CLASSES . 'cc_validation.php'); $cc_validation = new cc_validation(); $result = $cc_validation->validate($HTTP_POST_VARS['euroconex_cc_number'], $HTTP_POST_VARS['euroconex_cc_expires_month'], $HTTP_POST_VARS['euroconex_cc_expires_year']); $error = ''; switch ($result) { case -1: $error = sprintf(TEXT_CCVAL_ERROR_UNKNOWN_CARD, substr($cc_validation->cc_number, 0, 4)); break; case -2: case -3: case -4: $error = TEXT_CCVAL_ERROR_INVALID_DATE; break; case false: $error = TEXT_CCVAL_ERROR_INVALID_NUMBER; break; } if ( ($result == false) || ($result < 1) ) { $payment_error_return = 'payment_error=' . $this->code . '&error=' . urlencode($error) . '&euroconex_cc_owner=' . urlencode($HTTP_POST_VARS['euroconex_cc_owner']) . '&euroconex_cc_expires_month=' . $HTTP_POST_VARS['euroconex_cc_expires_month'] . '&euroconex_cc_expires_year=' . $HTTP_POST_VARS['euroconex_cc_expires_year']; tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, $payment_error_return, 'SSL', true, false)); } $this->cc_card_type = $cc_validation->cc_type; $this->cc_card_number = $cc_validation->cc_number; $this->cc_expiry_month = $cc_validation->cc_expiry_month; $this->cc_expiry_year = $cc_validation->cc_expiry_year; } function confirmation() { global $HTTP_POST_VARS; $confirmation = array('title' => $this->title . ': ' . $this->cc_card_type, 'fields' => array(array('title' => MODULE_PAYMENT_EUROCONEX_TEXT_CREDIT_CARD_OWNER, 'field' => $HTTP_POST_VARS['euroconex_cc_owner']), array('title' => MODULE_PAYMENT_EUROCONEX_TEXT_CREDIT_CARD_NUMBER, 'field' => substr($this->cc_card_number, 0, 4) . str_repeat('X', (strlen($this->cc_card_number) - 8)) . substr($this->cc_card_number, -4)), array('title' => MODULE_PAYMENT_EUROCONEX_TEXT_CREDIT_CARD_EXPIRES, 'field' => strftime('%B, %Y', mktime(0,0,0,$HTTP_POST_VARS['euroconex_cc_expires_month'], 1, '20' . $HTTP_POST_VARS['euroconex_cc_expires_year']))))); return $confirmation; } function process_button() { global $HTTP_SERVER_VARS, $order, $customer_id; $sequence = rand(1, 1000); $process_button_string = tep_draw_hidden_field('clikpay_id', MODULE_PAYMENT_EUROCONEX_LOGIN) . tep_draw_hidden_field('card_number', $this->cc_card_number) . tep_draw_hidden_field('card_exp_date', $this->cc_expiry_month . substr($this->cc_expiry_year, -2)) . tep_draw_hidden_field('amount', number_format($order->info['total'], 2)) . tep_draw_hidden_field('customer_id', $customer_id) . tep_draw_hidden_field('billto_firstname', $order->customer['firstname']) . tep_draw_hidden_field('billto_lastname', $order->customer['lastname']) . tep_draw_hidden_field('billto_address', $order->customer['street_address']) . tep_draw_hidden_field('billto_city', $order->customer['city']) . tep_draw_hidden_field('billto_postalcode', $order->customer['postcode']) . tep_draw_hidden_field('billto_country', $order->customer['country']['title']) . tep_draw_hidden_field('billto_phone', $order->customer['telephone']) . tep_draw_hidden_field('billto_email', $order->customer['email_address']) . tep_draw_hidden_field('shipto_first_name', $order->delivery['firstname']) . tep_draw_hidden_field('shipto_last_name', $order->delivery['lastname']) . tep_draw_hidden_field('shipto_address', $order->delivery['street_address']) . tep_draw_hidden_field('shipto_city', $order->delivery['city']) . tep_draw_hidden_field('shipto_postalcode', $order->delivery['postcode']) . tep_draw_hidden_field('shipto_country', $order->delivery['country']['title']) . tep_draw_hidden_field('customer_ip', $HTTP_SERVER_VARS['REMOTE_ADDR']) . $this->InsertFP(MODULE_PAYMENT_EUROCONEX_CLIKPAY_ID, number_format($order->info['total'], 2), $sequence); if (MODULE_PAYMENT_EUROCONEX_TESTMODE == 'on') $process_button_string .= tep_draw_hidden_field('x_Test_Request', 'TRUE'); $process_button_string .= tep_draw_hidden_field(tep_session_name(), tep_session_id()); return $process_button_string; } function before_process() { global $HTTP_POST_VARS; if ($HTTP_POST_VARS['x_response_code'] == '1') return; if ($HTTP_POST_VARS['x_response_code'] == '2') { tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(MODULE_PAYMENT_EUROCONEX_TEXT_DECLINED_MESSAGE), 'SSL', true, false)); } // Code 3 is an error - but anything else is an error too (IMHO) tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode(MODULE_PAYMENT_EUROCONEX_TEXT_ERROR_MESSAGE), 'SSL', true, false)); } function after_process() { return false; } function get_error() { global $HTTP_GET_VARS; $error = array('title' => MODULE_PAYMENT_EUROCONEX_TEXT_ERROR, 'error' => stripslashes(urldecode($HTTP_GET_VARS['error']))); return $error; } function check() { if (!isset($this->_check)) { $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PAYMENT_EUROCONEX_STATUS'"); $this->_check = tep_db_num_rows($check_query); } return $this->_check; } function install() { tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Euroconex Module', 'MODULE_PAYMENT_EUROCONEX_STATUS', 'True', 'Do you want to accept Euroconex payments?', '6', '0', 'tep_cfg_select_option(array('True', 'False'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('CLIKPAY ID', 'MODULE_PAYMENT_EUROCONEX_CLIKPAY_ID', 'Test', 'Clikpay ID number', '6', '0', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Transaction Mode', 'MODULE_PAYMENT_EUROCONEX_TESTMODE', 'Test', 'Turn ON or OFF Test mode. If ON, no transactions can be made', '6', '0', 'tep_cfg_select_option(array('ON', 'OFF'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort order of display.', 'MODULE_PAYMENT_EUROCONEX_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Payment Zone', 'MODULE_PAYMENT_EUROCONEX_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', '6', '2', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, use_function, date_added) values ('Set Order Status', 'MODULE_PAYMENT_EUROCONEX_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', '6', '0', 'tep_cfg_pull_down_order_statuses(', 'tep_get_order_status_name', now())"); } function remove() { tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')"); } function keys() { return array('MODULE_PAYMENT_EUROCONEX_STATUS', 'MODULE_PAYMENT_EUROCONEX_CLIKPAY_ID', 'MODULE_PAYMENT_EUROCONEX_TESTMODE', 'MODULE_PAYMENT_EUROCONEX_ZONE', 'MODULE_PAYMENT_EUROCONEX_ORDER_STATUS_ID', 'MODULE_PAYMENT_EUROCONEX_SORT_ORDER'); } } ?> Maybe the problem is not here, but any hints?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.