123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115 |
- package yb_activity
- import (
- "hongze/hongze_yb/global"
- "time"
- )
- type ActivityItem struct {
- ActivityID int `json:"activityId"`
- FirstActivityTypeID int `json:"firstActivityTypeId"`
- FirstActivityTypeName string `json:"firstActivityTypeName"`
- ActivityName string `json:"activityName"`
- ActivityTypeID int `json:"activityTypeId"`
- ActivityTypeName string `json:"activityTypeName"`
- StartTime time.Time `json:"startTime"`
- EndTime time.Time `json:"endTime"`
- Speaker string `json:"speaker"`
- SpeakerHeadPic string `json:"speakerHeadPic"`
- SpeakerBackgroundPic string `json:"speakerBackgroundPic"`
- City string `json:"city"`
- WeekString string `json:"weekString"`
- HasRemind int `json:"hasRemind"`
- HasPlayBack int `json:"hasPlayBack"`
- RegisterState int `json:"registerState"`
- ActivityState int `json:"activityState"`
- }
- type ActivityDetail struct {
- ActivityItem
- MainlandTel string `json:"mainlandTel"`
- HongKongTel string `json:"hongKongTel"`
- TaiwanTel string `json:"taiwanTel"`
- AmericaTel string `json:"americaTel"`
- SingaporeTel string `json:"singaporeTel"`
- ParticipationCode string `json:"participationCode"`
- LinkParticipants string `json:"linkParticipants"`
- IsLimitPeople int8 `json:"isLimitPeople"`
- LimitPeopleNum int `json:"limitPeopleNum"`
- ReportLink string `json:"reportLink"`
- ReportName string `json:"reportName"`
- Address string `json:"address"`
- RegisteredNum int `json:"registeredNum"`
- ReportId int `json:"report_id"`
- IsNewReport int `json:"is_new_report"`
- }
- func GetPageListByWhere(condition string, pars []interface{}, page, limit int, order string, userId int) (activities []ActivityItem, err error) {
- fields := []string{
- "activity_id", "activity_name", "activity_type_id", "activity_type_name", "start_time", "end_time", "speaker",
- "city", "speaker_head_pic", "speaker_background_pic", "first_activity_type_id", "first_activity_type_name",
- }
- queryOrder := "start_time asc"
- if order != "" {
- queryOrder = order
- }
- err = global.DEFAULT_MYSQL.Model(YbActivity{}).Select(fields).Where(condition, pars...).Order(queryOrder).Limit(limit).Offset((page - 1) * limit).Scan(&activities).Error
- return
- }
- func GetDetailById(activityId int) (activity *ActivityDetail, err error) {
- fields := []string{
- "activity_id", "activity_name", "activity_type_id", "activity_type_name", "start_time", "end_time", "speaker", "city", "speaker_head_pic", "speaker_background_pic",
- "mainland_tel", "hong_kong_tel", "taiwan_tel", "america_tel", "singapore_tel", "participation_code", "report_id", "is_new_report",
- "link_participants", "is_limit_people", "limit_people_num", "report_link", "report_name", "address", "first_activity_type_id", "first_activity_type_name",
- }
- err = global.DEFAULT_MYSQL.Model(YbActivity{}).Select(fields).Where("activity_id", activityId).Scan(&activity).Error
- return
- }
- func GetOneById(activityId int) (activity *YbActivity, err error) {
- err = global.DEFAULT_MYSQL.Where("activity_id = ?", activityId).First(&activity).Error
- return
- }
- func GetActivityByIDsAndDate(ids []int, publishTime string) (list []*YbActivity, err error) {
- err = global.DEFAULT_MYSQL.Model(YbActivity{}).
- Select("DISTINCT activity_id").
- Where("activity_id in (?) and publish_status = 1 and create_time > ? and is_delete = 0", ids, publishTime).Scan(&list).Error
- return
- }
- func GetLatestByIds(activityids []int) (activity *YbActivity, err error) {
- err = global.DEFAULT_MYSQL.Model(YbActivity{}).Where("activity_id in (?) and is_delete = 0 and publish_status = 1", activityids).Order("create_time desc").First(&activity).Error
- return
- }
- func GetListByIds(activityids []int, offset, limit int) (activitys []*YbActivity, err error) {
- err = global.DEFAULT_MYSQL.Model(YbActivity{}).
- Where("activity_id in (?) and is_delete = 0 and publish_status = 1", activityids).
- Order("create_time desc").
- Offset(offset).
- Limit(limit).
- Scan(&activitys).Error
- return
- }
- func GetListCountByIds(activityIds []int) (total int64, err error) {
- err = global.DEFAULT_MYSQL.Model(YbActivity{}).
- Where("activity_id in (?) and is_delete = 0 and publish_status = 1", activityIds).
- Count(&total).Error
- return
- }
- func GetLatestActivity() (activity *YbActivity, err error) {
- err = global.DEFAULT_MYSQL.Model(YbActivity{}).Where("is_delete = 0 and publish_status = 1").Order("create_time desc").First(&activity).Error
- return
- }
|