Enable banks to be able to retrieve inventory item counts across different timeframes

[edwinthinks]

Summary

We've been asked on numerous occasions to be able to give banks the ability to know how much of what item they had at a given point in time. Unfortunately, we don't currently have the tools or system in place to be able to service this request. Therefore we should include the system and tools to be able to do this.

See below in the Criteria for Completion on what steps we may need to take.

Things to Consider

This won't be able to figure out what item counts were in the past. This would only start taking affect after this has been released

Criteria for Completion

• Add https://github.com/paper-trail-gem/paper_trail gem
• Store changes in JSONB so that querying is easier if we wanted to use SQL directly
• Update InventoryItem to paper trail or track when it is created, updated, or discarded.
• Add a new page where bank users can see the inventory count at different time frames across all storage locations. You can probably use version_at method shown in paper trail's README.
• Backfill all InventoryItem records to have an initial audit or paper trail record for the current time.

[edwinthinks]

@albertchae would you be interested in taking this issue? Since I believe you said you had experience working with auditing or paper trail.

[edwinthinks]

@albertchae any updates on this issue? I've noticed that this is coming up more often. Let us know if we can support on this.

[albertchae]

@edwinthinks Hey sorry for the silence on this issue. I have most of the setup with papertrail done, but need to finish out the page where bank users can view their inventory. I'll probably go with something simple first so we can get something out and then iterate on it.

[edwinthinks]

@albertchae no worries, thoughts on using the storage location view page for this? Might work nicely without having to add a new page that needs to be discovered and I suspect that is the most likely place they'd use the feature in.

[edwinthinks]

@albertchae thoughts on seeing if we can release the paperclip gem and integration in advance before the page gets created? I figure we can start collecting historical data and then think about showing it later.

What do you think?

[albertchae]

@edwinthinks sounds good on trying the storage location page. And I agree with your second comment too and put up what I have so far as a PR #2448

[github-actions]

This issue has been inactive for 3994 hours (166.42 days) and is past the limit of 360 hours (15.00 days) so is being unassigned.