<?php
/***************************************************************************
- * Copyright (C) 2003-2011 Polytechnique.org *
+ * Copyright (C) 2003-2014 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
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, $params);
}
&& $this->params['starts_with'] != null) {
$this->set->addCond(
- new UFC_Name(Profile::LASTNAME,
- $this->params['starts_with'], UFC_Name::PREFIX)
+ new UFC_NameInitial($this->params['starts_with'])
);
}
return parent::apply($page);
{
$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, $params);
}
public function __construct(PlSet $set, array $params)
{
$this->entriesPerPage = 20;
- $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(),
+ ), 'dernière modification'));
parent::__construct($set, $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('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'));
parent::__construct($set, $params);
}
class TrombiView extends MixedView
{
+ 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']) {
new UFO_Score(true),
new UFO_ProfileUpdate(true),
new UFO_Promo(UserFilter::DISPLAY, true),
- new UFO_Name(Profile::DN_SORT),
+ new UFO_Name(),
), 'pertinence'));
}
$set->addCond(new UFC_Photo());
- $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'));
parent::__construct($set, $params);
}
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')) {
+ $uids = $this->set->getIds(new PlLimit());
+ $pids = Profile::getPIDsFromUIDs($uids);
+ GeolocModule::assign_json_to_map($page, $pids);
+ $page->runJSON();
+ exit;
+ } else {
+ GeolocModule::prepare_map($page);
+ return 'geoloc/index.tpl';
+ }
+ }
+
+ public function args()
+ {
+ return $this->set->args();
+ }
+}
+
class GadgetView implements PlView
{
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 = new ProfileVisibility(ProfileVisibility::VIS_AX);
- pl_cached_content_headers('text/x-csv', 1);
+ if ($this->set instanceof UserSet) {
+ $uids = $this->set->getIds(new PlLimit());
+ $pids = Profile::getPIDsFromUIDs($uids);
+ } else {
+ $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('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, ';');
+ fputcsv($csv,
+ array('AX_ID', 'PROMOTION', 'CIVILITE', 'NOM', 'PRENOM', 'SOCIETE', 'ADRESSE', 'ADRESSE1', 'ADRESSE2', 'ADRESSE3', 'CP', 'EMAIL', 'NHABITE_PLUS_A_LADRESSE'),
+ ';');
+
+ if (!empty($pids)) {
+ $res = XDB::query("SELECT p.ax_id, 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,
+ IF (FIND_IN_SET('deliveryIssue', pa.flags), 'oui', '') AS delivery_issue
+ 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('dn_best_mail', pa.flags)", $pids);
+ foreach ($res->fetchAllRow() as $item) {
+ list($axid, $promo, $title, $lastname, $firstname, $company, $full_address, $zipcode, $email, $delivery_issue) = array_map('utf8_decode', $item);
+ $lines = self::split_address($full_address);
+ fputcsv($csv, array(
+ $axid, $promo, $title, $lastname, $firstname, $company,
+ $full_address, $lines[0], $lines[1], $lines[2], $zipcode,
+ $email, $delivery_issue), ';');
+ }
}
fclose($csv);
exit();
}
}
-// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
+// vim:set et sw=4 sts=4 sws=4 foldmethod=marker fenc=utf-8:
?>
projects / platal.git / blobdiff