productDev/dmvisit.git

			@@ -1,6 +1,7 @@
			package com.doumee.service.business.impl;

			import com.alibaba.fastjson.JSONObject;
			import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
			import com.doumee.biz.system.SystemDictDataBiz;
			import com.doumee.core.constants.ResponseStatus;
			import com.doumee.core.exception.BusinessException;
			@@ -10,17 +11,28 @@
			import com.doumee.core.haikang.model.param.request.ParkReservationDelRequest;
			import com.doumee.core.haikang.model.param.respose.ParkReservationAddResponse;
			import com.doumee.core.haikang.service.HKService;
			import com.doumee.core.model.LoginUserInfo;
			import com.doumee.core.model.PageData;
			import com.doumee.core.model.PageWrap;
			import com.doumee.dao.business.dao.UserActionMapper;
			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.service.business.third.model.request.TmsLockStatusQueryRequest;
			import com.doumee.service.business.third.model.response.TmsBaseResponse;
			import com.doumee.service.business.third.model.response.TmsLockStatusQueryResponse;
			import com.doumee.core.utils.*;
			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.join.PlatformJobJoinMapper;
			import com.doumee.dao.business.join.PlatformJoinMapper;
			import com.doumee.dao.business.model.*;
			import com.doumee.dao.business.vo.LargeScreenDataVO;
			import com.doumee.dao.openapi.request.*;
			import com.doumee.dao.openapi.response.*;

			import com.doumee.dao.system.SystemUserMapper;
			import com.doumee.dao.system.model.SystemUser;
			import com.doumee.dao.web.reqeust.*;
			import com.doumee.dao.web.response.DriverHomeVO;
			@@ -32,9 +44,8 @@
			import com.baomidou.mybatisplus.core.metadata.IPage;
			import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
			import com.doumee.service.business.impl.hksync.HkSyncPushServiceImpl;
			import com.doumee.service.business.impl.thrid.WmsServiceImpl;
			import com.doumee.service.business.third.EmayService;
			import com.doumee.service.business.third.WmsService;
			import com.doumee.service.business.third.TmsService;
			import com.github.yulichang.wrapper.MPJLambdaWrapper;
			import lombok.extern.slf4j.Slf4j;
			import org.apache.commons.lang3.StringUtils;
			@@ -42,6 +53,7 @@
			import org.slf4j.LoggerFactory;
			import org.springframework.beans.BeanUtils;
			import org.springframework.beans.factory.annotation.Autowired;
			import org.springframework.data.redis.core.RedisTemplate;
			import org.springframework.stereotype.Service;
			import org.springframework.transaction.annotation.Transactional;
			import org.springframework.util.CollectionUtils;
			@@ -50,6 +62,7 @@
			import java.math.RoundingMode;
			import java.util.*;
			import java.util.Date;
			import java.util.concurrent.TimeUnit;
			import java.util.stream.Collectors;

			/**
			@@ -63,6 +76,10 @@

			@Autowired
			private PlatformJobMapper platformJobMapper;
			@Autowired
			private UserActionMapper userActionMapper;
			@Autowired
			private TmsService tmsService;

			@Autowired
			private PlatformDeviceMapper platformDeviceMapper;
			@@ -108,9 +125,19 @@
			private EmayService emayService;

			@Autowired
			private RedisTemplate<String, Object> redisTemplate;
			@Autowired
			private PlatformBroadcastLogMapper platformBroadcastLogMapper;
			@Autowired
			private PlatformWarnEventServiceImpl platformWarnEventService;
			@Autowired
			private PlatformWarnEventMapper platformWarnEventMapper;
			@Autowired
			private MemberMapper memberMapper;
			@Autowired
			private WxNoticeConfigMapper wxNoticeConfigMapper;
			@Autowired
			private SystemUserMapper systemUserMapper;

			@Override
			public Integer create(PlatformJob platformJob) {
			@@ -124,6 +151,30 @@
			}


			@Override
			@Transactional(rollbackFor = {BusinessException.class})
			public void deleteById(Integer id,LoginUserInfo user) {
			Date date = new Date();
			PlatformJob job = platformJobMapper.selectById(id);
			if(job==null \|\|Constants.equalsInteger(Constants.ONE,job.getIsdeleted())){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(! Constants.equalsInteger(Constants.PlatformJobStatus.CANCEL.getKey(),job.getStatus())){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起，只能删除已取消的作业任务！");
			}
			platformJobMapper.update(null,new UpdateWrapper<PlatformJob>().lambda()
			.set(PlatformJob::getIsdeleted,Constants.ONE)
			.set(PlatformJob::getEditDate,date)
			.set(PlatformJob::getEditor,user.getId())
			.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.CANCEL.getKey())
			.eq(PlatformJob::getId,id));
			String[] params = new String[3];
			params[0] = user.getRealname();
			params[1]=DateUtil.getPlusTime2(date);
			params[2]="【运单号："+job.getBillCode()+"】-【司机："+job.getDriverName()+" "+job.getDrivierPhone()+"】-【车牌号："+job.getCarCodeFront()+"】";
			//记录删除日志
			UserActionServiceImpl.saveUserActionBiz(user,id,Constants.UserActionType.PLATFROM_JOB_DEL,userActionMapper,date,params,JSONObject.toJSONString(job));
			}
			@Override
			public void delete(Integer id) {
			platformJobMapper.update(null,new UpdateWrapper<PlatformJob>().lambda()
			@@ -174,6 +225,7 @@

			@Override
			public List<PlatformJob> findList(PlatformJob platformJob) {
			platformJob.setIsdeleted(Constants.ZERO);
			QueryWrapper<PlatformJob> wrapper = new QueryWrapper<>(platformJob);
			return platformJobMapper.selectList(wrapper);
			}
			@@ -183,6 +235,7 @@
			IPage<PlatformJob> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
			MPJLambdaWrapper<PlatformJob> queryWrapper = new MPJLambdaWrapper<>();
			Utils.MP.blankToNull(pageWrap.getModel());
			pageWrap.getModel().setIsdeleted(Constants.ZERO);
			queryWrapper
			.selectAll(PlatformJob.class)
			.selectAs(Platform::getName,PlatformJob::getPlatformName)
			@@ -192,11 +245,14 @@
			.selectAs(PlatformWmsJob::getIoCreatedate,PlatformJob::getIoCreatedate)
			.selectAs(SystemUser::getRealname,PlatformJob::getOutUserName)
			.selectAs(PlatformBooks::getId,PlatformJob::getBookId)
			.select("s.REALNAME",PlatformJob::getEditUserName)
			.leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId)
			.leftJoin(PlatformGroup.class,PlatformGroup::getId,Platform::getGroupId)
			.leftJoin(PlatformGroup.class,PlatformGroup::getId,PlatformJob::getPlatformGroupId)
			.leftJoin(PlatformWmsJob.class,PlatformWmsJob::getCarryBillCode,PlatformJob::getBillCode)
			.leftJoin(SystemUser.class,SystemUser::getId,PlatformJob::getOutUserId)
			.leftJoin(PlatformBooks.class,PlatformBooks::getJobId,PlatformJob::getId)
			.leftJoin(" system_user s on t.EDITOR = s.id ")
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.eq(pageWrap.getModel().getId() != null, PlatformJob::getId, pageWrap.getModel().getId())
			.eq(pageWrap.getModel().getCreator() != null, PlatformJob::getCreator, pageWrap.getModel().getCreator())
			.ge(pageWrap.getModel().getCreateDate() != null, PlatformJob::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()))
			@@ -212,6 +268,7 @@
			.eq(pageWrap.getModel().getCode() != null, PlatformJob::getCode, pageWrap.getModel().getCode())
			.eq(pageWrap.getModel().getBillCode() != null, PlatformJob::getBillCode, pageWrap.getModel().getBillCode())
			.eq(pageWrap.getModel().getDriverId() != null, PlatformJob::getDriverId, pageWrap.getModel().getDriverId())
			.eq(pageWrap.getModel().getReasonId() != null, PlatformBooks::getReasonId, pageWrap.getModel().getReasonId())
			.eq(pageWrap.getModel().getDriverName() != null, PlatformJob::getDriverName, pageWrap.getModel().getDriverName())
			.eq(pageWrap.getModel().getPlateNum() != null, PlatformJob::getPlateNum, pageWrap.getModel().getPlateNum())
			.eq(pageWrap.getModel().getDrivierPhone() != null, PlatformJob::getDrivierPhone, pageWrap.getModel().getDrivierPhone())
			@@ -271,28 +328,32 @@
			.eq(pageWrap.getModel().getInType() != null, PlatformJob::getInType, pageWrap.getModel().getInType())
			.eq(pageWrap.getModel().getTotalNum() != null, PlatformJob::getTotalNum, pageWrap.getModel().getTotalNum())
			.eq(pageWrap.getModel().getPlatformGroupId() != null, PlatformJob::getPlatformGroupId, pageWrap.getModel().getPlatformGroupId())

			.apply(pageWrap.getModel().getQueryStatus() != null, " find_in_set(t.`STATUS`,'"+pageWrap.getModel().getQueryStatus()+"')")
			.apply(pageWrap.getModel().getQueryStatusForPower() != null, " find_in_set(t.`STATUS`,'"+pageWrap.getModel().getQueryStatusForPower()+"')")
			.apply(pageWrap.getModel().getQueryType() != null, " find_in_set(t.TYPE,'"+pageWrap.getModel().getQueryType()+"')")
			.ge(pageWrap.getModel().getCreateDateStart() != null, PlatformJob::getCreateDate, pageWrap.getModel().getCreateDateStart())
			.le(pageWrap.getModel().getCreateDateEnd() != null, PlatformJob::getCreateDate, pageWrap.getModel().getCreateDateEnd())
			.ge(pageWrap.getModel().getBeginWorkDateStart() != null, PlatformJob::getStartDate, Utils.Date.getStart(pageWrap.getModel().getBeginWorkDateStart()))
			.le(pageWrap.getModel().getBeginWorkDateEnd() != null, PlatformJob::getStartDate, Utils.Date.getEnd(pageWrap.getModel().getBeginWorkDateEnd()))
			.ge(pageWrap.getModel().getBeginDoneDateStart() != null, PlatformJob::getDoneDate, Utils.Date.getStart(pageWrap.getModel().getBeginDoneDateStart()))
			.le(pageWrap.getModel().getBeginDoneDateEnd() != null, PlatformJob::getDoneDate, Utils.Date.getEnd(pageWrap.getModel().getBeginDoneDateEnd()))

			.ge(pageWrap.getModel().getCreateDateStart() != null, PlatformWmsJob::getIoCreatedate, Utils.Date.getStart(pageWrap.getModel().getCreateDateStart()))
			.le(pageWrap.getModel().getCreateDateEnd() != null, PlatformWmsJob::getIoCreatedate, Utils.Date.getEnd(pageWrap.getModel().getCreateDateEnd()))
			.isNotNull(pageWrap.getModel().getJobType() != null && Constants.equalsInteger(Constants.ONE,pageWrap.getModel().getJobType()), PlatformJob::getContractNum)
			.isNull(pageWrap.getModel().getJobType() != null && Constants.equalsInteger(Constants.ZERO,pageWrap.getModel().getJobType()), PlatformJob::getContractNum)
			;

			for(PageWrap.SortData sortData: pageWrap.getSorts()) {
			// .isNotNull(pageWrap.getModel().getJobType() != null && Constants.equalsInteger(Constants.ONE,pageWrap.getModel().getJobType()),
			// PlatformJob::getContractNum)
			// .isNull(pageWrap.getModel().getJobType() != null && Constants.equalsInteger(Constants.ZERO,pageWrap.getModel().getJobType()), PlatformJob::getContractNum)
			.exists(pageWrap.getModel().getJobType() != null && Constants.equalsInteger(Constants.ZERO,pageWrap.getModel().getJobType()),
			"select 1 from platform_wms_detail tt where tt.isdeleted=0 and tt.job_id=t.id")
			.notExists(pageWrap.getModel().getJobType() != null && Constants.equalsInteger(Constants.ONE,pageWrap.getModel().getJobType()),
			"select 1 from platform_wms_detail tt where tt.isdeleted=0 and tt.job_id=t.id")
			.exists(StringUtils.isNotBlank(pageWrap.getModel().getWmsContractNum()),
			"select tt.id from platform_wms_detail tt where tt.isdeleted=0 and tt.contract_num='"+pageWrap.getModel().getWmsContractNum()+"' and tt.job_id=t.id");
			queryWrapper.orderByDesc(PlatformJob::getCreateDate);
			/*for(PageWrap.SortData sortData: pageWrap.getSorts()) {
			if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
			queryWrapper.orderByDesc(sortData.getProperty());
			} else {
			queryWrapper.orderByAsc(sortData.getProperty());
			}
			}
			}*/
			IPage<PlatformJob> platformJobIPage = platformJobJoinMapper.selectJoinPage(page,PlatformJob.class,queryWrapper);
			platformJobIPage.getRecords().forEach(i->{
			i.dealTime();
			@@ -301,8 +362,6 @@
			});
			return PageData.from(platformJobIPage);
			}



			@Override
			public PageData<PlatformJob> platformCallList(PageWrap<PlatformJob> pageWrap) {
			@@ -315,6 +374,8 @@
			.selectAs(Platform::getName,PlatformJob::getPlatformName)
			.selectAs(Platform::getWorkRate,PlatformJob::getWorkRate)
			.selectAs(PlatformWmsJob::getCarrierName,PlatformJob::getCarrierName)
			.select(" (select GROUP_CONCAT(distinct(tt.contract_num )) from platform_wms_detail tt where tt.isdeleted=0 and tt.contract_num is not null and tt.job_id=t.id )as wmsContractNum")
			// .select(" case when t.total_num is null then ( select sum(pwd.IO_QTY) from platform_wms_detail pwd where pwd.JOB_ID = t.id ) else t.total_num end ioQty ")
			.leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId)
			.leftJoin(PlatformWmsJob.class,PlatformWmsJob::getCarryBillCode,PlatformJob::getBillCode)
			.leftJoin(PlatformBooks.class,PlatformBooks::getJobId,PlatformJob::getId)
			@@ -322,15 +383,12 @@
			.apply("( t1.isdeleted = 0 or t.PLATFORM_ID is null )")
			.eq(pageWrap.getModel().getPlatformGroupId() != null, PlatformJob::getPlatformGroupId, pageWrap.getModel().getPlatformGroupId())
			.like(pageWrap.getModel().getCarCodeFront() != null, PlatformJob::getCarCodeFront, pageWrap.getModel().getCarCodeFront())

			.apply(Objects.nonNull(pageWrap.getModel().getCallType())
			&&Constants.equalsInteger(pageWrap.getModel().getCallType(),Constants.ONE),
			" ( " +
			" ( t.`STATUS` = "+Constants.PlatformJobStatus.WAIT_CALL.getKey()+" and t.PLATFORM_GROUP_ID = ( SELECT p.group_id FROM platform p WHERE p.id = "+pageWrap.getModel().getPlatformId()+" LIMIT 1 ) )" +
			") "
			)


			.apply(Objects.nonNull(pageWrap.getModel().getCallType())
			&&Constants.equalsInteger(pageWrap.getModel().getCallType(),Constants.TWO),
			" ( " +
			@@ -341,8 +399,6 @@
			" (t.`STATUS` = "+Constants.PlatformJobStatus.TRANSFERING.getKey()+" and t.PLATFORM_ID = "+pageWrap.getModel().getPlatformId()+" ) " +
			") "
			)


			.and(Objects.nonNull(pageWrap.getModel().getCallType())
			&&Constants.equalsInteger(pageWrap.getModel().getCallType(),Constants.THREE),
			i->i.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey()).or()
			@@ -352,12 +408,17 @@
			)
			// .like(PlatformJob::getArriveDate,DateUtil.dateTypeToString(new Date(),"yyyy-MM-dd"))
			.orderByDesc(PlatformJob::getStatus)
			.orderByAsc(PlatformJob::getSignDate)
			;
			IPage<PlatformJob> platformJobIPage = platformJobJoinMapper.selectJoinPage(page,PlatformJob.class,queryWrapper);
			platformJobIPage.getRecords().forEach(i->{
			i.dealTime();
			this.getWmsJobData(i);
			this.queryWaitNum(i);
			if(Constants.equalsInteger(i.getOrigin(),Constants.ZERO)){
			i.setWmsContractNum(i.getContractNum());
			}
			// i.setTotalNum(i.getIoQty());
			// this.getWmsJobData(i);
			// this.queryWaitNum(i);
			});
			return PageData.from(platformJobIPage);
			}
			@@ -368,7 +429,6 @@
			\|\| Constants.equalsInteger(platformJob.getType(),Constants.platformJobType.zyczh)
			\|\| Constants.equalsInteger(platformJob.getType(),Constants.platformJobType.wxcxh)
			\|\| Constants.equalsInteger(platformJob.getType(),Constants.platformJobType.wxczh)) {

			PlatformWmsJob platformWmsJob = platformWmsJobMapper.selectOne(new QueryWrapper<PlatformWmsJob>().lambda()
			.eq(PlatformWmsJob::getIsdeleted,Constants.ZERO)
			.eq(PlatformWmsJob::getJobId,platformJob.getId())
			@@ -384,7 +444,7 @@

			if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformWmsDetailList)){
			platformJob.setTotalNum(
			platformWmsDetailList.stream().map(m->m.getIoQty()).reduce(BigDecimal.ZERO,BigDecimal::add)
			platformWmsDetailList.stream().filter(i->Objects.nonNull(i.getIoQty())).map(m->m.getIoQty()).reduce(BigDecimal.ZERO,BigDecimal::add)
			);
			platformWmsJob.setPlatformWmsDetailList(platformWmsDetailList);
			platformJob.setPlatformWmsJob(platformWmsJob);
			@@ -400,37 +460,40 @@
			}else{
			platformJob.setLockStatus(Constants.ONE); //部分上锁
			}

			}



			}
			}
			}


			public void queryWaitNum(PlatformJob platformJob){
			if(Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.WAIT_CALL.getKey())){
			//查询前方排队数量
			List<PlatformJob> lineUpNum = platformJobMapper.selectList(new QueryWrapper<PlatformJob>().lambda()
			//查询当前所有排队数量
			List<PlatformJob> lineUpAllList = platformJobMapper.selectList(new QueryWrapper<PlatformJob>().lambda()
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey()
			,Constants.PlatformJobStatus.IN_WAIT.getKey()
			,Constants.PlatformJobStatus.TRANSFERING.getKey())
			.gt(PlatformJob::getSignDate,platformJob.getSignDate())
			// .lt(PlatformJob::getSignDate,platformJob.getSignDate())
			.eq(PlatformJob::getPlatformGroupId,platformJob.getPlatformGroupId())
			.like(PlatformJob::getArriveDate,DateUtil.dateTypeToString(platformJob.getArriveDate(),"yyyy-MM-dd")));
			platformJob.setLineUpNum(lineUpNum.size());
			BigDecimal sumWorkRate = platformJob.getTotalNum();
			for (PlatformJob linePlatformJob:lineUpNum) {
			this.getWmsJobData(linePlatformJob);
			sumWorkRate = sumWorkRate.add(linePlatformJob.getTotalNum());
			}
			if(lineUpNum.size()>Constants.ZERO){
			// .like(PlatformJob::getArriveDate,DateUtil.dateTypeToString(platformJob.getArriveDate(),"yyyy-MM-dd"))
			);
			if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(lineUpAllList)){
			for (PlatformJob linePlatformJob:lineUpAllList) {
			this.getWmsJobData(linePlatformJob);
			}
			//查询排队在我前面的数据
			List<PlatformJob> lineUpNum = lineUpAllList.stream().filter(i->Objects.nonNull(i.getSignDate())&&i.getSignDate().getTime()<platformJob.getSignDate().getTime()).collect(Collectors.toList());
			platformJob.setLineUpNum(lineUpNum.size());
			BigDecimal sumWorkRate = Constants.formatBigdecimal(platformJob.getTotalNum());
			for (PlatformJob linePlatformJob:lineUpNum) {
			sumWorkRate = sumWorkRate.add(Constants.formatBigdecimal(linePlatformJob.getTotalNum()));
			}
			//计算预计等待时间
			List<Platform> platformList = platformJoinMapper.selectList(new QueryWrapper<Platform>().lambda().eq(Platform::getIsdeleted,Constants.ZERO).eq(Platform::getGroupId,platformJob.getPlatformGroupId()));
			BigDecimal workRate = platformList.stream().map(m->m.getWorkRate()).reduce(BigDecimal.ZERO,BigDecimal::add);
			List<Platform> platformList = platformJoinMapper.selectList(new QueryWrapper<Platform>().lambda()
			.eq(Platform::getIsdeleted,Constants.ZERO).eq(Platform::getGroupId,platformJob.getPlatformGroupId()));
			BigDecimal workRate = new BigDecimal(0);
			if(platformList!=null){
			workRate = platformList.stream().map(m->Constants.formatBigdecimal(m.getWorkRate())).reduce(BigDecimal.ZERO,BigDecimal::add);
			}
			if(sumWorkRate.compareTo(BigDecimal.ZERO) > Constants.ZERO && workRate.compareTo(BigDecimal.ZERO) > Constants.ZERO ){
			BigDecimal sumMinute = sumWorkRate.divide(workRate,1, RoundingMode.HALF_DOWN).multiply(BigDecimal.valueOf(60L));
			Integer sumMinuteInteger = sumMinute.intValue();
			@@ -449,7 +512,9 @@
			platformJob.setWaitTime("预计等待：-小时-分钟");
			}
			}else if(Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.WORKING.getKey())
			\|\| Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.DONE.getKey())){
			\|\| Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.DONE.getKey())
			\|\| Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey())
			\|\| Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.LEAVED.getKey())){
			//查询最后开始任务的月台记录日志表因为存在异常挂起转移等问题
			PlatformLog platformLog = platformLogMapper.selectOne(new QueryWrapper<PlatformLog>().lambda()
			.eq(PlatformLog::getJobId,platformJob.getId())
			@@ -457,7 +522,7 @@
			.orderByDesc(PlatformLog::getCreateDate)
			.last(" limit 1")
			);
			if(Objects.nonNull(platformLog)){
			if(Objects.nonNull(platformLog) && platformJob.getWorkRate()!=null && platformJob.getWorkRate().compareTo(new BigDecimal(0))>0){
			BigDecimal sumMinute = platformJob.getTotalNum().divide(platformJob.getWorkRate(),1, RoundingMode.HALF_DOWN).multiply(BigDecimal.valueOf(60L));
			platformJob.setFinishTimeStr(DateUtil.DateToStr(DateUtil.afterMinutesDate(platformLog.getCreateDate(),sumMinute.intValue()),"HH:mm"));
			}
			@@ -467,9 +532,12 @@
			.isNotNull(PlatformLog::getParam3)
			.ne(PlatformLog::getParam3,Constants.ZERO+"")
			.orderByDesc(PlatformLog::getCreateDate));
			platformJob.setWorkTime(platformLogList.stream().map(m->Long.valueOf(m.getParam3())).reduce(Long.valueOf(0),Long::sum));
			if(platformLogList!=null){
			platformJob.setWorkTime(platformLogList.stream().map(m->Long.valueOf(StringUtils.defaultString(m.getParam3(),"0"))).reduce(Long.valueOf(0),Long::sum));
			}

			}
			platformJob.setWorkTimeStr(DateUtil.getTimeStrBySecond(platformJob.getWorkTime()));
			}


			@@ -491,7 +559,14 @@
			.leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId)
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.eq(PlatformJob::getDrivierPhone,loginUserInfo.getMobile())
			// .like(PlatformJob::getArriveDate,DateUtil.getCurrDate())
			.and(i->i.like(PlatformJob::getDoneDate,DateUtil.getCurrDate())
			.or().in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey()
			,Constants.PlatformJobStatus.WAIT_CONFIRM.getKey(),
			Constants.PlatformJobStatus.WART_SIGN_IN.getKey(),
			Constants.PlatformJobStatus.IN_WAIT.getKey(),
			Constants.PlatformJobStatus.CALLED.getKey(),
			Constants.PlatformJobStatus.WORKING.getKey())
			)
			.orderByDesc(PlatformJob::getId)
			);
			for (PlatformJob platformJob:platformJobList) {
			@@ -500,9 +575,7 @@
			//查询前方排队数量
			this.queryWaitNum(platformJob);
			}

			driverHomeVO.setPlatformJobList(platformJobList);

			// 园区导览图图片
			driverHomeVO.setReservationMap(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.PLATFORM_GUIDEMAP).getCode());
			// 预约指南文本
			@@ -524,7 +597,7 @@
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			PlatformJob platformJob = platformJobMapper.selectById(confirmTaskDTO.getId());
			if(Objects.isNull(platformJob)){
			if(Objects.isNull(platformJob)\|\|Constants.equalsInteger(platformJob.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(!Constants.equalsInteger(platformJob.getStatus(),Constants.ZERO)){
			@@ -560,7 +633,7 @@
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			PlatformJob platformJob = platformJobMapper.selectById(signInDTO.getJobId());
			if(Objects.isNull(platformJob)){
			if(Objects.isNull(platformJob)\|\|Constants.equalsInteger(platformJob.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}

			@@ -568,11 +641,17 @@
			BeanUtils.copyProperties(platformJob,oldPlatformJob);

			if(Constants.equalsInteger(signInDTO.getSignType(),Constants.ZERO)){
			if(!StringUtils.equals(platformJob.getDrivierPhone(),signInDTO.getLoginUserInfo().getMobile())){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(!Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.WART_SIGN_IN.getKey())){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"业务状态已流转，请刷新查看");
			}
			this.distanceSignIn(signInDTO,platformJob);
			}else if(Constants.equalsInteger(signInDTO.getSignType(),Constants.ONE)){
			if(!StringUtils.equals(platformJob.getDrivierPhone(),signInDTO.getLoginUserInfo().getMobile())){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(!Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.WART_SIGN_IN.getKey())){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"业务状态已流转，请刷新查看");
			}
			@@ -598,7 +677,9 @@
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"未在工作时间["+platformGroup.getStartTime() + "-" + platformGroup.getEndTime() +"]，无法进行签到");
			}
			//查询今日最大的签到数
			List<PlatformJob> signList = platformJobMapper.selectList(new QueryWrapper<PlatformJob>().lambda().apply(" DATE(SIGN_DATE) = DATE(NOW()) and sign_date is not null "));
			List<PlatformJob> signList = platformJobMapper.selectList(new QueryWrapper<PlatformJob>().lambda()
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.apply(" DATE(SIGN_DATE) = DATE(NOW()) and sign_date is not null "));
			if(CollectionUtils.isEmpty(signList)){
			platformJob.setSignNum(Constants.ONE);
			} else{
			@@ -612,14 +693,80 @@
			//存储操作日志
			savePlatformLog(Constants.PlatformJobLogType.SIGN.getKey(),oldPlatformJob,platformJob,
			Constants.PlatformJobLogType.SIGN.getInfo());
			//签到微信通知 2025年3月26日14:25:00
			logger.info("签到微信通知=========================>开始====签到类型=>"+signInDTO.getSignType()+"===>人员主键=>"+platformGroup.getSignInNoticeUsers());
			if(!Constants.equalsInteger(signInDTO.getSignType(),Constants.TWO)&&
			StringUtils.isNotBlank(platformGroup.getSignInNoticeUsers())){
			logger.info("签到微信通知=========================>进入");
			List<SystemUser> systemUserList = systemUserMapper.selectList(new QueryWrapper<SystemUser>().lambda()
			.eq(SystemUser::getDeleted,Constants.ZERO).eq(SystemUser::getStatus,Constants.ZERO).isNotNull(SystemUser::getOpenid)
			.in(SystemUser::getMemberId,Arrays.asList(platformGroup.getSignInNoticeUsers().split(",")))
			);
			if (com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(systemUserList)) {
			WxPlatNotice wxPlatNotice = new WxPlatNotice();
			wxPlatNotice.sendPlatformJobSignNotice(systemDictDataBiz,wxNoticeConfigMapper, platformJob,
			WxPlatConstants.platformJobContent.platformGroupSignIn,
			systemUserList.stream().map(i->i.getOpenid()).collect(Collectors.toList())
			);
			}
			}
			logger.info("签到微信通知=========================>结束");
			}


			@Override
			public void sendUnFinishNotice(){
			//状态 0待确认 1待签到 2等待叫号 3入园等待 4已叫号 5作业中 6作业完成 7转移中 8异常挂起 9已授权离园 10已离园 11 已过号 12取消（WMS）
			List<PlatformJob> platformJobList = platformJobJoinMapper.selectJoinList(PlatformJob.class,
			new MPJLambdaWrapper<PlatformJob>()
			.selectAll(PlatformJob.class)
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.isNotNull(PlatformJob::getPlatformGroupId)
			.apply(" CREATE_DATE < now() ")
			.in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CONFIRM.getKey()
			,Constants.PlatformJobStatus.WART_SIGN_IN.getKey()
			,Constants.PlatformJobStatus.WAIT_CALL.getKey()
			,Constants.PlatformJobStatus.IN_WAIT.getKey()
			,Constants.PlatformJobStatus.CALLED.getKey()
			,Constants.PlatformJobStatus.WORKING.getKey()
			,Constants.PlatformJobStatus.TRANSFERING.getKey()
			,Constants.PlatformJobStatus.EXCEPTION.getKey()
			,Constants.PlatformJobStatus.OVER_NUMBER.getKey()
			)
			);
			if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformJobList)){
			List<Integer> platformGroupId = platformJobList.stream().map(i->i.getPlatformGroupId()).collect(Collectors.toList());
			if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformGroupId)){
			Set<Integer> setList = new HashSet<>(platformGroupId);
			for (Integer groupId:setList) {
			PlatformGroup platformGroup = platformGroupMapper.selectById(groupId);
			if(Objects.nonNull(platformGroup)&&StringUtils.isNotBlank(platformGroup.getUnFinishNoticeUsers())){
			List<SystemUser> systemUserList = systemUserMapper.selectList(new QueryWrapper<SystemUser>().lambda()
			.eq(SystemUser::getDeleted,Constants.ZERO).eq(SystemUser::getStatus,Constants.ZERO)
			.isNotNull(SystemUser::getOpenid)
			.in(SystemUser::getMemberId,Arrays.asList(platformGroup.getUnFinishNoticeUsers().split(",")))
			);
			if (com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(systemUserList)) {
			WxPlatNotice wxPlatNotice = new WxPlatNotice();
			wxPlatNotice.sendUnFinishNotice(systemDictDataBiz,
			wxNoticeConfigMapper,
			platformJobList.stream().filter(i->Constants.equalsInteger(i.getPlatformGroupId(),groupId)).collect(Collectors.toList()).size(),
			WxPlatConstants.platformJobContent.unFinishNotice,
			systemUserList.stream().map(i->i.getOpenid()).collect(Collectors.toList())
			);
			}
			}
			}
			}
			}
			}


			public void distanceSignIn(SignInDTO signInDTO , PlatformJob platformJob){
			if(Objects.isNull(signInDTO.getLat())
			\|\| Objects.isNull(signInDTO.getLnt())){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"经纬度信息异常");
			}

			//获取签到点的经纬度
			Double lat = Double.parseDouble(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_PLACE_LAT).getCode());
			Double lnt = Double.parseDouble(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_PLACE_LNT).getCode());
			@@ -635,37 +782,37 @@
			}

			public void sceneSignIn(SignInDTO signInDTO){

			if( StringUtils.isNotBlank(signInDTO.getQrCodeKey())){
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			if(!signInDTO.getQrCodeKey().equals(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_QRCODE).getCode())){
			if(!signInDTO.getQrCodeKey().equals(
			systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_QRCODE_PREFIX).getCode() + systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_QRCODE).getCode())){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"二维码已过期,请刷新重试");
			}
			}


			@Override
			public PlatformJob getDetail(JobDetailDTO jobDetailDTO){
			if(Objects.isNull(jobDetailDTO)
			\|\| Objects.isNull(jobDetailDTO.getJobId())){
			if(Objects.isNull(jobDetailDTO) \|\| Objects.isNull(jobDetailDTO.getJobId())){
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			PlatformJob platformJob = platformJobMapper.selectById(jobDetailDTO.getJobId());
			if(Objects.isNull(platformJob)){
			if(Objects.isNull(platformJob)\|\|Constants.equalsInteger(platformJob.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.WART_SIGN_IN.getKey())){
			//待签到计算距离
			if(Objects.nonNull(jobDetailDTO.getLnt())&&Objects.nonNull(jobDetailDTO.getLat())){
			//获取签到点的经纬度
			Double lat = Double.parseDouble(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_PLACE_LAT).getCode());
			Double lnt = Double.parseDouble(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_PLACE_LNT).getCode());
			//获取2个点的距离X米
			Double getDistanceDouble = PositionUtil.getDistance(jobDetailDTO.getLnt(),jobDetailDTO.getLat(),lnt,lat);
			//转换km
			BigDecimal getDistance = BigDecimal.valueOf(getDistanceDouble).divide(new BigDecimal(1000),2,BigDecimal.ROUND_HALF_UP);
			platformJob.setGetDistance(getDistance);
			if(jobDetailDTO.getLat()!=null && jobDetailDTO.getLnt()!=null){
			//获取签到点的经纬度
			Double lat = Double.parseDouble(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_PLACE_LAT).getCode());
			Double lnt = Double.parseDouble(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_PLACE_LNT).getCode());
			//获取2个点的距离X米
			Double getDistanceDouble = PositionUtil.getDistance(jobDetailDTO.getLnt(),jobDetailDTO.getLat(),lnt,lat);
			//转换km
			BigDecimal getDistance = BigDecimal.valueOf(getDistanceDouble).divide(new BigDecimal(1000),2,BigDecimal.ROUND_HALF_UP);
			platformJob.setGetDistance(getDistance);
			}
			}
			}else if( Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.WAIT_CALL.getKey())
			\|\| Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.IN_WAIT.getKey())
			@@ -684,7 +831,7 @@
			}
			}
			platformJob.dealTime();
			this.getWorkTime(platformJob);
			this.getWorkTime(platformJob,platformLogMapper);
			this.getWmsJobData(platformJob);
			return platformJob;
			}
			@@ -712,6 +859,7 @@
			,PlatformJob::getId,lineUpDetailDTO.getJobId())
			.in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey(),
			Constants.PlatformJobStatus.IN_WAIT.getKey(),
			Constants.PlatformJobStatus.WORKING.getKey(),
			Constants.PlatformJobStatus.CALLED.getKey())
			.orderByDesc(PlatformJob::getStatus)
			.orderByAsc(PlatformJob::getSignDate)
			@@ -737,12 +885,12 @@
			.leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId)
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.eq(PlatformJob::getPlatformGroupId,platformGroup.getId())
			.le(Objects.nonNull(platformJob),PlatformJob::getSignDate,DateUtil.dateTypeToString(platformJob.getSignDate(),"yyyy-MM-dd HH:mm:ss"))
			.in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CALL.getKey(),
			Constants.PlatformJobStatus.IN_WAIT.getKey(),
			Constants.PlatformJobStatus.CALLED.getKey())
			.orderByDesc(PlatformJob::getStatus)
			.orderByDesc(PlatformJob::getSignDate));
			.orderByAsc(PlatformJob::getSignDate)
			.orderByAsc(PlatformJob::getSignNum)
			);
			platformGroup.setSignJobList(platformJobSignInList);
			//查询当前月台组下
			List<PlatformJob> platformJobWorkList = platformJobJoinMapper.selectJoinList(PlatformJob.class,
			@@ -766,7 +914,7 @@
			* 获取已作业时间
			* @param platformJob
			*/
			public Long getWorkTime(PlatformJob platformJob){
			public static Long getWorkTime(PlatformJob platformJob,PlatformLogMapper platformLogMapper){
			List<PlatformLog> platformLogList = platformLogMapper.selectList(new QueryWrapper<PlatformLog>()
			.lambda().eq(PlatformLog::getIsdeleted,Constants.ZERO)
			.eq(PlatformLog::getJobId,platformJob.getId())
			@@ -789,7 +937,7 @@
			.last(" limit 1 ")
			);
			if(Objects.nonNull(lastBeginPlatform)){
			String v = Long.toString(System.currentTimeMillis() - lastBeginPlatform.getCreateDate().getTime() / 1000) ;
			String v = Long.toString((System.currentTimeMillis() - lastBeginPlatform.getCreateDate().getTime() )/ 1000) ;
			optTime = optTime + Long.valueOf(v);
			}
			}
			@@ -809,7 +957,7 @@
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			PlatformJob platformJob = platformJobMapper.selectById(jobOperateDTO.getJobId());
			if(Objects.isNull(platformJob)){
			if(Objects.isNull(platformJob)\|\|Constants.equalsInteger(platformJob.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(!Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.WAIT_CALL.getKey())){
			@@ -850,15 +998,64 @@
			emayService,smsEmailMapper,smsConfigMapper,platformJobMapper,platformJob.getId(),
			SmsConstants.platformJobContent.platformJobCallIn,null,null
			);


			//公众号模板消息
			if(Objects.nonNull(platformJob.getDrivierPhone())) {
			this.sendWxNotice(WxPlatConstants.platformJobContent.platformJobCallIn,platformJob);
			}
			return platformJob;
			}

			public void sendWxNotice(String objCode,PlatformJob platformJob){
			SystemUser driver = systemUserMapper.selectOne(new QueryWrapper<SystemUser>().lambda()
			.eq(SystemUser::getDeleted, Constants.ZERO)
			.in(SystemUser::getType, Constants.ZERO,Constants.TWO)
			.eq(SystemUser::getMobile,platformJob.getDrivierPhone())
			.last(" limit 1 "));
			if (Objects.nonNull(driver) && StringUtils.isNotBlank(driver.getOpenid())) {
			PlatformJob p = platformJobJoinMapper.selectJoinOne(PlatformJob.class,
			new MPJLambdaWrapper<PlatformJob>()
			.selectAll(PlatformJob.class)
			.selectAs(Platform::getName,PlatformJob::getPlatformName)
			.leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId)
			.eq(PlatformJob::getId,platformJob.getId())
			.last(" limit 1")
			);
			WxPlatNotice wxPlatNotice = new WxPlatNotice();
			wxPlatNotice.sendPlatformJobTemplateNotice(systemDictDataBiz,
			wxNoticeConfigMapper, p,
			objCode,
			Arrays.asList(driver.getOpenid().split(","))
			);
			}
			}





			private Logger logger = LoggerFactory.getLogger(PlatformJobServiceImpl.class);

			@Override
			public void sendInPark(PlatformJob platformJob){
			log.info("【下发停车场权限】================开始===="+platformJob.getCarCodeFront());
			if(Constants.equalsInteger(platformJob.getType(),Constants.THREE)
			&& Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.DONE.getKey()) ){
			//如果是已完成的外协车卸货作业，查询所有合同是否以上电子锁，如果没有，不自动授权离园
			List<PlatformWmsDetail> details = platformWmsDetailMapper.selectList(new QueryWrapper<PlatformWmsDetail>().lambda()
			.select(PlatformWmsDetail::getLockStatus,PlatformWmsDetail::getId)
			.eq(PlatformWmsDetail::getJobId,platformJob.getId())
			.eq(PlatformWmsDetail::getIsdeleted,Constants.ZERO)
			);
			if(details!=null && details.size()>0){
			for(PlatformWmsDetail d : details){
			if(Constants.equalsInteger(d.getLockStatus(),Constants.ZERO)){
			//如果存在未上锁，不自动授权离园
			return;
			}
			}
			}
			}
			if(Constants.equalsInteger(platformJob.getType(),Constants.TWO)
			\|\| Constants.equalsInteger(platformJob.getType(),Constants.THREE)
			\|\| Constants.equalsInteger(platformJob.getType(),Constants.FOUR)){
			@@ -940,6 +1137,15 @@
			platformJob.setInHkdate(new Date());
			if(sendStatus){
			platformJob.setInHkstatus(Constants.TWO);
			if(Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.DONE.getKey())){
			//如果已下发成功，标记已授权离园状态
			platformJob.setStatus(Constants.PlatformJobStatus.AUTHED_LEAVE.getKey());
			//删除报警信息
			platformWarnEventMapper.update(new UpdateWrapper<PlatformWarnEvent>().lambda()
			.set(PlatformWarnEvent::getIsdeleted,Constants.ONE)
			.eq(PlatformWarnEvent::getPlatformId,platformJob.getId())
			);
			}
			}else{
			platformJob.setInHkstatus(Constants.THREE);
			}
			@@ -950,18 +1156,19 @@
			}
			}


			@Override
			public void cancelInPark(PlatformJob platformJob){
			if(Constants.equalsInteger(platformJob.getType(),Constants.TWO)
			\|\| Constants.equalsInteger(platformJob.getType(),Constants.THREE)
			\|\| StringUtils.isBlank(platformJob.getCarCodeFront())
			\|\| Constants.equalsInteger(platformJob.getType(),Constants.FOUR)){

			List<VisitPark> visitParkList = visitParkMapper.selectList(new QueryWrapper<VisitPark>().lambda()
			.eq(VisitPark::getCarCode,platformJob.getCarCodeFront())
			.eq(VisitPark::getObjType,Constants.ONE)
			.eq(VisitPark::getHkStatus,Constants.ONE)
			.isNotNull(VisitPark::getHkId)
			.apply(" END_TIME > now() ")
			.orderByDesc(VisitPark::getCreateDate)
			);
			if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(visitParkList)){
			for (VisitPark visitPark:visitParkList) {
			@@ -979,7 +1186,6 @@
			}
			}
			}

			/**
			* 月台叫号
			*/
			@@ -991,7 +1197,7 @@
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			PlatformJob platformJob = platformJobMapper.selectById(jobOperateDTO.getJobId());
			if(Objects.isNull(platformJob)){
			if(Objects.isNull(platformJob)\|\|Constants.equalsInteger(platformJob.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(!(Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.WAIT_CALL.getKey())
			@@ -1009,6 +1215,7 @@
			//查询月台任务等待作业数量
			if(platformJobMapper.selectCount(new QueryWrapper<PlatformJob>().lambda()
			.eq(PlatformJob::getPlatformId,platform.getId())
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.in(PlatformJob::getStatus,Constants.PlatformJobStatus.CALLED.getKey(),Constants.PlatformJobStatus.WORKING.getKey())
			)>=platform.getWorkingNum()){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"超出月台可同时作业数量["+platform.getWorkingNum()+"辆]");
			@@ -1045,10 +1252,16 @@
			SmsConstants.platformJobContent.platformJobSingIn,platform.getName(),null
			);

			//公众号模板消息
			if(Objects.nonNull(platformJob.getDrivierPhone())){
			this.sendWxNotice(WxPlatConstants.platformJobContent.platformJobSingIn,platformJob);
			}


			//广播 led通知
			platformJob.setPlatformName(platform.getName());
			this.broadcastAndLEed(platformJob,Constants.PlatformLedContent.CALLING.getInfo(),
			Constants.PlatformBroadcastContent.CALLING.getInfo()
			Constants.PlatformBroadcastContent.CALLING.getInfo()+ Constants.PlatformBroadcastContent.CALLING.getInfo() + Constants.PlatformBroadcastContent.CALLING.getInfo()
			);

			platformJob.setPlatformWmsCode(platform.getCode());
			@@ -1132,7 +1345,7 @@
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			PlatformJob platformJob = platformJobMapper.selectById(jobOperateDTO.getJobId());
			if(Objects.isNull(platformJob)){
			if(Objects.isNull(platformJob)\|\|Constants.equalsInteger(platformJob.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if( !( Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.WORKING.getKey())
			@@ -1175,7 +1388,13 @@
			SmsConstants.platformJobContent.platformJobMove,oldPlatform.getName(),platform.getName()
			);

			platformJob.setPlatformName(platform.getName());
			//公众号模板消息
			if(Objects.nonNull(platformJob.getDrivierPhone())) {
			this.sendWxNotice(WxPlatConstants.platformJobContent.platformJobMove,platformJob);
			}

			platformJob.setPlatformName(oldPlatform.getName());
			platformJob.setPlatformId(oldPlatform.getId());
			this.broadcastAndLEed(platformJob, StringUtils.isBlank(oldPlatform.getLedContent())?Constants.PlatformLedContent.IDEL_CONTNET.getName():oldPlatform.getLedContent(),
			null
			);
			@@ -1194,12 +1413,19 @@
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			PlatformJob platformJob = platformJobMapper.selectById(jobOperateDTO.getJobId());
			if(Objects.isNull(platformJob)){
			if(Objects.isNull(platformJob)\|\|Constants.equalsInteger(platformJob.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}

			if(!Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.CALLED.getKey())){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起,业务状态已流转！");
			}

			Platform platform = platformJoinMapper.selectById(platformJob.getPlatformId());
			if(Objects.isNull(platform)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到月台信息");
			}

			PlatformJob oldPlatformJob = new PlatformJob();
			BeanUtils.copyProperties(platformJob,oldPlatformJob);

			@@ -1215,6 +1441,15 @@
			SmsConstants.platformJobContent.platformJobOverNum,null,null
			);

			//公众号模板消息
			if(Objects.nonNull(platformJob.getDrivierPhone())){
			this.sendWxNotice(WxPlatConstants.platformJobContent.platformJobOverNum,platformJob);
			}

			platformJob.setPlatformName(platform.getName());
			this.broadcastAndLEed(platformJob, StringUtils.isBlank(platform.getLedContent())?Constants.PlatformLedContent.IDEL_CONTNET.getName():platform.getLedContent(),
			null
			);

			return platformJob;
			}
			@@ -1231,7 +1466,7 @@
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			PlatformJob platformJob = platformJobMapper.selectById(jobOperateDTO.getJobId());
			if(Objects.isNull(platformJob)){
			if(Objects.isNull(platformJob)\|\|Constants.equalsInteger(platformJob.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(!Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.WORKING.getKey())){
			@@ -1258,6 +1493,11 @@
			SmsConstants.platformJobContent.platformJobError,platform.getName(),null
			);

			//公众号模板消息
			if(Objects.nonNull(platformJob.getDrivierPhone())) {
			this.sendWxNotice(WxPlatConstants.platformJobContent.platformJobError,platformJob);
			}

			platformJob.setPlatformName(platform.getName());
			this.broadcastAndLEed(platformJob, StringUtils.isBlank(platform.getLedContent())?Constants.PlatformLedContent.IDEL_CONTNET.getName():platform.getLedContent(),
			null
			@@ -1277,7 +1517,7 @@
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			PlatformJob platformJob = platformJobMapper.selectById(jobOperateDTO.getJobId());
			if(Objects.isNull(platformJob)){
			if(Objects.isNull(platformJob)\|\|Constants.equalsInteger(platformJob.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(!Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.CALLED.getKey())){
			@@ -1307,7 +1547,10 @@
			emayService,smsEmailMapper,smsConfigMapper,platformJobMapper,platformJob.getId(),
			SmsConstants.platformJobContent.platformJobWorking,platform.getName(),null
			);

			//公众号模板消息
			if(Objects.nonNull(platformJob.getDrivierPhone())) {
			this.sendWxNotice(WxPlatConstants.platformJobContent.platformJobWorking,platformJob);
			}
			//广播 led通知
			platformJob.setPlatformName(platform.getName());
			this.broadcastAndLEed(platformJob,Constants.PlatformLedContent.WORKING.getInfo(),
			@@ -1316,11 +1559,22 @@

			return platformJob;
			}


			/**
			* 完成作业
			*/

			@Override
			public PlatformJob getLastWaitJob(String uuid, LoginUserInfo loginUser){
			String u = (String) redisTemplate.opsForValue().get(Constants.RedisKeys.BIGSCREEN_UUID);
			if(!StringUtils.equals(u,uuid)){
			throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，二维码已失效！");
			}
			PlatformJob platformJob = platformJobMapper.selectOne(new QueryWrapper<PlatformJob>().lambda()
			.eq(PlatformJob::getDrivierPhone,loginUser.getMobile())
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WART_SIGN_IN.getKey())
			.orderByDesc(PlatformJob::getCreateDate)
			.last(" limit 1 ") );
			return platformJob;
			}

			@Override
			@Transactional(rollbackFor = {Exception.class,BusinessException.class})
			public PlatformJob finishWork(JobOperateDTO jobOperateDTO){
			@@ -1329,7 +1583,7 @@
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			PlatformJob platformJob = platformJobMapper.selectById(jobOperateDTO.getJobId());
			if(Objects.isNull(platformJob)){
			if(Objects.isNull(platformJob)\|\|Constants.equalsInteger(platformJob.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(! (Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.WORKING.getKey())
			@@ -1352,25 +1606,146 @@
			//存储操作日志
			savePlatformLog(Constants.PlatformJobLogType.DONE.getKey(),oldPlatformJob,platformJob ,
			Constants.PlatformJobLogType.DONE.getInfo());

			//删除报警信息
			platformWarnEventMapper.update(new UpdateWrapper<PlatformWarnEvent>().lambda()
			.set(PlatformWarnEvent::getIsdeleted,Constants.ONE)
			.eq(PlatformWarnEvent::getPlatformId,platformJob.getId())
			);

			if(Constants.equalsInteger(platformJob.getType(),Constants.TWO)){
			//TODO 外协车装货查询TMS 电子锁情况
			if(Constants.equalsInteger(platformJob.getType(),Constants.THREE)){
			// 外协车装货查询TMS 电子锁情况
			List<PlatformWmsDetail> details = platformWmsDetailMapper.selectList(new QueryWrapper<PlatformWmsDetail>().lambda()
			.eq(PlatformWmsDetail::getJobId,platformJob.getId())
			.eq(PlatformWmsDetail::getIsdeleted,Constants.ZERO)
			);
			if(details!=null && details.size()>0){
			Date date = new Date();
			List<String> codeList =new ArrayList<>();
			for(PlatformWmsDetail d : details){
			codeList.add(d.getContractNum());
			}
			TmsLockStatusQueryRequest tmsLock = new TmsLockStatusQueryRequest();
			tmsLock.setContractNumbers(codeList);
			TmsBaseResponse<List<TmsLockStatusQueryResponse>> lockResult = tmsService.lockStatusQuery(tmsLock);
			if(lockResult!=null && lockResult.getCode()!=null && lockResult.getCode().equals("0")&& lockResult.getData()!=null ){
			for(TmsLockStatusQueryResponse s : lockResult.getData()){
			if(StringUtils.isBlank(s.getOutDate())){
			continue;
			}
			platformWmsDetailMapper.update(null,new UpdateWrapper<PlatformWmsDetail>().lambda()
			.eq(PlatformWmsDetail::getContractNum,s.getContractNumber())
			.set(PlatformWmsDetail::getEditDate,date)
			.set(PlatformWmsDetail::getLockDate,s.getOutDate())
			.set(PlatformWmsDetail::getLockStatus,Constants.ONE)
			.eq(PlatformWmsDetail::getIsdeleted,Constants.ZERO));
			}
			}
			}

			}else if(Constants.equalsInteger(platformJob.getType(),Constants.ONE) \|\| Constants.equalsInteger(platformJob.getType(),Constants.FOUR)){
			//TODO 外协车卸货或者市公司车卸货则根据任务情况

			}



			//发送短信信息
			SmsEmailServiceImpl.sendPlatformJobSms(systemDictDataBiz,
			emayService,smsEmailMapper,smsConfigMapper,platformJobMapper,platformJob.getId(),
			SmsConstants.platformJobContent.platformJobFinish,platform.getName(),null
			);

			//公众号模板消息
			if(Objects.nonNull(platformJob.getDrivierPhone())) {
			this.sendWxNotice(WxPlatConstants.platformJobContent.platformJobFinish,platformJob);
			}

			//广播 led通知
			platformJob.setPlatformName(platform.getName());
			this.broadcastAndLEed(platformJob,Constants.PlatformLedContent.DONE.getInfo(),
			this.broadcastAndLEed(platformJob,
			//Constants.PlatformLedContent.DONE.getInfo(),
			StringUtils.isBlank(platform.getLedContent())?Constants.PlatformLedContent.IDEL_CONTNET.getInfo():platform.getLedContent(),
			Constants.PlatformBroadcastContent.DONE.getInfo());
			return platformJob;
			}
			@Override
			public void checkWmsLockStatus(){
			List<PlatformWmsDetail> details = platformWmsDetailMapper.selectJoinList(PlatformWmsDetail.class,new MPJLambdaWrapper<PlatformWmsDetail>()
			.selectAll(PlatformWmsDetail.class)
			.leftJoin(PlatformJob.class,PlatformJob::getId,PlatformWmsDetail::getJobId)
			.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey())//查询已完成作业的
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.and(wr->{wr.isNull(PlatformWmsDetail::getLockStatus).or().eq(PlatformWmsDetail::getLockStatus,Constants.ZERO);})
			.eq(PlatformWmsDetail::getIsdeleted,Constants.ZERO));
			if(details !=null && details.size()>0){
			Date date = new Date();
			List<String> codeList =new ArrayList<>();
			for(PlatformWmsDetail d : details){
			if(StringUtils.isNotBlank(d.getContractNum())){
			if(StringUtils.isNotBlank(d.getContractNum())){
			codeList.add(d.getContractNum());
			}
			}
			}
			List<Integer> jobIds = new ArrayList<>();
			if(codeList.size()>0){
			TmsLockStatusQueryRequest tmsLock = new TmsLockStatusQueryRequest();
			tmsLock.setContractNumbers(codeList);
			TmsBaseResponse<List<TmsLockStatusQueryResponse>> lockResult = tmsService.lockStatusQuery(tmsLock);
			if(lockResult!=null && lockResult.getCode()!=null && lockResult.getCode().equals("0")&& lockResult.getData()!=null ){
			for(TmsLockStatusQueryResponse s : lockResult.getData()){
			try {
			if(StringUtils.isBlank(s.getOutDate())){
			continue;
			}
			//异常处理，能处理一个是一个
			platformWmsDetailMapper.update(null,new UpdateWrapper<PlatformWmsDetail>().lambda()
			.eq(PlatformWmsDetail::getContractNum,s.getContractNumber())
			.set(PlatformWmsDetail::getEditDate,date)
			.set(PlatformWmsDetail::getLockDate,s.getOutDate())
			.set(PlatformWmsDetail::getLockStatus,Constants.ONE)
			.eq(PlatformWmsDetail::getIsdeleted,Constants.ZERO));
			PlatformWmsDetail job = getJobByContractnumFromDetail(s.getContractNumber(),details);
			if(job != null){
			jobIds.add(job.getJobId());
			}
			}catch (Exception e){
			logger.error("=============更新电子锁状态信息异常："+e.getMessage());
			}
			}
			}
			}
			if(jobIds.size()>0){
			List<PlatformJob> list = platformJobMapper.selectJoinList(PlatformJob.class,new MPJLambdaWrapper<PlatformJob>()
			.selectAll(PlatformJob.class)
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey())
			.in(PlatformJob::getId,jobIds)
			);
			if(list!=null){
			for(PlatformJob platformJob : list){
			sendInPark(platformJob);//检查是否需要自动授权离园
			}
			}
			}
			}

			}

			private PlatformWmsJob getJobByContractnum(String contractNumber, List<PlatformWmsJob> details) {
			for(PlatformWmsJob d : details){
			if(StringUtils.equals(contractNumber,d.getContractNum())){
			return d;
			}
			}
			return null;
			}
			private PlatformWmsDetail getJobByContractnumFromDetail(String contractNumber, List<PlatformWmsDetail> details) {
			for(PlatformWmsDetail d : details){
			if(StringUtils.equals(contractNumber,d.getContractNum())){
			return d;
			}
			}
			return null;
			}


			@@ -1385,7 +1760,7 @@
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			PlatformJob platformJob = platformJobMapper.selectById(jobOperateDTO.getJobId());
			if(Objects.isNull(platformJob)){
			if(Objects.isNull(platformJob)\|\|Constants.equalsInteger(platformJob.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(!Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.DONE.getKey())){
			@@ -1429,6 +1804,7 @@
			PlatformJob platformJob = platformJobMapper.selectOne(new QueryWrapper<PlatformJob>().lambda()
			.eq(PlatformJob::getPlatformId,platformDevice.getPlatformId())
			.eq(PlatformJob::getCarCodeBack,jobOperateDTO.getCarCodeBack())
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.CALLED.getKey())
			.last(" limit 1 ")
			);
			@@ -1635,13 +2011,19 @@
			@Override
			public PlatformWorkVO getPlatformWorkVOById(Integer platformId){
			//获取月台下的所有作业数据
			List<PlatformJob> platformJobList = platformJobJoinMapper.selectJoinList(PlatformJob.class,new MPJLambdaWrapper<PlatformJob>()
			List<PlatformJob> allPlatformJobList = platformJobJoinMapper.selectJoinList(PlatformJob.class,new MPJLambdaWrapper<PlatformJob>()
			.selectAll(PlatformJob.class)
			.select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = "+Constants.PlatformJobLogType.WORKING.getKey()+" order by pl.CREATE_DATE desc limit 1 ) as newStartDate ")
			.select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = "+Constants.PlatformJobLogType.CALLED.getKey()+" order by pl.CREATE_DATE desc limit 1 ) as newCallDate ")
			.select(" case when t.total_num is null then ( select sum(pwd.IO_QTY) from platform_wms_detail pwd where pwd.JOB_ID = t.id ) else t.total_num end ioQty ")
			.select(" (select GROUP_CONCAT(distinct(tt.contract_num )) from platform_wms_detail tt where tt.isdeleted=0 and tt.contract_num is not null and tt.job_id=t.id )as wmsContractNum")
			.selectAs(Platform::getName,PlatformJob::getPlatformName)
			.selectAs(Platform::getWorkRate,PlatformJob::getWorkRate)
			.selectAs(PlatformWmsJob::getCarrierName,PlatformJob::getCarrierName)
			.selectAs(PlatformBooks::getId,PlatformJob::getBookId)
			.leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId)
			.leftJoin(PlatformWmsJob.class,PlatformWmsJob::getJobId,PlatformJob::getId)
			.leftJoin(PlatformBooks.class,PlatformBooks::getJobId,PlatformJob::getId)
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.in(PlatformJob::getStatus,
			Constants.PlatformJobStatus.WAIT_CALL.getKey(),
			@@ -1654,13 +2036,13 @@
			)
			.orderByDesc(PlatformJob::getId)
			);
			for (PlatformJob platformJob:platformJobList) {
			//处理WSM数量
			this.getWmsJobData(platformJob);
			//查询前方排队数量
			this.queryWaitNum(platformJob);
			}
			PlatformWorkVO platformWorkVO = PlatformGroupServiceImpl.getPlatformWorkVO(platformJoinMapper.selectById(platformId),platformJobList);
			// List<PlatformJob> platformJobList = allPlatformJobList.stream().filter(i->Constants.equalsInteger(i.getPlatformId(),platformId)).collect(Collectors.toList());
			// for (PlatformJob platformJob:platformJobList) {
			// platformJob.setTotalNum(platformJob.getIoQty());
			// //查询前方排队数量
			// this.queryWaitNum(platformJob);
			// }
			PlatformWorkVO platformWorkVO = PlatformGroupServiceImpl.getPlatformWorkVO(platformJoinMapper.selectById(platformId),allPlatformJobList);
			return platformWorkVO;
			}

			@@ -1681,16 +2063,16 @@
			);
			//查询今日完成任务
			platformOrderNumByDateResponse.setDoneNum(
			platformJobMapper.selectCount(new QueryWrapper<PlatformJob>().lambda()
			platformJobMapper.selectCount(new MPJLambdaWrapper<PlatformJob>()
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.like(PlatformJob::getDoneDate,queryDateStr)
			.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey())
			.in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey()
			,Constants.PlatformJobStatus.AUTHED_LEAVE.getKey()
			,Constants.PlatformJobStatus.LEAVED.getKey())
			)
			);
			return platformOrderNumByDateResponse;
			}



			@Override
			public List<PlatformDataListResponse> platformWorkingDataList(PlatformDataListRequest param){
			@@ -1712,8 +2094,8 @@
			.selectAs(Platform::getWorkRate, PlatformJob::getWorkRate)
			.selectAs(Platform::getName, PlatformJob::getPlatformName)
			.select(" case when t.total_num is null then ( select sum(pwd.IO_QTY) from platform_wms_detail pwd where pwd.JOB_ID = t.id ) else t.total_num end workNum ")
			.select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = 5 order by pl.CREATE_DATE desc limit 1 ) as newStartDate ")
			.select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = 4 order by pl.CREATE_DATE desc limit 1 ) as newCallDate ")
			.select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = "+Constants.PlatformJobLogType.WORKING.getKey()+" order by pl.CREATE_DATE desc limit 1 ) as newStartDate ")
			.select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = "+Constants.PlatformJobLogType.CALLED.getKey()+" order by pl.CREATE_DATE desc limit 1 ) as newCallDate ")
			.leftJoin(Platform.class, Platform::getId, PlatformJob::getPlatformId)
			.eq(PlatformJob::getStatus, Constants.PlatformJobStatus.WORKING.getKey())
			.eq(PlatformJob::getPlatformId, platform.getId())
			@@ -1913,8 +2295,8 @@
			.selectAs(Platform::getName,PlatformJob::getPlatformName)
			.selectAs(PlatformGroup::getWaitCallTime,PlatformJob::getWorktimeOutAlarmTime)
			.select(" case when t.total_num is null then ( select sum(pwd.IO_QTY) from platform_wms_detail pwd where pwd.JOB_ID = t.id ) else t.total_num end workNum ")
			.select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = 5 order by pl.CREATE_DATE desc limit 1 ) as newStartDate ")
			.select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = 4 order by pl.CREATE_DATE desc limit 1 ) as newCallDate ")
			.select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = "+Constants.PlatformJobLogType.WORKING.getKey()+" order by pl.CREATE_DATE desc limit 1 ) as newStartDate ")
			.select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = "+Constants.PlatformJobLogType.CALLED.getKey()+" order by pl.CREATE_DATE desc limit 1 ) as newCallDate ")
			.leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId)
			.leftJoin(PlatformGroup.class,PlatformGroup::getId,Platform::getGroupId)
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			@@ -1948,7 +2330,14 @@
			List<PlatformJob> calledList = platformJobList.stream().filter(i->Constants.equalsInteger(i.getStatus(),Constants.PlatformJobStatus.CALLED.getKey())).collect(Collectors.toList());
			largeScreenDataVO.setWaitWorkList(calledList);
			}
			largeScreenDataVO.setQrCode(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_QRCODE).getCode());
			// String u = (String) redisTemplate.opsForValue().get(Constants.RedisKeys.BIGSCREEN_UUID);
			// if(StringUtils.isBlank(u)){
			String u = UUID.randomUUID().toString();
			redisTemplate.opsForValue().set(Constants.RedisKeys.BIGSCREEN_UUID,u,3, TimeUnit.MINUTES);
			// }
			String url = Constants.getWxUrl(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.WX_REDIRECT_URL).getCode(),Constants.WxUrlParams.BISCREEN_CODE,u);
			largeScreenDataVO.setQrCode(url);
			largeScreenDataVO.setAttention(systemDictDataBiz.queryByCode(Constants.PLATFORM,Constants.SIGN_IN_ATTENTION).getCode());
			return largeScreenDataVO;

			}
			@@ -1998,7 +2387,8 @@
			List<PlatformJob> platformJobList = platformJobJoinMapper.selectJoinList(PlatformJob.class,new MPJLambdaWrapper<PlatformJob>()
			.selectAll(PlatformJob.class)
			.selectAs(Platform::getName,PlatformJob::getPlatformName)
			.select(" ( now() > DATE_ADD( ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = 4 order by pl.CREATE_DATE desc limit 1 ) ,INTERVAL t2.WAIT_CALL_TIME MINUTE) ) as isTimeOut ")
			.select(" ( now() >= DATE_ADD( ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = "+Constants.PlatformJobLogType.CALLED.getKey()+" " +
			"order by pl.CREATE_DATE desc limit 1 ) ,INTERVAL t2.WAIT_CALL_TIME MINUTE) ) as isTimeOut ")
			.leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId)
			.leftJoin(PlatformGroup.class,PlatformGroup::getId,Platform::getGroupId)
			.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.CALLED.getKey())
			@@ -2006,10 +2396,13 @@
			);
			//如果超时处理数据并发送led与广播
			for (PlatformJob platformJob:platformJobList) {
			JobOperateDTO jobOperateDTO = new JobOperateDTO();
			jobOperateDTO.setJobId(platformJob.getId());
			this.platformOverNumber(jobOperateDTO);
			this.cancelInPark(platformJob);
			if(Constants.equalsInteger(platformJob.getIsTimeOut(),Constants.ONE)){
			JobOperateDTO jobOperateDTO = new JobOperateDTO();
			jobOperateDTO.setJobId(platformJob.getId());
			this.platformOverNumber(jobOperateDTO);
			this.cancelInPark(platformJob);
			}

			}
			}

			@@ -2026,7 +2419,7 @@
			.selectAs(Platform::getWorkRate, PlatformJob::getWorkRate)
			.selectAs(Platform::getWorkTimeoutAlarmTime, PlatformJob::getWorktimeOutAlarmTime)
			.select(" case when t.total_num is null then ( select sum(pwd.IO_QTY) from platform_wms_detail pwd where pwd.JOB_ID = t.id ) else t.total_num end workNum ")
			.select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = 5 order by pl.CREATE_DATE desc limit 1 ) as newStartDate ")
			.select(" ( select pl.CREATE_DATE from platform_log pl where t.id = pl.obj_id and pl.OBJ_TYPE = "+Constants.PlatformJobLogType.WORKING.getKey()+" order by pl.CREATE_DATE desc limit 1 ) as newStartDate ")
			.leftJoin(Platform.class,Platform::getId,PlatformJob::getPlatformId)
			.eq(PlatformJob::getStatus,Constants.PlatformJobStatus.WORKING.getKey())
			.eq(PlatformJob::getInOut,Constants.ONE)
			@@ -2053,6 +2446,133 @@
			}


			/**
			* 更换月台分钟
			* @param param
			*/
			@Override
			public void changPlatformGroup(PlatformJob param, LoginUserInfo loginUser){
			if(param.getId() ==null \|\| param.getPlatformGroupId()==null) {
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			PlatformJob model = platformJobMapper.selectById(param.getId());
			if(model ==null \|\| Constants.equalsInteger(model.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(Constants.equalsInteger(model.getType(),Constants.platformJobType.sgscxh)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"【市公司外协车卸货】作业类型不支持月台组切换");
			}
			// WAIT_CONFIRM(0, "待确认","待确认" ),
			// WART_SIGN_IN(1, "待签到","待签到" ),
			// WAIT_CALL(2, "已签到","已签到"),
			if(!Constants.equalsInteger(model.getStatus(),Constants.PlatformJobStatus.WAIT_CONFIRM.getKey())
			&&!Constants.equalsInteger(model.getStatus(),Constants.PlatformJobStatus.WART_SIGN_IN.getKey())
			&&!Constants.equalsInteger(model.getStatus(),Constants.PlatformJobStatus.WAIT_CALL.getKey())){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起,业务状态已流转，不支持月台组切换！");
			}
			PlatformGroup group = platformGroupMapper.selectById(param.getPlatformGroupId());
			if(Objects.isNull(group)\|\| Constants.equalsInteger(group.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到月台组信息");
			}
			if(Constants.equalsInteger(model.getType(),Constants.platformJobType.zycxh)
			\|\|Constants.equalsInteger(model.getType(),Constants.platformJobType.wxcxh)){
			if( ! Constants.equalsInteger(group.getType(),Constants.ZERO)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"该作业只能在【安泰物流卸货】类型的月台组下作业");
			}
			}
			if(Constants.equalsInteger(model.getType(),Constants.platformJobType.zyczh)
			\|\|Constants.equalsInteger(model.getType(),Constants.platformJobType.wxczh)){
			if( ! Constants.equalsInteger(group.getType(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"该作业只能在【安泰物流装货】类型的月台组下作业");
			}
			}
			if(Constants.equalsInteger(model.getType(),Constants.platformJobType.sgscxh)
			&& !Constants.equalsInteger(group.getType(),Constants.TWO)){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"该作业只能在【市公司卸货】类型的月台组下作业");
			}
			PlatformJob platformJob = new PlatformJob();
			BeanUtils.copyProperties(model,platformJob);
			platformJob.setPlatformGroupId(param.getPlatformGroupId());
			platformJob.setEditDate(new Date());
			platformJob.setTagVirtual(Constants.ONE);
			platformJob.setTagVirtualUser(platformJob.getEditor());
			platformJob.setTagVirtualTime(platformJob.getEditDate());
			platformJob.setEditor(loginUser.getId());
			int flag = platformJobMapper.update(null,new UpdateWrapper<PlatformJob>().lambda()
			.set(PlatformJob::getEditDate,platformJob.getEditDate())
			.set(PlatformJob::getTagVirtualTime,platformJob.getTagVirtualTime())
			.set(PlatformJob::getEditor,platformJob.getEditor())
			.set(PlatformJob::getPlatformGroupId,param.getPlatformGroupId())
			.set(PlatformJob::getTagVirtualUser,platformJob.getEditor())
			.set(PlatformJob::getPlatformId,null)//置空分配的月台信息
			.in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CONFIRM.getKey(),
			Constants.PlatformJobStatus.WART_SIGN_IN.getKey(),
			Constants.PlatformJobStatus.WAIT_CALL.getKey())
			.eq(PlatformJob::getId,param.getId()));
			//存储操作日志
			savePlatformLog(Constants.PlatformJobLogType.CHANGE_GROUP.getKey(),model,platformJob,
			Constants.PlatformJobLogType.CHANGE_GROUP.getInfo().replace("{data}",param.getPlatformGroupName()).replace("{data1}",group.getName()));
			}
			/**
			* 手动完成作业
			* @param jobIdList
			*/
			@Override
			public void dealJobFinish(List<Integer> jobIdList,LoginUserInfo loginUserInfo){
			if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(jobIdList)){
			List<PlatformJob> platformJobList = platformJobMapper.selectList(new QueryWrapper<PlatformJob>().lambda()
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CONFIRM.getKey()
			,Constants.PlatformJobStatus.WART_SIGN_IN.getKey()
			,Constants.PlatformJobStatus.WAIT_CALL.getKey())
			.in(PlatformJob::getId,jobIdList)
			);
			if(com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(platformJobList)){
			platformJobMapper.update(null,new UpdateWrapper<PlatformJob>().lambda()
			.set(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey())
			.set(PlatformJob::getDoneDate,new Date())
			.set(PlatformJob::getEditor,loginUserInfo.getId())
			.in(PlatformJob::getStatus,Constants.PlatformJobStatus.WAIT_CONFIRM.getKey(),Constants.PlatformJobStatus.WART_SIGN_IN.getKey(),Constants.PlatformJobStatus.WAIT_CALL.getKey())
			.eq(PlatformJob::getIsdeleted,Constants.ZERO)
			.in(PlatformJob::getId,platformJobList.stream().map(i->i.getId()).collect(Collectors.toList())));
			}

			}


			}

			@Override
			@Transactional(rollbackFor = {Exception.class,BusinessException.class})
			public PlatformJob restoreWork(JobOperateDTO jobOperateDTO){
			if(Objects.isNull(jobOperateDTO)
			\|\| Objects.isNull(jobOperateDTO.getJobId())){
			throw new BusinessException(ResponseStatus.BAD_REQUEST);
			}
			PlatformJob platformJob = platformJobMapper.selectById(jobOperateDTO.getJobId());
			if(Objects.isNull(platformJob)\|\|Constants.equalsInteger(platformJob.getIsdeleted(),Constants.ONE)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY);
			}
			if(!Constants.equalsInteger(platformJob.getStatus(),Constants.PlatformJobStatus.EXCEPTION.getKey())){
			throw new BusinessException(ResponseStatus.NOT_ALLOWED.getCode(),"对不起,业务状态已流转！");
			}
			Platform platform = platformJoinMapper.selectById(platformJob.getPlatformId());
			if(Objects.isNull(platform)){
			throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到月台信息");
			}
			PlatformJob oldPlatformJob = new PlatformJob();
			BeanUtils.copyProperties(platformJob,oldPlatformJob);
			if(Objects.isNull(platformJob.getStartDate())){
			platformJob.setStartDate(new Date());
			}
			platformJob.setStatus(Constants.PlatformJobStatus.WORKING.getKey());
			platformJob.setEditDate(new Date());
			platformJobMapper.updateById(platformJob);

			//存储操作日志
			savePlatformLog(Constants.PlatformJobLogType.WORKING.getKey(),oldPlatformJob,platformJob,
			Constants.PlatformJobLogType.WORKING.getInfo().replace("{data}",platform.getName()));
			return platformJob;
			}

			}