基于大数据的健身房管理系统的实现(Python)

今天药忘吃喽~ 2024-03-23 22:30 68阅读 0赞

目 录  
摘 要 I  
Abstract II  
1 绪论 1  
1.1选题背景及意义 1  
1.2国内外研究现状 2  
1.2.1国内研究现状 2  
1.2.2国外研究现状 2  
1.2.3发展趋势 3  
1.3研究主要内容 4  
2 关键技术介绍 5  
2.1相关技术简介 5  
2.1.1 B/S体系相关介绍 5  
2.1.2 Python语言介绍 6  
2.1.3 Djang框架介绍 6  
2.2技术方案选择 7  
2.3开发环境的确定 8  
3 系统分析 10  
3.1可行性分析 10  
3.2 系统需求分析 10  
3.2.1 开发设计思想 11  
3.2.2 开发项目的功能需求 11  
3.3处理流程设计 12  
3.3.1系统操作流程图 12  
3.3.2数据增加流程 13  
3.3.3数据修改流程图 13  
3.3.4数据删除流程图 14  
3.4输入输出设计 14  
3.4.1输入设计 14  
3.4.2输出设计 15  
4 系统设计 16  
4.1系统功能模块设计 16  
4.1.1系统功能总体模块设计 17  
4.1.2子功能模块设计 17  
4.2数据库设计 20  
4.2.1数据字典 21  
4.2.2系统实体图 23  
4.2.3流程图 26  
4.2.4数据表设计 27  
5 系统实现 31  
5.1个人信息管理功能模块的设计 31  
5.1.1个人信息管理功能模块的设计 32  
5.2健身会员课程选择的实现 33  
5.3教练选择模块的设计 34  
5.4课程管理的实现 35  
5.5健身教练管理的实现 36  
5.6个人信息修改密码的实现 37  
5.6.1 前端页面 37  
5.6.2 web层 38  
5.6.3 service层 39  
5.6.4 dao层以及mapper 40  
6 系统测试 41  
6.1测试用例 42  
6.1.1 以健身会员信息的添加、修改、删除为例进行测试 42  
6.1.2 测试用例之登录管理 43  
6.1.3 以该系统设计的菜单中会员管理菜单项为例进行测试 43  
7 总结与展望 45  
7.1 总结 45  
7.2系统的不足与改进方案 45  
7.2.1 系统的不足 45  
7.2.2 系统的改进方案 46  
参考文献 47  
致 谢 49  
1.3研究主要内容  
本系统的研究主要内容包括以下几个方面：  
系统的需求分析：针对健身房管理的实际需求，通过对健身房运营流程和管理流程的分析，明确了系统的功能需求和技术要求，为后续的系统设计和开发奠定了基础。  
系统的设计与实现：在需求分析的基础上，采用 Python 语言、Django 框架和 SQLite 数据库等技术，实现了会员管理、课程管理、财务管理和数据分析等多个模块，为健身房的管理和决策提供了全面和准确的数据支持。  
系统的测试和优化：通过对系统的功能测试和性能测试，发现并解决了一些潜在的问题和bug，同时也对系统的界面设计和用户体验进行了优化和改进，提高了整个系统的可靠性和实用性。  
系统的应用与推广：对系统进行了广泛的应用和推广，得到了用户的一致好评和认可，为健身房的管理和发展提供了有力的支持和帮助。  
综上所述，本系统的研究内容主要包括需求分析、系统设计与实现、测试与优化以及应用与推广等几个方面，旨在提高健身房的管理效率和数据分析能力，为健身房的发展和创新提供更加科学和智能化的管理手段和决策支持。

