<?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 *
Platal::load('geoloc');
if (Get::b('ajax')) {
- $pids = $this->set->getIds(new PlLimit());
+ $uids = $this->set->getIds(new PlLimit());
+ $pids = Profile::getPIDsFromUIDs($uids);
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 apply(PlPage $page)
{
- $pids = $this->set->getIds(new PlLimit());
+ 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('PROMOTION', 'CIVILITE', 'NOM', 'PRENOM', 'SOCIETE', 'ADRESSE', 'ADRESSE1', 'ADRESSE2', 'ADRESSE3', 'CP', 'EMAIL'),
+ 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 pd.promo, p.title,
+ $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
+ 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)
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);
+ WHERE pa.pid IN {?} AND FIND_IN_SET('dn_best_mail', pa.flags)", $pids);
foreach ($res->fetchAllRow() as $item) {
- list($promo, $title, $lastname, $firstname, $company, $full_address, $zipcode, $email) = array_map('utf8_decode', $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($promo, $title, $lastname, $firstname, $company, $full_address, $lines[0], $lines[1], $lines[2], $zipcode, $email),
- ';');
+ fputcsv($csv, array(
+ $axid, $promo, $title, $lastname, $firstname, $company,
+ $full_address, $lines[0], $lines[1], $lines[2], $zipcode,
+ $email, $delivery_issue), ';');
}
}
fclose($csv);
}
}
-// 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:
?>