Merge lp:~vauxoo/addons-vauxoo/cicsa_price_unit_estimated_prl-dev-yani into lp:~vauxoo/addons-vauxoo/addons-vauxoo-cicsa

[Yanina Aular (Vauxoo)]

An estimated unit price per line in the purchase requisition, a subtotal for each line
of the purchase requisition and a total of all lines is added.

[lp:~vauxoo/addons-vauxoo/cicsa_price_unit_estimated_prl-dev-yani]

1058. By Yanina Aular (Vauxoo) on 2014-06-18

[FIX] price unit not be required in model

=== added directory 'purchase_requisition_line_price_unit'
=== added file 'purchase_requisition_line_price_unit/__init__.py'
--- purchase_requisition_line_price_unit/__init__.py	1970-01-01 00:00:00 +0000
+++ purchase_requisition_line_price_unit/__init__.py	2014-06-18 14:56:09 +0000
@@ -0,0 +1,27 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###############################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
+#    All Rights Reserved
+############# Credits #########################################################
+#    Coded by: Yanina Aular <[e-mail]>
+#    Planified by: Humberto Arocha <[e-mail]>
+#    Audited by: Humberto Arocha <[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 model
+import wizard

=== added file 'purchase_requisition_line_price_unit/__openerp__.py'
--- purchase_requisition_line_price_unit/__openerp__.py	1970-01-01 00:00:00 +0000
+++ purchase_requisition_line_price_unit/__openerp__.py	2014-06-18 14:56:09 +0000
@@ -0,0 +1,52 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###############################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
+#    All Rights Reserved
+############# Credits #########################################################
+#    Coded by: Yanina Aular <[e-mail]>
+#    Planified by: Humberto Arocha <[e-mail]>
+#    Audited by: Humberto Arocha <[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': 'Purchase Requisition Line Price Unit',
+    'version': '1.0',
+    'author': 'Vauxoo',
+    'website': 'http://www.vauxoo.com/',
+    'category': '',
+    'description': '''
+Purchase Requisition Line Price Unit
+====================================
+
+An estimated unit price per line in the purchase requisition, a subtotal for each line
+of the purchase requisition and a total of all lines is added.
+''',
+    'depends': [
+        'purchase_requisition',
+        ],
+    'data': [
+        'view/purchase_requisition_view.xml'
+        ],
+    'demo': [],
+    'test': [],
+    'qweb': [],
+    'js': [],
+    'css': [],
+    'active': False,
+    'installable': True,
+}

=== added directory 'purchase_requisition_line_price_unit/data'
=== added directory 'purchase_requisition_line_price_unit/demo'
=== added directory 'purchase_requisition_line_price_unit/doc'
=== added directory 'purchase_requisition_line_price_unit/doc/images'
=== added directory 'purchase_requisition_line_price_unit/i18n'
=== added directory 'purchase_requisition_line_price_unit/model'
=== added file 'purchase_requisition_line_price_unit/model/__init__.py'
--- purchase_requisition_line_price_unit/model/__init__.py	1970-01-01 00:00:00 +0000
+++ purchase_requisition_line_price_unit/model/__init__.py	2014-06-18 14:56:09 +0000
@@ -0,0 +1,26 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###############################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
+#    All Rights Reserved
+############# Credits #########################################################
+#    Coded by: Yanina Aular <[e-mail]>
+#    Planified by: Humberto Arocha <[e-mail]>
+#    Audited by: Humberto Arocha <[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 purchase_requisition_line

=== added file 'purchase_requisition_line_price_unit/model/purchase_requisition_line.py'
--- purchase_requisition_line_price_unit/model/purchase_requisition_line.py	1970-01-01 00:00:00 +0000
+++ purchase_requisition_line_price_unit/model/purchase_requisition_line.py	2014-06-18 14:56:09 +0000
@@ -0,0 +1,86 @@
+# -*- encoding: utf-8 -*-
+########################################################################
+#
+#    OpenERP, Open Source Management Solution
+#    Copyright (C) 2004-2010 Tiny SPRL (<http://tiny.be>). All Rights Reserved
+#    $Id$
+#
+#    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 datetime import datetime
+from dateutil.relativedelta import relativedelta
+import time
+from openerp import netsvc
+
+from openerp.osv import fields, osv
+from openerp.tools.translate import _
+import openerp.addons.decimal_precision as dp
+from openerp import tools
+
+class purchase_requisition(osv.Model):
+    _inherit = "purchase.requisition"
+
+    def _get_requisition(self, cr, uid, ids, context=None):
+        result = {}
+        for line in self.pool.get('purchase.requisition.line').browse(cr, uid, ids, context=context):
+            result[line.requisition_id.id] = True
+        return result.keys()
+
+    def _amount_all(self, cr, uid, ids, field_name, arg, context=None):
+        res = {}
+        cur_obj=self.pool.get('res.currency')
+        for requisition in self.browse(cr, uid, ids, context=context):
+            res[requisition.id] = {
+                'amount_untaxed': 0.0,
+                'amount_tax': 0.0,
+                'amount_total': 0.0,
+            }
+            val = val1 = 0.0
+            cur = requisition.currency_id
+            for line in requisition.line_ids:
+               val1 += line.price_subtotal
+               for c in self.pool.get('account.tax').compute_all(cr, uid, [], line.price_unit, line.product_qty, line.product_id)['taxes']:
+                    val += c.get('amount', 0.0)
+            #res[requisition.id]['amount_tax']=cur_obj.round(cr, uid, cur, val)
+            amount_untaxed =cur_obj.round(cr, uid, cur, val1)
+            res[requisition.id]['amount_total']= amount_untaxed # + res[requisition.id]['amount_tax']
+        return res
+    
+    _columns = {
+        'amount_total': fields.function(_amount_all, digits_compute= dp.get_precision('Account'), string='Total',
+            store={
+                'purchase.requisition.line': (_get_requisition, None, 10),
+            }, multi="sums",help="The total amount"),
+    }
+
+class purchase_requisition_line(osv.Model):
+    _inherit = "purchase.requisition.line"
+
+    def _amount_line(self, cr, uid, ids, prop, arg, context=None):
+        res = {}
+        cur_obj=self.pool.get('res.currency')
+        tax_obj = self.pool.get('account.tax')
+        for line in self.browse(cr, uid, ids, context=context):
+            taxes = tax_obj.compute_all(cr, uid, [], line.price_unit, line.product_qty, line.product_id)
+            #cur = line.requisition_id.pricelist_id.currency_id
+            cur = line.requisition_id.currency_id
+            res[line.id] = cur_obj.round(cr, uid, cur, taxes['total'])
+        return res
+
+    _columns = {
+        'price_unit': fields.float('Unit Price', digits_compute= dp.get_precision('Product Price')),
+        'price_subtotal': fields.function(_amount_line, string='Subtotal', digits_compute= dp.get_precision('Account')),
+    }
+    

