server/system_gateway/src/main/resources/bootstrap.yml
@@ -1,6 +1,6 @@ spring: profiles: active: pro active: dev application: name: system_gateway # å®å ¨é ç½® server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/admin/TmsCloudController.java
@@ -6,10 +6,7 @@ import com.doumee.core.tms.model.request.TmsLockStatusQueryRequest; import com.doumee.core.tms.model.request.TmsOrderInfoRequest; import com.doumee.core.tms.model.request.TmsOrderListRequest; import com.doumee.core.tms.model.response.TmsBaseResponse; import com.doumee.core.tms.model.response.TmsLockStatusQueryResponse; import com.doumee.core.tms.model.response.TmsOrderInfoResponse; import com.doumee.core.tms.model.response.TmsOrderListResponse; import com.doumee.core.tms.model.response.*; import com.doumee.core.utils.Constants; import com.doumee.core.wms.model.response.WmsBaseResponse; import com.doumee.service.business.third.TmsService; @@ -51,7 +48,7 @@ @ApiOperation("ãTMSãååå表æ¥å£") @LoginNoRequired @PostMapping("/orderList") public ApiResponse<List<TmsOrderListResponse>> orderList(@RequestBody TmsOrderListRequest request ) { public ApiResponse<TmsBasePageResponse<TmsOrderListResponse>> orderList(@RequestBody TmsOrderListRequest request ) { return ApiResponse.success(tmsService.orderList(request)); } server/visits/dmvisit_admin/src/main/java/com/doumee/cloud/board/PlatformJobRunActController.java
@@ -2,6 +2,7 @@ import com.doumee.api.BaseController; import com.doumee.config.annotation.LoginNoRequired; import com.doumee.core.haikang.model.cars.response.CarsAlarmResultListResponse; import com.doumee.core.model.ApiResponse; import com.doumee.core.utils.Constants; import com.doumee.dao.business.join.PlatformJobJoinMapper; @@ -71,6 +72,13 @@ BoardCarsListVO data = boardService.platformJobCarsList(); return ApiResponse.success(data); } @LoginNoRequired @ApiOperation("汽车åè¦äºä»¶éåæ°æ®") @GetMapping("/carsEventList") public ApiResponse<List<CarsAlarmResultListResponse>> carsEventList() { List<CarsAlarmResultListResponse> data = boardService.carsEventList(); return ApiResponse.success(data); } @LoginNoRequired @ApiOperation("æ ¹æ®è½¦çå·æ¥è¯¢ä½ä¸ä¿¡æ¯åååä¿¡æ¯éå") server/visits/dmvisit_service/src/main/java/com/doumee/core/haikang/service/HKCarOpenService.java
@@ -34,6 +34,8 @@ private static final String DEFAULT_CHARSET = "UTF-8"; private static final String REGION_ID = "cn-hangzhou"; private static final String VERSION = "2.1.0"; public static List<CarsDeviceDetaisResponse> HK_CARS_LIST= null; public static String BASE_URL = "https://open.hikvisionauto.com:14021/v2/"; private static TreeMap<String, String> getBaseParams() { Map<String, String> params = Maps.newHashMap(); server/visits/dmvisit_service/src/main/java/com/doumee/core/tms/model/TMSContants.java
@@ -14,11 +14,11 @@ String[] getRealTimeInventory = new String[]{"/tms/zhyt/getRealTimeInventory", "ãTMSã宿¶åºåæ¥è¯¢"};//TMS宿¶åºåæ¥è¯¢æ¥å£å°å String[] getInboundOutbound = new String[]{"/tms/zhyt/getInboundOutbound", "ãTMSãåºå ¥åºè®°å½æ¥è¯¢"};//TMSåºå ¥åºè®°å½æ¥è¯¢æ¥å£å°å String[] getIntransitDetails = new String[]{"/tms/zhyt/getIntransitDetails", "ãTMSãå¨éæç»å表"};//TMSå¨éæç»å表æ¥å£å°å String[] getOrderList = new String[]{"/tms/zhyt/getIntransitDetails", "ãTMSãååå表æ¥è¯¢"};//TMSååå表æ¥è¯¢æ¥å£å°å String[] getOrderList = new String[]{"/tms/zhyt/getOrderList", "ãTMSãååå表æ¥è¯¢"};//TMSååå表æ¥è¯¢æ¥å£å°å String[] getElecByContractNumberList = new String[]{"/tms/zhyt/getElecByContractNumberList", "ãTMSãååä¸éç¶æ"};//TMSååä¸éç¶ææ¥å£å°å String[] getOrderDetailByContractNumber = new String[]{"/tms/zhyt/getOrderDetailByContractNumber", "ãTMSãåå详æ "};//TMSååè¯¦æ æ¥å£å°å String[] getGis = new String[]{"/tms/zhyt/getGis", "ãTMSãæ ¹æ®è¿è¾åå·æ¥è¯¢gis轨"};//TMSæ ¹æ®è¿è¾åå·æ¥è¯¢gis轨æ¥å£å°å String[] getOrderStatusByContractNumber = new String[]{";//", "ãTMSãåçå½å¨æ"};//3.8订åçå½å¨æ String[] getOrderStatusByContractNumber = new String[]{"/tms/zhyt/getOrderStatusByContractNumber", "ãTMSãåçå½å¨æ"};//3.8订åçå½å¨æ } public enum TopStatusLevel { server/visits/dmvisit_service/src/main/java/com/doumee/core/tms/model/request/TmsOrderListPagerRequest.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,20 @@ package com.doumee.core.tms.model.request; import io.swagger.annotations.ApiModel; import lombok.Data; import java.util.List; /** * @author æ±è¹è¹ * @date 2023/11/23 14:03 */ @Data @ApiModel("tmsååå表页ç 请æ±åæ°") public class TmsOrderListPagerRequest { private Integer page ;//æ¯ æ°å å½å页 private Integer rows ;//æ¯ æ°å æ¯é¡µæ°æ®éCreateDateTimeEnd;//æªæ¢æ¶é´ } server/visits/dmvisit_service/src/main/java/com/doumee/core/tms/model/request/TmsOrderListParamRequest.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,27 @@ package com.doumee.core.tms.model.request; import io.swagger.annotations.ApiModel; import lombok.Data; import java.util.List; /** * @author æ±è¹è¹ * @date 2023/11/23 14:03 */ @Data @ApiModel("tmsååå表请æ±åæ°") public class TmsOrderListParamRequest { private List<String> permissionDomainIdList; //æ¯ éå åºåIDéå private List<String> contractNumbers; // å¦ éå ååå·éå private String contractNumber; // å¦ ååå·éå private String deliveryEnterprise ;//å¦ å符串 åè´§å° private String receiveEnterprise ;// å¦ å符串 å°è´§å° private String provinceName ;// å¦ å符串 å°è´§å°ç份 private String ncCreateDateTimeEnd;//æªæ¢æ¶é´ private String ncCreateDateTimeStart;// å¼å§æ¶é´ private String phoneNumber ;//å¦ å符串 ææºå· } server/visits/dmvisit_service/src/main/java/com/doumee/core/tms/model/request/TmsOrderListRequest.java
@@ -10,17 +10,11 @@ * @date 2023/11/23 14:03 */ @Data @ApiModel("tmsååå表请æ±åæ°") @ApiModel("tmsååå表å页请æ±åæ°") public class TmsOrderListRequest { private List<String> permissionDomainIdList; //æ¯ éå åºåIDéå private List<String> contractNumbers; // å¦ éå ååå·éå private String fromRepertoty ;//å¦ å符串 åè´§å° private String toRepertoty ;// å¦ å符串 å°è´§å° private String provinceName ;// å¦ å符串 å°è´§å°ç份 private String ncCreateDateTimeEnd;//æªæ¢æ¶é´ private String ncCreateDateTimeStart;// å¼å§æ¶é´ private String phoneNumber ;//å¦ å符串 ææºå· private TmsOrderListParamRequest parameters; //æ¯ éå åºåIDéå private TmsOrderListPagerRequest pager; // å¦ éå ååå·éå } server/visits/dmvisit_service/src/main/java/com/doumee/core/tms/model/response/TmsBasePageResponse.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,16 @@ package com.doumee.core.tms.model.response; import com.alibaba.fastjson.annotation.JSONField; import lombok.Data; import java.util.List; @Data public class TmsBasePageResponse<T> { private int totalCount;// number False æ»è®°å½æ¡æ° private int totalPage;// æ»é¡µæ° Integer private int currentPage ;//å½å页 Integer private int pageSize;// æ¥è¯¢æ°æ®è®°å½æ»æ° Long @JSONField(name="rows",alternateNames = {"results","list"}) private List<T> rows ;// object[] False æéç»å¯¹è±¡å表 } server/visits/dmvisit_service/src/main/java/com/doumee/core/tms/model/response/TmsCircleStatusListResponse.java
@@ -1,6 +1,7 @@ package com.doumee.core.tms.model.response; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; /** @@ -8,17 +9,27 @@ * @date 2023/11/23 14:03 */ @Data @ApiModel("tmsæ ¹æ®ååå·æ¥è¯¢è®¢åçå½å¨æè¿ååæ°") @ApiModel("tmsæ ¹æ®ååå·æ¥è¯¢è®¢åçå½å¨æç¶ææç»è¿ååæ°") public class TmsCircleStatusListResponse { /** */ @ApiModelProperty(value = "订åç¶ææè¿°" ) private String orderStatusDes ;//å符串 订åç¶ææè¿° @ApiModelProperty(value = "ç¶æè®°å½æ¶é´" ) private String recordDate ;//å符串 ç¶æè®°å½æ¶é´ @ApiModelProperty(value = "订åç¶æç " ) private Integer orderStatus;// å符串 订åç¶æç @ApiModelProperty(value = "订åç¶æè®°å½ç±»å" ) private Integer type;// å符串 订åç¶æè®°å½ç±»å @ApiModelProperty(value = "æ¤éåå " ) private String canCelReason;// å符串 æ¤éåå @ApiModelProperty(value = "å·ç " ) private String tel ;//å符串 å·ç @ApiModelProperty(value = "订åç¶æå¯ä¸æ è¯" ) private Integer statusKey;// å符串 订åç¶æç private long timeStamp;// } server/visits/dmvisit_service/src/main/java/com/doumee/core/tms/model/response/TmsCircleStatusResultListResponse.java
@@ -1,6 +1,7 @@ package com.doumee.core.tms.model.response; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.List; @@ -14,9 +15,11 @@ public class TmsCircleStatusResultListResponse { /** */ private Integer key ;//å符串 ç¶æè®°å½æ¶é´ private String name ;//å符串 订åç¶æç @ApiModelProperty(value = "ç´¢å¼å¼" ) private int key ;//å符串 ç¶æè®°å½æ¶é´ @ApiModelProperty(value = "é¶æ®µåç§°" ) private String name ;//å符串 @ApiModelProperty(value = "äºç´æ°æ®éå" ) private List<TmsCircleStatusListResponse> secondList ;//äºç´æ°æ®éå } server/visits/dmvisit_service/src/main/java/com/doumee/core/tms/model/response/TmsOrderInfoResponse.java
@@ -1,6 +1,7 @@ package com.doumee.core.tms.model.response; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.List; @@ -13,22 +14,42 @@ @ApiModel("tmsåå详æ è¿ååæ°") public class TmsOrderInfoResponse { @ApiModelProperty(value = "ååå·" ) private String contractNumber ; //ååå· @ApiModelProperty(value = "åè´§å°" ) private String deliveryEnterprise ; //åè´§å° @ApiModelProperty(value = "å°è´§å°" ) private String receiveEnterprise ; //å°è´§å° private String plateNumber; // 车çå· ååæªé è½½åæ // @ApiModelProperty(value = "车çå·" ) // private String plateNumber; // 车çå· ååæªé è½½åæ @ApiModelProperty(value = "å½åè¿è¾åç¶æ" ) private String orderStatus ; //å½åè¿è¾åç¶æ @ApiModelProperty(value = "å¶åæ¶é´" ) private String ncCreateDate; // å¶åæ¶é´ @ApiModelProperty(value = "è¿è¾å¦æ" ) private String transportDate; // @ApiModelProperty(value = "è¿è¾åå·" ) private String transportCode; // @ApiModelProperty(value = "叿ºå§å" ) private String driverName; // @ApiModelProperty(value = "叿ºçµè¯" ) private String driverTel; // @ApiModelProperty(value = "ç¶ææè¿°" ) private String orderStatusDesc; // @ApiModelProperty(value = "车çå·" ) private String plateName; //": "çCC2585", @ApiModelProperty(value = "åè´§ä»åºç»åº¦" ) private String deliveryLon ; // åè´§ä»åºç»åº¦ @ApiModelProperty(value = "åè´§ä»åºçº¬åº¦" ) private String deliveryLat ; // åè´§ä»åºçº¬åº¦ @ApiModelProperty(value = "å¸è´§ä»åºç»åº¦" ) private String receiveLon ; // å¸è´§ä»åºç»åº¦ @ApiModelProperty(value = "å¸è´§ä»åºçº¬åº¦" ) private String receiveLat; // å¸è´§ä»åºçº¬åº¦ @ApiModelProperty(value = "计åå°è¾¾æ¶é´" ) private String plannedArrivedDate; // 计åå°è¾¾æ¶é´ @ApiModelProperty(value = "gis轨迹ç»çº¬åº¦éå" ) private List<TmsGisListResponse> gisList; @ApiModelProperty(value = "çå½å¨æéå" ) private List<TmsCircleStatusResultListResponse> cicleStatusList; } server/visits/dmvisit_service/src/main/java/com/doumee/core/tms/model/response/TmsOrderListResponse.java
@@ -1,6 +1,7 @@ package com.doumee.core.tms.model.response; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.List; @@ -27,18 +28,36 @@ "message": "æä½æå" } */ @ApiModelProperty(value = "ååå·" ) private String contractNumber; // ååå· @ApiModelProperty(value = "åè´§å°" ) private String fromRepertoty; // åè´§å° @ApiModelProperty(value = "å°è´§å°" ) private String toRepertoty ; //å°è´§å° private String plateNumber; // 车çå· ååæªé è½½åæ @ApiModelProperty(value = "车çå·" ) private String plateName; // 车çå· ååæªé è½½åæ @ApiModelProperty(value = "å½åè¿è¾åç¶æ" ) private String orderStatus; // å½åè¿è¾åç¶æ @ApiModelProperty(value = "å¶åæ¶é´" ) private String ncCreateDate; // å¶åæ¶é´ @ApiModelProperty(value = "åè´§å°" ) private String deliveryEnterprise; // åè´§å° åè´§ä»åºåç§° @ApiModelProperty(value = "å°è´§å°" ) private String receiveEnterprise; // å°è´§å° å¸è´§ä»åºåç§° private String deliveryLon ; // åè´§ä»åºç»åº¦ private String deliveryLat ; // åè´§ä»åºçº¬åº¦ private String receiveLon ; // å¸è´§ä»åºç»åº¦ private String receiveLat; // å¸è´§ä»åºçº¬åº¦ @ApiModelProperty(value = "è¿è¾åå·" ) private String transportCode; // è¿è¾åå· å¯è½ä¸ºç©ºï¼æ è¿è¾åçæ åµï¼ @ApiModelProperty(value = "ç¶ææè¿°" ) private String orderStatusDesc; // ç¶ææè¿° @ApiModelProperty(value = "åè´§å°çº¬åº¦" ) private String deliveryLon; // ç¶ææè¿° @ApiModelProperty(value = "åè´§å°ç»åº¦" ) private String deliveryLat; // ç¶ææè¿° @ApiModelProperty(value = "æ¶è´§å°çº¬åº¦" ) private String receiveLon; // ç¶ææè¿° @ApiModelProperty(value = "æ¶è´§å°ç»åº¦" ) private String receiveLat; // ç¶ææè¿° @ApiModelProperty(value = "计åå°è¾¾æ¶é´" ) private String plannedArrivedDate; // ç¶ææè¿° private long timeStamp;//æ¶é´æ³ } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/hksync/HkSyncNoticeServiceImpl.java
@@ -58,6 +58,19 @@ } Constants.DEALING_HK_NOTICE_LIST =true; try { List<String> users = new ArrayList<>(); users.add(username); List<Integer> userIds = new ArrayList<>(); List<Member > userList = memberMapper.selectList(new QueryWrapper<Member>().lambda() .in(Member::getPhone,users) .eq(Member::getType,Constants.TWO) .eq(Member::getIsdeleted,Constants.ZERO)); Member tu= getFromUserList(username,userList); if(tu!=null){ userIds.add(tu.getId()); }else{ throw new BusinessException(ResponseStatus.SERVER_ERROR.getCode(), "对ä¸èµ·ï¼æ æè´¦å·~"); } Date date = new Date(); List<GetTodoListResponse> allHkList = new ArrayList<>(); boolean hasNext = true; @@ -88,16 +101,10 @@ } curPage++; } if(allHkList!=null && allHkList.size()>0){ List<Notices> list = new ArrayList<>(); List<String> users = new ArrayList<>(); for(GetTodoListResponse data :allHkList){ users.add(data.getUserId()); } List<Integer> userIds = new ArrayList<>(); List<Member > userList = memberMapper.selectList(new QueryWrapper<Member>().lambda() .in(Member::getPhone,users) .eq(Member::getIsdeleted,Constants.ZERO)); for(GetTodoListResponse data :allHkList){ Member u = getFromUserList(data.getUserId(),userList); if(u==null){ @@ -133,13 +140,16 @@ list.add(notices); } if(list.size()>0){ noticesJoinMapper.insert(list);//æ¹éæå ¥è®°å½ } } if(userIds.size()>0){ //æ¸ ç©ºæµ·åº·å ¨é¨çä»£åæ°æ® noticesJoinMapper.delete(new UpdateWrapper<Notices>().lambda() .eq(Notices::getType, Constants.noticesObjectType.hknotice) .in(Notices::getUserId, userIds)); noticesJoinMapper.insert(list);//æ¹éæå ¥è®°å½ } } }catch (Exception e){ e.printStackTrace(); }finally { server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/BoardServiceImpl.java
@@ -182,7 +182,7 @@ toatalNum =1; } data.setTotalNum(new BigDecimal(toatalNum)); data.setUseRate(data.getTotalNum().divide(data.getNum(),2,BigDecimal.ROUND_UP)); data.setUseRate(Constants.formatBigdecimal(data.getNum()).divide(data.getTotalNum(),2,BigDecimal.ROUND_UP)); return data; } @@ -670,6 +670,7 @@ List<PlatformJob> dataList = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) .selectAs(PlatformJob::getCreateDate,PlatformJob::getCreateDate) .selectAs(PlatformJob::getTotalNum,PlatformJob::getTotalNum) // .select("select sum(io_qty) from platform_wms_details a where a.isdeleted=0 and a.job_id=t.id",create_date) .eq(PlatformJob::getIsdeleted,Constants.ZERO) @@ -680,7 +681,7 @@ TransportMeasureVO data = new TransportMeasureVO(); data.setPlanDate(date); data.setPlanTimes(0); data.setPlanTaskNum(new BigDecimal(random.nextInt(0))); data.setPlanTaskNum(new BigDecimal( 0)); data.setFinishTaskNum(new BigDecimal(0)); for(PlatformJob job :dataList){ if(queryType == 2){ @@ -849,42 +850,48 @@ List<PlatformJob> monthNum = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) .select(PlatformJob::getType,PlatformJob::getType) .select(PlatformJob::getTotalNum,PlatformJob::getTotalNum) // .select("select sum(io_qty) from platform_wms_details a where a.isdeleted=0 and a.job_id=t.id",create_date) .select(PlatformJob::getStatus,PlatformJob::getStatus) .eq(PlatformJob::getIsdeleted,Constants.ZERO) // .in(PlatformJob::getType,Constants.ONE,Constants.THREE) .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey()) .apply("year(create_date) = year("+DateUtil.getPlusTime2(month)+") and month(create_date) = month("+DateUtil.getPlusTime2(month)+") and to_days(create_date)<= "+DateUtil.getPlusTime2(month))); .apply("year(done_date) = year('"+DateUtil.getPlusTime2(month)+"') and month(done_date) = month('"+DateUtil.getPlusTime2(month)+"') ")); List<PlatformJob> monthLastNum = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) .selectAs(PlatformJob::getTotalNum,PlatformJob::getTotalNum) .select(PlatformJob::getType,PlatformJob::getType) .select(PlatformJob::getStatus,PlatformJob::getStatus) // .select("select sum(io_qty) from platform_wms_details a where a.isdeleted=0 and a.job_id=t.id",create_date) .eq(PlatformJob::getIsdeleted,Constants.ZERO) .in(PlatformJob::getType,Constants.ONE,Constants.THREE) .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey()) .apply("year(create_date) = year("+DateUtil.getPlusTime2(lastMonth)+") and month(create_date) = month("+DateUtil.getPlusTime2(lastMonth)+") and to_days(create_date)<= "+DateUtil.getPlusTime2(lastMonth))); .apply("year(done_date) = year('"+DateUtil.getPlusTime2(lastMonth)+"') and month(done_date) = month('"+DateUtil.getPlusTime2(lastMonth)+"') and done_date<= '" +DateUtil.getPlusTime2(lastMonth)+"'")); List<PlatformJob> yearNum = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) .select(PlatformJob::getTotalNum,PlatformJob::getTotalNum) .selectCount(PlatformJob::getPlatformId,PlatformJob::getCountum) // .select("select sum(io_qty) from platform_wms_details a where a.isdeleted=0 and a.job_id=t.id",create_date) .selectAs(PlatformJob::getTotalNum,PlatformJob::getTotalNum) .select(PlatformJob::getStatus,PlatformJob::getStatus) .select(PlatformJob::getType,PlatformJob::getType) // .selectCount(PlatformJob::getPlatformId,PlatformJob::getCountum) .eq(PlatformJob::getIsdeleted,Constants.ZERO) .in(PlatformJob::getType,Constants.ONE,Constants.THREE) .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey()) .apply("year(create_date) = year("+DateUtil.getPlusTime2(year)+") and to_days(create_date)<= "+DateUtil.getPlusTime2(year))); .apply("year(done_date) = year('"+DateUtil.getPlusTime2(year)+"') and done_date<= '"+DateUtil.getPlusTime2(year)+"'")); List<PlatformJob> yearLastNum = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) .selectAs(PlatformJob::getType,PlatformJob::getId) .select(PlatformJob::getStatus,PlatformJob::getStatus) .select(PlatformJob::getTotalNum,PlatformJob::getTotalNum) // .select("select sum(io_qty) from platform_wms_details a where a.isdeleted=0 and a.job_id=t.id",create_date) .eq(PlatformJob::getIsdeleted,Constants.ZERO) .in(PlatformJob::getType,Constants.ONE,Constants.THREE) .in(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey()) .apply("year(create_date) = year("+DateUtil.getPlusTime2(lastYear)+") and to_days(create_date)<= "+DateUtil.getPlusTime2(lastYear))); .apply("year(done_date) = year('"+DateUtil.getPlusTime2(lastYear)+"') and done_date<= '"+DateUtil.getPlusTime2(lastYear)+"'")); data.setMonthOutTotal(getSumTotalByList(monthNum,0,null));//æ¬æåºåºé data.setMonthLastOutTotal(getSumTotalByList(monthLastNum,null,null) );//䏿åºåºé data.setMonthLastOutTotal(getSumTotalByList(monthLastNum,null,null) );//䏿åºåºé data.setYearOutTotal(getSumTotalByList(yearNum,null,null) );//æ¬å¹´åºåºé data.setYearLastOutTotal(getSumTotalByList(yearLastNum,null,null) );//å»å¹´åºåºé data.setMonthOutTimes(monthNum!=null?monthNum.size():0); @@ -900,19 +907,30 @@ // .select("select sum(io_qty) from platform_wms_details a where a.isdeleted=0 and a.job_id=t.id",create_date) .eq(PlatformJob::getIsdeleted,Constants.ZERO) .notIn(PlatformJob::getStatus,Constants.PlatformJobStatus.DONE.getKey(),Constants.PlatformJobStatus.LEAVED.getKey(),Constants.PlatformJobStatus.AUTHED_LEAVE.getKey(),Constants.PlatformJobStatus.CALLED.getKey()) .apply(" and to_days(create_date) <to_days(now())")); .apply(" to_days(create_date) <to_days(now())")); //==========ä»å¤©åºå ¥åºä»»å¡ List<PlatformJob> currentNum = platformJobMapper.selectJoinList(PlatformJob.class, //==========ä»å¤©åºå ¥åºå®æé List<PlatformJob> currentDoneNum = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) .selectAs(PlatformJob::getStatus,PlatformJob::getStatus) .selectAs(PlatformJob::getType,PlatformJob::getType) .selectAs(PlatformJob::getStatus,PlatformJob::getStatus) .select(PlatformJob::getTotalNum,PlatformJob::getTotalNum) // .select("select sum(io_qty) from platform_wms_details a where a.isdeleted=0 and a.job_id=t.id",create_date) .eq(PlatformJob::getIsdeleted,Constants.ZERO) .notIn(PlatformJob::getStatus,Constants.PlatformJobStatus.CALLED.getKey()) .apply("year(create_date) = year("+DateUtil.getPlusTime2(lastYear)+") and to_days(create_date)<= "+DateUtil.getPlusTime2(lastYear))); .apply(" to_days(done_date) = to_days(now())")); //==========ä»å¤©ä¸ååºå ¥åºä»»å¡---- List<PlatformJob> currentNum = platformJobMapper.selectJoinList(PlatformJob.class, new MPJLambdaWrapper<PlatformJob>() .selectAs(PlatformJob::getId,PlatformJob::getId) .selectAs(PlatformJob::getType,PlatformJob::getType) .selectAs(PlatformJob::getStatus,PlatformJob::getStatus) .select(PlatformJob::getTotalNum,PlatformJob::getTotalNum) // .select("select sum(io_qty) from platform_wms_details a where a.isdeleted=0 and a.job_id=t.id",create_date) .eq(PlatformJob::getIsdeleted,Constants.ZERO) .notIn(PlatformJob::getStatus,Constants.PlatformJobStatus.CALLED.getKey()) .apply(" to_days(create_date) = to_days(now())")); BigDecimal beforeOutNum = (getSumTotalByList(beforeJobNum,0,null));//ä»å¤©ä¹åæªå®æåºåºä»»å¡ BigDecimal currentOutNum = (getSumTotalByList(currentNum,0,null));//ä»å¤©ä¸ååºåºä»»å¡ @@ -920,8 +938,8 @@ BigDecimal currentInNum = (getSumTotalByList(currentNum,1,null));//ä»å¤©ä¸åå ¥åºä»»å¡ data.setCurrentInNum(beforeInNum.add(currentInNum));//å½åå ¥åºæ»ä»»å¡æé data.setCurrentOutNum(beforeOutNum.add(currentOutNum));//å½ååºåºæ»ä»»å¡æé data.setCurrentInDoneNum(getSumTotalByList(currentNum,0,1));//仿¥å®æé data.setCurrentOutDoneNum(getSumTotalByList(currentNum,1,1));//仿¥å®æé data.setCurrentInDoneNum(getSumTotalByList(currentDoneNum,0,1));//仿¥å®æé data.setCurrentOutDoneNum(getSumTotalByList(currentDoneNum,1,1));//仿¥å®æé //------------仿¥åºå ¥åºæç---------------- BigDecimal outHours = getTotalDoneTimes(currentNum,0);// @@ -933,15 +951,15 @@ data.setTodayInRate(data.getCurrentInDoneNum().divide(inHours,2));//å½åå ¥åºæ»ä»»å¡æé } //------------æ¬æåºå ¥åºæç---------------- BigDecimal outMonthNum = getSumTotalByList(monthNum,0,null).add(data.getCurrentOutDoneNum()); // BigDecimal outMonthNum = getSumTotalByList(monthNum,0,null).add(data.getCurrentOutDoneNum()); BigDecimal inMonthNum = getSumTotalByList(monthNum,1,null).add(data.getCurrentInDoneNum()); BigDecimal outYearHours = getTotalDoneTimes(yearNum,0).add(outHours);// BigDecimal inYearHours = getTotalDoneTimes(yearNum,1).add(inHours);// if(outYearHours.compareTo(new BigDecimal(0))>0){ data.setMonthOutRate(outMonthNum.divide(outYearHours,2));//æ¬æå ¥åºæç BigDecimal outMonthHours = getTotalDoneTimes(monthNum,0).add(outHours);// BigDecimal inMonthHours = getTotalDoneTimes(monthNum,1).add(inHours);// if(outMonthHours.compareTo(new BigDecimal(0))>0){ data.setMonthOutRate(data.getMonthOutTotal().divide(outMonthHours,0,BigDecimal.ROUND_HALF_UP));//æ¬æå ¥åºæç } if(inYearHours.compareTo(new BigDecimal(0))>0){ data.setMonthInRate(inMonthNum.divide(inYearHours,2));//æ¬æå ¥åºæç if(inMonthHours.compareTo(new BigDecimal(0))>0){ data.setMonthInRate(inMonthNum.divide(inMonthHours,0,BigDecimal.ROUND_HALF_UP));//æ¬æå ¥åºæç } return data; } @@ -1015,12 +1033,20 @@ // if(Constants.formatBigdecimal(job.getIoQty()).compareTo(new BigDecimal(0)) >0){ // r.add( job.getIoQty()); // }else{ r.add(Constants.formatBigdecimal(job.getTotalNum())); r = r.add(Constants.formatBigdecimal(job.getTotalNum())); // } } return Constants.formatBigdecimal0Float(r); } @Override public List<CarsAlarmResultListResponse> carsEventList(){ if(HKCarOpenService.HK_CARS_LIST == null){ HKCarOpenService.HK_CARS_LIST = HKCarOpenService.getAllCarsDetais(); } return HKCarOpenService.getAlarmEvemtList( HKCarOpenService.HK_CARS_LIST,new Date()); } @Override public BoardCarsListVO platformJobCarsList(){ BoardCarsListVO data = new BoardCarsListVO(); @@ -1057,7 +1083,8 @@ .groupBy(PlatformJob::getCarCodeFront)); data.setBusyNum( busyNum!=null ?busyNum.size():0);//å¨éæä»»å¡æ°é data.setIdleNum(codes.size() -data.getBusyNum());//æ ä»»å¡ç©ºé²æ°é data.setEventList(HKCarOpenService.getAlarmEvemtList(detaisResponses,new Date())); HKCarOpenService.HK_CARS_LIST = detaisResponses; // data.setEventList(HKCarOpenService.getAlarmEvemtList(detaisResponses,new Date())); if(busyNum != null){ FLAG: for(CarsDeviceDetaisResponse model:detaisResponses){ for(PlatformJob job : busyNum){ server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/thrid/TmsServiceImpl.java
@@ -9,6 +9,7 @@ import com.doumee.core.tms.model.request.*; import com.doumee.core.tms.model.response.*; import com.doumee.core.utils.Constants; import com.doumee.core.utils.DateUtil; import com.doumee.core.utils.HttpsUtil; import com.doumee.core.wms.model.request.*; import com.doumee.core.wms.model.response.WmsBaseDataResponse; @@ -154,7 +155,9 @@ } } } Collections.sort(list, (o1, o2) -> { return o2.getKey() - o1.getKey(); //ææ°éä»å¤§å°å°æåº }); return list; } @@ -169,19 +172,26 @@ for(TmsCircleStatusListResponse status :data){ if(Constants.equalsInteger(status.getOrderStatus(),Constants.FOUR) && Constants.equalsInteger(status.getType(),TMSContants.StatusCode.app)) { status.setOrderStatus(TMSContants.ChildStatusLevel.clqdapp.getKey()); status.setOrderStatus(TMSContants.ChildStatusLevel.clqdapp.getOrderStatus()); } if(Constants.equalsInteger(status.getOrderStatus(),Constants.FIVE) && Constants.equalsInteger(status.getType(),TMSContants.StatusCode.app)) { status.setOrderStatus(TMSContants.ChildStatusLevel.ddzhd.getKey()); status.setOrderStatus(TMSContants.ChildStatusLevel.ddzhd.getOrderStatus()); } if(Constants.equalsInteger(status.getOrderStatus(),t )){ status.setOrderStatusDes(TMSContants.ChildStatusLevel.getInfo(status.getOrderStatus(),null)); list.add(status); } Date td =DateUtil.fromStringToDate("yyy-MM-dd HH:mm:ss",status.getRecordDate()); if(td!=null){ status.setTimeStamp(td.getTime()); } } } } Collections.sort(list, (o1, o2) -> { return (int) (o2.getTimeStamp() - o1.getTimeStamp()); //ææ°éä»å¤§å°å°æåº }); return list; } @@ -192,21 +202,36 @@ * @return TmsBaseResponse */ @Override public List<TmsOrderListResponse> orderList(TmsOrderListRequest param){ if(StringUtils.isBlank(param.getPhoneNumber())){ param.setPhoneNumber("00000000000");//ææºå·å¿ å¡« public TmsBasePageResponse<TmsOrderListResponse> orderList(TmsOrderListRequest param){ if(param == null){ param = new TmsOrderListRequest(); } if(param.getContractNumbers()==null || param.getContractNumbers().size()==0){ param.setContractNumbers(null); if(param.getParameters() == null){ param.setParameters( new TmsOrderListParamRequest()); } if(param.getPager() == null){ param.setPager( new TmsOrderListPagerRequest()); } if(param.getPager().getPage() == null){ param.getPager().setPage(1); } if(param.getPager().getRows() == null){ param.getPager().setRows(10); } if(StringUtils.isBlank(param.getParameters().getPhoneNumber())){ param.getParameters().setPhoneNumber("00000000000");//ææºå·å¿ å¡« } if(param.getParameters().getContractNumbers()==null || param.getParameters().getContractNumbers().size()==0){ param.getParameters().setContractNumbers(null); } String url = systemDictDataBiz.queryByCode(Constants.TSM_PARAM,Constants.TMS_INTERFACE_URL_PREFIX).getCode() +TMSContants.InterfacePath.getOrderList[0]; TmsBaseResponse<List<TmsOrderListResponse>> response = sendHttpRequest(url,TMSContants.InterfacePath.getOrderList[1],JSONObject.toJSONString(param) ,new TypeReference< TmsBaseResponse<List<TmsOrderListResponse>>>(){}); TmsBaseResponse<TmsBasePageResponse<TmsOrderListResponse>> response = sendHttpRequest(url,TMSContants.InterfacePath.getOrderList[1],JSONObject.toJSONString(param) ,new TypeReference< TmsBaseResponse<TmsBasePageResponse<TmsOrderListResponse>>>(){}); if(response ==null){ return new ArrayList<>(); return new TmsBasePageResponse<>(); }else{ return response.getData()==null?new ArrayList<>():response.getData(); return response.getData()==null?new TmsBasePageResponse<>():response.getData(); } } /** @@ -222,7 +247,7 @@ } String url = systemDictDataBiz.queryByCode(Constants.TSM_PARAM,Constants.TMS_INTERFACE_URL_PREFIX).getCode() +TMSContants.InterfacePath.getOrderDetailByContractNumber[0]; TmsBaseResponse<TmsOrderInfoResponse> response = sendHttpRequest(url,TMSContants.InterfacePath.getOrderDetailByContractNumber[1],JSONObject.toJSONString(param) TmsBaseResponse<TmsOrderInfoResponse> response = sendHttpRequest(url,TMSContants.InterfacePath.getOrderDetailByContractNumber[1],param.getContractNumber() ,new TypeReference< TmsBaseResponse<TmsOrderInfoResponse>>(){}); if(response!=null && response.getData()!=null){ result =response.getData(); server/visits/dmvisit_service/src/main/java/com/doumee/service/business/third/BoardService.java
@@ -1,5 +1,6 @@ package com.doumee.service.business.third; import com.doumee.core.haikang.model.cars.response.CarsAlarmResultListResponse; import com.doumee.core.haikang.model.param.respose.PageFireChannelInfoResponse; import com.doumee.core.haikang.model.param.respose.PageRegionInfoResponse; import com.doumee.core.haikang.model.param.respose.PageSensorStatusResponse; @@ -89,4 +90,6 @@ BoardStockListVO stockList(); List<GeneralVO> todayTotalInList(); List<CarsAlarmResultListResponse> carsEventList(); } server/visits/dmvisit_service/src/main/java/com/doumee/service/business/third/TmsService.java
@@ -34,7 +34,7 @@ * @param param åæ° * @return TmsBaseResponse */ List<TmsOrderListResponse> orderList(TmsOrderListRequest param); TmsBasePageResponse<TmsOrderListResponse> orderList(TmsOrderListRequest param); List<TmsGisListResponse> gisList(TmsGisListRequest param); List<TmsCircleStatusResultListResponse> getCicleStatusList(TmsCircleStatusListRequest param); /**