China Factory Database and Android App

Encerrado Postado Jul 8, 2014 Pago na entrega
Encerrado Pago na entrega

Freelancers Located in China ONLY please.

We currently have an Android app and website system to track the flow and speed of products in our factory. We want to remake our entire system to allow for more expansion and better user interaction.

What we currently have and need redone:

Android app that allows users to login. Each user is designated a "Location" in the factory, after login the user is able to scan QR codes. The app scans QR codes and updates the database of the time it passed each location. There are 10 total locations, 7 of them only record the time it was scanned. 1 (Repairs) only records how many times it was scanned, because it is potentially scanned multiple times at this location. Another location (QC) also records QC issues the item had, example, transit damage, paint chip, assembled wrong etc. The last location (Container) records everything scanned that day and puts in into a separate file on the website called "(Date) Container Loading List"

The website creates QR codes for each line of an excel file we upload. We upload a new excel file for each order we get. When the items are scanned the database then creates 4 different reports:

1. Daily scan report: reports on how many cubic meters and quantity have been scanned in each location.

2. Weekly Scan Report: Reports the average amount of time the items took between each location.

3. Container scan report displays where each container is located, in %.

4. The QC location also records issues with the item and creates a report for the issues over a certain time period and displays it in a graph.

What we want in addition to the above:

We want to create an extensive database for all our models that includes bill of materials and the time it takes to be manufactured. The time it takes to be manufactured will be derived from the last 2 times we made the item. It will average the last 2 times we made it and give us the time it takes in each factory department.

We want to be able to search and sort the bill of materials to see how many of each component we need from Date 1 to Date 2. Or in Containers 1-10 For example.

For certain locations we want a prompt on the app to force the user to take a picture of the item or to complete a checklist. We want this customized so we can decide which locations, and what check list to complete. It may also be decided not just on the location but also on the model of item. For example, all ABC-001 need to complete a ABC-001 check list at X, Y, and Z locations.

Add another user called "Management" but this is not a location. When a QR code is scanned it displays the items information as well as the time it was in each department. So it is basically the same report as the weekly report but it is only for this one item. This location doesn't record anything, its for management to be able to walk through the factory and do spot checks to see how long items are taking in each department. But it does have the option to Flag the item and take a picture of it.

Also add a user that can access the site but only view it, and admin can select what can be seen. No data can be changed by this user.

We currently use excel and macros to create slips to attach to each item, but we want to site to create these along with the BOMs (Bill of materials) and component slips (these have a picture and dimensions of each component). Attached is an example of them.

For the site, we want 2 versions, an English version, and a Chinese version. Both identical in function and data.

You are welcome to build off what we currently have or start from scratch. We want it to be very functional, customizable, easy to use, and good looking. I will happily give more information, answer any questions and show you the current site so you can better understand our needs.

Android Desenvolvimento de Banco de Dados JavaScript MySQL Design de Sites

ID do Projeto: #6162480

Sobre o projeto

21 propostas Projeto remoto Ativo em Aug 14, 2014

21 freelancers estão ofertando em média $2362 nesse trabalho

monster816

A proposal has not yet been provided

$3092 USD in 20 dias
(26 Comentários)
7.1
nuprogramer

We are interested in developing the app for you. We have some questions to discuss. Can we discuss them in detail? Regards, Nuprogramer

$3472 USD in 45 dias
(35 Comentários)
6.3
andrewrick25

Hello, We are glad to see your project post and we wish you a success for your project. we are USA based IT firm,and we are dealing with direct clients til now. on the part of business we are connecting with clients Mais

$2631 USD in 28 dias
(19 Comentários)
6.8
cloudappteam

Hi there, we are very interested with this project and inviting you to discuss further. Cost: Option 1: Build this as a Phone-Gap app using HTML 5, JQuery, Angular JS, PHP and MySQL. This will be a universal app run Mais

$1200 USD in 35 dias
(15 Comentários)
6.3
TopCSharp

Dear sir I have experiences for 4+ years on ANDROID and iOS. I am very interesting your job and can do perfectly. Please give me this project. Looking forward to award from you. Best regards

$3000 USD in 20 dias
(28 Comentários)
5.7
chinbochen

Hello, I'm an experienced java, J2EE web application developer. I'm very happy to get this project done for you. Ping me if you are interested. Thanks, Rick

$6842 USD in 30 dias
(9 Comentários)
5.3
jaytishah

Dear Sir, I have read your project description and would like to work on this project. I have experience of 3 years in this field

$777 USD in 20 dias
(0 Comentários)
0.0