How to call a table outside CLASS within the same .py file using Odoo 12?

    def holiday(lookup_date):
        # check holidays
        
        hday_credit_rate = 0
        
        *****Error below calling the table outside the class****** 
        holidays = env['hr.company.holidays'].sudo().search([('date', '=',                     lookup_date)])

        if holidays:
            holiday_rate = env['hr.holiday.rate'].sudo().search([('id', '=',                             holidays.holiday_rate_id.id)])
            hday_credit_rate = holidays.credited_rate
        
        return hday_credit_rate


class dtr(models.Model):
 _name = 'hr.dtr'
_inherit = ['mail.thread', 'mail.activity.mixin']
 _description = "Daily Time Record"

employee_id = fields.Many2one('hr.employee', string='Employee', required=True)

********start to call the table outside the class 
holiday_credit = holiday('2020/07/03')

Husain Rangwala

Hello gain

If you want to call method from multiple classes in same .py file then declare method as you did above and then you can call method with help of any instance(Object) method.

Example:

def holiday(lookup_date):
    # check holidays
    hday_credit_rate = 0
    *****Error below calling the table outside the class****** 
    holidays = env['hr.company.holidays'].sudo().search([('date', '=',lookup_date)])
    if holidays:
        holiday_rate = env['hr.holiday.rate'].sudo().search([('id', '=',holidays.holiday_rate_id.id)])
        hday_credit_rate = holidays.credited_rate
    return hday_credit_rate
class dtr(models.Model):
    _name = 'hr.dtr'
    _inherit = ['mail.thread', 'mail.activity.mixin']
    _description = "Daily Time Record"
    employee_id = fields.Many2one('hr.employee', string='Employee', required=True)
    ********start to call the table outside the class 
    def get_holiday_credit(self):
        holiday_credit = holiday('2020/07/03')

You can call this method from multiple classes And if you have a method and you want to call it from different files you can just define method in one file and then import that file in required file to call your method.

Thanks

gain charlie

Tác giả

Hi Hussain,

def get_holiday_credit(self) is not visible in DTR(class). because its calling Holiday(function) which is outside of class.

CODE:

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!

Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!

Đăng ký

Bài viết liên quan	Trả lời	Lượt xem
What is faster, creating a env every time in a loop or to create a variable and use it? environment odoo12	1 thg 6 20	3879
How can i get odoo environment in thread environment thread odoo12	0 thg 2 19	5177
How to open a table outside a class but belong to the same module in odoo 12 function environment class call	0 thg 10 20	3350
Odoo Mail Sending Limit Đã xử lý odoo12	2 thg 12 23	14899
(Document type: Invoice, Operation: write) - (Records: [], User: 2) odoo12	0 thg 10 23	33

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!