stock.py

# -*- encoding: utf-8 -*-
###############################################################################
#                                                                             #
# Copyright (C) 2009  Renato Lima - Akretion                                  #
# Copyright (C) 2012  Raphaël Valyi - Akretion                                #
# Copyright (C) 2014  Luis Felipe Miléo - KMEE - www.kmee.com.br              #
#                                                                             #
#This program is free software: you can redistribute it and/or modify         #
#it under the terms of the GNU Affero General Public License as published by  #
#the Free Software Foundation, either version 3 of the License, or            #
#(at your option) any later version.                                          #
#                                                                             #
#This program is distributed in the hope that it will be useful,              #
#but WITHOUT ANY WARRANTY; without even the implied warranty of               #
#MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the                #
#GNU Affero General Public License for more details.                          #
#                                                                             #
#You should have received a copy of the GNU Affero General Public License     #
#along with this program.  If not, see <http://www.gnu.org/licenses/>.        #
###############################################################################

from openerp.osv import orm, fields


class StockIncoterms(orm.Model):
    _inherit = 'stock.incoterms'
    _columns = {
        'freight_responsibility': fields.selection(
            [('0', 'Emitente'),
            ('1', u'Destinatário'),
            ('2', 'Terceiros'),
            ('9', 'Sem Frete')],
            'Frete por Conta', required=True)
    }
    _defaults = {
        'freight_responsibility': 0
    }


class StockPicking(orm.Model):
    _inherit = 'stock.picking'

    def _default_fiscal_category(self, cr, uid, context=None):
        user = self.pool.get('res.users').browse(
            cr, uid, uid, context=context)
        return user.company_id.stock_fiscal_category_id and \
        user.company_id.stock_fiscal_category_id.id or False

    _columns = {
        'fiscal_category_id': fields.many2one(
            'l10n_br_account.fiscal.category', 'Categoria Fiscal',
            readonly=True, domain="[('state', '=', 'approved')]",
            states={'draft': [('readonly', False)]}),
        'fiscal_position': fields.many2one(
            'account.fiscal.position', u'Posição Fiscal',
            domain="[('fiscal_category_id','=',fiscal_category_id)]",
            readonly=True, states={'draft': [('readonly', False)]}),
        'ind_pres': fields.selection([
                ('0', u'Não se aplica'),
                ('1', u'Operação presencial'),
                ('2', u'Operação não presencial, pela Internet'),
                ('3', u'Operação não presencial, Teleatendimento'),
                ('4', u'NFC-e em operação com entrega em domicílio'),
                ('9', u'Operação não presencial, outros'),
            ],u'Tipo de operação',
            help=u'Indicador de presença do comprador no \
                \nestabelecimento comercial no momento \
                \nda operação.'),
    }
    _defaults = {
        'ind_pres': '0',
        'fiscal_category_id': _default_fiscal_category
    }

    def onchange_partner_in(self, cr, uid, ids, partner_id=None,
                            company_id=None, context=None,
                            fiscal_category_id=None):
        if not context:
            context = {}

        return super(StockPicking, self).onchange_partner_in(
            cr, uid, ids, partner_id=partner_id, company_id=company_id,
            context=context, fiscal_category_id=fiscal_category_id)

    def onchange_fiscal_category_id(self, cr, uid, ids,
                                    partner_id, company_id=False,
                                    fiscal_category_id=False,
                                    context=None, **kwargs):
        if not context:
            context = {}

        result = {'value': {'fiscal_position': False}}

        if not partner_id or not company_id:
            return result

        partner_invoice_id = self.pool.get('res.partner').address_get(
            cr, uid, [partner_id], ['invoice'])['invoice']
        partner_shipping_id = self.pool.get('res.partner').address_get(
            cr, uid, [partner_id], ['delivery'])['delivery']

        kwargs = {
           'partner_id': partner_id,
           'partner_invoice_id': partner_invoice_id,
           'partner_shipping_id': partner_shipping_id,
           'company_id': company_id,
           'context': context,
           'fiscal_category_id': fiscal_category_id
        }
        return self._fiscal_position_map(cr, uid, result, **kwargs)

    def onchange_company_id(self, cr, uid, ids, partner_id, company_id=False,
                            fiscal_category_id=False, context=None, **kwargs):
        if not context:
            context = {}

        result = {'value': {'fiscal_position': False}}

        if not partner_id or not company_id:
            return result

        partner_invoice_id = self.pool.get('res.partner').address_get(
            cr, uid, [partner_id], ['invoice'])['invoice']
        partner_shipping_id = self.pool.get('res.partner').address_get(
            cr, uid, [partner_id], ['delivery'])['delivery']

        kwargs = {
           'partner_id': partner_id,
           'partner_invoice_id': partner_invoice_id,
           'partner_shipping_id': partner_shipping_id,
           'company_id': company_id,
           'context': context,
           'fiscal_category_id': fiscal_category_id
        }
        return self._fiscal_position_map(cr, uid, result, **kwargs)

    def _prepare_invoice_line(self, cr, uid, group, picking, move_line,
                              invoice_id, invoice_vals, context=None):
        result = super(StockPicking, self)._prepare_invoice_line(
            cr, uid, group, picking, move_line, invoice_id, invoice_vals,
            context)

        fiscal_position = move_line.fiscal_position or \
            move_line.picking_id.fiscal_position or False
        fiscal_category_id = move_line.fiscal_category_id or \
            move_line.picking_id.fiscal_category_id or False
              
        result['cfop_id'] = fiscal_position and \
        fiscal_position.cfop_id and fiscal_position.cfop_id.id
        result['fiscal_category_id'] = fiscal_category_id and \
        fiscal_category_id.id
        result['fiscal_position'] = fiscal_position and \
        fiscal_position.id

        result['partner_id'] = picking.partner_id.id
        result['company_id'] = picking.company_id.id

        return result

    def _prepare_invoice(self, cr, uid, picking, partner,
                        inv_type, journal_id, context=None):
        result = super(StockPicking, self)._prepare_invoice(
            cr, uid, picking, partner, inv_type, journal_id, context)

        comment = ''
        if picking.fiscal_position.inv_copy_note:
            comment += picking.fiscal_position.note or ''

        if picking.note:
            comment += ' - ' + picking.note

        result['comment'] = comment
        result['fiscal_category_id'] = picking.fiscal_category_id and \
        picking.fiscal_category_id.id
        result['fiscal_position'] = picking.fiscal_position and \
        picking.fiscal_position.id
        result['ind_pres'] = picking.ind_pres
        return result


