<?php
$DEBUG=0;
$serie=50;
$ent = "Intervention";
$ico = "intervention.png";
$edition="";
$fiche="";
$tableSelect="intervention left join station on intervention.idstation=station.idstation left join personnel on intervention.iddemandeur=personnel.idutilisateur";
$champs=array("idintervention",
              "intervention.idstation",
              "station.numero as station",
              "idperipherique",
              "idtype",
              "concat(nom,' ',prenom) as demandeur",
              "iddemandeur",
              "idintervenant",
              "dateouverture",
              "datecloture",
              "observations",
              "idetatintervention",
              "observations as naturestation"); /*nature utilisé pour nature appelant sousform ex:stationmairie*/
$selection="";                                       
$sql_etatintervention="select idetat,libetat from etatintervention";
$sql_peripherique="select idelement,libmodele from element inner join modeleelement on element.idmodele=modeleelement.idmodele where classe='peripherique' and (numserie<>'' or numero<>'') and idstation = ";
$sql_type="select idtype,libtype from typeintervention order by libtype";
$sql_demandeur="select idutilisateur,concat(' ',nom,' ',prenom) as utilisateur from personnel where idutilisateur=";
$sql_intervenant="select idutilisateur,concat(nom,' ',prenom) from personnel where intervenant='v' order by nom";
?>