<?php

namespace App\Http\Controllers\Permission;

// Laravel Specifics
use Illuminate\Http\Request;
use DB;

// Creatia Specifics
use App\Http\Controllers\BaseController;
use App\Models\Group;

class Controller extends BaseController {

    public function get_groups(Request $_r) {
        return $this->paged_table($_r, function() {
            return Group::select('groups.id', 'name')
                ->where('user_visible', '=', '1')
                ->leftJoin('group_permissions', 'groups.id', '=', 'group_id')
                ->groupBy('groups.id');
        }, [ 
            'name' => [ 'db' => 'name', 'searchable' => true ]
        ], 'created_at', null);
    }
}