package roadshow

import (
	"github.com/rdlucklib/rdluck_tools/orm"
)

//公开会议总览

//获取公开会议
func GetPublicMeetingList(endDate string) (list []*RsCalendarResearcher, err error) {
	sql := ` SELECT b.* FROM rs_calendar AS a
			INNER JOIN rs_calendar_researcher AS b ON a.rs_calendar_id=b.rs_calendar_id
			WHERE a.source=0 AND activity_type='公开会议'
			AND b.end_date>=?
			ORDER BY a.rs_calendar_id ASC  `
	o := orm.NewOrm()
	_, err = o.Raw(sql, endDate).QueryRows(&list)
	return
}

func ModifyCalendarUnionCode(unionCode string, rsCalendarId int) (err error) {
	sql := ` UPDATE rs_calendar SET union_code=? WHERE rs_calendar_id=? `
	o := orm.NewOrm()
	_, err = o.Raw(sql, unionCode, rsCalendarId).Exec()
	if err != nil {
		return err
	}
	sql = ` UPDATE rs_calendar_researcher SET union_code=? WHERE rs_calendar_id=? `
	_, err = o.Raw(sql, unionCode, rsCalendarId).Exec()
	if err != nil {
		return err
	}
	return
}

func GetCoincideMeeting(startTime, endTime string) (list []*RsCalendarResearcher, err error) {
	sql := ` SELECT * FROM rs_calendar_researcher AS a
			WHERE ? >= DATE_FORMAT(CONCAT(a.start_date," ",a.start_time),'%Y-%m-%d %H:%i:%S')
			AND ? <= DATE_FORMAT(CONCAT(a.end_date," ",a.end_time),'%Y-%m-%d %H:%i:%S') `
	o := orm.NewOrm()
	_, err = o.Raw(sql, startTime, endTime).QueryRows(&list)
	return
}