Actions

API17

Difference between revisions of "JTableNested"

From Joomla! Documentation

(Layout updates)
m (moving preparation)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
 +
=={{JVer|11.1}} JTableNested==
 +
===Description===
 +
{{Description:JTableNested}}
 
<span class="editsection" style="font-size:76%;">
 
<span class="editsection" style="font-size:76%;">
 
<nowiki>[</nowiki>[[Description:JTableNested|Edit Descripton]]<nowiki>]</nowiki>
 
<nowiki>[</nowiki>[[Description:JTableNested|Edit Descripton]]<nowiki>]</nowiki>
 
</span>
 
</span>
{{Description:JTableNested}}
 
===Defined in===
 
libraries/joomla/database/tablenested.php
 
* see source code in [[jplatform:database/tablenested.php|BitBucket]]
 
===Subpackage===
 
[[Subpackage Database/11.1|Database]]
 
===Extends===
 
[[JTable/11.1|JTable]]
 
===Extended by===
 
* [[JTableAsset/11.1|JTableAsset]]
 
* [[JTableCategory/11.1|JTableCategory]]
 
* [[JTableMenu/11.1|JTableMenu]]
 
 
===Methods===
 
===Methods===
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"
 
|-
 
|-
 +
!Visibility
 
!Method name
 
!Method name
 
!Description
 
!Description
 
|-
 
|-
|[[JTableNested::check/11.1|check]]
+
|public
 +
|[[API17:JTableNested::check|check]]
 
|Asset that the nested set data is valid.  
 
|Asset that the nested set data is valid.  
 
|-
 
|-
|[[JTableNested::debug/11.1|debug]]
+
|public
 +
|[[API17:JTableNested::debug|debug]]
 
|Sets the debug level on or off.  
 
|Sets the debug level on or off.  
 
|-
 
|-
|[[JTableNested::delete/11.1|delete]]
+
|public
 +
|[[API17:JTableNested::delete|delete]]
 
|Method to delete a node, and optionally its child nodes, from the table.  
 
|Method to delete a node, and optionally its child nodes, from the table.  
 
|-
 
|-
|[[JTableNested::getPath/11.1|getPath]]
+
|public
 +
|[[API17:JTableNested::getPath|getPath]]
 
|Method to get an array of nodes from a given node to its root.  
 
|Method to get an array of nodes from a given node to its root.  
 
|-
 
|-
|[[JTableNested::getRootId/11.1|getRootId]]
+
|public
 +
|[[API17:JTableNested::getRootId|getRootId]]
 
|Gets the ID of the root item in the tree.  
 
|Gets the ID of the root item in the tree.  
 
|-
 
|-
|[[JTableNested::getTree/11.1|getTree]]
+
|public
 +
|[[API17:JTableNested::getTree|getTree]]
 
|Method to get a node and all its child nodes.  
 
|Method to get a node and all its child nodes.  
 
|-
 
|-
|[[JTableNested::isLeaf/11.1|isLeaf]]
+
|public
 +
|[[API17:JTableNested::isLeaf|isLeaf]]
 
|Method to determine if a node is a leaf node in the tree (has no children).  
 
|Method to determine if a node is a leaf node in the tree (has no children).  
 
|-
 
|-
|[[JTableNested::move/11.1|move]]
+
|public
 +
|[[API17:JTableNested::move|move]]
 
|Method to move a row in the ordering sequence of a group of rows defined by an SQL WHERE clause.  
 
|Method to move a row in the ordering sequence of a group of rows defined by an SQL WHERE clause.  
 
|-
 
|-
|[[JTableNested::moveByReference/11.1|moveByReference]]
+
|public
 +
|[[API17:JTableNested::moveByReference|moveByReference]]
 
|Method to move a node and its children to a new location in the tree.  
 
|Method to move a node and its children to a new location in the tree.  
 
|-
 
|-
|[[JTableNested::orderDown/11.1|orderDown]]
+
|public
 +
|[[API17:JTableNested::orderDown|orderDown]]
 
|Method to move a node one position to the right in the same level.  
 
|Method to move a node one position to the right in the same level.  
 
|-
 
|-
|[[JTableNested::orderUp/11.1|orderUp]]
+
|public
 +
|[[API17:JTableNested::orderUp|orderUp]]
 
|Method to move a node one position to the left in the same level.  
 
|Method to move a node one position to the left in the same level.  
 
|-
 
|-
|[[JTableNested::publish/11.1|publish]]
+
|public
 +
|[[API17:JTableNested::publish|publish]]
 
|Method to set the publishing state for a node or list of nodes in the database table.  
 
|Method to set the publishing state for a node or list of nodes in the database table.  
 
|-
 
|-
|[[JTableNested::rebuild/11.1|rebuild]]
+
|public
 +
|[[API17:JTableNested::rebuild|rebuild]]
 
|Method to recursively rebuild the whole nested set tree.  
 
|Method to recursively rebuild the whole nested set tree.  
 
|-
 
|-
|[[JTableNested::rebuildPath/11.1|rebuildPath]]
+
|public
 +
|[[API17:JTableNested::rebuildPath|rebuildPath]]
 
|Method to rebuild the node's path field from the alias values of the nodes from the current node to the root node of the tree.  
 
|Method to rebuild the node's path field from the alias values of the nodes from the current node to the root node of the tree.  
 
|-
 
|-
|[[JTableNested::saveorder/11.1|saveorder]]
+
|public
 +
|[[API17:JTableNested::saveorder|saveorder]]
 
|Method to update order of table rows.  
 
|Method to update order of table rows.  
 
|-
 
|-
|[[JTableNested::setLocation/11.1|setLocation]]
+
|public
 +
