原材料管理

1. 涉及表

表	表名	功能
ps_income_materials	来料管理表	来料入库
ps_material_out	来料出库记录	来料出库

2. 业务:材料盘点

**将ps_income_materials来料入库表与ps_material_out来料出库记录表关联查询 **

       SELECT mb.name as base_name,mm.name as model_name,sum(m.quantity) as quantity,mm.unit from
        (
        select name as material_id,base_id,quantity from ps_income_materials
        union
        select material_id,base_id,-quantity as quantity from ps_material_out
        ) m
        left join ps_material_base mb on mb.id = m.base_id
        left join ps_material_model mm on mm.id = m.material_id
        GROUP BY m.base_id,m.material_id