/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function consulta(Request $request) { $proyecto_etapa = Project::where('projects.id', '=', $request->get('project_id'))->join('project_stage', 'project_stage.project_id', '=', 'projects.id')->join('stages', 'stages.id', '=', 'project_stage.stage_id')->where('stages.id', '=', $request->get('stage_id'))->get(['project_stage.id as id', 'stages.name as name']); $actividad_etapa = Activity_Stage::where('activity_id', '=', $request->get('activity_id'))->where('stage_project_id', '=', $proyecto_etapa->last()->id)->get(); if (count($actividad_etapa) > 0) { $especificaciones = Spacification::where('activity_id', '=', $actividad_etapa->last()->id)->get(); } else { $especificaciones = ''; } $etapa = stage::where('id', '=', $request->get('stage_id'))->first(); $proyecto = Project::where('id', '=', $request->get('project_id'))->first(); $actividad = Activity::where('id', '=', $request->get('activity_id'))->first(); return response()->json(['actividad_etapa' => $actividad_etapa, 'etapa' => $etapa->name, 'especificaciones' => $especificaciones, 'proyecto' => $proyecto->name, 'actividad' => $actividad->name, 'project_id' => $proyecto->id, 'stage_id' => $etapa->id, 'activity_id' => $actividad->id, 'project_stage_id' => $proyecto_etapa->first()->id]); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $especificacion = Spacification::find($id); $especificacion->delete(); return response()->json($especificacion); }