Generating a Nested Menu

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
14 messages Options
Reply | Threaded
Open this post in threaded view
|

Generating a Nested Menu

Naveen Kumar-3
Hi all,

My project spec requires that I need to create an ofbiz menu the following
way in a nested <ul> <li> structure:


        ...
        PARTY
        PROJECT
        *SFA** ** (class="active")*
                Main
                Accounts
                Contacts
               * Leads** ** (class="active")*
                        Create New
                        *Create Lead From vCard ** (class="active")*
                Competitors & Partners
                Events
                Documents
                Forecast
                Opportunities
                Preferences
        BUSINESS INTELLIGENCE
        EBAY
        ...



The main-menu, app-menu and the button tabs ALL should come within a SINGLE
NESTED unordered list with specific classes (like <li class="active"> for
the current active APP/SCREEN). This single nested list should be
dynamically generated.

Is this possible to create such a list? If "yes", please suggest me some
ways to implement this (in code).

Thank you,
Naveen.
Reply | Threaded
Open this post in threaded view
|

Re: Generating a Nested Menu

BJ Freeman
have you looked at the source code of a page, say for parytmgr, using
the different themes.
you will find your answer.

=========================
BJ Freeman
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man

Naveen Kumar sent the following on 12/13/2010 5:53 AM:


> Hi all,
>
> My project spec requires that I need to create an ofbiz menu the following
> way in a nested<ul>  <li>  structure:
>
>
>          ...
>          PARTY
>          PROJECT
>          *SFA** ** (class="active")*
>                  Main
>                  Accounts
>                  Contacts
>                 * Leads** ** (class="active")*
>                          Create New
>                          *Create Lead From vCard ** (class="active")*
>                  Competitors&  Partners
>                  Events
>                  Documents
>                  Forecast
>                  Opportunities
>                  Preferences
>          BUSINESS INTELLIGENCE
>          EBAY
>          ...
>
>
>
> The main-menu, app-menu and the button tabs ALL should come within a SINGLE
> NESTED unordered list with specific classes (like<li class="active">  for
> the current active APP/SCREEN). This single nested list should be
> dynamically generated.
>
> Is this possible to create such a list? If "yes", please suggest me some
> ways to implement this (in code).
>
> Thank you,
> Naveen.
>
Reply | Threaded
Open this post in threaded view
|

Re: Generating a Nested Menu

Bruno Busco
Hi Naveen,
unfortunately the multilevel menu is not completely implemented in the menu
widget.

We have had some discussion about it but not yet implemented.

You can find something interesting here:
https://issues.apache.org/jira/browse/OFBIZ-2104
https://issues.apache.org/jira/browse/OFBIZ-3373

Any contribution in this area will be greatly appreciated.

Regards,
Bruno

2010/12/14 BJ Freeman <[hidden email]>

> have you looked at the source code of a page, say for parytmgr, using the
> different themes.
> you will find your answer.
>
> =========================
> BJ Freeman
> Strategic Power Office with Supplier Automation  <
> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> Specialtymarket.com  <http://www.specialtymarket.com/>
> Systems Integrator-- Glad to Assist
>
> Chat  Y! messenger: bjfr33man
>
> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
>
>
>
>  Hi all,
>>
>> My project spec requires that I need to create an ofbiz menu the following
>> way in a nested<ul>  <li>  structure:
>>
>>
>>         ...
>>         PARTY
>>         PROJECT
>>         *SFA** ** (class="active")*
>>                 Main
>>                 Accounts
>>                 Contacts
>>                * Leads** ** (class="active")*
>>                         Create New
>>                         *Create Lead From vCard ** (class="active")*
>>                 Competitors&  Partners
>>                 Events
>>                 Documents
>>                 Forecast
>>                 Opportunities
>>                 Preferences
>>         BUSINESS INTELLIGENCE
>>         EBAY
>>         ...
>>
>>
>>
>> The main-menu, app-menu and the button tabs ALL should come within a
>> SINGLE
>> NESTED unordered list with specific classes (like<li class="active">  for
>> the current active APP/SCREEN). This single nested list should be
>> dynamically generated.
>>
>> Is this possible to create such a list? If "yes", please suggest me some
>> ways to implement this (in code).
>>
>> Thank you,
>> Naveen.
>>
>>
Reply | Threaded
Open this post in threaded view
|

