/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Naturezaocorrencia::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['idNatureza' => $this->idNatureza]); $query->andFilterWhere(['like', 'Nome', $this->Nome]); return $dataProvider; }
public function emAberto($params) { $query = Ocorrencia::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $idCategoriabkp = $this->idCategoria; $idNaturezabkp = $this->idNatureza; $periodobkp = $this->periodo; $databkp = $this->data; if ($this->data != null) { list($dia, $mes, $ano) = split('[/]', $this->data); $this->data = $ano . '-' . $mes . '-' . $dia; } if ($this->dataConclusao != null) { list($dia, $mes, $ano) = split('[/]', $this->dataConclusao); $this->dataConclusao = $ano . '-' . $mes . '-' . $dia; } if ($this->periodo != null) { if (strcmp($this->periodo, 'Manhã') == 0) { $this->periodo = 1; } elseif (strcmp($this->periodo, 'Tarde') == 0) { $this->periodo = 2; } elseif (strcmp($this->periodo, 'Noite') == 0) { $this->periodo = 3; } elseif (strcmp($this->periodo, 'Madrugada') == 0) { $this->periodo = 4; } } $Natureza = Naturezaocorrencia::find()->where(['nome' => $this->idNatureza])->One(); if ($Natureza != null) { $this->idNatureza = $Natureza->idNatureza; } $Categoria = Categoria::find()->where(['nome' => $this->idCategoria])->One(); if ($Categoria != null) { $this->idCategoria = $Categoria->idCategoria; } //$this->idCategoria = Categoria::findOne($this->idCategoria)->Nome; $query->andFilterWhere(['idOcorrencia' => $this->idOcorrencia, 'status' => 1, 'data' => $this->data, 'hora' => $this->hora, 'dataConclusao' => $this->dataConclusao, 'idCategoria' => $this->idCategoria, 'idSubLocal' => $this->idSubLocal, 'idNatureza' => $this->idNatureza]); $query->andFilterWhere(['like', 'periodo', $this->periodo])->andFilterWhere(['like', 'detalheLocal', $this->detalheLocal])->andFilterWhere(['like', 'descricao', $this->descricao])->andFilterWhere(['like', 'procedimento', $this->procedimento])->andFilterWhere(['like', 'cpfUsuario', $this->cpfUsuario]); $this->idCategoria = $idCategoriabkp; $this->idNatureza = $idNaturezabkp; $this->periodo = $periodobkp; $this->data = $databkp; return $dataProvider; }