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')