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
|
<div>
<ul id="navigation">
<?php
function toMonthFR($a){
$tmpdate = explode(" ",$a);
$thedate = explode("-",$tmpdate[0]);
$theday = $thedate[2];
$themonth = $thedate[1];
$theyear = $thedate[0];
$year = array("Janvier","Fevrier","Mars","Avril","Mai","Jujn","Juillet","Aout","Septembre","Octobre","Novembre","Decembre");
for($i = 0; $i <= 11; $i++){
if($tmpdate[1] == ""){
return($year[$themonth-1]);
}else{
return($year[$themonth-1]);
}
}
}
//Mois de la presta
$query_liste_rapport = "SELECT date_rapport,id_rapport_position FROM rapport_position WHERE id_prestation ='$presta' GROUP BY date_rapport ORDER BY date_rapport DESC";
$liste_rapport = $cx->prepare($query_liste_rapport);
$liste_rapport->execute();
$result_liste_rapport = $liste_rapport->fetchAll(PDO::FETCH_ASSOC);
//print_r($result_liste_rapport);
foreach($result_liste_rapport as $value => $key){
if(toMonthFR($result_liste_rapport[$value]['date_rapport']) != toMonthFR($result_liste_rapport[$value-1]['date_rapport'])){
echo "<li class='toggleSubMenu'>".toMonthFR($result_liste_rapport[$value]['date_rapport'])."<ul class='subMenu'>";
echo "<li>".$result_liste_rapport[$value]['date_rapport']."</li></ul></li>";
}else{
echo "<li>".$result_liste_rapport[$value]['date_rapport']."</li></ul></li>";
}
}
?>
</ul>
</div> |
Partager