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