Tue, 15 Feb 2022 23:00:45 +0100
Suppliers table refresh works after edit.
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1 | /** |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
2 | * EditSupplier.cpp is part of bmsapp. |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
3 | * |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
4 | * bmsapp is free software: you can redistribute it and/or modify |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
5 | * it under the terms of the GNU General Public License as published by |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
6 | * the Free Software Foundation, either version 3 of the License, or |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
7 | * (at your option) any later version. |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
8 | * |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
9 | * bmsapp is distributed in the hope that it will be useful, |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
10 | * but WITHOUT ANY WARRANTY; without even the implied warranty of |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
11 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
12 | * GNU General Public License for more details. |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
13 | * |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
14 | * You should have received a copy of the GNU General Public License |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
15 | * along with this program. If not, see <http://www.gnu.org/licenses/>. |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
16 | */ |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
17 | #include "EditSupplier.h" |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
18 | #include "../ui/ui_EditSupplier.h" |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
19 | #include "bmsapp.h" |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
20 | |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
21 | |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
22 | EditSupplier::EditSupplier(int id, QWidget *parent) : QDialog(parent), ui(new Ui::EditSupplier) |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
23 | { |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
24 | QSqlQuery query; |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
25 | |
11
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
26 | qDebug() << "EditSupplier record:" << id; |
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
27 | ui->setupUi(this); |
11
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
28 | this->recno = id; |
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
29 | |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
30 | if (id < 0) { |
11
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
31 | setWindowTitle(QString("BMSapp - Add new supplier")); |
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
32 | } else { |
11
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
33 | setWindowTitle(QString("BMSapp - Edit supplier %1").arg(id)); |
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
34 | query.prepare("SELECT * FROM inventory_suppliers WHERE record = :recno"); |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
35 | query.bindValue(":recno", id); |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
36 | query.exec(); |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
37 | query.next(); |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
38 | |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
39 | ui->nameEdit->setText(query.value(1).toString()); |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
40 | ui->addressEdit->setText(query.value(2).toString()); |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
41 | ui->cityEdit->setText(query.value(3).toString()); |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
42 | ui->zipEdit->setText(query.value(4).toString()); |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
43 | ui->countryEdit->setText(query.value(5).toString()); |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
44 | ui->webEdit->setText(query.value(6).toString()); |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
45 | ui->emailEdit->setText(query.value(7).toString()); |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
46 | ui->phoneEdit->setText(query.value(8).toString()); |
11
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
47 | ui->notesEdit->setPlainText(query.value(9).toString()); |
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
48 | } |
11
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
49 | connect(ui->notesEdit, SIGNAL(textChanged()), this, SLOT(onTextChanged())); |
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
50 | } |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
51 | |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
52 | |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
53 | EditSupplier::~EditSupplier() |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
54 | { |
11
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
55 | qDebug() << "EditSupplier closed"; |
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
56 | delete ui; |
11
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
57 | emit entry_changed(); |
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
58 | } |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
59 | |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
60 | |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
61 | void EditSupplier::onOKButtonClicked() |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
62 | { |
11
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
63 | QSqlQuery query; |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
64 | bool modified, valid; |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
65 | |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
66 | /* The notes field uses a signal textChanged() */ |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
67 | modified = (ui->nameEdit->isModified() || ui->addressEdit->isModified() || ui->cityEdit->isModified() || |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
68 | ui->zipEdit->isModified() || ui->countryEdit->isModified() || ui->webEdit->isModified() || |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
69 | ui->emailEdit->isModified() || ui->phoneEdit->isModified() || this->textIsChanged); |
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
70 | |
11
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
71 | valid = true; |
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
72 | /* If there are errors in the form, show a message and do "return;" */ |
11
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
73 | if (ui->nameEdit->text().length() < 2) { |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
74 | // QMessageBox msgBox; |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
75 | // msgBox.setText("Name empty or too short."); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
76 | // msgBox.exec(); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
77 | return; |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
78 | } |
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
79 | |
11
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
80 | if (modified && valid) { |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
81 | qDebug() << "EditSupplier do SQL"; |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
82 | if (this->recno == -1) { |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
83 | query.prepare("INSERT INTO inventory_suppliers SET name = :name, address = :address, city = :city, zip = :zip, " |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
84 | "country = :country, website = :web, email = :email, phone = :phone, notes = :notes, uuid = :uuid"); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
85 | } else { |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
86 | query.prepare("UPDATE inventory_suppliers SET name = :name, address = :address, city = :city, zip = :zip, " |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
87 | "country = :country, website = :web, email = :email, phone = :phone, notes = :notes WHERE record = :recno"); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
88 | } |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
89 | query.bindValue(":name", ui->nameEdit->text()); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
90 | query.bindValue(":address", ui->addressEdit->text()); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
91 | query.bindValue(":city", ui->cityEdit->text()); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
92 | query.bindValue(":zip", ui->zipEdit->text()); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
93 | query.bindValue(":country", ui->countryEdit->text()); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
94 | query.bindValue(":web", ui->webEdit->text()); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
95 | query.bindValue(":email", ui->emailEdit->text()); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
96 | query.bindValue(":phone", ui->phoneEdit->text()); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
97 | query.bindValue(":notes", ui->notesEdit->toPlainText()); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
98 | if (this->recno == -1) { |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
99 | query.bindValue(":uuid", QUuid::createUuid().toString().mid(1, 36)); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
100 | } else { |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
101 | query.bindValue(":recno", this->recno); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
102 | } |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
103 | query.exec(); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
104 | if (query.lastError().isValid()) { |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
105 | qDebug() << query.lastError(); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
106 | } |
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
107 | |
11
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
108 | this->close(); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
109 | this->setResult(1); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
110 | } else { |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
111 | /* Not saving */ |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
112 | this->close(); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
113 | this->setResult(0); |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
114 | } |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
115 | } |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
116 | |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
117 | |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
118 | void EditSupplier::onTextChanged() |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
119 | { |
c9cdc15d3caf
The Supplier editor saves changes and inserts new suppliers. It sends a signal to InventorySuppliers when done (always for now). Refresh the table still doesn't work. Added a missing iconn in the Inventory menus dropdown.
Michiel Broek <mbroek@mbse.eu>
parents:
10
diff
changeset
|
120 | this->textIsChanged = true; |
10
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
121 | } |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
122 | |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
123 | |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
124 | void EditSupplier::onCancelButtonClicked() |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
125 | { |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
126 | this->close(); |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
127 | this->setResult(0); |
8aa2bd9ba9e8
Added the EditSupplier popup window. It is now ready to validate the form data.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
128 | } |