function Aff_feed_closeTab ($mode, $filter,$tri) {
global $mnuchoice;
// Recherche dans la table maint_task si il existe des demandes en attente de traitement
$filter= mktime(0, 0, 0, 10, 0, 2010);
$sens = "ASC";
if ( $tri == "emetteur") $tri="Owner";
elseif ( $tri == "prisencharge") $tri="Author";
else { $tri="OpenTimeStamp"; $sens = "DESC"; }
$cols = array(
"Rid"=>"N°",
"Owner"=>"Emetteur",
"Author"=>"Traité par",
"Room"=>"Salle",
"NumComp"=>"Ordi.",
"Mark"=>"Marque",
"Os"=>"Os",
"Cat"=>"Origine",
"Content"=>"Demande",
"OpenTimeStamp"=>"Date",
"TakeTimeStamp"=>"PeC.",
"CloseTimeStamp"=>"Clôture",
"BoosTimeStamp"=>"Relance",
"TimeLife"=>"Temps",
"Cost"=>"Coût"
);
Aff_tHead($cols );
$requete = mysql_query("SELECT * FROM maint_task WHERE (OpenTimeStamp>$filter AND Acq='2' ) ORDER BY $tri $sens");
while($row = mysql_fetch_array($requete)) {
$Rid=$row["Rid"];
$cout=0;
$requete1 = mysql_query("SELECT * FROM maint_thread WHERE (TopRid='$Rid')");
// Affichage du feed du rapport d'intervention
$comments="";
while($row1 = mysql_fetch_array($requete1)) {
$timelife = $row1['TimeLife'] == 0 ? 5 : $timelife+$row1['TimeLife'];
$cout = $row1['Cost'] == 0 ? $cout : $cout+$row1['Cost'];
$comments .= "<div class=\"bold\">Réponse du ".dateFR( $row1['TimeStamp'])."</div>";
$comments .= "<div >".$row1['Content']."</div><hr/>";
}
$html .= "<tr>";
$tempsPasse = intval($row['CloseTimeStamp']) - intval($row['TakeTimeStamp']);
foreach($cols as $k=>$col) {
$hTd = "<td ";
if( $k=="Rid")
$hTd .= " class=\"collapsible\" rowspan=\"2\"";
if( $k=="Owner" || $k=="Author" || $k=="Room" || $k=="NumComp" || $k=="Os" || $k=="Mark" )
$hTd .= " rowspan=\"2\"";
if( $k=="Cat" )
$hTd .= " class=\"collapsible_alt\" rowspan=\"2\"";
// if($col=="OwnerMail")
if($k=="Owner") $hTd .= " title=\"".$row['OwnerMail']."\">".$row[$k]."</td>";
else if($k=="Room") $hTd .= "title=\"Secteur : ".$row['Sector'].", Bat : ".valid_utf8($row['Bat'])."\">".valid_utf8($row[$k]) ."</td>";
else if($k=="BoosTimeStamp" ){ $rl=$row[$k] ==0?0:1;$hTd .= " title=\"Date : ".strftime("%d-%m-%Y - %H.%M",$row["BoosTimeStamp"])."\">".$rl."</td>";}
else if($k=="Content") {
$ctnt = test_utf8( $row[$k] ) ? $row[$k] : utf8_encode($row[$k]);
$hTd .= "title=\"Secteur : ".$row['Sector'].", Bat : ".$row['Bat']."\" style=\"width: 265px;\">".$ctnt."</td>";
}
else if($k=="OpenTimeStamp") $hTd .= "> ".dateFR( $row["OpenTimeStamp"])." </td>";
else if($k=="CloseTimeStamp") $hTd .= "> ".dateFR( $row["CloseTimeStamp"])." </td>";
else if($k=="TakeTimeStamp") $hTd .= "> ".dateFR( $row["TakeTimeStamp"])." </td>";
else if($k=="TimeLife") $hTd .= ">".intval($timelife)." mn </td>";
else if($k=="Cost") $hTd .= ">".$cout." €</td>";
else {
$ctnt = test_utf8( $row[$k] ) ? $row[$k] : utf8_encode($row[$k]);
$hTd .= ">".$ctnt ."</td>\n";
}
$html .= $hTd;
}
$html .= "</tr>";
$html .= "<tr class=\"expand-child\">";
$html .= "<td style=\"display: none;\" colspan=\"7\">";
$html .= test_utf8( $comments ) ? $comments : utf8_encode( $comments );
$html .= "</td></tr>";
} //fin du while
$html .= "</tbody>";
$html .= "</table>";
echo $html;
}
<div class="box-body">
<dl class="dl-horizontal">
<dt>Adhérent </dt><dd><?php
echo $prenom . " " . $nom;
?>
</dd>
<dt>Date de 1er adhésion</dt><dd> le <span class="text-success"><b><?php
echo dateFR($dateinsc);
?>
</b></span></dd>
<dt>Tarif</dt><dd><span class="text-success"><b><?php
echo $prixtarif;
?>
</b></span>.</dd>
<dt>Renouvellement prévu </dt><dd> le <span class="text-red"><b><?php
echo dateFR($daterenouv);
?>
</b></span></dd>
</dl>
<?php
if (mysqli_num_rows($paiementAttente)) {
$row = mysqli_fetch_array($paiementAttente);
if (in_array($tarif, $row)) {
echo "<p class=\"lead\"><span class=\"text-red\">Attention le paiement est toujours en attente</span></p>\n\t\t\t\t <a href=\"index.php?a=21&b=3&typetransac=adh&idtransac=" . $row["id_transac"] . "&iduser="******" \"><input type=\"submit\" value=\"Encaisser\" class=\"btn bg-default\"></a>\n\t\t\t\t";
}
}
?>
</div>
<div class="box-footer">
<?php
<div id="container1">
<table style="width:100%;">
<?php
$db = new PDO('mysql:host=' . $mysql_hostname . ';dbname=' . $mysql_database, $mysql_username, $mysql_password);
$sql = "SELECT * FROM `web_task` ORDER BY `task_level` DESC";
$req = $db->prepare($sql);
$req->execute();
$req->setFetchMode(PDO::FETCH_ASSOC);
while ($row = $req->fetch()) {
echo '<div class="cnt">';
echo '<div id="title">' . utf8_encode(stripslashes($row['task_name'])) . '</div>';
echo '<div id="status">' . getTranslation($row['task_level'] . "_tlevel") . '</div>';
echo '<div style="clear:both;"></div>';
echo '<div id="more">';
echo '<div id="creator">Tache créée par : ' . $dev->getName($row['uuid_creator']) . '</div>';
echo '<div id="date">' . dateFR($row['date_created']) . '</div>';
echo '<div style="clear:both;"></div>';
echo '</br>';
echo '<div id="desc">' . getHTMLfromBB($row['task_desc']) . '</div>';
echo '</div>';
echo '</div>';
}
?>
</table>
</div>
<div id="container2"></div>
</div>
</div>
</body>
</html>
