From 463f4334cf41a30348067f5d5b3cf288c19c0eba Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期三, 24 一月 2024 14:54:03 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
server/service/src/main/java/com/doumee/service/business/impl/ApplyChangeServiceImpl.java | 104 ++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 104 insertions(+), 0 deletions(-)
diff --git a/server/service/src/main/java/com/doumee/service/business/impl/ApplyChangeServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/ApplyChangeServiceImpl.java
index 0203ee3..321678a 100644
--- a/server/service/src/main/java/com/doumee/service/business/impl/ApplyChangeServiceImpl.java
+++ b/server/service/src/main/java/com/doumee/service/business/impl/ApplyChangeServiceImpl.java
@@ -910,8 +910,112 @@
ApplyChange applyChange = applyChangeJoinMapper.selectOne(queryWrapper);
return applyChange;
}
+ /**
+ * 瀵煎嚭鎹㈠巶鐢宠琛�
+ * @param param
+ * @return
+ */
+ @Override
+ public ApplyChange exportChangeUnitExcel(ApplyChange param){
+ ApplyChange model = findJoinDetail(param);
+ if(Objects.isNull(model) ||! Constants.equalsInteger(Constants.ZERO,model.getType())){
+ throw new BusinessException(ResponseStatus.DATA_EMPTY);
+ }
+
+ //鏌ヨ鏄庣粏
+ List<ApplyChagneDetail> detailList =findJoinChangeDetailList(model);
+ model.setChangeDetailList(detailList!=null?detailList:new ArrayList<>());
+ model.setChangeNum(model.getChangeDetailList().size());
+ return model;
+ }
+ /**
+ * 瀵煎嚭鍔犲噺淇濈敵璇疯〃
+ * @param param
+ * @return
+ */
+ @Override
+ public ApplyChange exportJiajianBaoExcel(ApplyChange param){
+
+ ApplyChange model = findJoinDetail(param);
+ if(Objects.isNull(model) ||! Constants.equalsInteger(Constants.ZERO,model.getType())){
+ throw new BusinessException(ResponseStatus.DATA_EMPTY);
+ }
+
+ //鏌ヨ鏄庣粏
+ List<ApplyChagneDetail> detailList =findJoinDetailList(model);
+ model.setAddDetailList(new ArrayList<>());
+ model.setDelDetailList(new ArrayList<>());
+ if(detailList!=null){
+ for(ApplyChagneDetail ad :detailList){
+ if(Constants.equalsInteger(ad.getType(),Constants.ZERO)){
+ model.getAddDetailList().add(ad);
+ }else{
+ model.getDelDetailList().add(ad);
+ }
+ }
+ }
+ model.setDelNum(model.getDelDetailList().size());
+ model.setAddNum(model.getAddDetailList().size());
+ return model;
+ }
+ private ApplyChange findJoinDetail(ApplyChange param) {
+ MPJLambdaWrapper wrapper= new MPJLambdaWrapper<ApplyChange>()
+ .selectAll(ApplyChange.class)
+ .selectAs(Solutions::getName,ApplyChange::getSolutionsName)
+ .selectAs(Company::getName,ApplyChange::getCompanyName)
+ .selectAs(InsuranceApply::getCode,ApplyChange::getApplyCode)
+ .selectAs(InsuranceApply::getStartTime,ApplyChange::getStartTime)
+ .selectAs(InsuranceApply::getStartTime,ApplyChange::getEndTime)
+ .leftJoin(InsuranceApply.class,InsuranceApply::getId,ApplyChange::getApplyId)
+ .leftJoin(Solutions.class,Solutions::getId,InsuranceApply::getSolutionId)
+ .leftJoin(Company.class,Company::getId,ApplyChange::getCompanyId)
+ .eq(ApplyChange::getId,param.getId())
+ .last("limit 1");
+
+ ApplyChange model = applyChangeJoinMapper.selectJoinOne(ApplyChange.class,wrapper);
+ return model;
+ }
+ private List<ApplyChagneDetail> findJoinDetailList(ApplyChange model) {
+ MPJLambdaWrapper wrapper1= new MPJLambdaWrapper<ApplyChagneDetail>()
+ .selectAll(ApplyChagneDetail.class)
+ .selectAs(Member::getName,ApplyChagneDetail::getMemberName)
+ .selectAs(Member::getSex,ApplyChagneDetail::getSex)
+ .selectAs(Member::getIdcardNo,ApplyChagneDetail::getIdcardNo)
+ .selectAs(Worktype::getName,ApplyChagneDetail::getWorkTypeName)
+ .selectAs(DispatchUnit::getName,ApplyChagneDetail::getDuName)
+ .leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getWorktypeId)
+ .leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getDuId)
+ .leftJoin(Member.class,Member::getId,ApplyChagneDetail::getMemberId)
+ .eq(ApplyChagneDetail::getIsdeleted,Constants.ZERO)
+ .eq(ApplyChagneDetail::getApplyChangeId,model.getId());
+ //鏌ヨ鏄庣粏
+ List<ApplyChagneDetail> detailList =applyChagneDetailJoinMapper.selectJoinList(ApplyChagneDetail.class,wrapper1);
+ return detailList;
+ }
+ private List<ApplyChagneDetail> findJoinChangeDetailList(ApplyChange model) {
+ MPJLambdaWrapper wrapper1= new MPJLambdaWrapper<ApplyChagneDetail>()
+ .selectAll(ApplyChagneDetail.class)
+ .selectAs(Member::getName,ApplyChagneDetail::getMemberName)
+ .selectAs(Member::getSex,ApplyChagneDetail::getSex)
+ .select("t1.name as worktypeName")
+ .select("t2.name as duName")
+ .select("t3.name as oldWorktypeName")
+ .select("t4.name as oldDuName")
+ .selectAs(Member::getSex,ApplyChagneDetail::getSex)
+ .selectAs(Member::getIdcardNo,ApplyChagneDetail::getIdcardNo)
+ .leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getWorktypeId)
+ .leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getDuId)
+ .leftJoin(Worktype.class,Worktype::getId,ApplyChagneDetail::getOldWorktypeId)
+ .leftJoin(DispatchUnit.class,DispatchUnit::getId,ApplyChagneDetail::getOldDuId)
+ .leftJoin(Member.class,Member::getId,ApplyChagneDetail::getMemberId)
+ .eq(ApplyChagneDetail::getIsdeleted,Constants.ZERO)
+ .eq(ApplyChagneDetail::getApplyChangeId,model.getId());
+ //鏌ヨ鏄庣粏
+ List<ApplyChagneDetail> detailList =applyChagneDetailJoinMapper.selectJoinList(ApplyChagneDetail.class,wrapper1);
+ return detailList;
+ }
}
--
Gitblit v1.9.3