def add_diary():
user = session.get('user_id')
if user != None:
data = {
'imgurl': request.files.get('img'),
'titel': request.values.get('title'),
'content': request.values.get('content'),
'house_style': request.values.get('style'),
'house_type': request.values.get('type'),
'usable_area': request.values.get('area'),
'house_money': request.values.get('spend')
}
d = Diary.query.order_by(db.desc(Diary.id)).first()
rj = Diary(id=d.id + 1)
db.session.add(rj)
p = Diary.query.order_by(db.desc(Diary.id)).first()
if data['titel']:
p.titel = data['titel']
if data['content']:
p.content = data['content']
if data['house_style']:
p.house_style = data['house_style']
if data['house_type']:
p.house_type = data['house_type']
if data['usable_area']:
p.usable_area = data['usable_area']
if data['house_money']:
p.house_money = data['house_money']
if data['imgurl']:
p.imgurl = icon1(data['imgurl'])
p.pid = user
db.session.add(p)
return jsonify({'ret': 'true', 'data': {'state': 1}}) # 修改成功
else:
return jsonify({'ret': 'true', 'data': {'state': 0}}) # 登录信息丢失
def index():
form = PostForm()
# 数据合法则保存
if form.validate_on_submit():
if not current_user.is_authenticated:
flash('登录才能发言哦')
return redirect(url_for('users.login'))
else:
user = current_user._get_current_object()
post = Posts(content=form.content.data, user=user)
db.session.add(post)
return redirect(url_for('main.index'))
# posts = Posts.query.filter_by(rid=0)
# 指定渲染页数 分页代码
page = request.args.get('page', 1, type=int)
pagination = Posts.query.filter_by(rid=0).order_by(db.desc(
Posts.timestamp)).paginate(page, per_page=6)
posts = pagination.items
# 最热 最新 博文
Topposts = Posts.query.order_by(db.desc(Posts.views))[:5]
Newposts = Posts.query.order_by(db.desc(Posts.timestamp))[:5]
return render_template('common/index.html',
form=form,
posts=posts,
Topposts=Topposts,
Newposts=Newposts,
pagination=pagination)
def topic():
ud = UnderDiscussion.query.order_by(db.desc(UnderDiscussion.id))[:3]
topic1 = Topics_one.query.order_by(db.desc(Topics_one.id))[:2]
discuss = []
topic2 = []
# 正在评论
for i in ud:
discuss.append({"id": i.id, "imgUrl": i.imgurl, "desc": i.title})
# 话题的标题和内容
for k in topic1:
imgurl = []
topic2.append({
"id":
k.id,
"title":
k.title,
"desc":
k.content,
"imgUrl":
imgurl,
"discusscount":
Topics_udcontent.query.filter_by(topics_one_id=k.id).count()
})
# 获取评论人的信息
u = Topics_udcontent.query.filter_by(topics_one_id=k.id).all()
for j in u:
x = Personal.query.filter_by(id=j.pid).first()
imgurl.append({'id': x.id, 'imgUrl': x.icon})
return jsonify({
'ret': 'true',
'data': {
'discuss': discuss,
'topic': topic2
}
})
def detail(postid):
form = CommentsForm()
if form.validate_on_submit():
if not current_user.is_authenticated:
flash('登录才能评论哦')
return redirect(url_for('users.login'))
else:
user = current_user._get_current_object()
post = Posts.query.get(postid)
comment = Comments(content=form.content.data, user=user, post=post)
db.session.add(comment)
return redirect(url_for('main.detail', postid=postid))
post = Posts.query.get(postid)
# 阅读数+1
post.views += 1
db.session.add(post)
# 最热 最新 博文
Topposts = Posts.query.order_by(db.desc(Posts.views))[:5]
Newposts = Posts.query.order_by(db.desc(Posts.timestamp))[:5]
# 博文的评论
comments = Comments.query.filter_by(post=post).order_by(
db.desc(Comments.timestamp))
return render_template('common/detail.html',
post=post,
Newposts=Newposts,
Topposts=Topposts,
form=form,
comments=comments)
def udcontent_comment(kw):
user = session.get('user_id')
if user != None:
d = Udcontent.query.order_by(db.desc(Udcontent.id)).first()
rj = Udcontent(id=d.id + 1)
db.session.add(rj)
p = Udcontent.query.order_by(db.desc(Udcontent.id)).first()
if kw:
p.content = request.json['content']
p.ud_id = kw
p.pid = user
db.session.add(p)
return jsonify({'ret': 'true', 'data': {'state': 1}}) # 评论成功
else:
return jsonify({'ret': 'true', 'data': {'state': 0}}) # 登录信息丢失
def send_ht():
user = session.get('user_id')
if user != None:
d = Topics_one.query.order_by(db.desc(Topics_one.id)).first()
rj = Topics_one(id=d.id + 1)
db.session.add(rj)
p = Topics_one.query.order_by(db.desc(Topics_one.id)).first()
if request.values.get('title'):
p.title = request.values.get('title')
if request.values.get('content'):
p.content = request.values.get('content')
db.session.add(p)
return jsonify({'ret': 'true', 'data': {'state': 1}}) # 发布成功
else:
return jsonify({'ret': 'true', 'data': {'state': 0}}) # 发布失败
def add_collects(kw):
user = session.get('user_id')
if user != None:
d = Collects.query.order_by(db.desc(Collects.id)).first()
rj = Collects(id=d.id + 1)
db.session.add(rj)
p = Collects.query.order_by(db.desc(Collects.id)).first()
if kw:
p.topics_id = kw
p.pid = user
t = Topics.query.filter_by(id=kw).first()
t.count = t.count + 1
db.session.add(t)
return jsonify({'ret': 'true', 'data': {'state': 1}}) # 收藏成功
else:
return jsonify({'ret': 'true', 'data': {'state': 0}}) # 登录信息丢失
def topic_discuss():
ud = UnderDiscussion.query.order_by(db.desc(UnderDiscussion.id))
discuss = []
# 正在评论
for i in ud:
discuss.append({"id": i.id, "imgUrl": i.imgurl, "desc": i.title})
return jsonify({'ret': 'true', 'data': discuss})
def problem():
user = session.get('user_id')
print(user)
if user != None:
list = Posts.query.order_by(db.desc(Posts.id))
question = []
response = []
for i in list:
# 回答该问题用户的数量
replyCount = Posts.query.filter_by(pid=i.id).count()
if i.rid != 0:
u = Personal.query.filter_by(id=i.p_id).first()
question.append({
"id": i.id,
"imgUrl": u.icon,
"username": u.nickname,
"question": i.title,
"replyCount": replyCount,
"browseCount": i.counts,
"response": response,
"time": i.create_time,
"style": i.type
})
else:
u1 = Personal.query.filter_by(id=i.p_id).first()
response.append({
"username": u1.nickname,
"headImg": u1.icon,
"content": i.content,
"id": u1.id
})
return jsonify({'ret': 'true', 'data': {'question': question}})
else:
return 'Have no right to access', 404
def myposts():
user = current_user._get_current_object()
# posts = Posts.query.filter_by(user=user)
# posts = user.posts.all()
page = request.args.get('page', 1, type=int)
pagination = Posts.query.filter_by(user=user).order_by(
db.desc(Posts.timestamp)).paginate(page, per_page=6)
posts = pagination.items
return render_template('users/myposts.html',
posts=posts,
pagination=pagination)
def topic_comment(kw):
user = session.get('user_id')
if user != None:
d = Topics_udcontent.query.order_by(db.desc(
Topics_udcontent.id)).first()
rj = Topics_udcontent(id=d.id + 1)
db.session.add(rj)
p = Topics_udcontent.query.order_by(db.desc(
Topics_udcontent.id)).first()
if kw:
p.content = request.json['content']
if request.values.get('imgurl1'):
p.imgurl1 = icon1(request.values.get('imgurl1'))
if request.values.get('imgurl2'):
p.imgurl2 = icon1(request.values.get('imgurl2'))
if request.values.get('imgurl1'):
p.imgurl3 = icon1(request.values.get('imgurl3'))
p.topics_one_id = kw
p.pid = user
db.session.add(p)
return jsonify({'ret': 'true', 'data': {'state': 1}}) # 评论成功
else:
return jsonify({'ret': 'true', 'data': {'state': 0}}) # 登录信息丢失
def information():
user = session.get('user_id')
data = []
if user != None:
info = Information.query.order_by(db.desc(Information.id)).all()
for i in info:
data.append({
'id': i.id,
'imgurl': i.imgurl,
'title': i.title,
'time': i.time
})
return jsonify({'ret': 'true', 'data': data})
return jsonify({'ret': 'true', 'data': '0'}) # 参数错误
def design():
list1 = Design.query.order_by(db.desc(Design.id))
desion1 = []
for i in list1:
u = Personal.query.filter_by(id=i.pid).first()
desion1.append({
"id": i.id,
"imgUrl": i.logo,
"logo": u.icon,
"title": i.title,
"company": i.company,
"address": i.address
})
return jsonify({'ret': 'true', 'data': {'findDesign': desion1}})
def decorate():
list1 = Topics.query.order_by(db.desc(Topics.id)).all()
decorate1 = []
for i in list1:
u = Personal.query.filter_by(id=i.pid).first()
decorate1.append({
"id": i.id,
"headImg": u.icon,
"imgUrl": i.top_img,
"desc": i.top_title,
"username": u.nickname,
"house_type": i.house_type,
"usable_area": i.usable_area
})
return jsonify({'ret': 'true', 'data': {'decorate': decorate1}})
def topic_list():
topic1 = Topics_one.query.order_by(db.desc(Topics_one.id))
topic2 = []
for i in topic1:
imgurl = []
topic2.append({
"id":
i.id,
"title":
i.title,
"desc":
i.content,
"imgUrl":
imgurl,
"discusscount":
Topics_udcontent.query.filter_by(topics_one_id=i.id).count()
})
# 获取评论人的信息
u = Topics_udcontent.query.filter_by(topics_one_id=i.id).all()
for j in u:
x = Personal.query.filter_by(id=j.pid).first()
imgurl.append({'id': x.id, 'imgUrl': x.icon})
return jsonify({'ret': 'true', 'data': topic2})
def static(kw):
data = []
dic = {
'recommend': 'recommend',
'sample': '简约',
'chinese': '中式',
'europ': '欧式',
'america': '美式',
'vield': '田园',
'mix': '混搭',
}
if kw != 'recommend':
sid = Styles.query.filter_by(type=dic[kw]).all()
for i in sid:
lists = Personal.query.filter_by(id=i.pid).first()
data.append({
"id": i.id,
"imgUrl": i.imgUrl,
"describe": i.describe,
"headImg": lists.icon,
"username": lists.nickname,
"pid": lists.id
})
return jsonify({'ret': 'true', 'data': data})
else:
sid1 = Styles.query.order_by(db.desc(Styles.id)).all()
for i in sid1:
lists = Personal.query.filter_by(id=i.pid).first()
data.append({
"id": i.id,
"imgUrl": i.imgUrl,
"describe": i.describe,
"headImg": lists.icon,
"username": lists.nickname,
"pid": lists.id
})
return jsonify({'ret': 'true', 'data': data})
def about():
Topposts = Posts.query.order_by(db.desc(Posts.views))[:5]
Newposts = Posts.query.order_by(db.desc(Posts.timestamp))[:5]
return render_template('common/about.html',
Newposts=Newposts,
Topposts=Topposts)