def admin_item(request):
pageusername = request.session.get('username')
if pageusername:
if request.method == 'POST':
itemname = request.POST.get('itemname')
itemcost = request.POST.get('itemcost')
itemtime = request.POST.get('itemtime')
print(itemname, itemcost, itemtime)
user = {
'itemname': itemname,
'itemcost': itemcost,
'itemtime': itemtime
}
models.item.objects.create(**user)
# 获取到当前页码
current_page = int(request.GET.get('pagenum', 1))
total = models.item.objects.all().count()
obj = page_help('/admin_item', current_page, total, 10)
page = obj.page_str()
query_set = models.item.objects.all()[obj.db_start():obj.db_end()]
return render(request, 'admin_item.html', locals())
else:
# 获取到当前页码
current_page = int(request.GET.get('pagenum', 1))
total = models.item.objects.all().count()
obj = page_help('/admin_item', current_page, total, 10)
page = obj.page_str()
query_set = models.item.objects.all()[obj.db_start():obj.db_end()]
return render(request, 'admin_item.html', locals())
def admin_coach(request):
pageusername = request.session.get('username')
if pageusername:
if request.method == 'POST':
username = request.POST.get('username')
if models.coach.objects.filter(username=username).exists():
info = '该用户已重复'
current_page = int(request.GET.get('pagenum', 1))
total = models.coach.objects.all().count()
obj = page_help('/admin_coach/', current_page, total, 10)
page = obj.page_str()
query_set = models.coach.objects.all()[obj.db_start():obj.
db_end()]
item_set = models.item.objects.all()
return render(request, 'admin_coach.html', locals())
else:
m1 = hashlib.md5()
m1.update(request.POST.get('pwd', None).encode('utf-8'))
password = m1.hexdigest()
gender = request.POST.get('gender')
birth = request.POST.get('birth')
tel = request.POST.get('tel')
charge = int(request.POST.get('charge'))
registertime = datetime.datetime.now()
print(username, password, gender, tel, birth, registertime)
user = {
'username': username,
'password': password,
'gender': gender,
'birth': birth,
'tel': tel,
'registerdate': registertime,
'charge_id': charge
}
models.coach.objects.create(**user)
# 获取到当前页码
current_page = int(request.GET.get('pagenum', 1))
total = models.coach.objects.all().count()
obj = page_help('/admin_coach/', current_page, total, 10)
page = obj.page_str()
query_set = models.coach.objects.all()[obj.db_start():obj.
db_end()]
return render(request, 'admin_coach.html', locals())
elif request.method == 'GET':
# 获取到当前页码
current_page = int(request.GET.get('pagenum', 1))
total = models.coach.objects.all().count()
obj = page_help('/admin_coach/', current_page, total, 10)
page = obj.page_str()
query_set = models.coach.objects.all()[obj.db_start():obj.db_end()]
item_set = models.item.objects.all()
return render(request, 'admin_coach.html', locals())
else:
return redirect('/login.html')
def index(request):
if request.method == 'GET':
# 获取到当前页码
current_page = int(request.GET.get('pagenum', 1))
amount_sql = "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = '%s';" % DATABASES[
'default']['NAME']
total = query_mysql(amount_sql)
total = total[0]['COUNT(*)']
#print(total)
obj = page_help('/index', current_page, total, 15)
page = obj.page_str()
sql = "SELECT (@i:=@i+1)AS id, table_name, TABLE_COMMENT FROM information_schema.tables,(select @i:=0)as it WHERE table_schema = '%s' ORDER BY table_name;" % DATABASES[
'default']['NAME']
table_comment = query_mysql(sql)
# print(type(the_id))
#print(table_comment)
query_set = table_comment[obj.db_start():obj.db_end()]
return render(request, 'index.html', locals())
elif request.method == 'POST':
table_name = request.POST.get('table_name', default='')
comments = request.POST.get('comments', default='')
sql = "SELECT (@i:=@i+1)AS id, table_name, TABLE_COMMENT FROM information_schema.tables,(select @i:=0)as it WHERE TABLE_SCHEMA='%s' AND TABLE_NAME LIKE '%%%s%%' AND TABLE_COMMENT LIKE '%%%s%%' ORDER BY table_name;" % (
DATABASES['default']['NAME'], table_name, comments)
print(sql)
query_set = query_mysql(sql)
return render(request, 'index.html', locals())
def admin_index(request):
pageusername = request.session.get('username')
if pageusername:
if request.method == 'POST':
username = request.POST.get('username')
if models.admin.objects.filter(username=username).exists():
info = '该用户已重复'
current_page = int(request.GET.get('pagenum', 1))
total = models.admin.objects.all().count()
obj = page_help('/admin_index/', current_page, total, 10)
page = obj.page_str()
query_set = models.admin.objects.all()[obj.db_start():obj.
db_end()]
return render(request, 'admin_index.html', locals())
else:
usernames = request.POST.get('username')
m1 = hashlib.md5()
m1.update(request.POST.get('pwd').encode('utf-8'))
password = m1.hexdigest()
registertime = datetime.datetime.now()
user = {
'username': usernames,
'password': password,
'registerdate': registertime
}
models.admin.objects.create(**user)
# 获取到当前页码
current_page = int(request.GET.get('pagenum', 1))
total = models.admin.objects.all().count()
obj = page_help('/admin_index', current_page, total, 10)
page = obj.page_str()
query_set = models.admin.objects.all()[obj.db_start():obj.
db_end()]
return render(request, 'admin_index.html', locals())
elif request.method == "GET":
# 获取到当前页码
current_page = int(request.GET.get('pagenum', 1))
total = models.admin.objects.all().count()
obj = page_help('/admin_index', current_page, total, 10)
page = obj.page_str()
query_set = models.admin.objects.all()[obj.db_start():obj.db_end()]
return render(request, 'admin_index.html', locals())
else:
return redirect('/login.html')
def coach_student(request):
pageusername = request.session.get('username')
if pageusername:
if request.method == 'GET':
query_set = models.coach.objects.filter(username=pageusername)
for i in query_set:
the_id = i.charge_id
the_name = i.charge
# 获取到当前页码
current_page = int(request.GET.get('pagenum', 1))
total = models.userinfo.objects.filter(choice_id=the_id).count()
obj = page_help('/coach_student/', current_page, total, 10)
page = obj.page_str()
query_set = models.userinfo.objects.filter(
choice_id=the_id)[obj.db_start():obj.db_end()]
return render(request, 'coach_student.html', locals())
else:
return redirect('/login.html')
def user(request):
username = request.session.get('username')
myinde = request.session.get('indentify')
if myinde == '管理员':
manager = True
coach = True
comuser = True
elif myinde == '教练':
coach = True
comuser = True
elif myinde == '会员':
comuser = True
else:
manager = False
coach = False
comuser = False
if username:
if request.method == 'POST':
username = request.POST.get('username')
password = request.POST.get('pwd')
gender = request.POST.get('gender')
age = request.POST.get('age')
weight = request.POST.get('weight')
height = request.POST.get('height')
email = request.POST.get('email')
rank = int(request.POST.get('rank'))
registertime = datetime.datetime.now()
print(username, password, gender, age, weight, height, email, rank,
registertime)
user = {
'username': username,
'password': password,
'gender': gender,
'age': age,
'weight': weight,
'height': height,
'email': email,
'rank_id': rank,
'registerdate': registertime
}
models.userinfo.objects.create(**user)
# 获取到当前页码
current_page = int(request.GET.get('pagenum', 1))
total = models.userinfo.objects.all().count()
obj = page_help('/user', current_page, total, 10)
page = obj.page_str()
query_set = models.userinfo.objects.all()[obj.db_start():obj.
db_end()]
return render(request, 'user.html', locals())
else:
#获取到当前页码
current_page = int(request.GET.get('pagenum', 1))
total = models.userinfo.objects.all().count()
obj = page_help('/user', current_page, total, 10)
page = obj.page_str()
query_set = models.userinfo.objects.all()[obj.db_start():obj.
db_end()]
return render(request, 'user.html', locals())
else:
return redirect('/login.html')