rai_serve.go 9.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348
  1. package cygx
  2. import (
  3. "fmt"
  4. "github.com/rdlucklib/rdluck_tools/paging"
  5. "hongze/hz_crm_api/controllers"
  6. "hongze/hz_crm_api/models"
  7. "hongze/hz_crm_api/models/company"
  8. "hongze/hz_crm_api/models/cygx"
  9. "hongze/hz_crm_api/utils"
  10. "strings"
  11. )
  12. // 权益服务类型
  13. type RaiServeCoAntroller struct {
  14. controllers.BaseAuthController
  15. }
  16. // @Title 服务类型列表
  17. // @Description 服务类型列表接口
  18. // @Success 200 {object} cygx.RaiServeTypeListResp
  19. // @router /rai_serve/type_list [get]
  20. func (this *RaiServeCoAntroller) TypeList() {
  21. br := new(models.BaseResponse).Init()
  22. defer func() {
  23. this.Data["json"] = br
  24. this.ServeJSON()
  25. }()
  26. sysUser := this.SysUser
  27. if sysUser == nil {
  28. br.Msg = "请登录"
  29. br.ErrMsg = "请登录,SysUser Is Empty"
  30. br.Ret = 408
  31. return
  32. }
  33. resp := new(cygx.RaiServeTypeListResp)
  34. var condition string
  35. list, err := cygx.GetRaiServeTypeRespList(condition)
  36. if err != nil {
  37. br.Msg = "获取失败"
  38. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  39. return
  40. }
  41. resp.List = list
  42. br.Ret = 200
  43. br.Success = true
  44. br.Msg = "获取成功"
  45. br.Data = resp
  46. }
  47. // @Title 标签搜索
  48. // @Description 标签搜索接口
  49. // @Param KeyWord query string false "搜索关键词"
  50. // @Success 200 {object} cygx.RaiServeTagListResp
  51. // @router /rai_serve/search_tag [get]
  52. func (this *RaiServeCoAntroller) SearchTag() {
  53. br := new(models.BaseResponse).Init()
  54. defer func() {
  55. this.Data["json"] = br
  56. this.ServeJSON()
  57. }()
  58. sysUser := this.SysUser
  59. if sysUser == nil {
  60. br.Msg = "请登录"
  61. br.ErrMsg = "请登录,SysUser Is Empty"
  62. br.Ret = 408
  63. return
  64. }
  65. keyWord := this.GetString("KeyWord")
  66. if keyWord == "" {
  67. br.Msg = "请输入搜索关键词"
  68. return
  69. }
  70. resp := new(cygx.RaiServeTagListResp)
  71. list, err := cygx.GetRaiServeSearchTagRespList(keyWord)
  72. if err != nil {
  73. br.Msg = "获取失败"
  74. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  75. return
  76. }
  77. //如果有固收或者策略就去查询行业表
  78. if strings.Contains("固收", keyWord) || strings.Contains("策略", keyWord) {
  79. var condition string
  80. var pars []interface{}
  81. keyWord = "%" + keyWord + "%"
  82. condition = ` AND product_id = 2 AND permission_name IN ('策略','固收') AND permission_name LIKE ? `
  83. pars = append(pars, keyWord)
  84. listChartPermission, err := models.GetChartPermissionListByCondition(condition, pars)
  85. if err != nil {
  86. br.Msg = "获取失败"
  87. br.ErrMsg = "获取数据失败,GetChartPermissionListByCondition Err:" + err.Error()
  88. return
  89. }
  90. for _, v := range listChartPermission {
  91. item := new(cygx.RaiServeTagResp)
  92. item.TagType = 3
  93. item.TagId = v.ChartPermissionId
  94. item.TagName = v.PermissionName
  95. list = append(list, item)
  96. }
  97. }
  98. if len(list) == 0 {
  99. list = make([]*cygx.RaiServeTagResp, 0)
  100. } else {
  101. for _, v := range list {
  102. v.Md5Key = utils.MD5(fmt.Sprintf("K_", v.TagType, "V_", v.TagId))
  103. }
  104. }
  105. resp.List = list
  106. br.Ret = 200
  107. br.Success = true
  108. br.Msg = "获取成功"
  109. br.Data = resp
  110. }
  111. // @Title 权益服务统计列表
  112. // @Description 权益服务统计列表接口
  113. // @Param PageSize query int true "每页数据条数"
  114. // @Param CurrentIndex query int true "当前页页码,从1开始"
  115. // @Param SellerId query string false "销售id"
  116. // @Param ShareSellerId query string false "共享销售ID"
  117. // @Param ServeTypeId int int false "服务类型ID"
  118. // @Param TagType int string false "标签类型"
  119. // @Param TagId int string false "标签ID"
  120. // @Param Status query string false "客户状态,正式、未续约(除了正式之外的所有)"
  121. // @Param SortType query string true "如何排序,是正序还是倒序,枚举值:`asc 正序`,`desc 倒叙`"
  122. // @Param IsExport query bool false "是否导出excel,默认是false"
  123. // @Success 200 {object} cygx.RaiServeTagListResp
  124. // @router /rai_serve/list [get]
  125. func (this *RaiServeCoAntroller) List() {
  126. br := new(models.BaseResponse).Init()
  127. defer func() {
  128. this.Data["json"] = br
  129. this.ServeJSON()
  130. }()
  131. sysUser := this.SysUser
  132. if sysUser == nil {
  133. br.Msg = "请登录"
  134. br.ErrMsg = "请登录,SysUser Is Empty"
  135. br.Ret = 408
  136. return
  137. }
  138. pageSize, _ := this.GetInt("PageSize")
  139. currentIndex, _ := this.GetInt("CurrentIndex")
  140. status := this.GetString("Status")
  141. sellerId := this.GetString("SellerId")
  142. shareSellerId := this.GetString("ShareSellerId")
  143. sortType := this.GetString("SortType")
  144. tagType, _ := this.GetInt("TagType")
  145. tagId, _ := this.GetInt("TagId")
  146. serveTypeId, _ := this.GetInt("ServeTypeId")
  147. isExport, _ := this.GetBool("IsExport")
  148. resp := new(cygx.CygxRaiServeCompanyListResp)
  149. var startSize int
  150. if pageSize <= 0 {
  151. pageSize = utils.PageSize20
  152. }
  153. if currentIndex <= 0 {
  154. currentIndex = 1
  155. }
  156. startSize = utils.StartIndex(currentIndex, pageSize)
  157. var condition string
  158. var sortStr string
  159. var pars []interface{}
  160. if status != "" {
  161. if status == "正式" {
  162. condition = " AND status = '正式' "
  163. } else {
  164. condition = " AND status != '正式' "
  165. }
  166. }
  167. if sellerId != "" {
  168. condition = " AND seller_id IN (?) "
  169. pars = append(pars, sellerId)
  170. }
  171. if shareSellerId != "" {
  172. condition = " AND share_seller_id IN (?) "
  173. pars = append(pars, shareSellerId)
  174. }
  175. if sortType != "" {
  176. if sortType == "asc" {
  177. sortStr = " ORDER BY money ASC "
  178. } else if sortType == "desc" {
  179. sortStr = " ORDER BY money DESC "
  180. }
  181. } else {
  182. sortStr = " ORDER BY end_date DESC "
  183. }
  184. total, err := cygx.GetCygxRaiServeCompanyCount(condition, pars)
  185. if err != nil {
  186. br.Msg = "获取失败"
  187. br.ErrMsg = "获取失败,GetCygxRaiServeCompanyCountErr:" + err.Error()
  188. return
  189. }
  190. listRaiServeCompany, err := cygx.GetCygxRaiServeCompanyList(condition+sortStr, pars, startSize, pageSize)
  191. if err != nil {
  192. br.Msg = "获取失败"
  193. br.ErrMsg = "获取失败,Err:" + err.Error()
  194. return
  195. }
  196. switch tagType {
  197. case 1:
  198. fmt.Println(tagId)
  199. case 2:
  200. case 3:
  201. }
  202. if serveTypeId > 0 {
  203. }
  204. if isExport {
  205. }
  206. for _, v := range listRaiServeCompany {
  207. item := new(cygx.CygxRaiServeCompanyResp)
  208. item.CompanyId = v.CompanyId
  209. item.CompanyName = v.CompanyName
  210. item.Money = v.Money
  211. item.ServeCoverageRate = v.ServeCoverageRate + "%"
  212. item.SellerId = v.SellerId
  213. item.SellerName = v.SellerName
  214. item.StartDate = v.StartDate
  215. item.StartDate = v.StartDate
  216. item.EndDate = v.EndDate
  217. item.ShareSeller = v.ShareSeller
  218. item.ShareSellerId = v.ShareSellerId
  219. item.Status = v.Status
  220. item.PermissionName = v.PermissionName
  221. item.ThisWeekAmount = 99
  222. item.LastWeekAmount = 99
  223. item.TwoWeekAmount = 99
  224. item.ThreeWeekAmount = 99
  225. resp.List = append(resp.List, item)
  226. }
  227. page := paging.GetPaging(currentIndex, pageSize, total)
  228. resp.Paging = page
  229. br.Ret = 200
  230. br.Success = true
  231. br.Msg = "获取成功"
  232. br.Data = resp
  233. }
  234. // @Title 近四周覆盖率
  235. // @Description 近四周覆盖率接口
  236. // @Param CompanyId query int false "公司ID"
  237. // @Success 200 {object} cygx.RaiServeTagListResp
  238. // @router /rai_serve/coverage_rate [get]
  239. func (this *RaiServeCoAntroller) CoverageRate() {
  240. br := new(models.BaseResponse).Init()
  241. defer func() {
  242. this.Data["json"] = br
  243. this.ServeJSON()
  244. }()
  245. sysUser := this.SysUser
  246. if sysUser == nil {
  247. br.Msg = "请登录"
  248. br.ErrMsg = "请登录,SysUser Is Empty"
  249. br.Ret = 408
  250. return
  251. }
  252. companyId := this.GetString("CompanyId")
  253. fmt.Println(companyId)
  254. resp := new(cygx.RaiServeCoverageRateResp)
  255. resp.List = []string{"22%", "33%", "44%", "55%"}
  256. br.Ret = 200
  257. br.Success = true
  258. br.Msg = "获取成功"
  259. br.Data = resp
  260. }
  261. // @Title 明细列表
  262. // @Description 明细列表接口
  263. // @Param CompanyId query int false "公司ID"
  264. // @Param TagType query int false "标签类型"
  265. // @Param TagId query int false "标签ID"
  266. // @Param ServeTypeId int int false "服务类型ID"
  267. // @Param WhatWeek query int false "哪一周 ,1:本周、2:上周、3:上上周、4上三周"
  268. // @Success 200 {object} cygx.RaiServeTagListResp
  269. // @router /rai_serve/bill_list [get]
  270. func (this *RaiServeCoAntroller) BillList() {
  271. br := new(models.BaseResponse).Init()
  272. defer func() {
  273. this.Data["json"] = br
  274. this.ServeJSON()
  275. }()
  276. sysUser := this.SysUser
  277. if sysUser == nil {
  278. br.Msg = "请登录"
  279. br.ErrMsg = "请登录,SysUser Is Empty"
  280. br.Ret = 408
  281. return
  282. }
  283. companyId, _ := this.GetInt("CompanyId")
  284. tagType, _ := this.GetInt("TagType")
  285. tagId, _ := this.GetInt("TagId")
  286. serveTypeId, _ := this.GetInt("ServeTypeId")
  287. if companyId == 0 {
  288. br.Msg = "请选择对应公司ID"
  289. return
  290. }
  291. companyInfo, err := company.GetCompanyById(companyId)
  292. if err != nil {
  293. br.Msg = "获取失败"
  294. br.ErrMsg = "获取失败,GetCompanyById:" + err.Error()
  295. return
  296. }
  297. var condition string
  298. var pars []interface{}
  299. condition = " AND company_id = ? "
  300. pars = append(pars, companyId)
  301. if serveTypeId > 0 {
  302. condition += " AND serve_type_id = ? "
  303. pars = append(pars, serveTypeId)
  304. }
  305. switch tagType {
  306. case 1:
  307. fmt.Println(tagId)
  308. case 2:
  309. case 3:
  310. }
  311. list, err := cygx.GetCygxRaiServeBillRespList(condition, pars)
  312. if err != nil {
  313. br.Msg = "获取失败"
  314. br.ErrMsg = "获取失败,GetCygxRaiServeCompanyCountErr:" + err.Error()
  315. return
  316. }
  317. resp := new(cygx.CygxRaiServeBillListResp)
  318. resp.CompanyName = companyInfo.CompanyName
  319. resp.List = list
  320. br.Ret = 200
  321. br.Success = true
  322. br.Msg = "获取成功"
  323. br.Data = resp
  324. }