my_chart.go 68 KB

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