cesium_three_nodejs/router_handler/user/userInfo.js

const db = require('../../db/index.js');

const bcrypt = require("bcryptjs");

const jwt = require("jsonwebtoken");

const config = require('../../config.js')

//查询用户信息
exports.userInfoList = (req, res) => { 

    const sql = "select id,username,nickname,email,user_pic from ev_users where id=?"

    db.query(sql, req.user.id, (err, results) => {
        if (err) {
            return res.rescc(err);
        }

        if (results.length !== 1) { 
            return res.rescc("获取用户信息失败！");
        }

        res.rescc("获取用户信息成功", 200, results);

     })
}

//修改用户信息
exports.updataUserInfo = (req, res) => { 

    const sql = "update ev_users set ? where id=?"

    db.query(sql, [req.body, req.body.id], (err, results) => { 
        if (err) { 
            return res.rescc(err);
        }
        if (results.affectedRows !== 1) { 
            return res.rescc("用户信息更新失败！");
        }
        res.rescc("用户信息更新成功！", 200)
    })
}

//修改用户密码
exports.updataUserpwd = (req, res) => { 

    const sql1 = "select * from ev_users where id=?"
    db.query(sql1, req.user.id, (err, results) => { 
        if (err) {
            return res.rescc(err);
        }
        if (results.length !== 1) {
            return res.rescc("用户不存在！");
        }

        const compareResult = bcrypt.compareSync(req.body.oldPwd, results[0].password);
        if (!compareResult) { 
            return res.rescc("原密码错误！");
        }

        const sql = "update ev_users set password=? where id=?"

        const newPwd = bcrypt.hashSync(req.body.newPwd, 10);
        console.log(req.user.id)

        db.query(sql, [newPwd, req.user.id], (err, results) => {
            if (err) {
                return res.rescc(err);
            }
            if (results.affectedRows !== 1) {
                return res.rescc("用户更新密码失败！");
            }
            res.rescc("用户更新密码成功！", 200)
        })
    })
}

exports.updataUserAvatar = (req, res) => { 
    const sql = "update ev_users set user_pic=? where id=?"

    db.query(sql, [req.body.avatar, req.body.id], (err, results) => { 
        if (err) { 
            return res.rescc(err);
        }
        if (results.affectedRows !== 1) { 
            return res.rescc("用户头像更新失败！");
        }
        res.rescc("用户头像更新成功！", 200)
    })
}