Adds MapView.
[platal.git] / include / userset.inc.php
index 56dac4b..55521c7 100644 (file)
@@ -1,6 +1,6 @@
 <?php
 /***************************************************************************
- *  Copyright (C) 2003-2009 Polytechnique.org                              *
+ *  Copyright (C) 2003-2011 Polytechnique.org                              *
  *  http://opensource.polytechnique.org/                                   *
  *                                                                         *
  *  This program is free software; you can redistribute it and/or modify   *
 
 class UserSet extends PlSet
 {
-    public function __construct(PlFilterCondition &$cond, $orders)
+    public function __construct(PlFilterCondition $cond, $orders = null)
     {
         parent::__construct($cond, $orders);
     }
 
-    protected function buildFilter(PlFilterCondition &$cond, $orders)
+    protected function buildFilter(PlFilterCondition $cond, $orders)
     {
         return new UserFilter($cond, $orders);
     }
 }
 
-class SearchSet extends UserSet
+class ProfileSet extends PlSet
 {
-    public  $advanced = false;
-    private $score    = null;
-    private $conds    = null;
-    private $orders   = null;
-    private $quick    = false;
+    public function __construct(PlFilterCondition $cond, $orders = null)
+    {
+        parent::__construct($cond, $orders);
+    }
 
-    public function __construct($quick = false, $no_search = false, PlFilterCondition $cond = null)
+    protected function buildFilter(PlFilterCondition $cond, $orders)
     {
-        Platal::load('search', 'search.inc.php');
+        return new ProfileFilter($cond, $orders);
+    }
+}
 
-        if ($no_search) {
-            return;
-        }
+require_once "ufbuilder.inc.php";
 
-        $this->quick = $quick;
+class SearchSet extends ProfileSet
+{
+    protected $score    = null;
+    protected $valid    = true;
 
+    public function __construct(UserFilterBuilder $ufb, PlFilterCondition $cond = null)
+    {
         if (is_null($cond)) {
-            $this->conds = new PFC_And();
+            $conds = new PFC_And();
         } else if ($cond instanceof PFC_And) {
-            $this->conds = $cond;
+            $conds = $cond;
         } else {
-            $this->conds = new PFC_And($cond);
-        }
-
-        if ($quick) {
-            $this->getQuick();
-        } else {
-            $this->getAdvanced();
-        }
-    }
-
-    private function getQuick()
-    {
-        if (!S::logged()) {
-            Env::kill('with_soundex');
+            $conds = new PFC_And($cond);
         }
 
-        require_once 'ufbuilder.inc.php';
-        $ufb = new UFB_QuickSearch();
-
         if (!$ufb->isValid()) {
+            $this->valid = false;
             return;
         }
 
-        $this->conds->addChild($ufb->getUFC());
+        $ufc = $ufb->getUFC();
+        $conds->addChild($ufc);
 
         $orders = $ufb->getOrders();
-        $orders[] = new UFO_Promo(UserFilter::DISPLAY, true);
-        $orders[] = new UFO_Promo(UserFilter::DN_SORT);
-
-        if (S::logged() && Env::has('nonins')) {
-            $this->conds = new PFC_And($this->conds,
-                new UFC_Not(new UFC_Dead()),
-                new UFC_Registered()
-            );
-        }
 
-        parent::__construct($this->conds, $orders);
+        parent::__construct($conds, $orders);
     }
 
-    private function getAdvanced()
+    public function isValid()
     {
-        $this->advanced = true;
-        require_once 'ufbuilder.inc.php';
-        $ufb = new UFB_AdvancedSearch();
+        return $this->valid;
+    }
 
-        if (!$ufb->isValid()) {
-            return;
+    /** Add a "rechercher=Chercher" field to the query to simulate the POST
+     * behaviour.
+     */
+    public function args()
+    {
+        $args = parent::args();
+        if (!isset($args['rechercher'])) {
+            $args['rechercher'] = 'Chercher';
         }
+        return $args;
+    }
 
-        $this->conds->addChild($ufb->getUFC());
+    protected function &getFilterResults(PlFilter $pf, PlLimit $limit)
+    {
+        $profiles = $pf->getProfiles($limit, Profile::FETCH_MINIFICHES);
+        return $profiles;
     }
+}
 
