activity.go 71 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080
  1. package services
  2. import (
  3. "context"
  4. "errors"
  5. "fmt"
  6. "github.com/tealeg/xlsx"
  7. "hongze/hongze_cygx/models"
  8. "hongze/hongze_cygx/utils"
  9. "os"
  10. "path/filepath"
  11. "strconv"
  12. "strings"
  13. "time"
  14. "unicode/utf8"
  15. )
  16. // 修改活动状态
  17. func UpdateActivitySattus(cont context.Context) (err error) {
  18. //defer func() {
  19. // if err != nil {
  20. // fmt.Println("同步失败,Err:", err.Error())
  21. // }
  22. //}()
  23. go models.UpdateActivitySattusToHaveInHand()
  24. go models.UpdateActivitySattusToComplete()
  25. return
  26. }
  27. // 推送会议开始消息提醒60分钟前
  28. func SendActivityBeginMsg(cont context.Context) (err error) {
  29. defer func() {
  30. if err != nil {
  31. go utils.SendAlarmMsg("60分钟会议消息提醒失败", 2)
  32. fmt.Println("发送失败,Err:", err.Error())
  33. }
  34. }()
  35. endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
  36. listActivity, err := models.GetActivitySendMsgListAll(endDate)
  37. fmt.Println(len(listActivity))
  38. if err != nil {
  39. fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
  40. return
  41. }
  42. if len(listActivity) == 0 {
  43. return
  44. }
  45. var remark = "点击查看活动详情"
  46. var signupIds string
  47. for _, v := range listActivity {
  48. signupIds += strconv.Itoa(v.Id) + ","
  49. var reserveResults string
  50. var first string
  51. openIdItem := new(models.OpenIdList)
  52. openIdItem.OpenId = v.OpenId
  53. openIdItem.UserId = v.UserId
  54. openIdList := make([]*models.OpenIdList, 0)
  55. openIdList = append(openIdList, openIdItem)
  56. //if v.FailType == 0 {
  57. // reserveResults = "成功"
  58. //} else if v.FailType == 1 {
  59. // reserveResults = "失败(总人数已满)"
  60. //} else if v.FailType == 2 {
  61. // reserveResults = "失败(单机构超限制)"
  62. //} else if v.FailType == 3 {
  63. // reserveResults = "失败(爽约次数超限)"
  64. //}
  65. reserveResults = "--"
  66. first = "您有一场【" + v.ActivityTypeName + "】将在1小时后开始"
  67. SendWxMsgWithFrequency(first, v.ActivityName, reserveResults, v.ActivityTime, v.Address, remark, openIdList, v.ActivityId)
  68. }
  69. if len(signupIds) == 0 {
  70. return
  71. }
  72. signupIds = strings.TrimRight(signupIds, ",")
  73. err = models.UPdateSendedMsgStatus(signupIds)
  74. if err != nil {
  75. var msg string
  76. go utils.SendEmail("发送模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  77. utils.FileLog.Info("发送模版消息失败,Err:%s", err.Error())
  78. }
  79. return
  80. }
  81. // 推送会议开始消息提醒15分钟前
  82. func SendActivityBeginMsgMeeting(cont context.Context) (err error) {
  83. defer func() {
  84. if err != nil {
  85. go utils.SendAlarmMsg("15分钟会议消息提醒失败", 2)
  86. fmt.Println("发送失败,Err:", err.Error())
  87. }
  88. }()
  89. endDate := time.Now().Add(+time.Minute * 15).Format(utils.FormatDateTime)
  90. listActivity, err := models.GetActivitySendMsgListAllMeeting(endDate)
  91. if err != nil {
  92. fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
  93. return
  94. }
  95. if len(listActivity) == 0 {
  96. return
  97. }
  98. var signupIds string
  99. var remark = "点击查看活动详情"
  100. for _, v := range listActivity {
  101. signupIds += strconv.Itoa(v.Id) + ","
  102. var reserveResults string
  103. var first string
  104. openIdItem := new(models.OpenIdList)
  105. openIdItem.OpenId = v.OpenId
  106. openIdItem.UserId = v.UserId
  107. openIdList := make([]*models.OpenIdList, 0)
  108. openIdList = append(openIdList, openIdItem)
  109. reserveResults = "--"
  110. first = "您有一场【" + v.ActivityTypeName + "】将在15分钟后开始"
  111. SendWxMsgWithFrequency(first, v.ActivityName, reserveResults, v.ActivityTime, "--", remark, openIdList, v.ActivityId)
  112. }
  113. if len(signupIds) == 0 {
  114. return
  115. }
  116. signupIds = strings.TrimRight(signupIds, ",")
  117. err = models.UPdateSendedMsgMeetingStatus(signupIds)
  118. if err != nil {
  119. var msg string
  120. go utils.SendEmail("发送模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  121. utils.FileLog.Info("发送模版消息失败,Err:%s", err.Error())
  122. }
  123. return
  124. }
  125. // 预约外呼名单,会前1小时自动发送邮件给专家组
  126. func SendEmailFileToExpert(cont context.Context) (err error) {
  127. var msg string
  128. var touser string
  129. defer func() {
  130. if err != nil {
  131. fmt.Println("err:", err)
  132. go utils.SendAlarmMsg("发送附件模版消息失败", 2)
  133. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  134. utils.FileLog.Info("发送附件模版消息失败,Err:%s", err.Error())
  135. }
  136. if msg != "" {
  137. fmt.Println(msg)
  138. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  139. }
  140. }()
  141. endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
  142. total, err := models.GetCountActivityIdToSendFile(endDate)
  143. if total == 0 {
  144. fmt.Println("发送附件完成0")
  145. return nil
  146. }
  147. if err != nil {
  148. msg = "发送附件模版消息失败 Err:" + err.Error()
  149. return
  150. }
  151. listActivity, err := models.GetActivityIdToSendFile(endDate)
  152. if err != nil {
  153. msg = "发送附件模版消息失败 Err:" + err.Error()
  154. return
  155. }
  156. for _, v := range listActivity {
  157. time.Sleep(5 * time.Second) //延时五秒,避免邮件发送不成功
  158. activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
  159. if activityInfo == nil {
  160. msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
  161. return
  162. }
  163. list, errFile := models.GetSignupExport(v.ActivityId)
  164. if errFile != nil {
  165. msg = "获取失败,Err:" + errFile.Error()
  166. return
  167. }
  168. //创建excel
  169. dir, errFile := os.Executable()
  170. exPath := filepath.Dir(dir)
  171. downLoadnFilePath := exPath + "/" + time.Now().Format(utils.FormatDateTimeUnSpace) + utils.GetRandDigit(5) + ".xlsx"
  172. xlsxFile := xlsx.NewFile()
  173. if errFile != nil {
  174. msg = "生成文件失败Err:" + errFile.Error()
  175. return
  176. }
  177. style := xlsx.NewStyle()
  178. alignment := xlsx.Alignment{
  179. Horizontal: "center",
  180. Vertical: "center",
  181. WrapText: true,
  182. }
  183. style.Alignment = alignment
  184. style.ApplyAlignment = true
  185. sheet, errFile := xlsxFile.AddSheet("外呼名单")
  186. if errFile != nil {
  187. msg = "新增Sheet失败,Err:" + errFile.Error()
  188. return
  189. }
  190. //设置宽度
  191. _ = sheet.SetColWidth(1, 1, 15)
  192. _ = sheet.SetColWidth(3, 3, 30)
  193. //标头
  194. rowTitle := sheet.AddRow()
  195. cellA := rowTitle.AddCell()
  196. cellA.Value = "姓名"
  197. cellB := rowTitle.AddCell()
  198. cellB.Value = "外呼号码"
  199. cellC := rowTitle.AddCell()
  200. cellC.Value = "国际代码"
  201. cellD := rowTitle.AddCell()
  202. cellD.Value = "公司名称"
  203. cellE := rowTitle.AddCell()
  204. cellE.Value = "所属销售"
  205. for _, item := range list {
  206. row := sheet.AddRow()
  207. cellA := row.AddCell()
  208. cellA.Value = item.RealName
  209. cellB := row.AddCell()
  210. cellB.Value = item.OutboundMobile
  211. cellC := row.AddCell()
  212. if item.CountryCode == "" {
  213. cellC.Value = "86"
  214. } else {
  215. cellC.Value = item.CountryCode
  216. }
  217. cellD := row.AddCell()
  218. cellD.Value = item.CompanyName
  219. cellE := row.AddCell()
  220. cellE.Value = item.SellerName
  221. }
  222. errFile = xlsxFile.Save(downLoadnFilePath)
  223. if errFile != nil {
  224. msg = "保存文件失败Err:" + errFile.Error()
  225. return
  226. }
  227. title := activityInfo.ActivityName + "外呼名单"
  228. content := "外呼名单详情"
  229. fileName := downLoadnFilePath
  230. if activityInfo.ChartPermissionName == "科技" {
  231. touser = utils.EmailTechnology
  232. } else if activityInfo.ChartPermissionName == "医药" {
  233. touser = utils.EmailMedicine
  234. } else if activityInfo.ChartPermissionName == "消费" {
  235. touser = utils.EmailConsumption
  236. } else if activityInfo.ChartPermissionName == "智造" {
  237. touser = utils.EmailZhizao
  238. } else if activityInfo.ChartPermissionName == "策略" {
  239. touser = utils.EmailStrategy
  240. } else if strings.Contains(activityInfo.ChartPermissionName, "研选") {
  241. touser = utils.EmailExpert
  242. }
  243. sendResult := utils.SendEmailByHongze(title, content, touser, fileName, title+".xlsx")
  244. if sendResult {
  245. errFile = models.UPdateActivityIdToSendFile(v.ActivityId)
  246. if errFile != nil {
  247. msg = "获取失败,Err:" + errFile.Error()
  248. return
  249. }
  250. os.Remove(downLoadnFilePath)
  251. } else {
  252. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+activityInfo.ActivityName, utils.EmailSendToUsers)
  253. utils.FileLog.Info("发送附件模版消息失败,Err:%s", activityInfo.ActivityName)
  254. }
  255. }
  256. return
  257. }
  258. func EditOutboundMobile(cont context.Context) (err error) {
  259. defer func() {
  260. if err != nil {
  261. fmt.Println("发送失败,Err:", err.Error())
  262. }
  263. }()
  264. list, err := models.GetActivitySignupListAll()
  265. if err != nil {
  266. fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
  267. return
  268. }
  269. for _, v := range list {
  270. err = models.UPdateSignup(v)
  271. fmt.Println("修改:", strconv.Itoa(v.Id))
  272. if err != nil {
  273. fmt.Println("发送失败,Err:", err.Error()+strconv.Itoa(v.Id))
  274. }
  275. }
  276. fmt.Println("修改完成")
  277. return
  278. }
  279. // 同步用户绑定手机号以及区号
  280. func EditUserOutboundMobile(cont context.Context) (err error) {
  281. defer func() {
  282. if err != nil {
  283. fmt.Println("发送失败,Err:", err.Error())
  284. }
  285. }()
  286. list, err := models.GetUserListAll()
  287. if err != nil {
  288. fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
  289. return
  290. }
  291. for _, v := range list {
  292. err = models.UPdateUserCountryCode(v)
  293. fmt.Println("修改:", strconv.Itoa(v.UserId))
  294. if err != nil {
  295. fmt.Println("发送失败,Err:", err.Error()+strconv.Itoa(v.UserId))
  296. }
  297. }
  298. fmt.Println("修改完成")
  299. return
  300. }
  301. // 获取 用户类型 //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户;6、冻结客户;7、流失客户
  302. func GetUserType(companyId int) (userType int, permissionStrnew string, err error) {
  303. var permissionStr, permissionZhengShiStr string
  304. if companyId <= 1 {
  305. userType = 0
  306. } else {
  307. total, errs := models.GetCountCompanyDetailByIdGroup(companyId)
  308. if errs != nil {
  309. err = errs
  310. return
  311. }
  312. if total == 0 {
  313. userType = 0
  314. } else {
  315. companyDetail, errs := models.GetCompanyDetailByIdGroup(companyId)
  316. if errs != nil {
  317. err = errs
  318. return
  319. }
  320. permissionStr, errs = models.GetCompanyPermission(companyId)
  321. if errs != nil {
  322. err = errs
  323. return
  324. }
  325. permissionStrnew = permissionStr
  326. //大套餐客户,数据库添加标识,
  327. companyUserTypeDetail, errs := models.GetCygxCompanyUserType(companyId)
  328. if errs != nil && errs.Error() != utils.ErrNoRow() {
  329. err = errs
  330. return
  331. }
  332. if companyUserTypeDetail != nil {
  333. if companyUserTypeDetail.CustomerTypeId != 0 {
  334. userType = companyUserTypeDetail.CustomerTypeId
  335. return
  336. }
  337. }
  338. permissionZhengShiStr, errs = models.GetCompanyPermissionByUserZhengShi(companyId)
  339. if errs != nil {
  340. err = errs
  341. return
  342. }
  343. //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户、 10: 30W套餐客户
  344. //大套餐客户定义:医药、消费、科技、智造、策略。5个行业中任意4个及以上是正式权限的,属于大套餐客户(医药、消费、科技、智造需要主客观都开)
  345. if companyDetail.Status == "永续" {
  346. userType = 1
  347. } else if companyDetail.Status == "试用" {
  348. userType = 5
  349. } else if companyDetail.Status == "冻结" {
  350. userType = 6
  351. } else if companyDetail.Status == "流失" {
  352. userType = 7
  353. }
  354. //大套餐客户定义:医药、消费、科技、智造、策略。5个行业中任意4个及以上是正式权限的,属于大套餐客户(医药、消费、科技、智造需要主客观都开)
  355. if userType == 0 && companyDetail.Status == "正式" {
  356. var permissionZhegnshiNum int
  357. if strings.Count(permissionZhengShiStr, "医药") == 2 {
  358. permissionZhegnshiNum++
  359. }
  360. if strings.Count(permissionZhengShiStr, "消费") == 2 {
  361. permissionZhegnshiNum++
  362. }
  363. if strings.Count(permissionZhengShiStr, "科技") == 2 {
  364. permissionZhegnshiNum++
  365. }
  366. if strings.Count(permissionZhengShiStr, "智造") == 2 {
  367. permissionZhegnshiNum++
  368. }
  369. if strings.Count(permissionZhengShiStr, "策略") == 1 {
  370. permissionZhegnshiNum++
  371. }
  372. if strings.Count(permissionZhengShiStr, "路演服务") == 1 {
  373. permissionZhegnshiNum++
  374. }
  375. //if permissionZhegnshiNum == 6 {
  376. // userType = 2
  377. //} else
  378. //大套餐客户,数据库添加标识,条件大于等于四的都是 30W套餐客户
  379. if permissionZhegnshiNum >= 4 {
  380. userType = 10
  381. } else {
  382. userType = 3
  383. }
  384. }
  385. }
  386. }
  387. permissionStrnew = permissionStr
  388. return
  389. }
  390. // GetSpecialDetailUserPower 处理用户查看详情的权限
  391. func GetActivityDetailUserPower(user *models.WxUserItem, activityInfo *models.ActivityDetail) (havePower bool, err error) {
  392. var companyDetailStatus string
  393. var userTypeStr string
  394. //如果是弘则的用户或者宏观的权限不做校验
  395. if user.CompanyId == utils.HZ_COMPANY_ID || activityInfo.ChartPermissionName == utils.HONG_GUAN_NAME {
  396. havePower = true
  397. return
  398. }
  399. userType, permissionStr, e := GetUserType(user.CompanyId)
  400. if e != nil {
  401. err = errors.New("GetCompanyPermissionUpgrade, Err: " + e.Error())
  402. return
  403. }
  404. if activityInfo.LimitPeopleNum > 0 {
  405. mapUserType, e := GetActivityCcustomerTypeList()
  406. if e != nil {
  407. err = e
  408. return
  409. }
  410. userTypeStr = mapUserType[userType]
  411. // 永续客户、大套餐客户、30W套餐客户可以查看行业升级套餐客户 权限
  412. if userTypeStr == "1" || userTypeStr == "2" || userTypeStr == "AA" {
  413. if strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) && strings.Contains(activityInfo.CustomerTypeIds, "8") {
  414. havePower = true
  415. //return
  416. }
  417. }
  418. }
  419. //判断管理规模是否满足
  420. companyProduct, e := models.GetCompanyProductDetail(user.CompanyId, 2)
  421. if e != nil {
  422. err = e
  423. return
  424. }
  425. if companyProduct != nil && activityInfo.Scale != "" {
  426. if strings.Contains(activityInfo.Scale, companyProduct.Scale) {
  427. havePower = true
  428. }
  429. }
  430. if user.CompanyId <= 1 {
  431. return
  432. } else {
  433. if permissionStr == "" {
  434. return
  435. } else {
  436. companyDetail, e := models.GetCompanyDetailById(user.CompanyId)
  437. if e != nil {
  438. err = errors.New("GetCompanyPermissionUpgrade, Err: " + e.Error())
  439. return
  440. }
  441. if companyDetail == nil {
  442. err = errors.New("客户不存在,uid:" + strconv.Itoa(user.UserId) + "CompanyId:" + strconv.Itoa(user.CompanyId))
  443. return
  444. }
  445. companyDetailStatus = companyDetail.Status
  446. }
  447. }
  448. if activityInfo.ChartPermissionId == 1 {
  449. havePower = true
  450. return
  451. }
  452. if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3) && strings.Contains(permissionStr, "专家") && activityInfo.LimitPeopleNum == 0 {
  453. havePower = true
  454. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "正式" && strings.Contains(activityInfo.CustomerTypeIds, "4") {
  455. havePower = true
  456. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "试用" && strings.Contains(activityInfo.CustomerTypeIds, "5") {
  457. havePower = true
  458. } else if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3 || activityInfo.ActivityTypeId == 4 || activityInfo.ActivityTypeId == 5) && strings.Contains(permissionStr, "专家") {
  459. havePower = true
  460. }
  461. if (strings.Contains(activityInfo.ChartPermissionName, "研选") || activityInfo.ChartPermissionName == "策略") && strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  462. havePower = true
  463. return
  464. }
  465. if activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 6 || activityInfo.ActivityTypeId == 7 {
  466. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(主观)") {
  467. havePower = true
  468. } else {
  469. havePower = false
  470. }
  471. } else {
  472. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(客观)") {
  473. havePower = true
  474. } else {
  475. havePower = false
  476. }
  477. }
  478. //如果主客观校验不通过,那么直接返回
  479. if !havePower {
  480. return
  481. }
  482. //如果是易董的活动且属于研选类型,只要开通任何权限就可以查看详情
  483. if activityInfo.YidongActivityId != "" && permissionStr != "" && strings.Contains(activityInfo.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) {
  484. havePower = true
  485. }
  486. permissionShengji, errs := models.GetCompanyPermissionByUserTrip(user.CompanyId)
  487. if errs != nil {
  488. err = errs
  489. return
  490. }
  491. //fmt.Println("主客观2", havePower)
  492. //if strings.Contains(permissionStr, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) {
  493. // havePower = true
  494. //}
  495. //fmt.Println("主客观3", havePower)
  496. //处理升级权限以及用户身份的 双重判断
  497. if activityInfo.CustomerTypeIds != "" {
  498. if !strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) && userTypeStr != "8" {
  499. havePower = false
  500. if strings.Contains(permissionShengji, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, "8") {
  501. havePower = true
  502. }
  503. }
  504. }
  505. if havePower && activityInfo.LimitPeopleNum > 0 {
  506. //对于一些特殊的活动,即使权限满足也不给产看
  507. noPower, e := GetShareNoPowe(activityInfo, permissionStr, userType, user)
  508. if e != nil {
  509. err = errors.New("GetShareNoPowe, Err: " + e.Error())
  510. return
  511. }
  512. if noPower {
  513. havePower = false
  514. }
  515. }
  516. return
  517. }
  518. // 校验被分享的用户是否有查看详情的权限
  519. func GetShareNoPowe(activityInfo *models.ActivityDetail, permissionStr string, userType int, user *models.WxUserItem) (noPower bool, err error) {
  520. //如果是弘则的就不进行可见权限校验
  521. if user.CompanyId == utils.HZ_COMPANY_ID {
  522. return
  523. }
  524. //var noPower bool
  525. //if !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(userType)) {
  526. // noPower = true
  527. //}
  528. //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户
  529. //if userType == 2 && strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(2)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(4)) {
  530. // noPower = true
  531. //}
  532. //if userType == 2 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(2)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
  533. // noPower = true
  534. //}
  535. //if userType == 3 && strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(4)) {
  536. // noPower = true
  537. //}
  538. //if userType == 3 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
  539. // noPower = true
  540. //}
  541. fmt.Println(userType)
  542. if userType == 8 {
  543. permissionShengji, errs := models.GetCompanyPermissionByUserZhengShiTrip(user.CompanyId)
  544. if errs != nil {
  545. err = errs
  546. return
  547. }
  548. if !strings.Contains(permissionShengji, activityInfo.ChartPermissionName) {
  549. noPower = true
  550. return
  551. }
  552. }
  553. if !noPower {
  554. noPower, err = CheckUserPowerByActivityChoose(user, activityInfo)
  555. }
  556. return
  557. }
  558. // 处理活动本组们是否决策人权限
  559. func CheckUserPowerByActivityChoose(user *models.WxUserItem, activityInfo *models.ActivityDetail) (noPower bool, err error) {
  560. //处理 见范围 1,仅本组可见 、2,全部客户可见
  561. if activityInfo.VisibleRange == 1 {
  562. adminIds, errAdmin := models.GetSelleridWhichGroup(user.CompanyId, 2)
  563. if errAdmin != nil {
  564. err = errAdmin
  565. return
  566. }
  567. sliceAdminIds := strings.Split(adminIds, ",")
  568. var haveAdminId bool
  569. for _, v := range sliceAdminIds {
  570. if v == strconv.Itoa(activityInfo.AdminId) {
  571. haveAdminId = true
  572. }
  573. }
  574. if !haveAdminId {
  575. noPower = true
  576. }
  577. }
  578. //处理 是否仅决策人可见 0,否 、1,是
  579. if activityInfo.IsMakerShow == 1 {
  580. if user.IsMaker == 0 {
  581. noPower = true
  582. }
  583. }
  584. return
  585. }
  586. // 校验用户报名的权限
  587. func GetHavePower(activityInfo *models.ActivityDetail, permissionStr, companyDetailStatus string, userType int) (havePower bool, err error) {
  588. // 查研观向7.4-宏观活动不作权限限制
  589. if activityInfo.ChartPermissionId == 1 {
  590. havePower = true
  591. return
  592. }
  593. if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3) && strings.Contains(permissionStr, "专家") && activityInfo.LimitPeopleNum == 0 {
  594. havePower = true
  595. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "正式" && strings.Contains(activityInfo.CustomerTypeIds, "4") {
  596. havePower = true
  597. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "试用" && strings.Contains(activityInfo.CustomerTypeIds, "5") {
  598. havePower = true
  599. //} else if strings.Contains(permissionStr, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(userType)) {
  600. // havePower = true
  601. //} else if strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  602. // havePower = true
  603. } else if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3 || activityInfo.ActivityTypeId == 4 || activityInfo.ActivityTypeId == 5) && strings.Contains(permissionStr, "专家") {
  604. havePower = true
  605. }
  606. if activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 6 || activityInfo.ActivityTypeId == 7 {
  607. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(主观)") {
  608. havePower = true
  609. }
  610. } else {
  611. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(客观)") {
  612. havePower = true
  613. }
  614. }
  615. if (strings.Contains(activityInfo.ChartPermissionName, "研选") || activityInfo.ChartPermissionName == "策略") && strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  616. havePower = true
  617. }
  618. //如果是易董的活动且属于研选类型,只要开通任何权限就可以查看详情
  619. if activityInfo.YidongActivityId != "" && permissionStr != "" && strings.Contains(activityInfo.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) {
  620. havePower = true
  621. }
  622. return
  623. }
  624. // 获取活动列表查询权限的SQL
  625. // @Param ChartPermissionIds query string false "行业id 多个用 , 隔开"
  626. // @Param ActivityTypeIds query string false "活动类型id 多个用 , 隔开"
  627. // @Param ActiveState query string false "活动进行状态 未开始:1、进行中2、已结束3"
  628. // @Param WhichDay query string false "哪一天 今天:1、明天:2,多个用 , 隔开"
  629. // @Param IsPower query int false "是否选择有权限行业 ,1是 0 否 默认0"
  630. // @Param Label query string false "搜索主题 多个用 , 隔开"
  631. // @Param PlayBack query int false "是否仅展示回放 1:是、0:否 默认0"
  632. // @Param KeyWord query string false "搜索关键词 多个用 , 隔开"
  633. // @Param ikType query int false "联想词类型 , 1不做联想,2,做除初始词的联想,3所有联想"
  634. func GetActivityonditionList(user *models.WxUserItem, activityTypeId, chartPermissionIds, whichDay, activeState, label string, isPower, source int, keyWord string, playBack, ikType int) (conditionActivity string, err error) {
  635. keyWordNoIk := keyWord
  636. adminIds, err := models.GetSelleridWhichGroup(user.CompanyId, 2)
  637. if err != nil {
  638. return
  639. }
  640. userType, permissionStr, err := GetUserType(user.CompanyId)
  641. if err != nil {
  642. return
  643. }
  644. //判断客户规模是否属于可见范围的活动
  645. companyProduct, err := models.GetCompanyProductDetail(user.CompanyId, 2)
  646. if err != nil && err.Error() != utils.ErrNoRow() {
  647. return
  648. }
  649. isMaker := user.IsMaker
  650. slicePer := strings.Split(permissionStr, ",")
  651. var permissionSqlStr string
  652. var permissionNameStr string
  653. for _, v := range slicePer {
  654. if userType == 1 {
  655. //研选权限处理
  656. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  657. permissionNameStr += "'" + v + "',"
  658. }
  659. } else {
  660. permissionNameStr += "'" + v + "',"
  661. }
  662. }
  663. permissionNameStr = strings.Replace(permissionNameStr, "(主观)", "", -1)
  664. permissionNameStr = strings.Replace(permissionNameStr, "(客观)", "", -1)
  665. permissionNameStr = strings.TrimRight(permissionNameStr, ",")
  666. mapUserType, e := GetActivityCcustomerTypeList()
  667. if e != nil {
  668. err = e
  669. return
  670. }
  671. var userTypeStr string
  672. userTypeStr = mapUserType[userType]
  673. // 查研观向7.4-始终查询宏观的权限(无论是否有权限)
  674. if permissionNameStr == `` {
  675. permissionNameStr = `'宏观'`
  676. } else {
  677. permissionNameStr += `, '宏观'`
  678. }
  679. var condition string
  680. var conditionAdmin string
  681. var conditionHz string // 弘则权限处理
  682. var sqlExport string // 专家权限处理
  683. //permissionSqlStr = ` AND art.chart_permission_name IN (` + permissionNameStr + `)`
  684. sqlExport = ` AND (art.customer_type_ids LIKE '%` + userTypeStr + `%' `
  685. //if userType == 2 {
  686. // sqlExport += ` OR art.customer_type_ids LIKE '%3%' `
  687. //}
  688. //if (userType == 2 || userType == 3) && strings.Contains(permissionStr, "专家") {
  689. // sqlExport += ` OR art.customer_type_ids LIKE '%4%' `
  690. //}
  691. sqlExport += `) `
  692. // 如果是C类电话会就不展示内容,且合并到分析师电话会
  693. if activityTypeId != "" {
  694. if activityTypeId == strconv.Itoa(utils.ANALYST_TELL_ACTIVITY_TYPE_ID) {
  695. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id IN (` + activityTypeId + "," + strconv.Itoa(utils.C_CLASS_ACTIVITY_TYPE_ID) + `)`
  696. } else {
  697. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id IN (` + activityTypeId + `)`
  698. }
  699. }
  700. //主题
  701. if label != "" {
  702. condition = ` AND art.label LIKE '%` + label + `%' `
  703. }
  704. if isPower == 1 {
  705. condition += permissionSqlStr
  706. }
  707. //行业名称
  708. if len(chartPermissionIds) > 0 {
  709. condition += ` AND art.chart_permission_id IN (` + chartPermissionIds + `)`
  710. }
  711. //如果是PC的,则不看易董的
  712. if source == 1 {
  713. condition += ` AND art.yidong_activity_id = '' `
  714. }
  715. var conditionOr string
  716. if whichDay != "" {
  717. var startDate string
  718. var endDate string
  719. if whichDay == "1" {
  720. startDate = time.Now().Format(utils.FormatDate)
  721. endDate = startDate
  722. } else if whichDay == "2" {
  723. startDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  724. endDate = startDate
  725. } else if whichDay == "3" {
  726. startDate = utils.GetNowWeekMonday().Format(utils.FormatDate)
  727. endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
  728. } else if whichDay == "4" {
  729. startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
  730. endDate = utils.GetLastWeekSunday().Format(utils.FormatDate)
  731. } else if whichDay == "5" {
  732. startDate = utils.GetNowMonthFirstDay().Format(utils.FormatDate)
  733. endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
  734. } else if whichDay == "6" {
  735. startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
  736. endDate = utils.GetLastMonthLastDay().Format(utils.FormatDate)
  737. } else if whichDay == "1,2" {
  738. startDate = time.Now().Format(utils.FormatDate)
  739. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  740. } else if whichDay == "3,4" {
  741. startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
  742. endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
  743. } else if whichDay == "5,6" {
  744. startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
  745. endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
  746. } else {
  747. startDate = time.Now().Format(utils.FormatDate)
  748. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  749. }
  750. condition += ` AND art.activity_time >= ` + "'" + startDate + " 00:00:00'"
  751. condition += ` AND art.activity_time <= ` + "'" + endDate + " 23:59:59'"
  752. }
  753. //有搜索条件传过来时,不判进行状态条件
  754. if keyWord != "" {
  755. if ikType == 2 || ikType == 3 {
  756. keyWordArr, e := GetIndustryMapNameSliceV3(keyWord)
  757. if e != nil {
  758. err = errors.New("获取分词失败,GetIndustryMapNameSliceV3, Err: " + keyWord + e.Error())
  759. return
  760. }
  761. keyWordArr = RemoveDuplicatesAndEmpty(keyWordArr)
  762. //var keywords string
  763. if len(keyWordArr) > 1 {
  764. if ikType == 2 {
  765. keyWord = KeyWordArrSqlRegexp(keyWordArr)
  766. condition += ` AND (art.label NOT LIKE '%` + keyWordNoIk + `%' AND art.activity_name NOT LIKE '%` + keyWordNoIk + `%' ) `
  767. } else if ikType == 3 {
  768. keyWord = KeyWordArrSqlRegexpAll(keyWordArr)
  769. }
  770. }
  771. }
  772. condition += ` AND (art.label REGEXP '` + keyWord + `' OR art.activity_name REGEXP '` + keyWord + `' ) `
  773. } else {
  774. if activeState != "" {
  775. // 默认查看未开始跟进行中
  776. if activeState == "1" {
  777. condition += ` AND art.active_state IN (1,2)`
  778. } else {
  779. condition += ` AND art.active_state IN (` + activeState + `)`
  780. }
  781. } else {
  782. condition += ` AND art.active_state IN (1,2)`
  783. }
  784. }
  785. if playBack == 1 {
  786. var pars []interface{}
  787. ativityVIdArry := make([]string, 0)
  788. voiceList, e := models.GetActivityVoiceListAll("", pars, 0, 1000)
  789. if e != nil && e.Error() != utils.ErrNoRow() {
  790. err = e
  791. return
  792. }
  793. for _, v := range voiceList {
  794. ativityVIdArry = append(ativityVIdArry, strconv.Itoa(v.ActivityId))
  795. }
  796. videoList, e := models.GetActivityVideoListAll("", pars, 0, 1000)
  797. if e != nil && e.Error() != utils.ErrNoRow() {
  798. err = e
  799. return
  800. }
  801. for _, v := range videoList {
  802. ativityVIdArry = append(ativityVIdArry, strconv.Itoa(v.ActivityId))
  803. }
  804. //活动音频,设置有效时间为30天,失效后该活动就不再支持音频回放。有效期起始时间为活动的开始时间
  805. //endTime := time.Now().AddDate(0, 0, -30).Format("2006-01-02 15:04:05")
  806. //condition += ` AND art.activity_time > '` + endTime + `' `
  807. if len(ativityVIdArry) > 0 {
  808. ativityVIdstr := strings.Join(ativityVIdArry, ",")
  809. condition += ` AND art.activity_id IN (` + ativityVIdstr + `) `
  810. } else {
  811. condition += ` AND art.activity_id = 0 `
  812. }
  813. }
  814. //查询全部可见的数据(是否全部客户可见)
  815. //condition += ` AND art.visible_range != 1 AND art.publish_status = 1 `
  816. condition += ` AND art.publish_status = 1 `
  817. if adminIds == "" {
  818. //condition += ` AND art.visible_range != 1 `
  819. } else {
  820. condition += ` AND ( art.visible_range != 1 OR ( art.admin_id IN ( ` + adminIds + ` ) AND art.visible_range = 1 )) `
  821. }
  822. conditionHz = condition
  823. //活动仅决策人可见
  824. if isMaker == 0 {
  825. condition += ` AND art.is_maker_show = 0 `
  826. }
  827. conditionAdmin = condition + ` AND art.visible_range = 1 `
  828. //condition += ` AND art.visible_range != 1 `
  829. if (userType == 2 || userType == 3 || userType == 4) && strings.Contains(permissionStr, "专家") {
  830. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%4%' ` + condition + `) `
  831. }
  832. if (userType == 5) && strings.Contains(permissionStr, "专家") {
  833. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%5%' ` + condition + `) `
  834. }
  835. if userType == 1 {
  836. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + permissionSqlStr + `) `
  837. } else {
  838. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
  839. }
  840. if userType == 6 || userType == 7 {
  841. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' ` + condition + `) `
  842. }
  843. if companyProduct != nil {
  844. if companyProduct.Scale != "" {
  845. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%' ` + condition + `) `
  846. }
  847. }
  848. if adminIds != "" {
  849. if userType == 3 {
  850. conditionAdmin += ` AND art.chart_permission_name IN (` + permissionNameStr + `) `
  851. }
  852. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + userTypeStr + `%' ` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
  853. if companyProduct != nil {
  854. if companyProduct.Scale != "" {
  855. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%'` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
  856. }
  857. }
  858. }
  859. conditionShengji, conditionZhengshi, conditionHangYe, e := ActivityLabelSpecialUserSql(user)
  860. if e != nil {
  861. err = errors.New("ActivityLabelSpecialUserSql, Err: " + e.Error())
  862. return
  863. }
  864. if conditionShengji != "" {
  865. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionShengji + condition + ` ) `
  866. }
  867. if conditionZhengshi != "" {
  868. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionZhengshi + condition + ` ) `
  869. }
  870. if conditionHangYe != "" {
  871. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionHangYe + condition + ` ) `
  872. }
  873. //弘则研究下的客户不做权限,限制,C类电话会,仅本组销售、部门管理员、admin、权益研究员账号能看到
  874. if user.CompanyId == utils.HZ_COMPANY_ID {
  875. mapMobile, e := GetAdminMobileMap()
  876. if e != nil {
  877. err = e
  878. return
  879. }
  880. if _, ok := mapMobile[user.Mobile]; ok {
  881. conditionOr += ` OR ( art.publish_status = 1 ` + conditionHz + `) `
  882. }
  883. }
  884. if userType == 3 {
  885. condition += ` AND art.chart_permission_name IN (` + permissionNameStr + `) `
  886. }
  887. conditionActivity = condition + permissionSqlStr + sqlExport + conditionOr
  888. return
  889. }
  890. // 研选系列专家电话会,会前1小时将问题列表发送给邮箱
  891. func SendEmailFileForAskMsgResearch(cont context.Context) (err error) {
  892. var msg string
  893. //var touser string
  894. defer func() {
  895. if err != nil {
  896. go utils.SendAlarmMsg("发送附件模版消息失败", 2)
  897. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  898. }
  899. if msg != "" {
  900. go utils.SendAlarmMsg(msg, 2)
  901. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  902. }
  903. }()
  904. endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
  905. condition := `AND a.activity_type_id = 1 AND a.chart_permission_id = 31 `
  906. total, err := models.GetCountActivityResearchToSendFile(condition, endDate)
  907. if total == 0 {
  908. fmt.Println("发送附件完成0")
  909. return nil
  910. }
  911. if err != nil {
  912. msg = "发送附件模版消息失败 Err:" + err.Error()
  913. return
  914. }
  915. listActivity, err := models.GetActivityResearchToSendFile(condition, endDate)
  916. if err != nil {
  917. msg = "发送附件模版消息失败 Err:" + err.Error()
  918. return
  919. }
  920. for _, v := range listActivity {
  921. activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
  922. if activityInfo == nil {
  923. msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
  924. return
  925. }
  926. list, errFile := models.GetActivityMsgExport(v.ActivityId)
  927. if errFile != nil {
  928. msg = "获取失败,Err:" + errFile.Error()
  929. return
  930. }
  931. for _, v2 := range list {
  932. user, err := models.GetWxUserItemByUserId(v2.UserId)
  933. if err != nil && err.Error() != utils.ErrNoRow() {
  934. return err
  935. }
  936. //获取销售信息
  937. sellerItem, err := models.GetSellerByCompanyIdCheckFicc(v2.CompanyId, 2)
  938. if err != nil && err.Error() != utils.ErrNoRow() {
  939. return err
  940. }
  941. //给研究员推送消息
  942. if sellerItem != nil {
  943. openIpItem, _ := models.GetUserRecordByMobile(4, utils.ActSendMsgMobile)
  944. if openIpItem != nil && openIpItem.OpenId != "" {
  945. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  946. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  947. }
  948. }
  949. //给所属销售推送消息
  950. if sellerItem != nil {
  951. openIpItem, _ := models.GetUserRecordByMobile(4, sellerItem.Mobile)
  952. if openIpItem != nil && openIpItem.OpenId != "" {
  953. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  954. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  955. }
  956. }
  957. }
  958. errFile = models.UPdateActivityMsgToSendFile(v.ActivityId)
  959. if errFile != nil {
  960. msg = "获取失败,Err:" + errFile.Error()
  961. return
  962. }
  963. }
  964. return
  965. }
  966. // 非研选系列专家电话会,根据主持人姓名,会前15分钟将问题列表发送给至该主持人对应邮箱
  967. func SendEmailFileForAskMsg(cont context.Context) (err error) {
  968. var msg string
  969. //var touser string
  970. defer func() {
  971. if err != nil {
  972. go utils.SendAlarmMsg("发送附件模版消息失败", 2)
  973. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  974. }
  975. if msg != "" {
  976. go utils.SendAlarmMsg(msg, 2)
  977. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  978. }
  979. }()
  980. endDate := time.Now().Add(+time.Minute * 15).Format(utils.FormatDateTime)
  981. condition := `AND a.activity_type_id = 1 AND a.chart_permission_id != 31 `
  982. total, err := models.GetCountActivityResearchToSendFile(condition, endDate)
  983. if total == 0 {
  984. fmt.Println("发送附件完成0")
  985. return nil
  986. }
  987. if err != nil {
  988. msg = "发送附件模版消息失败 Err:" + err.Error()
  989. return
  990. }
  991. listActivity, err := models.GetActivityResearchToSendFile(condition, endDate)
  992. if err != nil {
  993. msg = "发送附件模版消息失败 Err:" + err.Error()
  994. return
  995. }
  996. listEmail, errEmail := models.GetAskEmail()
  997. if errEmail != nil {
  998. msg = "获取失败,Err:" + errEmail.Error()
  999. return
  1000. }
  1001. for _, v := range listActivity {
  1002. activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
  1003. if activityInfo == nil {
  1004. msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
  1005. return
  1006. }
  1007. list, errFile := models.GetActivityMsgExport(v.ActivityId)
  1008. if errFile != nil {
  1009. msg = "获取失败,Err:" + errFile.Error()
  1010. return
  1011. }
  1012. for _, v2 := range list {
  1013. user, err := models.GetWxUserItemByUserId(v2.UserId)
  1014. if err != nil && err.Error() != utils.ErrNoRow() {
  1015. return err
  1016. }
  1017. var sendMobile string
  1018. for _, vEmail := range listEmail {
  1019. if strings.Index(activityInfo.Host, vEmail.Name) > 0 {
  1020. sendMobile = vEmail.Mobile
  1021. }
  1022. }
  1023. //获取销售信息
  1024. sellerItem, err := models.GetSellerByCompanyIdCheckFicc(v2.CompanyId, 2)
  1025. if err != nil && err.Error() != utils.ErrNoRow() {
  1026. return err
  1027. }
  1028. //给研究员推送模板消息
  1029. if sellerItem != nil {
  1030. openIpItem, _ := models.GetUserRecordByMobile(4, sendMobile)
  1031. if openIpItem != nil && openIpItem.OpenId != "" {
  1032. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  1033. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  1034. }
  1035. }
  1036. //给销售推送模板消息
  1037. if sellerItem != nil {
  1038. openIpItem, _ := models.GetUserRecordByMobile(4, sellerItem.Mobile)
  1039. if openIpItem != nil && openIpItem.OpenId != "" {
  1040. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  1041. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  1042. }
  1043. }
  1044. }
  1045. errFile = models.UPdateActivityMsgToSendFile(v.ActivityId)
  1046. if errFile != nil {
  1047. msg = "获取失败,Err:" + errFile.Error()
  1048. return
  1049. }
  1050. }
  1051. return
  1052. }
  1053. // 活动标签字符串处理
  1054. func LabelStr(label string) (labelNew string) {
  1055. slicebr := strings.Split(label, "-")
  1056. if len(slicebr) < 2 {
  1057. labelNew = label
  1058. } else {
  1059. labelNew = slicebr[1]
  1060. }
  1061. return labelNew
  1062. }
  1063. // 5.3版本活动标签字符串处理
  1064. func LabelStrV5(label string, isShowSubjectName int, temporaryLabel string) (labelNew string) {
  1065. slicebr := strings.Split(label, "-")
  1066. if len(slicebr) > 1 {
  1067. if isShowSubjectName == 1 {
  1068. labelNew = slicebr[1]
  1069. } else {
  1070. labelNew = slicebr[0]
  1071. }
  1072. } else {
  1073. labelNew = label
  1074. }
  1075. if temporaryLabel != "" {
  1076. labelNew = temporaryLabel
  1077. }
  1078. return labelNew
  1079. }
  1080. func ActivityAttendanceDetail(cont context.Context) (err error) {
  1081. defer func() {
  1082. if err != nil {
  1083. fmt.Println("ActivityAttendanceDetail Err:" + err.Error())
  1084. go utils.SendAlarmMsg("同步进门财经数据失败", 2)
  1085. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "ActivityAttendanceDetail ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1086. }
  1087. }()
  1088. configCode := "jin_meng_activity_id"
  1089. detail, err := models.GetConfigByCode(configCode)
  1090. if err != nil {
  1091. return err
  1092. }
  1093. fmt.Println(detail.ConfigValue)
  1094. mapActivityId := make(map[string]string)
  1095. sliceValue := strings.Split(detail.ConfigValue, ",")
  1096. for _, v := range sliceValue {
  1097. mapActivityId[v] = v
  1098. }
  1099. var activityIds string
  1100. var activityIdsLongTime string //可回放的会议,到会详情持续更新加入到不做14天限制的活动中
  1101. fmt.Println("开始同步")
  1102. dateTime := time.Now().AddDate(0, 0, -14).Format(utils.FormatDate)
  1103. dateNow := time.Now().AddDate(0, 0, 0).Format(utils.FormatDate)
  1104. startDate := dateTime + " 00:00:00"
  1105. endDate := dateNow + " 23:59:59"
  1106. //获取进门财经需要处理的活动
  1107. listActivityRoadshow, err := models.GetRoadshowDataListByDateTime(startDate, endDate)
  1108. if err != nil {
  1109. fmt.Println("GetRoadshowDataListByDateTime Err:", err.Error())
  1110. return err
  1111. }
  1112. for _, vAct := range listActivityRoadshow {
  1113. doTime := utils.TimeRemoveHms2(vAct.RoadshowBeginTime)
  1114. findStartDate := doTime + " 00:00:00"
  1115. findEndDate := doTime + " 23:59:59"
  1116. var roadshowTitle string
  1117. roadshowTitle = vAct.RoadshowTitle
  1118. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "【", "", -1)
  1119. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "】", "", -1)
  1120. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, " ", "", -1)
  1121. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "-", "", -1)
  1122. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, ":", "", -1)
  1123. nameSlice := strings.Split(vAct.RoadshowTitle, "|")
  1124. //fmt.Println(timeSlice[0])
  1125. //对于手动匹配到的活动数据也要更新
  1126. var activityName string
  1127. if len(nameSlice) >= 1 {
  1128. //if vAct.JmcjRoadshowTitle != "" {
  1129. // activityName = vAct.JmcjRoadshowTitle
  1130. //} else {
  1131. // activityName = nameSlice[len(nameSlice)-1]
  1132. //}
  1133. activityName = nameSlice[len(nameSlice)-1]
  1134. if activityName != "" {
  1135. //通过名称去找匹配的活动
  1136. activityDetail, _ := models.GetAddActivityInfoByTitle(activityName, findStartDate, findEndDate)
  1137. if activityDetail == nil {
  1138. continue
  1139. } else {
  1140. activityIds += strconv.Itoa(activityDetail.ActivityId) + ","
  1141. }
  1142. list, err := models.GetRoadshowDataList(roadshowTitle, findStartDate, findEndDate)
  1143. if err != nil {
  1144. fmt.Println("GetTacticsList Err:", err.Error())
  1145. return err
  1146. }
  1147. var isPlayback bool // 是否包含回放
  1148. needAddAttendanc := make([]*models.CygxActivityAttendanceDetail, 0)
  1149. var mobileStr string
  1150. if len(list) > 0 {
  1151. fmt.Println("原来的", vAct.RoadshowTitle)
  1152. fmt.Println("处理的", activityName)
  1153. for _, v := range list {
  1154. if v.UserPhone != "" {
  1155. item := new(models.CygxActivityAttendanceDetail)
  1156. item.ActivityId = activityDetail.ActivityId
  1157. item.RealName = v.UserName
  1158. item.Mobile = v.UserPhone
  1159. item.CompanyName = v.Company
  1160. //item.SellerName = sellerName
  1161. item.FirstMeetingTime = v.FirstWatchTime
  1162. item.LastMeetingTime = v.LastWatchTime
  1163. item.Duration = utils.GetAttendanceDetailSeconds(v.JoinTime)
  1164. if v.JoinType == 1 {
  1165. item.MeetingTypeStr = "网络"
  1166. } else {
  1167. item.MeetingTypeStr = "电话"
  1168. }
  1169. item.MeetingAuthentication = v.AuthInfo
  1170. if v.DataType == 1 {
  1171. item.MeetingStatusStr = "直播"
  1172. } else {
  1173. item.MeetingStatusStr = "回放"
  1174. isPlayback = true
  1175. }
  1176. item.Position = v.Occupation
  1177. item.UseridEntity = v.UseridEntity
  1178. item.ActivityTime = activityDetail.ActivityTime
  1179. item.CrmCompanyMapStatusId = v.CrmCompanyMapStatusId
  1180. item.CreateTime = time.Now()
  1181. mobileStr += "'" + v.UserPhone + "'" + ","
  1182. needAddAttendanc = append(needAddAttendanc, item)
  1183. }
  1184. }
  1185. if isPlayback && mapActivityId[strconv.Itoa(activityDetail.ActivityId)] == "" {
  1186. activityIdsLongTime += strconv.Itoa(activityDetail.ActivityId) + ","
  1187. }
  1188. mobileStr = strings.TrimRight(mobileStr, ",")
  1189. if mobileStr == "" {
  1190. mobileStr = "1"
  1191. }
  1192. listUser, err := models.GetWxUserOutboundMobile(mobileStr)
  1193. if err != nil {
  1194. fmt.Println("GetWxUserOutboundMobile Err:", err.Error())
  1195. return err
  1196. }
  1197. for k, v := range needAddAttendanc {
  1198. for _, v2 := range listUser {
  1199. if v2.OutboundMobile == v.Mobile || v2.Mobile == v.Mobile {
  1200. if needAddAttendanc[k].CompanyId == 0 {
  1201. needAddAttendanc[k].CompanyId = v2.CompanyId
  1202. needAddAttendanc[k].SellerName = v2.SellerName
  1203. needAddAttendanc[k].CompanyName = v2.CompanyName
  1204. needAddAttendanc[k].IsMeetingStr = 1
  1205. }
  1206. }
  1207. }
  1208. }
  1209. //fmt.Println(mobileStr)
  1210. //参会记录
  1211. err = models.AddAttendancDetail(needAddAttendanc, activityDetail.ActivityId, mobileStr)
  1212. if err != nil {
  1213. fmt.Println("AddAttendancDetail Err:", err.Error())
  1214. return err
  1215. }
  1216. ////处理是否限制报名
  1217. err = AddCygxActivityRestrictSignupByAdmin(activityDetail.ActivityId)
  1218. if err != nil {
  1219. fmt.Println("AddCygxActivityRestrictSignupByAdmin Err:", err.Error())
  1220. return err
  1221. }
  1222. go AddctivitySignupDetailByJmcj(needAddAttendanc, activityDetail.ActivityId)
  1223. }
  1224. }
  1225. }
  1226. }
  1227. //获取需要处理的活动
  1228. listActivity, err := models.GetActivityListByDateTime(startDate, endDate, activityIds, detail.ConfigValue)
  1229. if err != nil {
  1230. fmt.Println("GetTacticsList Err:", err.Error())
  1231. return err
  1232. }
  1233. //通过本地去找进门财经的数据
  1234. for _, vAct := range listActivity {
  1235. doTime := utils.TimeRemoveHms2(vAct.ActivityTime)
  1236. findStartDate := doTime + " 00:00:00"
  1237. findEndDate := doTime + " 23:59:59"
  1238. nameSlice := strings.Split(vAct.ActivityName, "】")
  1239. //对于手动匹配到的活动数据也要更新
  1240. var activityName string
  1241. if len(nameSlice) > 1 {
  1242. if vAct.JmcjRoadshowTitle != "" {
  1243. activityName = vAct.JmcjRoadshowTitle
  1244. } else {
  1245. activityName = nameSlice[len(nameSlice)-1]
  1246. }
  1247. //activityName = nameSlice[len(nameSlice)-1]
  1248. if activityName != "" {
  1249. list, err := models.GetRoadshowDataList(activityName, findStartDate, findEndDate)
  1250. if err != nil {
  1251. fmt.Println("GetTacticsList Err:", err.Error())
  1252. return err
  1253. }
  1254. var isPlayback bool // 是否包含回放
  1255. needAddAttendanc := make([]*models.CygxActivityAttendanceDetail, 0)
  1256. var mobileStr string
  1257. if len(list) > 0 {
  1258. fmt.Println("原来的1", vAct.ActivityName)
  1259. fmt.Println("处理的2", activityName)
  1260. for _, v := range list {
  1261. if v.UserPhone != "" {
  1262. item := new(models.CygxActivityAttendanceDetail)
  1263. item.ActivityId = vAct.ActivityId
  1264. item.RealName = v.UserName
  1265. item.Mobile = v.UserPhone
  1266. item.CompanyName = v.Company
  1267. //item.SellerName = sellerName
  1268. item.FirstMeetingTime = v.FirstWatchTime
  1269. item.LastMeetingTime = v.LastWatchTime
  1270. item.Duration = utils.GetAttendanceDetailSeconds(v.JoinTime)
  1271. if v.JoinType == 1 {
  1272. item.MeetingTypeStr = "网络"
  1273. } else {
  1274. item.MeetingTypeStr = "电话"
  1275. }
  1276. item.MeetingAuthentication = v.AuthInfo
  1277. if v.DataType == 1 {
  1278. item.MeetingStatusStr = "直播"
  1279. } else {
  1280. item.MeetingStatusStr = "回放"
  1281. isPlayback = true
  1282. }
  1283. item.Position = v.Occupation
  1284. item.UseridEntity = v.UseridEntity
  1285. item.ActivityTime = vAct.ActivityTime
  1286. item.CrmCompanyMapStatusId = v.CrmCompanyMapStatusId
  1287. item.CreateTime = time.Now()
  1288. mobileStr += "'" + v.UserPhone + "'" + ","
  1289. needAddAttendanc = append(needAddAttendanc, item)
  1290. }
  1291. }
  1292. if isPlayback && mapActivityId[strconv.Itoa(vAct.ActivityId)] == "" {
  1293. activityIdsLongTime += strconv.Itoa(vAct.ActivityId) + ","
  1294. }
  1295. mobileStr = strings.TrimRight(mobileStr, ",")
  1296. if mobileStr == "" {
  1297. mobileStr = "1"
  1298. }
  1299. listUser, err := models.GetWxUserOutboundMobile(mobileStr)
  1300. if err != nil {
  1301. fmt.Println("GetWxUserOutboundMobile Err:", err.Error())
  1302. return err
  1303. }
  1304. for k, v := range needAddAttendanc {
  1305. for _, v2 := range listUser {
  1306. if v2.OutboundMobile == v.Mobile || v2.Mobile == v.Mobile {
  1307. if needAddAttendanc[k].CompanyId == 0 {
  1308. needAddAttendanc[k].CompanyId = v2.CompanyId
  1309. needAddAttendanc[k].SellerName = v2.SellerName
  1310. needAddAttendanc[k].CompanyName = v2.CompanyName
  1311. needAddAttendanc[k].IsMeetingStr = 1
  1312. }
  1313. }
  1314. }
  1315. }
  1316. ////参会记录
  1317. err = models.AddAttendancDetail(needAddAttendanc, vAct.ActivityId, mobileStr)
  1318. if err != nil {
  1319. fmt.Println("AddAttendancDetail Err:", err.Error())
  1320. return err
  1321. }
  1322. ////处理是否限制报名
  1323. err = AddCygxActivityRestrictSignupByAdmin(vAct.ActivityId)
  1324. if err != nil {
  1325. fmt.Println("AddCygxActivityRestrictSignupByAdmin Err:", err.Error())
  1326. return err
  1327. }
  1328. activityIds += strconv.Itoa(vAct.ActivityId) + ","
  1329. go AddctivitySignupDetailByJmcj(needAddAttendanc, vAct.ActivityId)
  1330. }
  1331. }
  1332. }
  1333. }
  1334. if activityIdsLongTime != "" {
  1335. activityIdsLongTime = strings.TrimRight(activityIdsLongTime, ",")
  1336. activityIdsLongTime = detail.ConfigValue + "," + activityIdsLongTime
  1337. go models.UpdateConfigByCode(activityIdsLongTime, configCode)
  1338. }
  1339. activityIds = strings.TrimRight(activityIds, ",")
  1340. if activityIds != "" {
  1341. detailList, err := models.GetActivityAttendanceDetailList(activityIds)
  1342. if err != nil {
  1343. fmt.Println("GetActivityAttendanceDetailList Err:", err.Error())
  1344. return err
  1345. }
  1346. //添加报名日志 (下载使用)
  1347. err = models.AddCygxActivityMeetDetailLogOnlineByList(detailList, activityIds)
  1348. if err != nil {
  1349. fmt.Println("AddCygxActivityMeetDetailLogOnline Err:", err.Error())
  1350. return err
  1351. }
  1352. }
  1353. fmt.Println("结束路演同步")
  1354. return
  1355. }
  1356. // 判断是否加入黑名单
  1357. func AddCygxActivityRestrictSignupByAdmin(activityId int) (err error) {
  1358. total, err := models.GetActivitySignupNomeetingCount(activityId)
  1359. if err != nil {
  1360. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1361. fmt.Println(" Err:", err.Error())
  1362. return err
  1363. }
  1364. if total == 0 {
  1365. return err
  1366. }
  1367. mobileList, _ := models.GetUserMeetingMobile(activityId)
  1368. if len(mobileList) >= 0 {
  1369. for _, v := range mobileList {
  1370. totalRestrict, err := models.GetRestrictSignupCountByUid(v.UserId)
  1371. if err != nil {
  1372. fmt.Println(" Err:", err.Error())
  1373. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1374. return err
  1375. }
  1376. totalNomeet, err := models.GetActivitySignupNomeetingCountByUid(v.UserId)
  1377. if err != nil {
  1378. fmt.Println(" Err:", err.Error())
  1379. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1380. return err
  1381. }
  1382. if totalRestrict > 0 && totalNomeet < 3 {
  1383. err = models.DeleteCygxActivityRestrictSignup(v.UserId)
  1384. if err != nil {
  1385. fmt.Println(" Err:", err.Error())
  1386. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1387. return err
  1388. }
  1389. }
  1390. }
  1391. }
  1392. list, err := models.GetActivitySignupNomeetingCountList(activityId)
  1393. if err != nil {
  1394. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1395. fmt.Println(" 用户限制报名失败 Err:", err.Error())
  1396. return err
  1397. }
  1398. for _, v := range list {
  1399. totalRestrict, err := models.GetRestrictSignupCountByUid(v.UserId)
  1400. if err != nil {
  1401. fmt.Println(" Err:", err.Error())
  1402. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1403. return err
  1404. }
  1405. totalNomeet, err := models.GetActivitySignupNomeetingCountByUid(v.UserId)
  1406. if err != nil {
  1407. fmt.Println(" Err:", err.Error())
  1408. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1409. return err
  1410. }
  1411. if totalNomeet >= 3 {
  1412. if totalRestrict == 0 {
  1413. infoUser, err := models.GetUserAndCompanyNameList(v.UserId)
  1414. if err != nil {
  1415. fmt.Println(" Err:", err.Error())
  1416. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1417. return err
  1418. }
  1419. if infoUser != nil {
  1420. item := new(models.CygxActivityRestrictSignup)
  1421. item.UserId = infoUser.UserId
  1422. item.CreateTime = time.Now()
  1423. item.Mobile = infoUser.Mobile
  1424. item.Email = infoUser.Email
  1425. item.CompanyId = infoUser.CompanyId
  1426. item.CompanyName = infoUser.CompanyName
  1427. item.IsRestrict = 1
  1428. err = models.AddCygxActivityRestrictSignup(item)
  1429. if err != nil {
  1430. fmt.Println(" Err:", err.Error())
  1431. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1432. return err
  1433. }
  1434. }
  1435. }
  1436. }
  1437. }
  1438. return
  1439. }
  1440. // 判断预约纪要按钮是否显示
  1441. func IsShowAppointment(activityTypeId int, chartPermissionName string) (isShowAppointment bool) {
  1442. if activityTypeId == 1 || activityTypeId == 2 || activityTypeId == 3 || activityTypeId == 4 {
  1443. isShowAppointment = true
  1444. }
  1445. if activityTypeId == 5 && chartPermissionName == "医药" {
  1446. isShowAppointment = true
  1447. }
  1448. return
  1449. }
  1450. // 判断预约纪要按钮是否显示
  1451. func IsShowAppointmentByactivityInfo(item *models.ActivityDetail, chartPermissionName string) (isShowAppointment bool) {
  1452. activityTypeId := item.ActivityTypeId
  1453. if activityTypeId == 1 || activityTypeId == 3 || activityTypeId == 4 {
  1454. isShowAppointment = true
  1455. }
  1456. if activityTypeId == 5 && chartPermissionName == "医药" {
  1457. isShowAppointment = true
  1458. }
  1459. if activityTypeId == 2 && item.IsLimitPeople == 0 {
  1460. isShowAppointment = true
  1461. }
  1462. return
  1463. }
  1464. // 用户报告操作行为,模板消息推送 (先放在活动模块下,避免代码冲突)
  1465. func ArticleUserRemind(user *models.WxUserItem, articleDetail *models.ArticleDetail, source int) (err error) {
  1466. defer func() {
  1467. if err != nil {
  1468. go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
  1469. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1470. }
  1471. }()
  1472. countUser, err := models.GetUserRemind(user.UserId)
  1473. if err != nil {
  1474. return err
  1475. }
  1476. if countUser == 0 {
  1477. return err
  1478. }
  1479. var sourceMsg string
  1480. if source == 1 {
  1481. sourceMsg = "阅读报告"
  1482. } else {
  1483. sourceMsg = "收藏报告"
  1484. }
  1485. //获取销售手机号
  1486. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1487. if err != nil && err.Error() != utils.ErrNoRow() {
  1488. return err
  1489. }
  1490. if sellerItemQy != nil {
  1491. openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  1492. if err != nil {
  1493. fmt.Println(err)
  1494. return err
  1495. }
  1496. var keyword1 string
  1497. var keyword2 string
  1498. keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
  1499. keyword2 = articleDetail.Title
  1500. SendWxMsgWithArticleUserRemind(keyword1, keyword2, openIdList, articleDetail.ArticleId)
  1501. }
  1502. return
  1503. }
  1504. // 用户活动操作行为,模板消息推送
  1505. func ActivityUserRemind(user *models.WxUserItem, activityDetail *models.ActivityDetail, source int) (err error) {
  1506. defer func() {
  1507. if err != nil {
  1508. go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
  1509. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1510. }
  1511. }()
  1512. countUser, err := models.GetUserRemind(user.UserId)
  1513. if err != nil {
  1514. return err
  1515. }
  1516. if countUser == 0 {
  1517. return err
  1518. }
  1519. var sourceMsg string
  1520. if source == 1 {
  1521. sourceMsg = "预约外呼"
  1522. } else if source == 2 {
  1523. sourceMsg = "设置会议提醒"
  1524. } else if source == 3 {
  1525. sourceMsg = "预约纪要"
  1526. } else if source == 4 {
  1527. sourceMsg = "活动报名"
  1528. }
  1529. //获取销售手机号
  1530. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1531. if err != nil && err.Error() != utils.ErrNoRow() {
  1532. return err
  1533. }
  1534. if sellerItemQy != nil {
  1535. openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  1536. if err != nil {
  1537. fmt.Println(err)
  1538. return err
  1539. }
  1540. var keyword1 string
  1541. var keyword2 string
  1542. keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
  1543. keyword2 = activityDetail.ActivityName
  1544. SendWxMsgWithActivityUserRemind(keyword1, keyword2, openIdList, activityDetail.ActivityId)
  1545. }
  1546. return
  1547. }
  1548. // 用户专项调研操作行为,模板消息推送
  1549. func SpecialActivityUserRemind(user *models.WxUserItem, activityDetail *models.CygxActivitySpecialDetail, source int) (err error) {
  1550. defer func() {
  1551. if err != nil {
  1552. go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
  1553. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1554. }
  1555. }()
  1556. countUser, err := models.GetUserRemind(user.UserId)
  1557. if err != nil {
  1558. return err
  1559. }
  1560. if countUser == 0 {
  1561. return err
  1562. }
  1563. var sourceMsg string
  1564. if source == 1 {
  1565. sourceMsg = "预报名调研"
  1566. }
  1567. //获取销售手机号
  1568. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1569. if err != nil && err.Error() != utils.ErrNoRow() {
  1570. return err
  1571. }
  1572. if sellerItemQy != nil {
  1573. openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  1574. if err != nil {
  1575. fmt.Println(err)
  1576. return err
  1577. }
  1578. var keyword1 string
  1579. var keyword2 string
  1580. keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
  1581. keyword2 = activityDetail.ResearchTheme
  1582. SendWxMsgWithSpecialActivityUserRemind(keyword1, keyword2, openIdList, activityDetail.ActivityId)
  1583. }
  1584. return
  1585. }
  1586. //func init() {
  1587. // DoActivityOnenIdWxTemplateMsg()
  1588. //}
  1589. // 周日下午四点半推送全部活动
  1590. func DoActivityOnenIdWxTemplateMsg(cont context.Context) (err error) {
  1591. var msg string
  1592. defer func() {
  1593. if err != nil {
  1594. go utils.SendAlarmMsg("周日下午四点半推送全部活动失败,DoActivityOnenIdWxTemplateMsg ErrMsg:"+err.Error(), 2)
  1595. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "DoActivityOnenIdWxTemplateMsg ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1596. fmt.Println(err)
  1597. }
  1598. if msg != "" {
  1599. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  1600. }
  1601. }()
  1602. var condition string
  1603. var pars []interface{}
  1604. openidPowerList, err := models.GetCygxUserRecordPower(condition, pars)
  1605. if err != nil {
  1606. return err
  1607. }
  1608. first := "近期所有行业活动预告,欢迎参与"
  1609. keyword1 := "下周活动预告"
  1610. keyword2 := "已发布"
  1611. keyword3 := ""
  1612. keyword4 := "点击查看下周活动列表"
  1613. SendActivityOnenIdWxTemplateMsg(first, keyword1, keyword2, keyword3, keyword4, openidPowerList)
  1614. return
  1615. }
  1616. func ActivityButtonShow(item *models.ActivityDetail) (articleDetail *models.ActivityDetail) {
  1617. articleDetail = item
  1618. //IsShowAppointment bool `description:"是否展示预约纪要"`
  1619. //IsShowOutboundCall bool `description:"是否展示预约外呼"`
  1620. //IsShowMeetingReminder bool `description:"是否展示会议提醒"`
  1621. //IsShowHelpSsk bool `description:"是否展示帮我带问"`
  1622. //IsShowSignup bool `description:"是否展示我要报名"`
  1623. //如果后台在添加活的时候,关联的报告类型不隐藏预约纪要按钮,而且满足以下展示预约纪要按钮类型就展示
  1624. //if articleDetail.IsHideAppointment == 0 {
  1625. // articleDetail.IsShowAppointment = IsShowAppointmentByactivityInfo(articleDetail, articleDetail.ChartPermissionName)
  1626. //}
  1627. articleDetail.IsShowAppointment = false
  1628. //易董的操作按钮都隐藏
  1629. if articleDetail.YidongActivityId != "" {
  1630. articleDetail.IsShowSignup = false
  1631. articleDetail.IsShowDetails = true
  1632. return
  1633. }
  1634. articleDetail.Expert, _ = GetReportContentTextSub(item.Expert)
  1635. //专家电话会 1
  1636. if articleDetail.ActivityTypeId == 1 && articleDetail.IsLimitPeople == 0 && (articleDetail.ActiveState == "1" || articleDetail.ActiveState == "2") {
  1637. articleDetail.IsShowHelpSsk = true
  1638. }
  1639. //新的是否展示规则
  1640. if articleDetail.IsCanAppointmentMinutes == 1 {
  1641. articleDetail.IsShowAppointment = true
  1642. } else {
  1643. articleDetail.IsShowAppointment = false
  1644. }
  1645. if articleDetail.ActiveState == "1" {
  1646. //专家电话会 1
  1647. //专家电话会限制人数的展示我要报名,不限制的展示预约外外呼
  1648. if articleDetail.ActivityTypeId == 1 {
  1649. //articleDetail.IsShowOutboundCall = true
  1650. if articleDetail.LimitPeopleNum == 0 {
  1651. articleDetail.IsShowOutboundCall = true
  1652. //articleDetail.IsShowHelpSsk = true
  1653. } else {
  1654. articleDetail.IsShowSignup = true
  1655. }
  1656. //if articleDetail.SignupType == 0 {
  1657. // if articleDetail.LimitPeopleNum == 0 {
  1658. // articleDetail.IsShowOutboundCall = true
  1659. // //articleDetail.IsShowHelpSsk = true
  1660. // } else {
  1661. // articleDetail.IsShowSignup = true
  1662. // }
  1663. //} else {
  1664. // if articleDetail.SignupType == 2 {
  1665. // articleDetail.IsShowSignup = true
  1666. // } else {
  1667. // articleDetail.IsShowOutboundCall = true
  1668. // }
  1669. //}
  1670. articleDetail.IsShowMeetingReminder = true
  1671. articleDetail.IsShowHelpSsk = true
  1672. }
  1673. //分析师电话会 2
  1674. if articleDetail.ActivityTypeId == 2 {
  1675. //if articleDetail.SignupType == 0 {
  1676. // if articleDetail.LimitPeopleNum == 0 {
  1677. // articleDetail.IsShowOutboundCall = true
  1678. // //articleDetail.IsShowHelpSsk = true
  1679. // } else {
  1680. // articleDetail.IsShowSignup = true
  1681. // }
  1682. //} else {
  1683. // if articleDetail.SignupType == 2 {
  1684. // articleDetail.IsShowSignup = true
  1685. // } else {
  1686. // articleDetail.IsShowOutboundCall = true
  1687. // }
  1688. //}
  1689. if articleDetail.LimitPeopleNum == 0 {
  1690. articleDetail.IsShowOutboundCall = true
  1691. //articleDetail.IsShowHelpSsk = true
  1692. } else {
  1693. articleDetail.IsShowSignup = true
  1694. }
  1695. articleDetail.IsShowMeetingReminder = true
  1696. }
  1697. //公司调研电话会 3
  1698. if articleDetail.ActivityTypeId == 3 {
  1699. if articleDetail.LimitPeopleNum == 0 {
  1700. articleDetail.IsShowMeetingReminder = true
  1701. articleDetail.IsShowOutboundCall = true
  1702. } else {
  1703. articleDetail.IsShowSignup = true
  1704. }
  1705. }
  1706. //公司线下调研 4
  1707. if articleDetail.ActivityTypeId == 4 {
  1708. articleDetail.IsShowSignup = true
  1709. }
  1710. //专家线下沙龙 5
  1711. if articleDetail.ActivityTypeId == 5 {
  1712. articleDetail.IsShowSignup = true
  1713. }
  1714. //分析师线下沙龙 6
  1715. if articleDetail.ActivityTypeId == 6 {
  1716. articleDetail.IsShowSignup = true
  1717. }
  1718. //分析师电话会(C类) 7
  1719. if articleDetail.ActivityTypeId == 7 {
  1720. articleDetail.IsShowSignup = true
  1721. articleDetail.IsShowMeetingReminder = true
  1722. articleDetail.ActivityTypeName = "分析师电话会"
  1723. }
  1724. }
  1725. if articleDetail.SourceType != 2 {
  1726. articleDetail.SourceType = 1
  1727. }
  1728. activityTimeText := articleDetail.ActivityTimeText
  1729. activityTimeText = strings.Replace(activityTimeText, "(", "(", -1)
  1730. activityTimeText = strings.Replace(activityTimeText, ")", ")", -1)
  1731. articleDetail.ActivityTimeText = activityTimeText
  1732. return
  1733. }
  1734. // GetActivityNewLabelMap 获取活动【新】标签Map
  1735. func GetActivityNewLabelMap(activityIds []int) (labelMap map[int]bool, industryNewMap map[int]bool, err error) {
  1736. labelMap = make(map[int]bool, 0)
  1737. industryNewMap = make(map[int]bool, 0)
  1738. if len(activityIds) == 0 {
  1739. return
  1740. }
  1741. // 获取活动关联的产业
  1742. var groupCond string
  1743. var groupPars []interface{}
  1744. groupCond += ` AND a.activity_id IN (` + utils.GetOrmInReplace(len(activityIds)) + `) AND b.source = 1 `
  1745. groupPars = append(groupPars, activityIds)
  1746. groups, e := models.GetActivityIndustryRelationList(groupCond, groupPars)
  1747. if e != nil {
  1748. err = errors.New("获取活动产业关联列表失败, Err: " + e.Error())
  1749. return
  1750. }
  1751. activityIndustryMap := make(map[int][]int, 0)
  1752. industryIds := make([]int, 0)
  1753. for i := range groups {
  1754. industryIds = append(industryIds, groups[i].IndustrialManagementId)
  1755. activityIndustryMap[groups[i].ActivityId] = append(activityIndustryMap[groups[i].ActivityId], groups[i].IndustrialManagementId)
  1756. }
  1757. // 获取新产业Map
  1758. industryLabelMap, e := GetIndustryNewLabelMap(industryIds)
  1759. if e != nil {
  1760. err = errors.New("获取产业新标签Map失败, Err: " + e.Error())
  1761. return
  1762. }
  1763. // 判断活动是否为新
  1764. for k := range industryLabelMap {
  1765. for k2, v2 := range activityIndustryMap {
  1766. if labelMap[k2] {
  1767. continue
  1768. }
  1769. // 活动的产业ID中存在一个新产业即为新活动
  1770. if utils.InArrayByInt(v2, k) {
  1771. labelMap[k2] = true
  1772. }
  1773. }
  1774. }
  1775. //for _, v := range activityIds {
  1776. // labelMap[v] = true
  1777. //}
  1778. //fmt.Println(labelMap)
  1779. ////产业关联的弘则报告发布日期在三个月以内的活动、产业显示 NEW标签
  1780. articNewLabel, e := GetArticNewLabelWhithActivity3Month()
  1781. if e != nil {
  1782. err = errors.New("获取产业新标签Map失败, Err: " + e.Error())
  1783. return
  1784. }
  1785. for k := range articNewLabel {
  1786. labelMap[k] = false
  1787. }
  1788. return
  1789. }
  1790. // GetActivityVoiceResp 处理活动音频回放
  1791. func GetActivityVoiceResp(mapActivityId []int) (mapItem map[int]*models.CygxActivityVoiceReq, err error) {
  1792. activityVoiceList, err := models.GetCygxActivityVoiceReqList(mapActivityId)
  1793. if err != nil && err.Error() != utils.ErrNoRow() {
  1794. return
  1795. }
  1796. mapActivityVoice := make(map[int]*models.CygxActivityVoiceReq)
  1797. if len(activityVoiceList) > 0 {
  1798. for _, v := range activityVoiceList {
  1799. mapActivityVoice[v.ActivityId] = v
  1800. }
  1801. }
  1802. mapItem = mapActivityVoice
  1803. return
  1804. }
  1805. // AddActivitykeyWordSearch 添加活动搜索记录
  1806. func AddActivitykeyWordSearch(keyWordSearch string, user *models.WxUserItem) {
  1807. if keyWordSearch != "" {
  1808. keyWordItem := new(models.CygxUserSearchKeyWord)
  1809. keyWordItem.UserId = user.UserId
  1810. keyWordItem.KeyWord = keyWordSearch
  1811. keyWordItem.PageType = "ActivitSearch"
  1812. keyWordItem.CreateTime = time.Now()
  1813. go models.AddUserSearchKeyWord(keyWordItem)
  1814. }
  1815. }
  1816. // GetActivityVideoResp 处理活动视频频回放
  1817. func GetActivityVideoResp(mapActivityId []int) (mapItem map[int]*models.CygxActivityVideoListResp, err error) {
  1818. var condition string
  1819. var ativityVIdstr string
  1820. for _, v := range mapActivityId {
  1821. ativityVIdstr += strconv.Itoa(v) + ","
  1822. }
  1823. if ativityVIdstr == "" {
  1824. return
  1825. }
  1826. ativityVIdstr = strings.TrimRight(ativityVIdstr, ",")
  1827. condition += ` AND art.activity_id IN (` + ativityVIdstr + `) `
  1828. var pars []interface{}
  1829. //endTime := time.Now().AddDate(0, 0, -30).Format("2006-01-02 15:04:05")
  1830. //condition += ` AND art.activity_time > ? `
  1831. //pars = append(pars, endTime)
  1832. videoList, e := models.GetActivityVideoListAll(condition, pars, 0, 1000)
  1833. if e != nil && e.Error() != utils.ErrNoRow() {
  1834. err = e
  1835. return
  1836. }
  1837. mapActivityVideo := make(map[int]*models.CygxActivityVideoListResp)
  1838. if len(videoList) > 0 {
  1839. for _, v := range videoList {
  1840. mapActivityVideo[v.ActivityId] = v
  1841. }
  1842. }
  1843. mapItem = mapActivityVideo
  1844. return
  1845. }
  1846. // 用户音视频回放操作操作行为,模板消息推送
  1847. func ActivityVideoUserRmind(user *models.WxUserItem, activityId, fileType int) (err error) {
  1848. defer func() {
  1849. if err != nil {
  1850. go utils.SendAlarmMsg("用户音视频回放操作操作行为,模板消息推送失败"+err.Error(), 2)
  1851. }
  1852. }()
  1853. countUser, err := models.GetUserRemind(user.UserId)
  1854. if err != nil {
  1855. return err
  1856. }
  1857. if countUser == 0 {
  1858. return err
  1859. }
  1860. var first string
  1861. var keyword1 string
  1862. var keyword2 string
  1863. var keyword3 string
  1864. var keyword4 string
  1865. var remark string
  1866. //获取销售手机号
  1867. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1868. if err != nil && err.Error() != utils.ErrNoRow() {
  1869. return err
  1870. }
  1871. if sellerItemQy != nil {
  1872. openIdList, e := models.GetWxOpenIdByMobileList(sellerItemQy.Mobile)
  1873. if e != nil {
  1874. err = errors.New("GetSellerByAdminId, Err: " + e.Error())
  1875. return
  1876. }
  1877. //TripStatus int `description:"行程进行状态 1:预报名,2:确定行程"`
  1878. if fileType == 1 {
  1879. activityInfo, e := models.GetCygxActivityVideoByActivityId(activityId)
  1880. if e != nil {
  1881. err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
  1882. return
  1883. }
  1884. if activityInfo == nil {
  1885. return
  1886. }
  1887. keyword1 = activityInfo.VideoName
  1888. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:播放视频")
  1889. } else {
  1890. activityInfo, e := models.GetCygxActivityVoiceByActivityId(activityId)
  1891. if e != nil {
  1892. err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
  1893. return
  1894. }
  1895. if activityInfo == nil {
  1896. return
  1897. }
  1898. keyword1 = activityInfo.VoiceName
  1899. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:播放音频")
  1900. }
  1901. keyword2 = "__"
  1902. remark = "点击查看活动详情"
  1903. openIdArr := make([]string, 0)
  1904. for _, v := range openIdList {
  1905. openIdArr = append(openIdArr, v.OpenId)
  1906. }
  1907. redirectUrl := utils.WX_MSG_PATH_ACTIVITY_SPECIAL_DETAIL + strconv.Itoa(activityId)
  1908. sendInfo := new(SendWxTemplate)
  1909. sendInfo.First = first
  1910. sendInfo.Keyword1 = keyword1
  1911. sendInfo.Keyword2 = keyword2
  1912. sendInfo.Keyword3 = keyword3
  1913. sendInfo.Keyword4 = keyword4
  1914. sendInfo.Remark = remark
  1915. sendInfo.TemplateId = utils.WxMsgTemplateIdArticleUserRemind
  1916. sendInfo.RedirectUrl = redirectUrl
  1917. sendInfo.RedirectTarget = 3
  1918. sendInfo.Resource = strconv.Itoa(activityId)
  1919. sendInfo.SendType = utils.TEMPLATE_MSG_CYGX_ARTICLE_ADD
  1920. sendInfo.OpenIdArr = openIdArr
  1921. err = PublicSendTemplateMsg(sendInfo)
  1922. if err != nil {
  1923. return
  1924. }
  1925. }
  1926. return
  1927. }
  1928. // 解析活动填写的报告链接
  1929. func GetActivityReportLinkToArticleList(item *models.ActivityDetail) (items []*models.ActivityArticleResp, err error) {
  1930. reportLink := item.ReportLink
  1931. //处理活动的
  1932. var articleIds []int
  1933. var articleList []string
  1934. if strings.Contains(reportLink, ";") {
  1935. articleList = strings.Split(reportLink, ";")
  1936. } else {
  1937. articleList = strings.Split(reportLink, ";")
  1938. }
  1939. for _, v := range articleList {
  1940. linkList := strings.Split(v, "/")
  1941. if linkList[len(linkList)-1] != "" {
  1942. linkArticleId, _ := strconv.Atoi(linkList[len(linkList)-1])
  1943. articleIds = append(articleIds, linkArticleId)
  1944. }
  1945. }
  1946. lenarticleIds := len(articleIds)
  1947. if lenarticleIds == 0 {
  1948. return
  1949. }
  1950. var condition string
  1951. var pars []interface{}
  1952. pars = make([]interface{}, 0)
  1953. condition = ` AND a.article_id IN (` + utils.GetOrmInReplace(lenarticleIds) + `)`
  1954. pars = append(pars, articleIds)
  1955. listArticle, e := models.GetHomeList(condition, pars, 0, len(articleIds))
  1956. if e != nil {
  1957. err = errors.New("GetResourceDataList, Err: " + e.Error())
  1958. return
  1959. }
  1960. if len(listArticle) > 0 {
  1961. for _, v := range listArticle {
  1962. artItem := new(models.ActivityArticleResp)
  1963. artItem.ArticleId = v.ArticleId
  1964. artItem.Title = v.Title
  1965. items = append(items, artItem)
  1966. }
  1967. }
  1968. return
  1969. }
  1970. // GetActivityCityResp 获取活动关联城市,当同一个活动标签对应多个城市的时候,展示最近举办的活动
  1971. func GetActivityCityResp() (mapItem map[string]string, err error) {
  1972. activityList, err := models.GetActivityLabelListCity()
  1973. if err != nil && err.Error() != utils.ErrNoRow() {
  1974. return
  1975. }
  1976. mapActivityCity := make(map[string]string)
  1977. if len(activityList) > 0 {
  1978. for _, v := range activityList {
  1979. if v.ActivityTypeId == utils.C_CLASS_ACTIVITY_TYPE_ID {
  1980. v.ActivityTypeId = utils.ANALYST_TELL_ACTIVITY_TYPE_ID
  1981. }
  1982. //如果城市民称长度大于2,那么就不显示
  1983. if utf8.RuneCountInString(v.City) != 2 || mapActivityCity[fmt.Sprint(v.Label, "{|}", v.ActivityTypeId)] != "" {
  1984. continue
  1985. }
  1986. mapActivityCity[fmt.Sprint(v.Label, "{|}", v.ActivityTypeId)] = v.City
  1987. }
  1988. }
  1989. mapItem = mapActivityCity
  1990. return
  1991. }