class StockPickingIn(StockPicking):
    _inherit = 'stock.picking.in'

    def _default_fiscal_category(self, cr, uid, context=None):
        user = self.pool.get('res.users').browse(
            cr, uid, uid, context=context)
        return user.company_id.stock_in_fiscal_category_id and \
        user.company_id.stock_in_fiscal_category_id.id or False

    _columns = {
        'fiscal_category_id': fields.many2one(
            'l10n_br_account.fiscal.category', 'Categoria Fiscal',
            domain="""[('journal_type', 'in', ('sale_refund', 'purchase')),
            "('fiscal_type', '=', 'product'), ('type', '=', 'input'),
            ('state', '=', 'approved')]"""),
        'fiscal_position': fields.many2one(
            'account.fiscal.position', u'Posição Fiscal',
            domain="[('fiscal_category_id','=',fiscal_category_id)]"),
        'ind_pres': fields.selection([
                ('0', u'Não se aplica'),
                ('1', u'Operação presencial'),
                ('2', u'Operação não presencial, pela Internet'),
                ('3', u'Operação não presencial, Teleatendimento'),
                ('4', u'NFC-e em operação com entrega em domicílio'),
                ('9', u'Operação não presencial, outros'),
            ],u'Tipo de operação',
            help=u'Indicador de presença do comprador no \
                \nestabelecimento comercial no momento \
                \nda operação.'),
    }
    _defaults = {
        'invoice_state': 'none',
        'fiscal_category_id': _default_fiscal_category,
        'ind_pres': '0',
    }

    def _fiscal_position_map(self, cr, uid, result, **kwargs):
        kwargs['context'].update({'use_domain': ('use_picking', '=', True)})
        fp_rule_obj = self.pool.get('account.fiscal.position.rule')
        return fp_rule_obj.apply_fiscal_mapping(cr, uid, result, **kwargs)

    def onchange_partner_in(self, cr, uid, ids, partner_id=None,
                            company_id=None, context=None,
                            fiscal_category_id=None):

        result = super(StockPicking, self).onchange_partner_in(
            cr, uid, partner_id, context)

        if not result:
            result = {'value': {'fiscal_position': False}}

        if not partner_id or not company_id:
            return result

        partner_invoice_id = self.pool.get('res.partner').address_get(
            cr, uid, [partner_id], ['invoice'])['invoice']
        partner_shipping_id = self.pool.get('res.partner').address_get(
            cr, uid, [partner_id], ['delivery'])['delivery']

        kwargs = {
           'partner_id': partner_id,
           'partner_invoice_id': partner_invoice_id,
           'partner_shipping_id': partner_shipping_id,
           'company_id': company_id,
           'fiscal_category_id': fiscal_category_id,
           'context': context
        }
        return self._fiscal_position_map(cr, uid, result, **kwargs)


