public function getList()
{
$itens = $this->_entities->getTrashItens();
if ($this->_filters['section'] != '' && $this->_filters['section'] != '0') {
$itens = array($itens[$this->_filters['section']]);
}
$i = 0;
foreach ($itens as $item) {
$table_name = $item->getTbl();
$id_field = $item->getId();
$title_field = $item->getTitle();
$section = $item->getSection();
$select1 = new Select($table_name);
$select1->addField($id_field, 'id');
$select1->addField($title_field, 'title');
$select1->addField('del_date');
$select1->addSField('section', $section);
$select1->addSField('entity_name', $table_name);
$select1->where(array('is_del = 1' => null, $title_field . ' LIKE ?' => '%' . $this->_filters['title'] . '%'));
if ($i == 0) {
$select = $select1;
} else {
$select->union($select1);
}
$i++;
}
$select->order_by('del_date DESC');
$this->_paginator = new PaginatorAdmin($this->_itens_per_page, $this->_filters['pag']);
$this->setPaginationSelect($select);
$result = $this->_dao->select($select);
foreach ($result as $i => $row) {
$result[$i]['del_date'] = DateFormat::filter_date($row['del_date'], 'd/m/Y H:i');
}
return $result;
}
