def jsonIndex(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))
user = request.GET.get("user")
if not user:
user = ""
limit = 10
curpage = request.GET.get('curpage', None)
if not curpage:
curpage = 1
else:
curpage = int(curpage)
start = curpage * limit - limit
database = Database()
row = database.select_fetchall(
"""SELECT user.name,task.id,task.task,task.status
FROM user,task WHERE task.user_id = user.id and task.user_id = %s order by task.id desc limit %s,%s
""", [user_id, start, limit])
lenrow = database.select_fetchall(
"""SELECT count(task.id) len FROM task where user_id =%s """,
[user_id])
data = {"row": row, "count": lenrow}
#ensure_ascii=False用于处理中文
return HttpResponse(json.dumps(data, ensure_ascii=False))
pass
def index(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))
user = request.GET.get("user")
if not user:
user = ""
limit = 10
curpage = request.GET.get('curpage', None)
if not curpage:
curpage = 1
else:
curpage = int(curpage)
start = curpage * limit - limit
database = Database()
row = database.select_fetchall(
"""SELECT user.name,task.id,task.task,task.status
FROM user,task WHERE task.user_id = user.id and task.user_id = %s order by task.id desc limit %s,%s
""", [user_id, start, limit])
lenrow = database.select_fetchall(
"""SELECT count(task.id) len FROM task where user_id =%s """,
[user_id])
# users = database.select_fetchall(""" SELECT user.name,user.id
# FROM user """,[])
params = {"task": row, "count": lenrow[0]['len'], "curpage": curpage}
templateFile = "task/index.html"
return render_to_response(templateFile, params, RequestContext(request))
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 statistics(request):
name = request.session.get('name',default=None)
if not name:
params={"mes":""}
templateFile = "login.html"
return render_to_response(
templateFile,
params,
RequestContext(request)
)
database = Database()
row = database.select_fetchall("""SELECT COUNT(comment.id) count,user.name
FROM user LEFT JOIN comment on user.id = comment.user_id GROUP BY user_id,user.name """, [])
count =[]
names = [];
for x in row:
count.append(x['count'])
names.append(x['name'])
params={
"name":name,
"names":names,
"count":count
}
templateFile = "statistics.html"
return render_to_response(
templateFile,
params,
RequestContext(request)
)
def getUser(request, id):
print id
database = Database()
data = database.select_fetchall(
""" SELECT user.name,user.id,sex,age,password FROM user where id=%s """,
[id])
#ensure_ascii=False用于处理中文
return HttpResponse(json.dumps(data[0], ensure_ascii=False))
def index2(request):
name = request.session.get('name', default=None)
if not name:
params = {"mes": ""}
templateFile = "login.html"
return render_to_response(templateFile, params,
RequestContext(request))
user = request.GET.get("user")
if not user:
user = ""
limit = 10
curpage = request.GET.get('curpage', None)
if not curpage:
curpage = 1
else:
curpage = int(curpage)
start = curpage * limit - limit
database = Database()
if user != "":
row = database.select_fetchall(
"""SELECT user.name,log.id,log.remark,log.type,log.time
FROM user,log WHERE log.user_id = user.id and user.id=%s order by time desc limit %s,%s
""", [user, start, limit])
lenrow = database.select_fetchall(
"""SELECT count(log.id) len FROM log where log.user_id = %s """,
[user])
else:
row = database.select_fetchall(
"""SELECT user.name,log.id,log.remark,log.type,log.time
FROM user,log WHERE log.user_id =user.id order by time desc limit %s,%s
""", [start, limit])
lenrow = database.select_fetchall(
"""SELECT count(log.id) len FROM log """, [])
for x in row:
x['time'] = datetime_to_string(x["time"])
users = database.select_fetchall(
""" SELECT user.name,user.id
FROM user """, [])
params = {
"users": users,
"log": row,
"count": lenrow[0]['len'],
"curpage": curpage
}
templateFile = "log/index2.html"
return render_to_response(templateFile, params, RequestContext(request))
def jsonHome(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.GET.get("title")
user = request.GET.get("user")
title = request.GET.get("title")
user = request.GET.get("username")
curpage = request.GET.get('curpage',None)
if not title:
title="%%"
if not user:
user=""
database = Database()
limit = 10
if not curpage:
curpage=1
else:
curpage =int(curpage)
start = curpage*limit -limit
if user!="":
row = database.select_fetchall("""SELECT comment.id,comment.title,
comment.comment,user.name,comment.create_time
FROM comment,user WHERE user.id = comment.user_id and comment.title like %s and user.id = %s order by comment.create_time desc
limit %s,%s""", [title,user,start,limit])
lenrow = database.select_fetchall("""SELECT count(comment.id) len FROM comment where comment.user_id = %s and comment.title like %s """, [user,title])
else:
row = database.select_fetchall("""SELECT comment.id,comment.title,
comment.comment,user.name,comment.create_time
FROM comment,user WHERE user.id = comment.user_id and comment.title like %s order by comment.create_time desc
limit %s,%s""", [title,start,limit])
lenrow = database.select_fetchall("""SELECT count(comment.id) len FROM comment where comment.title like %s """, [title])
for x in row:
x['create_time'] = x['create_time'].strftime('%Y-%m-%d %H:%M:%S')
data = {"row": row,"count":lenrow}
#ensure_ascii=False用于处理中文
return HttpResponse(json.dumps(data, ensure_ascii=False))
pass
def jsonIndex(request):
name = request.session.get('name', default=None)
if not name:
params = {"mes": ""}
templateFile = "login.html"
return render_to_response(templateFile, params,
RequestContext(request))
user = request.GET.get("user")
if not user:
user = ""
limit = 10
curpage = request.GET.get('curpage', None)
if not curpage:
curpage = 1
else:
curpage = int(curpage)
start = curpage * limit - limit
database = Database()
if user != "":
row = database.select_fetchall(
"""SELECT user.name,log.id,log.remark,log.type,log.time
FROM user,log WHERE log.user_id = user.id and user.id=%s order by time desc limit %s,%s
""", [user, start, limit])
lenrow = database.select_fetchall(
"""SELECT count(log.id) len FROM log where log.user_id = %s """,
[user])
else:
row = database.select_fetchall(
"""SELECT user.name,log.id,log.remark,log.type,log.time
FROM user,log WHERE log.user_id =user.id order by time desc limit %s,%s
""", [start, limit])
lenrow = database.select_fetchall(
"""SELECT count(log.id) len FROM log """, [])
for x in row:
x['time'] = datetime_to_string(x["time"])
data = {"row": row, "count": lenrow}
#ensure_ascii=False用于处理中文
return HttpResponse(json.dumps(data, ensure_ascii=False))
pass
def index(request):
name = request.session.get('name', default=None)
role_id = request.session.get('role_id', default=False)
if not name:
params = {"mes": ""}
templateFile = "login.html"
return render_to_response(templateFile, params,
RequestContext(request))
database = Database()
users = database.select_fetchall(
""" SELECT user.name,user.id,password,role_id,sex,age
FROM user """, [])
params = {"user": users, "role_id": role_id}
templateFile = "usermanage/index.html"
return render_to_response(templateFile, params, RequestContext(request))
def index3(request):
name = request.session.get('name',default=None)
role_id = request.session.get('role_id',default=False)
isOperation = False
if role_id==0:
isOperation = True
pass
if not name:
params={"mes":""}
templateFile = "login.html"
return render_to_response(
templateFile,
params,
RequestContext(request)
)
title = request.GET.get("title")
user = request.GET.get("user")
if not title:
title="%%"
if not user:
user=""
database = Database()
limit = 10
curpage = request.GET.get('curpage',None)
if not curpage:
curpage=1
else:
curpage =int(curpage)
start = curpage*limit -limit
if user!="":
row = database.select_fetchall("""SELECT comment.id,comment.title,
comment.comment,user.name,comment.create_time
FROM comment,user WHERE user.id = comment.user_id and comment.title like %s and user.id = %s order by comment.create_time desc
limit %s,%s""", [title,user,start,limit])
lenrow = database.select_fetchall("""SELECT count(comment.id) len FROM comment where comment.user_id = %s and comment.title like %s """, [user,title])
else:
row = database.select_fetchall("""SELECT comment.id,comment.title,
comment.comment,user.name,comment.create_time
FROM comment,user WHERE user.id = comment.user_id and comment.title like %s order by comment.create_time desc
limit %s,%s""", [title,start,limit])
lenrow = database.select_fetchall("""SELECT count(comment.id) len FROM comment where comment.title like %s """, [title])
for x in row:
x['create_time'] = x['create_time'].strftime('%Y-%m-%d %H:%M:%S')
if x['name']==name:
x['isme']=True
else:
x['isme']=False
users = database.select_fetchall(""" SELECT user.name,user.id
FROM user """,[])
if title=="%%":
title=""
params={
"row":row,
"count":lenrow[0]['len'],
"curpage":curpage,
"title":title,
"user":user,
"users":users,
"name":name,
"isOperation":isOperation,
"openOption":True,
"refreshTime":100
}
templateFile = "index3.html"
return render_to_response(
templateFile,
params,
RequestContext(request)
)
