Build a website for intranet use for data entry of our production
€30-250 EUR
Paid on delivery
We are a greek company repacking fertilizers in small packets.
We want to create a program in HTML in order to be accesible from tablets and PC in our production sites.
This program will receive data from our SQL server using our Intranet.
The user of the website will be the production worker.
This project will be completed in two STAGES and we would like to have offers for these two different stages:
Data entry will be done using two different ways:
============== STAGE 1 (1st way of making the data entry): ==============
1) Make a data entry for an already completed production.
a) The user will scan or type the workers that participated in this production
b) The user will choose the production site
c) The user will scan the produced unit
d) System will show details about the product and let the user type the quantity that we produced and type how many minutes or hours this production took.
e) See the reccomended materials that our SQL view is suggesting, and write a comment if you disagree with some of them.
d) Complete the production data entry and store the information in an SQL table.
============== STAGE 2 (2nd way of making the data entry): ==============
2) Make a data entry while the production is being made
a) The user will scan the workers that will participate in this production
b) The user will choose the production site
c) Scan every product they produce and make a sum up while we are producing it at the top of the screen
If we scan a product that is not similar to the previous one then we should notify the user that he made a mistake.
Because this way is a real time data entry, the user should be able to pause the production and resume in after his brake
d) Pause the production / Continue the production
e) Complete the production
f) See the reccomended materials that our ERP is suggesting, and write a comment if you disagree with some of them
============== Comments: ==============
This website should read data from our SQL views for:
Workers (code, name, picture)
Products produced (code or barcode, product description, picture, measurement unit)
Calculate the materials that we used using an SQL view that we will multiply with the produced quantity
This website should write date in one SQL table:
Create a unique number of production (this number should be calculated when we transfer the data on our SQL server)
Production site
Employee codes that participated in the production
Date of production
Code of product that we produced
Quantity of products that we produced
Total minutes that we made the production (only for stage two, stage one will leave this blank)
Comments of this production
and insert to an SQL table data of each production.
In our server we use
SQL 2019
Windows server 2019
Project ID: #30530497
About the project
Awarded to:
Hi, I have over 14 years of industry experience in ASP.net, C#, VB.net, SQL Server, Oracle and MySQL. I have gone through the project details and can complete this project in 2 weeks. Thank You Farooq
27 freelancers are bidding on average €177 for this job
I can create a program in HTML in order to be accesible from tablets and PC in our production sites. I have read your whole description and i want to ask you some questions related to this work.
Hi, I can build your website for internet use for data entry production. I'm PHP Developer thinking out of the box. I have 7 years of experience in PHP Web Based Application Development. Pure PHP developments of any le More
Hi, I am Ahmed from Gaza, living in Turkey We are an integrated team working in several fields like building a website, and apps building apps, creating videos and designs. We have 8 years of experience in technology. More
Hello there. I’m Isha Mahmood, a Professional and Expert Software Engineer.I will build you a website according your requirements. I am interested in doing this job for you. Ready to start the project. Looking forward More
HI! I am an expert web programmer. I am familiar with Laravel and I have a lot of work experience in Laravel, Codeigniter, PHP, Wordpress, JavaScript, HTML, Vuejs, Reactjs, React Native, and MySQL. I can start right aw More
Hi nice to meet you. I have read all your project description and can start working asap on it. Since most of my interest is developing good and secure projects, I must say that because you only wish tou use html/jav More
I have 11+ year working experience in SharePoint, O365 during this i have worked for multinational client's with quality delivery. I have good working experience in SPFX, Power App, Power automate, Power BI,Powershell, More
