تخطي للذهاب إلى المحتوى
القائمة
لقد تم الإبلاغ عن هذا السؤال
1 الرد
1744 أدوات العرض

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

الصورة الرمزية
إهمال
أفضل إجابة

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

الصورة الرمزية
إهمال
المنشورات ذات الصلة الردود أدوات العرض النشاط
2
مارس 24
2161
1
مايو 25
1007
1
مارس 25
1196
0
فبراير 25
1399
1
ديسمبر 24
1835