} elseif (isset($_POST['action'])) { $action = null; } else { $action = null; } if ($connect == 1) { // Si le visiteur s'est identifie on affiche //affichage filtre pr reduire liste affichée ?> <div> <table align='center'> <tr> </tr> <?php $res = afficheFiltre("users"); ?> </table> </div><?php //si on a cliqué sur ajout/supp admin if ($action == 'ajouteAdmin') { $res = addAdmin($_GET['dn_user'], "CN=Maintenance_administrateur,CN=Users,DC=CODIF,DC=FR"); } if ($action == 'retireAdmin') { $res = suppAdmin($_GET['dn_user'], "CN=Maintenance_administrateur,CN=Users,DC=CODIF,DC=FR"); } $liste_services = listeService(); $groupes = array(); for ($i = 0; $i < count($liste_services) - 1; $i++) { $nom_groupe = $liste_services[$i]["cn"][0]; $groupes[] = $nom_groupe;
} elseif (isset($_POST['action'])) { $action = null; } else { $action = null; } if ($connect == 1) { // Si le visiteur s'est identifie on affiche //affichage filtre pr reduire liste affichée ?> <div> <table align='center'> <tr> </tr> <?php $res = afficheFiltre("materiels"); ?> </table> </div><?php echo "<div id=ligne></div>"; } else { ?> <div align=center> <h2> Connexion non valide</h2> <p>Vous n'avez pas accès à cette page, veuillez vous connecter.</p> </div> <?php } ?> <script type="text/javascript" src="include/jquery/datepicker-fr.js"></script> <script type="text/javascript" src="include/jquery/dates.js"></script>
function afficheForm($entite, $titre, $id, $event = null, $source = null) { include_once 'classes/materiel.class.php'; include_once 'classes/fournisseur.class.php'; //initialise disabled global $disabled; $disabled = ''; $cnx = ouvresylob(1); //recup table pr chq entité switch ($entite) { case "contrat": $latable = "informix.zz_contratmat"; $lajointure = ""; $leschamps = "*"; $lechamp = "id_contratmat"; $obligatoires = array("num", "debut", "fin", "preavis", "ent"); break; case "intervention": $latable = "informix.zz_inter"; $lajointure = ""; $leschamps = "id_inter as id,debut_inter as debut, fin_inter as fin, \r\n presta_inter as prestataire, intervenant_inter as intervenant,\r\n etat_inter, type_inter, \r\n periodicite_inter as periodicite, priorite_inter as priorite, \r\n domaine_inter as domaine, cout_inter as cout,\r\n detail_inter as detail, supp_inter as supp"; $lechamp = "id_inter"; $obligatoires = array("debut", "fin", "intervenant", "type_inter", "domaine"); break; case "materiel": $latable = "informix.zz_materiel"; $lajointure = " left join informix.zz_misservice on informix.zz_misservice.id_materiel = informix.zz_materiel.id_materiel\r\n left join informix.zz_destruction on informix.zz_destruction.id_materiel = informix.zz_materiel.id_materiel\r\n left join informix.bas_postrav on informix.bas_postrav.no_poste= informix.zz_materiel.id_posttrav"; $leschamps = "informix.zz_materiel.id_materiel as id, sn_materiel as sn, desig_materiel as designation,\r\n zone_materiel as zonemateriel, famille_materiel as fammat, id_posttrav as poste,\r\n type_materiel as typemateriel, marq_materiel as marque_materiel, frn_materiel as fournisseur,\r\n dteha_materiel as achat, etat_materiel as etatmateriel, contrat_materiel as contratmat, \r\n informix.zz_materiel.usage_materiel as usagemateriel, dte_misservice, dte_destruction"; $lechamp = "informix.zz_materiel.id_materiel"; $obligatoires = array("designation", "zonemateriel", "fammat", "typemateriel", "etatmateriel", "dte_misservice"); break; default: $latable = "informix.zz_" . $entite; $lechamp = "id_" . $entite; $obligatoires = array(""); break; } //on recupere les champs de l'entite $sql = "select " . $leschamps . " from " . $latable; if ($lajointure != '') { $sql .= $lajointure; } if ($id != null) { //on a un id => recup entite pr modif $sql = $sql . " where " . $lechamp . " = " . $id . ""; } else { $sql = $sql . " where 1=2"; //recup dernier id renseigné $sql0 = "SELECT max(" . $lechamp . ") FROM " . $latable; //echo $sql0; $res = odbc_exec($cnx, $sql0) or die('Erreur : ' . $sql); if (odbc_result($res, 1) > 0) { $no = odbc_result($res, 1) + 1; } else { $no = 1; } } $result = odbc_exec($cnx, $sql) or die('Erreur : ' . $sql); $ncols = odbc_num_fields($result); for ($i = 0; $i < odbc_num_fields($result); $i++) { $champs[] = odbc_field_name($result, $i + 1); $typeChamp[] = odbc_field_type($result, $i + 1); } $nb_champs = odbc_num_fields($result); //initialise tableau de valeurs a vide $valeurs = array(); for ($i = 0; $i < $nb_champs; $i++) { $valeurs[$i] = ''; } //si id renseigné => on est en modif : on recup donnees table if ($id) { while (odbc_fetch_row($result)) { for ($i = 0; $i < $nb_champs; $i++) { $valeurs[$i] = odbc_result($result, $i + 1); } //si etat = 3 on disabled if ($entite == 'intervention' and $valeurs[5] == 3 or $entite == 'materiel' and $valeurs[10] == 3) { $disabled = 'disabled'; } } $no = $id; } elseif (isset($_POST['id'])) { for ($i = 0; $i < $nb_champs; $i++) { if (isset($_POST[$champs[$i]]) and $_POST[$champs[$i]] != '') { $valeurs[$i] = $_POST[$champs[$i]]; } } $no = $_POST['id']; //on recup n° entite pr affichage } elseif (isset($_GET['materiel']) and $_GET['materiel'] != '') { for ($i = 0; $i < $nb_champs; $i++) { if (isset($_GET[$champs[$i]]) and $_GET[$champs[$i]] != '') { $valeurs[$i] = utf8_decode($_GET[$champs[$i]]); //on a encode pr passer en param ds calendar => on decode } } } //odbc_close($cnx); echo "<br>"; echo "<div id='edit'>"; echo "<TABLE align=center style=background:#fdf2db;color:#135356>\r\n <TR>\r\n <TD colspan=6 style='background:#519085' width=1090 align=right>\r\n <a href='" . $entite . ".php' ><img border=0 src='images/list.png' title='Affichage liste'></a>\r\n </td>\r\n </tr>\r\n </table>"; //affichage different pour materiel_infos if ($entite != 'materiel_infos') { //si contrat ou inter on doit recup liste materiels concernés if ($entite == "contrat" or $entite == "intervention") { $java = "onSubmit='javascript: soumettre_1liste(document.forms[0].choisi);'"; } else { $java = ""; } //affichage du formulaire echo " <form name='" . $entite . "' " . $java . " action = 'edit_" . $entite . ".php' \r\n method='post' onfocus='trie(this," . $entite . ",2);');'>\r\n <TABLE align=center style=background:#fdf2db;color:#135356>\r\n <TR>\r\n <TD colspan = 6 style='background:#519085' width=1090>\r\n <span>" . strtoupper(utf8_decode($titre)) . "</span>\r\n </TD>\r\n </TR>\r\n <tr><td colspan=6> </td></tr>\r\n <TR>\r\n <TD colspan = 6 align=center>\r\n <font color=#135356 size=5><b>" . str_replace("MATERIEL", "ENTITE", strtoupper(utf8_decode(str_replace("informix.zz_", "", $entite)))) . " N°" . $no . "</b></font>\r\n </TD>\r\n </TR>\r\n <tr><td colspan=6> </td></tr>\r\n <TR>\r\n <TD></TD><TD></TD>\r\n </TR>"; } //si form contrat ou inter on choisi le(s) materiel(s) concerné(s) if ($entite == 'contrat' or $entite == 'intervention') { afficheFiltre($entite); //liste materiel selectionné if ($id != '') { switch ($entite) { case 'contrat': $listemateriels = getMatContrat($id); break; case 'intervention': $listemateriels = getMatInter($id); break; default: break; } } else { $listemateriels = array(); } echo "<tr><td colspan=6><table border=0 align=center><tr> \r\n <th>Entités disponibles </th><th></th><th></th><th>Entité(s) concernée(s) </th></tr><tr>\r\n <td><select size = 10 style='width:300' name=dispo[] id=dispo " . $disabled . " multiple onDblClick='javascript: deplacer(this.form.dispo, this.form.choisi);'>"; //contenu liste materiel dispo renseigné par script echo " </select></td>"; echo " <td></td><td>\r\n <input type=button " . $disabled . " value=Ajouter onclick='javascript: deplacer(this.form.dispo, this.form.choisi);'><br><br>\r\n <input type=button " . $disabled . " value=Retirer onclick='javascript: deplacer(this.form.choisi, this.form.dispo);'>\r\n </td>"; echo " <td><select size = 10 style='width:300' class='obligatoire' name=choisi[] id=choisi " . $disabled . " multiple onDblClick='javascript: deplacer(this.form.choisi, this.form.dispo);'>"; foreach ($listemateriels as $materiel) { echo " <option value ='" . $materiel . "' >" . $materiel . " - " . utf8_encode(getNomMat($materiel)) . "</option>"; } echo " </select></td></tr></table>"; } echo " <TR><tr><td colspan=6> </td></tr>"; //on boucle sur ts les champs de l'entite pour faire le formulaire for ($i = 0; $i < $nb_champs; $i++) { $champs[$i] = str_replace("_contratmat", "", $champs[$i]); if (in_array($champs[$i], $obligatoires)) { $classe = "class=obligatoire"; } else { $classe = ""; } $label = formatLabel($champs[$i]); //on cree les champs de formulaire selon leur type switch ($typeChamp[$i]) { case "INTEGER": //int sylob formInteger($champs[$i], $valeurs[$i], $disabled, $classe); break; case "SERIAL": //id $id = $valeurs[$i]; //recupere l'id echo "<input type=hidden name=id value='" . $id . "'>"; break; case "FLOAT": //duree ou prix if ($champs[$i] == "duree") { echo "<td>" . $label . " </td><td><input type=text " . $disabled . " " . $classe . " name=" . $champs[$i] . " value = '" . $valeurs[$i] . "' onKeyPress='return chiffres(event);'> heure(s)</td>"; } else { echo "<td>" . $label . " </td><td><input type=text " . $disabled . " " . $classe . " name=" . $champs[$i] . " value = '" . $valeurs[$i] . "' onKeyPress='return chiffres(event);'> € HT</td>"; } break; case "DATE": //date sylob formDate($champs[$i], $valeurs[$i], $disabled); break; case "DATETIME YEAR TO MINUTE": //date + heure sylob if (isset($_GET['debut'])) { //echo $_GET['debut']; formHeure($champs[$i], $_GET['debut'], $disabled); } else { //echo $valeurs[$i]; formHeure($champs[$i], $valeurs[$i], $disabled); } break; case "CHAR": //char sylob formChar($champs[$i], $valeurs[$i], $disabled, $classe); break; case "VARCHAR": //textarea echo "</TR><TR><td>" . $label . " </td><td colspan=5><textarea " . $disabled . " name=" . $champs[$i] . " cols=50 rows=5>" . utf8_encode($valeurs[$i]) . "</textarea></td></TR><TR>"; break; default: echo "pas traité :" . $champs[$i] . " - " . $typeChamp[$i]; break; } if ($i % 3 == 0) { echo "<tr><td colspan=6> </td></tr>"; } } //si on vient du calendrier on recuperre source if (isset($source) and $source == "calendrier") { echo "<input type=hidden " . $disabled . " name=source value=" . $source . ">"; } if ($entite != "materiel_infos") { echo " </TR> \r\n <TR>\r\n <TD COLSPAN=6 align = center>\r\n <input type=button " . $disabled . " id=monform name=monform onclick=verifForm(this.form); value=Valider />\r\n </TD>\r\n </TR>\r\n </TABLE> \r\n </form>\r\n </div>"; } }
$res = deleteContrat($_GET['id']); } if ($action == 'restaure') { $res = restaureContrat($_GET['id']); } //Lien pour ajouter contrat //echo "<a href = edit_contrat.php?id= ><img border=0 src='images/demande.png' alt='Nouveau Contrat' /></a>"; //affichage filtre pr reduire liste affichée ?> <div> <table align='center'> <tr> </tr> <?php $res = afficheFiltre("contrats"); ?> </table> </div><?php //affichage liste issue de retour.php echo "<div id=ligne></div>"; } else { ?> <div align=center> <h2> Connexion non valide</h2> <p>Vous n'avez pas accès à cette page, veuillez vous connecter.</p> </div> <?php } ?> <script type="text/javascript" src="include/jquery/datepicker-fr.js"></script>
} elseif (isset($_POST['action'])) { $action = null; } else { $action = null; } if ($connect == 1) { // Si le visiteur s'est identifie on affiche //affichage filtre pr reduire liste affichée ?> <div> <table align='center'> <tr> </tr> <?php $res = afficheFiltre("fournisseurs"); ?> </table> </div><?php //Lien pour ajouter fournisseur //echo "<a href = edit_fournisseur.php?id= ><img border=0 src='images/demande.png' alt='Nouveau fournisseur' /></a>"; //on recupere les fournisseurs et on les affiche en tableau //$liste_fournisseur = listeFourni(); //afficheListe($liste_fournisseur, 'fournisseur'); echo "<div id=ligne></div>"; } else { ?> <div align=center> <h2> Connexion non valide</h2> <p>Vous n'avez pas accès à cette page, veuillez vous connecter.</p> </div>
$res = restaureInter($_GET['id']); } if ($action == 'duplique') { $res = dupliqueInter($_GET['id']); } //Lien pour ajouter intervention //echo "<a href = edit_intervention.php?id= ><img border=0 src='images/demande.png' title='Nouvelle intervention' alt='Nouvelle intervention'/></a>"; //affichage filtre pr reduire liste affichée ?> <div> <table align='center'> <tr> </tr> <?php $res = afficheFiltre("interventions"); ?> </table> </div><?php //affichage liste issue de retour.php echo "<div id=ligne></div>"; } else { ?> <div align=center> <h2> Connexion non valide</h2> <p>Vous n'avez pas accès à cette page, veuillez vous connecter.</p> </div> <?php } ?> <script type="text/javascript" src="include/jquery/datepicker-fr.js"></script>