| | |
| | | import com.ruoyi.common.enums.BusinessType; |
| | | import com.ruoyi.common.utils.ServletUtils; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.ruoyi.domain.ZfPet; |
| | | import com.ruoyi.domain.ZfPetNote; |
| | | import com.ruoyi.domain.ZfProperty; |
| | | import com.ruoyi.service.ZfPetNoteService; |
| | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import javax.websocket.server.PathParam; |
| | | import java.util.Arrays; |
| | | import java.util.Collections; |
| | | import java.util.List; |
| | | |
| | | import static com.ruoyi.common.core.page.TableSupport.PAGE_NUM; |
| | |
| | | return zfPetNoteService.getAllPetNoteByPetId(pid); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 获取导入模板 |
| | | */ |
| | | @GetMapping("/model") |
| | | public void getExportModel(HttpServletResponse response){ |
| | | List<ZfPetNote> list = Collections.singletonList(new ZfPetNote()); |
| | | ExcelUtil<ZfPetNote> util = new ExcelUtil<>(ZfPetNote.class); |
| | | util.exportExcel(response,list,"魅宠备忘录记录数据"); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 导出魅宠备忘录记录列表 |
| | | */ |
| | |
| | | * 导入魅宠备忘录记录列表 |
| | | */ |
| | | @Log(title = "用户管理", businessType = BusinessType.IMPORT) |
| | | @PostMapping("/importData") |
| | | public AjaxResult importData(@RequestParam("excelImport") MultipartFile file) throws Exception |
| | | @PostMapping("/importData/{pid}") |
| | | public AjaxResult importData(@RequestParam("excelImport") MultipartFile file,@PathVariable Long pid) throws Exception |
| | | { |
| | | ExcelUtil<ZfPetNote> util = new ExcelUtil<>(ZfPetNote.class); |
| | | List<ZfPetNote> eventList = util.importExcel(file.getInputStream()); |
| | | for (ZfPetNote zfPetNote : eventList) { |
| | | zfPetNote.setPid(pid); |
| | | } |
| | | log.info("魅宠备忘录列表为:{}",eventList); |
| | | |
| | | if (zfPetNoteService.saveBatch(eventList)) { |