Requirement : Perl + MySQL
Update data to 2 mysql server in different location (discuss)
Optional Splash screen.
Login using https after login go back to http.
Disallow hot-link.
Not allow user access webpage without login. And DO NOT allowed to modify URL to access other page even after login.
eg. [login to view URL] is prohibited
SQL Injection is prohibited too.
Only PC with valid control key can access to the system. This is something like a registry for PC. (discuss later)
All modules control by CGI::Sessions (no cookies), DBI, Image::Magick and necessary libraries.
Optional CGI::CRUD, CGI::FormBuilder, CGI::Ajax, jquery, jquery-maskedinput
CSS is a must.
Able Export to csv or other common format / print to PDF
Able to create Data Dictionary for reference.
Invoice / Detail data entry. Print to Blank / Pre-printed form with Different page length / width & Barcode.
To keep [login to view URL] as small as possible, each program must have their own cgi name. Eg. [login to view URL] (sub customer) for customer module. When action=customer, include [login to view URL] and run customer().
eg.
if ($action="" || $action="login") { include "[login to view URL]"; login(parameters);};
if ($action="customer") {include "[login to view URL]"; customer(parameters)};;
if ($action="user") {include "[login to view URL]"; user(parameters);};
...
Make Data Entry a module. I can use it when new table added.
Menu is read from a table. That means I can add item when necessary.
## Deliverables
* * *This broadcast message was sent to all bidders on Wed. May 18, 2011 11:09:54 AM:
mysoftsys changed the ExpertRating requirements on this project from:
JavaScript 1.3 Test
MySQL 5.0 Test
CSS 2.0 Test
Accounts Payable Test
Accounts Receivable Test
Inventory Management Test
HTML 4.01 Test
CSS 3 Test
JavaScript 1.8 Test
Perl Programming Skills Test (Hands-on programming skills)
HTML 5 Test
To:
Inventory Management Test
* * *This broadcast message was sent to all bidders on Wed. May 18, 2011 11:12:52 AM:
mysoftsys changed the ExpertRating requirements on this project from:
Inventory Management Test
To:
MySQL 5.0 Test
Linux Test
Perl Programming Skills Test (Hands-on programming skills)