- // alias virtual
- $res = XDB::query(
- "SELECT alias
- FROM virtual
- INNER JOIN virtual_redirect USING(vid)
- INNER JOIN auth_user_quick ON ( user_id = {?} AND emails_alias_pub = 'public' )
- WHERE ( redirect={?} OR redirect={?} )
- AND alias LIKE '%@{$globals->mail->alias_dom}'",
- $user['user_id'],
- $user['forlife'].'@'.$globals->mail->domain,
- $user['forlife'].'@'.$globals->mail->domain2);
-
- $user['virtualalias'] = $res->fetchOneCell();
- $user['gpxs_vcardjoin'] = join(',', array_map(array('VCard', 'text_encode'), $user['gpxs_name']));
- $user['binets_vcardjoin'] = join(',', array_map(array('VCard', 'text_encode'), $user['binets']));
- // get photo
- if ($this->photos) {
- $res = XDB::query(
- "SELECT attach, attachmime
- FROM photo AS p
- INNER JOIN aliases AS a ON (a.id = p.uid AND a.type = 'a_vie')
- WHERE a.alias = {?}", $login);
- if ($res->numRows()) {
- $user['photo'] = $res->fetchOneAssoc();
+ // Pro
+ $jobs = $pf->getJobs();
+ foreach ($jobs as $job) {
+ $terms_array = array();
+ foreach ($job->terms as $term) {
+ $terms_array[] = $term->full_name;
+ }
+ $terms = implode(', ', $terms_array);
+ if ($job->address) {
+ if (!$job->address->postalCode || !$job->address->locality || !$job->address->country) {
+ $group = $entry->addWork($job->company->name, null, $job->description, $terms,
+ $job->address->text, null, null, null,
+ null, $job->address->administrativeArea, null);
+ } else {
+ $group = $entry->addWork($job->company->name, null, $job->description, $terms,
+ trim(Geocoder::getFirstLines($job->address->text, $job->address->postalCode, 4)),
+ null, null, $job->address->postalCode,
+ $job->address->locality, $job->address->administrativeArea, $job->address->country);
+ }
+ } else {
+ $group = $entry->addWork($job->company->name, null, $job->description, $terms,
+ null, null, null, null,
+ null, null, null);
+ }
+ if ($job->user_email) {
+ $entry->addMail($group, $job->user_email);
+ }
+ foreach ($job->phones as $phone) {
+ if ($phone->type == Phone::TYPE_MOBILE) {
+ $entry->addTel($group, $phone->display, false, true, true, false, true);
+ } else if ($phone->type == Phone::TYPE_FAX) {
+ $entry->addTel($group, $phone->display, true);
+ } else {
+ $entry->addTel($group, $phone->display, false, true, true);
+ }