def article_write(request): userInfo = request.session.get('uInfo', False) url = C.getProtocol(request) + request.get_host() if C.checkLoginAdmin(userInfo) == False: return HttpResponseRedirect('/') if request.method == 'POST': currTime = C.getCurrTime() createTime = cgi.escape(request.POST.get('create_date')) + ' ' + cgi.escape(request.POST.get('create_time')) articleInfo = Article.objects.create( look_count = 0, comment_count = 0, update_time = currTime, create_time = createTime, author = int(userInfo['user_id']), title = cgi.escape(request.POST.get('title')), content = cgi.escape(request.POST.get('content')), article_pic = cgi.escape(request.POST.get('article_pic')), created = datetime.datetime.strftime(datetime.datetime.now(timeZone), '%Y年%m月') ) categoryIdList = request.REQUEST.getlist('category') for item in categoryIdList: Relation.objects.create(aid=articleInfo.article_id, cid=item) categoryList = C.getCategoryList() attachmentList = Attachment.objects.all().order_by('-attrch_id') context = { 'url' : url, 'categoryList' : categoryList, 'attachmentList' : attachmentList } return render(request, manageThemeDir + 'article_write.html', context)
def category(request): if C.checkLoginAdmin(request.session.get('uInfo', False)) == False: return HttpResponseRedirect('/signin/') else: context = { 'categoryList' : C.getCategoryList('<i class="uk-icon-minus"></i>') } return render(request, manageThemeDir + 'category.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 article_edit(request): if C.checkLoginAdmin(request.session.get('uInfo', False)) == False: return HttpResponseRedirect('/signin/') else: context = {} url = request.get_host() userInfo = request.session.get('uInfo', False) aid = cgi.escape(request.GET.get('aid', 0)) if request.method == 'POST': updateArticle = Article.objects.get(article_id=aid) createTime = cgi.escape(request.POST.get('create_date')) + ' ' + cgi.escape(request.POST.get('create_time')) updateArticle.create_time = createTime updateArticle.update_time = C.getCurrTime() updateArticle.author = int(userInfo['user_id']) updateArticle.article_pic = request.POST.get('article_pic', '') updateArticle.title = cgi.escape(request.POST.get('title', '')) updateArticle.content = cgi.escape(request.POST.get('content', '')) updateArticle.save() Relation.objects.filter(aid=aid).delete() categoryIdList = cgi.escape(request.REQUEST.getlist('category')) for item in categoryIdList: Relation.objects.create(aid=aid, cid=item) return HttpResponse('修改文章成功') detail = [] if C.isset(aid): detail = Article.objects.get(article_id=aid) detail.create_date = str(detail.create_time)[0:10] detail.create_time = str(detail.create_time)[10:16] detail.author = User.objects.get(user_id=detail.author).username detail.content = detail.content.replace('\t', '').replace('\n', '').replace(' ', '') categoryList = C.getCategoryList() activeCategory = Relation.objects.filter(aid=aid).all() attachmentList = Attachment.objects.all().order_by('-attrch_id') context = { 'detail' : detail, 'categoryList' : categoryList, 'activeCategory' : activeCategory, 'attachmentList' : attachmentList } return render(request, manageThemeDir + 'article_edit.html', context)
def category_add(request): context = {} if request.method == 'POST': chosenPid = int(request.POST.get('pid', 0)) pidInfo = Category.objects.get(category_id=chosenPid) currPath = str(pidInfo.path) + '-' + str(pidInfo.category_id) Category.objects.create( path = currPath, pid = chosenPid, name = cgi.escape(request.POST.get('name', '')), ) return HttpResponse('success') context = { 'categoryList' : C.getCategoryList() } return render(request, manageThemeDir + 'category_add.html', context)
def category_add(request): if C.checkLoginAdmin(request.session.get('uInfo', False)) == False: return HttpResponseRedirect('/signin/') else: context = {} if request.method == 'POST': chosenPid = int(request.POST.get('pid', 0)) pidInfo = Category.objects.get(category_id=chosenPid) currPath = str(pidInfo.path) + '-' + str(pidInfo.category_id) Category.objects.create( path = currPath, pid = chosenPid, name = cgi.escape(request.POST.get('name', '')), ) return HttpResponse('success') context = { 'categoryList' : C.getCategoryList() } return render(request, manageThemeDir + 'category_add.html', context)
def category(request): context = { 'categoryList' : C.getCategoryList('<i class="uk-icon-minus"></i>') } return render(request, manageThemeDir + 'category.html', context)