| | |
| | | import doumeemes.core.utils.Constants; |
| | | import doumeemes.core.utils.Utils; |
| | | import doumeemes.core.utils.excel.EasyExcelUtil; |
| | | import doumeemes.dao.business.DepartmentMapper; |
| | | import doumeemes.dao.business.MaterialMapper; |
| | | import doumeemes.dao.business.ProceduresMapper; |
| | | import doumeemes.dao.business.SalaryParamMapper; |
| | | import doumeemes.dao.business.*; |
| | | import doumeemes.dao.business.model.*; |
| | | import doumeemes.dao.business.vo.SalaryParamVO; |
| | | import doumeemes.dao.ext.dto.SalaryParamDTO; |
| | |
| | | |
| | | @Autowired |
| | | private MaterialMapper materialMapper; |
| | | @Autowired |
| | | private MaterialDistributeMapper materialDistributeMapper; |
| | | |
| | | @Autowired |
| | | private ProceduresMapper proceduresMapper; |
| | |
| | | wrapper.lambda() |
| | | .eq(Department::getName,salaryParamImportDTO.getDepartName()) |
| | | .eq(Department::getType,Constants.DEPART_TYPE.factory) |
| | | .eq(Department::getDeleted,Constants.ZERO) |
| | | .last("limit 1"); |
| | | Department department = departmentMapper.selectOne(wrapper); |
| | | if (Objects.isNull(department)){ |
| | |
| | | materialWrapper.lambda() |
| | | .eq(Material::getCode,salaryParamImportDTO.getMaterialCode()) |
| | | .eq(Material::getRootDepartId,department.getRootId()) |
| | | .eq(Material::getDeleted,Constants.ZERO) |
| | | .last("limit 1"); |
| | | Material material = materialMapper.selectOne(materialWrapper); |
| | | |
| | |
| | | } |
| | | if (Objects.nonNull(material) && !Objects.equals(material.getName(),salaryParamImportDTO.getMaterialName())){ |
| | | throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "导入数据内容【产品名称】有误!"); |
| | | } |
| | | QueryWrapper<MaterialDistribute> materialDistributeQueryWrapper = new QueryWrapper<>(); |
| | | materialDistributeQueryWrapper.lambda() |
| | | .eq(MaterialDistribute::getMaterialId,material.getId()) |
| | | .eq(MaterialDistribute::getRootDepartId,department.getRootId()) |
| | | .eq(MaterialDistribute::getDeleted,Constants.ZERO) |
| | | .last("limit 1"); |
| | | MaterialDistribute materialDistribute = materialDistributeMapper.selectOne(materialDistributeQueryWrapper); |
| | | if (Objects.isNull(materialDistribute)){ |
| | | throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "导入数据内容【产品编码】有误!"); |
| | | } |
| | | QueryWrapper<Procedures> proceduresWrapper = new QueryWrapper<>(); |
| | | proceduresWrapper.lambda() |
| | |
| | | salaryParam.setRootDepartId(department.getRootId()); |
| | | salaryParam.setDepartId(department.getId()); |
| | | salaryParam.setProcedureId(procedures.getId()); |
| | | salaryParam.setMaterialId(material.getId()); |
| | | salaryParam.setMaterialId(materialDistribute.getId()); |
| | | salaryParam.setSalary(salaryParamImportDTO.getSalary()); |
| | | salaryParam.setNum(new BigDecimal(salaryParamImportDTO.getNum())); |
| | | salaryParam.setTimes(getIntegerTimes(salaryParamImportDTO.getTimesName())); |