Profile::FETCH_PHONES => 'ProfilePhones',
Profile::FETCH_MENTOR_SECTOR => 'ProfileMentoringSectors',
Profile::FETCH_MENTOR_COUNTRY => 'ProfileMentoringCountries',
+ Profile::FETCH_JOB_TERMS => 'ProfileJobTerms',
+ Profile::FETCH_MENTOR_TERMS => 'ProfileMentoringTerms',
);
/** The profile to which this field belongs
* @param $pids An array of pids
* @param $visibility The level of visibility fetched fields must have
* @return a PlIterator yielding data suitable for a "new ProfileBlah($data)"
- * XXX MUST be reimplemented for each kind of ProfileField
+ *
+ * MUST be reimplemented for each kind of ProfileField.
*/
public static function fetchData(array $pids, ProfileVisibility $visibility)
{
public function __construct($cls, array $pids, ProfileVisibility $visibility)
{
+ if (is_numeric($cls) && isset(ProfileField::$fields[$cls])) {
+ $cls = ProfileField::$fields[$cls];
+ }
$this->data = call_user_func(array($cls, 'fetchData'), $pids, $visibility);
$this->cls = $cls;
}
}
// }}}
-// {{{ class Phone
-class Phone
-{
- const TYPE_FAX = 'fax';
- const TYPE_FIXED = 'fixed';
- const TYPE_MOBILE = 'mobile';
- public $type;
-
- public $search;
- public $display;
- public $comment = '';
-
- const LINK_JOB = 'job';
- const LINK_ADDRESS = 'address';
- const LINK_PROFILE = 'user';
- const LINK_COMPANY = 'hq';
- public $link_type;
- public $link_id;
-
- /** Fields are :
- * $type, $search, $display, $link_type, $link_id, $comment, $pid, $id
- */
- public function __construct($data)
- {
- foreach ($data as $key => $val) {
- $this->$key = $val;
- }
- }
-}
-// }}}
// {{{ class Company
class Company
{
public function setPhone(Phone &$phone)
{
- if ($phone->link_type == Phone::LINK_COMPANY && $phone->link_id == $this->id) {
+ if ($phone->linkType() == Phone::LINK_COMPANY && $phone->linkId() == $this->id) {
$this->phone = $phone;
}
}
public $id;
public $company = null;
- private $phones = array();
- private $address = null;
+ public $phones = array();
+ public $address = null;
+ public $terms = array();
public $jobid;
$this->$key = $val;
}
$this->company = CompanyList::get($this->jobid);
+ if (is_null($this->company)) {
+ require_once 'validations.inc.php';
+ $entreprise = ProfileValidate::get_typed_requests($this->pid, 'entreprise');
+ $this->company = new Company(array('name' => $entreprise[$this->id]->name));
+ }
}
public function phones()
public function addPhone(Phone &$phone)
{
- if ($phone->link_type == Phone::LINK_JOB && $phone->link_id == $this->id && $phone->pid == $this->pid) {
- $this->phones[] = $phone;
+ if ($phone->linkType() == Phone::LINK_JOB && $phone->linkId() == $this->id && $phone->pid() == $this->pid) {
+ $this->phones[$phone->uniqueId()] = $phone;
}
}
public function setAddress(Address $address)
{
- if ($address->link_id == Address::LINK_JOB && $address->link_id == $this->id && $address->pid == $this->pid) {
+ if ($address->link_type == Address::LINK_JOB && $address->link_id == $this->id && $address->pid == $this->pid) {
$this->address = $address;
}
}
+
+ public function addTerm(JobTerm &$term)
+ {
+ $this->terms[$term->jtid] = $term;
+ }
+}
+// }}}
+// {{{ class JobTerm
+class JobTerm
+{
+ public $jtid;
+ public $full_name;
+ public $pid;
+ public $jid;
+
+ /** Fields are:
+ * pid, jid, jtid, full_name
+ */
+ public function __construct($data)
+ {
+ foreach ($data as $key => $val) {
+ $this->$key = $val;
+ }
+ }
}
// }}}
// {{{ class Address
const LINK_PROFILE = 'home';
public $flags;
- public $link_id;
+ public $id; // The ID of the address among those associated with its link
+ public $link_id; // The ID of the object to which the address is linked (profile, job, company)
public $link_type;
public $text;
$this->flags = new PlFlagSet($this->flags);
}
+ public function uid() {
+ $uid = $this->link_type . '_';
+ if ($this->link_type != self::LINK_COMPANY) {
+ $uid .= $this->pid . '_';
+ }
+ $uid .= $this->link_id . '_' . $this->id;
+ }
+
public function addPhone(Phone &$phone)
{
- if ($phone->link_type == Phone::LINK_ADDRESS && $phone->link_id == $this->id && $phone->pid == $this->pid) {
- $this->phones[] = $phone;
+ if (
+ $phone->linkType() == Phone::LINK_ADDRESS && $phone->linkId() == $this->id &&
+ ($this->link_type == self::LINK_COMPANY || $phone->pid() == $this->pid) ) {
+ $this->phones[$phone->uniqueId()] = $phone;
}
}
public function hasFlag($flag)
{
+ if (!$this->flags instanceof PlFlagSet) {
+ $this->flags = new PlFlagSet($this->flags);
+ }
return $this->flags->hasFlag($flag);
}
}
public static function fetchData(array $pids, ProfileVisibility $visibility)
{
- $data = XDB::iterator('SELECT pm.pid, pm.mid, pm.gid, pme.text, pme.img
+ $data = XDB::iterator('SELECT pm.pid, pm.mid, pm.gid, pme.text, pme.img, pmge.text AS grade
FROM profile_medals AS pm
LEFT JOIN profiles AS p ON (pm.pid = p.pid)
LEFT JOIN profile_medal_enum AS pme ON (pme.id = pm.mid)
+ LEFT JOIN profile_medal_grade_enum AS pmge ON (pmge.mid = pm.mid AND pmge.gid = pm.gid)
WHERE pm.pid IN {?} AND p.medals_pub IN {?}
ORDER BY ' . XDB::formatCustomOrder('pm.pid', $pids),
$pids, $visibility->levels());
{
private $networks = array();
- public function __construct(PlIterator $it)
+ public function __construct(PlInnerSubIterator $it)
{
+ $this->pid = $it->value();
while ($network = $it->next()) {
- $this->networks[$network['nwid']] = $network['address'];
+ $network['network_type'] = new PlFlagSet($network['network_type']);
+ $this->networks[$network['id']] = $network;
}
}
public static function fetchData(array $pids, ProfileVisibility $visibility)
{
- $data = XDB::iterator('SELECT pid, nwid, address, network_type
- FROM profile_networking
+ $data = XDB::iterator('SELECT pid, id, address, pne.nwid, pne.network_type, pne.link, pne.name
+ FROM profile_networking AS pn
+ LEFT JOIN profile_networking_enum AS pne USING(nwid)
WHERE pid IN {?} AND pub IN {?}
ORDER BY ' . XDB::formatCustomOrder('pid', $pids) . ',
- network_type, nwid',
+ pn.nwid, id',
$pids, $visibility->levels());
return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
$nws = array();
$nb = 0;
foreach ($this->networks as $id => $nw) {
- // XXX hardcoded reference to web site index
- if (
- (($flags & Profile::NETWORKING_WEB) && $nw['network_type'] == 0)
- ||
- (! ($flags & Profile::NETWORKING_WEB))
- ) {
+ if (($flags & Profile::NETWORKING_WEB) && $nw['network_type']->hasFlag('web') ||
+ ($flags & Profile::NETWORKING_IM) && $nw['network_type']->hasFlag('im') ||
+ ($flags & Profile::NETWORKING_SOCIAL) && $nw['network_type']->hasFlag('social') ||
+ ($flags == Profile::NETWORKING_ALL)) {
$nws[$id] = $nw;
++$nb;
- }
- if ($nb >= $limit) {
- break;
+ if (isset($limit) && $nb >= $limit) {
+ break;
+ }
}
}
return $nws;
LEFT JOIN profile_corps_enum AS pceo ON (pceo.id = pc.original_corpsid)
LEFT JOIN profile_corps_enum AS pcec ON (pcec.id = pc.current_corpsid)
LEFT JOIN profile_corps_rank_enum AS pcrec ON (pcrec.id = pc.rankid)
- WHERE pc.pid IN {?} AND pc.corps_pub IN {?}
+ WHERE pc.pid IN {?} AND pc.corps_pub IN {?} AND pceo.id != 1
ORDER BY ' . XDB::formatCustomOrder('pid', $pids),
$pids, $visibility->levels());
* 3) attach addresses to jobs and profiles
*/
+// {{{ Database schema (profile_address, profile_jobs)
+/** The database for this is very unclear, so here is a little schema :
+ * profile_job describes a Job, links to:
+ * - a Profile, through `pid`
+ * - a Company, through `jobid`
+ * The `id` field is the id of this job in the list of the jobs of its profile
+ *
+ * profile_addresses describes an Address, which
+ * related to either a Profile, a Job or a Company:
+ * - for a Profile:
+ * - `type` is set to 'home'
+ * - `pid` is set to the related profile pid
+ * - `id` is the id of the address in the list of those related to that profile
+ * - `jobid` is empty
+ *
+ * - for a Company:
+ * - `type` is set to 'hq'
+ * - `pid` is set to 0
+ * - `jobid` is set to the id of the company
+ * - `id` is set to 0 (only one address per Company)
+ *
+ * - for a Job:
+ * - `type` is set to 'job'
+ * - `pid` is set to the pid of the Profile of the related Job
+ * - `jobid` is set to the Company of the job (this information is redundant
+ * with that of the row of profile_job for the related job)
+ * - `id` is the id of the job to which we refer (i.e `profile_job.id`)
+ *
+ * For the documentation of the phone table, please see classes/phone.php.
+ *
+ * The possible relations are as follow:
+ * An Address can be linked to a Company, a Profile, a Job
+ * A Job is linked to a Company and a Profile
+ */
+// }}}
+
// {{{ class ProfileAddresses [ Field ]
class ProfileAddresses extends ProfileField
{
$nb = 0;
foreach ($this->addresses as $addr) {
if (
- ($flags & Profile::ADDRESS_ALL)
- ||
(($flags & Profile::ADDRESS_MAIN) && $addr->hasFlag('current'))
||
(($flags & Profile::ADDRESS_POSTAL) && $addr->hasFlag('mail'))
||
- (($flags & Profile::ADDRESS_PERSO) && $addr->link_type == 'home')
+ (($flags & Profile::ADDRESS_PERSO) && $addr->link_type == Address::LINK_PROFILE)
||
- (($flags & Profile::ADDRESS_PRO) && $addr->link_type == 'job')
+ (($flags & Profile::ADDRESS_PRO) && $addr->link_type == Address::LINK_JOB)
) {
$res[] = $addr;
$nb++;
public static function fetchData(array $pids, ProfileVisibility $visibility)
{
$data = XDB::iterator('SELECT pa.id, pa.pid, pa.flags, pa.type AS link_type,
- IF(pa.type = \'home\', pid, jobid) AS link_id,
+ IF(pa.type = \'home\', pid, IF(pa.type = \'job\', pa.id, jobid)) AS link_id,
pa.text, pa.postalCode, pa.latitude, pa.longitude, pa.comment,
gl.name AS locality, gas.name AS subAdministrativeArea,
ga.name AS administrativeArea, gc.countryFR AS country
public function addPhones(ProfilePhones $phones)
{
- $p = $phones->get(0);
+ $p = $phones->get(Profile::PHONE_LINK_ADDRESS | Profile::PHONE_TYPE_ANY);
foreach ($p as $phone) {
- if ($phone->link_type == Phone::LINK_ADDRESS && array_key_exists($phone->link_id, $this->addresses)) {
- $this->addresses[$phone->link_id]->addPhone($phone);
+ if ($phone->linkType() == Phone::LINK_ADDRESS && array_key_exists($phone->linkId(), $this->addresses)) {
+ $this->addresses[$phone->linkId()]->addPhone($phone);
}
}
}
$phones = array();
$nb = 0;
foreach ($this->phones as $id => $phone) {
- $phones[$id] = $phone;
- ++$nb;
- if ($limit != null && $nb == $limit) {
- break;
+ if ($phone->hasFlags($flags)) {
+ $phones[$id] = $phone;
+ ++$nb;
+ if ($limit != null && $nb == $limit) {
+ break;
+ }
}
}
return $phones;
public static function fetchData(array $pids, ProfileVisibility $visibility)
{
- $data = XDB::iterator('SELECT tel_type AS type, search_tel AS search, display_tel AS display, link_type, comment
- FROM profile_phones
- WHERE pid IN {?} AND pub IN {?}
- ORDER BY ' . XDB::formatCustomOrder('pid', $pids),
- $pids, $visibility->levels());
- return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
+ $it = Phone::iterate($pids, array(), array(), $visibility->levels());
+ return PlIteratorUtils::subIterator($it->value(), PlIteratorUtils::arrayValueCallback('pid'));
}
}
// }}}
public function addPhones(ProfilePhones $phones)
{
- $p = $phones->get(0);
+ $p = $phones->get(Profile::PHONE_LINK_JOB | Profile::PHONE_TYPE_ANY);
foreach ($p as $phone) {
- if ($phone->link_type == Phone::LINK_JOB && array_key_exists($phone->link_id, $this->jobs)) {
- $this->jobs[$phone->link_id]->addPhones($phone);
+ if ($phone->linkType() == Phone::LINK_JOB && array_key_exists($phone->linkId(), $this->jobs)) {
+ $this->jobs[$phone->linkId()]->addPhone($phone);
}
}
}
- public static function addAddresses(ProfileAddresses $addresses)
+ public function addAddresses(ProfileAddresses $addresses)
{
$a = $addresses->get(Profile::ADDRESS_PRO);
foreach ($a as $address) {
}
}
- public static function addCompanies(array $companies)
+ public function addCompanies(array $companies)
+ {
+ foreach ($this->jobs as $job) {
+ $this->company = $companies[$job->jobid];
+ }
+ }
+
+ public function addJobTerms(ProfileJobTerms $jobterms)
{
- foreach ($this->jobs as $job)
- {
- $job->company = $companies[$job->jobid];
+ $terms = $jobterms->get();
+ foreach ($terms as $term) {
+ if ($this->pid == $term->pid && array_key_exists($term->jid, $this->jobs)) {
+ $this->jobs[$term->jid]->addTerm(&$term);
+ }
}
}
}
// }}}
+// {{{ class ProfileJobTerms [ Field ]
+class ProfileJobTerms extends ProfileField
+{
+ private $jobterms = array();
+ public function __construct(PlInnerSubIterator $it)
+ {
+ $this->pid = $it->value();
+ while ($term = $it->next()) {
+ $this->jobterms[] = new JobTerm($term);
+ }
+ }
+
+ public function get()
+ {
+ return $this->jobterms;
+ }
+
+ public static function fetchData(array $pids, ProfileVisibility $visibility)
+ {
+ $data = XDB::iterator('SELECT jt.jtid, jte.full_name, jt.pid, jt.jid
+ FROM profile_job_term AS jt
+ INNER JOIN profile_job AS j ON (jt.pid = j.pid AND jt.jid = j.id)
+ LEFT JOIN profile_job_term_enum AS jte USING(jtid)
+ WHERE jt.pid IN {?} AND j.pub IN {?}
+ ORDER BY ' . XDB::formatCustomOrder('jt.pid', $pids),
+ $pids, $visibility->levels());
+ return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
+ }
+}
+// }}}
+// {{{ class ProfileMentoringTerms [ Field ]
+class ProfileMentoringTerms extends ProfileJobTerms
+{
+ public static function fetchData(array $pids, ProfileVisibility $visibility)
+ {
+ $data = XDB::iterator('SELECT mt.jtid, jte.full_name, mt.pid
+ FROM profile_mentor_term AS mt
+ LEFT JOIN profile_job_term_enum AS jte USING(jtid)
+ WHERE mt.pid IN {?}
+ ORDER BY ' . XDB::formatCustomOrder('mt.pid', $pids),
+ $pids);
+ return PlIteratorUtils::subIterator($data, PlIteratorUtils::arrayValueCallback('pid'));
+ }
+}
+// }}}
// {{{ class CompanyList
class CompanyList
{
LEFT JOIN profile_addresses AS pa ON (pje.id = pa.jobid AND pa.type = \'hq\')
' . $join . '
' . $where);
+ $newcompanies = array();
while ($row = $it->next()) {
$cp = new Company($row);
$addr = new Address($row);
$cp->setAddress($addr);
+ if (!array_key_exists($row['id'], self::$companies)) {
+ $newcompanies[] = $row['id'];
+ }
self::$companies[$row['id']] = $cp;
}
- // TODO: add phones to addresses
+ // Add phones to hq
+ if (count($newcompanies)) {
+ $it = Phone::iterate(array(), array(Phone::LINK_COMPANY), $newcompanies);
+ while ($phone = $it->next()) {
+ self::$companies[$phone->linkId()]->setPhone($phone);
+ }
+ }
+
if (count($pids) == 0) {
self::$fullload = true;
}
projects / platal.git / blobdiff