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