[php]<?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>
[/php]
