def detail(request):
aid = cgi.escape(request.GET.get('aid'))
url = request.get_host()
detail = []
if C.isset(aid):
detail = Article.objects.get(article_id=aid)
detail.author = User.objects.get(user_id=detail.author).username
detail.content = detail.content.replace('\t', '').replace('\n', '').replace(' ', '')
navList = C.getNavList()
userInfo = request.session.get('uInfo', '')
commentHtml = commentTree(commentList, 0, False)
commentList = Comment.objects.filter(article_id=aid)
del commentList
upArticle = Article.objects.get(article_id=aid)
upArticle.look_count = upArticle.look_count+1
upArticle.save()
context = {
'userinfo' : userInfo,
'detail' : detail,
'navList' : navList,
'url' : url,
'aid' : aid,
'commentHtml' : commentHtml,
'themeHeader' : C.getThemePath() + '/Public/header.html',
'themeFooter' : C.getThemePath() + '/Public/footer.html'
}
return render(request, C.getThemePath() + 'detail.html', context)
def index(request):
url = request.get_host()
cid = request.GET.get('cid')
if C.isset(cid) == 0:
cid = 0
navList = C.getNavList()
if request.method == 'POST':
articleList = Article.objects.filter(title__icontains=cgi.escape(request.POST.get('word'))).order_by('-article_id')
elif cid == 0:
articleList = Article.objects.all().order_by('-article_id')
else:
sql = 'SELECT * FROM "' + Meta.db_table + '_article" AS article LEFT JOIN "' + Meta.db_table
sql += '_relation" AS relation ON article.article_id=relation.aid WHERE relation.cid=' + cgi.escape(cid)
#sql += " AND article.title LIKE '%%" + request.POST.get('word') + "%%'"
sql += ' ORDER BY article_id DESC'
articleList = Article.objects.raw(sql)
articleList = list(articleList)
paginator = Paginator(articleList, 5)
page = int(request.GET.get('page', 1))
try:
pagebar = paginator.page(page)
except PageNotAnInteger:
pagebar = paginator.page(1)
except EmptyPage:
pagebar = paginator.page(paginator.num_pages)
categoryList = C.getCategoryList()
userInfo = request.session.get('uInfo', '')
contentDateList = Article.objects.order_by('created').values('created').distinct()
context = {
'url' : url,
'pagebar' : pagebar,
'navList' : navList,
'userinfo' : userInfo,
'cid' : int(cid),
'articleList' : articleList,
'categoryList' : categoryList,
'webInfo' : C.getWebInfo(),
'contentDateList' : contentDateList,
'themeHeader' : C.getThemePath() + '/Public/header.html',
'themeFooter' : C.getThemePath() + '/Public/footer.html'
}
return render(request, C.getThemePath() + 'index.html', context)
def signin(request):
navList = C.getNavList()
