/*
* Copyright (C) 2010 Ixonos Plc.
- * Copyright (C) 2011-2015 Philipp Spitzer, gregor herrmann, Stefan Stahl
+ * Copyright (C) 2011-2024 Philipp Spitzer, gregor herrmann, Stefan Stahl
*
* This file is part of ConfClerk.
*
<< QSqlField("xid_track", QVariant::Int)
<< QSqlField("type", QVariant::String)
<< QSqlField("language", QVariant::String)
- << QSqlField("favourite", QVariant::Bool)
+ << QSqlField("favourite", QVariant::Int)
<< QSqlField("alarm", QVariant::Bool)
<< QSqlField("tag", QVariant::String)
<< QSqlField("title", QVariant::String)
query.prepare(selectQuery() + "WHERE xid_conference = :conf AND ( \
( start >= :s1 AND ( start + duration ) < :e1 ) \
OR ( ( start + duration ) > :s2 AND start < :e2 ) ) \
- AND favourite = 1 AND NOT id = :id ORDER BY start, duration");
+ AND favourite >= 1 AND NOT id = :id ORDER BY start, duration");
query.bindValue(":conf", event.conferenceId());
query.bindValue(":s1", convertToDb(event.start(), QVariant::DateTime));
query.bindValue(":e1", convertToDb(event.start().toTime_t()+event.duration(), QVariant::DateTime));
QList<Event> Event::getImminentAlarmEvents(int maxSecToAlarm, int conferenceId) {
+ Conference conference = Conference::getById(conferenceId);
QSqlQuery query;
query.prepare(selectQuery() + "WHERE xid_conference = :conf AND (start < :start AND alarm = 1) ORDER BY start, duration");
query.bindValue(":conf", conferenceId);
- query.bindValue(":start", convertToDb(QDateTime::currentDateTime().addSecs(maxSecToAlarm), QVariant::DateTime));
+ QDateTime start;
+ if (conference.hasUtcOffset()) {
+ start = QDateTime::currentDateTimeUtc().addSecs(conference.utcOffset() * 60);
+ } else {
+ start = QDateTime::currentDateTime();
+ if (conference.hasDisplayTimeShift()) start = start.addSecs(conference.displayTimeShift() * 60);
+ }
+ start = start.addSecs(maxSecToAlarm);
+ query.bindValue(":start", convertToDb(start, QVariant::DateTime));
return load(query);
}
Conference conference = Conference::getById(conferenceId);
QDateTime dayStart(date, conference.dayChangeTime(), Qt::UTC);
QSqlQuery query;
- query.prepare(selectQuery() + QString("WHERE xid_conference = :conf AND start >= :start AND start < :end AND favourite = 1 ORDER BY start, duration"));
+ query.prepare(selectQuery() + QString("WHERE xid_conference = :conf AND start >= :start AND start < :end AND favourite >= 1 ORDER BY start, duration"));
query.bindValue(":conf", conferenceId);
query.bindValue(":start", dayStart.toTime_t());
query.bindValue(":end", dayStart.addDays(1).toTime_t());
return mLinksList;
}
-bool Event::hasTimeConflict() const
-{
- if(!isFavourite()) // if it's not favourite, it can't have time-conflict
- return false;
+Favourite Event::timeConflict() const {
+ if (favourite() == Favourite_no) // if it's not favourite, it can't have time-conflict
+ return Favourite_no;
+
+ QList<Event> events = conflictEvents(id(),conferenceId());
+
+ // find "strongest" conflict
+ Favourite f = Favourite_no;
+ for (int i = 0; i != events.size(); ++i) {
+ switch (events[i].favourite()) {
+ case Favourite_strong: f = Favourite_strong; break;
+ case Favourite_weak: if (f == Favourite_no) f = Favourite_weak; break;
+ case Favourite_no: break;
+ }
+ }
+ return f;
- return conflictEvents(id(),conferenceId()).count() > 0 ? true : false;
+}
+
+void Event::cycleFavourite(bool back) {
+ switch (favourite()) {
+ case Favourite_no: setFavourite(back ? Favourite_weak : Favourite_strong); break;
+ case Favourite_strong: setFavourite(back ? Favourite_no : Favourite_weak); break;
+ case Favourite_weak: setFavourite(back ? Favourite_strong : Favourite_no); break;
+ }
}
void Event::setRoom(const QString &room)