Page Menu
Home
In-Portal Phabricator
Search
Configure Global Search
Log In
Files
F1198367
D532.id1360.diff
No One
Temporary
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Thu, Oct 30, 12:33 PM
Size
1 KB
Mime Type
text/x-diff
Expires
Fri, Oct 31, 12:33 PM (9 h, 48 m)
Engine
blob
Format
Raw Data
Handle
779028
Attached To
D532: INP-1859 - Escape MySQL 8.3 keywords
D532.id1360.diff
View Options
Index: modules/in-commerce/units/orders/orders_event_handler.php
===================================================================
--- modules/in-commerce/units/orders/orders_event_handler.php
+++ modules/in-commerce/units/orders/orders_event_handler.php
@@ -2886,7 +2886,7 @@
""),
"_",
PackageNum
- ) AS Grouping,
+ ) AS GroupingCalc,
SUM(Quantity) AS TotalItems,
SUM('.$table_prefix.'OrderItems.Weight*Quantity) AS TotalWeight,
SUM(Price * Quantity) AS TotalAmount,
@@ -2896,7 +2896,7 @@
LEFT JOIN '.TABLE_PREFIX.'Products
ON '.TABLE_PREFIX.'Products.ProductId = '.$table_prefix.'OrderItems.ProductId
WHERE OrderId = '.$ord_id.'
- GROUP BY BackOrderFlagCalc, Grouping
+ GROUP BY BackOrderFlagCalc, GroupingCalc
ORDER BY BackOrderFlagCalc ASC, PackageNum ASC, ProductType ASC';
$sub_orders = $this->Conn->Query($query);
@@ -2930,7 +2930,7 @@
$sub_order->SetDBField('SubNumber', $next_sub_number);
$sub_order->SetDBField('SubTotal', $sub_order_data['TotalAmount']);
- $grouping_data = explode('_', $sub_order_data['Grouping']);
+ $grouping_data = explode('_', $sub_order_data['GroupingCalc']);
$named_grouping_data['Type'] = $grouping_data[0];
if (!in_array($named_grouping_data['Type'], $skip_types)) {
Event Timeline
Log In to Comment