def commentary_edit(table, no): if request.method == 'POST': commentary_db = db.Commentary() user_db = db.User() if not user_db.is_author(table, no, current_user): return redirect("/" + table + "/view/" + str(no)) commentary_title = request.form['commentary_title'] commentary_text = request.form['commentary_text'] commentary_vcode = request.form['commentary_vcode'] commentary_copen = int(request.form['copen']) commentary_db.edit_commentary(table, no, commentary_title, commentary_text, commentary_vcode, commentary_copen) return redirect("/" + table + "/view/" + str(no)) else: commentary_db = db.Commentary() user_db = db.User() if not user_db.is_author(table, no, current_user): return redirect("/" + table + "/view/" + str(no)) cview = commentary_db.cview(table, no) return render_template('commentary_add.html', cview=cview, table=table)
def commentary_add(table, vcode=1): if request.method == 'POST': commentary_title = request.form['commentary_title'] commentary_text = request.form['commentary_text'] commentary_vcode = request.form['commentary_vcode'] commentary_copen = int(request.form['copen']) commentary_author = current_user.name commentary_email = current_user.user_id return_vcode_page = request.form['return_vcode_page'] return_category_page = request.form['return_category_page'] commentary_db = db.Commentary() commentary_db.add_commentary(table, commentary_title, commentary_text, commentary_author, commentary_vcode, commentary_email, commentary_copen) if return_vcode_page: return redirect("/commentary/vcode/" + str(return_vcode_page)) elif return_category_page == 'mylist': return redirect("/commentary/mylist/") else: return redirect("/" + table + "/list/") elif request.method == 'GET': category = request.args.get('c') return render_template('commentary_add.html', vcode=vcode, table=table, category=category) else: return render_template('commentary_add.html', vcode=vcode, table=table)
def commentary_view(table, no, title=''): if request.method == 'GET': mode = request.args.get('mode') pagenum = request.args.get('p') vcode = request.args.get('v') else: mode = '' pagenum = '' vcode = '' commentary_db = db.Commentary() cview = commentary_db.cview(table, no) # 이메일 공개/비공개 user_db = db.User() identity = user_db.get_identity(cview[3]) # 비공개 글일 경우 해당 저자가 아니면 리스트 목록으로 넘어감 try: if cview[13] == 0 and current_user.user_id != cview[3]: return redirect('/' + table + '/list/') except: return redirect('/' + table + '/list/') else: return render_template('commentary_view.html', view=cview, table=table, mode=mode, pagenum=pagenum, vcode=vcode, identity=identity)
def commentary_del(table, no): if request.method == 'GET': next_url = request.args.get('n') else: next_url = "/" + table + "/list/" commentary_db = db.Commentary() user_db = db.User() if user_db.is_author(table, no, current_user): commentary_db.remove_commentary(table, no) return redirect(next_url) else: return redirect(next_url)
def commentary_select_vcode(no): commentary_db = db.Commentary() try: if current_user.user_id: vclist = commentary_db.vcode_mylist(no, current_user.user_id) category = 'myvcode' except: vclist = commentary_db.vcode_list(no) category = 'vcode' return render_template('commentary_list.html', lists=vclist, vcode=no, pagenum=1, totalpage=1, category=category)
def main_page(): commentary_db = db.Commentary() recent_posts_commentary = commentary_db.get_recent('commentary', 3) img_pattern = re.compile(r"<img[^>]*src=[\"']?([^>\"']+)[\"']?[^>]*>") title = [] content = [] img = [] date = [] author = [] no = [] urltitle = [] for post in recent_posts_commentary: title.append(post[4]) try: img.append(re.findall(img_pattern, str(post[5]))[0]) except: img.append("https://app.alphalef.com/static/img/logo.png") date.append(post[1].split(' ')[0]) author.append(post[2]) content_text = re.sub('<.+?>', '', post[5], 0, re.I | re.S) content_text = re.sub('$.+?;', '', content_text, 0, re.I | re.S) content.append(content_text[0:150]) no.append(post[0]) urltitle.append(post[10]) forum_db = db.Forum() recent_forum_topic = forum_db.get_recent_topic(3) # recent_posts_classic = commentary_db.get_recent('classic', 5) # return render_template('main.html', recent_posts_commentary=recent_posts_commentary, recent_posts_classic=recent_posts_classic) return render_template('main.html', author=author, date=date, img=img, content=content, title=title, urltitle=urltitle, no=no, recent_forum_topic=recent_forum_topic)
def commentary_list(table): if request.method == 'GET': pagenum = request.args.get('p') if not pagenum: pagenum = 1 commentary_db = db.Commentary() clist = commentary_db.clist(table, pagenum) totalnum = commentary_db.get_table_count(table) totalpage = int(int(totalnum) / 11) + 1 return render_template('commentary_list.html', lists=clist, user=current_user, table=table, totalpage=totalpage, pagenum=pagenum, category='list')