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<Integer> 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<PageData<Bookings>> findPage (@RequestBody PageWrap<Bookings> 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<Bookings> 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<MeetingDetailResponse> 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<MeetingDetailResponse> 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<List<RoomStatisticsVo>> getRoomStatistics(@RequestParam Integer yearNum, @RequestParam Integer roomId){
|
return ApiResponse.success(bookingsService.getRoomStatistics(yearNum));
|
}
|
|
@ApiOperation("人员参加会议时常")
|
@PostMapping("/getUserStatistics")
|
@CloudRequiredPermission("business:bookings:update")
|
public ApiResponse<PageData<UserStatisticsVo>> getUserStatistics(@RequestBody PageWrap<UserStatisticsDTO> pageWrap ){
|
return ApiResponse.success(bookingsService.getUserStatistics(pageWrap));
|
}
|
|
@ApiOperation("人员参会时长统计导出Excel")
|
@PostMapping("/exportUserStatistics")
|
@CloudRequiredPermission("business:bookings:exportExcel")
|
public void exportUserStatistics (@RequestBody PageWrap<UserStatisticsDTO> pageWrap,HttpServletResponse response,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){
|
List<UserStatisticsVo> records = bookingsService.getUserStatistics(pageWrap).getRecords();
|
if (!CollectionUtils.isEmpty(records)){
|
JSONArray o = (JSONArray) JSON.toJSON(records);
|
o.forEach(s->{
|
JSONObject jsonObject = (JSONObject) s;
|
Set<Map.Entry<String, Object>> entries = jsonObject.entrySet();
|
for (Map.Entry<String, Object> 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<UserStatisticsDTO> pageWrap,HttpServletResponse response,@RequestHeader(Constants.HEADER_USER_TOKEN) String token){
|
List<RoomStatisticsVo> roomStatistics = bookingsService.getRoomStatistics(pageWrap.getModel().getYearNum());
|
if (!CollectionUtils.isEmpty(roomStatistics)){
|
JSONArray o = (JSONArray) JSON.toJSON(roomStatistics);
|
o.forEach(s->{
|
JSONObject jsonObject = (JSONObject) s;
|
Set<Map.Entry<String, Object>> entries = jsonObject.entrySet();
|
for (Map.Entry<String, Object> 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<List<Bookings>> 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<List<DateTimeResourceDate>> findMothBookingMeet( @RequestParam(required = false) Integer roomId,String dateMonth){
|
return ApiResponse.success(bookingsService.findMothBookingMeet(getLoginUser(null).getId(),roomId,dateMonth));
|
}
|
}
|
