We need a simple to use and to drive softwaresystem to trace which material is where in stock and which were the the movements of this material. The system should provide a simple to use search facility, extremely simple to use facilities to perform store in and store out, intended for use on a mobile device ( android based smart phones) equipped with hardware barcode scanner , screens for request of stock in /stock out and simple reports on the data which are created.
The stocking method we intend to use is “random stock keeping, which means in our case that we only want to identify containers which are labeled with a 1-D barcode and the actual location of the container, which are identified also with 1-D barcodes but of a different name scheme.
The core tracking information is created with the stock in functionality : simply record which container barcode can be found at which stock location = its barcode. Every physical transport and stockout must be recorded, so a complete tracking is possible.
The description of the containers will consist of several catchwords used also in other IT systems , a freetext field describing the content of the container and one to several photos.
To enhance the quality of the catchwords, table lookups must performed. The contractor has to implement lookup tables in the database he creates, the contents of these tables will be populated by the buyer.
Brief list of functions / tasks to perform
- database design
- complete design of the software, must be agreed with buyer and will be binding for the further steps
- design of several HTML GUI screens
- HTML Gui is ajaxified with jquery, use of several autocomplete fields with table lookups on different tables
- Android App or HTML Gui to enter barcodes and take photo(s) on mobile device
- upload of photos/ files, creation of thumbnails
- programming in PHP of the functions
* Stock in / Stock out
* Request for Stock in / Stock out
* Search on ware in stock
* History of movements
- simple authorization handling and interface for authorization management
- user authentication against Active Directory
- user documentation
- Admin documentation
Software must be realized with royalty free components only, other than special components agreed with the buyer
Complete and exclusive rights on the works/ code are at buyer
Please see detailed Specification