SpringBoot+Vue 管理系统毕业设计｜软件工程毕设开发实战

flowchart LR
    A[用户登录系统] --> B[浏览自习室座位]
    B --> C{使用智能推荐?}
    C --是--> D[协同过滤算法计算推荐座位]
    C --否--> E[手动选择座位]
    D --> F[提交预约申请]
    E --> F
    F --> G[后端校验预约规则]
    G -->|校验成功| H[生成预约记录]
    G -->|校验失败| I[返回预约失败提示]
    H --> J[到店签到]
    J --> K[自习结束，释放座位]

@RestController
@RequestMapping("/reservation")
public class ReservationController {
    @Autowired
    private ReservationService reservationService;
    /**
     * 提交座位预约
     */
    @PostMapping("/add")
    public Result<?> addReservation(@RequestBody ReservationDTO reservationDTO){
        // 参数校验：预约起止时间
        if(reservationDTO.getReserveStart().after(reservationDTO.getReserveEnd())){
            return Result.error("预约起始时间不能晚于结束时间");
        }
        boolean check = reservationService.checkSeatConflict(reservationDTO);
        if(!check){
            return Result.error("该座位此时间段已被预约，存在冲突");
        }
        reservationService.saveReservation(reservationDTO);
        return Result.success("预约成功");
    }
    /**
     * 获取智能推荐座位列表
     */
    @GetMapping("/recommend/{userId}")
    public Result<List<SeatVO>> getRecommendSeat(@PathVariable Long userId){
        List<SeatVO> recommendList = reservationService.getRecommendSeatByCF(userId);
        return Result.success(recommendList);
    }
}

@Service
public class ReservationServiceImpl implements ReservationService {
    @Autowired
    private ReservationMapper reservationMapper;
    @Override
    public List<SeatVO> getRecommendSeatByCF(Long userId) {
        // 1.查询当前用户历史预约记录
        List<Reservation> historyList = reservationMapper.selectByUserId(userId);
        if(historyList == null || historyList.size() == 0){
            // 无历史记录，返回热门座位
            return reservationMapper.selectHotSeat();
        }
        // 2.计算用户相似度，找到兴趣相似用户集合
        List<Long> similarUserIds = calculateUserSimilar(userId);
        // 3.获取相似用户预约过的座位，过滤当前已占用座位
        List<SeatVO> candidateSeat = reservationMapper.selectSeatBySimilarUser(similarUserIds);
        // 4.过滤掉已经被预约的座位，返回推荐结果
        return filterAvailableSeat(candidateSeat);
    }
    // 计算用户相似度简化实现
    private List<Long> calculateUserSimilar(Long userId){
        // 基于用户预约的自习室、时间段、座位类型，计算相似度
        // 毕设阶段可简化实现，重点体现算法思想
        return reservationMapper.getSimilarUserId(userId);
    }
}

<template>
  <div class="seat-container">
    <el-card title="自习室座位列表">
      <el-row :gutter="10">
        <el-col :span="4" v-for="item in seatList" :key="item.id">
          <el-button 
            :type="item.seat_status===0?'success':'danger'"
            @click="selectSeat(item)"
            :disabled="item.seat_status!==0">
            {{item.seat_no}}
          </el-button>
        </el-col>
      </el-row>
    </el-card>
    <el-card title="智能推荐座位">
      <el-table :data="recommendList">
        <el-table-column label="自习室名称" prop="roomName"/>
        <el-table-column label="座位编号" prop="seatNo"/>
        <el-table-column label="座位类型" prop="seatType"/>
        <el-table-column label="操作">
          <template #default="scope">
            <el-button type="primary" @click="selectSeat(scope.row)">预约</el-button>
          </template>
        </el-table-column>
      </el-table>
    </el-card>
  </div>
</template>
<script>
export default {
  data(){
    return {
      seatList:[],
      recommendList:[],
    }
  },
  mounted(){
    this.getSeatList();
    this.getRecommend();
  },
  methods:{
    async getRecommend(){
      const res = await this.$api.get(`/reservation/recommend/${this.$store.state.userId}`);
      this.recommendList = res.data;
    },
    selectSeat(row){
      // 弹出预约时间选择弹窗
    }
  }
}
</script>