package Template

import (
	"Cold_Api/conf"
	"fmt"
	"github.com/beego/beego/v2/adapter/orm"
	_ "github.com/go-sql-driver/mysql"
	"time"
)

// 模板
type Template struct {
	Id                int    `orm:"column(ID);size(11);auto;pk"`

	T_name       string `orm:"size(256);null"`  // 标题
	T_class      int    `orm:"size(200);null"`  // 分类
	T_img        string `orm:"size(256);null"`  // 图片
	T_int    int    `orm:"size(200);null"`  	//  数量
	T_text       string `orm:"type(text);null"` // 详情

	T_Visit             int    `orm:"size(200);1"`     // 浏览量
	T_State       int    `orm:"size(2);1"`       // 0 删除   1 正常
	CreateTime time.Time `orm:"column(create_time);type(timestamp);null;auto_now_add"`   //auto_now_add 第一次保存时才设置时间
	UpdateTime time.Time `orm:"column(update_time);type(timestamp);null;auto_now"`   //auto_now 每次 model 保存时都会对时间自动更新
}

func (t *Template) TableName() string {
	return "Template" // 数据库名称   // ************** 替换 FormulaList **************
}

func init() {
	//注册模型
	orm.RegisterModel(new(Template))

}

// ---------------- 特殊方法 -------------------
// 修改
func Update_TTemplate(r Template, cols ...string) bool {
	o := orm.NewOrm()
	if num, err := o.Update(&r, cols...); err == nil {
		fmt.Println("Number of records updated in database:", num)
		return true
	}
	return false
}
// 获取 ById
func Read_List_ById(id int) (r Template) {
	o := orm.NewOrm()
	r = Template{Id: id}
	err := o.Read(&r) // o.Read(&r,"Tokey") 如果不是 主键 就得指定字段名
	if err != nil {
		fmt.Println(err)
	}
	return r
}

// 添加
func Add_List(m Template) (id int64, err error) {
	o := orm.NewOrm()
	id, err = o.Insert(&m)
	if err != nil {
		fmt.Println(err)
	}
	return id, err
}

// 删除
func Delete_List_ById(id int) (err error) {
	o := orm.NewOrm()
	v := Template{Id: id}
	// ascertain id exists in the database
	if err = o.Read(&v); err == nil {
		var num int64
		if num, err = o.Delete(&Template{Id: id}); err == nil {
			fmt.Println("Number of records deleted in database:", num)
		}
	}
	return
}
// 删除
func Delete_List(m Template) (err error) {
	o := orm.NewOrm()
	if num, err := o.Delete(&m); err == nil {
		fmt.Println("Number of records deleted in database:", num)
	}

	return
}

// 修改
func Update_List_ById(m Template) (err error) {
	o := orm.NewOrm()
	v := Template{Id: m.Id}
	// ascertain id exists in the database
	if err = o.Read(&v); err == nil {
		var num int64
		v.T_State = 0
		if num, err = o.Update(&v, "T_State"); err == nil {
			fmt.Println("Number of records updated in database:", num)
		}
	}
	return err
}

// 获取列表
func Read_List_1(page int,name string,class int) (r []Template,cnt int64) {

	o := orm.NewOrm()
	// 也可以直接使用 Model 结构体作为表名

	qs := o.QueryTable(new(Template))
	var offset int64
	if page <= 1 {
		offset = 0
	} else {
		offset = int64((page - 1) * conf.Page_size)
	}

	if class == 0 {
		qs.Limit(conf.Page_size, offset).Filter("T_name__icontains", name).OrderBy("-Id").Filter("T_State", 1).All(&r)
		cnt, _ = qs.Filter("T_name__icontains", name).Filter("T_State", 1).Count()
	} else {
		qs.Limit(conf.Page_size, offset).Filter("T_name__icontains", name).Filter("T_class", class).Filter("T_State", 1).OrderBy("-Id").All(&r)
		cnt, _ = qs.Filter("T_name__icontains", name).Filter("T_class", class).Filter("T_State", 1).Count()
	}

	return r,cnt
}
// 获取列表 /时间筛选  Time_start_ Time_end_    2021-12-30，所以下面要加后缀 时间
func Read_DeviceWarning_1(page int, T_sn string, T_Title string,Time_start_ string,Time_end_ string) (r []Template, cnt int64) {

	o := orm.NewOrm()
	// 也可以直接使用 Model 结构体作为表名

	qs := o.QueryTable(new(Template))
	var offset int64
	if page <= 1 {
		offset = 0
	} else {
		offset = int64((page - 1) * conf.Page_size)
	}

	if(len(Time_start_) > 1 && len(Time_end_) > 1 ) {
		fmt.Println(Time_start_,Time_end_)
		qs.Limit(conf.Page_size, offset).Filter("T_Ut__lte", Time_end_+" 23:59:59").Filter("T_Ut__gte", Time_start_+" 00:00:00").Filter("T_Title__icontains", T_Title).Filter("T_sn__icontains", T_sn).OrderBy("-Id").Filter("T_State", 1).All(&r)
		cnt, _ = qs.Filter("T_Ut__lte", Time_end_+" 23:59:59").Filter("T_Ut__gte", Time_start_+" 00:00:00").Filter("T_Title__icontains", T_Title).Filter("T_sn__icontains", T_sn).Filter("T_State", 1).Count()
		return r, cnt
	}

	if(len(Time_start_) > 1) {
		qs.Limit(conf.Page_size, offset).Filter("T_Ut__gte", Time_start_+" 00:00:00").Filter("T_Title__icontains", T_Title).Filter("T_sn__icontains", T_sn).OrderBy("-Id").Filter("T_State", 1).All(&r)
		cnt, _ = qs.Filter("T_Ut__gte", Time_start_+" 00:00:00").Filter("T_Title__icontains", T_Title).Filter("T_sn__icontains", T_sn).Filter("T_State", 1).Count()
		return r, cnt
	}else if(len(Time_end_) > 1) {
		qs.Limit(conf.Page_size, offset).Filter("T_Ut__lte", Time_end_+" 23:59:59").Filter("T_Title__icontains", T_Title).Filter("T_sn__icontains", T_sn).OrderBy("-Id").Filter("T_State", 1).All(&r)
		cnt, _ = qs.Filter("T_Ut__lte", Time_end_+" 23:59:59").Filter("T_Title__icontains", T_Title).Filter("T_sn__icontains", T_sn).Filter("T_State", 1).Count()
		return r, cnt
	}

	qs.Limit(conf.Page_size, offset).Filter("T_Title__icontains", T_Title).Filter("T_sn__icontains", T_sn).OrderBy("-Id").Filter("T_State", 1).All(&r)
	cnt, _ = qs.Filter("T_Title__icontains", T_Title).Filter("T_sn__icontains", T_sn).Filter("T_State", 1).Count()

	return r, cnt
}