/**
* 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]);
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request)
{
if (empty($request->get('name'))) {
return response()->json(['bad' => 'empty']);
}
$stage = stage::where('name', '=', $request->get('name'))->whereNotIn('id', [$request->get('id')])->first();
$identificador = stage::where('identificador', '=', $request->get('identificador'))->whereNotIn('id', [$request->get('id')])->first();
if ($stage == null) {
if ($identificador == null) {
$stage = stage::find($request->get('id'));
$stage->fill($request->all());
$stage->save();
return response()->json(['good' => 'good', 'data' => $stage]);
} else {
return response()->json(['bad' => 'id']);
}
} else {
return response()->json(['bad' => 'exists']);
}
}
