modules/profile/jobs.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2009 Polytechnique.org                              *
   4  *  http://opensource.polytechnique.org/                                   *
   5  *                                                                         *
   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.                                    *
  10  *                                                                         *
  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.                           *
  15  *                                                                         *
  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            *
  18  *  Foundation, Inc.,                                                      *
  19  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  20  ***************************************************************************/
  21
  22 class ProfileJob extends ProfileGeocoding
  23 {
  24     private $pub;
  25     private $mail_new;
  26     private $mail;
  27     private $web;
  28     private $bool;
  29     private $checks;
  30
  31     public function __construct()
  32     {
  33         $this->pub    = new ProfilePub();
  34         $this->mail
  35                       = $this->mail_new
  36                       = new ProfileEmail();
  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'));
  43     }
  44
  45     private function cleanJob(ProfilePage &$page, $jobid, array &$job, &$success)
  46     {
  47         $success = true;
  48         foreach ($this->checks as $obj=>&$fields) {
  49             $chk =& $this->$obj;
  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];
  54                     }
  55                     continue;
  56                 }
  57                 $job[$field] = $chk->value($page, $field, $job[$field], $s);
  58                 if (!$s) {
  59                     $success = false;
  60                     $job[$field . '_error'] = true;
  61                 }
  62             }
  63         }
  64         if (!$job['sss_secteur_name']) {
  65             $res = XDB::query("SELECT  name
  66                                  FROM  profile_job_subsubsector_enum
  67                                 WHERE  id = {?}",
  68                               $job['sss_secteur']);
  69             $job['sss_secteur_name'] = $res->fetchOneCell();
  70         } else {
  71             $res = XDB::query("SELECT  sectorid, subsectorid, id
  72                                  FROM  profile_job_subsubsector_enum
  73                                 WHERE  name = {?}",
  74                               $job['sss_secteur_name']);
  75             if ($res->numRows() != 1) {
  76                 $success = false;
  77                 $job['sector_error'] = true;
  78             } else {
  79                 list($job['secteur'], $job['ss_secteur'], $job['sss_secteur']) = $res->fetchOneRow();
  80             }
  81         }
  82         if ($job['name']) {
  83             $res = XDB::query("SELECT  id
  84                                  FROM  profile_job_enum
  85                                 WHERE  name = {?}",
  86                               $job['name']);
  87             if ($res->numRows() != 1) {
  88                 $user = S::user();
  89                 $req = new EntrReq($user, $jobid, $job['name'], $job['acronym'], $job['hq_web'], $job['hq_email'], $job['hq_tel'], $job['hq_fax']);
  90                 $req->submit();
  91                 $job['jobid'] = null;
  92             } else {
  93                 $job['jobid'] = $res->fetchOneCell();
  94             }
  95         }
  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();
 100         }
 101         $profiletel = new ProfilePhones('pro', $jobid);
 102         $job['w_tel'] = $profiletel->value($page, 'tel', $job['w_tel'], $s);
 103         unset($job['removed']);
 104         unset($job['new']);
 105         unset($job['w_adr']['changed']);
 106         unset($job['w_adr']['parsevalid']);
 107         unset($job['w_adr']['display']);
 108     }
 109
 110     public function value(ProfilePage &$page, $field, $value, &$success)
 111     {
 112         require_once('validations.inc.php');
 113         $entreprise = Validate::get_typed_requests(S::i('uid'), 'entreprise');
 114         $entr_val = 0;
 115
 116         $init = false;
 117         if (is_null($value)) {
 118             $value = $page->values['jobs'];
 119             $init = true;
 120         }
 121         $success = true;
 122         foreach ($value as $key=>&$job) {
 123             $job['name'] = trim($job['name']);
 124             if (!$job['name']) {
 125                 $job['tmp_name'] = $entreprise[$entr_val]->name;
 126                 $entr_val ++;
 127             }
 128             if (@$job['removed']) {
 129                 unset($value[$key]);
 130             }
 131         }
 132         foreach ($value as $key=>&$job) {
 133             $ls = true;
 134             $this->geocodeAddress($job['w_adr'], $s);
 135             $ls = ($ls && $s);
 136             $this->cleanJob($page, $key, $job, $s);
 137             $ls = ($ls && $s);
 138             if (!$init) {
 139                 $success = ($success && $ls);
 140             }
 141         }
 142         return $value;
 143     }
 144
 145     public function save(ProfilePage &$page, $field, $value)
 146     {
 147         require_once('profil.func.inc.php');
 148         require_once('validations.inc.php');
 149
 150         XDB::execute("DELETE FROM  profile_job
 151                             WHERE  uid = {?}",
 152                      S::i('uid'));
 153         XDB::execute("DELETE FROM  profile_phones
 154                             WHERE  uid = {?} AND link_type = 'pro'",
 155                      S::i('uid'));
 156         foreach ($value as $id=>&$job) {
 157             if ($job['w_email'] == "new@example.org") {
 158                 $job['w_email'] = $job['w_email_new'];
 159             }
 160             if ($job['jobid']) {
 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']);
 166             } else {
 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']);
 172             }
 173             $profiletel = new ProfilePhones('pro', $id);
 174             $profiletel->saveTels('tel', $job['w_tel']);
 175         }
 176     }
 177 }
 178
 179 class ProfileJobs extends ProfilePage
 180 {
 181     protected $pg_template = 'profile/jobs.tpl';
 182
 183     public function __construct(PlWizard &$wiz)
 184     {
 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);
 190     }
 191
 192     protected function _fetchData()
 193     {
 194         // Checkout the CV
 195         $res = XDB::query("SELECT  cv
 196                              FROM  auth_user_md5
 197                             WHERE  user_id = {?}",
 198                           S::i('uid'));
 199         $this->values['cv'] = $res->fetchOneCell();
 200
 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
 204                              FROM  profile_corps
 205                             WHERE  uid = {?}",
 206                           S::i('uid'));
 207         $this->values['corps'] = $res->fetchOneAssoc();
 208
 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, gc.countryFR, pa.accuracy,
 214                                      j.email, j.url, j.pub,
 215                                      e.adr_pub, j.email_pub,
 216                                      e.glat, e.glng, s.name
 217                                FROM  profile_job                   AS j
 218                           LEFT JOIN  profile_job_enum              AS je ON (j.jobid = je.id)
 219                           LEFT JOIN  entreprises                   AS e  ON (j.uid = e.uid AND j.id = e.entrid)
 220                           LEFT JOIN  geoloc_countries              AS gc ON (gc.iso_3166_1_a2 = e.country)
 221                           LEFT JOIN  profile_job_subsubsector_enum AS s  ON (s.id = j.subsubsectorid)
 222                               WHERE  j.uid = {?}
 223                            ORDER BY  entrid", S::i('uid'));
 224         $this->values['jobs'] = array();
 225         while (list($id, $name, $function, $secteur, $ss_secteur, $sss_secteur, $description,
 226                     $w_adr1, $w_adr2, $w_adr3, $w_postcode, $w_city, $w_cityid,
 227                     $w_region, $w_regiontxt, $w_country, $w_countrytxt,
 228                     $w_checked, $w_email, $w_web,
 229                     $pub, $w_adr_pub, $w_email_pub, $w_glat, $w_glng, $sss_secteur_name
 230                    ) = $res->next()) {
 231             $this->values['jobs'][] = array('id'               => $id,
 232                                             'name'             => $name,
 233                                             'fonction'         => $function,
 234                                             'secteur'          => $secteur,
 235                                             'ss_secteur'       => $ss_secteur,
 236                                             'sss_secteur'      => $sss_secteur,
 237                                             'sss_secteur_name' => $sss_secteur_name,
 238                                             'description'      => $description,
 239                                             'w_adr'            => array('adr1'        => $w_adr1,
 240                                                                         'adr2'        => $w_adr2,
 241                                                                         'adr3'        => $w_adr3,
 242                                                                         'postcode'    => $w_postcode,
 243                                                                         'city'        => $w_city,
 244                                                                         'cityid'      => $w_cityid,
 245                                                                         'region'      => $w_region,
 246                                                                         'regiontxt'   => $w_regiontxt,
 247                                                                         'country'     => $w_country,
 248                                                                         'countrytxt'  => $w_countrytxt,
 249                                                                         'pub'         => $w_adr_pub,
 250                                                                         'checked'     => (($w_checked == 0)? true : false),
 251                                                                         'precise_lat' => $w_glat,
 252                                                                         'precise_lon' => $w_glng),
 253                                             'w_email'          => $w_email,
 254                                             'w_web'            => $w_web,
 255                                             'pub'              => $pub,
 256                                             'w_email_pub'      => $w_email_pub);
 257         }
 258
 259         $res = XDB::iterator("SELECT  link_id AS jobid, tel_type AS type, pub, display_tel AS tel, comment
 260                                 FROM  profile_phones
 261                                WHERE  uid = {?} AND link_type = 'pro'
 262                             ORDER BY  link_id",
 263                              S::i('uid'));
 264         $i = 0;
 265         $jobNb = count($this->values['jobs']);
 266         while ($tel = $res->next()) {
 267             $jobid = $tel['jobid'];
 268             unset($tel['jobid']);
 269             while ($i < $jobNb && $this->values['jobs'][$i]['id'] < $jobid) {
 270                 $i++;
 271             }
 272             if ($i >= $jobNb) {
 273                 break;
 274             }
 275             $job =& $this->values['jobs'][$i];
 276             if (!isset($job['w_tel'])) {
 277                 $job['w_tel'] = array();
 278             }
 279             if ($job['id'] == $jobid) {
 280                 $job['w_tel'][] = $tel;
 281             }
 282         }
 283         foreach ($this->values['jobs'] as $id=>&$job) {
 284             if (!isset($job['w_tel'])) {
 285                 $job['w_tel'] = array();
 286             }
 287             unset($job['id']);
 288         }
 289     }
 290
 291     protected function _saveData()
 292     {
 293         if ($this->changed['cv']) {
 294             XDB::execute("UPDATE  auth_user_md5
 295                              SET  cv = {?}
 296                            WHERE  user_id = {?}",
 297                          $this->values['cv'], S::i('uid'));
 298         }
 299
 300         if ($this->changed['corps']) {
 301             XDB::execute("UPDATE  profile_corps
 302                              SET  original_corpsid = {?}, current_corpsid = {?},
 303                                   rankid = {?}, corps_pub = {?}
 304                            WHERE  uid = {?}",
 305                           $this->values['corps']['original'], $this->values['corps']['current'],
 306                           $this->values['corps']['rank'], $this->values['corps']['pub'], S::i('uid'));
 307         }
 308     }
 309
 310     public function _prepare(PlPage &$page, $id)
 311     {
 312         require_once "emails.combobox.inc.php";
 313         fill_email_combobox($page);
 314
 315         $res = XDB::query("SELECT  id, name AS label
 316                              FROM  profile_job_sector_enum");
 317         $page->assign('secteurs', $res->fetchAllAssoc());
 318         $res = XDB::query("SELECT  id, fonction_fr, FIND_IN_SET('titre', flags) AS title
 319                              FROM  fonctions_def
 320                          ORDER BY  id");
 321         $page->assign('fonctions', $res->fetchAllAssoc());
 322
 323         $res = XDB::iterator("SELECT  id, name
 324                                 FROM  profile_corps_enum
 325                             ORDER BY  id = 1 DESC, name");
 326         $page->assign('original_corps', $res->fetchAllAssoc());
 327
 328         $res = XDB::iterator("SELECT  id, name
 329                                 FROM  profile_corps_enum
 330                                WHERE  still_exists = 1
 331                             ORDER BY  id = 1 DESC, name");
 332         $page->assign('current_corps', $res->fetchAllAssoc());
 333
 334         $res = XDB::iterator("SELECT  id, name
 335                                 FROM  profile_corps_rank_enum");
 336         $page->assign('corps_rank', $res->fetchAllAssoc());
 337     }
 338 }
 339
 340 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 341 ?>