sale_manual_delivery

у sale-workflow · джерело на GitHub

Create your deliveries manually

Категорія: Sale · Camptocamp SA · AGPL-3

2026-09-10 14:38:43,524 1 INFO job_581091ce1eae odoo.addons.base.models.ir_module: ALLOW access to module.button_install on ['Sales'] to user __system__ #1 via n/a
2026-09-10 14:38:43,763 1 INFO job_581091ce1eae odoo.registry: Registry changed, signaling through the database
2026-09-10 14:38:43,767 1 INFO job_581091ce1eae odoo.modules.loading: Module stock_delivery loaded in 2.27s, 818 queries (+818 other)
2026-09-10 14:38:43,767 1 INFO job_581091ce1eae odoo.modules.loading: Loading module sale_manual_delivery (71/71)
2026-09-10 14:38:43,821 1 ERROR job_581091ce1eae odoo.sql_db: bad query: b"\nupdate sale_order_line as sol set qty_procured = r.qty_procured,\nqty_to_procure = sol.product_uom_qty - r.qty_procured\nfrom (select sol.id, sum(\n    case\n        when (\n        sl.usage = 'customer'\n        and sm.origin_returned_move_id is null\n        or (\n        sm.origin_returned_move_id is not null and sm.to_refund\n        )) then\n            ROUND(\n                ((sm.product_uom_qty / sm_product_uom.factor) * sol_product_uom.factor),\n                SCALE(0.01)\n                )\n        when (\n        sl.usage != 'customer'\n        and sm.to_refund\n        ) then\n        ROUND(\n                ((sm.product_uom_qty / sm_product_uom.factor) * sol_product_uom.factor),\n                SCALE(0.01)\n                ) * -1\n        else 0\n    end)\n AS qty_procured\nfrom\nsale_order_line as sol\ninner join (\n    select sol.id, sm.id as move_id, sm.location_id, sm.location_dest_id\n    from sale_order_line as sol\n    left join stock_move as sm on (\n        sm.state != 'cancel'\n        and sm.scrap_id is null\n        and sol.product_id = sm.product_id\n        and sm.sale_line_id = sol.id\n        )\n) as q on q.id = sol.id\nleft join stock_move as sm on sm.id = q.move_id\nleft join product_product as pp on pp.id = sol.product_id\nleft join product_template as pt on pt.id = pp.product_tmpl_id\nleft join stock_location as sl on sl.id = q.location_dest_id\nLEFT JOIN uom_uom sm_product_uom ON sm.product_uom = sm_product_uom.id\nLEFT JOIN uom_uom sol_product_uom ON sol.product_uom_id = sol_product_uom.id\ngroup by sol.id, sm.product_uom, sol.product_uom_id\n) as r\nwhere r.id = sol.id\n    "
ERROR: column sm.scrap_id does not exist
LINE 34:         and sm.scrap_id is null
                     ^

