def login_action(request):
name = request.POST['name']
password = request.POST['password']
database = Database()
row = database.select_fetchall(
"""SELECT user.name,user.id,user.role_id
FROM user WHERE name =%s and password = %s
""", [name, password])
if len(row) == 0:
params = {"mes": "登录失败"}
templateFile = "login.html"
return render_to_response(templateFile, params,
RequestContext(request))
else:
# 创建或修改 session：
request.session['name'] = name
request.session['user_id'] = row[0]['id']
request.session['role_id'] = row[0]['role_id']
remark = "登录成功"
database.execute(
""" insert into log(type,user_id,remark,time)values(%s,%s,%s,%s)""",
[1, row[0]['id'], remark,
datetime.datetime.now()])
params = {"mes": "登录成功"}
return HttpResponseRedirect('/app/new_index') #跳转到index界面
def exit(request):
remark = "注销"
database = Database()
database.execute(""" insert into log(type,user_id,remark,time)values(%s,%s,%s,%s)""",[2,request.session['user_id'],remark,datetime.datetime.now()])
del request.session['name']
del request.session['user_id']
return HttpResponseRedirect('/login') #跳转到index界面
def addTask(request):
name = request.session.get('name', default=None)
user_id = request.session.get('user_id', default=None)
if not name:
params = {"mes": ""}
templateFile = "login.html"
return render_to_response(templateFile, params,
RequestContext(request))
task = request.POST['task']
database = Database()
row = database.execute(
"""INSERT `task`(task,`status`,user_id) VALUES(%s,%s,%s)
""", [task, 0, user_id])
return HttpResponseRedirect('/task/index') #跳转到index界面
def updateUser(request):
name = request.session.get('name', default=None)
if not name:
params = {"mes": ""}
templateFile = "login.html"
return render_to_response(templateFile, params,
RequestContext(request))
loginname = request.POST['loginname']
id = request.POST['id']
sex = request.POST['sex']
age = request.POST['age']
password = request.POST['password']
database = Database()
row = database.execute(
"""update `user` set name=%s,password=%s,sex=%s,age=%s where id=%s
""", [loginname, password, sex, age, id])
return HttpResponseRedirect('/usermanage/index') #跳转到index界面
def addUser(request):
name = request.session.get('name', default=None)
if not name:
params = {"mes": ""}
templateFile = "login.html"
return render_to_response(templateFile, params,
RequestContext(request))
loginname = request.POST['loginname']
sex = request.POST['sex']
age = request.POST['age']
# password = request.POST['password']
password = "******"
database = Database()
row = database.execute(
"""INSERT `user`(name,`password`,sex,age) VALUES(%s,%s,%s,%s)
""", [loginname, password, sex, age])
return HttpResponseRedirect('/usermanage/index') #跳转到index界面
def addComment(request):
name = request.session.get('name',default=None)
if not name:
params={"mes":""}
templateFile = "login.html"
return render_to_response(
templateFile,
params,
RequestContext(request)
)
title = request.POST['title']
comment = request.POST['comment']
name = request.session.get('name',default=None)
dateTime = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
user_id =request.session['user_id']
database = Database()
row = database.execute("""INSERT `comment`(title,`comment`,user_id,create_time) VALUES(%s,%s,%s,%s)
""", [title,comment,user_id,dateTime])
return HttpResponseRedirect('/app') #跳转到index界面
def changeStatus(request):
id = request.POST.get('id', None)
type = request.POST.get('type', None)
if id and type:
database = Database()
if type == "start":
database.execute(""" update task set status = %s where id = %s """,
[1, id])
if type == "success":
database.execute(""" update task set status = %s where id = %s """,
[2, id])
if type == "fail":
database.execute(""" update task set status = %s where id = %s """,
[3, id])
return HttpResponse(json.dumps(["success"], ensure_ascii=False))
else:
return HttpResponse(json.dumps(["failed"], ensure_ascii=False))
