data:
exports.findAll = function *(query) {
let where = {};
if (query.sodHStoreId && query.sodHStoreId != '') where.sodHStoreId = query.sodHStoreId
let page = yield db.sequelize.Sod.findAndCountAll({
attributes: {exclude: ['createdAt', 'updatedAt']},
where: where,
include: [
{model: db.sequelize.Shop, as: 'hshop', attributes: ['store_id']},
{model: db.sequelize.Sct, as: 'scts', attributes: ['sctid','sctstoreuserid','sctcontents','sctcreatetime','sctstoreuserid',],
include:{model: db.sequelize.StoreUser, as: 'storeuser', attributes: ['store_user_id','store_user_name']}}
],
order: [['sodid', 'ASC']]
})
return page;
}
http://www.360doc.com/content/13/1103/19/9200790_326363987.shtml