87,899
社区成员
发帖
与我相关
我的任务
分享
orders.findAll({
attributes: ['id', 'code', 'status', 'createTime'],
where: {
personID: req.body.personID
},
include: [ {
as: 'address',
model: receiveAddress,
attributes: ['id', 'area', 'address']
}, {
model: orderDetail,
attributes: ['id', 'quantity'],
include: [{
model: goods,
attributes: ['id', 'desc', 'name', 'cover']
}]
}],
order: [
['createTime', 'DESC'],
],
offset: req.body.pageIndex * req.body.pageSize,
limit: req.body.pageSize
})
//订单表的外键
receiveAddressID: {
type: Sequelize.STRING,
allowNull: false,
field: 'PerSon_Address_ID'
}
//关系定义
orders.belongsTo(receiveAddress, {
as: 'address',
foreignKey: 'receiveAddressID',
through: null
});