//分类查看 func (this *MainController) Category() { var ( page int pagesize int name string err error count int64 result map[string][]*models.Post ) name = this.Ctx.Input.Param(":name") if page, err = strconv.Atoi(this.Ctx.Input.Param(":page")); err != nil || page < 1 { page = 1 } if pagesize, err = strconv.Atoi(this.getOption("pagesize")); err != nil || pagesize < 1 { pagesize = 20 } else { pagesize *= 2 } o := orm.NewOrm() tag := new(models.Tag) tag.Name = name if o.Read(tag, "Name") != nil { this.Abort("404") } count, _ = o.QueryTable(&models.TagPost{}).Filter("tagid", tag.Id).Filter("poststatus", 0).Count() result = make(map[string][]*models.Post) if count > 0 { var tp []*models.TagPost var list []*models.Post var pids []int64 = make([]int64, 0) o.QueryTable(&models.TagPost{}).Filter("tagid", tag.Id).Filter("poststatus", 0).OrderBy("-posttime").Limit(pagesize, (page-1)*pagesize).All(&tp) for _, v := range tp { pids = append(pids, v.Postid) } o.QueryTable(&models.Post{}).Filter("id__in", pids).All(&list) for _, v := range list { year := v.Posttime.Format("2006") if _, ok := result[year]; !ok { result[year] = make([]*models.Post, 0) } result[year] = append(result[year], v) } } this.Data["tag"] = tag this.Data["page"] = page this.Data["pagesize"] = pagesize this.Data["count"] = count this.Data["result"] = result this.Data["pagebar"] = models.NewPager(int64(page), int64(count), int64(pagesize), "/category/"+url.QueryEscape(tag.Name)).ToString() this.setHeadMetas(tag.Name, tag.Name, tag.Name) this.display("category") }
//首页, 只显示前N条 func (this *MainController) Index() { var ( list []*models.Post pagesize int err error page int ) if page, err = strconv.Atoi(this.Ctx.Input.Param(":page")); err != nil || page < 1 { page = 1 } if pagesize, err = strconv.Atoi(this.getOption("pagesize")); err != nil || pagesize < 1 { pagesize = 10 } query := new(models.Post).Query().Filter("status", 0).Filter("urltype", 0) count, _ := query.Count() if count > 0 { query.OrderBy("-istop", "-posttime").Limit(pagesize, (page-1)*pagesize).All(&list) } this.Data["count"] = count this.Data["list"] = list this.Data["pagebar"] = models.NewPager(int64(page), int64(count), int64(pagesize), "").ToString() this.setHeadMetas() this.display("index") }
//管理 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.GetInt("status") if page, _ = this.GetInt("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["count"] = count this.Data["list"] = list this.Data["pagebar"] = models.NewPager(page, count, pagesize, fmt.Sprintf("/admin/article/list?status=%d&searchtype=%s&keyword=%s", status, searchtype, keyword), true).ToString() this.display() }
//历史归档 func (this *MainController) Archives() { var ( page int pagesize int err error count int64 result map[string][]*models.Post ) if page, err = strconv.Atoi(this.Ctx.Input.Param(":page")); err != nil || page < 1 { page = 1 } if pagesize, err = strconv.Atoi(this.getOption("pagesize")); err != nil || pagesize < 1 { pagesize = 20 } else { pagesize *= 2 } query := new(models.Post).Query().Filter("status", 0).Filter("urltype", 0) count, _ = query.Count() result = make(map[string][]*models.Post) if count > 0 { var list []*models.Post query.OrderBy("-posttime").Limit(pagesize, (page-1)*pagesize).All(&list) for _, v := range list { year := v.Posttime.Format("2006") if _, ok := result[year]; !ok { result[year] = make([]*models.Post, 0) } result[year] = append(result[year], v) } } this.Data["page"] = page this.Data["count"] = count this.Data["pagesize"] = pagesize this.Data["pagebar"] = models.NewPager(int64(page), int64(count), int64(pagesize), "/archives").ToString() this.Data["result"] = result this.setHeadMetas("归档") this.display("archives") }
//标签列表 func (this *TagController) list() { var page int64 var pagesize int64 = 10 var list []*models.Tag var tag models.Tag if page, _ = this.GetInt("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["count"] = count this.Data["list"] = list this.Data["pagebar"] = models.NewPager(page, count, pagesize, "/admin/tag", true).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.GetInt("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["count"] = count this.Data["list"] = list this.Data["pagebar"] = models.NewPager(page, count, pagesize, "/admin/user/list", true).ToString() this.display() }