前端毕业设计：Nodejs+Vue菜鸟驿站仓库管理系统的设计与实现

let { name, password, password2, phone, username } = ctx.request.body;
let adminUserList = await query('select * from admin_user');
let time = dayjs().format('YYYY-MM-DD HH:mm:ss')
if (adminUserList.some(item => item.username === username)) {
   ctx.body = {
code: -1,
data: null,
message:  '该用户已经注册'
};
 } else {
  try {
    let str = `INSERT INTO admin_user(username, password, name, phone, time) VALUES('${username}', '${password}', '${name}', '${phone}', '${time}')`;
    console.log(str);
    await query(str);
    ctx.response.redirect('/login');
 } catch(err) {
    console.log(err);
   ctx.response.redirect('/register');
 }
}

let adminUserList = await query(`
SELECT id, username, name, phone
FROM admin_use
WHERE username='${username}' && password='${password}'
`);
 if (adminUserList.length > 0) {
   let token = jwt.sign({ ...adminUserList[0] }, secret);
   ctx.body = {
    code: 1,
      data: {
        token,
            username: username
      },
 message: '登录成功'
}

router.post('/instock', async function (ctx, next) {
    let { token } = ctx.request.header;
    let { name, phone, goodsName } = ctx.request.body;
    try {
      let userInfo = jwt.verify(token, secret);
      let time = dayjs().format('YYYY-MM-DD HH:mm:ss');
      console.log(name, phone, goodsName, userInfo);
      // 1. 先用手机号查customer表，是否有此用户
      let customerList = await query(`select id, phone from customer`);
      let curCustomer = customerList.find(item => item.phone == phone);
      let customerId;
      if (!curCustomer) {
        // 先加一下这个用户
        customerId = customerList.length + 1;
        await query(`insert into customer(id, name, phone, time) values(${customerId}, '${name}', '${phone}', '${time}')`);
      } else {
        customerId = curCustomer.id;
      }

// 2. 找一个空的货架单元
      // 把所有库存的仓库都找出来
      let storehouseGoodsList = await query(`select storehouse_id from storehouse_goods where is_out<>1`);
      let storehouseList = await query(`select id from storehouse`);
      let emptyStoreId = '';
      if (storehouseGoodsList.length > 0) {
        let emptyStoreList = storehouseList.filter(item => !storehouseGoodsList.some(it => it.storehouse_id === item.id))
        if (emptyStoreList.length === 0) throw new Error('没有空余的货架，请出库以腾出空位！');
        emptyStoreId = emptyStoreList[0].id;
      } else {
        emptyStoreId = storehouseList[0].id;
      }
      // 写入出库
      let goodsList = await query(`select id from goods`);
      let goodsId = goodsList.length + 1;
      await query(`insert into goods(id, name, customer_id, admin_id) values(${goodsId}, '${goodsName}', ${customerId}, ${userInfo.id})`);
      await query(`insert into storehouse_goods(goods_id, storehouse_id, is_out, instock_time) values(${goodsId}, ${emptyStoreId}, 0 ,'${time}');`);
      ctx.body = {
        code: 1,
        data: null,
        message: '商品入库成功！'
      }
    } catch(err) {
      console.log(err);
      ctx.response.redirect('/login');
    }
  });

router.post('/outstock', async function (ctx, next) {
    let { token } = ctx.request.header;
    let { val } = ctx.request.body;
    try {
      let userInfo = jwt.verify(token, secret);
      let sgList = await query(`select id, goods_id, is_out from storehouse_goods where id=${val}`);
      if (sgList.length === 0) throw new Error('库存id无效');
      if (sgList[0].is_out === 1) throw new Error('该商品已经出库');
      let time = dayjs().format('YYYY-MM-DD HH:mm:ss');
      await query(`UPDATE storehouse_goods SET is_out=1, outstock_time='${time}' where id=${val}`);
      ctx.body = {
        code: 1,
        data: null,
        message: '出库成功'
      }
    } catch(err) {
      ctx.body = {
        code: -1,
        data: null,
        message: err.message
      }
    }
  });

router.get('/queryorder', async function (ctx, next) {
    let { token } = ctx.request.header;
    let { value } = ctx.request.query;
    try {
      let userInfo = jwt.verify(token, secret);
      let reg_tel = /^(13[0-9]|14[01456879]|15[0-35-9]|16[2567]|17[0-8]|18[0-9]|19[0-35-9])\d{8}$/;
      let arr = [];
      // , G.is_out, G.instock_time, G.outstock_time
      // 如果是手机号
      if (reg_tel.test(value)) {
        let customerList = await query(`SELECT id FROM customer WHERE phone='${value}'`);
        if (customerList.length === 0) throw new Error('没有这个手机号的记录');
        // 找到这个商品
        let goodsList = await query(`SELECT G.id, G.name AS 'good_name', A.name AS 'admin_name', C.name AS 'customer_name' FROM goods G, admin_user A, customer C WHERE G.customer_id=${customerList[0].id} AND C.id=${customerList[0].id} AND A.id=G.admin_id`);
        if (goodsList.length > 0) {
          for (let i=0; i<goodsList.length; i++) {
            let _item = { ...goodsList[i] };
            let sgList = await query(`SELECT * FROM storehouse_goods WHERE goods_id=${_item.id}`);
            if (sgList.length === 0) throw new Error('没有找到此库存');
            let storeList = await query(`SELECT * FROM storehouse WHERE id=${sgList[0].storehouse_id}`);
            if (storeList.length === 0) throw new Error('没有找到此仓库');
            // 找这个仓库
            _item.store_id = storeList[0].id;
            _item.store_code = storeList[0].name;
            _item.sg_id = sgList[0].id;
            _item.is_out = sgList[0].is_out;
            _item.instock_time = sgList[0].instock_time;
            _item.outstock_time = sgList[0].outstock_time;
            arr.push(_item);
          }
        }
        console.log(goodsList);
      } else {
        // 使用取件码查询
        // 1. 查询库存表是否有这个仓库
        let storeList = await query(`SELECT id, name FROM storehouse WHERE name='${value}'`);
        if (storeList.length === 0) throw new Error(`${value}这个取件码无效`);
        // 2. 找到这个库存
        let sgList = await query(`SELECT * FROM storehouse_goods WHERE storehouse_id=${storeList[0].id}`);
        if (sgList.length === 0) throw new Error(`没有找到这个库存`);
        // 3. 找到这个商品
        let goodsList = await query(`SELECT G.id, G.name AS 'good_name', A.name AS 'admin_name', C.name AS 'customer_name' FROM goods G, admin_user A, customer C WHERE G.id=${sgList[0].id} AND C.id=G.customer_id AND A.id=G.admin_id`);
        if (goodsList.length > 0) {
          arr.push(goodsList[0]);
          arr[0].store_id = storeList[0].id;
          arr[0].store_code = storeList[0].name;
          arr[0].sg_id = sgList[0].id;
          arr[0].is_out = sgList[0].is_out;
          arr[0].instock_time = sgList[0].instock_time;
          arr[0].outstock_time = sgList[0].outstock_time;
        }
      }
      ctx.body = {
        code: arr.length > 0? 1: -1,
        data: arr,
        message: arr.length > 0? 'query ok': '没有找到指定的库存'
      }
    } catch(err) {
      ctx.body = {
        code: -1,
        data: null,
        message: err.message
      }
    }
  })

let arr = [];
      let timeWhere = '';
      switch (val) {
        case '1': // 超时一周
          timeWhere = `instock_time < '${ dayjs(dayjs() - 7*24*60*60*1000).format('YYYY-MM-DD HH:mm:ss') }'`;
          break;
        case '2': // 超时3周
          timeWhere = `instock_time < '${ dayjs(dayjs() - 3*7*24*60*60*1000).format('YYYY-MM-DD HH:mm:ss') }'`;
          break;
        case '3': // 超时一个月
          timeWhere = `instock_time < '${ dayjs(dayjs() - 30*24*60*60*1000).format('YYYY-MM-DD HH:mm:ss') }'`;
          break;
        case '4': // 超时三个月
          timeWhere = `instock_time < '${ dayjs(dayjs() - 90*24*60*60*1000).format('YYYY-MM-DD HH:mm:ss') }'`;
          break;
        case '5': // 超时一年
          timeWhere = `instock_time < '${ dayjs(dayjs() - 365*24*60*60*1000).format('YYYY-MM-DD HH:mm:ss') }'`;
          break;
      }
      let sgList = await query(`select * from storehouse_goods where is_out<>1 and ${timeWhere}`);
      for (let i=0; i<sgList.length; i++) {
        let item = { ...sgList[i], instock_time: dayjs(sgList[i].instock_time).format('YYYY-MM-DD HH:mm:ss') };
        let storeList = await query(`select id, name from storehouse where id=${item.storehouse_id}`);
        let goodsList = await query(`select G.id, G.name AS 'good_name', A.name AS 'admin_name', C.name AS 'customer_name' from goods G, admin_user A, customer C where G.id=${item.goods_id} AND C.id=G.customer_id AND A.id=G.admin_id`);
        if (goodsList.length > 0) {
          item.store_id = storeList[0].id;
          item.store_code = storeList[0].name;
          item.admin_name = goodsList[0].admin_name;
          item.customer_name = goodsList[0].customer_name;
          item.good_name = goodsList[0].good_name;
        }
        arr.push(item);
      }