| | |
| | | package com.yuanchu.mom.controller; |
| | | |
| | | import cn.hutool.core.lang.Console; |
| | | import cn.hutool.core.text.csv.CsvData; |
| | | import cn.hutool.core.text.csv.CsvReader; |
| | | import cn.hutool.core.text.csv.CsvRow; |
| | |
| | | |
| | | @ApiOperation(value = "导入进粉上报列表") |
| | | @PostMapping("/inputFansSubmitCsv") |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public Result<?> inputFansSubmitCsv(@RequestParam("file") MultipartFile file) throws IOException { |
| | | List<FansSubmit> fansSubmitLists = new ArrayList<>(); |
| | | List<FansSubmit> fansSubmitList = new ArrayList<>(); |
| | |
| | | ExcelUtil.readBySax(file.getInputStream(), 0, (i, l, list) -> { |
| | | LocalDateTime date = null; |
| | | try { |
| | | date = LocalDateTime.parse((list.get(0) + "").replace(" ", "T")); |
| | | date = LocalDateTime.parse((list.get(0) + "").replace(" ", "T")).plusDays(1); |
| | | dates.add(date.format(DateTimeFormatter.ofPattern("yyyy-MM-dd"))+" 00:00:00"); |
| | | } catch (Exception e) {} |
| | | } catch (Exception e) { |
| | | if(!(l == 0 || l == 1 || l == 2)){ |
| | | return; |
| | | } |
| | | } |
| | | if (l == 0 || l == 1 || l == 2 |
| | | || date.compareTo(LocalDateTime.now()) < 1) { |
| | | for (int i1 = 1; i1 < list.size(); i1++) { |
| | |
| | | fansSubmit.setVx(str); |
| | | break; |
| | | case "进粉": |
| | | fansSubmit.setFansAdd(Integer.parseInt(str)); |
| | | try { |
| | | fansSubmit.setFansAdd(Integer.parseInt(str)); |
| | | }catch (Exception e){ |
| | | fansSubmit.setFansAdd(0); |
| | | } |
| | | break; |
| | | } |
| | | } |
| | |
| | | fansSubmit.setVx(str); |
| | | } |
| | | }else{ |
| | | fansSubmit.setCreateTime(date.plusDays(1)); |
| | | fansSubmit.setCreateTime(date); |
| | | fansSubmit.setFansAdd((str == null || str.equals("")) ? 0 : Integer.parseInt(str)); |
| | | } |
| | | return product; |