Usage of operation plan resource to add restrictions to frepple

[zipus]

The same way we can create manufacturing order in confirmed state to don't allow Frepple to plan in that space (With this we have the machinery assigned to confirmed orders).
I want to have confirmed also the employees resources assigned to those orders restricted.
I don't see documented, but I suppose I can define a operationplanresource like:

- reference = operationplan__reference
- resource = "Employee Ben Harper"
- start = same date as operationplan__reference.start
- end = same date as operationplan__reference.end

But in apache logs displays: django.db.utils.IntegrityError: null value in column "operationplan_id" of relation "operationplanresource" violates not-null constraint
So, apart from calendars (which is about company hours and it's not a normal option to create a calendar for each order restricting), how can I restrict to frepple a resource the same way we do in manufacturing order by creating confirmed?

[jdetaeye]

The error message already explains what's not good. Just fill in the operationplan_id with the reference of the manufacturing order.

That tells frepple "we have manufacturing order X and the resources Y and Z are working on it"

[zipus]

I have these 4 confirmed MO:

{"total":1,
"page":1,
"records":4,
"rows":[
{"reference":"production,2673", "computed_color":"0.0", "color":"0E-8", "item__name":"DEMO TABLE", "operation__location__name":"Almac\u00e9n", "operation":"DEMO TABLE", "startdate":"2022-11-17 00:00:00", "enddate":"2022-11-17 08:21:44.331126", "opplan_duration":30104.331126, "opplan_net_duration":30104.331126, "quantity":"1.00000000", "status":"completed", "lastmodified":"2022-11-17 10:21:44.336779", "operation__type":"routing", "operation__sizeminimum":"1.00000000", "operation__priority":"1", "operation__source":"production.routing,2853", "operation__lastmodified":"2022-11-17 10:21:41.112036", "feasible":"True", "operation__item__type":"make to order", "operation__item__uom":"u", "operation__item__source":"product.product,8854", "operation__item__lastmodified":"2022-11-17 10:21:39.616691", "operation__location__source":"stock.location,5", "operation__location__lastmodified":"2022-11-17 10:21:37.343602"},
{"reference":"production,2673/7676", "computed_color":"0.0", "color":"0E-8", "item__name":"DEMO TABLE", "operation__location__name":"Almac\u00e9n", "operation":"DEMO TABLE/Corte", "startdate":"2022-11-17 08:21:44.986839", "enddate":"2022-11-17 08:21:44.986839", "opplan_duration":0.0, "opplan_net_duration":0.0, "quantity":"1.00000000", "status":"completed", "owner":"production,2673", "lastmodified":"2022-11-17 10:21:44.998948", "operation__type":"time_per", "operation__duration_per":3600.0, "operation__sizeminimum":"1.00000000", "operation__priority":"1", "operation__source":"production.routing.step,10275", "operation__lastmodified":"2022-11-17 10:21:42.079631", "feasible":"True", "operation__location__source":"stock.location,5", "operation__location__lastmodified":"2022-11-17 10:21:37.343602"},
{"reference":"production,2673/7677", "computed_color":"0.0", "color":"0E-8", "item__name":"DEMO TABLE", "operation__location__name":"Almac\u00e9n", "operation":"DEMO TABLE/Rectificar", "startdate":"2022-11-17 08:21:45.015612", "enddate":"2022-11-17 08:21:45.015612", "opplan_duration":0.0, "opplan_net_duration":0.0, "quantity":"1.00000000", "status":"completed", "owner":"production,2673", "lastmodified":"2022-11-17 10:21:45.030280", "operation__type":"time_per", "operation__duration_per":7200.0, "operation__sizeminimum":"1.00000000", "operation__priority":"1", "operation__source":"production.routing.step,10276", "operation__lastmodified":"2022-11-17 10:21:42.084021", "feasible":"True", "operation__location__source":"stock.location,5", "operation__location__lastmodified":"2022-11-17 10:21:37.343602"},
{"reference":"production,2673/__union__", "computed_color":"0.0", "color":"0E-8", "item__name":"DEMO TABLE", "operation__location__name":"Almac\u00e9n", "operation":"DEMO TABLE/__union__", "startdate":"2022-11-17 08:21:44.645927", "enddate":"2022-11-17 08:21:44.645927", "opplan_duration":0.0, "opplan_net_duration":0.0, "quantity":"1.00000000", "status":"completed", "owner":"production,2673", "lastmodified":"2022-11-17 10:21:44.657863", "operation__type":"time_per", "operation__duration_per":1.0, "operation__sizeminimum":"1.00000000", "operation__priority":"1", "operation__source":"production.routing,2853", "operation__lastmodified":"2022-11-17 10:21:41.420404", "feasible":"True", "operation__location__source":"stock.location,5", "operation__location__lastmodified":"2022-11-17 10:21:37.343602"}
]}

And have tried to make a post request to operationplanresource with suggested configs:

[
{'id': 'production,2673/7676', 'reference': 'production,2673/7676', 'resource': 'Viktor Valovvy', 'status': 'confirmed', 'startdate': '2022-11-17 12:00:02', 'enddate': '2022-11-17 13:00:02'}, 
{'id': 'production,2673/7677', 'reference': 'production,2673/7677', 'resource': 'Viktor Valovvy', 'status': 'confirmed', 'startdate': '2022-11-17 13:00:02', 'enddate': '2022-11-17 15:00:02'}, 
{'id': 'production,2672/7678', 'reference': 'production,2672/7678', 'resource': 'Viktor Valovvy', 'status': 'proposed', 'startdate': '2022-11-17 15:00:02', 'enddate': '2022-11-17 16:00:02'}, 
{'id': 'production,2672/7679', 'reference': 'production,2672/7679', 'resource': 'Viktor Valovvy', 'status': 'proposed', 'startdate': '2022-11-17 16:00:02', 'enddate': '2022-11-17 18:00:02'}]

or:

[
{'operationplan_id': 'production,2673/7676', 'reference': 'production,2673/7676', 'resource': 'Viktor Valovvy', 'status': 'confirmed', 'startdate': '2022-11-17 12:00:02', 'enddate': '2022-11-17 13:00:02'},
{'operationplan_id': 'production,2673/7677', 'reference': 'production,2673/7677', 'resource': 'Viktor Valovvy', 'status': 'confirmed', 'startdate': '2022-11-17 13:00:02', 'enddate': '2022-11-17 15:00:02'},
{'operationplan_id': 'production,2672/7678', 'reference': 'production,2672/7678', 'resource': 'Viktor Valovvy', 'status': 'proposed', 'startdate': '2022-11-17 15:00:02', 'enddate': '2022-11-17 16:00:02'},
{'operationplan_id': 'production,2672/7679', 'reference': 'production,2672/7679', 'resource': 'Viktor Valovvy', 'status': 'proposed', 'startdate': '2022-11-17 16:00:02', 'enddate': '2022-11-17 18:00:02'}]

None of them worked, the error is the same.
Maybe the problem is about sending string instead of int for the id, but the error is quite specific about null value.

[zipus]

I managed to load through web if the MO reference is a integer.
This is the result:

{"total":1,
"page":1,
"records":1,
"rows":[
{"id":"156989", "resource":"Anayak", "operationplan__reference":"7676", "owner":"production,2673", "color":"0E-8", "operationplan__item":"DEMO TABLE", "operationplan__location":"Almac\u00e9n", "operationplan__operation__name":"DEMO TABLE/Corte", "operationplan__operation__type":"time_per", "operationplan__operation__duration_per":3600.0, "operationplan__operation__sizeminimum":"1.00000000", "operationplan__operation__priority":"1", "operationplan__operation__source":"production.routing.step,10275", "operationplan__operation__lastmodified":"2022-11-17 10:21:42.079631", "operationplan__startdate":"2022-11-17 09:09:26.253295", "operationplan__enddate":"2022-11-17 09:09:26.253295", "opplan_duration":0.0, "opplan_net_duration":0.0, "operationplan__quantity":"1.00000000", "operationplan__status":"completed", "operationplan__type":"MO", "quantity":"1.00000000", "feasible":"True", "operationplan__item__type":"make to order", "operationplan__item__uom":"u", "operationplan__item__source":"product.product,8854", "operationplan__item__lastmodified":"2022-11-17 10:21:39.616691", "operationplan__operation__location__source":"stock.location,5", "operationplan__operation__location__lastmodified":"2022-11-17 10:21:37.343602", "resource__type":"default", "resource__maximum":"1.00000000", "lastmodified":"2022-11-17 11:09:53.387106"}
]}

But the same error keep showing through API with:

[
{'id': '7676', 'reference': '7676', 'resource': 'Viktor Valovvy', 'status': 'confirmed', 'startdate': '2022-11-17 12:00:02', 'enddate': '2022-11-17 13:00:02'}, 
{'id': '7677', 'reference': '7677', 'resource': 'Viktor Valovvy', 'status': 'confirmed', 'startdate': '2022-11-17 13:00:02', 'enddate': '2022-11-17 15:00:02'}, 
{'id': '7678', 'reference': '7678', 'resource': 'Viktor Valovvy', 'status': 'proposed', 'startdate': '2022-11-17 15:00:02', 'enddate': '2022-11-17 16:00:02'}, 
{'id': '7679', 'reference': '7679', 'resource': 'Viktor Valovvy', 'status': 'proposed', 'startdate': '2022-11-17 16:00:02', 'enddate': '2022-11-17 18:00:02'}]

or:

[
{'operationplan_id': '7676', 'reference': '7676', 'resource': 'Viktor Valovvy', 'status': 'confirmed', 'startdate': '2022-11-17 12:00:02', 'enddate': '2022-11-17 13:00:02'},
{'operationplan_id': '7677', 'reference': '7677', 'resource': 'Viktor Valovvy', 'status': 'confirmed', 'startdate': '2022-11-17 13:00:02', 'enddate': '2022-11-17 15:00:02'},
{'operationplan_id': '7678', 'reference': '7678', 'resource': 'Viktor Valovvy', 'status': 'proposed', 'startdate': '2022-11-17 15:00:02', 'enddate': '2022-11-17 16:00:02'},
{'operationplan_id': '7679', 'reference': '7679', 'resource': 'Viktor Valovvy', 'status': 'proposed', 'startdate': '2022-11-17 16:00:02', 'enddate': '2022-11-17 18:00:02'}]

or following /data/input/operationplanresource/?format=json also tried:

[
{'operationplan__reference': '7676', 'resource': 'Viktor Valovvy', 'status': 'confirmed', 'startdate': '2022-11-17 12:00:02', 'enddate': '2022-11-17 13:00:02'},
{'operationplan__reference': '7677', 'resource': 'Viktor Valovvy', 'status': 'confirmed', 'startdate': '2022-11-17 13:00:02', 'enddate': '2022-11-17 15:00:02'},
{'operationplan__reference': '7678', 'resource': 'Viktor Valovvy', 'status': 'proposed', 'startdate': '2022-11-17 15:00:02', 'enddate': '2022-11-17 16:00:02'},
{'operationplan__reference': '7679', 'resource': 'Viktor Valovvy', 'status': 'proposed', 'startdate': '2022-11-17 16:00:02', 'enddate': '2022-11-17 18:00:02'}]

[jdetaeye]

The data examples above are NOT in the correct formats of the proper frepple APIs. You're guessing & messing around (at your own risk) with reversed engineered data from some of our reports.

The ONLY correct interfacing APIs for such data is through:

• either use REST api for "resource detail": https://demo.frepple.com/api/input/operationplanresource/
• either use the csv or excel format when exporting from resource detail screen: https://demo.frepple.com/data/input/operationplanresource/

[zipus]

For any one asking the same in the future, this is my final json load:

[{'operationplan': 'production,2672/7678', 'resource': 'Sierra', 'status': 'confirmed', 'startdate': '2022-11-17T15:00:02+0100', 'enddate': '2022-11-17T16:00:02+0100'},
{'operationplan': 'production,2672/7679', 'resource': 'Afilado HERCAT', 'status': 'confirmed', 'startdate': '2022-11-17T16:00:02+0100', 'enddate': '2022-11-17T18:00:02+0100'}]

Maybe the problem is about sending string instead of int for the id, but the error is quite specific about null value.

False, strings are valid.

The data examples above are NOT in the correct formats of the proper frepple APIs. You're guessing & messing around (at your own risk) with reversed engineered data from some of our reports.

Yes, I was using REST API (post request with the json above) but searching the table definition in the wrong place, I expected to see the operationplanresource table somewhere in table descriptions. Because there, normally I find some more explanations about status and which is the best for each.
While I forgot to look up on API docs, I tried to guess operationplan field which was causing my error because I was trying to use operationplan__reference, operationplan_id, id.
I can see an improvement to create table definition for operationplanresource, mainly to explain his usage and state, as proposed state while is a valid option to load though API, it's unuseful data.