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))