已添加1个文件
已删除4个文件
已修改36个文件
已重命名1个文件
| | |
| | | export function pageDriverList (data) { |
| | | return request.post('/visitsAdmin/cloudService/system/user/pageDriver', data) |
| | | } |
| | | export function findAllList (data) { |
| | | return request.post('/visitsAdmin/cloudService/system/user/findAllList', data) |
| | | } |
| | | |
| | | // æ°å»º |
| | | export function create (data) { |
| | |
| | | <el-button v-if="row.meetingStatus == '1'" type="text" |
| | | @click="$refs.operaBookingsWindow.open('ç¼è¾ä¼è®®é¢çº¦', row)" |
| | | v-permissions="['business:bookings:update']">ç¼è¾</el-button> |
| | | <el-button type="text" v-if="row.meetingStatus == '1'" @click="handleStart(row)">å¼å§</el-button> |
| | | <el-button type="text" v-if="row.meetingStatus == '1' || row.meetingStatus == '4'" @click="handleStart(row)">å¼å§</el-button> |
| | | <el-button type="text" v-if="row.meetingStatus == '2'" @click="handleEnd(row)">ç»æ</el-button> |
| | | <el-button v-if="row.meetingStatus == '1'" type="text" @click="cancelMeeting(row.id)" |
| | | <el-button v-if="row.meetingStatus == '1' || row.meetingStatus == '4'" type="text" @click="cancelMeeting(row.id)" |
| | | v-permissions="['business:bookings:update']">æ¤å</el-button> |
| | | </template> |
| | | <!-- <el-button v-else type="text" @click="deleteById(row)" v-permissions="['business:bookings:delete']">å é¤</el-button> --> |
| | |
| | | @ApiOperation(value = "彿ä¼è®®è¡¨", notes = "彿ä¼è®®è¡¨") |
| | | @GetMapping("/monthMeeting") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(paramType = "query", dataType = "String", name = "yearMonth", value = "å¹´æ yyyy-MM", required = true) |
| | | @ApiImplicitParam(paramType = "query", dataType = "String", name = "yearMonth", value = "å¹´æ yyyy-MM", required = true), |
| | | @ApiImplicitParam(paramType = "query", dataType = "String", name = "queryType", value = "æ¥è¯¢ç±»å«ï¼1=æåä¸çï¼2=æé¢çº¦çï¼3管ç忥çå
¨é¨ ", required = true) |
| | | }) |
| | | public ApiResponse<List<MonthDataResponse>> monthDay(@RequestParam String yearMonth) { |
| | | public ApiResponse<List<MonthDataResponse>> monthDay(@RequestParam String yearMonth |
| | | ,@RequestParam(required = false) Integer queryType) { |
| | | LoginUserInfo user = getLoginUser(null); |
| | | List<String> dataList = DateUtil.getDayByMonth(yearMonth); |
| | | List<MonthDataResponse> monthDataResponseList = new ArrayList<>(); |
| | | List<Bookings> bookings = bookingsService.getMyBookings(user.getId(),yearMonth); |
| | | List<Bookings> bookings = bookingsService.getMyBookings(user.getId(),yearMonth,queryType); |
| | | for (String str:dataList) { |
| | | MonthDataResponse monthDataResponse = new MonthDataResponse(); |
| | | monthDataResponse.setWeekMsg(DateUtil.getWeek(DateUtil.StringToDate(str,"yyyy-MM-dd")).getChineseName()); |
| | |
| | | @ApiOperation(value = "彿ä¼è®®è¡¨", notes = "彿ä¼è®®è¡¨") |
| | | @GetMapping("/monthMeeting") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(paramType = "header", dataType = "String", name = "token", value = "ç¨æ·tokenå¼", required = true), |
| | | @ApiImplicitParam(paramType = "query", dataType = "String", name = "yearMonth", value = "å¹´æ yyyy-MM", required = true) |
| | | @ApiImplicitParam(paramType = "query", dataType = "String", name = "yearMonth", value = "å¹´æ yyyy-MM", required = true), |
| | | @ApiImplicitParam(paramType = "query", dataType = "String", name = "queryType", value = "æ¥è¯¢ç±»å«ï¼1=æåä¸çï¼2=æé¢çº¦çï¼3管ç忥çå
¨é¨ ", required = true) |
| | | }) |
| | | public ApiResponse<List<MonthDataResponse>> monthDay(@RequestParam String yearMonth, @RequestHeader(Constants.HEADER_USER_TOKEN) String token) { |
| | | public ApiResponse<List<MonthDataResponse>> monthDay(@RequestParam String yearMonth |
| | | ,@RequestParam(required = false) Integer queryType |
| | | ,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { |
| | | LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); |
| | | List<String> dataList = DateUtil.getDayByMonth(yearMonth); |
| | | List<MonthDataResponse> monthDataResponseList = new ArrayList<>(); |
| | | List<Bookings> bookings = bookingsService.getMyBookings(user.getId(),yearMonth); |
| | | List<Bookings> bookings = bookingsService.getMyBookings(user.getId(),yearMonth,queryType); |
| | | for (String str:dataList) { |
| | | MonthDataResponse monthDataResponse = new MonthDataResponse(); |
| | | monthDataResponse.setWeekMsg(DateUtil.getWeek(DateUtil.StringToDate(str,"yyyy-MM-dd")).getChineseName()); |
| | |
| | | @ApiOperation(value = "彿ä¼è®®è¡¨", notes = "彿ä¼è®®è¡¨") |
| | | @GetMapping("/monthMeeting") |
| | | @ApiImplicitParams({ |
| | | @ApiImplicitParam(paramType = "query", dataType = "String", name = "yearMonth", value = "å¹´æ yyyy-MM", required = true) |
| | | @ApiImplicitParam(paramType = "query", dataType = "String", name = "yearMonth", value = "å¹´æ yyyy-MM", required = true), |
| | | @ApiImplicitParam(paramType = "query", dataType = "String", name = "queryType", value = "æ¥è¯¢ç±»å«ï¼1=æåä¸çï¼2=æé¢çº¦çï¼3管ç忥çå
¨é¨ ", required = true) |
| | | }) |
| | | public ApiResponse<List<MonthDataResponse>> monthDay(@RequestParam String yearMonth |
| | | ,@RequestParam(required = false) Integer queryType |
| | | ,@RequestHeader(Constants.HEADER_USER_TOKEN) String token) { |
| | | LoginUserInfo user = getLoginUser(token); |
| | | List<String> dataList = DateUtil.getDayByMonth(yearMonth); |
| | | List<MonthDataResponse> monthDataResponseList = new ArrayList<>(); |
| | | List<Bookings> bookings = bookingsService.getMyBookings(user.getId(),yearMonth); |
| | | List<Bookings> bookings = bookingsService.getMyBookings(user.getId(),yearMonth,queryType); |
| | | for (String str:dataList) { |
| | | MonthDataResponse monthDataResponse = new MonthDataResponse(); |
| | | monthDataResponse.setWeekMsg(DateUtil.getWeek(DateUtil.StringToDate(str,"yyyy-MM-dd")).getChineseName()); |
| | |
| | | # daoå±çæ¥å¿è®¾ç½®ä¸ºdebugï¼æ¹ä¾¿æ¥çsql |
| | | logging: |
| | | level: |
| | | doumeemes.dao: debug |
| | | com.doumee.dao: debug |
| | | |
| | | |
| | | # WEBæå¡å¨é
ç½® |
| | |
| | | <pattern>%highlight(%date{yyyy-MM-dd HH:mm:ss}) | %highlight(%-5level) | %highlight(%thread) | %highlight(%logger) | %msg%n</pattern> |
| | | </layout> |
| | | </appender> |
| | | <property name="log.path" value="logs/meetingAdmin"></property> |
| | | <property name="log.path" value="/usr/local/jars/logs/meetingAdmin"></property> |
| | | <property name="log.fileSize" value="100MB"></property> |
| | | <property name="log.historyDays" value="7"></property> |
| | | |
| | |
| | | import com.doumee.dao.system.vo.UserStatisticsVo; |
| | | import com.doumee.dao.web.response.MeetingDetailResponse; |
| | | import com.doumee.dao.web.response.MeetingListResponse; |
| | | import com.github.yulichang.base.MPJBaseMapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.apache.ibatis.annotations.Select; |
| | | |
| | |
| | | * @author æ±è¹è¹ |
| | | * @date 2023/05/04 18:18 |
| | | */ |
| | | public interface BookingsMapper extends BaseMapper<Bookings> { |
| | | public interface BookingsMapper extends MPJBaseMapper<Bookings> { |
| | | |
| | | |
| | | |
| | |
| | | " CASE WHEN a.START_TIME_REAL IS NULL AND a.`STATUS` = 0 THEN 1 WHEN ( a.`STATUS` = 2 ) THEN 3 WHEN a.`STATUS` = 1 THEN 5 ELSE 2 END meetingStatus ," + |
| | | " b.IMGURL as imgUrl ," + |
| | | " a.remark " + |
| | | " from meeting_book a inner join meeting_rooms b on a.ROOM_ID = b.ID " + |
| | | " inner join system_user c on a.CREATOR = c.id " + |
| | | " from meeting_book a" + |
| | | " left join meeting_rooms b on a.ROOM_ID = b.ID " + |
| | | " left join system_user c on a.CREATOR = c.id " + |
| | | " ${ew.customSqlSegment} ") |
| | | IPage<MeetingListResponse> myMeetingPage(IPage<MeetingListResponse> page, @Param(Constants.WRAPPER) Wrapper wrapper); |
| | | |
| | |
| | | @ApiModelProperty(value = "ä¼è®®ç¶æ: 1=æªå¼å§ï¼2=è¿è¡ä¸ï¼3=å·²ç»æ ; 4=å³å°å¼å§; 5=å·²æ¤é") |
| | | @TableField(exist = false) |
| | | private Integer meetingStatus; |
| | | |
| | | |
| | | |
| | | @ApiModelProperty(value = "æ¥è¯¢æ¥æ yyyy-MM-dd") |
| | | @TableField(exist = false) |
| | | private String queryDate; |
| | | |
| | | |
| | | @ApiModelProperty(value = "æ¥è¯¢ç±»å«ï¼1=æåä¸çï¼2=æé¢çº¦çï¼") |
| | | @TableField(exist = false) |
| | | private Integer queryType; |
| | | |
| | | |
| | | @ApiModelProperty(value = "ä¼è®®å®¤åç§°") |
| | | @TableField(exist = false) |
| | | private String roomsName; |
| | | |
| | | @ApiModelProperty(value = "ä¼è®®å®¤ä¸»é®") |
| | | @TableField(exist = false) |
| | | private Integer roomsId; |
| | | |
| | | } |
| | |
| | | @ApiModelProperty(value = "ç¨æ·ä¸»é®") |
| | | private Integer userId; |
| | | |
| | | @ApiModelProperty(value = "æ¥è¯¢ç±»å«ï¼1=æåä¸çï¼2=æé¢çº¦çï¼") |
| | | @ApiModelProperty(value = "æ¥è¯¢ç±»å«ï¼1=æåä¸çï¼2=æé¢çº¦çï¼3管ç忥çå
¨é¨") |
| | | private Integer queryType; |
| | | |
| | | @ApiModelProperty(value = "ç¶æï¼æªå¼å§ 1 å·²ç»æ 2") |
| | |
| | | */ |
| | | @Data |
| | | @ApiModel("ä¼è®®å表è¿åç±»") |
| | | public class MeetingListResponse{ |
| | | public class MeetingListResponse{ |
| | | |
| | | @ApiModelProperty(value = "主é®") |
| | | private Integer id; |
| | |
| | | * @param dateMsg |
| | | * @return |
| | | */ |
| | | List<Bookings> getMyBookings(Integer userId,String dateMsg); |
| | | List<Bookings> getMyBookings(Integer userId,String dateMsg,Integer queryType); |
| | | |
| | | |
| | | /** |
| | |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.util.CollectionUtils; |
| | | |
| | | import java.awt.print.Book; |
| | | import java.text.SimpleDateFormat; |
| | | import java.time.LocalDate; |
| | | import java.time.LocalDateTime; |
| | |
| | | * @return |
| | | */ |
| | | @Override |
| | | public List<Bookings> getMyBookings(Integer userId, String dateMsg) { |
| | | return bookingsMapper.selectList(new QueryWrapper<Bookings>() |
| | | .apply(" id in ( select u.OBJ_ID from meeting_user_rel u where u.USER_ID = '" + userId + "' and u.ISDELETED = 0 and OBJ_TYPE = 1 ) ") |
| | | .eq("ISDELETED",MeetConstants.ZERO) |
| | | public List<Bookings> getMyBookings(Integer userId, String dateMsg,Integer queryType) { |
| | | if(queryType==null ){ |
| | | queryType =1; |
| | | } |
| | | return bookingsMapper.selectJoinList(Bookings.class,new MPJLambdaWrapper<Bookings>() |
| | | .selectAll(Bookings.class) |
| | | .leftJoin(Rooms.class,Rooms::getId,Bookings::getRoomId) |
| | | .exists(queryType!=3,"( select u.OBJ_ID from meeting_user_rel u where u.OBJ_ID =t.id and u.USER_ID = '" + userId + "' and u.ISDELETED = 0 and OBJ_TYPE = 1 ) ") |
| | | .exists(queryType==3,"( select u.OBJ_ID from meeting_user_rel u where u.OBJ_ID =t1.id and u.USER_ID = '" + userId + "' and u.ISDELETED = 0 and OBJ_TYPE = 0 ) ") |
| | | .eq(Bookings::getIsdeleted,MeetConstants.ZERO) |
| | | .eq(Rooms::getIsdeleted,MeetConstants.ZERO) |
| | | .eq(Rooms::getStatus,MeetConstants.ZERO) |
| | | // .eq("STATUS",MeetConstants.ZERO) |
| | | .apply(" ROOM_ID in ( select r.id from meeting_rooms r where r.ISDELETED = 0 and r.STATUS = 0 )") |
| | | .like(StringUtils.isNotBlank(dateMsg), "START_TIME", dateMsg)); |
| | | .like(StringUtils.isNotBlank(dateMsg), Bookings::getStartTime, dateMsg)); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * æçé¢çº¦/æçä¼è®® |
| | |
| | | * @param pageWrap |
| | | * @return |
| | | */ |
| | | public IPage<Bookings> getMyMeetingPageNew(PageWrap<Bookings> pageWrap) { |
| | | IPage<Bookings> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); |
| | | MPJLambdaWrapper<Bookings> queryWrapper = new MPJLambdaWrapper<>(); |
| | | Utils.MP.blankToNull(pageWrap.getModel()); |
| | | |
| | | queryWrapper.selectAll(Bookings.class); |
| | | queryWrapper.selectAs(Rooms::getName, Bookings::getRoomName); |
| | | queryWrapper.selectAs(SystemUser::getRealname, Bookings::getRealName); |
| | | queryWrapper.selectAs(Company::getName, Bookings::getDepartmentName); |
| | | queryWrapper.select(" CASE WHEN t.START_TIME_REAL IS NULL AND t.`STATUS` = 0 THEN 1 WHEN ( ( t.END_TIME < now() AND t.`STATUS` = 0 ) or t.`STATUS` = 2 ) THEN 3 WHEN t.`STATUS` = 1 THEN 5 ELSE 2 END meetingStatus "); |
| | | queryWrapper.leftJoin(Rooms.class, Rooms::getId, Bookings::getRoomId); |
| | | queryWrapper.leftJoin(SystemUser.class, SystemUser::getId, Bookings::getCreator); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,SystemUser::getCompanyId); |
| | | queryWrapper.orderByDesc(Bookings::getCreateDate); |
| | | queryWrapper.eq(Bookings::getIsdeleted, MeetConstants.ZERO); |
| | | queryWrapper.and(StringUtils.isNotBlank(pageWrap.getModel().getRoomsName()), |
| | | j -> j.like(Bookings::getName,pageWrap.getModel().getRoomsName()).or().like(Rooms::getName, pageWrap.getModel().getRoomsName())) |
| | | .exists(pageWrap.getModel().getQueryType().equals(MeetConstants.ONE) && !Objects.isNull(pageWrap.getModel().getUserId()), |
| | | " select u.id from meeting_user_rel u where t.id = u.OBJ_ID and u.USER_ID = '" + pageWrap.getModel().getUserId() + "' and u.ISDELETED = 0 and u.OBJ_TYPE = 1 ") |
| | | .eq(pageWrap.getModel().getQueryType().equals(MeetConstants.TWO) |
| | | && !Objects.isNull(pageWrap.getModel().getUserId()), Bookings::getCreator, pageWrap.getModel().getUserId()) |
| | | .like(StringUtils.isNotBlank(pageWrap.getModel().getQueryDate()), Bookings::getStartTime, pageWrap.getModel().getQueryDate()) |
| | | .eq(!Objects.isNull(pageWrap.getModel().getRoomsId()), Bookings::getRoomId, pageWrap.getModel().getRoomsId()) |
| | | .apply(!Objects.isNull(pageWrap.getModel().getStatus()) && pageWrap.getModel().getStatus().equals(MeetConstants.ONE), |
| | | " now() < t.END_TIME and t.STATUS = 0 ") |
| | | .and(!Objects.isNull(pageWrap.getModel().getStatus()) && pageWrap.getModel().getStatus().equals(MeetConstants.TWO), |
| | | j -> j.apply("now() >= t.END_TIME ").or() |
| | | .eq(" t.STATUS", MeetConstants.ONE)) |
| | | .eq(Rooms::getIsdeleted,MeetConstants.ZERO) |
| | | .eq(Rooms::getStatus,MeetConstants.ZERO) |
| | | .eq(Bookings::getIsdeleted,MeetConstants.ZERO) |
| | | .apply(Objects.nonNull(pageWrap.getModel().getMeetingStatus()) |
| | | &&Constants.equalsInteger(pageWrap.getModel().getMeetingStatus(),Constants.ONE), |
| | | " ( now() < t.START_TIME and t.status = 0 ) " |
| | | ) |
| | | .apply(Objects.nonNull(pageWrap.getModel().getMeetingStatus()) |
| | | &&Constants.equalsInteger(pageWrap.getModel().getMeetingStatus(),Constants.TWO), |
| | | " ( now() >= t.START_TIME and t.END_TIME >= now() and t.status = 0 ) " |
| | | ) |
| | | .apply(Objects.nonNull(pageWrap.getModel().getMeetingStatus()) |
| | | &&Constants.equalsInteger(pageWrap.getModel().getMeetingStatus(),Constants.THREE), |
| | | " ( ( now() >t.END_TIME and t.`STATUS` = 0 ) or t.`STATUS` = 2 ) " |
| | | ) |
| | | .apply(Objects.nonNull(pageWrap.getModel().getMeetingStatus()) |
| | | &&Constants.equalsInteger(pageWrap.getModel().getMeetingStatus(),Constants.FOUR), |
| | | " now() < t.START_TIME AND SUBDATE( t.START_TIME, INTERVAL 120 MINUTE ) < NOW() " |
| | | ) |
| | | .eq(Objects.nonNull(pageWrap.getModel().getMeetingStatus()) |
| | | &&Constants.equalsInteger(pageWrap.getModel().getMeetingStatus(),Constants.FIVE), |
| | | Bookings::getStatus,MeetConstants.ONE |
| | | ) |
| | | .orderByDesc(Constants.equalsInteger(pageWrap.getModel().getQueryType(),MeetConstants.TWO),Bookings::getCreateDate) |
| | | .orderByAsc(Constants.equalsInteger(pageWrap.getModel().getQueryType(),MeetConstants.ONE),Bookings::getStartTime); |
| | | |
| | | IPage<Bookings> result = bookingsJoinMapper.selectJoinPage(page, Bookings.class, queryWrapper); |
| | | return result; |
| | | } |
| | | @Override |
| | | public IPage<MeetingListResponse> getMyMeetingPage(PageWrap<MeetingPageRequest> pageWrap) { |
| | | |
| | | QueryWrapper queryWrapper = new QueryWrapper<MeetingListResponse>() |
| | | .and(StringUtils.isNotBlank(pageWrap.getModel().getRoomsName()), |
| | | j -> j.like("a.NAME",pageWrap.getModel().getRoomsName()).or() |
| | | .like(" b.NAME", pageWrap.getModel().getRoomsName())) |
| | | j -> j.like("a.NAME",pageWrap.getModel().getRoomsName()).or().like(" b.NAME", pageWrap.getModel().getRoomsName())) |
| | | .exists(pageWrap.getModel().getQueryType().equals(MeetConstants.ONE) && !Objects.isNull(pageWrap.getModel().getUserId()), |
| | | " select 1 from meeting_user_rel u where a.id = u.OBJ_ID and u.USER_ID = '" + pageWrap.getModel().getUserId() + "' and u.ISDELETED = 0 and OBJ_TYPE = 1 ") |
| | | " select 1 from meeting_user_rel u where a.id = u.OBJ_ID and u.USER_ID = '" + pageWrap.getModel().getUserId() + "' and u.ISDELETED = 0 and OBJ_TYPE = 1 ") |
| | | .exists(pageWrap.getModel().getQueryType().equals(MeetConstants.THREE) && !Objects.isNull(pageWrap.getModel().getUserId()), |
| | | " select 1 from meeting_user_rel u where b.id = u.OBJ_ID and u.USER_ID = '" + pageWrap.getModel().getUserId() + "' and u.ISDELETED = 0 and OBJ_TYPE = 0 ")//管ç忥ç |
| | | .eq(pageWrap.getModel().getQueryType().equals(MeetConstants.TWO) && !Objects.isNull(pageWrap.getModel().getUserId()), "a.CREATOR", pageWrap.getModel().getUserId()) |
| | | .like(StringUtils.isNotBlank(pageWrap.getModel().getQueryDate()), "a.START_TIME", pageWrap.getModel().getQueryDate()) |
| | | .eq(!Objects.isNull(pageWrap.getModel().getRoomsId()), "b.id", pageWrap.getModel().getRoomsId()) |
| | | .apply(!Objects.isNull(pageWrap.getModel().getStatus()) && pageWrap.getModel().getStatus().equals(MeetConstants.ONE), " now() < a.END_TIME and a.STATUS = 0 ") |
| | | .and(!Objects.isNull(pageWrap.getModel().getStatus()) && pageWrap.getModel().getStatus().equals(MeetConstants.TWO), |
| | | .apply(!Objects.isNull(pageWrap.getModel().getStatus()) |
| | | && pageWrap.getModel().getStatus().equals(MeetConstants.ONE), |
| | | " now() < a.END_TIME and a.STATUS = 0 ") |
| | | .and(!Objects.isNull(pageWrap.getModel().getStatus()) |
| | | && pageWrap.getModel().getStatus().equals(MeetConstants.TWO), |
| | | j -> j.apply("now() >= a.END_TIME ").or() |
| | | .eq(" a.STATUS", MeetConstants.ONE)) |
| | | .eq("b.ISDELETED",MeetConstants.ZERO) |
| | |
| | | // .orderByDesc(!Objects.isNull(pageWrap.getModel().getStatus())&&pageWrap.getModel().getStatus().equals(MeetConstants.TWO),"a.START_TIME") |
| | | // .orderByAsc(Objects.isNull(pageWrap.getModel().getStatus())||pageWrap.getModel().getStatus().equals(MeetConstants.ONE),"a.START_TIME") |
| | | .orderByDesc(Constants.equalsInteger(pageWrap.getModel().getQueryType(),MeetConstants.TWO),"a.CREATE_DATE") |
| | | .orderByAsc(Constants.equalsInteger(pageWrap.getModel().getQueryType(),MeetConstants.ONE),"a.START_TIME"); |
| | | .orderByAsc(Constants.equalsInteger(pageWrap.getModel().getQueryType(),MeetConstants.ONE) |
| | | || Constants.equalsInteger(pageWrap.getModel().getQueryType(),MeetConstants.THREE),"a.START_TIME"); |
| | | |
| | | IPage<MeetingListResponse> page = bookingsMapper.myMeetingPage(pageWrap.toPage(), queryWrapper); |
| | | this.dealMeetingStatus(page.getRecords()); |
| | |
| | | #!/bin/bash |
| | | # è·åå½åæ¥æï¼æ ¼å¼ä¸ºYYYYMMDD |
| | | current_date=$(date +%Y%m%d) |
| | | |
| | | # å®ä¹æ¥å¿æä»¶è·¯å¾ååç§°ï¼å
嫿¥æä¿¡æ¯ |
| | | log_file_path="/usr/local/jars/log/admin/info.log" |
| | | log_file_error_path="/usr/local/jars/log/admin/error.log" |
| | | killall java |
| | | |
| | | nohup java -Xms2048m -Xmx2048m -Xmn2048m -XX:MetaspaceSize=1024m -XX:MaxMetaspaceSize=1024m -XX:+UseParNewGC -XX:+UseConcMarkSweepGC -XX:+UseCMSCompactAtFullCollection -XX:CMSInitiatingOccupancyFraction=10031 -jar /usr/local/jars/admin_interface.jar >"${log_file_path}" 2>"${log_file_error_path}" & |
| | | /usr/local/nacos/nacos/bin/startup.sh -m standalone |
| | | |
| | | nohup java -jar /usr/local/jars/system_gateway.jar > /dev/null 2>&1 & |
| | | nohup java -jar /usr/local/jars/admin_timer.jar > /dev/null 2>&1 & |
| | | nohup java -jar /usr/local/jars/system_timer.jar > /dev/null 2>&1 & |
| | | nohup java -jar /usr/local/jars/admin_interface.jar > /dev/null 2>&1 & |
| | | nohup java -jar /usr/local/jars/meeting_admin.jar > /dev/null 2>&1 & |
| | |
| | | spring: |
| | | profiles: |
| | | active: pro |
| | | active: self |
| | | application: |
| | | name: system_gateway |
| | | # å®å
¨é
ç½® |
| | |
| | | <pattern>%highlight(%date{yyyy-MM-dd HH:mm:ss}) | %highlight(%-5level) | %highlight(%thread) | %highlight(%logger) | %msg%n</pattern> |
| | | </layout> |
| | | </appender> |
| | | <property name="log.path" value="logs/system_gateway"></property> |
| | | <property name="log.path" value="/usr/local/jars/logs/system_gateway"></property> |
| | | <property name="log.fileSize" value="100MB"></property> |
| | | <property name="log.historyDays" value="7"></property> |
| | | |
| | |
| | | import com.fasterxml.jackson.core.JsonProcessingException; |
| | | import com.fasterxml.jackson.databind.ObjectMapper; |
| | | import com.fasterxml.jackson.databind.PropertyNamingStrategy; |
| | | import net.sourceforge.pinyin4j.PinyinHelper; |
| | | import org.apache.commons.lang3.StringUtils; |
| | | |
| | | import java.io.IOException; |
| | | import java.math.BigDecimal; |
| | | import java.text.Collator; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.ArrayList; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Random; |
| | | import java.util.*; |
| | | import java.util.Date; |
| | | import java.util.regex.Matcher; |
| | | import java.util.regex.Pattern; |
| | | |
| | |
| | | } |
| | | |
| | | public static void main(String[] args) { |
| | | System.out.println(Constants.checkCarNo("çA10991")); |
| | | System.out.println(Constants.checkCarNo("çAA10991")); |
| | | getChinesePingyin("DDaaæ±èç对对对"); |
| | | // System.out.println(DateUtil.getShortTime(new Date())); |
| | | // System.out.println( "2025-01-14 10:50:56".substring(0,10)); |
| | | // System.out.println(Constants.checkCarNo("çAA10991")); |
| | | // System.out.println(Constants.getVehiclePlateNo("æ¹B140D17").getDescription()); |
| | | // System.out.println(Constants.getVehiclePlateNo("宿AP0637").getDescription()); |
| | | |
| | |
| | | this.info = info; |
| | | } |
| | | } |
| | | public static String getChinesePingyin(String chinese) { |
| | | if(StringUtils.isBlank(chinese)){ |
| | | return null; |
| | | } |
| | | StringBuilder result = new StringBuilder(); |
| | | for (char ch : chinese.toCharArray()) { |
| | | String[] pinyinArray = PinyinHelper.toHanyuPinyinStringArray(ch); |
| | | |
| | | // 妿å符æ¯ä¸æï¼åè·åå
¶æ¼é³çé¦åæ¯ |
| | | if (pinyinArray != null && pinyinArray.length > 0) { |
| | | result.append(pinyinArray[0].charAt(0)); |
| | | } else { |
| | | // é䏿åç¬¦ç´æ¥æ¼æ¥ |
| | | result.append(ch); |
| | | } |
| | | } |
| | | System.out.println(result.toString()); |
| | | return result.toString().toUpperCase(); |
| | | } |
| | | |
| | | /** |
| | | * æå°ä½ä¸ ç¶æ |
| | |
| | | // System.out.println(DateUtil.afterMinutesDate(-5)); |
| | | |
| | | |
| | | System.out.println(DateUtil.getBeforMonthStr(new Date(),1)); |
| | | System.out.println(DateUtil.getBeforMonthStr(new Date(),12)); |
| | | System.out.println(getPlusTime2(DateUtil.addMonthToDate(new Date(),-1))); |
| | | // System.out.println(DateUtil.getBeforMonthStr(new Date(),12)); |
| | | |
| | | // List<Date> list =getThisMonthDateList(); |
| | | // for(Date d :list){ |
| | |
| | | @ApiModelProperty(value = "æ´æ°äººç¼ç ") |
| | | @ExcelColumn(name="æ´æ°äººç¼ç ") |
| | | private Integer editor; |
| | | |
| | | @ApiModelProperty(value = "å§åæ¼é³é¦åæ¯") |
| | | private String pinyin; |
| | | @ApiModelProperty(value = "æ´æ°æ¶é´") |
| | | @ExcelColumn(name="æ´æ°æ¶é´") |
| | | private Date editDate; |
| | |
| | | @JsonFormat(pattern = "yyyy-MM-dd") |
| | | @ExcelColumn(name="å
¥èæ¥æ",index =9,width = 10, dateFormat = "yyyy-MM-dd") |
| | | private Date jobDate; |
| | | @ApiModelProperty(value = "å§åæ¼é³é¦åæ¯") |
| | | private String pinyin; |
| | | @ApiModelProperty(value = "å¹è®ç»ææ¶é´") |
| | | @TableField(exist = false) |
| | | @ExcelColumn(name="å¹è®ç»ææ¶é´",index =10,width = 10, dateFormat = "yyyy-MM-dd") |
| | |
| | | import com.doumee.dao.system.model.SystemUser; |
| | | import com.doumee.dao.system.vo.SystemUserListVO; |
| | | import com.doumee.dao.system.vo.UserResponse; |
| | | import com.github.yulichang.base.MPJBaseMapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.apache.ibatis.annotations.Select; |
| | | |
| | |
| | | /** |
| | | * @author T14 |
| | | */ |
| | | public interface SystemUserMapper extends BaseMapper<SystemUser> { |
| | | public interface SystemUserMapper extends MPJBaseMapper<SystemUser> { |
| | | |
| | | /** |
| | | * æ¥è¯¢ç¨æ·å表 |
| | |
| | | private Integer id; |
| | | @ApiModelProperty(value = "ç¨æ·ç¼ç ï¼å
³èmember)", example = "1") |
| | | private Integer memberId; |
| | | |
| | | @ApiModelProperty(value = "å§åæ¼é³é¦åæ¯") |
| | | private String pinyin; |
| | | @ApiModelProperty(value = "ç¨æ·å") |
| | | @NotBlank(message = "ç¨æ·åä¸è½ä¸ºç©º") |
| | | private String username; |
| | |
| | | @ApiModelProperty(value = "å
¬å¸åç§°") |
| | | @TableField(exist = false) |
| | | private String companyName; |
| | | @ApiModelProperty(value = "æç´¢å
³é®è¯è¯") |
| | | @TableField(exist = false) |
| | | private String queryParam; |
| | | @ApiModelProperty(value = "å¨èç¶æ 0å¨è 1离è") |
| | | @TableField(exist = false) |
| | | private Integer workStatus; |
| | | @ApiModelProperty(value = "å
¬å¸ç±»å") |
| | | @TableField(exist = false) |
| | | private Integer companyType; |
| | | @ApiModelProperty(value = "æ¯å¦æ¥è¯¢åºå®äººåç»ç»ä¸»é®" ,hidden = true) |
| | | @TableField(exist = false) |
| | | private String companySpecialId; |
| | | |
| | | @ApiModelProperty(value = "æ¯å¦æ¥è¯¢åºå®äººåï¼0=å¦ï¼1=æ¯" ) |
| | | @TableField(exist = false) |
| | | private Integer querySpecial; |
| | | |
| | | @ApiModelProperty(value = "æ°æ®æéå
é¨é¨ç¼ç éå") |
| | | @TableField(exist = false) |
| | | private List<Integer> companyIdList; |
| | | @ApiModelProperty(value = "人è¸ç
§ç") |
| | | @TableField(exist = false) |
| | | private String faceImg; |
| | | |
| | | } |
| | |
| | | * å·²å°è´§ |
| | | * å·²å
¥åº |
| | | */ |
| | | ddsc(0,"订åçæ",new Integer[]{ChildStatusLevel.create.getOrderStatus()}), |
| | | ydpzz (1,"è¿åé
è½½ä¸",new Integer[]{ChildStatusLevel.ysdxc.getOrderStatus() |
| | | ddsc(0,"订åçæ",new Integer[]{ChildStatusLevel.create.getOrderStatus() |
| | | ,ChildStatusLevel.kcbz.getOrderStatus()}), |
| | | ydpzz (1,"è¿è¾ä»»å¡çæ",new Integer[]{ChildStatusLevel.ysdxc.getOrderStatus() |
| | | ,ChildStatusLevel.ysdcx.getOrderStatus() |
| | | ,ChildStatusLevel.shtg.getOrderStatus() |
| | | ,ChildStatusLevel.shwtg.getOrderStatus()}), |
| | | ckckz (2,"ä»åºåºåºä¸",new Integer[]{ChildStatusLevel.ddzhddzs.getOrderStatus() |
| | | ckckz (2,"ä»åºåºåº",new Integer[]{ChildStatusLevel.ddzhddzs.getOrderStatus() |
| | | ,ChildStatusLevel.sqzyzwc.getOrderStatus() |
| | | ,ChildStatusLevel.clqddzs.getOrderStatus()}), |
| | | clysz(3, "车è¾è¿è¾ä¸",new Integer[]{ChildStatusLevel.clqdapp.getOrderStatus()}), |
| | | clysz(3, "车è¾è¿è¾",new Integer[]{ChildStatusLevel.clqdapp.getOrderStatus()}), |
| | | ydh(4,"å·²å°è´§",new Integer[]{ChildStatusLevel.ddzhd.getOrderStatus()}), |
| | | yrk (5,"å·²å
¥åº",new Integer[]{ChildStatusLevel.ddxhd.getOrderStatus()}); |
| | | |
| | |
| | | ddzhddzs(6,3,2,"å°è¾¾è£
è´§å°-çµåéæ±½è¿","车è¾å·²å°è¾¾è£
è´§å°" ), |
| | | clqddzs(7, 4,2,"车è¾å¯è¿-çµåéæ±½è¿","车è¾å·²å¯è¿" ), |
| | | clqdapp(8, 7,3,"车è¾å¯è¿-APP","车è¾è¿è¾ä¸" ), |
| | | kcbz(11, 9,0,"å¾
ç产","å½å订ååºåä¸è¶³ï¼å¾
ç产" ), |
| | | ddzhd(9, 8,4,"å°è¾¾å¸è´§å°-APP","车è¾å·²å°è¾¾å¸è´§å°" ), |
| | | ddxhd(10, 5,5,"å°è¾¾å¸è´§å°-çµåéæ±½è¿","çµåé已解éï¼è¿è¾ä»»å¡å·²å®æ" ), |
| | | ; |
| | |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.doumee.biz.system.SystemDictDataBiz; |
| | | import com.doumee.dao.business.model.Member; |
| | | import com.doumee.service.business.third.model.PageData; |
| | | import com.doumee.service.business.third.model.PageWrap; |
| | | import com.doumee.core.utils.Constants; |
| | |
| | | |
| | | @Override |
| | | public List<SystemUser> findList(SystemUser systemUser) { |
| | | Wrapper<SystemUser> wrapper = new QueryWrapper<>(systemUser); |
| | | return systemUserMapper.selectList(wrapper); |
| | | MPJLambdaWrapper<SystemUser> wrapper = new MPJLambdaWrapper<>(); |
| | | wrapper.selectAll(SystemUser.class ) |
| | | .selectAs(Company::getName,SystemUser::getCompanyName) |
| | | .eq(SystemUser::getDeleted,Constants.ZERO) |
| | | .leftJoin(Company.class,Company::getId,SystemUser::getCompanyId) |
| | | .eq( systemUser.getCompanyId() !=null,SystemUser::getCompanyId,systemUser.getCompanyId()) |
| | | .eq( systemUser.getCompanyType() !=null,Company::getType,systemUser.getCompanyType()) |
| | | .like(StringUtils.isNotBlank(systemUser.getRealname()),SystemUser::getRealname,systemUser.getRealname()) |
| | | .like(StringUtils.isNotBlank(systemUser.getMobile()),SystemUser::getMobile,systemUser.getMobile()) |
| | | .like(StringUtils.isNotBlank(systemUser.getUsername()),SystemUser::getUsername,systemUser.getUsername()) |
| | | .like(StringUtils.isNotBlank(systemUser.getCompanyName()),Company::getName,systemUser.getCompanyName()) |
| | | .orderByAsc( Company::getPinyin ) |
| | | .orderByAsc(SystemUser::getPinyin) |
| | | ; |
| | | return systemUserMapper.selectJoinList(SystemUser.class,wrapper); |
| | | } |
| | | |
| | | @Override |
| | |
| | | |
| | | |
| | | @Override |
| | | public List<SystemUser> findAllList(SystemUser pageWrap) { |
| | | MPJLambdaWrapper<SystemUser> queryWrapper = new MPJLambdaWrapper<>(); |
| | | Utils.MP.blankToNull(pageWrap); |
| | | queryWrapper.selectAll(SystemUser.class); |
| | | queryWrapper.eq(SystemUser::getDeleted, Constants.ZERO); |
| | | queryWrapper.and(StringUtils.isNotBlank(pageWrap.getUsername()),ms->ms.like(SystemUser::getUsername,pageWrap.getUsername()) |
| | | .or().like(SystemUser::getMobile,pageWrap.getUsername()) |
| | | .or().like(SystemUser::getRealname,pageWrap.getUsername()) |
| | | ); |
| | | queryWrapper.orderByDesc(SystemUser::getCreateTime); |
| | | List<SystemUser> result = systemUserJoinMapper.selectJoinList( SystemUser.class, queryWrapper); |
| | | public List<SystemUser> findAllList(SystemUser systemUser) { |
| | | |
| | | //æ¥è¯¢ç¹æ®ç42人é
ç½® |
| | | if( Constants.equalsInteger(systemUser.getQuerySpecial(),Constants.ONE)){ |
| | | String companySpecialId = systemDictDataBiz.queryByCode(Constants.SYSTEM,Constants.SPECIAL_COMPANY_ID).getCode(); |
| | | if(StringUtils.isNotBlank(companySpecialId)){ |
| | | systemUser.setCompanySpecialId(companySpecialId); |
| | | } |
| | | } |
| | | |
| | | MPJLambdaWrapper<SystemUser> wrapper = new MPJLambdaWrapper<>(); |
| | | wrapper.selectAll(SystemUser.class ) |
| | | .selectAs(Company::getCompanyNamePath,SystemUser::getCompanyName) |
| | | .selectAs(Member::getFaceImg,SystemUser::getFaceImg) |
| | | .eq(SystemUser::getDeleted,Constants.ZERO) |
| | | .leftJoin(Company.class,Company::getId,SystemUser::getCompanyId) |
| | | .leftJoin(Member.class,Member::getId,SystemUser::getMemberId) |
| | | .and(StringUtils.isNotBlank(systemUser.getUsername()),ms->ms.like(SystemUser::getUsername,systemUser.getUsername()) |
| | | .or().like(SystemUser::getMobile,systemUser.getUsername()) |
| | | .or().like(SystemUser::getRealname,systemUser.getUsername())) |
| | | .and(StringUtils.isNotBlank(systemUser.getQueryParam()),ms->ms.like(SystemUser::getUsername,systemUser.getUsername()) |
| | | .or().like(SystemUser::getMobile,systemUser.getQueryParam()) |
| | | .or().like(Company::getName,systemUser.getQueryParam()) |
| | | .or().like(SystemUser::getRealname,systemUser.getQueryParam())) |
| | | .eq( systemUser.getCompanyId() !=null,SystemUser::getCompanyId,systemUser.getCompanyId()) |
| | | .eq( systemUser.getCompanyType() !=null,Company::getType,systemUser.getCompanyType()) |
| | | .eq( systemUser.getWorkStatus() !=null,Member::getWorkStatus,systemUser.getWorkStatus()) |
| | | .like(StringUtils.isNotBlank(systemUser.getRealname()),SystemUser::getRealname,systemUser.getRealname()) |
| | | .like(StringUtils.isNotBlank(systemUser.getMobile()),SystemUser::getMobile,systemUser.getMobile()) |
| | | .like(StringUtils.isNotBlank(systemUser.getUsername()),SystemUser::getUsername,systemUser.getUsername()) |
| | | .like(StringUtils.isNotBlank(systemUser.getCompanyName()),Company::getName,systemUser.getCompanyName()) |
| | | .apply(StringUtils.isNotBlank(systemUser.getCompanySpecialId())," find_in_set('"+systemUser.getCompanySpecialId()+"',REPLACE(t1.company_path,'/',','))") |
| | | .orderByAsc( Company::getPinyin ) |
| | | .orderByAsc(SystemUser::getPinyin) |
| | | ; |
| | | List<SystemUser> result = systemUserJoinMapper.selectJoinList( SystemUser.class, wrapper); |
| | | if(result!=null){ |
| | | String prefixUrl = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() + |
| | | systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode(); |
| | | for (SystemUser memberInfoDTO:result) { |
| | | //æ¼æ¥åç¼ |
| | | if (StringUtils.isNotBlank(memberInfoDTO.getFaceImg())) { |
| | | memberInfoDTO.setFaceImg(prefixUrl + memberInfoDTO.getFaceImg()); |
| | | } |
| | | } |
| | | } |
| | | |
| | | return result; |
| | | } |
| | | |
| | |
| | | queryWrapper.eq(SystemUser::getDeleted, Constants.ZERO); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,SystemUser::getCompanyId); |
| | | queryWrapper.eq(Company::getType,Constants.ONE); |
| | | queryWrapper.orderByDesc(SystemUser::getCreateTime); |
| | | queryWrapper.orderByAsc(SystemUser::getPinyin); |
| | | List<SystemUser> result = systemUserJoinMapper.selectJoinList( SystemUser.class, queryWrapper); |
| | | return result; |
| | | } |
| | |
| | | <pattern>%highlight(%date{yyyy-MM-dd HH:mm:ss}) | %highlight(%-5level) | %highlight(%thread) | %highlight(%logger) | %msg%n</pattern> |
| | | </layout> |
| | | </appender> |
| | | <property name="log.path" value="logs/visitsTimer"></property> |
| | | <property name="log.path" value="/usr/local/jars/logs/visitsTimer"></property> |
| | | <property name="log.fileSize" value="100MB"></property> |
| | | <property name="log.historyDays" value="7"></property> |
| | | <appender name="fileInfoLog" class="ch.qos.logback.core.rolling.RollingFileAppender"> |
| | |
| | | import com.doumee.core.haikang.model.param.request.*; |
| | | import com.doumee.core.haikang.model.param.respose.*; |
| | | import com.doumee.core.haikang.service.HKService; |
| | | import com.doumee.service.business.MemberService; |
| | | import com.doumee.service.business.third.model.ApiResponse; |
| | | import com.doumee.core.utils.Constants; |
| | | import com.doumee.dao.business.model.Device; |
| | |
| | | |
| | | @Autowired |
| | | private SystemDictDataBiz systemDictDataBiz; |
| | | @Autowired |
| | | private MemberService memberService; |
| | | @Autowired |
| | | private HkSyncImgServiceImpl hkSyncImgService; |
| | | @Autowired |
| | |
| | | } |
| | | return ApiResponse.success(dList); |
| | | } |
| | | @ApiOperation("ãç³»ç»ãéæ°åå§åææcompanyãmemberåsystemuseræ°æ®çpinyinåæ®µ") |
| | | @GetMapping("/initPinyinTool") |
| | | @LoginNoRequired |
| | | public ApiResponse<List<Map<String,Object>> > initPinyinTool( HttpServletResponse response) { |
| | | memberService.initPinyinTool(); |
| | | return ApiResponse.success(null); |
| | | } |
| | | @ApiOperation("ãæµ·åº·ãæµè¯LEDæ¾ç¤ºå±") |
| | | @PostMapping("/testLed") |
| | | @LoginNoRequired |
| | |
| | | import com.doumee.api.BaseController; |
| | | import com.doumee.config.annotation.LoginNoRequired; |
| | | import com.doumee.core.haikang.model.cars.response.CarsAlarmResultListResponse; |
| | | import com.doumee.dao.web.reqeust.CarsJobAndContractByJobIdDTO; |
| | | import com.doumee.service.business.third.model.ApiResponse; |
| | | import com.doumee.core.utils.Constants; |
| | | import com.doumee.dao.business.join.PlatformJobJoinMapper; |
| | |
| | | return ApiResponse.success(data); |
| | | } |
| | | @LoginNoRequired |
| | | @ApiOperation("æ ¹æ®ä½ä¸ç¼ç æ¥è¯¢ä½ä¸ä¿¡æ¯åååä¿¡æ¯éå") |
| | | @PostMapping("/getJobDetailsById") |
| | | public ApiResponse<CarsJobAndContractVO> getJobDetailsById(@RequestBody CarsJobAndContractByJobIdDTO param) { |
| | | CarsJobAndContractVO data = boardService.getJobDetailsById(param); |
| | | return ApiResponse.success(data); |
| | | } |
| | | @LoginNoRequired |
| | | @ApiOperation("彿¥è¿è¾ä»»å¡") |
| | | @GetMapping("/platformJobList") |
| | | public ApiResponse<List<PlatformJob>> platformJobList() { |
| | |
| | | <pattern>%highlight(%date{yyyy-MM-dd HH:mm:ss}) | %highlight(%-5level) | %highlight(%thread) | %highlight(%logger) | %msg%n</pattern> |
| | | </layout> |
| | | </appender> |
| | | <property name="log.path" value="logs/visitsAdmin"></property> |
| | | <property name="log.path" value="/usr/local/jars/logs/visitsAdmin"></property> |
| | | <property name="log.fileSize" value="100MB"></property> |
| | | <property name="log.historyDays" value="7"></property> |
| | | |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.doumee.dao.web.reqeust; |
| | | |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | |
| | | /** |
| | | * Created by IntelliJ IDEA. |
| | | * |
| | | * @Author : Rk |
| | | * @create 2024/1/4 16:17 |
| | | */ |
| | | @Data |
| | | public class CarsJobAndContractByJobIdDTO { |
| | | |
| | | @ApiModelProperty(value = "ä»»å¡ç¼ç ") |
| | | private Integer id; |
| | | |
| | | |
| | | } |
| | |
| | | |
| | | @ApiModelProperty(value = "ãåºåºè½åã彿¥è®¡åé") |
| | | private BigDecimal currentPlanNum; |
| | | @ApiModelProperty(value = "ãåºåºè½åã彿¥è®¡å车次é") |
| | | @ApiModelProperty(value = "ãåºåºè½åãæ éé
è½½çä»»å¡é") |
| | | private BigDecimal noNeedTransportOrderNum; |
| | | @ApiModelProperty(value = "ãåºåºè½åãéé
è½½çä»»å¡é") |
| | | private BigDecimal needTransportOrderNum; |
| | | @ApiModelProperty(value = "ãåºåºè½åãå½åä»»å¡è½¦æ¬¡") |
| | | private int currentPlanCarNum; |
| | | |
| | | @ApiModelProperty(value = "ãåºåºè½åã仿¥åºåºé") |
| | |
| | | |
| | | |
| | | List<Member> findDriveList(Member model); |
| | | |
| | | void initPinyinTool(); |
| | | } |
| | |
| | | company.setHkDate(company.getCreateDate()); |
| | | company.setEditDate(company.getCreateDate()); |
| | | company.setEditor(company.getCreator()); |
| | | company.setPinyin(Constants.getChinesePingyin(company.getName())); |
| | | company.setHkId(UUID.randomUUID().toString().replace("-","")); |
| | | companyMapper.insert(company); |
| | | //ä¸å海康å®é²å¹³å° |
| | |
| | | insert.setCode(company.getCode()); |
| | | insert.setParentId(company.getParentId()); |
| | | insert.setLinkName(company.getLinkName()); |
| | | company.setPinyin(Constants.getChinesePingyin(company.getName())); |
| | | insert.setLinkPhone(company.getLinkPhone()); |
| | | companyMapper.insert(insert); |
| | | return insert.getId(); |
| | |
| | | company.setHkDate(company.getHkDate()); |
| | | company.setHkId(StringUtils.defaultString(model.getHkId(),UUID.randomUUID().toString().replace("-",""))); |
| | | company.setParentId(null);//䏿¯æä¿®æ¹ç¶çº§ |
| | | company.setPinyin(Constants.getChinesePingyin(company.getName())); |
| | | companyMapper.updateById(company); |
| | | //æ´æ°çcompanyPath |
| | | String newName = model.getCompanyNamePath().replace(model.getName(),company.getName()); |
| | |
| | | if (company.getQueryHiddenDanger() != null && Constants.equalsInteger(company.getQueryHiddenDanger(),Constants.ONE)) { |
| | | queryWrapper.apply(" t.id in ( select hdp.COMPANY_ID from hidden_danger_param hdp where hdp.ISDELETED = 0 and hdp.STATUS = 0 and hdp.TYPE = 0 ) "); |
| | | } |
| | | queryWrapper.orderByDesc(Company::getCreateDate); |
| | | queryWrapper.orderByAsc(Company::getPinyin); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,Company::getParentId); |
| | | queryWrapper.select(" t.* ") |
| | | .select("(select count(m.id) from member m where m.COMPANY_ID=t.id and m.ISDELETED=0) as countNum") ; |
| | |
| | | queryWrapper.ge(Company::getFsDate, Utils.Date.getStart(pageWrap.getModel().getFsDate())); |
| | | queryWrapper.le(Company::getFsDate, Utils.Date.getEnd(pageWrap.getModel().getFsDate())); |
| | | } |
| | | queryWrapper.orderByDesc(Company::getCreateDate); |
| | | queryWrapper.leftJoin(Company.class,Company::getId,Company::getParentId); |
| | | /* .leftJoin(Member.class, Member::getId,Company::getHeadId)*/ |
| | | /* queryWrapper.leftJoin(" company c on c.id=t.parent_id");*/ |
| | | /* queryWrapper.leftJoin(" company c on c.id=t.parent_id");*/ |
| | | queryWrapper.selectAll(Company.class) |
| | | .select("(select count(m.id) from member m where m.COMPANY_ID=t.id and m.ISDELETED=0) as countNum") ; |
| | | queryWrapper.select("t1.name",Company::getParentName); |
| | |
| | | queryWrapper.eq(Objects.nonNull(pageWrap.getModel().getStatus()),Company::getStatus,Constants.ZERO); |
| | | queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Company::getName,pageWrap.getModel().getName()); |
| | | queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getParentName()),"c.name",pageWrap.getModel().getParentName()); |
| | | queryWrapper.orderByAsc(Company::getPinyin); |
| | | IPage<Company> companyIPage = companyJoinMapper.selectJoinPage(page, Company.class, queryWrapper); |
| | | return PageData.from(companyIPage); |
| | | } |
| | |
| | | LambdaQueryWrapper<Company> wrapper = new LambdaQueryWrapper<>(); |
| | | |
| | | wrapper.eq(Company::getIsdeleted,Constants.ZERO) |
| | | .eq(Constants.equalsInteger(type,Constants.ONE),Company::getType,type); |
| | | .eq(Constants.equalsInteger(type,Constants.ONE),Company::getType,type) |
| | | .orderByAsc(Company::getPinyin); |
| | | List<Company> companies = companyMapper.selectList(wrapper); |
| | | return getCompanyTree( companies, null); |
| | | } |
| | |
| | | if (CollectionUtils.isEmpty(companies)){ |
| | | return; |
| | | } |
| | | company.setPinyin(Constants.getChinesePingyin(company.getName())); |
| | | //æ°å¢çæ
åµåå¨è®°å½ |
| | | if (Objects.isNull(company.getId())){ |
| | | throw new BusinessException(ResponseStatus.DATA_EXISTS.getCode(),"å
¬å¸åç§°å·²åå¨"); |
| | |
| | | if(StringUtils.isBlank(multifile.getFileurl())){ |
| | | continue; |
| | | } |
| | | multifile.setId(null); |
| | | multifile.setCreateDate(new Date()); |
| | | multifile.setCreator(hiddenDanger.getEditor()); |
| | | multifile.setIsdeleted(Constants.ZERO); |
| | |
| | | if(hiddenDanger.getStatus().equals(Constants.ONE) && !isTrue){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对ä¸èµ·ï¼è¯·æè¦æ±å¡«åå¤çæ°æ®"); |
| | | } |
| | | multifileMapper.update(null,new UpdateWrapper<Multifile>().lambda() |
| | | .set(Multifile::getIsdeleted,Constants.ONE ) |
| | | .eq(Multifile::getObjType,Constants.MultiFile.HIDDEN_DANGER_DEAL_BEFORE.getKey()) |
| | | .set(Multifile::getObjId,hiddenDanger.getId()) |
| | | ); |
| | | } |
| | | if(hiddenDanger.getStatus().equals(Constants.ONE)){ |
| | | boolean isTrue = false; |
| | |
| | | if(StringUtils.isBlank(multifile.getFileurl())){ |
| | | continue; |
| | | } |
| | | multifile.setId(null); |
| | | multifile.setCreateDate(new Date()); |
| | | multifile.setCreator(hiddenDanger.getEditor()); |
| | | multifile.setIsdeleted(Constants.ZERO); |
| | |
| | | user.setSource(Constants.ZERO); |
| | | user.setDeleted(Boolean.FALSE); |
| | | user.setFixed(Boolean.FALSE); |
| | | user.setPinyin(Constants.getChinesePingyin(user.getRealname())); |
| | | user.setStatus(Constants.ZERO); |
| | | return user; |
| | | } |
| | |
| | | insert.setSex(Constants.getSexByCardNo( member.getIdcardNo()));//æ ¹æ®èº«ä»½è¯å·è·åæ§å« |
| | | insert.setJobDate(member.getJobDate()); |
| | | insert.setIsDangyuan(member.getIsDangyuan()); |
| | | insert.setPinyin(Constants.getChinesePingyin(member.getName())); |
| | | insert.setPositionId(member.getPositionId()); |
| | | if(StringUtils.isNotBlank(member.getIdcardNo())){ |
| | | insert.setBirthday( DateUtil.fromStringToDate("yyyyMMdd",IdcardUtil.getBirthByIdCard(member.getIdcardNo()))); |
| | |
| | | .set(SystemUser::getUpdateUser,member.getLoginUserInfo().getId()) |
| | | .set(SystemUser::getUpdateTime,new Date()) |
| | | .set(StringUtils.isNotBlank(member.getFaceImg()),SystemUser::getAvatar,member.getFaceImg()) |
| | | .set(StringUtils.isNotBlank(member.getName()),SystemUser::getPinyin,Constants.getChinesePingyin(member.getName())) |
| | | .set(StringUtils.isNotBlank(member.getPhone()),SystemUser::getMobile,member.getPhone()) |
| | | .set(StringUtils.isNotBlank(member.getPhone()),SystemUser::getUsername,member.getPhone()) |
| | | .set(StringUtils.isNotBlank(member.getName()),SystemUser::getRealname,member.getName()) |
| | |
| | | //å¦æäººè¸æ²¡åå |
| | | member.setFaceImg(null); |
| | | } |
| | | |
| | | member.setPinyin(Constants.getChinesePingyin(member.getName())); |
| | | return model; |
| | | } |
| | | |
| | |
| | | loginUserInfo = updateMember.getLoginUserInfo(); |
| | | } |
| | | //æ ¡éªåæ° å¹¶ä¸æ´æ°systemuser ææºå·åå·¥å·ä¿¡æ¯ï¼å¦æéè¦ä¿®æ¹çè¯ï¼ |
| | | Member model = isMemberUpdateParamValid(updateMember); |
| | | Member model = isMemberUpdateParamValid(updateMember); |
| | | updateMember.setEditor(loginUserInfo.getId()); |
| | | updateMember.setEditDate(new Date()); |
| | | //æµ·åº·äººåæ°å¢ä¸å¡ |
| | |
| | | .set(StringUtils.isNotBlank(updateMember.getName()),Member::getName,updateMember.getName()) |
| | | .set(Member::getEditDate,updateMember.getEditDate()) |
| | | .set(Member::getEditor,updateMember.getEditor()) |
| | | .set(StringUtils.isNotBlank(updateMember.getName()),Member::getPinyin,Constants.getChinesePingyin(updateMember.getName())) |
| | | .set(StringUtils.isNotBlank(updateMember.getIdcardNo()),Member::getIdcardNo,updateMember.getIdcardNo()) |
| | | .set(StringUtils.isNotBlank(updateMember.getIdcardDecode()),Member::getIdcardDecode,updateMember.getIdcardDecode()) |
| | | .set( Member::getAuthStatus,Constants.ZERO) |
| | |
| | | } |
| | | queryWrapper.eq(Member::getIsdeleted,Constants.ZERO); |
| | | queryWrapper.eq(Member::getWorkStatus,Constants.ZERO); |
| | | queryWrapper.orderByAsc(Member::getPinyin); |
| | | List<Member> list = memberJoinMapper.selectJoinList(Member.class,queryWrapper); |
| | | // if(list!=null){ |
| | | // for(Member m : list){ |
| | |
| | | queryWrapper.eq(Member::getCompanyId,member.getCompanyId()); |
| | | } |
| | | queryWrapper.eq(Member::getIsdeleted,Constants.ZERO); |
| | | queryWrapper.orderByAsc(Member::getPinyin); |
| | | List<Member> list = memberJoinMapper.selectJoinList(Member.class,queryWrapper); |
| | | if(list!=null){ |
| | | for(Member m : list){ |
| | |
| | | } |
| | | } |
| | | return list; |
| | | } |
| | | @Override |
| | | public void initPinyinTool(){ |
| | | MPJLambdaWrapper<Member> queryWrapper = new MPJLambdaWrapper<>(); |
| | | List<Member> list = memberJoinMapper.selectList(queryWrapper); |
| | | if(list!=null){ |
| | | for(Member m : list){ |
| | | if(m.getName()!=null){ |
| | | Member u = new Member(); |
| | | u.setId(m.getId()); |
| | | u.setPinyin(Constants.getChinesePingyin(m.getName())); |
| | | memberMapper.updateById(u); |
| | | } |
| | | } |
| | | } |
| | | |
| | | MPJLambdaWrapper<SystemUser> q1 = new MPJLambdaWrapper<>(); |
| | | List<SystemUser> list1 = systemUserMapper.selectList(q1); |
| | | if(list1!=null){ |
| | | for(SystemUser m : list1){ |
| | | if(m.getRealname()!=null){ |
| | | SystemUser u = new SystemUser(); |
| | | u.setId(m.getId()); |
| | | u.setPinyin(Constants.getChinesePingyin(m.getRealname())); |
| | | systemUserMapper.updateById(u); |
| | | } |
| | | } |
| | | } |
| | | MPJLambdaWrapper<Company> q2 = new MPJLambdaWrapper<>(); |
| | | List<Company> list2 = companyMapper.selectList(q2); |
| | | if(list2!=null){ |
| | | for(Company m : list2){ |
| | | if(m.getName()!=null){ |
| | | Company u = new Company(); |
| | | u.setId(m.getId()); |
| | | u.setPinyin(Constants.getChinesePingyin(m.getName())); |
| | | companyMapper.updateById(u); |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | @Override |
| | |
| | | // .eq(Member::getStatus,Constants.Status.ENABLE.getValue()) |
| | | // .eq(Member::getType,Constants.memberType.internal) |
| | | .eq(pageWrap.getModel().getHkStatus()!=null,Member::getHkStatus,pageWrap.getModel().getHkStatus()) |
| | | .orderByDesc(!Constants.equalsInteger(pageWrap.getModel().getIsdeleted(),Constants.ONE),Member::getCreateDate) |
| | | .orderByAsc(!Constants.equalsInteger(pageWrap.getModel().getIsdeleted(),Constants.ONE),Member::getPinyin) |
| | | .orderByDesc(Constants.equalsInteger(pageWrap.getModel().getIsdeleted(),Constants.ONE),Member::getEditDate); |
| | | if(Constants.formatIntegerNum(dataSyncConfig.getOrgUserDataOrigin())==DataSyncConfig.origin.erp){ |
| | | queryWrapper.eq( StringUtils.isNotBlank(pageWrap.getModel().getErpOrgId()),Member::getErpOrgId,pageWrap.getModel().getErpOrgId()); |
| | |
| | | .eq(Objects.nonNull(pageWrap.getModel().getStatus()),Member::getStatus,pageWrap.getModel().getStatus()) |
| | | .eq(Member::getType,Constants.memberType.visitor) |
| | | .eq(Member::getIsdeleted,Constants.ZERO) |
| | | .orderByDesc(Member::getCreateDate); |
| | | .orderByAsc(Member::getPinyin); |
| | | if(Constants.formatIntegerNum(dataSyncConfig.getOrgUserDataOrigin())==DataSyncConfig.origin.erp){ |
| | | queryWrapper.eq( StringUtils.isNotBlank(pageWrap.getModel().getErpOrgId()),Member::getErpOrgId,pageWrap.getModel().getErpOrgId()); |
| | | }else{ |
| | |
| | | |
| | | queryWrapper.selectAs(Position::getName,Member::getPositionName); |
| | | queryWrapper.leftJoin(Position.class,Position::getId,Member::getPositionId); |
| | | |
| | | queryWrapper.orderByAsc(Member::getPinyin); |
| | | IPage<Member> memberIPage = memberJoinMapper.selectJoinPage(page, Member.class,queryWrapper); |
| | | return PageData.from(memberIPage); |
| | | |
| | |
| | | .leftJoin(Company.class,Company::getId,Member::getCompanyId) |
| | | .eq(Member::getIsdeleted,Constants.ZERO) |
| | | .eq(Company::getType,Constants.ZERO) |
| | | .eq(Member::getStatus,Constants.ZERO) |
| | | .eq(Member::getStatus,Constants.ZERO |
| | | ) |
| | | .isNotNull(Member::getHkId) |
| | | .apply("to_days(LAST_VISIT_DATE)+ "+days+" < to_days(now())" )); |
| | | .apply("to_days(LAST_VISIT_DATE)+ "+days+" < to_days(now())" ) |
| | | .orderByAsc(Member::getPinyin)); |
| | | if(CollectionUtils.isEmpty(memberList)){ |
| | | return; |
| | | } |
| | |
| | | .eq(Member::getWorkStatus,Constants.ZERO) |
| | | .eq(Member::getCanVisit,Constants.ONE) |
| | | .eq(Company::getType,Constants.ONE) |
| | | .orderByAsc(Member::getPinyin) |
| | | ); |
| | | List<MemberVO> memberVOList = new ArrayList<>(); |
| | | if (com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(memberList)) { |
| | |
| | | queryWrapper.and(StringUtils.isNotBlank(visitMemberDTO.getName()), ms->ms.like(Member::getPhone,visitMemberDTO.getName()) |
| | | .or().like(Member::getPhone,visitMemberDTO.getName())); |
| | | } |
| | | queryWrapper.orderByDesc(Visits::getCreateDate); |
| | | queryWrapper.orderByAsc(Member::getPinyin); |
| | | // queryWrapper.orderByDesc(Visits::getCreateDate); |
| | | IPage<MemberVO> result = memberJoinMapper.selectJoinPage(page, MemberVO.class,queryWrapper); |
| | | |
| | | String prefixUrl = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() + |
| | |
| | | //广æ 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()); |
| | |
| | | import com.doumee.core.haikang.model.param.respose.*; |
| | | import com.doumee.core.haikang.service.HKCarOpenService; |
| | | import com.doumee.core.haikang.service.HKService; |
| | | import com.doumee.dao.web.reqeust.CarsJobAndContractByJobIdDTO; |
| | | import com.doumee.service.business.third.model.request.TmsFacrotyCodeListRequest; |
| | | import com.doumee.service.business.third.model.request.TmsOrderNoFinishListRequest; |
| | | import com.doumee.service.business.third.model.request.TmsOutQtyAndVehicleQtyRequest; |
| | |
| | | Constants.PlatformJobStatus.AUTHED_LEAVE.getKey(), |
| | | Constants.PlatformJobStatus.CALLED.getKey()) |
| | | .last("limit 1")); |
| | | |
| | | dealJobDetailAndContractBiz(job,data); |
| | | |
| | | return data; |
| | | |
| | | } |
| | | /** |
| | | * ãååºç©æä¸å¿è°åº¦ãçæ¿-æ ¹æ®è½¦çå·æ¥è¯¢ä½ä¸ä¿¡æ¯åååä¿¡æ¯éå |
| | | * |
| | | * @return |
| | | * |
| | | */ |
| | | @Override |
| | | public CarsJobAndContractVO getJobDetailsById(CarsJobAndContractByJobIdDTO param) { |
| | | CarsJobAndContractVO data = new CarsJobAndContractVO(); |
| | | if(param.getId() == null){ |
| | | return data; |
| | | } |
| | | PlatformJob job = platformJobMapper.selectJoinOne(PlatformJob.class, |
| | | new MPJLambdaWrapper<PlatformJob>() |
| | | .selectAll(PlatformJob.class) |
| | | .eq(PlatformJob::getId,param.getId()) |
| | | .last("limit 1")); |
| | | dealJobDetailAndContractBiz(job,data); |
| | | |
| | | return data; |
| | | |
| | | } |
| | | |
| | | private void dealJobDetailAndContractBiz(PlatformJob job, CarsJobAndContractVO data) { |
| | | if(job!=null){ |
| | | List<PlatformLog> logList = platformLogMapper.selectJoinList(PlatformLog.class, |
| | | new MPJLambdaWrapper<PlatformLog>() |
| | |
| | | if(detailList!=null){ |
| | | for(PlatformWmsDetail d : detailList){ |
| | | if(isExistIocode(d.getIocode(),data.getContractList())){ |
| | | continue; |
| | | continue; |
| | | } |
| | | tt = new CarsContractVO(); |
| | | tt.setIoCode(d.getIocode()); |
| | |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | | return data; |
| | | |
| | | } |
| | | |
| | | private List<PlatformWmsDetail> getDetailListByCode(String iocode, List<PlatformWmsDetail> detailList,CarsContractVO tt) { |
| | |
| | | @Override |
| | | public PlatformJobRunBoardNewVO platformJobCenterData(){ |
| | | PlatformJobRunBoardNewVO data = new PlatformJobRunBoardNewVO(); |
| | | Random random = new Random(); |
| | | |
| | | data.setMonthOutTimes(random.nextInt(1000)); |
| | | data.setYearOutTimes(random.nextInt(1000) * 11); |
| | | |
| | | data.setMonthOutTimes(0); |
| | | data.setYearOutTimes(0); |
| | | Date month = Utils.Date.getStart(new Date());//æ¬æ |
| | | Date lastMonth = DateUtil.addMonthToDate(month,-1);//䏿 |
| | | Date year = Utils.Date.getStart(new Date());//ä»å¹´ |
| | |
| | | .selectAs(PlatformJob::getStatus,PlatformJob::getStatus) |
| | | .selectAs(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("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(" to_days(create_date) <to_days(now())")); |
| | |
| | | } |
| | | return data; |
| | | } |
| | | |
| | | |
| | | private BigDecimal getDoneHoursByData(String start ,String end) { |
| | | List<PlatformLog> platformLogList = platformLogMapper.selectList(new QueryWrapper<PlatformLog>().lambda() |
| | |
| | | data.setHoursAbility(new BigDecimal(0)); |
| | | data.setCurrentPlanNum(new BigDecimal(0)); |
| | | data.setCurrentOrderNum(new BigDecimal(0)); |
| | | data.setNoNeedTransportOrderNum(new BigDecimal(0)); |
| | | data.setNeedTransportOrderNum(new BigDecimal(0)); |
| | | data.setCurrentOrderNum(new BigDecimal(0)); |
| | | data.setCrrentRestNum(new BigDecimal(0)); |
| | | data.setCrrentOutNum(new BigDecimal(0)); |
| | | List<TmsFactoryParam> paramList = factoryList(); |
| | |
| | | } |
| | | TmsOutboundCapabilityResponse result= tmsService.getOutboundCapability(param); |
| | | if(result !=null){ |
| | | String todayDate = DateUtil.getShortTime(new Date()); |
| | | List<String> planCodes = new ArrayList<>(); |
| | | List<String> todayCodes = new ArrayList<>(); |
| | | String todayDate = DateUtil.getShortTime(new Date()); |
| | | if(result.getCurrentDayOrderList()!=null && result.getCurrentDayOrderList().size()>0){ |
| | | for(TmsOutboundCapabilityInfoResponse model :result.getCurrentDayOrderList()){ |
| | | data.setCurrentOrderNum(data.getCurrentOrderNum().add(Constants.formatBigdecimal(model.getNcTotality())));//仿¥è®¢åé |
| | | /** |
| | | * DISPATCH_TYPE in(1,2) ä¸ TRANSPORT_CODEä¸ä¸ºç©ºï¼sum(NC_TOTALITY) + DISPATCH_TYPE not in(1,2) sum(NC_TOTALITY) |
| | | * 仿¥åºåºä¸è¾¾ç计å任塿»é |
| | | */ |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) |
| | | && (StringUtils.equals("1",model.getDispatchType()) || StringUtils.equals("2",model.getDispatchType()))){ |
| | | data.setCurrentPlanNum(data.getCurrentPlanNum().add(Constants.formatBigdecimal(model.getNcTotality())));//仿¥è®¢åé |
| | | } |
| | | if(!(StringUtils.equals("1",model.getDispatchType()) || StringUtils.equals("2",model.getDispatchType()))){ |
| | | data.setCurrentPlanNum(data.getCurrentPlanNum().add(Constants.formatBigdecimal(model.getNcTotality())));//仿¥è®¡åé |
| | | } |
| | | |
| | | /** |
| | | * 仿¥ä¸è¾¾åºåºç计åä»»å¡å¯¹åºçè¿è¾è½¦æ¬¡æ° |
| | | * TRANSPORT_CODEä¸ä¸ºç©ºcount(transport_code ) |
| | | */ |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),planCodes)){ |
| | | planCodes.add(model.getTransportCode()); |
| | | } |
| | | /** |
| | | * 仿¥ä¸è¾¾åºåºç计åä»»å¡å¯¹åºçè¿è¾è½¦æ¬¡æ° |
| | | * TRANSPORT_CODEä¸ä¸ºç©ºcount(transport_code ) |
| | | */ |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),planCodes)){ |
| | | planCodes.add(model.getTransportCode()); |
| | | } |
| | | /** |
| | | * out_dateä¸ºå½æ¥,sum(NC_TOTALITY) 仿¥å®æçåºåºä½ä¸ä»»å¡æ»é |
| | | * TRANSPORT_CODEä¸ä¸ºç©º ä¸out_dateä¸ºå½æ¥ count(transport_code) 仿¥å®æçåºåºä½ä¸ä»»å¡çè¿è¾è½¦æ¬¡æ° |
| | | */ |
| | | if(StringUtils.isNotBlank(model.getOutDate()) && model.getOutDate().length()> 10){ |
| | | String tDate = model.getOutDate().substring(0,10); |
| | | if(tDate.equals(todayDate)){ |
| | | //妿æ¯å½æ¥ |
| | | data.setCrrentOutNum(data.getCrrentOutNum().add(Constants.formatBigdecimal(model.getNcTotality())));//仿¥è®¢åé |
| | | } |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),todayCodes)){ |
| | | todayCodes.add(model.getTransportCode()); |
| | | } |
| | | } |
| | | dealOutOrderBiz(data,model,planCodes,todayCodes,todayDate); |
| | | } |
| | | } |
| | | if(result.getCurrentDayAgoOrderList()!=null && result.getCurrentDayAgoOrderList().size()>0){ |
| | | for(TmsOutboundCapabilityInfoResponse model :result.getCurrentDayAgoOrderList()){ |
| | | /** |
| | | * out_date为空ï¼sum(NC_TOTALITY) æ¨å¤©æªå®æåºåºè®¡åä»»å¡ |
| | | * out_date为空 ä¸TRANSPORT_CODEä¸ä¸ºç©º * count(transport_code ) æ¨å¤©æªå®æåºåºè®¡åä»»å¡è½¦æ¬¡ |
| | | */ |
| | | if(StringUtils.isBlank(model.getOutDate())){ |
| | | data.setCurrentPlanNum(data.getCurrentPlanNum().add(Constants.formatBigdecimal(model.getNcTotality())));//仿¥è®¡åé |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),planCodes)){ |
| | | planCodes.add(model.getTransportCode()); |
| | | } |
| | | } |
| | | dealOutOrderBiz(data,model,planCodes,todayCodes,todayDate); |
| | | } |
| | | } |
| | | data.setCurrentPlanCarNum(planCodes.size());//仿¥è®¡å车次 |
| | | data.setCurrentPlanCarNum(planCodes.size());//仿¥ä»»å¡è½¦æ¬¡ |
| | | data.setCrrentOutCarNum(todayCodes.size());//仿¥åºåºè½¦æ¬¡ |
| | | } |
| | | data.setCrrentRestNum(data.getCurrentPlanNum().subtract(data.getCrrentOutNum())); |
| | | data.setCrrentRestCarNum(data.getCurrentPlanCarNum() -data.getCrrentOutCarNum()); |
| | | // data.setCrrentRestNum(data.getCurrentPlanNum().subtract(data.getCrrentOutNum())); |
| | | // data.setCrrentRestCarNum(data.getCurrentPlanCarNum() -data.getCrrentOutCarNum()); |
| | | data.setCrrentRestNum(data.getCurrentPlanNum()); |
| | | data.setCrrentRestCarNum(data.getCurrentPlanCarNum()); |
| | | if(data.getCrrentRestNum().compareTo(new BigDecimal(0)) <=0){ |
| | | data.setCrrentRestNum(new BigDecimal(0)); |
| | | } |
| | |
| | | data.setCurrentPlanNum(Constants.formatBigdecimal(data.getCurrentPlanNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); |
| | | data.setCrrentOutNum(Constants.formatBigdecimal(data.getCrrentOutNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); |
| | | data.setCurrentOrderNum(Constants.formatBigdecimal(data.getCurrentOrderNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); |
| | | data.setNoNeedTransportOrderNum(Constants.formatBigdecimal(data.getNoNeedTransportOrderNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); |
| | | data.setNeedTransportOrderNum(Constants.formatBigdecimal(data.getNeedTransportOrderNum()).divide(new BigDecimal(5), 2, BigDecimal.ROUND_HALF_UP)); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 1ãå½å订åéï¼æªæ¢ç®åæªé
载订åéï¼ |
| | | * 2ãå½åä»»å¡éï¼æªæ¢ç®åå·²é
è½½æªåºåºè®¢åé+æ éé
è½½çæªåºåºä»»å¡éï¼ |
| | | * 3ãå½åä»»å¡éåå©ä½ä»»å¡éç»è®¡é»è¾ä¸è´ï¼ |
| | | * @param data |
| | | * @param model |
| | | */ |
| | | private void dealOutOrderBiz(WholeProvinceBoardVO data, TmsOutboundCapabilityInfoResponse model,List<String> planCodes,List<String> todayCodes, String todayDate ) { |
| | | |
| | | /** |
| | | * å½å订åéï¼æªè³ç®åæªé
è½½çæ°æ® |
| | | */ |
| | | if(StringUtils.isBlank(model.getTransportCode()) |
| | | &&( StringUtils.equals("1",model.getDispatchType()) || StringUtils.equals("2",model.getDispatchType()))){ |
| | | data.setCurrentOrderNum(data.getCurrentOrderNum().add(Constants.formatBigdecimal(model.getNcTotality())));//å½å订åé |
| | | } |
| | | /** |
| | | * å½åä»»å¡é(åå©ä½ä»»å¡éï¼ï¼æªè³ç®åå·²é
è½½æªåºåºç订å |
| | | */ |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) && StringUtils.isBlank(model.getOutDate())){ |
| | | data.setCurrentPlanNum(data.getCurrentPlanNum().add(Constants.formatBigdecimal(model.getNcTotality())));//å½åä»»å¡éï¼ç´¯è®¡ï¼ |
| | | data.setNeedTransportOrderNum(data.getNeedTransportOrderNum().add(Constants.formatBigdecimal(model.getNcTotality())));//ååå©ä½ä»»å¡éï¼ç´¯è®¡ï¼ |
| | | if(notInList(model.getTransportCode(),planCodes)){ |
| | | planCodes.add(model.getTransportCode()); |
| | | } |
| | | } |
| | | /** |
| | | * ååååï¼æ éé
è½½ä½æ¯æªå®æï¼ |
| | | */ |
| | | if(StringUtils.isBlank(model.getOutDate()) |
| | | && !StringUtils.equals("1",model.getDispatchType()) && !StringUtils.equals("2",model.getDispatchType())){ |
| | | data.setNoNeedTransportOrderNum(data.getNoNeedTransportOrderNum().add(Constants.formatBigdecimal(model.getNcTotality())));//ååå©ä½ä»»å¡éï¼ç´¯è®¡ï¼ |
| | | data.setCurrentPlanNum(data.getCurrentPlanNum().add(Constants.formatBigdecimal(model.getNcTotality())));//å½åä»»å¡éï¼ç´¯è®¡ï¼ |
| | | } |
| | | /** |
| | | * 仿¥åºåºéï¼åºåºæ¶é´ä¸ºä»å¤©ç |
| | | */ |
| | | if(StringUtils.isNotBlank(model.getOutDate()) && model.getOutDate().length()> 10){ |
| | | String tDate = model.getOutDate().substring(0,10); |
| | | if(tDate.equals(todayDate)){ |
| | | //妿æ¯å½æ¥ |
| | | data.setCrrentOutNum(data.getCrrentOutNum().add(Constants.formatBigdecimal(model.getNcTotality())));//仿¥åºåºé |
| | | if(StringUtils.isNotBlank(model.getTransportCode()) && notInList(model.getTransportCode(),todayCodes)){ |
| | | todayCodes.add(model.getTransportCode()); |
| | | } |
| | | } |
| | | } |
| | | |
| | | } |
| | | |
| | | private boolean notInList(String transportCode, List<String> planCodes) { |
| | | for(String s :planCodes){ |
| | | if(StringUtils.equals(transportCode,s)){ |
| | |
| | | |
| | | import com.doumee.core.haikang.model.cars.response.CarsAlarmResultListResponse; |
| | | import com.doumee.core.haikang.model.param.respose.*; |
| | | import com.doumee.dao.web.reqeust.CarsJobAndContractByJobIdDTO; |
| | | import com.doumee.service.business.third.model.request.TmsOrderNoFinishListRequest; |
| | | import com.doumee.service.business.third.model.response.TmsBasePageResponse; |
| | | import com.doumee.service.business.third.model.response.TmsOrderNoFinishListResponse; |
| | |
| | | PlatformJobRunBoardNewVO platformJobCenterData(); |
| | | |
| | | CarsJobAndContractVO getCarsJobDetails(CarsJobAndContractDTO param); |
| | | CarsJobAndContractVO getJobDetailsById(CarsJobAndContractByJobIdDTO param); |
| | | |
| | | List<TransportMeasureVO> transportMeasure(Integer queryType); |
| | | |