Ir al contenido
Menú
Se marcó esta pregunta
1 Responder
1732 Vistas

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

Avatar
Descartar
Mejor respuesta

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

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
2
mar 24
2143
1
may 25
970
1
mar 25
1176
0
feb 25
1346
1
dic 24
1811