Merge lp:~vauxoo/addons-vauxoo/addons-vauxoo-account_move_sum_all_credits_debits-dev-fernando2 into lp:addons-vauxoo

[Fernando Lopez]

Se agregó el modulo que realiza en la vista form, en 2 campos, la suma de todos los credits y debits de la base de datos del modelo account move usando sql

[Moisés López - http://www.vauxoo.com (moylop260)]

Fernando,
Haz la prueba de este function creando 3 registros de account.move con diferentes cantidades cada unom
Y veras que en los 3 te estará mostrando la misma cantidad.

Y en este caso, en la misma funcion puedes devolver el field_name para no tener que hacer casi la misma operacion, pero con diferentes campos 2 veces

review: Needs Fixing

[lp:~vauxoo/addons-vauxoo/addons-vauxoo-account_move_sum_all_credits_debits-dev-fernando2]

471. By Fernando Lopez on 2012-09-28

[IMP]Made the changes so it shows the debit and credits of that record, not all account moves

472. By Fernando Lopez on 2012-09-28

[REM]Removed code lines for debugging

[Fernando Lopez (kyon)]

Se hizo el cambio de obtener la suma solo del registro actual, y no la suma de todos los registros de la base de datos. Se fusionó a una sola función en lugar de 2.

review: Needs Resubmitting

=== added directory 'account_move_sum_all_credits_debits'
=== added file 'account_move_sum_all_credits_debits/__init__.py'
--- account_move_sum_all_credits_debits/__init__.py	1970-01-01 00:00:00 +0000
+++ account_move_sum_all_credits_debits/__init__.py	2012-09-28 19:45:26 +0000
@@ -0,0 +1,26 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2012 Vauxoo - http://www.vauxoo.com
+#    All Rights Reserved.
+#    [e-mail]
+############################################################################
+#    Coded by: fernandoL ([e-mail])
+############################################################################
+#
+#    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 account
\ No newline at end of file

=== added file 'account_move_sum_all_credits_debits/__openerp__.py'
--- account_move_sum_all_credits_debits/__openerp__.py	1970-01-01 00:00:00 +0000
+++ account_move_sum_all_credits_debits/__openerp__.py	2012-09-28 19:45:26 +0000
@@ -0,0 +1,45 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2012 Vauxoo - http://www.vauxoo.com
+#    All Rights Reserved.
+#    [e-mail]
+############################################################################
+#    Coded by: fernandoL ([e-mail])
+############################################################################
+#
+#    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/>.
+#
+##############################################################################
+
+{
+    "name": "Account move sum all credits debits",
+    "version": "1.0",
+    "author" : "Vauxoo",
+    "category": "Generic Modules/Production",
+    "website" : "http://www.vauxoo.com/",
+    "description": """ Add two function fields to sum all of the credits and
+    debits of the account move lines
+    """,
+    'depends': ['account'],
+    'init_xml': [],
+    'update_xml': [
+        'account_view.xml',
+        ],
+    'demo_xml': [],
+    'test': [],
+    'installable': True,
+    'active': False,
+}
\ No newline at end of file

=== added file 'account_move_sum_all_credits_debits/account.py'
--- account_move_sum_all_credits_debits/account.py	1970-01-01 00:00:00 +0000
+++ account_move_sum_all_credits_debits/account.py	2012-09-28 19:45:26 +0000
@@ -0,0 +1,56 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2012 Vauxoo - http://www.vauxoo.com
+#    All Rights Reserved.
+#    [e-mail]
+############################################################################
+#    Coded by: fernandoL ([e-mail])
+############################################################################
+#
+#    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 tools.translate import _
+from osv import osv, fields
+import decimal_precision as dp
+
+class account_move(osv.osv):
+    _inherit = "account.move"
+    
+    """example of query that get these fields ---
+    select sum(credit), sum(debit) 
+    from account_move_line 
+    where move_id=27
+    """
+    
+    def _sum_credit_debit(self, cr, uid, ids, field, arg, context=None):
+        suma = []
+        dict = {}
+        for id in ids:
+            cr.execute("""select sum(credit), sum(debit) 
+                        from account_move_line 
+                        where move_id=%s""",(id,))
+            suma = cr.fetchone()
+            dict[id] = {field[0]:suma[0],field[1]:suma[1]}
+        return dict#{25:{total_debit:1200},{total_credit:1200}}
+    
+    _columns = {
+        'total_debit': fields.function(_sum_credit_debit, string='Total debit', method=True, digits_compute=dp.get_precision('Account'), type='float', multi="total_credit_debit"),
+        'total_credit': fields.function(_sum_credit_debit, string='Total credit', method=True, digits_compute=dp.get_precision('Account'), type='float', multi="total_credit_debit"),
+    }
+
+account_move()
\ No newline at end of file

=== added file 'account_move_sum_all_credits_debits/account_view.xml'
--- account_move_sum_all_credits_debits/account_view.xml	1970-01-01 00:00:00 +0000
+++ account_move_sum_all_credits_debits/account_view.xml	2012-09-28 19:45:26 +0000
@@ -0,0 +1,25 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+<!--
+	Adding the fields to the parent account move view
+-->
+        <record id="account_move_sum_all_credits_debits_form" model="ir.ui.view">
+            <field name="name">account.move.sum.all.credits.debits.form</field>
+            <field name="model">account.move</field>
+	    <field name="inherit_id" ref="account.view_move_form" />
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <xpath expr="/form/group/field[@name='date']" position="after">
+			<field name="total_debit"/>
+			<field name="total_credit"/>
+                </xpath>
+            </field>
+        </record>
+
+<!--
+	View of wizard on stock.picking
+-->
+	
+    </data>
+</openerp>