1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120
| <html>
<head>
<title>Extraction - Résultats</title>
<style type="text/css">
table {
border-width: 0px;
border-spacing: 2px;
border-style: solid;
border-color: gray;
border-collapse: collapse;
background-color: white;
}
table td {
border-width: 1px;
padding: 1px;
border-style: solid;
border-color: gray;
background-color: white;
padding: 1px;
-moz-border-radius: 0px;
}
</style>
</head>
<body>
<?php
$date1 = $_POST['date1'];
$date2 = $_POST['date2'];
$projet = $_POST['projet'];
$mach = $_POST['mach'];
$lim = $_POST['lim'];
$mail = $_POST['mail'];
$filter = $_POST['filter'];
if ($date1){$date1_dis="du : ".$date1."<br/>"; $date1=" -date1 ".$date1."";}else{$date1=""; $date1_dis="";}
if ($date2){$date2_dis="au : ".$date2."<br/>"; $date2=" -date2 ".$date2."";}else{$date2=""; $date2_dis="";}
if ($mach){$mach_dis="machine : ".$mach."<br/>"; $mach=" -mach ".$mach."";}else{$mach=""; $mach_dis="";}
if ($mail){$mail_dis="mail : ".$mail."<br/>"; $mail=" -mail ".$mail."";}else{$mail=""; $mail_dis="";}
if ($lim){$lim_dis="severite : ".$lim."<br/>"; $lim=" -date1 ".$lim."";}else{$lim=""; $lim_dis="";}
if ($projet){$projet_dis="projet : ".$projet."<br/>"; $projet=" -projet ".$projet."";}else{$projet=""; $projet_dis="";}
if ($filter){$filter_dis="filtre : ".$filter."<br/>"; $filter_act=" -grep ".$filter.""; $filter=" | grep ".$filter."";}else{$filter=""; $filter_dis=""; $filter_act="";}
echo $date1_dis.$date2_dis.$mach_dis.$lim_dis.$projet_dis.$mail_dis.$filter_dis;
exec("plink -l root -pw xxxxxx srv \"cd /var/srv/home/xxx && ./Extract.ksh ".$date1."".$date2."".$mach."".$mail."".$lim."".$projet."".$filter_act." && exit\"");
$output = array();
$return_var = 0;
exec("plink -l root -pw xxxxxx srv \"cat /var/srv/home/xxx/Extract.txt".$filter." && exit\"", $output, $return_var);
echo "<br />";
echo "<table border='0'>";
echo "<tr>";
echo "<td style='background-color: #cccccc;'>ident</td>";
echo "<td style='background-color: #cccccc;'>ident_annul</td>";
echo "<td style='background-color: #cccccc;'>Severite</td>";
echo "<td style='background-color: #cccccc;'>Machine</td>";
echo "<td style='background-color: #cccccc;'>Objet</td>";
echo "<td style='background-color: #cccccc;'>Projet</td>";
echo "<td style='background-color: #cccccc;'>Appli</td>";
echo "<td style='background-color: #cccccc;'>d_reception</td>";
echo "<td style='background-color: #cccccc;'>d_prise_en_compte</td>";
echo "<td style='background-color: #cccccc;'>alias_d_annulation</td>";
echo "<td style='background-color: #cccccc;'>euuh</td>";
echo "<td style='background-color: #cccccc;'>Libelle Alarme</td>";
echo "</tr>";
foreach($output as $key => $val){
list($grr, $ident, $ident_annul, $severi, $s_machine, $s_objet, $s_proj, $s_appl, $d_reception, $d_prise_en_compte, $alias_d_annulation, $euuh, $texte) = explode("@", $val);
/*$ident = trim($ident);
if(empty($ident)){$ident="-";}*/
$ident_annul = trim($ident_annul);
if(empty($ident_annul)){$ident_annul="-";}
/*$severi = trim($severi);
if(empty($severi)){$severi="-";}*/
$s_machine = trim($s_machine);
if(empty($s_machine)){$s_machine="-";}
$s_objet = trim($s_objet);
if(empty($s_objet)){$s_objet="-";}
$s_proj = trim($s_proj);
if(empty($s_proj)){$s_proj="-";}
$s_appl = trim($s_appl);
if(empty($s_appl)){$s_appl="-";}
$d_reception = trim($d_reception);
if(empty($d_reception)){$d_reception="-";}
$d_prise_en_compte = trim($d_prise_en_compte);
if(empty($d_prise_en_compte)){$d_prise_en_compte="-";}
$alias_d_annulation = trim($alias_d_annulation);
if(empty($alias_d_annulation)){$alias_d_annulation="-";}
$euuh = trim($euuh);
if(empty($euuh)){$euuh="-";}
$texte = trim($texte);
if(empty($texte)){$texte="-";}
$severi = trim($severi);
if($severi=="0"){$style="color:#009933; background-color:#ffffff; font-weight:bold; font-size:11px; font-family:ARIAL;";}
elseif($severi=="1"){$style="color:#0033ff; background-color:#ffffff; font-weight:bold; font-size:11px; font-family:ARIAL;";}
elseif($severi=="2"){$style="color:#ff9900; background-color:#ffffff; font-weight:bold; font-size:11px; font-family:ARIAL;";}
elseif($severi=="3"){$style="color:#cc3300; background-color:#ffffff; font-weight:bold; font-size:11px; font-family:ARIAL;";}
elseif($severi=="4"){$style="color:#ff0000; background-color:#ffffff; font-weight:bold; font-size:11px; font-family:ARIAL;";}
echo "<tr>";
echo "<td style='".$style."'>".$ident."</td>";
echo "<td style='".$style."'>".$ident_annul."</td>";
echo "<td style='".$style."'>".$severi."</td>";
echo "<td style='".$style."'>".$s_machine."</td>";
echo "<td style='".$style."'>".$s_objet."</td>";
echo "<td style='".$style."'>".$s_proj."</td>";
echo "<td style='".$style."'>".$s_appl."</td>";
echo "<td style='".$style."'>".$d_reception."</td>";
echo "<td style='".$style."'>".$d_prise_en_compte."</td>";
echo "<td style='".$style."'>".$alias_d_annulation."</td>";
echo "<td style='".$style."'>".$euuh."</td>";
echo "<td style='".$style."'>".$texte."</td>";
echo "</tr>";
}
echo "</table>";
?>
</body>
</html> |
Partager