package com.doumee.api; 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.LoginNoRequired; 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.apache.shiro.SecurityUtils; import org.apache.shiro.authz.annotation.RequiresPermissions; 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("/cloudService/bookings") public class CloudBookingsController extends BaseController { @Autowired private BookingsService bookingsService; @ApiOperation("测试网管") @GetMapping("/test") public ApiResponse test() { return ApiResponse.success("会议室测试成功"); } @LoginNoRequired @ApiOperation("测试无需登录成功") @GetMapping("/testNoLogin") public ApiResponse testNoLogin() { return ApiResponse.success("会议室管理测试无需登录成功"); } @PreventRepeat @ApiOperation("新建") @PostMapping("/create") public ApiResponse create(@RequestBody Bookings bookings) { LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); bookings.setCreator(user.getId()); return ApiResponse.success(bookingsService.create(bookings)); } @ApiOperation("根据ID删除") @GetMapping("/delete/{id}") public ApiResponse deleteById(@PathVariable Integer id) { bookingsService.deleteById(id); return ApiResponse.success(null); } @ApiOperation("批量删除") @GetMapping("/delete/batch") public ApiResponse deleteByIdInBatch(@RequestParam String ids) { String [] idArray = ids.split(","); List idList = new ArrayList<>(); for (String id : idArray) { idList.add(Integer.valueOf(id)); } bookingsService.deleteByIdInBatch(idList); return ApiResponse.success(null); } @ApiOperation("根据ID修改") @PostMapping("/updateById") public ApiResponse updateById(@RequestBody Bookings bookings) { LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); bookings.setCreator(user.getId()); bookingsService.updateById(bookings); return ApiResponse.success(null); } @ApiOperation("分页查询") @PostMapping("/page") public ApiResponse> findPage (@RequestBody PageWrap pageWrap) { return ApiResponse.success(bookingsService.findPage(pageWrap)); } @ApiOperation("导出Excel") @PostMapping("/exportExcel") @RequiresPermissions("business:bookings:exportExcel") public void exportExcel (@RequestBody PageWrap pageWrap, HttpServletResponse response) { ExcelExporter.build(Bookings.class).export(bookingsService.findPage(pageWrap).getRecords(), "会议室预定信息表", response); } @ApiOperation("根据ID查询") @GetMapping("/{id}") public ApiResponse findById(@PathVariable Integer id) { return ApiResponse.success(bookingsService.getMeetingDetail(id)); } @ApiOperation("取消") @PostMapping("/cancelById") public ApiResponse cancelById(@RequestBody Bookings bookings) { bookingsService.cancelById(bookings); return ApiResponse.success(null); } @ApiOperation("会议室使用时长统计") @GetMapping("/getRoomStatistics") public ApiResponse> getRoomStatistics(@RequestParam Integer yearNum, @RequestParam Integer roomId){ return ApiResponse.success(bookingsService.getRoomStatistics(yearNum)); } @ApiOperation("人员参加会议时常") @PostMapping("/getUserStatistics") public ApiResponse> getUserStatistics(@RequestBody PageWrap pageWrap ){ return ApiResponse.success(bookingsService.getUserStatistics(pageWrap)); } @ApiOperation("人员参会时长统计导出Excel") @PostMapping("/exportUserStatistics") public void exportUserStatistics (@RequestBody PageWrap pageWrap,HttpServletResponse response) { 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") public void exportRoomStatistics (@RequestBody PageWrap pageWrap,HttpServletResponse response) { 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().getId(), null,startTime,endTime)); } /** * 获取用户当当月预约会议情况 * @return */ @ApiOperation("获取用户当当月预约会议情况") @PostMapping("/findMothBookingMeet") public ApiResponse> findMothBookingMeet( @RequestParam(required = false) Integer roomId,String dateMonth){ return ApiResponse.success(bookingsService.findMothBookingMeet(getLoginUser().getId(),roomId,dateMonth)); } }