{
$address = $this->text;
if ($this->type == self::LINK_PROFILE || $this->type == self::LINK_JOB) {
- static $pubs = array('public' => 'publique', 'ax' => 'annuaire AX', 'private' => 'privé');
+ static $pubs = array('public' => 'publique', 'ax' => 'annuaire papier', 'private' => 'privé', 'hidden' => 'administrateurs');
$address .= ' (affichage ' . $pubs[$this->pub];
}
if ($this->type == self::LINK_PROFILE) {
}
if ($this->pid != 0) {
- $this->updateAxMail();
+ self::updateBestMail($this->pid);
}
}
}
- private function updateAxMail()
+ /**
+ * Upate the denormalized flag which is used to mark the best mail to use
+ * when sending postal mail
+ *
+ * Call with $fake to true to only get which address would be selected,
+ * without updating anything in the database.
+ * Returns an array describing the selected profile address
+ */
+ static public function updateBestMail($pid, $fake=false)
{
- XDB::execute("UPDATE profile_addresses
- SET flags = REPLACE(flags, 'ax_mail', '')
- WHERE pid = {?}",
- $this->pid);
+ if (!$fake) {
+ XDB::execute("UPDATE profile_addresses
+ SET flags = REPLACE(flags, 'dn_best_mail', '')
+ WHERE pid = {?}",
+ $pid);
+ }
- $ax_mail = XDB::fetchOneAssoc("SELECT pid, jobid, groupid, type, id
+ /* Following order is selected to find the best mail:
+ * * Use addresses without the deliveryIssue flag if possible.
+ * * Among these, use addresses flagged as "current".
+ * * If there is no such addresses or several ones, prefer those
+ * without "secondary" flag.
+ * * If there are still several addresses in the selection, try not
+ * to select the ones with "job" type.
+ */
+ $best_mail = XDB::fetchOneAssoc("SELECT pid, jobid, groupid, type, id, flags
FROM profile_addresses
- WHERE pub IN ('public', 'ax') AND FIND_IN_SET('mail', flags) AND pid = {?}
- ORDER BY NOT FIND_IN_SET('current', flags),
- FIND_IN_SET('secondary', flags), type = 'job'",
- $this->pid);
-
- if ($ax_mail) {
+ WHERE FIND_IN_SET('mail', flags) AND pid = {?}
+ ORDER BY FIND_IN_SET('deliveryIssue', flags),
+ NOT FIND_IN_SET('current', flags),
+ FIND_IN_SET('secondary', flags), type = 'job'
+ LIMIT 1",
+ $pid);
+
+ if (!$fake && $best_mail) {
XDB::execute("UPDATE profile_addresses
- SET flags = CONCAT(flags, ',ax_mail')
+ SET flags = CONCAT(flags, ',dn_best_mail')
WHERE pid = {?} AND jobid = {?} AND groupid = {?} AND type = {?} AND id = {?}",
- $ax_mail['pid'], $ax_mail['jobid'], $ax_mail['groupid'], $ax_mail['type'], $ax_mail['id']);
+ $best_mail['pid'], $best_mail['jobid'], $best_mail['groupid'], $best_mail['type'], $best_mail['id']);
}
+ return $best_mail;
}
public function updateGeocoding($text)