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 *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 *TagController) batch() {
ids := this.GetStrings("ids[]")
op := this.GetString("op")
idarr := make([]int64, 0)
for _, v := range ids {
if id, _ := strconv.Atoi(v); id > 0 {
idarr = append(idarr, int64(id))
}
}
switch op {
case "upcount": //更新统计
for _, id := range idarr {
obj := models.Tag{Id: id}
if obj.Read() == nil {
obj.UpCount()
}
}
case "merge": //合并到
toname := strings.TrimSpace(this.GetString("toname"))
if toname != "" && len(idarr) > 0 {
tag := new(models.Tag)
tag.Name = toname
if tag.Read("name") != nil {
tag.Count = 0
tag.Insert()
}
for _, id := range idarr {
obj := models.Tag{Id: id}
if obj.Read() == nil {
obj.MergeTo(tag)
obj.Delete()
}
}
tag.UpCount()
}
case "delete": //批量删除
for _, id := range idarr {
obj := models.Tag{Id: id}
if obj.Read() == nil {
obj.Delete()
}
}
}
this.Redirect("/admin/tag", 302)
}
//保存
func (this *ArticleController) Save() {
var (
id int64 = 0
title string = strings.TrimSpace(this.GetString("title"))
content string = this.GetString("content")
tags string = strings.TrimSpace(this.GetString("tags"))
urlname string = strings.TrimSpace(this.GetString("urlname"))
color string = strings.TrimSpace(this.GetString("color"))
cover string = strings.TrimSpace(this.GetString("cover"))
timestr string = strings.TrimSpace(this.GetString("posttime"))
status int64 = 0
istop int8 = 0
urltype int8 = 0
post models.Post
)
if title == "" {
this.showmsg("标题不能为空！")
}
id, _ = this.GetInt64("id")
status, _ = this.GetInt64("status")
if this.GetString("istop") == "1" {
istop = 1
}
if this.GetString("urltype") == "1" {
urltype = 1
}
if status != 1 && status != 2 {
status = 0
}
if cover == "" {
cover = "/static/upload/defaultcover.png"
}
addtags := make([]string, 0)
//标签过滤
if tags != "" {
tagarr := strings.Split(tags, ",")
for _, v := range tagarr {
if tag := strings.TrimSpace(v); tag != "" {
exists := false
for _, vv := range addtags {
if vv == tag {
exists = true
break
}
}
if !exists {
addtags = append(addtags, tag)
}
}
}
}
if id < 1 {
post.Userid = this.userid
post.Author = this.username
post.Posttime = this.getTime()
post.Updated = this.getTime()
post.Insert()
models.Cache.Delete("latestblog")
} else {
post.Id = id
if post.Read() != nil {
goto RD
}
if post.Tags != "" {
var tagobj models.Tag
var tagpostobj models.TagPost
oldtags := strings.Split(strings.Trim(post.Tags, ","), ",")
//标签统计-1
tagobj.Query().Filter("name__in", oldtags).Update(orm.Params{"count": orm.ColValue(orm.Col_Minus, 1)})
//删掉tag_post表的记录
tagpostobj.Query().Filter("postid", post.Id).Delete()
}
}
if len(addtags) > 0 {
for _, v := range addtags {
tag := models.Tag{Name: v}
if tag.Read("Name") == orm.ErrNoRows {
tag.Count = 1
tag.Insert()
} else {
tag.Count += 1
tag.Update("Count")
}
tp := models.TagPost{Tagid: tag.Id, Postid: post.Id, Poststatus: int8(status), Posttime: this.getTime()}
tp.Insert()
}
post.Tags = "," + strings.Join(addtags, ",") + ","
}
if posttime, err := time.Parse("2006-01-02 15:04:05", timestr); err == nil {
post.Posttime = posttime
} else {
post.Posttime, _ = time.Parse("2006-01-02 15:04:05", post.Posttime.Format("2006-01-02 15:04:05"))
}
post.Status = int8(status)
post.Title = title
post.Color = color
post.Istop = istop
post.Cover = cover
post.Content = content
post.Urlname = urlname
post.Urltype = urltype
post.Updated = this.getTime()
post.Update("tags", "status", "title", "color", "cover", "istop", "content", "urlname", "urltype", "updated", "posttime")
RD:
this.Redirect("/admin/article/list", 302)
}