comparison: src/EditMisc.cpp
src/EditMisc.cpp
- changeset 385
- 09af9f46518f
- parent 292
- b6ec2e275736
equal
deleted
inserted
replaced
| 384:d68826df8b63 | 385:09af9f46518f |
|---|---|
| 103 } | 103 } |
| 104 | 104 |
| 105 | 105 |
| 106 EditMisc::~EditMisc() | 106 EditMisc::~EditMisc() |
| 107 { | 107 { |
| 108 qDebug() << "EditMisc done"; | |
| 109 delete ui; | 108 delete ui; |
| 110 emit entry_changed(); | 109 emit entry_changed(); |
| 111 } | 110 } |
| 112 | 111 |
| 113 | 112 |
| 171 } else { | 170 } else { |
| 172 query.bindValue(":recno", this->recno); | 171 query.bindValue(":recno", this->recno); |
| 173 } | 172 } |
| 174 query.exec(); | 173 query.exec(); |
| 175 if (query.lastError().isValid()) { | 174 if (query.lastError().isValid()) { |
| 176 qDebug() << "EditMisc" << query.lastError(); | 175 qWarning() << "EditMisc" << query.lastError(); |
| 177 QMessageBox::warning(this, tr("Database error"), | 176 QMessageBox::warning(this, tr("Database error"), |
| 178 tr("MySQL error: %1\n%2\n%3") | 177 tr("MySQL error: %1\n%2\n%3") |
| 179 .arg(query.lastError().nativeErrorCode()) | 178 .arg(query.lastError().nativeErrorCode()) |
| 180 .arg(query.lastError().driverText()) | 179 .arg(query.lastError().driverText()) |
| 181 .arg(query.lastError().databaseText())); | 180 .arg(query.lastError().databaseText())); |
| 188 this->textIsChanged = false; | 187 this->textIsChanged = false; |
| 189 WindowTitle(); | 188 WindowTitle(); |
| 190 } | 189 } |
| 191 | 190 |
| 192 | 191 |
| 192 void EditMisc::on_cloneButton_clicked() | |
| 193 { | |
| 194 QSqlQuery query; | |
| 195 | |
| 196 query.prepare("INSERT INTO inventory_miscs SET name=:name, type=:type, use_use=:use, " | |
| 197 "time=:time, amount_is_weight=:isweight, use_for=:usefor, notes=:notes, " | |
| 198 "always_on_stock=:always, inventory=:inventory, cost=:cost, production_date=:prod, " | |
| 199 "tht_date=:tht, uuid = :uuid"); | |
| 200 | |
| 201 query.bindValue(":name", ui->nameEdit->text() + " [copy]"); | |
| 202 query.bindValue(":type", ui->typeEdit->currentIndex()); | |
| 203 query.bindValue(":use", ui->useEdit->currentIndex()); | |
| 204 query.bindValue(":time", ui->timeEdit->value()); | |
| 205 query.bindValue(":isweight", ui->isweightEdit->isChecked() ? 1:0); | |
| 206 query.bindValue(":usefor", ui->useforEdit->toPlainText()); | |
| 207 query.bindValue(":notes", ui->notesEdit->toPlainText()); | |
| 208 query.bindValue(":always", ui->alwaysEdit->isChecked() ? 1:0); | |
| 209 query.bindValue(":inventory", QString("%1").arg(0, 5, 'f', 4, '0')); | |
| 210 query.bindValue(":cost", QString("%1").arg(ui->costEdit->value(), 3, 'f', 2, '0')); | |
| 211 query.bindValue(":prod", QDate()); | |
| 212 query.bindValue(":tht", QDate()); | |
| 213 query.bindValue(":uuid", QUuid::createUuid().toString().mid(1, 36)); | |
| 214 | |
| 215 query.exec(); | |
| 216 if (query.lastError().isValid()) { | |
| 217 qWarning() << "EditMisc" << query.lastError(); | |
| 218 QMessageBox::warning(this, tr("Database error"), | |
| 219 tr("MySQL error: %1\n%2\n%3") | |
| 220 .arg(query.lastError().nativeErrorCode()) | |
| 221 .arg(query.lastError().driverText()) | |
| 222 .arg(query.lastError().databaseText())); | |
| 223 } else { | |
| 224 qDebug() << "EditMisc Saved"; | |
| 225 } | |
| 226 } | |
| 227 | |
| 228 | |
| 193 void EditMisc::on_deleteButton_clicked() | 229 void EditMisc::on_deleteButton_clicked() |
| 194 { | 230 { |
| 195 QSqlQuery query; | 231 QSqlQuery query; |
| 232 | |
| 233 int rc = QMessageBox::warning(this, tr("Delete misc"), tr("Delete %1").arg(ui->nameEdit->text()), | |
| 234 QMessageBox::Yes | QMessageBox::No, QMessageBox::No); | |
| 235 if (rc == QMessageBox::No) | |
| 236 return; | |
| 196 | 237 |
| 197 query.prepare("DELETE FROM inventory_miscs WHERE record = :recno"); | 238 query.prepare("DELETE FROM inventory_miscs WHERE record = :recno"); |
| 198 query.bindValue(":recno", this->recno); | 239 query.bindValue(":recno", this->recno); |
| 199 query.exec(); | 240 query.exec(); |
| 200 if (query.lastError().isValid()) { | 241 if (query.lastError().isValid()) { |
| 201 qDebug() << "EditMisc" << query.lastError(); | 242 qWarning() << "EditMisc" << query.lastError(); |
| 202 QMessageBox::warning(this, tr("Database error"), | 243 QMessageBox::warning(this, tr("Database error"), |
| 203 tr("MySQL error: %1\n%2\n%3") | 244 tr("MySQL error: %1\n%2\n%3") |
| 204 .arg(query.lastError().nativeErrorCode()) | 245 .arg(query.lastError().nativeErrorCode()) |
| 205 .arg(query.lastError().driverText()) | 246 .arg(query.lastError().driverText()) |
| 206 .arg(query.lastError().databaseText())); | 247 .arg(query.lastError().databaseText())); |
