Thanks,
it works. I placed it into models directory. Is that right?
Julius
V Pondelok, 26. apríl 2010 o 17:05 -0700, mdipierro napísal(a):
> Something like
>
> def build_menu()::
> root=0 # assumes the root has parent_id=0
> keys={root:UL()}
> items=db(db.category.id>0).select(orderby=db.category.parent_id|
> db.category.name)
> for item in items:
> keys[item.id]=ul=UL()
> keys[item.parent_id].append(LI(A(item.name,_href='#'),ul)
> return keys[root]
>
> {{=build_menu()}}
>
> On Apr 26, 12:31 pm, Julius Minka <[email protected]> wrote:
> > I have to implement following 4-level menu in my view:
> >
> > <ul class="menu1">
> > <li><a href="#">Level1a</a></li>
> > <li><a href="#">Level1b</a></li>
> > <li><a href="#">Level1c*</a>
> > <ul class="menu1">
> > <li><a href="#">Level2a*</a>
> > <ul class="menu1">
> > <li><a href="#">Level3a*</a>
> > <ul>
> > <li><a href="#">Level4a</a></li>
> > <li><a href="#">Level4b</a></li>
> > <li><a href="#">Level4c</a></li>
> > </ul>
> > </li>
> > <li><a href="#">Level3b</a></li>
> > <li><a href="#">Level3c</a></li>
> > <li><a href="#">Level3d</a></li>
> > </ul>
> > </li>
> > <li><a href="#">Level2b</a></li>
> > <li><a href="#">Level2c</a></li>
> > <li><a href="#">Level2d</a></li>
> > </ul>
> > </li>
> > </ul>
> >
> > This menu should be dynamically generated from DB
> > Respective table looks as follows:
> >
> > db.define_table('category',
> > Field('name', 'string', length=40, required=True, notnull=False,
> > unique=True),
> > Field('parent_id', 'reference category', length=5, required=False,
> > notnull=False))
> > db.category.parent_id.requires=IS_NULL_OR(IS_IN_DB(db,'category.id','
> > %(name)s'))
> >
> > Menu items on the first level have no parents, all items on next levels
> > define one. I can change the table if required.
> >
> > Can somebody suggest a good approach for doing this?
> >
> > Thanks,
> > Julius
> >
> > --
> > Subscription settings:http://groups.google.com/group/web2py/subscribe?hl=en
