From bf4ca3fdb8c0f0c1f99a4a871ad39436cefc6ab6 Mon Sep 17 00:00:00 2001
From: liuxiaolong <liuxiaolong@aiotlink.com>
Date: 星期六, 10 十月 2020 19:37:05 +0800
Subject: [PATCH] 在地图上不显示vip车辆

---
 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