activity.go 52 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474
  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. "unicode/utf8"
  11. )
  12. // 获取活动列表查询权限的SQL
  13. // @Param ChartPermissionIds query string false "行业id 多个用 , 隔开"
  14. // @Param ActivityTypeIds query string false "活动类型id 多个用 , 隔开"
  15. // @Param ActiveState query string false "活动进行状态 未开始:1、进行中2、已结束3"
  16. // @Param WhichDay query string false "哪一天 今天:1、明天:2,多个用 , 隔开"
  17. // @Param WhichTime query string false "已结束的时间筛选项 本周:1、上周:2 、本月:3、上月:4"
  18. // @Param Label query string false "搜索主题 多个用 , 隔开"
  19. // @Param PlayBack query int false "是否仅展示回放 1:是、0:否 默认0"
  20. // @Param KeyWord query string false "搜索关键词"
  21. // @Param ikType query int false "联想词类型 , 1不做联想,2,做除初始词的联想,3所有联想"
  22. func GetActivityonditionList(user *models.WxUserItem, activityTypeId, chartPermissionIds, whichDay, activeState, label string, isPower, source int, keyWord string, playBack, ikType int) (conditionActivity string, err error) {
  23. keyWordNoIk := keyWord
  24. adminIds, err := models.GetSelleridWhichGroup(user.CompanyId, 2)
  25. if err != nil {
  26. return
  27. }
  28. userType, permissionStr, permissionStrZhengShi, err := GetUserTypeZhengShi(user.CompanyId)
  29. if err != nil {
  30. return
  31. }
  32. //判断客户规模是否属于可见范围的活动
  33. companyProduct, err := models.GetCompanyProductDetail(user.CompanyId, 2)
  34. if err != nil && err.Error() != utils.ErrNoRow() {
  35. return
  36. }
  37. isMaker := user.IsMaker
  38. slicePer := strings.Split(permissionStr, ",")
  39. var permissionSqlStr string
  40. var permissionNameStr string
  41. for _, v := range slicePer {
  42. if userType == 1 {
  43. //研选权限处理
  44. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  45. permissionNameStr += "'" + v + "',"
  46. }
  47. } else {
  48. permissionNameStr += "'" + v + "',"
  49. }
  50. }
  51. permissionNameStr = strings.Replace(permissionNameStr, "(主观)", "", -1)
  52. permissionNameStr = strings.Replace(permissionNameStr, "(客观)", "", -1)
  53. permissionNameStr = strings.TrimRight(permissionNameStr, ",")
  54. slicePerZhengShi := strings.Split(permissionStrZhengShi, ",")
  55. var permissionNameStrZhengShi string
  56. for _, v := range slicePerZhengShi {
  57. if userType == 1 {
  58. //研选权限处理
  59. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  60. permissionNameStrZhengShi += "'" + v + "',"
  61. }
  62. } else {
  63. permissionNameStrZhengShi += "'" + v + "',"
  64. }
  65. }
  66. permissionNameStrZhengShi = strings.Replace(permissionNameStrZhengShi, "(主观)", "", -1)
  67. permissionNameStrZhengShi = strings.Replace(permissionNameStrZhengShi, "(客观)", "", -1)
  68. permissionNameStrZhengShi = strings.TrimRight(permissionNameStrZhengShi, ",")
  69. mapUserType, e := GetActivityCcustomerTypeList()
  70. if e != nil {
  71. err = e
  72. return
  73. }
  74. var userTypeStr string
  75. userTypeStr = mapUserType[userType]
  76. // 查研观向7.4-始终查询宏观的权限(无论是否有权限)
  77. if permissionNameStr == `` {
  78. permissionNameStr = `'宏观'`
  79. } else {
  80. permissionNameStr += `, '宏观'`
  81. }
  82. var condition string
  83. var conditionAdmin string
  84. var conditionHz string // 弘则权限处理
  85. var sqlExport string // 专家权限处理
  86. //permissionSqlStr = ` AND art.chart_permission_name IN (` + permissionNameStr + `)`
  87. sqlExport = ` AND (art.customer_type_ids LIKE '%` + userTypeStr + `%' `
  88. //if userType == 2 {
  89. // sqlExport += ` OR art.customer_type_ids LIKE '%3%' `
  90. //}
  91. if (userType == 2 || userType == 3) && strings.Contains(permissionStr, "专家") {
  92. sqlExport += ` OR art.customer_type_ids LIKE '%4%' `
  93. }
  94. sqlExport += `) `
  95. // 如果是C类电话会就不展示内容,且合并到分析师电话会
  96. if activityTypeId != "" {
  97. if activityTypeId == strconv.Itoa(utils.ANALYST_TELL_ACTIVITY_TYPE_ID) {
  98. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id IN (` + activityTypeId + "," + strconv.Itoa(utils.C_CLASS_ACTIVITY_TYPE_ID) + `)`
  99. } else {
  100. condition = ` AND art.publish_status = 1 AND art.label != '' AND art.activity_type_id IN (` + activityTypeId + `)`
  101. }
  102. }
  103. //主题
  104. if label != "" {
  105. condition = ` AND art.label LIKE "%` + label + `%" `
  106. }
  107. if isPower == 1 {
  108. condition += permissionSqlStr
  109. }
  110. //行业名称
  111. if len(chartPermissionIds) > 0 {
  112. condition += ` AND art.chart_permission_id IN (` + chartPermissionIds + `)`
  113. }
  114. //如果是PC的,则不看易董的
  115. if source == 1 {
  116. condition += ` AND art.yidong_activity_id = '' `
  117. }
  118. var conditionOr string
  119. if whichDay != "" {
  120. var startDate string
  121. var endDate string
  122. if whichDay == "1" {
  123. startDate = time.Now().Format(utils.FormatDate)
  124. endDate = startDate
  125. } else if whichDay == "2" {
  126. startDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  127. endDate = startDate
  128. } else if whichDay == "3" {
  129. startDate = utils.GetNowWeekMonday().Format(utils.FormatDate)
  130. endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
  131. } else if whichDay == "4" {
  132. startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
  133. endDate = utils.GetLastWeekSunday().Format(utils.FormatDate)
  134. } else if whichDay == "5" {
  135. startDate = utils.GetNowMonthFirstDay().Format(utils.FormatDate)
  136. endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
  137. } else if whichDay == "6" {
  138. startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
  139. endDate = utils.GetLastMonthLastDay().Format(utils.FormatDate)
  140. } else if whichDay == "1,2" {
  141. startDate = time.Now().Format(utils.FormatDate)
  142. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  143. } else if whichDay == "3,4" {
  144. startDate = utils.GetLastWeekMonday().Format(utils.FormatDate)
  145. endDate = utils.GetNowWeekSunday().Format(utils.FormatDate)
  146. } else if whichDay == "5,6" {
  147. startDate = utils.GetLastMonthFirstDay().Format(utils.FormatDate)
  148. endDate = utils.GetNowMonthLastDay().Format(utils.FormatDate)
  149. } else {
  150. startDate = time.Now().Format(utils.FormatDate)
  151. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  152. }
  153. condition += ` AND art.activity_time >= ` + "'" + startDate + " 00:00:00'"
  154. condition += ` AND art.activity_time <= ` + "'" + endDate + " 23:59:59'"
  155. }
  156. //有搜索条件传过来时,不判进行状态条件
  157. if keyWord != "" {
  158. if ikType == 2 || ikType == 3 {
  159. keyWordArr, e := GetIndustryMapNameSliceV3(keyWord)
  160. if e != nil {
  161. err = errors.New("获取分词失败,GetIndustryMapNameSliceV3, Err: " + keyWord + e.Error())
  162. return
  163. }
  164. keyWordArr = RemoveDuplicatesAndEmpty(keyWordArr)
  165. //var keywords string
  166. if len(keyWordArr) > 1 {
  167. if ikType == 2 {
  168. keyWord = KeyWordArrSqlRegexp(keyWordArr)
  169. condition += ` AND (art.label NOT LIKE '%` + keyWordNoIk + `%' AND art.activity_name NOT LIKE '%` + keyWordNoIk + `%' ) `
  170. } else if ikType == 3 {
  171. keyWord = KeyWordArrSqlRegexpAll(keyWordArr)
  172. }
  173. }
  174. }
  175. condition += ` AND (art.label REGEXP '` + keyWord + `' OR art.activity_name REGEXP '` + keyWord + `' ) `
  176. } else {
  177. if activeState != "" {
  178. // 默认查看未开始跟进行中
  179. if activeState == "1" {
  180. condition += ` AND art.active_state IN (1,2)`
  181. } else {
  182. condition += ` AND art.active_state IN (` + activeState + `)`
  183. }
  184. } else {
  185. condition += ` AND art.active_state IN (1,2)`
  186. }
  187. }
  188. if playBack == 1 {
  189. var pars []interface{}
  190. ativityVIdArry := make([]string, 0)
  191. voiceList, e := models.GetActivityVoiceListAll("", pars, 0, 1000)
  192. if e != nil && e.Error() != utils.ErrNoRow() {
  193. err = e
  194. return
  195. }
  196. for _, v := range voiceList {
  197. ativityVIdArry = append(ativityVIdArry, strconv.Itoa(v.ActivityId))
  198. }
  199. videoList, e := models.GetActivityVideoListAll("", pars, 0, 1000)
  200. if e != nil && e.Error() != utils.ErrNoRow() {
  201. err = e
  202. return
  203. }
  204. for _, v := range videoList {
  205. ativityVIdArry = append(ativityVIdArry, strconv.Itoa(v.ActivityId))
  206. }
  207. //活动音频,设置有效时间为30天,失效后该活动就不再支持音频回放。有效期起始时间为活动的开始时间
  208. //endTime := time.Now().AddDate(0, 0, -30).Format("2006-01-02 15:04:05")
  209. //condition += ` AND art.activity_time > '` + endTime + `' `
  210. if len(ativityVIdArry) > 0 {
  211. ativityVIdstr := strings.Join(ativityVIdArry, ",")
  212. condition += ` AND art.activity_id IN (` + ativityVIdstr + `) `
  213. } else {
  214. condition += ` AND art.activity_id = 0 `
  215. }
  216. }
  217. //查询全部可见的数据(是否全部客户可见)
  218. //condition += ` AND art.visible_range != 1 AND art.publish_status = 1 `
  219. condition += ` AND art.publish_status = 1 `
  220. //if adminIds == "" {
  221. // //condition += ` AND art.visible_range != 1 `
  222. //} else {
  223. // condition += ` AND ( art.visible_range != 1 OR ( art.admin_id IN ( ` + adminIds + ` ) AND art.visible_range = 1 )) `
  224. //}
  225. if adminIds != "" {
  226. condition += ` AND ( art.visible_range != 1 OR ( art.admin_id IN ( ` + adminIds + ` ) AND art.visible_range = 1 )) `
  227. }
  228. conditionHz = condition
  229. //活动仅决策人可见
  230. if isMaker == 0 {
  231. condition += ` AND art.is_maker_show = 0 `
  232. }
  233. conditionAdmin = condition + ` AND art.visible_range = 1 `
  234. //condition += ` AND art.visible_range != 1 `
  235. if (userType == 2 || userType == 3 || userType == 4) && strings.Contains(permissionStr, "专家") {
  236. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%4%' ` + condition + `) `
  237. }
  238. if (userType == 5) && strings.Contains(permissionStr, "专家") {
  239. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%5%' ` + condition + `) `
  240. }
  241. if userType == 1 {
  242. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + permissionSqlStr + `) `
  243. } else {
  244. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
  245. }
  246. if userType == 6 || userType == 7 {
  247. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' ` + condition + `) `
  248. }
  249. if companyProduct != nil {
  250. if companyProduct.Scale != "" {
  251. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%' ` + condition + `) `
  252. }
  253. }
  254. if adminIds != "" {
  255. if userType == 3 {
  256. conditionAdmin += ` AND art.chart_permission_name IN (` + permissionNameStrZhengShi + `) `
  257. }
  258. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + userTypeStr + `%' ` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
  259. if companyProduct != nil {
  260. if companyProduct.Scale != "" {
  261. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%'` + ` AND art.admin_id IN (` + adminIds + `) ` + conditionAdmin + `) `
  262. }
  263. }
  264. }
  265. conditionShengji, conditionZhengshi, conditionHangYe, e := ActivityLabelSpecialUserSql(user)
  266. if e != nil {
  267. err = errors.New("ActivityLabelSpecialUserSql, Err: " + e.Error())
  268. return
  269. }
  270. if conditionShengji != "" {
  271. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionShengji + condition + ` ) `
  272. }
  273. if conditionZhengshi != "" {
  274. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionZhengshi + condition + ` ) `
  275. }
  276. if conditionHangYe != "" {
  277. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionHangYe + condition + ` ) `
  278. }
  279. //弘则研究下的客户不做权限,限制,C类电话会,仅本组销售、部门管理员、admin、权益研究员账号能看到
  280. if user.CompanyId == utils.HZ_COMPANY_ID {
  281. mapMobile, e := GetAdminMobileMap()
  282. if e != nil {
  283. err = e
  284. return
  285. }
  286. if _, ok := mapMobile[user.Mobile]; ok {
  287. conditionOr += ` OR ( art.publish_status = 1 ` + conditionHz + `) `
  288. }
  289. }
  290. if userType == 3 {
  291. condition += ` AND art.chart_permission_name IN (` + permissionNameStrZhengShi + `) `
  292. }
  293. conditionActivity = condition + permissionSqlStr + sqlExport + conditionOr
  294. return
  295. }
  296. // 根据用户身份处理活动可见
  297. func ActivityConditioninitSql(user *models.WxUserItem, condition string, isPower int) (conditionActivity string, err error) {
  298. // cygx_10.9 未绑定联系方式的客户可以看到部分活动
  299. if user.UserId == 0 || user.CompanyId == 1 {
  300. conditionActivity = ` AND art.publish_status = 1 AND art.visible_range != 1 AND (art.is_limit_people = 0 OR (art.is_limit_people=1 AND art.is_all_customer_type=1)) ` + condition
  301. return
  302. }
  303. condition += ` AND art.publish_status = 1 `
  304. conditionActivity = condition
  305. //弘则可以查看所有活动
  306. if GetBelongingRai(user.Mobile) && user.CompanyId == utils.HZ_COMPANY_ID {
  307. return
  308. }
  309. adminIds, err := models.GetSelleridWhichGroup(user.CompanyId, 2)
  310. if err != nil {
  311. return
  312. }
  313. userType, permissionStr, permissionStrZhengShi, err := GetUserTypeZhengShi(user.CompanyId)
  314. if err != nil {
  315. return
  316. }
  317. //判断客户规模是否属于可见范围的活动
  318. companyProduct, err := models.GetCompanyProductDetail(user.CompanyId, 2)
  319. if err != nil && err.Error() != utils.ErrNoRow() {
  320. return
  321. }
  322. isMaker := user.IsMaker
  323. slicePer := strings.Split(permissionStr, ",")
  324. var permissionSqlStr string
  325. var permissionNameStr string
  326. for _, v := range slicePer {
  327. if userType == 1 {
  328. //研选权限处理
  329. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  330. permissionNameStr += "'" + v + "',"
  331. }
  332. } else {
  333. permissionNameStr += "'" + v + "',"
  334. }
  335. }
  336. permissionNameStr = strings.Replace(permissionNameStr, "(主观)", "", -1)
  337. permissionNameStr = strings.Replace(permissionNameStr, "(客观)", "", -1)
  338. permissionNameStr = strings.TrimRight(permissionNameStr, ",")
  339. slicePerZhengShi := strings.Split(permissionStrZhengShi, ",")
  340. var permissionNameStrZhengShi string
  341. for _, v := range slicePerZhengShi {
  342. if userType == 1 {
  343. //研选权限处理
  344. if !strings.Contains(v, utils.CHART_PERMISSION_NAME_YANXUAN) {
  345. permissionNameStrZhengShi += "'" + v + "',"
  346. }
  347. } else {
  348. permissionNameStrZhengShi += "'" + v + "',"
  349. }
  350. }
  351. permissionNameStrZhengShi = strings.Replace(permissionNameStrZhengShi, "(主观)", "", -1)
  352. permissionNameStrZhengShi = strings.Replace(permissionNameStrZhengShi, "(客观)", "", -1)
  353. permissionNameStrZhengShi = strings.TrimRight(permissionNameStrZhengShi, ",")
  354. mapUserType, e := GetActivityCcustomerTypeList()
  355. if e != nil {
  356. err = e
  357. return
  358. }
  359. var userTypeStr string
  360. userTypeStr = mapUserType[userType]
  361. fmt.Println("userTypeStr", userTypeStr)
  362. // 查研观向7.4-始终查询宏观的权限(无论是否有权限)
  363. if permissionNameStr == `` {
  364. permissionNameStr = `'宏观'`
  365. } else {
  366. permissionNameStr += `, '宏观'`
  367. }
  368. var sqlExport string // 专家权限处理
  369. sqlExport = ` AND (art.customer_type_ids LIKE '%` + userTypeStr + `%' `
  370. if (userType == 2 || userType == 3) && strings.Contains(permissionStr, "专家") {
  371. sqlExport += ` OR art.customer_type_ids LIKE '%4%' `
  372. }
  373. sqlExport += `) `
  374. if isPower == 1 {
  375. permissionSqlStr = ` AND art.chart_permission_name IN (` + permissionNameStr + `)`
  376. condition += permissionSqlStr
  377. }
  378. var conditionOr string
  379. //查询全部可见的数据(是否全部客户可见)
  380. if adminIds != "" {
  381. condition += ` AND ( art.visible_range != 1 OR ( art.admin_id IN ( ` + adminIds + ` ) AND art.visible_range = 1 )) `
  382. }
  383. //活动仅决策人可见
  384. if isMaker == 0 {
  385. condition += ` AND art.is_maker_show = 0 `
  386. }
  387. //condition += ` AND art.visible_range != 1 `
  388. if (userType == 2 || userType == 3 || userType == 4) && strings.Contains(permissionStr, "专家") {
  389. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%4%' ` + condition + `) `
  390. }
  391. if (userType == 5) && strings.Contains(permissionStr, "专家") {
  392. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%5%' ` + condition + `) `
  393. }
  394. if userType == 1 {
  395. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + permissionSqlStr + `) `
  396. } else {
  397. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
  398. }
  399. if userType == 6 || userType == 7 {
  400. conditionOr += ` OR ( art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' ` + condition + `) `
  401. }
  402. if companyProduct != nil {
  403. if companyProduct.Scale != "" {
  404. conditionOr += ` OR ( art.scale LIKE '%` + companyProduct.Scale + `%' ` + condition + `) `
  405. }
  406. }
  407. conditionShengji, conditionZhengshi, conditionHangYe, e := ActivityLabelSpecialUserSql(user)
  408. if e != nil {
  409. err = errors.New("ActivityLabelSpecialUserSql, Err: " + e.Error())
  410. return
  411. }
  412. // 升级客户可查看范围
  413. if conditionShengji != "" {
  414. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionShengji + condition + ` ) `
  415. }
  416. // 正式客户可查看范围
  417. if conditionZhengshi != "" {
  418. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionZhengshi + condition + ` ) `
  419. }
  420. // 行业客户可查看范围
  421. if conditionHangYe != "" {
  422. conditionOr += ` OR ( art.is_limit_people = 1 AND ` + conditionHangYe + condition + ` ) `
  423. }
  424. if userType == 3 {
  425. condition += ` AND art.chart_permission_name IN (` + permissionNameStrZhengShi + `) `
  426. }
  427. condition += ` AND art.is_limit_people = 1 `
  428. conditionActivity = condition + permissionSqlStr + sqlExport + conditionOr
  429. return
  430. }
  431. // 获取可见的活动
  432. func HandleActivityPowerList(listActivity []*models.CygxActivity, user *models.WxUserItem) (items []*models.CygxActivity, err error) {
  433. return
  434. }
  435. // 5.3版本活动标签字符串处理
  436. func LabelStr(label string, isShowSubjectName int, temporaryLabel string) (labelNew string) {
  437. slicebr := strings.Split(label, "-")
  438. if len(slicebr) > 1 {
  439. if isShowSubjectName == 1 {
  440. labelNew = slicebr[1]
  441. } else {
  442. labelNew = slicebr[0]
  443. }
  444. } else {
  445. labelNew = label
  446. }
  447. if temporaryLabel != "" {
  448. labelNew = temporaryLabel
  449. }
  450. return labelNew
  451. }
  452. // 列表
  453. func HandleActivityTypeHomeList(listType []*models.ActivityTypeHome, listActivity []*models.CygxActivity, user *models.WxUserItem) (items []*models.ActivityTypeHome, err error) {
  454. mapActivity := make(map[int][]*models.CygxActivityLabelList)
  455. activityIds := make([]int, 0) // 用于查询活动【新】标签Map
  456. for _, v := range listActivity {
  457. // 如果是C类电话会就不展示内容,且合并到分析师电话会
  458. if v.ActivityTypeId == 7 {
  459. v.ActivityTypeId = 2
  460. }
  461. //if v.ActivityTypeId == 1 {
  462. activityIds = append(activityIds, v.ActivityId)
  463. //}
  464. }
  465. // 活动【新】标签Map
  466. newLabelMap, _, e := GetActivityNewLabelMap(activityIds)
  467. if e != nil {
  468. err = errors.New("获取产业新标签Map失败,GetActivityNewLabelMap Err: " + e.Error())
  469. return
  470. }
  471. activityPointsByUserAllMap := GetActivityPointsByUserAllMap() // 获取对用户进行研选扣点的活动
  472. mapkeyWord := make(map[string]string)
  473. for _, v := range listActivity {
  474. if v.Label == "" {
  475. continue
  476. }
  477. // 如果是C类电话会就不展示内容,且合并到分析师电话会
  478. if v.ActivityTypeId == 7 {
  479. v.ActivityTypeId = 2
  480. }
  481. item := new(models.CygxActivityLabelList)
  482. item.IsResearchPoints = activityPointsByUserAllMap[v.ActivityId]
  483. item.KeyWord = LabelStr(v.Label, v.IsShowSubjectName, v.TemporaryLabel)
  484. if _, ok := mapkeyWord[fmt.Sprint(v.ActivityTypeId, "-", item.KeyWord)]; ok {
  485. continue
  486. }
  487. item.Resource = 1
  488. item.ActivityId = v.ActivityId
  489. if v.IsExternalLabel > 0 {
  490. item.IsExternalLabel = true
  491. }
  492. //if v.IsResearchPoints > 0 {
  493. item.IsResearchPoints = activityPointsByUserAllMap[v.ActivityId]
  494. //}
  495. item.City = v.City
  496. if utf8.RuneCountInString(v.City) != 2 {
  497. item.City = ""
  498. }
  499. item.IsNew = newLabelMap[v.ActivityId]
  500. mapActivity[v.ActivityTypeId] = append(mapActivity[v.ActivityTypeId], item)
  501. mapkeyWord[fmt.Sprint(v.ActivityTypeId, "-", item.KeyWord)] = item.KeyWord
  502. }
  503. for _, v := range listType {
  504. v.Resource = 1
  505. if len(mapActivity[v.ActivityTypeId]) > 0 {
  506. v.List = mapActivity[v.ActivityTypeId]
  507. } else {
  508. v.List = make([]*models.CygxActivityLabelList, 0)
  509. }
  510. }
  511. items = listType
  512. return
  513. }
  514. // GetActivityVoiceResp 处理活动音频回放
  515. func GetActivityVoiceResp(mapActivityId []int) (mapItem map[int]*models.CygxActivityVoiceReq, err error) {
  516. activityVoiceList, err := models.GetCygxActivityVoiceReqList(mapActivityId)
  517. if err != nil && err.Error() != utils.ErrNoRow() {
  518. return
  519. }
  520. mapActivityVoice := make(map[int]*models.CygxActivityVoiceReq)
  521. if len(activityVoiceList) > 0 {
  522. for _, v := range activityVoiceList {
  523. mapActivityVoice[v.ActivityId] = v
  524. }
  525. }
  526. mapItem = mapActivityVoice
  527. return
  528. }
  529. // GetActivityVideoResp 处理活动视频频回放
  530. func GetActivityVideoResp(mapActivityId []int) (mapItem map[int]*models.CygxActivityVideoListResp, err error) {
  531. var condition string
  532. var ativityVIdstr string
  533. for _, v := range mapActivityId {
  534. ativityVIdstr += strconv.Itoa(v) + ","
  535. }
  536. if ativityVIdstr == "" {
  537. return
  538. }
  539. ativityVIdstr = strings.TrimRight(ativityVIdstr, ",")
  540. condition += ` AND art.activity_id IN (` + ativityVIdstr + `) `
  541. var pars []interface{}
  542. //endTime := time.Now().AddDate(0, 0, -30).Format("2006-01-02 15:04:05")
  543. //condition += ` AND art.activity_time > ? `
  544. //pars = append(pars, endTime)
  545. videoList, e := models.GetActivityVideoListAll(condition, pars, 0, 1000)
  546. if e != nil && e.Error() != utils.ErrNoRow() {
  547. err = e
  548. return
  549. }
  550. mapActivityVideo := make(map[int]*models.CygxActivityVideoListResp)
  551. if len(videoList) > 0 {
  552. for _, v := range videoList {
  553. mapActivityVideo[v.ActivityId] = v
  554. }
  555. }
  556. mapItem = mapActivityVideo
  557. return
  558. }
  559. func ActivityButtonShow(item *models.ActivityDetail, user *models.WxUserItem, permissionArr []string) (itemActivity *models.ActivityListResp) {
  560. activityDetail := item
  561. //IsShowAppointment bool `description:"是否展示预约纪要"`
  562. //IsShowOutboundCall bool `description:"是否展示预约外呼"`
  563. //IsShowMeetingReminder bool `description:"是否展示会议提醒"`
  564. //IsShowHelpSsk bool `description:"是否展示帮我带问"`
  565. //IsShowSignup bool `description:"是否展示我要报名"`
  566. activityPointsByUserAllMap := GetActivityPointsByUserAllMap() // 获取对用户进行研选扣点的活动
  567. if strings.Contains(activityDetail.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) {
  568. activityDetail.IsResearch = true
  569. }
  570. //如果是 公司调研电话会:3,或 专家线下沙龙:5 而且 除易董同步过来的以外的研选类型活动,必须要有研选的正式权限
  571. if (activityDetail.ActivityTypeId == 3 || activityDetail.ActivityTypeId == 5) && activityDetail.YidongActivityId == "" && strings.Contains(activityDetail.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) && utils.InArrayByStr(permissionArr, utils.CHART_PERMISSION_NAME_MF_YANXUAN) {
  572. activityDetail.IsResearchSpecial = true
  573. }
  574. if activityDetail.SiginupDeadline == utils.FormatDateTimeInit { //报名截止时间处理
  575. activityDetail.SiginupDeadline = ""
  576. }
  577. //如果报名截止时间不规范,或者是非研选扣点活动就把截止时间设置为空
  578. if activityDetail.CancelDeadline == utils.FormatDateTimeInit || !activityDetail.IsResearchPoints {
  579. activityDetail.CancelDeadline = ""
  580. }
  581. activityTimeText := activityDetail.ActivityTimeText
  582. activityTimeText = strings.Replace(activityTimeText, "(", "(", -1)
  583. activityTimeText = strings.Replace(activityTimeText, ")", ")", -1)
  584. activityDetail.ActivityTimeText = activityTimeText
  585. var yidongActivityUrl string
  586. activityDetail.IsShowAppointment = false
  587. //易董的操作按钮都隐藏
  588. if activityDetail.YidongActivityId != "" {
  589. activityDetail.IsShowSignup = false
  590. activityDetail.IsShowDetails = true
  591. if activityDetail.YidongActivityId != "" {
  592. ydTgc, _ := GetYiDongCreateUserInfo(user)
  593. yidongLongLink, _ := GetYiDongOriginalLink(activityDetail)
  594. if yidongLongLink != "" {
  595. yidongActivityUrl = yidongLongLink + "%26source=11%26fromHz=true%26tgc=" + ydTgc
  596. }
  597. }
  598. } else {
  599. //专家电话会 1
  600. if activityDetail.ActivityTypeId == 1 && activityDetail.IsLimitPeople == 0 && (activityDetail.ActiveState == "1" || activityDetail.ActiveState == "2") {
  601. activityDetail.IsShowHelpSsk = true
  602. }
  603. if activityDetail.ActiveState == "1" {
  604. //新的是否展示规则
  605. if activityDetail.IsCanAppointmentMinutes == 1 {
  606. activityDetail.IsShowAppointment = true
  607. }
  608. //专家电话会 1
  609. if activityDetail.ActivityTypeId == 1 {
  610. if activityDetail.LimitPeopleNum == 0 {
  611. activityDetail.IsShowOutboundCall = true
  612. } else {
  613. activityDetail.IsShowSignup = true
  614. }
  615. activityDetail.IsShowMeetingReminder = true
  616. activityDetail.IsShowHelpSsk = true
  617. }
  618. //分析师电话会 2
  619. if activityDetail.ActivityTypeId == 2 {
  620. if activityDetail.LimitPeopleNum == 0 {
  621. activityDetail.IsShowOutboundCall = true
  622. } else {
  623. activityDetail.IsShowSignup = true
  624. }
  625. activityDetail.IsShowMeetingReminder = true
  626. }
  627. if activityDetail.ActivityTypeId == 3 {
  628. //司调研电话会(3)、扣点的研选活动只展示我要报名
  629. if activityDetail.IsResearchPoints || activityDetail.LimitPeopleNum > 0 {
  630. activityDetail.IsShowSignup = true
  631. } else {
  632. activityDetail.IsShowMeetingReminder = true
  633. activityDetail.IsShowOutboundCall = true
  634. }
  635. }
  636. //公司线下调研 4
  637. if activityDetail.ActivityTypeId == 4 {
  638. activityDetail.IsShowSignup = true
  639. }
  640. //专家线下沙龙 5
  641. if activityDetail.ActivityTypeId == 5 {
  642. activityDetail.IsShowSignup = true
  643. }
  644. //分析师线下沙龙 6
  645. if activityDetail.ActivityTypeId == 6 {
  646. activityDetail.IsShowSignup = true
  647. }
  648. //分析师电话会(C类) 7
  649. if activityDetail.ActivityTypeId == 7 {
  650. activityDetail.IsShowSignup = true
  651. activityDetail.IsShowMeetingReminder = true
  652. }
  653. //如果是易董创建的活动,展示我要报名,不展示预约外呼
  654. if activityDetail.IsYidongConduct {
  655. activityDetail.IsShowSignup = true
  656. activityDetail.IsShowOutboundCall = false
  657. }
  658. }
  659. }
  660. activityDetail.IsResearchPoints = activityPointsByUserAllMap[activityDetail.ActivityId]
  661. authInfo, permissionArr, e := GetUserRaiPermissionInfo(user.UserId, user.CompanyId)
  662. if e != nil {
  663. e = errors.New("获取用户权限失败, Err: " + e.Error())
  664. return
  665. }
  666. v := activityDetail
  667. itemActivity = &models.ActivityListResp{
  668. ActivityId: v.ActivityId,
  669. ActivityTypeId: v.ActivityTypeId,
  670. ActivityTypeName: v.ActivityTypeName,
  671. ChartPermissionId: v.ChartPermissionId,
  672. ChartPermissionName: v.ChartPermissionName,
  673. IsLimitPeople: v.IsLimitPeople,
  674. LimitPeopleNum: v.LimitPeopleNum,
  675. LastUpdatedTime: v.LastUpdatedTime,
  676. ActivityTime: v.ActivityTime,
  677. ActivityTimeText: v.ActivityTimeText,
  678. DistinguishedGuest: v.DistinguishedGuest,
  679. Host: v.Host,
  680. Speaker: v.Speaker,
  681. MainlandTell: v.MainlandTell,
  682. HongKongTell: v.HongKongTell,
  683. TaiwanTell: v.TaiwanTell,
  684. AmericaTell: v.AmericaTell,
  685. ParticipationCode: v.ParticipationCode,
  686. Theme: v.Theme,
  687. Expert: v.Expert,
  688. ActivityName: v.ActivityName,
  689. OnlineParticipation: v.OnlineParticipation,
  690. ReportLink: v.ReportLink,
  691. AppAttendance: v.AppAttendance,
  692. ConferencePassword: v.ConferencePassword,
  693. City: v.City,
  694. Address: v.Address,
  695. Highlights: v.Highlights,
  696. Remarks: v.Remarks,
  697. IsSignup: v.IsSignup,
  698. IsCancelMeetingReminder: v.IsCancelMeetingReminder,
  699. IsAppointment: v.IsAppointment,
  700. ActiveState: v.ActiveState,
  701. IsShowSustainable: v.IsShowSustainable,
  702. Description: v.Description,
  703. IsResearch: v.IsResearch,
  704. IsHideAppointment: v.IsHideAppointment,
  705. IsCClassMeeting: v.IsCClassMeeting,
  706. Label: v.Label,
  707. ImgUrl: v.ImgUrl,
  708. ImgUrlText: v.ImgUrlText,
  709. ActivityType: v.ActivityType,
  710. IsShowOutboundCall: v.IsShowOutboundCall,
  711. IsShowMeetingReminder: v.IsShowMeetingReminder,
  712. IsShowHelpSsk: v.IsShowHelpSsk,
  713. IsShowSignup: v.IsShowSignup,
  714. IsShowAppointment: v.IsShowAppointment,
  715. IsShowDetails: v.IsShowDetails,
  716. AudioLink: v.AudioLink,
  717. VoiceDetail: v.VoiceList,
  718. VideoDetail: v.VideoDetail,
  719. FileType: v.FileType,
  720. SourceType: v.SourceType,
  721. SignupNum: v.SignupNum,
  722. YidongActivityUrl: yidongActivityUrl,
  723. Explain: utils.ACtIVITY_SPECIAL_EXPLAIN,
  724. TripImgLink: v.TripImgLink,
  725. Days: v.Days,
  726. SignupType: v.SignupType,
  727. IsYidongConduct: v.IsYidongConduct,
  728. IsCanOutboundCall: v.IsCanOutboundCall,
  729. TencentConferenceNumber: v.TencentConferenceNumber,
  730. IsResearchSpecial: v.IsResearchSpecial,
  731. LinkParticipants: v.LinkParticipants,
  732. IsResearchPoints: v.IsResearchPoints,
  733. IsExternalLabel: v.IsExternalLabel,
  734. SiginupDeadline: v.SiginupDeadline,
  735. CancelDeadline: v.CancelDeadline,
  736. }
  737. au := new(models.UserPermissionAuthInfo)
  738. au.SellerName = authInfo.SellerName
  739. au.SellerMobile = authInfo.SellerMobile
  740. au.HasPermission = authInfo.HasPermission
  741. au.OperationMode = authInfo.OperationMode
  742. if au.HasPermission == 1 {
  743. // 非宏观权限进一步判断是否有权限
  744. if v.ChartPermissionId != utils.HONG_GUAN_ID && !utils.InArrayByStr(permissionArr, v.ChartPermissionName) {
  745. au.HasPermission = 2
  746. }
  747. }
  748. // 无权限的弹框提示
  749. if au.HasPermission != 1 {
  750. if au.OperationMode == UserPermissionOperationModeCall {
  751. if v.FileType == 1 {
  752. au.PopupMsg = UserPermissionPopupMsgCallMicroVoice
  753. } else {
  754. au.PopupMsg = UserPermissionPopupMsgCallMicroVideo
  755. }
  756. } else {
  757. if v.FileType == 1 {
  758. au.PopupMsg = UserPermissionPopupMsgApplyMicroVoice
  759. } else {
  760. au.PopupMsg = UserPermissionPopupMsgApplyMicroVideo
  761. }
  762. }
  763. }
  764. itemActivity.AuthInfo = au
  765. //处理用户已经报名了的行程
  766. var activityIds []int
  767. activityIds = append(activityIds, v.ActivityId)
  768. UserMap, e := GetSpecialTripUserMap(activityIds, user.UserId)
  769. if e != nil {
  770. e = errors.New("GetSpecialTripUserMap, Err: " + e.Error())
  771. return
  772. }
  773. if _, ok := UserMap[v.ActivityId]; ok {
  774. itemActivity.IsTrip = 1
  775. }
  776. if itemActivity.Days == 0 {
  777. itemActivity.TripStatus = 1
  778. //activityDetail.Explain = utils.ACtIVITY_SPECIAL_EXPLAIN
  779. } else {
  780. itemActivity.TripStatus = 2
  781. //itemActivity.TripImgLink = itemActivity.TripImgLinkFix
  782. //activityDetail.Explain = utils.ACtIVITY_SPECIAL_TRIP_EXPLAIN
  783. }
  784. return
  785. }
  786. func ActivityDetaailShow(activityInfo *models.ActivityListResp) (itemActivity *models.ActivityListResp, err error) {
  787. itemActivity = activityInfo
  788. if GetShowSustainable() && strings.Contains(itemActivity.ChartPermissionName, "研选") {
  789. itemActivity.IsShowSustainable = true
  790. }
  791. if activityInfo.SignupNum > activityInfo.LimitPeopleNum {
  792. activityInfo.SignupNum = activityInfo.LimitPeopleNum
  793. }
  794. if activityInfo.ReportLink != "" {
  795. artList, e := GetActivityReportLinkToArticleList(activityInfo)
  796. if e != nil && e.Error() != utils.ErrNoRow() {
  797. err = e
  798. return
  799. }
  800. if len(artList) == 0 {
  801. activityInfo.ArticleList = make([]*models.ActivityArticleResp, 0)
  802. } else {
  803. activityInfo.ArticleList = artList
  804. }
  805. } else {
  806. activityInfo.ArticleList = make([]*models.ActivityArticleResp, 0)
  807. }
  808. activityInfo.ActivityTypeName = strings.Replace(activityInfo.ActivityTypeName, "(C类)", "", -1)
  809. return
  810. }
  811. // GetActivityNewLabelMap 获取活动【新】标签Map
  812. func GetActivityNewLabelMap(activityIds []int) (labelMap map[int]bool, industryNewMap map[int]bool, err error) {
  813. labelMap = make(map[int]bool, 0)
  814. industryNewMap = make(map[int]bool, 0)
  815. if len(activityIds) == 0 {
  816. return
  817. }
  818. // 获取活动关联的产业
  819. var groupCond string
  820. var groupPars []interface{}
  821. groupCond += ` AND a.activity_id IN (` + utils.GetOrmInReplace(len(activityIds)) + `) AND b.source = 1 `
  822. groupPars = append(groupPars, activityIds)
  823. groups, e := models.GetActivityIndustryRelationList(groupCond, groupPars)
  824. if e != nil {
  825. err = errors.New("获取活动产业关联列表失败, Err: " + e.Error())
  826. return
  827. }
  828. activityIndustryMap := make(map[int][]int, 0)
  829. industryIds := make([]int, 0)
  830. for i := range groups {
  831. industryIds = append(industryIds, groups[i].IndustrialManagementId)
  832. activityIndustryMap[groups[i].ActivityId] = append(activityIndustryMap[groups[i].ActivityId], groups[i].IndustrialManagementId)
  833. }
  834. // 获取新产业Map
  835. industryLabelMap, e := GetIndustryNewLabelMap(industryIds)
  836. if e != nil {
  837. err = errors.New("获取产业新标签Map失败, Err: " + e.Error())
  838. return
  839. }
  840. // 判断活动是否为新
  841. for k := range industryLabelMap {
  842. for k2, v2 := range activityIndustryMap {
  843. if labelMap[k2] {
  844. continue
  845. }
  846. // 活动的产业ID中存在一个新产业即为新活动
  847. if utils.InArrayByInt(v2, k) {
  848. labelMap[k2] = true
  849. }
  850. }
  851. }
  852. //
  853. //////产业关联的弘则报告发布日期在三个月以内的活动、产业显示 NEW标签
  854. //articNewLabel, e := GetArticNewLabelWhithActivity3Month()
  855. //if e != nil {
  856. // err = errors.New("获取产业新标签Map失败, Err: " + e.Error())
  857. // return
  858. //}
  859. //for k := range articNewLabel {
  860. // labelMap[k] = true
  861. //}
  862. return
  863. }
  864. // GetIndustryNewLabelMap 获取产业【新】标签Map
  865. func GetIndustryNewLabelMap(industryIds []int) (labelMap map[int]bool, err error) {
  866. labelMap = make(map[int]bool, 0)
  867. industryIdLen := len(industryIds)
  868. if industryIdLen == 0 {
  869. return
  870. }
  871. // 获取产业关联的报告最早发布时间及最近的发布时间
  872. var timeCond string
  873. var timePars []interface{}
  874. timeCond += ` AND b.publish_status = 1`
  875. if industryIdLen > 0 {
  876. timeCond += ` AND a.industrial_management_id IN (` + utils.GetOrmInReplace(industryIdLen) + `)`
  877. timePars = append(timePars, industryIds)
  878. }
  879. //只要弘则报告,不要研选报告
  880. timeCond += ` AND b.article_id < ? `
  881. timePars = append(timePars, utils.SummaryArticleId)
  882. industryTimeList, e := models.GetIndustryArticleMinMaxPublishTime(timeCond, timePars)
  883. if e != nil {
  884. err = errors.New("获取产业文章最大最小发布时间失败, Err: " + e.Error())
  885. return
  886. }
  887. // 判断产业是否为新
  888. nowTime := time.Now().Local()
  889. threeMonthBefore := nowTime.AddDate(0, -3, 0)
  890. nullTime, _ := time.ParseInLocation(utils.FormatDateTime, "0001-01-01 00:00:00", time.Local)
  891. industryMap := make(map[int]*models.IndustryArticleMinMaxPublishTime, 0)
  892. for i := range industryTimeList {
  893. industryMap[industryTimeList[i].IndustrialManagementId] = industryTimeList[i]
  894. }
  895. for i := range industryIds {
  896. iid := industryIds[i]
  897. item := industryMap[iid]
  898. if item != nil {
  899. // 最早发布时间为空 / 最早发布时间在三个月前之后
  900. if item.MinPublishTime.Equal(nullTime) || (item.MinPublishTime.After(threeMonthBefore)) {
  901. labelMap[iid] = true
  902. }
  903. } else {
  904. // 产业无报告, 则为新产业
  905. labelMap[iid] = true
  906. }
  907. }
  908. return
  909. }
  910. // GetSpecialDetailUserPower 处理用户查看详情的权限
  911. func GetActivityDetailUserPower(user *models.WxUserItem, activityInfo *models.ActivityDetail) (havePower, isResearchSpecial bool, err error) {
  912. var companyDetailStatus string
  913. var userTypeStr string
  914. //如果是弘则的用户或者宏观的权限不做校验
  915. if (GetBelongingRai(user.Mobile) && user.CompanyId == utils.HZ_COMPANY_ID) || activityInfo.ChartPermissionName == utils.HONG_GUAN_NAME {
  916. havePower = true
  917. return
  918. }
  919. userType, permissionStr, permissionStrZhengShi, e := GetUserTypeZhengShi(user.CompanyId)
  920. if e != nil {
  921. err = errors.New("GetCompanyPermissionUpgrade, Err: " + e.Error())
  922. return
  923. }
  924. //如果是 公司调研电话会:3,或 专家线下沙龙:5 而且 除易董同步过来的以外的研选类型活动,必须要有研选的正式权限
  925. if (activityInfo.ActivityTypeId == 3 || activityInfo.ActivityTypeId == 5) && activityInfo.YidongActivityId == "" && strings.Contains(activityInfo.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) {
  926. isResearchSpecial = true
  927. }
  928. //如果是 对用户的研选扣点的必须要有研选的正式权限
  929. if activityInfo.IsResearchPoints {
  930. //获取活动对用户要扣的点
  931. userPointsNum, e := models.GetCygxActivityPointsSetUserNum(activityInfo.ActivityId)
  932. if e != nil {
  933. err = errors.New("GetActivitySignupSuccessByUserCountNoHz, Err: " + e.Error())
  934. return
  935. }
  936. if userPointsNum > 0 {
  937. if !strings.Contains(permissionStr, utils.CHART_PERMISSION_NAME_YANXUAN) {
  938. //如果连试用权限都没有,那么久按照普通的研选样式展示
  939. isResearchSpecial = false
  940. }
  941. if !strings.Contains(permissionStrZhengShi, activityInfo.ChartPermissionName) {
  942. havePower = false
  943. return
  944. }
  945. }
  946. }
  947. //处理决策人可见权限
  948. if user.IsMaker == 0 && activityInfo.IsMakerShow == 1 {
  949. havePower = false
  950. return
  951. }
  952. // 处理本组可见权限
  953. if activityInfo.VisibleRange == 1 {
  954. adminIds, e := models.GetSelleridWhichGroup(user.CompanyId, 2)
  955. if e != nil {
  956. err = errors.New("GetSelleridWhichGroup, Err: " + e.Error())
  957. return
  958. }
  959. haveVisibleRange := false
  960. adminIdSlice := strings.Split(adminIds, ",")
  961. for _, v := range adminIdSlice {
  962. if v == strconv.Itoa(activityInfo.AdminId) {
  963. haveVisibleRange = true
  964. }
  965. }
  966. if !haveVisibleRange {
  967. havePower = false
  968. return
  969. }
  970. }
  971. if permissionStr == "" {
  972. return
  973. }
  974. //如果是易董的活动且属于研选类型,只要开通任何权限就可以查看详情
  975. if activityInfo.YidongActivityId != "" && permissionStr != "" && strings.Contains(activityInfo.ChartPermissionName, utils.CHART_PERMISSION_NAME_YANXUAN) {
  976. havePower = true
  977. return
  978. }
  979. //医药消费,科技,智造四大行业,验证主客观。如果主客观校验不通过,那么直接返回
  980. if strings.Contains(utils.YI_YAO_NAME+utils.XIAO_FEI_NAME+utils.KE_JI_NAME+utils.ZHI_ZAO_NAME, activityInfo.ChartPermissionName) {
  981. if activityInfo.ActivityTypeId == 2 || activityInfo.ActivityTypeId == 6 || activityInfo.ActivityTypeId == 7 {
  982. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(主观)") {
  983. havePower = true
  984. } else {
  985. havePower = false
  986. }
  987. } else {
  988. if strings.Contains(permissionStr, activityInfo.ChartPermissionName+"(客观)") {
  989. havePower = true
  990. } else {
  991. havePower = false
  992. }
  993. }
  994. //如果主客观校验不通过,那么直接返回
  995. if !havePower {
  996. return
  997. }
  998. }
  999. if activityInfo.LimitPeopleNum > 0 {
  1000. mapUserType, e := GetActivityCcustomerTypeList()
  1001. if e != nil {
  1002. err = e
  1003. return
  1004. }
  1005. userTypeStr = mapUserType[userType]
  1006. // 永续客户、大套餐客户、30W套餐客户可以查看行业升级套餐客户 权限
  1007. if userTypeStr == "1" || userTypeStr == "2" || userTypeStr == "AA" {
  1008. if strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) && strings.Contains(activityInfo.CustomerTypeIds, "8") {
  1009. havePower = true
  1010. //return
  1011. }
  1012. }
  1013. } else {
  1014. if strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  1015. havePower = true
  1016. return
  1017. }
  1018. }
  1019. //判断管理规模是否满足
  1020. companyProduct, e := models.GetCompanyProductDetail(user.CompanyId, 2)
  1021. if e != nil {
  1022. err = e
  1023. return
  1024. }
  1025. if companyProduct != nil && activityInfo.Scale != "" {
  1026. if strings.Contains(activityInfo.Scale, companyProduct.Scale) {
  1027. havePower = true
  1028. }
  1029. }
  1030. if user.CompanyId <= 1 {
  1031. return
  1032. } else {
  1033. if permissionStr == "" {
  1034. return
  1035. } else {
  1036. companyDetail, e := models.GetCompanyDetailById(user.CompanyId)
  1037. if e != nil {
  1038. err = errors.New("GetCompanyPermissionUpgrade, Err: " + e.Error())
  1039. return
  1040. }
  1041. if companyDetail == nil {
  1042. err = errors.New("客户不存在,uid:" + strconv.Itoa(user.UserId) + "CompanyId:" + strconv.Itoa(user.CompanyId))
  1043. return
  1044. }
  1045. companyDetailStatus = companyDetail.Status
  1046. }
  1047. }
  1048. if activityInfo.ChartPermissionId == 1 {
  1049. havePower = true
  1050. return
  1051. }
  1052. if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3) && strings.Contains(permissionStr, "专家") && activityInfo.LimitPeopleNum == 0 {
  1053. havePower = true
  1054. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "正式" && strings.Contains(activityInfo.CustomerTypeIds, "4") {
  1055. havePower = true
  1056. } else if activityInfo.ActivityTypeId == 3 && strings.Contains(permissionStr, "专家") && companyDetailStatus == "试用" && strings.Contains(activityInfo.CustomerTypeIds, "5") {
  1057. havePower = true
  1058. } else if (activityInfo.ActivityTypeId == 1 || activityInfo.ActivityTypeId == 3 || activityInfo.ActivityTypeId == 4 || activityInfo.ActivityTypeId == 5) && strings.Contains(permissionStr, "专家") {
  1059. havePower = true
  1060. }
  1061. fmt.Println(permissionStrZhengShi)
  1062. //if (strings.Contains(activityInfo.ChartPermissionName, "研选") || activityInfo.ChartPermissionName == "策略") && strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  1063. // havePower = true
  1064. // return
  1065. //}
  1066. if strings.Contains(activityInfo.ChartPermissionName, "研选") || activityInfo.ChartPermissionName == "策略" {
  1067. if strings.Contains(activityInfo.CustomerTypeIds, "5") {
  1068. if strings.Contains(permissionStr, activityInfo.ChartPermissionName) {
  1069. havePower = true
  1070. return
  1071. }
  1072. } else {
  1073. if strings.Contains(permissionStrZhengShi, activityInfo.ChartPermissionName) {
  1074. havePower = true
  1075. return
  1076. }
  1077. }
  1078. }
  1079. permissionShengji, errs := models.GetCompanyPermissionByUserTrip(user.CompanyId)
  1080. if errs != nil {
  1081. err = errs
  1082. return
  1083. }
  1084. //fmt.Println("主客观2", havePower)
  1085. //if strings.Contains(permissionStr, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) {
  1086. // havePower = true
  1087. //}
  1088. //fmt.Println("主客观3", havePower)
  1089. //处理升级权限以及用户身份的 双重判断
  1090. if activityInfo.CustomerTypeIds != "" {
  1091. if !strings.Contains(activityInfo.CustomerTypeIds, userTypeStr) && userTypeStr != "8" {
  1092. havePower = false
  1093. if strings.Contains(permissionShengji, activityInfo.ChartPermissionName) && strings.Contains(activityInfo.CustomerTypeIds, "8") {
  1094. havePower = true
  1095. }
  1096. }
  1097. }
  1098. if havePower && activityInfo.LimitPeopleNum > 0 {
  1099. //对于一些特殊的活动,即使权限满足也不给产看
  1100. noPower, e := GetShareNoPowe(activityInfo, permissionStr, userType, user)
  1101. if e != nil {
  1102. err = errors.New("GetShareNoPowe, Err: " + e.Error())
  1103. return
  1104. }
  1105. if noPower {
  1106. havePower = false
  1107. }
  1108. }
  1109. return
  1110. }
  1111. // 校验被分享的用户是否有查看详情的权限
  1112. func GetShareNoPowe(activityInfo *models.ActivityDetail, permissionStr string, userType int, user *models.WxUserItem) (noPower bool, err error) {
  1113. //如果是弘则的就不进行可见权限校验
  1114. if user.CompanyId == utils.HZ_COMPANY_ID {
  1115. return
  1116. }
  1117. //var noPower bool
  1118. //if !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(userType)) {
  1119. // noPower = true
  1120. //}
  1121. //1、永续客户 //2、大套餐客户(4个行业全开通的正式客户) //3、分行业套餐客户(开通对应行业的正式客户) //4、仅开通专家套餐的正式客户 //5、开通对应行业套餐或专家套餐的试用客户
  1122. //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)) {
  1123. // noPower = true
  1124. //}
  1125. //if userType == 2 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(2)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
  1126. // noPower = true
  1127. //}
  1128. //if userType == 3 && strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(4)) {
  1129. // noPower = true
  1130. //}
  1131. //if userType == 3 && !strings.Contains(permissionStr, "专家") && !strings.Contains(activityInfo.CustomerTypeIds, strconv.Itoa(3)) {
  1132. // noPower = true
  1133. //}
  1134. if userType == 8 {
  1135. permissionShengji, errs := models.GetCompanyPermissionByUserZhengShiTrip(user.CompanyId)
  1136. if errs != nil {
  1137. err = errs
  1138. return
  1139. }
  1140. if !strings.Contains(permissionShengji, activityInfo.ChartPermissionName) {
  1141. noPower = true
  1142. return
  1143. }
  1144. }
  1145. if !noPower {
  1146. noPower, err = CheckUserPowerByActivityChoose(user, activityInfo)
  1147. }
  1148. return
  1149. }
  1150. // 处理活动本组们是否决策人权限
  1151. func CheckUserPowerByActivityChoose(user *models.WxUserItem, activityInfo *models.ActivityDetail) (noPower bool, err error) {
  1152. //处理 见范围 1,仅本组可见 、2,全部客户可见
  1153. if activityInfo.VisibleRange == 1 {
  1154. adminIds, errAdmin := models.GetSelleridWhichGroup(user.CompanyId, 2)
  1155. if errAdmin != nil {
  1156. err = errAdmin
  1157. return
  1158. }
  1159. sliceAdminIds := strings.Split(adminIds, ",")
  1160. var haveAdminId bool
  1161. for _, v := range sliceAdminIds {
  1162. if v == strconv.Itoa(activityInfo.AdminId) {
  1163. haveAdminId = true
  1164. }
  1165. }
  1166. if !haveAdminId {
  1167. noPower = true
  1168. }
  1169. }
  1170. //处理 是否仅决策人可见 0,否 、1,是
  1171. if activityInfo.IsMakerShow == 1 {
  1172. if user.IsMaker == 0 {
  1173. noPower = true
  1174. }
  1175. }
  1176. return
  1177. }
  1178. // 判断预约纪要按钮是否显示
  1179. func IsShowAppointment(activityTypeId int, chartPermissionName string) (isShowAppointment bool) {
  1180. if activityTypeId == 1 || activityTypeId == 2 || activityTypeId == 3 || activityTypeId == 4 {
  1181. isShowAppointment = true
  1182. }
  1183. if activityTypeId == 5 && chartPermissionName == "医药" {
  1184. isShowAppointment = true
  1185. }
  1186. return
  1187. }
  1188. // GetindustryVideoDetailById 通过视频ID获取视频详情
  1189. func GetActivityVideoDetailById(user *models.WxUserItem, videoId int) (industryVideo *models.CygxActivityVideoDetailResp, AuthInfo *models.UserPermissionAuthInfo, err error) {
  1190. total, e := models.GetActivityVideoByVideoIdCount(videoId)
  1191. if e != nil {
  1192. err = errors.New("获取活动的视频失败,GetActivityVideoByVideoIdCount " + e.Error())
  1193. return
  1194. }
  1195. if total == 0 {
  1196. err = errors.New("视频不存在,或已取消发布")
  1197. return
  1198. }
  1199. // 用户权限
  1200. authInfo, permissionArr, e := GetUserRaiPermissionInfo(user.UserId, user.CompanyId)
  1201. if e != nil {
  1202. err = errors.New("获取用户权限失败,GetUserRaiPermissionInfo " + e.Error())
  1203. return
  1204. }
  1205. videoSimple := new(models.CygxActivityVideoDetailResp)
  1206. // 权限
  1207. var au *models.UserPermissionAuthInfo
  1208. videoSimple, e = models.GetCygxActivityVideoById(videoId)
  1209. if e != nil {
  1210. err = errors.New("获取产业关联的视频失败,GetMicroRoadshowVideoByIndustryId " + e.Error())
  1211. return
  1212. } else {
  1213. //videoSimple.Id = video.Id
  1214. //videoSimple.Title = video.Title
  1215. //videoSimple.ResourceUrl = video.ResourceUrl
  1216. //videoSimple.PlaySeconds = video.PlaySeconds
  1217. //videoSimple.ActivityId = video.ActivityId
  1218. //videoSimple.ChartPermissionId = video.ChartPermissionId
  1219. if videoSimple.BackgroundImg == "" {
  1220. // 获取默认图配置
  1221. _, videoMap, _, _, e := GetMicroRoadShowDefaultImgConfig()
  1222. if e != nil {
  1223. err = errors.New("获取视频默认配置图失败,GetMicroRoadshowVideoByIndustryId " + e.Error())
  1224. return
  1225. }
  1226. videoSimple.BackgroundImg = videoMap[videoSimple.ChartPermissionId]
  1227. }
  1228. au = new(models.UserPermissionAuthInfo)
  1229. au.SellerName = authInfo.SellerName
  1230. au.SellerMobile = authInfo.SellerMobile
  1231. au.HasPermission = authInfo.HasPermission
  1232. au.OperationMode = authInfo.OperationMode
  1233. if au.HasPermission == 1 {
  1234. // 非宏观权限进一步判断是否有权限
  1235. if videoSimple.ChartPermissionId != utils.HONG_GUAN_ID && !utils.InArrayByStr(permissionArr, videoSimple.ChartPermissionName) {
  1236. au.HasPermission = 2
  1237. }
  1238. }
  1239. // 无权限的弹框提示
  1240. if au.HasPermission != 1 {
  1241. if au.OperationMode == UserPermissionOperationModeCall {
  1242. au.PopupMsg = UserPermissionPopupMsgCallMicroVideo
  1243. } else {
  1244. au.PopupMsg = UserPermissionPopupMsgApplyMicroVideo
  1245. }
  1246. videoSimple.ResourceUrl = ""
  1247. }
  1248. }
  1249. industryVideo = videoSimple
  1250. AuthInfo = au
  1251. return
  1252. }
  1253. // 用户活动操作行为,模板消息推送
  1254. func ActivityUserRemind(user *models.WxUserItem, activityDetail *models.ActivityDetail, source int) (err error) {
  1255. defer func() {
  1256. if err != nil {
  1257. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "ActivityUserRemind ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1258. }
  1259. }()
  1260. //获取销售手机号
  1261. countUser, e := models.GetUserRemind(user.UserId)
  1262. if e != nil {
  1263. err = errors.New("GetUserRemind, Err: " + e.Error())
  1264. return
  1265. }
  1266. //获取销售手机号
  1267. sellerItemQy, e := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1268. if e != nil && e.Error() != utils.ErrNoRow() {
  1269. err = errors.New("GetSellerByCompanyIdCheckFicc, Err: " + e.Error())
  1270. return
  1271. }
  1272. if sellerItemQy == nil {
  1273. err = nil
  1274. return
  1275. }
  1276. //某销售下的所有客户活动报名/预约外呼时,模板消息提醒该销售(可设置销售范围,随时增减销售)
  1277. conf, e := models.GetConfigByCode("tpl_msg_seller_mobile")
  1278. if e != nil {
  1279. err = errors.New("GetConfigByCode, Err: " + e.Error())
  1280. return
  1281. }
  1282. //如果用户没有设置消息提醒,而且销售的手机号也没有添加到配置中,那么就不推送模版消息
  1283. if countUser == 0 && !strings.Contains(conf.ConfigValue, sellerItemQy.Mobile) {
  1284. err = nil
  1285. return
  1286. }
  1287. var sourceMsg string
  1288. if source == 1 {
  1289. sourceMsg = "预约外呼"
  1290. } else if source == 2 {
  1291. sourceMsg = "设置会议提醒"
  1292. } else if source == 3 {
  1293. sourceMsg = "预约纪要"
  1294. } else if source == 4 {
  1295. sourceMsg = "活动报名"
  1296. }
  1297. openIdList, e := models.GetUserRecordListByMobile(4, sellerItemQy.Mobile)
  1298. if e != nil {
  1299. err = errors.New("GetUserRecordListByMobile, Err: " + e.Error())
  1300. return err
  1301. }
  1302. var keyword1 string
  1303. var keyword2 string
  1304. keyword1 = activityDetail.ActivityName
  1305. keyword2 = fmt.Sprint("互动:", sourceMsg, ",", user.RealName, "--", user.CompanyName)
  1306. SendWxMsgWithActivityUserRemind(keyword1, keyword2, openIdList, activityDetail.ActivityId)
  1307. return
  1308. }
  1309. // 用户音视频回放操作操作行为,模板消息推送
  1310. func ActivityVideoUserRmind(user *models.WxUserItem, activityId, fileType int) (err error) {
  1311. defer func() {
  1312. if err != nil {
  1313. go utils.SendAlarmMsg("用户音视频回放操作操作行为,模板消息推送失败"+err.Error(), 2)
  1314. }
  1315. }()
  1316. countUser, err := models.GetUserRemind(user.UserId)
  1317. if err != nil {
  1318. return err
  1319. }
  1320. if countUser == 0 {
  1321. return err
  1322. }
  1323. var first string
  1324. var keyword1 string
  1325. var keyword2 string
  1326. var keyword3 string
  1327. var keyword4 string
  1328. var remark string
  1329. //获取销售手机号
  1330. sellerItemQy, err := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  1331. if err != nil && err.Error() != utils.ErrNoRow() {
  1332. return err
  1333. }
  1334. if sellerItemQy != nil {
  1335. openIdList, e := models.GetWxOpenIdByMobileList(sellerItemQy.Mobile)
  1336. if e != nil {
  1337. err = errors.New("GetSellerByAdminId, Err: " + e.Error())
  1338. return
  1339. }
  1340. //TripStatus int `description:"行程进行状态 1:预报名,2:确定行程"`
  1341. if fileType == 1 {
  1342. activityInfo, e := models.GetCygxActivityVideoByActivityId(activityId)
  1343. if e != nil {
  1344. err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
  1345. return
  1346. }
  1347. if activityInfo == nil {
  1348. return
  1349. }
  1350. keyword1 = activityInfo.VideoName
  1351. keyword2 = fmt.Sprint("互动:播放视频,", user.RealName, "--", user.CompanyName)
  1352. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:播放视频")
  1353. } else {
  1354. activityInfo, e := models.GetCygxActivityVoiceByActivityId(activityId)
  1355. if e != nil {
  1356. err = errors.New("GetCygxActivitySpecialDetailById, Err: " + e.Error())
  1357. return
  1358. }
  1359. if activityInfo == nil {
  1360. return
  1361. }
  1362. keyword1 = activityInfo.VoiceName
  1363. keyword2 = fmt.Sprint("互动:播放音频,", user.RealName, "--", user.CompanyName)
  1364. first = fmt.Sprint(user.RealName, "--", user.CompanyName, ",有新的互动:播放音频")
  1365. }
  1366. //keyword2 = "__"
  1367. //remark = "点击查看活动详情"
  1368. openIdArr := make([]string, 0)
  1369. for _, v := range openIdList {
  1370. openIdArr = append(openIdArr, v.OpenId)
  1371. }
  1372. redirectUrl := utils.WX_MSG_PATH_ACTIVITY_SPECIAL_DETAIL + strconv.Itoa(activityId)
  1373. sendInfo := new(SendWxTemplate)
  1374. sendInfo.First = first
  1375. sendInfo.Keyword1 = keyword1
  1376. sendInfo.Keyword2 = keyword2
  1377. sendInfo.Keyword3 = keyword3
  1378. sendInfo.Keyword4 = keyword4
  1379. sendInfo.Remark = remark
  1380. sendInfo.TemplateId = utils.WxMsgTemplateIdArticleUserRemind
  1381. sendInfo.RedirectUrl = redirectUrl
  1382. sendInfo.RedirectTarget = 3
  1383. sendInfo.Resource = strconv.Itoa(activityId)
  1384. sendInfo.SendType = utils.TEMPLATE_MSG_CYGX_ARTICLE_ADD
  1385. sendInfo.OpenIdArr = openIdArr
  1386. err = PublicSendTemplateMsg(sendInfo)
  1387. if err != nil {
  1388. return
  1389. }
  1390. }
  1391. return
  1392. }