activity.go 62 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "fmt"
  5. "github.com/medivhzhan/weapp/v2"
  6. "github.com/tealeg/xlsx"
  7. "hongze/hongze_cygx/models"
  8. "hongze/hongze_cygx/services"
  9. "hongze/hongze_cygx/utils"
  10. "os"
  11. "path/filepath"
  12. "rdluck_tools/paging"
  13. "strconv"
  14. "strings"
  15. "time"
  16. )
  17. //活动
  18. type ActivityCoAntroller struct {
  19. BaseAuthController
  20. }
  21. type ActivityABaseController struct {
  22. BaseCommonController
  23. }
  24. // @Title 活动类型列表
  25. // @Description活动类型列表接口
  26. // @Success 200 {object} models.ActivityTypeListResp
  27. // @router /activityTypelist [get]
  28. func (this *ActivityCoAntroller) List() {
  29. br := new(models.BaseResponse).Init()
  30. defer func() {
  31. this.Data["json"] = br
  32. this.ServeJSON()
  33. }()
  34. user := this.User
  35. if user == nil {
  36. br.Msg = "请登录"
  37. br.ErrMsg = "请登录,SysUser Is Empty"
  38. br.Ret = 408
  39. return
  40. }
  41. resp := new(models.ActivityTypeListResp)
  42. list, err := models.GetActivityTypeList()
  43. if err != nil {
  44. br.Msg = "获取失败"
  45. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  46. return
  47. }
  48. resp.List = list
  49. br.Ret = 200
  50. br.Success = true
  51. br.Msg = "获取成功"
  52. br.Data = resp
  53. }
  54. // @Title 活动列表
  55. // @Description 获取活动列表接口
  56. // @Param PageSize query int true "每页数据条数"
  57. // @Param CurrentIndex query int true "当前页页码,从1开始"
  58. // @Param ChartPermissionIds query string false "行业id 多个用 , 隔开"
  59. // @Param ActivityTypeIds query string false "活动类型id 多个用 , 隔开"
  60. // @Param KeyWord query string false "搜索关键词 多个用 , 隔开"
  61. // @Param ActiveState query string false "活动进行状态 未开始:1、进行中2、已结束3"
  62. // @Param WhichDay query string false "哪一天 今天:1、明天:2,多个用 , 隔开"
  63. // @Param IsShowJurisdiction query int false "是否仅展示有权限的,1是,2否 默认为零"
  64. // @Param Label query string false "搜索主题 多个用 , 隔开"
  65. // @Success 200 {object} models.GetCygxActivityListRep
  66. // @router /list [get]
  67. func (this *ActivityCoAntroller) ActivityList() {
  68. br := new(models.BaseResponse).Init()
  69. defer func() {
  70. this.Data["json"] = br
  71. this.ServeJSON()
  72. }()
  73. user := this.User
  74. if user == nil {
  75. br.Msg = "请登录"
  76. br.ErrMsg = "请登录,SysUser Is Empty"
  77. return
  78. }
  79. uid := user.UserId
  80. pageSize, _ := this.GetInt("PageSize")
  81. currentIndex, _ := this.GetInt("CurrentIndex")
  82. chartPermissionIds := this.GetString("ChartPermissionIds")
  83. activityTypeIds := this.GetString("ActivityTypeIds")
  84. whichDay := this.GetString("WhichDay")
  85. isShowJurisdiction, _ := this.GetInt("IsShowJurisdiction")
  86. keyWord := this.GetString("KeyWord")
  87. activeState := this.GetString("ActiveState")
  88. label := this.GetString("Label")
  89. //入参为 undefined 时的处理
  90. if chartPermissionIds == "undefined" {
  91. chartPermissionIds = ""
  92. }
  93. if activityTypeIds == "undefined" {
  94. activityTypeIds = ""
  95. }
  96. if whichDay == "undefined" {
  97. whichDay = ""
  98. }
  99. if activeState == "undefined" {
  100. activeState = ""
  101. }
  102. if label == "undefined" {
  103. label = ""
  104. }
  105. //更新用户的搜索信息
  106. itemSearch := new(models.CygxActivityUserSearchContent)
  107. itemSearch.UserId = uid
  108. itemSearch.CreateTime = time.Now()
  109. itemSearch.Mobile = user.Mobile
  110. itemSearch.Email = user.Email
  111. itemSearch.CompanyId = user.CompanyId
  112. itemSearch.CompanyName = user.CompanyName
  113. itemSearch.ModifyTime = time.Now()
  114. itemSearch.ChartPermissionids = chartPermissionIds
  115. itemSearch.ActivityTypeids = activityTypeIds
  116. itemSearch.ActiveState = activeState
  117. itemSearch.IsShowJurisdiction = isShowJurisdiction
  118. //并发缓存校验
  119. cacheKey := fmt.Sprint("xygx:activity_user_search:add:", uid)
  120. ttlTime := utils.Rc.GetRedisTTL(cacheKey)
  121. _, errSearch := models.AddUserSearchContent(itemSearch, ttlTime)
  122. if errSearch != nil {
  123. br.Msg = "操作失败"
  124. br.ErrMsg = "操作失败,Err:" + errSearch.Error()
  125. return
  126. }
  127. utils.Rc.SetNX(cacheKey, user.Mobile, time.Second*10)
  128. userType, permissionStr, err := services.GetUserType(user.CompanyId)
  129. if isShowJurisdiction == 1 && chartPermissionIds == "" && userType == 4 {
  130. activityTypeIds = "1,3"
  131. }
  132. var startSize int
  133. if pageSize <= 0 {
  134. pageSize = utils.PageSize20
  135. }
  136. if currentIndex <= 0 {
  137. currentIndex = 1
  138. }
  139. startSize = utils.StartIndex(currentIndex, pageSize)
  140. var condition string
  141. var pars []interface{}
  142. //活动可见限制
  143. var sqlExport string
  144. slicePer := strings.Split(permissionStr, ",")
  145. var permissionSqlStr string
  146. for _, v := range slicePer {
  147. if userType == 1 {
  148. if v != "研选" {
  149. permissionSqlStr += "'" + v + "',"
  150. }
  151. } else {
  152. permissionSqlStr += "'" + v + "',"
  153. }
  154. }
  155. permissionSqlStr = strings.TrimRight(permissionSqlStr, ",")
  156. permissionSqlStr = ` AND art.chart_permission_name IN (` + permissionSqlStr + `)`
  157. sqlExport = ` AND (art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' `
  158. if userType == 2 {
  159. sqlExport += ` OR art.customer_type_ids LIKE '%3%' `
  160. }
  161. if (userType == 2 || userType == 3) && strings.Contains(permissionStr, "专家") {
  162. sqlExport += ` OR art.customer_type_ids LIKE '%4%' `
  163. }
  164. sqlExport += `) `
  165. if keyWord != "" {
  166. var mirrorword string
  167. var mirrorwordSql string
  168. slicemirrorword := strings.Split(keyWord, ",")
  169. for _, v := range slicemirrorword {
  170. mirrorwordSql += "'" + v + "'" + ","
  171. }
  172. mirrorwordSql = strings.TrimRight(mirrorwordSql, ",")
  173. total, err := models.GetActivityMirrorWordCount(mirrorwordSql)
  174. if err != nil {
  175. br.Msg = "获取失败"
  176. br.ErrMsg = "获取失败,Err:" + err.Error()
  177. return
  178. }
  179. if total > 0 {
  180. mirrorword, err = models.GetMirrorWord(mirrorwordSql)
  181. if err != nil {
  182. br.Msg = "获取信息失败"
  183. br.ErrMsg = "关系词映射获取失败,Err:" + err.Error()
  184. return
  185. }
  186. }
  187. keyWord = keyWord + "," + mirrorword
  188. slicekeyWord := strings.Split(keyWord, ",")
  189. var sqlKeyOr string
  190. if len(slicekeyWord) >= 2 {
  191. for _, v := range slicekeyWord {
  192. if v != "" {
  193. sqlKeyOr += ` OR art.activity_name LIKE '%` + v + `%' `
  194. }
  195. }
  196. condition += ` AND (art.activity_name LIKE '%` + keyWord + `%' ` + sqlKeyOr + ` )`
  197. } else {
  198. condition += ` AND (art.activity_name LIKE '%` + keyWord + `%' )`
  199. }
  200. }
  201. //主题
  202. if label != "" {
  203. sliceLabel := strings.Split(label, ",")
  204. var labelSqlStr string
  205. for _, v := range sliceLabel {
  206. labelSqlStr += "'" + v + "',"
  207. }
  208. labelSqlStr = strings.TrimRight(labelSqlStr, ",")
  209. condition = ` AND art.label IN (` + labelSqlStr + `)`
  210. }
  211. //行业名称
  212. if len(chartPermissionIds) > 0 {
  213. condition += ` AND art.chart_permission_id IN (` + chartPermissionIds + `)`
  214. }
  215. if activityTypeIds != "" {
  216. condition += ` AND art.activity_type_id IN (` + activityTypeIds + `)`
  217. }
  218. if whichDay != "" {
  219. var startDate string
  220. var endDate string
  221. if whichDay == "1" {
  222. startDate = time.Now().Format(utils.FormatDate)
  223. endDate = startDate
  224. } else if whichDay == "2" {
  225. startDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  226. endDate = startDate
  227. } else {
  228. startDate = time.Now().Format(utils.FormatDate)
  229. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  230. }
  231. condition += ` AND art.activity_time >= ` + "'" + startDate + " 00:00:00'"
  232. condition += ` AND art.activity_time <= ` + "'" + endDate + " 23:59:59'"
  233. }
  234. if activeState != "" {
  235. condition += ` AND art.active_state IN (` + activeState + `)`
  236. }
  237. condition += ` AND art.publish_status = 1 `
  238. var conditionOr string
  239. // 有专家权限的这几种用户,不做行业权限校验
  240. if (userType == 2 || userType == 3 || userType == 4) && strings.Contains(permissionStr, "专家") {
  241. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%4%' ` + condition + `) `
  242. }
  243. if (userType == 5) && strings.Contains(permissionStr, "专家") {
  244. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%5%' ` + condition + `) `
  245. }
  246. if userType == 1 {
  247. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + permissionSqlStr + `) `
  248. } else {
  249. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
  250. }
  251. condition += ` AND art.is_limit_people = 1 ` + permissionSqlStr + sqlExport + conditionOr
  252. total, err := models.GetActivityCount(condition, pars)
  253. if err != nil {
  254. br.Msg = "获取失败"
  255. br.ErrMsg = "获取失败,Err:" + err.Error()
  256. return
  257. }
  258. if activeState == "2" || activeState == "3" {
  259. condition += ` ORDER BY art.activity_time DESC `
  260. } else {
  261. condition += ` ORDER BY art.active_state ASC, art.activity_time ASC `
  262. }
  263. list, errList := models.GetActivityListAll(condition, pars, uid, startSize, pageSize)
  264. if errList != nil {
  265. br.Msg = "获取失败"
  266. br.ErrMsg = "获取失败,Err:" + errList.Error()
  267. return
  268. }
  269. for k, v := range list {
  270. if strings.Contains(v.ActivityName, "【") {
  271. list[k].IsBrackets = 1
  272. }
  273. if v.SignupNum > v.LimitPeopleNum {
  274. list[k].SignupNum = v.LimitPeopleNum
  275. }
  276. if services.GetShowSustainable() && v.ChartPermissionName == "研选" {
  277. list[k].IsShowSustainable = true
  278. }
  279. }
  280. page := paging.GetPaging(currentIndex, pageSize, total)
  281. resp := new(models.GetCygxActivityListRep)
  282. resp.List = list
  283. resp.Paging = page
  284. br.Ret = 200
  285. br.Success = true
  286. br.Msg = "获取成功"
  287. br.Data = resp
  288. }
  289. // @Title 我的日程
  290. // @Description 我的日程列表接口
  291. // @Param PageSize query int true "每页数据条数"
  292. // @Param CurrentIndex query int true "当前页页码,从1开始"
  293. // @Success 200 {object} models.GetCygxActivityListRep
  294. // @router /scheduleList [get]
  295. func (this *ActivityCoAntroller) ScheduleList() {
  296. br := new(models.BaseResponse).Init()
  297. defer func() {
  298. this.Data["json"] = br
  299. this.ServeJSON()
  300. }()
  301. user := this.User
  302. if user == nil {
  303. br.Msg = "请登录"
  304. br.ErrMsg = "请登录,SysUser Is Empty"
  305. return
  306. }
  307. uid := user.UserId
  308. pageSize, _ := this.GetInt("PageSize")
  309. currentIndex, _ := this.GetInt("CurrentIndex")
  310. var startSize int
  311. if pageSize <= 0 {
  312. pageSize = utils.PageSize20
  313. }
  314. if currentIndex <= 0 {
  315. currentIndex = 1
  316. }
  317. startSize = utils.StartIndex(currentIndex, pageSize)
  318. var condition string
  319. var conditionCount string
  320. var pars []interface{}
  321. condition += ` AND art.publish_status = 1 `
  322. total, err := models.GetScheduleCount(conditionCount, uid)
  323. page := paging.GetPaging(currentIndex, pageSize, total)
  324. if err != nil {
  325. br.Msg = "获取失败"
  326. br.ErrMsg = "获取失败,Err:" + err.Error()
  327. return
  328. }
  329. conditionCount = ` AND art.active_state = 2 `
  330. totalCount, err := models.GetScheduleCount(conditionCount, uid) //获取正在进行中的活动数量
  331. if err != nil {
  332. br.Msg = "获取失败"
  333. br.ErrMsg = "获取失败,Err:" + err.Error()
  334. return
  335. }
  336. var list []*models.CygxActivityList
  337. fmt.Println(totalCount)
  338. //全部都是进行中的活动
  339. if totalCount > currentIndex*pageSize {
  340. condition += ` AND art.active_state IN(2) `
  341. listHave, errList := models.GetScheduleList(condition, pars, uid, startSize, pageSize)
  342. list = listHave
  343. if errList != nil {
  344. br.Msg = "获取失败"
  345. br.ErrMsg = "获取失败,Err:" + errList.Error()
  346. return
  347. }
  348. fmt.Println("22222")
  349. } else if totalCount > currentIndex-1*pageSize && totalCount < currentIndex*pageSize { //部分是进行中的活动
  350. condition = ` AND art.publish_status = 1 AND art.active_state IN(2) `
  351. listHave, errList := models.GetScheduleList(condition, pars, uid, startSize, pageSize)
  352. list = listHave
  353. if errList != nil {
  354. br.Msg = "获取失败"
  355. br.ErrMsg = "获取失败,Err:" + errList.Error()
  356. return
  357. }
  358. fmt.Println("33333")
  359. pageSize = pageSize - len(listHave)
  360. condition = ` AND art.publish_status = 1 AND art.active_state IN(1,3) `
  361. listOther, errList := models.GetScheduleList(condition, pars, uid, startSize, pageSize)
  362. if errList != nil {
  363. br.Msg = "获取失败"
  364. br.ErrMsg = "获取失败,Err:" + errList.Error()
  365. return
  366. }
  367. fmt.Println("长度", len(listOther))
  368. if len(listOther) > 0 {
  369. for _, v := range listOther {
  370. list = append(list, v)
  371. }
  372. }
  373. } else {
  374. condition += ` AND art.active_state IN(1,3)` //全部都不是进行中的活动
  375. listOther, errList := models.GetScheduleList(condition, pars, uid, startSize, pageSize)
  376. list = listOther
  377. if errList != nil {
  378. br.Msg = "获取失败"
  379. br.ErrMsg = "获取失败,Err:" + errList.Error()
  380. return
  381. }
  382. }
  383. for k, v := range list {
  384. if strings.Contains(v.ActivityName, "【") {
  385. list[k].IsBrackets = 1
  386. }
  387. if v.SignupNum > v.LimitPeopleNum {
  388. list[k].SignupNum = v.LimitPeopleNum
  389. }
  390. //是否展示限免标签
  391. if services.GetShowSustainable() && v.ChartPermissionName == "研选" {
  392. list[k].IsShowSustainable = true
  393. }
  394. }
  395. resp := new(models.GetCygxActivityListRep)
  396. resp.List = list
  397. resp.Paging = page
  398. br.Ret = 200
  399. br.Success = true
  400. br.Msg = "获取成功"
  401. br.Data = resp
  402. }
  403. // @Title 活动详情
  404. // @Description 获取活动详情接口
  405. // @Param ActivityId query int true "活动ID"
  406. // @Success Ret=200 {object} models.CygxActivityResp
  407. // @router /detail [get]
  408. func (this *ActivityCoAntroller) Detail() {
  409. br := new(models.BaseResponse).Init()
  410. defer func() {
  411. this.Data["json"] = br
  412. this.ServeJSON()
  413. }()
  414. user := this.User
  415. if user == nil {
  416. br.Msg = "请登录"
  417. br.ErrMsg = "请登录,用户信息为空"
  418. br.Ret = 408
  419. return
  420. }
  421. uid := user.UserId
  422. activityId, _ := this.GetInt("ActivityId")
  423. if activityId < 1 {
  424. br.Msg = "请输入活动ID"
  425. return
  426. }
  427. resp := new(models.CygxActivityResp)
  428. hasPermission := 0
  429. var companyDetailStatus string
  430. activityInfo, err := models.GetAddActivityInfoByIdShow(uid, activityId)
  431. if err != nil && err.Error() != utils.ErrNoRow() {
  432. br.Msg = "获取信息失败"
  433. br.ErrMsg = "判断是否已申请过试用失败,Err:" + err.Error()
  434. return
  435. }
  436. if activityInfo == nil {
  437. br.Msg = "活动不存在"
  438. br.ErrMsg = "活动ID错误,Err:" + "activityId:" + strconv.Itoa(activityId)
  439. return
  440. }
  441. applyCount, err := models.GetApplyRecordCount(uid)
  442. if err != nil && err.Error() != utils.ErrNoRow() {
  443. br.Msg = "获取信息失败"
  444. br.ErrMsg = "判断是否已申请过试用失败,Err:" + err.Error()
  445. return
  446. }
  447. if user.CompanyId <= 1 {
  448. companyDetailStatus = ""
  449. } else {
  450. companyPermission, err := models.GetCompanyPermission(user.CompanyId)
  451. if err != nil {
  452. br.Msg = "获取信息失败"
  453. br.ErrMsg = "获取客户详情失败,Err:" + err.Error()
  454. return
  455. }
  456. if companyPermission == "" {
  457. if applyCount > 0 {
  458. hasPermission = 4
  459. } else {
  460. hasPermission = 3
  461. }
  462. resp.HasPermission = hasPermission
  463. resp.OperationMode = "Apply"
  464. resp.PopupMsg = "您暂无权限参加 【" + activityInfo.ChartPermissionName + "】行业活动,若想参加可以申请开通哦"
  465. br.Ret = 200
  466. br.Success = true
  467. br.Msg = "获取成功"
  468. br.Data = resp
  469. return
  470. }
  471. companyDetail, err := models.GetCompanyDetailById(user.CompanyId)
  472. if err != nil {
  473. br.Msg = "获取信息失败!"
  474. br.ErrMsg = "获取客户详情失败,Err:" + err.Error()
  475. return
  476. }
  477. if companyDetail == nil {
  478. br.Msg = "获取信息失败!"
  479. br.ErrMsg = "客户不存在,uid:" + strconv.Itoa(user.UserId) + "CompanyId:" + strconv.Itoa(user.CompanyId)
  480. return
  481. }
  482. companyDetailStatus = companyDetail.Status
  483. }
  484. userType, permissionStr, err := services.GetUserType(user.CompanyId)
  485. if err != nil {
  486. br.Msg = "获取信息失败"
  487. br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  488. return
  489. }
  490. if activityInfo.IsLimitPeople > 0 {
  491. noPower, err := services.GetShareNoPowe(activityInfo, permissionStr, userType)
  492. if err != nil {
  493. br.Msg = "获取信息失败"
  494. br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  495. return
  496. }
  497. if noPower {
  498. br.Msg = "您暂无查看该活动权限"
  499. br.ErrMsg = "被分享客户不可见,获取信息失败"
  500. return
  501. }
  502. }
  503. if userType == 1 && activityInfo.ChartPermissionName == "研选" {
  504. br.Msg = "您暂无查看该活动权限"
  505. br.ErrMsg = "被分享客户不可见,永续客户无法查看研选行业"
  506. return
  507. }
  508. detail, errDetail := models.GetActivityTypeDetailById(activityInfo.ActivityTypeId)
  509. if errDetail != nil {
  510. br.Msg = "获取信息失败"
  511. br.ErrMsg = "获取信息失败,Err:" + errDetail.Error()
  512. return
  513. }
  514. if activityInfo.IsSignup > 0 {
  515. detail, errDetail := models.GetActivitySignupDetail(activityId, uid)
  516. if errDetail != nil {
  517. br.Msg = "获取信息失败"
  518. br.ErrMsg = "获取信息失败,Err:" + errDetail.Error()
  519. return
  520. }
  521. activityInfo.SignupType = detail.SignupType
  522. }
  523. activityInfo.ShowType = detail.ShowType
  524. //判断是否已经申请过
  525. if user.CompanyId > 1 {
  526. permissionStr, err := models.GetCompanyPermission(user.CompanyId)
  527. if err != nil {
  528. br.Msg = "获取信息失败"
  529. br.ErrMsg = "获取客户权限信息失败,Err:" + err.Error()
  530. return
  531. }
  532. companyItem, err := models.GetCompanyDetailById(user.CompanyId)
  533. //冻结客户
  534. if err != nil {
  535. if err.Error() == utils.ErrNoRow() {
  536. resp.HasPermission = 4
  537. resp.OperationMode = "Apply"
  538. resp.PopupMsg = "您暂无权限参加 【" + activityInfo.ChartPermissionName + "】行业活动"
  539. br.Ret = 200
  540. br.Success = true
  541. br.Msg = "获取成功"
  542. br.Data = resp
  543. return
  544. } else {
  545. br.Msg = "获取信息失败"
  546. br.ErrMsg = "获取客户公司信息失败,Err:" + err.Error()
  547. return
  548. }
  549. }
  550. havePower, err := services.GetHavePower(activityInfo, permissionStr, companyDetailStatus, userType)
  551. if havePower {
  552. hasPermission = 1
  553. resp.HaqveJurisdiction = true
  554. } else {
  555. if permissionStr == "专家" {
  556. resp.PopupMsg = "您暂无权限参加【" + activityInfo.ActivityTypeName + "】类型活动"
  557. resp.MsgType = "Type"
  558. } else {
  559. resp.PopupMsg = "您暂无权限参加【" + activityInfo.ChartPermissionName + "】行业活动"
  560. resp.MsgType = "Industry"
  561. }
  562. resp.SellerMobile = companyItem.Mobile
  563. resp.SellerName = companyItem.SellerName
  564. resp.OperationMode = "Call"
  565. hasPermission = 2
  566. }
  567. } else { //潜在客户
  568. if applyCount > 0 {
  569. hasPermission = 4
  570. } else {
  571. hasPermission = 3
  572. }
  573. resp.OperationMode = "Apply"
  574. resp.PopupMsg = "您暂无权限参加 【" + activityInfo.ChartPermissionName + "】行业活动,若想参加可以申请开通哦"
  575. }
  576. if hasPermission == 1 {
  577. //是否展示限免标签
  578. if services.GetShowSustainable() && activityInfo.ChartPermissionName == "研选" {
  579. activityInfo.IsShowSustainable = true
  580. }
  581. configCode := "description_of_research"
  582. detail, err := models.GetConfigByCode(configCode)
  583. if err != nil {
  584. br.Msg = "获取数据失败"
  585. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  586. return
  587. }
  588. activityInfo.Description = detail.ConfigValue
  589. if activityInfo.SignupNum > activityInfo.LimitPeopleNum {
  590. activityInfo.SignupNum = activityInfo.LimitPeopleNum
  591. }
  592. if activityInfo.ChartPermissionNames != "" {
  593. activityInfo.ChartPermissionName = activityInfo.ChartPermissionNames
  594. }
  595. resp.Detail = activityInfo
  596. }
  597. resp.HasPermission = hasPermission
  598. br.Ret = 200
  599. br.Success = true
  600. br.Msg = "获取成功"
  601. br.Data = resp
  602. }
  603. // @Title 活动报名
  604. // @Description 活动报名接口
  605. // @Param request body models.ActivitySingnupRep true "type json string"
  606. // @Success Ret=200 {object} models.SignupStatus
  607. // @router /signup/add [post]
  608. func (this *ActivityCoAntroller) SignupAdd() {
  609. br := new(models.BaseResponse).Init()
  610. defer func() {
  611. this.Data["json"] = br
  612. this.ServeJSON()
  613. }()
  614. user := this.User
  615. if user == nil {
  616. br.Msg = "请登录"
  617. br.ErrMsg = "请登录,用户信息为空"
  618. br.Ret = 408
  619. return
  620. }
  621. uid := user.UserId
  622. signupStatus := ""
  623. var req models.ActivitySingnupRep
  624. resp := new(models.SignupStatus)
  625. var total int
  626. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  627. if err != nil {
  628. br.Msg = "参数解析异常!"
  629. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  630. return
  631. }
  632. activityId := req.ActivityId
  633. signupType := req.SignupType
  634. hasPermission := 0
  635. if signupType == 1 && user.Mobile == "" && user.OutboundMobile == "" {
  636. resp.GoBindEmail = true
  637. }
  638. //判断是否已经申请过
  639. applyCount, err := models.GetApplyRecordCount(uid)
  640. if err != nil && err.Error() != utils.ErrNoRow() {
  641. br.Msg = "获取信息失败"
  642. br.ErrMsg = "判断是否已申请过试用失败,Err:" + err.Error()
  643. return
  644. }
  645. activityInfo, errInfo := models.GetAddActivityInfoById(activityId)
  646. if activityInfo == nil {
  647. br.Msg = "操作失败"
  648. br.ErrMsg = "活动ID错误,不存在activityId:" + strconv.Itoa(activityId)
  649. return
  650. }
  651. if errInfo != nil {
  652. br.Msg = "操作失败"
  653. br.ErrMsg = "操作失败,Err:" + errInfo.Error()
  654. return
  655. }
  656. //SignupStatus "报名状态:人数已满:FullStarffed、单机构超过两人:TwoPeople、爽约次数过多:BreakPromise、超时:Overtime 、成功:Success"`
  657. //HasPermission "1:有该行业权限,正常展示,2:无该行业权限,3:潜在客户,未提交过申请,4:潜在客户,已提交过申请"`
  658. var companyDetailStatus string
  659. if user.CompanyId <= 1 {
  660. companyDetailStatus = ""
  661. } else {
  662. companyPermission, err := models.GetCompanyPermission(user.CompanyId)
  663. if err != nil {
  664. br.Msg = "获取信息失败"
  665. br.ErrMsg = "获取客户详情失败,Err:" + err.Error()
  666. return
  667. }
  668. if companyPermission == "" {
  669. if applyCount > 0 {
  670. hasPermission = 4
  671. } else {
  672. hasPermission = 3
  673. }
  674. resp.HasPermission = hasPermission
  675. resp.OperationMode = "Apply"
  676. resp.PopupMsg = "您暂无权限参加 【" + activityInfo.ChartPermissionName + "】行业活动,若想参加可以申请开通哦"
  677. br.Ret = 200
  678. br.Success = true
  679. br.Msg = "获取成功"
  680. br.Data = resp
  681. return
  682. }
  683. companyDetail, err := models.GetCompanyDetailById(user.CompanyId)
  684. if err != nil {
  685. br.Msg = "获取信息失败!"
  686. br.ErrMsg = "获取客户详情失败,Err:" + err.Error()
  687. return
  688. }
  689. if companyDetail == nil {
  690. br.Msg = "获取信息失败!"
  691. br.ErrMsg = "客户不存在,uid:" + strconv.Itoa(user.UserId) + "CompanyId:" + strconv.Itoa(user.CompanyId)
  692. return
  693. }
  694. companyDetailStatus = companyDetail.Status
  695. }
  696. var userType int
  697. var permissionStr string
  698. userType, permissionStr, err = services.GetUserType(user.CompanyId)
  699. if err != nil {
  700. br.Msg = "获取信息失败!"
  701. br.ErrMsg = "获取失败,Err:" + err.Error()
  702. return
  703. }
  704. if userType == 1 && activityInfo.ChartPermissionName == "研选" {
  705. br.Msg = "您暂无查看该活动权限"
  706. br.ErrMsg = "被分享客户不可见,永续客户无法查看研选行业"
  707. return
  708. }
  709. item := new(models.CygxActivitySignup)
  710. if user.CompanyId > 1 {
  711. companyItem, err := models.GetCompanyDetailById(user.CompanyId)
  712. //冻结客户
  713. if err != nil {
  714. if err.Error() == utils.ErrNoRow() {
  715. resp.HasPermission = 4
  716. resp.OperationMode = "Apply"
  717. resp.PopupMsg = "您暂无权限参加 【" + activityInfo.ChartPermissionName + "】行业活动,若想参加可以申请开通哦"
  718. br.Ret = 200
  719. br.Success = true
  720. br.Msg = "获取成功"
  721. br.Data = resp
  722. return
  723. } else {
  724. br.Msg = "获取信息失败"
  725. br.ErrMsg = "获取客户公司信息失败,Err:" + err.Error()
  726. return
  727. }
  728. }
  729. //1专家电话会、2分析师电话会、3公司调研电话会、4公司线下调研、5专家线下沙龙、6分析师线下沙龙
  730. //OperationMode string `description:"操作方式 Apply:立即申请、Call:拨号 为空则为有权限"`
  731. havePower, err := services.GetHavePower(activityInfo, permissionStr, companyDetailStatus, userType)
  732. if err != nil {
  733. br.Msg = "获取信息失败!"
  734. br.ErrMsg = "获取失败,Err:" + err.Error()
  735. return
  736. }
  737. if havePower {
  738. hasPermission = 1
  739. signupStatus = "Success"
  740. resultTime := utils.StrTimeToTime(activityInfo.ActivityTime) //时间字符串格式转时间格式
  741. if time.Now().After(resultTime.Add(-time.Minute * 60)) {
  742. signupStatus = "Overtime"
  743. resp.SignupType = signupType
  744. resp.SignupStatus = signupStatus
  745. resp.HasPermission = hasPermission
  746. br.Ret = 200
  747. br.Success = true
  748. br.Msg = ""
  749. br.Data = resp
  750. return
  751. }
  752. //人数已满:FullStarffed、单机构超过两人:TwoPeople、爽约次数过多:BreakPromise、超时:Overtime 、成功:Success"`
  753. //如果是下面几种情况则对报名信息做判断限制 (公司调研电话会(限制人数)、公司线下调研、专家/分析师线下沙龙)
  754. if (activityInfo.ActivityTypeId == 3 && activityInfo.IsLimitPeople == 1) || activityInfo.ActivityTypeId > 3 {
  755. //判断优先级:总人数限制→单机构2人限制→爽约3次限制
  756. totalRestrict, err := models.GetUserRestrictCount(user.Mobile)
  757. if err != nil {
  758. br.Msg = "获取信息失败"
  759. br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  760. return
  761. }
  762. if totalRestrict >= 1 {
  763. signupStatus = "BreakPromise"
  764. item.FailType = 3
  765. }
  766. totalSignupCompany, err := models.GetActivitySignupCompanyCount(activityId, user.CompanyId)
  767. if err != nil {
  768. br.Msg = "获取信息失败"
  769. br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  770. return
  771. }
  772. if totalSignupCompany >= 2 {
  773. signupStatus = "TwoPeople"
  774. item.FailType = 2
  775. }
  776. totaSignupPeopleNum, err := models.GetActivitySignupSuccessCount(activityId)
  777. if err != nil {
  778. br.Msg = "获取信息失败"
  779. br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  780. return
  781. }
  782. if totaSignupPeopleNum >= activityInfo.LimitPeopleNum {
  783. signupStatus = "FullStarffed"
  784. item.FailType = 1
  785. }
  786. totalUserRestrictCount, err := models.GetActivitySignupByUserRestrictCount(uid, activityId)
  787. if err != nil {
  788. br.Msg = "获取失败"
  789. br.ErrMsg = "获取失败,Err:" + err.Error()
  790. return
  791. }
  792. //解除报名限制之后二次报名相同活动
  793. if totalUserRestrictCount > 0 && totalRestrict == 0 && resp.GoBindEmail != true {
  794. item.UserId = uid
  795. item.ActivityId = activityId
  796. item.CreateTime = time.Now()
  797. item.Mobile = user.Mobile
  798. item.Email = user.Email
  799. item.CompanyId = user.CompanyId
  800. item.CompanyName = user.CompanyName
  801. item.SignupType = signupType
  802. item.FailType = 0
  803. item.DoFailType = 0
  804. _, errSignup := models.AddActivitySignupByRestrict(item)
  805. if errSignup != nil {
  806. br.Msg = "操作失败"
  807. br.ErrMsg = "操作失败,Err:" + errSignup.Error()
  808. return
  809. }
  810. resp.HaqveJurisdiction = true
  811. resp.SignupType = signupType
  812. resp.SignupStatus = "Success"
  813. resp.HasPermission = hasPermission
  814. resp.ActivityId = activityId
  815. total, err = models.GetUserMeetingReminderCount(user.UserId)
  816. if err != nil {
  817. br.Msg = "获取信息失败"
  818. br.ErrMsg = "获取日程数量信息失败,Err:" + err.Error()
  819. return
  820. }
  821. if total == 0 {
  822. resp.GoFollow = true
  823. }
  824. br.Ret = 200
  825. br.Success = true
  826. br.Msg = "操作成功"
  827. br.Data = resp
  828. return
  829. }
  830. totalMy, err := models.GetActivitySignupByUserCount(uid, activityId)
  831. if err != nil {
  832. br.Msg = "获取失败"
  833. br.ErrMsg = "获取失败,Err:" + err.Error()
  834. return
  835. }
  836. if signupStatus != "Success" && totalMy == 0 && resp.GoBindEmail != true {
  837. item.UserId = uid
  838. item.ActivityId = activityId
  839. item.CreateTime = time.Now()
  840. item.Mobile = user.Mobile
  841. item.Email = user.Email
  842. item.CompanyId = user.CompanyId
  843. item.CompanyName = user.CompanyName
  844. item.SignupType = signupType
  845. item.DoFailType = item.FailType
  846. if user.OutboundMobile != "" {
  847. item.OutboundMobile = user.OutboundMobile
  848. if user.OutboundCountryCode == "" {
  849. item.CountryCode = "86"
  850. } else {
  851. item.CountryCode = user.OutboundCountryCode
  852. }
  853. } else {
  854. item.OutboundMobile = user.Mobile
  855. if user.CountryCode == "" {
  856. item.CountryCode = "86"
  857. } else {
  858. item.CountryCode = user.CountryCode
  859. }
  860. }
  861. //添加报名信息,但是不加入日程
  862. _, errSignup := models.AddActivitySignupNoSchedule(item)
  863. if errSignup != nil {
  864. br.Msg = "操作失败"
  865. br.ErrMsg = "操作失败,Err:" + errSignup.Error()
  866. return
  867. }
  868. }
  869. }
  870. totalMySuccess, err := models.GetActivitySignupCount(uid, activityId)
  871. if err != nil {
  872. br.Msg = "获取失败"
  873. br.ErrMsg = "获取失败,Err:" + err.Error()
  874. return
  875. }
  876. if totalMySuccess > 0 {
  877. br.Msg = "您已报名这个活动"
  878. return
  879. }
  880. if signupStatus == "Success" && resp.GoBindEmail != true {
  881. item.UserId = uid
  882. item.ActivityId = activityId
  883. item.CreateTime = time.Now()
  884. item.Mobile = user.Mobile
  885. item.Email = user.Email
  886. item.CompanyId = user.CompanyId
  887. item.CompanyName = user.CompanyName
  888. item.SignupType = signupType
  889. item.FailType = 0
  890. item.DoFailType = 0
  891. item.OutboundMobile = user.Mobile
  892. if user.OutboundMobile != "" {
  893. item.OutboundMobile = user.OutboundMobile
  894. if user.OutboundCountryCode == "" {
  895. item.CountryCode = "86"
  896. } else {
  897. item.CountryCode = user.OutboundCountryCode
  898. }
  899. } else {
  900. item.OutboundMobile = user.Mobile
  901. if user.CountryCode == "" {
  902. item.CountryCode = "86"
  903. } else {
  904. item.CountryCode = user.CountryCode
  905. }
  906. }
  907. _, errSignup := models.AddActivitySignup(item)
  908. if errSignup != nil {
  909. br.Msg = "操作失败"
  910. br.ErrMsg = "操作失败,Err:" + errSignup.Error()
  911. return
  912. }
  913. resp.HaqveJurisdiction = true
  914. }
  915. } else {
  916. hasPermission = 2
  917. resp.SellerMobile = companyItem.Mobile
  918. resp.SellerName = companyItem.SellerName
  919. resp.MsgType = "Type"
  920. resp.OperationMode = "Call"
  921. if permissionStr == "专家" {
  922. resp.PopupMsg = "您暂无权限参加【" + activityInfo.ActivityTypeName + "】类型活动,若想参加请联系对口销售--" + companyItem.SellerName + ":" + companyItem.Mobile
  923. resp.MsgType = "Type"
  924. } else {
  925. resp.PopupMsg = "您暂无权限参加【" + activityInfo.ChartPermissionName + "】行业活动,若想参加请联系对口销售--" + companyItem.SellerName + ":" + companyItem.Mobile
  926. resp.MsgType = "Industry"
  927. }
  928. }
  929. } else { //潜在客户
  930. if applyCount > 0 {
  931. hasPermission = 4
  932. } else {
  933. hasPermission = 3
  934. }
  935. resp.OperationMode = "Apply"
  936. resp.PopupMsg = "您暂无权限参加 【" + activityInfo.ChartPermissionName + "】行业活动,若想参加可以申请开通哦"
  937. }
  938. if signupType == 1 && user.IsMsgOutboundMobile == 0 {
  939. resp.GoOutboundMobile = true
  940. if user.Mobile != "" || user.OutboundMobile != "" {
  941. go models.ModifyWxUserIsMsgOutboundMobile(user.UserId)
  942. }
  943. }
  944. if user.OutboundMobile == "" {
  945. resp.Mobile = user.Mobile
  946. if user.CountryCode == "" && len(user.Mobile) == 11 {
  947. resp.CountryCode = "86"
  948. } else {
  949. resp.CountryCode = user.CountryCode
  950. }
  951. } else {
  952. resp.Mobile = user.OutboundMobile
  953. resp.CountryCode = user.OutboundCountryCode
  954. }
  955. //如果用户有绑定手机号,但是没有绑定外呼手机号
  956. if signupType == 1 && user.Mobile != "" && user.OutboundMobile == "" {
  957. var countryCode string
  958. if len(user.Mobile) == 8 {
  959. countryCode = "852"
  960. } else if len(user.Mobile) == 9 {
  961. countryCode = "886"
  962. } else if len(user.Mobile) == 10 {
  963. countryCode = "1"
  964. } else if len(user.Mobile) >= 11 {
  965. countryCode = "86"
  966. }
  967. models.BindUserOutboundMobileByMobile(user.Mobile, countryCode, uid)
  968. }
  969. resp.SignupType = signupType
  970. resp.SignupStatus = signupStatus
  971. resp.HasPermission = hasPermission
  972. if signupStatus == "Success" {
  973. resp.ActivityId = activityId
  974. }
  975. total, err = models.GetUserSignupCount(user.UserId)
  976. if err != nil {
  977. br.Msg = "获取信息失败"
  978. br.ErrMsg = "获取日程数量信息失败,Err:" + err.Error()
  979. return
  980. }
  981. if total <= 1 {
  982. resp.GoFollow = true
  983. }
  984. br.Ret = 200
  985. br.Success = true
  986. br.Msg = "操作成功"
  987. br.Data = resp
  988. }
  989. // @Title 活动取消报名
  990. // @Description 活动取消报名接口
  991. // @Param request body models.ActivitySingnupRep true "type json string"
  992. // @Success Ret=200 {object} models.SignupStatus
  993. // @router /signup/cancel [post]
  994. func (this *ActivityCoAntroller) SignupCancel() {
  995. br := new(models.BaseResponse).Init()
  996. defer func() {
  997. this.Data["json"] = br
  998. this.ServeJSON()
  999. }()
  1000. user := this.User
  1001. if user == nil {
  1002. br.Msg = "请登录"
  1003. br.ErrMsg = "请登录,用户信息为空"
  1004. br.Ret = 408
  1005. return
  1006. }
  1007. uid := user.UserId
  1008. var req models.ActivitySingnupRep
  1009. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1010. if err != nil {
  1011. br.Msg = "参数解析异常!"
  1012. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1013. return
  1014. }
  1015. activityId := req.ActivityId
  1016. signupType := req.SignupType
  1017. item := new(models.CygxActivitySignup)
  1018. activityInfo, errInfo := models.GetAddActivityInfoById(activityId)
  1019. if activityInfo == nil {
  1020. br.Msg = "操作失败"
  1021. br.ErrMsg = "活动ID错误,不存在activityId:" + strconv.Itoa(activityId)
  1022. return
  1023. }
  1024. if errInfo != nil {
  1025. br.Msg = "操作失败"
  1026. br.ErrMsg = "操作失败,Err:" + errInfo.Error()
  1027. return
  1028. }
  1029. resultTime := utils.StrTimeToTime(activityInfo.ActivityTime) //时间字符串格式转时间格式
  1030. if time.Now().After(resultTime.Add(-time.Minute * 60)) {
  1031. if signupType == 1 {
  1032. br.Msg = "活动开始前1小时内无法取消预约外呼,请联系对口销售处理"
  1033. } else {
  1034. br.Msg = "活动开始前1小时内无法取消报名,请联系对口销售处理"
  1035. }
  1036. return
  1037. }
  1038. total, err := models.GetActivitySignupCount(uid, activityId)
  1039. if err != nil {
  1040. br.Msg = "获取失败"
  1041. br.ErrMsg = "获取失败,Err:" + err.Error()
  1042. return
  1043. }
  1044. if total == 0 {
  1045. br.Msg = "您暂未报名这个活动"
  1046. return
  1047. }
  1048. item.UserId = uid
  1049. item.ActivityId = activityId
  1050. item.CreateTime = time.Now()
  1051. item.Mobile = user.Mobile
  1052. item.Email = user.Email
  1053. item.CompanyId = user.CompanyId
  1054. item.CompanyName = user.CompanyName
  1055. resp := new(models.SignupStatus)
  1056. resp.ActivityId = activityId
  1057. _, errSignup := models.CancelActivitySignup(item)
  1058. if errSignup != nil {
  1059. br.Msg = "操作失败"
  1060. br.ErrMsg = "操作失败,Err:" + errSignup.Error()
  1061. return
  1062. }
  1063. br.Ret = 200
  1064. br.Success = true
  1065. br.Msg = "操作成功"
  1066. br.Data = resp
  1067. }
  1068. // @Title 用户搜索详情
  1069. // @Description 获取用户搜索详情接口
  1070. // @Param IsShowJurisdiction query int true "是否仅展示有权限的,默认为0,1是,2否 "
  1071. // @Success Ret=200 {object} models.ActivityUserSearchContentList
  1072. // @router /getUserSearchContent [get]
  1073. func (this *ActivityCoAntroller) GetUserSearchContent() {
  1074. br := new(models.BaseResponse).Init()
  1075. defer func() {
  1076. this.Data["json"] = br
  1077. this.ServeJSON()
  1078. }()
  1079. user := this.User
  1080. if user == nil {
  1081. br.Msg = "请登录"
  1082. br.ErrMsg = "请登录,用户信息为空"
  1083. br.Ret = 408
  1084. return
  1085. }
  1086. uid := user.UserId
  1087. detailSeearch := new(models.CygxActivityUserSearchContent)
  1088. detailSeearch.IsShowJurisdiction = 0
  1089. detailSeearch.ChartPermissionids = ""
  1090. detailSeearch.ActiveState = ""
  1091. resp := new(models.ActivityUserSearchContentList)
  1092. detail, _ := models.GetUserSearchContentByUid(uid)
  1093. if detail == nil {
  1094. detail = detailSeearch
  1095. }
  1096. isShowJurisdiction, _ := this.GetInt("IsShowJurisdiction")
  1097. listActivityType, errActivityType := models.GetActivityTypeList()
  1098. if errActivityType != nil {
  1099. br.Msg = "获取失败"
  1100. br.ErrMsg = "获取数据失败,Err:" + errActivityType.Error()
  1101. return
  1102. }
  1103. var listChartPermissionid []*models.ActivityChartPermission
  1104. var errChart error
  1105. if isShowJurisdiction == 1 {
  1106. listChartPermissionidAll, errChartAll := models.GetUserCompanyPermission(user.CompanyId)
  1107. listChartPermissionid = listChartPermissionidAll
  1108. errChart = errChartAll
  1109. } else if isShowJurisdiction == 2 {
  1110. listChartPermissionidAll, errChartAll := models.GetChartPermissionActivity()
  1111. listChartPermissionid = listChartPermissionidAll
  1112. errChart = errChartAll
  1113. } else {
  1114. if detail.IsShowJurisdiction == 1 {
  1115. listChartPermissionidAll, errChartAll := models.GetUserCompanyPermission(user.CompanyId)
  1116. listChartPermissionid = listChartPermissionidAll
  1117. errChart = errChartAll
  1118. } else {
  1119. listChartPermissionidAll, errChartAll := models.GetChartPermissionActivity()
  1120. listChartPermissionid = listChartPermissionidAll
  1121. errChart = errChartAll
  1122. }
  1123. }
  1124. if errChart != nil {
  1125. br.Msg = "获取信息失败"
  1126. br.ErrMsg = "获取品种信息失败,Err:" + errChart.Error()
  1127. return
  1128. }
  1129. if detail.IsShowJurisdiction == 1 {
  1130. resp.IsShowJurisdiction = true
  1131. }
  1132. if isShowJurisdiction == 1 || detail.IsShowJurisdiction == 1 {
  1133. resp.IsShowJurisdiction = true
  1134. for k, _ := range listChartPermissionid {
  1135. listChartPermissionid[k].IsChoose = true
  1136. }
  1137. }
  1138. if isShowJurisdiction == 2 {
  1139. resp.IsShowJurisdiction = false
  1140. }
  1141. activeStateList := []models.ActivityStaus{models.ActivityStaus{Id: 1, StatusName: "未开始", IsChoose: true}, models.ActivityStaus{Id: 2, StatusName: "进行中"}, models.ActivityStaus{Id: 3, StatusName: "已结束"}}
  1142. list2, err := models.GetChartPermissionActivity()
  1143. if err != nil {
  1144. br.Msg = "获取信息失败"
  1145. br.ErrMsg = "获取品种信息失败,Err:" + err.Error()
  1146. return
  1147. }
  1148. if activeStateList[1].IsChoose == activeStateList[2].IsChoose == false {
  1149. activeStateList[0].IsChoose = true
  1150. }
  1151. var userType int
  1152. userType, _, err = services.GetUserType(user.CompanyId)
  1153. if err != nil {
  1154. br.Msg = "获取信息失败!"
  1155. br.ErrMsg = "获取失败,Err:" + err.Error()
  1156. return
  1157. }
  1158. var listChartPermissionidNew2 []*models.ActivityChartPermission
  1159. for _, v := range list2 {
  1160. if userType == 1 {
  1161. if v.PermissionName != "研选" {
  1162. listChartPermissionidNew2 = append(listChartPermissionidNew2, v)
  1163. }
  1164. } else {
  1165. listChartPermissionidNew2 = append(listChartPermissionidNew2, v)
  1166. }
  1167. }
  1168. resp.ListChartPermission2 = listChartPermissionidNew2
  1169. var listChartPermissionidNew []*models.ActivityChartPermission
  1170. for _, v := range listChartPermissionid {
  1171. if userType == 1 {
  1172. if v.PermissionName != "研选" {
  1173. listChartPermissionidNew = append(listChartPermissionidNew, v)
  1174. }
  1175. } else {
  1176. listChartPermissionidNew = append(listChartPermissionidNew, v)
  1177. }
  1178. }
  1179. resp.ListActivityType = listActivityType
  1180. resp.ListChartPermission = listChartPermissionidNew
  1181. resp.ListActivityStaus = activeStateList
  1182. br.Ret = 200
  1183. br.Success = true
  1184. br.Msg = "获取成功"
  1185. br.Data = resp
  1186. }
  1187. // @Title 添加会议提醒
  1188. // @Description 添加会议提醒接口
  1189. // @Param request body models.ActivityIdRep true "type json string"
  1190. // @Success Ret=200 {object} models.SignupStatus
  1191. // @router /meetingReminder/add [post]
  1192. func (this *ActivityCoAntroller) MeetingReminderAdd() {
  1193. br := new(models.BaseResponse).Init()
  1194. defer func() {
  1195. this.Data["json"] = br
  1196. this.ServeJSON()
  1197. }()
  1198. user := this.User
  1199. if user == nil {
  1200. br.Msg = "请登录"
  1201. br.ErrMsg = "请登录,用户信息为空"
  1202. br.Ret = 408
  1203. return
  1204. }
  1205. uid := user.UserId
  1206. //var signupStatus string
  1207. signupStatus := "Success"
  1208. var req models.ActivityIdRep
  1209. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1210. if err != nil {
  1211. br.Msg = "参数解析异常!"
  1212. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1213. return
  1214. }
  1215. activityId := req.ActivityId
  1216. activityInfo, errInfo := models.GetAddActivityInfoById(activityId)
  1217. if activityInfo == nil {
  1218. br.Msg = "操作失败"
  1219. br.ErrMsg = "活动ID错误,不存在activityId:" + strconv.Itoa(activityId)
  1220. return
  1221. }
  1222. if errInfo != nil {
  1223. br.Msg = "操作失败"
  1224. br.ErrMsg = "操作失败,Err:" + errInfo.Error()
  1225. return
  1226. }
  1227. //判断是否已经申请过
  1228. applyCount, err := models.GetApplyRecordCount(uid)
  1229. if err != nil && err.Error() != utils.ErrNoRow() {
  1230. br.Msg = "获取信息失败"
  1231. br.ErrMsg = "判断是否已申请过试用失败,Err:" + err.Error()
  1232. return
  1233. }
  1234. //SignupStatus string `description:"报名状态:人数已满:FullStarffed、单机构超过两人:TwoPeople、爽约次数过多:BreakPromise、超时:Overtime 、成功:Success"`
  1235. item := new(models.CygxActivityMeetingReminder)
  1236. resp := new(models.SignupStatus)
  1237. hasPermission := 0
  1238. var companyDetailStatus string
  1239. if user.CompanyId <= 1 {
  1240. companyDetailStatus = ""
  1241. } else {
  1242. companyPermission, err := models.GetCompanyPermission(user.CompanyId)
  1243. if err != nil {
  1244. br.Msg = "获取信息失败"
  1245. br.ErrMsg = "获取客户详情失败,Err:" + err.Error()
  1246. return
  1247. }
  1248. if companyPermission == "" {
  1249. if applyCount > 0 {
  1250. hasPermission = 4
  1251. } else {
  1252. hasPermission = 3
  1253. }
  1254. resp.HasPermission = hasPermission
  1255. resp.OperationMode = "Apply"
  1256. resp.PopupMsg = "您暂无权限参加 【" + activityInfo.ChartPermissionName + "】行业活动,若想参加可以申请开通哦"
  1257. br.Ret = 200
  1258. br.Success = true
  1259. br.Msg = "获取成功"
  1260. br.Data = resp
  1261. return
  1262. }
  1263. companyDetail, err := models.GetCompanyDetailById(user.CompanyId)
  1264. if err != nil {
  1265. br.Msg = "获取信息失败!"
  1266. br.ErrMsg = "获取客户详情失败,Err:" + err.Error()
  1267. return
  1268. }
  1269. if companyDetail == nil {
  1270. br.Msg = "获取信息失败!"
  1271. br.ErrMsg = "客户不存在,uid:" + strconv.Itoa(user.UserId) + "CompanyId:" + strconv.Itoa(user.CompanyId)
  1272. return
  1273. }
  1274. companyDetailStatus = companyDetail.Status
  1275. }
  1276. var userType int
  1277. var permissionStr string
  1278. userType, permissionStr, err = services.GetUserType(user.CompanyId)
  1279. if err != nil {
  1280. br.Msg = "获取信息失败!"
  1281. br.ErrMsg = "获取失败,Err:" + err.Error()
  1282. return
  1283. }
  1284. if userType == 1 && activityInfo.ChartPermissionName == "研选" {
  1285. br.Msg = "您暂无查看该活动权限"
  1286. br.ErrMsg = "被分享客户不可见,永续客户无法查看研选行业"
  1287. return
  1288. }
  1289. resultTime := utils.StrTimeToTime(activityInfo.ActivityTime) //时间字符串格式转时间格式
  1290. if time.Now().After(resultTime.Add(-time.Minute * 15)) {
  1291. br.Msg = "活动开始前15分钟无法设置会议提醒"
  1292. return
  1293. }
  1294. if user.CompanyId > 1 {
  1295. companyItem, err := models.GetCompanyDetailById(user.CompanyId)
  1296. //冻结客户
  1297. if err != nil {
  1298. if err.Error() == utils.ErrNoRow() {
  1299. resp.HasPermission = 4
  1300. resp.OperationMode = "Apply"
  1301. resp.PopupMsg = "您暂无权限参加 【" + activityInfo.ChartPermissionName + "】行业活动,若想参加可以申请开通哦"
  1302. br.Ret = 200
  1303. br.Success = true
  1304. br.Msg = "获取成功"
  1305. br.Data = resp
  1306. return
  1307. } else {
  1308. br.Msg = "获取信息失败"
  1309. br.ErrMsg = "获取客户公司信息失败,Err:" + err.Error()
  1310. return
  1311. }
  1312. }
  1313. havePower, err := services.GetHavePower(activityInfo, permissionStr, companyDetailStatus, userType)
  1314. if err != nil {
  1315. br.Msg = "获取信息失败!"
  1316. br.ErrMsg = "获取失败,Err:" + err.Error()
  1317. return
  1318. }
  1319. if havePower {
  1320. hasPermission = 1
  1321. signupStatus = "Success"
  1322. totalMeeting, errMeeting := models.GetActivityMeetingReminderCount(uid, activityId)
  1323. if errMeeting != nil {
  1324. br.Msg = "获取失败"
  1325. br.ErrMsg = "获取失败,Err:" + errMeeting.Error()
  1326. return
  1327. }
  1328. if totalMeeting > 0 {
  1329. br.Msg = "您已预约,请勿重复预约"
  1330. return
  1331. }
  1332. item.UserId = uid
  1333. item.ActivityId = activityId
  1334. item.CreateTime = time.Now()
  1335. item.Mobile = user.Mobile
  1336. item.Email = user.Email
  1337. item.CompanyId = user.CompanyId
  1338. item.CompanyName = user.CompanyName
  1339. _, errSignup := models.AddActivityMeetingReminder(item)
  1340. if errSignup != nil {
  1341. br.Msg = "操作失败"
  1342. br.ErrMsg = "操作失败,Err:" + errSignup.Error()
  1343. return
  1344. }
  1345. resp.HaqveJurisdiction = true
  1346. } else {
  1347. hasPermission = 2
  1348. resp.SellerMobile = companyItem.Mobile
  1349. resp.SellerName = companyItem.SellerName
  1350. resp.MsgType = "Type"
  1351. resp.OperationMode = "Call"
  1352. if permissionStr == "专家" {
  1353. resp.PopupMsg = "您暂无权限参加【" + activityInfo.ActivityTypeName + "】类型活动,若想参加请联系对口销售--" + companyItem.SellerName + ":" + companyItem.Mobile
  1354. resp.MsgType = "Type"
  1355. } else {
  1356. resp.PopupMsg = "您暂无权限参加【" + activityInfo.ChartPermissionName + "】行业活动,若想参加请联系对口销售--" + companyItem.SellerName + ":" + companyItem.Mobile
  1357. resp.MsgType = "Industry"
  1358. }
  1359. }
  1360. } else { //潜在客户
  1361. if applyCount > 0 {
  1362. hasPermission = 4
  1363. } else {
  1364. hasPermission = 3
  1365. }
  1366. resp.OperationMode = "Apply"
  1367. resp.PopupMsg = "您暂无权限参加 【" + activityInfo.ChartPermissionName + "】行业活动,若想参加可以申请开通哦"
  1368. }
  1369. resp.HasPermission = hasPermission
  1370. resp.SignupStatus = signupStatus
  1371. resp.ActivityId = activityId
  1372. var total int
  1373. total, err = models.GetUserActivityMeetingReminderCount(user.UserId)
  1374. if err != nil {
  1375. br.Msg = "获取信息失败"
  1376. br.ErrMsg = "获取日程数量信息失败,Err:" + err.Error()
  1377. return
  1378. }
  1379. if total <= 1 {
  1380. resp.GoFollow = true
  1381. }
  1382. br.Ret = 200
  1383. br.Success = true
  1384. if hasPermission == 1 {
  1385. br.Msg = "设置成功,会前15分钟会为您推送微信消息提醒"
  1386. }
  1387. br.Data = resp
  1388. }
  1389. // @Title 取消会议提醒
  1390. // @Description 取消会议提醒接口
  1391. // @Param request body models.ActivityIdRep true "type json string"
  1392. // @Success Ret=200 {object} models.SignupStatus
  1393. // @router /meetingReminder/cancel [post]
  1394. func (this *ActivityCoAntroller) MeetingReminderCancel() {
  1395. br := new(models.BaseResponse).Init()
  1396. defer func() {
  1397. this.Data["json"] = br
  1398. this.ServeJSON()
  1399. }()
  1400. user := this.User
  1401. if user == nil {
  1402. br.Msg = "请登录"
  1403. br.ErrMsg = "请登录,用户信息为空"
  1404. br.Ret = 408
  1405. return
  1406. }
  1407. uid := user.UserId
  1408. var req models.ActivityIdRep
  1409. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1410. if err != nil {
  1411. br.Msg = "参数解析异常!"
  1412. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1413. return
  1414. }
  1415. activityId := req.ActivityId
  1416. signupStatus := "Success"
  1417. item := new(models.CygxActivityMeetingReminder)
  1418. activityInfo, errInfo := models.GetAddActivityInfoById(activityId)
  1419. if activityInfo == nil {
  1420. br.Msg = "操作失败"
  1421. br.ErrMsg = "活动ID错误,不存在activityId:" + strconv.Itoa(activityId)
  1422. return
  1423. }
  1424. if errInfo != nil {
  1425. br.Msg = "操作失败"
  1426. br.ErrMsg = "操作失败,Err:" + errInfo.Error()
  1427. return
  1428. }
  1429. //if signupStatus == "Success" {
  1430. total, err := models.GetActivityMeetingReminderCount(uid, activityId)
  1431. if err != nil {
  1432. br.Msg = "获取失败"
  1433. br.ErrMsg = "获取失败,Err:" + err.Error()
  1434. return
  1435. }
  1436. if total == 0 {
  1437. br.Msg = "您暂未添加该活动会议提醒"
  1438. return
  1439. }
  1440. resultTime := utils.StrTimeToTime(activityInfo.ActivityTime) //时间字符串格式转时间格式
  1441. if time.Now().After(resultTime.Add(-time.Minute * 15)) {
  1442. br.Msg = "活动开始前15分钟无法取消会议提醒"
  1443. return
  1444. }
  1445. item.UserId = uid
  1446. item.ActivityId = activityId
  1447. item.CreateTime = time.Now()
  1448. item.Mobile = user.Mobile
  1449. item.Email = user.Email
  1450. item.CompanyId = user.CompanyId
  1451. item.CompanyName = user.CompanyName
  1452. _, errSignup := models.CancelActivityMeetingReminder(item)
  1453. if errSignup != nil {
  1454. br.Msg = "操作失败"
  1455. br.ErrMsg = "操作失败,Err:" + errSignup.Error()
  1456. return
  1457. }
  1458. //}
  1459. resp := new(models.SignupStatus)
  1460. resp.SignupStatus = signupStatus
  1461. resp.ActivityId = activityId
  1462. br.Ret = 200
  1463. br.Success = true
  1464. br.Msg = "会议提醒已取消"
  1465. br.Data = resp
  1466. }
  1467. // @Title 敏捷搜索关键词的列表
  1468. // @Description 获取敏捷搜索关键词的列表接口
  1469. // @Success 200 {object} models.ActivityFastsearchKeywordsListResp
  1470. // @router /fastSearchKeWord [get]
  1471. func (this *ActivityABaseController) FastSearch() {
  1472. br := new(models.BaseResponse).Init()
  1473. defer func() {
  1474. this.Data["json"] = br
  1475. this.ServeJSON()
  1476. }()
  1477. resp := new(models.ActivityFastsearchKeywordsListResp)
  1478. list, err := models.GetActivityFastsearchKeywordsList()
  1479. if err != nil {
  1480. br.Msg = "获取失败"
  1481. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  1482. return
  1483. }
  1484. resp.List = list
  1485. br.Ret = 200
  1486. br.Success = true
  1487. br.Msg = "获取成功"
  1488. br.Data = resp
  1489. }
  1490. // @Title 主题列表
  1491. // @Description 获取活动主题列表接口
  1492. // @Param ChartPermissionIds query string false "行业id 多个用 , 隔开"
  1493. // @Param ActivityTypeIds query string false "活动类型id 多个用 , 隔开"
  1494. // @Param ActiveState query string false "活动进行状态 未开始:1、进行中2、已结束3"
  1495. // @Param WhichDay query string false "哪一天 今天:1、明天:2,多个用 , 隔开"
  1496. // @Param Label query string false "搜索主题 多个用 , 隔开 (空为活动主题,非空为更多主题)"
  1497. // @Success 200 {object} models.GetCygxActivityLabelListRep
  1498. // @router /labelList [get]
  1499. func (this *ActivityCoAntroller) LabelList() {
  1500. br := new(models.BaseResponse).Init()
  1501. defer func() {
  1502. this.Data["json"] = br
  1503. this.ServeJSON()
  1504. }()
  1505. user := this.User
  1506. if user == nil {
  1507. br.Msg = "请登录"
  1508. br.ErrMsg = "请登录,SysUser Is Empty"
  1509. return
  1510. }
  1511. pageSize, _ := this.GetInt("PageSize")
  1512. //currentIndex, _ := this.GetInt("CurrentIndex")
  1513. chartPermissionIds := this.GetString("ChartPermissionIds")
  1514. activityTypeIds := this.GetString("ActivityTypeIds")
  1515. whichDay := this.GetString("WhichDay")
  1516. isShowJurisdiction, _ := this.GetInt("IsShowJurisdiction")
  1517. activeState := this.GetString("ActiveState")
  1518. label := this.GetString("Label")
  1519. //入参为 undefined 时的处理
  1520. if chartPermissionIds == "undefined" {
  1521. chartPermissionIds = ""
  1522. }
  1523. if activityTypeIds == "undefined" {
  1524. activityTypeIds = ""
  1525. }
  1526. if whichDay == "undefined" {
  1527. whichDay = ""
  1528. }
  1529. if activeState == "undefined" {
  1530. activeState = ""
  1531. }
  1532. if label == "undefined" {
  1533. label = ""
  1534. }
  1535. var userType int
  1536. var permissionStr string
  1537. if user.CompanyId <= 1 {
  1538. userType = 0
  1539. } else {
  1540. total, err := models.GetCountCompanyDetailByIdGroup(user.CompanyId)
  1541. if err != nil {
  1542. br.Msg = "获取失败"
  1543. br.ErrMsg = "获取失败,Err:" + err.Error()
  1544. return
  1545. }
  1546. if total == 0 {
  1547. userType = 0
  1548. } else {
  1549. companyDetail, err := models.GetCompanyDetailByIdGroup(user.CompanyId)
  1550. if err != nil {
  1551. br.Msg = "获取信息失败!"
  1552. br.ErrMsg = "获取客户详情失败,Err:" + err.Error()
  1553. return
  1554. }
  1555. if companyDetail == nil {
  1556. br.Msg = "获取信息失败!"
  1557. br.ErrMsg = "客户不存在,uid:" + strconv.Itoa(user.UserId) + "CompanyId:" + strconv.Itoa(user.CompanyId)
  1558. return
  1559. }
  1560. permissionStr, err = models.GetCompanyPermission(user.CompanyId)
  1561. if err != nil {
  1562. br.Msg = "获取信息失败"
  1563. br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  1564. return
  1565. }
  1566. //1、永续客户
  1567. //2、大套餐客户(4个行业全开通的正式客户)
  1568. //3、分行业套餐客户(开通对应行业的正式客户)
  1569. //4、仅开通专家套餐的正式客户
  1570. //5、开通对应行业套餐或专家套餐的试用客户
  1571. if companyDetail.Status == "永续" {
  1572. userType = 1
  1573. } else if companyDetail.Status == "试用" {
  1574. userType = 5
  1575. } else if companyDetail.Status == "正式" {
  1576. if permissionStr == "专家" {
  1577. userType = 4
  1578. } else if strings.Contains(permissionStr, "医药") && strings.Contains(permissionStr, "消费") && strings.Contains(permissionStr, "科技") && strings.Contains(permissionStr, "智造") {
  1579. userType = 2
  1580. } else {
  1581. userType = 3
  1582. }
  1583. if userType == 3 {
  1584. if !strings.Contains(permissionStr, "医药") && !strings.Contains(permissionStr, "消费") && !strings.Contains(permissionStr, "科技") && !strings.Contains(permissionStr, "智造") {
  1585. userType = 4
  1586. }
  1587. }
  1588. }
  1589. }
  1590. }
  1591. if isShowJurisdiction == 1 && chartPermissionIds == "" && userType == 4 {
  1592. activityTypeIds = "1,3"
  1593. }
  1594. var startSize int
  1595. //if pageSize <= 0 {
  1596. // pageSize = utils.PageSize20
  1597. //}
  1598. //currentIndex = 1
  1599. pageSize = 15
  1600. //startSize = utils.StartIndex(currentIndex, pageSize)
  1601. var condition string
  1602. var sortTime string
  1603. var pars []interface{}
  1604. //活动可见限制
  1605. var sqlExport string
  1606. slicePer := strings.Split(permissionStr, ",")
  1607. var permissionSqlStr string
  1608. //for _, v := range slicePer {
  1609. // permissionSqlStr += "'" + v + "',"
  1610. //}
  1611. for _, v := range slicePer {
  1612. if userType == 1 {
  1613. if v != "研选" {
  1614. permissionSqlStr += "'" + v + "',"
  1615. }
  1616. } else {
  1617. permissionSqlStr += "'" + v + "',"
  1618. }
  1619. }
  1620. permissionSqlStr = strings.TrimRight(permissionSqlStr, ",")
  1621. permissionSqlStr = ` AND art.chart_permission_name IN (` + permissionSqlStr + `)`
  1622. sqlExport = ` AND (art.customer_type_ids LIKE '%` + strconv.Itoa(userType) + `%' `
  1623. if userType == 2 {
  1624. sqlExport += ` OR art.customer_type_ids LIKE '%3%' `
  1625. }
  1626. if (userType == 2 || userType == 3) && strings.Contains(permissionStr, "专家") {
  1627. sqlExport += ` OR art.customer_type_ids LIKE '%4%' `
  1628. }
  1629. sqlExport += `) `
  1630. condition += ` AND art.publish_status = 1 AND art.label != '' `
  1631. //condition += ` AND art.active_state = 1 `
  1632. var conditionOr string
  1633. if (userType == 2 || userType == 3 || userType == 4) && strings.Contains(permissionStr, "专家") {
  1634. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%4%' ` + condition + `) `
  1635. }
  1636. if (userType == 5) && strings.Contains(permissionStr, "专家") {
  1637. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%5%' ` + condition + `) `
  1638. }
  1639. if userType == 1 {
  1640. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + permissionSqlStr + `) `
  1641. } else {
  1642. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
  1643. }
  1644. //conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
  1645. condition += `AND art.is_limit_people = 1 ` + permissionSqlStr + sqlExport + conditionOr
  1646. resp := new(models.GetCygxActivityLabelListRep)
  1647. //conditionLaable := condition
  1648. //主题
  1649. if label != "" {
  1650. sortTime = ` timesort DESC `
  1651. listAll, errList := models.GetActivityLabelListAll(condition, sortTime, pars, startSize, 32)
  1652. if errList != nil {
  1653. br.Msg = "获取失败"
  1654. br.ErrMsg = "获取失败,Err:" + errList.Error()
  1655. return
  1656. }
  1657. sortTime = ` mintimesort ASC `
  1658. condition += ` AND art.active_state = 1 `
  1659. list1, errList := models.GetActivityLabelListAll(condition, sortTime, pars, startSize, 16)
  1660. if errList != nil {
  1661. br.Msg = "获取失败"
  1662. br.ErrMsg = "获取失败,Err:" + errList.Error()
  1663. return
  1664. }
  1665. for _, v := range listAll {
  1666. var isHAve bool
  1667. for _, v2 := range list1 {
  1668. if v2.KeyWord == v.KeyWord {
  1669. isHAve = true
  1670. }
  1671. }
  1672. if !isHAve {
  1673. resp.List = append(resp.List, v)
  1674. }
  1675. }
  1676. br.Ret = 200
  1677. br.Success = true
  1678. br.Msg = "获取成功"
  1679. br.Data = resp
  1680. return
  1681. } else {
  1682. //行业名称
  1683. condition = ` AND art.publish_status = 1 AND art.label != '' `
  1684. if len(chartPermissionIds) > 0 {
  1685. condition += ` AND art.chart_permission_id IN (` + chartPermissionIds + `)`
  1686. }
  1687. if activityTypeIds != "" {
  1688. condition += ` AND art.activity_type_id IN (` + activityTypeIds + `)`
  1689. }
  1690. var conditionOr string
  1691. if whichDay != "" {
  1692. var startDate string
  1693. var endDate string
  1694. if whichDay == "1" {
  1695. startDate = time.Now().Format(utils.FormatDate)
  1696. endDate = startDate
  1697. } else if whichDay == "2" {
  1698. startDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  1699. endDate = startDate
  1700. } else {
  1701. startDate = time.Now().Format(utils.FormatDate)
  1702. endDate = time.Now().AddDate(0, 0, +1).Format(utils.FormatDate)
  1703. }
  1704. condition += ` AND art.activity_time >= ` + "'" + startDate + " 00:00:00'"
  1705. condition += ` AND art.activity_time <= ` + "'" + endDate + " 23:59:59'"
  1706. }
  1707. if activeState != "" {
  1708. condition += ` AND art.active_state IN (` + activeState + `)`
  1709. } else {
  1710. condition += ` AND art.active_state IN (1)`
  1711. }
  1712. if (userType == 2 || userType == 3 || userType == 4) && strings.Contains(permissionStr, "专家") {
  1713. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%4%' ` + condition + `) `
  1714. }
  1715. if (userType == 5) && strings.Contains(permissionStr, "专家") {
  1716. conditionOr += ` OR ( art.is_limit_people = 1 AND art.customer_type_ids LIKE '%5%' ` + condition + `) `
  1717. }
  1718. if userType == 1 {
  1719. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + permissionSqlStr + `) `
  1720. } else {
  1721. conditionOr += ` OR ( art.is_limit_people = 0 ` + condition + `) `
  1722. }
  1723. condition += `AND art.is_limit_people = 1 ` + permissionSqlStr + sqlExport + conditionOr
  1724. }
  1725. sortTime = ` mintimesort ASC `
  1726. list, errList := models.GetActivityLabelListAll(condition, sortTime, pars, startSize, pageSize)
  1727. if errList != nil {
  1728. br.Msg = "获取失败"
  1729. br.ErrMsg = "获取失败,Err:" + errList.Error()
  1730. return
  1731. }
  1732. //resp := new(models.GetCygxActivityLabelListRep)
  1733. resp.List = list
  1734. br.Ret = 200
  1735. br.Success = true
  1736. br.Msg = "获取成功"
  1737. br.Data = resp
  1738. }
  1739. // @Title 上传公司名称excel
  1740. // @Description 上传参会表格数据
  1741. // @Param File query file true "文件"
  1742. // @Success 200 Ret=200 导入成功
  1743. // @router /activityMeet/import [post]
  1744. func (this *ActivityCoAntroller) Import() {
  1745. br := new(models.BaseResponse).Init()
  1746. defer func() {
  1747. this.Data["json"] = br
  1748. this.ServeJSON()
  1749. }()
  1750. sysUser := this.User
  1751. if sysUser == nil {
  1752. br.Msg = "请重新登录"
  1753. return
  1754. }
  1755. file, h, err := this.GetFile("File")
  1756. if err != nil {
  1757. br.Msg = "获取文件失败"
  1758. br.ErrMsg = "获取文件失败,Err:" + err.Error()
  1759. return
  1760. }
  1761. uploadDir := "static/xls"
  1762. err = os.MkdirAll(uploadDir, 766)
  1763. if err != nil {
  1764. br.Msg = "存储目录创建失败"
  1765. br.ErrMsg = "存储目录创建失败,Err:" + err.Error()
  1766. return
  1767. }
  1768. path := uploadDir + "/" + time.Now().Format(utils.FormatDateTimeUnSpace) + h.Filename
  1769. defer file.Close()
  1770. err = this.SaveToFile("File", path)
  1771. if err != nil {
  1772. br.Msg = "文件保存失败"
  1773. br.ErrMsg = "文件保存失败,Err:" + err.Error()
  1774. return
  1775. }
  1776. xlFile, err := xlsx.OpenFile(path)
  1777. if err != nil {
  1778. br.Msg = "文件导入失败"
  1779. br.ErrMsg = "文件导入失败,Err:" + err.Error()
  1780. return
  1781. }
  1782. //允许添加的联系人
  1783. needAddAttendanc := make([]*models.UserWhiteList, 0)
  1784. // 遍历sheet页读取
  1785. for _, sheet := range xlFile.Sheets {
  1786. //遍历行读取
  1787. maxRow := sheet.MaxRow
  1788. for i := 0; i < maxRow; i++ {
  1789. if i >= 1 {
  1790. row := sheet.Row(i)
  1791. cells := row.Cells
  1792. var companyName, permission string
  1793. for k, cell := range cells {
  1794. if k == 0 {
  1795. companyName = cell.String()
  1796. }
  1797. if k == 2 {
  1798. permission = cell.String()
  1799. }
  1800. }
  1801. //这些字段都没有的话,系统认为excel到底了
  1802. if companyName == "" {
  1803. break
  1804. }
  1805. item := new(models.UserWhiteList)
  1806. item.CompanyName = companyName
  1807. item.Permission = permission
  1808. needAddAttendanc = append(needAddAttendanc, item)
  1809. }
  1810. }
  1811. }
  1812. //var mobileStr string
  1813. var permissionStr string
  1814. for k, v := range needAddAttendanc {
  1815. if k > 0 && v.CompanyName != needAddAttendanc[k-1].CompanyName {
  1816. permissionStr, err = models.GetCompanyPermissionByName(v.CompanyName)
  1817. if err != nil {
  1818. br.Msg = "获取信息失败"
  1819. br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  1820. return
  1821. }
  1822. }
  1823. if k == 0 {
  1824. permissionStr, err = models.GetCompanyPermissionByName(v.CompanyName)
  1825. if err != nil {
  1826. br.Msg = "获取信息失败"
  1827. br.ErrMsg = "获取客户信息失败,Err:" + err.Error()
  1828. return
  1829. }
  1830. }
  1831. needAddAttendanc[k].Permission = permissionStr
  1832. fmt.Println(permissionStr)
  1833. }
  1834. defer func() {
  1835. os.Remove(path)
  1836. }()
  1837. //创建excel
  1838. dir, errFile := os.Executable()
  1839. exPath := filepath.Dir(dir)
  1840. downLoadnFilePath := exPath + "/" + time.Now().Format(utils.FormatDateTimeUnSpace) + ".xlsx"
  1841. xlsxFile := xlsx.NewFile()
  1842. if errFile != nil {
  1843. br.Msg = "生成文件失败Err:" + errFile.Error()
  1844. return
  1845. }
  1846. style := xlsx.NewStyle()
  1847. alignment := xlsx.Alignment{
  1848. Horizontal: "center",
  1849. Vertical: "center",
  1850. WrapText: true,
  1851. }
  1852. style.Alignment = alignment
  1853. style.ApplyAlignment = true
  1854. sheet, err := xlsxFile.AddSheet("白名单")
  1855. if err != nil {
  1856. br.Msg = "新增Sheet失败,Err:" + err.Error()
  1857. return
  1858. }
  1859. //标头
  1860. rowTitle := sheet.AddRow()
  1861. cellA := rowTitle.AddCell()
  1862. cellA.Value = ""
  1863. cellB := rowTitle.AddCell()
  1864. cellB.Value = "公司"
  1865. cellC := rowTitle.AddCell()
  1866. cellC.Value = "权限"
  1867. for _, item := range needAddAttendanc {
  1868. row := sheet.AddRow()
  1869. cellA := row.AddCell()
  1870. cellA.Value = item.CompanyName
  1871. cellB := row.AddCell()
  1872. if item.Permission == "" {
  1873. //item.Permission = "专家/医药/智造/消费/研选/科技/策略/路演服务"
  1874. }
  1875. cellB.Value = item.Permission
  1876. }
  1877. errFile = xlsxFile.Save(downLoadnFilePath)
  1878. if errFile != nil {
  1879. br.Msg = "保存文件失败Err:" + errFile.Error()
  1880. return
  1881. }
  1882. br.Msg = "导入成功"
  1883. br.Ret = 200
  1884. br.Success = true
  1885. }
  1886. // @Title 活动带问
  1887. // @Description 新增活动带问接口
  1888. // @Param request body models.AddCygxActivityHelpAsk true "type json string"
  1889. // @Success Ret=200 新增成功
  1890. // @router /askAdd [post]
  1891. func (this *ActivityCoAntroller) AskAdd() {
  1892. br := new(models.BaseResponse).Init()
  1893. defer func() {
  1894. this.Data["json"] = br
  1895. this.ServeJSON()
  1896. }()
  1897. user := this.User
  1898. if user == nil {
  1899. br.Msg = "请登录"
  1900. br.ErrMsg = "请登录,SysUser Is Empty"
  1901. br.Ret = 408
  1902. return
  1903. }
  1904. var req models.CygxActivityHelpAsk
  1905. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1906. if err != nil {
  1907. br.Msg = "参数解析异常!"
  1908. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1909. return
  1910. }
  1911. if req.Content == "" {
  1912. br.Msg = "建议内容不可为空"
  1913. return
  1914. }
  1915. content := req.Content
  1916. itemToken, err := services.WxGetToken()
  1917. if err != nil {
  1918. br.Msg = "GetWxAccessToken Err:" + err.Error()
  1919. return
  1920. }
  1921. if itemToken.AccessToken == "" {
  1922. br.Msg = "accessToken is empty"
  1923. return
  1924. }
  1925. commerr, err := weapp.MSGSecCheck(itemToken.AccessToken, content)
  1926. if err != nil {
  1927. br.Msg = "内容校验失败!"
  1928. br.ErrMsg = "内容校验失败,Err:" + err.Error()
  1929. return
  1930. }
  1931. if commerr.ErrCode != 0 {
  1932. br.Msg = "内容违规,请重新提交!"
  1933. br.ErrMsg = "颜文字内容违规,Err:" + commerr.ErrMSG
  1934. return
  1935. }
  1936. activityId := req.ActivityId
  1937. activityInfo, errInfo := models.GetAddActivityInfoById(activityId)
  1938. if activityInfo == nil {
  1939. br.Msg = "操作失败"
  1940. br.ErrMsg = "活动ID错误,不存在activityId:" + strconv.Itoa(activityId)
  1941. return
  1942. }
  1943. if errInfo != nil {
  1944. br.Msg = "操作失败"
  1945. br.ErrMsg = "操作失败,Err:" + errInfo.Error()
  1946. return
  1947. }
  1948. resultTime := utils.StrTimeToTime(activityInfo.ActivityTime) //时间字符串格式转时间格式
  1949. if activityInfo.ActivityTypeId == 1 && activityInfo.ChartPermissionId != 31 {
  1950. if time.Now().After(resultTime.Add(-time.Minute * 15)) {
  1951. br.Msg = "活动开始前15分钟内无法提交问题"
  1952. return
  1953. }
  1954. } else {
  1955. if time.Now().After(resultTime.Add(-time.Minute * 60)) {
  1956. br.Msg = "活动开始前1小时内无法提交问题"
  1957. return
  1958. }
  1959. }
  1960. companyDetail, err := models.GetCompanyDetailById(user.CompanyId)
  1961. if err != nil {
  1962. br.Msg = "提交失败!"
  1963. br.ErrMsg = "获取客户详情失败,Err:" + err.Error()
  1964. return
  1965. }
  1966. if companyDetail == nil {
  1967. br.Msg = "提交失败!"
  1968. br.ErrMsg = "客户不存在,uid:" + strconv.Itoa(user.UserId)
  1969. return
  1970. }
  1971. item := new(models.CygxActivityHelpAsk)
  1972. item.UserId = user.UserId
  1973. item.ActivityId = req.ActivityId
  1974. item.CompanyId = user.CompanyId
  1975. item.CompanyName = companyDetail.CompanyName
  1976. item.CreateTime = time.Now()
  1977. item.Mobile = user.Mobile
  1978. item.Email = user.Email
  1979. item.Content = content
  1980. _, err = models.AddActivityHelpAsk(item)
  1981. if err != nil {
  1982. br.Msg = "提交失败"
  1983. br.ErrMsg = "提交带问失败,Err:" + err.Error()
  1984. return
  1985. }
  1986. br.Ret = 200
  1987. br.Success = true
  1988. br.Msg = "提交成功"
  1989. }