/** * método que adiciona filtro para a pesquisa da caixa de minutas * @param \Doctrine\ORM\QueryBuilder &$queryBuilder * @param Core_Dto_Search $dto */ protected function addWhere(\Doctrine\ORM\QueryBuilder &$queryBuilder, \Core_Dto_Search $dto) { $isDate = FALSE; $data = explode('/', $dto->getDataSearch()); if (count($data) == 3) { if (checkdate($data[1], $data[0], $data[2])) { $isDate = TRUE; $newDate = $data[2] . '-' . $data[1] . '-' . $data[0]; $queryBuilder->andWhere('vcm.dataCriacao = :data')->setParameter('data', $newDate); $queryBuilder->orWhere('vcm.prazo = :data')->setParameter('data', $newDate); } } if (!$isDate && $dto->getDataSearch() != '') { $query = mb_strtolower($dto->getDataSearch(), 'UTF-8'); $queryBuilder->andWhere('(((LOWER(vcm.tipo) like :query)'); $queryBuilder->orWhere('(LOWER(vcm.origem) like :query)'); $queryBuilder->orWhere('(LOWER(vcm.assunto) like :query)'); $queryBuilder->orWhere('(LOWER(vcm.autor) like :query)'); $queryBuilder->orWhere('(LOWER(vcm.status) like :query)))'); $queryBuilder->setParameter('query', '%' . $query . '%'); $queryBuilder->andWhere('vcm.sqStatusArtefato <> :sqStatusArtefato54')->setParameter('sqStatusArtefato54', \Core_Configuration::getSgdoceStatusExcluida()); } }
/** * Método que exclui minutas * @return NULL */ public function excluirMinutaAction() { $params['sqStatusArtefato'] = \Core_Configuration::getSgdoceStatusExcluida(); $params['sqUnidadeOrg'] = $this->getUser()->sqUnidadeOrg; $params['sqArtefato'] = $this->_getParam('sqArtefato'); $params['sqPessoa'] = $this->getUser()->sqPessoa; $params['sqOcorrencia'] = \Core_Configuration::getSqOcorrenciaExcluirMinuta(); $res = $this->alteraHistoricoArtefato($params); switch ($res) { case TRUE: $this->getMessaging()->addSuccessMessage('MN045'); return $this->_redirectActionDefault('index/view/' . $this->_getParam('view')); break; } return NULL; }