confirm.php not saving Order Summary data

Hi!
I have been putting a site together for a client who pays commission to her staff when an order is placed by one of their logged in customers.

In order to cope with the possibility of a change in commission rate down the line, I am trying to add a new column to the orders table called Ord_Comm. I currently have the datatype set as FLOAT (the same as the OrderAmount field).

I have added the commission calculation to the form using some basic php maths. The grand total is taken from the e-cart object and the commission rate is taken from a recordset. The calculation in the hidden field on the form displays perfectly.

Now, in the Store Summary in Database behaviour, I have linked my Ord_Comm database field with the 'commission' field in the form on the page, but it will not save the calculated commission rate into the database.

At the same time, there is another column called 'ComPaid_ord' which has a value of '0' added into the Store Summer in Database behaviour and this enters '0' in every time I put a dummy order through.

Any ideas? My client is demonstrating this on Wednesday evenign (UK time) and would greatly appreciate a pointer or two on what's going on...or not!

Many thanks,

Martin

If you view source of the confirm page in the browser, what is the value of the commission form element?


I would suspect that the calculation you have for the commission element is not returning the proper value.





For the ComPaid_ord column, you have hard coded the value to be 0 in the store order summary behavior.

Hi Jason,

Thanks for coming back to me. Here is a copy of the source code from the page in action on the site:

Line 272 and 273 show the grand total to be GBP 17.20 which is correct.

Line 300 gives the correct commission value (in this case 10%) as being 1.72 (no currency setting. The commission is calculated using the results from a recordset and the Grand Total of the session)

So, the total is correct and the commission value is correct too....yet the Save Summary to Database behaviour is not saving this figure to the database....but the hard coded 'ComPaid_ord' is being entered as '0'.

Just to recap, in the database, the commission field called 'Ord_Comm' (where the form value id=commission from line 300 (in the attached source code) should be stored) is set to FLOAT.

as everything appears to be correct....I still can't see what's going wrong with it!

Many thanks,

Martin

to help troubleshoot, change the following line:

$WA_Sql = "insert into " . $WA_table . " (" . $insertParamsObj->WA_tableValues . ") values (" . $insertParamsObj->WA_dbValues . ")";

to:

$WA_Sql = "insert into " . $WA_table . " (" . $insertParamsObj->WA_tableValues . ") values (" . $insertParamsObj->WA_dbValues . ")";

die("SQL: ".$WA_Sql."<br /><pre>".var_dump($_POST)."</pre>");

this will write the insert SQL and the form values to the screen, please post this information back.

Hi,
Have changed the file as requested and this is the data that is returned:

array(25) { ["firstname"]=> string(6) "Martin" ["lastname"]=> string(11) "Saban-Smith" ["email"]=> string(24) "editor@thisisalton.co.uk" ["phone"]=> string(12) "07713 349883" ["fax"]=> string(0) "" ["street1"]=> string(9) "Garthowen" ["street2"]=> string(10) "Alton Lane" ["city"]=> string(10) "Four Marks" ["state_province"]=> string(9) "Hampshire" ["postcode"]=> string(8) "GU34 5AJ" ["country"]=> string(2) "GB" ["eC_SameAs"]=> string(1) "1" ["shipping_firstname"]=> string(6) "Martin" ["shipping_lastname"]=> string(11) "Saban-Smith" ["shipping_email"]=> string(24) "editor@thisisalton.co.uk" ["shipping_phone"]=> string(12) "07713 349883" ["shipping_fax"]=> string(0) "" ["shipping_street1"]=> string(9) "Garthowen" ["shipping_street2"]=> string(10) "Alton Lane" ["shipping_city"]=> string(10) "Four Marks" ["shipping_state_province"]=> string(9) "Hampshire" ["shipping_postcode"]=> string(8) "GU34 5AJ" ["shipping_country"]=> string(0) "" ["Checkout_x"]=> string(2) "19" ["Checkout_y"]=> string(1) "7" } SQL: insert into orders (OrderUserID,OrderAmount,OrderShipName,OrderShipAddress,OrderShipAddress2,OrderCity,OrderState,OrderZip,OrderCountry,OrderPhone,OrderFax,OrderShipping,OrderTax,OrderEmail,OrderDate,ComPaid_ord,mentor_ord,Ord_Comm) values (86,15.00,'Martin Saban-Smith','Garthowen','Alton Lane','Four Marks','Hampshire','GU34 5AJ','','07713 349883','',2.5,0,'editor@thisisalton.co.uk','2012-02-22 09:59:22',0,74,NULL)


FYI - Order Grand total was GBP 15.00 - therefore, the Ord_Comm value should be 1.5, but I think is showing NULL.

I have had to put the original confirm.php file back in place as the shop is currently live.

Many thanks for your continued help.

Martin

ok, i see now.

you need to add the commission form element top the checkout page.

you are using paypal standard, so the form on the confirm page posts to paypal.

the order summary and details are stored when the checkout page posts to the confirm page.

Brilliant!

Thanks, Jason.....first class as always!

Martin

you're welcome.