src/InventorySuppliers.cpp

changeset 22
b52978ee7412
parent 19
c94edc758a5b
child 61
3fea5dde2b99
equal deleted inserted replaced
21:15e5879df8dc 22:b52978ee7412
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 }

mercurial