Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
1 Odpowiedz
1735 Widoki

I need to calculate the salary based on meters installed per day just if that day the calculationof the total meters cost is higher than the base salary per day. Meter cost is fixed.

Example:

Monday 70 meters

tuesday 60 meters

Wednesday 20 meters

Thursday 100 meters

Friday 80 meters


Day cost: 500

Meter cost: $20

(70*20)+(60*20)+(20*20)+(100*20)+(80*20) :: (1400>500:1400)+(1200>50:1200)+(400<500:500)+(2000>500:2000)+(1600>500:1600)::

(1400)+(1200)+(500)+(2000)+(1600)=6700

Awatar
Odrzuć
Najlepsza odpowiedź

I recommend opting for the creation of a custom model for the following reasons: First, consider configuring a model with two fields, namely "Day Cost" and "Meter Cost." This configuration provides flexibility for future adjustments. You can either keep these values static or modify them as needed.


Next, build a second model to define the daily meter readings for each employee, including the date of travel. This model serves as a record to track all journeys. Lastly, incorporate a custom field in the payroll module to retrieve data based on the new journey model. By following these steps, the computation of relevant data will occur automatically, and you also have the option to switch to a batch model if required.


If you need further assistance, please feel free to contact me at Mohit Nakrani, mohit@axialtek.co.uk.


Best regards,

Mohit Nakrani

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
2
mar 24
2157
1
maj 25
998
1
mar 25
1191
0
lut 25
1391
1
gru 24
1828