class StockHistoryDetailModel(BasicModel):
class Meta:
label_name = {
'is_enable': u'啟用',
'title': u'完整規格名稱',
}
history = Fields.KeyProperty(verbose_name=u'歷史記錄', kind=StockHistoryModel)
product_name = Fields.StringProperty(verbose_name=u'產品名稱')
product_image = Fields.StringProperty(verbose_name=u'產品圖片')
sku_object = Fields.KeyProperty(verbose_name=u'SKU 對象')
spec_full_name = Fields.SearchingHelperProperty(verbose_name=u'完整規格名稱', target='sku_object', target_field_name='spec_full_name')
sku_full_name = Fields.SearchingHelperProperty(verbose_name=u'sku 編號', target='sku_object', target_field_name='sku_full_name')
operation_type = Fields.StringProperty(verbose_name=u'操作類型') # 出庫、入庫、轉倉
warehouse = Fields.StringProperty(verbose_name=u'倉庫')
warehouse_target = Fields.StringProperty(verbose_name=u'目標倉庫')
quantity = Fields.IntegerProperty(verbose_name=u'數量')
@classmethod
def all_with_history(cls, history):
return cls.query(cls.history == history.key).order(-cls.sort)
@property
def sku_instance(self):
if not hasattr(self, '_sku'):
self._sku = self.sku_object.get()
return self._sku
class StockHistoryModel(BasicModel):
user = Fields.KeyProperty(verbose_name=u'使用者', kind=ApplicationUserModel)
user_name = Fields.StringProperty(verbose_name=u'使用者名稱')
status = Fields.BooleanProperty(verbose_name=u'狀態') # True 成功, False 失敗
result = Fields.StringProperty(verbose_name=u'結果訊息')
operation = Fields.StringProperty(verbose_name=u'操作類型') # 產品出入庫、訂單出貨、日常調動
remake = Fields.StringProperty(verbose_name=u'摘要')
order = Fields.KeyProperty(verbose_name=u'所屬訂單', kind=OrderModel)
temporary_key = Fields.StringProperty(verbose_name=u'訂單暫存序號')
temporary_items = Fields.SidePanelProperty(
verbose_name=u'相關項目',
text=u'點擊此處查看 相關項目',
auto_open=True,
uri='admin:product_stock:stock:side_panel_for_order')
@property
def details(self):
from stock_history_detail_model import StockHistoryDetailModel
return StockHistoryDetailModel.all_with_history(self)
class UserRoleModel(BasicModel):
user = Fields.ApplicationUserProperty(verbose_name=u'使用者')
role = Fields.KeyProperty(verbose_name=u'角色', kind=RoleModel)
@classmethod
def get_user_roles(cls, user):
return cls.query(cls.user == user.key)
@classmethod
def get_role(cls, role):
if isinstance(role, basestring):
role = RoleModel.get_by_name(role)
return role
@classmethod
def set_role(cls, user, role):
role = cls.get_role(role)
if role is None:
return None
n = cls.query(cls.user == user.key, cls.role == role.key).get()
if n is None:
n = cls()
n.user = user.key
n.role = role.key
n.put()
return n
@classmethod
def remove_role(cls, user, role):
role = cls.get_role(role)
if role is None:
return False
n = cls.query(cls.user == user.key, cls.role == role.key).get(keys_only=True)
if n is not None:
ndb.delete_multi([n])
return True
@classmethod
def has_role(cls, user, role):
role = cls.get_role(role)
if role is None:
return False
n = cls.query(cls.user == user.key, cls.role == role.key).get(keys_only=True)
if n:
return True
return False
class UserShopPointHistoryModel(BasicModel):
name = Fields.StringProperty(verbose_name=u'識別名稱')
shop_point_target = Fields.KeyProperty(verbose_name=u'所屬單位',
kind=UserShopPointModel)
order_no = Fields.StringProperty(verbose_name=u'訂單編號', default=u'')
order_amount = Fields.StringProperty(verbose_name=u'訂單金額', default=u'')
decrease_point = Fields.FloatProperty(verbose_name=u'點數减少', default=0)
increase_point = Fields.FloatProperty(verbose_name=u'點數增加', default=0)
point = Fields.FloatProperty(verbose_name=u'剩餘點數', default=0)
remark = Fields.TextProperty(verbose_name=u'說明', default=u'')
@classmethod
def all_enable(cls, target=None, *args, **kwargs):
if target:
return cls.query(
cls.shop_point_target == target.key).order(-cls.sort)
return cls.query().order(-cls.sort)
class StockKeepingUnitModel(BasicModel):
class Meta:
label_name = {
'is_enable': u'啟用',
'title': u'完整規格名稱',
'sku_full_name': u'sku 完整編號'
}
name = Fields.StringProperty(verbose_name=u'識別名稱')
product_no = Fields.StringProperty(verbose_name=u'產品編號')
sku_no = Fields.StringProperty(verbose_name=u'sku 編號')
spec_full_name = Fields.StringProperty(verbose_name=u'完整規格名稱')
image = Fields.ImageProperty(verbose_name=u'圖片')
use_price = Fields.BooleanProperty(verbose_name=u'使用獨立銷售價格', default=False)
price = Fields.FloatProperty(verbose_name=u'獨立銷售價格', default=-1)
use_cost = Fields.BooleanProperty(verbose_name=u'使用成本', default=False)
cost = Fields.FloatProperty(verbose_name=u'成本', default=0.0)
quantity = Fields.IntegerProperty(verbose_name=u'現存數量', default=0)
estimate = Fields.IntegerProperty(verbose_name=u'預估數量', default=0)
in_order_quantity = Fields.IntegerProperty(verbose_name=u'在訂單中的數量',
default=0)
pre_order_quantity = Fields.IntegerProperty(verbose_name=u'在預購中的數量',
default=0)
low_stock_quantity = Fields.IntegerProperty(verbose_name=u'庫存警戒線',
default=-1)
last_in_quantity = Fields.IntegerProperty(verbose_name=u'最後入庫數量',
default=0)
last_in_datetime = Fields.DateTimeProperty(verbose_name=u'最後入庫時間',
auto_now_add=True)
last_out_quantity = Fields.IntegerProperty(verbose_name=u'最後出庫數量',
default=0)
last_out_datetime = Fields.DateTimeProperty(verbose_name=u'最後入庫時間',
auto_now_add=True)
is_enable = Fields.BooleanProperty(verbose_name=u'顯示於前台', default=True)
can_be_purchased = Fields.BooleanProperty(verbose_name=u'可購買',
default=True)
use_automatic_increment = Fields.BooleanProperty(verbose_name=u'自動增量',
default=False)
automatic_increment_quantity = Fields.IntegerProperty(
verbose_name=u'增量的數量', default=0)
product = Fields.SearchingHelperProperty(verbose_name=u'所屬產品',
target='product_object',
target_field_name='title')
product_object = Fields.KeyProperty(verbose_name=u'所屬產品',
kind=ProductModel)
spec_name_1 = Fields.HiddenProperty(verbose_name=u'規格名稱 1')
spec_name_2 = Fields.HiddenProperty(verbose_name=u'規格名稱 2')
spec_name_3 = Fields.HiddenProperty(verbose_name=u'規格名稱 3')
spec_name_4 = Fields.HiddenProperty(verbose_name=u'規格名稱 4')
spec_name_5 = Fields.HiddenProperty(verbose_name=u'規格名稱 5')
spec_value_1 = Fields.HiddenProperty(verbose_name=u'規格值 1')
spec_value_2 = Fields.HiddenProperty(verbose_name=u'規格值 2')
spec_value_3 = Fields.HiddenProperty(verbose_name=u'規格值 3')
spec_value_4 = Fields.HiddenProperty(verbose_name=u'規格值 4')
spec_value_5 = Fields.HiddenProperty(verbose_name=u'規格值 5')
@property
def sku_full_name(self):
product_no = u''
if self.product_no is not u'' and self.product_no is not None:
product_no = '%s' % self.product_no
sku_post_name = u''
if self.name is not u'' and self.name is not None:
sku_post_name = self.name
if self.sku_no is not u'' and self.sku_no is not None:
sku_post_name = self.sku_no
if product_no is not u'' and sku_post_name is not u'':
return '%s-%s' % (product_no, sku_post_name)
return '%s%s' % (product_no, sku_post_name)
def before_put(self):
super(StockKeepingUnitModel, self).before_put()
product_no = u''
cat = self.product_object
if cat is not None:
try:
cat = cat.get()
product_no = cat.product_no
except:
pass
spec_list = (u'%s' % self.spec_full_name).split(u',')
i = 0
setattr(self, 'product_no', product_no)
for index in range(0, len(spec_list)):
spec = spec_list[index].split(u':')
setattr(self, 'spec_name_%s' % (index + 1), spec[0])
setattr(self, 'spec_value_%s' % (index + 1), spec[1])
@property
def title(self):
return self.spec_full_name
@property
def quantity_percent(self):
quantity = self.quantity if self.quantity is not None else 0
last_in_quantity = self.last_in_quantity if self.last_in_quantity is not None else 0
if last_in_quantity == 0:
return 0
if last_in_quantity < self.low_stock_quantity:
last_in_quantity = self.low_stock_quantity
return int((float(quantity) / float(last_in_quantity)) * 10000) / 100.0
@property
def is_low_stock_level(self):
quantity = self.quantity if self.quantity is not None else 0
low_stock_quantity = self.low_stock_quantity if self.low_stock_quantity is not None else -1
return quantity <= low_stock_quantity
@classmethod
def all_enable(cls, product=None, *args, **kwargs):
cat = None
if product:
cat = ProductModel.get_by_name(product)
if cat is None:
return cls.query(cls.is_enable == True).order(-cls.sort)
else:
return cls.query(cls.product_object == cat.key,
cls.is_enable == True).order(-cls.sort)
@classmethod
def find_by_product(cls, product):
return cls.query(cls.product_object == product.key).order(
cls.spec_full_name)
def change_estimate_quantity(self, sub_quantity=0, add_quantity=0):
self.estimate = self.estimate - abs(sub_quantity) + abs(add_quantity)
if self.estimate < 0:
self.estimate = 0
def change_pre_order_quantity(self, sub_quantity=0, add_quantity=0):
self.pre_order_quantity = self.pre_order_quantity - abs(
sub_quantity) + abs(add_quantity)
if self.pre_order_quantity < 0:
self.pre_order_quantity = 0
def change_in_order_quantity(self, sub_quantity=0, add_quantity=0):
self.in_order_quantity = self.in_order_quantity - abs(
sub_quantity) + abs(add_quantity)
if self.in_order_quantity < 0:
self.in_order_quantity = 0
@property
def quantity_can_be_used(self):
n = self.quantity - self.in_order_quantity - self.estimate
if n < 0:
return 0
return n
class ShoppingCartItemModel(BasicModel):
cart = Fields.KeyProperty(verbose_name=u'購物車', kind=ShoppingCartModel)
spec = Fields.KeyProperty(verbose_name=u'產品規格',
kind=ProductSpecificationModel)
user = Fields.ApplicationUserProperty(verbose_name=u'使用者')
product_object = Fields.KeyProperty(verbose_name=u'所屬產品',
kind=ProductModel)
title = Fields.StringProperty(verbose_name=u'產品名稱', default=u'')
product_name = Fields.StringProperty(verbose_name=u'產品名稱(系統)', default=u'')
product_no = Fields.StringProperty(verbose_name=u'產品型號', default=u'')
product_image = Fields.StringProperty(verbose_name=u'產品圖片', default=u'')
price = Fields.FloatProperty(verbose_name=u'銷售價格', default=-1)
cost = Fields.FloatProperty(verbose_name=u'成本', default=0.0)
spec_full_name = Fields.StringProperty(verbose_name=u'完整規格名稱', default=u'')
# 庫存相關
try:
from plugins.product_stock.models.stock_keeping_unit_model import StockKeepingUnitModel
except ImportError:
class StockKeepingUnitModel(BasicModel):
pass
sku = Fields.KeyProperty(verbose_name=u'最小庫存單位',
kind=StockKeepingUnitModel)
sku_full_name = Fields.StringProperty(verbose_name=u'產品最小庫存名稱')
expired_time = Fields.FloatProperty(verbose_name=u'庫存回收時間')
quantity = Fields.IntegerProperty(verbose_name=u'數量', default=0)
quantity_has_count = Fields.IntegerProperty(verbose_name=u'已計入庫存的數量',
default=0)
can_add_to_order = Fields.BooleanProperty(verbose_name=u'加至訂單中',
default=False)
try:
from plugins.supplier.models.supplier_model import SupplierModel
except ImportError:
class SupplierModel(BasicModel):
pass
supplier = Fields.CategoryProperty(kind=SupplierModel, verbose_name=u'供應商')
# 0=訂購(無庫存), 1=現貨, 2預購
order_type = Fields.StringProperty(verbose_name=u'訂購方式')
order_type_value = Fields.IntegerProperty(verbose_name=u'訂購方式(值)')
size_1 = Fields.FloatProperty(verbose_name=u'長度(公分)', default=10.0)
size_2 = Fields.FloatProperty(verbose_name=u'寬度(公分)', default=10.0)
size_3 = Fields.FloatProperty(verbose_name=u'高度(公分)', default=10.0)
weight = Fields.FloatProperty(verbose_name=u'重量(公斤)', default=10.0)
@classmethod
def get_or_create(cls, cart, user, product, spec, order_type=0):
try:
user_key = user.key
except AttributeError:
user_key = user
item = cls.query(cls.cart == cart.key, cls.user == user_key,
cls.product_object == product.key,
cls.spec == spec.key,
cls.order_type_value == order_type).get()
need_put = False
if item is None:
item = cls()
item.cart = cart.key
item.user = user_key
item.product_object = product.key
item.spec = spec.key
item.order_type_value = order_type
item.order_type = [u'訂購', u'現貨', u'預購'][order_type]
item.spec_full_name = spec.full_name
item.product_name = product.name
item.product_image = product.image
need_put = True
if order_type == 0:
item.can_add_to_order = True
for field_name in [
'title', 'product_no', 'price', 'cost', 'size_1', 'size_2',
'size_3', 'weight'
]:
if getattr(item, field_name) != getattr(product, field_name):
setattr(item, field_name, getattr(product, field_name))
need_put = True
if need_put:
item.put()
return item
@classmethod
def get(cls, user, sku, order_type_value=0):
return cls.query(cls.sku == sku.key, cls.user == user.key,
cls.order_type_value == order_type_value).get()
@classmethod
def get_or_create_with_spec(cls,
user,
spec,
quantity=0,
order_type_value=0):
product = spec.product_object.get()
item = cls.query(cls.sku == spec.key, cls.user == user.key,
cls.order_type_value == order_type_value).get()
if item is None:
item = cls()
item.spec = spec.key
item.user = user.key
item.order_type_value = order_type_value
item.product_object = product.key
try:
item.supplier = product.supplier.get().key
except:
pass
if order_type_value == 0:
item.order_type = u'訂購'
else:
item.order_type = u'預購'
item._spec = spec
item._product = product
item.title = product.title
item.product_no = product.product_no
item.product_image = product.image
item.spec_full_name = spec.spec_full_name
item.change_quantity(quantity)
item.put()
return item
@classmethod
def all_with_user(cls, user):
key = None
if user is not None:
key = user.key
return cls.query(cls.user == key).order(-cls.sort)
@classmethod
def before_delete(cls, key):
item = key.get()
if item.order_type_value == 0:
if item.quantity > 0:
try:
sku = item.sku_instance
sku.change_estimate_quantity(item.quantity_has_count)
sku.put()
except:
pass
def volumetric_weight(self, divisor=6000.0):
n = self.size_1 * self.size_2 * self.size_3 / float(divisor)
return n
@property
def spec_instance(self):
if not hasattr(self, '_spec'):
self._spec = self.spec.get()
return self._spec
@property
def sku_instance(self):
if not hasattr(self, '_sku'):
self._sku = self.sku.get()
return self._sku
@property
def product_instance(self):
if not hasattr(self, '_product'):
self._product = self.spec_instance.product_object.get()
return self._product
def change_quantity(self, quantity):
spec = self.spec_instance
product = self.product_instance
if self.order_type_value == 0:
config = ConfigModel.get_config()
if config.stock_recover:
self.expired_time = time() + config.stock_recover_time
else:
self.expired_time = time() + 525600
can_use_quantity = spec.quantity_can_be_used + int(
self.quantity_has_count)
old_quantity_has_count = self.quantity_has_count
if can_use_quantity >= quantity and product.can_order:
self.can_add_to_order = True
self.quantity = quantity
self.quantity_has_count = quantity
else:
self.can_add_to_order = False
self.quantity = 0
self.quantity_has_count = 0
spec.change_estimate_quantity(sub_quantity=old_quantity_has_count,
add_quantity=self.quantity)
spec.put()
else:
if product.can_pre_order:
self.can_add_to_order = True
self.quantity = quantity
else:
self.can_add_to_order = False
self.quantity = 0
spec.change_pre_order_quantity(sub_quantity=int(
self.quantity_has_count),
add_quantity=self.quantity)
spec.put()
def quantity_can_be_order(self, user=None, sku=None):
if sku is None:
sku = self.sku.get()
if self.order_type_value > 0:
return 999
if user and self.quantity is not None:
c = sku.quantity_can_be_used + self.quantity
if c > 0:
return c
return sku.quantity_can_be_used
class StockKeepingUnitInWarehouseModel(BasicModel):
class Meta:
label_name = {
'is_enable': u'啟用',
'title': u'完整規格名稱',
'sku_full_name': u'sku 編號'
}
sku = Fields.KeyProperty(kind=StockKeepingUnitModel,
verbose_name=u'所屬 SKU')
warehouse = Fields.KeyProperty(kind=WarehouseModel, verbose_name=u'所屬倉庫')
product = Fields.KeyProperty(kind=ProductModel, verbose_name=u'所屬產品')
quantity = Fields.IntegerProperty(verbose_name=u'在庫數量', default=0)
@classmethod
def stock_in(cls, warehouse, sku, quantity):
record = cls.get_or_create(sku=sku, warehouse=warehouse)
record.quantity = int(record.quantity) + int(quantity)
record.put()
sku.quantity = sku.quantity + quantity
sku.last_in_quantity = sku.quantity
sku.last_in_datetime = datetime.now()
sku.put()
return record
@classmethod
def stock_out_check(cls, warehouse, sku, quantity, auto_fill=False):
record = cls.get_or_create(sku=sku, warehouse=warehouse)
c = record.quantity - quantity
if c < 0 and auto_fill is False:
raise ValueError(u'錯誤 [ %s ] 的數量不足 %s 個，缺少 %s 個' %
(sku.spec_full_name, str(quantity), str(-c)))
@classmethod
def stock_out(cls, warehouse, sku, quantity, auto_fill=False):
record = cls.get_or_create(sku=sku, warehouse=warehouse)
record.quantity = record.quantity - quantity
record.put()
sku.quantity = sku.quantity - quantity
sku.last_out_quantity = sku.quantity
sku.last_out_datetime = datetime.now()
sku.put()
return record
@classmethod
def get_or_create(cls, sku, warehouse, quantity=0):
record = cls.query(cls.sku == sku.key,
cls.warehouse == warehouse.key).get()
if record is None:
record = cls()
record.sku = sku.key
record.product = sku.product_object
record.warehouse = warehouse.key
record.quantity = quantity
record.put()
return record
@classmethod
def get_all_with_product(cls, product, warehouse=None):
if warehouse is None:
return cls.query(cls.product == product.key)
else:
return cls.query(cls.product == product.key,
cls.warehouse == warehouse.key)
@classmethod
def create_sku_by_product(cls, product, warehouse=None):
from stock_keeping_unit_model import StockKeepingUnitModel as SKU
sku_list = SKU.query(SKU.product_object == product.key).fetch()
sku_list_in_warehouse = []
for item in sku_list:
sku_list_in_warehouse.append(cls.get_or_create(item, warehouse))
return sku_list_in_warehouse
class AlbumRelationModel(BasicModel):
name = Fields.StringProperty(verbose_name=u'識別名稱')
file = Fields.KeyProperty(verbose_name=u'檔案', kind=FileModel)
album = Fields.KeyProperty(verbose_name=u'相簿', kind=AlbumModel)
class ShoppingCartModel(BasicModel):
title = Fields.StringProperty(verbose_name=u'購物車名稱', default=u'預設')
user = Fields.ApplicationUserProperty(verbose_name=u'使用者')
total_size = Fields.FloatProperty(verbose_name=u'尺寸合計', default=0.0)
total_volume = Fields.FloatProperty(verbose_name=u'體積合計', default=0.0)
total_price = Fields.FloatProperty(verbose_name=u'金額合計', default=0.0)
total_weight = Fields.FloatProperty(verbose_name=u'重量總重', default=0.0)
total_volumetric_weight = Fields.FloatProperty(verbose_name=u'材積總重',
default=0.0)
cost_for_items = Fields.FloatProperty(verbose_name=u'成本(項目)',
default=0.0,
tab_page=4)
freight = Fields.FloatProperty(verbose_name=u'運費', default=0.0)
freight_type = Fields.KeyProperty(verbose_name=u'運送方式',
kind=FreightTypeModel)
try:
from plugins.supplier.models.supplier_model import SupplierModel
except ImportError:
class SupplierModel(BasicModel):
pass
supplier = Fields.CategoryProperty(verbose_name=u'供應商', kind=SupplierModel)
@classmethod
def get_or_create(cls, user, supplier=None, supplier_key=None):
if supplier is not None and supplier_key is None:
supplier_key = supplier.key
cart = cls.query(cls.user == user.key,
cls.supplier == supplier_key).get()
if cart is None:
cart = cls()
cart.user = user.key
if supplier_key:
cart.supplier = supplier_key
cart.put()
return cart
def get_shopping_cart_item(self, product, spec, item_order_type):
from shopping_cart_item_model import ShoppingCartItemModel
return ShoppingCartItemModel.get_or_create(self, self.user, product,
spec, item_order_type)
@property
def items(self):
from shopping_cart_item_model import ShoppingCartItemModel
return ShoppingCartItemModel.query(
ShoppingCartItemModel.cart == self.key).fetch()
def clean(self):
if len(self.items) == 0:
self.key.delete()
def calc_size_weight_price_and_put(self, items=None):
if items is None:
items = self.items
total_volume = 0.0
total_size = 0.0
total_price = 0.0
total_weight = 0.0
total_volumetric_weight = 0.0
total_cost_for_items = 0.0
for cart_item in items:
total_size += cart_item.quantity * (
cart_item.size_1 + cart_item.size_2 + cart_item.size_3)
total_volume += cart_item.quantity * cart_item.size_1 * cart_item.size_2 * cart_item.size_3
total_price += cart_item.quantity * cart_item.price
total_weight += cart_item.quantity * cart_item.weight
total_volumetric_weight += cart_item.quantity * cart_item.volumetric_weight(
)
total_cost_for_items += cart_item.quantity * cart_item.cost
self.total_volume = total_volume
self.total_size = total_size
self.total_price = total_price
self.total_weight = total_weight
self.total_volumetric_weight = total_volumetric_weight
self.cost_for_items = total_cost_for_items
self.put()