Public feed #378544

Someone

public text v1 · immutable
Raw Edit
·published 2007-03-02 16:01 UTC
rendered paste body
<?php
// Appel de la session
session_start();

// Securité
if (!isset($_SESSION['user'])) {header("Location: index.php");exit();}

// Inclusion
include './fonctions/fct_list.php';

// Definition de l'affichage des onglets
if (isset($_POST['Flag'])) {
  if ($_POST['Flag']=="A") {$A_Display="block";$S_Display="none";} else {$S_Display="block";$A_Display="none";}
} else {$S_Display="block";$A_Display="none";}
?>

<html>

<head>
<link rel="stylesheet" type="text/css" href="./styles/styles.css">
<script language="javascript" src="js/scripts.js"></script>
<script language="javascript">
function ChangeOrder(order) {
  document.getElementById('OrderBy').value=order;
  document.FndApp.submit();
}
function Affiche(a,b) {
  document.getElementById(a).style.display="block";
  document.getElementById(b).style.display="none";
}
</script>
</head>

<title>ePérimètre</title>

<body class="Body_1" onLoad="InitMenu('<?=$_SERVER['PHP_SELF'];?>');document.getElementById('GenSearch').focus();">
<table class="MainTemplate"><tr><td width=200 valign="top"><? include "menu.php"; ?></td><td valign=top>

<center>

<br>
<div class="Titre_1">Recherche d'une Application :</div>
<br>
<div class="Notice">Cochez la case adjacente à un champ afin de l'afficher au résultat de la recherche</div>
<br><br>

<form name="FndApp" action="" method="POST">
<input type="hidden" name="Flag" value="S">
<input type="hidden" name="OrderBy">


<div id="S" style="display:<?=$S_Display;?>;">
<table class="Table_1" cellspacing="0" width="820">
  <tr><td class="TitreTable_1" width="100%">Recherche Simple</td>
  <tr><td width="100%" class="ContenuTable_1" align="center"><a href="#" class="notice" onClick="Affiche('A','S')">Recherche avancée</a></td></tr>
  <tr><td width="100%" class="ContenuTable_1" align="center" valign="center" height="50"><input type="text" id="GenSearch" name="GenSearch" size="35" value="<?=$_POST['GenSearch'];?>"></td></tr>
  <tr><td width="100%" height="50" class="ContenuTable_1" align="center" valign="center"><input type="submit" value="Rechercher" onClick="document.getElementById('Flag').value='S';"></td></tr>
</table>
</div>

