仅记录用户的Fullcalendar数据

Question

@RestController
class EventController {
    
    @Autowired
    private EventJpaRepository eventRepository;
    
    @RequestMapping(value="/allevents", method=RequestMethod.GET)
    public List<Event> events() {
        return eventRepository.findAll();
    }
    
    @RequestMapping(value="/events", method=RequestMethod.GET)
    public List<Event> getEventsInRange(@RequestParam(value = "start", required = true) String start, 
                        @RequestParam(value = "end", required = true) String end, @RequestParam(value = "title", required = true) String title) {
    Date startDate = null;
    Date endDate = null;
    SimpleDateFormat inputDateFormat=new SimpleDateFormat("yyyy-MM-dd");

    try {
        startDate = inputDateFormat.parse(start);
    } catch (ParseException e) {
        throw new BadDateFormatException("bad start date: " + start);
    }

    try {
        endDate = inputDateFormat.parse(end);
    } catch (ParseException e) {
        throw new BadDateFormatException("bad end date: " + end);
    }

    LocalDateTime startDateTime = LocalDateTime.ofInstant(startDate.toInstant(),
    ZoneId.systemDefault());

    LocalDateTime endDateTime = LocalDateTime.ofInstant(endDate.toInstant(),
    ZoneId.systemDefault());

    return eventRepository.findByDateBetween(startDateTime, endDateTime); 
    }
}

@Repository
interface EventJpaRepository extends JpaRepository<Event, Long> {
        
    @Query("select b from Event b where b.start >= ?1 and b.end <= ?2")
    public List<Event> findByDateBetween(LocalDateTime start, LocalDateTime end);
    
}

<script> 
    document.addEventListener('DOMContentLoaded', function() {
        var calendarEl = document.getElementById('calendar');
        var calendar = new FullCalendar.Calendar(calendarEl, {
            initialView : 'dayGridMonth',
            headerToolbar: {
                left: 'prev,next today',
                center: 'title',
                right: 'dayGridMonth,timeGridWeek,timeGridDay'
            },
            locale: 'it',
            editable : false,
            eventLimit : true, // allow "more" link when too many events
            events : {
                url : '/allevents',
                type : 'GET',
                error : function() {
                    alert('there was an error while fetching events!');
                },
            }
        });     
        calendar.render();
    });

    
</script>

Answer 1

您的代码缺少一些东西。现在，查询返回一个时间范围内的所有事件。要将其仅限于登录的用户，您需要将Doctor表与用户ID联接在查询中。由于不知道会话是如何存储的，也不知道Doctor表是什么样子，您的查询可能需要进行如下更新：

@Query("select b from Event b join Doctor d on b.doctor_id=d.id where b.doctorId = ?1 AND b.start >= ?2 and b.end <= ?3")
public List<Event> findByDoctorIdAndDateBetween(Long doctorId, LocalDateTime start, LocalDateTime end, String userId);

我还没有测试过，但这应该会让你朝着正确的方向前进。

编辑：对不起，我已经有一段时间没有写JPA了。我已经更新了上面的查询，您将需要一个

@OneToMany(mappedBy="doctorId")
List<Event> events;

@ManyToOne
Long doctorId