Content creation and ordering

[pelloq1]

Hello,

I have created a custom component, that use backend listings (extends from JModelList). Exactly like the core joomla com_content, my extension store a list of items.

My items are chapters of a documentation imported books (a lot of books and chapters), the structure is like:

Code: Select all

 0. Book title 
 1 title 
 1.1 title
 1.2 title
 .... More than 5000 records. 

And each record have several 'core' supported field, like state, Id, title, content and ordering, and some custom fields like Id_parent, name, content, short_content, ...

All is fine... Until one book as been modified by its author, and have new chapters.

Now in the backend listing. I added a button to each line named 'insert child article'. This button il like the 'new' button, except it pass 2 custom values in the url to prefill the parent_id field, and the current ordering.

All is fine, I can create child item.

BUT, now my problem is the ordering. I want that the new inserted item, goes not at end of listing (ordering = getMaxOrder()..), but to the next ordering number just after the line from where I created this child.

Sample:

Code: Select all

 23.4 Title abc (ordering 3456) [insert child]
 23.5 Title xyz (ordering 3457) [insert child]

Now I need a new chapter 23.4.1, with ordering 2357, and the 23.5 become 2358, and all next items will shift +1.

Is there an easy way to do this with the joomla api?

I hope it's clear to understand ...

Thanks you, Cédric

[itoctopus]

If you have child items, then you will need to develop a concept like that of the #__assets table, where you have the lft and rgt (left and right) fields. Check the #__assets table on what these fields mean, and avoid the temptation to store your data there as an inflated #__assets table can seriously impact the performance of your website.

[pelloq1]

Thanks you, my database structure and he application are already running, I cannot change now the database structure ...

Did you do not have another solution?

[pelloq1]

I found this about left and right, but as said I cannot change the structure.
http://mikehillyer.com/articles/managin ... -in-mysql/

[pelloq1]

Currently I found a (poor) workaround.

In the dedicated table extens JTable, in the check function I set manually the ordering value (based on the parent or the borther), and at next manual reordering, joomla reorder all.