/**
* 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;
}
/**
* Finds the Naturezaocorrencia model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Naturezaocorrencia the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Naturezaocorrencia::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
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;
}
public function afterFind()
{
list($ano, $mes, $dia) = split('[-]', $this->data);
$this->data = $dia . '/' . $mes . '/' . $ano;
if ($this->dataConclusao != null) {
list($ano, $mes, $dia) = split('[-]', $this->dataConclusao);
$this->dataConclusao = $dia . '/' . $mes . '/' . $ano;
}
if ($this->hora != null) {
list($hora, $minuto, $segundos) = split('[:]', $this->hora);
$this->hora = $hora . ':' . $minuto;
}
$foto = FotoController::getFotoOcorrencia($this->idOcorrencia);
if ($foto != null) {
$this->comentarioFoto = $foto[0]->comentario;
}
$this->idCategoriabkp = $this->idCategoria;
// echo "Categoria bkp".$this->idCategoriabkp;
$this->idSubLocalbkp = $this->idSubLocal;
$this->idNaturezabkp = $this->idNatureza;
$sublocal = Sublocal::findOne($this->idSubLocal);
$this->idLocal = $sublocal->idLocal;
$this->cpfbkp = $this->cpfUsuario;
$this->idSubLocal = Sublocal::findOne($this->idSubLocal)->Nome;
$this->cpfUsuario = User::findOne($this->cpfUsuario)->nome;
$this->idNatureza = Naturezaocorrencia::findOne($this->idNatureza)->Nome;
$this->idCategoria = Categoria::findOne($this->idCategoria)->Nome;
if ($this->status == 1) {
$this->status = 'Aberto';
} elseif ($this->status == 2) {
$this->status = 'Solucionado';
} elseif ($this->status == 3) {
$this->status = 'Não Solucionado';
}
if ($this->periodo == 1) {
$this->periodo = 'Manhã';
} elseif ($this->periodo == 2) {
$this->periodo = 'Tarde';
} elseif ($this->periodo == 3) {
$this->periodo = 'Noite';
} elseif ($this->periodo == 4) {
$this->periodo = 'Madrugada';
}
}
