function handlers()
{
return array(
- 'carnet/panel' => $this->make_hook('panel', AUTH_COOKIE),
+ 'carnet' => $this->make_hook('index', AUTH_COOKIE),
+ 'carnet/panel' => $this->make_hook('panel', AUTH_COOKIE),
+ 'carnet/notifs' => $this->make_hook('notifs', AUTH_COOKIE),
- 'carnet/rss' => $this->make_hook('rss', AUTH_PUBLIC),
- 'carnet/ical' => $this->make_hook('ical', AUTH_PUBLIC),
+ 'carnet/contacts' => $this->make_hook('contacts', AUTH_COOKIE),
+ 'carnet/contacts/pdf' => $this->make_hook('pdf', AUTH_COOKIE),
+
+ 'carnet/rss' => $this->make_hook('rss', AUTH_PUBLIC),
+ 'carnet/ical' => $this->make_hook('ical', AUTH_PUBLIC),
);
}
);
}
+ function handler_index(&$page)
+ {
+ $page->changeTpl('carnet/index.tpl');
+ $page->assign('xorg_title','Polytechnique.org - Mon carnet');
+ $this->_add_rss_link($page);
+
+ return PL_OK;
+ }
+
function handler_panel(&$page)
{
$page->changeTpl('carnet/panel.tpl');
return PL_OK;
}
+ function _handler_notifs_promos(&$page, &$watch, $action, $arg)
+ {
+ if(preg_match('!^ *(\d{4}) *$!', $arg, $matches)) {
+ $p = intval($matches[1]);
+ if($p<1900 || $p>2100) {
+ $page->trig("la promo entrée est invalide");
+ } else {
+ if ($action == 'add_promo') {
+ $watch->_promos->add($p);
+ } else {
+ $watch->_promos->del($p);
+ }
+ }
+ } elseif (preg_match('!^ *(\d{4}) *- *(\d{4}) *$!', $arg, $matches)) {
+ $p1 = intval($matches[1]);
+ $p2 = intval($matches[2]);
+ if($p1<1900 || $p1>2100) {
+ $page->trig('la première promo de la plage entrée est invalide');
+ } elseif($p2<1900 || $p2>2100) {
+ $page->trig('la seconde promo de la plage entrée est invalide');
+ } else {
+ if ($action == 'add_promo') {
+ $watch->_promos->addRange($p1, $p2);
+ } else {
+ $watch->_promos->delRange($p1, $p2);
+ }
+ }
+ } else {
+ $page->trig("La promo (ou la plage de promo) entrée est dans un format incorrect.");
+ }
+ }
+
+ function handler_notifs(&$page, $action = null, $arg = null)
+ {
+ global $globals;
+
+ $page->changeTpl('carnet/notifs.tpl');
+
+ require_once 'notifs.inc.php';
+
+ $watch = new Watch(Session::getInt('uid'));
+
+ $res = $globals->xdb->query("SELECT promo_sortie
+ FROM auth_user_md5
+ WHERE user_id = {?}",
+ Session::getInt('uid', -1));
+ $promo_sortie = $res->fetchOneCell();
+ $page->assign('promo_sortie', $promo_sortie);
+
+ switch ($action) {
+ case 'add_promo':
+ case 'del_promo':
+ $this->_handler_notifs_promos($page, $watch, $action, $arg);
+ break;
+
+ case 'del_nonins':
+ $watch->_nonins->del($arg);
+ break;
+
+ case 'add_nonins':
+ $watch->_nonins->add($arg);
+ break;
+ }
+
+ if (Env::has('subs')) $watch->_subs->update('sub');
+ if (Env::has('flags_contacts')) {
+ $watch->watch_contacts = Env::getBool('contacts');
+ $watch->saveFlags();
+ }
+ if (Env::has('flags_mail')) {
+ $watch->watch_mail = Env::getBool('mail');
+ $watch->saveFlags();
+ }
+
+ $page->assign_by_ref('watch', $watch);
+
+ return PL_OK;
+ }
+
+ function _get_list($offset, $limit) {
+ global $globals;
+ $uid = Session::getInt('uid');
+ $res = $globals->xdb->query("SELECT COUNT(*) FROM contacts WHERE uid = {?}", $uid);
+ $total = $res->fetchOneCell();
+
+ $order = Get::get('order');
+ $orders = Array(
+ 'nom' => 'nom DESC, u.prenom, u.promo',
+ 'promo' => 'promo DESC, nom, u.prenom',
+ 'last' => 'u.date DESC, nom, u.prenom, promo');
+ if ($order != 'promo' && $order != 'last')
+ $order = 'nom';
+ $order = $orders[$order];
+ if (Get::get('inv') == '')
+ $order = str_replace(" DESC,", ",", $order);
+
+ $res = $globals->xdb->query("
+ SELECT u.prenom, IF(u.nom_usage='',u.nom,u.nom_usage) AS nom, a.alias AS forlife, u.promo
+ FROM contacts AS c
+ INNER JOIN auth_user_md5 AS u ON (u.user_id = c.contact)
+ INNER JOIN aliases AS a ON (u.user_id = a.id AND a.type='a_vie')
+ WHERE c.uid = {?}
+ ORDER BY $order
+ LIMIT {?}, {?}", $uid, $offset*$limit, $limit);
+ $list = $res->fetchAllAssoc();
+
+ return Array($total, $list);
+ }
+
+ function handler_contacts(&$page, $action = null)
+ {
+ global $globals;
+
+ $page->changeTpl('carnet/mescontacts.tpl');
+ require_once("applis.func.inc.php");
+ $page->assign('xorg_title','Polytechnique.org - Mes contacts');
+
+ $uid = Session::getInt('uid');
+ $user = Env::get('user');
+
+ switch (Env::get('action')) {
+ case 'retirer':
+ if (is_numeric($user)) {
+ if ($globals->xdb->execute('DELETE FROM contacts
+ WHERE uid = {?} AND contact = {?}',
+ $uid, $user))
+ {
+ $page->trig("Contact retiré !");
+ }
+ } else {
+ if ($globals->xdb->execute(
+ 'DELETE FROM contacts
+ USING contacts AS c
+ INNER JOIN aliases AS a ON (c.contact=a.id and a.type!="homonyme")
+ WHERE c.uid = {?} AND a.alias={?}', $uid, $user))
+ {
+ $page->trig("Contact retiré !");
+ }
+ }
+ break;
+
+ case 'ajouter':
+ require_once('user.func.inc.php');
+ if (($login = get_user_login($user)) !== false) {
+ if ($globals->xdb->execute(
+ 'INSERT INTO contacts (uid, contact)
+ SELECT {?}, id
+ FROM aliases
+ WHERE alias = {?}', $uid, $login))
+ {
+ $page->trig('Contact ajouté !');
+ } else {
+ $page->trig('Contact déjà dans la liste !');
+ }
+ }
+ }
+
+ if ($action == 'trombi') {
+ require_once 'trombi.inc.php';
+
+ $trombi = new Trombi(array($this, '_get_list'));
+ $trombi->setNbRows(4);
+ $page->assign_by_ref('trombi',$trombi);
+
+ $order = Get::get('order');
+ if ($order != 'promo' && $order != 'last')
+ $order = 'nom';
+ $page->assign('order', $order);
+ $page->assign('inv', Get::get('inv'));
+
+ } else {
+
+ $order = Get::get('order');
+ $orders = Array(
+ 'nom' => 'sortkey DESC, a.prenom, a.promo',
+ 'promo' => 'promo DESC, sortkey, a.prenom',
+ 'last' => 'a.date DESC, sortkey, a.prenom, promo');
+ if ($order != 'promo' && $order != 'last')
+ $order = 'nom';
+ $page->assign('order', $order);
+ $page->assign('inv', Get::get('inv'));
+ $order = $orders[$order];
+ if (Get::get('inv') == '')
+ $order = str_replace(" DESC,", ",", $order);
+
+ $sql = "SELECT contact AS id,
+ a.*, l.alias AS forlife,
+ 1 AS inscrit,
+ a.perms != 'pending' AS wasinscrit,
+ a.deces != 0 AS dcd, a.deces, a.matricule_ax,
+ FIND_IN_SET('femme', a.flags) AS sexe,
+ e.entreprise, es.label AS secteur, ef.fonction_fr AS fonction,
+ IF(n.nat='',n.pays,n.nat) AS nat, n.a2 AS iso3166,
+ ad0.text AS app0text, ad0.url AS app0url, ai0.type AS app0type,
+ ad1.text AS app1text, ad1.url AS app1url, ai1.type AS app1type,
+ adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region,
+ IF(a.nom_usage<>'',a.nom_usage,a.nom) AS sortkey
+ FROM contacts AS c
+ INNER JOIN auth_user_md5 AS a ON (a.user_id = c.contact)
+ INNER JOIN aliases AS l ON (a.user_id = l.id AND l.type='a_vie')
+ LEFT JOIN entreprises AS e ON (e.entrid = 0 AND e.uid = a.user_id)
+ LEFT JOIN emploi_secteur AS es ON (e.secteur = es.id)
+ LEFT JOIN fonctions_def AS ef ON (e.fonction = ef.id)
+ LEFT JOIN geoloc_pays AS n ON (a.nationalite = n.a2)
+ LEFT JOIN applis_ins AS ai0 ON (a.user_id = ai0.uid AND ai0.ordre = 0)
+ LEFT JOIN applis_def AS ad0 ON (ad0.id = ai0.aid)
+ LEFT JOIN applis_ins AS ai1 ON (a.user_id = ai1.uid AND ai1.ordre = 1)
+ LEFT JOIN applis_def AS ad1 ON (ad1.id = ai1.aid)
+ LEFT JOIN adresses AS adr ON (a.user_id = adr.uid
+ AND FIND_IN_SET('active', adr.statut))
+ LEFT JOIN geoloc_pays AS gp ON (adr.country = gp.a2)
+ LEFT JOIN geoloc_region AS gr ON (adr.country = gr.a2 AND adr.region = gr.region)
+ WHERE c.uid = $uid
+ ORDER BY ".$order;
+
+ $page->assign_by_ref('citer', $globals->xdb->iterator($sql));
+ }
+
+ return PL_OK;
+ }
+
+ function handler_pdf(&$page, $arg0 = null, $arg1 = null)
+ {
+ global $globals;
+
+ require_once 'contacts.pdf.inc.php';
+ require_once 'user.func.inc.php';
+
+ session_write_close();
+
+ $sql = "SELECT a.alias
+ FROM aliases AS a
+ INNER JOIN auth_user_md5 AS u ON ( a.id = u.user_id )
+ INNER JOIN contacts AS c ON ( a.id = c.contact )
+ WHERE c.uid = {?} AND a.type='a_vie'";
+ if ($arg0 == 'promo') {
+ $sql .= ' ORDER BY u.promo, u.nom, u.prenom';
+ } else {
+ $sql .= ' ORDER BY u.nom, u.prenom, u.promo';
+ }
+
+ $citer = $globals->xdb->iterRow($sql, Session::getInt('uid'));
+ $pdf = new ContactsPDF();
+
+ while (list($alias) = $citer->next()) {
+ $user = get_user_details($alias);
+ $pdf->addContact($user, $arg0 == 'photos' || $arg1 == 'photos');
+ }
+ $pdf->Output();
+
+ exit;
+ }
+
function handler_rss(&$page, $user = null, $hash = null)
{
require_once 'rss.inc.php';
projects / platal.git / blobdiff