Merge lp:~vauxoo/addons-vauxoo/addons-vauxoo-6.0-product_partner_upc-dev-rodo into lp:addons-vauxoo

[Rodolfo Lopez]

[ADD][module product_partner_upc]
añade one2many en productos para agregar upc y un partner
esto permite que el mismo producto pueda ser reconocido por diferentes códigos segun el partner lo mencione.

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

Rodo,
Cambia el author y descripción del __openerp__.py y del __terp__.py
Así como también agrega los comentarios de licencia al inicio por favor.

Sustituye los query por search a toda costa.

Y quita el search de packaging que ese es de otro módulo.

Verifica por que hay 2 campos many2one a product.

Cambia el nombre del campo upc por product_code. (Tal cual lo hace actualmente product.supplierinfo, solo cambiando donde dice supplier, ahora es customer)
        'product_code': fields.char('Supplier Product Code', size=64, help="This supplier's product code will be used when printing a request for quotation. Keep empty to use the internal one."),

Y agrega también
        'product_name': fields.char('Supplier Product Name', size=128, help="This supplier's product name will be used when printing a request for quotation. Keep empty to use the internal one."),

Hay que modificar la venta, para que tome en el descripción el product_code & product_name del cliente, en su pedido de venta.

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

También agrega un index del product_code, para saber como se hace esto, verifica la función "def _auto_init"
del "account/account_move_line.py"

    def _auto_init(self, cr, context=None):
        super(account_move_line, self)._auto_init(cr, context=context)
        cr.execute('SELECT indexname FROM pg_indexes WHERE indexname = \'account_move_line_journal_id_period_id_index\'')
        if not cr.fetchone():
            cr.execute('CREATE INDEX account_move_line_journal_id_period_id_index ON account_move_line (journal_id, period_id)')

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

Agrega el campo "company_id" y pon el default, como lo hacen las demás funciones de los otros modelos.

Modifica el
_sql_constraints = [
         ('number_uniq', 'unique (upc)', 'UPC tiene que ser unico!')
     ]

Lo correcto debería de ser:
_sql_constraints = [
  ('number_uniq', 'unique(upc,partner_id,company_id)', 'UPC tiene que ser unico!')
]

(cambiar los mensajes a ingles, y con los nuevos nombres de campos)

Analizar la opción de mandar en el context el partner_id, desde la venta, para que lo procese la búsqueda de mapeo con sus códigos.

[lp:~vauxoo/addons-vauxoo/addons-vauxoo-6.0-product_partner_upc-dev-rodo]

288. By Rodolfo Lopez on 2012-06-04

[MERGE][delete querys, and add licenses]

289. By Luis Torres - http://www.vauxoo.com on 2012-06-29

[REF]Names were changed

290. By Luis Torres - http://www.vauxoo.com on 2012-06-29

[REF]Names were changed from partner_upc to customer_code

291. By Luis Torres - http://www.vauxoo.com on 2012-06-29

[ REF]Was changed to required fiel partner_id

292. By Luis Torres - http://www.vauxoo.com on 2012-06-30

[ADD]Add security and goups

293. By Luis Torres - http://www.vauxoo.com on 2012-06-30

[IMP]Add fiel company_id & your default

294. By Luis Torres - http://www.vauxoo.com on 2012-07-02

[IMP][product_customer_code]Add traducction & Constrains of product code

295. By Luis Torres - http://www.vauxoo.com on 2012-07-03

[ADD][product_customer_code]Sale.order.line was added to a context for when seeking the product_id just look client code that partner.

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

Modifica lo siguiente:
1) Crear el grupo manager y user (uno ya está creado)
2) Asignar al ir.rules el grupo manager & user segúń corresponda

Apóyate de la siguiente propuesta de merge:
https://code.launchpad.net/~vauxoo/addons-vauxoo/customs_rate_dev_jcarlos/+merge/112864

[lp:~vauxoo/addons-vauxoo/addons-vauxoo-6.0-product_partner_upc-dev-rodo]

296. By Luis Torres - http://www.vauxoo.com on 2012-07-06

[ADD][product_customer_code]Was create the groups user

297. By Luis Torres - http://www.vauxoo.com on 2012-07-07

[IMP][product_customer_code]Add traduction of english

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

Dejar solo un es_MX.po (hay 2 el otro es es_Mx.po)
Eliminar el .pot (es un binario que te genera poedit, que no se necesita)
Eliminar los comentarios de TODO
Agregar index para búsquedas más eficientes.

