my_chart.go 73 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515
  1. package data_manage
  2. import (
  3. "encoding/json"
  4. "eta/eta_mobile/controllers"
  5. "eta/eta_mobile/models"
  6. "eta/eta_mobile/models/data_manage"
  7. "eta/eta_mobile/models/system"
  8. "eta/eta_mobile/services/data"
  9. "eta/eta_mobile/services/data/data_manage_permission"
  10. "eta/eta_mobile/utils"
  11. "fmt"
  12. "github.com/rdlucklib/rdluck_tools/paging"
  13. "strconv"
  14. "strings"
  15. "time"
  16. )
  17. // 我的图库
  18. type MyChartController struct {
  19. controllers.BaseAuthController
  20. }
  21. // @Title ETA图表列表接口
  22. // @Description ETA图表列表接口
  23. // @Param PageSize query int true "每页数据条数"
  24. // @Param CurrentIndex query int true "当前页页码,从1开始"
  25. // @Param ChartClassifyId query int true "分类id"
  26. // @Param KeyWord query string true "搜索关键词"
  27. // @Param IsShowMe query bool true "是否只看我的,true、false"
  28. // @Success 200 {object} data_manage.ChartListResp
  29. // @router /chart/list [get]
  30. func (this *MyChartController) ChartList() {
  31. br := new(models.BaseResponse).Init()
  32. defer func() {
  33. this.Data["json"] = br
  34. this.ServeJSON()
  35. }()
  36. sysUser := this.SysUser
  37. if sysUser == nil {
  38. br.Msg = "请登录"
  39. br.ErrMsg = "请登录,SysUser Is Empty"
  40. br.Ret = 408
  41. return
  42. }
  43. chartClassifyId, _ := this.GetInt("ChartClassifyId")
  44. pageSize, _ := this.GetInt("PageSize")
  45. currentIndex, _ := this.GetInt("CurrentIndex")
  46. keyWord := this.GetString("KeyWord")
  47. var total int
  48. page := paging.GetPaging(currentIndex, pageSize, total)
  49. var startSize int
  50. if pageSize <= 0 {
  51. pageSize = utils.PageSize20
  52. }
  53. if currentIndex <= 0 {
  54. currentIndex = 1
  55. }
  56. startSize = paging.StartIndex(currentIndex, pageSize)
  57. var condition string
  58. var pars []interface{}
  59. // 普通图表
  60. condition += ` AND source = ? `
  61. pars = append(pars, utils.CHART_SOURCE_DEFAULT)
  62. if chartClassifyId > 0 {
  63. chartClassifyId, err := data_manage.GetChartClassify(chartClassifyId)
  64. if err != nil && err.Error() != utils.ErrNoRow() {
  65. br.Msg = "获取图表信息失败"
  66. br.ErrMsg = "获取信息失败,GetChartClassify,Err:" + err.Error()
  67. return
  68. }
  69. condition += " AND chart_classify_id IN(" + chartClassifyId + ") "
  70. //pars = append(pars, chartClassifyId)
  71. }
  72. if keyWord != "" {
  73. condition += ` AND ( chart_name LIKE '%` + keyWord + `%' OR chart_name_en LIKE '%` + keyWord + `%' )`
  74. }
  75. //只看我的
  76. isShowMe, _ := this.GetBool("IsShowMe")
  77. if isShowMe {
  78. condition += ` AND sys_user_id = ? `
  79. pars = append(pars, sysUser.AdminId)
  80. }
  81. // 获取当前账号的不可见指标
  82. noPermissionChartIdList := make([]int, 0)
  83. {
  84. obj := data_manage.EdbInfoNoPermissionAdmin{}
  85. confList, err := obj.GetAllChartListByAdminId(this.SysUser.AdminId)
  86. if err != nil && err.Error() != utils.ErrNoRow() {
  87. br.Msg = "获取失败"
  88. br.ErrMsg = "获取不可见指标配置数据失败,Err:" + err.Error()
  89. return
  90. }
  91. for _, v := range confList {
  92. noPermissionChartIdList = append(noPermissionChartIdList, v.ChartInfoId)
  93. }
  94. }
  95. lenNoPermissionChartIdList := len(noPermissionChartIdList)
  96. if lenNoPermissionChartIdList > 0 {
  97. condition += ` AND chart_info_id not in (` + utils.GetOrmInReplace(lenNoPermissionChartIdList) + `) `
  98. pars = append(pars, noPermissionChartIdList)
  99. }
  100. //获取图表信息
  101. list, err := data_manage.GetChartListByCondition(condition, pars, startSize, pageSize)
  102. if err != nil && err.Error() != utils.ErrNoRow() {
  103. br.Success = true
  104. br.Msg = "获取图表信息失败"
  105. br.ErrMsg = "获取图表信息失败,Err:" + err.Error()
  106. return
  107. }
  108. myChartList, err := data_manage.GetMyChartListByAdminId(sysUser.AdminId)
  109. if err != nil && err.Error() != utils.ErrNoRow() {
  110. br.Msg = "获取图表信息失败"
  111. br.ErrMsg = "获取我的图表信息失败,Err:" + err.Error()
  112. return
  113. }
  114. myChartMap := make(map[int]*data_manage.MyChartView)
  115. for _, v := range myChartList {
  116. myChartMap[v.ChartInfoId] = v
  117. }
  118. listLen := len(list)
  119. chartEdbMap := make(map[int][]*data_manage.ChartEdbInfoMapping)
  120. if listLen > 0 {
  121. // 分类id
  122. classifyIdList := make([]int, 0)
  123. // 当前列表中的分类map
  124. classifyMap := make(map[int]*data_manage.ChartClassify)
  125. for _, v := range list {
  126. classifyIdList = append(classifyIdList, v.ChartClassifyId)
  127. }
  128. classifyList, err := data_manage.GetChartClassifyByIdList(classifyIdList)
  129. if err != nil {
  130. br.Msg = "获取失败"
  131. br.ErrMsg = "获取分类列表失败,Err:" + err.Error()
  132. return
  133. }
  134. for _, v := range classifyList {
  135. classifyMap[v.ChartClassifyId] = v
  136. }
  137. // 已授权分类id
  138. permissionChartIdList, permissionClassifyIdList, err := data_manage_permission.GetUserChartAndClassifyPermissionList(this.SysUser.AdminId, 0, 0)
  139. if err != nil {
  140. br.Msg = "获取失败"
  141. br.ErrMsg = "获取已授权分类id数据失败,Err:" + err.Error()
  142. return
  143. }
  144. // 权限
  145. for k, chartViewInfo := range list {
  146. if currClassify, ok := classifyMap[chartViewInfo.ChartClassifyId]; ok {
  147. list[k].HaveOperaAuth = data_manage_permission.CheckChartPermissionByPermissionIdList(chartViewInfo.IsJoinPermission, currClassify.IsJoinPermission, chartViewInfo.ChartInfoId, chartViewInfo.ChartClassifyId, permissionChartIdList, permissionClassifyIdList)
  148. }
  149. }
  150. chartInfoIds := ""
  151. for _, v := range list {
  152. chartInfoIds += strconv.Itoa(v.ChartInfoId) + ","
  153. }
  154. if chartInfoIds != "" {
  155. chartInfoIds = strings.Trim(chartInfoIds, ",")
  156. //判断是否需要展示英文标识
  157. edbList, e := data_manage.GetChartEdbMappingListByChartInfoIds(chartInfoIds)
  158. if e != nil {
  159. br.Msg = "获取失败"
  160. br.ErrMsg = "获取图表,指标信息失败,Err:" + e.Error()
  161. return
  162. }
  163. for _, v := range edbList {
  164. chartEdbMap[v.ChartInfoId] = append(chartEdbMap[v.ChartInfoId], v)
  165. }
  166. }
  167. }
  168. for i := 0; i < listLen; i++ {
  169. //判断是否需要展示英文标识
  170. if edbTmpList, ok := chartEdbMap[list[i].ChartInfoId]; ok {
  171. list[i].IsEnChart = data.CheckIsEnChart(list[i].ChartNameEn, edbTmpList, list[i].Source, list[i].ChartType)
  172. }
  173. if existItem, ok := myChartMap[list[i].ChartInfoId]; ok {
  174. list[i].IsAdd = true
  175. list[i].MyChartId = existItem.MyChartId
  176. list[i].MyChartClassifyId = existItem.MyChartClassifyId
  177. }
  178. }
  179. resp := new(data_manage.ChartListResp)
  180. if list == nil || len(list) <= 0 || (err != nil && err.Error() == utils.ErrNoRow()) {
  181. items := make([]*data_manage.ChartInfoView, 0)
  182. resp.Paging = page
  183. resp.List = items
  184. br.Ret = 200
  185. br.Success = true
  186. br.Msg = "获取成功"
  187. return
  188. }
  189. dataCount, err := data_manage.GetChartListCountByCondition(condition, pars)
  190. if err != nil && err.Error() != utils.ErrNoRow() {
  191. br.Msg = "获取指标信息失败"
  192. br.ErrMsg = "获取指标数据总数失败,Err:" + err.Error()
  193. return
  194. }
  195. page = paging.GetPaging(currentIndex, pageSize, dataCount)
  196. resp.Paging = page
  197. resp.List = list
  198. br.Ret = 200
  199. br.Success = true
  200. br.Msg = "获取成功"
  201. br.Data = resp
  202. }
  203. // ClassifyList
  204. // @Title 我的图表-分类列表接口
  205. // @Description 我的图表-分类列表接口
  206. // @Success 200 {object} data_manage.MyChartClassifyResp
  207. // @router /classify/list [get]
  208. func (this *MyChartController) ClassifyList() {
  209. br := new(models.BaseResponse).Init()
  210. defer func() {
  211. this.Data["json"] = br
  212. this.ServeJSON()
  213. }()
  214. sysUser := this.SysUser
  215. if sysUser == nil {
  216. br.Msg = "请登录"
  217. br.ErrMsg = "请登录,SysUser Is Empty"
  218. br.Ret = 408
  219. return
  220. }
  221. //获取图表信息
  222. list, err := data_manage.GetMyChartClassifyAll(sysUser.AdminId)
  223. if err != nil && err.Error() != utils.ErrNoRow() {
  224. br.Success = true
  225. br.Msg = "获取分类信息失败"
  226. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  227. return
  228. }
  229. resp := new(data_manage.MyChartClassifyResp)
  230. if list == nil || len(list) <= 0 || (err != nil && err.Error() == utils.ErrNoRow()) {
  231. items := make([]*data_manage.MyChartClassifyItem, 0)
  232. resp.List = items
  233. br.Ret = 200
  234. br.Success = true
  235. br.Msg = "获取成功"
  236. return
  237. }
  238. //resp.List = list
  239. // 获取图表分类下各自的图表数
  240. chartsNumMap, e := data.GetMyChartClassifyIdNumMap(sysUser.AdminId)
  241. if e != nil {
  242. br.Msg = "获取失败"
  243. br.ErrMsg = "获取失败, GetMyChartClassifyIdNumMap Err: " + e.Error()
  244. return
  245. }
  246. results := make([]*data_manage.MyChartClassifyItem, 0)
  247. for _, v := range list {
  248. results = append(results, data_manage.FormatMyChartClassify2Item(v, chartsNumMap[v.MyChartClassifyId]))
  249. }
  250. resp.List = results
  251. language := `CN`
  252. // 指标显示的语言
  253. {
  254. configDetail, _ := system.GetConfigDetailByCode(this.SysUser.AdminId, system.ChartLanguageVar)
  255. if configDetail != nil {
  256. language = configDetail.ConfigValue
  257. } else {
  258. configDetail, _ = system.GetDefaultConfigDetailByCode(system.ChartLanguageVar)
  259. if configDetail != nil {
  260. language = configDetail.ConfigValue
  261. }
  262. }
  263. }
  264. resp.Language = language
  265. br.Ret = 200
  266. br.Success = true
  267. br.Msg = "获取成功"
  268. br.Data = resp
  269. }
  270. // @Title 新增我的图表分类
  271. // @Description 新增我的图表接口
  272. // @Param request body data_manage.MyChartClassifyAddReq true "type json string"
  273. // @Success 200 Ret=200 保存成功
  274. // @router /classify/add [post]
  275. func (this *MyChartController) ClassifyAdd() {
  276. br := new(models.BaseResponse).Init()
  277. defer func() {
  278. this.Data["json"] = br
  279. this.ServeJSON()
  280. }()
  281. sysUser := this.SysUser
  282. if sysUser == nil {
  283. br.Msg = "请登录"
  284. br.ErrMsg = "请登录,SysUser Is Empty"
  285. br.Ret = 408
  286. return
  287. }
  288. var req data_manage.MyChartClassifyAddReq
  289. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  290. if err != nil {
  291. br.Msg = "参数解析异常!"
  292. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  293. return
  294. }
  295. if req.MyChartClassifyName == "" {
  296. br.Msg = "请输入分类名称"
  297. br.IsSendEmail = false
  298. return
  299. }
  300. var condition string
  301. var pars []interface{}
  302. condition += " AND admin_id=? "
  303. pars = append(pars, sysUser.AdminId)
  304. condition += " AND my_chart_classify_name=? "
  305. pars = append(pars, req.MyChartClassifyName)
  306. count, err := data_manage.GetMyChartClassifyCountByCondition(condition, pars)
  307. if err != nil {
  308. br.Msg = "保存失败"
  309. br.ErrMsg = "保存失败,校验名称是否存在失败,Err:" + err.Error()
  310. return
  311. }
  312. if count > 0 {
  313. br.Msg = "分类已存在,请重新输入"
  314. br.IsSendEmail = false
  315. return
  316. }
  317. // 获取我的图库分类的最大排序值
  318. sort, err := data_manage.GetMyChartClassifyMinSort(sysUser.AdminId)
  319. if err != nil {
  320. br.Msg = "保存失败"
  321. br.ErrMsg = "保存失败,获取最大排序失败,Err:" + err.Error()
  322. return
  323. }
  324. item := new(data_manage.MyChartClassify)
  325. item.AdminId = sysUser.AdminId
  326. item.MyChartClassifyName = req.MyChartClassifyName
  327. item.Sort = sort - 1
  328. item.ModifyTime = time.Now()
  329. item.CreateTime = time.Now()
  330. err = data_manage.AddMyChartClassify(item)
  331. if err != nil {
  332. br.Msg = "保存失败"
  333. br.ErrMsg = "保存失败,Err:" + err.Error()
  334. return
  335. }
  336. //新增操作日志
  337. {
  338. edbLog := new(data_manage.MyChartLog)
  339. edbLog.MyChartId = 0
  340. edbLog.ChartInfoId = 0
  341. edbLog.SysUserId = sysUser.AdminId
  342. edbLog.SysUserRealName = sysUser.RealName
  343. edbLog.CreateTime = time.Now()
  344. edbLog.Content = string(this.Ctx.Input.RequestBody)
  345. edbLog.Status = "新增分类"
  346. edbLog.Method = this.Ctx.Input.URI()
  347. go data_manage.AddMyChartLog(edbLog)
  348. }
  349. br.Ret = 200
  350. br.Msg = "保存成功"
  351. br.Success = true
  352. br.IsAddLog = true
  353. }
  354. // @Title 编辑我的图表分类
  355. // @Description 编辑我的图表接口
  356. // @Param request body data_manage.MyChartClassifyEditReq true "type json string"
  357. // @Success 200 Ret=200 保存成功
  358. // @router /classify/edit [post]
  359. func (this *MyChartController) ClassifyEdit() {
  360. br := new(models.BaseResponse).Init()
  361. defer func() {
  362. this.Data["json"] = br
  363. this.ServeJSON()
  364. }()
  365. sysUser := this.SysUser
  366. if sysUser == nil {
  367. br.Msg = "请登录"
  368. br.ErrMsg = "请登录,SysUser Is Empty"
  369. br.Ret = 408
  370. return
  371. }
  372. var req data_manage.MyChartClassifyEditReq
  373. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  374. if err != nil {
  375. br.Msg = "参数解析异常!"
  376. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  377. return
  378. }
  379. if req.MyChartClassifyName == "" {
  380. br.Msg = "请输入分类名称"
  381. br.IsSendEmail = false
  382. return
  383. }
  384. item, err := data_manage.GetMyChartClassifyById(sysUser.AdminId, req.MyChartClassifyId)
  385. if err != nil && err.Error() != utils.ErrNoRow() {
  386. br.Msg = "保存失败"
  387. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  388. return
  389. }
  390. if item == nil {
  391. br.Msg = "分类不存在"
  392. br.ErrMsg = "分类不存在,Err:" + err.Error()
  393. return
  394. }
  395. var condition string
  396. var pars []interface{}
  397. condition += " AND admin_id=? "
  398. pars = append(pars, sysUser.AdminId)
  399. condition += " AND my_chart_classify_name=? "
  400. pars = append(pars, req.MyChartClassifyName)
  401. condition += " AND my_chart_classify_id<>? "
  402. pars = append(pars, req.MyChartClassifyId)
  403. //判断名称是否已经存在
  404. count, err := data_manage.GetMyChartClassifyCountByCondition(condition, pars)
  405. if err != nil {
  406. br.Msg = "保存失败"
  407. br.ErrMsg = "保存失败,校验名称是否存在失败,Err:" + err.Error()
  408. return
  409. }
  410. if count > 0 {
  411. br.Msg = "分类已存在,请重新输入"
  412. br.IsSendEmail = false
  413. return
  414. }
  415. err = data_manage.ModifyMyChartClassify(req.MyChartClassifyId, req.MyChartClassifyName)
  416. if err != nil {
  417. br.Msg = "保存失败"
  418. br.ErrMsg = "保存失败,Err:" + err.Error()
  419. return
  420. }
  421. //新增操作日志
  422. {
  423. edbLog := new(data_manage.MyChartLog)
  424. edbLog.MyChartId = 0
  425. edbLog.ChartInfoId = 0
  426. edbLog.SysUserId = sysUser.AdminId
  427. edbLog.SysUserRealName = sysUser.RealName
  428. edbLog.CreateTime = time.Now()
  429. edbLog.Content = string(this.Ctx.Input.RequestBody)
  430. edbLog.Status = "编辑分类"
  431. edbLog.Method = this.Ctx.Input.URI()
  432. go data_manage.AddMyChartLog(edbLog)
  433. }
  434. br.Ret = 200
  435. br.Msg = "保存成功"
  436. br.Success = true
  437. br.IsAddLog = true
  438. }
  439. // ClassifyMove
  440. // @Title 移动我的图表分类
  441. // @Description 移动我的图表分类接口
  442. // @Param request body data_manage.MyChartClassifyMoveReq true "type json string"
  443. // @Success 200 Ret=200 移动成功
  444. // @router /classify/move [post]
  445. func (this *MyChartController) ClassifyMove() {
  446. br := new(models.BaseResponse).Init()
  447. defer func() {
  448. this.Data["json"] = br
  449. this.ServeJSON()
  450. }()
  451. sysUser := this.SysUser
  452. if sysUser == nil {
  453. br.Msg = "请登录"
  454. br.ErrMsg = "请登录,SysUser Is Empty"
  455. br.Ret = 408
  456. return
  457. }
  458. var req data_manage.MyChartClassifyMoveReq
  459. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  460. if err != nil {
  461. br.Msg = "参数解析异常!"
  462. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  463. return
  464. }
  465. //查询该分类存不存在
  466. item, err := data_manage.GetMyChartClassifyById(sysUser.AdminId, req.MyChartClassifyId)
  467. if err != nil && err.Error() != utils.ErrNoRow() {
  468. br.Msg = "移动失败,找不到该分类"
  469. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  470. return
  471. }
  472. if item == nil {
  473. br.Msg = "分类不存在"
  474. br.ErrMsg = "分类不存在,Err:" + err.Error()
  475. return
  476. }
  477. updateCol := make([]string, 0)
  478. //如果有传入 上一个兄弟节点分类id
  479. if req.PrevClassifyId > 0 {
  480. prevClassify, err := data_manage.GetMyChartClassifyById(sysUser.AdminId, req.PrevClassifyId)
  481. if err != nil {
  482. br.Msg = "移动失败"
  483. br.ErrMsg = "获取上一个兄弟节点分类信息失败,Err:" + err.Error()
  484. return
  485. }
  486. //如果是移动在两个兄弟节点之间
  487. if req.NextClassifyId > 0 {
  488. //下一个兄弟节点
  489. nextClassify, err := data_manage.GetMyChartClassifyById(sysUser.AdminId, req.NextClassifyId)
  490. if err != nil {
  491. br.Msg = "移动失败"
  492. br.ErrMsg = "获取下一个兄弟节点分类信息失败,Err:" + err.Error()
  493. return
  494. }
  495. //如果上一个兄弟与下一个兄弟的排序权重是一致的,那么需要将下一个兄弟(以及下个兄弟的同样排序权重)的排序权重+2,自己变成上一个兄弟的排序权重+1
  496. if prevClassify.Sort == nextClassify.Sort || prevClassify.Sort == item.Sort {
  497. //变更兄弟节点的排序
  498. updateSortStr := `sort + 2`
  499. _ = data_manage.UpdateMyChartClassifySortByClassifyId(sysUser.AdminId, prevClassify.MyChartClassifyId, prevClassify.Sort, updateSortStr)
  500. } else {
  501. //如果下一个兄弟的排序权重正好是上个兄弟节点的下一层,那么需要再加一层了
  502. if nextClassify.Sort-prevClassify.Sort == 1 {
  503. //变更兄弟节点的排序
  504. updateSortStr := `sort + 1`
  505. _ = data_manage.UpdateMyChartClassifySortByClassifyId(sysUser.AdminId, 0, prevClassify.Sort, updateSortStr)
  506. }
  507. }
  508. }
  509. item.Sort = prevClassify.Sort + 1
  510. item.ModifyTime = time.Now()
  511. updateCol = append(updateCol, "Sort", "ModifyTime")
  512. } else {
  513. firstClassify, err := data_manage.GetFirstMyChartClassifyByAdminId(sysUser.AdminId)
  514. if err != nil && err.Error() != utils.ErrNoRow() {
  515. br.Msg = "移动失败"
  516. br.ErrMsg = "获取获取当前账号下的排序第一条的分类信息失败,Err:" + err.Error()
  517. return
  518. }
  519. //如果该分类下存在其他分类,且第一个其他分类的排序等于0,那么需要调整排序
  520. if firstClassify != nil && firstClassify.Sort == 0 {
  521. updateSortStr := ` sort + 1 `
  522. _ = data_manage.UpdateMyChartClassifySortByClassifyId(sysUser.AdminId, firstClassify.MyChartClassifyId-1, 0, updateSortStr)
  523. }
  524. item.Sort = 0 //那就是排在第一位
  525. item.ModifyTime = time.Now()
  526. updateCol = append(updateCol, "Sort", "ModifyTime")
  527. }
  528. //更新
  529. if len(updateCol) > 0 {
  530. err = item.Update(updateCol)
  531. if err != nil {
  532. br.Msg = "移动失败"
  533. br.ErrMsg = "修改失败,Err:" + err.Error()
  534. return
  535. }
  536. }
  537. //新增操作日志
  538. {
  539. edbLog := new(data_manage.MyChartLog)
  540. edbLog.MyChartId = 0
  541. edbLog.ChartInfoId = 0
  542. edbLog.SysUserId = sysUser.AdminId
  543. edbLog.SysUserRealName = sysUser.RealName
  544. edbLog.CreateTime = time.Now()
  545. edbLog.Content = string(this.Ctx.Input.RequestBody)
  546. edbLog.Status = "移动分类"
  547. edbLog.Method = this.Ctx.Input.URI()
  548. go data_manage.AddMyChartLog(edbLog)
  549. }
  550. br.Ret = 200
  551. br.Msg = "保存成功"
  552. br.Success = true
  553. br.IsAddLog = true
  554. }
  555. // @Title 删除我的图表分类
  556. // @Description 删除我的图表接口
  557. // @Param request body data_manage.MyChartClassifyDeleteReq true "type json string"
  558. // @Success 200 Ret=200 保存成功
  559. // @router /classify/delete [post]
  560. func (this *MyChartController) ClassifyDelete() {
  561. br := new(models.BaseResponse).Init()
  562. defer func() {
  563. this.Data["json"] = br
  564. this.ServeJSON()
  565. }()
  566. sysUser := this.SysUser
  567. if sysUser == nil {
  568. br.Msg = "请登录"
  569. br.ErrMsg = "请登录,SysUser Is Empty"
  570. br.Ret = 408
  571. return
  572. }
  573. var req data_manage.MyChartClassifyDeleteReq
  574. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  575. if err != nil {
  576. br.Msg = "参数解析异常!"
  577. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  578. return
  579. }
  580. item, err := data_manage.GetMyChartClassifyById(sysUser.AdminId, req.MyChartClassifyId)
  581. if err != nil && err.Error() != utils.ErrNoRow() {
  582. br.Msg = "保存失败"
  583. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  584. return
  585. }
  586. if item == nil {
  587. br.Msg = "分类已被删除"
  588. br.ErrMsg = "分类已被删除,Err:" + err.Error()
  589. return
  590. }
  591. nodeOb := new(data_manage.ChartFrameworkNode)
  592. cond := ` AND my_chart_classify_id = ?`
  593. pars := make([]interface{}, 0)
  594. pars = append(pars, req.MyChartClassifyId)
  595. nodes, e := nodeOb.GetItemsByCondition(cond, pars, []string{}, "")
  596. if e != nil {
  597. br.Msg = "获取失败"
  598. br.ErrMsg = "获取我的图表分类关联的框架节点失败, Err: " + e.Error()
  599. return
  600. }
  601. if len(nodes) > 0 {
  602. br.Msg = "该图分类已添加节点链接, 不允许删除"
  603. return
  604. }
  605. //var condition string
  606. //var pars []interface{}
  607. //
  608. //condition += " AND admin_id=? "
  609. //pars = append(pars, sysUser.AdminId)
  610. //
  611. //condition += " AND my_chart_classify_id=? "
  612. //pars = append(pars, req.MyChartClassifyId)
  613. ////判断是否包含图表
  614. //count, err := data_manage.GetMyChartClassifyMappingCountByCondition(condition, pars)
  615. //if err != nil {
  616. // br.Msg = "保存失败"
  617. // br.ErrMsg = "保存失败,校验名称是否存在失败,Err:" + err.Error()
  618. // return
  619. //}
  620. //if count > 0 {
  621. // br.Msg = "此分类下含有图表,不可删除"
  622. // br.IsSendEmail = false
  623. // return
  624. //}
  625. err = data_manage.DeleteMyChartClassify(req.MyChartClassifyId)
  626. if err != nil {
  627. br.Msg = "删除失败"
  628. br.ErrMsg = "删除失败,Err:" + err.Error()
  629. return
  630. }
  631. //新增操作日志
  632. {
  633. edbLog := new(data_manage.MyChartLog)
  634. edbLog.MyChartId = 0
  635. edbLog.ChartInfoId = 0
  636. edbLog.SysUserId = sysUser.AdminId
  637. edbLog.SysUserRealName = sysUser.RealName
  638. edbLog.CreateTime = time.Now()
  639. edbLog.Content = string(this.Ctx.Input.RequestBody)
  640. edbLog.Status = "删除分类"
  641. edbLog.Method = this.Ctx.Input.URI()
  642. go data_manage.AddMyChartLog(edbLog)
  643. }
  644. br.Ret = 200
  645. br.Msg = "删除成功"
  646. br.Success = true
  647. br.IsAddLog = true
  648. }
  649. // @Title 新增我的图表
  650. // @Description 新增我的图表接口
  651. // @Param request body data_manage.MyChartAddReq true "type json string"
  652. // @Success 200 Ret=200 保存成功
  653. // @router /add [post]
  654. func (this *MyChartController) MyChartAdd() {
  655. br := new(models.BaseResponse).Init()
  656. defer func() {
  657. this.Data["json"] = br
  658. this.ServeJSON()
  659. }()
  660. sysUser := this.SysUser
  661. if sysUser == nil {
  662. br.Msg = "请登录"
  663. br.ErrMsg = "请登录,SysUser Is Empty"
  664. br.Ret = 408
  665. return
  666. }
  667. var req data_manage.MyChartAddReq
  668. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  669. if err != nil {
  670. br.Msg = "参数解析异常!"
  671. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  672. return
  673. }
  674. chartItem, err := data_manage.GetChartInfoById(req.ChartInfoId)
  675. if err != nil && err.Error() != utils.ErrNoRow() {
  676. br.Msg = "获取图表信息失败!"
  677. br.ErrMsg = "获取图表信息失败,Err:" + err.Error()
  678. return
  679. }
  680. if chartItem == nil {
  681. br.Msg = "此图表已被删除!"
  682. br.ErrMsg = "此图表已被删除,ChartInfoId:" + strconv.Itoa(req.ChartInfoId)
  683. return
  684. }
  685. var condition string
  686. var pars []interface{}
  687. condition += " AND admin_id=? "
  688. pars = append(pars, sysUser.AdminId)
  689. condition += " AND chart_info_id=? "
  690. pars = append(pars, req.ChartInfoId)
  691. existItem, err := data_manage.GetMyChartDetailByCondition(condition, pars)
  692. if err != nil && err.Error() != utils.ErrNoRow() {
  693. br.Msg = "保存失败"
  694. br.ErrMsg = "保存失败,校验名称是否存在失败,Err:" + err.Error()
  695. return
  696. }
  697. resp := new(data_manage.MyChartAddResp)
  698. var myChartClassifyId string
  699. if existItem != nil { //修改
  700. fmt.Println("modify")
  701. for _, v := range req.MyChartClassifyId {
  702. myChartClassifyId += strconv.Itoa(v) + ","
  703. }
  704. resp.MyChartInfoId = existItem.MyChartId
  705. err = data_manage.MoveMyChartClassify(sysUser.AdminId, existItem.MyChartId, req.MyChartClassifyId)
  706. if err != nil {
  707. br.Msg = "保存失败"
  708. br.ErrMsg = "保存我的图表失败,MoveMyChartClassify,Err:" + err.Error()
  709. return
  710. }
  711. } else {
  712. myChart := &data_manage.MyChart{
  713. //MyChartId: 0,
  714. ChartInfoId: chartItem.ChartInfoId,
  715. Source: chartItem.Source,
  716. AdminId: sysUser.AdminId,
  717. CreateTime: time.Now(),
  718. ModifyTime: time.Now(),
  719. }
  720. newMyChartId, err := data_manage.AddMyChart(myChart)
  721. if err != nil {
  722. br.Msg = "保存失败"
  723. br.ErrMsg = "保存我的图表失败,Err:" + err.Error()
  724. return
  725. }
  726. //step := float64(65536)
  727. for _, v := range req.MyChartClassifyId {
  728. var sort float64
  729. // 查找最小排序值
  730. firstMapItem, _ := data_manage.GetMyChartSort(sysUser.AdminId, v, 0)
  731. if firstMapItem != nil {
  732. sort = firstMapItem.Sort
  733. }
  734. //获取最大的排序字段
  735. //count, _ := data_manage.GetMyChartMaxSort(sysUser.AdminId, v)
  736. mappingItem := new(data_manage.MyChartClassifyMapping)
  737. mappingItem.AdminId = sysUser.AdminId
  738. mappingItem.MyChartId = int(newMyChartId)
  739. mappingItem.MyChartClassifyId = v
  740. mappingItem.CreateTime = time.Now()
  741. mappingItem.ModifyTime = time.Now()
  742. //mappingItem.Sort = (float64(count) + 1) * step
  743. mappingItem.Sort = sort
  744. _, err = data_manage.AddMyChartClassifyMapping(mappingItem)
  745. if err != nil {
  746. br.Msg = "保存失败"
  747. br.ErrMsg = "保存我的图表AddMyChartClassifyMapping失败,Err:" + err.Error()
  748. return
  749. }
  750. myChartClassifyId += strconv.Itoa(v) + ","
  751. }
  752. //新增操作日志
  753. {
  754. edbLog := new(data_manage.MyChartLog)
  755. edbLog.MyChartId = myChart.MyChartId
  756. edbLog.ChartInfoId = myChart.ChartInfoId
  757. edbLog.SysUserId = sysUser.AdminId
  758. edbLog.SysUserRealName = sysUser.RealName
  759. edbLog.CreateTime = time.Now()
  760. edbLog.Content = string(this.Ctx.Input.RequestBody)
  761. edbLog.Status = "新增我的图表"
  762. edbLog.Method = this.Ctx.Input.URI()
  763. go data_manage.AddMyChartLog(edbLog)
  764. }
  765. resp.MyChartInfoId = int(newMyChartId)
  766. }
  767. resp.MyChartClassifyId = strings.Trim(myChartClassifyId, ",")
  768. //更新es
  769. if resp.MyChartInfoId > 0 {
  770. go data.EsAddOrEditMyChartInfoByMyChartId(resp.MyChartInfoId)
  771. }
  772. br.Ret = 200
  773. br.Msg = "保存成功"
  774. br.Success = true
  775. br.Data = resp
  776. br.IsAddLog = true
  777. }
  778. // MyChartAddToClassify
  779. // @Title 将图表加入到我的图表分类
  780. // @Description 新增我的图表接口
  781. // @Param request body data_manage.MyChartAddReq true "type json string"
  782. // @Success 200 Ret=200 保存成功
  783. // @router /add_to_classify [post]
  784. func (this *MyChartController) MyChartAddToClassify() {
  785. br := new(models.BaseResponse).Init()
  786. defer func() {
  787. this.Data["json"] = br
  788. this.ServeJSON()
  789. }()
  790. sysUser := this.SysUser
  791. if sysUser == nil {
  792. br.Msg = "请登录"
  793. br.ErrMsg = "请登录,SysUser Is Empty"
  794. br.Ret = 408
  795. return
  796. }
  797. var req data_manage.MyChartAddReq
  798. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  799. if err != nil {
  800. br.Msg = "参数解析异常!"
  801. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  802. return
  803. }
  804. chartItem, err := data_manage.GetChartInfoById(req.ChartInfoId)
  805. if err != nil && err.Error() != utils.ErrNoRow() {
  806. br.Msg = "获取图表信息失败!"
  807. br.ErrMsg = "获取图表信息失败,Err:" + err.Error()
  808. return
  809. }
  810. if chartItem == nil {
  811. br.Msg = "此图表已被删除!"
  812. br.ErrMsg = "此图表已被删除,ChartInfoId:" + strconv.Itoa(req.ChartInfoId)
  813. return
  814. }
  815. var condition string
  816. var pars []interface{}
  817. condition += " AND admin_id=? "
  818. pars = append(pars, sysUser.AdminId)
  819. condition += " AND chart_info_id=? "
  820. pars = append(pars, req.ChartInfoId)
  821. existItem, err := data_manage.GetMyChartDetailByCondition(condition, pars)
  822. if err != nil && err.Error() != utils.ErrNoRow() {
  823. br.Msg = "保存失败"
  824. br.ErrMsg = "保存失败,校验名称是否存在失败,Err:" + err.Error()
  825. return
  826. }
  827. resp := new(data_manage.MyChartAddResp)
  828. var myChartClassifyId string
  829. if existItem != nil { //修改
  830. fmt.Println("modify")
  831. for _, v := range req.MyChartClassifyId {
  832. myChartClassifyId += strconv.Itoa(v) + ","
  833. }
  834. resp.MyChartInfoId = existItem.MyChartId
  835. err = data_manage.AddMyChartToMyChartClassify(sysUser.AdminId, existItem.MyChartId, req.MyChartClassifyId)
  836. if err != nil {
  837. br.Msg = "保存失败"
  838. br.ErrMsg = "保存我的图表失败,MoveMyChartClassify,Err:" + err.Error()
  839. return
  840. }
  841. } else {
  842. myChart := &data_manage.MyChart{
  843. //MyChartId: 0,
  844. ChartInfoId: chartItem.ChartInfoId,
  845. Source: chartItem.Source,
  846. AdminId: sysUser.AdminId,
  847. CreateTime: time.Now(),
  848. ModifyTime: time.Now(),
  849. }
  850. newMyChartId, err := data_manage.AddMyChart(myChart)
  851. if err != nil {
  852. br.Msg = "保存失败"
  853. br.ErrMsg = "保存我的图表失败,Err:" + err.Error()
  854. return
  855. }
  856. step := float64(65536)
  857. for _, v := range req.MyChartClassifyId {
  858. //获取最大的排序字段
  859. count, _ := data_manage.GetMyChartMaxSort(sysUser.AdminId, v)
  860. mappingItem := new(data_manage.MyChartClassifyMapping)
  861. mappingItem.AdminId = sysUser.AdminId
  862. mappingItem.MyChartId = int(newMyChartId)
  863. mappingItem.MyChartClassifyId = v
  864. mappingItem.CreateTime = time.Now()
  865. mappingItem.ModifyTime = time.Now()
  866. mappingItem.Sort = (float64(count) + 1) * step
  867. _, err = data_manage.AddMyChartClassifyMapping(mappingItem)
  868. if err != nil {
  869. br.Msg = "保存失败"
  870. br.ErrMsg = "保存我的图表AddMyChartClassifyMapping失败,Err:" + err.Error()
  871. return
  872. }
  873. myChartClassifyId += strconv.Itoa(v) + ","
  874. }
  875. //新增操作日志
  876. {
  877. edbLog := new(data_manage.MyChartLog)
  878. edbLog.MyChartId = myChart.MyChartId
  879. edbLog.ChartInfoId = myChart.ChartInfoId
  880. edbLog.SysUserId = sysUser.AdminId
  881. edbLog.SysUserRealName = sysUser.RealName
  882. edbLog.CreateTime = time.Now()
  883. edbLog.Content = string(this.Ctx.Input.RequestBody)
  884. edbLog.Status = "新增我的图表"
  885. edbLog.Method = this.Ctx.Input.URI()
  886. go data_manage.AddMyChartLog(edbLog)
  887. }
  888. resp.MyChartInfoId = int(newMyChartId)
  889. }
  890. resp.MyChartClassifyId = strings.Trim(myChartClassifyId, ",")
  891. //更新es
  892. if resp.MyChartInfoId > 0 {
  893. go data.EsAddOrEditMyChartInfoByMyChartId(resp.MyChartInfoId)
  894. }
  895. br.Ret = 200
  896. br.Msg = "保存成功"
  897. br.Success = true
  898. br.Data = resp
  899. br.IsAddLog = true
  900. }
  901. // GetMyChartClassifyIdList
  902. // @Title 根据我的图表id获取所属分类列表
  903. // @Description 根据我的图表id获取所属分类列表接口
  904. // @Param query ChartInfoId int `description:"图表id"`
  905. // @Success 200 {object} []int
  906. // @router /get_mychart_classify_id_list [get]
  907. func (this *MyChartController) GetMyChartClassifyIdList() {
  908. br := new(models.BaseResponse).Init()
  909. defer func() {
  910. this.Data["json"] = br
  911. this.ServeJSON()
  912. }()
  913. sysUser := this.SysUser
  914. if sysUser == nil {
  915. br.Msg = "请登录"
  916. br.ErrMsg = "请登录,SysUser Is Empty"
  917. br.Ret = 408
  918. return
  919. }
  920. chartInfoId, _ := this.GetInt("ChartInfoId")
  921. if chartInfoId <= 0 {
  922. br.Msg = "请传入图表id"
  923. br.IsSendEmail = false
  924. return
  925. }
  926. //图表分类id列表
  927. chartClassifyIdList := make([]int, 0)
  928. var condition string
  929. var pars []interface{}
  930. condition += " AND admin_id=? AND chart_info_id=? "
  931. pars = append(pars, sysUser.AdminId, chartInfoId)
  932. existItem, _ := data_manage.GetMyChartDetailByCondition(condition, pars)
  933. if existItem != nil {
  934. myChartClassifyList, err := data_manage.GetMyChartClassifyList(existItem.MyChartId)
  935. if err != nil && err.Error() != utils.ErrNoRow() {
  936. br.Msg = "获取图表信息失败!"
  937. br.ErrMsg = "获取图表信息失败,Err:" + err.Error()
  938. return
  939. }
  940. for _, v := range myChartClassifyList {
  941. chartClassifyIdList = append(chartClassifyIdList, v.MyChartClassifyId)
  942. }
  943. }
  944. br.Ret = 200
  945. br.Msg = "获取成功"
  946. br.Success = true
  947. br.Data = chartClassifyIdList
  948. }
  949. // @Title 删除-我的图表-中的图表
  950. // @Description 删除-我的图表-中的图表接口
  951. // @Param request body data_manage.MyChartDeleteReq true "type json string"
  952. // @Success 200 Ret=200 保存成功
  953. // @router /delete [post]
  954. func (this *MyChartController) MyChartDelete() {
  955. setNxKey := "MyChartDelete_"
  956. deleteCache := true
  957. br := new(models.BaseResponse).Init()
  958. defer func() {
  959. if deleteCache {
  960. utils.Rc.Delete(setNxKey)
  961. }
  962. this.Data["json"] = br
  963. this.ServeJSON()
  964. }()
  965. sysUser := this.SysUser
  966. if sysUser == nil {
  967. br.Msg = "请登录"
  968. br.ErrMsg = "请登录,SysUser Is Empty"
  969. br.Ret = 408
  970. return
  971. }
  972. var req data_manage.MyChartDeleteReq
  973. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  974. if err != nil {
  975. br.Msg = "参数解析异常!"
  976. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  977. return
  978. }
  979. setNxKey += strconv.Itoa(req.MyChartId) + strconv.Itoa(req.MyChartClassifyId)
  980. if !utils.Rc.SetNX(setNxKey, 1, 3*time.Second) {
  981. deleteCache = false
  982. br.Msg = "系统处理中,请稍后重试!"
  983. br.IsSendEmail = false
  984. return
  985. }
  986. if req.MyChartId <= 0 {
  987. br.Msg = "参数错误!"
  988. br.ErrMsg = "参数错误,Err:" + string(this.Ctx.Input.RequestBody)
  989. return
  990. }
  991. isDelMyChart, err := data_manage.DeleteMyChart(req.MyChartId, req.MyChartClassifyId)
  992. if err != nil {
  993. br.Msg = "移除失败!"
  994. br.ErrMsg = "移除失败,Err:" + err.Error()
  995. return
  996. }
  997. //新增操作日志
  998. {
  999. edbLog := new(data_manage.MyChartLog)
  1000. edbLog.MyChartId = 0
  1001. edbLog.ChartInfoId = 0
  1002. edbLog.SysUserId = sysUser.AdminId
  1003. edbLog.SysUserRealName = sysUser.RealName
  1004. edbLog.CreateTime = time.Now()
  1005. edbLog.Content = string(this.Ctx.Input.RequestBody)
  1006. edbLog.Status = "删除-我的图表-中的图表"
  1007. edbLog.Method = this.Ctx.Input.URI()
  1008. go data_manage.AddMyChartLog(edbLog)
  1009. }
  1010. if isDelMyChart {
  1011. //如果确实删除了,那么就去ES同步删除
  1012. go data.EsDeleteMyChartInfoByMyChartId(req.MyChartId)
  1013. } else {
  1014. //如果只是删除了关系,那么就去ES同步更新数据
  1015. go data.EsAddOrEditMyChartInfoByMyChartId(req.MyChartId)
  1016. }
  1017. br.Ret = 200
  1018. br.Msg = "移除成功"
  1019. br.Success = true
  1020. br.IsAddLog = true
  1021. }
  1022. // @Title 编辑我的图表
  1023. // @Description 编辑我的图表接口
  1024. // @Param request body data_manage.MyChartEditReq true "type json string"
  1025. // @Success 200 Ret=200 保存成功
  1026. // @router /edit [post]
  1027. func (this *MyChartController) MyChartEdit() {
  1028. br := new(models.BaseResponse).Init()
  1029. defer func() {
  1030. this.Data["json"] = br
  1031. this.ServeJSON()
  1032. }()
  1033. sysUser := this.SysUser
  1034. if sysUser == nil {
  1035. br.Msg = "请登录"
  1036. br.ErrMsg = "请登录,SysUser Is Empty"
  1037. br.Ret = 408
  1038. return
  1039. }
  1040. var req data_manage.MyChartEditReq
  1041. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1042. if err != nil {
  1043. br.Msg = "参数解析异常!"
  1044. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1045. return
  1046. }
  1047. for _, v := range req.MyChartClassifyId {
  1048. myChartClassifyId := v
  1049. count, _ := data_manage.GetMyChartClassifyMappingCount(sysUser.AdminId, req.MyChartId, myChartClassifyId)
  1050. if count <= 0 {
  1051. mappingItem := new(data_manage.MyChartClassifyMapping)
  1052. mappingItem.AdminId = sysUser.AdminId
  1053. mappingItem.MyChartId = req.MyChartId
  1054. mappingItem.MyChartClassifyId = myChartClassifyId
  1055. mappingItem.CreateTime = time.Now()
  1056. _, err = data_manage.AddMyChartClassifyMapping(mappingItem)
  1057. }
  1058. }
  1059. err = data_manage.DeleteMyChartClassifyMapping(sysUser.AdminId, req.MyChartId, req.CurrentMyChartClassifyId)
  1060. if err != nil {
  1061. br.Msg = "保存失败!"
  1062. br.ErrMsg = "保存失败,移除分类失败,Err:" + err.Error()
  1063. return
  1064. }
  1065. //新增操作日志
  1066. {
  1067. edbLog := new(data_manage.MyChartLog)
  1068. edbLog.MyChartId = 0
  1069. edbLog.ChartInfoId = 0
  1070. edbLog.SysUserId = sysUser.AdminId
  1071. edbLog.SysUserRealName = sysUser.RealName
  1072. edbLog.CreateTime = time.Now()
  1073. edbLog.Content = string(this.Ctx.Input.RequestBody)
  1074. edbLog.Status = "编辑我的图表"
  1075. edbLog.Method = this.Ctx.Input.URI()
  1076. go data_manage.AddMyChartLog(edbLog)
  1077. }
  1078. //更新es
  1079. if req.MyChartId > 0 {
  1080. go data.EsAddOrEditMyChartInfoByMyChartId(req.MyChartId)
  1081. }
  1082. br.Ret = 200
  1083. br.Msg = "保存成功"
  1084. br.Success = true
  1085. br.IsAddLog = true
  1086. }
  1087. // MyChartList
  1088. // @Title 我的图表-列表接口
  1089. // @Description 我的图表-列表接口
  1090. // @Param PageSize query int true "每页数据条数"
  1091. // @Param CurrentIndex query int true "当前页页码,从1开始"
  1092. // @Param MyChartClassifyId query int true "我的图表分类id"
  1093. // @Param MyChartId query int true "我的图表id"
  1094. // @Param IsShared query bool false "是否可分享(如从图库框架请求的属于可分享的)"
  1095. // @Success 200 {object} data_manage.MyChartListResp
  1096. // @router /list [get]
  1097. func (this *MyChartController) MyChartList() {
  1098. br := new(models.BaseResponse).Init()
  1099. defer func() {
  1100. this.Data["json"] = br
  1101. this.ServeJSON()
  1102. }()
  1103. sysUser := this.SysUser
  1104. if sysUser == nil {
  1105. br.Msg = "请登录"
  1106. br.ErrMsg = "请登录,SysUser Is Empty"
  1107. br.Ret = 408
  1108. return
  1109. }
  1110. myChartClassifyId, _ := this.GetInt("MyChartClassifyId")
  1111. pageSize, _ := this.GetInt("PageSize")
  1112. currentIndex, _ := this.GetInt("CurrentIndex")
  1113. myChartId, _ := this.GetInt("MyChartId")
  1114. isShared, _ := this.GetBool("IsShared")
  1115. var total int
  1116. page := paging.GetPaging(currentIndex, pageSize, total)
  1117. var startSize int
  1118. if pageSize <= 0 {
  1119. pageSize = utils.PageSize20
  1120. }
  1121. if currentIndex <= 0 {
  1122. currentIndex = 1
  1123. }
  1124. startSize = paging.StartIndex(currentIndex, pageSize)
  1125. var condition string
  1126. var pars []interface{}
  1127. chartAdminId := sysUser.AdminId
  1128. if myChartClassifyId > 0 {
  1129. condition += " AND c.my_chart_classify_id=? "
  1130. pars = append(pars, myChartClassifyId)
  1131. // 可共享
  1132. if isShared {
  1133. myClassify, e := data_manage.GetMyChartClassifyByClassifyId(myChartClassifyId)
  1134. if e != nil {
  1135. if e.Error() == utils.ErrNoRow() {
  1136. br.Msg = "分类已被删除, 请刷新页面"
  1137. return
  1138. }
  1139. br.Msg = "获取失败"
  1140. br.ErrMsg = "获取分类失败, Err: " + e.Error()
  1141. return
  1142. }
  1143. chartAdminId = myClassify.AdminId
  1144. }
  1145. }
  1146. condition += " AND (a.admin_id = ? OR d.is_public = 1)"
  1147. pars = append(pars, chartAdminId)
  1148. if myChartId > 0 {
  1149. condition += " AND a.my_chart_id=? "
  1150. pars = append(pars, myChartId)
  1151. }
  1152. // 获取当前账号的不可见指标
  1153. noPermissionChartIdList := make([]int, 0)
  1154. {
  1155. obj := data_manage.EdbInfoNoPermissionAdmin{}
  1156. confList, err := obj.GetAllChartListByAdminId(this.SysUser.AdminId)
  1157. if err != nil && err.Error() != utils.ErrNoRow() {
  1158. br.Msg = "获取失败"
  1159. br.ErrMsg = "获取不可见指标配置数据失败,Err:" + err.Error()
  1160. return
  1161. }
  1162. for _, v := range confList {
  1163. noPermissionChartIdList = append(noPermissionChartIdList, v.ChartInfoId)
  1164. }
  1165. }
  1166. lenNoPermissionChartIdList := len(noPermissionChartIdList)
  1167. if lenNoPermissionChartIdList > 0 {
  1168. condition += ` AND b.chart_info_id not in (` + utils.GetOrmInReplace(lenNoPermissionChartIdList) + `) `
  1169. pars = append(pars, noPermissionChartIdList)
  1170. }
  1171. //获取图表信息
  1172. list, err := data_manage.GetMyChartListByCondition(condition, pars, startSize, pageSize)
  1173. if err != nil && err.Error() != utils.ErrNoRow() {
  1174. br.Success = true
  1175. br.Msg = "获取图表信息失败"
  1176. br.ErrMsg = "获取图表信息失败,Err:" + err.Error()
  1177. return
  1178. }
  1179. myChartList, err := data_manage.GetMyChartListByAdminId(sysUser.AdminId)
  1180. if err != nil && err.Error() != utils.ErrNoRow() {
  1181. br.Msg = "获取图表信息失败"
  1182. br.ErrMsg = "获取我的图表信息失败,Err:" + err.Error()
  1183. return
  1184. }
  1185. myChartMap := make(map[int]int)
  1186. chartInfoIds := ""
  1187. chartEdbMap := make(map[int][]*data_manage.ChartEdbInfoMapping)
  1188. for _, v := range myChartList {
  1189. myChartMap[v.ChartInfoId] = v.ChartInfoId
  1190. chartInfoIds += strconv.Itoa(v.ChartInfoId) + ","
  1191. }
  1192. if chartInfoIds != "" {
  1193. chartInfoIds = strings.Trim(chartInfoIds, ",")
  1194. //判断是否需要展示英文标识
  1195. edbList, e := data_manage.GetChartEdbMappingListByChartInfoIds(chartInfoIds)
  1196. if e != nil {
  1197. br.Msg = "获取失败"
  1198. br.ErrMsg = "获取图表,指标信息失败,Err:" + e.Error()
  1199. return
  1200. }
  1201. for _, v := range edbList {
  1202. chartEdbMap[v.ChartInfoId] = append(chartEdbMap[v.ChartInfoId], v)
  1203. }
  1204. }
  1205. listLen := len(list)
  1206. if listLen > 0 {
  1207. // 分类id
  1208. classifyIdList := make([]int, 0)
  1209. // 当前列表中的分类map
  1210. classifyMap := make(map[int]*data_manage.ChartClassify)
  1211. for _, v := range list {
  1212. classifyIdList = append(classifyIdList, v.ChartClassifyId)
  1213. }
  1214. classifyList, err := data_manage.GetChartClassifyByIdList(classifyIdList)
  1215. if err != nil {
  1216. br.Msg = "获取失败"
  1217. br.ErrMsg = "获取分类列表失败,Err:" + err.Error()
  1218. return
  1219. }
  1220. for _, v := range classifyList {
  1221. classifyMap[v.ChartClassifyId] = v
  1222. }
  1223. // 已授权分类id
  1224. permissionChartIdList, permissionClassifyIdList, err := data_manage_permission.GetUserChartAndClassifyPermissionList(this.SysUser.AdminId, 0, 0)
  1225. if err != nil {
  1226. br.Msg = "获取失败"
  1227. br.ErrMsg = "获取已授权分类id数据失败,Err:" + err.Error()
  1228. return
  1229. }
  1230. // 权限
  1231. for i, chartViewInfo := range list {
  1232. //判断是否需要展示英文标识
  1233. if edbTmpList, ok := chartEdbMap[list[i].ChartInfoId]; ok {
  1234. list[i].IsEnChart = data.CheckIsEnChart(list[i].ChartNameEn, edbTmpList, list[i].Source, list[i].ChartType)
  1235. }
  1236. if _, ok := myChartMap[list[i].ChartInfoId]; ok {
  1237. list[i].IsAdd = true
  1238. }
  1239. // 数据权限
  1240. if currClassify, ok := classifyMap[chartViewInfo.ChartClassifyId]; ok {
  1241. list[i].HaveOperaAuth = data_manage_permission.CheckChartPermissionByPermissionIdList(chartViewInfo.IsJoinPermission, currClassify.IsJoinPermission, chartViewInfo.ChartInfoId, chartViewInfo.ChartClassifyId, permissionChartIdList, permissionClassifyIdList)
  1242. }
  1243. }
  1244. }
  1245. resp := new(data_manage.MyChartListResp)
  1246. if list == nil || len(list) <= 0 || (err != nil && err.Error() == utils.ErrNoRow()) {
  1247. items := make([]*data_manage.MyChartList, 0)
  1248. resp.Paging = page
  1249. resp.List = items
  1250. br.Ret = 200
  1251. br.Success = true
  1252. br.Msg = "获取成功"
  1253. return
  1254. }
  1255. total, err = data_manage.GetMyChartListCountByCondition(condition, pars)
  1256. if err != nil && err.Error() != utils.ErrNoRow() {
  1257. br.Msg = "获取信息失败"
  1258. br.ErrMsg = "获取我的图表数据总数失败,Err:" + err.Error()
  1259. return
  1260. }
  1261. page = paging.GetPaging(currentIndex, pageSize, total)
  1262. resp.Paging = page
  1263. resp.List = list
  1264. br.Ret = 200
  1265. br.Success = true
  1266. br.Msg = "获取成功"
  1267. br.Data = resp
  1268. }
  1269. // @Title 移动我的图表接口
  1270. // @Description 移动我的图表接口
  1271. // @Success 200 {object} data_manage.MoveMyChartReq
  1272. // @router /move [post]
  1273. func (this *MyChartController) MyChartMove() {
  1274. br := new(models.BaseResponse).Init()
  1275. defer func() {
  1276. this.Data["json"] = br
  1277. this.ServeJSON()
  1278. }()
  1279. sysUser := this.SysUser
  1280. if sysUser == nil {
  1281. br.Msg = "请登录"
  1282. br.ErrMsg = "请登录,SysUser Is Empty"
  1283. br.Ret = 408
  1284. return
  1285. }
  1286. adminId := sysUser.AdminId
  1287. var req data_manage.MoveMyChartReq
  1288. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1289. if err != nil {
  1290. br.Msg = "参数解析异常!"
  1291. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1292. return
  1293. }
  1294. //step := float64(65536)
  1295. var newSort float64
  1296. if req.PrevMyChartId <= 0 {
  1297. firstMapItem, err := data_manage.GetMyChartSort(adminId, req.MyChartClassifyId, 0)
  1298. if err != nil {
  1299. br.Msg = "获取数据失败!"
  1300. br.ErrMsg = "获取数据失败,GetMyChartClassifyMapping,Err:" + err.Error()
  1301. return
  1302. }
  1303. //if firstMapItem.Sort <= 0 {
  1304. // firstSort := step / float64(2)
  1305. // err = data_manage.MyChartMove(firstSort, adminId, firstMapItem.MyChartId, firstMapItem.MyChartClassifyId)
  1306. // if err != nil {
  1307. // br.Msg = "移动失败!"
  1308. // br.ErrMsg = "移动失败,Err:" + err.Error()
  1309. // return
  1310. // }
  1311. // newSort = step / float64(4)
  1312. //} else {
  1313. // newSort = firstMapItem.Sort / float64(2)
  1314. //}
  1315. newSort = firstMapItem.Sort - 1
  1316. } else if req.NextMyChartId <= 0 {
  1317. latestMapItem, err := data_manage.GetMyChartSort(adminId, req.MyChartClassifyId, 1)
  1318. if err != nil {
  1319. br.Msg = "获取数据失败!"
  1320. br.ErrMsg = "获取数据失败,GetMyChartClassifyMapping,Err:" + err.Error()
  1321. return
  1322. }
  1323. //if latestMapItem.Sort <= 0 {
  1324. // latestSort := step / float64(2)
  1325. // err = data_manage.MyChartMove(latestSort, adminId, latestMapItem.MyChartId, latestMapItem.MyChartClassifyId)
  1326. // if err != nil {
  1327. // br.Msg = "移动失败!"
  1328. // br.ErrMsg = "移动失败,Err:" + err.Error()
  1329. // return
  1330. // }
  1331. // newSort = step / float64(4)
  1332. //} else {
  1333. // newSort = latestMapItem.Sort + (step / float64(2)) - 1
  1334. //}
  1335. newSort = latestMapItem.Sort + 1
  1336. } else {
  1337. preMapItem, err := data_manage.GetMyChartClassifyMapping(adminId, req.PrevMyChartId, req.MyChartClassifyId)
  1338. if err != nil {
  1339. br.Msg = "获取数据失败!"
  1340. br.ErrMsg = "获取数据失败,GetMyChartClassifyMapping,Err:" + err.Error()
  1341. return
  1342. }
  1343. nextMapItem, err := data_manage.GetMyChartClassifyMapping(adminId, req.NextMyChartId, req.MyChartClassifyId)
  1344. if err != nil {
  1345. br.Msg = "获取数据失败!"
  1346. br.ErrMsg = "获取数据失败,GetMyChartClassifyMapping,Err:" + err.Error()
  1347. return
  1348. }
  1349. newSort = (preMapItem.Sort + nextMapItem.Sort) / 2
  1350. newSort = preMapItem.Sort + 1
  1351. var updateSortStr string
  1352. if preMapItem.Sort == nextMapItem.Sort {
  1353. //变更兄弟节点的排序(sort同级)
  1354. updateSortStr = `sort + 2`
  1355. } else if nextMapItem.Sort-preMapItem.Sort == 1 {
  1356. //变更兄弟节点的排序(sort只相差一级)
  1357. updateSortStr = `sort + 1`
  1358. }
  1359. if updateSortStr != `` {
  1360. _ = data_manage.UpdateMyChartSortByClassifyId(req.MyChartClassifyId, int(preMapItem.Sort), preMapItem.MyChartClassifyMappingId, updateSortStr)
  1361. }
  1362. }
  1363. //if newSort >= 0 {
  1364. //
  1365. //} else {
  1366. // utils.FileLog.Info("MyChartMove Sort=0:" + string(this.Ctx.Input.RequestBody))
  1367. //}
  1368. err = data_manage.MyChartMove(newSort, adminId, req.MyChartId, req.MyChartClassifyId)
  1369. if err != nil {
  1370. br.Msg = "移动失败!"
  1371. br.ErrMsg = "移动失败,Err:" + err.Error()
  1372. return
  1373. }
  1374. //新增操作日志
  1375. {
  1376. edbLog := new(data_manage.MyChartLog)
  1377. edbLog.MyChartId = 0
  1378. edbLog.ChartInfoId = 0
  1379. edbLog.SysUserId = sysUser.AdminId
  1380. edbLog.SysUserRealName = sysUser.RealName
  1381. edbLog.CreateTime = time.Now()
  1382. edbLog.Content = string(this.Ctx.Input.RequestBody)
  1383. edbLog.Status = "移动我的图表"
  1384. edbLog.Method = this.Ctx.Input.URI()
  1385. go data_manage.AddMyChartLog(edbLog)
  1386. }
  1387. //更新es
  1388. if req.MyChartId > 0 {
  1389. go data.EsAddOrEditMyChartInfoByMyChartId(req.MyChartId)
  1390. }
  1391. br.Ret = 200
  1392. br.Success = true
  1393. br.Msg = "移动成功"
  1394. br.IsAddLog = true
  1395. }
  1396. // @Title ETA图表-推荐列表接口
  1397. // @Description ETA图表-推荐列表接口
  1398. // @Param ChartClassifyId query int true "分类id"
  1399. // @Success 200 {object} data_manage.ChartRecommendListResp
  1400. // @router /chart/recommend/list [get]
  1401. func (this *MyChartController) ChartRecommendList() {
  1402. br := new(models.BaseResponse).Init()
  1403. defer func() {
  1404. this.Data["json"] = br
  1405. this.ServeJSON()
  1406. }()
  1407. sysUser := this.SysUser
  1408. if sysUser == nil {
  1409. br.Msg = "请登录"
  1410. br.ErrMsg = "请登录,SysUser Is Empty"
  1411. br.Ret = 408
  1412. return
  1413. }
  1414. pageSize := 6
  1415. currentIndex := 1
  1416. var startSize int
  1417. startSize = paging.StartIndex(currentIndex, pageSize)
  1418. var condition string
  1419. var pars []interface{}
  1420. if sysUser.AdminId > 0 {
  1421. condition += " AND a.admin_id=? "
  1422. pars = append(pars, sysUser.AdminId)
  1423. }
  1424. //获取图表信息
  1425. list, err := data_manage.GetRecommendChartListByCondition(condition, pars, startSize, pageSize)
  1426. if err != nil && err.Error() != utils.ErrNoRow() {
  1427. br.Success = true
  1428. br.Msg = "获取图表信息失败"
  1429. br.ErrMsg = "获取图表信息失败,Err:" + err.Error()
  1430. return
  1431. }
  1432. myChartList, err := data_manage.GetMyChartListByAdminId(sysUser.AdminId)
  1433. if err != nil && err.Error() != utils.ErrNoRow() {
  1434. br.Msg = "获取图表信息失败"
  1435. br.ErrMsg = "获取我的图表信息失败,Err:" + err.Error()
  1436. return
  1437. }
  1438. myChartMap := make(map[int]int)
  1439. for _, v := range myChartList {
  1440. myChartMap[v.ChartInfoId] = v.ChartInfoId
  1441. }
  1442. listLen := len(list)
  1443. if listLen > 0 {
  1444. // 分类id
  1445. classifyIdList := make([]int, 0)
  1446. // 当前列表中的分类map
  1447. classifyMap := make(map[int]*data_manage.ChartClassify)
  1448. for _, v := range list {
  1449. classifyIdList = append(classifyIdList, v.ChartClassifyId)
  1450. }
  1451. classifyList, err := data_manage.GetChartClassifyByIdList(classifyIdList)
  1452. if err != nil {
  1453. br.Msg = "获取失败"
  1454. br.ErrMsg = "获取分类列表失败,Err:" + err.Error()
  1455. return
  1456. }
  1457. for _, v := range classifyList {
  1458. classifyMap[v.ChartClassifyId] = v
  1459. }
  1460. // 已授权分类id
  1461. permissionChartIdList, permissionClassifyIdList, err := data_manage_permission.GetUserChartAndClassifyPermissionList(this.SysUser.AdminId, 0, 0)
  1462. if err != nil {
  1463. br.Msg = "获取失败"
  1464. br.ErrMsg = "获取已授权分类id数据失败,Err:" + err.Error()
  1465. return
  1466. }
  1467. // 权限
  1468. for k, chartViewInfo := range list {
  1469. if currClassify, ok := classifyMap[chartViewInfo.ChartClassifyId]; ok {
  1470. list[k].HaveOperaAuth = data_manage_permission.CheckChartPermissionByPermissionIdList(chartViewInfo.IsJoinPermission, currClassify.IsJoinPermission, chartViewInfo.ChartInfoId, chartViewInfo.ChartClassifyId, permissionChartIdList, permissionClassifyIdList)
  1471. }
  1472. if _, ok := myChartMap[list[k].ChartInfoId]; ok {
  1473. list[k].IsAdd = true
  1474. }
  1475. }
  1476. }
  1477. resp := new(data_manage.ChartRecommendListResp)
  1478. if list == nil || len(list) <= 0 || (err != nil && err.Error() == utils.ErrNoRow()) {
  1479. items := make([]*data_manage.ChartInfoView, 0)
  1480. resp.List = items
  1481. br.Ret = 200
  1482. br.Success = true
  1483. br.Msg = "获取成功"
  1484. return
  1485. }
  1486. resp.List = list
  1487. br.Ret = 200
  1488. br.Success = true
  1489. br.Msg = "获取成功"
  1490. br.Data = resp
  1491. }
  1492. // @Title 我的图表-列表接口
  1493. // @Description 我的图表-列表接口
  1494. // @Param KeyWord query string true "搜索关键词"
  1495. // @Success 200 {object} data_manage.MyChartListResp
  1496. // @router /search [get]
  1497. func (this *MyChartController) MyChartSearch() {
  1498. br := new(models.BaseResponse).Init()
  1499. defer func() {
  1500. this.Data["json"] = br
  1501. this.ServeJSON()
  1502. }()
  1503. sysUser := this.SysUser
  1504. if sysUser == nil {
  1505. br.Msg = "请登录"
  1506. br.ErrMsg = "请登录,SysUser Is Empty"
  1507. br.Ret = 408
  1508. return
  1509. }
  1510. var condition string
  1511. var pars []interface{}
  1512. condition += " AND a.admin_id=? "
  1513. pars = append(pars, sysUser.AdminId)
  1514. keyWord := this.GetString("KeyWord")
  1515. if keyWord != "" {
  1516. condition += ` AND chart_name LIKE '%` + keyWord + `%' `
  1517. }
  1518. //获取图表信息
  1519. list, err := data_manage.GetMyChartSearchByCondition(condition, pars)
  1520. if err != nil && err.Error() != utils.ErrNoRow() {
  1521. br.Success = true
  1522. br.Msg = "获取图表信息失败"
  1523. br.ErrMsg = "获取图表信息失败,Err:" + err.Error()
  1524. return
  1525. }
  1526. listLen := len(list)
  1527. if listLen > 0 {
  1528. // 分类id
  1529. classifyIdList := make([]int, 0)
  1530. // 当前列表中的分类map
  1531. classifyMap := make(map[int]*data_manage.ChartClassify)
  1532. for _, v := range list {
  1533. classifyIdList = append(classifyIdList, v.ChartClassifyId)
  1534. }
  1535. classifyList, err := data_manage.GetChartClassifyByIdList(classifyIdList)
  1536. if err != nil {
  1537. br.Msg = "获取失败"
  1538. br.ErrMsg = "获取分类列表失败,Err:" + err.Error()
  1539. return
  1540. }
  1541. for _, v := range classifyList {
  1542. classifyMap[v.ChartClassifyId] = v
  1543. }
  1544. // 已授权分类id
  1545. permissionChartIdList, permissionClassifyIdList, err := data_manage_permission.GetUserChartAndClassifyPermissionList(this.SysUser.AdminId, 0, 0)
  1546. if err != nil {
  1547. br.Msg = "获取失败"
  1548. br.ErrMsg = "获取已授权分类id数据失败,Err:" + err.Error()
  1549. return
  1550. }
  1551. // 权限
  1552. for k, chartViewInfo := range list {
  1553. if currClassify, ok := classifyMap[chartViewInfo.ChartClassifyId]; ok {
  1554. list[k].HaveOperaAuth = data_manage_permission.CheckChartPermissionByPermissionIdList(chartViewInfo.IsJoinPermission, currClassify.IsJoinPermission, chartViewInfo.ChartInfoId, chartViewInfo.ChartClassifyId, permissionChartIdList, permissionClassifyIdList)
  1555. }
  1556. list[k].IsAdd = true
  1557. }
  1558. }
  1559. resp := new(data_manage.MyChartSearchListResp)
  1560. if list == nil {
  1561. list = make([]*data_manage.MyChartList, 0)
  1562. }
  1563. resp.List = list
  1564. br.Ret = 200
  1565. br.Success = true
  1566. br.Msg = "获取成功"
  1567. br.Data = resp
  1568. }
  1569. // MyChartSearchByEs
  1570. // @Title 我的图表-列表接口
  1571. // @Description 我的图表-列表接口
  1572. // @Param Keyword query string true "搜索关键词"
  1573. // @Success 200 {object} data_manage.MyChartListResp
  1574. // @router /search_by_es [get]
  1575. func (this *MyChartController) MyChartSearchByEs() {
  1576. br := new(models.BaseResponse).Init()
  1577. defer func() {
  1578. this.Data["json"] = br
  1579. this.ServeJSON()
  1580. }()
  1581. sysUser := this.SysUser
  1582. if sysUser == nil {
  1583. br.Msg = "请登录"
  1584. br.ErrMsg = "请登录,SysUser Is Empty"
  1585. br.Ret = 408
  1586. return
  1587. }
  1588. pageSize, _ := this.GetInt("PageSize")
  1589. currentIndex, _ := this.GetInt("CurrentIndex")
  1590. var startSize int
  1591. if pageSize <= 0 {
  1592. pageSize = utils.PageSize20
  1593. }
  1594. if currentIndex <= 0 {
  1595. currentIndex = 1
  1596. }
  1597. startSize = paging.StartIndex(currentIndex, pageSize)
  1598. keyword := this.GetString("Keyword")
  1599. // 获取当前账号的不可见指标
  1600. noPermissionChartIdList := make([]int, 0)
  1601. {
  1602. obj := data_manage.EdbInfoNoPermissionAdmin{}
  1603. confList, err := obj.GetAllChartListByAdminId(this.SysUser.AdminId)
  1604. if err != nil && err.Error() != utils.ErrNoRow() {
  1605. br.Msg = "获取失败"
  1606. br.ErrMsg = "获取不可见指标配置数据失败,Err:" + err.Error()
  1607. return
  1608. }
  1609. for _, v := range confList {
  1610. noPermissionChartIdList = append(noPermissionChartIdList, v.ChartInfoId)
  1611. }
  1612. }
  1613. //获取图表信息
  1614. list, total, err := data.EsSearchMyChartInfo(keyword, sysUser.AdminId, noPermissionChartIdList, startSize, pageSize)
  1615. if err != nil {
  1616. br.Msg = "获取失败"
  1617. br.ErrMsg = "获取图表信息失败,Err:" + err.Error()
  1618. return
  1619. }
  1620. lenList := len(list)
  1621. if lenList <= 0 {
  1622. list = make([]*data_manage.MyChartList, 0)
  1623. } else {
  1624. // 分类id
  1625. classifyIdList := make([]int, 0)
  1626. // 图表id
  1627. chartInfoIdList := make([]int, 0)
  1628. // 当前列表中的分类map
  1629. chartClassifyMap := make(map[int]*data_manage.ChartClassify)
  1630. // 当前列表中的图表map
  1631. chartInfoMap := make(map[int]*data_manage.ChartInfo)
  1632. for _, v := range list {
  1633. classifyIdList = append(classifyIdList, v.ChartClassifyId)
  1634. chartInfoIdList = append(chartInfoIdList, v.ChartInfoId)
  1635. }
  1636. // 分类
  1637. {
  1638. classifyList, err := data_manage.GetChartClassifyByIdList(classifyIdList)
  1639. if err != nil {
  1640. if err != nil {
  1641. br.Msg = "获取失败"
  1642. br.ErrMsg = "获取分类列表失败,Err:" + err.Error()
  1643. return
  1644. }
  1645. }
  1646. for _, tmpClassifyInfo := range classifyList {
  1647. chartClassifyMap[tmpClassifyInfo.ChartClassifyId] = tmpClassifyInfo
  1648. }
  1649. }
  1650. // 图表
  1651. {
  1652. tmpChartList, err := data_manage.GetChartInfoByIdList(chartInfoIdList)
  1653. if err != nil {
  1654. br.Msg = "获取失败"
  1655. br.ErrMsg = "获取所有有权限的图表失败,Err:" + err.Error()
  1656. return
  1657. }
  1658. for _, tmpChartInfo := range tmpChartList {
  1659. chartInfoMap[tmpChartInfo.ChartInfoId] = tmpChartInfo
  1660. }
  1661. }
  1662. // 已授权分类id
  1663. permissionChartIdList, permissionClassifyIdList, err := data_manage_permission.GetUserChartAndClassifyPermissionList(this.SysUser.AdminId, 0, 0)
  1664. if err != nil {
  1665. br.Msg = "获取失败"
  1666. br.ErrMsg = "获取已授权分类id数据失败,Err:" + err.Error()
  1667. return
  1668. }
  1669. // 权限
  1670. for k, tmpChartViewInfo := range list {
  1671. list[k].IsAdd = true
  1672. chartViewInfo, ok := chartInfoMap[tmpChartViewInfo.ChartInfoId]
  1673. if !ok {
  1674. continue
  1675. }
  1676. if currClassify, ok := chartClassifyMap[chartViewInfo.ChartClassifyId]; ok {
  1677. list[k].HaveOperaAuth = data_manage_permission.CheckChartPermissionByPermissionIdList(chartViewInfo.IsJoinPermission, currClassify.IsJoinPermission, chartViewInfo.ChartInfoId, chartViewInfo.ChartClassifyId, permissionChartIdList, permissionClassifyIdList)
  1678. }
  1679. }
  1680. }
  1681. page := paging.GetPaging(currentIndex, pageSize, int(total))
  1682. resp := data_manage.MyChartSearchListResp{
  1683. List: list,
  1684. Paging: page,
  1685. }
  1686. br.Ret = 200
  1687. br.Success = true
  1688. br.Msg = "获取成功"
  1689. br.Data = resp
  1690. }
  1691. // PublicClassifyList
  1692. // @Title 我的图表-公共分类列表接口
  1693. // @Description 我的图表-公共分类列表接口
  1694. // @Success 200 {object} data_manage.MyChartClassifyResp
  1695. // @router /classify/public_list [get]
  1696. func (this *MyChartController) PublicClassifyList() {
  1697. br := new(models.BaseResponse).Init()
  1698. defer func() {
  1699. this.Data["json"] = br
  1700. this.ServeJSON()
  1701. }()
  1702. sysUser := this.SysUser
  1703. if sysUser == nil {
  1704. br.Msg = "请登录"
  1705. br.ErrMsg = "请登录,SysUser Is Empty"
  1706. br.Ret = 408
  1707. return
  1708. }
  1709. //获取图表信息
  1710. list, err := data_manage.GetPublicChartClassifyAllExceptMy(sysUser.AdminId)
  1711. if err != nil && err.Error() != utils.ErrNoRow() {
  1712. br.Success = true
  1713. br.Msg = "获取公共分类信息失败"
  1714. br.ErrMsg = "获取公共分类信息失败,Err:" + err.Error()
  1715. return
  1716. }
  1717. resp := new(data_manage.PublicChartClassifyResp)
  1718. if list == nil || len(list) <= 0 || (err != nil && err.Error() == utils.ErrNoRow()) {
  1719. resp.List = make([]data_manage.PublicChartClassifyList, 0)
  1720. br.Ret = 200
  1721. br.Success = true
  1722. br.Msg = "获取成功"
  1723. return
  1724. }
  1725. // 创建人姓名
  1726. adminIdStr := make([]string, 0)
  1727. for _, v := range list {
  1728. adminIdStr = append(adminIdStr, fmt.Sprint(v.AdminId))
  1729. }
  1730. adminMap := make(map[int]string)
  1731. adminList, _ := system.GetSysAdminByIdSlice(adminIdStr)
  1732. if len(adminList) > 0 {
  1733. for _, adminInfo := range adminList {
  1734. adminMap[adminInfo.AdminId] = adminInfo.RealName
  1735. }
  1736. }
  1737. respList := make([]data_manage.PublicChartClassifyList, 0)
  1738. existMap := make(map[int]bool, 0)
  1739. itemsMap := make(map[int][]data_manage.PublicChartClassifyItem, 0)
  1740. for _, v := range list {
  1741. realName := adminMap[v.AdminId]
  1742. if realName == "" {
  1743. // 忽略掉被删掉的用户
  1744. continue
  1745. }
  1746. if itemsMap[v.AdminId] == nil {
  1747. itemsMap[v.AdminId] = make([]data_manage.PublicChartClassifyItem, 0)
  1748. }
  1749. itemsMap[v.AdminId] = append(itemsMap[v.AdminId], data_manage.PublicChartClassifyItem{
  1750. MyChartClassifyId: v.MyChartClassifyId,
  1751. MyChartClassifyName: v.MyChartClassifyName,
  1752. AdminId: v.AdminId,
  1753. RealName: realName,
  1754. IsPublic: v.IsPublic,
  1755. IsCompanyPublic: v.IsCompanyPublic,
  1756. })
  1757. var menu data_manage.PublicChartClassifyList
  1758. if existMap[v.AdminId] {
  1759. continue
  1760. }
  1761. existMap[v.AdminId] = true
  1762. menu.MenuAdminId = v.AdminId
  1763. menu.MenuName = fmt.Sprintf("%s的图库", realName)
  1764. respList = append(respList, menu)
  1765. }
  1766. for k, v := range respList {
  1767. respList[k].Items = itemsMap[v.MenuAdminId]
  1768. }
  1769. resp.List = respList
  1770. language := `CN`
  1771. // 指标显示的语言
  1772. {
  1773. configDetail, _ := system.GetConfigDetailByCode(this.SysUser.AdminId, system.ChartLanguageVar)
  1774. if configDetail != nil {
  1775. language = configDetail.ConfigValue
  1776. } else {
  1777. configDetail, _ = system.GetDefaultConfigDetailByCode(system.ChartLanguageVar)
  1778. if configDetail != nil {
  1779. language = configDetail.ConfigValue
  1780. }
  1781. }
  1782. }
  1783. resp.Language = language
  1784. br.Ret = 200
  1785. br.Success = true
  1786. br.Msg = "获取成功"
  1787. br.Data = resp
  1788. }
  1789. // ModifyClassifyPublicStatus
  1790. // @Title 修改我的图表分类的是否可见
  1791. // @Description 修改我的图表分类的是否可见接口
  1792. // @Param request body data_manage.ModifyChartClassifyPublicReq true "type json string"
  1793. // @Success 200 Ret=200 修改成功
  1794. // @router /classify/modify_public [post]
  1795. func (this *MyChartController) ModifyClassifyPublicStatus() {
  1796. br := new(models.BaseResponse).Init()
  1797. defer func() {
  1798. this.Data["json"] = br
  1799. this.ServeJSON()
  1800. }()
  1801. sysUser := this.SysUser
  1802. if sysUser == nil {
  1803. br.Msg = "请登录"
  1804. br.ErrMsg = "请登录,SysUser Is Empty"
  1805. br.Ret = 408
  1806. return
  1807. }
  1808. var req data_manage.ModifyChartClassifyPublicReq
  1809. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1810. if err != nil {
  1811. br.Msg = "参数解析异常!"
  1812. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1813. return
  1814. }
  1815. //查询该分类存不存在
  1816. item, err := data_manage.GetMyChartClassifyById(sysUser.AdminId, req.MyChartClassifyId)
  1817. if err != nil && err.Error() != utils.ErrNoRow() {
  1818. br.Msg = "修改失败,找不到该分类"
  1819. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  1820. return
  1821. }
  1822. if item == nil {
  1823. br.Msg = "分类不存在"
  1824. br.ErrMsg = "分类不存在,Err:" + err.Error()
  1825. return
  1826. }
  1827. item.IsPublic = req.IsPublic
  1828. item.PublicTime = time.Now()
  1829. if req.IsPublic == 0 {
  1830. // 取消公开同时取消客户公开
  1831. item.IsCompanyPublic = 0
  1832. }
  1833. err = item.Update([]string{"IsPublic", "PublicTime", "IsCompanyPublic"})
  1834. if err != nil {
  1835. br.Msg = "修改失败"
  1836. br.ErrMsg = "修改是否公开失败,Err:" + err.Error()
  1837. return
  1838. }
  1839. //新增操作日志
  1840. {
  1841. edbLog := new(data_manage.MyChartLog)
  1842. edbLog.MyChartId = 0
  1843. edbLog.ChartInfoId = 0
  1844. edbLog.SysUserId = sysUser.AdminId
  1845. edbLog.SysUserRealName = sysUser.RealName
  1846. edbLog.CreateTime = time.Now()
  1847. edbLog.Content = string(this.Ctx.Input.RequestBody)
  1848. edbLog.Status = "修改分类是否公开"
  1849. edbLog.Method = this.Ctx.Input.URI()
  1850. go data_manage.AddMyChartLog(edbLog)
  1851. }
  1852. br.Ret = 200
  1853. br.Msg = "修改成功"
  1854. br.Success = true
  1855. br.IsAddLog = true
  1856. }
  1857. // CopyClassifyAndChart
  1858. // @Title 复制我的图表分类
  1859. // @Description 复制我的图表分类接口
  1860. // @Param request body data_manage.CopyChartClassifyReq true "type json string"
  1861. // @Success 200 Ret=200 复制成功
  1862. // @router /classify/copy [post]
  1863. func (this *MyChartController) CopyClassifyAndChart() {
  1864. br := new(models.BaseResponse).Init()
  1865. defer func() {
  1866. this.Data["json"] = br
  1867. this.ServeJSON()
  1868. }()
  1869. sysUser := this.SysUser
  1870. if sysUser == nil {
  1871. br.Msg = "请登录"
  1872. br.ErrMsg = "请登录,SysUser Is Empty"
  1873. br.Ret = 408
  1874. return
  1875. }
  1876. var req data_manage.CopyChartClassifyReq
  1877. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1878. if err != nil {
  1879. br.Msg = "参数解析异常!"
  1880. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1881. return
  1882. }
  1883. //查询该公共分类存不存在
  1884. item, err := data_manage.GetPublicMyChartClassifyById(req.MyChartClassifyId)
  1885. if err != nil && err.Error() != utils.ErrNoRow() {
  1886. br.Msg = "复制失败,找不到该分类"
  1887. br.ErrMsg = "获取分类信息失败,Err:" + err.Error()
  1888. return
  1889. }
  1890. if item == nil {
  1891. br.Msg = "分类不存在"
  1892. br.ErrMsg = "分类不存在,Err:" + err.Error()
  1893. return
  1894. }
  1895. //获取所有的分类名称
  1896. chartClassifyList, err := data_manage.GetMyChartClassifyAll(sysUser.AdminId)
  1897. //生成新的分类名称
  1898. newChartClassifyName := generateMyChartClassifyName(item.MyChartClassifyName, 1, chartClassifyList)
  1899. //复制分类
  1900. newMyChartClassify, err := data_manage.CopyPublicMyChartClassifyById(item.MyChartClassifyId, sysUser.AdminId, newChartClassifyName)
  1901. if err != nil {
  1902. br.Msg = "复制失败"
  1903. br.ErrMsg = "复制失败,Err:" + err.Error()
  1904. return
  1905. }
  1906. //新增操作日志
  1907. {
  1908. edbLog := new(data_manage.MyChartLog)
  1909. edbLog.MyChartId = 0
  1910. edbLog.ChartInfoId = 0
  1911. edbLog.SysUserId = sysUser.AdminId
  1912. edbLog.SysUserRealName = sysUser.RealName
  1913. edbLog.CreateTime = time.Now()
  1914. edbLog.Content = string(this.Ctx.Input.RequestBody)
  1915. edbLog.Status = "复制分类"
  1916. edbLog.Method = this.Ctx.Input.URI()
  1917. go data_manage.AddMyChartLog(edbLog)
  1918. }
  1919. br.Data = newMyChartClassify
  1920. br.Ret = 200
  1921. br.Msg = "复制成功"
  1922. br.Success = true
  1923. br.IsAddLog = true
  1924. }
  1925. // generateMyChartClassifyName 生成我的图库分类名称
  1926. func generateMyChartClassifyName(myChartClassifyName string, count int, chartClassifyList []*data_manage.MyChartClassify) (newChartClassifyName string) {
  1927. newChartClassifyName = fmt.Sprint(myChartClassifyName, count)
  1928. for _, v := range chartClassifyList {
  1929. if v.MyChartClassifyName == newChartClassifyName {
  1930. count++
  1931. newChartClassifyName = generateMyChartClassifyName(fmt.Sprint(myChartClassifyName), count, chartClassifyList)
  1932. return
  1933. }
  1934. }
  1935. return
  1936. }
  1937. // ModifyClassifyPublicStatus
  1938. // @Title 修改公共分类是否用户可见
  1939. // @Description 修改公共分类是否用户可见接口
  1940. // @Param request body data_manage.ModifyChartClassifyCompanyPublicReq true "type json string"
  1941. // @Success 200 Ret=200 修改成功
  1942. // @router /classify/modify_company_public [post]
  1943. func (this *MyChartController) ModifyClassifyCompanyPublicStatus() {
  1944. br := new(models.BaseResponse).Init()
  1945. defer func() {
  1946. this.Data["json"] = br
  1947. this.ServeJSON()
  1948. }()
  1949. sysUser := this.SysUser
  1950. if sysUser == nil {
  1951. br.Msg = "请登录"
  1952. br.ErrMsg = "请登录,SysUser Is Empty"
  1953. br.Ret = 408
  1954. return
  1955. }
  1956. var req data_manage.ModifyChartClassifyCompanyPublicReq
  1957. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1958. if err != nil {
  1959. br.Msg = "参数解析异常!"
  1960. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1961. return
  1962. }
  1963. item, err := data_manage.GetPublicMyChartClassifyById(req.MyChartClassifyId)
  1964. if err != nil {
  1965. br.Msg = "找不到该分类"
  1966. br.ErrMsg = "获取分类信息失败, Err:" + err.Error()
  1967. return
  1968. }
  1969. if item.IsPublic != 1 {
  1970. br.Msg = "该分类未公开,不可设置为用户可见"
  1971. br.ErrMsg = "该分类未公开,不可设置为用户可见"
  1972. return
  1973. }
  1974. item.IsCompanyPublic = req.IsCompanyPublic
  1975. item.CompanyPublicTime = time.Now()
  1976. err = item.Update([]string{"IsCompanyPublic", "CompanyPublicTime"})
  1977. if err != nil {
  1978. br.Msg = "修改失败"
  1979. br.ErrMsg = "修改是否用户可见失败, Err:" + err.Error()
  1980. return
  1981. }
  1982. {
  1983. edbLog := new(data_manage.MyChartLog)
  1984. edbLog.MyChartId = 0
  1985. edbLog.ChartInfoId = 0
  1986. edbLog.SysUserId = sysUser.AdminId
  1987. edbLog.SysUserRealName = sysUser.RealName
  1988. edbLog.CreateTime = time.Now()
  1989. edbLog.Content = string(this.Ctx.Input.RequestBody)
  1990. edbLog.Status = "修改用户是否可见"
  1991. edbLog.Method = this.Ctx.Input.URI()
  1992. go data_manage.AddMyChartLog(edbLog)
  1993. }
  1994. br.Ret = 200
  1995. br.Msg = "修改成功"
  1996. br.Success = true
  1997. br.IsAddLog = true
  1998. }
  1999. // CompanyPublicClassifyList
  2000. // @Title 我的图表-用户可见分类列表
  2001. // @Description 我的图表-用户可见分类列表接口
  2002. // @Param Keyword query string false "分类名称关键词"
  2003. // @Success 200 {object} data_manage.MyChartClassifyResp
  2004. // @router /classify/company_public_list [get]
  2005. func (this *MyChartController) CompanyPublicClassifyList() {
  2006. br := new(models.BaseResponse).Init()
  2007. defer func() {
  2008. this.Data["json"] = br
  2009. this.ServeJSON()
  2010. }()
  2011. sysUser := this.SysUser
  2012. if sysUser == nil {
  2013. br.Msg = "请登录"
  2014. br.ErrMsg = "请登录,SysUser Is Empty"
  2015. br.Ret = 408
  2016. return
  2017. }
  2018. var condition string
  2019. var pars []interface{}
  2020. keyword := this.GetString("Keyword")
  2021. if keyword != "" {
  2022. keyword = "%" + keyword + "%"
  2023. condition += ` AND my_chart_classify_name LIKE ? `
  2024. pars = append(pars, keyword)
  2025. }
  2026. list, err := data_manage.GetCompanyPublicClassifyList(condition, pars)
  2027. if err != nil && err.Error() != utils.ErrNoRow() {
  2028. br.Success = true
  2029. br.Msg = "获取用户可见分类列表失败"
  2030. br.ErrMsg = "获取用户可见分类列表失败, Err:" + err.Error()
  2031. return
  2032. }
  2033. resp := new(data_manage.MyChartClassifyResp)
  2034. if list == nil || len(list) <= 0 || (err != nil && err.Error() == utils.ErrNoRow()) {
  2035. items := make([]*data_manage.MyChartClassifyItem, 0)
  2036. resp.List = items
  2037. br.Ret = 200
  2038. br.Success = true
  2039. br.Msg = "获取成功"
  2040. return
  2041. }
  2042. results := make([]*data_manage.MyChartClassifyItem, 0)
  2043. for _, v := range list {
  2044. results = append(results, data_manage.FormatMyChartClassify2Item(v, 0))
  2045. }
  2046. resp.List = results
  2047. //resp.List = list
  2048. br.Ret = 200
  2049. br.Success = true
  2050. br.Msg = "获取成功"
  2051. br.Data = resp
  2052. }
  2053. //func init() {
  2054. // data.AddAllMyChartInfo()
  2055. //}
  2056. // Locate
  2057. // @Title ETA图表位置
  2058. // @Description ETA图表位置
  2059. // @Param PageSize query int true "每页数据条数"
  2060. // @Param CurrentIndex query int true "当前页页码,从1开始"
  2061. // @Param ChartClassifyId query int true "分类id"
  2062. // @Param KeyWord query string true "搜索关键词"
  2063. // @Param IsShowMe query bool true "是否只看我的,true、false"
  2064. // @Success 200 {object} data_manage.ChartListResp
  2065. // @router /chart/locate [get]
  2066. func (this *MyChartController) Locate() {
  2067. br := new(models.BaseResponse).Init()
  2068. defer func() {
  2069. if br.ErrMsg == "" {
  2070. br.IsSendEmail = false
  2071. }
  2072. this.Data["json"] = br
  2073. this.ServeJSON()
  2074. }()
  2075. sysUser := this.SysUser
  2076. if sysUser == nil {
  2077. br.Msg = "请登录"
  2078. br.ErrMsg = "请登录,SysUser Is Empty"
  2079. br.Ret = 408
  2080. return
  2081. }
  2082. classifyId, _ := this.GetInt("ChartClassifyId")
  2083. keyword := this.GetString("KeyWord")
  2084. mine, _ := this.GetBool("IsShowMe") // 只看我的
  2085. condition := ` AND source = ?`
  2086. pars := make([]interface{}, 0)
  2087. pars = append(pars, utils.CHART_SOURCE_DEFAULT) // 普通图表
  2088. orderRule := ``
  2089. {
  2090. if keyword != "" {
  2091. k := fmt.Sprint("%", keyword, "%")
  2092. condition += ` AND chart_name LIKE ?`
  2093. pars = append(pars, k)
  2094. }
  2095. if mine {
  2096. condition += ` AND sys_user_id = ?`
  2097. pars = append(pars, sysUser.AdminId)
  2098. }
  2099. if classifyId > 0 {
  2100. strIds, e := data_manage.GetChartClassify(classifyId)
  2101. if e != nil {
  2102. br.Msg = "获取失败"
  2103. br.ErrMsg = "获取图表分类信息失败, GetChartClassify Err: " + e.Error()
  2104. return
  2105. }
  2106. if strIds == "" {
  2107. br.Msg = "获取失败"
  2108. br.ErrMsg = "图表分类为空"
  2109. return
  2110. }
  2111. condition += fmt.Sprintf(` AND chart_classify_id IN (%s)`, strIds)
  2112. }
  2113. }
  2114. // 当前账号的不可见指标
  2115. {
  2116. ids := make([]int, 0)
  2117. obj := data_manage.EdbInfoNoPermissionAdmin{}
  2118. conf, e := obj.GetAllChartListByAdminId(sysUser.AdminId)
  2119. if e != nil && e.Error() != utils.ErrNoRow() {
  2120. br.Msg = "获取失败"
  2121. br.ErrMsg = "获取不可见指标配置失败, Err: " + e.Error()
  2122. return
  2123. }
  2124. for _, v := range conf {
  2125. ids = append(ids, v.ChartInfoId)
  2126. }
  2127. if len(ids) > 0 {
  2128. condition += fmt.Sprintf(` AND chart_info_id NOT IN (%s)`, utils.GetOrmInReplace(len(ids)))
  2129. pars = append(pars, ids)
  2130. }
  2131. }
  2132. // 获取图表
  2133. list := make([]*data_manage.ChartInfoLocate, 0)
  2134. charts, e := data_manage.GetChartItems(condition, pars, orderRule)
  2135. if e != nil {
  2136. br.Msg = "获取失败"
  2137. br.ErrMsg = "获取图表列表失败, Err: " + e.Error()
  2138. return
  2139. }
  2140. if len(charts) == 0 {
  2141. br.Ret = 200
  2142. br.Success = true
  2143. br.Msg = "获取成功"
  2144. br.Data = list
  2145. return
  2146. }
  2147. // 二级分类
  2148. classifies, e := data_manage.GetSecondaryChartClassifyWithSort()
  2149. if e != nil {
  2150. br.Msg = "获取失败"
  2151. br.ErrMsg = "获取图表分类排序失败, Err: " + e.Error()
  2152. return
  2153. }
  2154. classifyIdName := make(map[int]string)
  2155. for _, c := range classifies {
  2156. classifyIdName[c.ChartClassifyId] = c.ChartClassifyName
  2157. }
  2158. // 当前列表中的分类map
  2159. classifyMap := make(map[int]*data_manage.ChartClassify)
  2160. {
  2161. // 分类id
  2162. classifyIdList := make([]int, 0)
  2163. for _, v := range list {
  2164. classifyIdList = append(classifyIdList, v.ChartClassifyId)
  2165. }
  2166. classifyList, err := data_manage.GetChartClassifyByIdList(classifyIdList)
  2167. if err != nil {
  2168. br.Msg = "获取失败"
  2169. br.ErrMsg = "获取分类列表失败,Err:" + err.Error()
  2170. return
  2171. }
  2172. for _, v := range classifyList {
  2173. classifyMap[v.ChartClassifyId] = v
  2174. }
  2175. }
  2176. // 已授权分类id
  2177. permissionChartIdList, permissionClassifyIdList, err := data_manage_permission.GetUserChartAndClassifyPermissionList(this.SysUser.AdminId, 0, 0)
  2178. if err != nil {
  2179. br.Msg = "获取失败"
  2180. br.ErrMsg = "获取已授权分类id数据失败,Err:" + err.Error()
  2181. return
  2182. }
  2183. // 分类ID大于0时, 优先分类排序, 其次图表排序
  2184. if classifyId > 0 {
  2185. for _, cl := range classifies {
  2186. for _, ch := range charts {
  2187. if ch.ChartClassifyId != cl.ChartClassifyId {
  2188. continue
  2189. }
  2190. v := new(data_manage.ChartInfoLocate)
  2191. v.ChartInfoId = ch.ChartInfoId
  2192. v.ChartName = ch.ChartName
  2193. v.ChartType = ch.ChartType
  2194. v.ChartClassifyId = ch.ChartClassifyId
  2195. v.ChartClassifyName = cl.ChartClassifyName
  2196. v.UniqueCode = ch.UniqueCode
  2197. v.Source = ch.Source
  2198. v.StartDate = ch.StartDate
  2199. v.EndDate = ch.EndDate
  2200. v.SeasonStartDate = ch.SeasonStartDate
  2201. v.SeasonEndDate = ch.SeasonEndDate
  2202. v.DateType = ch.DateType
  2203. v.Calendar = ch.Calendar
  2204. v.StartYear = ch.StartYear
  2205. // 图表权限
  2206. if currClassify, ok := classifyMap[ch.ChartClassifyId]; ok {
  2207. v.HaveOperaAuth = data_manage_permission.CheckChartPermissionByPermissionIdList(ch.IsJoinPermission, currClassify.IsJoinPermission, ch.ChartInfoId, ch.ChartClassifyId, permissionChartIdList, permissionClassifyIdList)
  2208. }
  2209. list = append(list, v)
  2210. }
  2211. }
  2212. br.Ret = 200
  2213. br.Success = true
  2214. br.Msg = "获取成功"
  2215. br.Data = list
  2216. return
  2217. }
  2218. // 分类ID为0时
  2219. for _, ch := range charts {
  2220. v := new(data_manage.ChartInfoLocate)
  2221. v.ChartInfoId = ch.ChartInfoId
  2222. v.ChartName = ch.ChartName
  2223. v.ChartType = ch.ChartType
  2224. v.ChartClassifyId = ch.ChartClassifyId
  2225. v.ChartClassifyName = classifyIdName[v.ChartClassifyId]
  2226. v.UniqueCode = ch.UniqueCode
  2227. v.Source = ch.Source
  2228. v.StartDate = ch.StartDate
  2229. v.EndDate = ch.EndDate
  2230. v.SeasonStartDate = ch.SeasonStartDate
  2231. v.SeasonEndDate = ch.SeasonEndDate
  2232. v.DateType = ch.DateType
  2233. v.Calendar = ch.Calendar
  2234. v.StartYear = ch.StartYear
  2235. // 图表权限
  2236. if currClassify, ok := classifyMap[ch.ChartClassifyId]; ok {
  2237. v.HaveOperaAuth = data_manage_permission.CheckChartPermissionByPermissionIdList(ch.IsJoinPermission, currClassify.IsJoinPermission, ch.ChartInfoId, ch.ChartClassifyId, permissionChartIdList, permissionClassifyIdList)
  2238. }
  2239. list = append(list, v)
  2240. }
  2241. br.Ret = 200
  2242. br.Success = true
  2243. br.Msg = "获取成功"
  2244. br.Data = list
  2245. }
  2246. // ClassifyFrameworkNodeList
  2247. // @Title 我的图表分类-关联的框架节点列表
  2248. // @Description 我的图表分类-关联的框架节点列表
  2249. // @Param MyChartClassifyId query int false "图表分类ID"
  2250. // @Success 200 Ret=200 获取成功
  2251. // @router /classify/framework_node_list [get]
  2252. func (this *MyChartController) ClassifyFrameworkNodeList() {
  2253. br := new(models.BaseResponse).Init()
  2254. defer func() {
  2255. if br.ErrMsg == "" {
  2256. br.IsSendEmail = true
  2257. }
  2258. this.Data["json"] = br
  2259. this.ServeJSON()
  2260. }()
  2261. sysUser := this.SysUser
  2262. if sysUser == nil {
  2263. br.Msg = "请登录"
  2264. br.ErrMsg = "请登录,SysUser Is Empty"
  2265. br.Ret = 408
  2266. return
  2267. }
  2268. classifyId, _ := this.GetInt("MyChartClassifyId")
  2269. if classifyId <= 0 {
  2270. br.Msg = "参数有误"
  2271. br.ErrMsg = fmt.Sprintf("参数有误, MyChartClassifyId: %d", classifyId)
  2272. return
  2273. }
  2274. _, e := data_manage.GetMyChartClassifyById(sysUser.AdminId, classifyId)
  2275. if e != nil {
  2276. if e.Error() == utils.ErrNoRow() {
  2277. br.Msg = "分类不存在, 请刷新页面"
  2278. return
  2279. }
  2280. br.Msg = "获取失败"
  2281. br.ErrMsg = "获取分类信息失败, Err:" + e.Error()
  2282. return
  2283. }
  2284. nodeOb := new(data_manage.ChartFrameworkNode)
  2285. cond := ` AND my_chart_classify_id = ?`
  2286. pars := make([]interface{}, 0)
  2287. pars = append(pars, classifyId)
  2288. nodes, e := nodeOb.GetItemsByCondition(cond, pars, []string{}, "")
  2289. if e != nil {
  2290. br.Msg = "获取失败"
  2291. br.ErrMsg = "获取我的图表分类关联的框架节点失败, Err: " + e.Error()
  2292. return
  2293. }
  2294. resp := make([]*data_manage.ChartFrameworkNodeItem, 0)
  2295. for _, v := range nodes {
  2296. resp = append(resp, data_manage.FormatChartFrameworkNode2Item(v, 0))
  2297. }
  2298. br.Data = resp
  2299. br.Ret = 200
  2300. br.Msg = "获取成功"
  2301. br.Success = true
  2302. }