Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
المشروع
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

Cron for updating kanban color based on date condition

cronjob

1 الرد

4149 أدوات العرض

Nicholas Wright

Hey, so we are trying to implement a andon system in our kanban view depending on a date field.

If the date is within 90 days we need it to be one color,

If the date is within 60 days we need it to be a different color,

if the date is within 30 days we need it to be a different color.

Ive created a cron in the model that runs with no errors however it isnt actually updating any values.

Is there somthing im missing here, thanks!

@api.model

def cron_andon_color_set(self):

today = fields.Date.today()

contracts = self.env['account.analytic.account'].search([('x_contact', '!=', False),('date_end','!=',False)])

for record in contracts:

if record['date_end'] != False:

end_date = fields.Date.from_string(str(record['date_end']))

if today-timedelta(days=90) <= end_date <= today:

record['x_color'] = 1

elif today-timedelta(days=60) <= end_date <= today:

record['x_color'] = 2

elif today-timedelta(days=30) <= end_date <= today:

record['x_color'] = 3

else:

#Kinda broke if we get to here

record['x_color'] = False

Nicholas Wright

الكاتب أفضل إجابة

Solution:

    @api.model
    def cron_andon_color_set(self):
        contracts = self.env['account.analytic.account'].search([('x_contact', '!=', False),('date_end','!=',False)])

        for record in contracts:
            current_date = fields.Date.today()
            end_date = fields.Date.from_string(record['date_end'])
            difference = int((current_date - end_date).days)

            if difference >= 0:
                #We have passed this date
                record['x_color'] = 1
            else:
                #In the future
                flipped_difference = difference * -1
                if flipped_difference > 90:
                	#More than 90 days
                	#Blue
                    record['x_color'] = 4
                elif flipped_difference <= 90 and flipped_difference > 60:
                    #Between 90 and 60
                    #Green
                    record['x_color'] = 8
                elif flipped_difference <= 60 and flipped_difference > 30:
                    #Between 60 and 30
                    #Orange
                    record['x_color'] = 2
                else:
                   	#Less than 30
                    #Red
                    record['x_color'] = 1

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Cron action not work automatically just manually cronjob	1 أكتوبر 23	3211
Updating records when triggered in a ir.cron job تم الحل cronjob	1 أكتوبر 21	6756
Schedule Action code is not working in odoo 18 تم الحل cronjob odoo18	1 نوفمبر 25	8261
Event loop hell Cron Job when override run with a seconds unit automation cronjob	0 مارس 24	2743
How to Auto Cancel and Recreate Sale Order with Cron Schedule on Odoo 17? sale cronjob	0 يناير 24	77

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!