cygx_yanxuan_special_company.go 5.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206
  1. package services
  2. import (
  3. "context"
  4. "encoding/json"
  5. "errors"
  6. "fmt"
  7. "hongze/hongze_clpt/models"
  8. "hongze/hongze_clpt/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 && e.Error() != utils.ErrNoRow() {
  76. err = errors.New("GetSellerByCompanyIdCheckFicc, Err: " + e.Error())
  77. return
  78. }
  79. if sellerItem == nil {
  80. return
  81. }
  82. sellerName = sellerItem.RealName
  83. if stopTime >= 3 {
  84. //判断一个用户是否阅读过 某一篇研选专栏
  85. totalRecord, e := models.GetCygxYanxuanSpecialRecordCountByUser(user.UserId, specialId)
  86. if e != nil {
  87. err = errors.New("GetCygxYanxuanSpecialRecordCountByUser, Err: " + e.Error())
  88. return
  89. }
  90. detail, e := models.GetYanxuanSpecialBySpecialId(specialId)
  91. if e != nil {
  92. err = errors.New("GetYanxuanSpecialBySpecialId, Err: " + e.Error())
  93. return
  94. }
  95. item := new(models.CygxYanxuanSpecialRecord)
  96. item.UserId = user.UserId
  97. item.Mobile = user.Mobile
  98. item.Email = user.Email
  99. item.CompanyId = user.CompanyId
  100. item.CompanyName = user.CompanyName
  101. item.RealName = user.RealName
  102. item.SellerName = sellerName
  103. item.CreateTime = time.Now().Add(-time.Duration(stopTime) * time.Second) // 往前推迟的时间就是他的阅读时间
  104. item.ModifyTime = time.Now()
  105. item.RegisterPlatform = utils.REGISTER_PLATFORM
  106. item.YanxuanSpecialId = specialId
  107. item.StopTime = stopTime
  108. _, e = models.AddCygxYanxuanSpecialRecord(item) // 添加历史记录
  109. if e != nil {
  110. err = errors.New("AddCygxYanxuanSpecialRecord, Err: " + e.Error())
  111. return
  112. }
  113. //如果不是弘则研究的人员阅读的,就修改Pv、Uv数量
  114. if user.CompanyId != utils.HZ_COMPANY_ID {
  115. //专栏Pv数量进行加一
  116. e = models.UpdateYanxuanSpecialPv(specialId)
  117. if e != nil {
  118. err = errors.New("UpdateYanxuanSpecialPv, Err: " + e.Error())
  119. return
  120. }
  121. //专栏作者Pv数量进行加一
  122. e = models.UpdateCygxYanxuanSpecialAuthorPv(detail.UserId)
  123. if e != nil {
  124. err = errors.New("UpdateCygxYanxuanSpecialAuthorPv, Err: " + e.Error())
  125. return
  126. }
  127. //如果没有阅读过,那么就给专栏文章的UV、作者的UV进行加一
  128. if totalRecord == 0 {
  129. e = models.UpdateYanxuanSpecialUv(specialId)
  130. if e != nil {
  131. err = errors.New("UpdateYanxuanSpecialUv, Err: " + e.Error())
  132. return
  133. }
  134. //专栏作者Uv数量进行加一
  135. e = models.UpdateCygxYanxuanSpecialAuthorUv(detail.UserId)
  136. if e != nil {
  137. err = errors.New("UpdateCygxYanxuanSpecialAuthorUv, Err: " + e.Error())
  138. return
  139. }
  140. }
  141. }
  142. }
  143. itemLog := new(models.CygxYanxuanSpecialRecordLog)
  144. itemLog.UserId = user.UserId
  145. itemLog.Mobile = user.Mobile
  146. itemLog.Email = user.Email
  147. itemLog.CompanyId = user.CompanyId
  148. itemLog.CompanyName = user.CompanyName
  149. itemLog.RealName = user.RealName
  150. itemLog.SellerName = sellerName
  151. itemLog.CreateTime = time.Now().Add(-time.Duration(stopTime) * time.Second) // 往前推迟的时间就是他的阅读时间
  152. itemLog.ModifyTime = time.Now()
  153. itemLog.RegisterPlatform = utils.REGISTER_PLATFORM
  154. itemLog.YanxuanSpecialId = specialId
  155. itemLog.StopTime = stopTime
  156. _, e = models.AddCygxYanxuanSpecialRecordLog(itemLog) // 添加历史记录
  157. if e != nil {
  158. err = errors.New("AddCygxYanxuanSpecialRecordLog, Err: " + e.Error())
  159. return
  160. }
  161. return
  162. }
  163. // GetYanxuanSpecialRecordByYanxuanSpecialId 获取研选专栏阅读 pv map
  164. func GetYanxuanSpecialRecordByYanxuanSpecialId(articleIds []int) (mapResp map[int]int) {
  165. var err error
  166. defer func() {
  167. if err != nil {
  168. fmt.Println(err)
  169. go utils.SendAlarmMsg("获取研选专栏阅读,信息失败,GetYanxuanSpecialRecordByYanxuanSpecialId Err:"+err.Error(), 3)
  170. }
  171. }()
  172. lenIds := len(articleIds)
  173. if lenIds == 0 {
  174. return
  175. }
  176. var condition string
  177. var pars []interface{}
  178. condition = ` AND yanxuan_special_id IN (` + utils.GetOrmInReplace(lenIds) + `) `
  179. pars = append(pars, articleIds)
  180. listPv, e := models.GetCygxYanxuanSpecialRecordListPv(condition, pars)
  181. if e != nil {
  182. err = errors.New("GetCygxArticleHistoryRecordNewpvListPvCy, Err: " + e.Error())
  183. return
  184. }
  185. mapResp = make(map[int]int, 0)
  186. for _, v := range listPv {
  187. mapResp[v.YanxuanSpecialId] = v.Pv
  188. }
  189. return
  190. }