ULab

update charging tab to allow user to specify charge rates per day or per hour.

May only need to be an interface change, can keep storing rate as per hour in database, would then need a way to show 'day rate' back to user after saving.

update project codes
- add FEC/nonFEC field
- add application date

update project import to include these

update booking settings to add in second 'internal' charge rate

update BIF report to check if project code is FEC/nonFEC and use corresponding 1st/2nd internal charge rate.

[all completed, needs testing]

FA upgrade from v4 to v6
- add new .css
- add new webfont folder (cf 'font' in v4)
- update inc_head to include new path and shim for v4 compatability

working on DEV, move to LIVE soon.

Bath need a report that lists all users (name, email address) of a facility filtered by date.

Added a .csv export to the charging.php tool

- export user list .csv from group page
- add multi-checkbox option to delete all/expire all users

Allow
- group import/export
- bulk delete/expire users

group add allows duplicates

update service orders to allow kit owner to specify number of items instead of duration/time. Store in booking data, using 1 minute per item (should give 60*24=1440 per day, 40k+ per month which should be sufficient to allow recording of usage.

Need to update BIF report to show items instead of hours?

Need to update make_bookable > charging to allow for per item cost?

Add jquery datatables lib to add filter etc. as it has memory

working on DEV, needs testing/refining.

note: the page can take a while to load - look to improve performance of numInvoicedBookings function?

bug - the filter was pranging the _SESSION used to do the multi=1 report, resulting in the multi report attemptign to generate the BIF for everything, causing an out of memory error. Fixed using JQuery to capture hidden ID_ in the table and only including the values that are visible in the filtered table.

Manage groups of similar equipment so a user can book 'any one of' a group of similar equipment. For example, user may want to book any bench or any workstation from a set rather than a particular item.
[complete on DEV]

Allow equipment manager to copy booking settings between items in equipment group.
[completed on DEV]

[all on live]

logic part-reversed/broken on charging.php if user ticked only include confirmed check-box.

email field was restricted to 40 char. Extended to 250 and fixed truncated username/emails

lapse of project codes restricted to editor/owner of project code.

updated to allow admin or fin users too.

add a 'charge per hour' box to sundry items
update the invoicing/BIF tools add this additional charge rate
— this will allow equipment to be run at 'basic rate' plus multiple optional 'per hour' add-ons by getting the user to select the 'operation mode' using a sundry item.

update lab with flag to turn on/off service orders [completed on DEV]
creates a link on lab page to service orders tool
a) single service order addition [completed on DEV]
b) bulk upload [in progress]
- instrument specialist gets listing of username + duration of use (hours) from equipment (.csv/excel) [optional col 3 for project code?]
- copy/paste upload into ULab
- code checks for default project code for each username (lookup to project_code_members)
– if user has single entry, use it
– if user has no entry —> flag to user posting data
– if user has multiple entries, use first in list –> flag?

allow user to 'edit' the posted data to correct any issues (list all projects in dropdown, missing project - lookup for projects to enter?)

once completed –> submit
→ data into booking_instance [additional data from equipment booking_object… need object_ID, start_time, end_time, title (service order), booked_by (username), project_code]
→ email to finance?

Give access to org admins to their own users for editing/updating

check org_admin settings and scope/tools available

crate cron job to check project codes that are nearing expiry date and email PI - check with Bath on when this is sent (1 week before?)

email address/ PI not changing on project_codes.php

project_email is different field from owner. System is saving change to 'owner' (PI), but is displaying principal_name and project_email no owner name/email.

list all bookings that havent been approved
- across all equipment.
- by project code
- select columns for output on report?

lever ESG power ratings from equipment to generate reports for:

power usage by equipment [done]
power usage by lab [done]
power usage by department
power usage by institution

compare to admin reporting to generate graphs etc.

need to improve performance [looking at data aggregation table or partitioning]

allow for some way to record if user finishes using kit early or late and to reflect that in the booking

non-approved bookings appearing in BIF report

need example of where this is happening to investigate

night vs day charge rates

extend BIF report to allow selection of data from multiple labs

user can change end time of booking to cross into 'busy' time e.g. if free busy is set to be only free from 08:00 to 22:00, user can create a booking 21-22:00 then edit it change it to 21:00-23:00.