<?php
/***************************************************************************
- * Copyright (C) 2003-2009 Polytechnique.org *
+ * Copyright (C) 2003-2010 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
* 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
***************************************************************************/
-class ProfileJob extends ProfileGeocoding
+class ProfileSettingJob extends ProfileSettingGeocoding
{
private $pub;
private $email_new;
public function __construct()
{
- $this->pub = new ProfilePub();
+ $this->pub = new ProfileSettingPub();
$this->email
= $this->email_new
- = new ProfileEmail();
- $this->url = new ProfileWeb();
- $this->bool = new ProfileBool();
+ = new ProfileSettingEmail();
+ $this->url = new ProfileSettingWeb();
+ $this->bool = new ProfileSettingBool();
$this->checks = array('url' => array('w_url'),
'email' => array('w_email'),
'pub' => array('pub', 'w_email_pub'),
if (!isset($job['w_phone'])) {
$job['w_phone'] = array();
}
- $profiletel = new ProfilePhones('pro', $jobid);
+ $profiletel = new ProfileSettingPhones('pro', $jobid);
$job['w_phone'] = $profiletel->value($page, 'tel', $job['w_phone'], $s);
unset($job['removed']);
require_once('validations.inc.php');
XDB::execute("DELETE FROM profile_job
- WHERE uid = {?}",
- S::i('uid'));
+ WHERE pid = {?}",
+ $this->pid());
XDB::execute("DELETE FROM profile_addresses
WHERE pid = {?} AND type = 'job'",
- S::i('uid'));
+ $this->pid());
XDB::execute("DELETE FROM profile_phones
- WHERE uid = {?} AND link_type = 'pro'",
- S::i('uid'));
+ WHERE pid = {?} AND link_type = 'pro'",
+ $this->pid());
foreach ($value as $id=>&$job) {
if (isset($job['name']) && $job['name']) {
if (isset($job['jobid']) && $job['jobid']) {
- XDB::execute("INSERT INTO profile_job (uid, id, description, sectorid, subsectorid,
+ XDB::execute("INSERT INTO profile_job (pid, id, description, sectorid, subsectorid,
subsubsectorid, email, url, pub, email_pub, jobid)
VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
- S::i('uid'), $id, $job['description'], $job['sector'], $job['subSector'],
+ $this->pid(), $id, $job['description'], $job['sector'], $job['subSector'],
$job['subSubSector'], $job['w_email'], $job['w_url'], $job['pub'], $job['w_email_pub'], $job['jobid']);
} else {
- XDB::execute("INSERT INTO profile_job (uid, id, description, sectorid, subsectorid,
+ XDB::execute("INSERT INTO profile_job (pid, id, description, sectorid, subsectorid,
subsubsectorid, email, url, pub, email_pub)
VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
- S::i('uid'), $id, $job['description'], $job['sector'], $job['subSector'],
+ $this->pid(), $id, $job['description'], $job['sector'], $job['subSector'],
$job['subSubSector'], $job['w_email'], $job['w_url'], $job['pub'], $job['w_email_pub']);
}
- $address = new ProfileAddress();
+ $address = new ProfileSettingAddress();
$address->saveAddress($id, $job['w_address'], 'job');
- $profiletel = new ProfilePhones('pro', $id);
+ $profiletel = new ProfileSettingPhones('pro', $id);
$profiletel->saveTels('tel', $job['w_phone']);
}
}
}
}
-class ProfileJobs extends ProfilePage
+class ProfileSettingJobs extends ProfilePage
{
protected $pg_template = 'profile/jobs.tpl';
parent::__construct($wiz);
$this->settings['cv'] = null;
$this->settings['corps'] = null;
- $this->settings['jobs'] = new ProfileJob();
+ $this->settings['jobs'] = new ProfileSettingJob();
$this->watched = array('cv' => true, 'jobs' => true, 'corps' => true);
}
{
// Checkout the CV
$res = XDB::query("SELECT cv
- FROM auth_user_md5
- WHERE user_id = {?}",
- S::i('uid'));
+ FROM profiles
+ WHERE pid = {?}",
+ $this->pid());
$this->values['cv'] = $res->fetchOneCell();
// Checkout the corps
$res = XDB::query("SELECT original_corpsid AS original, current_corpsid AS current,
rankid AS rank, corps_pub AS pub
FROM profile_corps
- WHERE uid = {?}",
- S::i('uid'));
+ WHERE pid = {?}",
+ $this->pid());
$this->values['corps'] = $res->fetchOneAssoc();
// Build the jobs tree
FROM profile_job AS j
LEFT JOIN profile_job_enum AS je ON (j.jobid = je.id)
LEFT JOIN profile_job_subsubsector_enum AS s ON (s.id = j.subsubsectorid)
- LEFT JOIN profile_addresses AS aw ON (aw.pid = j.uid AND aw.type = 'job'
+ LEFT JOIN profile_addresses AS aw ON (aw.pid = j.pid AND aw.type = 'job'
AND aw.id = j.id)
LEFT JOIN profile_addresses AS ah ON (ah.jobid = j.jobid AND ah.type = 'hq')
- WHERE j.uid = {?}
+ WHERE j.pid = {?}
ORDER BY j.id",
- S::i('uid'));
+ $this->pid());
$this->values['jobs'] = array();
if ($res->numRows() > 0) {
$res = XDB::iterator("SELECT link_id AS jobid, tel_type AS type, pub, display_tel AS tel, comment
FROM profile_phones
- WHERE uid = {?} AND link_type = 'pro'
+ WHERE pid = {?} AND link_type = 'pro'
ORDER BY link_id",
S::i('uid'));
$i = 0;
protected function _saveData()
{
if ($this->changed['cv']) {
- XDB::execute("UPDATE auth_user_md5
+ XDB::execute("UPDATE profiles
SET cv = {?}
- WHERE user_id = {?}",
- $this->values['cv'], S::i('uid'));
+ WHERE pid = {?}",
+ $this->values['cv'], $this->pid());
}
if ($this->changed['corps']) {
XDB::execute("UPDATE profile_corps
SET original_corpsid = {?}, current_corpsid = {?},
rankid = {?}, corps_pub = {?}
- WHERE uid = {?}",
+ WHERE pid = {?}",
$this->values['corps']['original'], $this->values['corps']['current'],
- $this->values['corps']['rank'], $this->values['corps']['pub'], S::i('uid'));
+ $this->values['corps']['rank'], $this->values['corps']['pub'], $this->pid());
}
}
public function _prepare(PlPage &$page, $id)
{
require_once "emails.combobox.inc.php";
- fill_email_combobox($page);
+ fill_email_combobox($page, $this->owner, $this->profile);
$res = XDB::query("SELECT id, name AS label
FROM profile_job_sector_enum");
projects / platal.git / blobdiff