Since I'm a PHP programmer mostly, I'll paste PHP code. This is from a project I (tried) to work on about a year ago. I actually worked on that function. That's the kind of code where if you miss a character somewhere, you'd spend half a day trying to find out why it's not working as expected. It did happen to me.
So check out this.... and it's actually followed by an even longer function that must be about 1000 lines long. But I don't want to spam the forum, and most of all I don't feel like spending 5 minutes looking for the end of the function block.
Feel free to share yours. I'm hoping others will come in with nightmarish code they came across.
//VERIFIE SI LES SAISIES SONT CORRECTES
function estValide($leLogin,$lePass,$lePnom,$leCodCri,$leNom,$lePrenom,$leTelPro,$leMobPro,$leFaxPro,$leMailPro,$leTelPer,$leMobPer,$leFaxPer,$leMailPer,$leKeySta,$leArboHO,$leSer,$leBur,$leDir,$leTypeAnn,$leMat,$leBadge,$leMatMng)
{
$alert = array();
$booleen=false;
//test doublon base
if( $leLogin != "" && VerifierAdresseMail($leLogin) ){
$acces_login = array();
if($_SESSION["choixId"]) {
$req_doublon = "SELECT login FROM annuaire where idAnnuaire!='".$_SESSION["choixId"]."' ";
}
else {
$req_doublon = "SELECT login FROM annuaire";
}
$res_doublon = mysql_query($req_doublon);
while($tab_doublon = mysql_fetch_array($res_doublon)) {
$acces_login[] = strtolower(Decrypte($tab_doublon["login"], KEY));
}
if( in_array(strtolower($leLogin), $acces_login) ) {
$alertloginM="\\n - This login already exist";
$doublon = 1 ;
}
}
if($leTypeAnn == '') {
$alertType = "\\n - Please imput type (internal/external)";
$erreurType = 1;
}
if($leMailPro != '') {
$req_doublon = "SELECT mail FROM annuaire where idAnnuaire!='".$_SESSION["choixId"]."' ";
$res_doublon = mysql_query($req_doublon);
while($tab_doublon = mysql_fetch_array($res_doublon)) {
$acces_login[] = Decrypte($tab_doublon["mail"],KEY);
}
if( in_array($leMailPro, $acces_login) ) {
$alertDoubleMail="\\n - This email already exist";
$doubleMail = 1 ;
}
}
if($leDir == '') {
$alertDir = "\\n - Please imput direction";
$erreurDir = 1;
}
if($lePnom == '') {
$alertPnom = "\\n -Please imput pnom";
$erreurPnom = 1;
}
if(($leTypeAnn == 1) && ($leMat == '')) {
$alertTypeInt = "\\n - Please input ID Number";
$erreurTypeInt = 1;
}
if($leTypeAnn == 1) {
$testMail = preg_match("/externe/i", "'$leMailPro'");
if($testMail != 0) {
$alertTypeInt2 = "\\n - Internal resource cannot have \"external\" in his e-mail";
$erreurTypeInt2 = 1;
}
$testLogin = preg_match("/externe/i", "'$leLogin'");
if($testLogin != 0) {
$alertTypeInt3 = "\\n - Internal resource cannot have \"external\" in his e-mail";
$erreurTypeInt3 = 1;
}
}
if($leTypeAnn == 2) {
if($leLogin != '') {
$testLogin = preg_match("/externe/i", "'$leLogin'");
if($testLogin == 0) {
$alertTypeLogin = "\\n - Internal Resource email has to be look like : (xx).interne@(xx).(xx)()";
$erreurTypeLogin = 1;
}
}
if($leMat != '') {
$alertExtMat = "\\n - External resource cannot have a ID. number";
$erreurExtMat = 1;
}
$testMail = preg_match("/externe/i", "'$leMailPro'");
if($testMail == 0) {
$alertTypeInt = "\\n - External Resource email has to be look like : (xx).externe@(xx).(xx)()";
$erreurTypeExt = 1;
}
}
if($leMatMng == '') {
$alertMatMng = "\\n - Please imput manager";
$erreurTypeMng = 1;
}
if ($doublon == 1 || $leLogin=="" ||
$lePass=="" ||
$leNom=="" ||
$lePnom=="" ||
$lePrenom=="" ||
$leTelPro=="" ||
$leMailPro=="" ||
$erreurType == 1 ||
$erreurDir == 1||
//$erreur2 == 1 ||
$erreurPnom == 1||
$erreurTypeInt == 1 ||
$erreurTypeExt == 1 ||
$erreurTypeLogin == 1 ||
$erreurTypeMng == 1 ||
$erreurExtMat == 1 ||
$erreurTypeInt2 == 1 ||
$erreurTypeInt3 == 1 ||
$doubleMail == 1 ||
(!VerifierAdresseMail($leLogin)) ||
(!VerifierAdresseMail($leLogin, true)) || // verifier extension
(!VerifierTelephone($leTelPro)) ||
(!VerifierAdresseMail($leMailPro)) ||
(!is_numeric($leKeySta)&&($leKeySta!="")) ||
(!is_numeric($leArboHO)&&($leArboHO!="")) ||
(!is_numeric($leMat)&&($leMat!="")) ||
(!is_numeric($leBadge)&&($leBadge!="")) ||
//(!is_numeric($leMatMng)&&($leMatMng!="")) ||
(!VerifierAdresseMail($leMailPer)&&($leMailPer!="")) ||
(!VerifierTelephone($leTelPer)&&($leTelPer!="")) ||
(!VerifierTelephone($leMobPro)&&($leMobPro!="")) ||
(!VerifierTelephone($leMobPer)&&($leMobPer!="")) ||
((VerifierMotDePasse($lePass) !== true )&&($lePass!="")) ||
(!VerifierTelephone($leFaxPer)&&($leFaxPer!="")) ||
(!VerifierTelephone($leFaxPro)&&($leFaxPro!=""))
) {
if($leLogin=="")$alertloginM="\\n - Please input User Name"; else {
if (!VerifierAdresseMail($leLogin))
$alertloginM="\\n - User Name should follow the form : ()@().()";
elseif (!VerifierAdresseMail($leLogin, true))
$alertloginM="\\n - Wrong Extension for User Name";
}
if($lePass=="")$alertpassM="\\n - Please input Password";
if($leNom=="")$alertnomM="\\n - Please input First Name";
if($lePrenom=="")$alertprenomM="\\n - Please input Last Name";
if($leTelPro=="")$alerttelproM="\\n - Please input Phone1 N°";else {if (!VerifierTelephone($leTelPro)) $alerttelproM="\\n - Phone1 N° is not valid.";}
if($leMailPro=="")$alertmailproM="\\n - Please input E-mail1";else {if (!VerifierAdresseMail($leMailPro)) $alertmailproM="\\n - Email1 is not valid.";}
if((!VerifierAdresseMail($leMailPer))&&($leMailPer!="")) $alertmailper="\\n - E-mail2 is not valid.";
if((($temp=VerifierMotDePasse($lePass))!==true)&&($lePass!="")) $alert=array_merge($alert, $temp);
if(!is_numeric($leKeySta)&&($leKeySta!="")) $alertkeysta="\\n - Top 50 must be a number.";
if(!is_numeric($leArboHO)&&($leArboHO!="")) $alertarbo="\\n - Tree Crisis must be a number.";
if(!is_numeric($leMat)&&($leMat!="")) $alertMat="\\n - ID Number is not valid.";
if(!is_numeric($leBadge)&&($leBadge!="")) $alertBadge="\\n - Badge Number is not valid.";
if((!VerifierTelephone($leTelPer))&&($leTelPer!="")) $alerttelper="\\n - phone2 is not valid.";
if((!VerifierTelephone($leMobPro))&&($leMobPro!="")) $alertmobpro="\\n - Cellular1 is not valid.";
if((!VerifierTelephone($leMobPer))&&($leMobPer!="")) $alertmobper="\\n - Cellular2 is not valid.";
if((!VerifierTelephone($leFaxPer))&&($leFaxPer!="")) $alertFaxper="\\n - Fax number is not valid.";
if((!VerifierTelephone($leFaxPro))&&($leFaxPro!="")) $alertfaxpro="\\n - Fax number is not valid.";
$_SESSION["message"] = "Wrong input: \\n".$alertloginM." ".$alertDoubleMail." ".$alertTypeLogin." ".$alertpassM." ".$alertPnom." ".$alertnomM." ".$alertprenomM." ".$alerttelproM." ".$alertmailproM." ".$alert2." ".$alertType." ".$alertExtMat." ".$alertTypeInt." ".$alertTypeInt2." ".$alertTypeInt3." ".$alertTypeExt." ".$alertMat." ".$alertBadge." ".$alertMatMng." ".$alertDir." ".$alertmailper." ".$alertkeysta." ".$alertarbo." ".$alerttelper." ".$alertmobpro." ".$alertmobper." ".$leFaxPer." ".$alertfaxpro;
if (count($alert) > 0) {
$_SESSION["message"] .= "\\n - ".implode("\\n - ", $alert);
}
/*
?>
<script> alert('<?php echo $mes; ?>') </script>
<?php */
}
else {
$booleen=true;
}//else
$_POST["passage"]=1;
$_POST["leLogin"]=$leLogin;
$_POST["lePass"]=$lePass;
if($_SESSION["codCri"]=='t'){$_POST["leCodCri"]=$leCodCri;}
if($_SESSION["nom"]=='t'){$_POST["leNom"]=$leNom;}
if($_SESSION["prenom"]=='t'){$_POST["lePrenom"]=$lePrenom;}
if($_SESSION["pnom"]=='t'){$_POST["lePnom"]=$lePnom;}
if($_SESSION["direction"]=='t'){$_POST["leDir"]=$leDir;}
if($_SESSION["service"]=='t'){$_POST["leSer"]=$leSer;}
if($_SESSION["bureau"]=='t'){$_POST["leBur"]=$leBur;}
if($_SESSION["telPro"]=='t'){$_POST["leTelPro"]=$leTelPro;}
if($_SESSION["mobPro"]=='t'){$_POST["leMobPro"]=$leMobPro;}
if($_SESSION["faxPro"]=='t'){$_POST["leFaxPro"]=$leFaxPro;}
if($_SESSION["mailPro"]=='t'){$_POST["leMailPro"]=$leMailPro;}
if($_SESSION["telPer"]=='t'){$_POST["leTelPer"]=$leTelPer;}
if($_SESSION["mobPer"]=='t'){$_POST["leMobPer"]=$leMobPer;}
if($_SESSION["faxPer"]=='t'){$_POST["leFaxPer"]=$leFaxPer;}
if($_SESSION["mailPer"]=='t'){$_POST["leMailPer"]=$leMailPer;}
if($_SESSION["keySta"]=='t'){$_POST["leKeySta"]=$leKeySta;}
if($_SESSION["arboHO"]=='t'){$_POST["learboHO"]=$learboHO;}
return $booleen;
}//function estValide
Oh well, that code may not look too bad, so I'll paste the next function anyway. And yes it took me 5 minutes to find the end of the function.
//AFFICHE TOUS LES CHAMPS DE LA RESSOURCE SELECTIONNE AVEC LES VALEURS DE LA BD ou du formulaire après une vérif
function afficherChampsPlein($selectionM,$test_passage)
{
set_time_limit(0);
$loginSaisi = $_POST["leLogin"];
$passSaisi = $_POST["lePass"];
$pnomSaisi = $_POST["lePnom"];
$nomSaisi = $_POST["leNom"];
$prenomSaisi = $_POST["lePrenom"];
$matSaisi = $_POST["leMat"];
$badgeSaisi = $_POST["leBadge"];
$matmngSaisi = $_POST["leMatMng"];
$batSaisi = $_POST["leBat"];
$etageSaisi = $_POST["leEtage"];
$bureauSaisi = $_POST["leBur"];
$bureauSaisi2 = $_POST["leBur2"];
$telProSaisi = $_POST["leTelPro"];
$mobProSaisi = $_POST["leMobPro"];
$faxProSaisi = $_POST["leFaxPro"];
$mailProSaisi = $_POST["leMailPro"];
$keyStaSaisi = $_POST["leKeySta"];
$arboHOSaisi = $_POST["leArboHO"];
$directionSaisi = $_POST["leDir"];
$serviceSaisi = $_POST["leSer"];
$siteSaisi = $_POST["leSite"];
$posteSaisi = $_POST["lePoste"];
//Récupération jointure annuaire pour pnom
$req = "SELECT * FROM annuaire";
$res = mysql_query($req);
$array_pnom = array();
while($tab = mysql_fetch_array($res)){
$pnom2 = Decrypte($tab[pnom],KEY);
$id = $tab[idAnnuaire];
$array_pnom[$pnom2] = $id;
}
echo '
<div>
<div style="float: left; margin-bottom: 5px; font-family: Arial; color: #000; font-size: 12px; font-weight: bold;">
<img src="images/b_edit.png"> Modify Resource</div>
<div style="display: block; float: right; width: 700px;">
<a href="#" onclick="document.form_etapeC.valider3.value=1; document.form_etapeC.submit();" class="bouton">Save</a>
<a href="param3.php?onglet=annuraire&Bmenu=param_annuraire_crise&lg=1" class="bouton">Return</a>
</div>
</div>';
echo '<TABLE BORDER="0" style="font-family:verdana; font-size:10px">';
if(!$_POST["passage"]){
$_POST["passage"]=1;
$keyPass = KEY;
$req4="SELECT a.*, AES_DECRYPT(a.nom, '$keyPass') as nom FROM annuaire a WHERE idAnnuaire='$selectionM'";
$res4=mysql_query($req4) or die (mysql_error());
while($tab4=mysql_fetch_array($res4)) {
//$leLogin=Decrypte($tab4["login"],KEY); echo '<tr><td align="left">Login:</td><td align="left"><input type="hidden" name="leLogin" value = "'.$leLogin.'"><input type="text" disabled="disabled" name="leLogin2" value="'.$leLogin.'" style="width: 200px">*</td></tr>';
//$lePass=Decrypte($tab4["mdp"],KEY); echo '<tr><td align="left">Password:</td><td align="left"><input type="hidden" name="lePass" value = "'.$lePass.'"><input type="text" disabled="disabled" name="lePass2" value="'.$lePass.'" style="width: 200px">*</td></tr>';
$leLogin=Decrypte($tab4["login"], KEY);
echo '
<tr class="ligneformulaire">
<td class="textformulaire">Login :</td>
<td align="left"><input type="text" class="champformulaire" name="leLogin" value="'.$leLogin.'" style="width: 200px">*</td>
</tr>';
$lePass=Decrypte($tab4["mdp"], KEY);
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Password : </td>
<td align="left"><input type="text" class="champformulaire" name="lePass" value="'.$lePass.'" style="width: 200px">*</td>
</tr>';
$lePnom = Decrypte($tab4["pnom"], KEY);
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Pnom : </td>
<td align="left"><input type="text" class="champformulaire" name="lePnom" value="'.$lePnom.'" style="width: 200px">*</td>
</tr>';
if($_SESSION["nom"]=='t') {
$leNom=$tab4["nom"];
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
First Name : </td>
<td align="left"><input type="text" class="champformulaire" name="leNom" value="'.$leNom.'" style="width: 200px">*</td>
</tr>';
}
if($_SESSION["prenom"]=='t') {
$lePrenom=ucfirst(strtolower($tab4['prenom']));
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Last Name : </td>
<td align="left"><input type="text" class="champformulaire" name="lePrenom" value="'.$lePrenom.'" style="width: 200px">*</td>
</tr>';
}
//type annuaire (interne ou externe)
$requete = "SELECT * FROM annuaire_typeannuaire WHERE idAnnuaire = '$selectionM' AND Date_fin='0000-00-00'";
$resultat = mysql_query($requete) or die (mysql_error());
while($ligne_test = mysql_fetch_array($resultat)){$test = $ligne_test[idAnnuaire];}
if($test == $selectionM) {
$requete2 = "SELECT * FROM annuaire_typeannuaire WHERE idAnnuaire = '$selectionM' AND Date_fin='0000-00-00' ";
$resultat2 = mysql_query($requete2) or die (mysql_error());
while($ligne_typeann = mysql_fetch_array($resultat2)){
$req_typeann = "select idType_Ann as id, TypeAnn_Lib as typeann_libelle from typeannuaire";
$res_typeann = mysql_query($req_typeann);
while($tab_typeann = mysql_fetch_array($res_typeann)) {
$id_typeann = $tab_typeann["id"];
$array_typeann[$id_typeann] = $tab_typeann["typeann_libelle"];
}
if($_SESSION["typeannuaire"]=='t'){
if($_POST["leTypeAnn"]=='') $leTypeAnn = $ligne_typeann["idType_Ann"]; else $leTypeAnn=$_POST["leTypeAnn"];
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Type : </td>
<td align="left">';
echo "
<select name=\"leTypeAnn\"\">";
echo "
<option></option>";
foreach($array_typeann as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $leTypeAnn) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'*</td>
</tr>';
}
}
}
else{
$req_typeann = "select idType_Ann as id, TypeAnn_Lib as typeann_libelle from typeannuaire";
$res_typeann = mysql_query($req_typeann);
while($tab_typeann = mysql_fetch_array($res_typeann)) {
$id_typeann = $tab_typeann["id"];
$array_typeann[$id_typeann] = $tab_typeann["typeann_libelle"];
}
if($_SESSION["typeannuaire"]=='t'){
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Type : </td>
<td align="left">';
echo "
<select name=\"leTypeAnn\"\">";
echo "
<option></option>";
foreach($array_typeann as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $typeannSaisi) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'*</td>
</tr>';
}
}
if($_SESSION["matricule"]=='t') {
$req = "SELECT * FROM annuaire_typeannuaire WHERE idAnnuaire = '$selectionM' AND Date_fin='0000-00-00'";
$res = mysql_query($req) or die (mysql_error());
while($ligne = mysql_fetch_array($res)) { $leMat = $ligne[matricule];}
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
ID Number* : </td>
<td align="left"> <input type="text" class="champformulaire" name="leMat"value="'.$leMat.'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["numbadge"]=='t') {
$req = "SELECT * FROM annuaire_typeannuaire WHERE idAnnuaire = '$selectionM' AND Date_fin='0000-00-00'";
$res = mysql_query($req) or die (mysql_error());
while($ligne = mysql_fetch_array($res)) { $leBadge = $ligne[num_badge];}
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Badge Number : </td>
<td align="left"> <input type="text" class="champformulaire" name="leBadge"value="'.$leBadge.'" style="width: 120px"></td>
</tr>';
}
/*if($_SESSION["matmng"]=='t') {
$req = "SELECT * FROM annuaire_typeannuaire WHERE idAnnuaire = '$selectionM'";
$res = mysql_query($req) or die (mysql_error());
while($ligne = mysql_fetch_array($res)) { $leMatMng = $ligne[matricule_mng];}*/
$requete = "SELECT * FROM annuaire_typeannuaire WHERE idAnnuaire = '$selectionM' AND Date_Fin = '0000-00-00'";
$resultat = mysql_query($requete) or die (mysql_error());
while($ligne_test = mysql_fetch_array($resultat)){$test = $ligne_test[idAnnuaire];}
if($test == $selectionM) {
$requete = "SELECT * FROM annuaire_typeannuaire WHERE idAnnuaire = '$selectionM' AND Date_Fin = '0000-00-00'";
$resultat = mysql_query($requete) or die (mysql_error());
while($ligne = mysql_fetch_array($resultat)) {
$array_manager = array();
$req_typeann = "select distinct matricule_mng as pnom from annuaire_typeannuaire";
$res_typeann = mysql_query($req_typeann);
while($tab_typeann = mysql_fetch_array($res_typeann)) {
$idMan = $tab_typeann["pnom"];
$req = "SELECT * FROM annuaire WHERE idAnnuaire = '$idMan'";
$res = mysql_query($req) or die (mysql_error());
while($tab_typeann2 = mysql_fetch_array($res)) {
$id_typeann = $idMan;
$array_manager[$id_typeann] = strtoupper(Decrypte($tab_typeann2["pnom"],KEY));
}
}
sort($array_manager);
//array_multisort($array_manager, SORT_ASC);
if($_SESSION["matmng"]=='t'){
if($_POST["leMatMng"]=='') {
$leMatMng = $ligne["matricule_mng"];
$req2 = "SELECT * FROM annuaire WHERE idAnnuaire = '$leMatMng'";
$res2 = mysql_query($req2) or die (mysql_error());
while($tab2 = mysql_fetch_array($res2)) {$leMatMng = strtoupper(Decrypte($tab2["pnom"],KEY));}
}
else{ $leMatMng=$_POST["leMatMng"];}
//if($_POST["leMatMng"] != "") $leMatMng = $_POST["leMatMng"];
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Manager : </td>
<td align="left">';
echo "
<select id=\"leMatMng\" name=\"leMatMng\"\">";
echo "
<option></option>";
foreach($array_manager as $key=>$value) {
echo "
<option value=\"".$value."\" ";
if ($value == $leMatMng) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'*</td>
</tr>';
}
}
}
else{
$array_manager = array();
$req_typeann = "select distinct matricule_mng as pnom from annuaire_typeannuaire";
$res_typeann = mysql_query($req_typeann);
while($tab_typeann = mysql_fetch_array($res_typeann)) {
$idMan = $tab_typeann["pnom"];
$req = "SELECT * FROM annuaire WHERE idAnnuaire = '$idMan'";
$res = mysql_query($req) or die (mysql_error());
while($tab_typeann2 = mysql_fetch_array($res)) {
$id_typeann = $idMan;
$array_manager[$id_typeann] = strtoupper(Decrypte($tab_typeann2["pnom"],KEY));
}
}
sort($array_manager);
//array_multisort($array_manager, SORT_ASC);
if($_SESSION["matmng"]=='t'){
if($_POST["leMatMng"]=='') {
$leMatMng = $ligne["matricule_mng"];
$req2 = "SELECT * FROM annuaire WHERE idAnnuaire = '$leMatMng'";
$res2 = mysql_query($req2) or die (mysql_error());
while($tab2 = mysql_fetch_array($res2)) {$leMatMng = strtoupper(Decrypte($tab2["pnom"],KEY));}
}
else{ $leMatMng=$_POST["leMatMng"];}
//if($_POST["leMatMng"] != "") $leMatMng = $_POST["leMatMng"];
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Manager : </td>
<td align="left">';
echo "
<select id=\"leMatMng\" name=\"leMatMng\"\">";
echo "
<option></option>";
foreach($array_manager as $key=>$value) {
echo "
<option value=\"".$value."\" ";
if ($value == $leMatMng) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'*</td>
</tr>';
}
}
/*$lePnomMan = '';
$lePnomMan = array_search($leMatMng, $array_pnom);
echo '<tr><td align="left">Manager:</td><td align="left"> <input type="text" name="leMatMng"value="'.$lePnomMan.'" style="width: 120px">*</td></tr>';}*/
//direction
//--> liste direction dans la base
$requete = "SELECT * FROM annuaire_organisation WHERE idAnnuaire = '$selectionM' AND idOrga in
(SELECT idOrga FROM organisation WHERE idTypeOrga = '1') AND Date_Fin = '0000-00-00' ";
$resultat = mysql_query($requete) or die (mysql_error());
$test = mysql_num_rows($resultat);
if($test >= 1) {
while($ligne_direction = mysql_fetch_array($resultat)){
$req = "select idOrga as id, Orga_Lib as dir_libelle from organisation where idTypeOrga = '1'
AND Affecte = 't' order by Orga_Lib ";
$res = mysql_query($req) or die (mysql_error());
while($tab_dir = mysql_fetch_array($res)) {
$id_direct = $tab_dir["id"];
$array_direction[$id_direct] = $tab_dir["dir_libelle"];
}
if($_SESSION["direction"]=='t'){
if($_POST["leDir"]=='') $leDir=$ligne_direction["idOrga"]; else $leDir=$_POST["leDir"];
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Direction : </td>
<td align="left">';
//affichage directions principales
echo "
<select name=\"leDir\" onChange=\"choixDirection('leDir','leSer')\">";
echo "
<option></option>";
foreach($array_direction as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $leDir) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'*</td>
</tr>';
}
//service
$requete2 = "SELECT * FROM annuaire_organisation WHERE idAnnuaire = '$selectionM' AND idOrga in
(SELECT idOrga FROM organisation WHERE idTypeOrga = '2') AND Date_Fin = '0000-00-00' ";
$resultat2 = mysql_query($requete2) or die (mysql_error());
$test = mysql_num_rows($resultat2);
if($test >= 1) {
$requete2 = "SELECT * FROM annuaire_organisation WHERE idAnnuaire = '$selectionM' AND idOrga in
(SELECT idOrga FROM organisation WHERE idTypeOrga = '2') AND Date_Fin = '0000-00-00'";
$resultat2 = mysql_query($requete2) or die (mysql_error());
while($ligne2 = mysql_fetch_array($resultat2)) {
if($_SESSION["service"]=='t'){
if($_POST["leSer"]=='') $leSer=$ligne2["idOrga"]; else $leSer=$_POST["leSer"];
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Department : </td>
<td align="left">';
echo"
<div id=\"div_leSer\">";
if($_POST["leDir"]=='') $leDir = $ligne_direction["idOrga"]; else $leDir=$_POST["leDir"];
if($leDir){
$req_ser = "SELECT idOrga as id, Orga_Lib as ser_libelle
FROM organisation
WHERE idTypeOrga = '2'
AND Orga_Date_Fin = '0000-00-00'
AND idOrgaPere = '$leDir'
AND Affecte = 't'
order by Orga_Lib ASC";
echo "
<select id=\leSer\" name=\"leSer\" size=\"1\" ><option></option>";
//liste complètes des services de la direction
$req_ser = "SELECT idOrga as id, Orga_Lib as ser_libelle
FROM organisation
WHERE idTypeOrga = '2'
AND Orga_Date_Fin = '0000-00-00'
AND idOrgaPere = '$leDir'
AND Affecte = 't'
order by Orga_Lib ASC";
$res_ser = mysql_query($req_ser);
$liste_service = array();
if(mysql_num_rows($res_ser)){
while($tab_ser=mysql_fetch_array($res_ser)) {
$id_serv = $tab_ser["id"];
$lib = $tab_ser["ser_libelle"];
echo "
<option value=\"".$id_serv."\" ";
if($id_serv==$leSer) echo " selected";
echo ">".htmlentities($lib)."</option>";
}
}
echo "
</select>";
}
else echo "--- Choose one direction ---";
echo "
</div>";
echo'</td>
</tr>';
}
}
}
else{
//service
if($_SESSION["service"]=='t'){
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Department : </td>
<td align="left">';
echo"
<div id=\"div_leSer\">";
$leSer = $_POST["leSer"];
if($_POST["leDir"]=='') $leDir = $ligne_direction["idOrga"]; else $leDir=$_POST["leDir"];
if($leDir){
echo "
<select id=\leSer\" name=\"leSer\" size=\"1\" >
<option></option>";
//liste complètes des services de la direction
$req_ser = "SELECT `idOrga` as id, `Orga_Lib` as ser_libelle FROM `organisation` WHERE `idTypeOrga` = '2' AND `idOrgaPere` = '$leDir'
AND `Affecte` = 't' AND `Orga_Date_Fin` = '0000-00-00' order by Orga_Lib ASC";
$res_ser = mysql_query($req_ser);
$liste_service = array();
if(mysql_num_rows($res_ser)){
while($tab_ser=mysql_fetch_array($res_ser)) {
$id_serv = $tab_ser["id"];
$lib = $tab_ser["ser_libelle"];
echo "
<option value=\"".$id_serv."\" ";
if($id_serv==$leSer) echo " selected";
echo ">".htmlentities($lib)."</option>";
}
}
echo "
</select>";
}
else echo "--- Choose one direction ---";
echo "
</div>";
echo'</td>
</tr>';
}
}
}//while
}
else{
//direction
//--> liste direction dans la base
$req_dir = "select idOrga as id, Orga_Lib as dir_libelle from organisation where idTypeOrga = '1'
AND Affecte = 't' order by Orga_Lib";
$res_dir = mysql_query($req_dir);
while($tab_dir = mysql_fetch_array($res_dir)) {
$id_direct = $tab_dir["id"];
$array_direction[$id_direct] = $tab_dir["dir_libelle"];
}
if($_SESSION["direction"]=='t'){
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Direction : </td>
<td align="left">';
//affichage directions principales
echo "
<select name=\"leDir\" onChange=\"choixDirection('leDir','leSer')\">";
echo "
<option></option>";
foreach($array_direction as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $directionSaisi) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'*</td>
</tr>';
}
//service
if($_SESSION["service"]=='t'){
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Department : </td>
<td align="left">';
echo"
<div id=\"div_leSer\">";
$leSer = $_POST["leSer"];
$leDir = $_POST["leDir"];
if($leDir){
echo "
<select id=\leSer\" name=\"leSer\" size=\"1\" >
<option></option>";
//liste complètes des services de la direction
echo $req_ser = "SELECT * FROM organisation WHERE idTypeOrga = '2' AND idOrgaPere = '$idDir'
AND Affecte = 't' AND Orga_Date_Fin = '0000-00-00' order by Orga_Lib ASC";
$res_ser = mysql_query($req_ser);
$liste_service = array();
if(mysql_num_rows($res_ser)){
while($tab_ser=mysql_fetch_array($res_ser)) {
$id_serv = $tab_ser["id"];
$liste_service[$id_serv] = $tab_ser["ser_libelle"];
}
}
foreach($liste_service as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if($key==$leSer) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
}
else echo "--- Choose one direction ---";
echo "
</div>";
echo'</td>
</tr>';
}
}
//Affiche la zone de Poste
$requete = "SELECT * FROM annuaire_fonction_orga WHERE idAnnuaire = '$selectionM' AND Date_Fin = '0000-00-00'";
$resultat = mysql_query($requete) or die (mysql_error());
$test = mysql_num_rows($resultat);
if($test >= 1) {
while($ligne_poste = mysql_fetch_array($resultat)){
$req_poste = "select idFonction as id, Fonction_Lib as fonction_libelle from fonction WHERE Affecte = 't'
order by Fonction_Lib ASC";
$res_poste = mysql_query($req_poste);
while($tab_poste = mysql_fetch_array($res_poste)) {
$id_poste = $tab_poste["id"];
$array_poste[$id_poste] = $tab_poste["fonction_libelle"];
}
if($_SESSION["fonction"]=='t'){
if($_POST["lePoste"]=='') $lePoste=$ligne_poste["idFonction"]; else $lePoste = $_POST["lePoste"];
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Fonction : </td>
<td align="left">';
echo "
<select name=\"lePoste\"\">";
echo "
<option></option>";
foreach($array_poste as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $lePoste) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'</td>
</tr>';
}
}
}
else{
$req_poste = "select idFonction as id, Fonction_Lib as fonction_libelle from fonction WHERE Affecte = 't'
order by Fonction_Lib ASC";
$res_poste = mysql_query($req_poste);
while($tab_poste = mysql_fetch_array($res_poste)) {
$id_poste = $tab_poste["id"];
$array_poste[$id_poste] = $tab_poste["fonction_libelle"];
}
if($_SESSION["fonction"]=='t'){
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Fonction : </td>
<td align="left">';
echo "
<select name=\"lePoste\"\">";
echo "
<option></option>";
foreach($array_poste as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $posteSaisi) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'</td>
</tr>';
}
}
//Affiche la zone de Site
$requete = "SELECT * FROM annuaire_site_orga WHERE idAnnuaire = '$selectionM' AND Date_Fin = '0000-00-00'";
$resultat = mysql_query($requete) or die (mysql_error());
$test = mysql_num_rows($resultat);
if($test >=1 ) {
while($ligne_site = mysql_fetch_array($resultat)){
$req_site = "select idSite as id, Site_Lib as site_libelle from site WHERE Affecte = 't'
order by Site_Lib ASC";
$res_site = mysql_query($req_site);
while($tab_site = mysql_fetch_array($res_site)) {
$id_site = $tab_site["id"];
$array_site[$id_site] = $tab_site["site_libelle"];
}
if($_SESSION["site"]=='t'){
if($_POST["leSite"]=='') $leSite=$ligne_site["idSite"]; else $leSite = $_POST["leSite"];
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Site : </td>
<td align="left">';
echo "
<select name=\"leSite\"\">";
echo "
<option></option>";
foreach($array_site as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $leSite) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'</td>
</tr>';
}
}
}
else{
$req_site = "select idSite as id, Site_Lib as site_libelle from site WHERE Affecte = 't'
order by Site_Lib ASC";
$res_site = mysql_query($req_site);
while($tab_site = mysql_fetch_array($res_site)) {
$id_site = $tab_site["id"];
$array_site[$id_site] = $tab_site["site_libelle"];
}
if($_SESSION["site"]=='t'){
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Site : </td>
<td align="left">';
echo "
<select name=\"leSite\"\">";
echo "
<option></option>";
foreach($array_site as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $siteSaisi) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'</td>
</tr>';
}
}
if($_SESSION["batiment"]=='t') {
$req = "SELECT * FROM annuaire_site_orga WHERE idAnnuaire = '$selectionM'";
$res = mysql_query($req) or die (mysql_error());
while($ligne = mysql_fetch_array($res)) {$leBat = $ligne[Batiment];}
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Building : </td>
<td align="left"><input type="text" class="champformulaire" name="leBat" value="'.$leBat.'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["etage"]=='t') {
$req = "SELECT * FROM annuaire_site_orga WHERE idAnnuaire = '$selectionM'";
$res = mysql_query($req) or die (mysql_error());
while($ligne = mysql_fetch_array($res)) {$leEtage = $ligne[Etage];}
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Floor : </td>
<td align="left"><input type="text" class="champformulaire" name="leEtage" value="'.$leEtage.'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["bureau"]=='t') {
$req = "SELECT * FROM annuaire_site_orga WHERE idAnnuaire = '$selectionM'";
$res = mysql_query($req) or die (mysql_error());
while($ligne = mysql_fetch_array($res)) {$leBur = $ligne[Bur_Dia];}
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Office :</td>
<td align="left"><input type="text" class="champformulaire" name="leBur" value="'.$leBur.'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["bureau2"]=='t') {
$req = "SELECT * FROM annuaire_site_orga WHERE idAnnuaire = '$selectionM'";
$res = mysql_query($req) or die (mysql_error());
while($ligne = mysql_fetch_array($res)) {$leBur2 = $ligne[Bur_Intranet];}
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Bureau(Intranet) : </td>
<td align="left"><input type="text" class="champformulaire" name="leBur2" value="'.$leBur2.'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["telPro"]=='t') {
$req = "SELECT * FROM annuaire_typeannuaire WHERE idAnnuaire = '$selectionM' AND Date_fin='0000-00-00'";
$res = mysql_query($req) or die (mysql_error());
while($ligne = mysql_fetch_array($res)) {$leTelPro = Decrypte($ligne[tel_fixe],KEY);}
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Phone1 N° : </td>
<td align="left"><input type="text" class="champformulaire" name="leTelPro" value="'.$leTelPro.'" style="width: 120px">*</td>
</tr>';
}
if($_SESSION["mobPro"]=='t') {
$req = "SELECT * FROM annuaire_typeannuaire WHERE idAnnuaire = '$selectionM' AND Date_fin='0000-00-00'";
$res = mysql_query($req) or die (mysql_error());
while($ligne = mysql_fetch_array($res)) {$leMobPro = Decrypte($ligne[tel_mobile],KEY);}
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Cellular1 N° : </td>
<td align="left"><input type="text" class="champformulaire" name="leMobPro" value="'.$leMobPro.'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["mailPro"]=='t'){
$leMailPro=Decrypte($tab4["mail"],KEY);
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
E-mail1 : </td>
<td align="left"><input type="text" class="champformulaire" name="leMailPro" value="'.$leMailPro.'" style="width: 200px" >*</td>
</tr>';
}
if($_SESSION["faxPro"]=='t'){
$req = "SELECT * FROM annuaire_typeannuaire WHERE idAnnuaire ='$selectionM' AND Date_fin='0000-00-00'";
$res = mysql_query($req) or die (mysql_error());
while($ligne = mysql_fetch_array($res)) {$leFaxPro = Decrypte($ligne['fax'],KEY);}
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Fax1 N° : </td>
<td align="left"><input type="text" class="champformulaire" name="leFaxPro" value="'.$leFaxPro.'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["keySta"]=='t') {
$req = "SELECT * FROM annuaire_typeannuaire WHERE idAnnuaire ='$selectionM' AND Date_fin='0000-00-00'";
$res = mysql_query($req) or die (mysql_error());
while($ligne = mysql_fetch_array($res)) {$leKeySta = $ligne[top50];}
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Top Manager : </td>
<td align="left"><input type="text" class="champformulaire" name="leKeySta" value="'.$leKeySta.'" style="width: 20px" maxlength="2"></td>
</tr>';
}
if($_SESSION["arboHO"]=='t') {
$req = "SELECT * FROM annuaire_typeannuaire WHERE idAnnuaire = '$selectionM' AND Date_fin='0000-00-00'";
$res = mysql_query($req) or die (mysql_error());
while($ligne = mysql_fetch_array($res)) {$leArboHO = $ligne[arboHO];}
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Tree Crisis : </td>
<td align="left"><input type="text" class="champformulaire" name="leArboHO" value="'.$leArboHO.'" style="width: 20px" maxlength="2"></td>
</tr>';
}
$activité=$tab4["TypRes_Iden"];
if($activité=='ACT') {$estActif=1;} else {$estActif=0;}
}//while
}//fin if not passsage
else{
$requete = "SELECT * FROM annuaire WHERE idAnnuaire = '$selectionM'";
$resultat = mysql_query($requete) or die (mysql_error());
while($tab4 = mysql_fetch_array($resultat)) {
//$leLogin=Decrypte($tab4["login"],KEY); echo '<tr><td align="left">Login:</td><td align="left"><input type="hidden" name="leLogin" value = "'.$leLogin.'"><input type="text" disabled="disabled" name="leLogin2" value="'.$leLogin.'" style="width: 200px">*</td></tr>';
//$lePass=Decrypte($tab4["mdp"],KEY); echo '<tr><td align="left">Password:</td><td align="left"><input type="hidden" name="lePass" value = "'.$lePass.'"><input type="text" disabled="disabled" name="lePass2" value="'.$lePass.'" style="width: 200px">*</td></tr>';
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Login : </td>
<td align="left"><input type="text" class="champformulaire" name="leLogin" value = "'.$_POST["leLogin"].'" style="width: 200px">*</td>
</tr>';
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Password : </td>
<td align="left"><input type="text" class="champformulaire" name="lePass" value="'.$_POST["lePass"].'" style="width: 200px">*</td>
</tr>';
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Pnom : </td>
<td align="left"><input type="text" class="champformulaire" name="lePnom" value="'.$_POST["lePnom"].'" style="width: 200px">*</td>
</tr>';
}//while
if($_SESSION["codCri"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Crisis Code : </td>
<td align="left"><input type="text" class="champformulaire" name="leCodCri" value="'.$_POST["leCodCri"].'" style="width: 200px"></td>
</tr>';
}
if($_SESSION["nom"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
First Name : </td>
<td align="left"><input type="text" class="champformulaire" name="leNom" value="'.$_POST["leNom"].'" style="width: 200px">*</td>
</tr>';
}
if($_SESSION["prenom"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Last Name : </td>
<td align="left"><input type="text" class="champformulaire" name="lePrenom" value="'.$_POST["lePrenom"].'" style="width: 200px">*</td>
</tr>';
}
$req_typeann = "select idType_Ann as id, TypeAnn_Lib as typeann_libelle from typeannuaire";
$res_typeann = mysql_query($req_typeann);
while($tab_typeann = mysql_fetch_array($res_typeann)) {
$id_typeann = $tab_typeann["id"];
$array_typeann[$id_typeann] = $tab_typeann["typeann_libelle"];
}
if($_SESSION["typeannuaire"]=='t'){
if($_POST["leTypeAnn"]=='') $leTypeAnn = $ligne_typeann["idType_Ann"]; else $leTypeAnn=$_POST["leTypeAnn"];
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Type : </td>
<td align="left">';
echo "
<select name=\"leTypeAnn\"\">";
echo " <option></option>";
foreach($array_typeann as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $leTypeAnn) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'*</td>
</tr>';
}
if($_SESSION["matricule"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
ID Number* : </td>
<td align="left"><input type="text" class="champformulaire" name="leMat"value="'.$_POST["leMat"].'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["numbadge"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Badge Number : </td>
<td align="left"> <input type="text" class="champformulaire" name="leBadge"value="'.$_POST["leBadge"].'" style="width: 120px"></td>
</tr>';
}
//if($_SESSION["matmng"]=='t') { echo '<tr><td align="left">Manager:</td><td align="left"> <input type="text" name="leMatMng"value="'.$_POST["leMatMng"].'" style="width: 120px">*</td></tr>';}
$requete = "SELECT * FROM annuaire_typeannuaire WHERE idAnnuaire = '$selectionM' AND Date_Fin = '0000-00-00'";
$resultat = mysql_query($requete) or die (mysql_error());
while($ligne = mysql_fetch_array($resultat)) {
$array_manager = array();
$req_typeann = "select distinct matricule_mng as pnom from annuaire_typeannuaire";
$res_typeann = mysql_query($req_typeann);
while($tab_typeann = mysql_fetch_array($res_typeann)) {
$idMan = $tab_typeann["pnom"];
$req = "SELECT * FROM annuaire WHERE idAnnuaire = '$idMan'";
$res = mysql_query($req) or die (mysql_error());
while($tab_typeann2 = mysql_fetch_array($res)) {
$id_typeann = $idMan;
$array_manager[$id_typeann] = strtoupper(Decrypte($tab_typeann2["pnom"],KEY));
}
}
sort($array_manager);
//array_multisort($array_manager, SORT_ASC);
if($_SESSION["matmng"]=='t'){
if($_POST["leMatMng"]=='') {
$leMatMng = $ligne["matricule_mng"];
$req2 = "SELECT * FROM annuaire WHERE idAnnuaire = '$leMatMng'";
$res2 = mysql_query($req2) or die (mysql_error());
while($tab2 = mysql_fetch_array($res2)) {$leMatMng = strtoupper(Decrypte($tab2["pnom"],KEY));}
}
else{ $leMatMng=$_POST["leMatMng"];}
//if($_POST["leMatMng"] != "") $leMatMng = $_POST["leMatMng"];
if($test_passage == 1) {
if($_POST["leMatMng"]!='') $leMatMng=$_POST["leMatMng"]; else $leMatMng = "";
}
else{
if($_POST["leMatMng"]=='') $leMatMng=strtoupper(Decrypte($tab2["pnom"],KEY)); else $leMatMng=$_POST["leMatMng"];
}
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Manager : </td>
<td align="left">';
echo "
<select id=\"leMatMng\" name=\"leMatMng\"\">";
echo "
<option></option>";
foreach($array_manager as $key=>$value) {
echo "<option value=\"".$value."\" ";
if ($value == $leMatMng) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'*</td>
</tr>';
}
}
//direction
//--> liste direction dans la base
$requete = "SELECT * FROM annuaire_organisation WHERE idAnnuaire = '$selectionM' AND idOrga in
(SELECT idOrga FROM organisation WHERE idTypeOrga = '1') AND Date_Fin = '0000-00-00' ";
$resultat = mysql_query($requete) or die (mysql_error());
$test = mysql_num_rows($resultat);
if($test >= 1) {
while($ligne_direction = mysql_fetch_array($resultat)){
$req = "select idOrga as id, Orga_Lib as dir_libelle from organisation where idTypeOrga = '1'
AND Affecte = 't' order by Orga_Lib";
$res = mysql_query($req) or die (mysql_error());
while($tab_dir = mysql_fetch_array($res)) {
$id_direct = $tab_dir["id"];
$array_direction[$id_direct] = $tab_dir["dir_libelle"];
}
if($_SESSION["direction"]=='t'){
if($test_passage == 1) {
if($_POST["leDir"]!='') $leDir=$_POST["leDir"]; else $leDir = "";
}
else{
if($_POST["leDir"]=='') $leDir=$ligne_direction["idOrga"]; else $leDir=$_POST["leDir"];
}
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Direction : </td>
<td align="left">';
//affichage directions principales
echo "
<select name=\"leDir\" onChange=\"choixDirection('leDir','leSer')\">";
echo "
<option></option>";
foreach($array_direction as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $leDir) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'*</td>
</tr>';
}
//service
$requete2 = "SELECT * FROM annuaire_organisation WHERE idAnnuaire = '$selectionM' AND idOrga in
(SELECT idOrga FROM organisation WHERE idTypeOrga = '2') AND Date_Fin = '0000-00-00' ";
$resultat2 = mysql_query($requete2) or die (mysql_error());
$test = mysql_num_rows($resultat2);
if($test >= 1) {
$requete2 = "SELECT * FROM annuaire_organisation WHERE idAnnuaire = '$selectionM' AND idOrga in
(SELECT idOrga FROM organisation WHERE idTypeOrga = '2') AND Date_Fin = '0000-00-00'";
$resultat2 = mysql_query($requete2) or die (mysql_error());
while($ligne2 = mysql_fetch_array($resultat2)) {
if($_SESSION["service"]=='t'){
if($_POST["leSer"]=='') $leSer=$ligne2["idOrga"]; else $leSer=$_POST["leSer"];
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Department : </td>
<td align="left">';
echo"
<div id=\"div_leSer\">";
if($_POST["leDir"]=='') $leDir = $ligne_direction["idOrga"]; else $leDir=$_POST["leDir"];
if($leDir){
echo "
<select id=\leSer\" name=\"leSer\" size=\"1\" ><option></option>";
//liste complètes des services de la direction
$req_ser = "SELECT idOrga as id, Orga_Lib as ser_libelle FROM organisation WHERE idTypeOrga = '2' AND idOrgaPere = '$leDir' AND Orga_Date_Fin = '0000-00-00'
AND Affecte = 't' order by Orga_Lib ASC";
$res_ser = mysql_query($req_ser);
$liste_service = array();
if(mysql_num_rows($res_ser)){
while($tab_ser=mysql_fetch_array($res_ser)) {
$id_serv = $tab_ser["id"];
$liste_service[$id_serv] = $tab_ser["ser_libelle"];
}
}
foreach($liste_service as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if($key==$leSer) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
}else echo "--- Choose one direction ---";
echo "
</div>";
echo'</td>
</tr>';
}
}
}
else{
//service
if($_SESSION["service"]=='t'){
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Department : </td>
<td align="left">';
echo"
<div id=\"div_leSer\">";
$leSer = $_POST["leSer"];
$leDir = $_POST["leDir"];
if($leDir){
echo "
<select id=\leSer\" name=\"leSer\" size=\"1\" >
<option></option>";
//liste complètes des services de la direction
$req_ser = "SELECT * FROM organisation WHERE idTypeOrga = '2' AND idOrgaPere = '$idDir'
AND Affecte = 't' AND Orga_Date_Fin = '0000-00-00' order by Orga_Lib ASC";
$res_ser = mysql_query($req_ser);
$liste_service = array();
if(mysql_num_rows($res_ser)){
while($tab_ser=mysql_fetch_array($res_ser)) {
$id_serv = $tab_ser["id"];
$liste_service[$id_serv] = $tab_ser["ser_libelle"];
}
}
foreach($liste_service as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if($key==$leSer) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
}else echo "--- Choose one direction ---";
echo "
</div>";
echo'</td>
</tr>';
}
}
}//while
}
else{//direction
//--> liste direction dans la base
$req_dir = "select idOrga as id, Orga_Lib as dir_libelle from organisation where idTypeOrga = '1'
AND Affecte = 't' order by Orga_Lib";
$res_dir = mysql_query($req_dir);
while($tab_dir = mysql_fetch_array($res_dir)) {
$id_direct = $tab_dir["id"];
$array_direction[$id_direct] = $tab_dir["dir_libelle"];
}
if($_SESSION["direction"]=='t'){
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Direction : </td>
<td align="left">';
//affichage directions principales
echo "
<select name=\"leDir\" onChange=\"choixDirection('leDir','leSer')\">";
echo "
<option></option>";
foreach($array_direction as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $directionSaisi) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'*</td>
</tr>';
}
//service
if($_SESSION["service"]=='t'){
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Department : </td>
<td align="left">';
echo"
<div id=\"div_leSer\">";
$leSer = $_POST["leSer"];
$leDir = $_POST["leDir"];
if($leDir){
echo "
<select id=\leSer\" name=\"leSer\" size=\"1\" >
<option></option>";
//liste complètes des services de la direction
echo $req_ser = "SELECT * FROM organisation WHERE idTypeOrga = '2' AND idOrgaPere = '$idDir' AND Orga_Date_Fin = '0000-00-00'
AND Affecte = 't' order by Orga_Lib ASC";
$res_ser = mysql_query($req_ser);
$liste_service = array();
if(mysql_num_rows($res_ser)){
while($tab_ser=mysql_fetch_array($res_ser)) {
$id_serv = $tab_ser["id"];
$liste_service[$id_serv] = $tab_ser["ser_libelle"];
}
}
foreach($liste_service as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if($key==$leSer) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
}else echo "--- Choose one direction ---";
echo "
</div>";
echo'</td>
</tr>';
}
}
//Affiche la zone de Poste
$requete = "SELECT * FROM annuaire_fonction_orga WHERE idAnnuaire = '$selectionM' AND Date_Fin = '0000-00-00'";
$resultat = mysql_query($requete) or die (mysql_error());
$test = mysql_num_rows($resultat);
$requete = "SELECT * FROM annuaire_fonction_orga WHERE idAnnuaire = '$selectionM' AND Date_Fin = '0000-00-00'";
$resultat = mysql_query($requete) or die (mysql_error());
$test = mysql_num_rows($resultat);
if($test >= 1) {
while($ligne_poste = mysql_fetch_array($resultat)){
$req_poste = "select idFonction as id, Fonction_Lib as fonction_libelle from fonction WHERE Affecte = 't'
order by Fonction_Lib ASC";
$res_poste = mysql_query($req_poste);
while($tab_poste = mysql_fetch_array($res_poste)) {
$id_poste = $tab_poste["id"];
$array_poste[$id_poste] = $tab_poste["fonction_libelle"];
}
if($_SESSION["fonction"]=='t'){
if($_POST["lePoste"]=='') $lePoste=$ligne_poste["idFonction"]; else $lePoste = $_POST["lePoste"];
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Fonction : </td>
<td align="left">';
echo "
<select name=\"lePoste\"\">";
echo "
<option></option>";
foreach($array_poste as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $lePoste) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'</td>
</tr>';
}
}
}
else{
$req_poste = "select idFonction as id, Fonction_Lib as fonction_libelle from fonction WHERE Affecte = 't'
order by Fonction_Lib ASC";
$res_poste = mysql_query($req_poste);
while($tab_poste = mysql_fetch_array($res_poste)) {
$id_poste = $tab_poste["id"];
$array_poste[$id_poste] = $tab_poste["fonction_libelle"];
}
if($_SESSION["fonction"]=='t'){
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Fonction : </td>
<td align="left">';
echo "
<select name=\"lePoste\"\">";
echo "
<option></option>";
foreach($array_poste as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $posteSaisi) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'</td>
</tr>';
}
}
//Affiche la zone de Site
$requete = "SELECT * FROM annuaire_site_orga WHERE idAnnuaire = '$selectionM' AND Date_Fin = '0000-00-00'";
$resultat = mysql_query($requete) or die (mysql_error());
$test = mysql_num_rows($resultat);
if($test >=1 ) {
while($ligne_site = mysql_fetch_array($resultat)){
$req_site = "select idSite as id, Site_Lib as site_libelle from site WHERE Affecte = 't'
order by Site_Lib ASC";
$res_site = mysql_query($req_site);
while($tab_site = mysql_fetch_array($res_site)) {
$id_site = $tab_site["id"];
$array_site[$id_site] = $tab_site["site_libelle"];
}
if($_SESSION["site"]=='t'){
if($_POST["leSite"]=='') $leSite=$ligne_site["idSite"]; else $leSite = $_POST["leSite"];
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Site : </td>
<td align="left">';
echo "
<select name=\"leSite\"\">";
echo "
<option></option>";
foreach($array_site as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $leSite) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo "
</select>";
echo'</td>
</tr>';
}
}
}
else{
$req_site = "select idSite as id, Site_Lib as site_libelle from site WHERE Affecte = 't'
order by Site_Lib ASC";
$res_site = mysql_query($req_site);
while($tab_site = mysql_fetch_array($res_site)) {
$id_site = $tab_site["id"];
$array_site[$id_site] = $tab_site["site_libelle"];
}
if($_SESSION["site"]=='t'){
echo '
<tr class="ligneformulaireS">
<td class="textformulaire">
Site : </td>
<td align="left">';
echo "
<select name=\"leSite\"\">";
echo "
<option></option>";
foreach($array_site as $key=>$value) {
echo "
<option value=\"".$key."\" ";
if ($key == $siteSaisi) echo " selected";
echo ">".stripslashes($value)."</option>";
}
echo'</td>
</tr>';
}
}
if($_SESSION["batiment"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Building : </td>
<td align="left"><input type="text" class="champformulaire" name="leBat" value="'.$_POST["leBat"].'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["etage"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Floor : </td>
<td align="left"><input type="text" class="champformulaire" name="leEtage" value="'.$_POST["leEtage"].'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["bureau"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Office : </td>
<td align="left"><input type="text" class="champformulaire" name="leBur" value="'.$_POST["leBur"].'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["bureau2"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Bureau(Intranet) : </td>
<td align="left"><input type="text" class="champformulaire" name="leBur2" value="'.$_POST["leBur2"].'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["telPro"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Phone1 N° : </td>
<td align="left"><input type="text" class="champformulaire" name="leTelPro" value="'.$_POST["leTelPro"].'" style="width: 120px">*</td>
</tr>';
}
if($_SESSION["mobPro"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Cellular1 N° : </td>
<td align="left"><input type="text" class="champformulaire" name="leMobPro" value="'.$_POST["leMobPro"].'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["mailPro"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
E-mail1 : </td>
<td align="left"><input type="text" class="champformulaire" name="leMailPro" value="'.$_POST["leMailPro"].'" style="width: 200px" >*</td>
</tr>';
}
if($_SESSION["faxPro"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Fax1 N° : </td>
<td align="left"><input type="text" class="champformulaire" name="leFaxPro" value="'.$_POST["leFaxPro"].'" style="width: 120px"></td>
</tr>';
}
if($_SESSION["keySta"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Top Manager : </td>
<td align="left"><input type="text" class="champformulaire" name="leKeySta" value="'.$_POST["leKeySta"].'" style="width: 20px" maxlength="2"></td>
</tr>';
}
if($_SESSION["arboHO"]=='t') {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Tree Crisis : </td>
<td align="left"><input type="text" class="champformulaire" name="leArboHO" value="'.$_POST["leArboHO"].'" style="width: 20px" maxlength="2"></td>
</tr>';
}
if($_POST["choix2"]=='1') $estActif=1; else $estActif=0;
}//fin else passage
if($estActif==1) {
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
On </td>
<td align="left">
<input type="radio" style="border:none;" name="choix2" value="1" CHECKED align="right"></td>
</tr>';
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Off </td>
<td align="left">
<input type="radio" style="border:none;" name="choix2" value="2" align="right"></td>
</tr>';
}
else{
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
On </td>
<td align="left">
<input type="radio" style="border:none;" name="choix2" value="1" align="right"></td>
</tr>';
echo '
<tr class="ligneformulaire">
<td class="textformulaire">
Off </td>
<td align="left">
<input type="radio" style="border:none;" name="choix2" value="2" CHECKED align="right"></td>
</tr>';
}
echo "
</table>";
echo "<br>
<div style='font-family:verdana; font-size:10px'>* Mandatory Field<br></div>";
//echo "<div style='font-family:verdana; font-size:10px'>** Un des deux champs obligatoires<br><br></div>";
echo "<br><input type=\"hidden\" name=\"valider3\"/>";
echo '<a href="#" onclick="document.form_etapeC.valider3.value=1; document.form_etapeC.submit();" class="bouton">Save</a>';
echo '<a href="param3.php?onglet=annuraire&Bmenu=param_annuraire_crise&lg=1" class="bouton">Return</a>';
if($test_passage == '1') {
$popupAlerte = $_SESSION["message"];
}
}// function afficheChampsPlein