On Jun 2, 12:18 am, Jeremy Burns <[email protected]> wrote: > You mention tree behaviour but I don't see any parent, left or right fields.
I haven't implemented this (yet) with Tree. I mentioned it because this is how I've done it in the past. But, in this case I can't see how to use it because, normally, everything in the DB table would be a single tree. In this case, I've got to have several separate lists (trees), one for each DocumentSection. > Just want to clarify a few things...are these accurate statements? > > - A section has many documents yes > - The order is (i) section then (ii) documents within the section yes > - The document order is not based on the name of the document The client wishes to be able to re-order the documents within a given section. > If so, wouldn't a 'sort_order' column in the documents table fix this? If so, > the order becomes (i) section.name (ii) document.sort_order. Perhaps, but I can't see how that could be implemented, nor how I'd change the order. Here's a concrete example: section_1 document_a document_b document_c document_d section_2 document_e document_f document_g The client wishes to change them to look like: section_1 document_a document_c document_d document_b section_2 document_g document_e document_f I can't figure out how I would do this using Tree Behavior, as I've done in the past. A sort_order column might do the trick but I'm having some trouble wrapping my head around that. How would I handle a new Document being added to section_1, for example? My inclination would be for it to be added to the end of the section, and then, if the client wished to do so, it could be re-ordered once its been uploaded. But, if using a sort_order column, how to set that correctly in the first place? One idea I've been ruminating on is to dispense with a document_sections table and, instead, have a root Document (that is "virtual, and never shown) and then several more "virtual" Documents representing the section names. IOW, the only real documents are those on the 3rd level of the tree (and there are only ever 3 levels). I'm going to give that a shot and see how it goes. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
