//分类查看
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()
}