manual_edb.go 40 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601
  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. "github.com/rdlucklib/rdluck_tools/paging"
  13. "github.com/shopspring/decimal"
  14. "os"
  15. "strconv"
  16. "strings"
  17. "time"
  18. )
  19. // ManualEdbController 手工指标服务(鉴权)
  20. type ManualEdbController struct {
  21. controllers.BaseAuthController
  22. }
  23. // EdbDetail
  24. // @Title 指标列表
  25. // @Description 指标列表
  26. // @Param TradeCode query string true "指标编码"
  27. // @Success 200 {object} models.TargetDetailResp
  28. // @router /target/edb/detail [get]
  29. func (c *ManualEdbController) EdbDetail() {
  30. br := new(models.BaseResponse).Init()
  31. defer func() {
  32. c.Data["json"] = br
  33. c.ServeJSON()
  34. }()
  35. sysUser := c.SysUser
  36. if sysUser == nil {
  37. br.Msg = "请重新登录"
  38. return
  39. }
  40. // 指标编码
  41. tradeCode := c.GetString("TradeCode")
  42. if tradeCode == `` {
  43. br.Msg = "请输入指标编码"
  44. br.IsSendEmail = false
  45. return
  46. }
  47. manualEdbInfo, err := models.GetTargetByTradeCode(tradeCode)
  48. if err != nil {
  49. br.Msg = "获取指标失败"
  50. br.ErrMsg = "获取指标失败,err:" + err.Error()
  51. return
  52. }
  53. // 如果不是超管账号,那么得校验下当前用户是否有该指标的权限
  54. if sysUser.RoleTypeCode != utils.ROLE_TYPE_CODE_ADMIN {
  55. //获取账户所拥有权限的分类id集合
  56. count, err := models.GetCountManualUserClassify(sysUser.AdminId, manualEdbInfo.ClassifyId)
  57. if err != nil {
  58. br.Msg = "获取分类数据失败"
  59. br.ErrMsg = "获取分类数据失败,err:" + err.Error()
  60. return
  61. }
  62. if count <= 0 {
  63. br.Msg = "无权访问"
  64. br.ErrMsg = "无权访问"
  65. br.IsSendEmail = false
  66. return
  67. }
  68. }
  69. classifyList := make([]*models.EdbdataClassify, 0)
  70. {
  71. classify, err := models.GetManualClassifyByClassifyId(manualEdbInfo.ClassifyId)
  72. if err != nil {
  73. br.Msg = "获取分类信息失败"
  74. br.ErrMsg = "获取分类信息失败,err:" + err.Error()
  75. return
  76. }
  77. parentClassify, err := models.GetManualClassifyByClassifyId(classify.ParentId)
  78. if err != nil {
  79. br.Msg = "获取分类信息失败"
  80. br.ErrMsg = "获取父级分类信息失败,err:" + err.Error()
  81. return
  82. }
  83. classifyList = []*models.EdbdataClassify{
  84. parentClassify, classify,
  85. }
  86. }
  87. // 明细数据
  88. {
  89. dataList, err := models.GetEdbDataListByCode(manualEdbInfo.TradeCode)
  90. if err != nil {
  91. br.Msg = "获取明细数据失败"
  92. br.ErrMsg = "获取明细数据失败,err:" + err.Error()
  93. return
  94. }
  95. // 获取下期时间
  96. dataNextDateTime, err := fillDataNextDateTime(dataList)
  97. if err != nil {
  98. return
  99. }
  100. manualEdbInfo.DataList = dataNextDateTime
  101. }
  102. resp := models.TargetDetailResp{
  103. Detail: manualEdbInfo,
  104. ClassifyList: classifyList,
  105. }
  106. br.Ret = 200
  107. br.Success = true
  108. br.Msg = "获取成功"
  109. //br.Data = resp
  110. br.Data = resp
  111. }
  112. // 封装指标数据下期时间
  113. func fillDataNextDateTime(list []*models.Edbdata) ([]*models.Edbdata, error) {
  114. if len(list) == 0 {
  115. return nil, nil
  116. }
  117. nextDataDateTime := models.Edbdata{}
  118. nextDataDateTime.TradeCode = list[0].TradeCode
  119. indexCodes := []string{list[0].TradeCode}
  120. edbinfoList, err := models.GetEdbinfoListByCodeListByCodeIdList(indexCodes)
  121. if err != nil {
  122. return nil, err
  123. }
  124. if len(edbinfoList) == 0 {
  125. return list, nil
  126. }
  127. date := utils.StrDateToDate(list[0].Dt)
  128. frequency := edbinfoList[0].Frequency
  129. switch frequency {
  130. case "日度":
  131. nextDataDateTime.Dt = date.AddDate(0, 0, 1).Format(utils.FormatDate)
  132. case "周度":
  133. nextDataDateTime.Dt = date.AddDate(0, 0, 7).Format(utils.FormatDate)
  134. case "旬度":
  135. nextDataDateTime.Dt = date.AddDate(0, 0, 10).Format(utils.FormatDate)
  136. case "月度":
  137. nextDataDateTime.Dt = date.AddDate(0, 1, 0).Format(utils.FormatDate)
  138. case "季度":
  139. nextDataDateTime.Dt = date.AddDate(0, 3, 0).Format(utils.FormatDate)
  140. case "半年度":
  141. nextDataDateTime.Dt = date.AddDate(0, 6, 0).Format(utils.FormatDate)
  142. case "年度":
  143. nextDataDateTime.Dt = date.AddDate(1, 0, 0).Format(utils.FormatDate)
  144. }
  145. // nextDataDateTime 添加到list第一个
  146. list = append([]*models.Edbdata{&nextDataDateTime}, list...)
  147. return list, nil
  148. }
  149. // ClassifyEdbList
  150. // @Title 分类指标列表
  151. // @Description 指标列表
  152. // @Param ClassifyId query string true "分类id"
  153. // @Success 200 {object} models.TargetDetailResp
  154. // @router /target/classify/edb/list [get]
  155. func (c *ManualEdbController) ClassifyEdbList() {
  156. br := new(models.BaseResponse).Init()
  157. defer func() {
  158. c.Data["json"] = br
  159. c.ServeJSON()
  160. }()
  161. sysUser := c.SysUser
  162. if sysUser == nil {
  163. br.Msg = "请登录"
  164. br.Ret = 408
  165. return
  166. }
  167. resp := new(models.EdbdataClassifyResp)
  168. classifyId, _ := c.GetInt("ClassifyId") //分类
  169. if classifyId <= 0 {
  170. br.Msg = "请传入分类"
  171. br.ErrMsg = "请传入分类"
  172. br.IsSendEmail = false
  173. }
  174. var condition string
  175. var pars []interface{}
  176. // 如果不是超管账号,那么得校验下当前用户是否有该指标的权限
  177. if sysUser.RoleTypeCode != utils.ROLE_TYPE_CODE_ADMIN {
  178. //获取账户所拥有权限的分类id集合
  179. count, err := models.GetCountManualUserClassify(sysUser.AdminId, classifyId)
  180. if err != nil {
  181. br.Msg = "获取分类数据失败"
  182. br.ErrMsg = "获取分类数据失败,err:" + err.Error()
  183. return
  184. }
  185. if count <= 0 {
  186. br.Msg = "无权访问"
  187. br.ErrMsg = "无权访问"
  188. br.IsSendEmail = false
  189. return
  190. }
  191. }
  192. list := make([]*models.EdbdataClassifyList, 0)
  193. condition += ` AND a.classify_id = ? `
  194. pars = append(pars, classifyId)
  195. tmpList, err := models.GetEdbInfoList(condition, pars, 0, 0)
  196. if err != nil {
  197. br.Msg = "获取失败"
  198. br.ErrMsg = "获取失败,Err:" + err.Error()
  199. return
  200. }
  201. for _, v := range tmpList {
  202. list = append(list, &models.EdbdataClassifyList{
  203. ClassifyId: 0,
  204. ClassifyName: v.SecName,
  205. ParentId: v.ClassifyId,
  206. Child: nil,
  207. TradeCode: v.TradeCode,
  208. UniqueCode: utils.MD5(v.TradeCode),
  209. })
  210. }
  211. resp.List = list
  212. br.Ret = 200
  213. br.Success = true
  214. br.Msg = "获取成功"
  215. br.Data = resp
  216. }
  217. // EdbSearch
  218. // @Title 指标搜索
  219. // @Description 指标搜索
  220. // @Param Keyword query string false "关键字搜索"
  221. // @Success 200 {object} models.TargetItemListResp
  222. // @router /target/edb/search [get]
  223. func (c *ManualEdbController) EdbSearch() {
  224. br := new(models.BaseResponse).Init()
  225. defer func() {
  226. c.Data["json"] = br
  227. c.ServeJSON()
  228. }()
  229. sysUser := c.SysUser
  230. if sysUser == nil {
  231. br.Msg = "请重新登录"
  232. return
  233. }
  234. pageSize, _ := c.GetInt("PageSize")
  235. currentIndex, _ := c.GetInt("CurrentIndex")
  236. var startSize int
  237. if pageSize <= 0 {
  238. pageSize = utils.PageSize20
  239. }
  240. if currentIndex <= 0 {
  241. currentIndex = 1
  242. }
  243. startSize = utils.StartIndex(currentIndex, pageSize)
  244. //关键字
  245. keyword := c.GetString("Keyword")
  246. var condition string
  247. var pars []interface{}
  248. //userId := sysUser.AdminId
  249. //超管账号可以查看分类下的所有频度数据
  250. if sysUser.RoleTypeCode != utils.ROLE_TYPE_CODE_ADMIN {
  251. classifyIdList, err := data.GetUserManualClassifyIdList(sysUser.AdminId)
  252. if err != nil {
  253. br.Msg = "获取分类数据失败"
  254. br.Msg = "获取拥有的分类数据失败,Err:" + err.Error()
  255. return
  256. }
  257. num := len(classifyIdList)
  258. if num > 0 {
  259. condition += ` AND a.classify_id in (` + utils.GetOrmInReplace(num) + `) `
  260. pars = append(pars, classifyIdList)
  261. }
  262. }
  263. if keyword != "" {
  264. condition += ` AND (a.SEC_NAME like ? or a.TRADE_CODE like ? )`
  265. pars = utils.GetLikeKeywordPars(pars, keyword, 2)
  266. }
  267. total, err := models.GetCountEdbInfoList(condition, pars)
  268. if err != nil {
  269. br.Msg = "获取失败"
  270. br.ErrMsg = "获取失败,Err:" + err.Error()
  271. return
  272. }
  273. list, err := models.GetEdbInfoList(condition, pars, startSize, pageSize)
  274. if err != nil {
  275. br.Msg = "获取失败"
  276. br.ErrMsg = "获取失败,Err:" + err.Error()
  277. return
  278. }
  279. for _, v := range list {
  280. v.UniqueCode = utils.MD5(v.TradeCode)
  281. }
  282. resp := models.EdbListResp{
  283. List: list,
  284. Paging: paging.GetPaging(currentIndex, pageSize, total),
  285. }
  286. br.Ret = 200
  287. br.Success = true
  288. br.Msg = "获取成功"
  289. br.Data = resp
  290. }
  291. // EdbList
  292. // @Title 获取研究员指标
  293. // @Description 获取研究员指标
  294. // @Param Frequency query string false "频度;枚举值:日度、周度、月度、季度、半年度、年度"
  295. // @Param Keyword query string false "关键字搜索"
  296. // @Param TradeCode query string false "指标唯一编码"
  297. // @Param ClassifyId query int false "分类id"
  298. // @Param UserId query int false "用户id"
  299. // @Success 200 {object} models.TargetItemListResp
  300. // @router /target/edb/list [get]
  301. func (c *ManualEdbController) EdbList() {
  302. br := new(models.BaseResponse).Init()
  303. defer func() {
  304. c.Data["json"] = br
  305. c.ServeJSON()
  306. }()
  307. sysUser := c.SysUser
  308. if sysUser == nil {
  309. br.Msg = "请重新登录"
  310. return
  311. }
  312. pageSize, _ := c.GetInt("PageSize")
  313. currentIndex, _ := c.GetInt("CurrentIndex")
  314. var startSize int
  315. if pageSize <= 0 {
  316. pageSize = utils.PageSize20
  317. }
  318. if currentIndex <= 0 {
  319. currentIndex = 1
  320. }
  321. startSize = utils.StartIndex(currentIndex, pageSize)
  322. // 频度
  323. frequency := c.GetString("Frequency")
  324. //关键字
  325. keyword := c.GetString("Keyword")
  326. //关键字
  327. classifyId, _ := c.GetInt("ClassifyId", 0)
  328. //用户ID
  329. userId, _ := c.GetInt("UserId", 0)
  330. var condition string
  331. var pars []interface{}
  332. // 权限用户id
  333. permissionUserId := sysUser.AdminId
  334. //超管账号可以查看分类下的所有频度数据
  335. if sysUser.RoleTypeCode != utils.ROLE_TYPE_CODE_ADMIN {
  336. classifyIdList, err := data.GetUserManualClassifyIdList(sysUser.AdminId)
  337. if err != nil {
  338. br.Msg = "获取分类数据失败"
  339. br.Msg = "获取拥有的分类数据失败,Err:" + err.Error()
  340. return
  341. }
  342. num := len(classifyIdList)
  343. if num > 0 {
  344. condition += ` AND a.classify_id in (` + utils.GetOrmInReplace(num) + `) `
  345. pars = append(pars, classifyIdList)
  346. }
  347. } else {
  348. permissionUserId = 0
  349. }
  350. // 关键词
  351. if keyword != "" {
  352. condition += ` AND (a.SEC_NAME like ? or a.TRADE_CODE like ? )`
  353. pars = utils.GetLikeKeywordPars(pars, keyword, 2)
  354. }
  355. if frequency != "" {
  356. condition += ` AND a.frequency = ?`
  357. pars = append(pars, frequency)
  358. }
  359. // 所属分类
  360. if classifyId > 0 {
  361. // 获取有用权限的分类
  362. classifyList, err := models.GetEdbdataClassify(int64(permissionUserId))
  363. if err != nil {
  364. return
  365. }
  366. var isParent bool
  367. classifyIdList := make([]int, 0)
  368. for _, v := range classifyList {
  369. if v.ClassifyId == classifyId {
  370. isParent = true
  371. classifyIdList = append(classifyIdList, v.ClassifyId)
  372. if v.Child != nil && len(v.Child) > 0 {
  373. for _, vv := range v.Child {
  374. classifyIdList = append(classifyIdList, vv.ClassifyId)
  375. }
  376. }
  377. break
  378. }
  379. }
  380. num := len(classifyIdList)
  381. if num > 0 && isParent {
  382. condition += ` AND a.classify_id in (` + utils.GetOrmInReplace(num) + `) `
  383. pars = append(pars, classifyIdList)
  384. } else {
  385. condition += ` AND a.classify_id = ? `
  386. pars = append(pars, classifyId)
  387. }
  388. }
  389. // 所属用户
  390. if userId > 0 {
  391. condition += ` AND a.user_id = ? `
  392. pars = append(pars, userId)
  393. }
  394. total, err := models.GetCountEdbInfoList(condition, pars)
  395. if err != nil {
  396. br.Msg = "获取失败"
  397. br.ErrMsg = "获取失败,Err:" + err.Error()
  398. return
  399. }
  400. list, err := models.GetEdbInfoList(condition, pars, startSize, pageSize)
  401. if err != nil {
  402. br.Msg = "获取失败"
  403. br.ErrMsg = "获取失败,Err:" + err.Error()
  404. return
  405. }
  406. // 获取预测时间
  407. fillNextDateTime(list)
  408. resp := models.EdbListResp{
  409. List: list,
  410. Paging: paging.GetPaging(currentIndex, pageSize, total),
  411. }
  412. br.Ret = 200
  413. br.Success = true
  414. br.Msg = "获取成功"
  415. br.Data = resp
  416. }
  417. // 封装指标列表下期时间
  418. func fillNextDateTime(list []*models.EdbInfoListItem) {
  419. for _, item := range list {
  420. date := utils.StrDateToDate(item.EndDate)
  421. switch item.Frequency {
  422. case "日度":
  423. item.NextDateTime = date.AddDate(0, 0, 1).Format(utils.FormatDate)
  424. case "周度":
  425. item.NextDateTime = date.AddDate(0, 0, 7).Format(utils.FormatDate)
  426. case "旬度":
  427. item.NextDateTime = date.AddDate(0, 0, 10).Format(utils.FormatDate)
  428. case "月度":
  429. item.NextDateTime = date.AddDate(0, 1, 0).Format(utils.FormatDate)
  430. case "季度":
  431. item.NextDateTime = date.AddDate(0, 3, 0).Format(utils.FormatDate)
  432. case "半年度":
  433. item.NextDateTime = date.AddDate(0, 6, 0).Format(utils.FormatDate)
  434. case "年度":
  435. item.NextDateTime = date.AddDate(1, 0, 0).Format(utils.FormatDate)
  436. }
  437. }
  438. }
  439. // EditExcelData
  440. // @Title 根据excel的样式去编辑指标
  441. // @Description 根据excel的样式去编辑指标
  442. // @Param request body models.ManualEdbExcelStyleEditReq true "type json string"
  443. // @Success 200
  444. // @router /target/edb/excel_style/edit [post]
  445. func (c *ManualEdbController) EditExcelData() {
  446. br := new(models.BaseResponse).Init()
  447. var err error
  448. errs := make([]string, 0)
  449. defer func() {
  450. if len(errs) > 0 {
  451. utils.FileLog.Info("编辑EXCEL数据 新增或修改数据失败,Err:" + strings.Join(errs, "\n"))
  452. }
  453. c.Data["json"] = br
  454. c.ServeJSON()
  455. }()
  456. sysUser := c.SysUser
  457. if sysUser == nil {
  458. br.Msg = "请重新登录"
  459. return
  460. }
  461. var req data_manage.ManualEdbExcelStyleEditReq
  462. err = json.Unmarshal(c.Ctx.Input.RequestBody, &req)
  463. if err != nil {
  464. br.Msg = "参数解析异常!"
  465. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  466. return
  467. }
  468. if req.TradeCode == `` {
  469. br.Msg = "指标编码异常!"
  470. br.ErrMsg = "指标编码异常!"
  471. return
  472. }
  473. if req.Unit == `` {
  474. br.Msg = "单位填写异常!"
  475. br.ErrMsg = "单位填写异常!"
  476. return
  477. }
  478. if req.Frequency == `` {
  479. br.Msg = "频度填写异常!"
  480. br.ErrMsg = "频度填写异常!"
  481. return
  482. }
  483. if req.ClassifyId <= 0 {
  484. br.Msg = "品种填写异常!"
  485. br.ErrMsg = "品种填写异常!"
  486. return
  487. }
  488. // 获取指标信息
  489. manualEdbInfo, err := models.GetEdbinfoByTradeCode(req.TradeCode)
  490. if err != nil {
  491. br.Msg = `找不到该指标`
  492. br.Msg = `找不到该指标,ERR:` + err.Error()
  493. return
  494. }
  495. // 如果不是超管账号,那么得校验下当前用户是否有该指标的权限
  496. if sysUser.RoleTypeCode != utils.ROLE_TYPE_CODE_ADMIN {
  497. count, err := models.GetCountManualUserClassify(sysUser.AdminId, manualEdbInfo.ClassifyId)
  498. if err != nil {
  499. br.Msg = "获取分类数据失败"
  500. br.ErrMsg = "获取分类数据失败,err:" + err.Error()
  501. return
  502. }
  503. if count <= 0 {
  504. br.Msg = "无权访问"
  505. br.ErrMsg = "无权访问"
  506. br.IsSendEmail = false
  507. return
  508. }
  509. }
  510. dateValueMap := make(map[string]string)
  511. //取到所有数据
  512. for _, dateValue := range req.Data {
  513. dateValueMap[dateValue.Date] = strconv.FormatFloat(dateValue.Value, 'f', -1, 64)
  514. }
  515. //操作指标,新增指标及数据等
  516. {
  517. var isUpdateEdb, isUpdateData bool
  518. secName := strings.TrimSpace(req.EdbName)
  519. frequency := strings.TrimSpace(req.Frequency)
  520. unit := strings.TrimSpace(req.Unit)
  521. // 指标基础信息变更
  522. {
  523. updateCols := make([]string, 0)
  524. if manualEdbInfo.SecName != secName {
  525. // 校验是否存在相同指标名称
  526. var condition string
  527. var pars []interface{}
  528. condition += " AND SEC_NAME=? AND left(TRADE_CODE,1)='W' AND REMARK='手动' AND TRADE_CODE != ? "
  529. pars = append(pars, secName, req.TradeCode)
  530. count, err := models.GetManualEdbCountByCondition(condition, pars)
  531. if err != nil {
  532. br.Msg = `指标保存失败`
  533. br.ErrMsg = `获取同名指标信息异常,ERR:` + err.Error()
  534. return
  535. }
  536. if count > 0 {
  537. br.Msg = `已存在同名指标`
  538. br.ErrMsg = `已存在同名指标`
  539. br.IsSendEmail = false
  540. return
  541. }
  542. updateCols = append(updateCols, "SecName")
  543. manualEdbInfo.SecName = secName
  544. }
  545. if manualEdbInfo.ClassifyId != req.ClassifyId {
  546. updateCols = append(updateCols, "ClassifyId")
  547. manualEdbInfo.ClassifyId = req.ClassifyId
  548. }
  549. if manualEdbInfo.Frequency != frequency {
  550. updateCols = append(updateCols, "Frequency")
  551. manualEdbInfo.Frequency = frequency
  552. }
  553. if manualEdbInfo.Unit != unit {
  554. updateCols = append(updateCols, "Unit")
  555. manualEdbInfo.Unit = unit
  556. }
  557. if len(updateCols) > 0 {
  558. isUpdateEdb = true
  559. manualEdbInfo.ModifyTime = time.Now().Format(utils.FormatDateTime)
  560. updateCols = append(updateCols, "ModifyTime")
  561. err = manualEdbInfo.Update(updateCols)
  562. if err != nil {
  563. br.Msg = `指标保存失败`
  564. br.ErrMsg = `指标保存失败,ERR:` + err.Error()
  565. return
  566. }
  567. }
  568. }
  569. // 当前已经存在的指标明细数据
  570. targetDataList, tmpErr := models.GetTargetsDataList(manualEdbInfo.TradeCode)
  571. if tmpErr != nil {
  572. err = tmpErr
  573. }
  574. existDataMap := make(map[string]string)
  575. deleteDataMap := make(map[string]string)
  576. for _, tmpData := range targetDataList {
  577. existDataMap[tmpData.Dt] = tmpData.Close
  578. deleteDataMap[tmpData.Dt] = tmpData.Dt
  579. }
  580. addDataList := make([]*models.Edbdata, 0)
  581. for createDate, closeVal := range dateValueMap {
  582. if createDate == "" || closeVal == "" {
  583. continue
  584. }
  585. //判断数据是否已经存在
  586. tmpVal, ok3 := existDataMap[createDate]
  587. // 不存在,那么后面进行插入
  588. if !ok3 {
  589. addDataList = append(addDataList, &models.Edbdata{
  590. TradeCode: manualEdbInfo.TradeCode,
  591. Dt: createDate,
  592. Close: closeVal,
  593. ModifyTime: time.Now(),
  594. })
  595. continue
  596. }
  597. delete(deleteDataMap, createDate)
  598. // 库里面的数据
  599. tmpValDecimal, tmpErr := decimal.NewFromString(tmpVal)
  600. if tmpErr != nil {
  601. fmt.Println("tmpVal Parse err:", tmpErr.Error())
  602. err = tmpErr
  603. continue
  604. }
  605. // 用户填写的数据
  606. closeValDecimal, tmpErr := decimal.NewFromString(closeVal)
  607. if tmpErr != nil {
  608. fmt.Println("closeVal Parse err:", tmpErr.Error())
  609. err = tmpErr
  610. continue
  611. }
  612. if !tmpValDecimal.Equal(closeValDecimal) {
  613. isUpdateData = true
  614. fmt.Println("更新数值")
  615. err = models.ModifyTargetsDataByImport(manualEdbInfo.TradeCode, createDate, closeVal)
  616. if err != nil {
  617. fmt.Println("ModifyTargetsDataByImport err:", err.Error())
  618. errs = append(errs, err.Error())
  619. //go utils.SendEmail(utils.APPNAME+"失败提醒", "导入数据 修改数据失败:Err:"+err.Error(), utils.EmailSendToUsers)
  620. }
  621. }
  622. }
  623. // 新增指标
  624. if len(addDataList) > 0 {
  625. isUpdateData = true
  626. err = models.OnlyMultiAddEdbdata(addDataList)
  627. if err != nil {
  628. fmt.Println("MultiAddEdbdata err:", err.Error())
  629. errs = append(errs, err.Error())
  630. }
  631. }
  632. // 删除不需要的日期数据
  633. num := len(deleteDataMap)
  634. if num > 0 {
  635. isUpdateData = true
  636. deleteDateList := make([]string, 0)
  637. for date := range deleteDataMap {
  638. deleteDateList = append(deleteDateList, date)
  639. }
  640. err = models.DelEdbdataByCodeAndDateList(manualEdbInfo.TradeCode, deleteDateList)
  641. if err != nil {
  642. fmt.Println("DelEdbdataByCodeAndDateList err:", err.Error())
  643. errs = append(errs, err.Error())
  644. }
  645. }
  646. // 添加记录
  647. if isUpdateEdb {
  648. record := &models.EdbinfoOpRecord{
  649. TradeCode: manualEdbInfo.TradeCode,
  650. Remark: "编辑指标",
  651. UserId: sysUser.AdminId,
  652. UserName: sysUser.RealName,
  653. CreateTime: time.Now(),
  654. }
  655. go func() {
  656. _ = record.Create()
  657. }()
  658. }
  659. // 更新数据
  660. if isUpdateData {
  661. record := &models.EdbinfoOpRecord{
  662. TradeCode: manualEdbInfo.TradeCode,
  663. Remark: "更新数据",
  664. UserId: sysUser.AdminId,
  665. UserName: sysUser.RealName,
  666. CreateTime: time.Now(),
  667. }
  668. go func() {
  669. data.ModifyManualEdbMaxMinDate(manualEdbInfo.TradeCode)
  670. _ = record.Create()
  671. }()
  672. }
  673. //将该指标的code加入到 “手工数据导入后刷新” 缓存
  674. if utils.Re == nil {
  675. err := utils.Rc.LPush(utils.CACHE_IMPORT_MANUAL_DATA, manualEdbInfo.TradeCode)
  676. if err != nil {
  677. fmt.Println("CACHE_IMPORT_MANUAL_DATA LPush Err:" + err.Error())
  678. }
  679. }
  680. }
  681. br.Ret = 200
  682. br.Success = true
  683. br.Msg = "保存成功"
  684. }
  685. // BatchEdbList
  686. // @Title 获取研究员指标
  687. // @Description 获取研究员指标
  688. // @Param request body models.BatchAddEdbReq true "type json string"
  689. // @Success 200 {object} models.TargetItemListResp
  690. // @router /target/edb/batch/list [post]
  691. func (c *ManualEdbController) BatchEdbList() {
  692. br := new(models.BaseResponse).Init()
  693. defer func() {
  694. c.Data["json"] = br
  695. c.ServeJSON()
  696. }()
  697. sysUser := c.SysUser
  698. if sysUser == nil {
  699. br.Msg = "请重新登录"
  700. return
  701. }
  702. var req models.BatchManualEdbReq
  703. err := json.Unmarshal(c.Ctx.Input.RequestBody, &req)
  704. pageSize := req.PageSize
  705. currentIndex := req.CurrentIndex
  706. var startSize int
  707. if pageSize <= 0 {
  708. pageSize = utils.PageSize20
  709. }
  710. if currentIndex <= 0 {
  711. currentIndex = 1
  712. }
  713. startSize = utils.StartIndex(currentIndex, pageSize)
  714. req.Keyword = strings.TrimSpace(req.Keyword)
  715. var condition string
  716. var pars []interface{}
  717. // 是否加到指标库
  718. condition += ` AND a.is_join_edb = ? `
  719. pars = append(pars, 0)
  720. //超管账号可以查看分类下的所有频度数据
  721. if sysUser.RoleTypeCode != utils.ROLE_TYPE_CODE_ADMIN {
  722. classifyIdList, err := data.GetUserManualClassifyIdList(sysUser.AdminId)
  723. if err != nil {
  724. br.Msg = "获取分类数据失败"
  725. br.Msg = "获取拥有的分类数据失败,Err:" + err.Error()
  726. return
  727. }
  728. num := len(classifyIdList)
  729. if num > 0 {
  730. condition += ` AND a.classify_id in (` + utils.GetOrmInReplace(num) + `) `
  731. pars = append(pars, classifyIdList)
  732. }
  733. }
  734. // 关键词
  735. if req.Keyword != "" {
  736. condition += ` AND (a.SEC_NAME like ? or a.TRADE_CODE like ? )`
  737. pars = utils.GetLikeKeywordPars(pars, req.Keyword, 2)
  738. }
  739. // 所属分类
  740. lenFrequency := len(req.FrequencyList)
  741. if lenFrequency > 0 {
  742. condition += ` AND a.frequency in (` + utils.GetOrmInReplace(lenFrequency) + `) `
  743. pars = append(pars, req.FrequencyList)
  744. }
  745. // 所属分类
  746. lenClassify := len(req.ClassifyIdList)
  747. if lenClassify > 0 {
  748. condition += ` AND a.classify_id in (` + utils.GetOrmInReplace(lenClassify) + `) `
  749. pars = append(pars, req.ClassifyIdList)
  750. }
  751. // 所属用户
  752. lenUser := len(req.UserIdList)
  753. if lenUser > 0 {
  754. condition += ` AND a.user_id in (` + utils.GetOrmInReplace(lenUser) + `) `
  755. pars = append(pars, req.UserIdList)
  756. }
  757. total, err := models.GetCountEdbInfoList(condition, pars)
  758. if err != nil {
  759. br.Msg = "获取失败"
  760. br.ErrMsg = "获取失败,Err:" + err.Error()
  761. return
  762. }
  763. list, err := models.GetEdbInfoList(condition, pars, startSize, pageSize)
  764. if err != nil {
  765. br.Msg = "获取失败"
  766. br.ErrMsg = "获取失败,Err:" + err.Error()
  767. return
  768. }
  769. resp := models.EdbListResp{
  770. List: list,
  771. Paging: paging.GetPaging(currentIndex, pageSize, total),
  772. }
  773. br.Ret = 200
  774. br.Success = true
  775. br.Msg = "获取成功"
  776. br.Data = resp
  777. br.IsAddLog = false
  778. }
  779. // BatchAddEdbCheck
  780. // @Title 新增校验
  781. // @Description 新增校验
  782. // @Param request body data_manage.BatchManualEdbReq true "type json string"
  783. // @Success 200 string "操作成功"
  784. // @router /target/edb/batch/add/check [post]
  785. func (c *ManualEdbController) BatchAddEdbCheck() {
  786. br := new(models.BaseResponse).Init()
  787. defer func() {
  788. if br.ErrMsg == "" {
  789. br.IsSendEmail = false
  790. }
  791. c.Data["json"] = br
  792. c.ServeJSON()
  793. }()
  794. sysUser := c.SysUser
  795. if sysUser == nil {
  796. br.Msg = "请登录"
  797. br.ErrMsg = "请登录,SysUser Is Empty"
  798. br.Ret = 408
  799. return
  800. }
  801. // 最大批量添加的数量
  802. codeMax := 30
  803. var req models.BatchManualEdbReq
  804. err := json.Unmarshal(c.Ctx.Input.RequestBody, &req)
  805. req.Keyword = strings.TrimSpace(req.Keyword)
  806. var condition string
  807. var pars []interface{}
  808. //
  809. condition += ` AND a.is_join_edb = 0 `
  810. //超管账号可以查看分类下的所有频度数据
  811. if sysUser.RoleTypeCode != utils.ROLE_TYPE_CODE_ADMIN {
  812. classifyIdList, err := data.GetUserManualClassifyIdList(sysUser.AdminId)
  813. if err != nil {
  814. br.Msg = "获取分类数据失败"
  815. br.Msg = "获取拥有的分类数据失败,Err:" + err.Error()
  816. return
  817. }
  818. num := len(classifyIdList)
  819. if num > 0 {
  820. condition += ` AND a.classify_id in (` + utils.GetOrmInReplace(num) + `) `
  821. pars = append(pars, classifyIdList)
  822. }
  823. }
  824. if req.ListAll {
  825. // 关键词
  826. if req.Keyword != "" {
  827. condition += ` AND (a.SEC_NAME like ? or a.TRADE_CODE like ? )`
  828. pars = utils.GetLikeKeywordPars(pars, req.Keyword, 2)
  829. }
  830. // 所属分类
  831. lenFrequency := len(req.FrequencyList)
  832. if lenFrequency > 0 {
  833. condition += ` AND a.frequency in (` + utils.GetOrmInReplace(lenFrequency) + `) `
  834. pars = append(pars, req.FrequencyList)
  835. }
  836. // 所属分类
  837. lenClassify := len(req.ClassifyIdList)
  838. if lenClassify > 0 {
  839. condition += ` AND a.classify_id in (` + utils.GetOrmInReplace(lenClassify) + `) `
  840. pars = append(pars, req.ClassifyIdList)
  841. }
  842. // 所属用户
  843. lenUser := len(req.UserIdList)
  844. if lenUser > 0 {
  845. condition += ` AND a.user_id in (` + utils.GetOrmInReplace(lenUser) + `) `
  846. pars = append(pars, req.UserIdList)
  847. }
  848. lenTradeList := len(req.TradeCodeList)
  849. // 指标
  850. if lenTradeList > 0 {
  851. condition += ` AND a.TRADE_CODE not in (` + utils.GetOrmInReplace(lenTradeList) + `) `
  852. pars = append(pars, req.TradeCodeList)
  853. }
  854. } else {
  855. lenTradeList := len(req.TradeCodeList)
  856. if lenTradeList <= 0 {
  857. br.Msg = "请选择指标"
  858. br.ErrMsg = "请选择指标"
  859. return
  860. }
  861. // 指标
  862. if lenTradeList > 0 {
  863. condition += ` AND a.TRADE_CODE in (` + utils.GetOrmInReplace(lenTradeList) + `) `
  864. pars = append(pars, req.TradeCodeList)
  865. }
  866. }
  867. list, err := models.GetEdbInfoList(condition, pars, 0, 0)
  868. if err != nil {
  869. br.Msg = "获取失败"
  870. br.ErrMsg = "获取失败,Err:" + err.Error()
  871. return
  872. }
  873. if len(list) > codeMax {
  874. br.Msg = fmt.Sprintf("最多只能选择%d个指标", codeMax)
  875. return
  876. }
  877. br.Data = list
  878. br.Msg = "校验成功"
  879. br.Ret = 200
  880. br.Success = true
  881. }
  882. // NameCheck
  883. // @Title 重名校验
  884. // @Description 批量新增
  885. // @Param request body data_manage.AddEdbInfoReq true "type json string"
  886. // @Success 200 string "操作成功"
  887. // @router /target/edb/batch/add/name_check [post]
  888. func (c *ManualEdbController) NameCheck() {
  889. br := new(models.BaseResponse).Init()
  890. defer func() {
  891. if br.ErrMsg == "" {
  892. br.IsSendEmail = false
  893. }
  894. c.Data["json"] = br
  895. c.ServeJSON()
  896. }()
  897. sysUser := c.SysUser
  898. if sysUser == nil {
  899. br.Msg = "请登录"
  900. br.ErrMsg = "请登录,SysUser Is Empty"
  901. br.Ret = 408
  902. return
  903. }
  904. var req []*data_manage.AddEdbInfoReq
  905. if e := json.Unmarshal(c.Ctx.Input.RequestBody, &req); e != nil {
  906. br.Msg = "参数解析异常!"
  907. br.ErrMsg = "参数解析失败,Err:" + e.Error()
  908. return
  909. }
  910. if len(req) == 0 {
  911. br.Msg = "请选择指标"
  912. return
  913. }
  914. type NameCheckResult struct {
  915. EdbCode string
  916. EdbName string
  917. Exist bool
  918. }
  919. indexNames := make([]string, 0)
  920. resp := make([]*NameCheckResult, 0)
  921. for _, v := range req {
  922. v.EdbCode = strings.TrimSpace(v.EdbCode)
  923. if v.EdbCode == "" {
  924. br.Msg = "指标ID不可为空"
  925. return
  926. }
  927. v.EdbName = strings.TrimSpace(v.EdbName)
  928. if v.EdbName == "" {
  929. br.Msg = "请输入指标名称"
  930. return
  931. }
  932. indexNames = append(indexNames, v.EdbName)
  933. resp = append(resp, &NameCheckResult{
  934. EdbCode: v.EdbCode,
  935. EdbName: v.EdbName,
  936. })
  937. }
  938. // 重名校验
  939. edbList, e := data_manage.GetEdbInfoByNameArr(indexNames, utils.EDB_INFO_TYPE)
  940. if e != nil {
  941. br.Msg = "操作失败"
  942. br.ErrMsg = "获取重名指标失败, Err: " + e.Error()
  943. return
  944. }
  945. nameExists := make(map[string]bool)
  946. for _, v := range edbList {
  947. nameExists[v.EdbName] = true
  948. }
  949. if len(nameExists) > 0 {
  950. for _, v := range resp {
  951. v.Exist = nameExists[v.EdbName]
  952. }
  953. }
  954. br.Data = resp
  955. br.Msg = "操作成功"
  956. br.Ret = 200
  957. br.Success = true
  958. }
  959. // BatchAdd2Edb
  960. // @Title 批量新增到指标库
  961. // @Description 批量新增到指标库
  962. // @Param request body data_manage.AddEdbInfoReq true "type json string"
  963. // @Success 200 string "操作成功"
  964. // @router /target/edb/batch/add [post]
  965. func (c *ManualEdbController) BatchAdd2Edb() {
  966. br := new(models.BaseResponse).Init()
  967. defer func() {
  968. if br.ErrMsg == "" {
  969. br.IsSendEmail = false
  970. }
  971. c.Data["json"] = br
  972. c.ServeJSON()
  973. }()
  974. sysUser := c.SysUser
  975. if sysUser == nil {
  976. br.Msg = "请登录"
  977. br.ErrMsg = "请登录,SysUser Is Empty"
  978. br.Ret = 408
  979. return
  980. }
  981. // 最大批量添加的数量
  982. codeMax := 30
  983. deleteCache := true
  984. cacheKey := "CACHE_EDB_INFO_BATCH_ADD_MANUAL_" + strconv.Itoa(sysUser.AdminId)
  985. defer func() {
  986. if deleteCache {
  987. _ = utils.Rc.Delete(cacheKey)
  988. }
  989. }()
  990. if !utils.Rc.SetNX(cacheKey, 1, 30*time.Second) {
  991. deleteCache = false
  992. br.Msg = "系统处理中,请稍后重试!"
  993. br.ErrMsg = "系统处理中,请稍后重试!" + sysUser.RealName + ";data:" + string(c.Ctx.Input.RequestBody)
  994. return
  995. }
  996. var req []*data_manage.AddEdbInfoReq
  997. if e := json.Unmarshal(c.Ctx.Input.RequestBody, &req); e != nil {
  998. br.Msg = "参数解析异常!"
  999. br.ErrMsg = "参数解析失败,Err:" + e.Error()
  1000. return
  1001. }
  1002. if len(req) == 0 {
  1003. br.Msg = "请选择指标"
  1004. return
  1005. }
  1006. if len(req) > codeMax {
  1007. br.Msg = "批量添加指标数量不得超过30个"
  1008. return
  1009. }
  1010. indexNames := make([]string, 0)
  1011. for _, v := range req {
  1012. v.EdbCode = strings.TrimSpace(v.EdbCode)
  1013. if v.EdbCode == "" {
  1014. br.Msg = "指标ID不可为空"
  1015. return
  1016. }
  1017. v.EdbName = strings.TrimSpace(v.EdbName)
  1018. if v.EdbName == "" {
  1019. br.Msg = "请输入指标名称"
  1020. return
  1021. }
  1022. indexNames = append(indexNames, v.EdbName)
  1023. v.Frequency = strings.TrimSpace(v.Frequency)
  1024. if v.Frequency == "" {
  1025. br.Msg = "请选择频度"
  1026. return
  1027. }
  1028. v.Unit = strings.TrimSpace(v.Unit)
  1029. if v.Unit == "" {
  1030. br.Msg = "请输入单位"
  1031. return
  1032. }
  1033. if v.ClassifyId <= 0 {
  1034. br.Msg = "请选择分类"
  1035. return
  1036. }
  1037. }
  1038. // 限定同一时间最多批量新增30个指标
  1039. for _, v := range req {
  1040. var r data.ManualIndexSource2EdbReq
  1041. r.EdbCode = v.EdbCode
  1042. r.EdbName = v.EdbName
  1043. r.Frequency = v.Frequency
  1044. r.Unit = v.Unit
  1045. r.ClassifyId = v.ClassifyId
  1046. r.AdminId = sysUser.AdminId
  1047. r.AdminRealName = sysUser.RealName
  1048. edbInfo, e, errMsg, skip := data.ManualIndexSource2Edb(r, c.Lang)
  1049. if e != nil {
  1050. br.Msg = "操作失败"
  1051. if errMsg != "" {
  1052. br.Msg = errMsg
  1053. }
  1054. br.ErrMsg = e.Error()
  1055. return
  1056. }
  1057. if skip {
  1058. continue
  1059. }
  1060. // 试用平台更新用户累计新增指标数
  1061. if utils.BusinessCode == utils.BusinessCodeSandbox {
  1062. go func() {
  1063. adminItem, e := system.GetSysAdminById(sysUser.AdminId)
  1064. if e != nil {
  1065. tips := fmt.Sprintf("试用平台更新用户累计新增指标数-获取用户失败, Err: " + e.Error())
  1066. utils.FileLog.Info(tips)
  1067. return
  1068. }
  1069. if adminItem.DepartmentName != "ETA试用客户" {
  1070. return
  1071. }
  1072. var ur etaTrialService.EtaTrialUserReq
  1073. ur.Mobile = adminItem.Mobile
  1074. _, _ = etaTrialService.UpdateUserIndexNum(ur)
  1075. }()
  1076. }
  1077. // 新增操作日志
  1078. {
  1079. edbLog := new(data_manage.EdbInfoLog)
  1080. edbLog.EdbInfoId = edbInfo.EdbInfoId
  1081. edbLog.SourceName = edbInfo.SourceName
  1082. edbLog.Source = edbInfo.Source
  1083. edbLog.EdbCode = edbInfo.EdbCode
  1084. edbLog.EdbName = edbInfo.EdbName
  1085. edbLog.ClassifyId = edbInfo.ClassifyId
  1086. edbLog.SysUserId = sysUser.AdminId
  1087. edbLog.SysUserRealName = sysUser.RealName
  1088. edbLog.CreateTime = time.Now()
  1089. edbLog.Content = string(c.Ctx.Input.RequestBody)
  1090. edbLog.Status = "新增指标"
  1091. edbLog.Method = c.Ctx.Input.URI()
  1092. go data_manage.AddEdbInfoLog(edbLog)
  1093. }
  1094. }
  1095. br.Msg = "操作成功"
  1096. br.Ret = 200
  1097. br.Success = true
  1098. br.IsAddLog = true
  1099. }
  1100. // BatchDelEdbCheck
  1101. // @Title 新增校验
  1102. // @Description 新增校验
  1103. // @Param request body data_manage.BatchManualEdbReq true "type json string"
  1104. // @Success 200 string "操作成功"
  1105. // @router /target/edb/batch/del/check [post]
  1106. func (c *ManualEdbController) BatchDelEdbCheck() {
  1107. br := new(models.BaseResponse).Init()
  1108. defer func() {
  1109. if br.ErrMsg == "" {
  1110. br.IsSendEmail = false
  1111. }
  1112. c.Data["json"] = br
  1113. c.ServeJSON()
  1114. }()
  1115. sysUser := c.SysUser
  1116. if sysUser == nil {
  1117. br.Msg = "请登录"
  1118. br.ErrMsg = "请登录,SysUser Is Empty"
  1119. br.Ret = 408
  1120. return
  1121. }
  1122. var req models.BatchManualEdbReq
  1123. err := json.Unmarshal(c.Ctx.Input.RequestBody, &req)
  1124. req.Keyword = strings.TrimSpace(req.Keyword)
  1125. var condition string
  1126. var pars []interface{}
  1127. // 就是为了找出已经加入指标库的指标
  1128. condition += ` AND a.is_join_edb = ? `
  1129. pars = append(pars, 1)
  1130. //超管账号可以查看分类下的所有频度数据
  1131. if sysUser.RoleTypeCode != utils.ROLE_TYPE_CODE_ADMIN {
  1132. classifyIdList, err := data.GetUserManualClassifyIdList(sysUser.AdminId)
  1133. if err != nil {
  1134. br.Msg = "获取分类数据失败"
  1135. br.Msg = "获取拥有的分类数据失败,Err:" + err.Error()
  1136. return
  1137. }
  1138. num := len(classifyIdList)
  1139. if num > 0 {
  1140. condition += ` AND a.classify_id in (` + utils.GetOrmInReplace(num) + `) `
  1141. pars = append(pars, classifyIdList)
  1142. }
  1143. }
  1144. if req.ListAll {
  1145. // 关键词
  1146. if req.Keyword != "" {
  1147. condition += ` AND (a.SEC_NAME like ? or a.TRADE_CODE like ? )`
  1148. pars = utils.GetLikeKeywordPars(pars, req.Keyword, 2)
  1149. }
  1150. // 所属分类
  1151. lenFrequency := len(req.FrequencyList)
  1152. if lenFrequency > 0 {
  1153. condition += ` AND a.frequency in (` + utils.GetOrmInReplace(lenFrequency) + `) `
  1154. pars = append(pars, req.FrequencyList)
  1155. }
  1156. // 所属分类
  1157. lenClassify := len(req.ClassifyIdList)
  1158. if lenClassify > 0 {
  1159. condition += ` AND a.classify_id in (` + utils.GetOrmInReplace(lenClassify) + `) `
  1160. pars = append(pars, req.ClassifyIdList)
  1161. }
  1162. // 所属用户
  1163. lenUser := len(req.UserIdList)
  1164. if lenUser > 0 {
  1165. condition += ` AND a.user_id in (` + utils.GetOrmInReplace(lenUser) + `) `
  1166. pars = append(pars, req.UserIdList)
  1167. }
  1168. lenTradeList := len(req.TradeCodeList)
  1169. // 指标
  1170. if lenTradeList > 0 {
  1171. condition += ` AND a.TRADE_CODE not in (` + utils.GetOrmInReplace(lenTradeList) + `) `
  1172. pars = append(pars, req.TradeCodeList)
  1173. }
  1174. } else {
  1175. lenTradeList := len(req.TradeCodeList)
  1176. if lenTradeList <= 0 {
  1177. br.Msg = "请选择指标"
  1178. br.ErrMsg = "请选择指标"
  1179. return
  1180. }
  1181. // 指标
  1182. if lenTradeList > 0 {
  1183. condition += ` AND a.TRADE_CODE in (` + utils.GetOrmInReplace(lenTradeList) + `) `
  1184. pars = append(pars, req.TradeCodeList)
  1185. }
  1186. }
  1187. list, err := models.GetEdbInfoList(condition, pars, 0, 0)
  1188. if err != nil {
  1189. br.Msg = "获取失败"
  1190. br.ErrMsg = "获取失败,Err:" + err.Error()
  1191. return
  1192. }
  1193. br.Data = list
  1194. br.Msg = "校验成功"
  1195. br.Ret = 200
  1196. br.Success = true
  1197. }
  1198. // BatchDel
  1199. // @Title 批量删除
  1200. // @Description 批量新增
  1201. // @Param request body data_manage.AddEdbInfoReq true "type json string"
  1202. // @Success 200 string "操作成功"
  1203. // @router /target/edb/batch/del [post]
  1204. func (c *ManualEdbController) BatchDel() {
  1205. br := new(models.BaseResponse).Init()
  1206. defer func() {
  1207. if br.ErrMsg == "" {
  1208. br.IsSendEmail = false
  1209. }
  1210. c.Data["json"] = br
  1211. c.ServeJSON()
  1212. }()
  1213. sysUser := c.SysUser
  1214. if sysUser == nil {
  1215. br.Msg = "请登录"
  1216. br.ErrMsg = "请登录,SysUser Is Empty"
  1217. br.Ret = 408
  1218. return
  1219. }
  1220. deleteCache := true
  1221. cacheKey := "CACHE_EDB_INFO_BATCH_ADD_MANUAL_" + strconv.Itoa(sysUser.AdminId)
  1222. defer func() {
  1223. if deleteCache {
  1224. _ = utils.Rc.Delete(cacheKey)
  1225. }
  1226. }()
  1227. if !utils.Rc.SetNX(cacheKey, 1, 30*time.Second) {
  1228. deleteCache = false
  1229. br.Msg = "系统处理中,请稍后重试!"
  1230. br.ErrMsg = "系统处理中,请稍后重试!" + sysUser.RealName + ";data:" + string(c.Ctx.Input.RequestBody)
  1231. return
  1232. }
  1233. var req models.BatchManualEdbReq
  1234. err := json.Unmarshal(c.Ctx.Input.RequestBody, &req)
  1235. req.Keyword = strings.TrimSpace(req.Keyword)
  1236. var condition string
  1237. var pars []interface{}
  1238. // 就是为了找出已经加入指标库的指标
  1239. condition += ` AND a.is_join_edb = ? `
  1240. pars = append(pars, 0)
  1241. //超管账号可以查看分类下的所有频度数据
  1242. if sysUser.RoleTypeCode != utils.ROLE_TYPE_CODE_ADMIN {
  1243. classifyIdList, err := data.GetUserManualClassifyIdList(sysUser.AdminId)
  1244. if err != nil {
  1245. br.Msg = "获取分类数据失败"
  1246. br.Msg = "获取拥有的分类数据失败,Err:" + err.Error()
  1247. return
  1248. }
  1249. num := len(classifyIdList)
  1250. if num > 0 {
  1251. condition += ` AND a.classify_id in (` + utils.GetOrmInReplace(num) + `) `
  1252. pars = append(pars, classifyIdList)
  1253. }
  1254. }
  1255. if req.ListAll {
  1256. // 关键词
  1257. if req.Keyword != "" {
  1258. condition += ` AND (a.SEC_NAME like ? or a.TRADE_CODE like ? )`
  1259. pars = utils.GetLikeKeywordPars(pars, req.Keyword, 2)
  1260. }
  1261. // 所属分类
  1262. lenFrequency := len(req.FrequencyList)
  1263. if lenFrequency > 0 {
  1264. condition += ` AND a.frequency in (` + utils.GetOrmInReplace(lenFrequency) + `) `
  1265. pars = append(pars, req.FrequencyList)
  1266. }
  1267. // 所属分类
  1268. lenClassify := len(req.ClassifyIdList)
  1269. if lenClassify > 0 {
  1270. condition += ` AND a.classify_id in (` + utils.GetOrmInReplace(lenClassify) + `) `
  1271. pars = append(pars, req.ClassifyIdList)
  1272. }
  1273. // 所属用户
  1274. lenUser := len(req.UserIdList)
  1275. if lenUser > 0 {
  1276. condition += ` AND a.user_id in (` + utils.GetOrmInReplace(lenUser) + `) `
  1277. pars = append(pars, req.UserIdList)
  1278. }
  1279. lenTradeList := len(req.TradeCodeList)
  1280. // 指标
  1281. if lenTradeList > 0 {
  1282. condition += ` AND a.TRADE_CODE not in (` + utils.GetOrmInReplace(lenTradeList) + `) `
  1283. pars = append(pars, req.TradeCodeList)
  1284. }
  1285. } else {
  1286. lenTradeList := len(req.TradeCodeList)
  1287. if lenTradeList <= 0 {
  1288. br.Msg = "请选择指标"
  1289. br.ErrMsg = "请选择指标"
  1290. return
  1291. }
  1292. // 指标
  1293. if lenTradeList > 0 {
  1294. condition += ` AND a.TRADE_CODE in (` + utils.GetOrmInReplace(lenTradeList) + `) `
  1295. pars = append(pars, req.TradeCodeList)
  1296. }
  1297. }
  1298. list, err := models.GetEdbInfoList(condition, pars, 0, 0)
  1299. if err != nil {
  1300. br.Msg = "删除失败"
  1301. br.ErrMsg = "删除失败,Err:" + err.Error()
  1302. return
  1303. }
  1304. // TODO 二次校验指标是否已经加到指标库
  1305. {
  1306. codeList := make([]string, 0)
  1307. // 限定同一时间最多批量新增30个指标
  1308. for _, v := range list {
  1309. codeList = append(codeList, v.TradeCode)
  1310. }
  1311. err = models.DelManualIndexByCodeList(codeList)
  1312. if err != nil {
  1313. br.Msg = "删除失败"
  1314. br.ErrMsg = "删除失败,Err:" + err.Error()
  1315. return
  1316. }
  1317. }
  1318. br.Msg = "删除成功"
  1319. br.Ret = 200
  1320. br.Success = true
  1321. br.IsAddLog = true
  1322. }
  1323. // ImportData
  1324. // @Title 导入数据
  1325. // @Description 导入数据
  1326. // @Param EntryFile query file true "文件"
  1327. // @Success 200 Ret=200 录入成功
  1328. // @router /import/data [post]
  1329. func (c *ManualEdbController) ImportData() {
  1330. br := new(models.BaseResponse).Init()
  1331. defer func() {
  1332. c.Data["json"] = br
  1333. c.ServeJSON()
  1334. }()
  1335. sysUser := c.SysUser
  1336. if sysUser == nil {
  1337. br.Msg = "请重新登录"
  1338. return
  1339. }
  1340. file, _, err := c.GetFile("EntryFile")
  1341. if err != nil {
  1342. br.Msg = "获取文件失败"
  1343. br.ErrMsg = "获取文件失败,Err:" + err.Error()
  1344. return
  1345. }
  1346. path := "./static/数据导入_" + time.Now().Format(utils.FormatDateTimeUnSpace) + ".xlsx"
  1347. defer file.Close()
  1348. err = c.SaveToFile("EntryFile", path)
  1349. if err != nil {
  1350. br.Msg = "文件保存失败"
  1351. br.ErrMsg = "文件保存失败,Err:" + err.Error()
  1352. return
  1353. }
  1354. if utils.RunMode == "debug" {
  1355. defer os.Remove(path)
  1356. }
  1357. successCount, failCount, indexCount, err, errMsg := data.ImportManualData(path, sysUser)
  1358. if err != nil {
  1359. br.Msg = errMsg
  1360. br.ErrMsg = err.Error()
  1361. return
  1362. }
  1363. resp := models.EdbdataImportResp{
  1364. SuccessCount: successCount,
  1365. FailCount: failCount,
  1366. IndexCount: indexCount,
  1367. }
  1368. if failCount > 0 {
  1369. if successCount == 0 {
  1370. resp.Status = -1
  1371. resp.Msg = "导入失败"
  1372. } else {
  1373. resp.Status = 1
  1374. resp.Msg = "存在部分导入失败"
  1375. }
  1376. } else {
  1377. resp.Status = 0
  1378. }
  1379. br.Msg = "导入成功"
  1380. br.Ret = 200
  1381. br.Success = true
  1382. br.Data = resp
  1383. }
  1384. // RecordList
  1385. // @Title 获取指标操作记录列表
  1386. // @Description 获取指标操作记录列表
  1387. // @Param TradeCode query string false "指标编码"
  1388. // @Success 200 {object} models.EdbinfoOpRecordListResp
  1389. // @router /target/edb/op/record/list [get]
  1390. func (c *ManualEdbController) RecordList() {
  1391. br := new(models.BaseResponse).Init()
  1392. defer func() {
  1393. c.Data["json"] = br
  1394. c.ServeJSON()
  1395. }()
  1396. sysUser := c.SysUser
  1397. if sysUser == nil {
  1398. br.Msg = "请重新登录"
  1399. return
  1400. }
  1401. pageSize, _ := c.GetInt("PageSize")
  1402. currentIndex, _ := c.GetInt("CurrentIndex")
  1403. var startSize int
  1404. if pageSize <= 0 {
  1405. pageSize = utils.PageSize20
  1406. }
  1407. if currentIndex <= 0 {
  1408. currentIndex = 1
  1409. }
  1410. startSize = utils.StartIndex(currentIndex, pageSize)
  1411. // 频度
  1412. tradeCode := c.GetString("TradeCode")
  1413. if tradeCode == `` {
  1414. br.Msg = `请选择指标`
  1415. br.ErrMsg = `请选择指标`
  1416. br.IsSendEmail = false
  1417. return
  1418. }
  1419. total, list, err := models.GetEdbinfoOpRecordPageList(tradeCode, startSize, pageSize)
  1420. if err != nil {
  1421. br.Msg = "获取失败"
  1422. br.ErrMsg = "获取失败,Err:" + err.Error()
  1423. return
  1424. }
  1425. resp := models.EdbinfoOpRecordListResp{
  1426. List: list,
  1427. Paging: paging.GetPaging(currentIndex, pageSize, total),
  1428. }
  1429. br.Ret = 200
  1430. br.Success = true
  1431. br.Msg = "获取成功"
  1432. br.Data = resp
  1433. }