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
| function display_frequenceVoyageTrajet()
{
$query=$this->db->query("SELECT trajet_Voyage, imm_Camion,year(dateBL_Voyage) AS Year, CASE month(dateBL_Voyage)
WHEN 1 THEN 'Janvier'
WHEN 2 THEN 'Fevrier'
WHEN 3 THEN 'Mars'
WHEN 4 THEN 'Avril'
WHEN 5 THEN 'Mai'
WHEN 6 THEN 'Juin'
WHEN 7 THEN 'Juillet'
WHEN 8 THEN 'Août'
WHEN 9 THEN 'Steptembre'
WHEN 10 THEN 'Octobre'
WHEN 11 THEN 'Novembre'
WHEN 12 THEN 'Decembre'
END AS `monthname`,MONTH(dateBL_Voyage) `month`, COUNT(*) as frequence FROM voyage GROUP BY trajet_Voyage,imm_Camion,year(dateBL_Voyage), DATE_FORMAT(`dateBL_Voyage`, '%M') ORDER BY MONTH(dateBL_Voyage),year(dateBL_Voyage)");
return $query->result();}
function display_frequenceVoyageTrajet1()
{
$query1=$this->db->query("SELECT imm_Camion FROM camion");
return $query1->result();
}
function display_frequenceVoyageTrajet2()
{
$query2=$this->db->query("SELECT COUNT(*) as total FROM camion");
return $query2->result();
} |
Partager