2026-09-10 14:38:43,824 1 WARNING job_581091ce1eae odoo.modules.loading: Transient module states were reset
2026-09-10 14:38:43,825 1 ERROR job_581091ce1eae odoo.registry: Failed to load registry
2026-09-10 14:38:43,826 1 CRITICAL job_581091ce1eae odoo.service.server: Failed to initialize database `job_581091ce1eae`.
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 1559, in preload_registries
    registry = Registry.new(dbname, update_module=update_module, install_modules=config['init'], upgrade_modules=config['update'], reinit_modules=config['reinit'])
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 67, in locked
    return func(inst, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3/dist-packages/odoo/orm/registry.py", line 222, in new
    contextvars.Context().run(
  File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 446, in load_modules
    load_module_graph(
  File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 179, in load_module_graph
    getattr(py_module, pre_init)(env)
  File "/mnt/pool/sale_manual_delivery/hook.py", line 18, in pre_init_hook
    cr.execute(
  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 418, in execute
    self._obj.execute(query, params)
psycopg2.errors.UndefinedColumn: column sm.scrap_id does not exist
LINE 34:         and sm.scrap_id is null
                     ^

2026-09-10 14:38:43,828 1 INFO job_581091ce1eae odoo.service.server.ThreadedServer: Initiating shutdown
2026-09-10 14:38:43,828 1 INFO job_581091ce1eae odoo.service.server.ThreadedServer: Hit CTRL-C again or send a second signal to force the shutdown.
2026-09-10 14:38:43,829 1 INFO job_581091ce1eae odoo.addons.bus.websocket: Disconnecting 0 websockets
2026-09-10 14:38:43,930 1 INFO job_581091ce1eae odoo.sql_db: ConnectionPool(read/write;used=0/count=0/max=64): Closed 1 connections

2026-09-18 11:54:06,528 1 INFO job_1ba10f6b312f odoo.addons.base.models.ir_module: ALLOW access to module.button_install on ['Sales'] to user __system__ #1 via n/a
2026-09-18 11:54:06,777 1 INFO job_1ba10f6b312f odoo.registry: Registry changed, signaling through the database
2026-09-18 11:54:06,780 1 INFO job_1ba10f6b312f odoo.modules.loading: Module stock_delivery loaded in 2.85s, 914 queries (+914 other)
2026-09-18 11:54:06,781 1 INFO job_1ba10f6b312f odoo.modules.loading: Loading module sale_manual_delivery (71/71)
2026-09-18 11:54:06,830 1 ERROR job_1ba10f6b312f odoo.sql_db: bad query: b"\nupdate sale_order_line as sol set qty_procured = r.qty_procured,\nqty_to_procure = sol.product_uom_qty - r.qty_procured\nfrom (select sol.id, sum(\n    case\n        when (\n        sl.usage = 'customer'\n        and sm.origin_returned_move_id is null\n        or (\n        sm.origin_returned_move_id is not null and sm.to_refund\n        )) then\n            ROUND(\n                ((sm.product_uom_qty / sm_product_uom.factor) * sol_product_uom.factor),\n                SCALE(0.01)\n                )\n        when (\n        sl.usage != 'customer'\n        and sm.to_refund\n        ) then\n        ROUND(\n                ((sm.product_uom_qty / sm_product_uom.factor) * sol_product_uom.factor),\n                SCALE(0.01)\n                ) * -1\n        else 0\n    end)\n AS qty_procured\nfrom\nsale_order_line as sol\ninner join (\n    select sol.id, sm.id as move_id, sm.location_id, sm.location_dest_id\n    from sale_order_line as sol\n    left join stock_move as sm on (\n        sm.state != 'cancel'\n        and sm.scrap_id is null\n        and sol.product_id = sm.product_id\n        and sm.sale_line_id = sol.id\n        )\n) as q on q.id = sol.id\nleft join stock_move as sm on sm.id = q.move_id\nleft join product_product as pp on pp.id = sol.product_id\nleft join product_template as pt on pt.id = pp.product_tmpl_id\nleft join stock_location as sl on sl.id = q.location_dest_id\nLEFT JOIN uom_uom sm_product_uom ON sm.product_uom = sm_product_uom.id\nLEFT JOIN uom_uom sol_product_uom ON sol.product_uom_id = sol_product_uom.id\ngroup by sol.id, sm.product_uom, sol.product_uom_id\n) as r\nwhere r.id = sol.id\n    "
ERROR: column sm.scrap_id does not exist
LINE 34:         and sm.scrap_id is null
                     ^

2026-09-18 11:54:06,832 1 WARNING job_1ba10f6b312f odoo.modules.loading: Transient module states were reset
2026-09-18 11:54:06,833 1 ERROR job_1ba10f6b312f odoo.registry: Failed to load registry
2026-09-18 11:54:06,833 1 CRITICAL job_1ba10f6b312f odoo.service.server: Failed to initialize database `job_1ba10f6b312f`.
Traceback (most recent call last):
  File "/opt/odoo/odoo/service/server.py", line 1520, in preload_registries
    registry = Registry.new(dbname, update_module=update_module, install_modules=config['init'], upgrade_modules=config['update'], reinit_modules=config['reinit'])
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/odoo/odoo/tools/func.py", line 67, in locked
    return func(inst, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/odoo/odoo/orm/registry.py", line 222, in new
    contextvars.Context().run(
  File "/opt/odoo/odoo/modules/loading.py", line 449, in load_modules
    load_module_graph(
  File "/opt/odoo/odoo/modules/loading.py", line 179, in load_module_graph
    getattr(py_module, pre_init)(env)
  File "/mnt/pool/sale_manual_delivery/hook.py", line 18, in pre_init_hook
    cr.execute(
  File "/opt/odoo/odoo/sql_db.py", line 418, in execute
    self._obj.execute(query, params)
psycopg2.errors.UndefinedColumn: column sm.scrap_id does not exist
LINE 34:         and sm.scrap_id is null
                     ^

2026-09-18 11:54:06,838 1 INFO job_1ba10f6b312f odoo.service.server.ThreadedServer: Initiating shutdown
2026-09-18 11:54:06,838 1 INFO job_1ba10f6b312f odoo.service.server.ThreadedServer: Hit CTRL-C again or send a second signal to force the shutdown.
2026-09-18 11:54:06,838 1 INFO job_1ba10f6b312f odoo.addons.bus.websocket: Disconnecting 0 websockets
2026-09-18 11:54:06,941 1 INFO job_1ba10f6b312f odoo.sql_db: ConnectionPool(read/write;used=0/count=0/max=64): Closed 1 connections

Код модуля на 19.0

Рядки — фізичні, разом із порожніми й коментарями, як wc -l. Тести — файли test_*.py у теці tests/. Моделі — рядки з _name = і _inherit =. Це факти про код, а не оцінка: більше рядків не означає ні краще, ні гірше. Зміряно 2026-08-28 на дереві 127761199cd0.

У каталозі apps.odoo.com є листинг під тією самою технічною назвою на 16.0, 17.0, 18.0, 19.0: apps.odoo.com/apps/modules/19.0/sale_manual_delivery. Збіг назви не доводить збіг коду — як ми це рахували.

Залежить від

Історія

Переклади й коміти ботів у підрахунок не входять.

Результат виглядає неправильним? Повідомте — ми покажемо лог або перепрогонимо. Повідомити про хибний результат

Дізнатися, коли цей модуль змінить стан