Re: Generating a Nested Menu

Scott Gray-2
Hi Bruno,

Are you sure OFBIZ-2104 isn't implemented, I'm sure I recall doing this a couple of years ago...

Regards
Scott

On 14/12/2010, at 7:50 PM, Bruno Busco wrote:

> Hi Naveen,
> unfortunately the multilevel menu is not completely implemented in the menu
> widget.
>
> We have had some discussion about it but not yet implemented.
>
> You can find something interesting here:
> https://issues.apache.org/jira/browse/OFBIZ-2104
> https://issues.apache.org/jira/browse/OFBIZ-3373
>
> Any contribution in this area will be greatly appreciated.
>
> Regards,
> Bruno
>
> 2010/12/14 BJ Freeman <[hidden email]>
>
>> have you looked at the source code of a page, say for parytmgr, using the
>> different themes.
>> you will find your answer.
>>
>> =========================
>> BJ Freeman
>> Strategic Power Office with Supplier Automation  <
>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>> Specialtymarket.com  <http://www.specialtymarket.com/>
>> Systems Integrator-- Glad to Assist
>>
>> Chat  Y! messenger: bjfr33man
>>
>> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
>>
>>
>>
>> Hi all,
>>>
>>> My project spec requires that I need to create an ofbiz menu the following
>>> way in a nested<ul>  <li>  structure:
>>>
>>>
>>>        ...
>>>        PARTY
>>>        PROJECT
>>>        *SFA** ** (class="active")*
>>>                Main
>>>                Accounts
>>>                Contacts
>>>               * Leads** ** (class="active")*
>>>                        Create New
>>>                        *Create Lead From vCard ** (class="active")*
>>>                Competitors&  Partners
>>>                Events
>>>                Documents
>>>                Forecast
>>>                Opportunities
>>>                Preferences
>>>        BUSINESS INTELLIGENCE
>>>        EBAY
>>>        ...
>>>
>>>
>>>
>>> The main-menu, app-menu and the button tabs ALL should come within a
>>> SINGLE
>>> NESTED unordered list with specific classes (like<li class="active">  for
>>> the current active APP/SCREEN). This single nested list should be
>>> dynamically generated.
>>>
>>> Is this possible to create such a list? If "yes", please suggest me some
>>> ways to implement this (in code).
>>>
>>> Thank you,
>>> Naveen.
>>>
>>>


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Generating a Nested Menu

Scott Gray-2
It looks like nested menu items are supported but not nesting other menus.

Regards
Scott

On 14/12/2010, at 9:14 PM, Scott Gray wrote:

> Hi Bruno,
>
> Are you sure OFBIZ-2104 isn't implemented, I'm sure I recall doing this a couple of years ago...
>
> Regards
> Scott
>
> On 14/12/2010, at 7:50 PM, Bruno Busco wrote:
>
>> Hi Naveen,
>> unfortunately the multilevel menu is not completely implemented in the menu
>> widget.
>>
>> We have had some discussion about it but not yet implemented.
>>
>> You can find something interesting here:
>> https://issues.apache.org/jira/browse/OFBIZ-2104
>> https://issues.apache.org/jira/browse/OFBIZ-3373
>>
>> Any contribution in this area will be greatly appreciated.
>>
>> Regards,
>> Bruno
>>
>> 2010/12/14 BJ Freeman <[hidden email]>
>>
>>> have you looked at the source code of a page, say for parytmgr, using the
>>> different themes.
>>> you will find your answer.
>>>
>>> =========================
>>> BJ Freeman
>>> Strategic Power Office with Supplier Automation  <
>>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>>> Specialtymarket.com  <http://www.specialtymarket.com/>
>>> Systems Integrator-- Glad to Assist
>>>
>>> Chat  Y! messenger: bjfr33man
>>>
>>> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
>>>
>>>
>>>
>>> Hi all,
>>>>
>>>> My project spec requires that I need to create an ofbiz menu the following
>>>> way in a nested<ul>  <li>  structure:
>>>>
>>>>
>>>>       ...
>>>>       PARTY
>>>>       PROJECT
>>>>       *SFA** ** (class="active")*
>>>>               Main
>>>>               Accounts
>>>>               Contacts
>>>>              * Leads** ** (class="active")*
>>>>                       Create New
>>>>                       *Create Lead From vCard ** (class="active")*
>>>>               Competitors&  Partners
>>>>               Events
>>>>               Documents
>>>>               Forecast
>>>>               Opportunities
>>>>               Preferences
>>>>       BUSINESS INTELLIGENCE
>>>>       EBAY
>>>>       ...
>>>>
>>>>
>>>>
>>>> The main-menu, app-menu and the button tabs ALL should come within a
>>>> SINGLE
>>>> NESTED unordered list with specific classes (like<li class="active">  for
>>>> the current active APP/SCREEN). This single nested list should be
>>>> dynamically generated.
>>>>
>>>> Is this possible to create such a list? If "yes", please suggest me some
>>>> ways to implement this (in code).
>>>>
>>>> Thank you,
>>>> Naveen.
>>>>
>>>>
>


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Generating a Nested Menu

