| Line 428... |
Line 428... |
| 428 |
}
|
428 |
}
|
| Line 429... |
Line 429... |
| 429 |
|
429 |
|
| 430 |
$requete = $this->construireRequeteGrandsContributeurs($nombre, $jours, $critere);
|
430 |
$requete = $this->construireRequeteGrandsContributeurs($nombre, $jours, $critere);
|
| Line -... |
Line 431... |
| - |
|
431 |
$resultats = Cel::db()->requeter($requete);
|
| - |
|
432 |
|
| - |
|
433 |
$courriels = array();
|
| - |
|
434 |
foreach ($resultats as $res) {
|
| - |
|
435 |
$courriels[] = $res['courriel_utilisateur'];
|
| - |
|
436 |
}
|
| - |
|
437 |
$identites = $this->recupererUtilisateursIdentite($courriels);
|
| - |
|
438 |
foreach ($resultats as &$res) {
|
| - |
|
439 |
$res['intitule_utilisateur'] = $identites[$res['courriel_utilisateur']]['intitule'];
|
| - |
|
440 |
unset($res['courriel_utilisateur']);
|
| - |
|
441 |
unset($res['nom_utilisateur']);
|
| - |
|
442 |
unset($res['prenom_utilisateur']);
|
| 431 |
$resultats = Cel::db()->requeter($requete);
|
443 |
}
|
| 432 |
|
444 |
|
| 433 |
$retour = array(
|
445 |
$retour = array(
|
| 434 |
'entete' => array(
|
446 |
'entete' => array(
|
| 435 |
'nombre' => intval($nombre),
|
447 |
'nombre' => intval($nombre),
|
| Line 458... |
Line 470... |
| 458 |
case "obs":
|
470 |
case "obs":
|
| 459 |
$req = "SELECT ce_utilisateur , prenom_utilisateur , nom_utilisateur , courriel_utilisateur , count(*) as nombre" .
|
471 |
$req = "SELECT ce_utilisateur , prenom_utilisateur , nom_utilisateur , courriel_utilisateur , count(*) as nombre" .
|
| 460 |
" FROM cel_obs" .
|
472 |
" FROM cel_obs" .
|
| 461 |
" WHERE transmission = 1" .
|
473 |
" WHERE transmission = 1" .
|
| 462 |
" AND TO_DAYS(NOW()) - TO_DAYS(date_transmission) <= $jours" .
|
474 |
" AND TO_DAYS(NOW()) - TO_DAYS(date_transmission) <= $jours" .
|
| 463 |
" GROUP BY courriel_utilisateur ORDER BY nombre DESC LIMIT $nombre;";
|
475 |
" GROUP BY ce_utilisateur ORDER BY nombre DESC LIMIT $nombre;";
|
| 464 |
break;
|
476 |
break;
|
| 465 |
case "img":
|
477 |
case "img":
|
| 466 |
$req = "SELECT co.ce_utilisateur , co.prenom_utilisateur , co.nom_utilisateur , co.courriel_utilisateur , count(DISTINCT ci.id_image) as nombre" .
|
478 |
$req = "SELECT co.ce_utilisateur , co.prenom_utilisateur , co.nom_utilisateur , co.courriel_utilisateur , count(DISTINCT ci.id_image) as nombre" .
|
| 467 |
" FROM cel_images ci" .
|
479 |
" FROM cel_images ci" .
|
| 468 |
" RIGHT JOIN cel_obs_images coi ON coi.id_image = ci.id_image" .
|
480 |
" RIGHT JOIN cel_obs_images coi ON coi.id_image = ci.id_image" .
|
| 469 |
" LEFT JOIN cel_obs co ON coi.id_observation = co.id_observation" .
|
481 |
" LEFT JOIN cel_obs co ON coi.id_observation = co.id_observation" .
|
| 470 |
" WHERE co.transmission = 1" .
|
482 |
" WHERE co.transmission = 1" .
|
| 471 |
" AND TO_DAYS(NOW()) - TO_DAYS(co.date_transmission) <= $jours" .
|
483 |
" AND TO_DAYS(NOW()) - TO_DAYS(co.date_transmission) <= $jours" .
|
| 472 |
" GROUP BY co.courriel_utilisateur ORDER BY nombre DESC LIMIT $nombre;";
|
484 |
" GROUP BY co.ce_utilisateur ORDER BY nombre DESC LIMIT $nombre;";
|
| 473 |
break;
|
485 |
break;
|
| 474 |
default:
|
486 |
default:
|
| 475 |
$req = "SELECT co.ce_utilisateur , co.prenom_utilisateur , co.nom_utilisateur , co.courriel_utilisateur ," .
|
487 |
$req = "SELECT co.ce_utilisateur , co.prenom_utilisateur , co.nom_utilisateur , co.courriel_utilisateur ," .
|
| 476 |
" count(DISTINCT ci.id_image) as nombreImg, count(DISTINCT co.id_observation) as nombreObs," .
|
488 |
" count(DISTINCT ci.id_image) as nombreImg, count(DISTINCT co.id_observation) as nombreObs," .
|
| 477 |
" count(DISTINCT ci.id_image) + count(DISTINCT co.id_observation) as somme" .
|
489 |
" count(DISTINCT ci.id_image) + count(DISTINCT co.id_observation) as somme" .
|
| 478 |
" FROM cel_images ci" .
|
490 |
" FROM cel_images ci" .
|
| 479 |
" RIGHT JOIN cel_obs_images coi ON coi.id_image = ci.id_image" .
|
491 |
" RIGHT JOIN cel_obs_images coi ON coi.id_image = ci.id_image" .
|
| 480 |
" LEFT JOIN cel_obs co ON coi.id_observation = co.id_observation" .
|
492 |
" LEFT JOIN cel_obs co ON coi.id_observation = co.id_observation" .
|
| 481 |
" WHERE co.transmission = 1" .
|
493 |
" WHERE co.transmission = 1" .
|
| 482 |
" AND TO_DAYS(NOW()) - TO_DAYS(co.date_transmission) <= $jours" .
|
494 |
" AND TO_DAYS(NOW()) - TO_DAYS(co.date_transmission) <= $jours" .
|
| 483 |
" GROUP BY co.courriel_utilisateur" .
|
495 |
" GROUP BY co.ce_utilisateur" .
|
| 484 |
" ORDER BY somme DESC LIMIT $nombre;";
|
496 |
" ORDER BY somme DESC LIMIT $nombre;";
|
| 485 |
}
|
497 |
}
|
| Line 486... |
Line 498... |
| 486 |
|
498 |
|
| 487 |
return $req;
|
499 |
return $req;
|