mirror of
https://github.com/OCA/stock-logistics-warehouse.git
synced 2025-01-21 14:27:28 +02:00
247da988cd
* Any child_ids changed on a children_ids should recompute locations: otherwise only 2 levels are updated. * Flush any change in the hierarchy before executing the SQL
46 lines
1.4 KiB
Python
46 lines
1.4 KiB
Python
# Copyright 2020 Camptocamp SA
|
|
# License AGPL-3.0 or later (https://www.gnu.org/licenses/agpl)
|
|
from odoo import api, fields, models
|
|
|
|
|
|
class StockLocation(models.Model):
|
|
|
|
_inherit = "stock.location"
|
|
|
|
children_ids = fields.Many2many(
|
|
"stock.location",
|
|
"stock_location_children_ids",
|
|
"parent_id",
|
|
"children_id",
|
|
compute="_compute_children_ids",
|
|
store=True,
|
|
help="All the children (multi-level) stock location of this location",
|
|
)
|
|
|
|
@api.depends("child_ids", "children_ids.child_ids")
|
|
def _compute_children_ids(self):
|
|
query = """SELECT sub.id, ARRAY_AGG(sl2.id) AS children
|
|
FROM stock_location sl2,
|
|
(
|
|
SELECT id, parent_path
|
|
FROM stock_location sl
|
|
) sub
|
|
WHERE sl2.parent_path LIKE sub.parent_path || '%%'
|
|
AND sl2.id != sub.id
|
|
AND sub.id IN %s
|
|
GROUP BY sub.id;
|
|
"""
|
|
self.flush(["location_id", "child_ids"])
|
|
self.env.cr.execute(query, (tuple(self.ids),))
|
|
rows = self.env.cr.dictfetchall()
|
|
for loc in self:
|
|
all_ids = []
|
|
for row in rows:
|
|
if row.get("id") == loc.id:
|
|
all_ids = row.get("children")
|
|
break
|
|
if all_ids:
|
|
loc.children_ids = [(6, 0, all_ids)]
|
|
else:
|
|
loc.children_ids = [(5, 0, 0)]
|