<?
 include("GetSession.php");
 include("Ressources.inc.php");

 if (!$_SESSION["AJO"]){
  header("location : Listing.php");
  die();
  }

 $NatureDos = $_GET["nature"];

 /*****************************************************************************/
  $res_cre = getressourcearray("creationsimple.php",                                //
  								array(  "res_pays",                           //
                                        "res_cp",                             //
                                        "res_ville",                          //
                                        "res_expediteur",                     //
                                        "res_destinataire",                   //
                                        "res_quantite",                       //
                                        "res_poids",                           //
                                        "res_v_ref",                          //
                                        "res_emballage",                      //
                                        "res_volume",                         //
                                        "res_ref_agent",                      //
                                        "res_nature",                         //
                                        "res_m_lineaire",                     //
                                        "res_terme",                          //
                                        "res_date_enl",                       //
                                        "res_imperatif_enl",                      //
                                        "res_imperatif_liv",                      //
                                        "res_date_liv",                       //
                                        "res_valeur",             //
                                        "res_devise",                         //
                                        "res_cod",
                                        "res_transporteur",
                                        "res_observation",
                                        "res_appel",
                                        "btn_annuler",
                                        "btn_valider",
                                        "btn_appeloffre",
                                        "msg_oui",
                                        "msg_non",
                                        "res_attention",
                                        "popup_date",
										"res_attention_pays",
										"res_lien_fr_gb",
										"res_lien_sp_gb"                            //
                                	 ),                                       //
                                array(  "res_pays"=>"PAYS",                   //
                                        "res_cp"=>"CP",                  //
                                        "res_ville"=>"VILLE",                  //
                                        "res_expediteur"=>"EXPEDITEUR",          //
                                        "res_destinataire"=>"DESTINATAIRE",      //
                                        "res_quantite"=>"NB COLIS",           //
                                        "res_poids"=>"KGS",                   //
                                        "res_v_ref"=>"V/REF",                 //
                                        "res_emballage"=>"EMBALLAGE",          //
                                        "res_volume"=>"M3",               //
                                        "res_ref_agent"=>"V/REF2",         //
                                        "res_nature"=>"NATURE",               //
                                        "res_m_lineaire"=>"ML",       //
                                        "res_terme"=>"TERME",                 //
                                        "res_date_enl"=>"DATE ENL",       //
                                        "res_imperatif_enl"=>"IMP ",      //
                                        "res_imperatif_liv"=>"IMP ",      //
                                        "res_date_liv"=>"DATE LIV",      //
                                        "res_valeur"=>"VALEUR",//
                                        "res_devise"=>"DEVISE",             //
                                        "res_cod" =>"COD",
                                        "res_transporteur"=>"TRANSPORTEUR",
                                        "res_observation"=>"INSTRUCTIONS",
                                        "res_appel"=>"G&eacute;n&eacute;rer appel d'offre",
                                		"btn_annuler"=>"ANNULER",
                                        "btn_valider"=>"VALIDER",
                                        "btn_appeloffre"=>"APPEL D'OFFRE",
                                        "msg_oui"=>"OUI",
                                        "msg_non"=>"NON",
                                        "res_attention"=>"ATTENTION : Les champs en jaune sont obligatoires",
                                        "popup_date"=>"La date saisie est incorrecte",
										"res_attention_pays"=>"Les pays sont list&eacute;s sous leur forme anglaise. Ainsi, Angleterre = United Kingdom - Maroc = Morocco - Etats-Unis = United State...",
										"res_lien_fr_gb"=>"Traduction des pays du Fran&ccedil;ais vers l'Anglais :              http://www.culture.gouv.fr/culture/dglf/ressources/pays/FRANCAIS.HTM",
										"res_lien_sp_gb"=>"Traduction des pays de l'Espagnol vers l'Anglais :           http://www.culture.gouv.fr/culture/dglf/ressources/pays/ESPAGNOL.HTM"                //
                                     ),                  				      //
                                $_SESSION["langue"]);
