activity.go 99 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885
  1. package services
  2. import (
  3. "context"
  4. "errors"
  5. "fmt"
  6. "github.com/tealeg/xlsx"
  7. "hongze/hongze_cygx/models"
  8. "hongze/hongze_cygx/utils"
  9. "os"
  10. "path/filepath"
  11. "strconv"
  12. "strings"
  13. "time"
  14. "unicode/utf8"
  15. )
  16. // 修改活动状态
  17. func UpdateActivitySattus(cont context.Context) (err error) {
  18. //defer func() {
  19. // if err != nil {
  20. // fmt.Println("同步失败,Err:", err.Error())
  21. // }
  22. //}()
  23. go models.UpdateActivitySattusToHaveInHand()
  24. go models.UpdateActivitySattusToComplete()
  25. return
  26. }
  27. // 推送会议开始消息提醒60分钟前
  28. func SendActivityBeginMsg(cont context.Context) (err error) {
  29. //func SendActivityBeginMsg() (err error) {
  30. defer func() {
  31. if err != nil {
  32. go utils.SendAlarmMsg("60分钟会议消息提醒失败"+err.Error(), 2)
  33. fmt.Println("发送失败,Err:", err.Error())
  34. }
  35. }()
  36. endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
  37. listActivity, err := models.GetActivitySendMsgListAll(endDate)
  38. fmt.Println(len(listActivity))
  39. if err != nil {
  40. fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
  41. return
  42. }
  43. if len(listActivity) == 0 {
  44. return
  45. }
  46. var remark = "点击查看活动详情"
  47. var signupIds string
  48. for _, v := range listActivity {
  49. signupIds += strconv.Itoa(v.Id) + ","
  50. var reserveResults string
  51. var first string
  52. openIdItem := new(models.OpenIdList)
  53. openIdItem.OpenId = v.OpenId
  54. openIdItem.UserId = v.UserId
  55. openIdList := make([]*models.OpenIdList, 0)
  56. openIdList = append(openIdList, openIdItem)
  57. //if v.FailType == 0 {
  58. // reserveResults = "成功"
  59. //} else if v.FailType == 1 {
  60. // reserveResults = "失败(总人数已满)"
  61. //} else if v.FailType == 2 {
  62. // reserveResults = "失败(单机构超限制)"
  63. //} else if v.FailType == 3 {
  64. // reserveResults = "失败(爽约次数超限)"
  65. //}
  66. reserveResults = "--"
  67. first = "将在1小时后开始"
  68. SendWxMsgWithFrequency(first, v.ActivityName, reserveResults, v.ActivityTimeText, v.Address, remark, openIdList, v.ActivityId)
  69. }
  70. if len(signupIds) == 0 {
  71. return
  72. }
  73. signupIds = strings.TrimRight(signupIds, ",")
  74. err = models.UPdateSendedMsgStatus(signupIds)
  75. if err != nil {
  76. var msg string
  77. go utils.SendEmail("发送模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  78. utils.FileLog.Info("发送模版消息失败,Err:%s", err.Error())
  79. }
  80. return
  81. }
  82. //func init() {
  83. // SendActivityBeginMsgMeeting()
  84. //}
  85. // 推送会议开始消息提醒15分钟前
  86. func SendActivityBeginMsgMeeting(cont context.Context) (err error) {
  87. //func SendActivityBeginMsgMeeting() (err error) {
  88. defer func() {
  89. if err != nil {
  90. go utils.SendAlarmMsg("15分钟会议消息提醒失败", 2)
  91. fmt.Println("发送失败,Err:", err.Error())
  92. }
  93. }()
  94. var condition string
  95. var pars []interface{}
  96. endDate := time.Now().Add(+time.Minute * 15).Format(utils.FormatDateTime)
  97. condition = ` AND activity_time <= ? AND activity_time >= NOW() AND publish_status = 1 `
  98. pars = append(pars, endDate)
  99. listActivity, e := models.GetCygxActivityList(condition, pars, 0, 100000)
  100. if e != nil && e.Error() != utils.ErrNoRow() {
  101. err = errors.New("GetCygxActivityList, Err: " + e.Error())
  102. return
  103. }
  104. if len(listActivity) == 0 {
  105. return
  106. }
  107. //var signupIds string
  108. var remark = "点击查看活动详情"
  109. var activityIds []int
  110. //同一时间举办的活动不多所以这里循环查询
  111. for _, v := range listActivity {
  112. activityIds = append(activityIds, v.ActivityId)
  113. var mobiles []string
  114. pars = make([]interface{}, 0)
  115. condition = ` AND activity_id = ? AND is_send_wx_msg = 0 `
  116. pars = append(pars, v.ActivityId)
  117. //获取设置消息提醒的用户列表
  118. listxReminder, e := models.GetCygxReminderListByUser(condition, pars)
  119. if e != nil {
  120. err = errors.New("GetCygxReminderListByUser, Err: " + e.Error())
  121. return
  122. }
  123. for _, vReminder := range listxReminder {
  124. mobiles = append(mobiles, vReminder.Mobile)
  125. }
  126. pars = make([]interface{}, 0)
  127. condition = ` AND do_fail_type = 0 AND activity_id = ? AND signup_type = 1 AND is_send_wx_msg = 0 `
  128. pars = append(pars, v.ActivityId)
  129. //获取设置预约外呼的用户列表
  130. listSignup, e := models.GetActivitySignupList(condition, pars)
  131. if e != nil && e.Error() != utils.ErrNoRow() {
  132. err = errors.New("GetActivitySignupList, Err: " + e.Error())
  133. return
  134. }
  135. for _, vSignup := range listSignup {
  136. mobiles = append(mobiles, vSignup.Mobile)
  137. }
  138. //获取这些手机号对应的Openid
  139. listOpenid, e := models.GetUserRecordListByMobileArr(mobiles)
  140. if e != nil && e.Error() != utils.ErrNoRow() {
  141. err = errors.New("GetUserRecordListByMobileArr, Err: " + e.Error())
  142. return
  143. }
  144. openIdList := make([]*models.OpenIdList, 0)
  145. for _, vOpenid := range listOpenid {
  146. openIdItem := new(models.OpenIdList)
  147. openIdItem.OpenId = vOpenid.OpenId
  148. openIdItem.UserId = vOpenid.UserId
  149. openIdList = append(openIdList, openIdItem)
  150. }
  151. var reserveResults string
  152. var keyword2 string
  153. reserveResults = "--"
  154. keyword2 = "将在15分钟后开始"
  155. SendWxMsgWithFrequency(keyword2, v.ActivityName, reserveResults, v.ActivityTimeText, "--", remark, openIdList, v.ActivityId)
  156. }
  157. err = models.UpdateSendedMsgMeetingSendWxMsg(activityIds)
  158. return
  159. }
  160. // 预约外呼名单,会前1小时自动发送邮件给专家组
  161. func SendEmailFileToExpert(cont context.Context) (err error) {
  162. var msg string
  163. var touser string
  164. defer func() {
  165. if err != nil {
  166. fmt.Println("err:", err)
  167. go utils.SendAlarmMsg("预约外呼名单,会前1小时自动发送邮件给专家组失败"+err.Error()+msg, 2)
  168. }
  169. }()
  170. endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
  171. total, e := models.GetCountActivityIdToSendFile(endDate)
  172. if e != nil && e.Error() != utils.ErrNoRow() {
  173. err = errors.New("GetCountActivityIdToSendFile" + e.Error())
  174. return
  175. }
  176. if total == 0 {
  177. fmt.Println("发送附件完成0")
  178. return nil
  179. }
  180. listActivity, e := models.GetActivityIdToSendFile(endDate)
  181. if e != nil && e.Error() != utils.ErrNoRow() {
  182. err = errors.New("GetActivityIdToSendFile" + e.Error())
  183. return
  184. }
  185. if len(listActivity) == 0 {
  186. return
  187. }
  188. var activityIds []int
  189. for _, v := range listActivity {
  190. activityIds = append(activityIds, v.ActivityId)
  191. }
  192. for _, v := range listActivity {
  193. //time.Sleep(30 * time.Second) //延时30秒,避免邮件发送不成功
  194. activityInfo, e := models.GetAddActivityInfoById(v.ActivityId)
  195. if e != nil {
  196. err = errors.New("GetAddActivityInfoById" + e.Error())
  197. return
  198. }
  199. list, e := models.GetSignupExport(v.ActivityId)
  200. if e != nil {
  201. err = errors.New("GetSignupExport" + e.Error())
  202. return
  203. }
  204. var companyIds []int
  205. for _, vSin := range list {
  206. companyIds = append(companyIds, vSin.CompanyId)
  207. }
  208. sellNameMap := GetSellNameMapByCompanyIds(companyIds)
  209. //创建excel
  210. dir, errFile := os.Executable()
  211. exPath := filepath.Dir(dir)
  212. downLoadnFilePath := exPath + "/" + time.Now().Format(utils.FormatDateTimeUnSpace) + utils.GetRandDigit(5) + ".xlsx"
  213. xlsxFile := xlsx.NewFile()
  214. if errFile != nil {
  215. msg = "生成文件失败Err:" + errFile.Error()
  216. return
  217. }
  218. style := xlsx.NewStyle()
  219. alignment := xlsx.Alignment{
  220. Horizontal: "center",
  221. Vertical: "center",
  222. WrapText: true,
  223. }
  224. style.Alignment = alignment
  225. style.ApplyAlignment = true
  226. sheet, errFile := xlsxFile.AddSheet("外呼名单")
  227. if errFile != nil {
  228. msg = "新增Sheet失败,Err:" + errFile.Error()
  229. return
  230. }
  231. //设置宽度
  232. _ = sheet.SetColWidth(1, 1, 15)
  233. _ = sheet.SetColWidth(3, 3, 30)
  234. //标头
  235. rowTitle := sheet.AddRow()
  236. cellA := rowTitle.AddCell()
  237. cellA.Value = "姓名"
  238. cellB := rowTitle.AddCell()
  239. cellB.Value = "外呼号码"
  240. cellC := rowTitle.AddCell()
  241. cellC.Value = "国际代码"
  242. cellD := rowTitle.AddCell()
  243. cellD.Value = "公司名称"
  244. cellE := rowTitle.AddCell()
  245. cellE.Value = "所属销售"
  246. for _, item := range list {
  247. row := sheet.AddRow()
  248. cellA := row.AddCell()
  249. cellA.Value = item.RealName
  250. cellB := row.AddCell()
  251. cellB.Value = item.OutboundMobile
  252. cellC := row.AddCell()
  253. if item.CountryCode == "" {
  254. cellC.Value = "86"
  255. } else {
  256. cellC.Value = item.CountryCode
  257. }
  258. cellD := row.AddCell()
  259. cellD.Value = item.CompanyName
  260. cellE := row.AddCell()
  261. cellE.Value = sellNameMap[item.CompanyId]
  262. }
  263. errFile = xlsxFile.Save(downLoadnFilePath)
  264. if errFile != nil {
  265. msg = "保存文件失败Err:" + errFile.Error()
  266. return
  267. }
  268. title := activityInfo.ActivityName + "外呼名单"
  269. content := "外呼名单详情"
  270. fileName := downLoadnFilePath
  271. if activityInfo.ChartPermissionName == "科技" {
  272. touser = utils.EmailTechnology
  273. } else if activityInfo.ChartPermissionName == "医药" {
  274. touser = utils.EmailMedicine
  275. } else if activityInfo.ChartPermissionName == "消费" {
  276. touser = utils.EmailConsumption
  277. } else if activityInfo.ChartPermissionName == "智造" {
  278. touser = utils.EmailZhizao
  279. } else if activityInfo.ChartPermissionName == "策略" {
  280. touser = utils.EmailStrategy
  281. } else if strings.Contains(activityInfo.ChartPermissionName, "研选") {
  282. touser = utils.EmailExpert
  283. }
  284. sub := strings.Index(touser, ";")
  285. if sub >= 0 {
  286. spArr := strings.Split(touser, ";")
  287. for _, v := range spArr {
  288. utils.SendEmailByHongze(title, content, v, fileName, title+".xlsx")
  289. }
  290. }
  291. os.Remove(downLoadnFilePath)
  292. e = models.UPdateActivityIdToSendFile(v.ActivityId)
  293. if e != nil {
  294. go utils.SendAlarmMsg("UPdateActivityIdToSendFile err"+e.Error(), 2)
  295. }
  296. //sendResult := utils.SendEmailByHongze(title, content, touser, fileName, title+".xlsx")
  297. //if sendResult {
  298. // errFile = models.UPdateActivityIdToSendFile(v.ActivityId)
  299. // if errFile != nil {
  300. // msg = "获取失败,Err:" + errFile.Error()
  301. // return
  302. // }
  303. // os.Remove(downLoadnFilePath)
  304. //} else {
  305. // go utils.SendAlarmMsg("发送附件模版消息失败"+activityInfo.ActivityName, 2)
  306. // utils.FileLog.Info("发送附件模版消息失败,Err:%s", activityInfo.ActivityName)
  307. //}
  308. }
  309. return
  310. }
  311. func EditOutboundMobile(cont context.Context) (err error) {
  312. defer func() {
  313. if err != nil {
  314. fmt.Println("发送失败,Err:", err.Error())
  315. }
  316. }()
  317. list, err := models.GetActivitySignupListAll()
  318. if err != nil {
  319. fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
  320. return
  321. }
  322. for _, v := range list {
  323. err = models.UPdateSignup(v)
  324. fmt.Println("修改:", strconv.Itoa(v.Id))
  325. if err != nil {
  326. fmt.Println("发送失败,Err:", err.Error()+strconv.Itoa(v.Id))
  327. }
  328. }
  329. fmt.Println("修改完成")
  330. return
  331. }
  332. // 同步用户绑定手机号以及区号
  333. func EditUserOutboundMobile(cont context.Context) (err error) {
  334. defer func() {
  335. if err != nil {
  336. fmt.Println("发送失败,Err:", err.Error())
  337. }
  338. }()
  339. list, err := models.GetUserListAll()
  340. if err != nil {
  341. fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
  342. return
  343. }
  344. for _, v := range list {
  345. err = models.UPdateUserCountryCode(v)
  346. fmt.Println("修改:", strconv.Itoa(v.UserId))
  347. if err != nil {
  348. fmt.Println("发送失败,Err:", err.Error()+strconv.Itoa(v.UserId))
  349. }
  350. }
  351. fmt.Println("修改完成")
  352. return
  353. }
  354. // 获取 用户类型 //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户;6、冻结客户;7、流失客户
  355. func GetUserType(companyId int) (userType int, permissionStrnew string, err error) {
  356. var permissionStr, permissionZhengShiStr string
  357. if companyId <= 1 {
  358. userType = 0
  359. } else {
  360. total, errs := models.GetCountCompanyDetailByIdGroup(companyId)
  361. if errs != nil {
  362. err = errs
  363. return
  364. }
  365. if total == 0 {
  366. userType = 0
  367. } else {
  368. companyDetail, errs := models.GetCompanyDetailByIdGroup(companyId)
  369. if errs != nil {
  370. err = errs
  371. return
  372. }
  373. permissionStr, errs = models.GetCompanyPermission(companyId)
  374. if errs != nil {
  375. err = errs
  376. return
  377. }
  378. permissionStrnew = permissionStr
  379. //大套餐客户,数据库添加标识,
  380. companyUserTypeDetail, errs := models.GetCygxCompanyUserType(companyId)
  381. if errs != nil && errs.Error() != utils.ErrNoRow() {
  382. err = errs
  383. return
  384. }
  385. if companyUserTypeDetail != nil {
  386. if companyUserTypeDetail.CustomerTypeId != 0 {
  387. userType = companyUserTypeDetail.CustomerTypeId
  388. return
  389. }
  390. }
  391. permissionZhengShiStr, errs = models.GetCompanyPermissionByUserZhengShi(companyId)
  392. if errs != nil {
  393. err = errs
  394. return
  395. }
  396. //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户、 10: 30W套餐客户
  397. //大套餐客户定义:医药、消费、科技、智造、策略。5个行业中任意4个及以上是正式权限的,属于大套餐客户(医药、消费、科技、智造需要主客观都开)
  398. if companyDetail.Status == "永续" {
  399. userType = 1
  400. } else if companyDetail.Status == "试用" {
  401. userType = 5
  402. } else if companyDetail.Status == "冻结" {
  403. userType = 6
  404. } else if companyDetail.Status == "流失" {
  405. userType = 7
  406. }
  407. //大套餐客户定义:医药、消费、科技、智造、策略。5个行业中任意4个及以上是正式权限的,属于大套餐客户(医药、消费、科技、智造需要主客观都开)
  408. if userType == 0 && companyDetail.Status == "正式" {
  409. var permissionZhegnshiNum int
  410. if strings.Count(permissionZhengShiStr, "医药") == 2 {
  411. permissionZhegnshiNum++
  412. }
  413. if strings.Count(permissionZhengShiStr, "消费") == 2 {
  414. permissionZhegnshiNum++
  415. }
  416. if strings.Count(permissionZhengShiStr, "科技") == 2 {
  417. permissionZhegnshiNum++
  418. }
  419. if strings.Count(permissionZhengShiStr, "智造") == 2 {
  420. permissionZhegnshiNum++
  421. }
  422. if strings.Count(permissionZhengShiStr, "策略") == 1 {
  423. permissionZhegnshiNum++
  424. }
  425. if strings.Count(permissionZhengShiStr, "路演服务") == 1 {
  426. permissionZhegnshiNum++
  427. }
  428. //if permissionZhegnshiNum == 6 {
  429. // userType = 2
  430. //} else
  431. //大套餐客户,数据库添加标识,条件大于等于四的都是 30W套餐客户
  432. if permissionZhegnshiNum >= 4 {
  433. userType = 10
  434. } else {
  435. userType = 3
  436. }
  437. }
  438. }
  439. }
  440. permissionStrnew = permissionStr
  441. return
  442. }
  443. func GetUserTypeZhengShi(companyId int) (userType int, permissionStrnew, permissionStrZhengShinew string, err error) {
  444. var permissionStr, permissionZhengShiStr string
  445. if companyId <= 1 {
  446. userType = 0
  447. } else {
  448. total, errs := models.GetCountCompanyDetailByIdGroup(companyId)
  449. if errs != nil {
  450. err = errs
  451. return
  452. }
  453. if total == 0 {
  454. userType = 0
  455. } else {
  456. companyDetail, errs := models.GetCompanyDetailByIdGroup(companyId)
  457. if errs != nil {
  458. err = errs
  459. return
  460. }
  461. permissionStr, errs = models.GetCompanyPermission(companyId)
  462. if errs != nil {
  463. err = errs
  464. return
  465. }
  466. permissionStrnew = permissionStr
  467. permissionZhengShiStr, errs = models.GetCompanyPermissionByUserZhengShi(companyId)
  468. if errs != nil {
  469. err = errs
  470. return
  471. }
  472. permissionStrZhengShinew = permissionZhengShiStr
  473. //大套餐客户,数据库添加标识,
  474. companyUserTypeDetail, errs := models.GetCygxCompanyUserType(companyId)
  475. if errs != nil && errs.Error() != utils.ErrNoRow() {
  476. err = errs
  477. return
  478. }
  479. if companyUserTypeDetail != nil {
  480. if companyUserTypeDetail.CustomerTypeId != 0 {
  481. userType = companyUserTypeDetail.CustomerTypeId
  482. return
  483. }
  484. }
  485. //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户、 10: 30W套餐客户
  486. //大套餐客户定义:医药、消费、科技、智造、策略。5个行业中任意4个及以上是正式权限的,属于大套餐客户(医药、消费、科技、智造需要主客观都开)
  487. if companyDetail.Status == "永续" {
  488. userType = 1
  489. } else if companyDetail.Status == "试用" {
  490. userType = 5
  491. } else if companyDetail.Status == "冻结" {
  492. userType = 6
  493. } else if companyDetail.Status == "流失" {
  494. userType = 7
  495. }
  496. //大套餐客户定义:医药、消费、科技、智造、策略。5个行业中任意4个及以上是正式权限的,属于大套餐客户(医药、消费、科技、智造需要主客观都开)
  497. if userType == 0 && companyDetail.Status == "正式" {
  498. var permissionZhegnshiNum int
  499. if strings.Count(permissionZhengShiStr, "医药") == 2 {
  500. permissionZhegnshiNum++
  501. }
  502. if strings.Count(permissionZhengShiStr, "消费") == 2 {
  503. permissionZhegnshiNum++
  504. }
  505. if strings.Count(permissionZhengShiStr, "科技") == 2 {
  506. permissionZhegnshiNum++
  507. }
  508. if strings.Count(permissionZhengShiStr, "智造") == 2 {
  509. permissionZhegnshiNum++
  510. }
  511. if strings.Count(permissionZhengShiStr, "策略") == 1 {
  512. permissionZhegnshiNum++
  513. }
  514. if strings.Count(permissionZhengShiStr, "路演服务") == 1 {
  515. permissionZhegnshiNum++
  516. }
  517. //if permissionZhegnshiNum == 6 {
  518. // userType = 2
  519. //} else
  520. //大套餐客户,数据库添加标识,条件大于等于四的都是 30W套餐客户
  521. if permissionZhegnshiNum >= 4 {
  522. userType = 10
  523. } else {
  524. userType = 3
  525. }
  526. }
  527. }
  528. }
  529. permissionStrnew = permissionStr
  530. permissionStrZhengShinew = permissionZhengShiStr
  531. return
  532. }
  533. // GetSpecialDetailUserPower 处理用户查看详情的权限
  534. func GetActivityDetailUserPower(user *models.WxUserItem, activityInfo *models.ActivityDetail) (havePower, isResearchSpecial bool, err error) {
  535. var companyDetailStatus string
  536. var userTypeStr string
  537. activityPointsByUserAllMap := GetActivityPointsByUserAllMap() // 获取对用户进行研选扣点的活动
  538. //勾选【研选扣点】且扣点对象为参会人的活动,需要有买方研选的正式权限
  539. if strings.Contains(activityInfo.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) && activityPointsByUserAllMap[activityInfo.ActivityId] {
  540. isResearchSpecial = true
  541. }
  542. //如果是弘则的用户或者宏观的权限不做校验
  543. //if (GetBelongingRai(user.Mobile) && user.CompanyId == utils.HZ_COMPANY_ID) || activityInfo.ChartPermissionName == utils.HONG_GUAN_NAME {
  544. if GetBelongingRai(user.Mobile) && user.CompanyId == utils.HZ_COMPANY_ID {
  545. havePower = true
  546. return
  547. }
  548. userType, permissionStr, permissionStrZhengShi, e := GetUserTypeZhengShi(user.CompanyId)
  549. if e != nil {
  550. err = errors.New("GetCompanyPermissionUpgrade, Err: " + e.Error())
  551. return
  552. }
  553. //如果一个权限都没有就返回无权限
  554. if permissionStr == "" {
  555. return
  556. }
  557. permissionStr += "," + utils.HONG_GUAN_NAME // 添加一个宏观权限
  558. if permissionStrZhengShi == "" {
  559. permissionStrZhengShi = utils.HONG_GUAN_NAME // 添加一个宏观权限
  560. } else {
  561. permissionStrZhengShi += "," + utils.HONG_GUAN_NAME // 添加一个宏观权限
  562. }
  563. //如果是易董的活动,主、副权限有一个满足即可
  564. if activityInfo.YidongActivityId != "" {
  565. if strings.Contains(permissionStr, activityInfo.ChartPermissionName) || strings.Contains(permissionStr, activityInfo.ChartPermissionNameDeputy) {
  566. havePower = true
  567. return
  568. }
  569. }
  570. //如果权限不包含那么直接返回
  571. if !strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  572. return
  573. }
  574. //如果是 对用户的研选扣点的必须要有研选的正式权限
  575. if activityInfo.IsResearchPoints {
  576. //获取活动对用户要扣的点
  577. userPointsNum, e := models.GetCygxActivityPointsSetUserNum(activityInfo.ActivityId)
  578. if e != nil {
  579. err = errors.New("GetActivitySignupSuccessByUserCountNoHz, Err: " + e.Error())
  580. return
  581. }
  582. if userPointsNum > 0 {
  583. //if !strings.Contains(permissionStr, utils.CHART_PERMISSION_NAME_YANXUAN) {
  584. // //如果连试用权限都没有,那么久按照普通的研选样式展示
  585. // isResearchSpecial = false
  586. //}
  587. if !strings.Contains(permissionStrZhengShi, activityInfo.ChartPermissionName) {
  588. havePower = false
  589. return
  590. }
  591. }
  592. }
  593. //处理决策人可见权限
  594. if user.IsMaker == 0 && activityInfo.IsMakerShow == 1 {
  595. havePower = false
  596. return
  597. }
  598. // 处理本组可见权限
  599. if activityInfo.VisibleRange == 1 {
  600. adminIds, e := models.GetSelleridWhichGroup(user.CompanyId, 2)
  601. if e != nil {
  602. err = errors.New("GetSelleridWhichGroup, Err: " + e.Error())
  603. return
  604. }
  605. haveVisibleRange := false
  606. adminIdSlice := strings.Split(adminIds, ",")
  607. for _, v := range adminIdSlice {
  608. if v == strconv.Itoa(activityInfo.AdminId) {
  609. haveVisibleRange = true
  610. }
  611. }
  612. if !haveVisibleRange {
  613. havePower = false
  614. return
  615. }
  616. }
  617. if permissionStr == "" {
  618. return
  619. }
  620. //如果是易董的活动且属于研选类型,只要开通任何权限就可以查看详情
  621. if activityInfo.YidongActivityId != "" && permissionStr != "" && strings.Contains(activityInfo.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) {
  622. havePower = true
  623. return
  624. }
  625. //医药消费,科技,智造四大行业,验证主客观。如果主客观校验不通过,那么直接返回
  626. if strings.Contains(utils.YI_YAO_NAME+utils.XIAO_FEI_NAME+utils.KE_JI_NAME+utils.ZHI_ZAO_NAME, activityInfo.ChartPermissionName) {
  627. if activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 6 || activityInfo.ActivityTypeId == 7 {
  628. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(主观)") {
  629. havePower = true
  630. } else {
  631. havePower = false
  632. }
  633. } else {
  634. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(客观)") {
  635. havePower = true
  636. } else {
  637. havePower = false
  638. }
  639. }
  640. if !havePower {
  641. return
  642. }
  643. }
  644. if activityInfo.LimitPeopleNum > 0 {
  645. mapUserType, e := GetActivityCcustomerTypeList()
  646. if e != nil {
  647. err = e
  648. return
  649. }
  650. userTypeStr = mapUserType[userType]
  651. // 永续客户、大套餐客户、30W套餐客户可以查看行业升级套餐客户 权限
  652. if userTypeStr == "1" || userTypeStr == "2" || userTypeStr == "AA" {
  653. if strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) && strings.Contains(activityInfo.CustomerTypeIds, "8") {
  654. havePower = true
  655. //return
  656. }
  657. }
  658. } else {
  659. if strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  660. havePower = true
  661. return
  662. }
  663. }
  664. //判断管理规模是否满足
  665. companyProduct, e := models.GetCompanyProductDetail(user.CompanyId, 2)
  666. if e != nil {
  667. err = e
  668. return
  669. }
  670. if companyProduct != nil && activityInfo.Scale != "" {
  671. if strings.Contains(activityInfo.Scale, companyProduct.Scale) {
  672. havePower = true
  673. }
  674. }
  675. if user.CompanyId <= 1 {
  676. return
  677. } else {
  678. if permissionStr == "" {
  679. return
  680. } else {
  681. companyDetail, e := models.GetCompanyDetailById(user.CompanyId)
  682. if e != nil {
  683. err = errors.New("GetCompanyPermissionUpgrade, Err: " + e.Error())
  684. return
  685. }
  686. if companyDetail == nil {
  687. err = errors.New("客户不存在,uid:" + strconv.Itoa(user.UserId) + "CompanyId:" + strconv.Itoa(user.CompanyId))
  688. return
  689. }
  690. companyDetailStatus = companyDetail.Status
  691. }
  692. }
  693. //宏观满足用户可见身份验证权限既满足 2023-9-18
  694. if activityInfo.ChartPermissionId == 1 {
  695. if activityInfo.LimitPeopleNum > 0 {
  696. if strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) {
  697. havePower = true
  698. return
  699. }
  700. } else {
  701. havePower = true
  702. return
  703. }
  704. }
  705. if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3) && strings.Contains(permissionStr, "专家") && activityInfo.LimitPeopleNum == 0 {
  706. havePower = true
  707. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "正式" && strings.Contains(activityInfo.CustomerTypeIds, "4") {
  708. havePower = true
  709. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "试用" && strings.Contains(activityInfo.CustomerTypeIds, "5") {
  710. havePower = true
  711. } else if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3 || activityInfo.ActivityTypeId == 4 || activityInfo.ActivityTypeId == 5) && strings.Contains(permissionStr, "专家") {
  712. havePower = true
  713. }
  714. fmt.Println(permissionStrZhengShi)
  715. //if (strings.Contains(activityInfo.ChartPermissionName, "研选") || activityInfo.ChartPermissionName == "策略") && strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  716. // havePower = true
  717. // return
  718. //}
  719. if strings.Contains(activityInfo.ChartPermissionName, "研选") || activityInfo.ChartPermissionName == "策略" {
  720. if strings.Contains(activityInfo.CustomerTypeIds, "5") {
  721. if strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  722. havePower = true
  723. return
  724. }
  725. } else {
  726. if strings.Contains(permissionStrZhengShi, activityInfo.ChartPermissionName) {
  727. havePower = true
  728. return
  729. }
  730. }
  731. }
  732. permissionShengji, errs := models.GetCompanyPermissionByUserTrip(user.CompanyId)
  733. if errs != nil {
  734. err = errs
  735. return
  736. }
  737. //fmt.Println("主客观2", havePower)
  738. //if strings.Contains(permissionStr, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) {
  739. // havePower = true
  740. //}
  741. //fmt.Println("主客观3", havePower)
  742. //处理升级权限以及用户身份的 双重判断
  743. if activityInfo.CustomerTypeIds != "" {
  744. if !strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) && userTypeStr != "8" {
  745. havePower = false
  746. if strings.Contains(permissionShengji, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, "8") {
  747. havePower = true
  748. }
  749. }
  750. }
  751. if havePower && activityInfo.LimitPeopleNum > 0 {
  752. //对于一些特殊的活动,即使权限满足也不给产看
  753. noPower, e := GetShareNoPowe(activityInfo, permissionStr, userType, user)
  754. if e != nil {
  755. err = errors.New("GetShareNoPowe, Err: " + e.Error())
  756. return
  757. }
  758. if noPower {
  759. havePower = false
  760. }
  761. }
  762. return
  763. }
  764. // 校验被分享的用户是否有查看详情的权限
  765. func GetShareNoPowe(activityInfo *models.ActivityDetail, permissionStr string, userType int, user *models.WxUserItem) (noPower bool, err error) {
  766. //如果是弘则的就不进行可见权限校验
  767. if user.CompanyId == utils.HZ_COMPANY_ID {
  768. return
  769. }
  770. //var noPower bool
  771. //if !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(userType)) {
  772. // noPower = true
  773. //}
  774. //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户
  775. //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)) {
  776. // noPower = true
  777. //}
  778. //if userType == 2 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(2)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
  779. // noPower = true
  780. //}
  781. //if userType == 3 && strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(4)) {
  782. // noPower = true
  783. //}
  784. //if userType == 3 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
  785. // noPower = true
  786. //}
  787. fmt.Println(userType)
  788. if userType == 8 {
  789. permissionShengji, errs := models.GetCompanyPermissionByUserZhengShiTrip(user.CompanyId)
  790. if errs != nil {
  791. err = errs
  792. return
  793. }
  794. if !strings.Contains(permissionShengji, activityInfo.ChartPermissionName) {
  795. noPower = true
  796. return
  797. }
  798. }
  799. if !noPower {
  800. noPower, err = CheckUserPowerByActivityChoose(user, activityInfo)
  801. }
  802. return
  803. }
  804. // 处理活动本组们是否决策人权限
  805. func CheckUserPowerByActivityChoose(user *models.WxUserItem, activityInfo *models.ActivityDetail) (noPower bool, err error) {
  806. //处理 见范围 1,仅本组可见 、2,全部客户可见
  807. if activityInfo.VisibleRange == 1 {
  808. adminIds, errAdmin := models.GetSelleridWhichGroup(user.CompanyId, 2)
  809. if errAdmin != nil {
  810. err = errAdmin
  811. return
  812. }
  813. sliceAdminIds := strings.Split(adminIds, ",")
  814. var haveAdminId bool
  815. for _, v := range sliceAdminIds {
  816. if v == strconv.Itoa(activityInfo.AdminId) {
  817. haveAdminId = true
  818. }
  819. }
  820. if !haveAdminId {
  821. noPower = true
  822. }
  823. }
  824. //处理 是否仅决策人可见 0,否 、1,是
  825. if activityInfo.IsMakerShow == 1 {
  826. if user.IsMaker == 0 {
  827. noPower = true
  828. }
  829. }
  830. return
  831. }
  832. // 校验用户报名的权限
  833. func GetHavePower(activityInfo *models.ActivityDetail, permissionStr, companyDetailStatus string, userType int) (havePower bool, err error) {
  834. // 查研观向7.4-宏观活动不作权限限制
  835. if activityInfo.ChartPermissionId == 1 {
  836. havePower = true
  837. return
  838. }
  839. if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3) && strings.Contains(permissionStr, "专家") && activityInfo.LimitPeopleNum == 0 {
  840. havePower = true
  841. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "正式" && strings.Contains(activityInfo.CustomerTypeIds, "4") {
  842. havePower = true
  843. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "试用" && strings.Contains(activityInfo.CustomerTypeIds, "5") {
  844. havePower = true
  845. //} else if strings.Contains(permissionStr, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(userType)) {
  846. // havePower = true
  847. //} else if strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  848. // havePower = true
  849. } else if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3 || activityInfo.ActivityTypeId == 4 || activityInfo.ActivityTypeId == 5) && strings.Contains(permissionStr, "专家") {
  850. havePower = true
  851. }
  852. if activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 6 || activityInfo.ActivityTypeId == 7 {
  853. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(主观)") {
  854. havePower = true
  855. }
  856. } else {
  857. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(客观)") {
  858. havePower = true
  859. }
  860. }
  861. if (strings.Contains(activityInfo.ChartPermissionName, "研选") || activityInfo.ChartPermissionName == "策略") && strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  862. havePower = true
  863. }
  864. //如果是易董的活动且属于研选类型,只要开通任何权限就可以查看详情
  865. if activityInfo.YidongActivityId != "" && permissionStr != "" && strings.Contains(activityInfo.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) {
  866. havePower = true
  867. }
  868. return
  869. }
  870. // 获取活动列表查询权限的SQL
  871. // @Param ChartPermissionIds query string false "行业id 多个用 , 隔开"
  872. // @Param ActivityTypeIds query string false "活动类型id 多个用 , 隔开"
  873. // @Param ActiveState query string false "活动进行状态 未开始:1、进行中2、已结束3"
  874. // @Param WhichDay query string false "哪一天 今天:1、明天:2,多个用 , 隔开"
  875. // @Param IsPower query int false "是否选择有权限行业 ,1是 0 否 默认0"
  876. // @Param Label query string false "搜索主题 多个用 , 隔开"
  877. // @Param PlayBack query int false "是否仅展示回放 1:是、0:否 默认0"
  878. // @Param KeyWord query string false "搜索关键词 多个用 , 隔开"
  879. // @Param ikType query int false "联想词类型 , 1不做联想,2,做除初始词的联想,3所有联想"
  880. func GetActivityonditionList(user *models.WxUserItem, activityTypeId, chartPermissionIds, whichDay, activeState, label string, isPower, source int, keyWord string, playBack, ikType int) (conditionActivity string, err error) {
  881. keyWordNoIk := keyWord
  882. adminIds, err := models.GetSelleridWhichGroup(user.CompanyId, 2)
  883. if err != nil {
  884. return
  885. }
  886. userType, permissionStr, permissionStrZhengShi, err := GetUserTypeZhengShi(user.CompanyId)
  887. if err != nil {
  888. return
  889. }
  890. //判断客户规模是否属于可见范围的活动
  891. companyProduct, err := models.GetCompanyProductDetail(user.CompanyId, 2)
  892. if err != nil && err.Error() != utils.ErrNoRow() {
  893. return
  894. }
  895. isMaker := user.IsMaker
  896. slicePer := strings.Split(permissionStr, ",")
  897. var permissionSqlStr string
  898. var permissionNameStr string
  899. for _, v := range slicePer {
  900. if userType == 1 {
  901. //研选权限处理
  902. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  903. permissionNameStr += "'" + v + "',"
  904. }
  905. } else {
  906. permissionNameStr += "'" + v + "',"
  907. }
  908. }
  909. permissionNameStr = strings.Replace(permissionNameStr, "(主观)", "", -1)
  910. permissionNameStr = strings.Replace(permissionNameStr, "(客观)", "", -1)
  911. permissionNameStr = strings.TrimRight(permissionNameStr, ",")
  912. slicePerZhengShi := strings.Split(permissionStrZhengShi, ",")
  913. var permissionNameStrZhengShi string
  914. for _, v := range slicePerZhengShi {
  915. if userType == 1 {
  916. //研选权限处理
  917. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  918. permissionNameStrZhengShi += "'" + v + "',"
  919. }
  920. } else {
  921. permissionNameStrZhengShi += "'" + v + "',"
  922. }
  923. }
  924. permissionNameStrZhengShi = strings.Replace(permissionNameStrZhengShi, "(主观)", "", -1)
  925. permissionNameStrZhengShi = strings.Replace(permissionNameStrZhengShi, "(客观)", "", -1)
  926. permissionNameStrZhengShi = strings.TrimRight(permissionNameStrZhengShi, ",")
  927. mapUserType, e := GetActivityCcustomerTypeList()
  928. if e != nil {
  929. err = e
  930. return
  931. }
  932. var userTypeStr string
  933. userTypeStr = mapUserType[userType]
  934. // 查研观向7.4-始终查询宏观的权限(无论是否有权限)
  935. if permissionNameStr == `` {
  936. permissionNameStr = `'宏观'`
  937. } else {
  938. permissionNameStr += `, '宏观'`
  939. }
  940. var condition string
  941. var conditionAdmin string
  942. var conditionHz string // 弘则权限处理
  943. var sqlExport string // 专家权限处理
  944. //permissionSqlStr = ` AND art.chart_permission_name IN (` + permissionNameStr + `)`
  945. sqlExport = ` AND (art.customer_type_ids LIKE '%` + userTypeStr + `%' `
  946. //if userType == 2 {
  947. // sqlExport += ` OR art.customer_type_ids LIKE '%3%' `
  948. //}
  949. //if (userType == 2 || userType == 3) && strings.Contains(permissionStr, "专家") {
  950. // sqlExport += ` OR art.customer_type_ids LIKE '%4%' `
  951. //}
  952. sqlExport += `) `
  953. // 如果是C类电话会就不展示内容,且合并到分析师电话会
  954. if activityTypeId != "" {
  955. if activityTypeId == strconv.Itoa(utils.ANALYST_TELL_ACTIVITY_TYPE_ID) {
  956. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id IN (` + activityTypeId + "," + strconv.Itoa(utils.C_CLASS_ACTIVITY_TYPE_ID) + `)`
  957. } else {
  958. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id IN (` + activityTypeId + `)`
  959. }
  960. }
  961. //主题
  962. if label != "" {
  963. condition = ` AND art.label LIKE "%` + label + `%" `
  964. }
  965. if isPower == 1 {
  966. condition += permissionSqlStr
  967. }
  968. //行业名称
  969. if len(chartPermissionIds) > 0 {
  970. condition += ` AND art.chart_permission_id IN (` + chartPermissionIds + `)`
  971. }
  972. //如果是PC的,则不看易董的
  973. if source == 1 {
  974. condition += ` AND art.yidong_activity_id = '' `
  975. }
  976. var conditionOr string
  977. if whichDay != "" {
  978. var startDate string
  979. var endDate string
  980. if whichDay == "1" {
  981. startDate = time.Now().Format(utils.FormatDate)
  982. endDate = startDate
  983. } else if whichDay == "2" {
  984. startDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  985. endDate = startDate
  986. } else if whichDay == "3" {
  987. startDate = utils.GetNowWeekMonday().Format(utils.FormatDate)
  988. endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
  989. } else if whichDay == "4" {
  990. startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
  991. endDate = utils.GetLastWeekSunday().Format(utils.FormatDate)
  992. } else if whichDay == "5" {
  993. startDate = utils.GetNowMonthFirstDay().Format(utils.FormatDate)
  994. endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
  995. } else if whichDay == "6" {
  996. startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
  997. endDate = utils.GetLastMonthLastDay().Format(utils.FormatDate)
  998. } else if whichDay == "1,2" {
  999. startDate = time.Now().Format(utils.FormatDate)
  1000. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  1001. } else if whichDay == "3,4" {
  1002. startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
  1003. endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
  1004. } else if whichDay == "5,6" {
  1005. startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
  1006. endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
  1007. } else {
  1008. startDate = time.Now().Format(utils.FormatDate)
  1009. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  1010. }
  1011. condition += ` AND art.activity_time >= ` + "'" + startDate + " 00:00:00'"
  1012. condition += ` AND art.activity_time <= ` + "'" + endDate + " 23:59:59'"
  1013. }
  1014. //有搜索条件传过来时,不判进行状态条件
  1015. if keyWord != "" {
  1016. if ikType == 2 || ikType == 3 {
  1017. keyWordArr, e := GetIndustryMapNameSliceV3(keyWord)
  1018. if e != nil {
  1019. err = errors.New("获取分词失败,GetIndustryMapNameSliceV3, Err: " + keyWord + e.Error())
  1020. return
  1021. }
  1022. keyWordArr = RemoveDuplicatesAndEmpty(keyWordArr)
  1023. //var keywords string
  1024. if len(keyWordArr) > 1 {
  1025. if ikType == 2 {
  1026. keyWord = KeyWordArrSqlRegexp(keyWordArr)
  1027. condition += ` AND (art.label NOT LIKE '%` + keyWordNoIk + `%' AND art.activity_name NOT LIKE '%` + keyWordNoIk + `%' ) `
  1028. } else if ikType == 3 {
  1029. keyWord = KeyWordArrSqlRegexpAll(keyWordArr)
  1030. }
  1031. }
  1032. }
  1033. condition += ` AND (art.label REGEXP '` + keyWord + `' OR art.activity_name REGEXP '` + keyWord + `' ) `
  1034. } else {
  1035. if activeState != "" {
  1036. // 默认查看未开始跟进行中
  1037. if activeState == "1" {
  1038. condition += ` AND art.active_state IN (1,2)`
  1039. } else {
  1040. condition += ` AND art.active_state IN (` + activeState + `)`
  1041. }
  1042. } else {
  1043. condition += ` AND art.active_state IN (1,2)`
  1044. }
  1045. }
  1046. if playBack == 1 {
  1047. var pars []interface{}
  1048. ativityVIdArry := make([]string, 0)
  1049. voiceList, e := models.GetActivityVoiceListAll("", pars, 0, 1000)
  1050. if e != nil && e.Error() != utils.ErrNoRow() {
  1051. err = e
  1052. return
  1053. }
  1054. for _, v := range voiceList {
  1055. ativityVIdArry = append(ativityVIdArry, strconv.Itoa(v.ActivityId))
  1056. }
  1057. videoList, e := models.GetActivityVideoListAll("", pars, 0, 1000)
  1058. if e != nil && e.Error() != utils.ErrNoRow() {
  1059. err = e
  1060. return
  1061. }
  1062. for _, v := range videoList {
  1063. ativityVIdArry = append(ativityVIdArry, strconv.Itoa(v.ActivityId))
  1064. }
  1065. //活动音频,设置有效时间为30天,失效后该活动就不再支持音频回放。有效期起始时间为活动的开始时间
  1066. //endTime := time.Now().AddDate(0, 0, -30).Format("2006-01-02 15:04:05")
  1067. //condition += ` AND art.activity_time > '` + endTime + `' `
  1068. if len(ativityVIdArry) > 0 {
  1069. ativityVIdstr := strings.Join(ativityVIdArry, ",")
  1070. condition += ` AND art.activity_id IN (` + ativityVIdstr + `) `
  1071. } else {
  1072. condition += ` AND art.activity_id = 0 `
  1073. }
  1074. }
  1075. //查询全部可见的数据(是否全部客户可见)
  1076. //condition += ` AND art.visible_range != 1 AND art.publish_status = 1 `
  1077. condition += ` AND art.publish_status = 1 `
  1078. if adminIds == "" {
  1079. //condition += ` AND art.visible_range != 1 `
  1080. } else {
  1081. condition += ` AND ( art.visible_range != 1 OR ( art.admin_id IN ( ` + adminIds + ` ) AND art.visible_range = 1 )) `
  1082. }
  1083. conditionHz = condition
  1084. //活动仅决策人可见
  1085. if isMaker == 0 {
  1086. condition += ` AND art.is_maker_show = 0 `
  1087. }
  1088. conditionAdmin = condition + ` AND art.visible_range = 1 `
  1089. //condition += ` AND art.visible_range != 1 `
  1090. if (userType == 2 || userType == 3 || userType == 4) && strings.Contains(permissionStr, "专家") {
  1091. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%4%' ` + condition + `) `
  1092. }
  1093. if (userType == 5) && strings.Contains(permissionStr, "专家") {
  1094. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%5%' ` + condition + `) `
  1095. }
  1096. if userType == 1 {
  1097. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + permissionSqlStr + `) `
  1098. } else {
  1099. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
  1100. }
  1101. if userType == 6 || userType == 7 {
  1102. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' ` + condition + `) `
  1103. }
  1104. if companyProduct != nil {
  1105. if companyProduct.Scale != "" {
  1106. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%' ` + condition + `) `
  1107. }
  1108. }
  1109. if adminIds != "" {
  1110. if userType == 3 {
  1111. conditionAdmin += ` AND art.chart_permission_name IN (` + permissionNameStrZhengShi + `) `
  1112. }
  1113. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + userTypeStr + `%' ` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
  1114. if companyProduct != nil {
  1115. if companyProduct.Scale != "" {
  1116. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%'` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
  1117. }
  1118. }
  1119. }
  1120. conditionShengji, conditionZhengshi, conditionHangYe, e := ActivityLabelSpecialUserSql(user)
  1121. if e != nil {
  1122. err = errors.New("ActivityLabelSpecialUserSql, Err: " + e.Error())
  1123. return
  1124. }
  1125. if conditionShengji != "" {
  1126. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionShengji + condition + ` ) `
  1127. }
  1128. if conditionZhengshi != "" {
  1129. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionZhengshi + condition + ` ) `
  1130. }
  1131. if conditionHangYe != "" {
  1132. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionHangYe + condition + ` ) `
  1133. }
  1134. //弘则研究下的客户不做权限,限制,C类电话会,仅本组销售、部门管理员、admin、权益研究员账号能看到
  1135. if user.CompanyId == utils.HZ_COMPANY_ID {
  1136. mapMobile, e := GetAdminMobileMap()
  1137. if e != nil {
  1138. err = e
  1139. return
  1140. }
  1141. if _, ok := mapMobile[user.Mobile]; ok {
  1142. conditionOr += ` OR ( art.publish_status = 1 ` + conditionHz + `) `
  1143. }
  1144. }
  1145. if userType == 3 {
  1146. condition += ` AND art.chart_permission_name IN (` + permissionNameStrZhengShi + `) `
  1147. }
  1148. conditionActivity = condition + permissionSqlStr + sqlExport + conditionOr
  1149. return
  1150. }
  1151. // 根据用户身份处理活动可见
  1152. func ActivityConditioninitSql(user *models.WxUserItem, condition string, isPower int) (conditionActivity string, err error) {
  1153. //未登录的用户也可以查看所有活动v12.2.1
  1154. if user.UserId == 0 {
  1155. conditionActivity = ` AND art.publish_status = 1 AND art.yidong_activity_id = '' ` + condition
  1156. return
  1157. }
  1158. // cygx_10.9 未绑定联系方式的客户可以看到部分活动
  1159. if user.UserId == 0 || user.CompanyId == 1 {
  1160. conditionActivity = ` AND art.publish_status = 1 AND art.visible_range != 1 AND (art.is_limit_people = 0 OR (art.is_limit_people=1 AND art.is_all_customer_type=1)) ` + condition
  1161. return
  1162. }
  1163. condition += ` AND art.publish_status = 1 `
  1164. conditionActivity = condition
  1165. //弘则可以查看所有活动
  1166. if (GetBelongingRai(user.Mobile) && user.CompanyId == utils.HZ_COMPANY_ID) || user.UserId == 0 {
  1167. return
  1168. }
  1169. adminIds, err := models.GetSelleridWhichGroup(user.CompanyId, 2)
  1170. if err != nil {
  1171. return
  1172. }
  1173. userType, permissionStr, permissionStrZhengShi, err := GetUserTypeZhengShi(user.CompanyId)
  1174. if err != nil {
  1175. return
  1176. }
  1177. //判断客户规模是否属于可见范围的活动
  1178. companyProduct, err := models.GetCompanyProductDetail(user.CompanyId, 2)
  1179. if err != nil && err.Error() != utils.ErrNoRow() {
  1180. return
  1181. }
  1182. isMaker := user.IsMaker
  1183. slicePer := strings.Split(permissionStr, ",")
  1184. var permissionSqlStr string
  1185. var permissionNameStr string
  1186. for _, v := range slicePer {
  1187. if userType == 1 {
  1188. //研选权限处理
  1189. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  1190. permissionNameStr += "'" + v + "',"
  1191. }
  1192. } else {
  1193. permissionNameStr += "'" + v + "',"
  1194. }
  1195. }
  1196. permissionNameStr = strings.Replace(permissionNameStr, "(主观)", "", -1)
  1197. permissionNameStr = strings.Replace(permissionNameStr, "(客观)", "", -1)
  1198. permissionNameStr = strings.TrimRight(permissionNameStr, ",")
  1199. slicePerZhengShi := strings.Split(permissionStrZhengShi, ",")
  1200. var permissionNameStrZhengShi string
  1201. for _, v := range slicePerZhengShi {
  1202. if userType == 1 {
  1203. //研选权限处理
  1204. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  1205. permissionNameStrZhengShi += "'" + v + "',"
  1206. }
  1207. } else {
  1208. permissionNameStrZhengShi += "'" + v + "',"
  1209. }
  1210. }
  1211. permissionNameStrZhengShi = strings.Replace(permissionNameStrZhengShi, "(主观)", "", -1)
  1212. permissionNameStrZhengShi = strings.Replace(permissionNameStrZhengShi, "(客观)", "", -1)
  1213. permissionNameStrZhengShi = strings.TrimRight(permissionNameStrZhengShi, ",")
  1214. mapUserType, e := GetActivityCcustomerTypeList()
  1215. if e != nil {
  1216. err = e
  1217. return
  1218. }
  1219. var userTypeStr string
  1220. userTypeStr = mapUserType[userType]
  1221. // 查研观向7.4-始终查询宏观的权限(无论是否有权限)
  1222. if permissionNameStr == `` {
  1223. permissionNameStr = `'宏观'`
  1224. } else {
  1225. permissionNameStr += `, '宏观'`
  1226. }
  1227. var sqlExport string // 专家权限处理
  1228. sqlExport = ` AND (art.customer_type_ids LIKE '%` + userTypeStr + `%' `
  1229. if (userType == 2 || userType == 3) && strings.Contains(permissionStr, "专家") {
  1230. sqlExport += ` OR art.customer_type_ids LIKE '%4%' `
  1231. }
  1232. sqlExport += `) `
  1233. if isPower == 1 {
  1234. permissionSqlStr = ` AND art.chart_permission_name IN (` + permissionNameStr + `)`
  1235. condition += permissionSqlStr
  1236. }
  1237. var conditionOr string
  1238. //查询全部可见的数据(是否全部客户可见)
  1239. if adminIds != "" {
  1240. condition += ` AND ( art.visible_range != 1 OR ( art.admin_id IN ( ` + adminIds + ` ) AND art.visible_range = 1 )) `
  1241. }
  1242. //活动仅决策人可见
  1243. if isMaker == 0 {
  1244. condition += ` AND art.is_maker_show = 0 `
  1245. }
  1246. //condition += ` AND art.visible_range != 1 `
  1247. if (userType == 2 || userType == 3 || userType == 4) && strings.Contains(permissionStr, "专家") {
  1248. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%4%' ` + condition + `) `
  1249. }
  1250. if (userType == 5) && strings.Contains(permissionStr, "专家") {
  1251. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%5%' ` + condition + `) `
  1252. }
  1253. if userType == 1 {
  1254. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + permissionSqlStr + `) `
  1255. } else {
  1256. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
  1257. }
  1258. if userType == 6 || userType == 7 {
  1259. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' ` + condition + `) `
  1260. }
  1261. if companyProduct != nil {
  1262. if companyProduct.Scale != "" {
  1263. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%' ` + condition + `) `
  1264. }
  1265. }
  1266. conditionShengji, conditionZhengshi, conditionHangYe, e := ActivityLabelSpecialUserSql(user)
  1267. if e != nil {
  1268. err = errors.New("ActivityLabelSpecialUserSql, Err: " + e.Error())
  1269. return
  1270. }
  1271. // 升级客户可查看范围
  1272. if conditionShengji != "" {
  1273. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionShengji + condition + ` ) `
  1274. }
  1275. // 正式客户可查看范围
  1276. if conditionZhengshi != "" {
  1277. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionZhengshi + condition + ` ) `
  1278. }
  1279. // 行业客户可查看范围
  1280. if conditionHangYe != "" {
  1281. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionHangYe + condition + ` ) `
  1282. }
  1283. if userType == 3 {
  1284. condition += ` AND art.chart_permission_name IN (` + permissionNameStrZhengShi + `) `
  1285. }
  1286. condition += ` AND art.is_limit_people = 1 `
  1287. conditionActivity = condition + permissionSqlStr + sqlExport + conditionOr
  1288. return
  1289. }
  1290. // 研选系列专家电话会,会前1小时将问题列表发送给邮箱
  1291. func SendEmailFileForAskMsgResearch(cont context.Context) (err error) {
  1292. var msg string
  1293. //var touser string
  1294. defer func() {
  1295. if err != nil {
  1296. go utils.SendAlarmMsg("发送附件模版消息失败", 2)
  1297. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  1298. }
  1299. if msg != "" {
  1300. go utils.SendAlarmMsg(msg, 2)
  1301. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  1302. }
  1303. }()
  1304. endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
  1305. condition := `AND a.activity_type_id = 1 AND a.chart_permission_id = 31 `
  1306. total, err := models.GetCountActivityResearchToSendFile(condition, endDate)
  1307. if total == 0 {
  1308. fmt.Println("发送附件完成0")
  1309. return nil
  1310. }
  1311. if err != nil {
  1312. msg = "发送附件模版消息失败 Err:" + err.Error()
  1313. return
  1314. }
  1315. listActivity, err := models.GetActivityResearchToSendFile(condition, endDate)
  1316. if err != nil {
  1317. msg = "发送附件模版消息失败 Err:" + err.Error()
  1318. return
  1319. }
  1320. for _, v := range listActivity {
  1321. activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
  1322. if activityInfo == nil {
  1323. msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
  1324. return
  1325. }
  1326. list, errFile := models.GetActivityMsgExport(v.ActivityId)
  1327. if errFile != nil {
  1328. msg = "获取失败,Err:" + errFile.Error()
  1329. return
  1330. }
  1331. for _, v2 := range list {
  1332. user, e := models.GetWxUserItemByUserId(v2.UserId)
  1333. if e != nil && e.Error() != utils.ErrNoRow() {
  1334. err = errors.New("GetWxUserItemByUserId, Err: " + e.Error())
  1335. return err
  1336. }
  1337. //获取销售信息
  1338. sellerItem, e := models.GetSellerByCompanyIdCheckFicc(v2.CompanyId, 2)
  1339. if e != nil && e.Error() != utils.ErrNoRow() {
  1340. err = errors.New("GetSellerByCompanyIdCheckFicc, Err: " + e.Error())
  1341. return
  1342. }
  1343. //如果是研选的就推送给汪洋
  1344. cnf, e := models.GetConfigByCode(utils.TPL_MSG_WANG_YANG)
  1345. if e != nil {
  1346. err = errors.New("GetConfigByCode, Err: " + e.Error())
  1347. return
  1348. }
  1349. //给汪洋推送消息
  1350. if sellerItem != nil {
  1351. openIpItem, _ := models.GetUserRecordByMobile(4, cnf.ConfigValue)
  1352. if openIpItem != nil && openIpItem.OpenId != "" {
  1353. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName+"("+sellerItem.RealName+")", "留言:"+activityInfo.ActivityName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo, v2.AskId)
  1354. }
  1355. }
  1356. //给所属销售推送消息
  1357. if sellerItem != nil {
  1358. openIpItem, _ := models.GetUserRecordByMobile(4, sellerItem.Mobile)
  1359. if openIpItem != nil && openIpItem.OpenId != "" {
  1360. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName+"("+sellerItem.RealName+")", "留言:"+activityInfo.ActivityName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo, v2.AskId)
  1361. }
  1362. }
  1363. }
  1364. errFile = models.UPdateActivityMsgToSendFile(v.ActivityId)
  1365. if errFile != nil {
  1366. msg = "获取失败,Err:" + errFile.Error()
  1367. return
  1368. }
  1369. }
  1370. return
  1371. }
  1372. // 非研选系列专家电话会,根据主持人姓名,会前15分钟将问题列表发送给至该主持人对应邮箱
  1373. func SendEmailFileForAskMsg(cont context.Context) (err error) {
  1374. var msg string
  1375. //var touser string
  1376. defer func() {
  1377. if err != nil {
  1378. go utils.SendAlarmMsg("发送附件模版消息失败", 2)
  1379. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  1380. }
  1381. if msg != "" {
  1382. go utils.SendAlarmMsg(msg, 2)
  1383. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  1384. }
  1385. }()
  1386. endDate := time.Now().Add(+time.Minute * 15).Format(utils.FormatDateTime)
  1387. condition := `AND a.activity_type_id = 1 AND a.chart_permission_id != 31 `
  1388. total, err := models.GetCountActivityResearchToSendFile(condition, endDate)
  1389. if total == 0 {
  1390. fmt.Println("发送附件完成0")
  1391. return nil
  1392. }
  1393. if err != nil {
  1394. msg = "发送附件模版消息失败 Err:" + err.Error()
  1395. return
  1396. }
  1397. listActivity, err := models.GetActivityResearchToSendFile(condition, endDate)
  1398. if err != nil {
  1399. msg = "发送附件模版消息失败 Err:" + err.Error()
  1400. return
  1401. }
  1402. listEmail, errEmail := models.GetAskEmail()
  1403. if errEmail != nil {
  1404. msg = "获取失败,Err:" + errEmail.Error()
  1405. return
  1406. }
  1407. for _, v := range listActivity {
  1408. activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
  1409. if activityInfo == nil {
  1410. msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
  1411. return
  1412. }
  1413. list, errFile := models.GetActivityMsgExport(v.ActivityId)
  1414. if errFile != nil {
  1415. msg = "获取失败,Err:" + errFile.Error()
  1416. return
  1417. }
  1418. for _, v2 := range list {
  1419. user, err := models.GetWxUserItemByUserId(v2.UserId)
  1420. if err != nil && err.Error() != utils.ErrNoRow() {
  1421. return err
  1422. }
  1423. var sendMobile string
  1424. for _, vEmail := range listEmail {
  1425. if strings.Index(activityInfo.Host, vEmail.Name) > 0 {
  1426. sendMobile = vEmail.Mobile
  1427. }
  1428. }
  1429. //获取销售信息
  1430. sellerItem, err := models.GetSellerByCompanyIdCheckFicc(v2.CompanyId, 2)
  1431. if err != nil && err.Error() != utils.ErrNoRow() {
  1432. return err
  1433. }
  1434. //给研究员推送模板消息
  1435. if sellerItem != nil {
  1436. openIpItem, _ := models.GetUserRecordByMobile(4, sendMobile)
  1437. if openIpItem != nil && openIpItem.OpenId != "" {
  1438. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  1439. //SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  1440. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName+"("+sellerItem.RealName+")", "留言:"+activityInfo.ActivityName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo, v2.AskId)
  1441. }
  1442. }
  1443. //给销售推送模板消息
  1444. if sellerItem != nil {
  1445. openIpItem, _ := models.GetUserRecordByMobile(4, sellerItem.Mobile)
  1446. if openIpItem != nil && openIpItem.OpenId != "" {
  1447. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  1448. //SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  1449. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName+"("+sellerItem.RealName+")", "留言:"+activityInfo.ActivityName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo, v2.AskId)
  1450. }
  1451. }
  1452. }
  1453. errFile = models.UPdateActivityMsgToSendFile(v.ActivityId)
  1454. if errFile != nil {
  1455. msg = "获取失败,Err:" + errFile.Error()
  1456. return
  1457. }
  1458. }
  1459. return
  1460. }
  1461. // 活动标签字符串处理
  1462. func LabelStr(label string) (labelNew string) {
  1463. slicebr := strings.Split(label, "-")
  1464. if len(slicebr) < 2 {
  1465. labelNew = label
  1466. } else {
  1467. labelNew = slicebr[1]
  1468. }
  1469. return labelNew
  1470. }
  1471. // 5.3版本活动标签字符串处理
  1472. func LabelStrV5(label string, isShowSubjectName int, temporaryLabel string) (labelNew string) {
  1473. slicebr := strings.Split(label, "-")
  1474. if len(slicebr) > 1 {
  1475. if isShowSubjectName == 1 {
  1476. labelNew = slicebr[1]
  1477. } else {
  1478. labelNew = slicebr[0]
  1479. }
  1480. } else {
  1481. labelNew = label
  1482. }
  1483. if temporaryLabel != "" {
  1484. labelNew = temporaryLabel
  1485. }
  1486. return labelNew
  1487. }
  1488. func ActivityAttendanceDetail(cont context.Context) (err error) {
  1489. defer func() {
  1490. if err != nil {
  1491. fmt.Println("ActivityAttendanceDetail Err:" + err.Error())
  1492. go utils.SendAlarmMsg("同步进门财经数据失败", 2)
  1493. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "ActivityAttendanceDetail ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1494. }
  1495. }()
  1496. configCode := "jin_meng_activity_id"
  1497. detail, err := models.GetConfigByCode(configCode)
  1498. if err != nil {
  1499. return err
  1500. }
  1501. fmt.Println(detail.ConfigValue)
  1502. mapActivityId := make(map[string]string)
  1503. sliceValue := strings.Split(detail.ConfigValue, ",")
  1504. for _, v := range sliceValue {
  1505. mapActivityId[v] = v
  1506. }
  1507. var activityIds string
  1508. var activityIdsLongTime string //可回放的会议,到会详情持续更新加入到不做14天限制的活动中
  1509. fmt.Println("开始同步")
  1510. dateTime := time.Now().AddDate(0, 0, -7).Format(utils.FormatDate)
  1511. dateNow := time.Now().AddDate(0, 0, 0).Format(utils.FormatDate)
  1512. startDate := dateTime + " 00:00:00"
  1513. endDate := dateNow + " 23:59:59"
  1514. //获取进门财经需要处理的活动
  1515. listActivityRoadshow, err := models.GetRoadshowDataListByDateTime(startDate, endDate)
  1516. if err != nil {
  1517. fmt.Println("GetRoadshowDataListByDateTime Err:", err.Error())
  1518. return err
  1519. }
  1520. for _, vAct := range listActivityRoadshow {
  1521. doTime := utils.TimeRemoveHms2(vAct.RoadshowBeginTime)
  1522. findStartDate := doTime + " 00:00:00"
  1523. findEndDate := doTime + " 23:59:59"
  1524. var roadshowTitle string
  1525. roadshowTitle = vAct.RoadshowTitle
  1526. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "【", "", -1)
  1527. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "】", "", -1)
  1528. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, " ", "", -1)
  1529. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "-", "", -1)
  1530. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, ":", "", -1)
  1531. nameSlice := strings.Split(vAct.RoadshowTitle, "|")
  1532. //fmt.Println(timeSlice[0])
  1533. //对于手动匹配到的活动数据也要更新
  1534. var activityName string
  1535. if len(nameSlice) >= 1 {
  1536. //if vAct.JmcjRoadshowTitle != "" {
  1537. // activityName = vAct.JmcjRoadshowTitle
  1538. //} else {
  1539. // activityName = nameSlice[len(nameSlice)-1]
  1540. //}
  1541. activityName = nameSlice[len(nameSlice)-1]
  1542. if activityName != "" {
  1543. //通过名称去找匹配的活动
  1544. activityDetail, _ := models.GetAddActivityInfoByTitle(activityName, findStartDate, findEndDate)
  1545. if activityDetail == nil {
  1546. continue
  1547. } else {
  1548. activityIds += strconv.Itoa(activityDetail.ActivityId) + ","
  1549. }
  1550. list, err := models.GetRoadshowDataList(roadshowTitle, findStartDate, findEndDate)
  1551. if err != nil {
  1552. fmt.Println("GetTacticsList Err:", err.Error())
  1553. return err
  1554. }
  1555. var isPlayback bool // 是否包含回放
  1556. needAddAttendanc := make([]*models.CygxActivityAttendanceDetail, 0)
  1557. var mobileStr string
  1558. var mobileArr []string
  1559. if len(list) > 0 {
  1560. fmt.Println("原来的", vAct.RoadshowTitle)
  1561. fmt.Println("处理的", activityName)
  1562. for _, v := range list {
  1563. if v.UserPhone != "" {
  1564. item := new(models.CygxActivityAttendanceDetail)
  1565. item.ActivityId = activityDetail.ActivityId
  1566. item.RealName = v.UserName
  1567. item.Mobile = v.UserPhone
  1568. item.CompanyName = v.Company
  1569. //item.SellerName = sellerName
  1570. item.FirstMeetingTime = v.FirstWatchTime
  1571. item.LastMeetingTime = v.LastWatchTime
  1572. item.Duration = utils.GetAttendanceDetailSeconds(v.JoinTime)
  1573. if v.JoinType == 1 {
  1574. item.MeetingTypeStr = "网络"
  1575. } else {
  1576. item.MeetingTypeStr = "电话"
  1577. }
  1578. item.MeetingAuthentication = v.AuthInfo
  1579. if v.DataType == 1 {
  1580. item.MeetingStatusStr = "直播"
  1581. } else {
  1582. item.MeetingStatusStr = "回放"
  1583. isPlayback = true
  1584. }
  1585. item.Position = v.Occupation
  1586. item.UseridEntity = v.UseridEntity
  1587. item.ActivityTime = activityDetail.ActivityTime
  1588. item.CrmCompanyMapStatusId = v.CrmCompanyMapStatusId
  1589. item.CreateTime = time.Now()
  1590. mobileStr += "'" + v.UserPhone + "'" + ","
  1591. mobileArr = append(mobileArr, v.UserPhone)
  1592. needAddAttendanc = append(needAddAttendanc, item)
  1593. }
  1594. }
  1595. if isPlayback && mapActivityId[strconv.Itoa(activityDetail.ActivityId)] == "" {
  1596. activityIdsLongTime += strconv.Itoa(activityDetail.ActivityId) + ","
  1597. }
  1598. mobileStr = strings.TrimRight(mobileStr, ",")
  1599. if mobileStr == "" {
  1600. mobileStr = "1"
  1601. }
  1602. listUser, err := models.GetWxUserOutboundMobile(mobileStr)
  1603. if err != nil {
  1604. fmt.Println("GetWxUserOutboundMobile Err:", err.Error())
  1605. return err
  1606. }
  1607. for k, v := range needAddAttendanc {
  1608. for _, v2 := range listUser {
  1609. if v2.OutboundMobile == v.Mobile || v2.Mobile == v.Mobile {
  1610. if needAddAttendanc[k].CompanyId == 0 {
  1611. needAddAttendanc[k].CompanyId = v2.CompanyId
  1612. needAddAttendanc[k].SellerName = v2.SellerName
  1613. needAddAttendanc[k].CompanyName = v2.CompanyName
  1614. needAddAttendanc[k].IsMeetingStr = 1
  1615. }
  1616. }
  1617. }
  1618. }
  1619. //fmt.Println(mobileStr)
  1620. //参会记录
  1621. err = models.AddAttendancDetail(needAddAttendanc, activityDetail.ActivityId, mobileStr)
  1622. if err != nil {
  1623. fmt.Println("AddAttendancDetail Err:", err.Error())
  1624. return err
  1625. }
  1626. ////处理是否限制报名
  1627. err = AddCygxActivityRestrictSignupByAdmin(activityDetail.ActivityId)
  1628. if err != nil {
  1629. fmt.Println("AddCygxActivityRestrictSignupByAdmin Err:", err.Error())
  1630. return err
  1631. }
  1632. go ActivityUserLabelLogAdd(activityDetail.ActivityId, mobileArr)
  1633. AddctivitySignupDetailByJmcj(needAddAttendanc, activityDetail.ActivityId)
  1634. }
  1635. }
  1636. }
  1637. }
  1638. //获取需要处理的活动
  1639. listActivity, err := models.GetActivityListByDateTime(startDate, endDate, activityIds, detail.ConfigValue)
  1640. if err != nil {
  1641. fmt.Println("GetTacticsList Err:", err.Error())
  1642. return err
  1643. }
  1644. //通过本地去找进门财经的数据
  1645. for _, vAct := range listActivity {
  1646. doTime := utils.TimeRemoveHms2(vAct.ActivityTime)
  1647. findStartDate := doTime + " 00:00:00"
  1648. findEndDate := doTime + " 23:59:59"
  1649. nameSlice := strings.Split(vAct.ActivityName, "】")
  1650. //对于手动匹配到的活动数据也要更新
  1651. var activityName string
  1652. if len(nameSlice) > 1 {
  1653. if vAct.JmcjRoadshowTitle != "" {
  1654. activityName = vAct.JmcjRoadshowTitle
  1655. } else {
  1656. activityName = nameSlice[len(nameSlice)-1]
  1657. }
  1658. //activityName = nameSlice[len(nameSlice)-1]
  1659. if activityName != "" {
  1660. list, err := models.GetRoadshowDataList(activityName, findStartDate, findEndDate)
  1661. if err != nil {
  1662. fmt.Println("GetTacticsList Err:", err.Error())
  1663. return err
  1664. }
  1665. var isPlayback bool // 是否包含回放
  1666. needAddAttendanc := make([]*models.CygxActivityAttendanceDetail, 0)
  1667. var mobileStr string
  1668. var mobileArr []string
  1669. if len(list) > 0 {
  1670. fmt.Println("原来的1", vAct.ActivityName)
  1671. fmt.Println("处理的2", activityName)
  1672. for _, v := range list {
  1673. if v.UserPhone != "" {
  1674. item := new(models.CygxActivityAttendanceDetail)
  1675. item.ActivityId = vAct.ActivityId
  1676. item.RealName = v.UserName
  1677. item.Mobile = v.UserPhone
  1678. item.CompanyName = v.Company
  1679. //item.SellerName = sellerName
  1680. item.FirstMeetingTime = v.FirstWatchTime
  1681. item.LastMeetingTime = v.LastWatchTime
  1682. item.Duration = utils.GetAttendanceDetailSeconds(v.JoinTime)
  1683. if v.JoinType == 1 {
  1684. item.MeetingTypeStr = "网络"
  1685. } else {
  1686. item.MeetingTypeStr = "电话"
  1687. }
  1688. item.MeetingAuthentication = v.AuthInfo
  1689. if v.DataType == 1 {
  1690. item.MeetingStatusStr = "直播"
  1691. } else {
  1692. item.MeetingStatusStr = "回放"
  1693. isPlayback = true
  1694. }
  1695. item.Position = v.Occupation
  1696. item.UseridEntity = v.UseridEntity
  1697. item.ActivityTime = vAct.ActivityTime
  1698. item.CrmCompanyMapStatusId = v.CrmCompanyMapStatusId
  1699. item.CreateTime = time.Now()
  1700. mobileStr += "'" + v.UserPhone + "'" + ","
  1701. mobileArr = append(mobileArr, v.UserPhone)
  1702. needAddAttendanc = append(needAddAttendanc, item)
  1703. }
  1704. }
  1705. if isPlayback && mapActivityId[strconv.Itoa(vAct.ActivityId)] == "" {
  1706. activityIdsLongTime += strconv.Itoa(vAct.ActivityId) + ","
  1707. }
  1708. mobileStr = strings.TrimRight(mobileStr, ",")
  1709. if mobileStr == "" {
  1710. mobileStr = "1"
  1711. }
  1712. listUser, err := models.GetWxUserOutboundMobile(mobileStr)
  1713. if err != nil {
  1714. fmt.Println("GetWxUserOutboundMobile Err:", err.Error())
  1715. return err
  1716. }
  1717. for k, v := range needAddAttendanc {
  1718. for _, v2 := range listUser {
  1719. if v2.OutboundMobile == v.Mobile || v2.Mobile == v.Mobile {
  1720. if needAddAttendanc[k].CompanyId == 0 {
  1721. needAddAttendanc[k].CompanyId = v2.CompanyId
  1722. needAddAttendanc[k].SellerName = v2.SellerName
  1723. needAddAttendanc[k].CompanyName = v2.CompanyName
  1724. needAddAttendanc[k].IsMeetingStr = 1
  1725. }
  1726. }
  1727. }
  1728. }
  1729. ////参会记录
  1730. err = models.AddAttendancDetail(needAddAttendanc, vAct.ActivityId, mobileStr)
  1731. if err != nil {
  1732. fmt.Println("AddAttendancDetail Err:", err.Error())
  1733. return err
  1734. }
  1735. ////处理是否限制报名
  1736. err = AddCygxActivityRestrictSignupByAdmin(vAct.ActivityId)
  1737. if err != nil {
  1738. fmt.Println("AddCygxActivityRestrictSignupByAdmin Err:", err.Error())
  1739. return err
  1740. }
  1741. activityIds += strconv.Itoa(vAct.ActivityId) + ","
  1742. go ActivityUserLabelLogAdd(vAct.ActivityId, mobileArr)
  1743. AddctivitySignupDetailByJmcj(needAddAttendanc, vAct.ActivityId)
  1744. }
  1745. }
  1746. }
  1747. }
  1748. if activityIdsLongTime != "" {
  1749. activityIdsLongTime = strings.TrimRight(activityIdsLongTime, ",")
  1750. activityIdsLongTime = detail.ConfigValue + "," + activityIdsLongTime
  1751. go models.UpdateConfigByCode(activityIdsLongTime, configCode)
  1752. }
  1753. activityIds = strings.TrimRight(activityIds, ",")
  1754. if activityIds != "" {
  1755. detailList, err := models.GetActivityAttendanceDetailList(activityIds)
  1756. if err != nil {
  1757. fmt.Println("GetActivityAttendanceDetailList Err:", err.Error())
  1758. return err
  1759. }
  1760. //添加报名日志 (下载使用)
  1761. err = models.AddCygxActivityMeetDetailLogOnlineByList(detailList, activityIds)
  1762. if err != nil {
  1763. fmt.Println("AddCygxActivityMeetDetailLogOnline Err:", err.Error())
  1764. return err
  1765. }
  1766. }
  1767. fmt.Println("结束路演同步")
  1768. return
  1769. }
  1770. // 判断是否加入黑名单
  1771. func AddCygxActivityRestrictSignupByAdmin111(activityId int) (err error) {
  1772. defer func() {
  1773. if err != nil {
  1774. fmt.Println(err)
  1775. go utils.SendAlarmMsg("判断是否加入黑名单记录失败"+err.Error(), 2)
  1776. }
  1777. }()
  1778. total, err := models.GetActivitySignupNomeetingCount(activityId)
  1779. if err != nil {
  1780. err = errors.New("GetActivitySignupNomeetingCount" + err.Error())
  1781. return err
  1782. }
  1783. if total == 0 {
  1784. return err
  1785. }
  1786. mobileList, _ := models.GetUserMeetingMobile(activityId)
  1787. if len(mobileList) >= 0 {
  1788. for _, v := range mobileList {
  1789. totalRestrict, err := models.GetRestrictSignupCountByUid(v.UserId)
  1790. if err != nil {
  1791. err = errors.New("GetRestrictSignupCountByUid" + err.Error())
  1792. return err
  1793. }
  1794. totalNomeet, err := models.GetActivitySignupNomeetingCountByUid(v.UserId)
  1795. if err != nil {
  1796. err = errors.New("GetActivitySignupNomeetingCountByUid" + err.Error())
  1797. return err
  1798. }
  1799. if totalRestrict > 0 && totalNomeet < 3 {
  1800. err = models.DeleteCygxActivityRestrictSignup(v.UserId)
  1801. if err != nil {
  1802. err = errors.New("DeleteCygxActivityRestrictSignup" + err.Error())
  1803. return err
  1804. }
  1805. }
  1806. }
  1807. }
  1808. list, err := models.GetActivitySignupNomeetingCountList(activityId)
  1809. if err != nil {
  1810. err = errors.New("GetActivitySignupNomeetingCountList" + err.Error())
  1811. return err
  1812. }
  1813. var items []*models.CygxActivitySignupBreak
  1814. for _, v := range list {
  1815. totalRestrict, err := models.GetRestrictSignupCountByUid(v.UserId)
  1816. if err != nil {
  1817. err = errors.New("GetRestrictSignupCountByUid" + err.Error())
  1818. return err
  1819. }
  1820. totalNomeet, err := models.GetActivitySignupNomeetingCountByUid(v.UserId)
  1821. if err != nil {
  1822. err = errors.New("GetActivitySignupNomeetingCountByUid" + err.Error())
  1823. return err
  1824. }
  1825. if totalNomeet >= 3 {
  1826. if totalRestrict == 0 {
  1827. infoUser, err := models.GetUserAndCompanyNameList(v.UserId)
  1828. //if err != nil && err.Error() != utils.ErrNoRow() {
  1829. if err != nil {
  1830. err = errors.New("GetUserAndCompanyNameList" + err.Error())
  1831. return err
  1832. }
  1833. if infoUser != nil {
  1834. item := new(models.CygxActivityRestrictSignup)
  1835. item.UserId = infoUser.UserId
  1836. item.CreateTime = time.Now()
  1837. item.Mobile = infoUser.Mobile
  1838. item.Email = infoUser.Email
  1839. item.CompanyId = infoUser.CompanyId
  1840. item.CompanyName = infoUser.CompanyName
  1841. item.IsRestrict = 1
  1842. err = models.AddCygxActivityRestrictSignup(item)
  1843. if err != nil {
  1844. err = errors.New("AddCygxActivityRestrictSignup" + err.Error())
  1845. return err
  1846. }
  1847. }
  1848. }
  1849. }
  1850. //处理未到会
  1851. item := new(models.CygxActivitySignupBreak)
  1852. item.UserId = v.UserId
  1853. item.ActivityId = v.ActivityId
  1854. item.CreateTime = time.Now()
  1855. item.Mobile = v.Mobile
  1856. item.Email = v.Email
  1857. item.CompanyId = v.CompanyId
  1858. item.CompanyName = v.CompanyName
  1859. item.RealName = v.RealName
  1860. item.SellerName = v.SellerName
  1861. items = append(items, item)
  1862. }
  1863. err = models.DeleteCygxActivitySignupBreakById(activityId)
  1864. if err != nil {
  1865. err = errors.New("DeleteCygxActivitySignupBreakById" + err.Error())
  1866. return
  1867. }
  1868. _, err = models.AddCygxActivitySignupBreakList(items)
  1869. if err != nil {
  1870. err = errors.New("AddCygxActivitySignupBreakList, Err: " + err.Error())
  1871. return
  1872. }
  1873. return
  1874. }
  1875. // 查研观向处理活动用户限制报名
  1876. func AddCygxActivityRestrictSignupByAdmin(activityId int) (err error) {
  1877. defer func() {
  1878. if err != nil {
  1879. fmt.Println("err:", err)
  1880. go utils.SendAlarmMsg("查研观向处理活动用户限制报名失败,Err:"+err.Error()+"activityId"+strconv.Itoa(activityId), 3)
  1881. }
  1882. }()
  1883. activityInfo, e := models.GetAddActivityInfoById(activityId)
  1884. if e != nil {
  1885. err = errors.New("GetAddActivityInfoById" + e.Error())
  1886. return
  1887. }
  1888. if activityInfo == nil {
  1889. return
  1890. }
  1891. //不限制报名的不做爽约限制处理
  1892. //if activityInfo.IsLimitPeople > 0 {
  1893. //total, err := cygx.GetActivitySignupNomeetingCount(activityId)
  1894. if err != nil {
  1895. return
  1896. }
  1897. mobileList, _ := models.GetUserMeetingMobile(activityId)
  1898. var userIdArr []int
  1899. if len(mobileList) > 0 {
  1900. for _, v := range mobileList {
  1901. userIdArr = append(userIdArr, v.UserId)
  1902. }
  1903. lenuserIdArr := len(userIdArr)
  1904. var condition string
  1905. var pars []interface{}
  1906. condition = ` AND user_id IN (` + utils.GetOrmInReplace(lenuserIdArr) + `)`
  1907. pars = append(pars, userIdArr)
  1908. restrictSignupList, e := models.GetCygxActivityRestrictSignupList(condition, pars, 0, 9999)
  1909. if e != nil {
  1910. err = errors.New("GetCygxActivityRestrictSignupList" + e.Error())
  1911. return
  1912. }
  1913. //获取这些用户是否被加入到限制报名了
  1914. maptotalRestrict := make(map[int]bool)
  1915. for _, v := range restrictSignupList {
  1916. maptotalRestrict[v.UserId] = true
  1917. }
  1918. pars = make([]interface{}, 0)
  1919. condition = ` AND a.is_limit_people = 1 AND v.is_meeting = 0 AND v.do_fail_type = 0 AND v.user_id IN (` + utils.GetOrmInReplace(lenuserIdArr) + `)`
  1920. pars = append(pars, userIdArr)
  1921. listSignup, e := models.GetActivitySignupInnerActivityList(condition, pars)
  1922. if e != nil && e.Error() != utils.ErrNoRow() {
  1923. err = errors.New("GetActivitySignupInnerActivityList" + e.Error())
  1924. return
  1925. }
  1926. mapNomeet := make(map[int]int)
  1927. if len(listSignup) > 0 {
  1928. for _, v := range listSignup {
  1929. mapNomeet[v.UserId]++
  1930. }
  1931. }
  1932. var userIdDelArr []int
  1933. for _, v := range mobileList {
  1934. //如果加入了爽约限制但是爽约次数少于3条就删除爽约记录
  1935. if maptotalRestrict[v.UserId] && mapNomeet[v.UserId] < 3 {
  1936. userIdDelArr = append(userIdDelArr, v.UserId)
  1937. }
  1938. }
  1939. if len(userIdDelArr) > 0 {
  1940. e = models.DeleteCygxActivityRestrictSignupByUserIds(userIdDelArr)
  1941. if e != nil {
  1942. err = errors.New("DeleteCygxActivityRestrictSignupByUserIds" + e.Error())
  1943. return
  1944. }
  1945. }
  1946. }
  1947. //if total == 0 {
  1948. // return
  1949. //}
  1950. //}
  1951. list, e := models.GetActivitySignupNomeetingCountList(activityId)
  1952. if e != nil {
  1953. err = errors.New("GetActivitySignupNomeetingCountList" + e.Error())
  1954. return
  1955. }
  1956. var userIdSiginArr []int
  1957. var items []*models.CygxActivitySignupBreak
  1958. for _, v := range list {
  1959. userIdSiginArr = append(userIdSiginArr, v.UserId)
  1960. //添加爽约记录
  1961. item := new(models.CygxActivitySignupBreak)
  1962. item.UserId = v.UserId
  1963. item.ActivityId = v.ActivityId
  1964. item.CreateTime = time.Now()
  1965. item.Mobile = v.Mobile
  1966. item.Email = v.Email
  1967. item.CompanyId = v.CompanyId
  1968. item.CompanyName = v.CompanyName
  1969. item.RealName = v.RealName
  1970. item.SellerName = v.SellerName
  1971. items = append(items, item)
  1972. }
  1973. if len(list) == 0 {
  1974. return
  1975. }
  1976. var itemsRestrict []*models.CygxActivityRestrictSignup
  1977. maptotalRestrict := make(map[int]bool)
  1978. lenuserIdSiginArr := len(userIdSiginArr)
  1979. var condition string
  1980. var pars []interface{}
  1981. condition = ` AND user_id IN (` + utils.GetOrmInReplace(lenuserIdSiginArr) + `)`
  1982. pars = append(pars, userIdSiginArr)
  1983. restrictSignupList, e := models.GetCygxActivityRestrictSignupList(condition, pars, 0, 9999)
  1984. if e != nil {
  1985. err = errors.New("GetCygxActivityRestrictSignupList" + e.Error())
  1986. return
  1987. }
  1988. //获取这些用户是否被加入到限制报名了
  1989. for _, v := range restrictSignupList {
  1990. maptotalRestrict[v.UserId] = true
  1991. }
  1992. pars = make([]interface{}, 0)
  1993. condition = ` AND a.is_limit_people = 1 AND v.is_meeting = 0 AND v.do_fail_type = 0 AND user_id IN (` + utils.GetOrmInReplace(lenuserIdSiginArr) + `)`
  1994. pars = append(pars, userIdSiginArr)
  1995. listSignup, e := models.GetActivitySignupInnerActivityList(condition, pars)
  1996. if e != nil && e.Error() != utils.ErrNoRow() {
  1997. err = errors.New("GetActivitySignupInnerActivityList" + e.Error())
  1998. return
  1999. }
  2000. mapNomeet := make(map[int]int)
  2001. if len(listSignup) > 0 {
  2002. for _, v := range listSignup {
  2003. mapNomeet[v.UserId]++
  2004. }
  2005. }
  2006. for _, v := range mobileList {
  2007. //如果加入了爽约限制但是爽约次数少于3条就删除爽约记录
  2008. if !maptotalRestrict[v.UserId] && mapNomeet[v.UserId] >= 3 {
  2009. itemRestrict := new(models.CygxActivityRestrictSignup)
  2010. itemRestrict.UserId = v.UserId
  2011. itemRestrict.CreateTime = time.Now()
  2012. itemRestrict.Mobile = v.Mobile
  2013. itemRestrict.Email = v.Email
  2014. itemRestrict.CompanyId = v.CompanyId
  2015. itemRestrict.CompanyName = v.CompanyName
  2016. itemRestrict.IsRestrict = 1
  2017. itemsRestrict = append(itemsRestrict, itemRestrict)
  2018. }
  2019. }
  2020. err = models.DeleteCygxActivitySignupBreakById(activityId)
  2021. if err != nil {
  2022. err = errors.New("DeleteCygxActivitySignupBreakById" + err.Error())
  2023. return
  2024. }
  2025. //添加爽约记录
  2026. if len(items) > 0 {
  2027. _, e = models.AddCygxActivitySignupBreakList(items)
  2028. if e != nil {
  2029. err = errors.New("AddCygxActivitySignupBreakList, Err: " + e.Error())
  2030. return
  2031. }
  2032. }
  2033. //添加报名限制
  2034. if len(itemsRestrict) > 0 {
  2035. _, e = models.AddCygxActivityRestrictSignupList(itemsRestrict)
  2036. if e != nil {
  2037. err = errors.New("AddCygxActivityRestrictSignupList, Err: " + e.Error())
  2038. return
  2039. }
  2040. }
  2041. return
  2042. }
  2043. // 判断预约纪要按钮是否显示
  2044. func IsShowAppointment(activityTypeId int, chartPermissionName string) (isShowAppointment bool) {
  2045. if activityTypeId == 1 || activityTypeId == 2 || activityTypeId == 3 || activityTypeId == 4 {
  2046. isShowAppointment = true
  2047. }
  2048. if activityTypeId == 5 && chartPermissionName == "医药" {
  2049. isShowAppointment = true
  2050. }
  2051. return
  2052. }
  2053. // 判断预约纪要按钮是否显示
  2054. func IsShowAppointmentByactivityInfo(item *models.ActivityDetail, chartPermissionName string) (isShowAppointment bool) {
  2055. activityTypeId := item.ActivityTypeId
  2056. if activityTypeId == 1 || activityTypeId == 3 || activityTypeId == 4 {
  2057. isShowAppointment = true
  2058. }
  2059. if activityTypeId == 5 && chartPermissionName == "医药" {
  2060. isShowAppointment = true
  2061. }
  2062. if activityTypeId == 2 && item.IsLimitPeople == 0 {
  2063. isShowAppointment = true
  2064. }
  2065. return
  2066. }
  2067. // 用户报告操作行为,模板消息推送 (先放在活动模块下,避免代码冲突)
  2068. func ArticleUserRemind(user *models.WxUserItem, articleDetail *models.ArticleDetail, source int) (err error) {
  2069. defer func() {
  2070. if err != nil {
  2071. go utils.SendAlarmMsg(" 用户报告操作行为,模板消息推送失败"+fmt.Sprint("UserId:", user.UserId, "ArticleId:", articleDetail.ArticleId), 2)
  2072. }
  2073. }()
  2074. countUser, err := models.GetUserRemind(user.UserId)
  2075. if err != nil {
  2076. return err
  2077. }
  2078. if countUser == 0 {
  2079. return err
  2080. }
  2081. var sourceMsg string
  2082. if source == 1 {
  2083. sourceMsg = "阅读报告"
  2084. } else {
  2085. sourceMsg = "收藏报告"
  2086. }
  2087. //获取销售手机号
  2088. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  2089. if err != nil && err.Error() != utils.ErrNoRow() {
  2090. return err
  2091. }
  2092. if sellerItemQy != nil {
  2093. openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  2094. if err != nil {
  2095. fmt.Println(err)
  2096. return err
  2097. }
  2098. var keyword1 string
  2099. var keyword2 string
  2100. keyword1 = articleDetail.Title
  2101. keyword2 = fmt.Sprint("互动:", sourceMsg, ",", user.RealName, "--", user.CompanyName)
  2102. SendWxMsgWithArticleUserRemind(keyword1, keyword2, openIdList, articleDetail.ArticleId)
  2103. }
  2104. return
  2105. }
  2106. // 用户活动操作行为,模板消息推送
  2107. func ActivityUserRemind(user *models.WxUserItem, activityDetail *models.ActivityDetail, source int) (err error) {
  2108. defer func() {
  2109. if err != nil {
  2110. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "ActivityUserRemind ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  2111. }
  2112. }()
  2113. //获取销售手机号
  2114. countUser, e := models.GetUserRemind(user.UserId)
  2115. if e != nil {
  2116. err = errors.New("GetUserRemind, Err: " + e.Error())
  2117. return
  2118. }
  2119. //获取销售手机号
  2120. sellerItemQy, e := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  2121. if e != nil && e.Error() != utils.ErrNoRow() {
  2122. err = errors.New("GetSellerByCompanyIdCheckFicc, Err: " + e.Error())
  2123. return
  2124. }
  2125. if sellerItemQy == nil {
  2126. err = nil
  2127. return
  2128. }
  2129. //某销售下的所有客户活动报名/预约外呼时,模板消息提醒该销售(可设置销售范围,随时增减销售)
  2130. conf, e := models.GetConfigByCode("tpl_msg_seller_mobile")
  2131. if e != nil {
  2132. err = errors.New("GetConfigByCode, Err: " + e.Error())
  2133. return
  2134. }
  2135. //如果用户没有设置消息提醒,而且销售的手机号也没有添加到配置中,那么就不推送模版消息
  2136. if countUser == 0 && !strings.Contains(conf.ConfigValue, sellerItemQy.Mobile) {
  2137. err = nil
  2138. return
  2139. }
  2140. var sourceMsg string
  2141. if source == 1 {
  2142. sourceMsg = "预约外呼"
  2143. } else if source == 2 {
  2144. sourceMsg = "设置会议提醒"
  2145. } else if source == 3 {
  2146. sourceMsg = "预约纪要"
  2147. } else if source == 4 {
  2148. sourceMsg = "活动报名"
  2149. }
  2150. openIdList, e := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  2151. if e != nil {
  2152. err = errors.New("GetUserRecordListByMobile, Err: " + e.Error())
  2153. return err
  2154. }
  2155. var keyword1 string
  2156. var keyword2 string
  2157. keyword1 = activityDetail.ActivityName
  2158. keyword2 = fmt.Sprint("互动:", sourceMsg, ",", user.RealName, "--", user.CompanyName)
  2159. SendWxMsgWithActivityUserRemind(keyword1, keyword2, openIdList, activityDetail.ActivityId)
  2160. return
  2161. }
  2162. // 用户专项调研操作行为,模板消息推送
  2163. func SpecialActivityUserRemind(user *models.WxUserItem, activityDetail *models.CygxActivitySpecialDetail, source int) (err error) {
  2164. defer func() {
  2165. if err != nil {
  2166. go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
  2167. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  2168. }
  2169. }()
  2170. countUser, err := models.GetUserRemind(user.UserId)
  2171. if err != nil {
  2172. return err
  2173. }
  2174. if countUser == 0 {
  2175. return err
  2176. }
  2177. var sourceMsg string
  2178. if source == 1 {
  2179. sourceMsg = "预报名调研"
  2180. }
  2181. //获取销售手机号
  2182. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  2183. if err != nil && err.Error() != utils.ErrNoRow() {
  2184. return err
  2185. }
  2186. if sellerItemQy != nil {
  2187. openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  2188. if err != nil {
  2189. fmt.Println(err)
  2190. return err
  2191. }
  2192. var keyword1 string
  2193. var keyword2 string
  2194. keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
  2195. keyword2 = activityDetail.ResearchTheme
  2196. SendWxMsgWithSpecialActivityUserRemind(keyword1, keyword2, openIdList, activityDetail.ActivityId)
  2197. }
  2198. return
  2199. }
  2200. //func init() {
  2201. // DoActivityOnenIdWxTemplateMsg()
  2202. //}
  2203. // 周日下午四点半推送全部活动
  2204. func DoActivityOnenIdWxTemplateMsg(cont context.Context) (err error) {
  2205. var msg string
  2206. defer func() {
  2207. if err != nil {
  2208. go utils.SendAlarmMsg("周日下午四点半推送全部活动失败,DoActivityOnenIdWxTemplateMsg ErrMsg:"+err.Error(), 2)
  2209. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "DoActivityOnenIdWxTemplateMsg ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  2210. fmt.Println(err)
  2211. }
  2212. if msg != "" {
  2213. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  2214. }
  2215. }()
  2216. var condition string
  2217. var pars []interface{}
  2218. openidPowerListMobile, err := models.GetCygxUserRecordPower(condition, pars)
  2219. if err != nil {
  2220. return err
  2221. }
  2222. var mobileArr []string
  2223. for _, v := range openidPowerListMobile {
  2224. mobileArr = append(mobileArr, v.Mobile)
  2225. }
  2226. openidPowerList, err := models.GetWxOpenIdByMobileSliceList(mobileArr)
  2227. if err != nil {
  2228. return err
  2229. }
  2230. first := "近期所有行业活动预告,欢迎参与"
  2231. keyword1 := "下周活动预告"
  2232. keyword2 := "已发布"
  2233. keyword3 := ""
  2234. keyword4 := "点击查看下周活动列表"
  2235. SendActivityOnenIdWxTemplateMsg(first, keyword1, keyword2, keyword3, keyword4, openidPowerList)
  2236. return
  2237. }
  2238. func ActivityButtonShow(item *models.ActivityDetail) (activityDetail *models.ActivityDetail) {
  2239. if item.ChartPermissionId == utils.CHART_PERMISSION_ID_YANXUAN {
  2240. item.IsResearch = true
  2241. }
  2242. activityDetail = item
  2243. //IsShowAppointment bool `description:"是否展示预约纪要"`
  2244. //IsShowOutboundCall bool `description:"是否展示预约外呼"`
  2245. //IsShowMeetingReminder bool `description:"是否展示会议提醒"`
  2246. //IsShowHelpSsk bool `description:"是否展示帮我带问"`
  2247. //IsShowSignup bool `description:"是否展示我要报名"`
  2248. activityPointsByUserAllMap := GetActivityPointsByUserAllMap() // 获取对用户进行研选扣点的活动
  2249. activityDetail.IsResearchPoints = activityPointsByUserAllMap[activityDetail.ActivityId]
  2250. if activityDetail.SiginupDeadline == utils.FormatDateTimeInit { //报名截止时间处理
  2251. activityDetail.SiginupDeadline = ""
  2252. }
  2253. //如果报名截止时间不规范,或者是非研选扣点活动就把截止时间设置为空
  2254. if activityDetail.CancelDeadline == utils.FormatDateTimeInit || !activityDetail.IsResearchPoints {
  2255. activityDetail.CancelDeadline = ""
  2256. }
  2257. activityTimeText := activityDetail.ActivityTimeText
  2258. activityTimeText = strings.Replace(activityTimeText, "(", "(", -1)
  2259. activityTimeText = strings.Replace(activityTimeText, ")", ")", -1)
  2260. activityDetail.ActivityTimeText = activityTimeText
  2261. if activityDetail.SourceType != 2 {
  2262. activityDetail.SourceType = 1
  2263. }
  2264. activityDetail.IsShowAppointment = false
  2265. //易董的操作按钮都隐藏
  2266. if activityDetail.YidongActivityId != "" {
  2267. activityDetail.SourceType = 1
  2268. activityDetail.IsShowSignup = false
  2269. activityDetail.IsShowDetails = true
  2270. activityDetail.IsExternalLabel = true
  2271. activityDetail.IsResearch = false
  2272. activityDetail.IsResearchSpecial = false
  2273. return
  2274. }
  2275. //专家电话会 1
  2276. if activityDetail.ActivityTypeId == 1 && activityDetail.IsLimitPeople == 0 && (activityDetail.ActiveState == "1" || activityDetail.ActiveState == "2") {
  2277. activityDetail.IsShowHelpSsk = true
  2278. }
  2279. //新的是否展示规则
  2280. if activityDetail.IsCanAppointmentMinutes == 1 {
  2281. activityDetail.IsShowAppointment = true
  2282. } else {
  2283. activityDetail.IsShowAppointment = false
  2284. }
  2285. if activityDetail.ActiveState == "1" {
  2286. //专家电话会 1
  2287. //专家电话会限制人数的展示我要报名,不限制的展示预约外外呼
  2288. if activityDetail.ActivityTypeId == 1 {
  2289. //articleDetail.IsShowOutboundCall = true
  2290. if activityDetail.LimitPeopleNum == 0 {
  2291. activityDetail.IsShowOutboundCall = true
  2292. //articleDetail.IsShowHelpSsk = true
  2293. } else {
  2294. activityDetail.IsShowSignup = true
  2295. }
  2296. activityDetail.IsShowMeetingReminder = true
  2297. activityDetail.IsShowHelpSsk = true
  2298. }
  2299. //分析师电话会 2
  2300. if activityDetail.ActivityTypeId == 2 {
  2301. if activityDetail.LimitPeopleNum == 0 {
  2302. activityDetail.IsShowOutboundCall = true
  2303. //articleDetail.IsShowHelpSsk = true
  2304. } else {
  2305. activityDetail.IsShowSignup = true
  2306. }
  2307. activityDetail.IsShowMeetingReminder = true
  2308. }
  2309. //公司调研电话会 3
  2310. if activityDetail.ActivityTypeId == 3 {
  2311. if activityDetail.IsResearchPoints || activityDetail.LimitPeopleNum > 0 {
  2312. activityDetail.IsShowSignup = true
  2313. } else {
  2314. activityDetail.IsShowMeetingReminder = true
  2315. activityDetail.IsShowOutboundCall = true
  2316. }
  2317. }
  2318. //公司线下调研 4
  2319. if activityDetail.ActivityTypeId == 4 {
  2320. activityDetail.IsShowSignup = true
  2321. }
  2322. //专家线下沙龙 5
  2323. if activityDetail.ActivityTypeId == 5 {
  2324. activityDetail.IsShowSignup = true
  2325. }
  2326. //分析师线下沙龙 6
  2327. if activityDetail.ActivityTypeId == 6 {
  2328. activityDetail.IsShowSignup = true
  2329. }
  2330. //分析师电话会(C类) 7
  2331. if activityDetail.ActivityTypeId == 7 {
  2332. activityDetail.IsShowSignup = true
  2333. activityDetail.IsShowMeetingReminder = true
  2334. activityDetail.ActivityTypeName = "分析师电话会"
  2335. }
  2336. //买方线下交流 8 // 查研观向 11.0
  2337. if activityDetail.ActivityTypeId == 8 {
  2338. activityDetail.IsShowSignup = true
  2339. }
  2340. }
  2341. //如果是易董创建的活动,展示我要报名,不展示预约外呼
  2342. if activityDetail.IsYidongConduct {
  2343. activityDetail.IsShowSignup = true
  2344. activityDetail.IsShowOutboundCall = false
  2345. }
  2346. return
  2347. }
  2348. func ActivityArrButtonShow(items []*models.ActivityDetail) (activityDetails []*models.ActivityDetail) {
  2349. activityPointsByUserAllMap := GetActivityPointsByUserAllMap() // 获取对用户进行研选扣点的活动
  2350. for _, activityDetail := range items {
  2351. if activityDetail.ChartPermissionId == utils.CHART_PERMISSION_ID_YANXUAN {
  2352. activityDetail.IsResearch = true
  2353. }
  2354. //勾选【研选扣点】且扣点对象为参会人的活动,需要有买方研选的正式权限
  2355. if strings.Contains(activityDetail.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) && activityPointsByUserAllMap[activityDetail.ActivityId] {
  2356. activityDetail.IsResearchSpecial = true
  2357. }
  2358. //IsShowAppointment bool `description:"是否展示预约纪要"`
  2359. //IsShowOutboundCall bool `description:"是否展示预约外呼"`
  2360. //IsShowMeetingReminder bool `description:"是否展示会议提醒"`
  2361. //IsShowHelpSsk bool `description:"是否展示帮我带问"`
  2362. //IsShowSignup bool `description:"是否展示我要报名"`
  2363. activityDetail.IsResearchPoints = activityPointsByUserAllMap[activityDetail.ActivityId]
  2364. if activityDetail.SiginupDeadline == utils.FormatDateTimeInit { //报名截止时间处理
  2365. activityDetail.SiginupDeadline = ""
  2366. }
  2367. //如果报名截止时间不规范,或者是非研选扣点活动就把截止时间设置为空
  2368. if activityDetail.CancelDeadline == utils.FormatDateTimeInit || !activityDetail.IsResearchPoints {
  2369. activityDetail.CancelDeadline = ""
  2370. }
  2371. activityTimeText := activityDetail.ActivityTimeText
  2372. activityTimeText = strings.Replace(activityTimeText, "(", "(", -1)
  2373. activityTimeText = strings.Replace(activityTimeText, ")", ")", -1)
  2374. activityDetail.ActivityTimeText = activityTimeText
  2375. if activityDetail.SourceType != 2 {
  2376. activityDetail.SourceType = 1
  2377. }
  2378. activityDetail.IsShowAppointment = false
  2379. //易董的操作按钮都隐藏
  2380. if activityDetail.YidongActivityId != "" {
  2381. activityDetail.SourceType = 1
  2382. activityDetail.IsShowSignup = false
  2383. activityDetail.IsShowDetails = true
  2384. } else {
  2385. //专家电话会 1
  2386. if activityDetail.ActivityTypeId == 1 && activityDetail.IsLimitPeople == 0 && (activityDetail.ActiveState == "1" || activityDetail.ActiveState == "2") {
  2387. activityDetail.IsShowHelpSsk = true
  2388. }
  2389. //新的是否展示规则
  2390. if activityDetail.IsCanAppointmentMinutes == 1 {
  2391. activityDetail.IsShowAppointment = true
  2392. } else {
  2393. activityDetail.IsShowAppointment = false
  2394. }
  2395. if activityDetail.ActiveState == "1" {
  2396. //专家电话会 1
  2397. //专家电话会限制人数的展示我要报名,不限制的展示预约外外呼
  2398. if activityDetail.ActivityTypeId == 1 {
  2399. //articleDetail.IsShowOutboundCall = true
  2400. if activityDetail.LimitPeopleNum == 0 {
  2401. activityDetail.IsShowOutboundCall = true
  2402. //articleDetail.IsShowHelpSsk = true
  2403. } else {
  2404. activityDetail.IsShowSignup = true
  2405. }
  2406. activityDetail.IsShowMeetingReminder = true
  2407. activityDetail.IsShowHelpSsk = true
  2408. }
  2409. //分析师电话会 2
  2410. if activityDetail.ActivityTypeId == 2 {
  2411. if activityDetail.LimitPeopleNum == 0 {
  2412. activityDetail.IsShowOutboundCall = true
  2413. //articleDetail.IsShowHelpSsk = true
  2414. } else {
  2415. activityDetail.IsShowSignup = true
  2416. }
  2417. activityDetail.IsShowMeetingReminder = true
  2418. }
  2419. //公司调研电话会 3
  2420. if activityDetail.ActivityTypeId == 3 {
  2421. if activityDetail.IsResearchPoints || activityDetail.LimitPeopleNum > 0 {
  2422. activityDetail.IsShowSignup = true
  2423. } else {
  2424. activityDetail.IsShowMeetingReminder = true
  2425. activityDetail.IsShowOutboundCall = true
  2426. }
  2427. }
  2428. //公司线下调研 4
  2429. if activityDetail.ActivityTypeId == 4 {
  2430. activityDetail.IsShowSignup = true
  2431. }
  2432. //专家线下沙龙 5
  2433. if activityDetail.ActivityTypeId == 5 {
  2434. activityDetail.IsShowSignup = true
  2435. }
  2436. //分析师线下沙龙 6
  2437. if activityDetail.ActivityTypeId == 6 {
  2438. activityDetail.IsShowSignup = true
  2439. }
  2440. //分析师电话会(C类) 7
  2441. if activityDetail.ActivityTypeId == 7 {
  2442. activityDetail.IsShowSignup = true
  2443. activityDetail.IsShowMeetingReminder = true
  2444. activityDetail.ActivityTypeName = "分析师电话会"
  2445. }
  2446. //买方线下交流 8 // 查研观向 11.0
  2447. if activityDetail.ActivityTypeId == 8 {
  2448. activityDetail.IsShowSignup = true
  2449. }
  2450. }
  2451. //如果是易董创建的活动,展示我要报名,不展示预约外呼
  2452. if activityDetail.IsYidongConduct {
  2453. activityDetail.IsShowSignup = true
  2454. activityDetail.IsShowOutboundCall = false
  2455. }
  2456. }
  2457. //如果是易董同步过来的,只展示外部资源标签
  2458. if activityDetail.YidongActivityId != "" {
  2459. activityDetail.IsExternalLabel = true
  2460. activityDetail.IsResearch = false
  2461. activityDetail.IsResearchSpecial = false
  2462. }
  2463. activityDetails = append(activityDetails, activityDetail)
  2464. }
  2465. return
  2466. }
  2467. // GetActivityNewLabelMap 获取活动【新】标签Map
  2468. func GetActivityNewLabelMap(activityIds []int) (labelMap map[int]bool, industryNewMap map[int]bool, err error) {
  2469. labelMap = make(map[int]bool, 0)
  2470. industryNewMap = make(map[int]bool, 0)
  2471. if len(activityIds) == 0 {
  2472. return
  2473. }
  2474. // 获取活动关联的产业
  2475. var groupCond string
  2476. var groupPars []interface{}
  2477. groupCond += ` AND a.activity_id IN (` + utils.GetOrmInReplace(len(activityIds)) + `) AND b.source = 1 `
  2478. groupPars = append(groupPars, activityIds)
  2479. groups, e := models.GetActivityIndustryRelationList(groupCond, groupPars)
  2480. if e != nil {
  2481. err = errors.New("获取活动产业关联列表失败, Err: " + e.Error())
  2482. return
  2483. }
  2484. activityIndustryMap := make(map[int][]int, 0)
  2485. industryIds := make([]int, 0)
  2486. for i := range groups {
  2487. industryIds = append(industryIds, groups[i].IndustrialManagementId)
  2488. activityIndustryMap[groups[i].ActivityId] = append(activityIndustryMap[groups[i].ActivityId], groups[i].IndustrialManagementId)
  2489. }
  2490. // 获取新产业Map
  2491. industryLabelMap, e := GetIndustryNewLabelMap(industryIds)
  2492. if e != nil {
  2493. err = errors.New("获取产业新标签Map失败, Err: " + e.Error())
  2494. return
  2495. }
  2496. // 判断活动是否为新
  2497. for k := range industryLabelMap {
  2498. for k2, v2 := range activityIndustryMap {
  2499. if labelMap[k2] {
  2500. continue
  2501. }
  2502. // 活动的产业ID中存在一个新产业即为新活动
  2503. if utils.InArrayByInt(v2, k) {
  2504. labelMap[k2] = true
  2505. }
  2506. }
  2507. }
  2508. ////产业关联的弘则报告发布日期在三个月以内的活动、产业显示 NEW标签
  2509. //articNewLabel, e := GetArticNewLabelWhithActivity3Month()
  2510. //if e != nil {
  2511. // err = errors.New("获取产业新标签Map失败, Err: " + e.Error())
  2512. // return
  2513. //}
  2514. //for k := range articNewLabel {
  2515. // labelMap[k] = true
  2516. //}
  2517. return
  2518. }
  2519. // GetActivityVoiceResp 处理活动音频回放
  2520. func GetActivityVoiceResp(mapActivityId []int) (mapItem map[int]*models.CygxActivityVoiceReq, err error) {
  2521. activityVoiceList, err := models.GetCygxActivityVoiceReqList(mapActivityId)
  2522. if err != nil && err.Error() != utils.ErrNoRow() {
  2523. return
  2524. }
  2525. mapActivityVoice := make(map[int]*models.CygxActivityVoiceReq)
  2526. if len(activityVoiceList) > 0 {
  2527. for _, v := range activityVoiceList {
  2528. mapActivityVoice[v.ActivityId] = v
  2529. }
  2530. }
  2531. mapItem = mapActivityVoice
  2532. return
  2533. }
  2534. // AddActivitykeyWordSearch 添加活动搜索记录
  2535. func AddActivitykeyWordSearch(keyWordSearch string, user *models.WxUserItem) {
  2536. if keyWordSearch != "" {
  2537. keyWordItem := new(models.CygxUserSearchKeyWord)
  2538. keyWordItem.UserId = user.UserId
  2539. keyWordItem.KeyWord = keyWordSearch
  2540. keyWordItem.PageType = "ActivitSearch"
  2541. keyWordItem.CreateTime = time.Now()
  2542. go models.AddUserSearchKeyWord(keyWordItem)
  2543. }
  2544. }
  2545. // GetActivityVideoResp 处理活动视频频回放
  2546. func GetActivityVideoResp(mapActivityId []int) (mapItem map[int]*models.CygxActivityVideoListResp, err error) {
  2547. var condition string
  2548. var ativityVIdstr string
  2549. for _, v := range mapActivityId {
  2550. ativityVIdstr += strconv.Itoa(v) + ","
  2551. }
  2552. if ativityVIdstr == "" {
  2553. return
  2554. }
  2555. ativityVIdstr = strings.TrimRight(ativityVIdstr, ",")
  2556. condition += ` AND art.activity_id IN (` + ativityVIdstr + `) `
  2557. var pars []interface{}
  2558. //endTime := time.Now().AddDate(0, 0, -30).Format("2006-01-02 15:04:05")
  2559. //condition += ` AND art.activity_time > ? `
  2560. //pars = append(pars, endTime)
  2561. videoList, e := models.GetActivityVideoListAll(condition, pars, 0, 1000)
  2562. if e != nil && e.Error() != utils.ErrNoRow() {
  2563. err = e
  2564. return
  2565. }
  2566. mapActivityVideo := make(map[int]*models.CygxActivityVideoListResp)
  2567. if len(videoList) > 0 {
  2568. for _, v := range videoList {
  2569. mapActivityVideo[v.ActivityId] = v
  2570. }
  2571. }
  2572. mapItem = mapActivityVideo
  2573. return
  2574. }
  2575. // 用户音视频回放操作操作行为,模板消息推送
  2576. func ActivityVideoUserRmind(user *models.WxUserItem, activityId, fileType int) (err error) {
  2577. defer func() {
  2578. if err != nil {
  2579. go utils.SendAlarmMsg("用户音视频回放操作操作行为,模板消息推送失败"+err.Error(), 2)
  2580. }
  2581. }()
  2582. countUser, err := models.GetUserRemind(user.UserId)
  2583. if err != nil {
  2584. return err
  2585. }
  2586. if countUser == 0 {
  2587. return err
  2588. }
  2589. var first string
  2590. var keyword1 string
  2591. var keyword2 string
  2592. var keyword3 string
  2593. var keyword4 string
  2594. var remark string
  2595. //获取销售手机号
  2596. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  2597. if err != nil && err.Error() != utils.ErrNoRow() {
  2598. return err
  2599. }
  2600. if sellerItemQy != nil {
  2601. openIdList, e := models.GetWxOpenIdByMobileList(sellerItemQy.Mobile)
  2602. if e != nil {
  2603. err = errors.New("GetSellerByAdminId, Err: " + e.Error())
  2604. return
  2605. }
  2606. //TripStatus int `description:"行程进行状态 1:预报名,2:确定行程"`
  2607. if fileType == 1 {
  2608. activityInfo, e := models.GetCygxActivityVideoByActivityId(activityId)
  2609. if e != nil {
  2610. err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
  2611. return
  2612. }
  2613. if activityInfo == nil {
  2614. return
  2615. }
  2616. keyword1 = activityInfo.VideoName
  2617. keyword2 = fmt.Sprint("互动:播放视频,", user.RealName, "--", user.CompanyName)
  2618. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:播放视频")
  2619. } else {
  2620. activityInfo, e := models.GetCygxActivityVoiceByActivityId(activityId)
  2621. if e != nil {
  2622. err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
  2623. return
  2624. }
  2625. if activityInfo == nil {
  2626. return
  2627. }
  2628. keyword1 = activityInfo.VoiceName
  2629. keyword2 = fmt.Sprint("互动:播放音频,", user.RealName, "--", user.CompanyName)
  2630. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:播放音频")
  2631. }
  2632. //keyword2 = "__"
  2633. //remark = "点击查看活动详情"
  2634. openIdArr := make([]string, 0)
  2635. for _, v := range openIdList {
  2636. openIdArr = append(openIdArr, v.OpenId)
  2637. }
  2638. redirectUrl := utils.WX_MSG_PATH_ACTIVITY_SPECIAL_DETAIL + strconv.Itoa(activityId)
  2639. sendInfo := new(SendWxTemplate)
  2640. sendInfo.First = first
  2641. sendInfo.Keyword1 = keyword1
  2642. sendInfo.Keyword2 = keyword2
  2643. sendInfo.Keyword3 = keyword3
  2644. sendInfo.Keyword4 = keyword4
  2645. sendInfo.Remark = remark
  2646. sendInfo.TemplateId = utils.WxMsgTemplateIdArticleUserRemind
  2647. sendInfo.RedirectUrl = redirectUrl
  2648. sendInfo.RedirectTarget = 3
  2649. sendInfo.Resource = strconv.Itoa(activityId)
  2650. sendInfo.SendType = utils.TEMPLATE_MSG_CYGX_ARTICLE_ADD
  2651. sendInfo.OpenIdArr = openIdArr
  2652. err = PublicSendTemplateMsg(sendInfo)
  2653. if err != nil {
  2654. return
  2655. }
  2656. }
  2657. return
  2658. }
  2659. // 解析活动填写的报告链接
  2660. func GetActivityReportLinkToArticleList(item *models.ActivityDetail) (items []*models.ActivityArticleResp, err error) {
  2661. reportLink := item.ReportLink
  2662. //处理活动的
  2663. var articleIds []int
  2664. var articleList []string
  2665. if strings.Contains(reportLink, ";") {
  2666. articleList = strings.Split(reportLink, ";")
  2667. } else {
  2668. articleList = strings.Split(reportLink, ";")
  2669. }
  2670. for _, v := range articleList {
  2671. linkList := strings.Split(v, "/")
  2672. if linkList[len(linkList)-1] != "" {
  2673. linkArticleId, _ := strconv.Atoi(linkList[len(linkList)-1])
  2674. articleIds = append(articleIds, linkArticleId)
  2675. }
  2676. }
  2677. lenarticleIds := len(articleIds)
  2678. if lenarticleIds == 0 {
  2679. return
  2680. }
  2681. var condition string
  2682. var pars []interface{}
  2683. pars = make([]interface{}, 0)
  2684. condition = ` AND a.article_id IN (` + utils.GetOrmInReplace(lenarticleIds) + `)`
  2685. pars = append(pars, articleIds)
  2686. listArticle, e := models.GetHomeList(condition, pars, 0, len(articleIds))
  2687. if e != nil {
  2688. err = errors.New("GetResourceDataList, Err: " + e.Error())
  2689. return
  2690. }
  2691. if len(listArticle) > 0 {
  2692. for _, v := range listArticle {
  2693. artItem := new(models.ActivityArticleResp)
  2694. artItem.ArticleId = v.ArticleId
  2695. artItem.Title = v.Title
  2696. items = append(items, artItem)
  2697. }
  2698. }
  2699. return
  2700. }
  2701. // GetActivityCityResp 获取活动关联城市,当同一个活动标签对应多个城市的时候,展示最近举办的活动
  2702. func GetActivityCityResp() (mapItem map[string]string, err error) {
  2703. activityList, err := models.GetActivityLabelListCity()
  2704. if err != nil && err.Error() != utils.ErrNoRow() {
  2705. return
  2706. }
  2707. mapActivityCity := make(map[string]string)
  2708. if len(activityList) > 0 {
  2709. for _, v := range activityList {
  2710. if v.ActivityTypeId == utils.C_CLASS_ACTIVITY_TYPE_ID {
  2711. v.ActivityTypeId = utils.ANALYST_TELL_ACTIVITY_TYPE_ID
  2712. }
  2713. //如果城市民称长度大于2,那么就不显示
  2714. if utf8.RuneCountInString(v.City) != 2 || mapActivityCity[fmt.Sprint(v.Label, "{|}", v.ActivityTypeId)] != "" {
  2715. continue
  2716. }
  2717. mapActivityCity[fmt.Sprint(v.Label, "{|}", v.ActivityTypeId)] = v.City
  2718. }
  2719. }
  2720. mapItem = mapActivityCity
  2721. return
  2722. }
  2723. // UpdateIsSendYidongSignUp更改活动是否向易董推送报名名单的状态
  2724. func UpdateIsSendYidongSignUp(activityId int) (err error) {
  2725. defer func() {
  2726. if err != nil {
  2727. fmt.Println(err)
  2728. go utils.SendAlarmMsg("更改活动是否向易董推送报名名单的状态,失败,活动ID:"+strconv.Itoa(activityId)+err.Error(), 2)
  2729. }
  2730. }()
  2731. err = models.UPdateSendedYiDongSignUp(activityId)
  2732. return
  2733. }