Public Member Functions | Protected Member Functions | Protected Attributes

ajaxListComponent Class Reference

Inheritance diagram for ajaxListComponent:
Collaboration diagram for ajaxListComponent:

List of all members.

Public Member Functions

 init ($aColumns=null)
 getColumns ()
 setColumns ($aColumns)
 setName ($sName)
 processRequest ($sFunction=null)
 resetArtSeoUrl ($aArtIds, $aCatIds=null)
 resetContentCache ()
 resetCounter ($sCounterType, $sValue=null)

Protected Member Functions

 _getActionIds ($sId)
 _getQuery ()
 _getDataQuery ($sQ)
 _getCountQuery ($sQ)
 _getSortCol ()
 _getColNames ($sId=null)
 _getIdentColNames ()
 _getVisibleColNames ()
 _getQueryCols ()
 _buildColsQuery ($aIdentCols, $blIdentCols=true)
 _isExtendedColumn ($sColumn)
 _getExtendedColQuery ($sViewTable, $sColumn, $iCnt)
 _getSorting ()
 _getLimit ($iStart)
 _getFilter ()
 _addFilter ($sQ)
 _getAll ($sQ)
 _getSortDir ()
 _getStartIndex ()
 _getTotalCount ($sQ)
 _getDataFields ($sQ)
 _outputResponse ($aData)
 _output ($sOut)
 _getViewName ($sTable)
 _getData ($sCountQ, $sQ)

Protected Attributes

 $_aPosDir = array( 'asc', 'desc' )
 $_aColumns = array()
 $_iSqlLimit = 2500
 $_sContainer = null
 $_blAllowExtColumns = false

Detailed Description

AJAX call processor class

Definition at line 7 of file ajaxlistcomponent.php.

Member Function Documentation

ajaxListComponent._addFilter ( $  sQ  )  [protected]

Adds filter SQL to current query

Parameters:
string $sQ query to add filter condition
Returns:
string

Reimplemented in actions_article_ajax, actions_main_ajax, article_bundle_ajax, attribute_main_ajax, category_main_ajax, manufacturer_main_ajax, and vendor_main_ajax.

Definition at line 416 of file ajaxlistcomponent.php.

ajaxListComponent._buildColsQuery ( $  aIdentCols,
$  blIdentCols = true 
) [protected]

Builds column selection query

Parameters:
array $aIdentCols columns
bool $blIdentCols if true, means ident columns part is build
Returns:
string

Definition at line 280 of file ajaxlistcomponent.php.

ajaxListComponent._getActionIds ( $  sId  )  [protected]

Required data fields are returned by indexes/position in _aColumns array. This method translates "table_name.col_name" into index definition and fetches request data according to it. This is usefull while using AJAX across versions.

Parameters:
string $sId "table_name.col_name"
Returns:
array

Definition at line 92 of file ajaxlistcomponent.php.

ajaxListComponent._getAll ( $  sQ  )  [protected]

Returns DB records as plain indexed array

Parameters:
string $sQ SQL query
Returns:
array

Definition at line 431 of file ajaxlistcomponent.php.

ajaxListComponent._getColNames ( $  sId = null  )  [protected]

Returns array of cotainer DB cols which must be loaded. If id is not passed - all possible containers cols will be returned

Parameters:
string $sId container id (optional)
Returns:
array

Definition at line 196 of file ajaxlistcomponent.php.

ajaxListComponent._getCountQuery ( $  sQ  )  [protected]

Return fully formatted query for data records count

Parameters:
string $sQ part of initial query
Returns:
string

Definition at line 143 of file ajaxlistcomponent.php.

ajaxListComponent._getData ( $  sCountQ,
$  sQ 
) [protected]

Formats data array which later will be processed by _outputResponse method

Parameters:
string $sCountQ count query
string $sQ data load query
Returns:
array

Reimplemented in statistic_main_ajax.

Definition at line 557 of file ajaxlistcomponent.php.

ajaxListComponent._getDataFields ( $  sQ  )  [protected]

Returns array with DB records

Parameters:
string $sQ SQL query
Returns:
array

Reimplemented in article_extend_ajax.

Definition at line 494 of file ajaxlistcomponent.php.

ajaxListComponent._getDataQuery ( $  sQ  )  [protected]

Return fully formatted query for data loading

Parameters:
string $sQ part of initial query
Returns:
string

Definition at line 131 of file ajaxlistcomponent.php.

