列的使用

默认隐藏列

info.AddField("Name", "name", db.Varchar).FieldSortable()

设置为固定

info.AddField("Name", "name", db.Varchar).FieldFixed()

设置筛选的操作符与操作表单类型：

// 设置操作符为like，模糊查询
info.AddField("Name", "name", db.Varchar).FieldFilterable(types.FilterType{Operator: types.FilterOperatorLike})
// 设置为单选类型
info.AddField("Gender", "gender", db.Tinyint).
    FieldFilterOptions([]map[string]string{
        {"value": "0", "field": "men"},
        {"value": "1", "field": "women"},
    }).FieldFilterOptionExt(map[string]interface{}{"allowClear": true})
// 设置为时间范围类型，范围查询
info.AddField("CreatedAt", "created_at", db.Timestamp).FieldFilterable(types.FilterType{FormType: form.DatetimeRange})

字符串操作

限制输出长度

info.AddField("Name", "name", db.Varchar).FieldLimit(10)

info.AddField("Name", "name", db.Varchar).FieldToTitle()

去除空格

字符串截取

info.AddField("Name", "name", db.Varchar).FieldSubstr(0, 3)

info.AddField("Name", "name", db.Varchar).FieldToUpper()

字符串转小写

info.AddField("Name", "name", db.Varchar).FieldToLower()

如果想要全局进行过滤操作

如果想要在表格或表单显示层面进行过滤操作

info := table.NewDefaultTable(...).GetInfo()
info.AddLimitFilter(limit int)
info.AddTrimSpaceFilter()
info.AddToTitleFilter()
info.AddToLowerFilter()
info.AddXssFilter()
info.AddXssJsFilter()
form := table.NewDefaultTable(...).GetForm()
form.AddLimitFilter(limit int)
form.AddTrimSpaceFilter()
form.AddSubstrFilter(start int, end int)
form.AddToTitleFilter()
form.AddToUpperFilter()
form.AddToLowerFilter()
form.AddXssFilter()