package com.ld.igds.inout.view;
|
|
import java.util.*;
|
|
import com.ld.igds.inout.InoutConstant;
|
import com.ld.igds.inout.dto.ReportInoutDepotData;
|
import com.ld.igds.inout.dto.ReportInoutShipData;
|
import org.apache.commons.lang3.StringUtils;
|
import org.apache.commons.lang3.time.DateFormatUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
import com.bstek.bdf2.core.model.DefaultDept;
|
import com.bstek.dorado.annotation.DataProvider;
|
import com.ld.igds.inout.service.HInoutReportService;
|
import com.ld.igds.inout.service.JInoutReportService;
|
import com.ld.igds.models.InoutRecord;
|
import com.ld.igds.sys.service.SysDeptService;
|
import com.ld.igds.util.ContextUtil;
|
import com.ld.igds.util.DateUtil;
|
|
/**
|
* @author: andy.jia
|
* @description:
|
* @version:
|
* @data:2020年3月13日
|
*/
|
@Component
|
public class InoutReportPR {
|
|
@Autowired
|
private HInoutReportService hiberReportService;
|
@Autowired
|
private JInoutReportService jdbcReportService;
|
@Autowired
|
private SysDeptService sysDeptService;
|
|
/**
|
* inoutReportPR#getQuery 根据报表类型，获取默认查询信息，比如表头信息等
|
*
|
* @param
|
* @return
|
*/
|
@DataProvider
|
public Map<String, Object> getQuery(Map<String, Object> param) {
|
Map<String, Object> result = new HashMap<String, Object>();
|
//获取参数中报表类型
|
String type = (String) param.get("type");
|
//获取参数中分库编码
|
String deptId = (String) param.get("deptId");
|
//获取分库编码对应的分库名称
|
String deptName = "";
|
List<DefaultDept> defaultDepts = sysDeptService.getCacheDept(ContextUtil.getCompanyId());
|
for (DefaultDept defaultDept : defaultDepts) {
|
if (defaultDept.getId().equals(deptId)) {
|
deptName = defaultDept.getName();
|
}
|
}
|
if ("INOUT_DETAIL".equals(type)) {
|
result.put("title", "出入库明细汇总");
|
if (StringUtils.isNotEmpty(deptName)) {
|
result.put("title", deptName + "出入库明细汇总");
|
result.put("deptId", deptId);
|
}
|
|
result.put("unit", "千克（KG）");
|
result.put("end", new Date());
|
Date start = DateUtil.getNewByDay(new Date(), -30);
|
result.put("start", start);
|
|
result.put("timeDesc",
|
DateFormatUtils.format(start, "yyyy-MM-dd") + " 截至："
|
+ DateFormatUtils.format(new Date(), "yyyy-MM-dd"));
|
}
|
|
/**
|
* 每日出库统计
|
*/
|
if ("OUT_DAY".equals(type)) {
|
result.put("title", "每日出库汇总");
|
if (StringUtils.isNotEmpty(deptName)) {
|
result.put("title", deptName + "每日出库汇总");
|
result.put("deptId", deptId);
|
}
|
|
result.put("unit", "千克（KG）");
|
result.put("day", new Date());
|
result.put("timeDesc",
|
DateFormatUtils.format(new Date(), "yyyy-MM-dd"));
|
result.put("type", InoutConstant.TYPE_OUT);
|
}
|
|
/**
|
* 每日入库汇总统计
|
*/
|
if ("IN_DAY".equals(type)) {
|
result.put("title", "每日入库汇总");
|
if (StringUtils.isNotEmpty(deptName)) {
|
result.put("title", deptName + "每日入库汇总");
|
result.put("deptId", deptId);
|
}
|
|
result.put("unit", "千克（KG）");
|
result.put("day", new Date());
|
result.put("timeDesc",
|
DateFormatUtils.format(new Date(), "yyyy-MM-dd"));
|
result.put("type", InoutConstant.TYPE_IN);
|
}
|
/**
|
* 分仓收支存
|
*/
|
if ("INOUTDEPOT".equals(type)) {
|
result.put("title", "分仓粮油收支存");
|
if (StringUtils.isNotEmpty(deptName)) {
|
result.put("title", deptName + "分仓粮油收支存");
|
result.put("deptId", deptId);
|
}
|
result.put("end", new Date());
|
Date start = DateUtil.getNewByDay(new Date(), -30);
|
result.put("start", start);
|
|
result.put("timeDesc",
|
DateFormatUtils.format(start, "yyyy-MM-dd") + " 截至："
|
+ DateFormatUtils.format(new Date(), "yyyy-MM-dd"));
|
result.put("unit", "千克（KG）");
|
}
|
/**
|
* 分品种收支存
|
*/
|
if ("INOUTFOODVARIETY".equals(type)) {
|
result.put("title", "分品种粮油收支存");
|
if (StringUtils.isNotEmpty(deptName)) {
|
result.put("title", deptName + "分品种粮油收支存");
|
result.put("deptId", deptId);
|
}
|
result.put("end", new Date());
|
Date start = DateUtil.getNewByDay(new Date(), -30);
|
result.put("start", start);
|
|
result.put("timeDesc",
|
DateFormatUtils.format(start, "yyyy-MM-dd") + " 截至："
|
+ DateFormatUtils.format(new Date(), "yyyy-MM-dd"));
|
result.put("unit", "千克（KG）");
|
}
|
if ("INOUT_SHIP_DETAIL".equals(type)) {
|
result.put("title", "船运明细汇总");
|
if (StringUtils.isNotEmpty(deptName)) {
|
result.put("title", deptName + "船运明细汇总");
|
result.put("deptId", deptId);
|
}
|
|
result.put("unit", "千克（KG）");
|
result.put("end", new Date());
|
Date start = DateUtil.getNewByDay(new Date(), -30);
|
result.put("start", start);
|
|
result.put("timeDesc",
|
DateFormatUtils.format(start, "yyyy-MM-dd") + " 截至："
|
+ DateFormatUtils.format(new Date(), "yyyy-MM-dd"));
|
}
|
return result;
|
}
|
|
/**
|
* 出入库汇总表
|
* inoutReportPR#listRecord 报表数据，只获取已经完成的，并且非异常数据和删除数据
|
*
|
* @param param
|
* @return
|
*/
|
@DataProvider
|
public List<InoutRecord> listRecord(Map<String, Object> param)
|
throws Exception {
|
|
if (null == param) {
|
param = new HashMap<String, Object>();
|
param.put("progress", InoutConstant.PROGRESS_RECORD);
|
}
|
|
List<InoutRecord> result = hiberReportService.listRecord(param);
|
if (null == result || result.isEmpty())
|
return result;
|
|
// 添加统计信息
|
double emptyWeightSum = 0.0, fullWeightSum = 0.0, deCheck = 0.0, addCheck = 0.0, deWetSum = 0.0, deImpuritySum = 0.0, deHandleSum = 0.0, deOtherSum = 0.0, deSumSum = 0.0, netWeightSum = 0.0, settleWeightSum = 0.0;
|
int index = 1;
|
for (InoutRecord record : result) {
|
record.setRemarks(String.valueOf(index));
|
emptyWeightSum += record.getEmptyWeight();
|
fullWeightSum += record.getFullWeight();
|
deCheck += record.getDeCheck();
|
addCheck += record.getAddCheck();
|
// deWetSum += record.getDeWet();
|
// deImpuritySum += record.getDeImpurity();
|
deHandleSum += record.getDeHandle();
|
deOtherSum += record.getDeOther();
|
// deSumSum += record.getDeSum();
|
netWeightSum += record.getNetWeight();
|
settleWeightSum += record.getSettleWeight();
|
index++;
|
}
|
InoutRecord sum = new InoutRecord();
|
sum.setId("合计");
|
sum.setEmptyWeight(emptyWeightSum);
|
sum.setFullWeight(fullWeightSum);
|
sum.setAddCheck(addCheck);
|
sum.setDeCheck(deCheck);
|
// sum.setDeWet(deWetSum);
|
// sum.setDeImpurity(deImpuritySum);
|
sum.setDeHandle(deHandleSum);
|
sum.setDeOther(deOtherSum);
|
// sum.setDeSum(deSumSum);
|
sum.setNetWeight(netWeightSum);
|
sum.setSettleWeight(settleWeightSum);
|
result.add(sum);
|
|
return result;
|
}
|
|
/**
|
* inoutReportPR#inoutDepotData 分仓粮油收支存
|
*
|
* @param param
|
* @return
|
*/
|
@DataProvider
|
public List<ReportInoutDepotData> inoutDepotData(Map<String, Object> param) throws Exception {
|
List<ReportInoutDepotData> result = jdbcReportService.getInoutDepotData(param);
|
return result;
|
}
|
|
/**
|
* inoutReportPR#inoutFoodVarietyData 分品种粮油收支存
|
*
|
* @param param
|
* @return
|
*/
|
@DataProvider
|
public List<ReportInoutDepotData> inoutFoodVarietyData(Map<String, Object> param)
|
throws Exception {
|
List<ReportInoutDepotData> result = jdbcReportService.getFoodVarietyData(param);
|
return result;
|
}
|
|
/**
|
* 船运明细汇总
|
* inoutReportPR#listShipDetail
|
*
|
* @param param
|
* @return
|
*/
|
@DataProvider
|
public List<ReportInoutShipData> listShipDetail(Map<String, Object> param) throws Exception {
|
|
if (null == param) {
|
param = new HashMap<String, Object>();
|
}
|
|
return jdbcReportService.listShipDetail(param);
|
}
|
}
|