-    public function &get(PlLimit $limit = null)
+// Specialized SearchSet for quick search.
+class QuickSearchSet extends SearchSet
+{
+    public function __construct(PlFilterCondition $cond = null)
     {
-        $uf = $this->buildFilter($this->conds, $this->orders);
-        if (is_null($limit)) {
-            $limit = new PlLimit(20, 0);
+        if (!S::logged()) {
+            Env::kill('with_soundex');
         }
-        $it          = $uf->getProfiles($limit);
-        $this->count = $uf->getTotalCount();
-        return $it;
+
+        parent::__construct(new UFB_QuickSearch(), $cond);
     }
 }
 
-class ArraySet extends UserSet
+// Specialized SearchSet for advanced search.
+class AdvancedSearchSet extends SearchSet
 {
-    public function __construct(array $users)
+    public function __construct($xorg_admin_fields, $ax_admin_fields,
+                                PlFilterCondition $cond = null)
     {
-        $hruids = User::getBulkHruid($users, array('User', '_silent_user_callback'));
-        if (is_null($hruids) || count($hruids) == 0) {
-            $cond = new PFC_False();
-        } else {
-            $cond = new UFC_Hruid($hruids);
-        }
-        parent::__construct($cond);
+        parent::__construct(new UFB_AdvancedSearch($xorg_admin_fields, $ax_admin_fields),
+                            $cond);
     }
 }
 
-class MinificheView extends MultipageView
+/** Simple set based on an array of User emails
+ */
+class UserArraySet extends UserSet
 {
-    public function __construct(PlSet &$set, $data, array $params)
+    public function __construct(array $emails)
     {
-        require_once 'education.func.inc.php';
-        global $globals;
-        $this->entriesPerPage = $globals->search->per_page;
-        if (@$params['with_score']) {
-            $this->addSort(new PlViewOrder('score', array(
-                    new UFO_Score(true),
-                    new UFO_ProfileUpdate(true),
-                    new UFO_Promo(UserFilter::DISPLAY, true),
-                    new UFO_Name(UserFilter::DN_SORT),
-                ), 'pertinence'));
-        }
-        $this->addSort(new PlViewOrder(
-                            'name',
-                            array(new UFO_Name(UserFilter::DN_SORT)),
-                            'nom'));
-        $this->addSort(new PlViewOrder('promo', array(
-                    new UFO_Promo(UserFilter::DISPLAY, true),
-                    new UFO_Name(UserFilter::DN_SORT),
-                ), 'promotion'));
-        $this->addSort(new PlViewOrder('date_mod', array(
-                    new UFO_ProfileUpdate(true),
-                    new UFO_Promo(UserFilter::DISPLAY, true),
-                    new UFO_Name(UserFilter::DN_SORT),
-                ), 'dernière modification'));
-        parent::__construct($set, $data, $params);
+        parent::__construct(new UFC_Email($emails));
     }
+}
+
+/** Simple set based on an array of Profile emails
+ */
+class ProfileArraySet extends ProfileSet
+{
+    public function __construct(array $emails)
+    {
+        parent::__construct(new UFC_Email($emails));
+    }
+}
+
 
+/** A multipage view for profiles or users
+ * Allows the display of bounds when sorting by name or promo.
+ */
+abstract class MixedView extends MultipageView
+{
     protected function getBoundValue($obj)
     {
         if ($obj instanceof Profile) {
             switch ($this->bound_field) {
             case 'name':
                 $name = $obj->name('%l');
-                return strtoupper($name[0]);
+                return strtoupper($name);
             case 'promo':
                 return $obj->promo();
             default:
                 return null;
             }
+        } elseif ($obj instanceof User) {
+            switch ($this->bound_field) {
+            case 'name':
+                $name = $obj->lastName();
+                return strtoupper($name);
+            case 'promo':
+                if ($obj->hasProfile()) {
+                    return $obj->profile()->promo();
+                } else {
+                    return 'ext';
+                }
+            default:
+                return null;
+            }
         }
         return null;
     }
@@ -196,6 +195,62 @@ class MinificheView extends MultipageView
         }
         return $show_bounds;
     }
+}
+
+/** An extended multipage view for profiles, as minifiches.
+ * Allows to sort by:
+ * - score (for a search query)
+ * - name
+ * - promo
+ * - latest modification
+ *
+ * Paramaters for this view are:
+ * - with_score: whether to allow ordering by score (set only for a quick search)
+ * - starts_with: show only names beginning with the given letter
+ */
+class MinificheView extends MixedView
+{
+    public function __construct(PlSet $set, array $params)
+    {
+        global $globals;
+        $this->entriesPerPage = $globals->search->per_page;
+        if (@$params['with_score']) {
+            $this->addSort(new PlViewOrder('score', array(
+                    new UFO_Score(true),
+                    new UFO_ProfileUpdate(true),
+                    new UFO_Promo(UserFilter::DISPLAY, true),
+                    new UFO_Name(Profile::DN_SORT),
+                ), 'pertinence'));
+        }
+        $this->addSort(new PlViewOrder(
+                            'name',
+                            array(new UFO_Name(Profile::DN_SORT)),
+                            'nom'));
+        $this->addSort(new PlViewOrder('promo', array(
+                    new UFO_Promo(UserFilter::DISPLAY, true),
+                    new UFO_Name(Profile::DN_SORT),
+                ), 'promotion'));
+        $this->addSort(new PlViewOrder('date_mod', array(
+                    new UFO_ProfileUpdate(true),
+                    new UFO_Promo(UserFilter::DISPLAY, true),
+                    new UFO_Name(Profile::DN_SORT),
+                ), 'dernière modification'));
+        parent::__construct($set, $params);
+    }
+
+    public function apply(PlPage $page)
+    {
+        if (array_key_exists('starts_with', $this->params)
+            && $this->params['starts_with'] != ""
+            && $this->params['starts_with'] != null) {
+
+            $this->set->addCond(
+                new UFC_Name(Profile::LASTNAME,
+                    $this->params['starts_with'], UFC_Name::PREFIX)
+            );
+        }
+        return parent::apply($page);
+    }
 
     public function templateName()
     {
@@ -203,141 +258,146 @@ class MinificheView extends MultipageView
     }
 }
 
