ppt_english_group.go 41 KB

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