} 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>
