33 } |
33 } |
34 |
34 |
35 |
35 |
36 void InventorySuppliers::refreshTable() |
36 void InventorySuppliers::refreshTable() |
37 { |
37 { |
38 qDebug() << "slot" << Q_FUNC_INFO; |
38 qDebug() << "InventorySuppliers reload"; |
39 |
39 |
40 QSqlQuery query("SELECT * FROM inventory_suppliers ORDER BY name"); |
40 QSqlQuery query("SELECT * FROM inventory_suppliers ORDER BY name"); |
41 const QStringList labels({tr("Record"), tr("Name"), tr("Address"), tr("City"), tr("Country"), tr("Phone"), tr("Edit")}); |
41 const QStringList labels({tr("Name"), tr("Address"), tr("City"), tr("Country"), tr("Phone"), tr("Edit")}); |
42 |
42 |
43 ui->tableSuppliers->setColumnCount(7); |
43 ui->tableSuppliers->setColumnCount(6); |
44 ui->tableSuppliers->setColumnWidth(0, 50); /* Record */ |
44 ui->tableSuppliers->setColumnWidth(0, 250); /* Name */ |
45 ui->tableSuppliers->setColumnWidth(1, 250); /* Name */ |
45 ui->tableSuppliers->setColumnWidth(1, 250); /* Address */ |
46 ui->tableSuppliers->setColumnWidth(2, 250); /* Address */ |
46 ui->tableSuppliers->setColumnWidth(2, 200); /* City */ |
47 ui->tableSuppliers->setColumnWidth(3, 200); /* City */ |
47 ui->tableSuppliers->setColumnWidth(3, 120); /* Country */ |
48 ui->tableSuppliers->setColumnWidth(4, 120); /* Country */ |
48 ui->tableSuppliers->setColumnWidth(4, 120); /* Phone */ |
49 ui->tableSuppliers->setColumnWidth(5, 120); /* Phone */ |
49 ui->tableSuppliers->setColumnWidth(5, 90); /* Edit button */ |
50 ui->tableSuppliers->setColumnWidth(6, 90); /* Edit button */ |
|
51 ui->tableSuppliers->setRowCount(query.size()); |
50 ui->tableSuppliers->setRowCount(query.size()); |
52 ui->tableSuppliers->setHorizontalHeaderLabels(labels); |
51 ui->tableSuppliers->setHorizontalHeaderLabels(labels); |
53 ui->tableSuppliers->verticalHeader()->hide(); |
52 ui->tableSuppliers->verticalHeader()->hide(); |
54 ui->tableSuppliers->setFixedSize(1280, 640); /* Even if this is too large, it works */ |
53 ui->tableSuppliers->setFixedSize(1030 + 24, 640); /* Even if this is too large, it works */ |
55 |
54 |
56 // qDebug() << query.record().count() << query.size(); |
|
57 query.first(); |
55 query.first(); |
58 for (int ridx = 0 ; ridx < query.size() ; ridx++ ) { |
56 for (int ridx = 0 ; ridx < query.size() ; ridx++ ) { |
59 for (int cidx = 0 ; cidx < 4; cidx++) { |
57 ui->tableSuppliers->setItem(ridx, 0, new QTableWidgetItem(query.value(1).toString())); |
60 QTableWidgetItem* item = new QTableWidgetItem(query.value(cidx).toString()); |
58 ui->tableSuppliers->setItem(ridx, 1, new QTableWidgetItem(query.value(2).toString())); |
61 ui->tableSuppliers->setItem(ridx, cidx, item ); |
59 ui->tableSuppliers->setItem(ridx, 2, new QTableWidgetItem(query.value(3).toString())); |
62 } |
60 ui->tableSuppliers->setItem(ridx, 3, new QTableWidgetItem(query.value(5).toString())); |
63 // qDebug() << ridx << "record:" << query.value(0).toString() << " name:" << query.value(1).toString(); |
61 ui->tableSuppliers->setItem(ridx, 4, new QTableWidgetItem(query.value(8).toString())); |
64 QTableWidgetItem* item = new QTableWidgetItem(query.value(5).toString()); |
62 |
65 ui->tableSuppliers->setItem(ridx, 4, item ); |
|
66 item = new QTableWidgetItem(query.value(8).toString()); |
|
67 ui->tableSuppliers->setItem(ridx, 5, item ); |
|
68 /* Add the Edit button */ |
63 /* Add the Edit button */ |
69 QWidget* pWidget = new QWidget(); |
64 QWidget* pWidget = new QWidget(); |
70 QPushButton* btn_edit = new QPushButton(); |
65 QPushButton* btn_edit = new QPushButton(); |
71 btn_edit->setObjectName(QString("%1").arg(query.value(0).toString())); /* Send record with the button */ |
66 btn_edit->setObjectName(QString("%1").arg(query.value(0).toString())); /* Send record with the button */ |
72 btn_edit->setText(tr("Edit")); |
67 btn_edit->setText(tr("Edit")); |
73 connect(btn_edit, SIGNAL(clicked()), this, SLOT(on_editButton_clicked())); |
68 connect(btn_edit, SIGNAL(clicked()), this, SLOT(on_editButton_clicked())); |
74 QHBoxLayout* pLayout = new QHBoxLayout(pWidget); |
69 QHBoxLayout* pLayout = new QHBoxLayout(pWidget); |
75 pLayout->addWidget(btn_edit); |
70 pLayout->addWidget(btn_edit); |
76 // pLayout->setAlignment(Qt::AlignCenter); |
|
77 pLayout->setContentsMargins(5, 0, 5, 0); |
71 pLayout->setContentsMargins(5, 0, 5, 0); |
78 pWidget->setLayout(pLayout); |
72 pWidget->setLayout(pLayout); |
79 ui->tableSuppliers->setCellWidget(ridx, 6, pWidget); |
73 ui->tableSuppliers->setCellWidget(ridx, 5, pWidget); |
80 query.next(); |
74 query.next(); |
81 } |
75 } |
82 |
76 |
83 setWindowTitle( QString("BMSapp - %1 - Inventory Suppliers").arg(VERSIONSTRING) ); |
77 setWindowTitle( QString("BMSapp - %1 - Inventory Suppliers").arg(VERSIONSTRING) ); |
84 } |
78 } |