by.belsoft.report.tools.actions
Class QueryAction

java.lang.Object
  |
  +--by.belsoft.report.tools.actions.ContextData
        |
        +--by.belsoft.report.tools.actions.QueryAction

public class QueryAction

extends ContextData

The class to work with queries

Author:

Ilya Kirillov

Constructor Summary

QueryAction()
Base constructor

Method Summary

void	add(ActionEvent ae) add sets add query mode
void	addCriteria(ActionEvent ae) addCriteria adds new criteria
void	delete(ActionEvent e) delete deletes current query
void	down(ActionEvent ae) down make down step in to fields
java.lang.String	getCfield() standard getter
java.util.ArrayList	getCfields() standard getter
java.lang.String[]	getComponentLocalValues(ActionEvent ae, java.lang.String name) getComponentLocalValues gets current values of component
java.lang.String	getCrecordtype() standard getter
java.util.ArrayList	getCrecordtypes() standard getter
java.lang.String	getCriteria() standard getter
java.util.ArrayList	getCriterias() standard getter
Query	getCurquery() standard getter
java.lang.String	getCurrentDataSource() standard getter
DataSource	getDatasource() getDatasource standard getter
java.util.ArrayList	getDataSources() standard getter
java.util.ArrayList	getDownStep(java.lang.String[] stf, java.util.ArrayList all) getDownStep makes down step in the select
java.util.ArrayList	getFieldsToAdd() standard getter
java.util.ArrayList	getFromFields() standard getter
java.lang.String	getMode() standard getter
java.lang.String	getName() standard getter
java.lang.String	getParamValue(ActionEvent ae) getParamValue gets first child param
Query	getQuery() standard getter
java.lang.String	getRelationfid() standard getter
java.util.ArrayList	getRelationFields() standard getter
java.lang.String	getRelationqid() standard getter
java.util.ArrayList	getSelectedTo() standard getter
java.util.ArrayList	getSortFields() standard getter
java.lang.String	getSorting(java.lang.String fieldname) getSorting sets sorting value
java.lang.String	getTable() standard getter
java.util.ArrayList	getTables() standard getter
java.lang.String	getTest() standard getter
java.util.ArrayList	getToFields() standard getter
DefaultTreeModel	getTree() getTree makes query tree
java.util.ArrayList	getUpStep(java.lang.String[] stf, java.util.ArrayList all) getUpStep makes up step in the select
boolean	getViewable(java.lang.String fieldname) getViewable checks display param of the field
java.lang.String	isViewable(ActionEvent ae) isViewable checks if viewable checkbox is marked
void	listenFrom(ActionEvent ae) listenFrom listens from fields
void	listenRemoveCriteria(ActionEvent ae) listenRemoveCriteria listens criteria to remove
void	listenSort(ActionEvent ae) listenSort listens fields to be sorted
void	listenSortFields(ValueChangeEvent vce) listenSortFields listens sort fields
void	listenSorting(ValueChangeEvent vce) listenSorting listens sorting type
void	listenTo(ActionEvent ae) listenTo listens to fields
void	listenToFields(ValueChangeEvent vce) listenToFields listens To fields on view state
void	listenUnsort(ActionEvent ae) listenUnsort listens fields to be excluded from sorting
void	listenViewable(ValueChangeEvent vce) listenViewable listens view state
Query	makeElement(Query q) makeElement makes result query
java.lang.String	makeSortBy(ActionEvent ae) makeSortBy listens sorting radio
DefaultMutableTreeNode	makeXMLTreeFromObject(DefaultMutableTreeNode to, java.util.ArrayList what) makeXMLTreeFromObject makes tree from container
void	save(ActionEvent ae) save saves current query
void	saveElement() saveElement saves query element
void	setCfield(java.lang.String cfield) standard setter
void	setCfields(ValueChangeEvent vce) setCfields sets fields with criterias
void	setCrecordtype(java.lang.String crecordtype) standard setter
void	setCrecordtypes(java.util.ArrayList crecordtypes) standard setter
void	setCriteria(java.lang.String criteria) standard setter
void	setCriterias(java.util.ArrayList criterias) standard setter
void	setCurquery(Query curquery) standard setter
void	setCurrentDataSource(java.lang.String currentDataSource) setCurrentDataSource standard setter
void	setDatasource(DataSource datasource) setDatasource standard setter
void	setDataSources(java.util.ArrayList dataSources) standard setter
void	setFieldsToAdd(java.util.ArrayList fieldsToAdd) standard setter
void	setFromFields(ValueChangeEvent vce) setFromFields sets from fields
void	setMode(java.lang.String mode) standard setter
void	setName(java.lang.String name) standard setter
void	setQuery(Query query) standard setter
void	setRelationCriteria(ValueChangeEvent vce) setRelationCriteria sets new relation criteria
void	setRelationfid(java.lang.String relationfid) standard setter
void	setRelationFields(java.util.ArrayList connectionFields) setRelationFields sets relation fields
void	setRelationqid(java.lang.String relationqid) standard setter
void	setSelectedTo(java.util.ArrayList selectedTo) standard setter
void	setSortFields(java.util.ArrayList sortFields) standard setter
void	setSorting(java.lang.String fieldname, java.lang.String value) setSorting sets sorting
void	setTable(java.lang.String table) standard setter
void	setTest(java.lang.String test) standard setter
void	setToFields(java.util.ArrayList toFields) setToFields sets fields into corresponding select
void	setViewable(java.lang.String fieldname, java.lang.String value) setViewable sets view state
void	sortDown(ActionEvent ae) sortDown make down step in sort fields
void	sortUp(ActionEvent ae) sortUp make up step in sor fields
void	subquery(ActionEvent ae) subquery sets subquery mode
void	testDataSource(ActionEvent e) testDataSource tests current datasource
void	up(ActionEvent ae) up make up step in to fields

