ppt.go 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "eta/eta_mobile/models"
  5. "eta/eta_mobile/utils"
  6. "github.com/rdlucklib/rdluck_tools/paging"
  7. _ "image/gif"
  8. _ "image/jpeg"
  9. _ "image/png"
  10. "time"
  11. )
  12. // 报告
  13. type PptController struct {
  14. BaseAuthController
  15. }
  16. // @Title 获取ppt列表
  17. // @Description 获取ppt列表接口
  18. // @Param PageSize query int true "每页数据条数"
  19. // @Param CurrentIndex query int true "当前页页码,从1开始"
  20. // @Param KeyWord query string true "搜索关键词"
  21. // @Success 200 {object} models.ReportListResp
  22. // @router /list [get]
  23. func (this *PptController) ListPpt() {
  24. br := new(models.BaseResponse).Init()
  25. defer func() {
  26. this.Data["json"] = br
  27. this.ServeJSON()
  28. }()
  29. sysUser := this.SysUser
  30. if sysUser == nil {
  31. br.Msg = "请登录"
  32. br.ErrMsg = "请登录,SysUser Is Empty"
  33. return
  34. }
  35. pageSize, _ := this.GetInt("PageSize")
  36. currentIndex, _ := this.GetInt("CurrentIndex")
  37. keyWord := this.GetString("KeyWord")
  38. var startSize int
  39. if pageSize <= 0 {
  40. pageSize = utils.PageSize20
  41. }
  42. if currentIndex <= 0 {
  43. currentIndex = 1
  44. }
  45. startSize = utils.StartIndex(currentIndex, pageSize)
  46. var condition string
  47. var pars []interface{}
  48. if keyWord != "" {
  49. //condition += ` AND (title LIKE '%` + keyWord + `%' OR admin_real_name LIKE '%` + keyWord + `%' ) `
  50. likeKey := `%` + keyWord + `%`
  51. condition += ` AND (title LIKE ? OR admin_real_name LIKE ? ) `
  52. pars = append(pars, likeKey)
  53. pars = append(pars, likeKey)
  54. }
  55. total, err := models.GetPptListCount(condition, pars)
  56. if err != nil {
  57. br.Msg = "获取失败"
  58. br.ErrMsg = "获取失败,Err:" + err.Error()
  59. return
  60. }
  61. list, err := models.GetPptList(condition, pars, startSize, pageSize)
  62. if err != nil {
  63. br.Msg = "获取失败"
  64. br.ErrMsg = "获取失败,Err:" + err.Error()
  65. return
  66. }
  67. lenList := len(list)
  68. for i := 0; i < lenList; i++ {
  69. adminId := list[i].AdminId
  70. if adminId == sysUser.AdminId || sysUser.Role == "admin" {
  71. list[i].IsAuth = true
  72. } else {
  73. list[i].IsAuth = false
  74. }
  75. }
  76. page := paging.GetPaging(currentIndex, pageSize, total)
  77. resp := new(models.PptListResp)
  78. resp.Paging = page
  79. resp.List = list
  80. br.Ret = 200
  81. br.Success = true
  82. br.Msg = "获取成功"
  83. br.Data = resp
  84. }
  85. // @Title 新增ppt
  86. // @Description 新增ppt接口
  87. // @Param request body models.AddPptReq true "type json string"
  88. // @Success 200 Ret=200 新增成功
  89. // @router /add [post]
  90. func (this *PptController) AddPpt() {
  91. br := new(models.BaseResponse).Init()
  92. defer func() {
  93. this.Data["json"] = br
  94. this.ServeJSON()
  95. }()
  96. var req models.AddPptReq
  97. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  98. if err != nil {
  99. br.Msg = "参数解析异常!"
  100. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  101. return
  102. }
  103. if req.FirstPage.Title == "" {
  104. br.Msg = "标题不能为空"
  105. return
  106. }
  107. var newId int64
  108. var msg string
  109. if req.PptId <= 0 {
  110. item, err := models.GetPptByTitle(req.FirstPage.Title)
  111. if err != nil && err.Error() != utils.ErrNoRow() {
  112. br.Msg = "获取数据异常!"
  113. br.ErrMsg = "获取数据异常,Err:" + err.Error()
  114. return
  115. }
  116. if item != nil {
  117. br.Msg = "标题已存在,不可重复添加"
  118. return
  119. }
  120. ppt := new(models.Ppt)
  121. ppt.Title = req.FirstPage.Title
  122. ppt.PptDate = req.FirstPage.PptDate
  123. ppt.ReportType = req.FirstPage.ReportType
  124. ppt.CreateTime = time.Now()
  125. ppt.ModifyTime = time.Now()
  126. ppt.AdminId = this.SysUser.AdminId
  127. ppt.AdminRealName = this.SysUser.RealName
  128. ppt.Version = 2
  129. newId, err = models.AddPpt(ppt)
  130. if err != nil {
  131. br.Msg = "新增失败"
  132. br.ErrMsg = "新增失败,Err:" + err.Error()
  133. return
  134. }
  135. firstPage := new(models.PptPages)
  136. firstPage.PptId = newId
  137. firstPage.Title = req.FirstPage.Title
  138. firstPage.ResourceId = "0"
  139. firstPage.Timestamp = 0
  140. firstPage.BackIndex = req.FirstPage.BackIndex
  141. _, err = models.AddPptPages(firstPage)
  142. if err != nil {
  143. br.Msg = "新增失败"
  144. br.ErrMsg = "新增章节失败,Err:" + err.Error()
  145. return
  146. }
  147. for _, v := range req.ContentPage {
  148. if v.ResourceId == "" {
  149. br.Msg = "图表参数错误"
  150. br.ErrMsg = "图表参数错误,ResourceId 等于0"
  151. return
  152. }
  153. count, _ := models.GetPptPagesContent(int(newId), v.ResourceId)
  154. if count <= 0 {
  155. page := new(models.PptPages)
  156. page.PptId = newId
  157. page.Title = v.Title
  158. page.ResourceId = v.ResourceId
  159. page.Timestamp = v.Timestamp
  160. page.CreateTime = time.Now()
  161. page.ModifyTime = time.Now()
  162. _, err = models.AddPptPages(page)
  163. if err != nil {
  164. br.Msg = "新增失败"
  165. br.ErrMsg = "新增章节失败,Err:" + err.Error()
  166. return
  167. }
  168. }
  169. }
  170. msg = "新增成功"
  171. } else {
  172. newId = req.PptId
  173. ppt := new(models.Ppt)
  174. ppt.PptId = int(req.PptId)
  175. ppt.Title = req.FirstPage.Title
  176. ppt.PptDate = req.FirstPage.PptDate
  177. ppt.ReportType = req.FirstPage.ReportType
  178. ppt.ModifyTime = time.Now()
  179. err = models.EditPpt(ppt)
  180. //删除ppt_pages
  181. err = models.DeletePptPages(req.PptId)
  182. if err != nil {
  183. br.Msg = "编辑失败"
  184. br.ErrMsg = "编辑失败,Err:" + err.Error()
  185. return
  186. }
  187. firstPage := new(models.PptPages)
  188. firstPage.PptId = newId
  189. firstPage.Title = req.FirstPage.Title
  190. firstPage.ResourceId = ""
  191. firstPage.Timestamp = 0
  192. firstPage.BackIndex = req.FirstPage.BackIndex
  193. _, err = models.AddPptPages(firstPage)
  194. if err != nil {
  195. br.Msg = "新增失败"
  196. br.ErrMsg = "新增章节失败,Err:" + err.Error()
  197. return
  198. }
  199. for _, v := range req.ContentPage {
  200. if v.ResourceId == "" {
  201. br.Msg = "图表参数错误"
  202. br.ErrMsg = "图表参数错误,ResourceId 等于 empty"
  203. return
  204. }
  205. count, _ := models.GetPptPagesContent(int(newId), v.ResourceId)
  206. if count <= 0 {
  207. page := new(models.PptPages)
  208. page.PptId = newId
  209. page.Title = v.Title
  210. page.ResourceId = v.ResourceId
  211. page.Timestamp = v.Timestamp
  212. page.CreateTime = time.Now()
  213. page.ModifyTime = time.Now()
  214. _, err = models.AddPptPages(page)
  215. if err != nil {
  216. br.Msg = "新增失败"
  217. br.ErrMsg = "新增章节失败,Err:" + err.Error()
  218. return
  219. }
  220. }
  221. }
  222. msg = "保存成功"
  223. }
  224. resp := new(models.AddPptResp)
  225. resp.PptId = newId
  226. br.Ret = 200
  227. br.Success = true
  228. br.Msg = msg
  229. br.Data = resp
  230. }
  231. // @Title 编辑ppt
  232. // @Description 编辑ppt接口
  233. // @Param request body models.EditPptReq true "type json string"
  234. // @Success 200 Ret=200 编辑成功
  235. // @router /edit [post]
  236. func (this *PptController) EditPpt() {
  237. br := new(models.BaseResponse).Init()
  238. defer func() {
  239. this.Data["json"] = br
  240. this.ServeJSON()
  241. }()
  242. var req models.EditPptReq
  243. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  244. if err != nil {
  245. br.Msg = "参数解析异常!"
  246. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  247. return
  248. }
  249. if req.FirstPage.Title == "" {
  250. br.Msg = "标题不能为空"
  251. return
  252. }
  253. item, err := models.GetPptByTitle(req.FirstPage.Title)
  254. if err != nil && err.Error() != utils.ErrNoRow() {
  255. br.Msg = "获取数据异常!"
  256. br.ErrMsg = "获取数据异常,Err:" + err.Error()
  257. return
  258. }
  259. if item != nil && item.PptId != int(req.PptId) {
  260. br.Msg = "标题已存在,不可重复添加"
  261. return
  262. }
  263. ppt := new(models.Ppt)
  264. ppt.PptId = int(req.PptId)
  265. ppt.Title = req.FirstPage.Title
  266. ppt.PptDate = req.FirstPage.PptDate
  267. ppt.ReportType = req.FirstPage.ReportType
  268. ppt.ModifyTime = time.Now()
  269. err = models.EditPpt(ppt)
  270. if err != nil {
  271. br.Msg = "编辑失败"
  272. br.ErrMsg = "编辑失败,Err:" + err.Error()
  273. return
  274. }
  275. newId := req.PptId
  276. //删除ppt_pages
  277. err = models.DeletePptPages(newId)
  278. if err != nil {
  279. br.Msg = "编辑失败"
  280. br.ErrMsg = "编辑失败,Err:" + err.Error()
  281. return
  282. }
  283. firstPage := new(models.PptPages)
  284. firstPage.PptId = newId
  285. firstPage.Title = req.FirstPage.Title
  286. firstPage.ResourceId = "0"
  287. firstPage.Timestamp = 0
  288. firstPage.BackIndex = req.FirstPage.BackIndex
  289. _, err = models.AddPptPages(firstPage)
  290. if err != nil {
  291. br.Msg = "编辑失败"
  292. br.ErrMsg = "新增章节失败,Err:" + err.Error()
  293. return
  294. }
  295. for _, v := range req.ContentPage {
  296. if v.ResourceId == "" {
  297. br.Msg = "图表参数错误"
  298. br.ErrMsg = "图表参数错误,ResourceId 等于 empty"
  299. return
  300. }
  301. count, _ := models.GetPptPagesContent(int(newId), v.ResourceId)
  302. if count <= 0 {
  303. page := new(models.PptPages)
  304. page.PptId = newId
  305. page.Title = v.Title
  306. page.ResourceId = v.ResourceId
  307. page.Timestamp = v.Timestamp
  308. page.CreateTime = time.Now()
  309. page.ModifyTime = time.Now()
  310. _, err = models.AddPptPages(page)
  311. if err != nil {
  312. br.Msg = "编辑失败"
  313. br.ErrMsg = "新增章节失败,Err:" + err.Error()
  314. return
  315. }
  316. }
  317. }
  318. resp := new(models.AddPptResp)
  319. resp.PptId = req.PptId
  320. br.Ret = 200
  321. br.Success = true
  322. br.Msg = "编辑成功"
  323. br.Data = resp
  324. }
  325. // @Title 删除ppt
  326. // @Description 删除ppt接口
  327. // @Param request body models.DeletePptReq true "type json string"
  328. // @Success 200 Ret=200 编辑成功
  329. // @router /delete [post]
  330. func (this *PptController) DeletePpt() {
  331. br := new(models.BaseResponse).Init()
  332. defer func() {
  333. this.Data["json"] = br
  334. this.ServeJSON()
  335. }()
  336. var req models.DeletePptReq
  337. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  338. if err != nil {
  339. br.Msg = "参数解析异常!"
  340. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  341. return
  342. }
  343. if req.PptId <= 0 {
  344. br.Msg = "参数错误"
  345. return
  346. }
  347. err = models.DeletePpt(req.PptId)
  348. if err != nil {
  349. br.Msg = "删除失败"
  350. br.ErrMsg = "删除失败,Err:" + err.Error()
  351. return
  352. }
  353. br.Ret = 200
  354. br.Success = true
  355. br.Msg = "删除成功"
  356. }
  357. // @Title 新增ppt章节
  358. // @Description 新增ppt章节接口
  359. // @Param request body models.ContentPageItems true "type json string"
  360. // @Success 200 Ret=200 编辑成功
  361. // @router /addPptPages [post]
  362. func (this *PptController) AddPptPages() {
  363. br := new(models.BaseResponse).Init()
  364. defer func() {
  365. this.Data["json"] = br
  366. this.ServeJSON()
  367. }()
  368. var req models.ContentPageItems
  369. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  370. if err != nil {
  371. br.Msg = "参数解析异常!"
  372. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  373. return
  374. }
  375. page := new(models.PptPages)
  376. page.PptId = req.PptId
  377. page.Title = req.Title
  378. page.CreateTime = time.Now()
  379. page.ModifyTime = time.Now()
  380. page.ResourceId = req.ResourceId
  381. _, err = models.AddPptPages(page)
  382. if err != nil {
  383. br.Msg = "新增失败"
  384. br.ErrMsg = "新增失败,Err:" + err.Error()
  385. return
  386. }
  387. br.Ret = 200
  388. br.Success = true
  389. br.Msg = "新增成功"
  390. }
  391. // @Title 获取ppt详情
  392. // @Description 获取ppt详情接口
  393. // @Param PptId query int true "ppt_id"
  394. // @Success 200 {object} models.ReportListResp
  395. // @router /detail [get]
  396. func (this *PptController) DetailPpt() {
  397. br := new(models.BaseResponse).Init()
  398. defer func() {
  399. this.Data["json"] = br
  400. this.ServeJSON()
  401. }()
  402. pptId, _ := this.GetInt("PptId")
  403. ppt, err := models.GetPptById(pptId)
  404. if err != nil {
  405. br.Msg = "信息获取失败"
  406. br.ErrMsg = "信息获取失败,Err:" + err.Error()
  407. return
  408. }
  409. pptPages, err := models.GetPptPagesById(pptId)
  410. if err != nil {
  411. br.Msg = "信息获取失败"
  412. br.ErrMsg = "信息获取失败,Err:" + err.Error()
  413. return
  414. }
  415. resp := new(models.PptDetailResp)
  416. resp.Ppt = ppt
  417. resp.PptPages = pptPages
  418. br.Ret = 200
  419. br.Success = true
  420. br.Msg = "获取成功"
  421. br.Data = resp
  422. }
  423. type PptCommonController struct {
  424. BaseCommonController
  425. }
  426. // @Title ppt下载
  427. // @Description ppt下载
  428. // @Param PptId query int true "PptId"
  429. // @Success 200 下载成功
  430. // @router /download [get]
  431. func (this *PptCommonController) Download() {
  432. br := new(models.BaseResponse).Init()
  433. defer func() {
  434. this.Data["json"] = br
  435. this.ServeJSON()
  436. }()
  437. pptId, err := this.GetInt("PptId")
  438. if err != nil {
  439. br.Msg = "参数错误"
  440. br.ErrMsg = "获取,pptId,Err:" + err.Error()
  441. return
  442. }
  443. ppt, err := models.GetPptById(pptId)
  444. if err != nil {
  445. br.Msg = "获取信息失败"
  446. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  447. return
  448. }
  449. filePath := ppt.PptUrl + ".ppt"
  450. fileName := ppt.Title + ".ppt"
  451. this.Ctx.Output.Download(filePath, fileName)
  452. br.Success = true
  453. br.Ret = 200
  454. br.Msg = "下载成功"
  455. return
  456. }
  457. // @Title ppt下载
  458. // @Description ppt下载
  459. // @Param PptId query int true "PptId"
  460. // @Success 200 下载成功
  461. // @router /downloadpptx [get]
  462. func (this *PptCommonController) Downloadpptx() {
  463. br := new(models.BaseResponse).Init()
  464. defer func() {
  465. this.Data["json"] = br
  466. this.ServeJSON()
  467. }()
  468. pptId, err := this.GetInt("PptId")
  469. if err != nil {
  470. br.Msg = "参数错误"
  471. br.ErrMsg = "获取,pptId,Err:" + err.Error()
  472. return
  473. }
  474. ppt, err := models.GetPptById(pptId)
  475. if err != nil {
  476. br.Msg = "获取信息失败"
  477. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  478. return
  479. }
  480. filePath := ppt.PptUrl + ".pptx"
  481. fileName := ppt.Title + ".pptx"
  482. this.Ctx.Output.Download(filePath, fileName)
  483. br.Success = true
  484. br.Ret = 200
  485. br.Msg = "下载成功"
  486. return
  487. }
  488. // @Title 获取首页背景模板接口
  489. // @Description 获取首页背景模板接口
  490. // @Success 200 {object} models.PptImagesResp
  491. // @router /getImages [get]
  492. func (this *PptController) GetImages() {
  493. br := new(models.BaseResponse).Init()
  494. defer func() {
  495. this.Data["json"] = br
  496. this.ServeJSON()
  497. }()
  498. imageType := 0
  499. ppt, err := models.GetImages(imageType)
  500. if err != nil {
  501. br.Msg = "获取信息失败"
  502. br.ErrMsg = "获取信息失败,Err:" + err.Error()
  503. return
  504. }
  505. resp := new(models.PptImagesResp)
  506. resp.List = ppt
  507. br.Data = resp
  508. br.Ret = 200
  509. br.Success = true
  510. br.Msg = "获取成功"
  511. return
  512. }
  513. type PublishPptResult struct {
  514. Result string `json:"result"`
  515. PptPath string `json:"ppt_path"`
  516. PptName string `json:"ppt_name"`
  517. PptFullPath string `json:"ppt_full_path"`
  518. }
  519. /*
  520. func init() {
  521. fmt.Println("start")
  522. var err error
  523. defer func() {
  524. if err != nil {
  525. fmt.Println("err:", err.Error())
  526. }
  527. }()
  528. pptId := 111
  529. if pptId <= 0 {
  530. return
  531. }
  532. pptFirstPages, err := models.GetPptFirstPage(pptId)
  533. if err != nil {
  534. return
  535. }
  536. pptContentPages, err := models.GetPptContentPages(pptId, pptFirstPages.PptPagesId)
  537. if err != nil {
  538. return
  539. }
  540. dataMap := make(map[string]interface{})
  541. dataMap["FirstPage"] = pptFirstPages
  542. dataMap["ContentPage"] = pptContentPages
  543. dataMap["ScreenHeight"] = 12000
  544. postUrl := "http://127.0.0.1:5000/publish_ppt/" //随便写的
  545. postData, err := json.Marshal(dataMap)
  546. if err != nil {
  547. return
  548. }
  549. utils.FileLog.Info("%s",string(postData))
  550. result, err := http.Post(postUrl, string(postData))
  551. fmt.Println("result:", string(result))
  552. if err != nil {
  553. return
  554. }
  555. var pptResult PublishPptResult
  556. err = json.Unmarshal(result, &pptResult)
  557. if err != nil {
  558. return
  559. }
  560. fmt.Println("ppt:", pptResult.PptFullPath)
  561. fmt.Println("end")
  562. }
  563. */
  564. /*func init() {
  565. fmt.Println("start")
  566. fmt.Println(time.Now())
  567. randStr := utils.GetRandStringNoSpecialChar(28)
  568. fileName := randStr + ".png"
  569. savePath := "./b1.jpg"
  570. resourceUrl, err := services.UploadAliyun(fileName, savePath)
  571. if err != nil {
  572. fmt.Println("err:", err)
  573. }
  574. fmt.Println(resourceUrl)
  575. fmt.Println(time.Now())
  576. fmt.Println("end")
  577. }
  578. */