qgssearchquerybuilder.h

Go to the documentation of this file.

/***************************************************************************
    qgssearchquerybuilder.h  - Query builder for search strings
    ----------------------
    begin                : March 2006
    copyright            : (C) 2006 by Martin Dobias
    email                : wonder.sk at gmail dot com
 ***************************************************************************
 *                                                                         *
 *   This program is free software; you can redistribute it and/or modify  *
 *   it under the terms of the GNU General Public License as published by  *
 *   the Free Software Foundation; either version 2 of the License, or     *
 *   (at your option) any later version.                                   *
 *                                                                         *
 ***************************************************************************/

#ifndef QGSSEARCHQUERYBUILDER_H
#define QGSSEARCHQUERYBUILDER_H

#include <map>
#include <vector>
#include <QStandardItemModel>
#include <QModelIndex>

#include "ui_qgsquerybuilderbase.h"
#include "qgisgui.h"
#include "qgscontexthelp.h"

class QgsField;
class QgsVectorLayer;

class GUI_EXPORT QgsSearchQueryBuilder : public QDialog, private Ui::QgsQueryBuilderBase
{
    Q_OBJECT

  public:
    QgsSearchQueryBuilder( QgsVectorLayer* layer, QWidget *parent = nullptr,
                           const Qt::WindowFlags& fl = QgisGui::ModalDialogFlags );

    ~QgsSearchQueryBuilder();

    QString searchString();

    void setSearchString( const QString& searchString );

  public slots:
    void on_btnEqual_clicked();
    void on_btnOk_clicked();
    void on_btnLessThan_clicked();
    void on_btnGreaterThan_clicked();
    void on_btnLike_clicked();
    void on_btnILike_clicked();
    void on_btnPct_clicked();
    void on_btnIn_clicked();
    void on_btnNotIn_clicked();

    void on_lstFields_doubleClicked( const QModelIndex &index );
    void on_lstValues_doubleClicked( const QModelIndex &index );
    void on_btnLessEqual_clicked();
    void on_btnGreaterEqual_clicked();
    void on_btnNotEqual_clicked();
    void on_btnAnd_clicked();
    void on_btnNot_clicked();
    void on_btnOr_clicked();
    void on_btnClear_clicked();

    void on_btnTest_clicked();

    void on_btnGetAllValues_clicked();

    void on_btnSampleValues_clicked();

    void on_buttonBox_helpRequested() { QgsContextHelp::run( metaObject()->className() ); }

    void saveQuery();
    void loadQuery();

  private:

    void populateFields();
    void setupListViews();

    long countRecords( const QString& sql );

    void getFieldValues( int limit );

  private:

    QgsVectorLayer* mLayer;
    QMap<QString, int> mFieldMap;
    QStandardItemModel *mModelFields;
    QStandardItemModel *mModelValues;
};
#endif //QGSSEARCHQUERYBUILDER_H