hfysite/server/database/d_user.js

const mysql = require('./mysql');
const {searchSql,limitSql} = require("../tools/searchSql");
const {isEmpty} = require("../tools/typeTool_cjs");
const log = require("../logger").logger("d_user","info");
const dbField = require("../map/dbField");
function login(account,passwd){
  let sql,values;
  sql = `SELECT m.id,m.name,m.type,m.status,m.enableNewPasswd
           FROM hfy_manager as m
           WHERE name = ? AND password = ?
           AND enableNewPasswd = ? `;
  log.debug(`[用户登录] 登陆账号:${account} 密码:${passwd}`);
  log.debug(sql);
  values = [account,passwd,dbField.db_user.enableNewPasswd.true];
  return mysql.pq(sql,values);
}

function addAccount(account,passwd){
  let sql,values;
  sql = `INSERT INTO hfy_manage (name,passwd) VALUES (?,?)`;
  values = [account,passwd];
  return mysql.pq(sql,values);
}

function checkAccount(id){
  let sql,values;
  sql = `SELECT
            m.id,
            m.name,
            m.type,
            m.status,
          FROM hfy_manager as m
          WHERE id = ?
          limit 1`;
  values = [id];
  return mysql.pq(sql,values);
}

/**
 * 加载账号
 * @param type array|count
 * @param _params key
 * @param p page
 * @param l limit
 * @returns {*}
 */
function loadAccounts(type='array',_params,p,l){
  let sql = ``;
  let values = [];
  if(isEmpty(_params)){
    _params = {};
  }
  if(type === 'count'){
    sql = `select count(*) as total `;
  }else {
    sql = `select
    m.id,
    m.name,
    m.type,
    m.status,
    m.createTime,
    m.updateTime
    `;
  }
  sql += `
    from
    hfy_manager as m
    where 1 = 1
  `
  if(_params.key){
    sql += ` and m.name like '%${_params.key}%'`
  }
  return searchSql(mysql.pq,type,sql,values,l,p);
}

module.exports = {
  login,
  checkAccount,
  addAccount,
  loadAccounts,
}