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/>.
20 #include "conference.h"
21 #include "../sql/sqlengine.h"
23 QSqlRecord const Conference::sColumns = Conference::toRecord(QList<QSqlField>()
24 << QSqlField("id", QVariant::Int)
25 << QSqlField("title", QVariant::String)
26 << QSqlField("subtitle", QVariant::String)
27 << QSqlField("venue", QVariant::String)
28 << QSqlField("city", QVariant::String)
29 << QSqlField("start", QVariant::DateTime)
30 << QSqlField("end", QVariant::DateTime)
31 << QSqlField("day_change", QVariant::Int)
32 << QSqlField("timeslot_duration", QVariant::Int)
33 << QSqlField("utc_offset", QVariant::Int)
34 << QSqlField("display_time_shift", QVariant::Int)
35 << QSqlField("active", QVariant::Bool)
36 << QSqlField("url", QVariant::String)
39 QString const Conference::sTableName = QString("conference");
41 Conference Conference::getById(int id)
44 query.prepare(selectQuery() + "WHERE id = :id");
45 query.bindValue(":id", id);
46 return loadOne(query);
49 QList<Conference> Conference::getAll()
52 query.prepare(selectQuery());
56 int Conference::activeConference() {
57 QSqlQuery query("SELECT id FROM conference ORDER BY active DESC, id LIMIT 1");
58 if (!query.exec() || !query.first()) return -1;
59 return query.record().value("id").toInt();
63 QTime Conference::shiftTime(const QTime& value) const {
64 return value.addSecs(displayTimeShift() * 60);