1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
# -*- 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