Java Class

[su2]

Hello Friends,

I have a form - myForm.xml
 
I want to create following field in myForm.xml

<field name="subTotal" title="${uiLabelMap.mySubTotal}">
            <display description="${bsh:org.ofbiz.my.my.MyHelper.getSubTotal(myOrderNo)}"/>
</field>

For this I want to create java class - getSubTotal()

Where I want to pass current orderno and get subtotal(=itemsubtotal + shipping charges)

for that I want to create a SQL query in my java class - getSubTotal()

SELECT (itemsubtotal+shippingCharges) as subTotal FROM myTable where orderNo = $(mypassedOrderNo);

Is this possible to do in java class?

If yes, can somebody guide me?

Thank you for the help in advance.

Su-

[Adrian Crum]

Typically, data queries are put in services (so they can be reused) and
then the service is called by the form's actions element.

-Adrian

su2 wrote:

> Hello Friends,
>
> I have a form - myForm.xml
>  
> I want to create following field in myForm.xml
>
> <field name="subTotal" title="${uiLabelMap.mySubTotal}">
>             <display
> description="${bsh:org.ofbiz.my.my.MyHelper.getSubTotal(myOrderNo)}"/>
> </field>
>
> For this I want to create java class - getSubTotal()
>
> Where I want to pass current orderno and get subtotal(=itemsubtotal +
> shipping charges)
>
> for that I want to create a SQL query in my java class - getSubTotal()
>
> SELECT (itemsubtotal+shippingCharges) as subTotal FROM myTable where orderNo
> = $(mypassedOrderNo);
>
> Is this possible to do in java class?
>
> If yes, can somebody guide me?
>
> Thank you for the help in advance.
>
> Su-
>
>
>
>
>

[su2]

Hi Adrian,

But I would like to have it in a java class instead of services as i need to do lot of data manipulation which is i think not possible in services.

Adrian Crum wrote

Typically, data queries are put in services (so they can be reused) and
then the service is called by the form's actions element.

-Adrian

su2 wrote:
> Hello Friends,
>
> I have a form - myForm.xml
>  
> I want to create following field in myForm.xml
>
> <field name="subTotal" title="${uiLabelMap.mySubTotal}">
>             <display
> description="${bsh:org.ofbiz.my.my.MyHelper.getSubTotal(myOrderNo)}"/>
> </field>
>
> For this I want to create java class - getSubTotal()
>
> Where I want to pass current orderno and get subtotal(=itemsubtotal +
> shipping charges)
>
> for that I want to create a SQL query in my java class - getSubTotal()
>
> SELECT (itemsubtotal+shippingCharges) as subTotal FROM myTable where orderNo
> = $(mypassedOrderNo);
>
> Is this possible to do in java class?
>
> If yes, can somebody guide me?
>
> Thank you for the help in advance.
>
> Su-
>
>
>
>
>

[Sumit Pandit-3]

Hi Su,
        This is possible in java, you can find many java classes in OFBiz  
where various calculation are done based on many query, for example -  
ShoppingCart.java, PosTransaction.java and few are in Accounting  
component.
--
Regards
Sumit Pandit


On 29-Sep-09, at 7:58 PM, su2 wrote:

>
> Hello Friends,
>
> I have a form - myForm.xml
>
> I want to create following field in myForm.xml
>
> <field name="subTotal" title="${uiLabelMap.mySubTotal}">
>            <display
> description="${bsh:org.ofbiz.my.my.MyHelper.getSubTotal(myOrderNo)}"/>
> </field>
>
> For this I want to create java class - getSubTotal()
>
> Where I want to pass current orderno and get subtotal(=itemsubtotal +
> shipping charges)
>
> for that I want to create a SQL query in my java class - getSubTotal()
>
> SELECT (itemsubtotal+shippingCharges) as subTotal FROM myTable where  
> orderNo
> = $(mypassedOrderNo);
>
> Is this possible to do in java class?
>
> If yes, can somebody guide me?
>
> Thank you for the help in advance.
>
> Su-
>
>
>
>
>
> --
> View this message in context: http://www.nabble.com/Java-Class-tp25663962p25663962.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>