server/dmvisit_service/src/main/java/com/doumee/dao/admin/request/LaborEmpowerDTO.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,55 @@ package com.doumee.dao.admin.request; import com.doumee.core.annotation.excel.ExcelColumn; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import org.springframework.web.multipart.MultipartFile; import java.util.Date; import java.util.List; /** * @author T14 */ @Data @ApiModel("é¨ç¦ææææ¹éå¤ç") public class LaborEmpowerDTO { @ApiModelProperty(value = "æä»¶") private MultipartFile file; @ApiModelProperty(value = "å¼å§æ¶é´") private Date startTime; @ApiModelProperty(value = "ç»ææ¶é´") private Date endTime; @ApiModelProperty(value = "ä¸åæ¹å¼") private Integer sendType; @ApiModelProperty(value = "é¨ç¦è§è²") private String deviceRole; @ApiModelProperty(value = "é¨ç¦id") private List<String> deviceIds; @Data @ApiModel("å³å¡äººåä¿¡æ¯") public static class LaborMemberEmpower{ @ApiModelProperty(value = "å§å") @ExcelColumn(name="å§å") private String name; @ApiModelProperty(value = "ææºå·") @ExcelColumn(name="ææºå·") private String phone; @ApiModelProperty(value = "身份è¯å·") @ExcelColumn(name="身份è¯å·") private String idcardNo; } } server/dmvisit_service/src/main/java/com/doumee/service/business/MemberService.java
@@ -3,6 +3,7 @@ import com.baomidou.mybatisplus.core.conditions.Wrapper; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.dao.admin.request.LaborEmpowerDTO; import com.doumee.dao.admin.request.LaborMemberDTO; import com.doumee.dao.admin.response.MemberInfoDTO; import com.doumee.dao.business.model.Member; @@ -123,4 +124,12 @@ * @return long */ long count(Member member); /** * å¯¼å ¥å³å¡äººåé¨ç¦ä¿¡æ¯ * @param laborEmpowerDTO * @return */ void importMemberBatch(LaborEmpowerDTO laborEmpowerDTO); } server/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java
@@ -3,7 +3,8 @@ import cn.hutool.core.date.DateTime; import cn.hutool.core.date.DateUtil; import cn.hutool.core.util.IdcardUtil; import com.baomidou.mybatisplus.core.conditions.Wrapper; import cn.hutool.core.util.PhoneUtil; import com.doumee.core.annotation.excel.ExcelImporter; import com.doumee.core.constants.ResponseStatus; import com.doumee.core.exception.BusinessException; import com.doumee.core.model.LoginUserInfo; @@ -11,6 +12,7 @@ import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Constants; import com.doumee.core.utils.Utils; import com.doumee.dao.admin.request.LaborEmpowerDTO; import com.doumee.dao.admin.request.LaborMemberDTO; import com.doumee.dao.admin.response.MemberInfoDTO; import com.doumee.dao.business.MemberMapper; @@ -26,13 +28,12 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.github.yulichang.wrapper.MPJLambdaWrapper; import org.apache.commons.collections.CollectionUtils; import org.apache.commons.lang3.StringUtils; import org.apache.shiro.SecurityUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; import java.util.Date; import java.util.List; import java.util.Objects; @@ -66,6 +67,9 @@ LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); if (PhoneUtil.isPhone(member.getPhone())){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"çµè¯å·ç æ ¼å¼æè¯¯"); } if (IdcardUtil.isValidCard(member.getIdcardNo())){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"身份è¯å·æ ¼å¼æè¯¯"); } @@ -349,4 +353,22 @@ QueryWrapper<Member> wrapper = new QueryWrapper<>(member); return memberMapper.selectCount(wrapper); } @Override public void importMemberBatch(LaborEmpowerDTO laborEmpowerDTO) { try { ExcelImporter ie = new ExcelImporter(laborEmpowerDTO.getFile(),0,0); List<LaborEmpowerDTO.LaborMemberEmpower> dataList = ie.getDataList(LaborEmpowerDTO.LaborMemberEmpower.class,null); if (CollectionUtils.isEmpty(dataList)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"æä»¶æ æ°æ®è®°å½"); } } catch (Exception e) { } // } }