Bruno Busco
Yes,
I think this is what the sub-menu attribute of the menu-item tag should be
for.
It is not implemented yet.

Regards,
Bruno

2010/12/14 Scott Gray <[hidden email]>

> It looks like nested menu items are supported but not nesting other menus.
>
> Regards
> Scott
>
> On 14/12/2010, at 9:14 PM, Scott Gray wrote:
>
> > Hi Bruno,
> >
> > Are you sure OFBIZ-2104 isn't implemented, I'm sure I recall doing this a
> couple of years ago...
> >
> > Regards
> > Scott
> >
> > On 14/12/2010, at 7:50 PM, Bruno Busco wrote:
> >
> >> Hi Naveen,
> >> unfortunately the multilevel menu is not completely implemented in the
> menu
> >> widget.
> >>
> >> We have had some discussion about it but not yet implemented.
> >>
> >> You can find something interesting here:
> >> https://issues.apache.org/jira/browse/OFBIZ-2104
> >> https://issues.apache.org/jira/browse/OFBIZ-3373
> >>
> >> Any contribution in this area will be greatly appreciated.
> >>
> >> Regards,
> >> Bruno
> >>
> >> 2010/12/14 BJ Freeman <[hidden email]>
> >>
> >>> have you looked at the source code of a page, say for parytmgr, using
> the
> >>> different themes.
> >>> you will find your answer.
> >>>
> >>> =========================
> >>> BJ Freeman
> >>> Strategic Power Office with Supplier Automation  <
> >>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> >>> Specialtymarket.com  <http://www.specialtymarket.com/>
> >>> Systems Integrator-- Glad to Assist
> >>>
> >>> Chat  Y! messenger: bjfr33man
> >>>
> >>> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
> >>>
> >>>
> >>>
> >>> Hi all,
> >>>>
> >>>> My project spec requires that I need to create an ofbiz menu the
> following
> >>>> way in a nested<ul>  <li>  structure:
> >>>>
> >>>>
> >>>>       ...
> >>>>       PARTY
> >>>>       PROJECT
> >>>>       *SFA** ** (class="active")*
> >>>>               Main
> >>>>               Accounts
> >>>>               Contacts
> >>>>              * Leads** ** (class="active")*
> >>>>                       Create New
> >>>>                       *Create Lead From vCard ** (class="active")*
> >>>>               Competitors&  Partners
> >>>>               Events
> >>>>               Documents
> >>>>               Forecast
> >>>>               Opportunities
> >>>>               Preferences
> >>>>       BUSINESS INTELLIGENCE
> >>>>       EBAY
> >>>>       ...
> >>>>
> >>>>
> >>>>
> >>>> The main-menu, app-menu and the button tabs ALL should come within a
> >>>> SINGLE
> >>>> NESTED unordered list with specific classes (like<li class="active">
>  for
> >>>> the current active APP/SCREEN). This single nested list should be
> >>>> dynamically generated.
> >>>>
> >>>> Is this possible to create such a list? If "yes", please suggest me
> some
> >>>> ways to implement this (in code).
> >>>>
> >>>> Thank you,
> >>>> Naveen.
> >>>>
> >>>>
> >
>
>
Reply | Threaded
Open this post in threaded view
|

Sub queries using entity engine !

prashant punekar
Hi All,

Can we write a sub query using entity engine ?
Here is the query which is to be generated using entity engine.

Thanks in advance.

Regards,
Prashant


SELECT
        pc.category_name
      ,COUNT(DISTINCT p.product_id)

FROM  product_category_member pcm INNER JOIN
      product_category pc
