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)
  }
}