From b2456c9c70d059baad14103d2691b8c51d752263 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Mon, 6 Oct 2025 11:59:20 +0700 Subject: cleansing useless sale order --- fixco_custom/models/sale.py | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) diff --git a/fixco_custom/models/sale.py b/fixco_custom/models/sale.py index c6e9ccb..6912796 100755 --- a/fixco_custom/models/sale.py +++ b/fixco_custom/models/sale.py @@ -194,4 +194,13 @@ class SaleOrder(models.Model): for order in self: order._check_duplicate_order_id() res = super(SaleOrder, self).action_confirm() - return res \ No newline at end of file + return res + + def _clean_sale_order(self): + orders = self.env['sale.order'].search([ + ('invoice_status', '=', 'no'), + ('state', '=', ['draft', 'sale']) + ], limit=2000) + for order in orders: + print("cancel sales or draft "+order.name) + order.action_cancel() -- cgit v1.2.3 From 3ee99b28535aaf54770f426473c4bad4b34f9430 Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Mon, 6 Oct 2025 14:15:27 +0700 Subject: fix error --- fixco_custom/models/sale.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/fixco_custom/models/sale.py b/fixco_custom/models/sale.py index 6912796..1d80abb 100755 --- a/fixco_custom/models/sale.py +++ b/fixco_custom/models/sale.py @@ -199,7 +199,7 @@ class SaleOrder(models.Model): def _clean_sale_order(self): orders = self.env['sale.order'].search([ ('invoice_status', '=', 'no'), - ('state', '=', ['draft', 'sale']) + ('state', 'in', ['draft', 'sale']) ], limit=2000) for order in orders: print("cancel sales or draft "+order.name) -- cgit v1.2.3 From f55504662c191b2ed89773fde521d9006c15d3ee Mon Sep 17 00:00:00 2001 From: stephanchrst Date: Tue, 7 Oct 2025 15:04:40 +0700 Subject: change cleansing so status --- fixco_custom/models/sale.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/fixco_custom/models/sale.py b/fixco_custom/models/sale.py index 1d80abb..33c0ab0 100755 --- a/fixco_custom/models/sale.py +++ b/fixco_custom/models/sale.py @@ -198,7 +198,7 @@ class SaleOrder(models.Model): def _clean_sale_order(self): orders = self.env['sale.order'].search([ - ('invoice_status', '=', 'no'), + # ('invoice_status', '=', 'no'), ('state', 'in', ['draft', 'sale']) ], limit=2000) for order in orders: -- cgit v1.2.3