-
Notifications
You must be signed in to change notification settings - Fork 0
/
article.py
101 lines (84 loc) · 2.75 KB
/
article.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
# -*- coding: utf-8 -*-
# -*- coding: utf-8 -*-
from myapp import app
from flask import render_template, url_for, redirect, request, flash, session, g, abort
from model import Catagory,db,Article
from flask import jsonify
import json
import urllib
import random
import os,sys
import re
import datetime
import utils
from urllib import unquote
@app.route('/article/catagorymanage', methods=['GET','POST'])
def catagorymanage():
return render_template("catagorymanage.html",title = 'Home',action='/catagorymanage')
@app.route('/article/getcatagorys', methods=['GET','POST'])
def getcatagorys():
catagory=Catagory()
pageIndexParam = request.form['pageIndex']
belongto=request.form['belongto']
query=Catagory.query
###条件查询####
if belongto:
query=query.filter(Catagory.belongto == belongto)
pageIndexParam=int(pageIndexParam)+1
total=len(query.all())
paginate = query.paginate(pageIndexParam, 10, False)
catagorys = paginate.items
catagorylist = []
for catagory in catagorys:
catagorylist.append(catagory.to_json())
return (jsonify(rows=catagorylist,results=total))
@app.route('/article/delcatagorys',methods=['GET','POST'])
def delcatagorys():
catagory=Catagory()
requeststr = request.query_string
ids=utils.getAjaxIds(unquote(requeststr))
for catagoryid in ids:
catagory.deletecatagory(catagoryid)
return(jsonify(msg='0000'))
@app.route('/article/addcatagory', methods=['GET','POST'])
def addcatagory():
catagory=Catagory()
requeststr = request.query_string
print unquote(requeststr)
params=utils.getparam(unquote(requeststr))
catagory.catagoryname=params['catagoryname']
catagory.belongto=params['belongto']
catagory.addcatagory()
return jsonify(msg='0000')
@app.route('/article/editcatagory',methods=['GET','POST'])
def editcatagory():
catagory=Catagory()
requeststr=request.query_string
params=utils.getparam(unquote(requeststr))
paramdict={}
paramdict["catagoryid"]=params['catagoryid']
paramdict["catagoryname"]=params['catagoryname']
paramdict["belongto"]=params['belongto']
catagory.updatecatagory(paramdict)
return jsonify(msg='0000')
@app.route('/article/addarticle')
def addarticle():
article=Article()
requeststr=request.query_string
params=utils.getArticleStr(unquote(requeststr))
article.title=params[0]
article.catagoryrelateid=params[1]
article.content=params[2]
article.addarticle()
return jsonify(msg='0000')
@app.route('/article/getArticle')
def getArticle():
article=Article()
articlelist=Article.query.all()
articles=[]
for article in articlelist:
articles.append(article.to_json())
return (jsonify(rows=articles))
@app.route('/article/articlemanage', methods=['GET','POST'])
def articlemanage():
return render_template("articlemanage.html",title = 'Home',action='/catagorymanage')