def __init__(self, product, month, year): self.product = product super(ProductMonthsOfStockColumn, self).__init__( name=self.product.sms_code, value=lambda cell: historical_months_of_stock( cell.object, self.product, year, month, "No data"), sort_key_fn=lambda sp: historical_months_of_stock( sp, self.product, year, month, -1), titleized=False, safe=True, css_class=_stock_class, header_class="prod-%s" % product.sms_code)
def __init__(self, product, month, year): self.product = product super(ProductMonthsOfStockColumn, self).__init__(name=self.product.sms_code, value=lambda cell: historical_months_of_stock(cell.object, self.product, year, month, "No data"), sort_key_fn=lambda sp: historical_months_of_stock(sp, self.product, year, month, -1), titleized=False, safe=True, css_class=_stock_class, header_class = "prod-%s" % product.sms_code )
def _stock_class(cell): mos = historical_months_of_stock(cell.object, cell.column.product, cell.row.table.year, cell.row.table.month, -1) mos = float(mos) if mos == -1: return "insufficient_data prod-%s" % cell.column.product.sms_code elif mos == 0.00: return "zero_count stock_iconified prod-%s" % cell.column.product.sms_code elif mos < 1: return "low_stock stock_iconified prod-%s" % cell.column.product.sms_code elif mos <= 3: return "adequate_stock stock_iconified prod-%s" % cell.column.product.sms_code else: return "overstock stock_iconified prod-%s" % cell.column.product.sms_code
def _stock_class(cell): mos = historical_months_of_stock(cell.object, cell.column.product, cell.row.table.year, cell.row.table.month, -1) mos = float(mos) if mos == -1: return "insufficient_data prod-%s" % cell.column.product.sms_code elif mos == 0.00: return "zero_count stock_iconified prod-%s" % cell.column.product.sms_code elif mos < 1: return "low_stock stock_iconified prod-%s" % cell.column.product.sms_code elif mos <= 3: return "adequate_stock stock_iconified prod-%s" % cell.column.product.sms_code else: return "overstock stock_iconified prod-%s" % cell.column.product.sms_code