| Line 51... |
Line 51... |
| 51 |
$this->envoyer($info);
|
51 |
$this->envoyer($info);
|
| 52 |
}
|
52 |
}
|
| 53 |
}
|
53 |
}
|
| Line 54... |
Line 54... |
| 54 |
|
54 |
|
| 55 |
private function getEvolImgLieesParMois($param) {
|
55 |
private function getEvolImgLieesParMois($param) {
|
| Line 56... |
Line 56... |
| 56 |
$utilisateur = isset($_GET['utilisateur']) ? $this->bdd->quote($_GET['utilisateur']) : null;
|
56 |
$utilisateur = isset($_GET['utilisateur']) ? Cel::db()->quote($_GET['utilisateur']) : null;
|
| 57 |
|
57 |
|
| 58 |
// Récupération des données
|
58 |
// Récupération des données
|
| 59 |
$requete = "SELECT DATE_FORMAT(date_creation, '%Y%m') AS periode, COUNT(ci.id_image) AS nbre ".
|
59 |
$requete = "SELECT DATE_FORMAT(date_creation, '%Y%m') AS periode, COUNT(ci.id_image) AS nbre ".
|
| Line 122... |
Line 122... |
| 122 |
'chxs' => '0,007F00|4,99CC00');
|
122 |
'chxs' => '0,007F00|4,99CC00');
|
| 123 |
return $graph;
|
123 |
return $graph;
|
| 124 |
}
|
124 |
}
|
| Line 125... |
Line 125... |
| 125 |
|
125 |
|
| 126 |
private function getEvolImgParMois($param) {
|
126 |
private function getEvolImgParMois($param) {
|
| Line 127... |
Line 127... |
| 127 |
$utilisateur = isset($_GET['utilisateur']) ? $this->bdd->quote($_GET['utilisateur']) : null;
|
127 |
$utilisateur = isset($_GET['utilisateur']) ? Cel::db()->quote($_GET['utilisateur']) : null;
|
| 128 |
|
128 |
|
| 129 |
// Récupération des données
|
129 |
// Récupération des données
|
| 130 |
$requete = "SELECT DATE_FORMAT(date_creation, '%Y%m') AS periode, COUNT(id_image) AS nbre ".
|
130 |
$requete = "SELECT DATE_FORMAT(date_creation, '%Y%m') AS periode, COUNT(id_image) AS nbre ".
|
| Line 777... |
Line 777... |
| 777 |
//echo '<pre>'.print_r($graph,true).'</pre>';
|
777 |
//echo '<pre>'.print_r($graph,true).'</pre>';
|
| 778 |
return $graph;
|
778 |
return $graph;
|
| 779 |
}
|
779 |
}
|
| Line 780... |
Line 780... |
| 780 |
|
780 |
|
| 781 |
private function getNuagePointsObsParHeureEtJourSemaine($param) {
|
781 |
private function getNuagePointsObsParHeureEtJourSemaine($param) {
|
| Line 782... |
Line 782... |
| 782 |
$utilisateur = isset($_GET['utilisateur']) ? $this->bdd->quote($_GET['utilisateur']) : false;
|
782 |
$utilisateur = isset($_GET['utilisateur']) ? Cel::db()->quote($_GET['utilisateur']) : false;
|
| 783 |
|
783 |
|
| 784 |
// Récupération des données de la base
|
784 |
// Récupération des données de la base
|
| 785 |
$requete = 'SELECT courriel_utilisateur, DATE_FORMAT(date_creation, "%w-%H") AS periode, (ROUND(LOG10(COUNT(id_observation))) + 1) AS nbre '.
|
785 |
$requete = 'SELECT courriel_utilisateur, DATE_FORMAT(date_creation, "%w-%H") AS periode, (ROUND(LOG10(COUNT(id_observation))) + 1) AS nbre '.
|
| Line 925... |
Line 925... |
| 925 |
//echo '<pre>'.print_r($graph,true).'</pre>';
|
925 |
//echo '<pre>'.print_r($graph,true).'</pre>';
|
| 926 |
return $graph;
|
926 |
return $graph;
|
| 927 |
}
|
927 |
}
|
| Line 928... |
Line 928... |
| 928 |
|
928 |
|
| 929 |
private function executerRequeteEvol($table, $champ, $format_date = '%Y%m', $where = null, $champ_date = 'date_creation', $order_by = null, $limit = null) {
|
929 |
private function executerRequeteEvol($table, $champ, $format_date = '%Y%m', $where = null, $champ_date = 'date_creation', $order_by = null, $limit = null) {
|
| Line 930... |
Line 930... |
| 930 |
$utilisateur = isset($_GET['utilisateur']) ? $this->bdd->quote($_GET['utilisateur']) : false;
|
930 |
$utilisateur = isset($_GET['utilisateur']) ? Cel::db()->quote($_GET['utilisateur']) : false;
|
| 931 |
|
931 |
|
| 932 |
$requete = "SELECT DATE_FORMAT($champ_date, '$format_date') AS periode, COUNT($champ) AS nbre ".
|
932 |
$requete = "SELECT DATE_FORMAT($champ_date, '$format_date') AS periode, COUNT($champ) AS nbre ".
|
| 933 |
"FROM $table ".
|
933 |
"FROM $table ".
|
| Line 950... |
Line 950... |
| 950 |
}
|
950 |
}
|
| Line 951... |
Line 951... |
| 951 |
|
951 |
|
| 952 |
private function executerRequeteNombre($table, $champ, $where = null) {
|
952 |
private function executerRequeteNombre($table, $champ, $where = null) {
|
| 953 |
$utilisateur = null;
|
953 |
$utilisateur = null;
|
| 954 |
if (isset($_GET['utilisateur'])) {
|
954 |
if (isset($_GET['utilisateur'])) {
|
| 955 |
$utilisateur = $this->bdd->quote($_GET['utilisateur']);
|
955 |
$utilisateur = Cel::db()->quote($_GET['utilisateur']);
|
| 956 |
$where = isset($where) ? $where.' AND ' : '';
|
956 |
$where = isset($where) ? $where.' AND ' : '';
|
| 957 |
$where .= "courriel_utilisateur = $utilisateur ";
|
957 |
$where .= "courriel_utilisateur = $utilisateur ";
|
| Line 958... |
Line 958... |
| 958 |
}
|
958 |
}
|