* 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
***************************************************************************/
+class ProfileJob extends ProfileGeoloc
+{
+ private $pub;
+ private $mail;
+ private $web;
+ private $tel;
+ private $checks;
+
+ public function __construct()
+ {
+ $this->pub = new ProfilePub();
+ $this->mail = new ProfileEmail();
+ $this->web = new ProfileWeb();
+ $this->tel = new ProfileTel();
+ $this->checks = array('web' => array('web'),
+ 'mail' => array('email'),
+ 'tel' => array('tel', 'fax', 'mobile'),
+ 'pub' => array('pub', 'tel_pub', 'email_pub'));
+ }
+
+ private function cleanJob(ProfilePage &$page, array &$job, &$success)
+ {
+ $success = true;
+ foreach ($this->checks as $obj=>&$fields) {
+ $chk =& $this->$obj;
+ foreach ($fields as $field) {
+ $job[$field] = $chk->value($page, $field, $job[$field], $s);
+ if (!$s) {
+ $success = false;
+ $job[$field . '_error'] = true;
+ }
+ }
+ }
+ unset($job['removed']);
+ unset($job['new']);
+ unset($job['adr']['changed']);
+ unset($job['adr']['parsevalid']);
+ unset($job['adr']['display']);
+ }
+
+ public function value(ProfilePage &$page, $field, $value, &$success)
+ {
+ $init = false;
+ if (is_null($value)) {
+ $value = $page->values['jobs'];
+ $init = true;
+ }
+ $success = true;
+ foreach ($value as $key=>&$job) {
+ if (@$job['removed']) {
+ unset($value[$key]);
+ }
+ }
+ foreach ($value as $key=>&$job) {
+ $ls = true;
+ $this->geolocAddress($job['adr'], $s);
+ $ls = ($ls && $s);
+ $this->cleanJob($page, $job, $s);
+ $ls = ($ls && $s);
+ if (!$init) {
+ $success = ($success && $ls);
+ }
+ }
+ return $value;
+ }
+
+ public function save(ProfilePage &$page, $field, $value)
+ {
+ XDB::execute("DELETE FROM entreprises
+ WHERE uid = {?}",
+ S::i('uid'));
+ $i = 0;
+ foreach ($value as &$job) {
+ XDB::execute("INSERT INTO entreprises (uid, entrid, entreprise, secteur, ss_secteur,
+ fonction, poste, adr1, adr2, adr3, postcode,
+ city, cityid, country, region, regiontxt,
+ tel, fax, mobile, email, web,
+ pub, adr_pub, tel_pub, email_pub)
+ VALUES ({?}, {?}, {?}, {?}, {?},
+ {?}, {?}, {?}, {?}, {?}, {?},
+ {?}, {?}, {?}, {?}, {?},
+ {?}, {?}, {?}, {?}, {?},
+ {?}, {?}, {?}, {?})",
+ S::i('uid'), $i++, $job['name'], $job['secteur'], $job['ss_secteur'],
+ $job['fonction'], $job['poste'], $job['adr']['adr1'], $job['adr']['adr2'], $job['adr']['adr3'],
+ $job['adr']['postcode'],
+ $job['adr']['city'], $job['adr']['cityid'], $job['adr']['country'], $job['adr']['region'],
+ $job['adr']['regiontxt'],
+ $job['tel'], $job['fax'], $job['mobile'], $job['email'], $job['web'],
+ $job['pub'], $job['adr']['pub'], $job['tel_pub'], $job['email_pub']);
+ }
+ }
+}
+
class ProfileJobs extends ProfilePage
{
protected $pg_template = 'profile/jobs.tpl';
public function __construct(PlWizard &$wiz)
{
parent::__construct($wiz);
+ $this->settings['cv'] = null;
+ $this->settings['jobs'] = new ProfileJob();
+ }
+
+ protected function fetchData()
+ {
+ if (count($this->orig) > 0) {
+ $this->values = $this->orig;
+ return;
+ }
+ // Checkout the CV
+ $res = XDB::query("SELECT cv
+ FROM auth_user_md5
+ WHERE user_id = {?}",
+ S::i('uid'));
+ $this->values['cv'] = $res->fetchOneCell();
+
+ // Build the jobs tree
+ $res = XDB::iterRow("SELECT e.entreprise, e.secteur, e.ss_secteur,
+ e.fonction, e.poste, e.adr1, e.adr2, e.adr3,
+ e.postcode, e.city, e.cityid, e.region, e.regiontxt,
+ e.country, gp.pays, gp.display,
+ e.tel, e.fax, e.mobile, e.email, e.web, e.pub,
+ e.adr_pub, e.tel_pub, e.email_pub
+ FROM entreprises AS e
+ INNER JOIN geoloc_pays AS gp ON(gp.a2 = e.country)
+ WHERE uid = {?} AND entreprise != ''
+ ORDER BY entrid", S::i('uid'));
+ $this->values['jobs'] = array();
+ while (list($name, $secteur, $ss_secteur, $fonction, $poste,
+ $adr1, $adr2, $adr3, $postcode, $city, $cityid,
+ $region, $regiontxt, $country, $countrytxt, $display,
+ $tel, $fax, $mobile, $email, $web,
+ $pub, $adr_pub, $tel_pub, $email_pub) = $res->next()) {
+ $this->values['jobs'][] = array('name' => $name,
+ 'secteur' => $secteur,
+ 'ss_secteur' => $ss_secteur,
+ 'fonction' => $fonction,
+ 'poste' => $poste,
+ 'adr' => array('adr1' => $adr1,
+ 'adr2' => $adr2,
+ 'adr3' => $adr3,
+ 'postcode' => $postcode,
+ 'city' => $city,
+ 'cityid' => $cityid,
+ 'region' => $region,
+ 'regiontxt' => $regiontxt,
+ 'country' => $country,
+ 'countrytxt' => $countrytxt,
+ 'display' => $display,
+ 'pub' => $adr_pub),
+ 'tel' => $tel,
+ 'fax' => $fax,
+ 'mobile' => $mobile,
+ 'email' => $email,
+ 'web' => $web,
+ 'pub' => $pub,
+ 'adr_pub' => $adr_pub,
+ 'tel_pub' => $tel_pub,
+ 'email_pub' => $email_pub);
+ }
+ parent::fetchData();
+ }
+
+ protected function saveData()
+ {
+ if ($this->changed['cv']) {
+ XDB::execute("UPDATE auth_user_md5
+ SET cv = {?}
+ WHERE user_id = {?}",
+ $this->values['cv'], S::i('uid'));
+ }
+ parent::saveData();
}
public function prepare(PlatalPage &$page)