const intoQuery = await dbJQL.collection('book').groupBy('author,title').groupField('sum(数量) as 入总数').get()
const outQuery = await dbJQL.collection('book2').groupBy('author,title').groupField('sum(数量) as 出总数').get()
let shuju = intoQuery.data.map((v) => {
let obj = outQuery.data.find(o => o.author === v.author && o.title === v.title)
let czs = typeof(obj) == 'object' ? obj.出总数 : 0
let kcs = {
出总数: czs,
库存: v.入总数 - czs
}
return {
...v,
...obj,
...kcs
}
})
3***@qq.com
- 发布:2022-10-31 09:44
- 更新:2022-10-31 09:44
- 阅读:132