From ca10e9d776509f54cb0251b7eae44cee74d94b2c Mon Sep 17 00:00:00 2001
From: liuxiaolong <liuxiaolong@aiotlink.com>
Date: 星期二, 01 九月 2020 20:09:50 +0800
Subject: [PATCH] findHikSpaceUser add state=1
---
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