ON    pc.product_category_id = pcm.product_category_id LEFT OUTER JOIN
                (
SELECT p.product_id
FROM    product p INNER JOIN
                inventory_item ii
ON      p.product_id = ii.product_id

GROUP BY  p.product_id
HAVING  SUM(ii.AVAILABLE_TO_PROMISE_TOTAL) > 0 /***no inventory**/) AS p

ON         pcm.product_id = p.product_id
GROUP BY  pc.category_name

________________________________

http://www.mindtree.com/email/disclaimer.html
Reply | Threaded
Open this post in threaded view
|

Re: Sub queries using entity engine !

BJ Freeman
what was the entity or entity view that created this sql.

=========================
BJ Freeman
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man


Prashant Punekar sent the following on 12/14/2010 11:16 AM:

> Hi All,
>
> Can we write a sub query using entity engine ?
> Here is the query which is to be generated using entity engine.
>
> Thanks in advance.
>
> Regards,
> Prashant
>
>
> SELECT
>          pc.category_name
>        ,COUNT(DISTINCT p.product_id)
>
> FROM  product_category_member pcm INNER JOIN
>        product_category pc
> ON    pc.product_category_id = pcm.product_category_id LEFT OUTER JOIN
>                  (
> SELECT p.product_id
> FROM    product p INNER JOIN
>                  inventory_item ii
> ON      p.product_id = ii.product_id
>
> GROUP BY  p.product_id
> HAVING  SUM(ii.AVAILABLE_TO_PROMISE_TOTAL)>  0 /***no inventory**/) AS p
>
> ON         pcm.product_id = p.product_id
> GROUP BY  pc.category_name
>
> ________________________________
>
> http://www.mindtree.com/email/disclaimer.html
>

Reply | Threaded
Open this post in threaded view
|

Re: Generating a Nested Menu

Naveen Kumar-3
In reply to this post by Bruno Busco
Hi All,

I'm interested in developing this nested menu thing. Can you please give me
directions on how to proceed with this?

Regards,
Naveen.


On Tue, Dec 14, 2010 at 11:31 PM, Bruno Busco <[hidden email]> wrote:

> Yes,
> I think this is what the sub-menu attribute of the menu-item tag should be
> for.
> It is not implemented yet.
>
> Regards,
> Bruno
>
> 2010/12/14 Scott Gray <[hidden email]>
>
> > It looks like nested menu items are supported but not nesting other
> menus.
> >
> > Regards
> > Scott
> >
> > On 14/12/2010, at 9:14 PM, Scott Gray wrote:
> >
> > > Hi Bruno,
> > >
> > > Are you sure OFBIZ-2104 isn't implemented, I'm sure I recall doing this
> a
> > couple of years ago...
> > >
> > > Regards
> > > Scott
> > >
> > > On 14/12/2010, at 7:50 PM, Bruno Busco wrote:
> > >
> > >> Hi Naveen,
> > >> unfortunately the multilevel menu is not completely implemented in the
> > menu
> > >> widget.
> > >>
> > >> We have had some discussion about it but not yet implemented.
> > >>
> > >> You can find something interesting here:
> > >> https://issues.apache.org/jira/browse/OFBIZ-2104
> > >> https://issues.apache.org/jira/browse/OFBIZ-3373
> > >>
> > >> Any contribution in this area will be greatly appreciated.
> > >>
> > >> Regards,
> > >> Bruno
> > >>
> > >> 2010/12/14 BJ Freeman <[hidden email]>
> > >>
> > >>> have you looked at the source code of a page, say for parytmgr, using
> > the
> > >>> different themes.
> > >>> you will find your answer.
> > >>>
> > >>> =========================
> > >>> BJ Freeman
> > >>> Strategic Power Office with Supplier Automation  <
> > >>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> > >>> Specialtymarket.com  <http://www.specialtymarket.com/>
> > >>> Systems Integrator-- Glad to Assist
> > >>>
> > >>> Chat  Y! messenger: bjfr33man
> > >>>
> > >>> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
> > >>>
> > >>>
> > >>>
> > >>> Hi all,
> > >>>>
> > >>>> My project spec requires that I need to create an ofbiz menu the
> > following
> > >>>> way in a nested<ul>  <li>  structure:
> > >>>>
> > >>>>
> > >>>>       ...
> > >>>>       PARTY
> > >>>>       PROJECT
> > >>>>       *SFA** ** (class="active")*
> > >>>>               Main
> > >>>>               Accounts
> > >>>>               Contacts
> > >>>>              * Leads** ** (class="active")*
> > >>>>                       Create New
> > >>>>                       *Create Lead From vCard ** (class="active")*
> > >>>>               Competitors&  Partners
> > >>>>               Events
> > >>>>               Documents
> > >>>>               Forecast
> > >>>>               Opportunities
> > >>>>               Preferences
> > >>>>       BUSINESS INTELLIGENCE
> > >>>>       EBAY
> > >>>>       ...
> > >>>>
> > >>>>
> > >>>>
> > >>>> The main-menu, app-menu and the button tabs ALL should come within a
> > >>>> SINGLE
> > >>>> NESTED unordered list with specific classes (like<li class="active">
> >  for
> > >>>> the current active APP/SCREEN). This single nested list should be
> > >>>> dynamically generated.
> > >>>>
> > >>>> Is this possible to create such a list? If "yes", please suggest me
> > some
> > >>>> ways to implement this (in code).
> > >>>>
> > >>>> Thank you,
> > >>>> Naveen.
> > >>>>
> > >>>>
> > >
> >
> >
>
Reply | Threaded
Open this post in threaded view
|

