package com.dingzhuo.energy.project.statisticalData.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import com.dingzhuo.energy.project.statisticalData.domain.GxdhCountIndex;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import com.dingzhuo.energy.project.statisticalData.mapper.GxdhCountMapper;
|
import com.dingzhuo.energy.project.statisticalData.domain.GxdhCount;
|
import com.dingzhuo.energy.project.statisticalData.service.IGxdhCountService;
|
|
/**
|
* 工序单耗统计功能Service业务层处理
|
*
|
* @author zhaow
|
* @date 2020-12-26
|
*/
|
@Service
|
public class GxdhCountServiceImpl implements IGxdhCountService
|
{
|
@Autowired
|
private GxdhCountMapper gxdhCountMapper;
|
|
/**
|
* 查询工序单耗统计功能
|
*
|
* @param id 工序单耗统计功能ID
|
* @return 工序单耗统计功能
|
*/
|
@Override
|
public GxdhCount selectGxdhCountById(String id)
|
{
|
return gxdhCountMapper.selectGxdhCountById(id);
|
}
|
|
/**
|
* 查询工序单耗统计功能列表
|
*
|
* @param gxdhCount 工序单耗统计功能
|
* @return 工序单耗统计功能
|
*/
|
@Override
|
public List<GxdhCount> selectGxdhCountList(GxdhCount gxdhCount)
|
{
|
return gxdhCountMapper.selectGxdhCountList(gxdhCount);
|
}
|
|
/**
|
* 新增工序单耗统计功能
|
*
|
* @param gxdhCount 工序单耗统计功能
|
* @return 结果
|
*/
|
@Override
|
public int insertGxdhCount(GxdhCount gxdhCount)
|
{
|
return gxdhCountMapper.insertGxdhCount(gxdhCount);
|
}
|
|
/**
|
* 修改工序单耗统计功能
|
*
|
* @param gxdhCount 工序单耗统计功能
|
* @return 结果
|
*/
|
@Override
|
public int updateGxdhCount(GxdhCount gxdhCount)
|
{
|
return gxdhCountMapper.updateGxdhCount(gxdhCount);
|
}
|
|
/**
|
* 批量删除工序单耗统计功能
|
*
|
* @param ids 需要删除的工序单耗统计功能ID
|
* @return 结果
|
*/
|
@Override
|
public int deleteGxdhCountByIds(String[] ids)
|
{
|
return gxdhCountMapper.deleteGxdhCountByIds(ids);
|
}
|
|
/**
|
* 删除工序单耗统计功能信息
|
*
|
* @param id 工序单耗统计功能ID
|
* @return 结果
|
*/
|
@Override
|
public int deleteGxdhCountById(String id)
|
{
|
return gxdhCountMapper.deleteGxdhCountById(id);
|
}
|
|
/**
|
* 查询工序单耗统计功能报表的指标数据列表
|
*
|
* @param gxdhCountIndex 工序单耗统计功能报表的指标数据
|
* @return 工序单耗统计功能集合
|
*/
|
public List<GxdhCountIndex> selectGxdhCountIndexList(GxdhCountIndex gxdhCountIndex){
|
List<GxdhCountIndex> resList = new ArrayList<>();
|
GxdhCountIndex nyxhl = new GxdhCountIndex();
|
nyxhl.setVarietyType("能源消耗量");
|
|
GxdhCountIndex cpcl = new GxdhCountIndex();
|
cpcl.setVarietyType("产品产量");
|
|
GxdhCountIndex cpdh = new GxdhCountIndex();
|
cpdh.setVarietyType("产品单耗");
|
//先查 能源消耗量
|
gxdhCountIndex.setVarietyType("NYXHL");
|
List<GxdhCountIndex> queryNyxhlRes = gxdhCountMapper.selectGxdhCountIndexList(gxdhCountIndex);
|
if(queryNyxhlRes!=null && queryNyxhlRes.size()>0)
|
{
|
for(GxdhCountIndex gxdhCountIndexT:queryNyxhlRes)
|
{
|
if(gxdhCountIndexT.getFL().equals("DIAN"))
|
{
|
nyxhl.setA1(gxdhCountIndexT.getA1());
|
nyxhl.setA4(gxdhCountIndexT.getA2());
|
nyxhl.setA7(gxdhCountIndexT.getA3());
|
nyxhl.setA10(gxdhCountIndexT.getA4());
|
nyxhl.setA13(gxdhCountIndexT.getA5());
|
nyxhl.setA16(gxdhCountIndexT.getA6());
|
nyxhl.setA19(gxdhCountIndexT.getA7());
|
nyxhl.setA22(gxdhCountIndexT.getA8());
|
nyxhl.setA25(gxdhCountIndexT.getA9());
|
nyxhl.setA28(gxdhCountIndexT.getA10());
|
nyxhl.setA31(gxdhCountIndexT.getA11());
|
nyxhl.setA34(gxdhCountIndexT.getA12());
|
}else if(gxdhCountIndexT.getFL().equals("MQ"))
|
{
|
nyxhl.setA2(gxdhCountIndexT.getA1());
|
nyxhl.setA5(gxdhCountIndexT.getA2());
|
nyxhl.setA8(gxdhCountIndexT.getA3());
|
nyxhl.setA11(gxdhCountIndexT.getA4());
|
nyxhl.setA14(gxdhCountIndexT.getA5());
|
nyxhl.setA17(gxdhCountIndexT.getA6());
|
nyxhl.setA20(gxdhCountIndexT.getA7());
|
nyxhl.setA23(gxdhCountIndexT.getA8());
|
nyxhl.setA26(gxdhCountIndexT.getA9());
|
nyxhl.setA29(gxdhCountIndexT.getA10());
|
nyxhl.setA32(gxdhCountIndexT.getA11());
|
nyxhl.setA35(gxdhCountIndexT.getA12());
|
}else if(gxdhCountIndexT.getFL().equals("ZQ"))
|
{
|
nyxhl.setA3(gxdhCountIndexT.getA1());
|
nyxhl.setA6(gxdhCountIndexT.getA2());
|
nyxhl.setA9(gxdhCountIndexT.getA3());
|
nyxhl.setA12(gxdhCountIndexT.getA4());
|
nyxhl.setA15(gxdhCountIndexT.getA5());
|
nyxhl.setA18(gxdhCountIndexT.getA6());
|
nyxhl.setA21(gxdhCountIndexT.getA7());
|
nyxhl.setA24(gxdhCountIndexT.getA8());
|
nyxhl.setA27(gxdhCountIndexT.getA9());
|
nyxhl.setA30(gxdhCountIndexT.getA10());
|
nyxhl.setA33(gxdhCountIndexT.getA11());
|
nyxhl.setA36(gxdhCountIndexT.getA12());
|
}
|
}
|
}
|
|
//再查 产品产量
|
gxdhCountIndex.setVarietyType("CPCL");
|
List<GxdhCountIndex> queryCpclRes = gxdhCountMapper.selectGxdhCountIndexList(gxdhCountIndex);
|
if(queryCpclRes!=null && queryCpclRes.size()>0)
|
{
|
for(GxdhCountIndex gxdhCountIndexCpcl:queryCpclRes)
|
{
|
if(gxdhCountIndexCpcl.getFL().equals("DIAN"))
|
{
|
cpcl.setA1(gxdhCountIndexCpcl.getA1());
|
cpcl.setA4(gxdhCountIndexCpcl.getA2());
|
cpcl.setA7(gxdhCountIndexCpcl.getA3());
|
cpcl.setA10(gxdhCountIndexCpcl.getA4());
|
cpcl.setA13(gxdhCountIndexCpcl.getA5());
|
cpcl.setA16(gxdhCountIndexCpcl.getA6());
|
cpcl.setA19(gxdhCountIndexCpcl.getA7());
|
cpcl.setA22(gxdhCountIndexCpcl.getA8());
|
cpcl.setA25(gxdhCountIndexCpcl.getA9());
|
cpcl.setA28(gxdhCountIndexCpcl.getA10());
|
cpcl.setA31(gxdhCountIndexCpcl.getA11());
|
cpcl.setA34(gxdhCountIndexCpcl.getA12());
|
}else if(gxdhCountIndexCpcl.getFL().equals("MQ"))
|
{
|
cpcl.setA2(gxdhCountIndexCpcl.getA1());
|
cpcl.setA5(gxdhCountIndexCpcl.getA2());
|
cpcl.setA8(gxdhCountIndexCpcl.getA3());
|
cpcl.setA11(gxdhCountIndexCpcl.getA4());
|
cpcl.setA14(gxdhCountIndexCpcl.getA5());
|
cpcl.setA17(gxdhCountIndexCpcl.getA6());
|
cpcl.setA20(gxdhCountIndexCpcl.getA7());
|
cpcl.setA23(gxdhCountIndexCpcl.getA8());
|
cpcl.setA26(gxdhCountIndexCpcl.getA9());
|
cpcl.setA29(gxdhCountIndexCpcl.getA10());
|
cpcl.setA32(gxdhCountIndexCpcl.getA11());
|
cpcl.setA35(gxdhCountIndexCpcl.getA12());
|
}else if(gxdhCountIndexCpcl.getFL().equals("ZQ"))
|
{
|
cpcl.setA3(gxdhCountIndexCpcl.getA1());
|
cpcl.setA6(gxdhCountIndexCpcl.getA2());
|
cpcl.setA9(gxdhCountIndexCpcl.getA3());
|
cpcl.setA12(gxdhCountIndexCpcl.getA4());
|
cpcl.setA15(gxdhCountIndexCpcl.getA5());
|
cpcl.setA18(gxdhCountIndexCpcl.getA6());
|
cpcl.setA21(gxdhCountIndexCpcl.getA7());
|
cpcl.setA24(gxdhCountIndexCpcl.getA8());
|
cpcl.setA27(gxdhCountIndexCpcl.getA9());
|
cpcl.setA30(gxdhCountIndexCpcl.getA10());
|
cpcl.setA33(gxdhCountIndexCpcl.getA11());
|
cpcl.setA36(gxdhCountIndexCpcl.getA12());
|
}
|
}
|
}
|
|
resList.add(nyxhl);
|
resList.add(cpcl);
|
//计算产品单耗=能源消耗量/产品产量
|
cpdh.setA1(calculationCpdh(nyxhl.getA1(),cpcl.getA1()));
|
cpdh.setA2(calculationCpdh(nyxhl.getA2(),cpcl.getA2()));
|
cpdh.setA3(calculationCpdh(nyxhl.getA3(),cpcl.getA3()));
|
cpdh.setA4(calculationCpdh(nyxhl.getA4(),cpcl.getA4()));
|
cpdh.setA5(calculationCpdh(nyxhl.getA5(),cpcl.getA5()));
|
cpdh.setA6(calculationCpdh(nyxhl.getA6(),cpcl.getA6()));
|
cpdh.setA7(calculationCpdh(nyxhl.getA7(),cpcl.getA7()));
|
cpdh.setA8(calculationCpdh(nyxhl.getA8(),cpcl.getA8()));
|
cpdh.setA9(calculationCpdh(nyxhl.getA9(),cpcl.getA9()));
|
cpdh.setA10(calculationCpdh(nyxhl.getA10(),cpcl.getA10()));
|
cpdh.setA11(calculationCpdh(nyxhl.getA11(),cpcl.getA11()));
|
cpdh.setA12(calculationCpdh(nyxhl.getA12(),cpcl.getA12()));
|
cpdh.setA13(calculationCpdh(nyxhl.getA13(),cpcl.getA13()));
|
cpdh.setA14(calculationCpdh(nyxhl.getA14(),cpcl.getA14()));
|
cpdh.setA15(calculationCpdh(nyxhl.getA15(),cpcl.getA15()));
|
cpdh.setA16(calculationCpdh(nyxhl.getA16(),cpcl.getA16()));
|
cpdh.setA17(calculationCpdh(nyxhl.getA17(),cpcl.getA17()));
|
cpdh.setA18(calculationCpdh(nyxhl.getA18(),cpcl.getA18()));
|
cpdh.setA19(calculationCpdh(nyxhl.getA19(),cpcl.getA19()));
|
cpdh.setA20(calculationCpdh(nyxhl.getA20(),cpcl.getA20()));
|
cpdh.setA21(calculationCpdh(nyxhl.getA21(),cpcl.getA21()));
|
cpdh.setA22(calculationCpdh(nyxhl.getA22(),cpcl.getA22()));
|
cpdh.setA23(calculationCpdh(nyxhl.getA23(),cpcl.getA23()));
|
cpdh.setA24(calculationCpdh(nyxhl.getA24(),cpcl.getA24()));
|
cpdh.setA25(calculationCpdh(nyxhl.getA25(),cpcl.getA25()));
|
cpdh.setA26(calculationCpdh(nyxhl.getA26(),cpcl.getA26()));
|
cpdh.setA27(calculationCpdh(nyxhl.getA27(),cpcl.getA27()));
|
cpdh.setA28(calculationCpdh(nyxhl.getA28(),cpcl.getA28()));
|
cpdh.setA29(calculationCpdh(nyxhl.getA29(),cpcl.getA29()));
|
cpdh.setA30(calculationCpdh(nyxhl.getA30(),cpcl.getA30()));
|
cpdh.setA31(calculationCpdh(nyxhl.getA31(),cpcl.getA31()));
|
cpdh.setA32(calculationCpdh(nyxhl.getA32(),cpcl.getA32()));
|
cpdh.setA33(calculationCpdh(nyxhl.getA33(),cpcl.getA33()));
|
cpdh.setA34(calculationCpdh(nyxhl.getA34(),cpcl.getA34()));
|
cpdh.setA35(calculationCpdh(nyxhl.getA35(),cpcl.getA35()));
|
cpdh.setA36(calculationCpdh(nyxhl.getA36(),cpcl.getA36()));
|
resList.add(cpdh);
|
return resList;
|
}
|
|
private String calculationCpdh(String nyxhl,String cpcl)
|
{
|
try{
|
if(nyxhl.equals("--")||cpcl.equals("--"))
|
{
|
return "--";
|
}else{
|
double fz = Double.parseDouble(nyxhl);
|
double fm = Double.parseDouble(cpcl);
|
return String.format("%.2f", fz/fm);
|
}
|
}catch (Exception e)
|
{
|
e.printStackTrace();
|
return "--";
|
}
|
}
|
}
|
