class PriceCut(models.Model):
"""
满减
"""
owner = models.ForeignKey(User)
price_threshold = models.FloatField(default=0) #价格阈值
cut_money = models.FloatField(default=0) #减价
is_enable_cycle_mode = models.BooleanField(default=False) #是否启用循环满减
class Meta(object):
db_table = 'mallpromotion_price_cut'
verbose_name = '满减'
verbose_name_plural = '满减'
class Member(models.Model):
"""
会员
"""
token = models.CharField(max_length=255)
webapp_id = models.CharField(max_length=16)
username_hexstr = models.CharField(max_length=2048,
verbose_name='会员名称的hex str')
user_icon = models.CharField(max_length=1024,
verbose_name='会员头像',
default='')
integral = models.IntegerField(default=0, verbose_name='积分')
created_at = models.DateTimeField(auto_now_add=True)
grade = models.ForeignKey(MemberGrade)
experience = models.IntegerField(default=0, verbose_name='经验值')
remarks_name = models.CharField(max_length=32,
verbose_name='备注名',
default='')
remarks_extra = models.TextField(verbose_name='备注信息', default='')
last_visit_time = models.DateTimeField(auto_now_add=True)
last_message_id = models.IntegerField(default=-1, verbose_name="最近一条消息id")
session_id = models.IntegerField(default=-1, verbose_name="会话id")
is_for_test = models.BooleanField(default=False)
is_subscribed = models.BooleanField(default=True)
friend_count = models.IntegerField(default=0) #好友数量
factor = models.FloatField(default=0.00) #社会因子
source = models.IntegerField(default=-1) #会员来源
is_for_buy_test = models.BooleanField(default=False)
update_time = models.DateTimeField(
default=datetime.now()) #会员信息更新时间 2014-11-11
pay_money = models.FloatField(default=0.0)
pay_times = models.IntegerField(default=0)
last_pay_time = models.DateTimeField(default=None) #会员信息更新时间 2014-11-11
unit_price = models.FloatField(default=0.0) #ke dan jia
city = models.CharField(default='', max_length=50)
province = models.CharField(default='', max_length=50)
country = models.CharField(default='', max_length=50)
sex = models.IntegerField(default=0, verbose_name='性别')
status = models.IntegerField(default=1)
purchase_frequency = models.IntegerField(default=0) # 30天购买次数
cancel_subscribe_time = models.DateTimeField(blank=True,
null=True,
default=None,
verbose_name="取消关注时间")
fans_count = models.IntegerField(default=0) #粉丝数量
class Meta(object):
db_table = 'member_member'
def __unicode__(self):
return u'<member: %s %s>' % (self.webapp_id, self.token)
class IntegralSaleRule(models.Model):
"""
积分应用规则
"""
owner = models.ForeignKey(User)
integral_sale = models.ForeignKey(IntegralSale)
member_grade_id = models.IntegerField(default=0) #会员等级
discount = models.FloatField(default=0) #折扣上限
discount_money = models.FloatField(default=0.0) #折扣金额
class Meta(object):
db_table = 'mallpromotion_integral_sale_rule'
verbose_name = '积分应用规则'
verbose_name_plural = '积分应用规则'
class IntegralSale(models.Model):
"""
积分应用
"""
owner = models.ForeignKey(User)
type = models.IntegerField(default=INTEGRAL_SALE_TYPE_PARTIAL) #积分抵扣类型
discount = models.IntegerField(default=0) #折扣上限
discount_money = models.FloatField(default=0.0) #折扣金额
integral_price = models.FloatField(default=0.0) #积分价
is_permanant_active = models.BooleanField(default=False) #是否永久有效
class Meta(object):
db_table = 'mallpromotion_integral_sale'
verbose_name = '积分应用'
verbose_name_plural = '积分应用'
class JinGeCardLog(models.Model):
"""
锦歌饭卡交易记录
"""
jinge_card = models.ForeignKey(JinGeCard) #jinge card id
price = models.FloatField(default=0.0) # 浮动金额
trade_id = models.CharField(max_length=50, default='') #支付流水号
order_id = models.CharField(max_length=32, default='') #订单号
reason = models.CharField(max_length=128) # 原因
balance = models.FloatField(default=0.0) # 余额
created_at = models.DateTimeField(auto_now_add=True) #时间
class Meta(object):
db_table = 'third_party_jinge_card_log'
verbose_name = '锦歌公司饭卡交易记录'
verbose_name_plural = '锦歌公司饭卡交易记录'
class FlashSale(models.Model):
"""
限时抢购
"""
owner = models.ForeignKey(User)
limit_period = models.IntegerField(default=0) #限购周期
promotion_price = models.FloatField(default=0.0) #限购价格
count_per_purchase = models.IntegerField(default=1) #单人限购数量每次
count_per_period = models.IntegerField(default=0)
class Meta(object):
db_table = 'mallpromotion_flash_sale'
verbose_name = '限时抢购'
verbose_name_plural = '限时抢购'
class TengyiRebateLog(models.Model):
"""
腾易微众星级会员返利记录表
"""
member_id = models.IntegerField(default=0)
is_self_order = models.BooleanField(default=False) #是否自己的订单返利
supply_member_id = models.IntegerField(default=0) #返利会员id
is_exchanged = models.BooleanField(default=False) #是否已返利
exchanged_at = models.DateTimeField(default=datetime.strptime(
'2000-01-01', '%Y-%m-%d')) #返利时间
rebate_money = models.FloatField(default=0) #返利金额
created_at = models.DateTimeField(auto_now_add=True)
class Meta(object):
db_table = 'tengyi_rebate_log'
class MemberSharedUrlInfo(models.Model):
member = models.ForeignKey(Member)
shared_url = models.CharField(max_length=1024)
shared_url_digest = models.CharField(max_length=32)
pv = models.IntegerField(default=1)
leadto_buy_count = models.IntegerField(default=0)
title = models.CharField(max_length=256, default='')
cr = models.FloatField(default=0.0)
followers = models.IntegerField(default=0)
created_at = models.DateTimeField(auto_now_add=True)
class Meta(object):
db_table = 'member_shared_url_info'
verbose_name = '分享链接信息'
verbose_name_plural = '分享链接信息'
class MemberCardLog(models.Model):
"""
会员卡记录，仅交易记录 下单 和 取消订单
"""
member_card = models.ForeignKey(MemberCard) # member card id
price = models.FloatField(default=0.0) # 浮动金额
trade_id = models.CharField(max_length=50,
default="") # 支付流水号alter table member_card_log add column trade_id varchar(50) default '';
order_id = models.CharField(max_length=200,
default="") # 订单号 alter table member_card_log add column order_id varchar(200) default '';
reason = models.CharField(max_length=512) # 原因
created_at = models.DateTimeField(auto_now_add=True) # 时间
class Meta(object):
db_table = 'member_card_log'
class MemberCardPayOrder(models.Model):
"""
会员卡支付订单 duhao
"""
owner_id = models.IntegerField() #商家id
member_id = models.IntegerField() #会员id
batch_id = models.CharField(max_length=50, default="") #微众卡批次id
order_id = models.CharField(max_length=50) #支付订单id
batch_name = models.CharField(max_length=200) #会员卡名称
price = models.FloatField(default=0.0) #支付金额
is_paid = models.BooleanField(default=False) #是否支付成功
created_at = models.DateTimeField(auto_now_add=True) #创建时间
paid_at = models.DateTimeField(null=True) #支付时间
class Meta(object):
db_table = 'member_card_pay_order'
class TengyiMemberRebateCycle(models.Model):
"""
腾易微众星级会员推荐返利周期
"""
member_id = models.IntegerField(default=0)
start_time = models.DateTimeField()
end_time = models.DateTimeField()
is_receive_reward = models.BooleanField(default=False) #是否已获得购物返利
receive_reward_at = models.DateTimeField(
default=DEFAULT_DATETIME) #获得推荐返利时间
is_recommend_member_receive_reward = models.BooleanField(
default=False) #是否被推荐人已获得推荐返利
recommend_member_rebate_money = models.FloatField(default=0) #推荐人返利金额
created_at = models.DateTimeField(auto_now_add=True)
class Meta(object):
db_table = 'tengyi_member_rebate_cycle'
class RedEnvelopeParticipences(models.Model):
"""
红包领用记录
"""
owner = models.ForeignKey(User)
coupon = models.ForeignKey(Coupon)
red_envelope_rule_id = models.IntegerField(default=0)
red_envelope_relation_id = models.IntegerField(default=0)
member = models.ForeignKey(Member)
is_new = models.BooleanField(default=False)
introduced_by = models.IntegerField(default=0) #由谁引入
introduce_new_member = models.IntegerField(default=0) #引入新关注
introduce_used_number = models.IntegerField(default=0) #引入使用人数
introduce_received_number = models.IntegerField(default=0) #引入领取人数
introduce_sales_number = models.FloatField(default=0.0) #引入消费额
created_at = models.DateTimeField(auto_now_add=True)
class Meta(object):
db_table = 'mall_red_envelope_participences'
class Coupon(models.Model):
"""
优惠券
"""
owner = models.ForeignKey(User)
coupon_rule = models.ForeignKey(CouponRule) #coupon rule
member_id = models.IntegerField(default=0) #优惠券分配的member的id
coupon_record_id = models.IntegerField(default=0) #优惠券记录的id
status = models.IntegerField(default=COUPON_STATUS_UNUSED) #优惠券状态
coupon_id = models.CharField(max_length=50) #优惠券号
provided_time = models.DateTimeField(default=DEFAULT_DATETIME) #领取时间
start_time = models.DateTimeField() #优惠券有效期开始时间
expired_time = models.DateTimeField() #过期时间
money = models.FloatField() #金额
is_manual_generated = models.BooleanField(default=False) #是否手工生成
created_at = models.DateTimeField(auto_now_add=True) #添加时间
class Meta(object):
db_table = 'market_tool_coupon'
class MemberGrade(models.Model):
"""
会员等级
"""
webapp_id = models.CharField(max_length=16, verbose_name='所关联的app id')
name = models.TextField()
is_auto_upgrade = models.BooleanField(default=False, verbose_name='是否凭经验值自动升级')
upgrade_lower_bound = models.IntegerField(default=0, verbose_name='该等级的经验值下限')
shop_discount = models.IntegerField(default=100, verbose_name='购物折扣')
is_default_grade = models.BooleanField(default=False)
usable_integral_percentage_in_order = models.IntegerField(verbose_name='一笔交易中能使用的多少积分', default=100) # -1 无限制
pay_money = models.FloatField(default=0.00)
pay_times = models.IntegerField(default=0)
integral = models.IntegerField(default=0)
created_at = models.DateTimeField(auto_now_add=True)
class Meta(object):
db_table = 'member_grade'
def __unicode__(self):
return u"{}-{}".format(self.webapp_id, self.name)