Merge lp:~inddiana/diana-addons/nota_credito_desc_financieros into lp:diana-addons/6.0

[[SISB] Aryrosa Fuentes]

[ADD] Nuevo modulo para aplicar notas de credito a descuentos financieros de 1 porciento.
Se debe comentar el constraint en presupuesto. Se debe configurar los productos, asociar al grupo la categoria de estos productos, asociar el usuario al nuevo grupo.

=== added directory 'notas_de_credito'
=== added file 'notas_de_credito/__init__.py'
--- notas_de_credito/__init__.py	1970-01-01 00:00:00 +0000
+++ notas_de_credito/__init__.py	2013-04-26 02:38:26 +0000
@@ -0,0 +1,4 @@
+# -*- coding: utf-8 -*-
+
+import model
+import wizard
 
=== added file 'notas_de_credito/__openerp__.py'
--- notas_de_credito/__openerp__.py	1970-01-01 00:00:00 +0000
+++ notas_de_credito/__openerp__.py	2013-04-26 02:38:26 +0000
@@ -0,0 +1,22 @@
+# -*- coding: utf-8 -*-
+
+{
+    "name" : "Registro nota de credito por descuentos financieros",
+    "version" : "1.0",
+    "author" : "Industrias Diana C.A.",
+    "category" : "Interfaces",
+    "website" : "http://www.industriasdiana.gob.ve",
+    "depends" : ["sisb_ventas",
+            'l10n_ve_presupuesto',
+    ],
+    "description": """Wizard para registrar nota de credito por descuentos financieros para facturas de ventas. Incluye la informacion para presupuesto.""",
+    "update_xml" : [
+        'security/nc_des_financiero_security.xml',
+        'security/ir.model.access.csv',
+        'view/nota_credito_desc_financiero.xml',
+        'wizard/nota_credito_1_x_100_wizard.xml',
+    ],
+    "active": False,
+    "installable": True,
+    'data' : [],
+}
 
=== added directory 'notas_de_credito/i18n'
=== added directory 'notas_de_credito/model'
=== added file 'notas_de_credito/model/__init__.py'
--- notas_de_credito/model/__init__.py	1970-01-01 00:00:00 +0000
+++ notas_de_credito/model/__init__.py	2013-04-26 02:38:26 +0000
@@ -0,0 +1,21 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###############Credits#########################################################
+#    Finance by: Industrias Diana, C.A. http://www.industriasdiana.gob.ve
+###############################################################################
+#    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/>.
+###############################################################################
+
+
+import product_tax
 
=== added file 'notas_de_credito/model/product_tax.py'
--- notas_de_credito/model/product_tax.py	1970-01-01 00:00:00 +0000
+++ notas_de_credito/model/product_tax.py	2013-04-26 02:38:26 +0000
@@ -0,0 +1,32 @@
+# -*- coding: utf-8 -*-
+"""
+Módulo utilizado para configurar los productos a escoger para asociar a las notas de credito del 1 porciento segun los impuestos
+"""
+
+import time
+import netsvc
+from osv import fields, osv
+from tools import config
+from tools.translate import _
+import decimal_precision as dp
+
+#----------------------------------------------------------
+#  Productos tipo servicio y el impuesto asociado
+#----------------------------------------------------------
+
+class nota_credito_product_tax(osv.osv):
+    _name = "nota.credito.product_tax"
+    _description = "Productos de Notas de Credito"
+    _order = "name"
+
+    _columns = {
+        'name': fields.char('Nombre', size=64, select=True, required=True),
+        'tax_id': fields.many2one('account.tax', 'Impuesto', required=True),
+        'product_id': fields.many2one('product.product', 'Servicio de Descuento', required=True),
+    }
+    _sql_constraints = [
+        ('tax_product_uniq', 'unique (tax_id, product_id)', 'The combination of tax and product must be unique !'),
+    ]
+    
+    
+nota_credito_product_tax()
 
