docChangeService.go 3.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121
  1. package stdlib
  2. import (
  3. jyDocsRpcUtil "app.yhyue.com/moapp/jy_docs/services/util"
  4. elastic "app.yhyue.com/moapp/jybase/esv7"
  5. "errors"
  6. "gorm.io/gorm"
  7. "log"
  8. "time"
  9. )
  10. const DocOn = 1
  11. const DocOff = 0
  12. // 上架文档
  13. func ChangeDocumentOn(id string, reason int32) bool {
  14. // 查文档
  15. docData := map[string]interface{}{}
  16. rs := jyDocsRpcUtil.GetJyDocsDB().Table("doc").Where("id=? and isDelete=0 and downOrUp=0", id).Find(&docData)
  17. if rs.Error != nil {
  18. log.Println("上架文档 error:"+id, rs.Error)
  19. return false
  20. } else {
  21. if docData["id"] == nil {
  22. log.Println("上架文档 error:"+id, "文档不存在或已经被上架")
  23. return false
  24. }
  25. }
  26. statisticsData := map[string]interface{}{}
  27. var downTimes int64
  28. var viewTimes int64
  29. result := jyDocsRpcUtil.GetJyDocsDB().Table("doc_statistics").Where("docId=?", id).Find(&statisticsData)
  30. if result.Error != nil {
  31. log.Println("上架文档 查询浏览次数下载量出错 error:"+id, result.Error)
  32. return false
  33. } else {
  34. if statisticsData["id"] != nil {
  35. if statisticsData["downTimes"] != nil {
  36. downTimes = statisticsData["downTimes"].(int64)
  37. }
  38. if statisticsData["viewTimes"] != nil {
  39. viewTimes = statisticsData["viewTimes"].(int64)
  40. }
  41. }
  42. }
  43. // 上架
  44. err := jyDocsRpcUtil.GetJyDocsDB().Transaction(func(tx *gorm.DB) error {
  45. // 更新大库状态为上架 1-上架
  46. if err := tx.Exec("update doc set downOrUp=? where id=? ", DocOn, id).Error; err != nil {
  47. return err
  48. }
  49. // 存上架记录
  50. date := time.Now().Local().Format("2006-01-02 15:04:05")
  51. if err := tx.Exec("insert into doc_change_record (docId,date,downOrUp,reason) values (?,?,?,?)", id, date, DocOn, reason).Error; err != nil {
  52. return err
  53. }
  54. docData["_id"] = docData["id"]
  55. saveData := map[string]interface{}{
  56. "_id": docData["id"],
  57. "docName": docData["docName"],
  58. "docTags": docData["docTags"],
  59. "docClassLevelOne": docData["docClassLevelOne"],
  60. "docClassLevelTwo": docData["docClassLevelTwo"],
  61. "price": docData["price"],
  62. "downTimes": downTimes,
  63. "viewTimes": viewTimes,
  64. "docSummary": docData["docSummary"],
  65. "create_at": docData["uploadDate"].(time.Time).Format("2006-01-02 15:04:05"),
  66. }
  67. if rs := elastic.Save("jydoc", "_doc", saveData); rs != true {
  68. return errors.New("发布到检索库失败")
  69. }
  70. return nil
  71. })
  72. if err != nil {
  73. log.Println("上架文档 error:"+id, err)
  74. return false
  75. }
  76. log.Println("上架文档成功:" + id)
  77. return true
  78. }
  79. // 下架文档
  80. func ChangeDocumentOff(id string, reason int32) bool {
  81. // 查文档
  82. docData := map[string]interface{}{}
  83. rs := jyDocsRpcUtil.GetJyDocsDB().Table("doc").Where("id=? and isDelete=0 and downOrUp=1", id).Find(&docData)
  84. if rs.Error != nil {
  85. log.Println("下架文档 error:"+id, rs.Error)
  86. return false
  87. } else {
  88. if docData["id"] == nil {
  89. log.Println("下架文档 error:"+id, "文档不存在或已经被下架")
  90. return false
  91. }
  92. }
  93. // 下架
  94. err := jyDocsRpcUtil.GetJyDocsDB().Transaction(func(tx *gorm.DB) error {
  95. // 更新大库状态为下架 0-下架
  96. if err := tx.Exec("update doc set downOrUp=? where id=? ", DocOff, id).Error; err != nil {
  97. return err
  98. }
  99. // 存下架记录
  100. date := time.Now().Local().Format("2006-01-02 15:04:05")
  101. if err := tx.Exec("insert into doc_change_record (docId,date,downOrUp,reason) values (?,?,?,?)", id, date, DocOff, reason).Error; err != nil {
  102. return err
  103. }
  104. //todo 从es删除数据 索引待替换 及测试
  105. if rs := elastic.DelById("jydoc", "doc", id); rs != true {
  106. return errors.New("从检索库删除失败")
  107. }
  108. return nil
  109. })
  110. if err != nil {
  111. log.Println("下架文档 error:"+id, err)
  112. return false
  113. }
  114. log.Println("下架文档成功:" + id)
  115. return true
  116. }