Đang Thực Hiện

150063 PHP/MySql Warehouse Mngmt Sys

Project Overview:

Skills: HTML, PHP, MySQL, JavaScript

The selected party will complete the last 20 or so files in the internal admin system of a PHP/MySql based warehouse management system for 3rd party logistics companies. They will also:

- integrate all the files into the completed system

- error check all files (including existing files)

- clean up the look and feel of the entire system

- create approximately 20 new files as described below.

- and complete JavaScript error checking for other existing files.

There are between 50 and 60 files in the system now so there will be between 70 and 80 files or so in the complete system.

Upon the successful completion of this work there are two other major steps to this project that the winning party will be given high preference for.

The winning party will provide both an estimate of the cost and time to complete this project and, for possible additional work in the future, an hourly rate.

Each bidding party should provide examples of their previous work.

Please visit the project at the address below and familiarize yourself with the system before bidding.

Project URL: [url removed, login to view]

Login Barcode: 1234567890

Please find the attached sql file for reference.



The winning party will be selected no later than Thursday July 12, 2007. The project needs to be delivered by 5pm CST on Tuesday July 17, 2007 but this date may be negotiable BEFORE the project starts. All work/files should be delivered as soon as completed via a provided FTP account and regular email updates should be provided 2-3 times daily.


Files: (The look and feel of these screens should look like the existing screens.)

Add, Edit and List Customers (Companies - defined in the Customer Table)

Add, Edit and List Customer Users (As defined in the CustUser Table)

Add, Edit and List Inventory Items (As defined in the Item Table)

Inventory item history and current location screens

(inventory items are defined in the item table and item instances are tracked in the BarCodeItemJoin tables)

Add, Edit and List Locations (as defined in the Location table)

Equipment Join Screen w/ Items and Locations

Add, Edit and list customer requests

Add, Edit, list and print Orders and Pick Tickets (Order, OrderLine and PickTicket tables)

The control variable that causes updating must be named $process.

The variable "$HiddenControlVars" must be printed in each form.

Every link must include the variable named $ControlVars

Screen designs that are questionable should be approved before coded.


Project Struncture:

[url removed, login to view] is a login screen. After a successful login the user is redirected to MagiaWMS.php.

After [url removed, login to view] verifies the user it opens the appropriate file in the /ControlStructs folder.

(See /ControlStructs/[url removed, login to view] for an example)


Some Common Functions that already exist: ([url removed, login to view])

BarCodeExists ($barcode, $table = '', $id = '')

Checks to see if a barcode provided in $barcode exists in the system. Returns a zero (0) if not.

$table can be used to check an existing table in the system by setting the variable's value to the name of the table.

The possible table names are: Employee, Equipment, Location, BarCodeItemJoin, PickTicket

if $id is provided a value greater than zero and a table name is provided in the $table variable then the system will

return a value of zero (0) even if that barcode exists if the record it exists for exists in $table and has the unique id

of $id.

StorePhone ($var)

Strips all non numeric characters from the variable $var for storage.

ShowPhone ($var)

Formats the phone number sent as $var in a standard way.

StateList ($selected = '')

Populaes the options of a select list with the names of the States in the United States.

EmployeeList($id = "")

Populates the options of a select list with the names of the employees.

The value of each option is the employees unique id.

if the variable $id is provided that employee will be selected.


prints the employee name of the employee with an employeeid of $id


Database access class. [url removed, login to view]

A database class named $DB_Conn is created by the system control files. The functions of this class include:

Query ($query)

Performs the requested query on the database


Returns the unique id that was assigned by the last insert request sent by the Query function.


Returns the error number mysql set for the last call to Query if an error was generated.


Returns the error text mysql set for the last call to Query if an error was generated.


Returns the number of rows affected by the last query sent by the Query function.


There is a simple ajax class located under the library/ajax directories. Its use can be seen in the file located at shared/[url removed, login to view]

Kĩ năng: AJAX, Bất kì công việc gì, CSS, Javascript, MySQL, PHP

Xem nhiều hơn: tickets work com, tickets at work, sql inventory system, shared variable, project management hourly rate, project list in php, print w 9, printed names, php mysql create, php is, php ajax sql, names designs, named query, mysql inventory management, mysql customer database, look php id, it companies use php, hourly rate to edit, find possible employees, find new employees, find employees names, find an employees, find an employee by employee id, example of inventory database, employee find

Về Bên Thuê:
( 2 nhận xét ) Florissant,

ID dự án: #1896242

Được trao cho:


Hiya, I can do this for ya. Sent a PMB for further details!

$280 USD trong 7 ngày
(0 Đánh Giá)