review: Needs Fixing

[lp:~vauxoo/addons-vauxoo/addons-vauxoo-6.0-product_partner_upc-dev-rodo]

298. By Moisés López - http://www.vauxoo.com on 2012-07-07

[REF] [product_customer_code] Rename standard security xml file

299. By Moisés López - http://www.vauxoo.com on 2012-07-07

[REF] [product_customer_code] Standard to i18n

300. By Moisés López - http://www.vauxoo.com on 2012-07-07

[FIX] [product_customer_code] Fix context.get('partner_id') validation

301. By Moisés López - http://www.vauxoo.com on 2012-07-07

[REF][product_customer_code] Change code to file product.py. Remove comment's. Add ToDo messages

302. By Moisés López - http://www.vauxoo.com on 2012-07-07

[FIX][product_customer_code] Add import to new file.

303. By Moisés López - http://www.vauxoo.com on 2012-07-07

[REF] [product_custome_code] Replace tab for spaces in xml view file

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

Agregarle al campo company_id el grupo multi-company

review: Needs Fixing

[lp:~vauxoo/addons-vauxoo/addons-vauxoo-6.0-product_partner_upc-dev-rodo]

304. By Moisés López - http://www.vauxoo.com on 2012-07-07

[REF] [product_customer_code] Add group multi-company to field company_id.
Add required company_id.
Change help text

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

review: Approve

=== added directory 'product_customer_code'
=== added file 'product_customer_code/__init__.py'
--- product_customer_code/__init__.py	1970-01-01 00:00:00 +0000
+++ product_customer_code/__init__.py	2012-07-07 21:55:21 +0000
@@ -0,0 +1,2 @@
+import product_customer_code
+import product
 
=== added file 'product_customer_code/__openerp__.py'
--- product_customer_code/__openerp__.py	1970-01-01 00:00:00 +0000
+++ product_customer_code/__openerp__.py	2012-07-07 21:55:21 +0000
@@ -0,0 +1,47 @@
+# -*- encoding: utf-8 -*-
+###########################################################################
+#    Module Writen to OpenERP, Open Source Management Solution
+#
+#    Copyright (c) 2012 Vauxoo - http://www.vauxoo.com/
+#    All Rights Reserved.
+#    info Vauxoo ([e-mail])
+############################################################################
+#    Coded by: el_rodo_1 ([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" : "Products Customer Code",
+    "version" : "1.0",
+    "author" : "Vauxoo",
+    "website" : "http://www.vauxoo.com/",
+    "license" : "AGPL-3",
+    "category" : "Generic Modules/Product",
+    "depends" : ["base", "product"],
+    "init_xml" : [],
+    "demo_xml" : [],
+    "description": """
+Add manies Codes of Customer's in product
+     """,
+    "update_xml" : ["security/product_customer_code_security.xml",
+                    "security/ir.model.access.csv",
+                    "product_customer_code.xml",
+                    "product_product.xml",
+                    
+                    ],
+    "active": False,
+    "installable": True,
+}
 
