Issue 10792

Title
Add lot traceability view
Priority
feature
Status
resolved
Nosy list
ced, pokoli, reviewbot, roundup-bot, udono
Assigned to
ced
Keywords
review

Created on 2021-09-24.15:40:19 by pokoli, last changed 2 months ago by roundup-bot.

Messages

New changeset 54817318a430 by Cédric Krier in branch 'default':
Add lot traceability
https://hg.tryton.org/tryton-env/rev/54817318a430
New changeset 6b5f97da147a by Cédric Krier in branch 'default':
Add lot traceability
https://hg.tryton.org/modules/stock_lot/rev/6b5f97da147a
New changeset f9b4c7fcdd86 by Cédric Krier in branch 'default':
Add lot traceability
https://hg.tryton.org/modules/production/rev/f9b4c7fcdd86
Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2022-02-07.22:39:24

Indeed my comment about using table_query is not good because it will require for the database to scan all the moves which is not good for a growing table like stock_move. But also the current proposal as the same problem by joining the table with itself.
In fact it is better to compute the downward and upward traces in Python just for the displayed moves.
Here is review387871002 which implement a new model based on stock.move and compute the downward and upward traces. The benefit is that it works also if production is not activated (and replace the existing moves relate). And thanks to the contextual menu, user can follow the trace for a specific lot from a production.
By the way I did not implement a scenario because the code is mainly about definition of model which is executed by the standard module test case.

Author: [hidden] (pokoli) Tryton committer Tryton translator
Date: 2021-09-24.15:41:38

Here is review381061002 implementing it.
It still missing some test suite and minor fixes but all the functionality is there

Author: [hidden] (pokoli) Tryton committer Tryton translator
Date: 2021-09-24.15:40:19
History
Date User Action Args
2022-03-19 22:45:09roundup-botsetmessages: + msg74619
2022-03-19 22:45:04roundup-botsetmessages: + msg74618
2022-03-19 22:44:57roundup-botsetmessages: + msg74617
nosy: + roundup-bot
status: testing -> resolved
2022-02-07 23:03:42reviewbotsetmessages: + msg73926
2022-02-07 22:39:24cedsetassignedto: pokoli -> ced
component: + production
messages: + msg73921
nosy: + ced
reviews: 381061002 -> 381061002,387871002
2021-12-14 18:00:39reviewbotsetmessages: + msg72541
2021-11-02 10:49:23reviewbotsetmessages: + msg71479
2021-10-20 17:59:40reviewbotsetmessages: + msg71142
2021-09-29 12:03:56reviewbotsetmessages: + msg70504
2021-09-27 12:32:09udonosetnosy: + udono
2021-09-24 15:53:13reviewbotsetmessages: + msg70390
nosy: + reviewbot
2021-09-24 15:41:38pokolisetkeyword: + review
messages: + msg70389
reviews: 381061002
status: in-progress -> testing
2021-09-24 15:40:19pokolicreate