123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899 |
- package services
- import (
- "context"
- "errors"
- "fmt"
- "github.com/tealeg/xlsx"
- "hongze/hongze_cygx/models"
- "hongze/hongze_cygx/utils"
- "os"
- "path/filepath"
- "strconv"
- "strings"
- "time"
- "unicode/utf8"
- )
- // 修改活动状态
- func UpdateActivitySattus(cont context.Context) (err error) {
- //defer func() {
- // if err != nil {
- // fmt.Println("同步失败,Err:", err.Error())
- // }
- //}()
- go models.UpdateActivitySattusToHaveInHand()
- go models.UpdateActivitySattusToComplete()
- return
- }
- // 推送会议开始消息提醒60分钟前
- func SendActivityBeginMsg(cont context.Context) (err error) {
- defer func() {
- if err != nil {
- go utils.SendAlarmMsg("60分钟会议消息提醒失败", 2)
- fmt.Println("发送失败,Err:", err.Error())
- }
- }()
- endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
- listActivity, err := models.GetActivitySendMsgListAll(endDate)
- fmt.Println(len(listActivity))
- if err != nil {
- fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
- return
- }
- if len(listActivity) == 0 {
- return
- }
- var remark = "点击查看活动详情"
- var signupIds string
- for _, v := range listActivity {
- signupIds += strconv.Itoa(v.Id) + ","
- var reserveResults string
- var first string
- openIdItem := new(models.OpenIdList)
- openIdItem.OpenId = v.OpenId
- openIdItem.UserId = v.UserId
- openIdList := make([]*models.OpenIdList, 0)
- openIdList = append(openIdList, openIdItem)
- //if v.FailType == 0 {
- // reserveResults = "成功"
- //} else if v.FailType == 1 {
- // reserveResults = "失败(总人数已满)"
- //} else if v.FailType == 2 {
- // reserveResults = "失败(单机构超限制)"
- //} else if v.FailType == 3 {
- // reserveResults = "失败(爽约次数超限)"
- //}
- reserveResults = "--"
- first = "您有一场【" + v.ActivityTypeName + "】将在1小时后开始"
- SendWxMsgWithFrequency(first, v.ActivityName, reserveResults, v.ActivityTime, v.Address, remark, openIdList, v.ActivityId)
- }
- if len(signupIds) == 0 {
- return
- }
- signupIds = strings.TrimRight(signupIds, ",")
- err = models.UPdateSendedMsgStatus(signupIds)
- if err != nil {
- var msg string
- go utils.SendEmail("发送模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
- utils.FileLog.Info("发送模版消息失败,Err:%s", err.Error())
- }
- return
- }
- // 推送会议开始消息提醒15分钟前
- func SendActivityBeginMsgMeeting(cont context.Context) (err error) {
- defer func() {
- if err != nil {
- go utils.SendAlarmMsg("15分钟会议消息提醒失败", 2)
- fmt.Println("发送失败,Err:", err.Error())
- }
- }()
- endDate := time.Now().Add(+time.Minute * 15).Format(utils.FormatDateTime)
- listActivity, err := models.GetActivitySendMsgListAllMeeting(endDate)
- if err != nil {
- fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
- return
- }
- if len(listActivity) == 0 {
- return
- }
- var signupIds string
- var remark = "点击查看活动详情"
- for _, v := range listActivity {
- signupIds += strconv.Itoa(v.Id) + ","
- var reserveResults string
- var first string
- openIdItem := new(models.OpenIdList)
- openIdItem.OpenId = v.OpenId
- openIdItem.UserId = v.UserId
- openIdList := make([]*models.OpenIdList, 0)
- openIdList = append(openIdList, openIdItem)
- reserveResults = "--"
- first = "您有一场【" + v.ActivityTypeName + "】将在15分钟后开始"
- SendWxMsgWithFrequency(first, v.ActivityName, reserveResults, v.ActivityTime, "--", remark, openIdList, v.ActivityId)
- }
- if len(signupIds) == 0 {
- return
- }
- signupIds = strings.TrimRight(signupIds, ",")
- err = models.UPdateSendedMsgMeetingStatus(signupIds)
- if err != nil {
- var msg string
- go utils.SendEmail("发送模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
- utils.FileLog.Info("发送模版消息失败,Err:%s", err.Error())
- }
- return
- }
- // 预约外呼名单,会前1小时自动发送邮件给专家组
- func SendEmailFileToExpert(cont context.Context) (err error) {
- var msg string
- var touser string
- defer func() {
- if err != nil {
- fmt.Println("err:", err)
- go utils.SendAlarmMsg("发送附件模版消息失败", 2)
- go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
- utils.FileLog.Info("发送附件模版消息失败,Err:%s", err.Error())
- }
- if msg != "" {
- fmt.Println(msg)
- utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
- }
- }()
- endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
- total, err := models.GetCountActivityIdToSendFile(endDate)
- if total == 0 {
- fmt.Println("发送附件完成0")
- return nil
- }
- if err != nil {
- msg = "发送附件模版消息失败 Err:" + err.Error()
- return
- }
- listActivity, err := models.GetActivityIdToSendFile(endDate)
- if err != nil {
- msg = "发送附件模版消息失败 Err:" + err.Error()
- return
- }
- for _, v := range listActivity {
- time.Sleep(5 * time.Second) //延时五秒,避免邮件发送不成功
- activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
- if activityInfo == nil {
- msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
- return
- }
- list, errFile := models.GetSignupExport(v.ActivityId)
- if errFile != nil {
- msg = "获取失败,Err:" + errFile.Error()
- return
- }
- //创建excel
- dir, errFile := os.Executable()
- exPath := filepath.Dir(dir)
- downLoadnFilePath := exPath + "/" + time.Now().Format(utils.FormatDateTimeUnSpace) + utils.GetRandDigit(5) + ".xlsx"
- xlsxFile := xlsx.NewFile()
- if errFile != nil {
- msg = "生成文件失败Err:" + errFile.Error()
- return
- }
- style := xlsx.NewStyle()
- alignment := xlsx.Alignment{
- Horizontal: "center",
- Vertical: "center",
- WrapText: true,
- }
- style.Alignment = alignment
- style.ApplyAlignment = true
- sheet, errFile := xlsxFile.AddSheet("外呼名单")
- if errFile != nil {
- msg = "新增Sheet失败,Err:" + errFile.Error()
- return
- }
- //设置宽度
- _ = sheet.SetColWidth(1, 1, 15)
- _ = sheet.SetColWidth(3, 3, 30)
- //标头
- rowTitle := sheet.AddRow()
- cellA := rowTitle.AddCell()
- cellA.Value = "姓名"
- cellB := rowTitle.AddCell()
- cellB.Value = "外呼号码"
- cellC := rowTitle.AddCell()
- cellC.Value = "国际代码"
- cellD := rowTitle.AddCell()
- cellD.Value = "公司名称"
- cellE := rowTitle.AddCell()
- cellE.Value = "所属销售"
- for _, item := range list {
- row := sheet.AddRow()
- cellA := row.AddCell()
- cellA.Value = item.RealName
- cellB := row.AddCell()
- cellB.Value = item.OutboundMobile
- cellC := row.AddCell()
- if item.CountryCode == "" {
- cellC.Value = "86"
- } else {
- cellC.Value = item.CountryCode
- }
- cellD := row.AddCell()
- cellD.Value = item.CompanyName
- cellE := row.AddCell()
- cellE.Value = item.SellerName
- }
- errFile = xlsxFile.Save(downLoadnFilePath)
- if errFile != nil {
- msg = "保存文件失败Err:" + errFile.Error()
- return
- }
- title := activityInfo.ActivityName + "外呼名单"
- content := "外呼名单详情"
- fileName := downLoadnFilePath
- if activityInfo.ChartPermissionName == "科技" {
- touser = utils.EmailTechnology
- } else if activityInfo.ChartPermissionName == "医药" {
- touser = utils.EmailMedicine
- } else if activityInfo.ChartPermissionName == "消费" {
- touser = utils.EmailConsumption
- } else if activityInfo.ChartPermissionName == "智造" {
- touser = utils.EmailZhizao
- } else if activityInfo.ChartPermissionName == "策略" {
- touser = utils.EmailStrategy
- } else if strings.Contains(activityInfo.ChartPermissionName, "研选") {
- touser = utils.EmailExpert
- }
- sendResult := utils.SendEmailByHongze(title, content, touser, fileName, title+".xlsx")
- if sendResult {
- errFile = models.UPdateActivityIdToSendFile(v.ActivityId)
- if errFile != nil {
- msg = "获取失败,Err:" + errFile.Error()
- return
- }
- os.Remove(downLoadnFilePath)
- } else {
- go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+activityInfo.ActivityName, utils.EmailSendToUsers)
- utils.FileLog.Info("发送附件模版消息失败,Err:%s", activityInfo.ActivityName)
- }
- }
- return
- }
- func EditOutboundMobile(cont context.Context) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("发送失败,Err:", err.Error())
- }
- }()
- list, err := models.GetActivitySignupListAll()
- if err != nil {
- fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
- return
- }
- for _, v := range list {
- err = models.UPdateSignup(v)
- fmt.Println("修改:", strconv.Itoa(v.Id))
- if err != nil {
- fmt.Println("发送失败,Err:", err.Error()+strconv.Itoa(v.Id))
- }
- }
- fmt.Println("修改完成")
- return
- }
- // 同步用户绑定手机号以及区号
- func EditUserOutboundMobile(cont context.Context) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("发送失败,Err:", err.Error())
- }
- }()
- list, err := models.GetUserListAll()
- if err != nil {
- fmt.Println("GetActivitySendMsgListAll Err:", err.Error())
- return
- }
- for _, v := range list {
- err = models.UPdateUserCountryCode(v)
- fmt.Println("修改:", strconv.Itoa(v.UserId))
- if err != nil {
- fmt.Println("发送失败,Err:", err.Error()+strconv.Itoa(v.UserId))
- }
- }
- fmt.Println("修改完成")
- return
- }
- // 获取 用户类型 //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户;6、冻结客户;7、流失客户
- func GetUserType(companyId int) (userType int, permissionStrnew string, err error) {
- var permissionStr, permissionZhengShiStr string
- if companyId <= 1 {
- userType = 0
- } else {
- total, errs := models.GetCountCompanyDetailByIdGroup(companyId)
- if errs != nil {
- err = errs
- return
- }
- if total == 0 {
- userType = 0
- } else {
- companyDetail, errs := models.GetCompanyDetailByIdGroup(companyId)
- if errs != nil {
- err = errs
- return
- }
- permissionStr, errs = models.GetCompanyPermissionByUser(companyId)
- if errs != nil {
- err = errs
- return
- }
- permissionZhengShiStr, errs = models.GetCompanyPermissionByUserZhengShi(companyId)
- if errs != nil {
- err = errs
- return
- }
- //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户
- //大套餐客户定义:医药、消费、科技、智造、策略。5个行业中任意4个及以上是正式权限的,属于大套餐客户(医药、消费、科技、智造需要主客观都开)
- if companyDetail.Status == "永续" {
- userType = 1
- } else if companyDetail.Status == "试用" {
- userType = 5
- } else if companyDetail.Status == "正式" {
- if permissionStr == "专家" {
- userType = 4
- } else if strings.Count(permissionZhengShiStr, "医药") == 2 && strings.Count(permissionZhengShiStr, "消费") == 2 && strings.Count(permissionZhengShiStr, "科技") == 2 && strings.Count(permissionZhengShiStr, "智造") == 2 {
- userType = 2
- } else {
- userType = 3
- }
- if userType == 3 {
- if !strings.Contains(permissionStr, "医药") && !strings.Contains(permissionStr, "消费") && !strings.Contains(permissionStr, "科技") && !strings.Contains(permissionStr, "智造") {
- userType = 4
- }
- }
- } else if companyDetail.Status == "冻结" {
- userType = 6
- } else if companyDetail.Status == "流失" {
- userType = 7
- }
- //大套餐客户定义:医药、消费、科技、智造、策略。5个行业中任意4个及以上是正式权限的,属于大套餐客户(医药、消费、科技、智造需要主客观都开)
- if userType == 3 {
- var permissionZhegnshiNum int
- if strings.Count(permissionZhengShiStr, "医药") == 2 {
- permissionZhegnshiNum++
- }
- if strings.Count(permissionZhengShiStr, "消费") == 2 {
- permissionZhegnshiNum++
- }
- if strings.Count(permissionZhengShiStr, "科技") == 2 {
- permissionZhegnshiNum++
- }
- if strings.Count(permissionZhengShiStr, "智造") == 2 {
- permissionZhegnshiNum++
- }
- if strings.Count(permissionZhengShiStr, "策略") == 1 {
- permissionZhegnshiNum++
- }
- if permissionZhegnshiNum >= 4 {
- userType = 2
- }
- }
- }
- }
- permissionStrnew = permissionStr
- return
- }
- // 校验被分享的用户是否有查看详情的权限
- func GetShareNoPowe(activityInfo *models.ActivityDetail, permissionStr string, userType int, user *models.WxUserItem) (noPower bool, err error) {
- //如果是弘则的就不进行可见权限校验
- if user.CompanyId == utils.HZ_COMPANY_ID {
- return
- }
- //var noPower bool
- if (userType == 1 || userType == 4 || userType == 5) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(userType)) {
- noPower = true
- }
- //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户
- 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)) {
- noPower = true
- }
- if userType == 2 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(2)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
- noPower = true
- }
- if userType == 3 && strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(4)) {
- noPower = true
- }
- if userType == 3 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
- noPower = true
- }
- if !noPower {
- noPower, err = CheckUserPowerByActivityChoose(user, activityInfo)
- }
- return
- }
- // 处理活动本组们是否决策人权限
- func CheckUserPowerByActivityChoose(user *models.WxUserItem, activityInfo *models.ActivityDetail) (noPower bool, err error) {
- //处理 见范围 1,仅本组可见 、2,全部客户可见
- if activityInfo.VisibleRange == 1 {
- adminIds, errAdmin := models.GetSelleridWhichGroup(user.CompanyId, 2)
- if errAdmin != nil {
- err = errAdmin
- return
- }
- sliceAdminIds := strings.Split(adminIds, ",")
- var haveAdminId bool
- for _, v := range sliceAdminIds {
- if v == strconv.Itoa(activityInfo.AdminId) {
- haveAdminId = true
- }
- }
- if !haveAdminId {
- noPower = true
- }
- }
- //处理 是否仅决策人可见 0,否 、1,是
- if activityInfo.IsMakerShow == 1 {
- if user.IsMaker == 0 {
- noPower = true
- }
- }
- fmt.Println(noPower)
- return
- }
- // 校验用户报名的权限
- func GetHavePower(activityInfo *models.ActivityDetail, permissionStr, companyDetailStatus string, userType int) (havePower bool, err error) {
- // 查研观向7.4-宏观活动不作权限限制
- if activityInfo.ChartPermissionId == 1 {
- havePower = true
- return
- }
- if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3) && strings.Contains(permissionStr, "专家") && activityInfo.LimitPeopleNum == 0 {
- havePower = true
- } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "正式" && strings.Contains(activityInfo.CustomerTypeIds, "4") {
- havePower = true
- } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "试用" && strings.Contains(activityInfo.CustomerTypeIds, "5") {
- havePower = true
- //} else if strings.Contains(permissionStr, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(userType)) {
- // havePower = true
- //} else if strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
- // havePower = true
- } else if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3 || activityInfo.ActivityTypeId == 4 || activityInfo.ActivityTypeId == 5) && strings.Contains(permissionStr, "专家") {
- havePower = true
- }
- if activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 6 || activityInfo.ActivityTypeId == 7 {
- if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(主观)") {
- havePower = true
- }
- } else {
- if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(客观)") {
- havePower = true
- }
- }
- if (strings.Contains(activityInfo.ChartPermissionName, "研选") || activityInfo.ChartPermissionName == "策略") && strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
- havePower = true
- }
- //如果是易董的活动且属于研选类型,只要开通任何权限就可以查看详情
- if activityInfo.YidongActivityId != "" && permissionStr != "" && strings.Contains(activityInfo.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) {
- havePower = true
- }
- return
- }
- // 获取活动列表查询权限的SQL
- // @Param ChartPermissionIds query string false "行业id 多个用 , 隔开"
- // @Param ActivityTypeIds query string false "活动类型id 多个用 , 隔开"
- // @Param ActiveState query string false "活动进行状态 未开始:1、进行中2、已结束3"
- // @Param WhichDay query string false "哪一天 今天:1、明天:2,多个用 , 隔开"
- // @Param IsPower query int false "是否选择有权限行业 ,1是 0 否 默认0"
- // @Param Label query string false "搜索主题 多个用 , 隔开"
- // @Param PlayBack query int false "是否仅展示回放 1:是、0:否 默认0"
- // @Param KeyWord query string false "搜索关键词 多个用 , 隔开"
- // @Param ikType query int false "联想词类型 , 1不做联想,2,做除初始词的联想,3所有联想"
- func GetActivityonditionList(user *models.WxUserItem, activityTypeId, chartPermissionIds, whichDay, activeState, label string, isPower, source int, keyWord string, playBack, ikType int) (conditionActivity string, err error) {
- keyWordNoIk := keyWord
- adminIds, err := models.GetSelleridWhichGroup(user.CompanyId, 2)
- if err != nil {
- return
- }
- userType, permissionStr, err := GetUserType(user.CompanyId)
- if err != nil {
- return
- }
- //判断客户规模是否属于可见范围的活动
- companyProduct, err := models.GetCompanyProductDetail(user.CompanyId, 2)
- if err != nil && err.Error() != utils.ErrNoRow() {
- return
- }
- isMaker := user.IsMaker
- slicePer := strings.Split(permissionStr, ",")
- var permissionSqlStr string
- var permissionNameStr string
- for _, v := range slicePer {
- if userType == 1 {
- //研选权限处理
- if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
- permissionNameStr += "'" + v + "',"
- }
- } else {
- permissionNameStr += "'" + v + "',"
- }
- }
- permissionNameStr = strings.Replace(permissionNameStr, "(主观)", "", -1)
- permissionNameStr = strings.Replace(permissionNameStr, "(客观)", "", -1)
- permissionNameStr = strings.TrimRight(permissionNameStr, ",")
- // 查研观向7.4-始终查询宏观的权限(无论是否有权限)
- if permissionNameStr == `` {
- permissionNameStr = `'宏观'`
- } else {
- permissionNameStr += `, '宏观'`
- }
- var condition string
- var conditionAdmin string
- var conditionHz string // 弘则权限处理
- var sqlExport string // 专家权限处理
- permissionSqlStr = ` AND art.chart_permission_name IN (` + permissionNameStr + `)`
- sqlExport = ` AND (art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' `
- if userType == 2 {
- sqlExport += ` OR art.customer_type_ids LIKE '%3%' `
- }
- if (userType == 2 || userType == 3) && strings.Contains(permissionStr, "专家") {
- sqlExport += ` OR art.customer_type_ids LIKE '%4%' `
- }
- sqlExport += `) `
- // 如果是C类电话会就不展示内容,且合并到分析师电话会
- if activityTypeId != "" {
- if activityTypeId == strconv.Itoa(utils.ANALYST_TELL_ACTIVITY_TYPE_ID) {
- condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id IN (` + activityTypeId + "," + strconv.Itoa(utils.C_CLASS_ACTIVITY_TYPE_ID) + `)`
- } else {
- condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id IN (` + activityTypeId + `)`
- }
- }
- //主题
- if label != "" {
- condition = ` AND art.label LIKE '%` + label + `%' `
- }
- if isPower == 1 {
- condition += permissionSqlStr
- }
- //行业名称
- if len(chartPermissionIds) > 0 {
- condition += ` AND art.chart_permission_id IN (` + chartPermissionIds + `)`
- }
- //如果是PC的,则不看易董的
- if source == 1 {
- condition += ` AND art.yidong_activity_id = '' `
- }
- var conditionOr string
- if whichDay != "" {
- var startDate string
- var endDate string
- if whichDay == "1" {
- startDate = time.Now().Format(utils.FormatDate)
- endDate = startDate
- } else if whichDay == "2" {
- startDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
- endDate = startDate
- } else if whichDay == "3" {
- startDate = utils.GetNowWeekMonday().Format(utils.FormatDate)
- endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
- } else if whichDay == "4" {
- startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
- endDate = utils.GetLastWeekSunday().Format(utils.FormatDate)
- } else if whichDay == "5" {
- startDate = utils.GetNowMonthFirstDay().Format(utils.FormatDate)
- endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
- } else if whichDay == "6" {
- startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
- endDate = utils.GetLastMonthLastDay().Format(utils.FormatDate)
- } else if whichDay == "1,2" {
- startDate = time.Now().Format(utils.FormatDate)
- endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
- } else if whichDay == "3,4" {
- startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
- endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
- } else if whichDay == "5,6" {
- startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
- endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
- } else {
- startDate = time.Now().Format(utils.FormatDate)
- endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
- }
- condition += ` AND art.activity_time >= ` + "'" + startDate + " 00:00:00'"
- condition += ` AND art.activity_time <= ` + "'" + endDate + " 23:59:59'"
- }
- fmt.Println(keyWord)
- fmt.Println(keyWordNoIk)
- //有搜索条件传过来时,不判进行状态条件
- if keyWord != "" {
- if ikType == 2 || ikType == 3 {
- keyWordArr, e := GetIndustryMapNameSliceV3(keyWord)
- if e != nil {
- err = errors.New("获取分词失败,GetIndustryMapNameSliceV3, Err: " + keyWord + e.Error())
- return
- }
- keyWordArr = RemoveDuplicatesAndEmpty(keyWordArr)
- //var keywords string
- if len(keyWordArr) > 1 {
- if ikType == 2 {
- keyWord = KeyWordArrSqlRegexp(keyWordArr)
- condition += ` AND (art.label NOT LIKE '%` + keyWordNoIk + `%' AND art.activity_name NOT LIKE '%` + keyWordNoIk + `%' ) `
- } else if ikType == 3 {
- keyWord = KeyWordArrSqlRegexpAll(keyWordArr)
- }
- }
- }
- condition += ` AND (art.label REGEXP '` + keyWord + `' OR art.activity_name REGEXP '` + keyWord + `' ) `
- } else {
- if activeState != "" {
- // 默认查看未开始跟进行中
- if activeState == "1" {
- condition += ` AND art.active_state IN (1,2)`
- } else {
- condition += ` AND art.active_state IN (` + activeState + `)`
- }
- } else {
- condition += ` AND art.active_state IN (1,2)`
- }
- }
- if playBack == 1 {
- var pars []interface{}
- ativityVIdArry := make([]string, 0)
- voiceList, e := models.GetActivityVoiceListAll("", pars, 0, 1000)
- if e != nil && e.Error() != utils.ErrNoRow() {
- err = e
- return
- }
- for _, v := range voiceList {
- ativityVIdArry = append(ativityVIdArry, strconv.Itoa(v.ActivityId))
- }
- videoList, e := models.GetActivityVideoListAll("", pars, 0, 1000)
- if e != nil && e.Error() != utils.ErrNoRow() {
- err = e
- return
- }
- for _, v := range videoList {
- ativityVIdArry = append(ativityVIdArry, strconv.Itoa(v.ActivityId))
- }
- //活动音频,设置有效时间为30天,失效后该活动就不再支持音频回放。有效期起始时间为活动的开始时间
- //endTime := time.Now().AddDate(0, 0, -30).Format("2006-01-02 15:04:05")
- //condition += ` AND art.activity_time > '` + endTime + `' `
- if len(ativityVIdArry) > 0 {
- ativityVIdstr := strings.Join(ativityVIdArry, ",")
- condition += ` AND art.activity_id IN (` + ativityVIdstr + `) `
- }
- }
- //查询全部可见的数据(是否全部客户可见)
- //condition += ` AND art.visible_range != 1 AND art.publish_status = 1 `
- condition += ` AND art.publish_status = 1 `
- conditionHz = condition
- //活动仅决策人可见
- if isMaker == 0 {
- condition += ` AND art.is_maker_show = 0 `
- }
- conditionAdmin = condition + ` AND art.visible_range = 1 `
- condition += ` AND art.visible_range != 1 `
- if (userType == 2 || userType == 3 || userType == 4) && strings.Contains(permissionStr, "专家") {
- conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%4%' ` + condition + `) `
- }
- if (userType == 5) && strings.Contains(permissionStr, "专家") {
- conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%5%' ` + condition + `) `
- }
- if userType == 1 {
- conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + permissionSqlStr + `) `
- } else {
- conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
- }
- if userType == 6 || userType == 7 {
- conditionOr += ` OR ( art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' ` + condition + `) `
- }
- if companyProduct != nil {
- if companyProduct.Scale != "" {
- conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%' ` + condition + `) `
- }
- }
- if adminIds != "" {
- conditionOr += ` OR ( art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' ` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
- if companyProduct != nil {
- if companyProduct.Scale != "" {
- conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%'` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
- }
- }
- }
- //弘则研究下的客户不做权限,限制,C类电话会,仅本组销售、部门管理员、admin、权益研究员账号能看到
- if user.CompanyId == 16 {
- mapMobile, e := GetAdminMobileMap()
- if e != nil {
- err = e
- return
- }
- if _, ok := mapMobile[user.Mobile]; ok {
- conditionOr += ` OR ( art.publish_status = 1 ` + conditionHz + `) `
- }
- }
- conditionActivity = condition + permissionSqlStr + sqlExport + conditionOr
- return
- }
- // 研选系列专家电话会,会前1小时将问题列表发送给邮箱
- func SendEmailFileForAskMsgResearch(cont context.Context) (err error) {
- var msg string
- //var touser string
- defer func() {
- if err != nil {
- go utils.SendAlarmMsg("发送附件模版消息失败", 2)
- go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
- }
- if msg != "" {
- go utils.SendAlarmMsg(msg, 2)
- utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
- }
- }()
- endDate := time.Now().Add(+time.Minute * 60).Format(utils.FormatDateTime)
- condition := `AND a.activity_type_id = 1 AND a.chart_permission_id = 31 `
- total, err := models.GetCountActivityResearchToSendFile(condition, endDate)
- if total == 0 {
- fmt.Println("发送附件完成0")
- return nil
- }
- if err != nil {
- msg = "发送附件模版消息失败 Err:" + err.Error()
- return
- }
- listActivity, err := models.GetActivityResearchToSendFile(condition, endDate)
- if err != nil {
- msg = "发送附件模版消息失败 Err:" + err.Error()
- return
- }
- for _, v := range listActivity {
- activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
- if activityInfo == nil {
- msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
- return
- }
- list, errFile := models.GetActivityMsgExport(v.ActivityId)
- if errFile != nil {
- msg = "获取失败,Err:" + errFile.Error()
- return
- }
- for _, v2 := range list {
- user, err := models.GetWxUserItemByUserId(v2.UserId)
- if err != nil && err.Error() != utils.ErrNoRow() {
- return err
- }
- //获取销售信息
- sellerItem, err := models.GetSellerByCompanyIdCheckFicc(v2.CompanyId, 2)
- if err != nil && err.Error() != utils.ErrNoRow() {
- return err
- }
- //给研究员推送消息
- if sellerItem != nil {
- openIpItem, _ := models.GetUserRecordByMobile(4, utils.ActSendMsgMobile)
- if openIpItem != nil && openIpItem.OpenId != "" {
- //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
- SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
- }
- }
- //给所属销售推送消息
- if sellerItem != nil {
- openIpItem, _ := models.GetUserRecordByMobile(4, sellerItem.Mobile)
- if openIpItem != nil && openIpItem.OpenId != "" {
- //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
- SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
- }
- }
- }
- errFile = models.UPdateActivityMsgToSendFile(v.ActivityId)
- if errFile != nil {
- msg = "获取失败,Err:" + errFile.Error()
- return
- }
- }
- return
- }
- // 非研选系列专家电话会,根据主持人姓名,会前15分钟将问题列表发送给至该主持人对应邮箱
- func SendEmailFileForAskMsg(cont context.Context) (err error) {
- var msg string
- //var touser string
- defer func() {
- if err != nil {
- go utils.SendAlarmMsg("发送附件模版消息失败", 2)
- go utils.SendEmail("发送附件模版消息失败"+"【"+utils.APPNAME+"】"+time.Now().Format(utils.FormatDateTime), msg+";Err:"+err.Error(), utils.EmailSendToUsers)
- }
- if msg != "" {
- go utils.SendAlarmMsg(msg, 2)
- utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
- }
- }()
- endDate := time.Now().Add(+time.Minute * 15).Format(utils.FormatDateTime)
- condition := `AND a.activity_type_id = 1 AND a.chart_permission_id != 31 `
- total, err := models.GetCountActivityResearchToSendFile(condition, endDate)
- if total == 0 {
- fmt.Println("发送附件完成0")
- return nil
- }
- if err != nil {
- msg = "发送附件模版消息失败 Err:" + err.Error()
- return
- }
- listActivity, err := models.GetActivityResearchToSendFile(condition, endDate)
- if err != nil {
- msg = "发送附件模版消息失败 Err:" + err.Error()
- return
- }
- listEmail, errEmail := models.GetAskEmail()
- if errEmail != nil {
- msg = "获取失败,Err:" + errEmail.Error()
- return
- }
- for _, v := range listActivity {
- activityInfo, _ := models.GetAddActivityInfoById(v.ActivityId)
- if activityInfo == nil {
- msg = "活动不存在,Err:activityId:" + strconv.Itoa(v.ActivityId)
- return
- }
- list, errFile := models.GetActivityMsgExport(v.ActivityId)
- if errFile != nil {
- msg = "获取失败,Err:" + errFile.Error()
- return
- }
- for _, v2 := range list {
- user, err := models.GetWxUserItemByUserId(v2.UserId)
- if err != nil && err.Error() != utils.ErrNoRow() {
- return err
- }
- var sendMobile string
- for _, vEmail := range listEmail {
- if strings.Index(activityInfo.Host, vEmail.Name) > 0 {
- sendMobile = vEmail.Mobile
- }
- }
- //获取销售信息
- sellerItem, err := models.GetSellerByCompanyIdCheckFicc(v2.CompanyId, 2)
- if err != nil && err.Error() != utils.ErrNoRow() {
- return err
- }
- //给研究员推送模板消息
- if sellerItem != nil {
- openIpItem, _ := models.GetUserRecordByMobile(4, sendMobile)
- if openIpItem != nil && openIpItem.OpenId != "" {
- //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
- SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
- }
- }
- //给销售推送模板消息
- if sellerItem != nil {
- openIpItem, _ := models.GetUserRecordByMobile(4, sellerItem.Mobile)
- if openIpItem != nil && openIpItem.OpenId != "" {
- //SendActivityAskApplyTemplateMsg(user.RealName+"——"+user.CompanyName+"(所属销售:"+sellerItem.RealName+")", v2.CreateTime, v2.Content, activityInfo.ActivityName, activityInfo.ActivityId, openIpItem)
- SendActivityAskApplyTemplateMsgV2(user.RealName+"——"+user.CompanyName, "所属销售:"+sellerItem.RealName, time.Now().Format(utils.FormatDateTime), v2.Content, activityInfo.ActivityName, openIpItem, activityInfo)
- }
- }
- }
- errFile = models.UPdateActivityMsgToSendFile(v.ActivityId)
- if errFile != nil {
- msg = "获取失败,Err:" + errFile.Error()
- return
- }
- }
- return
- }
- // 活动标签字符串处理
- func LabelStr(label string) (labelNew string) {
- slicebr := strings.Split(label, "-")
- if len(slicebr) < 2 {
- labelNew = label
- } else {
- labelNew = slicebr[1]
- }
- return labelNew
- }
- // 5.3版本活动标签字符串处理
- func LabelStrV5(label string, isShowSubjectName int, temporaryLabel string) (labelNew string) {
- slicebr := strings.Split(label, "-")
- if len(slicebr) > 1 {
- if isShowSubjectName == 1 {
- labelNew = slicebr[1]
- } else {
- labelNew = slicebr[0]
- }
- } else {
- labelNew = label
- }
- if temporaryLabel != "" {
- labelNew = temporaryLabel
- }
- return labelNew
- }
- func ActivityAttendanceDetail(cont context.Context) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("ActivityAttendanceDetail Err:" + err.Error())
- go utils.SendAlarmMsg("同步进门财经数据失败", 2)
- go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "ActivityAttendanceDetail ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- }
- }()
- configCode := "jin_meng_activity_id"
- detail, err := models.GetConfigByCode(configCode)
- if err != nil {
- return err
- }
- fmt.Println(detail.ConfigValue)
- mapActivityId := make(map[string]string)
- sliceValue := strings.Split(detail.ConfigValue, ",")
- for _, v := range sliceValue {
- mapActivityId[v] = v
- }
- var activityIds string
- var activityIdsLongTime string //可回放的会议,到会详情持续更新加入到不做14天限制的活动中
- fmt.Println("开始同步")
- dateTime := time.Now().AddDate(0, 0, -14).Format(utils.FormatDate)
- dateNow := time.Now().AddDate(0, 0, 0).Format(utils.FormatDate)
- startDate := dateTime + " 00:00:00"
- endDate := dateNow + " 23:59:59"
- //获取进门财经需要处理的活动
- listActivityRoadshow, err := models.GetRoadshowDataListByDateTime(startDate, endDate)
- if err != nil {
- fmt.Println("GetRoadshowDataListByDateTime Err:", err.Error())
- return err
- }
- for _, vAct := range listActivityRoadshow {
- doTime := utils.TimeRemoveHms2(vAct.RoadshowBeginTime)
- findStartDate := doTime + " 00:00:00"
- findEndDate := doTime + " 23:59:59"
- var roadshowTitle string
- roadshowTitle = vAct.RoadshowTitle
- vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "【", "", -1)
- vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "】", "", -1)
- vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, " ", "", -1)
- vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, "-", "", -1)
- vAct.RoadshowTitle = strings.Replace(vAct.RoadshowTitle, ":", "", -1)
- nameSlice := strings.Split(vAct.RoadshowTitle, "|")
- //fmt.Println(timeSlice[0])
- //对于手动匹配到的活动数据也要更新
- var activityName string
- if len(nameSlice) >= 1 {
- //if vAct.JmcjRoadshowTitle != "" {
- // activityName = vAct.JmcjRoadshowTitle
- //} else {
- // activityName = nameSlice[len(nameSlice)-1]
- //}
- activityName = nameSlice[len(nameSlice)-1]
- if activityName != "" {
- //通过名称去找匹配的活动
- activityDetail, _ := models.GetAddActivityInfoByTitle(activityName, findStartDate, findEndDate)
- if activityDetail == nil {
- continue
- } else {
- activityIds += strconv.Itoa(activityDetail.ActivityId) + ","
- }
- list, err := models.GetRoadshowDataList(roadshowTitle, findStartDate, findEndDate)
- if err != nil {
- fmt.Println("GetTacticsList Err:", err.Error())
- return err
- }
- var isPlayback bool // 是否包含回放
- needAddAttendanc := make([]*models.CygxActivityAttendanceDetail, 0)
- var mobileStr string
- if len(list) > 0 {
- fmt.Println("原来的", vAct.RoadshowTitle)
- fmt.Println("处理的", activityName)
- for _, v := range list {
- if v.UserPhone != "" {
- item := new(models.CygxActivityAttendanceDetail)
- item.ActivityId = activityDetail.ActivityId
- item.RealName = v.UserName
- item.Mobile = v.UserPhone
- item.CompanyName = v.Company
- //item.SellerName = sellerName
- item.FirstMeetingTime = v.FirstWatchTime
- item.LastMeetingTime = v.LastWatchTime
- item.Duration = utils.GetAttendanceDetailSeconds(v.JoinTime)
- if v.JoinType == 1 {
- item.MeetingTypeStr = "网络"
- } else {
- item.MeetingTypeStr = "电话"
- }
- item.MeetingAuthentication = v.AuthInfo
- if v.DataType == 1 {
- item.MeetingStatusStr = "直播"
- } else {
- item.MeetingStatusStr = "回放"
- isPlayback = true
- }
- item.Position = v.Occupation
- item.UseridEntity = v.UseridEntity
- item.ActivityTime = activityDetail.ActivityTime
- item.CrmCompanyMapStatusId = v.CrmCompanyMapStatusId
- item.CreateTime = time.Now()
- mobileStr += "'" + v.UserPhone + "'" + ","
- needAddAttendanc = append(needAddAttendanc, item)
- }
- }
- if isPlayback && mapActivityId[strconv.Itoa(activityDetail.ActivityId)] == "" {
- activityIdsLongTime += strconv.Itoa(activityDetail.ActivityId) + ","
- }
- mobileStr = strings.TrimRight(mobileStr, ",")
- if mobileStr == "" {
- mobileStr = "1"
- }
- listUser, err := models.GetWxUserOutboundMobile(mobileStr)
- if err != nil {
- fmt.Println("GetWxUserOutboundMobile Err:", err.Error())
- return err
- }
- for k, v := range needAddAttendanc {
- for _, v2 := range listUser {
- if v2.OutboundMobile == v.Mobile || v2.Mobile == v.Mobile {
- if needAddAttendanc[k].CompanyId == 0 {
- needAddAttendanc[k].CompanyId = v2.CompanyId
- needAddAttendanc[k].SellerName = v2.SellerName
- needAddAttendanc[k].CompanyName = v2.CompanyName
- needAddAttendanc[k].IsMeetingStr = 1
- }
- }
- }
- }
- //fmt.Println(mobileStr)
- //参会记录
- err = models.AddAttendancDetail(needAddAttendanc, activityDetail.ActivityId, mobileStr)
- if err != nil {
- fmt.Println("AddAttendancDetail Err:", err.Error())
- return err
- }
- ////处理是否限制报名
- err = AddCygxActivityRestrictSignupByAdmin(activityDetail.ActivityId)
- if err != nil {
- fmt.Println("AddCygxActivityRestrictSignupByAdmin Err:", err.Error())
- return err
- }
- go AddctivitySignupDetailByJmcj(needAddAttendanc, activityDetail.ActivityId)
- }
- }
- }
- }
- //获取需要处理的活动
- listActivity, err := models.GetActivityListByDateTime(startDate, endDate, activityIds, detail.ConfigValue)
- if err != nil {
- fmt.Println("GetTacticsList Err:", err.Error())
- return err
- }
- //通过本地去找进门财经的数据
- for _, vAct := range listActivity {
- doTime := utils.TimeRemoveHms2(vAct.ActivityTime)
- findStartDate := doTime + " 00:00:00"
- findEndDate := doTime + " 23:59:59"
- nameSlice := strings.Split(vAct.ActivityName, "】")
- //对于手动匹配到的活动数据也要更新
- var activityName string
- if len(nameSlice) > 1 {
- if vAct.JmcjRoadshowTitle != "" {
- activityName = vAct.JmcjRoadshowTitle
- } else {
- activityName = nameSlice[len(nameSlice)-1]
- }
- //activityName = nameSlice[len(nameSlice)-1]
- if activityName != "" {
- list, err := models.GetRoadshowDataList(activityName, findStartDate, findEndDate)
- if err != nil {
- fmt.Println("GetTacticsList Err:", err.Error())
- return err
- }
- var isPlayback bool // 是否包含回放
- needAddAttendanc := make([]*models.CygxActivityAttendanceDetail, 0)
- var mobileStr string
- if len(list) > 0 {
- fmt.Println("原来的1", vAct.ActivityName)
- fmt.Println("处理的2", activityName)
- for _, v := range list {
- if v.UserPhone != "" {
- item := new(models.CygxActivityAttendanceDetail)
- item.ActivityId = vAct.ActivityId
- item.RealName = v.UserName
- item.Mobile = v.UserPhone
- item.CompanyName = v.Company
- //item.SellerName = sellerName
- item.FirstMeetingTime = v.FirstWatchTime
- item.LastMeetingTime = v.LastWatchTime
- item.Duration = utils.GetAttendanceDetailSeconds(v.JoinTime)
- if v.JoinType == 1 {
- item.MeetingTypeStr = "网络"
- } else {
- item.MeetingTypeStr = "电话"
- }
- item.MeetingAuthentication = v.AuthInfo
- if v.DataType == 1 {
- item.MeetingStatusStr = "直播"
- } else {
- item.MeetingStatusStr = "回放"
- isPlayback = true
- }
- item.Position = v.Occupation
- item.UseridEntity = v.UseridEntity
- item.ActivityTime = vAct.ActivityTime
- item.CrmCompanyMapStatusId = v.CrmCompanyMapStatusId
- item.CreateTime = time.Now()
- mobileStr += "'" + v.UserPhone + "'" + ","
- needAddAttendanc = append(needAddAttendanc, item)
- }
- }
- if isPlayback && mapActivityId[strconv.Itoa(vAct.ActivityId)] == "" {
- activityIdsLongTime += strconv.Itoa(vAct.ActivityId) + ","
- }
- mobileStr = strings.TrimRight(mobileStr, ",")
- if mobileStr == "" {
- mobileStr = "1"
- }
- listUser, err := models.GetWxUserOutboundMobile(mobileStr)
- if err != nil {
- fmt.Println("GetWxUserOutboundMobile Err:", err.Error())
- return err
- }
- for k, v := range needAddAttendanc {
- for _, v2 := range listUser {
- if v2.OutboundMobile == v.Mobile || v2.Mobile == v.Mobile {
- if needAddAttendanc[k].CompanyId == 0 {
- needAddAttendanc[k].CompanyId = v2.CompanyId
- needAddAttendanc[k].SellerName = v2.SellerName
- needAddAttendanc[k].CompanyName = v2.CompanyName
- needAddAttendanc[k].IsMeetingStr = 1
- }
- }
- }
- }
- ////参会记录
- err = models.AddAttendancDetail(needAddAttendanc, vAct.ActivityId, mobileStr)
- if err != nil {
- fmt.Println("AddAttendancDetail Err:", err.Error())
- return err
- }
- ////处理是否限制报名
- err = AddCygxActivityRestrictSignupByAdmin(vAct.ActivityId)
- if err != nil {
- fmt.Println("AddCygxActivityRestrictSignupByAdmin Err:", err.Error())
- return err
- }
- activityIds += strconv.Itoa(vAct.ActivityId) + ","
- go AddctivitySignupDetailByJmcj(needAddAttendanc, vAct.ActivityId)
- }
- }
- }
- }
- if activityIdsLongTime != "" {
- activityIdsLongTime = strings.TrimRight(activityIdsLongTime, ",")
- activityIdsLongTime = detail.ConfigValue + "," + activityIdsLongTime
- go models.UpdateConfigByCode(activityIdsLongTime, configCode)
- }
- activityIds = strings.TrimRight(activityIds, ",")
- if activityIds != "" {
- detailList, err := models.GetActivityAttendanceDetailList(activityIds)
- if err != nil {
- fmt.Println("GetActivityAttendanceDetailList Err:", err.Error())
- return err
- }
- //添加报名日志 (下载使用)
- err = models.AddCygxActivityMeetDetailLogOnlineByList(detailList, activityIds)
- if err != nil {
- fmt.Println("AddCygxActivityMeetDetailLogOnline Err:", err.Error())
- return err
- }
- }
- fmt.Println("结束路演同步")
- return
- }
- // 判断是否加入黑名单
- func AddCygxActivityRestrictSignupByAdmin(activityId int) (err error) {
- total, err := models.GetActivitySignupNomeetingCount(activityId)
- if err != nil {
- utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
- fmt.Println(" Err:", err.Error())
- return err
- }
- if total == 0 {
- return err
- }
- mobileList, _ := models.GetUserMeetingMobile(activityId)
- if len(mobileList) >= 0 {
- for _, v := range mobileList {
- totalRestrict, err := models.GetRestrictSignupCountByUid(v.UserId)
- if err != nil {
- fmt.Println(" Err:", err.Error())
- utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
- return err
- }
- totalNomeet, err := models.GetActivitySignupNomeetingCountByUid(v.UserId)
- if err != nil {
- fmt.Println(" Err:", err.Error())
- utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
- return err
- }
- if totalRestrict > 0 && totalNomeet < 3 {
- err = models.DeleteCygxActivityRestrictSignup(v.UserId)
- if err != nil {
- fmt.Println(" Err:", err.Error())
- utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
- return err
- }
- }
- }
- }
- list, err := models.GetActivitySignupNomeetingCountList(activityId)
- if err != nil {
- utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
- fmt.Println(" 用户限制报名失败 Err:", err.Error())
- return err
- }
- for _, v := range list {
- totalRestrict, err := models.GetRestrictSignupCountByUid(v.UserId)
- if err != nil {
- fmt.Println(" Err:", err.Error())
- utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
- return err
- }
- totalNomeet, err := models.GetActivitySignupNomeetingCountByUid(v.UserId)
- if err != nil {
- fmt.Println(" Err:", err.Error())
- utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
- return err
- }
- if totalNomeet >= 3 {
- if totalRestrict == 0 {
- infoUser, err := models.GetUserAndCompanyNameList(v.UserId)
- if err != nil {
- fmt.Println(" Err:", err.Error())
- utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
- return err
- }
- if infoUser != nil {
- item := new(models.CygxActivityRestrictSignup)
- item.UserId = infoUser.UserId
- item.CreateTime = time.Now()
- item.Mobile = infoUser.Mobile
- item.Email = infoUser.Email
- item.CompanyId = infoUser.CompanyId
- item.CompanyName = infoUser.CompanyName
- item.IsRestrict = 1
- err = models.AddCygxActivityRestrictSignup(item)
- if err != nil {
- fmt.Println(" Err:", err.Error())
- utils.FileLog.Info("用户限制报名失败,Err:%s,%s", err.Error())
- return err
- }
- }
- }
- }
- }
- return
- }
- // 判断预约纪要按钮是否显示
- func IsShowAppointment(activityTypeId int, chartPermissionName string) (isShowAppointment bool) {
- if activityTypeId == 1 || activityTypeId == 2 || activityTypeId == 3 || activityTypeId == 4 {
- isShowAppointment = true
- }
- if activityTypeId == 5 && chartPermissionName == "医药" {
- isShowAppointment = true
- }
- return
- }
- // 判断预约纪要按钮是否显示
- func IsShowAppointmentByactivityInfo(item *models.ActivityDetail, chartPermissionName string) (isShowAppointment bool) {
- activityTypeId := item.ActivityTypeId
- if activityTypeId == 1 || activityTypeId == 3 || activityTypeId == 4 {
- isShowAppointment = true
- }
- if activityTypeId == 5 && chartPermissionName == "医药" {
- isShowAppointment = true
- }
- if activityTypeId == 2 && item.IsLimitPeople == 0 {
- isShowAppointment = true
- }
- return
- }
- // 用户报告操作行为,模板消息推送 (先放在活动模块下,避免代码冲突)
- func ArticleUserRemind(user *models.WxUserItem, articleDetail *models.ArticleDetail, source int) (err error) {
- defer func() {
- if err != nil {
- go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
- go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- }
- }()
- countUser, err := models.GetUserRemind(user.UserId)
- if err != nil {
- return err
- }
- if countUser == 0 {
- return err
- }
- var sourceMsg string
- if source == 1 {
- sourceMsg = "阅读报告"
- } else {
- sourceMsg = "收藏报告"
- }
- //获取销售手机号
- sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
- if err != nil && err.Error() != utils.ErrNoRow() {
- return err
- }
- if sellerItemQy != nil {
- openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
- if err != nil {
- fmt.Println(err)
- return err
- }
- var keyword1 string
- var keyword2 string
- keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
- keyword2 = articleDetail.Title
- SendWxMsgWithArticleUserRemind(keyword1, keyword2, openIdList, articleDetail.ArticleId)
- }
- return
- }
- // 用户活动操作行为,模板消息推送
- func ActivityUserRemind(user *models.WxUserItem, activityDetail *models.ActivityDetail, source int) (err error) {
- defer func() {
- if err != nil {
- go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
- go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- }
- }()
- countUser, err := models.GetUserRemind(user.UserId)
- if err != nil {
- return err
- }
- if countUser == 0 {
- return err
- }
- var sourceMsg string
- if source == 1 {
- sourceMsg = "预约外呼"
- } else if source == 2 {
- sourceMsg = "设置会议提醒"
- } else if source == 3 {
- sourceMsg = "预约纪要"
- } else if source == 4 {
- sourceMsg = "活动报名"
- }
- //获取销售手机号
- sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
- if err != nil && err.Error() != utils.ErrNoRow() {
- return err
- }
- if sellerItemQy != nil {
- openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
- if err != nil {
- fmt.Println(err)
- return err
- }
- var keyword1 string
- var keyword2 string
- keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
- keyword2 = activityDetail.ActivityName
- SendWxMsgWithActivityUserRemind(keyword1, keyword2, openIdList, activityDetail.ActivityId)
- }
- return
- }
- // 用户专项调研操作行为,模板消息推送
- func SpecialActivityUserRemind(user *models.WxUserItem, activityDetail *models.CygxActivitySpecialDetail, source int) (err error) {
- defer func() {
- if err != nil {
- go utils.SendAlarmMsg("同步策略平台阅读数据失败", 2)
- go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- }
- }()
- countUser, err := models.GetUserRemind(user.UserId)
- if err != nil {
- return err
- }
- if countUser == 0 {
- return err
- }
- var sourceMsg string
- if source == 1 {
- sourceMsg = "预报名调研"
- }
- //获取销售手机号
- sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
- if err != nil && err.Error() != utils.ErrNoRow() {
- return err
- }
- if sellerItemQy != nil {
- openIdList, err := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
- if err != nil {
- fmt.Println(err)
- return err
- }
- var keyword1 string
- var keyword2 string
- keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:", sourceMsg)
- keyword2 = activityDetail.ResearchTheme
- SendWxMsgWithSpecialActivityUserRemind(keyword1, keyword2, openIdList, activityDetail.ActivityId)
- }
- return
- }
- //func init() {
- // DoActivityOnenIdWxTemplateMsg()
- //}
- // 周日下午四点半推送全部活动
- func DoActivityOnenIdWxTemplateMsg(cont context.Context) (err error) {
- var msg string
- defer func() {
- if err != nil {
- go utils.SendAlarmMsg("周日下午四点半推送全部活动失败,DoActivityOnenIdWxTemplateMsg ErrMsg:"+err.Error(), 2)
- go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "DoActivityOnenIdWxTemplateMsg ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- fmt.Println(err)
- }
- if msg != "" {
- utils.FileLog.Info("发送模版消息失败,msg:%s", msg)
- }
- }()
- var condition string
- var pars []interface{}
- openidPowerList, err := models.GetCygxUserRecordPower(condition, pars)
- if err != nil {
- return err
- }
- first := "近期所有行业活动预告,欢迎参与"
- keyword1 := "下周活动预告"
- keyword2 := "已发布"
- keyword3 := ""
- keyword4 := "点击查看下周活动列表"
- SendActivityOnenIdWxTemplateMsg(first, keyword1, keyword2, keyword3, keyword4, openidPowerList)
- return
- }
- func ActivityButtonShow(item *models.ActivityDetail) (articleDetail *models.ActivityDetail) {
- articleDetail = item
- //IsShowAppointment bool `description:"是否展示预约纪要"`
- //IsShowOutboundCall bool `description:"是否展示预约外呼"`
- //IsShowMeetingReminder bool `description:"是否展示会议提醒"`
- //IsShowHelpSsk bool `description:"是否展示帮我带问"`
- //IsShowSignup bool `description:"是否展示我要报名"`
- //如果后台在添加活的时候,关联的报告类型不隐藏预约纪要按钮,而且满足以下展示预约纪要按钮类型就展示
- //if articleDetail.IsHideAppointment == 0 {
- // articleDetail.IsShowAppointment = IsShowAppointmentByactivityInfo(articleDetail, articleDetail.ChartPermissionName)
- //}
- articleDetail.IsShowAppointment = false
- //易董的操作按钮都隐藏
- if articleDetail.YidongActivityId != "" {
- articleDetail.IsShowSignup = false
- articleDetail.IsShowDetails = true
- return
- }
- articleDetail.Expert, _ = GetReportContentTextSub(item.Expert)
- //专家电话会 1
- if articleDetail.ActivityTypeId == 1 && articleDetail.IsLimitPeople == 0 && (articleDetail.ActiveState == "1" || articleDetail.ActiveState == "2") {
- articleDetail.IsShowHelpSsk = true
- }
- //新的是否展示规则
- if articleDetail.IsCanAppointmentMinutes == 1 {
- articleDetail.IsShowAppointment = true
- } else {
- articleDetail.IsShowAppointment = false
- }
- if articleDetail.ActiveState == "1" {
- //专家电话会 1
- //专家电话会限制人数的展示我要报名,不限制的展示预约外外呼
- if articleDetail.ActivityTypeId == 1 {
- //articleDetail.IsShowOutboundCall = true
- if articleDetail.LimitPeopleNum == 0 {
- articleDetail.IsShowOutboundCall = true
- //articleDetail.IsShowHelpSsk = true
- } else {
- articleDetail.IsShowSignup = true
- }
- //if articleDetail.SignupType == 0 {
- // if articleDetail.LimitPeopleNum == 0 {
- // articleDetail.IsShowOutboundCall = true
- // //articleDetail.IsShowHelpSsk = true
- // } else {
- // articleDetail.IsShowSignup = true
- // }
- //} else {
- // if articleDetail.SignupType == 2 {
- // articleDetail.IsShowSignup = true
- // } else {
- // articleDetail.IsShowOutboundCall = true
- // }
- //}
- articleDetail.IsShowMeetingReminder = true
- articleDetail.IsShowHelpSsk = true
- }
- //分析师电话会 2
- if articleDetail.ActivityTypeId == 2 {
- //if articleDetail.SignupType == 0 {
- // if articleDetail.LimitPeopleNum == 0 {
- // articleDetail.IsShowOutboundCall = true
- // //articleDetail.IsShowHelpSsk = true
- // } else {
- // articleDetail.IsShowSignup = true
- // }
- //} else {
- // if articleDetail.SignupType == 2 {
- // articleDetail.IsShowSignup = true
- // } else {
- // articleDetail.IsShowOutboundCall = true
- // }
- //}
- if articleDetail.LimitPeopleNum == 0 {
- articleDetail.IsShowOutboundCall = true
- //articleDetail.IsShowHelpSsk = true
- } else {
- articleDetail.IsShowSignup = true
- }
- articleDetail.IsShowMeetingReminder = true
- }
- //公司调研电话会 3
- if articleDetail.ActivityTypeId == 3 {
- if articleDetail.LimitPeopleNum == 0 {
- articleDetail.IsShowMeetingReminder = true
- articleDetail.IsShowOutboundCall = true
- } else {
- articleDetail.IsShowSignup = true
- }
- }
- //公司线下调研 4
- if articleDetail.ActivityTypeId == 4 {
- articleDetail.IsShowSignup = true
- }
- //专家线下沙龙 5
- if articleDetail.ActivityTypeId == 5 {
- articleDetail.IsShowSignup = true
- }
- //分析师线下沙龙 6
- if articleDetail.ActivityTypeId == 6 {
- articleDetail.IsShowSignup = true
- }
- //分析师电话会(C类) 7
- if articleDetail.ActivityTypeId == 7 {
- articleDetail.IsShowSignup = true
- articleDetail.IsShowMeetingReminder = true
- articleDetail.ActivityTypeName = "分析师电话会"
- }
- }
- if articleDetail.SourceType != 2 {
- articleDetail.SourceType = 1
- }
- activityTimeText := articleDetail.ActivityTimeText
- activityTimeText = strings.Replace(activityTimeText, "(", "(", -1)
- activityTimeText = strings.Replace(activityTimeText, ")", ")", -1)
- articleDetail.ActivityTimeText = activityTimeText
- return
- }
- // GetActivityNewLabelMap 获取活动【新】标签Map
- func GetActivityNewLabelMap(activityIds []int) (labelMap map[int]bool, industryNewMap map[int]bool, err error) {
- labelMap = make(map[int]bool, 0)
- industryNewMap = make(map[int]bool, 0)
- if len(activityIds) == 0 {
- return
- }
- // 获取活动关联的产业
- var groupCond string
- var groupPars []interface{}
- groupCond += ` AND a.activity_id IN (` + utils.GetOrmInReplace(len(activityIds)) + `) AND b.source = 1 `
- groupPars = append(groupPars, activityIds)
- groups, e := models.GetActivityIndustryRelationList(groupCond, groupPars)
- if e != nil {
- err = errors.New("获取活动产业关联列表失败, Err: " + e.Error())
- return
- }
- activityIndustryMap := make(map[int][]int, 0)
- industryIds := make([]int, 0)
- for i := range groups {
- industryIds = append(industryIds, groups[i].IndustrialManagementId)
- activityIndustryMap[groups[i].ActivityId] = append(activityIndustryMap[groups[i].ActivityId], groups[i].IndustrialManagementId)
- }
- // 获取新产业Map
- industryLabelMap, e := GetIndustryNewLabelMap(industryIds)
- if e != nil {
- err = errors.New("获取产业新标签Map失败, Err: " + e.Error())
- return
- }
- // 判断活动是否为新
- for k := range industryLabelMap {
- for k2, v2 := range activityIndustryMap {
- if labelMap[k2] {
- continue
- }
- // 活动的产业ID中存在一个新产业即为新活动
- if utils.InArrayByInt(v2, k) {
- labelMap[k2] = true
- }
- }
- }
- //for _, v := range activityIds {
- // labelMap[v] = true
- //}
- //fmt.Println(labelMap)
- ////产业关联的弘则报告发布日期在三个月以内的活动、产业显示 NEW标签
- articNewLabel, e := GetArticNewLabelWhithActivity3Month()
- if e != nil {
- err = errors.New("获取产业新标签Map失败, Err: " + e.Error())
- return
- }
- for k := range articNewLabel {
- labelMap[k] = false
- }
- return
- }
- // GetActivityVoiceResp 处理活动音频回放
- func GetActivityVoiceResp(mapActivityId []int) (mapItem map[int]*models.CygxActivityVoiceReq, err error) {
- activityVoiceList, err := models.GetCygxActivityVoiceReqList(mapActivityId)
- if err != nil && err.Error() != utils.ErrNoRow() {
- return
- }
- mapActivityVoice := make(map[int]*models.CygxActivityVoiceReq)
- if len(activityVoiceList) > 0 {
- for _, v := range activityVoiceList {
- mapActivityVoice[v.ActivityId] = v
- }
- }
- mapItem = mapActivityVoice
- return
- }
- // AddActivitykeyWordSearch 添加活动搜索记录
- func AddActivitykeyWordSearch(keyWordSearch string, user *models.WxUserItem) {
- if keyWordSearch != "" {
- keyWordItem := new(models.CygxUserSearchKeyWord)
- keyWordItem.UserId = user.UserId
- keyWordItem.KeyWord = keyWordSearch
- keyWordItem.PageType = "ActivitSearch"
- keyWordItem.CreateTime = time.Now()
- go models.AddUserSearchKeyWord(keyWordItem)
- }
- }
- // GetActivityVideoResp 处理活动视频频回放
- func GetActivityVideoResp(mapActivityId []int) (mapItem map[int]*models.CygxActivityVideoListResp, err error) {
- var condition string
- var ativityVIdstr string
- for _, v := range mapActivityId {
- ativityVIdstr += strconv.Itoa(v) + ","
- }
- if ativityVIdstr == "" {
- return
- }
- ativityVIdstr = strings.TrimRight(ativityVIdstr, ",")
- condition += ` AND art.activity_id IN (` + ativityVIdstr + `) `
- var pars []interface{}
- //endTime := time.Now().AddDate(0, 0, -30).Format("2006-01-02 15:04:05")
- //condition += ` AND art.activity_time > ? `
- //pars = append(pars, endTime)
- videoList, e := models.GetActivityVideoListAll(condition, pars, 0, 1000)
- if e != nil && e.Error() != utils.ErrNoRow() {
- err = e
- return
- }
- mapActivityVideo := make(map[int]*models.CygxActivityVideoListResp)
- if len(videoList) > 0 {
- for _, v := range videoList {
- mapActivityVideo[v.ActivityId] = v
- }
- }
- mapItem = mapActivityVideo
- return
- }
- // 用户音视频回放操作操作行为,模板消息推送
- func ActivityVideoUserRmind(user *models.WxUserItem, activityId, fileType int) (err error) {
- defer func() {
- if err != nil {
- go utils.SendAlarmMsg("用户音视频回放操作操作行为,模板消息推送失败"+err.Error(), 2)
- }
- }()
- countUser, err := models.GetUserRemind(user.UserId)
- if err != nil {
- return err
- }
- if countUser == 0 {
- return err
- }
- var first string
- var keyword1 string
- var keyword2 string
- var keyword3 string
- var keyword4 string
- var remark string
- //获取销售手机号
- sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
- if err != nil && err.Error() != utils.ErrNoRow() {
- return err
- }
- if sellerItemQy != nil {
- openIdList, e := models.GetWxOpenIdByMobileList(sellerItemQy.Mobile)
- if e != nil {
- err = errors.New("GetSellerByAdminId, Err: " + e.Error())
- return
- }
- //TripStatus int `description:"行程进行状态 1:预报名,2:确定行程"`
- if fileType == 1 {
- activityInfo, e := models.GetCygxActivityVideoByActivityId(activityId)
- if e != nil {
- err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
- return
- }
- if activityInfo == nil {
- return
- }
- keyword1 = activityInfo.VideoName
- first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:播放视频")
- } else {
- activityInfo, e := models.GetCygxActivityVoiceByActivityId(activityId)
- if e != nil {
- err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
- return
- }
- if activityInfo == nil {
- return
- }
- keyword1 = activityInfo.VoiceName
- first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:播放音频")
- }
- keyword2 = "__"
- remark = "点击查看活动详情"
- openIdArr := make([]string, 0)
- for _, v := range openIdList {
- openIdArr = append(openIdArr, v.OpenId)
- }
- redirectUrl := utils.WX_MSG_PATH_ACTIVITY_SPECIAL_DETAIL + strconv.Itoa(activityId)
- sendInfo := new(SendWxTemplate)
- sendInfo.First = first
- sendInfo.Keyword1 = keyword1
- sendInfo.Keyword2 = keyword2
- sendInfo.Keyword3 = keyword3
- sendInfo.Keyword4 = keyword4
- sendInfo.Remark = remark
- sendInfo.TemplateId = utils.WxMsgTemplateIdArticleUserRemind
- sendInfo.RedirectUrl = redirectUrl
- sendInfo.RedirectTarget = 3
- sendInfo.Resource = strconv.Itoa(activityId)
- sendInfo.SendType = utils.TEMPLATE_MSG_CYGX_ARTICLE_ADD
- sendInfo.OpenIdArr = openIdArr
- err = PublicSendTemplateMsg(sendInfo)
- if err != nil {
- return
- }
- }
- return
- }
- // 解析活动填写的报告链接
- func GetActivityReportLinkToArticleList(item *models.ActivityDetail) (items []*models.ActivityArticleResp, err error) {
- reportLink := item.ReportLink
- //处理活动的
- var articleIds []int
- var articleList []string
- if strings.Contains(reportLink, ";") {
- articleList = strings.Split(reportLink, ";")
- } else {
- articleList = strings.Split(reportLink, ";")
- }
- for _, v := range articleList {
- linkList := strings.Split(v, "/")
- if linkList[len(linkList)-1] != "" {
- linkArticleId, _ := strconv.Atoi(linkList[len(linkList)-1])
- articleIds = append(articleIds, linkArticleId)
- }
- }
- lenarticleIds := len(articleIds)
- if lenarticleIds == 0 {
- return
- }
- var condition string
- var pars []interface{}
- pars = make([]interface{}, 0)
- condition = ` AND a.article_id IN (` + utils.GetOrmInReplace(lenarticleIds) + `)`
- pars = append(pars, articleIds)
- listArticle, e := models.GetHomeList(condition, pars, 0, len(articleIds))
- if e != nil {
- err = errors.New("GetResourceDataList, Err: " + e.Error())
- return
- }
- if len(listArticle) > 0 {
- for _, v := range listArticle {
- artItem := new(models.ActivityArticleResp)
- artItem.ArticleId = v.ArticleId
- artItem.Title = v.Title
- items = append(items, artItem)
- }
- }
- return
- }
- // GetActivityCityResp 获取活动关联城市,当同一个活动标签对应多个城市的时候,展示最近举办的活动
- func GetActivityCityResp() (mapItem map[string]string, err error) {
- activityList, err := models.GetActivityLabelListCity()
- if err != nil && err.Error() != utils.ErrNoRow() {
- return
- }
- mapActivityCity := make(map[string]string)
- if len(activityList) > 0 {
- for _, v := range activityList {
- if v.ActivityTypeId == utils.C_CLASS_ACTIVITY_TYPE_ID {
- v.ActivityTypeId = utils.ANALYST_TELL_ACTIVITY_TYPE_ID
- }
- //如果城市民称长度大于2,那么就不显示
- if utf8.RuneCountInString(v.City) != 2 || mapActivityCity[fmt.Sprint(v.Label, "{|}", v.ActivityTypeId)] != "" {
- continue
- }
- mapActivityCity[fmt.Sprint(v.Label, "{|}", v.ActivityTypeId)] = v.City
- }
- }
- mapItem = mapActivityCity
- return
- }
|