试着写了下,不知道能不能给你提供思路
ws_list = WoocommerceShoporderModel.objects.filter(
shop_id = '5',
transaction_id != '',
(Q(order_type is None) | Q(transaction_id != '')),
fulfillment_status != 'fulfilled'
)
new_ws = WoocommerceShoporderModel.objects.none()
for ws in ws_list:
wi = woocommerce_shoporderitem.objects.filter(
order_id=
ws.id,sku_id !=None,is_retail != True)
item2_count = Item2Model.objects.filter(order_id=
ws.id,sku_id!=None).count()
item1_count = ItmeModel.objects.filter(
sku_id != None,
is_retail != True,
order_id=
ws.id,
status__in=[3,4]).count()
if wi and (item1_count != item2_count):
# 这个写法不一定对,太久没用忘了怎么写了
new_ws |= [ws]