Re: Generating a Nested Menu

BJ Freeman
to clarify
the menu widget does do nested menus.
the part missing is if you have other menu widget you can not attach
them to a current menu widget and have them nested.

is the attachment of other menu widget what you are reffering to?


=========================
BJ Freeman
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Naveen Kumar sent the following on 12/15/2010 6:18 AM:

> Hi All,
>
> I'm interested in developing this nested menu thing. Can you please give me
> directions on how to proceed with this?
>
> Regards,
> Naveen.
>
>
> On Tue, Dec 14, 2010 at 11:31 PM, Bruno Busco<[hidden email]>  wrote:
>
>> Yes,
>> I think this is what the sub-menu attribute of the menu-item tag should be
>> for.
>> It is not implemented yet.
>>
>> Regards,
>> Bruno
>>
>> 2010/12/14 Scott Gray<[hidden email]>
>>
>>> It looks like nested menu items are supported but not nesting other
>> menus.
>>>
>>> Regards
>>> Scott
>>>
>>> On 14/12/2010, at 9:14 PM, Scott Gray wrote:
>>>
>>>> Hi Bruno,
>>>>
>>>> Are you sure OFBIZ-2104 isn't implemented, I'm sure I recall doing this
>> a
>>> couple of years ago...
>>>>
>>>> Regards
>>>> Scott
>>>>
>>>> On 14/12/2010, at 7:50 PM, Bruno Busco wrote:
>>>>
>>>>> Hi Naveen,
>>>>> unfortunately the multilevel menu is not completely implemented in the
>>> menu
>>>>> widget.
>>>>>
>>>>> We have had some discussion about it but not yet implemented.
>>>>>
>>>>> You can find something interesting here:
>>>>> https://issues.apache.org/jira/browse/OFBIZ-2104
>>>>> https://issues.apache.org/jira/browse/OFBIZ-3373
>>>>>
>>>>> Any contribution in this area will be greatly appreciated.
>>>>>
>>>>> Regards,
>>>>> Bruno
>>>>>
>>>>> 2010/12/14 BJ Freeman<[hidden email]>
>>>>>
>>>>>> have you looked at the source code of a page, say for parytmgr, using
>>> the
>>>>>> different themes.
>>>>>> you will find your answer.
>>>>>>
>>>>>> =========================
>>>>>> BJ Freeman
>>>>>> Strategic Power Office with Supplier Automation<
>>>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>>>>>> Specialtymarket.com<http://www.specialtymarket.com/>
>>>>>> Systems Integrator-- Glad to Assist
>>>>>>
>>>>>> Chat  Y! messenger: bjfr33man
>>>>>>
>>>>>> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
>>>>>>
>>>>>>
>>>>>>
>>>>>> Hi all,
>>>>>>>
>>>>>>> My project spec requires that I need to create an ofbiz menu the
>>> following
>>>>>>> way in a nested<ul>   <li>   structure:
>>>>>>>
>>>>>>>
>>>>>>>        ...
>>>>>>>        PARTY
>>>>>>>        PROJECT
>>>>>>>        *SFA** ** (class="active")*
>>>>>>>                Main
>>>>>>>                Accounts
>>>>>>>                Contacts
>>>>>>>               * Leads** ** (class="active")*
>>>>>>>                        Create New
>>>>>>>                        *Create Lead From vCard ** (class="active")*
>>>>>>>                Competitors&   Partners
>>>>>>>                Events
>>>>>>>                Documents
>>>>>>>                Forecast
>>>>>>>                Opportunities
>>>>>>>                Preferences
>>>>>>>        BUSINESS INTELLIGENCE
>>>>>>>        EBAY
>>>>>>>        ...
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> The main-menu, app-menu and the button tabs ALL should come within a
>>>>>>> SINGLE
>>>>>>> NESTED unordered list with specific classes (like<li class="active">
>>>   for
>>>>>>> the current active APP/SCREEN). This single nested list should be
>>>>>>> dynamically generated.
>>>>>>>
>>>>>>> Is this possible to create such a list? If "yes", please suggest me
>>> some
>>>>>>> ways to implement this (in code).
>>>>>>>
>>>>>>> Thank you,
>>>>>>> Naveen.
>>>>>>>
>>>>>>>
>>>>
>>>
>>>
>>
>
Reply | Threaded
Open this post in threaded view
|

