class OtherImg(models.Model):
'''其他图片'''
feedback_classfiy = QiniuField(max_length=5000, blank=True, null=True, verbose_name='服务号')
buy_house_qun = QiniuField(max_length=5000, blank=True, null=True, verbose_name='买房群')
feedback_img = QiniuField(max_length=5000, blank=True, null=True, verbose_name='公众号')
class Meta:
db_table = 'tb_question_other_img'
verbose_name = '其他图片'
verbose_name_plural = verbose_name
managed = True
def __str__(self):
return '%s %s %s %s ' % (self.feedback_classfiy, self.buy_house_qun, self.feedback_img, self.id)
def image_data1(self):
return format_html('<img src="{}" width="100px"/>', self.feedback_classfiy)
image_data1.short_description = u'服务号'
def image_data2(self):
return format_html('<img src="{}" width="100px"/>', self.buy_house_qun)
image_data2.short_description = u'买房群'
def image_data3(self):
return format_html('<img src="{}" width="100px"/>', self.feedback_img)
image_data3.short_description = u'公众号'
class Article(models.Model):
'''文章'''
ARTICLE_CHOICES = ((0, '买房干货'), (1, '楼市解读'), (2, '楼市百科'), (3, '房产投资'))
choice_classfiy = models.SmallIntegerField(choices=ARTICLE_CHOICES, default=0, verbose_name='文章分类')
author = models.CharField(max_length=50, blank=True, null=True, verbose_name='作者')
author_img = QiniuField(max_length=500, blank=True, null=True, verbose_name='作者头像')
create_time = models.DateField(auto_now_add=True, blank=True, null=True, verbose_name='创建时间')
title = models.CharField(max_length=50, blank=True, null=True, verbose_name='标题')
content = RichTextUploadingField(blank=True, null=True, verbose_name='内容')
land = models.TextField(blank=True, null=True, verbose_name='地区')
new_img = QiniuField(max_length=500, blank=True, null=True, verbose_name='图片')
read = models.IntegerField(default=0, blank=True, null=True, verbose_name='阅读量')
zanc = models.IntegerField(default=0, blank=True, null=True, verbose_name='点赞量')
class Meta:
db_table = 'tb_article'
verbose_name = '文章'
verbose_name_plural = verbose_name
managed = True
def __str__(self):
return '%s %s %s %s %s %s %s' % (self.choice_classfiy, self.author, self.create_time, self.title, self.id, self.content, self.new_img)
def image_data1(self):
return format_html('<img src="{}" width="100px"/>', self.author_img)
image_data1.short_description = u'头像'
def image_data2(self):
return format_html('<img src="{}" width="100px"/>', self.new_img)
image_data2.short_description = u'图片'
class Answer(models.Model):
'''答'''
question = models.ForeignKey(Question, on_delete=models.CASCADE, null=True, blank=True, verbose_name='问题')
com = models.CharField(max_length=255, null=True, blank=True, verbose_name='评论id')
create_time = models.DateTimeField(auto_now=True, verbose_name='创建时间')
content = RichTextUploadingField(blank=True, null=True, verbose_name='内容')
aut = models.TextField(blank=True, null=True, verbose_name='作者')
aut_id = models.TextField(blank=True, null=True, verbose_name='作者id')
head_img = QiniuField(max_length=255, blank=True, null=True, verbose_name='头像')
click_count = models.IntegerField(default=0, verbose_name='点赞数')
catgrage_id = models.CharField(max_length=255, blank=True, null=True, verbose_name='点评所属id') # 默认没有
class Meta:
db_table = 'tb_answer'
verbose_name = '答'
verbose_name_plural = verbose_name
managed = True
def __str__(self):
return '%s %s %s %s %s %s' % (self.question_id, self.aut, self.create_time, self.click_count, self.id, self.click_count)
def b_name(self):
return self.question.title
b_name.short_description = '问题'
def image_data(self):
return format_html('<img src="{}" width="100px"/>', self.head_img)
image_data.short_description = u'头像'
class BuildingVideo(models.Model):
'''视频'''
fk = models.ForeignKey(BuildingDetial, on_delete=models.CASCADE, verbose_name='楼盘详情')
HOUSE_CHOICES = ((0, '其他'), (1, '项目官方宣传'), (2, '项目周边讲解'), (3, '沙盘讲解'), (4, '样板间拍摄'))
choice_classfiy = models.SmallIntegerField(choices=HOUSE_CHOICES, default=0, verbose_name='户型分类')
video = QiniuField(max_length=5000, null=True, blank=True, verbose_name='视频')
create_time = models.DateField(auto_now_add=True, verbose_name='创建时间')
class Meta:
db_table = 'tb_building_video'
verbose_name = '视频'
verbose_name_plural = verbose_name
managed = True
def __str__(self):
return '%s %s %s %s %s ' % (self.fk_id, self.choice_classfiy, self.id, self.video, self.create_time)
def b_name(self):
return self.fk.building_name
b_name.short_description = '类别'
def image_data(self):
return format_html('<img src="{}" width="100px"/>', self.video)
image_data.short_description = u'图片'
class BuildingOneHouseOnePriceImage(models.Model):
'''生成的一房一价图片'''
fk = models.ForeignKey(BuildingDetial, on_delete=models.CASCADE, verbose_name='楼盘详情')
photo_image = QiniuField(max_length=5000, blank=True, null=True, verbose_name='图片')
create_time = models.DateField(auto_now=True,blank=True, null=True, verbose_name='创建时间')
class Meta:
db_table = 'tb_building_one_house_one_price_image'
verbose_name = '生成的一房一价图片'
verbose_name_plural = verbose_name
managed = True
def __str__(self):
return '%s %s %s %s' % (self.fk_id, self.id, self.photo_image, self.create_time)
def b_name(self):
return self.fk.building_name
b_name.short_description = '类别'
def image_data(self):
return format_html(
'<img src="{}" width="100px"/>',
self.photo_image,
)
image_data.short_description = u'楼盘图片'
class BuildingImage(models.Model):
'''楼盘相册'''
fk = models.ForeignKey(BuildingDetial, on_delete=models.CASCADE, verbose_name='楼盘详情')
HOUSE_CHOICES = ((0, '全部'), (1, '实景图'), (2, '项目周边'), (3, '样板间'), (4, '效果图'), (5, '鸟瞰图'))
choice_classfiy = models.SmallIntegerField(choices=HOUSE_CHOICES, default=0, verbose_name='户型分类')
photo_image = QiniuField(max_length=5000, blank=True, null=True, verbose_name='图片')
create_time = models.DateField(auto_now=True,blank=True, null=True, verbose_name='创建时间')
class Meta:
db_table = 'tb_building_image'
verbose_name = '楼盘图片'
verbose_name_plural = verbose_name
managed = True
def __str__(self):
return '%s %s %s %s %s ' % (self.fk_id, self.choice_classfiy, self.id, self.photo_image, self.create_time)
def b_name(self):
return self.fk.building_name
b_name.short_description = '类别'
def image_data(self):
return format_html(
'<img src="{}" width="100px"/>',
self.photo_image,
)
image_data.short_description = u'楼盘图片'
class BuyHouseHundredDepartment(models.Model):
'''购房百科'''
classfiy = models.ForeignKey(BuyHouseHundredDepartmentClassfiy, on_delete=models.CASCADE, verbose_name='购房百科分类')
title = models.CharField(max_length=255, blank=True, null=True, verbose_name='标题')
two_title = models.CharField(max_length=255, blank=True, null=True, verbose_name='二级标题')
text_img = QiniuField(max_length=500, blank=True, null=True, verbose_name='资料图片')
text = RichTextUploadingField(blank=True, null=True, verbose_name='内容')
create_time = models.DateTimeField(auto_now=True, verbose_name='问题创建时间')
click_zan = models.IntegerField(default=0, verbose_name='点赞量')
class Meta:
db_table = 'tb_buy_house_hundred_department'
verbose_name = '购房百科'
verbose_name_plural = verbose_name
managed = True
def __str__(self):
return '%s %s %s %s %s %s %s %s' % (self.id, self.title, self.two_title, self.text_img, self.text, self.create_time, self.classfiy_id, self.click_zan)
def b_name(self):
return self.classfiy.name
b_name.short_description = '类别'
def image_data(self):
return format_html(
'<img src="{}" width="100px"/>',
self.text_img,
)
image_data.short_description = u'资料图片'
class PublicPlan(models.Model):
'''公示方案'''
fk = models.ForeignKey(BuildingDetial, on_delete=models.CASCADE, verbose_name='楼盘详情')
autor = models.CharField(max_length=55, null=True, blank=True, verbose_name='作者')
title = models.CharField(max_length=55, null=True, blank=True, verbose_name='标题')
img = QiniuField(max_length=5000, null=True, blank=True, verbose_name='资料图片')
two_title = models.CharField(max_length=55, null=True, blank=True, verbose_name='二级标题')
content = RichTextUploadingField(null=True, blank=True, verbose_name='内容')
create_time = models.DateTimeField(auto_now=True, verbose_name='创建时间')
class Meta:
db_table = 'tb_public_plan'
verbose_name = '楼盘选择类型'
verbose_name_plural = verbose_name
managed = True
def __str__(self):
return '%s %s %s %s %s %s %s' % (self.fk_id, self.title, self.img, self.id, self.two_title, self.content, self.autor)
def b_name(self):
return self.fk.building_name
b_name.short_description = '楼盘名称'
def image_data(self):
return format_html('<img src="{}" width="100px"/>',self.img)
image_data.short_description = u'楼盘图片'
class IssueBuildingDynamicMessage(models.Model):
'''(发表)楼盘动态信息(房小团官宣)'''
building_detial = models.ForeignKey(BuildingDetial, on_delete=models.PROTECT,null=True, blank=True, verbose_name='楼盘')
title = models.CharField(max_length=255,null=True, blank=True, verbose_name='标题')
content = RichTextUploadingField(blank=True, null=True, verbose_name='内容')
message_create_time = models.DateField(auto_now_add=True, null=True, blank=True, verbose_name='创建时间')
author = models.CharField(max_length=50,null=True, blank=True, verbose_name='作者')
author_id = models.CharField(max_length=50, null=True, blank=True, verbose_name='作者id')
RESIDENCE_CHOICES = ((0, '无'), (1, '楼盘动态'), (2, '预售证'), (3, '开盘'), (4, '交房'))
choice_classfiy = models.SmallIntegerField(choices=RESIDENCE_CHOICES, default=0, verbose_name='类型')
img = QiniuField(max_length=5000, blank=True, null=True, verbose_name='图片')
class Meta:
db_table = 'tb_issue_building_dynamic_message'
verbose_name = '楼盘动态信息'
managed = True
verbose_name_plural = verbose_name
def __str__(self):
return '%s %s %s %s %s %s %s %s' % (self.building_detial_id, self.author_id, self.title, self.content, self.message_create_time, self.author, self.id, self.img)
def b_name(self):
return self.building_detial.building_name
def image_data(self):
return format_html('<img src="{}" width="100px"/>',self.img)
b_name.short_description = '楼盘名称'
image_data.short_description = u'楼盘图片'
class LandAuction(models.Model):
'''土拍'''
classfiy_name = models.ForeignKey(LandDistrict, on_delete=models.CASCADE, null=True, blank=True, verbose_name='地区分类')
RESIDENCE_CHOICES = ((1, '住宅'), (2, '商业'))
if_residence = models.SmallIntegerField(choices=RESIDENCE_CHOICES, default=0, verbose_name='是否住宅')
SALE_CHOICES = ((0, '已出让'), (1, '未出让'))
if_sale = models.SmallIntegerField(choices=SALE_CHOICES, default=0, verbose_name='是否出让')
land_name = models.CharField(max_length=200, blank=True, null=True, verbose_name='地块名称')
map = QiniuField(max_length=500, blank=True, null=True, verbose_name='地图')
land_region = models.CharField(max_length=250, blank=True, null=True, verbose_name='地块区域')
land_position = models.CharField(max_length=250, blank=True, null=True, verbose_name='宗地位置')
nuddle_price = models.CharField(max_length=250, blank=True, null=True, verbose_name='楼面价')
acquisition_company = models.CharField(max_length=200, blank=True, null=True, verbose_name='竞得方')
start_parice = models.CharField(max_length=200, blank=True, null=True, verbose_name='起拍价')
end_parice = models.CharField(max_length=200, blank=True, null=True, verbose_name='成交价')
give_area = models.CharField(max_length=200, blank=True, null=True, verbose_name='出让面积')
deal_all_price = models.CharField(max_length=200, blank=True, null=True, verbose_name='成交总价')
max_volume_rate = models.CharField(max_length=200, blank=True, null=True, verbose_name='最大容积率')
overflow = models.CharField(max_length=200, blank=True, null=True, verbose_name='溢价率')
land_use = models.CharField(max_length=200, blank=True, null=True, verbose_name='土地用途')
give_year = models.CharField(max_length=200, blank=True, null=True, verbose_name='出让年限')
land_ask_for = models.CharField(max_length=50, blank=True, null=True, verbose_name='宗地要求')
land_number = models.CharField(max_length=100, blank=True, null=True, verbose_name='宗地编号')
for_remark = models.CharField(max_length=50, blank=True, null=True, verbose_name='挂牌备注')
long = models.FloatField(default=0,blank=True, null=True, verbose_name='经度')
late = models.FloatField(default=0,blank=True, null=True, verbose_name='纬度')
deal_date = models.CharField(max_length=100, blank=True, null=True, verbose_name='成交日期')
land_img = QiniuField(max_length=500, blank=True, null=True, verbose_name='地块图片')
create_time = models.DateField(auto_now_add=True, null=True, blank=True, verbose_name='创建时间')
class Meta:
db_table = 'tb_land_auction'
verbose_name = '土拍'
verbose_name_plural = verbose_name
managed = True
def __str__(self):
return '%s %s %s %s %s %s %s %s %s %s %s %s %s %s %s %s %s %s %s' % (self.id, self.classfiy_name_id, self.land_name, self.map, self.land_region, self.land_position, self.nuddle_price, self.acquisition_company, self.start_parice, self.end_parice, self.give_area, self.deal_all_price, self.max_volume_rate, self.overflow, self.land_use, self.give_year, self.land_ask_for, self.land_number, self.deal_date)
def b_name(self):
return self.classfiy_name.name
def image_data(self):
return format_html('<img src="{}" width="100px"/>',self.land_img)
b_name.short_description = '分类'
image_data.short_description = u'楼盘图片'
class Share(models.Model): # 搜索时以楼盘类别和我的关注作为筛选条件, 最新和最热分享
'''分享堂'''
middle_fk = models.ForeignKey('authorization.MiddlePeople', on_delete=models.CASCADE, verbose_name='置业顾问id')
bd_id = models.CharField(max_length=255, blank=True, null=True, verbose_name='顾问主营楼盘id')
building_name = models.CharField(max_length=255, blank=True, null=True, verbose_name='楼盘名称')
mobile = models.CharField(max_length=255, blank=True, null=True, verbose_name='手机号')
author = models.CharField(max_length=25, blank=True, null=True, verbose_name='作者')
create_time = models.DateTimeField(auto_now=True, verbose_name='创建时间')
content = RichTextUploadingField(max_length=255, blank=True, null=True, verbose_name='内容')
browse_count = models.IntegerField(default=0, blank=True, null=True, verbose_name='浏览量')
img = QiniuField(max_length=500, blank=True, null=True, verbose_name='图片')
video = QiniuField(max_length=500, blank=True, null=True, verbose_name='视频')
HOUSE_CHOICES = ((0, '公寓'), (1, '住宅'))
choice_classfiy = models.SmallIntegerField(choices=HOUSE_CHOICES, default=0, verbose_name='住宅类型分类')
head_img = QiniuField(max_length=500, blank=True, null=True,verbose_name='头像')
class Meta:
db_table = 'tb_share'
verbose_name = '分享堂'
verbose_name_plural = verbose_name
managed = True
def __str__(self):
return '%s %s %s %s %s %s %s %s' % (self.bd_id, self.middle_fk_id, self.id, self.create_time, self.content, self.img, self.video, self.author)
def m_name(self):
return self.middle_fk.nick_name
m_name.short_description = '顾问名称'
# def b_name(self):
# return self.building_fk.building_name
# b_name.short_description = '所属楼盘'
def image_data1(self):
return format_html('<img src="{}" width="100px"/>', self.img)
image_data1.short_description = u'图片'
def image_data2(self):
return format_html('<img src="{}" width="100px"/>', self.video)
image_data2.short_description = u'视频'
def image_data3(self):
return format_html('<img src="{}" width="100px"/>', self.head_img)
image_data3.short_description = u'头像'
class Question(models.Model):
'''问'''
name = models.ForeignKey('authorization.Users', on_delete=models.CASCADE,blank=True, null=True, verbose_name='作者')
author = models.CharField(max_length=30, blank=True, null=True, verbose_name='作者')
author_id = models.CharField(max_length=30, blank=True, null=True, verbose_name='作者ID')
create_time = models.DateTimeField(auto_now=True, verbose_name='创建时间')
title = models.CharField(max_length=30, blank=True, null=True, verbose_name='标题')
q_type = models.CharField(max_length=15, blank=True, null=True, verbose_name='类型')
content = RichTextUploadingField(blank=True, null=True, verbose_name='内容')
browse_count = models.IntegerField(default=0, verbose_name='浏览量')
answer_count = models.IntegerField(default=0, verbose_name='回答量')
head_img = QiniuField(max_length=255, blank=True, null=True, verbose_name='头像')
QUESTION_CHOICES = ((0, '无'), (1, '已回答'), (2, '已解决'), (3, '未回答'))
choice_classfiy = models.SmallIntegerField(choices=QUESTION_CHOICES, default=0, verbose_name='解决状态')
STATUS_CHOICES = ((0, '无'), (1, '落户'), (2, '社保'), (3, '刚需'), (4, '限购'))
buy_house_status = models.SmallIntegerField(choices=STATUS_CHOICES, default=0, verbose_name='购房资格')
TOU_CHOICES = ((0, '无'), (1, '城市规划'), (2, '楼盘对比'), (3, '房价预测'))
tou_choice = models.SmallIntegerField(choices=TOU_CHOICES, default=0, verbose_name='投资指南')
BUY_SALE_CHOICES = ((0, '无'), (1, '交易过户'), (2, '公积金'), (3, '贷款'))
buy_sale_choice = models.SmallIntegerField(choices=BUY_SALE_CHOICES, default=0, verbose_name='买房卖房')
DECORATION_CHOICES = ((0, '无'), (1, '精装'), (2, '毛胚'))
decoration_choice = models.SmallIntegerField(choices=DECORATION_CHOICES, default=0, verbose_name='装修')
class Meta:
db_table = 'tb_question'
verbose_name = '问'
verbose_name_plural = verbose_name
managed = True
def __str__(self):
return '%s %s %s %s %s %s %s %s %s %s %s' % (self.id, self.author, self.create_time, self.title, self.browse_count, self.answer_count, self.choice_classfiy, self.buy_house_status, self.tou_choice, self.buy_sale_choice, self.decoration_choice )
def image_data(self):
return format_html('<img src="{}" width="100px"/>', self.head_img)
image_data.short_description = u'头像'
class Comment(models.Model):
'''评论'''
catgrage_id = models.CharField(max_length=255, blank=True, null=True, verbose_name='所属id')
create_time = models.DateField(auto_now_add=True, blank=True, null=True, verbose_name='创建时间')
click_count = models.IntegerField(default=0, verbose_name='点赞数')
author_name = models.CharField(max_length=20, blank=True, null=True, verbose_name='作者名称')
author_id = models.CharField(max_length=20, blank=True, null=True, verbose_name='作者id')
village_id = models.CharField(max_length=20, blank=True, null=True, verbose_name='楼盘id')
title = models.CharField(max_length=20, blank=True, null=True, verbose_name='标题')
content = RichTextUploadingField(max_length=255, blank=True, null=True, verbose_name='内容')
head_img = QiniuField(max_length=255, blank=True, null=True, verbose_name='头像')
class Meta:
db_table = 'tb_comment'
verbose_name = '评论'
verbose_name_plural = verbose_name
managed = True
def __str__(self):
return '%s %s %s %s %s %s %s %s' % (self.id, self.catgrage_id, self.author_name, self.village_id, self.create_time, self.click_count, self.content, self.title)
def image_data(self):
return format_html('<img src="{}" width="100px"/>', self.head_img)
image_data.short_description = u'头像'
class QuestionEveryProblem(models.Model):
'''7组件(购房资料问题表)/摇号常见问题/公积金问题/征信打印指南/资料模板下载/资格查询/摇号流程/'''
CHOICES_CLASSFIY = ((0, '摇号常见问题'), (1, '公积金问题'), (2, '征信打印指南'), (3, '资料模板下载'), (4, '资格查询'), (5, '摇号流程'))
choice = models.SmallIntegerField(choices=CHOICES_CLASSFIY, default=0, verbose_name='分类')
create_time = models.DateField(auto_now_add=True, blank=True, null=True, verbose_name='创建时间')
title = models.CharField(max_length=255, blank=True, null=True, verbose_name='标题')
content = RichTextUploadingField(blank=True, null=True, verbose_name='内容')
img = QiniuField(max_length=5000, blank=True, null=True, verbose_name='图片')
class Meta:
db_table = 'tb_question_every_problem'
verbose_name = '7组件'
verbose_name_plural = verbose_name
managed = True
def __str__(self):
return '%s %s %s %s %s %s' % (self.choice, self.create_time, self.title, self.id, self.content, self.img)
def image_data(self):
return format_html(
'<img src="{}" width="100px"/>',
self.img,
)
image_data.short_description = u'资料图片'