From 0494779a1de00553ee8a47ca712ffdcafaea9381 Mon Sep 17 00:00:00 2001
From: liuxiaolong <liuxiaolong@aiotlink.com>
Date: 星期一, 17 八月 2020 16:09:59 +0800
Subject: [PATCH] save push log and add spaceInfo,pushLog
---
models/log.go | 35 +++++++++++++++++++++++++++++++++++
1 files changed, 35 insertions(+), 0 deletions(-)
diff --git a/models/log.go b/models/log.go
index 2640e7f..da46e80 100644
--- a/models/log.go
+++ b/models/log.go
@@ -1 +1,36 @@
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
+ sql := "select count(*) from "+l.TableName()+" where createTime >='"+startTime+"' and createTime <= '"+endTime+"'"
+ o.Raw(sql).QueryRow(&total)
+ sn := (curPage-1)*pageSize
+ sql += " order by createTime desc limit "+strconv.Itoa(sn)+","+strconv.Itoa(pageSize)+""
+ o.Raw(sql).QueryRows(&list)
+ return total, list
+}
--
Gitblit v1.8.0