activity_special.go 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765
  1. package services
  2. import (
  3. "errors"
  4. "fmt"
  5. "hongze/hongze_clpt/models"
  6. "hongze/hongze_clpt/utils"
  7. "strconv"
  8. "strings"
  9. "time"
  10. )
  11. //func init() {
  12. // UpdateCygxActivitySpecialSignupNum()
  13. //}
  14. func ActivityLabelSpecialSql(chartPermissionIds, whichDay, activeState string) (condition string) {
  15. //行业名称
  16. if len(chartPermissionIds) > 0 {
  17. condition += ` AND art.chart_permission_id IN (` + chartPermissionIds + `)`
  18. }
  19. if whichDay != "" {
  20. var startDate string
  21. var endDate string
  22. if whichDay == "1" {
  23. startDate = time.Now().Format(utils.FormatDate)
  24. endDate = startDate
  25. } else if whichDay == "2" {
  26. startDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  27. endDate = startDate
  28. } else if whichDay == "1,2" || whichDay == "2,1" {
  29. startDate = time.Now().Format(utils.FormatDate)
  30. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  31. } else if whichDay == "3" {
  32. startDate = utils.GetNowWeekMonday().Format(utils.FormatDate)
  33. endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
  34. } else if whichDay == "4" {
  35. startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
  36. endDate = utils.GetLastWeekSunday().Format(utils.FormatDate)
  37. } else if whichDay == "5" {
  38. startDate = utils.GetNowMonthFirstDay().Format(utils.FormatDate)
  39. endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
  40. } else if whichDay == "6" {
  41. startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
  42. endDate = utils.GetLastMonthLastDay().Format(utils.FormatDate)
  43. } else if whichDay == "3,4" || whichDay == "4,3" {
  44. startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
  45. endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
  46. } else if whichDay == "5,6" || whichDay == "6,5" {
  47. startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
  48. endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
  49. } else {
  50. startDate = utils.GetNowWeekMonday().Format(utils.FormatDate)
  51. endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
  52. }
  53. condition += ` AND art.activity_time >= ` + "'" + startDate + " 00:00:00'"
  54. condition += ` AND art.activity_time <= ` + "'" + endDate + " 23:59:59'"
  55. }
  56. if activeState == "2" {
  57. condition += ` AND art.activity_time <= ` + "'" + time.Now().Format(utils.FormatDateTime) + " '"
  58. condition += ` AND art.activity_time_end >= ` + "'" + time.Now().Format(utils.FormatDateTime) + " '"
  59. }
  60. if activeState == "3" {
  61. condition += ` AND art.activity_time_end <= ` + "'" + time.Now().Format(utils.FormatDateTime) + " '"
  62. }
  63. if activeState != "" || whichDay != "" {
  64. condition += ` AND art.days > 0 `
  65. }
  66. return
  67. }
  68. //处理专项调研的展示
  69. func GetActivityLabelSpecialList(user *models.WxUserItem, conditionActivitySpecial string) (item *models.ActivityTypeHome, err error) {
  70. itemList := new(models.ActivityTypeHome)
  71. if user.CompanyId <= 1 {
  72. itemList.List = make([]*models.CygxActivityLabelList, 0)
  73. item = itemList
  74. return
  75. }
  76. userType, e := GetSpecialUserType(user)
  77. if e != nil {
  78. err = errors.New("GetSpecialUserType, Err: " + e.Error())
  79. return
  80. }
  81. if userType == 0 {
  82. itemList.List = make([]*models.CygxActivityLabelList, 0)
  83. item = itemList
  84. return
  85. }
  86. companyDetail, e := models.GetCompanyDetailByIdGroupTrip(user.CompanyId)
  87. fmt.Println(e)
  88. if e != nil && e.Error() != utils.ErrNoRow() {
  89. err = errors.New("GetCompanyDetailByIdGroupTrip, Err: " + e.Error())
  90. return
  91. }
  92. if companyDetail == nil {
  93. return
  94. }
  95. //如果是永续的就按照普通的权限逻辑来查,如果不是就按照升级的逻辑来查
  96. var condition string
  97. if companyDetail.Status == "永续" {
  98. condition, e = HandleActivityLabelSpecialPermission(user)
  99. if e != nil {
  100. err = errors.New("HandleActivityLabelSpecialPermission, Err: " + e.Error())
  101. return
  102. }
  103. } else {
  104. condition, e = HandleActivityLabelSpecialTripPermission(user)
  105. if e != nil {
  106. err = errors.New("HandleActivityLabelSpecialPermission, Err: " + e.Error())
  107. return
  108. }
  109. }
  110. var pars []interface{}
  111. condition += ` AND art.publish_status = 1 AND art.label != '' AND art.is_offline = 0 ` + conditionActivitySpecial
  112. ////行业名称
  113. //if isPower == 1 {
  114. // condition += ` AND art.chart_permission_name IN (` + permissionNameStr + `) `
  115. //}
  116. //if chartPermissionIds != "" {
  117. // condition += ` AND art.chart_permission_id IN (` + chartPermissionIds + `) `
  118. //}
  119. conditionTrip := condition
  120. conditionTrip += ` AND art.days > 0 ORDER BY art.activity_time ASC `
  121. specialList, err := models.GetActivityLabelSpecialListAll(conditionTrip, pars, 0, 8)
  122. if err != nil {
  123. return
  124. }
  125. if len(specialList) < 8 {
  126. condition += ` AND art.days = 0 ORDER BY art.last_updated_time DESC`
  127. specialListNotrip, e := models.GetActivityLabelSpecialListAll(condition, pars, 0, 20)
  128. if e != nil {
  129. err = e
  130. return
  131. }
  132. for _, v := range specialListNotrip {
  133. specialList = append(specialList, v)
  134. }
  135. }
  136. for k2, v2 := range specialList {
  137. v2.Resource = 2
  138. specialList[k2].KeyWord = LabelStr(v2.KeyWord, v2.IsShowSubjectName, v2.TemporaryLabel)
  139. specialList[k2].ImgUrlBg = "https://hzstatic.hzinsights.com/static/temp/20220426202204/20220426/XDLLsjC9XAAy8LIzQr7GsjrBbtX6.png"
  140. specialList[k2].ImgUrlBg = utils.ACTIVITY_ZXDY_ImgUrl3
  141. }
  142. itemList.ActivityTypeName = "专项产业调研"
  143. itemList.Resource = 2
  144. itemList.List = specialList
  145. itemList.ActivityTypeId = 7
  146. itemList.OnlineIco = utils.ACTIVITY_ZXDY_ImgUrl1
  147. itemList.ImgUrlBgPc = utils.ACTIVITY_ZXDY_ImgUrl2
  148. item = itemList
  149. return
  150. }
  151. //HandleActivityLabelSpecialPermission 处理专项产业调研的查询权限sql 永续
  152. func HandleActivityLabelSpecialPermission(user *models.WxUserItem) (condition string, err error) {
  153. permissionStr, e := GetCompanyPermission(user.CompanyId)
  154. if e != nil {
  155. err = errors.New("GetCompanyPermission, Err: " + e.Error())
  156. return
  157. }
  158. userType, e := GetSpecialUserType(user)
  159. if e != nil {
  160. err = errors.New("GetSpecialUserType, Err: " + e.Error())
  161. return
  162. }
  163. slicePer := strings.Split(permissionStr, ",")
  164. var permissionSqlStr string
  165. for _, v := range slicePer {
  166. if userType == 1 {
  167. if !strings.Contains(v, "研选") {
  168. permissionSqlStr += "'" + v + "',"
  169. }
  170. } else {
  171. permissionSqlStr += "'" + v + "',"
  172. }
  173. }
  174. permissionSqlStr = strings.TrimRight(permissionSqlStr, ",")
  175. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.is_offline = 0 `
  176. if permissionSqlStr != "" {
  177. condition += ` AND art.chart_permission_name IN (` + permissionSqlStr + `) `
  178. }
  179. condition += ` AND art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' `
  180. return
  181. }
  182. //HandleActivityLabelSpecialPermisseion 处理专项产业调研的查询权限sql
  183. func HandleActivityLabelSpecialTripPermission(user *models.WxUserItem) (condition string, err error) {
  184. permissionStr, e := GetCompanyPermission(user.CompanyId)
  185. if e != nil {
  186. err = errors.New("GetCompanyPermission, Err: " + e.Error())
  187. return
  188. }
  189. userType, e := GetSpecialUserType(user)
  190. if e != nil {
  191. err = errors.New("GetSpecialUserType, Err: " + e.Error())
  192. return
  193. }
  194. slicePer := strings.Split(permissionStr, ",")
  195. var permissionSqlStr string
  196. for _, v := range slicePer {
  197. if userType == 1 {
  198. if !strings.Contains(v, "研选") {
  199. permissionSqlStr += "'" + v + "',"
  200. }
  201. } else {
  202. permissionSqlStr += "'" + v + "',"
  203. }
  204. }
  205. permissionSqlStr = strings.TrimRight(permissionSqlStr, ",")
  206. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.is_offline = 0 `
  207. if permissionSqlStr != "" {
  208. condition += ` AND art.chart_permission_name IN (` + permissionSqlStr + `) `
  209. }
  210. condition += ` AND art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' `
  211. return
  212. }
  213. //获取预报名列表
  214. func GetActivitySpecialPrepareList(user *models.WxUserItem, startSize, pageSize int, keywords, conditionActivity string) (list []*models.CygxActivitySpecialDetail, totalPrepare int, err error) {
  215. companyDetail, e := models.GetCompanyDetailByIdGroupTrip(user.CompanyId)
  216. if e != nil {
  217. err = errors.New("GetCompanyDetailByIdGroupTrip, Err: " + e.Error())
  218. return
  219. }
  220. //如果是永续的就按照普通的权限逻辑来查,如果不是就按照升级的逻辑来查
  221. var condition string
  222. if companyDetail.Status == "永续" {
  223. condition, e = HandleActivityLabelSpecialPermission(user)
  224. if e != nil {
  225. err = errors.New("HandleActivityLabelSpecialPermission, Err: " + e.Error())
  226. return
  227. }
  228. } else {
  229. condition, e = HandleActivityLabelSpecialTripPermission(user)
  230. if e != nil {
  231. err = errors.New("HandleActivityLabelSpecialPermission, Err: " + e.Error())
  232. return
  233. }
  234. }
  235. var pars []interface{}
  236. condition += ` AND art.days = 0 AND art.publish_status = 1 AND art.is_offline = 0 ` + conditionActivity
  237. if keywords != "" {
  238. keywords = "%" + keywords + "%"
  239. condition += ` AND art.research_theme LIKE ? `
  240. pars = append(pars, keywords)
  241. }
  242. totalPrepare, e = models.GetActivitySpecialCount(condition, pars)
  243. if e != nil {
  244. err = errors.New("GetActivitySpecialCount, Err: " + e.Error())
  245. return
  246. }
  247. condition += ` ORDER BY art.last_updated_time DESC `
  248. list, e = models.GetCygxActivitySpecialDetailList(condition, pars, user.UserId, startSize, pageSize)
  249. if e != nil {
  250. err = errors.New("GetCygxActivitySpecialDetailList, Err: " + e.Error())
  251. return
  252. }
  253. return
  254. }
  255. /*
  256. 确定行程的查询 GetActivityLabelSpecialConfirmList
  257. state 进行状态 1:未开始,2:进行中,3:已结束,4:未开始、进行中 不传默认查询全部items []*CygxActivitySpecialDetail
  258. */
  259. func GetActivityLabelSpecialConfirmList(user *models.WxUserItem, startSize, pageSize, state int, keywords, conditionActivity string) (list []*models.CygxActivitySpecialDetail, totalConfirm int, err error) {
  260. //var condition string
  261. companyDetail, e := models.GetCompanyDetailByIdGroupTrip(user.CompanyId)
  262. if e != nil {
  263. err = errors.New("GetCompanyDetailByIdGroupTrip, Err: " + e.Error())
  264. return
  265. }
  266. //如果是永续的就按照普通的权限逻辑来查,如果不是就按照升级的逻辑来查
  267. var condition string
  268. if companyDetail.Status == "永续" {
  269. condition, e = HandleActivityLabelSpecialPermission(user)
  270. if e != nil {
  271. err = errors.New("HandleActivityLabelSpecialPermission, Err: " + e.Error())
  272. return
  273. }
  274. } else {
  275. condition, e = HandleActivityLabelSpecialTripPermission(user)
  276. if e != nil {
  277. err = errors.New("HandleActivityLabelSpecialPermission, Err: " + e.Error())
  278. return
  279. }
  280. }
  281. var pars []interface{}
  282. condition += ` AND art.days >0 AND art.publish_status =1 AND art.is_offline = 0 ` + conditionActivity
  283. if state == 1 {
  284. condition += ` AND art.activity_time > ? `
  285. pars = append(pars, time.Now())
  286. }
  287. if state == 2 {
  288. condition += ` AND art.activity_time < ? `
  289. pars = append(pars, time.Now())
  290. condition += ` AND art.activity_time_end > ? `
  291. pars = append(pars, time.Now())
  292. }
  293. if state == 3 {
  294. condition += ` AND art.activity_time_end < ? `
  295. pars = append(pars, time.Now())
  296. }
  297. if state == 4 {
  298. condition += ` AND art.activity_time_end > ? `
  299. pars = append(pars, time.Now())
  300. }
  301. if keywords != "" {
  302. keywords = "%" + keywords + "%"
  303. condition += ` AND art.research_theme LIKE ? `
  304. pars = append(pars, keywords)
  305. }
  306. totalConfirm, e = models.GetActivitySpecialCount(condition, pars)
  307. if e != nil {
  308. err = errors.New("GetActivitySpecialCount, Err: " + e.Error())
  309. return
  310. }
  311. condition += ` ORDER BY art.activity_time ASC `
  312. list, e = models.GetCygxActivitySpecialDetailList(condition, pars, user.UserId, startSize, pageSize)
  313. if e != nil {
  314. err = errors.New("GetCygxActivitySpecialDetailList, Err: " + e.Error())
  315. return
  316. }
  317. var activityIds []int
  318. for k, v := range list {
  319. resultTimeStart := utils.StrTimeToTime(v.ActivityTime) //时间字符串格式转时间格式
  320. resultTimeEnd := utils.StrTimeToTime(v.ActivityTimeEnd) //时间字符串格式转时间格式
  321. if resultTimeStart.After(time.Now()) {
  322. list[k].ActiveState = 1
  323. } else if time.Now().After(resultTimeEnd) {
  324. list[k].ActiveState = 3
  325. } else {
  326. list[k].ActiveState = 2
  327. }
  328. if list[k].Days == 0 {
  329. list[k].TripStatus = 1
  330. } else {
  331. list[k].TripStatus = 2
  332. }
  333. activityIds = append(activityIds, v.ActivityId)
  334. }
  335. //处理用户已经报名了的行程
  336. UserMap, e := GetSpecialTripUserMap(activityIds, user.UserId)
  337. if e != nil {
  338. err = errors.New("GetSpecialTripUserMap, Err: " + e.Error())
  339. return
  340. }
  341. for k, v := range list {
  342. if _, ok := UserMap[v.ActivityId]; ok {
  343. list[k].IsTrip = 1
  344. }
  345. }
  346. return
  347. }
  348. //获取用户已经报名的活动
  349. func GetSpecialTripUserMap(activityIds []int, userId int) (mapUserId map[int]int, err error) {
  350. var condition string
  351. var pars []interface{}
  352. activityIdsLen := len(activityIds)
  353. if activityIdsLen > 0 {
  354. condition += ` AND activity_id IN (` + utils.GetOrmInReplace(activityIdsLen) + `)`
  355. pars = append(pars, activityIds)
  356. }
  357. condition += ` AND user_id = ? AND is_cancel = 0 `
  358. pars = append(pars, userId)
  359. list, e := models.GetCygxActivitySpecialTripList(condition, pars)
  360. if e != nil {
  361. err = errors.New("GetCygxActivitySpecialTripList, Err: " + e.Error())
  362. return
  363. }
  364. mapUid := make(map[int]int)
  365. for _, v := range list {
  366. mapUid[v.ActivityId] = v.UserId
  367. }
  368. mapUserId = mapUid
  369. return
  370. }
  371. //获取用户已经报名的活动数量
  372. func GetSpecialTripUserSchedule(userId int) (total int, err error) {
  373. var condition string
  374. var pars []interface{}
  375. condition += ` AND t.user_id = ? AND t.is_cancel = 0 `
  376. pars = append(pars, userId)
  377. condition += ` AND a.activity_time_end >= ? `
  378. pars = append(pars, time.Now())
  379. condition += ` AND is_valid = 1 `
  380. total, err = models.GetActivitySpecialTripCountByActivitySpecial(condition, pars)
  381. return
  382. }
  383. //GetActivitySpecialList 获取专项调研列表
  384. func GetActivitySpecialList(user *models.WxUserItem, currentIndex, pageSize int, keywords, conditionActivity string) (list []*models.CygxActivitySpecialDetail, total int, err error) {
  385. listConfirm, totalConfirm, e := GetActivityLabelSpecialConfirmList(user, (currentIndex-1)*pageSize, pageSize, 4, keywords, conditionActivity)
  386. if e != nil {
  387. err = errors.New("GetActivityLabelSpecialConfirmList, Err: " + e.Error())
  388. return
  389. }
  390. if currentIndex == 1 && len(listConfirm) > 0 {
  391. listConfirm[0].Explain = utils.ACtIVITY_SPECIAL_TRIP_EXPLAIN
  392. }
  393. list = listConfirm
  394. total = totalConfirm
  395. var startSizePrepare, pageSizePrepare int
  396. //全是确定行程的查询数据
  397. if totalConfirm >= currentIndex*pageSize {
  398. startSizePrepare = 0
  399. pageSizePrepare = 0
  400. } else if totalConfirm > (currentIndex-1)*pageSize && totalConfirm < currentIndex*pageSize {
  401. //一半确认行程一半预报名
  402. startSizePrepare = 0
  403. pageSizePrepare = pageSize - len(listConfirm)
  404. } else {
  405. //全是预报名
  406. startSizePrepare = (currentIndex-1)*pageSize - totalConfirm
  407. pageSizePrepare = pageSize - len(listConfirm)
  408. }
  409. listPrepare, totalPrepare, e := GetActivitySpecialPrepareList(user, startSizePrepare, pageSizePrepare, keywords, conditionActivity)
  410. if e != nil {
  411. err = errors.New("GetActivityLabelSpecialConfirmList, Err: " + e.Error())
  412. return
  413. }
  414. if len(listPrepare) > 0 {
  415. for _, v := range listPrepare {
  416. list = append(list, v)
  417. }
  418. if startSizePrepare == 0 {
  419. listPrepare[0].Explain = utils.ACtIVITY_SPECIAL_EXPLAIN
  420. }
  421. }
  422. total = totalConfirm + totalPrepare
  423. //处理封面图片
  424. detail, e := models.GetConfigByCode("city_img_url")
  425. if e != nil {
  426. err = errors.New("GetConfigByCode, Err: " + e.Error())
  427. return
  428. }
  429. detailChart, e := models.GetConfigByCode("chart_img_url")
  430. if e != nil {
  431. err = errors.New("GetConfigByCode, Err: " + e.Error())
  432. return
  433. }
  434. addressList := strings.Split(detail.ConfigValue, "{|}")
  435. mapAddress := make(map[string]string)
  436. chartList := strings.Split(detailChart.ConfigValue, "{|}")
  437. mapChart := make(map[string]string)
  438. var cityName string
  439. var chartName string
  440. var imgUrl string
  441. var imgUrlChart string
  442. for _, v := range addressList {
  443. vslice := strings.Split(v, "_")
  444. cityName = vslice[0]
  445. imgUrl = vslice[len(vslice)-1]
  446. mapAddress[cityName] = imgUrl
  447. }
  448. for _, v := range chartList {
  449. vslice := strings.Split(v, "_")
  450. chartName = vslice[0]
  451. imgUrlChart = vslice[len(vslice)-1]
  452. mapChart[chartName] = imgUrlChart
  453. }
  454. for k, v := range list {
  455. //list[k].ImgUrlText = "https://hongze.oss-cn-shanghai.aliyuncs.com/static/images/202112/20211221/bIdfv8t86xrFRpDOeGGHXOmKEuKl.png"
  456. if mapChart[v.ChartPermissionName] != "" {
  457. list[k].ImgUrl = mapChart[v.ChartPermissionName]
  458. }
  459. list[k].ActivityTypeName = "专项调研"
  460. if list[k].Days == 0 {
  461. list[k].TripStatus = 1
  462. } else {
  463. list[k].TripStatus = 2
  464. list[k].TripImgLink = list[k].TripImgLinkFix
  465. }
  466. }
  467. return
  468. }
  469. //HandleActivitySpecialShow 处理活动的状态
  470. func HandleActivitySpecialShow(activityDetail *models.CygxActivitySpecialDetail, user *models.WxUserItem) (item *models.CygxActivitySpecialDetail, err error) {
  471. var activityIds []int
  472. resultTimeStart := utils.StrTimeToTime(activityDetail.ActivityTime) //时间字符串格式转时间格式
  473. resultTimeEnd := utils.StrTimeToTime(activityDetail.ActivityTimeEnd) //时间字符串格式转时间格式
  474. if resultTimeStart.After(time.Now()) {
  475. activityDetail.ActiveState = 1
  476. } else if time.Now().After(resultTimeEnd) {
  477. activityDetail.ActiveState = 3
  478. } else {
  479. activityDetail.ActiveState = 2
  480. }
  481. activityIds = append(activityIds, activityDetail.ActivityId)
  482. //处理用户已经报名了的行程
  483. UserMap, e := GetSpecialTripUserMap(activityIds, user.UserId)
  484. if e != nil {
  485. err = errors.New("GetSpecialTripUserMap, Err: " + e.Error())
  486. return
  487. }
  488. if activityDetail.Days == 0 {
  489. activityDetail.TripStatus = 1
  490. activityDetail.Explain = utils.ACtIVITY_SPECIAL_EXPLAIN
  491. } else {
  492. activityDetail.TripStatus = 2
  493. activityDetail.TripImgLink = activityDetail.TripImgLinkFix
  494. activityDetail.Explain = utils.ACtIVITY_SPECIAL_TRIP_EXPLAIN
  495. }
  496. if _, ok := UserMap[activityDetail.ActivityId]; ok {
  497. activityDetail.IsTrip = 1
  498. }
  499. item = activityDetail
  500. return
  501. }
  502. //活动与专项调研搜索 GetActivitySpecialSearcheList
  503. func GetActivitySpecialSearcheList(user *models.WxUserItem, condition string, startSize, pageSize int, keywords string, playBack int) (items []*models.ActivityDetail, total int, err error) {
  504. var conditionSpecil string
  505. var pars, parsSpecil []interface{}
  506. if keywords != "" {
  507. keywords = "%" + keywords + "%"
  508. conditionSpecil += ` AND art.days > 0 AND (art.research_theme LIKE ? OR art.label LIKE ? OR art.industrial_name LIKE ? OR art.industrial_subject_name LIKE ? ) `
  509. parsSpecil = append(parsSpecil, keywords, keywords, keywords, keywords)
  510. }
  511. if playBack == 1 {
  512. conditionSpecil += ` AND art.activity_id = 0 `
  513. }
  514. list, totalSearche, e := models.GetActivitySpecialSearcheList(condition, pars, conditionSpecil, parsSpecil, startSize, pageSize)
  515. if e != nil {
  516. err = errors.New("GetActivitySpecialSearcheList, Err: " + e.Error())
  517. return
  518. }
  519. items, e = HandleActivityListButton(list, user)
  520. if e != nil {
  521. err = errors.New("HandleActivityListButton, Err: " + e.Error())
  522. return
  523. }
  524. total = totalSearche
  525. return
  526. }
  527. //获取 专项调研客户类型 //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //8、行业升级套餐客户 //9、其余正式客户;5、试用客户
  528. func GetActivitySpecialUserType(companyId int) (userType int, permissionStrnew string, err error) {
  529. var permissionStr string
  530. if companyId <= 1 {
  531. userType = 0
  532. } else {
  533. total, e := models.GetCountCompanyDetailByIdGroupTrip(companyId)
  534. if e != nil {
  535. err = errors.New("GetCountCompanyDetailByIdGroupTrip, Err: " + e.Error())
  536. return
  537. }
  538. if total == 0 {
  539. userType = 0
  540. } else {
  541. companyDetail, e := models.GetCompanyDetailByIdGroupTrip(companyId)
  542. if e != nil {
  543. err = errors.New("GetCompanyDetailByIdGroupTrip, Err: " + e.Error())
  544. return
  545. }
  546. permissionStr, e = models.GetCompanyPermissionByUserTrip(companyId)
  547. if e != nil {
  548. err = errors.New("GetCompanyPermissionByUserTrip, Err: " + e.Error())
  549. return
  550. }
  551. //permissionZhengShiStr, e = models.GetCompanyPermissionByUserZhengShiTrip(companyId)
  552. //if e != nil {
  553. // err = errors.New("GetCompanyPermissionByUserZhengShiTrip, Err: " + e.Error())
  554. // return
  555. //}
  556. //大套餐客户定义:医药、消费、科技、智造。4个行业中为升级,策略是正式,属于大套餐客户
  557. if companyDetail.Status == "永续" {
  558. userType = 1
  559. } else if companyDetail.Status == "试用" {
  560. userType = 5
  561. } else if companyDetail.Status == "正式" {
  562. if permissionStr == "专家" {
  563. userType = 4
  564. } else if strings.Count(permissionStr, "医药") == 2 && strings.Count(permissionStr, "消费") == 2 && strings.Count(permissionStr, "科技") == 2 && strings.Count(permissionStr, "智造") == 2 && strings.Count(permissionStr, "策略") == 1 {
  565. userType = 2
  566. } else {
  567. userType = 3
  568. }
  569. if userType == 3 {
  570. if !strings.Contains(permissionStr, "医药") && !strings.Contains(permissionStr, "消费") && !strings.Contains(permissionStr, "科技") && !strings.Contains(permissionStr, "智造") {
  571. userType = 4
  572. }
  573. }
  574. } else if companyDetail.Status == "冻结" {
  575. userType = 6
  576. } else if companyDetail.Status == "流失" {
  577. userType = 7
  578. }
  579. }
  580. }
  581. permissionStrnew = permissionStr
  582. return
  583. }
  584. //GetSpecialUserType 获取专项产业调研的用户身份类型
  585. //获取 专项调研客户类型 //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //8、行业升级套餐客户 //9、其余正式客户;5、试用客户
  586. func GetSpecialUserType(user *models.WxUserItem) (userType int, err error) {
  587. companyId := user.CompanyId
  588. companyDetail, e := models.GetCompanyDetailByIdGroupTrip(companyId)
  589. if e != nil && e.Error() != utils.ErrNoRow() {
  590. err = errors.New("GetCompanyDetailByIdGroupTrip, Err: " + e.Error())
  591. return
  592. }
  593. if companyDetail == nil {
  594. return
  595. }
  596. if companyId <= 1 {
  597. userType = 0
  598. } else {
  599. if companyDetail.Status == "永续" {
  600. userType = 1
  601. } else {
  602. if companyDetail.Status == "正式" {
  603. list, e := models.GetCompanyReportPermissionUpgrade(companyId, 2)
  604. if e != nil && e.Error() != utils.ErrNoRow() {
  605. err = errors.New("GetCompanyReportPermissionUpgrade, Err: " + e.Error())
  606. }
  607. if len(list) == 0 {
  608. userType = 9
  609. }
  610. if len(list) == 4 {
  611. totalName, e := models.GetCompanyPermissionNameCheck(companyId, 2, "策略")
  612. if e != nil {
  613. err = errors.New("获取品种信息失败, Err:" + e.Error())
  614. return
  615. }
  616. if totalName > 0 {
  617. userType = 2
  618. } else {
  619. userType = 8
  620. }
  621. } else {
  622. userType = 8
  623. }
  624. } else if companyDetail.Status == "试用" {
  625. userType = 5
  626. }
  627. }
  628. }
  629. return
  630. }
  631. //GetSpecialDetailUserPower 处理用户查看专项调研详情的权限
  632. func GetSpecialDetailUserPower(user *models.WxUserItem, activityInfo *models.CygxActivitySpecialDetail) (havePower bool, err error) {
  633. permissionStr, e := GetCompanyPermissionUpgrade(user.CompanyId)
  634. if e != nil {
  635. err = errors.New("GetCompanyPermissionUpgrade, Err: " + e.Error())
  636. return
  637. }
  638. fmt.Println(permissionStr)
  639. //如果没有对应的升级权限,则返回
  640. if !strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  641. return
  642. }
  643. userType, e := GetSpecialUserType(user)
  644. if e != nil {
  645. err = errors.New("GetSpecialUserType, Err: " + e.Error())
  646. return
  647. }
  648. if userType == 0 {
  649. return
  650. }
  651. var pars []interface{}
  652. var condition string
  653. var userTypes string
  654. condition += ` AND art.publish_status = 1 AND art.is_offline = 0 `
  655. userTypes = "%" + strconv.Itoa(userType) + "%"
  656. condition += ` AND art.customer_type_ids LIKE ? `
  657. pars = append(pars, userTypes)
  658. condition += ` AND art.activity_id = ? `
  659. pars = append(pars, activityInfo.ActivityId)
  660. total, e := models.GetActivitySpecialCount(condition, pars)
  661. if e != nil {
  662. err = errors.New("GetSpecialUserType, Err: " + e.Error())
  663. return
  664. }
  665. if total == 1 {
  666. havePower = true
  667. }
  668. return
  669. }
  670. //预报名活动,感兴趣人数满10人时,推送给活动负责人和王芳
  671. func SendWxMsgActivitySpecial10(activityInfo *models.CygxActivitySpecialDetail) (err error) {
  672. activityId := activityInfo.ActivityId
  673. var msg string
  674. defer func() {
  675. if err != nil {
  676. go utils.SendEmail("发送模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format("2006-01-02 15:04:05"), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  677. go utils.SendAlarmMsg(fmt.Sprint("预报名活动,感兴趣人数满10人时,推送给活动负责人和王芳消息发送失败", activityInfo.ResearchTheme, ", activityId"), 2)
  678. utils.FileLog.Info("发送模版消息失败,Err:%s", err.Error())
  679. }
  680. }()
  681. var first string
  682. var keyword1 string
  683. var keyword2 string
  684. var keyword3 string
  685. var keyword4 string
  686. var remark string
  687. adminUser, e := models.GetSellerByAdminId(activityInfo.AdminId)
  688. if e != nil {
  689. err = errors.New("GetSellerByAdminId, Err: " + e.Error())
  690. return
  691. }
  692. cnf, _ := models.GetConfigByCode("tpl_msg")
  693. mobile := adminUser.Mobile + "," + cnf.ConfigValue
  694. specialSignupList, e := models.GetActivityListSpecialByActivityId(activityId)
  695. if e != nil {
  696. err = errors.New("GetActivityListSpecialAll, Err: " + e.Error())
  697. return
  698. }
  699. for _, v := range specialSignupList {
  700. keyword1 += "【" + v.RealName + "--" + v.CompanyName + "】"
  701. }
  702. openIdList, e := models.GetWxOpenIdByMobileList(mobile)
  703. if e != nil {
  704. err = errors.New("GetSellerByAdminId, Err: " + e.Error())
  705. return
  706. }
  707. first = "【" + activityInfo.ResearchTheme + "】已有10人预报名"
  708. keyword3 = "-"
  709. keyword2 = "-"
  710. keyword4 = activityInfo.ResearchTheme
  711. openIdArr := make([]string, 0)
  712. for _, v := range openIdList {
  713. openIdArr = append(openIdArr, v.OpenId)
  714. }
  715. redirectUrl := utils.WX_MSG_PATH_ACTIVITY_SPECIAL_DETAIL + strconv.Itoa(activityId)
  716. sendInfo := new(SendWxTemplate)
  717. sendInfo.First = first
  718. sendInfo.Keyword1 = keyword1
  719. sendInfo.Keyword2 = keyword2
  720. sendInfo.Keyword3 = keyword3
  721. sendInfo.Keyword4 = keyword4
  722. sendInfo.Remark = remark
  723. sendInfo.TemplateId = utils.WxMsgTemplateIdAskMsgXzs
  724. sendInfo.RedirectUrl = redirectUrl
  725. sendInfo.RedirectTarget = 3
  726. sendInfo.Resource = strconv.Itoa(activityId)
  727. sendInfo.SendType = utils.TEMPLATE_MSG_CYGX_ARTICLE_ADD
  728. sendInfo.OpenIdArr = openIdArr
  729. err = PublicSendTemplateMsg(sendInfo)
  730. if err != nil {
  731. return
  732. }
  733. return
  734. }