rai_serve.go 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378
  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. //ThisWeekAmount string `comment:"本周互动量"`
  256. //LastWeekAmount string `comment:"上周互动量"`
  257. //TwoWeekAmount string `comment:"上上周互动量"`
  258. //ThreeWeekAmount string `comment:"上三周互动量"`
  259. resp.ThisWeekAmount = "22%"
  260. resp.LastWeekAmount = "33%"
  261. resp.TwoWeekAmount = "44%"
  262. resp.ThreeWeekAmount = "55%"
  263. //resp.List = []string{"22%", "33%", "44%", "55%"}
  264. br.Ret = 200
  265. br.Success = true
  266. br.Msg = "获取成功"
  267. br.Data = resp
  268. }
  269. // @Title 明细列表
  270. // @Description 明细列表接口
  271. // @Param PageSize query int true "每页数据条数"
  272. // @Param CurrentIndex query int true "当前页页码,从1开始"
  273. // @Param CompanyId query int false "公司ID"
  274. // @Param TagType query int false "标签类型"
  275. // @Param TagId query int false "标签ID"
  276. // @Param ServeTypeId int int false "服务类型ID"
  277. // @Param WhatWeek query int false "哪一周 ,1:本周、2:上周、3:上上周、4上三周"
  278. // @Success 200 {object} cygx.RaiServeTagListResp
  279. // @router /rai_serve/bill_list [get]
  280. func (this *RaiServeCoAntroller) BillList() {
  281. br := new(models.BaseResponse).Init()
  282. defer func() {
  283. this.Data["json"] = br
  284. this.ServeJSON()
  285. }()
  286. sysUser := this.SysUser
  287. if sysUser == nil {
  288. br.Msg = "请登录"
  289. br.ErrMsg = "请登录,SysUser Is Empty"
  290. br.Ret = 408
  291. return
  292. }
  293. pageSize, _ := this.GetInt("PageSize")
  294. currentIndex, _ := this.GetInt("CurrentIndex")
  295. companyId, _ := this.GetInt("CompanyId")
  296. tagType, _ := this.GetInt("TagType")
  297. tagId, _ := this.GetInt("TagId")
  298. serveTypeId, _ := this.GetInt("ServeTypeId")
  299. var startSize int
  300. if pageSize <= 0 {
  301. pageSize = utils.PageSize20
  302. }
  303. if currentIndex <= 0 {
  304. currentIndex = 1
  305. }
  306. startSize = utils.StartIndex(currentIndex, pageSize)
  307. if companyId == 0 {
  308. br.Msg = "请选择对应公司ID"
  309. return
  310. }
  311. companyInfo, err := company.GetCompanyById(companyId)
  312. if err != nil {
  313. br.Msg = "获取失败"
  314. br.ErrMsg = "获取失败,GetCompanyById:" + err.Error()
  315. return
  316. }
  317. var condition string
  318. var pars []interface{}
  319. condition = " AND company_id = ? "
  320. pars = append(pars, companyId)
  321. if serveTypeId > 0 {
  322. condition += " AND serve_type_id = ? "
  323. pars = append(pars, serveTypeId)
  324. }
  325. switch tagType {
  326. case 1:
  327. fmt.Println(tagId)
  328. case 2:
  329. case 3:
  330. }
  331. total, err := cygx.GetCygxRaiServeBillCount(condition, pars)
  332. if err != nil {
  333. br.Msg = "获取失败"
  334. br.ErrMsg = "获取失败,GetCygxRaiServeCompanyCountErr:" + err.Error()
  335. return
  336. }
  337. list, err := cygx.GetCygxRaiServeBillRespList(condition, pars, startSize, pageSize)
  338. if err != nil {
  339. br.Msg = "获取失败"
  340. br.ErrMsg = "获取失败,GetCygxRaiServeCompanyCountErr:" + err.Error()
  341. return
  342. }
  343. page := paging.GetPaging(currentIndex, pageSize, total)
  344. resp := new(cygx.CygxRaiServeBillListResp)
  345. resp.Paging = page
  346. resp.CompanyName = companyInfo.CompanyName
  347. resp.List = list
  348. br.Ret = 200
  349. br.Success = true
  350. br.Msg = "获取成功"
  351. br.Data = resp
  352. }