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