From e5ebd02de9615e2a22694dba7e4207526054b2f8 Mon Sep 17 00:00:00 2001 From: whywhyo <1511349576@qq.com> Date: 星期二, 11 七月 2023 23:21:44 +0800 Subject: [PATCH] 123456 --- zhang-content/src/main/java/com/ruoyi/service/impl/ZSelfNoteServiceImpl.java | 114 ++++++++ zhang-content/src/main/java/com/ruoyi/service/impl/ZYearInfoServiceImpl.java | 115 ++++++++ zhang-content/src/main/java/com/ruoyi/service/ZYearInfoService.java | 11 ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZSelfNoteController.java | 113 +++++++ zhang-content/src/main/java/com/ruoyi/service/ZSelfNoteService.java | 11 zhang-content/src/main/java/com/ruoyi/domain/ZYearInfo.java | 114 ++----- ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZYearInfoController.java | 113 +++++++ zhang-content/src/main/java/com/ruoyi/domain/ZYearHealth.java | 103 ------- zhang-content/src/main/java/com/ruoyi/domain/ZSelfNote.java | 95 ++---- zhang-content/src/main/java/com/ruoyi/domain/ZSecret.java | 2 10 files changed, 546 insertions(+), 245 deletions(-) diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZSelfNoteController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZSelfNoteController.java index c62d659..aa5e2a4 100644 --- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZSelfNoteController.java +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZSelfNoteController.java @@ -1,9 +1,27 @@ package com.ruoyi.web.controller.zhang; -import org.springframework.web.bind.annotation.RequestMapping; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.core.text.Convert; +import com.ruoyi.common.enums.BusinessType; +import com.ruoyi.common.utils.ServletUtils; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.domain.ZSelfNote; +import com.ruoyi.service.ZSelfNoteService; +import lombok.extern.slf4j.Slf4j; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.*; +import org.springframework.web.multipart.MultipartFile; -import org.springframework.web.bind.annotation.RestController; +import javax.servlet.http.HttpServletResponse; +import java.util.Arrays; +import java.util.Collections; +import java.util.List; + +import static com.ruoyi.common.core.page.TableSupport.PAGE_NUM; +import static com.ruoyi.common.core.page.TableSupport.PAGE_SIZE; /** * <p> @@ -15,7 +33,96 @@ */ @RestController @RequestMapping("/zSelfNote") -public class ZSelfNoteController { +@Slf4j +public class ZSelfNoteController extends BaseController { + @Autowired + private ZSelfNoteService zSelfNoteService; + + /** + * 鏌ヨ鎵�鏈夎褰� + */ + @GetMapping("/all") + public AjaxResult listAll(ZSelfNote zSelfNote){ + Integer pageNum = Convert.toInt(ServletUtils.getParameter(PAGE_NUM), 1); + Integer pageSize = Convert.toInt(ServletUtils.getParameter(PAGE_SIZE), 10); + return zSelfNoteService.selectDataList(zSelfNote,pageNum,pageSize); + } + + /** + * 鏍规嵁id鏌ヨ + */ + @GetMapping() + public AjaxResult listById(Long id){ + return AjaxResult.success(zSelfNoteService.getById(id)); + } + + /** + * 妯℃澘 + */ + @GetMapping("/model") + public void getModel(HttpServletResponse response){ + ZSelfNote zSelfNote = new ZSelfNote(); + List<ZSelfNote> emptyList = Collections.singletonList(zSelfNote); + ExcelUtil<ZSelfNote> util = new ExcelUtil<>(ZSelfNote.class); + util.exportExcel(response, emptyList, "涓汉璁颁簨鏈褰曟暟鎹�"); + } + + /** + * 瀵煎嚭涓汉璁颁簨鏈褰曞垪琛� + */ +// @PreAuthorize("@ss.hasPermi('system:property:export')") + @Log(title = "涓汉璁颁簨鏈褰�", businessType = BusinessType.EXPORT) + @PostMapping("/export/{ids}") + public void export(HttpServletResponse response,@PathVariable Long[] ids) + { + List<ZSelfNote> list = zSelfNoteService.selectByIds(ids); + log.info("瀵煎嚭璁板綍涓�:{}",list); + ExcelUtil<ZSelfNote> util = new ExcelUtil<>(ZSelfNote.class); + util.exportExcel(response, list, "涓汉璁颁簨鏈褰曟暟鎹�"); + } + + /** + * 瀵煎叆涓汉璁颁簨鏈褰曞垪琛� + */ + @Log(title = "鐢ㄦ埛绠$悊", businessType = BusinessType.IMPORT) + @PostMapping("/importData") + public AjaxResult importData(@RequestParam("excelImport") MultipartFile file) throws Exception + { + return zSelfNoteService.importExcel(file); + } + + /** + * 鏂板涓汉璁颁簨鏈褰� + */ +// @PreAuthorize("@ss.hasPermi('system:property:add')") + @Log(title = "涓汉璁颁簨鏈褰�", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody ZSelfNote zSelfNote) + { + return zSelfNoteService.mySave(zSelfNote); + } + + /** + * 淇敼涓汉璁颁簨鏈褰� + */ +// @PreAuthorize("@ss.hasPermi('system:property:edit')") + @Log(title = "涓汉璁颁簨鏈褰�", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody ZSelfNote zSelfNote) + { + return toAjax(zSelfNoteService.updateById(zSelfNote)); + } +// + /** + * 鎵归噺鍒犻櫎涓汉璁颁簨鏈褰� + */ +// @PreAuthorize("@ss.hasPermi('system:property:remove')") + @Log(title = "涓汉璁颁簨鏈褰�", businessType = BusinessType.DELETE) + @DeleteMapping("/{ids}") + public AjaxResult remove(@PathVariable Long[] ids) + { + return toAjax(zSelfNoteService.removeByIds(Arrays.asList(ids))); + } } diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZYearInfoController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZYearInfoController.java index 84a6307..2d2fe22 100644 --- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZYearInfoController.java +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZYearInfoController.java @@ -1,9 +1,27 @@ package com.ruoyi.web.controller.zhang; -import org.springframework.web.bind.annotation.RequestMapping; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.core.text.Convert; +import com.ruoyi.common.enums.BusinessType; +import com.ruoyi.common.utils.ServletUtils; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.domain.ZYearInfo; +import com.ruoyi.service.ZYearInfoService; +import lombok.extern.slf4j.Slf4j; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.*; +import org.springframework.web.multipart.MultipartFile; -import org.springframework.web.bind.annotation.RestController; +import javax.servlet.http.HttpServletResponse; +import java.util.Arrays; +import java.util.Collections; +import java.util.List; + +import static com.ruoyi.common.core.page.TableSupport.PAGE_NUM; +import static com.ruoyi.common.core.page.TableSupport.PAGE_SIZE; /** * <p> @@ -15,7 +33,96 @@ */ @RestController @RequestMapping("/zYearInfo") -public class ZYearInfoController { +@Slf4j +public class ZYearInfoController extends BaseController { + @Autowired + private ZYearInfoService zYearInfoService; + + /** + * 鏌ヨ鎵�鏈夎褰� + */ + @GetMapping("/all") + public AjaxResult listAll(ZYearInfo zYearInfo){ + Integer pageNum = Convert.toInt(ServletUtils.getParameter(PAGE_NUM), 1); + Integer pageSize = Convert.toInt(ServletUtils.getParameter(PAGE_SIZE), 10); + return zYearInfoService.selectDataList(zYearInfo,pageNum,pageSize); + } + + /** + * 鏍规嵁id鏌ヨ + */ + @GetMapping() + public AjaxResult listById(Long id){ + return AjaxResult.success(zYearInfoService.getById(id)); + } + + /** + * 妯℃澘 + */ + @GetMapping("/model") + public void getModel(HttpServletResponse response){ + ZYearInfo zYearInfo = new ZYearInfo(); + List<ZYearInfo> emptyList = Collections.singletonList(zYearInfo); + ExcelUtil<ZYearInfo> util = new ExcelUtil<>(ZYearInfo.class); + util.exportExcel(response, emptyList, "骞村害鍋ュ悍璁板綍鏁版嵁"); + } + + /** + * 瀵煎嚭骞村害鍋ュ悍璁板綍鍒楄〃 + */ +// @PreAuthorize("@ss.hasPermi('system:property:export')") + @Log(title = "骞村害鍋ュ悍璁板綍", businessType = BusinessType.EXPORT) + @PostMapping("/export/{ids}") + public void export(HttpServletResponse response,@PathVariable Long[] ids) + { + List<ZYearInfo> list = zYearInfoService.selectByIds(ids); + log.info("瀵煎嚭璁板綍涓�:{}",list); + ExcelUtil<ZYearInfo> util = new ExcelUtil<>(ZYearInfo.class); + util.exportExcel(response, list, "骞村害鍋ュ悍璁板綍鏁版嵁"); + } + + /** + * 瀵煎叆骞村害鍋ュ悍璁板綍鍒楄〃 + */ + @Log(title = "鐢ㄦ埛绠$悊", businessType = BusinessType.IMPORT) + @PostMapping("/importData") + public AjaxResult importData(@RequestParam("excelImport") MultipartFile file) throws Exception + { + return zYearInfoService.importExcel(file); + } + + /** + * 鏂板骞村害鍋ュ悍璁板綍 + */ +// @PreAuthorize("@ss.hasPermi('system:property:add')") + @Log(title = "骞村害鍋ュ悍璁板綍", businessType = BusinessType.INSERT) + @PostMapping + public AjaxResult add(@RequestBody ZYearInfo zYearInfo) + { + return zYearInfoService.mySave(zYearInfo); + } + + /** + * 淇敼骞村害鍋ュ悍璁板綍 + */ +// @PreAuthorize("@ss.hasPermi('system:property:edit')") + @Log(title = "骞村害鍋ュ悍璁板綍", businessType = BusinessType.UPDATE) + @PutMapping + public AjaxResult edit(@RequestBody ZYearInfo zYearInfo) + { + return toAjax(zYearInfoService.updateById(zYearInfo)); + } +// + /** + * 鎵归噺鍒犻櫎骞村害鍋ュ悍璁板綍 + */ +// @PreAuthorize("@ss.hasPermi('system:property:remove')") + @Log(title = "骞村害鍋ュ悍璁板綍", businessType = BusinessType.DELETE) + @DeleteMapping("/{ids}") + public AjaxResult remove(@PathVariable Long[] ids) + { + return toAjax(zYearInfoService.removeByIds(Arrays.asList(ids))); + } } diff --git a/zhang-content/src/main/java/com/ruoyi/domain/ZSecret.java b/zhang-content/src/main/java/com/ruoyi/domain/ZSecret.java index 8bb6aba..adadbe6 100644 --- a/zhang-content/src/main/java/com/ruoyi/domain/ZSecret.java +++ b/zhang-content/src/main/java/com/ruoyi/domain/ZSecret.java @@ -113,4 +113,6 @@ @TableField(exist = false) @JsonFormat(pattern = "yyyy-MM-dd") private Date happenEndTime; + + } diff --git a/zhang-content/src/main/java/com/ruoyi/domain/ZSelfNote.java b/zhang-content/src/main/java/com/ruoyi/domain/ZSelfNote.java index a072ff2..ecef979 100644 --- a/zhang-content/src/main/java/com/ruoyi/domain/ZSelfNote.java +++ b/zhang-content/src/main/java/com/ruoyi/domain/ZSelfNote.java @@ -1,10 +1,16 @@ package com.ruoyi.domain; import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; +import com.fasterxml.jackson.annotation.JsonFormat; +import com.ruoyi.common.annotation.Excel; +import lombok.Data; + import java.io.Serializable; import java.time.LocalDateTime; +import java.util.Date; /** * <p> @@ -15,27 +21,23 @@ * @since 2023-03-14 */ @TableName("z_self_note") +@Data public class ZSelfNote implements Serializable { private static final long serialVersionUID = 1L; @TableId(value = "id", type = IdType.AUTO) - private Integer id; + private Long id; /** * 鐢ㄦ埛id */ - private Integer userId; + private Long uid; /** * 鍦扮偣 */ private String address; - - /** - * 鏃堕棿 - */ - private LocalDateTime noteDate; /** * 鏍囬 @@ -47,64 +49,35 @@ */ private String remark; + /** + * 浜虹墿 + */ + private String people; - public Integer getId() { - return id; - } + /** + * 鍒涘缓鏃堕棿 + */ + @JsonFormat(pattern = "yyyy-MM-dd") + private Date createTime; - public void setId(Integer id) { - this.id = id; - } + /** + * 鍙戠敓鏃堕棿 + */ + @Excel(name = "鍙戠敓鏃堕棿",dateFormat = "yyyy-MM-dd") + @JsonFormat(pattern = "yyyy-MM-dd") + private Date happenTime; - public Integer getUserId() { - return userId; - } + /** + * 鐢靛瓙鏂囦欢璺緞 + */ + private String url; - public void setUserId(Integer userId) { - this.userId = userId; - } + @TableField(exist = false) + @JsonFormat(pattern = "yyyy-MM-dd") + private Date happenStartTime; - public String getAddress() { - return address; - } + @TableField(exist = false) + @JsonFormat(pattern = "yyyy-MM-dd") + private Date happenEndTime; - public void setAddress(String address) { - this.address = address; - } - - public LocalDateTime getNoteDate() { - return noteDate; - } - - public void setNoteDate(LocalDateTime noteDate) { - this.noteDate = noteDate; - } - - public String getTitle() { - return title; - } - - public void setTitle(String title) { - this.title = title; - } - - public String getRemark() { - return remark; - } - - public void setRemark(String remark) { - this.remark = remark; - } - - @Override - public String toString() { - return "ZSelfNote{" + - "id=" + id + - ", userId=" + userId + - ", address=" + address + - ", noteDate=" + noteDate + - ", title=" + title + - ", remark=" + remark + - "}"; - } } diff --git a/zhang-content/src/main/java/com/ruoyi/domain/ZYearHealth.java b/zhang-content/src/main/java/com/ruoyi/domain/ZYearHealth.java index 9f0069b..662190a 100644 --- a/zhang-content/src/main/java/com/ruoyi/domain/ZYearHealth.java +++ b/zhang-content/src/main/java/com/ruoyi/domain/ZYearHealth.java @@ -3,6 +3,8 @@ import com.baomidou.mybatisplus.annotation.IdType; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; +import lombok.Data; + import java.io.Serializable; /** @@ -14,17 +16,18 @@ * @since 2023-03-14 */ @TableName("z_year_health") +@Data public class ZYearHealth implements Serializable { private static final long serialVersionUID = 1L; @TableId(value = "id", type = IdType.AUTO) - private Integer id; + private Long id; /** * 骞村害鍋ュ悍琛ㄦ寔鏈夎�卛d */ - private Integer uid; + private Long uid; /** * 鐢熸椿涔犳儻 @@ -66,100 +69,4 @@ */ private String diseaseOutcome; - - public Integer getId() { - return id; - } - - public void setId(Integer id) { - this.id = id; - } - - public Integer getUid() { - return uid; - } - - public void setUid(Integer uid) { - this.uid = uid; - } - - public String getLifeHabit() { - return lifeHabit; - } - - public void setLifeHabit(String lifeHabit) { - this.lifeHabit = lifeHabit; - } - - public String getTreatment() { - return treatment; - } - - public void setTreatment(String treatment) { - this.treatment = treatment; - } - - public String getFamilyDisease() { - return familyDisease; - } - - public void setFamilyDisease(String familyDisease) { - this.familyDisease = familyDisease; - } - - public String getNowDisease() { - return nowDisease; - } - - public void setNowDisease(String nowDisease) { - this.nowDisease = nowDisease; - } - - public String getDiseaseHappen() { - return diseaseHappen; - } - - public void setDiseaseHappen(String diseaseHappen) { - this.diseaseHappen = diseaseHappen; - } - - public String getDiseaseDevelop() { - return diseaseDevelop; - } - - public void setDiseaseDevelop(String diseaseDevelop) { - this.diseaseDevelop = diseaseDevelop; - } - - public String getDiseaseTreat() { - return diseaseTreat; - } - - public void setDiseaseTreat(String diseaseTreat) { - this.diseaseTreat = diseaseTreat; - } - - public String getDiseaseOutcome() { - return diseaseOutcome; - } - - public void setDiseaseOutcome(String diseaseOutcome) { - this.diseaseOutcome = diseaseOutcome; - } - - @Override - public String toString() { - return "ZYearHealth{" + - "id=" + id + - ", uid=" + uid + - ", lifeHabit=" + lifeHabit + - ", treatment=" + treatment + - ", familyDisease=" + familyDisease + - ", nowDisease=" + nowDisease + - ", diseaseHappen=" + diseaseHappen + - ", diseaseDevelop=" + diseaseDevelop + - ", diseaseTreat=" + diseaseTreat + - ", diseaseOutcome=" + diseaseOutcome + - "}"; - } } diff --git a/zhang-content/src/main/java/com/ruoyi/domain/ZYearInfo.java b/zhang-content/src/main/java/com/ruoyi/domain/ZYearInfo.java index 38ea31a..b77691f 100644 --- a/zhang-content/src/main/java/com/ruoyi/domain/ZYearInfo.java +++ b/zhang-content/src/main/java/com/ruoyi/domain/ZYearInfo.java @@ -1,10 +1,17 @@ package com.ruoyi.domain; import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableField; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; +import com.fasterxml.jackson.annotation.JsonFormat; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; +import lombok.Data; + import java.io.Serializable; import java.time.LocalDateTime; +import java.util.Date; /** * <p> @@ -15,124 +22,71 @@ * @since 2023-03-14 */ @TableName("z_year_info") +@Data public class ZYearInfo implements Serializable { private static final long serialVersionUID = 1L; @TableId(value = "id", type = IdType.AUTO) - private Integer id; + private Long id; /** * 骞村害鍋ュ悍琛╥d */ - private Integer hid; + private Long uid; /** * 浣撴鏃堕棿 */ - private LocalDateTime checkTime; + @JsonFormat(pattern = "yyyy-MM-dd") + @Excel(name = "浣撴鏃堕棿") + private Date checkTime; + + @TableField(exist = false) + @JsonFormat(pattern = "yyyy-MM-dd") + private Date happenStartTime; + + @TableField(exist = false) + @JsonFormat(pattern = "yyyy-MM-dd") + private Date happenEndTime; /** - * 鐪嬬梾锛�0銆佷綋妫�锛�1 + * 绫诲瀷 */ - private Integer type; + @Excel(name = "绫诲瀷") + private String type; /** * 灏辫瘖鍖婚櫌 */ + @Excel(name = "灏辫瘖鍖婚櫌") private String hospital; /** * 棰樺悕 */ + @Excel(name = "棰樺悕") private String title; /** * 娉ㄦ剰浜嬮」 */ + @Excel(name = "娉ㄦ剰浜嬮」") private String notice; /** * 澶囨敞 */ + @Excel(name = "澶囨敞") private String remark; + /** + * 鍒涘缓鏃堕棿 + */ + @JsonFormat(pattern = "yyyy-MM-dd") + private Date createTime; - public Integer getId() { - return id; - } + private String url; - public void setId(Integer id) { - this.id = id; - } - public Integer getHid() { - return hid; - } - - public void setHid(Integer hid) { - this.hid = hid; - } - - public LocalDateTime getCheckTime() { - return checkTime; - } - - public void setCheckTime(LocalDateTime checkTime) { - this.checkTime = checkTime; - } - - public Integer getType() { - return type; - } - - public void setType(Integer type) { - this.type = type; - } - - public String getHospital() { - return hospital; - } - - public void setHospital(String hospital) { - this.hospital = hospital; - } - - public String getTitle() { - return title; - } - - public void setTitle(String title) { - this.title = title; - } - - public String getNotice() { - return notice; - } - - public void setNotice(String notice) { - this.notice = notice; - } - - public String getRemark() { - return remark; - } - - public void setRemark(String remark) { - this.remark = remark; - } - - @Override - public String toString() { - return "ZYearInfo{" + - "id=" + id + - ", hid=" + hid + - ", checkTime=" + checkTime + - ", type=" + type + - ", hospital=" + hospital + - ", title=" + title + - ", notice=" + notice + - ", remark=" + remark + - "}"; - } } diff --git a/zhang-content/src/main/java/com/ruoyi/service/ZSelfNoteService.java b/zhang-content/src/main/java/com/ruoyi/service/ZSelfNoteService.java index 5c7cd8c..4a459f1 100644 --- a/zhang-content/src/main/java/com/ruoyi/service/ZSelfNoteService.java +++ b/zhang-content/src/main/java/com/ruoyi/service/ZSelfNoteService.java @@ -2,7 +2,11 @@ import com.baomidou.mybatisplus.extension.service.IService; +import com.ruoyi.common.core.domain.AjaxResult; import com.ruoyi.domain.ZSelfNote; +import org.springframework.web.multipart.MultipartFile; + +import java.util.List; /** * <p> @@ -14,4 +18,11 @@ */ public interface ZSelfNoteService extends IService<ZSelfNote> { + AjaxResult selectDataList(ZSelfNote zSelfNote, Integer pageNum, Integer pageSize); + + List<ZSelfNote> selectByIds(Long[] ids); + + AjaxResult importExcel(MultipartFile file); + + AjaxResult mySave(ZSelfNote zSelfNote); } diff --git a/zhang-content/src/main/java/com/ruoyi/service/ZYearInfoService.java b/zhang-content/src/main/java/com/ruoyi/service/ZYearInfoService.java index c167682..0f3154e 100644 --- a/zhang-content/src/main/java/com/ruoyi/service/ZYearInfoService.java +++ b/zhang-content/src/main/java/com/ruoyi/service/ZYearInfoService.java @@ -2,7 +2,12 @@ import com.baomidou.mybatisplus.extension.service.IService; +import com.ruoyi.common.core.domain.AjaxResult; import com.ruoyi.domain.ZYearInfo; +import com.ruoyi.domain.ZYearInfo; +import org.springframework.web.multipart.MultipartFile; + +import java.util.List; /** * <p> @@ -13,5 +18,11 @@ * @since 2023-03-14 */ public interface ZYearInfoService extends IService<ZYearInfo> { + AjaxResult selectDataList(ZYearInfo zYearInfo, Integer pageNum, Integer pageSize); + List<ZYearInfo> selectByIds(Long[] ids); + + AjaxResult importExcel(MultipartFile file); + + AjaxResult mySave(ZYearInfo zYearInfo); } diff --git a/zhang-content/src/main/java/com/ruoyi/service/impl/ZSelfNoteServiceImpl.java b/zhang-content/src/main/java/com/ruoyi/service/impl/ZSelfNoteServiceImpl.java index e4fce98..150b5b9 100644 --- a/zhang-content/src/main/java/com/ruoyi/service/impl/ZSelfNoteServiceImpl.java +++ b/zhang-content/src/main/java/com/ruoyi/service/impl/ZSelfNoteServiceImpl.java @@ -1,11 +1,28 @@ package com.ruoyi.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.core.domain.entity.SysUser; +import com.ruoyi.common.utils.MapUtils; +import com.ruoyi.common.utils.SecurityUtils; +import com.ruoyi.common.utils.StringUtils; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.domain.ZSelfNote; import com.ruoyi.domain.ZSelfNote; import com.ruoyi.mapper.ZSelfNoteMapper; import com.ruoyi.service.ZSelfNoteService; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Transactional; +import org.springframework.web.multipart.MultipartFile; + +import java.util.ArrayList; +import java.util.Arrays; +import java.util.HashMap; +import java.util.List; /** * <p> @@ -18,4 +35,101 @@ @Service public class ZSelfNoteServiceImpl extends ServiceImpl<ZSelfNoteMapper, ZSelfNote> implements ZSelfNoteService { + @Autowired + ZSelfNoteServiceImpl zSelfNoteService; + + private LambdaQueryWrapper<ZSelfNote> uniqueCondition(ZSelfNote zSelfNote) { + LambdaQueryWrapper<ZSelfNote> lqw = new LambdaQueryWrapper<>(); + lqw.eq(StringUtils.isNotEmpty(zSelfNote.getAddress()), ZSelfNote::getAddress, zSelfNote.getAddress()) + .eq(StringUtils.isNotEmpty(zSelfNote.getPeople()), ZSelfNote::getPeople, zSelfNote.getPeople()) + .eq(zSelfNote.getHappenTime() != null, ZSelfNote::getHappenTime, zSelfNote.getHappenTime()) + .eq(StringUtils.isNotEmpty(zSelfNote.getTitle()), ZSelfNote::getTitle, zSelfNote.getTitle()) + .eq(StringUtils.isNotEmpty(zSelfNote.getRemark()), ZSelfNote::getRemark, zSelfNote.getRemark()) + .eq(zSelfNote.getUid() != null, ZSelfNote::getUid, zSelfNote.getUid()); + return lqw; + } + + private LambdaQueryWrapper<ZSelfNote> buildCondition(ZSelfNote zSelfNote, Long userId) { + LambdaQueryWrapper<ZSelfNote> lqw = new LambdaQueryWrapper<>(); + lqw.eq(userId != null, ZSelfNote::getUid, userId) + .like(StringUtils.isNotEmpty(zSelfNote.getPeople()), ZSelfNote::getPeople, zSelfNote.getPeople()) + .like(StringUtils.isNotEmpty(zSelfNote.getTitle()), ZSelfNote::getTitle, zSelfNote.getTitle()) + .between(zSelfNote.getHappenStartTime() != null && zSelfNote.getHappenEndTime() != null, ZSelfNote::getHappenTime, zSelfNote.getHappenStartTime(), zSelfNote.getHappenEndTime()) + .orderByDesc(ZSelfNote::getCreateTime); + return lqw; + } + + /** + * 鍒嗛〉鏌ユ壘 + */ + @Override + public AjaxResult selectDataList(ZSelfNote zSelfNote, Integer pageNum, Integer pageSize) { + SysUser user = SecurityUtils.getLoginUser().getUser(); + Long userId = user.getUserId(); + LambdaQueryWrapper<ZSelfNote> lqw = buildCondition(zSelfNote, userId); + + Page<ZSelfNote> pageBean = new Page<>(pageNum, pageSize); + Page<ZSelfNote> pageResult = page(pageBean, lqw); + + List<ZSelfNote> beanRecords = pageResult.getRecords();//寰楀埌鏌ヨ鍑烘潵鐨勬暟鎹� + + HashMap<String, Object> data = MapUtils.getResult(pageResult, beanRecords); + return AjaxResult.success(data); + + } + + + @Override + public List<ZSelfNote> selectByIds(Long[] ids) { + List<ZSelfNote> list = new ArrayList<>(); + if (ids.length != 0) + list = listByIds(Arrays.asList(ids)); + else + list = list(); + return list; + } + + @Override + public AjaxResult mySave(ZSelfNote zSelfNote) { + SysUser user = SecurityUtils.getLoginUser().getUser(); + Long userId = user.getUserId(); + zSelfNote.setUid(userId); + + //妫�鏌ユ槸鍚︽湁閲嶅鏁版嵁鎻掑叆 + LambdaQueryWrapper<ZSelfNote> lqw = uniqueCondition(zSelfNote); + List<ZSelfNote> list = list(lqw); + if (list.size() > 0) { + throw new RuntimeException("璇峰嬁鏂板閲嶅鏁版嵁"); + } + + if (save(zSelfNote)) { + return AjaxResult.success(); + } else { + return AjaxResult.error(); + } + + } + + @Override + @Transactional + public AjaxResult importExcel(MultipartFile file) { + + ExcelUtil<ZSelfNote> util = new ExcelUtil<>(ZSelfNote.class); + List<ZSelfNote> dataList = null; + try { + dataList = util.importExcel(file.getInputStream()); + } catch (Exception e) { + throw new RuntimeException("娌℃湁鎸夌収瑙勫垯瀵煎叆鏁版嵁"); + } + + assert dataList != null; + + for (ZSelfNote zSelfNote : dataList) { + zSelfNoteService.mySave(zSelfNote); + } + + return AjaxResult.success(); + + } + } diff --git a/zhang-content/src/main/java/com/ruoyi/service/impl/ZYearInfoServiceImpl.java b/zhang-content/src/main/java/com/ruoyi/service/impl/ZYearInfoServiceImpl.java index 7b7fcd3..e924156 100644 --- a/zhang-content/src/main/java/com/ruoyi/service/impl/ZYearInfoServiceImpl.java +++ b/zhang-content/src/main/java/com/ruoyi/service/impl/ZYearInfoServiceImpl.java @@ -1,11 +1,28 @@ package com.ruoyi.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.core.domain.entity.SysUser; +import com.ruoyi.common.utils.MapUtils; +import com.ruoyi.common.utils.SecurityUtils; +import com.ruoyi.common.utils.StringUtils; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.domain.ZYearInfo; import com.ruoyi.domain.ZYearInfo; import com.ruoyi.mapper.ZYearInfoMapper; import com.ruoyi.service.ZYearInfoService; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Transactional; +import org.springframework.web.multipart.MultipartFile; + +import java.util.ArrayList; +import java.util.Arrays; +import java.util.HashMap; +import java.util.List; /** * <p> @@ -18,4 +35,102 @@ @Service public class ZYearInfoServiceImpl extends ServiceImpl<ZYearInfoMapper, ZYearInfo> implements ZYearInfoService { + @Autowired + ZYearInfoServiceImpl zYearInfoService; + + private LambdaQueryWrapper<ZYearInfo> uniqueCondition(ZYearInfo zYearInfo) { + LambdaQueryWrapper<ZYearInfo> lqw = new LambdaQueryWrapper<>(); + lqw.eq(StringUtils.isNotEmpty(zYearInfo.getType()), ZYearInfo::getType, zYearInfo.getType()) + .eq(StringUtils.isNotEmpty(zYearInfo.getHospital()), ZYearInfo::getHospital, zYearInfo.getHospital()) + .eq(StringUtils.isNotEmpty(zYearInfo.getTitle()), ZYearInfo::getTitle, zYearInfo.getTitle()) + .eq(zYearInfo.getCheckTime() != null, ZYearInfo::getCheckTime, zYearInfo.getCheckTime()) + .eq(StringUtils.isNotEmpty(zYearInfo.getNotice()), ZYearInfo::getNotice, zYearInfo.getNotice()) + .eq(StringUtils.isNotEmpty(zYearInfo.getRemark()), ZYearInfo::getRemark, zYearInfo.getRemark()) + .eq(zYearInfo.getUid() != null, ZYearInfo::getUid, zYearInfo.getUid()); + return lqw; + } + + private LambdaQueryWrapper<ZYearInfo> buildCondition(ZYearInfo zYearInfo, Long userId) { + LambdaQueryWrapper<ZYearInfo> lqw = new LambdaQueryWrapper<>(); + lqw.eq(userId != null, ZYearInfo::getUid, userId) + .like(StringUtils.isNotEmpty(zYearInfo.getType()), ZYearInfo::getType, zYearInfo.getType()) + .like(StringUtils.isNotEmpty(zYearInfo.getHospital()), ZYearInfo::getHospital, zYearInfo.getHospital()) + .like(StringUtils.isNotEmpty(zYearInfo.getTitle()), ZYearInfo::getTitle, zYearInfo.getTitle()) + .between(zYearInfo.getHappenStartTime() != null && zYearInfo.getHappenEndTime() != null, ZYearInfo::getCheckTime, zYearInfo.getHappenStartTime(), zYearInfo.getHappenEndTime()) + .orderByDesc(ZYearInfo::getCreateTime); + return lqw; + } + + /** + * 鍒嗛〉鏌ユ壘 + */ + @Override + public AjaxResult selectDataList(ZYearInfo zYearInfo, Integer pageNum, Integer pageSize) { + SysUser user = SecurityUtils.getLoginUser().getUser(); + Long userId = user.getUserId(); + LambdaQueryWrapper<ZYearInfo> lqw = buildCondition(zYearInfo, userId); + + Page<ZYearInfo> pageBean = new Page<>(pageNum, pageSize); + Page<ZYearInfo> pageResult = page(pageBean, lqw); + + List<ZYearInfo> beanRecords = pageResult.getRecords();//寰楀埌鏌ヨ鍑烘潵鐨勬暟鎹� + + HashMap<String, Object> data = MapUtils.getResult(pageResult, beanRecords); + return AjaxResult.success(data); + + } + + + @Override + public List<ZYearInfo> selectByIds(Long[] ids) { + List<ZYearInfo> list = new ArrayList<>(); + if (ids.length != 0) + list = listByIds(Arrays.asList(ids)); + else + list = list(); + return list; + } + + @Override + public AjaxResult mySave(ZYearInfo zYearInfo) { + SysUser user = SecurityUtils.getLoginUser().getUser(); + Long userId = user.getUserId(); + zYearInfo.setUid(userId); + + //妫�鏌ユ槸鍚︽湁閲嶅鏁版嵁鎻掑叆 + LambdaQueryWrapper<ZYearInfo> lqw = uniqueCondition(zYearInfo); + List<ZYearInfo> list = list(lqw); + if (list.size() > 0) { + throw new RuntimeException("璇峰嬁鏂板閲嶅鏁版嵁"); + } + + if (save(zYearInfo)) { + return AjaxResult.success(); + } else { + return AjaxResult.error(); + } + + } + + @Override + @Transactional + public AjaxResult importExcel(MultipartFile file) { + + ExcelUtil<ZYearInfo> util = new ExcelUtil<>(ZYearInfo.class); + List<ZYearInfo> dataList = null; + try { + dataList = util.importExcel(file.getInputStream()); + } catch (Exception e) { + throw new RuntimeException("娌℃湁鎸夌収瑙勫垯瀵煎叆鏁版嵁"); + } + + assert dataList != null; + + for (ZYearInfo zYearInfo : dataList) { + zYearInfoService.mySave(zYearInfo); + } + + return AjaxResult.success(); + + } } -- Gitblit v1.9.1