# -*- coding:utf-8 -*-
    
    from django.views.decorators.csrf import csrf_exempt
    
    import json
    
    from datetime import datetime
    from django.contrib.auth.hashers import make_password
    from django.contrib.auth.mixins import LoginRequiredMixin
    from django.http import HttpResponse, QueryDict, HttpResponseRedirect, JsonResponse
    from django.shortcuts import render, redirect
    from django.contrib.auth import authenticate, login, logout
    # Create your views here.
    from django.urls import reverse
    from django.views.generic.base import View
    
    from HeaClub import settings
    from course.models import Course
    from teachers.models import Teacher
    from users.forms import LoginForm, RegisterForm, UploadImageForm
    from users.models import UserMessage, UserFavorite, UserSign, UserMember
    from utils.pay import AliPay
    
    
    class IndexView(View):
        def get(self,request):
            all_course=Course.objects.all()[0:4]
            all_teacher=Teacher.objects.all()[0:4]
            return render(request, "index.html", {
        "all_course":all_course,"all_teacher":all_teacher})
    
    
    class LoginView(View):
        def get(self,request):
            return render(request, "login.html", {
        })
    
        def post(self, request):
            login_form=LoginForm(request.POST)
            if login_form.is_valid():
                username = request.POST.get("username", "")
                password = request.POST.get("password", "")
                all_course = Course.objects.all()[0:5]
                all_teacher = Teacher.objects.all()[0:5]
                # django用户认证方法
                user = authenticate(username=username, password=password)
                if user is not None:
                    login(request, user)
                    if user.type=='tea':
                        return render(request, "teacher-info.html")
                    else:
                        return render(request, "index.html",{
        "all_course":all_course,"all_teacher":all_teacher})
                else:
                    return render(request, "login.html", {
        'msg': '用户名或密码错误'})
            else:
                return render(request,'login.html',{
        'login_form':login_form})
    
    #---用户注册----
    class  RegisterView(View):
    
        def get(self,request):
            register_form = RegisterForm()
            return render(request,'register.html',{
        'register_form':register_form})
        def post(self,request):
            register_form = RegisterForm(request.POST)
            if register_form.is_valid():
                username = request.POST.get("username", "")
                password = request.POST.get("password", "")
                class_id=request.POST.get("class_id","class_id")
                if UserMessage.objects.filter(username=username):
                    return render(request,'register.html',{
        'register_form':register_form,'msg':u"用户已存在"})
                user_obj=UserMessage()
                user_obj.username=username
                user_obj.type=class_id
                #密码需要加密
               # make_password加密
                user_obj.password=  make_password(password)
                user_obj.save()
                #如果教练加到Teacher表
                if class_id=='tea':
                    tea_obj=Teacher(user=user_obj)
                    tea_obj.save()
                return render(request,'login.html',{
        'register_form':register_form})
            return render(request, 'register.html', {
        'register_form': register_form})
    
    class LogoutView(View):
        """
        用户登出
        pass
        # """
        def get(self, request):
            logout(request)
            return HttpResponseRedirect(reverse("index"))
    
    class UserinfoView(View):
    
        """
        # 用户个人信息
        # """
        def get(self, request):
    
            if request.user.type == 'tea':
                tea_obj=Teacher.objects.get(user=request.user)
                return render(request, "teacher-info.html",{
        "tea_obj":tea_obj})
            else:
                return render(request, 'usercenter-info.html', {
        })
    
        def post(self, request):
            data=(QueryDict(request.POST.get("data")))
            username=data['username']
            birthday=data["birthday"]
            sex=data["sex"]
            address=data["address"]
            mobile=data["mobile"]
            detail=data["detail"]
            user_info_obj=UserMessage.objects.get(id=request.user.id)
            user_info_obj.username=username
            if birthday:
                user_info_obj.birthday = birthday
            user_info_obj.sex = sex
            user_info_obj.address = address
            user_info_obj.mobile = mobile
            #简介添加到教练列表
    
            tea_obj=Teacher.objects.get(user=request.user)
            tea_obj.detail=detail
            try:
                user_info_obj.save()
                tea_obj.save()
            except Exception as  e:
                print(e)
                return HttpResponse('{
        "status":"fail"}', content_type='application/json')
            return HttpResponse('{
        "status":"success"}', content_type='application/json')
    
    
    
    
    
    
    
    class UploadImageView(View):
    
        def post(self, request):
            image_form = UploadImageForm(request.POST, request.FILES, instance=request.user)
            if image_form.is_valid():
                image_form.save()
                return HttpResponse('{
        "status":"success"}', content_type='application/json')
            else:
                return HttpResponse('{
        "status":"fail"}', content_type='application/json')
    
    class MemberView(View):
        def get(self,request):
            return render(request, 'user-mem.html', {
        })
    
        def post(self,request):
    
            order_no= '%s%d' % (datetime.now().strftime('%Y%m%d%H%M%S'), request.user.id)
            #创建订单
            user_m=UserMember(user=request.user,price=298,mem_time=datetime.now(),order_no=order_no)
            user_m.save()
            alipay = Get_AliPay_Object()
            #生成订单号
            out_trade_no="hy"+ str(datetime.now())
            #生成支付
            query_params = alipay.direct_pay(
                subject='开通会员',
                out_trade_no=order_no,  #订单号
                total_amount=str('298.00'),  # 交易金额
            )
    
            # 支付宝网关地址（沙箱应用）
            pay_url = settings.ALIPAY_URL + "?{0}".format(query_params)
            # return HttpResponseRedirect(pay_url)
            # 页面重定向到支付页面
            return JsonResponse({
        "res": 3, "pay_url": pay_url})
    
    class SignView(View):
    
        def get(self,request):
            now_time = datetime.now()
            all_sign=UserSign.objects.filter(user=request.user,signdate__month=now_time.month)
            all_day= [_day.day for _day in all_sign]
            all_day=json.dumps(all_day)
            today = datetime.now().date()
            us_count = UserSign.objects.filter(user=request.user, signdate=today).count()
            return render(request, 'sign.html',{
        "all_sign":all_sign,"all_day":all_day,"us_count":us_count})
    
        def post(self,request):
            today = datetime.now().date()
            us_obj=UserSign.objects.filter(user=request.user,signdate=today)
            if us_obj.count()==0:
                us_obj=UserSign(user=request.user,signdate=datetime.today(),day=today.day)
                us_obj.save()
            return HttpResponse('{
        "status":"ok"}', content_type='application/json')
    
    
    
    
    class MyFavTeacherView(View):
    
        def get(self, request):
            teacher_list = []
            fav_teachers = UserFavorite.objects.filter(user=request.user, fav_type=3)
            for fav_teacher in fav_teachers:
                teacher_id = fav_teacher.fav_id
                teacher = UserMessage.objects.get(id=teacher_id)
                teacher_list.append(teacher)
    
            return render(request, 'usercenter-fav-teacher.html', {
        
                "teacher_list":teacher_list
            })
    
    
    class MyFavCourseView(View):
        def get(self, request):
            course_list = []
            fav_courses = UserFavorite.objects.filter(user=request.user, fav_type=1)
            for fav_course in fav_courses:
                course_id = fav_course.fav_id
                course = Course.objects.get(id=course_id)
                course_list.append(course)
            return render(request, 'usercenter-fav-course.html', {
        
                "course_list":course_list
            })
    
    
    
    
    # from utils.pay import AliPay
    
    # AliPay 对象实例化
    def Get_AliPay_Object():
        alipay = AliPay(
            appid=settings.ALIPAY_APPID,  # APPID （沙箱应用）
            app_notify_url="http://127.0.0.1:8000/users/pay_result",  # 回调通知地址
            return_url="http://127.0.0.1:8000/users/pay_result",  # 支付完成后的跳转地址
            app_private_key_path=settings.APP_PRIVATE_KEY_PATH,  # 应用私钥
            alipay_public_key_path=settings.ALIPAY_PUBLIC_KEY_PATH,  # 支付宝公钥
            debug=True,  # 默认False,
        )
        return alipay
    
        # 发起支付请求
    
    
    
    
    
    class PayResultView(View):
        def get(self,request):
            alipay = Get_AliPay_Object()
            params = request.GET.dict()
            sign = params.pop('sign', None)
            status = alipay.verify(params, sign)
    
            out_trade_no=params.pop('out_trade_no')
            trade_no=params.pop('trade_no')#支付宝订单号
            user_m=UserMember.objects.get(order_no=out_trade_no)
            user_m.sale_no=trade_no
            pay_status='1'
    
            um_obj=UserMessage.objects.get(id=request.user.id)
            um_obj.is_member=True
            um_obj.open_date=datetime.now().date()
            um_obj.save()
            return render(request, 'usercenter-info.html', {
        })

