All Projects

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

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?

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]

extend BIF report to allow selection of data from multiple labs

- allow for ULab to collect actual usage data from equipment (kit api?)
- lock equipment unless booking approved?

dig out old comm code from v1?

Create new API to call (Bath) PURE API for equipment
- get all equipment [nearly done]
- put (create) equipment
- get equipment (by ID) [done]
- put update equipment
- get file from equiment (by ID) [done]
- put upload file to equipment (by ID)

- add in PURE tab to allow matching (cf RAM tab for SU) [done]
- create tool to allow list of all ULab Bath kit to compare/match with PURE listing [in progress]

update the equipment forms to allow for new database fields to be managed

update the equipment database table to include additional fields

update show/hide from search to allow for limit search to group, institution, anyone or no-one.

checkbox compulsory not blocking bookings

checkboxes are only 'POST'ed if they are ticked, so will not work as compulsory without a 'hidden' field to compare with. Either add hidden field or convert to select yes/no option