| | |
| | | List<Map<String, Object>> combList = jdbcTemplate.queryForList("select top 10 * from man_comb where 1=1 order by create_time desc"); |
| | | for (int i=0;i<combList.size();i++) { |
| | | Object create_time = combList.get(i).get("create_time"); |
| | | combList.get(i).put("time", String.valueOf(create_time).substring(11, 16)); |
| | | combList.get(i).put("time", String.valueOf(create_time).substring(5, 16)); |
| | | combList.get(i).put("active", i<3?"active":""); |
| | | } |
| | | // 拣货单 |
| | |
| | | "left join \n" + |
| | | "(select SUM(anfme) as anfme, node_id from man_loc_detl where 1=1 group by node_id) mld on mp.node_id = mld.node_id\n" + |
| | | "where 1=1 \n" + |
| | | "and mp.safe_qua > mld.anfme\n" + |
| | | "order by (mp.safe_qua - mld.anfme) desc"); |
| | | for (int i=0;i<safeQuaList.size();i++) { |
| | | safeQuaList.get(i).put("no", i+1); |