fix(home): 统一原料名称为"原料"
- 将产品进出库分析中的"原材料"改为"原料"
- 更新销售台账产品查询中对应的原料名称匹配条件
| | |
| | | public List<Map<String, Object>> productInOutAnalysis(Integer type) { |
| | | String targetName; |
| | | if (type == 1) { |
| | | targetName = "原材料"; |
| | | targetName = "原料"; |
| | | } else if (type == 2) { |
| | | targetName = "成品"; |
| | | } else if (type == 3) { |
| | |
| | | JOIN product pr ON slp.product_id = pr.id |
| | | WHERE |
| | | slp.type = 2 |
| | | AND pr.parent_id = ( SELECT id FROM product WHERE product_name = '原材料' ) |
| | | AND pr.parent_id = ( SELECT id FROM product WHERE product_name = '原料' ) |
| | | GROUP BY |
| | | pr.id, |
| | | pr.product_name |