hongze_cygx/models/tactics.go

package models

import (
	"rdluck_tools/orm"
	"time"
)

type Tactics struct {
	ArticleId       int       `description:"文章id"`
	Title           string    `description:"标题"`
	TitleEn         string    `description:"英文标题"`
	UpdateFrequency string    `description:"更新周期"`
	PublishDate     time.Time `description:"发布时间"`
	PublishStatus   int       `description:"发布状态"`
	Department      string    `description:"作者"`
	Body            string    `description:"内容"`
	Abstract        string    `description:"摘要"`
	Annotation      string    `description:"注解"`
	CategoryName    string    `description:"分类"`
	SubCategoryName string    `description:"子级分类"`
	CategoryId      int       `description:"分类id"`
	CreateDate      string    `description:"创建日期"`
}

func GetTacticsList(endDate string) (list []*Tactics, err error) {
	o := orm.NewOrm()
	o.Using("tactics")
	sql := `SELECT a.*,b.body,b.abstract,b.annotation,b.article_id,d.category_name,d.sub_category_name,c.category_id
				FROM article_articleinfo AS a
				INNER JOIN article_content AS b ON a.id=b.article_id
				INNER JOIN article_category AS c ON a.id=c.article_id
				INNER JOIN article_categoryinfo AS d ON c.category_id=d.id
				WHERE a.publish_status=1 AND a.publish_date>=? AND d.id IN (28,32,45,50,57,62,72,74,79,84,86,88,90) 
                AND a.id NOT IN (3454,3456,3457,3459,2449,2450,2453,2454,2459,2530,2583,2663,2670,2699,2715,2732,2748,2759,2399,2356,2870,3173,2978,2826,3470) `
	_, err = o.Raw(sql, endDate).QueryRows(&list)
	return
}

func GetTacticsListAll() (list []*Tactics, err error) {
	o := orm.NewOrm()
	o.Using("tactics")
	sql := `SELECT a.*,b.body,b.abstract,b.annotation,b.article_id,d.category_name,d.sub_category_name,c.category_id
			FROM article_articleinfo AS a
			INNER JOIN article_content AS b ON a.id=b.article_id
			INNER JOIN article_category AS c ON a.id=c.article_id
			INNER JOIN article_categoryinfo AS d ON c.category_id=d.id
			WHERE a.publish_status=1 AND d.id IN (28,32,45,50,57,62,72,74,79,84,86,88,90) 
            AND a.id NOT IN (3454,3456,3457,3459,2449,2450,2453,2454,2459,2530,2583,2663,2670,2699,2715,2732,2748,2759,2399,2356,2870,3173,2978,2826,3470) `
	//IN(85,71)
	_, err = o.Raw(sql).QueryRows(&list)
	return
}


func GetCygxArticleListAll() (list []*Tactics, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM cygx_article `
	_, err = o.Raw(sql).QueryRows(&list)
	return
}