=== added directory 'notas_de_credito/security'
=== added file 'notas_de_credito/security/ir.model.access.csv'
--- notas_de_credito/security/ir.model.access.csv	1970-01-01 00:00:00 +0000
+++ notas_de_credito/security/ir.model.access.csv	2013-04-26 02:38:26 +0000
@@ -0,0 +1,2 @@
+"id","name","model_id:id","group_id:id","perm_read","perm_write","perm_create","perm_unlink"
+"access_nc_des_financiero","nota_credito.product_tax","model_nota_credito_product_tax","group_nc_des_financiero_user",1,1,1,0
 
=== added file 'notas_de_credito/security/nc_des_financiero_security.xml'
--- notas_de_credito/security/nc_des_financiero_security.xml	1970-01-01 00:00:00 +0000
+++ notas_de_credito/security/nc_des_financiero_security.xml	2013-04-26 02:38:26 +0000
@@ -0,0 +1,13 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data noupdate="0">
+
+<!--
+        Grupo
+-->
+        <record id="group_nc_des_financiero_user" model="res.groups">
+            <field name="name">NC para Descuento Financiero / User</field>
+        </record>
+        
+    </data>
+</openerp>
 
=== added directory 'notas_de_credito/view'
=== added file 'notas_de_credito/view/nota_credito_desc_financiero.xml'
--- notas_de_credito/view/nota_credito_desc_financiero.xml	1970-01-01 00:00:00 +0000
+++ notas_de_credito/view/nota_credito_desc_financiero.xml	2013-04-26 02:38:26 +0000
@@ -0,0 +1,62 @@
+<?xml version="1.0"?>
+<openerp>
+    <data>
+        <record id="view_nc_product_tax_form" model="ir.ui.view">
+            <field name="name">nota.credito.product_tax.form</field>
+            <field name="model">nota.credito.product_tax</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Impuestos y productos asociados para la nota de credito">
+                    <group colspan="4" col="6">
+                        <group colspan="2" col="2">
+                            <field name="name"/>
+                            <field name="tax_id"  domain="[('type_tax_use','=','sale')]"/>
+                        </group>
+                        <group colspan="2" col="2">
+                            <field name="product_id" domain="[('type','=','service')]"/>
+                        </group>
+                    </group>
+                </form>
+            </field>
+        </record>
+
+        <record id="view_nc_product_tax_search" model="ir.ui.view">
+            <field name="name">nota.credito.product_tax.search</field>
+            <field name="model">nota.credito.product_tax</field>
+            <field name="type">search</field>
+            <field name="arch" type="xml">
+                <search string="Impuestos y productos">
+                    <field name="name"/>
+                    <field name="tax_id"/>
+                    <field name="product_id"/>
+                </search>
+            </field>
+        </record>
+
+        <record id="view_nc_product_tax_tree" model="ir.ui.view">
+            <field name="name">nota.credito.product_tax.tree</field>
+            <field name="model">nota.credito.product_tax</field>
+            <field name="type">tree</field>
+            <field name="priority" eval="2"/>
+            <field name="arch" type="xml">
+                <tree string="Impuestos y productos">
+                    <field name="name"/>
+                    <field name="tax_id"/>
+                    <field name="product_id"/>
+                </tree>
+            </field>
+        </record>
+
+        <record id="action_nc_product_tax_form" model="ir.actions.act_window">
+            <field name="name">Impuestos y productos</field>
+            <field name="res_model">nota.credito.product_tax</field>
+            <field name="type">ir.actions.act_window</field>
+            <field name="view_type">form</field>
+            <field name="view_id" ref="view_nc_product_tax_tree"/>
+            <field name="search_view_id" ref="view_nc_product_tax_search"/>
+            <field name="help">Configurar los productos utilizados por cada impuesto en las notas de credito para descuentos financieros en ventas.</field>
+        </record>
+        <menuitem id="menu_action_nc_product_tax_desc_fin_form" name="Impuestos y productos para descuentos financieros" parent="account.menu_finance_configuration"/>
+        <menuitem action="action_nc_product_tax_form" id="menu_action_nc_product_tax_form" parent="menu_action_nc_product_tax_desc_fin_form"/>
+    </data>
+</openerp>
 
=== added directory 'notas_de_credito/wizard'
=== added file 'notas_de_credito/wizard/__init__.py'
--- notas_de_credito/wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ notas_de_credito/wizard/__init__.py	2013-04-26 02:38:26 +0000
@@ -0,0 +1,21 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###############Credits#########################################################
+#    Finance by: Industrias Diana, C.A. http://www.industriasdiana.gob.ve
+###############################################################################
+#    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/>.
+###############################################################################
+
+
+import nota_credito_1_x_100_wizard
 
