cygx_yanxuan_special_company.go 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203
  1. package services
  2. import (
  3. "context"
  4. "encoding/json"
  5. "errors"
  6. "fmt"
  7. "hongze/hongze_web_mfyx/models"
  8. "hongze/hongze_web_mfyx/utils"
  9. "io/ioutil"
  10. "net/http"
  11. "time"
  12. )
  13. func GetStocksFromVmp(cont context.Context) (err error) {
  14. defer func() {
  15. if err != nil {
  16. fmt.Println("err:", err)
  17. go utils.SendAlarmMsg("更新上市公司表失败"+err.Error(), 2)
  18. }
  19. }()
  20. err = models.DelYanxuanSpecialCompany()
  21. if err != nil {
  22. fmt.Println("获取上市公司信息失败 Err:%s", err.Error())
  23. return
  24. }
  25. getUrl := "https://vmp.hzinsights.com/v2api/articles/stock"
  26. result, err := http.Get(getUrl)
  27. if err != nil {
  28. return
  29. }
  30. defer result.Body.Close()
  31. body, err := ioutil.ReadAll(result.Body)
  32. if err != nil {
  33. fmt.Println("err:" + err.Error())
  34. return
  35. }
  36. fmt.Println(body)
  37. var resp models.VmpStocks
  38. err = json.Unmarshal(body, &resp)
  39. if err != nil {
  40. fmt.Println("获取上市公司信息失败 Err:%s", err.Error())
  41. return
  42. }
  43. items := make([]*models.CygxYanxuanSpecialCompany, 0)
  44. for i, _ := range resp.Data {
  45. items = append(items, &resp.Data[i])
  46. if len(items) > 5000 {
  47. err = models.AddCygxYanxuanSpecialCompanyMulti(items)
  48. if err != nil {
  49. fmt.Println("AddCygxYanxuanSpecialCompanyMulti Err:%s", err.Error())
  50. return
  51. }
  52. items = []*models.CygxYanxuanSpecialCompany{}
  53. }
  54. }
  55. err = models.AddCygxYanxuanSpecialCompanyMulti(items)
  56. if err != nil {
  57. fmt.Println("AddCygxYanxuanSpecialCompanyMulti Err:%s", err.Error())
  58. return
  59. }
  60. return
  61. }
  62. // 记录用户阅读时长
  63. func AddSpecialRecord(user *models.WxUserItem, specialId, stopTime int) (err error) {
  64. if user.UserId == 0 {
  65. return
  66. }
  67. defer func() {
  68. if err != nil {
  69. go utils.SendAlarmMsg(fmt.Sprint("记录用户阅读时长 失败 AddSpecialRecord Err:"+err.Error(), "userId:", user.UserId, "specialId:", specialId), 2)
  70. }
  71. }()
  72. var sellerName string
  73. //获取销售信息
  74. sellerItem, e := models.GetSellerByCompanyIdCheckFicc(user.CompanyId, 2)
  75. if e != nil {
  76. err = errors.New("GetSellerByCompanyIdCheckFicc, Err: " + e.Error())
  77. return
  78. }
  79. sellerName = sellerItem.RealName
  80. if stopTime >= 3 {
  81. //判断一个用户是否阅读过 某一篇研选专栏
  82. totalRecord, e := models.GetCygxYanxuanSpecialRecordCountByUser(user.UserId, specialId)
  83. if e != nil {
  84. err = errors.New("GetCygxYanxuanSpecialRecordCountByUser, Err: " + e.Error())
  85. return
  86. }
  87. detail, e := models.GetYanxuanSpecialBySpecialId(specialId)
  88. if e != nil {
  89. err = errors.New("GetYanxuanSpecialBySpecialId, Err: " + e.Error())
  90. return
  91. }
  92. item := new(models.CygxYanxuanSpecialRecord)
  93. item.UserId = user.UserId
  94. item.Mobile = user.Mobile
  95. item.Email = user.Email
  96. item.CompanyId = user.CompanyId
  97. item.CompanyName = user.CompanyName
  98. item.RealName = user.RealName
  99. item.SellerName = sellerName
  100. item.CreateTime = time.Now().Add(-time.Duration(stopTime) * time.Second) // 往前推迟的时间就是他的阅读时间
  101. item.ModifyTime = time.Now()
  102. item.RegisterPlatform = utils.REGISTER_PLATFORM
  103. item.YanxuanSpecialId = specialId
  104. item.StopTime = stopTime
  105. _, e = models.AddCygxYanxuanSpecialRecord(item) // 添加历史记录
  106. if e != nil {
  107. err = errors.New("AddCygxYanxuanSpecialRecord, Err: " + e.Error())
  108. return
  109. }
  110. //如果不是弘则研究的人员阅读的,就修改Pv、Uv数量
  111. if user.CompanyId != utils.HZ_COMPANY_ID {
  112. //专栏Pv数量进行加一
  113. e = models.UpdateYanxuanSpecialPv(specialId)
  114. if e != nil {
  115. err = errors.New("UpdateYanxuanSpecialPv, Err: " + e.Error())
  116. return
  117. }
  118. //专栏作者Pv数量进行加一
  119. e = models.UpdateCygxYanxuanSpecialAuthorPv(detail.UserId)
  120. if e != nil {
  121. err = errors.New("UpdateCygxYanxuanSpecialAuthorPv, Err: " + e.Error())
  122. return
  123. }
  124. //如果没有阅读过,那么就给专栏文章的UV、作者的UV进行加一
  125. if totalRecord == 0 {
  126. e = models.UpdateYanxuanSpecialUv(specialId)
  127. if e != nil {
  128. err = errors.New("UpdateYanxuanSpecialUv, Err: " + e.Error())
  129. return
  130. }
  131. //专栏作者Uv数量进行加一
  132. e = models.UpdateCygxYanxuanSpecialAuthorUv(detail.UserId)
  133. if e != nil {
  134. err = errors.New("UpdateCygxYanxuanSpecialAuthorUv, Err: " + e.Error())
  135. return
  136. }
  137. }
  138. }
  139. }
  140. itemLog := new(models.CygxYanxuanSpecialRecordLog)
  141. itemLog.UserId = user.UserId
  142. itemLog.Mobile = user.Mobile
  143. itemLog.Email = user.Email
  144. itemLog.CompanyId = user.CompanyId
  145. itemLog.CompanyName = user.CompanyName
  146. itemLog.RealName = user.RealName
  147. itemLog.SellerName = sellerName
  148. itemLog.CreateTime = time.Now().Add(-time.Duration(stopTime) * time.Second) // 往前推迟的时间就是他的阅读时间
  149. itemLog.ModifyTime = time.Now()
  150. itemLog.RegisterPlatform = utils.REGISTER_PLATFORM
  151. itemLog.YanxuanSpecialId = specialId
  152. itemLog.StopTime = stopTime
  153. _, e = models.AddCygxYanxuanSpecialRecordLog(itemLog) // 添加历史记录
  154. if e != nil {
  155. err = errors.New("AddCygxYanxuanSpecialRecordLog, Err: " + e.Error())
  156. return
  157. }
  158. return
  159. }
  160. // GetYanxuanSpecialRecordByYanxuanSpecialId 获取研选专栏阅读 pv map
  161. func GetYanxuanSpecialRecordByYanxuanSpecialId(articleIds []int) (mapResp map[int]int) {
  162. var err error
  163. defer func() {
  164. if err != nil {
  165. fmt.Println(err)
  166. go utils.SendAlarmMsg("获取研选专栏阅读,信息失败,GetYanxuanSpecialRecordByYanxuanSpecialId Err:"+err.Error(), 3)
  167. }
  168. }()
  169. lenIds := len(articleIds)
  170. if lenIds == 0 {
  171. return
  172. }
  173. var condition string
  174. var pars []interface{}
  175. condition = ` AND yanxuan_special_id IN (` + utils.GetOrmInReplace(lenIds) + `) `
  176. pars = append(pars, articleIds)
  177. listPv, e := models.GetCygxYanxuanSpecialRecordListPv(condition, pars)
  178. if e != nil {
  179. err = errors.New("GetCygxArticleHistoryRecordNewpvListPvCy, Err: " + e.Error())
  180. return
  181. }
  182. mapResp = make(map[int]int, 0)
  183. for _, v := range listPv {
  184. mapResp[v.YanxuanSpecialId] = v.Pv
  185. }
  186. return
  187. }