public function indexAction()
{
$galeriasModel = new Application_Model_Galerias();
$this->view->galerias = $galeriasModel->fetchAll($galeriasModel->select()->where('excluido = 0'));
$galeriaModel = new Application_Model_Galeria();
$this->view->galeria = $galeriaModel->fetchAll($galeriaModel->select()->where('excluido = 0'));
$busca = $this->_request->getParam('busca');
$galeria = $this->_request->getParam('galeria');
}
public function indexAction()
{
$this->view->headTitle('Galeria');
$galeriasModel = new Application_Model_Galerias();
$nome_galerias = $galeriasModel->fetchAll($galeriasModel->select()->from($galeriasModel->info(Zend_Db_Table_Abstract::NAME))->columns(array('nome'))->where('excluido = 0'));
$this->view->nome_galerias = $nome_galerias;
$galeriaModel = new Application_Model_Galeria();
$busca = $this->_request->getParam('galeria');
// $this->view->busca = $nome_evento;
$galeria = $galeriaModel->fetchAll($galeriaModel->select()->where('galeria LIKE :busca')->where('excluido = 0')->bind(array('busca' => '%' . $busca . '%')));
$this->view->galeria = $galeria;
}
public function removerAction()
{
$id = $this->_request->getParam('id');
$confirma = $this->_request->getParam('confirma');
$galeriaModel = new Application_Model_Galeria();
if (isset($confirma)) {
if ($confirma == 1) {
$galeriaModel->update(array('excluido' => '1'), 'id_foto = ' . $id);
unlink(APPLICATION_PATH . '/../galeria_fotos/' . $id . '.jpg');
unlink(APPLICATION_PATH . '/../galeria_fotos/thumbs/' . $id . '.jpg');
}
return $this->_helper->redirector('index');
} else {
$this->view->id = $this->_request->getParam('id');
$galeriaModel = new Application_Model_Galeria();
$nome_galeria = $galeriaModel->fetchAll($galeriaModel->select()->from($galeriaModel->info(Zend_Db_Table_Abstract::NAME))->columns(array('descricao'))->where('id_foto = ?', $id));
$this->view->galeria = $nome_galeria;
}
}
