| | |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.moral.api.entity.AllocationLog; |
| | | import com.moral.api.entity.ResponsibilityUnit; |
| | | import com.moral.api.pojo.enums.AllocationApproveEnum; |
| | | import com.moral.api.pojo.enums.ChangeEnum; |
| | | import com.moral.api.pojo.ext.allocation.AllocationExcelExt; |
| | | import com.moral.api.pojo.ext.allocation.AllocationExt; |
| | | import com.moral.api.pojo.ext.allocation.AllocationPageExt; |
| | |
| | | import java.io.IOException; |
| | | import java.net.URL; |
| | | import java.net.URLEncoder; |
| | | import java.util.ArrayList; |
| | | import java.util.Arrays; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.*; |
| | | import java.util.concurrent.atomic.AtomicReference; |
| | | |
| | | |
| | |
| | | |
| | | } |
| | | |
| | | private final String PARHTINAGE = "https://qx.7drlb.com/api/file/preview/"; |
| | | |
| | | private void genImageExcel(List<AllocationExcelExt> list, HttpServletResponse response) throws IOException { |
| | | if (CollectionUtils.isEmpty(list)) { |
| | |
| | | } |
| | | List<AllocationListExcelVo> demoDataList = new ArrayList<>(); |
| | | for(int i = 0;i<list.size();i++){ |
| | | AllocationListExcelVo item = AllocationListExcelVo.convert(list.get(i)); |
| | | AllocationExcelExt excelExt = list.get(i); |
| | | AllocationListExcelVo item = AllocationListExcelVo.convert(excelExt); |
| | | List<String> urls = new ArrayList<>(); |
| | | for(FileAddressVo z : list.get(i).getFileBaseList()){ |
| | | for(FileAddressVo z : excelExt.getFileBaseList()){ |
| | | urls.add(handleFileRealPath(z.getFileAddress())); |
| | | } |
| | | item.setChangeTypeStr(Objects.isNull(excelExt.getChangeType())?" ":ChangeEnum.getByValue(excelExt.getChangeType()).getName()); |
| | | item.setChangeStr(Objects.isNull(excelExt.getIsChange())?"否":ChangeEnum.getByValue(excelExt.getChangeType()).getName()); |
| | | item.setWriteCellDataFile(urls); |
| | | List<String> urlsAfter = new ArrayList<>(); |
| | | for(FileAddressVo z : excelExt.getFileChangeList()){ |
| | | urlsAfter.add(handleFileRealPath(z.getFileAddress())); |
| | | } |
| | | item.setWriteCellDataFileResult(urlsAfter); |
| | | item.setEscalationTimeStr(DateUtils.dateToDateString(excelExt.getEscalationTime(),DateUtils.yyyy_MM_dd_EN)); |
| | | item.setChangeTimeStr(DateUtils.dateToDateString(excelExt.getChangeTime(),DateUtils.yyyy_MM_dd_EN)); |
| | | demoDataList.add(item); |
| | | } |
| | | try { |