public function search($input) { $query = PermissionRole::query(); $columns = Schema::getColumnListing('permission_roles'); $attributes = array(); foreach ($columns as $attribute) { $attributes[$attribute] = null; if (isset($input[$attribute]) and !empty($input[$attribute])) { $query->where($attribute, $input[$attribute]); $attributes[$attribute] = $input[$attribute]; } } /* ** Filter */ $this->filter($input, $query); /* ** Get count */ $total = $query->count(); /* ** Pagination */ $this->pagination($input, $query); /* ** Order */ $this->order($input, $query); return [$query->get(), $attributes, 'total' => $total]; }
public function getPermissionRole() { $query = \App\Models\PermissionRole::query()->where('role_id', $this->id)->get(); $results = []; foreach ($query as $key => $val) { $results[$key] = $val->permission->slug_view; } return $results; }