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)