×
This forum has been locked. Please submit new Feature Requests on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Nested Sets
Yonder Media
Nieuw lid
Posts: 7
9 jaren 10 maanden geleden #666
door Yonder Media
Nested Sets werd gestart door Yonder Media
Having used Component Creator quite extensively, one of the things I find myself having to make over and over again, are nested set models. For instance, Nested Sets are used in Joomla's native Category component, allowing n-tiered nesting of categories associated with other categories.
In the Table class, this requires changing it from JTable to JTableNested, and including code in the prepareTable function of the model class (an example is shown below:)
Additionally, then, this requires changes to the View classes and markup output, to correctly show entries as being nested within each other. For this, I've borrowed code from Joomla's Category Component to achieve this.
Whilst I can get this all to work, it would be a really cool feature to have this built-in to Component Creator!
In the Table class, this requires changing it from JTable to JTableNested, and including code in the prepareTable function of the model class (an example is shown below:)
protected function prepareTable($table)
{
jimport('joomla.filter.output');
$db = JFactory::getDbo();
// Specify where to insert the new node.
$parent = @$table->parent_id;
if (!empty($parent))
{
$table->setLocation($parent, 'last-child');
}
else
{
$rootId = $table->getRootId();
if ($rootId === false)
{
$db = JFactory::getDbo();
$sql = 'INSERT INTO #__yomo_ussd_article_category'
. ' SET parent_id = 0'
. ', lft = 0'
. ', rgt = 1'
. ', level = 0'
. ', title = '.$db->quote('root')
. ', alias = '.$db->quote('root')
. ', access = 1'
. ', path = '.$db->quote('')
;
$db->setQuery($sql);
$db->query();
$parent = $db->insertid();
$table->setLocation($parent, 'last-child');
}
else
{
$table->setLocation($rootId, 'last-child');
}
}
# Check that the node data is valid.
$table->check();
# Store the node in the database table.
$table->store();
}
Additionally, then, this requires changes to the View classes and markup output, to correctly show entries as being nested within each other. For this, I've borrowed code from Joomla's Category Component to achieve this.
Whilst I can get this all to work, it would be a really cool feature to have this built-in to Component Creator!
Gelieve Inloggen of een account aanmaken om deel te nemen aan het gesprek.
RIP Graphics
Nieuw lid
Posts: 16
9 jaren 9 maanden geleden #667
door RIP Graphics
Beantwoord door RIP Graphics in topic Nested Sets
+1
Gelieve Inloggen of een account aanmaken om deel te nemen aan het gesprek.
Pete
Junior Lid
Posts: 27
9 jaren 9 maanden geleden #700
door Pete
Beantwoord door Pete in topic Nested Sets
+1
Gelieve Inloggen of een account aanmaken om deel te nemen aan het gesprek.
Søren Beck Jensen
Administrator
Posts: 81
9 jaren 8 maanden geleden #771
door Søren Beck Jensen
Søren Beck Jensen
Founder, Component-Creator.com
Beantwoord door Søren Beck Jensen in topic Nested Sets
Please note that this relates only to nested sets of custom tables. You can always use the Joomla Category field and create as many nested categories you would like.
Thanks to Brian Teeman for pointing this out.
Thanks to Brian Teeman for pointing this out.
Søren Beck Jensen
Founder, Component-Creator.com
Gelieve Inloggen of een account aanmaken om deel te nemen aan het gesprek.
Ilya Protasov
Nieuw lid
Posts: 9
9 jaren 5 maanden geleden #876
door Ilya Protasov
Beantwoord door Ilya Protasov in topic Nested Sets
+1
Gelieve Inloggen of een account aanmaken om deel te nemen aan het gesprek.
Jesper
Nieuw lid
Posts: 6
9 jaren 5 maanden geleden #883
door Jesper
Beantwoord door Jesper in topic Nested Sets
+1 as i sit and could use this right now for something i have to build
Gelieve Inloggen of een account aanmaken om deel te nemen aan het gesprek.
Tijd voor maken pagina: 0.056 seconden