ppt_group.go 49 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771
  1. package ppt
  2. import (
  3. "encoding/json"
  4. "errors"
  5. "eta/eta_api/models"
  6. "eta/eta_api/models/system"
  7. "eta/eta_api/utils"
  8. "fmt"
  9. "sort"
  10. "strconv"
  11. "strings"
  12. "time"
  13. )
  14. type PageContent struct {
  15. //Id int `json:"id"`
  16. Key int `json:"key"`
  17. ModelId int `json:"modelId"`
  18. Title string `json:"title"`
  19. Elements []PageContentElements `json:"elements"`
  20. }
  21. type PageContentElements struct {
  22. Type string `json:"type"`
  23. Position int `json:"position"`
  24. Content string `json:"content"`
  25. RichContent string `json:"richContent"`
  26. ChartId string `json:"chartId"`
  27. Src string `json:"src"`
  28. }
  29. // GetGroupsByAdminId 查询ppt目录列表
  30. func GetGroupsByAdminId(IsNewPpt, adminId int) (ret models.RespGroupList, err error) {
  31. publicGroups, err := models.GetPublicPptGroups()
  32. if err != nil {
  33. err = errors.New("公共目录查询出错:" + err.Error())
  34. return
  35. }
  36. privateGroups, err := models.GetPrivatePptGroups(adminId)
  37. if err != nil {
  38. err = errors.New("私有目录查询出错:" + err.Error())
  39. return
  40. }
  41. groupIds := make([]int64, 0)
  42. for _, v := range publicGroups {
  43. groupIds = append(groupIds, v.GroupId)
  44. }
  45. for _, v := range privateGroups {
  46. groupIds = append(groupIds, v.GroupId)
  47. }
  48. ret.PublicList = make([]*models.RespGroupListItem, 0)
  49. ret.PrivateList = make([]*models.RespGroupListItem, 0)
  50. if len(groupIds) == 0 {
  51. return
  52. }
  53. //整理目录数据
  54. for _, v := range publicGroups {
  55. tmp := new(models.RespGroupListItem)
  56. tmp.GroupId = v.GroupId
  57. tmp.GroupName = v.GroupName
  58. tmp.IsShare = v.IsShare
  59. tmp.AdminId = v.AdminId
  60. ret.PublicList = append(ret.PublicList, tmp)
  61. }
  62. for _, v := range privateGroups {
  63. if v.IsShareAdd == 1 {
  64. continue
  65. } else {
  66. tmp := new(models.RespGroupListItem)
  67. tmp.GroupId = v.GroupId
  68. tmp.GroupName = v.GroupName
  69. tmp.IsShare = v.IsShare
  70. tmp.AdminId = v.AdminId
  71. ret.PrivateList = append(ret.PrivateList, tmp)
  72. }
  73. }
  74. pptMappings, err := models.GetPptMappingListByGroupIds(groupIds)
  75. if err != nil {
  76. err = errors.New("查询目录里的ppt出错:" + err.Error())
  77. return
  78. }
  79. pptMap := make(map[int]*models.PptV2)
  80. groupMap := make(map[int64][]*models.RespGroupPptNameListItem)
  81. groupHasNewPptMap := make(map[int64]struct{})
  82. pptIds := make([]int, 0)
  83. for _, v := range pptMappings {
  84. pptIds = append(pptIds, int(v.PptId))
  85. }
  86. if len(pptIds) == 0 {
  87. // 返回所有空目录
  88. return
  89. }
  90. pptList, err := models.GetPptV2ByIds(pptIds)
  91. if err != nil {
  92. err = errors.New("查询ppt详情出错:" + err.Error())
  93. return
  94. }
  95. for _, v := range pptList {
  96. pptMap[v.PptId] = v
  97. }
  98. //组装group ppt
  99. for _, v := range pptMappings {
  100. tmp := new(models.RespGroupPptNameListItem)
  101. tmp.AdminId = v.AdminId
  102. tmp.GroupPptId = v.GroupPptId
  103. tmp.PptId = v.PptId
  104. if v.ChildGroupPptId > 0 {
  105. tmp.IsSingleShare = 1
  106. }
  107. if i, ok := pptMap[int(v.PptId)]; ok {
  108. // 因之前并没有存储PPT页数字段,所以此处读取PPT内容的长度
  109. if i.Content != "" {
  110. contents := make([]PageContent, 0)
  111. if e := json.Unmarshal([]byte(i.Content), &contents); e != nil {
  112. err = errors.New("解析PPT内容页数失败: " + e.Error())
  113. return
  114. }
  115. tmp.PptPage = len(contents)
  116. }
  117. tmp.Title = i.Title
  118. tmp.PptVersion = i.PptVersion
  119. tmp.PptxUrl = i.PptxUrl
  120. tmp.ReportId = i.ReportId
  121. tmp.ReportCode = i.ReportCode
  122. tmp.PptCreateTime = i.CreateTime.Format(utils.FormatDateTime)
  123. }
  124. tmp.AdminRealName = v.AdminRealName
  125. if tmp.PptVersion == 2 {
  126. groupHasNewPptMap[v.GroupId] = struct{}{}
  127. } else {
  128. if IsNewPpt == 1 { //如果只展示新版的ppt,则忽略旧版ppt
  129. continue
  130. }
  131. }
  132. groupMap[v.GroupId] = append(groupMap[v.GroupId], tmp)
  133. }
  134. for k, v := range ret.PublicList {
  135. if pptL, ok := groupMap[v.GroupId]; ok {
  136. ret.PublicList[k].PptList = pptL
  137. if _, ok1 := groupHasNewPptMap[v.GroupId]; !ok1 && len(pptL) > 0 {
  138. ret.PublicList[k].OnlyOld = true
  139. }
  140. }
  141. }
  142. for k, v := range ret.PrivateList {
  143. if pptL, ok := groupMap[v.GroupId]; ok {
  144. ret.PrivateList[k].PptList = pptL
  145. if _, ok1 := groupHasNewPptMap[v.GroupId]; !ok1 && len(pptL) > 0 {
  146. ret.PrivateList[k].OnlyOld = true
  147. }
  148. }
  149. }
  150. if IsNewPpt == 1 { //如果只展示新版ppt,则过滤空文件夹
  151. pubList := make([]*models.RespGroupListItem, 0)
  152. for _, v := range ret.PublicList {
  153. if len(v.PptList) > 0 {
  154. pubList = append(pubList, v)
  155. }
  156. }
  157. ret.PublicList = pubList
  158. priList := make([]*models.RespGroupListItem, 0)
  159. for _, v := range ret.PrivateList {
  160. if len(v.PptList) > 0 {
  161. priList = append(priList, v)
  162. }
  163. }
  164. ret.PrivateList = priList
  165. }
  166. return
  167. }
  168. // AddGroup 新增ppt目录
  169. func AddGroup(groupName string, adminId int, isShare int8, isSharedAdd int8) (newId int64, err error) {
  170. item, err := models.GetPptGroupByName(groupName, adminId)
  171. if err != nil && err.Error() != utils.ErrNoRow() {
  172. err = errors.New("目录查询出错:" + err.Error())
  173. return
  174. }
  175. if item != nil {
  176. err = errors.New("目录名称已存在,不可重复添加")
  177. return
  178. }
  179. groupInfo := &models.PptV2Group{
  180. GroupName: groupName,
  181. AdminId: adminId,
  182. IsShare: isShare,
  183. IsShareAdd: isSharedAdd,
  184. }
  185. if isShare == 1 {
  186. groupInfo.ShareTime = time.Now()
  187. }
  188. newId, err = models.AddPptGroup(groupInfo)
  189. if err != nil {
  190. err = errors.New("新增失败,Err:" + err.Error())
  191. return
  192. }
  193. groupInfo.GroupSort = newId
  194. groupInfo.GroupId = newId
  195. // 更新排序标识
  196. err = groupInfo.Update([]string{"group_sort"})
  197. if err != nil {
  198. err = errors.New("更新排序失败:" + err.Error())
  199. return
  200. }
  201. return
  202. }
  203. // AddGroupPptMapping 新增ppt和目录映射关系
  204. func AddGroupPptMapping(pptId int64, groupId int64, adminId int, adminRealName string) (newId int64, err error) {
  205. _, err = models.GetPptGroupByGroupIdAdminId(groupId, adminId)
  206. if err != nil {
  207. if err.Error() == utils.ErrNoRow() {
  208. err = errors.New("目录不存在")
  209. return
  210. }
  211. err = errors.New("目录查询出错:" + err.Error())
  212. return
  213. }
  214. bindInfo := &models.PptV2GroupMapping{
  215. GroupId: groupId,
  216. PptId: pptId,
  217. AdminId: adminId,
  218. AdminRealName: adminRealName,
  219. }
  220. newId, err = models.AddPptGroupMapping(bindInfo)
  221. if err != nil {
  222. err = errors.New("绑定目录失败:" + err.Error())
  223. return
  224. }
  225. bindInfo.GroupPptId = newId
  226. bindInfo.PptSort = newId
  227. err = bindInfo.Update([]string{"ppt_sort"})
  228. if err != nil {
  229. err = errors.New("更新排序失败:" + err.Error())
  230. return
  231. }
  232. return
  233. }
  234. // DelGroup 删除ppt 目录
  235. func DelGroup(groupId int64, adminId int) (err error) {
  236. _, err = models.GetPptGroupByGroupIdAdminId(groupId, adminId)
  237. if err != nil {
  238. if err.Error() == utils.ErrNoRow() {
  239. err = errors.New("目录不存在")
  240. return
  241. }
  242. err = errors.New("目录查询出错:" + err.Error())
  243. return
  244. }
  245. //查询是否有映射存在
  246. count, err := models.GetPptMappingCountByGroupId(groupId)
  247. if err != nil {
  248. err = errors.New("查询目录里的ppt个数出错:" + err.Error())
  249. return
  250. }
  251. if count > 0 {
  252. err = errors.New("该目录下有关联PPT,不允许删除")
  253. return
  254. }
  255. err = models.DeletePptGroup(groupId)
  256. if err != nil {
  257. err = errors.New("删除失败:" + err.Error())
  258. return
  259. }
  260. return
  261. }
  262. // ShareGroup 共享/取消共享目录
  263. func ShareGroup(groupId int64, adminId int) (respShare models.RespPptGroupShare, err error) {
  264. // 查询目录是否存在
  265. groupInfo, err := models.GetPptGroupByGroupIdAdminId(groupId, adminId)
  266. if err != nil {
  267. if err.Error() == utils.ErrNoRow() {
  268. err = errors.New("目录不存在")
  269. return
  270. }
  271. err = errors.New("目录查询出错:" + err.Error())
  272. return
  273. }
  274. // 判断是共享操作还是取消共享操作
  275. if groupInfo.IsShare == 1 {
  276. //取消共享
  277. groupInfo.IsShare = 0
  278. //groupInfo.ModifyTime = time.Now()
  279. err = groupInfo.Update([]string{"is_share"})
  280. if err != nil {
  281. err = errors.New("取消共享出错:" + err.Error())
  282. return
  283. }
  284. } else {
  285. //设置共享
  286. groupInfo.IsShare = 1
  287. groupInfo.ShareTime = time.Now()
  288. err = groupInfo.Update([]string{"is_share", "share_time"})
  289. if err != nil {
  290. err = errors.New("设置共享出错:" + err.Error())
  291. return
  292. }
  293. respShare.IsShare = 1
  294. }
  295. respShare.GroupId = groupId
  296. return
  297. }
  298. // CopyGroup 复制目录
  299. func CopyGroup(groupId int64, adminId int, adminRealName string) (err error) {
  300. //查询目录是否存在
  301. groupInfo, err := models.GetPptGroupByGroupId(groupId)
  302. if err != nil {
  303. if err.Error() == utils.ErrNoRow() {
  304. err = errors.New("目录不存在")
  305. return
  306. }
  307. err = errors.New("目录查询出错:" + err.Error())
  308. return
  309. }
  310. //新增公共目录。目录名称在原来的基础上带上复制序号
  311. groupNames, err := models.GetPptGroupNamesByAdminId(adminId)
  312. if err != nil {
  313. err = errors.New("目录查询出错:" + err.Error())
  314. return
  315. }
  316. newGroupName := generateCopyName(groupInfo.GroupName, 1, groupNames)
  317. newGroupId, err := AddGroup(newGroupName, adminId, 0, 0)
  318. if err != nil {
  319. err = errors.New("复制目录出错:" + err.Error())
  320. return
  321. }
  322. //查询该目录下面是否存在ppt,如果存在则批量复制ppt到新目录下
  323. mappingList, err := models.GetPptMappingListByGroupId(groupId)
  324. if err != nil {
  325. err = errors.New("查询目录里的ppt列表出错:" + err.Error())
  326. return
  327. }
  328. if len(mappingList) <= 0 {
  329. return
  330. }
  331. pptIds := make([]int, 0)
  332. for _, v := range mappingList {
  333. pptIds = append(pptIds, int(v.PptId))
  334. }
  335. //批量查询ppt详情
  336. pptList, err := models.GetPptV2ByIds(pptIds)
  337. if err != nil {
  338. err = errors.New("查询ppt列表出错:" + err.Error())
  339. return
  340. }
  341. pptNames, err := models.GetAllPptTitle()
  342. if err != nil {
  343. err = errors.New("查询ppt标题出错:" + err.Error())
  344. return
  345. }
  346. //批量复制ppt,更新作者为当前账号,并返回新的pptID
  347. newPptList := make([]*models.PptV2, 0)
  348. for _, v := range pptList {
  349. if v.PptVersion != 2 { //只复制新版的ppt,旧版本的ppt忽略
  350. continue
  351. }
  352. tmp := &models.PptV2{
  353. TemplateType: v.TemplateType,
  354. BackgroundImg: v.BackgroundImg,
  355. Title: generateCopyName(v.Title, 1, pptNames),
  356. ReportType: v.ReportType,
  357. PptDate: v.PptDate,
  358. Content: v.Content,
  359. CoverContent: v.CoverContent,
  360. PptUrl: v.PptUrl,
  361. PptxUrl: v.PptxUrl,
  362. CreateTime: time.Now(),
  363. ModifyTime: time.Now(),
  364. AdminId: adminId,
  365. AdminRealName: adminRealName,
  366. PptVersion: v.PptVersion,
  367. TitleSetting: v.TitleSetting,
  368. }
  369. newPptList = append(newPptList, tmp)
  370. }
  371. if len(newPptList) > 0 {
  372. err = models.AddPptV2Multi(newPptList)
  373. if err != nil {
  374. err = errors.New("复制目录里的ppt出错:" + err.Error())
  375. return
  376. }
  377. newMappings := make([]*models.PptV2GroupMapping, 0)
  378. for _, v := range newPptList {
  379. tmp := &models.PptV2GroupMapping{
  380. GroupId: newGroupId,
  381. PptId: int64(v.PptId),
  382. CreateTime: time.Now(),
  383. ModifyTime: time.Now(),
  384. AdminId: adminId,
  385. AdminRealName: adminRealName,
  386. }
  387. newMappings = append(newMappings, tmp)
  388. }
  389. err = models.AddPptGroupMappingMulti(newMappings)
  390. if err != nil {
  391. err = errors.New("复制目录里的ppt出错:" + err.Error())
  392. return
  393. }
  394. //批量更新排序字段
  395. var newGroupPptIds []int64
  396. for _, v := range newMappings {
  397. newGroupPptIds = append(newGroupPptIds, v.GroupPptId)
  398. }
  399. err = models.UpdatePptGroupMappingSortMulti(newGroupPptIds)
  400. if err != nil {
  401. err = errors.New("更新排序标识出错:" + err.Error())
  402. return
  403. }
  404. }
  405. return
  406. }
  407. // RenameGroupName 目录重命名
  408. func RenameGroupName(groupId int64, groupName string, adminId int) (err error) {
  409. groupInfo, err := models.GetPptGroupByGroupIdAdminId(groupId, adminId)
  410. if err != nil {
  411. if err.Error() == utils.ErrNoRow() {
  412. err = errors.New("目录不存在")
  413. return
  414. }
  415. err = errors.New("目录查询出错:" + err.Error())
  416. return
  417. }
  418. if groupInfo.GroupName == groupName {
  419. err = errors.New("与原名字一致,无需修改")
  420. return
  421. }
  422. item, err := models.GetPptGroupByName(groupName, adminId)
  423. if err != nil && err.Error() != utils.ErrNoRow() {
  424. err = errors.New("目录查询出错:" + err.Error())
  425. return
  426. }
  427. if item != nil {
  428. err = errors.New("目录名称已存在,不可重复添加")
  429. return
  430. }
  431. //更新新名字
  432. groupInfo.GroupName = groupName
  433. err = groupInfo.Update([]string{"group_name"})
  434. if err != nil {
  435. err = errors.New("目录重命名失败" + err.Error())
  436. return
  437. }
  438. return
  439. }
  440. // ShareSingleGroupPpt 共享单个ppt/取消共享单个ppt,返回共享状态
  441. func ShareSingleGroupPpt(groupPptId int64, adminId int, adminRealName string) (ret models.RespPptShare, err error) {
  442. //判断当前登录者是否有共享的权限
  443. groupPpt, err := models.GetPptMappingByGroupPptId(groupPptId, adminId)
  444. if err != nil {
  445. if err.Error() == utils.ErrNoRow() {
  446. err = errors.New("当前目录下的ppt不存在")
  447. return
  448. }
  449. err = errors.New("目录下的ppt查询出错:" + err.Error())
  450. return
  451. }
  452. groupInfo, err := models.GetPptGroupByGroupIdAdminId(groupPpt.GroupId, adminId)
  453. if err != nil {
  454. if err.Error() == utils.ErrNoRow() {
  455. err = errors.New("目录不存在")
  456. return
  457. }
  458. err = errors.New("目录查询出错:" + err.Error())
  459. return
  460. }
  461. //判断当前的共享状态
  462. if groupPpt.ChildGroupPptId > 0 {
  463. err = CancelShareSingleGroupPpt(groupPpt, adminId)
  464. if err != nil {
  465. err = errors.New(err.Error())
  466. return
  467. }
  468. ret.IsSingleShare = 0
  469. } else {
  470. //如果是未共享状态,则共享该ppt,类似复制流程,并更新共享标识
  471. //新增公共目录。目录名称在原来的基础上带上复制序号
  472. groupNames, tErr := models.GetPptGroupNamesByAdminId(adminId)
  473. if tErr != nil {
  474. err = errors.New("目录查询出错:" + tErr.Error())
  475. return
  476. }
  477. newGroupName := generateCopyName(groupInfo.GroupName, 1, groupNames)
  478. newGroupId, tErr := AddGroup(newGroupName, adminId, 1, 1)
  479. if tErr != nil {
  480. err = errors.New(tErr.Error())
  481. return
  482. }
  483. //新增公共的目录和ppt之间的映射关系
  484. newGroupPptId, tErr := AddGroupPptMapping(groupPpt.PptId, newGroupId, adminId, adminRealName)
  485. if tErr != nil {
  486. err = errors.New(tErr.Error())
  487. return
  488. }
  489. //更新共享标识
  490. groupPpt.ChildGroupPptId = newGroupPptId
  491. err = groupPpt.Update([]string{"child_group_ppt_id"})
  492. if err != nil {
  493. err = errors.New("更新共享标识失败" + err.Error())
  494. return
  495. }
  496. ret.IsSingleShare = 1
  497. }
  498. ret.GroupPptId = groupPptId
  499. return
  500. }
  501. // GetGroupPptList 公共目录下的ppt列表或者单个目录里的ppt列表
  502. func GetGroupPptList(groupId int64, adminId int) (ret models.RespGroupPptList, err error) {
  503. var groupPptList []*models.PptV2GroupMapping
  504. var groups []*models.PptV2Group
  505. list := make([]*models.RespGroupPptListItem, 0)
  506. ret.List = list
  507. if groupId > 0 {
  508. //只查询组内的ppt列表
  509. //查询目录是否存在
  510. groupInfo, tErr := models.GetPptGroupByGroupId(groupId)
  511. if tErr != nil {
  512. if tErr.Error() == utils.ErrNoRow() {
  513. err = errors.New("目录不存在")
  514. return
  515. }
  516. err = errors.New("目录查询出错:" + tErr.Error())
  517. return
  518. }
  519. groups = append(groups, groupInfo)
  520. groupPptList, tErr = models.GetPptMappingListByGroupId(groupId)
  521. if tErr != nil {
  522. err = errors.New("目录里的ppt查询出错:" + tErr.Error())
  523. return
  524. }
  525. } else {
  526. // 获取我的所有的ppt
  527. ret, err = GetMyPptList(adminId, ``)
  528. return
  529. ////查询所有公共目录下的ppt列表
  530. //var tErr error
  531. //groups, tErr = models.GetPublicPptGroups()
  532. //if tErr != nil {
  533. // err = errors.New("目录查询出错:" + tErr.Error())
  534. // return
  535. //}
  536. ////查询这些目录下的所有ppt
  537. //groupIds := make([]int64, 0)
  538. //for _, v := range groups {
  539. // groupIds = append(groupIds, v.GroupId)
  540. //}
  541. //
  542. //groupPptList, tErr = models.GetPptMappingListByGroupIds(groupIds)
  543. //if tErr != nil {
  544. // err = errors.New("目录里的ppt查询出错:" + tErr.Error())
  545. // return
  546. //}
  547. }
  548. if len(groupPptList) <= 0 {
  549. return
  550. }
  551. pptMap := make(map[int]*models.PptV2)
  552. groupMap := make(map[int64][]*models.PptV2GroupMapping)
  553. pptIds := make([]int, 0)
  554. for _, v := range groupPptList {
  555. pptIds = append(pptIds, int(v.PptId))
  556. groupMap[v.GroupId] = append(groupMap[v.GroupId], v)
  557. }
  558. if len(pptIds) == 0 {
  559. // 返回所有空目录
  560. return
  561. }
  562. pptList, err := models.GetPptV2ByIds(pptIds)
  563. if err != nil {
  564. err = errors.New("查询ppt详情出错:" + err.Error())
  565. return
  566. }
  567. for _, v := range pptList {
  568. pptMap[v.PptId] = v
  569. }
  570. //按照排序顺序,依次放入ppt
  571. hasPpt := make(map[int]struct{})
  572. for _, v := range groups {
  573. if mapList, ok := groupMap[v.GroupId]; ok {
  574. if len(mapList) > 0 {
  575. for _, pptV := range mapList {
  576. pptInfo, ok1 := pptMap[int(pptV.PptId)]
  577. _, ok2 := hasPpt[int(pptV.PptId)]
  578. if ok1 && !ok2 {
  579. tmp := &models.RespGroupPptListItem{
  580. GroupPptId: pptV.GroupPptId,
  581. PptId: pptV.PptId,
  582. TemplateType: pptInfo.TemplateType,
  583. BackgroundImg: pptInfo.BackgroundImg,
  584. Title: pptInfo.Title,
  585. AdminId: pptV.AdminId,
  586. AdminRealName: pptV.AdminRealName,
  587. IsSingleShare: 0,
  588. PptCreateTime: pptInfo.CreateTime.Format(utils.FormatDateTime),
  589. PptModifyTime: pptInfo.ModifyTime.Format(utils.FormatDateTime),
  590. PptxUrl: pptInfo.PptxUrl,
  591. PptVersion: pptInfo.PptVersion,
  592. ReportId: pptInfo.ReportId,
  593. ReportCode: pptInfo.ReportCode,
  594. PublishTime: utils.DealDateTimeZero(pptInfo.PublishTime, utils.FormatDateTime),
  595. }
  596. if pptV.ChildGroupPptId > 0 {
  597. tmp.IsSingleShare = 1
  598. }
  599. list = append(list, tmp)
  600. hasPpt[pptInfo.PptId] = struct{}{}
  601. }
  602. }
  603. }
  604. }
  605. }
  606. ret.List = list
  607. if groupId <= 0 {
  608. sort.Sort(ret)
  609. }
  610. ret.Total = len(list)
  611. return
  612. }
  613. // MoveGroupPpt 移动ppt操作
  614. func MoveGroupPpt(groupId, groupPptId, prevGroupPptId, nextGroupPptId int64, adminId int) (err error) {
  615. //查询当前映射是否存在
  616. //判断当前登录者是否有共享的权限oo
  617. groupPpt, err := models.GetPptMappingByGroupPptId(groupPptId, adminId)
  618. if err != nil {
  619. if err.Error() == utils.ErrNoRow() {
  620. err = errors.New("当前目录下的ppt不存在")
  621. return
  622. }
  623. err = errors.New("目录下的ppt查询出错:" + err.Error())
  624. return
  625. }
  626. var updateStr []string
  627. //如果更换了目录,默认当前排序值为0
  628. var currentSort, prevSort, nextSort int64
  629. //判断是否更换group
  630. if groupPpt.GroupId != groupId {
  631. _, err = models.GetPptGroupByGroupIdAdminId(groupId, adminId)
  632. if err != nil {
  633. if err.Error() == utils.ErrNoRow() {
  634. err = errors.New("目录不存在")
  635. return
  636. }
  637. err = errors.New("目录查询出错:" + err.Error())
  638. return
  639. }
  640. //判断是否需要解除当个ppt共享
  641. //解除共享操作
  642. err = CancelShareSingleGroupPpt(groupPpt, adminId)
  643. if err != nil {
  644. err = errors.New(err.Error())
  645. return
  646. }
  647. groupPpt.GroupId = groupId
  648. updateStr = append(updateStr, "group_id")
  649. }
  650. currentSort = groupPpt.PptSort
  651. var prevGroupPpt *models.PptV2GroupMapping
  652. var nextGroupPpt *models.PptV2GroupMapping
  653. if prevGroupPptId > 0 {
  654. prevGroupPpt, err = models.GetPptMappingByGroupPptId(prevGroupPptId, adminId)
  655. if err != nil {
  656. if err.Error() == utils.ErrNoRow() {
  657. err = errors.New("目录下的ppt不存在")
  658. return
  659. }
  660. err = errors.New("目录下的ppt查询出错:" + err.Error())
  661. return
  662. }
  663. prevSort = prevGroupPpt.PptSort
  664. }
  665. if nextGroupPptId > 0 {
  666. nextGroupPpt, err = models.GetPptMappingByGroupPptId(nextGroupPptId, adminId)
  667. if err != nil {
  668. if err.Error() == utils.ErrNoRow() {
  669. err = errors.New("目录下的ppt不存在")
  670. return
  671. }
  672. err = errors.New("目录下的ppt查询出错:" + err.Error())
  673. return
  674. }
  675. nextSort = nextGroupPpt.PptSort
  676. }
  677. updateStr = append(updateStr, "ppt_sort")
  678. //移到两个排序值中间操作
  679. if prevSort >= currentSort {
  680. //往下移动
  681. err = models.MoveDownGroupPptBySort(groupId, prevSort, currentSort)
  682. if err != nil {
  683. err = errors.New("向下移动ppt出错:" + err.Error())
  684. return
  685. }
  686. groupPpt.PptSort = prevSort
  687. } else if nextSort <= currentSort && nextSort != 0 {
  688. //往上移动
  689. err = models.MoveUpGroupPptBySort(groupId, nextSort, currentSort)
  690. if err != nil {
  691. err = errors.New("向上移动ppt出错:" + err.Error())
  692. return
  693. }
  694. groupPpt.PptSort = nextSort
  695. }
  696. //更新当前排序
  697. err = groupPpt.Update(updateStr)
  698. if err != nil {
  699. err = errors.New("移动ppt出错:" + err.Error())
  700. return
  701. }
  702. return
  703. }
  704. // MoveGroup 移动目录
  705. func MoveGroup(groupId, prevGroupId, nextGroupId int64, adminId int) (err error) {
  706. //查询目录是否存在
  707. groupInfo, err := models.GetPptGroupByGroupIdAdminId(groupId, adminId)
  708. if err != nil {
  709. if err.Error() == utils.ErrNoRow() {
  710. err = errors.New("目录不存在")
  711. return
  712. }
  713. err = errors.New("目录查询出错:" + err.Error())
  714. return
  715. }
  716. //如果更换了目录,默认当前排序值为0
  717. var currentSort, prevSort, nextSort int64
  718. currentSort = groupInfo.GroupSort
  719. var prevGroup *models.PptV2Group
  720. var nextGroup *models.PptV2Group
  721. if prevGroupId > 0 {
  722. prevGroup, err = models.GetPptGroupByGroupIdAdminId(prevGroupId, adminId)
  723. if err != nil {
  724. if err.Error() == utils.ErrNoRow() {
  725. err = errors.New("目录不存在")
  726. return
  727. }
  728. err = errors.New("目录查询出错:" + err.Error())
  729. return
  730. }
  731. prevSort = prevGroup.GroupSort
  732. }
  733. if nextGroupId > 0 {
  734. nextGroup, err = models.GetPptGroupByGroupIdAdminId(nextGroupId, adminId)
  735. if err != nil {
  736. if err.Error() == utils.ErrNoRow() {
  737. err = errors.New("目录不存在")
  738. return
  739. }
  740. err = errors.New("目录查询出错:" + err.Error())
  741. return
  742. }
  743. nextSort = nextGroup.GroupSort
  744. }
  745. //移到两个排序值中间操作
  746. if prevSort >= currentSort {
  747. //往下移动
  748. err = models.MoveDownGroupBySort(prevSort, currentSort)
  749. if err != nil {
  750. err = errors.New("向下移动ppt出错:" + err.Error())
  751. return
  752. }
  753. groupInfo.GroupSort = prevSort
  754. } else if nextSort <= currentSort && nextSort != 0 {
  755. //往上移动
  756. err = models.MoveUpGroupBySort(nextSort, currentSort)
  757. if err != nil {
  758. err = errors.New("向上移动ppt出错:" + err.Error())
  759. return
  760. }
  761. groupInfo.GroupSort = nextSort
  762. }
  763. //更新当前排序
  764. err = groupInfo.Update([]string{"group_sort"})
  765. if err != nil {
  766. err = errors.New("移动目录出错:" + err.Error())
  767. return
  768. }
  769. return
  770. }
  771. // CancelShareSingleGroupPpt 解除单个共享的ppt
  772. func CancelShareSingleGroupPpt(groupPpt *models.PptV2GroupMapping, adminId int) (err error) {
  773. if groupPpt.ChildGroupPptId <= 0 {
  774. return
  775. }
  776. //如果已经是共享状态,
  777. //判断当前登录者是否有取消共享的权限
  778. childGroupPpt, tErr := models.GetPptMappingByGroupPptId(groupPpt.ChildGroupPptId, adminId)
  779. if tErr != nil {
  780. if tErr.Error() != utils.ErrNoRow() {
  781. err = errors.New("目录下的ppt查询出错:" + tErr.Error())
  782. return
  783. }
  784. }
  785. if childGroupPpt != nil {
  786. //删除共享目录和ppt的映射关系
  787. err = models.DeletePptGroupMapping(childGroupPpt.GroupPptId, adminId)
  788. if err != nil {
  789. err = errors.New("删除共享目录下的ppt失败:" + err.Error())
  790. return
  791. }
  792. //删除共享出去的公共目录
  793. err = models.DeletePptGroup(childGroupPpt.GroupId)
  794. if err != nil {
  795. err = errors.New("删除共享目录失败:" + err.Error())
  796. return
  797. }
  798. }
  799. //更新共享状态为未共享,
  800. //更新共享标识
  801. groupPpt.ChildGroupPptId = 0
  802. err = groupPpt.Update([]string{"child_group_ppt_id"})
  803. if err != nil {
  804. err = errors.New("更新共享标识失败" + err.Error())
  805. return
  806. }
  807. return
  808. }
  809. // DeleteGroupPpt 删除ppt
  810. func DeleteGroupPpt(PptId int) (err error) {
  811. //查询该ppt的所有单个共享出去的目录信息
  812. groupPpts, err := models.GetGroupPptByPptId(PptId)
  813. if err != nil {
  814. err = errors.New("查询目录里的ppt失败" + err.Error())
  815. return
  816. }
  817. if len(groupPpts) <= 0 {
  818. return
  819. }
  820. //整理出需要删除的groupId
  821. groupPptMap := make(map[int64]*models.PptV2GroupMapping)
  822. for _, v := range groupPpts {
  823. groupPptMap[v.GroupPptId] = v
  824. }
  825. var delGroupIds string
  826. for _, v := range groupPpts {
  827. if v.ChildGroupPptId > 0 {
  828. if childGroup, ok := groupPptMap[v.ChildGroupPptId]; ok {
  829. delGroupIds += strconv.Itoa(int(childGroup.GroupId)) + ","
  830. }
  831. }
  832. }
  833. if delGroupIds != "" {
  834. delGroupIds = "(" + strings.Trim(delGroupIds, ",") + ")"
  835. err = models.DeletePptGroupByGroupIds(delGroupIds)
  836. if err != nil {
  837. err = errors.New("删除单个共享目录失败" + err.Error())
  838. return
  839. }
  840. }
  841. //再统一删除目录里相关的ppt
  842. err = models.DeletePptGroupMappingByPptId(PptId)
  843. if err != nil {
  844. err = errors.New("删除目录里的ppt失败" + err.Error())
  845. return
  846. }
  847. return
  848. }
  849. // CopyPpt 复制单个ppt,并移动到新的目录下面
  850. func CopyPpt(pptId int, groupId int64, adminId int, adminRealName string) (resp models.RespGroupPptNameListItem, err error) {
  851. //查询ppt详情
  852. pptInfo, err := models.GetPptV2ById(pptId)
  853. if err != nil {
  854. if err.Error() == utils.ErrNoRow() {
  855. err = errors.New("ppt 不存在")
  856. return
  857. }
  858. err = errors.New("查询ppt失败" + err.Error())
  859. return
  860. }
  861. if pptInfo.PptVersion == 1 {
  862. err = errors.New("旧版本的ppt不允许复制")
  863. return
  864. }
  865. // 查询目录是否存在
  866. _, err = models.GetPptGroupByGroupIdAdminId(groupId, adminId)
  867. if err != nil {
  868. if err.Error() == utils.ErrNoRow() {
  869. err = errors.New("目录不存在")
  870. return
  871. }
  872. err = errors.New("目录查询出错:" + err.Error())
  873. return
  874. }
  875. pptNames, err := models.GetAllPptTitle()
  876. if err != nil {
  877. err = errors.New("查询ppt标题出错:" + err.Error())
  878. return
  879. }
  880. //复制ppt,更新作者为当前账号,并返回新的pptID
  881. var newPptList []*models.PptV2
  882. newPpt := &models.PptV2{
  883. TemplateType: pptInfo.TemplateType,
  884. BackgroundImg: pptInfo.BackgroundImg,
  885. Title: generateCopyName(pptInfo.Title, 1, pptNames),
  886. ReportType: pptInfo.ReportType,
  887. PptDate: pptInfo.PptDate,
  888. Content: pptInfo.Content,
  889. CoverContent: pptInfo.CoverContent,
  890. PptUrl: pptInfo.PptUrl,
  891. PptxUrl: pptInfo.PptxUrl,
  892. CreateTime: time.Now(),
  893. ModifyTime: time.Now(),
  894. AdminId: adminId,
  895. AdminRealName: adminRealName,
  896. PptVersion: pptInfo.PptVersion,
  897. TitleSetting: pptInfo.TitleSetting,
  898. }
  899. newPptList = append(newPptList, newPpt)
  900. err = models.AddPptV2Multi(newPptList)
  901. if err != nil {
  902. err = errors.New("复制目录里的ppt出错:" + err.Error())
  903. return
  904. }
  905. var newMappings []*models.PptV2GroupMapping
  906. newGroupPpt := &models.PptV2GroupMapping{
  907. GroupId: groupId,
  908. PptId: int64(newPpt.PptId),
  909. CreateTime: time.Now(),
  910. ModifyTime: time.Now(),
  911. AdminId: adminId,
  912. AdminRealName: adminRealName,
  913. }
  914. newMappings = append(newMappings, newGroupPpt)
  915. err = models.AddPptGroupMappingMulti(newMappings)
  916. if err != nil {
  917. err = errors.New("复制目录里的ppt出错:" + err.Error())
  918. return
  919. }
  920. //批量更新排序字段
  921. err = models.UpdatePptGroupMappingSortMulti([]int64{newGroupPpt.GroupPptId})
  922. if err != nil {
  923. err = errors.New("更新排序标识出错:" + err.Error())
  924. return
  925. }
  926. pptPage := 0
  927. // 因之前并没有存储PPT页数字段,所以此处读取PPT内容的长度
  928. if newPpt.Content != "" {
  929. contents := make([]PageContent, 0)
  930. if e := json.Unmarshal([]byte(newPpt.Content), &contents); e != nil {
  931. err = errors.New(fmt.Sprintf("%d,解析PPT内容页数失败: %s", newPpt.PptId, e.Error()))
  932. return
  933. }
  934. pptPage = len(contents)
  935. }
  936. resp = models.RespGroupPptNameListItem{
  937. GroupPptId: newGroupPpt.GroupPptId,
  938. PptId: int64(newPpt.PptId),
  939. Title: newPpt.Title,
  940. AdminId: newPpt.AdminId,
  941. AdminRealName: newPpt.AdminRealName,
  942. PptVersion: newPpt.PptVersion,
  943. PptxUrl: newPpt.PptxUrl,
  944. ReportId: newPpt.ReportId,
  945. ReportCode: newPpt.ReportCode,
  946. PptCreateTime: newPpt.CreateTime.Format(utils.FormatDateTime),
  947. PptPage: pptPage,
  948. TitleSetting: newPpt.TitleSetting,
  949. }
  950. return
  951. }
  952. // generateCopyName 生成复制的目录名称
  953. func generateCopyName(originName string, count int, nameList []string) (newName string) {
  954. newName = originName + "(" + strconv.Itoa(count) + ")"
  955. for _, v := range nameList {
  956. if v == newName {
  957. count++
  958. newName = generateCopyName(originName, count, nameList)
  959. return
  960. }
  961. }
  962. return
  963. }
  964. // SearchGroupPpt 根据ppt标题搜索ppt
  965. func SearchGroupPpt(keyWord string) (ret models.RespSearchGroupPptList, err error) {
  966. //组装group ppt
  967. list := make([]*models.RespSearchGroupPptListItem, 0)
  968. ret.List = list
  969. reqKeyword := "%" + keyWord + "%"
  970. condition := " and title like ? "
  971. var pars []interface{}
  972. pars = append(pars, reqKeyword)
  973. pptList, err := models.GetPptV2ByCondition(condition, pars)
  974. if err != nil {
  975. err = errors.New("查询ppt列表出错:" + err.Error())
  976. return
  977. }
  978. if len(pptList) == 0 {
  979. return
  980. }
  981. pptIds := make([]string, 0)
  982. pptMap := make(map[int]*models.PptV2)
  983. for _, v := range pptList {
  984. pptIds = append(pptIds, strconv.Itoa(v.PptId))
  985. pptMap[v.PptId] = v
  986. }
  987. groupPptList, err := models.GetPublicGroupPptByPptIds(pptIds)
  988. if err != nil {
  989. err = errors.New("查询目录里的ppt列表出错:" + err.Error())
  990. return
  991. }
  992. for _, v := range groupPptList {
  993. tmp := new(models.RespSearchGroupPptListItem)
  994. tmp.GroupPptId = v.GroupPptId
  995. tmp.PptId = v.PptId
  996. if i, ok := pptMap[int(v.PptId)]; ok {
  997. tmp.Title = i.Title
  998. }
  999. list = append(list, tmp)
  1000. }
  1001. ret.List = list
  1002. return
  1003. }
  1004. // InitPptGroup 初始化目录分组
  1005. func InitPptGroup() (err error) {
  1006. //查询所有的ppt
  1007. now := time.Now()
  1008. pptList, err := models.GetPptV2ByCondition("", []interface{}{})
  1009. if err != nil {
  1010. errors.New("查询所有的ppt出错" + err.Error())
  1011. return
  1012. }
  1013. pptAdminMap := make(map[int]string, 0)
  1014. adminPptListMap := make(map[int][]*models.PptV2)
  1015. oldPptAdminMap := make(map[int]string, 0)
  1016. oldAdminPptListMap := make(map[int][]*models.PptV2)
  1017. //查询所有的ppt作者
  1018. for _, v := range pptList {
  1019. if v.PptVersion == 2 {
  1020. if _, ok := pptAdminMap[v.AdminId]; !ok {
  1021. pptAdminMap[v.AdminId] = v.AdminRealName
  1022. }
  1023. adminPptListMap[v.AdminId] = append(adminPptListMap[v.AdminId], v)
  1024. } else {
  1025. if _, ok := oldPptAdminMap[v.AdminId]; !ok {
  1026. oldPptAdminMap[v.AdminId] = v.AdminRealName
  1027. }
  1028. oldAdminPptListMap[v.AdminId] = append(oldAdminPptListMap[v.AdminId], v)
  1029. }
  1030. }
  1031. //批量生成历史目录,共享目录
  1032. newOldGroupList := make([]*models.PptV2Group, 0)
  1033. //批量生成目录,共享目录
  1034. newGroupList := make([]*models.PptV2Group, 0)
  1035. if len(pptAdminMap) > 0 {
  1036. for k, v := range pptAdminMap {
  1037. tmp := &models.PptV2Group{
  1038. GroupName: v + "的PPT",
  1039. AdminId: k,
  1040. IsShare: 1,
  1041. CreateTime: now,
  1042. ModifyTime: now,
  1043. ShareTime: now,
  1044. }
  1045. newGroupList = append(newGroupList, tmp)
  1046. }
  1047. //批量把对应的ppt放到目录当中
  1048. err = models.AddPptGroupMulti(newGroupList)
  1049. if err != nil {
  1050. err = errors.New("创建目录出错:" + err.Error())
  1051. return
  1052. }
  1053. }
  1054. if len(oldPptAdminMap) > 0 {
  1055. for k, v := range oldPptAdminMap {
  1056. tmp := &models.PptV2Group{
  1057. GroupName: v + "的历史PPT",
  1058. AdminId: k,
  1059. IsShare: 1,
  1060. CreateTime: now,
  1061. ModifyTime: now,
  1062. ShareTime: now,
  1063. }
  1064. newOldGroupList = append(newOldGroupList, tmp)
  1065. }
  1066. //批量把对应的ppt放到目录当中
  1067. err = models.AddPptGroupMulti(newOldGroupList)
  1068. if err != nil {
  1069. err = errors.New("创建目录出错:" + err.Error())
  1070. return
  1071. }
  1072. }
  1073. //批量更新排序字段
  1074. var newGroupIds []int64
  1075. var newMappings []*models.PptV2GroupMapping
  1076. for _, v := range newGroupList {
  1077. newGroupIds = append(newGroupIds, v.GroupId)
  1078. if ppts, ok := adminPptListMap[v.AdminId]; ok {
  1079. for _, p := range ppts {
  1080. tmp := &models.PptV2GroupMapping{
  1081. GroupId: v.GroupId,
  1082. PptId: int64(p.PptId),
  1083. CreateTime: now,
  1084. ModifyTime: now,
  1085. AdminId: p.AdminId,
  1086. AdminRealName: p.AdminRealName,
  1087. }
  1088. newMappings = append(newMappings, tmp)
  1089. }
  1090. }
  1091. }
  1092. for _, v := range newOldGroupList {
  1093. newGroupIds = append(newGroupIds, v.GroupId)
  1094. if oldPpts, ok1 := oldAdminPptListMap[v.AdminId]; ok1 {
  1095. for _, p := range oldPpts {
  1096. tmp := &models.PptV2GroupMapping{
  1097. GroupId: v.GroupId,
  1098. PptId: int64(p.PptId),
  1099. CreateTime: now,
  1100. ModifyTime: now,
  1101. AdminId: p.AdminId,
  1102. AdminRealName: p.AdminRealName,
  1103. }
  1104. newMappings = append(newMappings, tmp)
  1105. }
  1106. }
  1107. }
  1108. err = models.UpdatePptGroupSortMulti(newGroupIds)
  1109. if err != nil {
  1110. err = errors.New("更新目录排序标识出错:" + err.Error())
  1111. return
  1112. }
  1113. err = models.AddPptGroupMappingMulti(newMappings)
  1114. if err != nil {
  1115. err = errors.New("创建目录里的ppt出错:" + err.Error())
  1116. return
  1117. }
  1118. //批量更新排序字段
  1119. var newGroupPptIds []int64
  1120. for _, v := range newMappings {
  1121. newGroupPptIds = append(newGroupPptIds, v.GroupPptId)
  1122. }
  1123. err = models.UpdatePptGroupMappingSortMulti(newGroupPptIds)
  1124. if err != nil {
  1125. err = errors.New("更新排序标识出错:" + err.Error())
  1126. return
  1127. }
  1128. return
  1129. }
  1130. // GetGroupsByAdminIdV2 查询ppt目录列表
  1131. // @Author roc
  1132. // @Time 2022-08-29 15:22:20
  1133. func GetGroupsByAdminIdV2(IsNewPpt, adminId int, lang string) (ret models.RespGroupList, err error) {
  1134. myPptList := make([]*models.RespGroupPptNameListItem, 0)
  1135. otherPptList := make([]*models.RespGroupPptNameListItem, 0)
  1136. grantList := []models.RespGroupListItem{}
  1137. if lang == utils.EnLangVersion {
  1138. grantList = append(grantList, []models.RespGroupListItem{
  1139. {
  1140. GroupId: 1,
  1141. GroupName: "My shared",
  1142. PptList: myPptList,
  1143. },
  1144. {
  1145. GroupId: 2,
  1146. GroupName: "Received shared",
  1147. PptList: otherPptList,
  1148. },
  1149. }...)
  1150. } else {
  1151. grantList = append(grantList, []models.RespGroupListItem{
  1152. {
  1153. GroupId: 1,
  1154. GroupName: "我共享的",
  1155. PptList: myPptList,
  1156. },
  1157. {
  1158. GroupId: 2,
  1159. GroupName: "收到共享",
  1160. PptList: otherPptList,
  1161. },
  1162. }...)
  1163. }
  1164. ret.PublicList = make([]*models.RespGroupListItem, 0)
  1165. ret.PrivateList = make([]*models.RespGroupListItem, 0)
  1166. ret.GrantList = grantList
  1167. pptMap := make(map[int]*models.PptV2)
  1168. groupMap := make(map[int64][]*models.RespGroupPptNameListItem)
  1169. groupHasNewPptMap := make(map[int64]struct{})
  1170. pptIds := make([]int, 0)
  1171. // 获取我的ppt分组
  1172. privateGroups, err := models.GetPrivatePptGroupsByAdminId(adminId)
  1173. if err != nil {
  1174. err = errors.New("私有目录查询出错:" + err.Error())
  1175. return
  1176. }
  1177. groupIds := make([]int64, 0)
  1178. for _, v := range privateGroups {
  1179. groupIds = append(groupIds, v.GroupId)
  1180. }
  1181. var pptMappings []*models.PptV2GroupMapping
  1182. // 如果没有分组,那么直接返回
  1183. if len(groupIds) > 0 {
  1184. // 遍历分组并拼接
  1185. for _, v := range privateGroups {
  1186. tmp := new(models.RespGroupListItem)
  1187. tmp.GroupId = v.GroupId
  1188. tmp.GroupName = v.GroupName
  1189. tmp.IsShare = v.IsShare
  1190. tmp.AdminId = v.AdminId
  1191. ret.PrivateList = append(ret.PrivateList, tmp)
  1192. }
  1193. // 通过分组id获取相关的ppt信息,主要是为了获取所有的ppt_id字段
  1194. pptMappings, err = models.GetPptMappingListByGroupIds(groupIds)
  1195. if err != nil {
  1196. err = errors.New("查询目录里的ppt出错:" + err.Error())
  1197. return
  1198. }
  1199. for _, v := range pptMappings {
  1200. pptIds = append(pptIds, int(v.PptId))
  1201. }
  1202. }
  1203. adminIdList := make([]int, 0) //需要查询的创建人admin_id列表集合
  1204. adminIdMap := make(map[int]int) //需要查询的创建人admin_id集合,用来去重的,避免重复id
  1205. // grantList 已经分配权限的ppt
  1206. grantPptList, err := models.GetAllGrantList(adminId)
  1207. for _, v := range grantPptList {
  1208. pptIds = append(pptIds, v.PptId)
  1209. if _, ok := adminIdMap[v.AdminId]; !ok {
  1210. adminIdList = append(adminIdList, v.AdminId) //需要查询的创建人admin_id列表集合
  1211. adminIdMap[v.AdminId] = v.AdminId //需要查询的创建人admin_id集合,用来去重的,避免重复id
  1212. }
  1213. }
  1214. if len(pptIds) > 0 {
  1215. // 通过ppt_id列表字段获取所有的ppt信息
  1216. pptList, tmpErr := models.GetPptV2ByIds(pptIds)
  1217. if tmpErr != nil {
  1218. err = errors.New("查询ppt详情出错:" + err.Error())
  1219. return
  1220. }
  1221. for _, v := range pptList {
  1222. pptMap[v.PptId] = v
  1223. }
  1224. }
  1225. // 私有的Ppt列表
  1226. {
  1227. //组装group ppt
  1228. for _, v := range pptMappings {
  1229. i, ok := pptMap[int(v.PptId)]
  1230. if !ok { //找不到ppt,还干个啥,直接退出当前循环啊
  1231. continue
  1232. }
  1233. if IsNewPpt == 1 && i.PptVersion != 2 { //都说了只要新版ppt,你一个不是新版ppt的,凑啥热闹,靠边站去,直接退出当前循环啊
  1234. continue
  1235. }
  1236. pptPage := 0
  1237. // 因之前并没有存储PPT页数字段,所以此处读取PPT内容的长度
  1238. if i.Content != "" {
  1239. contents := make([]PageContent, 0)
  1240. if e := json.Unmarshal([]byte(i.Content), &contents); e != nil {
  1241. err = errors.New(fmt.Sprintf("%d,解析PPT内容页数失败: %s", i.PptId, e.Error()))
  1242. return
  1243. }
  1244. pptPage = len(contents)
  1245. }
  1246. tmp := &models.RespGroupPptNameListItem{
  1247. AdminId: v.AdminId,
  1248. GroupPptId: v.GroupPptId,
  1249. PptId: v.PptId,
  1250. AdminRealName: v.AdminRealName,
  1251. Title: i.Title,
  1252. PptVersion: i.PptVersion,
  1253. IsSingleShare: i.IsShare,
  1254. PptxUrl: i.PptxUrl,
  1255. ReportId: i.ReportId,
  1256. ReportCode: i.ReportCode,
  1257. PptCreateTime: i.CreateTime.Format(utils.FormatDateTime),
  1258. PptModifyTime: i.ModifyTime.Format(utils.FormatDateTime),
  1259. PublishTime: utils.DealDateTimeZero(i.PublishTime, utils.FormatDateTime),
  1260. PptPage: pptPage,
  1261. }
  1262. if tmp.PptVersion == 2 {
  1263. groupHasNewPptMap[v.GroupId] = struct{}{}
  1264. }
  1265. groupMap[v.GroupId] = append(groupMap[v.GroupId], tmp)
  1266. }
  1267. for k, v := range ret.PrivateList {
  1268. if pptL, ok := groupMap[v.GroupId]; ok {
  1269. ret.PrivateList[k].PptList = pptL
  1270. if _, ok1 := groupHasNewPptMap[v.GroupId]; !ok1 && len(pptL) > 0 {
  1271. ret.PrivateList[k].OnlyOld = true
  1272. }
  1273. }
  1274. }
  1275. }
  1276. publicAdminIdList := make([]int, 0)
  1277. publicPptListMap := make(map[int][]*models.RespGroupPptNameListItem)
  1278. // 获取公开分享的ppt
  1279. sharePptList, err := models.GetSharePptV2(IsNewPpt)
  1280. for _, v := range sharePptList {
  1281. publicPptList, ok := publicPptListMap[v.AdminId]
  1282. if !ok {
  1283. publicPptList = make([]*models.RespGroupPptNameListItem, 0)
  1284. publicAdminIdList = append(publicAdminIdList, v.AdminId)
  1285. // 需要查询的创建人信息
  1286. if _, ok := adminIdMap[v.AdminId]; !ok {
  1287. adminIdList = append(adminIdList, v.AdminId) //需要查询的创建人admin_id列表集合
  1288. adminIdMap[v.AdminId] = v.AdminId //需要查询的创建人admin_id集合,用来去重的,避免重复id
  1289. }
  1290. }
  1291. contents := make([]PageContent, 0)
  1292. if e := json.Unmarshal([]byte(v.Content), &contents); e != nil {
  1293. err = errors.New("解析PPT内容页数失败: " + e.Error())
  1294. return
  1295. }
  1296. pptPage := len(contents)
  1297. tmpV := &models.RespGroupPptNameListItem{
  1298. GroupPptId: int64(v.PptId),
  1299. PptId: int64(v.PptId),
  1300. Title: v.Title,
  1301. AdminId: v.AdminId,
  1302. AdminRealName: v.AdminRealName,
  1303. PptVersion: v.PptVersion,
  1304. IsSingleShare: v.IsShare,
  1305. PptxUrl: v.PptxUrl,
  1306. ReportId: v.ReportId,
  1307. ReportCode: v.ReportCode,
  1308. PptCreateTime: v.CreateTime.Format(utils.FormatDateTime),
  1309. PptModifyTime: v.ModifyTime.Format(utils.FormatDateTime),
  1310. PublishTime: utils.DealDateTimeZero(v.PublishTime, utils.FormatDateTime),
  1311. PptPage: pptPage,
  1312. }
  1313. publicPptList = append(publicPptList, tmpV)
  1314. publicPptListMap[v.AdminId] = publicPptList
  1315. }
  1316. // 创建人信息
  1317. systemAdminMap := make(map[int]*system.Admin)
  1318. systemAdminList, err := system.GetAdminListByIdList(adminIdList)
  1319. if err != nil {
  1320. return
  1321. }
  1322. for _, v := range systemAdminList {
  1323. systemAdminMap[v.AdminId] = v
  1324. }
  1325. // 公开分享的用户列表
  1326. {
  1327. for _, v := range publicAdminIdList {
  1328. systemAdmin, ok := systemAdminMap[v]
  1329. if !ok {
  1330. continue
  1331. }
  1332. // ppt 列表信息
  1333. respGroupPptNameListItemList, ok := publicPptListMap[v]
  1334. if !ok {
  1335. respGroupPptNameListItemList = make([]*models.RespGroupPptNameListItem, 0)
  1336. }
  1337. // ppt 分组信息
  1338. tmpRespGroupListItem := &models.RespGroupListItem{
  1339. GroupId: int64(systemAdmin.AdminId),
  1340. GroupName: systemAdmin.RealName + "的PPT",
  1341. AdminId: systemAdmin.AdminId,
  1342. IsShare: 1,
  1343. OnlyOld: false,
  1344. PptList: respGroupPptNameListItemList,
  1345. }
  1346. ret.PublicList = append(ret.PublicList, tmpRespGroupListItem)
  1347. }
  1348. }
  1349. myGrantPPtIdMap := make(map[int]int) //我分配的ppt的id集合
  1350. // 共享Ppt
  1351. {
  1352. for _, v := range grantPptList {
  1353. pptPage := 0
  1354. // 因之前并没有存储PPT页数字段,所以此处读取PPT内容的长度
  1355. if v.Content != "" {
  1356. contents := make([]PageContent, 0)
  1357. if e := json.Unmarshal([]byte(v.Content), &contents); e != nil {
  1358. err = errors.New("解析PPT内容页数失败: " + e.Error())
  1359. return
  1360. }
  1361. }
  1362. title := v.Title
  1363. if adminInfo, ok := systemAdminMap[v.AdminId]; ok {
  1364. title = adminInfo.RealName + "———" + title
  1365. }
  1366. tmp := &models.RespGroupPptNameListItem{
  1367. AdminId: v.AdminId,
  1368. //GroupPptId: v.GroupPptId,
  1369. PptId: int64(v.PptId),
  1370. AdminRealName: v.AdminRealName,
  1371. Title: title,
  1372. PptVersion: v.PptVersion,
  1373. IsSingleShare: v.IsShare,
  1374. PptxUrl: v.PptxUrl,
  1375. ReportId: v.ReportId,
  1376. ReportCode: v.ReportCode,
  1377. PptCreateTime: v.CreateTime.Format(utils.FormatDateTime),
  1378. PptModifyTime: v.ModifyTime.Format(utils.FormatDateTime),
  1379. PublishTime: utils.DealDateTimeZero(v.PublishTime, utils.FormatDateTime),
  1380. PptPage: pptPage,
  1381. }
  1382. //如果只展示新版ppt,则过滤旧版的Ppt
  1383. if IsNewPpt == 1 && v.PptVersion == 1 {
  1384. continue
  1385. }
  1386. if v.AdminId == adminId {
  1387. tmp.IsGrant = 1
  1388. myPptList = append(myPptList, tmp)
  1389. myGrantPPtIdMap[v.PptId] = v.PptId
  1390. } else {
  1391. tmp.IsReceived = 1
  1392. otherPptList = append(otherPptList, tmp)
  1393. }
  1394. }
  1395. grantList[0].PptList = myPptList
  1396. grantList[1].PptList = otherPptList
  1397. ret.GrantList = grantList
  1398. }
  1399. // 处理公共ppt里面的关于自个的ppt是否有配置权限的字段数据变更
  1400. for k, publicList := range ret.PublicList {
  1401. for kk, pptInfo := range publicList.PptList {
  1402. // 是否有过权限配置
  1403. if _, ok := myGrantPPtIdMap[int(pptInfo.PptId)]; ok {
  1404. pptInfo.IsGrant = 1
  1405. }
  1406. publicList.PptList[kk] = pptInfo
  1407. }
  1408. ret.PublicList[k] = publicList
  1409. }
  1410. for k, privateList := range ret.PrivateList {
  1411. for kk, pptInfo := range privateList.PptList {
  1412. // 是否有过权限配置
  1413. if _, ok := myGrantPPtIdMap[int(pptInfo.PptId)]; ok {
  1414. pptInfo.IsGrant = 1
  1415. }
  1416. privateList.PptList[kk] = pptInfo
  1417. }
  1418. ret.PrivateList[k] = privateList
  1419. }
  1420. //如果只展示新版ppt,则过滤空文件夹
  1421. if IsNewPpt == 1 {
  1422. //公共ppt
  1423. pubList := make([]*models.RespGroupListItem, 0)
  1424. for _, v := range ret.PublicList {
  1425. if len(v.PptList) > 0 {
  1426. pubList = append(pubList, v)
  1427. }
  1428. }
  1429. ret.PublicList = pubList
  1430. // 私有ppt
  1431. priList := make([]*models.RespGroupListItem, 0)
  1432. for _, v := range ret.PrivateList {
  1433. if len(v.PptList) > 0 {
  1434. priList = append(priList, v)
  1435. }
  1436. }
  1437. ret.PrivateList = priList
  1438. }
  1439. return
  1440. }
  1441. // ShareSingleGroupPptV2 共享单个ppt/取消共享单个ppt,返回共享状态
  1442. // @Author roc
  1443. // @Time 2022-08-29 15:22:20
  1444. func ShareSingleGroupPptV2(pptId int, adminId int) (pptInfo *models.PptV2, err error) {
  1445. //判断当前登录者是否有共享的权限
  1446. pptInfo, err = models.GetPptV2ById(pptId)
  1447. if err != nil {
  1448. if err.Error() == utils.ErrNoRow() {
  1449. err = errors.New("当前目录下的ppt不存在")
  1450. return
  1451. }
  1452. err = errors.New("目录下的ppt查询出错:" + err.Error())
  1453. return
  1454. }
  1455. if pptInfo.AdminId != adminId {
  1456. err = errors.New("该Ppt不是本人创建")
  1457. return
  1458. }
  1459. //判断当前的共享状态
  1460. if pptInfo.IsShare > 0 {
  1461. pptInfo.IsShare = 0
  1462. err = pptInfo.Update([]string{"IsShare"})
  1463. if err != nil {
  1464. err = errors.New(err.Error())
  1465. return
  1466. }
  1467. } else {
  1468. pptInfo.IsShare = 1
  1469. err = pptInfo.Update([]string{"IsShare"})
  1470. if err != nil {
  1471. err = errors.New(err.Error())
  1472. return
  1473. }
  1474. }
  1475. return
  1476. }
  1477. // GetMyPptList 我的ppt列表
  1478. // @Author roc
  1479. // @Time 2022-09-05 17:26:21
  1480. func GetMyPptList(adminId int, keyword string) (ret models.RespGroupPptList, err error) {
  1481. list := make([]*models.RespGroupPptListItem, 0)
  1482. ret.List = list
  1483. var condition string
  1484. var pars []interface{}
  1485. condition += ` AND admin_id=? `
  1486. pars = append(pars, adminId)
  1487. if keyword != `` {
  1488. condition += ` AND (title LIKE ? OR admin_real_name LIKE ? ) `
  1489. pars = utils.GetLikeKeywordPars(pars, keyword, 2)
  1490. }
  1491. pptList, err := models.GetAllPptV2List(condition, pars)
  1492. if len(pptList) <= 0 {
  1493. return
  1494. }
  1495. for _, v := range pptList {
  1496. tmpV := &models.RespGroupPptListItem{
  1497. GroupPptId: int64(v.PptId),
  1498. PptId: int64(v.PptId),
  1499. TemplateType: v.TemplateType,
  1500. BackgroundImg: v.BackgroundImg,
  1501. Title: v.Title,
  1502. PptCreateTime: v.CreateTime.Format(utils.FormatDateTime),
  1503. PptModifyTime: v.ModifyTime.Format(utils.FormatDateTime),
  1504. AdminId: v.AdminId,
  1505. AdminRealName: v.AdminRealName,
  1506. PptVersion: v.PptVersion,
  1507. IsSingleShare: v.IsShare,
  1508. PptxUrl: v.PptxUrl,
  1509. ReportId: v.ReportId,
  1510. ReportCode: v.ReportCode,
  1511. PublishTime: utils.DealDateTimeZero(v.PublishTime, utils.FormatDateTime),
  1512. }
  1513. list = append(list, tmpV)
  1514. }
  1515. ret.List = list
  1516. ret.Total = len(list)
  1517. return
  1518. }
  1519. // GetSharePptList 公共目录下的ppt列表
  1520. // @Author roc
  1521. // @Time 2022-08-29 16:27:59
  1522. func GetSharePptList(adminId int, keyword string, isPrivate bool) (ret models.RespGroupPptList, err error) {
  1523. list := make([]*models.RespGroupPptListItem, 0)
  1524. ret.List = list
  1525. var condition string
  1526. var pars []interface{}
  1527. // 公开的ppt
  1528. condition += ` AND is_share=? `
  1529. if isPrivate {
  1530. pars = append(pars, 0)
  1531. } else {
  1532. pars = append(pars, 1)
  1533. }
  1534. if adminId > 0 {
  1535. condition += ` AND admin_id=? `
  1536. pars = append(pars, adminId)
  1537. }
  1538. if keyword != `` {
  1539. condition += ` AND (title LIKE ? OR admin_real_name LIKE ? ) `
  1540. pars = utils.GetLikeKeywordPars(pars, keyword, 2)
  1541. }
  1542. pptList, err := models.GetAllPptV2List(condition, pars)
  1543. if len(pptList) <= 0 {
  1544. return
  1545. }
  1546. for _, v := range pptList {
  1547. tmpV := &models.RespGroupPptListItem{
  1548. GroupPptId: int64(v.PptId),
  1549. PptId: int64(v.PptId),
  1550. TemplateType: v.TemplateType,
  1551. BackgroundImg: v.BackgroundImg,
  1552. Title: v.Title,
  1553. PptCreateTime: v.CreateTime.Format(utils.FormatDateTime),
  1554. PptModifyTime: v.ModifyTime.Format(utils.FormatDateTime),
  1555. AdminId: v.AdminId,
  1556. AdminRealName: v.AdminRealName,
  1557. PptVersion: v.PptVersion,
  1558. IsSingleShare: v.IsShare,
  1559. PptxUrl: v.PptxUrl,
  1560. ReportId: v.ReportId,
  1561. ReportCode: v.ReportCode,
  1562. PublishTime: utils.DealDateTimeZero(v.PublishTime, utils.FormatDateTime),
  1563. }
  1564. list = append(list, tmpV)
  1565. }
  1566. ret.List = list
  1567. ret.Total = len(list)
  1568. return
  1569. }
  1570. // GetGrantPptList 公共目录下的ppt列表
  1571. // @Author roc
  1572. // @Time 2022-09-05 15:50:25
  1573. func GetGrantPptList(adminId int, keyword, sourceType string) (ret models.RespGroupPptList, err error) {
  1574. list := make([]*models.RespGroupPptListItem, 0)
  1575. ret.List = list
  1576. var condition string
  1577. var pars []interface{}
  1578. switch sourceType {
  1579. case "my":
  1580. condition += ` AND a.admin_id = ? `
  1581. pars = append(pars, adminId)
  1582. case "other":
  1583. condition += ` AND a.admin_id != ? AND (b.department_id = 1 OR b.grant_admin_id = ?) `
  1584. pars = append(pars, adminId, adminId)
  1585. default:
  1586. err = errors.New("无效的来源")
  1587. return
  1588. }
  1589. if keyword != `` {
  1590. condition += ` AND a.title LIKE ? `
  1591. pars = utils.GetLikeKeywordPars(pars, keyword, 1)
  1592. }
  1593. pptList, err := models.GetGrantList(condition, pars)
  1594. if err != nil {
  1595. return
  1596. }
  1597. if len(pptList) <= 0 {
  1598. return
  1599. }
  1600. for _, v := range pptList {
  1601. tmpV := &models.RespGroupPptListItem{
  1602. GroupPptId: int64(v.PptId),
  1603. PptId: int64(v.PptId),
  1604. TemplateType: v.TemplateType,
  1605. BackgroundImg: v.BackgroundImg,
  1606. Title: v.Title,
  1607. PptCreateTime: v.CreateTime.Format(utils.FormatDateTime),
  1608. PptModifyTime: v.ModifyTime.Format(utils.FormatDateTime),
  1609. AdminId: v.AdminId,
  1610. AdminRealName: v.AdminRealName,
  1611. PptVersion: v.PptVersion,
  1612. IsSingleShare: v.IsShare,
  1613. PptxUrl: v.PptxUrl,
  1614. ReportId: v.ReportId,
  1615. ReportCode: v.ReportCode,
  1616. PublishTime: utils.DealDateTimeZero(v.PublishTime, utils.FormatDateTime),
  1617. }
  1618. list = append(list, tmpV)
  1619. }
  1620. ret.List = list
  1621. ret.Total = len(list)
  1622. return
  1623. }
  1624. // SearchPptList PPT搜索(我的/公开PPT)
  1625. func SearchPptList(adminId int, keyword string) (ret models.RespGroupPptList, err error) {
  1626. list := make([]*models.RespGroupPptListItem, 0)
  1627. ret.List = list
  1628. var condition string
  1629. var pars []interface{}
  1630. // 公开的PPT或是我的非公开PPT
  1631. condition += ` AND (is_share = 1 OR (admin_id = ? AND is_share = 0)) `
  1632. pars = append(pars, adminId)
  1633. if keyword != `` {
  1634. kw := fmt.Sprint("%", keyword, "%")
  1635. condition += ` AND (title LIKE ? OR admin_real_name LIKE ? ) `
  1636. pars = append(pars, kw, kw)
  1637. }
  1638. pptList, err := models.GetAllPptV2List(condition, pars)
  1639. if len(pptList) <= 0 {
  1640. return
  1641. }
  1642. for _, v := range pptList {
  1643. tmpV := &models.RespGroupPptListItem{
  1644. GroupPptId: int64(v.PptId),
  1645. PptId: int64(v.PptId),
  1646. TemplateType: v.TemplateType,
  1647. BackgroundImg: v.BackgroundImg,
  1648. Title: v.Title,
  1649. PptCreateTime: v.CreateTime.Format(utils.FormatDateTime),
  1650. AdminId: v.AdminId,
  1651. AdminRealName: v.AdminRealName,
  1652. PptVersion: v.PptVersion,
  1653. IsSingleShare: v.IsShare,
  1654. PptxUrl: v.PptxUrl,
  1655. ReportId: v.ReportId,
  1656. ReportCode: v.ReportCode,
  1657. }
  1658. list = append(list, tmpV)
  1659. }
  1660. ret.List = list
  1661. ret.Total = len(list)
  1662. return
  1663. }