16 #include <QMessageBox> 
   35   setWindowTitle( tr( 
"Database Styles Manager" ) );
 
   37   mDeleteButton = mButtonBox->button( QDialogButtonBox::StandardButton::Close );
 
   38   mDeleteButton->setText( tr( 
"Delete Style" ) );
 
   40   mLoadButton = mButtonBox->button( QDialogButtonBox::StandardButton::Open );
 
   41   mLoadButton->setText( tr( 
"Load Style" ) );
 
   42   mCancelButton = mButtonBox->button( QDialogButtonBox::StandardButton::Cancel );
 
   47   if ( providerName == QLatin1String( 
"ogr" ) )
 
   51     if ( providerName == QLatin1String( 
"GPKG" ) )
 
   52       providerName = QStringLiteral( 
"GeoPackage" );
 
   55   const QString myLastUsedDir = settings.
value( QStringLiteral( 
"style/lastStyleDir" ), QDir::homePath() ).toString();
 
   58   connect( mStyleTypeComboBox, qOverload<int>( &QComboBox::currentIndexChanged ), 
this, [ = ]( 
int )
 
   62     mFileLabel->setVisible( !vl || type != QgsVectorLayerProperties::StyleType::DB );
 
   63     mFileWidget->setVisible( !vl || type != QgsVectorLayerProperties::StyleType::DB );
 
   66       mFromDbWidget->setVisible( type == QgsVectorLayerProperties::StyleType::DB );
 
   71       mFromDbWidget->setVisible( 
false );
 
   72       mDeleteButton->setVisible( 
false );
 
   75     mStyleCategoriesListView->setEnabled( !vl || 
currentStyleType() != QgsVectorLayerProperties::StyleType::SLD );
 
   76     updateLoadButtonState();
 
   80   if ( 
QgsVectorLayer *vl = qobject_cast< QgsVectorLayer * >( mLayer ) )
 
   82     if ( vl->dataProvider()->isSaveAndLoadStyleToDatabaseSupported() )
 
   84       mStyleTypeComboBox->addItem( tr( 
"From Database (%1)" ).arg( providerName ), QgsVectorLayerProperties::StyleType::DB );
 
   85       if ( settings.
value( QStringLiteral( 
"style/lastLoadStyleTypeSelection" ) ) == QgsVectorLayerProperties::StyleType::DB )
 
   87         mStyleTypeComboBox->setCurrentIndex( mStyleTypeComboBox->findData( QgsVectorLayerProperties::StyleType::DB ) );
 
   96   mStyleCategoriesListView->setModel( mModel );
 
   99   switch ( mLayer->
type() )
 
  102       mFileWidget->setFilter( tr( 
"QGIS Layer Style File, SLD File" ) + QStringLiteral( 
" (*.qml *.sld)" ) );
 
  106       mFileWidget->setFilter( tr( 
"All Styles" ) + QStringLiteral( 
" (*.qml *.json);;" )
 
  107                               + tr( 
"QGIS Layer Style File" ) + QStringLiteral( 
" (*.qml);;" )
 
  108                               + tr( 
"MapBox GL Style JSON File" ) + QStringLiteral( 
" (*.json)" ) );
 
  121   mFileWidget->setDefaultRoot( myLastUsedDir );
 
  127     const QFileInfo tmplFileInfo( path );
 
  128     settings.
setValue( QStringLiteral( 
"style/lastStyleDir" ), tmplFileInfo.absolutePath() );
 
  130     updateLoadButtonState();
 
  134   mLoadButton->setDisabled( 
true );
 
  135   mDeleteButton->setDisabled( 
true );
 
  136   mRelatedTable->setEditTriggers( QTableWidget::NoEditTriggers );
 
  137   mRelatedTable->horizontalHeader()->setStretchLastSection( 
true );
 
  138   mRelatedTable->setSelectionBehavior( QTableWidget::SelectRows );
 
  139   mRelatedTable->verticalHeader()->setVisible( 
false );
 
  140   mOthersTable->setEditTriggers( QTableWidget::NoEditTriggers );
 
  141   mOthersTable->horizontalHeader()->setStretchLastSection( 
true );
 
  142   mOthersTable->setSelectionBehavior( QTableWidget::SelectRows );
 
  143   mOthersTable->verticalHeader()->setVisible( 
false );
 
  144   connect( mRelatedTable->selectionModel(), &QItemSelectionModel::selectionChanged, 
this, &QgsMapLayerLoadStyleDialog::onRelatedTableSelectionChanged );
 
  145   connect( mOthersTable->selectionModel(), &QItemSelectionModel::selectionChanged, 
this, &QgsMapLayerLoadStyleDialog::onOthersTableSelectionChanged );
 
  146   connect( mRelatedTable, &QTableWidget::doubleClicked, 
this, &QDialog::accept );
 
  147   connect( mOthersTable, &QTableWidget::doubleClicked, 
this, &QDialog::accept );
 
  148   connect( mCancelButton, &QPushButton::clicked, 
this, &QDialog::reject );
 
  149   connect( mButtonBox, &QDialogButtonBox::helpRequested, 
this, &QgsMapLayerLoadStyleDialog::showHelp );
 
  150   connect( mLoadButton, &QPushButton::clicked, 
this, &QDialog::accept );
 
  151   connect( mDeleteButton, &QPushButton::clicked, 
this, &QgsMapLayerLoadStyleDialog::deleteStyleFromDB );
 
  152   connect( 
this, &QgsMapLayerLoadStyleDialog::rejected, [ = ]
 
  157   setTabOrder( mRelatedTable, mOthersTable );
 
  159   mStyleCategoriesListView->adjustSize();
 
  172     const QFileInfo fi( mFileWidget->filePath() );
 
  173     if ( fi.exists() && fi.suffix().compare( QStringLiteral( 
"sld" ), Qt::CaseInsensitive ) == 0 )
 
  181   return QFileInfo( mFileWidget->filePath() ).suffix();
 
  186   return mFileWidget->filePath();
 
  192   mSectionLimit = sectionLimit;
 
  193   const int relatedTableNOfCols = sectionLimit > 0 ? 2 : 1;
 
  194   const int othersTableNOfCols = ( sectionLimit >= 0 && ids.count() - sectionLimit > 0 ) ? 2 : 1;
 
  195   const QString twoColsHeader( QStringLiteral( 
"Name;Description" ) );
 
  196   const QString oneColsHeader( QStringLiteral( 
"No styles found in the database" ) );
 
  197   const QString relatedTableHeader = relatedTableNOfCols == 1 ? oneColsHeader : twoColsHeader;
 
  198   const QString othersTableHeader = othersTableNOfCols == 1 ? oneColsHeader : twoColsHeader;
 
  200   mRelatedTable->setColumnCount( relatedTableNOfCols );
 
  201   mOthersTable->setColumnCount( othersTableNOfCols );
 
  202   mRelatedTable->setHorizontalHeaderLabels( relatedTableHeader.split( 
';' ) );
 
  203   mOthersTable->setHorizontalHeaderLabels( othersTableHeader.split( 
';' ) );
 
  204   mRelatedTable->setRowCount( sectionLimit );
 
  205   mOthersTable->setRowCount( sectionLimit >= 0 ? ( ids.count() - sectionLimit ) : 0 );
 
  206   mRelatedTable->setDisabled( relatedTableNOfCols == 1 );
 
  207   mOthersTable->setDisabled( othersTableNOfCols == 1 );
 
  209   if ( sectionLimit >= 0 )
 
  211     for ( 
int i = 0; i < sectionLimit; i++ )
 
  213       QTableWidgetItem *item = 
new QTableWidgetItem( names.value( i, QString() ) );
 
  214       item->setData( Qt::UserRole, ids[i] );
 
  215       mRelatedTable->setItem( i, 0, item );
 
  216       mRelatedTable->setItem( i, 1, 
new QTableWidgetItem( descriptions.value( i, QString() ) ) );
 
  218     for ( 
int i = sectionLimit; i < ids.count(); i++ )
 
  220       const int j = i - sectionLimit;
 
  221       QTableWidgetItem *item = 
new QTableWidgetItem( names.value( i, QString() ) );
 
  222       item->setData( Qt::UserRole, ids[i] );
 
  223       mOthersTable->setItem( j, 0, item );
 
  224       mOthersTable->setItem( j, 1, 
new QTableWidgetItem( descriptions.value( i, QString() ) ) );
 
  231   return mSelectedStyleId;
 
  234 void QgsMapLayerLoadStyleDialog::onRelatedTableSelectionChanged()
 
  236   selectionChanged( mRelatedTable );
 
  237   if ( mRelatedTable->selectionModel()->hasSelection() )
 
  239     if ( mOthersTable->selectionModel()->hasSelection() )
 
  241       disconnect( mOthersTable->selectionModel(), &QItemSelectionModel::selectionChanged, 
this, &QgsMapLayerLoadStyleDialog::onOthersTableSelectionChanged );
 
  242       const QTableWidgetSelectionRange range( 0, 0, mOthersTable->rowCount() - 1, mOthersTable->columnCount() - 1 );
 
  243       mOthersTable->setRangeSelected( range, 
false );
 
  244       connect( mOthersTable->selectionModel(), &QItemSelectionModel::selectionChanged, 
this, &QgsMapLayerLoadStyleDialog::onOthersTableSelectionChanged );
 
  249 void QgsMapLayerLoadStyleDialog::onOthersTableSelectionChanged()
 
  251   selectionChanged( mOthersTable );
 
  252   if ( mOthersTable->selectionModel()->hasSelection() )
 
  254     if ( mRelatedTable->selectionModel()->hasSelection() )
 
  256       disconnect( mRelatedTable->selectionModel(), &QItemSelectionModel::selectionChanged, 
this, &QgsMapLayerLoadStyleDialog::onRelatedTableSelectionChanged );
 
  257       const QTableWidgetSelectionRange range( 0, 0, mRelatedTable->rowCount() - 1, mRelatedTable->columnCount() - 1 );
 
  258       mRelatedTable->setRangeSelected( range, 
false );
 
  259       connect( mRelatedTable->selectionModel(), &QItemSelectionModel::selectionChanged, 
this, &QgsMapLayerLoadStyleDialog::onRelatedTableSelectionChanged );
 
  264 void QgsMapLayerLoadStyleDialog::selectionChanged( QTableWidget *styleTable )
 
  266   QTableWidgetItem *item = 
nullptr;
 
  267   const QList<QTableWidgetItem *> selected = styleTable->selectedItems();
 
  269   if ( !selected.isEmpty() )
 
  271     item = selected.at( 0 );
 
  272     mSelectedStyleName = item->text();
 
  273     mSelectedStyleId = item->data( Qt::UserRole ).toString();
 
  274     mLoadButton->setEnabled( 
true );
 
  275     mDeleteButton->setEnabled( 
true );
 
  279     mSelectedStyleName.clear();
 
  280     mSelectedStyleId.clear();
 
  281     mLoadButton->setEnabled( 
false );
 
  282     mDeleteButton->setEnabled( 
false );
 
  285   updateLoadButtonState();
 
  296 void QgsMapLayerLoadStyleDialog::deleteStyleFromDB()
 
  303   const QString opInfo = QObject::tr( 
"Delete style %1 from %2" ).arg( mSelectedStyleName, mLayer->
providerType() );
 
  305   if ( QMessageBox::question( 
nullptr, QObject::tr( 
"Delete Style" ),
 
  306                               QObject::tr( 
"Are you sure you want to delete the style %1?" ).arg( mSelectedStyleName ),
 
  307                               QMessageBox::Yes | QMessageBox::No, QMessageBox::No ) != QMessageBox::Yes )
 
  311   if ( !msgError.isNull() )
 
  314     QMessageBox::warning( 
this, opInfo, tr( 
"%1: fail. %2" ).arg( opInfo, msgError ) );
 
  321     mRelatedTable->setRowCount( 0 );
 
  322     mOthersTable->setRowCount( 0 );
 
  326     QStringList ids, names, descriptions;
 
  329     if ( !errorMsg.isNull() )
 
  331       QMessageBox::warning( 
this, tr( 
"Error occurred while retrieving styles from database" ), errorMsg );
 
  340 void QgsMapLayerLoadStyleDialog::updateLoadButtonState()
 
  346                                && ( mRelatedTable->selectionModel()->hasSelection() || mOthersTable->selectionModel()->hasSelection()
 
  352     mLoadButton->setEnabled( !mFileWidget->filePath().isEmpty() );
 
  356 void QgsMapLayerLoadStyleDialog::showHelp()
 
  358   QgsHelp::openHelp( QStringLiteral( 
"introduction/general_tools.html#save-and-share-layer-properties" ) );
 
static QIcon getThemeIcon(const QString &name, const QColor &fillColor=QColor(), const QColor &strokeColor=QColor())
Helper to get a theme icon.
static QgsGui * instance()
Returns a pointer to the singleton instance.
static void enableAutoGeometryRestore(QWidget *widget, const QString &key=QString())
Register the widget to allow its position to be automatically saved and restored when open and closed...
static void openHelp(const QString &key)
Opens help topic for the given help key using default system web browser.
QgsMapLayer::StyleCategories styleCategories() const
Returns the list of selected style categories the user has opted to load.
void initializeLists(const QStringList &ids, const QStringList &names, const QStringList &descriptions, int sectionLimit)
Initialize list of database stored styles.
QString selectedStyleId()
Returns the ID of the selected database stored style.
QgsMapLayerLoadStyleDialog(QgsMapLayer *layer, QWidget *parent=nullptr)
Constructor for QgsMapLayerLoadStyleDialog, associated with the specified map layer.
QString filePath() const
Returns the full path to the selected layer style source file.
QString fileExtension() const
Returns the file extension for the selected layer style source file.
QgsVectorLayerProperties::StyleType currentStyleType() const
Returns the selected vector style type, for vector layers only.
Model for layer style categories.
void setCategories(QgsMapLayer::StyleCategories categories)
Reset the model data.
QgsMapLayer::StyleCategories categories() const
Returns the categories as defined in the model.
Base class for all map layer types.
QString providerType() const
Returns the provider type (provider key) for this layer.
This class is a composition of two QSettings instances:
T flagValue(const QString &key, const T &defaultValue, const Section section=NoSection)
Returns the setting value for a setting based on a flag.
void setFlagValue(const QString &key, const T &value, const Section section=NoSection)
Set the value of a setting based on a flag.
QVariant value(const QString &key, const QVariant &defaultValue=QVariant(), Section section=NoSection) const
Returns the value for setting key.
void setValue(const QString &key, const QVariant &value, QgsSettings::Section section=QgsSettings::NoSection)
Sets the value of setting key to value.
virtual QString storageType() const
Returns the permanent storage type for this layer as a friendly name.
virtual bool isDeleteStyleFromDatabaseSupported() const
It returns false by default.
Represents a vector layer which manages a vector based data sets.
virtual int listStylesInDatabase(QStringList &ids, QStringList &names, QStringList &descriptions, QString &msgError)
Lists all the style in db split into related to the layer and not related to.
QgsVectorDataProvider * dataProvider() FINAL
Returns the layer's data provider, it may be nullptr.
virtual bool deleteStyleFromDatabase(const QString &styleId, QString &msgError)
Deletes a style from the database.
@ PointCloudLayer
Added in 3.18.
@ VectorTileLayer
Added in 3.14.
@ AnnotationLayer
Contains freeform, georeferenced annotations. Added in QGIS 3.16.