We have a basic Perl script which displays our current inventory from a MySQL database. The script is currently functional, but we are looking to better organize the data. An HTML snapshot of the current screen is attached. We would like the following changes made:
1.)We need the ability to define categories (such as “Standard Smart-UPS” or “Smart-UPS XL” on the current screen) and then to determine which individual model numbers belong in each of those categories. The list of categories and which units are in which category should both be stored in the MySQL database. We can update the database manually since we rarely get new units or need to define new categories.
2.)We need to improve the sorting of the model numbers. Right now, it is an alphabetical sort on the model number, which ends up putting a su700 below an su5000, even though the 700 should be above the 5000.
3.)Regardless of whether or not an inventory item is assigned to a category, it must be displayed on the page. A “unassigned” category where all unassigned units are displayed can fulfill this requirement.
4.)Probably most important, we have several units that have different model numbers, but are actually the same unit. For reasons of accuracy, we need to keep the model numbers unchanged in the database, but we would like to have them be displayed on the same line. For example, a “dl1400” is exactly the same unit as a “su1400bx120”. In the attached screenshot, we currently have 2 of the dl1400, and 37 of the su1400bx120. Instead of displaying those on two separate lines, we need to have it display 39 of the su1400bx120's. We can manually maintain a table in the MySQL database of “aliases” if needed.
5.)We would like to make the page look a little nicer and perhaps be more printer friendly. It doesn't need to be great looking, since we are the only ones who use it, but perhaps a CSS style sheet to clean up the tables would be nice. We would like each line to alternate between white and a very light gray.
Things to be aware of:
1.)For our more common units, we have a “target” inventory specified, which is displayed if there is one. If we have a unit with a target specified, but have 0 quantity, we still want those lines to show up on the inventory report even though they have a quantity of 0. This is already programmed in, but may need to be adapted if the code changes significantly.
2.)We also have a table with units that are “on hold” for customers. If a unit(s) is on hold for a customer, those units are not reflected in the available quantities (and there is a (+1 on hold) next to the quantity on the report.) This is already programmed in, but depending on how the code is edited, this functionality may need to be updated to work with the new code.
Hello, I have worked with perl for about 9 years and MySQL for about 8. These alterations should be fairly straight forward and definitely something I can complete for you.