Hello,
I’ m trying to write program for the company i work full/time as a graphic designer.
Going to use MongoDB and restfulApi(Asp.net web api)
We have 4 different kind of proccess types on our company.
Cutting(2 Machine) with different operations.
Printing(3 Different Machine) with different operations.
Lamination(1 Machine) with different operations.
We also have graphic design service.(1 Office) with different operations.
Different printing machine operation has smiliar printing colors such as CMYK / Pantone / Black
Our work orders has one customer, multiple operations such as;
**
WORK ORDER
**
{Order Number}
{Order Start Date / Deadline Date / Finish Date)
Customer (Company A) =>
SUB ORDER 1
Graphic Design on Graphic Office
(Which has designer named Designer A == Employee A)
{Design type: Standart}
{Design piece : 1}
{Order Number}
{Order Start Date / Deadline Date / Finish Date)
SUB ORDER 2
Printing Mold Design on Graphic Office
(Which has designer named Designer A == Employee A)
{Printing mold machine: Printing Machine A}
{Number of printing molds : 4}
{Mold colors : C/M/Y/K}
{Is molds billable : true}
{Order Number}
{Order Start Date / Deadline Date / Finish Date)
SUB ORDER 3
Printing on Printing Machine 1
(Which has technician named Technician A == Employee B)
{using Material A in Warehouse A (Material Owner name == Company A)
{Printing type : CMYK}
{Printing piece : 4.000}
{Fnished goods : 3980}
{Order Number}
{Order Start Date / Deadline Date / Finish Date)
SUB ORDER 4
Lamination on Lamination Machine 1(Which has technician named Technician B == Employee C)
{Lamination type : Glossy uv lacquer }
{Lamination piece : 3.980}
{Fnished goods : 3950}
{Order Number}
{Order Start Date / Deadline Date / Finish Date)
SUB ORDER 5
Cutting on Cutting Machine 1(Which has technician named Technician C == Employee D)
{Cutting piece : 3950}
{Cutted goods : 3900}
{Order Number}
{Order Start Date / Deadline Date / Finish Date)
When i submit this order, it should create 5 different work orders inhouse for our company.
We have customers which we manufacture operations for them. They send us materials such as paper, dye, varnish. We are using their materials in our company to manufacture / print for them.
We would like to track our manufacturing in beetween dates how many operation we did, how much cost us, how much money we gained. Also filter for technician / operation manager has given more money.
How many we produce for each customer.
What kind of data architecture will be good for us. Can u guys help me design / developt my first project. Thank you.