/** * method onReload() * Load the datagrid with the database objects */ function onReload($param = NULL) { try { // open a transaction with database 'samples' TTransaction::open('samples'); // creates a repository for Category $repository = new TRepository('Category'); // creates a criteria, ordered by id $criteria = new TCriteria(); $order = isset($param['order']) ? $param['order'] : 'id'; $criteria->setProperty('order', $order); // load the objects according to criteria $categories = $repository->load($criteria); $this->datagrid->clear(); if ($categories) { // iterate the collection of active records foreach ($categories as $category) { // add the object inside the datagrid $this->datagrid->addItem($category); } } // close the transaction TTransaction::close(); $this->loaded = true; } catch (Exception $e) { // shows the exception error message new TMessage('error', '<b>Error</b> ' . $e->getMessage()); // undo all pending operations TTransaction::rollback(); } }
public function removeListOfMaterialPermanente() { $criteria = new TCriteria(); $criteria->add(new TFilter('tipo_material_permanente_id', '=', $this->id)); $repository = new TRepository('MaterialPermanente'); return $repository->delete($criteria); }
function onReload($param = NULL) { $offset = $param['offset']; //$order = $param['order']; $limit = 10; // inicia transação com o banco 'pg_livro' TTransaction::open('pg_livro'); // instancia um repositório para Alunos $repository = new TRepository('Pessoa'); // retorna todos objetos que satisfazem o critério $criteria = new TCriteria(); $count = $repository->count($criteria); $criteria->setProperty('limit', $limit); $criteria->setProperty('offset', $offset); $pessoas = $repository->load($criteria); $this->navbar->setPageSize($limit); $this->navbar->setCurrentPage($param['page']); $this->navbar->setTotalRecords($count); $this->datagrid->clear(); if ($pessoas) { foreach ($pessoas as $pessoa) { // adiciona o objeto na DataGrid $this->datagrid->addItem($pessoa); } } // finaliza a transação TTransaction::close(); $this->loaded = true; }
public static function listForCategory($category_id) { $criteria = new TCriteria(); $criteria->add(new TFilter('category_id', '=', $category_id)); $repos = new TRepository('Post'); return $repos->load($criteria); }
/** * Class Constructor * @param $name widget's name * @param $database database name * @param $model model class name * @param $key table field to be used as key in the combo * @param $value table field to be listed in the combo * @param $ordercolumn column to order the fields (optional) * @param array $filter TFilter (optional) By Alexandre * @param array $expresione TExpression (opcional) by Alexandre */ public function __construct($name, $database, $model, $key, $value, $ordercolumn = NULL, $filter = NULL, $expression = NULL) { new TSession(); // executes the parent class constructor parent::__construct($name); // carrega objetos do banco de dados TTransaction::open($database); // instancia um repositório de Estado $repository = new TRepository($model); $criteria = new TCriteria(); $criteria->setProperty('order', isset($ordercolumn) ? $ordercolumn : $key); if ($filter) { foreach ($filter as $fil) { if ($expression) { foreach ($expression as $ex) { $criteria->add($fil, $ex); } } else { $criteria->add($fil); } } } // carrega todos objetos $collection = $repository->load($criteria); // adiciona objetos na combo if ($collection) { $items = array(); foreach ($collection as $object) { $items[$object->{$key}] = $object->{$value}; } parent::addItems($items); } TTransaction::close(); }
public function delete($id = NULL) { $id = isset($id) ? $id : $this->{'id'}; $criteria = new TCriteria(); $criteria->add(new TFilter('project_id', '=', $id)); $repository = new TRepository('Backlog'); $repository->delete($criteria); parent::delete($id); }
public function delete($id = NULL) { $id = isset($id) ? $id : $this->logra_id; $repository = new TRepository('LogradouroBairro'); $criteria = new TCriteria(); $criteria->add(new TFilter('tb_logradouros_logra_id', '=', $id)); $repository->delete($criteria); // delete the object itself parent::delete($id); }
/** * Retorna uma instância de usuário a partir do login * @param $login Login do usuário */ public static function newFromLogin($login) { $repos = new TRepository('User'); $criteria = new TCriteria(); $criteria->add(new TFilter('login', '=', $login)); $objects = $repos->load($criteria); if (isset($objects[0])) { return $objects[0]; } }
/** * Delete an Active Record object from the database * @param [$id] The Object ID * @exception Exception if there's no active transaction opened */ public function delete($id = NULL) { $id = isset($id) ? $id : $this->{'id'}; $note_rep = new TRepository('Note'); $criteria = new TCriteria(); $criteria->add(new TFilter('id_issue', '=', $id)); $note_rep->delete($criteria); // delete the object itself parent::delete($id); }
/** * Returns the Item from its barcode */ public static function newFromBarcode($barcode) { $rep = new TRepository('Item'); $criteria = new TCriteria(); $criteria->add(new TFilter('barcode', '=', $barcode)); $objects = $rep->load($criteria); if ($objects) { $item = $objects[0]; return $item; } }
/** * Delete the object and its aggregates * @param $id object ID */ public function delete($id = NULL) { // delete the related System_groupSystem_program objects $id = isset($id) ? $id : $this->id; $repository = new TRepository('SystemGroupProgram'); $criteria = new TCriteria(); $criteria->add(new TFilter('system_group_id', '=', $id)); $repository->delete($criteria); // delete the object itself parent::delete($id); }
function get_inscricoes() { // cria um critério de seleção $criteria = new TCriteria(); // filtra por codigo do aluno $criteria->add(new TFilter('ref_aluno', '=', $this->id)); // instancia repositório de Inscrições $repository = new TRepository('Inscricao'); // retorna todas inscrições que satisfazem o critério return $repository->load($criteria); }
/** * Delete the object and its aggregates * @param $id object ID */ public function delete($id = NULL) { // delete the related System_userSystem_user_group objects $id = isset($id) ? $id : $this->id; $repository = new TRepository('SystemStock'); $criteria = new TCriteria(); $criteria->add(new TFilter('id', '=', $id)); $repository->delete($criteria); // delete the object itself parent::delete($id); }
/** * Get the last loan (not arrived) from a barcode */ public static function getFromBarcode($barcode) { $rep = new TRepository('Loan'); $criteria = new TCriteria(); $criteria->add(new TFilter('barcode', '=', $barcode)); $criteria->add(new TFilter('arrive_date', 'is', NULL)); $objects = $rep->load($criteria); if ($objects) { $loan = $objects[0]; return $loan; } }
public function getTicketsSolicitante($solicitante_id) { $criteria = new TCriteria(); $criteria->add(new TFilter('solicitante_id', '=', $solicitante_id)); $repository = new TRepository('Ticket'); $tickets = $repository->load($criteria); $retorno[] = '0'; foreach ($tickets as $row) { $retorno[] = $row->id; } return $retorno; }
public function delete($id = NULL) { //sobrescrito! $id = isset($id) ? $id : $this->id; $repository = new TRepository('TurmaDisciplina'); $criteria = new TCriteria(); $criteria->add(new TFilter('turma_id', '=', $id)); $repository->delete($criteria); $repository = new TRepository('AlunoTurma'); $repository->delete($criteria); parent::delete($id); }
/** * Return the week events * @return Event[] */ public static function getWeekEvents() { $first_week_day = self::getFirstWeekDay(); $last_week_day = self::getLastWeekDay(); // load objects $repo = new TRepository('Event'); $criteria = new TCriteria(); $criteria->add(new TFilter('event_date', '>=', $first_week_day)); $criteria->add(new TFilter('event_date', '<=', $last_week_day)); $criteria->setProperty('order', 'event_date, start_hour'); return $repo->load($criteria); }
public function get_itens() { // instancia um repositório de Item $repositorio = new TRepository('Item'); // define o critério de seleção $criterio = new TCriteria(); $criterio->add(new TFilter('id_venda', '=', $this->id)); // carrega a coleção de itens $this->itens = $repositorio->load($criterio); // retorna os itens return $this->itens; }
public function __construct() { parent::__construct(); try { TTransaction::open('samples'); $repository = new TRepository('Customer'); $repository->where('address', 'like', 'Rua Porto%')->where('gender', '=', 'M')->delete(); new TMessage('info', 'Records Deleted'); TTransaction::close(); } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }
public function __construct() { parent::__construct(); try { TTransaction::open('samples'); $repository = new TRepository('Customer'); $count = $repository->where('name', 'like', 'Rafael%', TExpression::OR_OPERATOR)->where('name', 'like', 'Ana%', TExpression::OR_OPERATOR)->count(); new TMessage('info', "Total of found customers: {$count} <br>\n"); TTransaction::close(); } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }
public function __construct() { parent::__construct(); try { TTransaction::open('samples'); $repository = new TRepository('Customer'); $customers = $repository->where('gender', '=', 'M')->where('name', 'like', 'A%')->load(); foreach ($customers as $customer) { echo $customer->id . ' - ' . $customer->name . '<br>'; } TTransaction::close(); } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }
public function __construct() { parent::__construct(); $this->order = "titulo"; $this->chavesEstrangeiras[] = "categoria"; $this->chavesEstrangeiras[] = "conta"; }
public function __construct() { parent::__construct(); $this->order = "id"; $this->chavesEstrangeiras[] = "pessoaFisica"; $this->chavesEstrangeiras[] = "profissao"; }
public function __construct() { parent::__construct(); $this->order = "id"; $this->chavesEstrangeiras[] = "pessoa"; $this->chavesEstrangeiras[] = "perfilAcesso"; }
/** * Action to be executed when the user changes the gender or status * @param $param Action parameters */ public static function onGenderChange($param) { TTransaction::open('samples'); $repo = new TRepository('Customer'); $criteria = new TCriteria(); $criteria->add(new TFilter('gender', 'IN', isset($param['check_gender']) ? $param['check_gender'] : array())); if ($param['combo_status']) { $criteria->add(new TFilter('status', '=', $param['combo_status'])); } $customers = $repo->load($criteria); TTransaction::close(); $options = array(); foreach ($customers as $customer) { $options[$customer->id] = $customer->name; } TCombo::reload('form_dynamic_filter', 'customers', $options); }
public function __construct() { parent::__construct(); try { TTransaction::open('samples'); $criteria = new TCriteria(); $criteria->add(new TFilter('gender', '=', 'F')); $repository = new TRepository('Customer'); $customers = $repository->load($criteria); foreach ($customers as $customer) { echo $customer->id . ' - ' . $customer->name . '<br>'; } TTransaction::close(); } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }
public function __construct() { parent::__construct(); $this->chavesEstrangeiras[] = "PessoaFisica"; $this->chavesEstrangeiras[] = "PessoaJuridica"; $this->arquivos[] = "fotos"; $this->order = "nome"; }
/** * Class Constructor * @param $name widget's name * @param $database database name * @param $model model class name * @param $key table field to be used as key in the combo * @param $value table field to be listed in the combo * @param $ordercolumn column to order the fields (optional) * @param $criteria criteria (TCriteria object) to filter the model (optional) */ public function __construct($name, $database, $model, $key, $value, $ordercolumn = NULL, TCriteria $criteria = NULL) { // executes the parent class constructor parent::__construct($name); if (empty($database)) { throw new Exception(AdiantiCoreTranslator::translate('The parameter (^1) of ^2 is required', 'database', __CLASS__)); } if (empty($model)) { throw new Exception(AdiantiCoreTranslator::translate('The parameter (^1) of ^2 is required', 'model', __CLASS__)); } if (empty($key)) { throw new Exception(AdiantiCoreTranslator::translate('The parameter (^1) of ^2 is required', 'key', __CLASS__)); } if (empty($value)) { throw new Exception(AdiantiCoreTranslator::translate('The parameter (^1) of ^2 is required', 'value', __CLASS__)); } // carrega objetos do banco de dados TTransaction::open($database); // instancia um repositório de Estado $repository = new TRepository($model); if (is_null($criteria)) { $criteria = new TCriteria(); } $criteria->setProperty('order', isset($ordercolumn) ? $ordercolumn : $key); // carrega todos objetos $collection = $repository->load($criteria, FALSE); // adiciona objetos na combo if ($collection) { $items = array(); foreach ($collection as $object) { if (is_array($value)) { foreach ($value as $k => $v) { if ($k == 0) { $items[$object->{$key}] = str_pad($object->{$v}, 3, 0, STR_PAD_LEFT); } else { $items[$object->{$key}] .= ' - ' . $object->{$v}; } } } else { $items[$object->{$key}] = $object->{$value}; } } parent::addItems($items); } TTransaction::close(); }
public function __construct() { parent::__construct(); try { TTransaction::open('samples'); // abre uma transação // inicia o repositório $repository = new TRepository('Customer'); // deleta os clientes $repository->where('address', 'like', 'Rua Porto%')->where('gender', '=', 'M')->delete(); new TMessage('info', 'Registros excluídos'); TTransaction::close(); // fecha a transação. } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }
public function __construct() { parent::__construct(); try { TTransaction::open('samples'); // abre uma transação // inicia o repositório $repository = new TRepository('Customer'); // conta os clientes $count = $repository->where('name', 'like', 'Rafael%', TExpression::OR_OPERATOR)->where('name', 'like', 'Ana%', TExpression::OR_OPERATOR)->count(); new TMessage('info', "Total de clientes encontrados: {$count} <br>\n"); TTransaction::close(); // fecha a transação. } catch (Exception $e) { new TMessage('error', $e->getMessage()); } }