const mysql = require('mysql')
module.exports = {
    // 數(shù)據(jù)庫配置
    config: {
        host: 'localhost', // 連接地址
        port: '3306', //端口號(hào)
        user: 'root',  //用戶名
        password: 'wei630229', //密碼
        database: 'exapp2', //數(shù)據(jù)庫名
    },
// 連接數(shù)據(jù)庫，使用mysql的連接池連接方式
// 連接池對(duì)象
sqlConnect: function (sql, sqlArr, callBack) {
        var pool = mysql.createPool(this.config)
        pool.getConnection((err, conn) => {
            console.log('12345')
            if (err) {
                console.log('連接失敗');
                return;
            }
            // 事件驅(qū)動(dòng)回調(diào)
            conn.query(sql, sqlArr, callBack);
            //釋放連接
            conn.release();
        })
    }
}

var dbCongif = require("../utils/dbconfig");
// 隨機(jī)驗(yàn)證碼
function rand(min, max) {
  return Math.floor(Math.random() * (max - min)) + min;
}
// 聲明驗(yàn)證碼和手機(jī)號(hào)數(shù)組
ValidatePhoneCode = [];
// 判斷該手機(jī)是否一定接收過該驗(yàn)證碼
let sendCodeP = (phone) => {
  for (var item of ValidatePhoneCode) {
    console.log("item", item);
    if (phone == item.phone) {
      return true;
    }
  }
  return false;
};
//
let findCodeAndPhone = (phone, code) => {
  for (var item of ValidatePhoneCode) {
    if (phone == item.phone && code == item.code) {
      return "login";
    }
  }
  return "error";
};
// 驗(yàn)證碼發(fā)送接口
sendCode = (req, res) => {
  // 判斷該手機(jī)號(hào)是否一定接收過驗(yàn)證碼
  let phone = req.query.phone;
  if (sendCodeP(phone)) {
    res.send({
      code: 400,
      msg: "已經(jīng)發(fā)送過驗(yàn)證碼，稍后再發(fā)",
    });
  }
  let codeMge = rand(1000, 9999);
  ValidatePhoneCode.push({
    phone: phone,
    code: codeMge,
  });
  res.send({
    code: 200,
    msg: "發(fā)送成功",
  });
  console.log("code", codeMge);
};
// 驗(yàn)證碼登錄
codePhoneLogin = (req, res) => {
  let { phone, code } = req.query;
  // 判斷手機(jī)號(hào)是否發(fā)送過驗(yàn)證碼
  if (sendCodeP(phone)) {
    // 驗(yàn)證碼和手機(jī)號(hào)是否匹配
    let state = findCodeAndPhone(phone, code);
    if (state == "login") {
      // 登錄成功
      res.send({
        code: "200",
        mgs: "登錄成功",
      });
    } else if (state == "error") {
      res.send({
        code: "500",
        mgs: "登錄失敗",
      });
    }
  } else {
    res.send({
      code: "400",
      mgs: "未發(fā)送驗(yàn)證碼",
    });
  }
};
module.exports = {
  sendCode, // 驗(yàn)證碼接口
  codePhoneLogin, //  登錄接口
};