New file |
0,0 → 1,41 |
<?php |
// declare(encoding='UTF-8'); |
/** |
* Script gérant les statistiques de DEL. |
* |
* @category DEL |
* @package Scripts |
* @subpackage Stats |
* @author Mathias CHOUET <mathias@tela-botanica.org> |
* @author Jean-Pascal MILCENT <jpm@tela-botanica.org> |
* @author Aurelien PERONNET <aurelien@tela-botanica.org> |
* @license GPL v3 <http://www.gnu.org/licenses/gpl.txt> |
* @license CECILL v2 <http://www.cecill.info/licences/Licence_CeCILL_V2-en.txt> |
* @copyright 1999-2014 Tela Botanica <accueil@tela-botanica.org> |
*/ |
class Stats extends DelScript { |
|
public function executer() { |
$this->mettreAJourStats(); |
} |
|
/** |
* Met à jour la table des statistiques en la vidant et en recalculant la moyenne pondérée, |
* le nombre de votes et le nombre de points pour chaque image - utilise "commun". |
* Attention, c'est over-pas-optimisé, ça prend du temps ! |
*/ |
private function mettreAJourStats() { |
$requete = "SELECT id_image FROM del_image ORDER BY id_image ASC"; |
$ids = $this->getBdd()->recupererTous($requete); |
|
$requete = "SELECT id_protocole FROM del_image_protocole ORDER BY id_protocole ASC"; |
$protos = $this->getBdd()->recupererTous($requete); |
|
foreach ($ids as $id) { |
echo "ID: " . $id['id_image'] . "\n"; |
foreach ($protos as $proto) { |
TelaBotanica\Del\Commun\Stats::updateStats($this->getBdd(), $id['id_image'], $proto['id_protocole']); |
} |
} |
} |
} |