def delroot():
rid = request.args.get("rid")
cur.execute("delete from role where rid=%s",(rid))
db.commit()
cur.execute("select * from role")
result = cur.fetchall()
return json.dumps(result)
def page():
page = request.args.get('page')
cur.execute(
"select * from question,`cursor`,questiontype where question.fid=`cursor`.cid and question.nid=questiontype.nid limit %s,10",
((int(page) - 1) * 10))
result = cur.fetchall()
return json.dumps(result)
def dele():
id = request.args.get('id')
cur.execute("delete from questiontype where id=%s", (id))
db.commit()
cur.execute("select * from questiontype")
result = cur.fetchall()
return json.dumps(result)
def del1():
id = request.args.get("id")
cur.execute("delete from users where uid=%s", (id))
db.commit()
cur.execute("select * from users,role where users.rid=role.rid")
data = cur.fetchall()
return json.dumps(data)
def updaterole():
rid = request.args.get("rid")
rname = request.args.get("rname")
power = request.args.get("power")
cur.execute("update role set rname=%s,power=%s where rid=%s",(rname,power,rid))
db.commit()
return "ok"
def add():
# nid=request.args.get('nid')
name = request.args.get('name')
cur.execute("insert into questiontype (name) values (%s)", (name))
db.commit()
cur.execute("select * from questiontype")
result = cur.fetchall()
return json.dumps(result)
def selectonestudent():
name = request.args.get('name')
cur.execute("select id from classes where name=%s", (name))
id = cur.fetchone()['id']
cur.execute("select name,phone,school from studentes where classid=%s",
(id))
result = cur.fetchall()
return json.dumps(result)
def look():
id = session.get('uid') or 10
cur.execute("select * from point where stuid=%s", (id))
result = cur.fetchall()
for item in result:
if isinstance(item['nowdate'], object):
item['nowdate'] = item['nowdate'].strftime("%Y-%m-%d %H:%M")
return json.dumps(result)
def del1():
data = json.loads(request.args.get('datas'))
cid = request.args.get('cid')
print(data)
cur.execute("delete from dircursor where cid=%s and step=%s",
(cid, data['step']))
db.commit()
return 'ok'
def menu():
rid = session.get("rid")
cur.execute("select power from role where rid=%s", (rid))
if int(rid) > 1:
rid = 0
print(rid)
result = cur.fetchone()['power'] + '|' + str(rid)
# result="1|2|3|4|5|6|7|8|0"
return result
def selectclasses():
cur.execute("select name,start,end from classes")
result = cur.fetchall()
for item in result:
# 把时间对象转化为字符串
if isinstance(item['start'], object):
item['start'] = item['start'].strftime("%Y-%m-%d")
if isinstance(item['end'], object):
item['end'] = item['end'].strftime("%Y-%m-%d")
return json.dumps(result)
def edit():
id = request.args.get('id')
nid = request.args.get('nid')
name = request.args.get('name')
print(id, nid, name)
cur.execute("update questiontype set nid=%s,name=%s where id=%s",
(nid, name, id))
db.commit()
cur.execute("select * from questiontype")
result = cur.fetchall()
return json.dumps(result)
def addjudge():
con=request.args.get('con')
answer=request.args.get('answer')
nid = 3
point = request.args.get('point') or 3
cname = request.args.get('cname')
cur.execute("select cid from `cursor` where cname=%s", (cname))
fid = cur.fetchone()['cid']
cur.execute("insert into question (fid,con,answer,point,nid) values (%s,%s,%s,%s,%s)",(fid, con, answer, point, nid))
db.commit()
return 'ok'
def filedata(con):
cur.execute("insert into `cursor` (cname) values (%s)", (con[0]))
cid = db.insert_id()
step = con[1].split("\n")
part = con[2].split("\n")
for index in range(len(step)):
arr = []
arr.append((step[index], part[index], cid))
cur.executemany(
"insert into `dircursor` (step,part,cid) values (%s,%s,%s)", (arr))
db.commit()
def addone():
name = request.args.get('name')
f = request.args.get('f')
start = request.args.get('start')
end = request.args.get('end')
cur.execute("select cid from `cursor` where cname=%s", (f))
cid = cur.fetchone()['cid']
cur.execute(
"insert into classes (name,start,end,fid) values (%s,%s,%s,%s)",
(name, start, end, cid))
db.commit()
return "ok"
def sel():
fid = session.get('fid') or 32
allquestion = []
seleone = []
selemore = []
judge = []
getquestion(fid, "单选题", seleone)
getquestion(fid, "多选题", selemore)
getquestion(fid, "判断题", judge)
allquestion = tuple(seleone + selemore + judge)
cur.execute("select * from question where id in" + str(allquestion))
result = cur.fetchall()
return json.dumps(result)
def add():
name = request.form['name']
upass = request.form['pass']
phone = request.form['phone']
rid = request.form['rid']
md5 = hashlib.md5()
md5.update(upass.encode())
upass = md5.hexdigest()
cur.execute(
"insert into users(name,uname,upass,phone,rid)values (%s,%s,%s,%s,%s)",
(name, phone, upass, phone, rid))
db.commit()
return 'ok'
def checkdata():
cod = request.form['code'].lower()
str1 = session.get("str1")
if cod != str1:
return redirect("/login")
phone = request.form['username']
upass = request.form['password']
# sys = request.form['sys']
md5 = hashlib.md5()
md5.update(upass.encode())
upass = md5.hexdigest()
print(uname, upass)
cur.execute("select * from users where uname=%s and upass=%s",
(phone, upass))
result = cur.fetchone()
print(result)
if result:
if result['rid'] == 1:
cur.execute("select classid from studentes where phone=%s",
(phone))
classid = cur.fetchone()['classid']
cur.execute("select * from classes where id=%s", (classid))
data = cur.fetchone()
classname = data['name']
fid = data['fid']
elif result['rid'] == 2:
cur.execute("select class from teacher where phone=%s", (phone))
classname = cur.fetchone()['class']
cur.execute("select * from classes where name=%s", (classname))
data = cur.fetchone()
classid = data['id']
fid = data['fid']
else:
classname = ''
classid = ''
fid = ''
if result:
session['fid'] = fid
session['class'] = classname
session['classid'] = classid
session['rid'] = result['rid']
session['uid'] = result['uid']
session['login'] = "******"
session['name'] = result['name']
# if sys=='0':
return redirect('/')
# else:
# return redirect('/exam')
return redirect('/login')
def getquestion(fid, name, question):
cur.execute("select * from questiontype where name=%s", (name))
onenid = cur.fetchone()['nid']
cur.execute("select id from question where fid=%s and nid=%s",
(fid, onenid))
oneid = cur.fetchall()
onearr = []
for i in oneid:
onearr.append(i['id'])
arr = []
while len(question) < 4:
i = random.randint(0, len(onearr) - 1)
if i not in arr:
arr.append(i)
question.append(onearr[i])
return question
def addstudaily():
uid = session.get('uid')
# classid=session.get('classid')
cur.execute("select phone from users where uid=%s", (uid))
phone = cur.fetchone()['phone']
name = session.get('name')
motto = request.args.get('motto')
con = request.args.get('con')
heart = request.args.get('heart')
suggest = request.args.get('suggest')
date = request.args.get('date')
cur.execute(
"insert into studaily (uid,name,motto,con,heart,suggest,date,phone) values (%s,%s,%s,%s,%s,%s,%s,%s)",
(uid, name, motto, con, heart, suggest, date, phone))
db.commit()
return 'ok'
def editonecursor():
data = request.args.get('data')
data = json.loads(data)
print(data)
cid = request.args.get('id')
cur.execute("update `cursor` set cname=%s where cid=%s", (data[0], cid))
cur.execute("delete from dircursor where cid=%s", (cid))
step = data[1].split("\n")
part = data[2].split("\n")
for index in range(len(step)):
arr = []
arr.append((step[index], part[index], cid))
cur.executemany(
"insert into `dircursor` (step,part,cid) values (%s,%s,%s)", (arr))
db.commit()
return 'ok'
def upload():
UPLOAD_FOLDER = 'upload/exam/'
current_app.config['UPLOAD_FOLDER'] = UPLOAD_FOLDER
if request.method == 'POST':
f = request.files['file'] # 从表单的file字段获取文件，myfile为该表单的name值
if f and allowed_file(f.filename): # 判断是否是允许上传的文件类型
fname = secure_filename(f.filename)
suf = fname.rsplit('.', 1)[1] #截取文件后缀名
now = int(time.time())
newfile = str(now)+'.'+suf
f.save(os.path.join(current_app.config['UPLOAD_FOLDER'],newfile))
book=xlrd.open_workbook('upload/exam/'+newfile)
sheet = book.sheet_by_index(0) #定义一个对象
question=[]
for i in range(1,sheet.nrows):
arr=[]
con = sheet.row_values(i)
cur.execute("select cid from `cursor` where cname=%s",(con[0]))
fid=cur.fetchone()['cid']
cur.execute("select nid from questiontype where name=%s", (con[1]))
nid=cur.fetchone()['nid']
sel=con[3].split('|')
if nid==1:
answer=sel.index(str(int(con[4])))
elif nid==2:
answer=''
ans = con[4].split('|')
for i in range(len(sel)):
for j in range(len(ans)):
if sel[i] == ans[j]:
a=str(i)+'|'
answer+=a
answer=answer[0:-1]
elif nid==3:
con[3]=None
if con[4]=='错':
answer=0
elif con[4]=='对':
answer=1
arr+=[fid]+[con[2]]+[con[3]]+[answer]+[int(con[5])]+[nid]
question.append(tuple(arr))
cur.executemany("insert into question (fid,con,`option`,answer,point,nid) values (%s,%s,%s,%s,%s,%s)",(question))
db.commit()
return 'ok'
else:
return "error"
def selectclasses():
cur.execute("select name,phone,fid,class from teacher")
result = cur.fetchall()
db1 = pymysql.connect(host="localhost",
user="******",
password="******",
db="lzm",
charset="utf8")
cur1 = db1.cursor()
cur1.execute("select cid,cname from `cursor`")
c = dict(cur1.fetchall())
db1.close()
print(result)
print(c)
for item in result:
item['fid'] = c[item['fid']]
return json.dumps(result)
def selectdaily():
rid = session.get('rid')
uid = session.get('uid')
if rid == '1':
cur.execute("select name,date from studaily where uid=%s", (uid))
result = cur.fetchall()
for item in result:
# 把时间对象转化为字符串
if isinstance(item['date'], object):
item['date'] = item['date'].strftime("%Y-%m-%d")
return json.dumps(result)
elif rid == '2':
cur.execute("select phone from users where uid=%s", (uid))
phone = cur.fetchone()['phone']
cur.execute("select class from teacher where phone=%s", (phone))
classname = cur.fetchone()['class']
cur.execute("select id from classes where name=%s", (classname))
id = cur.fetchone()['id']
db1 = pymysql.connect(host="localhost",
user="******",
password="******",
db="lzm",
charset="utf8")
cur1 = db1.cursor()
cur1.execute('select phone from studentes where calssid=%s', (id))
allphone = cur1.fetchall()
print(allphone)
cur1.executemany('select uid from users where phone=%s', (allphone))
alluid = cur1.fetchall()
db1.close()
cur.executemany('select * from studaily where uid=%s', (alluid))
result = cur.fetchall()
for item in result:
if isinstance(item['date'], object):
item['date'] = item['date'].strftime("%Y-%m-%d")
return json.dumps(result)
else:
cur.execute("select * from studaily")
result = cur.fetchall()
for item in result:
# 把时间对象转化为字符串
if isinstance(item['date'], object):
item['date'] = item['date'].strftime("%Y-%m-%d")
return json.dumps(result)
def selectonecursor():
cid = request.args.get('cid')
cname = request.args.get('cname')
cur.execute(
"select GROUP_CONCAT(step) from `cursor` inner join dircursor where `cursor`.cid=%s and dircursor.cid=%s group by cname",
(cid, cid))
step = cur.fetchone()['GROUP_CONCAT(step)']
step = step.split(",")
cur.execute(
"select part from `cursor` inner join dircursor where `cursor`.cid=%s and dircursor.cid=%s",
(cid, cid))
part = cur.fetchall()
result = []
for i in range(len(step)):
obj = {'cname': cname}
obj['step'] = step[i]
obj['part'] = part[i]['part']
result.append(obj)
# result[0]['cname']=cname
return json.dumps(result)
def addPoint():
id = session.get('uid') or 10
data = request.args.get('data')
data = json.loads(data)
myanswer = ''
aid = ''
for item in data:
if isinstance(item['myanswer'], list):
a = ''
for i in item['myanswer']:
a += str(i) + '|'
a = a[:-1]
item['myanswer'] = a
myanswer += str(item['myanswer']) + '/n'
aid += str(item['id']) + '/n'
myanswer = myanswer[:-2]
aid = aid[:-2]
point = data[len(data) - 1]['point']
nowdate = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
cur.execute(
"insert into point (stuid,point,myanswer,aid,nowdate) values (%s,%s,%s,%s,%s)",
(id, point, myanswer, aid, nowdate))
db.commit()
return 'ok'
def addone():
name = request.args.get('name')
school = request.args.get('school')
phone = request.args.get('phone')
classes = request.args.get('classes')
md5 = hashlib.md5()
md5.update(b'111111')
up = md5.hexdigest()
cur.execute("select id from classes where name=%s", (classes))
classid = cur.fetchone()['id']
cur.execute(
"insert into studentes (name,phone,school,classid) values (%s,%s,%s,%s)",
(name, phone, school, classid))
cur.execute(
"insert into users (name,uname,upass,phone,rid) values (%s,%s,%s,%s,%s)",
(name, phone, up, phone, 1))
db.commit()
return "ok"
def addone():
name = request.args.get('name')
f = request.args.get('f')
phone = request.args.get('phone')
classes = request.args.get('classes')
md5 = hashlib.md5()
md5.update(b'111111')
up = md5.hexdigest()
cur.execute("select cid from `cursor` where cname=%s", (f))
fid = cur.fetchone()['cid']
cur.execute(
"insert into teacher (name,phone,class,fid) values (%s,%s,%s,%s)",
(name, phone, classes, fid))
cur.execute(
"insert into users (name,uname,upass,phone,rid) values (%s,%s,%s,%s,%s)",
(name, phone, up, phone, 2))
db.commit()
return "ok"
def searchuser():
cur.execute("select * from users,role where users.rid=role.rid")
result = cur.fetchall()
return json.dumps(result)
def studailycon():
date = request.args.get('date')
cur.execute("select con,heart,suggest,motto from studaily where date=%s",
(date))
result = cur.fetchall()
return json.dumps(result)