/******************************************************************************/
?>
<html>
<head>
<style>
.lien1{
	color: #FF9600;
};
</style>
<title>FretOnline : La bourse de Fret gratuite sur Internet - Destinée aux Chargeurs,
exportateurs, importateurs...</title>
<meta name="description" content="Fretonline, la bourse de fret gratuite, met en relation les chargeurs et les professionnels du transport - Transporteurs, messagers, affréteurs, transitaires...">
<meta name="keywords" content="bourse de fret transporter marchandises système appel offres transport aérien maritime route messagerie affrètement bourse fret camion douane déménagement palettes caisse emballage chargeur affréteur messager avion bateaux déménager conditionnement logistique">
<script language="JavaScript" src="date-picker.js"></script>
<SCRIPT type='text/javascript'>
  function OuvrirPopup(page, nom, option){
    var top=(screen.height-400)/2;
    var left=(screen.width-640)/2;
     window.open(page, nom,'top='+top+',left='+left+','+option);
    return true;
  }

  function OuvrirPetitPopup(page, nom, option){
    var top=(screen.height-460)/2;
    var left=(screen.width-400)/2;
     window.open(page, nom,'top='+top+',left='+left+','+option);
    return true;
  }

  function Valider(Creation){
   if (Creation.Exp_Cp.value==""){
     alert("*** LE CODE POSTAL DE L\'EXPEDITEUR EST VIDE ***\r\nLe code postal est une zone obligatoire. Si vous ne connaissez pas ce code,\r\nvous devez saisir \"INC\".\r\nNéanmoins nous vous informons que votre offre sera moins diffusée qu\'avec\r\nun code postal valide.");
     Creation.Exp_Cp.focus();
     return;
   }

   if (Creation.Exp_Ville.value==""){
     alert("Vous devez entrer une ville d\'expediteur");
     Creation.Exp_Ville.focus();
     return;
   }

   if (Creation.Exp_Pays.value==""){
     alert("Vous devez entrer un pays d\'expediteur");
     Creation.Exp_Pays.focus();
     return;
   }

   if (Creation.Des_Cp.value==""){
     alert("*** LE CODE POSTAL DU DESTINATAIRE EST VIDE ***\r\nLe code postal est une zone obligatoire. Si vous ne connaissez pas ce code,\r\nvous devez saisir \"INC\".\r\nNéanmoins nous vous informons que votre offre sera moins diffusée qu\'avec\r\nun code postal valide.");
     Creation.Des_Cp.focus();
     return;
   }

   if (Creation.Des_Ville.value==""){
     alert("Vous devez entrer une ville de destinataire");
     Creation.Des_Ville.focus();
     return;
   }

   if (Creation.Des_Pays.value==""){
     alert("Vous devez entrer un pays de destinataire");
     Creation.Des_Pays.focus();
     return;
   }

   if (Creation.Emb.value==""){
     alert("Vous devez entrer un code d'emballage");
     Creation.Emb.focus();
     return;
   }

  if (!checkDate(Creation.date_enl)){
    alert("");
  	return;
  }

  if (!checkDate(Creation.date_liv)){
    alert("");
  	return;
  }

   Creation.submit();
  }
</SCRIPT>
<SCRIPT TYPE="text/javascript">
<!--
function numbersonly(myfield, e)
{
var key;
var keychar;

if (window.event)
   key = window.event.keyCode;
else if (e)
   key = e.which;
else
   return true;
keychar = String.fromCharCode(key);

// control keys
if ((key==null) || (key==0) || (key==8) ||
    (key==9) || (key==13) || (key==27) )
   return true;

// numbers
else if ((("0123456789.").indexOf(keychar) > -1))
   return true;
else
   return false;
}

//-->
</SCRIPT>
<script language="javascript">
/**********************************************************************/
/*Function name :isDigit(theDigit) */
/*Usage of this function :test for an digit */
/*Input parameter required:thedata=string for test whether is digit */
/*Return value :if is digit,return true */
/* else return false */
/**********************************************************************/
function isDigit(theDigit)
{
var digitArray = new Array('0','1','2','3','4','5','6','7','8','9'),j;

for (j = 0; j < digitArray.length; j++)
{if (theDigit == digitArray[j])
return true
}
return false

}

/*************************************************************************/
/*Function name :isPositiveInteger(theString) */
/*Usage of this function :test for an +ve integer */
/*Input parameter required:thedata=string for test whether is +ve integer*/
/*Return value :if is +ve integer,return true */
/* else return false */
/*function require :isDigit */
/*************************************************************************/
function isPositiveInteger(theString)
{
var theData = new String(theString)

if (!isDigit(theData.charAt(0)))
if (!(theData.charAt(0)== '+'))
return false

for (var i = 1; i < theData.length; i++)
if (!isDigit(theData.charAt(i)))
return false
return true
}

