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']) {
global $globals;
$page->assign('mainsiteurl', 'https://' . $globals->core->secure_domain . '/');
}
+ $page->assign('full_count', $this->full_count);
return parent::apply($page);
}
}
$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.long_name AS postal_code, p.email_directory
- FROM (SELECT pa.pid, pa.postalText, pa.jobid, pa.groupid, pa.type, pa.id, pace.long_name
- FROM profile_addresses AS pa
- LEFT JOIN profile_addresses_components AS pac ON (pa.pid = pac.pid
- AND pa.jobid = pac.jobid
- AND pa.groupid = pac.groupid
- AND pa.type = pac.type
- AND pa.id = pac.id)
- LEFT JOIN profile_addresses_components_enum AS pace ON (pac.component_id = pace.id
- AND FIND_IN_SET('postal_code', pace.types))
- WHERE pa.pub IN ('public', 'ax') AND FIND_IN_SET('mail', pa.flags) AND pa.pid IN {?}
- ORDER BY pa.pid, NOT FIND_IN_SET('current', pa.flags),
- FIND_IN_SET('secondary', pa.flags), pa.type = 'job',
- pace.long_name IS NULL) AS pa
+ 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)