All Projects

https://www.ulabequipment.com/equipment.php?ID=6506

had a booking on 26/10/2025 18:00 to 00:00 that wasn't displaying so user couldn't delete it. Booking was immediately after booking from 08:00 to 18:00. Changing the end time to 23:00 or earlier will make the booking display again.

Fixed for user by manually deleting from the database so they can run BIF report

same happens on DEV:
https://www.dev.ulabequipment.com/booking/weekview.php?object=3889 (view 26th Oct 2025)

add tool that allows users to generate BIF report using analysis code - use substring of internal ID on each equipment item e.g.
CRFCTMSS0001

User may want all CRFCTMSSxxxx equipment bookings
→ generate BIF

Can re-use charging.php
- add new branch to _GET['lab'] / _GET['object'] / _GET['multi'] to check for _GET['analysis_code']
- rest of code should work without too much modification

need page/tool to get user to select analysis code substring to generate the BIF

Bath have non-Finance users who want to have a 'list' view of all bookings on an item of equipment, including the project code. Need ability to modify the project code in the list - driven by need to update any/all TMP_UNKNOWN project codes used at time of booking to actual project codes at month end prior to running BIF report.

Would be useful for other users to have a list view of bookings?

add budget cap to project codes that would restrict booking on that project code if budget cap is exceeded. Need to consider how to calculated budget (all bookings made to date?) and whether there is any buffer/range over cap would be allowed; include monthly spend vs annual/total spend?

add option to allow users to set fixed booking times e.g. 9-13:00, 13:00-17:00, would need to take account of min/max booking duration.

Might be possible using slight changes to free/busy options, as can almost achieve this with using free/busy to restrict bookings to 09-17:00 and then setting min/max bookings to 4 hours - but user can still book 10-14:00 just now.

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 [x]
- add application date [x]

update project import to include these [x]

update booking settings to add in second 'internal' charge rate [x]

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

tested and moved to live [x]

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. [done]

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