=== added file 'notas_de_credito/wizard/nota_credito_1_x_100_wizard.py'
--- notas_de_credito/wizard/nota_credito_1_x_100_wizard.py	1970-01-01 00:00:00 +0000
+++ notas_de_credito/wizard/nota_credito_1_x_100_wizard.py	2013-04-26 02:38:26 +0000
@@ -0,0 +1,235 @@
+# -*- encoding: utf-8 -*-
+##############################################################################
+# Copyright (c) 2012 Industrias Diana C.A.
+# All Rights Reserved.
+#
+# WARNING: This program as such is intended to be used by professional
+# programmers who take the whole responsability of assessing all potential
+# consequences resulting from its eventual inadequacies and bugs
+# End users who are looking for a ready-to-use solution with commercial
+# garantees and support are strongly adviced to contract a Free Software
+# Service Company
+#
+# This program is Free Software; you can redistribute it and/or
+# modify it under the terms of the GNU General Public License
+# as published by the Free Software Foundation; either version 2
+# 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 General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
+###############################################################################
+from datetime import datetime, timedelta
+from dateutil.relativedelta import relativedelta
+import time
+
+from osv import osv
+from osv import fields
+import sys
+from tools.translate import _
+import decimal_precision as dp
+import netsvc
+
+class nota_credito_1_x_100_wizard(osv.osv_memory):
+    """
+    Forzar la confirmación del presupuesto para convertirse en un pedido de venta.
+    """
+    _name = "nota.credito.1_x_100.wizard"
+    
+    _description = "Nota de Credito por Descuento Financiero"
+    _columns = {
+       'descuento': fields.integer('Descuento (%)', digits_compute= dp.get_precision('Account')),
+    }
+    
+    _defaults = {
+        'descuento': 1
+    }
+    
+    def _make_invoice(self, cr, uid, cabecera, lines, descuento, context=None):
+        journal_obj = self.pool.get('account.journal')
+        inv_obj = self.pool.get('account.invoice')
+        obj_invoice_line = self.pool.get('account.invoice.line')
+        if context is None:
+            context = {}
+
+        journal_id = cabecera.journal_id.sale_shop_id and cabecera.journal_id.sale_shop_id.refund_journal_id and cabecera.journal_id.sale_shop_id.refund_journal_id.id or False
+        if not journal_id:
+            raise osv.except_osv(_('Error !'),
+                _('There is no sales journal defined for this return: "%s"') % (cabecera.name))
+        
+        a = cabecera.partner_id.property_account_receivable.id
+
+        inv = {
+            'name': 'RECTIFICA A ' + cabecera.number + ' DESCONTANDO EL ' + str(descuento) + '%',
+            'origin': cabecera.origin,
+            'type': 'out_refund',
+            'reference': cabecera.number,
+            'account_id': a,
+            'partner_id': cabecera.partner_id.id,
+            'journal_id': journal_id,
+            'address_invoice_id': cabecera.address_invoice_id.id,
+            'address_contact_id': cabecera.address_contact_id and cabecera.address_contact_id.id or False,
+            'invoice_line': [(6, 0, lines)],
+            'currency_id': cabecera.currency_id.id,
+            'comment': 'Descuento financiero al ' + str(descuento) + '%',
+            'fiscal_position': cabecera.partner_id.property_account_position.id,
+            'date_invoice': time.strftime('%Y-%m-%d'),
+            'company_id': cabecera.company_id.id,
+            'user_id': cabecera.user_id and cabecera.user_id.id or False,
+            'parent_id': cabecera.id,
+            'address_shipping_id': cabecera.address_shipping_id.id,
+        }
+        
+        inv_id = inv_obj.create(cr, uid, inv)
+        inv_obj.button_compute(cr, uid, [inv_id])
+
+        return inv_id
+    
+    def action_invoice_create(self, cr, uid, ids, res_ids, descuento, context=None):
+        if context is None:
+            context = {}
+            
+        invoice_ids_refund = []
+
+        invoice = self.pool.get('account.invoice')
+        obj_invoice_tax_ids = self.pool.get('account.invoice.tax')
+        if context is None:
+            context = {}
+
+        for out_inv in invoice.browse(cr, uid, res_ids, context=context):
+            invoices = {}
+            inv_line_id = False
+            create_ids = []
+            #Buscar los impuesto de donde se van a sacar las lineas de la factura
+            ait_ids = obj_invoice_tax_ids.search(cr, uid, [('invoice_id','=',out_inv.id)],context=context)
+            #Por cada linea de impuesto crear una linea de la factura rectificativa
+            for line in obj_invoice_tax_ids.browse(cr, uid, ait_ids, context=context):
+                product_tax_id = self.pool.get('nota.credito.product_tax').search(cr, uid, [('tax_id','=',line.tax_id.id)], context=context)
+                
+                if not product_tax_id:
+                    raise osv.except_osv(_('Error !'),
+                        _('There is no product for invoice refund defined ' \
+                                'for this tax: "%s" ') % \
+                                (line.tax_id.name))
+                
+                product_tax = self.pool.get('nota.credito.product_tax').browse(cr, uid, product_tax_id[0], context=context) 
+                
+                #La cuenta de ingreso del producto
+                a = product_tax.product_id.product_tmpl_id.property_account_expense.id
+                if not a:
+                    a = product_tax.product_id.categ_id.property_account_expense_categ.id
+                if not a:
+                    a = self.get_product_category_account(cr,uid,product_tax.product_id.categ_id.id,"property_account_expense_categ",context=context)
+                if not a:
+                    raise osv.except_osv(_('Error !'),
+                            _('There is no income account defined ' \
+                                    'for this product: "%s" (id:%d)') % \
+                                    (product_tax.product_id.name, product_tax.product_id.id,))
+
+                inv_line_id = self.pool.get('account.invoice.line').create(cr, uid, {
+                    'name': self.pool.get('product.product').name_get(cr, uid, [product_tax.product_id.id])[0][1][:128],
+                    'origin': out_inv.origin,
+                    'account_id': a,
+                    'price_unit': line.base * descuento/100,
+                    'quantity': 1,
+                    'discount': 0.00,
+                    'uos_id': product_tax.product_id.uom_id.id,
+                    'product_id': product_tax.product_id.id,
+                    'invoice_line_tax_id': [(6, 0, [product_tax.tax_id.id])],
+                    'note': 'Descuento financiero al ' + str(descuento) + '%',
+                    'account_analytic_id': out_inv.journal_id.sale_shop_id and out_inv.journal_id.sale_shop_id.project_id and out_inv.journal_id.sale_shop_id.project_id.id or False,
+                    'accion_especifica_id': out_inv.journal_id.sale_shop_id and out_inv.journal_id.sale_shop_id.accion_especifica_id and out_inv.journal_id.sale_shop_id.accion_especifica_id.id or False,
+                    'partida_presupuesto': product_tax.product_id.partida_egreso and product_tax.product_id.partida_egreso.id or False,
+                })
+                create_ids.append(inv_line_id)
+            
+            #Se crea la factura rectificativa
+            if create_ids:
+                inv_id = self._make_invoice(cr, uid, out_inv, create_ids, descuento, context=context)
+                invoice_ids_refund.append(inv_id)
+            else:
+                inv_id = 0
+
+        return invoice_ids_refund
+        
+    def crear_nc(self, cr, uid, ids, context=None):
+        if context is None:
+            context = {}
+        
+        aml_obj = self.pool.get('account.move.line')
+        wf_service = netsvc.LocalService("workflow")
+        
+        act_obj = self.pool.get('ir.actions.act_window')
+        mod_obj = self.pool.get('ir.model.data')
+        model = context.get('active_model')
+        
+        descuento_data_obj = self.read(cr, uid, ids, ['descuento'])
+        
+        if not model or model != 'account.invoice':
+            return []
+        
+        if descuento_data_obj[0]['descuento'] < 1 or descuento_data_obj[0]['descuento']  > 100:
+            raise osv.except_osv(_('Mensaje !'), _('No se puede aplicar a una factura un descuento menor a 1% o mayor a 100% por este modulo!'))
+        
+        res_ids = context and context.get('active_ids', [])
+        model_pool = self.pool.get(model)
+        browse_inv = model_pool.browse(cr, uid, res_ids, context=context)
+        #Proceso de validacion
+        validar_grupo_ok = True
+        number_inv = ''
+        for inv_disc in browse_inv:
+            if inv_disc.type != 'out_invoice' or inv_disc.state not in ('open') \
+                or abs(inv_disc.residual - inv_disc.amount_total) > 0.01:
+                validar_grupo_ok = False
+            
+            if not validar_grupo_ok:
+                number_inv = inv_disc.number or inv_disc.origin or inv_disc.state
+                break
+            
+            #Se recomienda a futuro validar por fecha de vencimiento
+            
+        #Si todas las facturas son de ventas
+        if validar_grupo_ok:
+            #crear las facturas
+            refund_invoice_ids = self.action_invoice_create(cr, uid, ids, res_ids, descuento_data_obj[0]['descuento'], context=context)
+            
+            #procesar las facturas
+            for invoice in refund_invoice_ids:
+                wf_service.trg_validate(uid, 'account.invoice', invoice, 'invoice_open', cr)
+            
+            """ Se concilian los asientos de la factura rectificativa y la factura padre """
+            reconcil_ids = []
+            for invoice in refund_invoice_ids:
+                reconcil_ids = []
+                inv_refund = model_pool.browse(cr, uid, invoice, context=context)
+                for line_m_r in inv_refund.move_id.line_id:
+                    if line_m_r.account_id == inv_refund.account_id:
+                        reconcil_ids.append(line_m_r.id)
+                        break
+                
+                for line_m_i in inv_refund.parent_id.move_id.line_id:
+                    if line_m_i.account_id == inv_refund.account_id:
+                        reconcil_ids.append(line_m_i.id)
+                        break
+
+                """ Se concilian los asientos de la factura """
+                if reconcil_ids:
+                    isok = aml_obj.reconcile_partial(cr, uid, reconcil_ids,'manual', context)
+
+        else:
+            raise osv.except_osv(_('Mensaje !'), _('Hay facturas seleccionadas que no se les puede aplicar nota de credito para descuento financieros. Por favor revise para empezar la factura %s!')%number_inv)
+        
+        result = mod_obj.get_object_reference(cr, uid, 'account', 'action_invoice_tree3')
+        id = result and result[1] or False
+        result = act_obj.read(cr, uid, id, context=context)
+        invoice_domain = eval(result['domain'])
+        invoice_domain.append(('id', 'in', refund_invoice_ids))
+        result['domain'] = invoice_domain
+        return result
+    
+nota_credito_1_x_100_wizard()
 
