[platal.git] / modules / carnet.php

<?php
/***************************************************************************
 *  Copyright (C) 2003-2008 Polytechnique.org                              *
 *  http://opensource.polytechnique.org/                                   *
 *                                                                         *
 *  This program is free software; you can redistribute it and/or modify   *
 *  it under the terms of the GNU General Public License as published by   *
 *  the Free Software Foundation; either version 2 of the License, or      *
 *  (at your option) any later version.                                    *
 *                                                                         *
 *  This program 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 this program; if not, write to the Free Software            *
 *  Foundation, Inc.,                                                      *
 *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
 ***************************************************************************/

class CarnetModule extends PLModule
{
    function handlers()
    {
        return array(
            'carnet'                => $this->make_hook('index',    AUTH_COOKIE),
            'carnet/panel'          => $this->make_hook('panel',    AUTH_COOKIE),
            'carnet/notifs'         => $this->make_hook('notifs',   AUTH_COOKIE),

            'carnet/contacts'       => $this->make_hook('contacts', AUTH_COOKIE),
            'carnet/contacts/pdf'   => $this->make_hook('pdf',      AUTH_COOKIE, 'user', NO_HTTPS),
            'carnet/contacts/ical'  => $this->make_hook('ical',     AUTH_PUBLIC, 'user', NO_HTTPS),
            'carnet/contacts/vcard' => $this->make_hook('vcard',    AUTH_COOKIE, 'user', NO_HTTPS),

            'carnet/rss'            => $this->make_hook('rss',      AUTH_PUBLIC, 'user', NO_HTTPS),
        );
    }

    function _add_rss_link(&$page)
    {
        if (!S::has('core_rss_hash')) {
            return;
        }
        $page->setRssLink('Polytechnique.org :: Carnet',
                          '/carnet/rss/'.S::v('forlife') .'/'.S::v('core_rss_hash').'/rss.xml');
    }

    function handler_index(&$page)
    {
        $page->changeTpl('carnet/index.tpl');
        $page->setTitle('Mon carnet');
        $this->_add_rss_link($page);
    }

    function handler_panel(&$page)
    {
        $page->changeTpl('carnet/panel.tpl');

        if (Get::has('read')) {
            S::set('watch_last', Get::v('read'));
            Platal::session()->updateNbNotifs();
            pl_redirect('carnet/panel');
        }

        require_once 'notifs.inc.php';

        $page->assign('now',date('YmdHis'));
        $notifs = new Notifs(S::v('uid'), true);

        $page->assign('notifs', $notifs);
        $page->assign('today', date('Y-m-d'));
        $this->_add_rss_link($page);
    }

    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->trigError("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->trigError('la première promo de la plage entrée est invalide');
            } elseif($p2<1900 || $p2>2100) {
                $page->trigError('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->trigError("La promo (ou la plage de promo) entrée est dans un format incorrect.");
        }
    }

    function handler_notifs(&$page, $action = null, $arg = null)
    {
        $page->changeTpl('carnet/notifs.tpl');

        require_once 'notifs.inc.php';

        $watch = new Watch(S::v('uid'));

        $res = XDB::query("SELECT promo_sortie
                                       FROM auth_user_md5
                                      WHERE user_id = {?}",
                                    S::v('uid', -1));
        $promo_sortie = $res->fetchOneCell();
        $page->assign('promo_sortie', $promo_sortie);

        if ($action) {
            S::assert_xsrf_token();
        }
        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')) {
            S::assert_xsrf_token();
            $watch->_subs->update('sub');
        }

        if (Env::has('flags_contacts')) {
            S::assert_xsrf_token();
            $watch->watch_contacts = Env::b('contacts');
            $watch->saveFlags();
        }

        if (Env::has('flags_mail')) {
            S::assert_xsrf_token();
            $watch->watch_mail = Env::b('mail');
            $watch->saveFlags();
        }

