| | |
| | | bookquery.eq(Bookings::getIsdeleted, Constants.ZERO); |
| | | bookquery.eq(Bookings::getStatus, Constants.ZERO); |
| | | bookquery.apply("DATE_FORMAT(t.START_TIME,'%Y-%m-%d') = DATE_FORMAT(now(),'%Y-%m-%d') " ); |
| | | Integer todayBookingsNum= bookingsJoinMapper.selectCount(bookquery); |
| | | Long todayBookingsNum= bookingsJoinMapper.selectCount(bookquery); |
| | | json.put("todayBookingsNum",todayBookingsNum); |
| | | |
| | | //今日会议时长(小时) |
| | |
| | | MPJLambdaWrapper<Rooms> rm1 = new MPJLambdaWrapper<>(); |
| | | rm1.eq(Rooms::getIsdeleted, Constants.ZERO); |
| | | rm1.eq(Rooms::getStatus, Constants.ZERO); |
| | | Integer roomNum= roomsJoinMapper.selectCount(rm1); |
| | | Long roomNum= roomsJoinMapper.selectCount(rm1); |
| | | json.put("roomNum",roomNum); |
| | | |
| | | //员工数量 |