const mysql = require('../utils/mysql_db')
|
|
module.exports = {
|
/**
|
* 密码校验
|
*/
|
async getUser(username) {
|
let sql = `SELECT a.id,a.user_name,a.tel,a.password,a.failuresTimes FROM sys_user a WHERE tel = '${username}' `
|
return await mysql.query(sql)
|
},
|
/**
|
* 失败加一次
|
*/
|
async failuresAdd(params) {
|
let sql = `update sys_user set failuresTimes = '${params.num}' WHERE id = '${params.id}' `
|
return await mysql.query(sql)
|
},
|
/**
|
* 用户信息
|
*/
|
async getInfo(params) {
|
let sql = `SELECT a.id,a.user_name,a.tel,a.pic_url,a.address,DATE_FORMAT(a.birthday,'%Y-%m-%d') birthday,a.roles,a.email FROM sys_user a WHERE a.tel = '${params}'`
|
return await mysql.query(sql)
|
},
|
async ifPhoneExist(param) {
|
let sql = `SELECT * FROM SYS_USER WHERE TEL = '${param.phone}'`
|
return await mysql.query(sql)
|
},
|
/**
|
* 字典表
|
*/
|
async Dictionary(params) {
|
let sql = `SELECT * FROM ${params.table};`
|
return await mysql.query(sql)
|
},
|
//测试
|
async getwithoutToken() {
|
let sql = `SELECT a.id,a.user_name,a.tel,a.pic_url,a.address,DATE_FORMAT(a.birthday,'%Y-%m-%d') birthday,a.roles FROM sys_user a WHERE a.tel = '18918594757'`
|
return await mysql.query(sql)
|
}
|
}
|