=== added directory 'purchase_requisition_line_price_unit/report'
=== added directory 'purchase_requisition_line_price_unit/security'
=== added directory 'purchase_requisition_line_price_unit/static'
=== added directory 'purchase_requisition_line_price_unit/static/description'
=== added file 'purchase_requisition_line_price_unit/static/description/index.html'
=== added directory 'purchase_requisition_line_price_unit/static/src'
=== added directory 'purchase_requisition_line_price_unit/static/src/css'
=== added directory 'purchase_requisition_line_price_unit/static/src/img'
=== added file 'purchase_requisition_line_price_unit/static/src/img/icon.png'
Binary files purchase_requisition_line_price_unit/static/src/img/icon.png	1970-01-01 00:00:00 +0000 and purchase_requisition_line_price_unit/static/src/img/icon.png	2014-06-18 14:56:09 +0000 differ
=== added directory 'purchase_requisition_line_price_unit/static/src/js'
=== added directory 'purchase_requisition_line_price_unit/static/src/xml'
=== added directory 'purchase_requisition_line_price_unit/test'
=== added directory 'purchase_requisition_line_price_unit/view'
=== added file 'purchase_requisition_line_price_unit/view/purchase_requisition_view.xml'
--- purchase_requisition_line_price_unit/view/purchase_requisition_view.xml	1970-01-01 00:00:00 +0000
+++ purchase_requisition_line_price_unit/view/purchase_requisition_view.xml	2014-06-18 14:56:09 +0000
@@ -0,0 +1,26 @@
+<?xml version="1.0"?>
+<openerp>
+    <data>
+        <record id="view_purchase_requisition_form_inherit_price_unit" model="ir.ui.view">
+            <field name="name">purchase.requisition.form.inherit.price_unit</field>
+            <field name="model">purchase.requisition</field>
+            <field name="inherit_id" ref="purchase_requisition.view_purchase_requisition_form"/>
+            <field name="arch" type="xml">
+                <xpath expr="//field[@name='line_ids']//tree//field[@name='product_qty'][last()]" position="after">
+                    <field name="price_unit" required="1"/>
+                    <field name="price_subtotal" required="1"/>
+                </xpath>
+                <xpath expr="//field[@name='line_ids']//form//field[@name='product_qty'][last()]" position="after">
+                    <field name="price_unit" required="1"/>
+                    <field name="price_subtotal" required="1"/>
+                </xpath>
+                <xpath expr="//field[@name='line_ids']" position="after">
+                    <group class="oe_subtotal_footer oe_right">
+                    <field name="amount_total" class="oe_subtotal_footer_separator" widget="monetary" options="{'currency_field': 'currency_id'}"/>
+                    </group>
+                </xpath>
+            </field>
+        </record> 
+
+    </data>
+</openerp>

=== added directory 'purchase_requisition_line_price_unit/wizard'
=== added file 'purchase_requisition_line_price_unit/wizard/__init__.py'
--- purchase_requisition_line_price_unit/wizard/__init__.py	1970-01-01 00:00:00 +0000
+++ purchase_requisition_line_price_unit/wizard/__init__.py	2014-06-18 14:56:09 +0000
@@ -0,0 +1,25 @@
+#!/usr/bin/python
+# -*- encoding: utf-8 -*-
+###############################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#    Copyright (C) OpenERP Venezuela (<http://www.vauxoo.com>).
+#    All Rights Reserved
+############# Credits #########################################################
+#    Coded by: Yanina Aular <[e-mail]>
+#    Planified by: Humberto Arocha <[e-mail]>
+#    Audited by: Humberto Arocha <[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/>.
+###############################################################################
+

=== added directory 'purchase_requisition_line_price_unit/workflow'