Packing list Generator

  • Posted:
  • Proposals: 4
  • Remote
  • #662839
  • Expired
Gaurav R.Advanced W.Satwinder S.Nilesh R. have already sent a proposal.
  • 1

Description

Experience Level: Intermediate
Estimated Job duration: less than 1 week
General information for the website: We sell textile good
Num. of web pages/modules: Small php application
Description of requirements/features: This is a small php project.

We are a textile company, and we are looking for an application to generate an excel, based on a number of scanned barcodes.

The name of the project is : Packing list generator. A packing list is an excel list which shows a number of items. This document is printed and attached to a certain shipping.

** We need the following views:

- “Packing list” listing
- Listing of “boxes” in a packing list.
- Listing of items, in a box.
- Add items to a box


** We need the following functionality:
- A small menu to go trough the views.
- Create/ delete/ modify packing list.
- Create/ delete/ modify packing list box.
- Add/ delete items from a packing list box

** Special features:
- Packing list info is stores in database number 1
- Barcode info ( Size, model and color from the scanned barcode ) is retrieved from database number 2.
- Users scan barcodes with a barcode reader in the warehouse, or you can input the barcode “manually” in the form. In this instant, the web makes a query on database number 2, to retrieve color/size and other info. This info is displayed for the user, so he check that everything is right, and stored in database number 1.
- User has to be able to keep adding items, without needing to make click on “add a new item”, so ajax or something similar is suggested.
- User has to do click on a button to create a new box, or a new packing list.
- There is the need to “control errors”, in case barcode is not found in database 2, so user has to input another barcode.
- Both database1, and database2, are already implemented, on SQL server.
- Web server is IIS7, with php support.
- After user has finished work, he has to export the packing list to a excel. The excel shows:
+ packing list
+ a row for each item, showing : times scanned ( units ), color, size, model reference, and a few more fields.
+ date of creation of the packing list.
- There are two type of packing list: “return”, and “shipping”.


** Database info ( databases are already created ):
- Datababase 1 ( where packing list are stored ) :
+ packing list table -> packing list box table -> packing list box items table
- Database 2 ( where barcode info is stored) :
+ For each barcode row, there is some info we have to retrieve : color, size, ref model, desc.

** I will you access to both databases
** Hosting is also provided
Extra notes:

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.