public function Data(Request $request) { $affiliates = Affiliate::select(['id', 'identity_card', 'registration', 'last_name', 'mothers_last_name', 'first_name', 'second_name', 'affiliate_state_id', 'degree_id']); if ($request->has('last_name')) { $affiliates->where(function ($affiliates) use($request) { $last_name = trim($request->get('last_name')); $affiliates->where('last_name', 'like', "%{$last_name}%"); }); } if ($request->has('mothers_last_name')) { $affiliates->where(function ($affiliates) use($request) { $mothers_last_name = trim($request->get('mothers_last_name')); $affiliates->where('mothers_last_name', 'like', "%{$mothers_last_name}%"); }); } if ($request->has('first_name')) { $affiliates->where(function ($affiliates) use($request) { $first_name = trim($request->get('first_name')); $affiliates->where('first_name', 'like', "%{$first_name}%"); }); } if ($request->has('second_name')) { $affiliates->where(function ($affiliates) use($request) { $second_name = trim($request->get('second_name')); $affiliates->where('second_name', 'like', "%{$second_name}%"); }); } if ($request->has('identity_card')) { $affiliates->where(function ($affiliates) use($request) { $identity_card = trim($request->get('identity_card')); $affiliates->where('identity_card', 'like', "%{$identity_card}%"); }); } if ($request->has('registration')) { $affiliates->where(function ($affiliates) use($request) { $registration = trim($request->get('registration')); $affiliates->where('registration', 'like', "%{$registration}%"); }); } return Datatables::of($affiliates)->addColumn('degree', function ($affiliate) { return $affiliate->degree_id ? $affiliate->degree->shortened : ''; })->editColumn('last_name', function ($affiliate) { return Util::ucw($affiliate->last_name); })->editColumn('mothers_last_name', function ($affiliate) { return Util::ucw($affiliate->mothers_last_name); })->addColumn('names', function ($affiliate) { return Util::ucw($affiliate->first_name) . ' ' . Util::ucw($affiliate->second_name); })->addColumn('state', function ($affiliate) { return $affiliate->affiliate_state->name; })->addColumn('action', function ($affiliate) { return ' <div class="btn-group" style="margin:-3px 0;"> <a href="affiliate/' . $affiliate->id . '" class="btn btn-success btn-raised btn-sm"><i class="glyphicon glyphicon-eye-open"></i></a> <a href="" data-target="#" class="btn btn-success btn-raised btn-sm dropdown-toggle" data-toggle="dropdown"><span class="caret"></span></a> <ul class="dropdown-menu"> <li><a href="selectgestaporte/' . $affiliate->id . '" style="padding:3px 10px;"><i class="glyphicon glyphicon-plus"></i> Aporte</a></li> <li role="separator" class="divider"></li> <li><a href="tramite_fondo_retiro/' . $affiliate->id . '" style="padding:3px 10px;"><i class="glyphicon glyphicon-plus"></i> Trámite FR</a></li> </ul> </div>'; })->make(true); }
public function getTittleName() { return Util::ucw($this->first_name) . ' ' . Util::ucw($this->second_name) . ' ' . Util::ucw($this->last_name) . ' ' . Util::ucw($this->mothers_last_name) . ' ' . Util::ucw($this->surname_husband); }