+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 = 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', '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 (SELECT pid, postalText, jobid, groupid, type, id, postal_code_fr
+ FROM profile_addresses
+ WHERE pub IN ('public', 'ax') AND FIND_IN_SET('mail', flags) AND pid IN {?}
+ ORDER BY pid, NOT FIND_IN_SET('current', flags),
+ FIND_IN_SET('secondary', flags), type = 'job') 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)
+ GROUP BY pa.pid", $pids);
+ foreach ($res->fetchAllAssoc() as $item) {
+ fputcsv($csv, array_map('utf8_decode', $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();
+ }
+}
+