idg_region_tax_actual.py

import logging
from datetime import datetime

from psycopg2 import DatabaseError, sql

from odoo import fields, models, api, _
from odoo.exceptions import UserError

# from odoo.tools import sql

_logger = logging.getLogger(__name__)


class IdgRegionTaxActual(models.Model):
    _name = 'idg.region.tax.actual'
    _description = 'Region Tax Actual'
    country_id = fields.Many2one('res.country', required=True)
    state_id = fields.Many2one('res.country.state', required=True,
                               domain="[('country_id', '=?', country_id)]")

    district_id = fields.Many2one('res.district', required=False,
                                  domain="[('state_id', '=?', state_id)]")
    account_id = fields.Many2one('account.account', required=True)
    year = fields.Integer(compute='_compute_day', store=True)
    month = fields.Integer(compute='_compute_day', store=True)
    day = fields.Integer(compute='_compute_day', store=True)
    date = fields.Date(default=datetime.now().date(), required=True)
    qty = fields.Integer(required=True, default=0)
    amount = fields.Integer(required=True, default=0)

    def _compute_date(self):
        for row in self:
            row.year = row.date.year
            row.month = row.date.month
            row.day = row.date.day