-class MentorView extends MultipageView
+class MentorView extends MixedView
 {
-    public function __construct(PlSet &$set, $data, array $params)
+    public function __construct(PlSet $set, array $params)
     {
         $this->entriesPerPage = 10;
         $this->addSort(new PlViewOrder('rand', array(new PFO_Random(S::i('uid'))), 'aléatoirement'));
-        $this->addSort(new PlViewOrder('name', array(new UFO_Name(UserFilter::DN_SORT)), 'nom'));
+        $this->addSort(new PlViewOrder('name', array(new UFO_Name(Profile::DN_SORT)), 'nom'));
         $this->addSort(new PlViewOrder('promo', array(
                     new UFO_Promo(UserFilter::DISPLAY, true),
-                    new UFO_Name(UserFilter::DN_SORT),
+                    new UFO_Name(Profile::DN_SORT),
                 ), 'promotion'));
         $this->addSort(new PlViewOrder('date_mod', array(
                     new UFO_ProfileUpdate(true),
                     new UFO_Promo(UserFilter::DISPLAY, true),
-                    new UFO_Name(UserFilter::DN_SORT),
+                    new UFO_Name(Profile::DN_SORT),
                 ), 'dernière modification'));
-        parent::__construct($set, $data, $params);
+        parent::__construct($set, $params);
     }
 
-    protected function getBoundValue($obj)
+    public function templateName()
     {
-        if ($obj instanceof Profile) {
-            switch ($this->bound_field) {
-            case 'name':
-                $name = $obj->name('%l');
-                return strtoupper($name[0]);
-            case 'promo':
-                return $obj->promo();
-            default:
-                return null;
-            }
-        }
-        return null;
+        return 'include/plview.referent.tpl';
     }
+}
 
-    public function bounds()
+class GroupMemberView extends MixedView
+{
+    public function __construct(PlSet $set, array $params)
     {
-        $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;
+        $this->entriesPerPage = 20;
+        $this->addSort(new PlViewOrder('name', array(new UFO_Name(Profile::DN_SORT)), 'nom'));
+        $this->addSort(new PlViewOrder('promo', array(
+                    new UFO_Promo(UserFilter::DISPLAY, true),
+                    new UFO_Name(Profile::DN_SORT),
+                ), 'promotion'));
+        parent::__construct($set, $params);
     }
 
     public function templateName()
     {
-        return 'include/plview.referent.tpl';
+        return 'include/plview.groupmember.tpl';
     }
 }
 
-class TrombiView extends MultipageView
+class ListMemberView extends MixedView
 {
-    public function __construct(PlSet &$set, $data, array $params)
+    public function __construct(PlSet $set, array $params)
+    {
+        $this->entriesPerPage = 100;
+        $this->addSort(new PlViewOrder('name', array(new UFO_Name(Profile::DN_SORT)), 'nom'));
+        $this->addSort(new PlViewOrder('promo', array(
+                    new UFO_Promo(UserFilter::DISPLAY, true),
+                    new UFO_Name(Profile::DN_SORT),
+                ), 'promotion'));
+        parent::__construct($set, $params);
+    }
+
+    public function templateName()
+    {
+        return 'include/plview.listmember.tpl';
+    }
+}
+
+class TrombiView extends MixedView
+{
+    public function __construct(PlSet $set, array $params)
     {
         $this->entriesPerPage = 24;
+        $this->defaultkey = 'name';
         if (@$params['with_score']) {
             $this->addSort(new PlViewOrder('score', array(
                             new UFO_Score(true),
                             new UFO_ProfileUpdate(true),
                             new UFO_Promo(UserFilter::DISPLAY, true),
-                            new UFO_Name(UserFilter::DN_SORT),
+                            new UFO_Name(Profile::DN_SORT),
             ), 'pertinence'));
         }
-        $this->addSort(new PlViewOrder('name', array(new UFO_Name(UserFilter::DN_SORT)), 'nom'));
+        $set->addCond(new UFC_Photo());
+        $this->addSort(new PlViewOrder('name', array(new UFO_Name(Profile::DN_SORT)), 'nom'));
         $this->addSort(new PlViewOrder('promo', array(
                         new UFO_Promo(UserFilter::DISPLAY, true),
-                        new UFO_Name(UserFilter::DN_SORT),
+                        new UFO_Name(Profile::DN_SORT),
                     ), 'promotion'));
-        parent::__construct($set, $data, $params);
+        parent::__construct($set, $params);
     }
 
-    protected function getBoundValue($obj)
+    public function templateName()
     {
-        if ($obj instanceof Profile) {
-            switch ($this->bound_field) {
-            case 'name':
-                $name = $obj->name('%l');
-                return strtoupper($name[0]);
-            case 'promo':
-                return $obj->promo();
-            default:
-                return null;
-            }
-        }
-        return null;
+        return 'include/plview.trombi.tpl';
     }
 
-    public function bounds()
+    public function apply(PlPage $page)
     {
-        $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;
+        if (!empty($GLOBALS['IS_XNET_SITE'])) {
+            global $globals;
+            $page->assign('mainsiteurl', 'https://' . $globals->core->secure_domain . '/');
         }
-        return $show_bounds;
+        return parent::apply($page);
     }
+}
 
