ElementQueryWidget Class Reference

The ElementQueryWidget class A widget use to edit a sql query for get element information This widget only work to get information from ProjectDataBase. More...

#include <elementquerywidget.h>

Inherits QWidget.

Collaboration diagram for ElementQueryWidget:

Public Member Functions
	ElementQueryWidget (QWidget *parent=nullptr)
	ElementQueryWidget::ElementQueryWidget. More...
	~ElementQueryWidget ()
	ElementQueryWidget::~ElementQueryWidget. More...
void	setQuery (const QString &query)
	ElementQueryWidget::setQuery. More...
QString	queryStr () const
	ElementQueryWidget::queryStr. More...
void	setGroupBy (QString text, bool set=true)
	ElementQueryWidget::setGroupBy Add the query instruction GROUP BY. More...
void	setCount (QString text, bool set=true)
	ElementQueryWidget::setCount Add the query instruction COUNT. Unlike setGroupBy, you have to write the entire sentance. ex : text = "COUNT(*) AS designation_qty". the query will contain what you write. More...

Static Public Member Functions
static QString	modelIdentifier ()

Private Slots
void	on_m_up_pb_clicked ()
	ElementQueryWidget::on_m_up_pb_clicked. More...
void	on_m_add_pb_clicked ()
	ElementQueryWidget::on_m_add_pb_clicked. More...
void	on_m_remove_pb_clicked ()
	ElementQueryWidget::on_m_remove_pb_clicked. More...
void	on_m_down_pb_clicked ()
	ElementQueryWidget::on_m_down_pb_clicked. More...
void	on_m_edit_sql_query_cb_clicked ()
	ElementQueryWidget::on_m_edit_sql_query_cb_clicked. More...
void	on_m_filter_le_textEdited (const QString &arg1)
	ElementQueryWidget::on_m_filter_le_textEdited. More...
void	on_m_filter_type_cb_activated (int index)
	ElementQueryWidget::on_m_filter_type_cb_activated. More...
void	on_m_load_pb_clicked ()
	ElementQueryWidget::on_m_load_pb_clicked Load a query from nomenclature.json file. More...
void	on_m_save_current_conf_pb_clicked ()
	ElementQueryWidget::on_m_save_current_conf_pb_clicked Save the actual query to nomenclature.json file. More...
void	on_m_save_name_le_textChanged (const QString &arg1)
void	on_m_choosen_list_currentItemChanged (QListWidgetItem *current, QListWidgetItem *previous)
void	on_m_var_list_itemDoubleClicked (QListWidgetItem *item)
void	on_m_choosen_list_itemDoubleClicked (QListWidgetItem *item)
void	updateQueryLine ()
	ElementQueryWidget::updateQueryLine. More...
QStringList	selectedKeys () const
	ElementQueryWidget::selectedKeys. More...
void	setUpItems ()
	ElementQueryWidget::setUpItems. More...
QPair< int, QString >	FilterFor (const QString &key) const
	ElementQueryWidget::FilterFor. More...
void	fillSavedQuery ()
	ElementQueryWidget::fillSavedQuery Fill the combobox of saved queries. More...
void	reset ()
	ElementQueryWidget::reset Clear this widget aka set to initial state. More...

Private Attributes
Ui::ElementQueryWidget *	ui
QHash< QString, QString >	m_export_info
QButtonGroup	m_button_group
QList< QListWidgetItem * >	m_items_list
QString	m_custom_query
QString	m_group_by
QString	m_count
QHash< QString, QPair< int, QString > >	m_filter

Detailed Description

The ElementQueryWidget class A widget use to edit a sql query for get element information This widget only work to get information from ProjectDataBase.

Constructor & Destructor Documentation

ElementQueryWidget()

ElementQueryWidget::ElementQueryWidget ( QWidget *  parent = nullptr )

explicit

ElementQueryWidget::ElementQueryWidget.

Parameters

parent

Here is the call graph for this function:

~ElementQueryWidget()

ElementQueryWidget::~ElementQueryWidget

(

)

ElementQueryWidget::~ElementQueryWidget.

Member Function Documentation

fillSavedQuery

void ElementQueryWidget::fillSavedQuery ( )

privateslot

ElementQueryWidget::fillSavedQuery Fill the combobox of saved queries.

Here is the call graph for this function:

FilterFor

QPair< int, QString > ElementQueryWidget::FilterFor ( const QString &  key ) const

privateslot

ElementQueryWidget::FilterFor.

Parameters

key

Returns

the filter associated to key

Here is the caller graph for this function:

modelIdentifier()

static QString ElementQueryWidget::modelIdentifier ( )

inlinestatic

on_m_add_pb_clicked

void ElementQueryWidget::on_m_add_pb_clicked ( )

privateslot

ElementQueryWidget::on_m_add_pb_clicked.

Here is the call graph for this function:

Here is the caller graph for this function:

on_m_choosen_list_currentItemChanged

void ElementQueryWidget::on_m_choosen_list_currentItemChanged ( QListWidgetItem *  current, QListWidgetItem *  previous  )

privateslot

Here is the call graph for this function:

on_m_choosen_list_itemDoubleClicked

void ElementQueryWidget::on_m_choosen_list_itemDoubleClicked ( QListWidgetItem *  item )

