| | |
| | | */ |
| | | Page<Map<String, Object>> customPageMapList(@Param("page") Page page, @Param("paramCondition") ProductionOrdeInfoParam paramCondition); |
| | | |
| | | List lineFinishQty(); |
| | | List<ProductionOrdeInfoResult> lineFinishQty(); |
| | | |
| | | HashMap getOrderWeek(); |
| | | |
| | |
| | | <!-- SELECT production_line as name,sum(actual_qty)as value FROM om_production_orde_info GROUP BY production_line--> |
| | | <!-- </select>--> |
| | | <select id="lineFinishQty" resultType="cn.stylefeng.guns.modular.om.productionOrdeInfo.model.result.ProductionOrdeInfoResult"> |
| | | SELECT TOP 7 actual_start_time as actualStartTime,actual_qty as actualQty FROM om_production_orde_info WHERE plan_start_time is not null AND actual_qty IS NOT NULL ORDER BY actual_qty DESC |
| | | <![CDATA[ |
| | | SELECT TOP 7 actual_start_time as actualStartTime,actual_qty as actualQty FROM om_production_orde_info WHERE actual_start_time is not null AND actual_qty IS NOT NULL ORDER BY actual_start_time DESC |
| | | ]]> |
| | | </select> |
| | | |
| | | <select id="getOrderWeek" resultType="Map"> |