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