/***************************************************************************
//
// softProjector - an open source media projection software
// Copyright (C) 2014 Vladislav Kobzar, Matvey Adzhigirey and Ilya Spivakov
//
// This program is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation version 3 of the License.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program. If not, see <http://www.gnu.org/licenses/>.
//
***************************************************************************/
#include "theme.h"
PassiveSettings::PassiveSettings()
{
useBackground = false;
backgroundName = "";
background = QPixmap();
useDisp2settings = false;
}
BibleSettings::BibleSettings()
{
// Apply Bible Defaults
useShadow = true;
useFading = true;
useBlurShadow = false;
useBackground = false;
backgroundName = "";
background = QPixmap();
textFont.fromString("Arial,48,-1,5,50,0,0,0,0,0");
textColor = QColor(Qt::white);
textAlingmentV = 0;
textAlingmentH = 0;
captionFont.fromString("Arial,36,-1,5,50,0,0,0,0,0");
captionColor = QColor(Qt::white);
captionAlingment = 2;
captionPosition = 1;
useAbbriviations = false;
screenUse = 100;
screenPosition = 1;
useDisp2settings = false;
}
SongSettings::SongSettings()
{
// Apply song defaults
useShadow = true;
useFading = true;
useBlurShadow = false;
showStanzaTitle = false;
showSongKey = false;
showSongNumber = false;
infoColor = QColor(Qt::white);
infoFont.fromString("Arial,36,-1,5,50,0,0,0,0,0");
infoAling = 0;
showSongEnding = true;
endingColor = QColor(Qt::white);
endingFont.fromString("Arial,48,-1,5,50,0,0,0,0,0");
endingType = 0;
endingPosition = 1;
useBackground = false;
backgroundName = "";
background = QPixmap();
textColor = QColor(Qt::white);
textFont.fromString("Arial,48,-1,5,50,0,0,0,0,0");
textAlingmentV = 1;
textAlingmentH = 1;
screenUse = 100;
screenPositon = 1;
useDisp2settings = false;
}
AnnounceSettings::AnnounceSettings()
{
// Apply annouce defaults
useShadow = true;
useFading = true;
useBlurShadow = false;
useBackground = false;
backgroundName = "";
background = QPixmap();
textFont.fromString("Arial,48,-1,5,50,0,0,0,0,0");
textColor = QColor(Qt::white);
textAlingmentV = 0;
textAlingmentH = 1;
useDisp2settings = false;
}
ThemeInfo::ThemeInfo()
{
themeId = 0;
name = "Default";
comments = "Default SoftProjector Theme";
}
Theme::Theme()
{
themeId = 0;
name = "Default";
comments = "Default SoftProjector Theme";
}
void Theme::saveThemeNew()
{
QSqlQuery sq;
sq.prepare("INSERT INTO Themes (name, comment) VALUES (?,?)");
sq.addBindValue(name);
sq.addBindValue(comments);
sq.exec();
// get new theme id
sq.exec("SELECT seq FROM sqlite_sequence WHERE name = 'Themes'");
sq.first();
themeId = sq.value(0).toInt();
savePassiveNew(1,passive);
savePassiveNew(2,passive2);
saveBibleNew(1,bible);
saveBibleNew(2,bible2);
saveSongNew(1,song);
saveSongNew(2,song2);
saveAnnounceNew(1,announce);
saveAnnounceNew(2,announce2);
}
void Theme::savePassiveNew(int screen, PassiveSettings &settings)
{
QSqlQuery sq;
sq.prepare("INSERT INTO ThemePassive (theme_id, disp, use_background, background_name, background, use_disp_2) "
"VALUES(?,?,?,?,?,?)");
sq.addBindValue(themeId);
sq.addBindValue(screen);
sq.addBindValue(settings.useBackground);
sq.addBindValue(settings.backgroundName);
sq.addBindValue(pixToByte(settings.background));
sq.addBindValue(settings.useDisp2settings);
sq.exec();
}
void Theme::saveBibleNew(int screen, BibleSettings &settings)
{
QSqlQuery sq;
sq.prepare("INSERT INTO ThemeBible (theme_id, disp, use_shadow, use_fading, use_blur_shadow, use_background, "
"background_name, background, text_font, text_color, text_align_v, text_align_h, caption_font, "
"caption_color, caption_align, caption_position, use_abbr, screen_use, screen_position, use_disp_2) "
"VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
sq.addBindValue(themeId);
sq.addBindValue(screen);
sq.addBindValue(settings.useShadow);
sq.addBindValue(settings.useFading);
sq.addBindValue(settings.useBlurShadow);
sq.addBindValue(settings.useBackground);
sq.addBindValue(settings.backgroundName);
sq.addBindValue(pixToByte(settings.background));
sq.addBindValue(settings.textFont.toString());
sq.addBindValue((unsigned int)(settings.textColor.rgb()));
sq.addBindValue(settings.textAlingmentV);
sq.addBindValue(settings.textAlingmentH);
sq.addBindValue(settings.captionFont.toString());
sq.addBindValue((unsigned int)(settings.captionColor.rgb()));
sq.addBindValue(settings.captionAlingment);
sq.addBindValue(settings.captionPosition);
sq.addBindValue(settings.useAbbriviations);
sq.addBindValue(settings.screenUse);
sq.addBindValue(settings.screenPosition);
sq.addBindValue(settings.useDisp2settings);
sq.exec();
}
void Theme::saveSongNew(int screen, SongSettings &settings)
{
QSqlQuery sq;
sq.prepare("INSERT INTO ThemeSong (theme_id, disp, use_shadow, use_fading, use_blur_shadow, show_stanza_title, "
"show_key, show_number, info_color, info_font, info_align, show_song_ending, ending_color, ending_font, "
"ending_type, ending_position, use_background, background_name, background, text_font, text_color, "
"text_align_v, text_align_h, screen_use, screen_position, use_disp_2) "
"VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
sq.addBindValue(themeId);
sq.addBindValue(screen);
sq.addBindValue(settings.useShadow);
sq.addBindValue(settings.useFading);
sq.addBindValue(settings.useBlurShadow);
sq.addBindValue(settings.showStanzaTitle);
sq.addBindValue(settings.showSongKey);
sq.addBindValue(settings.showSongNumber);
sq.addBindValue((unsigned int)(settings.infoColor.rgb()));
sq.addBindValue(settings.infoFont.toString());
sq.addBindValue(settings.infoAling);
sq.addBindValue(settings.showSongEnding);
sq.addBindValue((unsigned int)(settings.endingColor.rgb()));
sq.addBindValue(settings.endingFont.toString());
sq.addBindValue(settings.endingType);
sq.addBindValue(settings.endingPosition);
sq.addBindValue(settings.useBackground);
sq.addBindValue(settings.backgroundName);
sq.addBindValue(pixToByte(settings.background));
sq.addBindValue(settings.textFont);
sq.addBindValue((unsigned int)(settings.textColor.rgb()));
sq.addBindValue(settings.textAlingmentV);
sq.addBindValue(settings.textAlingmentH);
sq.addBindValue(settings.screenUse);
sq.addBindValue(settings.screenPositon);
sq.addBindValue(settings.useDisp2settings);
sq.exec();
}
void Theme::saveAnnounceNew(int screen, AnnounceSettings &settings)
{
QSqlQuery sq;
sq.prepare("INSERT INTO ThemeAnnounce (theme_id, disp, use_shadow, use_fading, use_blur_shadow, use_background, "
"background_name, background, text_font, text_color, text_align_v, text_align_h, use_disp_2) "
"VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)");
sq.addBindValue(themeId);
sq.addBindValue(screen);
sq.addBindValue(settings.useShadow);
sq.addBindValue(settings.useFading);
sq.addBindValue(settings.useBlurShadow);
sq.addBindValue(settings.useBackground);
sq.addBindValue(settings.backgroundName);
sq.addBindValue(pixToByte(settings.background));
sq.addBindValue(settings.textFont.toString());
sq.addBindValue(settings.textColor.rgb());
sq.addBindValue(settings.textAlingmentV);
sq.addBindValue(settings.textAlingmentH);
sq.addBindValue(settings.useDisp2settings);
sq.exec();
}
void Theme::saveThemeUpdate()
{
QSqlQuery sq;
sq.prepare("UPDATE Themes SET name = ?, comments = ? WHERE id = ?");
sq.addBindValue(name);
sq.addBindValue(comments);
sq.addBindValue(themeId);
sq.exec();
savePassiveUpdate(1,passive);
savePassiveUpdate(2,passive2);
saveBibleUpdate(1,bible);
saveBibleUpdate(2,bible2);
saveSongUpdate(1,song);
saveSongUpdate(2,song2);
saveAnnounceUpdate(1,announce);
saveAnnounceUpdate(2,announce2);
}
void Theme::savePassiveUpdate(int screen, PassiveSettings &settings)
{
QSqlQuery sq;
sq.prepare("UPDATE ThemePassive SET use_background = ?, background_name = ?, background = ?, use_disp_2 = ? "
"WHERE theme_id = ? AND disp = ?");
sq.addBindValue(settings.useBackground);
sq.addBindValue(settings.backgroundName);
sq.addBindValue(pixToByte(settings.background));
sq.addBindValue(settings.useDisp2settings);
sq.addBindValue(themeId);
sq.addBindValue(screen);
sq.exec();
}
void Theme::saveBibleUpdate(int screen, BibleSettings &settings)
{
QSqlQuery sq;
sq.prepare("UPDATE ThemeBible SET use_shadow = ?, use_fading = ?, use_blur_shadow = ?, "
"use_background = ?, background_name = ?, background = ?, text_font = ?, text_color = ?, text_align_v = ?, "
"text_align_h = ?, caption_font = ?, caption_color = ?, caption_align = ?, caption_position = ?, "
"use_abbr = ?, screen_use = ?, screen_position = ?, use_disp_2 = ? "
"WHERE theme_id = ? AND disp = ?");
sq.addBindValue(settings.useShadow);
sq.addBindValue(settings.useFading);
sq.addBindValue(settings.useBlurShadow);
sq.addBindValue(settings.useBackground);
sq.addBindValue(settings.backgroundName);
sq.addBindValue(pixToByte(settings.background));
sq.addBindValue(settings.textFont.toString());
sq.addBindValue((unsigned int)(settings.textColor.rgb()));
sq.addBindValue(settings.textAlingmentV);
sq.addBindValue(settings.textAlingmentH);
sq.addBindValue(settings.captionFont.toString());
sq.addBindValue((unsigned int)(settings.captionColor.rgb()));
sq.addBindValue(settings.captionAlingment);
sq.addBindValue(settings.captionPosition);
sq.addBindValue(settings.useAbbriviations);
sq.addBindValue(settings.screenUse);
sq.addBindValue(settings.screenPosition);
sq.addBindValue(settings.useDisp2settings);
sq.addBindValue(themeId);
sq.addBindValue(screen);
sq.exec();
}
void Theme::saveSongUpdate(int screen, SongSettings &settings)
{
QSqlQuery sq;
sq.prepare("UPDATE ThemeSong SET use_shadow = ?, use_fading = ?, use_blur_shadow = ?, "
"show_stanza_title = ?, show_key = ?, show_number = ?, info_color = ?, info_font = ?, info_align = ?, "
"show_song_ending = ?, ending_color = ?, ending_font = ?, ending_type = ?, ending_position = ?, "
"use_background = ?, background_name = ?, background = ?, text_font = ?, text_color = ?, text_align_v = ?, "
"text_align_h = ?, screen_use = ?, screen_position = ?, use_disp_2 = ? "
"WHERE theme_id = ? AND disp = ?");
sq.addBindValue(settings.useShadow);
sq.addBindValue(settings.useFading);
sq.addBindValue(settings.useBlurShadow);
sq.addBindValue(settings.showStanzaTitle);
sq.addBindValue(settings.showSongKey);
sq.addBindValue(settings.showSongNumber);
sq.addBindValue((unsigned int)(settings.infoColor.rgb()));
sq.addBindValue(settings.infoFont.toString());
sq.addBindValue(settings.infoAling);
sq.addBindValue(settings.showSongEnding);
sq.addBindValue((unsigned int)(settings.endingColor.rgb()));
sq.addBindValue(settings.endingFont.toString());
sq.addBindValue(settings.endingType);
sq.addBindValue(settings.endingPosition);
sq.addBindValue(settings.useBackground);
sq.addBindValue(settings.backgroundName);
sq.addBindValue(pixToByte(settings.background));
sq.addBindValue(settings.textFont);
sq.addBindValue((unsigned int)(settings.textColor.rgb()));
sq.addBindValue(settings.textAlingmentV);
sq.addBindValue(settings.textAlingmentH);
sq.addBindValue(settings.screenUse);
sq.addBindValue(settings.screenPositon);
sq.addBindValue(settings.useDisp2settings);
sq.addBindValue(themeId);
sq.addBindValue(screen);
sq.exec();
}
void Theme::saveAnnounceUpdate(int screen, AnnounceSettings &settings)
{
QSqlQuery sq;
sq.prepare("UPDATE ThemeAnnounce SET use_shadow = ?, use_fading = ?, use_blur_shadow = ?, "
"use_background = ?, background_name = ?, background = ?, text_font = ?, text_color = ?, "
"text_align_v = ?, text_align_h = ?, use_disp_2 = ? "
"WHERE theme_id = ? AND disp = ?");
sq.addBindValue(settings.useShadow);
sq.addBindValue(settings.useFading);
sq.addBindValue(settings.useBlurShadow);
sq.addBindValue(settings.useBackground);
sq.addBindValue(settings.backgroundName);
sq.addBindValue(pixToByte(settings.background));
sq.addBindValue(settings.textFont.toString());
sq.addBindValue(settings.textColor.rgb());
sq.addBindValue(settings.textAlingmentV);
sq.addBindValue(settings.textAlingmentH);
sq.addBindValue(settings.useDisp2settings);
sq.addBindValue(themeId);
sq.addBindValue(screen);
sq.exec();
}
void Theme::loadTheme()
{
QSqlQuery sq;
bool ok, allok;
allok = false;
sq.exec(QString("SELECT name, comment FROM Themes WHERE id = %1").arg(themeId));
ok = sq.first();
if(ok)
{
name = sq.value(0).toString();
comments = sq.value(1).toString();
allok = true;
}
else
{
sq.exec("SELECT id, name, comment FROM Themes");
ok = sq.first();
// Check at least one theme exitst
if (ok) // If exist, then load it
{
themeId = sq.value(0).toInt();
name = sq.value(1).toString();
comments = sq.value(2).toString();
allok = true;
}
else // No themes exist, creat one and exit
{
saveThemeNew();
allok = false;
}
}
if(allok)
{
loadPassive(1,passive);
loadPassive(2,passive2);
loadBible(1,bible);
loadBible(2,bible2);
loadSong(1,song);
loadSong(2,song2);
loadAnnounce(1,announce);
loadAnnounce(2,announce2);
}
}
void Theme::loadPassive(int screen, PassiveSettings &settings)
{
QSqlQuery sq;
QSqlRecord sr;
sq.exec(QString("SELECT * FROM ThemePassive WHERE theme_id = %1 and disp = %2").arg(themeId).arg(screen));
sq.first();
sr = sq.record();
settings.useBackground = sr.field("use_background").value().toBool();
settings.backgroundName = sr.field("background_name").value().toString();
settings.background.loadFromData(sr.field("background").value().toByteArray());
settings.useDisp2settings = sr.field("use_disp_2").value().toBool();
}
void Theme::loadBible(int screen, BibleSettings &settings)
{
QSqlQuery sq;
QSqlRecord sr;
sq.exec(QString("SELECT * FROM ThemeBible WHERE theme_id = %1 and disp = %2").arg(themeId).arg(screen));
sq.first();
sr = sq.record();
settings.useShadow = sr.field("use_shadow").value().toBool();
settings.useFading = sr.field("use_fading").value().toBool();
settings.useBlurShadow = sr.field("use_blur_shadow").value().toBool();
settings.useBackground = sr.field("use_background").value().toBool();
settings.backgroundName = sr.field("background_name").value().toString();
settings.background.loadFromData(sr.field("background").value().toByteArray());
settings.textFont.fromString(sr.field("text_font").value().toString());
settings.textColor = QColor::fromRgb(sr.field("text_color").value().toUInt());
settings.textAlingmentV = sr.field("text_align_v").value().toInt();
settings.textAlingmentH = sr.field("text_align_h").value().toInt();
settings.captionFont.fromString(sr.field("caption_font").value().toString());
settings.captionColor = QColor::fromRgb(sr.field("caption_color").value().toUInt());
settings.captionAlingment = sr.field("caption_align").value().toInt();
settings.captionPosition = sr.field("caption_position").value().toInt();
settings.useAbbriviations = sr.field("use_abbr").value().toBool();
settings.screenUse = sr.field("screen_use").value().toInt();
settings.screenPosition = sr.field("screen_position").value().toInt();
settings.useDisp2settings = sr.field("use_disp_2").value().toBool();
}
void Theme::loadSong(int screen, SongSettings &settings)
{
QSqlQuery sq;
QSqlRecord sr;
sq.exec(QString("SELECT * FROM ThemeSong WHERE theme_id = %1 and disp = %2").arg(themeId).arg(screen));
sq.first();
sr = sq.record();
settings.useShadow = sr.field("use_shadow").value().toBool();
settings.useFading = sr.field("use_fading").value().toBool();
settings.useBlurShadow = sr.field("use_blur_shadow").value().toBool();
settings.showStanzaTitle = sr.field("show_stanza_title").value().toBool();
settings.showSongKey = sr.field("show_key").value().toBool();
settings.showSongNumber = sr.field("show_number").value().toBool();
settings.infoColor = QColor::fromRgb(sr.field("info_color").value().toUInt());
settings.infoFont.fromString(sr.field("info_font").value().toString());
settings.infoAling = sr.field("info_align").value().toInt();
settings.showSongEnding = sr.field("show_song_ending").value().toBool();
settings.endingColor = QColor::fromRgb(sr.field("ending_color").value().toUInt());
settings.endingFont.fromString(sr.field("ending_font").value().toString());
settings.endingType = sr.field("ending_type").value().toInt();
settings.endingPosition = sr.field("ending_position").value().toInt();
settings.useBackground = sr.field("use_background").value().toBool();
settings.backgroundName = sr.field("background_name").value().toString();
settings.background.loadFromData(sr.field("background").value().toByteArray());
settings.textFont.fromString(sr.field("text_font").value().toString());
settings.textColor = QColor::fromRgb(sr.field("text_color").value().toUInt());
settings.textAlingmentV = sr.field("text_align_v").value().toInt();
settings.textAlingmentH = sr.field("text_align_h").value().toInt();
settings.screenUse = sr.field("screen_use").value().toInt();
settings.screenPositon = sr.field("screen_position").value().toInt();
settings.useDisp2settings = sr.field("use_disp_2").value().toBool();
}
void Theme::loadAnnounce(int screen, AnnounceSettings &settings)
{
QSqlQuery sq;
QSqlRecord sr;
sq.exec(QString("SELECT * FROM ThemeAnnounce WHERE theme_id = %1 and disp = %2").arg(themeId).arg(screen));
sq.first();
sr = sq.record();
settings.useShadow = sr.field("use_shadow").value().toBool();
settings.useFading = sr.field("use_fading").value().toBool();
settings.useBlurShadow = sr.field("use_blur_shadow").value().toBool();
settings.useBackground = sr.field("use_background").value().toBool();
settings.backgroundName = sr.field("background_name").value().toString();
settings.background.loadFromData(sr.field("background").value().toByteArray());
settings.textFont.fromString(sr.field("text_font").value().toString());
settings.textColor = QColor::fromRgb(sr.field("text_color").value().toUInt());
settings.textAlingmentV = sr.field("text_align_v").value().toInt();
settings.textAlingmentH = sr.field("text_align_h").value().toInt();
settings.useDisp2settings = sr.field("use_disp_2").value().toBool();
}
void Theme::setThemeInfo(ThemeInfo info)
{
themeId = info.themeId;
name = info.name;
comments = info.comments;
}
ThemeInfo Theme::getThemeInfo()
{
ThemeInfo info;
info.themeId = themeId;
info.name = name;
info.comments = comments;
return info;
}
