source: src/mvc/conference.cpp

Last change on this file was ffb6be7, checked in by gregor herrmann <gregor@…>, 4 months ago

Bump copyright years.

  • Property mode set to 100644
File size: 2.2 KB
Line 
1/*
2 * Copyright (C) 2010 Ixonos Plc.
3 * Copyright (C) 2011-2021 Philipp Spitzer, gregor herrmann, Stefan Stahl
4 *
5 * This file is part of ConfClerk.
6 *
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)
10 * any later version.
11 *
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
15 * more details.
16 *
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/>.
19 */
20#include "conference.h"
21#include "../sql/sqlengine.h"
22
23QSqlRecord 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)
37    );
38
39QString const Conference::sTableName = QString("conference");
40
41Conference Conference::getById(int id)
42{
43    QSqlQuery query;
44    query.prepare(selectQuery() + "WHERE id = :id");
45    query.bindValue(":id", id);
46    return loadOne(query);
47}
48
49QList<Conference> Conference::getAll()
50{
51    QSqlQuery query;
52    query.prepare(selectQuery());
53    return load(query);
54}
55
56int 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();
60}
61
62
63QTime Conference::shiftTime(const QTime& value) const {
64    return value.addSecs(displayTimeShift() * 60);
65}
Note: See TracBrowser for help on using the repository browser.