class StockPickingOut(StockPicking):
    _inherit = 'stock.picking.out'

    def _default_fiscal_category(self, cr, uid, context=None):
        user = self.pool.get('res.users').browse(
            cr, uid, uid, context=context)
        return user.company_id.stock_out_fiscal_category_id and \
        user.company_id.stock_out_fiscal_category_id.id or False

    _columns = {
        'fiscal_category_id': fields.many2one(
            'l10n_br_account.fiscal.category', 'Categoria Fiscal',
            domain="""[('journal_type', 'in', ('purchase_refund', 'sale')),
            "('fiscal_type', '=', 'product'), ('type', '=', 'output'),
            ('state', '=', 'approved')]"""),
        'fiscal_position': fields.many2one(
            'account.fiscal.position', u'Posição Fiscal',
            domain="[('fiscal_category_id','=',fiscal_category_id)]"),
        'ind_pres': fields.selection([
                ('0', u'Não se aplica'),
                ('1', u'Operação presencial'),
                ('2', u'Operação não presencial, pela Internet'),
                ('3', u'Operação não presencial, Teleatendimento'),
                ('4', u'NFC-e em operação com entrega em domicílio'),
                ('9', u'Operação não presencial, outros'),
            ],u'Tipo de operação',
            help=u'Indicador de presença do comprador no \
                \nestabelecimento comercial no momento \
                \nda operação.'),
    }
    _defaults = {
        'invoice_state': 'none',
        'fiscal_category_id': _default_fiscal_category,
        'ind_pres': '0',
    }

    def _fiscal_position_map(self, cr, uid, result, **kwargs):
        kwargs['context'].update({'use_domain': ('use_picking', '=', True)})
        fp_rule_obj = self.pool.get('account.fiscal.position.rule')
        return fp_rule_obj.apply_fiscal_mapping(cr, uid, result, **kwargs)

    def onchange_partner_in(self, cr, uid, ids, partner_id=None,
                            company_id=None, context=None,
                            fiscal_category_id=None):

        result = super(StockPicking, self).onchange_partner_in(
            cr, uid, partner_id, context)

        if not result:
            result = {'value': {'fiscal_position': False}}

        if not partner_id or not company_id:
            return result

        partner_invoice_id = self.pool.get('res.partner').address_get(
            cr, uid, [partner_id], ['invoice'])['invoice']
        partner_shipping_id = self.pool.get('res.partner').address_get(
            cr, uid, [partner_id], ['delivery'])['delivery']

        kwargs = {
           'partner_id': partner_id,
           'partner_invoice_id': partner_invoice_id,
           'partner_shipping_id': partner_shipping_id,
           'company_id': company_id,
           'fiscal_category_id': fiscal_category_id,
           'context': context
        }
        return self._fiscal_position_map(cr, uid, result, **kwargs)
    
class StockMove(orm.Model):

    _inherit = "stock.move"
    
    _columns = {
        'fiscal_category_id': fields.many2one(
            'l10n_br_account.fiscal.category', 'Categoria Fiscal',
            domain="[('type', '=', 'output'), ('journal_type', '=', 'sale')]",
            readonly=True, states={'draft': [('readonly', False)],
                'sent': [('readonly', False)]}),
        'fiscal_position': fields.many2one(
            'account.fiscal.position', 'Fiscal Position',
            domain="[('fiscal_category_id','=',fiscal_category_id)]",
            readonly=True, states={'draft': [('readonly', False)],
                'sent': [('readonly', False)]}),
                }
   
    def _fiscal_position_map(self, cr, uid, result, **kwargs):
        kwargs['context'].update({'use_domain': ('use_picking', '=', True)})
        fp_rule_obj = self.pool.get('account.fiscal.position.rule')
        return fp_rule_obj.apply_fiscal_mapping(cr, uid, result, **kwargs)

    def onchange_product_id(self, cr, uid, ids, product_id, location_id,
                            location_dest_id, partner_id, context=False, **kwargs ):
        
        if not context:
            context = {}
            
        parent_fiscal_category_id = context.get('parent_fiscal_category_id')
        picking_type = context.get('picking_type')
        if context.get('company_id', False):
            company_id = context['company_id']
        else:
            company_id = self.pool.get('res.users').browse(cr, uid, uid,
            context=context).company_id.id    
        
        result = {'value': {}}
        
        if parent_fiscal_category_id and product_id and picking_type:
            
            obj_fp_rule = self.pool.get('account.fiscal.position.rule')
            product_fc_id = obj_fp_rule.product_fiscal_category_map(
                cr, uid, product_id, parent_fiscal_category_id)

            if product_fc_id:
                parent_fiscal_category_id = product_fc_id

            result['value']['fiscal_category_id'] = parent_fiscal_category_id

            partner_invoice_id = self.pool.get('res.partner').address_get(
                    cr, uid, [partner_id], ['invoice'])['invoice']
            partner_shipping_id = self.pool.get('res.partner').address_get(
                    cr, uid, [partner_id], ['delivery'])['delivery']

            kwargs = {
               'partner_id': partner_id,
               'partner_invoice_id': partner_invoice_id,
               'partner_shipping_id': partner_shipping_id,
               'fiscal_category_id': parent_fiscal_category_id,
               'company_id': company_id,
               'context': context
            }
                        
            result.update(self._fiscal_position_map(cr, uid, result, **kwargs))
        
        result_super  = super(StockMove, self).onchange_product_id(cr, uid, 
                ids, product_id, location_id, location_dest_id, partner_id)
            
        result_super['value'].update(result['value'])
        return result_super