=== added directory 'product_customer_code/i18n'
=== added file 'product_customer_code/i18n/es.po'
--- product_customer_code/i18n/es.po	1970-01-01 00:00:00 +0000
+++ product_customer_code/i18n/es.po	2012-07-07 21:55:21 +0000
@@ -0,0 +1,92 @@
+# Translation of OpenERP Server.
+# This file contains the translation of the following modules:
+#	* product_customer_code
+#
+msgid ""
+msgstr ""
+"Project-Id-Version: OpenERP Server 6.1\n"
+"Report-Msgid-Bugs-To: \n"
+"POT-Creation-Date: 2012-07-02 20:40+0000\n"
+"PO-Revision-Date: 2012-07-02 20:40+0000\n"
+"Last-Translator: <>\n"
+"Language-Team: \n"
+"MIME-Version: 1.0\n"
+"Content-Type: text/plain; charset=UTF-8\n"
+"Content-Transfer-Encoding: \n"
+"Plural-Forms: \n"
+
+#. module: product_customer_code
+#: view:product.product:0
+msgid "Information"
+msgstr "Información"
+
+#. module: product_customer_code
+#: view:product.product:0
+msgid "Customer Code"
+msgstr "Código del Cliente"
+
+#. module: product_customer_code
+#: model:res.groups,name:product_customer_code.group_product_customer_code
+msgid "Product_Customer / Manager"
+msgstr "Producto_Cliente / Gerente"
+
+#. module: product_customer_code
+#: field:product.customer.code,product_code:0
+msgid "Customer Product Code"
+msgstr "Código del Producto por Cliente"
+
+#. module: product_customer_code
+#: field:product.customer.code,company_id:0
+msgid "Company"
+msgstr "Compañia"
+
+#. module: product_customer_code
+#: view:product.customer.code:0
+msgid "Product Customer Code"
+msgstr "Código del Producto por Cliente"
+
+#. module: product_customer_code
+#: model:ir.model,name:product_customer_code.model_product_product
+#: field:product.customer.code,product_id:0
+msgid "Product"
+msgstr "Producto"
+
+#. module: product_customer_code
+#: field:product.product,product_customer_code_ids:0
+msgid "Customer Codes"
+msgstr "Código del Cliente"
+
+#. module: product_customer_code
+#: constraint:product.product:0
+msgid "Error: Invalid ean code"
+msgstr "Error: Código EAN erróneo"
+
+#. module: product_customer_code
+#: help:product.customer.code,product_code:0
+msgid "This customer's product code will be used when searching into a request for quotation."
+msgstr "El código de producto de este cliente se utiliza cuando se busca dentro de una solicitud de cotización."
+
+#. module: product_customer_code
+#: field:product.customer.code,product_name:0
+msgid "Customer Product Name"
+msgstr "Nombre del producto"
+
+#. module: product_customer_code
+#: field:product.customer.code,partner_id:0
+msgid "Customer"
+msgstr "Cliente"
+
+#. module: product_customer_code
+#: help:product.customer.code,product_name:0
+msgid "This customer's product name will be used when searching into a request for quotation."
+msgstr "El nombre de producto de este cliente se utiliza cuando se busca dentro de una solicitud de cotización."
+
+#. module: product_customer_code
+#: model:ir.model,name:product_customer_code.model_product_customer_code
+msgid "Add manies Code of Customer's"
+msgstr "Agregar varios códigos de clientes"
+
+#. module: product_customer_code
+#: sql_constraint:product.customer.code:0
+msgid "Product Code must be unique"
+msgstr "El código del producto debe ser unico"
 
=== added file 'product_customer_code/product.py'
--- product_customer_code/product.py	1970-01-01 00:00:00 +0000
+++ product_customer_code/product.py	2012-07-07 21:55:21 +0000
@@ -0,0 +1,51 @@
+# -*- coding: 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: Rodo ([e-mail]),Moy ([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 osv import osv, fields
+from tools.translate import _
+
+class product_product(osv.osv):
+    _inherit = "product.product"
+    
+    _columns = {
+        'product_customer_code_ids': fields.one2many('product.customer.code', 'product_id', 'Customer Codes'),
+    }
+    
+    def name_search(self, cr, user, name='', args=None, operator='ilike', context=None, limit=80):
+        res = super(product_product, self).name_search(cr, user, name, args, operator, context, limit)
+        product_customer_code_obj=self.pool.get('product.customer.code')
+        if not res:
+            ids=[]
+            partner_id = context.get('partner_id', False)
+            if partner_id:
+                id_prod_code=product_customer_code_obj.search(cr, user, [('product_code','=',name),('partner_id','=',partner_id)], limit=limit, context=context)
+                #TODO: Search for product customer name
+                id_prod=id_prod_code and product_customer_code_obj.browse(cr, user, id_prod_code, context=context) or []
+                for ppu in id_prod:
+                    ids.append(ppu.product_id.id)
+            if ids:
+                res = self.name_get(cr, user, ids, context)
+        return res
+product_product()
 
