const mysql = require('../utils/mysql_db')
|
const dbhandle = require('../utils/handle_db')
|
const uuid = require('node-uuid')
|
|
module.exports = {
|
/**
|
* 更新验证码
|
*/
|
async updateVerification(params) {
|
let sql = `UPDATE SYS_USER SET verification_code = '${params.code}' WHERE tel = '${params.phone}'`
|
return await mysql.query(sql)
|
},
|
|
/**
|
* 验证码登录
|
*/
|
async getUser(params) {
|
let sql = `SELECT * FROM SYS_USER WHERE TEL = '${params.phone}' AND verification_code = '${params.code}'`
|
return await mysql.query(sql)
|
}
|
}
|
