Index: www-lp/www/admin/orders.php
===================================================================
diff -u -r4 -r29
--- www-lp/www/admin/orders.php	(.../orders.php)	(revision 4)
+++ www-lp/www/admin/orders.php	(.../orders.php)	(revision 29)
@@ -719,6 +719,7 @@
 // <- OSC-99 - Gestion des agents commerciaux
 // <- ORED5066+MANORM155
 // -> VDUPS: génération du fichier XML/UPS
+      $contents[] = array('align' => 'center', 'text' => '<a style="border-radius:3px;" href="' . tep_href_link('edit_form_chronopost.php', tep_get_all_get_params(array('oID', 'action')) . 'oID=' . $_GET['oID'] . '&action=edit') . '">' . tep_image_button('button_chronopost.gif', IMAGE_CHRONOPOST) . '</a>'); 
       $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_EXPORT_UPS, "page=" . $HTTP_GET_VARS['page'] . '&oID=' . $oInfo->orders_id) . '">' . accrosys_tep_image('logo_ups', IMAGE_ORDERS_UPS) . '</a>');
 // <- VDUPS: génération du fichier XML/UPS
 // -> 0000003: affichage bouton exapaq
Index: www-lp/www/admin/includes/languages/english.php
===================================================================
diff -u -r4 -r29
--- www-lp/www/admin/includes/languages/english.php	(.../english.php)	(revision 4)
+++ www-lp/www/admin/includes/languages/english.php	(.../english.php)	(revision 29)
@@ -159,6 +159,7 @@
 define('JS_STATE_SELECT', '-- Select Above --');
 define('JS_ZONE', '* The \'State\' entry must be selected from the list for this country.');
 define('JS_COUNTRY', '* The \'Country\' value must be chosen.\n');
+define('JS_TELEPHONE_COUNTRY', 'The \'Country Code\' field must be filled in \n');
 define('JS_TELEPHONE', '* The \'Telephone Number\' entry must have at least ' . ENTRY_TELEPHONE_MIN_LENGTH . ' characters.\n');
 define('JS_PASSWORD', '* The \'Password\' amd \'Confirmation\' entries must match amd have at least ' . ENTRY_PASSWORD_MIN_LENGTH . ' characters.\n');
 
@@ -206,6 +207,8 @@
 define('ENTRY_STATE_ERROR', '&nbsp;<span class="errorText">required</span>');
 define('ENTRY_COUNTRY', 'Country:');
 define('ENTRY_COUNTRY_ERROR', '');
+define('ENTRY_COUNTRY_CODE', 'Country Code&nbsp;:');
+define('ENTRY_COUNTRY_CODE_ERROR', 'Please enter your country code');
 define('ENTRY_TELEPHONE_NUMBER', 'Telephone Number:');
 define('ENTRY_TELEPHONE_NUMBER_ERROR', '&nbsp;<span class="errorText">min ' . ENTRY_TELEPHONE_MIN_LENGTH . ' chars</span>');
 define('ENTRY_FAX_NUMBER', 'Fax Number:');
@@ -237,6 +240,7 @@
 define('IMAGE_ICON_STATUS_PURPLE_LIGHT', 'Available');
 define('TEXT_PRODUCTS_OUT_OF_STOCK', 'Out Of Stock');
 // <- VDOFS 
+define('IMAGE_CHRONOPOST', 'Chronopost');
 define('IMAGE_ICON_INFO', 'Info');
 define('IMAGE_INSERT', 'Insert');
 define('IMAGE_LOCK', 'Lock');
Index: www-lp/www/admin/includes/languages/french/edit_form_chronopost.php
===================================================================
diff -u
--- www-lp/www/admin/includes/languages/french/edit_form_chronopost.php	(revision 0)
+++ www-lp/www/admin/includes/languages/french/edit_form_chronopost.php	(revision 29)
@@ -0,0 +1,52 @@
+<?php
+/*
+  $Id: edit_form_chronopost.php v5.0 08/12/2007 djmonkey1 Exp $
+
+  osCommerce, Open Source E-Commerce Solutions
+  http://www.oscommerce.com
+
+  Copyright (c) 2007 osCommerce
+
+  Released under the GNU General Public License
+*/
+
+define('ENTRY_CUSTOMER', 'Client');
+define('ENTRY_SHIPPING_ADDRESS', 'Adresse de livraison :');
+define('ENTRY_BILLING_ADDRESS', 'Adresse de facturation :');
+
+//Add info fields 
+define('RECIPIENT_REFERENCE','N° identifiant destinataire');
+define('RECIPIENT_COMPANY', 'Ou Nom et Prénom');
+define('RECIPIENT_COUNTRY_CODE', 'Code pays ISO, si vide FR par défaut');
+define('RECIPIENT_PHONE', 'Téléphone portable de préférence');
+define('PRODUCT_INFO', 'Obligatoire si pas de produit par défaut');
+define('REFERENCE', 'N° BL, N° commande, N° facture, etc ...');
+define('ACCOUNT_NUMBER', 'Obligatoire si plusieurs comptes');
+define('SUB_ACCOUNT_NUMBER','Par exemple mettre 1 et non 001');
+define('INSURANCE', 'En euros');
+define('CUSTOMES_VALUE', 'En euros');
+define('PACKAGE_TYPE', 'D=Document, M=Marchandise');
+define('REQUIRE_DESCRIPTION', 'Obligatoire Hors France');
+define('DESCRIPTION', '<br>La description doit être la plus précise possible et en anglais (type, d\' objet, utilisation, composition).  <br> le champ est à renseigné avec l\' article le plus significatif, celui en plus grand nombre ou le plus cher du colis. <br> Exemple : Trompette en platique accessoire = Plastic trumpet accessory');
+define('SATURDAY_DELIVERY', 'Pour que ce soit livré le Samedi uniquement si date d\' envoi est Vendredi');
+Define('REQUIRE_CHRONO_RELAY_ID', 'Obligatoire si Produit Chrono Relais. ');
+define('CHRONO_RELAY_ID', 'Valeur obtenue uniquement par les WebServices Chronopost');
+define('WEIGHT', 'En Kg');
+define('WIDTH', 'En cm');
+define('LENGTH', 'En cm');
+define('HEIGHT', 'En cm');
+define('UNUSED', 'Inutilise');
+define('ALERT_SENDER', 'O pour Oui et N pour Non');
+define('ALERT_RECIPIENT', 'O pour Oui et N pour Non');
+define('REQUIRE_DLC', 'Obligatoire si Produit FOOD. ');
+define('DLC', 'Date Limite de Consommation. Format : JJ/MM/AAAA');
+define('REQUIRE_START_TIME_SLOT', 'Obligatoire si produit précisé. ');
+define('START_TIME_SLOT', 'Voir avec votre contact informatique Chronopost. Format : JJMMAAHHmm .');
+define('REQUIRE_END_TIME_SLOT', 'Obligatoire si produit précisé.');
+define('END_TIME_SLOT', 'Voir avec votre contact informatique Chronopost. Format : JJMMAAHHmm');
+define('REQUIRE_AS_CODE', 'Obligatoire pour certains produits. Les valeurs seront communiquées par IT Chronopost. ');
+define('AS_CODE', 'Voir avec votre contact informatique Chronopost');
+define('SERVICE_CODE', 'Voir avec votre contact informatique Chronopost');
+define('MONO_PACKAGE', 'Si il y a plusieurs colis pour le même client, il faut que dans le fichier, il ait une ligne d\' adresse par colis. <br> Exemple :3 colis pour le même client, il faut 3 lignes d \'adresses identiques avec le poids propre à chaque colis.');
+define('MULTI_PACKAGE', 'Le fichier doit: <br> - soit contenir une ligne par colis avec le poids du colis. <br> - ou soit  mettre le nombre de colis dans le champ n°29 (nombre de colis), dans ce cas le poids est le poids total, avec un nombre de colis ne dépassant pas 9.');
+?>
Index: www-lp/www/admin/includes/languages/english/images/buttons/button_chronopost.gif
===================================================================
diff -u
Binary files differ
Index: www-lp/www/admin/includes/languages/french.php
===================================================================
diff -u -r4 -r29
--- www-lp/www/admin/includes/languages/french.php	(.../french.php)	(revision 4)
+++ www-lp/www/admin/includes/languages/french.php	(.../french.php)	(revision 29)
@@ -169,6 +169,7 @@
 define('JS_STATE_SELECT', '-- Choisissez ci-dessus --');
 define('JS_ZONE', '* L\'entrée \'Département\' doit être choisie parmi la liste pour ce pays.');
 define('JS_COUNTRY', '* La valeur \'Pays\' doit être choisie.\n');
