| | |
| | | import com.finance.common.utils.EasyExcelUtil; |
| | | import com.finance.common.utils.SecurityUtils; |
| | | import com.finance.common.utils.StringUtils; |
| | | import com.finance.system.constants.QuarterConstant; |
| | | import com.finance.system.domain.TbBasicData; |
| | | import com.finance.system.domain.TbBasicDataConfig; |
| | | import com.finance.system.domain.TbBasicDataConfigDetail; |
| | |
| | | if (tbBasicDataField != null) { |
| | | field.setValue( |
| | | tbBasicDataField.getFieldValue()); |
| | | } else { |
| | | field.setValue(""); |
| | | } |
| | | if (field.getChildren() != null && !field.getChildren().isEmpty()) { |
| | | setFieldValues(field.getChildren(), fieldMap); |
| | |
| | | LocalDate fifteenDaysLimit = quarterStartLocalDate.plusDays(14); |
| | | LocalDate now = LocalDate.now(); |
| | | String previousQuarter = DateUtils.getPreviousQuarter(); |
| | | previousQuarter = "2024年一季度"; |
| | | previousQuarter = QuarterConstant.CURRENT_QUARTER; |
| | | DateUtils.getQuarterDate(previousQuarter); |
| | | vo.setQuarter(previousQuarter); |
| | | vo.setStatus(ReportingStatusEnum.UNFILLED); |
| | |
| | | return; |
| | | } |
| | | String previousQuarter = DateUtils.getPreviousQuarter(); |
| | | previousQuarter = "2024年一季度"; |
| | | previousQuarter = QuarterConstant.CURRENT_QUARTER; |
| | | // 查询需要填写的动态字段 |
| | | List<TbField> fieldList = |
| | | tbFieldService.lambdaQuery().eq(TbField::getStatus, ShowStatusEnum.SHOW).list(); |
| | |
| | | .eq(TbBasicData::getDeptAreaCode, areaCode) |
| | | .eq(TbBasicData::getQuarter, previousQuarter).oneOpt(); |
| | | TbBasicData tbBasicData = BeanUtils.copyBean(dto, TbBasicData.class); |
| | | tbBasicData.setCurrentGdp(tbBasicData.getCurrentGdp().replace(",", "")); |
| | | tbBasicData.setTransferPaymentScale(tbBasicData.getTransferPaymentScale().replace(",", "")); |
| | | if (basicDataOpt.isPresent()) { |
| | | tbBasicData.setId(basicDataOpt.get().getId()); |
| | | tbBasicData.setDeptAreaCode(areaCode); |
| | |
| | | field.getFieldValue(), tbOperlogList, result.toString()); |
| | | } |
| | | } |
| | | tbOperLogService.saveBatch(tbOperlogList); |
| | | } |
| | | |
| | | private static void wrapOperLog(LoginUser loginUser, TbBasicData tbBasicData, String before, |
| | |
| | | LoginUser loginUser = SecurityUtils.getLoginUser(); |
| | | String areaCode = loginUser.getUser().getAreaCode(); |
| | | String previousQuarter = DateUtils.getPreviousQuarter(); |
| | | previousQuarter = "2024年一季度"; |
| | | previousQuarter = QuarterConstant.CURRENT_QUARTER; |
| | | EasyExcel.read( |
| | | file.getInputStream(), |
| | | new BasicDataListener( |
| | |
| | | Date quarterStart = DateUtil.beginOfQuarter(date); |
| | | Date quarterEnd = DateUtil.endOfQuarter(date); |
| | | String previousQuarter = DateUtils.getPreviousQuarter(); |
| | | previousQuarter = "2024年一季度"; |
| | | // previousQuarter = "2024年一季度"; |
| | | // 查询是否有当前季度的填报记录 |
| | | TbBasicData basicData = |
| | | this.getOne( |
| | |
| | | roots.add(remark); |
| | | vo.setFields(roots); |
| | | String previousQuarter = DateUtils.getPreviousQuarter(); |
| | | previousQuarter = "2024年一季度"; |
| | | // previousQuarter = "2024年一季度"; |
| | | // 查询上报的基础数据 |
| | | List<TbBasicData> basicDataList = |
| | | this.lambdaQuery() |
| | |
| | | if (quarterLocalDate.isAfter(dateLocalDate) || quarterLocalDate.equals(dateLocalDate)) { |
| | | throw new ServiceException("请导入过去季度的数据。"); |
| | | } |
| | | |
| | | long start = System.currentTimeMillis(); |
| | | EasyExcel.read( |
| | | file.getInputStream(), |
| | | new HistoryDataListener( |
| | |
| | | .sheet() |
| | | .headRowNumber(0) |
| | | .doRead(); |
| | | log.info("历史数据导入完成,耗时{}毫秒", System.currentTimeMillis() - start); |
| | | } |
| | | |
| | | @Override |
| | |
| | | // 查询需要填写的动态字段 |
| | | List<TbField> fieldList = |
| | | tbFieldService.lambdaQuery().eq(TbField::getStatus, ShowStatusEnum.SHOW).list(); |
| | | Map<Long, TbField> allFieldMap = fieldList.stream() |
| | | .collect(Collectors.toMap(TbField::getId, e -> e)); |
| | | List<TbBasicDataField> originFields = tbBasicDataFieldService.lambdaQuery() |
| | | .eq(TbBasicDataField::getBasicDataId, basicData.getId()).list(); |
| | | Set<Long> fieldIdList = originFields.stream().map(TbBasicDataField::getFieldId) |
| | |
| | | BeanUtils.copyBean(dto, BasicDataDTO.class), |
| | | fieldMap)); |
| | | TbBasicData tbBasicData = BeanUtils.copyBean(dto, TbBasicData.class); |
| | | tbBasicData.setCurrentGdp(tbBasicData.getCurrentGdp().replace(",", "")); |
| | | tbBasicData.setTransferPaymentScale(tbBasicData.getTransferPaymentScale().replace(",", "")); |
| | | tbBasicData.setDeptAreaCode(basicData.getDeptAreaCode()); |
| | | tbBasicData.setQuarter(basicData.getQuarter()); |
| | | // 保存基础数据动态字段数据 |
| | | List<TbBasicDataField> tbBasicDataFields = |
| | |
| | | if (StringUtils.isNotBlank(item.getFieldValue())) { |
| | | item.setFieldValue(item.getFieldValue().replace(",", "")); |
| | | } |
| | | } else { |
| | | TbField field = allFieldMap.get(item.getFieldId()); |
| | | item.setFieldName(field.getFieldName()); |
| | | item.setBasicDataId(basicData.getId()); |
| | | } |
| | | |
| | | }).collect(Collectors.toList()); |