Closed

From scratch PLM-ERP hybrid software (web based)

For our small engineering company we need a lightweight hybrid system (up to 10 users) somewhere between PLM and ERP. The system should be webbased and will be installed on our local network server. The system has a database backend (mysql, postgres sql....) The Data Structure is as the following:

- Table0: items (about 15 columns)

contains all items with several information like

ID

delevery time

supplier

price

if it is a single part or assembly

if its a assambly it shows the related billOfMaterials ID

- Table1: Projects (about 15 columns)

contains information like

ID

customer

bill of material

-Table2: billOfMaterials (about 10 columns)

contains a number of item Ids

-Table3: customers (about 5 columns)

contains all customers and related information like

ID

Name

Adress

Person

Email Adress

-Table4: suppliers (about 15 columns)

contains all suppliers and related indormation like

ID

Name

Adress

Person

Email Adress

-Table5: users

contains user credentials and further information about the users

-Table6: roles

contains the roles and the related information for "user-role management"

The logic behind the system is the following:

A project has exacly one bill of materials.

This bill of materials contails a number of items.

Some of these items have a bill of materials too some not.

This bill of meterial contains items again and so on...

The project information containing the calculated delivery time for the hole project and the aggregated costst based on the used items.

The first operational view is a simple list of all items in a project. Every item is only shown only once with the aggregated quantity. It is possible to sort and filter every column eg. for supplier.

Possible CSV export.

The second operational view is a graph where all items are displayed on the y axis and the delevery time on the x axis. In option A the delivery time bars are starting at the current date and ending at thier specific deleverydate, calculated from today. In option B the delevery time bar of the item with the longest delevery time starts today and all other items are starting at the end of this bar and going backwards. (see figures attached)

At the beginning we need 8-9 Views in total. The other 6 views are showing the 6 Database tables and contain a "add", "edit" and "delete" Button.

Please contact me for further information.

Skills: MySQL, Software Architecture, Java, SQL, Frontend Development

See more: bluetooth marketing software web based, erp asp ajax web based, software web based printable coupon database, magento erp open source web based, raffle software web based, php loan modification software web based, legal collection software web based, complaint management software web based free, job assignment software web based, chat software web based, converter software web based em desktop, mlm software web based, computer management software web based, accounting software web based java, repair credit software web based, bid solicitation software web based, mobile marketing software web based

About the Employer:
( 1 review ) Weinstadt, Germany

Project ID: #27944518

16 freelancers are bidding on average €803 for this job

seekdeveloper

Hi, I have read your post and understood your requirement. Looking for the freelancer to work on your next project? Or just need some issues/bugs/fixes ASAP? I have 11+ years of software experience in fortune 500 comp More

€500 EUR in 7 days
(59 Reviews)
8.2
ayesha0124

Hello there, How are you doing? Just saw your project posted. I read the brief details and I felt I could help you with it. Lets start the chat and discuss it in detail. Please check my porfolio and reviews on my prev More

€750 EUR in 12 days
(7 Reviews)
5.2
(22 Reviews)
5.4
contactsapphire

- Lightweight hybrid system, somewhere between PLM and ERP. - Get 8+ year experienced PHP developer who is proficient in MySQL, Bootstrap, JavaScript, HTML, jQuery, Graphic design, Angular, etc. I'm part of an 18-yea More

€1500 EUR in 20 days
(3 Reviews)
6.0
(7 Reviews)
5.1
babitabubu

Hi, I have read your job brief and understand it. I will build you a PLM-ERP hybrid software system from scratch as per your job brief. I have built many software systems before so can meet your job specifications acco More

€3000 EUR in 20 days
(9 Reviews)
4.7
lisovetskyibv

Hi, How are you? I read your proposal carefully and I understood what you want. I can build hybrid app for you and your business. I am very interested in your project and I can complete correctly. I have enough skills More

€800 EUR in 20 days
(2 Reviews)
4.1
maks52andr

>>>>>>>>> There will be MIRACLE when you BELIEVE <<<<<<<<< Hello, My name is Maksim and Web Developer. I have read your details interestingly and I can do your project in short time. As you can see on my review, I am More

€250 EUR in 6 days
(8 Reviews)
4.2
engrkhanzain

For previous experience you please see my profile in which you see core java, software development and different server working. I try my best to complete your work ASAP. I am not asking you for any type of payment unt More

€750 EUR in 21 days
(23 Reviews)
4.6
eyadbas

Dear Sir! I've seriously went through your post and I have understood what you need. I am sure that I can be the best candidate who is able to perfectly complete this project From scratch PLM-ERP hybrid software (web b More

€555 EUR in 6 days
(1 Review)
1.9
pashyaa

Hi, there. Hope you are doing well. I understand the requirement of project. I can develop web-based application using Java + MySQL (Backend) and (React or Bootstrap+jQuery) Front-end. I've 10+ Years of experience in F More

€750 EUR in 10 days
(1 Review)
1.1
carsanro

Hi there. I am a passionate Fullstack developer with 12 years of experience. I have great experience in PHP, HTML, Javascript and Java. I can fulfill all requirements to the fullest. Can we discuss more detail on priv More

€500 EUR in 7 days
(0 Reviews)
0.0
vadimdev8

Hello, how are you? I have rich experience with Website development so i am confident that i can provide you goo dservice. Plase send me a message to discuss further. Thank you and best regards.

€500 EUR in 7 days
(0 Reviews)
0.0
diaraimova

Hi, there Nice to meet you. Here is Diana. I understood full your requirement. I am very familiar with PLM and ERP system. Your requirement is very clear for me. let's discuss more in chat. Thank you

€500 EUR in 7 days
(1 Review)
0.1
DenisKolm

[login to view URL] are you? I can build website with crud, csv downloading and visuable chart perfectly. I have rich experience in this field. Best regard. Thank you

€300 EUR in 3 days
(0 Reviews)
0.0
arajesh456

Hello, I am working as a PLM consultant & Developer. I have extensive PLM experience over 10 years and worked on items/parts, BOM Structures, Integration between PLM & ERP systems. I understood your requirements. Ple More

€1200 EUR in 20 days
(0 Reviews)
0.0