<?php
/***************************************************************************
- * Copyright (C) 2003-2010 Polytechnique.org *
+ * Copyright (C) 2003-2013 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 = null)
+ 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 ProfileSet extends PlSet
{
- public function __construct(PlFilterCondition &$cond, $orders = null)
+ 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 ProfileFilter($cond, $orders);
}
}
+require_once "ufbuilder.inc.php";
+
class SearchSet extends ProfileSet
{
- public $advanced = false;
- private $score = null;
- private $quick = false;
+ protected $score = null;
+ protected $valid = true;
- public function __construct($quick = false, $no_search = false, PlFilterCondition $cond = null)
+ public function __construct(UserFilterBuilder $ufb, PlFilterCondition $cond = null)
{
- if ($no_search) {
- return;
- }
-
- $this->quick = $quick;
-
if (is_null($cond)) {
- $this->conds = new PFC_And();
+ $conds = new PFC_And();
} else if ($cond instanceof PFC_And) {
- $this->conds = $cond;
- } else {
- $this->conds = new PFC_And($cond);
- }
-
- if ($quick) {
- $this->getQuick();
+ $conds = $cond;
} 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;
}
$ufc = $ufb->getUFC();
- $this->conds->addChild($ufc);
+ $conds->addChild($ufc);
$orders = $ufb->getOrders();
- if (S::logged() && Env::has('nonins')) {
- $this->conds = new PFC_And($this->conds,
- new PFC_Not(new UFC_Dead()),
- new PFC_Not(new UFC_Registered())
- );
- }
+ parent::__construct($conds, $orders);
+ }
- parent::__construct($this->conds, $orders);
+ public function isValid()
+ {
+ return $this->valid;
}
- private function getAdvanced()
+ /** Add a "rechercher=Chercher" field to the query to simulate the POST
+ * behaviour.
+ */
+ public function args()
{
- $this->advanced = true;
- require_once 'ufbuilder.inc.php';
- $ufb = new UFB_AdvancedSearch();
+ $args = parent::args();
+ if (!isset($args['rechercher'])) {
+ $args['rechercher'] = 'Chercher';
+ }
+ return $args;
+ }
- if (!$ufb->isValid()) {
- return;
+ protected function &getFilterResults(PlFilter $pf, PlLimit $limit)
+ {
+ $profiles = $pf->getProfiles($limit, Profile::FETCH_MINIFICHES);
+ return $profiles;
+ }
+}
+
+// Specialized SearchSet for quick search.
+class QuickSearchSet extends SearchSet
+{
+ public function __construct(PlFilterCondition $cond = null)
+ {
+ if (!S::logged()) {
+ Env::kill('with_soundex');
}
- $this->conds->addChild($ufb->getUFC());
+ parent::__construct(new UFB_QuickSearch(), $cond);
}
+}
- protected function &getFilterResults(PlFilter &$pf, PlLimit $limit)
+// Specialized SearchSet for advanced search.
+class AdvancedSearchSet extends SearchSet
+{
+ public function __construct($xorg_admin_fields, $ax_admin_fields,
+ PlFilterCondition $cond = null)
{
- return $pf->getProfiles($limit, Profile::FETCH_MINIFICHES);
+ parent::__construct(new UFB_AdvancedSearch($xorg_admin_fields, $ax_admin_fields),
+ $cond);
}
}
-class ArraySet extends ProfileSet
+/** Simple set based on an array of User emails
+ */
+class UserArraySet extends UserSet
{
- public function __construct(array $users)
+ public function __construct(array $emails)
{
- $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 UFC_Email($emails));
}
}
-abstract class ProfileView extends MultipageView
+/** 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)
{
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;
}
+
+ public function bounds()
+ {
+ $order = Env::v('order', $this->defaultkey);
+ $show_bounds = 0;
+ if (($order == "name") || ($order == "-name")) {
+ $this->bound_field = "name";
+ $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;
+ }
}
-class MinificheView extends ProfileView
+/** 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, $data, array $params)
+ public function __construct(PlSet $set, array $params)
{
- require_once 'education.func.inc.php';
global $globals;
$this->entriesPerPage = $globals->search->per_page;
if (@$params['with_score']) {
new UFO_Score(true),
new UFO_ProfileUpdate(true),
new UFO_Promo(UserFilter::DISPLAY, true),
- new UFO_Name(Profile::DN_SORT),
+ new UFO_Name(),
), 'pertinence'));
}
$this->addSort(new PlViewOrder(
'name',
- array(new UFO_Name(Profile::DN_SORT)),
+ array(new UFO_Name()),
'nom'));
$this->addSort(new PlViewOrder('promo', array(
new UFO_Promo(UserFilter::DISPLAY, true),
- new UFO_Name(Profile::DN_SORT),
+ new UFO_Name(),
), 'promotion'));
$this->addSort(new PlViewOrder('date_mod', array(
new UFO_ProfileUpdate(true),
new UFO_Promo(UserFilter::DISPLAY, true),
- new UFO_Name(Profile::DN_SORT),
+ new UFO_Name(),
), 'dernière modification'));
- parent::__construct($set, $data, $params);
+ parent::__construct($set, $params);
}
- 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 = "name";
- $show_bounds = 1;
- } elseif (($order == "promo") || ($order == "-promo")) {
- $this->bound_field = "promo";
- $show_bounds = -1;
- }
- if ($order{0} == '-') {
- $show_bounds = -$show_bounds;
+ if (array_key_exists('starts_with', $this->params)
+ && $this->params['starts_with'] != ""
+ && $this->params['starts_with'] != null) {
+
+ $this->set->addCond(
+ new UFC_NameInitial($this->params['starts_with'])
+ );
}
- return $show_bounds;
+ return parent::apply($page);
}
public function templateName()
}
}
-class MentorView extends ProfileView
+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(Profile::DN_SORT)), 'nom'));
+ $this->addSort(new PlViewOrder('name', array(new UFO_Name()), 'nom'));
$this->addSort(new PlViewOrder('promo', array(
new UFO_Promo(UserFilter::DISPLAY, true),
- new UFO_Name(Profile::DN_SORT),
+ new UFO_Name(),
), 'promotion'));
$this->addSort(new PlViewOrder('date_mod', array(
new UFO_ProfileUpdate(true),
new UFO_Promo(UserFilter::DISPLAY, true),
- new UFO_Name(Profile::DN_SORT),
+ new UFO_Name(),
), 'dernière modification'));
- parent::__construct($set, $data, $params);
+ parent::__construct($set, $params);
}
- public function bounds()
+ public function templateName()
{
- $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;
+ return 'include/plview.referent.tpl';
+ }
+}
+
+class GroupMemberView extends MixedView
+{
+ public function __construct(PlSet $set, array $params)
+ {
+ $this->entriesPerPage = 20;
+ $this->addSort(new PlViewOrder('name', array(new UFO_Name()), 'nom'));
+ $this->addSort(new PlViewOrder('promo', array(
+ new UFO_Promo(UserFilter::DISPLAY, true),
+ new UFO_Name(),
+ ), 'promotion'));
+ $this->addSort(new PlViewOrder('date_mod', array(
+ new UFO_ProfileUpdate(true),
+ new UFO_Promo(UserFilter::DISPLAY, true),
+ new UFO_Name(),
+ ), 'dernière modification'));
+ parent::__construct($set, $params);
}
public function templateName()
{
- return 'include/plview.referent.tpl';
+ return 'include/plview.groupmember.tpl';
+ }
+}
+
+class ListMemberView extends MixedView
+{
+ public function __construct(PlSet $set, array $params)
+ {
+ $this->entriesPerPage = 100;
+ $this->addSort(new PlViewOrder('name', array(new UFO_Name()), 'nom'));
+ $this->addSort(new PlViewOrder('promo', array(
+ new UFO_Promo(UserFilter::DISPLAY, true),
+ new UFO_Name(),
+ ), 'promotion'));
+ parent::__construct($set, $params);
+ }
+
+ public function templateName()
+ {
+ return 'include/plview.listmember.tpl';
}
}
-class TrombiView extends ProfileView
+class TrombiView extends MixedView
{
- public function __construct(PlSet &$set, $data, array $params)
+ private $full_count;
+
+ public function __construct(PlSet $set, array $params)
{
+ $set->getIds();
+ $this->full_count = $set->count();
+
$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(Profile::DN_SORT),
+ new UFO_Name(),
), 'pertinence'));
}
- $this->addSort(new PlViewOrder('name', array(new UFO_Name(Profile::DN_SORT)), 'nom'));
+ $set->addCond(new UFC_Photo());
+ $this->addSort(new PlViewOrder('name', array(new UFO_Name()), 'nom'));
$this->addSort(new PlViewOrder('promo', array(
new UFO_Promo(UserFilter::DISPLAY, true),
- new UFO_Name(Profile::DN_SORT),
+ new UFO_Name(),
), 'promotion'));
- $set->addCond(new UFC_Photo());
- parent::__construct($set, $data, $params);
- }
-
- 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;
+ parent::__construct($set, $params);
}
public function templateName()
return 'include/plview.trombi.tpl';
}
- 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 . '/');
}
+ $page->assign('full_count', $this->full_count);
return parent::apply($page);
}
}
+class MapView implements PlView
+{
+ private $set;
+
+ public function __construct(PlSet $set, array $params)
+ {
+ $this->set = $set;
+ }
+
+ public function apply(PlPage $page)
+ {
+ 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';
+ }
+ }
+
+ 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)));
}
}
}
+class AddressesView implements PlView
+{
+ private $set;
+
+ public function __construct(PlSet $set, array $params)
+ {
+ $this->set =& $set;
+ }
+
+ /* Convert a single address field into 3 lines.
+ */
+ public static function split_address($address)
+ {
+ $lines = preg_split("/(\r|\n)+/", $address, -1, PREG_SPLIT_NO_EMPTY);
+ $nb_lines = count($lines);
+ switch ($nb_lines) {
+ case 0:
+ // No data => nothing
+ return array("", "", "");
+ case 1:
+ // Single line => Assume it's city+zipcode
+ $line = $lines[0];
+ return array("", "", $line);
+ case 2:
+ // Two lines => Assume it's street \n city
+ $line1 = $lines[0];
+ $line3 = $lines[1];
+ return array($line1, "", $line3);
+ case 3:
+ return $lines;
+ default:
+ // More than 3 lines => Keep 2 last intact, merge other lines.
+ $line3 = array_pop($lines);
+ $line2 = array_pop($lines);
+ $line1 = implode(" ", $lines);
+ return array($line1, $line2, $line3);
+ }
+ }
+
+ public function apply(PlPage $page)
+ {
+ $pids = $this->set->getIds(new PlLimit());
+ $visibility = Visibility::defaultForRead(Visibility::VIEW_AX);
+ pl_cached_content_headers('text/x-csv', 'iso-8859-1', 1, 'adresses.csv');
+
+ $csv = fopen('php://output', 'w');
+ fputcsv($csv,
+ array('PROMOTION', 'CIVILITE', 'NOM', 'PRENOM', 'SOCIETE', 'ADRESSE', 'ADRESSE1', 'ADRESSE2', 'ADRESSE3', 'CP', 'EMAIL'),
+ ';');
+
+ if (!empty($pids)) {
+ $res = XDB::query("SELECT pd.promo, p.title,
+ IF (pn.firstname_ordinary = '', UPPER(pn.firstname_main), UPPER(pn.firstname_ordinary)) AS firstname,
+ IF (pn.lastname_ordinary = '', UPPER(pn.lastname_main), UPPER(pn.lastname_ordinary)) AS lastname,
+ UPPER(pje.name), pa.postalText, pa.postal_code_fr AS postal_code, p.email_directory
+ FROM profile_addresses AS pa
+ INNER JOIN profiles AS p ON (pa.pid = p.pid)
+ INNER JOIN profile_display AS pd ON (pd.pid = pa.pid)
+ INNER JOIN profile_public_names AS pn ON (pn.pid = pa.pid)
+ LEFT JOIN profile_job AS pj ON (pj.pid = pa.pid
+ AND pj.id = IF(pa.type = 'job', pa.id, NULL))
+ LEFT JOIN profile_job_enum AS pje ON (pj.jobid = pje.id)
+ WHERE pa.pid IN {?} AND FIND_IN_SET('ax_mail', pa.flags)", $pids);
+ foreach ($res->fetchAllRow() as $item) {
+ list($promo, $title, $lastname, $firstname, $company, $full_address, $zipcode, $email) = array_map('utf8_decode', $item);
+ $lines = self::split_address($full_address);
+ fputcsv($csv,
+ array($promo, $title, $lastname, $firstname, $company, $full_address, $lines[0], $lines[1], $lines[2], $zipcode, $email),
+ ';');
+ }
+ }
+ 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:
?>