Line 50... |
Line 50... |
50 |
$this->envoyer($info);
|
50 |
$this->envoyer($info);
|
51 |
}
|
51 |
}
|
52 |
}
|
52 |
}
|
Line 53... |
Line 53... |
53 |
|
53 |
|
- |
|
54 |
private function getEvolImgLieesParMois($param) {
|
- |
|
55 |
$utilisateur = isset($_GET['utilisateur']) ? $this->bdd->quote($_GET['utilisateur']) : null;
|
54 |
private function getEvolImgLieesParMois($param) {
|
56 |
|
55 |
// Récupération des données
|
57 |
// Récupération des données
|
56 |
$requete = "SELECT DATE_FORMAT(ci_meta_date_ajout, '%Y%m') AS periode, COUNT(ci_id_image) AS nbre ".
|
58 |
$requete = "SELECT DATE_FORMAT(ci_meta_date_ajout, '%Y%m') AS periode, COUNT(ci_id_image) AS nbre ".
|
57 |
"FROM cel_obs_images LEFT JOIN cel_images ON (coi_ce_image = ci_id_image) ".
|
59 |
"FROM cel_obs_images LEFT JOIN cel_images ON (coi_ce_image = ci_id_image) ".
|
- |
|
60 |
"WHERE ci_meta_date_ajout != '0000-00-00 00:00:00' ".
|
58 |
"WHERE ci_meta_date_ajout != '0000-00-00 00:00:00' ".
|
61 |
((isset($utilisateur)) ? " AND ci_ce_utilisateur = $utilisateur " : '').
|
59 |
'GROUP BY periode '.
|
62 |
'GROUP BY periode '.
|
60 |
'ORDER BY periode ';
|
63 |
'ORDER BY periode ';
|
Line 61... |
Line 64... |
61 |
$resulats = $this->executerRequete($requete);
|
64 |
$resulats = $this->executerRequete($requete);
|
Line 117... |
Line 120... |
117 |
'chxs' => '0,007F00|4,99CC00');
|
120 |
'chxs' => '0,007F00|4,99CC00');
|
118 |
return $graph;
|
121 |
return $graph;
|
119 |
}
|
122 |
}
|
Line 120... |
Line 123... |
120 |
|
123 |
|
- |
|
124 |
private function getEvolImgParMois($param) {
|
- |
|
125 |
$utilisateur = isset($_GET['utilisateur']) ? $this->bdd->quote($_GET['utilisateur']) : null;
|
121 |
private function getEvolImgParMois($param) {
|
126 |
|
122 |
// Récupération des données
|
127 |
// Récupération des données
|
123 |
$requete = "SELECT DATE_FORMAT(ci_meta_date_ajout, '%Y%m') AS periode, COUNT(ci_id_image) AS nbre ".
|
128 |
$requete = "SELECT DATE_FORMAT(ci_meta_date_ajout, '%Y%m') AS periode, COUNT(ci_id_image) AS nbre ".
|
124 |
"FROM cel_images ".
|
129 |
"FROM cel_images ".
|
- |
|
130 |
"WHERE ci_meta_date_ajout != '0000-00-00 00:00:00' ".
|
125 |
"WHERE ci_meta_date_ajout != '0000-00-00 00:00:00' ".
|
131 |
((isset($utilisateur)) ? " AND ci_ce_utilisateur = $utilisateur " : '').
|
126 |
'GROUP BY periode '.
|
132 |
'GROUP BY periode '.
|
127 |
'ORDER BY periode ';
|
133 |
'ORDER BY periode ';
|
Line 128... |
Line 134... |
128 |
$resulats = $this->executerRequete($requete);
|
134 |
$resulats = $this->executerRequete($requete);
|
Line 507... |
Line 513... |
507 |
'chts' => '000000,12');
|
513 |
'chts' => '000000,12');
|
508 |
return $graph;
|
514 |
return $graph;
|
509 |
}
|
515 |
}
|
Line 510... |
Line 516... |
510 |
|
516 |
|
511 |
private function getNbreObsAvecIndicationGeo($param) {
|
- |
|
512 |
$utilisateur = isset($_GET['utilisateur']) ? ' AND identifiant = '.$this->bdd->quote($_GET['utilisateur']) : '';
|
- |
|
513 |
|
517 |
private function getNbreObsAvecIndicationGeo($param) {
|
514 |
// Récupération des données
|
518 |
// Récupération des données
|
515 |
$total = $this->executerRequeteNombre('cel_inventory', 'id', $utilisateur);
|
519 |
$total = $this->executerRequeteNombre('cel_inventory', 'id');
|
516 |
$where_commune = "location != '000null' AND location != '' AND location IS NOT NULL";
|
520 |
$where_commune = $this->creerWhereIndicationGeo('location');
|
- |
|
521 |
$obs['commune'] = $this->executerRequeteNombre('cel_inventory', 'id', $where_commune);
|
517 |
$obs['commune'] = $this->executerRequeteNombre('cel_inventory', 'id', $where_commune);
|
522 |
$where_commune_id = $this->creerWhereIndicationGeo('id_location');
|
- |
|
523 |
$obs['commune identifiée'] = $this->executerRequeteNombre('cel_inventory', 'id', $where_commune_id);
|
518 |
$obs['commune identifiée'] = $this->executerRequeteNombre('cel_inventory', 'id', "id_location != '000null' AND id_location != '' AND id_location IS NOT NULL");
|
524 |
$where_lieudit = $this->creerWhereIndicationGeo('lieudit');
|
- |
|
525 |
$obs['lieu-dit'] = $this->executerRequeteNombre('cel_inventory', 'id', $where_lieudit);
|
519 |
$obs['lieu-dit'] = $this->executerRequeteNombre('cel_inventory', 'id', "lieudit != '000null' AND lieudit != '' AND lieudit IS NOT NULL");
|
526 |
$where_station = $this->creerWhereIndicationGeo('station');
|
- |
|
527 |
$obs['station'] = $this->executerRequeteNombre('cel_inventory', 'id', $where_station);
|
520 |
$obs['station'] = $this->executerRequeteNombre('cel_inventory', 'id', "station != '000null' AND station != '' AND station IS NOT NULL");
|
528 |
$where_milieu = $this->creerWhereIndicationGeo('milieu');
|
- |
|
529 |
$obs['milieu'] = $this->executerRequeteNombre('cel_inventory', 'id', $where_milieu);
|
521 |
$obs['milieu'] = $this->executerRequeteNombre('cel_inventory', 'id', "milieu != '000null' AND milieu != '' AND milieu IS NOT NULL");
|
530 |
$where_xy = $this->creerWhereIndicationGeo('coord_x').' AND '.$this->creerWhereIndicationGeo('coord_y');
|
Line 522... |
Line 531... |
522 |
$obs['coordonnée'] = $this->executerRequeteNombre('cel_inventory', 'id', "coord_x != '000null' AND coord_x != '' AND coord_x IS NOT NULL AND coord_y != '000null' AND coord_y != '' AND coord_y IS NOT NULL");
|
531 |
$obs['coordonnée'] = $this->executerRequeteNombre('cel_inventory', 'id', $where_xy);
|
523 |
|
532 |
|
524 |
$donnees = array();
|
533 |
$donnees = array();
|
525 |
$num = 1;
|
534 |
$num = 1;
|
Line 551... |
Line 560... |
551 |
//'chxp' => '1,0,20,40,60,80,100',// Grille sous forme de cible
|
560 |
//'chxp' => '1,0,20,40,60,80,100',// Grille sous forme de cible
|
552 |
'chm' => 'B,FF000080,0,1.0,5.0');
|
561 |
'chm' => 'B,FF000080,0,1.0,5.0');
|
553 |
return $graph;
|
562 |
return $graph;
|
554 |
}
|
563 |
}
|
Line -... |
Line 564... |
- |
|
564 |
|
- |
|
565 |
private function creerWhereIndicationGeo($champ) {
|
- |
|
566 |
$where = null;
|
- |
|
567 |
if (isset($champ)) {
|
- |
|
568 |
$where = "$champ != '000null' ".
|
- |
|
569 |
"AND $champ != '' ".
|
- |
|
570 |
"AND $champ IS NOT NULL ";
|
- |
|
571 |
}
|
- |
|
572 |
return $where;
|
- |
|
573 |
}
|
555 |
|
574 |
|
556 |
private function getUtilisationJournaliere($param) {
|
575 |
private function getUtilisationJournaliere($param) {
|
557 |
// Sur quel jour, voulons nous estimer l'utilisation
|
576 |
// Sur quel jour, voulons nous estimer l'utilisation
|
558 |
$aujourdhui = date('Y-m-d');
|
577 |
$aujourdhui = date('Y-m-d');
|
559 |
if (isset($param[0]) && preg_match('/^[0-9]{4}(?:-[0-9]{2}){2}$/', $param[0])) {
|
578 |
if (isset($param[0]) && preg_match('/^[0-9]{4}(?:-[0-9]{2}){2}$/', $param[0])) {
|
Line 568... |
Line 587... |
568 |
$max_obs[] = $this->executerRequeteEvol('cel_inventory', 'id', '%Y%m%d',
|
587 |
$max_obs[] = $this->executerRequeteEvol('cel_inventory', 'id', '%Y%m%d',
|
569 |
"date_modification NOT LIKE '$aujourdhui%' ", 'date_modification');
|
588 |
"date_modification NOT LIKE '$aujourdhui%' ", 'date_modification');
|
570 |
$max_obs[] = $this->executerRequeteEvol('cel_inventory', 'id', '%Y%m%d',
|
589 |
$max_obs[] = $this->executerRequeteEvol('cel_inventory', 'id', '%Y%m%d',
|
571 |
"date_transmission NOT LIKE '$aujourdhui%' ", 'date_transmission');
|
590 |
"date_transmission NOT LIKE '$aujourdhui%' ", 'date_transmission');
|
572 |
$obs_aujourdhui = $this->executerRequeteNombre('cel_inventory', 'id',
|
591 |
$obs_aujourdhui = $this->executerRequeteNombre('cel_inventory', 'id',
|
573 |
"date_creation LIKE '$aujourdhui%'
|
592 |
"(date_creation LIKE '$aujourdhui%'
|
574 |
OR date_modification LIKE '$aujourdhui%'
|
593 |
OR date_modification LIKE '$aujourdhui%'
|
575 |
OR date_transmission LIKE '$aujourdhui%' ");
|
594 |
OR date_transmission LIKE '$aujourdhui%') ");
|
Line 576... |
Line 595... |
576 |
|
595 |
|
577 |
// Cummul des obs crées, modifiées, transmises par jour
|
596 |
// Cummul des obs crées, modifiées, transmises par jour
|
578 |
$donnees = array();
|
597 |
$donnees = array();
|
579 |
foreach ($max_obs as $obs_par_jour) {
|
598 |
foreach ($max_obs as $obs_par_jour) {
|
Line 586... |
Line 605... |
586 |
}
|
605 |
}
|
587 |
}
|
606 |
}
|
Line 588... |
Line 607... |
588 |
|
607 |
|
589 |
// Post traitement des données
|
608 |
// Post traitement des données
|
590 |
$valeur = $obs_aujourdhui;
|
609 |
$valeur = $obs_aujourdhui;
|
591 |
$valeur_max = 400;max($donnees);
|
610 |
$valeur_max = 400;
|
592 |
if ($valeur > $valeur_max) {
|
611 |
if ($valeur > $valeur_max) {
|
593 |
$pourcentage = 100;
|
612 |
$pourcentage = 100;
|
594 |
} else {
|
613 |
} else {
|
595 |
$pourcentage = round(($valeur / ($valeur_max / 100)), 0);
|
614 |
$pourcentage = round(($valeur / ($valeur_max / 100)), 0);
|
Line 907... |
Line 926... |
907 |
$utilisateur = isset($_GET['utilisateur']) ? $this->bdd->quote($_GET['utilisateur']) : false;
|
926 |
$utilisateur = isset($_GET['utilisateur']) ? $this->bdd->quote($_GET['utilisateur']) : false;
|
Line 908... |
Line 927... |
908 |
|
927 |
|
909 |
$requete = "SELECT DATE_FORMAT($champ_date, '$format_date') AS periode, COUNT($champ) AS nbre ".
|
928 |
$requete = "SELECT DATE_FORMAT($champ_date, '$format_date') AS periode, COUNT($champ) AS nbre ".
|
910 |
"FROM $table ".
|
929 |
"FROM $table ".
|
911 |
"WHERE $champ_date != '0000-00-00 00:00:00' ".
|
930 |
"WHERE $champ_date != '0000-00-00 00:00:00' ".
|
912 |
($utilisateur ? " AND identifiant = $utilisateur " : '').
|
931 |
(($utilisateur != false) ? " AND identifiant = $utilisateur " : '').
|
913 |
((is_null($where)) ? '' : " AND $where ").
|
932 |
((is_null($where)) ? '' : " AND $where ").
|
914 |
'GROUP BY periode '.
|
933 |
'GROUP BY periode '.
|
915 |
((is_null($order_by)) ? '' : "ORDER BY $order_by ");
|
934 |
((is_null($order_by)) ? '' : "ORDER BY $order_by ");
|
916 |
((is_null($limit)) ? '' : "LIMIT $limit ");
|
935 |
((is_null($limit)) ? '' : "LIMIT $limit ");
|
Line 924... |
Line 943... |
924 |
|
943 |
|
925 |
return $donnees_traitees;
|
944 |
return $donnees_traitees;
|
Line 926... |
Line 945... |
926 |
}
|
945 |
}
|
- |
|
946 |
|
- |
|
947 |
private function executerRequeteNombre($table, $champ, $where = null) {
|
- |
|
948 |
$utilisateur = null;
|
- |
|
949 |
if (isset($_GET['utilisateur'])) {
|
- |
|
950 |
$utilisateur = $this->bdd->quote($_GET['utilisateur']);
|
- |
|
951 |
$where .= isset($where) ? ' AND ' : '';
|
- |
|
952 |
$where .= "identifiant = $utilisateur ";
|
927 |
|
953 |
}
|
928 |
private function executerRequeteNombre($table, $champ, $where = null) {
|
954 |
|
929 |
$requete = "SELECT COUNT($champ) AS nbre ".
|
955 |
$requete = "SELECT COUNT($champ) AS nbre ".
|
- |
|
956 |
"FROM $table ".
|
930 |
"FROM $table ".
|
957 |
((isset($where)) ? "WHERE $where " : '');
|
931 |
((is_null($where)) ? '' : "WHERE $where ");
|
958 |
|
932 |
$nbre = $this->executerRequete($requete, 'Column');
|
959 |
$nbre = $this->executerRequete($requete, 'Column');
|
933 |
return $nbre;
|
960 |
return $nbre;
|
934 |
}
|
961 |
}
|