RE: Sub queries using entity engine !

prashant punekar
In reply to this post by BJ Freeman
Freeman,

This query is not generated. I want to generate this query using DynamicViewEntity object.
Is it possible to use the sub-query as the table alias and then do left outer join on it?

Regards,
Prashant


-----Original Message-----
From: BJ Freeman [mailto:[hidden email]]
Sent: Tuesday, December 14, 2010 11:25 AM
To: [hidden email]
Subject: Re: Sub queries using entity engine !

what was the entity or entity view that created this sql.

=========================
BJ Freeman
Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com  <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man


Prashant Punekar sent the following on 12/14/2010 11:16 AM:

> Hi All,
>
> Can we write a sub query using entity engine ?
> Here is the query which is to be generated using entity engine.
>
> Thanks in advance.
>
> Regards,
> Prashant
>
>
> SELECT
>          pc.category_name
>        ,COUNT(DISTINCT p.product_id)
>
> FROM  product_category_member pcm INNER JOIN
>        product_category pc
> ON    pc.product_category_id = pcm.product_category_id LEFT OUTER JOIN
>                  (
> SELECT p.product_id
> FROM    product p INNER JOIN
>                  inventory_item ii
> ON      p.product_id = ii.product_id
>
> GROUP BY  p.product_id
> HAVING  SUM(ii.AVAILABLE_TO_PROMISE_TOTAL)>  0 /***no inventory**/) AS p
>
> ON         pcm.product_id = p.product_id
> GROUP BY  pc.category_name
>
> ________________________________
>
> http://www.mindtree.com/email/disclaimer.html
>

Reply | Threaded
Open this post in threaded view
|

Re: Sub queries using entity engine !

David E. Jones-2

You can do a nested query using the EntityWhereClause condition, just mix it in with other conditions you need as part of your condition tree. It won't be part of the entity definition, but rather the code that does the query.

-David


On Dec 15, 2010, at 1:55 PM, Prashant Punekar wrote:

> Freeman,
>
> This query is not generated. I want to generate this query using DynamicViewEntity object.
> Is it possible to use the sub-query as the table alias and then do left outer join on it?
>
> Regards,
> Prashant
>
>
> -----Original Message-----
> From: BJ Freeman [mailto:[hidden email]]
> Sent: Tuesday, December 14, 2010 11:25 AM
> To: [hidden email]
> Subject: Re: Sub queries using entity engine !
>
> what was the entity or entity view that created this sql.
>
> =========================
> BJ Freeman
> Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> Specialtymarket.com  <http://www.specialtymarket.com/>
> Systems Integrator-- Glad to Assist
>
> Chat  Y! messenger: bjfr33man
>
>
> Prashant Punekar sent the following on 12/14/2010 11:16 AM:
>> Hi All,
>>
>> Can we write a sub query using entity engine ?
>> Here is the query which is to be generated using entity engine.
>>
>> Thanks in advance.
>>
>> Regards,
>> Prashant
>>
>>
>> SELECT
>>         pc.category_name
>>       ,COUNT(DISTINCT p.product_id)
>>
>> FROM  product_category_member pcm INNER JOIN
>>       product_category pc
>> ON    pc.product_category_id = pcm.product_category_id LEFT OUTER JOIN
>>                 (
>> SELECT p.product_id
>> FROM    product p INNER JOIN
>>                 inventory_item ii
>> ON      p.product_id = ii.product_id
>>
>> GROUP BY  p.product_id
>> HAVING  SUM(ii.AVAILABLE_TO_PROMISE_TOTAL)>  0 /***no inventory**/) AS p
>>
>> ON         pcm.product_id = p.product_id
>> GROUP BY  pc.category_name
>>
>> ________________________________
>>
>> http://www.mindtree.com/email/disclaimer.html
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: Sub queries using entity engine !

