cygx_yanxuan_special_company.go 5.8 KB

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