heures_pilote.php

<?php

/**
 * Display informations about the connected pilot
 *
 * PHP version 5
 *
 * Copyright © 2011 Mélissa Djebel
 *
 * This file is part of Galette (http://galette.tuxfamily.org).
 *
 * Plugin Pilote is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with Galette. If not, see <http://www.gnu.org/licenses/>.
 *
 * @category  Plugins
 * @package   GalettePilote
 *
 * @author    Mélissa Djebel <melissa.djebel@gmx.net>
 * @copyright 2011 Mélissa Djebel
 * @license   http://www.gnu.org/licenses/gpl-3.0.html GPL License 3.0 or (at your option) any later version
 * @version   0.7
 * @link      http://galette.tuxfamily.org
 * @since     Available since 0.7
 */
define('GALETTE_BASE_PATH', '../../');
require_once GALETTE_BASE_PATH . 'includes/galette.inc.php';

// Import des classes de notre plugin
require_once '_config.inc.php';

if (!$login->isLogged() || !(PiloteInstructeur::isPiloteInstructeur($login->login) || $login->isAdmin() || $login->isStaff())) {
    header('location: ' . GALETTE_BASE_PATH . 'index.php');
    die();
}

// Récupération du tri
$tri = filter_has_var(INPUT_GET, 'tri') ? filter_input(INPUT_GET, 'tri') : 'nom';
$direction = filter_has_var(INPUT_GET, 'direction') ? filter_input(INPUT_GET, 'direction') : 'asc';
switch ($tri) {
    case 'nom':
        $tri_sql = 'nom_adh';
        break;
    case 'prenom':
        $tri_sql = 'prenom_adh';
        break;
    case 'pseudo':
        $tri_sql = 'login_adh';
        break;
    case 'an-1':
        $tri_sql = 'somme_last_year';
        break;
    case 'an':
        $tri_sql = 'somme_this_year';
        break;
    case 'glissant':
        $tri_sql = 'somme_glissant';
        break;
}
$type_vol = filter_has_var(INPUT_GET, 'type_vol') ? filter_input(INPUT_GET, 'type_vol') : 'all';

$tpl->assign('page_title', _T("HEURES PILOTE.PAGE TITLE"));
//Set the path to the current plugin's templates,
//but backup main Galette's template path before
$orig_template_path = $tpl->template_dir;
$tpl->template_dir = 'templates/' . $preferences->pref_theme;

$adherents = array();
$stats = PiloteOperation::getStatistiquesPilotes($type_vol, $tri_sql, $direction);
foreach ($stats as $ligne) {
    $obj = new stdClass();
    $obj->nom = $ligne->nom_adh;
    $obj->prenom = $ligne->prenom_adh;
    $obj->pseudo = $ligne->login_adh;

    if (!is_null($ligne->somme_last_year)) {
        $nb_h = floor($ligne->somme_last_year / 60);
        $nb_m = $ligne->somme_last_year - $nb_h * 60;
        $obj->somme_last_year = ($nb_h > 0 ? $nb_h . 'h ' : '') . $nb_m . 'min';
    } else {
        $obj->somme_last_year = '';
    }
    if (!is_null($ligne->somme_this_year)) {
        $nb_h = floor($ligne->somme_this_year / 60);
        $nb_m = $ligne->somme_this_year - $nb_h * 60;
        $obj->somme_this_year = ($nb_h > 0 ? $nb_h . 'h ' : '') . $nb_m . 'min';
    } else {
        $obj->somme_this_year = '';
    }
    if (!is_null($ligne->somme_glissant)) {
        $nb_h = floor($ligne->somme_glissant / 60);
        $nb_m = $ligne->somme_glissant - $nb_h * 60;
        $obj->somme_glissant = ($nb_h > 0 ? $nb_h . 'h ' : '') . $nb_m . 'min';
    } else {
        $obj->somme_glissant = '';
    }
    $adherents[] = $obj;
}

$tpl->assign('tri', $tri);
$tpl->assign('direction', $direction);
$tpl->assign('adherents', $adherents);
$tpl->assign('annee_derniere', date('Y', strtotime('-1 years')));
$tpl->assign('cette_annee', date('Y'));
$tpl->assign('an_glissant', date('d/m/Y', strtotime('-1 years')));
$tpl->assign('require_tabs', true);
$tpl->assign('type_vols', PiloteOperation::getTypesVols());
$tpl->assign('type_vol', $type_vol);

$content = $tpl->fetch('heures_pilote.tpl', PILOTE_SMARTY_PREFIX);
$tpl->assign('content', $content);
//Set path to main Galette's template
$tpl->template_dir = $orig_template_path;
$tpl->display('page.tpl', PILOTE_SMARTY_PREFIX);