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