modules/geoloc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2009 Polytechnique.org                              *
   4  *  http://opensource.polytechnique.org/                                   *
   5  *                                                                         *
   6  *  This program is free software; you can redistribute it and/or modify   *
   7  *  it under the terms of the GNU General Public License as published by   *
   8  *  the Free Software Foundation; either version 2 of the License, or      *
   9  *  (at your option) any later version.                                    *
  10  *                                                                         *
  11  *  This program is distributed in the hope that it will be useful,        *
  12  *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
  13  *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
  14  *  GNU General Public License for more details.                           *
  15  *                                                                         *
  16  *  You should have received a copy of the GNU General Public License      *
  17  *  along with this program; if not, write to the Free Software            *
  18  *  Foundation, Inc.,                                                      *
  19  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  20  ***************************************************************************/
  21
  22 class GeolocModule extends PLModule
  23 {
  24     function handlers()
  25     {
  26         return array(
  27             'geoloc'             => $this->make_hook('default', AUTH_COOKIE),
  28             'admin/geoloc'           => $this->make_hook('admin', AUTH_MDP, 'admin'),
  29             'admin/geoloc/dynamap'   => $this->make_hook('admin_dynamap', AUTH_MDP, 'admin'),
  30         );
  31     }
  32
  33     function handler_default(&$page, $action = null, $subaction = null)
  34     {
  35         global $globals;
  36
  37         $set = new UserSet();
  38         $set->addMod('geoloc', 'Geolocalisation', true);
  39         $set->apply('geoloc', $page, $action, $subaction);
  40     }
  41
  42     function handler_admin(&$page, $action = false) {
  43         $page->changeTpl('geoloc/admin.tpl');
  44         require_once("geoloc.inc.php");
  45         $page->setTitle('Administration - Geolocalisation');
  46
  47         $nb_synchro = 0;
  48
  49         if (Env::has('id') && is_numeric(Env::v('id'))) {
  50             if (synchro_city(Env::v('id'))) $nb_synchro ++;
  51         }
  52
  53         if ($action == 'missinglat') {
  54             $res = XDB::iterRow("SELECT id FROM geoloc_city WHERE lat = 0 AND lon = 0");
  55             while ($a = $res->next()) if (synchro_city($a[0])) $nb_synchro++;
  56         }
  57
  58         if ($nb_synchro)
  59             $page->trigSuccess(($nb_synchro > 1)?($nb_synchro." villes ont été synchronisées"):"Une ville a été synchronisée");
  60
  61         $res = XDB::query("SELECT COUNT(*) FROM geoloc_city WHERE lat = 0 AND lon = 0");
  62         $page->assign("nb_missinglat", $res->fetchOneCell());
  63     }
  64
  65     function handler_admin_dynamap(&$page, $action = false) {
  66         $page->changeTpl('geoloc/admin_dynamap.tpl');
  67
  68         if ($action == 'cities_not_on_map') {
  69             require_once('geoloc.inc.php');
  70             if (!fix_cities_not_on_map(20))
  71                 $page->trigError("Impossible d'accéder au webservice");
  72             else
  73                 $refresh = true;
  74         }
  75
  76         if ($action == 'smallest_maps') {
  77             require_once('geoloc.inc.php');
  78             set_smallest_levels();
  79         }
  80
  81         if ($action == 'precise_coordinates') {
  82             XDB::execute("UPDATE  adresses AS a
  83                       INNER JOIN  geoloc_city AS c ON(a.cityid = c.id)
  84                              SET  a.glat = c.lat / 100000, a.glng = c.lon / 100000");
  85         }
  86
  87         if ($action == 'newmaps') {
  88             require_once('geoloc.inc.php');
  89             if (!get_new_maps(Env::v('url')))
  90                 $page->trigError("Impossible d'accéder aux nouvelles cartes");
  91         }
  92
  93         $countMissing = XDB::query("SELECT COUNT(*) FROM geoloc_city AS c LEFT JOIN geoloc_city_in_maps AS m ON(c.id = m.city_id) WHERE m.city_id IS NULL");
  94         $missing = $countMissing->fetchOneCell();
  95
  96         $countNoSmallest = XDB::query("SELECT SUM(IF(infos = 'smallest',1,0)) AS n FROM geoloc_city_in_maps GROUP BY city_id ORDER BY n");
  97         $noSmallest = $countNoSmallest->fetchOneCell() == 0;
  98
  99         $countNoCoordinates = XDB::query("SELECT COUNT(*) FROM adresses WHERE cityid IS NOT NULL AND glat = 0 AND glng = 0");
 100         $noCoordinates = $countNoCoordinates->fetchOneCell();
 101
 102         if (isset($refresh) && $missing) {
 103             $page->assign("pl_extra_header", "<meta http-equiv='Refresh' content='3'/>");
 104         }
 105         $page->assign("nb_cities_not_on_map", $missing);
 106         $page->assign("no_smallest", $noSmallest);
 107         $page->assign("no_coordinates", $noCoordinates);
 108     }
 109
 110 }
 111
 112 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 113 ?>