Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
1 Vastaa
1914 Näkymät

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
Hylkää
Paras vastaus

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
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
2
maalisk. 24
2311
1
syysk. 25
227
1
toukok. 25
1377
1
maalisk. 25
1320
0
helmik. 25
1601