| | |
| | | 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; |
| | |
| | | * 根据宠物id获取相关备忘录 |
| | | */ |
| | | @GetMapping |
| | | public AjaxResult getByPetId(@PathParam("pid")Long pid){ |
| | | return zfPetNoteService.getAllPetNoteByPetId(pid); |
| | | public AjaxResult getByPetId(@PathParam("pid")String pid,ZfPetNote zfPetNote){ |
| | | Integer pageNum = Convert.toInt(ServletUtils.getParameter(PAGE_NUM), 1); |
| | | Integer pageSize = Convert.toInt(ServletUtils.getParameter(PAGE_SIZE), 10); |
| | | return zfPetNoteService.getAllPetNoteByPetId(pageNum,pageSize,pid,zfPetNote); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 获取导入模板 |
| | | */ |
| | | @PostMapping("/model") |
| | | public void getExportModel(HttpServletResponse response){ |
| | | List<ZfPetNote> list = Collections.singletonList(new ZfPetNote()); |
| | | ExcelUtil<ZfPetNote> util = new ExcelUtil<>(ZfPetNote.class); |
| | | util.exportExcel(response,list,"魅宠备忘录导入模板"); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 导出魅宠备忘录记录列表 |
| | |
| | | util.exportExcel(response, list, "魅宠备忘录记录数据"); |
| | | } |
| | | |
| | | @Log(title = "魅宠备忘录记录", businessType = BusinessType.EXPORT) |
| | | @PostMapping("/export1/{ids}") |
| | | public void export1(HttpServletResponse response, ZfPetNote zfPetNote, @PathVariable Long[] ids) |
| | | { |
| | | List<ZfPetNote> list = zfPetNoteService.selectByIds(ids); |
| | | log.info("导出记录为:{}",list); |
| | | 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 String 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)) { |