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 ProfileGeoloc
31 public function __construct()
33 $this->pub
= new ProfilePub();
37 $this->web
= new ProfileWeb();
38 $this->bool
= new ProfileBool();
39 $this->checks
= array('web' => array('w_web'),
40 'mail_new' => array('w_email_new'),
41 'mail' => array('w_email'),
42 'pub' => array('pub', 'w_email_pub'));
45 private function cleanJob(ProfilePage
&$page, $jobid, array &$job, &$success)
48 foreach ($this->checks
as $obj=>&$fields) {
50 foreach ($fields as $field) {
51 if ($field == "w_email_new") {
52 if ($job['w_email'] == "new@example.org") {
53 $job['w_email'] = $job[$field];
57 $job[$field] = $chk->value($page, $field, $job[$field], $s);
60 $job[$field . '_error'] = true
;
64 if (!$job['sss_secteur_name']) {
65 $res = XDB
::query("SELECT name
66 FROM profile_job_subsubsector_enum
69 $job['sss_secteur_name'] = $res->fetchOneCell();
71 $res = XDB
::query("SELECT sectorid, subsectorid, id
72 FROM profile_job_subsubsector_enum
74 $job['sss_secteur_name']);
75 if ($res->numRows() != 1) {
77 $job['sector_error'] = true
;
79 list($job['secteur'], $job['ss_secteur'], $job['sss_secteur']) = $res->fetchOneRow();
83 $res = XDB
::query("SELECT id
87 if ($res->numRows() != 1) {
89 $req = new EntrReq($user, $jobid, $job['name'], $job['acronym'], $job['hq_web'], $job['hq_email'], $job['hq_tel'], $job['hq_fax']);
93 $job['jobid'] = $res->fetchOneCell();
96 $job['w_adr']['pub'] = $this->pub
->value($page, 'adr_pub', @$job['w_adr']['pub'], $s);
97 $job['w_adr']['checked'] = $this->bool
->value($page, 'adr_checked', @$job['w_adr']['checked'], $s);
98 if (!isset($job['w_tel'])) {
99 $job['w_tel'] = array();
101 $profiletel = new ProfilePhones('pro', $jobid);
102 $job['w_tel'] = $profiletel->value($page, 'tel', $job['w_tel'], $s);
103 unset($job['removed']);
105 unset($job['w_adr']['changed']);
106 unset($job['w_adr']['parsevalid']);
107 unset($job['w_adr']['display']);
110 public function value(ProfilePage
&$page, $field, $value, &$success)
112 require_once('validations.inc.php');
113 $entreprise = Validate
::get_typed_requests(S
::i('uid'), 'entreprise');
117 if (is_null($value)) {
118 $value = $page->values
['jobs'];
122 foreach ($value as $key=>&$job) {
123 $job['name'] = trim($job['name']);
125 $job['tmp_name'] = $entreprise[$entr_val]->name
;
128 if (@$job['removed']) {
132 foreach ($value as $key=>&$job) {
134 $this->geolocAddress($job['w_adr'], $s);
136 $this->cleanJob($page, $key, $job, $s);
139 $success = ($success && $ls);
145 public function save(ProfilePage
&$page, $field, $value)
147 require_once('profil.func.inc.php');
148 require_once('validations.inc.php');
150 XDB
::execute("DELETE FROM profile_job
153 XDB
::execute("DELETE FROM profile_phones
154 WHERE uid = {?} AND link_type = 'pro'",
156 foreach ($value as $id=>&$job) {
157 if ($job['w_email'] == "new@example.org") {
158 $job['w_email'] = $job['w_email_new'];
161 XDB
::execute("INSERT INTO profile_job (uid, id, functionid, description, sectorid, subsectorid,
162 subsubsectorid, email, url, pub, email_pub, jobid)
163 VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
164 S
::i('uid'), $id, $job['fonction'], $job['description'], $job['secteur'], $job['ss_secteur'],
165 $job['sss_secteur'], $job['w_email'], $job['w_web'], $job['pub'], $job['w_email_pub'], $job['jobid']);
167 XDB
::execute("INSERT INTO profile_job (uid, id, functionid, description, sectorid, subsectorid,
168 subsubsectorid, email, url, pub, email_pub)
169 VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})",
170 S
::i('uid'), $id, $job['fonction'], $job['description'], $job['secteur'], $job['ss_secteur'],
171 $job['sss_secteur'], $job['w_email'], $job['w_web'], $job['pub'], $job['w_email_pub']);
173 $profiletel = new ProfilePhones('pro', $id);
174 $profiletel->saveTels('tel', $job['w_tel']);
179 class ProfileJobs
extends ProfilePage
181 protected $pg_template = 'profile/jobs.tpl';
183 public function __construct(PlWizard
&$wiz)
185 parent
::__construct($wiz);
186 $this->settings
['cv'] = null
;
187 $this->settings
['corps'] = null
;
188 $this->settings
['jobs'] = new ProfileJob();
189 $this->watched
= array('cv' => true
, 'jobs' => true
, 'corps' => true
);
192 protected function _fetchData()
195 $res = XDB
::query("SELECT cv
199 $this->values
['cv'] = $res->fetchOneCell();
201 // Checkout the corps
202 $res = XDB
::query("SELECT original_corpsid AS original, current_corpsid AS current,
203 rankid AS rank, corps_pub AS pub
207 $this->values
['corps'] = $res->fetchOneAssoc();
209 // Build the jobs tree
210 $res = XDB
::iterRow("SELECT j.id, je.name, j.functionid, j.sectorid, j.subsectorid,
211 j.subsubsectorid, j.description, e.adr1, e.adr2, e.adr3,
212 e.postcode, e.city, e.cityid, e.region, e.regiontxt,
213 e.country, gp.pays, gp.display,
214 FIND_IN_SET('geoloc', flags),
215 j.email, j.url, j.pub,
216 e.adr_pub, j.email_pub,
217 e.glat, e.glng, s.name
218 FROM profile_job AS j
219 LEFT JOIN profile_job_enum AS je ON (j.jobid = je.id)
220 LEFT JOIN entreprises AS e ON (j.uid = e.uid AND j.id = e.entrid)
221 LEFT JOIN geoloc_pays AS gp ON (gp.a2 = e.country)
222 LEFT JOIN profile_job_subsubsector_enum AS s ON (s.id = j.subsubsectorid)
224 ORDER BY entrid", $this->pid());
225 $this->values
['jobs'] = array();
226 while (list($id, $name, $function, $secteur, $ss_secteur, $sss_secteur, $description,
227 $w_adr1, $w_adr2, $w_adr3, $w_postcode, $w_city, $w_cityid,
228 $w_region, $w_regiontxt, $w_country, $w_countrytxt, $w_display,
229 $w_checked, $w_email, $w_web,
230 $pub, $w_adr_pub, $w_email_pub, $w_glat, $w_glng, $sss_secteur_name
232 $this->values
['jobs'][] = array('id' => $id,
234 'fonction' => $function,
235 'secteur' => $secteur,
236 'ss_secteur' => $ss_secteur,
237 'sss_secteur' => $sss_secteur,
238 'sss_secteur_name' => $sss_secteur_name,
239 'description' => $description,
240 'w_adr' => array('adr1' => $w_adr1,
243 'postcode' => $w_postcode,
245 'cityid' => $w_cityid,
246 'region' => $w_region,
247 'regiontxt' => $w_regiontxt,
248 'country' => $w_country,
249 'countrytxt' => $w_countrytxt,
250 'display' => $w_display,
252 'checked' => $w_checked,
253 'precise_lat' => $w_glat,
254 'precise_lon' => $w_glng),
255 'w_email' => $w_email,
258 'w_email_pub' => $w_email_pub);
261 $res = XDB
::iterator("SELECT link_id AS jobid, tel_type AS type, pub, display_tel AS tel, comment
263 WHERE uid = {?} AND link_type = 'pro'
267 $jobNb = count($this->values
['jobs']);
268 while ($tel = $res->next()) {
269 $jobid = $tel['jobid'];
270 unset($tel['jobid']);
271 while ($i < $jobNb && $this->values
['jobs'][$i]['id'] < $jobid) {
277 $job =& $this->values
['jobs'][$i];
278 if (!isset($job['w_tel'])) {
279 $job['w_tel'] = array();
281 if ($job['id'] == $jobid) {
282 $job['w_tel'][] = $tel;
285 foreach ($this->values
['jobs'] as $id=>&$job) {
286 if (!isset($job['w_tel'])) {
287 $job['w_tel'] = array();
293 protected function _saveData()
295 if ($this->changed
['cv']) {
296 XDB
::execute("UPDATE profiles
299 $this->values
['cv'], $this->pid());
302 if ($this->changed
['corps']) {
303 XDB
::execute("UPDATE profile_corps
304 SET original_corpsid = {?}, current_corpsid = {?},
305 rankid = {?}, corps_pub = {?}
307 $this->values
['corps']['original'], $this->values
['corps']['current'],
308 $this->values
['corps']['rank'], $this->values
['corps']['pub'], $this->pid());
312 public function _prepare(PlPage
&$page, $id)
314 require_once "emails.combobox.inc.php";
315 fill_email_combobox($page, $this->owner
, $this->profile
);
317 $res = XDB
::query("SELECT id, name AS label
318 FROM profile_job_sector_enum");
319 $page->assign('secteurs', $res->fetchAllAssoc());
320 $res = XDB
::query("SELECT id, fonction_fr, FIND_IN_SET('titre', flags) AS title
323 $page->assign('fonctions', $res->fetchAllAssoc());
325 $res = XDB
::iterator("SELECT id, name
326 FROM profile_corps_enum
327 ORDER BY id = 1 DESC, name");
328 $page->assign('original_corps', $res->fetchAllAssoc());
330 $res = XDB
::iterator("SELECT id, name
331 FROM profile_corps_enum
332 WHERE still_exists = 1
333 ORDER BY id = 1 DESC, name");
334 $page->assign('current_corps', $res->fetchAllAssoc());
336 $res = XDB
::iterator("SELECT id, name
337 FROM profile_corps_rank_enum");
338 $page->assign('corps_rank', $res->fetchAllAssoc());
342 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: