import_cost_calculation/models/import_cost_calculation.py

# -*- encoding: utf-8 -*-
from openerp import models, fields, api, _
from openerp.exceptions import Warning
from pytz import timezone
from openerp.tools import DEFAULT_SERVER_DATETIME_FORMAT, DEFAULT_SERVER_DATE_FORMAT
from datetime import datetime,timedelta
from openerp import http

DATE_FORMAT = '%Y-%m-%d'

class import_purchase_line(models.Model):
    _name = 'import.purchase.line'

    import_id = fields.Many2one('import.cost', 'Gastos de importación',ondelete='cascade')
    purchase_id = fields.Many2one('account.invoice', 'Gastos de importación',required=True)
    purchase_subtotal = fields.Float("Subtotal", related='purchase_id.amount_untaxed', store=True, readonly=True)
    purchase_taxes = fields.Float("Impuestos", related='purchase_id.amount_tax', store=True, readonly=True)
    purchase_total = fields.Float("Total", related='purchase_id.amount_total', store=True, readonly=True)

class import_expense_line(models.Model):
    _name = 'import.expense.line'

    import_id = fields.Many2one('import.cost', 'Gastos de importación',ondelete='cascade')
    expense_id = fields.Many2one('account.invoice', 'Gastos de importación', required=True)
    expense_subtotal = fields.Float("Subtotal", related='expense_id.amount_untaxed', store=True, readonly=True)
    expense_taxes = fields.Float("Impuestos", related='expense_id.amount_tax', store=True, readonly=True)
    expense_total = fields.Float("Total", related='expense_id.amount_total', store=True, readonly=True)


class import_cost(models.Model):
    _name = 'import.cost'

    name = fields.Char(string='Nombre', readonly=True)
    date = fields.Datetime('Fecha', default=datetime.now(), required=True)
    purchases = fields.One2many('import.purchase.line','import_id','Facturas de compra')
    expenses = fields.One2many('import.expense.line','import_id','Facturas de gasto')
    factor = fields.Float(string="Factor", readonly=True)
    state = fields.Selection([
        ('draft', 'Borrador'),
        ('approved', 'Aprobado'),
        ], 'Estado', readonly=True, select=True, default="draft")
    created_by = fields.Many2one('res.users', 'Creado por', default=lambda self: self.env.user.id, readonly=True)
    approved_by = fields.Many2one('res.users', 'Aprobado por')

    @api.one
    def _get_amount(self):
        suma_purchase_subtotal = 0
        suma_purchase_taxes = 0
        suma_purchase_total = 0
        suma_expense_subtotal = 0
        suma_expense_taxes = 0
        suma_expense_total = 0

        invoice1 = self.env['import.purchase.line'].search([('import_id','=',self.id)])

        for each in invoice1:
            suma_purchase_subtotal = suma_purchase_subtotal + each.purchase_subtotal
            suma_purchase_taxes = suma_purchase_taxes + each.purchase_taxes
            suma_purchase_total = suma_purchase_total + each.purchase_total

        invoice2 = self.env['import.expense.line'].search([('import_id','=',self.id)])

        for item in invoice2:
            suma_expense_subtotal = suma_expense_subtotal + item.expense_subtotal
            suma_expense_taxes = suma_expense_taxes + item.expense_taxes
            suma_expense_total = suma_expense_total + item.expense_total

        self.purchases_subtotal = suma_purchase_subtotal
        self.purchases_taxes = suma_purchase_taxes
        self.purchases_total = suma_purchase_total
        self.expenses_subtotal = suma_expense_subtotal
        self.expenses_taxes = suma_expense_taxes
        self.expenses_total = suma_expense_total

    purchases_subtotal = fields.Float(string="Subtotal", compute="_get_amount")
    purchases_taxes = fields.Float(string="Impuestos", compute="_get_amount")
    purchases_total = fields.Float(string="Total", compute="_get_amount")
    expenses_subtotal = fields.Float(string="Subtotal", compute="_get_amount")
    expenses_taxes = fields.Float(string="Impuestos", compute="_get_amount")
    expenses_total = fields.Float(string="Total", compute="_get_amount")

    @api.model
    def approve_import_cost(self, value):
        approved_by = self.env.user.id
        import_cost = self.env['import.cost'].search([('id','=',value['import_id'])])
        import_cost.write({'state': 'approved','factor':value['factor'],'approved_by':approved_by})

        for item in value['purchases']:
            product = self.env['product.product'].search([('id','=',item['product_id'][0])])
            template = self.env['product.template'].search([('id','=',product.product_tmpl_id.id)])

            if(template.price_change == 'import'):
                template.write({'standard_price': item['import_cost']})
        return True

    @api.model
    def create(self,vals):
        ctx = dict(self._context or {})
        vals['name'] = self.env['ir.sequence'].get('import.cost') or '/'
        return super(import_cost, self.with_context(ctx)).create(vals)