package models
|
|
import (
|
"github.com/astaxie/beego/orm"
|
"strconv"
|
)
|
|
//cid和别名绑定记录
|
type Log struct {
|
Id string `orm:"pk;size(50);column(id)" json:"id"`
|
CreateTime string `orm:"column(createTime)" json:"createTime"` //创建时间
|
Result bool `orm:"column(result)" json:"result"` //推送结果
|
Phones string `orm:"size(8000);column(phones)" json:"phones"` //推送目标手机号
|
Content string `orm:"column(content)" json:"content"` //剩余车位
|
}
|
|
func (l *Log) TableName() string {
|
return "log"
|
}
|
|
func (l *Log) Insert() (int64,error) {
|
o := orm.NewOrm()
|
return o.Insert(l)
|
}
|
|
func (l *Log) Find(curPage int, pageSize int, startTime string, endTime string) (int,[]*Log) {
|
var list []*Log
|
o := orm.NewOrm()
|
var total int
|
o.Raw("select count(*) from "+l.TableName()+" where createTime >='"+startTime+"' and createTime <= '"+endTime+"'").QueryRow(&total)
|
sn := (curPage-1)*pageSize
|
sql := "select * from "+l.TableName()+" where createTime >='"+startTime+"' and createTime <= '"+endTime+"' order by createTime desc limit "+strconv.Itoa(sn)+","+strconv.Itoa(pageSize)+""
|
o.Raw(sql).QueryRows(&list)
|
return total, list
|
}
|
