public static List<Appointment> findByWeek(long uid, long week)
			throws SQLException {
		List<Appointment> aAppt = new ArrayList<Appointment>();
		long endOfWeek = week + 6 * DateUtil.DAY_LENGTH;

		// once
		aAppt.addAll(Appointment.findOnceByDaySpan(uid, week, endOfWeek));

		// daily
		aAppt.addAll(Appointment.findDailyByDaySpan(uid, week, endOfWeek));

		// weekly
		aAppt.addAll(Appointment.findWeeklyByDaySpan(uid, week, endOfWeek));

		// monthly
		aAppt.addAll(Appointment.findMonthlyByDaySpan(uid, week, endOfWeek));

		return aAppt;
	}