public function execute() { try { $fields = array(usuarioTableClass::ID, usuarioTableClass::USER, usuarioTableClass::CREATED_AT); $orderBy = array(usuarioTableClass::USER); $page = 0; if (request::getInstance()->hasGet('page')) { $page = request::getInstance()->getGet('page') - 1; $page = $page * config::getRowGrid(); } //close if $f = array(usuarioTableClass::ID); if (request::getInstance()->hasGet('page')) { $this->page = request::getInstance()->getGet('page'); } else { $this->page = $page; } //close if $lines = config::getRowGrid(); $this->cntPages = usuarioTableClass::getAllCount($f, true, $lines); $this->objUsuarios = usuarioTableClass::getAll($fields, true, $orderBy, 'ASC', config::getRowGrid(), $page); $this->defineView('index', 'usuario', session::getInstance()->getFormatOutput()); } catch (PDOException $exc) { echo $exc->getMessage(); echo '<br>'; echo '<pre>'; print_r($exc->getTrace()); echo '</pre>'; } }
public function execute() { try { $where = null; if (request::getInstance()->hasPost('filter')) { $filter = request::getInstance()->getPost('filter'); if (isset($filter['nombre']) and $filter['nombre'] !== null and $filter['nombre'] !== '') { $where[usuarioTableClass::getNameTable() . '.' . usuarioTableClass::USER] = $filter['nombre']; } //close if // // $where[usuarioTableClass::CREATED_AT] = array( // date(config::getFormatTimestamp(), strtotime($filter['fecha_inicial'] . ' 00.00.00')), // date(config::getFormatTimestamp(), strtotime($filter['fecha_fin'] . ' 23.59.59')) // ); session::getInstance()->setAttribute('usuarioFiltersUsuario', $where); } elseif (session::getInstance()->hasAttribute('usuarioFiltersUsuario')) { $where = session::getInstance()->getAttribute('usuarioFiltersUsuario'); } //close if $fields = array(usuarioTableClass::ID, usuarioTableClass::USER, usuarioTableClass::CREATED_AT); $orderBy = array(usuarioTableClass::USER); $page = 0; if (request::getInstance()->hasGet('page')) { $page = request::getInstance()->getGet('page') - 1; $page = $page * config::getRowGrid(); } $f = array(usuarioTableClass::ID); if (request::getInstance()->hasGet('page')) { $this->page = request::getInstance()->getGet('page'); } else { $this->page = $page; } $lines = config::getRowGrid(); $this->cntPages = usuarioTableClass::getAllCount($f, true, $lines, $where); $this->objUsuarios = usuarioTableClass::getAll($fields, true, $orderBy, 'ASC', config::getRowGrid(), $page, $where); $this->defineView('index', 'usuario', session::getInstance()->getFormatOutput()); } catch (PDOException $exc) { echo $exc->getMessage(); echo '<br>'; echo '<pre>'; print_r($exc->getTrace()); echo '</pre>'; } }