MainWindow::MainWindow(QWidget *parent)
: QMainWindow(parent)
{
//Setup database
ConecToDb(db_, "tareas");
db_.exec("CREATE TABLE IF NOT EXISTS tareas ("
"id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"
"name TEXT,"
"description TEXT"
"date TEXT,"
"category_id INT,"
");");
db_.exec("CREATE TABLE IF NOT EXISTS categories ("
"id INTEGER,"
"name TEXT,"
"description TEXT"
");");
db_.exec("CREATE TABLE IF NOT EXISTS tag ("
"id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"
"name TEXT"
");");
db_.exec("CREATE TABLE IF NOT EXISTS tag_tareas ("
"tag_id INT,"
"tareas_id INT"
");");
dbList_ = new dblist(db_);
setCentralWidget(dbList_);
}
MainWindow::MainWindow(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::MainWindow)
{
ui->setupUi(this);
//Setup database
ConecToDb(db_, "tareas");
db_.exec("CREATE TABLE IF NOT EXISTS tareas ("
"id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"
"name TEXT,"
"descripcion TEXT,"
"date TEXT,"
"done INTEGER,"
"id_categ INTEGER"
");");
db_.exec("CREATE TABLE IF NOT EXISTS categorias ("
"id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"
"name TEXT,"
"descripcion TEXT"
");");
db_.exec("CREATE TABLE IF NOT EXISTS etiquetas ("
"id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,"
"name TEXT"
");");
db_.exec("CREATE TABLE IF NOT EXISTS tareas_etiq ("
"id_tarea INTEGER,"
"id_etiq INTEGER"
");");
connect(ui->actionNuevaTarea, SIGNAL(triggered()), this, SLOT(onAddTarea()));
//Obtenemos las categorias
QSqlQuery q = db_.exec("SELECT * "
"FROM categorias;");
while (q.next()) {
ui->comboCategoria->addItem(GetField(q,"name").toString());
int rowNumber = ui->tblCateg->rowCount();
ui->tblCateg->insertRow(rowNumber);
QTableWidgetItem* item = new QTableWidgetItem(GetField(q, "name").toString());
ui->tblCateg->setItem(rowNumber, 0, item);
}
ui->tblCateg->setSortingEnabled(true);
}
MainWindow::MainWindow(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::MainWindow)
{
ui->setupUi(this);
//Setup database
if (!ConecToDb(db_, "tareas")) {
exit(0);
} else {
// Crea las tablas
createTables();
// Llena los datos mediante script (no implementado)
populateTables();
// Tareas
connect(ui->actionNuevaTarea, SIGNAL(triggered()), this, SLOT(onAddTarea()));
connect(ui->tblTareas, SIGNAL(cellChanged(int,int)), this, SLOT(onTareasCellChanged(int,int)));
connect(ui->comboCategoria, SIGNAL(currentIndexChanged(int)), this, SLOT(onLoadTareas()));
// Etiquetas
connect(ui->actionNuevaEtiq, SIGNAL(triggered()), this, SLOT(onAddEtiqueta()));
connect(ui->tblEtiq, SIGNAL(cellChanged(int,int)), this, SLOT(onEtiquetasCellChanged(int,int)));
// Categorías
connect(ui->actionNuevaCateg, SIGNAL(triggered()), this, SLOT(onAddCategoria()));
connect(ui->tblCateg, SIGNAL(cellChanged(int,int)), this, SLOT(onCategoriasCellChanged(int,int)));
addingTarea_ = false;
addingEtiqueta_ = false;
addingCategoria_ = false;
obtenerCategorias();
obtenerEtiquetas();
obtenerTareas();
}
}
