//获取一个文章
func (this *Articles) GetEx(id int64) (*Articles, error) {
defer db.Close()
m := new(Articles)
condition := qbs.NewEqualCondition("id", id)
err := db.Condition(condition).Find(m)
return m, err
}
//分页获取账户
func (this *Users) GetAll() (us []*Users, err error) {
defer db.Close()
condition := qbs.NewEqualCondition("Deleted", utils.DelNormal)
err = db.Condition(condition).OmitFields("Password", "Updator", "Ip").FindAll(&us)
return
}
//获取一个可用文章，屏蔽禁用或已删除的文章
func (this *Articles) Get(id int64) (*Articles, error) {
defer db.Close()
m := new(Articles)
condition := qbs.NewEqualCondition("deleted", utils.DelNormal).AndEqual("id", id)
err := db.Condition(condition).Find(m)
return m, err
}
func (this *Channels) GetByName(enname string) (*Channels, error) {
defer db.Close()
m := new(Channels)
condition := qbs.NewEqualCondition("Deleted", utils.DelNormal).AndEqual("enname", enname)
err := db.Condition(condition).Find(m)
return m, err
}
//获取一个账户
func (this *Users) GetEx(id int64) (*Users, error) {
defer db.Close()
m := new(Users)
//err := db.WhereEqual("id", id).Find(m)
condition := qbs.NewEqualCondition("id", id)
err := db.Condition(condition).Find(m)
return m, err
}
//获取一个可用图片，屏蔽禁用或已删除的图片
func (this *Images) Get(id int64) (*Images, error) {
defer db.Close()
m := new(Images)
condition := qbs.NewEqualCondition("deleted", 0).AndEqual("id", id)
err := db.Condition(condition).Find(m)
return m, err
}
//分页获取图片
func (this *Images) GetImages(args ...interface{}) (us []*Images, err error) {
defer db.Close()
condition := qbs.NewEqualCondition("Deleted", utils.DelNormal).AndEqual("Status", utils.StatEnabled)
if len(args) > 0 && args[0].(int64) > 0 {
condition = condition.AndEqual("articleid", args[0].(int64))
}
err = db.Condition(condition).OmitFields("Created", "Creator", "Updated", "Updator", "Ip").OrderByDesc("sequence").FindAll(&us)
return
}
//分页获取文章
func (this *Articles) GetArticles(channelid int64, page *Pagination) (us []*Articles, err error) {
defer db.Close()
condition := qbs.NewEqualCondition("Deleted", utils.DelNormal).AndEqual("Status", utils.StatEnabled)
//文章频道
if channelid > 0 {
condition = condition.AndEqual("channelid", channelid)
}
//符合条件的记录数
page.Count = int(db.Condition(condition).Count("articles"))
err = db.Condition(condition).Limit(int(page.Size)).Offset(int((page.Index-1)*page.Size)).
OmitFields("Keywords", "Description", "Author", "Intro", "Content", "Created", "Creator", "Updated", "Updator", "Ip").
OrderByDesc("sequence").OrderByDesc("Updated").FindAll(&us)
return
}
//登录
func (this *Users) Login(loginName, password string, f *Field) (*Users, error) {
defer db.Close()
u := new(Users)
condition := qbs.NewEqualCondition("Loginname", loginName).AndEqual("Deleted", utils.DelNormal)
err := db.Condition(condition).Find(u)
if err != nil {
return nil, errors.New("accoundNotFound")
} else {
//是否被锁定
if u.Status == utils.StatDisabled {
return nil, errors.New("accountLocked")
}
//校验密码
if u.Password == utils.MD5(password) {
//db.Save(u)
return u, nil
} else {
return nil, errors.New("invalidPassword")
}
}
}
/*
是否存在同名账户
*/
func (this *Users) Exist(name string) bool {
defer db.Close()
condition := qbs.NewEqualCondition("loginname", name)
num := db.Condition(condition).Count("users")
return num > 0
}