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