my_chart.go 68 KB

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