Project

General

Profile

解析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.

Status:
已关闭
Priority:
普通
Assignee:
Zhongbao Ye
Target version:
IT: Easytryck (Sweden) - v3.0
Start date:
10/11/2024
Due date:
10/11/2024
% Done:

100%

Estimated time:
1.00 h

Description

Task Details
  1. When updating order status in batches, the update_time of the order table is not updated.
  2. When updating some order products, can you update the order ID only once?
Input
  • Daping
Output
  • Report and Solution

Others

#1

Updated by Zhongbao Ye about 1 year ago

  • 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
#2

Updated by Zhongbao Ye about 1 year ago

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
#3

Updated by Zhongbao Ye about 1 year ago

  • 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
#4

Updated by Xihua Fan about 1 year ago

  • Description updated (diff)
  • Status changed from 已关闭 to 进行中
  • % Done changed from 100 to 90
#5

Updated by Zhongbao Ye about 1 year ago

  • Status changed from 进行中 to 已关闭
  • % Done changed from 90 to 100

Output(2024/10/14) 九亭

Task Detail 2: Commit ID: b6761f2837e64a1c018cc40911a6d664d383c041
  1. 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
  2. When updating orders in batches, only update the order once when updating order products in a loop.

Also available in: Atom PDF