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