<div id="A" style="display:<?=$A_Display;?>;">
<table class="Table_1" cellspacing="0">
  <tr><td class="TitreTable_1" colspan="6">Recherche Avancée</td><tr>
  <tr><td colspan="6" class="ContenuTable_1" align="center" height="25" valign="top"><a href="#" class="notice" onClick="Affiche('S','A')">Recherche simple</a></td></tr>
  <tr><td width="150" class="ContenuTable_1" align="right"><span class="help" title="Numéro de série Clarify de l'application">Référence Clarify :</span></td>
      <td class="ContenuTable_1" align="Left"><input type="text" name="Ref_Clarify" size="35" value="<?=$_POST['Ref_Clarify'];?>"></td>
      <td class="ContenuTable_1"></td>
      <td width="150" class="ContenuTable_1" align="right"><span class="help" title="Nom complet de l'application">Nom :</span></td>
      <td class="ContenuTable_1" align="Left"><input type="text" name="Nom" size="35" value="<?=$_POST['Nom'];?>"></td>
      <td class="ContenuTable_1"></td></tr>

  <tr><td width="150" class="ContenuTable_1" align="right"><span class="help" title="Serveur h\364te">Serveur :</span></td>
      <td class="ContenuTable_1" align="Left"><input type="text" name="Serveur" size="35" value="<?=$_POST['Serveur'];?>"></td>
      <td class="ContenuTable_1"></td>
      <td width="150" class="ContenuTable_1" align="right"><span class="help" title="Base de données utilisée">Base de données :</span></td>
      <td class="ContenuTable_1" align="Left"><input type="text" name="Base" size="35" value="<?=$_POST['Base'];?>"></td>
      <td class="ContenuTable_1"></td></tr>

  <tr><td width="150" class="ContenuTable_1" align="right"><span class="help" title="Alias de l'application">Alias :</span></td>
      <td class="ContenuTable_1" align="Left"><input type="text" name="Alias" size="35" value="<?=$_POST['Alias'];?>"></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_Alias'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_Alias" value="Alias"></td>
      <td width="150" class="ContenuTable_1" align="right"><span class="help" title="Nom du Projet associé à l'application">Projet :</span></td>
      <td class="ContenuTable_1" align="Left"><input type="text" name="Projet" size="35" value="<?=$_POST['Projet'];?>"></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_Projet'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_Projet" value="Projet"></td></tr>

  <tr><td width="150" class="ContenuTable_1" align="right"><span class="help" title="DSI responsable de l'application">DSI :</span></td>
      <td class="ContenuTable_1" align="Left"><select name="DSI"><?=make_fnd_select("EP_LISTE_DSI",$_POST['DSI']);?></select></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_DSI'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_DSI" value="DSI"></td>
      <td width="150" class="ContenuTable_1" align="right"><span class="help" title="Domaine applicatif">Domaine :</span></td>
      <td class="ContenuTable_1" align="Left"><select name="Domaine"><?=make_fnd_select("EP_LISTE_DOMAINES_APP",$_POST['Domaine']);?></select></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_Domaine'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_Domaine" value="Domaine Applicatif"></td></tr>

  <tr><td width="150" class="ContenuTable_1" align="right"><span class="help" title="Support associé à l'application">Niveau de Service :</span></td>
      <td class="ContenuTable_1" align="Left"><select name="Nv_Srvc"><?=make_fnd_select("EP_LISTE_NIVEAUX_SERVICE_APP",$_POST['Nv_Srvc']);?></select></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_Nv_Srvc'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_Nv_Srvc" value="Niveau de Service"></td>
      <td width="150" class="ContenuTable_1" align="right"><span class="help" title="Type de supervision: HO ou Totale (HO+HNO)">Couverture de Service :</span></td>
      <td class="ContenuTable_1" align="Left"><select name="Couv_Srvc"><?=make_fnd_select("EP_LISTE_COUV_SERVICE_APP",$_POST['Couv_Srvc']);?></select></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_Couv_Srvc'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_Couv_Srvc" value="Couverture de Service"></td></tr>

  <tr><td width="150" class="ContenuTable_1" align="right"><span class="help" title="Nom du chef de projet en charge de l'application">Chef de Projet :</span></td>
      <td class="ContenuTable_1" align="Left"><input type="text" name="Chef_Projet" size="35" value="<?=$_POST['Chef_Projet'];?>"></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_Chef_Projet'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_Chef_Projet" value="Chef de Projet"></td>
      <td width="150" class="ContenuTable_1" align="right"><span class="help" title="Nom du SM chargé de l'application">Service Manager :</span></td>
      <td class="ContenuTable_1" align="Left"><select name="Svc_Mgr"><?=make_fnd_select("EP_LISTE_SERVICE_MGR_APP",$_POST['Svc_Mgr']);?></select></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_Svc_Mgr'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_Svc_Mgr" value="Service Manager"></td></tr>
  <tr><td width="150" class="ContenuTable_1" align="right"><span class="help" title="BT associé à l'application">BT :</span></td>
      <td class="ContenuTable_1" align="Left"><select name="BT"><?=make_fnd_select("EP_LISTE_BT_APP",$_POST['BT']);?></select></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_BT'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_BT" value="BT"></td>
      <td width="150" class="ContenuTable_1" align="right"><span class="help" title="Environnement de l'instance de l'application">Environnement :</span></td>
      <td class="ContenuTable_1" align="Left"><select name="Environnement"><?=make_fnd_select("EP_LISTE_ENVIRONNEMENTS",$_POST['ENVIRONNEMENT']);?></select></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_Environnement'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_Environnement" value="Environnement"></td></tr>
  <tr><td width="150" class="ContenuTable_1" align="right"><span class="help" title="Etat de l'application">Statut :</span></td>
      <td class="ContenuTable_1" align="Left"><select name="Statut"><?=make_fnd_select("EP_LISTE_STATUTS_APP",$_POST['STATUT']);?></select></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_Statut'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_Statut" value="Statut"></td>
      <td width="150" class="ContenuTable_1" align="right"><span class="help" title="Plage autorisée pour les interventions (MEP,curatives,etc...)">Plage d'intervention :</span></td>
      <td class="ContenuTable_1" align="Left"><select name="Plage_H_Inter"><?=make_fnd_select("EP_LISTE_PLAGE_H_INTER_APP",$_POST['PLAGE_H_INTER']);?></select>&nbsp;<select name="Plage_J_Inter"><?=make_fnd_select("EP_LISTE_PLAGE_J_INTER_APP",$_POST['PLAGE_J_INTER']);?></select></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_Plage_Inter'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_Plage_Inter" value="Plage d'intervention"></td></tr>
  <tr><td width="150" class="ContenuTable_1" align="right"><span class="help" title="Plage de fonctionnement de l'application pour l'explotation">Plage de production :</span></td>
      <td class="ContenuTable_1" align="Left"><select name="Plage_H_Prod"><?=make_fnd_select("EP_LISTE_PLAGE_H_PROD_APP",$_POST['PLAGE_H_PROD']);?></select>&nbsp;<select name="Plage_J_Prod"><?=make_fnd_select("EP_LISTE_PLAGE_J_PROD_APP",$_POST['PLAGE_J_PROD']);?></select></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_Plage_Prod'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_Plage_Prod" value="Plage d'utilisation"></td>
      <td width="150" class="ContenuTable_1" align="right"><span class="help" title="Plage de fonctionnement de l'application pour les utilisateurs">Plage d'utilisation :</span></td>
      <td class="ContenuTable_1" align="Left"><select name="Plage_H_Util"><?=make_fnd_select("EP_LISTE_PLAGE_H_UTIL_APP",$_POST['PLAGE_H_UTIL']);?></select>&nbsp;<select name="Plage_J_Util"><?=make_fnd_select("EP_LISTE_PLAGE_J_UTIL_APP",$_POST['PLAGE_J_UTIL']);?></select></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_Plage_Util'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_Plage_Util" value="Plage d'utilisation"></td></tr>
  <tr><td width="150" class="ContenuTable_1" align="right"><span class="help" title="Commentaires sur l'application">Commentaires :</span></td>
      <td class="ContenuTable_1" align="Left"><input type="text" name="Commentaires" size="35" value="<?=$_POST['Commentaires'];?>"></td>
      <td class="ContenuTable_1" width="10"><input type="checkbox" <?if(isset($_POST['Aff_Comm'])||!isset($_POST['Flag'])){echo "checked";}?> name="Aff_Comm" value="Plage d'utilisation"></td>
      <td class="ContenuTable_1" colspan="3">&nbsp;</td></tr>
  <tr><td rowspan="2" colspan="6" class="ContenuTable_1" align="center" height="50"><input type="submit" value="Rechercher" onClick="document.getElementById('Flag').value='A';"></td></tr>