=== added file 'notas_de_credito/wizard/nota_credito_1_x_100_wizard.xml'
--- notas_de_credito/wizard/nota_credito_1_x_100_wizard.xml	1970-01-01 00:00:00 +0000
+++ notas_de_credito/wizard/nota_credito_1_x_100_wizard.xml	2013-04-26 02:38:26 +0000
@@ -0,0 +1,32 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        <record id="view_nota_credito_1_x_100_wizard" model="ir.ui.view">
+            <field name="name">Nota de Credito de 1 Porciento</field>
+            <field name="model">nota.credito.1_x_100.wizard</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+              <form string="Crear Nota de Credito por descuento Financiero">
+                    <separator colspan="4" string="Crear Nota de Credito" />
+                    <group colspan="2" col="2">
+                    <field name="descuento"/>
+                    </group>
+                    <separator string="" colspan="4" />
+                    <button special="cancel" string="Cancelar" icon='gtk-cancel'/>
+                    <button name="crear_nc" string="Crear" type="object" icon="terp-gtk-go-back-rtl"/>
+             </form>
+            </field>
+        </record>
+
+
+        <act_window name="Nota de Credito por Descuento Financiero"
+            res_model="nota.credito.1_x_100.wizard"
+            src_model="account.invoice"
+            key2="client_action_multi"
+            multi="True"
+            view_mode="form"
+            view_type="form"
+            target="new"
+            id="action_nota_credito_1_x_100"/>
+    </data>
+</openerp>