X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fprofile%2Fjobs.inc.php;h=ad1e921f6d4edeb5aafa73119d19b02cb089984d;hb=f70f2bcdc077c220e40ecebaf569e097f6028743;hp=05e538c55b96c003248b6c372770e625912d924b;hpb=2dcac0f527e8207d754af8974d81b2bce3f433d9;p=platal.git diff --git a/modules/profile/jobs.inc.php b/modules/profile/jobs.inc.php index 05e538c..ad1e921 100644 --- a/modules/profile/jobs.inc.php +++ b/modules/profile/jobs.inc.php @@ -1,6 +1,6 @@ pub = new ProfilePub(); + $this->mail = new ProfileEmail(); + $this->web = new ProfileWeb(); + $this->tel = new ProfileTel(); + $this->bool = new ProfileBool(); + $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; + } + } + } + $job['adr']['pub'] = $this->pub->value($page, 'adr_pub', @$job['adr']['pub'], $s); + $job['adr']['checked'] = $this->bool->value($page, 'adr_checked', @$job['adr']['checked'], $s); + 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'] || !trim($job['name'])) { + 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, flags, + glat, glng) + 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'], + $job['adr']['checked'] ? 'geoloc' : '', $job['adr']['precise_lat'], + $job['adr']['precise_lon']); + } + } +} + class ProfileJobs extends ProfilePage { protected $pg_template = 'profile/jobs.tpl'; @@ -26,11 +128,82 @@ class ProfileJobs extends ProfilePage public function __construct(PlWizard &$wiz) { parent::__construct($wiz); + $this->settings['cv'] = null; + $this->settings['jobs'] = new ProfileJob(); + $this->watched['cv'] = $this->watched['jobs'] = true; + } + + protected function _fetchData() + { + // 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, + FIND_IN_SET('geoloc', flags), + e.tel, e.fax, e.mobile, e.email, e.web, e.pub, + e.adr_pub, e.tel_pub, e.email_pub, + e.glat AS precise_lat, e.glng AS precise_lon + FROM entreprises AS e + LEFT 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, + $checked, $tel, $fax, $mobile, $email, $web, + $pub, $adr_pub, $tel_pub, $email_pub, $glat, $glng) = $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, + 'checked' => $checked, + 'precise_lat'=> $glat, + 'precise_lon'=> $glng), + 'tel' => $tel, + 'fax' => $fax, + 'mobile' => $mobile, + 'email' => $email, + 'web' => $web, + 'pub' => $pub, + 'tel_pub' => $tel_pub, + 'email_pub' => $email_pub); + } + } + + protected function _saveData() + { + if ($this->changed['cv']) { + XDB::execute("UPDATE auth_user_md5 + SET cv = {?} + WHERE user_id = {?}", + $this->values['cv'], S::i('uid')); + } } - public function prepare(PlatalPage &$page) + public function _prepare(PlPage &$page, $id) { - parent::prepare($page); $page->assign('secteurs', XDB::iterator("SELECT id, label FROM emploi_secteur")); $page->assign('fonctions', XDB::iterator("SELECT id, fonction_fr, FIND_IN_SET('titre', flags) AS title