![在这里插入图片描述][53dec3e8828b4b1eab305d5c122d1da3.png_pic_center]  
![在这里插入图片描述][974328242819431c89b17c0ec83d35ca.png_pic_center]  
![在这里插入图片描述][c64cd1fe271d427ea93f8d91f50d050b.png_pic_center]  
![在这里插入图片描述][6c0fdb274019444b85a078f7dd411377.png_pic_center]  
![在这里插入图片描述][c92bfed5794b466a8100ac7b64e6958c.png_pic_center]  
![在这里插入图片描述][3c1ccf1f361144c79cb7ff5307e46f28.png_pic_center]  
![在这里插入图片描述][20daeab48e41462e8c401a1cefa74b1a.png_pic_center]  
![在这里插入图片描述][195fbf31e82446a39c95221ff06720f0.png_pic_center]  
![在这里插入图片描述][d17a3ef5301147bfbfaa75990d80d1b2.png_pic_center]  
![在这里插入图片描述][34195a261e434bd6b5a0a4a3496f70eb.png_pic_center]  
![在这里插入图片描述][bb9f0f31d88248e888416a5d3c46c0ac.png_pic_center]  
![在这里插入图片描述][0888fb2ac6d84849824c37d9cb4ecad5.png_pic_center]  
![在这里插入图片描述][8ad05399d598406781ee01459c4dcc89.png_pic_center]  
![在这里插入图片描述][51677275d31f4f41ba6e927ea07482bc.png_pic_center]  
![在这里插入图片描述][ee3a004710aa472397c25d3d7bc0591c.png_pic_center]  
![在这里插入图片描述][d34ca28399514c45ae26cb70b9e60552.png_pic_center]  
![在这里插入图片描述][1d1d8e002c214285917e89c045a4794b.png_pic_center]  
![在这里插入图片描述][62fda3954d904ba98667e26cb37d948f.png_pic_center]  
![在这里插入图片描述][633c970c16cb4225860a33d823265807.png_pic_center]  
![在这里插入图片描述][a43b449737ce46fd8a7ba5d17610840f.png_pic_center]  
![在这里插入图片描述][f9500eaa333643068a2b6f14cc1dedfe.png_pic_center]  
![在这里插入图片描述][f8ed21e03d7d4affa695744f47848f10.png_pic_center]  
![在这里插入图片描述][6e32913f0e4546f9b9f1e47b82513128.png_pic_center]  
![在这里插入图片描述][6d1b2bbb4e8746e483a089fb4d17ce57.png_pic_center]  
![在这里插入图片描述][16a18373196a415786921c701742198f.png_pic_center]  
![在这里插入图片描述][6f44cb215b2c4011b3d3c9a8860141d4.png_pic_center]  
![在这里插入图片描述][b7fd9760bba1466697ca66d7b056a8dd.png_pic_center]  
![在这里插入图片描述][21174063f8754d4c80a37c9b7c9e103c.png_pic_center]  
![在这里插入图片描述][c7d57aefd2c4498bacc40d5b84c7d0c1.png_pic_center]  
![在这里插入图片描述][4de9b52c681442bf8ff66a1c728dc093.png_pic_center]  
![在这里插入图片描述][7406d65a8fc945e292dc695ab25b96f2.png_pic_center]  
![在这里插入图片描述][3ef52f1600944ded940f4fb74e5cd5ed.png_pic_center]  
![在这里插入图片描述][b84544664361478987626a6f028f9f29.png_pic_center]

