kpler_data.go 49 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810
  1. package data_manage
  2. import (
  3. "encoding/json"
  4. "eta/eta_api/controllers"
  5. "eta/eta_api/models"
  6. "eta/eta_api/models/data_manage"
  7. "eta/eta_api/models/system"
  8. "eta/eta_api/services/data"
  9. etaTrialService "eta/eta_api/services/eta_trial"
  10. "eta/eta_api/utils"
  11. "fmt"
  12. "os"
  13. "path/filepath"
  14. "sort"
  15. "strconv"
  16. "strings"
  17. "time"
  18. "github.com/rdlucklib/rdluck_tools/paging"
  19. "github.com/tealeg/xlsx"
  20. )
  21. type BaseFromKplerController struct {
  22. controllers.BaseAuthController
  23. }
  24. // Search
  25. // @Title 新增指标-查询指标信息接口
  26. // @Description 新增指标-查询指标信息接口
  27. // @Param request body data_manage.ThsHfSearchEdbReq true "type json string"
  28. // @Success 200 {object} data_manage.ThsHfSearchEdbResp
  29. // @router /kpler/index/search [post]
  30. func (this *BaseFromKplerController) Search() {
  31. br := new(models.BaseResponse).Init()
  32. defer func() {
  33. if br.ErrMsg == "" {
  34. br.IsSendEmail = false
  35. }
  36. this.Data["json"] = br
  37. this.ServeJSON()
  38. }()
  39. sysUser := this.SysUser
  40. if sysUser == nil {
  41. br.Msg = "请登录"
  42. br.ErrMsg = "请登录,SysUser Is Empty"
  43. br.Ret = 408
  44. return
  45. }
  46. var params data_manage.KplerSearchReq
  47. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &params); e != nil {
  48. br.Msg = "参数解析异常!"
  49. br.ErrMsg = "参数解析失败,Err:" + e.Error()
  50. return
  51. }
  52. params.Granularity = strings.TrimSpace(params.Granularity)
  53. if params.Granularity == "" {
  54. br.Msg = "请选择频度"
  55. return
  56. }
  57. split := strings.TrimSpace(params.Split)
  58. if split == "" {
  59. split = "Total"
  60. }
  61. unit := strings.TrimSpace(params.Unit)
  62. if unit == "" {
  63. unit = "Kbd"
  64. }
  65. flowDirection := strings.TrimSpace(params.FlowDirection)
  66. if flowDirection == "" {
  67. br.Msg = "请选择流向"
  68. return
  69. }
  70. var productNamesStr string
  71. var fromZoneNamesStr string
  72. var toZoneNamesStr string
  73. classifyName := ""
  74. if len(params.ProductIds) > 0 {
  75. // 获取产品名称
  76. productList, e := data_manage.GetKplerClassifyByProductId(params.ProductIds)
  77. if e != nil {
  78. br.Msg = "获取Kpler产品名称失败"
  79. br.ErrMsg = fmt.Sprintf("获取Kpler产品名称失败, %v", e)
  80. return
  81. }
  82. productNames := make([]string, 0)
  83. for _, v := range productList {
  84. productNames = append(productNames, v.ProductName)
  85. }
  86. if len(productNames) > 0 {
  87. productNamesStr = strings.Join(productNames, ",")
  88. // 获取第一个产品的分类ID
  89. classifyObj, err := data_manage.GetBaseFromKplerClassifyByProductName(productNames[0])
  90. if err != nil {
  91. br.Msg = "获取分类ID失败"
  92. br.ErrMsg = fmt.Sprintf("获取分类ID失败, %v", err)
  93. return
  94. }
  95. allClassifyIds := make([]int, 0)
  96. if classifyObj.LevelPath != "" {
  97. levelPath := strings.Split(classifyObj.LevelPath, ",")
  98. for _, v := range levelPath {
  99. levelId, _ := strconv.Atoi(v)
  100. allClassifyIds = append(allClassifyIds, levelId)
  101. }
  102. //获取所有的分类列表
  103. classifyList, err := data_manage.GetBaseFromKplerClassifyByIds(allClassifyIds)
  104. if err != nil {
  105. br.Msg = "获取分类列表失败"
  106. br.ErrMsg = fmt.Sprintf("获取分类列表失败, %v", err)
  107. return
  108. }
  109. for _, v := range classifyList {
  110. classifyName += v.ClassifyName + "/"
  111. }
  112. classifyName = strings.TrimRight(classifyName, "/")
  113. }
  114. }
  115. }
  116. // 获取区域名称
  117. zoneObj := new(data_manage.BaseFromKplerZone)
  118. if len(params.FromZoneIds) > 0 {
  119. fromZoneList, e := zoneObj.GetByZoneIds(params.FromZoneIds)
  120. if e != nil {
  121. br.Msg = "获取Kpler区域名称失败"
  122. br.ErrMsg = fmt.Sprintf("获取Kpler区域名称失败, %v", e)
  123. return
  124. }
  125. fromZoneNames := make([]string, 0)
  126. for _, v := range fromZoneList {
  127. fromZoneNames = append(fromZoneNames, v.ZoneName)
  128. }
  129. if len(fromZoneNames) > 0 {
  130. fromZoneNamesStr = strings.Join(fromZoneNames, ",")
  131. }
  132. }
  133. if len(params.ToZoneIds) > 0 {
  134. toZoneList, e := zoneObj.GetByZoneIds(params.ToZoneIds)
  135. if e != nil {
  136. br.Msg = "获取Kpler区域名称失败"
  137. br.ErrMsg = fmt.Sprintf("获取Kpler区域名称失败, %v", e)
  138. return
  139. }
  140. toZoneNames := make([]string, 0)
  141. for _, v := range toZoneList {
  142. toZoneNames = append(toZoneNames, v.ZoneName)
  143. }
  144. if len(toZoneNames) > 0 {
  145. toZoneNamesStr = strings.Join(toZoneNames, ",")
  146. }
  147. }
  148. // 校验已入库的指标
  149. if params.Split == "Total" {
  150. flowDirection := params.FlowDirection
  151. // prefixIndexName := fmt.Sprintf("kpler%s%s%s%s", fromZoneNamesStr, flowDirection, toZoneNamesStr, productNamesStr)
  152. // lastIndexName := params.Granularity
  153. // indexName := fmt.Sprintf("%s%s%s", prefixIndexName, "Total", lastIndexName)
  154. prefixIndexCode := fmt.Sprintf("k%s%s%s%s", fromZoneNamesStr, flowDirection, toZoneNamesStr, productNamesStr)
  155. // 获取首字母
  156. lastIndexCode := strings.ToUpper(params.Granularity[:1])
  157. indexCode := fmt.Sprintf("%s%s%s", prefixIndexCode, "Total", lastIndexCode)
  158. // 查询指标是否已存在
  159. _, e := data_manage.GetKplerIndexByIndexCode(indexCode)
  160. if e != nil && !utils.IsErrNoRow(e) {
  161. br.Msg = "获取指标信息失败"
  162. br.ErrMsg = fmt.Sprintf("获取指标信息失败, %v", e)
  163. return
  164. }
  165. if e == nil {
  166. br.Msg = "指标均已存在"
  167. return
  168. }
  169. }
  170. resp := make([]*data_manage.KplerIndexItem, 0)
  171. // 请求API获取数据
  172. indexes, e := data.GetEdbDataKpler(params, productNamesStr, fromZoneNamesStr, toZoneNamesStr)
  173. if e != nil {
  174. br.Msg = "未搜索到指标"
  175. br.ErrMsg = fmt.Sprintf("获取指标失败, %v", e)
  176. return
  177. }
  178. if len(indexes) == 0 {
  179. br.Msg = "未搜索到指标"
  180. return
  181. }
  182. for _, v := range indexes {
  183. item := new(data_manage.KplerIndexItem)
  184. item.IndexCode = v.IndexCode
  185. item.IndexName = v.IndexName
  186. item.Frequency = v.Frequency
  187. item.Unit = v.Unit
  188. item.ClassifyName = classifyName
  189. // 搜索只展示100条数据
  190. var limit int
  191. sort.Slice(v.IndexData, func(i, j int) bool {
  192. return v.IndexData[i].DataTime < v.IndexData[j].DataTime
  193. })
  194. for _, d := range v.IndexData {
  195. if limit > 10 {
  196. break
  197. }
  198. limit += 1
  199. item.IndexData = append(item.IndexData, d)
  200. }
  201. resp = append(resp, item)
  202. }
  203. br.Data = resp
  204. br.Ret = 200
  205. br.Success = true
  206. br.Msg = "获取成功"
  207. }
  208. // IndexAdd
  209. // @Title 新增指标-新增指标接口
  210. // @Description 新增指标-新增指标接口
  211. // @Param request body data_manage.ThsHfSearchEdbReq true "type json string"
  212. // @Success 200 {object} data_manage.ThsHfSearchEdbResp
  213. // @router /kpler/index/add [post]
  214. func (this *BaseFromKplerController) IndexAdd() {
  215. br := new(models.BaseResponse).Init()
  216. defer func() {
  217. if br.ErrMsg == "" {
  218. br.IsSendEmail = false
  219. }
  220. this.Data["json"] = br
  221. this.ServeJSON()
  222. }()
  223. sysUser := this.SysUser
  224. if sysUser == nil {
  225. br.Msg = "请登录"
  226. br.ErrMsg = "请登录,SysUser Is Empty"
  227. br.Ret = 408
  228. return
  229. }
  230. var params data_manage.KplerSearchReq
  231. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &params); e != nil {
  232. br.Msg = "参数解析异常!"
  233. br.ErrMsg = "参数解析失败,Err:" + e.Error()
  234. return
  235. }
  236. params.Granularity = strings.TrimSpace(params.Granularity)
  237. if params.Granularity == "" {
  238. br.Msg = "请选择频度"
  239. return
  240. }
  241. split := strings.TrimSpace(params.Split)
  242. if split == "" {
  243. split = "Total"
  244. }
  245. unit := strings.TrimSpace(params.Unit)
  246. if unit == "" {
  247. unit = "Kbd"
  248. }
  249. flowDirection := strings.TrimSpace(params.FlowDirection)
  250. if flowDirection == "" {
  251. br.Msg = "请选择流向"
  252. return
  253. }
  254. var productNamesStr string
  255. var fromZoneNamesStr string
  256. var toZoneNamesStr string
  257. if len(params.ProductIds) > 0 {
  258. // 获取产品名称
  259. productList, e := data_manage.GetKplerClassifyByProductId(params.ProductIds)
  260. if e != nil {
  261. br.Msg = "获取Kpler产品名称失败"
  262. br.ErrMsg = fmt.Sprintf("获取Kpler产品名称失败, %v", e)
  263. return
  264. }
  265. productNames := make([]string, 0)
  266. for _, v := range productList {
  267. productNames = append(productNames, v.ProductName)
  268. }
  269. if len(productNames) > 0 {
  270. productNamesStr = strings.Join(productNames, ",")
  271. }
  272. }
  273. // 获取区域名称
  274. zoneObj := new(data_manage.BaseFromKplerZone)
  275. if len(params.FromZoneIds) > 0 {
  276. fromZoneList, e := zoneObj.GetByZoneIds(params.FromZoneIds)
  277. if e != nil {
  278. br.Msg = "获取Kpler区域名称失败"
  279. br.ErrMsg = fmt.Sprintf("获取Kpler区域名称失败, %v", e)
  280. return
  281. }
  282. fromZoneNames := make([]string, 0)
  283. for _, v := range fromZoneList {
  284. fromZoneNames = append(fromZoneNames, v.ZoneName)
  285. }
  286. if len(fromZoneNames) > 0 {
  287. fromZoneNamesStr = strings.Join(fromZoneNames, ",")
  288. }
  289. }
  290. if len(params.ToZoneIds) > 0 {
  291. toZoneList, e := zoneObj.GetByZoneIds(params.ToZoneIds)
  292. if e != nil {
  293. br.Msg = "获取Kpler区域名称失败"
  294. br.ErrMsg = fmt.Sprintf("获取Kpler区域名称失败, %v", e)
  295. return
  296. }
  297. toZoneNames := make([]string, 0)
  298. for _, v := range toZoneList {
  299. toZoneNames = append(toZoneNames, v.ZoneName)
  300. }
  301. if len(toZoneNames) > 0 {
  302. toZoneNamesStr = strings.Join(toZoneNames, ",")
  303. }
  304. }
  305. // 校验已入库的指标
  306. if params.Split == "Total" {
  307. flowDirection := params.FlowDirection
  308. // prefixIndexName := fmt.Sprintf("kpler%s%s%s%s", fromZoneNamesStr, flowDirection, toZoneNamesStr, productNamesStr)
  309. // lastIndexName := params.Granularity
  310. // indexName := fmt.Sprintf("%s%s%s", prefixIndexName, "Total", lastIndexName)
  311. prefixIndexCode := fmt.Sprintf("k%s%s%s%s", fromZoneNamesStr, flowDirection, toZoneNamesStr, productNamesStr)
  312. // 获取首字母
  313. lastIndexCode := strings.ToUpper(params.Granularity[:1])
  314. indexCode := fmt.Sprintf("%s%s%s", prefixIndexCode, "T", lastIndexCode)
  315. // 查询指标是否已存在
  316. _, e := data_manage.GetKplerIndexByIndexCode(indexCode)
  317. if e != nil && !utils.IsErrNoRow(e) {
  318. br.Msg = "获取指标信息失败"
  319. br.ErrMsg = fmt.Sprintf("获取指标信息失败, %v", e)
  320. return
  321. }
  322. if e == nil {
  323. br.Msg = "指标均已存在"
  324. return
  325. }
  326. }
  327. resp := make([]*data_manage.KplerIndexItem, 0)
  328. // 请求API获取数据
  329. e := data.AddKplerIndex(params, productNamesStr, fromZoneNamesStr, toZoneNamesStr)
  330. if e != nil {
  331. br.Msg = "新增指标失败"
  332. br.ErrMsg = fmt.Sprintf("新增指标失败, %v", e)
  333. return
  334. }
  335. br.Data = resp
  336. br.Ret = 200
  337. br.Success = true
  338. br.Msg = "获取成功"
  339. }
  340. // KplerClassify
  341. // @Title Kpler数据分类
  342. // @Description Kpler数据分类接口
  343. // @Success 200 {object} data_manage.BaseFromKplerClassify
  344. // @router /kpler/classify [get]
  345. func (this *BaseFromKplerController) KplerClassify() {
  346. br := new(models.BaseResponse).Init()
  347. defer func() {
  348. this.Data["json"] = br
  349. this.ServeJSON()
  350. }()
  351. sysUser := this.SysUser
  352. if sysUser == nil {
  353. br.Msg = "请登录"
  354. br.ErrMsg = "请登录,SysUser Is Empty"
  355. br.Ret = 408
  356. return
  357. }
  358. classifyId, _ := this.GetInt("ClassifyId")
  359. if classifyId < 0 {
  360. br.Msg = "请选择分类"
  361. br.ErrMsg = "请选择分类"
  362. return
  363. }
  364. list, e := data_manage.GetKplerClassifyAndIndex(classifyId)
  365. if e != nil {
  366. br.Msg = "获取失败"
  367. br.ErrMsg = "获取数据失败,Err:" + e.Error()
  368. return
  369. }
  370. //组装二级分类
  371. var ret data_manage.BaseFromKplerClassifyResp
  372. ret.List = list
  373. br.Ret = 200
  374. br.Success = true
  375. br.Msg = "获取成功"
  376. br.Data = ret
  377. }
  378. // KplerClassifyTree
  379. // @Title Kpler数据分类树
  380. // @Description Kpler数据分类树接口
  381. // @Success 200 {object} data_manage.BaseFromKplerClassify
  382. // @router /kpler/classify/tree [get]
  383. func (this *BaseFromKplerController) KplerClassifyTree() {
  384. br := new(models.BaseResponse).Init()
  385. defer func() {
  386. this.Data["json"] = br
  387. this.ServeJSON()
  388. }()
  389. sysUser := this.SysUser
  390. if sysUser == nil {
  391. br.Msg = "请登录"
  392. br.ErrMsg = "请登录,SysUser Is Empty"
  393. br.Ret = 408
  394. return
  395. }
  396. classifyAll := make([]*data_manage.BaseFromKplerClassifyItems, 0)
  397. var err error
  398. keyword := this.GetString("Keyword")
  399. if keyword != "" {
  400. keyList, er := data_manage.GetBaseFromKplerClassifyByKeyword(keyword)
  401. if er != nil && !utils.IsErrNoRow(er) {
  402. br.Msg = "获取失败"
  403. br.ErrMsg = "获取数据失败,Err:" + er.Error()
  404. return
  405. }
  406. classifyIds := make([]int, 0)
  407. classifyMap := make(map[int]int)
  408. for _, v := range keyList {
  409. tmpIds := strings.Split(v.LevelPath, ",")
  410. for _, id := range tmpIds {
  411. tmpId, err := strconv.Atoi(id)
  412. if err == nil {
  413. if _, ok := classifyMap[tmpId]; !ok {
  414. classifyIds = append(classifyIds, tmpId)
  415. classifyMap[tmpId] = v.ClassifyId
  416. }
  417. }
  418. }
  419. }
  420. classifyAll, err = data_manage.GetBaseFromKplerClassifyItemsByIds(classifyIds)
  421. if err != nil && !utils.IsErrNoRow(err) {
  422. br.Msg = "获取失败"
  423. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  424. return
  425. }
  426. }else{
  427. classifyAll, err = data_manage.GetAllBaseFromKplerClassify()
  428. if err != nil && !utils.IsErrNoRow(err) {
  429. br.Msg = "获取失败"
  430. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  431. return
  432. }
  433. }
  434. list := data.GetKplerClassifyTreeRecursive(classifyAll, 0)
  435. // 递归组装分类
  436. var ret data_manage.BaseFromKplerClassifyResp
  437. ret.List = list
  438. br.Ret = 200
  439. br.Success = true
  440. br.Msg = "获取成功"
  441. br.Data = ret
  442. }
  443. // 查询区域
  444. // @Title 查询区域
  445. // @Description 查询区域接口
  446. // @Success 200 {object} data_manage.BaseFromKplerZone
  447. // @router /kpler/zone [get]
  448. func (this *BaseFromKplerController) KplerZone() {
  449. br := new(models.BaseResponse).Init()
  450. defer func() {
  451. this.Data["json"] = br
  452. this.ServeJSON()
  453. }()
  454. sysUser := this.SysUser
  455. if sysUser == nil {
  456. br.Msg = "请登录"
  457. br.ErrMsg = "请登录,SysUser Is Empty"
  458. br.Ret = 408
  459. return
  460. }
  461. keyword := this.GetString("Keyword")
  462. var zoneList []*data_manage.BaseFromKplerZone
  463. var err error
  464. if keyword == "" {
  465. br.Data = zoneList
  466. br.Ret = 200
  467. br.Success = true
  468. br.Msg = "获取成功"
  469. return
  470. }
  471. // 使用带相似度排序的搜索函数
  472. zoneList, err = data_manage.GetBaseFromKplerZoneByKeywordWithRelevance(keyword)
  473. if err != nil && !utils.IsErrNoRow(err) {
  474. br.Msg = "获取失败"
  475. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  476. return
  477. }
  478. br.Data = zoneList
  479. br.Ret = 200
  480. br.Success = true
  481. br.Msg = "获取成功"
  482. }
  483. // KplerIndexData
  484. // @Title 获取Kpler数据
  485. // @Description 获取Kpler数据接口
  486. // @Param PageSize query int true "每页数据条数"
  487. // @Param CurrentIndex query int true "当前页页码,从1开始"
  488. // @Param ClassifyId query string true "分类id"
  489. // @Success 200 {object} data_manage.LzFrequency
  490. // @router /kpler/index/data [get]
  491. func (this *BaseFromKplerController) KplerIndexData() {
  492. br := new(models.BaseResponse).Init()
  493. defer func() {
  494. this.Data["json"] = br
  495. this.ServeJSON()
  496. }()
  497. sysUser := this.SysUser
  498. if sysUser == nil {
  499. br.Msg = "请登录"
  500. br.ErrMsg = "请登录,SysUser Is Empty"
  501. br.Ret = 408
  502. return
  503. }
  504. pageSize, _ := this.GetInt("PageSize")
  505. currentIndex, _ := this.GetInt("CurrentIndex")
  506. var startSize int
  507. if pageSize <= 0 {
  508. pageSize = utils.PageSize20
  509. }
  510. if currentIndex <= 0 {
  511. currentIndex = 1
  512. }
  513. startSize = utils.StartIndex(currentIndex, pageSize)
  514. classifyId, _ := this.GetInt("ClassifyId")
  515. if classifyId < 0 {
  516. br.Msg = "请选择分类"
  517. br.ErrMsg = "请选择分类"
  518. return
  519. }
  520. // 增加频度请求入参
  521. frequency := this.GetString("Frequency")
  522. //获取指标
  523. var condition string
  524. var pars []interface{}
  525. if classifyId >= 0 {
  526. classifyInfo, err := data_manage.GetBaseFromKplerClassifyById(classifyId)
  527. if err != nil {
  528. if utils.IsErrNoRow(err) {
  529. br.Msg = "分类不存在"
  530. return
  531. }
  532. br.Msg = "获取分类信息失败"
  533. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  534. return
  535. }
  536. if classifyInfo.LevelPath != "" {
  537. childClassify, err := data_manage.GetBaseFromKplerClassifyByLevelPath(classifyInfo.LevelPath)
  538. if err != nil {
  539. br.Msg = "获取分类信息失败"
  540. br.ErrMsg = "获取子分类信息失败,Err:" + err.Error()
  541. return
  542. }
  543. var classifyList []int
  544. classifyList = append(classifyList, classifyId)
  545. for _, v := range childClassify {
  546. classifyList = append(classifyList, v.ClassifyId)
  547. }
  548. condition += ` AND classify_id IN (` + utils.GetOrmInReplace(len(classifyList)) + `) `
  549. pars = append(pars, classifyList)
  550. }
  551. }
  552. if frequency != "" {
  553. condition += ` AND frequency=? `
  554. pars = append(pars, frequency)
  555. }
  556. KplerList, err := data_manage.GetKplerIndex(condition, pars)
  557. if err != nil {
  558. br.Msg = "获取数据失败"
  559. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  560. return
  561. }
  562. edbCodeList := make([]string, 0)
  563. for _, v := range KplerList {
  564. edbCodeList = append(edbCodeList, v.IndexCode)
  565. }
  566. edbInfoMap := make(map[string]*data_manage.EdbInfo)
  567. dataMap := make(map[string][]*data_manage.BaseFromKplerData)
  568. total := 0
  569. if len(edbCodeList) > 0 {
  570. edbInfoList, err := data_manage.GetEdbInfoByEdbCodeList(utils.DATA_SOURCE_KPLER, edbCodeList)
  571. if err != nil {
  572. br.Msg = "获取数据源失败"
  573. br.ErrMsg = "获取指标数据失败,Err:" + err.Error()
  574. return
  575. }
  576. for _, v := range edbInfoList {
  577. edbInfoMap[v.EdbCode] = v
  578. }
  579. // 首先对分类下的指标按照日期进行分页,再针对日期,进行排序
  580. dataTimes, err := data_manage.GetKplerIndexDataTimePageByCodes(edbCodeList, startSize, pageSize)
  581. if err != nil {
  582. br.Msg = "获取数据失败"
  583. br.ErrMsg = "获取指标数据日期信息失败,Err:" + err.Error()
  584. return
  585. }
  586. if len(dataTimes) > 0 {
  587. startDate := dataTimes[len(dataTimes)-1]
  588. endDate := dataTimes[0]
  589. // 把截止日往后加1天
  590. endDateT, _ := time.ParseInLocation(utils.FormatDate, endDate, time.Local)
  591. endDate = endDateT.AddDate(0, 0, 1).Format(utils.FormatDate)
  592. dataList, e := data_manage.GetKplerIndexDataByDataTime(edbCodeList, startDate, endDate)
  593. if e != nil {
  594. br.Msg = "获取数据失败"
  595. br.ErrMsg = "获取指标数据失败,Err:" + e.Error()
  596. return
  597. }
  598. //将数据按照指标进行分类
  599. for _, v := range dataList {
  600. dataMap[v.IndexCode] = append(dataMap[v.IndexCode], v)
  601. }
  602. }
  603. total, err = data_manage.GetKplerIndexDataTimePageCount(edbCodeList)
  604. if err != nil {
  605. br.Msg = "获取数据失败"
  606. br.ErrMsg = "获取指标数据失败,Err:" + err.Error()
  607. return
  608. }
  609. }
  610. page := paging.GetPaging(currentIndex, pageSize, total)
  611. resultList := make([]*data_manage.BaseFromKplerIndexList, 0)
  612. for _, v := range KplerList {
  613. product := new(data_manage.BaseFromKplerIndexList)
  614. product.BaseFromKplerIndexId = v.BaseFromKplerIndexId
  615. product.Unit = v.Unit
  616. product.IndexCode = v.IndexCode
  617. product.IndexName = v.IndexName
  618. product.Frequency = v.Frequency
  619. product.ClassifyId = v.ClassifyId
  620. product.ModifyTime = v.ModifyTime
  621. if edb, ok := edbInfoMap[v.IndexCode]; ok {
  622. product.EdbInfoId = edb.EdbInfoId
  623. product.EdbExist = 1
  624. }
  625. dataListTmp, ok := dataMap[v.IndexCode]
  626. if !ok {
  627. dataListTmp = make([]*data_manage.BaseFromKplerData, 0)
  628. }
  629. product.DataList = dataListTmp
  630. product.Paging = page
  631. resultList = append(resultList, product)
  632. }
  633. br.Ret = 200
  634. br.Success = true
  635. br.Msg = "获取成功"
  636. br.Data = resultList
  637. }
  638. // KplerSearchList
  639. // @Title Kpler模糊搜索
  640. // @Description Kpler模糊搜索
  641. // @Param Keyword query string ture "关键字搜索"
  642. // @Success 200 {object} models.BaseResponse
  643. // @router /kpler/search_list [get]
  644. func (this *BaseFromKplerController) KplerSearchList() {
  645. br := new(models.BaseResponse).Init()
  646. defer func() {
  647. this.Data["json"] = br
  648. this.ServeJSON()
  649. }()
  650. sysUser := this.SysUser
  651. if sysUser == nil {
  652. br.Msg = "请重新登录"
  653. return
  654. }
  655. list := make([]*data_manage.BaseFromKplerIndexSearchItem, 0)
  656. var err error
  657. //关键字
  658. keyword := this.GetString("Keyword")
  659. if keyword != "" {
  660. keyWordArr := strings.Split(keyword, " ")
  661. if len(keyWordArr) > 0 {
  662. condition := ""
  663. for _, v := range keyWordArr {
  664. condition += ` AND CONCAT(index_name,index_code) LIKE '%` + v + `%'`
  665. }
  666. list, err = data_manage.GetKplerItemList(condition)
  667. if err != nil {
  668. br.ErrMsg = "获取失败,Err:" + err.Error()
  669. br.Msg = "获取失败"
  670. return
  671. }
  672. }
  673. } else {
  674. // todo es 模糊搜索
  675. list, err = data_manage.GetKplerItemList("")
  676. if err != nil {
  677. br.ErrMsg = "获取失败,Err:" + err.Error()
  678. br.Msg = "获取失败"
  679. return
  680. }
  681. }
  682. classifyIds := make([]int, 0)
  683. for _, v := range list {
  684. classifyIds = append(classifyIds, v.ClassifyId)
  685. }
  686. classifyList, err := data_manage.GetBaseFromKplerClassifyByIds(classifyIds)
  687. if err != nil {
  688. br.Msg = "搜索失败"
  689. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  690. return
  691. }
  692. classifyMap := make(map[int]int)
  693. for _, v := range classifyList {
  694. classifyMap[v.ClassifyId] = v.ParentId
  695. }
  696. for _, v := range list {
  697. v.ParentClassifyId = classifyMap[v.ClassifyId]
  698. }
  699. br.Ret = 200
  700. br.Success = true
  701. br.Msg = "获取成功"
  702. br.Data = list
  703. }
  704. // KplerSingleData
  705. // @Title 获取Kpler数据
  706. // @Description 获取Kpler单条数据接口
  707. // @Param IndexCode query string true "指标唯一编码"
  708. // @Success 200 {object} models.BaseResponse
  709. // @router /kpler/single_data [get]
  710. func (this *BaseFromKplerController) KplerSingleData() {
  711. br := new(models.BaseResponse).Init()
  712. defer func() {
  713. this.Data["json"] = br
  714. this.ServeJSON()
  715. }()
  716. sysUser := this.SysUser
  717. if sysUser == nil {
  718. br.Msg = "请登录"
  719. br.ErrMsg = "请登录,SysUser Is Empty"
  720. br.Ret = 408
  721. return
  722. }
  723. // 增加分页入参
  724. pageSize, _ := this.GetInt("PageSize")
  725. currentIndex, _ := this.GetInt("CurrentIndex")
  726. var startSize int
  727. if pageSize <= 0 {
  728. pageSize = utils.PageSize20
  729. }
  730. if currentIndex <= 0 {
  731. currentIndex = 1
  732. }
  733. startSize = utils.StartIndex(currentIndex, pageSize)
  734. indexCode := this.GetString("IndexCode")
  735. indexInfo, err := data_manage.GetBaseFromKplerIndexByIndexCode(indexCode)
  736. if err != nil {
  737. br.Msg = "获取指标信息失败"
  738. br.ErrMsg = "获取指标信息失败,Err:" + err.Error()
  739. return
  740. }
  741. total, err := data_manage.GetKplerIndexDataByCodeCount(indexCode)
  742. if err != nil {
  743. br.Msg = "获取数据失败"
  744. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  745. return
  746. }
  747. dataTmpList, err := data_manage.GetKplerIndexDataByCodeWithPage(indexCode, startSize, pageSize)
  748. if err != nil {
  749. br.Msg = "获取数据失败"
  750. br.ErrMsg = "获取数据失败,Err:" + err.Error()
  751. return
  752. }
  753. edbInfo, err := data_manage.GetEdbInfoByEdbCode(utils.DATA_SOURCE_KPLER, indexCode)
  754. if err != nil && !utils.IsErrNoRow(err) {
  755. br.Msg = "获取数据源失败"
  756. br.ErrMsg = "获取数据源失败,Err:" + err.Error()
  757. return
  758. }
  759. var ret data_manage.KplerSingleDataResp
  760. var dataList []*data_manage.KplerSingleData
  761. if edbInfo != nil {
  762. ret.EdbInfoId = edbInfo.EdbInfoId
  763. ret.EdbExist = 1
  764. }
  765. ret.ClassifyId = indexInfo.ClassifyId
  766. ret.BaseFromKplerIndexId = indexInfo.BaseFromKplerIndexId
  767. ret.IndexCode = indexInfo.IndexCode
  768. ret.IndexName = indexInfo.IndexName
  769. ret.Frequency = indexInfo.Frequency
  770. ret.CreateTime = indexInfo.CreateTime.Format(utils.FormatDateTime)
  771. ret.ModifyTime = indexInfo.ModifyTime.Format(utils.FormatDateTime)
  772. ret.Unit = indexInfo.Unit
  773. for _, v := range dataTmpList {
  774. tmp := &data_manage.KplerSingleData{
  775. Value: fmt.Sprintf("%v", v.Value),
  776. DataTime: v.DataTime,
  777. }
  778. dataList = append(dataList, tmp)
  779. }
  780. ret.DataList = dataList
  781. page := paging.GetPaging(currentIndex, pageSize, total)
  782. ret.Paging = page
  783. br.Ret = 200
  784. br.Success = true
  785. br.Msg = "获取成功"
  786. br.Data = ret
  787. }
  788. // KplerIndexList
  789. // @Title Kpler指标列表
  790. // @Description Kpler指标列表
  791. // @Param ClassifyId query int true "分类id"
  792. // @Success 200 {object} data_manage.BaseFromKplerClassifyResp
  793. // @router /kpler/classify/index/list [get]
  794. func (this *BaseFromKplerController) KplerIndexList() {
  795. br := new(models.BaseResponse).Init()
  796. defer func() {
  797. this.Data["json"] = br
  798. this.ServeJSON()
  799. }()
  800. classifyId, _ := this.GetInt("ClassifyId", 0)
  801. indexList, err := data_manage.GetKplerIndexByClassifyId(classifyId)
  802. if err != nil && !utils.IsErrNoRow(err) {
  803. br.Msg = "获取失败"
  804. br.ErrMsg = "获取指标信息失败,Err:" + err.Error()
  805. return
  806. }
  807. var ret data_manage.BaseFromKplerClassifyResp
  808. list := make([]*data_manage.BaseFromKplerClassifyItems, 0)
  809. for _, v := range indexList {
  810. classify := new(data_manage.BaseFromKplerClassifyItems)
  811. classify.ClassifyId = classifyId
  812. classify.BaseFromKplerIndexId = v.BaseFromKplerIndexId
  813. classify.IndexCode = v.IndexCode
  814. classify.ClassifyName = v.IndexName
  815. classify.UniqueCode = fmt.Sprintf("%d_%d", classifyId, v.BaseFromKplerIndexId)
  816. list = append(list, classify)
  817. }
  818. ret.List = list
  819. br.Ret = 200
  820. br.Success = true
  821. br.Msg = "获取成功"
  822. br.Data = ret
  823. }
  824. // KplerBatchSearch
  825. // @Title Kpler指标查询
  826. // @Description Kpler指标查询
  827. // @Param ClassifyIds query string true "分类id, 多个分类用英文"
  828. // @Param Keyword query string true "关键词, 指标ID/指标名称"
  829. // @Success 200 {object} data_manage.LzFrequency
  830. // @router /kpler/batch_search [get]
  831. func (this *BaseFromKplerController) KplerBatchSearch() {
  832. br := new(models.BaseResponse).Init()
  833. defer func() {
  834. this.Data["json"] = br
  835. this.ServeJSON()
  836. }()
  837. sysUser := this.SysUser
  838. if sysUser == nil {
  839. br.Msg = "请登录"
  840. br.ErrMsg = "请登录,SysUser Is Empty"
  841. br.Ret = 408
  842. return
  843. }
  844. classifyIdStr := this.GetString("ClassifyIds")
  845. pageSize, _ := this.GetInt("PageSize")
  846. currentIndex, _ := this.GetInt("CurrentIndex")
  847. var startSize int
  848. if pageSize <= 0 {
  849. pageSize = utils.PageSize20
  850. }
  851. if currentIndex <= 0 {
  852. currentIndex = 1
  853. }
  854. startSize = utils.StartIndex(currentIndex, pageSize)
  855. resp := data_manage.BaseFromKplerIndexSearchList{}
  856. total := 0
  857. page := paging.GetPaging(currentIndex, pageSize, total)
  858. var list = make([]*data_manage.BaseFromKplerIndexList, 0)
  859. var condition string
  860. var pars []interface{}
  861. classifyIds := strings.Split(classifyIdStr, ",")
  862. if len(classifyIds) > 0 && classifyIds[0] != `` {
  863. condition += " AND classify_id IN (" + utils.GetOrmInReplace(len(classifyIds)) + " ) "
  864. pars = append(pars, classifyIds)
  865. }
  866. keyword := this.GetString("Keyword")
  867. if keyword != `` {
  868. condition += " AND (index_name like ? OR index_code like ?) "
  869. pars = utils.GetLikeKeywordPars(pars, keyword, 2)
  870. }
  871. frequencies := this.GetString("Frequencies")
  872. if frequencies != "" {
  873. frequencyList := strings.Split(frequencies, ",")
  874. condition += " AND frequency IN (" + utils.GetOrmInReplace(len(frequencyList)) + " ) "
  875. pars = append(pars, frequencyList)
  876. }
  877. condition += ` AND index_code not in (SELECT edb_code FROM edb_info WHERE source=?) `
  878. pars = append(pars, "Kpler")
  879. list, err := data_manage.GetKplerIndexPage(condition, pars, startSize, pageSize)
  880. if err != nil {
  881. br.Msg = "获取失败"
  882. br.ErrMsg = "获取失败,Err:" + err.Error()
  883. return
  884. }
  885. total, err = data_manage.GetKplerIndexPageCount(condition, pars)
  886. if err != nil {
  887. br.Msg = "获取数据失败"
  888. br.ErrMsg = "获取指标数据失败,Err:" + err.Error()
  889. return
  890. }
  891. page = paging.GetPaging(currentIndex, pageSize, total)
  892. resp.Paging = page
  893. resp.List = list
  894. br.Ret = 200
  895. br.Success = true
  896. br.Msg = "获取成功"
  897. br.Data = resp
  898. }
  899. // KplerBatchAdd
  900. // @Title Kpler批量新增
  901. // @Description Kpler批量新增
  902. // @Param request body data_manage.AddEdbInfoReq true "type json string"
  903. // @Success 200 string "操作成功"
  904. // @router /kpler/batch_add [post]
  905. func (this *BaseFromKplerController) KplerBatchAdd() {
  906. br := new(models.BaseResponse).Init()
  907. defer func() {
  908. if br.ErrMsg == "" {
  909. br.IsSendEmail = false
  910. }
  911. this.Data["json"] = br
  912. this.ServeJSON()
  913. }()
  914. sysUser := this.SysUser
  915. if sysUser == nil {
  916. br.Msg = "请登录"
  917. br.ErrMsg = "请登录,SysUser Is Empty"
  918. br.Ret = 408
  919. return
  920. }
  921. deleteCache := true
  922. cacheKey := "CACHE_EDB_INFO_BATCH_ADD_Kpler_" + strconv.Itoa(sysUser.AdminId)
  923. defer func() {
  924. if deleteCache {
  925. _ = utils.Rc.Delete(cacheKey)
  926. }
  927. }()
  928. if !utils.Rc.SetNX(cacheKey, 1, 30*time.Second) {
  929. deleteCache = false
  930. br.Msg = "系统处理中,请稍后重试!"
  931. br.ErrMsg = "系统处理中,请稍后重试!" + sysUser.RealName + ";data:" + string(this.Ctx.Input.RequestBody)
  932. return
  933. }
  934. var req []*data_manage.AddEdbInfoReq
  935. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  936. br.Msg = "参数解析异常!"
  937. br.ErrMsg = "参数解析失败,Err:" + e.Error()
  938. return
  939. }
  940. if len(req) == 0 {
  941. br.Msg = "请选择指标"
  942. return
  943. }
  944. if len(req) > 30 {
  945. br.Msg = "批量添加指标数量不得超过30个"
  946. return
  947. }
  948. for _, v := range req {
  949. v.EdbCode = strings.TrimSpace(v.EdbCode)
  950. if v.EdbCode == "" {
  951. br.Msg = "指标ID不可为空"
  952. return
  953. }
  954. v.EdbName = strings.TrimSpace(v.EdbName)
  955. if v.EdbName == "" {
  956. br.Msg = "请输入指标名称"
  957. return
  958. }
  959. v.Frequency = strings.TrimSpace(v.Frequency)
  960. if v.Frequency == "" {
  961. br.Msg = "请选择频度"
  962. return
  963. }
  964. v.Unit = strings.TrimSpace(v.Unit)
  965. if v.Unit == "" {
  966. br.Msg = "请输入单位"
  967. return
  968. }
  969. if v.ClassifyId <= 0 {
  970. br.Msg = "请选择分类"
  971. return
  972. }
  973. }
  974. // 限定同一时间最多批量新增30个指标
  975. for _, v := range req {
  976. var r data_manage.KplerIndexSource2EdbReq
  977. r.EdbCode = v.EdbCode
  978. r.EdbName = v.EdbName
  979. r.Frequency = v.Frequency
  980. r.Unit = v.Unit
  981. r.ClassifyId = v.ClassifyId
  982. r.AdminId = sysUser.AdminId
  983. r.AdminRealName = sysUser.RealName
  984. edbInfo, e, errMsg, skip := data.KplerIndexSource2Edb(r, this.Lang)
  985. if e != nil {
  986. br.Msg = "操作失败"
  987. if errMsg != "" {
  988. br.Msg = errMsg
  989. }
  990. br.ErrMsg = e.Error()
  991. return
  992. }
  993. if skip {
  994. continue
  995. }
  996. // 试用平台更新用户累计新增指标数
  997. if utils.BusinessCode == utils.BusinessCodeSandbox {
  998. go func() {
  999. adminItem, e := system.GetSysAdminById(sysUser.AdminId)
  1000. if e != nil {
  1001. tips := fmt.Sprintf("试用平台更新用户累计新增指标数-获取用户失败, Err: " + e.Error())
  1002. utils.FileLog.Info(tips)
  1003. return
  1004. }
  1005. if adminItem.DepartmentName != "ETA试用客户" {
  1006. return
  1007. }
  1008. var ur etaTrialService.EtaTrialUserReq
  1009. ur.Mobile = adminItem.Mobile
  1010. _, _ = etaTrialService.UpdateUserIndexNum(ur)
  1011. }()
  1012. }
  1013. // 新增操作日志
  1014. {
  1015. edbLog := new(data_manage.EdbInfoLog)
  1016. edbLog.EdbInfoId = edbInfo.EdbInfoId
  1017. edbLog.SourceName = edbInfo.SourceName
  1018. edbLog.Source = edbInfo.Source
  1019. edbLog.EdbCode = edbInfo.EdbCode
  1020. edbLog.EdbName = edbInfo.EdbName
  1021. edbLog.ClassifyId = edbInfo.ClassifyId
  1022. edbLog.SysUserId = sysUser.AdminId
  1023. edbLog.SysUserRealName = sysUser.RealName
  1024. edbLog.CreateTime = time.Now()
  1025. edbLog.Content = string(this.Ctx.Input.RequestBody)
  1026. edbLog.Status = "新增指标"
  1027. edbLog.Method = this.Ctx.Input.URI()
  1028. go data_manage.AddEdbInfoLog(edbLog)
  1029. }
  1030. }
  1031. br.Msg = "操作成功"
  1032. br.Ret = 200
  1033. br.Success = true
  1034. br.IsAddLog = true
  1035. }
  1036. // KplerNameCheck
  1037. // @Title 加入指标库的重名检测
  1038. // @Description 加入指标库的重名检测
  1039. // @Param ClassifyIds query string true "分类id, 多个分类用英文"
  1040. // @Param Keyword query string true "关键词, 指标ID/指标名称"
  1041. // @Success 200 {object} NameCheckResult
  1042. // @router /kpler/edb_info/name_check [post]
  1043. func (this *BaseFromKplerController) KplerNameCheck() {
  1044. br := new(models.BaseResponse).Init()
  1045. defer func() {
  1046. if br.ErrMsg == "" {
  1047. br.IsSendEmail = false
  1048. }
  1049. this.Data["json"] = br
  1050. this.ServeJSON()
  1051. }()
  1052. sysUser := this.SysUser
  1053. if sysUser == nil {
  1054. br.Msg = "请登录"
  1055. br.ErrMsg = "请登录,SysUser Is Empty"
  1056. br.Ret = 408
  1057. return
  1058. }
  1059. var req []*data_manage.NameCheckEdbInfoReq
  1060. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  1061. br.Msg = "参数解析异常!"
  1062. br.ErrMsg = "参数解析失败,Err:" + e.Error()
  1063. return
  1064. }
  1065. if len(req) == 0 {
  1066. br.Msg = "请选择指标"
  1067. return
  1068. }
  1069. codeMaxT := 30
  1070. codeLen := len(req)
  1071. if codeLen > codeMaxT {
  1072. br.Msg = "批量添加指标数量不得超过30个"
  1073. return
  1074. }
  1075. indexNames := make([]string, 0)
  1076. resp := make([]*data_manage.EdbNameCheckResult, 0)
  1077. for _, v := range req {
  1078. v.EdbCode = strings.TrimSpace(v.EdbCode)
  1079. if v.EdbCode == "" {
  1080. br.Msg = "指标ID不可为空"
  1081. return
  1082. }
  1083. v.EdbName = strings.TrimSpace(v.EdbName)
  1084. if v.EdbName == "" {
  1085. br.Msg = "请输入指标名称"
  1086. return
  1087. }
  1088. indexNames = append(indexNames, v.EdbName)
  1089. resp = append(resp, &data_manage.EdbNameCheckResult{
  1090. EdbCode: v.EdbCode,
  1091. EdbName: v.EdbName,
  1092. })
  1093. dataItems, err := data_manage.GetEdbDataAllByEdbCode(v.EdbCode, utils.DATA_SOURCE_KPLER, 0, utils.EDB_DATA_LIMIT)
  1094. if err != nil && !utils.IsErrNoRow(err) {
  1095. br.Msg = "获取失败"
  1096. br.ErrMsg = "获取钢联已存在信息失败,Err:" + err.Error()
  1097. return
  1098. }
  1099. if len(dataItems) <= 0 {
  1100. respItem, err := data.AddEdbData(utils.DATA_SOURCE_KPLER, v.EdbCode, v.Frequency)
  1101. if err != nil {
  1102. br.Msg = "获取失败"
  1103. br.ErrMsg = "获取失败,Err:" + err.Error()
  1104. return
  1105. }
  1106. if respItem.Ret != 200 {
  1107. br.Msg = "未搜索到该指标"
  1108. br.ErrMsg = respItem.ErrMsg + ";EdbCode:" + v.EdbCode
  1109. return
  1110. }
  1111. }
  1112. }
  1113. // 重名校验
  1114. edbList, e := data_manage.GetEdbInfoByNameArr(indexNames, utils.EDB_INFO_TYPE)
  1115. if e != nil {
  1116. br.Msg = "操作失败"
  1117. br.ErrMsg = "获取重名指标失败, Err: " + e.Error()
  1118. return
  1119. }
  1120. nameExists := make(map[string]bool)
  1121. for _, v := range edbList {
  1122. nameExists[v.EdbName] = true
  1123. }
  1124. if len(nameExists) > 0 {
  1125. for _, v := range resp {
  1126. v.Exist = nameExists[v.EdbName]
  1127. }
  1128. }
  1129. br.Data = resp
  1130. br.Msg = "校验成功"
  1131. br.Ret = 200
  1132. br.Success = true
  1133. }
  1134. // KplerAddCheck
  1135. // @Title 加入指标库指标Id检测
  1136. // @Description 加入指标库指标Id检测
  1137. // @Param request body request.BatchAddCheckReq true "type json string"
  1138. // @Success 200 string "操作成功"
  1139. // @router /kpler/edb_info/add_check [post]
  1140. func (c *BaseFromKplerController) KplerAddCheck() {
  1141. br := new(models.BaseResponse).Init()
  1142. defer func() {
  1143. if br.ErrMsg == "" {
  1144. br.IsSendEmail = false
  1145. }
  1146. c.Data["json"] = br
  1147. c.ServeJSON()
  1148. }()
  1149. sysUser := c.SysUser
  1150. if sysUser == nil {
  1151. br.Msg = "请登录"
  1152. br.ErrMsg = "请登录,SysUser Is Empty"
  1153. br.Ret = 408
  1154. return
  1155. }
  1156. var req data_manage.BatchAddCheckReq
  1157. if e := json.Unmarshal(c.Ctx.Input.RequestBody, &req); e != nil {
  1158. br.Msg = "参数解析异常!"
  1159. br.ErrMsg = "参数解析失败,Err:" + e.Error()
  1160. return
  1161. }
  1162. codeMaxT := 30
  1163. codeLen := len(req.IndexCodes)
  1164. // 获取指标库已有指标
  1165. existsEdb, e := data_manage.GetEdbCodesBySource(utils.DATA_SOURCE_KPLER)
  1166. if e != nil {
  1167. br.Msg = "获取失败"
  1168. br.ErrMsg = "获取自有数据已添加的指标失败, Err: " + e.Error()
  1169. return
  1170. }
  1171. existMap := make(map[string]*data_manage.EdbInfo)
  1172. for _, v := range existsEdb {
  1173. existMap[v.EdbCode] = v
  1174. }
  1175. if codeLen == 0 {
  1176. br.Msg = "请选择指标"
  1177. return
  1178. }
  1179. if codeLen > codeMaxT {
  1180. br.Msg = fmt.Sprintf("最多只能选择%d个指标", codeMaxT)
  1181. return
  1182. }
  1183. // 查询选中的指标
  1184. cond := fmt.Sprintf(` AND index_code IN (%s)`, utils.GetOrmInReplace(codeLen))
  1185. pars := make([]interface{}, 0)
  1186. pars = append(pars, req.IndexCodes)
  1187. list, err := data_manage.GetKplerIndex(cond, pars)
  1188. if err != nil {
  1189. br.Msg = "获取失败"
  1190. br.ErrMsg = "获取钢联已存在信息失败,Err:" + err.Error()
  1191. return
  1192. }
  1193. if len(list) > codeMaxT {
  1194. br.Msg = fmt.Sprintf("最多只能选择%d个指标", codeMaxT)
  1195. return
  1196. }
  1197. resp := make([]*data_manage.BaseFromKplerIndexList, 0)
  1198. for _, v := range list {
  1199. if edb, ok := existMap[v.IndexCode]; ok {
  1200. v.EdbInfoId = edb.EdbInfoId
  1201. v.EdbClassifyId = edb.ClassifyId
  1202. v.EdbUniqueCode = edb.UniqueCode
  1203. v.EdbExist = 1
  1204. }
  1205. resp = append(resp, v)
  1206. }
  1207. br.Data = resp
  1208. br.Msg = "校验成功"
  1209. br.Ret = 200
  1210. br.Success = true
  1211. }
  1212. // 加入到指标库
  1213. // @Title 加入到指标库
  1214. // @Description 加入到指标库
  1215. // @Param request body request.BatchAddCheckReq true "type json string"
  1216. // @Success 200 string "操作成功"
  1217. // @router /kpler/edb_info/add [post]
  1218. func (c *BaseFromKplerController) KplerAdd() {
  1219. br := new(models.BaseResponse).Init()
  1220. defer func() {
  1221. c.Data["json"] = br
  1222. c.ServeJSON()
  1223. }()
  1224. sysUser := c.SysUser
  1225. if sysUser == nil {
  1226. br.Msg = "请登录"
  1227. br.ErrMsg = "请登录,SysUser Is Empty"
  1228. br.Ret = 408
  1229. return
  1230. }
  1231. var req data_manage.AddEdbInfoReq
  1232. if e := json.Unmarshal(c.Ctx.Input.RequestBody, &req); e != nil {
  1233. br.Msg = "参数解析异常!"
  1234. br.ErrMsg = "参数解析失败,Err:" + e.Error()
  1235. return
  1236. }
  1237. if req.EdbCode == "" {
  1238. br.Msg = "指标ID不能为空"
  1239. return
  1240. }
  1241. if req.EdbName == "" {
  1242. br.Msg = "指标名称不能为空"
  1243. return
  1244. }
  1245. if req.ClassifyId <= 0 {
  1246. br.Msg = "分类不能为空"
  1247. return
  1248. }
  1249. if req.Frequency == "" {
  1250. br.Msg = "频度不能为空"
  1251. return
  1252. }
  1253. if req.Unit == "" {
  1254. br.Msg = "单位不能为空"
  1255. return
  1256. }
  1257. count, err := data_manage.GetEdbInfoCount(utils.DATA_SOURCE_KPLER, req.EdbCode)
  1258. if err != nil {
  1259. br.Msg = "获取失败"
  1260. br.ErrMsg = "获取失败,Err:" + err.Error()
  1261. return
  1262. }
  1263. if count > 0 {
  1264. br.Msg = "指标已存在"
  1265. return
  1266. }
  1267. // 指标入库
  1268. edbInfo, err, errMsg, isSendEmail := data.EdbInfoAdd(utils.DATA_SOURCE_KPLER, utils.DATA_SUB_SOURCE_EDB, req.ClassifyId, req.EdbCode, req.EdbName, req.Frequency, req.Unit, req.StartDate, req.EndDate, sysUser.AdminId, sysUser.RealName, c.Lang)
  1269. if err != nil {
  1270. br.Msg = "保存失败"
  1271. if errMsg != `` {
  1272. br.Msg = errMsg
  1273. }
  1274. br.ErrMsg = err.Error()
  1275. br.IsSendEmail = isSendEmail
  1276. return
  1277. }
  1278. // 试用平台更新用户累计新增指标数
  1279. adminItem, e := system.GetSysAdminById(sysUser.AdminId)
  1280. if e != nil {
  1281. br.Msg = "操作失败"
  1282. br.ErrMsg = "获取系统用户数据失败,Err:" + e.Error()
  1283. return
  1284. }
  1285. if utils.BusinessCode == utils.BusinessCodeSandbox && adminItem.DepartmentName == "ETA试用客户" {
  1286. go func() {
  1287. var r etaTrialService.EtaTrialUserReq
  1288. r.Mobile = adminItem.Mobile
  1289. _, _ = etaTrialService.UpdateUserIndexNum(r)
  1290. }()
  1291. }
  1292. //新增操作日志
  1293. {
  1294. edbLog := new(data_manage.EdbInfoLog)
  1295. edbLog.EdbInfoId = edbInfo.EdbInfoId
  1296. edbLog.SourceName = edbInfo.SourceName
  1297. edbLog.Source = edbInfo.Source
  1298. edbLog.EdbCode = edbInfo.EdbCode
  1299. edbLog.EdbName = edbInfo.EdbName
  1300. edbLog.ClassifyId = edbInfo.ClassifyId
  1301. edbLog.SysUserId = sysUser.AdminId
  1302. edbLog.SysUserRealName = sysUser.RealName
  1303. edbLog.CreateTime = time.Now()
  1304. edbLog.Content = string(c.Ctx.Input.RequestBody)
  1305. edbLog.Status = "新增指标"
  1306. edbLog.Method = c.Ctx.Input.URI()
  1307. go data_manage.AddEdbInfoLog(edbLog)
  1308. }
  1309. // 更新es
  1310. go data.AddOrEditEdbInfoToEs(edbInfo.EdbInfoId)
  1311. resp := new(data_manage.AddEdbInfoResp)
  1312. resp.EdbInfoId = edbInfo.EdbInfoId
  1313. resp.UniqueCode = edbInfo.UniqueCode
  1314. br.Ret = 200
  1315. br.Success = true
  1316. br.Msg = "保存成功"
  1317. br.Data = resp
  1318. br.IsAddLog = true
  1319. }
  1320. // ExportKplerList
  1321. // @Title 导出Kpler数据
  1322. // @Description 导出Kpler数据
  1323. // @Param ClassifyId query int true "关键字搜索"
  1324. // @Param IndexCode query string true "指标编码"
  1325. // @Success 200 导出成功
  1326. // @router /kpler/export [get]
  1327. func (this *BaseFromKplerController) ExportKplerList() {
  1328. br := new(models.BaseResponse).Init()
  1329. defer func() {
  1330. this.Data["json"] = br
  1331. this.ServeJSON()
  1332. }()
  1333. sysUser := this.SysUser
  1334. if sysUser == nil {
  1335. br.Msg = "请重新登录"
  1336. return
  1337. }
  1338. classifyId, _ := this.GetInt("ClassifyId")
  1339. indexCode := this.GetString("IndexCode")
  1340. if classifyId <= 0 && indexCode == "" {
  1341. br.Msg = "请选择分类或者指标"
  1342. return
  1343. }
  1344. dir, _ := os.Executable()
  1345. exPath := filepath.Dir(dir)
  1346. downLoadnFilePath := exPath + "/" + time.Now().Format(utils.FormatDateTimeUnSpace) + ".xlsx"
  1347. xlsxFile := xlsx.NewFile()
  1348. var condition string
  1349. var pars []interface{}
  1350. var classifyName string
  1351. if classifyId > 0 {
  1352. classifyInfo, err := data_manage.GetBaseFromKplerClassifyById(classifyId)
  1353. if err != nil {
  1354. if utils.IsErrNoRow(err) {
  1355. br.Msg = "分类不存在"
  1356. return
  1357. }
  1358. br.Msg = "下载失败"
  1359. br.ErrMsg = "获取分类失败,Err:" + err.Error()
  1360. return
  1361. }
  1362. classifyName = classifyInfo.ClassifyName
  1363. childClassify := make([]*data_manage.BaseFromKplerClassify, 0)
  1364. if classifyInfo.LevelPath != "" {
  1365. childClassify, err = data_manage.GetBaseFromKplerClassifyByLevelPath(classifyInfo.LevelPath)
  1366. if err != nil {
  1367. br.Msg = "下载失败"
  1368. br.ErrMsg = "获取分类失败,Err:" + err.Error()
  1369. return
  1370. }
  1371. }
  1372. if len(childClassify) > 0 {
  1373. childClassifyIds := make([]int, 0)
  1374. for _, child := range childClassify {
  1375. childClassifyIds = append(childClassifyIds, child.ClassifyId)
  1376. }
  1377. condition += ` AND classify_id IN (` + utils.GetOrmInReplace(len(childClassifyIds)) + `)`
  1378. pars = append(pars, childClassifyIds)
  1379. } else {
  1380. condition += ` AND classify_id=?`
  1381. pars = append(pars, classifyId)
  1382. }
  1383. }
  1384. if indexCode != "" {
  1385. condition += ` AND index_code=? `
  1386. pars = append(pars, indexCode)
  1387. }
  1388. indexList, err := data_manage.GetKplerIndex(condition, pars)
  1389. if err != nil {
  1390. br.Msg = "下载失败"
  1391. br.ErrMsg = "获取指标失败,Err:" + err.Error()
  1392. fmt.Println("获取数据失败,Err:" + err.Error())
  1393. return
  1394. }
  1395. if len(indexList) <= 0 {
  1396. fmt.Println("indexList 为空")
  1397. br.Ret = 200
  1398. br.Success = true
  1399. br.Msg = "success"
  1400. return
  1401. }
  1402. codeList := make([]string, 0)
  1403. frequenciesMap := make(map[string][]*data_manage.BaseFromKplerIndexList)
  1404. for _, v := range indexList {
  1405. codeList = append(codeList, v.IndexCode)
  1406. frequenciesMap[v.Frequency] = append(frequenciesMap[v.Frequency], v)
  1407. }
  1408. dataListMap := make(map[string][]*data_manage.BaseFromKplerData)
  1409. if len(indexList) > 0 {
  1410. allDataList, e := data_manage.GetKplerIndexDataByCodes(codeList)
  1411. if e != nil {
  1412. br.Msg = "获取数据失败"
  1413. br.ErrMsg = "获取数据失败,Err:" + e.Error()
  1414. return
  1415. }
  1416. for _, v := range allDataList {
  1417. dataListMap[v.IndexCode] = append(dataListMap[v.IndexCode], v)
  1418. }
  1419. }
  1420. // 按照频率分组排序
  1421. frequencies := []string{
  1422. "日度", "周度", "旬度", "月度", "季度", "半年度", "年度",
  1423. }
  1424. for _, frequency := range frequencies {
  1425. //获取指标
  1426. indexCodeList, ok := frequenciesMap[frequency]
  1427. if !ok {
  1428. continue
  1429. }
  1430. if len(indexCodeList) <= 0 {
  1431. fmt.Printf("sheet:%s, 不存在指标", frequency)
  1432. return
  1433. }
  1434. var sheetName string
  1435. switch frequency {
  1436. case "日度":
  1437. sheetName = "日度(Daily)"
  1438. case "周度":
  1439. sheetName = "周度(Weekly)"
  1440. case "旬度":
  1441. sheetName = "旬度(ten-day)"
  1442. case "月度":
  1443. sheetName = "月度(Monthly)"
  1444. case "季度":
  1445. sheetName = "季度(Quarterly)"
  1446. case "半年度":
  1447. sheetName = "半年度(Semi-annual)"
  1448. case "年度":
  1449. sheetName = "年度(Annual)"
  1450. default:
  1451. sheetName = "其他数据"
  1452. }
  1453. sheetNew, err := xlsxFile.AddSheet(sheetName)
  1454. if err != nil {
  1455. fmt.Println("新增Sheet失败", err.Error())
  1456. return
  1457. }
  1458. secNameRow := sheetNew.AddRow()
  1459. frequencyRow := sheetNew.AddRow()
  1460. unitRow := sheetNew.AddRow()
  1461. lastModifyDateRow := sheetNew.AddRow()
  1462. var indexIdList []int
  1463. for _, idx := range frequenciesMap[frequency] {
  1464. indexIdList = append(indexIdList, idx.BaseFromKplerIndexId)
  1465. }
  1466. dataTimeList, err := data_manage.GetKplerDataDataTimeByIndexId(indexIdList)
  1467. if err != nil {
  1468. br.Msg = "下载失败"
  1469. br.ErrMsg = "获取数据时间失败,Err:" + err.Error()
  1470. fmt.Println("获取数据时间失败", err.Error())
  1471. return
  1472. }
  1473. // 添加excel左侧指标日期
  1474. setRowIndex := 4
  1475. for rk, dv := range dataTimeList {
  1476. rowIndex := setRowIndex + rk
  1477. row := sheetNew.Row(rowIndex)
  1478. displayDate, _ := time.Parse(utils.FormatDate, dv)
  1479. displayDateCell := row.AddCell()
  1480. style := new(xlsx.Style)
  1481. style.ApplyAlignment = true
  1482. style.Alignment.WrapText = true
  1483. displayDateCell.SetStyle(style)
  1484. displayDateCell.SetDate(displayDate)
  1485. }
  1486. for k, icl := range indexCodeList {
  1487. // 获取数据
  1488. dataList, ok := dataListMap[icl.IndexCode]
  1489. if !ok {
  1490. continue
  1491. }
  1492. if k == 0 {
  1493. secNameRow.AddCell().SetValue("指标名称/Metric Name")
  1494. frequencyRow.AddCell().SetValue("频度/Frequency")
  1495. unitRow.AddCell().SetValue("单位/Unit")
  1496. lastModifyDateRow.AddCell().SetValue("更新时间/Update Time")
  1497. min := k * 3
  1498. sheetNew.SetColWidth(min, min, 15)
  1499. }
  1500. if len(dataList) == 0 {
  1501. continue
  1502. }
  1503. secNameRow.AddCell().SetValue(icl.IndexName)
  1504. frequencyRow.AddCell().SetValue(icl.Frequency)
  1505. unitRow.AddCell().SetValue(icl.Unit)
  1506. timeDate, err := time.Parse(utils.FormatDateTime, dataList[0].ModifyTime)
  1507. if err != nil {
  1508. continue
  1509. }
  1510. lastModifyDateRow.AddCell().SetValue(timeDate.Format(utils.FormatDate))
  1511. dataInfoMap := make(map[string]*data_manage.BaseFromKplerData)
  1512. for _, v := range dataList {
  1513. dataInfoMap[v.DataTime] = v
  1514. }
  1515. for rk, dtv := range dataTimeList {
  1516. rowIndex := setRowIndex + rk
  1517. row := sheetNew.Row(rowIndex)
  1518. displayDateCell := row.AddCell()
  1519. tmpData, ok := dataInfoMap[dtv]
  1520. if ok {
  1521. displayDateCell.SetValue(tmpData.Value)
  1522. }
  1523. }
  1524. }
  1525. }
  1526. err = xlsxFile.Save(downLoadnFilePath)
  1527. if err != nil {
  1528. //有指标无数据时先导出一遍空表
  1529. sheet, err := xlsxFile.AddSheet("无数据")
  1530. if err != nil {
  1531. br.Msg = "新增Sheet失败"
  1532. br.ErrMsg = "新增Sheet失败,Err:" + err.Error()
  1533. return
  1534. }
  1535. rowSecName := sheet.AddRow()
  1536. celSecName := rowSecName.AddCell()
  1537. celSecName.SetValue("")
  1538. e := xlsxFile.Save(downLoadnFilePath)
  1539. if e != nil {
  1540. br.Msg = "保存文件失败"
  1541. br.ErrMsg = "保存文件失败"
  1542. return
  1543. }
  1544. }
  1545. fileName := classifyName
  1546. if indexCode != "" && len(indexList) == 1 {
  1547. fileName = indexList[0].IndexName
  1548. }
  1549. fileName = strings.Replace(fileName, ": ", "_", -1)
  1550. fileName = strings.Replace(fileName, ", ", "_", -1)
  1551. fileName = strings.Replace(fileName, " ", "_", -1)
  1552. fileName += time.Now().Format("06.01.02") + `.xlsx` //文件名称
  1553. fmt.Println(fileName)
  1554. this.Ctx.Output.Download(downLoadnFilePath, fileName)
  1555. defer func() {
  1556. os.Remove(downLoadnFilePath)
  1557. }()
  1558. br.Ret = 200
  1559. br.Success = true
  1560. br.Msg = "success"
  1561. }
  1562. // GetFrequency
  1563. // @Title kpler数据频度
  1564. // @Description kpler数据频度接口
  1565. // @Param ClassifyId query string true "分类Id"
  1566. // @Success 200 {object} data_manage.LzFrequency
  1567. // @router /kpler/frequency [get]
  1568. func (this *BaseFromKplerController) GetFrequency() {
  1569. br := new(models.BaseResponse).Init()
  1570. defer func() {
  1571. this.Data["json"] = br
  1572. this.ServeJSON()
  1573. }()
  1574. sysUser := this.SysUser
  1575. if sysUser == nil {
  1576. br.Msg = "请登录"
  1577. br.ErrMsg = "请登录,SysUser Is Empty"
  1578. br.Ret = 408
  1579. return
  1580. }
  1581. classifyId, _ := this.GetInt("ClassifyId")
  1582. if classifyId < 0 {
  1583. br.Msg = "请选择分类"
  1584. br.ErrMsg = "请选择分类"
  1585. return
  1586. }
  1587. frequencyList, err := data_manage.GetKplerFrequencyByClassifyId(classifyId)
  1588. if err != nil {
  1589. br.Msg = "获取频度失败"
  1590. br.ErrMsg = "获取频度失败,Err:" + err.Error()
  1591. return
  1592. }
  1593. br.Ret = 200
  1594. br.Success = true
  1595. br.Msg = "获取成功"
  1596. br.Data = frequencyList
  1597. }
  1598. // BatchAddEdbCheck
  1599. // @Title 新增校验
  1600. // @Description 新增校验
  1601. // @Param request body data_manage.BatchManualEdbReq true "type json string"
  1602. // @Success 200 string "操作成功"
  1603. // @router /kpler/batch/add/check [post]
  1604. func (this *BaseFromKplerController) BatchAddEdbCheck() {
  1605. br := new(models.BaseResponse).Init()
  1606. defer func() {
  1607. if br.ErrMsg == "" {
  1608. br.IsSendEmail = false
  1609. }
  1610. this.Data["json"] = br
  1611. this.ServeJSON()
  1612. }()
  1613. sysUser := this.SysUser
  1614. if sysUser == nil {
  1615. br.Msg = "请登录"
  1616. br.ErrMsg = "请登录,SysUser Is Empty"
  1617. br.Ret = 408
  1618. return
  1619. }
  1620. // 最大批量添加的数量
  1621. codeMaxT := 31
  1622. var req data_manage.BatchCheckKplerEdbReq
  1623. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1624. if err != nil {
  1625. br.Msg = "参数错误"
  1626. br.ErrMsg = "参数错误,Err:" + err.Error()
  1627. return
  1628. }
  1629. req.Keyword = strings.TrimSpace(req.Keyword)
  1630. classifyIdStr := req.ClassifyIds
  1631. var list = make([]*data_manage.BaseFromKplerIndexList, 0)
  1632. var condition string
  1633. var pars []interface{}
  1634. if req.ListAll {
  1635. classifyIds := strings.Split(classifyIdStr, ",")
  1636. if len(classifyIds) > 0 && classifyIds[0] != `` {
  1637. condition += " AND classify_id IN (" + utils.GetOrmInReplace(len(classifyIds)) + " ) "
  1638. pars = append(pars, classifyIds)
  1639. }
  1640. keyword := req.Keyword
  1641. if keyword != `` {
  1642. condition += " AND (index_name like ? OR index_code like ?) "
  1643. pars = utils.GetLikeKeywordPars(pars, keyword, 2)
  1644. }
  1645. frequencies := req.Frequencies
  1646. if frequencies != "" {
  1647. frequencyList := strings.Split(frequencies, ",")
  1648. condition += " AND frequency IN (" + utils.GetOrmInReplace(len(frequencyList)) + " ) "
  1649. pars = append(pars, frequencyList)
  1650. }
  1651. codes := req.TradeCodeList
  1652. codeList := make([]string, 0)
  1653. if codes != "" {
  1654. codeList = strings.Split(codes, ",")
  1655. }
  1656. if len(codeList) > 0 {
  1657. condition += ` AND index_code not in (` + utils.GetOrmInReplace(len(codeList)) + `) `
  1658. pars = append(pars, codeList)
  1659. }
  1660. } else {
  1661. codes := req.TradeCodeList
  1662. codeList := make([]string, 0)
  1663. if codes != "" {
  1664. codeList = strings.Split(codes, ",")
  1665. }
  1666. if len(codeList) <= 0 {
  1667. br.Msg = "请选择指标"
  1668. br.ErrMsg = "请选择指标"
  1669. return
  1670. }
  1671. // 指标
  1672. condition += ` AND index_code in (` + utils.GetOrmInReplace(len(codeList)) + `) `
  1673. pars = append(pars, codeList)
  1674. }
  1675. condition += ` AND index_code not in (SELECT edb_code FROM edb_info WHERE source=?) `
  1676. pars = append(pars, utils.DATA_SOURCE_USDA_FAS)
  1677. list, err = data_manage.GetKplerIndexPage(condition, pars, 0, codeMaxT)
  1678. if err != nil {
  1679. br.Msg = "获取失败"
  1680. br.ErrMsg = "获取失败,Err:" + err.Error()
  1681. return
  1682. }
  1683. if len(list) >= codeMaxT {
  1684. br.Msg = "批量添加指标数量不得超过30个"
  1685. return
  1686. }
  1687. br.Data = list
  1688. br.Msg = "校验成功"
  1689. br.Ret = 200
  1690. br.Success = true
  1691. }