25#include <QStandardItemModel>
37 : QAbstractTableModel( parent )
38 , mExpressionContextGenerator( new
QgsFieldMappingModel::ExpressionContextGenerator( sourceFields ) )
45 if ( role == Qt::DisplayRole )
47 switch ( orientation )
55 return tr(
"Source Expression" );
59 return tr(
"Aggregate Function" );
63 return tr(
"Delimiter" );
75 return tr(
"Length" );
79 return tr(
"Precision" );
100 if ( parent.isValid() )
102 return mMapping.count();
107 if ( parent.isValid() )
114 if ( index.isValid() )
117 const Aggregate &agg { mMapping.at( index.row() ) };
121 case Qt::DisplayRole:
132 return agg.aggregate;
136 return agg.delimiter;
140 return agg.field.displayName();
144 return agg.field.typeName();
148 return agg.field.length();
152 return agg.field.precision();
164 if ( index.isValid() )
166 return Qt::ItemFlags( Qt::ItemIsSelectable |
170 return Qt::ItemFlags();
175 if ( index.isValid() )
177 if ( role == Qt::EditRole )
205 QgsFieldMappingModel::setFieldTypeFromName( f.
field, value.toString() );
211 const int length { value.toInt( &ok ) };
219 const int precision { value.toInt( &ok ) };
225 emit dataChanged( index, index );
236bool QgsAggregateMappingModel::moveUpOrDown(
const QModelIndex &index,
bool up )
238 if ( ! index.isValid() && index.model() ==
this )
242 const int row { up ? index.row() - 1 : index.row() };
244 if ( row < 0 || row + 1 >=
rowCount( QModelIndex() ) )
248 beginMoveRows( QModelIndex( ), row, row, QModelIndex(), row + 2 );
249 mMapping.swapItemsAt( row, row + 1 );
257 if ( mExpressionContextGenerator )
258 mExpressionContextGenerator->setSourceFields( mSourceFields );
267 aggregate.
field.
setTypeName( QgsFieldMappingModel::qgsFieldToTypeName( f ) );
271 aggregate.
aggregate = QStringLiteral(
"sum" );
272 else if ( f.type() == QMetaType::Type::QString || ( f.type() == QMetaType::Type::QVariantList && f.subType() == QMetaType::Type::QString ) )
273 aggregate.
aggregate = QStringLiteral(
"concatenate" );
277 mMapping.push_back( aggregate );
284 return mExpressionContextGenerator.get();
289 mExpressionContextGenerator->setBaseExpressionContextGenerator( generator );
301 for (
auto &agg : mMapping )
303 agg.field.setTypeName( QgsFieldMappingModel::qgsFieldToTypeName( agg.field ) );
310 const int lastRow {
rowCount( QModelIndex( ) ) };
311 beginInsertRows( QModelIndex(), lastRow, lastRow );
318 mMapping.push_back( agg );
324 if ( index.isValid() && index.model() ==
this && index.row() <
rowCount( QModelIndex() ) )
326 beginRemoveRows( QModelIndex(), index.row(), index.row() );
327 mMapping.removeAt( index.row() );
339 return moveUpOrDown( index );
344 return moveUpOrDown( index,
false );
356 QVBoxLayout *verticalLayout =
new QVBoxLayout();
357 verticalLayout->setContentsMargins( 0, 0, 0, 0 );
358 mTableView =
new QTableView();
359 verticalLayout->addWidget( mTableView );
360 setLayout( verticalLayout );
363 mTableView->setModel( mModel );
369 connect( mModel, &QgsAggregateMappingModel::rowsInserted,
this, [ = ] { updateColumns(); } );
370 connect( mModel, &QgsAggregateMappingModel::modelReset,
this, [ = ] { updateColumns(); } );
379 return qobject_cast<QgsAggregateMappingModel *>( mModel );
394 return mTableView->selectionModel();
404 mSourceLayer = layer;
414 mTableView->scrollTo( index );
429 if ( ! mTableView->selectionModel()->hasSelection() )
432 std::list<int> rowsToRemove { selectedRows() };
433 rowsToRemove.reverse();
434 for (
const int row : rowsToRemove )
446 if ( ! mTableView->selectionModel()->hasSelection() )
449 const std::list<int> rowsToMoveUp { selectedRows() };
450 for (
const int row : rowsToMoveUp )
462 if ( ! mTableView->selectionModel()->hasSelection() )
465 std::list<int> rowsToMoveDown { selectedRows() };
466 rowsToMoveDown.reverse();
467 for (
const int row : rowsToMoveDown )
477void QgsAggregateMappingWidget::updateColumns()
479 for (
int i = 0; i < mModel->rowCount(); ++i )
486 for (
int i = 0; i < mModel->columnCount(); ++i )
488 mTableView->resizeColumnToContents( i );
492std::list<int> QgsAggregateMappingWidget::selectedRows()
495 if ( mTableView->selectionModel()->hasSelection() )
497 const QModelIndexList constSelection { mTableView->selectionModel()->selectedIndexes() };
498 for (
const QModelIndex &index : constSelection )
500 rows.push_back( index.row() );
515QgsAggregateMappingDelegate::QgsAggregateMappingDelegate( QObject *parent )
516 : QStyledItemDelegate( parent )
520QWidget *QgsAggregateMappingDelegate::createEditor( QWidget *parent,
const QStyleOptionViewItem &option,
const QModelIndex & )
const
523 QComboBox *editor =
new QComboBox( parent );
525 const QStringList aggregateList { aggregates() };
527 for (
const QString &aggregate : aggregateList )
529 editor->addItem( aggregate );
530 editor->setItemData( i, aggregate, Qt::UserRole );
535 qOverload<int >( &QComboBox::currentIndexChanged ),
537 [ = ](
int currentIndex )
539 Q_UNUSED( currentIndex )
540 const_cast< QgsAggregateMappingDelegate *
>( this )->emit commitData( editor );
546void QgsAggregateMappingDelegate::setEditorData( QWidget *editor,
const QModelIndex &index )
const
548 QComboBox *editorWidget { qobject_cast<QComboBox *>( editor ) };
549 if ( ! editorWidget )
552 const QVariant value = index.model()->data( index, Qt::EditRole );
553 editorWidget->setCurrentIndex( editorWidget->findData( value ) );
556void QgsAggregateMappingDelegate::setModelData( QWidget *editor, QAbstractItemModel *model,
const QModelIndex &index )
const
558 QComboBox *editorWidget { qobject_cast<QComboBox *>( editor ) };
559 if ( ! editorWidget )
562 const QVariant currentValue = editorWidget->currentData( );
563 model->setData( index, currentValue, Qt::EditRole );
566const QStringList QgsAggregateMappingDelegate::aggregates()
568 static QStringList sAggregates;
569 static std::once_flag initialized;
570 std::call_once( initialized, [ = ]( )
572 sAggregates << QStringLiteral(
"first_value" )
573 << QStringLiteral(
"last_value" );
578 if ( !function || function->isDeprecated() || function->name().isEmpty() || function->name().at( 0 ) ==
'_' )
581 if ( function->groups().contains( QLatin1String(
"Aggregates" ) ) )
583 if ( function->name() == QLatin1String(
"aggregate" )
584 || function->name() == QLatin1String(
"relation_aggregate" ) )
587 sAggregates.append( function->name() );
590 std::sort( sAggregates.begin(), sAggregates.end() );
The QgsAggregateMappingModel holds mapping information for defining sets of aggregates of fields from...
QgsFields sourceFields() const
Returns a list of source fields.
void appendField(const QgsField &field, const QString &source=QString(), const QString &aggregate=QString())
Appends a new field to the model, with an optional source and aggregate.
QVariant headerData(int section, Qt::Orientation orientation, int role) const override
int columnCount(const QModelIndex &parent=QModelIndex()) const override
ColumnDataIndex
The ColumnDataIndex enum represents the column index for the view.
@ Aggregate
Aggregate name.
@ SourceExpression
Expression.
@ DestinationPrecision
Destination field precision.
@ DestinationName
Destination field name.
@ DestinationType
Destination field type string.
@ DestinationLength
Destination field length.
Qt::ItemFlags flags(const QModelIndex &index) const override
bool removeField(const QModelIndex &index)
Removes the field at index from the model, returns true on success.
bool moveUp(const QModelIndex &index)
Moves down the field at index.
QVariant data(const QModelIndex &index, int role) const override
QList< QgsAggregateMappingModel::Aggregate > mapping() const
Returns a list of Aggregate objects representing the current status of the model.
bool setData(const QModelIndex &index, const QVariant &value, int role) override
QgsExpressionContextGenerator * contextGenerator() const
Returns the context generator with the source fields.
bool moveDown(const QModelIndex &index)
Moves up the field at index.
void setSourceFields(const QgsFields &sourceFields)
Set source fields to sourceFields.
void setMapping(const QList< QgsAggregateMappingModel::Aggregate > &mapping)
Sets the mapping to show in the model.
int rowCount(const QModelIndex &parent=QModelIndex()) const override
void setBaseExpressionContextGenerator(const QgsExpressionContextGenerator *generator)
Sets the base expression context generator, which will generate the expression contexts for expressio...
QgsAggregateMappingModel(const QgsFields &sourceFields=QgsFields(), QObject *parent=nullptr)
Constructs a QgsAggregateMappingModel from a set of sourceFields.
Abstract interface for generating an expression context.
A abstract base class for defining QgsExpression functions.
Class for parsing and evaluation of expressions (formerly called "search strings").
static const QList< QgsExpressionFunction * > & Functions()
static QString quotedColumnRef(QString name)
Returns a quoted column reference (in double quotes)
The QgsFieldMappingModel holds mapping information for mapping from one set of QgsFields to another,...
Encapsulate a field in an attribute table or data source.
void setPrecision(int precision)
Set the field precision.
void setName(const QString &name)
Set the field name.
void setLength(int len)
Set the field length.
void setTypeName(const QString &typeName)
Set the field type.
Container of fields for a vector layer.
Represents a vector layer which manages a vector based data sets.
The Aggregate struct holds information about an aggregate column.
QString source
The source expression used as the input for the aggregate calculation.
QString delimiter
Delimiter string.
QString aggregate
Aggregate name.
QgsField field
The field in its current status (it might have been renamed)