good/sell/models/customer_goods.py

from odoo import fields, models, api


class CustomerGoods(models.Model):
    _name = 'customer.goods'
    _description = '客户供货价格表'
    _order = 'sequence,date desc,min_qty desc'

    sequence = fields.Integer('优先级')
    goods_id = fields.Many2one('goods', '商品', required=True, ondelete='cascade', help='商品')
    customer_id = fields.Many2one(
        string='客户',
        required=True,
        comodel_name='partner',
        domain=[('c_category_id', '!=', False)],
        ondelete='cascade',
        help='客户',
    )
    price = fields.Float('价格', digits='Price', help='给客户供货的价格')
    min_qty = fields.Float('起订量', digits='Quantity', help='销售商品时，大于或等于起订量时，商品的价格才取该行的销售价')
    date = fields.Date('生效日期')
    note = fields.Text('备注')
    company_id = fields.Many2one('res.company', '公司', change_default=True, default=lambda self: self.env.company)


class Partner(models.Model):
    _inherit = 'partner'

    customer_goods_ids = fields.One2many('customer.goods', 'customer_id', '销售商品', help='给客户的基于起订量的销售商品价格表')


class Goods(models.Model):
    _inherit = 'goods'

    customer_ids = fields.One2many('customer.goods', 'goods_id', '销售价格', help='给各客户的基于起订量的销售价格表')