2 * Copyright (C) 2010 Ixonos Plc.
3 * Copyright (C) 2011-2021 Philipp Spitzer, gregor herrmann, Stefan Stahl
5 * This file is part of ConfClerk.
7 * ConfClerk is free software: you can redistribute it and/or modify it
8 * under the terms of the GNU General Public License as published by the Free
9 * Software Foundation, either version 2 of the License, or (at your option)
12 * ConfClerk is distributed in the hope that it will be useful, but
13 * WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
14 * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
17 * You should have received a copy of the GNU General Public License along with
18 * ConfClerk. If not, see <http://www.gnu.org/licenses/>.
25 #include <QStringList>
27 #include "ormrecord.h"
32 NoSuchEventException is thrown when required event does not exist.
34 class NoSuchEventException
39 enum Favourite {Favourite_no=0, Favourite_weak=2, Favourite_strong=1};
42 class Event : public OrmRecord<Event>
46 static const QSqlRecord sColumns;
47 static QString const sTableName;
49 static Event getById(int id, int conferenceId);
50 static QList<Event> getByDate(const QDate & date, int conferenceId, QString orderBy);
51 static QList<Event> getFavByDate(const QDate & date, int conferenceId); // get favourites by date
52 static QList<Event> getSearchResultByDate(const QDate& date, int conferenceId, QString orderBy);
53 static QList<Event> getByTrack(int id);
54 static QList<Event> getByDateAndRoom(const QDate& date, int conferenceId);
55 static QList<Event> conflictEvents(int aEventId, int conferenceId);
56 static QList<Event> getImminentAlarmEvents(int maxSecToAlarm, int conferenceId);
58 int id() const { return value("id").toInt(); }
59 int conferenceId() const { return value("xid_conference").toInt(); }
60 QDateTime start() const { return value("start").toDateTime(); }
61 /// duration of the event in seconds
62 int duration() const { return value("duration").toInt(); }
63 int trackId() const { return value("xid_track").toInt(); }
64 QString type() const { return value("type").toString(); }
65 QString language() const { return value("language").toString(); }
66 Favourite favourite() const { return static_cast<Favourite>(value("favourite").toInt()); }
67 bool hasAlarm() const { return value("alarm").toBool(); }
68 Favourite timeConflict() const;
69 QString tag() const { return value("tag").toString(); }
70 QString title() const { return value("title").toString(); }
71 QString subtitle() const { return value("subtitle").toString(); }
72 QString abstract() const { return value("abstract").toString(); }
73 QString description() const { return value("description").toString(); }
74 // records from other tables associated with 'id'
78 QStringList persons();
79 QMap<QString,QString> links();
81 void setId(int id) { setValue("id", id); }
82 void setConferenceId(int conferenceId) { setValue("xid_conference", conferenceId); }
83 void setStart(const QDateTime & start) { setValue("start", start); }
84 void setDuration(int duration) { setValue("duration", duration); }
85 void setTrackId(int trackId) { setValue("xid_track", trackId); }
86 void setType(const QString & type) { setValue("type", type); }
87 void setLanguage(const QString & language) { setValue("language", language); }
88 void setFavourite(Favourite favourite) { setValue("favourite", (int) favourite); }
89 void cycleFavourite(bool back = false);
90 void setHasAlarm(bool alarm) { setValue("alarm", (int)((alarm))); }
91 void setTag(const QString& tag) { setValue("tag", tag); }
92 void setTitle(const QString& title) { setValue("title", title); }
93 void setSubtitle(const QString& subtitle) { setValue("subtitle", subtitle); }
94 void setAbstract(const QString& abstract) { setValue("abstract", abstract); }
95 void setDescription(const QString& description) { setValue("description", description); }
96 // records from other tables associated with 'id'
97 void setRoom(const QString& room);
98 void setPersons(const QStringList &persons);
99 void setLinks(const QMap<QString,QString> &aLinks);
101 friend class EventTest;
104 QStringList mPersonsList;
105 QMap<QString,QString> mLinksList;