Added Note capability.

[schematic] / src / scmwidget.cpp

diff --git a/src/scmwidget.cpp b/src/scmwidget.cpp
index c9a175e34d784aa9ce753fef4164ee6d3e2a63eb..a04e8947050a424dcc4ba53e844b8ef8187796a3 100644 (file)
--- a/src/scmwidget.cpp
+++ b/src/scmwidget.cpp
@@ -15,6 +15,7 @@
 #include <QtSql>
 #include "addresswidget.h"
 #include "contactwidget.h"
+#include "notedialog.h"
 
 
 SCMWidget::SCMWidget(QWidget * parent/*= 0*/): QWidget(parent),
@@ -217,7 +218,7 @@ SCMWidget::SCMWidget(QWidget * parent/*= 0*/): QWidget(parent),
        connect(showOpen, SIGNAL(clicked()), this, SLOT(ShowOpenPOs()));
        connect(showClosed, SIGNAL(clicked()), this, SLOT(ShowClosedPOs()));
        connect(showAll, SIGNAL(clicked()), this, SLOT(ShowAllPOs()));
-       connect(addVendor, SIGNAL(clicked()), this, SLOT(AddVendor()));
+//     connect(addVendor, SIGNAL(clicked()), this, SLOT(AddVendor()));
        connect(addLocation, SIGNAL(clicked()), this, SLOT(AddLocation()));
        connect(addContact, SIGNAL(clicked()), this, SLOT(AddContact()));
        connect(editVendor, SIGNAL(clicked()), this, SLOT(EditVendor()));
@@ -249,7 +250,22 @@ void SCMWidget::GetPreviousVendor(void)
 
 void SCMWidget::CreateNote(void)
 {
-       QMessageBox::warning(this, "Approaching Singularity!", "TODO: Implementation");
+       NoteDialog dlg;
+       
+       if (dlg.exec() == true)
+       {
+               // Add note to DB for this user
+               QString note = dlg.note->document()->toPlainText();
+
+               QSqlQuery query;
+               query.prepare("INSERT INTO Notes VALUES ('', ?, NULL, ?)");
+               query.addBindValue(currentUID);
+//             query.addBindValue(NULL);
+               query.addBindValue(note.toAscii());
+               query.exec();
+
+               UpdateNotes();
+       }
 }
 
 
@@ -368,3 +384,27 @@ void SCMWidget::GetVendor(int key)
        }
 }
 
+
+void SCMWidget::UpdateNotes(void)
+{
+//             QMessageBox::warning(this, "Approaching Singularity!", "TODO: Implementation");
+//NID (P-key) | UID | POID | Note
+
+       QSqlQuery query;
+       query.prepare("SELECT note FROM Notes WHERE uid = ?");
+//             "c.name, email, c.address, phone1, phone2, fax, description, v.vlid FROM "
+//             "Vendor AS v LEFT OUTER JOIN Location AS l ON v.vid = l.vid "
+//             "LEFT OUTER JOIN (Contact AS c JOIN ContactType AS ct ON c.ctid = ct.ctid) "
+//             "ON v.vid = c.vid WHERE v.vid = ?");
+       query.addBindValue(currentUID);
+       query.exec();
+
+       notes->clear();
+
+       while (query.next())
+       {
+               QListWidgetItem * item = new QListWidgetItem(query.value(0).toString());
+               notes->addItem(item);
+       }
+}
+