| | |
| | | /** |
| | | * 钣金供应缺口报表 |
| | | */ |
| | | @RequiresPermissions("Aps:ApsPlateStandardRequire:supplyGapList") |
| | | //@RequiresPermissions("Aps:ApsPlateStandardRequire:supplyGapList") |
| | | @GetMapping("/supplyGapList") |
| | | public TableDataInfo selectPlateSupplyGapList(ApsPlateStandardRequire apsPlateStandardRequire) |
| | | { |
| | |
| | | ApsBom apsBom = jsonArray.getJSONObject(i).to(ApsBom.class); |
| | | bomLineList.add(apsBom); |
| | | } |
| | | }else { |
| | | bomLineList = selectApsBomLineList(plant, itemNumber); |
| | | } |
| | | // else { |
| | | // bomLineList = selectApsBomLineList(plant, itemNumber); |
| | | // } |
| | | |
| | | return bomLineList; |
| | | } |
| | |
| | | select id, require_track_id, bom_line_code, bom_line_level, |
| | | match_state, match_mode, unmatched_demand_amount, start_date, |
| | | complete_date, demand_date, org_code, production_base |
| | | from aps_plate_standard_require where unmatched_demand_amount>0 and del_flag='0' |
| | | from aps_plate_standard_require where unmatched_demand_amount>0 and del_flag='0' and bom_line_level>0 |
| | | <if test="requireTrackId != null and requireTrackId != ''"> and require_track_id like '%' || #{requireTrackId} || '%'</if> |
| | | <if test="bomLineCode != null and bomLineCode != ''"> and bom_line_code like '%' || #{bomLineCode} || '%'</if> |
| | | </select> |