Photo Shop - My Orders: Calculation problems

[JohannM]

Hi

The "Admin" and "My Orders" in the photo shop system does not calculate the correct amounts.

Any help ?

[Stramm]

plugins/photo_shop/photo_shop_checkout.php

find

Code Select Expand

$results2 = cpg_db_query ("INSERT INTO `{$CONFIG['TABLE_SHOP']}` (`oid`, `uid`, `cd`, `quantity`, `price`, `otime`) VALUES ('$order_id', '".USER_ID."', '1', '".($cd_counter['cd']+$cd_counter['photo'])."', '".(number_format(($picture_total+$cd_price[1]+$shipping_price-$discount),2))."', '$otime')");

replace with

Code Select Expand

$results2 = cpg_db_query ("INSERT INTO `{$CONFIG['TABLE_SHOP']}` (`oid`, `uid`, `cd`, `quantity`, `price`, `otime`) VALUES ('$order_id', '".USER_ID."', '1', '".($cd_counter['cd']+$cd_counter['photo'])."', '".($picture_total+$cd_price[1]+$shipping_price_calc-$discount_calc)."', '$otime')");


find

Code Select Expand

function photoshop_add_data($shop_data, $order_id){
global $CONFIG, $SHOP_CONFIG, $cd_price, $cd_counter, $discount, $shipping_price;

replace with

Code Select Expand

function photoshop_add_data($shop_data, $order_id){
global $CONFIG, $SHOP_CONFIG, $cd_price, $cd_counter, $discount_calc, $shipping_price_calc;

[JohannM]

Yet again, you are a star. Working nice.

Thanx a mil Stramm

Ho can I include the discount amount on the "My order" Page ?

[Stramm]

it doesn't save the discount... it saves the price of each item and the total
-> total - sum prices = discount + shipping

[mfaizalar]

it doesn't save the discount... it saves the price of each item and the total
-> total - sum prices = discount + shipping

I'm having quite similar prob. Setting up 2 diff shipping cost for 2 diff places. But when it comes to total cost, the sum will pick up the highest cost between these 2 shipping costs. Any suggestion to fix this? Appreciate your help!

[Stramm]

it's coded that way... despite changing code there's mo way

[JohannM]

Hi Stramm

I just realized that the "My Orders" and "Admin" pages does not show the correct amounts.  The totals is wrong and the number format also.

What u think can be wring ? Please help !!!   Thanx in advance

[Stramm]

examples? Again with numbers > 1000 ??

[JohannM]

Yes Stramm, numbers greater than 1000. I just can't figure it out, tried everything within my php knowledge.

[JohannM]

Yes Stramm, numbers greater than 1000. I just can't figure it out with my php knowledge. Tried everything !