activity.go 65 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904
  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.GetCompanyPermissionByUser(companyId)
  321. if errs != nil {
  322. err = errs
  323. return
  324. }
  325. permissionZhengShiStr, errs = models.GetCompanyPermissionByUserZhengShi(companyId)
  326. if errs != nil {
  327. err = errs
  328. return
  329. }
  330. //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户
  331. //大套餐客户定义:医药、消费、科技、智造、策略。5个行业中任意4个及以上是正式权限的,属于大套餐客户(医药、消费、科技、智造需要主客观都开)
  332. if companyDetail.Status == "永续" {
  333. userType = 1
  334. } else if companyDetail.Status == "试用" {
  335. userType = 5
  336. } else if companyDetail.Status == "正式" {
  337. if permissionStr == "专家" {
  338. userType = 4
  339. } else if strings.Count(permissionZhengShiStr, "医药") == 2 && strings.Count(permissionZhengShiStr, "消费") == 2 && strings.Count(permissionZhengShiStr, "科技") == 2 && strings.Count(permissionZhengShiStr, "智造") == 2 {
  340. userType = 2
  341. } else {
  342. userType = 3
  343. }
  344. if userType == 3 {
  345. if !strings.Contains(permissionStr, "医药") && !strings.Contains(permissionStr, "消费") && !strings.Contains(permissionStr, "科技") && !strings.Contains(permissionStr, "智造") {
  346. userType = 4
  347. }
  348. }
  349. } else if companyDetail.Status == "冻结" {
  350. userType = 6
  351. } else if companyDetail.Status == "流失" {
  352. userType = 7
  353. }
  354. //大套餐客户定义:医药、消费、科技、智造、策略。5个行业中任意4个及以上是正式权限的,属于大套餐客户(医药、消费、科技、智造需要主客观都开)
  355. if userType == 3 {
  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 permissionZhegnshiNum >= 4 {
  373. userType = 2
  374. }
  375. }
  376. }
  377. }
  378. permissionStrnew = permissionStr
  379. return
  380. }
  381. // 校验被分享的用户是否有查看详情的权限
  382. func GetShareNoPowe(activityInfo *models.ActivityDetail, permissionStr string, userType int, user *models.WxUserItem) (noPower bool, err error) {
  383. //如果是弘则的就不进行可见权限校验
  384. if user.CompanyId == utils.HZ_COMPANY_ID {
  385. return
  386. }
  387. //var noPower bool
  388. if (userType == 1 || userType == 4 || userType == 5) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(userType)) {
  389. noPower = true
  390. }
  391. //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户
  392. 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)) {
  393. noPower = true
  394. }
  395. if userType == 2 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(2)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
  396. noPower = true
  397. }
  398. if userType == 3 && strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(4)) {
  399. noPower = true
  400. }
  401. if userType == 3 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
  402. noPower = true
  403. }
  404. if !noPower {
  405. noPower, err = CheckUserPowerByActivityChoose(user, activityInfo)
  406. }
  407. return
  408. }
  409. // 处理活动本组们是否决策人权限
  410. func CheckUserPowerByActivityChoose(user *models.WxUserItem, activityInfo *models.ActivityDetail) (noPower bool, err error) {
  411. //处理 见范围 1,仅本组可见 、2,全部客户可见
  412. if activityInfo.VisibleRange == 1 {
  413. adminIds, errAdmin := models.GetSelleridWhichGroup(user.CompanyId, 2)
  414. if errAdmin != nil {
  415. err = errAdmin
  416. return
  417. }
  418. sliceAdminIds := strings.Split(adminIds, ",")
  419. var haveAdminId bool
  420. for _, v := range sliceAdminIds {
  421. if v == strconv.Itoa(activityInfo.AdminId) {
  422. haveAdminId = true
  423. }
  424. }
  425. if !haveAdminId {
  426. noPower = true
  427. }
  428. }
  429. //处理 是否仅决策人可见 0,否 、1,是
  430. if activityInfo.IsMakerShow == 1 {
  431. if user.IsMaker == 0 {
  432. noPower = true
  433. }
  434. }
  435. fmt.Println(noPower)
  436. return
  437. }
  438. // 校验用户报名的权限
  439. func GetHavePower(activityInfo *models.ActivityDetail, permissionStr, companyDetailStatus string, userType int) (havePower bool, err error) {
  440. // 查研观向7.4-宏观活动不作权限限制
  441. if activityInfo.ChartPermissionId == 1 {
  442. havePower = true
  443. return
  444. }
  445. if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3) && strings.Contains(permissionStr, "专家") && activityInfo.LimitPeopleNum == 0 {
  446. havePower = true
  447. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "正式" && strings.Contains(activityInfo.CustomerTypeIds, "4") {
  448. havePower = true
  449. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "试用" && strings.Contains(activityInfo.CustomerTypeIds, "5") {
  450. havePower = true
  451. //} else if strings.Contains(permissionStr, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(userType)) {
  452. // havePower = true
  453. //} else if strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  454. // havePower = true
  455. } else if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3 || activityInfo.ActivityTypeId == 4 || activityInfo.ActivityTypeId == 5) && strings.Contains(permissionStr, "专家") {
  456. havePower = true
  457. }
  458. if activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 6 || activityInfo.ActivityTypeId == 7 {
  459. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(主观)") {
  460. havePower = true
  461. }
  462. } else {
  463. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(客观)") {
  464. havePower = true
  465. }
  466. }
  467. if (strings.Contains(activityInfo.ChartPermissionName, "研选") || activityInfo.ChartPermissionName == "策略") && strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  468. havePower = true
  469. }
  470. //如果是易董的活动且属于研选类型,只要开通任何权限就可以查看详情
  471. if activityInfo.YidongActivityId != "" && permissionStr != "" && strings.Contains(activityInfo.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) {
  472. havePower = true
  473. }
  474. return
  475. }
  476. // 获取活动列表查询权限的SQL
  477. // @Param ChartPermissionIds query string false "行业id 多个用 , 隔开"
  478. // @Param ActivityTypeIds query string false "活动类型id 多个用 , 隔开"
  479. // @Param ActiveState query string false "活动进行状态 未开始:1、进行中2、已结束3"
  480. // @Param WhichDay query string false "哪一天 今天:1、明天:2,多个用 , 隔开"
  481. // @Param IsPower query int false "是否选择有权限行业 ,1是 0 否 默认0"
  482. // @Param Label query string false "搜索主题 多个用 , 隔开"
  483. // @Param PlayBack query int false "是否仅展示回放 1:是、0:否 默认0"
  484. // @Param KeyWord query string false "搜索关键词 多个用 , 隔开"
  485. // @Param ikType query int false "联想词类型 , 1不做联想,2,做除初始词的联想,3所有联想"
  486. func GetActivityonditionList(user *models.WxUserItem, activityTypeId, chartPermissionIds, whichDay, activeState, label string, isPower, source int, keyWord string, playBack, ikType int) (conditionActivity string, err error) {
  487. keyWordNoIk := keyWord
  488. adminIds, err := models.GetSelleridWhichGroup(user.CompanyId, 2)
  489. if err != nil {
  490. return
  491. }
  492. userType, permissionStr, err := GetUserType(user.CompanyId)
  493. if err != nil {
  494. return
  495. }
  496. //判断客户规模是否属于可见范围的活动
  497. companyProduct, err := models.GetCompanyProductDetail(user.CompanyId, 2)
  498. if err != nil && err.Error() != utils.ErrNoRow() {
  499. return
  500. }
  501. isMaker := user.IsMaker
  502. slicePer := strings.Split(permissionStr, ",")
  503. var permissionSqlStr string
  504. var permissionNameStr string
  505. for _, v := range slicePer {
  506. if userType == 1 {
  507. //研选权限处理
  508. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  509. permissionNameStr += "'" + v + "',"
  510. }
  511. } else {
  512. permissionNameStr += "'" + v + "',"
  513. }
  514. }
  515. permissionNameStr = strings.Replace(permissionNameStr, "(主观)", "", -1)
  516. permissionNameStr = strings.Replace(permissionNameStr, "(客观)", "", -1)
  517. permissionNameStr = strings.TrimRight(permissionNameStr, ",")
  518. // 查研观向7.4-始终查询宏观的权限(无论是否有权限)
  519. if permissionNameStr == `` {
  520. permissionNameStr = `'宏观'`
  521. } else {
  522. permissionNameStr += `, '宏观'`
  523. }
  524. var condition string
  525. var conditionAdmin string
  526. var conditionHz string // 弘则权限处理
  527. var sqlExport string // 专家权限处理
  528. permissionSqlStr = ` AND art.chart_permission_name IN (` + permissionNameStr + `)`
  529. sqlExport = ` AND (art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' `
  530. if userType == 2 {
  531. sqlExport += ` OR art.customer_type_ids LIKE '%3%' `
  532. }
  533. if (userType == 2 || userType == 3) && strings.Contains(permissionStr, "专家") {
  534. sqlExport += ` OR art.customer_type_ids LIKE '%4%' `
  535. }
  536. sqlExport += `) `
  537. // 如果是C类电话会就不展示内容,且合并到分析师电话会
  538. if activityTypeId != "" {
  539. if activityTypeId == strconv.Itoa(utils.ANALYST_TELL_ACTIVITY_TYPE_ID) {
  540. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id IN (` + activityTypeId + "," + strconv.Itoa(utils.C_CLASS_ACTIVITY_TYPE_ID) + `)`
  541. } else {
  542. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id IN (` + activityTypeId + `)`
  543. }
  544. }
  545. //主题
  546. if label != "" {
  547. condition = ` AND art.label LIKE '%` + label + `%' `
  548. }
  549. if isPower == 1 {
  550. condition += permissionSqlStr
  551. }
  552. //行业名称
  553. if len(chartPermissionIds) > 0 {
  554. condition += ` AND art.chart_permission_id IN (` + chartPermissionIds + `)`
  555. }
  556. //如果是PC的,则不看易董的
  557. if source == 1 {
  558. condition += ` AND art.yidong_activity_id = '' `
  559. }
  560. var conditionOr string
  561. if whichDay != "" {
  562. var startDate string
  563. var endDate string
  564. if whichDay == "1" {
  565. startDate = time.Now().Format(utils.FormatDate)
  566. endDate = startDate
  567. } else if whichDay == "2" {
  568. startDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  569. endDate = startDate
  570. } else if whichDay == "3" {
  571. startDate = utils.GetNowWeekMonday().Format(utils.FormatDate)
  572. endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
  573. } else if whichDay == "4" {
  574. startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
  575. endDate = utils.GetLastWeekSunday().Format(utils.FormatDate)
  576. } else if whichDay == "5" {
  577. startDate = utils.GetNowMonthFirstDay().Format(utils.FormatDate)
  578. endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
  579. } else if whichDay == "6" {
  580. startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
  581. endDate = utils.GetLastMonthLastDay().Format(utils.FormatDate)
  582. } else if whichDay == "1,2" {
  583. startDate = time.Now().Format(utils.FormatDate)
  584. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  585. } else if whichDay == "3,4" {
  586. startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
  587. endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
  588. } else if whichDay == "5,6" {
  589. startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
  590. endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
  591. } else {
  592. startDate = time.Now().Format(utils.FormatDate)
  593. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  594. }
  595. condition += ` AND art.activity_time >= ` + "'" + startDate + " 00:00:00'"
  596. condition += ` AND art.activity_time <= ` + "'" + endDate + " 23:59:59'"
  597. }
  598. fmt.Println(keyWord)
  599. fmt.Println(keyWordNoIk)
  600. //有搜索条件传过来时,不判进行状态条件
  601. if keyWord != "" {
  602. if ikType == 2 || ikType == 3 {
  603. keyWordArr, e := GetIndustryMapNameSliceV3(keyWord)
  604. if e != nil {
  605. err = errors.New("获取分词失败,GetIndustryMapNameSliceV3, Err: " + keyWord + e.Error())
  606. return
  607. }
  608. keyWordArr = RemoveDuplicatesAndEmpty(keyWordArr)
  609. //var keywords string
  610. if len(keyWordArr) > 1 {
  611. if ikType == 2 {
  612. keyWord = KeyWordArrSqlRegexp(keyWordArr)
  613. condition += ` AND (art.label NOT LIKE '%` + keyWordNoIk + `%' AND art.activity_name NOT LIKE '%` + keyWordNoIk + `%' ) `
  614. } else if ikType == 3 {
  615. keyWord = KeyWordArrSqlRegexpAll(keyWordArr)
  616. }
  617. }
  618. }
  619. condition += ` AND (art.label REGEXP '` + keyWord + `' OR art.activity_name REGEXP '` + keyWord + `' ) `
  620. } else {
  621. if activeState != "" {
  622. // 默认查看未开始跟进行中
  623. if activeState == "1" {
  624. condition += ` AND art.active_state IN (1,2)`
  625. } else {
  626. condition += ` AND art.active_state IN (` + activeState + `)`
  627. }
  628. } else {
  629. condition += ` AND art.active_state IN (1,2)`
  630. }
  631. }
  632. if playBack == 1 {
  633. var pars []interface{}
  634. ativityVIdArry := make([]string, 0)
  635. voiceList, e := models.GetActivityVoiceListAll("", pars, 0, 1000)
  636. if e != nil && e.Error() != utils.ErrNoRow() {
  637. err = e
  638. return
  639. }
  640. for _, v := range voiceList {
  641. ativityVIdArry = append(ativityVIdArry, strconv.Itoa(v.ActivityId))
  642. }
  643. videoList, e := models.GetActivityVideoListAll("", pars, 0, 1000)
  644. if e != nil && e.Error() != utils.ErrNoRow() {
  645. err = e
  646. return
  647. }
  648. for _, v := range videoList {
  649. ativityVIdArry = append(ativityVIdArry, strconv.Itoa(v.ActivityId))
  650. }
  651. //活动音频,设置有效时间为30天,失效后该活动就不再支持音频回放。有效期起始时间为活动的开始时间
  652. //endTime := time.Now().AddDate(0, 0, -30).Format("2006-01-02 15:04:05")
  653. //condition += ` AND art.activity_time > '` + endTime + `' `
  654. if len(ativityVIdArry) > 0 {
  655. ativityVIdstr := strings.Join(ativityVIdArry, ",")
  656. condition += ` AND art.activity_id IN (` + ativityVIdstr + `) `
  657. }
  658. }
  659. //查询全部可见的数据(是否全部客户可见)
  660. //condition += ` AND art.visible_range != 1 AND art.publish_status = 1 `
  661. condition += ` AND art.publish_status = 1 `
  662. conditionHz = condition
  663. //活动仅决策人可见
  664. if isMaker == 0 {
  665. condition += ` AND art.is_maker_show = 0 `
  666. }
  667. conditionAdmin = condition + ` AND art.visible_range = 1 `
  668. condition += ` AND art.visible_range != 1 `
  669. if (userType == 2 || userType == 3 || userType == 4) && strings.Contains(permissionStr, "专家") {
  670. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%4%' ` + condition + `) `
  671. }
  672. if (userType == 5) && strings.Contains(permissionStr, "专家") {
  673. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%5%' ` + condition + `) `
  674. }
  675. if userType == 1 {
  676. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + permissionSqlStr + `) `
  677. } else {
  678. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
  679. }
  680. if userType == 6 || userType == 7 {
  681. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' ` + condition + `) `
  682. }
  683. if companyProduct != nil {
  684. if companyProduct.Scale != "" {
  685. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%' ` + condition + `) `
  686. }
  687. }
  688. if adminIds != "" {
  689. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' ` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
  690. if companyProduct != nil {
  691. if companyProduct.Scale != "" {
  692. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%'` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
  693. }
  694. }
  695. }
  696. //弘则研究下的客户不做权限,限制,C类电话会,仅本组销售、部门管理员、admin、权益研究员账号能看到
  697. if user.CompanyId == 16 {
  698. mapMobile, e := GetAdminMobileMap()
  699. if e != nil {
  700. err = e
  701. return
  702. }
  703. if _, ok := mapMobile[user.Mobile]; ok {
  704. conditionOr += ` OR ( art.publish_status = 1 ` + conditionHz + `) `
  705. }
  706. }
  707. conditionActivity = condition + permissionSqlStr + sqlExport + conditionOr
  708. return
  709. }
  710. // 研选系列专家电话会,会前1小时将问题列表发送给邮箱
  711. func SendEmailFileForAskMsgResearch(cont context.Context) (err error) {
  712. var msg string
  713. //var touser string
  714. defer func() {
  715. if err != nil {
  716. go utils.SendAlarmMsg("发送附件模版消息失败", 2)
  717. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  718. }
  719. if msg != "" {
  720. go utils.SendAlarmMsg(msg, 2)
  721. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  722. }
  723. }()
  724. endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
  725. condition := `AND a.activity_type_id = 1 AND a.chart_permission_id = 31 `
  726. total, err := models.GetCountActivityResearchToSendFile(condition, endDate)
  727. if total == 0 {
  728. fmt.Println("发送附件完成0")
  729. return nil
  730. }
  731. if err != nil {
  732. msg = "发送附件模版消息失败 Err:" + err.Error()
  733. return
  734. }
  735. listActivity, err := models.GetActivityResearchToSendFile(condition, endDate)
  736. if err != nil {
  737. msg = "发送附件模版消息失败 Err:" + err.Error()
  738. return
  739. }
  740. for _, v := range listActivity {
  741. activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
  742. if activityInfo == nil {
  743. msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
  744. return
  745. }
  746. list, errFile := models.GetActivityMsgExport(v.ActivityId)
  747. if errFile != nil {
  748. msg = "获取失败,Err:" + errFile.Error()
  749. return
  750. }
  751. for _, v2 := range list {
  752. user, err := models.GetWxUserItemByUserId(v2.UserId)
  753. if err != nil && err.Error() != utils.ErrNoRow() {
  754. return err
  755. }
  756. //获取销售信息
  757. sellerItem, err := models.GetSellerByCompanyIdCheckFicc(v2.CompanyId, 2)
  758. if err != nil && err.Error() != utils.ErrNoRow() {
  759. return err
  760. }
  761. //给研究员推送消息
  762. if sellerItem != nil {
  763. openIpItem, _ := models.GetUserRecordByMobile(4, utils.ActSendMsgMobile)
  764. if openIpItem != nil && openIpItem.OpenId != "" {
  765. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  766. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  767. }
  768. }
  769. //给所属销售推送消息
  770. if sellerItem != nil {
  771. openIpItem, _ := models.GetUserRecordByMobile(4, sellerItem.Mobile)
  772. if openIpItem != nil && openIpItem.OpenId != "" {
  773. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  774. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  775. }
  776. }
  777. }
  778. errFile = models.UPdateActivityMsgToSendFile(v.ActivityId)
  779. if errFile != nil {
  780. msg = "获取失败,Err:" + errFile.Error()
  781. return
  782. }
  783. }
  784. return
  785. }
  786. // 非研选系列专家电话会,根据主持人姓名,会前15分钟将问题列表发送给至该主持人对应邮箱
  787. func SendEmailFileForAskMsg(cont context.Context) (err error) {
  788. var msg string
  789. //var touser string
  790. defer func() {
  791. if err != nil {
  792. go utils.SendAlarmMsg("发送附件模版消息失败", 2)
  793. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  794. }
  795. if msg != "" {
  796. go utils.SendAlarmMsg(msg, 2)
  797. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  798. }
  799. }()
  800. endDate := time.Now().Add(+time.Minute * 15).Format(utils.FormatDateTime)
  801. condition := `AND a.activity_type_id = 1 AND a.chart_permission_id != 31 `
  802. total, err := models.GetCountActivityResearchToSendFile(condition, endDate)
  803. if total == 0 {
  804. fmt.Println("发送附件完成0")
  805. return nil
  806. }
  807. if err != nil {
  808. msg = "发送附件模版消息失败 Err:" + err.Error()
  809. return
  810. }
  811. listActivity, err := models.GetActivityResearchToSendFile(condition, endDate)
  812. if err != nil {
  813. msg = "发送附件模版消息失败 Err:" + err.Error()
  814. return
  815. }
  816. listEmail, errEmail := models.GetAskEmail()
  817. if errEmail != nil {
  818. msg = "获取失败,Err:" + errEmail.Error()
  819. return
  820. }
  821. for _, v := range listActivity {
  822. activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
  823. if activityInfo == nil {
  824. msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
  825. return
  826. }
  827. list, errFile := models.GetActivityMsgExport(v.ActivityId)
  828. if errFile != nil {
  829. msg = "获取失败,Err:" + errFile.Error()
  830. return
  831. }
  832. for _, v2 := range list {
  833. user, err := models.GetWxUserItemByUserId(v2.UserId)
  834. if err != nil && err.Error() != utils.ErrNoRow() {
  835. return err
  836. }
  837. var sendMobile string
  838. for _, vEmail := range listEmail {
  839. if strings.Index(activityInfo.Host, vEmail.Name) > 0 {
  840. sendMobile = vEmail.Mobile
  841. }
  842. }
  843. //获取销售信息
  844. sellerItem, err := models.GetSellerByCompanyIdCheckFicc(v2.CompanyId, 2)
  845. if err != nil && err.Error() != utils.ErrNoRow() {
  846. return err
  847. }
  848. //给研究员推送模板消息
  849. if sellerItem != nil {
  850. openIpItem, _ := models.GetUserRecordByMobile(4, sendMobile)
  851. if openIpItem != nil && openIpItem.OpenId != "" {
  852. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  853. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  854. }
  855. }
  856. //给销售推送模板消息
  857. if sellerItem != nil {
  858. openIpItem, _ := models.GetUserRecordByMobile(4, sellerItem.Mobile)
  859. if openIpItem != nil && openIpItem.OpenId != "" {
  860. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  861. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  862. }
  863. }
  864. }
  865. errFile = models.UPdateActivityMsgToSendFile(v.ActivityId)
  866. if errFile != nil {
  867. msg = "获取失败,Err:" + errFile.Error()
  868. return
  869. }
  870. }
  871. return
  872. }
  873. // 活动标签字符串处理
  874. func LabelStr(label string) (labelNew string) {
  875. slicebr := strings.Split(label, "-")
  876. if len(slicebr) < 2 {
  877. labelNew = label
  878. } else {
  879. labelNew = slicebr[1]
  880. }
  881. return labelNew
  882. }
  883. // 5.3版本活动标签字符串处理
  884. func LabelStrV5(label string, isShowSubjectName int, temporaryLabel string) (labelNew string) {
  885. slicebr := strings.Split(label, "-")
  886. if len(slicebr) > 1 {
  887. if isShowSubjectName == 1 {
  888. labelNew = slicebr[1]
  889. } else {
  890. labelNew = slicebr[0]
  891. }
  892. } else {
  893. labelNew = label
  894. }
  895. if temporaryLabel != "" {
  896. labelNew = temporaryLabel
  897. }
  898. return labelNew
  899. }
  900. func ActivityAttendanceDetail(cont context.Context) (err error) {
  901. defer func() {
  902. if err != nil {
  903. fmt.Println("ActivityAttendanceDetail Err:" + err.Error())
  904. go utils.SendAlarmMsg("同步进门财经数据失败", 2)
  905. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "ActivityAttendanceDetail ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  906. }
  907. }()
  908. configCode := "jin_meng_activity_id"
  909. detail, err := models.GetConfigByCode(configCode)
  910. if err != nil {
  911. return err
  912. }
  913. fmt.Println(detail.ConfigValue)
  914. mapActivityId := make(map[string]string)
  915. sliceValue := strings.Split(detail.ConfigValue, ",")
  916. for _, v := range sliceValue {
  917. mapActivityId[v] = v
  918. }
  919. var activityIds string
  920. var activityIdsLongTime string //可回放的会议,到会详情持续更新加入到不做14天限制的活动中
  921. fmt.Println("开始同步")
  922. dateTime := time.Now().AddDate(0, 0, -14).Format(utils.FormatDate)
  923. dateNow := time.Now().AddDate(0, 0, 0).Format(utils.FormatDate)
  924. startDate := dateTime + " 00:00:00"
  925. endDate := dateNow + " 23:59:59"
  926. //获取进门财经需要处理的活动
  927. listActivityRoadshow, err := models.GetRoadshowDataListByDateTime(startDate, endDate)
  928. if err != nil {
  929. fmt.Println("GetRoadshowDataListByDateTime Err:", err.Error())
  930. return err
  931. }
  932. for _, vAct := range listActivityRoadshow {
  933. doTime := utils.TimeRemoveHms2(vAct.RoadshowBeginTime)
  934. findStartDate := doTime + " 00:00:00"
  935. findEndDate := doTime + " 23:59:59"
  936. var roadshowTitle string
  937. roadshowTitle = vAct.RoadshowTitle
  938. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "【", "", -1)
  939. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "】", "", -1)
  940. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, " ", "", -1)
  941. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "-", "", -1)
  942. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, ":", "", -1)
  943. nameSlice := strings.Split(vAct.RoadshowTitle, "|")
  944. //fmt.Println(timeSlice[0])
  945. //对于手动匹配到的活动数据也要更新
  946. var activityName string
  947. if len(nameSlice) >= 1 {
  948. //if vAct.JmcjRoadshowTitle != "" {
  949. // activityName = vAct.JmcjRoadshowTitle
  950. //} else {
  951. // activityName = nameSlice[len(nameSlice)-1]
  952. //}
  953. activityName = nameSlice[len(nameSlice)-1]
  954. if activityName != "" {
  955. //通过名称去找匹配的活动
  956. activityDetail, _ := models.GetAddActivityInfoByTitle(activityName, findStartDate, findEndDate)
  957. if activityDetail == nil {
  958. continue
  959. } else {
  960. activityIds += strconv.Itoa(activityDetail.ActivityId) + ","
  961. }
  962. list, err := models.GetRoadshowDataList(roadshowTitle, findStartDate, findEndDate)
  963. if err != nil {
  964. fmt.Println("GetTacticsList Err:", err.Error())
  965. return err
  966. }
  967. var isPlayback bool // 是否包含回放
  968. needAddAttendanc := make([]*models.CygxActivityAttendanceDetail, 0)
  969. var mobileStr string
  970. if len(list) > 0 {
  971. fmt.Println("原来的", vAct.RoadshowTitle)
  972. fmt.Println("处理的", activityName)
  973. for _, v := range list {
  974. if v.UserPhone != "" {
  975. item := new(models.CygxActivityAttendanceDetail)
  976. item.ActivityId = activityDetail.ActivityId
  977. item.RealName = v.UserName
  978. item.Mobile = v.UserPhone
  979. item.CompanyName = v.Company
  980. //item.SellerName = sellerName
  981. item.FirstMeetingTime = v.FirstWatchTime
  982. item.LastMeetingTime = v.LastWatchTime
  983. item.Duration = utils.GetAttendanceDetailSeconds(v.JoinTime)
  984. if v.JoinType == 1 {
  985. item.MeetingTypeStr = "网络"
  986. } else {
  987. item.MeetingTypeStr = "电话"
  988. }
  989. item.MeetingAuthentication = v.AuthInfo
  990. if v.DataType == 1 {
  991. item.MeetingStatusStr = "直播"
  992. } else {
  993. item.MeetingStatusStr = "回放"
  994. isPlayback = true
  995. }
  996. item.Position = v.Occupation
  997. item.UseridEntity = v.UseridEntity
  998. item.ActivityTime = activityDetail.ActivityTime
  999. item.CrmCompanyMapStatusId = v.CrmCompanyMapStatusId
  1000. item.CreateTime = time.Now()
  1001. mobileStr += "'" + v.UserPhone + "'" + ","
  1002. needAddAttendanc = append(needAddAttendanc, item)
  1003. }
  1004. }
  1005. if isPlayback && mapActivityId[strconv.Itoa(activityDetail.ActivityId)] == "" {
  1006. activityIdsLongTime += strconv.Itoa(activityDetail.ActivityId) + ","
  1007. }
  1008. mobileStr = strings.TrimRight(mobileStr, ",")
  1009. if mobileStr == "" {
  1010. mobileStr = "1"
  1011. }
  1012. listUser, err := models.GetWxUserOutboundMobile(mobileStr)
  1013. if err != nil {
  1014. fmt.Println("GetWxUserOutboundMobile Err:", err.Error())
  1015. return err
  1016. }
  1017. for k, v := range needAddAttendanc {
  1018. for _, v2 := range listUser {
  1019. if v2.OutboundMobile == v.Mobile || v2.Mobile == v.Mobile {
  1020. if needAddAttendanc[k].CompanyId == 0 {
  1021. needAddAttendanc[k].CompanyId = v2.CompanyId
  1022. needAddAttendanc[k].SellerName = v2.SellerName
  1023. needAddAttendanc[k].CompanyName = v2.CompanyName
  1024. needAddAttendanc[k].IsMeetingStr = 1
  1025. }
  1026. }
  1027. }
  1028. }
  1029. //fmt.Println(mobileStr)
  1030. //参会记录
  1031. err = models.AddAttendancDetail(needAddAttendanc, activityDetail.ActivityId, mobileStr)
  1032. if err != nil {
  1033. fmt.Println("AddAttendancDetail Err:", err.Error())
  1034. return err
  1035. }
  1036. ////处理是否限制报名
  1037. err = AddCygxActivityRestrictSignupByAdmin(activityDetail.ActivityId)
  1038. if err != nil {
  1039. fmt.Println("AddCygxActivityRestrictSignupByAdmin Err:", err.Error())
  1040. return err
  1041. }
  1042. go AddctivitySignupDetailByJmcj(needAddAttendanc, activityDetail.ActivityId)
  1043. }
  1044. }
  1045. }
  1046. }
  1047. //获取需要处理的活动
  1048. listActivity, err := models.GetActivityListByDateTime(startDate, endDate, activityIds, detail.ConfigValue)
  1049. if err != nil {
  1050. fmt.Println("GetTacticsList Err:", err.Error())
  1051. return err
  1052. }
  1053. //通过本地去找进门财经的数据
  1054. for _, vAct := range listActivity {
  1055. doTime := utils.TimeRemoveHms2(vAct.ActivityTime)
  1056. findStartDate := doTime + " 00:00:00"
  1057. findEndDate := doTime + " 23:59:59"
  1058. nameSlice := strings.Split(vAct.ActivityName, "】")
  1059. //对于手动匹配到的活动数据也要更新
  1060. var activityName string
  1061. if len(nameSlice) > 1 {
  1062. if vAct.JmcjRoadshowTitle != "" {
  1063. activityName = vAct.JmcjRoadshowTitle
  1064. } else {
  1065. activityName = nameSlice[len(nameSlice)-1]
  1066. }
  1067. //activityName = nameSlice[len(nameSlice)-1]
  1068. if activityName != "" {
  1069. list, err := models.GetRoadshowDataList(activityName, findStartDate, findEndDate)
  1070. if err != nil {
  1071. fmt.Println("GetTacticsList Err:", err.Error())
  1072. return err
  1073. }
  1074. var isPlayback bool // 是否包含回放
  1075. needAddAttendanc := make([]*models.CygxActivityAttendanceDetail, 0)
  1076. var mobileStr string
  1077. if len(list) > 0 {
  1078. fmt.Println("原来的1", vAct.ActivityName)
  1079. fmt.Println("处理的2", activityName)
  1080. for _, v := range list {
  1081. if v.UserPhone != "" {
  1082. item := new(models.CygxActivityAttendanceDetail)
  1083. item.ActivityId = vAct.ActivityId
  1084. item.RealName = v.UserName
  1085. item.Mobile = v.UserPhone
  1086. item.CompanyName = v.Company
  1087. //item.SellerName = sellerName
  1088. item.FirstMeetingTime = v.FirstWatchTime
  1089. item.LastMeetingTime = v.LastWatchTime
  1090. item.Duration = utils.GetAttendanceDetailSeconds(v.JoinTime)
  1091. if v.JoinType == 1 {
  1092. item.MeetingTypeStr = "网络"
  1093. } else {
  1094. item.MeetingTypeStr = "电话"
  1095. }
  1096. item.MeetingAuthentication = v.AuthInfo
  1097. if v.DataType == 1 {
  1098. item.MeetingStatusStr = "直播"
  1099. } else {
  1100. item.MeetingStatusStr = "回放"
  1101. isPlayback = true
  1102. }
  1103. item.Position = v.Occupation
  1104. item.UseridEntity = v.UseridEntity
  1105. item.ActivityTime = vAct.ActivityTime
  1106. item.CrmCompanyMapStatusId = v.CrmCompanyMapStatusId
  1107. item.CreateTime = time.Now()
  1108. mobileStr += "'" + v.UserPhone + "'" + ","
  1109. needAddAttendanc = append(needAddAttendanc, item)
  1110. }
  1111. }
  1112. if isPlayback && mapActivityId[strconv.Itoa(vAct.ActivityId)] == "" {
  1113. activityIdsLongTime += strconv.Itoa(vAct.ActivityId) + ","
  1114. }
  1115. mobileStr = strings.TrimRight(mobileStr, ",")
  1116. if mobileStr == "" {
  1117. mobileStr = "1"
  1118. }
  1119. listUser, err := models.GetWxUserOutboundMobile(mobileStr)
  1120. if err != nil {
  1121. fmt.Println("GetWxUserOutboundMobile Err:", err.Error())
  1122. return err
  1123. }
  1124. for k, v := range needAddAttendanc {
  1125. for _, v2 := range listUser {
  1126. if v2.OutboundMobile == v.Mobile || v2.Mobile == v.Mobile {
  1127. if needAddAttendanc[k].CompanyId == 0 {
  1128. needAddAttendanc[k].CompanyId = v2.CompanyId
  1129. needAddAttendanc[k].SellerName = v2.SellerName
  1130. needAddAttendanc[k].CompanyName = v2.CompanyName
  1131. needAddAttendanc[k].IsMeetingStr = 1
  1132. }
  1133. }
  1134. }
  1135. }
  1136. ////参会记录
  1137. err = models.AddAttendancDetail(needAddAttendanc, vAct.ActivityId, mobileStr)
  1138. if err != nil {
  1139. fmt.Println("AddAttendancDetail Err:", err.Error())
  1140. return err
  1141. }
  1142. ////处理是否限制报名
  1143. err = AddCygxActivityRestrictSignupByAdmin(vAct.ActivityId)
  1144. if err != nil {
  1145. fmt.Println("AddCygxActivityRestrictSignupByAdmin Err:", err.Error())
  1146. return err
  1147. }
  1148. activityIds += strconv.Itoa(vAct.ActivityId) + ","
  1149. go AddctivitySignupDetailByJmcj(needAddAttendanc, vAct.ActivityId)
  1150. }
  1151. }
  1152. }
  1153. }
  1154. if activityIdsLongTime != "" {
  1155. activityIdsLongTime = strings.TrimRight(activityIdsLongTime, ",")
  1156. activityIdsLongTime = detail.ConfigValue + "," + activityIdsLongTime
  1157. go models.UpdateConfigByCode(activityIdsLongTime, configCode)
  1158. }
  1159. activityIds = strings.TrimRight(activityIds, ",")
  1160. if activityIds != "" {
  1161. detailList, err := models.GetActivityAttendanceDetailList(activityIds)
  1162. if err != nil {
  1163. fmt.Println("GetActivityAttendanceDetailList Err:", err.Error())
  1164. return err
  1165. }
  1166. //添加报名日志 (下载使用)
  1167. err = models.AddCygxActivityMeetDetailLogOnlineByList(detailList, activityIds)
  1168. if err != nil {
  1169. fmt.Println("AddCygxActivityMeetDetailLogOnline Err:", err.Error())
  1170. return err
  1171. }
  1172. }
  1173. fmt.Println("结束路演同步")
  1174. return
  1175. }
  1176. // 判断是否加入黑名单
  1177. func AddCygxActivityRestrictSignupByAdmin(activityId int) (err error) {
  1178. total, err := models.GetActivitySignupNomeetingCount(activityId)
  1179. if err != nil {
  1180. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1181. fmt.Println(" Err:", err.Error())
  1182. return err
  1183. }
  1184. if total == 0 {
  1185. return err
  1186. }
  1187. mobileList, _ := models.GetUserMeetingMobile(activityId)
  1188. if len(mobileList) >= 0 {
  1189. for _, v := range mobileList {
  1190. totalRestrict, err := models.GetRestrictSignupCountByUid(v.UserId)
  1191. if err != nil {
  1192. fmt.Println(" Err:", err.Error())
  1193. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1194. return err
  1195. }
  1196. totalNomeet, err := models.GetActivitySignupNomeetingCountByUid(v.UserId)
  1197. if err != nil {
  1198. fmt.Println(" Err:", err.Error())
  1199. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1200. return err
  1201. }
  1202. if totalRestrict > 0 && totalNomeet < 3 {
  1203. err = models.DeleteCygxActivityRestrictSignup(v.UserId)
  1204. if err != nil {
  1205. fmt.Println(" Err:", err.Error())
  1206. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1207. return err
  1208. }
  1209. }
  1210. }
  1211. }
  1212. list, err := models.GetActivitySignupNomeetingCountList(activityId)
  1213. if err != nil {
  1214. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1215. fmt.Println(" 用户限制报名失败 Err:", err.Error())
  1216. return err
  1217. }
  1218. for _, v := range list {
  1219. totalRestrict, err := models.GetRestrictSignupCountByUid(v.UserId)
  1220. if err != nil {
  1221. fmt.Println(" Err:", err.Error())
  1222. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1223. return err
  1224. }
  1225. totalNomeet, err := models.GetActivitySignupNomeetingCountByUid(v.UserId)
  1226. if err != nil {
  1227. fmt.Println(" Err:", err.Error())
  1228. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1229. return err
  1230. }
  1231. if totalNomeet >= 3 {
  1232. if totalRestrict == 0 {
  1233. infoUser, err := models.GetUserAndCompanyNameList(v.UserId)
  1234. if err != nil {
  1235. fmt.Println(" Err:", err.Error())
  1236. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1237. return err
  1238. }
  1239. if infoUser != nil {
  1240. item := new(models.CygxActivityRestrictSignup)
  1241. item.UserId = infoUser.UserId
  1242. item.CreateTime = time.Now()
  1243. item.Mobile = infoUser.Mobile
  1244. item.Email = infoUser.Email
  1245. item.CompanyId = infoUser.CompanyId
  1246. item.CompanyName = infoUser.CompanyName
  1247. item.IsRestrict = 1
  1248. err = models.AddCygxActivityRestrictSignup(item)
  1249. if err != nil {
  1250. fmt.Println(" Err:", err.Error())
  1251. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1252. return err
  1253. }
  1254. }
  1255. }
  1256. }
  1257. }
  1258. return
  1259. }
  1260. // 判断预约纪要按钮是否显示
  1261. func IsShowAppointment(activityTypeId int, chartPermissionName string) (isShowAppointment bool) {
  1262. if activityTypeId == 1 || activityTypeId == 2 || activityTypeId == 3 || activityTypeId == 4 {
  1263. isShowAppointment = true
  1264. }
  1265. if activityTypeId == 5 && chartPermissionName == "医药" {
  1266. isShowAppointment = true
  1267. }
  1268. return
  1269. }
  1270. // 判断预约纪要按钮是否显示
  1271. func IsShowAppointmentByactivityInfo(item *models.ActivityDetail, chartPermissionName string) (isShowAppointment bool) {
  1272. activityTypeId := item.ActivityTypeId
  1273. if activityTypeId == 1 || activityTypeId == 3 || activityTypeId == 4 {
  1274. isShowAppointment = true
  1275. }
  1276. if activityTypeId == 5 && chartPermissionName == "医药" {
  1277. isShowAppointment = true
  1278. }
  1279. if activityTypeId == 2 && item.IsLimitPeople == 0 {
  1280. isShowAppointment = true
  1281. }
  1282. return
  1283. }
  1284. // 用户报告操作行为,模板消息推送 (先放在活动模块下,避免代码冲突)
  1285. func ArticleUserRemind(user *models.WxUserItem, articleDetail *models.ArticleDetail, source int) (err error) {
  1286. defer func() {
  1287. if err != nil {
  1288. go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
  1289. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1290. }
  1291. }()
  1292. countUser, err := models.GetUserRemind(user.UserId)
  1293. if err != nil {
  1294. return err
  1295. }
  1296. if countUser == 0 {
  1297. return err
  1298. }
  1299. var sourceMsg string
  1300. if source == 1 {
  1301. sourceMsg = "阅读报告"
  1302. } else {
  1303. sourceMsg = "收藏报告"
  1304. }
  1305. //获取销售手机号
  1306. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1307. if err != nil && err.Error() != utils.ErrNoRow() {
  1308. return err
  1309. }
  1310. if sellerItemQy != nil {
  1311. openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  1312. if err != nil {
  1313. fmt.Println(err)
  1314. return err
  1315. }
  1316. var keyword1 string
  1317. var keyword2 string
  1318. keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
  1319. keyword2 = articleDetail.Title
  1320. SendWxMsgWithArticleUserRemind(keyword1, keyword2, openIdList, articleDetail.ArticleId)
  1321. }
  1322. return
  1323. }
  1324. // 用户活动操作行为,模板消息推送
  1325. func ActivityUserRemind(user *models.WxUserItem, activityDetail *models.ActivityDetail, source int) (err error) {
  1326. defer func() {
  1327. if err != nil {
  1328. go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
  1329. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1330. }
  1331. }()
  1332. countUser, err := models.GetUserRemind(user.UserId)
  1333. if err != nil {
  1334. return err
  1335. }
  1336. if countUser == 0 {
  1337. return err
  1338. }
  1339. var sourceMsg string
  1340. if source == 1 {
  1341. sourceMsg = "预约外呼"
  1342. } else if source == 2 {
  1343. sourceMsg = "设置会议提醒"
  1344. } else if source == 3 {
  1345. sourceMsg = "预约纪要"
  1346. } else if source == 4 {
  1347. sourceMsg = "活动报名"
  1348. }
  1349. //获取销售手机号
  1350. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1351. if err != nil && err.Error() != utils.ErrNoRow() {
  1352. return err
  1353. }
  1354. if sellerItemQy != nil {
  1355. openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  1356. if err != nil {
  1357. fmt.Println(err)
  1358. return err
  1359. }
  1360. var keyword1 string
  1361. var keyword2 string
  1362. keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
  1363. keyword2 = activityDetail.ActivityName
  1364. SendWxMsgWithActivityUserRemind(keyword1, keyword2, openIdList, activityDetail.ActivityId)
  1365. }
  1366. return
  1367. }
  1368. // 用户专项调研操作行为,模板消息推送
  1369. func SpecialActivityUserRemind(user *models.WxUserItem, activityDetail *models.CygxActivitySpecialDetail, source int) (err error) {
  1370. defer func() {
  1371. if err != nil {
  1372. go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
  1373. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1374. }
  1375. }()
  1376. countUser, err := models.GetUserRemind(user.UserId)
  1377. if err != nil {
  1378. return err
  1379. }
  1380. if countUser == 0 {
  1381. return err
  1382. }
  1383. var sourceMsg string
  1384. if source == 1 {
  1385. sourceMsg = "预报名调研"
  1386. }
  1387. //获取销售手机号
  1388. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1389. if err != nil && err.Error() != utils.ErrNoRow() {
  1390. return err
  1391. }
  1392. if sellerItemQy != nil {
  1393. openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  1394. if err != nil {
  1395. fmt.Println(err)
  1396. return err
  1397. }
  1398. var keyword1 string
  1399. var keyword2 string
  1400. keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
  1401. keyword2 = activityDetail.ResearchTheme
  1402. SendWxMsgWithSpecialActivityUserRemind(keyword1, keyword2, openIdList, activityDetail.ActivityId)
  1403. }
  1404. return
  1405. }
  1406. //func init() {
  1407. // DoActivityOnenIdWxTemplateMsg()
  1408. //}
  1409. // 周日下午四点半推送全部活动
  1410. func DoActivityOnenIdWxTemplateMsg(cont context.Context) (err error) {
  1411. var msg string
  1412. defer func() {
  1413. if err != nil {
  1414. go utils.SendAlarmMsg("周日下午四点半推送全部活动失败,DoActivityOnenIdWxTemplateMsg ErrMsg:"+err.Error(), 2)
  1415. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "DoActivityOnenIdWxTemplateMsg ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1416. fmt.Println(err)
  1417. }
  1418. if msg != "" {
  1419. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  1420. }
  1421. }()
  1422. var condition string
  1423. var pars []interface{}
  1424. openidPowerList, err := models.GetCygxUserRecordPower(condition, pars)
  1425. if err != nil {
  1426. return err
  1427. }
  1428. first := "近期所有行业活动预告,欢迎参与"
  1429. keyword1 := "下周活动预告"
  1430. keyword2 := "已发布"
  1431. keyword3 := ""
  1432. keyword4 := "点击查看下周活动列表"
  1433. SendActivityOnenIdWxTemplateMsg(first, keyword1, keyword2, keyword3, keyword4, openidPowerList)
  1434. return
  1435. }
  1436. func ActivityButtonShow(item *models.ActivityDetail) (articleDetail *models.ActivityDetail) {
  1437. articleDetail = item
  1438. //IsShowAppointment bool `description:"是否展示预约纪要"`
  1439. //IsShowOutboundCall bool `description:"是否展示预约外呼"`
  1440. //IsShowMeetingReminder bool `description:"是否展示会议提醒"`
  1441. //IsShowHelpSsk bool `description:"是否展示帮我带问"`
  1442. //IsShowSignup bool `description:"是否展示我要报名"`
  1443. //如果后台在添加活的时候,关联的报告类型不隐藏预约纪要按钮,而且满足以下展示预约纪要按钮类型就展示
  1444. //if articleDetail.IsHideAppointment == 0 {
  1445. // articleDetail.IsShowAppointment = IsShowAppointmentByactivityInfo(articleDetail, articleDetail.ChartPermissionName)
  1446. //}
  1447. articleDetail.IsShowAppointment = false
  1448. //易董的操作按钮都隐藏
  1449. if articleDetail.YidongActivityId != "" {
  1450. articleDetail.IsShowSignup = false
  1451. articleDetail.IsShowDetails = true
  1452. return
  1453. }
  1454. articleDetail.Expert, _ = GetReportContentTextSub(item.Expert)
  1455. //专家电话会 1
  1456. if articleDetail.ActivityTypeId == 1 && articleDetail.IsLimitPeople == 0 && (articleDetail.ActiveState == "1" || articleDetail.ActiveState == "2") {
  1457. articleDetail.IsShowHelpSsk = true
  1458. }
  1459. //新的是否展示规则
  1460. if articleDetail.IsCanAppointmentMinutes == 1 {
  1461. articleDetail.IsShowAppointment = true
  1462. } else {
  1463. articleDetail.IsShowAppointment = false
  1464. }
  1465. if articleDetail.ActiveState == "1" {
  1466. //专家电话会 1
  1467. //专家电话会限制人数的展示我要报名,不限制的展示预约外外呼
  1468. if articleDetail.ActivityTypeId == 1 {
  1469. //articleDetail.IsShowOutboundCall = true
  1470. if articleDetail.LimitPeopleNum == 0 {
  1471. articleDetail.IsShowOutboundCall = true
  1472. //articleDetail.IsShowHelpSsk = true
  1473. } else {
  1474. articleDetail.IsShowSignup = true
  1475. }
  1476. //if articleDetail.SignupType == 0 {
  1477. // if articleDetail.LimitPeopleNum == 0 {
  1478. // articleDetail.IsShowOutboundCall = true
  1479. // //articleDetail.IsShowHelpSsk = true
  1480. // } else {
  1481. // articleDetail.IsShowSignup = true
  1482. // }
  1483. //} else {
  1484. // if articleDetail.SignupType == 2 {
  1485. // articleDetail.IsShowSignup = true
  1486. // } else {
  1487. // articleDetail.IsShowOutboundCall = true
  1488. // }
  1489. //}
  1490. articleDetail.IsShowMeetingReminder = true
  1491. articleDetail.IsShowHelpSsk = true
  1492. }
  1493. //分析师电话会 2
  1494. if articleDetail.ActivityTypeId == 2 {
  1495. //if articleDetail.SignupType == 0 {
  1496. // if articleDetail.LimitPeopleNum == 0 {
  1497. // articleDetail.IsShowOutboundCall = true
  1498. // //articleDetail.IsShowHelpSsk = true
  1499. // } else {
  1500. // articleDetail.IsShowSignup = true
  1501. // }
  1502. //} else {
  1503. // if articleDetail.SignupType == 2 {
  1504. // articleDetail.IsShowSignup = true
  1505. // } else {
  1506. // articleDetail.IsShowOutboundCall = true
  1507. // }
  1508. //}
  1509. if articleDetail.LimitPeopleNum == 0 {
  1510. articleDetail.IsShowOutboundCall = true
  1511. //articleDetail.IsShowHelpSsk = true
  1512. } else {
  1513. articleDetail.IsShowSignup = true
  1514. }
  1515. articleDetail.IsShowMeetingReminder = true
  1516. }
  1517. //公司调研电话会 3
  1518. if articleDetail.ActivityTypeId == 3 {
  1519. if articleDetail.LimitPeopleNum == 0 {
  1520. articleDetail.IsShowMeetingReminder = true
  1521. articleDetail.IsShowOutboundCall = true
  1522. } else {
  1523. articleDetail.IsShowSignup = true
  1524. }
  1525. }
  1526. //公司线下调研 4
  1527. if articleDetail.ActivityTypeId == 4 {
  1528. articleDetail.IsShowSignup = true
  1529. }
  1530. //专家线下沙龙 5
  1531. if articleDetail.ActivityTypeId == 5 {
  1532. articleDetail.IsShowSignup = true
  1533. }
  1534. //分析师线下沙龙 6
  1535. if articleDetail.ActivityTypeId == 6 {
  1536. articleDetail.IsShowSignup = true
  1537. }
  1538. //分析师电话会(C类) 7
  1539. if articleDetail.ActivityTypeId == 7 {
  1540. articleDetail.IsShowSignup = true
  1541. articleDetail.IsShowMeetingReminder = true
  1542. articleDetail.ActivityTypeName = "分析师电话会"
  1543. }
  1544. }
  1545. if articleDetail.SourceType != 2 {
  1546. articleDetail.SourceType = 1
  1547. }
  1548. //如果是易董创建的活动,展示我要报名,不展示预约外呼
  1549. if articleDetail.IsYidongConduct {
  1550. articleDetail.IsShowSignup = true
  1551. articleDetail.IsShowOutboundCall = false
  1552. }
  1553. activityTimeText := articleDetail.ActivityTimeText
  1554. activityTimeText = strings.Replace(activityTimeText, "(", "(", -1)
  1555. activityTimeText = strings.Replace(activityTimeText, ")", ")", -1)
  1556. articleDetail.ActivityTimeText = activityTimeText
  1557. return
  1558. }
  1559. // GetActivityNewLabelMap 获取活动【新】标签Map
  1560. func GetActivityNewLabelMap(activityIds []int) (labelMap map[int]bool, industryNewMap map[int]bool, err error) {
  1561. labelMap = make(map[int]bool, 0)
  1562. industryNewMap = make(map[int]bool, 0)
  1563. if len(activityIds) == 0 {
  1564. return
  1565. }
  1566. // 获取活动关联的产业
  1567. var groupCond string
  1568. var groupPars []interface{}
  1569. groupCond += ` AND a.activity_id IN (` + utils.GetOrmInReplace(len(activityIds)) + `) AND b.source = 1 `
  1570. groupPars = append(groupPars, activityIds)
  1571. groups, e := models.GetActivityIndustryRelationList(groupCond, groupPars)
  1572. if e != nil {
  1573. err = errors.New("获取活动产业关联列表失败, Err: " + e.Error())
  1574. return
  1575. }
  1576. activityIndustryMap := make(map[int][]int, 0)
  1577. industryIds := make([]int, 0)
  1578. for i := range groups {
  1579. industryIds = append(industryIds, groups[i].IndustrialManagementId)
  1580. activityIndustryMap[groups[i].ActivityId] = append(activityIndustryMap[groups[i].ActivityId], groups[i].IndustrialManagementId)
  1581. }
  1582. // 获取新产业Map
  1583. industryLabelMap, e := GetIndustryNewLabelMap(industryIds)
  1584. if e != nil {
  1585. err = errors.New("获取产业新标签Map失败, Err: " + e.Error())
  1586. return
  1587. }
  1588. // 判断活动是否为新
  1589. for k := range industryLabelMap {
  1590. for k2, v2 := range activityIndustryMap {
  1591. if labelMap[k2] {
  1592. continue
  1593. }
  1594. // 活动的产业ID中存在一个新产业即为新活动
  1595. if utils.InArrayByInt(v2, k) {
  1596. labelMap[k2] = true
  1597. }
  1598. }
  1599. }
  1600. //for _, v := range activityIds {
  1601. // labelMap[v] = true
  1602. //}
  1603. //fmt.Println(labelMap)
  1604. ////产业关联的弘则报告发布日期在三个月以内的活动、产业显示 NEW标签
  1605. articNewLabel, e := GetArticNewLabelWhithActivity3Month()
  1606. if e != nil {
  1607. err = errors.New("获取产业新标签Map失败, Err: " + e.Error())
  1608. return
  1609. }
  1610. for k := range articNewLabel {
  1611. labelMap[k] = false
  1612. }
  1613. return
  1614. }
  1615. // GetActivityVoiceResp 处理活动音频回放
  1616. func GetActivityVoiceResp(mapActivityId []int) (mapItem map[int]*models.CygxActivityVoiceReq, err error) {
  1617. activityVoiceList, err := models.GetCygxActivityVoiceReqList(mapActivityId)
  1618. if err != nil && err.Error() != utils.ErrNoRow() {
  1619. return
  1620. }
  1621. mapActivityVoice := make(map[int]*models.CygxActivityVoiceReq)
  1622. if len(activityVoiceList) > 0 {
  1623. for _, v := range activityVoiceList {
  1624. mapActivityVoice[v.ActivityId] = v
  1625. }
  1626. }
  1627. mapItem = mapActivityVoice
  1628. return
  1629. }
  1630. // AddActivitykeyWordSearch 添加活动搜索记录
  1631. func AddActivitykeyWordSearch(keyWordSearch string, user *models.WxUserItem) {
  1632. if keyWordSearch != "" {
  1633. keyWordItem := new(models.CygxUserSearchKeyWord)
  1634. keyWordItem.UserId = user.UserId
  1635. keyWordItem.KeyWord = keyWordSearch
  1636. keyWordItem.PageType = "ActivitSearch"
  1637. keyWordItem.CreateTime = time.Now()
  1638. go models.AddUserSearchKeyWord(keyWordItem)
  1639. }
  1640. }
  1641. // GetActivityVideoResp 处理活动视频频回放
  1642. func GetActivityVideoResp(mapActivityId []int) (mapItem map[int]*models.CygxActivityVideoListResp, err error) {
  1643. var condition string
  1644. var ativityVIdstr string
  1645. for _, v := range mapActivityId {
  1646. ativityVIdstr += strconv.Itoa(v) + ","
  1647. }
  1648. if ativityVIdstr == "" {
  1649. return
  1650. }
  1651. ativityVIdstr = strings.TrimRight(ativityVIdstr, ",")
  1652. condition += ` AND art.activity_id IN (` + ativityVIdstr + `) `
  1653. var pars []interface{}
  1654. //endTime := time.Now().AddDate(0, 0, -30).Format("2006-01-02 15:04:05")
  1655. //condition += ` AND art.activity_time > ? `
  1656. //pars = append(pars, endTime)
  1657. videoList, e := models.GetActivityVideoListAll(condition, pars, 0, 1000)
  1658. if e != nil && e.Error() != utils.ErrNoRow() {
  1659. err = e
  1660. return
  1661. }
  1662. mapActivityVideo := make(map[int]*models.CygxActivityVideoListResp)
  1663. if len(videoList) > 0 {
  1664. for _, v := range videoList {
  1665. mapActivityVideo[v.ActivityId] = v
  1666. }
  1667. }
  1668. mapItem = mapActivityVideo
  1669. return
  1670. }
  1671. // 用户音视频回放操作操作行为,模板消息推送
  1672. func ActivityVideoUserRmind(user *models.WxUserItem, activityId, fileType int) (err error) {
  1673. defer func() {
  1674. if err != nil {
  1675. go utils.SendAlarmMsg("用户音视频回放操作操作行为,模板消息推送失败"+err.Error(), 2)
  1676. }
  1677. }()
  1678. countUser, err := models.GetUserRemind(user.UserId)
  1679. if err != nil {
  1680. return err
  1681. }
  1682. if countUser == 0 {
  1683. return err
  1684. }
  1685. var first string
  1686. var keyword1 string
  1687. var keyword2 string
  1688. var keyword3 string
  1689. var keyword4 string
  1690. var remark string
  1691. //获取销售手机号
  1692. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1693. if err != nil && err.Error() != utils.ErrNoRow() {
  1694. return err
  1695. }
  1696. if sellerItemQy != nil {
  1697. openIdList, e := models.GetWxOpenIdByMobileList(sellerItemQy.Mobile)
  1698. if e != nil {
  1699. err = errors.New("GetSellerByAdminId, Err: " + e.Error())
  1700. return
  1701. }
  1702. //TripStatus int `description:"行程进行状态 1:预报名,2:确定行程"`
  1703. if fileType == 1 {
  1704. activityInfo, e := models.GetCygxActivityVideoByActivityId(activityId)
  1705. if e != nil {
  1706. err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
  1707. return
  1708. }
  1709. if activityInfo == nil {
  1710. return
  1711. }
  1712. keyword1 = activityInfo.VideoName
  1713. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:播放视频")
  1714. } else {
  1715. activityInfo, e := models.GetCygxActivityVoiceByActivityId(activityId)
  1716. if e != nil {
  1717. err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
  1718. return
  1719. }
  1720. if activityInfo == nil {
  1721. return
  1722. }
  1723. keyword1 = activityInfo.VoiceName
  1724. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:播放音频")
  1725. }
  1726. keyword2 = "__"
  1727. remark = "点击查看活动详情"
  1728. openIdArr := make([]string, 0)
  1729. for _, v := range openIdList {
  1730. openIdArr = append(openIdArr, v.OpenId)
  1731. }
  1732. redirectUrl := utils.WX_MSG_PATH_ACTIVITY_SPECIAL_DETAIL + strconv.Itoa(activityId)
  1733. sendInfo := new(SendWxTemplate)
  1734. sendInfo.First = first
  1735. sendInfo.Keyword1 = keyword1
  1736. sendInfo.Keyword2 = keyword2
  1737. sendInfo.Keyword3 = keyword3
  1738. sendInfo.Keyword4 = keyword4
  1739. sendInfo.Remark = remark
  1740. sendInfo.TemplateId = utils.WxMsgTemplateIdArticleUserRemind
  1741. sendInfo.RedirectUrl = redirectUrl
  1742. sendInfo.RedirectTarget = 3
  1743. sendInfo.Resource = strconv.Itoa(activityId)
  1744. sendInfo.SendType = utils.TEMPLATE_MSG_CYGX_ARTICLE_ADD
  1745. sendInfo.OpenIdArr = openIdArr
  1746. err = PublicSendTemplateMsg(sendInfo)
  1747. if err != nil {
  1748. return
  1749. }
  1750. }
  1751. return
  1752. }
  1753. // 解析活动填写的报告链接
  1754. func GetActivityReportLinkToArticleList(item *models.ActivityDetail) (items []*models.ActivityArticleResp, err error) {
  1755. reportLink := item.ReportLink
  1756. //处理活动的
  1757. var articleIds []int
  1758. var articleList []string
  1759. if strings.Contains(reportLink, ";") {
  1760. articleList = strings.Split(reportLink, ";")
  1761. } else {
  1762. articleList = strings.Split(reportLink, ";")
  1763. }
  1764. for _, v := range articleList {
  1765. linkList := strings.Split(v, "/")
  1766. if linkList[len(linkList)-1] != "" {
  1767. linkArticleId, _ := strconv.Atoi(linkList[len(linkList)-1])
  1768. articleIds = append(articleIds, linkArticleId)
  1769. }
  1770. }
  1771. lenarticleIds := len(articleIds)
  1772. if lenarticleIds == 0 {
  1773. return
  1774. }
  1775. var condition string
  1776. var pars []interface{}
  1777. pars = make([]interface{}, 0)
  1778. condition = ` AND a.article_id IN (` + utils.GetOrmInReplace(lenarticleIds) + `)`
  1779. pars = append(pars, articleIds)
  1780. listArticle, e := models.GetHomeList(condition, pars, 0, len(articleIds))
  1781. if e != nil {
  1782. err = errors.New("GetResourceDataList, Err: " + e.Error())
  1783. return
  1784. }
  1785. if len(listArticle) > 0 {
  1786. for _, v := range listArticle {
  1787. artItem := new(models.ActivityArticleResp)
  1788. artItem.ArticleId = v.ArticleId
  1789. artItem.Title = v.Title
  1790. items = append(items, artItem)
  1791. }
  1792. }
  1793. return
  1794. }
  1795. // GetActivityCityResp 获取活动关联城市,当同一个活动标签对应多个城市的时候,展示最近举办的活动
  1796. func GetActivityCityResp() (mapItem map[string]string, err error) {
  1797. activityList, err := models.GetActivityLabelListCity()
  1798. if err != nil && err.Error() != utils.ErrNoRow() {
  1799. return
  1800. }
  1801. mapActivityCity := make(map[string]string)
  1802. if len(activityList) > 0 {
  1803. for _, v := range activityList {
  1804. if v.ActivityTypeId == utils.C_CLASS_ACTIVITY_TYPE_ID {
  1805. v.ActivityTypeId = utils.ANALYST_TELL_ACTIVITY_TYPE_ID
  1806. }
  1807. //如果城市民称长度大于2,那么就不显示
  1808. if utf8.RuneCountInString(v.City) != 2 || mapActivityCity[fmt.Sprint(v.Label, "{|}", v.ActivityTypeId)] != "" {
  1809. continue
  1810. }
  1811. mapActivityCity[fmt.Sprint(v.Label, "{|}", v.ActivityTypeId)] = v.City
  1812. }
  1813. }
  1814. mapItem = mapActivityCity
  1815. return
  1816. }