My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 39: PATCH Wrong number of orders by country
1 person starred this issue and may be notified of changes. Back to list
Status:  Fixed
Owner:  ----
Closed:  Apr 2008


 
Reported by edmundo...@gmail.com, Mar 6, 2008
What steps will reproduce the problem?
1. Pick one user and make several orders and let the billing and shipping
addresses the same.

What is the expected output? What do you see instead?
The result in administration view is the sum of
(number_of_orders_of_an_user_to_a_country *
number_of_total_orders_of_this_user). It should be only the sum of orders
sent to a country by any user.

What version of the product are you using? On what operating system?
trunk. Ubuntu 7.04

Please provide any additional information below.

The way it is it only works when you test with just one order per user.
Create one more and it will give wrong results.

The SQL is wrong, you dont need to join orders with users and then to
addresses, the order already have a foreign key to a shipping address where
you can discover the country.

Follows a patch.
orders_by_country_counter.patch
898 bytes   View   Download
Apr 8, 2008
Project Member #1 subim...@gmail.com
Fixed - revision 53
Status: Fixed

Powered by Google Project Hosting