Methods inherited from class by.belsoft.report.tools.actions.ContextData

getContext, getReportName, getRequest, getSession, setRefreshData

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

QueryAction

public QueryAction()

Base constructor

Method Detail

save

public void save(ActionEvent ae)

save saves current query

Parameters:

ae - ActionEvent event invoked

subquery

public void subquery(ActionEvent ae)

subquery sets subquery mode

Parameters:

ae - ActionEvent event invoked

add

public void add(ActionEvent ae)

add sets add query mode

Parameters:

ae - ActionEvent event invoked

delete

public void delete(ActionEvent e)

delete deletes current query

Parameters:

e - ActionEvent event invoked

getTree

public DefaultTreeModel getTree()

getTree makes query tree

Returns:

DefaultTreeModel the query tree

makeXMLTreeFromObject

public DefaultMutableTreeNode makeXMLTreeFromObject(DefaultMutableTreeNode to,
                                                    java.util.ArrayList what)

makeXMLTreeFromObject makes tree from container

Parameters:

to - DefaultMutableTreeNode the tree where to put data

what - ArrayList the arraylist of objects with

Returns:

DefaultMutableTreeNode the result tree

makeElement

public Query makeElement(Query q)

makeElement makes result query

Parameters:

q - Query query to be made

Returns:

Query the result query

saveElement

public void saveElement()

saveElement saves query element

makeSortBy

public java.lang.String makeSortBy(ActionEvent ae)

makeSortBy listens sorting radio

Parameters:

ae - ActionEvent event invoked

Returns:

String the string with sorting

testDataSource

public void testDataSource(ActionEvent e)

testDataSource tests current datasource

Parameters:

e - ActionEvent event invoked

getParamValue

public java.lang.String getParamValue(ActionEvent ae)

getParamValue gets first child param

Parameters:

ae - ActionEvent event invoked

Returns:

String the param value

setFromFields

public void setFromFields(ValueChangeEvent vce)

setFromFields sets from fields

Parameters:

vce - ValueChangeEvent event invoked by value changing

setRelationCriteria

public void setRelationCriteria(ValueChangeEvent vce)

setRelationCriteria sets new relation criteria

Parameters:

vce - ValueChangeEvent event invoked by value changing

getViewable

public boolean getViewable(java.lang.String fieldname)

getViewable checks display param of the field

Parameters:

fieldname - String the fieldname to check

Returns:

boolean the field view state

setViewable

public void setViewable(java.lang.String fieldname,
                        java.lang.String value)

setViewable sets view state

Parameters:

fieldname - String the fieldname tj set view state

value - String the new value

listenToFields

public void listenToFields(ValueChangeEvent vce)

listenToFields listens To fields on view state

Parameters:

vce - ValueChangeEvent event invoked by value changing

listenViewable

