解析Bug #432
v3.0: When updating orders in batches, the order update_time is not updated
Added by Zhongbao Ye about 1 year ago.
Updated about 1 year ago.
Target version:
IT: Easytryck (Sweden) - v3.0
Description
Task Details
- When updating order status in batches, the update_time of the order table is not updated.
- When updating some order products, can you update the order ID only once?
Input
Output
Others
- Subject changed from v3.0: When updating order status in batches, the update_time of the order table is not updated to v3.0: When updating orders in batches, the order update_date is not updated
Output(2024/10/11) 九亭
- Solution: Commit ID (OTS): f9a162b1af71c4e0e455de439004136ec6e73c8a
When updating order products in batches, update the order update_time at the same time.
- Batch update order status = any order status
- Batch update order status = sent to retailer
- Note:
The order update time is not updated when deleting order products in batches
- Subject changed from v3.0: When updating orders in batches, the order update_date is not updated to v3.0: When updating orders in batches, the order update_time is not updated
- Status changed from 新建 to 已关闭
- % Done changed from 0 to 100
- Description updated (diff)
- Status changed from 已关闭 to 进行中
- % Done changed from 100 to 90
- Status changed from 进行中 to 已关闭
- % Done changed from 90 to 100
Output(2024/10/14) 九亭
Task Detail 2: Commit ID: b6761f2837e64a1c018cc40911a6d664d383c041
- Bugfix: After batch updating orders, multiple sub-orders of the same order are not sorted together.
- Reason: The default order sorting rule is: ORDER BY o.update_time DESC, op.update_time DESC.
When some sub-orders are updated in batches, the same orders cannot be sorted together.
- Solution: Modify sorting rules:
Old: ORDER BY o.update_time DESC, op.update_time DESC
New: ORDER BY o.update_time DESC, op.order_id, op.update_time DESC
- When updating orders in batches, only update the order once when updating order products in a loop.
Also available in: Atom
PDF