Scheduled Reporting - Calculated Date Parameters

Donate to this project

Submitted by tanderson on Mon, 16/07/2018 - 15:34

Development Project Status: Completed

Total cost estimate (ex-Tax):

$660

Due date for completion of this stage:

16/07/2018

Release:

2.1

Current Percentage Funded:

100.00%

Project funding:

You can donate money to this project by entering the amount above and clicking the 'Add to cart' button. In the Checkout process you can either choose to pay now (via Bank Transfer, Cheque or Pay Pal) or you can pledge the amount by choosing the 'Pledge a payment for a Development Project' method. If you make a pledge, then when we have 100% funding commitments, you will be notified by email and you can then action your payment. Note that development will not commence until all funds are received.

Project description:

This project will extend the Scheduled Reporting functionality included in OpenVPMS 2.0 to support calculated date parameters.

This will allow standard OpenVPMS reports to be easily scheduled. Currently these must either:

be modified to calculate the date range to query
have the parameters configured manually, before the report is scheduled to run

For each date parameter, the following list of options will be available:

Today - the current date
Yesterday - yesterday's date
Tomorrow - tomorrow's date
Now - the current date/time
Start Of Month - the first day of the current month
End Of Month - the last day of the current month
Start Of Last Month - the first day of the previous month
End Of Last Month - the last day of the previous month
Date - a specific date, to support the existing behaviour

With the exception of the Now option, the date will be calculated and supplied to the report with a 00:00:00 time component.

User Interface

Each date parameter will have a dropdown next to it, allowing the user to select from one of the above options. If Date is selected, a date-chooser will be displayed to select the date.

Archetype Changes

The entity.jobScheduledReport archetype needs new hidden paramExprType1...paramExprType14 and paramExprValue1...paramExprValue14 nodes to store the expression type and value.
The expression type will be 'date', but could be expanded to support jxpath expressions in future.