/**
* 本月支出
*/
input.setProductType("1");
List<Map<String, Object>> xMonOutgo = outputItemMapper.selectExpenditureMonthlyReportByType(input);
input.setProductType("3");
List<Map<String, Object>> cMonOutgo = outputItemMapper.selectExpenditureMonthlyReportByType(input);
/**
* 本月支出进行合并
*/
ArrayList<Map<String, Object>> xMonfinalList1 = new ArrayList<>();
ArrayList<Object> xMonfinalListIds1 = new ArrayList<>();
for (Map<String, Object> xMap : xMonOutgo) {
xMap.put("output_type_name", sysDictService.queryDictTextByKey("output_type", xMap.get("output_type").toString()));
xMonfinalList1.add(xMap);
xMonfinalListIds1.add(xMap.get("output_type"));
for (Map<String, Object> cMap : cMonOutgo) {
if (xMap.get("output_type").toString().equals(cMap.get("output_type").toString())) {
xMonfinalList1.remove(xMap);
//成药的数量
xMap.put("c_purchase_money", cMap.get("purchase_money"));
xMap.put("c_sell_money", cMap.get("sell_money"));
//合计
xMap.put("total_purchase_money", new BigDecimal(xMap.get("purchase_money").toString()).add(new BigDecimal(cMap.get("purchase_money").toString())));
xMap.put("total_sell_money", new BigDecimal(xMap.get("sell_money").toString()).add(new BigDecimal(cMap.get("sell_money").toString())));
xMonfinalList1.add(xMap);
}
}
}
for (Map<String, Object> cMap : cMonOutgo) {
if (!xMonfinalListIds1.contains(cMap.get("output_type"))) {
cMap.put("output_type_name", sysDictService.queryDictTextByKey("output_type", cMap.get("output_type").toString()));
cMap.put("c_purchase_money", cMap.get("purchase_money"));
cMap.put("c_sell_money", cMap.get("sell_money"));
cMap.put("purchase_money", 0);
cMap.put("sell_money", 0);
cMap.put("total_purchase_money", cMap.get("purchase_money"));
cMap.put("total_sell_money", cMap.get("sell_money"));
xMonfinalList1.add(cMap);
}
}
Map<String, Object> goSumMap = new HashMap<>();
goSumMap.put("output_type_name", "小计");
goSumMap.put("purchase_money", xGoSum.get("purchase_money"));
goSumMap.put("sell_money", xGoSum.get("sell_money"));
goSumMap.put("c_purchase_money", cGoSum.get("purchase_money"));
goSumMap.put("c_sell_money", cGoSum.get("sell_money"));
goSumMap.put("total_purchase_money", goSum.get("purchase_money"));
goSumMap.put("total_sell_money", goSum.get("sell_money"));
xMonfinalList1.add(goSumMap);
Map<String, Object> map = new HashMap<>();
map.put("comeResult", MapKeyToFormatCol.formatHumpKeyList(xMonfinalList));
map.put("goResult", MapKeyToFormatCol.formatHumpKeyList(xMonfinalList1));
两个list进行合并
最新推荐文章于 2023-08-18 20:15:00 发布