19#include "moc_qgsjoindialog.cpp"
29#include <QStandardItemModel>
33 : QDialog( parent, f )
37 connect( buttonBox, &QDialogButtonBox::helpRequested,
this, [ = ]
39 QgsHelp::openHelp( QStringLiteral(
"working_with_vector/vector_properties.html#joins-properties" ) );
47 alreadyJoinedLayers.append( layer );
49 mTargetFieldComboBox->setLayer( mLayer );
51 mDynamicFormCheckBox->setToolTip( tr(
"This option allows values of the joined fields to be automatically reloaded when the \"Target Field\" is changed" ) );
53 mEditableJoinLayer->setToolTip( tr(
"This option allows values of the joined layers to be editable if they're themselves editable" ) );
54 mUpsertOnEditCheckBox->setToolTip( tr(
"Automatically adds a matching row to the joined table, but if one already exists then update that matching row instead" ) );
55 mDeleteCascadeCheckBox->setToolTip( tr(
"Automatically delete the corresponding feature of the linked layer if one exists" ) );
58 mJoinLayerComboBox->setExceptedLayerList( alreadyJoinedLayers );
62 mCacheInMemoryCheckBox->setChecked(
true );
63 mCacheEnabled = mCacheInMemoryCheckBox->isChecked();
65 QgsMapLayer *joinLayer = mJoinLayerComboBox->currentLayer();
66 if ( joinLayer && joinLayer->
isValid() )
68 mJoinFieldComboBox->setLayer( joinLayer );
69 joinedLayerChanged( joinLayer );
75 connect( mEditableJoinLayer, &QGroupBox::toggled,
this, &QgsJoinDialog::editableJoinLayerChanged );
77 checkDefinitionValid();
96 mUseCustomPrefix->setChecked(
false );
100 mUseCustomPrefix->setChecked(
true );
105 mUseJoinFieldsSubset->setChecked( lst && !lst->isEmpty() );
106 QAbstractItemModel *model = mJoinFieldsSubsetView->model();
109 for (
int i = 0; i < model->rowCount(); ++i )
111 const QModelIndex index = model->index( i, 0 );
112 if ( lst && lst->contains( model->data( index, Qt::DisplayRole ).toString() ) )
114 model->setData( index, Qt::Checked, Qt::CheckStateRole );
118 model->setData( index, Qt::Unchecked, Qt::CheckStateRole );
123 editableJoinLayerChanged();
129 info.
setJoinLayer( qobject_cast<QgsVectorLayer *>( mJoinLayerComboBox->currentLayer() ) );
135 info.
setEditable( mEditableJoinLayer->isChecked() );
142 if ( mUseCustomPrefix->isChecked() )
147 if ( mUseJoinFieldsSubset->isChecked() )
150 QAbstractItemModel *model = mJoinFieldsSubsetView->model();
153 for (
int i = 0; i < model->rowCount(); ++i )
155 const QModelIndex index = model->index( i, 0 );
156 if ( model->data( index, Qt::CheckStateRole ).toInt() == Qt::Checked )
157 lst << model->data( index ).toString();
168 return mCreateIndexCheckBox->isChecked();
171void QgsJoinDialog::joinedLayerChanged(
QgsMapLayer *layer )
173 mJoinFieldComboBox->clear();
181 mUseJoinFieldsSubset->setChecked(
false );
182 QStandardItemModel *subsetModel =
new QStandardItemModel(
this );
184 for (
const QgsField &field : layerFields )
186 QStandardItem *subsetItem =
new QStandardItem( field.name() );
187 subsetItem->setCheckable(
true );
189 subsetModel->appendRow( subsetItem );
191 mJoinFieldsSubsetView->setModel( subsetModel );
195 if ( canCreateAttrIndex )
197 mCreateIndexCheckBox->setEnabled(
true );
201 mCreateIndexCheckBox->setEnabled(
false );
202 mCreateIndexCheckBox->setChecked(
false );
205 if ( !mUseCustomPrefix->isChecked() )
207 mCustomPrefix->setText( layer->
name() +
'_' );
211void QgsJoinDialog::checkDefinitionValid()
213 buttonBox->button( QDialogButtonBox::Ok )->setEnabled( mJoinLayerComboBox->currentIndex() != -1
214 && mJoinFieldComboBox->currentIndex() != -1
215 && mTargetFieldComboBox->currentIndex() != -1 );
218void QgsJoinDialog::editableJoinLayerChanged()
220 if ( mEditableJoinLayer->isChecked() )
222 mCacheInMemoryCheckBox->setEnabled(
false );
223 mCacheInMemoryCheckBox->setToolTip( tr(
"Caching can not be enabled if editable join layer is enabled" ) );
224 mCacheEnabled = mCacheInMemoryCheckBox->isChecked();
225 mCacheInMemoryCheckBox->setChecked(
false );
229 mCacheInMemoryCheckBox->setEnabled(
true );
230 mCacheInMemoryCheckBox->setToolTip( QString() );
231 mCacheInMemoryCheckBox->setChecked( mCacheEnabled );
@ CreateAttributeIndex
Can create indexes on provider's fields.
void fieldChanged(const QString &fieldName)
Emitted when the currently selected field changes.
void setLayer(QgsMapLayer *layer)
Sets the layer for which fields are listed in the combobox.
Encapsulate a field in an attribute table or data source.
Container of fields for a vector layer.
static void openHelp(const QString &key)
Opens help topic for the given help key using default system web browser.
QgsJoinDialog(QgsVectorLayer *layer, QList< QgsMapLayer * > alreadyJoinedLayers, QWidget *parent=nullptr, Qt::WindowFlags f=Qt::WindowFlags())
QgsVectorLayerJoinInfo joinInfo() const
Returns the join info.
bool createAttributeIndex() const
Returns true if user wants to create an attribute index on the join field.
void setJoinInfo(const QgsVectorLayerJoinInfo &joinInfo)
Configure the dialog for an existing join.
void layerChanged(QgsMapLayer *layer)
Emitted whenever the currently selected layer changes.
Base class for all map layer types.
This is the base class for vector data providers.
virtual Q_INVOKABLE Qgis::VectorProviderCapabilities capabilities() const
Returns flags containing the supported capabilities.
Defines left outer join from our vector layer to some other vector layer.
void setDynamicFormEnabled(bool enabled)
Sets whether the form has to be dynamically updated with joined fields when a feature is being create...
bool hasCascadedDelete() const
Returns whether a feature deleted on the target layer has to impact the joined layer by deleting the ...
void setUsingMemoryCache(bool enabled)
Sets whether values from the joined layer should be cached in memory to speed up lookups.
bool isDynamicFormEnabled() const
Returns whether the form has to be dynamically updated with joined fields when a feature is being cre...
bool hasUpsertOnEdit() const
Returns whether a feature created on the target layer has to impact the joined layer by creating a ne...
void setEditable(bool enabled)
Sets whether the form of the target layer allows editing joined fields.
bool isEditable() const
Returns whether joined fields may be edited through the form of the target layer.
void setCascadedDelete(bool enabled)
Sets whether a feature deleted on the target layer has to impact the joined layer by deleting the cor...
void setJoinFieldName(const QString &fieldName)
Sets name of the field of joined layer that will be used for join.
bool isUsingMemoryCache() const
Returns whether values from the joined layer should be cached in memory to speed up lookups.
QString prefix() const
Returns prefix of fields from the joined layer. If nullptr, joined layer's name will be used.
static QStringList joinFieldNamesSubset(const QgsVectorLayerJoinInfo &info, bool blocklisted=true)
Returns the list of field names to use for joining considering blocklisted fields and subset.
void setTargetFieldName(const QString &fieldName)
Sets name of the field of our layer that will be used for join.
QString joinFieldName() const
Returns name of the field of joined layer that will be used for join.
void setUpsertOnEdit(bool enabled)
Sets whether a feature created on the target layer has to impact the joined layer by creating a new f...
QString targetFieldName() const
Returns name of the field of our layer that will be used for join.
void setPrefix(const QString &prefix)
Sets prefix of fields from the joined layer. If nullptr, joined layer's name will be used.
void setJoinLayer(QgsVectorLayer *layer)
Sets weak reference to the joined layer.
QgsVectorLayer * joinLayer() const
Returns joined layer (may be nullptr if the reference was set by layer ID and not resolved yet)
void setJoinFieldNamesSubset(QStringList *fieldNamesSubset)
Sets the subset of fields to be used from joined layer.
Represents a vector layer which manages a vector based data sets.
QgsVectorDataProvider * dataProvider() FINAL
Returns the layer's data provider, it may be nullptr.