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