wss-pool/internal/data/mysqlbusiness/updateinfo.go

package mysqlbusiness

import (
	"go.uber.org/zap"
	"strconv"
	"wss-pool/internal/data"
	"wss-pool/logging/applogger"
	"wss-pool/pkg/model/sqlmodel"
)

// UpdateBoUserSms
func UpdateBoUserSms(userSms sqlmodel.BoUserSms) error {
	_, err := data.Engine.Table("bo_user_sms").
		Where("`from` = ?", userSms.From).
		Where("`to` = ?", userSms.To).
		Where("task_id = ?", userSms.TaskId).
		Where("message = ?", userSms.Message).
		Update(&userSms)
	if err != nil {
		applogger.Error("UpdateBoUserSms info err：%v", err)
		return err
	}

	return nil
}

// UpdateBoUsersById
func UpdateBoUsersById(phoneNumber string, password string) (string, error) {
	phone, err := strconv.Atoi(phoneNumber)
	if err != nil {
		applogger.Error("Atoi err: %v", err)
		return "电话号码解析失败,请联系管理员", err
	}
	sqlStr := "UPDATE bo_users set loginPassword=? where phoneNumber=? and status=1"
	_, err = data.DB.Exec(sqlStr, password, phone)
	if err != nil {
		applogger.Error("Login User verification failed.", zap.Error(err))
		return "修改密码异常请联系管理员", err
	}

	return "密码修改成功", nil
}

// UpdateBoUsersTokenById
func UpdateBoUsersTokenById(id int64, accessToken string) error {
	sqlStr := "UPDATE bo_users set accessToken=? where id=? and status=1"
	_, err := data.DB.Exec(sqlStr, accessToken, id)
	if err != nil {
		applogger.Error("Login User verification failed.", zap.Error(err))
		return err
	}

	return nil
}

// UpdateBoUsersById
func UpdateBoUsersPassWordByPhoneNumber(phoneNumber string, password string) (string, error) {
	phone, err := strconv.Atoi(phoneNumber)
	if err != nil {
		applogger.Error("Atoi err: %v", err)
		return "电话号码解析失败,请联系管理员", err
	}
	//sqlStr := "UPDATE bo_users set loginPassword=? where phoneNumber=? and status=1"
	//_, err = data.DB.Exec(sqlStr, password, phone)
	//if err != nil {
	//	applogger.Error("Login User verification failed.", zap.Error(err))
	//	return "修改密码异常请联系管理员", err
	//}
	bom := sqlmodel.BoUsers{
		Loginpassword: password,
	}
	checkInt, err := data.Engine.Table("bo_users").
		Where("phoneNumber=?", phone).
		Where("status=1").
		Update(&bom)
	if err != nil {
		applogger.Error("UpdateBoUsersPassWordByPhoneNumber info err: %v", err)
		return "修改密码异常请联系管理员", err
	}
	if checkInt == 0 {
		return "修改密码失败", nil
	}

	return "修改密码成功", nil
}

// UpdateBoUsersById
func UpdateBoUsersPhoneNumberById(phoneNumber string, id int64) (string, error) {
	phone, err := strconv.Atoi(phoneNumber)
	if err != nil {
		applogger.Error("Atoi err: %v", err)
		return "电话号码解析失败,请联系管理员", err
	}
	sqlStr := "UPDATE bo_users set phoneNumber=? where id=? and status=1"
	_, err = data.DB.Exec(sqlStr, phone, id)
	if err != nil {
		applogger.Error("Login User verification failed.", zap.Error(err))
		return "设置手机号异常请联系管理员", err
	}

	return "设置手机号成功", err
}