API17

JTableNested: Difference between revisions

From Joomla! Documentation

Doxiki2 (talk | contribs)
Bots
18,905 edits
Bulk upload by Doxiki2
 
m preparing for archive only
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
__NOTOC__
__NOTOC__
<span class="editsection" style="font-size:76%;">
=={{JVer|11.1}} JTableNested==
<nowiki>[</nowiki>[[Description:JTableNested|Edit Descripton]]<nowiki>]</nowiki>
===Description===
</span>
JTableNested is a table class which supports modified pre-order [[wikipedia:tree traversal|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.
{{Description:JTableNested}}
 
===Defined in===
libraries/joomla/database/tablenested.php
===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|Other versions of this class]]
* {{JVer|11.1}} '''JTableNested source code''' on [[jplatform:database/tablenested.php|BitBucket]]
{{SeeAlso:JTableNested}}
* {{JVer|11.1}} Subpackage [[API17:Subpackage Database|Database]]
<span class="editsection" style="font-size:76%;">
* [[API17:JTableNested|Other versions of JTableNested]]
<nowiki>[</nowiki>[[SeeAlso:JTableNested|Edit See Also]]<nowiki>]</nowiki>
 
</span>
 
===Examples===
===User contributed notes===
<CodeExamplesForm />
=== Code Examples ===
<dpl>
<dpl>
noresultsheader=\n
noresultsheader=\n
category=JTableNested
category=JTableNested
category=CodeExample
namespace=CodeExample
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 03:49, 25 March 2017

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.

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


User contributed notes

Code Examples


Retrieved from "https://docs.sandbox.joomla.org/index.php?title=API17:JTableNested&oldid=386256"