/**********************************************************************/
/*Function name :isDate(s,f) */
/*Usage of this function :To check s is a valid format */
/*Input parameter required:s=input string */
/* f=input string format */
/* =1,in mm/dd/yyyy format */
/* else in dd/mm/yyyy */
/*Return value :if is a valid date return 1 */
/* else return 0 */
/*Function required :isPositiveInteger() */
/**********************************************************************/
function isDate(s,f)
{var a1=s.split("/");
var a2=s.split("-");
var e=true;
if ((a1.length!=3) && (a2.length!=3))
{
e=false;
}
else
{if (a1.length==3)
var na=a1;
if (a2.length==3)
var na=a2;
if (isPositiveInteger(na[0]) && isPositiveInteger(na[1]) && isPositiveInteger(na[2]))
{ if (f==1)
{var d=na[1],m=na[0];
}
else
{var d=na[0],m=na[1];
}
var y=na[2];
if (((e) && (y<1000)||y.length>4))
e=false
if (e)
{
v=new Date(m+"/"+d+"/"+y);
if (v.getMonth()!=m-1)
e=false;
}
}
else
{
e=false;
}
}
return e
}

function checkDate(v)
{
var s=v.value;
if (isDate(s,0)){//dd/mm/yyyy format
 return true;
 }
else
  {
  v.focus();
  v.select();
  return false;
  }
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#919CBB" leftmargin="0" topmargin="1" marginheight="0"  marginwidth="0" onKeyDown="handlePress(event)" onLoad='Creation.Exp_Cp.focus();'>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td align="center" bgcolor="#FFFFFF"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="766" height="228">
        <param name="movie" value="Flash/headermember_.swf">
        <param name="quality" value="high">
        <param name="menu" value="false">
        <embed src="Flash/headermember_.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="766" height="228"></embed>
      </object></td>
  </tr>
</table>
<p>
  <SCRIPT LANGUAGE='JavaScript'>
var focused;

function whichField(obj){
   focused = obj;
};

function handlePress(e) {
  var whichCode = (window.Event) ? e.which : e.keyCode;

  if ((whichCode==13)||(whichCode==9)){
    if (focused=='Exp_Cp'){
    	if (!e.shiftKey) {
        	window.document.forms['Creation'].elements['Exp_Ville'].focus();
        }
        else
        {
         	window.document.forms['Creation'].elements['Submit'].focus();
        }
    };

    if (focused=='Exp_Ville'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['Exp_Pays'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['Exp_Cp'].focus();
        }
    };

    if (focused=='Exp_Pays'){
    	if (!e.shiftKey){
        	//OuvrirPetitPopup('paysappelsimple.php?pays='+window.document.forms['Creation'].elements['Exp_Pays'].value+'&champs=Exp_Pays','ExpPays','width=400,height=460,menubar=no,status=no,scrollbars=yes,resizable=no');
        	window.document.forms['Creation'].elements['Des_Cp'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['Exp_Ville'].focus();
        }
    };

    if (focused=='Des_Cp'){
    	if (!e.shiftKey) {
        	window.document.forms['Creation'].elements['Des_Ville'].focus();
        }
        else
        {
         	window.document.forms['Creation'].elements['Exp_Pays'].focus();
        }
    };

    if (focused=='Des_Ville'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['Des_Pays'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['Des_Cp'].focus();
        }
    };

    if (focused=='Des_Pays'){
    	if (!e.shiftKey){
        	//OuvrirPetitPopup('paysappelsimple.php?pays='+window.document.forms['Creation'].elements['Des_Pays'].value+'&champs=Des_Pays','DesPays','width=400,height=460,menubar=no,status=no,scrollbars=yes,resizable=no');
        	window.document.forms['Creation'].elements['Qte'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['Des_Ville'].focus();
        }
    };

    if (focused=='Qte'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['Emb'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['Des_Pays'].focus();
        }
    };

    if (focused=='Emb'){
    	if (!e.shiftKey){
        	//OuvrirPetitPopup('emballage.php?emb='+window.document.forms['Creation'].elements['Emb'].value,'emballage','width=400,height=460,menubar=no,status=no,scrollbars=yes,resizable=no');
        	window.document.forms['Creation'].elements['NatureM'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['Qte'].focus();
        }
    };

    if (focused=='NatureM'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['poids'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['Emb'].focus();
        }
    };

    if (focused=='poids'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['volume'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['NatureM'].focus();
        }
    };

    if (focused=='volume'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['lineaire'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['poids'].focus();
        }
    };

    if (focused=='lineaire'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['vref'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['volume'].focus();
        }
    };

    if (focused=='vref'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['refagent'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['lineaire'].focus();
        }
    };

    if (focused=='refagent'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['terme'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['vref'].focus();
        }
    };

    if (focused=='terme'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['date_enl'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['refagent'].focus();
        }
    };

    if (focused=='date_enl'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['imp_enl'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['terme'].focus();
        }
    };

    if (focused=='imp_enl'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['date_liv'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['date_enl'].focus();
        }
    };

    if (focused=='date_liv'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['imp_liv'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['imp_enl'].focus();
        }
    };

    if (focused=='imp_liv'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['valeur_march'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['date_liv'].focus();
        }
    };

    if (focused=='valeur_march'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['devise_march'].focus();
        }
        else
        {
           window.document.forms['Creation'].elements['imp_liv'].focus();
        }
    };

    if (focused=='devise_march'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['cod'].focus();
        }
          else
        {
           window.document.forms['Creation'].elements['valeur_march'].focus();
        }
    };

    if (focused=='cod'){
    	if (!e.shiftKey){
        	window.document.forms['Creation'].elements['obs'].focus();
        }
          else
        {
           window.document.forms['Creation'].elements['valeur_march'].focus();
        }
    };

    if (focused=='obs'){
    	if (whichCode==13){
           return;
        }
		if (!e.shiftKey){ window.document.forms['Creation'].elements['Exp_Cp'].focus(); }else{window.document.forms['Creation'].elements['devise_march'].focus();}
    };

    if (focused=='Submit'){
		if (!e.shiftKey){Valider(Creation);}else{window.document.forms['Creation'].elements['obs'].focus();}
    };

    window.event.cancelBubble = true;
    window.event.returnValue = false;
  };
}
</SCRIPT>
</p>
<form name="Creation" method="post" action="validersimple.php">
  <table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td width="1" background="images/rep_3.jpg"></td>
      <td width="7">
<table width="780" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td background="images/rep_3.jpg" height="1"></td>
          </tr>
        </table>
        <table width="780" border="0" align="center" bgcolor="#E8E8E8">
          <tr>
            <td width="121"><font color="#919CBB" face=arial size=2><b> <? echo $res_cre["res_expediteur"];?></b></font></td>
            <td height="18" width="151"> <font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_cp"]; ?>
              </b></font> <input name="Exp_Cp" type="text" onKeypress="if ((event.keyCode > 32 && event.keyCode < 48) || (event.keyCode > 57 && event.keyCode < 65) || (event.keyCode > 90 && event.keyCode < 97) || (window.event.keyCode>122)) event.returnValue = false;" style="font-family: Verdana;border: solid rgb(145,156,186) 1px;background-color: rgb(255,255,202)" tabindex=2 onFocus='whichField(this.name)' size="7%" maxlength="8" onkeyup="javascript:this.value=this.value.toUpperCase();">
            </td>
            <td height="18" width="68"> <font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_ville"]; ?>
              </b></font> </td>
            <td width="173"><input name="Exp_Ville" type="text" onKeypress="if ((event.keyCode > 32 && event.keyCode < 48) || (event.keyCode > 57 && event.keyCode < 65) || (event.keyCode > 90 && event.keyCode < 97) || (window.event.keyCode>122)) event.returnValue = false;" style="font-family: Verdana;border: solid rgb(145,156,186) 1px;background-color: rgb(255,255,202)" tabindex=3 onFocus='whichField(this.name)' size="20%" maxlength="30" onkeyup="javascript:this.value=this.value.toUpperCase();"></td>
            <td width="245" height="18" colspan="2"> <font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_pays"]?>&nbsp;&nbsp;
              </b></font>
              <select size="1" name="Exp_Pays" onFocus='whichField(this.name)' style='background-color: #FFCC99; width: 180px'>
                <?
            		$conn = mssql_connect("127.0.0.1", "sa", "anastasi20");

            		if (mssql_select_db("FRETONLINE")){
            			$reqpays = "Select Nom From Pays Order By Nom";

            			$respays = mssql_query($reqpays, $conn);

            			if ($respays){
                            do{
	              			while($rowpays=@mssql_fetch_row($respays)){
	              				if ($rowpays[0]=="FRANCE")$selit="Selected"; else $selit="";

            					echo "<option value=\"$rowpays[0]\" $selit>$rowpays[0]</option>\n";
                            }
	            			}while(@mssql_next_result($respays));

                            mssql_free_result($respays);
            		   	}
            		   	else{
            		   		echo "<option value=\"FRANCE\">FRANCE</option>\n";
            		   	}
  					}
  					mssql_close($conn);
  				?>
              </select>
              <!--<input name="Exp_Pays" type="text" style='background-color: #FFCC99;' tabindex=4 onFocus='whichField(this.name)' onChange="OuvrirPetitPopup('paysappelsimple.php?pays='+window.document.forms['Creation'].elements['Exp_Pays'].value+'&champs=Exp_Pays','ExpPays','width=400,height=460,menubar=no,status=no,scrollbars=yes,resizable=no');" size="39" maxlength="30">
              <a onClick=javascript:OuvrirPetitPopup('paysappelsimple.php?pays='+window.document.forms['Creation'].elements['Exp_Pays'].value+'&champs=Exp_Pays','ExpPays','width=400,height=460,menubar=no,status=no,scrollbars=yes,resizable=no'); onmouseover="window.status='Cliquez-ici pour sélectionner un pays de départ';return true;" onmouseout="window.status='';return true;"><img src="Find.gif" width=15 height=13 border=0></a>-->
            </td>
          </tr>
          <tr>
            <td><font color="#919CBB" face=arial size=2><b> <? echo $res_cre["res_destinataire"]; ?></b></font></td>
            <td height="5" width="151"> <font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_cp"]; ?>
              </b></font> <input name="Des_Cp" type="text" onKeypress="if ((event.keyCode > 32 && event.keyCode < 48) || (event.keyCode > 57 && event.keyCode < 65) || (event.keyCode > 90 && event.keyCode < 97) || (window.event.keyCode>122)) event.returnValue = false;" style="font-family: Verdana;border: solid rgb(145,156,186) 1px;background-color: rgb(255,255,202)" tabindex=5 onFocus='whichField(this.name)' size="7%" maxlength="8" onkeyup="javascript:this.value=this.value.toUpperCase();">
            </td>
            <td width="68" height="5"> <font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_ville"]; ?>
              </b></font></td>
            <td width="173" height="5"><input name="Des_Ville" type="text" onKeypress="if ((event.keyCode > 32 && event.keyCode < 48) || (event.keyCode > 57 && event.keyCode < 65) || (event.keyCode > 90 && event.keyCode < 97) || (window.event.keyCode>122)) event.returnValue = false;" style="font-family: Verdana;border: solid rgb(145,156,186) 1px;background-color: rgb(255,255,202)" tabindex=6 onFocus='whichField(this.name)' size="20%" maxlength="30" onkeyup="javascript:this.value=this.value.toUpperCase();"></td>
            <td height="5" colspan="2"> <font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_pays"]?>&nbsp;&nbsp;
              </b></font>
              <select size="1" name="Des_Pays" onFocus='whichField(this.name)' style='background-color: #FFCC99; width: 180px'>
                <?
            		$conn = mssql_connect("127.0.0.1", "sa", "anastasi20");

            		if (mssql_select_db("FRETONLINE")){
            			$reqpays = "Select Nom From Pays Order By Nom";

            			$respays = mssql_query($reqpays, $conn);

            			if ($respays){
                            do{
	              			while($rowpays=@mssql_fetch_row($respays)){
	              				if ($rowpays[0]=="FRANCE")$selit="Selected"; else $selit="";

            					echo "<option value=\"$rowpays[0]\" $selit>$rowpays[0]</option>\n";
                            }
	            			}while(@mssql_next_result($respays));

                            mssql_free_result($respays);
            		   	}
            		   	else{
            		   		echo "<option value=\"FRANCE\">FRANCE</option>\n";
            		   	}
  					}
  					mssql_close($conn);
  				?>
              </select>
              <!--<input name="Des_Pays" type="text" style='background-color: #FFCC99;' tabindex=7 onFocus='whichField(this.name)' onChange="OuvrirPetitPopup('paysappelsimple.php?pays='+window.document.forms['Creation'].elements['Des_Pays'].value+'&champs=Des_Pays','DesPays','width=400,height=460,menubar=no,status=no,scrollbars=yes,resizable=no');" size="39" maxlength="30">
              <a onClick=javascript:OuvrirPetitPopup('paysappelsimple.php?pays='+window.document.forms['Creation'].elements['Des_Pays'].value+'&champs=Des_Pays','DesPays','width=400,height=460,menubar=no,status=no,scrollbars=yes,resizable=no'); onmouseover="window.status='Cliquez-ici pour sélectionner un pays d\'arrivée';return true;" onmouseout="window.status='';return true;"><img src="Find.gif" width=15 height=13 border=0></a>-->
            </td>
          </tr>
        </table>
        <table width="780" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td background="images/rep_3.jpg" height="1"></td>
          </tr>
        </table>
        <table width="780" border="0" align="center" bgcolor="#E8E8E8">
          <tr>
            <td width="16%"><font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_quantite"]; ?></b></font></td>
            <td width="20%"> <input name="Qte" type="text" style="font-family: Verdana;border: solid rgb(145,156,186) 1px;background-color: rgb(255,255,202)" tabindex=8 onFocus='whichField(this.name)' onkeyup="javascript:this.value=this.value.toUpperCase();" onKeyPress="return numbersonly(this, event)" size="10%">
            </td>
            <td width="9%"><font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_poids"]; ?></b></font></td>
            <td width="23%"> <input type="text" size="10%" name="poids" style="font-family: Verdana;border: solid rgb(145,156,186) 1px" onFocus='whichField(this.name)' onkeyup="javascript:this.value=this.value.toUpperCase();" onKeyPress="return numbersonly(this, event)" tabindex=11>
            </td>
            <td width="6%"><font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_v_ref"]; ?></b></font></td>
            <td width="26%"> <input name="vref" type="text" onKeypress="if ((event.keyCode > 32 && event.keyCode < 48) || (event.keyCode > 57 && event.keyCode < 65) || (event.keyCode > 90 && event.keyCode < 97) || (window.event.keyCode>122)) event.returnValue = false;" style="font-family: Verdana;border: solid rgb(145,156,186) 1px" tabindex=14 onFocus='whichField(this.name)' size="23" maxlength="20" onkeyup="javascript:this.value=this.value.toUpperCase();">
            </td>
          </tr>
          <tr>
            <td><font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_emballage"]; ?></b></font></td>
            <td width="20%"> <select size="1" name="Emb" onFocus='whichField(this.name)' style='background-color: #FFCC99;  width: 135px'>
                <?
            $conn = mssql_connect("127.0.0.1", "sa", "anastasi20");

            if (mssql_select_db("FRETONLINE")){
                $reqembal = "Select Info From Infos Where Type='EMBAL' Order By Info";

                $resembal = mssql_query($reqembal, $conn);

                if ($resembal){
                    do{
                    while($rowembal=@mssql_fetch_row($resembal)){
                        if ($rowembal[0]=="COLIS")$selit="Selected"; else $selit="";

                        echo "<option value=\"$rowembal[0]\" $selit alt=\"$rowembal[0]\">$rowembal[0]</option>\n";
                    }
                    }while(@mssql_next_result($resembal));

                    mssql_free_result($resembal);
                }
                else{
                    echo "<option value=\"COLIS\">COLIS</option>\n";
                }
            }
            mssql_close($conn);
        ?>
              </select></td>
            <td><font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_volume"]; ?></b></font></td>
            <td width="23%"> <input type="text" name="volume" size="10%" style="font-family: Verdana;border: solid rgb(145,156,186) 1px" onFocus='whichField(this.name)' onkeyup="javascript:this.value=this.value.toUpperCase();" onKeyPress="return numbersonly(this, event)" tabindex=12>
            </td>
            <td width="6%"><font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_ref_agent"]; ?></b></font></td>
            <td width="26%"> <input name="refagent" type="text" onKeypress="if ((event.keyCode > 32 && event.keyCode < 48) || (event.keyCode > 57 && event.keyCode < 65) || (event.keyCode > 90 && event.keyCode < 97) || (window.event.keyCode>122)) event.returnValue = false;" style="font-family: Verdana;border: solid rgb(145,156,186) 1px" tabindex=15 onFocus='whichField(this.name)' size="23" maxlength="20" onkeyup="javascript:this.value=this.value.toUpperCase();">
            </td>
          </tr>
          <tr>
            <td><font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_nature"]?></b></font></td>
            <td width="20%"> <input name="NatureM" onKeypress="if ((event.keyCode > 32 && event.keyCode < 48) || (event.keyCode > 57 && event.keyCode < 65) || (event.keyCode > 90 && event.keyCode < 97) || (window.event.keyCode>122)) event.returnValue = false;" type="text" style="font-family: Verdana;border: solid rgb(145,156,186) 1px" tabindex=10 onFocus='whichField(this.name)' size="10%" maxlength="20" onkeyup="javascript:this.value=this.value.toUpperCase();">
            </td>
            <td><font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_m_lineaire"]; ?></b></font></td>
            <td width="23%"> <input type="text" name="lineaire" size="10%" style="font-family: Verdana;border: solid rgb(145,156,186) 1px" onFocus='whichField(this.name)' onkeyup="javascript:this.value=this.value.toUpperCase();"onKeyPress="return numbersonly(this, event)" tabindex=13>
            </td>
            <td width="6%"><font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_terme"]; ?></b></font></td>
            <td width="26%"> <select name="terme" onFocus='whichField(this.name)' style='background-color: rgb(255,255,202);' tabindex=16>
                <option>CFR</option>
                <option>CIF</option>
                <option>CIP</option>
                <option>CPT</option>
                <option>DAF</option>
                <option>DDP</option>
                <option>DDU</option>
                <option>DEQ</option>
                <option>DES</option>
                <option>EXW</option>
                <option>FAS</option>
                <option>FCA</option>
                <option>FOB</option>
                <option selected>PAY</option>
                <option>PDU</option>
              </select> </td>
          </tr>
        </table>
        <table width="780" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td background="images/rep_3.jpg" height="1"></td>
          </tr>
        </table>
        <table width="780" border="0" align="center" bgcolor="#E8E8E8">
          <tr>
            <td width="16%"> <font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_date_enl"]; ?></b></font></td>
            <td height="23" width="15%"> <input name="date_enl" type="text" style="font-family: Verdana;border: solid rgb(145,156,186) 1px;background-color: rgb(255,255,202)" tabindex=17 onFocus='whichField(this.name)' value='<? echo strftime("%d/%m/%Y", time()); ?>' size="10" maxlength="10">
            </td>
            <td width="5%"><a href="javascript:show_calendar('Creation.date_enl');" onmouseover="window.status='Cliquez-ici pour sélectionner une date d\'enlèvement';return true;" onmouseout="window.status='';return true;"><img src="show-calendar2.gif" width=16 height=15 border=0></a></td>
            <td width="9%"><font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_imperatif_enl"]; ?></b></font></td>
            <td height="23" width="55%"> <input name="imp_enl" type="text" onKeypress="if ((event.keyCode > 32 && event.keyCode < 48) || (event.keyCode > 57 && event.keyCode < 65) || (event.keyCode > 90 && event.keyCode < 97) || (window.event.keyCode>122)) event.returnValue = false;" style="font-family: Verdana;border: solid rgb(145,156,186) 1px" tabindex=18 onFocus='whichField(this.name)' size="55" maxlength="30" onkeyup="javascript:this.value=this.value.toUpperCase();">
            </td>
          </tr>
          <tr>
            <td><font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_date_liv"];?></b></font></td>
            <td width="15%"> <input name="date_liv" type="text" style="font-family: Verdana;border: solid rgb(145,156,186) 1px;background-color: rgb(255,255,202)" tabindex=19 onFocus='whichField(this.name)' size="10" maxlength="10">
            </td>
            <td width="5%"><a href="javascript:show_calendar('Creation.date_liv');" onmouseover="window.status='Cliquez-ici pour sélectionner une date de livraison';return true;" onmouseout="window.status='';return true;"><img src="show-calendar2.gif" width=16 height=15 border=0></a></td>
            <td width="9%"> <font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_imperatif_liv"]; ?></b></font></td>
            <td width="55%"> <input name="imp_liv" type="text" onKeypress="if ((event.keyCode > 32 && event.keyCode < 48) || (event.keyCode > 57 && event.keyCode < 65) || (event.keyCode > 90 && event.keyCode < 97) || (window.event.keyCode>122)) event.returnValue = false;" style="font-family: Verdana;border: solid rgb(145,156,186) 1px" tabindex=20 onFocus='whichField(this.name)' size="55" maxlength="30" onkeyup="javascript:this.value=this.value.toUpperCase();">
            </td>
          </tr>
        </table>
        <table width="780" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td background="images/rep_3.jpg" height="1"></td>
          </tr>
        </table>
        <table width="780" border="0" align="center" bgcolor="#E8E8E8">
          <tr>
            <td width="16%" height="26"><font color="#919CBB" face=arial size=2><b>
              <? echo $res_cre["res_valeur"]; ?></b></font></td>
            <td width="12%"> <input name="valeur_march" type="text" style="font-family: Verdana;border: solid rgb(145,156,186) 1px" tabindex=21 onFocus='whichField(this.name)' onkeyup="javascript:this.value=this.value.toUpperCase();" onKeyPress="return numbersonly(this, event)" size="10%">
            </td>
            <td width="34%"><font color="#919CBB" size="2" face="arial"><strong>EUR
              <input name="devise_march" type="hidden" tabindex=22 onFocus='whichField(this.name)' value="EUR">
              </strong></font></td>
            <td width="12%"><font color="#919CBB" face=arial size=2><b><? echo $res_cre["res_cod"]; ?></b>
              </font></td>
            <td width="26%"><font color="#919CBB" face=arial size=2>
              <select name="cod" onFocus='whichField(this.name)' tabindex=23>
                <option value="OUI"><? echo $res_cre["msg_oui"]; ?></option>
                <option value="NON" selected><? echo $res_cre["msg_non"]; ?></option>
              </select>
              </font> </td>
          </tr>
        </table>
        <table width="780" border="0" align="center" bgcolor="#E8E8E8">
          <tr>
            <td height="31" width="16%"><font color="#919CBB" face=arial size=2><b>
              <? echo $res_cre["res_observation"]; ?></b></font></td>
            <td height="31" width="84%"> <textarea name="obs" wrap="VIRTUAL" cols="89" rows="2" style="font-family: Verdana;border: solid rgb(145,156,186) 1px" onFocus='whichField(this.name)' onkeyup="javascript:this.value=this.value.toUpperCase();"></textarea>
            </td>
          </tr>
        </table>
        <table width="780" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td background="images/rep_3.jpg" height="1"></td>
          </tr>
        </table>
        <table width="780" border="0" align="center" background="images/sobes.jpg">
          <tr>
            <td height="10" width="50%"><b></b> <b><font color="#FFFFFF" face=arial size=2>
              <input type="hidden" name="CU" value='<? echo $_SESSION["CodeUser"]; ?>' readonly=Yes onFocus='whichField(this.name)' tabindex=2>
              <input type="hidden" name="NatureDos" size="20%" value='<? echo $NatureDos; ?>' readonly=Yes onFocus='whichField(this.name)' tabindex=5>
              <b><font size="1" face="Arial, Helvetica, sans-serif">
              <input type="hidden" name="TypeD" value="IMPORT" tabindex=4 onFocus='whichField(this.name)' style='background-color: rgb(255,255,202);'>
              </font><font color="#FFFFFF" face=arial size=2><b><font color="#919CBB" face=arial size=2><b><font color="#919CBB" face=arial size=2>
              <input type="hidden" name="AG" value='<? echo $_SESSION["agence"]; ?>' readonly=Yes onFocus='whichField(this.name)' tabindex=3>
              <input name="DC" type="hidden"  style="font-family: Verdana;border: solid rgb(1,179,192) 1px" tabindex=1 onFocus='whichField(this.name)' value='<? echo strftime("%d/%m/%Y", time()); ?>' size="14%" readonly=Yes >
              </font></b></font></b></font><font size="1" face="Arial, Helvetica, sans-serif">
              </font></b> </font></b> </td>
            <td height="2" width="10%">&nbsp;</td>
            <input type="hidden" name="service" value='STANDARD'>
            <td width="25%" height="2" bgcolor="#919CBA"> <input name="appel" type="checkbox" value="yes" checked>
              <font face='arial' size='2' color="#FFFFFF"><b>&nbsp;<? echo $res_cre["btn_appeloffre"]; ?></b></font>
            </td>
            <td height="2" width="11%"><a href="javascript:location.href='mainpage.php'"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif" size="2"><b><? echo $res_cre["btn_annuler"]; ?></b></font></a></td>
            <td height="2" width="13%"><a href="javascript:Valider(Creation);"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif" size="2"><b><? echo $res_cre["btn_valider"]; ?></b></font></a>&nbsp;</td>
          </tr>
        </table>

      </td>
      <td width="1" background="images/rep_3.jpg"></td>
    </tr>
    <tr>
      <td colspan="3" background="images/rep_3.jpg"></td>
    </tr>
  </table>
  <table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td height="25"><font color="#FF4848" size="2" face="Arial, Helvetica, sans-serif">
                </font></td>
    </tr>
    <tr>
      <td height="20"><font color="#787878" size="2" face="Arial, Helvetica, sans-serif">
                </font></td>
    </tr>
    <tr>
      <td height="20"><font color="#787878" size="2" face="Arial, Helvetica, sans-serif">
                </font></td>
    </tr>
    <tr>
      <td height="20"><font color="#787878" size="2" face="Arial, Helvetica, sans-serif">
                </font></td>
    </tr>
  </table>
</form>
</body>
</html>

<?
   unset($res_sav);
   unset($res_btns);
   unset($res_msg);
?>