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