View Issue Details

Jump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0006634OXID eShop (all versions)2.6. Administer orderspublic2017-05-09 21:292017-05-11 10:38
Reportermario_lorenz Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionno change required 
Product Version4.10.4 / 5.3.4 
Summary0006634: list_order SQL, the "group by" ignore order id
Descriptionin the method List_Order->_prepareWhereQuery

the group by groups the articles by articles-oxid and not by order-oxid.

If you have two orders with the same article, in both orders the articles are adds together.
TagsNo tags attached.
Attached Files
orders_list.png (46,888 bytes)   
orders_list.png (46,888 bytes)   
orders_details.png (57,826 bytes)   
orders_details.png (57,826 bytes)   
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
Database VersionNot defined

Activities

QA

2017-05-10 11:10

administrator   ~0012080

Kindly test the functionality in Oxid Demoshop:
https://demoshop.oxid-esales.com/professional-edition/

Also please send screenshots where the articles in different orders gets added together.
Thanks.

mario_lorenz

2017-05-10 16:16

developer   ~0012083

The best way is, if i can send to you a anonymus DB-Dump of the order-DBs. Or is it possible to send a PM via Mantis?

QA

2017-05-10 16:28

administrator   ~0012084

Any or all information regarding the bug has to be attached to this page. This will help any person who works on the bug to get all the required info.

Also if I understand the issue correctly, the added up articles will be listed in the Shop admin view. A few screenshots of the articles in the admin view and the original order in the frontend view should help us understand the issue better.

Important: Kindly confirm if the bug is reproducible in the Oxid Demoshop.
Thanks

mario_lorenz

2017-05-11 09:32

developer   ~0012085

Ok, i try to explain. In the screenshot "orders_list", you can see the order from 23.04.2017 18:40.

It looks, that the customers orders 2 x "Fauna...". But if you click in the orders_details (see screenshot "orders_details") you see, that the customer orders only 1 x "Fauna ...". (The same happens with the order 23.04.2017 16:41).

I´ve looked to the table "oxorderarticles". I found two rows with the "Fauna..." article. One from the order descriped before, and one from another correct order.

You can reproduce it, by ordering the same article with two different accounts, so that you´ve two orders in the backend. Then have a look at the list order. You see one of the orders, with 2 items of the same article.

Here my temporary solution:

When you have a look to the method:

List_Order->_prepareWhereQuery

You see, that you group the listing-SQL-Result by oxorderarticles.oxartnum

$sQ .= " group by oxorderarticles.oxartnum";


I´ve fixed it, by overloading the method with my own grouping:

$sQ .= " group by oxorder.oxid, oxorderarticles.oxartnum";

So i have the correct order, with the correct count of articles by order.

QA

2017-05-11 10:38

administrator   ~0012086

Thanks for the clear explanation. The scenario that you have explained is the intended behaviour. Kindly check the info under "Bestellübersicht" in the URL: https://www.oxid-esales.com/de/support-services/dokumentation-und-hilfe/oxid-eshop/betrieb/bestellungen.html

The Bestellübersicht/Order Summary will show all articles that have been ordered across different orders. It shows a statistic of ordered articles. For example, if one article, say Art1 is ordered 1 each in Order1, Order2 and Order3, then Bestellübersicht will display the quantity of Art1 and the amount displayed will be 3(total Art1 ordered in all orders)
Hence closing the issue.