func (this *MainController) Category() { var list []*models.Post tagpost := new(models.TagPost) tag := new(models.Tag) tag.Name = this.Ctx.Input.Param(":name") if tag.Read("Name") != nil { this.Abort("404") } query := tagpost.Query().Filter("tagid", tag.Id).Filter("poststatus", 0) count, _ := query.Count() if count > 0 { var tp []*models.TagPost var pids []int64 = make([]int64, 0) query.OrderBy("-posttime").Limit(this.pagesize, (this.page-1)*this.pagesize).All(&tp) for _, v := range tp { pids = append(pids, v.Postid) } new(models.Post).Query().Filter("id__in", pids).All(&list) } this.Data["tag"] = tag this.Data["list"] = list this.Data["pagebar"] = models.NewPager(int64(this.page), int64(count), int64(this.pagesize), "/category/"+tag.Name+"/page/%d").ToString() this.setHeadMetas(tag.Name, tag.Name, tag.Name) this.display("life") }
func (this *MainController) Mood() { var list []*models.Mood query := new(models.Mood).Query() count, _ := query.Count() if count > 0 { query.OrderBy("-posttime").Limit(this.pagesize, (this.page-1)*this.pagesize).All(&list) } this.Data["list"] = list this.setHeadMetas("碎言碎语") this.right = "" this.Data["pagebar"] = models.NewPager(int64(this.page), int64(count), int64(this.pagesize), "/mood/%d").ToString() this.display("mood") }
//blog分页显示 func (this *MainController) BlogList() { var list []*models.Post query := new(models.Post).Query().Filter("status", 0).Filter("urltype", 0) count, _ := query.Count() if count > 0 { query.OrderBy("-istop", "-posttime").Limit(this.pagesize, (this.page-1)*this.pagesize).All(&list) } this.Data["list"] = list this.Data["pagebar"] = models.NewPager(int64(this.page), int64(count), int64(this.pagesize), "/life/%d").ToString() this.setHeadMetas("点点滴滴") this.right = "right.html" this.display("life") }
//首页, 只显示前N条 func (this *MainController) Index() { var list []*models.Post query := new(models.Post).Query().Filter("status", 0).Filter("urltype", 0) count, _ := query.Count() if count > 0 { query.OrderBy("-istop", "-views").Limit(this.pagesize, (this.page-1)*this.pagesize).All(&list) } this.Data["list"] = list this.Data["pagebar"] = models.NewPager(int64(this.page), int64(count), int64(this.pagesize), "/index/%d").ToString() this.setHeadMetas() this.display("index") }
func (this *MainController) Album() { pagesize, _ := strconv.Atoi(this.getOption("albumsize")) if pagesize < 1 { pagesize = 12 } var list []*models.Album query := new(models.Album).Query().Filter("ishide", 0) count, _ := query.Count() if count > 0 { query.OrderBy("-rank", "-posttime").Limit(pagesize, (this.page-1)*pagesize).All(&list) } this.setHeadMetas("美丽瞬间") this.right = "" this.Data["list"] = list this.Data["pagebar"] = models.NewPager(int64(this.page), int64(count), int64(pagesize), "/album/%d").ToString() this.display("album") }
//管理 func (this *ArticleController) List() { var ( page int64 pagesize int64 = 10 status int64 offset int64 list []*models.Post post models.Post searchtype string keyword string ) searchtype = this.GetString("searchtype") keyword = this.GetString("keyword") status, _ = this.GetInt64("status") if page, _ = this.GetInt64("page"); page < 1 { page = 1 } offset = (page - 1) * pagesize query := post.Query().Filter("status", status) if keyword != "" { switch searchtype { case "title": query = query.Filter("title__icontains", keyword) case "author": query = query.Filter("author__icontains", keyword) case "tag": query = query.Filter("tags__icontains", keyword) } } count, _ := query.Count() if count > 0 { query.OrderBy("-istop", "-posttime").Limit(pagesize, offset).All(&list) } this.Data["searchtype"] = searchtype this.Data["keyword"] = keyword this.Data["count_1"], _ = post.Query().Filter("status", 1).Count() this.Data["count_2"], _ = post.Query().Filter("status", 2).Count() this.Data["status"] = status this.Data["list"] = list this.Data["pagebar"] = models.NewPager(page, count, pagesize, fmt.Sprintf("/admin/article/list?status=%d&searchtype=%s&keyword=%s&page=%s", status, searchtype, keyword, "%d")).ToString() this.display() }
//标签列表 func (this *TagController) list() { var page int64 var pagesize int64 = 10 var list []*models.Tag var tag models.Tag if page, _ = this.GetInt64("page"); page < 1 { page = 1 } offset := (page - 1) * pagesize count, _ := tag.Query().Count() if count > 0 { tag.Query().OrderBy("-count").Limit(pagesize, offset).All(&list) } this.Data["list"] = list this.Data["pagebar"] = models.NewPager(page, count, pagesize, "/admin/tag?page=%d").ToString() this.display("tag_list") }
//用户列表 func (this *UserController) List() { var page int64 var pagesize int64 = 10 var list []*models.User var user models.User if page, _ = this.GetInt64("page"); page < 1 { page = 1 } offset := (page - 1) * pagesize count, _ := user.Query().Count() if count > 0 { user.Query().OrderBy("-id").Limit(pagesize, offset).All(&list) } this.Data["list"] = list this.Data["pagebar"] = models.NewPager(page, count, pagesize, "/admin/user/list?page=%d").ToString() this.display() }
//相册列表 func (this *AlbumController) List() { var page int64 var pagesize int64 = 6 var list []*models.Album var album models.Album if page, _ = this.GetInt64("page"); page < 1 { page = 1 } offset := (page - 1) * pagesize query := album.Query() count, _ := query.Count() if count > 0 { query.OrderBy("-rank", "-posttime").Limit(pagesize, offset).All(&list) } this.Data["list"] = list this.Data["pagebar"] = models.NewPager(page, count, pagesize, "/admin/album/list?page=%d").ToString() this.display() }