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