/**
* Return the issue notes
*/
public function get_notes()
{
$repos = new TRepository('Note');
$criteria = new TCriteria();
$criteria->add(new TFilter('id_issue', '=', $this->id));
return $repos->load($criteria);
}
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);
}
/**
* 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 get_listOfMaterialConsumo()
{
$criteria = new TCriteria();
$criteria->add(new TFilter('tipo_material_consumo_id', '=', $this->id));
$repository = new TRepository('MaterialConsumo');
return $repository->load($criteria);
}
public function get_listOfMaterialPermanente()
{
$criteria = new TCriteria();
$criteria->add(new TFilter('tipo_material_permanente_id', '=', $this->id));
$repository = new TRepository('MaterialPermanente');
return $repository->load($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;
}
/**
* 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();
}
/**
* Load the object and its aggregates
* @param $id object ID
*/
public function load($id)
{
// load the related Contact objects
$repository = new TRepository('Contact');
$criteria = new TCriteria();
$criteria->add(new TFilter('customer_id', '=', $id));
$this->contacts = $repository->load($criteria);
// load the object itself
return parent::load($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];
}
}
/**
* 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;
}
}
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);
}
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;
}
/**
* 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;
}
}
/**
* 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 load($id)
{
$repository = new TRepository('ImovelProprietarios');
$criteria = new TCriteria();
$criteria->add(new TFilter('tb_imovel_imovel_id', '=', $id));
$imovelproprietario = $repository->load($criteria);
if ($imovelproprietario) {
foreach ($imovelproprietario as $imovelproprietarios) {
$proprietario = new Contribuinte($imovelproprietarios->tb_contribuinte_contribuinte_id);
$this->addProprietario($proprietario);
}
}
return parent::load($id);
}
public function load($id)
{
$repository = new TRepository('LogradouroBairro');
$criteria = new TCriteria();
$criteria->add(new TFilter('tb_logradouros_logra_id', '=', $id));
$logradourobairro = $repository->load($criteria);
if ($logradourobairro) {
foreach ($logradourobairro as $logradourobairros) {
$bairro = new Bairro($logradourobairros->tb_bairros_bairros_id);
$this->addBairro($bairro);
}
}
// load the object itself
return parent::load($id);
}
/**
* Method getSystem_programs
* Return the System_group' System_program's
* @return Collection of System_program
*/
public function getSystemPrograms()
{
$system_programs = array();
// load the related System_program objects
$repository = new TRepository('SystemGroupProgram');
$criteria = new TCriteria();
$criteria->add(new TFilter('system_group_id', '=', $this->id));
$system_group_system_programs = $repository->load($criteria);
if ($system_group_system_programs) {
foreach ($system_group_system_programs as $system_group_system_program) {
$system_programs[] = new SystemProgram($system_group_system_program->system_program_id);
}
}
return $system_programs;
}
/**
* Load the object and its aggregates
* @param $id object ID
*/
public function load($id)
{
// load the related Skill objects
$repository = new TRepository('CustomerSkill');
$criteria = new TCriteria();
$criteria->add(new TFilter('customer_id', '=', $id));
$customer_skills = $repository->load($criteria);
if ($customer_skills) {
foreach ($customer_skills as $customer_skill) {
$skill = new Skill($customer_skill->skill_id);
$this->addSkill($skill);
}
}
// load the object itself
return parent::load($id);
}
/**
* Load the object and its aggregates
* @param $id object ID
*/
public function load($id)
{
// load the related System_program objects
$repository = new TRepository('SystemGroupProgram');
$criteria = new TCriteria();
$criteria->add(new TFilter('system_group_id', '=', $id));
$system_group_system_programs = $repository->load($criteria);
if ($system_group_system_programs) {
foreach ($system_group_system_programs as $system_group_system_program) {
$system_program = new SystemProgram($system_group_system_program->system_program_id);
$this->addSystemProgram($system_program);
}
}
// load the object itself
return parent::load($id);
}
/**
* 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);
}
/**
* 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');
$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());
}
}
/**
* method onGenerate()
* Executed whenever the user clicks at the generate button
*/
function onGenerate()
{
try {
// open a transaction with database 'samples'
TTransaction::open('samples');
// load all customers
$repository = new TRepository('Customer');
$criteria = new TCriteria();
$customers = $repository->load($criteria);
$data = $this->form->getData();
$this->form->validate();
$designer = new TPDFDesigner();
$designer->fromXml('app/reports/report.pdf.xml');
$designer->generate();
$fill = TRUE;
$designer->gotoAnchorXY('details');
$designer->SetFont('Arial', '', 10);
$designer->setFillColorRGB('#F9F9FF');
if ($customers) {
foreach ($customers as $customer) {
$designer->gotoAnchorX('details');
$designer->Cell(34, 12, $customer->id, 1, 0, 'C', $fill);
$designer->Cell(160, 12, utf8_decode($customer->name), 1, 0, 'L', $fill);
$designer->Cell(152, 12, utf8_decode($customer->address), 1, 0, 'L', $fill);
$designer->Cell(152, 12, utf8_decode($customer->city_name), 1, 0, 'L', $fill);
$designer->Ln(12);
// grid background
$fill = !$fill;
}
}
$file = 'app/output/pdf_report.pdf';
if (!file_exists($file) or is_writable($file)) {
$designer->save($file);
parent::openFile($file);
} else {
throw new Exception(_t('Permission denied') . ': ' . $file);
}
new TMessage('info', 'Report generated. Please, enable popups in the browser (just in the web).');
// close the transaction
TTransaction::close();
} catch (Exception $e) {
new TMessage('error', '<b>Error</b> ' . $e->getMessage());
TTransaction::rollback();
}
}
public function __construct()
{
parent::__construct();
try {
TTransaction::open('samples');
$criteria = new TCriteria();
$criteria->add(new TFilter('city_id', '=', '4'));
$repository = new TRepository('Customer');
$customers = $repository->load($criteria);
foreach ($customers as $customer) {
$customer->phone = '84 ' . substr($customer->phone, 3);
$customer->store();
}
new TMessage('info', 'Records updated');
TTransaction::close();
} catch (Exception $e) {
new TMessage('error', $e->getMessage());
}
}
public function start()
{
$this->status = true;
while ($this->status) {
try {
TTransaction::open($this->banco);
$repo = new TRepository($this->model);
$this->obj = $repo->load($this->criteria);
TTransaction::close();
if ($this->obj) {
return $this->obj;
$this->status = false;
}
} catch (Exception $e) {
throw new Exception();
}
sleep($this->timer);
}
}
public function __construct()
{
parent::__construct();
try {
TTransaction::open('samples');
// abre uma transação
$criteria = new TCriteria();
$criteria->setProperty('limit', 10);
$criteria->setProperty('offset', 20);
$criteria->setProperty('order', 'id');
$repository = new TRepository('Customer');
$customers = $repository->load($criteria);
foreach ($customers as $customer) {
echo $customer->id . ' - ' . $customer->name . '<br>';
}
TTransaction::close();
// fecha a transação.
} catch (Exception $e) {
new TMessage('error', $e->getMessage());
}
}
/**
* Return members by project
*/
public function getMembers($roles = NULL)
{
$members = array();
$repos = new TRepository('Member');
$criteria = new TCriteria();
$criteria->add(new TFilter('active', '=', 'Y'));
$objects = $repos->load($criteria);
if ($objects) {
foreach ($objects as $object) {
if ($object->getProjects()) {
// IF no role is specified OR the ROLE is within $roles
if (is_null($roles) or is_array($roles) and in_array($object->role_mnemonic, $roles)) {
$member_projects_ids = array_keys($object->getProjectsList());
if (in_array($this->id, $member_projects_ids)) {
$members[] = $object;
}
}
}
}
}
return $members;
}
function onReload()
{
// inicia transação com o banco 'pg_livro'
TTransaction::open('pg_livro');
// instancia um repositório para Pessoa
$repository = new TRepository('Pessoa');
// cria um critério, definindo a ordenação
$criteria = new TCriteria();
$criteria->setProperty('order', 'id');
// carrega os objetos $pessoas
$pessoas = $repository->load($criteria);
$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;
}
/**
* 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
*/
public function __construct($name, $database, $model, $key, $value)
{
// 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', $key);
// 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();
}
