From 45271bc891546c395acd312b95524b98ae8d9c31 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期五, 01 十一月 2024 14:05:52 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/MemberCloudController.java | 20 ++++++++++ server/visits/dmvisit_admin/src/main/java/com/doumee/api/business/CompanyController.java | 2 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java | 3 + server/visits/dmvisit_admin/src/main/resources/bootstrap.yml | 2 server/system_gateway/src/main/resources/bootstrap.yml | 2 admin/public/template/member.xlsx | 0 admin/src/components/business/OperaHiddenDangerParamWindow.vue | 1 server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/CompanyCloudController.java | 11 ++--- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java | 2 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/ApproveServiceImpl.java | 5 ++ server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/HiddenDangerCloudController.java | 5 ++ server/system_service/src/main/java/com/doumee/dao/business/model/Company.java | 3 + server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java | 12 +++++ server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/HiddenDanger.java | 16 ++++---- 14 files changed, 63 insertions(+), 21 deletions(-) diff --git a/admin/public/template/member.xlsx b/admin/public/template/member.xlsx index 05a836d..41dbeac 100644 --- a/admin/public/template/member.xlsx +++ b/admin/public/template/member.xlsx Binary files differ diff --git a/admin/src/components/business/OperaHiddenDangerParamWindow.vue b/admin/src/components/business/OperaHiddenDangerParamWindow.vue index ca72dcc..9d051dc 100644 --- a/admin/src/components/business/OperaHiddenDangerParamWindow.vue +++ b/admin/src/components/business/OperaHiddenDangerParamWindow.vue @@ -104,6 +104,7 @@ }) }, loadMember() { + this.$set(this.form, 'memberIdList', []) allList({ type: 2, companyType: 1, diff --git a/server/system_gateway/src/main/resources/bootstrap.yml b/server/system_gateway/src/main/resources/bootstrap.yml index 099da4a..8ecd0a5 100644 --- a/server/system_gateway/src/main/resources/bootstrap.yml +++ b/server/system_gateway/src/main/resources/bootstrap.yml @@ -1,6 +1,6 @@ spring: profiles: - active: pro + active: dev application: name: system_gateway # 瀹夊叏閰嶇疆 diff --git a/server/system_service/src/main/java/com/doumee/dao/business/model/Company.java b/server/system_service/src/main/java/com/doumee/dao/business/model/Company.java index ddaf90a..03ae864 100644 --- a/server/system_service/src/main/java/com/doumee/dao/business/model/Company.java +++ b/server/system_service/src/main/java/com/doumee/dao/business/model/Company.java @@ -196,4 +196,7 @@ @ApiModelProperty(value = "erp閮ㄩ棬绾у埆璺緞", example = "1") @ExcelColumn(name="erp閮ㄩ棬绾у埆璺緞") private String erpCompanyPath; + @ApiModelProperty(value = "鍙煡璇㈤殣鎮i厤缃儴闂細0=鍚︼紱1=鏄�", example = "1") + @TableField(exist = false) + private Integer queryHiddenDanger; } diff --git a/server/visits/dmvisit_admin/src/main/java/com/doumee/api/business/CompanyController.java b/server/visits/dmvisit_admin/src/main/java/com/doumee/api/business/CompanyController.java index b65d924..beec7ca 100644 --- a/server/visits/dmvisit_admin/src/main/java/com/doumee/api/business/CompanyController.java +++ b/server/visits/dmvisit_admin/src/main/java/com/doumee/api/business/CompanyController.java @@ -101,7 +101,7 @@ @ApiOperation("缁勭粐鏍戞煡璇�") @GetMapping("/tree") @ApiImplicitParams({ - @ApiImplicitParam(name = "type", dataType = "Integer", value = "绫诲瀷 0鍔冲姟鍏徃 1鍐呴儴缁勭粐", required = true), + @ApiImplicitParam(name = "type", dataType = "Integer", value = "绫诲瀷 0鍔冲姟鍏徃 1鍐呴儴缁勭粐", required = true) }) @RequiresPermissions("business:company:query") public ApiResponse<List<Company>> tree (@RequestParam Integer type) { diff --git a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/CompanyCloudController.java b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/CompanyCloudController.java index ec0beda..b5a5677 100644 --- a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/CompanyCloudController.java +++ b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/CompanyCloudController.java @@ -1,5 +1,6 @@ package com.doumee.cloud.admin; +import com.baomidou.mybatisplus.annotation.TableField; import com.doumee.api.BaseController; import com.doumee.config.DataSyncConfig; import com.doumee.config.annotation.CloudRequiredPermission; @@ -16,10 +17,7 @@ import com.doumee.service.business.ext.ERPSyncService; import com.doumee.service.business.impl.hksync.fhk.HkSyncOrgUserFromHKServiceImpl; import com.doumee.service.business.impl.hksync.fhk.HkSyncOrgUserFromSelfServiceImpl; -import io.swagger.annotations.Api; -import io.swagger.annotations.ApiImplicitParam; -import io.swagger.annotations.ApiImplicitParams; -import io.swagger.annotations.ApiOperation; +import io.swagger.annotations.*; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; @@ -115,10 +113,11 @@ @ApiOperation("缁勭粐鏍戞煡璇�") @GetMapping("/tree") @ApiImplicitParams({ - @ApiImplicitParam(name = "type", dataType = "Integer", value = "绫诲瀷 0鍔冲姟鍏徃 1鍐呴儴缁勭粐", required = true), + @ApiImplicitParam(name = "type", dataType = "Integer", value = "绫诲瀷 0鍔冲姟鍏徃 1鍐呴儴缁勭粐 2鎸囧畾缁勭粐", required = true), }) @CloudRequiredPermission("business:company:query") - public ApiResponse<List<Company>> tree (@RequestParam(required=false) Integer type,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ + public ApiResponse<List<Company>> tree (@RequestParam(required=false) Integer type, + @RequestHeader(Constants.HEADER_USER_TOKEN) String token){ return ApiResponse.success(companyService.companyTree(type)); } diff --git a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/HiddenDangerCloudController.java b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/HiddenDangerCloudController.java index f6604e0..0d47aa8 100644 --- a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/HiddenDangerCloudController.java +++ b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/HiddenDangerCloudController.java @@ -19,6 +19,7 @@ import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletResponse; +import java.util.List; import java.util.Objects; /** @@ -88,7 +89,9 @@ @CloudRequiredPermission("business:hiddendanger:exportExcel") public void exportExcel (@RequestBody PageWrap<HiddenDanger> pageWrap, HttpServletResponse response,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ pageWrap.getModel().setLoginUserInfo(this.getLoginUser(token)); - ExcelExporter.build(HiddenDanger.class).export(hiddenDangerService.findPage(pageWrap).getRecords(), "闅愭偅淇℃伅琛�", response); + List<HiddenDanger> list = hiddenDangerService.findPage(pageWrap).getRecords(); + + ExcelExporter.build(HiddenDanger.class).export(list, "闅愭偅淇℃伅琛�", response); } @ApiOperation("鏍规嵁ID鏌ヨ") diff --git a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/MemberCloudController.java b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/MemberCloudController.java index d8220d6..41e4b0b 100644 --- a/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/MemberCloudController.java +++ b/server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/MemberCloudController.java @@ -267,6 +267,26 @@ @PostMapping("/exportExcel") @CloudRequiredPermission("business:member:exportExcel") public void exportExcel (@RequestBody PageWrap<MemberQuery> pageWrap, HttpServletResponse response,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ + List<Member> memberList = new ArrayList<>(); + if(pageWrap.getModel().getType().equals(Constants.memberType.visitor)){ + memberList = memberService.findVisitPage(pageWrap).getRecords(); + }else if(pageWrap.getModel().getType().equals(Constants.memberType.internal)){ + pageWrap.getModel().setLoginUserInfo(this.getLoginUser(token)); + memberList = memberService.findMemberInfoPage(pageWrap).getRecords(); + } + if(CollectionUtils.isNotEmpty(memberList)){ + for (Member member:memberList) { + if(StringUtils.isNotBlank(member.getFaceImg())){ + member.setHavaFaceImg(Constants.ONE); + }else{ + member.setHavaFaceImg(Constants.ZERO); + } + + } + } + + ExcelExporter.build(Member.class).export(memberList, "浜哄憳淇℃伅琛�", response); + public void exportExcel (@RequestBody PageWrap<MemberQuery> pageWrap, HttpServletResponse response,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ // pageWrap.getModel().setLoginUserInfo(this.getLoginUser(token)); // return ApiResponse.success(memberService.findMemberInfoPage(pageWrap)); ExcelExporter.build(Member.class).export(memberService.findMemberInfoPage(pageWrap).getRecords(), "浜哄憳淇℃伅琛�", response); diff --git a/server/visits/dmvisit_admin/src/main/resources/bootstrap.yml b/server/visits/dmvisit_admin/src/main/resources/bootstrap.yml index 2df12af..9dc10e9 100644 --- a/server/visits/dmvisit_admin/src/main/resources/bootstrap.yml +++ b/server/visits/dmvisit_admin/src/main/resources/bootstrap.yml @@ -1,6 +1,6 @@ spring: profiles: - active: pro + active: dev application: name: visitsAdmin # 瀹夊叏閰嶇疆 diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/HiddenDanger.java b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/HiddenDanger.java index dd3c760..684f6ba 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/HiddenDanger.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/dao/business/model/HiddenDanger.java @@ -59,7 +59,7 @@ private Integer areaId; @ApiModelProperty(value = "鐘舵�� 0寰呭鐞� 1宸插鐞� 2涓嶅鐞�", example = "1") - @ExcelColumn(name="澶勭悊缁撴灉" ,valueMapping ="0=0寰呭鐞�;1=宸插鐞�;2=涓嶅鐞�;",index = 6) + @ExcelColumn(name="澶勭悊缁撴灉" ,valueMapping ="0=0寰呭鐞�;1=宸插鐞�;2=涓嶅鐞�;",index = 5) private Integer status; @ApiModelProperty(value = "鐢宠澶勭悊浜虹紪鐮�(鍏宠仈member)", example = "1") @@ -91,20 +91,20 @@ private Integer checkUserId; @ApiModelProperty(value = "鍖哄煙鍚嶇О") - @ExcelColumn(name="闅愭偅鍖哄煙",index = 2) + @ExcelColumn(name="闅愭偅鍖哄煙",index = 1) private String areaName; @ApiModelProperty(value = "鐢宠浜哄鍚�", example = "1") @TableField(exist = false) - @ExcelColumn(name="鎻愭姤浜哄鍚�",index =4) + @ExcelColumn(name="鎻愭姤浜哄鍚�",index =3) private String memberName; @ApiModelProperty(value = "鐢宠浜烘墍灞炵粍缁囧悕绉�", example = "1") @TableField(exist = false) - @ExcelColumn(name="鎵�灞炵粍缁�",index = 5) + @ExcelColumn(name="鎵�灞炵粍缁�",index = 4) private String companyName; @ApiModelProperty(value = "璐d换閮ㄩ棬鍚嶇О", example = "1") @TableField(exist = false) - @ExcelColumn(name="璐d换閮ㄩ棬鍚嶇О",index = 1) + @ExcelColumn(name="璐d换閮ㄩ棬鍚嶇О",index = 0) private String dutyCompanyName; @ApiModelProperty(value = "鐢宠浜烘墜鏈哄彿", example = "1") @TableField(exist = false) @@ -124,7 +124,7 @@ private String checkorPhone; @ApiModelProperty(value = "闅愭偅绫诲瀷鍚嶇О", example = "1") @TableField(exist = false) - @ExcelColumn(name="闅愭偅绫诲瀷",index = 3) + @ExcelColumn(name="闅愭偅绫诲瀷",index = 2) private String categoryName; @ApiModelProperty(value = "鏌ヨ寮�濮嬫椂闂达紙鍩轰簬鎻愭姤鏃堕棿锛�", example = "2024-05-20 11:48:50") @@ -145,12 +145,12 @@ @ApiModelProperty(value = "鎻愭姤鏃堕棿") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") - @ExcelColumn(name="鎻愭姤鏃堕棿",index = 6) + @ExcelColumn(name="鎻愭姤鏃堕棿",index = 6,dateFormat = "yyyy-MM-dd HH:mm:ss") private Date submitTime; @ApiModelProperty(value = "澶勭悊鏃堕棿锛堟暣鏀�/閫�鍥炰娇鐢級") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") - @ExcelColumn(name="澶勭悊鏃堕棿",index = 8) + @ExcelColumn(name="澶勭悊鏃堕棿",index = 7 ,dateFormat = "yyyy-MM-dd HH:mm:ss") private Date dealTime; @ApiModelProperty(value = "闄勪欢淇℃伅") diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/ApproveServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/ApproveServiceImpl.java index 85ed8b2..78e572f 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/ApproveServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/ApproveServiceImpl.java @@ -779,6 +779,9 @@ * @param objLevel 鏌ヨ绾у埆 */ public Company getAuditCompanyHead(Integer companyId, Integer objLevel){ + if(Objects.isNull(objLevel)||Objects.isNull(companyId)){ + throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"瀹℃壒娴侀厤缃紓甯革紝璇疯仈绯荤鐞嗗憳"); + } Company auditCompany = companyMapper.selectById(companyId); Integer queryLevel = Constants.ONE; while(queryLevel<objLevel){ @@ -1693,7 +1696,7 @@ if(approveDTO.getStatus()==Constants.TWO&&Constants.equalsInteger(approve.getDriverParam(),Constants.ONE)){ CarDriver carDriver = carDriverMapper.selectOne(new QueryWrapper<CarDriver>().lambda() .eq(CarDriver::getIsdeleted,Constants.ZERO) - .eq(CarDriver::getStatus,Constants.ZERO) +// .eq(CarDriver::getStatus,Constants.ZERO) .eq(CarDriver::getMemberId,approveDTO.getDriverId())); if(Objects.isNull(carDriver)){ throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"鏈煡璇㈠埌鍙告満淇℃伅"); diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java index f62e20f..3751492 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CarUseBookServiceImpl.java @@ -118,7 +118,7 @@ CarDriver carDriver = carDriverMapper.selectOne(new QueryWrapper<CarDriver>().lambda() .eq(CarDriver::getCarId,cars.getId()) .eq(CarDriver::getIsdeleted,Constants.ZERO) - .eq(CarDriver::getStatus,Constants.ONE) +// .eq(CarDriver::getStatus,Constants.ZERO) .last( " limit 1 ") ); if(Objects.nonNull(carDriver)&&Objects.nonNull(carDriver.getMemberId())){ diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java index e7782a0..e7aa1ca 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/CompanyServiceImpl.java @@ -449,6 +449,9 @@ queryWrapper.ge(Company::getFsDate, Utils.Date.getStart(company.getFsDate())); queryWrapper.le(Company::getFsDate, Utils.Date.getEnd(company.getFsDate())); } + if (company.getQueryHiddenDanger() != null && Constants.equalsInteger(company.getQueryHiddenDanger(),Constants.ONE)) { + queryWrapper.apply(" t.id in ( select hdp.COMPANY_ID from hidden_danger_param hdp where hdp.ISDELETED = 0 and hdp.STATUS = 0 and hdp.TYPE = 0 ) "); + } queryWrapper.orderByDesc(Company::getCreateDate); queryWrapper.leftJoin(Company.class,Company::getId,Company::getParentId); queryWrapper.select(" t.* ") @@ -678,7 +681,14 @@ queryWrapper.leftJoin(Member.class,Member::getId,Company::getHeadId); queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,Company::getEditor); queryWrapper.eq(Company::getIsdeleted,Constants.ZERO); - queryWrapper.eq(type!=null,Company::getType,type); + if(Objects.nonNull(type) && ( Constants.equalsInteger(type,Constants.ONE) || Constants.equalsInteger(type,Constants.ZERO))){ + queryWrapper.eq(type!=null,Company::getType,type); + }else if(Objects.nonNull(type) && Constants.equalsInteger(type,Constants.TWO)){ + String companySpecialId = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.SPECIAL_COMPANY_ID).getCode(); + if(StringUtils.isNotBlank(companySpecialId)){ + queryWrapper.apply(" (find_in_set('"+companySpecialId+"',REPLACE(t.company_path,'/',',')) or t.parent_id is null ) "); + } + } queryWrapper.orderByAsc(true,"t.sortnum"); List<Company> companyList = companyJoinMapper.selectJoinList(Company.class,queryWrapper); //閰嶇疆缁勫憳浜哄憳绫诲瀷鏉ユ簮鏂瑰紡 0鑷缓 1ERP diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java index 627869c..2d993e6 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java @@ -211,6 +211,9 @@ insert.setHkId(UUID.randomUUID().toString().replace("-","")); insert.setHkStatus(Constants.ONE); insert.setSex(Constants.getSexByCardNo( member.getIdcardNo()));//鏍规嵁韬唤璇佸彿鑾峰彇鎬у埆 + insert.setJobDate(member.getJobDate()); + insert.setIsDangyuan(member.getIsDangyuan()); + insert.setPositionId(member.getPositionId()); if(StringUtils.isNotBlank(member.getIdcardNo())){ insert.setBirthday( DateUtil.fromStringToDate("yyyyMMdd",IdcardUtil.getBirthByIdCard(member.getIdcardNo()))); insert.setIdcardNo(DESUtil.encrypt(Constants.EDS_PWD, member.getIdcardNo()));//韬唤璇佸彿鍔犲瘑 -- Gitblit v1.9.3