+define('JS_TELEPHONE_COUNTRY', '* L\'entrée \'Indicatif du pays\' doit être rempli \n');
 define('JS_TELEPHONE', '* L\'entrée \'Numéro de téléphone\' doit avoir au moins ' . ENTRY_TELEPHONE_MIN_LENGTH . ' caractères.\n');
 define('JS_PASSWORD', '* Les entrées \'Mot de passe\' et \'Confirmation\' doivent avoir au moins ' . ENTRY_PASSWORD_MIN_LENGTH . ' caractères.\n');
 
@@ -216,6 +217,8 @@
 define('ENTRY_STATE_ERROR', '&nbsp;<span class="errorText">requis</span>');
 define('ENTRY_COUNTRY', 'Pays :');
 define('ENTRY_COUNTRY_ERROR', '');
+define('ENTRY_COUNTRY_CODE', 'Indicatif du pays&nbsp;:');
+define('ENTRY_COUNTRY_CODE_ERROR', 'Veuillez compléter votre indicatif du pays');
 define('ENTRY_TELEPHONE_NUMBER', 'Num&eacute;ro de t&eacute;l&eacute;phone :');
 define('ENTRY_TELEPHONE_NUMBER_ERROR', '&nbsp;<span class="errorText">min. ' . ENTRY_TELEPHONE_MIN_LENGTH . ' caract.</span>');
 define('ENTRY_FAX_NUMBER', 'Num&eacute;ro de fax :');
@@ -247,6 +250,7 @@
 define('IMAGE_ICON_STATUS_PURPLE_LIGHT', 'En stock');
 define('TEXT_PRODUCTS_OUT_OF_STOCK', 'Epuis&eacute;');
 // <- VDOFS 
+define('IMAGE_CHRONOPOST', 'Chronopost');
 define('IMAGE_ICON_INFO', 'Info');
 define('IMAGE_INSERT', 'Ins&eacute;rer');
 define('IMAGE_LOCK', 'Verouilller');
