X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fevents.php;h=2702756dde54f33b39ec4ab453af5476036c9fc6;hb=1d10d3fd659fa8eb7c663d6bb599bc8bbc0feeb3;hp=98d25920064c3ed6afd5c27bb8f572c1ed0fcefd;hpb=08cce2ff528b38bde27cdec6d6bc28d6af4a42d4;p=platal.git diff --git a/modules/events.php b/modules/events.php index 98d2592..2702756 100644 --- a/modules/events.php +++ b/modules/events.php @@ -25,25 +25,43 @@ class EventsModule extends PLModule { return array( 'events' => $this->make_hook('ev', AUTH_COOKIE), + 'send_bug' => $this->make_hook('bug', AUTH_COOKIE), 'events/submit' => $this->make_hook('ev_submit', AUTH_MDP), + 'admin/events' => $this->make_hook('admin_events', AUTH_MDP, 'admin'), 'nl' => $this->make_hook('nl', AUTH_COOKIE), 'nl/show' => $this->make_hook('nl_show', AUTH_COOKIE), 'nl/submit' => $this->make_hook('nl_submit', AUTH_COOKIE), + 'admin/newsletter' => $this->make_hook('admin_nl', AUTH_MDP, 'admin'), + 'admin/newsletter/categories' => $this->make_hook('admin_nl_cat', AUTH_MDP, 'admin'), + 'admin/newsletter/edit' => $this->make_hook('admin_nl_edit', AUTH_MDP, 'admin'), ); } - function handler_ev(&$page) + function on_subscribe($forlife, $uid, $promo, $password) { - global $globals; + require_once 'newsletter.inc.php'; + subscribe_nl($uid); + } + + function handler_bug(&$page) + { + $this->handler_ev($page); + $page->assign('bug', 1); + } + function handler_ev(&$page, $action = 'list', $eid = null, $pound = null) + { $page->changeTpl('login.tpl'); + + // donne la derniere date de session + $page->assign('lastlogin', strftime("%Y%m%d%H%M%S",S::i('lastlogin'))); $res = XDB::query('SELECT date, naissance FROM auth_user_md5 - WHERE user_id={?}', Session::getInt('uid')); + WHERE user_id={?}', S::v('uid')); list($date, $naissance) = $res->fetchOneRow(); - // incitation à mettre à jour la fiche + // incitation à mettre à jour la fiche $d2 = mktime(0, 0, 0, substr($date, 5, 2), substr($date, 8, 2), substr($date, 0, 4)); @@ -58,65 +76,66 @@ class EventsModule extends PLModule $page->assign('birthday', date('Y') - substr($naissance, 0, 4)); } - // incitation à mettre une photo + // incitation à mettre une photo $res = XDB::query('SELECT COUNT(*) FROM photo - WHERE uid={?}', Session::getInt('uid')); + WHERE uid={?}', S::v('uid')); $page->assign('photo_incitation', $res->fetchOneCell() == 0); - // Incitation à se géolocaliser + // Incitation à se géolocaliser require_once 'geoloc.inc.php'; - $res = localize_addresses(Session::getInt('uid', -1)); + $res = localize_addresses(S::v('uid', -1)); $page->assign('geoloc_incitation', count($res)); - // affichage de la boîte avec quelques liens - require_once 'login.conf.php'; - $pub_nbElem = $pub_nbLig * $pub_nbCol ; - if (count($pub_tjs) <= $pub_nbElem) { - $publicite = array_slice($pub_tjs, 0, $pub_nbElem); - } else { - $publicite = $pub_tjs ; + // affichage de la boîte avec quelques liens + /* Bandeau de publicité sur la page de login */ + $publicite = array( + 'password' => 'Changer mon mot de passe' , + 'Docs/Dons' => 'Faire un don à l\'association Polytechnique.org' + ) ; + + // Liens apparaissant de façon aléatoire + $pub_rnd = array( + 'nl/show' => 'Afficher la dernière newsletter' , + 'http://www.polytechnique.net/login' => 'Vers les autres sites polytechniciens' , + "trombi/{$_SESSION["promo"]}" => "Voir le trombi de ma promo" , + 'banana' => 'Un petit tour du côté des forums !!' + ) ; + + $choix = array_rand($pub_rnd, 2); + foreach ($choix as $url) { + $publicite[$url] = $pub_rnd[$url] ; } - - $nbAlea = $pub_nbElem - count($publicite) ; - if ($nbAlea > 0) { - $choix = array_rand($pub_rnd,$nbAlea) ; - foreach ($choix as $url) { - $publicite[$url] = $pub_rnd[$url] ; - } - } - $publicite = array_chunk( $publicite , $pub_nbLig , true ) ; - $page->assign_by_ref('publicite', $publicite); + $page->assign('publicite', array_chunk($publicite, 2, true)); // ajout du lien RSS - - if (Session::has('core_rss_hash')) { - $page->assign('xorg_rss', - array('title' => 'Polytechnique.org :: News', - 'href' => '/rss/'.Session::get('forlife') - .'/'.Session::get('core_rss_hash').'/rss.xml') - ); + if (S::has('core_rss_hash')) { + $page->setRssLink('Polytechnique.org :: News', + '/rss/'.S::v('forlife') .'/'.S::v('core_rss_hash').'/rss.xml'); } // cache les evenements lus et raffiche les evenements a relire - if (Env::has('lu')){ - XDB::execute('DELETE FROM evenements_vus AS ev - INNER JOIN evenements AS e ON e.id = ev.evt_id - WHERE peremption < NOW)'); + if ($action == 'read' && $eid) { + XDB::execute('DELETE evenements_vus.* + FROM evenements_vus AS ev + INNER JOIN evenements AS e ON e.id = ev.evt_id + WHERE peremption < NOW()'); XDB::execute('REPLACE INTO evenements_vus VALUES({?},{?})', - Env::get('lu'), Session::getInt('uid')); + $eid, S::v('uid')); + pl_redirect('events#'.$pound); } - if (Env::has('nonlu')){ + if ($action == 'unread' && $eid) { XDB::execute('DELETE FROM evenements_vus - WHERE evt_id = {?} AND user_id = {?}', - Env::get('nonlu'), Session::getInt('uid')); + WHERE evt_id = {?} AND user_id = {?}', + $eid, S::v('uid')); + pl_redirect('events#newsid'.$eid); } // affichage des evenements - // annonces promos triées par présence d'une limite sur les promos + // annonces promos triées par présence d'une limite sur les promos // puis par dates croissantes d'expiration - $promo = Session::getInt('promo'); + $promo = S::v('promo'); $sql = "SELECT e.id,e.titre,e.texte,a.user_id,a.nom,a.prenom,a.promo,l.alias AS forlife FROM evenements AS e INNER JOIN auth_user_md5 AS a ON e.user_id=a.user_id @@ -128,7 +147,7 @@ class EventsModule extends PLModule AND ev.user_id IS NULL ORDER BY (e.promo_min != 0 AND e.promo_max != 0) DESC, e.peremption"; $page->assign('evenement', - XDB::iterator($sql, Session::getInt('uid'), + XDB::iterator($sql, S::v('uid'), $promo, $promo) ); @@ -140,26 +159,37 @@ class EventsModule extends PLModule AND (e.promo_max = 0 || e.promo_max >= {?}) ORDER BY (e.promo_min != 0 AND e.promo_max != 0) DESC, e.peremption"; $page->assign('evenement_summary', - XDB::iterator($sql, Session::getInt('uid'), + XDB::iterator($sql, S::v('uid'), $promo, $promo) ); } function handler_ev_submit(&$page) { - global $globals; $page->changeTpl('evenements.tpl'); - $titre = Post::get('titre'); - $texte = Post::get('texte'); - $promo_min = Post::getInt('promo_min'); - $promo_max = Post::getInt('promo_max'); - $peremption = Post::getInt('peremption'); - $valid_mesg = Post::get('valid_mesg'); - $action = Post::get('action'); + $titre = Post::v('titre'); + $texte = Post::v('texte'); + $promo_min = Post::i('promo_min'); + $promo_max = Post::i('promo_max'); + $peremption = Post::i('peremption'); + $valid_mesg = Post::v('valid_mesg'); + $action = Post::v('action'); + + if ($promo_min > $promo_max || + ($promo_min != 0 && ($promo_min <= 1900 || $promo_min >= 2020)) || + ($promo_max != 0 && ($promo_max <= 1900 || $promo_max >= 2020))) + { + $page->trig("L'intervalle de promotions n'est pas valide"); + $action = null; + } + require_once('url_catcher.inc.php'); + $texte_catch_url = url_catcher($texte); + $page->assign('titre', $titre); $page->assign('texte', $texte); + $page->assign('texte_html', $texte_catch_url); $page->assign('promo_min', $promo_min); $page->assign('promo_max', $promo_max); $page->assign('peremption', $peremption); @@ -167,13 +197,10 @@ class EventsModule extends PLModule $page->assign('action', strtolower($action)); if ($action == 'Confirmer') { - $texte = preg_replace('/((http|ftp)+(s)?:\/\/[^<>\s]+)/i', - '\\0', $texte); - $texte = preg_replace('/([^,\s]+@[^,\s]+)/i', - '\\0', $texte); + $texte = $texte_catch_url; require_once 'validations.inc.php'; $evtreq = new EvtReq($titre, $texte, $promo_min, $promo_max, - $peremption, $valid_mesg, Session::getInt('uid')); + $peremption, $valid_mesg, S::v('uid')); $evtreq->submit(); $page->assign('ok', true); } @@ -209,7 +236,7 @@ class EventsModule extends PLModule } $page->assign('nls', get_nl_state()); - $page->assign_by_ref('nl_list', get_nl_list()); + $page->assign('nl_list', get_nl_list()); } function handler_nl_show(&$page, $nid = 'last') @@ -222,9 +249,9 @@ class EventsModule extends PLModule $page->assign_by_ref('nl', $nl); if (Post::has('send')) { - $nl->sendTo(Session::get('prenom'), Session::get('nom'), - Session::get('bestalias'), Session::get('femme'), - Session::get('mail_fmt') != 'text'); + $nl->sendTo(S::v('prenom'), S::v('nom'), + S::v('bestalias'), S::v('femme'), + S::v('mail_fmt') != 'texte'); } } @@ -235,16 +262,187 @@ class EventsModule extends PLModule require_once 'newsletter.inc.php'; if (Post::has('see')) { - $art = new NLArticle(Post::get('title'), Post::get('body'), Post::get('append')); + $art = new NLArticle(Post::v('title'), Post::v('body'), Post::v('append')); $page->assign('art', $art); } elseif (Post::has('valid')) { require_once('validations.inc.php'); - $art = new NLReq(Session::getInt('uid'), Post::get('title'), - Post::get('body'), Post::get('append')); + $art = new NLReq(S::v('uid'), Post::v('title'), + Post::v('body'), Post::v('append')); $art->submit(); $page->assign('submited', true); } } + + function handler_admin_events(&$page, $action = 'list', $eid = null) + { + $page->changeTpl('admin/evenements.tpl'); + $page->assign('xorg_title','Polytechnique.org - Administration - Evenements'); + $page->register_modifier('hde', 'html_entity_decode'); + + $arch = $action == 'archives'; + $page->assign('action', $action); + + if (Post::v('action') == "Proposer" && $eid) { + $promo_min = Post::i('promo_min'); + $promo_max = Post::i('promo_max'); + if ($promo_min > $promo_max || + ($promo_min != 0 && ($promo_min <= 1900 || $promo_min >= 2020)) || + ($promo_max != 0 && ($promo_max <= 1900 || $promo_max >= 2020))) + { + $page->trig("L'intervalle de promotions $promo_min -> $promo_max n'est pas valide"); + $action = 'edit'; + } else { + XDB::execute('UPDATE evenements + SET titre={?}, texte={?}, peremption={?}, promo_min={?}, promo_max={?} + WHERE id = {?}', + Post::v('titre'), Post::v('texte'), Post::v('peremption'), + Post::v('promo_min'), Post::v('promo_max'), $eid); + } + } + + if ($action == 'edit') { + $res = XDB::query('SELECT titre, texte, peremption, promo_min, promo_max + FROM evenements + WHERE id={?}', $eid); + list($titre, $texte, $peremption, $promo_min, $promo_max) = $res->fetchOneRow(); + $page->assign('titre',$titre); + $page->assign('texte',$texte); + $page->assign('promo_min',$promo_min); + $page->assign('promo_max',$promo_max); + $page->assign('peremption',$peremption); + + $select = ""; + for ($i = 1 ; $i < 30 ; $i++) { + $p_stamp=date("Ymd",time()+3600*24*$i); + $year=substr($p_stamp,0,4); + $month=substr($p_stamp,4,2); + $day=substr($p_stamp,6,2); + + $select .= "\n"; + } + $page->assign('select',$select); + } else { + switch ($action) { + case 'delete': + XDB::execute('DELETE from evenements + WHERE id = {?}', $eid); + break; + + case "archive": + XDB::execute('UPDATE evenements + SET creation_date = creation_date, flags = CONCAT(flags,",archive") + WHERE id = {?}', $eid); + break; + + case "unarchive": + XDB::execute('UPDATE evenements + SET creation_date = creation_date, flags = REPLACE(flags,"archive","") + WHERE id = {?}', $eid); + $action = 'archives'; + $arch = true; + break; + + case "valid": + XDB::execute('UPDATE evenements + SET creation_date = creation_date, flags = CONCAT(flags,",valide") + WHERE id = {?}', $eid); + break; + + case "unvalid": + XDB::execute('UPDATE evenements + SET creation_date = creation_date, flags = REPLACE(flags,"valide", "") + WHERE id = {?}', $eid); + break; + } + + $pid = ($eid && $action == 'preview') ? $eid : -1; + $sql = "SELECT e.id, e.titre, e.texte,e.id = $pid AS preview, + DATE_FORMAT(e.creation_date,'%d/%m/%Y %T') AS creation_date, + DATE_FORMAT(e.peremption,'%d/%m/%Y') AS peremption, + e.promo_min, e.promo_max, + FIND_IN_SET('valide', e.flags) AS fvalide, + FIND_IN_SET('archive', e.flags) AS farch, + u.promo, u.nom, u.prenom, a.alias AS forlife + FROM evenements AS e + INNER JOIN auth_user_md5 AS u ON(e.user_id = u.user_id) + INNER JOIN aliases AS a ON (u.user_id = a.id AND a.type='a_vie') + WHERE ".($arch ? "" : "!")."FIND_IN_SET('archive',e.flags) + ORDER BY FIND_IN_SET('valide',e.flags), e.peremption DESC"; + $page->assign('evs', XDB::iterator($sql)); + } + $page->assign('arch', $arch); + } + + function handler_admin_nl(&$page, $new = false) { + $page->changeTpl('newsletter/admin.tpl'); + $page->assign('xorg_title','Polytechnique.org - Administration - Newsletter : liste'); + require_once("newsletter.inc.php"); + + if($new) { + insert_new_nl(); + pl_redirect("admin/newsletter"); + } + + $page->assign('nl_list', get_nl_slist()); + } + + function handler_admin_nl_edit(&$page, $nid = 'last', $aid = null, $action = 'edit') { + $page->changeTpl('newsletter/edit.tpl'); + $page->assign('xorg_title','Polytechnique.org - Administration - Newsletter : Edition'); + require_once("newsletter.inc.php"); + + $nl = new NewsLetter($nid); + + if($action == 'delete') { + $nl->delArticle($aid); + pl_redirect("admin/newsletter/edit/$nid"); + } + + if($aid == 'update') { + $nl->_title = Post::v('title'); + $nl->_title_mail= Post::v('title_mail'); + $nl->_date = Post::v('date'); + $nl->_head = Post::v('head'); + $nl->_shortname = strlen(Post::v('shortname')) ? Post::v('shortname') : null; + if (preg_match('/^[-a-z0-9]*$/i', $nl->_shortname) && !is_numeric($nl->_shortname)) { + $nl->save(); + } else { + $page->trig('Le nom de la NL n\'est pas valide'); + pl_redirect('admin/newsletter/edit/' . $nl->_id); + } + } + + if(Post::v('save')) { + $art = new NLArticle(Post::v('title'), Post::v('body'), Post::v('append'), + $aid, Post::v('cid'), Post::v('pos')); + $nl->saveArticle($art); + pl_redirect("admin/newsletter/edit/$nid"); + } + + if($action == 'edit' && $aid != 'update') { + $eaid = $aid; + if(Post::has('title')) { + $art = new NLArticle(Post::v('title'), Post::v('body'), Post::v('append'), + $eaid, Post::v('cid'), Post::v('pos')); + } else { + $art = ($eaid == 'new') ? new NLArticle() : $nl->getArt($eaid); + } + $page->assign('art', $art); + } + + $page->assign_by_ref('nl',$nl); + } + function handler_admin_nl_cat(&$page, $action = 'list', $id = null) { + $page->assign('xorg_title','Polytechnique.org - Administration - Newsletter : Catégories'); + $page->assign('title', 'Gestion des catégories de la newsletter'); + $table_editor = new PLTableEditor('admin/newsletter/categories','newsletter_cat','cid'); + $table_editor->describe('titre','intitulé',true); + $table_editor->describe('pos','position',true); + $table_editor->apply($page, $action, $id); + } + } ?>