activity.go 97 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814
  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. userId := user.UserId
  538. activityPointsByUserAllMap := GetActivityPointsByUserAllMap() // 获取对用户进行研选扣点的活动
  539. //勾选【研选扣点】且扣点对象为参会人的活动,需要有买方研选的正式权限
  540. if strings.Contains(activityInfo.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) && activityPointsByUserAllMap[activityInfo.ActivityId] {
  541. isResearchSpecial = true
  542. }
  543. //如果是弘则的用户或者宏观的权限不做校验
  544. //if (GetBelongingRai(user.Mobile) && user.CompanyId == utils.HZ_COMPANY_ID) || activityInfo.ChartPermissionName == utils.HONG_GUAN_NAME {
  545. if GetBelongingRai(user.Mobile) && user.CompanyId == utils.HZ_COMPANY_ID {
  546. havePower = true
  547. return
  548. }
  549. userType, permissionStr, permissionStrZhengShi, e := GetUserTypeZhengShi(user.CompanyId)
  550. if e != nil {
  551. err = errors.New("GetCompanyPermissionUpgrade, Err: " + e.Error())
  552. return
  553. }
  554. //判断用户是否开通了个人研选权限,如果有权限后缀拼接权限名称
  555. mfyxUserPermissionTotal := GetMfyxUserPermissionTotal(userId)
  556. if mfyxUserPermissionTotal == 1 {
  557. permissionStr += "," + utils.CHART_PERMISSION_NAME_MF_YANXUAN
  558. }
  559. //如果一个权限都没有就返回无权限
  560. if permissionStr == "" {
  561. return
  562. }
  563. //永续客户,无法查看研选权限,但是下面的联系人,单独开通研选后,也可以查看研选内容
  564. if userType == 1 && strings.Contains(activityInfo.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) && mfyxUserPermissionTotal == 0 {
  565. havePower = false
  566. return
  567. }
  568. permissionStr += "," + utils.HONG_GUAN_NAME // 添加一个宏观权限
  569. if permissionStrZhengShi == "" {
  570. permissionStrZhengShi = utils.HONG_GUAN_NAME // 添加一个宏观权限
  571. } else {
  572. permissionStrZhengShi += "," + utils.HONG_GUAN_NAME // 添加一个宏观权限
  573. }
  574. //如果是易董的活动,主、副权限有一个满足即可
  575. if activityInfo.YidongActivityId != "" {
  576. if strings.Contains(permissionStr, activityInfo.ChartPermissionName) || strings.Contains(permissionStr, activityInfo.ChartPermissionNameDeputy) {
  577. havePower = true
  578. return
  579. }
  580. }
  581. //如果权限不包含那么直接返回
  582. if !strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  583. return
  584. }
  585. //如果是 对用户的研选扣点的必须要有研选的正式权限
  586. if activityInfo.IsResearchPoints {
  587. //获取活动对用户要扣的点
  588. userPointsNum, e := models.GetCygxActivityPointsSetUserNum(activityInfo.ActivityId)
  589. if e != nil {
  590. err = errors.New("GetActivitySignupSuccessByUserCountNoHz, Err: " + e.Error())
  591. return
  592. }
  593. if userPointsNum > 0 {
  594. //if !strings.Contains(permissionStr, utils.CHART_PERMISSION_NAME_YANXUAN) {
  595. // //如果连试用权限都没有,那么久按照普通的研选样式展示
  596. // isResearchSpecial = false
  597. //}
  598. if !strings.Contains(permissionStrZhengShi, activityInfo.ChartPermissionName) {
  599. havePower = false
  600. return
  601. }
  602. }
  603. }
  604. //处理决策人可见权限
  605. if user.IsMaker == 0 && activityInfo.IsMakerShow == 1 {
  606. havePower = false
  607. return
  608. }
  609. // 处理本组可见权限
  610. if activityInfo.VisibleRange == 1 {
  611. adminIds, e := models.GetSelleridWhichGroup(user.CompanyId, 2)
  612. if e != nil {
  613. err = errors.New("GetSelleridWhichGroup, Err: " + e.Error())
  614. return
  615. }
  616. haveVisibleRange := false
  617. adminIdSlice := strings.Split(adminIds, ",")
  618. for _, v := range adminIdSlice {
  619. if v == strconv.Itoa(activityInfo.AdminId) {
  620. haveVisibleRange = true
  621. }
  622. }
  623. if !haveVisibleRange {
  624. havePower = false
  625. return
  626. }
  627. }
  628. if permissionStr == "" {
  629. return
  630. }
  631. //如果是易董的活动且属于研选类型,只要开通任何权限就可以查看详情
  632. if activityInfo.YidongActivityId != "" && permissionStr != "" && strings.Contains(activityInfo.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) {
  633. havePower = true
  634. return
  635. }
  636. //医药消费,科技,智造四大行业,验证主客观。如果主客观校验不通过,那么直接返回
  637. if strings.Contains(utils.YI_YAO_NAME+utils.XIAO_FEI_NAME+utils.KE_JI_NAME+utils.ZHI_ZAO_NAME, activityInfo.ChartPermissionName) {
  638. if activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 6 || activityInfo.ActivityTypeId == 7 {
  639. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(主观)") {
  640. havePower = true
  641. } else {
  642. havePower = false
  643. }
  644. } else {
  645. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(客观)") {
  646. havePower = true
  647. } else {
  648. havePower = false
  649. }
  650. }
  651. if !havePower {
  652. return
  653. }
  654. }
  655. if activityInfo.LimitPeopleNum > 0 {
  656. mapUserType, e := GetActivityCcustomerTypeList()
  657. if e != nil {
  658. err = e
  659. return
  660. }
  661. userTypeStr = mapUserType[userType]
  662. // 永续客户、大套餐客户、30W套餐客户可以查看行业升级套餐客户 权限
  663. if userTypeStr == "1" || userTypeStr == "2" || userTypeStr == "AA" {
  664. if strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) && strings.Contains(activityInfo.CustomerTypeIds, "8") {
  665. havePower = true
  666. //return
  667. }
  668. }
  669. } else {
  670. if strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  671. havePower = true
  672. return
  673. }
  674. }
  675. //判断管理规模是否满足
  676. companyProduct, e := models.GetCompanyProductDetail(user.CompanyId, 2)
  677. if e != nil {
  678. err = e
  679. return
  680. }
  681. if companyProduct != nil && activityInfo.Scale != "" {
  682. if strings.Contains(activityInfo.Scale, companyProduct.Scale) {
  683. havePower = true
  684. }
  685. }
  686. if user.CompanyId <= 1 {
  687. return
  688. } else {
  689. if permissionStr == "" {
  690. return
  691. } else {
  692. companyDetail, e := models.GetCompanyDetailById(user.CompanyId)
  693. if e != nil {
  694. err = errors.New("GetCompanyPermissionUpgrade, Err: " + e.Error())
  695. return
  696. }
  697. if companyDetail == nil {
  698. err = errors.New("客户不存在,uid:" + strconv.Itoa(user.UserId) + "CompanyId:" + strconv.Itoa(user.CompanyId))
  699. return
  700. }
  701. companyDetailStatus = companyDetail.Status
  702. }
  703. }
  704. //宏观满足用户可见身份验证权限既满足 2023-9-18
  705. if activityInfo.ChartPermissionId == 1 {
  706. if activityInfo.LimitPeopleNum > 0 {
  707. if strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) {
  708. havePower = true
  709. return
  710. }
  711. } else {
  712. havePower = true
  713. return
  714. }
  715. }
  716. if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3) && strings.Contains(permissionStr, "专家") && activityInfo.LimitPeopleNum == 0 {
  717. havePower = true
  718. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "正式" && strings.Contains(activityInfo.CustomerTypeIds, "4") {
  719. havePower = true
  720. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "试用" && strings.Contains(activityInfo.CustomerTypeIds, "5") {
  721. havePower = true
  722. } else if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3 || activityInfo.ActivityTypeId == 4 || activityInfo.ActivityTypeId == 5) && strings.Contains(permissionStr, "专家") {
  723. havePower = true
  724. }
  725. //fmt.Println(permissionStrZhengShi)
  726. //if (strings.Contains(activityInfo.ChartPermissionName, "研选") || activityInfo.ChartPermissionName == "策略") && strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  727. // havePower = true
  728. // return
  729. //}
  730. if strings.Contains(activityInfo.ChartPermissionName, "研选") || activityInfo.ChartPermissionName == "策略" {
  731. if strings.Contains(activityInfo.CustomerTypeIds, "5") {
  732. if strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  733. havePower = true
  734. return
  735. }
  736. } else {
  737. if strings.Contains(permissionStrZhengShi, activityInfo.ChartPermissionName) {
  738. havePower = true
  739. return
  740. }
  741. }
  742. }
  743. permissionShengji, errs := models.GetCompanyPermissionByUserTrip(user.CompanyId)
  744. if errs != nil {
  745. err = errs
  746. return
  747. }
  748. //fmt.Println("主客观2", havePower)
  749. //if strings.Contains(permissionStr, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) {
  750. // havePower = true
  751. //}
  752. //fmt.Println("主客观3", havePower)
  753. //处理升级权限以及用户身份的 双重判断
  754. if activityInfo.CustomerTypeIds != "" {
  755. if !strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) && userTypeStr != "8" {
  756. havePower = false
  757. if strings.Contains(permissionShengji, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, "8") {
  758. havePower = true
  759. }
  760. }
  761. }
  762. if havePower && activityInfo.LimitPeopleNum > 0 {
  763. //对于一些特殊的活动,即使权限满足也不给产看
  764. noPower, e := GetShareNoPowe(activityInfo, permissionStr, userType, user)
  765. if e != nil {
  766. err = errors.New("GetShareNoPowe, Err: " + e.Error())
  767. return
  768. }
  769. if noPower {
  770. havePower = false
  771. }
  772. }
  773. return
  774. }
  775. // 校验被分享的用户是否有查看详情的权限
  776. func GetShareNoPowe(activityInfo *models.ActivityDetail, permissionStr string, userType int, user *models.WxUserItem) (noPower bool, err error) {
  777. //如果是弘则的就不进行可见权限校验
  778. if user.CompanyId == utils.HZ_COMPANY_ID {
  779. return
  780. }
  781. //var noPower bool
  782. //if !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(userType)) {
  783. // noPower = true
  784. //}
  785. //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户
  786. //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)) {
  787. // noPower = true
  788. //}
  789. //if userType == 2 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(2)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
  790. // noPower = true
  791. //}
  792. //if userType == 3 && strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(4)) {
  793. // noPower = true
  794. //}
  795. //if userType == 3 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
  796. // noPower = true
  797. //}
  798. fmt.Println(userType)
  799. if userType == 8 {
  800. permissionShengji, errs := models.GetCompanyPermissionByUserZhengShiTrip(user.CompanyId)
  801. if errs != nil {
  802. err = errs
  803. return
  804. }
  805. if !strings.Contains(permissionShengji, activityInfo.ChartPermissionName) {
  806. noPower = true
  807. return
  808. }
  809. }
  810. if !noPower {
  811. noPower, err = CheckUserPowerByActivityChoose(user, activityInfo)
  812. }
  813. return
  814. }
  815. // 处理活动本组们是否决策人权限
  816. func CheckUserPowerByActivityChoose(user *models.WxUserItem, activityInfo *models.ActivityDetail) (noPower bool, err error) {
  817. //处理 见范围 1,仅本组可见 、2,全部客户可见
  818. if activityInfo.VisibleRange == 1 {
  819. adminIds, errAdmin := models.GetSelleridWhichGroup(user.CompanyId, 2)
  820. if errAdmin != nil {
  821. err = errAdmin
  822. return
  823. }
  824. sliceAdminIds := strings.Split(adminIds, ",")
  825. var haveAdminId bool
  826. for _, v := range sliceAdminIds {
  827. if v == strconv.Itoa(activityInfo.AdminId) {
  828. haveAdminId = true
  829. }
  830. }
  831. if !haveAdminId {
  832. noPower = true
  833. }
  834. }
  835. //处理 是否仅决策人可见 0,否 、1,是
  836. if activityInfo.IsMakerShow == 1 {
  837. if user.IsMaker == 0 {
  838. noPower = true
  839. }
  840. }
  841. return
  842. }
  843. // 校验用户报名的权限
  844. func GetHavePower(activityInfo *models.ActivityDetail, permissionStr, companyDetailStatus string, userType int) (havePower bool, err error) {
  845. // 查研观向7.4-宏观活动不作权限限制
  846. if activityInfo.ChartPermissionId == 1 {
  847. havePower = true
  848. return
  849. }
  850. if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3) && strings.Contains(permissionStr, "专家") && activityInfo.LimitPeopleNum == 0 {
  851. havePower = true
  852. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "正式" && strings.Contains(activityInfo.CustomerTypeIds, "4") {
  853. havePower = true
  854. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "试用" && strings.Contains(activityInfo.CustomerTypeIds, "5") {
  855. havePower = true
  856. //} else if strings.Contains(permissionStr, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(userType)) {
  857. // havePower = true
  858. //} else if strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  859. // havePower = true
  860. } else if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3 || activityInfo.ActivityTypeId == 4 || activityInfo.ActivityTypeId == 5) && strings.Contains(permissionStr, "专家") {
  861. havePower = true
  862. }
  863. if activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 6 || activityInfo.ActivityTypeId == 7 {
  864. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(主观)") {
  865. havePower = true
  866. }
  867. } else {
  868. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(客观)") {
  869. havePower = true
  870. }
  871. }
  872. if (strings.Contains(activityInfo.ChartPermissionName, "研选") || activityInfo.ChartPermissionName == "策略") && strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  873. havePower = true
  874. }
  875. //如果是易董的活动且属于研选类型,只要开通任何权限就可以查看详情
  876. if activityInfo.YidongActivityId != "" && permissionStr != "" && strings.Contains(activityInfo.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) {
  877. havePower = true
  878. }
  879. return
  880. }
  881. // 获取活动列表查询权限的SQL
  882. // @Param ChartPermissionIds query string false "行业id 多个用 , 隔开"
  883. // @Param ActivityTypeIds query string false "活动类型id 多个用 , 隔开"
  884. // @Param ActiveState query string false "活动进行状态 未开始:1、进行中2、已结束3"
  885. // @Param WhichDay query string false "哪一天 今天:1、明天:2,多个用 , 隔开"
  886. // @Param IsPower query int false "是否选择有权限行业 ,1是 0 否 默认0"
  887. // @Param Label query string false "搜索主题 多个用 , 隔开"
  888. // @Param PlayBack query int false "是否仅展示回放 1:是、0:否 默认0"
  889. // @Param KeyWord query string false "搜索关键词 多个用 , 隔开"
  890. // @Param ikType query int false "联想词类型 , 1不做联想,2,做除初始词的联想,3所有联想"
  891. func GetActivityonditionList(user *models.WxUserItem, activityTypeId, chartPermissionIds, whichDay, activeState, label string, isPower, source int, keyWord string, playBack, ikType int) (conditionActivity string, err error) {
  892. keyWordNoIk := keyWord
  893. adminIds, err := models.GetSelleridWhichGroup(user.CompanyId, 2)
  894. if err != nil {
  895. return
  896. }
  897. userType, permissionStr, permissionStrZhengShi, err := GetUserTypeZhengShi(user.CompanyId)
  898. if err != nil {
  899. return
  900. }
  901. //判断客户规模是否属于可见范围的活动
  902. companyProduct, err := models.GetCompanyProductDetail(user.CompanyId, 2)
  903. if err != nil && err.Error() != utils.ErrNoRow() {
  904. return
  905. }
  906. isMaker := user.IsMaker
  907. slicePer := strings.Split(permissionStr, ",")
  908. var permissionSqlStr string
  909. var permissionNameStr string
  910. for _, v := range slicePer {
  911. if userType == 1 {
  912. //研选权限处理
  913. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  914. permissionNameStr += "'" + v + "',"
  915. }
  916. } else {
  917. permissionNameStr += "'" + v + "',"
  918. }
  919. }
  920. permissionNameStr = strings.Replace(permissionNameStr, "(主观)", "", -1)
  921. permissionNameStr = strings.Replace(permissionNameStr, "(客观)", "", -1)
  922. permissionNameStr = strings.TrimRight(permissionNameStr, ",")
  923. slicePerZhengShi := strings.Split(permissionStrZhengShi, ",")
  924. var permissionNameStrZhengShi string
  925. for _, v := range slicePerZhengShi {
  926. if userType == 1 {
  927. //研选权限处理
  928. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  929. permissionNameStrZhengShi += "'" + v + "',"
  930. }
  931. } else {
  932. permissionNameStrZhengShi += "'" + v + "',"
  933. }
  934. }
  935. permissionNameStrZhengShi = strings.Replace(permissionNameStrZhengShi, "(主观)", "", -1)
  936. permissionNameStrZhengShi = strings.Replace(permissionNameStrZhengShi, "(客观)", "", -1)
  937. permissionNameStrZhengShi = strings.TrimRight(permissionNameStrZhengShi, ",")
  938. mapUserType, e := GetActivityCcustomerTypeList()
  939. if e != nil {
  940. err = e
  941. return
  942. }
  943. var userTypeStr string
  944. userTypeStr = mapUserType[userType]
  945. // 查研观向7.4-始终查询宏观的权限(无论是否有权限)
  946. if permissionNameStr == `` {
  947. permissionNameStr = `'宏观'`
  948. } else {
  949. permissionNameStr += `, '宏观'`
  950. }
  951. var condition string
  952. var conditionAdmin string
  953. var conditionHz string // 弘则权限处理
  954. var sqlExport string // 专家权限处理
  955. //permissionSqlStr = ` AND art.chart_permission_name IN (` + permissionNameStr + `)`
  956. sqlExport = ` AND (art.customer_type_ids LIKE '%` + userTypeStr + `%' `
  957. //if userType == 2 {
  958. // sqlExport += ` OR art.customer_type_ids LIKE '%3%' `
  959. //}
  960. //if (userType == 2 || userType == 3) && strings.Contains(permissionStr, "专家") {
  961. // sqlExport += ` OR art.customer_type_ids LIKE '%4%' `
  962. //}
  963. sqlExport += `) `
  964. // 如果是C类电话会就不展示内容,且合并到分析师电话会
  965. if activityTypeId != "" {
  966. if activityTypeId == strconv.Itoa(utils.ANALYST_TELL_ACTIVITY_TYPE_ID) {
  967. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id IN (` + activityTypeId + "," + strconv.Itoa(utils.C_CLASS_ACTIVITY_TYPE_ID) + `)`
  968. } else {
  969. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id IN (` + activityTypeId + `)`
  970. }
  971. }
  972. //主题
  973. if label != "" {
  974. condition = ` AND art.label LIKE "%` + label + `%" `
  975. }
  976. if isPower == 1 {
  977. condition += permissionSqlStr
  978. }
  979. //行业名称
  980. if len(chartPermissionIds) > 0 {
  981. condition += ` AND art.chart_permission_id IN (` + chartPermissionIds + `)`
  982. }
  983. //如果是PC的,则不看易董的
  984. if source == 1 {
  985. condition += ` AND art.yidong_activity_id = '' `
  986. }
  987. var conditionOr string
  988. if whichDay != "" {
  989. var startDate string
  990. var endDate string
  991. if whichDay == "1" {
  992. startDate = time.Now().Format(utils.FormatDate)
  993. endDate = startDate
  994. } else if whichDay == "2" {
  995. startDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  996. endDate = startDate
  997. } else if whichDay == "3" {
  998. startDate = utils.GetNowWeekMonday().Format(utils.FormatDate)
  999. endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
  1000. } else if whichDay == "4" {
  1001. startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
  1002. endDate = utils.GetLastWeekSunday().Format(utils.FormatDate)
  1003. } else if whichDay == "5" {
  1004. startDate = utils.GetNowMonthFirstDay().Format(utils.FormatDate)
  1005. endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
  1006. } else if whichDay == "6" {
  1007. startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
  1008. endDate = utils.GetLastMonthLastDay().Format(utils.FormatDate)
  1009. } else if whichDay == "1,2" {
  1010. startDate = time.Now().Format(utils.FormatDate)
  1011. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  1012. } else if whichDay == "3,4" {
  1013. startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
  1014. endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
  1015. } else if whichDay == "5,6" {
  1016. startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
  1017. endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
  1018. } else {
  1019. startDate = time.Now().Format(utils.FormatDate)
  1020. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  1021. }
  1022. condition += ` AND art.activity_time >= ` + "'" + startDate + " 00:00:00'"
  1023. condition += ` AND art.activity_time <= ` + "'" + endDate + " 23:59:59'"
  1024. }
  1025. //有搜索条件传过来时,不判进行状态条件
  1026. if keyWord != "" {
  1027. if ikType == 2 || ikType == 3 {
  1028. keyWordArr, e := GetIndustryMapNameSliceV3(keyWord)
  1029. if e != nil {
  1030. err = errors.New("获取分词失败,GetIndustryMapNameSliceV3, Err: " + keyWord + e.Error())
  1031. return
  1032. }
  1033. keyWordArr = RemoveDuplicatesAndEmpty(keyWordArr)
  1034. //var keywords string
  1035. if len(keyWordArr) > 1 {
  1036. if ikType == 2 {
  1037. keyWord = KeyWordArrSqlRegexp(keyWordArr)
  1038. condition += ` AND (art.label NOT LIKE '%` + keyWordNoIk + `%' AND art.activity_name NOT LIKE '%` + keyWordNoIk + `%' ) `
  1039. } else if ikType == 3 {
  1040. keyWord = KeyWordArrSqlRegexpAll(keyWordArr)
  1041. }
  1042. }
  1043. }
  1044. condition += ` AND (art.label REGEXP '` + keyWord + `' OR art.activity_name REGEXP '` + keyWord + `' ) `
  1045. } else {
  1046. if activeState != "" {
  1047. // 默认查看未开始跟进行中
  1048. if activeState == "1" {
  1049. condition += ` AND art.active_state IN (1,2)`
  1050. } else {
  1051. condition += ` AND art.active_state IN (` + activeState + `)`
  1052. }
  1053. } else {
  1054. condition += ` AND art.active_state IN (1,2)`
  1055. }
  1056. }
  1057. if playBack == 1 {
  1058. var pars []interface{}
  1059. ativityVIdArry := make([]string, 0)
  1060. voiceList, e := models.GetActivityVoiceListAll("", pars, 0, 1000)
  1061. if e != nil && e.Error() != utils.ErrNoRow() {
  1062. err = e
  1063. return
  1064. }
  1065. for _, v := range voiceList {
  1066. ativityVIdArry = append(ativityVIdArry, strconv.Itoa(v.ActivityId))
  1067. }
  1068. videoList, e := models.GetActivityVideoListAll("", pars, 0, 1000)
  1069. if e != nil && e.Error() != utils.ErrNoRow() {
  1070. err = e
  1071. return
  1072. }
  1073. for _, v := range videoList {
  1074. ativityVIdArry = append(ativityVIdArry, strconv.Itoa(v.ActivityId))
  1075. }
  1076. //活动音频,设置有效时间为30天,失效后该活动就不再支持音频回放。有效期起始时间为活动的开始时间
  1077. //endTime := time.Now().AddDate(0, 0, -30).Format("2006-01-02 15:04:05")
  1078. //condition += ` AND art.activity_time > '` + endTime + `' `
  1079. if len(ativityVIdArry) > 0 {
  1080. ativityVIdstr := strings.Join(ativityVIdArry, ",")
  1081. condition += ` AND art.activity_id IN (` + ativityVIdstr + `) `
  1082. } else {
  1083. condition += ` AND art.activity_id = 0 `
  1084. }
  1085. }
  1086. //查询全部可见的数据(是否全部客户可见)
  1087. //condition += ` AND art.visible_range != 1 AND art.publish_status = 1 `
  1088. condition += ` AND art.publish_status = 1 `
  1089. if adminIds == "" {
  1090. //condition += ` AND art.visible_range != 1 `
  1091. } else {
  1092. condition += ` AND ( art.visible_range != 1 OR ( art.admin_id IN ( ` + adminIds + ` ) AND art.visible_range = 1 )) `
  1093. }
  1094. conditionHz = condition
  1095. //活动仅决策人可见
  1096. if isMaker == 0 {
  1097. condition += ` AND art.is_maker_show = 0 `
  1098. }
  1099. conditionAdmin = condition + ` AND art.visible_range = 1 `
  1100. //condition += ` AND art.visible_range != 1 `
  1101. if (userType == 2 || userType == 3 || userType == 4) && strings.Contains(permissionStr, "专家") {
  1102. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%4%' ` + condition + `) `
  1103. }
  1104. if (userType == 5) && strings.Contains(permissionStr, "专家") {
  1105. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%5%' ` + condition + `) `
  1106. }
  1107. if userType == 1 {
  1108. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + permissionSqlStr + `) `
  1109. } else {
  1110. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
  1111. }
  1112. if userType == 6 || userType == 7 {
  1113. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' ` + condition + `) `
  1114. }
  1115. if companyProduct != nil {
  1116. if companyProduct.Scale != "" {
  1117. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%' ` + condition + `) `
  1118. }
  1119. }
  1120. if adminIds != "" {
  1121. if userType == 3 {
  1122. conditionAdmin += ` AND art.chart_permission_name IN (` + permissionNameStrZhengShi + `) `
  1123. }
  1124. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + userTypeStr + `%' ` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
  1125. if companyProduct != nil {
  1126. if companyProduct.Scale != "" {
  1127. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%'` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
  1128. }
  1129. }
  1130. }
  1131. conditionShengji, conditionZhengshi, conditionHangYe, e := ActivityLabelSpecialUserSql(user)
  1132. if e != nil {
  1133. err = errors.New("ActivityLabelSpecialUserSql, Err: " + e.Error())
  1134. return
  1135. }
  1136. if conditionShengji != "" {
  1137. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionShengji + condition + ` ) `
  1138. }
  1139. if conditionZhengshi != "" {
  1140. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionZhengshi + condition + ` ) `
  1141. }
  1142. if conditionHangYe != "" {
  1143. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionHangYe + condition + ` ) `
  1144. }
  1145. //弘则研究下的客户不做权限,限制,C类电话会,仅本组销售、部门管理员、admin、权益研究员账号能看到
  1146. if user.CompanyId == utils.HZ_COMPANY_ID {
  1147. mapMobile, e := GetAdminMobileMap()
  1148. if e != nil {
  1149. err = e
  1150. return
  1151. }
  1152. if _, ok := mapMobile[user.Mobile]; ok {
  1153. conditionOr += ` OR ( art.publish_status = 1 ` + conditionHz + `) `
  1154. }
  1155. }
  1156. if userType == 3 {
  1157. condition += ` AND art.chart_permission_name IN (` + permissionNameStrZhengShi + `) `
  1158. }
  1159. conditionActivity = condition + permissionSqlStr + sqlExport + conditionOr
  1160. return
  1161. }
  1162. // 根据用户身份处理活动可见
  1163. func ActivityConditioninitSql(user *models.WxUserItem, condition string, isPower int) (conditionActivity string, err error) {
  1164. //未登录的用户也可以查看所有活动v12.2.1
  1165. if user.UserId == 0 {
  1166. conditionActivity = ` AND art.publish_status = 1 AND art.yidong_activity_id = '' ` + condition
  1167. return
  1168. }
  1169. // cygx_10.9 未绑定联系方式的客户可以看到部分活动
  1170. if user.UserId == 0 || user.CompanyId == 1 {
  1171. 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
  1172. return
  1173. }
  1174. condition += ` AND art.publish_status = 1 `
  1175. conditionActivity = condition
  1176. //弘则可以查看所有活动
  1177. if (GetBelongingRaiIt(user.Mobile) && user.CompanyId == utils.HZ_COMPANY_ID) || user.UserId == 0 {
  1178. return
  1179. }
  1180. adminIds, err := models.GetSelleridWhichGroup(user.CompanyId, 2)
  1181. if err != nil {
  1182. return
  1183. }
  1184. userType, permissionStr, permissionStrZhengShi, err := GetUserTypeZhengShi(user.CompanyId)
  1185. if err != nil {
  1186. return
  1187. }
  1188. //判断客户规模是否属于可见范围的活动
  1189. companyProduct, err := models.GetCompanyProductDetail(user.CompanyId, 2)
  1190. if err != nil && err.Error() != utils.ErrNoRow() {
  1191. return
  1192. }
  1193. isMaker := user.IsMaker
  1194. slicePer := strings.Split(permissionStr, ",")
  1195. var permissionSqlStr string
  1196. var permissionNameStr string
  1197. for _, v := range slicePer {
  1198. if userType == 1 {
  1199. //研选权限处理
  1200. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  1201. permissionNameStr += "'" + v + "',"
  1202. }
  1203. } else {
  1204. permissionNameStr += "'" + v + "',"
  1205. }
  1206. }
  1207. permissionNameStr = strings.Replace(permissionNameStr, "(主观)", "", -1)
  1208. permissionNameStr = strings.Replace(permissionNameStr, "(客观)", "", -1)
  1209. permissionNameStr = strings.TrimRight(permissionNameStr, ",")
  1210. slicePerZhengShi := strings.Split(permissionStrZhengShi, ",")
  1211. var permissionNameStrZhengShi string
  1212. for _, v := range slicePerZhengShi {
  1213. if userType == 1 {
  1214. //研选权限处理
  1215. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  1216. permissionNameStrZhengShi += "'" + v + "',"
  1217. }
  1218. } else {
  1219. permissionNameStrZhengShi += "'" + v + "',"
  1220. }
  1221. }
  1222. permissionNameStrZhengShi = strings.Replace(permissionNameStrZhengShi, "(主观)", "", -1)
  1223. permissionNameStrZhengShi = strings.Replace(permissionNameStrZhengShi, "(客观)", "", -1)
  1224. permissionNameStrZhengShi = strings.TrimRight(permissionNameStrZhengShi, ",")
  1225. mapUserType, e := GetActivityCcustomerTypeList()
  1226. if e != nil {
  1227. err = e
  1228. return
  1229. }
  1230. var userTypeStr string
  1231. userTypeStr = mapUserType[userType]
  1232. // 查研观向7.4-始终查询宏观的权限(无论是否有权限)
  1233. if permissionNameStr == `` {
  1234. permissionNameStr = `'宏观'`
  1235. } else {
  1236. permissionNameStr += `, '宏观'`
  1237. }
  1238. var sqlExport string // 专家权限处理
  1239. sqlExport = ` AND (art.customer_type_ids LIKE '%` + userTypeStr + `%' `
  1240. if (userType == 2 || userType == 3) && strings.Contains(permissionStr, "专家") {
  1241. sqlExport += ` OR art.customer_type_ids LIKE '%4%' `
  1242. }
  1243. sqlExport += `) `
  1244. if isPower == 1 {
  1245. permissionSqlStr = ` AND art.chart_permission_name IN (` + permissionNameStr + `)`
  1246. condition += permissionSqlStr
  1247. }
  1248. var conditionOr string
  1249. //查询全部可见的数据(是否全部客户可见)
  1250. if adminIds != "" {
  1251. condition += ` AND ( art.visible_range != 1 OR ( art.admin_id IN ( ` + adminIds + ` ) AND art.visible_range = 1 )) `
  1252. }
  1253. //活动仅决策人可见
  1254. if isMaker == 0 {
  1255. condition += ` AND art.is_maker_show = 0 `
  1256. }
  1257. //condition += ` AND art.visible_range != 1 `
  1258. if (userType == 2 || userType == 3 || userType == 4) && strings.Contains(permissionStr, "专家") {
  1259. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%4%' ` + condition + `) `
  1260. }
  1261. if (userType == 5) && strings.Contains(permissionStr, "专家") {
  1262. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%5%' ` + condition + `) `
  1263. }
  1264. if userType == 1 {
  1265. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + permissionSqlStr + `) `
  1266. } else {
  1267. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
  1268. }
  1269. if userType == 6 || userType == 7 {
  1270. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' ` + condition + `) `
  1271. }
  1272. if companyProduct != nil {
  1273. if companyProduct.Scale != "" {
  1274. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%' ` + condition + `) `
  1275. }
  1276. }
  1277. conditionShengji, conditionZhengshi, conditionHangYe, e := ActivityLabelSpecialUserSql(user)
  1278. if e != nil {
  1279. err = errors.New("ActivityLabelSpecialUserSql, Err: " + e.Error())
  1280. return
  1281. }
  1282. // 升级客户可查看范围
  1283. if conditionShengji != "" {
  1284. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionShengji + condition + ` ) `
  1285. }
  1286. // 正式客户可查看范围
  1287. if conditionZhengshi != "" {
  1288. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionZhengshi + condition + ` ) `
  1289. }
  1290. // 行业客户可查看范围
  1291. if conditionHangYe != "" {
  1292. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionHangYe + condition + ` ) `
  1293. }
  1294. if userType == 3 {
  1295. condition += ` AND art.chart_permission_name IN (` + permissionNameStrZhengShi + `) `
  1296. }
  1297. condition += ` AND art.is_limit_people = 1 `
  1298. conditionActivity = condition + permissionSqlStr + sqlExport + conditionOr
  1299. return
  1300. }
  1301. // 研选系列专家电话会,会前1小时将问题列表发送给邮箱
  1302. func SendEmailFileForAskMsgResearch(cont context.Context) (err error) {
  1303. var msg string
  1304. //var touser string
  1305. defer func() {
  1306. if err != nil {
  1307. go utils.SendAlarmMsg("发送附件模版消息失败", 2)
  1308. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  1309. }
  1310. if msg != "" {
  1311. go utils.SendAlarmMsg(msg, 2)
  1312. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  1313. }
  1314. }()
  1315. endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
  1316. condition := `AND a.activity_type_id = 1 AND a.chart_permission_id = 31 `
  1317. total, err := models.GetCountActivityResearchToSendFile(condition, endDate)
  1318. if total == 0 {
  1319. fmt.Println("发送附件完成0")
  1320. return nil
  1321. }
  1322. if err != nil {
  1323. msg = "发送附件模版消息失败 Err:" + err.Error()
  1324. return
  1325. }
  1326. listActivity, err := models.GetActivityResearchToSendFile(condition, endDate)
  1327. if err != nil {
  1328. msg = "发送附件模版消息失败 Err:" + err.Error()
  1329. return
  1330. }
  1331. for _, v := range listActivity {
  1332. activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
  1333. if activityInfo == nil {
  1334. msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
  1335. return
  1336. }
  1337. list, errFile := models.GetActivityMsgExport(v.ActivityId)
  1338. if errFile != nil {
  1339. msg = "获取失败,Err:" + errFile.Error()
  1340. return
  1341. }
  1342. for _, v2 := range list {
  1343. user, e := models.GetWxUserItemByUserId(v2.UserId)
  1344. if e != nil && e.Error() != utils.ErrNoRow() {
  1345. err = errors.New("GetWxUserItemByUserId, Err: " + e.Error())
  1346. return err
  1347. }
  1348. //获取销售信息
  1349. sellerItem, e := models.GetSellerByCompanyIdCheckFicc(v2.CompanyId, 2)
  1350. if e != nil && e.Error() != utils.ErrNoRow() {
  1351. err = errors.New("GetSellerByCompanyIdCheckFicc, Err: " + e.Error())
  1352. return
  1353. }
  1354. //如果是研选的就推送给汪洋
  1355. cnf, e := models.GetConfigByCode(utils.TPL_MSG_WANG_YANG)
  1356. if e != nil {
  1357. err = errors.New("GetConfigByCode, Err: " + e.Error())
  1358. return
  1359. }
  1360. //给汪洋推送消息
  1361. if sellerItem != nil {
  1362. openIpItem, _ := models.GetUserRecordByMobile(4, cnf.ConfigValue)
  1363. if openIpItem != nil && openIpItem.OpenId != "" {
  1364. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName+"("+sellerItem.RealName+")", "提问:"+activityInfo.ActivityName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo, v2.AskId)
  1365. }
  1366. }
  1367. //给所属销售推送消息
  1368. if sellerItem != nil {
  1369. openIpItem, _ := models.GetUserRecordByMobile(4, sellerItem.Mobile)
  1370. if openIpItem != nil && openIpItem.OpenId != "" {
  1371. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName+"("+sellerItem.RealName+")", "提问:"+activityInfo.ActivityName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo, v2.AskId)
  1372. }
  1373. }
  1374. }
  1375. errFile = models.UPdateActivityMsgToSendFile(v.ActivityId)
  1376. if errFile != nil {
  1377. msg = "获取失败,Err:" + errFile.Error()
  1378. return
  1379. }
  1380. }
  1381. return
  1382. }
  1383. // 非研选系列专家电话会,根据主持人姓名,会前15分钟将问题列表发送给至该主持人对应邮箱
  1384. func SendEmailFileForAskMsg(cont context.Context) (err error) {
  1385. var msg string
  1386. //var touser string
  1387. defer func() {
  1388. if err != nil {
  1389. go utils.SendAlarmMsg("发送附件模版消息失败", 2)
  1390. go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
  1391. }
  1392. if msg != "" {
  1393. go utils.SendAlarmMsg(msg, 2)
  1394. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  1395. }
  1396. }()
  1397. endDate := time.Now().Add(+time.Minute * 15).Format(utils.FormatDateTime)
  1398. condition := `AND a.activity_type_id = 1 AND a.chart_permission_id != 31 `
  1399. total, err := models.GetCountActivityResearchToSendFile(condition, endDate)
  1400. if total == 0 {
  1401. fmt.Println("发送附件完成0")
  1402. return nil
  1403. }
  1404. if err != nil {
  1405. msg = "发送附件模版消息失败 Err:" + err.Error()
  1406. return
  1407. }
  1408. listActivity, err := models.GetActivityResearchToSendFile(condition, endDate)
  1409. if err != nil {
  1410. msg = "发送附件模版消息失败 Err:" + err.Error()
  1411. return
  1412. }
  1413. listEmail, errEmail := models.GetAskEmail()
  1414. if errEmail != nil {
  1415. msg = "获取失败,Err:" + errEmail.Error()
  1416. return
  1417. }
  1418. for _, v := range listActivity {
  1419. activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
  1420. if activityInfo == nil {
  1421. msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
  1422. return
  1423. }
  1424. list, errFile := models.GetActivityMsgExport(v.ActivityId)
  1425. if errFile != nil {
  1426. msg = "获取失败,Err:" + errFile.Error()
  1427. return
  1428. }
  1429. for _, v2 := range list {
  1430. user, err := models.GetWxUserItemByUserId(v2.UserId)
  1431. if err != nil && err.Error() != utils.ErrNoRow() {
  1432. return err
  1433. }
  1434. var sendMobile string
  1435. for _, vEmail := range listEmail {
  1436. if strings.Index(activityInfo.Host, vEmail.Name) > 0 {
  1437. sendMobile = vEmail.Mobile
  1438. }
  1439. }
  1440. //获取销售信息
  1441. sellerItem, err := models.GetSellerByCompanyIdCheckFicc(v2.CompanyId, 2)
  1442. if err != nil && err.Error() != utils.ErrNoRow() {
  1443. return err
  1444. }
  1445. //给研究员推送模板消息
  1446. if sellerItem != nil {
  1447. openIpItem, _ := models.GetUserRecordByMobile(4, sendMobile)
  1448. if openIpItem != nil && openIpItem.OpenId != "" {
  1449. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  1450. //SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  1451. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName+"("+sellerItem.RealName+")", "提问:"+activityInfo.ActivityName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo, v2.AskId)
  1452. }
  1453. }
  1454. //给销售推送模板消息
  1455. if sellerItem != nil {
  1456. openIpItem, _ := models.GetUserRecordByMobile(4, sellerItem.Mobile)
  1457. if openIpItem != nil && openIpItem.OpenId != "" {
  1458. //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
  1459. //SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
  1460. SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName+"("+sellerItem.RealName+")", "提问:"+activityInfo.ActivityName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo, v2.AskId)
  1461. }
  1462. }
  1463. }
  1464. errFile = models.UPdateActivityMsgToSendFile(v.ActivityId)
  1465. if errFile != nil {
  1466. msg = "获取失败,Err:" + errFile.Error()
  1467. return
  1468. }
  1469. }
  1470. return
  1471. }
  1472. // 活动标签字符串处理
  1473. func LabelStr(label string) (labelNew string) {
  1474. slicebr := strings.Split(label, "-")
  1475. if len(slicebr) < 2 {
  1476. labelNew = label
  1477. } else {
  1478. labelNew = slicebr[1]
  1479. }
  1480. return labelNew
  1481. }
  1482. // 5.3版本活动标签字符串处理
  1483. func LabelStrV5(label string, isShowSubjectName int, temporaryLabel string) (labelNew string) {
  1484. slicebr := strings.Split(label, "-")
  1485. if len(slicebr) > 1 {
  1486. if isShowSubjectName == 1 {
  1487. labelNew = slicebr[1]
  1488. } else {
  1489. labelNew = slicebr[0]
  1490. }
  1491. } else {
  1492. labelNew = label
  1493. }
  1494. if temporaryLabel != "" {
  1495. labelNew = temporaryLabel
  1496. }
  1497. return labelNew
  1498. }
  1499. func ActivityAttendanceDetail(cont context.Context) (err error) {
  1500. defer func() {
  1501. if err != nil {
  1502. fmt.Println("ActivityAttendanceDetail Err:" + err.Error())
  1503. go utils.SendAlarmMsg("同步进门财经数据失败", 2)
  1504. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "ActivityAttendanceDetail ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1505. }
  1506. }()
  1507. configCode := "jin_meng_activity_id"
  1508. detail, err := models.GetConfigByCode(configCode)
  1509. if err != nil {
  1510. return err
  1511. }
  1512. fmt.Println(detail.ConfigValue)
  1513. mapActivityId := make(map[string]string)
  1514. sliceValue := strings.Split(detail.ConfigValue, ",")
  1515. for _, v := range sliceValue {
  1516. mapActivityId[v] = v
  1517. }
  1518. var activityIds string
  1519. var activityIdsLongTime string //可回放的会议,到会详情持续更新加入到不做14天限制的活动中
  1520. fmt.Println("开始同步")
  1521. dateTime := time.Now().AddDate(0, 0, -7).Format(utils.FormatDate)
  1522. dateNow := time.Now().AddDate(0, 0, 0).Format(utils.FormatDate)
  1523. startDate := dateTime + " 00:00:00"
  1524. endDate := dateNow + " 23:59:59"
  1525. //获取进门财经需要处理的活动
  1526. listActivityRoadshow, err := models.GetRoadshowDataListByDateTime(startDate, endDate)
  1527. if err != nil {
  1528. fmt.Println("GetRoadshowDataListByDateTime Err:", err.Error())
  1529. return err
  1530. }
  1531. for _, vAct := range listActivityRoadshow {
  1532. doTime := utils.TimeRemoveHms2(vAct.RoadshowBeginTime)
  1533. findStartDate := doTime + " 00:00:00"
  1534. findEndDate := doTime + " 23:59:59"
  1535. var roadshowTitle string
  1536. roadshowTitle = vAct.RoadshowTitle
  1537. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "【", "", -1)
  1538. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "】", "", -1)
  1539. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, " ", "", -1)
  1540. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "-", "", -1)
  1541. vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, ":", "", -1)
  1542. nameSlice := strings.Split(vAct.RoadshowTitle, "|")
  1543. //fmt.Println(timeSlice[0])
  1544. //对于手动匹配到的活动数据也要更新
  1545. var activityName string
  1546. if len(nameSlice) >= 1 {
  1547. //if vAct.JmcjRoadshowTitle != "" {
  1548. // activityName = vAct.JmcjRoadshowTitle
  1549. //} else {
  1550. // activityName = nameSlice[len(nameSlice)-1]
  1551. //}
  1552. activityName = nameSlice[len(nameSlice)-1]
  1553. if activityName != "" {
  1554. //通过名称去找匹配的活动
  1555. activityDetail, _ := models.GetAddActivityInfoByTitle(activityName, findStartDate, findEndDate)
  1556. if activityDetail == nil {
  1557. continue
  1558. } else {
  1559. activityIds += strconv.Itoa(activityDetail.ActivityId) + ","
  1560. }
  1561. list, err := models.GetRoadshowDataList(roadshowTitle, findStartDate, findEndDate)
  1562. if err != nil {
  1563. fmt.Println("GetTacticsList Err:", err.Error())
  1564. return err
  1565. }
  1566. var isPlayback bool // 是否包含回放
  1567. needAddAttendanc := make([]*models.CygxActivityAttendanceDetail, 0)
  1568. var mobileStr string
  1569. var mobileArr []string
  1570. if len(list) > 0 {
  1571. fmt.Println("原来的", vAct.RoadshowTitle)
  1572. fmt.Println("处理的", activityName)
  1573. for _, v := range list {
  1574. if v.UserPhone != "" {
  1575. item := new(models.CygxActivityAttendanceDetail)
  1576. item.ActivityId = activityDetail.ActivityId
  1577. item.RealName = v.UserName
  1578. item.Mobile = v.UserPhone
  1579. item.CompanyName = v.Company
  1580. //item.SellerName = sellerName
  1581. item.FirstMeetingTime = v.FirstWatchTime
  1582. item.LastMeetingTime = v.LastWatchTime
  1583. item.Duration = utils.GetAttendanceDetailSeconds(v.JoinTime)
  1584. if v.JoinType == 1 {
  1585. item.MeetingTypeStr = "网络"
  1586. } else {
  1587. item.MeetingTypeStr = "电话"
  1588. }
  1589. item.MeetingAuthentication = v.AuthInfo
  1590. if v.DataType == 1 {
  1591. item.MeetingStatusStr = "直播"
  1592. } else {
  1593. item.MeetingStatusStr = "回放"
  1594. isPlayback = true
  1595. }
  1596. item.Position = v.Occupation
  1597. item.UseridEntity = v.UseridEntity
  1598. item.ActivityTime = activityDetail.ActivityTime
  1599. item.CrmCompanyMapStatusId = v.CrmCompanyMapStatusId
  1600. item.CreateTime = time.Now()
  1601. mobileStr += "'" + v.UserPhone + "'" + ","
  1602. mobileArr = append(mobileArr, v.UserPhone)
  1603. needAddAttendanc = append(needAddAttendanc, item)
  1604. }
  1605. }
  1606. if isPlayback && mapActivityId[strconv.Itoa(activityDetail.ActivityId)] == "" {
  1607. activityIdsLongTime += strconv.Itoa(activityDetail.ActivityId) + ","
  1608. }
  1609. mobileStr = strings.TrimRight(mobileStr, ",")
  1610. if mobileStr == "" {
  1611. mobileStr = "1"
  1612. }
  1613. listUser, err := models.GetWxUserOutboundMobile(mobileStr)
  1614. if err != nil {
  1615. fmt.Println("GetWxUserOutboundMobile Err:", err.Error())
  1616. return err
  1617. }
  1618. for k, v := range needAddAttendanc {
  1619. for _, v2 := range listUser {
  1620. if v2.OutboundMobile == v.Mobile || v2.Mobile == v.Mobile {
  1621. if needAddAttendanc[k].CompanyId == 0 {
  1622. needAddAttendanc[k].CompanyId = v2.CompanyId
  1623. needAddAttendanc[k].SellerName = v2.SellerName
  1624. needAddAttendanc[k].CompanyName = v2.CompanyName
  1625. needAddAttendanc[k].IsMeetingStr = 1
  1626. }
  1627. }
  1628. }
  1629. }
  1630. //fmt.Println(mobileStr)
  1631. //参会记录
  1632. err = models.AddAttendancDetail(needAddAttendanc, activityDetail.ActivityId, mobileStr)
  1633. if err != nil {
  1634. fmt.Println("AddAttendancDetail Err:", err.Error())
  1635. return err
  1636. }
  1637. ////处理是否限制报名
  1638. err = AddCygxActivityRestrictSignupByAdmin(activityDetail.ActivityId)
  1639. if err != nil {
  1640. fmt.Println("AddCygxActivityRestrictSignupByAdmin Err:", err.Error())
  1641. return err
  1642. }
  1643. go ActivityUserLabelLogAdd(activityDetail.ActivityId, mobileArr)
  1644. AddctivitySignupDetailByJmcj(needAddAttendanc, activityDetail.ActivityId)
  1645. }
  1646. }
  1647. }
  1648. }
  1649. //获取需要处理的活动
  1650. listActivity, err := models.GetActivityListByDateTime(startDate, endDate, activityIds, detail.ConfigValue)
  1651. if err != nil {
  1652. fmt.Println("GetTacticsList Err:", err.Error())
  1653. return err
  1654. }
  1655. //通过本地去找进门财经的数据
  1656. for _, vAct := range listActivity {
  1657. doTime := utils.TimeRemoveHms2(vAct.ActivityTime)
  1658. findStartDate := doTime + " 00:00:00"
  1659. findEndDate := doTime + " 23:59:59"
  1660. nameSlice := strings.Split(vAct.ActivityName, "】")
  1661. //对于手动匹配到的活动数据也要更新
  1662. var activityName string
  1663. if len(nameSlice) > 1 {
  1664. if vAct.JmcjRoadshowTitle != "" {
  1665. activityName = vAct.JmcjRoadshowTitle
  1666. } else {
  1667. activityName = nameSlice[len(nameSlice)-1]
  1668. }
  1669. //activityName = nameSlice[len(nameSlice)-1]
  1670. if activityName != "" {
  1671. list, err := models.GetRoadshowDataList(activityName, findStartDate, findEndDate)
  1672. if err != nil {
  1673. fmt.Println("GetTacticsList Err:", err.Error())
  1674. return err
  1675. }
  1676. var isPlayback bool // 是否包含回放
  1677. needAddAttendanc := make([]*models.CygxActivityAttendanceDetail, 0)
  1678. var mobileStr string
  1679. var mobileArr []string
  1680. if len(list) > 0 {
  1681. fmt.Println("原来的1", vAct.ActivityName)
  1682. fmt.Println("处理的2", activityName)
  1683. for _, v := range list {
  1684. if v.UserPhone != "" {
  1685. item := new(models.CygxActivityAttendanceDetail)
  1686. item.ActivityId = vAct.ActivityId
  1687. item.RealName = v.UserName
  1688. item.Mobile = v.UserPhone
  1689. item.CompanyName = v.Company
  1690. //item.SellerName = sellerName
  1691. item.FirstMeetingTime = v.FirstWatchTime
  1692. item.LastMeetingTime = v.LastWatchTime
  1693. item.Duration = utils.GetAttendanceDetailSeconds(v.JoinTime)
  1694. if v.JoinType == 1 {
  1695. item.MeetingTypeStr = "网络"
  1696. } else {
  1697. item.MeetingTypeStr = "电话"
  1698. }
  1699. item.MeetingAuthentication = v.AuthInfo
  1700. if v.DataType == 1 {
  1701. item.MeetingStatusStr = "直播"
  1702. } else {
  1703. item.MeetingStatusStr = "回放"
  1704. isPlayback = true
  1705. }
  1706. item.Position = v.Occupation
  1707. item.UseridEntity = v.UseridEntity
  1708. item.ActivityTime = vAct.ActivityTime
  1709. item.CrmCompanyMapStatusId = v.CrmCompanyMapStatusId
  1710. item.CreateTime = time.Now()
  1711. mobileStr += "'" + v.UserPhone + "'" + ","
  1712. mobileArr = append(mobileArr, v.UserPhone)
  1713. needAddAttendanc = append(needAddAttendanc, item)
  1714. }
  1715. }
  1716. if isPlayback && mapActivityId[strconv.Itoa(vAct.ActivityId)] == "" {
  1717. activityIdsLongTime += strconv.Itoa(vAct.ActivityId) + ","
  1718. }
  1719. mobileStr = strings.TrimRight(mobileStr, ",")
  1720. if mobileStr == "" {
  1721. mobileStr = "1"
  1722. }
  1723. listUser, err := models.GetWxUserOutboundMobile(mobileStr)
  1724. if err != nil {
  1725. fmt.Println("GetWxUserOutboundMobile Err:", err.Error())
  1726. return err
  1727. }
  1728. for k, v := range needAddAttendanc {
  1729. for _, v2 := range listUser {
  1730. if v2.OutboundMobile == v.Mobile || v2.Mobile == v.Mobile {
  1731. if needAddAttendanc[k].CompanyId == 0 {
  1732. needAddAttendanc[k].CompanyId = v2.CompanyId
  1733. needAddAttendanc[k].SellerName = v2.SellerName
  1734. needAddAttendanc[k].CompanyName = v2.CompanyName
  1735. needAddAttendanc[k].IsMeetingStr = 1
  1736. }
  1737. }
  1738. }
  1739. }
  1740. ////参会记录
  1741. err = models.AddAttendancDetail(needAddAttendanc, vAct.ActivityId, mobileStr)
  1742. if err != nil {
  1743. fmt.Println("AddAttendancDetail Err:", err.Error())
  1744. return err
  1745. }
  1746. ////处理是否限制报名
  1747. err = AddCygxActivityRestrictSignupByAdmin(vAct.ActivityId)
  1748. if err != nil {
  1749. fmt.Println("AddCygxActivityRestrictSignupByAdmin Err:", err.Error())
  1750. return err
  1751. }
  1752. activityIds += strconv.Itoa(vAct.ActivityId) + ","
  1753. go ActivityUserLabelLogAdd(vAct.ActivityId, mobileArr)
  1754. AddctivitySignupDetailByJmcj(needAddAttendanc, vAct.ActivityId)
  1755. }
  1756. }
  1757. }
  1758. }
  1759. if activityIdsLongTime != "" {
  1760. activityIdsLongTime = strings.TrimRight(activityIdsLongTime, ",")
  1761. activityIdsLongTime = detail.ConfigValue + "," + activityIdsLongTime
  1762. go models.UpdateConfigByCode(activityIdsLongTime, configCode)
  1763. }
  1764. activityIds = strings.TrimRight(activityIds, ",")
  1765. if activityIds != "" {
  1766. detailList, err := models.GetActivityAttendanceDetailList(activityIds)
  1767. if err != nil {
  1768. fmt.Println("GetActivityAttendanceDetailList Err:", err.Error())
  1769. return err
  1770. }
  1771. //添加报名日志 (下载使用)
  1772. err = models.AddCygxActivityMeetDetailLogOnlineByList(detailList, activityIds)
  1773. if err != nil {
  1774. fmt.Println("AddCygxActivityMeetDetailLogOnline Err:", err.Error())
  1775. return err
  1776. }
  1777. }
  1778. fmt.Println("结束路演同步")
  1779. return
  1780. }
  1781. // 查研观向处理活动用户限制报名
  1782. func AddCygxActivityRestrictSignupByAdmin(activityId int) (err error) {
  1783. defer func() {
  1784. if err != nil {
  1785. fmt.Println("err:", err)
  1786. go utils.SendAlarmMsg("查研观向处理活动用户限制报名失败,Err:"+err.Error()+"activityId"+strconv.Itoa(activityId), 3)
  1787. }
  1788. }()
  1789. activityInfo, e := models.GetAddActivityInfoById(activityId)
  1790. if e != nil {
  1791. err = errors.New("GetAddActivityInfoById" + e.Error())
  1792. return
  1793. }
  1794. if activityInfo == nil {
  1795. return
  1796. }
  1797. //不限制报名的不做爽约限制处理
  1798. //if activityInfo.IsLimitPeople > 0 {
  1799. //total, err := cygx.GetActivitySignupNomeetingCount(activityId)
  1800. if err != nil {
  1801. return
  1802. }
  1803. mobileList, _ := models.GetUserMeetingMobile(activityId)
  1804. var userIdArr []int
  1805. if len(mobileList) > 0 {
  1806. for _, v := range mobileList {
  1807. userIdArr = append(userIdArr, v.UserId)
  1808. }
  1809. lenuserIdArr := len(userIdArr)
  1810. var condition string
  1811. var pars []interface{}
  1812. condition = ` AND user_id IN (` + utils.GetOrmInReplace(lenuserIdArr) + `)`
  1813. pars = append(pars, userIdArr)
  1814. restrictSignupList, e := models.GetCygxActivityRestrictSignupList(condition, pars, 0, 9999)
  1815. if e != nil {
  1816. err = errors.New("GetCygxActivityRestrictSignupList" + e.Error())
  1817. return
  1818. }
  1819. //获取这些用户是否被加入到限制报名了
  1820. maptotalRestrict := make(map[int]bool)
  1821. for _, v := range restrictSignupList {
  1822. maptotalRestrict[v.UserId] = true
  1823. }
  1824. pars = make([]interface{}, 0)
  1825. 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) + `)`
  1826. pars = append(pars, userIdArr)
  1827. listSignup, e := models.GetActivitySignupInnerActivityList(condition, pars)
  1828. if e != nil && e.Error() != utils.ErrNoRow() {
  1829. err = errors.New("GetActivitySignupInnerActivityList" + e.Error())
  1830. return
  1831. }
  1832. mapNomeet := make(map[int]int)
  1833. if len(listSignup) > 0 {
  1834. for _, v := range listSignup {
  1835. mapNomeet[v.UserId]++
  1836. }
  1837. }
  1838. var userIdDelArr []int
  1839. for _, v := range mobileList {
  1840. //如果加入了爽约限制但是爽约次数少于3条就删除爽约记录
  1841. if maptotalRestrict[v.UserId] && mapNomeet[v.UserId] < 3 {
  1842. userIdDelArr = append(userIdDelArr, v.UserId)
  1843. }
  1844. }
  1845. if len(userIdDelArr) > 0 {
  1846. e = models.DeleteCygxActivityRestrictSignupByUserIds(userIdDelArr)
  1847. if e != nil {
  1848. err = errors.New("DeleteCygxActivityRestrictSignupByUserIds" + e.Error())
  1849. return
  1850. }
  1851. }
  1852. }
  1853. //if total == 0 {
  1854. // return
  1855. //}
  1856. //}
  1857. list, e := models.GetActivitySignupNomeetingCountList(activityId)
  1858. if e != nil {
  1859. err = errors.New("GetActivitySignupNomeetingCountList" + e.Error())
  1860. return
  1861. }
  1862. var userIdSiginArr []int
  1863. var items []*models.CygxActivitySignupBreak
  1864. for _, v := range list {
  1865. userIdSiginArr = append(userIdSiginArr, v.UserId)
  1866. //添加爽约记录
  1867. item := new(models.CygxActivitySignupBreak)
  1868. item.UserId = v.UserId
  1869. item.ActivityId = v.ActivityId
  1870. item.CreateTime = time.Now()
  1871. item.Mobile = v.Mobile
  1872. item.Email = v.Email
  1873. item.CompanyId = v.CompanyId
  1874. item.CompanyName = v.CompanyName
  1875. item.RealName = v.RealName
  1876. item.SellerName = v.SellerName
  1877. items = append(items, item)
  1878. }
  1879. if len(list) == 0 {
  1880. return
  1881. }
  1882. var itemsRestrict []*models.CygxActivityRestrictSignup
  1883. maptotalRestrict := make(map[int]bool)
  1884. lenuserIdSiginArr := len(userIdSiginArr)
  1885. var condition string
  1886. var pars []interface{}
  1887. condition = ` AND user_id IN (` + utils.GetOrmInReplace(lenuserIdSiginArr) + `)`
  1888. pars = append(pars, userIdSiginArr)
  1889. restrictSignupList, e := models.GetCygxActivityRestrictSignupList(condition, pars, 0, 9999)
  1890. if e != nil {
  1891. err = errors.New("GetCygxActivityRestrictSignupList" + e.Error())
  1892. return
  1893. }
  1894. //获取这些用户是否被加入到限制报名了
  1895. for _, v := range restrictSignupList {
  1896. maptotalRestrict[v.UserId] = true
  1897. }
  1898. pars = make([]interface{}, 0)
  1899. 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) + `)`
  1900. pars = append(pars, userIdSiginArr)
  1901. listSignup, e := models.GetActivitySignupInnerActivityList(condition, pars)
  1902. if e != nil && e.Error() != utils.ErrNoRow() {
  1903. err = errors.New("GetActivitySignupInnerActivityList" + e.Error())
  1904. return
  1905. }
  1906. mapNomeet := make(map[int]int)
  1907. if len(listSignup) > 0 {
  1908. for _, v := range listSignup {
  1909. mapNomeet[v.UserId]++
  1910. }
  1911. }
  1912. for _, v := range mobileList {
  1913. //如果加入了爽约限制但是爽约次数少于3条就删除爽约记录
  1914. if !maptotalRestrict[v.UserId] && mapNomeet[v.UserId] >= 3 {
  1915. itemRestrict := new(models.CygxActivityRestrictSignup)
  1916. itemRestrict.UserId = v.UserId
  1917. itemRestrict.CreateTime = time.Now()
  1918. itemRestrict.Mobile = v.Mobile
  1919. itemRestrict.Email = v.Email
  1920. itemRestrict.CompanyId = v.CompanyId
  1921. itemRestrict.CompanyName = v.CompanyName
  1922. itemRestrict.IsRestrict = 1
  1923. itemsRestrict = append(itemsRestrict, itemRestrict)
  1924. }
  1925. }
  1926. err = models.DeleteCygxActivitySignupBreakById(activityId)
  1927. if err != nil {
  1928. err = errors.New("DeleteCygxActivitySignupBreakById" + err.Error())
  1929. return
  1930. }
  1931. //添加爽约记录
  1932. if len(items) > 0 {
  1933. _, e = models.AddCygxActivitySignupBreakList(items)
  1934. if e != nil {
  1935. err = errors.New("AddCygxActivitySignupBreakList, Err: " + e.Error())
  1936. return
  1937. }
  1938. }
  1939. //添加报名限制
  1940. if len(itemsRestrict) > 0 {
  1941. _, e = models.AddCygxActivityRestrictSignupList(itemsRestrict)
  1942. if e != nil {
  1943. err = errors.New("AddCygxActivityRestrictSignupList, Err: " + e.Error())
  1944. return
  1945. }
  1946. }
  1947. return
  1948. }
  1949. // 判断预约纪要按钮是否显示
  1950. func IsShowAppointment(activityTypeId int, chartPermissionName string) (isShowAppointment bool) {
  1951. if activityTypeId == 1 || activityTypeId == 2 || activityTypeId == 3 || activityTypeId == 4 {
  1952. isShowAppointment = true
  1953. }
  1954. if activityTypeId == 5 && chartPermissionName == "医药" {
  1955. isShowAppointment = true
  1956. }
  1957. return
  1958. }
  1959. // 判断预约纪要按钮是否显示
  1960. func IsShowAppointmentByactivityInfo(item *models.ActivityDetail, chartPermissionName string) (isShowAppointment bool) {
  1961. activityTypeId := item.ActivityTypeId
  1962. if activityTypeId == 1 || activityTypeId == 3 || activityTypeId == 4 {
  1963. isShowAppointment = true
  1964. }
  1965. if activityTypeId == 5 && chartPermissionName == "医药" {
  1966. isShowAppointment = true
  1967. }
  1968. if activityTypeId == 2 && item.IsLimitPeople == 0 {
  1969. isShowAppointment = true
  1970. }
  1971. return
  1972. }
  1973. // 用户报告操作行为,模板消息推送 (先放在活动模块下,避免代码冲突)
  1974. func ArticleUserRemind(user *models.WxUserItem, articleDetail *models.ArticleDetail, source int) (err error) {
  1975. defer func() {
  1976. if err != nil {
  1977. go utils.SendAlarmMsg(" 用户报告操作行为,模板消息推送失败"+fmt.Sprint("UserId:", user.UserId, "ArticleId:", articleDetail.ArticleId), 2)
  1978. }
  1979. }()
  1980. countUser, err := models.GetUserRemind(user.UserId)
  1981. if err != nil {
  1982. return err
  1983. }
  1984. if countUser == 0 {
  1985. return err
  1986. }
  1987. var sourceMsg string
  1988. if source == 1 {
  1989. sourceMsg = "阅读报告"
  1990. } else {
  1991. sourceMsg = "收藏报告"
  1992. }
  1993. //获取销售手机号
  1994. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1995. if err != nil && err.Error() != utils.ErrNoRow() {
  1996. return err
  1997. }
  1998. if sellerItemQy != nil {
  1999. openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  2000. if err != nil {
  2001. fmt.Println(err)
  2002. return err
  2003. }
  2004. var keyword1 string
  2005. var keyword2 string
  2006. keyword1 = articleDetail.Title
  2007. keyword2 = fmt.Sprint("互动:", sourceMsg, ",", user.RealName, "--", user.CompanyName)
  2008. SendWxMsgWithArticleUserRemind(keyword1, keyword2, openIdList, articleDetail.ArticleId)
  2009. }
  2010. return
  2011. }
  2012. // 用户活动操作行为,模板消息推送
  2013. func ActivityUserRemind(user *models.WxUserItem, activityDetail *models.ActivityDetail, source int) (err error) {
  2014. defer func() {
  2015. if err != nil {
  2016. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "ActivityUserRemind ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  2017. }
  2018. }()
  2019. //获取销售手机号
  2020. countUser, e := models.GetUserRemind(user.UserId)
  2021. if e != nil {
  2022. err = errors.New("GetUserRemind, Err: " + e.Error())
  2023. return
  2024. }
  2025. //获取销售手机号
  2026. sellerItemQy, e := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  2027. if e != nil && e.Error() != utils.ErrNoRow() {
  2028. err = errors.New("GetSellerByCompanyIdCheckFicc, Err: " + e.Error())
  2029. return
  2030. }
  2031. if sellerItemQy == nil {
  2032. err = nil
  2033. return
  2034. }
  2035. //某销售下的所有客户活动报名/预约外呼时,模板消息提醒该销售(可设置销售范围,随时增减销售)
  2036. conf, e := models.GetConfigByCode("tpl_msg_seller_mobile")
  2037. if e != nil {
  2038. err = errors.New("GetConfigByCode, Err: " + e.Error())
  2039. return
  2040. }
  2041. //如果用户没有设置消息提醒,而且销售的手机号也没有添加到配置中,那么就不推送模版消息
  2042. if countUser == 0 && !strings.Contains(conf.ConfigValue, sellerItemQy.Mobile) {
  2043. err = nil
  2044. return
  2045. }
  2046. var sourceMsg string
  2047. if source == 1 {
  2048. sourceMsg = "预约外呼"
  2049. } else if source == 2 {
  2050. sourceMsg = "设置会议提醒"
  2051. } else if source == 3 {
  2052. sourceMsg = "预约纪要"
  2053. } else if source == 4 {
  2054. sourceMsg = "活动报名"
  2055. }
  2056. openIdList, e := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  2057. if e != nil {
  2058. err = errors.New("GetUserRecordListByMobile, Err: " + e.Error())
  2059. return err
  2060. }
  2061. var keyword1 string
  2062. var keyword2 string
  2063. keyword1 = activityDetail.ActivityName
  2064. keyword2 = fmt.Sprint("互动:", sourceMsg, ",", user.RealName, "--", user.CompanyName)
  2065. SendWxMsgWithActivityUserRemind(keyword1, keyword2, openIdList, activityDetail.ActivityId)
  2066. return
  2067. }
  2068. // 用户专项调研操作行为,模板消息推送
  2069. func SpecialActivityUserRemind(user *models.WxUserItem, activityDetail *models.CygxActivitySpecialDetail, source int) (err error) {
  2070. defer func() {
  2071. if err != nil {
  2072. go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
  2073. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  2074. }
  2075. }()
  2076. countUser, err := models.GetUserRemind(user.UserId)
  2077. if err != nil {
  2078. return err
  2079. }
  2080. if countUser == 0 {
  2081. return err
  2082. }
  2083. var sourceMsg string
  2084. if source == 1 {
  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 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
  2101. keyword2 = activityDetail.ResearchTheme
  2102. SendWxMsgWithSpecialActivityUserRemind(keyword1, keyword2, openIdList, activityDetail.ActivityId)
  2103. }
  2104. return
  2105. }
  2106. //func init() {
  2107. // DoActivityOnenIdWxTemplateMsg()
  2108. //}
  2109. // 周日下午四点半推送全部活动
  2110. func DoActivityOnenIdWxTemplateMsg(cont context.Context) (err error) {
  2111. var msg string
  2112. defer func() {
  2113. if err != nil {
  2114. go utils.SendAlarmMsg("周日下午四点半推送全部活动失败,DoActivityOnenIdWxTemplateMsg ErrMsg:"+err.Error(), 2)
  2115. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "DoActivityOnenIdWxTemplateMsg ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  2116. fmt.Println(err)
  2117. }
  2118. if msg != "" {
  2119. utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
  2120. }
  2121. }()
  2122. var condition string
  2123. var pars []interface{}
  2124. openidPowerListMobile, err := models.GetCygxUserRecordPower(condition, pars)
  2125. if err != nil {
  2126. return err
  2127. }
  2128. var mobileArr []string
  2129. for _, v := range openidPowerListMobile {
  2130. mobileArr = append(mobileArr, v.Mobile)
  2131. }
  2132. openidPowerList, err := models.GetWxOpenIdByMobileSliceList(mobileArr)
  2133. if err != nil {
  2134. return err
  2135. }
  2136. first := "近期所有行业活动预告,欢迎参与"
  2137. keyword1 := "下周活动预告"
  2138. keyword2 := "已发布"
  2139. keyword3 := ""
  2140. keyword4 := "点击查看下周活动列表"
  2141. SendActivityOnenIdWxTemplateMsg(first, keyword1, keyword2, keyword3, keyword4, openidPowerList)
  2142. return
  2143. }
  2144. func ActivityButtonShow(item *models.ActivityDetail) (activityDetail *models.ActivityDetail) {
  2145. if item.ChartPermissionId == utils.CHART_PERMISSION_ID_YANXUAN {
  2146. item.IsResearch = true
  2147. }
  2148. activityDetail = item
  2149. //IsShowAppointment bool `description:"是否展示预约纪要"`
  2150. //IsShowOutboundCall bool `description:"是否展示预约外呼"`
  2151. //IsShowMeetingReminder bool `description:"是否展示会议提醒"`
  2152. //IsShowHelpSsk bool `description:"是否展示帮我带问"`
  2153. //IsShowSignup bool `description:"是否展示我要报名"`
  2154. activityTypeIdMap := GetActivityTypeIdMap()
  2155. activityDetail.ActivityType = activityTypeIdMap[activityDetail.ActivityTypeId] // 线上还是线下
  2156. activityPointsByUserAllMap := GetActivityPointsByUserAllMap() // 获取对用户进行研选扣点的活动
  2157. activityDetail.IsResearchPoints = activityPointsByUserAllMap[activityDetail.ActivityId]
  2158. if activityDetail.SiginupDeadline == utils.FormatDateTimeInit { //报名截止时间处理
  2159. activityDetail.SiginupDeadline = ""
  2160. }
  2161. //如果报名截止时间不规范,或者是非研选扣点活动就把截止时间设置为空
  2162. if activityDetail.CancelDeadline == utils.FormatDateTimeInit || !activityDetail.IsResearchPoints {
  2163. activityDetail.CancelDeadline = ""
  2164. }
  2165. activityTimeText := activityDetail.ActivityTimeText
  2166. activityTimeText = strings.Replace(activityTimeText, "(", "(", -1)
  2167. activityTimeText = strings.Replace(activityTimeText, ")", ")", -1)
  2168. activityDetail.ActivityTimeText = activityTimeText
  2169. if activityDetail.SourceType != 2 {
  2170. activityDetail.SourceType = 1
  2171. }
  2172. activityDetail.IsShowAppointment = false
  2173. //易董的操作按钮都隐藏
  2174. if activityDetail.YidongActivityId != "" {
  2175. activityDetail.SourceType = 1
  2176. activityDetail.IsShowSignup = false
  2177. activityDetail.IsShowDetails = true
  2178. activityDetail.IsExternalLabel = true
  2179. activityDetail.IsResearch = false
  2180. activityDetail.IsResearchSpecial = false
  2181. return
  2182. }
  2183. //专家电话会 1
  2184. if activityDetail.ActivityTypeId == 1 && activityDetail.IsLimitPeople == 0 && (activityDetail.ActiveState == "1" || activityDetail.ActiveState == "2") {
  2185. activityDetail.IsShowHelpSsk = true
  2186. }
  2187. //新的是否展示规则
  2188. if activityDetail.IsCanAppointmentMinutes == 1 {
  2189. activityDetail.IsShowAppointment = true
  2190. } else {
  2191. activityDetail.IsShowAppointment = false
  2192. }
  2193. if activityDetail.ActiveState == "1" {
  2194. //专家电话会 1
  2195. //专家电话会限制人数的展示我要报名,不限制的展示预约外外呼
  2196. if activityDetail.ActivityTypeId == 1 {
  2197. //articleDetail.IsShowOutboundCall = true
  2198. if activityDetail.LimitPeopleNum == 0 {
  2199. activityDetail.IsShowOutboundCall = true
  2200. //articleDetail.IsShowHelpSsk = true
  2201. } else {
  2202. activityDetail.IsShowSignup = true
  2203. }
  2204. activityDetail.IsShowMeetingReminder = true
  2205. activityDetail.IsShowHelpSsk = true
  2206. }
  2207. //分析师电话会 2
  2208. if activityDetail.ActivityTypeId == 2 {
  2209. if activityDetail.LimitPeopleNum == 0 {
  2210. activityDetail.IsShowOutboundCall = true
  2211. //articleDetail.IsShowHelpSsk = true
  2212. } else {
  2213. activityDetail.IsShowSignup = true
  2214. }
  2215. activityDetail.IsShowMeetingReminder = true
  2216. }
  2217. //公司调研电话会 3
  2218. if activityDetail.ActivityTypeId == 3 {
  2219. if activityDetail.IsResearchPoints || activityDetail.LimitPeopleNum > 0 {
  2220. activityDetail.IsShowSignup = true
  2221. } else {
  2222. activityDetail.IsShowMeetingReminder = true
  2223. activityDetail.IsShowOutboundCall = true
  2224. }
  2225. }
  2226. //公司线下调研 4
  2227. if activityDetail.ActivityTypeId == 4 {
  2228. activityDetail.IsShowSignup = true
  2229. }
  2230. //专家线下沙龙 5
  2231. if activityDetail.ActivityTypeId == 5 {
  2232. activityDetail.IsShowSignup = true
  2233. }
  2234. //分析师线下沙龙 6
  2235. if activityDetail.ActivityTypeId == 6 {
  2236. activityDetail.IsShowSignup = true
  2237. }
  2238. //分析师电话会(C类) 7
  2239. if activityDetail.ActivityTypeId == 7 {
  2240. activityDetail.IsShowSignup = true
  2241. activityDetail.IsShowMeetingReminder = true
  2242. activityDetail.ActivityTypeName = "分析师电话会"
  2243. }
  2244. //买方线下交流 8 // 查研观向 11.0
  2245. if activityDetail.ActivityTypeId == 8 {
  2246. activityDetail.IsShowSignup = true
  2247. }
  2248. }
  2249. //如果是易董创建的活动,展示我要报名,不展示预约外呼
  2250. if activityDetail.IsYidongConduct {
  2251. activityDetail.IsShowSignup = true
  2252. activityDetail.IsShowOutboundCall = false
  2253. }
  2254. return
  2255. }
  2256. func ActivityArrButtonShow(items []*models.ActivityDetail) (activityDetails []*models.ActivityDetail) {
  2257. activityPointsByUserAllMap := GetActivityPointsByUserAllMap() // 获取对用户进行研选扣点的活动
  2258. activityTypeIdMap := GetActivityTypeIdMap()
  2259. for _, activityDetail := range items {
  2260. activityDetail.ActivityType = activityTypeIdMap[activityDetail.ActivityTypeId] // 线上还是线下
  2261. if activityDetail.ChartPermissionId == utils.CHART_PERMISSION_ID_YANXUAN {
  2262. activityDetail.IsResearch = true
  2263. }
  2264. //勾选【研选扣点】且扣点对象为参会人的活动,需要有买方研选的正式权限
  2265. if strings.Contains(activityDetail.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) && activityPointsByUserAllMap[activityDetail.ActivityId] {
  2266. activityDetail.IsResearchSpecial = true
  2267. }
  2268. //IsShowAppointment bool `description:"是否展示预约纪要"`
  2269. //IsShowOutboundCall bool `description:"是否展示预约外呼"`
  2270. //IsShowMeetingReminder bool `description:"是否展示会议提醒"`
  2271. //IsShowHelpSsk bool `description:"是否展示帮我带问"`
  2272. //IsShowSignup bool `description:"是否展示我要报名"`
  2273. activityDetail.IsResearchPoints = activityPointsByUserAllMap[activityDetail.ActivityId]
  2274. if activityDetail.SiginupDeadline == utils.FormatDateTimeInit { //报名截止时间处理
  2275. activityDetail.SiginupDeadline = ""
  2276. }
  2277. //如果报名截止时间不规范,或者是非研选扣点活动就把截止时间设置为空
  2278. if activityDetail.CancelDeadline == utils.FormatDateTimeInit || !activityDetail.IsResearchPoints {
  2279. activityDetail.CancelDeadline = ""
  2280. }
  2281. activityTimeText := activityDetail.ActivityTimeText
  2282. activityTimeText = strings.Replace(activityTimeText, "(", "(", -1)
  2283. activityTimeText = strings.Replace(activityTimeText, ")", ")", -1)
  2284. activityDetail.ActivityTimeText = activityTimeText
  2285. if activityDetail.SourceType != 2 {
  2286. activityDetail.SourceType = 1
  2287. }
  2288. activityDetail.IsShowAppointment = false
  2289. //易董的操作按钮都隐藏
  2290. if activityDetail.YidongActivityId != "" {
  2291. activityDetail.SourceType = 1
  2292. activityDetail.IsShowSignup = false
  2293. activityDetail.IsShowDetails = true
  2294. } else {
  2295. //专家电话会 1
  2296. if activityDetail.ActivityTypeId == 1 && activityDetail.IsLimitPeople == 0 && (activityDetail.ActiveState == "1" || activityDetail.ActiveState == "2") {
  2297. activityDetail.IsShowHelpSsk = true
  2298. }
  2299. //新的是否展示规则
  2300. if activityDetail.IsCanAppointmentMinutes == 1 {
  2301. activityDetail.IsShowAppointment = true
  2302. } else {
  2303. activityDetail.IsShowAppointment = false
  2304. }
  2305. if activityDetail.ActiveState == "1" {
  2306. //专家电话会 1
  2307. //专家电话会限制人数的展示我要报名,不限制的展示预约外外呼
  2308. if activityDetail.ActivityTypeId == 1 {
  2309. //articleDetail.IsShowOutboundCall = true
  2310. if activityDetail.LimitPeopleNum == 0 {
  2311. activityDetail.IsShowOutboundCall = true
  2312. //articleDetail.IsShowHelpSsk = true
  2313. } else {
  2314. activityDetail.IsShowSignup = true
  2315. }
  2316. activityDetail.IsShowMeetingReminder = true
  2317. activityDetail.IsShowHelpSsk = true
  2318. }
  2319. //分析师电话会 2
  2320. if activityDetail.ActivityTypeId == 2 {
  2321. if activityDetail.LimitPeopleNum == 0 {
  2322. activityDetail.IsShowOutboundCall = true
  2323. //articleDetail.IsShowHelpSsk = true
  2324. } else {
  2325. activityDetail.IsShowSignup = true
  2326. }
  2327. activityDetail.IsShowMeetingReminder = true
  2328. }
  2329. //公司调研电话会 3
  2330. if activityDetail.ActivityTypeId == 3 {
  2331. if activityDetail.IsResearchPoints || activityDetail.LimitPeopleNum > 0 {
  2332. activityDetail.IsShowSignup = true
  2333. } else {
  2334. activityDetail.IsShowMeetingReminder = true
  2335. activityDetail.IsShowOutboundCall = true
  2336. }
  2337. }
  2338. //公司线下调研 4
  2339. if activityDetail.ActivityTypeId == 4 {
  2340. activityDetail.IsShowSignup = true
  2341. }
  2342. //专家线下沙龙 5
  2343. if activityDetail.ActivityTypeId == 5 {
  2344. activityDetail.IsShowSignup = true
  2345. }
  2346. //分析师线下沙龙 6
  2347. if activityDetail.ActivityTypeId == 6 {
  2348. activityDetail.IsShowSignup = true
  2349. }
  2350. //分析师电话会(C类) 7
  2351. if activityDetail.ActivityTypeId == 7 {
  2352. activityDetail.IsShowSignup = true
  2353. activityDetail.IsShowMeetingReminder = true
  2354. activityDetail.ActivityTypeName = "分析师电话会"
  2355. }
  2356. //买方线下交流 8 // 查研观向 11.0
  2357. if activityDetail.ActivityTypeId == 8 {
  2358. activityDetail.IsShowSignup = true
  2359. }
  2360. }
  2361. //如果是易董创建的活动,展示我要报名,不展示预约外呼
  2362. if activityDetail.IsYidongConduct {
  2363. activityDetail.IsShowSignup = true
  2364. activityDetail.IsShowOutboundCall = false
  2365. }
  2366. }
  2367. //如果是易董同步过来的,只展示外部资源标签
  2368. if activityDetail.YidongActivityId != "" {
  2369. activityDetail.IsExternalLabel = true
  2370. activityDetail.IsResearch = false
  2371. activityDetail.IsResearchSpecial = false
  2372. }
  2373. activityDetails = append(activityDetails, activityDetail)
  2374. }
  2375. return
  2376. }
  2377. // GetActivityNewLabelMap 获取活动【新】标签Map
  2378. func GetActivityNewLabelMap(activityIds []int) (labelMap map[int]bool, industryNewMap map[int]bool, err error) {
  2379. labelMap = make(map[int]bool, 0)
  2380. industryNewMap = make(map[int]bool, 0)
  2381. if len(activityIds) == 0 {
  2382. return
  2383. }
  2384. // 获取活动关联的产业
  2385. var groupCond string
  2386. var groupPars []interface{}
  2387. groupCond += ` AND a.activity_id IN (` + utils.GetOrmInReplace(len(activityIds)) + `) AND b.source = 1 `
  2388. groupPars = append(groupPars, activityIds)
  2389. groups, e := models.GetActivityIndustryRelationList(groupCond, groupPars)
  2390. if e != nil {
  2391. err = errors.New("获取活动产业关联列表失败, Err: " + e.Error())
  2392. return
  2393. }
  2394. activityIndustryMap := make(map[int][]int, 0)
  2395. industryIds := make([]int, 0)
  2396. for i := range groups {
  2397. industryIds = append(industryIds, groups[i].IndustrialManagementId)
  2398. activityIndustryMap[groups[i].ActivityId] = append(activityIndustryMap[groups[i].ActivityId], groups[i].IndustrialManagementId)
  2399. }
  2400. // 获取新产业Map
  2401. industryLabelMap, e := GetIndustryNewLabelMap(industryIds)
  2402. if e != nil {
  2403. err = errors.New("获取产业新标签Map失败, Err: " + e.Error())
  2404. return
  2405. }
  2406. // 判断活动是否为新
  2407. for k := range industryLabelMap {
  2408. for k2, v2 := range activityIndustryMap {
  2409. if labelMap[k2] {
  2410. continue
  2411. }
  2412. // 活动的产业ID中存在一个新产业即为新活动
  2413. if utils.InArrayByInt(v2, k) {
  2414. labelMap[k2] = true
  2415. }
  2416. }
  2417. }
  2418. ////产业关联的弘则报告发布日期在三个月以内的活动、产业显示 NEW标签
  2419. //articNewLabel, e := GetArticNewLabelWhithActivity3Month()
  2420. //if e != nil {
  2421. // err = errors.New("获取产业新标签Map失败, Err: " + e.Error())
  2422. // return
  2423. //}
  2424. //for k := range articNewLabel {
  2425. // labelMap[k] = true
  2426. //}
  2427. return
  2428. }
  2429. // GetActivityVoiceResp 处理活动音频回放
  2430. func GetActivityVoiceResp(mapActivityId []int) (mapItem map[int]*models.CygxActivityVoiceReq, err error) {
  2431. activityVoiceList, err := models.GetCygxActivityVoiceReqList(mapActivityId)
  2432. if err != nil && err.Error() != utils.ErrNoRow() {
  2433. return
  2434. }
  2435. mapActivityVoice := make(map[int]*models.CygxActivityVoiceReq)
  2436. if len(activityVoiceList) > 0 {
  2437. for _, v := range activityVoiceList {
  2438. mapActivityVoice[v.ActivityId] = v
  2439. }
  2440. }
  2441. mapItem = mapActivityVoice
  2442. return
  2443. }
  2444. // AddActivitykeyWordSearch 添加活动搜索记录
  2445. func AddActivitykeyWordSearch(keyWordSearch string, user *models.WxUserItem) {
  2446. if keyWordSearch != "" {
  2447. keyWordItem := new(models.CygxUserSearchKeyWord)
  2448. keyWordItem.UserId = user.UserId
  2449. keyWordItem.KeyWord = keyWordSearch
  2450. keyWordItem.PageType = "ActivitSearch"
  2451. keyWordItem.CreateTime = time.Now()
  2452. go models.AddUserSearchKeyWord(keyWordItem)
  2453. }
  2454. }
  2455. // GetActivityVideoResp 处理活动视频频回放
  2456. func GetActivityVideoResp(mapActivityId []int) (mapItem map[int]*models.CygxActivityVideoListResp, err error) {
  2457. var condition string
  2458. var ativityVIdstr string
  2459. for _, v := range mapActivityId {
  2460. ativityVIdstr += strconv.Itoa(v) + ","
  2461. }
  2462. if ativityVIdstr == "" {
  2463. return
  2464. }
  2465. ativityVIdstr = strings.TrimRight(ativityVIdstr, ",")
  2466. condition += ` AND art.activity_id IN (` + ativityVIdstr + `) `
  2467. var pars []interface{}
  2468. //endTime := time.Now().AddDate(0, 0, -30).Format("2006-01-02 15:04:05")
  2469. //condition += ` AND art.activity_time > ? `
  2470. //pars = append(pars, endTime)
  2471. videoList, e := models.GetActivityVideoListAll(condition, pars, 0, 1000)
  2472. if e != nil && e.Error() != utils.ErrNoRow() {
  2473. err = e
  2474. return
  2475. }
  2476. mapActivityVideo := make(map[int]*models.CygxActivityVideoListResp)
  2477. if len(videoList) > 0 {
  2478. for _, v := range videoList {
  2479. mapActivityVideo[v.ActivityId] = v
  2480. }
  2481. }
  2482. mapItem = mapActivityVideo
  2483. return
  2484. }
  2485. // 用户音视频回放操作操作行为,模板消息推送
  2486. func ActivityVideoUserRmind(user *models.WxUserItem, activityId, fileType int) (err error) {
  2487. defer func() {
  2488. if err != nil {
  2489. go utils.SendAlarmMsg("用户音视频回放操作操作行为,模板消息推送失败"+err.Error(), 2)
  2490. }
  2491. }()
  2492. countUser, err := models.GetUserRemind(user.UserId)
  2493. if err != nil {
  2494. return err
  2495. }
  2496. if countUser == 0 {
  2497. return err
  2498. }
  2499. var first string
  2500. var keyword1 string
  2501. var keyword2 string
  2502. var keyword3 string
  2503. var keyword4 string
  2504. var remark string
  2505. //获取销售手机号
  2506. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  2507. if err != nil && err.Error() != utils.ErrNoRow() {
  2508. return err
  2509. }
  2510. if sellerItemQy != nil {
  2511. openIdList, e := models.GetWxOpenIdByMobileList(sellerItemQy.Mobile)
  2512. if e != nil {
  2513. err = errors.New("GetSellerByAdminId, Err: " + e.Error())
  2514. return
  2515. }
  2516. //TripStatus int `description:"行程进行状态 1:预报名,2:确定行程"`
  2517. if fileType == 1 {
  2518. activityInfo, e := models.GetCygxActivityVideoByActivityId(activityId)
  2519. if e != nil {
  2520. err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
  2521. return
  2522. }
  2523. if activityInfo == nil {
  2524. return
  2525. }
  2526. keyword1 = activityInfo.VideoName
  2527. keyword2 = fmt.Sprint("互动:播放视频,", user.RealName, "--", user.CompanyName)
  2528. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:播放视频")
  2529. } else {
  2530. activityInfo, e := models.GetCygxActivityVoiceByActivityId(activityId)
  2531. if e != nil {
  2532. err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
  2533. return
  2534. }
  2535. if activityInfo == nil {
  2536. return
  2537. }
  2538. keyword1 = activityInfo.VoiceName
  2539. keyword2 = fmt.Sprint("互动:播放音频,", user.RealName, "--", user.CompanyName)
  2540. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:播放音频")
  2541. }
  2542. //keyword2 = "__"
  2543. //remark = "点击查看活动详情"
  2544. openIdArr := make([]string, 0)
  2545. for _, v := range openIdList {
  2546. openIdArr = append(openIdArr, v.OpenId)
  2547. }
  2548. redirectUrl := utils.WX_MSG_PATH_ACTIVITY_SPECIAL_DETAIL + strconv.Itoa(activityId)
  2549. sendInfo := new(SendWxTemplate)
  2550. sendInfo.First = first
  2551. sendInfo.Keyword1 = keyword1
  2552. sendInfo.Keyword2 = keyword2
  2553. sendInfo.Keyword3 = keyword3
  2554. sendInfo.Keyword4 = keyword4
  2555. sendInfo.Remark = remark
  2556. sendInfo.TemplateId = utils.WxMsgTemplateIdArticleUserRemind
  2557. sendInfo.RedirectUrl = redirectUrl
  2558. sendInfo.RedirectTarget = 3
  2559. sendInfo.Resource = strconv.Itoa(activityId)
  2560. sendInfo.SendType = utils.TEMPLATE_MSG_CYGX_ARTICLE_ADD
  2561. sendInfo.OpenIdArr = openIdArr
  2562. err = PublicSendTemplateMsg(sendInfo)
  2563. if err != nil {
  2564. return
  2565. }
  2566. }
  2567. return
  2568. }
  2569. // 解析活动填写的报告链接
  2570. func GetActivityReportLinkToArticleList(item *models.ActivityDetail) (items []*models.ActivityArticleResp, err error) {
  2571. reportLink := item.ReportLink
  2572. //处理活动的
  2573. var articleIds []int
  2574. var articleList []string
  2575. if strings.Contains(reportLink, ";") {
  2576. articleList = strings.Split(reportLink, ";")
  2577. } else {
  2578. articleList = strings.Split(reportLink, ";")
  2579. }
  2580. for _, v := range articleList {
  2581. linkList := strings.Split(v, "/")
  2582. if linkList[len(linkList)-1] != "" {
  2583. linkArticleId, _ := strconv.Atoi(linkList[len(linkList)-1])
  2584. articleIds = append(articleIds, linkArticleId)
  2585. }
  2586. }
  2587. lenarticleIds := len(articleIds)
  2588. if lenarticleIds == 0 {
  2589. return
  2590. }
  2591. var condition string
  2592. var pars []interface{}
  2593. pars = make([]interface{}, 0)
  2594. condition = ` AND a.article_id IN (` + utils.GetOrmInReplace(lenarticleIds) + `)`
  2595. pars = append(pars, articleIds)
  2596. listArticle, e := models.GetHomeList(condition, pars, 0, len(articleIds))
  2597. if e != nil {
  2598. err = errors.New("GetResourceDataList, Err: " + e.Error())
  2599. return
  2600. }
  2601. if len(listArticle) > 0 {
  2602. for _, v := range listArticle {
  2603. artItem := new(models.ActivityArticleResp)
  2604. artItem.ArticleId = v.ArticleId
  2605. artItem.Title = v.Title
  2606. items = append(items, artItem)
  2607. }
  2608. }
  2609. return
  2610. }
  2611. // GetActivityCityResp 获取活动关联城市,当同一个活动标签对应多个城市的时候,展示最近举办的活动
  2612. func GetActivityCityResp() (mapItem map[string]string, err error) {
  2613. activityList, err := models.GetActivityLabelListCity()
  2614. if err != nil && err.Error() != utils.ErrNoRow() {
  2615. return
  2616. }
  2617. mapActivityCity := make(map[string]string)
  2618. if len(activityList) > 0 {
  2619. for _, v := range activityList {
  2620. if v.ActivityTypeId == utils.C_CLASS_ACTIVITY_TYPE_ID {
  2621. v.ActivityTypeId = utils.ANALYST_TELL_ACTIVITY_TYPE_ID
  2622. }
  2623. //如果城市民称长度大于2,那么就不显示
  2624. if utf8.RuneCountInString(v.City) != 2 || mapActivityCity[fmt.Sprint(v.Label, "{|}", v.ActivityTypeId)] != "" {
  2625. continue
  2626. }
  2627. mapActivityCity[fmt.Sprint(v.Label, "{|}", v.ActivityTypeId)] = v.City
  2628. }
  2629. }
  2630. mapItem = mapActivityCity
  2631. return
  2632. }
  2633. // UpdateIsSendYidongSignUp更改活动是否向易董推送报名名单的状态
  2634. func UpdateIsSendYidongSignUp(activityId int) (err error) {
  2635. defer func() {
  2636. if err != nil {
  2637. fmt.Println(err)
  2638. go utils.SendAlarmMsg("更改活动是否向易董推送报名名单的状态,失败,活动ID:"+strconv.Itoa(activityId)+err.Error(), 2)
  2639. }
  2640. }()
  2641. err = models.UPdateSendedYiDongSignUp(activityId)
  2642. return
  2643. }
  2644. // 获取活动线上还是线下的类型
  2645. func GetActivityTypeIdMap() (mapResp map[int]int) {
  2646. var err error
  2647. defer func() {
  2648. if err != nil {
  2649. fmt.Println(err)
  2650. go utils.SendAlarmMsg("获取活动线上还是线下的类型,失败,GetActivityTypeIdMap:Err "+err.Error(), 2)
  2651. }
  2652. }()
  2653. list, e := models.GetActivityTypeList("")
  2654. if e != nil {
  2655. err = errors.New("GetActivityTypeList, Err: " + e.Error())
  2656. return
  2657. }
  2658. mapResp = make(map[int]int, 0)
  2659. for _, v := range list {
  2660. mapResp[v.ActivityTypeId] = v.ActivityType
  2661. }
  2662. return
  2663. }