#include <QtSql>
#include "addresswidget.h"
#include "contactwidget.h"
+#include "notedialog.h"
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()));
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();
+ }
}
}
}
+
+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);
+ }
+}
+