From 7622abfd473ba097b4cc590adedb6c04d8d64ef6 Mon Sep 17 00:00:00 2001
From: liuxiaolong <liuxiaolong@aiotlink.com>
Date: 星期一, 17 八月 2020 19:44:52 +0800
Subject: [PATCH] fix
---
models/log.go | 5 ++---
1 files changed, 2 insertions(+), 3 deletions(-)
diff --git a/models/log.go b/models/log.go
index 72170af..cdd6958 100644
--- a/models/log.go
+++ b/models/log.go
@@ -27,10 +27,9 @@
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)
+ o.Raw("select count(*) from "+l.TableName()+" where createTime >='"+startTime+"' and createTime <= '"+endTime+"'").QueryRow(&total)
sn := (curPage-1)*pageSize
- sql += " order by createTime desc limit "+strconv.Itoa(sn)+","+strconv.Itoa(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
}
--
Gitblit v1.8.0