class Option(models.Model):
name = models.CharField(max_length=50, help_text='Option Name - shown in config grid unless overriden by ProdutOption name.')
usage_notes = models.CharField(max_length=80, blank=True, help_text='Usage notes - used internally to disambiguate options with the same name.')
sortorder = models.IntegerField( help_text='Sort order for this option - The options appear ordered by this in the config grid.')
#choices = models.ManyToManyField (Choice, related_name='options', help_text='"OptionList" of Choices - NEW July 2011 for POOL architecture.') # through='OptionList',
choices = models.ManyToManyField ("Choice", related_name='+', help_text='"OptionList" of Choices - NEW July 2011 for POOL architecture.') # through='OptionList',
blurb = models.TextField (blank=True, help_text='Short description, typically a few lines, HTML OK.')
description = models.TextField (blank=True, help_text='Detailed description, HTML OK.')
#dependencies = models.CharField(max_length=50, help_text="Not used as of July 2011 - let's do something with this - JJW")
#faq = models.TextField(Blank=True, help_text="Not used as of July 2011 - let's do something with this - JJW")
comments = models.TextField (blank=True, help_text='Internal notes and comments. Please add dates & your initials')
published = models.BooleanField (default=True)
created = models.DateTimeField(auto_now_add=True)
updated = models.DateTimeField(auto_now=True)
objects = PublishedManager()
def __unicode__ (self):
#return smart_str(self.name)
if self.usage_notes:
return u'%s: %s (%s)' % (self.sortorder, self.name, self.usage_notes)
else:
return u'%s: %s' % (self.sortorder, self.name)
class Meta:
db_table = u'options'
ordering = ['sortorder']
class ChoiceCategory(models.Model):
name = models.CharField(max_length=80)
abbrev = models.CharField(max_length=10, blank=True, help_text= 'For prefixes on choice display names - typically 3 chars, uppercase')
sohigh = models.IntegerField ("High Sort Order", default=0) # blank=True,
solow = models.IntegerField ("Low Sort Order", default=0) # blank=True,
parent = models.ForeignKey('self', null=True, blank=True, related_name='children')
published = models.BooleanField (default=True)
created = models.DateTimeField(auto_now_add=True)
updated = models.DateTimeField(auto_now=True)
objects = PublishedManager()
#def __unicode__ (self):
# return '%s (%s)' % (self.name, self.abbrev)
# could rename this to label
def __unicode__ (self):
s = self.abbrev or self.name
if self.parent:
s = u'%s:%s' % (self.parent, s)
return s
class Meta:
verbose_name_plural = "Choice Categories"
db_table = u'choicecategories'
class Categories (Imageable):
name = models.CharField (max_length=50, help_text='Category Name - Capitals, spaces OK. slugified for urls.')
slug = models.SlugField ( help_text='Category url name - slugified from name field.')
title = models.CharField (max_length=100, blank=True, help_text='If present, used for page title (useful for SEO).')
blurb = models.TextField (blank=True, help_text='Short description, typically a few lines, HTML OK.')
description = models.TextField (blank=True, help_text='Detailed description, HTML OK. Used for cetegory page.')
comments = models.TextField (blank=True, help_text='Internal notes and comments. Please add dates & your initials')
sortorder = models.IntegerField (default=100)
meta_title = models.CharField (max_length=512, blank=True, help_text="Meta title")
meta_description = models.TextField (blank=True, help_text="Meta description")
meta_keywords = models.TextField (blank=True, help_text="Meta keywords")
published = models.BooleanField (default=True)
created = models.DateTimeField (auto_now_add=True)
updated = models.DateTimeField (auto_now=True)
objects = PublishedManager()
tags = TaggableManager(blank=True)
def __unicode__ (self):
return self.name
class Meta:
db_table = u'categories'
verbose_name = 'Category'
verbose_name_plural = 'Categories'
ordering = ['sortorder', 'name']
def get_absolute_url (self):
return self.url
@property
def url (self):
return "/products/%s/" % self.slug
@property
def prods_as_list_divs (self): # Used in category page (product list)
if [True for p in Product.objects.published().filter (category=self) if not p.blurb]:
# don't return any unless they're all present for this category - remove after migration - JJW 10/14/15
return ''
return mark_safe (
'\n'.join ([p.as_list_div for p in Product.objects.published().filter (category=self)]) # .order_by('-sortorder')
)
def prods_as_lis (self):
return mark_safe (TagStream22()
.li (prod = Product.objects.filter (category=self, published=True))
.a ('{prod.name}', href='{prod.url}', title='{prod.title_or_name}')
.render()
)
def prods_as_divs (self):
return mark_safe (TagStream22()
.div (prod = Product.objects.filter (category=self, published=True), _class='product')
.a ('{prod.name}', href='{prod.url}', title='{prod.title_or_name}')
.render()
)
class Publishable (models.Model): # ABC
published = models.BooleanField (default=True)
created = models.DateTimeField (auto_now_add=True)
updated = models.DateTimeField (auto_now=True)
objects = PublishedManager()
class Meta:
abstract = True
class Choice(models.Model):
name = models.CharField(max_length=80)
#supplier = models.IntegerField(blank=True, help_text="Primary supplier of this component") # someday an m2m to mfrs, distribs
source = models.CharField(max_length=80, blank=True)
price = models.FloatField(null=True, blank=True, help_text='Override cost-based calculated price with this (not used much)')
cost = models.FloatField(help_text='Our internal cost, used to calculate prices & differences')
sortorder = models.IntegerField()
multiplier = models.IntegerField(null=True, help_text='Override internal multiplier with this if >0 (not used much, can be 1 to sell at cost)')
comment = models.TextField(blank=True, null=True)
choicecategory = models.ForeignKey("ChoiceCategory", verbose_name='category', default=get_misc_choice_category)
blurb = models.TextField(blank=True, help_text='Short description, typically a few lines, HTML OK.')
# description? specs? features? esp when nested..
#comments = models.TextField (blank=True, help_text='Internal notes and comments. Please add dates & your initials')
options = models.ManyToManyField (Option, through=Option.choices.through, related_name='+')
published = models.BooleanField(default=True)
created = models.DateTimeField(auto_now_add=True)
updated = models.DateTimeField(auto_now=True)
objects = PublishedManager()
def __unicode__ (self):
#return '%s ($ %0.2f)' % (smart_str(self.name), self.cost) # , %s, %s]' % (smart_str(self.name), self.cost, self.price, self.multiplier)
#return '%s ($%s)' % (smart_str(self.name), self.cost) # , %s, %s]' % (smart_str(self.name), self.cost, self.price, self.multiplier)
# JJW 4/24/14
return '%s:%s ($%s)' % (self.choicecategory, smart_str(self.name), self.cost) # , %s, %s]' % (smart_str(self.name), self.cost, self.price, self.multiplier)
@property
def calc_markup (self):
if self.multiplier:
return self.multiplier
else:
return 1.35 # Move to a "global settings" table or definition location
@property
def calc_price (self):
if self.price:
return self.price
else:
return self.cost * self.calc_markup
#def calc_pricedelta (self, baseline):
# pass
class Meta:
db_table = u'choices'
ordering = ['sortorder', 'cost']
class Prodopt(models.Model):
# 4 NEW fields SAT 7/9/11
name = models.CharField(max_length=64, blank=True, help_text='Name to display in config grid - blank uses the Option name by default.')
qty = models.IntegerField(default=1, help_text='The <b>Option Quantity</b> - the number of lines of this option to display in config grid. Defaults to 1.')
single = models.BooleanField (default=False, help_text='If checked, there are no OptionChoices, the defaultchoice is the only possible choice.')
required = models.BooleanField (default=False, help_text='If checked, this option will not have a "none" choice. If false, a "none" choice will be available.')
choices_orderby = models.CharField(max_length=20, choices=choice_orderby_choices, default='cost', help_text='Name to display in config grid - blank uses the Option name by default.')
allowed_quantities = models.CommaSeparatedIntegerField (max_length=80, blank=True, default='', help_text="The allowed <b>Choice Quantities</b> - a comma-separated list of integers, eg '1,2,4' etc. Blank means don't display a quantity box.")
product = models.ForeignKey(Product, db_column='productid')
option = models.ForeignKey(Option, db_column='optionid')
choices = models.ManyToManyField (Choice, through='Prodoptchoice', related_name='prodopts', blank=True, help_text='Legacy ProductOptionChoices - overrides OptionChoice list if present - Feb2012 JJW')
defaultchoice = models.ForeignKey(Choice, default=get_none_choice, db_column='defaultchoiceid', help_text="Default choice from list of option-choices or legacy POCs - <b><span style='color:red'>SAVE TWICE to set this correctly</span></b>, otherwise fault will occur on ajax product update!") # default='TBD',null=True, blank=True
published = models.BooleanField(default=True)
created = models.DateTimeField(auto_now_add=True)
updated = models.DateTimeField(auto_now=True)
objects = PublishedManager()
# these 4 from eRacks proto 7/10/11
def calc_relative_price (self, ch):
default_cost = self.defaultchoice.cost
return spreadto5 (ch.cost, default_cost, ch.calc_markup)
#default_price = self.defaultchoice.calc_price
#return ch.calc_price - default_price
def choice_name_and_price (self, ch):
relative_price = self.calc_relative_price (ch)
if relative_price:
return '%s ($%.2f%s)' % (ch.name, relative_price, ' ea' if self.allowed_quantities else '')
else:
return '%s' % ch.name
@property
def calc_name (self):
return self.name or self.option.name # or self.option.display_name
def option_choices (self):
if self.single:
#assert self.defaultchoice in self.option.choices.all()
result = [self.defaultchoice.id]
else:
result = list (self.option.choices.order_by (self.choices_orderby).values_list ('id', flat=True)) # all() #filter(published=True)],
if not self.required:
result.insert (0, none_choice_id) # insert at front
if self.required and none_choice_id in result:
result.remove (none_choice_id)
#return self.objects.in_bulk (result) % this returns a dict indexed by the id - we need the query set:
return Choice.objects.filter (id__in=result)
def all_choices (self):
if self.choices.count():
return self.choices.all()
else:
return self.option_choices()
def as_combos (self, lineid):
if self.defaultchoice:
selected = '%s,%s' % (lineid, self.defaultchoice.id)
else:
selected = None
result = ''
if self.allowed_quantities:
result += tags.dropdown ([(q,'%s,%s' % (lineid, q)) for q in self.allowed_quantities.split(',')], name='choiceqty', cls='choiceqty')
leaveroom = True
else:
leaveroom = False
#result += TagStream().select (name='choiceid').option (value='(1,2)', 'hi there', selected = t/f
result += tags.dropdown (
#[(self.choice_name_and_price (c), (self.option.id,c.id)) for c in self.option_choices()], #d='prodopt_%s' % self.option.id, # self.name or self.option.name.replace(' ','_'),
[(self.choice_name_and_price (c), '%s,%s' % (lineid, c.id)) for c in self.all_choices()],
name='choiceid', # self.name or self.option.name.replace(' ','_'),
selected=selected,
cls='choiceid' + (' leaveroom' if leaveroom else ''),
) # self.defaultchoice.id if self.defaultchoice else None)
return result
@property
def as_rows (self):
result = ''
for i in range (self.qty):
lineid = '%s_%s' % (self.id, i+1)
result += (TagStream()
.tr (d=lineid)
.td (self.calc_name, cls=lineid, title=self.option.blurb or self.calc_name + ' option')
.td (self.as_combos (lineid), cls=lineid + ' dropdowns')
.td (self.defaultchoice.name, cls='choiceinfo', title=self.defaultchoice.blurb or self.defaultchoice.name + ' (default choice)')
.td ('', cls='optprice')
#.td (self.option.blurb, d=self.defaultchoice.id)
.render()
)
return result
'''tags = self.qty * [TagStream()
.tr (d=self.id)
.td (self.calc_name, cls=self.id)
.td (self.as_combos, cls=self.id)
.td (self.defaultchoice.name, d=self.defaultchoice.id)
.render()
]
return tags'''
def __unicode__ (self):
return '%s: %s' % (self.product, self.option)
#def save(self, *args, **kwargs):
# print 'IN SAVE'
# print self.defaultchoice
# super(Prodopt, self).save(*args, **kwargs) # Call the "real" save() method.
class Meta:
verbose_name = 'Product Option'
db_table = u'prodopts'
class Product (Imageable):
name = models.CharField(max_length=50, help_text='Product name - by convention is "eRacks/<sku>".') # should derive one of these
sku = models.CharField(unique=True, max_length=50, help_text="Our sku, also used as our Model Number or MPN (Manufacturer's Part Number).")
baseprice = models.FloatField( help_text='Base / baseline price for this model.')
cost = models.FloatField( help_text='Our cost - note that this field is not updated as our costs change, so is likely to be old.')
category = models.ForeignKey("Categories", db_column='categoryid', help_text='Legacy Zope Category for this product.')
options = models.ManyToManyField (Option, through='Prodopt', help_text='ProductOptions for this product - used by BOTH legacy Zope PO-POC architecture, and the new Django PO-OL architecture.')
weight = models.IntegerField(default=40, help_text="Total shipping weight in lbs - defaults to 40.") # required!
baseoptions = models.CharField(max_length=254, blank=True) # is this used? 2/12 JJW
sortorder = models.IntegerField(default=0)
blurb = models.TextField(blank=True, help_text='Short description, typically a few lines, HTML OK.')
description = models.TextField(blank=True, help_text='Detailed description, HTML OK.')
features = models.TextField (blank=True, help_text='Features, shown on Product Features tab.') # old: which we split by line and display as bullets
#specs = models.TextField (blank=True, help_text='Specifications, which we split by line and display as bullets.')
comments = models.TextField (blank=True, help_text='Internal notes and comments. Please add dates & your initials')
link = models.CharField(max_length=150, blank=True) # is this used? 2/12 JJW
title = models.CharField(max_length=100, blank=True, help_text='If present, used for product page title (useful for SEO). Only for newer Django (non-Zope) products.')
meta_title = models.CharField (max_length=512, blank=True, help_text="Meta title")
meta_description = models.TextField (blank=True, help_text="Meta description")
meta_keywords = models.TextField (blank=True, help_text="Meta keywords")
meta_title = models.CharField (max_length=512, blank=True, help_text="Meta title")
meta_description = models.TextField (blank=True, help_text="Meta description")
meta_keywords = models.TextField (blank=True, help_text="Meta keywords")
created = models.DateTimeField(auto_now_add=True)
updated = models.DateTimeField(auto_now=True)
published = models.BooleanField(default=True, help_text='Filters whether product is shown in queries.')
objects = PublishedManager()
tags = TaggableManager(blank=True)
def __unicode__ (self):
return self.sku
def get_absolute_url (self):
return self.url # old: "/product/%s/" % self.sku
@property
def title_or_name (self):
#print 'TITLE OR NAME', self.title or self.name
return self.title or self.name
@property
def url (self):
return "/products/%s/%s/" % (self.category.slug, self.sku) # might want to slugify sku or add a slug field
@property
def slug (self):
return slugify (self.sku)
@property
def image (self):
imgs = self.images.published().order_by ('sortorder') [:1]
if imgs: return imgs [0]
@property
def image_tag (self):
imgs = self.images.published().order_by ('sortorder') [:1]
return imgs [0].tag() if imgs else ''
def product_options (self):
return self.prodopt_set.order_by("option")
@property
def calc_description (self):
if self.description:
return self.description
else:
return '(No Description)'
@property
def calc_specs (self):
if self.blurb:
return self.blurb
else:
return '(No Specifications)'
@property
def as_list_div (self): # For category page / product list - blurb, image, name
return tags.div (
tags.a (
tags.div (self.image_tag, class_="primary-image") +
tags.h3 (self.name),
href="%s" % self.url) +
tags.div (self.blurb, class_="product-blurb") + # clearfix
#tags.div ('Starting at ' +
# tags.a ('$%.f' % self.baseprice, class_="product-price", href="%s" % self.url),
# class_='product-price-line'),
tags.a ('Starting at ' +
tags.span ('$%.f' % self.baseprice, class_="product-price"),
class_='product-price-line btn btn-success', href="%s" % self.url),
class_='clearfix product-summary'
)
@property
def prodopts_as_table (self): # returns inner rows
return ''.join ([po.as_rows for po in self.product_options()])
class Meta:
db_table = u'products'
ordering = ['sortorder', 'sku']
class Categories(Imageable):
#images_dir = "images/categories/"
name = models.CharField(
max_length=50,
help_text='Category Name - Capitals, spaces OK. slugified for urls.')
slug = models.SlugField(
help_text='Category url name - slugified from name field.')
title = models.CharField(
max_length=100,
blank=True,
help_text='If present, used for page title (useful for SEO).')
blurb = models.TextField(
blank=True,
help_text='Short description, typically a few lines, HTML OK.')
description = models.TextField(
blank=True,
help_text='Detailed description, HTML OK. Used for cetegory page.')
comments = models.TextField(
blank=True,
help_text=
'Internal notes and comments. Please add dates & your initials')
#image = models.ImageField (max_length=100, blank=True, upload_to='images/categories/')
#image = FileBrowseField (max_length=200, blank=True, directory=images_dir)
#images = models.ManyToManyField (Image, blank=True)
sortorder = models.IntegerField(default=100)
meta_title = models.CharField(max_length=512,
blank=True,
help_text="Meta title")
meta_description = models.TextField(blank=True,
help_text="Meta description")
meta_keywords = models.TextField(blank=True, help_text="Meta keywords")
published = models.BooleanField(default=True)
created = models.DateTimeField(auto_now_add=True)
updated = models.DateTimeField(auto_now=True)
objects = PublishedManager()
objects = PublishedManager()
tags = TaggableManager(blank=True)
def __unicode__(self):
return self.name
class Meta:
db_table = u'categories'
verbose_name = 'Category'
verbose_name_plural = 'Categories'
ordering = ['sortorder', 'name']
def get_absolute_url(self):
return self.url
@property
def url(self):
return "/products/%s/" % self.slug
'''
def as_ul (self):
result = mark_safe (TagStream22()
.ul
.il (prod = Product.objects.filter (category=self))
.a ('{prod.name}', href='{prod.url}', title='{prod.title}')
.close_li
.render()
)
return result
'''
'''
# Nope 5/6/12 - needs more work :-( JJW
# KeyError: 'prod'
@classmethod
def cats_with_prods_as_ul (self):
result = mark_safe ('\n'.join ([TagStream24_5(cat=cat)
.ul
.il (prod = Product.objects.filter (category__name='{cat.name}'))
.a ('{prod.name}', href='{prod.url}', title='{prod.title}')
.close_li
.render()
for cat in Categories.objects.published()
]))
#result = mark_safe ('\n'.join [cat for cat in Categories.objects.published()])
return result
'''
'''
def prods_as_ul (self):
return mark_safe (TagStream22()
#.ul (_class="flyout")
.il (prod = Product.objects.filter (category=self))
.a ('{prod.name}', href='{prod.url}', title='{prod.title}')
.render()
)
'''
def prods_as_divs(self):
return mark_safe(TagStream22().div(
prod=Product.objects.filter(category=self, published=True),
_class='product').a('{prod.name}',
href='{prod.url}',
title='{prod.title}').render())
class Product(Imageable):
#images_dir = "images/products/"
name = models.CharField(
max_length=50,
help_text='Product name - by convention is "eRacks/<sku>".'
) # should derive one of these
sku = models.CharField(
unique=True,
max_length=50,
help_text=
"Our sku, also used as our Model Number or MPN (Manufacturer's Part Number)."
)
baseprice = models.FloatField(
help_text='Base / baseline price for this model.')
cost = models.FloatField(
help_text=
'Our cost - note that this field is not updated as our costs change, so is likely to be old.'
)
category = models.ForeignKey(
"Categories",
db_column='categoryid',
help_text='Legacy Zope Category for this product.')
options = models.ManyToManyField(
Option,
through='Prodopt',
help_text=
'ProductOptions for this product - used by BOTH legacy Zope PO-POC architecture, and the new Django PO-OL architecture.'
)
weight = models.IntegerField(
default=40, help_text="Total shipping weight in lbs - defaults to 40."
) # required!
baseoptions = models.CharField(max_length=254,
blank=True) # is this used? 2/12 JJW
#algorithm = models.TextField(blank=True)
sortorder = models.IntegerField(default=0)
#multiplier = models.IntegerField(blank=True, help_text='Markup multiplier to set the sale price for the product.')
blurb = models.TextField(
blank=True,
help_text='Short description, typically a few lines, HTML OK.')
description = models.TextField(blank=True,
help_text='Detailed description, HTML OK.')
features = models.TextField(
blank=True, help_text='Features, shown on Product Features tab.'
) # old: which we split by line and display as bullets
#specs = models.TextField (blank=True, help_text='Specifications, which we split by line and display as bullets.')
comments = models.TextField(
blank=True,
help_text=
'Internal notes and comments. Please add dates & your initials')
link = models.CharField(max_length=150,
blank=True) # is this used? 2/12 JJW
#image = FileBrowseField(max_length=200, blank=True, directory=images_dir)
#images = models.ManyToManyField (Image, blank=True)
title = models.CharField(
max_length=100,
blank=True,
help_text=
'If present, used for product page title (useful for SEO). Only for newer Django (non-Zope) products.'
)
#new_grid = models.BooleanField(default=False, help_text='If true, use the newer django-based grid to present the product grid view to the customer.')
meta_title = models.CharField(max_length=512,
blank=True,
help_text="Meta title")
meta_description = models.TextField(blank=True,
help_text="Meta description")
meta_keywords = models.TextField(blank=True, help_text="Meta keywords")
created = models.DateTimeField(auto_now_add=True)
updated = models.DateTimeField(auto_now=True)
published = models.BooleanField(
default=True, help_text='Filters whether product is shown in queries.')
objects = PublishedManager()
tags = TaggableManager(blank=True)
def __unicode__(self):
return self.sku
def get_absolute_url(self):
return self.url # old: "/product/%s/" % self.sku
@property
def url(self):
return "/products/%s/%s/" % (
self.category.slug, self.sku
) # might want to slugify sku or add a slug field
@property
def slug(self):
return slugify(self.sku)
def product_options(self):
return self.prodopt_set.order_by("option")
@property
def calc_description(self):
if self.description:
return self.description
else:
return '(No Description)'
@property
def calc_specs(self):
if self.blurb:
return self.blurb
else:
return '(No Specifications)'
#@property
#def calc_price (self):
# if
@property
def prodopts_as_table(self): # returns inner rows
return ''.join([po.as_rows for po in self.product_options()])
'''result = []
for po in self.product_options():
result += po.as_rows
return ''.join (result)
return ''.join ([(TagStream()
.tr
.td (po.calc_name, d=po.id)
.td (po.as_combo)
.td (po.defaultchoice.name, d=po.defaultchoice.id)
.render()
)
for po in self.product_options()
])'''
#used in django_connect (zope)
@property
def as_content(self): # org used for in_zope prototype 2011 or so
return (
TagStream().h1(self.name).div(
self.calc_description,
cls='description').div(self.calc_specs, cls='specs').img(
src='http://eracks.com/images/eracks_web_logo.png')
#.a (href=self.image).img (src='http://eracks.com/images/eracks_web_logo.png')
.a('More Photos', href=self.get_absolute_url()).span(
'Base Price: <b>$%.2f</b>' % self.baseprice,
cls='baseprice').span(
'As Configured: <b>$%.2f</b>' % self.baseprice,
cls='price').div('Default Configuration',
cls='summary').table(cls='configgrid').tr.
th('Option',
title='Hover over option to see more info').th('Choices').th(
'More Info', title='Hover over choice to see more info').th(
'Add',
title='Additions / subtactions from base price').render(
self.prodopts_as_table))
'''
@property
def as_config_tab (self):
return (TagStream()
.div (d='current', cls='panel') # 'Current Configuration',
.div ('Base Price: <b>$%.2f</b>' % self.baseprice, cls='baseprice')
.div ('As Configured: <b>$%.2f</b>' % self.baseprice, cls='price')
.div ('Default Configuration', cls='summary')
#.close_div # doesn't work w/older tagstream
.render()
+
TagStream()
.table (cls='configgrid')
.thead
.tr
.th ('Option', title='Hover over option to see more info')
.th ('Choices')
.th ('More Info', title='Hover over choice to see more info')
.th ('Add', title='Additions / subtactions from base price')
.render (self.prodopts_as_table) # doesn't work w/newer tagstreams 22 & 24_5 :-/
)
'''
class Meta:
db_table = u'products'
ordering = ['sortorder', 'sku']