| 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 EventFeed extends PlFeed |
| 23 | { |
| 24 | public function __construct() |
| 25 | { |
| 26 | global $globals; |
| 27 | parent::__construct($globals->core->sitename . ' :: News', |
| 28 | $globals->baseurl, |
| 29 | 'Informations et Activités polytechniciennes', |
| 30 | $globals->baseurl . '/images/logo.png', |
| 31 | 'events/rss.tpl'); |
| 32 | } |
| 33 | |
| 34 | protected function fetch(PlUser &$user) |
| 35 | { |
| 36 | global $globals; |
| 37 | return XDB::iterator( |
| 38 | 'SELECT e.id, e.titre AS title, e.texte, e.creation_date AS publication, e.post_id, p.attachmime IS NOT NULL AS photo, |
| 39 | CONCAT(u2.prenom, " ", IF(u2.nom_usage = "", u2.nom, u2.nom_usage), " (X", u2.promo, ")") AS author, |
| 40 | FIND_IN_SET(\'wiki\', e.flags) AS wiki, |
| 41 | CONCAT({?}, "/events#newsid", e.id) AS link |
| 42 | FROM auth_user_md5 AS u |
| 43 | INNER JOIN evenements AS e ON ( (e.promo_min = 0 || e.promo_min <= u.promo) |
| 44 | AND (e.promo_max = 0 || e.promo_max >= u.promo) ) |
| 45 | LEFT JOIN evenements_photo AS p ON (p.eid = e.id) |
| 46 | INNER JOIN auth_user_md5 AS u2 ON (u2.user_id = e.user_id) |
| 47 | WHERE u.user_id = {?} AND FIND_IN_SET("valide", e.flags) |
| 48 | AND peremption >= NOW()', $globals->baseurl, $user->id()); |
| 49 | } |
| 50 | } |
| 51 | |
| 52 | // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: |
| 53 | ?> |