user_bind.go 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241
  1. package user
  2. import (
  3. "context"
  4. "errors"
  5. "fmt"
  6. "hongze/hongze_yb/global"
  7. "hongze/hongze_yb/models/tables/rddp/msg_code"
  8. "hongze/hongze_yb/models/tables/rddp/session"
  9. "hongze/hongze_yb/models/tables/user_record"
  10. "hongze/hongze_yb/models/tables/wx_user"
  11. "hongze/hongze_yb/models/tables/wx_user_log"
  12. "hongze/hongze_yb/utils"
  13. "strconv"
  14. "time"
  15. )
  16. // BindWxUser 用户注册/绑定
  17. func BindWxUser(openid, mobile, email, code string, bindType, areaNum, registerPlatform int) (token string, userInfo UserInfo, err error, errMsg string) {
  18. switch bindType {
  19. case 1: //手机号
  20. _, tmpErr := msg_code.GetMsgCode(mobile, code)
  21. if tmpErr != nil {
  22. if err == utils.ErrNoRow {
  23. err = errors.New("校验验证码失败,Err:" + tmpErr.Error())
  24. errMsg = "校验验证码失败"
  25. return
  26. } else {
  27. err = errors.New("校验验证码失败,Err:" + tmpErr.Error())
  28. errMsg = "验证码错误,请重新输入"
  29. return
  30. }
  31. }
  32. case 2: //邮箱
  33. _, tmpErr := msg_code.GetMsgCode(email, code)
  34. if tmpErr != nil {
  35. if err == utils.ErrNoRow {
  36. err = errors.New("校验验证码失败,Err:" + tmpErr.Error())
  37. errMsg = "校验验证码失败"
  38. return
  39. } else {
  40. err = errors.New("校验验证码失败,Err:" + tmpErr.Error())
  41. errMsg = "验证码错误,请重新输入"
  42. return
  43. }
  44. }
  45. default:
  46. err = errors.New("无效的绑定方式,bindType:" + strconv.Itoa(bindType))
  47. errMsg = "无效的绑定方式"
  48. return
  49. }
  50. userInfo, err = bindWxUser(openid, mobile, email, areaNum, registerPlatform)
  51. if err != nil {
  52. errMsg = "绑定失败:" + err.Error()
  53. return
  54. }
  55. sessionItem, err := session.GetTokenByOpenId(userInfo.OpenID)
  56. if err != nil && err != utils.ErrNoRow {
  57. errMsg = "登录失败"
  58. err = errors.New("登录失败,获取token失败:" + err.Error())
  59. return
  60. }
  61. if sessionItem == nil || (err != nil && err == utils.ErrNoRow) {
  62. timeUnix := time.Now().Unix()
  63. timeUnixStr := strconv.FormatInt(timeUnix, 10)
  64. token = utils.MD5(userInfo.OpenID) + utils.MD5(timeUnixStr)
  65. //新增session
  66. {
  67. sessionInfo := &session.Session{
  68. OpenID: userInfo.OpenID,
  69. UserID: int64(userInfo.UserID),
  70. CreatedTime: time.Now(),
  71. LastUpdatedTime: time.Now(),
  72. ExpireTime: time.Now().AddDate(0, 1, 0),
  73. AccessToken: token,
  74. }
  75. tmpErr := sessionInfo.Create()
  76. if tmpErr != nil {
  77. errMsg = "登录失败"
  78. err = errors.New("登录失败,新增用户session信息失败:" + tmpErr.Error())
  79. return
  80. }
  81. }
  82. } else {
  83. token = sessionItem.AccessToken
  84. _ = sessionItem.UpdateSession(int64(userInfo.UserID), time.Now().AddDate(0, 1, 0))
  85. }
  86. tmpErr := wx_user.ModifyFirstLogin(userInfo.UserID)
  87. if err != nil {
  88. fmt.Println("变更联系人是否第一次登录失败,ERR:", tmpErr)
  89. return
  90. }
  91. //新增登录日志
  92. //新增登录日志
  93. {
  94. loginLog := &wx_user_log.WxUserLog{
  95. UserID: int(userInfo.UserID),
  96. OpenID: userInfo.OpenID,
  97. UnionID: userInfo.UnionID,
  98. Email: userInfo.Email,
  99. Mobile: userInfo.Mobile,
  100. CreateTime: time.Now(),
  101. Handle: "yb_login",
  102. Remark: token,
  103. }
  104. go loginLog.Create()
  105. }
  106. return
  107. }
  108. // bindWxUser 用户注册/绑定
  109. func bindWxUser(openid, mobile, email string, areaNum, registerPlatform int) (userInfo UserInfo, err error) {
  110. var source int8
  111. source = 6 //绑定来源,1:微信端,2:pc网页端,3:查研观向小程序,4:每日咨询
  112. if mobile == "" && email == "" {
  113. err = errors.New("手机号或邮箱必填一个")
  114. return
  115. }
  116. var bindAccount string
  117. var wxUser *wx_user.WxUser
  118. needCreateWxUser := true
  119. //根据手机号获取用户信息
  120. if mobile != "" {
  121. tmpWxUser, wxUserErr := wx_user.GetByMobile(mobile)
  122. if wxUserErr != nil {
  123. if wxUserErr != utils.ErrNoRow {
  124. err = wxUserErr
  125. return
  126. }
  127. } else {
  128. needCreateWxUser = false
  129. wxUser = tmpWxUser
  130. bindAccount = mobile
  131. }
  132. }
  133. //根据邮箱获取用户信息
  134. if needCreateWxUser && email != "" {
  135. tmpWxUser, wxUserErr := wx_user.GetByEmail(email)
  136. if wxUserErr != nil {
  137. if wxUserErr != utils.ErrNoRow {
  138. err = wxUserErr
  139. return
  140. }
  141. } else {
  142. needCreateWxUser = false
  143. wxUser = tmpWxUser
  144. bindAccount = email
  145. }
  146. }
  147. //查询openid的第三方(微信)信息
  148. userRecord, err := user_record.GetByOpenID(openid)
  149. if err != nil {
  150. return
  151. }
  152. var userId int
  153. //如果查询出来的结果是空,那么需要新增用户
  154. if needCreateWxUser {
  155. key := "bind_wx_user:mobile:" + mobile + ":email:" + email
  156. isHas, _ := global.Redis.Exists(context.TODO(), key).Result()
  157. if isHas > 0 {
  158. err = errors.New("多次提交,请关闭页面重新进入")
  159. return
  160. }
  161. global.Redis.SetNX(context.TODO(), key, "ok", time.Second*300)
  162. addwxUser := &wx_user.WxUser{
  163. CompanyID: 1,
  164. CreatedTime: time.Now(),
  165. FirstLogin: 1,
  166. Enabled: 1,
  167. RegisterPlatform: int8(registerPlatform), //账号注册来源,注册平台,1:微信端,2:PC网页端
  168. RegisterTime: time.Now(),
  169. Mobile: mobile,
  170. Email: email,
  171. IsRegister: 1,
  172. Source: source,
  173. CountryCode: strconv.Itoa(areaNum),
  174. OutboundMobile: mobile,
  175. OutboundCountryCode: strconv.Itoa(areaNum),
  176. }
  177. addUserErr := addwxUser.Create()
  178. //添加完成,清除缓存
  179. _ = global.Redis.Del(context.TODO(), key)
  180. if addUserErr != nil {
  181. err = addUserErr
  182. return
  183. }
  184. userId = int(addwxUser.UserID)
  185. tmpWxUser, _ := wx_user.GetByUserId(userId)
  186. wxUser = tmpWxUser
  187. } else {
  188. userId = int(wxUser.UserID)
  189. }
  190. //如果存在该手机号/邮箱,那么需要校验
  191. if userRecord.UserID > 0 && userRecord.UserID != userId {
  192. err = errors.New(fmt.Sprint("用户已绑定其他账户,已绑定的用户编号:", userRecord.UserID, ",不允许重复绑定"))
  193. return
  194. }
  195. if userRecord.UserID == 0 {
  196. userRecord.BindAccount = bindAccount
  197. userRecord.UserID = userId
  198. var updateCols = []string{"UserID", "BindAccount"}
  199. tmpErr := userRecord.Update(updateCols)
  200. if tmpErr != nil {
  201. err = tmpErr
  202. return
  203. }
  204. }
  205. //如果当前该第三方用户信息的昵称为空串的话,那么需要去查询该用户的第一个绑定信息的数据作为来源做数据修复
  206. if userRecord.NickName == "" {
  207. oldUserRecord, err := user_record.GetUserThirdRecordByUserId(userId)
  208. if err == nil && oldUserRecord != nil {
  209. //如果该用户绑定的第一条数据的头像信息不为空串,那么就去做新数据的修复
  210. if oldUserRecord.NickName != "" {
  211. _ = userRecord.ModifyUserRecordInfo(oldUserRecord.NickName, oldUserRecord.Headimgurl, oldUserRecord.City, oldUserRecord.Province, oldUserRecord.Country, oldUserRecord.Sex)
  212. }
  213. }
  214. }
  215. //如果该用户 绑定注册状态 字段处于 未注册 的情况下,那么去修改该数据
  216. if wxUser.IsRegister == 0 {
  217. err = wxUser.ModifyWxUserRegisterStatus(1, source, time.Now())
  218. if err != nil {
  219. return
  220. }
  221. }
  222. //格式化用户数据
  223. userInfo = formatWxUserAndUserRecord(wxUser, userRecord)
  224. return
  225. }