[6473] | 1 | <?php |
---|
| 2 | |
---|
[6523] | 3 | if (!defined('ROOTPATH')) |
---|
| 4 | define('ROOTPATH', dirname(__FILE__) . '/..'); |
---|
[6473] | 5 | |
---|
[6523] | 6 | require_once(ROOTPATH . '/rest/hypermedia/hypermedia.php'); |
---|
[6473] | 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 | |
---|
[6523] | 24 | $this->secured(); |
---|
| 25 | |
---|
[6473] | 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 | |
---|
[6523] | 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)) |
---|
[6473] | 39 | ); |
---|
| 40 | |
---|
| 41 | //Se nao foi encontrado contatos na consulta |
---|
[6523] | 42 | if (!$dynamicContacts) { |
---|
| 43 | $this->createException($request, $response, Response::NOTFOUND, 'Bad request', 'Dynamic Contact not found.'); |
---|
[6473] | 44 | return $response; |
---|
| 45 | } |
---|
| 46 | |
---|
[6523] | 47 | foreach ($dynamicContacts as $value) { |
---|
[6473] | 48 | $d = new Data(); |
---|
[6523] | 49 | $i = new Item($request->resources, 'DynamicContactsResource', $value['id']); |
---|
[6473] | 50 | |
---|
| 51 | $d->setName('name'); |
---|
[6523] | 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); |
---|
[6473] | 58 | |
---|
[6523] | 59 | $i->addData($d); |
---|
[6473] | 60 | |
---|
| 61 | $d = new Data(); |
---|
[6523] | 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); |
---|
[6473] | 69 | |
---|
[6523] | 70 | $i->addData($d); |
---|
[6473] | 71 | |
---|
| 72 | $d = new Data(); |
---|
[6523] | 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); |
---|
[6473] | 80 | |
---|
[6523] | 81 | $i->addData($d); |
---|
[6473] | 82 | |
---|
[6523] | 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); |
---|
[6512] | 91 | |
---|
[6523] | 92 | $i->addData($d); |
---|
[6473] | 93 | |
---|
[6523] | 94 | $l = new Link(); |
---|
[6473] | 95 | |
---|
[6523] | 96 | $l->setHref(''); |
---|
| 97 | $l->setRel('delete'); |
---|
| 98 | $l->setAlt('Remover'); |
---|
| 99 | $l->setPrompt('Remover'); |
---|
| 100 | $l->setRender('link'); |
---|
[6473] | 101 | |
---|
[6523] | 102 | $i->addLink($l); |
---|
[6473] | 103 | |
---|
[6523] | 104 | $l = new Link(); |
---|
| 105 | $l->setHref(''); |
---|
| 106 | $l->setRel('put'); |
---|
| 107 | $l->setAlt('Atualizar'); |
---|
| 108 | $l->setPrompt('Atualizar'); |
---|
| 109 | $l->setRender('link'); |
---|
[6473] | 110 | |
---|
[6523] | 111 | $i->addLink($l); |
---|
[6473] | 112 | |
---|
[6523] | 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); |
---|
[6473] | 122 | } |
---|
| 123 | |
---|
[6523] | 124 | $t = new Template(); |
---|
| 125 | $d = new Data(); |
---|
[6473] | 126 | |
---|
[6523] | 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); |
---|
[6473] | 134 | |
---|
[6523] | 135 | $t->addData($d); |
---|
[6473] | 136 | |
---|
[6523] | 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); |
---|
[6473] | 145 | |
---|
[6523] | 146 | $t->addData($d); |
---|
[6473] | 147 | |
---|
[6523] | 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); |
---|
[6473] | 156 | |
---|
[6523] | 157 | $t->addData($d); |
---|
[6473] | 158 | |
---|
[6523] | 159 | $c->setTemplate($t); |
---|
[6473] | 160 | |
---|
[6523] | 161 | $h->setCollection($c); |
---|
| 162 | } catch (Exception $ex) { |
---|
| 163 | $this->createException($request, $response, Response::INTERNALSERVERERROR, 'Internal Server Error', $ex); |
---|
| 164 | return $response; |
---|
[6473] | 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 | * */ |
---|
[6523] | 181 | function post($request) { |
---|
[6473] | 182 | |
---|
[6523] | 183 | $this->secured(); |
---|
[6605] | 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 | |
---|
[6523] | 193 | if (count($_POST) == 0) { |
---|
| 194 | $response = new Response($request); |
---|
| 195 | $response->code = Response::INTERNALSERVERERROR; |
---|
| 196 | return $response; |
---|
[6473] | 197 | } |
---|
| 198 | |
---|
[6578] | 199 | //recuperar os atributos definidos no conceito 'user' |
---|
[6473] | 200 | $map = Config::get('dynamicContact', 'PostgreSQL.mapping'); |
---|
| 201 | |
---|
| 202 | $params = array(); |
---|
[6523] | 203 | foreach ($_POST as $key => $value) { |
---|
[6473] | 204 | |
---|
[6523] | 205 | if (!isset($map[$key]) || $key == 'id' || $key == 'timestamp' || $key == 'number_of_messages') { |
---|
| 206 | continue; |
---|
| 207 | } |
---|
| 208 | $params[$key] = $value; |
---|
[6473] | 209 | } |
---|
| 210 | |
---|
[6523] | 211 | if (count($params) == 0) { |
---|
| 212 | $response = new Response($request); |
---|
| 213 | $response->code = Response::INTERNALSERVERERROR; |
---|
| 214 | return $response; |
---|
[6473] | 215 | } |
---|
| 216 | |
---|
[6523] | 217 | $response = new Response($request); |
---|
| 218 | $response->addHeader('Content-type', 'aplication/json'); |
---|
| 219 | $response->code = Response::CREATED; |
---|
[6473] | 220 | |
---|
[6523] | 221 | |
---|
[6473] | 222 | //completar os atributos |
---|
[6523] | 223 | $params['owner'] = Config::me("uidNumber"); |
---|
| 224 | $params['number_of_messages'] = '1'; |
---|
| 225 | $params['timestamp'] = time(); |
---|
[6473] | 226 | |
---|
| 227 | |
---|
[6523] | 228 | try { |
---|
[6473] | 229 | |
---|
[6578] | 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 |
---|
[6605] | 246 | if($numberOfMessages > 0 && $numberOfDynamicContacts >= $numberOfMessages){ |
---|
[6578] | 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 | |
---|
[6523] | 263 | } catch (Exception $ex) { |
---|
[6578] | 264 | |
---|
[6523] | 265 | $response->code = Response::INTERNALSERVERERROR; |
---|
| 266 | return $response; |
---|
| 267 | } |
---|
| 268 | $response->body = json_encode(null); |
---|
[6473] | 269 | |
---|
[6523] | 270 | return $response; |
---|
| 271 | } |
---|
[6473] | 272 | |
---|
[6523] | 273 | private function createException($request, &$response, $code, $title, $description) { |
---|
| 274 | $response->code = $code; |
---|
[6473] | 275 | |
---|
[6523] | 276 | $h = new Hypermedia(); |
---|
| 277 | $c = new Collection($request->resources, 'DynamicContactResource'); |
---|
| 278 | $e = new Error(); |
---|
[6473] | 279 | |
---|
[6523] | 280 | $e->setCode($code); |
---|
| 281 | $e->setTitle($title); |
---|
| 282 | $e->setDescription($description); |
---|
[6473] | 283 | |
---|
[6523] | 284 | $c->setError($e); |
---|
| 285 | $h->setCollection($c); |
---|
| 286 | |
---|
| 287 | $response->body = $h->getHypermedia($request->accept[10][0]); |
---|
| 288 | } |
---|
| 289 | |
---|
[6605] | 290 | private function isEnabledDynamicContacts($user){ |
---|
| 291 | |
---|
[6783] | 292 | //recuperando as preferencias (suas preferencias, preferencia padrão, preferencia obrigatoria) |
---|
| 293 | //dos contatos dinamicos |
---|
| 294 | $sql = 'SELECT preference_owner, preference_value '. |
---|
| 295 | 'FROM phpgw_preferences '. |
---|
| 296 | 'WHERE preference_app = \'expressoMail\' AND '. |
---|
| 297 | 'preference_owner in (-1,-2, ' . $user . ')'; |
---|
[6605] | 298 | |
---|
[6783] | 299 | $preferences = Controller::service('PostgreSQL')->execResultSql($sql); |
---|
[6605] | 300 | |
---|
[6783] | 301 | $array = array(); |
---|
| 302 | if(count($preferences) > 0){ |
---|
| 303 | foreach($preferences as $preference){ |
---|
| 304 | //recupera a preferencia |
---|
| 305 | $preference_value = unserialize( $preference['preference_value'] ); |
---|
| 306 | |
---|
| 307 | //gera um array com o owner e o valor da preferencia: |
---|
| 308 | //true: SIM (1) |
---|
| 309 | //false: NAO (0) |
---|
| 310 | //null: escolha pelo usuario/ usar padrao / sem padrao |
---|
| 311 | $value = null; |
---|
| 312 | if(isset($preference_value['use_dynamic_contacts'])){ |
---|
| 313 | $value = (isset($preference_value['use_dynamic_contacts'])) ? $preference_value['use_dynamic_contacts'] == '1' : false; |
---|
| 314 | } |
---|
| 315 | $array[ $preference['preference_owner'] ] = $value; |
---|
| 316 | } |
---|
| 317 | } |
---|
[6605] | 318 | |
---|
[6783] | 319 | //preferencia obrigatoria (SIM) |
---|
| 320 | if(array_key_exists(-1,$array) && $array[-1]){ |
---|
| 321 | return true; |
---|
[6605] | 322 | } |
---|
[6783] | 323 | //preferencia do user (SIM) |
---|
| 324 | else if(array_key_exists($user,$array) && $array[$user] ){ |
---|
| 325 | return true; |
---|
| 326 | } |
---|
| 327 | //preferencia padrao (SIM) escolhida pelo user |
---|
| 328 | else if(array_key_exists($user, $array) && $array[$user] === null && |
---|
| 329 | array_key_exists(-2, $array) && $array[-2]){ |
---|
| 330 | return true; |
---|
| 331 | } |
---|
| 332 | return false; |
---|
[6605] | 333 | } |
---|
| 334 | |
---|
[6473] | 335 | } |
---|
[6523] | 336 | |
---|
[6473] | 337 | ?> |
---|