| | |
| | | |
| | | |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.doumee.core.model.ApiResponse; |
| | | import com.doumee.core.model.PageData; |
| | | import com.doumee.core.model.PageWrap; |
| | | import com.doumee.service.business.third.model.ApiResponse; |
| | | import com.doumee.service.business.third.model.PageWrap; |
| | | import com.doumee.core.utils.Constants; |
| | | import com.doumee.dao.business.join.BookingsJoinMapper; |
| | | import com.doumee.dao.business.join.RoomsJoinMapper; |
| | |
| | | import com.github.yulichang.wrapper.MPJLambdaWrapper; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import org.apache.shiro.authz.annotation.RequiresPermissions; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.PostMapping; |
| | | import org.springframework.web.bind.annotation.RequestBody; |
| | |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.math.RoundingMode; |
| | | import java.text.ParseException; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.Date; |
| | |
| | | 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); |
| | | |
| | | //员工数量 |