public void listenViewable(ValueChangeEvent vce)

listenViewable listens view state

Parameters:

vce - ValueChangeEvent event invoked by value changing

getSorting

public java.lang.String getSorting(java.lang.String fieldname)

getSorting sets sorting value

Parameters:

fieldname - String the field name

Returns:

String with sorting value

setSorting

public void setSorting(java.lang.String fieldname,
                       java.lang.String value)

setSorting sets sorting

Parameters:

fieldname - String the sorting field

value - String the sorting value

listenSortFields

public void listenSortFields(ValueChangeEvent vce)

listenSortFields listens sort fields

Parameters:

vce - ValueChangeEvent event invoked by value changing

listenSorting

public void listenSorting(ValueChangeEvent vce)

listenSorting listens sorting type

Parameters:

vce - ValueChangeEvent event invoked by value changing

setCfields

public void setCfields(ValueChangeEvent vce)

setCfields sets fields with criterias

Parameters:

vce - ValueChangeEvent event invoked by value changing

listenTo

public void listenTo(ActionEvent ae)

listenTo listens to fields

Parameters:

ae - ActionEvent event invoked

listenFrom

public void listenFrom(ActionEvent ae)

listenFrom listens from fields

Parameters:

ae - ActionEvent event invoked

listenSort

public void listenSort(ActionEvent ae)

listenSort listens fields to be sorted

Parameters:

ae - ActionEvent event invoked

listenUnsort

public void listenUnsort(ActionEvent ae)

listenUnsort listens fields to be excluded from sorting

Parameters:

ae - ActionEvent event invoked

getUpStep

public java.util.ArrayList getUpStep(java.lang.String[] stf,
                                     java.util.ArrayList all)

getUpStep makes up step in the select

Parameters:

stf - String[] the select current values

all - ArrayList with select items

Returns:

ArrayList with items updated

getDownStep

public java.util.ArrayList getDownStep(java.lang.String[] stf,
                                       java.util.ArrayList all)

getDownStep makes down step in the select

Parameters:

stf - String[] the select current values

all - ArrayList with select items

Returns:

ArrayList with items updated

up

public void up(ActionEvent ae)

up make up step in to fields

Parameters:

ae - ActionEvent event invoked

down

public void down(ActionEvent ae)

down make down step in to fields

Parameters:

ae - ActionEvent

sortUp

public void sortUp(ActionEvent ae)

sortUp make up step in sor fields

Parameters:

ae - ActionEvent event invoked

sortDown

public void sortDown(ActionEvent ae)

sortDown make down step in sort fields

Parameters:

ae - ActionEvent event invoked

isViewable

public java.lang.String isViewable(ActionEvent ae)

isViewable checks if viewable checkbox is marked

Parameters:

ae - ActionEvent event invoked

Returns:

String with checkbox value

getComponentLocalValues

public java.lang.String[] getComponentLocalValues(ActionEvent ae,
                                                  java.lang.String name)

getComponentLocalValues gets current values of component

Parameters:

ae - ActionEvent event invoked

name - String component name

Returns:

String[] array with values

listenRemoveCriteria

public void listenRemoveCriteria(ActionEvent ae)

listenRemoveCriteria listens criteria to remove

Parameters:

ae - ActionEvent event invoked

addCriteria

public void addCriteria(ActionEvent ae)

addCriteria adds new criteria

Parameters:

ae - ActionEvent event invoked

getTest

public java.lang.String getTest()

standard getter

Returns:

Returns the test.

setTest

public void setTest(java.lang.String test)

standard setter

Parameters:

test - The test to set.

getName

public java.lang.String getName()

standard getter

Returns:

Returns the name.

setName

public void setName(java.lang.String name)

standard setter

Parameters:

name - The name to set.

getFromFields

public java.util.ArrayList getFromFields()

standard getter

Returns:

Returns the fromFields.

getSortFields

public java.util.ArrayList getSortFields()

standard getter

Returns:

Returns the sortFields.

setSortFields

public void setSortFields(java.util.ArrayList sortFields)

standard setter

Parameters:

sortFields - The sortFields to set.

getToFields

public java.util.ArrayList getToFields()

standard getter

Returns:

Returns the toFields.

setToFields

public void setToFields(java.util.ArrayList toFields)

setToFields sets fields into corresponding select

Parameters:

