An example of a Drupal LIMS system

Hi all, since this is my first post in this new group I wanted to start a discussion based on an example site I already made.

I work for a company named INTRON BV (The Netherlands) at which I'm a business developer. In my spare time when I'm not inventing new solutions for construction related problems I'm developing some internal drupal sites.

Attached are some screenshots of an internal dutch Drupal LIMS system with which laboratory samples are managed. The system is called DIF and it functions as follows:

General overview:

• Our certification department registers a project which some basic input fields like: customer, address, type of project, etc.
• To this project several assessment aspects can be added
• Depending on how many aspects have been added to the project, the system produces task lists for our laboratory department
• Once the tasks have been completed, the project manager can close the project upon generating (by the system) a pdf report including all the results of the tasks and the standard information

Drupal related overview:

• Once a project is saved it creates an automatic node title using the auto_nodetitle module. The title itself has a prefix (DIF) and a unique number (based on how many projects have already been registered).
• As I mentioned before to this project several assessment aspects can be added, these aspects are all nodes which the user can create. In the project node the user can add these using a node reference field (CCK).
• When a project including assessment aspects is saved the system creates new child nodes (laboratory tasks) using the node_hierarchy module
• By using the print module I'm able to generate custom-made pdf reports in the language the user specifies.

Other features:

• Financial overviews
• Status overviews in the form of battery pictures, a full battery means that a project is finished. I managed to get this working using custom sql queries and dropped that code in a specific page.tpl.php file
• Generating 3 of 9 barcodes for the samples, upon scanning the barcode the user is linked to the specific node

Main modules I used:

• Auto nodetitle
• CCK
• Computed field
• Contemplate
• Node hierarchy
• Print
• Token
• Views

Currently the system is running and at the moment I'm working on improving the looks (by writing and developing a custom theme). Although for this system the looks are of minor importance it should still look good, at least that is my opinion.

Maybe this example is useful for generating new ideas.....If you have any questions please do not hesitate to reply on this post.

For security reasons I wiped out the names of our customers in the screenshots, but I think it will still show some of it major features.