notesmanager.cpp Example File
notesmanagerplugin/notesmanager.cpp
#include <QtCore>
#include "notesmanager.h"
NotesManager::NotesManager(QObject *parent)
: QObject(parent), m_search(QString())
{
}
bool NotesManager::init()
{
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(QCoreApplication::applicationDirPath() + "/notesmanager.db");
if (!db.open())
db.setDatabaseName(QDir::homePath() + "/notesmanager.db");
if (db.open()) {
QSqlQuery create;
create.exec("CREATE TABLE todolist(id INTEGER PRIMARY KEY, notes VARCHAR(255), date VARCHAR(255))");
nextAlarm();
QTimer *timer = new QTimer(this);
QObject::connect(timer, SIGNAL(timeout()), this, SLOT(checkAlarm()));
timer->start(1000);
} else {
return false;
}
return true;
}
void NotesManager::nextAlarm()
{
QSqlQuery alarmQuery("SELECT * FROM todolist WHERE date > DATETIME('now', 'localtime') ORDER BY date");
if (alarmQuery.next()) {
setAlarmTime(QDateTime::fromString(alarmQuery.value(2).toString(), "yyyy-MM-dd HH:mm:ss"));
setAlarmMessage(alarmQuery.value(1).toString());
}
}
void NotesManager::checkAlarm()
{
QString currStr = QDateTime::currentDateTime().toString(Qt::ISODate);
QDateTime curr = QDateTime::fromString(currStr, Qt::ISODate);
if (getAlarmTime() == curr)
emit soundAlarm(getAlarmTime());
nextAlarm();
}
QDateTime NotesManager::getAlarmTime() const
{
return m_alarmTime;
}
void NotesManager::setAlarmTime(const QDateTime& alarm)
{
m_alarmTime = alarm;
}
QString NotesManager::getAlarmMessage() const
{
return m_alarmMessage;
}
void NotesManager::setAlarmMessage(const QString& message)
{
m_alarmMessage = message;
}
void NotesManager::addNote(const QString& note, const QDateTime& alarm)
{
QString alert = alarm.toString("yyyy-MM-dd HH:mm:ss");
QSqlQuery query("INSERT INTO todolist(notes, date) VALUES ('" + note + "', '" + alert + "')");
}
void NotesManager::removeNote(int id)
{
QSqlQuery query("DELETE FROM todolist WHERE id='" + QString::number(id) + "'");
}
void NotesManager::setSearch(const QString& search)
{
m_search = search;
}
QList<QObject*> NotesManager::getNotes(const QString& search)
{
m_notes.clear();
setSearch(search);
QString queryString = "SELECT * FROM todolist";
if (m_search != "") queryString += " WHERE notes LIKE '%" + m_search + "%'";
queryString += " ORDER BY date";
QSqlQuery query(queryString);
while (query.next()) {
Note *entry = new Note(this);
entry->setIndex(query.value(0).toInt());
entry->setMessage(query.value(1).toString());
entry->setAlarm(QDateTime::fromString(query.value(2).toString(), "yyyy-MM-dd HH:mm:ss"));
m_notes << entry;
}
return m_notes;
}
#ifdef DECLARATIVE
QDeclarativeListProperty<QObject> NotesManager::noteSet()
{
m_notes = getNotes(m_search);
return QDeclarativeListProperty<QObject>(this, m_notes);
}
#endif
|