PurchaseAnalysisController.java
6.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
package com.skua.modules.erp.controller;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.skua.core.api.vo.Result;
import com.skua.core.aspect.annotation.AutoLog;
import com.skua.core.context.SpringContextUtils;
import com.skua.core.query.QueryGenerator;
import com.skua.core.util.ConvertUtils;
import com.skua.modules.base.service.IBaseService;
import com.skua.modules.erp.entity.MaterialIN;
import com.skua.modules.erp.vo.PurchaseAnalysisVO;
import com.skua.tool.util.DateUtils;
import com.skua.tool.util.DigitalUtils;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
import java.util.Map;
import java.util.stream.Collectors;
/**
* 采购数据分析
* @auther kangwei
* @create 2025-02-19-14:07
*/
@Slf4j
@Api(tags="erp-药剂采购分析")
@RestController("purchaseAnalysisController")
@RequestMapping("/web/erp/purchaseAnalysis")
public class PurchaseAnalysisController {
@Autowired
private IBaseService baseService;
@AutoLog(value = "erp-药剂采购分析")
@ApiOperation(value="erp--药剂采购分析", notes="erp--药剂采购分析")
@GetMapping(value = "/analysis")
public Result<PurchaseAnalysisVO> settlementList(String startDate,String endDate) {
Result<PurchaseAnalysisVO> result = new Result<PurchaseAnalysisVO>();
// int year = DateUtils.getDateYear(startDate);
// startDate = year+"-01-01";
// endDate = year+"-12-31";
String drugStorage = getJdbcTemplate().queryForObject("select round(ifnull(sum(material_num),0),2) from erp_material_in where audit_status = '3' and arrive_time >='"+startDate+"' and arrive_time <= '"+endDate+"'",String.class);
// String purchaseMoney = getJdbcTemplate().queryForObject("select round(ifnull(sum(purchase_money),0),2) from erp_purchase_contract where use_flag = 0 and status = 3 and start_time >='"+startDate+"' and end_time <= '"+endDate+"'",String.class);
// String distributMoney = getJdbcTemplate().queryForObject("select round(ifnull(sum(distribut_money),0),2) from erp_distribut_contract where start_time >='"+startDate+"' and end_time <= '"+endDate+"' ",String.class);
// String supplierMoneyByJs = getJdbcTemplate().queryForObject("select round(ifnull(sum(t.total_price_tax),0),2) from erp_settlement t where t.settlement_type = '0' and apply_time >='"+startDate+"' and apply_time<='"+endDate+"' ",String.class);
// String waterDepartMoneyByJs = getJdbcTemplate().queryForObject("select round(ifnull(sum(t.total_price_tax),0),2) from erp_settlement t where t.settlement_type = '1' and apply_time >='"+startDate+"' and apply_time<='"+endDate+"' ",String.class);
//
// PurchaseAnalysisVO purchaseAnalysisVO = new PurchaseAnalysisVO( drugStorage, purchaseMoney, distributMoney, supplierMoneyByJs, waterDepartMoneyByJs);
// 药剂入库 数量
QueryWrapper<?> queryWrapper0 = new QueryWrapper<>();
queryWrapper0
.ge("arrive_time", startDate)
.le("arrive_time", endDate)
.eq("audit_status", "3");
List<Map<String, Object>> queryMapList0 = baseService.queryForList("select * from erp_material_in", queryWrapper0);
// 分销合同金额
List<Map<String, Object>> fxQueryMapList = baseService.queryForList("select * from erp_distribut_material", new QueryWrapper<>());
Map<String, Double> fxCode2UnitPriceMap = fxQueryMapList.stream().collect(Collectors.toMap(item -> ConvertUtils.getString(item.get("good_code")), item -> ConvertUtils.getDouble(item.get("distribut_price"), 0D), (v1 ,v2) -> v1));
double distributeMoney = 0D;
for (Map<String, Object> item: queryMapList0) {
String goodCode = ConvertUtils.getString(item.get("good_code"));
distributeMoney += fxCode2UnitPriceMap.getOrDefault(goodCode, 0D) * ConvertUtils.getDouble(item.get("material_num"), 0D);
}
// 采购合同金额
List<Map<String, Object>> cgQueryMapList = baseService.queryForList("select * from erp_purchase_material", new QueryWrapper<>());
Map<String, Double> cgCode2UnitPriceMap = cgQueryMapList.stream().collect(Collectors.toMap(item -> ConvertUtils.getString(item.get("good_code")), item -> ConvertUtils.getDouble(item.get("unit_price"), 0D), (v1 ,v2) -> v1));
double purchaseMoney = 0D;
for (Map<String, Object> item: queryMapList0) {
String goodCode = ConvertUtils.getString(item.get("good_code"));
purchaseMoney += cgCode2UnitPriceMap.getOrDefault(goodCode, 0D) * ConvertUtils.getDouble(item.get("material_num"), 0D);
}
// 水务公司结算金额
QueryWrapper<?> queryWrapper2 = new QueryWrapper<>();
queryWrapper2.ge("apply_time", startDate)
.le("apply_time", endDate)
.eq("status", "1")
.eq("settlement_type", "1");
Map<String, Object> waterDepartMoneyByJsMap = baseService.queryForMap("select ifnull(sum(total_price_tax), 0) as valueSum from erp_settlement", queryWrapper2);
// 供应商结算金额
QueryWrapper<?> queryWrapper3 = new QueryWrapper<>();
queryWrapper3.ge("apply_time", startDate)
.le("apply_time", endDate)
.eq("status", "1")
.eq("settlement_type", "0");
Map<String, Object> supplierMoneyByJsMap = baseService.queryForMap("select ifnull(sum(total_price_tax), 0) as valueSum from erp_settlement", queryWrapper3);
PurchaseAnalysisVO purchaseAnalysisVO = new PurchaseAnalysisVO(drugStorage, DigitalUtils.nPoint(purchaseMoney, 2), DigitalUtils.nPoint(distributeMoney, 2), DigitalUtils.nPoint(supplierMoneyByJsMap.get("valueSum"), 2), DigitalUtils.nPoint(waterDepartMoneyByJsMap.get("valueSum"), 2));
result.setSuccess(true);
result.setResult(purchaseAnalysisVO);
return result;
}
private JdbcTemplate getJdbcTemplate(){
JdbcTemplate jdbcTemplate = (JdbcTemplate) SpringContextUtils.getBean("master");
return jdbcTemplate;
}
}