-    public function templateName()
+class MapView implements PlView
+{
+    private $set;
+
+    public function __construct(PlSet $set, array $params)
     {
-        return 'include/plview.trombi.tpl';
+        $this->set = $set;
     }
 
-    public function apply(PlPage &$page)
+    public function apply(PlPage $page)
     {
-        if (!empty($GLOBALS['IS_XNET_SITE'])) {
-            global $globals;
-            $page->assign('mainsiteurl', 'https://' . $globals->core->secure_domain . '/');
+        Platal::load('geoloc');
+
+        if (Get::b('ajax')) {
+            $pids = $this->set->getIds(new PlLimit());
+            GeolocModule::assign_json_to_map($page, $pids);
+            $page->runJSON();
+            exit;
+        } else {
+            $this->set->getIds(new PlLimit());
+            GeolocModule::prepare_map($page);
+            return 'geoloc/index.tpl';
         }
-        return parent::apply($page);
+    }
+
+    public function args()
+    {
+        return $this->set->args();
     }
 }
 
 class GadgetView implements PlView
 {
-    public function __construct(PlSet &$set, $data, array $params)
+    public function __construct(PlSet $set, array $params)
     {
         $this->set =& $set;
     }
 
-    public function apply(PlPage &$page)
+    public function apply(PlPage $page)
     {
         $page->assign_by_ref('set', $this->set->get(new PlLimit(5, 0)));
     }
@@ -348,5 +408,70 @@ class GadgetView implements PlView
     }
 }
 
+class AddressesView implements PlView
+{
+    private $set;
+
+    public function __construct(PlSet $set, array $params)
+    {
+        $this->set =& $set;
+    }
+
+    public function apply(PlPage $page)
+    {
+        $pids = $this->set->getIds(new PlLimit());
+        $visibility = new ProfileVisibility(ProfileVisibility::VIS_AX);
+        pl_cached_content_headers('text/x-csv', 1);
+
+        $csv = fopen('php://output', 'w');
+        fputcsv($csv, array('adresses'), ';');
+        $res = XDB::query('SELECT  pd.public_name, pa.postalText
+                             FROM  profile_addresses AS pa
+                       INNER JOIN  profile_display   AS pd ON (pd.pid = pa.pid)
+                            WHERE  pa.type = \'home\' AND pa.pub IN (\'public\', \'ax\') AND FIND_IN_SET(\'mail\', pa.flags) AND pa.pid IN {?}
+                         GROUP BY  pa.pid', $pids);
+        foreach ($res->fetchAllAssoc() as $item) {
+            fputcsv($csv, $item, ';');
+        }
+        fclose($csv);
+        exit();
+    }
+
+    public function args()
+    {
+        return $this->set->args();
+    }
+}
+
+class JSonView implements PlView
+{
+    private $set;
+    private $params;
+
+    public function __construct(PlSet $set, array $params)
+    {
+        $this->set    = $set;
+        $this->params = $params;
+    }
+
+    public function apply(PlPage $page)
+    {
+        $export = array();
+        $start  = isset($this->params['offset']) ? $this->params['offset'] : 0;
+        $count  = isset($this->params['count'])  ? $this->params['count']  : 10;
+        $profiles = $this->set->get(new PlLimit($start, $count));
+        foreach ($profiles as $profile) {
+            $export[] = $profile->export();
+        }
+        $page->jsonAssign('profile_count', $this->set->count());
+        $page->jsonAssign('profiles', $export);
+    }
+
+    public function args()
+    {
+        return $this->set->args();
+    }
+}
+
 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 ?>