public function getJson($input) { $table = 'roles as a'; $select = 'a.*'; $replace_field = [['old_name' => 'name', 'new_name' => 'a.name']]; $param = ['input' => $input, 'select' => $select, 'table' => $table, 'replace_field' => $replace_field]; $datagrid = new Datagrid(); $data = $datagrid->datagrid_query($param, function ($data) { return $data; }); return $data; }
public function getJson($input) { $table = 'users as a'; $select = 'a.*'; $replace_field = [['old_name' => 'first_name', 'new_name' => 'a.first_name'], ['old_name' => 'last_name', 'new_name' => 'a.last_name'], ['old_name' => 'activated', 'new_name' => 'a.activated'], ['old_name' => 'phone_number', 'new_name' => 'a.phone_number']]; $param = ['input' => $input, 'select' => $select, 'table' => $table, 'replace_field' => $replace_field]; $datagrid = new Datagrid(); $data = $datagrid->datagrid_query($param, function ($data) { return $data; }); foreach ($data["rows"] as $key => $row) { $data["rows"][$key]->role_id = Sentinel::findUserById($data["rows"][$key]->id)->getRoles()->first()->id; } return $data; }