ajaxListComponent._getExtendedColQuery ( $  sViewTable,
$  sColumn,
$  iCnt 
) [protected]

Returns extended query part for given view/column combination (if variants must be shown in lists and column name is "oxtitle")

Parameters:
string $sViewTable view name
string $sColumn column name
int $iCnt column count
Returns:
string

Definition at line 327 of file ajaxlistcomponent.php.

ajaxListComponent._getFilter (  )  [protected]

Returns part of SQL query for filtering DB data

Returns:
string

Definition at line 364 of file ajaxlistcomponent.php.

ajaxListComponent._getIdentColNames (  )  [protected]

Returns array of identifiers which are used as identifiers for specific actions in AJAX and further in this processor class

Returns:
array

Definition at line 215 of file ajaxlistcomponent.php.

ajaxListComponent._getLimit ( $  iStart  )  [protected]

Returns part of SQL query for limiting number of entries from DB

Parameters:
int $iStart start position
Returns:
string

Definition at line 351 of file ajaxlistcomponent.php.

ajaxListComponent._getQuery (  )  [protected]

Empty function, developer should override this method according requirements

Returns:
string

Reimplemented in actions_article_ajax, actions_groups_ajax, actions_main_ajax, actions_order_ajax, article_accessories_ajax, article_attribute_ajax, article_bundle_ajax, article_crossselling_ajax, article_extend_ajax, article_selection_ajax, attribute_category_ajax, attribute_main_ajax, attribute_order_ajax, category_main_ajax, category_order_ajax, delivery_articles_ajax, delivery_categories_ajax, delivery_groups_ajax, delivery_main_ajax, delivery_users_ajax, deliveryset_country_ajax, deliveryset_groups_ajax, deliveryset_main_ajax, deliveryset_payment_ajax, deliveryset_users_ajax, discount_articles_ajax, discount_categories_ajax, discount_groups_ajax, discount_item_ajax, discount_main_ajax, discount_users_ajax, manufacturer_main_ajax, news_main_ajax, newsletter_selection_ajax, payment_country_ajax, payment_main_ajax, selectlist_main_ajax, selectlist_order_ajax, shop_default_category_ajax, user_main_ajax, usergroup_main_ajax, vendor_main_ajax, and voucherserie_groups_ajax.

Definition at line 119 of file ajaxlistcomponent.php.

ajaxListComponent._getQueryCols (  )  [protected]

Formats and returns chunk of SQL query string with definition of fields to load from DB

Returns:
string

Reimplemented in discount_item_ajax.

Definition at line 264 of file ajaxlistcomponent.php.

ajaxListComponent._getSortCol (  )  [protected]

Returns column id to sort

Returns:
int

Definition at line 177 of file ajaxlistcomponent.php.

ajaxListComponent._getSortDir (  )  [protected]

Checks user input and returns SQL sorting direction key

Returns:
string

Definition at line 449 of file ajaxlistcomponent.php.

ajaxListComponent._getSorting (  )  [protected]

Formats and returns part of SQL query for sorting

Returns:
string

Reimplemented in actions_main_ajax, actions_order_ajax, attribute_order_ajax, category_order_ajax, and selectlist_order_ajax.

Definition at line 339 of file ajaxlistcomponent.php.

ajaxListComponent._getStartIndex (  )  [protected]

Returns position from where data must be loaded

Returns:
int

Definition at line 464 of file ajaxlistcomponent.php.

ajaxListComponent._getTotalCount ( $  sQ  )  [protected]

Returns amount of records which can be found according to passed SQL query

Parameters:
string $sQ SQL query
Returns:
int

Definition at line 476 of file ajaxlistcomponent.php.

ajaxListComponent._getViewName ( $  sTable  )  [protected]

Return the view name of the given table if a view exists, otherwise the table name itself

Parameters:
string $sTable table name
Returns:
string

Definition at line 544 of file ajaxlistcomponent.php.

ajaxListComponent._getVisibleColNames (  )  [protected]

Returns array of col names which are requested by AJAX call and will be fetched from DB

Returns:
array

Definition at line 231 of file ajaxlistcomponent.php.

ajaxListComponent._isExtendedColumn ( $  sColumn  )  [protected]

Checks if current column is extended (currently checks if variants must be shown in lists and column name is "oxtitle")

Parameters:
string $sColumn column name
Returns:
bool

Definition at line 307 of file ajaxlistcomponent.php.

ajaxListComponent._output ( $  sOut  )  [protected]

Echoes given string