Index: www-lp/www/admin/includes/languages/english/edit_form_chronopost.php
===================================================================
diff -u
--- www-lp/www/admin/includes/languages/english/edit_form_chronopost.php	(revision 0)
+++ www-lp/www/admin/includes/languages/english/edit_form_chronopost.php	(revision 29)
@@ -0,0 +1,51 @@
+<?php
+/*
+  $Id: edit_form_chronopost.php v5.0 08/12/2007 djmonkey1 Exp $
+
+  osCommerce, Open Source E-Commerce Solutions
+  http://www.oscommerce.com
+
+  Copyright (c) 2007 osCommerce
+
+  Released under the GNU General Public License
+*/
+define('ENTRY_CUSTOMER', 'Client');
+define('ENTRY_SHIPPING_ADDRESS', 'Adresse de livraison :');
+define('ENTRY_BILLING_ADDRESS', 'Adresse de facturation :');
+
+//Add info fields 
+define('RECIPIENT_REFERENCE','N° identifiant destinataire');
+define('RECIPIENT_COMPANY', 'Ou Nom et Prénom');
+define('RECIPIENT_COUNTRY_CODE', 'Code pays ISO, si vide FR par défaut');
+define('RECIPIENT_PHONE', 'Téléphone portable de préférence');
+define('PRODUCT_INFO', 'Obligatoire si pas de produit par défaut');
+define('REFERENCE', 'N° BL, N° commande, N° facture, etc ...');
+define('ACCOUNT_NUMBER', 'Obligatoire si plusieurs comptes');
+define('SUB_ACCOUNT_NUMBER','Par exemple mettre 1 et non 001');
+define('INSURANCE', 'En euros');
+define('CUSTOMES_VALUE', 'En euros');
+define('PACKAGE_TYPE', 'D=Document, M=Marchandise');
+define('REQUIRE_DESCRIPTION', 'Obligatoire Hors France');
+define('DESCRIPTION', '<br>La description doit être la plus précise possible et en anglais (type, d\' objet, utilisation, composition).  <br> le champ est à renseigné avec l\' article le plus significatif, celui en plus grand nombre ou le plus cher du colis. <br> Exemple : Trompette en platique accessoire = Plastic trumpet accessory');
+define('SATURDAY_DELIVERY', 'Pour que ce soit livré le Samedi uniquement si date d\' envoi est Vendredi');
+Define('REQUIRE_CHRONO_RELAY_ID', 'Obligatoire si Produit Chrono Relais. ');
+define('CHRONO_RELAY_ID', 'Valeur obtenue uniquement par les WebServices Chronopost');
+define('WEIGHT', 'En Kg');
+define('WIDTH', 'En cm');
+define('LENGTH', 'En cm');
+define('HEIGHT', 'En cm');
+define('UNUSED', 'Inutilise');
+define('ALERT_SENDER', 'O pour Oui et N pour Non');
+define('ALERT_RECIPIENT', 'O pour Oui et N pour Non');
+define('REQUIRE_DLC', 'Obligatoire si Produit FOOD. ');
+define('DLC', 'Date Limite de Consommation. Format : JJ/MM/AAAA');
+define('REQUIRE_START_TIME_SLOT', 'Obligatoire si produit précisé. ');
+define('START_TIME_SLOT', 'Voir avec votre contact informatique Chronopost. Format : JJMMAAHHmm .');
+define('REQUIRE_END_TIME_SLOT', 'Obligatoire si produit précisé.');
+define('END_TIME_SLOT', 'Voir avec votre contact informatique Chronopost. Format : JJMMAAHHmm');
+define('REQUIRE_AS_CODE', 'Obligatoire pour certains produits. Les valeurs seront communiquées par IT Chronopost. ');
+define('AS_CODE', 'Voir avec votre contact informatique Chronopost');
+define('SERVICE_CODE', 'Voir avec votre contact informatique Chronopost');
+define('MONO_PACKAGE', 'Si il y a plusieurs colis pour le même client, il faut que dans le fichier, il ait une ligne d\' adresse par colis. <br> Exemple :3 colis pour le même client, il faut 3 lignes d \'adresses identiques avec le poids propre à chaque colis.');
+define('MULTI_PACKAGE', 'Le fichier doit: <br> - soit contenir une ligne par colis avec le poids du colis. <br> - ou soit  mettre le nombre de colis dans le champ n°29 (nombre de colis), dans ce cas le poids est le poids total, avec un nombre de colis ne dépassant pas 9.');
+?>
Index: www-lp/www/admin/includes/languages/french/images/buttons/button_chronopost.gif
===================================================================
diff -u
Binary files differ
Index: www-lp/www/admin/edit_form_chronopost.php
===================================================================
diff -u
--- www-lp/www/admin/edit_form_chronopost.php	(revision 0)
+++ www-lp/www/admin/edit_form_chronopost.php	(revision 29)
@@ -0,0 +1,1350 @@
+<?php 
+session_start();
+// -> VD : debug
+require_once('../logger/include.php');
+// <- VD
+  require('includes/application_top.php');
+
+  // include the appropriate functions & classes
+  include('order_editor/functions.php');
+  include('order_editor/cart.php');
+  include('order_editor/order.php');
+  include('order_editor/shipping.php');
+  include('order_editor/http_client.php');
+  include('includes/classes/order.php');
+
+$oID = tep_db_prepare_input($_GET['oID']);
+//$order = new manualOrder($oID);
+$order = new Order($oID);
+
+
+
+function validate_input(&$receiver_data, &$packages_list){
+    $ok = True;
+
+    // produit
+    switch ( $receiver_data['code_pays_destinataire'] ) {
+        case 'FR': $receiver_data['produit']='1S'; break;    // code produit pour la France : chrono 13 instance agence
+        default:   $receiver_data['produit']='44';           // hors France : chrono classic
+    }
+    // traitement des colis
+    $new_packages_list = array();
+    foreach ($packages_list as $package){
+        if (isset($package['poids'])) {
+            if ($package['poids'] > 0) { // le colis peut être traité si son poids est > 0
+
+                // code service en fonction du poids et du type de client
+                if($receiver_data['produit'] ==='44'){ // hors France : chrono classic uniquement
+                    if ($package['poids'] <= 3 && $receiver_data['type_client'] === 'customer') {
+                        $package['code_service'] = 136;
+                    }
+                    else if ($package['poids'] > 3 && $receiver_data['type_client'] === 'customer') {
+                        $package['code_service'] = 101;
+                    }
+                    else if ($package['poids'] <= 3 && $receiver_data['type_client'] === 'business') {
+                        $package['code_service'] = 328;
+                    }
+                    else if ($package['poids'] > 3 && $receiver_data['type_client'] === 'business') {
+                        $package['code_service'] = 327;
+                    }
+                }    
+
+                // valeur produit avec necessite ou non d'une description
+                if ($receiver_data['produit'] === '1S' ||                              // livraison en France ou ...
+                (isset($package['description']) && $receiver_data['produit'] === '44') )// livraison hors France et description fournie
+                {  
+                    array_push($new_packages_list, $package);
+                }
+            }
+        }
+    }
+
+    unset($receiver_data['type_client']);
+    $receiver_data['nombre_de_colis'] = 1;
+    $packages_list = $new_packages_list;
+    return $ok;
+}
+            
+
+function export_to_csv($receiver_data, $packages_list){
+    validate_input($receiver_data, $packages_list);
+    $sources_and_fields = array(
+        array('receiver_data', 'reference_destinataire'),
+        array('receiver_data', 'societe_destinataire'),
+        array('receiver_data', 'nom_destinataire'),
+        array('receiver_data', 'prenom_destinataire'),
+        array('receiver_data', 'adresse_destinataire'),
+        array('receiver_data', 'adresse_2_destinataire'),
+        array('receiver_data', 'code_porte_destinataire'),
+        array('receiver_data', 'code_postal_destinataire'),
+        array('receiver_data', 'ville_destinataire'),
+        array('receiver_data', 'code_pays_destinataire'),
+        array('receiver_data', 'telephone_destinataire'),
+        array('receiver_data', 'email_destinataire'),
+        array('receiver_data', 'reference_1'),
+        array('receiver_data', 'code_barre_client'),
+        array('receiver_data', 'produit'),
+        array('receiver_data', 'numero_de_compte'),
+        array('receiver_data', 'numero_de_sous_compte'),
+        array('package', 'assurance'),
+        array('package', 'valeur_en_douane'),
+        array('package', 'type_de_colis'),
+        array('package', 'description'),
+        array('package', 'livraison_samedi'),
+        array('receiver_data', 'id_chrono_relais'),
+        array('package', 'poids'),
+        array('receiver_data', 'largeur'),
+        array('receiver_data', 'longueur'),
+        array('receiver_data', 'hauteur'),
+        array('package', 'alerter_destinataire'),
+        array('receiver_data', 'nombre_de_colis'),
+        array('package', 'date_d_envoi'),
+        array('receiver_data', 'inutilise'),
+        array('receiver_data', 'alerter_expediteur'),
+        array('receiver_data', 'dlc'),
+        array('receiver_data', 'debut_du_creneau'),
+        array('receiver_data', 'fin_du_creneau'),
+        array('receiver_data', 'as_code'),
+        array('package', 'code_service'),
+    );
+
+
+    $output = fopen('php://output', 'w');
+
+    foreach ($packages_list as $package){
+        $data = '';
+        foreach ($sources_and_fields as $pair) {
+            list($source, $field) = $pair;
+            // Accède à la valeur de la clé dans le tableau associatif
+            $cmd='$data .= $' . $source . "['" . $field . "'];";
+            $data .= eval($cmd);
+            $data .= ';';
+        }
+       // $data = rtrim($data, ";"); // suppression du dernier ";"
+        if (substr($data, -1) === ";") { // Vérifie si le dernier caractère est un ";"
+            $data = substr($data, 0, -1); // Supprime le dernier caractère ";"
+        }
+        fwrite($output, $data . "\n");
+    }
+    fclose($output);   
+
+}
+
+
+
+
+$MAX_COLIS=3;
+
+$packages_list = array();
+
+for ($i = 1; $i <= $MAX_COLIS; $i++) {
+    $packages_list[] = array(
+        'poids' => stripslashes(tep_db_input(tep_db_prepare_input($_POST['poids_' . $i]))),
+        'description' => stripslashes(tep_db_input(tep_db_prepare_input($_POST['description_' . $i]))),
+        'assurance' => stripslashes(tep_db_input(tep_db_prepare_input($_POST['assurance_' . $i]))),
+        'valeur_en_douane' => stripslashes(tep_db_input(tep_db_prepare_input($_POST['valeur_en_douane_' . $i]))),
+        'type_de_colis' => stripslashes(tep_db_input(tep_db_prepare_input($_POST['type_de_colis_' . $i]))),
+        'livraison_samedi' => stripslashes(tep_db_input(tep_db_prepare_input($_POST['livraison_samedi_' . $i]))),
+        'alerter_destinataire' => stripslashes(tep_db_input(tep_db_prepare_input($_POST['alerter_destinataire_' . $i]))),
+        'date_d_envoi' => stripslashes(tep_db_input(tep_db_prepare_input($_POST['date_d_envoi_' . $i]))),        
+    );
+}
+
+function remove_accented_characters($string) {
+    $accents = array(
+        'À' => 'A', 'Á' => 'A', 'Â' => 'A', 'Ã' => 'A', 'Ä' => 'A', 'Å' => 'A',
+        'Æ' => 'AE', 'Ç' => 'C', 'È' => 'E', 'É' => 'E', 'Ê' => 'E', 'Ë' => 'E',
+        'Ì' => 'I', 'Í' => 'I', 'Î' => 'I', 'Ï' => 'I', 'Ñ' => 'N', 'Ò' => 'O',
+        'Ó' => 'O', 'Ô' => 'O', 'Õ' => 'O', 'Ö' => 'O', 'Ø' => 'O', 'Ù' => 'U',
+        'Ú' => 'U', 'Û' => 'U', 'Ü' => 'U', 'Ý' => 'Y', 'ß' => 'ss', 'à' => 'a',
+        'á' => 'a', 'â' => 'a', 'ã' => 'a', 'ä' => 'a', 'å' => 'a', 'æ' => 'ae',
+        'ç' => 'c', 'è' => 'e', 'é' => 'e', 'ê' => 'e', 'ë' => 'e', 'ì' => 'i',
+        'í' => 'i', 'î' => 'i', 'ï' => 'i', 'ñ' => 'n', 'ò' => 'o', 'ó' => 'o',
+        'ô' => 'o', 'õ' => 'o', 'ö' => 'o', 'ø' => 'o', 'ù' => 'u', 'ú' => 'u',
+        'û' => 'u', 'ü' => 'u', 'ý' => 'y', 'ÿ' => 'y'
+    );
+    
+    return strtr($string, $accents);
+}
+
+$receiver_data = array(
+    'type_client' => stripslashes(tep_db_input(tep_db_prepare_input($_POST['type_client']))),
+    'reference_destinataire' => '',
+    'societe_destinataire' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['societe_destinataire'])))),
+    'nom_destinataire' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['nom_destinataire'])))),
+    'prenom_destinataire' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['prenom_destinataire'])))),
+    'adresse_destinataire' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['adresse_destinataire'])))),
+    'adresse_2_destinataire' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['adresse_2_destinataire'])))),
+    'code_porte_destinataire' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['code_porte_destinataire'])))),
+    'code_postal_destinataire' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['code_postal_destinataire'])))),
+    'ville_destinataire' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['ville_destinataire'])))),
+    'code_pays_destinataire' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['code_pays_destinataire'])))),
+    'telephone_destinataire' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['telephone_destinataire'])))),
+    'email_destinataire' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['email_destinataire'])))),
+    'reference_1' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['reference_1'])))),
+    'code_barre_client' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['code_barre_client'])))),
+    'produit' => '',
+    'numero_de_compte' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['numero_de_compte'])))),
+    'numero_de_sous_compte' => remove_accented_characters(stripslashes(tep_db_input(tep_db_prepare_input($_POST['numero_de_sous_compte'])))),
+    'id_chrono_relais' => '',
+    'largeur' => '',
+    'longueur' => '',
+    'hauteur' => '',
+    'nombre_de_colis' => '', // nombre de colis toujours égal à 1
+    'inutilise' => '',
+    'alerter_expediteur' => '',
+    'dlc' => '',
+    'debut_du_creneau' => '',
+    'fin_du_creneau' => '',
+    'as_code' => '',
+    'code_service' => '',
+);
+
+$customer_type_query = tep_db_query("select customers_id, is_partner,coeff_partner,customers_group_id from " . TABLE_CUSTOMERS . " where customers_id = " . (int)$order->customer['id']);
+
+$customer_type = tep_db_fetch_array($customer_type_query);
+
+$today_reversed = date('Ymd');
+
+$filename = $_GET['oID'] . '-' . $today_reversed . '-chronopost.csv';
+
+
+if ($_SERVER["REQUEST_METHOD"] === "POST") {
+    header('Content-Type: text/csv; charset=UTF-8');
+    header('Content-Disposition: attachment; filename="' . $filename . '"');
+
+    export_to_csv($receiver_data, $packages_list);
+
+    exit();
+}
+
+$CODES_ISO_2_EUROPEAN = array(
+    'AL' => 'Albanie',
+    'AD' => 'Andorre',
+    'AM' => 'Arménie',
+    'AT' => 'Autriche',
+    'AZ' => 'Azerbaïdjan',
+    'BY' => 'Biélorussie',
+    'BE' => 'Belgique',
+    'BA' => 'Bosnie-Herzégovine',
+    'BG' => 'Bulgarie',
+    'HR' => 'Croatie',
+    'CY' => 'Chypre',
+    'CZ' => 'République tchèque',
+    'DK' => 'Danemark',
+    'EE' => 'Estonie',
+    'FI' => 'Finlande',
+    'FR' => 'France',
+    'GE' => 'Géorgie',
+    'DE' => 'Allemagne',
+    'GR' => 'Grèce',
+    'HU' => 'Hongrie',
+    'IS' => 'Islande',
+    'IE' => 'Irlande',
+    'IT' => 'Italie',
+    'KZ' => 'Kazakhstan',
+    'LV' => 'Lettonie',
+    'LI' => 'Liechtenstein',
+    'LT' => 'Lituanie',
+    'LU' => 'Luxembourg',
+    'MT' => 'Malte',
+    'MD' => 'Moldavie',
+    'MC' => 'Monaco',
+    'ME' => 'Monténégro',
+    'NL' => 'Pays-Bas',
+    'MK' => 'Macédoine du Nord',
+    'NO' => 'Norvège',
+    'PL' => 'Pologne',
+    'PT' => 'Portugal',
+    'RO' => 'Roumanie',
+    'RU' => 'Russie',
+    'SM' => 'Saint-Marin',
+    'RS' => 'Serbie',
+    'SK' => 'Slovaquie',
+    'SI' => 'Slovénie',
+    'ES' => 'Espagne',
+    'SE' => 'Suède',
+    'CH' => 'Suisse',
+    'TR' => 'Turquie',
+    'UA' => 'Ukraine',
+    'GB' => 'Royaume-Uni',
+    'VA' => 'Vatican'
+);
+
+asort($CODES_ISO_2_EUROPEAN);
+
+$defaultCountryCode = 'FR';
+
+?>
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
+"http://www.w3.org/TR/html4/loose.dtd">
+<html <?php echo HTML_PARAMS; ?>>
+<head>
+<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
+<title><?php echo TITLE; ?></title>
+<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
+<?php include('order_editor/css.php');  
+      //because if you haven't got your css, what have you got?
+      ?>
+
+<script language="javascript" src="includes/general.js"></script>
+
+  <?php //include('order_editor/javascript.php');  
+      //because if you haven't got your javascript, what have you got?
+      ?>
+<?php // -> 0000003: icirelais/exapaq ?>
+<!-- Added for ICI Relais -->
+<script type="text/javascript" src="includes/icirelais.js"></script>
+<link rel="stylesheet" href="//code.jquery.com/ui/1.8.24/themes/base/jquery-ui.css">
+<script src="//code.jquery.com/jquery-1.8.2.js"></script>
+<script src="//code.jquery.com/ui/1.8.24/jquery-ui.js"></script>
+<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0-beta3/css/all.min.css">
+
+ 
+  <style>
+
+    /* Conteneur principal du formulaire */
+    form {
+      width: 100%;
+      max-width: 600px;
+      margin: 0 auto;
+      padding: 10px;
+      border: 1px solid #C9C9C9;
+      box-sizing: border-box;
+    }
+    
+
+    /* Grid pour chaque champ sur une ligne distincte */
+    .form-row {
+      display: grid;
+      grid-template-columns: 150px 1fr 20px 30px; /* Label, Champ, Indicateur requis, Infobulle */
+      gap: 10px;
+      align-items: center;
+      margin-bottom: 10px; /* Espace entre les lignes */
+    }
+
+    /* Style des éléments de formulaire */
+    .form-row label {
+      font-weight: bold;
+    }
+
+    .form-row input[type="text"],
+    .form-row input[type="number"] {
+      padding: 5px;
+      width: 100%;
+      box-sizing: border-box;
+    }
+
+    .fieldRequired {
+      color: #d34f4f;
+      font-weight: bold;
+      text-align: center;
+    }
+
+    .size {
+    width: 250px; 
+    display: inline-block;
+    }
+
+  .fr{
+    display: flex;
+    align-items: center;
+    gap: 10px; /* Espace horizontal entre les éléments dans chaque ligne */
+    margin-bottom: 2px; /* Espace vertical entre chaque ligne */
+  }
+
+  .collapse-headings.package-one{
+    background-color: #7ea7df;
+  }
+
+  .collapse-headings.package-two.open{
+    background-color: #507bb7;
+  }
+  .collapse-headings.package-two.close{
+    background-color: #507bb7;
+  }
+
+  .collapse-headings.package-three.open{
+    background-color: #3a629b;
+  }
+
+  .collapse-headings.package-three.close{
+    background-color: #3a629b;
+    }
+
+  .collapse-headings {
+    font-family: Verdana, Arial, sans-serif;
+    border: 1px solid transparent;
+    /*border-radius: 8px;*/
+    /*background-color: lightgrey;*/
+    background-color: #b3bfec;
+    margin: 0 auto;
+    padding: 5px;
+    height: 100%;
+    /*box-shadow: 0px 0px 11px rgb(79, 92, 107);*/
+    -webkit-transition: all .5s;
+    transition: all .5s;
+    /*margin-top: 25px;*/
+}
+.collapse-headings.open a:before {
+    content:"\f13a";
+    display: inline;
+    font-size: 15px;
+    padding-left: 10px;
+    padding-right: 10px;
+    color: black;
+    font-family: FontAwesome;
+}
+.collapse-headings.close a:before {
+    content:"\f138";
+    display: inline;
+    font-size: 15px;
+    padding-left: 10px;
+    padding-right: 10px;
+    color: black;
+    font-family: FontAwesome;
+}
+.collapse-headings a {
+    text-decoration: none !important;
+    float: left;
+}
+
+input, select {
+        width: 250px;
+        box-sizing: border-box;
+    }
+
+.table_data_customer{
+    box-shadow: 0px 0px 11px rgb(79, 92, 107);
+    border-radius: 20px;
+}
+
+.data_customer{
+    padding-left:15px;
+    padding-top:5px;
+    font-size:15px;
+}
+
+.collapse-content{
+    padding-top:20px;
+}
+
+.style_button{
+    display:flex;
+    justify-content: start;
+}
+
+  </style>
+
+</head>
+<body>
+<div id="dhtmltooltip"></div>
+<script type="text/javascript">
+
+/***********************************************
+* Cool DHTML tooltip script- © Dynamic Drive DHTML code library (www.dynamicdrive.com)
+* This notice MUST stay intact for legal use
+* Visit Dynamic Drive at http://www.dynamicdrive.com/ for full source code
+***********************************************/
+
+/***********************************************
+* For Order Editor
+* This has to stay here for the tooltips to work correctly
+* I tried sticking it with the rest of the javascript, but it has to be inside the <body> tag
+*
+***********************************************/
+
+var offsetxpoint=-60 //Customize x offset of tooltip
+var offsetypoint=20 //Customize y offset of tooltip
+var ie=document.all
+var ns6=document.getElementById && !document.all
+var enabletip=false
+if (ie||ns6)
+var tipobj=document.all? document.all["dhtmltooltip"] : document.getElementById? document.getElementById("dhtmltooltip") : ""
+
+function ietruebody(){
+return (document.compatMode && document.compatMode!="BackCompat")? document.documentElement : document.body
+}
+
+function ddrivetip(thetext, thecolor, thewidth){
+if (ns6||ie){
+if (typeof thewidth!="undefined") tipobj.style.width=thewidth+"px"
+if (typeof thecolor!="undefined" && thecolor!="") tipobj.style.backgroundColor=thecolor
+tipobj.innerHTML=thetext
+enabletip=true
+return false
+}
+}
+
+function positiontip(e){
+if (enabletip){
+var curX=(ns6)?e.pageX : event.clientX+ietruebody().scrollLeft;
+var curY=(ns6)?e.pageY : event.clientY+ietruebody().scrollTop;
+//Find out how close the mouse is to the corner of the window
+var rightedge=ie&&!window.opera? ietruebody().clientWidth-event.clientX-offsetxpoint : window.innerWidth-e.clientX-offsetxpoint-20
+var bottomedge=ie&&!window.opera? ietruebody().clientHeight-event.clientY-offsetypoint : window.innerHeight-e.clientY-offsetypoint-20
+
+var leftedge=(offsetxpoint<0)? offsetxpoint*(-1) : -1000
+
+//if the horizontal distance isn't enough to accomodate the width of the context menu
+if (rightedge<tipobj.offsetWidth)
+//move the horizontal position of the menu to the left by it's width
+tipobj.style.left=ie? ietruebody().scrollLeft+event.clientX-tipobj.offsetWidth+"px" : window.pageXOffset+e.clientX-tipobj.offsetWidth+"px"
+else if (curX<leftedge)
+tipobj.style.left="5px"
+else
+//position the horizontal position of the menu where the mouse is positioned
+tipobj.style.left=curX+offsetxpoint+"px"
+
+//same concept with the vertical position
+if (bottomedge<tipobj.offsetHeight)
+tipobj.style.top=ie? ietruebody().scrollTop+event.clientY-tipobj.offsetHeight-offsetypoint+"px" : window.pageYOffset+e.clientY-tipobj.offsetHeight-offsetypoint+"px"
+else
+tipobj.style.top=curY+offsetypoint+"px"
+tipobj.style.visibility="visible"
+}
+}
+
+function hideddrivetip(){
+if (ns6||ie){
+enabletip=false
+tipobj.style.visibility="hidden"
+tipobj.style.left="-1000px"
+tipobj.style.backgroundColor='white'
+tipobj.style.width='200'
+}
+}
+
+document.onmousemove=positiontip
+
+function exportCSV() {
+        window.location.href = '?action=exporte';
+    }
+
+
+$(function () {
+    var initialCollapse = localStorage.collapse ;
+    if (initialCollapse) initialCollapse = initialCollapse.split(",")
+    $(".collapse-headings>a").click(function () {
+        var div = $(this).parent();
+
+        div.toggleClass("close open");
+
+
+        $(".collapse-content", div).toggle("slow");
+
+        localStorage.collapse = $(".collapse-headings").map(function () {
+            return $(this).hasClass("open") ? "open" : "close"
+        }).get()
+        console.log(localStorage.collapse)
+        return false;
+    })
+    if (initialCollapse) {
+        $(".collapse-headings>a").each(function (i) {
+            var div = $(this).parent();
+            div.removeClass("close open").addClass(initialCollapse[i])
+
+            $(".collapse-content", div).toggle(initialCollapse[i] !== "close");
+
+        })
+    }
+
+});
+
+
+  </script>
+<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
+<table border="0" width="100%" cellspacing="2" cellpadding="3">
+    <tr>
+        <td width="<?php echo BOX_WIDTH; ?>" valign="top">
+        <table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
+        <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
+
+        </table>
+        </td>
+        <td width="1000" valign="top">
+            <table width="100%" border="0" cellspacing="0" cellpadding="2">
+                <!--<div>NB : Il faut éviter les caractères accentués.</div>-->
+                <?php echo tep_draw_form('edit_form_chronopost', "edit_form_chronopost.php", tep_get_all_get_params(array('action')) . 'action=edit_form', 'post', 'id=myForm onsubmit="return validateForm()"');?>
+                <div class="collapse-headings" id="collapse-headings"><strong>Section destinataire</strong>
+                    <br>
+                    <br>
+                    <div class="">
+                        <div class="form-section">
+                            <div class="form-group fr">
+                                <span class="">&nbsp;&nbsp;&nbsp;&nbsp;</span>
+                                <label for="type_client" class="size">Type de client</label>
+                                <select name="type_client">
+                                    <?php if($customer_type['customers_group_id'] === '1' || $customer_type['is_partner'] || $customer_type['coeff_partner'] > 1){ ?>
+                                        <option value="business">Professionnel</option>
+                                        <option value="customer">Particulier</option>
+                                    <?php }
+                                        else if($customer_type['customers_group_id'] === '0'){?>
+                                            <option value="customer">Particulier</option>
+                                            <option value="business">Professionnel</option>
+                                    <?php } ?>
+                                </select>
+                                <span></span>
+                                <span></span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">&nbsp;2&nbsp;</span>
+                                <label for="company" class="size">Société destinataire <br> ou Nom et prénom</label>
+                                <?php if($order->delivery['company'] != ""){ ?>
+                                    <input class="size" id='company' name="societe_destinataire" size="30" value="<?php echo $order->delivery['company']; ?>" maxlength="38" required>
+                                    <?php }
+                                    else{ ?>
+                                        <input class="size" name="societe_destinataire" size="30" value="" required>
+                                        <?php
+                                    }
+                                        ?>
+                                    <span class="fieldRequired">*</span>
+                                    <span>&nbsp;&nbsp;</span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">&nbsp;5&nbsp;</span>
+                                <label for="adresse_destinataire" class="size">Adresse destinataire</label>
+                                <input type="text" name="adresse_destinataire" size="30" value="<?php echo $order->delivery['street_address']?>" class="size" maxlength="38" required>
+                                <span class="fieldRequired">*</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">&nbsp;8&nbsp;</span>
+                                <label for="code_postal_destinataire" class="size">Code postal destinataire</label>
+                                <input type="text" name="code_postal_destinataire" size="30" value="<?php echo $order->delivery['postcode']; ?>" class="size" maxlength="17" required>
+                                <span class="fieldRequired">*</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">10</span>
+                                <label for="code_pays_destinataire" class="size">Code pays destinataire</label>
+                                <select name="code_pays_destinataire" id="isoCode">
+                                <?php
+                                echo $data_array['produit'];
+                                    foreach ($CODES_ISO_2_EUROPEAN as $code => $name) {
+                                        if($code === $defaultCountryCode){
+                                            $code_iso_fr = $code;
+                                            echo "<option value=\"$code\" selected>$name</option>";
+                                        }
+                                        else{
+                                            echo "<option value=\"$code\">$name</option>";
+                                        }
+                                    }
+                                ?>
+                                </select>
+                                <span>&nbsp;&nbsp;</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(RECIPIENT_COUNTRY_CODE); ?>')"; onMouseout="hideddrivetip()">
+                                    <script language="JavaScript" type="text/javascript">
+                                        <!--
+                                        document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                        //-->
+                                    </script>  
+                                </span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">&nbsp;9&nbsp;</span>
+                                <label for="ville_destinataire" class="size">Ville destinataire</label>
+                                <input type="text" name="ville_destinataire" size="30" value="<?php echo $order->delivery['city']; ?>" class="size" maxlength="38" required>
+                                <span class="fieldRequired">*</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">11</span>
+                                <label for="telephone_destinataire" class="size">Téléphone destinataire</label>
+                                <input type="text" type="number" step="0.000001" name="telephone_destinataire" size="27" value="<?php echo $order->customer['telephone']; ?>" maxlength="17" required>
+                                <span class="fieldRequired">*</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(RECIPIENT_PHONE); ?>')"; onMouseout="hideddrivetip()">
+                                    <script language="JavaScript" type="text/javascript">
+                                        <!--
+                                        document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                        //-->
+                                    </script>  
+                                </span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">12</span>
+                                <label for="email_destinataire" class="size">Email destinaire</label>
+                                <input type="text" name="email_destinataire" size="30" value="<?php echo $order->customer['email_address']; ?>" maxlength="80" required>
+                                <span class="fieldRequired">*</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+                        </div>
+                    </div>
+                </div>
+                <div class="collapse-headings open"><a href="#"><strong>. . .</strong></a>
+                    <br>
+                    <div class="collapse-content">
+                        <div class="form-section">
+                            <div class="form-group fr">
+                                <span class="">&nbsp;3&nbsp;</span>
+                                <label for="nom_destinataire" class="size">Nom destinataire</label>
+                                <input type="text" name="nom_destinataire" size="30" value="" class="size">
+                                <span>&nbsp;&nbsp;</span> <!-- Colonne vide pour alignement -->
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+                            <div class="form-group fr">
+                                <span class="">&nbsp;4&nbsp;</span>
+                                <label for="prenom_destinataire" class="size">Prénom destinataire</label>
+                                <input type="text" name="prenom_destinataire" size="30" value="" class="size">
+                                <span>&nbsp;&nbsp;</span> <!-- Colonne vide pour alignement -->
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+                            <div class="form-group fr">
+                                <span class="">&nbsp;6&nbsp;</span>
+                                <label for="adresse_2_destinataire" class="size">Adresse 2 destinataire</label>
+                                <input type="text" name="adresse_2_destinataire" size="30" value="" class="size" maxlength="38">
+                                <span>&nbsp;&nbsp;</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+                            
+                            <div class="form-group fr">
+                                <span class="">&nbsp;7&nbsp;</span>
+                                <label for="code_porte_destinataire" class="size">Code porte destinataire</label>
+                                <input type="text" name="code_porte_destinataire" size="30" value="" class="size" maxlength="38">
+                                <span>&nbsp;&nbsp;</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+                            
+                            <div class="form-group fr">
+                                <span class="">13</span>
+                                <label for="reference_1" class="size">Référence 1</label>
+                                <input type="text" name="reference_1" size="30" value="<?php echo $oID ?>" maxlength="35">
+                                <span>&nbsp;&nbsp;</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(REFERENCE); ?>')"; onMouseout="hideddrivetip()">
+                                    <script language="JavaScript" type="text/javascript">
+                                        <!--
+                                        document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                        //-->
+                                    </script> 
+                                </span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">16</span>
+                                <label for="numero_de_compte" class="size">Numéro de compte</label>
+                                <input type="number" step="0.000001" name="numero_de_compte" size="8" value="80205003" maxlength="8">
+                                <span>&nbsp;&nbsp;</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(ACCOUNT_NUMBER); ?>')"; onMouseout="hideddrivetip()">
+                                    <script language="JavaScript" type="text/javascript">
+                                        <!--
+                                        document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                        //-->
+                                    </script>  
+                                </span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">17</span>
+                                <label for="numero_de_sous_compte" class="size">Numéro de sous compte</label>
+                                <input type="number" step="0.000001" name="numero_de_sous_compte" size="3" value="" maxlength="3">
+                                <span>&nbsp;&nbsp;</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(SUB_ACCOUNT_NUMBER); ?>')"; onMouseout="hideddrivetip()">
+                                    <script language="JavaScript" type="text/javascript">
+                                        <!--
+                                        document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                        //-->
+                                    </script>  
+                                </span>
+                            </div>
+
+                        </div>
+                    </div>
+                </div>
+            
+                <div class="collapse-headings package-one"><strong>Colis 1</strong>
+                    <br>
+                    <br>
+                    <div class="">
+                        <div class="form-section">
+                            <div class="form-group fr">
+                                <span class="">24</span>
+                                <label for="poids_1" class="size">Poids (kg)</label>
+                                <input type="number" step="0.000001" id="poids_1" name="poids_1" size="27" value="" maxlength="5" required>
+                                <span class="fieldRequired"> *</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">21</span>
+                                <label for="description_1" class="size">Description</label>
+                                <input type="text" id="description_1" name="description_1" size="30" value="" maxlength="30">
+                                <span id="requiredIndicator_1" class="fieldRequired" style="display: none;"> *</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(REQUIRE_DESCRIPTION); echo oe_html_no_quote(DESCRIPTION); ?>')"; onMouseout="hideddrivetip()">
+                                <script language="JavaScript" type="text/javascript">
+                                    <!--
+                                    document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                    //-->
+                                </script>
+                                </span>
+                                <span class="fieldRequired"><?php echo REQUIRE_DESCRIPTION; ?></span>
+                            </div>
+                        </div>
+                        <div class="collapse-headings open package-one" id="collapse-headings-1"><strong>. . .</strong><a href="#"> </a>
+                            <div class="collapse-content">
+
+                                <div class="form-group fr">
+                                    <span class="">18</span>
+                                    <label for="assurance_1" class="size">Assurance</label>
+                                    <input type="number" step="0.000001" name="assurance_1" size="5" value="" maxlength="5">
+                                    <span>&nbsp;&nbsp;</span>
+                                    <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(INSURANCE); ?>')"; onMouseout="hideddrivetip()">
+                                        <script language="JavaScript" type="text/javascript">
+                                            <!--
+                                            document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                            //-->
+                                        </script>
+                                    </span>  
+                                </div>
+                                
+                                <div class="form-group fr">
+                                    <span class="">19</span>
+                                    <label for="valeur_en_douane_1" class="size">Valeur en douane</label>
+                                    <input type="number" step="0.000001" name="valeur_en_douane_1" size="27" value="" maxlength="5">
+                                    <span>&nbsp;&nbsp;</span>
+                                    <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(CUSTOMES_VALUE); ?>')"; onMouseout="hideddrivetip()">
+                                        <script language="JavaScript" type="text/javascript">
+                                            <!--
+                                            document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                            //-->
+                                        </script>  
+                                    </span>
+                                </div>
+
+                                <div class="form-group fr">
+                                    <span class="">20</span>
+                                    <label for="type_de_colis_1" class="size">Type de colis</label>
+                                    <select name="type_de_colis_1">
+                                        <option value=""></option>
+                                        <option value="D">Document</option>
+                                        <option value="M">Marchandise</option>
+                                    </select>
+                                    <span>&nbsp;&nbsp;</span>
+                                    <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(PACKAGE_TYPE); ?>')"; onMouseout="hideddrivetip()"></span>
+                                </div>
+
+                                <div class="form-group fr">
+                                    <span class="">22</span>
+                                    <label for="livraison_samedi_1" class="size">Livraison Samedi</label>
+                                    <select name="livraison_samedi_1">
+                                        <option value=""></option>
+                                        <option value="O">Oui</option>
+                                    </select>
+                                    <span>&nbsp;&nbsp;</span>
+                                    <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(SATURDAY_DELIVERY); ?>')"; onMouseout="hideddrivetip()">
+                                        <script language="JavaScript" type="text/javascript">
+                                            <!--
+                                            document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                            //-->
+                                        </script> 
+                                    </span>
+                                </div>
+
+                                <div class="form-group fr">
+                                    <span class="">28</span>
+                                    <label for="alerter_destinataire_1" class="size">Alerter destinataire</label>
+                                    <select name="alerter_destinaire_1">
+                                        <option value=""></option>
+                                        <option value="O">Oui</option>
+                                        <option value="N">Non</option>
+                                    </select>
+                                    <span>&nbsp;&nbsp;</span>
+                                    <span>&nbsp;&nbsp;</span>
+                                </div>
+
+                                <!--<div class="form-group fr">
+                                    <span class="">29</span>
+                                    <label for="nombre_de_colis" class="size">Nombre de colis</label>
+                                    <input type="number" name="nombre_de_colis" size="27" value="" required>
+                                    <span class="fieldRequired"> *</span>
+                                    <span>&nbsp;&nbsp;</span>
+                                </div>-->
+
+                                <div class="form-group fr">
+                                    <span class="">30</span>
+                                    <label for="date_d_envoi_1" class="size">Date d'envoi (JJ/MM/AAAA)</label>
+                                    <input name="date_d_envoi_1" size="30" value="" maxlength="10">
+                                    <span>&nbsp;&nbsp;</span>
+                                    <span>&nbsp;&nbsp;</span>
+                                </div>
+                            </div>
+                        </div>
+                    </div>
+                </div>
+                            
+                <div class="collapse-headings open package-two"><strong>Colis 2</strong><a href="#"> </a>
+                    <div class="collapse-content">
+                        <div class="form-section">
+                            <div class="form-group fr">
+                                    <span class="">24</span>
+                                    <label for="poids_2" class="size">Poids (kg)</label>
+                                    <input type="number" step="0.000001" id="poids_2" name="poids_2" size="27" value="" maxlength="5">
+                                    <span id="requiredIndicatorWeight_2" class="fieldRequired" style="display: none;"> *</span>   
+                                    <span>&nbsp;&nbsp;</span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">21</span>
+                                <label for="description_2" class="size">Description</label>
+                                <input type="text" id="description_2" name="description_2" size="30" value="" maxlength="30">
+                                <span id="requiredIndicator_2" class="fieldRequired" style="display: none;"> *</span>     
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(REQUIRE_DESCRIPTION); echo oe_html_no_quote(DESCRIPTION); ?>')"; onMouseout="hideddrivetip()">
+                                <script language="JavaScript" type="text/javascript">
+                                    <!--
+                                    document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                    //-->
+                                </script>
+                                </span>
+                                <span class="fieldRequired"><?php echo REQUIRE_DESCRIPTION; ?></span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">18</span>
+                                <label for="assurance_2" class="size">Assurance</label>
+                                <input type="number" step="0.000001" name="assurance_2" size="5" value="" maxlength="5">
+                                <span>&nbsp;&nbsp;</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(INSURANCE); ?>')"; onMouseout="hideddrivetip()">
+                                    <script language="JavaScript" type="text/javascript">
+                                        <!--
+                                        document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                        //-->
+                                    </script>
+                                </span>  
+                            </div>
+                            
+                            <div class="form-group fr">
+                                <span class="">19</span>
+                                <label for="valeur_en_douane_2" class="size">Valeur en douane</label>
+                                <input type="number" step="0.000001" name="valeur_en_douane_2" size="27" value="" maxlength="5">
+                                <span>&nbsp;&nbsp;</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(CUSTOMES_VALUE); ?>')"; onMouseout="hideddrivetip()">
+                                    <script language="JavaScript" type="text/javascript">
+                                        <!--
+                                        document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                        //-->
+                                    </script>  
+                                </span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">20</span>
+                                <label for="type_de_colis_2" class="size">Type de colis</label>
+                                <select name="type_de_colis_2">
+                                    <option value=""></option>
+                                    <option value="D">Document</option>
+                                    <option value="M">Marchandise</option>
+                                </select>
+                                <span>&nbsp;&nbsp;</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(PACKAGE_TYPE); ?>')"; onMouseout="hideddrivetip()"></span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">22</span>
+                                <label for="livraison_samedi_2" class="size">Livraison Samedi</label>
+                                <select name="livraison_samedi_2">
+                                    <option value=""></option>
+                                    <option value="O">Oui</option>
+                                </select>
+                                <span>&nbsp;&nbsp;</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(SATURDAY_DELIVERY); ?>')"; onMouseout="hideddrivetip()">
+                                    <script language="JavaScript" type="text/javascript">
+                                        <!--
+                                        document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                        //-->
+                                    </script> 
+                                </span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">28</span>
+                                <label for="alerter_destinataire_2" class="size">Alerter destinataire</label>
+                                <select name="alerter_destinaire_2">
+                                    <option value=""></option>
+                                    <option value="O">Oui</option>
+                                    <option value="N">Non</option>
+                                </select>
+                                <span>&nbsp;&nbsp;</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+
+                            <!--<div class="form-group fr">
+                                <span class="">29</span>
+                                <label for="nombre_de_colis" class="size">Nombre de colis</label>
+                                <input type="number" name="nombre_de_colis" size="27" value="" required>
+                                <span class="fieldRequired"> *</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>-->
+
+                            <div class="form-group fr">
+                                <span class="">30</span>
+                                <label for="date_d_envoi_2" class="size">Date d'envoi (JJ/MM/AAAA)</label>
+                                <input name="date_d_envoi_2" size="30" value="" maxlength="10">
+                                <span>&nbsp;&nbsp;</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+                        </div>
+                    </div>
+                </div>
+
+                <div class="collapse-headings open package-three"><strong>Colis 3</strong><a href="#"> </a>
+                    <div class="collapse-content">
+                        <div class="form-section">
+                            <div class="form-group fr">
+                                <span class="">24</span>
+                                <label for="poids_3" class="size">Poids (kg)</label>
+                                <input type="number" step="0.000001" id="poids_3" name="poids_3" size="27" value="" maxlength="5">
+                                <span id="requiredIndicatorWeight_3" class="fieldRequired" style="display: none;"> *</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">21</span>
+                                <label for="description_3" class="size">Description</label>
+                                <input type="text" id="description_3" name="description_3" size="30" value="" maxlength="30">
+                                <span id="requiredIndicator_3" class="fieldRequired" style="display: none;"> *</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(REQUIRE_DESCRIPTION); echo oe_html_no_quote(DESCRIPTION); ?>')"; onMouseout="hideddrivetip()">
+                                <script language="JavaScript" type="text/javascript">
+                                    <!--
+                                    document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                    //-->
+                                </script>
+                                </span>
+                                <span class="fieldRequired"><?php echo REQUIRE_DESCRIPTION; ?></span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">18</span>
+                                <label for="assurance_3" class="size">Assurance</label>
+                                <input type="number" step="0.000001" name="assurance_3" size="5" value="" maxlength="5">
+                                <span>&nbsp;&nbsp;</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(INSURANCE); ?>')"; onMouseout="hideddrivetip()">
+                                    <script language="JavaScript" type="text/javascript">
+                                        <!--
+                                        document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                        //-->
+                                    </script>
+                                </span>  
+                            </div>
+                            
+                            <div class="form-group fr">
+                                <span class="">19</span>
+                                <label for="valeur_en_douane_3" class="size">Valeur en douane</label>
+                                <input type="number" step="0.000001" name="valeur_en_douane_3" size="27" value="" maxlength="5">
+                                <span>&nbsp;&nbsp;</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(CUSTOMES_VALUE); ?>')"; onMouseout="hideddrivetip()">
+                                    <script language="JavaScript" type="text/javascript">
+                                        <!--
+                                        document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                        //-->
+                                    </script>  
+                                </span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">20</span>
+                                <label for="type_de_colis_3" class="size">Type de colis</label>
+                                <select name="type_de_colis_3">
+                                    <option value=""></option>
+                                    <option value="D">Document</option>
+                                    <option value="M">Marchandise</option>
+                                </select>
+                                <span>&nbsp;&nbsp;</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(PACKAGE_TYPE); ?>')"; onMouseout="hideddrivetip()"></span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">22</span>
+                                <label for="livraison_samedi_3" class="size">Livraison Samedi</label>
+                                <select name="livraison_samedi_3">
+                                    <option value=""></option>
+                                    <option value="O">Oui</option>
+                                </select>
+                                <span>&nbsp;&nbsp;</span>
+                                <span onMouseover="ddrivetip('<?php echo oe_html_no_quote(SATURDAY_DELIVERY); ?>')"; onMouseout="hideddrivetip()">
+                                    <script language="JavaScript" type="text/javascript">
+                                        <!--
+                                        document.write("<img src=\"images/icon_info.gif\" border= \"0\" width=\"13\" height=\"13\">");
+                                        //-->
+                                    </script> 
+                                </span>
+                            </div>
+
+                            <div class="form-group fr">
+                                <span class="">28</span>
+                                <label for="alerter_destinataire_3" class="size">Alerter destinataire</label>
+                                <select name="alerter_destinaire_3">
+                                    <option value=""></option>
+                                    <option value="O">Oui</option>
+                                    <option value="N">Non</option>
+                                </select>
+                                <span>&nbsp;&nbsp;</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+
+                            <!--<div class="form-group fr">
+                                <span class="">29</span>
+                                <label for="nombre_de_colis" class="size">Nombre de colis</label>
+                                <input type="number" name="nombre_de_colis" size="27" value="" required>
+                                <span class="fieldRequired"> *</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>-->
+
+                            <div class="form-group fr">
+                                <span class="">30</span>
+                                <label for="date_d_envoi_3" class="size">Date d'envoi (JJ/MM/AAAA)</label>
+                                <input name="date_d_envoi_3" size="30" value="" maxlength="10">
+                                <span>&nbsp;&nbsp;</span>
+                                <span>&nbsp;&nbsp;</span>
+                            </div>
+
+                        </div>
+                    </div>
+                </div>
+                <div class="style_button"><button type="submit" name="action" value="">Télécharger l'étiquette</button></div>
+            </table> 
+        </td>
+        <td valign="top">   
+        <table width="100%" border="0" cellspacing="0" cellpadding="0" style="border: 1px solid #C9C9C9;">
+                <tr class="dataTableHeadingRow dataTableContent" valign="top" colspan="4">
+                    <td class="data_customer"><strong><?php echo ENTRY_CUSTOMER; ?></strong></td>
+                </tr>    
+                <tr class="dataTableHeadingRow dataTableContent"> 
+                <td class="data_customer"><p>
+                    <?php if($order->customer['name'] != ""){
+                        echo $order->customer['name'];?>
+                    <br>
+                    <?php } ?>
+                    <?php if($order->customer['telephone'] != ""){
+                        echo $order->customer['telephone'];?>
+                    <br>
+                    <?php } ?>
+                    <?php if($order->customer['company'] != ""){
+                        echo $order->customer['company'];?>
+                    <br>
+                    <?php } ?>
+                    <?php if($order->customer['email_address'] != ""){
+                        echo $order->customer['email_address'];?>
+                    <br>
+                    <?php } ?>
+                    <?php if($order->customer['street_address'] != ""){
+                        echo $order->customer['street_address'];?>
+                    <br>
+                    <?php } ?>
+                    <?php if($order->customer['suburb'] != ""){
+                        echo $order->customer['suburb'];?>
+                    <br>
+                    <?php } ?>
+                    <?php if($order->customer['city'] != ""){
+                        echo $order->customer['city'];?>
+                    <br>
+                    <?php } ?>
+                    <?php if($order->customer['postcode'] != ""){
+                        echo $order->customer['postcode'];?>
+                    <br>
+                    <?php } ?>
+                    <?php if($order->customer['country'] != ""){
+                        echo $order->customer['country'];?>
+                    <?php } ?>
+                    </p></td>
+                </tr>
+            </table>
+            <table width="100%" border="0" cellspacing="0" cellpadding="0" style="border: 1px solid #C9C9C9;">
+            <tr class="dataTableHeadingRow dataTableContent" valign="top" colspan="4">
+                <td class="data_customer"><strong><?php echo ENTRY_SHIPPING_ADDRESS; ?></strong></td>
+            </tr>     
+            <tr class="dataTableHeadingRow dataTableContent"> 
+                <td class="data_customer"><p>
+                <?php if($order->delivery['name'] != ""){
+                    echo $order->delivery['name'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->delivery['telephone'] != ""){
+                    echo $order->delivery['telephone'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->delivery['company'] != ""){
+                    echo $order->delivery['company'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->delivery['email_address'] != ""){
+                    echo $order->delivery['email_address'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->delivery['street_address'] != ""){
+                    echo $order->delivery['street_address'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->delivery['suburb'] != ""){
+                    echo $order->delivery['suburb'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->delivery['city'] != ""){
+                    echo $order->delivery['city'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->delivery['postcode'] != ""){
+                    echo $order->delivery['postcode'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->delivery['country'] != ""){
+                    echo $order->delivery['country'];?>
+                <?php } ?>
+                </p></td>
+                </tr>
+            </table>
+            <table width="100%" border="0" cellspacing="0" cellpadding="0" style="border: 1px solid #C9C9C9;">
+                <tr class="dataTableHeadingRow dataTableContent" valign="top" colspan="4">
+                    <td class="data_customer"><strong><?php echo ENTRY_BILLING_ADDRESS; ?></strong></td>
+                </tr>    
+            <tr class="dataTableHeadingRow dataTableContent"> 
+                <td class="data_customer"><p>
+                <?php if($order->billing['name'] != ""){
+                    echo $order->billing['name'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->billing['telephone'] != ""){
+                    echo $order->billing['telephone'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->billing['company'] != ""){
+                    echo $order->billing['company'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->billing['email_address'] != ""){
+                    echo $order->billing['email_address'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->billing['street_address'] != ""){
+                    echo $order->billing['street_address'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->billing['suburb'] != ""){
+                    echo $order->billing['suburb'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->billing['city'] != ""){
+                    echo $order->billing['city'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->billing['postcode'] != ""){
+                    echo $order->billing['postcode'];?>
+                <br>
+                <?php } ?>
+                <?php if($order->billing['country'] != ""){
+                    echo $order->billing['country'];?>
+                <br>
+                <?php } ?>
+                </p></td>
+                </tr>
+            </table>
+        </td>
+    </tr>
+</table>
+  <!-- footer //-->
+  <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
+  <!-- footer_eof //-->
+   <script>
+
+let weightField_2 = document.getElementById('poids_2');
+let weightField_3 = document.getElementById('poids_3');
+//const selectedCountry = this.value;
+const requiredIndicatorWeight_2 = document.getElementById('requiredIndicatorWeight_2'); 
+const requiredIndicatorWeight_3 = document.getElementById('requiredIndicatorWeight_3'); 
+const descriptionField_1 = document.getElementById('description_1');
+const descriptionField_2 = document.getElementById('description_2');
+const descriptionField_3 = document.getElementById('description_3'); 
+const requiredIndicator_1 = document.getElementById('requiredIndicator_1');
+const requiredIndicator_2 = document.getElementById('requiredIndicator_2');
+const requiredIndicator_3 = document.getElementById('requiredIndicator_3');
+
+function refresh_screen() {
+    const selectedCountry = document.getElementById('isoCode').value;
+
+    let description_required;
+    if (selectedCountry === "FR") {
+        description_required=false;
+    } else {
+        description_required=true;
+    }
+
+    // weight/description field 1
+    if ( description_required ) {
+        descriptionField_1.setAttribute('required', 'required');
+        requiredIndicator_1.style.display = 'inline'
+    }
+    else {
+        descriptionField_1.removeAttribute('required');
+        requiredIndicator_1.style.display = 'none';
+    }
+
+    // weight/description field 2
+    if (weightField_2.value.trim() === '') {
+        weightField_2.removeAttribute('required');
+        descriptionField_2.removeAttribute('required');
+        requiredIndicator_2.style.display = 'none';
+        requiredIndicatorWeight_2.style.display = 'none';
+    } 
+    else {
+        weightField_2.setAttribute('required', 'required');
+        requiredIndicatorWeight_2.style.display = 'inline';
+        if ( description_required ) {
+            descriptionField_2.setAttribute('required', 'required');
+            requiredIndicator_2.style.display = 'inline'
+        }
+        else {
+            descriptionField_2.removeAttribute('required');
+            requiredIndicator_2.style.display = 'none';
+        }
+    }
+
+    // weight/description field 3
+    if (weightField_3.value.trim() === ''){
+        weightField_3.removeAttribute('required');
+        descriptionField_3.removeAttribute('required');
+        requiredIndicator_3.style.display = 'none';
+        requiredIndicatorWeight_3.style.display = 'none';
+    }
+    else {
+        weightField_3.setAttribute('required', 'required');
+        requiredIndicatorWeight_3.style.display = 'inline';
+        if ( description_required ) {
+            descriptionField_3.setAttribute('required', 'required');
+            requiredIndicator_3.style.display = 'inline'
+        }
+        else {
+            descriptionField_3.removeAttribute('required');
+            requiredIndicator_3.style.display = 'none';
+        }
+
+    }
+}
+
+
+
+document.getElementById('isoCode').addEventListener('change', function() {
+    refresh_screen();
+});
+        
+document.addEventListener('DOMContentLoaded', function() {
+    refresh_screen();
+});
+
+weightField_2.addEventListener('input', function() {
+    refresh_screen();
+});
+
+weightField_3.addEventListener('input', function() {
+    refresh_screen();
+});
+
+
+   </script>
+</body>
+</html>
+<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
\ No newline at end of file