1. zikzakmedia
  2. trytond-product_variant


trytond-product_variant / product.py

#This file is part product_variant module for Tryton.
#The COPYRIGHT file at the top level of this repository contains
#the full copyright notices and license terms.

import itertools
from trytond.pool import Pool
from trytond.model import ModelView, ModelSQL, fields
from trytond.pyson import Eval, Greater, Or, And, Not, Bool
from trytond.transaction import Transaction

class Product(ModelSQL, ModelView):
    _name = 'product.product'

    attribute_values = fields.Many2Many('product.product-attribute.value',
        'product', 'value', 'Values', readonly=True,
        order=[('value', 'DESC')])
    template = fields.Many2One('product.template', 'Product Template',
        ondelete='CASCADE', select=1,
            'required': Greater(Eval('active_id', 0), 0),
            'invisible': Not(Greater(Eval('active_id', 0), 0)),
            'readonly': Not(Bool(Eval('variants')))

    def create(self, values):
        if values.has_key('template') and not values['template']:
            values = values.copy()
        return super(Product, self).create(values)


class Template(ModelSQL, ModelView):
    _name = "product.template"

    basecode = fields.Char('Basecode',
            'invisible': Not(Bool(Eval('attributes')))
        }, depends=['attributes'])
    attributes = fields.Many2Many('product.template-product.attribute',
        'template', 'attribute', 'Attributes')
    variants = fields.Function(fields.Integer('Variants', select=1),
        'get_variants', searcher='search_variants')

    def __init__(self):
        super(Template, self).__init__()
                'generate_variants': {
                    'invisible': Eval('template'),

        for column in self._columns.itervalues():
            already = False
            if 'readonly' in column.states:
                already = column.states['readonly']
            column.states = {'readonly': Or(And(Bool(Eval('template')),
                Bool(Eval('variants'))), already)}

    def delete(self, ids):
        #don't know - but this prevent always the deleation of the template
        #so the user has to delete empty templates manually
        ids = list(set(ids))
        if Transaction().delete:
            return ids
        return super(Template, self).delete(ids)

    def get_variants(self, ids, name):
        res = {}
        for template in self.browse(ids):
            variants = len(template.products)
            if variants <= 1:
                variants = None
            res[template.id] = variants
        return res

    def search_variants(self, name, clause):
        res = []
        ids = self.search([])
        records = self.browse(ids)
        for template in records:
                if len(template.products) >= clause[2]:
        return [('id', 'in', res)]

    def create_code(self, basecode, variant):
        config_obj = Pool().get('product.variant.configuration')
        config = config_obj.browse(1)
        sep = config.code_separator or ''
        code = '%s%s' % (basecode or '', ['', sep][bool(basecode)])
        code = code + sep.join(i.code for i in variant)
        return code

    def create_product(self, template, variant):
        "create the product"
        pool = Pool()
        product_obj = pool.get('product.product')
        value_obj = pool.get('product.product-attribute.value')
        code = self.create_code(template.basecode, variant)
        new_id = product_obj.create({'template': template.id, 'code': code})
        for value in variant:
            value_obj.create({'product': new_id, 'value': value.id})
        return True

    def generate_variants(self, ids):
        """generate variants"""
        if not ids:
            return False
        for template in self.browse(ids):
            if not template.attributes:
            already = set(tuple(i.attribute_values) for i in template.products)
            to_del = [i.id for i in template.products
                      if not i.attribute_values]
            values = [i.values for i in template.attributes]
            variants = itertools.product(*values)
            for variant in variants:
                if not variant in already:
                    self.create_product(template, variant)
        return True


class ProductAttribute(ModelSQL, ModelView):
    "Product Attribute"
    _name = "product.attribute"
    _description = __doc__

    sequence = fields.Integer('Sequence')
    name = fields.Char('Name', required=True, translate=True, select=1,
                       order_field="%(table)s.sequence %(order)s")
    values = fields.One2Many('product.attribute.value', 'attribute', 'Values')

    def __init__(self):
        super(ProductAttribute, self).__init__()
        self._order.insert(0, ('sequence', 'ASC'))


class AttributeValue(ModelSQL, ModelView):
    "Values for Attributes"
    _name = "product.attribute.value"
    _description = __doc__

    sequence = fields.Integer('Sequence')
    name = fields.Char('Name', required=True, select=1)
    code = fields.Char('Code', required=True)
    attribute = fields.Many2One('product.attribute', 'Product Attribute',

    def __init__(self):
        super(AttributeValue, self).__init__()
        self._order.insert(0, ('sequence', 'ASC'))


class ProductTemplateAttribute(ModelSQL, ModelView):
    "Product Template - Product Attribute"
    _name = "product.template-product.attribute"
    _description = __doc__

    attribute = fields.Many2One('product.attribute', 'Product Attribute',
            ondelete='RESTRICT', required=True)
    template = fields.Many2One('product.template', 'Product template',
            ondelete='CASCADE', required=True)


class ProductAttributeValue(ModelSQL, ModelView):
    "Product - Product Attribute Value"
    _name = "product.product-attribute.value"
    _description = __doc__

    product = fields.Many2One('product.product', 'Product',
            ondelete='CASCADE', required=True)
    value = fields.Many2One('product.attribute.value', 'Attribute Value',
            ondelete='CASCADE', required=True)

    def search(self, args, offset=0, limit=None, order=None, count=False,
        res = super(ProductAttributeValue, self).search(args,
                offset=offset, limit=limit, order=order,
                count=count, query_string=query_string)
        obs = [(ob.value.attribute.sequence, ob.id) for ob in self.browse(res)]
        return [i[1] for i in obs]