types

type Column struct {
	Name  string      `json:"name"`  // column name
	Exp   string      `json:"exp"`   // expressions, which default to = when the value is null, have =, ! =, >, >=, <, <=, like
	Value interface{} `json:"value"` // column value
	Logic string      `json:"logic"` // logical type, defaults to and when value is null, only &(and), ||(or)
}

type CreateUserExampleRequest struct {
	Name     string `json:"name" binding:"min=2"`         // username
	Email    string `json:"email" binding:"email"`        // email
	Password string `json:"password" binding:"md5"`       // password
	Phone    string `form:"phone" binding:"e164"`         // phone number, e164 means <+ country code> <cell phone number>.
	Avatar   string `form:"avatar" binding:"min=5"`       // avatar
	Age      int    `form:"age" binding:"gt=0,lt=120"`    // age
	Gender   int    `form:"gender" binding:"gte=0,lte=2"` // gender, 1:Male, 2:Female, other values:unknown
}

type GetUserExampleByIDRespond struct {
	ID        string    `json:"id"`         // id
	Name      string    `json:"name"`       // username
	Email     string    `json:"email"`      // email
	Phone     string    `json:"phone"`      // phone number
	Avatar    string    `json:"avatar"`     // avatar
	Age       int       `json:"age"`        // age
	Gender    int       `json:"gender"`     // gender, 1:Male, 2:Female, other values:unknown
	Status    int       `json:"status"`     // account status, 1:inactive, 2:activated, 3:blocked
	LoginAt   int64     `json:"login_at"`   // login timestamp
	CreatedAt time.Time `json:"created_at"` // create time
	UpdatedAt time.Time `json:"updated_at"` // update time
}

type GetUserExamplesByIDsRequest struct {
	IDs []uint64 `json:"ids" binding:"min=1"` // id list
}

type GetUserExamplesRequest struct {
	query.Params // query parameters
}

type ListUserExamplesRespond []struct {
	GetUserExampleByIDRespond
}

type Params struct {
	Page int    `form:"page" binding:"gte=0" json:"page"`      // page number, starting from page 0
	Size int    `form:"size" binding:"gt=0" json:"size"`       // lines per page
	Sort string `form:"sort" binding:"" json:"sort,omitempty"` // sorted fields, multi-column sorting separated by commas

	Columns []Column `json:"columns,omitempty"` // query conditions
}

type Result struct {
	Code int         `json:"code"` // return code
	Msg  string      `json:"msg"`  // return information description
	Data interface{} `json:"data"` // return data
}

type UpdateUserExampleByIDRequest struct {
	ID       uint64 `json:"id" binding:"-"`      // id
	Name     string `json:"name" binding:""`     // username
	Email    string `json:"email" binding:""`    // email
	Password string `json:"password" binding:""` // password
	Phone    string `form:"phone" binding:""`    // phone number
	Avatar   string `form:"avatar" binding:""`   // avatar
	Age      int    `form:"age" binding:""`      // age
	Gender   int    `form:"gender" binding:""`   // gender, 1:Male, 2:Female, other values:unknown
}