privateslot

Here is the call graph for this function:

on_m_down_pb_clicked

void ElementQueryWidget::on_m_down_pb_clicked ( )

privateslot

ElementQueryWidget::on_m_down_pb_clicked.

Here is the call graph for this function:

on_m_edit_sql_query_cb_clicked

void ElementQueryWidget::on_m_edit_sql_query_cb_clicked ( )

privateslot

ElementQueryWidget::on_m_edit_sql_query_cb_clicked.

Here is the call graph for this function:

on_m_filter_le_textEdited

void ElementQueryWidget::on_m_filter_le_textEdited ( const QString &  arg1 )

privateslot

ElementQueryWidget::on_m_filter_le_textEdited.

Parameters

arg1

Here is the call graph for this function:

on_m_filter_type_cb_activated

void ElementQueryWidget::on_m_filter_type_cb_activated ( int  index )

privateslot

ElementQueryWidget::on_m_filter_type_cb_activated.

Parameters

index

Here is the call graph for this function:

on_m_load_pb_clicked

void ElementQueryWidget::on_m_load_pb_clicked ( )

privateslot

ElementQueryWidget::on_m_load_pb_clicked Load a query from nomenclature.json file.

Here is the call graph for this function:

on_m_remove_pb_clicked

void ElementQueryWidget::on_m_remove_pb_clicked ( )

privateslot

ElementQueryWidget::on_m_remove_pb_clicked.

Here is the call graph for this function:

Here is the caller graph for this function:

on_m_save_current_conf_pb_clicked

void ElementQueryWidget::on_m_save_current_conf_pb_clicked ( )

privateslot

ElementQueryWidget::on_m_save_current_conf_pb_clicked Save the actual query to nomenclature.json file.

Here is the call graph for this function:

on_m_save_name_le_textChanged

void ElementQueryWidget::on_m_save_name_le_textChanged ( const QString &  arg1 )

privateslot

on_m_up_pb_clicked

void ElementQueryWidget::on_m_up_pb_clicked ( )

privateslot

ElementQueryWidget::on_m_up_pb_clicked.

Here is the call graph for this function:

on_m_var_list_itemDoubleClicked

void ElementQueryWidget::on_m_var_list_itemDoubleClicked ( QListWidgetItem *  item )

privateslot

Here is the call graph for this function:

queryStr()

QString ElementQueryWidget::queryStr

(

)

const

ElementQueryWidget::queryStr.

Returns

The current query

Here is the call graph for this function:

Here is the caller graph for this function:

reset

void ElementQueryWidget::reset ( )

privateslot

ElementQueryWidget::reset Clear this widget aka set to initial state.

Here is the caller graph for this function:

selectedKeys

QStringList ElementQueryWidget::selectedKeys ( ) const

privateslot

ElementQueryWidget::selectedKeys.

Returns

the current keys of selected infos to be exported

Here is the caller graph for this function:

setCount()

void ElementQueryWidget::setCount	(	QString	text,
		bool	set = true
	)

ElementQueryWidget::setCount Add the query instruction COUNT. Unlike setGroupBy, you have to write the entire sentance. ex : text = "COUNT(*) AS designation_qty". the query will contain what you write.

Parameters

text	: the count instruction
set	: true by default -> count will be used. false -> count will be not used.

Here is the call graph for this function:

Here is the caller graph for this function:

setGroupBy()

void ElementQueryWidget::setGroupBy	(	QString	text,
		bool	set = true
	)

ElementQueryWidget::setGroupBy Add the query instruction GROUP BY.

Parameters

text	: the text of the GROUP BY instruction: ex : if text = designation, the query will contain "GROUP BY designation"
set	: true by default -> GROUP BY will be used. false -> GROUP BY will be not used

Here is the call graph for this function:

Here is the caller graph for this function:

setQuery()

void ElementQueryWidget::setQuery

(

const QString &

query

)

ElementQueryWidget::setQuery.

Parameters

query

Set the current query to query. If it's possible, rebuild the state of the widget from the query

Here is the call graph for this function:

Here is the caller graph for this function:

setUpItems

void ElementQueryWidget::setUpItems ( )

privateslot

ElementQueryWidget::setUpItems.

Here is the call graph for this function:

updateQueryLine

void ElementQueryWidget::updateQueryLine ( )

privateslot

ElementQueryWidget::updateQueryLine.

Here is the call graph for this function:

Here is the caller graph for this function:

Member Data Documentation

m_button_group

QButtonGroup ElementQueryWidget::m_button_group

private

m_count

QString ElementQueryWidget::m_count

private

m_custom_query

QString ElementQueryWidget::m_custom_query

private

m_export_info

QHash<QString, QString> ElementQueryWidget::m_export_info

private

m_filter

QHash<QString, QPair<int, QString> > ElementQueryWidget::m_filter

private

m_group_by

QString ElementQueryWidget::m_group_by

private

m_items_list

QList<QListWidgetItem *> ElementQueryWidget::m_items_list

private

ui

Ui::ElementQueryWidget* ElementQueryWidget::ui

private

---

The documentation for this class was generated from the following files:

• sources/dataBase/ui/elementquerywidget.h
• sources/dataBase/ui/elementquerywidget.cpp