David E. Jones-2

Sorry, it's "EntityWhereString", not "EntityWhereClause".

-David


On Dec 15, 2010, at 3:49 PM, David E Jones wrote:

>
> You can do a nested query using the EntityWhereClause condition, just mix it in with other conditions you need as part of your condition tree. It won't be part of the entity definition, but rather the code that does the query.
>
> -David
>
>
> On Dec 15, 2010, at 1:55 PM, Prashant Punekar wrote:
>
>> Freeman,
>>
>> This query is not generated. I want to generate this query using DynamicViewEntity object.
>> Is it possible to use the sub-query as the table alias and then do left outer join on it?
>>
>> Regards,
>> Prashant
>>
>>
>> -----Original Message-----
>> From: BJ Freeman [mailto:[hidden email]]
>> Sent: Tuesday, December 14, 2010 11:25 AM
>> To: [hidden email]
>> Subject: Re: Sub queries using entity engine !
>>
>> what was the entity or entity view that created this sql.
>>
>> =========================
>> BJ Freeman
>> Strategic Power Office with Supplier Automation  <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>> Specialtymarket.com  <http://www.specialtymarket.com/>
>> Systems Integrator-- Glad to Assist
>>
>> Chat  Y! messenger: bjfr33man
>>
>>
>> Prashant Punekar sent the following on 12/14/2010 11:16 AM:
>>> Hi All,
>>>
>>> Can we write a sub query using entity engine ?
>>> Here is the query which is to be generated using entity engine.
>>>
>>> Thanks in advance.
>>>
>>> Regards,
>>> Prashant
>>>
>>>
>>> SELECT
>>>        pc.category_name
>>>      ,COUNT(DISTINCT p.product_id)
>>>
>>> FROM  product_category_member pcm INNER JOIN
>>>      product_category pc
>>> ON    pc.product_category_id = pcm.product_category_id LEFT OUTER JOIN
>>>                (
>>> SELECT p.product_id
>>> FROM    product p INNER JOIN
>>>                inventory_item ii
>>> ON      p.product_id = ii.product_id
>>>
>>> GROUP BY  p.product_id
>>> HAVING  SUM(ii.AVAILABLE_TO_PROMISE_TOTAL)>  0 /***no inventory**/) AS p
>>>
>>> ON         pcm.product_id = p.product_id
>>> GROUP BY  pc.category_name
>>>
>>> ________________________________
>>>
>>> http://www.mindtree.com/email/disclaimer.html
>>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: Generating a Nested Menu

Naveen Kumar-3
In reply to this post by BJ Freeman
Hi BJ,

Yes, it is *the attachment of other menu widget into a menu widget* that I'm
referring to.  If the current menu widget does not support this, is there
any other way to do this?

Thanks,

Naveen

On Wed, Dec 15, 2010 at 10:45 PM, BJ Freeman <[hidden email]> wrote:

