public function getTweets()
{
$entity_id = $this->_entity->getId();
$entity_tbl = $this->_entity->getTbl();
$select = new Select('tweet');
$select->addField('date');
$select->addField('msg');
$select->inner_join('id_tweet', Select::construct("r_{$entity_tbl}_tweet"));
$select->where(array("b.{$entity_id} = ?" => $this->getId()));
$select->order_by('date DESC');
$result = $this->_dao->select($select);
return $result;
}
public function batch_delete($id_photo, $gallery_sequence)
{
$arr_criteria = array("{$this->_id_photo} = ?" => $id_photo, "{$this->_id_photo_item} NOT IN (?)" => $gallery_sequence);
$select = new Select($this->_photo_item);
$select->addField($this->_id_photo_item);
$select->where($arr_criteria);
$result = $this->_dao->select($select);
foreach ($result as $row) {
Folder::delete("public/system/uploads/{$this->_photo}/{$id_photo}/{$this->_photo_item}/{$row[$this->_id_photo_item]}");
}
$this->_dao->delete($this->_photo_item, $arr_criteria);
}
public function getList()
{
$arrCriteria = array('a.admin LIKE ?' => '%' . $this->_filters['admin'] . '%', 'a.description LIKE ?' => '%' . $this->_filters['description'] . '%');
if ($this->_filters['action'] != '0' && $this->_filters['action'] != '') {
$arrCriteria['a.action = ?'] = $this->_filters['action'];
}
if ($this->_filters['tbl'] != '0' && $this->_filters['tbl'] != '') {
$arrCriteria['a.tbl = ?'] = $this->_filters['tbl'];
}
//$arrCriteria['a.name IN (?)'] = array_keys($this->getDropdownName());
$select = new Select('log');
$select->addField('id_log');
$select->addField('admin');
$select->addField('tbl');
$select->addField('inc_date');
$select->addField('action');
$select->addField('description');
$select->where($arrCriteria);
$select->order_by('a.inc_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]['action'] = Arrays::$logAcao[$row['action']];
$result[$i]['inc_date'] = DateFormat::filter_date($row['inc_date'], 'd/m/Y H:i:s');
$entity = $this->_entities->getEntity($row['tbl']);
$result[$i]['tbl'] = $entity->getSection();
}
return $result;
}
protected function validateToken($id, $v)
{
$select = new Select('admin');
$select->addField('password_change_date');
$select->where(array('id_admin = ?' => $id));
$result = $this->_dao->select($select);
if (!count($result)) {
return $v->addException('Token inválido, por favor gere um novo link de recuperação');
}
$time_inicial = strtotime(date('Y-m-d'));
$time_final = strtotime($result[0]['password_change_date']);
$diferenca = $time_final - $time_inicial;
$dias = (int) floor($diferenca / (60 * 60 * 24));
if ($dias !== 0) {
return $v->addException('Token expirado, por favor gere um novo link de recuperação');
}
}
public function deleteChildren(Entity $entity, $id)
{
$entity_id = $entity->getId();
$children = $entity->getChildren();
foreach ($children as $child) {
$child_entity = $this->_entities->getEntity($child);
$child_tbl = $child_entity->getTbl();
$child_id = $child_entity->getId();
$child_model = $child_entity->getModel();
$select = new Select($child_tbl);
$select->addField($child_id, 'id_children');
$select->where(array($entity_id . ' = ? ' => $id));
$result = $this->_dao->select($select);
$arr_delete = array();
foreach ($result as $row) {
$arr_delete[] = array('name' => $child_tbl, 'id' => $row['id_children']);
}
$child_model->delete($arr_delete);
}
}
private function getIdByTitle($row)
{
$fe_tbl = $this->_foreign_entity->getTbl();
$fe_id = $this->_foreign_entity->getId();
$fe_title = $this->_foreign_entity->getTitle();
$arrCriteria["{$fe_title} = ?"] = $row;
$select = new Select($fe_tbl);
$select->addField($fe_id, 'id');
$select->where($arrCriteria);
$result = $this->_dao->select($select);
return count($result) ? $result[0]['id'] : false;
}
public function deleteChildrens(Entity $entity, $id, $tableHistory)
{
$entity_id = $entity->getId();
$entity_tbl = $entity->getTbl();
$children = $entity->getChildren();
// verificia se é página infinita para deletar uma filha dela caso exista
if (array_key_exists('id_parent', $tableHistory)) {
$model = $entity->getModel();
$select = new Select($entity_tbl);
$select->addField($entity_id, 'id');
$select->where(array('id_parent = ?' => $tableHistory[$entity_id]));
$result = $this->_dao->select($select);
$arr_delete = array();
foreach ($result as $row) {
$arr_delete[] = array('name' => $entity_tbl, 'id' => $row['id']);
}
$this->delete($arr_delete);
}
//
foreach ($children as $child) {
$child_entity = $this->_entities->getEntity($child);
$child_tbl = $child_entity->getTbl();
$child_id = $child_entity->getId();
$select = new Select($child_tbl);
$select->addField($child_id, 'id_children');
$select->where(array($entity_id . ' = ? ' => $id));
$result = $this->_dao->select($select);
$arr_delete = array();
foreach ($result as $row) {
$arr_delete[] = array('name' => $child_tbl, 'id' => $row['id_children']);
}
$this->delete($arr_delete);
}
}
