data_move.go 46 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414
  1. package data_manage_permission
  2. import (
  3. "encoding/json"
  4. "eta/eta_api/models"
  5. "eta/eta_api/models/data_manage"
  6. "eta/eta_api/models/data_manage/data_manage_permission"
  7. "eta/eta_api/models/data_manage/excel"
  8. "eta/eta_api/models/system"
  9. "eta/eta_api/utils"
  10. "fmt"
  11. "github.com/rdlucklib/rdluck_tools/uuid"
  12. "strconv"
  13. "strings"
  14. "time"
  15. )
  16. // GetEdbChartClassifyList
  17. // @Description: 获取数据权限那边的分类列表
  18. // @author: Roc
  19. // @datetime 2024-04-01 09:46:29
  20. // @param source int
  21. // @param subSource int
  22. // @return resp data_manage.EdbChartClassifyResp
  23. // @return err error
  24. func GetEdbChartClassifyList(source, subSource int) (resp data_manage.EdbChartClassifyResp, err error) {
  25. switch source {
  26. case 1: //手工数据指标
  27. list, e := models.GetEdbdataClassify(0)
  28. if e != nil {
  29. err = e
  30. return
  31. }
  32. for _, v := range list {
  33. item := data_manage.EdbChartClassify{
  34. ClassifyId: v.ClassifyId,
  35. ClassifyName: v.ClassifyName,
  36. ParentId: v.ParentId,
  37. }
  38. for _, v2 := range v.Child {
  39. child := data_manage.EdbChartClassify{
  40. ClassifyId: v2.ClassifyId,
  41. ClassifyName: v2.ClassifyName,
  42. ParentId: v2.ParentId,
  43. }
  44. item.Child = append(item.Child, &child)
  45. }
  46. resp.List = append(resp.List, &item)
  47. }
  48. case 2: //钢联化工数据库
  49. rootList, e := data_manage.GetBaseFromMysteelChemicalClassifyByParentId(0)
  50. if e != nil && e.Error() != utils.ErrNoRow() {
  51. err = e
  52. return
  53. }
  54. classifyAll, e := data_manage.GetAllBaseFromMysteelChemicalClassify()
  55. if e != nil && e.Error() != utils.ErrNoRow() {
  56. err = e
  57. return
  58. }
  59. rootChildMap := make(map[int][]*data_manage.BaseFromMysteelChemicalClassifyItems)
  60. for _, v := range classifyAll {
  61. rootChildMap[v.ParentId] = append(rootChildMap[v.ParentId], v)
  62. }
  63. nodeAll := make([]*data_manage.BaseFromMysteelChemicalClassifyItems, 0)
  64. for _, v := range rootList {
  65. if existItems, ok := rootChildMap[v.BaseFromMysteelChemicalClassifyId]; ok {
  66. v.Children = existItems
  67. } else {
  68. items := make([]*data_manage.BaseFromMysteelChemicalClassifyItems, 0)
  69. v.Children = items
  70. }
  71. nodeAll = append(nodeAll, v)
  72. }
  73. for _, v := range nodeAll {
  74. item := data_manage.EdbChartClassify{
  75. ClassifyId: v.BaseFromMysteelChemicalClassifyId,
  76. ClassifyName: v.ClassifyName,
  77. ParentId: v.ParentId,
  78. }
  79. for _, v2 := range v.Children {
  80. child := data_manage.EdbChartClassify{
  81. ClassifyId: v2.BaseFromMysteelChemicalClassifyId,
  82. ClassifyName: v2.ClassifyName,
  83. ParentId: v2.ParentId,
  84. }
  85. item.Child = append(item.Child, &child)
  86. }
  87. resp.List = append(resp.List, &item)
  88. }
  89. case 3:
  90. //ETA指标库
  91. //rootList, e := data_manage.GetEdbClassifyByParentId(0, 0)
  92. //if e != nil && e.Error() != utils.ErrNoRow() {
  93. // err = e
  94. // return
  95. //}
  96. // 考虑到后面可以会迭代到10层, 这里直接用递归处理
  97. classifyAll, e := data_manage.GetAllEdbClassifyByType(0)
  98. if e != nil && e.Error() != utils.ErrNoRow() {
  99. err = e
  100. return
  101. }
  102. resp.List = GetEdbMenuTreeRecursive(classifyAll, 0)
  103. case 4:
  104. //ETA预测指标
  105. // 考虑到后面可以会迭代到10层, 这里直接用递归
  106. classifyAll, e := data_manage.GetAllEdbClassifyByType(1)
  107. if e != nil && e.Error() != utils.ErrNoRow() {
  108. err = e
  109. return
  110. }
  111. resp.List = GetEdbMenuTreeRecursive(classifyAll, 0)
  112. case 5: //图库
  113. // 考虑到后面可以会迭代到10层, 这里直接用递归处理
  114. classifyAll, e := data_manage.GetAllChartClassifyItemsBySource(1)
  115. if e != nil && e.Error() != utils.ErrNoRow() {
  116. err = e
  117. return
  118. }
  119. resp.List = GetChartMenuTreeRecursive(classifyAll, 0)
  120. // 将数据加入缓存
  121. //if utils.Re == nil {
  122. // utils.Rc.Delete(key)
  123. //}
  124. case 6:
  125. // ETA表格
  126. // 考虑到后面可以会迭代到10层, 这里直接用递归处理
  127. classifyAll, e := excel.GetExcelClassifyBySourceOrderByLevel(subSource)
  128. if e != nil && e.Error() != utils.ErrNoRow() {
  129. err = e
  130. return
  131. }
  132. resp.List = GetExcelMenuTreeRecursive(classifyAll, 0)
  133. default:
  134. return
  135. }
  136. return
  137. }
  138. // GetEdbMenuTreeRecursive 递归指标库菜单树
  139. func GetEdbMenuTreeRecursive(list []*data_manage.EdbClassifyItems, parentId int) []*data_manage.EdbChartClassify {
  140. res := make([]*data_manage.EdbChartClassify, 0)
  141. for _, v := range list {
  142. t := new(data_manage.EdbChartClassify)
  143. t.ClassifyId = v.ClassifyId
  144. t.ClassifyName = v.ClassifyName
  145. t.ParentId = v.ParentId
  146. t.IsJoinPermission = v.IsJoinPermission
  147. if v.ParentId == parentId {
  148. t.Child = GetEdbMenuTreeRecursive(list, v.ClassifyId)
  149. res = append(res, t)
  150. }
  151. }
  152. return res
  153. }
  154. // GetChartMenuTreeRecursive 递归指标库菜单树
  155. func GetChartMenuTreeRecursive(list []*data_manage.ChartClassifyItems, parentId int) []*data_manage.EdbChartClassify {
  156. res := make([]*data_manage.EdbChartClassify, 0)
  157. for _, v := range list {
  158. t := new(data_manage.EdbChartClassify)
  159. t.ClassifyId = v.ChartClassifyId
  160. t.ClassifyName = v.ChartClassifyName
  161. t.ParentId = v.ParentId
  162. t.IsJoinPermission = v.IsJoinPermission
  163. if v.ParentId == parentId {
  164. t.Child = GetChartMenuTreeRecursive(list, v.ChartClassifyId)
  165. res = append(res, t)
  166. }
  167. }
  168. return res
  169. }
  170. // GetExcelMenuTreeRecursive
  171. // @Description: 递归ETA表格菜单树
  172. // @author: Roc
  173. // @datetime 2024-03-27 10:30:32
  174. // @param list []*data_manage.ChartClassifyItems
  175. // @param parentId int
  176. // @return []*data_manage.EdbChartClassify
  177. func GetExcelMenuTreeRecursive(list []*excel.ExcelClassifyItems, parentId int) []*data_manage.EdbChartClassify {
  178. res := make([]*data_manage.EdbChartClassify, 0)
  179. for _, v := range list {
  180. t := new(data_manage.EdbChartClassify)
  181. t.ClassifyId = v.ExcelClassifyId
  182. t.ClassifyName = v.ExcelClassifyName
  183. t.ParentId = v.ParentId
  184. t.IsJoinPermission = v.IsJoinPermission
  185. if v.ParentId == parentId {
  186. t.Child = GetExcelMenuTreeRecursive(list, v.ExcelClassifyId)
  187. res = append(res, t)
  188. }
  189. }
  190. return res
  191. }
  192. // GetMoveEdbChartList 获取待转移的指标/图表列表
  193. // @param source 来源 :1:手工数据指标 2:钢联化工数据库 3:ETA指标库 4:ETA预测指标 5:图库 6:ETA表格
  194. func GetMoveEdbChartList(source, subSource, userId int, keyword, classify string, startSize, pageSize int) (list []data_manage.MoveEdbChartList, total int, err error) {
  195. var condition string
  196. var pars []interface{}
  197. switch source {
  198. case 1: //手工数据指标
  199. if keyword != "" {
  200. condition += ` AND (a.SEC_NAME LIKE ? OR a.TRADE_CODE like ? ) `
  201. pars = utils.GetLikeKeywordPars(pars, keyword, 2)
  202. }
  203. if userId > 0 {
  204. condition += ` AND a.user_id = ? `
  205. pars = append(pars, userId)
  206. }
  207. if classify != "" {
  208. condition += ` AND a.classify_id IN (` + classify + `) `
  209. }
  210. total, err = models.GetEdbinfoListCount(condition, pars, "", 0)
  211. if err != nil {
  212. return
  213. }
  214. tmpList, tmpErr := models.GetEdbinfoItemList(condition, pars, startSize, pageSize, "", 0)
  215. if tmpErr != nil {
  216. err = tmpErr
  217. return
  218. }
  219. if len(tmpList) > 0 {
  220. adminIdList := make([]int, 0)
  221. for _, v := range tmpList {
  222. adminIdList = append(adminIdList, v.UserId)
  223. }
  224. adminList, tmpErr := system.GetAdminListByIdListWithoutEnable(adminIdList)
  225. if tmpErr != nil {
  226. err = tmpErr
  227. return
  228. }
  229. adminMap := make(map[int]string)
  230. for _, adminInfo := range adminList {
  231. adminMap[adminInfo.AdminId] = adminInfo.RealName
  232. }
  233. for _, v := range tmpList {
  234. list = append(list, data_manage.MoveEdbChartList{
  235. DataId: v.TradeCode,
  236. Code: v.TradeCode,
  237. Name: v.SecName,
  238. ClassifyName: v.ClassifyName,
  239. NameEn: v.SecName,
  240. ClassifyNameEn: v.ClassifyName,
  241. CreateUserId: v.UserId,
  242. CreateUserName: adminMap[v.UserId],
  243. })
  244. }
  245. }
  246. case 2: //钢联化工数据库
  247. if keyword != `` {
  248. condition += " AND (index_name like ? OR index_code like ? OR sys_user_real_name like ? ) "
  249. pars = utils.GetLikeKeywordPars(pars, keyword, 3)
  250. }
  251. if userId > 0 {
  252. condition += ` AND sys_user_id = ? `
  253. pars = append(pars, userId)
  254. }
  255. if classify != "" {
  256. condition += ` AND base_from_mysteel_chemical_classify_id IN (` + classify + `) `
  257. }
  258. total, err = data_manage.GetMysteelChemicalIndexCount(condition, pars)
  259. if err != nil {
  260. return
  261. }
  262. tmpList, tmpErr := data_manage.GetMysteelChemicalIndexList(condition, pars, startSize, pageSize, "DESC")
  263. if tmpErr != nil {
  264. err = tmpErr
  265. return
  266. }
  267. for _, v := range tmpList {
  268. list = append(list, data_manage.MoveEdbChartList{
  269. DataId: strconv.Itoa(v.BaseFromMysteelChemicalIndexId),
  270. Code: v.IndexCode,
  271. Name: v.IndexName,
  272. NameEn: v.IndexName,
  273. //ClassifyName: v.,
  274. CreateUserId: v.SysUserId,
  275. CreateUserName: v.SysUserRealName,
  276. })
  277. }
  278. case 3, 4: //ETA指标库、ETA预测指标
  279. if keyword != `` {
  280. condition += " AND (edb_code like ? OR edb_name like ? OR edb_name_en like ? OR sys_user_real_name like ? ) "
  281. pars = utils.GetLikeKeywordPars(pars, keyword, 4)
  282. }
  283. if userId > 0 {
  284. condition += ` AND sys_user_id = ? `
  285. pars = append(pars, userId)
  286. }
  287. if classify != "" {
  288. condition += ` AND classify_id IN (` + classify + `) `
  289. }
  290. edbInfoType := 0 //ETA指标库
  291. if source == 4 { //ETA预测指标
  292. edbInfoType = 1
  293. }
  294. condition += ` AND edb_info_type = ? `
  295. pars = append(pars, edbInfoType)
  296. total, err = data_manage.GetEdbInfoByConditionCount(condition, pars)
  297. if err != nil {
  298. return
  299. }
  300. tmpList, tmpErr := data_manage.GetEdbInfoListByCondition(condition, pars, startSize, pageSize, "DESC")
  301. if tmpErr != nil {
  302. err = tmpErr
  303. return
  304. }
  305. for _, v := range tmpList {
  306. list = append(list, data_manage.MoveEdbChartList{
  307. DataId: strconv.Itoa(v.EdbInfoId),
  308. Code: v.EdbCode,
  309. Name: v.EdbName,
  310. NameEn: v.EdbNameEn,
  311. //ClassifyName: v.,
  312. CreateUserId: v.SysUserId,
  313. CreateUserName: v.SysUserRealName,
  314. })
  315. }
  316. case 5: //图库
  317. // 只展示eta图库
  318. condition += ` AND source = ? `
  319. pars = append(pars, utils.CHART_SOURCE_DEFAULT)
  320. // 关键字搜索
  321. if keyword != `` {
  322. condition += " AND (chart_name like ? or chart_name_en like ? OR sys_user_real_name like ? ) "
  323. pars = utils.GetLikeKeywordPars(pars, keyword, 3)
  324. }
  325. if userId > 0 {
  326. condition += ` AND sys_user_id = ? `
  327. pars = append(pars, userId)
  328. }
  329. if classify != "" {
  330. condition += ` AND chart_classify_id IN (` + classify + `) `
  331. }
  332. total, err = data_manage.GetChartInfoCountByCondition(condition, pars)
  333. if err != nil {
  334. return
  335. }
  336. tmpList, tmpErr := data_manage.GetChartInfoListByCondition(condition, pars, startSize, pageSize)
  337. if tmpErr != nil {
  338. err = tmpErr
  339. return
  340. }
  341. // 获取所有的图表分类
  342. firstClassifyList, tmpErr := data_manage.GetChartClassifyByParentId(0, 1)
  343. if tmpErr != nil {
  344. err = tmpErr
  345. return
  346. }
  347. firstClassifyNameMap := make(map[int]string)
  348. firstClassifyNameEnMap := make(map[int]string)
  349. for _, v := range firstClassifyList {
  350. firstClassifyNameMap[v.ChartClassifyId] = v.ChartClassifyName
  351. firstClassifyNameEnMap[v.ChartClassifyId] = v.ChartClassifyNameEn
  352. }
  353. secondClassList, tmpErr := data_manage.GetChartClassifyAll(1)
  354. if tmpErr != nil {
  355. err = tmpErr
  356. return
  357. }
  358. secondClassifyNameMap := make(map[int]string)
  359. secondClassifyNameEnMap := make(map[int]string)
  360. for _, v := range secondClassList {
  361. firstName := firstClassifyNameMap[v.ParentId]
  362. firstNameEn := firstClassifyNameEnMap[v.ParentId]
  363. if firstName != `` {
  364. firstName = firstName + " / "
  365. }
  366. if firstNameEn != `` {
  367. firstNameEn = firstNameEn + " / "
  368. }
  369. secondClassifyNameMap[v.ChartClassifyId] = firstName + v.ChartClassifyName
  370. secondClassifyNameEnMap[v.ChartClassifyId] = firstNameEn + v.ChartClassifyNameEn
  371. }
  372. for _, v := range tmpList {
  373. list = append(list, data_manage.MoveEdbChartList{
  374. DataId: strconv.Itoa(v.ChartInfoId),
  375. Name: v.ChartName,
  376. ClassifyName: secondClassifyNameMap[v.ChartClassifyId],
  377. NameEn: v.ChartNameEn,
  378. ClassifyNameEn: secondClassifyNameEnMap[v.ChartClassifyId],
  379. CreateUserId: v.SysUserId,
  380. CreateUserName: v.SysUserRealName,
  381. })
  382. }
  383. case 6: //ETA表格
  384. if keyword != `` {
  385. condition += " AND (excel_name like ? OR sys_user_real_name like ? ) "
  386. pars = utils.GetLikeKeywordPars(pars, keyword, 2)
  387. }
  388. if userId > 0 {
  389. condition += ` AND sys_user_id = ? `
  390. pars = append(pars, userId)
  391. }
  392. if classify != "" {
  393. condition += ` AND excel_classify_id IN (` + classify + `) `
  394. }
  395. condition += " AND source = ? "
  396. pars = append(pars, subSource)
  397. if subSource == utils.BALANCE_TABLE {
  398. condition += " AND parent_id = 0 AND balance_type = 0 "
  399. }
  400. total, err = excel.GetExcelInfoCountByCondition(condition, pars)
  401. if err != nil {
  402. return
  403. }
  404. tmpList, tmpErr := excel.GetNoContentExcelInfoListByCondition(condition, pars, startSize, pageSize)
  405. if tmpErr != nil {
  406. err = tmpErr
  407. return
  408. }
  409. // 获取所有的图表分类
  410. firstClassifyList, tmpErr := excel.GetExcelClassifyByParentId(0, subSource)
  411. if tmpErr != nil {
  412. err = tmpErr
  413. return
  414. }
  415. firstClassifyNameMap := make(map[int]string)
  416. for _, v := range firstClassifyList {
  417. firstClassifyNameMap[v.ExcelClassifyId] = v.ExcelClassifyName
  418. }
  419. secondClassList, tmpErr := excel.GetExcelClassifyBySource(subSource)
  420. if tmpErr != nil {
  421. err = tmpErr
  422. return
  423. }
  424. secondClassifyNameMap := make(map[int]string)
  425. for _, v := range secondClassList {
  426. firstName := firstClassifyNameMap[v.ParentId]
  427. if firstName != `` {
  428. firstName = firstName + " / "
  429. }
  430. secondClassifyNameMap[v.ExcelClassifyId] = firstName + v.ExcelClassifyName
  431. }
  432. for _, v := range tmpList {
  433. list = append(list, data_manage.MoveEdbChartList{
  434. DataId: strconv.Itoa(v.ExcelInfoId),
  435. Name: v.ExcelClassifyName,
  436. ClassifyName: secondClassifyNameMap[v.ExcelClassifyId],
  437. NameEn: v.ExcelClassifyName,
  438. ClassifyNameEn: secondClassifyNameMap[v.ExcelClassifyId],
  439. CreateUserId: v.SysUserId,
  440. CreateUserName: v.SysUserRealName,
  441. })
  442. }
  443. default:
  444. return
  445. }
  446. return
  447. }
  448. // MoveEdbChart 转移指标/图表创建人
  449. // @param source 来源 :1:手工数据指标 2:钢联化工数据库 3:ETA指标库 4:ETA预测指标 5:图库 6:ETA表格
  450. func MoveEdbChart(source, subSource, oldUserId, newUserId int, isSelectAll bool, dataId, noDataId []string, keyword, classify string, opUserId int, opUserName string) (err error, errMsg string) {
  451. adminInfo, err := system.GetSysAdminById(newUserId)
  452. if err != nil {
  453. return
  454. }
  455. // 如果勾选全部数据,那么
  456. if isSelectAll {
  457. // 找出不要的指标ID列表
  458. noDataIdMap := make(map[string]string, 0)
  459. for _, v := range noDataId {
  460. noDataIdMap[v] = v
  461. }
  462. // 需要转义的指标/图表ID列表
  463. dataId = make([]string, 0)
  464. // 获取所有指标/图表
  465. list, _, tmpErr := GetMoveEdbChartList(source, subSource, oldUserId, keyword, classify, 0, 100000)
  466. if tmpErr != nil {
  467. err = tmpErr
  468. return
  469. }
  470. for _, v := range list {
  471. if _, ok := noDataIdMap[v.DataId]; !ok {
  472. dataId = append(dataId, v.DataId)
  473. }
  474. }
  475. }
  476. // 操作记录
  477. dataPermissionMoveRecordList := make([]*data_manage_permission.DataPermissionMoveRecord, 0)
  478. uniqueCode := uuid.NewUUID().Hex32()
  479. title := `资产转移`
  480. content := `资产转入`
  481. switch source {
  482. case 1: //手工数据指标
  483. content += `(手工指标数据)`
  484. tmpList, tmpErr := models.GetEdbinfoListByCodeListByCodeIdList(dataId)
  485. if tmpErr != nil {
  486. err = tmpErr
  487. return
  488. }
  489. if len(tmpList) > 0 {
  490. for _, v := range tmpList {
  491. //if v.UserId == newUserId {
  492. // errMsg = "新创建人不可和原创建人一致"
  493. // err = errors.New(errMsg)
  494. // return
  495. //}
  496. // 操作记录
  497. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  498. DataPermissionMoveRecordId: 0,
  499. Source: int32(source),
  500. SubSource: int32(subSource),
  501. OpUniqueCode: uniqueCode,
  502. DataId: v.TradeCode,
  503. DataCode: v.TradeCode,
  504. DataName: v.SecName,
  505. OriginalUserId: int32(v.UserId),
  506. OriginalUserName: v.UserName,
  507. NewUserId: int32(adminInfo.AdminId),
  508. NewUserName: adminInfo.RealName,
  509. CreateTime: time.Now(),
  510. })
  511. }
  512. // 修改创建人
  513. err = models.ModifyEdbinfoUserIdByCodeList(dataId, newUserId, adminInfo.RealName)
  514. // 如果移动成功了,需要记录该指标的操作记录
  515. if err == nil && len(tmpList) > 0 {
  516. go afterMoveManualEdb(tmpList, adminInfo, opUserId, opUserName)
  517. }
  518. }
  519. case 2: //钢联化工数据库
  520. content += `(钢联化工数据库)`
  521. tmpList, tmpErr := data_manage.GetMysteelChemicalIndexListByIndexId(dataId)
  522. if tmpErr != nil {
  523. err = tmpErr
  524. return
  525. }
  526. if len(tmpList) > 0 {
  527. for _, v := range tmpList {
  528. //if v.SysUserId == newUserId {
  529. // errMsg = "新创建人不可和原创建人一致"
  530. // err = errors.New(errMsg)
  531. // return
  532. //}
  533. // 操作记录
  534. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  535. DataPermissionMoveRecordId: 0,
  536. Source: int32(source),
  537. SubSource: int32(subSource),
  538. OpUniqueCode: uniqueCode,
  539. DataId: fmt.Sprint(v.BaseFromMysteelChemicalIndexId),
  540. DataCode: v.IndexCode,
  541. DataName: v.IndexName,
  542. OriginalUserId: int32(v.SysUserId),
  543. OriginalUserName: v.SysUserRealName,
  544. NewUserId: int32(adminInfo.AdminId),
  545. NewUserName: adminInfo.RealName,
  546. CreateTime: time.Now(),
  547. })
  548. }
  549. // 修改创建人
  550. err = data_manage.ModifyMysteelChemicalIndexUserIdByCodeList(dataId, adminInfo.AdminId, adminInfo.RealName)
  551. }
  552. case 3, 4: //ETA指标库、ETA预测指标
  553. if source == 3 {
  554. content += `(ETA指标库)`
  555. } else {
  556. content += `(ETA预测指标)`
  557. }
  558. tmpList, tmpErr := data_manage.GetEdbInfoListByEdbInfoId(dataId)
  559. if tmpErr != nil {
  560. err = tmpErr
  561. return
  562. }
  563. if len(tmpList) > 0 {
  564. for _, v := range tmpList {
  565. //if v.SysUserId == newUserId {
  566. // errMsg = "新创建人不可和原创建人一致"
  567. // err = errors.New(errMsg)
  568. // return
  569. //}
  570. // 操作记录
  571. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  572. DataPermissionMoveRecordId: 0,
  573. Source: int32(source),
  574. SubSource: int32(subSource),
  575. OpUniqueCode: uniqueCode,
  576. DataId: fmt.Sprint(v.EdbInfoId),
  577. DataCode: v.EdbCode,
  578. DataName: v.EdbName,
  579. OriginalUserId: int32(v.SysUserId),
  580. OriginalUserName: v.SysUserRealName,
  581. NewUserId: int32(adminInfo.AdminId),
  582. NewUserName: adminInfo.RealName,
  583. CreateTime: time.Now(),
  584. })
  585. }
  586. // 修改创建人
  587. err = data_manage.ModifyEdbInfoUserIdByCodeList(dataId, adminInfo.AdminId, adminInfo.RealName)
  588. // 移除当前用户的不可操作权限
  589. {
  590. obj := data_manage.EdbInfoNoPermissionAdmin{}
  591. for _, v := range dataId {
  592. edbInfoId, _ := strconv.Atoi(v)
  593. go obj.DeleteByEdbInfoIdAndAdminId(edbInfoId, adminInfo.AdminId)
  594. }
  595. }
  596. }
  597. case 5: //图库
  598. content += `(ETA图库)`
  599. // 只展示eta图库
  600. subSource = utils.CHART_SOURCE_DEFAULT
  601. tmpList, tmpErr := data_manage.GetChartInfoListByChartIdList(dataId)
  602. if tmpErr != nil {
  603. err = tmpErr
  604. return
  605. }
  606. if len(tmpList) > 0 {
  607. for _, v := range tmpList {
  608. //if v.SysUserId == newUserId {
  609. // errMsg = "新创建人不可和原创建人一致"
  610. // err = errors.New(errMsg)
  611. // return
  612. //}
  613. // 操作记录
  614. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  615. DataPermissionMoveRecordId: 0,
  616. Source: int32(source),
  617. SubSource: int32(subSource),
  618. OpUniqueCode: uniqueCode,
  619. DataId: fmt.Sprint(v.ChartInfoId),
  620. DataCode: fmt.Sprint(v.ChartInfoId),
  621. DataName: v.ChartName,
  622. OriginalUserId: int32(v.SysUserId),
  623. OriginalUserName: v.SysUserRealName,
  624. NewUserId: int32(adminInfo.AdminId),
  625. NewUserName: adminInfo.RealName,
  626. CreateTime: time.Now(),
  627. })
  628. }
  629. // 修改创建人
  630. err = data_manage.ModifyChartInfoUserIdByCodeList(dataId, adminInfo.AdminId, adminInfo.RealName)
  631. }
  632. case 6: // ETA表格
  633. content += `(ETA表格)`
  634. tmpList, tmpErr := excel.GetNoContentExcelListByExcelInfoIdList(dataId)
  635. if tmpErr != nil {
  636. err = tmpErr
  637. return
  638. }
  639. if len(tmpList) > 0 {
  640. for _, v := range tmpList {
  641. //if v.SysUserId == newUserId {
  642. // errMsg = "新创建人不可和原创建人一致"
  643. // err = errors.New(errMsg)
  644. // return
  645. //}
  646. // 操作记录
  647. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  648. DataPermissionMoveRecordId: 0,
  649. Source: int32(source),
  650. SubSource: int32(subSource),
  651. OpUniqueCode: uniqueCode,
  652. DataId: fmt.Sprint(v.ExcelInfoId),
  653. DataCode: fmt.Sprint(v.ExcelInfoId),
  654. DataName: v.ExcelName,
  655. OriginalUserId: int32(v.SysUserId),
  656. OriginalUserName: v.SysUserRealName,
  657. NewUserId: int32(adminInfo.AdminId),
  658. NewUserName: adminInfo.RealName,
  659. CreateTime: time.Now(),
  660. })
  661. }
  662. // 修改创建人
  663. err = excel.ModifyExcelInfoUserIdByCodeList(dataId, adminInfo.AdminId, adminInfo.RealName)
  664. }
  665. default:
  666. return
  667. }
  668. // 转移失败了那么就直接返回了
  669. if err != nil {
  670. return
  671. }
  672. // 添加资产转移的记录
  673. dataPermissionMessage := &data_manage_permission.DataPermissionMessage{
  674. DataPermissionMessageId: 0,
  675. SendUserId: int32(opUserId),
  676. ReceiveUserId: int32(adminInfo.AdminId),
  677. Content: title,
  678. Remark: content,
  679. OpType: 1,
  680. Source: int32(source),
  681. SubSource: int32(subSource),
  682. OpUniqueCode: uniqueCode,
  683. IsRead: 0,
  684. CreateTime: time.Now(),
  685. ModifyTime: time.Now(),
  686. }
  687. tmpErr := data_manage_permission.AddDataPermissionMoveRecord(dataPermissionMoveRecordList, dataPermissionMessage)
  688. // 失败的话,日志记录
  689. if tmpErr != nil {
  690. // 序列化结构体为 JSON 数据
  691. recordListJsonBytes, tmpErr2 := json.Marshal(dataPermissionMoveRecordList)
  692. if tmpErr2 != nil {
  693. utils.FileLog.Error(fmt.Sprintf("添加资产转移的记录失败:%s;list转json失败:;操作记录:%+v;消息记录:%+v", tmpErr.Error(), dataPermissionMoveRecordList, dataPermissionMessage))
  694. return
  695. }
  696. // 序列化结构体为 JSON 数据
  697. messageJsonBytes, tmpErr2 := json.Marshal(dataPermissionMessage)
  698. if tmpErr2 != nil {
  699. utils.FileLog.Error(fmt.Sprintf("添加资产转移的记录失败:%s;message转json失败:;操作记录:%+v;消息记录:%+v", tmpErr.Error(), dataPermissionMoveRecordList, dataPermissionMessage))
  700. return
  701. }
  702. utils.FileLog.Error(fmt.Sprintf("添加资产转移的记录失败:%s;操作记录:%s;消息记录:%s", tmpErr.Error(), string(recordListJsonBytes), string(messageJsonBytes)))
  703. }
  704. return
  705. }
  706. // MoveAllEdbChartOld
  707. // @Description: 通过原创建人转移指标/图表创建人
  708. // @author: Roc
  709. // @datetime 2024-03-26 15:11:12
  710. // @param sourceList []int 1:手工数据指标 2:钢联化工数据库 3:ETA指标库 4:ETA预测指标 5:图库 6:ETA表格
  711. // @param oldUserId []int
  712. // @param userId int
  713. // @param opUserId int
  714. // @return err error
  715. // @return errMsg string
  716. func MoveAllEdbChartOld(sourceList, oldUserIdList []int, userId, opUserId int) (err error, errMsg string) {
  717. adminInfo, err := system.GetSysAdminById(userId)
  718. if err != nil {
  719. return
  720. }
  721. // 操作记录
  722. dataPermissionMoveRecordList := make([]*data_manage_permission.DataPermissionMoveRecord, 0)
  723. uniqueCode := uuid.NewUUID().Hex32()
  724. title := `资产转移`
  725. content := `资产转入`
  726. sourceStrList := make([]string, 0)
  727. for _, source := range sourceList {
  728. switch source {
  729. case 1: //手工数据指标
  730. sourceStrList = append(sourceStrList, "手工指标数据")
  731. tmpList, tmpErr := models.GetEdbinfoListByCodeListByUserId(oldUserIdList)
  732. if tmpErr != nil {
  733. err = tmpErr
  734. return
  735. }
  736. if len(tmpList) > 0 {
  737. for _, v := range tmpList {
  738. // 操作记录
  739. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  740. DataPermissionMoveRecordId: 0,
  741. Source: int32(source),
  742. SubSource: 0,
  743. OpUniqueCode: uniqueCode,
  744. DataId: v.TradeCode,
  745. DataCode: v.TradeCode,
  746. DataName: v.SecName,
  747. OriginalUserId: int32(v.UserId),
  748. OriginalUserName: v.UserName,
  749. NewUserId: int32(adminInfo.AdminId),
  750. NewUserName: adminInfo.RealName,
  751. CreateTime: time.Now(),
  752. })
  753. }
  754. // 修改创建人
  755. err = models.ModifyEdbinfoUserIdByOldUserId(oldUserIdList, userId)
  756. }
  757. case 2: //钢联化工数据库
  758. sourceStrList = append(sourceStrList, "钢联化工数据库")
  759. tmpList, tmpErr := data_manage.GetMysteelChemicalIndexListByUserId(oldUserIdList)
  760. if tmpErr != nil {
  761. err = tmpErr
  762. return
  763. }
  764. if len(tmpList) > 0 {
  765. for _, v := range tmpList {
  766. //if v.SysUserId == newUserId {
  767. // errMsg = "新创建人不可和原创建人一致"
  768. // err = errors.New(errMsg)
  769. // return
  770. //}
  771. // 操作记录
  772. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  773. DataPermissionMoveRecordId: 0,
  774. Source: int32(source),
  775. SubSource: 0,
  776. OpUniqueCode: uniqueCode,
  777. DataId: fmt.Sprint(v.BaseFromMysteelChemicalIndexId),
  778. DataCode: v.IndexCode,
  779. DataName: v.IndexName,
  780. OriginalUserId: int32(v.SysUserId),
  781. OriginalUserName: v.SysUserRealName,
  782. NewUserId: int32(adminInfo.AdminId),
  783. NewUserName: adminInfo.RealName,
  784. CreateTime: time.Now(),
  785. })
  786. }
  787. // 修改创建人
  788. err = data_manage.ModifyMysteelChemicalIndexUserIdByOldUserId(oldUserIdList, adminInfo.AdminId, adminInfo.RealName)
  789. }
  790. case 3: //ETA指标库
  791. sourceStrList = append(sourceStrList, "ETA指标库")
  792. edbInfoType := 0
  793. tmpList, tmpErr := data_manage.GetEdbInfoListByUserId(oldUserIdList, edbInfoType)
  794. if tmpErr != nil {
  795. err = tmpErr
  796. return
  797. }
  798. if len(tmpList) > 0 {
  799. for _, v := range tmpList {
  800. // 操作记录
  801. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  802. DataPermissionMoveRecordId: 0,
  803. Source: int32(source),
  804. SubSource: int32(edbInfoType),
  805. OpUniqueCode: uniqueCode,
  806. DataId: fmt.Sprint(v.EdbInfoId),
  807. DataCode: v.EdbCode,
  808. DataName: v.EdbName,
  809. OriginalUserId: int32(v.SysUserId),
  810. OriginalUserName: v.SysUserRealName,
  811. NewUserId: int32(adminInfo.AdminId),
  812. NewUserName: adminInfo.RealName,
  813. CreateTime: time.Now(),
  814. })
  815. }
  816. // 修改创建人
  817. err = data_manage.ModifyEdbInfoUserIdByOldUserId(oldUserIdList, edbInfoType, adminInfo.AdminId, adminInfo.RealName)
  818. }
  819. case 4: //ETA预测指标
  820. sourceStrList = append(sourceStrList, "ETA预测指标")
  821. edbInfoType := 1
  822. tmpList, tmpErr := data_manage.GetEdbInfoListByUserId(oldUserIdList, edbInfoType)
  823. if tmpErr != nil {
  824. err = tmpErr
  825. return
  826. }
  827. if len(tmpList) > 0 {
  828. for _, v := range tmpList {
  829. // 操作记录
  830. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  831. DataPermissionMoveRecordId: 0,
  832. Source: int32(source),
  833. SubSource: int32(edbInfoType),
  834. OpUniqueCode: uniqueCode,
  835. DataId: fmt.Sprint(v.EdbInfoId),
  836. DataCode: v.EdbCode,
  837. DataName: v.EdbName,
  838. OriginalUserId: int32(v.SysUserId),
  839. OriginalUserName: v.SysUserRealName,
  840. NewUserId: int32(adminInfo.AdminId),
  841. NewUserName: adminInfo.RealName,
  842. CreateTime: time.Now(),
  843. })
  844. }
  845. // 修改创建人
  846. err = data_manage.ModifyEdbInfoUserIdByOldUserId(oldUserIdList, edbInfoType, adminInfo.AdminId, adminInfo.RealName)
  847. }
  848. case 5: //ETA图库
  849. sourceStrList = append(sourceStrList, "ETA图库")
  850. // 只展示eta图库
  851. subSource := utils.CHART_SOURCE_DEFAULT
  852. tmpList, tmpErr := data_manage.GetChartInfoListByUserId(oldUserIdList, subSource)
  853. if tmpErr != nil {
  854. err = tmpErr
  855. return
  856. }
  857. if len(tmpList) > 0 {
  858. for _, v := range tmpList {
  859. // 操作记录
  860. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  861. DataPermissionMoveRecordId: 0,
  862. Source: int32(source),
  863. SubSource: int32(subSource),
  864. OpUniqueCode: uniqueCode,
  865. DataId: fmt.Sprint(v.ChartInfoId),
  866. DataCode: fmt.Sprint(v.ChartInfoId),
  867. DataName: v.ChartName,
  868. OriginalUserId: int32(v.SysUserId),
  869. OriginalUserName: v.SysUserRealName,
  870. NewUserId: int32(adminInfo.AdminId),
  871. NewUserName: adminInfo.RealName,
  872. CreateTime: time.Now(),
  873. })
  874. }
  875. // 修改创建人
  876. err = data_manage.ModifyChartInfoUserIdByOldUserId(oldUserIdList, adminInfo.AdminId, adminInfo.RealName)
  877. }
  878. case 6: // ETA表格
  879. sourceStrList = append(sourceStrList, "ETA表格")
  880. tmpList, tmpErr := excel.GetNoContentExcelListByUserId(oldUserIdList)
  881. if tmpErr != nil {
  882. err = tmpErr
  883. return
  884. }
  885. if len(tmpList) > 0 {
  886. for _, v := range tmpList {
  887. // 操作记录
  888. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  889. DataPermissionMoveRecordId: 0,
  890. Source: int32(source),
  891. SubSource: int32(v.Source),
  892. OpUniqueCode: uniqueCode,
  893. DataId: fmt.Sprint(v.ExcelInfoId),
  894. DataCode: fmt.Sprint(v.ExcelInfoId),
  895. DataName: v.ExcelName,
  896. OriginalUserId: int32(v.SysUserId),
  897. OriginalUserName: v.SysUserRealName,
  898. NewUserId: int32(adminInfo.AdminId),
  899. NewUserName: adminInfo.RealName,
  900. CreateTime: time.Now(),
  901. })
  902. }
  903. // 修改创建人
  904. err = excel.ModifyExcelInfoUserIdByOldUserId(oldUserIdList, adminInfo.AdminId, adminInfo.RealName)
  905. }
  906. default:
  907. }
  908. // 转移失败了那么就直接返回了
  909. if err != nil {
  910. return
  911. }
  912. }
  913. content += fmt.Sprintf("(%s)", strings.Join(sourceStrList, ","))
  914. // 添加资产转移的记录
  915. dataPermissionMessage := &data_manage_permission.DataPermissionMessage{
  916. DataPermissionMessageId: 0,
  917. SendUserId: int32(opUserId),
  918. ReceiveUserId: int32(adminInfo.AdminId),
  919. Content: title,
  920. Remark: content,
  921. OpType: 2,
  922. OpUniqueCode: uniqueCode,
  923. IsRead: 0,
  924. CreateTime: time.Now(),
  925. ModifyTime: time.Now(),
  926. }
  927. tmpErr := data_manage_permission.AddDataPermissionMoveRecord(dataPermissionMoveRecordList, dataPermissionMessage)
  928. // 失败的话,日志记录
  929. if tmpErr != nil {
  930. // 序列化结构体为 JSON 数据
  931. recordListJsonBytes, tmpErr2 := json.Marshal(dataPermissionMoveRecordList)
  932. if tmpErr2 != nil {
  933. utils.FileLog.Error(fmt.Sprintf("添加资产转移的记录失败:%s;list转json失败:;操作记录:%+v;消息记录:%+v", tmpErr.Error(), dataPermissionMoveRecordList, dataPermissionMessage))
  934. return
  935. }
  936. // 序列化结构体为 JSON 数据
  937. messageJsonBytes, tmpErr2 := json.Marshal(dataPermissionMessage)
  938. if tmpErr2 != nil {
  939. utils.FileLog.Error(fmt.Sprintf("添加资产转移的记录失败:%s;message转json失败:;操作记录:%+v;消息记录:%+v", tmpErr.Error(), dataPermissionMoveRecordList, dataPermissionMessage))
  940. return
  941. }
  942. utils.FileLog.Error(fmt.Sprintf("添加资产转移的记录失败:%s;操作记录:%s;消息记录:%s", tmpErr.Error(), string(recordListJsonBytes), string(messageJsonBytes)))
  943. }
  944. return
  945. }
  946. // MoveAllEdbChart
  947. // @Description: 通过原创建人转移指标/图表创建人
  948. // @author: Roc
  949. // @datetime 2024-03-26 15:11:12
  950. // @param sourceList []int 1:手工数据指标 2:钢联化工数据库 3:ETA指标库 4:ETA预测指标 5:图库 6:ETA表格
  951. // @param oldUserId []int
  952. // @param userId int
  953. // @param opUserId int
  954. // @return err error
  955. // @return errMsg string
  956. func MoveAllEdbChart(sourceList, oldUserIdList []int, userId, opUserId int) (err error, errMsg string) {
  957. adminInfo, err := system.GetSysAdminById(userId)
  958. if err != nil {
  959. return
  960. }
  961. // 操作记录
  962. dataPermissionMoveRecordList := make([]*data_manage_permission.DataPermissionMoveRecord, 0)
  963. uniqueCode := uuid.NewUUID().Hex32()
  964. title := `资产转移`
  965. content := `资产转入`
  966. sourceStrList := make([]string, 0)
  967. var isMoveManual, isMoveMysteelChemical, isMoveEdb, isMovePredictEdb, isMoveChart, isMoveExcel bool
  968. // 遍历需要转移的模块,1:手工数据指标 2:钢联化工数据库 3:ETA指标库 4:ETA预测指标 5:图库 6:ETA表格,并找出当前需要转移的资产
  969. for _, source := range sourceList {
  970. switch source {
  971. case 1: //手工数据指标
  972. sourceStrList = append(sourceStrList, "手工指标数据")
  973. tmpList, tmpErr := models.GetEdbinfoListByCodeListByUserId(oldUserIdList)
  974. if tmpErr != nil {
  975. err = tmpErr
  976. return
  977. }
  978. if len(tmpList) > 0 {
  979. for _, v := range tmpList {
  980. // 操作记录
  981. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  982. DataPermissionMoveRecordId: 0,
  983. Source: int32(source),
  984. SubSource: 0,
  985. OpUniqueCode: uniqueCode,
  986. DataId: v.TradeCode,
  987. DataCode: v.TradeCode,
  988. DataName: v.SecName,
  989. OriginalUserId: int32(v.UserId),
  990. OriginalUserName: v.UserName,
  991. NewUserId: int32(adminInfo.AdminId),
  992. NewUserName: adminInfo.RealName,
  993. CreateTime: time.Now(),
  994. })
  995. }
  996. isMoveManual = true
  997. }
  998. case 2: //钢联化工数据库
  999. sourceStrList = append(sourceStrList, "钢联化工数据库")
  1000. tmpList, tmpErr := data_manage.GetMysteelChemicalIndexListByUserId(oldUserIdList)
  1001. if tmpErr != nil {
  1002. err = tmpErr
  1003. return
  1004. }
  1005. if len(tmpList) > 0 {
  1006. for _, v := range tmpList {
  1007. //if v.SysUserId == newUserId {
  1008. // errMsg = "新创建人不可和原创建人一致"
  1009. // err = errors.New(errMsg)
  1010. // return
  1011. //}
  1012. // 操作记录
  1013. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  1014. DataPermissionMoveRecordId: 0,
  1015. Source: int32(source),
  1016. SubSource: 0,
  1017. OpUniqueCode: uniqueCode,
  1018. DataId: fmt.Sprint(v.BaseFromMysteelChemicalIndexId),
  1019. DataCode: v.IndexCode,
  1020. DataName: v.IndexName,
  1021. OriginalUserId: int32(v.SysUserId),
  1022. OriginalUserName: v.SysUserRealName,
  1023. NewUserId: int32(adminInfo.AdminId),
  1024. NewUserName: adminInfo.RealName,
  1025. CreateTime: time.Now(),
  1026. })
  1027. }
  1028. isMoveMysteelChemical = true
  1029. }
  1030. case 3: //ETA指标库
  1031. sourceStrList = append(sourceStrList, "ETA指标库")
  1032. edbInfoType := 0
  1033. tmpList, tmpErr := data_manage.GetEdbInfoListByUserId(oldUserIdList, edbInfoType)
  1034. if tmpErr != nil {
  1035. err = tmpErr
  1036. return
  1037. }
  1038. if len(tmpList) > 0 {
  1039. for _, v := range tmpList {
  1040. // 操作记录
  1041. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  1042. DataPermissionMoveRecordId: 0,
  1043. Source: int32(source),
  1044. SubSource: int32(edbInfoType),
  1045. OpUniqueCode: uniqueCode,
  1046. DataId: fmt.Sprint(v.EdbInfoId),
  1047. DataCode: v.EdbCode,
  1048. DataName: v.EdbName,
  1049. OriginalUserId: int32(v.SysUserId),
  1050. OriginalUserName: v.SysUserRealName,
  1051. NewUserId: int32(adminInfo.AdminId),
  1052. NewUserName: adminInfo.RealName,
  1053. CreateTime: time.Now(),
  1054. })
  1055. }
  1056. isMoveEdb = true
  1057. }
  1058. case 4: //ETA预测指标
  1059. sourceStrList = append(sourceStrList, "ETA预测指标")
  1060. edbInfoType := 1
  1061. tmpList, tmpErr := data_manage.GetEdbInfoListByUserId(oldUserIdList, edbInfoType)
  1062. if tmpErr != nil {
  1063. err = tmpErr
  1064. return
  1065. }
  1066. if len(tmpList) > 0 {
  1067. for _, v := range tmpList {
  1068. // 操作记录
  1069. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  1070. DataPermissionMoveRecordId: 0,
  1071. Source: int32(source),
  1072. SubSource: int32(edbInfoType),
  1073. OpUniqueCode: uniqueCode,
  1074. DataId: fmt.Sprint(v.EdbInfoId),
  1075. DataCode: v.EdbCode,
  1076. DataName: v.EdbName,
  1077. OriginalUserId: int32(v.SysUserId),
  1078. OriginalUserName: v.SysUserRealName,
  1079. NewUserId: int32(adminInfo.AdminId),
  1080. NewUserName: adminInfo.RealName,
  1081. CreateTime: time.Now(),
  1082. })
  1083. }
  1084. isMovePredictEdb = true
  1085. }
  1086. case 5: //ETA图库
  1087. sourceStrList = append(sourceStrList, "ETA图库")
  1088. // 只展示eta图库
  1089. subSource := utils.CHART_SOURCE_DEFAULT
  1090. tmpList, tmpErr := data_manage.GetChartInfoListByUserId(oldUserIdList, subSource)
  1091. if tmpErr != nil {
  1092. err = tmpErr
  1093. return
  1094. }
  1095. if len(tmpList) > 0 {
  1096. for _, v := range tmpList {
  1097. // 操作记录
  1098. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  1099. DataPermissionMoveRecordId: 0,
  1100. Source: int32(source),
  1101. SubSource: int32(subSource),
  1102. OpUniqueCode: uniqueCode,
  1103. DataId: fmt.Sprint(v.ChartInfoId),
  1104. DataCode: fmt.Sprint(v.ChartInfoId),
  1105. DataName: v.ChartName,
  1106. OriginalUserId: int32(v.SysUserId),
  1107. OriginalUserName: v.SysUserRealName,
  1108. NewUserId: int32(adminInfo.AdminId),
  1109. NewUserName: adminInfo.RealName,
  1110. CreateTime: time.Now(),
  1111. })
  1112. }
  1113. isMoveChart = true
  1114. }
  1115. case 6: // ETA表格
  1116. sourceStrList = append(sourceStrList, "ETA表格")
  1117. tmpList, tmpErr := excel.GetNoContentExcelListByUserId(oldUserIdList)
  1118. if tmpErr != nil {
  1119. err = tmpErr
  1120. return
  1121. }
  1122. if len(tmpList) > 0 {
  1123. for _, v := range tmpList {
  1124. // 操作记录
  1125. dataPermissionMoveRecordList = append(dataPermissionMoveRecordList, &data_manage_permission.DataPermissionMoveRecord{
  1126. DataPermissionMoveRecordId: 0,
  1127. Source: int32(source),
  1128. SubSource: int32(v.Source),
  1129. OpUniqueCode: uniqueCode,
  1130. DataId: fmt.Sprint(v.ExcelInfoId),
  1131. DataCode: fmt.Sprint(v.ExcelInfoId),
  1132. DataName: v.ExcelName,
  1133. OriginalUserId: int32(v.SysUserId),
  1134. OriginalUserName: v.SysUserRealName,
  1135. NewUserId: int32(adminInfo.AdminId),
  1136. NewUserName: adminInfo.RealName,
  1137. CreateTime: time.Now(),
  1138. })
  1139. }
  1140. isMoveExcel = true
  1141. }
  1142. default:
  1143. }
  1144. }
  1145. // 修改创建人
  1146. err = data_manage_permission.ModifyDataUserIdByOldUserId(oldUserIdList, adminInfo.AdminId, adminInfo.RealName, isMoveManual, isMoveMysteelChemical, isMoveEdb, isMovePredictEdb, isMoveChart, isMoveExcel)
  1147. // 转移失败了那么就直接返回了
  1148. if err != nil {
  1149. return
  1150. }
  1151. // 添加资产转移的记录
  1152. content += fmt.Sprintf("(%s)", strings.Join(sourceStrList, ","))
  1153. dataPermissionMessage := &data_manage_permission.DataPermissionMessage{
  1154. DataPermissionMessageId: 0,
  1155. SendUserId: int32(opUserId),
  1156. ReceiveUserId: int32(adminInfo.AdminId),
  1157. Content: title,
  1158. Remark: content,
  1159. OpType: 2,
  1160. OpUniqueCode: uniqueCode,
  1161. IsRead: 0,
  1162. CreateTime: time.Now(),
  1163. ModifyTime: time.Now(),
  1164. }
  1165. tmpErr := data_manage_permission.AddDataPermissionMoveRecord(dataPermissionMoveRecordList, dataPermissionMessage)
  1166. // 失败的话,日志记录
  1167. if tmpErr != nil {
  1168. // 序列化结构体为 JSON 数据
  1169. recordListJsonBytes, tmpErr2 := json.Marshal(dataPermissionMoveRecordList)
  1170. if tmpErr2 != nil {
  1171. utils.FileLog.Error(fmt.Sprintf("添加资产转移的记录失败:%s;list转json失败:;操作记录:%+v;消息记录:%+v", tmpErr.Error(), dataPermissionMoveRecordList, dataPermissionMessage))
  1172. return
  1173. }
  1174. // 序列化结构体为 JSON 数据
  1175. messageJsonBytes, tmpErr2 := json.Marshal(dataPermissionMessage)
  1176. if tmpErr2 != nil {
  1177. utils.FileLog.Error(fmt.Sprintf("添加资产转移的记录失败:%s;message转json失败:;操作记录:%+v;消息记录:%+v", tmpErr.Error(), dataPermissionMoveRecordList, dataPermissionMessage))
  1178. return
  1179. }
  1180. utils.FileLog.Error(fmt.Sprintf("添加资产转移的记录失败:%s;操作记录:%s;消息记录:%s", tmpErr.Error(), string(recordListJsonBytes), string(messageJsonBytes)))
  1181. }
  1182. return
  1183. }
  1184. // GetMoveEdbChartCount 获取待转移的指标/图表列表
  1185. // @param userId 用户
  1186. // @param countType 来源 :1:设置资产权限;2:设置数据权限
  1187. func GetMoveEdbChartCount(userId, countType int) (sourceMap map[int]int, err error) {
  1188. sourceMap = make(map[int]int)
  1189. {
  1190. // 手工数据指标
  1191. var condition string
  1192. var pars []interface{}
  1193. if userId > 0 {
  1194. condition += ` AND a.user_id = ? `
  1195. pars = append(pars, userId)
  1196. }
  1197. total, tmpErr := models.GetEdbinfoListCount(condition, pars, "", 0)
  1198. if tmpErr != nil {
  1199. err = tmpErr
  1200. return
  1201. }
  1202. sourceMap[1] = total
  1203. }
  1204. {
  1205. // 钢联化工数据库
  1206. var condition string
  1207. var pars []interface{}
  1208. if userId > 0 {
  1209. condition += ` AND sys_user_id = ? `
  1210. pars = append(pars, userId)
  1211. }
  1212. total, tmpErr := data_manage.GetMysteelChemicalIndexCount(condition, pars)
  1213. if tmpErr != nil {
  1214. err = tmpErr
  1215. return
  1216. }
  1217. sourceMap[2] = total
  1218. }
  1219. {
  1220. // ETA指标库
  1221. var condition string
  1222. var pars []interface{}
  1223. if userId > 0 {
  1224. condition += ` AND sys_user_id = ? `
  1225. pars = append(pars, userId)
  1226. }
  1227. //ETA指标库
  1228. condition += ` AND edb_info_type = ? `
  1229. pars = append(pars, 0)
  1230. total, tmpErr := data_manage.GetEdbInfoByConditionCount(condition, pars)
  1231. if tmpErr != nil {
  1232. err = tmpErr
  1233. return
  1234. }
  1235. sourceMap[3] = total
  1236. }
  1237. {
  1238. // ETA预测指标库
  1239. var condition string
  1240. var pars []interface{}
  1241. if userId > 0 {
  1242. condition += ` AND sys_user_id = ? `
  1243. pars = append(pars, userId)
  1244. }
  1245. //ETA预测指标
  1246. condition += ` AND edb_info_type = ? `
  1247. pars = append(pars, 1)
  1248. total, tmpErr := data_manage.GetEdbInfoByConditionCount(condition, pars)
  1249. if tmpErr != nil {
  1250. err = tmpErr
  1251. return
  1252. }
  1253. sourceMap[4] = total
  1254. }
  1255. {
  1256. // 图库
  1257. var condition string
  1258. var pars []interface{}
  1259. if userId > 0 {
  1260. condition += ` AND sys_user_id = ? `
  1261. pars = append(pars, userId)
  1262. }
  1263. total, tmpErr := data_manage.GetChartInfoCountByCondition(condition, pars)
  1264. if tmpErr != nil {
  1265. err = tmpErr
  1266. return
  1267. }
  1268. sourceMap[5] = total
  1269. }
  1270. {
  1271. // ETA表格
  1272. var condition string
  1273. var pars []interface{}
  1274. condition += ` AND is_delete = 0 `
  1275. if userId > 0 {
  1276. condition += ` AND sys_user_id = ? `
  1277. pars = append(pars, userId)
  1278. }
  1279. switch countType {
  1280. case 2:
  1281. condition += ` AND source in (2,3) `
  1282. default:
  1283. condition += ` AND source in (2,3,4) `
  1284. }
  1285. total, tmpErr := excel.GetExcelInfoCountByCondition(condition, pars)
  1286. if tmpErr != nil {
  1287. err = tmpErr
  1288. return
  1289. }
  1290. sourceMap[6] = total
  1291. }
  1292. return
  1293. }
  1294. // afterMoveManualEdb
  1295. // @Description: 手工数据移动后的操作
  1296. // @author: Roc
  1297. // @datetime 2024-08-01 13:55:59
  1298. // @param tmpList []*models.Edbinfo
  1299. // @param adminInfo *system.Admin
  1300. // @param opUserId int
  1301. // @param opUserName string
  1302. func afterMoveManualEdb(tmpList []*models.Edbinfo, adminInfo *system.Admin, opUserId int, opUserName string) {
  1303. recordList := make([]*models.EdbinfoOpRecord, 0)
  1304. for _, tmpManualInfo := range tmpList {
  1305. remark := fmt.Sprintf("数据资产由%s转移给%s", tmpManualInfo.UserName, adminInfo.RealName)
  1306. recordList = append(recordList, &models.EdbinfoOpRecord{
  1307. TradeCode: tmpManualInfo.TradeCode,
  1308. Remark: remark,
  1309. UserId: opUserId,
  1310. UserName: opUserName,
  1311. CreateTime: time.Now(),
  1312. })
  1313. }
  1314. obj := models.EdbinfoOpRecord{}
  1315. _ = obj.MulCreate(recordList)
  1316. }