Parameters:
string $sOut string to echo
Returns:
null

Definition at line 532 of file ajaxlistcomponent.php.

ajaxListComponent._outputResponse ( $  aData  )  [protected]

Outputs JSON encoded data

Parameters:
array $aData data to output
Returns:
null

Definition at line 506 of file ajaxlistcomponent.php.

ajaxListComponent.getColumns (  ) 

Gets columns array.

Returns:
array

Definition at line 66 of file ajaxlistcomponent.php.

ajaxListComponent.init ( $  aColumns = null  ) 

Initializes AJAX columns.

Parameters:
array $aColumns Array of DB table columns which are loaded from DB.
Deprecated:
since v5.1.1 (2013.10.24); must be replaced with setColumns if needed
Returns:
null

Definition at line 54 of file ajaxlistcomponent.php.

ajaxListComponent.processRequest ( $  sFunction = null  ) 

AJAX call processor function

Parameters:
string $sFunction name of action to execute (optional)
Returns:
null

Definition at line 155 of file ajaxlistcomponent.php.

ajaxListComponent.resetArtSeoUrl ( $  aArtIds,
$  aCatIds = null 
)

Marks article seo url as expired

Parameters:
array $aArtIds article id's
array $aCatIds ids if categories, which must be removed from oxseo
Returns:
null

Definition at line 598 of file ajaxlistcomponent.php.

ajaxListComponent.resetContentCache (  ) 

Reset output cache

Returns:
null

Definition at line 634 of file ajaxlistcomponent.php.

ajaxListComponent.resetCounter ( $  sCounterType,
$  sValue = null 
)

Resets counters values from cache. Resets price category articles, category articles, vendor articles, manufacturer articles count.

Parameters:
string $sCounterType counter type
string $sValue reset value
Returns:
null

Definition at line 653 of file ajaxlistcomponent.php.

ajaxListComponent.setColumns ( $  aColumns  ) 

Sets columns array.

Parameters:
array $aColumns columns array
Returns:
null

Definition at line 78 of file ajaxlistcomponent.php.

ajaxListComponent.setName ( $  sName  ) 

AJAX container name setter

Parameters:
string $sName name of container
Returns:
null

Definition at line 109 of file ajaxlistcomponent.php.

Member Data Documentation

ajaxListComponent.$_aColumns = array() [protected]

Reimplemented in actions_article_ajax, actions_groups_ajax, actions_main_ajax, actions_order_ajax, article_accessories_ajax, article_attribute_ajax, article_bundle_ajax, article_crossselling_ajax, article_extend_ajax, article_selection_ajax, attribute_category_ajax, attribute_main_ajax, attribute_order_ajax, category_main_ajax, category_order_ajax, delivery_articles_ajax, delivery_categories_ajax, delivery_groups_ajax, delivery_main_ajax, delivery_users_ajax, deliveryset_country_ajax, deliveryset_groups_ajax, deliveryset_main_ajax, deliveryset_payment_ajax, deliveryset_users_ajax, discount_articles_ajax, discount_categories_ajax, discount_groups_ajax, discount_item_ajax, discount_main_ajax, discount_users_ajax, manufacturer_main_ajax, news_main_ajax, newsletter_selection_ajax, payment_country_ajax, payment_main_ajax, selectlist_main_ajax, selectlist_order_ajax, shop_default_category_ajax, statistic_main_ajax, user_main_ajax, usergroup_main_ajax, vendor_main_ajax, and voucherserie_groups_ajax.

Definition at line 21 of file ajaxlistcomponent.php.

ajaxListComponent.$_aPosDir = array( 'asc', 'desc' ) [protected]

Definition at line 14 of file ajaxlistcomponent.php.

ajaxListComponent.$_blAllowExtColumns = false [protected]

Reimplemented in actions_article_ajax, actions_main_ajax, article_accessories_ajax, article_bundle_ajax, article_crossselling_ajax, attribute_main_ajax, category_main_ajax, delivery_articles_ajax, discount_articles_ajax, manufacturer_main_ajax, selectlist_main_ajax, and vendor_main_ajax.

Definition at line 43 of file ajaxlistcomponent.php.

ajaxListComponent.$_iSqlLimit = 2500 [protected]

Definition at line 28 of file ajaxlistcomponent.php.

ajaxListComponent.$_sContainer = null [protected]

Definition at line 35 of file ajaxlistcomponent.php.

The documentation for this class was generated from the following file:
Generated by  doxygen 1.7.1