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; } }