modules/profile/jobs.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2010 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 ProfileSettingJob implements ProfileSetting
  23 {
  24     private $pub;
  25     private $email_new;
  26     private $email;
  27     private $url;
  28     private $bool;
  29     private $checks;
  30
  31     public function __construct()
  32     {
  33         $this->pub    = new ProfileSettingPub();
  34         $this->email
  35                       = $this->email_new
  36                       = new ProfileSettingEmail();
  37         $this->url    = new ProfileSettingWeb();
  38         $this->bool   = new ProfileSettingBool();
  39         $this->checks = array('url'      => array('w_url'),
  40                               'email'    => array('w_email'),
  41                               'pub'      => array('pub', 'w_email_pub'),
  42                              );
  43     }
  44
  45     public function emptyJob()
  46     {
  47         $address = new Address();
  48         return array(
  49             'id'               => '0',
  50             'jobid'            => '',
  51             'pub'              => 'private',
  52             'name'             => '',
  53             'description'      => '',
  54             'w_url'            => '',
  55             'w_address'        => $address->toFormArray(),
  56             'w_email'          => '',
  57             'w_email_pub'      => 'private',
  58             'w_email_new'      => '',
  59             'w_phone'          => array(0 => array(
  60                 'type'    => 'fixed',
  61                 'tel'     => '',
  62                 'pub'     => 'private',
  63                 'comment' => '',
  64             ),
  65             'terms'            => array()),
  66         );
  67     }
  68
  69     private function cleanJob(ProfilePage &$page, $jobid, array &$job, &$success)
  70     {
  71         if ($job['w_email'] == "new@example.org") {
  72             $job['w_email'] = $job['w_email_new'];
  73         }
  74         foreach ($this->checks as $obj=>&$fields) {
  75             $chk =& $this->$obj;
  76             foreach ($fields as $field) {
  77                 $job[$field] = $chk->value($page, $field, $job[$field], $s);
  78                 if (!$s) {
  79                     $success = false;
  80                     $job[$field . '_error'] = true;
  81                 }
  82             }
  83         }
  84         if (count($job['terms'])) {
  85             $termsid = array();
  86             foreach ($job['terms'] as $term) {
  87                 if (!$term['full_name']) {
  88                     $termsid[] = $term['jtid'];
  89                 }
  90             }
  91             if (count($termsid)) {
  92                 $res = XDB::query("SELECT  jtid, full_name
  93                                     FROM  profile_job_term_enum
  94                                    WHERE  jtid IN {?}",
  95                                  $termsid);
  96                 $term_id_to_name = $res->fetchAllAssoc('jtid', false);
  97                 foreach ($job['terms'] as &$term) {
  98                     if (!$term['full_name']) {
  99                         $term['full_name'] = $term_id_to_name[$term['jtid']];
 100                     }
 101                 }
 102             }
 103         }
 104         if ($job['name']) {
 105             $res = XDB::query("SELECT  id
 106                                  FROM  profile_job_enum
 107                                 WHERE  name = {?}",
 108                               $job['name']);
 109             if ($res->numRows() != 1) {
 110                 $req = new EntrReq(S::user(), $page->profile, $jobid, $job['name'], $job['hq_acronym'], $job['hq_url'],
 111                                    $job['hq_email'], $job['hq_fixed'], $job['hq_fax'], $job['hq_address']);
 112                 $req->submit();
 113                 $job['jobid'] = null;
 114                 sleep(1);
 115             } else {
 116                 $job['jobid'] = $res->fetchOneCell();
 117             }
 118         }
 119         $job['w_phone'] = Phone::formatFormArray($job['w_phone'], $s);
 120
 121         unset($job['removed']);
 122         unset($job['new']);
 123     }
 124
 125     public function value(ProfilePage &$page, $field, $value, &$success)
 126     {
 127         require_once 'validations.inc.php';
 128         $entreprise = ProfileValidate::get_typed_requests($page->pid(), 'entreprise');
 129         $entr_val = 0;
 130
 131         $init = false;
 132         if (is_null($value)) {
 133             $value = $page->values['jobs'];
 134             $init = true;
 135         }
 136         $success = true;
 137         foreach ($value as $key => &$job) {
 138             $job['name'] = trim($job['name']);
 139             if ($job['name'] == '' && $entreprise) {
 140                 $job['tmp_name'] = $entreprise[$entr_val]->name;
 141                 ++$entr_val;
 142             } else if ($job['name'] == '') {
 143                 if ($job['description'] == '' && $job['w_url'] == ''
 144                     && $job['w_address']['text'] == '' && $job['w_email'] == ''
 145                     && count($job['w_phone']) == 1 && $job['w_phone']['tel'] == '') {
 146                     array_splice($value, $key, 1);
 147                     continue;
 148                 }
 149
 150                 if (!$init) {
 151                     $job['name_error'] = true;
 152                     $success = false;
 153                 }
 154             }
 155
 156             if (isset($job['removed']) && $job['removed']) {
 157                 if ($job['name'] == '' && $entreprise) {
 158                     $entreprise[$entr_val - 1]->clean();
 159                 }
 160                 array_splice($value, $key, 1);
 161             }
 162         }
 163         foreach ($value as $key => &$job) {
 164             $address = new Address($job['w_address']);
 165             $s = $address->format();
 166             $job['w_address'] = $address->toFormArray();
 167             $this->cleanJob($page, $key, $job, $s);
 168             if (!$init) {
 169                 $success = ($success && $s);
 170             }
 171         }
 172         return $value;
 173     }
 174
 175     public function save(ProfilePage &$page, $field, $value)
 176     {
 177         XDB::execute("DELETE FROM  profile_job
 178                             WHERE  pid = {?}",
 179                      $page->pid());
 180         Address::delete($page->pid(), Address::LINK_JOB);
 181         Phone::deletePhones($page->pid(), Phone::LINK_JOB);
 182         $terms_values = array();
 183         foreach ($value as $id => &$job) {
 184             if (isset($job['name']) && $job['name']) {
 185                 if (isset($job['jobid']) && $job['jobid']) {
 186                     XDB::execute('INSERT INTO  profile_job (pid, id, description, email, url, pub, email_pub, jobid)
 187                                        VALUES  ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
 188                                  $page->pid(), $id, $job['description'], $job['w_email'], $job['w_url'], $job['pub'], $job['w_email_pub'], $job['jobid']);
 189                 } else {
 190                     XDB::execute('INSERT INTO  profile_job (pid, id, description, email, url, pub, email_pub)
 191                                        VALUES  ({?}, {?}, {?}, {?}, {?}, {?}, {?})',
 192                                  $page->pid(), $id, $job['description'], $job['w_email'], $job['w_url'], $job['pub'], $job['w_email_pub']);
 193                 }
 194                 $address = new Address(array_merge($job['w_address'], array('pid' => $page->pid(), 'id' => $id, 'type' => Address::LINK_JOB)));
 195                 $address->save();
 196                 Phone::savePhones($job['w_phone'], $page->pid(), Phone::LINK_JOB, $id);
 197                 if (isset($job['terms'])) {
 198                     foreach ($job['terms'] as $term) {
 199                         $terms_values[] = '('.XDB::escape($page->pid()).', '. XDB::escape($id).', '.XDB::escape($term['jtid']).', "original")';
 200                     }
 201                 }
 202             }
 203         }
 204         if (count($terms_values) > 0) {
 205             XDB::execute('INSERT INTO  profile_job_term (pid, jid, jtid, computed)
 206                                VALUES  '.implode(', ', $terms_values));
 207         }
 208     }
 209
 210     public function getText($value) {
 211         $jobs = array();
 212         foreach ($value as $id => $job) {
 213             $address = Address::formArrayToString($job['w_address']);
 214             $phones = Phone::formArrayToString($job['w_phone']);
 215             // TODO: add jobterms here.
 216             $jobs[] = 'Entreprise : ' . $job['name']
 217                     . ', description : ' . $job['description'] . ', web : ' . $job['w_url']
 218                     . ', email : ' . $job['w_email']
 219                     . ($phones ? ', ' . $phones : '') . ($address ? ', ' . $address : '');
 220         }
 221         return implode(' ; ' , $jobs);
 222     }
 223 }
 224
 225 class ProfileSettingCorps implements ProfileSetting
 226 {
 227     public function value(ProfilePage &$page, $field, $value, &$success)
 228     {
 229         $success = true;
 230         if (is_null($value)) {
 231             $res = XDB::query("SELECT  original_corpsid AS original, current_corpsid AS current,
 232                                        rankid AS rank, corps_pub AS pub
 233                                  FROM  profile_corps
 234                                 WHERE  pid = {?}",
 235                             $page->pid());
 236             return $res->fetchOneAssoc();
 237         }
 238         return $value;
 239     }
 240
 241     public function save(ProfilePage &$page, $field, $value)
 242     {
 243         XDB::execute('REPLACE INTO  profile_corps (original_corpsid, current_corpsid, rankid, corps_pub, pid)
 244                             VALUES  ({?}, {?}, {?}, {?}, {?})',
 245                       $value['original'], $value['current'], $value['rank'], $value['pub'], $page->pid());
 246     }
 247
 248     public function getText($value)
 249     {
 250         $corpsList = DirEnum::getOptions(DirEnum::CORPS);
 251         $rankList  = DirEnum::getOptions(DirEnum::CORPSRANKS);
 252         return 'Corps actuel : ' . $corpsList[$value['current']] . ' , rang : ' . $corpsList[$value['rank']]
 253             . ' , corps d\'origine : ' . $corpsList[$value['original']] . ' , affichage : ' . $value['pub'];
 254     }
 255 }
 256
 257 class ProfileSettingJobs extends ProfilePage
 258 {
 259     protected $pg_template = 'profile/jobs.tpl';
 260
 261     public function __construct(PlWizard &$wiz)
 262     {
 263         parent::__construct($wiz);
 264         if (S::user()->checkPerms(User::PERM_DIRECTORY_PRIVATE)) {
 265             $this->settings['cv'] = null;
 266         }
 267         $this->settings['corps'] = new ProfileSettingCorps();
 268         $this->settings['jobs'] = new ProfileSettingJob();
 269         $this->watched = array('cv' => true, 'jobs' => true, 'corps' => true);
 270     }
 271
 272     protected function _fetchData()
 273     {
 274         if (S::user()->checkPerms(User::PERM_DIRECTORY_PRIVATE)) {
 275             // Checkout the CV
 276             $res = XDB::query("SELECT  cv
 277                                  FROM  profiles
 278                                 WHERE  pid = {?}",
 279                               $this->pid());
 280             $this->values['cv'] = $res->fetchOneCell();
 281         }
 282
 283         // Build the jobs tree
 284         $res = XDB::iterRow('SELECT  j.id, j.jobid, je.name, j.description, j.email, j.email_pub,
 285                                      j.url, j.pub
 286                                FROM  profile_job      AS j
 287                           LEFT JOIN  profile_job_enum AS je ON (j.jobid = je.id)
 288                               WHERE  j.pid = {?}
 289                            ORDER BY  j.id',
 290                             $this->pid());
 291         $this->values['jobs'] = array();
 292
 293         $compagnies = array();
 294         if ($res->numRows() > 0) {
 295             while (list($id, $jobid, $name, $description, $w_email, $w_emailPub, $w_url, $pub) = $res->next()) {
 296                 $compagnies[] = $jobid;
 297                 $this->values['jobs'][] = array(
 298                     'id'               => $id,
 299                     'jobid'            => $jobid,
 300                     'name'             => $name,
 301                     'description'      => $description,
 302                     'pub'              => $pub,
 303                     'w_email'          => $w_email,
 304                     'w_email_pub'      => $w_emailPub,
 305                     'w_url'            => $w_url,
 306                 );
 307             }
 308
 309             $it = Address::iterate(array($this->pid()), array(Address::LINK_JOB));
 310             while ($address = $it->next()) {
 311                 $this->values['jobs'][$address->jobid]['w_address'] = $address->toFormArray();
 312             }
 313             $it = Phone::iterate(array($this->pid()), array(Phone::LINK_JOB));
 314             while ($phone = $it->next()) {
 315                 $this->values['jobs'][$phone->linkId()]['w_phone'][$phone->id()] = $phone->toFormArray();
 316             }
 317             $res = XDB::iterator("SELECT  e.jtid, e.full_name, j.jid AS jobid
 318                                     FROM  profile_job_term_enum AS e
 319                               INNER JOIN  profile_job_term AS j USING(jtid)
 320                                    WHERE  pid = {?}
 321                                 ORDER BY  j.jid",
 322                                  $this->pid());
 323             $i = 0;
 324             $jobNb = count($this->values['jobs']);
 325             while ($term = $res->next()) {
 326                 $jobid = $term['jobid'];
 327                 while ($i < $jobNb && $this->values['jobs'][$i]['id'] < $jobid) {
 328                     $i++;
 329                 }
 330                 if ($i >= $jobNb) {
 331                     break;
 332                 }
 333                 $job =& $this->values['jobs'][$i];
 334                 if ($job['id'] != $jobid) {
 335                     continue;
 336                 }
 337                 if (!isset($job['terms'])) {
 338                     $job['terms'] = array();
 339                 }
 340                 $job['terms'][] = $term;
 341             }
 342
 343             $phone = new Phone();
 344             $address = new Address();
 345             foreach ($this->values['jobs'] as $id => &$job) {
 346                 if (!isset($job['w_phone'])) {
 347                     $job['w_phone'] = array(0 => $phone->toFormArray());
 348                 }
 349                 if (!isset($job['w_address'])) {
 350                     $job['w_address'] = $address->toFormArray();
 351                 }
 352             }
 353
 354             $job['w_email_new'] = '';
 355             if (!isset($job['w_email_pub'])) {
 356                 $job['w_email_pub'] = 'private';
 357             }
 358         } else {
 359             $this->values['jobs'][] = $this->settings['jobs']->emptyJob();
 360         }
 361     }
 362
 363     protected function _saveData()
 364     {
 365         if (S::user()->checkPerms(User::PERM_DIRECTORY_PRIVATE)) {
 366             if ($this->changed['cv']) {
 367                 XDB::execute("UPDATE  profiles
 368                                  SET  cv = {?}
 369                                WHERE  pid = {?}",
 370                              $this->values['cv'], $this->pid());
 371             }
 372         }
 373     }
 374
 375     public function _prepare(PlPage &$page, $id)
 376     {
 377         require_once 'emails.combobox.inc.php';
 378         fill_email_combobox($page, $this->owner);
 379
 380         $res = XDB::iterator("SELECT  id, name
 381                                 FROM  profile_corps_enum
 382                             ORDER BY  id = 1 DESC, name");
 383         $page->assign('original_corps', $res->fetchAllAssoc());
 384
 385         $res = XDB::iterator("SELECT  id, name
 386                                 FROM  profile_corps_enum
 387                                WHERE  still_exists = 1
 388                             ORDER BY  id = 1 DESC, name");
 389         $page->assign('current_corps', $res->fetchAllAssoc());
 390
 391         $res = XDB::iterator("SELECT  id, name
 392                                 FROM  profile_corps_rank_enum
 393                             ORDER BY  id = 1 DESC, name");
 394         $page->assign('corps_rank', $res->fetchAllAssoc());
 395     }
 396 }
 397
 398 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 399 ?>