</table>
</div>

</form>

<?
if (isset($_POST['Flag'])) {

// Variables
// Champs Textes
$VarFields="Ref_Clarify Nom Alias Projet Chef_Projet Plage_Inter Plage_Prod Plage_Util Commentaires";
// Champs Listes
$TableNames=array("DSI"=>"EP_LISTE_DSI","Domaine"=>"EP_LISTE_DOMAINES_APP","Nv_Srvc"=>"EP_LISTE_NIVEAUX_SERVICE_APP","Couv_Srvc"=>"EP_LISTE_COUV_SERVICE_APP","Svc_Mgr"=>"EP_LISTE_SERVICE_MGR_APP","BT"=>"EP_LISTE_BT_APP","Environnement"=>"EP_LISTE_ENVIRONNEMENTS","Statut"=>"EP_LISTE_STATUTS_APP");
// Labels des Champs avec affichage obligatoire
$ForcedFields=array("Nom"=>"Nom","Serveur"=>"Serveur","Base"=>"Base de donn\351es","SRVBDD"=>"Serveur de base de données");
// Tous les autres Champs
$Fields=array("Alias"=>"Alias","Projet"=>"Projet","DSI"=>"DSI","Domaine"=>"Domaine Applicatif","Nv_Srvc"=>"Niveau de Service","Couv_Srvc"=>"Couverture de Service","Chef_Projet"=>"Chef de Projet","Svc_Mgr"=>"Service Manager","BT"=>"BT","Environnement"=>"Environnement","Statut"=>"Statut","Plage_Inter"=>"Plage d\'intervention","Plage_Prod"=>"Plage d\'utilisation","Plage_Util"=>"Plage d\'utilisation","Commentaires"=>"Commentaires");

// Requete generique
$Request="select EP_APPLICATIONS.APP_ID, EP_APPLICATIONS.REF_CLARIFY, EP_APPLICATIONS.NOM,EP_SERVEURS.NOM as SERVEUR,EP_BDD.INSTANCE as BASE, EP_SRVBDD.NOM as SRVBDD, ALIAS, PROJET, EP_LISTE_DSI.OPT_LABEL as DSI,CHEF_PROJET, EP_LISTE_DOMAINES_APP.OPT_LABEL as DOMAINE, EP_LISTE_SERVICE_MGR_APP.OPT_LABEL as SVC_MGR, EP_LISTE_STATUTS_APP.OPT_LABEL as STATUT, EP_LISTE_ENVIRONNEMENTS.OPT_LABEL as ENVIRONNEMENT, EP_LISTE_NIVEAUX_SERVICE_APP.OPT_LABEL as NV_SRVC,EP_LISTE_COUV_SERVICE_APP.OPT_LABEL as COUV_SRVC, EP_LISTE_BT_APP.OPT_LABEL as BT, EP_LISTE_PLAGE_H_INTER_APP.OPT_LABEL as PLAGE_H_INTER,EP_LISTE_PLAGE_J_INTER_APP.OPT_LABEL as PLAGE_J_INTER,EP_LISTE_PLAGE_H_PROD_APP.OPT_LABEL as PLAGE_H_PROD,EP_LISTE_PLAGE_J_PROD_APP.OPT_LABEL as PLAGE_J_PROD,EP_LISTE_PLAGE_H_UTIL_APP.OPT_LABEL as PLAGE_H_UTIL,EP_LISTE_PLAGE_J_UTIL_APP.OPT_LABEL as PLAGE_J_UTIL, EP_APPLICATIONS.COMMENTAIRES from EP_APPLICATIONS left outer join EP_APP_SRV on EP_APPLICATIONS.APP_ID=EP_APP_SRV.APP_ID left outer join EP_APP_BDD on EP_APP_BDD.APP_ID=EP_APPLICATIONS.APP_ID left outer join EP_BDD on EP_BDD.BDD_ID=EP_APP_BDD.BDD_ID left outer join EP_SERVEURS on EP_SERVEURS.SRV_ID=EP_APP_SRV.SRV_ID left outer join EP_SERVEURS EP_SRVBDD on EP_BDD.SERVEUR=EP_SRVBDD.SRV_ID, EP_LISTE_STATUTS_APP, EP_LISTE_DSI, EP_LISTE_SERVICE_MGR_APP, EP_LISTE_DOMAINES_APP, EP_LISTE_ENVIRONNEMENTS, EP_LISTE_NIVEAUX_SERVICE_APP, EP_LISTE_COUV_SERVICE_APP,EP_LISTE_BT_APP,EP_LISTE_PLAGE_H_INTER_APP,EP_LISTE_PLAGE_J_INTER_APP,EP_LISTE_PLAGE_H_PROD_APP,EP_LISTE_PLAGE_J_PROD_APP,EP_LISTE_PLAGE_H_UTIL_APP,EP_LISTE_PLAGE_J_UTIL_APP where EP_APPLICATIONS.DSI=EP_LISTE_DSI.OPT_ID AND EP_APPLICATIONS.SVC_MGR=EP_LISTE_SERVICE_MGR_APP.OPT_ID AND EP_APPLICATIONS.DOMAINE=EP_LISTE_DOMAINES_APP.OPT_ID AND EP_APPLICATIONS.STATUT=EP_LISTE_STATUTS_APP.OPT_ID AND EP_APPLICATIONS.ENVIRONNEMENT=EP_LISTE_ENVIRONNEMENTS.OPT_ID AND EP_APPLICATIONS.NV_SRVC=EP_LISTE_NIVEAUX_SERVICE_APP.OPT_ID AND EP_APPLICATIONS.COUV_SRVC=EP_LISTE_COUV_SERVICE_APP.OPT_ID AND EP_APPLICATIONS.BT=EP_LISTE_BT_APP.OPT_ID AND EP_LISTE_ENVIRONNEMENTS.OPT_ID=EP_APPLICATIONS.ENVIRONNEMENT AND EP_LISTE_PLAGE_H_INTER_APP.OPT_ID=EP_APPLICATIONS.PLAGE_H_INTER AND EP_LISTE_PLAGE_J_INTER_APP.OPT_ID=EP_APPLICATIONS.PLAGE_J_INTER AND EP_LISTE_PLAGE_H_PROD_APP.OPT_ID=EP_APPLICATIONS.PLAGE_H_PROD AND EP_LISTE_PLAGE_J_PROD_APP.OPT_ID=EP_APPLICATIONS.PLAGE_J_PROD AND EP_LISTE_PLAGE_H_UTIL_APP.OPT_ID=EP_APPLICATIONS.PLAGE_H_UTIL AND EP_LISTE_PLAGE_J_UTIL_APP.OPT_ID=EP_APPLICATIONS.PLAGE_J_UTIL";

// Preparation du translate (suppression des accents) qui sera couple a un upper (suppression des majuscules)
$accents='ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðòóôõöùúûüýÿ';
$noaccents='AAAAAACEEEEIIIIOOOOOUUUUYaaaaaaceeeeiiiioooooouuuuyy';

// Type de recherche: Avancee
if ($_POST['Flag']=="A") {
$Fields=array();
// Generation des clause en fonction des elements de recherche soumis
foreach ($_POST as $key => $value) {
  if ($value && $key != "Flag" && $key != "GenSearch") {
    $Search=format_string($value);
    if ($key == "OrderBy") {
      $Order=" ORDER BY ".$value;
    } else if (substr($key,0,4) == "Aff_") {
      $Champ=substr($key,4);
      $Fields[$Champ]=$value;
    } else if ($key == "Base") {
      $Request.=" AND UPPER(TRANSLATE(EP_BDD.INSTANCE,'".$accents."','".$noaccents."')) like '%".escape_string($Search)."%'";
    } else if ($key == "Serveur") {
      $Request.=" AND UPPER(TRANSLATE(EP_SERVEURS.NOM,'".$accents."','".$noaccents."')) like '%".escape_string($Search)."%'";
    } else if (isset($TableNames[$key])) {
      $Request.=" AND EP_APPLICATIONS.".$key."='".escape_string($Search)."'";
    } else {
      $Request.=" AND UPPER(TRANSLATE(EP_APPLICATIONS.".$key.",'".$accents."','".$noaccents."')) like '%".escape_string($Search)."%'";
    }
  }
}

// Type de recherche: Simple
} else if ($_POST['Flag']=="S") {
$Request.=" AND (";
$Search=format_string($_POST['GenSearch']);
if ($_POST['OrderBy'] != "") {$Order=" ORDER BY ".$_POST['OrderBy'];}

$Fields=array("Alias"=>"Alias","Projet"=>"Projet","DSI"=>"DSI","Domaine"=>"Domaine Applicatif","Nv_Srvc"=>"Niveau de Service","Couv_Srvc"=>"Couverture de Service","Chef_Projet"=>"Chef de Projet","Svc_Mgr"=>"Service Manager","BT"=>"BT","Environnement"=>"Environnement","Statut"=>"Statut","Plage_Inter"=>"Plage d\'intervention","Plage_Prod"=>"Plage d\'utilisation","Plage_Util"=>"Plage d\'utilisation","Commentaires"=>"Commentaires"); 

// Generation des clause a partir des listes definies au dessus
// Gestion de la base et du serveur
$Request.="UPPER(TRANSLATE(EP_BDD.INSTANCE,'".$accents."','".$noaccents."')) like '%".escape_string($Search)."%'";
$Request.=" OR UPPER(TRANSLATE(EP_SERVEURS.NOM,'".$accents."','".$noaccents."')) like '%".escape_string($Search)."%'";
// Boucle sur $VarFields
foreach (explode(" ",$VarFields) as $key => $value) {
  if (substr($value,0,5) == "Plage") {
    $Request.=" OR UPPER(TRANSLATE(EP_APPLICATIONS.".str_replace("_","_H_",$value).",'".$accents."','".$noaccents."')) like '%".escape_string($Search)."%'";
    $Request.=" OR UPPER(TRANSLATE(EP_APPLICATIONS.".str_replace("_","_J_",$value).",'".$accents."','".$noaccents."')) like '%".escape_string($Search)."%'";
  } else {
    $Request.=" OR UPPER(TRANSLATE(EP_APPLICATIONS.".$value.",'".$accents."','".$noaccents."')) like '%".escape_string($Search)."%'";
  }
}
// Boucle sur $TableNames
foreach ($TableNames as $key => $value) {
  $Request.=" OR (EP_APPLICATIONS.".$key."=".$value.".OPT_ID AND UPPER(TRANSLATE(".$value.".OPT_LABEL,'".$accents."','".$noaccents."')) like '%".escape_string($Search)."%')";
}
$Request.=")";
}

// Ordre de Tri
if (!isset($Order)) {$Request.=" ORDER BY EP_APPLICATIONS.REF_CLARIFY";} else {$Request.=$Order;}

// Execution de la requete
$AppList=ExecSelect($Request);

// Merge des tableaux force et libre
$Fields=array_merge($ForcedFields,$Fields);

// Affichage
echo '<table class="Table_1" cellspacing="0">
  <tr><td class="TitreListe_1" width="150">Référence Clarify&nbsp;<span class="hand" title="Trier" onClick="ChangeOrder(\'REF_CLARIFY\')">&darr;</span></td>'."\n";

foreach ($Fields as $key => $value) {
  echo '      <td class="TitreListe_1" width="150">'.unescape_string($value).'&nbsp;<span class="hand" title="Trier" onClick="ChangeOrder(\''.strtoupper($key).'\')">&darr;</span></td>'."\n";
}

echo '  </tr>'."\n";

if (isset($AppList[0])) {
  foreach ($AppList as $Appkey => $Appvalue) {
    echo '  <tr align="center">
    <td class="ContenuListe_1"><a href="./viewapp.php?ID='.$Appvalue['APP_ID'].'">'.$Appvalue['REF_CLARIFY'].'</a></td>'."\n";
    foreach ($Fields as $key => $value) {
      if (substr(strtoupper($key),0,5) == "PLAGE") {
	echo '    <td class="ContenuListe_1">'.unescape_string($Appvalue[str_replace('_','_H_',strtoupper($key))]." ".$Appvalue[str_replace('_','_J_',strtoupper($key))]).'</td>'."\n";
      } else if (!isset($Appvalue[strtoupper($key)])) {
        echo '    <td class="ContenuListe_1">-</td>'."\n";
      } else {
        if ($key == "Nom") {
          echo '    <td class="ContenuListe_1">'.unescape_string($Appvalue[strtoupper($key)]." ".$Appvalue['ENV']).'</td>'."\n";
        } else {
          echo '    <td class="ContenuListe_1">'.tiret(unescape_string($Appvalue[strtoupper($key)])).'</td>'."\n";
        }
      }
    }
    echo '  </tr>'."\n";
  }
} else {echo '<tr align="center"><td class="ContenuTable_1" colspan="17"><span class="Message_1">Aucun resultat trouvé</span></td></tr>'."\n";}

echo '</table>';
}
?>

</td></tr></table>

</center>

</html>