=== added file 'product_customer_code/product_customer_code.py'
--- product_customer_code/product_customer_code.py	1970-01-01 00:00:00 +0000
+++ product_customer_code/product_customer_code.py	2012-07-07 21:55:21 +0000
@@ -0,0 +1,52 @@
+# -*- coding: 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: Rodo ([e-mail]),Moy ([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 osv import osv, fields
+from tools.translate import _
+
+class product_customer_code(osv.osv):
+    _name = "product.customer.code"
+    _description = "Add manies Code of Customer's"
+    
+    _rec_name = 'product_code'
+    
+    _columns = {
+        'product_code': fields.char('Customer Product Code', size=64, required=True, help="This customer's product code will be used when searching into a request for quotation."),
+        'product_name': fields.char('Customer Product Name', size=128, help="This customer's product name will be used when searching into a request for quotation."),
+        'product_id': fields.many2one('product.product', 'Product', required=True),
+        'partner_id': fields.many2one('res.partner', 'Customer', required=True),
+        'company_id': fields.many2one('res.company','Company', required=True),
+    }
+    
+    _defaults = {
+        'company_id': lambda s, cr, uid, c: s.pool.get('res.company')._company_default_get(cr, uid, 'product.customer.code', context=c),
+    }
+    
+    _sql_constraints = [
+        ('unique_code', 'unique(product_code,company_id,partner_id)', 'Product Code must be unique'),
+    ]
+    
+    #TODO: Add index to product_code, partner_id
+product_customer_code()
 
=== added file 'product_customer_code/product_customer_code.xml'
--- product_customer_code/product_customer_code.xml	1970-01-01 00:00:00 +0000
+++ product_customer_code/product_customer_code.xml	2012-07-07 21:55:21 +0000
@@ -0,0 +1,32 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+    
+        <record model="ir.ui.view" id="view_product_customer_code_form">
+            <field name="name">view.product.customer.code.form</field>
+            <field name="model">product.customer.code</field>
+            <field name="type">form</field>
+            <field name="arch" type="xml">
+                <form string="Product Customer Code">
+                    <field name="product_code"/>
+                    <field name="partner_id"/>
+                    <field name="company_id" widget="selection" groups="base.group_multi_company"/>
+                </form>
+            </field>
+        </record>
+        <record model="ir.ui.view" id="view_product_customer_code_tree">
+            <field name="name">view.product.customer.code.tree</field>
+            <field name="model">product.customer.code</field>
+            <field name="type">tree</field>
+            <field name="arch" type="xml">
+                <tree string="Product Customer Code" editable="bottom">
+                    <field name="product_code"/>
+                    <field name="partner_id"/>
+                    <field name="company_id" widget="selection" groups="base.group_multi_company"/>
+                </tree>
+            </field>
+        </record>
+
+    </data>
+</openerp>
+
 
=== added file 'product_customer_code/product_product.xml'
--- product_customer_code/product_product.xml	1970-01-01 00:00:00 +0000
+++ product_customer_code/product_product.xml	2012-07-07 21:55:21 +0000
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+        
+        <record model="ir.ui.view" id="product_normal_form_inh_product_customer_code_01">
+            <field name="name">product.normal.form.inh.product.customer.code.01</field>
+            <field name="model">product.product</field>
+            <field name="type">form</field>
+            <field name="inherit_id" ref="product.product_normal_form_view"/>
+            <field name="arch" type="xml">
+                <page string="Information" position="after">
+                    <page string="Customer Code">
+                        <field name="product_customer_code_ids" colspan="4" nolabel="1"/>
+                    </page>
+                </page>
+            </field>
+        </record>
+        
+    </data>
+</openerp>
 
=== added directory 'product_customer_code/security'
=== added file 'product_customer_code/security/ir.model.access.csv'
--- product_customer_code/security/ir.model.access.csv	1970-01-01 00:00:00 +0000
+++ product_customer_code/security/ir.model.access.csv	2012-07-07 21:55:21 +0000
@@ -0,0 +1,3 @@
+id,name,model_id:id,group_id:id,perm_create,perm_unlink,perm_write,perm_read
+access_product_customer_code_user,product.customer.code.user,model_product_customer_code,,0,0,0,1
+access_product_customer_code_manager,product.customer.code.manager,model_product_customer_code,,1,1,1,1
 
=== added file 'product_customer_code/security/product_customer_code_security.xml'
--- product_customer_code/security/product_customer_code_security.xml	1970-01-01 00:00:00 +0000
+++ product_customer_code/security/product_customer_code_security.xml	2012-07-07 21:55:21 +0000
@@ -0,0 +1,12 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data noupdate="0">
+            <record id="group_product_customer_code_manager" model="res.groups">
+                <field name="name">Product_Customer / Manager</field>
+            </record>
+            <record id="group_product_customer_code_user" model="res.groups">
+                <field name="name">Product_Customer / User</field>
+            </record>
+
+    </data>
+</openerp>