QGIS API Documentation 3.99.0-Master (e9821da5c6b)
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
20#include "qgsfieldconstraints.h"
21#include "qgsfields.h"
22#include "qgsproject.h"
23#include "qgsrelationmanager.h"
24#include "qgsvectorlayer.h"
25
26#include <QString>
27
28#include "moc_qgsrelationreferenceconfigdlg.cpp"
29
30using namespace Qt::StringLiterals;
31
33 : QgsEditorConfigWidget( vl, fieldIdx, parent )
34
35{
36 setupUi( this );
37
38 mFetchLimit->setMaximum( std::numeric_limits<int>::max() );
39
40 connect( mAddFilterButton, &QToolButton::clicked, this, &QgsRelationReferenceConfigDlg::mAddFilterButton_clicked );
41 connect( mRemoveFilterButton, &QToolButton::clicked, this, &QgsRelationReferenceConfigDlg::mRemoveFilterButton_clicked );
42
43 mExpressionWidget->registerExpressionContextGenerator( vl );
44
45 connect( mComboRelation, static_cast<void ( QComboBox::* )( int )>( &QComboBox::currentIndexChanged ), this, &QgsRelationReferenceConfigDlg::relationChanged );
46
47 const auto constReferencingRelations = vl->referencingRelations( fieldIdx );
48 for ( const QgsRelation &relation : constReferencingRelations )
49 {
50 if ( relation.name().isEmpty() )
51 mComboRelation->addItem( u"%1 (%2)"_s.arg( relation.id(), relation.referencedLayerId() ), relation.id() );
52 else
53 mComboRelation->addItem( u"%1 (%2)"_s.arg( relation.name(), relation.referencedLayerId() ), relation.id() );
54
55 QStandardItemModel *model = qobject_cast<QStandardItemModel *>( mComboRelation->model() );
56 QStandardItem *item = model->item( model->rowCount() - 1 );
57 item->setFlags( relation.type() == Qgis::RelationshipType::Generated ? item->flags() & ~Qt::ItemIsEnabled : item->flags() | Qt::ItemIsEnabled );
58
59 if ( auto *lReferencedLayer = relation.referencedLayer() )
60 {
61 mExpressionWidget->setField( lReferencedLayer->displayExpression() );
62 }
63 }
64
65 connect( mCbxAllowNull, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
66 connect( mCbxShowForm, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
67 connect( mCbxShowOpenFormButton, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
68 connect( mCbxMapIdentification, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
69 connect( mCbxReadOnly, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
70 connect( mComboRelation, static_cast<void ( QComboBox::* )( int )>( &QComboBox::currentIndexChanged ), this, &QgsEditorConfigWidget::changed );
71 connect( mCbxAllowAddFeatures, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
72 connect( mFilterGroupBox, &QGroupBox::toggled, this, &QgsEditorConfigWidget::changed );
73 connect( mFilterFieldsList, &QListWidget::itemChanged, this, &QgsEditorConfigWidget::changed );
74 connect( mCbxChainFilters, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
75 connect( mExpressionWidget, static_cast<void ( QgsFieldExpressionWidget::* )( const QString & )>( &QgsFieldExpressionWidget::fieldChanged ), this, &QgsEditorConfigWidget::changed );
76 connect( mEditExpression, &QAbstractButton::clicked, this, &QgsRelationReferenceConfigDlg::mEditExpression_clicked );
77 connect( mFilterExpression, &QTextEdit::textChanged, this, &QgsEditorConfigWidget::changed );
78 connect( mFetchLimitCheckBox, &QCheckBox::toggled, mFetchLimit, &QSpinBox::setEnabled );
79 connect( mCbxChainFilters, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
80 connect( mOrderByDescending, &QAbstractButton::toggled, this, &QgsEditorConfigWidget::changed );
81 connect( mOrderByExpressionWidget, static_cast<void ( QgsFieldExpressionWidget::* )( const QString & )>( &QgsFieldExpressionWidget::fieldChanged ), this, &QgsEditorConfigWidget::changed );
82}
83
84void QgsRelationReferenceConfigDlg::mEditExpression_clicked()
85{
86 QgsVectorLayer *vl = qobject_cast<QgsVectorLayer *>( layer() );
87 if ( !vl )
88 return;
89
93
94 context.setHighlightedFunctions( QStringList() << u"current_value"_s << u"current_parent_value"_s );
95 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 );
96
97 QgsExpressionBuilderDialog dlg( vl, mFilterExpression->toPlainText(), this, u"generic"_s, context );
98 dlg.setWindowTitle( tr( "Edit Filter Expression" ) );
99
100 if ( dlg.exec() == QDialog::Accepted )
101 {
102 mFilterExpression->setPlainText( dlg.expressionBuilder()->expressionText() );
103 }
104}
105
107{
108 // Only unset allowNull if it was in the config or the default value that was
109 // calculated from the field constraints when the widget was created will be overridden
110 mAllowNullWasSetByConfig = config.contains( u"AllowNULL"_s );
111 if ( mAllowNullWasSetByConfig )
112 {
113 mCbxAllowNull->setChecked( config.value( u"AllowNULL"_s, false ).toBool() );
114 }
115 mCbxShowForm->setChecked( config.value( u"ShowForm"_s, false ).toBool() );
116 mCbxShowOpenFormButton->setChecked( config.value( u"ShowOpenFormButton"_s, true ).toBool() );
117
118 if ( config.contains( u"Relation"_s ) )
119 {
120 mComboRelation->setCurrentIndex( mComboRelation->findData( config.value( u"Relation"_s ).toString() ) );
121 relationChanged( mComboRelation->currentIndex() );
122 }
123
124 mCbxMapIdentification->setChecked( config.value( u"MapIdentification"_s, false ).toBool() );
125 mCbxAllowAddFeatures->setChecked( config.value( u"AllowAddFeatures"_s, false ).toBool() );
126 mCbxReadOnly->setChecked( config.value( u"ReadOnly"_s, false ).toBool() );
127 mFetchLimitCheckBox->setChecked( config.value( u"FetchLimitActive"_s, QgsSettings().value( u"maxEntriesRelationWidget"_s, 100, QgsSettings::Gui ).toInt() > 0 ).toBool() );
128 mFetchLimit->setValue( config.value( u"FetchLimitNumber"_s, QgsSettings().value( u"maxEntriesRelationWidget"_s, 100, QgsSettings::Gui ) ).toInt() );
129
130 mOrderByExpressionWidget->setExpression( config.value( u"OrderExpression"_s ).toString() );
131 mOrderByDescending->setChecked( config.value( u"OrderDescending"_s, false ).toBool() );
132
133 mFilterExpression->setPlainText( config.value( u"FilterExpression"_s ).toString() );
134 if ( config.contains( u"FilterFields"_s ) )
135 {
136 mFilterGroupBox->setChecked( true );
137 const auto constToStringList = config.value( "FilterFields" ).toStringList();
138 for ( const QString &fld : constToStringList )
139 {
140 addFilterField( fld );
141 }
142
143 mCbxChainFilters->setChecked( config.value( u"ChainFilters"_s ).toBool() );
144 }
145}
146
147void QgsRelationReferenceConfigDlg::relationChanged( int idx )
148{
149 const QString relName = mComboRelation->itemData( idx ).toString();
150 const QgsRelation rel = QgsProject::instance()->relationManager()->relation( relName );
151
152 mReferencedLayer = rel.referencedLayer();
153 mExpressionWidget->setLayer( mReferencedLayer ); // set even if 0
154 if ( mReferencedLayer )
155 {
156 mExpressionWidget->setField( mReferencedLayer->displayExpression() );
157 mCbxMapIdentification->setEnabled( mReferencedLayer->isSpatial() );
158 }
159 mOrderByExpressionWidget->setLayer( mReferencedLayer );
160 // If AllowNULL is not set in the config, provide a default value based on the
161 // constraints of the referencing fields
162 if ( !mAllowNullWasSetByConfig )
163 {
164 mCbxAllowNull->setChecked( rel.referencingFieldsAllowNull() );
165 }
166
167 loadFields();
168}
169
170void QgsRelationReferenceConfigDlg::mAddFilterButton_clicked()
171{
172 const auto constSelectedItems = mAvailableFieldsList->selectedItems();
173 for ( QListWidgetItem *item : constSelectedItems )
174 {
175 addFilterField( item );
176 }
177}
178
179void QgsRelationReferenceConfigDlg::mRemoveFilterButton_clicked()
180{
181 const auto constSelectedItems = mFilterFieldsList->selectedItems();
182 for ( QListWidgetItem *item : constSelectedItems )
183 {
184 mFilterFieldsList->takeItem( indexFromListWidgetItem( item ) );
185 mAvailableFieldsList->addItem( item );
186 }
187}
188
190{
191 QVariantMap myConfig;
192 myConfig.insert( u"AllowNULL"_s, mCbxAllowNull->isChecked() );
193 myConfig.insert( u"ShowForm"_s, mCbxShowForm->isChecked() );
194 myConfig.insert( u"ShowOpenFormButton"_s, mCbxShowOpenFormButton->isChecked() );
195 myConfig.insert( u"MapIdentification"_s, mCbxMapIdentification->isEnabled() && mCbxMapIdentification->isChecked() );
196 myConfig.insert( u"ReadOnly"_s, mCbxReadOnly->isChecked() );
197 myConfig.insert( u"Relation"_s, mComboRelation->currentData() );
198 myConfig.insert( u"AllowAddFeatures"_s, mCbxAllowAddFeatures->isChecked() );
199 myConfig.insert( u"FetchLimitActive"_s, mFetchLimitCheckBox->isChecked() );
200 myConfig.insert( u"FetchLimitNumber"_s, mFetchLimit->value() );
201
202 myConfig.insert( u"OrderExpression"_s, mOrderByExpressionWidget->currentField() );
203 myConfig.insert( u"OrderDescending"_s, mOrderByDescending->isChecked() );
204
205 if ( mFilterGroupBox->isChecked() )
206 {
207 QStringList filterFields;
208 filterFields.reserve( mFilterFieldsList->count() );
209 for ( int i = 0; i < mFilterFieldsList->count(); i++ )
210 {
211 filterFields << mFilterFieldsList->item( i )->data( Qt::UserRole ).toString();
212 }
213 myConfig.insert( u"FilterFields"_s, filterFields );
214
215 myConfig.insert( u"ChainFilters"_s, mCbxChainFilters->isChecked() );
216 myConfig.insert( u"FilterExpression"_s, mFilterExpression->toPlainText() );
217 }
218
219 if ( mReferencedLayer )
220 {
221 // Store referenced layer data source and provider
222 myConfig.insert( u"ReferencedLayerDataSource"_s, mReferencedLayer->publicSource() );
223 myConfig.insert( u"ReferencedLayerProviderKey"_s, mReferencedLayer->providerType() );
224 myConfig.insert( u"ReferencedLayerId"_s, mReferencedLayer->id() );
225 myConfig.insert( u"ReferencedLayerName"_s, mReferencedLayer->name() );
226 mReferencedLayer->setDisplayExpression( mExpressionWidget->currentField() );
227 }
228
229 return myConfig;
230}
231
232void QgsRelationReferenceConfigDlg::loadFields()
233{
234 mAvailableFieldsList->clear();
235 mFilterFieldsList->clear();
236
237 if ( mReferencedLayer )
238 {
239 QgsVectorLayer *l = mReferencedLayer;
240 const QgsFields &flds = l->fields();
241 for ( int i = 0; i < flds.count(); i++ )
242 {
243 mAvailableFieldsList->addItem( flds.at( i ).displayName() );
244 mAvailableFieldsList->item( mAvailableFieldsList->count() - 1 )->setData( Qt::UserRole, flds.at( i ).name() );
245 }
246 }
247}
248
249void QgsRelationReferenceConfigDlg::addFilterField( const QString &field )
250{
251 for ( int i = 0; i < mAvailableFieldsList->count(); i++ )
252 {
253 if ( mAvailableFieldsList->item( i )->data( Qt::UserRole ).toString() == field )
254 {
255 addFilterField( mAvailableFieldsList->item( i ) );
256 break;
257 }
258 }
259}
260
261void QgsRelationReferenceConfigDlg::addFilterField( QListWidgetItem *item )
262{
263 mAvailableFieldsList->takeItem( indexFromListWidgetItem( item ) );
264 mFilterFieldsList->addItem( item );
265}
266
267int QgsRelationReferenceConfigDlg::indexFromListWidgetItem( QListWidgetItem *item )
268{
269 QListWidget *lw = item->listWidget();
270
271 for ( int i = 0; i < lw->count(); i++ )
272 {
273 if ( lw->item( i ) == item )
274 return i;
275 }
276
277 return -1;
278}
@ Generated
A generated relation is a child of a polymorphic relation.
Definition qgis.h:4476
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...
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:101
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:124
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.
Stores settings for use within QGIS.
Definition qgssettings.h:68
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