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