product_customer_code.py

# -*- coding: utf-8 -*-
###########################################################################
#    Module Writen to OpenERP, Open Source Management Solution
#
#    Copyright (c) 2012 Vauxoo - http://www.vauxoo.com
#    All Rights Reserved.
#    info@vauxoo.com
############################################################################
#    Coded by: Rodo (rodo@vauxoo.com),Moy (moylop260@vauxoo.com)
############################################################################
#
#    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
from openerp.tools.translate import _


class product_customer_code(orm.Model):
    _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=False),
    }

    _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 of customer must be unique'),
    ]

    # TODO: Add index to product_code, partner_id