QGIS API Documentation 4.1.0-Master (376402f9aeb)
Loading...
Searching...
No Matches
qgsrelationreferenceconfigdlg.cpp
Go to the documentation of this file.
1/***************************************************************************
2 qgsrelationreferenceconfigdlg.cpp
3 --------------------------------------
4 Date : 21.4.2013
5 Copyright : (C) 2013 Matthias Kuhn
6 Email : matthias at opengis dot ch
7 ***************************************************************************
8 * *
9 * This program is free software; you can redistribute it and/or modify *
10 * it under the terms of the GNU General Public License as published by *
11 * the Free Software Foundation; either version 2 of the License, or *
12 * (at your option) any later version. *
13 * *
14 ***************************************************************************/
15
17
21#include "qgsfieldconstraints.h"
22#include "qgsfields.h"
23#include "qgsproject.h"
24#include "qgsrelationmanager.h"
26#include "qgsvectorlayer.h"
27
28#include <QString>
29
30#include "moc_qgsrelationreferenceconfigdlg.cpp"
31
32using namespace Qt::StringLiterals;
33
35 : QgsEditorConfigWidget( vl, fieldIdx, parent )
36
37{
38 setupUi( this );
39
40 mFetchLimit->setMaximum( std::numeric_limits<int>::max() );
41
42 connect( mAddFilterButton, &QToolButton::clicked, this, &QgsRelationReferenceConfigDlg::mAddFilterButton_clicked );
43 connect( mRemoveFilterButton, &QToolButton::clicked, this, &QgsRelationReferenceConfigDlg::mRemoveFilterButton_clicked );
44
45 mExpressionWidget->registerExpressionContextGenerator( vl );
46
47 connect( mComboRelation, static_cast<void ( QComboBox::* )( int )>( &QComboBox::currentIndexChanged ), this, &QgsRelationReferenceConfigDlg::relationChanged );
48
49 const auto constReferencingRelations = vl->referencingRelations( fieldIdx );
50 for ( const QgsRelation &relation : constReferencingRelations )
51 {
52 if ( relation.name().isEmpty() )
53 mComboRelation->addItem( u"%1 (%2)"_s.arg( relation.id(), relation.referencedLayerId() ), relation.id() );
54 else
55 mComboRelation->addItem( u"%1 (%2)"_s.arg( relation.name(), relation.referencedLayerId() ), relation.id() );
56
57 QStandardItemModel *model = qobject_cast<QStandardItemModel *>( mComboRelation->model() );
58 QStandardItem *item = model->item( model->rowCount() - 1 );
59 item->setFlags( relation.type() == Qgis::RelationshipType::Generated ? item->flags() & ~Qt::ItemIsEnabled : item->flags() | Qt::ItemIsEnabled );
60
61 if ( auto *lReferencedLayer = relation.referencedLayer() )
62 {
63 mExpressionWidget->setField( lReferencedLayer->displayExpression() );
64 }
65 }
66
67 connect( mCbxAllowNull, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
68 connect( mCbxShowForm, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
69 connect( mCbxShowOpenFormButton, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
70 connect( mCbxMapIdentification, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
71 connect( mCbxReadOnly, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
72 connect( mComboRelation, static_cast<void ( QComboBox::* )( int )>( &QComboBox::currentIndexChanged ), this, &QgsEditorConfigWidget::changed );
73 connect( mCbxAllowAddFeatures, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
74 connect( mFilterGroupBox, &QGroupBox::toggled, this, &QgsEditorConfigWidget::changed );
75 connect( mFilterFieldsList, &QListWidget::itemChanged, this, &QgsEditorConfigWidget::changed );
76 connect( mCbxChainFilters, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
77 connect( mExpressionWidget, static_cast<void ( QgsFieldExpressionWidget::* )( const QString & )>( &QgsFieldExpressionWidget::fieldChanged ), this, &QgsEditorConfigWidget::changed );
78 connect( mEditExpression, &QAbstractButton::clicked, this, &QgsRelationReferenceConfigDlg::mEditExpression_clicked );
79 connect( mFilterExpression, &QTextEdit::textChanged, this, &QgsEditorConfigWidget::changed );
80 connect( mFetchLimitCheckBox, &QCheckBox::toggled, mFetchLimit, &QSpinBox::setEnabled );
81 connect( mCbxChainFilters, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
82 connect( mOrderByDescending, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
83 connect( mOrderByExpressionWidget, static_cast<void ( QgsFieldExpressionWidget::* )( const QString & )>( &QgsFieldExpressionWidget::fieldChanged ), this, &QgsEditorConfigWidget::changed );
84}
85
86void QgsRelationReferenceConfigDlg::mEditExpression_clicked()
87{
88 QgsVectorLayer *vl = qobject_cast<QgsVectorLayer *>( layer() );
89 if ( !vl )
90 return;
91
95
96 context.setHighlightedFunctions( QStringList() << u"current_value"_s << u"current_parent_value"_s );
97 context.setHighlightedVariables( QStringList() << u"current_geometry"_s << u"current_feature"_s << u"form_mode"_s << u"current_parent_geometry"_s << u"current_parent_feature"_s );
98
99 QgsExpressionBuilderDialog dlg( vl, mFilterExpression->toPlainText(), this, u"generic"_s, context );
100 dlg.setWindowTitle( tr( "Edit Filter Expression" ) );
101
102 if ( dlg.exec() == QDialog::Accepted )
103 {
104 mFilterExpression->setPlainText( dlg.expressionBuilder()->expressionText() );
105 }
106}
107
109{
110 // Only unset allowNull if it was in the config or the default value that was
111 // calculated from the field constraints when the widget was created will be overridden
112 mAllowNullWasSetByConfig = config.contains( u"AllowNULL"_s );
113 if ( mAllowNullWasSetByConfig )
114 {
115 mCbxAllowNull->setChecked( config.value( u"AllowNULL"_s, false ).toBool() );
116 }
117 mCbxShowForm->setChecked( config.value( u"ShowForm"_s, false ).toBool() );
118 mCbxShowOpenFormButton->setChecked( config.value( u"ShowOpenFormButton"_s, true ).toBool() );
119
120 if ( config.contains( u"Relation"_s ) )
121 {
122 mComboRelation->setCurrentIndex( mComboRelation->findData( config.value( u"Relation"_s ).toString() ) );
123 relationChanged( mComboRelation->currentIndex() );
124 }
125
126 mCbxMapIdentification->setChecked( config.value( u"MapIdentification"_s, false ).toBool() );
127 mCbxAllowAddFeatures->setChecked( config.value( u"AllowAddFeatures"_s, false ).toBool() );
128 mCbxReadOnly->setChecked( config.value( u"ReadOnly"_s, false ).toBool() );
129 mFetchLimitCheckBox->setChecked( config.value( u"FetchLimitActive"_s, QgsFeatureFilterModel::settingsMaxEntriesRelationWidget->value() > 0 ).toBool() );
130 mFetchLimit->setValue( config.value( u"FetchLimitNumber"_s, QgsFeatureFilterModel::settingsMaxEntriesRelationWidget->value() ).toInt() );
131
132 mOrderByExpressionWidget->setExpression( config.value( u"OrderExpression"_s ).toString() );
133 mOrderByDescending->setChecked( config.value( u"OrderDescending"_s, false ).toBool() );
134
135 mFilterExpression->setPlainText( config.value( u"FilterExpression"_s ).toString() );
136 if ( config.contains( u"FilterFields"_s ) )
137 {
138 mFilterGroupBox->setChecked( true );
139 const auto constToStringList = config.value( "FilterFields" ).toStringList();
140 for ( const QString &fld : constToStringList )
141 {
142 addFilterField( fld );
143 }
144
145 mCbxChainFilters->setChecked( config.value( u"ChainFilters"_s ).toBool() );
146 }
147}
148
149void QgsRelationReferenceConfigDlg::relationChanged( int idx )
150{
151 const QString relName = mComboRelation->itemData( idx ).toString();
152 const QgsRelation rel = QgsProject::instance()->relationManager()->relation( relName );
153
154 mReferencedLayer = rel.referencedLayer();
155 mExpressionWidget->setLayer( mReferencedLayer ); // set even if 0
156 if ( mReferencedLayer )
157 {
158 mExpressionWidget->setField( mReferencedLayer->displayExpression() );
159 mCbxMapIdentification->setEnabled( mReferencedLayer->isSpatial() );
160 }
161 mOrderByExpressionWidget->setLayer( mReferencedLayer );
162 // If AllowNULL is not set in the config, provide a default value based on the
163 // constraints of the referencing fields
164 if ( !mAllowNullWasSetByConfig )
165 {
166 mCbxAllowNull->setChecked( rel.referencingFieldsAllowNull() );
167 }
168
169 loadFields();
170}
171
172void QgsRelationReferenceConfigDlg::mAddFilterButton_clicked()
173{
174 const auto constSelectedItems = mAvailableFieldsList->selectedItems();
175 for ( QListWidgetItem *item : constSelectedItems )
176 {
177 addFilterField( item );
178 }
179}
180
181void QgsRelationReferenceConfigDlg::mRemoveFilterButton_clicked()
182{
183 const auto constSelectedItems = mFilterFieldsList->selectedItems();
184 for ( QListWidgetItem *item : constSelectedItems )
185 {
186 mFilterFieldsList->takeItem( indexFromListWidgetItem( item ) );
187 mAvailableFieldsList->addItem( item );
188 }
189}
190
192{
193 QVariantMap myConfig;
194 myConfig.insert( u"AllowNULL"_s, mCbxAllowNull->isChecked() );
195 myConfig.insert( u"ShowForm"_s, mCbxShowForm->isChecked() );
196 myConfig.insert( u"ShowOpenFormButton"_s, mCbxShowOpenFormButton->isChecked() );
197 myConfig.insert( u"MapIdentification"_s, mCbxMapIdentification->isEnabled() && mCbxMapIdentification->isChecked() );
198 myConfig.insert( u"ReadOnly"_s, mCbxReadOnly->isChecked() );
199 myConfig.insert( u"Relation"_s, mComboRelation->currentData() );
200 myConfig.insert( u"AllowAddFeatures"_s, mCbxAllowAddFeatures->isChecked() );
201 myConfig.insert( u"FetchLimitActive"_s, mFetchLimitCheckBox->isChecked() );
202 myConfig.insert( u"FetchLimitNumber"_s, mFetchLimit->value() );
203
204 myConfig.insert( u"OrderExpression"_s, mOrderByExpressionWidget->currentField() );
205 myConfig.insert( u"OrderDescending"_s, mOrderByDescending->isChecked() );
206
207 if ( mFilterGroupBox->isChecked() )
208 {
209 QStringList filterFields;
210 filterFields.reserve( mFilterFieldsList->count() );
211 for ( int i = 0; i < mFilterFieldsList->count(); i++ )
212 {
213 filterFields << mFilterFieldsList->item( i )->data( Qt::UserRole ).toString();
214 }
215 myConfig.insert( u"FilterFields"_s, filterFields );
216
217 myConfig.insert( u"ChainFilters"_s, mCbxChainFilters->isChecked() );
218 myConfig.insert( u"FilterExpression"_s, mFilterExpression->toPlainText() );
219 }
220
221 if ( mReferencedLayer )
222 {
223 // Store referenced layer data source and provider
224 myConfig.insert( u"ReferencedLayerDataSource"_s, mReferencedLayer->publicSource() );
225 myConfig.insert( u"ReferencedLayerProviderKey"_s, mReferencedLayer->providerType() );
226 myConfig.insert( u"ReferencedLayerId"_s, mReferencedLayer->id() );
227 myConfig.insert( u"ReferencedLayerName"_s, mReferencedLayer->name() );
228 mReferencedLayer->setDisplayExpression( mExpressionWidget->currentField() );
229 }
230
231 return myConfig;
232}
233
234void QgsRelationReferenceConfigDlg::loadFields()
235{
236 mAvailableFieldsList->clear();
237 mFilterFieldsList->clear();
238
239 if ( mReferencedLayer )
240 {
241 QgsVectorLayer *l = mReferencedLayer;
242 const QgsFields &flds = l->fields();
243 for ( int i = 0; i < flds.count(); i++ )
244 {
245 mAvailableFieldsList->addItem( flds.at( i ).displayName() );
246 mAvailableFieldsList->item( mAvailableFieldsList->count() - 1 )->setData( Qt::UserRole, flds.at( i ).name() );
247 }
248 }
249}
250
251void QgsRelationReferenceConfigDlg::addFilterField( const QString &field )
252{
253 for ( int i = 0; i < mAvailableFieldsList->count(); i++ )
254 {
255 if ( mAvailableFieldsList->item( i )->data( Qt::UserRole ).toString() == field )
256 {
257 addFilterField( mAvailableFieldsList->item( i ) );
258 break;
259 }
260 }
261}
262
263void QgsRelationReferenceConfigDlg::addFilterField( QListWidgetItem *item )
264{
265 mAvailableFieldsList->takeItem( indexFromListWidgetItem( item ) );
266 mFilterFieldsList->addItem( item );
267}
268
269int QgsRelationReferenceConfigDlg::indexFromListWidgetItem( QListWidgetItem *item )
270{
271 QListWidget *lw = item->listWidget();
272
273 for ( int i = 0; i < lw->count(); i++ )
274 {
275 if ( lw->item( i ) == item )
276 return i;
277 }
278
279 return -1;
280}
@ Generated
A generated relation is a child of a polymorphic relation.
Definition qgis.h:4693
QgsEditorConfigWidget(QgsVectorLayer *vl, int fieldIdx, QWidget *parent)
Create a new configuration widget.
int field()
Returns the field for which this configuration widget applies.
QgsVectorLayer * layer()
Returns the layer for which this configuration widget applies.
void changed()
Emitted when the configuration of the widget is changed.
A generic dialog for building expression strings.
static QgsExpressionContextScope * parentFormScope(const QgsFeature &formFeature=QgsFeature(), const QString &formMode=QString())
Creates a new scope which contains functions and variables from the current parent attribute form/tab...
static QgsExpressionContextScope * formScope(const QgsFeature &formFeature=QgsFeature(), const QString &formMode=QString())
Creates a new scope which contains functions and variables from the current attribute form/table form...
static QList< QgsExpressionContextScope * > globalProjectLayerScopes(const QgsMapLayer *layer)
Creates a list of three scopes: global, layer's project and layer.
Expression contexts are used to encapsulate the parameters around which a QgsExpression should be eva...
static const QgsSettingsEntryInteger * settingsMaxEntriesRelationWidget
Settings for maximum number of entries in relation widget.
A widget for selection of layer fields or expression creation.
void fieldChanged(const QString &fieldName)
Emitted when the currently selected field changes.
QString name
Definition qgsfield.h:65
QString displayName() const
Returns the name to use when displaying this field.
Definition qgsfield.cpp:96
Container of fields for a vector layer.
Definition qgsfields.h:46
int count
Definition qgsfields.h:50
QgsField at(int i) const
Returns the field at particular index (must be in range 0..N-1).
QgsRelationManager * relationManager
Definition qgsproject.h:125
static QgsProject * instance()
Returns the QgsProject singleton instance.
Q_INVOKABLE QgsRelation relation(const QString &id) const
Gets access to a relation by its id.
QgsRelationReferenceConfigDlg(QgsVectorLayer *vl, int fieldIdx, QWidget *parent)
void setConfig(const QVariantMap &config) override
Update the configuration widget to represent the given configuration.
QVariantMap config() override
Create a configuration from the current GUI state.
Represents a relationship between two vector layers.
Definition qgsrelation.h:42
QgsVectorLayer * referencedLayer
Definition qgsrelation.h:50
bool referencingFieldsAllowNull() const
Returns true if none of the referencing fields has a NOT NULL constraint.
Represents a vector layer which manages a vector based dataset.
bool isSpatial() const final
Returns true if this is a geometry layer and false in case of NoGeometry (table only) or UnknownGeome...
QList< QgsRelation > referencingRelations(int idx) const
Returns the layer's relations, where the foreign key is on this layer.
QString displayExpression