[platal.git] / include / userset.inc.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                *
 ***************************************************************************/

require_once('user.func.inc.php');

global $globals;

@$globals->search->result_where_statement = '
    LEFT JOIN  applis_ins     AS ai0 ON (u.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 (u.user_id = ai1.uid AND ai1.ordre = 1)
    LEFT JOIN  applis_def     AS ad1 ON (ad1.id = ai1.aid)
    LEFT JOIN  entreprises    AS e   ON (e.entrid = 0 AND e.uid = u.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 n1  ON (u.nationalite = n1.a2)
    LEFT JOIN  geoloc_pays    AS n2  ON (u.nationalite2 = n2.a2)
    LEFT JOIN  geoloc_pays    AS n3  ON (u.nationalite2 = n3.a2)
    LEFT JOIN  adresses       AS adr ON (u.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)
    LEFT JOIN  emails         AS em  ON (em.uid = u.user_id AND em.flags = \'active\')';

class UserSet extends PlSet
{
    public function __construct($joins = '', $where = '')
    {
        global $globals;
        parent::__construct('auth_user_md5 AS u',
                            (!empty($GLOBALS['IS_XNET_SITE']) ?
                                'INNER JOIN groupex.membres AS gxm ON (u.user_id = gxm.uid
                                                                       AND gxm.asso_id = ' . $globals->asso('id') . ') ' : '')
                           . 'LEFT JOIN auth_user_quick AS q USING (user_id)
                              LEFT JOIN aliases         AS a ON (a.id = u.user_id AND a.type = \'a_vie\')
                              ' . $joins,
                            $where,
                            'u.user_id');
    }
}

class SearchSet extends UserSet
{
    public  $advanced = false;
    private $score = null;
    private $order = null;
    private $quick = false;

    public function __construct($quick = false, $no_search = false, $join = '', $where = '')
    {
        require_once dirname(__FILE__).'/../modules/search/search.inc.php';

        if ($no_search) {
            return;
        }

        $this->quick = $quick;
        if ($quick) {
            $this->getQuick($join, $where);
        } else {
            $this->getAdvanced($join, $where);
        }
    }

    private function getQuick($join, $where)
    {
        require_once dirname(__FILE__).'/../modules/search/search.inc.php';
        global $globals;
        if (!S::logged()) {
            Env::kill('with_soundex');
        }
        $qSearch = new QuickSearch('quick');
        $fields  = new SFieldGroup(true, array($qSearch));
        if ($qSearch->isEmpty()) {
            new ThrowError('Aucun critère de recherche n\'est spécifié.');
        }
        $this->score = $qSearch->get_score_statement();
        $pwhere = $fields->get_where_statement();
        if (trim($pwhere)) {
            if (trim($where)) {
                $where .= ' AND ';
            }
            $where .= $pwhere;
        }
        if (S::logged() && Env::has('nonins')) {
            if (trim($where)) {
                $where .= ' AND ';
            }
            $where .= 'u.perms="pending" AND u.deces=0';
        }
        parent::__construct($join . ' ' . $fields->get_select_statement(), $where);

        $this->order = implode(',',array_filter(array($fields->get_order_statement(),
                                                      'u.promo DESC, NomSortKey, prenom')));
    }

    private function getAdvanced($join, $where)
    {
        global $globals;
        $this->advanced = true;
        $fields = new SFieldGroup(true, advancedSearchFromInput());
        if ($fields->too_large()) {
            new ThrowError('Recherche trop générale.');
        }
        parent::__construct(@$join . ' ' . $fields->get_select_statement(),
                            @$where . ' ' . $fields->get_where_statement());
        $this->order = implode(',',array_filter(array($fields->get_order_statement(),
                                                      'promo DESC, NomSortKey, prenom')));
    }

    public function &get($fields, $joins, $where, $groupby, $order, $limitcount = null, $limitfrom = null)
    {
        if ($this->score) {
            $fields .= ', ' . $this->score;
        }
        return parent::get($fields, $joins, $where, $groupby, $order, $limitcount, $limitfrom);
    }
}

class ArraySet extends UserSet
{
    public function __construct(array $users)
    {
        $where = $this->getUids($users);
        if ($where) {
            $where = "a.alias IN ($where)";
        } else {
            $where = " 0 ";
        }
        parent::__construct('', $where);
    }

    private function getUids(array $users)
    {
        $users = get_users_forlife_list($users, true, '_silent_user_callback');
        if (is_null($users)) {
            return '';
        }
        return '\'' . implode('\', \'', $users) . '\'';
    }
}

class MinificheView extends MultipageView
{
    public function __construct(PlSet &$set, $data, array $params)
    {
        require_once 'applis.func.inc.php';
        global $globals;
        $this->entriesPerPage = $globals->search->per_page;
        if (@$params['with_score']) {
            $this->addSortKey('score', array('-score', '-date', '-promo', 'name_sort'), 'pertinence');
        }
        $this->addSortKey('name', array('name_sort'), 'nom');
        $this->addSortKey('promo', array('-promo', 'name_sort'), 'promotion');
        $this->addSortKey('date_mod', array('-date', '-promo', 'name_sort'), 'dernière modification');
        parent::__construct($set, $data, $params);
    }

    public function fields()
    {
        return "u.user_id AS id,
                u.*, a.alias AS forlife,
                u.perms != 'pending' AS inscrit,
                u.perms != 'pending' AS wasinscrit,
                u.deces != 0 AS dcd, u.deces, u.matricule_ax,
                FIND_IN_SET('femme', u.flags) AS sexe,
                e.entreprise, es.label AS secteur, ef.fonction_fr AS fonction,
                IF(n1.nat='',n1.pays,n1.nat) AS nat1, n1.a2 AS iso3166_1,
                IF(n2.nat='',n2.pays,n2.nat) AS nat2, n2.a2 AS iso3166_2,
                IF(n3.nat='',n3.pays,n3.nat) AS nat3, n3.a2 AS iso3166_3,
                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,
                (COUNT(em.email) > 0 OR FIND_IN_SET('googleapps', u.mail_storage) > 0) AS actif,
                nd.display AS name_display, nd.tooltip AS name_tooltip, nd.sort AS name_sort" .
                (S::logged() ? ", c.contact AS contact" : '');
    }

    public function joins()
    {
        return  "LEFT JOIN  entreprises    AS e   ON (e.entrid = 0 AND e.uid = u.user_id".(S::logged() ? "" : " AND e.pub = 'public'").")
                 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 n1  ON (u.nationalite = n1.a2)
                 LEFT JOIN  geoloc_pays    AS n2  ON (u.nationalite2 = n2.a2)
                 LEFT JOIN  geoloc_pays    AS n3  ON (u.nationalite3 = n3.a2)
                 LEFT JOIN  applis_ins     AS ai0 ON (u.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 (u.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 (u.user_id = adr.uid
                                                      AND FIND_IN_SET('active', adr.statut)".(S::logged() ? "" : " AND adr.pub = 'public'").")
                 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)
                 LEFT JOIN  emails         AS em  ON (em.uid = u.user_id AND em.flags = 'active')
                INNER JOIN  profile_names_display AS nd  ON (nd.user_id = u.user_id)" .
                (S::logged() ?
                 "LEFT JOIN  contacts       AS c   On (c.contact = u.user_id AND c.uid = " . S::v('uid') . ")"
                 : "");
    }

    public function bounds()
    {
        $order = Env::v('order', $this->defaultkey);
        $show_bounds = 0;
        if (($order == "name") || ($order == "-name")) {
            $this->bound_field = "nom";
            $show_bounds = 1;
        } elseif (($order == "promo") || ($order == "-promo")) {
            $this->bound_field = "promo";
            $show_bounds = -1;
        }
        if ($order{0} == '-') {
            $show_bounds = -$show_bounds;
        }
        return $show_bounds;
    }

    public function templateName()
    {
        return 'include/plview.minifiche.tpl';
    }
}

class MentorView extends MultipageView
{
    public function __construct(PlSet &$set, $data, array $params)
    {
        $this->entriesPerPage = 10;
        $this->addSortKey('rand', array('RAND(' . S::i('uid') . ')'), 'aléatoirement');
        $this->addSortKey('name', array('name_sort'), 'nom');
        $this->addSortKey('promo', array('-promo', 'name_sort'), 'promotion');
        $this->addSortKey('date_mod', array('-date', '-promo', 'name_sort'), 'dernière modification');
        parent::__construct($set, $data, $params);
    }

    public function fields()
    {
        return "m.uid, u.promo,
                a.alias AS bestalias, m.expertise, mp.pid,
                ms.secteur, ms.ss_secteur,
                nd.display AS name_display, nd.tooltip AS name_tooltip, nd.sort AS name_sort";
    }

    public function joins()
    {
        return "INNER JOIN  profile_names_display AS nd ON (nd.user_id = u.user_id)";
    }

    public function bounds()
    {
        $order = Env::v('order', $this->defaultkey);
        $show_bounds = 0;
        if (($order == "name") || ($order == "-name")) {
            $this->bound_field = "nom";
            $show_bounds = 1;
        } elseif (($order == "promo") || ($order == "-promo")) {
            $this->bound_field = "promo";
            $show_bounds = -1;
        }
        if ($order{0} == '-') {
            $show_bounds = -$show_bounds;
        }
        return $show_bounds;
    }

    public function templateName()
    {
        return 'include/plview.referent.tpl';
    }
}

class TrombiView extends MultipageView
{
    public function __construct(PlSet &$set, $data, array $params)
    {
        $this->entriesPerPage = 24;
        $this->order = explode(',', Env::v('order', 'name_sort'));
        if (@$params['with_score']) {
            $this->addSortKey('score', array('-score', '-watch_last', '-promo', 'name_sort'), 'pertinence');
        }
        $this->addSortKey('name', array('name_sort'), 'nom');
        $this->addSortKey('promo', array('-promo', 'name_sort'), 'promotion');
        parent::__construct($set, $data, $params);
    }

    public function fields()
    {
        return "u.user_id, nd.display AS name_display, nd.tooltip AS name_tooltip, nd.sort AS name_sort, u.promo, a.alias AS forlife ";
    }

    public function joins()
    {
        return "INNER JOIN  photo AS p ON (p.uid = u.user_id)
                INNER JOIN  profile_names_display AS nd ON (nd.user_id = u.user_id)";
    }

    public function bounds()
    {
        $order = Env::v('order', $this->defaultkey);
        $show_bounds = 0;
        if (($order == "name") || ($order == "-name")) {
            $this->bound_field = "nom";
            $show_bounds = 1;
        } elseif (($order == "promo") || ($order == "-promo")) {
            $this->bound_field = "promo";
            $show_bounds = -1;
        }
        if ($order{0} == '-') {
            $show_bounds = -$show_bounds;
        }
        return $show_bounds;
    }

    public function templateName()
    {
        return 'include/plview.trombi.tpl';
    }

    public function apply(PlPage &$page)
    {
        if (!empty($GLOBALS['IS_XNET_SITE'])) {
            global $globals;
            $page->assign('mainsiteurl', 'https://' . $globals->core->secure_domain . '/');
        }
        return parent::apply($page);
    }
}

class GeolocView implements PlView
{
    private $set;
    private $type;
    private $params;

    public function __construct(PlSet &$set, $data, array $params)
    {
        $this->params = $params;
        $this->set   =& $set;
        $this->type   = $data;
    }

    private function use_map()
    {
        return is_file(dirname(__FILE__) . '/../modules/geoloc/dynamap.swf') &&
               is_file(dirname(__FILE__) . '/../modules/geoloc/icon.swf');
    }

    public function args()
    {
        $args = $this->set->args();
        unset($args['initfile']);
        unset($args['mapid']);
        return $args;
    }

    public function apply(PlPage &$page)
    {
        require_once 'geoloc.inc.php';
        require_once '../modules/search/search.inc.php';

        switch ($this->type) {
          case 'icon.swf':
            header("Content-type: application/x-shockwave-flash");
            header("Pragma:");
            readfile(dirname(__FILE__).'/../modules/geoloc/icon.swf');
            exit;

          case 'dynamap.swf':
            header("Content-type: application/x-shockwave-flash");
            header("Pragma:");
            readfile(dirname(__FILE__).'/../modules/geoloc/dynamap.swf');
            exit;

          case 'init':
            $page->changeTpl('geoloc/init.tpl', NO_SKIN);
            header('Content-Type: text/xml');
            header('Pragma:');
            if (!empty($GLOBALS['IS_XNET_SITE'])) {
                $page->assign('background', 0xF2E9D0);
            }
            break;

          case 'city':
            $page->changeTpl('geoloc/city.tpl', NO_SKIN);
            header('Content-Type: text/xml');
            header('Pragma:');
            $only_current = Env::v('only_current', false)? ' AND FIND_IN_SET(\'active\', adrf.statut)' : '';
            $it =& $this->set->get('u.user_id AS id, u.prenom, u.nom, u.promo, al.alias',
                                   "INNER JOIN  adresses AS adrf  ON (adrf.uid = u.user_id $only_current)
                                     LEFT JOIN  aliases  AS al   ON (u.user_id = al.id
                                                                   AND FIND_IN_SET('bestalias', al.flags))
                                    INNER JOIN  adresses AS avg ON (" . getadr_join('avg') . ")",
                                   'adrf.cityid = ' . Env::i('cityid'), null, null, 11);
            $page->assign('users', $it);
            break;

          case 'country':
            if (Env::has('debug')) {
                $page->changeTpl('geoloc/country.tpl', SIMPLE);
            } else {
                $page->changeTpl('geoloc/country.tpl', NO_SKIN);
                header('Content-Type: text/xml');
                header('Pragma:');
            }
            $mapid = Env::has('mapid') ? Env::i('mapid', -2) : false;
            list($countries, $cities) = geoloc_getData_subcountries($mapid, $this->set, 10);
            $page->assign('countries', $countries);
            $page->assign('cities', $cities);
            break;

          default:
            global $globals;
            if (!$this->use_map()) {
                $page->assign('request_geodesix', true);
            }
            $page->assign('annu', @$this->params['with_annu']);
            $page->assign('protocole', @$_SERVER['HTTPS'] ? 'https' : 'http');
            $this->set->get('u.user_id', null, "u.perms != 'pending' AND u.deces = 0", "u.user_id", null);
            return 'include/plview.geoloc.tpl';
        }
    }
}

class GadgetView implements PlView
{
    public function __construct(PlSet &$set, $data, array $params)
    {
        $this->set =& $set;
    }

    public function fields()
    {
        return "u.user_id AS id,
                u.*, a.alias AS forlife," .
               "u.perms != 'pending' AS inscrit,
                u.perms != 'pending' AS wasinscrit,
                u.deces != 0 AS dcd, u.deces,
                FIND_IN_SET('femme', u.flags) AS sexe,
                adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region" .
                (S::logged() ? ", c.contact AS contact" : '');
    }

    public function joins()
    {
        return  "LEFT JOIN  adresses       AS adr ON (u.user_id = adr.uid AND FIND_IN_SET('active', adr.statut)".(S::logged() ? "" : " AND adr.pub = 'public'").")
                 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)" .
                (S::logged() ?
                 "LEFT JOIN  contacts       AS c   On (c.contact = u.user_id AND c.uid = " . S::v('uid') . ")"
                 : "");
    }

    public function apply(PlPage &$page)
    {
        $page->assign_by_ref('set',
          $this->set->get($this->fields(), $this->joins(), null, null, null, 5, 0));
    }

    public function args()
    {
        return null;
    }
}

// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
?>
Commit	Line	Data
8c4a0c30	1	<?php
8c4a0c30	2	/***************************************************************************
179afa7f	3	* Copyright (C) 2003-2008 Polytechnique.org *
8c4a0c30	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
8c4a0c30	22	require_once('user.func.inc.php');
	23
	24	global $globals;
	25
35fa92e8	26	@$globals->search->result_where_statement = '
8c4a0c30	27	LEFT JOIN applis_ins AS ai0 ON (u.user_id = ai0.uid AND ai0.ordre = 0)
	28	LEFT JOIN applis_def AS ad0 ON (ad0.id = ai0.aid)
	29	LEFT JOIN applis_ins AS ai1 ON (u.user_id = ai1.uid AND ai1.ordre = 1)
	30	LEFT JOIN applis_def AS ad1 ON (ad1.id = ai1.aid)
	31	LEFT JOIN entreprises AS e ON (e.entrid = 0 AND e.uid = u.user_id)
	32	LEFT JOIN emploi_secteur AS es ON (e.secteur = es.id)
	33	LEFT JOIN fonctions_def AS ef ON (e.fonction = ef.id)
eeb2ec0f SJ	34	LEFT JOIN geoloc_pays AS n1 ON (u.nationalite = n1.a2)
	35	LEFT JOIN geoloc_pays AS n2 ON (u.nationalite2 = n2.a2)
	36	LEFT JOIN geoloc_pays AS n3 ON (u.nationalite2 = n3.a2)
8c4a0c30	37	LEFT JOIN adresses AS adr ON (u.user_id = adr.uid AND FIND_IN_SET(\'active\',adr.statut))
	38	LEFT JOIN geoloc_pays AS gp ON (adr.country = gp.a2)
	39	LEFT JOIN geoloc_region AS gr ON (adr.country = gr.a2 AND adr.region = gr.region)
	40	LEFT JOIN emails AS em ON (em.uid = u.user_id AND em.flags = \'active\')';
	41
	42	class UserSet extends PlSet
	43	{
	44	public function __construct($joins = '', $where = '')
	45	{
	46	global $globals;
	47	parent::__construct('auth_user_md5 AS u',
eaf30d86 PH	48	(!empty($GLOBALS['IS_XNET_SITE']) ?
eaf30d86 PH	49	'INNER JOIN groupex.membres AS gxm ON (u.user_id = gxm.uid
8c4a0c30	50	AND gxm.asso_id = ' . $globals->asso('id') . ') ' : '')
eaf30d86	51	. 'LEFT JOIN auth_user_quick AS q USING (user_id)
9d66aa4a	52	LEFT JOIN aliases AS a ON (a.id = u.user_id AND a.type = \'a_vie\')
8c4a0c30	53	' . $joins,
	54	$where,
	55	'u.user_id');
	56	}
	57	}
	58
	59	class SearchSet extends UserSet
	60	{
86b5c8f0	61	public $advanced = false;
35fa92e8	62	private $score = null;
8c4a0c30	63	private $order = null;
	64	private $quick = false;
	65
a2aa8436	66	public function __construct($quick = false, $no_search = false, $join = '', $where = '')
8c4a0c30	67	{
	68	require_once dirname(__FILE__).'/../modules/search/search.inc.php';
	69
	70	if ($no_search) {
	71	return;
	72	}
	73
	74	$this->quick = $quick;
	75	if ($quick) {
a2aa8436	76	$this->getQuick($join, $where);
8c4a0c30	77	} else {
a2aa8436	78	$this->getAdvanced($join, $where);
8c4a0c30	79	}
	80	}
	81
a2aa8436	82	private function getQuick($join, $where)
8c4a0c30	83	{
	84	require_once dirname(__FILE__).'/../modules/search/search.inc.php';
	85	global $globals;
	86	if (!S::logged()) {
	87	Env::kill('with_soundex');
	88	}
	89	$qSearch = new QuickSearch('quick');
	90	$fields = new SFieldGroup(true, array($qSearch));
	91	if ($qSearch->isEmpty()) {
8d118e58	92	new ThrowError('Aucun critère de recherche n\'est spécifié.');
8c4a0c30	93	}
35fa92e8	94	$this->score = $qSearch->get_score_statement();
3b2f9d11	95	$pwhere = $fields->get_where_statement();
	96	if (trim($pwhere)) {
	97	if (trim($where)) {
	98	$where .= ' AND ';
	99	}
	100	$where .= $pwhere;
	101	}
	102	if (S::logged() && Env::has('nonins')) {
	103	if (trim($where)) {
	104	$where .= ' AND ';
	105	}
	106	$where .= 'u.perms="pending" AND u.deces=0';
	107	}
	108	parent::__construct($join . ' ' . $fields->get_select_statement(), $where);
8c4a0c30	109
	110	$this->order = implode(',',array_filter(array($fields->get_order_statement(),
	111	'u.promo DESC, NomSortKey, prenom')));
	112	}
	113
63fac48e	114	private function getAdvanced($join, $where)
8c4a0c30	115	{
8c4a0c30	116	global $globals;
86b5c8f0	117	$this->advanced = true;
8c4a0c30	118	$fields = new SFieldGroup(true, advancedSearchFromInput());
	119	if ($fields->too_large()) {
	120	new ThrowError('Recherche trop générale.');
	121	}
137e819f FB	122	parent::__construct(@$join . ' ' . $fields->get_select_statement(),
137e819f FB	123	@$where . ' ' . $fields->get_where_statement());
8c4a0c30	124	$this->order = implode(',',array_filter(array($fields->get_order_statement(),
	125	'promo DESC, NomSortKey, prenom')));
	126	}
35fa92e8	127
	128	public function &get($fields, $joins, $where, $groupby, $order, $limitcount = null, $limitfrom = null)
	129	{
	130	if ($this->score) {
	131	$fields .= ', ' . $this->score;
	132	}
	133	return parent::get($fields, $joins, $where, $groupby, $order, $limitcount, $limitfrom);
	134	}
8c4a0c30	135	}
8c4a0c30	136
1cc0afe7	137	class ArraySet extends UserSet
	138	{
	139	public function __construct(array $users)
	140	{
	141	$where = $this->getUids($users);
	142	if ($where) {
	143	$where = "a.alias IN ($where)";
	144	} else {
	145	$where = " 0 ";
	146	}
	147	parent::__construct('', $where);
	148	}
	149
	150	private function getUids(array $users)
	151	{
	152	$users = get_users_forlife_list($users, true, '_silent_user_callback');
	153	if (is_null($users)) {
	154	return '';
	155	}
	156	return '\'' . implode('\', \'', $users) . '\'';
	157	}
	158	}
	159
8c4a0c30	160	class MinificheView extends MultipageView
	161	{
	162	public function __construct(PlSet &$set, $data, array $params)
	163	{
	164	require_once 'applis.func.inc.php';
	165	global $globals;
	166	$this->entriesPerPage = $globals->search->per_page;
35fa92e8	167	if (@$params['with_score']) {
cd5bd7dc	168	$this->addSortKey('score', array('-score', '-date', '-promo', 'name_sort'), 'pertinence');
35fa92e8	169	}
cd5bd7dc PC	170	$this->addSortKey('name', array('name_sort'), 'nom');
	171	$this->addSortKey('promo', array('-promo', 'name_sort'), 'promotion');
	172	$this->addSortKey('date_mod', array('-date', '-promo', 'name_sort'), 'dernière modification');
8c4a0c30	173	parent::__construct($set, $data, $params);
	174	}
	175
	176	public function fields()
	177	{
	178	return "u.user_id AS id,
	179	u.*, a.alias AS forlife,
	180	u.perms != 'pending' AS inscrit,
	181	u.perms != 'pending' AS wasinscrit,
	182	u.deces != 0 AS dcd, u.deces, u.matricule_ax,
	183	FIND_IN_SET('femme', u.flags) AS sexe,
	184	e.entreprise, es.label AS secteur, ef.fonction_fr AS fonction,
eeb2ec0f SJ	185	IF(n1.nat='',n1.pays,n1.nat) AS nat1, n1.a2 AS iso3166_1,
	186	IF(n2.nat='',n2.pays,n2.nat) AS nat2, n2.a2 AS iso3166_2,
	187	IF(n3.nat='',n3.pays,n3.nat) AS nat3, n3.a2 AS iso3166_3,
8c4a0c30	188	ad0.text AS app0text, ad0.url AS app0url, ai0.type AS app0type,
	189	ad1.text AS app1text, ad1.url AS app1url, ai1.type AS app1type,
	190	adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region,
cd5bd7dc PC	191	(COUNT(em.email) > 0 OR FIND_IN_SET('googleapps', u.mail_storage) > 0) AS actif,
cd5bd7dc PC	192	nd.display AS name_display, nd.tooltip AS name_tooltip, nd.sort AS name_sort" .
0e5ec860	193	(S::logged() ? ", c.contact AS contact" : '');
8c4a0c30	194	}
	195
	196	public function joins()
	197	{
f3af95c0	198	return "LEFT JOIN entreprises AS e ON (e.entrid = 0 AND e.uid = u.user_id".(S::logged() ? "" : " AND e.pub = 'public'").")
8c4a0c30	199	LEFT JOIN emploi_secteur AS es ON (e.secteur = es.id)
8c4a0c30	200	LEFT JOIN fonctions_def AS ef ON (e.fonction = ef.id)
eeb2ec0f SJ	201	LEFT JOIN geoloc_pays AS n1 ON (u.nationalite = n1.a2)
	202	LEFT JOIN geoloc_pays AS n2 ON (u.nationalite2 = n2.a2)
	203	LEFT JOIN geoloc_pays AS n3 ON (u.nationalite3 = n3.a2)
8c4a0c30	204	LEFT JOIN applis_ins AS ai0 ON (u.user_id = ai0.uid AND ai0.ordre = 0)
	205	LEFT JOIN applis_def AS ad0 ON (ad0.id = ai0.aid)
	206	LEFT JOIN applis_ins AS ai1 ON (u.user_id = ai1.uid AND ai1.ordre = 1)
	207	LEFT JOIN applis_def AS ad1 ON (ad1.id = ai1.aid)
	208	LEFT JOIN adresses AS adr ON (u.user_id = adr.uid
f3af95c0	209	AND FIND_IN_SET('active', adr.statut)".(S::logged() ? "" : " AND adr.pub = 'public'").")
8c4a0c30	210	LEFT JOIN geoloc_pays AS gp ON (adr.country = gp.a2)
8c4a0c30	211	LEFT JOIN geoloc_region AS gr ON (adr.country = gr.a2 AND adr.region = gr.region)
cd5bd7dc PC	212	LEFT JOIN emails AS em ON (em.uid = u.user_id AND em.flags = 'active')
cd5bd7dc PC	213	INNER JOIN profile_names_display AS nd ON (nd.user_id = u.user_id)" .
eaf30d86	214	(S::logged() ?
86b5c8f0	215	"LEFT JOIN contacts AS c On (c.contact = u.user_id AND c.uid = " . S::v('uid') . ")"
86b5c8f0	216	: "");
8c4a0c30	217	}
8c4a0c30	218
b71b2a36 SJ	219	public function bounds()
	220	{
	221	$order = Env::v('order', $this->defaultkey);
	222	$show_bounds = 0;
	223	if (($order == "name") \|\| ($order == "-name")) {
	224	$this->bound_field = "nom";
	225	$show_bounds = 1;
	226	} elseif (($order == "promo") \|\| ($order == "-promo")) {
	227	$this->bound_field = "promo";
	228	$show_bounds = -1;
	229	}
	230	if ($order{0} == '-') {
	231	$show_bounds = -$show_bounds;
	232	}
	233	return $show_bounds;
	234	}
	235
8c4a0c30	236	public function templateName()
	237	{
	238	return 'include/plview.minifiche.tpl';
	239	}
	240	}
	241
ff3eb9b7	242	class MentorView extends MultipageView
	243	{
	244	public function __construct(PlSet &$set, $data, array $params)
	245	{
eaf30d86	246	$this->entriesPerPage = 10;
ff3eb9b7	247	$this->addSortKey('rand', array('RAND(' . S::i('uid') . ')'), 'aléatoirement');
cd5bd7dc PC	248	$this->addSortKey('name', array('name_sort'), 'nom');
	249	$this->addSortKey('promo', array('-promo', 'name_sort'), 'promotion');
	250	$this->addSortKey('date_mod', array('-date', '-promo', 'name_sort'), 'dernière modification');
eaf30d86	251	parent::__construct($set, $data, $params);
ff3eb9b7	252	}
	253
	254	public function fields()
	255	{
cd5bd7dc	256	return "m.uid, u.promo,
ff3eb9b7	257	a.alias AS bestalias, m.expertise, mp.pid,
cd5bd7dc PC	258	ms.secteur, ms.ss_secteur,
	259	nd.display AS name_display, nd.tooltip AS name_tooltip, nd.sort AS name_sort";
	260	}
	261
	262	public function joins()
	263	{
	264	return "INNER JOIN profile_names_display AS nd ON (nd.user_id = u.user_id)";
ff3eb9b7	265	}
ff3eb9b7	266
b71b2a36 SJ	267	public function bounds()
	268	{
	269	$order = Env::v('order', $this->defaultkey);
	270	$show_bounds = 0;
	271	if (($order == "name") \|\| ($order == "-name")) {
	272	$this->bound_field = "nom";
	273	$show_bounds = 1;
	274	} elseif (($order == "promo") \|\| ($order == "-promo")) {
	275	$this->bound_field = "promo";
	276	$show_bounds = -1;
	277	}
	278	if ($order{0} == '-') {
	279	$show_bounds = -$show_bounds;
	280	}
	281	return $show_bounds;
	282	}
	283
ff3eb9b7	284	public function templateName()
	285	{
	286	return 'include/plview.referent.tpl';
	287	}
	288	}
	289
8c4a0c30	290	class TrombiView extends MultipageView
	291	{
	292	public function __construct(PlSet &$set, $data, array $params)
	293	{
	294	$this->entriesPerPage = 24;
cd5bd7dc	295	$this->order = explode(',', Env::v('order', 'name_sort'));
35fa92e8	296	if (@$params['with_score']) {
cd5bd7dc	297	$this->addSortKey('score', array('-score', '-watch_last', '-promo', 'name_sort'), 'pertinence');
35fa92e8	298	}
cd5bd7dc PC	299	$this->addSortKey('name', array('name_sort'), 'nom');
cd5bd7dc PC	300	$this->addSortKey('promo', array('-promo', 'name_sort'), 'promotion');
8c4a0c30	301	parent::__construct($set, $data, $params);
	302	}
	303
	304	public function fields()
	305	{
cd5bd7dc	306	return "u.user_id, nd.display AS name_display, nd.tooltip AS name_tooltip, nd.sort AS name_sort, u.promo, a.alias AS forlife ";
8c4a0c30	307	}
	308
	309	public function joins()
	310	{
cd5bd7dc PC	311	return "INNER JOIN photo AS p ON (p.uid = u.user_id)
cd5bd7dc PC	312	INNER JOIN profile_names_display AS nd ON (nd.user_id = u.user_id)";
8c4a0c30	313	}
8c4a0c30	314
b71b2a36 SJ	315	public function bounds()
	316	{
	317	$order = Env::v('order', $this->defaultkey);
	318	$show_bounds = 0;
	319	if (($order == "name") \|\| ($order == "-name")) {
	320	$this->bound_field = "nom";
	321	$show_bounds = 1;
	322	} elseif (($order == "promo") \|\| ($order == "-promo")) {
	323	$this->bound_field = "promo";
	324	$show_bounds = -1;
	325	}
	326	if ($order{0} == '-') {
	327	$show_bounds = -$show_bounds;
	328	}
	329	return $show_bounds;
	330	}
	331
8c4a0c30	332	public function templateName()
	333	{
	334	return 'include/plview.trombi.tpl';
	335	}
	336
04334c61	337	public function apply(PlPage &$page)
8c4a0c30	338	{
	339	if (!empty($GLOBALS['IS_XNET_SITE'])) {
	340	global $globals;
	341	$page->assign('mainsiteurl', 'https://' . $globals->core->secure_domain . '/');
	342	}
	343	return parent::apply($page);
	344	}
	345	}
	346
	347	class GeolocView implements PlView
	348	{
	349	private $set;
	350	private $type;
	351	private $params;
	352
	353	public function __construct(PlSet &$set, $data, array $params)
	354	{
	355	$this->params = $params;
	356	$this->set =& $set;
	357	$this->type = $data;
	358	}
	359
	360	private function use_map()
	361	{
	362	return is_file(dirname(__FILE__) . '/../modules/geoloc/dynamap.swf') &&
	363	is_file(dirname(__FILE__) . '/../modules/geoloc/icon.swf');
	364	}
	365
35fa92e8	366	public function args()
8c4a0c30	367	{
35fa92e8	368	$args = $this->set->args();
	369	unset($args['initfile']);
	370	unset($args['mapid']);
	371	return $args;
8c4a0c30	372	}
8c4a0c30	373
04334c61	374	public function apply(PlPage &$page)
8c4a0c30	375	{
	376	require_once 'geoloc.inc.php';
	377	require_once '../modules/search/search.inc.php';
	378
	379	switch ($this->type) {
	380	case 'icon.swf':
	381	header("Content-type: application/x-shockwave-flash");
	382	header("Pragma:");
	383	readfile(dirname(__FILE__).'/../modules/geoloc/icon.swf');
	384	exit;
	385
	386	case 'dynamap.swf':
	387	header("Content-type: application/x-shockwave-flash");
	388	header("Pragma:");
	389	readfile(dirname(__FILE__).'/../modules/geoloc/dynamap.swf');
	390	exit;
	391
	392	case 'init':
	393	$page->changeTpl('geoloc/init.tpl', NO_SKIN);
	394	header('Content-Type: text/xml');
	395	header('Pragma:');
	396	if (!empty($GLOBALS['IS_XNET_SITE'])) {
	397	$page->assign('background', 0xF2E9D0);
	398	}
8c4a0c30	399	break;
	400
	401	case 'city':
	402	$page->changeTpl('geoloc/city.tpl', NO_SKIN);
	403	header('Content-Type: text/xml');
	404	header('Pragma:');
a2aa8436	405	$only_current = Env::v('only_current', false)? ' AND FIND_IN_SET(\'active\', adrf.statut)' : '';
8c4a0c30	406	$it =& $this->set->get('u.user_id AS id, u.prenom, u.nom, u.promo, al.alias',
a2aa8436	407	"INNER JOIN adresses AS adrf ON (adrf.uid = u.user_id $only_current)
8c4a0c30	408	LEFT JOIN aliases AS al ON (u.user_id = al.id
010268b2	409	AND FIND_IN_SET('bestalias', al.flags))
97eff0ff	410	INNER JOIN adresses AS avg ON (" . getadr_join('avg') . ")",
8c4a0c30	411	'adrf.cityid = ' . Env::i('cityid'), null, null, 11);
	412	$page->assign('users', $it);
	413	break;
	414
	415	case 'country':
	416	if (Env::has('debug')) {
	417	$page->changeTpl('geoloc/country.tpl', SIMPLE);
	418	} else {
	419	$page->changeTpl('geoloc/country.tpl', NO_SKIN);
	420	header('Content-Type: text/xml');
	421	header('Pragma:');
	422	}
8c4a0c30	423	$mapid = Env::has('mapid') ? Env::i('mapid', -2) : false;
	424	list($countries, $cities) = geoloc_getData_subcountries($mapid, $this->set, 10);
	425	$page->assign('countries', $countries);
	426	$page->assign('cities', $cities);
	427	break;
	428
	429	default:
	430	global $globals;
	431	if (!$this->use_map()) {
	432	$page->assign('request_geodesix', true);
	433	}
a2aa8436	434	$page->assign('annu', @$this->params['with_annu']);
8c4a0c30	435	$page->assign('protocole', @$_SERVER['HTTPS'] ? 'https' : 'http');
8c4a0c30	436	$this->set->get('u.user_id', null, "u.perms != 'pending' AND u.deces = 0", "u.user_id", null);
8c4a0c30	437	return 'include/plview.geoloc.tpl';
	438	}
	439	}
	440	}
	441
92e80560 VZ	442	class GadgetView implements PlView
	443	{
	444	public function __construct(PlSet &$set, $data, array $params)
	445	{
	446	$this->set =& $set;
	447	}
	448
	449	public function fields()
	450	{
	451	return "u.user_id AS id,
	452	u.*, a.alias AS forlife," .
92e80560 VZ	453	"u.perms != 'pending' AS inscrit,
	454	u.perms != 'pending' AS wasinscrit,
	455	u.deces != 0 AS dcd, u.deces,
	456	FIND_IN_SET('femme', u.flags) AS sexe,
	457	adr.city, gp.a2, gp.pays AS countrytxt, gr.name AS region" .
	458	(S::logged() ? ", c.contact AS contact" : '');
	459	}
	460
	461	public function joins()
	462	{
	463	return "LEFT JOIN adresses AS adr ON (u.user_id = adr.uid AND FIND_IN_SET('active', adr.statut)".(S::logged() ? "" : " AND adr.pub = 'public'").")
	464	LEFT JOIN geoloc_pays AS gp ON (adr.country = gp.a2)
	465	LEFT JOIN geoloc_region AS gr ON (adr.country = gr.a2 AND adr.region = gr.region)" .
	466	(S::logged() ?
	467	"LEFT JOIN contacts AS c On (c.contact = u.user_id AND c.uid = " . S::v('uid') . ")"
	468	: "");
	469	}
	470
04334c61	471	public function apply(PlPage &$page)
92e80560 VZ	472	{
	473	$page->assign_by_ref('set',
	474	$this->set->get($this->fields(), $this->joins(), null, null, null, 5, 0));
	475	}
	476
	477	public function args()
	478	{
	479	return null;
	480	}
	481	}
	482
8c4a0c30	483	// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
8c4a0c30	484	?>