activity_special_trip.go 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717
  1. package services
  2. import (
  3. "errors"
  4. "fmt"
  5. "hongze/hongze_clpt/models"
  6. "hongze/hongze_clpt/models/company"
  7. "hongze/hongze_clpt/utils"
  8. "strconv"
  9. "strings"
  10. "time"
  11. )
  12. func SpecialTripPopupMsg(activityInfo *models.CygxActivitySpecialDetail, user *models.WxUserItem) (signupStatus int, popupMsg, popupMsg2 string, err error) {
  13. //SignupStatus int `description:"返回状态:1:成功 、2 :人数已满 、3:调研次数已用完、 4:超时"`
  14. signupStatus = 1
  15. resultTime := utils.StrTimeToTime(activityInfo.ActivityTime) //时间字符串格式转时间格式
  16. if time.Now().After(resultTime.Add(-time.Minute * 60)) {
  17. signupStatus = 4
  18. popupMsg = "活动开始前1小时内无法报名,请联系对口销售处理"
  19. return
  20. }
  21. errMsg, e := CheckTripRemainingtimesBycompany(user, activityInfo)
  22. if e != nil {
  23. err = errors.New("获取客户剩余报名次数失败 GetActivitySpecialUserType, Err: " + e.Error())
  24. return
  25. }
  26. if errMsg != "" {
  27. popupMsg = errMsg
  28. signupStatus = 3
  29. return
  30. }
  31. var condition string
  32. var pars []interface{}
  33. condition += ` AND activity_id = ? AND is_cancel = 0 `
  34. pars = append(pars, activityInfo.ActivityId)
  35. tripTota, e := models.GetActivitySpecialTripCountByActivityId(condition, pars)
  36. if e != nil {
  37. err = errors.New("GetCygxActivitySpecialDetailList, Err: " + e.Error())
  38. return
  39. }
  40. if activityInfo.LimitPeopleNum-tripTota < 1 {
  41. signupStatus = 2
  42. popupMsg = "此活动报名人数已满,请留意下期活动"
  43. return
  44. }
  45. //signupStatus = 4
  46. popupMsg = "感谢参与,本次报名会扣除一次贵司在弘则的调研点数。"
  47. popupMsg2 = "由于每场活动人数有限,如果不能参加请提前48小时取消,未及时取消导致影响其他客户报名将会维持扣点。"
  48. return
  49. }
  50. // 获取用户剩余报名次数
  51. // 获取用户剩余报名次数
  52. func GetTripRemainingtimesBycompany(user *models.WxUserItem, activityInfo *models.CygxActivitySpecialDetail) (errMsg string, tripRemaining int, err error) {
  53. //获取 专项调研客户类型 //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户;6、冻结客户;7、流失客户 8:行业升级套餐客户
  54. msgTemplate := "您的专项调研次数已用完,如仍想参加,请与您的对口销售商议"
  55. //var tripTota int
  56. //var airborneTota int
  57. //userType, _, e := GetActivitySpecialUserType(user.CompanyId)
  58. userType, _, e := GetUserType(user.CompanyId)
  59. if e != nil {
  60. err = errors.New("获取客户身份信息失败 GetActivitySpecialUserType, Err: " + e.Error())
  61. return
  62. }
  63. if userType == 0 {
  64. errMsg = msgTemplate
  65. return
  66. } else if userType == 1 {
  67. tripRemaining = 999
  68. return
  69. } else if userType == 2 {
  70. var condition string
  71. var pars []interface{}
  72. condition += ` AND company_id = ? `
  73. pars = append(pars, user.CompanyId)
  74. //airborneTota, e = models.GetActivitySpecialTripAirborneCountByActivitySpecial(condition, pars)
  75. //if e != nil {
  76. // err = errors.New("GetActivitySpecialTripAirborneCountByActivitySpecial, Err: " + e.Error())
  77. // return
  78. //}
  79. //condition += ` AND is_valid = 1 `
  80. //查询当年的数据
  81. condition += ` AND create_time >= ? `
  82. pars = append(pars, time.Now().Format(utils.FormatYearDate)+"-01-01")
  83. listTripBill, e := models.GetCygxActivitySpecialTripBill(condition, pars)
  84. if e != nil {
  85. err = errors.New("GetActivitySpecialTripCountByActivitySpecial, Err: " + e.Error())
  86. return
  87. }
  88. var TripBillNum int
  89. for _, v := range listTripBill {
  90. TripBillNum += v.BillDetailed
  91. }
  92. var packageType int
  93. //大套餐客户,数据库添加标识,
  94. companyUserTypeDetail, errs := models.GetCygxCompanyUserType(user.CompanyId)
  95. if errs != nil && errs.Error() != utils.ErrNoRow() {
  96. err = errs
  97. return
  98. }
  99. if companyUserTypeDetail != nil {
  100. packageType = companyUserTypeDetail.PackageType
  101. if companyUserTypeDetail.CustomerTypeId != 0 {
  102. userType = companyUserTypeDetail.CustomerTypeId
  103. return
  104. }
  105. }
  106. packageTypeMap := map[int]int{1: 16, 2: 10}
  107. totalTrip := packageTypeMap[packageType]
  108. //tripRemaining = 10 - airborneTota + TripBillNum
  109. tripRemaining = totalTrip + TripBillNum
  110. if tripRemaining <= 0 {
  111. errMsg = msgTemplate
  112. return
  113. }
  114. //tripRemaining = 12 - tripTota
  115. } else {
  116. var condition string
  117. var pars []interface{}
  118. condition += ` AND company_id = ? `
  119. pars = append(pars, user.CompanyId)
  120. condition += ` AND chart_permission_id = ? `
  121. pars = append(pars, activityInfo.ChartPermissionId)
  122. //airborneTota, e = models.GetActivitySpecialTripAirborneCountByActivitySpecial(condition, pars)
  123. //if e != nil {
  124. // err = errors.New("GetActivitySpecialTripAirborneCountByActivitySpecial, Err: " + e.Error())
  125. // return
  126. //}
  127. //查询当年的数据
  128. condition += ` AND create_time >= ? `
  129. pars = append(pars, time.Now().Format(utils.FormatYearDate)+"-01-01")
  130. listTripBill, e := models.GetCygxActivitySpecialTripBill(condition, pars)
  131. if e != nil {
  132. err = errors.New("GetActivitySpecialTripCountByActivitySpecial, Err: " + e.Error())
  133. return
  134. }
  135. var TripBillNum int
  136. for _, v := range listTripBill {
  137. TripBillNum += v.BillDetailed
  138. }
  139. //tripRemaining = 5 - airborneTota + TripBillNum
  140. tripRemaining = 5 + TripBillNum
  141. if tripRemaining <= 0 {
  142. errMsg = msgTemplate
  143. return
  144. }
  145. }
  146. return
  147. }
  148. // 校验是否还有剩余次数
  149. func CheckTripRemainingtimesBycompany(user *models.WxUserItem, activityInfo *models.CygxActivitySpecialDetail) (errMsg string, err error) {
  150. msgTemplate := "您的专项调研次数已用完,如仍想参加,请与您的对口销售商议"
  151. companyId := user.CompanyId
  152. chartPermissionName := activityInfo.ChartPermissionName
  153. companyDetail, e := models.GetCompanyDetailByIdGroup(companyId)
  154. if e != nil {
  155. err = errors.New("GetCompanyDetailByIdGroup, Err:" + e.Error())
  156. return
  157. }
  158. //永续客户不限制次数
  159. if companyDetail.Status == utils.COMPANY_STATUS_FOREVER {
  160. return
  161. }
  162. var condition string
  163. var pars []interface{}
  164. condition = " AND company_id = ? AND points > 0 ORDER BY chart_permission_id DESC "
  165. pars = append(pars, companyId)
  166. activitySpecialPermissionPointsList, e := models.GetCygxActivitySpecialPermissionPointsList(condition, pars)
  167. if e != nil && e.Error() != utils.ErrNoRow() {
  168. err = errors.New("GetCygxActivitySpecialPermissionPointsList, Err:" + e.Error())
  169. return
  170. }
  171. //如果没有剩余的点数,就返回
  172. if len(activitySpecialPermissionPointsList) == 0 {
  173. errMsg = msgTemplate
  174. return
  175. }
  176. //判断是不是策略行业的活动,策略的任何一个行业有剩余点数都能参加
  177. if chartPermissionName == utils.CE_LUE_NAME {
  178. return
  179. } else {
  180. for _, v := range activitySpecialPermissionPointsList {
  181. if v.ChartPermissionName == chartPermissionName || v.ChartPermissionId == 0 {
  182. return
  183. } // 如果对应行业有剩余次数,或者是属于大套餐且有次数,那么校验也通过
  184. }
  185. }
  186. return
  187. }
  188. // GetSpecialBillMaxChartPermissionId 获取专项调研剩余点数最多的行业
  189. func GetSpecialBillMaxChartPermissionId(user *models.WxUserItem) (maxChartPermissionId int, maxChartPermissionName string, err error) {
  190. companyId := user.CompanyId
  191. var condition string
  192. var pars []interface{}
  193. condition = " AND company_id = ? AND points > 0 ORDER BY points DESC LIMIT 1 "
  194. pars = append(pars, companyId)
  195. activitySpecialPermissionPointsList, e := models.GetCygxActivitySpecialPermissionPointsList(condition, pars)
  196. if e != nil && e.Error() != utils.ErrNoRow() {
  197. err = errors.New("GetCygxActivitySpecialPermissionPointsList, Err:" + e.Error())
  198. return
  199. }
  200. for _, v := range activitySpecialPermissionPointsList {
  201. maxChartPermissionId = v.ChartPermissionId
  202. maxChartPermissionName = v.ChartPermissionName
  203. }
  204. return
  205. }
  206. // DeductTripRemainingtimesByUser 扣除用户专项调研剩余次数
  207. func DeductTripRemainingtimesByUser(user *models.WxUserItem, activityInfo *models.CygxActivitySpecialDetail) (err error) {
  208. msgTemplate := "您的专项调研次数已用完,如仍想参加,请与您的对口销售商议"
  209. companyId := user.CompanyId
  210. chartPermissionName := activityInfo.ChartPermissionName
  211. companyProduct, e := company.GetCompanyProductByCompanyIdAndProductId(companyId, utils.COMPANY_PRODUCT_RAI_ID)
  212. if e != nil {
  213. err = errors.New("GetCompanyProductByCompanyIdAndProductId, Err:" + e.Error())
  214. return
  215. }
  216. var condition string
  217. var pars []interface{}
  218. var maxChartPermissionId int // 剩余点数最多的行业
  219. var points int // 剩余点数
  220. var activitySpecialPermissionPointsList []*models.CygxActivitySpecialPermissionPoints
  221. //永续客户不限次数需要单独处理
  222. if companyProduct.Status == utils.COMPANY_STATUS_FOREVER {
  223. condition = " AND company_id = ? ORDER BY points DESC LIMIT 1 "
  224. pars = append(pars, companyId)
  225. activitySpecialPermissionPointsList, e = models.GetCygxActivitySpecialPermissionPointsList(condition, pars)
  226. if e != nil && e.Error() != utils.ErrNoRow() {
  227. err = errors.New("GetCygxActivitySpecialPermissionPointsList, Err:" + e.Error())
  228. return
  229. }
  230. //如果永续客户不存在单独的行业剩余点数记录,那么就添加一条 -1 的记录作为初始化数据
  231. if len(activitySpecialPermissionPointsList) == 0 {
  232. item := new(models.CygxActivitySpecialPermissionPoints)
  233. item.CompanyId = companyProduct.CompanyId
  234. item.Points = -1
  235. item.CompanyName = companyProduct.CompanyName
  236. //item.ChartPermissionId = activityInfo.ChartPermissionId
  237. //item.ChartPermissionName = activityInfo.ChartPermissionName
  238. item.CreateTime = time.Now()
  239. item.ModifyTime = time.Now()
  240. e = models.AddCygxActivitySpecialPermissionPoints(item)
  241. if e != nil {
  242. err = errors.New("AddCygxActivitySpecialPermissionPoints, Err:" + e.Error())
  243. return
  244. }
  245. return
  246. }
  247. } else {
  248. condition = " AND company_id = ? AND points > 0 ORDER BY points DESC LIMIT 1 "
  249. pars = append(pars, companyId)
  250. //判断是不是策略、固收行业的活动,如果不是策略就获取对应行业的点数 ,策略的任何一个行业有剩余点数都能参加
  251. if chartPermissionName != utils.CE_LUE_NAME && chartPermissionName != utils.GU_SHOU_NAME {
  252. pars = make([]interface{}, 0)
  253. condition = " AND company_id = ? AND ( chart_permission_id = ? OR chart_permission_id =0 ) AND points > 0 ORDER BY points DESC LIMIT 1 "
  254. pars = append(pars, companyId, activityInfo.ChartPermissionId)
  255. }
  256. activitySpecialPermissionPointsList, e = models.GetCygxActivitySpecialPermissionPointsList(condition, pars)
  257. if e != nil && e.Error() != utils.ErrNoRow() {
  258. err = errors.New("GetCygxActivitySpecialPermissionPointsList, Err:" + e.Error())
  259. return
  260. }
  261. }
  262. //如果没有剩余的点数,就返回
  263. if len(activitySpecialPermissionPointsList) == 0 {
  264. err = errors.New(msgTemplate)
  265. return
  266. }
  267. for _, v := range activitySpecialPermissionPointsList {
  268. maxChartPermissionId = v.ChartPermissionId
  269. points = v.Points - 1
  270. }
  271. //更新对应行业剩余点数
  272. e = models.UpdateCygxActivitySpecialPermissionPoints(points, companyId, maxChartPermissionId)
  273. if e != nil {
  274. err = errors.New("UpdateCygxActivitySpecialPermissionPoints, Err:" + e.Error())
  275. return
  276. }
  277. return
  278. }
  279. // RebateTripRemainingtimesByUser 返点用户专项调研剩余次数
  280. func RebateTripRemainingtimesByUser(user *models.WxUserItem, activityInfo *models.CygxActivitySpecialDetail) (err error) {
  281. companyId := user.CompanyId
  282. chartPermissionName := activityInfo.ChartPermissionName
  283. var condition string
  284. var pars []interface{}
  285. condition = " AND company_id = ? ORDER BY points DESC LIMIT 1 "
  286. pars = append(pars, companyId)
  287. //判断是不是策略、固收行业的活动,如果不是策略就获取对应行业的点数 ,策略的任何一个行业有剩余点数都能参加
  288. if chartPermissionName != utils.CE_LUE_NAME && chartPermissionName != utils.GU_SHOU_NAME {
  289. pars = make([]interface{}, 0)
  290. condition = " AND company_id = ? AND ( chart_permission_id = ? OR chart_permission_id = 0 ) LIMIT 1 "
  291. pars = append(pars, companyId, activityInfo.ChartPermissionId)
  292. } else {
  293. lastTripBill, e := models.GetCygxActivitySpecialTripBillLastDetialByActivityId(activityInfo.ActivityId, user.UserId)
  294. if e != nil {
  295. err = errors.New("GetActivitySpecialTripCountByActivitySpecial, Err: " + e.Error())
  296. return
  297. }
  298. pars = make([]interface{}, 0)
  299. condition = " AND company_id = ? AND ( chart_permission_id = ? OR chart_permission_id = 0 ) LIMIT 1 "
  300. pars = append(pars, companyId, lastTripBill.ChartPermissionId)
  301. }
  302. activitySpecialPermissionPointsList, e := models.GetCygxActivitySpecialPermissionPointsList(condition, pars)
  303. if e != nil && e.Error() != utils.ErrNoRow() {
  304. err = errors.New("GetCygxActivitySpecialPermissionPointsList, Err:" + e.Error())
  305. return
  306. }
  307. var maxChartPermissionId int // 剩余点数最多的行业(返点行业)
  308. var points int // 剩余点数
  309. for _, v := range activitySpecialPermissionPointsList {
  310. maxChartPermissionId = v.ChartPermissionId
  311. points = v.Points + 1
  312. }
  313. //更新对应行业剩余点数
  314. e = models.UpdateCygxActivitySpecialPermissionPoints(points, companyId, maxChartPermissionId)
  315. if e != nil {
  316. err = errors.New("UpdateCygxActivitySpecialPermissionPoints, Err:" + e.Error())
  317. return
  318. }
  319. return
  320. }
  321. // 预处理专项调研流水明细表描述内容
  322. //func HandleActivitySpecialTripBillTotalText(user *models.WxUserItem) (totalText string, err error) {
  323. // companyId := user.CompanyId
  324. // companyDetail, e := models.GetCompanyDetailByIdGroup(companyId)
  325. // if e != nil {
  326. // err = errors.New("GetCompanyDetailByIdGroup, Err:" + e.Error())
  327. // return
  328. // }
  329. // //永续客户不限制次数
  330. // if companyDetail.Status == utils.COMPANY_STATUS_FOREVER {
  331. // totalText = "0次"
  332. // return
  333. // }
  334. // var condition string
  335. // var pars []interface{}
  336. // pars = make([]interface{}, 0)
  337. // condition = " AND company_id = ? AND points != 0 ORDER BY chart_permission_id DESC "
  338. // pars = append(pars, companyId)
  339. // activitySpecialPermissionPointsList, e := models.GetCygxActivitySpecialPermissionPointsList(condition, pars)
  340. // if e != nil && e.Error() != utils.ErrNoRow() {
  341. // err = errors.New("GetCygxActivitySpecialPermissionPointsList, Err:" + e.Error())
  342. // return
  343. // }
  344. //
  345. // var itemBillTotal []string
  346. // for _, v := range activitySpecialPermissionPointsList {
  347. // if v.ChartPermissionId > 0 {
  348. // itemBillTotal = append(itemBillTotal, fmt.Sprint(v.ChartPermissionName, v.Points, "次")) // 行业套餐客户展示规则
  349. // }
  350. // if v.ChartPermissionId == 0 {
  351. // totalText = fmt.Sprint(v.Points, "次") // 大套餐客户展示规则
  352. // }
  353. // }
  354. // if len(itemBillTotal) > 0 {
  355. // totalText = strings.Join(itemBillTotal, "+")
  356. // }
  357. // fmt.Println(totalText)
  358. // return
  359. //}
  360. // 预处理专项调研流水明细表描述内容
  361. func HandleActivitySpecialTripBillTotalText(companyId int) (totalText string, err error) {
  362. //companyId := user.CompanyId
  363. companyDetail, e := models.GetCompanyDetailByIdGroup(companyId)
  364. if e != nil {
  365. err = errors.New("GetCompanyDetailByIdGroup, Err:" + e.Error())
  366. return
  367. }
  368. var condition string
  369. var pars []interface{}
  370. pars = make([]interface{}, 0)
  371. condition = " AND company_id = ? AND points != 0 ORDER BY chart_permission_id DESC "
  372. pars = append(pars, companyId)
  373. activitySpecialPermissionPointsList, e := models.GetCygxActivitySpecialPermissionPointsList(condition, pars)
  374. if e != nil && e.Error() != utils.ErrNoRow() {
  375. err = errors.New("GetCygxActivitySpecialPermissionPointsList, Err:" + e.Error())
  376. return
  377. }
  378. //永续客户次数累加
  379. if companyDetail.Status == utils.COMPANY_STATUS_FOREVER {
  380. var points int
  381. for _, v := range activitySpecialPermissionPointsList {
  382. points += v.Points
  383. }
  384. totalText = fmt.Sprint(points, "次") //追加永续客户展示规则(2024-02-23)
  385. return
  386. }
  387. var itemBillTotal []string
  388. itemBillTotalMap := make(map[string]string)
  389. for _, v := range activitySpecialPermissionPointsList {
  390. if v.ChartPermissionId > 0 {
  391. itemBillTotal = append(itemBillTotal, fmt.Sprint(v.ChartPermissionName, v.Points, "次")) // 行业套餐客户展示规则
  392. itemBillTotalMap[v.ChartPermissionName] = fmt.Sprint(v.ChartPermissionName, v.Points, "次")
  393. }
  394. if v.ChartPermissionId == 0 {
  395. totalText = fmt.Sprint(v.Points, "次") // 大套餐客户展示规则,
  396. }
  397. }
  398. if len(itemBillTotal) > 0 {
  399. permissionNameSlice := []string{"医药", "消费", "科技", "智造"}
  400. var itemBillTotalNew []string
  401. for _, v := range permissionNameSlice {
  402. if itemBillTotalMap[v] == "" {
  403. itemBillTotalNew = append(itemBillTotalNew, fmt.Sprint(v, "0次"))
  404. } else {
  405. itemBillTotalNew = append(itemBillTotalNew, itemBillTotalMap[v])
  406. }
  407. }
  408. totalText = strings.Join(itemBillTotalNew, "+")
  409. }
  410. return
  411. }
  412. // 用户搜专项调研操作操作行为,模板消息推送
  413. func ActivitySpecialUserRmind(user *models.WxUserItem, activityId, TripStatus int) (err error) {
  414. defer func() {
  415. if err != nil {
  416. go utils.SendAlarmMsg("用户搜专项调研操作操作行为,模板消息推送失败"+err.Error(), 2)
  417. }
  418. }()
  419. countUser, err := models.GetUserRemind(user.UserId)
  420. if err != nil {
  421. return err
  422. }
  423. if countUser == 0 {
  424. return err
  425. }
  426. var first string
  427. var keyword1 string
  428. var keyword2 string
  429. var keyword3 string
  430. var keyword4 string
  431. var remark string
  432. //获取销售手机号
  433. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  434. if err != nil && err.Error() != utils.ErrNoRow() {
  435. return err
  436. }
  437. if sellerItemQy != nil {
  438. openIdList, e := models.GetWxOpenIdByMobileList(sellerItemQy.Mobile)
  439. if e != nil {
  440. err = errors.New("GetSellerByAdminId, Err: " + e.Error())
  441. return
  442. }
  443. activityInfo, e := models.GetCygxActivitySpecialDetailById(user.UserId, activityId)
  444. if e != nil {
  445. err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
  446. return
  447. }
  448. if activityInfo == nil {
  449. return
  450. }
  451. //TripStatus int `description:"行程进行状态 1:预报名,2:确定行程"`
  452. if TripStatus == 1 {
  453. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:专项调研预报名")
  454. } else {
  455. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:活动报名")
  456. }
  457. keyword1 = activityInfo.ResearchTheme
  458. keyword2 = "__"
  459. remark = "点击查看活动详情"
  460. openIdArr := make([]string, 0)
  461. for _, v := range openIdList {
  462. openIdArr = append(openIdArr, v.OpenId)
  463. }
  464. redirectUrl := utils.WX_MSG_PATH_ACTIVITY_SPECIAL_DETAIL + strconv.Itoa(activityId)
  465. sendInfo := new(SendWxTemplate)
  466. sendInfo.First = first
  467. sendInfo.Keyword1 = keyword1
  468. sendInfo.Keyword2 = keyword2
  469. sendInfo.Keyword3 = keyword3
  470. sendInfo.Keyword4 = keyword4
  471. sendInfo.Remark = remark
  472. sendInfo.TemplateId = utils.WxMsgTemplateIdArticleUserRemind
  473. sendInfo.RedirectUrl = redirectUrl
  474. sendInfo.RedirectTarget = 3
  475. sendInfo.Resource = strconv.Itoa(activityId)
  476. sendInfo.SendType = utils.TEMPLATE_MSG_CYGX_ARTICLE_ADD
  477. sendInfo.OpenIdArr = openIdArr
  478. err = PublicSendTemplateMsg(sendInfo)
  479. if err != nil {
  480. return
  481. }
  482. }
  483. return
  484. }
  485. // GetChartPermissionSpecialSurplusByCompany 获取公司专项调研次数-分品种
  486. func GetChartPermissionSpecialSurplusByCompany(companyId int) (userType int, tripRemaining int, mapChartName map[string]int, err error) {
  487. companyDetail, e := models.GetCompanyDetailByIdGroup(companyId)
  488. if e != nil {
  489. err = errors.New("GetCompanyDetailByIdGroup, Err: " + e.Error())
  490. }
  491. if companyDetail == nil {
  492. return
  493. }
  494. if companyDetail.Status != "永续" && companyDetail.Status != "正式" {
  495. return
  496. }
  497. var specialSurplus string
  498. if companyDetail.Status == "永续" {
  499. specialSurplus = "不限次数"
  500. }
  501. //chartMap := map[int]string{utils.YI_YAO_ID:utils.YI_YAO_NAME, utils.XIAO_FEI_ID:utils.XIAO_FEI_NAME, utils.KE_JI_ID:utils.KE_JI_NAME, utils.ZHI_ZAO_ID:utils.ZHI_ZAO_NAME}
  502. //chartNumMap := map[int]int{utils.YI_YAO_ID:0, utils.XIAO_FEI_ID:0, utils.KE_JI_ID:0, utils.ZHI_ZAO_ID:0}
  503. chartNameMap := map[string]int{utils.YI_YAO_NAME: 0, utils.XIAO_FEI_NAME: 0, utils.KE_JI_NAME: 0, utils.ZHI_ZAO_NAME: 0}
  504. if companyDetail.Status == "正式" {
  505. //var packageType int
  506. userType, _, _ = GetUserType(companyId)
  507. var condition string
  508. var pars []interface{}
  509. condition += ` AND company_id = ? `
  510. pars = append(pars, companyId)
  511. //查询当年的数据
  512. condition += ` AND b.create_time >= ? `
  513. pars = append(pars, time.Now().Format(utils.FormatYearDate)+"-01-01")
  514. listTripBill, e := models.GetCygxActivitySpecialTripBillList(condition, pars)
  515. if e != nil {
  516. err = errors.New("GetActivitySpecialTripCountByActivitySpecial, Err: " + e.Error())
  517. return
  518. }
  519. //// 获取继承点数
  520. //inheritList, e := models.GetCygxActivitySpecialInheritPointsByCompanyId(companyId)
  521. //if e != nil && e.Error() != utils.ErrNoRow() {
  522. // err = errors.New("GetCygxActivitySpecialInheritPointsByCompanyId, Err: " + e.Error())
  523. //}
  524. if userType == 2 {
  525. var tripBillNum int
  526. for _, v := range listTripBill {
  527. //if v.ActivityId == 0 {
  528. // continue
  529. //}
  530. tripBillNum += v.BillDetailed
  531. }
  532. //if len(inheritList) > 0 {
  533. // for _, v := range inheritList {
  534. // if v.ChartPermissionId == 0 {
  535. // tripBillNum += v.Points
  536. // }
  537. // }
  538. //}
  539. tripRemaining = tripBillNum
  540. if tripRemaining < 0 {
  541. tripRemaining = 0
  542. }
  543. } else {
  544. list, e := models.GetCompanyReportPermissionByCompanyIdAndProductId(companyId, 2)
  545. if e != nil && e.Error() != utils.ErrNoRow() {
  546. err = errors.New("GetCompanyReportPermissionUpgrade, Err: " + e.Error())
  547. }
  548. if len(list) == 0 {
  549. return
  550. }
  551. var chartPermissionIdSlice []string
  552. mapChartName = make(map[string]int)
  553. mapUpgradeId := make(map[int]int)
  554. mapPermissionNameTrip := make(map[string]int)
  555. mapInheritChartName := make(map[string]int)
  556. //mapPermissionName := make(map[int]string)
  557. for _, v := range list {
  558. chartPermissionIdSlice = append(chartPermissionIdSlice, strconv.Itoa(v.ChartPermissionId))
  559. //是升级套餐才有点数
  560. if v.IsUpgrade == 1 {
  561. mapUpgradeId[v.ChartPermissionId] = 1
  562. }
  563. }
  564. chartList := make([]*models.ChartPermission, 0)
  565. if len(chartPermissionIdSlice) > 0 {
  566. chartList, e = models.GetChartPermissionByIds(chartPermissionIdSlice)
  567. if e != nil {
  568. err = errors.New("获取品种信息失败, Err:" + e.Error())
  569. return
  570. }
  571. }
  572. if len(chartList) == 0 {
  573. return
  574. }
  575. for _, v := range listTripBill {
  576. if v.ActivityId == 0 {
  577. continue
  578. }
  579. mapPermissionNameTrip[v.ChartPermissionName] += v.BillDetailed
  580. }
  581. for _, v := range chartList {
  582. //如果是升级则加点
  583. if _, ok := mapUpgradeId[v.ChartPermissionId]; ok {
  584. mapChartName[v.PermissionName] = 5 + mapPermissionNameTrip[v.PermissionName]
  585. } else {
  586. mapChartName[v.PermissionName] = mapPermissionNameTrip[v.PermissionName]
  587. }
  588. }
  589. // 通过继承获得的加点
  590. //for _, v := range inheritList {
  591. // mapInheritChartName[v.ChartPermissionName] = v.Points
  592. //}
  593. for k, _ := range chartNameMap {
  594. if _, ok := mapChartName[k]; ok {
  595. if inherit, ok2 := mapInheritChartName[k]; ok2 {
  596. mapChartName[k] += inherit
  597. }
  598. }
  599. }
  600. for k, v := range mapChartName {
  601. if v > 0 {
  602. specialSurplus += k + strconv.Itoa(v) + "次+"
  603. }
  604. }
  605. specialSurplus = strings.TrimRight(specialSurplus, "+")
  606. }
  607. }
  608. return
  609. }
  610. // 确定行程用户报名模版消息推送
  611. func ActivitySpecialUserAddTrip(user *models.WxUserItem, activityId int) (err error) {
  612. defer func() {
  613. if err != nil {
  614. go utils.SendAlarmMsg("确定行程用户报名模版消息推送,模板消息推送失败"+err.Error(), 2)
  615. }
  616. }()
  617. var first string
  618. var keyword1 string
  619. var keyword2 string
  620. var keyword3 string
  621. var keyword4 string
  622. var remark string
  623. //获取销售手机号
  624. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  625. if err != nil && err.Error() != utils.ErrNoRow() {
  626. return err
  627. }
  628. cnf, _ := models.GetConfigByCode("tpl_msg")
  629. if cnf != nil && sellerItemQy != nil {
  630. openIdList, e := models.GetWxOpenIdByMobileList(cnf.ConfigValue + "," + sellerItemQy.Mobile)
  631. if e != nil {
  632. err = errors.New("GetSellerByAdminId, Err: " + e.Error())
  633. return
  634. }
  635. activityInfo, e := models.GetCygxActivitySpecialDetailById(user.UserId, activityId)
  636. if e != nil {
  637. err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
  638. return
  639. }
  640. if activityInfo == nil {
  641. return
  642. }
  643. keyword1 = fmt.Sprint(user.RealName, "--", user.CompanyName, "(所属销售:", sellerItemQy.RealName, ")")
  644. keyword2 = user.Mobile
  645. keyword3 = time.Now().Format(utils.FormatDateTime)
  646. keyword4 = "报名专项调研【" + activityInfo.ResearchTheme + "】 "
  647. remark = ""
  648. openIdArr := make([]string, 0)
  649. for _, v := range openIdList {
  650. openIdArr = append(openIdArr, v.OpenId)
  651. }
  652. redirectUrl := utils.WX_MSG_PATH_ACTIVITY_SPECIAL_DETAIL + strconv.Itoa(activityId)
  653. sendInfo := new(SendWxTemplate)
  654. sendInfo.First = first
  655. sendInfo.Keyword1 = keyword1
  656. sendInfo.Keyword2 = keyword2
  657. sendInfo.Keyword3 = keyword3
  658. sendInfo.Keyword4 = keyword4
  659. sendInfo.Remark = remark
  660. sendInfo.TemplateId = utils.WxMsgTemplateIdApplyXzs
  661. sendInfo.RedirectUrl = redirectUrl
  662. sendInfo.RedirectTarget = 3
  663. sendInfo.Resource = strconv.Itoa(activityId)
  664. sendInfo.SendType = utils.TEMPLATE_MSG_CYGX_ARTICLE_ADD
  665. sendInfo.OpenIdArr = openIdArr
  666. err = PublicSendTemplateMsg(sendInfo)
  667. if err != nil {
  668. return
  669. }
  670. }
  671. return
  672. }