/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$especificaciones = Spacification::leftJoin('activity_stage', 'activity_stage.id', '=', 'spacifications.activity_stage_id')->leftJoin('activities', 'activities.id', '=', 'activity_stage.activity_id')->orderBy('spacifications.name', 'DESC')->get(['spacifications.*', 'activities.name as actividad']);
$actividades = Activity::join('activity_stage', 'activity_stage.activity_id', '=', 'activities.id')->leftJoin('stages', 'stages.id', '=', 'activity_stage.stage_id')->orderBy('activities.name', 'ASC')->groupBy('activities.id')->get(['activity_stage.id as id', 'activities.name as name', 'stages.name as n_stage']);
return response()->json([$especificaciones, $actividades]);
}
