2 /***************************************************************************
3 * Copyright (C) 2003-2008 Polytechnique.org *
4 * http://opensource.polytechnique.org/ *
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. *
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. *
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 *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
24 class EntrReq
extends Validate
46 public function __construct(User
&$_user, $_id, $_name, $_acronym, $_url, $_email, $_tel, $_fax, $_stamp = 0)
48 parent
::__construct($_user, false
, 'entreprise', $_stamp);
51 $this->acronym
= $_acronym;
53 $this->email
= $_email;
57 $_name = str_replace(array("&", "(", ")", "-", "_", ",", ";", ".", ":", "/", "\\", "\'", "\""), " ", $_name);
58 $name = explode(" ", $_name);
59 $name_array = array_map("trim", $name);
60 $length = count($name_array);
62 for ($i = 0; $i < $length; $i++
) {
63 if (strlen($name_array[$i]) > 2) {
67 $where .= "name LIKE '%" . $name_array[$i] . "%'";
70 $res = XDB
::iterator("SELECT name
74 $this->suggestions
= "| ";
75 while ($sug = $res->next()) {
77 $this->suggestions
.= $sug['name'] . " | ";
82 // {{{ function formu()
84 public function formu()
86 return 'include/form.valid.entreprises.tpl';
90 // {{{ function editor()
92 public function editor()
94 return 'include/form.valid.edit-entreprises.tpl';
98 // {{{ function handle_editor()
100 protected function handle_editor()
102 if (Env
::has('holdingid')) {
103 $this->holdingid
= trim(Env
::v('holdingid'));
105 if (Env
::has('name')) {
106 $this->name
= trim(Env
::v('name'));
107 if (Env
::has('acronym')) {
108 $this->acronym
= trim(Env
::v('acronym'));
109 if (Env
::has('url')) {
110 $this->url
= trim(Env
::v('url'));
111 if (Env
::has('NAF_code')) {
112 $this->NAF_code
= trim(Env
::v('NAF_code'));
113 if (Env
::has('AX_code')) {
114 $this->AX_code
= trim(Env
::v('AX_code'));
125 // {{{ function _mail_subj
127 protected function _mail_subj()
129 return "[Polytechnique.org/Entreprises] Demande d'ajout d'une entreprise : " . $this->name
;
133 // {{{ function _mail_body
135 protected function _mail_body($isok)
138 return " L'entreprise " . $this->name
. " vient d'être ajoutée à ta fiche.";
140 return " La demande que tu avais faite pour l'entreprise " . $this->name
.
141 " a été refusée, car elle figure déjà dans notre base.";
146 // {{{ function commit()
148 public function commit()
150 $res = XDB
::query('SELECT id
151 FROM profile_job_enum
154 if ($res->numRows() != 1) {
155 require_once("profil.func.inc.php");
157 XDB
::execute('INSERT INTO profile_job_enum (name, acronym, url, email, holdingid, NAF_code, AX_code)
158 VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?})',
159 $this->name
, $this->acronym
, $this->url
, $this->email
,
160 $this->holdingid
, $this->NAF_code
, $this->AX_code
);
161 $jobid = XDB
::insertId();
162 $display_tel = format_display_number($this->tel
, $error_tel);
163 $display_fax =format_display_number($this->fax
, $error_fax);
164 XDB
::execute('INSERT INTO profile_phones (uid, link_type, link_id, tel_id, tel_type,
165 search_tel, display_tel, pub)
166 VALUES ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?}),
167 ({?}, {?}, {?}, {?}, {?}, {?}, {?}, {?})',
168 $jobid, 'hq', $this->id
, 0, 'fixed', format_phone_number($this->tel
), $display_tel, 'public',
169 $jobid, 'hq', $this->id
, 1, 'fax', format_phone_number($this->fax
), $display_fax, 'public');
171 $jobid = $res->fetchOneCell();
174 return XDB
::execute('UPDATE profile_job
176 WHERE uid = {?} AND id = {?}',
177 $jobid, $this->user
->id(), $this->id
);
185 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: