PharmaLedger-IMI / acdc-components

UC4 Anti-Counterfeiting Data Collaboration
MIT License
3 stars 4 forks source link

FGT integration #30

Open joaoluis-pdm opened 2 years ago

joaoluis-pdm commented 2 years ago

From #21

We would like to make the Product Status availability from FGT? (check 4) actually a real on-line check. Is it possible to integrate this now or soon from the FGT environment?

joaoluis-pdm commented 2 years ago

Although current ePI and FGT environments are lead by distinct teams, and have no common products and batches, it should be possible to write a small demo.

Proposal: On the detailed information of a particular scan event, ( URL https://acdc-dev.pharmaledger.pdmfc.com/backoffice/event/ae06686e-d142-4212-9328-f8b7a6df2c48 ) , add an extra option that calls an traceability request on one of FGT MAH's REST services API.

joaoluis-pdm commented 2 years ago

Bump version to v0.9.0 on all acdc-components/ modules, specially to illustrate a need for DB upgrade.

joaoluis-pdm commented 2 years ago

Architecture and sequence diagram for internal review.

joaoluis-pdm commented 2 years ago

Deploy to acdc-dev complete.

joaoluis-pdm commented 1 year ago

Mutate the latest events to match ALPV1.

acdc TST:

-- eventdId a1494ad0-e755-44fa-9847-e82f47e15d6d "createdOn": "2022-09-09T17:03:01.633Z"
acdc=> update eventinput set eventinputdata='{"productCode":"02113100000028","batch":"ALPV1","serialNumber":"93342708522623", "expiryDate":"290620","snCheckDateTime":"2022-07-17T13:41:39.121Z","snCheckLocation":{"latitude":42.242979,"longitude":-3.658588},"did":"AcdcEventDataGenerator","batchDsuStatus":true,"productDsuStatus":false}' where eventinputid='05ed621a-bcac-4d8f-9493-cd9096521a91';

acdc=> UPDATE appresource SET value='https://api-mah-bayer-fgt-dev.pharmaledger.pdmfc.com/traceability' WHERE key='fgt.url';

acdc=> UPDATE appresource SET value='Onfvp GHSVZwHkZmZ5ZwR5ByEbnKZkp1A1L2uOHmAwqKWyHTSmp3pjpzD=' WHERE key='fgt.authorization';

acdc=> UPDATE appresource SET value='0.9.1' WHERE key='acdc.version';

acdc DEV:

-- eventdId ae06686e-d142-4212-9328-f8b7a6df2c48 "createdOn": "2022-08-23T10:58:15.122Z"
acdc=> update eventinput set eventinputdata='{"productCode":"02113100000028","batch":"ALPV1","serialNumber":"93342708522623", "expiryDate":"290620","snCheckDateTime":"2022-07-17T13:41:39.121Z","snCheckLocation":{"latitude":42.242979,"longitude":-3.658588},"did":"AcdcEventDataGenerator","batchDsuStatus":true,"productDsuStatus":false}' where eventinputid='fe006e8e-8310-4004-890f-cef5223337ac';

acdc=> UPDATE appresource SET value='https://api-mah-bayer-fgt-dev.pharmaledger.pdmfc.com/traceability' WHERE key='fgt.url';

acdc=> UPDATE appresource SET value='Onfvp GHSVZwHkZmZ5ZwR5ByEbnKZkp1A1L2uOHmAwqKWyHTSmp3pjpzD=' WHERE key='fgt.authorization';

acdc=> UPDATE appresource SET value='0.9.1' WHERE key='acdc.version';

Both environments point to https://fgt-dev.pharmaledger.pdmfc.com for the time being.

9a3ec40c87875f256e35e99a83f519794049d55b

v0.9.1 default URLs have changed from MSD to Bayer