void availableRoomsWindow::initializeTable() { qDebug() << Q_FUNC_INFO; QTableView* tableView = ui->tableView; tableView->setModel(parameters->availableRoomsMdl); tableView->setSelectionBehavior(QAbstractItemView::SelectRows); tableView->setAlternatingRowColors(true); tableView->setSelectionMode(QAbstractItemView::SingleSelection); tableView->horizontalHeader()->setHighlightSections(false); tableView->horizontalHeader()->setSectionResizeMode(0, QHeaderView::Stretch); tableView->horizontalHeader()->setSectionResizeMode(2, QHeaderView::ResizeToContents); tableView->horizontalHeader()->setSectionResizeMode(3, QHeaderView::ResizeToContents); tableView->horizontalHeader()->setSectionResizeMode(4, QHeaderView::ResizeToContents); tableView->horizontalHeader()->setSectionResizeMode(5, QHeaderView::ResizeToContents); tableView->hideColumn(1); tableView->hideColumn(6); tableView->hideColumn(7); tableView->hideColumn(8); tableView->hideColumn(9); tableView->hideColumn(10); tableView->hideColumn(11); tableView->hideColumn(12); tableView->hideColumn(13); tableView->verticalHeader()->setSectionResizeMode(QHeaderView::Fixed); ui->tableView->verticalHeader()->setDefaultSectionSize(23); }
void QSqlTableModel_snippets() { //! [24] QSqlTableModel *model = new QSqlTableModel(parentObject, database); model->setTable("employee"); model->setEditStrategy(QSqlTableModel::OnManualSubmit); model->select(); model->setHeaderData(0, Qt::Horizontal, tr("Name")); model->setHeaderData(1, Qt::Horizontal, tr("Salary")); QTableView *view = new QTableView; view->setModel(model); view->hideColumn(0); // don't show the ID view->show(); //! [24] { //! [25] QSqlTableModel model; model.setTable("employee"); QString name = model.record(4).value("name").toString(); //! [25] } }
bool DatabaseHandler::getSpeciesList(QString type, QComboBox * cmb_box) { qDebug() << "Populating species list for " << type; QString qstr = "SELECT name_de, name_lat, euring_id, length FROM taxa LEFT JOIN " "(SELECT id_code, to_char(avg(length), 'FM99.99') as length FROM census WHERE tp='%1' GROUP BY id_code) as lt ON taxa.euring_id = lt.id_code " "WHERE type='%1' ORDER BY seaflag DESC, name_de"; QSqlQueryModel * model = new QSqlQueryModel; model->setQuery(qstr.arg(type)); qDebug() << qstr.arg(type); model->setHeaderData(0, Qt::Horizontal, "Deutscher Name"); model->setHeaderData(1, Qt::Horizontal, "Wissenschaftlicher Name"); model->setHeaderData(2, Qt::Horizontal, "EURING Code"); model->setHeaderData(3, Qt::Horizontal, QString::fromUtf8("Länge")); cmb_box->setModel(model); QTableView * view = new QTableView; cmb_box->setView(view); view->verticalHeader()->hide(); view->hideColumn(2); view->resizeColumnsToContents(); view->setSelectionMode(QAbstractItemView::SingleSelection); view->setSelectionBehavior(QAbstractItemView::SelectRows); view->setMinimumWidth(view->horizontalHeader()->length()); return true; }
//------------------------------------------------------------------------------ AnalysisSummaryWidget::AnalysisSummaryWidget(QSharedPointer<BudgetingPeriod> period, ProjectedBalanceModel* balances, EstimateDiffsModel* over, EstimateDiffsModel* under, QWidget* parent) : QWidget(parent) { importSource = new QLineEdit(tr("None")); importSource->setReadOnly(true); importCount = new QLineEdit("0"); importCount->setReadOnly(true); assignedCount = new QLineEdit("0"); assignedCount->setReadOnly(true); overBudgetCount = new QLineEdit("0"); overBudgetCount->setReadOnly(true); underBudgetCount = new QLineEdit("0"); underBudgetCount->setReadOnly(true); QFormLayout* formLayout = new QFormLayout; formLayout->addRow(tr("Import Source"), importSource); formLayout->addRow(tr("Number of Imported Transactions"), importCount); formLayout->addRow(tr("Number of Assigned Transactions"), assignedCount); formLayout->addRow(tr("Number of Over-budget Estimates"), overBudgetCount); formLayout->addRow(tr("Number of Under-budget Estimates"), underBudgetCount); QTableView* balanceTable = new QTableView(this); balanceTable->setModel(balances); balanceTable->horizontalHeader()->setSectionResizeMode(QHeaderView::Stretch); balanceTable->setSelectionBehavior(QTableView::SelectRows); QTableView* overBudgetTable = new QTableView(this); QSortFilterProxyModel* overModel = new QSortFilterProxyModel(this); overModel->setSourceModel(over); overBudgetTable->setModel(overModel); overBudgetTable->horizontalHeader()->setSectionResizeMode(QHeaderView::ResizeToContents); overBudgetTable->horizontalHeader()->setSectionResizeMode(1, QHeaderView::Stretch); overBudgetTable->setSelectionBehavior(QTableView::SelectRows); overBudgetTable->hideColumn(0); // Only show expense estimates overModel->setFilterKeyColumn(0); overModel->setFilterRegExp(QRegExp(QString("%1").arg(Estimate::Expense))); QTableView* underBudgetTable = new QTableView(this); QSortFilterProxyModel* underModel = new QSortFilterProxyModel(this); underModel->setSourceModel(under); underBudgetTable->setModel(underModel); underBudgetTable->horizontalHeader()->setSectionResizeMode(QHeaderView::ResizeToContents); underBudgetTable->horizontalHeader()->setSectionResizeMode(1, QHeaderView::Stretch); underBudgetTable->setSelectionBehavior(QTableView::SelectRows); underBudgetTable->hideColumn(0); // Only show expense estimates underModel->setFilterKeyColumn(0); underModel->setFilterRegExp(QRegExp(QString("%1").arg(Estimate::Expense))); QVBoxLayout* layout = new QVBoxLayout(this); layout->addLayout(formLayout); layout->addWidget(new QLabel(tr("Projected Ending Balances"))); layout->addWidget(balanceTable); layout->addWidget(new QLabel(tr("Top Over-budget Estimates"))); layout->addWidget(overBudgetTable); layout->addWidget(new QLabel(tr("Top Under-budget Estimates"))); layout->addWidget(underBudgetTable); setLayout(layout); }