()
| 22 | } |
| 23 | |
| 24 | func (m *Dashboard) Query() *Dashboard { |
| 25 | var ( |
| 26 | o = orm.NewOrm() |
| 27 | doc = NewDocument() |
| 28 | member = NewMember() |
| 29 | comment = NewComments() |
| 30 | book = NewBook() |
| 31 | max = 1000 |
| 32 | layout = "2006-01-02 00:00:00" |
| 33 | today = time.Now().Format(layout) |
| 34 | ) |
| 35 | |
| 36 | bookNumber, _ := o.QueryTable(NewBook().TableNameWithPrefix()).Count() |
| 37 | |
| 38 | m.BookNumber = bookNumber |
| 39 | m.DocumentNumber, _ = o.QueryTable(NewDocument().TableNameWithPrefix()).Count() |
| 40 | m.MemberNumber, _ = o.QueryTable(NewMember().TableNameWithPrefix()).Count() |
| 41 | m.CommentNumber, _ = o.QueryTable(NewComments()).Count() |
| 42 | |
| 43 | //m.AttachmentNumber, _ = o.QueryTable(NewAttachment().TableNameWithPrefix()).Count() |
| 44 | |
| 45 | o.QueryTable(doc).OrderBy("-document_id").One(doc, "document_id") |
| 46 | o.QueryTable(member).OrderBy("-member_id").One(member, "member_id") |
| 47 | o.QueryTable(comment).OrderBy("-id").One(comment, "id") |
| 48 | o.QueryTable(book).OrderBy("-book_id").One(book, "book_id") |
| 49 | m.DocumentNumberToday, _ = o.QueryTable(doc).Filter("document_id__gte", doc.DocumentId-max).Filter("create_time__gte", today).Count() |
| 50 | m.MemberNumberToday, _ = o.QueryTable(member).Filter("member_id__gte", member.MemberId-max).Filter("create_time__gte", today).Count() |
| 51 | m.CommentNumberToday, _ = o.QueryTable(comment).Filter("id__gte", comment.Id-max).Filter("time_create__gte", today).Count() |
| 52 | m.BookNumberToday, _ = o.QueryTable(book).Filter("book_id__gte", book.BookId-max).Filter("create_time__gte", today).Count() |
| 53 | return m |
| 54 | } |
no test coverage detected