activity.go 48 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380
  1. package services
  2. import (
  3. "context"
  4. "fmt"
  5. "github.com/tealeg/xlsx"
  6. "hongze/hongze_cygx/models"
  7. "hongze/hongze_cygx/utils"
  8. "os"
  9. "path/filepath"
  10. "strconv"
  11. "strings"
  12. "time"
  13. )
  14. //修改活动状态
  15. func UpdateActivitySattus(cont context.Context) (err error) {
  16. //defer func() {
  17. // if err != nil {
  18. // fmt.Println("同步失败,Err:", err.Error())
  19. // }
  20. //}()
  21. go models.UpdateActivitySattusToHaveInHand()
  22. go models.UpdateActivitySattusToComplete()
  23. return
  24. }
  25. //推送会议开始消息提醒60分钟前
  26. func SendActivityBeginMsg(cont context.Context) (err error) {
  27. defer func() {
  28. if err != nil {
  29. go utils.SendAlarmMsg("60分钟会议消息提醒失败", 2)
  30. fmt.Println("发送失败,Err:", err.Error())
  31. }
  32. }()
  33. endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
  34. listActivity, err := models.GetActivitySendMsgListAll(endDate)
  35. fmt.Println(len(listActivity))
  36. if err != nil {
  37. fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
  38. return
  39. }
  40. if len(listActivity) == 0 {
  41. return
  42. }
  43. var remark = "点击查看活动详情"
  44. var signupIds string
  45. for _, v := range listActivity {
  46. signupIds += strconv.Itoa(v.Id) + ","
  47. var reserveResults string
  48. var first string
  49. openIdItem := new(models.OpenIdList)
  50. openIdItem.OpenId = v.OpenId
  51. openIdItem.UserId = v.UserId
  52. openIdList := make([]*models.OpenIdList, 0)
  53. openIdList = append(openIdList, openIdItem)
  54. //if v.FailType == 0 {
  55. // reserveResults = "成功"
  56. //} else if v.FailType == 1 {
  57. // reserveResults = "失败(总人数已满)"
  58. //} else if v.FailType == 2 {
  59. // reserveResults = "失败(单机构超限制)"
  60. //} else if v.FailType == 3 {
  61. // reserveResults = "失败(爽约次数超限)"
  62. //}
  63. reserveResults = "--"
  64. first = "您有一场【" + v.ActivityTypeName + "】将在1小时后开始"
  65. SendWxMsgWithFrequency(first, v.ActivityName, reserveResults, v.ActivityTime, v.Address, remark, openIdList, v.ActivityId)
  66. }
  67. if len(signupIds) == 0 {
  68. return
  69. }
  70. signupIds = strings.TrimRight(signupIds, ",")
  71. err = models.UPdateSendedMsgStatus(signupIds)
  72. if err != nil {
  73. var msg string
  74. go utils.SendEmail("发送模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  75. utils.FileLog.Info("发送模版消息失败,Err:%s", err.Error())
  76. }
  77. return
  78. }
  79. //推送会议开始消息提醒15分钟前
  80. func SendActivityBeginMsgMeeting(cont context.Context) (err error) {
  81. defer func() {
  82. if err != nil {
  83. go utils.SendAlarmMsg("15分钟会议消息提醒失败", 2)
  84. fmt.Println("发送失败,Err:", err.Error())
  85. }
  86. }()
  87. endDate := time.Now().Add(+time.Minute * 15).Format(utils.FormatDateTime)
  88. listActivity, err := models.GetActivitySendMsgListAllMeeting(endDate)
  89. if err != nil {
  90. fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
  91. return
  92. }
  93. if len(listActivity) == 0 {
  94. return
  95. }
  96. var signupIds string
  97. var remark = "点击查看活动详情"
  98. for _, v := range listActivity {
  99. signupIds += strconv.Itoa(v.Id) + ","
  100. var reserveResults string
  101. var first string
  102. openIdItem := new(models.OpenIdList)
  103. openIdItem.OpenId = v.OpenId
  104. openIdItem.UserId = v.UserId
  105. openIdList := make([]*models.OpenIdList, 0)
  106. openIdList = append(openIdList, openIdItem)
  107. reserveResults = "--"
  108. first = "您有一场【" + v.ActivityTypeName + "】将在15分钟后开始"
  109. SendWxMsgWithFrequency(first, v.ActivityName, reserveResults, v.ActivityTime, "--", remark, openIdList, v.ActivityId)
  110. }
  111. if len(signupIds) == 0 {
  112. return
  113. }
  114. signupIds = strings.TrimRight(signupIds, ",")
  115. err = models.UPdateSendedMsgMeetingStatus(signupIds)
  116. if err != nil {
  117. var msg string
  118. go utils.SendEmail("发送模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  119. utils.FileLog.Info("发送模版消息失败,Err:%s", err.Error())
  120. }
  121. return
  122. }
  123. //预约外呼名单,会前1小时自动发送邮件给专家组
  124. func SendEmailFileToExpert(cont context.Context) (err error) {
  125. var msg string
  126. var touser string
  127. defer func() {
  128. if err != nil {
  129. fmt.Println("err:", err)
  130. go utils.SendAlarmMsg("发送附件模版消息失败", 2)
  131. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  132. utils.FileLog.Info("发送附件模版消息失败,Err:%s", err.Error())
  133. }
  134. if msg != "" {
  135. fmt.Println(msg)
  136. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  137. }
  138. }()
  139. endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
  140. total, err := models.GetCountActivityIdToSendFile(endDate)
  141. if total == 0 {
  142. fmt.Println("发送附件完成0")
  143. return nil
  144. }
  145. if err != nil {
  146. msg = "发送附件模版消息失败 Err:" + err.Error()
  147. return
  148. }
  149. listActivity, err := models.GetActivityIdToSendFile(endDate)
  150. if err != nil {
  151. msg = "发送附件模版消息失败 Err:" + err.Error()
  152. return
  153. }
  154. for _, v := range listActivity {
  155. activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
  156. if activityInfo == nil {
  157. msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
  158. return
  159. }
  160. list, errFile := models.GetSignupExport(v.ActivityId)
  161. if errFile != nil {
  162. msg = "获取失败,Err:" + errFile.Error()
  163. return
  164. }
  165. //创建excel
  166. dir, errFile := os.Executable()
  167. exPath := filepath.Dir(dir)
  168. downLoadnFilePath := exPath + "/" + time.Now().Format(utils.FormatDateTimeUnSpace) + utils.GetRandDigit(5) + ".xlsx"
  169. xlsxFile := xlsx.NewFile()
  170. if errFile != nil {
  171. msg = "生成文件失败Err:" + errFile.Error()
  172. return
  173. }
  174. style := xlsx.NewStyle()
  175. alignment := xlsx.Alignment{
  176. Horizontal: "center",
  177. Vertical: "center",
  178. WrapText: true,
  179. }
  180. style.Alignment = alignment
  181. style.ApplyAlignment = true
  182. sheet, errFile := xlsxFile.AddSheet("外呼名单")
  183. if errFile != nil {
  184. msg = "新增Sheet失败,Err:" + errFile.Error()
  185. return
  186. }
  187. //设置宽度
  188. _ = sheet.SetColWidth(1, 1, 15)
  189. _ = sheet.SetColWidth(3, 3, 30)
  190. //标头
  191. rowTitle := sheet.AddRow()
  192. cellA := rowTitle.AddCell()
  193. cellA.Value = "姓名"
  194. cellB := rowTitle.AddCell()
  195. cellB.Value = "外呼号码"
  196. cellC := rowTitle.AddCell()
  197. cellC.Value = "国际代码"
  198. cellD := rowTitle.AddCell()
  199. cellD.Value = "公司名称"
  200. cellE := rowTitle.AddCell()
  201. cellE.Value = "所属销售"
  202. for _, item := range list {
  203. row := sheet.AddRow()
  204. cellA := row.AddCell()
  205. cellA.Value = item.RealName
  206. cellB := row.AddCell()
  207. cellB.Value = item.OutboundMobile
  208. cellC := row.AddCell()
  209. if item.CountryCode == "" {
  210. cellC.Value = "86"
  211. } else {
  212. cellC.Value = item.CountryCode
  213. }
  214. cellD := row.AddCell()
  215. cellD.Value = item.CompanyName
  216. cellE := row.AddCell()
  217. cellE.Value = item.SellerName
  218. }
  219. errFile = xlsxFile.Save(downLoadnFilePath)
  220. if errFile != nil {
  221. msg = "保存文件失败Err:" + errFile.Error()
  222. return
  223. }
  224. title := activityInfo.ActivityName + "外呼名单"
  225. content := "外呼名单详情"
  226. fileName := downLoadnFilePath
  227. if activityInfo.ChartPermissionName == "科技" {
  228. touser = utils.EmailTechnology
  229. } else if activityInfo.ChartPermissionName == "医药" {
  230. touser = utils.EmailMedicine
  231. } else if activityInfo.ChartPermissionName == "消费" {
  232. touser = utils.EmailConsumption
  233. } else if activityInfo.ChartPermissionName == "智造" {
  234. touser = utils.EmailZhizao
  235. } else if activityInfo.ChartPermissionName == "策略" {
  236. touser = utils.EmailStrategy
  237. } else if strings.Contains(activityInfo.ChartPermissionName, "研选") {
  238. touser = utils.EmailExpert
  239. }
  240. sendResult := utils.SendEmailByHongze(title, content, touser, fileName, title+".xlsx")
  241. if sendResult {
  242. errFile = models.UPdateActivityIdToSendFile(v.ActivityId)
  243. if errFile != nil {
  244. msg = "获取失败,Err:" + errFile.Error()
  245. return
  246. }
  247. os.Remove(downLoadnFilePath)
  248. } else {
  249. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+activityInfo.ActivityName, utils.EmailSendToUsers)
  250. utils.FileLog.Info("发送附件模版消息失败,Err:%s", activityInfo.ActivityName)
  251. }
  252. }
  253. return
  254. }
  255. func EditOutboundMobile(cont context.Context) (err error) {
  256. defer func() {
  257. if err != nil {
  258. fmt.Println("发送失败,Err:", err.Error())
  259. }
  260. }()
  261. list, err := models.GetActivitySignupListAll()
  262. if err != nil {
  263. fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
  264. return
  265. }
  266. for _, v := range list {
  267. err = models.UPdateSignup(v)
  268. fmt.Println("修改:", strconv.Itoa(v.Id))
  269. if err != nil {
  270. fmt.Println("发送失败,Err:", err.Error()+strconv.Itoa(v.Id))
  271. }
  272. }
  273. fmt.Println("修改完成")
  274. return
  275. }
  276. //同步用户绑定手机号以及区号
  277. func EditUserOutboundMobile(cont context.Context) (err error) {
  278. defer func() {
  279. if err != nil {
  280. fmt.Println("发送失败,Err:", err.Error())
  281. }
  282. }()
  283. list, err := models.GetUserListAll()
  284. if err != nil {
  285. fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
  286. return
  287. }
  288. for _, v := range list {
  289. err = models.UPdateUserCountryCode(v)
  290. fmt.Println("修改:", strconv.Itoa(v.UserId))
  291. if err != nil {
  292. fmt.Println("发送失败,Err:", err.Error()+strconv.Itoa(v.UserId))
  293. }
  294. }
  295. fmt.Println("修改完成")
  296. return
  297. }
  298. //获取 用户类型 //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户;6、冻结客户;7、流失客户
  299. func GetUserType(companyId int) (userType int, permissionStrnew string, err error) {
  300. var permissionStr, permissionZhegnshiStr string
  301. if companyId <= 1 {
  302. userType = 0
  303. } else {
  304. total, errs := models.GetCountCompanyDetailByIdGroup(companyId)
  305. if errs != nil {
  306. err = errs
  307. return
  308. }
  309. if total == 0 {
  310. userType = 0
  311. } else {
  312. companyDetail, errs := models.GetCompanyDetailByIdGroup(companyId)
  313. if errs != nil {
  314. err = errs
  315. return
  316. }
  317. permissionStr, errs = models.GetCompanyPermissionByUserNoStatus(companyId)
  318. if errs != nil {
  319. err = errs
  320. return
  321. }
  322. permissionZhegnshiStr, errs = models.GetCompanyPermissionByUserZhengShi(companyId)
  323. if errs != nil {
  324. err = errs
  325. return
  326. }
  327. //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户
  328. if companyDetail.Status == "永续" {
  329. userType = 1
  330. } else if companyDetail.Status == "试用" {
  331. userType = 5
  332. } else if companyDetail.Status == "正式" {
  333. if permissionStr == "专家" {
  334. userType = 4
  335. } else if strings.Count(permissionZhegnshiStr, "医药") == 2 && strings.Count(permissionZhegnshiStr, "消费") == 2 && strings.Count(permissionZhegnshiStr, "科技") == 2 && strings.Count(permissionZhegnshiStr, "智造") == 2 {
  336. userType = 2
  337. } else {
  338. userType = 3
  339. }
  340. if userType == 3 {
  341. if !strings.Contains(permissionStr, "医药") && !strings.Contains(permissionStr, "消费") && !strings.Contains(permissionStr, "科技") && !strings.Contains(permissionStr, "智造") {
  342. userType = 4
  343. }
  344. }
  345. } else if companyDetail.Status == "冻结" {
  346. userType = 6
  347. } else if companyDetail.Status == "流失" {
  348. userType = 7
  349. }
  350. }
  351. }
  352. permissionStrnew = permissionStr
  353. return
  354. }
  355. // 校验被分享的用户是否有查看详情的权限
  356. func GetShareNoPowe(activityInfo *models.ActivityDetail, permissionStr string, userType int) (noPower bool, err error) {
  357. //var noPower bool
  358. if (userType == 1 || userType == 4 || userType == 5) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(userType)) {
  359. noPower = true
  360. }
  361. //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户
  362. 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)) {
  363. noPower = true
  364. }
  365. if userType == 2 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(2)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
  366. noPower = true
  367. }
  368. if userType == 3 && strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(4)) {
  369. noPower = true
  370. }
  371. if userType == 3 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
  372. noPower = true
  373. }
  374. return
  375. }
  376. // 校验用户报名的权限
  377. func GetHavePower(activityInfo *models.ActivityDetail, permissionStr, companyDetailStatus string, userType int) (havePower bool, err error) {
  378. if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3) && strings.Contains(permissionStr, "专家") && activityInfo.LimitPeopleNum == 0 {
  379. havePower = true
  380. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "正式" && strings.Contains(activityInfo.CustomerTypeIds, "4") {
  381. havePower = true
  382. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "试用" && strings.Contains(activityInfo.CustomerTypeIds, "5") {
  383. havePower = true
  384. //} else if strings.Contains(permissionStr, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(userType)) {
  385. // havePower = true
  386. //} else if strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  387. // havePower = true
  388. } else if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3 || activityInfo.ActivityTypeId == 4 || activityInfo.ActivityTypeId == 5) && strings.Contains(permissionStr, "专家") {
  389. havePower = true
  390. }
  391. if activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 6 || activityInfo.ActivityTypeId == 7 {
  392. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(主观)") {
  393. havePower = true
  394. }
  395. } else {
  396. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(客观)") {
  397. havePower = true
  398. }
  399. }
  400. if (strings.Contains(activityInfo.ChartPermissionName, "研选") || activityInfo.ChartPermissionName == "策略") && strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  401. havePower = true
  402. }
  403. return
  404. }
  405. //获取活动列表查询权限的SQL
  406. // @Param ChartPermissionIds query string false "行业id 多个用 , 隔开"
  407. // @Param ActivityTypeIds query string false "活动类型id 多个用 , 隔开"
  408. // @Param ActiveState query string false "活动进行状态 未开始:1、进行中2、已结束3"
  409. // @Param WhichDay query string false "哪一天 今天:1、明天:2,多个用 , 隔开"
  410. // @Param IsPower query int false "是否选择有权限行业 ,1是 0 否 默认0"
  411. // @Param Label query string false "搜索主题 多个用 , 隔开"
  412. func GetActivityonditionList(user *models.WxUserItem, activityTypeId, chartPermissionIds, whichDay, activeState, label string, isPower, source int) (conditionActivity string, err error) {
  413. adminIds, err := models.GetSelleridWhichGroup(user.CompanyId, 2)
  414. if err != nil {
  415. return
  416. }
  417. userType, permissionStr, err := GetUserType(user.CompanyId)
  418. if err != nil {
  419. return
  420. }
  421. //判断客户规模是否属于可见范围的活动
  422. companyProduct, err := models.GetCompanyProductDetail(user.CompanyId, 2)
  423. if err != nil && err.Error() != utils.ErrNoRow() {
  424. return
  425. }
  426. isMaker := user.IsMaker
  427. slicePer := strings.Split(permissionStr, ",")
  428. var permissionSqlStr string
  429. var permissionNameStr string
  430. for _, v := range slicePer {
  431. if userType == 1 {
  432. //研选权限处理
  433. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  434. permissionNameStr += "'" + v + "',"
  435. }
  436. } else {
  437. permissionNameStr += "'" + v + "',"
  438. }
  439. }
  440. permissionNameStr = strings.Replace(permissionNameStr, "(主观)", "", -1)
  441. permissionNameStr = strings.Replace(permissionNameStr, "(客观)", "", -1)
  442. permissionNameStr = strings.TrimRight(permissionNameStr, ",")
  443. var condition string
  444. var conditionAdmin string
  445. var sqlExport string // 专家权限处理
  446. permissionSqlStr = ` AND art.chart_permission_name IN (` + permissionNameStr + `)`
  447. sqlExport = ` AND (art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' `
  448. if userType == 2 {
  449. sqlExport += ` OR art.customer_type_ids LIKE '%3%' `
  450. }
  451. if (userType == 2 || userType == 3) && strings.Contains(permissionStr, "专家") {
  452. sqlExport += ` OR art.customer_type_ids LIKE '%4%' `
  453. }
  454. sqlExport += `) `
  455. // 如果是C类电话会就不展示内容,且合并到分析师电话会
  456. if activityTypeId == strconv.Itoa(utils.ANALYST_TELL_ACTIVITY_TYPE_ID) {
  457. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id IN (` + activityTypeId + "," + strconv.Itoa(utils.C_CLASS_ACTIVITY_TYPE_ID) + `)`
  458. } else {
  459. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id = ` + activityTypeId
  460. }
  461. //活动仅决策人可见
  462. if isMaker == 0 {
  463. condition += ` AND art.is_maker_show = 0 `
  464. }
  465. //主题
  466. if label != "" {
  467. condition = ` AND art.label LIKE '%` + label + `%' `
  468. }
  469. if isPower == 1 {
  470. condition += permissionSqlStr
  471. }
  472. //行业名称
  473. if len(chartPermissionIds) > 0 {
  474. condition += ` AND art.chart_permission_id IN (` + chartPermissionIds + `)`
  475. }
  476. //如果是PC的,则不看易董的
  477. if source == 1 {
  478. condition += ` AND art.yidong_activity_id = '' `
  479. }
  480. var conditionOr string
  481. if whichDay != "" {
  482. var startDate string
  483. var endDate string
  484. if whichDay == "1" {
  485. startDate = time.Now().Format(utils.FormatDate)
  486. endDate = startDate
  487. } else if whichDay == "2" {
  488. startDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  489. endDate = startDate
  490. } else {
  491. startDate = time.Now().Format(utils.FormatDate)
  492. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  493. }
  494. condition += ` AND art.activity_time >= ` + "'" + startDate + " 00:00:00'"
  495. condition += ` AND art.activity_time <= ` + "'" + endDate + " 23:59:59'"
  496. }
  497. if activeState != "" {
  498. // 默认查看未开始跟进行中
  499. if activeState == "1" {
  500. condition += ` AND art.active_state IN (1,2)`
  501. } else {
  502. condition += ` AND art.active_state IN (` + activeState + `)`
  503. }
  504. } else {
  505. condition += ` AND art.active_state IN (1,2)`
  506. }
  507. conditionAdmin = condition
  508. //查询全部可见的数据(是否全部客户可见)
  509. condition += ` AND art.visible_range != 1 AND art.publish_status = 1 `
  510. if (userType == 2 || userType == 3 || userType == 4) && strings.Contains(permissionStr, "专家") {
  511. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%4%' ` + condition + `) `
  512. }
  513. if (userType == 5) && strings.Contains(permissionStr, "专家") {
  514. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%5%' ` + condition + `) `
  515. }
  516. if userType == 1 {
  517. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + permissionSqlStr + `) `
  518. } else {
  519. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
  520. }
  521. if userType == 6 || userType == 7 {
  522. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' ` + condition + `) `
  523. }
  524. if companyProduct != nil {
  525. if companyProduct.Scale != "" {
  526. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%' ` + condition + `) `
  527. }
  528. }
  529. if adminIds != "" {
  530. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' ` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
  531. if companyProduct != nil {
  532. if companyProduct.Scale != "" {
  533. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%'` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
  534. }
  535. }
  536. }
  537. conditionActivity = condition + permissionSqlStr + sqlExport + conditionOr
  538. return
  539. }
  540. //研选系列专家电话会,会前1小时将问题列表发送给邮箱
  541. func SendEmailFileForAskMsgResearch(cont context.Context) (err error) {
  542. var msg string
  543. //var touser string
  544. defer func() {
  545. if err != nil {
  546. go utils.SendAlarmMsg("发送附件模版消息失败", 2)
  547. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  548. }
  549. if msg != "" {
  550. go utils.SendAlarmMsg(msg, 2)
  551. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  552. }
  553. }()
  554. endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
  555. condition := `AND a.activity_type_id = 1 AND a.chart_permission_id = 31 `
  556. total, err := models.GetCountActivityResearchToSendFile(condition, endDate)
  557. if total == 0 {
  558. fmt.Println("发送附件完成0")
  559. return nil
  560. }
  561. if err != nil {
  562. msg = "发送附件模版消息失败 Err:" + err.Error()
  563. return
  564. }
  565. listActivity, err := models.GetActivityResearchToSendFile(condition, endDate)
  566. if err != nil {
  567. msg = "发送附件模版消息失败 Err:" + err.Error()
  568. return
  569. }
  570. for _, v := range listActivity {
  571. activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
  572. if activityInfo == nil {
  573. msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
  574. return
  575. }
  576. list, errFile := models.GetActivityMsgExport(v.ActivityId)
  577. if errFile != nil {
  578. msg = "获取失败,Err:" + errFile.Error()
  579. return
  580. }
  581. for _, v2 := range list {
  582. user, err := models.GetWxUserItemByUserId(v2.UserId)
  583. if err != nil && err.Error() != utils.ErrNoRow() {
  584. return err
  585. }
  586. //获取销售信息
  587. sellerItem, err := models.GetSellerByCompanyIdCheckFicc(v2.CompanyId, 2)
  588. if err != nil && err.Error() != utils.ErrNoRow() {
  589. return err
  590. }
  591. //给研究员推送消息
  592. if sellerItem != nil {
  593. openIpItem, _ := models.GetUserRecordByMobile(4, utils.ActSendMsgMobile)
  594. if openIpItem != nil && openIpItem.OpenId != "" {
  595. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  596. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  597. }
  598. }
  599. //给所属销售推送消息
  600. if sellerItem != nil {
  601. openIpItem, _ := models.GetUserRecordByMobile(4, sellerItem.Mobile)
  602. if openIpItem != nil && openIpItem.OpenId != "" {
  603. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  604. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  605. }
  606. }
  607. }
  608. errFile = models.UPdateActivityMsgToSendFile(v.ActivityId)
  609. if errFile != nil {
  610. msg = "获取失败,Err:" + errFile.Error()
  611. return
  612. }
  613. }
  614. return
  615. }
  616. //非研选系列专家电话会,根据主持人姓名,会前15分钟将问题列表发送给至该主持人对应邮箱
  617. func SendEmailFileForAskMsg(cont context.Context) (err error) {
  618. var msg string
  619. //var touser string
  620. defer func() {
  621. if err != nil {
  622. go utils.SendAlarmMsg("发送附件模版消息失败", 2)
  623. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  624. }
  625. if msg != "" {
  626. go utils.SendAlarmMsg(msg, 2)
  627. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  628. }
  629. }()
  630. endDate := time.Now().Add(+time.Minute * 15).Format(utils.FormatDateTime)
  631. condition := `AND a.activity_type_id = 1 AND a.chart_permission_id != 31 `
  632. total, err := models.GetCountActivityResearchToSendFile(condition, endDate)
  633. if total == 0 {
  634. fmt.Println("发送附件完成0")
  635. return nil
  636. }
  637. if err != nil {
  638. msg = "发送附件模版消息失败 Err:" + err.Error()
  639. return
  640. }
  641. listActivity, err := models.GetActivityResearchToSendFile(condition, endDate)
  642. if err != nil {
  643. msg = "发送附件模版消息失败 Err:" + err.Error()
  644. return
  645. }
  646. listEmail, errEmail := models.GetAskEmail()
  647. if errEmail != nil {
  648. msg = "获取失败,Err:" + errEmail.Error()
  649. return
  650. }
  651. for _, v := range listActivity {
  652. activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
  653. if activityInfo == nil {
  654. msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
  655. return
  656. }
  657. list, errFile := models.GetActivityMsgExport(v.ActivityId)
  658. if errFile != nil {
  659. msg = "获取失败,Err:" + errFile.Error()
  660. return
  661. }
  662. for _, v2 := range list {
  663. user, err := models.GetWxUserItemByUserId(v2.UserId)
  664. if err != nil && err.Error() != utils.ErrNoRow() {
  665. return err
  666. }
  667. var sendMobile string
  668. for _, vEmail := range listEmail {
  669. if strings.Index(activityInfo.Host, vEmail.Name) > 0 {
  670. sendMobile = vEmail.Mobile
  671. }
  672. }
  673. //获取销售信息
  674. sellerItem, err := models.GetSellerByCompanyIdCheckFicc(v2.CompanyId, 2)
  675. if err != nil && err.Error() != utils.ErrNoRow() {
  676. return err
  677. }
  678. //给研究员推送模板消息
  679. if sellerItem != nil {
  680. openIpItem, _ := models.GetUserRecordByMobile(4, sendMobile)
  681. if openIpItem != nil && openIpItem.OpenId != "" {
  682. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  683. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  684. }
  685. }
  686. //给销售推送模板消息
  687. if sellerItem != nil {
  688. openIpItem, _ := models.GetUserRecordByMobile(4, sellerItem.Mobile)
  689. if openIpItem != nil && openIpItem.OpenId != "" {
  690. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  691. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  692. }
  693. }
  694. }
  695. errFile = models.UPdateActivityMsgToSendFile(v.ActivityId)
  696. if errFile != nil {
  697. msg = "获取失败,Err:" + errFile.Error()
  698. return
  699. }
  700. }
  701. return
  702. }
  703. //活动标签字符串处理
  704. func LabelStr(label string) (labelNew string) {
  705. slicebr := strings.Split(label, "-")
  706. if len(slicebr) < 2 {
  707. labelNew = label
  708. } else {
  709. labelNew = slicebr[1]
  710. }
  711. return labelNew
  712. }
  713. //5.3版本活动标签字符串处理
  714. func LabelStrV5(label string, isShowSubjectName int) (labelNew string) {
  715. slicebr := strings.Split(label, "-")
  716. if len(slicebr) > 1 {
  717. if isShowSubjectName == 1 {
  718. labelNew = slicebr[1]
  719. } else {
  720. labelNew = slicebr[0]
  721. }
  722. } else {
  723. labelNew = label
  724. }
  725. return labelNew
  726. }
  727. func ActivityAttendanceDetail(cont context.Context) (err error) {
  728. defer func() {
  729. if err != nil {
  730. fmt.Println("ActivityAttendanceDetail Err:" + err.Error())
  731. go utils.SendAlarmMsg("同步进门财经数据失败", 2)
  732. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "ActivityAttendanceDetail ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  733. }
  734. }()
  735. configCode := "jin_meng_activity_id"
  736. detail, err := models.GetConfigByCode(configCode)
  737. if err != nil {
  738. return err
  739. }
  740. fmt.Println(detail.ConfigValue)
  741. mapActivityId := make(map[string]string)
  742. sliceValue := strings.Split(detail.ConfigValue, ",")
  743. for _, v := range sliceValue {
  744. mapActivityId[v] = v
  745. }
  746. var activityIds string
  747. var activityIdsLongTime string //可回放的会议,到会详情持续更新加入到不做14天限制的活动中
  748. fmt.Println("开始同步")
  749. dateTime := time.Now().AddDate(0, 0, -14).Format(utils.FormatDate)
  750. dateNow := time.Now().AddDate(0, 0, 0).Format(utils.FormatDate)
  751. startDate := dateTime + " 00:00:00"
  752. endDate := dateNow + " 23:59:59"
  753. //获取进门财经需要处理的活动
  754. listActivityRoadshow, err := models.GetRoadshowDataListByDateTime(startDate, endDate)
  755. if err != nil {
  756. fmt.Println("GetRoadshowDataListByDateTime Err:", err.Error())
  757. return err
  758. }
  759. for _, vAct := range listActivityRoadshow {
  760. doTime := utils.TimeRemoveHms2(vAct.RoadshowBeginTime)
  761. findStartDate := doTime + " 00:00:00"
  762. findEndDate := doTime + " 23:59:59"
  763. var roadshowTitle string
  764. roadshowTitle = vAct.RoadshowTitle
  765. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "【", "", -1)
  766. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "】", "", -1)
  767. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, " ", "", -1)
  768. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "-", "", -1)
  769. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, ":", "", -1)
  770. nameSlice := strings.Split(vAct.RoadshowTitle, "|")
  771. //fmt.Println(timeSlice[0])
  772. //对于手动匹配到的活动数据也要更新
  773. var activityName string
  774. if len(nameSlice) >= 1 {
  775. //if vAct.JmcjRoadshowTitle != "" {
  776. // activityName = vAct.JmcjRoadshowTitle
  777. //} else {
  778. // activityName = nameSlice[len(nameSlice)-1]
  779. //}
  780. activityName = nameSlice[len(nameSlice)-1]
  781. if activityName != "" {
  782. //通过名称去找匹配的活动
  783. activityDetail, _ := models.GetAddActivityInfoByTitle(activityName, findStartDate, findEndDate)
  784. if activityDetail == nil {
  785. continue
  786. } else {
  787. activityIds += strconv.Itoa(activityDetail.ActivityId) + ","
  788. }
  789. list, err := models.GetRoadshowDataList(roadshowTitle, findStartDate, findEndDate)
  790. if err != nil {
  791. fmt.Println("GetTacticsList Err:", err.Error())
  792. return err
  793. }
  794. var isPlayback bool // 是否包含回放
  795. needAddAttendanc := make([]*models.CygxActivityAttendanceDetail, 0)
  796. var mobileStr string
  797. if len(list) > 0 {
  798. fmt.Println("原来的", vAct.RoadshowTitle)
  799. fmt.Println("处理的", activityName)
  800. for _, v := range list {
  801. if v.UserPhone != "" {
  802. item := new(models.CygxActivityAttendanceDetail)
  803. item.ActivityId = activityDetail.ActivityId
  804. item.RealName = v.UserName
  805. item.Mobile = v.UserPhone
  806. item.CompanyName = v.Company
  807. //item.SellerName = sellerName
  808. item.FirstMeetingTime = v.FirstWatchTime
  809. item.LastMeetingTime = v.LastWatchTime
  810. item.Duration = utils.GetAttendanceDetailSeconds(v.JoinTime)
  811. if v.JoinType == 1 {
  812. item.MeetingTypeStr = "网络"
  813. } else {
  814. item.MeetingTypeStr = "电话"
  815. }
  816. item.MeetingAuthentication = v.AuthInfo
  817. if v.DataType == 1 {
  818. item.MeetingStatusStr = "直播"
  819. } else {
  820. item.MeetingStatusStr = "回放"
  821. isPlayback = true
  822. }
  823. item.Position = v.Occupation
  824. item.UseridEntity = v.UseridEntity
  825. item.ActivityTime = activityDetail.ActivityTime
  826. item.CrmCompanyMapStatusId = v.CrmCompanyMapStatusId
  827. item.CreateTime = time.Now()
  828. mobileStr += "'" + v.UserPhone + "'" + ","
  829. needAddAttendanc = append(needAddAttendanc, item)
  830. }
  831. }
  832. if isPlayback && mapActivityId[strconv.Itoa(activityDetail.ActivityId)] == "" {
  833. activityIdsLongTime += strconv.Itoa(activityDetail.ActivityId) + ","
  834. }
  835. mobileStr = strings.TrimRight(mobileStr, ",")
  836. if mobileStr == "" {
  837. mobileStr = "1"
  838. }
  839. listUser, err := models.GetWxUserOutboundMobile(mobileStr)
  840. if err != nil {
  841. fmt.Println("GetWxUserOutboundMobile Err:", err.Error())
  842. return err
  843. }
  844. for k, v := range needAddAttendanc {
  845. for _, v2 := range listUser {
  846. if v2.OutboundMobile == v.Mobile || v2.Mobile == v.Mobile {
  847. if needAddAttendanc[k].CompanyId == 0 {
  848. needAddAttendanc[k].CompanyId = v2.CompanyId
  849. needAddAttendanc[k].SellerName = v2.SellerName
  850. needAddAttendanc[k].CompanyName = v2.CompanyName
  851. needAddAttendanc[k].IsMeetingStr = 1
  852. }
  853. }
  854. }
  855. }
  856. //fmt.Println(mobileStr)
  857. //参会记录
  858. err = models.AddAttendancDetail(needAddAttendanc, activityDetail.ActivityId, mobileStr)
  859. if err != nil {
  860. fmt.Println("AddAttendancDetail Err:", err.Error())
  861. return err
  862. }
  863. ////处理是否限制报名
  864. err = AddCygxActivityRestrictSignupByAdmin(activityDetail.ActivityId)
  865. if err != nil {
  866. fmt.Println("AddCygxActivityRestrictSignupByAdmin Err:", err.Error())
  867. return err
  868. }
  869. }
  870. }
  871. }
  872. }
  873. //获取需要处理的活动
  874. listActivity, err := models.GetActivityListByDateTime(startDate, endDate, activityIds, detail.ConfigValue)
  875. if err != nil {
  876. fmt.Println("GetTacticsList Err:", err.Error())
  877. return err
  878. }
  879. //通过本地去找进门财经的数据
  880. for _, vAct := range listActivity {
  881. doTime := utils.TimeRemoveHms2(vAct.ActivityTime)
  882. findStartDate := doTime + " 00:00:00"
  883. findEndDate := doTime + " 23:59:59"
  884. nameSlice := strings.Split(vAct.ActivityName, "】")
  885. //对于手动匹配到的活动数据也要更新
  886. var activityName string
  887. if len(nameSlice) > 1 {
  888. if vAct.JmcjRoadshowTitle != "" {
  889. activityName = vAct.JmcjRoadshowTitle
  890. } else {
  891. activityName = nameSlice[len(nameSlice)-1]
  892. }
  893. //activityName = nameSlice[len(nameSlice)-1]
  894. if activityName != "" {
  895. list, err := models.GetRoadshowDataList(activityName, findStartDate, findEndDate)
  896. if err != nil {
  897. fmt.Println("GetTacticsList Err:", err.Error())
  898. return err
  899. }
  900. var isPlayback bool // 是否包含回放
  901. needAddAttendanc := make([]*models.CygxActivityAttendanceDetail, 0)
  902. var mobileStr string
  903. if len(list) > 0 {
  904. fmt.Println("原来的1", vAct.ActivityName)
  905. fmt.Println("处理的2", activityName)
  906. for _, v := range list {
  907. if v.UserPhone != "" {
  908. item := new(models.CygxActivityAttendanceDetail)
  909. item.ActivityId = vAct.ActivityId
  910. item.RealName = v.UserName
  911. item.Mobile = v.UserPhone
  912. item.CompanyName = v.Company
  913. //item.SellerName = sellerName
  914. item.FirstMeetingTime = v.FirstWatchTime
  915. item.LastMeetingTime = v.LastWatchTime
  916. item.Duration = utils.GetAttendanceDetailSeconds(v.JoinTime)
  917. if v.JoinType == 1 {
  918. item.MeetingTypeStr = "网络"
  919. } else {
  920. item.MeetingTypeStr = "电话"
  921. }
  922. item.MeetingAuthentication = v.AuthInfo
  923. if v.DataType == 1 {
  924. item.MeetingStatusStr = "直播"
  925. } else {
  926. item.MeetingStatusStr = "回放"
  927. isPlayback = true
  928. }
  929. item.Position = v.Occupation
  930. item.UseridEntity = v.UseridEntity
  931. item.ActivityTime = vAct.ActivityTime
  932. item.CrmCompanyMapStatusId = v.CrmCompanyMapStatusId
  933. item.CreateTime = time.Now()
  934. mobileStr += "'" + v.UserPhone + "'" + ","
  935. needAddAttendanc = append(needAddAttendanc, item)
  936. }
  937. }
  938. if isPlayback && mapActivityId[strconv.Itoa(vAct.ActivityId)] == "" {
  939. activityIdsLongTime += strconv.Itoa(vAct.ActivityId) + ","
  940. }
  941. mobileStr = strings.TrimRight(mobileStr, ",")
  942. if mobileStr == "" {
  943. mobileStr = "1"
  944. }
  945. listUser, err := models.GetWxUserOutboundMobile(mobileStr)
  946. if err != nil {
  947. fmt.Println("GetWxUserOutboundMobile Err:", err.Error())
  948. return err
  949. }
  950. for k, v := range needAddAttendanc {
  951. for _, v2 := range listUser {
  952. if v2.OutboundMobile == v.Mobile || v2.Mobile == v.Mobile {
  953. if needAddAttendanc[k].CompanyId == 0 {
  954. needAddAttendanc[k].CompanyId = v2.CompanyId
  955. needAddAttendanc[k].SellerName = v2.SellerName
  956. needAddAttendanc[k].CompanyName = v2.CompanyName
  957. needAddAttendanc[k].IsMeetingStr = 1
  958. }
  959. }
  960. }
  961. }
  962. ////参会记录
  963. err = models.AddAttendancDetail(needAddAttendanc, vAct.ActivityId, mobileStr)
  964. if err != nil {
  965. fmt.Println("AddAttendancDetail Err:", err.Error())
  966. return err
  967. }
  968. ////处理是否限制报名
  969. err = AddCygxActivityRestrictSignupByAdmin(vAct.ActivityId)
  970. if err != nil {
  971. fmt.Println("AddCygxActivityRestrictSignupByAdmin Err:", err.Error())
  972. return err
  973. }
  974. activityIds += strconv.Itoa(vAct.ActivityId) + ","
  975. }
  976. }
  977. }
  978. }
  979. if activityIdsLongTime != "" {
  980. activityIdsLongTime = strings.TrimRight(activityIdsLongTime, ",")
  981. activityIdsLongTime = detail.ConfigValue + "," + activityIdsLongTime
  982. go models.UpdateConfigByCode(activityIdsLongTime, configCode)
  983. }
  984. activityIds = strings.TrimRight(activityIds, ",")
  985. if activityIds != "" {
  986. detailList, err := models.GetActivityAttendanceDetailList(activityIds)
  987. if err != nil {
  988. fmt.Println("GetActivityAttendanceDetailList Err:", err.Error())
  989. return err
  990. }
  991. //添加报名日志 (下载使用)
  992. err = models.AddCygxActivityMeetDetailLogOnlineByList(detailList, activityIds)
  993. if err != nil {
  994. fmt.Println("AddCygxActivityMeetDetailLogOnline Err:", err.Error())
  995. return err
  996. }
  997. }
  998. fmt.Println("结束路演同步")
  999. return
  1000. }
  1001. //判断是否加入黑名单
  1002. func AddCygxActivityRestrictSignupByAdmin(activityId int) (err error) {
  1003. total, err := models.GetActivitySignupNomeetingCount(activityId)
  1004. if err != nil {
  1005. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1006. fmt.Println(" Err:", err.Error())
  1007. return err
  1008. }
  1009. if total == 0 {
  1010. return err
  1011. }
  1012. mobileList, _ := models.GetUserMeetingMobile(activityId)
  1013. if len(mobileList) >= 0 {
  1014. for _, v := range mobileList {
  1015. totalRestrict, err := models.GetRestrictSignupCountByUid(v.UserId)
  1016. if err != nil {
  1017. fmt.Println(" Err:", err.Error())
  1018. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1019. return err
  1020. }
  1021. totalNomeet, err := models.GetActivitySignupNomeetingCountByUid(v.UserId)
  1022. if err != nil {
  1023. fmt.Println(" Err:", err.Error())
  1024. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1025. return err
  1026. }
  1027. if totalRestrict > 0 && totalNomeet < 3 {
  1028. err = models.DeleteCygxActivityRestrictSignup(v.UserId)
  1029. if err != nil {
  1030. fmt.Println(" Err:", err.Error())
  1031. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1032. return err
  1033. }
  1034. }
  1035. }
  1036. }
  1037. list, err := models.GetActivitySignupNomeetingCountList(activityId)
  1038. if err != nil {
  1039. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1040. fmt.Println(" 用户限制报名失败 Err:", err.Error())
  1041. return err
  1042. }
  1043. for _, v := range list {
  1044. totalRestrict, err := models.GetRestrictSignupCountByUid(v.UserId)
  1045. if err != nil {
  1046. fmt.Println(" Err:", err.Error())
  1047. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1048. return err
  1049. }
  1050. totalNomeet, err := models.GetActivitySignupNomeetingCountByUid(v.UserId)
  1051. if err != nil {
  1052. fmt.Println(" Err:", err.Error())
  1053. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1054. return err
  1055. }
  1056. if totalNomeet >= 3 {
  1057. if totalRestrict == 0 {
  1058. infoUser, err := models.GetUserAndCompanyNameList(v.UserId)
  1059. if err != nil {
  1060. fmt.Println(" Err:", err.Error())
  1061. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1062. return err
  1063. }
  1064. if infoUser != nil {
  1065. item := new(models.CygxActivityRestrictSignup)
  1066. item.UserId = infoUser.UserId
  1067. item.CreateTime = time.Now()
  1068. item.Mobile = infoUser.Mobile
  1069. item.Email = infoUser.Email
  1070. item.CompanyId = infoUser.CompanyId
  1071. item.CompanyName = infoUser.CompanyName
  1072. item.IsRestrict = 1
  1073. err = models.AddCygxActivityRestrictSignup(item)
  1074. if err != nil {
  1075. fmt.Println(" Err:", err.Error())
  1076. utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
  1077. return err
  1078. }
  1079. }
  1080. }
  1081. }
  1082. }
  1083. return
  1084. }
  1085. //判断预约纪要按钮是否显示
  1086. func IsShowAppointment(activityTypeId int, chartPermissionName string) (isShowAppointment bool) {
  1087. if activityTypeId == 1 || activityTypeId == 2 || activityTypeId == 3 || activityTypeId == 4 {
  1088. isShowAppointment = true
  1089. }
  1090. if activityTypeId == 5 && chartPermissionName == "医药" {
  1091. isShowAppointment = true
  1092. }
  1093. return
  1094. }
  1095. //判断预约纪要按钮是否显示
  1096. func IsShowAppointmentByactivityInfo(item *models.ActivityDetail, chartPermissionName string) (isShowAppointment bool) {
  1097. activityTypeId := item.ActivityTypeId
  1098. if activityTypeId == 1 || activityTypeId == 3 || activityTypeId == 4 {
  1099. isShowAppointment = true
  1100. }
  1101. if activityTypeId == 5 && chartPermissionName == "医药" {
  1102. isShowAppointment = true
  1103. }
  1104. if activityTypeId == 2 && item.IsLimitPeople == 0 {
  1105. isShowAppointment = true
  1106. }
  1107. return
  1108. }
  1109. //用户报告操作行为,模板消息推送 (先放在活动模块下,避免代码冲突)
  1110. func ArticleUserRemind(user *models.WxUserItem, articleDetail *models.ArticleDetail, source int) (err error) {
  1111. defer func() {
  1112. if err != nil {
  1113. go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
  1114. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1115. }
  1116. }()
  1117. countUser, err := models.GetUserRemind(user.UserId)
  1118. if err != nil {
  1119. return err
  1120. }
  1121. if countUser == 0 {
  1122. return err
  1123. }
  1124. var sourceMsg string
  1125. if source == 1 {
  1126. sourceMsg = "阅读报告"
  1127. } else {
  1128. sourceMsg = "收藏报告"
  1129. }
  1130. //获取销售手机号
  1131. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1132. if err != nil && err.Error() != utils.ErrNoRow() {
  1133. return err
  1134. }
  1135. if sellerItemQy != nil {
  1136. openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  1137. if err != nil {
  1138. fmt.Println(err)
  1139. return err
  1140. }
  1141. var keyword1 string
  1142. var keyword2 string
  1143. keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
  1144. keyword2 = articleDetail.Title
  1145. SendWxMsgWithArticleUserRemind(keyword1, keyword2, openIdList, articleDetail.ArticleId)
  1146. }
  1147. return
  1148. }
  1149. //用户活动操作行为,模板消息推送
  1150. func ActivityUserRemind(user *models.WxUserItem, activityDetail *models.ActivityDetail, source int) (err error) {
  1151. defer func() {
  1152. if err != nil {
  1153. go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
  1154. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1155. }
  1156. }()
  1157. countUser, err := models.GetUserRemind(user.UserId)
  1158. if err != nil {
  1159. return err
  1160. }
  1161. if countUser == 0 {
  1162. return err
  1163. }
  1164. var sourceMsg string
  1165. if source == 1 {
  1166. sourceMsg = "预约外呼"
  1167. } else if source == 2 {
  1168. sourceMsg = "设置会议提醒"
  1169. } else if source == 3 {
  1170. sourceMsg = "预约纪要"
  1171. } else if source == 4 {
  1172. sourceMsg = "活动报名"
  1173. }
  1174. //获取销售手机号
  1175. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1176. if err != nil && err.Error() != utils.ErrNoRow() {
  1177. return err
  1178. }
  1179. if sellerItemQy != nil {
  1180. openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  1181. if err != nil {
  1182. fmt.Println(err)
  1183. return err
  1184. }
  1185. var keyword1 string
  1186. var keyword2 string
  1187. keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
  1188. keyword2 = activityDetail.ActivityName
  1189. SendWxMsgWithActivityUserRemind(keyword1, keyword2, openIdList, activityDetail.ActivityId)
  1190. }
  1191. return
  1192. }
  1193. //用户专项调研操作行为,模板消息推送
  1194. func SpecialActivityUserRemind(user *models.WxUserItem, activityDetail *models.CygxActivitySpecialDetail, source int) (err error) {
  1195. defer func() {
  1196. if err != nil {
  1197. go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
  1198. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1199. }
  1200. }()
  1201. countUser, err := models.GetUserRemind(user.UserId)
  1202. if err != nil {
  1203. return err
  1204. }
  1205. if countUser == 0 {
  1206. return err
  1207. }
  1208. var sourceMsg string
  1209. if source == 1 {
  1210. sourceMsg = "预报名调研"
  1211. }
  1212. //获取销售手机号
  1213. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1214. if err != nil && err.Error() != utils.ErrNoRow() {
  1215. return err
  1216. }
  1217. if sellerItemQy != nil {
  1218. openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  1219. if err != nil {
  1220. fmt.Println(err)
  1221. return err
  1222. }
  1223. var keyword1 string
  1224. var keyword2 string
  1225. keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
  1226. keyword2 = activityDetail.ResearchTheme
  1227. SendWxMsgWithSpecialActivityUserRemind(keyword1, keyword2, openIdList, activityDetail.ActivityId)
  1228. }
  1229. return
  1230. }
  1231. //func init() {
  1232. // DoActivityOnenIdWxTemplateMsg()
  1233. //}
  1234. //周日下午四点半推送全部活动
  1235. func DoActivityOnenIdWxTemplateMsg(cont context.Context) (err error) {
  1236. var msg string
  1237. defer func() {
  1238. if err != nil {
  1239. go utils.SendAlarmMsg("周日下午四点半推送全部活动失败,DoActivityOnenIdWxTemplateMsg ErrMsg:"+err.Error(), 2)
  1240. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "DoActivityOnenIdWxTemplateMsg ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1241. fmt.Println(err)
  1242. }
  1243. if msg != "" {
  1244. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  1245. }
  1246. }()
  1247. var condition string
  1248. var pars []interface{}
  1249. openidPowerList, err := models.GetCygxUserRecordPower(condition, pars)
  1250. if err != nil {
  1251. return err
  1252. }
  1253. first := "近期所有行业活动预告,欢迎参与"
  1254. keyword1 := "--"
  1255. keyword2 := "--"
  1256. keyword3 := ""
  1257. keyword4 := "点击查看下周活动列表"
  1258. SendActivityOnenIdWxTemplateMsg(first, keyword1, keyword2, keyword3, keyword4, openidPowerList)
  1259. return
  1260. }
  1261. func ActivityButtonShow(item *models.ActivityDetail) (articleDetail *models.ActivityDetail) {
  1262. articleDetail = item
  1263. //IsShowAppointment bool `description:"是否展示预约纪要"`
  1264. //IsShowOutboundCall bool `description:"是否展示预约外呼"`
  1265. //IsShowMeetingReminder bool `description:"是否展示会议提醒"`
  1266. //IsShowHelpSsk bool `description:"是否展示帮我带问"`
  1267. //IsShowSignup bool `description:"是否展示我要报名"`
  1268. //如果后台在添加活的时候,关联的报告类型不隐藏预约纪要按钮,而且满足以下展示预约纪要按钮类型就展示
  1269. //if articleDetail.IsHideAppointment == 0 {
  1270. // articleDetail.IsShowAppointment = IsShowAppointmentByactivityInfo(articleDetail, articleDetail.ChartPermissionName)
  1271. //}
  1272. articleDetail.IsShowAppointment = false
  1273. //易董的操作按钮都隐藏
  1274. if articleDetail.YidongActivityId != "" {
  1275. articleDetail.IsShowSignup = false
  1276. return
  1277. }
  1278. //新的是否展示规则
  1279. if articleDetail.IsCanAppointmentMinutes == 1 {
  1280. articleDetail.IsShowAppointment = true
  1281. } else {
  1282. articleDetail.IsShowAppointment = false
  1283. }
  1284. //专家电话会 1
  1285. if articleDetail.ActivityTypeId == 1 {
  1286. articleDetail.IsShowOutboundCall = true
  1287. if articleDetail.LimitPeopleNum == 0 {
  1288. articleDetail.IsShowMeetingReminder = true
  1289. articleDetail.IsShowHelpSsk = true
  1290. }
  1291. }
  1292. //分析师电话会 2
  1293. if articleDetail.ActivityTypeId == 2 {
  1294. articleDetail.IsShowOutboundCall = true
  1295. if articleDetail.LimitPeopleNum == 0 {
  1296. articleDetail.IsShowMeetingReminder = true
  1297. }
  1298. }
  1299. //公司调研电话会 3
  1300. if articleDetail.ActivityTypeId == 3 {
  1301. if articleDetail.LimitPeopleNum == 0 {
  1302. articleDetail.IsShowMeetingReminder = true
  1303. articleDetail.IsShowOutboundCall = true
  1304. } else {
  1305. articleDetail.IsShowSignup = true
  1306. }
  1307. }
  1308. //公司线下调研 4
  1309. if articleDetail.ActivityTypeId == 4 {
  1310. articleDetail.IsShowSignup = true
  1311. }
  1312. //专家线下沙龙 5
  1313. if articleDetail.ActivityTypeId == 5 {
  1314. articleDetail.IsShowSignup = true
  1315. }
  1316. //分析师线下沙龙 6
  1317. if articleDetail.ActivityTypeId == 6 {
  1318. articleDetail.IsShowSignup = true
  1319. }
  1320. //分析师电话会(C类) 7
  1321. if articleDetail.ActivityTypeId == 7 {
  1322. articleDetail.IsShowSignup = true
  1323. }
  1324. return
  1325. }