1 | <?php |
---|
2 | |
---|
3 | if (!defined('ROOTPATH')) |
---|
4 | define('ROOTPATH', dirname(__FILE__) . '/..'); |
---|
5 | |
---|
6 | require_once(ROOTPATH . '/rest/hypermedia/hypermedia.php'); |
---|
7 | |
---|
8 | use prototype\api\Config as Config; |
---|
9 | |
---|
10 | class DynamicContactsResource extends Resource { |
---|
11 | |
---|
12 | /** |
---|
13 | * Retorna uma lista de contatos recentes |
---|
14 | * |
---|
15 | * @license http://www.gnu.org/copyleft/gpl.html GPL |
---|
16 | * @author Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br) |
---|
17 | * @sponsor Caixa Econômica Federal |
---|
18 | * @author José Vicente Tezza Jr. |
---|
19 | * @return Retorna uma lista de contatos recentes |
---|
20 | * @access public |
---|
21 | * */ |
---|
22 | function get($request) { |
---|
23 | |
---|
24 | $this->secured(); |
---|
25 | |
---|
26 | $response = new Response($request); |
---|
27 | $response->addHeader('Content-type', 'aplication/json'); |
---|
28 | $response->code = Response::OK; |
---|
29 | |
---|
30 | $h = new Hypermedia(); |
---|
31 | $c = new Collection($request->resources, 'DynamicContactsResource'); |
---|
32 | |
---|
33 | try { |
---|
34 | |
---|
35 | $dynamicContacts = Controller::find( |
---|
36 | array('concept' => 'dynamicContact'), false, array('filter' => array('=', 'owner', Config::me("uidNumber")), |
---|
37 | 'order' => array('number_of_messages', 'name', 'mail'), |
---|
38 | 'orderDesc' => array(true, false, false)) |
---|
39 | ); |
---|
40 | |
---|
41 | //Se nao foi encontrado contatos na consulta |
---|
42 | if (!$dynamicContacts) { |
---|
43 | $this->createException($request, $response, Response::NOTFOUND, 'Bad request', 'Dynamic Contact not found.'); |
---|
44 | return $response; |
---|
45 | } |
---|
46 | |
---|
47 | foreach ($dynamicContacts as $value) { |
---|
48 | $d = new Data(); |
---|
49 | $i = new Item($request->resources, 'DynamicContactsResource', $value['id']); |
---|
50 | |
---|
51 | $d->setName('name'); |
---|
52 | $d->setValue($value['name']); |
---|
53 | $d->setPrompt('Nome do Contato Recente'); |
---|
54 | $d->setDataType('string'); |
---|
55 | $d->setMaxLength('100'); |
---|
56 | $d->setMinLength(null); |
---|
57 | $d->setRequired(true); |
---|
58 | |
---|
59 | $i->addData($d); |
---|
60 | |
---|
61 | $d = new Data(); |
---|
62 | $d->setName('mail'); |
---|
63 | $d->setValue($value['mail']); |
---|
64 | $d->setPrompt('Email do Contato Recente'); |
---|
65 | $d->setDataType('string'); |
---|
66 | $d->setMaxLength('100'); |
---|
67 | $d->setMinLength(null); |
---|
68 | $d->setRequired(true); |
---|
69 | |
---|
70 | $i->addData($d); |
---|
71 | |
---|
72 | $d = new Data(); |
---|
73 | $d->setName('number_of_messages'); |
---|
74 | $d->setValue($value['number_of_messages']); |
---|
75 | $d->setPrompt('Quantidade de mensagens enviadas'); |
---|
76 | $d->setDataType('integer'); |
---|
77 | $d->setMaxLength('100'); |
---|
78 | $d->setMinLength(null); |
---|
79 | $d->setRequired(false); |
---|
80 | |
---|
81 | $i->addData($d); |
---|
82 | |
---|
83 | $d = new Data(); |
---|
84 | $d->setName('id'); |
---|
85 | $d->setValue($value['id']); |
---|
86 | $d->setPrompt('Id do contato dinamico'); |
---|
87 | $d->setDataType('integer'); |
---|
88 | $d->setMaxLength('100'); |
---|
89 | $d->setMinLength(null); |
---|
90 | $d->setRequired(false); |
---|
91 | |
---|
92 | $i->addData($d); |
---|
93 | |
---|
94 | $l = new Link(); |
---|
95 | |
---|
96 | $l->setHref(''); |
---|
97 | $l->setRel('delete'); |
---|
98 | $l->setAlt('Remover'); |
---|
99 | $l->setPrompt('Remover'); |
---|
100 | $l->setRender('link'); |
---|
101 | |
---|
102 | $i->addLink($l); |
---|
103 | |
---|
104 | $l = new Link(); |
---|
105 | $l->setHref(''); |
---|
106 | $l->setRel('put'); |
---|
107 | $l->setAlt('Atualizar'); |
---|
108 | $l->setPrompt('Atualizar'); |
---|
109 | $l->setRender('link'); |
---|
110 | |
---|
111 | $i->addLink($l); |
---|
112 | |
---|
113 | $l = new Link(); |
---|
114 | $l->setHref('/dynamiccontact/' . $value['id']); |
---|
115 | $l->setRel('get'); |
---|
116 | $l->setAlt('Buscar'); |
---|
117 | $l->setPrompt('Buscar'); |
---|
118 | $l->setRender('link'); |
---|
119 | |
---|
120 | $i->addLink($l); |
---|
121 | $c->addItem($i); |
---|
122 | } |
---|
123 | |
---|
124 | $t = new Template(); |
---|
125 | $d = new Data(); |
---|
126 | |
---|
127 | $d->setName('name'); |
---|
128 | $d->setValue(null); |
---|
129 | $d->setPrompt('Nome do Contato Recente'); |
---|
130 | $d->setDataType('string'); |
---|
131 | $d->setMaxLength(100); |
---|
132 | $d->setMinLength(null); |
---|
133 | $d->setRequired(false); |
---|
134 | |
---|
135 | $t->addData($d); |
---|
136 | |
---|
137 | $d = new Data(); |
---|
138 | $d->setName('mail'); |
---|
139 | $d->setValue(null); |
---|
140 | $d->setPrompt('Email do Contato Recente'); |
---|
141 | $d->setDataType('string'); |
---|
142 | $d->setMaxLength(100); |
---|
143 | $d->setMinLength(null); |
---|
144 | $d->setRequired(true); |
---|
145 | |
---|
146 | $t->addData($d); |
---|
147 | |
---|
148 | $d = new Data(); |
---|
149 | $d->setName('number_of_messages'); |
---|
150 | $d->setValue(null); |
---|
151 | $d->setPrompt('Quantidade de mensagens enviadas'); |
---|
152 | $d->setDataType('integer'); |
---|
153 | $d->setMaxLength(100); |
---|
154 | $d->setMinLength(null); |
---|
155 | $d->setRequired(false); |
---|
156 | |
---|
157 | $t->addData($d); |
---|
158 | |
---|
159 | $c->setTemplate($t); |
---|
160 | |
---|
161 | $h->setCollection($c); |
---|
162 | } catch (Exception $ex) { |
---|
163 | $this->createException($request, $response, Response::INTERNALSERVERERROR, 'Internal Server Error', $ex); |
---|
164 | return $response; |
---|
165 | } |
---|
166 | |
---|
167 | $response->body = $h->getHypermedia($request->accept[10][0]); |
---|
168 | return $response; |
---|
169 | } |
---|
170 | |
---|
171 | /** |
---|
172 | * Salva um contato recente |
---|
173 | * |
---|
174 | * @license http://www.gnu.org/copyleft/gpl.html GPL |
---|
175 | * @author Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br) |
---|
176 | * @sponsor Caixa Econômica Federal |
---|
177 | * @author José Vicente Tezza Jr. |
---|
178 | * @return retorna a uri do contato recente |
---|
179 | * @access public |
---|
180 | * */ |
---|
181 | function post($request) { |
---|
182 | |
---|
183 | $this->secured(); |
---|
184 | |
---|
185 | //verificar se a preferencia de contatos dinamicos nao esta ativada |
---|
186 | if(!$this->isEnabledDynamicContacts(Config::me("uidNumber")) ){ |
---|
187 | $response = new Response($request); |
---|
188 | $this->createException($request, $response, Response::UNAUTHORIZED, 'Resource unauthorized', 'disabled dynamic contacts preference'); |
---|
189 | return $response; |
---|
190 | } |
---|
191 | |
---|
192 | |
---|
193 | if (count($_POST) == 0) { |
---|
194 | $response = new Response($request); |
---|
195 | $response->code = Response::INTERNALSERVERERROR; |
---|
196 | return $response; |
---|
197 | } |
---|
198 | |
---|
199 | //recuperar os atributos definidos no conceito 'user' |
---|
200 | $map = Config::get('dynamicContact', 'PostgreSQL.mapping'); |
---|
201 | |
---|
202 | $params = array(); |
---|
203 | foreach ($_POST as $key => $value) { |
---|
204 | |
---|
205 | if (!isset($map[$key]) || $key == 'id' || $key == 'timestamp' || $key == 'number_of_messages') { |
---|
206 | continue; |
---|
207 | } |
---|
208 | $params[$key] = $value; |
---|
209 | } |
---|
210 | |
---|
211 | if (count($params) == 0) { |
---|
212 | $response = new Response($request); |
---|
213 | $response->code = Response::INTERNALSERVERERROR; |
---|
214 | return $response; |
---|
215 | } |
---|
216 | |
---|
217 | $response = new Response($request); |
---|
218 | $response->addHeader('Content-type', 'aplication/json'); |
---|
219 | $response->code = Response::CREATED; |
---|
220 | |
---|
221 | |
---|
222 | //completar os atributos |
---|
223 | $params['owner'] = Config::me("uidNumber"); |
---|
224 | $params['number_of_messages'] = '1'; |
---|
225 | $params['timestamp'] = time(); |
---|
226 | |
---|
227 | |
---|
228 | try { |
---|
229 | |
---|
230 | //verificar o limite maximo de contatos dinamicos nas preferencias do administrador |
---|
231 | $sql = "SELECT config_value ". |
---|
232 | "FROM phpgw_config ". |
---|
233 | "WHERE config_app = 'expressoMail1_2' ". |
---|
234 | "AND config_name = 'expressoMail_Number_of_dynamic_contacts'"; |
---|
235 | |
---|
236 | $numberOfMessages = Controller::service('PostgreSQL')->execResultSql($sql, true); |
---|
237 | $numberOfMessages = (count($numberOfMessages) > 0) ? (int)$numberOfMessages['config_value'] : 0; |
---|
238 | |
---|
239 | //realizar busca de contatos dinamicos ordenados pela data de utilizacao |
---|
240 | $dynamicContacts = Controller::find(array('concept' => 'dynamicContact'), false, array('filter' => array('=', 'owner', Config::me("uidNumber")), 'order' => array('timestamp') ) ); |
---|
241 | $numberOfDynamicContacts = ($dynamicContacts !== false) ? count($dynamicContacts) : 0; |
---|
242 | |
---|
243 | |
---|
244 | //se a quantidade de contatos dinamicos de usuario exceder o limite maximo definido nas preferencias do administrador, |
---|
245 | //remover o contato dinamico mais antigo |
---|
246 | if($numberOfMessages > 0 && $numberOfDynamicContacts >= $numberOfMessages){ |
---|
247 | $id = $dynamicContacts[0]['id']; |
---|
248 | $delete = Controller::delete(array('concept' => 'dynamicContact', 'id' => $id)); |
---|
249 | |
---|
250 | if (!$delete) { |
---|
251 | $this->createException($request, $response, Response::INTERNALSERVERERROR, 'Internal Server Error', Controller::service('PostgreSQL')->error); |
---|
252 | return $response; |
---|
253 | } |
---|
254 | } |
---|
255 | |
---|
256 | //inserir o novo contato dinamico |
---|
257 | $create = Controller::create( array('concept' => 'dynamicContact'), $params ); |
---|
258 | |
---|
259 | if (!$create) { |
---|
260 | throw new Exception(Controller::service('PostgreSQL')->error); |
---|
261 | } |
---|
262 | |
---|
263 | } catch (Exception $ex) { |
---|
264 | |
---|
265 | $response->code = Response::INTERNALSERVERERROR; |
---|
266 | return $response; |
---|
267 | } |
---|
268 | $response->body = json_encode(null); |
---|
269 | |
---|
270 | return $response; |
---|
271 | } |
---|
272 | |
---|
273 | private function createException($request, &$response, $code, $title, $description) { |
---|
274 | $response->code = $code; |
---|
275 | |
---|
276 | $h = new Hypermedia(); |
---|
277 | $c = new Collection($request->resources, 'DynamicContactResource'); |
---|
278 | $e = new Error(); |
---|
279 | |
---|
280 | $e->setCode($code); |
---|
281 | $e->setTitle($title); |
---|
282 | $e->setDescription($description); |
---|
283 | |
---|
284 | $c->setError($e); |
---|
285 | $h->setCollection($c); |
---|
286 | |
---|
287 | $response->body = $h->getHypermedia($request->accept[10][0]); |
---|
288 | } |
---|
289 | |
---|
290 | private function isEnabledDynamicContacts($user){ |
---|
291 | |
---|
292 | $sql = 'SELECT preference_value '. |
---|
293 | 'FROM phpgw_preferences '. |
---|
294 | 'WHERE preference_app = \'expressoMail\' AND '. |
---|
295 | 'preference_owner = ' . $user; |
---|
296 | |
---|
297 | $preference = Controller::service('PostgreSQL')->execResultSql($sql, true); |
---|
298 | |
---|
299 | if(count($preference) > 0 && isset($preference['preference_value'])){ |
---|
300 | $preference = unserialize( $preference['preference_value'] ); |
---|
301 | |
---|
302 | if(isset($preference['use_dynamic_contacts'])){ |
---|
303 | $preference = $preference['use_dynamic_contacts']; |
---|
304 | return ($preference == '1'); |
---|
305 | } |
---|
306 | } |
---|
307 | return false; |
---|
308 | } |
---|
309 | |
---|
310 | } |
---|
311 | |
---|
312 | ?> |
---|