I'm upgrading our intranet to OpenACS in a couple of weeks, and in the process of importing the hours logged in the old ACS intranet, I've run across this issue:
The old hour logger had the ability to associate a billing rate with an hour entry.
I can't really figure out a way to accomplish this same thing in logger.
I see two possibilities:
- add in logger_variables for each of the different rates, and when importing, make sure I enter them as each of those variables.
- modify logger in some way to add this functionality in. Looking at logger, I'm not really sure the best way to do this. The great thing about logger is that it is generic enough to track many different types of variables: time, hours, etc.. So I'm not sure what the cleanest way to do this would be.
The logger_variable table looks like this:
=# \d logger_variables;
Table "public.logger_variables"
Column | Type | Modifiers
-------------+------------------------+-----------------------------
variable_id | integer | not null
name | character varying(200) |
unit | character varying(200) |
type | character varying(50) | not null default 'additive'
package_id | integer |
We need to be able to run reports monthly where we summarize their total bill, and they could be billed at multiple rates.
Perhaps we could add a column:
secondary_unit
and secondary_function which would by default be ''multiply'', but could also be ''divide'', or some other options.
Any thoughts on this? I have until the end of the week, so I'm on a pretty tight deadline for this.