NOTE: This repo is archived, read-only access is provided.
This is a chemical inventory suitable for a medium-sized company. A very similar system is actually used in the industry.
Like any inventory, this system is designed to answer two questions:
- WHAT we have
- WHERE it is
Chemicals are structured in categories/subcategories. There are compounds, a compound can have batches and a batch can have many packs. Locationwise you can design laboratories (rooms), inside laboratories different storages (like cabinets, cupboards, fridges, etc.) and inside storages some sub- storages (e.g. shelves of a cupboard). Anyway, you can use any logic, nevertheless there is a 3-tier location system.
Compound, batch and pack management is through the web interface. Locations & manufacturers are stored in the database as well as user right levels, so you can manipulate them with a database management software or plain SQL.
Barcodes are assigned to each pack, so you can use labels for identification in the lab. (barcode printing is not implemented yet in this application)
Uploading the CoA and MSDS documents are possible for each batch.
Adding and editing batches and packs is only allowed for admins. Users can add/edit compounds and upload documents, whereas guests only can view and search the database.
- LDAP authentication
- Three user access levels (guest/user/admin)
- Add/edit compounds, batches and packs
- Inactivate packs when getting empty
- Changelog for audit trails
- Search chemicals with autocomplete
- Generate barcodes
- Drawing chemical structures
- Install a web server (like Apache) with support for PHP5
- Install a LDAP server
- Copy all the source (/src) files to host on your web server
- Setup a MySQL server and import DB_structure.sql
- Edit config.php with your credentials (database & LDAP)
- (optional) Load the database with sample data (DB_sample_data.sql)
GNU General Public License v3.0
This is a free software ;)
If you need more information feel free to contact me: semseysandor@gmail.com