|[[API17:JTableNested::setLocation|setLocation]]
 
|Method to set the location of a node in the tree object.  
 
|Method to set the location of a node in the tree object.  
 
|-
 
|-
|[[JTableNested::store/11.1|store]]
+
|public
 +
|[[API17:JTableNested::store|store]]
 
|Method to store a node in the database table.  
 
|Method to store a node in the database table.  
 
|-
 
|-
|[[JTableNested::_getNode/11.1|_getNode]]
+
|protected
 +
|[[API17:JTableNested::_getNode|_getNode]]
 
|Method to get nested set properties for a node in the tree.  
 
|Method to get nested set properties for a node in the tree.  
 
|-
 
|-
|[[JTableNested::_getTreeRepositionData/11.1|_getTreeRepositionData]]
+
|protected
 +
|[[API17:JTableNested::_getTreeRepositionData|_getTreeRepositionData]]
 
|Method to get various data necessary to make room in the tree at a location for a node and its children.  
 
|Method to get various data necessary to make room in the tree at a location for a node and its children.  
 
|-
 
|-
|[[JTableNested::_logtable/11.1|_logtable]]
+
|protected
 +
|[[API17:JTableNested::_logtable|_logtable]]
 
|
 
|
 
|-
 
|-
|[[JTableNested::_runQuery/11.1|_runQuery]]
+
|protected
 +
|[[API17:JTableNested::_runQuery|_runQuery]]
 
|
 
|
 
|-
 
|-
 
|}
 
|}
 +
* '''Defined in''' libraries/joomla/database/tablenested.php
 +
* '''Extends''' [[API17:JTable|JTable]]
 +
* '''Extended by'''
 +
** [[API17:JTableAsset|JTableAsset]]
 +
** [[API17:JTableCategory|JTableCategory]]
 +
** [[API17:JTableMenu|JTableMenu]]
 
===Importing===
 
===Importing===
 
<source lang="php">jimport( 'joomla.database.tablenested' );</source>
 
<source lang="php">jimport( 'joomla.database.tablenested' );</source>
 
===See also===
 
===See also===
* JTableNested source code in [[jplatform:database/tablenested.php|BitBucket]]
+
* {{JVer|11.1}} '''JTableNested source code''' on [[jplatform:database/tablenested.php|BitBucket]]
* [[JTableNested|Other versions of this class]]
+
* {{JVer|11.1}} Subpackage [[API17:Subpackage Database|Database]]
 +
* [[API17:JTableNested|Other versions of JTableNested]]
 
{{SeeAlso:JTableNested}}
 
{{SeeAlso:JTableNested}}
 
<span class="editsection" style="font-size:76%;">
 
<span class="editsection" style="font-size:76%;">
 
<nowiki>[</nowiki>[[SeeAlso:JTableNested|Edit See Also]]<nowiki>]</nowiki>
 
<nowiki>[</nowiki>[[SeeAlso:JTableNested|Edit See Also]]<nowiki>]</nowiki>
 
</span>
 
</span>
===Examples===
+
===User contributed notes===
 
<CodeExamplesForm />
 
<CodeExamplesForm />
 
<dpl>
 
<dpl>
Line 102: Line 122:
 
category=ClassExample
 
category=ClassExample
 
include=*
 
include=*
 +
namespace=CodeExample
 
format= ,,,
 
format= ,,,
 
</dpl>
 
</dpl>
<noinclude>[[Category:Platform]][[Category:Platform 11.1]][[Category:JTableNested]]</noinclude>
+
<noinclude>[[Category:Platform 11.1]][[Category:Archived pages API17]]</noinclude>

Latest revision as of 21:41, 11 May 2013

Replacement filing cabinet.png
This Namespace has been archived - Please Do Not Edit or Create Pages in this namespace. Pages contain information for a Joomla! version which is no longer supported. It exists only as a historical reference, will not be improved and its content may be incomplete.

Joomla 11.1 JTableNested

Description

JTableNested is a table class which supports modified pre-order tree traversal behaviour. This class is derived from the base JTable class and adds methods to support a binary tree structure in the database, with pre-order being the preferred method of traversal. [Edit Descripton]

Methods

Visibility Method name Description
public check Asset that the nested set data is valid.
public debug Sets the debug level on or off.
public delete Method to delete a node, and optionally its child nodes, from the table.
public getPath Method to get an array of nodes from a given node to its root.
public getRootId Gets the ID of the root item in the tree.
public getTree Method to get a node and all its child nodes.
public isLeaf Method to determine if a node is a leaf node in the tree (has no children).
public move Method to move a row in the ordering sequence of a group of rows defined by an SQL WHERE clause.
public moveByReference Method to move a node and its children to a new location in the tree.
public orderDown Method to move a node one position to the right in the same level.
public orderUp Method to move a node one position to the left in the same level.
public publish Method to set the publishing state for a node or list of nodes in the database table.
public rebuild Method to recursively rebuild the whole nested set tree.
public rebuildPath Method to rebuild the node's path field from the alias values of the nodes from the current node to the root node of the tree.
public saveorder Method to update order of table rows.
public setLocation Method to set the location of a node in the tree object.
public store Method to store a node in the database table.
protected _getNode Method to get nested set properties for a node in the tree.
protected _getTreeRepositionData Method to get various data necessary to make room in the tree at a location for a node and its children.
protected _logtable
protected _runQuery

Importing

jimport( 'joomla.database.tablenested' );

See also

  • Joomla 11.1 JTableNested source code on BitBucket
  • Joomla 11.1 Subpackage Database
  • Other versions of JTableNested

SeeAlso:JTableNested [Edit See Also]

User contributed notes

<CodeExamplesForm />