/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Respuesta::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(['idPregunta' => $this->idPregunta]);
$query->andFilterWhere(['like', 'id', $this->id])->andFilterWhere(['like', 'codFormulario', $this->codFormulario])->andFilterWhere(['like', 'descripcion', $this->descripcion]);
return $dataProvider;
}
public function destroyPregunta($id)
{
try {
$pre = Pregunta::find($id);
$list = DB::table('respuesta')->where('pregunta', '=', $pre->id)->get();
//return $list;
if (!empty($list)) {
foreach ($list as &$value) {
$res = Respuesta::find($value->id);
$res->delete();
}
}
$pre->delete();
return JsonResponse::create(array('message' => "Pregunta Eliminada Correctamente", "request" => json_encode($id)), 200);
} catch (Exception $ex) {
return JsonResponse::create(array('message' => "No se pudo Eliminar la pregunta", "exception" => $ex->getMessage(), "request" => json_encode($id)), 401);
}
}