> to clarify
> the menu widget does do nested menus.
> the part missing is if you have other menu widget you can not attach them
> to a current menu widget and have them nested.
>
> is the attachment of other menu widget what you are reffering to?
>
>
>
> =========================
> BJ Freeman
> Strategic Power Office with Supplier Automation  <
> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> Specialtymarket.com  <http://www.specialtymarket.com/>
> Systems Integrator-- Glad to Assist
>
> Chat  Y! messenger: bjfr33man
> Naveen Kumar sent the following on 12/15/2010 6:18 AM:
>
>
>  Hi All,
>>
>> I'm interested in developing this nested menu thing. Can you please give
>> me
>> directions on how to proceed with this?
>>
>> Regards,
>> Naveen.
>>
>>
>> On Tue, Dec 14, 2010 at 11:31 PM, Bruno Busco<[hidden email]>
>>  wrote:
>>
>>  Yes,
>>> I think this is what the sub-menu attribute of the menu-item tag should
>>> be
>>> for.
>>> It is not implemented yet.
>>>
>>> Regards,
>>> Bruno
>>>
>>> 2010/12/14 Scott Gray<[hidden email]>
>>>
>>>  It looks like nested menu items are supported but not nesting other
>>>>
>>> menus.
>>>
>>>>
>>>> Regards
>>>> Scott
>>>>
>>>> On 14/12/2010, at 9:14 PM, Scott Gray wrote:
>>>>
>>>>  Hi Bruno,
>>>>>
>>>>> Are you sure OFBIZ-2104 isn't implemented, I'm sure I recall doing this
>>>>>
>>>> a
>>>
>>>> couple of years ago...
>>>>
>>>>>
>>>>> Regards
>>>>> Scott
>>>>>
>>>>> On 14/12/2010, at 7:50 PM, Bruno Busco wrote:
>>>>>
>>>>>  Hi Naveen,
>>>>>> unfortunately the multilevel menu is not completely implemented in the
>>>>>>
>>>>> menu
>>>>
>>>>> widget.
>>>>>>
>>>>>> We have had some discussion about it but not yet implemented.
>>>>>>
>>>>>> You can find something interesting here:
>>>>>> https://issues.apache.org/jira/browse/OFBIZ-2104
>>>>>> https://issues.apache.org/jira/browse/OFBIZ-3373
>>>>>>
>>>>>> Any contribution in this area will be greatly appreciated.
>>>>>>
>>>>>> Regards,
>>>>>> Bruno
>>>>>>
>>>>>> 2010/12/14 BJ Freeman<[hidden email]>
>>>>>>
>>>>>>  have you looked at the source code of a page, say for parytmgr, using
>>>>>>>
>>>>>> the
>>>>
>>>>> different themes.
>>>>>>> you will find your answer.
>>>>>>>
>>>>>>> =========================
>>>>>>> BJ Freeman
>>>>>>> Strategic Power Office with Supplier Automation<
>>>>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>>>>>>> Specialtymarket.com<http://www.specialtymarket.com/>
>>>>>>> Systems Integrator-- Glad to Assist
>>>>>>>
>>>>>>> Chat  Y! messenger: bjfr33man
>>>>>>>
>>>>>>> Naveen Kumar sent the following on 12/13/2010 5:53 AM:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Hi all,
>>>>>>>
>>>>>>>>
>>>>>>>> My project spec requires that I need to create an ofbiz menu the
>>>>>>>>
>>>>>>> following
>>>>
>>>>> way in a nested<ul>   <li>   structure:
>>>>>>>>
>>>>>>>>
>>>>>>>>       ...
>>>>>>>>       PARTY
>>>>>>>>       PROJECT
>>>>>>>>       *SFA** ** (class="active")*
>>>>>>>>               Main
>>>>>>>>               Accounts
>>>>>>>>               Contacts
>>>>>>>>              * Leads** ** (class="active")*
>>>>>>>>                       Create New
>>>>>>>>                       *Create Lead From vCard ** (class="active")*
>>>>>>>>               Competitors&   Partners
>>>>>>>>               Events
>>>>>>>>               Documents
>>>>>>>>               Forecast
>>>>>>>>               Opportunities
>>>>>>>>               Preferences
>>>>>>>>       BUSINESS INTELLIGENCE
>>>>>>>>       EBAY
>>>>>>>>       ...
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> The main-menu, app-menu and the button tabs ALL should come within a
>>>>>>>> SINGLE
>>>>>>>> NESTED unordered list with specific classes (like<li class="active">
>>>>>>>>
>>>>>>>  for
>>>>
>>>>> the current active APP/SCREEN). This single nested list should be
>>>>>>>> dynamically generated.
>>>>>>>>
>>>>>>>> Is this possible to create such a list? If "yes", please suggest me
>>>>>>>>
>>>>>>> some
>>>>
>>>>> ways to implement this (in code).
>>>>>>>>
>>>>>>>> Thank you,
>>>>>>>> Naveen.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>
>>>>
>>>>
>>>
>>