Mes system - cycle analysis

[mitjap]

Hello.

i would like to build app for production control. in future i hope to integrete this with sql so i get real time control over machines

this is my problem

Table one: i get this times form Mes cycle data

part number	feature_timestamp	virsifra
300 500	22.09.2021 11:26:34	163
300 500	22.09.2021 11:18:13	163
300 500	22.09.2021 11:08:13	163
300 500	22.09.2021 10:59:53	163
300 500	22.09.2021 10:51:33	163
300 200	22.09.2021 10:43:12	163
300 200	22.09.2021 10:34:52	163
300 200	22.09.2021 10:27:22	163

data from ERP. gives time when part needs to be finished

part number	normative
300 500	9
300 200	7

extra table with status i need for control

status

Late

In time

first cycle

result

part number	feature_timestamp	virsifra	status
300 500	22.09.2021 11:26:34	163	in time
300 500	22.09.2021 11:18:13	163	late
300 500	22.09.2021 11:08:13	163	in time
300 500	22.09.2021 10:59:53	163	in time
300 500	22.09.2021 10:51:33	163	first cycle
300 200	22.09.2021 10:43:12	163	late
300 200	22.09.2021 10:34:52	163	late
300 200	22.09.2021 10:27:22	163	first cycle

If timedifference is less or more as normative for part, correct ststaus shows

Any help is very welcomed