<?php
/*
$Id: createPOaccount.php,v 1.65 2003/06/09 23:03:54 hpdl Exp $
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
Released under the GNU General Public License
*/
require('includes/application_top.php');
if (!tep_session_is_registered('customer_id')) {
$navigation->set_snapshot();
tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));
}
// needs to be included earlier to set the success message in the messageStack
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CREATEPOACCOUNT);
$process = false;
if (isset($HTTP_POST_VARS['action']) && ($HTTP_POST_VARS['action'] == 'process')) {
$process = true;
if (ACCOUNT_GENDER == 'true') {
if (isset($HTTP_POST_VARS['gender'])) {
$gender = tep_db_prepare_input($HTTP_POST_VARS['gender']);
} else {
$gender = false;
}
}
$company = tep_db_prepare_input($HTTP_POST_VARS['company']);
$creditrequest = tep_db_prepare_input($HTTP_POST_VARS['creditrequest']);
$street_address = tep_db_prepare_input($HTTP_POST_VARS['street_address']);
$city = tep_db_prepare_input($HTTP_POST_VARS['city']);
if (ACCOUNT_STATE == 'true') {
$state = tep_db_prepare_input($HTTP_POST_VARS['state']);
if (isset($HTTP_POST_VARS['zone_id'])) {
$zone_id = tep_db_prepare_input($HTTP_POST_VARS['zone_id']);
} else {
$zone_id = false;
}
}
$postcode = tep_db_prepare_input($HTTP_POST_VARS['postcode']);
$firstname = tep_db_prepare_input($HTTP_POST_VARS['firstname']);
$lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']);
$dob = tep_db_prepare_input($HTTP_POST_VARS['dob']);
$mensualite = tep_db_prepare_input($HTTP_POST_VARS['mensualite']);
$email_address = tep_db_prepare_input($HTTP_POST_VARS['email_address']);
$country = tep_db_prepare_input($HTTP_POST_VARS['country']);
$telephone = tep_db_prepare_input($HTTP_POST_VARS['telephone']);
$fax = tep_db_prepare_input($HTTP_POST_VARS['fax']);
$time_in_business = tep_db_prepare_input($HTTP_POST_VARS['time_in_business']);
$company_type = tep_db_prepare_input($HTTP_POST_VARS['company_type']);
$number_of_employees = tep_db_prepare_input($HTTP_POST_VARS['number_of_employees']);
$credit_ref1 = tep_db_prepare_input($HTTP_POST_VARS['credit_ref1']);
$credit_ref1address = tep_db_prepare_input($HTTP_POST_VARS['credit_ref1address']);
$credit_ref1city = tep_db_prepare_input($HTTP_POST_VARS['credit_ref1city']);
$credit_ref1state = tep_db_prepare_input($HTTP_POST_VARS['credit_ref1state']);
$credit_ref1phone = tep_db_prepare_input($HTTP_POST_VARS['credit_ref1phone']);
$credit_ref1fax = tep_db_prepare_input($HTTP_POST_VARS['credit_ref1fax']);
$credit_ref2 = tep_db_prepare_input($HTTP_POST_VARS['credit_ref2']);
$credit_ref2address = tep_db_prepare_input($HTTP_POST_VARS['credit_ref2address']);
$credit_ref2city = tep_db_prepare_input($HTTP_POST_VARS['credit_ref2city']);
$credit_ref2state = tep_db_prepare_input($HTTP_POST_VARS['credit_ref2state']);
$credit_ref2phone = tep_db_prepare_input($HTTP_POST_VARS['credit_ref2phone']);
$credit_ref2fax = tep_db_prepare_input($HTTP_POST_VARS['credit_ref2fax']);
$credit_ref3 = tep_db_prepare_input($HTTP_POST_VARS['credit_ref3']);
$credit_ref3address = tep_db_prepare_input($HTTP_POST_VARS['credit_ref3address']);
$credit_ref3city = tep_db_prepare_input($HTTP_POST_VARS['credit_ref3city']);
$credit_ref3state = tep_db_prepare_input($HTTP_POST_VARS['credit_ref3state']);
$credit_ref3phone = tep_db_prepare_input($HTTP_POST_VARS['credit_ref3phone']);
$credit_ref3fax = tep_db_prepare_input($HTTP_POST_VARS['credit_ref3fax']);
$contacttelephone = tep_db_prepare_input($HTTP_POST_VARS['contacttelephone']);
if (isset($HTTP_POST_VARS['newsletter'])) {
$newsletter = tep_db_prepare_input($HTTP_POST_VARS['newsletter']);
} else {
$newsletter = false;
}
$password = tep_db_prepare_input($HTTP_POST_VARS['password']);
$confirmation = tep_db_prepare_input($HTTP_POST_VARS['confirmation']);
$error = false;
if (ACCOUNT_GENDER == 'true') {
if ( ($gender != 'm') && ($gender != 'f') ) {
$error = true;
$messageStack->add('create_account', ENTRY_GENDER_ERROR);
}
}
if (strlen($firstname) < ENTRY_FIRST_NAME_MIN_LENGTH) {
$error = true;
$messageStack->add('create_account', ENTRY_FIRST_NAME_ERROR);
}
if (strlen($lastname) < ENTRY_LAST_NAME_MIN_LENGTH) {
$error = true;
$messageStack->add('create_account', ENTRY_LAST_NAME_ERROR);
}
if (ACCOUNT_DOB == 'true') {
if (checkdate(substr(tep_date_raw($dob), 4, 2), substr(tep_date_raw($dob), 6, 2), substr(tep_date_raw($dob), 0, 4)) == false) {
$error = true;
$messageStack->add('create_account', ENTRY_DATE_OF_BIRTH_ERROR);
}
}
if (strlen($email_address) < ENTRY_EMAIL_ADDRESS_MIN_LENGTH) {
$error = false;
$messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR);
} elseif (tep_validate_email($email_address) == true) {
$error = false;
$messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_CHECK_ERROR);
} else {
$check_email_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");
$check_email = tep_db_fetch_array($check_email_query);
if ($check_email['total'] > 0)
{ //PWA delete account
$get_customer_info = tep_db_query("select customers_id, customers_email_address, purchased_without_account from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");
$customer_info = tep_db_fetch_array($get_customer_info);
$customer_id = $customer_info['customers_id'];
$customer_email_address = $customer_info['customers_email_address'];
$customer_pwa = $customer_info['purchased_without_account'];
if ($customer_pwa !='1')
{
$error =false;
$messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS);
} else {
tep_db_query("delete from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $customer_id . "'");
tep_db_query("delete from " . TABLE_CUSTOMERS . " where customers_id = '" . $customer_id . "'");
tep_db_query("delete from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . $customer_id . "'");
tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . $customer_id . "'");
tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . $customer_id . "'");
tep_db_query("delete from " . TABLE_WHOS_ONLINE . " where customer_id = '" . $customer_id . "'");
}
}
// END
}
if (strlen($street_address) < ENTRY_STREET_ADDRESS_MIN_LENGTH) {
$error = true;
$messageStack->add('create_account', ENTRY_STREET_ADDRESS_ERROR);
}
if (strlen($postcode) < ENTRY_POSTCODE_MIN_LENGTH) {
$error = true;
$messageStack->add('create_account', ENTRY_POST_CODE_ERROR);
}
if (strlen($city) < ENTRY_CITY_MIN_LENGTH) {
$error = true;
$messageStack->add('create_account', ENTRY_CITY_ERROR);
}
if (is_numeric($country) == false) {
$error = true;
$messageStack->add('create_account', ENTRY_COUNTRY_ERROR);
}
if (ACCOUNT_STATE == 'true') {
$zone_id = 0;
$check_query = tep_db_query("select count(*) as total from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "'");
$check = tep_db_fetch_array($check_query);
$entry_state_has_zones = ($check['total'] > 0);
if ($entry_state_has_zones == true) {
$zone_query = tep_db_query("select distinct zone_id from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' and (zone_name like '" . tep_db_input($state) . "%' or zone_code like '%" . tep_db_input($state) . "%')");
if (tep_db_num_rows($zone_query) == 1) {
$zone = tep_db_fetch_array($zone_query);
$zone_id = $zone['zone_id'];
} else {
$error = true;
$messageStack->add('create_account', ENTRY_STATE_ERROR_SELECT);
}
} else {
if (strlen($state) < ENTRY_STATE_MIN_LENGTH) {
$error = true;
$messageStack->add('create_account', ENTRY_STATE_ERROR);
}
}
}
if (strlen($telephone) < ENTRY_TELEPHONE_MIN_LENGTH) {
$error = true;
$messageStack->add('create_account', ENTRY_TELEPHONE_NUMBER_ERROR);
}
if (strlen($password) < ENTRY_PASSWORD_MIN_LENGTH) {
$error = true;
$messageStack->add('create_account', ENTRY_PASSWORD_ERROR);
} elseif ($password != $confirmation) {
$error = true;
$messageStack->add('create_account', ENTRY_PASSWORD_ERROR_NOT_MATCHING);
}
if (isset($_POST['$messageStack']) && $_POST['$messageStack'] == 'deroulant') ;
if ($error == false) {
$sql_data_array = array('customers_firstname' => $firstname,
'customers_lastname' => $lastname,
'customers_email_address' => $email_address,
'customers_telephone' => $telephone,
'customers_fax' => $fax,
'customers_newsletter' => $newsletter,
'customers_password' => tep_encrypt_password($password));
if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $gender;
if (ACCOUNT_DOB == 'false') $sql_data_array['customers_dob'] = tep_date_raw($dob);
if (ACCOUNT_DOB == 'false') $sql_data_array['customers_email_address'] = $email_address;
tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);
$customer_id = tep_db_insert_id();
$sql_data_array = array('customers_id' => $customer_id,
'entry_firstname' => $firstname,
'entry_lastname' => $lastname,
'entry_street_address' => $street_address,
'entry_postcode' => $postcode,
'entry_city' => $city,
'entry_country_id' => $country);
if (ACCOUNT_GENDER == 'true') $sql_data_array['entry_gender'] = $gender;
if (ACCOUNT_COMPANY == 'true') $sql_data_array['entry_company'] = $company;
if (ACCOUNT_SUBURB == 'true') $sql_data_array['entry_suburb'] = $suburb;
if (ACCOUNT_STATE == 'true') {
if ($zone_id > 0) {
$sql_data_array['entry_zone_id'] = $zone_id;
$sql_data_array['entry_state'] = '';
} else {
$sql_data_array['entry_zone_id'] = '0';
$sql_data_array['entry_state'] = $state;
}
}
tep_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);
$address_id = tep_db_insert_id();
tep_db_query("update " . TABLE_CUSTOMERS . " set customers_default_address_id = '" . (int)$address_id . "' where customers_id = '" . (int)$customer_id . "'");
tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . (int)$customer_id . "', '0', now())");
if (SESSION_RECREATE == 'True') {
tep_session_recreate();
}
$customer_first_name = $firstname;
$customer_default_address_id = $address_id;
$customer_country_id = $country;
$customer_zone_id = $zone_id;
tep_session_register('customer_id');
tep_session_register('customer_first_name');
tep_session_register('customer_default_address_id');
tep_session_register('customer_country_id');
tep_session_register('customer_zone_id');
// restore cart contents
$cart->restore_contents();
// build the message content
$name = $firstname . ' ' . $lastname;
if (ACCOUNT_GENDER == 'true') {
if ($gender == 'm') {
$email_text = sprintf(EMAIL_GREET_MR, $lastname);
} else {
$email_text = sprintf(EMAIL_GREET_MS, $lastname);
}
} else {
$email_text = sprintf(EMAIL_GREET_NONE, $firstname);
}
$email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;
// ICW - CREDIT CLASS CODE BLOCK ADDED ******************************************************* BEGIN
if (NEW_SIGNUP_GIFT_VOUCHER_AMOUNT > 0) {
$coupon_code = create_coupon_code();
$insert_query = tep_db_query("insert into " . TABLE_COUPONS . " (coupon_code, coupon_type, coupon_amount, date_created) values ('" . $coupon_code . "', 'G', '" . NEW_SIGNUP_GIFT_VOUCHER_AMOUNT . "', now())");
$insert_id = tep_db_insert_id($insert_query);
$insert_query = tep_db_query("insert into " . TABLE_COUPON_EMAIL_TRACK . " (coupon_id, customer_id_sent, sent_firstname, emailed_to, date_sent) values ('" . $insert_id ."', '0', 'Admin', '" . $email_address . "', now() )");
$email_text .= sprintf(EMAIL_GV_INCENTIVE_HEADER, $currencies->format(NEW_SIGNUP_GIFT_VOUCHER_AMOUNT)) . "\n\n" .
sprintf(EMAIL_GV_REDEEM, $coupon_code) . "\n\n" .
EMAIL_GV_LINK . tep_href_link(FILENAME_GV_REDEEM, 'gv_no=' . $coupon_code,'NONSSL', false) .
"\n\n";
}
if (NEW_SIGNUP_DISCOUNT_COUPON != '') {
$coupon_code = NEW_SIGNUP_DISCOUNT_COUPON;
$coupon_query = tep_db_query("select * from " . TABLE_COUPONS . " where coupon_code = '" . $coupon_code . "'");
$coupon = tep_db_fetch_array($coupon_query);
$coupon_id = $coupon['coupon_id'];
$coupon_desc_query = tep_db_query("select * from " . TABLE_COUPONS_DESCRIPTION . " where coupon_id = '" . $coupon_id . "' and language_id = '" . (int)$languages_id . "'");
$coupon_desc = tep_db_fetch_array($coupon_desc_query);
$insert_query = tep_db_query("insert into " . TABLE_COUPON_EMAIL_TRACK . " (coupon_id, customer_id_sent, sent_firstname, emailed_to, date_sent) values ('" . $coupon_id ."', '0', 'Admin', '" . $email_address . "', now() )");
$email_text .= EMAIL_COUPON_INCENTIVE_HEADER . "\n" .
sprintf("%s", $coupon_desc['coupon_description']) ."\n\n" .
sprintf(EMAIL_COUPON_REDEEM, $coupon['coupon_code']) . "\n\n" .
"\n\n";
}
// ICW - CREDIT CLASS CODE BLOCK ADDED ******************************************************* END
tep_mail($name, $email_address, EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
$email_text2 = EMAIL_TEXT2;
tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, EMAIL_SUBJECT, $email_text2, $name, $email_address);
tep_mail($name, $email_address, EMAIL_SUBJECT, $email_text2, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
tep_redirect(tep_href_link(FILENAME_COFIDISRETURN1, '', 'SSL'));
}
}
$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_CREATEPOACCOUNT, '', 'SSL'));
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Language" content="fr">
<?php
// BOF: WebMakers.com Changed: Header Tag Controller v2.4.5
// Replaced by header_tags.php
if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {
require(DIR_WS_INCLUDES . 'header_tags.php');
} else {
?>
<?php
// BOF: WebMakers.com Changed: Header Tag Controller v1.0
// Replaced by header_tags.php
if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {
require(DIR_WS_INCLUDES . 'header_tags.php');
} else {
?>
<title><?php echo TITLE; ?></title>
<?php
}
// EOF: WebMakers.com Changed: Header Tag Controller v1.0
?>
<?php
}
// EOF: WebMakers.com Changed: Header Tag Controller v2.4.5
?>
<?php
$sql_data_array = array('customers_firstname' => $firstname,
'customers_lastname' => $lastname,
'customers_email_address' => $email_address,
'customers_telephone' => $telephone,
'customers_fax' => $fax);
$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
$orders_query = tep_db_query("select orders_id from " . TABLE_ORDERS . " where orders_id = '" . tep_db_input($oID) . "'");
include(DIR_WS_CLASSES . 'order.php');
$order = new order($oID);
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ADDRESS_BOOK_PROCESS);
$account_query = tep_db_query("select customers_gender, customers_firstname, customers_lastname, customers_dob, customers_email_address, customers_telephone, customers_fax from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'");
$account = tep_db_fetch_array($account_query);
$credit_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id, ci.customers_info_date_account_created, ci.customers_info_number_of_logons, ci.customers_info_date_account_last_modified, ci.customers_info_date_of_last_logon, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on (c.customers_default_address_id = a.address_book_id) left join " . TABLE_CUSTOMERS_INFO . " ci on (c.customers_id = ci.customers_info_id) where a.customers_id = c.customers_id and c.customers_id = '" . (int)$customer_id . "'");
$credit = tep_db_fetch_array($credit_query);
$montant = $order->info['total'];
tep_session_register('orders_total');
$orders_id=$insert_id;
tep_session_register('orders_id');
if ($order->info['total'] <= 1001) {
global $Profession, $credit_ref1city, $credit_ref1phone;
if ($this->enabled == true) {
if ($order->info['total'] <= 1001) {
$this->enabled = false;
}
}
}
?>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<?php require('includes/form_check.js.php'); ?>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
<td width="500">
<img height="73" src="http://www.esinger.fr/templates/Pixame_v1/images/header_title.gif" width="421"></td>
<td width="100%" background="http://www.esinger.fr/templates/Pixame_v1/images/header_background.gif" height="73">
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr class="header">
<td class="ShowCartDetails" vAlign="center" align="right" height="30"> </td>
</tr>
</table>
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
</table>
</td>
<td>
<img height="73" src="http://www.esinger.fr/templates/Pixame_v1/images/header_right.gif" width="80"></td>
</tr>
</table>
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td width="345">
<img height="23" src="http://www.esinger.fr/templates/Pixame_v1/images/slogan.gif" width="345"></td>
<td width="100%" background="http://www.esinger.fr/templates/Pixame_v1/images/slogan_middle.gif"> </td>
<td width="1" bgColor="#798ccc">
<img height="1" src="http://www.esinger.fr/templates/Pixame_v1/images/Pixel.gif" width="1"></td>
</tr>
</table>
<table height="20" cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td width="1" bgColor="#798ccc">
<img height="1" src="http://www.esinger.fr/templates/Pixame_v1/images/Pixel.gif" width="1"></td>
<td width="33%" bgColor="#d2dbf5"> </td>
<td align="right" width="77%" bgColor="#d2dbf5"> </td>
<td width="5" bgColor="#d2dbf5"> </td>
<td width="1" bgColor="#798ccc">
<img height="1" src="http://www.esinger.fr/templates/Pixame_v1/images/Pixel.gif" width="1"></td>
</tr>
</table>
<table cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td width="5">
<img height="25" src="http://www.esinger.fr/templates/Pixame_v1/images/links_left.gif" width="5"></td>
<td background="http://www.esinger.fr/templates/Pixame_v1/images/links_middle.gif">
<div align="center">
<font class="storyboxtitle">
<font size="1">
<img height="8" alt="" src="http://www.esinger.fr/templates/Pixame_v1/images/arrow.gif" width="4" border="0">
</font>
<a class="HeaderPageLinks" href="http://www.esinger.fr/index.php">
<font size="1">ACCUEIL</font></a><font size="1">
<img height="8" alt="" src="http://www.esinger.fr/templates/Pixame_v1/images/arrow.gif" width="4" border="0">
<a class="HeaderPageLinks" href="http://www.esinger.fr/login.php">
S'IDENTIFIER</a> <img height="8" alt="" src="http://www.esinger.fr/templates/Pixame_v1/images/arrow.gif" width="4" border="0">
<a class="HeaderPageLinks" href="http://www.esinger.fr/specials.php">
VENTE FLASH</a>
<img height="8" alt="" src="http://www.esinger.fr/templates/Pixame_v1/images/arrow.gif" width="4" border="0">
<a class="HeaderPageLinks" href="http://www.esinger.fr/products_new.php">
NOUVEAUTES</a>
<img height="8" src="http://www.esinger.fr/templates/Pixame_v1/images/arrow.gif" width="4">
<a href="http://www.esinger.fr/../../login.php">
<span style="TEXT-DECORATION: none">
MEMBRES</span></a>
<img height="8" src="http://www.esinger.fr/templates/Pixame_v1/images/arrow.gif" width="4"><a href="http://www.esinger.fr/../../forums.php"><span style="TEXT-DECORATION: none">
FORUMS </span></a>
<img height="8" src="http://www.esinger.fr/templates/Pixame_v1/images/arrow.gif" width="4">
<a href="http://www.esinger.fr/../../links.php">
<span style="TEXT-DECORATION: none">
LIENS </span></a>
<img height="8" alt="" src="http://www.esinger.fr/templates/Pixame_v1/images/arrow.gif" width="4" border="0">
<a class="HeaderPageLinks" href="http://www.esinger.fr/allprods.php">
CATALOGUE</a>
<img height="8" alt="" src="http://www.esinger.fr/templates/Pixame_v1/images/arrow.gif" width="4" border="0">
</font>
<a href="http://www.esinger.fr/contact_us.php">
<font size="1">CONTACT </font> </a></font></div>
</td>
<td width="5">
<img height="25" src="http://www.esinger.fr/templates/Pixame_v1/images/links_right.gif" width="5"></td>
<!-- header_eof //-->
<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
<tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->
<td width="100%" valign="top"><?php echo tep_draw_form('create_account', tep_href_link(FILENAME_CREATEPOACCOUNT, '', 'SSL'), 'post', 'onSubmit="return check_form(create_account);"') . tep_draw_hidden_field('action', 'process'); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_account.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
</tr>
</table></td>
</tr>
<tr> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_account.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
<tr>
<td class="smallText"><br><?php echo sprintf(TEXT_ORIGIN_LOGIN, tep_href_link(FILENAME_LOGIN, tep_get_all_get_params(), 'SSL')); ?></td>
</tr>
<?php
if ($messageStack->size('create_account') > 0) {
?>
<tr>
<td><?php echo $messageStack->output('create_account'); ?></td>
</tr>
<tr>
<td height="3"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<?php
}
?>
<tr><td <font style="font-size: 10pt; font-style:normal"> <p><b>
Votre identité</b></font></td>
</td>
</tr>
<tr>
</td>
<td>
<table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
<tr class="infoBoxContents">
<td width="449"><table border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="main" height="5" width="62"><?php echo ENTRY_GENDER; ?></td>
<td class="main" height="5"><?php echo tep_draw_radio_field('gender', 'm') . ' ' . MALE . ' ' . tep_draw_radio_field('gender', 'f') . ' ' . FEMALE . ' ' . tep_draw_radio_field('gender', 'Mlle') . ' ' . MLLE . ' '. (tep_not_null(ENTRY_GENDER_TEXT) ? '<span class="inputRequirement">' . ENTRY_GENDER_TEXT . '</span>': ''); ?></td>
</tr>
<tr>
<td class="main" width="62"><?php echo ENTRY_FIRST_NAME; ?></td>
<td class="main"><?php echo tep_draw_input_field('firstname', $account['customers_firstname']). ' ' . (tep_not_null(ENTRY_FIRST_NAME_TEXT) ? '<span class="inputRequirement">' . ENTRY_FIRST_NAME_TEXT . '</span>': ''); ?></td>
</tr>
<tr>
<td class="main" width="62"><?php echo ENTRY_LAST_NAME; ?></td>
<td class="main"><?php echo tep_draw_input_field('lastname', $account['customers_lastname']). ' ' . (tep_not_null(ENTRY_LAST_NAME_TEXT) ? '<span class="inputRequirement">' . ENTRY_LAST_NAME_TEXT . '</span>': ''); ?></td>
</tr>
<tr>
<td class="main" width="62"><?php echo ENTRY_DATE_OF_BIRTH ?></td>
<td class="main"><?php echo tep_draw_input_field('dob', tep_date_short ($account['customers_dob'])). ' ' . (tep_not_null(ENTRY_DATE_OF_BIRTH) ? '<span class="inputRequirement">' . ENTRY_DATE_OF_BIRTH_TEXT . '</span>': ''); ?></td>
</tr>
<tr>
<td class="main" width="62"><?php echo ENTRY_EMAIL_ADDRESS ?></td>
<td class="main"><?php echo tep_draw_input_field('email_address', $account['customers_email_address']). ' ' . (tep_not_null(ENTRY_EMAIL_ADDRESS) ? '<span class="inputRequirement">' . ENTRY_EMAIL_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>
<tr><td <font style="font-size: 8pt; font-style:normal" width="100%"> <p><b>
Votre crédit</b></font></td> </tr>
</tr></td>
</td>
<tr>
<td class="main" width="100%"><?php echo ENTRY_TOTALCOM; ?></td>
<td class="main"><?php echo tep_draw_input_field('totalcom', $montant). ' ' . (tep_not_null(ENTRY_TOTALCOM) ? '<span class="inputRequirement">' . ENTRY_TOTALCOM_TEXT . '</span>': ''); ?></td>
</tr>
</tr>
<span style="font-size: 8pt">
</td></tr>
<?php
//Requête SQL
define('TABLE_MENSUALITES', 'mensualites');
$mens_query = tep_db_query("select valeur_mens, montants from ".TABLE_MENSUALITES." order by valeur_mens");
//pour compter les enregistrements
$i=0;
//pour la liste déroulante des mensualités
$mens_array = array();
//Lecture du résultat
while ($row = tep_db_fetch_array($mens_query)) {
//Remplir la liste des mensualités tout en sélectionnant celle déjà choisie ou par défaut la première
$if_selected = $_POST["mensualite"] == $row["valeur_mens"]?true:false;
$mens_array[] = array('id' => $row["valeur_mens"], 'text' => $row["valeur_mens"], 'selected' => $if_selected);
//Préparer la liste des montants de la mensualité choisie ou par défaut pour la première
if ( ($_POST["mensualite"] && $_POST["mensualite"] == $row["valeur_mens"])
|| (!$_POST["mensualite"] && $i==0) ){
$montants_array = array();
$montants = explode(";" , $row["montants"]); //récup des montants séparés par ;
//construction du tableau source de la liste déroulante
foreach ($montants as $un_montant){
$montants_array[] = array('id' => $un_montant, 'text' => $un_montant);
}
}
//compteur d'enregitrements
$i++;
}//fin while
//afficher la mensulaité en cours
?>
<tr>
<td class="main" width="62"><?php echo ENTRY_MENSUALITE; ?></td>
<td class="main">
<?php
if ($_POST["mensualite"]==$row["valeur_mens"]) $mens_selected = $row["valeur_mens"];
echo tep_draw_pull_down_menu('mensualite', $mens_array, $mens_selected, 'onChange="this.form.submit();"');
if (tep_not_null(ENTRY_MENSUALITE_TEXT)) echo ' <span class="inputRequirement">' . ENTRY_MENSUALITE_TEXT . '</span>';
?>
</td>
<td class="main"><?php echo ENTRY_TOTAL_MENSUALITE; ?></td>
<td class="main">
<?php
//afficher la liste déroulante de ses montants
if ($_POST["total_mensualit"]==$row["valeur_mens"]) $mens_selected = $row["valeur_mens"];
echo tep_draw_pull_down_menu('total_mensualite', $montants_array, $mens_selected,'onChange="this.form.submit();"');
if (tep_not_null(ENTRY_TOTAL_MENSUALITE_TEXT)) echo ' <span class="inputRequirement">' . ENTRY_TOTAL_MENSUALITE_TEXT. '</span>';
?>
</td>
</tr>
<?php
//detection du bouton image submit du formulaire
echo "<pre>"; print_r($_POST); echo "</pre>";
$apport = $totalcom - $total_mensualite;
?>
<tr>
<td class="main" width="100%"><?php echo ENTRY_APPORT; ?></td>
<td class="main"><?php echo tep_draw_input_field('apport', $apport). ' ' . (tep_not_null(ENTRY_APPORT) ? '<span class="inputRequirement">' . ENTRY_APPORT_TEXT . '</span>': ''); ?><font color="#FF0000"><?php if ($apport < 0) echo "ERREUR le montant de votre financement ne doit pas être supérieur au total de votre commande" ?></font> </td>
</tr> </td>
</table></td>
</tr>
<table>
<tr><td <font style="font-size: 8pt; font-style:normal" width="449"> <p>
<b>Pièce d'identité</b></font></td>
<tr>
<th align="left" width="449"><span style="font-weight: 400">
<font style="font-size: 8pt">Nationalité
</font> </span></th>
<td align="left">
<font size="1">
<span style="font-size: 8pt">
<input class="TexteForm" id="nationalite1" type="radio" value="Française" name="nationalite" checked></span></font><font style="font-size: 8pt">Française
</font>
<font size="1">
<span style="font-size: 8pt">
<input class="TexteForm" id="nationalite2" type="radio" value="CEE" name="nationalite"></span><font style="font-size: 8pt">CEE
</font><span style="font-size: 8pt">
<input class="TexteForm" id="nationalite3" type="radio" value="Hors CEE" name="nationalite"></span><font style="font-size: 8pt">Hors
CEE </font> </font><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span> </td>
<td class="check" id="formValidatorTdradio=nationalite">
<div id="erreurradio=nationalite">
</div>
</td>
</tr>
<th align="left" width="449">
<address align="left">
<span style="font-style: normal; font-weight: 400; font-size: 8pt">
N</span><span style="font-size: 8pt; font-weight: 400; font-style:normal">ature
de la pièce</span></address>
<address>
<span style="font-size: 8pt; font-weight: 400; font-style:normal">
(carte d identité de séjour ou
passeport)</span></address>
</th>
<td align="left">
<span style="font-size: 8pt">
<input class="txt" name="naturepiece">
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td></tr>
<tr>
<th align="left" width="449"><span style="font-size: 8pt; font-weight: 400">
N°de votre pièce</span></th>
<td>
<span style="font-size: 8pt">
<input class="txt" name="datecni">
</span>
<font color="#FF0000">
<span style="font-size: 8pt">*</span></font></td>
</tr>
<tr>
<th align="left" width="449">
<span style="font-weight: 400">
<font style="font-size: 8pt">lieu</font></span><font style="font-size: 8pt"></font></font><span style="font-weight: 400"><font style="font-size: 8pt">
de délivrance</font></span><td>
<span style="font-size: 8pt"><input class="txt" name="datedelivrance">
</span>
<font color="#FF0000">
<span style="font-size: 8pt">*</span></font></td>
</tr>
<tr>
<td class="main" align="left" width="449">
<address>
<font style="font-style:normal; font-size:8pt">Date de </font>
</address>
<address>
<font style="font-style:normal; font-size:8pt">délivrance:</font></address>
</td>
<td class="main" align="left"><font size="1">
<span style="font-size: 8pt"><input name="datedélivrance"></span></font><font style="font-size: 8pt"> </font><span class="inputRequirement"><font style="font-size: 8pt"><font color="#FF0000">*</font>
(ex.03/02/1961)</font></span></td>
</tr>
<tr class="nomjf">
<th align="left" width="449">
<address>
<span style="font-weight: 400">
<font style="font-size: 8pt; font-style:normal">
Nom de </font></span>
</address>
<address>
<span style="font-weight: 400; font-style:normal">
<font style="font-size: 8pt">jeune
fille</font><font class="Marier"><font style="font-size: 8pt"> </font></font></span></address>
</th>
<td align="left">
<font size="1">
<span style="font-size: 8pt">
<input class="txt" id="nomJF" name="nomJF"></span></font><font color="#FF0000"><font style="font-size: 8pt">
</font><span class="inputRequirement">
<font style="font-size: 8pt">* </font> </span>
</font>
</td>
</tr>
<tr>
<th align="left" width="449">
<address>
<span style="font-weight: 400">
<font style="font-size: 8pt; font-style:normal">
Pays de</font></span></address>
<address>
<span style="font-weight: 400">
<font style="font-size: 8pt; font-style:normal">
naissance
</font> </span>
</address>
</th>
<td align="left">
<font size="1">
<span style="font-size: 8pt">
<select class="TexteForm" id="paysNaiss" onchange="checkPaysNaissance()" name="paysNaiss">
<option value="France" selected>France
</option>
<option value="Afghanistan">Afghanistan
</option>
<option value="Afrique du Sud">Afrique
du Sud</option>
<option value="Albanie">Albanie</option>
<option value="Algérie">Algérie</option>
<option value="Allemagne">Allemagne
</option>
<option value="Andorre">Andorre</option>
<option value="Angola">Angola</option>
<option value="Argentine">Argentine
</option>
<option value="Arménie">Arménie</option>
<option value="Australie">Australie
</option>
<option value="Autriche">Autriche
</option>
<option value="Belgique">Belgique
</option>
<option value="Birmanie">Birmanie
</option>
<option value="Bolivie">Bolivie</option>
<option value="Brésil">Brésil</option>
<option value="Bulgarie">Bulgarie
</option>
<option value="Cambodge">Cambodge
</option>
<option value="Cameroun">Cameroun
</option>
<option value="Canada">Canada</option>
<option value="Chili">Chili</option>
<option value="Chine">Chine</option>
<option value="Chypre">Chypre</option>
<option value="Colombie">Colombie
</option>
<option value="Congo">Congo</option>
<option value="Corée du Nord">Corée du
Nord</option>
<option value="Corée du Sud">Corée du
Sud</option>
<option value="Costa Rica">Costa Rica
</option>
<option value="Côte d'Ivoire">Côte
d'Ivoire</option>
<option value="Croatie">Croatie</option>
<option value="Cuba">Cuba</option>
<option value="Danemark">Danemark
</option>
<option value="Djibouti">Djibouti
</option>
<option value="Dominique">Dominique
</option>
<option value="Egypte">Egypte</option>
<option value="Emirats Arabes Unis">
Emirats Arabes Unis</option>
<option value="Espagne">Espagne</option>
<option value="Estonie">Estonie</option>
<option value="Ethiopie">Ethiopie
</option>
<option value="Fidji">Fidji</option>
<option value="Finlande">Finlande
</option>
<option value="Gabon">Gabon</option>
<option value="Gambie">Gambie</option>
<option value="Géorgie">Géorgie</option>
<option value="Ghana">Ghana</option>
<option value="Grèce">Grèce</option>
<option value="Guinée">Guinée</option>
<option value="Haïti">Haïti</option>
<option value="Hongrie">Hongrie</option>
<option value="Île Maurice">Île Maurice
</option>
<option value="Inde">Inde</option>
<option value="Indonesie">Indonesie
</option>
<option value="Irak">Irak</option>
<option value="Iran">Iran</option>
<option value="Irlande">Irlande</option>
<option value="Islande">Islande</option>
<option value="Israel">Israel</option>
<option value="Italie">Italie</option>
<option value="Jamaïque">Jamaïque
</option>
<option value="Japon">Japon</option>
<option value="Jordanie">Jordanie
</option>
<option value="Kenya">Kenya</option>
<option value="Kowéit">Kowéit</option>
<option value="Lettonie">Lettonie
</option>
<option value="Liban">Liban</option>
<option value="Libéria">Libéria</option>
<option value="Libye">Libye</option>
<option value="Lithuanie">Lithuanie
</option>
<option value="Luxembourg">Luxembourg
</option>
<option value="Madagascar">Madagascar
</option>
<option value="Malaisie">Malaisie
</option>
<option value="Mali">Mali</option>
<option value="Malte">Malte</option>
<option value="Maroc">Maroc</option>
<option value="Mauritanie">Mauritanie
</option>
<option value="Mexique">Mexique</option>
<option value="Moldavie">Moldavie
</option>
<option value="Monaco">Monaco</option>
<option value="Mongolie">Mongolie
</option>
<option value="Namibie">Namibie</option>
<option value="Népal">Népal</option>
<option value="Niger">Niger</option>
<option value="Norvège">Norvège</option>
<option value="Nouvelle-Zélande">
Nouvelle-Zélande</option>
<option value="Ouganda">Ouganda</option>
<option value="Ouzbekistan">Ouzbekistan
</option>
<option value="Pakistan">Pakistan
</option>
<option value="Panama">Panama</option>
<option value="Papouasie N. Guinée">
Papouasie N. Guinée</option>
<option value="Paraguay">Paraguay
</option>
<option value="Perou">Perou</option>
<option value="Philippines">Philippines
</option>
<option value="Pologne">Pologne</option>
<option value="Portugal">Portugal
</option>
<option value="Rép. Tchèque">Rép.
Tchèque</option>
<option value="Roumanie">Roumanie
</option>
<option value="Royaume Uni">Royaume Uni
</option>
<option value="Russie">Russie</option>
<option value="Rwanda">Rwanda</option>
<option value="Sao-Tomé-et-Principe">
Sao-Tomé-et-Principe</option>
<option value="Senegal">Senegal</option>
<option value="Slovaquie">Slovaquie
</option>
<option value="Slovénie">Slovénie
</option>
<option value="Somalie">Somalie</option>
<option value="Sri Lanka">Sri Lanka
</option>
<option value="Suède">Suède</option>
<option value="Suisse">Suisse</option>
<option value="Syrie">Syrie</option>
<option value="Taiwan">Taiwan</option>
<option value="Tanzanie">Tanzanie
</option>
<option value="Thaïlande">Thaïlande
</option>
<option value="Togo">Togo</option>
<option value="Tunisie">Tunisie</option>
<option value="Turquie">Turquie</option>
<option value="Ukraine">Ukraine</option>
<option value="Uruguay">Uruguay</option>
<option value="USA">USA</option>
<option value="Venezuela">Venezuela
</option>
<option value="Vietnam">Vietnam</option>
<option value="Yougoslavie">Yougoslavie
</option>
<option value="Zaire">Zaire</option>
<option value="Zambie">Zambie</option>
<option value="Autre">Autre</option>
</select></span></font><font style="font-size: 8pt">
</font><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td>
</tr>
<tr class="codePostalNaissZone">
<th align="left" width="449">
<address>
<span style="font-weight: 400">
<font style="font-size: 8pt; font-style:normal">
Code Postal </font></span>
</address>
<address>
<span style="font-weight: 400">
<font style="font-size: 8pt; font-style:normal">
de naissance</font></span></address>
</th>
<td align="left">
<div class="codePostalDiv" id="codePostalNaissDiv">
<font size="1">
<span style="font-size: 8pt">
<input id="lastCodePostalNaiss" type="hidden" name="lastCodePostalNaiss">
<input id="dptNaiss" type="hidden" name="dptNaiss">
</span>
</font><font size="1">
<span style="font-size: 8pt">
<input class="codePostal" id="codePostalNaiss" onkeyup="searchVilles(this, 'villeNaiss', 'lastCodePostalNaiss', 'villeNaissSpan')" maxLength="5" onchange="searchVilles(this, 'villeNaiss', 'lastCodePostalNaiss', 'villeNaissSpan')" size="5" name="codePostalNaiss" autocomplete="off"></span></font><font style="font-size: 8pt">
</font><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</div>
<font style="font-size: 8pt">
</td>
</tr>
<tr>
<th align="left" width="449">
<address>
<span style="font-weight: 400">
<font style="font-size: 8pt; font-style:normal">
Ville de </font></span>
</address>
<address>
<span style="font-weight: 400">
<font style="font-size: 8pt; font-style:normal">
naissance</font></span></address>
</th>
<td align="left">
<font size="1">
<span style="font-size: 8pt">
<input class="txt" id="villenaissance" name="villenaissance"></span></font><span class="inputRequirement"><font style="font-size: 8pt" color="#FF0000">* </font> </span>
</td>
</td>
</tr>
<td class="check" id="formValidatorTdvilleNaiss" width="449">
<div id="erreurvilleNaiss">
</td>
</tr>
</tr>
<tr><td <font style="font-size: 8pt; font-style:normal" width="449"> <p><b>
Votre habitation</b></font></td>
<tr>
<th align="left" width="449">
<span style="font-size: 8pt; font-weight: 400">
Habitat </span></th>
<td align="left">
<span style="font-size: 8pt">
<select class="txt" id="typeHabitat" name="typeHabitat">
<option value selected>Sélectionnez
</option>
<option value="Accession à la propriété">
Propriétaire crédit immobilier en cours
</option>
<option value="Propriétaire">
Propriétaire</option>
<option value="Locataire">Locataire
</option>
<option value="Logé par famille">Logé
par famille</option>
<option value="Logé par employeur-logement de fonction">
Logé par employeur-logement de fonction
</option>
<option value="meublé-hôtel-foyer-caravane-sous location">
meublé-hôtel-foyer-caravane-sous
location</option>
<option value="Situation inconnue">
Situation inconnue</option>
<option value="Autre">Autre</option>
</select></span><span class="inputRequirement"><font style="font-size: 8pt" color="#FF0000">* </font> </span>
<span style="font-size: 8pt">
</span></td>
<td class="check" id="incoh_typeHabitat_1" style="display: none" align="left">
<span style="font-size: 8pt">Incohérence
loyer / type logement
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
*</font></span></td>
<td class="check" id="formValidatorTdtypeHabitat">
<div id="erreurtypeHabitat">
</div>
</td>
</tr>
<tr>
<th align="left" width="449">
<span style="font-size: 8pt; font-weight: 400">
Depuis </span></th>
<td align="left">
<span style="font-size: 8pt">
<select class="txt-3" id="moisHabitat" name="moisHabitat">
<option value selected>Mois</option>
<option value="01">Janvier</option>
<option value="02">Février</option>
<option value="03">Mars</option>
<option value="04">Avril</option>
<option value="05">Mai</option>
<option value="06">Juin</option>
<option value="07">Juillet</option>
<option value="08">Août</option>
<option value="09">Septembre</option>
<option value="10">Octobre</option>
<option value="11">Novembre</option>
<option value="12">Décembre</option>
</select>
<select class="txt-3" id="anneeHabitat" name="anneeHabitat">
<option value selected>Année</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1969">1969</option>
<option value="1968">1968</option>
<option value="1967">1967</option>
<option value="1966">1966</option>
<option value="1965">1965</option>
<option value="1964">1964</option>
<option value="1963">1963</option>
<option value="1962">1962</option>
<option value="1961">1961</option>
<option value="1960">1960</option>
<option value="1959">1959</option>
<option value="1958">1958</option>
<option value="1957">1957</option>
<option value="1956">1956</option>
<option value="1955">1955</option>
<option value="1954">1954</option>
<option value="1953">1953</option>
<option value="1952">1952</option>
<option value="1951">1951</option>
<option value="1950">1950</option>
<option value="1949">1949</option>
<option value="1948">1948</option>
<option value="1947">1947</option>
<option value="1946">1946</option>
<option value="1945">1945</option>
<option value="1944">1944</option>
<option value="1943">1943</option>
<option value="1942">1942</option>
<option value="1941">1941</option>
<option value="1940">1940</option>
<option value="1939">1939</option>
<option value="1938">1938</option>
<option value="1937">1937</option>
<option value="1936">1936</option>
<option value="1935">1935</option>
<option value="1934">1934</option>
<option value="1933">1933</option>
<option value="1932">1932</option>
<option value="1931">1931</option>
<option value="1930">1930</option>
</select>
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td>
<td class="check" id="formValidatorTdmoisHabitat" align="left">
<div id="erreurmoisHabitat">
</div>
<tr><td <font style="font-size: 8pt; font-style:normal" width="449"> <p><b>
Votre situation familiale</b></font></td>
<tr>
<th align="left" width="449">
<span style="font-size: 8pt; font-weight: 400">
Situation de famille </span></th>
<td align="left">
<span style="font-size: 8pt">
<select class="txt" id="situation" onchange="checkCoEmp()" name="situation">
<option value selected></option>
<option value="Célibataire">Célibataire
</option>
<option value="Divorcé(e)-séparé(e)">
Divorcé(e)-séparé(e)</option>
<option value="Veuf / veuve">Veuf /
veuve</option>
<option value="Marié">Marié</option>
<option value="Concubinage - union libre">
Concubinage - union libre</option>
<option value="Pacs">Pacs</option>
</select> </span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span> </td>
<td class="check" id="incoh_situation_1" style="display: none" align="left">
<span style="font-size: 8pt">Incohérence
titre / situation familiale</span><span class="inputRequirement"><font style="font-size: 8pt" color="#FF0000">* </font> </span>
<span style="font-size: 8pt"> </span></td>
<td class="check" id="formValidatorTdsituation">
<div id="erreursituation">
</div>
</td>
</tr>
<tr>
<th align="left" width="449">
<span style="font-size: 8pt; font-weight: 400">
Nombre d'enfants à charge </span></th>
<td align="left">
<span style="font-size: 8pt">
<input class="txt-2" id="nbEnfant" maxLength="2" size="4" name="nbEnfant">
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td>
<td class="check" id="formValidatorTdnbEnfant" align="left">
<div id="erreurnbEnfant">
</div>
</td>
</tr>
</td>
<tr><td <font style="font-size: 8pt; font-style:normal" width="449"> <p><b>
Vos coordonnées</b></font></td>
<tr>
<td class="main" width="449"><?php echo ENTRY_STREET_ADDRESS; ?></td>
<td class="main"><?php echo tep_draw_input_field('street_address', $credit['entry_street_address']) . ' ' . (tep_not_null(ENTRY_STREET_ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_STREET_ADDRESS_TEXT . '</span>': ''); ?></td>
</tr>
<tr>
<td class="main" height="5" width="449"><?php echo ENTRY_CITY; ?></td>
<td class="main" height="5"><?php echo tep_draw_input_field('city', $credit['entry_city']) . ' ' . (tep_not_null(ENTRY_CITY_TEXT) ? '<span class="inputRequirement">' . ENTRY_CITY_TEXT . '</span>': ''); ?></td>
</tr>
<?php
if (ACCOUNT_STATE == 'true') {
?>
<tr>
<td class="main" width="449"><?php echo ENTRY_STATE; ?></td>
<td class="main">
<?php
if ($process == true) {
if ($entry_state_has_zones == true) {
$zones_array = array();
$zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' order by zone_name");
while ($zones_values = tep_db_fetch_array($zones_query)) {
$zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
}
echo tep_draw_pull_down_menu('state', $zones_array);
} else {
echo tep_draw_input_field('state');
}
} else {
echo tep_draw_input_field('state');
}
if (tep_not_null(ENTRY_STATE_TEXT)) echo ' <span class="inputRequirement">' . ENTRY_STATE_TEXT;
?>
</td>
</tr>
<?php
}
?>
<tr>
<td class="main" width="449"><?php echo ENTRY_POST_CODE; ?></td>
<td class="main"><?php echo tep_draw_input_field('postcode', $credit['entry_postcode']) . ' ' . (tep_not_null(ENTRY_POST_CODE_TEXT) ? '<span class="inputRequirement">' . ENTRY_POST_CODE_TEXT . '</span>': ''); ?></td>
</tr>
<tr>
<td class="main" width="449"><?php echo ENTRY_COUNTRY ?></td>
<td class="main"><?php echo tep_draw_input_field('country', $credit['entry_country_id']). ' ' . (tep_not_null(ENTRY_COUNTRY) ? '<span class="inputRequirement">' . ENTRY_COUNTRY_TEXT . '</span>': ''); ?></td>
</tr>
<tr>
<td class="main" width="449"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td>
<td class="main"><?php echo tep_draw_input_field('telephone', $account['customers_telephone']) . ' ' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td>
</tr>
<tr>
<td class="main" width="449"><?php echo ENTRY_FAX_NUMBER; ?></td>
<td class="main"><?php echo tep_draw_input_field('fax', $account['customers_fax']) . ' ' . (tep_not_null(ENTRY_FAX_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_FAX_NUMBER_TEXT . '</span>': ''); ?></td>
</tr>
</table></td>
<tr>
<td width="297"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<font style="font-size: 10pt; font-style:normal"><b>Votre activité</b></font>
</tr>
</table></td>
</tr>
<tr>
<td width="100%"><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
<tr class="infoBoxContents">
<td><table border="0" width="100%"cellspacing="2" cellpadding="2">
<tr>
<th align="left" height="27">
<span style="font-size: 8pt; font-weight: 400">
Profession </span></th><td align="left" height="27">
<span style="font-size: 8pt">
<input id="estCDDObligatoire" type="hidden" value="non" name="estCDDObligatoire">
</span><span style="font-size: 8pt">
<select class="TexteForm" id="profession" onchange="javascript:showCDD(document.forms[sBeanToUse].profession, document.forms[sBeanToUse].typeContrat, document.forms[sBeanToUse].estCDDObligatoire, 'dynamic1'); GereAffichage(sBeanToUse,'profession',['Chômeur','Femme au foyer','Etudiant','Retraité','Autre Inactif'],'coord_transitional');gereControlesProfession();" name="profession">
<option value selected>Profession
</option>
<option value="Agent de sécurité">Agent
de sécurité</option>
<option value="Agent Hopitalier">Agent
Hospitalier</option>
<option value="Agriculteurs">
Agriculteurs</option>
<option value="Artisan">Artisan</option>
<option value="Artiste">Artiste</option>
<option value="Autre Cadre Privé">Autre
Cadre Privé</option>
<option value="Autre Inactif">Autre
Inactif</option>
<option value="Cadre Ingénieur">Cadre
Ingénieur</option>
<option value="Cadre Supérieur du Public">
Cadre Supérieur du Public</option>
<option value="Chauffeur">Chauffeur
</option>
<option value="Chef Entreprise">Chef
Entreprise</option>
<option value="Chercheur">Chercheur
</option>
<option value="Chômeur">Chômeur</option>
<option value="Commerçant Assimilé">
Commerçant Assimilé</option>
<option value="Commercial / Chef de Service">
Commercial / Chef de Service</option>
<option value="Contremaître / Agent Maîtrise">
Contremaître / Agent Maîtrise</option>
<option value="Employé Banque">Employé
Banque</option>
<option value="Employé Bureau">Employé
Bureau</option>
<option value="Employé Commerce">Employé
Commerce</option>
<option value="Employé F.P.">Employé
F.P.</option>
<option value="Employé Hôtel">Employé
Hôtel</option>
<option value="Enseignant">Enseignant
</option>
<option value="Etudiant">Etudiant
</option>
<option value="Femme au foyer">Femme au
foyer</option>
<option value="Forain">Forain</option>
<option value="Infirmier">Infirmier
</option>
<option value="Infirmier salarié">
Infirmier salarié</option>
<option value="Intérimaire">Intérimaire
</option>
<option value="Medecin salarié">Médecin
salarié</option>
<option value="Médico-Social F.P.">
Médico-Social F.P.</option>
<option value="Militaire">Militaire
</option>
<option value="Ouvrier Agricole">Ouvrier
Agricole</option>
<option value="Ouvrier non Qualifié">
Ouvrier non Qualifié</option>
<option value="Ouvrier Qualifié">Ouvrier
Qualifié</option>
<option value="Personnel de service">
Personnel de service</option>
<option value="Personnel F.P.">Personnel
F.P.</option>
<option value="Personnel Médico-Social">
Personnel Médico-Social</option>
<option value="Policier">Policier
</option>
<option value="Profession Information">
Profession Information</option>
<option value="Profession libérale">
Profession libérale</option>
<option value="Retraité">Retraité
</option>
<option value="Technicien">Technicien
</option>
<option value="Vrp Représentant">Vrp
Représentant</option>
</select> <span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td>
</tr>
<tr>
<th align="left">
<font class="dynamic1" style="font-size: 8pt; font-weight: 400">
Type de contrat </font></th><td align="left"><font class="dynamic1">
<span style="font-size: 8pt">
<select id="typeContrat" onchange="checkFinContrat()" name="typeContrat">
<option value selected>Type de contrat
</option>
<option value="CDI">CDI</option>
<option value="CDD" checked="true">CDD
</option>
<option value="Q">
Qualification/Apprentissage</option>
<option value="C">CNE : Ctr Nouvelle
Embauche</option>
<option value="M">En Alternance</option>
<option value="S">Sans Objet</option>
<option value="X">Autres</option>
</select> </span> </font>
<span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td>
</tr>
<tr id="trFinContrat" style="display: none">
<th align="left">
<font class="dynamic1" style="font-size: 8pt; font-weight: 400">
Date de fin de contrat </font></th><td align="left"><font class="dynamic1">
<span style="font-size: 8pt">
<select class="txt-3" id="finContratMois" name="finContratMois">
<option value selected>Mois</option>
<option value="01">Janvier</option>
<option value="02">Février</option>
<option value="03">Mars</option>
<option value="04">Avril</option>
<option value="05">Mai</option>
<option value="06">Juin</option>
<option value="07">Juillet</option>
<option value="08">Août</option>
<option value="09">Septembre</option>
<option value="10">Octobre</option>
<option value="11">Novembre</option>
<option value="12">Décembre</option>
</select>
<select class="txt-3" id="finContratAnnee" name="finContratAnnee">
<option value selected>Année</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option>
</select>
</span></font><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
<tr>
<th align="left"><span style="font-weight: 400">
<span style="font-size: 8pt">Nom de
l'employeur</span><font class="coord_transitional"><span style="font-size: 8pt"> </span></font></span></th><td align="left">
<span style="font-size: 8pt">
<input class="txt" id="nomEmployeur" maxLength="30" size="16" name="nomEmployeur">
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td>
</td>
</tr>
<th>
<p align="left"><span style="font-size: 8pt; font-weight: 400">
Adresse</span></th><td>
<span style="font-size: 8pt">
<input class="txt" name="adresseemployeur">
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td></tr>
</tr>
<th>
<p align="left"><span style="font-size: 8pt; font-weight: 400">
Ville</span></th><td>
<span style="font-size: 8pt">
<input class="txt" name="villemployeur" >
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td></tr>
<?php
if (ACCOUNT_STATE == 'true') {
?>
<tr>
<td class="main"><?php echo ENTRY_STATE; ?></td><td class="main">
<?php
if ($process == true) {
if ($entry_state_has_zones == true) {
$zones_array = array();
$zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country . "' order by zone_name");
while ($zones_values = tep_db_fetch_array($zones_query)) {
$zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
}
echo tep_draw_pull_down_menu('state', $zones_array);
} else {
echo tep_draw_input_field('state');
}
} else {
echo tep_draw_input_field('state');
}
if (tep_not_null(ENTRY_STATE_TEXT)) echo ' <span class="inputRequirement">' . ENTRY_STATE_TEXT;
?>
</td>
</tr>
<?php
}
?>
</td>
</tr>
<th>
<p align="left"><span style="font-size: 8pt; font-weight: 400">
code postal</span></th><td>
<span style="font-size: 8pt">
<input class="txt" name="codepostalemployeur" size="7">
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td></tr>
<th>
<p align="left"><span style="font-size: 8pt; font-weight: 400">
Téléphone</span></th><td>
<span style="font-size: 8pt">
<input class="txt" name="telephoneemployeur" >
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td></tr>
<tr>
<td class="main"><?php echo ENTRY_FAX_NUMBER; ?></td><td class="main"><?php echo tep_draw_input_field('fax') . ' ' . (tep_not_null(ENTRY_FAX_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_FAX_NUMBER_TEXT . '</span>': ''); ?></td></tr><tr>
<th align="left">
<span style="font-weight: 400">
<span style="font-size: 8pt">Ancienneté
dans le poste</span><font class="coord_transitional"><span style="font-size: 8pt"> </span></font></span></th><td align="left">
<span style="font-size: 8pt">
<select class="txt-3" id="moisAncProf" name="moisAncProf">
<option value selected>Mois</option>
<option value="01">Janvier</option>
<option value="02">Février</option>
<option value="03">Mars</option>
<option value="04">Avril</option>
<option value="05">Mai</option>
<option value="06">Juin</option>
<option value="07">Juillet</option>
<option value="08">Août</option>
<option value="09">Septembre</option>
<option value="10">Octobre</option>
<option value="11">Novembre</option>
<option value="12">Décembre</option>
</select>
<select class="txt-3" id="anneeAncProf" name="anneeAncProf">
<option value selected>Année</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1969">1969</option>
<option value="1968">1968</option>
<option value="1967">1967</option>
<option value="1966">1966</option>
<option value="1965">1965</option>
<option value="1964">1964</option>
<option value="1963">1963</option>
<option value="1962">1962</option>
<option value="1961">1961</option>
<option value="1960">1960</option>
<option value="1959">1959</option>
<option value="1958">1958</option>
<option value="1957">1957</option>
<option value="1956">1956</option>
<option value="1955">1955</option>
<option value="1954">1954</option>
<option value="1953">1953</option>
<option value="1952">1952</option>
<option value="1951">1951</option>
<option value="1950">1950</option>
<option value="1949">1949</option>
<option value="1948">1948</option>
<option value="1947">1947</option>
<option value="1946">1946</option>
<option value="1945">1945</option>
<option value="1944">1944</option>
<option value="1943">1943</option>
<option value="1942">1942</option>
<option value="1941">1941</option>
<option value="1940">1940</option>
<option value="1939">1939</option>
<option value="1938">1938</option>
<option value="1937">1937</option>
<option value="1936">1936</option>
<option value="1935">1935</option>
<option value="1934">1934</option>
<option value="1933">1933</option>
<option value="1932">1932</option>
<option value="1931">1931</option>
<option value="1930">1930</option>
</select>
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td>
</tr>
<tr><td <font style="font-size: 10pt; font-style:normal"> <p><b>
Ou non salarié</b></font></td></tr><tr>
<td class="main"><?php echo ENTRY_CREDIT_REQUEST; ?></td><td class="main"><?php echo tep_draw_input_field('creditrequest') . ' ' . (tep_not_null(ENTRY_CREDIT_REQUEST_TEXT) ? '<span class="inputRequirement">' . ENTRY_CREDIT_REQUEST_TEXT . '</span>': ''); ?></td></td><tr>
<td class="main"><?php echo ENTRY_TIME_IN_BUSINESS; ?></td><td class="main"><?php echo tep_draw_input_field('time_in_business') . ' ' . (tep_not_null(ENTRY_TIME_IN_BUSINESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_TIME_IN_BUSINESS_TEXT . '</span>': ''); ?></td></tr><th>
<p align="left"><span style="font-size: 8pt; font-weight: 400">
Nom et nature de l activite</span></th><td>
<span style="font-size: 8pt">
<input class="txt" name="natureactive" >
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td></tr>
<tr>
<td class="main"><?php echo ENTRY_NUMBER_OF_EMPLOYESS; ?></td><td class="main"><?php echo tep_draw_input_field('number_of_employees') . ' ' . (tep_not_null(ENTRY_NUMBER_OF_EMPLOYESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_NUMBER_OF_EMPLOYESS_TEXT . '</span>': ''); ?></td></tr></table></td></tr></table></td></tr><tr>
<td width="297"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td></tr><tr>
<td class="main" width="297"><b><?php echo ENTRY_CREDIT_REF; ?></b></td></tr><tr>
<td width="100%"><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
<tr class="infoBoxContents">
<td><table border="0" width="100%" cellspacing="2" cellpadding="2">
<tr>
<td class="main"
<p align="left"><span style="font-size: 8pt; font-weight:700">
Charges mensuelles</span><span class="inputRequirement"><font style="font-size: 8pt" color="#FF0000">* </font> </span>
<span style="font-size: 8pt; font-weight:700"> </span></td>
<td class="main"
<p align="right"><span style="font-size: 8pt; font-weight:700">
Revenue mensuel nets</span><span class="inputRequirement"><font style="font-size: 8pt" color="#FF0000">* </font> </span>
<span style="font-size: 8pt; font-weight:700"> </span></p>
</td>
</tr>
<tr>
<td class="main"><?php echo ENTRY_CREDIT_REF1CITY; ?></td><td class="main"><?php echo tep_draw_input_field('credit_ref1city') . ' ' . (tep_not_null(ENTRY_CREDIT_REF1CITY_TEXT) ? '<span class="inputRequirement">' . ENTRY_CREDIT_REF1CITY_TEXT . '</span>': ''); ?></td><td class="main"><?php echo ENTRY_CREDIT_REF1STATE; ?></td><td class="main"><?php echo tep_draw_input_field('credit_ref1state') . ' ' . (tep_not_null(ENTRY_CREDIT_REF1STATE_TEXT) ? '<span class="inputRequirement">' . ENTRY_CREDIT_REF1STATE_TEXT . '</span>': ''); ?></td></tr><tr>
<td class="main"><?php echo ENTRY_CREDIT_REF1PHONE; ?></td><td class="main"><?php echo tep_draw_input_field('credit_ref1phone') . ' ' . (tep_not_null(ENTRY_CREDIT_REF1PHONE_TEXT) ? '<span class="inputRequirement">' . ENTRY_CREDIT_REF1PHONE_TEXT . '</span>': ''); ?></td><td class="main"><?php echo ENTRY_CREDIT_REF1FAX; ?></td><td class="main"><?php echo tep_draw_input_field('credit_ref1fax') . ' ' . (tep_not_null(ENTRY_CREDIT_REF1FAX_TEXT) ? '<span class="inputRequirement">' . ENTRY_CREDIT_REF1FAX_TEXT . '</span>': ''); ?></td></tr><tr>
<td></td>
<td></td>
</tr>
<tr>
<td class="main"><?php echo ENTRY_CREDIT_REF2; ?></td><td class="main"><?php echo tep_draw_input_field('credit_ref2') . ' ' . (tep_not_null(ENTRY_CREDIT_REF2_TEXT) ? '<span class="inputRequirement">' . ENTRY_CREDIT_REF2_TEXT . '</span>': ''); ?></td><td class="main"><?php echo ENTRY_CREDIT_REF2ADDRESS; ?></td><td class="main"><?php echo tep_draw_input_field('credit_ref2address') . ' ' . (tep_not_null(ENTRY_CREDIT_REF2ADDRESS_TEXT) ? '<span class="inputRequirement">' . ENTRY_CREDIT_REF2ADDRESS_TEXT . '</span>': ''); ?></td></tr><tr>
<td class="main"><?php echo ENTRY_CREDIT_REF2CITY; ?></td><td class="main"><?php echo tep_draw_input_field('credit_ref2city') . ' ' . (tep_not_null(ENTRY_CREDIT_REF2CITY_TEXT) ? '<span class="inputRequirement">' . ENTRY_CREDIT_REF2CITY_TEXT . '</span>': ''); ?></td><td class="main"><?php echo ENTRY_CREDIT_REF2STATE; ?></td><td class="main"><?php echo tep_draw_input_field('credit_ref2state') . ' ' . (tep_not_null(ENTRY_CREDIT_REF2STATE_TEXT) ? '<span class="inputRequirement">' . ENTRY_CREDIT_REF2STATE_TEXT . '</span>': ''); ?></td></tr><tr>
<td class="main"><?php echo ENTRY_CREDIT_REF2PHONE; ?></td><td class="main"><?php echo tep_draw_input_field('credit_ref2phone') . ' ' . (tep_not_null(ENTRY_CREDIT_REF2PHONE_TEXT) ? '<span class="inputRequirement">' . ENTRY_CREDIT_REF2PHONE_TEXT . '</span>': ''); ?></td><td class="main"><?php echo ENTRY_CREDIT_REF2FAX; ?></td></tr><tr>
<td class="main"><?php echo ENTRY_CREDIT_REF3CITY; ?></td><td class="main"><?php echo tep_draw_input_field('credit_ref3city') . ' ' . (tep_not_null(ENTRY_CREDIT_REF3CITY_TEXT) ? '<span class="inputRequirement">' . ENTRY_CREDIT_REF3CITY_TEXT . '</span>': ''); ?></td><td class="main"><?php echo ENTRY_CREDIT_REF3STATE; ?></td><td class="main"><?php echo tep_draw_input_field('credit_ref3state') . ' ' . (tep_not_null(ENTRY_CREDIT_REF3STATE_TEXT) ? '<span class="inputRequirement">' . ENTRY_CREDIT_REF3STATE_TEXT . '</span>': ''); ?></td></tr></table></td></tr></table></td></tr><tr>
<td width="297"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td></tr><tr><td <font style="font-size: 10pt; font-style:normal" width="297"> <p><b>
Votre banque</b></font></td><tr>
<td width="297"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td></tr><tr>
<td width="100%"><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
<tr class="infoBoxContents">
<td><table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<th>
<span style="font-size: 8pt; font-weight: 400">
Banque </span></th><td>
<span style="font-size: 8pt">
<select class="txt" id="banque" name="banque">
<option value selected></option>
<option value="CCP La Poste">CCP - La
Poste</option>
<option value="Crédit Agricole">Crédit
Agricole</option>
<option value="Crédit Lyonnais">Crédit
Lyonnais</option>
<option value="BNP">BNP</option>
<option value="Société Générale">Société
Générale</option>
<option value="Caisse d épargne">Caisse
d'épargne</option>
<option value="Banque Populaire">Banque
Populaire</option>
<option value="Crédit Mutuel">Crédit
Mutuel</option>
<option value="Crédit du Nord">Crédit du
Nord</option>
<option value="CIC">CIC</option>
<option value="Autres">Autres</option>
</select>
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td>
<td class="check" id="formValidatorTdbanque">
<div id="erreurbanque">
</td>
</tr>
<tr>
<th height="29">
<span style="font-size: 8pt; font-weight: 400">
Date d'ouverture du compte </span></th>
<td height="29">
<span style="font-size: 8pt">
<select class="txt-3" id="moisBanque" name="moisBanque">
<option value selected>Mois</option>
<option value="01">Janvier</option>
<option value="02">Février</option>
<option value="03">Mars</option>
<option value="04">Avril</option>
<option value="05">Mai</option>
<option value="06">Juin</option>
<option value="07">Juillet</option>
<option value="08">Août</option>
<option value="09">Septembre</option>
<option value="10">Octobre</option>
<option value="11">Novembre</option>
<option value="12">Décembre</option>
</select>
<select class="txt-3" id="anneeBanque" name="anneeBanque">
<option value selected>Année</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1969">1969</option>
<option value="1968">1968</option>
<option value="1967">1967</option>
<option value="1966">1966</option>
<option value="1965">1965</option>
<option value="1964">1964</option>
<option value="1963">1963</option>
<option value="1962">1962</option>
<option value="1961">1961</option>
<option value="1960">1960</option>
<option value="1959">1959</option>
<option value="1958">1958</option>
<option value="1957">1957</option>
<option value="1956">1956</option>
<option value="1955">1955</option>
<option value="1954">1954</option>
<option value="1953">1953</option>
<option value="1952">1952</option>
<option value="1951">1951</option>
<option value="1950">1950</option>
<option value="1949">1949</option>
<option value="1948">1948</option>
<option value="1947">1947</option>
<option value="1946">1946</option>
<option value="1945">1945</option>
<option value="1944">1944</option>
<option value="1943">1943</option>
<option value="1942">1942</option>
<option value="1941">1941</option>
<option value="1940">1940</option>
<option value="1939">1939</option>
<option value="1938">1938</option>
<option value="1937">1937</option>
<option value="1936">1936</option>
<option value="1935">1935</option>
<option value="1934">1934</option>
<option value="1933">1933</option>
<option value="1932">1932</option>
<option value="1931">1931</option>
<option value="1930">1930</option>
</select>
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td>
<td class="check" id="formValidatorTdmoisBanque" height="29">
<div id="erreurmoisBanque">
</div></th>
</td>
</tr>
<th><span style="font-size: 8pt; font-weight: 400">
N°établissement</span></th><td>
<span style="font-size: 8pt">
<input class="txt" name="numeroetablissement">
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td></tr>
<th>
<span style="font-size: 8pt; font-weight: 400">
N° guichet</span><td>
<span style="font-size: 8pt"><input class="txt" name="numeroguichet">
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td>
</td></tr>
<th>
<span style="font-size: 8pt; font-weight: 400">
N° de compte</span><td>
<span style="font-size: 8pt"><input class="txt" name="numerocompte">
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td>
</td></tr>
<th>
<span style="font-size: 8pt; font-weight: 400">
clé
</span> <td>
<span style="font-size: 8pt"><input class="txt" name="numerocle">
</span><span class="inputRequirement">
<font style="font-size: 8pt" color="#FF0000">
* </font> </span>
</td>
</th>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td width="100%"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td></tr><tr>
<td class="main" width="297"><b><?php echo CATEGORY_POACCOUNT_PASSWORD; ?></b></td></tr><tr>
<td width="100%"><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
<tr class="infoBoxContents">
<td><table border="0" cellspacing="2" cellpadding="2">
<tr>
<td class="main"><?php echo ENTRY_PASSWORD; ?></td><td class="main"><?php echo tep_draw_password_field('password') . ' ' . (tep_not_null(ENTRY_PASSWORD_TEXT) ? '<span class="inputRequirement">' . ENTRY_PASSWORD_TEXT . '</span>': ''); ?></td></tr><tr>
<td class="main"><?php echo ENTRY_PASSWORD_CONFIRMATION; ?></td><td class="main"><?php echo tep_draw_password_field('confirmation') . ' ' . (tep_not_null(ENTRY_PASSWORD_CONFIRMATION_TEXT) ? '<span class="inputRequirement">' . ENTRY_PASSWORD_CONFIRMATION_TEXT . '</span>': ''); ?></td></tr></table></td></tr></table></td></tr><tr>
<td class="main" width="100%"><?php echo ENTRY_CREDIT_TERMS_TEXT ?></td></tr><tr>
<td width="100%"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td></tr><tr>
<td width="100%"><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
<tr class="infoBoxContents">
<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td><td>
<?php if ( isset($_POST["x"]) ) echo tep_image_submit('button_submit.gif', IMAGE_BUTTON_SUBMIT); ?></td><td width="10">
<?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td></tr></table></td></tr></table></td></tr></table></form></td><!-- body_text_eof //--><td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php include(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
</table></td>
</tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<?php include(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
<?php
/*
$Id: create_account_success.php,v 1.2 2003/09/24 15:34:26 wilt Exp $
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
Released under the GNU General Public License
*/
require('includes/application_top.php');
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CREATE_ACCOUNT_SUCCESS);
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_PROCESS);
$breadcrumb->add(NAVBAR_TITLE_1);
$breadcrumb->add(NAVBAR_TITLE_2);
if (ACCOUNT_EMAIL_CONFIRMATION == 'true') {
tep_session_unregister('customer_id');
tep_session_unregister('customer_default_address_id');
tep_session_unregister('customer_first_name');
tep_session_unregister('customer_country_id');
tep_session_unregister('customer_zone_id');
tep_session_unregister('comments');
$cart->reset();
}
if (sizeof($navigation->snapshot) > 0) {
$origin_href = tep_href_link($navigation->snapshot['page'], tep_array_to_string($navigation->snapshot['get'], array(tep_session_name())), $navigation->snapshot['mode']);
$navigation->clear_snapshot();
} else {
$origin_href = tep_href_link(FILENAME_DEFAULT);
}
class cofidis_ZhenIT {
var $code, $title, $description, $enabled,$debug;
// class constructor
function cofidis_ZhenIT() {
global $order, $request_type;
$this->code = 'cofidis_ZhenIT';
$this->title = MODULE_PAYMENT_COFIDIS_TEXT_TITLE;
$this->description = MODULE_PAYMENT_COFIDIS_TEXT_DESCRIPTION;
$this->enabled = ((MODULE_PAYMENT_COFIDIS_STATUS == 'Sí') ? true : false);
$this->sort_order = MODULE_PAYMENT_COFIDIS_SORT_ORDER;
$this->debug = false;
if ((int)MODULE_PAYMENT_COFIDIS_ORDER_STATUS_ID > 0) {
$this->order_status = MODULE_PAYMENT_COFIDIS_ORDER_STATUS_ID;
}
$this->form_action_url = MODULE_PAYMENT_COFIDIS_FORM_URL;
if (is_object($order)) $this->update_status();
}
function trace($log){
if(!$this->debug)
return;
$fp = fopen (DIR_FS_CATALOG . '/includes/modules/payment/cofidis.log', "a+");
fwrite($fp,date("Y-m-d H:i:s")." - ".$log."\n");
fclose($fp);
}
// class methods
function update_status() {
global $order;
if ( ($this->enabled == true) && ((int)MODULE_PAYMENT_COFIDIS_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_COFIDIS_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;
}
}
if ($order->info['total'] < MODULE_PAYMENT_COFIDIS_IMPORTE_MIN) {
$this->enabled = false;
}
}
function javascript_validation() {
return false;
}
function selection() {
return array('id' => $this->code,
'module' => $this->title);
}
function pre_confirmation_check() {
return false;
}
function confirmation() {
return false;
}
function process_button()
{
global $order, $customer_id,$currency,$language, $currencies;
$sql = "select * from " . TABLE_CUSTOMERS . " c where c.customers_id = '" . (int)$customer_id . "'";
$query = tep_db_query($sql);
$customer = tep_db_fetch_array($query);
//Total setup without .
$importe=$order->info['total'];
$importe=round($importe*$order->info['currency_value'],2);
$importe=number_format($importe, 2, '.', '');
//$importe=preg_replace('/\./', ',', $importe);
$data=array("importe"=>$importe,
"customers_id" => (int)$customer_id
);
tep_db_perform("cofidis_ZhenIT", $data);
$referencia = tep_db_insert_id();
$apellidos = split(" ",$order->customer['lastname']);
$hayNif = tep_db_num_rows(tep_db_query('describe address_book entry_nif'));
$nif_contrib = '';
if ($hayNif >0){
if(!isset($order->customer['nif'])){
$nif_query = tep_db_query("select ab.entry_nif from " . TABLE_CUSTOMERS . " c, " . TABLE_ADDRESS_BOOK . " ab where c.customers_id = '" . (int)$customer_id . "' and ab.customers_id = '" . (int)$customer_id . "' and c.customers_default_address_id = ab.address_book_id");
$nif = tep_db_fetch_array($nif_query);
$order->customer['nif'] = $nif['entry_nif'];
}
$nif_contrib = tep_draw_hidden_field('nif', $order->customer['nif']) . tep_draw_hidden_field(' tipo_documento', 'nif');
}
list($year,$month, $day) = sscanf($customer['customers_dob'], "%04d-%02d-%02d");
$day = sprintf("%02d", $day);
$month = sprintf("%02d", $month);
$process_button_string='';
$process_button_string =
/*Obligatorios*/
tep_draw_hidden_field('partner', MODULE_PAYMENT_COFIDIS_PARTNER) .
tep_draw_hidden_field('producto', MODULE_PAYMENT_COFIDIS_PRODUCTO) .
tep_draw_hidden_field('referencia', $referencia ).
tep_draw_hidden_field('importe',$importe ) .
tep_draw_hidden_field('nombre', $order->customer['firstname']) .
tep_draw_hidden_field('apellidos', $order->customer['lastname']) .
tep_draw_hidden_field('apellido1', $apellidos[0]) .
tep_draw_hidden_field('apellido2', $apellidos[1]) .
tep_draw_hidden_field('url_acept', tep_href_link(FILENAME_CHECKOUT_PROCESS, 'referencia='.$referencia, 'SSL', true, true),false) .
tep_draw_hidden_field('url_rechaz', tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL', true, true),false) .
tep_draw_hidden_field('url_confirm', tep_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL', true, true),false) .
tep_draw_hidden_field('url_error', tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL', true, true),false) .
/*opcionales*/
tep_draw_hidden_field('sexo', $customer['customers_gender']=="m"?"V":"M") .
tep_draw_hidden_field('email', $order->customer['email_address']) .
tep_draw_hidden_field('telefono', $order->customer['telephone']) .
$nif_contrib.
tep_draw_hidden_field('via', $order->customer['street_address']) .
tep_draw_hidden_field('cod_postal', $order->customer['entry_postcode']) .
tep_draw_hidden_field('poblacion', $order->customer['entry_city']) .
tep_draw_hidden_field('diaNac', "".$day) .
tep_draw_hidden_field('mesNac', "".$month) .
tep_draw_hidden_field('anyNac', "".$year) ;
return $process_button_string;
}
function before_process()
{
$referencia = $_REQUEST['referencia'];
$sql = "select resultado from cofidis_ZhenIT where referencia='".(int)$referencia."'";
$query = tep_db_query($sql);
$payment = tep_db_fetch_array($query);
if($payment['resultado']=='1')
{
//The order has been succesfully paid
return false;
}
//Payment unsuccesful
tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode("Hubo un error procesando el pago, por favor, intente de nuevo o contacte con el comercio"), 'SSL', true, false));
//The order has been succesfully paid
return false;
}
function after_process() {
return false;
}
function output_error() {
return false;
}
function check() {
if (!isset($this->_check)) {
$check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PAYMENT_COFIDIS_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 ('¿Habilitar módulo COFIDIS?', 'MODULE_PAYMENT_COFIDIS_STATUS', 'Sí', '¿Desea aceptar pagos finaciados través de COFIDIS?', '6', '0', 'tep_cfg_select_option(array(\'Sí\', \'No\'), ', now())");
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Partner', 'MODULE_PAYMENT_COFIDIS_PARTNER', 'XXX', 'Este es el código de Partner facilitado por la Cofidis', '6', '4', now())");
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Producto','MODULE_PAYMENT_COFIDIS_PRODUCTO', '45', 'Código del producto Cofidis contratado (propocionado por Cofidis)', '6', '6', now())");
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('importe mínimo','MODULE_PAYMENT_COFIDIS_IMPORTE_MIN', '300.00', 'importe mínimo al que deberá llegar el pedido para ofrecer la opción de ser financiado a través de Cofidis', '6', '7', now())");
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Url Cofidis','MODULE_PAYMENT_COFIDIS_FORM_URL', 'https://www.cofidisonline.cofidis.es/FinanciacionEstandar/bienvenido.do', 'Url a la que se enviará la información para la solicitud de financiación, no deberería cambiarse', '6', '8', now())");
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Orden de visualización', 'MODULE_PAYMENT_COFIDIS_SORT_ORDER', '0', 'Orden de visualización, el más bajo se visualiza primero.', '6', '11', 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 ('Zona de pagos', 'MODULE_PAYMENT_COFIDIS_ZONE', '0', 'Si se selecciona una zona, este módulo solo estará disponible para esa zona.', '6', '12', '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 ('Estado de los pedidos', 'MODULE_PAYMENT_COFIDIS_ORDER_STATUS_ID', '0', 'Los pedidos pagados por este método, se pondrán a este estado.', '6', '13', 'tep_cfg_pull_down_order_statuses(', 'tep_get_order_status_name', now())");
$sql="CREATE TABLE cofidis_ZhenIT (".
"referencia INT NOT NULL AUTO_INCREMENT ,".
"orders_id INT DEFAULT '0' ,".
"customers_id INT DEFAULT '0' ,".
"resultado INT DEFAULT '666',".
"numcuotas VARCHAR( 64 ) ,".
"importe INT DEFAULT '0' NOT NULL,".
"PRIMARY KEY ( referencia ));";
$result=tep_db_query($sql);
}
function remove() {
tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
$sql="DROP TABLE IF EXISTS cofidis_ZhenIT";
$result=tep_db_query($sql);
}
function keys() {
return array('MODULE_PAYMENT_COFIDIS_STATUS','MODULE_PAYMENT_COFIDIS_INTERES','MODULE_PAYMENT_COFIDIS_PLAZOMAX','MODULE_PAYMENT_COFIDIS_PARTNER','MODULE_PAYMENT_COFIDIS_PRODUCTO','MODULE_PAYMENT_COFIDIS_IMPORTE_MIN', 'MODULE_PAYMENT_COFIDIS_FORM_URL','MODULE_PAYMENT_COFIDIS_SORT_ORDER', 'MODULE_PAYMENT_COFIDIS_ZONE', 'MODULE_PAYMENT_COFIDIS_ORDER_STATUS_ID');
}
function answer($referencia,
$accept,
$numcuotas){
$this->trace("Desde: ".$_SERVER['REMOTE_ADDR']." pide:".$_SERVER['REQUEST_URI']);
$sql = "select resultado from cofidis_ZhenIT where referencia='".(int)$referencia."'";
$query = tep_db_query($sql);
$payment = tep_db_fetch_array($query);
if($payment['resultado']=='2'){//Estaba pendiente Asnef
if($accept=1)
//Habría que enviar un mail, pero no hay manera de relacionarlo con un pedido
$this->trace("Confirmado un pendiente Asnef");
}
$data=array(
"resultado"=>$accept,
"numcuotas"=>$numcuotas
);
tep_db_perform("cofidis_ZhenIT", $data,'update',"referencia='".(int)$referencia."'");
}
}
$content = CONTENT_CHECKOUT_PROCESS;
require(DIR_WS_TEMPLATES . TEMPLATE_NAME . '/' . TEMPLATENAME_MAIN_PAGE);
require(DIR_WS_INCLUDES . 'application_bottom.php');
?>
<?php if ( isset($_POST["x"]) ) echo tep_image_submit('button_submit.gif', IMAGE_BUTTON_SUBMIT); ?>
CREATE TABLE `cofidis_ZhenIT` (
`referencia` int(11) NOT NULL auto_increment,
`orders_id` int(11) default '0',
`customers_id` int(11) default '0',
`resultado` int(11) default '666',
`numcuotas` varchar(64) default NULL,
`importe` int(11) NOT NULL default '0',
PRIMARY KEY (`referencia`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Contenu de la table `cofidis_ZhenIT`
--
<?php
/*
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
COFIDIS Module Copyright (c) 2006 ZhenIT
[email protected]
Released under the GNU General Public License
*/
class cofidis_ZhenIT {
var $code, $title, $description, $enabled,$debug;
// class constructor
function cofidis_ZhenIT() {
global $order, $request_type;
$this->code = 'cofidis_ZhenIT';
$this->title = MODULE_PAYMENT_COFIDIS_TEXT_TITLE;
$this->description = MODULE_PAYMENT_COFIDIS_TEXT_DESCRIPTION;
$this->enabled = ((MODULE_PAYMENT_COFIDIS_STATUS == 'Sí') ? true : false);
$this->sort_order = MODULE_PAYMENT_COFIDIS_SORT_ORDER;
$this->debug = false;
if ((int)MODULE_PAYMENT_COFIDIS_ORDER_STATUS_ID > 0) {
$this->order_status = MODULE_PAYMENT_COFIDIS_ORDER_STATUS_ID;
}
$this->form_action_url = MODULE_PAYMENT_COFIDIS_FORM_URL;
if (is_object($order)) $this->update_status();
}
function trace($log){
if(!$this->debug)
return;
$fp = fopen (DIR_FS_CATALOG . '/includes/modules/payment/cofidis.log', "a+");
fwrite($fp,date("Y-m-d H:i:s")." - ".$log."\n");
fclose($fp);
}
// class methods
function update_status() {
global $order;
if ( ($this->enabled == true) && ((int)MODULE_PAYMENT_COFIDIS_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_COFIDIS_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;
}
}
if ($order->info['total'] < MODULE_PAYMENT_COFIDIS_IMPORTE_MIN) {
$this->enabled = false;
}
}
function javascript_validation() {
return false;
}
function selection() {
return array('id' => $this->code,
'module' => $this->title);
}
function pre_confirmation_check() {
return false;
}
function confirmation() {
return false;
}
function process_button()
{
global $order, $customer_id,$currency,$language, $currencies;
$sql = "select * from " . TABLE_CUSTOMERS . " c where c.customers_id = '" . (int)$customer_id . "'";
$query = tep_db_query($sql);
$customer = tep_db_fetch_array($query);
//Total setup without .
$importe=$order->info['total'];
$importe=round($importe*$order->info['currency_value'],2);
$importe=number_format($importe, 2, '.', '');
//$importe=preg_replace('/\./', ',', $importe);
$data=array("importe"=>$importe,
"customers_id" => (int)$customer_id
);
tep_db_perform("cofidis_ZhenIT", $data);
$referencia = tep_db_insert_id();
$apellidos = split(" ",$order->customer['lastname']);
$hayNif = tep_db_num_rows(tep_db_query('describe address_book entry_nif'));
$nif_contrib = '';
if ($hayNif >0){
if(!isset($order->customer['nif'])){
$nif_query = tep_db_query("select ab.entry_nif from " . TABLE_CUSTOMERS . " c, " . TABLE_ADDRESS_BOOK . " ab where c.customers_id = '" . (int)$customer_id . "' and ab.customers_id = '" . (int)$customer_id . "' and c.customers_default_address_id = ab.address_book_id");
$nif = tep_db_fetch_array($nif_query);
$order->customer['nif'] = $nif['entry_nif'];
}
$nif_contrib = tep_draw_hidden_field('nif', $order->customer['nif']) . tep_draw_hidden_field(' tipo_documento', 'nif');
}
list($year,$month, $day) = sscanf($customer['customers_dob'], "%04d-%02d-%02d");
$day = sprintf("%02d", $day);
$month = sprintf("%02d", $month);
$process_button_string='';
$process_button_string =
/*Obligatorios*/
tep_draw_hidden_field('partner', MODULE_PAYMENT_COFIDIS_PARTNER) .
tep_draw_hidden_field('producto', MODULE_PAYMENT_COFIDIS_PRODUCTO) .
tep_draw_hidden_field('referencia', $referencia ).
tep_draw_hidden_field('importe',$importe ) .
tep_draw_hidden_field('nombre', $order->customer['firstname']) .
tep_draw_hidden_field('apellidos', $order->customer['lastname']) .
tep_draw_hidden_field('apellido1', $apellidos[0]) .
tep_draw_hidden_field('apellido2', $apellidos[1]) .
tep_draw_hidden_field('url_acept', tep_href_link(FILENAME_CHECKOUT_PROCESS, 'referencia='.$referencia, 'SSL', true, true),false) .
tep_draw_hidden_field('url_rechaz', tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL', true, true),false) .
tep_draw_hidden_field('url_confirm', tep_href_link('cofidis_ZhenIT_return.php', '', 'SSL', true, true),false) .
tep_draw_hidden_field('url_error', tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL', true, true),false) .
/*opcionales*/
tep_draw_hidden_field('sexo', $customer['customers_gender']=="m"?"V":"M") .
tep_draw_hidden_field('email', $order->customer['email_address']) .
tep_draw_hidden_field('telefono', $order->customer['telephone']) .
$nif_contrib.
tep_draw_hidden_field('via', $order->customer['street_address']) .
tep_draw_hidden_field('cod_postal', $order->customer['entry_postcode']) .
tep_draw_hidden_field('poblacion', $order->customer['entry_city']) .
tep_draw_hidden_field('diaNac', "".$day) .
tep_draw_hidden_field('mesNac', "".$month) .
tep_draw_hidden_field('anyNac', "".$year) ;
return $process_button_string;
}
function before_process()
{
$referencia = $_REQUEST['referencia'];
$sql = "select resultado from cofidis_ZhenIT where referencia='".(int)$referencia."'";
$query = tep_db_query($sql);
$payment = tep_db_fetch_array($query);
if($payment['resultado']=='1')
{
//The order has been succesfully paid
return false;
}
//Payment unsuccesful
tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode("Hubo un error procesando el pago, por favor, intente de nuevo o contacte con el comercio"), 'SSL', true, false));
//The order has been succesfully paid
return false;
}
function after_process() {
return false;
}
function output_error() {
return false;
}
function check() {
if (!isset($this->_check)) {
$check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PAYMENT_COFIDIS_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 ('¿Habilitar módulo COFIDIS?', 'MODULE_PAYMENT_COFIDIS_STATUS', 'Sí', '¿Desea aceptar pagos finaciados través de COFIDIS?', '6', '0', 'tep_cfg_select_option(array(\'Sí\', \'No\'), ', now())");
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Partner', 'MODULE_PAYMENT_COFIDIS_PARTNER', 'XXX', 'Este es el código de Partner facilitado por la Cofidis', '6', '4', now())");
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Producto','MODULE_PAYMENT_COFIDIS_PRODUCTO', '45', 'Código del producto Cofidis contratado (propocionado por Cofidis)', '6', '6', now())");
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('importe mínimo','MODULE_PAYMENT_COFIDIS_IMPORTE_MIN', '300.00', 'importe mínimo al que deberá llegar el pedido para ofrecer la opción de ser financiado a través de Cofidis', '6', '7', now())");
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Url Cofidis','MODULE_PAYMENT_COFIDIS_FORM_URL', 'https://www.cofidisonline.cofidis.es/FinanciacionEstandar/bienvenido.do', 'Url a la que se enviará la información para la solicitud de financiación, no deberería cambiarse', '6', '8', now())");
tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Orden de visualización', 'MODULE_PAYMENT_COFIDIS_SORT_ORDER', '0', 'Orden de visualización, el más bajo se visualiza primero.', '6', '11', 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 ('Zona de pagos', 'MODULE_PAYMENT_COFIDIS_ZONE', '0', 'Si se selecciona una zona, este módulo solo estará disponible para esa zona.', '6', '12', '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 ('Estado de los pedidos', 'MODULE_PAYMENT_COFIDIS_ORDER_STATUS_ID', '0', 'Los pedidos pagados por este método, se pondrán a este estado.', '6', '13', 'tep_cfg_pull_down_order_statuses(', 'tep_get_order_status_name', now())");
$sql="CREATE TABLE cofidis_ZhenIT (".
"referencia INT NOT NULL AUTO_INCREMENT ,".
"orders_id INT DEFAULT '0' ,".
"customers_id INT DEFAULT '0' ,".
"resultado INT DEFAULT '666',".
"numcuotas VARCHAR( 64 ) ,".
"importe INT DEFAULT '0' NOT NULL,".
"PRIMARY KEY ( referencia ));";
$result=tep_db_query($sql);
}
function remove() {
tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
$sql="DROP TABLE IF EXISTS cofidis_ZhenIT";
$result=tep_db_query($sql);
}
function keys() {
return array('MODULE_PAYMENT_COFIDIS_STATUS','MODULE_PAYMENT_COFIDIS_INTERES','MODULE_PAYMENT_COFIDIS_PLAZOMAX','MODULE_PAYMENT_COFIDIS_PARTNER','MODULE_PAYMENT_COFIDIS_PRODUCTO','MODULE_PAYMENT_COFIDIS_IMPORTE_MIN', 'MODULE_PAYMENT_COFIDIS_FORM_URL','MODULE_PAYMENT_COFIDIS_SORT_ORDER', 'MODULE_PAYMENT_COFIDIS_ZONE', 'MODULE_PAYMENT_COFIDIS_ORDER_STATUS_ID');
}
function answer($referencia,
$accept,
$numcuotas){
$this->trace("Desde: ".$_SERVER['REMOTE_ADDR']." pide:".$_SERVER['REQUEST_URI']);
$sql = "select resultado from cofidis_ZhenIT where referencia='".(int)$referencia."'";
$query = tep_db_query($sql);
$payment = tep_db_fetch_array($query);
if($payment['resultado']=='2'){//Estaba pendiente Asnef
if($accept=1)
//Habría que enviar un mail, pero no hay manera de relacionarlo con un pedido
$this->trace("Confirmado un pendiente Asnef");
}
$data=array(
"resultado"=>$accept,
"numcuotas"=>$numcuotas
);
tep_db_perform("cofidis_ZhenIT", $data,'update',"referencia='".(int)$referencia."'");
}
}
?>
<?
$referencia =='1';
require('includes/application_top.php');
require(DIR_WS_MODULES . 'payment/cofidis_ZhenIT1.php');
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CHECKOUT_PROCESS);
$cofidis=new cofidis_ZhenIT1();
$cofidis->trace("Desde: ".$_SERVER['REMOTE_ADDR']." pide:".$_SERVER['REQUEST_URI']);
if($_REQUEST['referencia']=='')
//tep_redirect(tep_href_link(FILENAME_CHECKOUT_PROCESS, 'error_message=' . urlencode("Hubo un error procesando el pago, por favor, intente de nuevo o contacte con el comercio"), 'SSL', true, false));
tep_redirect(tep_href_link(FILENAME_CHECKOUT_PROCESS, 'SSL', true, true));
$cofidis->answer($_REQUEST['referencia'],
$_REQUEST['accept'],
$_REQUEST['numcuotas']
);
//tep_redirect(tep_href_link(FILENAME_CHECKOUT_PROCESS, 'SSL', true, false));
?>
est la j'ai une erreur 404