Method GetPublicVersionItems

models/version.go:87–110

GetVersionItems 查询所有公共版本

(bookIdentify string)

// GetVersionItems 查询所有公共版本
func (m *Version) GetPublicVersionItems(bookIdentify string) (items []VersionItem) {
	item := VersionItem{}
	o := orm.NewOrm()
	o.QueryTable(item).Filter("book_identify", bookIdentify).One(&item)
	if item.Id == 0 {
		return
	}
	sql := "select vi.*,b.book_name from md_version_item vi left join md_books b on vi.book_identify = b.identify where vi.version_id = ? and privately_owned = 0"
	o.Raw(sql, item.VersionId).QueryRows(&items)

	var available []VersionItem
	for _, item := range items {
		if item.VersionNO != "" {
			available = append(available, item)
		}
	}

	if len(available) == 0 {
		return
	}

	items = m.SortVersionItems(available)
	return
}

func (m *Version) GetVersionItems(versionId int) (items []VersionItem) {
	orm.NewOrm().QueryTable(NewVersionItem()).Filter("version_id", versionId).All(&items)