tree_service.go 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575
  1. /*
  2. * @description:层级文件夹数据操作相关
  3. * @Author: CP
  4. * @Date: 2020-09-11 14:43:58
  5. * @FilePath: \construction_management\services\tree_service.go
  6. */
  7. package services
  8. import (
  9. "encoding/json"
  10. "errors"
  11. "fmt"
  12. "log"
  13. "strconv"
  14. "time"
  15. "github.com/kataras/iris/v12"
  16. "go.mod/comm"
  17. "go.mod/conf"
  18. "go.mod/dao"
  19. "go.mod/datasource"
  20. "go.mod/models"
  21. "go.mod/web/viewmodels"
  22. )
  23. //定义项目Service接口
  24. type TreeService interface {
  25. //ValidManager(code string, account string, password string) error
  26. ValidRule(ctx iris.Context) (viewmodels.Tree, error)
  27. ValidRuleBidsectionType(ctx iris.Context) (viewmodels.Permission, error)
  28. Create(data viewmodels.Tree) error
  29. GetAllProject(projectId int) *viewmodels.Tree
  30. GetAllContract(projectId int, account *models.CmProjectAccount, bidsectionType int) *viewmodels.FolderContract
  31. Rename(treevm viewmodels.Tree, projectId int) error
  32. GetFolderAndBid(id int, projectId int) ([]models.CmTree, error)
  33. DeleteFolderAndBid(id int, projectId int) error
  34. Move(id int, moveId int, projectId int) error
  35. }
  36. //返回service操作类
  37. type treeService struct {
  38. dao *dao.TreeDao
  39. permissionAccountDao *dao.PermissionAccountDao
  40. }
  41. //创建项目service
  42. func NewTreeService() TreeService {
  43. return &treeService{
  44. dao: dao.NewTreeDao(datasource.InstanceDbMaster()),
  45. permissionAccountDao: dao.NewPermissionAccountDao(datasource.InstanceDbMaster()),
  46. }
  47. }
  48. // 文件夹规则验证
  49. func (s *treeService) ValidRule(ctx iris.Context) (viewmodels.Tree, error) {
  50. folderVaild := viewmodels.Tree{}
  51. err := ctx.ReadJSON(&folderVaild)
  52. if err != nil {
  53. log.Println("folder-ValidRule-ReadForm转换异常, error=", err)
  54. return folderVaild, err
  55. }
  56. err = folderVaild.Validate()
  57. if err != nil {
  58. log.Println("文件夹验证, error=", err)
  59. return folderVaild, err
  60. }
  61. return folderVaild, nil
  62. }
  63. // 文件夹规则验证
  64. func (s *treeService) ValidRuleBidsectionType(ctx iris.Context) (viewmodels.Permission, error) {
  65. folderVaild := viewmodels.Permission{}
  66. err := ctx.ReadForm(&folderVaild)
  67. if err != nil {
  68. log.Println("folder-ValidRule-ReadForm转换异常, error=", err)
  69. return folderVaild, err
  70. }
  71. err = folderVaild.ValidateType()
  72. if err != nil {
  73. log.Println("请求标段类型验证, error=", err)
  74. return folderVaild, err
  75. }
  76. return folderVaild, nil
  77. }
  78. // 获得项目下 相关文件夹-整个树结构
  79. func (s *treeService) GetAllProject(projectId int) *viewmodels.Tree {
  80. datalist := s.dao.GetAllTree(projectId)
  81. folderlist := make([]*viewmodels.Tree, 0)
  82. // 生成根
  83. folder := &viewmodels.Tree{}
  84. id, _ := comm.AesEncrypt(strconv.Itoa(0), conf.SignSecret)
  85. parentId, _ := comm.AesEncrypt(strconv.Itoa(-1), conf.SignSecret)
  86. folder.Id = id
  87. folder.Name = "根目录"
  88. folder.Isfolder = 1
  89. folder.ParentId = parentId
  90. folder.Children = make([]*viewmodels.Tree, 0)
  91. folderlist = append(folderlist, folder)
  92. // 加入数据
  93. for _, data := range datalist {
  94. folder := &viewmodels.Tree{}
  95. //folder.Id = comm.Encrypt([]byte(conf.SignSecret), []byte(strconv.Itoa(data.Id)))
  96. id, _ := comm.AesEncrypt(strconv.Itoa(data.Id), conf.SignSecret)
  97. parentId, _ := comm.AesEncrypt(strconv.Itoa(data.ParentId), conf.SignSecret)
  98. projectId, _ := comm.AesEncrypt(strconv.Itoa(data.ProjectId), conf.SignSecret)
  99. serial, _ := comm.AesEncrypt(strconv.Itoa(data.Serial), conf.SignSecret)
  100. bidsectionId, _ := comm.AesEncrypt(strconv.Itoa(data.BidsectionId), conf.SignSecret)
  101. folder.Id = id
  102. folder.Name = data.Name
  103. folder.ParentId = parentId
  104. folder.ProjectId = projectId
  105. folder.BidsectionId = bidsectionId
  106. folder.Depth = data.Depth + 1
  107. folder.Serial = serial
  108. folder.Accounts = data.Accounts
  109. folder.Isfolder = data.Isfolder
  110. folder.IsEnd = false
  111. //folder.Leaf = true
  112. folder.HasFolder = false
  113. folder.IsBid = false
  114. folder.CreateTime = data.CreateTime.Format(conf.SysTimeform)
  115. folderlist = append(folderlist, folder)
  116. }
  117. //fmt.Println(folderlist)
  118. //var data []*viewmodels.Tree
  119. // data := make([]*viewmodels.Tree, 0)
  120. // for i, _ := range folderlist {
  121. // var a *viewmodels.Tree
  122. // a = &folderlist[i]
  123. // data = append(data, a)
  124. // }
  125. node := folderlist[0] //父节点
  126. maketree(folderlist, node) //调用生成tree
  127. //transformjson(node) //转化为json
  128. return node
  129. }
  130. // 获得合同管理的目录
  131. func (s *treeService) GetAllContract(projectId int, account *models.CmProjectAccount, bidsectionType int) *viewmodels.FolderContract {
  132. datalist := s.dao.GetAllTree(projectId)
  133. folderlist := make([]viewmodels.FolderContract, 0)
  134. // 2.获得该账号的权限
  135. permissionData := s.permissionAccountDao.GetProjectIdAccountId(projectId, account.Id)
  136. // 生成根
  137. folder := viewmodels.FolderContract{}
  138. id, _ := comm.AesEncrypt(strconv.Itoa(0), conf.SignSecret)
  139. parentId, _ := comm.AesEncrypt(strconv.Itoa(-1), conf.SignSecret)
  140. folder.Id = id
  141. folder.Name = "root"
  142. folder.ParentId = parentId
  143. folder.Isfolder = 1
  144. folder.Children = make([]*viewmodels.FolderContract, 0)
  145. folderlist = append(folderlist, folder)
  146. // 加入数据
  147. for _, data := range datalist {
  148. flag := true
  149. if data.BidsectionId != 0 && account.IsAdmin != 1 {
  150. flag = false
  151. }
  152. // 过滤没有权限访问的标段-管理员不需要过滤
  153. if data.BidsectionId != 0 && account.IsAdmin != 1 {
  154. permission := map[string]int{}
  155. for _, item := range permissionData {
  156. if data.BidsectionId == item.BidsectionId {
  157. // 区别合同,安全,质量
  158. if bidsectionType == 1 {
  159. json.Unmarshal([]byte(item.SafePermission), &permission)
  160. } else if bidsectionType == 2 {
  161. json.Unmarshal([]byte(item.QualityPermission), &permission)
  162. } else if bidsectionType == 0 {
  163. json.Unmarshal([]byte(item.ContractPermission), &permission)
  164. } else {
  165. return nil
  166. }
  167. if permission["access"] == 1 {
  168. flag = true
  169. }
  170. }
  171. }
  172. }
  173. if flag {
  174. folder := viewmodels.FolderContract{}
  175. id, _ := comm.AesEncrypt(strconv.Itoa(data.Id), conf.SignSecret)
  176. parentId, _ := comm.AesEncrypt(strconv.Itoa(data.ParentId), conf.SignSecret)
  177. projectId, _ := comm.AesEncrypt(strconv.Itoa(data.ProjectId), conf.SignSecret)
  178. bidsectionId, _ := comm.AesEncrypt(strconv.Itoa(data.BidsectionId), conf.SignSecret)
  179. folder.Id = id
  180. folder.Name = data.Name
  181. folder.ParentId = parentId
  182. folder.ProjectId = projectId
  183. folder.BidsectionId = bidsectionId
  184. // 合同数据
  185. folder.Contracts = data.Contracts
  186. folder.ContractsIncome = data.ContractsIncome
  187. folder.ContractsReturned = data.ContractsReturned
  188. // 汇款进度
  189. ContractsIncome, err := strconv.ParseFloat(data.ContractsIncome, 64)
  190. if err != nil {
  191. ContractsIncome = 0
  192. }
  193. ContractsReturned, err := strconv.ParseFloat(data.ContractsReturned, 64)
  194. if err != nil || ContractsReturned == 0 {
  195. ContractsReturned = 0
  196. folder.ContractsIncomeProgress = "0%"
  197. } else {
  198. folder.ContractsIncomeProgress = fmt.Sprintf("%.0f", (ContractsReturned/ContractsIncome)*100) + "%"
  199. }
  200. folder.ContractsPay = data.ContractsPay
  201. folder.ContractsPaid = data.ContractsPaid
  202. // 支付进度
  203. ContractsPay, err := strconv.ParseFloat(data.ContractsPay, 64)
  204. if err != nil {
  205. ContractsPay = 0
  206. }
  207. ContractsPaid, err := strconv.ParseFloat(data.ContractsPaid, 64)
  208. if err != nil || ContractsPaid == 0 {
  209. ContractsPaid = 0
  210. folder.ContractsPayProgress = "0%"
  211. } else {
  212. folder.ContractsPayProgress = fmt.Sprintf("%.0f", (ContractsPaid/ContractsPay)*100) + "%"
  213. }
  214. folder.Isfolder = data.Isfolder
  215. folder.IsEnd = false
  216. folder.HasFolder = false
  217. folder.IsBid = false
  218. folderlist = append(folderlist, folder)
  219. }
  220. }
  221. //fmt.Println(folderlist)
  222. var data []*viewmodels.FolderContract
  223. data = make([]*viewmodels.FolderContract, 0)
  224. for i, _ := range folderlist {
  225. var a *viewmodels.FolderContract
  226. a = &folderlist[i]
  227. data = append(data, a)
  228. }
  229. node := &folderlist[0] //父节点
  230. comm.MakeFolderContract(data, node)
  231. // 求和
  232. // dataLenght := len(data) + 4
  233. return node
  234. }
  235. // 新增一个文件夹
  236. func (s *treeService) Create(data viewmodels.Tree) error {
  237. // 类型校验
  238. folder := models.CmTree{}
  239. folder.Name = data.Name
  240. // 项目ID
  241. ProjectId, err := strconv.Atoi(data.ProjectId)
  242. if err != nil {
  243. return err
  244. }
  245. // 获得该目录ID
  246. Id, err := comm.AesDecrypt(data.Id, conf.SignSecret)
  247. if err != nil {
  248. return err
  249. }
  250. IdInt, err1 := strconv.Atoi(Id)
  251. if err1 != nil {
  252. return err1
  253. }
  254. // 该目录中是否有标段
  255. bidlist := s.dao.GetBidsection(IdInt)
  256. if len(bidlist) > 0 {
  257. return errors.New("该文件夹已存在标段,不能在新增目录")
  258. }
  259. // 获得该深度的文件夹最大序号
  260. serial := 0
  261. depth := data.Depth + 1
  262. if data.Depth == -1 {
  263. // 1-创建顶级目录--获得最大序号
  264. datalist := s.dao.GetAllDepth(depth, ProjectId)
  265. maxIndex := len(datalist)
  266. if maxIndex != 0 {
  267. serial = datalist[maxIndex-1].Serial + 1
  268. }
  269. } else {
  270. // 1-创建次目录-获得次级目录最大序号
  271. treeNode := s.dao.Get(IdInt, ProjectId)
  272. // 去除前端depth作用-在这里获得下级目录的深度
  273. depth = treeNode.Depth + 1
  274. if treeNode.Id == 0 {
  275. return errors.New("上级目录不正确")
  276. }
  277. attribution := fmt.Sprintf("%s%d-", treeNode.Attribution, treeNode.Serial)
  278. datalist := s.dao.GetALLDepthByAttribution(depth, ProjectId, attribution)
  279. maxIndex := len(datalist)
  280. if maxIndex != 0 {
  281. serial = datalist[maxIndex-1].Serial + 1
  282. }
  283. // 设置归属
  284. folder.Attribution = attribution //treeNode.Attribution + strconv.Itoa(treeNode.Serial) + "-"
  285. folder.ParentId = IdInt
  286. }
  287. folder.ProjectId = ProjectId
  288. folder.Serial = serial
  289. folder.Depth = depth
  290. folder.Isfolder = 1
  291. folder.CreateTime = time.Now()
  292. folder.UpdateTime = time.Now()
  293. folder.ContractsIncome = "0"
  294. folder.ContractsPaid = "0"
  295. folder.ContractsPay = "0"
  296. folder.ContractsReturned = "0"
  297. err = s.dao.Create(&folder)
  298. if err != nil {
  299. log.Println("添加目录出错, error=", err)
  300. return errors.New("添加目录出错")
  301. }
  302. return nil
  303. }
  304. // 重命名
  305. func (s *treeService) Rename(data viewmodels.Tree, projectId int) error {
  306. // 获得该目录ID
  307. Id, err := comm.AesDecrypt(data.Id, conf.SignSecret)
  308. if err != nil {
  309. return err
  310. }
  311. IdInt, err1 := strconv.Atoi(Id)
  312. if err1 != nil {
  313. return err1
  314. }
  315. // 获得树信息
  316. treeData := s.dao.Get(IdInt, projectId)
  317. if treeData.Id == 0 {
  318. return errors.New("修改的目录不合法")
  319. }
  320. treeNode := models.CmTree{}
  321. treeNode.Id = IdInt
  322. treeNode.Name = data.Name
  323. if treeData.Isfolder == 1 {
  324. // 目录
  325. err = s.dao.Update(&treeNode, []string{"Name"})
  326. } else {
  327. // 标段
  328. treeNode.BidsectionId = treeData.BidsectionId
  329. err = s.dao.Rename(&treeNode, []string{"Name"})
  330. }
  331. if err != nil {
  332. return err
  333. }
  334. return nil
  335. }
  336. // 获得该目录下所有的目录和标段
  337. func (s *treeService) GetFolderAndBid(id int, projectId int) ([]models.CmTree, error) {
  338. // 获得该目录ID
  339. // id, err := comm.AesDecrypt(id, conf.SignSecret)
  340. // if err != nil {
  341. // return nil, errors.New("目录解析错误")
  342. // }
  343. // IdInt, err := strconv.Atoi(id)
  344. // if err != nil {
  345. // return nil, errors.New("目录解析错误")
  346. // }
  347. // 获得该目录下所有数据
  348. folder := s.dao.Get(id, projectId)
  349. if folder.Id == 0 {
  350. return nil, errors.New("目录不合法")
  351. }
  352. attribution := fmt.Sprintf("%s%d-", folder.Attribution, folder.Serial)
  353. // 获得目录归属
  354. dataList := s.dao.GetFolderAndBid(folder.ProjectId, attribution)
  355. return dataList, nil
  356. }
  357. // 删除该目录和所属的目录和标段
  358. func (s *treeService) DeleteFolderAndBid(id int, projectId int) error {
  359. // 获得该目录ID
  360. // id, err := comm.AesDecrypt(id, conf.SignSecret)
  361. // if err != nil {
  362. // return errors.New("目录解析错误")
  363. // }
  364. // IdInt, err := strconv.Atoi(id)
  365. // if err != nil {
  366. // return errors.New("目录解析错误")
  367. // }
  368. // 获得该目录下 归属关系
  369. folder := s.dao.Get(id, projectId)
  370. if folder.Id == 0 {
  371. return errors.New("目录不合法")
  372. }
  373. attribution := fmt.Sprintf("%s%d-", folder.Attribution, folder.Serial)
  374. // --逻辑删除 目录和数据
  375. err := s.dao.DeleteFolderAndBid(folder.Id, folder.ProjectId, attribution)
  376. if err != nil {
  377. return err
  378. }
  379. // TODO -加入堆栈 物理删除数据
  380. return nil
  381. }
  382. // 移动目录
  383. func (s *treeService) Move(id int, moveId int, projectId int) error {
  384. // 获得项目目录
  385. treeNode := s.dao.Get(id, projectId)
  386. if treeNode.Id == 0 {
  387. return errors.New("目录或标段解析错误")
  388. }
  389. targetFolder := &models.CmTree{}
  390. // id为0是跟目录
  391. if moveId == 0 {
  392. // id
  393. targetFolder.Id = 0
  394. // 1.获得最大序号
  395. // seriallist := s.dao.GetALLDepthByAttribution(0, projectId, "")
  396. // maxIndex := len(seriallist)
  397. // serial := 0
  398. // if maxIndex != 0 {
  399. // serial = seriallist[maxIndex-1].Serial + 1
  400. // }
  401. // targetFolder.Serial = serial
  402. targetFolder.Serial = 0
  403. // 2.归属
  404. targetFolder.Attribution = ""
  405. // 3.深度depth-根目录为-1
  406. targetFolder.Depth = -1
  407. // 4.为目录
  408. targetFolder.Isfolder = 1
  409. // 5.项目ID
  410. targetFolder.ProjectId = projectId
  411. // fmt.Println(targetFolder)
  412. // if targetFolder.Id == 0 {
  413. // return errors.New("目录解析错误-测试")
  414. // }
  415. } else {
  416. targetFolder = s.dao.Get(moveId, projectId)
  417. if targetFolder.Id == 0 {
  418. return errors.New("目录解析错误")
  419. }
  420. }
  421. // 目录必须是目录
  422. if targetFolder.Isfolder == 0 {
  423. return errors.New("目标不是文件夹")
  424. }
  425. // 目录的目标不能是自己
  426. if id == moveId {
  427. return errors.New("目标目录是原目录-不能移动")
  428. }
  429. // 移动的是目录
  430. if treeNode.Isfolder == 1 {
  431. // 1.目录下不能有标段
  432. // 被移动的目录存在标段
  433. moveBidList := s.dao.GetBidsection(moveId)
  434. if len(moveBidList) > 0 {
  435. return errors.New("该目录中存在标段,不能移动")
  436. }
  437. } else {
  438. // 标段
  439. // 1.移动的目录是否为叶子节点
  440. moveBidList := s.dao.GetChildFolder(moveId)
  441. if len(moveBidList) > 0 {
  442. return errors.New("该目录中存在其他目录,不能移动")
  443. }
  444. }
  445. err := s.dao.Move(treeNode, targetFolder)
  446. if err != nil {
  447. return err
  448. }
  449. return nil
  450. }
  451. // 创建一颗树...interface{}
  452. func maketree(Data []*viewmodels.Tree, node *viewmodels.Tree) { //参数为父节点,添加父节点的子节点指针切片
  453. childs, _ := havechild(Data, node) //判断节点是否有子节点并返回
  454. if childs != nil {
  455. // fmt.Printf("\n")
  456. // fmt.Println(*node)
  457. // fmt.Println("子节点:")
  458. // for _, v := range childs {
  459. // fmt.Println(*v)
  460. // } //打印
  461. // 子节点总数
  462. Total := len(childs)
  463. node.ChildsTotal = Total
  464. // 标记最后一个元素
  465. end := Total - 1
  466. childs[end].IsEnd = true
  467. // 往父节点添加子节点
  468. node.Children = append(node.Children, childs[0:]...) //添加子节点
  469. for _, v := range childs { //查询子节点的子节点,并添加到子节点
  470. _, has := havechild(Data, v)
  471. if has {
  472. // 递归添加节点
  473. maketree(Data, v)
  474. }
  475. // else {
  476. // // 叶子节点
  477. // node.Leaf = false
  478. // }
  479. // 目录下是否包含标段
  480. if v.Isfolder == 0 {
  481. node.IsBid = true
  482. } else {
  483. node.HasFolder = true
  484. }
  485. }
  486. }
  487. }
  488. // 是否有子树
  489. func havechild(Data []*viewmodels.Tree, node *viewmodels.Tree) (child []*viewmodels.Tree, yes bool) {
  490. for _, v := range Data {
  491. if v.ParentId == node.Id {
  492. child = append(child, v)
  493. }
  494. }
  495. if child != nil {
  496. yes = true
  497. }
  498. return
  499. }
  500. func transformjson(Data *viewmodels.Tree) { //转为json
  501. Jsondata, _ := json.Marshal(Data)
  502. fmt.Println(string(Jsondata))
  503. }
  504. //now := comm.NowUnix()
  505. //comm.FormatFromUnixTime(now)
  506. // ParentIdInt := 0
  507. // if data.ParentId != "" {
  508. // ParentId, err := comm.AesDecrypt(data.ParentId, conf.SignSecret)
  509. // if err != nil {
  510. // return err
  511. // }
  512. // ParentIdInt, err = strconv.Atoi(ParentId)
  513. // if err != nil {
  514. // ParentIdInt = 0
  515. // }
  516. // }