Perl database script update

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.

Habilidades: Perl

Veja mais: script perl update database, update database perl script, perl script update database, update database perl, table customer, perl get, mysql customer database, how to get cgi, example of inventory database, common current, perl update, perl table import database, perl clean characters script, perl database properties, perl update database, perl table update database, perl linux access database update, perl cgi update database, schedule database update perl, model perl script, smart ups perl script, updating access database via perl cgi script, perl script update database example, script database tables model perl, perl sample script access database

Acerca do Empregador:
( 11 comentários ) Carol Stream, United States

ID do Projeto: #168956

Concedido a:


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.

$125 USD em 4 dias
(1 Comentário)

7 freelancers estão ofertando em média $185 para esse trabalho


Let me help you

$250 USD in 7 dias
(115 Comentários)

I can do job for you. See PM.

$120 USD in 3 dias
(147 Comentários)

Dear Sir, I am experienced Perl developer. I have developed a number of projects by using Perl. Here are the details of projects and sites which I have developed in Perl. 1-SEO Tools. I have developed 15 SEO Tool Mais

$300 USD in 10 dias
(11 Comentários)

messy, but fixable

$150 USD in 5 dias
(1 Comentário)

Hello, please check your PM. Lubos

$150 USD in 5 dias
(1 Comentário)

Hello, over all it is a 4-5 days job. I am keeping a day in hand just to make sure that layout and programming is properly tested before delivery. To start off we need access to your CGI programs and the database. More Mais

$200 USD in 5 dias
(2 Comentários)