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 init() { $this->addElement('text', 'descricao', array('label' => 'Descrição*', 'class' => 'campo-txt', 'required' => true)); $galeriasModel = new Application_Model_Galerias(); $galerias = $galeriasModel->fetchAll($galeriasModel->select()->from($galeriasModel->info(Zend_Db_Table_Abstract::NAME))->columns(array('nome'))->where('excluido = 0')); $galeriasArr = array(); foreach ($galerias as $galeria) { $galeriasArr[$galeria['nome']] = $galeria['nome']; } $this->addElement('select', 'galeria', array('label' => 'Galeria: ', 'multiple' => false, 'multiOptions' => $galeriasArr, 'registerInArrayValidator' => false)); $this->addElement('file', 'pFoto', array('label' => 'Foto*', 'required' => true)); $this->addElement('submit', 'submit_button', array('label' => 'Salvar', 'class' => 'bt-enviar', 'ignore' => true)); }
public function removergaleriaAction() { $id = $this->_request->getParam('id'); $confirma = $this->_request->getParam('confirma'); if (isset($confirma)) { if ($confirma == 1) { $galeriasModel = new Application_Model_Galerias(); $galeriasModel->update(array('excluido' => '1'), 'id_galeria = ' . $id); } return $this->_helper->redirector('index'); } else { $this->view->id = $this->_request->getParam('id'); $galeriasModel = new Application_Model_Galerias(); $nome_galeria = $galeriasModel->fetchAll($galeriasModel->select()->from($galeriasModel->info(Zend_Db_Table_Abstract::NAME))->columns(array('nome'))->where('id_galeria = ?', $id)); $this->view->galeria = $nome_galeria; } }