package com.yuanchu.mom.service.impl;
|
|
import cn.hutool.core.util.ObjectUtil;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.yuanchu.mom.common.GetLook;
|
import com.yuanchu.mom.common.PrintChina;
|
import com.yuanchu.mom.exception.ErrorException;
|
import com.yuanchu.mom.mapper.DataReportingMapper;
|
import com.yuanchu.mom.pojo.DataReporting;
|
import com.yuanchu.mom.pojo.FansSubmit;
|
import com.yuanchu.mom.pojo.FinanceSubmit;
|
import com.yuanchu.mom.service.DataReportingService;
|
import com.yuanchu.mom.service.FansSubmitService;
|
import com.yuanchu.mom.service.FinanceSubmitService;
|
import com.yuanchu.mom.mapper.FinanceSubmitMapper;
|
import com.yuanchu.mom.utils.QueryWrappers;
|
import lombok.AllArgsConstructor;
|
import org.springframework.stereotype.Service;
|
|
import java.math.BigDecimal;
|
import java.math.RoundingMode;
|
import java.time.LocalDate;
|
import java.time.LocalDateTime;
|
import java.time.format.DateTimeFormatter;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @author Administrator
|
* @description 针对表【finance_submit】的数据库操作Service实现
|
* @createDate 2023-12-25 01:48:05
|
*/
|
@Service
|
@AllArgsConstructor
|
public class FinanceSubmitServiceImpl extends ServiceImpl<FinanceSubmitMapper, FinanceSubmit>
|
implements FinanceSubmitService{
|
|
private FinanceSubmitMapper financeSubmitMapper;
|
|
private GetLook getLook;
|
|
private DataReportingMapper dataReportingMapper;
|
|
@Override
|
public Map<String, Object> selectFinanceSubmitList(IPage<FinanceSubmit> page, FinanceSubmit financeSubmit) {
|
Map<String, Object> map = new HashMap<>();
|
map.put("head", PrintChina.printChina(FinanceSubmit.class));
|
Map<String, Integer> map1 = getLook.selectPowerByMethodAndUserId("selectFinanceSubmitList");
|
if(map1.get("look")==1) financeSubmit.setCreateUser(map1.get("userId"));
|
map.put("body", financeSubmitMapper.selectFinanceSubmitPageList(page, QueryWrappers.queryWrappers(financeSubmit)));
|
return map;
|
}
|
|
@Override
|
public int delFinanceSubmit(Integer id) {
|
FinanceSubmit financeSubmit = financeSubmitMapper.selectOne(Wrappers.<FinanceSubmit>lambdaQuery().eq(FinanceSubmit::getId, id).select(FinanceSubmit::getEmployeeRebate,FinanceSubmit::getName,FinanceSubmit::getCompany,FinanceSubmit::getCreateTime,FinanceSubmit::getDataId));
|
financeSubmitMapper.deleteById(id);
|
FinanceSubmit financeSubmit2 = financeSubmitMapper.selectOne(Wrappers.<FinanceSubmit>lambdaQuery().eq(FinanceSubmit::getCompany, financeSubmit.getCompany()).eq(FinanceSubmit::getName, financeSubmit.getName()).eq(FinanceSubmit::getDataId, financeSubmit.getDataId()).select(FinanceSubmit::getEmployeeRebate).like(FinanceSubmit::getCreateTime, financeSubmit.getCreateTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd"))).orderByDesc(FinanceSubmit::getId).last("limit 1"));
|
if(ObjectUtil.isEmpty(financeSubmit2)){
|
return 1;
|
};
|
List<DataReporting> dataReportings = dataReportingMapper.selectList(Wrappers.<DataReporting>lambdaQuery().eq(DataReporting::getAgent, financeSubmit.getCompany()).eq(DataReporting::getName, financeSubmit.getName()).eq(DataReporting::getCreateUser, financeSubmit.getDataId()).like(DataReporting::getCreateTime, financeSubmit.getCreateTime().minusDays(1).format(DateTimeFormatter.ofPattern("yyyy-MM-dd"))));
|
for (DataReporting dataReporting : dataReportings) {
|
dataReporting.setAgentRebate(financeSubmit2.getEmployeeRebate());
|
dataReportingMapper.updateById(computingMethod(dataReporting));
|
}
|
return 1;
|
}
|
|
@Override
|
public int updateFinanceSubmit(FinanceSubmit financeSubmit3) {
|
financeSubmitMapper.updateById(financeSubmit3);
|
FinanceSubmit financeSubmit = financeSubmitMapper.selectOne(Wrappers.<FinanceSubmit>lambdaQuery().eq(FinanceSubmit::getId, financeSubmit3.getId()).select(FinanceSubmit::getEmployeeRebate,FinanceSubmit::getName,FinanceSubmit::getCompany,FinanceSubmit::getCreateTime,FinanceSubmit::getDataId));
|
FinanceSubmit financeSubmit2 = financeSubmitMapper.selectOne(Wrappers.<FinanceSubmit>lambdaQuery().eq(FinanceSubmit::getCompany, financeSubmit.getCompany()).eq(FinanceSubmit::getName, financeSubmit.getName()).eq(FinanceSubmit::getDataId, financeSubmit.getDataId()).select(FinanceSubmit::getEmployeeRebate).like(FinanceSubmit::getCreateTime, financeSubmit.getCreateTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd"))).orderByDesc(FinanceSubmit::getId).last("limit 1"));
|
if(ObjectUtil.isEmpty(financeSubmit2))return 1;
|
List<DataReporting> dataReportings = dataReportingMapper.selectList(Wrappers.<DataReporting>lambdaQuery().eq(DataReporting::getAgent, financeSubmit.getCompany()).eq(DataReporting::getName, financeSubmit.getName()).eq(DataReporting::getCreateUser, financeSubmit.getDataId()).like(DataReporting::getCreateTime, financeSubmit.getCreateTime().minusDays(1).format(DateTimeFormatter.ofPattern("yyyy-MM-dd"))));
|
for (DataReporting dataReporting : dataReportings) {
|
dataReporting.setAgentRebate(financeSubmit2.getEmployeeRebate());
|
dataReportingMapper.updateById(computingMethod(dataReporting));
|
}
|
return 1;
|
}
|
|
public DataReporting computingMethod(DataReporting dataReporting){
|
try {
|
dataReporting.setRebateConsumption(dataReporting.getAccountConsumption().divide(dataReporting.getCustomerRebate(), 2, RoundingMode.HALF_UP));
|
} catch (Exception e) {
|
}
|
try {
|
dataReporting.setConsumption(dataReporting.getCustomerCosts().multiply(BigDecimal.valueOf(dataReporting.getFansAdd())));
|
} catch (Exception e) {
|
}
|
try {
|
dataReporting.setDiscountedConsumption(dataReporting.getConsumption().divide(dataReporting.getAgentRebate(), 2, RoundingMode.HALF_UP));
|
} catch (Exception e) {
|
}
|
try {
|
dataReporting.setActualCost(dataReporting.getAccountConsumption().divide(new BigDecimal(dataReporting.getFansAdd()), 2, RoundingMode.HALF_UP));
|
} catch (Exception e) {
|
}
|
try {
|
dataReporting.setProfit(dataReporting.getRebateConsumption().subtract(dataReporting.getConsumption()));
|
} catch (Exception e) {
|
}
|
return dataReporting;
|
}
|
|
@Override
|
public int addFinanceSubmit(FinanceSubmit financeSubmit, String date, String param) {
|
if(date == null) date = getYesterday();
|
// financeSubmit.setDataId(Integer.parseInt(param));
|
String date2 = null;
|
if(date == null) {
|
date = LocalDate.now().format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
|
date2 = getYesterday();
|
}else{
|
date = LocalDateTime.parse(date + "T00:00:00").plusDays(1).format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
|
date2 = LocalDateTime.parse(date + "T00:00:00").minusDays(1).format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
|
financeSubmit.setCreateTime(LocalDateTime.parse(date + "T00:00:00"));
|
}
|
financeSubmitMapper.insert(financeSubmit);
|
FinanceSubmit financeSubmit2 = financeSubmitMapper.selectOne(Wrappers.<FinanceSubmit>lambdaQuery().eq(FinanceSubmit::getCompany, financeSubmit.getCompany()).eq(FinanceSubmit::getName, financeSubmit.getName()).select(FinanceSubmit::getEmployeeRebate).like(FinanceSubmit::getCreateTime, date).orderByDesc(FinanceSubmit::getId).last("limit 1"));
|
if(ObjectUtil.isEmpty(financeSubmit2))return 1;
|
List<DataReporting> dataReportings = dataReportingMapper.selectList(Wrappers.<DataReporting>lambdaQuery().eq(DataReporting::getAgent, financeSubmit.getCompany()).eq(DataReporting::getName, financeSubmit.getName()).like(DataReporting::getCreateTime, date2));
|
for (DataReporting dataReporting : dataReportings) {
|
dataReporting.setAgentRebate(financeSubmit2.getEmployeeRebate());
|
dataReportingMapper.updateById(computingMethod(dataReporting));
|
}
|
return 1;
|
}
|
|
public String getYesterday(){
|
return LocalDate.now().minusDays(1).format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
|
}
|
|
@Override
|
public void deleteAllFinance(String date) {
|
List<FinanceSubmit> list = financeSubmitMapper.selectList(Wrappers.<FinanceSubmit>lambdaQuery().eq(FinanceSubmit::getCreateUser, getLook.selectPowerByMethodAndUserId("selectDataReportingList").get("userId")).like(FinanceSubmit::getCreateTime, date).select(FinanceSubmit::getId));
|
for (FinanceSubmit financeSubmit : list) {
|
delFinanceSubmit(financeSubmit.getId());
|
}
|
}
|
}
|
