Merge branch 'master' of http://139.186.142.91:10010/r/productDev/dmvisit
| | |
| | | export function deleteById (id) { |
| | | return request.get(`/visitsAdmin/cloudService/business/platform/delete/${id}`) |
| | | } |
| | | // å é¤ |
| | | export function deletebooksById (id) { |
| | | return request.get(`/visitsAdmin/cloudService/business/platformBooks/delete/${id}`) |
| | | } |
| | | |
| | | // æ¹éå é¤ |
| | | export function deleteByIdInBatch (ids) { |
| | |
| | | // æ¥è¯¢å¯é¢çº¦é |
| | | export function checkSurplusNum (data) { |
| | | return request.post('/visitsAdmin/cloudService/business/platformBooks/checkSurplusNum', data) |
| | | } |
| | | } |
| | |
| | | import Pagination from '@/components/common/Pagination' |
| | | import QueryForm from '@/components/common/QueryForm' |
| | | import { platformBooksPage, platformReasonList, platformBooksApply, platformBooksExport } from '@/api' |
| | | import { checkSurplusNum } from '@/api/platform/platform' |
| | | import DriverDetail from "@/views/task/driverDetail" |
| | | import { checkSurplusNum, deletebooksById } from '@/api/platform/platform' |
| | | import DriverDetail from '@/views/task/driverDetail' |
| | | import GlobalWindow from '@/components/common/GlobalWindow' |
| | | import UploadAvatarImage from '@/components/common/UploadAvatarImage' |
| | | import { Message } from 'element-ui' |
| | |
| | | GlobalWindow, |
| | | UploadAvatarImage |
| | | }, |
| | | data() { |
| | | data () { |
| | | return { |
| | | isShowDriver: false, |
| | | exLoading: false, |
| | |
| | | reasonId: [{ required: true, message: 'è¯·éæ©', trigger: 'blur' }], |
| | | arriveDate: [{ required: true, message: 'è¯·éæ©', trigger: 'blur' }], |
| | | inType: [{ required: true, message: 'è¯·éæ©', trigger: 'blur' }], |
| | | driverName: [{ required: true, message: 'è¯·éæ©', trigger: 'blur' }], |
| | | driverName: [{ required: true, message: 'è¯·éæ©', trigger: 'blur' }] |
| | | }, |
| | | queryFormConfig: { |
| | | formItems: [ |
| | |
| | | { value: 1, label: '审æ¹ä¸' }, |
| | | { value: 2, label: '审æ¹éè¿' }, |
| | | { value: 3, label: '审æ¹é©³å' }, |
| | | { value: 4, label: '已忶' }, |
| | | { value: 4, label: '已忶' } |
| | | ] |
| | | }, |
| | | { |
| | |
| | | } |
| | | } |
| | | }, |
| | | created() { |
| | | created () { |
| | | this.changeRadio('0') |
| | | this.getList() |
| | | }, |
| | | methods: { |
| | | checkSurplus() { |
| | | checkSurplus () { |
| | | const { arriveDate, reasonId, totalNum } = this.param |
| | | if (!arriveDate || !reasonId || !totalNum) return |
| | | checkSurplusNum({ |
| | |
| | | } |
| | | }) |
| | | }, |
| | | changeRadio(day) { |
| | | changeRadio (day) { |
| | | const arr = [dayjs().subtract(day, 'day').format('YYYY-MM-DD') + ' 00:00:00', dayjs().format('YYYY-MM-DD') + ' 23:59:59'] |
| | | this.$set(this.filters, 'selDate', arr) |
| | | this.getList() |
| | | }, |
| | | changeForm(str) { |
| | | changeForm (str) { |
| | | if (str === 'selDate') { |
| | | this.$set(this.filters, 'fastdate', null) |
| | | this.getList() |
| | | } |
| | | }, |
| | | getList(page) { |
| | | getList (page) { |
| | | const { pagination, filters } = this |
| | | this.loading = true |
| | | platformBooksPage({ |
| | | model: { |
| | | ...filters, |
| | | arriveDateStart: filters.selDate && filters.selDate.length > 0 ? filters.selDate[0] : null, |
| | | arriveDateEnd: filters.selDate && filters.selDate.length > 0 ? filters.selDate[1] : null, |
| | | arriveDateEnd: filters.selDate && filters.selDate.length > 0 ? filters.selDate[1] : null |
| | | }, |
| | | capacity: pagination.pageSize, |
| | | page: page || pagination.page, |
| | | page: page || pagination.page |
| | | }).then(res => { |
| | | this.loading = false |
| | | this.list = res.records || [] |
| | |
| | | this.loading = false |
| | | }) |
| | | }, |
| | | handleEx() { |
| | | handleEx () { |
| | | this.$dialog.exportConfirm('确认导åºåï¼') |
| | | .then(() => { |
| | | const { filters } = this |
| | |
| | | model: { |
| | | ...filters, |
| | | arriveDateStart: filters.selDate && filters.selDate.length > 0 ? filters.selDate[0] : null, |
| | | arriveDateEnd: filters.selDate && filters.selDate.length > 0 ? filters.selDate[1] : null, |
| | | }, |
| | | arriveDateEnd: filters.selDate && filters.selDate.length > 0 ? filters.selDate[1] : null |
| | | } |
| | | }) |
| | | .then(response => { |
| | | this.download(response) |
| | |
| | | }) |
| | | }) |
| | | }, |
| | | onSubmit() { |
| | | this.$refs['ruleForm'].validate((valid) => { |
| | | onSubmit () { |
| | | this.$refs.ruleForm.validate((valid) => { |
| | | const param = this.param |
| | | param.inReason = this.reasonList.find(item => param.reasonId == item.id).reason |
| | | if (valid) { |
| | |
| | | } |
| | | }) |
| | | }, |
| | | uploadSuccess(file) { |
| | | uploadSuccess (file) { |
| | | this.$set(this.param, 'transportImg', file.imgurl) |
| | | this.$set(this.param, 'transportImgFull', file.imgurlfull) |
| | | }, |
| | | handleEdit(row) { |
| | | handleEdit (row) { |
| | | this.isShowEdit = true |
| | | this.param = { |
| | | inType: 0 |
| | | } |
| | | this.$nextTick(() => { |
| | | this.$refs['ruleForm'].clearValidate() |
| | | this.$refs.ruleForm.clearValidate() |
| | | }) |
| | | this.$set(this.param, 'arriveDate', dayjs().format('YYYY-MM-DD HH:mm:ss')) |
| | | this.getplatformReason() |
| | | }, |
| | | getplatformReason() { |
| | | getplatformReason () { |
| | | platformReasonList().then(res => { |
| | | this.reasonList = res || [] |
| | | }) |
| | | }, |
| | | handleSub() { |
| | | handleSub () { |
| | | this.$refs.ruleForm.validate((valid) => { |
| | | if (valid) { |
| | | alert('submit!') |
| | | } |
| | | }) |
| | | }, |
| | | clear() { |
| | | clear () { |
| | | this.pagination.page = 1 |
| | | this.filters = { |
| | | selDate: [], |
| | | selDate: [] |
| | | } |
| | | this.getList() |
| | | // this.changeRadio('0') |
| | | }, |
| | | handleDetail(row) { |
| | | handleDetail (row) { |
| | | this.isShowDriver = true |
| | | this.$nextTick(() => { |
| | | this.$refs.DriverDetailRef.id = row.id |
| | |
| | | this.$refs.DriverDetailRef.isShowModal = true |
| | | }) |
| | | }, |
| | | handleDel() { }, |
| | | handleSizeChange(capacity) { |
| | | handleDel (row) { |
| | | this.$confirm('ç¡®å®å é¤è¯¥è®°å½å, æ¯å¦ç»§ç»?', 'æç¤º', { |
| | | confirmButtonText: 'ç¡®å®', |
| | | cancelButtonText: 'åæ¶', |
| | | type: 'warning' |
| | | }).then(() => { |
| | | deletebooksById(row.id) |
| | | .then(res => { |
| | | this.$message.success('æä½æå') |
| | | this.page = 1 |
| | | this.getList() |
| | | }) |
| | | }).catch(() => { |
| | | }) |
| | | }, |
| | | handleSizeChange (capacity) { |
| | | this.pagination.pageSize = capacity |
| | | this.getList() |
| | | } |
| | |
| | | " ${ew.customSqlSegment} ") |
| | | List<MeetingListResponse> meetingList(@Param(Constants.WRAPPER) Wrapper wrapper); |
| | | |
| | | @Select(" select a.id , a.START_TIME , a.END_TIME , b.id as roomId, b.`NAME` as roomName , a.`NAME` as meetingName ,date_format(a.START_TIME,'%Yå¹´%mæ%dæ¥') as meetingDate ," + |
| | | @Select(" select a.id ,a.ISDELETED, a.START_TIME , a.END_TIME , b.id as roomId, b.`NAME` as roomName , a.`NAME` as meetingName ,date_format(a.START_TIME,'%Yå¹´%mæ%dæ¥') as meetingDate ," + |
| | | " CONCAT(date_format(a.START_TIME,'%H:%i') , ' ~ ',date_format(a.END_TIME,'%H:%i')) as meetingTime, c.REALNAME as bookingUserName ," + |
| | | //" CASE WHEN a.START_TIME > now() AND a.`STATUS` = 0 THEN 1 WHEN a.END_TIME < now() AND a.`STATUS` = 0 THEN 3 WHEN a.`STATUS` = 1 THEN 5 ELSE 2 END meetingStatus ," + |
| | | " CASE WHEN a.START_TIME_REAL IS NULL AND a.`STATUS` = 0 THEN 1 WHEN ( a.status = 2 ) THEN 3 WHEN a.`STATUS` = 1 THEN 5 ELSE 2 END meetingStatus ," + |
| | |
| | | " left join system_user c on a.CREATOR = c.id " + |
| | | " left join system_department_user d on c.id = d.USER_ID " + |
| | | " left JOIN system_department e on d.DEPARTMENT_ID = e.ID " + |
| | | " where a.id = #{id} ") |
| | | " where a.id = #{id} and a.isdeleted=0") |
| | | MeetingDetailResponse meetingDetail(@Param("id") Integer id); |
| | | |
| | | |
| | |
| | | "SUM( CONVERT( (UNIX_TIMESTAMP(b.END_TIME) - UNIX_TIMESTAMP(b.START_TIME))/(60*60),DECIMAL(5,1))) c\n" + |
| | | "FROM meeting_book b\n" + |
| | | "LEFT JOIN meeting_rooms r ON r.ID = b.ROOM_ID \n" + |
| | | "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2) \n" + |
| | | "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2) and b.isdeleted=0\n" + |
| | | "GROUP BY b.ROOM_ID , DATE_FORMAT(b.START_TIME,'%m')\n" + |
| | | ") t) t1 GROUP BY t1.name") |
| | | List<RoomStatisticsVo> getRoomStatistics(@Param("yearNum") Integer yearNum); |
| | |
| | | "meeting_user_rel ur\n" + |
| | | "LEFT JOIN `SYSTEM_USER` su ON ur.USER_ID = su.id \n" + |
| | | "LEFT JOIN meeting_book b ON ur.OBJ_ID = b.id \n" + |
| | | "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2)" + |
| | | "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2) and b.isdeleted=0" + |
| | | "<if test='userId != null'>"+ |
| | | "and ur.USER_ID = #{userId}\n" + |
| | | "</if>"+ |
| | |
| | | |
| | | @ApiModelProperty(value = "æåå¼å§æ¶é´") |
| | | private Date startTimeReal; |
| | | |
| | | @ApiModelProperty(value = "æ¯å¦åéåä¼äººéç¥ï¼0=éç¥ï¼1=ä¸éç¥") |
| | | private Integer joinNotice; |
| | | |
| | |
| | | |
| | | @ApiModelProperty(value = "主é®") |
| | | private Integer id; |
| | | @ApiModelProperty(value = "æ¯å¦å·²å é¤") |
| | | private Integer isdeleted; |
| | | |
| | | @ApiModelProperty(value = "ä¼è®®åç§°") |
| | | private String meetingName; |
| | |
| | | @Override |
| | | public MeetingDetailResponse getMeetingDetail(Integer id,Integer sysUserId) { |
| | | MeetingDetailResponse meetingDetailResponse = bookingsMapper.meetingDetail(id); |
| | | if (Objects.isNull(meetingDetailResponse)) { |
| | | if (Objects.isNull(meetingDetailResponse) |
| | | || Constants.equalsInteger(meetingDetailResponse.getIsdeleted(),Constants.ONE) ) { |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(), "æªæ¥è¯¢å°ä¼è®®è¯¦æ
"); |
| | | } |
| | | //é¢çº¦äºº |
| | |
| | | public Integer reservationMeeting(BookingsRequest bookingsRequest) { |
| | | Bookings bookings = new Bookings(); |
| | | BeanUtils.copyProperties(bookingsRequest, bookings); |
| | | bookings.setJoinNotice(bookingsRequest.getJoinNotice()); |
| | | if (Objects.isNull(bookingsRequest.getId())) { |
| | | this.create(bookings); |
| | | return bookings.getId(); |
| | |
| | | .replace("{ä¼è®®ä¸»é¢}",StringUtils.defaultString(bookings.getName(),"")) |
| | | .replace("{ä¼è®®å®¤åç§°}",StringUtils.defaultString(bookings.getRoomName(),"")) |
| | | .replace("{ä¼è®®æ¶é´æ®µ}",StringUtils.defaultString(timeInfo,"")) |
| | | .replace("{ä¼è®®å¤æ³¨}",StringUtils.defaultString(smsEmail.getRemark(),""))); |
| | | .replace("{ä¼è®®å¤æ³¨}",StringUtils.defaultString(bookings.getRemark(),""))); |
| | | smsEmailList.add(smsEmail); |
| | | } |
| | | } |
| | |
| | | return ApiResponse.success("æä½æå"); |
| | | } |
| | | |
| | | |
| | | @ApiOperation("éæ£æ°æ®ç»è®¡") |
| | | @PostMapping("/hiddenDangerData") |
| | | public ApiResponse hiddenDangerData (@RequestBody HiddenDanger hiddenDanger,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ |
| | | hiddenDanger.setLoginUserInfo(getLoginUser(token)); |
| | | hiddenDangerService.hiddenDangerData(hiddenDanger); |
| | | return ApiResponse.success("æä½æå"); |
| | | } |
| | | |
| | | |
| | | } |
| | |
| | | import com.doumee.config.annotation.CloudRequiredPermission; |
| | | import com.doumee.core.annotation.excel.ExcelExporter; |
| | | import com.doumee.core.annotation.pr.PreventRepeat; |
| | | import com.doumee.dao.business.vo.VisitEventCountVO; |
| | | import com.doumee.service.business.third.model.ApiResponse; |
| | | import com.doumee.service.business.third.model.PageData; |
| | | import com.doumee.service.business.third.model.PageWrap; |
| | |
| | | public ApiResponse findById(@PathVariable Integer id,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ |
| | | return ApiResponse.success(visitEventService.findById(id)); |
| | | } |
| | | @ApiOperation("æ¥è¯¢æå®ä¹é´èå´å
çç»è®¡æ°æ®ï¼äººæ¬¡å人æ°ï¼") |
| | | @PostMapping("/countNum") |
| | | @CloudRequiredPermission("business:visitevent:query") |
| | | public ApiResponse<VisitEventCountVO> countNum(@RequestBody VisitEvent model, @RequestHeader(Constants.HEADER_USER_TOKEN) String token){ |
| | | return ApiResponse.success(visitEventService.countNum(model)); |
| | | } |
| | | } |
| | |
| | | @TableField(exist = false) |
| | | private List<Multifile> multifileList; |
| | | |
| | | @ApiModelProperty(value = "鿣åºåé¨é¨ä¸»é®", example = "1",hidden = true) |
| | | @TableField(exist = false) |
| | | private Integer areaCompanyId; |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.doumee.dao.business.vo; |
| | | |
| | | import com.doumee.core.annotation.excel.ExcelColumn; |
| | | import com.doumee.service.business.third.model.LoginUserModel; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.Date; |
| | | |
| | | @Data |
| | | public class GeneralDataVO{ |
| | | |
| | | @ApiModelProperty(value = "åç§°") |
| | | private String name; |
| | | |
| | | @ApiModelProperty(value = "æ°é") |
| | | private Integer total ; |
| | | |
| | | @ApiModelProperty(value = "å æ¯") |
| | | private BigDecimal rata ; |
| | | |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.doumee.dao.business.vo; |
| | | |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | | |
| | | @Data |
| | | public class HiddenDangerDataVO { |
| | | |
| | | @ApiModelProperty(value = "æ»æ°") |
| | | private Integer total; |
| | | |
| | | @ApiModelProperty(value = "éæ£ç±»åç»è®¡") |
| | | private List<GeneralDataVO> cateList ; |
| | | |
| | | @ApiModelProperty(value = "鿣é¨é¨ç»è®¡") |
| | | private List<GeneralDataVO> departmentList ; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.doumee.dao.business.vo; |
| | | |
| | | import com.doumee.dao.business.model.Approve; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * Created by IntelliJ IDEA. |
| | | * |
| | | * @create 2024/5/23 14:56 |
| | | */ |
| | | @Data |
| | | public class VisitEventCountVO { |
| | | |
| | | @ApiModelProperty(value = "人次") |
| | | private Long eventNum; |
| | | |
| | | @ApiModelProperty(value = "人æ°") |
| | | private Long visitorNum; |
| | | |
| | | |
| | | } |
| | |
| | | package com.doumee.service.business; |
| | | |
| | | import com.doumee.dao.business.vo.HiddenDangerDataVO; |
| | | import com.doumee.service.business.third.model.LoginUserInfo; |
| | | import com.doumee.service.business.third.model.PageData; |
| | | import com.doumee.service.business.third.model.PageWrap; |
| | |
| | | void dealHiddenDanger(HiddenDanger hiddenDanger); |
| | | |
| | | void transferHiddenDanger(HiddenDanger hiddenDanger); |
| | | |
| | | HiddenDangerDataVO hiddenDangerData(HiddenDanger hiddenDanger); |
| | | } |
| | |
| | | package com.doumee.service.business; |
| | | |
| | | import com.doumee.dao.business.vo.VisitEventCountVO; |
| | | import com.doumee.service.business.third.model.PageData; |
| | | import com.doumee.service.business.third.model.PageWrap; |
| | | import com.doumee.dao.business.model.VisitEvent; |
| | |
| | | * @return PageData<VisitEventVo> |
| | | */ |
| | | List<VisitEvent> findPageExcel(PageWrap<VisitEvent> pageWrap); |
| | | |
| | | VisitEventCountVO countNum(VisitEvent model); |
| | | } |
| | |
| | | queryWrapper.select("t4.company_name_path",CarUseBook::getCompanyName); |
| | | queryWrapper.leftJoin(Member.class,Member::getId,CarUseBook::getMemberId) |
| | | .leftJoin(Member.class,Member::getId,CarUseBook::getDriverId) |
| | | .leftJoin("company t4 on t1.company_id=t4.id"); //æ°æ®æéå¼å§--------------------start---------------- |
| | | .leftJoin("company t4 on t1.company_id=t4.id"); |
| | | //æ°æ®æéå¼å§--------------------start---------------- |
| | | LoginUserInfo userInfo =pageWrap.getModel().getLoginUserInfo(); |
| | | if(userInfo!=null && userInfo.getCompanyIdList()!=null){ |
| | | if( userInfo.getCompanyIdList().size() ==0){ |
| | |
| | | import com.doumee.biz.system.SystemDictDataBiz; |
| | | import com.doumee.core.constants.ResponseStatus; |
| | | import com.doumee.core.exception.BusinessException; |
| | | import com.doumee.dao.business.dao.UserActionMapper; |
| | | import com.doumee.dao.business.dao.*; |
| | | import com.doumee.dao.business.vo.GeneralDataVO; |
| | | import com.doumee.dao.business.vo.HiddenDangerDataVO; |
| | | import com.doumee.service.business.third.model.LoginUserInfo; |
| | | import com.doumee.service.business.third.model.PageData; |
| | | import com.doumee.service.business.third.model.PageWrap; |
| | |
| | | import com.doumee.core.wx.wxPlat.WxPlatConstants; |
| | | import com.doumee.core.wx.wxPlat.WxPlatNotice; |
| | | import com.doumee.dao.business.*; |
| | | import com.doumee.dao.business.dao.MemberMapper; |
| | | import com.doumee.dao.business.dao.SmsConfigMapper; |
| | | import com.doumee.dao.business.dao.SmsEmailMapper; |
| | | import com.doumee.dao.business.model.*; |
| | | import com.doumee.dao.business.model.Member; |
| | | import com.doumee.dao.system.MultifileMapper; |
| | |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.util.CollectionUtils; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | |
| | | /** |
| | | * éæ£ä¿¡æ¯è¡¨Serviceå®ç° |
| | |
| | | private HiddenDangerLogMapper hiddenDangerLogMapper; |
| | | @Autowired |
| | | private UserActionMapper userActionMapper; |
| | | |
| | | @Autowired |
| | | private CompanyMapper companyMapper; |
| | | |
| | | |
| | | @Autowired |
| | |
| | | |
| | | .and(StringUtils.isNotBlank(pageWrap.getModel().getMemberName()), ms->ms.like(Member::getName,pageWrap.getModel().getMemberName()) |
| | | .or().like(Member::getPhone,pageWrap.getModel().getMemberName())) |
| | | .ge(Objects.nonNull(pageWrap.getModel().getQueryStartTime()), Empower::getCreateDate,pageWrap.getModel().getQueryStartTime()) |
| | | .le(Objects.nonNull(pageWrap.getModel().getQueryEndTime()),Empower::getCreateDate,pageWrap.getModel().getQueryEndTime()) |
| | | .ge(Objects.nonNull(pageWrap.getModel().getQueryStartTime()), HiddenDanger::getCreateDate,pageWrap.getModel().getQueryStartTime()) |
| | | .le(Objects.nonNull(pageWrap.getModel().getQueryEndTime()),HiddenDanger::getCreateDate,pageWrap.getModel().getQueryEndTime()) |
| | | .orderByDesc(Visits::getCreateDate) |
| | | ; |
| | | for(PageWrap.SortData sortData: pageWrap.getSorts()) { |
| | |
| | | } |
| | | |
| | | |
| | | /** |
| | | * éææç»è®¡æ°æ® |
| | | */ |
| | | @Override |
| | | public HiddenDangerDataVO hiddenDangerData(HiddenDanger hiddenDanger){ |
| | | HiddenDangerDataVO hiddenDangerDataVO = new HiddenDangerDataVO(); |
| | | List<HiddenDanger> hiddenDangerAllList = hiddenDangerMapper.selectJoinList(HiddenDanger.class, |
| | | new MPJLambdaWrapper<HiddenDanger>() |
| | | .selectAll(HiddenDanger.class) |
| | | .selectAs(HiddenDangerParam::getCompanyId, HiddenDanger::getAreaCompanyId) |
| | | .leftJoin(HiddenDangerParam.class,HiddenDangerParam::getId,HiddenDanger::getAreaId) //鿣åºå |
| | | .eq(Objects.nonNull(hiddenDanger.getStatus()),HiddenDanger::getStatus,hiddenDanger.getStatus()) |
| | | .ge(Objects.nonNull(hiddenDanger.getQueryStartTime()), HiddenDanger::getCreateDate,hiddenDanger.getQueryStartTime()) |
| | | .le(Objects.nonNull(hiddenDanger.getQueryEndTime()),HiddenDanger::getCreateDate,hiddenDanger.getQueryEndTime()) |
| | | ); |
| | | hiddenDangerDataVO.setTotal(hiddenDangerAllList.size()); |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(hiddenDangerAllList)){ |
| | | List<Integer> cateList = hiddenDangerAllList.stream().map(i->i.getCateId()).collect(Collectors.toList()); |
| | | //å
¨é¨éæ£åç±»æ°æ® |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(cateList)){ |
| | | List<GeneralDataVO> cateGeneralDataList = new ArrayList<>(); |
| | | Set<Integer> cateSetList = new HashSet<>(cateList); |
| | | List<HiddenDangerParam> hiddenDangerParamList = hiddenDangerParamMapper.selectList(new QueryWrapper<HiddenDangerParam>() |
| | | .lambda().eq(HiddenDangerParam::getIsdeleted,Constants.ZERO).eq(HiddenDangerParam::getType,Constants.ONE)); |
| | | for (Integer cateId:cateSetList) { |
| | | Optional<HiddenDangerParam> optionalHiddenDanger = hiddenDangerParamList.stream().filter(i->Constants.equalsInteger(i.getId(),cateId)).findAny(); |
| | | if(optionalHiddenDanger.isPresent()){ |
| | | GeneralDataVO generalDataVO = new GeneralDataVO(); |
| | | HiddenDangerParam hiddenDangerParam = optionalHiddenDanger.get(); |
| | | Integer total = hiddenDangerAllList.stream().filter(i->Constants.equalsInteger(i.getCateId(),hiddenDangerParam.getId())).collect(Collectors.toList()).size(); |
| | | generalDataVO.setName(hiddenDangerParam.getName()); |
| | | generalDataVO.setTotal(total); |
| | | generalDataVO.setRata( |
| | | Constants.equalsInteger(total,Constants.ZERO)? |
| | | BigDecimal.ZERO:new BigDecimal(total.toString()).divide(new BigDecimal(hiddenDangerDataVO.getTotal().toString()),2).multiply(new BigDecimal("100")) |
| | | ); |
| | | cateGeneralDataList.add(generalDataVO); |
| | | } |
| | | } |
| | | hiddenDangerDataVO.setCateList(cateGeneralDataList); |
| | | } |
| | | //å
¨é¨éæ£åºåé¨é¨æ°æ® |
| | | List<Integer> companyIdList = hiddenDangerAllList.stream().map(i->i.getAreaCompanyId()).collect(Collectors.toList()); |
| | | if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(companyIdList)){ |
| | | List<GeneralDataVO> companyGeneralDataList = new ArrayList<>(); |
| | | Set<Integer> companyIdSetList = new HashSet<>(companyIdList); |
| | | List<Company> companyList = companyMapper.selectList(new QueryWrapper<Company>() |
| | | .lambda().eq(Company::getIsdeleted,Constants.ZERO)); |
| | | for (Integer companyId:companyIdSetList) { |
| | | Optional<Company> optionalCompany = companyList.stream().filter(i->Constants.equalsInteger(i.getId(),companyId)).findAny(); |
| | | if(optionalCompany.isPresent()){ |
| | | GeneralDataVO generalDataVO = new GeneralDataVO(); |
| | | Company company = optionalCompany.get(); |
| | | Integer total = hiddenDangerAllList.stream().filter(i->Constants.equalsInteger(i.getAreaCompanyId(),company.getId())).collect(Collectors.toList()).size(); |
| | | generalDataVO.setName(company.getName()); |
| | | generalDataVO.setTotal(total); |
| | | companyGeneralDataList.add(generalDataVO); |
| | | } |
| | | } |
| | | hiddenDangerDataVO.setDepartmentList(companyGeneralDataList); |
| | | } |
| | | } |
| | | |
| | | return hiddenDangerDataVO; |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | |
| | | .set(PlatformBooks::getEditDate,date) |
| | | .set(PlatformBooks::getEditor,user.getId()) |
| | | .eq(PlatformBooks::getId,id)); |
| | | platformJobMapper.update(null,new UpdateWrapper<PlatformJob>().lambda() |
| | | .set(PlatformJob::getIsdeleted,Constants.ONE) |
| | | .set(PlatformJob::getEditDate,new Date()) |
| | | .set(PlatformJob::getEditor,user.getId()) |
| | | .eq(PlatformJob::getBookId,id) |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO)); |
| | | if(model.getJobId()!=null){ |
| | | platformJobMapper.update(null,new UpdateWrapper<PlatformJob>().lambda() |
| | | .set(PlatformJob::getIsdeleted,Constants.ONE) |
| | | .set(PlatformJob::getEditDate,new Date()) |
| | | .set(PlatformJob::getEditor,user.getId()) |
| | | .eq(PlatformJob::getPlatformId,model.getJobId()) |
| | | .eq(PlatformJob::getIsdeleted,Constants.ZERO)); |
| | | } |
| | | String[] params = new String[3]; |
| | | params[0] = user.getRealname(); |
| | | params[1]=DateUtil.getPlusTime2(date); |
| | |
| | | import cn.hutool.core.lang.Validator; |
| | | import cn.hutool.core.util.ReUtil; |
| | | import com.doumee.core.haikang.model.HKConstants; |
| | | import com.doumee.dao.business.vo.VisitEventCountVO; |
| | | import com.doumee.service.business.third.model.PageData; |
| | | import com.doumee.service.business.third.model.PageWrap; |
| | | import com.doumee.core.utils.Constants; |
| | |
| | | } |
| | | return PageData.from(visitEventDTOIPage); |
| | | } |
| | | |
| | | @Override |
| | | public VisitEventCountVO countNum(VisitEvent model){ |
| | | VisitEventCountVO data = new VisitEventCountVO(); |
| | | data.setEventNum(0l); |
| | | data.setVisitorNum(0l); |
| | | Long count = visitEventJoinMapper.selectCount(new QueryWrapper<VisitEvent>().lambda() |
| | | .ge(StringUtils.isNotBlank(model.getStartTime()), VisitEvent::getCreateDate, model.getStartTime()) |
| | | .le(StringUtils.isNotBlank(model.getEndTime()), VisitEvent::getCreateDate,model.getEndTime()) |
| | | .eq(VisitEvent::getInOrOut,Constants.ZERO) |
| | | .isNotNull(VisitEvent::getVisitorId) |
| | | .eq(VisitEvent::getEventType,HKConstants.EventTypes.VISIT_SIGN_ICCM_PASS.getKey()) |
| | | ); |
| | | if(count!=null){ |
| | | data.setEventNum(count); |
| | | } |
| | | Long count1 = visitEventJoinMapper.selectCount(new QueryWrapper<VisitEvent>().lambda() |
| | | .ge(StringUtils.isNotBlank(model.getStartTime()),VisitEvent::getCreateDate, model.getStartTime()) |
| | | .le(StringUtils.isNotBlank(model.getEndTime()), VisitEvent::getCreateDate,model.getEndTime()) |
| | | .eq( VisitEvent::getIsdeleted,Constants.ZERO) |
| | | .eq( VisitEvent::getInOrOut,Constants.ZERO) |
| | | .isNotNull(VisitEvent::getVisitorId) |
| | | .eq(VisitEvent::getEventType,HKConstants.EventTypes.VISIT_SIGN_ICCM_PASS.getKey()) |
| | | .groupBy(VisitEvent::getVisitorId) |
| | | ); |
| | | if(count1!=null){ |
| | | data.setVisitorNum(count); |
| | | } |
| | | return data; |
| | | } |
| | | @Override |
| | | public List<VisitEvent> findPageExcel(PageWrap<VisitEvent> pageWrap) { |
| | | IPage<VisitEvent> visitEventExcel = getDataInfo(pageWrap); |