X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fprofile%2Fjobs.inc.php;h=b81c8f9433a99c6366ad671bf77b6a3e7970251e;hb=37d44b3b542764eda8d4f9c3febc814ae37f8157;hp=40628eedcb57ac866c4d78c01cdb7b794a1568b7;hpb=3950bc21efd9cd06d800248b36abdeee00e25132;p=platal.git diff --git a/modules/profile/jobs.inc.php b/modules/profile/jobs.inc.php index 40628ee..b81c8f9 100644 --- a/modules/profile/jobs.inc.php +++ b/modules/profile/jobs.inc.php @@ -19,6 +19,100 @@ * 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'; @@ -26,6 +120,89 @@ class ProfileJobs extends ProfilePage 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) + { + 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 + FROM fonctions_def + ORDER BY id")); } }