Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
1775 Tampilan

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
Buang
Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
2
Mar 24
2191
1
Mei 25
1012
1
Mar 25
1200
0
Feb 25
1407
1
Des 24
1840