        $page->assign_by_ref('watch', $watch);
    }

    function _get_list($offset, $limit) {
        $uid   = S::v('uid');
        $res   = XDB::query("SELECT COUNT(*) FROM contacts WHERE uid = {?}", $uid);
        $total = $res->fetchOneCell();

        $order = Get::v('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::v('inv') == '')
            $order = str_replace(" DESC,", ",", $order);

        $res   = 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 searchErrorHandler($explain) {
        $page =& Platal::page();
        $page->trigError($explain);
        $this->handler_contacts($page);
    }

    function handler_contacts(&$page, $action = null, $subaction = null, $ssaction = null)
    {
        $page->setTitle('Mes contacts');
        $this->_add_rss_link($page);

        $uid  = S::v('uid');
        $user = Env::v('user');

        // For XSRF protection, checks both the normal xsrf token, and the special RSS token.
        // It allows direct linking to contact adding in the RSS feed.
        if (Env::v('action') && Env::v('token') !== S::v('core_rss_hash')) {
            S::assert_xsrf_token();
        }
        switch (Env::v('action')) {
            case 'retirer':
                if (is_numeric($user)) {
                    if (XDB::execute('DELETE FROM contacts
                                       WHERE uid = {?} AND contact = {?}',
                                     $uid, $user))
                    {
                        $page->trigSuccess("Contact retiré !");
                    }
                } else {
                    if (XDB::execute(
                                'DELETE FROM  c
                                       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->trigSuccess("Contact retiré !");
                    }
                }
                break;

            case 'ajouter':
                require_once('user.func.inc.php');
                if (($login = get_user_login($user)) !== false) {
                    if (XDB::execute(
                                'REPLACE INTO  contacts (uid, contact)
                                       SELECT  {?}, id
                                         FROM  aliases
                                        WHERE  alias = {?}', $uid, $login))
                    {
                        $page->trigSuccess('Contact ajouté !');
                    } else {
                        $page->trigWarning('Contact déjà dans la liste !');
                    }
                }
        }

        $search = false;
        if ($action == 'search') {
            $action = $subaction;
            $subaction = $ssaction;
            $search = true;
        }
        if ($search && trim(Env::v('quick'))) {
            require_once 'userset.inc.php';
            $base = 'carnet/contacts/search';

            Platal::load('search', 'classes.inc.php');
            ThrowError::$throwHook = array($this, 'searchErrorHandler');
            $view = new SearchSet(true, false, "INNER JOIN contacts AS c2 ON (u.user_id = c2.contact)", "c2.uid = $uid");
        } else {
            $base = 'carnet/contacts';
            $view = new UserSet("INNER JOIN contacts AS c2 ON (u.user_id = c2.contact)", " c2.uid = $uid ");
        }
        $view->addMod('minifiche', 'Mini-fiches', true);
        $view->addMod('trombi', 'Trombinoscope', false, array('with_admin' => false, 'with_promo' => true));
        $view->addMod('geoloc', 'Planisphère', false, array('with_annu' => 'carnet/contacts/search'));
        $view->apply($base, $page, $action, $subaction);
        if ($action != 'geoloc' || ($search && !$ssaction) || (!$search && !$subaction)) {
            $page->changeTpl('carnet/mescontacts.tpl');
        }
    }

    function handler_pdf(&$page, $arg0 = null, $arg1 = null)
    {
        $this->load('contacts.pdf.inc.php');
        require_once 'user.func.inc.php';

        Platal::session()->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 = XDB::iterRow($sql, S::v('uid'));
        $pdf   = new ContactsPDF();

        while (list($alias) = $citer->next()) {
            $user = get_user_details($alias);
            foreach ($user as &$value) {
                if (is_utf8($value)) {
                    $value = utf8_decode($value);
                }
            }
            $pdf = ContactsPDF::addContact($pdf, $user, $arg0 == 'photos' || $arg1 == 'photos');
        }
        $pdf->Output();

        exit;
    }

    function handler_rss(&$page, $user = null, $hash = null)
    {
        $this->load('feed.inc.php');
        $feed = new CarnetFeed();
        return $feed->run($page, $user, $hash);
    }

    function handler_ical(&$page, $alias = null, $hash = null)
    {
        require_once 'rss.inc.php';
        $uid = init_rss(null, $alias, $hash, false);
        if (S::logged()) {
            if (!$uid) {
                $uid = S::i('uid');
            } else if ($uid != S::i('uid')) {
                send_warning_email("Récupération d\'un autre utilisateur ($uid)");
            }
        } else if (!$uid) {
            exit;
        }
        require_once 'ical.inc.php';
        $page->changeTpl('carnet/calendar.tpl', NO_SKIN);
        $page->register_function('display_ical', 'display_ical');

        $res = XDB::iterRow(
                'SELECT u.prenom,
                        IF(u.nom_usage = \'\',u.nom,u.nom_usage) AS nom,
                        u.promo,
                        u.naissance,
                        DATE_ADD(u.naissance, INTERVAL 1 DAY) AS end,
                        u.date_ins,
                        a.alias AS forlife
                   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 = {?}', $uid);

        $annivs = Array();
        while (list($prenom, $nom, $promo, $naissance, $end, $ts, $forlife) = $res->next()) {
            $naissance = str_replace('-', '', $naissance);
            $end       = str_replace('-', '', $end);
            $annivs[] = array(
                'timestamp' => strtotime($ts),
                'date'      => $naissance,
                'tomorrow'  => $end,
                'forlife'   => $forlife,
                'summary'   => 'Anniversaire de '.$prenom
                                .' '.$nom.' - x '.$promo,
            );
        }
        $page->assign('events', $annivs);

        header('Content-Type: text/calendar; charset=utf-8');
    }

    function handler_vcard(&$page, $photos = null)
    {
        $res = XDB::query('SELECT contact
                             FROM contacts
                            WHERE uid = {?}', S::v('uid'));
        $vcard = new VCard($res->fetchColumn(), $photos == 'photos');
        $vcard->do_page(&$page);
    }
}

// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
?>
Commit	Line	Data
0337d704	1	<?php
0337d704	2	/***************************************************************************
179afa7f	3	* Copyright (C) 2003-2008 Polytechnique.org *
0337d704	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
c9f82d49	22	class CarnetModule extends PLModule
	23	{
	24	function handlers()
	25	{
	26	return array(
5e193297	27	'carnet' => $this->make_hook('index', AUTH_COOKIE),
	28	'carnet/panel' => $this->make_hook('panel', AUTH_COOKIE),
	29	'carnet/notifs' => $this->make_hook('notifs', AUTH_COOKIE),
fc12cbd1	30
5e193297	31	'carnet/contacts' => $this->make_hook('contacts', AUTH_COOKIE),
8fc4efa3	32	'carnet/contacts/pdf' => $this->make_hook('pdf', AUTH_COOKIE, 'user', NO_HTTPS),
	33	'carnet/contacts/ical' => $this->make_hook('ical', AUTH_PUBLIC, 'user', NO_HTTPS),
	34	'carnet/contacts/vcard' => $this->make_hook('vcard', AUTH_COOKIE, 'user', NO_HTTPS),
b48a0758	35
8fc4efa3	36	'carnet/rss' => $this->make_hook('rss', AUTH_PUBLIC, 'user', NO_HTTPS),
c9f82d49	37	);
c9f82d49	38	}
0337d704	39
fc12cbd1	40	function _add_rss_link(&$page)
fc12cbd1	41	{
cab08090	42	if (!S::has('core_rss_hash')) {
fc12cbd1	43	return;
fd8f77de	44	}
162370e7	45	$page->setRssLink('Polytechnique.org :: Carnet',
162370e7	46	'/carnet/rss/'.S::v('forlife') .'/'.S::v('core_rss_hash').'/rss.xml');
fc12cbd1	47	}
fc12cbd1	48
b48a0758	49	function handler_index(&$page)
	50	{
	51	$page->changeTpl('carnet/index.tpl');
46f272fe	52	$page->setTitle('Mon carnet');
b48a0758	53	$this->_add_rss_link($page);
b48a0758	54	}
b48a0758	55
fc12cbd1	56	function handler_panel(&$page)
	57	{
	58	$page->changeTpl('carnet/panel.tpl');
	59
	60	if (Get::has('read')) {
ebfdf077 FB	61	S::set('watch_last', Get::v('read'));
ebfdf077 FB	62	Platal::session()->updateNbNotifs();
8b00e0e0	63	pl_redirect('carnet/panel');
fc12cbd1	64	}
	65
	66	require_once 'notifs.inc.php';
	67
	68	$page->assign('now',date('YmdHis'));
cab08090	69	$notifs = new Notifs(S::v('uid'), true);
fc12cbd1	70
	71	$page->assign('notifs', $notifs);
	72	$page->assign('today', date('Y-m-d'));
	73	$this->_add_rss_link($page);
fc12cbd1	74	}
fc12cbd1	75
b48a0758	76	function _handler_notifs_promos(&$page, &$watch, $action, $arg)
	77	{
	78	if(preg_match('!^ (\d{4}) $!', $arg, $matches)) {
	79	$p = intval($matches[1]);
	80	if($p<1900 \|\| $p>2100) {
a7d35093	81	$page->trigError("la promo entrée est invalide");
b48a0758	82	} else {
	83	if ($action == 'add_promo') {
	84	$watch->_promos->add($p);
	85	} else {
	86	$watch->_promos->del($p);
	87	}
	88	}
	89	} elseif (preg_match('!^ (\d{4}) - (\d{4}) $!', $arg, $matches)) {
	90	$p1 = intval($matches[1]);
	91	$p2 = intval($matches[2]);
	92	if($p1<1900 \|\| $p1>2100) {
a7d35093	93	$page->trigError('la première promo de la plage entrée est invalide');
b48a0758	94	} elseif($p2<1900 \|\| $p2>2100) {
a7d35093	95	$page->trigError('la seconde promo de la plage entrée est invalide');
b48a0758	96	} else {
	97	if ($action == 'add_promo') {
	98	$watch->_promos->addRange($p1, $p2);
	99	} else {
	100	$watch->_promos->delRange($p1, $p2);
	101	}
	102	}
	103	} else {
a7d35093	104	$page->trigError("La promo (ou la plage de promo) entrée est dans un format incorrect.");
b48a0758	105	}
	106	}
	107
	108	function handler_notifs(&$page, $action = null, $arg = null)
	109	{
b48a0758	110	$page->changeTpl('carnet/notifs.tpl');
	111
	112	require_once 'notifs.inc.php';
	113
cab08090	114	$watch = new Watch(S::v('uid'));
b48a0758	115
08cce2ff	116	$res = XDB::query("SELECT promo_sortie
b48a0758	117	FROM auth_user_md5
b48a0758	118	WHERE user_id = {?}",
cab08090	119	S::v('uid', -1));
b48a0758	120	$promo_sortie = $res->fetchOneCell();
	121	$page->assign('promo_sortie', $promo_sortie);
	122
40d428d8 VZ	123	if ($action) {
40d428d8 VZ	124	S::assert_xsrf_token();
e6bf9216	125	}
b48a0758	126	switch ($action) {
	127	case 'add_promo':
	128	case 'del_promo':
	129	$this->_handler_notifs_promos($page, $watch, $action, $arg);
	130	break;
	131
	132	case 'del_nonins':
	133	$watch->_nonins->del($arg);
	134	break;
	135
	136	case 'add_nonins':
	137	$watch->_nonins->add($arg);
	138	break;
	139	}
	140
40d428d8 VZ	141	if (Env::has('subs')) {
40d428d8 VZ	142	S::assert_xsrf_token();
e6bf9216	143	$watch->_subs->update('sub');
e6bf9216 VZ	144	}
e6bf9216 VZ	145
40d428d8 VZ	146	if (Env::has('flags_contacts')) {
40d428d8 VZ	147	S::assert_xsrf_token();
5e2307dc	148	$watch->watch_contacts = Env::b('contacts');
b48a0758	149	$watch->saveFlags();
b48a0758	150	}
e6bf9216	151
40d428d8 VZ	152	if (Env::has('flags_mail')) {
40d428d8 VZ	153	S::assert_xsrf_token();
e6bf9216	154	$watch->watch_mail = Env::b('mail');
b48a0758	155	$watch->saveFlags();
	156	}
	157
	158	$page->assign_by_ref('watch', $watch);
b48a0758	159	}
	160
	161	function _get_list($offset, $limit) {
cab08090	162	$uid = S::v('uid');
08cce2ff	163	$res = XDB::query("SELECT COUNT(*) FROM contacts WHERE uid = {?}", $uid);
b48a0758	164	$total = $res->fetchOneCell();
b48a0758	165
5e2307dc	166	$order = Get::v('order');
b48a0758	167	$orders = Array(
	168	'nom' => 'nom DESC, u.prenom, u.promo',
	169	'promo' => 'promo DESC, nom, u.prenom',
	170	'last' => 'u.date DESC, nom, u.prenom, promo');
	171	if ($order != 'promo' && $order != 'last')
	172	$order = 'nom';
	173	$order = $orders[$order];
5e2307dc	174	if (Get::v('inv') == '')
b48a0758	175	$order = str_replace(" DESC,", ",", $order);
b48a0758	176
08cce2ff	177	$res = XDB::query("
b48a0758	178	SELECT u.prenom, IF(u.nom_usage='',u.nom,u.nom_usage) AS nom, a.alias AS forlife, u.promo
	179	FROM contacts AS c
	180	INNER JOIN auth_user_md5 AS u ON (u.user_id = c.contact)
	181	INNER JOIN aliases AS a ON (u.user_id = a.id AND a.type='a_vie')
	182	WHERE c.uid = {?}
	183	ORDER BY $order
	184	LIMIT {?}, {?}", $uid, $offset*$limit, $limit);
	185	$list = $res->fetchAllAssoc();
	186
	187	return Array($total, $list);
	188	}
	189
3b2f9d11	190	function searchErrorHandler($explain) {
d7610c35	191	$page =& Platal::page();
a7d35093	192	$page->trigError($explain);
3b2f9d11	193	$this->handler_contacts($page);
	194	}
	195
a2aa8436	196	function handler_contacts(&$page, $action = null, $subaction = null, $ssaction = null)
b48a0758	197	{
46f272fe	198	$page->setTitle('Mes contacts');
59a61432	199	$this->_add_rss_link($page);
b48a0758	200
cab08090	201	$uid = S::v('uid');
5e2307dc	202	$user = Env::v('user');
b48a0758	203
e6bf9216 VZ	204	// For XSRF protection, checks both the normal xsrf token, and the special RSS token.
e6bf9216 VZ	205	// It allows direct linking to contact adding in the RSS feed.
40d428d8 VZ	206	if (Env::v('action') && Env::v('token') !== S::v('core_rss_hash')) {
	207	S::assert_xsrf_token();
	208	}
	209	switch (Env::v('action')) {
	210	case 'retirer':
b48a0758	211	if (is_numeric($user)) {
08cce2ff	212	if (XDB::execute('DELETE FROM contacts
8c4a0c30	213	WHERE uid = {?} AND contact = {?}',
8c4a0c30	214	$uid, $user))
b48a0758	215	{
a7d35093	216	$page->trigSuccess("Contact retiré !");
b48a0758	217	}
b48a0758	218	} else {
08cce2ff	219	if (XDB::execute(
e2f609cd	220	'DELETE FROM c
b48a0758	221	USING contacts AS c
	222	INNER JOIN aliases AS a ON (c.contact=a.id and a.type!="homonyme")
	223	WHERE c.uid = {?} AND a.alias={?}', $uid, $user))
	224	{
a7d35093	225	$page->trigSuccess("Contact retiré !");
b48a0758	226	}
	227	}
	228	break;
	229
40d428d8	230	case 'ajouter':
b48a0758	231	require_once('user.func.inc.php');
b48a0758	232	if (($login = get_user_login($user)) !== false) {
08cce2ff	233	if (XDB::execute(
51e10229	234	'REPLACE INTO contacts (uid, contact)
	235	SELECT {?}, id
	236	FROM aliases
	237	WHERE alias = {?}', $uid, $login))
b48a0758	238	{
a7d35093	239	$page->trigSuccess('Contact ajouté !');
b48a0758	240	} else {
a7d35093	241	$page->trigWarning('Contact déjà dans la liste !');
b48a0758	242	}
	243	}
	244	}
	245
a2aa8436	246	$search = false;
	247	if ($action == 'search') {
	248	$action = $subaction;
	249	$subaction = $ssaction;
	250	$search = true;
	251	}
	252	if ($search && trim(Env::v('quick'))) {
	253	require_once 'userset.inc.php';
	254	$base = 'carnet/contacts/search';
3b2f9d11	255
adb07f6f	256	Platal::load('search', 'classes.inc.php');
3b2f9d11	257	ThrowError::$throwHook = array($this, 'searchErrorHandler');
3b2f9d11	258	$view = new SearchSet(true, false, "INNER JOIN contacts AS c2 ON (u.user_id = c2.contact)", "c2.uid = $uid");
a2aa8436	259	} else {
	260	$base = 'carnet/contacts';
	261	$view = new UserSet("INNER JOIN contacts AS c2 ON (u.user_id = c2.contact)", " c2.uid = $uid ");
	262	}
1fae7605	263	$view->addMod('minifiche', 'Mini-fiches', true);
8c4a0c30	264	$view->addMod('trombi', 'Trombinoscope', false, array('with_admin' => false, 'with_promo' => true));
a2aa8436	265	$view->addMod('geoloc', 'Planisphère', false, array('with_annu' => 'carnet/contacts/search'));
	266	$view->apply($base, $page, $action, $subaction);
	267	if ($action != 'geoloc' \|\| ($search && !$ssaction) \|\| (!$search && !$subaction)) {
8c4a0c30	268	$page->changeTpl('carnet/mescontacts.tpl');
b48a0758	269	}
b48a0758	270	}
	271
	272	function handler_pdf(&$page, $arg0 = null, $arg1 = null)
	273	{
460d8f55	274	$this->load('contacts.pdf.inc.php');
b48a0758	275	require_once 'user.func.inc.php';
b48a0758	276
732e5855	277	Platal::session()->close();
b48a0758	278
	279	$sql = "SELECT a.alias
	280	FROM aliases AS a
	281	INNER JOIN auth_user_md5 AS u ON ( a.id = u.user_id )
	282	INNER JOIN contacts AS c ON ( a.id = c.contact )
	283	WHERE c.uid = {?} AND a.type='a_vie'";
	284	if ($arg0 == 'promo') {
	285	$sql .= ' ORDER BY u.promo, u.nom, u.prenom';
	286	} else {
	287	$sql .= ' ORDER BY u.nom, u.prenom, u.promo';
	288	}
	289
cab08090	290	$citer = XDB::iterRow($sql, S::v('uid'));
b48a0758	291	$pdf = new ContactsPDF();
	292
	293	while (list($alias) = $citer->next()) {
	294	$user = get_user_details($alias);
ac73e294	295	foreach ($user as &$value) {
	296	if (is_utf8($value)) {
	297	$value = utf8_decode($value);
	298	}
	299	}
93c099e1	300	$pdf = ContactsPDF::addContact($pdf, $user, $arg0 == 'photos' \|\| $arg1 == 'photos');
b48a0758	301	}
	302	$pdf->Output();
	303
	304	exit;
	305	}
	306
c9f82d49	307	function handler_rss(&$page, $user = null, $hash = null)
c9f82d49	308	{
460d8f55	309	$this->load('feed.inc.php');
4e9a7a6d FB	310	$feed = new CarnetFeed();
4e9a7a6d FB	311	return $feed->run($page, $user, $hash);
c9f82d49	312	}
fbfb06dc	313
963c0b2e	314	function handler_ical(&$page, $alias = null, $hash = null)
fbfb06dc	315	{
963c0b2e	316	require_once 'rss.inc.php';
	317	$uid = init_rss(null, $alias, $hash, false);
	318	if (S::logged()) {
	319	if (!$uid) {
	320	$uid = S::i('uid');
	321	} else if ($uid != S::i('uid')) {
963c0b2e	322	send_warning_email("Récupération d\'un autre utilisateur ($uid)");
	323	}
	324	} else if (!$uid) {
	325	exit;
	326	}
99544d53	327	require_once 'ical.inc.php';
801fcad8	328	$page->changeTpl('carnet/calendar.tpl', NO_SKIN);
3585b0c8	329	$page->register_function('display_ical', 'display_ical');
fbfb06dc	330
f3b3f363	331	$res = XDB::iterRow(
	332	'SELECT u.prenom,
	333	IF(u.nom_usage = \'\',u.nom,u.nom_usage) AS nom,
	334	u.promo,
	335	u.naissance,
	336	DATE_ADD(u.naissance, INTERVAL 1 DAY) AS end,
	337	u.date_ins,
	338	a.alias AS forlife
	339	FROM contacts AS c
	340	INNER JOIN auth_user_md5 AS u ON (u.user_id = c.contact)
	341	INNER JOIN aliases AS a ON (u.user_id = a.id AND a.type = \'a_vie\')
963c0b2e	342	WHERE c.uid = {?}', $uid);
f3b3f363	343
	344	$annivs = Array();
	345	while (list($prenom, $nom, $promo, $naissance, $end, $ts, $forlife) = $res->next()) {
	346	$naissance = str_replace('-', '', $naissance);
	347	$end = str_replace('-', '', $end);
	348	$annivs[] = array(
	349	'timestamp' => strtotime($ts),
	350	'date' => $naissance,
	351	'tomorrow' => $end,
	352	'forlife' => $forlife,
	353	'summary' => 'Anniversaire de '.$prenom
	354	.' '.$nom.' - x '.$promo,
	355	);
fbfb06dc	356	}
f3b3f363	357	$page->assign('events', $annivs);
fbfb06dc	358
fbfb06dc	359	header('Content-Type: text/calendar; charset=utf-8');
fbfb06dc	360	}
5e193297	361
917c4d11	362	function handler_vcard(&$page, $photos = null)
5e193297	363	{
	364	$res = XDB::query('SELECT contact
	365	FROM contacts
	366	WHERE uid = {?}', S::v('uid'));
917c4d11	367	$vcard = new VCard($res->fetchColumn(), $photos == 'photos');
5e193297	368	$vcard->do_page(&$page);
5e193297	369	}
4da0b8d7	370	}
c9f82d49	371
a7de4ef7	372	// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
c9f82d49	373	?>