PIS is the PASSCAL Inventory System. PASSCAL ships equipment to, and receives it from, all over the world, so it's sort of a big deal. It's all Python and Tkinter and was about 73,000 lines of code when I stopped taking care of it. It started using a MySQL database engine, but later moved to a MariaDB database. These pictures are in no particular order. Some of the forms are sub-forms of other forms. It'll get more organized over time.
The red bar at the top of a form (above) tells the user something on the form may have been changed and the information may need to be saved.
You can click on a dot and it will display information about that experiment, or several experiments if the dots are on top of each other.
There are three Zebra label printers attached to the system. They are loaded with 4x5, 2x1, and 3x1 inch labels. You can print whatever you need to the latter two using this form.
Each piece of equipment that returns from an experiment in the field has a 4x5 inch tag printed up just for it. The tag has checkboxes for the technicians to keep track of which tests have been performed on the piece of equipment, and the results as it is readied to go back into the field on the next experiment.
Each "major" database function (like inventory info, experiment info, addresses, shipments, etc.) have an 'edit' form and a 'list' form. The listing shipments form is the next picture.
All output from the various forms shows up on the main display.
The main form contents can be searched, printed and saved. It's all just text, so it's easy. Now if there were graphics in there...
The history of where each item has been shipped and received is kept.
All kinds of verification routines are built in so whoever is taking care of the database can see how badly the users are messing things up.
Lots of items in the menus depending on your permission level. The following pictures show the all of the possible items.
There usually aren't this many forms open at a time, but you can jump to any one you want if it has been hidden behind others by selecting the form name from the Forms menu.
Help is text files loaded into a reader form.
Most of the forms.
2022-09-12