2. PHPRunner General questions
  3. how to calculate fields in real time
This topic is locked

how to calculate fields in real time

 		5/31/2010 12:03:01 AM
PHPRunner General questions
O
 onlline author

I Need Help.
PHPRunner 5.2 Build 4905
1.Table: Sales

2.Fields: Price Quantity Total
to add quantity and price like the sum of the total

This code below is not to solve it.
----------------------------------------------------------------------------------------------

var ctrlPrice = Runner.getControl(pageid, 'Price');

var ctrlQuantity = Runner.getControl(pageid, 'Quantity');

var ctrlTotal = Runner.getControl(pageid, 'Total');
function func() {

ctrlTotal.setValue(parseFloat(ctrlPrice.getValue()) * parseFloat(ctrlQuantity.getValue()));

};
ctrlPrice.on('keyup', func);

ctrlQuantity.on('keyup', func);

----------------------------------------------------------------------------------------------
I need a kind of cart or Shop Point of Sale
where I will add the products and wanted a total sale
A
 		ann 5/31/2010

Hi,
Please download the latest build 5482 of PHPRunner. Make sure you've put code into the Add page:JavaScript Onload event of the Sales table.

If it doesn't help please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.
O
 		onlline author 5/31/2010



Hi,
Please download the latest build 5482 of PHPRunner. Make sure you've code into the Add page:JavaScript Onload event of the Sales table.

If it doesn't help please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.


Perfect it worked, thanks.
I updated the version
when using dd online it gives me the total in the Total field
I'm more of an item to add them would be possible to make a total sum of the fields
example
1.Table: Sales

2.Fields: Price Quantity Total
3 Grand Total (would be the sum of the total field of each product added)
A
 		ann 6/1/2010

Leonardo,
choose "TOTAL" as Totals type for the "Total" field on the Fields order and totals tab.
O
 		onlline author 6/1/2010



Leonardo,
choose "TOTAL" as Totals type for the "Total" field on the Fields order and totals tab.


Excuse my English, I need to make a point of sale,
example seeing chairs.
must enter more than one product on the screen of sale and issue a receipt, also have to give output in the table of stock
would be a selling point as the super market, a person inserts various products and issues a receipt
as in this example image


The idea would be to make a point of you coming in php using PHPRunner
Tanks
A
 		ann 6/1/2010

Leonardo,
It's difficult to tell you what's happening without seeing actual files.

Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.
O
 		onlline author 6/1/2010



Leonardo,
It's difficult to tell you what's happening without seeing actual files.

Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.


Tradução do português para o inglêsMostrar romanização
sorry, I could solve my problem,
Now he wanted to create an application point of sale with this paricá the picture above.

this type
if you can come visit this link for an example

http://demo.phppointofsale.com/index.php/sales/
I would do something like PHPRunner
A
 		ann 6/2/2010

Leonardo,
In general, you can create such application. Probably it will require some custom coding in the events. I reccommend you to create tables, build your project and post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.