/**
* Retorna uma lista de usuários
*
* @license http://www.gnu.org/copyleft/gpl.html GPL
* @author Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br)
* @sponsor Caixa Econômica Federal
* @author José Vicente Tezza Jr.
* @return Retorna uma lista de usuários do LDAP
* @access public
* */
function get($request, $id)
{
$response = new Response($request);
$response->addHeader('Content-type', 'aplication/json');
$response->code = Response::OK;
$h = new Hypermedia();
$c = new Collection($request->resources, 'PersonalContactResource');
try {
$this->secured();
$contacts = !!$id ? Controller::find(array('concept' => 'contact'), false, array('filter' => array('AND', array('=', 'user', Config::me("uidNumber")), array('=', 'id', $id)))) : Controller::find(array('concept' => 'contact'), false, array('filter' => array('=', 'user', Config::me("uidNumber"))));
//Se nao foi encontrado contatos na consulta
if ($contacts === false) {
$error = new Error();
$error->setCode(Response::NOTFOUND);
$error->setTitle('Contacts not found');
$error->setDescription('Contacts not found.');
$c->setError($error);
$h->setCollection($c);
$response->code = Response::NOTFOUND;
$response->body = $h->getHypermedia($request->accept[10][0]);
return $response;
}
foreach ($contacts as $value) {
$i = new Item($request->resources, 'PersonalContactResource', $value['id']);
$d = new Data();
$d->setName('name');
$d->setValue($value['name']);
$d->setPrompt('Nome do Contato');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('id');
$d->setValue($value['id']);
$d->setPrompt('Id do Contato');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('email');
$d->setValue($value['email']);
$d->setPrompt('Email do Contato');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$l = new Link();
$l->setHref('');
$l->setRel('delete');
$l->setAlt('Remover');
$l->setPrompt('Remover');
$l->setRender('link');
$i->addLink($l);
$l = new Link();
$l->setHref('');
$l->setRel('put');
$l->setAlt('Atualizar');
$l->setPrompt('Atualizar');
$l->setRender('link');
$i->addLink($l);
$l = new Link();
$l->setHref('/contact/' . $value['id']);
$l->setRel('get');
$l->setAlt('Buscar');
$l->setPrompt('Buscar');
$l->setRender('link');
$i->addLink($l);
$c->addItem($i);
}
$t = new Template();
$d = new Data();
$d->setName('name');
$d->setValue(null);
$d->setPrompt('Nome do Contato');
$d->setDataType('string');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$d = new Data();
$d->setName('email');
$d->setValue(null);
$d->setPrompt('Email do Contato');
$d->setDataType('string');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$d = new Data();
$d->setName('telefone');
$d->setValue(null);
$d->setPrompt('Telefone do Contato');
$d->setDataType('string');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$c->setTemplate($t);
$h->setCollection($c);
} catch (Exception $ex) {
$error = new Error();
$error->setCode(Response::INTERNALSERVERERROR);
$error->setTitle('Internal Server Error');
$error->setDescription($ex);
$c->setError($error);
$h->setCollection($c);
$response->code = Response::INTERNALSERVERERROR;
$response->body = $h->getHypermedia($request->accept[10][0]);
return $response;
}
$response->body = $h->getHypermedia($request->accept[10][0]);
return $response;
}
/**
* Retorna uma lista de usuários
*
* @license http://www.gnu.org/copyleft/gpl.html GPL
* @author Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br)
* @sponsor Caixa Econômica Federal
* @author José Vicente Tezza Jr.
* @return Retorna um usuário do LDAP filtrado pelo atributo 'uid'
* @access public
* */
function get($request, $id)
{
$response = new Response($request);
$response->addHeader('Content-type', 'aplication/json');
$response->code = Response::OK;
$h = new Hypermedia();
$c = new Collection($request->resources, 'UserResource');
try {
$this->secured();
$user = Controller::find(array('concept' => 'user', 'service' => 'OpenLDAP'), false, array('filter' => array('=', 'uid', $id), 'notExternal' => true));
//Se nao foi encontrado usuario na consulta
if ($user === false) {
$error = new Error();
$error->setCode(Response::NOTFOUND);
$error->setTitle('UserLDAP not found');
$error->setDescription('User not found.');
$c->setError($error);
$h->setCollection($c);
$response->code = Response::NOTFOUND;
$response->body = $h->getHypermedia($request->accept[10][0]);
return $response;
}
$t = new Template();
$d = new Data();
$d->setName('name');
$d->setValue(null);
$d->setPrompt('Nome do Usuário');
$d->setDataType('string');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$d = new Data();
$d->setName('email');
$d->setValue(null);
$d->setPrompt('Email do Usuário');
$d->setDataType('string');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$d = new Data();
$d->setName('telefone');
$d->setValue(null);
$d->setPrompt('Telefone do Usuário');
$d->setDataType('string');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$c->setTemplate($t);
$d = new Data();
$d->setName('name');
$d->setValue($user[0]['name']);
$d->setPrompt('Nome do Usuário');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$c->addData($d);
$d = new Data();
$d->setName('email');
$d->setValue($user[0]['mail']);
$d->setPrompt('Email do Usuário');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$c->addData($d);
$d = new Data();
$d->setName('telephoneNumber');
$d->setValue($user[0]['telephoneNumber']);
$d->setPrompt('Telefone do Usuário');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$c->addData($d);
$l = new Link();
$l->setHref('');
$l->setRel('delete');
$l->setAlt('Remover');
$l->setPrompt('Remover');
$l->setRender('link');
$c->addLink($l);
$l = new Link();
$l->setHref('');
$l->setRel('put');
$l->setAlt('Atualizar');
$l->setPrompt('Atualizar');
$l->setRender('link');
$c->addLink($l);
$h->setCollection($c);
} catch (Exception $ex) {
$error = new Error();
$error->setCode(Response::INTERNALSERVERERROR);
$error->setTitle('Internal Server Error');
$error->setDescription($ex);
$c->setError($error);
$h->setCollection($c);
$response->code = Response::INTERNALSERVERERROR;
$response->body = $h->getHypermedia($request->accept[10][0]);
return $response;
}
$response->body = $h->getHypermedia($request->accept[10][0]);
return $response;
}
/**
* Retorna um contato recente
*
* @license http://www.gnu.org/copyleft/gpl.html GPL
* @author Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br)
* @sponsor Caixa Econômica Federal
* @author José Vicente Tezza Jr.
* @return Retorna um contato recente
* @access public
* */
function get($request, $id)
{
$this->secured();
//verificar se a preferencia de contatos dinamicos nao esta ativada
if (!$this->isEnabledDynamicContacts(Config::me("uidNumber"))) {
$response = new Response($request);
$this->createException($request, $response, Response::UNAUTHORIZED, 'Resource unauthorized', 'disabled dynamic contacts preference');
return $response;
}
$response = new Response($request);
$response->addHeader('Content-type', 'aplication/json');
$response->code = Response::OK;
$h = new Hypermedia();
$c = new Collection($request->resources, 'DynamicContactResource', $id);
try {
$dynamicContact = Controller::read(array('concept' => 'dynamicContact'), false, array('filter' => array('AND', array('=', 'owner', Config::me("uidNumber")), array('=', 'id', $id))));
//Se nao foi encontrado contatos na consulta
if (!$dynamicContact) {
$this->createException($request, $response, Response::NOTFOUND, 'Bad request', 'Dynamic Contact not found.');
return $response;
}
//Normaliza dado
if (is_array($dynamicContact)) {
$dynamicContact = $dynamicContact[0];
}
$t = new Template();
$d = new Data();
$d->setName('name');
$d->setValue(null);
$d->setPrompt('Nome do Contato Recente');
$d->setDataType('string');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$d = new Data();
$d->setName('mail');
$d->setValue(null);
$d->setPrompt('Email do Contato Recente');
$d->setDataType('string');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$d = new Data();
$d->setName('number_of_messages');
$d->setValue(null);
$d->setPrompt('Quantidade de mensagens enviadas');
$d->setDataType('integer');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(false);
$t->addData($d);
$c->setTemplate($t);
$d = new Data();
$d->setName('id');
$d->setValue($dynamicContact['id']);
$d->setPrompt('Identificador do Contato Recente');
$d->setDataType('integer');
$d->setMaxLength(null);
$d->setMinLength(null);
$d->setRequired(true);
$c->addData($d);
$d = new Data();
$d->setName('name');
$d->setValue($dynamicContact['name']);
$d->setPrompt('Nome do Contato Recente');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$c->addData($d);
$d = new Data();
$d->setName('mail');
$d->setValue($dynamicContact['mail']);
$d->setPrompt('Email do Contato Recente');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$c->addData($d);
$d = new Data();
$d->setName('number_of_messages');
$d->setValue($dynamicContact['number_of_messages']);
$d->setPrompt('Quantidade de mensagens enviadas');
$d->setDataType('integer');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(false);
$c->addData($d);
$l = new Link();
$l->setHref('');
$l->setRel('delete');
$l->setAlt('Remover');
$l->setPrompt('Remover');
$l->setRender('link');
$c->addLink($l);
$l = new Link();
$l->setHref('');
$l->setRel('put');
$l->setAlt('Atualizar');
$l->setPrompt('Atualizar');
$l->setRender('link');
$c->addLink($l);
$h->setCollection($c);
} catch (Exception $ex) {
$this->createException($request, $response, Response::INTERNALSERVERERROR, 'Internal Server Error', 'Internal Server Error');
return $response;
}
$response->body = $h->getHypermedia($request->accept[10][0]);
return $response;
}
/**
* Retorna uma lista de usuários
*
* @license http://www.gnu.org/copyleft/gpl.html GPL
* @author Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br)
* @sponsor Caixa Econômica Federal
* @author José Vicente Tezza Jr.
* @return Retorna uma lista de usuários do LDAP
* @access public
* */
function get($request)
{
$response = new Response($request);
$response->addHeader('Content-type', 'aplication/json');
$response->code = Response::OK;
$h = new Hypermedia();
$c = new Collection($request->resources, 'UsersResource');
$this->secured();
try {
//Executa uma consulta de usuários do LDAP a partir de um determinado atributo e valor
if (isset($_GET['field']) && isset($_GET['value'])) {
//recupera os atributos definidos no conceito 'user'
$map = Config::get('user', 'OpenLDAP.mapping');
//verifica se o campo(atributo) passado pelo usuário está definido no conceito 'user'
if (isset($map[$_GET['field']])) {
$users = Controller::find(array('concept' => 'user', 'service' => 'OpenLDAP'), false, array('filter' => array('=', $_GET['field'], $_GET['value']), 'notExternal' => true));
} else {
//lança warning no log do Expresso
trigger_error("Invalid field (" . $_GET['field'] . ") in the query.", E_USER_WARNING);
//formata os atributos LDAP do conceito 'user'
$attributes = implode(', ', $map);
//Configura o erro na hypermedia
$error = new Error();
$error->setCode(Response::NOTFOUND);
$error->setTitle('UserLDAP not found');
$error->setDescription("Invalid field (" . $_GET['field'] . ") in the query. Use of these: " . $attributes);
$c->setError($error);
$h->setCollection($c);
//retorna a hypermedia
$response->code = Response::NOTFOUND;
$response->body = $h->getHypermedia($request->accept[10][0]);
return $response;
}
} else {
//Executa a consulta dos primeiros 20 usuarios do LDAP
$users = Controller::find(array('concept' => 'user', 'service' => 'OpenLDAP'), false, array('filter' => array('=', 'phpgwAccountType', 'u'), 'limit' => 20, 'notExternal' => true));
}
//Se nao foi encontrado usuarios na consulta
if ($users === false) {
$error = new Error();
$error->setCode(Response::NOTFOUND);
$error->setTitle('UserLDAP not found');
$error->setDescription('Users not found.');
$c->setError($error);
$h->setCollection($c);
$response->code = Response::NOTFOUND;
$response->body = $h->getHypermedia($request->accept[10][0]);
return $response;
}
foreach ($users as $value) {
$d = new Data();
$i = new Item($request->resources, 'UsersResource', $value['uid']);
$d->setName('name');
$d->setValue($value['name']);
$d->setPrompt('Nome do Usuario');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('email');
$d->setValue($value['mail']);
$d->setPrompt('Email do Usuario');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('telephoneNumber');
$d->setValue($value['telephoneNumber']);
$d->setPrompt('Telefone do Usuario');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('vacationActive');
$d->setValue($value['vacationActive']);
$d->setPrompt('Status da Regra fora de Escritorio');
$d->setDataType('boolean');
$d->setMaxLength('10');
$d->setMinLength(null);
$d->setRequired(null);
$i->addData($d);
$d = new Data();
$d->setName('vacationInfo');
$d->setValue($value['vacationInfo']);
$d->setPrompt('Mensagem da Regra fora de Escritorio');
$d->setDataType('boolean');
$d->setMaxLength('10');
$d->setMinLength(null);
$d->setRequired(null);
$i->addData($d);
$l = new Link();
$l->setHref('');
$l->setRel('delete');
$l->setAlt('Remover');
$l->setPrompt('Remover');
$l->setRender('link');
$i->addLink($l);
$l = new Link();
$l->setHref('');
$l->setRel('put');
$l->setAlt('Atualizar');
$l->setPrompt('Atualizar');
$l->setRender('link');
$i->addLink($l);
$l = new Link();
$l->setHref('/userldap/' . $value['uid']);
$l->setRel('get');
$l->setAlt('Buscar');
$l->setPrompt('Buscar');
$l->setRender('link');
$i->addLink($l);
$c->addItem($i);
}
$t = new Template();
$d = new Data();
$d->setName('name');
$d->setValue(null);
$d->setPrompt('Nome do Usuario');
$d->setDataType('string');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$d = new Data();
$d->setName('email');
$d->setValue(null);
$d->setPrompt('Email do Usuario');
$d->setDataType('string');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$d = new Data();
$d->setName('telefone');
$d->setValue(null);
$d->setPrompt('Telefone do Usuario');
$d->setDataType('string');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$queries = new Querie();
$queries->setHref($c->href);
$queries->setData('field', '', true);
$queries->setData('value', '', true);
$c->addQueries($queries);
$h->setCollection($c);
} catch (Exception $ex) {
$error = new Error();
$error->setCode(Response::INTERNALSERVERERROR);
$error->setTitle('Internal Server Error');
$error->setDescription($ex);
$c->setError($error);
$h->setCollection($c);
$response->code = Response::INTERNALSERVERERROR;
$response->body = $h->getHypermedia($request->accept[10][0]);
return $response;
}
$response->body = $h->getHypermedia($request->accept[10][0]);
return $response;
}
if($length < 10) {
$size = 10;
}
*/
$inp = new Input();
$inp->setName($colname);
$inp->setValue($item);
$inp->setSize(50);
$inp->setMaxlength(128);
/**/
$tr = new Tr();
$tr->add($colname);
$tr->add($inp->dump());
$tr->build();
++$i;
/**/
}
$tr = new Tr();
$tr->add(' ');
$tr->add($submit->dump());
$tr->build();
unset($table);
unset($form);
$body->line('<hr />');
$backlink = new Link();
$backlink->setHref('controller.php?cmd=table_browse&table=' . $req->get('table'));
$backlink->setName('Back to list');
$backlink->build();
include_once './inc/footer.php';
unset($body);
unset($html);
$table->build();
foreach ($res as $item) {
if ($item->name == 'sqlite_sequence') {
continue;
}
$struct = new Link();
$struct->setHref('controller.php?cmd=tableinfo&table=' . $item->name . '&view=true');
$struct->setName('Structure');
$browse = new Link();
$browse->setHref('controller.php?cmd=table_browse&table=' . $item->name . '&view=true');
$browse->setName('Browse');
$dump = new Link();
$dump->setHref('controller.php?cmd=table_dump&table=' . $item->name . '&view=true');
$dump->setName('Dump');
$drop = new Link();
$drop->setHref('controller.php?cmd=drop_view&table=' . $item->name . '&view==true');
$drop->setName('Drop');
$drop->setJs(' onclick="return PSA.really_drop(\'view\');" ');
$tr = new Tr();
$tr->add($item->name);
$tr->add($struct->dump());
$tr->add($browse->dump());
$tr->add($dump->dump());
$tr->add($drop->dump());
$tr->build();
}
unset($table);
}
include_once './inc/footer.php';
unset($body);
unset($html);
$table->setClas('result');
$table->build();
$th = new Th();
$th->add('Name');
$th->add('Unique ?');
$th->add('Columns');
$th->add(' ');
$th->build();
foreach ($res as $item) {
if ($item->unique == 1) {
$uniq = 'Y';
} else {
$uniq = 'N';
}
$drop = new Link();
$drop->setHref('controller.php?cmd=drop_idx&idxname=' . $item->name . '&table=' . $req->get('table'));
$drop->setName('[ drop ]');
$drop->setJs(' onclick="return PSA.really_drop(\' index [' . $item->name . ']\');" ');
$tr = new Tr();
if ($odd) {
$tr->setGlobalClass('even');
$odd = FALSE;
} else {
$tr->setGlobalClass('odd');
$odd = TRUE;
}
$tr->add($item->name);
$tr->setClas('center');
$tr->add($uniq);
$q = "PRAGMA index_info(" . $item->name . ")";
$sql->qo($q);
/**
* Retorna uma lista de grupos
*
* @license http://www.gnu.org/copyleft/gpl.html GPL
* @author Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br)
* @sponsor Caixa Econômica Federal
* @author Adrino Coutinho da Silva.
* @return Retorna uma lista de Contatos Dinâmicos, Grupos, Contatos Pessoais, Grupos Compartilhados e Contatos Compartilhados
* @access public
* */
function get($request)
{
$this->secured();
//verificar se a preferencia de contatos dinamicos nao esta ativada
if (!$this->isEnabledDynamicContacts(Config::me("uidNumber"))) {
$response = new Response($request);
$this->createException($request, $response, Response::UNAUTHORIZED, 'Resource unauthorized', 'disabled dynamic contacts preference');
return $response;
}
$response = new Response($request);
$response->addHeader('Content-type', 'aplication/json');
$response->code = Response::OK;
$h = new Hypermedia();
$c = new Collection($request->resources, 'UserContactsResource');
try {
$d = new Data();
$d->setName('User Contacts');
$d->setValue(null);
$d->setPrompt('Contatos do usuário');
$d->setDataType(null);
$d->setMaxLength(null);
$d->setMinLength(null);
$d->setRequired(null);
$c->addData($d);
//Recupera os contatos dinâmicos do usuario
$dynamicContacts = Controller::find(array('concept' => 'dynamicContact'), false, array('filter' => array('=', 'owner', Config::me("uidNumber")), 'order' => array('number_of_messages', 'name', 'mail'), 'orderDesc' => array(true, false, false)));
if ($dynamicContacts) {
foreach ($dynamicContacts as $value) {
$d = new Data();
$i = new Item($request->resources, 'DynamicContactsResource', $value['id']);
$d->setName('name');
$d->setValue($value['name']);
$d->setPrompt('Nome do Contato Recente');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('mail');
$d->setValue($value['mail']);
$d->setPrompt('Email do Contato Recente');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('number_of_messages');
$d->setValue((int) $value['number_of_messages']);
$d->setPrompt('Quantidade de mensagens enviadas');
$d->setDataType('integer');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(false);
$i->addData($d);
$d = new Data();
$d->setName('id');
$d->setValue($value['id']);
$d->setPrompt('Id do contato dinamico');
$d->setDataType('integer');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(false);
$i->addData($d);
$l = new Link();
$l->setHref('');
$l->setRel('delete');
$l->setAlt('Remover');
$l->setPrompt('Remover');
$l->setRender('link');
$i->addLink($l);
$l = new Link();
$l->setHref('');
$l->setRel('put');
$l->setAlt('Atualizar');
$l->setPrompt('Atualizar');
$l->setRender('link');
$i->addLink($l);
$l = new Link();
$l->setHref('/dynamiccontact/' . $value['id']);
$l->setRel('get');
$l->setAlt('Buscar');
$l->setPrompt('Buscar');
$l->setRender('link');
$i->addLink($l);
$c->addItem($i);
}
}
$idS = array(Config::me("uidNumber"));
$acl = array();
//Recupera o uidNumber de todos os usuários que compartilham suas agendas com o usuário logado
$shareds = Controller::service('PostgreSQL')->execResultSql('select acl_account as "uidNumber", acl_rights as "acl" from phpgw_acl where (acl_location = \'' . Config::me("uidNumber") . '\' AND acl_appname = \'contactcenter\' )');
if (!empty($shareds) && $shareds) {
foreach ($shareds as $s) {
array_push($idS, $s['uidNumber']);
$acl[$s['uidNumber']] = $this->decodeAcl(decbin($s['acl']));
}
}
//Recupera os grupos do usuario
$groups = Controller::find(array('concept' => 'contactGroup'), false, array('filter' => array('IN', 'user', $idS), 'order' => array('name')));
if ($groups) {
foreach ($groups as $value) {
if ($value['user'] == Config::me("uidNumber") || $acl[$value['user']]['read']) {
$i = new Item($request->resources, $value['user'] == Config::me("uidNumber") ? 'GroupsResource' : 'SharedGroupResource', $value['id']);
$d = new Data();
$d->setName('id');
$d->setValue($value['id']);
$d->setPrompt('Id do Grupo');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('owner');
$d->setValue($value['user']);
$d->setPrompt('Id Dono do Grupo');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('name');
$d->setValue($value['name']);
$d->setPrompt('Nome do Grupo');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('mail');
$d->setValue($value['email']);
$d->setPrompt('Email do Grupo');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
if (Config::me("uidNumber") != $value['user']) {
/* Descomentar ao implementar os métodos
if ($acl[$value['user']]['delete']) {
$l = new Link();
$l->setHref('');
$l->setRel('delete');
$l->setAlt('Remover');
$l->setPrompt('Remover');
$l->setRender('link');
$i->addLink($l);
}
if ($acl[$value['user']]['update']) {
$l = new Link();
$l->setHref('');
$l->setRel('put');
$l->setAlt('Atualizar');
$l->setPrompt('Atualizar');
$l->setRender('link');
$i->addLink($l);
}
if ($acl[$value['user']]['write']) {
$l = new Link();
$l->setHref('');
$l->setRel('post');
$l->setAlt('Criar');
$l->setPrompt('Criar novo');
$l->setRender('link');
$i->addLink($l);
}
*/
$l = new Link();
$l->setHref('/sharedgroup/' . $value['id']);
$l->setRel('get');
$l->setAlt('Buscar');
$l->setPrompt('Buscar');
$l->setRender('link');
$i->addLink($l);
} else {
/* Descomentar ao implementar métodos no recurso
$l = new Link();
$l->setHref('');
$l->setRel('delete');
$l->setAlt('Remover');
$l->setPrompt('Remover');
$l->setRender('link');
$i->addLink($l);
$l = new Link();
$l->setHref('');
$l->setRel('put');
$l->setAlt('Atualizar');
$l->setPrompt('Atualizar');
$l->setRender('link');
$i->addLink($l);
*/
$l = new Link();
$l->setHref('/group/' . $value['id']);
$l->setRel('get');
$l->setAlt('Buscar');
$l->setPrompt('Buscar');
$l->setRender('link');
$i->addLink($l);
}
$c->addItem($i);
}
}
}
//Recupera os contatos pessoais do usuario
$contacts = Controller::find(array('concept' => 'contact'), false, array('filter' => array('IN', 'user', $idS)));
if ($contacts) {
foreach ($contacts as $value) {
if ($value['user'] == Config::me("uidNumber") || $acl[$value['user']]['read']) {
$d = new Data();
$i = new Item($request->resources, $value['user'] == Config::me("uidNumber") ? 'PersonalContactResource' : 'SharedContactResource', $value['id']);
$d->setName('id');
$d->setValue($value['id']);
$d->setPrompt('Id do Contato');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('owner');
$d->setValue($value['user']);
$d->setPrompt('Id Dono do Contato');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('name');
$d->setValue($value['name']);
$d->setPrompt('Nome do Contato');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('mail');
$d->setValue(isset($value['email']) ? $value['email'] : null);
$d->setPrompt('Email do Contato');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('telephone');
$d->setValue(isset($value['telephone']) ? $value['telephone'] : null);
$d->setPrompt('Telefone do Contato');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
if (Config::me("uidNumber") != $value['user']) {
$l = new Link();
$l->setHref('/sharedcontact/' . $value['id']);
$l->setRel('get');
$l->setAlt('Buscar');
$l->setPrompt('Buscar');
$l->setRender('link');
$i->addLink($l);
/* Descomentar ao criar recursos
if ($acl[$value['user']]['delete']) {
$l = new Link();
$l->setHref('');
$l->setRel('delete');
$l->setAlt('Remover');
$l->setPrompt('Remover');
$l->setRender('link');
$i->addLink($l);
}
if ($acl[$value['user']]['put']) {
$l = new Link();
$l->setHref('');
$l->setRel('put');
$l->setAlt('Atualizar');
$l->setPrompt('Atualizar');
$l->setRender('link');
$i->addLink($l);
}
*/
} else {
/* Descomentar ao criar recursos
$l = new Link();
$l->setHref('');
$l->setRel('delete');
$l->setAlt('Remover');
$l->setPrompt('Remover');
$l->setRender('link');
$i->addLink($l);
$l = new Link();
$l->setHref('');
$l->setRel('put');
$l->setAlt('Atualizar');
$l->setPrompt('Atualizar');
$l->setRender('link');
$i->addLink($l);
*/
$l = new Link();
$l->setHref('/contact/' . $value['id']);
$l->setRel('get');
$l->setAlt('Buscar');
$l->setPrompt('Buscar');
$l->setRender('link');
$i->addLink($l);
}
$c->addItem($i);
}
}
}
if (!$contacts && !$dynamicContacts && !$groups) {
$this->createException($request, $response, Response::NOTFOUND, 'Bad request', 'Resource not found.');
return $response;
}
$t = new Template();
$d = new Data();
$d->setName('id');
$d->setValue(null);
$d->setPrompt('Id do Grupo');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$d = new Data();
$d->setName('user');
$d->setValue(null);
$d->setPrompt('Id Dono do Grupo');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$d = new Data();
$d->setName('name');
$d->setValue(null);
$d->setPrompt('Nome do Grupo');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$c->setTemplate($t);
$h->setCollection($c);
$response->body = $h->getHypermedia($request->accept[10][0]);
return $response;
} catch (Exception $ex) {
$this->createException($request, $response, Response::INTERNALSERVERERROR, 'Internal Server Error', $ex);
return $response;
}
}
/**
* Retorna uma lista de contatos recentes
*
* @license http://www.gnu.org/copyleft/gpl.html GPL
* @author Consórcio Expresso Livre - 4Linux (www.4linux.com.br) e Prognus Software Livre (www.prognus.com.br)
* @sponsor Caixa Econômica Federal
* @author José Vicente Tezza Jr.
* @return Retorna uma lista de contatos recentes
* @access public
* */
function get($request)
{
$this->secured();
$response = new Response($request);
$response->addHeader('Content-type', 'aplication/json');
$response->code = Response::OK;
$h = new Hypermedia();
$c = new Collection($request->resources, 'DynamicContactsResource');
try {
$dynamicContacts = Controller::find(array('concept' => 'dynamicContact'), false, array('filter' => array('=', 'owner', Config::me("uidNumber")), 'order' => array('number_of_messages', 'name', 'mail'), 'orderDesc' => array(true, false, false)));
//Se nao foi encontrado contatos na consulta
if (!$dynamicContacts) {
$this->createException($request, $response, Response::NOTFOUND, 'Bad request', 'Dynamic Contact not found.');
return $response;
}
$dynamicContacts = array_slice($dynamicContacts, 0, 50);
foreach ($dynamicContacts as $value) {
$d = new Data();
$i = new Item($request->resources, 'DynamicContactsResource', $value['id']);
$d->setName('name');
$d->setValue($value['name']);
$d->setPrompt('Nome do Contato Recente');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('mail');
$d->setValue($value['mail']);
$d->setPrompt('Email do Contato Recente');
$d->setDataType('string');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(true);
$i->addData($d);
$d = new Data();
$d->setName('number_of_messages');
$d->setValue($value['number_of_messages']);
$d->setPrompt('Quantidade de mensagens enviadas');
$d->setDataType('integer');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(false);
$i->addData($d);
$d = new Data();
$d->setName('id');
$d->setValue($value['id']);
$d->setPrompt('Id do contato dinamico');
$d->setDataType('integer');
$d->setMaxLength('100');
$d->setMinLength(null);
$d->setRequired(false);
$i->addData($d);
$l = new Link();
$l->setHref('');
$l->setRel('delete');
$l->setAlt('Remover');
$l->setPrompt('Remover');
$l->setRender('link');
$i->addLink($l);
$l = new Link();
$l->setHref('');
$l->setRel('put');
$l->setAlt('Atualizar');
$l->setPrompt('Atualizar');
$l->setRender('link');
$i->addLink($l);
$l = new Link();
$l->setHref('/dynamiccontact/' . $value['id']);
$l->setRel('get');
$l->setAlt('Buscar');
$l->setPrompt('Buscar');
$l->setRender('link');
$i->addLink($l);
$c->addItem($i);
}
$t = new Template();
$d = new Data();
$d->setName('name');
$d->setValue(null);
$d->setPrompt('Nome do Contato Recente');
$d->setDataType('string');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(false);
$t->addData($d);
$d = new Data();
$d->setName('mail');
$d->setValue(null);
$d->setPrompt('Email do Contato Recente');
$d->setDataType('string');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(true);
$t->addData($d);
$d = new Data();
$d->setName('number_of_messages');
$d->setValue(null);
$d->setPrompt('Quantidade de mensagens enviadas');
$d->setDataType('integer');
$d->setMaxLength(100);
$d->setMinLength(null);
$d->setRequired(false);
$t->addData($d);
$c->setTemplate($t);
$h->setCollection($c);
} catch (Exception $ex) {
$this->createException($request, $response, Response::INTERNALSERVERERROR, 'Internal Server Error', $ex);
return $response;
}
$response->body = $h->getHypermedia($request->accept[10][0]);
return $response;
}
/**/
$tr = new Tr();
if ($odd) {
$tr->setGlobalClass('even');
$odd = FALSE;
} else {
$tr->setGlobalClass('odd');
$odd = TRUE;
}
if (!$is_view) {
$edit = new Link();
$edit->setHref('controller.php?cmd=edit_record&table=' . $req->get('table') . '&id=' . $item->id);
$edit->setName('[edit]');
// $edit->setTarget('edit_del');
$del = new Link();
$del->setHref('controller.php?cmd=drop_record&table=' . $req->get('table') . '&id=' . $item->id);
$del->setName('[del]');
$del->setJs(' onclick="return PSA.really_drop(\'record\');" ');
$tr->add($edit->dump());
$tr->add($del->dump());
}
foreach ($item as $data) {
$tr->add(htmlentities($data));
}
$tr->build();
}
unset($table);
}
$body->line('</div>');
include_once './inc/footer.php';
unset($body);
$head->setCss('./css/psa.css');
$head->setJs('./js/PSA.js');
$head->build();
$body = new Body();
$body->build();
include_once './inc/menubar.php';
// TODO: check if table name already exists
$name = new Input();
$name->setName('tblname');
$name->setSize(50);
$name->setMaxlength(128);
$name->setId('tblname');
$body->line('<span class="vet">Table name</span><br /> ');
$body->line($name->dump());
$create = new Link();
$create->setHref('controller.php?cmd=table_add_action');
$create->setName('<button>Create</button>');
$body->line($create->dump());
$body->line('<hr />');
$body->line('<span class="vet">Fields</span><br /> ');
$table = new Table();
$table->setClas('result');
$table->build();
$th = new Th();
$th->add('name');
$th->add('type');
$th->add('primary');
$th->add('size');
$th->add('null');
$th->add('default');
$th->build();
$table = new Table();
$table->setId('listing');
$table->build();
for ($i = 0; $i < sizeof($files); ++$i) {
$link = new Link();
$link->setHref('controller.php?cmd=table&db=' . urlencode($files[$i]));
$link->setName('[' . $files[$i] . ']');
$vacuum = new Link();
$vacuum->setHref('controller.php?cmd=vacuum_db&db=' . urlencode($files[$i]));
$vacuum->setName('[vacuum]');
$drop = new Link();
$drop->setHref('controller.php?cmd=drop_db&db=' . urlencode($files[$i]));
$drop->setName('[drop]');
$drop->setJs(' onclick="return PSA.really_drop(\'database\');" ');
$schema = new Link();
$schema->setHref('controller.php?cmd=schema_db&db=' . urlencode($files[$i]));
$schema->setName('[schema]');
$tr = new Tr();
if ($odd) {
$tr->setGlobalClass('even');
$odd = FALSE;
} else {
$tr->setGlobalClass('odd');
$odd = TRUE;
}
$tr->add($link->dump());
$tr->add($vacuum->dump());
$tr->add($drop->dump());
$tr->add($schema->dump());
$tr->build();
}
