activity.go 69 KB

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