[e5bc908] | 1 | #ifndef EVENT_H |
---|
| 2 | #define EVENT_H |
---|
| 3 | |
---|
| 4 | #include <QDateTime> |
---|
[5a73d27] | 5 | #include <QVector> |
---|
| 6 | #include <QStringList> |
---|
[e5bc908] | 7 | |
---|
[5a73d27] | 8 | #include <ormrecord.h> |
---|
| 9 | |
---|
| 10 | /** |
---|
| 11 | NoSuchEventException is thrown when required event does not exist. |
---|
| 12 | */ |
---|
| 13 | class NoSuchEventException |
---|
| 14 | { |
---|
| 15 | }; |
---|
| 16 | |
---|
[20a6010] | 17 | class Event : public OrmRecord<Event> |
---|
[e5bc908] | 18 | { |
---|
| 19 | public: |
---|
[64122f1] | 20 | static const QSqlRecord sColumns; |
---|
[c790268] | 21 | //static QString const sTableName; |
---|
[64122f1] | 22 | static const QString sTable1Name; |
---|
| 23 | static const QString sTable2Name; |
---|
| 24 | static const int sTable1ColCount; |
---|
| 25 | static const int sTable2ColCount; |
---|
[5a73d27] | 26 | public: |
---|
[20a6010] | 27 | static Event getById(int id, int conferenceId); |
---|
[64122f1] | 28 | static QList<Event> getByDate(const QDate & date, int conferenceId, QString orderBy); |
---|
| 29 | static QList<Event> getFavByDate(const QDate & date, int conferenceId); // get Favourities by Date |
---|
[e5bc908] | 30 | public: |
---|
[c790268] | 31 | // Table 1 |
---|
[46a5aba] | 32 | int id() const { return value("id").toInt(); } |
---|
| 33 | int conferenceId() const { return value("xid_conference").toInt(); } |
---|
[4693fa6] | 34 | QDateTime start() const { return value("start").toDateTime(); } |
---|
[46a5aba] | 35 | int duration() const { return value("duration").toInt(); } |
---|
[4693fa6] | 36 | int trackId() const { return value("xid_track").toInt(); } |
---|
[46a5aba] | 37 | QString type() const { return value("type").toString(); } |
---|
| 38 | QString language() const { return value("language").toString(); } |
---|
| 39 | bool isFavourite() const { return value("favourite").toBool(); } |
---|
| 40 | bool hasAlarm() const { return value("alarm").toBool(); } |
---|
[f2ef735] | 41 | bool hasTimeConflict() const { return true; /*return value("warning").toBool()*/; } //TODO |
---|
[c790268] | 42 | // Table 2 : virtual table for FTS (Full Text Search) |
---|
[46a5aba] | 43 | QString tag() const { return value("tag").toString(); } |
---|
| 44 | QString title() const { return value("title").toString(); } |
---|
| 45 | QString subtitle() const { return value("subtitle").toString(); } |
---|
| 46 | QString abstract() const { return value("abstract").toString(); } |
---|
| 47 | QString description() const { return value("description").toString(); } |
---|
[f9db452] | 48 | // records from other tables associated with 'id' |
---|
| 49 | QString room() const; |
---|
[395d6d3] | 50 | QStringList persons() const; |
---|
[20a6010] | 51 | |
---|
[c790268] | 52 | // Table 1 |
---|
[46a5aba] | 53 | void setId(int id) { setValue("id", id); } |
---|
| 54 | void setConferenceId(int conferenceId) { setValue("xid_conference", conferenceId); } |
---|
[4693fa6] | 55 | void setStart(const QDateTime & start) { setValue("start", start); } |
---|
[46a5aba] | 56 | void setDuration(int duration) { setValue("duration", duration); } |
---|
[4693fa6] | 57 | void setTrackId(int trackId) { setValue("xid_track", trackId); } |
---|
[46a5aba] | 58 | void setType(const QString & type) { setValue("type", type); } |
---|
| 59 | void setLanguage(const QString & language) { setValue("language", language); } |
---|
| 60 | void setFavourite(bool favourite) { setValue("favourite", (int)((favourite))); } |
---|
| 61 | void setHasAlarm(bool alarm) { setValue("alarm", (int)((alarm))); } |
---|
[c790268] | 62 | // Table 2 : virtual table for FTS (Full Text Search) |
---|
| 63 | void setTag(const QString& tag) { setValue("tag", tag); } |
---|
| 64 | void setTitle(const QString& title) { setValue("title", title); } |
---|
| 65 | void setSubtitle(const QString& subtitle) { setValue("subtitle", subtitle); } |
---|
| 66 | void setAbstract(const QString& abstract) { setValue("abstract", abstract); } |
---|
| 67 | void setDescription(const QString& description) { setValue("description", description); } |
---|
[f9db452] | 68 | // records from other tables associated with 'id' |
---|
| 69 | void setRoom(const QString& room); |
---|
[395d6d3] | 70 | void setPersons(const QStringList &persons); |
---|
[20a6010] | 71 | |
---|
| 72 | friend class EventTest; |
---|
[e5bc908] | 73 | }; |
---|
| 74 | |
---|
| 75 | #endif // EVENT_H |
---|
[680a4da] | 76 | |
---|