1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374 |
- package System
- import (
- "ColdVerify_server/logs"
- "github.com/beego/beego/v2/adapter/orm"
- orm2 "github.com/beego/beego/v2/client/orm"
- "time"
- )
- type Logs struct {
- Id int `orm:"column(ID);size(11);auto;pk"`
- Logs_class string `orm:"size(256);null"`
- Logs_Title string `orm:"size(256);null"`
- Logs_Txt string `orm:"type(text);null"`
- CreateTime time.Time `orm:"column(create_time);type(timestamp);null;auto_now_add"`
- UpdateTime time.Time `orm:"column(update_time);type(timestamp);null;auto_now"`
- }
- type L_JSON struct {
- }
- func (t *Logs) TableName() string {
- return "logs"
- }
- func init() {
-
- orm.RegisterModel(new(Logs))
- }
- func Add_Logs(Logs_class string, Logs_Title string, Logs_Txt string) {
- o := orm.NewOrm()
- m := Logs{Logs_class: Logs_class, Logs_Title: Logs_Title, Logs_Txt: Logs_Txt}
- o.Insert(&m)
- }
- func Read_Logs_ALL(page, page_z int, Logs_class string) (r []Logs, cnt int64) {
- o := orm.NewOrm()
-
- qs := o.QueryTable(new(Logs))
- var offset int64
- if page <= 1 {
- offset = 0
- } else {
- offset = int64((page - 1) * page_z)
- }
- qs.Limit(page_z, offset).Filter("Logs_class__icontains", Logs_class).OrderBy("-Id").All(&r)
- cnt, _ = qs.Filter("Logs_class__icontains", Logs_class).Count()
- return r, cnt
- }
- type CLASS_lists struct {
- Logs_class string
- }
- func Read_Logs_Class() (lists orm2.ParamsList) {
- o := orm.NewOrm()
- var pl_lists orm2.ParamsList
- num, err := o.Raw("SELECT DISTINCT logs_class FROM Logs LIMIT 0,1000").ValuesFlat(&pl_lists)
- if err == nil {
- logs.Println("user nums: ", num)
- }
- return pl_lists
- }
|