Add calculated fields to Loan

[tlammer]

From @grantfitzsimmons:
Loan has a number of calculated fields:

• totalPreps - Count of all associated loan preparations records
• totalItems - Count of all associated collection object preparations records
• unresolvedPreps - Count of all loan preparation records that are not resolved
• unresolvedItems - Count of all collection object preparation records that are not resolved
• resolvedPreps - It is the result of totalPreps - unresolvedPreps
• resolvedItems - It is the result of totalItems - unresolvedItems

These need to be visible and functional when added to the form. These are in the default form definition for Loan.

Relevant Specify 6 code:
https://github.com/specify/specify6/blob/945d28f00288d2d64979848fb2fb63fda34bdd1b/src/edu/ku/brc/specify/datamodel/Loan.java#L807-L838

Original comment by @tlammer:

The latest version of specify 6 added calculated fields, similar to the ones in Loan, to Gift, Accession, and Exchange Out. The fields are blank in Specify 7

[maxpatiiuk]

See also #1009

[grantfitzsimmons]

@benanhalt Can you use the changes for the accession, preparation, and collectionobject calculations to solve this?

[benanhalt]

To a certain degree. I still need to go into 6 and see what the actual calculations are and replicate them in 7.

[bronwyncombs]

Reported by Corinna as CSIRO:

I am just playing around with the accession form and I am trying to display the object count with a label of 'Total databased' (3rd row highlighted). My CO count for this accessionID is currently 12 - in the form it displayed 55. So I ended up pasting all the count fields from the original form back in to see what's happening (the red bracketed section), and I only see the '55' value against the 'total current Items' label. I suspect that includes a count of preps as well? At any rate, why are the other three count fields not populating and how can I get the count of the collection objects displayed? Any thoughts?

[grantfitzsimmons]

From my comment:

Specify 7 supports the actualTotalCountAmt calculated field, but as Bronwyn mentioned, we do not support the other fields included on the default Accession form (totalCountAmt, preparationCount, or collectionObjectCount )

The count field you are looking for to give a sum of all collection objects is unfortunately the collectionObjectCount field rather than the actualTotalCountAmt field which sums the counts of all preparations in the list of associated collection objects.

See on Asana

[sharadsw]

Looks like this already got added at some point after this issue was created.

This is on KU_VertPaleo_1_11_23 (edge):

KU_Fish_Tissue (edge) has them under shipments: