
前端代码: oriderList 和 orderId 是通过购物车页面 去结算通过query传进来的,传进来的数据 放在兄弟组件中,否则不会实时刷新
async submitOrder() {
let res = await http.$axios({
url: "/api/updateOrderStatus",
method: "POST",
headers: {
token: true,
},
data: {
oriderList: this.select,
orderId: this.order_code[0].order_id,
},
});
console.log(res);
},
购物车页面 去结算传参

接收query参数

后端
router.post('/api/updateOrderStatus', function (req, res, next) {
let params = {
orderId: req.body.orderId,
oriderList: req.body.oriderList
}
console.log(params, "paramsparamsparamsparams");
let tokens = req.headers.token;
let tokenObj = jwt.decode(tokens)
if (tokenObj == null) {
res.send({
data: {
code: 400,
success: false,
msg: '请先登录'
}
})
} else {
connection.query(`select * from user where tel ="${tokenObj.tel}"`, function (e, r) {
if (r.length > 0) {
let uid = r[0].id
console.log(uid);
console.log(`select * from order_pay where order_id = ${params.orderId}`);
connection.query(`update order_pay set order_status = "2" where order_id = ${params.orderId}`, function (e, r) {
connection.query(`delete from cartlist where id in (${params.oriderList}) and uid = ${uid}`, function (e, r) {
res.send({
data: {
success: true,
data: r
}
})
})
})
}
})
}
})