ModelDevices::ModelDevices(QSqlDatabase &db, QObject *parent): query(db), QSqlQueryModel(parent){ int index(1); roles[Qt::UserRole + index++] += "device_id"; roles[Qt::UserRole + index++] += "section"; roles[Qt::UserRole + index++] += "division"; roles[Qt::UserRole + index++] += "power_center"; roles[Qt::UserRole + index++] += "group_name"; roles[Qt::UserRole + index++] += "net_address"; roles[Qt::UserRole + index++] += "personal_account"; roles[Qt::UserRole + index++] += "payment_code"; roles[Qt::UserRole + index++] += "accounting_type"; roles[Qt::UserRole + index++] += "settlement"; roles[Qt::UserRole + index++] += "street"; roles[Qt::UserRole + index++] += "house"; roles[Qt::UserRole + index++] += "consumer_name"; roles[Qt::UserRole + index++] += "serial_number"; roles[Qt::UserRole + index++] += "repeater"; roles[Qt::UserRole + index++] += "coefficient"; roles[Qt::UserRole + index++] += "device_type"; roles[Qt::UserRole + index++] += "ra_id"; roles[Qt::UserRole + index++] += "gateway_number"; roles[Qt::UserRole + index++] += "device_status"; roles[Qt::UserRole + index++] += "askue"; roles[Qt::UserRole + index++] += "note"; roles[Qt::UserRole + index++] += "device_removed"; roles[Qt::UserRole + index++] += "object_id";}//==============================================QVariant ModelDevices::data(const QModelIndex &item, int role) const{ QVariant value; if (role < Qt::UserRole) { value = QSqlQueryModel::data(item, role); } else { int columnIndex = role - Qt::UserRole - 1; QModelIndex modelIndex = this->index(item.row(), columnIndex); value = QSqlQueryModel::data(modelIndex, Qt::DisplayRole); } return value;}//==============================================QHash<int, QByteArray> ModelDevices::roleNames() const{ return roles;}//==============================================
SortFilterProxyModel::SortFilterProxyModel(QObject *parent) : QSortFilterProxyModel(parent), m_complete(false){ connect(this, SIGNAL(rowsInserted(QModelIndex,int,int)), this, SIGNAL(countChanged())); connect(this, SIGNAL(rowsRemoved(QModelIndex,int,int)), this, SIGNAL(countChanged()));}int SortFilterProxyModel::count() const{ return rowCount();}QObject *SortFilterProxyModel::source() const{ return sourceModel();}void SortFilterProxyModel::setSource(QObject *source){ setSourceModel(qobject_cast<QAbstractItemModel *>(source));}QByteArray SortFilterProxyModel::sortRole() const{ return m_sortRole;}void SortFilterProxyModel::setSortRole(const QByteArray &role){ if (m_sortRole != role) { m_sortRole = role; if (m_complete) QSortFilterProxyModel::setSortRole(roleKey(role)); }}void SortFilterProxyModel::setSortOrder(Qt::SortOrder order){ QSortFilterProxyModel::sort(0, order);}QByteArray SortFilterProxyModel::filterRole() const{ return m_filterRole;}void SortFilterProxyModel::setFilterRole(const QByteArray &role){ if (m_filterRole != role) { m_filterRole = role; if (m_complete) QSortFilterProxyModel::setFilterRole(roleKey(role)); }}QString SortFilterProxyModel::filterString() const{ return filterRegExp().pattern();}void SortFilterProxyModel::setFilterString(const QString &filter){ setFilterRegExp(QRegExp(filter, filterCaseSensitivity(), static_cast<QRegExp::PatternSyntax>(filterSyntax())));}SortFilterProxyModel::FilterSyntax SortFilterProxyModel::filterSyntax() const{ return static_cast<FilterSyntax>(filterRegExp().patternSyntax());}void SortFilterProxyModel::setFilterSyntax(SortFilterProxyModel::FilterSyntax syntax){ setFilterRegExp(QRegExp(filterString(), filterCaseSensitivity(), static_cast<QRegExp::PatternSyntax>(syntax)));}QJSValue SortFilterProxyModel::get(int idx) const{ QJSEngine *engine = qmlEngine(this); QJSValue value = engine->newObject(); if (idx >= 0 && idx < count()) { QHash<int, QByteArray> roles = roleNames(); QHashIterator<int, QByteArray> it(roles); while (it.hasNext()) { it.next(); value.setProperty(QString::fromUtf8(it.value()), data(index(idx, 0), it.key()).toString()); } } return value;}void SortFilterProxyModel::classBegin(){}void SortFilterProxyModel::componentComplete(){ m_complete = true; if (!m_sortRole.isEmpty()) QSortFilterProxyModel::setSortRole(roleKey(m_sortRole)); if (!m_filterRole.isEmpty()) QSortFilterProxyModel::setFilterRole(roleKey(m_filterRole));}int SortFilterProxyModel::roleKey(const QByteArray &role) const{ QHash<int, QByteArray> roles = roleNames(); QHashIterator<int, QByteArray> it(roles); while (it.hasNext()) { it.next(); if (it.value() == role) return it.key(); } return -1;}QHash<int, QByteArray> SortFilterProxyModel::roleNames() const{ if (QAbstractItemModel *source = sourceModel()) return source->roleNames(); return QHash<int, QByteArray>();}bool SortFilterProxyModel::filterAcceptsRow(int sourceRow, const QModelIndex &sourceParent) const{ QRegExp rx = filterRegExp(); if (rx.isEmpty()) return true; QAbstractItemModel *model = sourceModel(); if (filterRole().isEmpty()) { QHash<int, QByteArray> roles = roleNames(); QHashIterator<int, QByteArray> it(roles); while (it.hasNext()) { it.next(); QModelIndex sourceIndex = model->index(sourceRow, 0, sourceParent); QString key = model->data(sourceIndex, it.key()).toString(); if (key.contains(rx)) return true; } return false; } QModelIndex sourceIndex = model->index(sourceRow, 0, sourceParent); if (!sourceIndex.isValid()) return true; QString key = model->data(sourceIndex, roleKey(filterRole())).toString(); return key.contains(rx);}
engine = new QQmlApplicationEngine(this); qmlRegisterType<SortFilterProxyModel>("org.qtproject.example", 1, 0, "SortFilterProxyModel"); engine->load(QUrl("qrc:///Ui/MainWindow")); engine->rootContext()->setContextProperty("ram", this); engine->rootContext()->setContextProperty("modelGroups", modelGroups); engine->rootContext()->setContextProperty("modelObjects", modelObjects); engine->rootContext()->setContextProperty("modelDevices", modelDevices);
// Настройка прокси модели SortFilterProxyModel { id: proxyModelDevices source: modelDevices sortOrder: viewListDevices.sortIndicatorOrder //sortCaseSensitivity: Qt.CaseInsensitive sortRole: viewListDevices.getColumn(viewListDevices.sortIndicatorColumn).role filterString: textSearch.text filterSyntax: SortFilterProxyModel.Wildcard filterCaseSensitivity: Qt.CaseInsensitive }
