public static function beneficiarios($id) { return Beneficiary::join('projects', 'projects.id', '=', 'beneficiaries.project_id')->leftJoin('advanceds', 'advanceds.beneficiary_id', '=', 'beneficiaries.id')->where('projects.id', '=', $id)->orderBy('beneficiaries.id', 'ASC')->groupBy('beneficiaries.id')->get(['beneficiaries.*', DB::raw("GROUP_CONCAT(advanceds.state SEPARATOR ',') AS state")]); }
public function avanceProyecto(Request $request) { $beneficiairios = Beneficiary::join('projects', 'projects.id', '=', 'beneficiaries.project_id')->where('projects.id', '=', $request->get('id'))->select('beneficiaries.*')->get(); return response()->json($beneficiairios); }