user.go 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381
  1. package services
  2. import (
  3. "errors"
  4. "fmt"
  5. "hongze/hongze_cygx/models"
  6. "hongze/hongze_cygx/utils"
  7. "strconv"
  8. "time"
  9. )
  10. var ERR_NO_USER_RECORD = errors.New("用户关系没有入库")
  11. var ERR_USER_NOT_BIND = errors.New("用户没有绑定")
  12. //通过openid获取用户信息
  13. func GetWxUserItemByOpenId(openid string) (item *models.WxUserItem, err error) {
  14. //通过openid获取用户关联信息
  15. userRecord, userRecordErr := models.GetUserRecordByOpenId(openid)
  16. fmt.Println("userRecordErr", userRecordErr)
  17. if userRecordErr != nil {
  18. if userRecordErr.Error() == utils.ErrNoRow() {
  19. err = ERR_NO_USER_RECORD
  20. return
  21. } else {
  22. err = userRecordErr
  23. return
  24. }
  25. }
  26. //该openid在系统中没有关联关系
  27. if userRecord == nil {
  28. err = ERR_NO_USER_RECORD
  29. return
  30. }
  31. //该openid没有绑定用户
  32. if userRecord.UserId <= 0 {
  33. err = ERR_USER_NOT_BIND
  34. item = new(models.WxUserItem)
  35. //格式化返回用户数据
  36. formatWxUserAndUserRecord(item, userRecord)
  37. return
  38. }
  39. //获取用户信息
  40. item, wxUserErr := models.GetWxUserItemByUserId(userRecord.UserId)
  41. fmt.Println("wxUserErr", wxUserErr)
  42. if wxUserErr != nil {
  43. err = wxUserErr
  44. return
  45. }
  46. if item.RealName == "" {
  47. item.RealName = userRecord.RealName
  48. }
  49. //格式化返回用户数据
  50. formatWxUserAndUserRecord(item, userRecord)
  51. return
  52. }
  53. //根据用户id和平台id获取用户信息
  54. func GetWxUserItemByUserId(userId, platform int) (wxUserItem *models.WxUserItem, err error) {
  55. //获取用户信息
  56. wxUserItem, wxUserErr := models.GetWxUserItemByUserId(userId)
  57. if wxUserErr != nil {
  58. err = wxUserErr
  59. return
  60. }
  61. //格式化返回用户数据
  62. formatWxUser(wxUserItem, platform)
  63. return
  64. }
  65. //根据用户邮箱和平台id获取用户信息
  66. func GetWxUserItemByEmail(email string, platform int) (wxUserItem *models.WxUserItem, err error) {
  67. //获取用户信息
  68. wxUserItem, wxUserErr := models.GetWxUserItemByEmail(email)
  69. if wxUserErr != nil {
  70. err = wxUserErr
  71. return
  72. }
  73. //格式化返回用户数据
  74. formatWxUser(wxUserItem, platform)
  75. return
  76. }
  77. //根据用户手机号和平台id获取用户信息
  78. func GetWxUserItemByMobile(mobile string, platform int) (wxUserItem *models.WxUserItem, err error) {
  79. //获取用户信息
  80. wxUserItem, wxUserErr := models.GetWxUserItemByMobile(mobile)
  81. if wxUserErr != nil {
  82. err = wxUserErr
  83. return
  84. }
  85. //格式化返回用户数据
  86. formatWxUser(wxUserItem, platform)
  87. return
  88. }
  89. //根据用户unionid和平台id获取用户信息
  90. func GetWxUserItemByUnionId(unionId string, platform int) (wxUserItem *models.WxUserItem, err error) {
  91. //获取用户信息
  92. wxUserItem, wxUserErr := models.GetWxUserItemByUnionid(unionId)
  93. if wxUserErr != nil {
  94. err = wxUserErr
  95. return
  96. }
  97. //格式化返回用户数据
  98. formatWxUser(wxUserItem, platform)
  99. return
  100. }
  101. //通过用户 关系表记录 和 用户记录 格式化返回 用户数据
  102. func formatWxUserAndUserRecord(wxUser *models.WxUserItem, userRecord *models.UserRecord) {
  103. wxUser.OpenId = userRecord.OpenId
  104. wxUser.UnionId = userRecord.UnionId
  105. wxUser.NickName = userRecord.NickName
  106. //wxUser.RealName = userRecord.RealName
  107. //wxUser.BindAccount = userRecord.BindAccount
  108. wxUser.Headimgurl = userRecord.Headimgurl
  109. wxUser.SessionKey = userRecord.SessionKey
  110. }
  111. //通过用户 用户记录 和 来源平台 格式化返回 用户数据
  112. func formatWxUser(wxUser *models.WxUserItem, platform int) {
  113. //根据用户id和平台id获取用户关系
  114. userRecord, userRecordErr := models.GetUserRecordByUserId(wxUser.UserId, platform)
  115. if userRecordErr != nil {
  116. if userRecordErr.Error() != utils.ErrNoRow() {
  117. return
  118. }
  119. if userRecordErr.Error() == utils.ErrNoRow() {
  120. return
  121. }
  122. }
  123. //该openid在系统中没有关联关系
  124. if userRecord == nil {
  125. return
  126. }
  127. wxUser.OpenId = userRecord.OpenId
  128. wxUser.UnionId = userRecord.UnionId
  129. wxUser.NickName = userRecord.NickName
  130. //wxUser.RealName = userRecord.RealName
  131. //wxUser.BindAccount = userRecord.BindAccount
  132. wxUser.Headimgurl = userRecord.Headimgurl
  133. wxUser.SessionKey = userRecord.SessionKey
  134. return
  135. }
  136. //用户绑定
  137. func BindWxUser(openid, mobile, email string) (wxUser *models.WxUserItem, err error) {
  138. if mobile == "" && email == "" {
  139. err = errors.New("手机号或邮箱必填一个")
  140. return
  141. }
  142. var bindAccount string
  143. //根据手机号获取用户信息
  144. if mobile != "" {
  145. tmpWxUser, wxUserErr := models.GetWxUserItemByMobile(mobile)
  146. if wxUserErr != nil && wxUserErr.Error() != utils.ErrNoRow() {
  147. err = wxUserErr
  148. return
  149. }
  150. wxUser = tmpWxUser
  151. bindAccount = mobile
  152. }
  153. //根据邮箱获取用户信息
  154. if wxUser == nil && email != "" {
  155. tmpWxUser, wxUserErr := models.GetWxUserItemByEmail(email)
  156. if wxUserErr != nil && wxUserErr.Error() != utils.ErrNoRow() {
  157. err = wxUserErr
  158. return
  159. }
  160. wxUser = tmpWxUser
  161. bindAccount = email
  162. }
  163. //查询openid的第三方(微信)信息
  164. userRecord, err := models.GetUserRecordByOpenId(openid)
  165. if err != nil {
  166. return
  167. }
  168. var userId int
  169. //如果查询出来的用户是nil,那么需要新增用户
  170. if wxUser == nil {
  171. user := &models.WxUser{
  172. CompanyId: 1,
  173. CreatedTime: time.Now(),
  174. FirstLogin: 1,
  175. Enabled: 1,
  176. RegisterPlatform: 4,
  177. RegisterTime: time.Now(),
  178. Mobile: mobile,
  179. Email: email,
  180. IsRegister: 1,
  181. Source: 3,
  182. }
  183. tmpUserId, addUserErr := models.AddWxUser(user)
  184. if err != nil {
  185. err = addUserErr
  186. return
  187. }
  188. user.UserId = int(tmpUserId)
  189. userId = int(tmpUserId)
  190. wxUser, err = models.GetWxUserItemByUserId(userId)
  191. } else {
  192. userId = wxUser.UserId
  193. if wxUser.IsRegister == 0 {
  194. models.ModifyWxUserRegisterStatus(userId)
  195. }
  196. }
  197. //如果存在该手机号/邮箱,那么需要校验
  198. if userRecord.UserId > 0 && userRecord.UserId != userId {
  199. err = errors.New("用户已绑定,不允许重复绑定")
  200. return
  201. }
  202. err = models.BindUserRecordByOpenid(userId, openid, bindAccount)
  203. if err != nil {
  204. return
  205. }
  206. userRecord.UserId = userId
  207. //如果当前该第三方用户信息的昵称为空串的话,那么需要去查询该用户的第一个绑定信息的数据作为来源做数据修复
  208. if userRecord.NickName == "" {
  209. oldUserRecord, err := models.GetUserThirdRecordByUserId(userId)
  210. if err == nil && oldUserRecord != nil {
  211. //如果该用户绑定的第一条数据的头像信息不为空串,那么就去做新数据的修复
  212. if oldUserRecord.NickName != "" {
  213. _ = models.ModifyUserRecordByDetail(userRecord.OpenId, userRecord.UnionId, oldUserRecord.NickName, oldUserRecord.Headimgurl, oldUserRecord.City, oldUserRecord.Province, oldUserRecord.Country, oldUserRecord.Sex, userId)
  214. }
  215. }
  216. }
  217. //格式化用户数据
  218. formatWxUserAndUserRecord(wxUser, userRecord)
  219. return
  220. }
  221. //微信登录
  222. func WxLogin(code, openId, unionId string, wxUserInfo *WxUserInfo) (token string, userId, firstLogin, permission int, err error) {
  223. if unionId == "" {
  224. unionId = wxUserInfo.Unionid
  225. }
  226. //firstLogin==1,强制绑定手机号或者邮箱
  227. firstLogin = 1
  228. fmt.Println("GetWxUserItemByOpenId ", openId)
  229. QUERY_WX_USER:
  230. wxUser, wxUserErr := GetWxUserItemByOpenId(openId)
  231. fmt.Println("wxUserErr", wxUserErr)
  232. if wxUserErr == ERR_NO_USER_RECORD { //没有用户openid记录
  233. //先添加第三方信息(openid等信息)
  234. _, recordErr := AddUserRecord(openId, unionId, wxUserInfo.Nickname, "", wxUserInfo.Province, wxUserInfo.City, wxUserInfo.Country, wxUserInfo.Headimgurl, wxUserInfo.SessionKey, utils.WxPlatform, wxUserInfo.Sex, 0)
  235. //如果插入失败,那么直接将错误信息返回
  236. if recordErr != nil {
  237. err = recordErr
  238. return
  239. }
  240. //插入成功后,需要重新查询该用户,并进入下面的逻辑
  241. goto QUERY_WX_USER
  242. } else if wxUserErr == ERR_USER_NOT_BIND {
  243. //没有用户信息
  244. //wxUser.FirstLogin = 1
  245. } else if wxUserErr != nil {
  246. err = wxUserErr
  247. return
  248. }
  249. fmt.Println("wxUserInfo", wxUserInfo)
  250. fmt.Println("wxUserInfo.Nickname", wxUserInfo.Nickname)
  251. fmt.Println("SessionKey", wxUserInfo.SessionKey)
  252. if wxUserInfo != nil {
  253. fmt.Println("ModifyUserRecordSessionKey")
  254. err = models.ModifyUserRecordSessionKey(openId, wxUserInfo.SessionKey)
  255. fmt.Println("ModifyUserRecordSessionKey Err", err)
  256. }
  257. //如果已经登录注册绑定的情况下
  258. if wxUser != nil && wxUserErr == nil {
  259. //获取用户权限
  260. firstLogin = wxUser.FirstLogin
  261. userId = wxUser.UserId
  262. {
  263. codeLog := new(models.WxUserCode)
  264. codeLog.WxCode = code
  265. codeLog.UserId = userId
  266. codeLog.Code = 0
  267. codeLog.FirstLogin = firstLogin
  268. codeLog.Authorization = token
  269. codeLog.UserPermission = permission
  270. codeLog.CreateTime = time.Now()
  271. go models.AddWxUserCode(codeLog)
  272. }
  273. if wxUser.Mobile == "" && wxUser.Email == "" {
  274. firstLogin = 1
  275. }
  276. }
  277. //获取登录token
  278. tokenItem, tokenErr := models.GetTokenByOpenId(openId)
  279. if tokenErr != nil && tokenErr.Error() != utils.ErrNoRow() {
  280. err = errors.New("登录失败,获取token失败:" + tokenErr.Error())
  281. return
  282. }
  283. fmt.Println("line 271 ", openId)
  284. if tokenItem == nil || (tokenErr != nil && tokenErr.Error() == utils.ErrNoRow()) {
  285. timeUnix := time.Now().Unix()
  286. timeUnixStr := strconv.FormatInt(timeUnix, 10)
  287. token = utils.MD5(openId) + utils.MD5(timeUnixStr)
  288. //新增session
  289. {
  290. session := new(models.CygxSession)
  291. session.OpenId = openId
  292. session.UserId = userId
  293. session.CreatedTime = time.Now()
  294. session.LastUpdatedTime = time.Now()
  295. session.ExpireTime = time.Now().AddDate(0, 3, 0)
  296. session.AccessToken = token
  297. sessionErr := models.AddSession(session)
  298. if err != nil {
  299. err = errors.New("登录失败,新增用户session信息失败:" + sessionErr.Error())
  300. return
  301. }
  302. }
  303. } else {
  304. token = tokenItem.AccessToken
  305. }
  306. fmt.Println("line 294 ", token)
  307. //新增登录日志
  308. {
  309. loginLog := new(models.WxUserLog)
  310. loginLog.UserId = userId
  311. loginLog.OpenId = openId
  312. loginLog.UnionId = unionId
  313. loginLog.CreateTime = time.Now()
  314. loginLog.Handle = "wechat_login_cygx"
  315. loginLog.Remark = token
  316. go models.AddWxUserLog(loginLog)
  317. }
  318. return
  319. }
  320. func UserLogin() {
  321. }
  322. //添加第三方用户(微信)记录
  323. func AddUserRecord(openId, unionId, nickName, realName, province, city, country, headimgurl, sessionKey string, platform, sex, subscribe int) (userRecord *models.UserRecord, err error) {
  324. find, err := models.GetUserRecordByOpenId(openId)
  325. if err != nil && err.Error() != utils.ErrNoRow() {
  326. return
  327. }
  328. if find != nil {
  329. userRecord = find
  330. return
  331. }
  332. userRecord = &models.UserRecord{
  333. OpenId: openId, //用户open_id
  334. UnionId: unionId, //用户union_id
  335. Subscribe: subscribe,
  336. NickName: nickName, //用户昵称,最大长度:32
  337. RealName: realName, //用户实际名称,最大长度:32
  338. Sex: sex, //普通用户性别,1为男性,2为女性
  339. Province: province, //普通用户个人资料填写的省份,最大长度:30
  340. City: city, //普通用户个人资料填写的城市,最大长度:30
  341. Country: country, //国家,如中国为CN,最大长度:30
  342. Headimgurl: headimgurl, //用户第三方(微信)头像,最大长度:512
  343. CreateTime: time.Now(), //创建时间,关系添加时间、用户授权时间
  344. CreatePlatform: platform, //注册平台,1:日度点评公众号,2:管理后台,3:pc端网站,4:查研观向小程序;默认:1
  345. SessionKey: sessionKey, //微信小程序会话密钥,最大长度:255
  346. }
  347. recordId, err := models.AddUserRecord(userRecord)
  348. if err != nil {
  349. return
  350. }
  351. userRecord.UserRecordId = int(recordId)
  352. return
  353. }