This repository contains some simple scripts used for tracking building and facility at the Leddy Library at the University of Windsor. The count.php script produces a form as shown:

There are a couple of variables that need to be set for MySQL credentials, the tables used by the script are in tables.sql. There are tables which are used to track LibCal activity, these designate what kinds and types of resources are being tracked.

The status.php script is used to provide status information. The output is in JSON and looks like:

{"total":27,"limit":350,"bookings":[{"space_id":0000,"category":"PCs","counter":9,"capacity":10},{"space_id":0000,"category":"Rooms","counter":4,"capacity":5},{"space_id":0000,"category":"Desks","counter":10,"capacity":20}]}

This can be used with a javascript widget for displaying ongoing capacty status.

The report.php script can be used for statistics. It shows the numbers for the current day by default and can be used to export all of the dates.

art rhyno ourdigitalworld/cdigs