activity_special_trip.go 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368
  1. package services
  2. import (
  3. "errors"
  4. "fmt"
  5. "hongze/hongze_clpt/models"
  6. "hongze/hongze_clpt/utils"
  7. "strconv"
  8. "strings"
  9. "time"
  10. )
  11. func SpecialTripPopupMsg(activityInfo *models.CygxActivitySpecialDetail, user *models.WxUserItem) (signupStatus int, popupMsg, popupMsg2 string, err error) {
  12. //SignupStatus int `description:"返回状态:1:成功 、2 :人数已满 、3:调研次数已用完、 4:超时"`
  13. signupStatus = 1
  14. resultTime := utils.StrTimeToTime(activityInfo.ActivityTime) //时间字符串格式转时间格式
  15. if time.Now().After(resultTime.Add(-time.Minute * 60)) {
  16. signupStatus = 4
  17. popupMsg = "活动开始前1小时内无法报名,请联系对口销售处理"
  18. return
  19. }
  20. errMsg, _, e := GetTripRemainingtimesBycompany(user, activityInfo)
  21. if e != nil {
  22. err = errors.New("获取客户剩余报名次数失败 GetActivitySpecialUserType, Err: " + e.Error())
  23. return
  24. }
  25. if errMsg != "" {
  26. popupMsg = errMsg
  27. signupStatus = 3
  28. return
  29. }
  30. var condition string
  31. var pars []interface{}
  32. condition += ` AND activity_id = ? AND is_cancel = 0 `
  33. pars = append(pars, activityInfo.ActivityId)
  34. tripTota, e := models.GetActivitySpecialTripCountByActivityId(condition, pars)
  35. if e != nil {
  36. err = errors.New("GetCygxActivitySpecialDetailList, Err: " + e.Error())
  37. return
  38. }
  39. if activityInfo.LimitPeopleNum-tripTota < 1 {
  40. signupStatus = 2
  41. popupMsg = "此活动报名人数已满,请留意下期活动"
  42. return
  43. }
  44. //signupStatus = 4
  45. popupMsg = "感谢参与,本次报名会扣除一次贵司在弘则的调研点数。"
  46. popupMsg2 = "由于每场活动人数有限,如果不能参加请提前48小时取消,未及时取消导致影响其他客户报名将会维持扣点。"
  47. return
  48. }
  49. // 获取用户剩余报名次数
  50. // 获取用户剩余报名次数
  51. func GetTripRemainingtimesBycompany(user *models.WxUserItem, activityInfo *models.CygxActivitySpecialDetail) (errMsg string, tripRemaining int, err error) {
  52. //获取 专项调研客户类型 //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户;6、冻结客户;7、流失客户 8:行业升级套餐客户
  53. msgTemplate := "您的专项调研次数已用完,如仍想参加,请与您的对口销售商议"
  54. //var tripTota int
  55. //var airborneTota int
  56. //userType, _, e := GetActivitySpecialUserType(user.CompanyId)
  57. userType, _, e := GetUserType(user.CompanyId)
  58. if e != nil {
  59. err = errors.New("获取客户身份信息失败 GetActivitySpecialUserType, Err: " + e.Error())
  60. return
  61. }
  62. if userType == 0 {
  63. errMsg = msgTemplate
  64. return
  65. } else if userType == 1 {
  66. tripRemaining = 999
  67. return
  68. } else if userType == 2 {
  69. var condition string
  70. var pars []interface{}
  71. condition += ` AND company_id = ? `
  72. pars = append(pars, user.CompanyId)
  73. //airborneTota, e = models.GetActivitySpecialTripAirborneCountByActivitySpecial(condition, pars)
  74. //if e != nil {
  75. // err = errors.New("GetActivitySpecialTripAirborneCountByActivitySpecial, Err: " + e.Error())
  76. // return
  77. //}
  78. //condition += ` AND is_valid = 1 `
  79. //查询当年的数据
  80. condition += ` AND create_time >= ? `
  81. pars = append(pars, time.Now().Format(utils.FormatYearDate)+"-01-01")
  82. listTripBill, e := models.GetCygxActivitySpecialTripBill(condition, pars)
  83. if e != nil {
  84. err = errors.New("GetActivitySpecialTripCountByActivitySpecial, Err: " + e.Error())
  85. return
  86. }
  87. var TripBillNum int
  88. for _, v := range listTripBill {
  89. TripBillNum += v.BillDetailed
  90. }
  91. var packageType int
  92. //大套餐客户,数据库添加标识,
  93. companyUserTypeDetail, errs := models.GetCygxCompanyUserType(user.CompanyId)
  94. if errs != nil && errs.Error() != utils.ErrNoRow() {
  95. err = errs
  96. return
  97. }
  98. if companyUserTypeDetail != nil {
  99. packageType = companyUserTypeDetail.PackageType
  100. if companyUserTypeDetail.CustomerTypeId != 0 {
  101. userType = companyUserTypeDetail.CustomerTypeId
  102. return
  103. }
  104. }
  105. packageTypeMap := map[int]int{1: 16, 2: 10}
  106. totalTrip := packageTypeMap[packageType]
  107. //tripRemaining = 10 - airborneTota + TripBillNum
  108. tripRemaining = totalTrip + TripBillNum
  109. if tripRemaining <= 0 {
  110. errMsg = msgTemplate
  111. return
  112. }
  113. //tripRemaining = 12 - tripTota
  114. } else {
  115. var condition string
  116. var pars []interface{}
  117. condition += ` AND company_id = ? `
  118. pars = append(pars, user.CompanyId)
  119. condition += ` AND chart_permission_id = ? `
  120. pars = append(pars, activityInfo.ChartPermissionId)
  121. //airborneTota, e = models.GetActivitySpecialTripAirborneCountByActivitySpecial(condition, pars)
  122. //if e != nil {
  123. // err = errors.New("GetActivitySpecialTripAirborneCountByActivitySpecial, Err: " + e.Error())
  124. // return
  125. //}
  126. //查询当年的数据
  127. condition += ` AND create_time >= ? `
  128. pars = append(pars, time.Now().Format(utils.FormatYearDate)+"-01-01")
  129. listTripBill, e := models.GetCygxActivitySpecialTripBill(condition, pars)
  130. if e != nil {
  131. err = errors.New("GetActivitySpecialTripCountByActivitySpecial, Err: " + e.Error())
  132. return
  133. }
  134. var TripBillNum int
  135. for _, v := range listTripBill {
  136. TripBillNum += v.BillDetailed
  137. }
  138. //tripRemaining = 5 - airborneTota + TripBillNum
  139. tripRemaining = 5 + TripBillNum
  140. if tripRemaining <= 0 {
  141. errMsg = msgTemplate
  142. return
  143. }
  144. }
  145. return
  146. }
  147. // 用户搜专项调研操作操作行为,模板消息推送
  148. func ActivitySpecialUserRmind(user *models.WxUserItem, activityId, TripStatus int) (err error) {
  149. defer func() {
  150. if err != nil {
  151. go utils.SendAlarmMsg("用户搜专项调研操作操作行为,模板消息推送失败"+err.Error(), 2)
  152. }
  153. }()
  154. countUser, err := models.GetUserRemind(user.UserId)
  155. if err != nil {
  156. return err
  157. }
  158. if countUser == 0 {
  159. return err
  160. }
  161. var first string
  162. var keyword1 string
  163. var keyword2 string
  164. var keyword3 string
  165. var keyword4 string
  166. var remark string
  167. //获取销售手机号
  168. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  169. if err != nil && err.Error() != utils.ErrNoRow() {
  170. return err
  171. }
  172. if sellerItemQy != nil {
  173. openIdList, e := models.GetWxOpenIdByMobileList(sellerItemQy.Mobile)
  174. if e != nil {
  175. err = errors.New("GetSellerByAdminId, Err: " + e.Error())
  176. return
  177. }
  178. activityInfo, e := models.GetCygxActivitySpecialDetailById(user.UserId, activityId)
  179. if e != nil {
  180. err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
  181. return
  182. }
  183. if activityInfo == nil {
  184. return
  185. }
  186. //TripStatus int `description:"行程进行状态 1:预报名,2:确定行程"`
  187. if TripStatus == 1 {
  188. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:专项调研预报名")
  189. } else {
  190. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:活动报名")
  191. }
  192. keyword1 = activityInfo.ResearchTheme
  193. keyword2 = "__"
  194. remark = "点击查看活动详情"
  195. openIdArr := make([]string, 0)
  196. for _, v := range openIdList {
  197. openIdArr = append(openIdArr, v.OpenId)
  198. }
  199. redirectUrl := utils.WX_MSG_PATH_ACTIVITY_SPECIAL_DETAIL + strconv.Itoa(activityId)
  200. sendInfo := new(SendWxTemplate)
  201. sendInfo.First = first
  202. sendInfo.Keyword1 = keyword1
  203. sendInfo.Keyword2 = keyword2
  204. sendInfo.Keyword3 = keyword3
  205. sendInfo.Keyword4 = keyword4
  206. sendInfo.Remark = remark
  207. sendInfo.TemplateId = utils.WxMsgTemplateIdArticleUserRemind
  208. sendInfo.RedirectUrl = redirectUrl
  209. sendInfo.RedirectTarget = 3
  210. sendInfo.Resource = strconv.Itoa(activityId)
  211. sendInfo.SendType = utils.TEMPLATE_MSG_CYGX_ARTICLE_ADD
  212. sendInfo.OpenIdArr = openIdArr
  213. err = PublicSendTemplateMsg(sendInfo)
  214. if err != nil {
  215. return
  216. }
  217. }
  218. return
  219. }
  220. // GetChartPermissionSpecialSurplusByCompany 获取公司专项调研次数-分品种
  221. func GetChartPermissionSpecialSurplusByCompany(companyId int) (userType int, tripRemaining int, mapChartName map[string]int, err error) {
  222. companyDetail, e := models.GetCompanyDetailByIdGroup(companyId)
  223. if e != nil {
  224. err = errors.New("GetCompanyDetailByIdGroup, Err: " + e.Error())
  225. }
  226. if companyDetail == nil {
  227. return
  228. }
  229. if companyDetail.Status != "永续" && companyDetail.Status != "正式" {
  230. return
  231. }
  232. var specialSurplus string
  233. if companyDetail.Status == "永续" {
  234. specialSurplus = "不限次数"
  235. }
  236. //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}
  237. //chartNumMap := map[int]int{utils.YI_YAO_ID:0, utils.XIAO_FEI_ID:0, utils.KE_JI_ID:0, utils.ZHI_ZAO_ID:0}
  238. chartNameMap := map[string]int{utils.YI_YAO_NAME: 0, utils.XIAO_FEI_NAME: 0, utils.KE_JI_NAME: 0, utils.ZHI_ZAO_NAME: 0}
  239. if companyDetail.Status == "正式" {
  240. //var packageType int
  241. userType, _, _ = GetUserType(companyId)
  242. var condition string
  243. var pars []interface{}
  244. condition += ` AND company_id = ? `
  245. pars = append(pars, companyId)
  246. //查询当年的数据
  247. condition += ` AND b.create_time >= ? `
  248. pars = append(pars, time.Now().Format(utils.FormatYearDate)+"-01-01")
  249. listTripBill, e := models.GetCygxActivitySpecialTripBillList(condition, pars)
  250. if e != nil {
  251. err = errors.New("GetActivitySpecialTripCountByActivitySpecial, Err: " + e.Error())
  252. return
  253. }
  254. // 获取继承点数
  255. inheritList, e := models.GetCygxActivitySpecialInheritPointsByCompanyId(companyId)
  256. if e != nil && e.Error() != utils.ErrNoRow() {
  257. err = errors.New("GetCygxActivitySpecialInheritPointsByCompanyId, Err: " + e.Error())
  258. }
  259. if userType == 2 {
  260. var tripBillNum int
  261. for _, v := range listTripBill {
  262. //if v.ActivityId == 0 {
  263. // continue
  264. //}
  265. tripBillNum += v.BillDetailed
  266. }
  267. if len(inheritList) > 0 {
  268. for _, v := range inheritList {
  269. if v.ChartPermissionId == 0 {
  270. tripBillNum += v.Points
  271. }
  272. }
  273. }
  274. tripRemaining = tripBillNum
  275. if tripRemaining < 0 {
  276. tripRemaining = 0
  277. }
  278. } else {
  279. list, e := models.GetCompanyReportPermissionByCompanyIdAndProductId(companyId, 2)
  280. if e != nil && e.Error() != utils.ErrNoRow() {
  281. err = errors.New("GetCompanyReportPermissionUpgrade, Err: " + e.Error())
  282. }
  283. if len(list) == 0 {
  284. return
  285. }
  286. var chartPermissionIdSlice []string
  287. mapChartName = make(map[string]int)
  288. mapUpgradeId := make(map[int]int)
  289. mapPermissionNameTrip := make(map[string]int)
  290. mapInheritChartName := make(map[string]int)
  291. //mapPermissionName := make(map[int]string)
  292. for _, v := range list {
  293. chartPermissionIdSlice = append(chartPermissionIdSlice, strconv.Itoa(v.ChartPermissionId))
  294. //是升级套餐才有点数
  295. if v.IsUpgrade == 1 {
  296. mapUpgradeId[v.ChartPermissionId] = 1
  297. }
  298. }
  299. chartList := make([]*models.ChartPermission, 0)
  300. if len(chartPermissionIdSlice) > 0 {
  301. chartList, e = models.GetChartPermissionByIds(chartPermissionIdSlice)
  302. if e != nil {
  303. err = errors.New("获取品种信息失败, Err:" + e.Error())
  304. return
  305. }
  306. }
  307. if len(chartList) == 0 {
  308. return
  309. }
  310. for _, v := range listTripBill {
  311. if v.ActivityId == 0 {
  312. continue
  313. }
  314. mapPermissionNameTrip[v.ChartPermissionName] += v.BillDetailed
  315. }
  316. for _, v := range chartList {
  317. //如果是升级则加点
  318. if _, ok := mapUpgradeId[v.ChartPermissionId]; ok {
  319. mapChartName[v.PermissionName] = 5 + mapPermissionNameTrip[v.PermissionName]
  320. } else {
  321. mapChartName[v.PermissionName] = mapPermissionNameTrip[v.PermissionName]
  322. }
  323. }
  324. // 通过继承获得的加点
  325. for _, v := range inheritList {
  326. mapInheritChartName[v.ChartPermissionName] = v.Points
  327. }
  328. for k, _ := range chartNameMap {
  329. if _, ok := mapChartName[k]; ok {
  330. if inherit, ok2 := mapInheritChartName[k]; ok2 {
  331. mapChartName[k] += inherit
  332. }
  333. }
  334. }
  335. for k, v := range mapChartName {
  336. if v > 0 {
  337. specialSurplus += k + strconv.Itoa(v) + "次+"
  338. }
  339. }
  340. specialSurplus = strings.TrimRight(specialSurplus, "+")
  341. }
  342. }
  343. return
  344. }