| 1 | #include "event.h" |
|---|
| 2 | |
|---|
| 3 | QSqlRecord const Event::sColumns = Event::toRecord(QList<QSqlField>() |
|---|
| 4 | << QSqlField("id", QVariant::Int) |
|---|
| 5 | << QSqlField("xid_conference", QVariant::Int) |
|---|
| 6 | << QSqlField("start", QVariant::DateTime) |
|---|
| 7 | << QSqlField("duration", QVariant::Int) |
|---|
| 8 | << QSqlField("xid_activity", QVariant::Int) |
|---|
| 9 | << QSqlField("type", QVariant::String) |
|---|
| 10 | << QSqlField("language", QVariant::String) |
|---|
| 11 | << QSqlField("favourite", QVariant::Bool)); |
|---|
| 12 | |
|---|
| 13 | QString const Event::sTableName = QString("event"); |
|---|
| 14 | |
|---|
| 15 | Event Event::getById(int id, int conferenceId) |
|---|
| 16 | { |
|---|
| 17 | QSqlQuery query; |
|---|
| 18 | query.prepare(selectQuery() + "WHERE id = :id AND xid_conference = :conf"); |
|---|
| 19 | query.bindValue(":id", id); |
|---|
| 20 | query.bindValue(":conf", conferenceId); |
|---|
| 21 | return loadOne(query); |
|---|
| 22 | } |
|---|
| 23 | |
|---|
| 24 | QList<Event> Event::getByDate(const QDate& date, int conferenceId) |
|---|
| 25 | { |
|---|
| 26 | QSqlQuery query; |
|---|
| 27 | query.prepare(selectQuery() + "WHERE xid_conference = :conf AND start >= :start AND start < :end ORDER BY start"); |
|---|
| 28 | query.bindValue(":conf", conferenceId); |
|---|
| 29 | query.bindValue(":start", convertToDb(date, QVariant::DateTime)); |
|---|
| 30 | query.bindValue(":end", convertToDb(date.addDays(1), QVariant::DateTime)); |
|---|
| 31 | |
|---|
| 32 | return load(query); |
|---|
| 33 | } |
|---|
| 34 | |
|---|
