123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384 |
- package Certificate
- import (
- "ColdVerify_local/conf"
- "ColdVerify_local/lib"
- "ColdVerify_local/logs"
- "fmt"
- orm2 "github.com/beego/beego/v2/client/orm"
- _ "github.com/go-sql-driver/mysql"
- "strconv"
- )
- type Certificate_ struct {
- Id int `orm:"column(ID)"`
- T_sn string // 编号
- T_layout_no string // 布局编号
- }
- // 获取列表
- func Read_Certificate_List(T_task_id, T_sn string, page, page_z int) ([]Certificate_, int64) {
- serverOrm := orm2.NewOrmUsingDB(conf.Server_AliasName)
- localOrm := orm2.NewOrmUsingDB(conf.Local_AliasName)
- pagez := page_z
- var offset int
- if page <= 1 {
- offset = 0
- } else {
- page -= 1
- offset = page * pagez
- }
- var maps []Certificate_
- idList := []string{}
- sql := "SELECT t_id FROM z_task_data_" + T_task_id + " GROUP BY t_id"
- fmt.Println(sql)
- _, err := localOrm.Raw(sql).QueryRows(&idList)
- if err != nil {
- logs.Error(lib.FuncName(), err)
- return maps, 0
- }
- idListStr := ""
- for _, id := range idList {
- if idListStr != "" {
- idListStr = idListStr + ","
- }
- idListStr = idListStr + "'" + id + "'"
- }
- sql_condition := " t__state=1"
- if len(idListStr) > 0 {
- sql_condition += " AND t_layout_no not in (" + idListStr + ")"
- }
- if len(T_sn) > 0 {
- sql_condition += " AND t_layout_no='" + T_sn + "'"
- }
- sql = "SELECT count(*) FROM certificate WHERE" + sql_condition
- fmt.Println(sql)
- var count int64
- err = serverOrm.Raw(sql).QueryRow(&count)
- if err != nil {
- return maps, 0
- }
- //sql = "SELECT * FROM certificate WHERE t__state=1 AND t_sn not in (" + strings.Join(snList, ",") + ") ORDER BY t_layout_no"
- // fixme 冷脸验证线上更新后再部署如下代码
- sql = "SELECT ID,t_layout_no FROM certificate WHERE" + sql_condition
- if page_z != 9999 {
- sql = sql + " LIMIT " + strconv.Itoa(offset) + "," + strconv.Itoa(pagez)
- }
- fmt.Println(sql)
- _, err = serverOrm.Raw(sql).QueryRows(&maps)
- if err != nil {
- logs.Error(lib.FuncName(), err)
- return maps, 0
- }
- return maps, count
- }
|