forked from golang/hotime
128 lines
4.2 KiB
Go
128 lines
4.2 KiB
Go
package app
|
|
|
|
import (
|
|
. "code.hoteas.com/golang/hotime"
|
|
. "code.hoteas.com/golang/hotime/common"
|
|
"time"
|
|
)
|
|
|
|
var AppProj = Proj{
|
|
"article": ArticleCtr,
|
|
"org": OrgCtr,
|
|
"ctg": CtgCtr,
|
|
"mail": MailCtr,
|
|
"test": {
|
|
"test": func(that *Context) {
|
|
//data:=that.Db.Table("admin").Order("id DESC").Select("*")
|
|
//data1:=that.Db.Table("admin").Where(Map{"name[~]":"m"}).Order("id DESC").Select("*")
|
|
//
|
|
//data3:=that.Db.Select("admin","*",Map{"name[~]":"m"})
|
|
data2 := that.Db.Table("article").Where(Map{"title[~]": "m"}).Order("id DESC").Page(1, 10).Select("*")
|
|
c := that.Db.Table("article").Where(Map{"title[~]": "m"}).Order("id DESC").Group("title").Select("*")
|
|
//that.Display(0,Slice{data1,data,data3,data2})
|
|
that.Display(0, Slice{data2, c})
|
|
},
|
|
"res": func(that *Context) {
|
|
ebw_res := that.Db.Select("ebw_res", "*")
|
|
|
|
for _, v := range ebw_res {
|
|
data := Map{"id": v.GetCeilInt("id"), "name": v.GetString("name"),
|
|
"parent_id": v.GetCeilInt64("pid"),
|
|
"sn": v.GetString("url"), "create_time": time.Now().Format("2006-01-02 15:04"),
|
|
"modify_time": time.Now().Format("2006-01-02 15:04"), "admin_id": 1}
|
|
if data.GetCeilInt("parent_id") == 0 {
|
|
data["parent_id"] = nil
|
|
}
|
|
that.Db.Insert("ctg", data)
|
|
}
|
|
|
|
that.Db.Exec("UPDATE ctg SET parent_id =NULL WHERE parent_id=id")
|
|
|
|
ss(0, that)
|
|
|
|
that.Display(0, len(ebw_res))
|
|
|
|
},
|
|
"news": func(that *Context) {
|
|
ebw_news := that.Db.Select("ebw_news", "*")
|
|
|
|
for _, v := range ebw_news {
|
|
ctg := that.Db.Get("ctg", "*", Map{"sn": v.GetString("type")})
|
|
data := Map{"sn": v.GetString("id"), "title": v.GetString("title"),
|
|
"content": v.GetString("content"), "push_time": v.GetString("timedate"),
|
|
"author": v.GetString("owner"), "origin": v.GetString("source"), "click_num": v.GetString("readtime"),
|
|
"sort": v.GetCeilInt("zhiding"), "create_time": time.Now().Format("2006-01-02 15:04"),
|
|
"modify_time": time.Now().Format("2006-01-02 15:04"), "admin_id": 1}
|
|
if ctg != nil {
|
|
data["ctg_id"] = ctg.GetCeilInt("id")
|
|
}
|
|
that.Db.Insert("article", data)
|
|
}
|
|
|
|
that.Display(0, len(ebw_news))
|
|
|
|
},
|
|
"res2news": func(that *Context) {
|
|
ebw_news_addition_res := that.Db.Select("ebw_news_addition_res", "*")
|
|
|
|
for _, v := range ebw_news_addition_res {
|
|
ctg := that.Db.Get("ctg", "*", Map{"sn": v.GetString("fk_res")})
|
|
article := that.Db.Get("article", "*", Map{"sn": v.GetString("fk_newsid")})
|
|
data := Map{"sn": Md5(ObjToStr(time.Now().UnixNano()) + ObjToStr(RandX(10000, 100000))),
|
|
"create_time": time.Now().Format("2006-01-02 15:04"),
|
|
"modify_time": time.Now().Format("2006-01-02 15:04"), "admin_id": 1}
|
|
if ctg != nil {
|
|
data["ctg_id"] = ctg.GetCeilInt("id")
|
|
}
|
|
if article != nil {
|
|
data["article_id"] = article.GetCeilInt("id")
|
|
}
|
|
that.Db.Insert("ctg_article", data)
|
|
}
|
|
|
|
that.Display(0, len(ebw_news_addition_res))
|
|
},
|
|
//将文章没有关联的ctg_article进行关联
|
|
"article": func(that *Context) {
|
|
articles := that.Db.Select("article", "id,ctg_id")
|
|
for _, v := range articles {
|
|
ctg_article := that.Db.Get("ctg_article", "id", Map{"article_id": v.GetCeilInt("id")})
|
|
if ctg_article == nil {
|
|
|
|
data := Map{"sn": Md5(ObjToStr(time.Now().UnixNano()) + ObjToStr(RandX(10000, 100000))),
|
|
"create_time": time.Now().Format("2006-01-02 15:04"),
|
|
"modify_time": time.Now().Format("2006-01-02 15:04"), "admin_id": 1}
|
|
if v.GetCeilInt("ctg_id") == 0 || v.GetCeilInt("id") == 0 {
|
|
continue
|
|
}
|
|
data["ctg_id"] = v.GetCeilInt("ctg_id")
|
|
data["article_id"] = v.GetCeilInt("id")
|
|
that.Db.Insert("ctg_article", data)
|
|
}
|
|
|
|
}
|
|
that.Display(0, len(articles))
|
|
|
|
},
|
|
},
|
|
}
|
|
|
|
func ss(parent_id int, that *Context) {
|
|
var ctgs []Map
|
|
ctg := that.Db.Get("ctg", "*", Map{"id": parent_id})
|
|
if parent_id == 0 {
|
|
ctgs = that.Db.Select("ctg", "*", Map{"parent_id": nil})
|
|
} else {
|
|
ctgs = that.Db.Select("ctg", "*", Map{"parent_id": parent_id})
|
|
}
|
|
|
|
for _, v := range ctgs {
|
|
if ctg == nil {
|
|
ctg = Map{"parent_ids": ","}
|
|
}
|
|
ids := ctg.GetString("parent_ids") + ObjToStr(v.GetCeilInt("id")) + ","
|
|
that.Db.Update("ctg", Map{"parent_ids": ids}, Map{"id": v.GetCeilInt("id")})
|
|
ss(v.GetCeilInt("id"), that)
|
|
}
|
|
}
|