toFields - ArrayList of fields to set

getCfield

public java.lang.String getCfield()

standard getter

Returns:

Returns the cfield.

setCfield

public void setCfield(java.lang.String cfield)

standard setter

Parameters:

cfield - The cfield to set.

getCrecordtype

public java.lang.String getCrecordtype()

standard getter

Returns:

Returns the crecordtype.

setCrecordtype

public void setCrecordtype(java.lang.String crecordtype)

standard setter

Parameters:

crecordtype - The crecordtype to set.

getCriteria

public java.lang.String getCriteria()

standard getter

Returns:

Returns the criteria.

setCriteria

public void setCriteria(java.lang.String criteria)

standard setter

Parameters:

criteria - The criteria to set.

getCriterias

public java.util.ArrayList getCriterias()

standard getter

Returns:

Returns the criterias.

getDataSources

public java.util.ArrayList getDataSources()

standard getter

Returns:

Returns the dataSources.

setDataSources

public void setDataSources(java.util.ArrayList dataSources)

standard setter

Parameters:

dataSources - The dataSources to set.

setCriterias

public void setCriterias(java.util.ArrayList criterias)

standard setter

Parameters:

criterias - The criterias to set.

getTable

public java.lang.String getTable()

standard getter

Returns:

Returns the table.

setTable

public void setTable(java.lang.String table)

standard setter

Parameters:

table - The table to set.

getTables

public java.util.ArrayList getTables()

standard getter

Returns:

Returns the tables.

getCfields

public java.util.ArrayList getCfields()

standard getter

Returns:

Returns the cfields.

getCrecordtypes

public java.util.ArrayList getCrecordtypes()

standard getter

Returns:

Returns the crecordtypes.

setCrecordtypes

public void setCrecordtypes(java.util.ArrayList crecordtypes)

standard setter

Parameters:

crecordtypes - The crecordtypes to set.

getQuery

public Query getQuery()

standard getter

Returns:

Returns the query.

setQuery

public void setQuery(Query query)

standard setter

Parameters:

query - The query to set.

getCurquery

public Query getCurquery()

standard getter

Returns:

Returns the curquery.

setCurquery

public void setCurquery(Query curquery)

standard setter

Parameters:

curquery - The curquery to set.

getMode

public java.lang.String getMode()

standard getter

Returns:

Returns the mode.

setMode

public void setMode(java.lang.String mode)

standard setter

Parameters:

mode - The mode to set.

getFieldsToAdd

public java.util.ArrayList getFieldsToAdd()

standard getter

Returns:

Returns the fieldsToAdd.

setFieldsToAdd

public void setFieldsToAdd(java.util.ArrayList fieldsToAdd)

standard setter

Parameters:

fieldsToAdd - The fieldsToAdd to set.

getRelationFields

public java.util.ArrayList getRelationFields()

standard getter

Returns:

Returns the connectionFields.

getRelationfid

public java.lang.String getRelationfid()

standard getter

Returns:

Returns the relationfid.

setRelationfid

public void setRelationfid(java.lang.String relationfid)

standard setter

Parameters:

relationfid - The relationfid to set.

getRelationqid

public java.lang.String getRelationqid()

standard getter

Returns:

Returns the relationqid.

setRelationqid

public void setRelationqid(java.lang.String relationqid)

standard setter

Parameters:

relationqid - The relationqid to set.

setRelationFields

public void setRelationFields(java.util.ArrayList connectionFields)

setRelationFields sets relation fields

Parameters:

connectionFields - ArrayList of fields to set

getSelectedTo

public java.util.ArrayList getSelectedTo()

standard getter

Returns:

Returns the selectedTo.

setSelectedTo

public void setSelectedTo(java.util.ArrayList selectedTo)

standard setter

Parameters:

selectedTo - The selectedTo to set.

getCurrentDataSource

public java.lang.String getCurrentDataSource()

standard getter

Returns:

Returns the drivers.

setCurrentDataSource

public void setCurrentDataSource(java.lang.String currentDataSource)

setCurrentDataSource standard setter

Parameters:

currentDataSource - String the current datasource to set

getDatasource

public DataSource getDatasource()

getDatasource standard getter

Returns:

DataSource the current datasource

setDatasource

public void setDatasource(DataSource datasource)

setDatasource standard setter

Parameters:

datasource - DataSource the current datasource