//首页, 只显示前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
}
beego.Debug("pagesize=", pagesize, "offset=", (page-1)*pagesize)
query := new(models.Post).Query().Filter("status", 0).Filter("urltype", 0)
count, _ := query.Count()
beego.Debug("count=", count)
if count > 0 {
query.OrderBy("-is_top", "-post_time").Limit(pagesize, (page-1)*pagesize).All(&list)
}
this.Data["count"] = count
this.Data["list"] = list
beego.Debug("list=", list)
this.Data["pagebar"] = 1 //util.NewPager(page, int(count), pagesize, "").ToString()
this.setHeadMetas()
this.display("home")
beego.Debug("list=", list)
}
//文章显示
func (this *MainController) Show() {
var (
post models.Post
err error
)
urlname := this.Ctx.Input.Param(":urlname")
//beego.Debug("urlname=", urlname)
if urlname != "" {
post.UrlName = urlname
err = post.Read("urlname")
} else {
id, _ := strconv.Atoi(this.Ctx.Input.Param(":id"))
post.Id = id
err = post.Read()
}
if err != nil || post.Status != 0 {
beego.Debug("show err:", err)
this.Abort("404")
return
}
post.Views++
post.Update("Views")
post.Content = strings.Replace(post.Content, "_ueditor_page_break_tag_", "", -1)
this.Data["post"] = post
//beego.Debug("show,post", post)
this.setHeadMetas(post.Title, strings.Trim(post.Tags, ","), post.Title)
this.display("article")
}
//删除
func (this *ArticleController) Delete() {
id, _ := this.GetInt("id")
post := models.Post{Id: id}
if post.Read() == nil {
post.Delete()
}
this.Redirect("/admin/article/list", 302)
}
//编辑
func (this *ArticleController) Edit() {
id, _ := this.GetInt("id")
post := models.Post{Id: id}
if post.Read() != nil {
this.Abort("404")
}
post.Tags = strings.Trim(post.Tags, ",")
this.Data["post"] = post
this.Data["posttime"] = post.PostTime.Format("2006-01-02 15:04:05")
this.display()
}
//管理
func (this *ArticleController) List() {
var (
page int
pagesize int = 10
status int
offset int
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()
beego.Debug("count=", count)
if count > 0 {
query.OrderBy("-is_top", "-post_time").Limit(pagesize, offset).All(&list)
}
beego.Debug("pagesize=", pagesize, "offset=", offset)
beego.Debug("list=", 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"] = 1 //util.NewPager(page, int(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("-post_time").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"] = 1 //util.NewPager(page, int(count), pagesize, "/archives").ToString()
this.Data["result"] = result
this.setHeadMetas("归档")
this.display("archives")
}
//保存
func (this *ArticleController) Save() {
var (
id int = 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"))
timestr string = strings.TrimSpace(this.GetString("posttime"))
status int = 0
istop int8 = 0
urltype int8 = 0
post models.Post
)
if title == "" {
this.showmsg("标题不能为空！")
}
id, _ = this.GetInt("id")
status, _ = this.GetInt("status")
if this.GetString("istop") == "1" {
istop = 1
}
if this.GetString("urltype") == "1" {
urltype = 1
}
if status != 1 && status != 2 {
status = 0
}
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.UpdateTime = this.getTime()
post.Insert()
} 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.Content = content
post.UrlName = urlname
post.UrlType = urltype
post.UpdateTime = this.getTime()
//post.Update( "title", "color", "is_top", "content", "url_name", "url_type", "updated", "post_time")
post.Update("tags", "status", "title", "color", "is_top", "content", "url_name", "url_type", "post_time")
RD:
this.Redirect("/admin/article/list", 302)
}
//批处理
func (this *ArticleController) Batch() {
ids := this.GetStrings("ids[]")
op := this.GetString("op")
idarr := make([]int, 0)
for _, v := range ids {
if id, _ := strconv.Atoi(v); id > 0 {
idarr = append(idarr, id)
}
}
var post models.Post
switch op {
case "topub": //移到已发布
post.Query().Filter("id__in", idarr).Update(orm.Params{"status": 0})
case "todrafts": //移到草稿箱
post.Query().Filter("id__in", idarr).Update(orm.Params{"status": 1})
case "totrash": //移到回收站
post.Query().Filter("id__in", idarr).Update(orm.Params{"status": 2})
case "delete": //批量删除
for _, id := range idarr {
obj := models.Post{Id: id}
if obj.Read() == nil {
obj.Delete()
}
}
}
this.Redirect(this.Ctx.Request.Referer(), 302)
}