[53dec3e8828b4b1eab305d5c122d1da3.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/d990a9228c3e45afb6c96b4480f51a19.png
[974328242819431c89b17c0ec83d35ca.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/fc342fd33c8b41fe94ea223e56efa370.png
[c64cd1fe271d427ea93f8d91f50d050b.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/17e25fa172cc42799ec8f97d4892d5ed.png
[6c0fdb274019444b85a078f7dd411377.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/6e7bbca1c0bd43d78a1bf7ee52ed0d70.png
[c92bfed5794b466a8100ac7b64e6958c.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/b9eac048d3f54f7490ef8f0b24200112.png
[3c1ccf1f361144c79cb7ff5307e46f28.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/d042f8d38eb74d3380c1f157cafddf4c.png
[20daeab48e41462e8c401a1cefa74b1a.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/902baf84773945d2b2b8cc6386196677.png
[195fbf31e82446a39c95221ff06720f0.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/d04a3becca2d49079581b947f558faf8.png
[d17a3ef5301147bfbfaa75990d80d1b2.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/60036bc810e54a1a88d9152f7ae82fdd.png
[34195a261e434bd6b5a0a4a3496f70eb.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/42f7cdbdd26e4371adb12e5801ea2077.png
[bb9f0f31d88248e888416a5d3c46c0ac.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/702d6f8de8394e1aa26410001bc729fe.png
[0888fb2ac6d84849824c37d9cb4ecad5.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/d90eb589d4bd4fc2958acd20d8705df1.png
[8ad05399d598406781ee01459c4dcc89.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/ca1c24d2175d465a9b71e8442c156783.png
[51677275d31f4f41ba6e927ea07482bc.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/e46a78b676764b5480325112f5725a4b.png
[ee3a004710aa472397c25d3d7bc0591c.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/a2a6b2f8522448ea8b204727938a64dd.png
[d34ca28399514c45ae26cb70b9e60552.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/1402273ccd0e4a17a2cf55b6f27635d1.png
[1d1d8e002c214285917e89c045a4794b.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/fa7b4469298a46599979d7376e61c218.png
[62fda3954d904ba98667e26cb37d948f.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/ce6c5e2570e14f808f3a48165277bc17.png
[633c970c16cb4225860a33d823265807.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/f301311f86674c3ab47a59da2f4322cb.png
[a43b449737ce46fd8a7ba5d17610840f.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/92302b095e0a43e08a6dde71fcf277df.png
[f9500eaa333643068a2b6f14cc1dedfe.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/0b1cac5ccad94cc38760316afd25c6ae.png
[f8ed21e03d7d4affa695744f47848f10.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/4bb6e757d9b54eebb731f74135e1bc3e.png
[6e32913f0e4546f9b9f1e47b82513128.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/eebcaa3284da43e1b2942d1c411689ad.png
[6d1b2bbb4e8746e483a089fb4d17ce57.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/d6a3db6388ef44848e8515ac6b92828b.png
[16a18373196a415786921c701742198f.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/61178d7c74974c5bb96551fb818dcfad.png
[6f44cb215b2c4011b3d3c9a8860141d4.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/d0c9fd745aed476e8bcd332a6fb5de3f.png
[b7fd9760bba1466697ca66d7b056a8dd.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/25151fd28b934e34b525ca3a0e36ac17.png
[21174063f8754d4c80a37c9b7c9e103c.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/6c1657600a2046a990ae266e0d5a10e4.png
[c7d57aefd2c4498bacc40d5b84c7d0c1.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/6d91ef61e17f46a597e377971b5eab54.png
[4de9b52c681442bf8ff66a1c728dc093.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/2be6326c34774b568e72d8465dc52ec0.png
[7406d65a8fc945e292dc695ab25b96f2.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/a30ea2dc96a54e26897d9f775866339d.png
[3ef52f1600944ded940f4fb74e5cd5ed.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/4b4852e3f7df41b9bc654878148072cb.png
[b84544664361478987626a6f028f9f29.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/2ce008a8bc904976a9ae58543a968327.png