2 /***************************************************************************
3 * Copyright (C) 2003-2009 Polytechnique.org *
4 * http://opensource.polytechnique.org/ *
6 * This program is free software; you can redistribute it and/or modify *
7 * it under the terms of the GNU General Public License as published by *
8 * the Free Software Foundation; either version 2 of the License, or *
9 * (at your option) any later version. *
11 * This program is distributed in the hope that it will be useful, *
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
14 * GNU General Public License for more details. *
16 * You should have received a copy of the GNU General Public License *
17 * along with this program; if not, write to the Free Software *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
22 class ProfileJob
extends ProfileGeocoding
31 public function __construct()
33 $this->pub
= new ProfilePub();
37 $this->url
= new ProfileWeb();
38 $this->bool
= new ProfileBool();
39 $this->checks
= array('url' => array('w_url'),
40 'email' => array('w_email'),
41 'pub' => array('pub', 'w_email_pub'),
45 public function emptyJob()
55 'hq_address' => array(
60 'administrativeAreaId' => '',
61 'subAdministrativeAreaId' => '',
77 'subSubSectorName' => null
,
80 'subSubSector' => '0',
89 'administrativeAreaId' => '',
90 'subAdministrativeAreaId' => '',
105 'w_email_pub' => 'private',
107 'w_phone' => array(0 => array(
116 private function cleanJob(ProfilePage
&$page, $jobid, array &$job, &$success)
119 if ($job['w_email'] == "new@example.org") {
120 $job['w_email'] = $job['w_email_new'];
122 foreach ($this->checks
as $obj=>&$fields) {
124 foreach ($fields as $field) {
125 $job[$field] = $chk->value($page, $field, $job[$field], $s);
128 $job[$field . '_error'] = true
;
132 if (!$job['subSubSectorName']) {
133 $res = XDB
::query("SELECT name
134 FROM profile_job_subsubsector_enum
136 $job['subSubSector']);
137 $job['subSubSectorName'] = $res->fetchOneCell();
139 $res = XDB
::query("SELECT sectorid, subsectorid, id
140 FROM profile_job_subsubsector_enum
142 $job['subSubSectorName']);
143 if ($res->numRows() != 1) {
145 $job['sector_error'] = true
;
147 list($job['sector'], $job['subSector'], $job['subSubSector']) = $res->fetchOneRow();
151 $res = XDB
::query("SELECT id
152 FROM profile_job_enum
155 if ($res->numRows() != 1) {
157 $this->geocodeAddress($job['hq_address'], $s);
159 $gmapsGeocoder = new GMapsGeocoder();
160 $job['hq_address'] = $gmapsGeocoder->stripGeocodingFromAddress($job['hq_address']);
162 $req = new EntrReq($user, $jobid, $job['name'], $job['hq_acronym'], $job['hq_url'],
163 $job['hq_email'], $job['hq_fixed'], $job['hq_fax'], $job['hq_address']);
165 $job['jobid'] = null
;
167 $job['jobid'] = $res->fetchOneCell();
170 $job['w_address']['pub'] = $this->pub
->value($page, 'address_pub', $job['w_address']['pub'], $s);
171 if (!isset($job['w_phone'])) {
172 $job['w_phone'] = array();
174 $profiletel = new ProfilePhones('pro', $jobid);
175 $job['w_phone'] = $profiletel->value($page, 'tel', $job['w_phone'], $s);
177 unset($job['removed']);
181 public function value(ProfilePage
&$page, $field, $value, &$success)
183 require_once('validations.inc.php');
184 $entreprise = Validate
::get_typed_requests(S
::i('uid'), 'entreprise');
188 if (is_null($value)) {
189 $value = $page->values
['jobs'];
193 foreach ($value as $key=>&$job) {
194 $job['name'] = trim($job['name']);
195 if (!$job['name'] && $entreprise) {
196 $job['tmp_name'] = $entreprise[$entr_val]->name
;
199 if (isset($job['removed']) && $job['removed']) {
203 foreach ($value as $key=>&$job) {
205 $this->geocodeAddress($job['w_address'], $s);
207 $this->cleanJob($page, $key, $job, $s);
210 $success = ($success && $ls);
216 public function save(ProfilePage
&$page, $field, $value)
218 // TODO: use address and phone classes to update profile_job_enum and profile_phones once they are done.
220 require_once('profil.func.inc.php');
221 require_once('validations.inc.php');
223 XDB
::execute("DELETE FROM profile_job
226 XDB
::execute("DELETE FROM profile_addresses
227 WHERE pid = {?} AND type = 'job'",
229 XDB
::execute("DELETE FROM profile_phones
230 WHERE uid = {?} AND link_type = 'pro'",
232 foreach ($value as $id=>&$job) {
233 if (isset($job['name']) && $job['name']) {
234 if (isset($job['jobid']) && $job['jobid']) {
235 XDB
::execute("INSERT INTO profile_job (uid, id, description, sectorid, subsectorid,
236 subsubsectorid, email, url, pub, email_pub, jobid)
237 VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
238 S
::i('uid'), $id, $job['description'], $job['sector'], $job['subSector'],
239 $job['subSubSector'], $job['w_email'], $job['w_url'], $job['pub'], $job['w_email_pub'], $job['jobid']);
241 XDB
::execute("INSERT INTO profile_job (uid, id, description, sectorid, subsectorid,
242 subsubsectorid, email, url, pub, email_pub)
243 VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
244 S
::i('uid'), $id, $job['description'], $job['sector'], $job['subSector'],
245 $job['subSubSector'], $job['w_email'], $job['w_url'], $job['pub'], $job['w_email_pub']);
247 $address = new ProfileAddress();
248 $address->saveAddress($id, $job['w_address'], 'job');
249 $profiletel = new ProfilePhones('pro', $id);
250 $profiletel->saveTels('tel', $job['w_phone']);
256 class ProfileJobs
extends ProfilePage
258 protected $pg_template = 'profile/jobs.tpl';
260 public function __construct(PlWizard
&$wiz)
262 parent
::__construct($wiz);
263 $this->settings
['cv'] = null
;
264 $this->settings
['corps'] = null
;
265 $this->settings
['jobs'] = new ProfileJob();
266 $this->watched
= array('cv' => true
, 'jobs' => true
, 'corps' => true
);
269 protected function _fetchData()
272 $res = XDB
::query("SELECT cv
274 WHERE user_id = {?}",
276 $this->values
['cv'] = $res->fetchOneCell();
278 // Checkout the corps
279 $res = XDB
::query("SELECT original_corpsid AS original, current_corpsid AS current,
280 rankid AS rank, corps_pub AS pub
284 $this->values
['corps'] = $res->fetchOneAssoc();
286 // Build the jobs tree
287 $res = XDB
::iterRow("SELECT j.id, j.jobid, je.name, j.sectorid, j.subsectorid, j.subsubsectorid,
288 s.name, j.description, j.email, j.email_pub, j.url, j.pub,
289 je.acronym, je.url, je.email,
290 aw.accuracy, aw.text, aw.postalText, aw.postalCode, aw.localityId,
291 aw.subAdministrativeAreaId, aw.administrativeAreaId, aw.countryId,
292 aw.latitude, aw.longitude, aw.pub, aw.updateTime,
293 aw.north, aw.south, aw.east, aw.west,
294 ah.accuracy, ah.text, ah.postalText, ah.postalCode, ah.localityId,
295 ah.subAdministrativeAreaId, ah.administrativeAreaId, ah.countryId,
296 ah.latitude, ah.longitude, ah.pub, ah.updateTime,
297 ah.north, ah.south, ah.east, ah.west
298 FROM profile_job AS j
299 LEFT JOIN profile_job_enum AS je ON (j.jobid = je.id)
300 LEFT JOIN profile_job_subsubsector_enum AS s ON (s.id = j.subsubsectorid)
301 LEFT JOIN profile_addresses AS aw ON (aw.pid = j.uid AND aw.type = 'job'
303 LEFT JOIN profile_addresses AS ah ON (ah.jobid = j.jobid AND ah.type = 'hq')
307 $this->values
['jobs'] = array();
309 if ($res->numRows() > 0) {
310 while (list($id, $jobid, $name, $sector, $subSector, $subSubSector,
311 $subSubSectorName, $description, $w_email, $w_emailPub, $w_url, $pub,
312 $hq_acronym, $hq_url, $hq_email,
313 $w_accuracy, $w_text, $w_postalText, $w_postalCode, $w_localityId,
314 $w_subAdministrativeAreaId, $w_administrativeAreaId, $w_countryId,
315 $w_latitude, $w_longitude, $w_pub, $w_updateTime,
316 $w_north, $w_south, $w_east, $w_west,
317 $hq_accuracy, $hq_text, $hq_postalText, $hq_postalCode, $hq_localityId,
318 $hq_subAdministrativeAreaId, $hq_administrativeAreaId, $hq_countryId,
319 $hq_latitude, $hq_longitude, $hq_pub, $hq_updateTime,
320 $hq_north, $hq_south, $hq_east, $hq_west,
322 $this->values
['jobs'][] = array(
327 'subSector' => $subSector,
328 'subSubSector' => $subSubSector,
329 'subSubSectorName' => $subSubSectorName,
330 'description' => $description,
332 'w_email' => $w_email,
333 'w_email_pub' => $w_emailPub,
335 'hq_acronym' => $hq_acronym,
337 'hq_email' => $hq_email,
338 'w_address' => array(
339 'accuracy' => $w_accuracy,
341 'postalText' => $w_postalText,
342 'postalCode' => $w_postalCode,
343 'localityId' => $w_localityId,
344 'subAdministrativeAreaId' => $w_subAdministrativeAreaId,
345 'administrativeAreaId' => $w_administrativeAreaId,
346 'countryId' => $w_countryId,
347 'latitude' => $w_latitude,
348 'longitude' => $w_longitude,
350 'updateTime' => $w_updateTime,
356 'hq_address' => array(
357 'accuracy' => $hq_accuracy,
359 'postalText' => $hq_postalText,
360 'postalCode' => $hq_postalCode,
361 'localityId' => $hq_localityId,
362 'subAdministrativeAreaId' => $hq_subAdministrativeAreaId,
363 'administrativeAreaId' => $hq_administrativeAreaId,
364 'countryId' => $hq_countryId,
365 'latitude' => $hq_latitude,
366 'longitude' => $hq_longitude,
368 'updateTime' => $hq_updateTime,
369 'north' => $hq_north,
370 'south' => $hq_south,
377 $res = XDB
::iterator("SELECT link_id AS jobid, tel_type AS type, pub, display_tel AS tel, comment
379 WHERE uid = {?} AND link_type = 'pro'
383 $jobNb = count($this->values
['jobs']);
384 while ($phone = $res->next()) {
385 $jobid = $phone['jobid'];
386 while ($i < $jobNb && $this->values
['jobs'][$i]['id'] < $jobid) {
392 $job =& $this->values
['jobs'][$i];
393 if (!isset($job['w_phone'])) {
394 $job['w_phone'] = array();
396 if ($job['id'] == $jobid) {
397 $job['w_phone'][] = $phone;
400 foreach ($this->values
['jobs'] as $id => &$job) {
401 if (!isset($job['w_phone'])) {
402 $job['w_phone'] = array(
413 $job['w_email_new'] = '';
414 if (!isset($job['hq_phone'])) {
415 $job['hq_phone'] = '';
417 if (!isset($job['hq_fax'])) {
420 if (!isset($job['w_email_pub'])) {
421 $job['w_email_pub'] = 'private';
423 if (!$job['hq_address']['text']) {
424 $job['hq_address'] = array(
429 'administrativeAreaId' => '',
430 'subAdministrativeAreaId' => '',
445 $job['w_address']['cedex'] = '';
446 $job['w_address']['changed'] = '0';
447 $job['w_address']['removed'] = '0';
449 $this->values
['jobs'][] = $this->settings
['jobs']->emptyJob();
453 protected function _saveData()
455 if ($this->changed
['cv']) {
456 XDB
::execute("UPDATE auth_user_md5
458 WHERE user_id = {?}",
459 $this->values
['cv'], S
::i('uid'));
462 if ($this->changed
['corps']) {
463 XDB
::execute("UPDATE profile_corps
464 SET original_corpsid = {?}, current_corpsid = {?},
465 rankid = {?}, corps_pub = {?}
467 $this->values
['corps']['original'], $this->values
['corps']['current'],
468 $this->values
['corps']['rank'], $this->values
['corps']['pub'], S
::i('uid'));
472 public function _prepare(PlPage
&$page, $id)
474 require_once "emails.combobox.inc.php";
475 fill_email_combobox($page);
477 $res = XDB
::query("SELECT id, name AS label
478 FROM profile_job_sector_enum");
479 $page->assign('sectors', $res->fetchAllAssoc());
481 $res = XDB
::iterator("SELECT id, name
482 FROM profile_corps_enum
483 ORDER BY id = 1 DESC, name");
484 $page->assign('original_corps', $res->fetchAllAssoc());
486 $res = XDB
::iterator("SELECT id, name
487 FROM profile_corps_enum
488 WHERE still_exists = 1
489 ORDER BY id = 1 DESC, name");
490 $page->assign('current_corps', $res->fetchAllAssoc());
492 $res = XDB
::iterator("SELECT id, name
493 FROM profile_corps_rank_enum");
494 $page->assign('corps_rank', $res->fetchAllAssoc());
498 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: