activity.go 97 KB

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