package com.doumee.cloud.admin; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.doumee.api.BaseController; import com.doumee.config.annotation.CloudRequiredPermission; import com.doumee.core.annotation.excel.ExcelExporter; import com.doumee.core.annotation.pr.PreventRepeat; import com.doumee.core.model.ApiResponse; import com.doumee.core.model.LoginUserInfo; import com.doumee.core.model.PageData; import com.doumee.core.model.PageWrap; import com.doumee.core.utils.Constants; import com.doumee.core.utils.DateUtil; import com.doumee.dao.business.model.Bookings; import com.doumee.dao.business.vo.RoomStatisticsVo; import com.doumee.dao.system.dto.UserStatisticsDTO; import com.doumee.dao.system.vo.UserStatisticsVo; import com.doumee.dao.web.response.DateTimeResourceDate; import com.doumee.dao.web.response.MeetingDetailResponse; import com.doumee.service.business.BookingsService; import io.swagger.annotations.Api; import io.swagger.annotations.ApiImplicitParam; import io.swagger.annotations.ApiImplicitParams; import io.swagger.annotations.ApiOperation; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.util.CollectionUtils; import org.springframework.web.bind.annotation.*; import javax.servlet.http.HttpServletResponse; import java.math.BigDecimal; import java.math.RoundingMode; import java.time.LocalDate; import java.time.LocalDateTime; import java.time.LocalTime; import java.util.ArrayList; import java.util.List; import java.util.Map; import java.util.Set; /** * @author 江蹄蹄 * @date 2023/05/04 18:18 */ @Api(tags = "会议室预定信息表") @RestController @RequestMapping(Constants.CLOUD_SERVICE_URL_INDEX+"/business/bookings") public class BookingsCloudController extends BaseController { @Autowired private BookingsService bookingsService; @PreventRepeat @ApiOperation("新建") @PostMapping("/create") @CloudRequiredPermission("business:bookings:create") public ApiResponse create(@RequestBody Bookings bookings,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ LoginUserInfo user = getLoginUser(token); bookings.setLoginUserInfo(user); bookings.setCreator(user.getId()); return ApiResponse.success(bookingsService.create(bookings)); } @ApiOperation("根据ID删除") @GetMapping("/delete/{id}") @CloudRequiredPermission("business:bookings:delete") public ApiResponse deleteById(@PathVariable Integer id,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ bookingsService.deleteById(id,this.getLoginUser(token)); return ApiResponse.success(null); } @ApiOperation("批量删除") @GetMapping("/delete/batch") @CloudRequiredPermission("business:bookings:delete") public ApiResponse deleteByIdInBatch(@RequestParam String ids,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ String [] idArray = ids.split(","); List idList = new ArrayList<>(); for (String id : idArray ){ idList.add(Integer.valueOf(id)); } bookingsService.deleteByIdInBatch(idList,this.getLoginUser(token)); return ApiResponse.success(null); } @ApiOperation("根据ID修改") @PostMapping("/updateById") @CloudRequiredPermission("business:bookings:update") public ApiResponse updateById(@RequestBody Bookings bookings,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ LoginUserInfo user = getLoginUser(token); bookings.setLoginUserInfo(user); bookings.setEditor(user.getId()); bookingsService.updateById(bookings); return ApiResponse.success(null); } @ApiOperation("分页查询") @PostMapping("/page") @CloudRequiredPermission("business:bookings:query") public ApiResponse> findPage (@RequestBody PageWrap pageWrap,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ pageWrap.getModel().setLoginUserInfo(this.getLoginUser(token)); return ApiResponse.success(bookingsService.findPage(pageWrap)); } @ApiOperation("导出Excel") @PostMapping("/exportExcel") @CloudRequiredPermission("business:bookings:exportExcel") public void exportExcel (@RequestBody PageWrap pageWrap, HttpServletResponse response,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ pageWrap.getModel().setLoginUserInfo(this.getLoginUser(token)); ExcelExporter.build(Bookings.class).export(bookingsService.findPage(pageWrap).getRecords(), "会议室预定信息表", response); } @ApiOperation("根据ID查询") @GetMapping("/{id}") @CloudRequiredPermission("business:bookings:query") public ApiResponse findById(@PathVariable Integer id,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ return ApiResponse.success(bookingsService.getMeetingDetail(id,getLoginUser(token).getId())); } @ApiOperation("根据日期和会议室主键查询占用信息") @PostMapping("/getMeetingDetailByDate") @CloudRequiredPermission("business:bookings:query") public ApiResponse getMeetingDetailByDate(@RequestBody Bookings bookings,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ return ApiResponse.success(bookingsService.getMeetingDetailByDate(bookings)); } @ApiOperation("取消") @PostMapping("/cancelById") @CloudRequiredPermission("business:bookings:update") public ApiResponse cancelById(@RequestBody Bookings bookings,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ bookings.setLoginUserInfo(this.getLoginUser(token)); bookingsService.cancelById(bookings); return ApiResponse.success(null); } @ApiOperation("会议室使用时长统计") @GetMapping("/getRoomStatistics") @CloudRequiredPermission("business:bookings:update") public ApiResponse> getRoomStatistics(@RequestParam Integer yearNum, @RequestParam Integer roomId){ return ApiResponse.success(bookingsService.getRoomStatistics(yearNum)); } @ApiOperation("人员参加会议时常") @PostMapping("/getUserStatistics") @CloudRequiredPermission("business:bookings:update") public ApiResponse> getUserStatistics(@RequestBody PageWrap pageWrap ){ return ApiResponse.success(bookingsService.getUserStatistics(pageWrap)); } @ApiOperation("人员参会时长统计导出Excel") @PostMapping("/exportUserStatistics") @CloudRequiredPermission("business:bookings:exportExcel") public void exportUserStatistics (@RequestBody PageWrap pageWrap,HttpServletResponse response,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ List records = bookingsService.getUserStatistics(pageWrap).getRecords(); if (!CollectionUtils.isEmpty(records)){ JSONArray o = (JSONArray) JSON.toJSON(records); o.forEach(s->{ JSONObject jsonObject = (JSONObject) s; Set> entries = jsonObject.entrySet(); for (Map.Entry entry:entries){ if (entry.getValue() instanceof BigDecimal){ BigDecimal value = (BigDecimal) entry.getValue(); entry.setValue(value.compareTo(value.setScale(0, RoundingMode.DOWN)) > 0 ? value : value.setScale(0, RoundingMode.DOWN)); } } }); records = o.toJavaList(UserStatisticsVo.class); } ExcelExporter.build(UserStatisticsVo.class).export(records, "人员参会时长统计", response); } @ApiOperation("会议室使用时长统计导出Excel") @PostMapping("/exportRoomStatistics") @CloudRequiredPermission("business:bookings:exportExcel") public void exportRoomStatistics (@RequestBody PageWrap pageWrap,HttpServletResponse response,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){ List roomStatistics = bookingsService.getRoomStatistics(pageWrap.getModel().getYearNum()); if (!CollectionUtils.isEmpty(roomStatistics)){ JSONArray o = (JSONArray) JSON.toJSON(roomStatistics); o.forEach(s->{ JSONObject jsonObject = (JSONObject) s; Set> entries = jsonObject.entrySet(); for (Map.Entry entry:entries){ if (entry.getValue() instanceof BigDecimal){ BigDecimal value = (BigDecimal) entry.getValue(); entry.setValue(value.compareTo(value.setScale(0, RoundingMode.DOWN)) > 0 ? value : value.setScale(0, RoundingMode.DOWN)); } } }); roomStatistics = o.toJavaList(RoomStatisticsVo.class); } ExcelExporter.build(RoomStatisticsVo.class).export(roomStatistics, "会议室使用时长统计", response); } @ApiOperation("参与的预约会议") @GetMapping("/reservationCancel") @ApiImplicitParams({ @ApiImplicitParam(paramType = "query", dataType = "Integer", name = "type", value = "1 今天 2 本周", required = true), }) public ApiResponse> getMyJoinBookingMeet(@RequestParam Integer type){ LocalDateTime startTime = LocalDateTime.of(LocalDate.now(), LocalTime.of(00,00,00)); LocalDateTime endTime = LocalDateTime.of(LocalDate.now(), LocalTime.of(23,59,59)); if(Constants.equalsInteger(type,Constants.TWO)){ startTime = DateUtil.getMonday(); endTime = DateUtil.getSunday(); } return ApiResponse.success(bookingsService.getMyJoinBookingMeet(getLoginUser(null).getId(), null,startTime,endTime)); } /** * 获取用户当当月预约会议情况 * @return */ @ApiOperation("获取用户当当月预约会议情况") @PostMapping("/findMothBookingMeet") public ApiResponse> findMothBookingMeet( @RequestParam(required = false) Integer roomId,String dateMonth){ return ApiResponse.success(bookingsService.findMothBookingMeet(getLoginUser(null).getId(),roomId,dateMonth)); } }