include/validations/entreprises.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 EntrReq
  23
  24 class EntrReq extends Validate
  25 {
  26     // {{{ properties
  27
  28     public $id;
  29     public $name;
  30     public $acronym;
  31     public $url;
  32     public $email;
  33     public $holdingid;
  34     public $NAF_code;
  35     public $AX_code;
  36
  37     public $tel;
  38     public $fax;
  39
  40     public $suggestions;
  41     //TODO: addresses
  42
  43     // }}}
  44     // {{{ constructor
  45
  46     public function __construct(User &$_user, $_id, $_name, $_acronym, $_url, $_email, $_tel, $_fax, $_stamp = 0)
  47     {
  48         parent::__construct($_user, false, 'entreprise', $_stamp);
  49         $this->id       = $_id;
  50         $this->name     = $_name;
  51         $this->acronym  = $_acronym;
  52         $this->url      = $_url;
  53         $this->email    = $_email;
  54         $this->tel      = $_tel;
  55         $this->fax      = $_fax;
  56
  57         $_name       = preg_replace('/[^0-9a-z]/i', ' ', strtolower(replace_accent($_name)));
  58         $name        = explode(" ", $_name);
  59         $name_array  = array_map("trim", $name);
  60         $length      = count($name_array);
  61         $where       = "";
  62         for ($i = 0; $i < $length; $i++) {
  63             if (strlen($name_array[$i]) > 2) {
  64                 if ($where !== "") {
  65                     $where .= " OR ";
  66                 }
  67                 $where .= "name LIKE '%" . $name_array[$i] . "%'";
  68             }
  69         }
  70         $res = XDB::iterator("SELECT  name
  71                              FROM  profile_job_enum
  72                             WHERE  "
  73                           . $where);
  74         $this->suggestions = "| ";
  75         while ($sug = $res->next()) {
  76             $this->suggestions .= $sug['name'] . " | ";
  77         }
  78     }
  79
  80     // }}}
  81     // {{{ function formu()
  82
  83     public function formu()
  84     {
  85         return 'include/form.valid.entreprises.tpl';
  86     }
  87
  88     // }}}
  89     // {{{ function editor()
  90
  91     public function editor()
  92     {
  93         return 'include/form.valid.edit-entreprises.tpl';
  94     }
  95
  96     // }}}
  97     // {{{ function handle_editor()
  98
  99     protected function handle_editor()
 100     {
 101         if (Env::has('holdingid')) {
 102             $this->holdingid = trim(Env::v('holdingid'));
 103         }
 104         if (Env::has('name')) {
 105             $this->name = trim(Env::v('name'));
 106             if (Env::has('acronym')) {
 107                 $this->acronym = trim(Env::v('acronym'));
 108                 if (Env::has('url')) {
 109                     $this->url = trim(Env::v('url'));
 110                     if (Env::has('NAF_code')) {
 111                         $this->NAF_code = trim(Env::v('NAF_code'));
 112                         if (Env::has('AX_code')) {
 113                             $this->AX_code = trim(Env::v('AX_code'));
 114                             return true;
 115                         }
 116                     }
 117                 }
 118             }
 119         }
 120         return false;
 121     }
 122
 123     // }}}
 124     // {{{ function _mail_subj
 125
 126     protected function _mail_subj()
 127     {
 128         return "[Polytechnique.org/Entreprises] Demande d'ajout d'une entreprise : " . $this->name;
 129     }
 130
 131     // }}}
 132     // {{{ function _mail_body
 133
 134     protected function _mail_body($isok)
 135     {
 136         if ($isok) {
 137             return "  L'entreprise " . $this->name . " vient d'être ajoutée à ta fiche.";
 138         } else {
 139             return "  La demande que tu avais faite pour l'entreprise " . $this->name .
 140                    " a été refusée, car elle figure déjà dans notre base.";
 141         }
 142     }
 143
 144     // }}}
 145     // {{{ function commit()
 146
 147     public function commit()
 148     {
 149         $res = XDB::query('SELECT  id
 150                              FROM  profile_job_enum
 151                             WHERE  name = {?}',
 152                           $this->name);
 153         if ($res->numRows() != 1) {
 154             require_once("profil.func.inc.php");
 155
 156             XDB::execute('INSERT INTO  profile_job_enum (name, acronym, url, email, holdingid, NAF_code, AX_code)
 157                                VALUES  ({?}, {?}, {?}, {?}, {?}, {?}, {?})',
 158                          $this->name, $this->acronym, $this->url, $this->email,
 159                          $this->holdingid, $this->NAF_code, $this->AX_code);
 160             $jobid = XDB::insertId();
 161             $display_tel = format_display_number($this->tel, $error_tel);
 162             $display_fax =format_display_number($this->fax, $error_fax);
 163             XDB::execute('INSERT INTO  profile_phones (uid, link_type, link_id, tel_id, tel_type,
 164                                        search_tel, display_tel, pub)
 165                                VALUES  ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}),
 166                                        ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
 167                          $jobid, 'hq', $this->id, 0, 'fixed', format_phone_number($this->tel), $display_tel, 'public',
 168                          $jobid, 'hq', $this->id, 1, 'fax', format_phone_number($this->fax), $display_fax, 'public');
 169         } else {
 170             $jobid = $res->fetchOneCell();
 171             $success = true;
 172         }
 173         return XDB::execute('UPDATE  profile_job
 174                                 SET  jobid = {?}
 175                               WHERE  uid = {?} AND id = {?}',
 176                             $jobid, $this->user->id(), $this->id);
 177     }
 178
 179     // }}}
 180 }
 181
 182 // }}}
 183
 184 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 185 ?>