大家好，我是Java1234_小锋老师，分享一套锋哥原创的基于Python的会员管理系统(带微信小程序会员端)(FastAPI+Vue3)优质版

项目介绍

随着移动互联网与数字化运营的快速发展，会员制已成为零售、餐饮、生活服务等行业提升客户黏性与复购率的重要手段。传统依赖纸质会员卡或分散表格登记的管理模式，存在信息滞后、统计困难、等级折扣难以自动执行、会员端触达不便等问题。因此，设计并实现一套前后端分离、移动端可访问的会员管理系统，对中小型商户实现精细化运营具有现实意义。

本文设计并实现了“基于Python的会员管理系统（带微信小程序端）”。系统采用B/S架构与前后端分离思想：后端基于Python语言与FastAPI框架构建RESTful接口，使用SQLAlchemy操作MySQL数据库（库名db_member），并结合JWT完成管理员与会员双端身份认证；管理后台基于Vue3、Vue Router、Pinia与Element Plus实现，首页集成ECharts数据统计图表；微信小程序端面向会员用户，提供用户名密码登录、注册、公告浏览、资产查看、头像与个人资料修改、密码修改等功能。业务上覆盖会员档案、会员等级与折扣、商品管理、充值、消费、积分获取与兑换、公告发布以及管理员与角色管理等核心场景，并实现消费折扣计算、余额扣减、积分累计与自动升级等关键业务闭环。

系统经过功能测试验证，各模块运行稳定，接口响应正常，能够满足本科毕业设计对完整性、规范性与实用性的要求。实践表明，Python与FastAPI适合快速构建高可读性的后端服务，Vue3适合构建交互友好的管理端，微信小程序则能有效降低会员使用门槛。论文同时给出了E-R图、功能结构图、时序图与数据表字段设计，并对关键功能附核心代码说明，便于复现与二次开发。

源码下载 

链接: https://pan.baidu.com/s/1hbcKeOPblLjWPn4royqf3A?pwd=1234
提取码: 1234

系统展示

核心代码

"""
消费业务服务
对齐 Java ConsumeServiceImpl.doConsume
"""
from decimal import Decimal, ROUND_DOWN, ROUND_HALF_UP

from sqlalchemy.orm import Session

from app.common.exception import BusinessException
from app.models.consume import Consume
from app.models.member import Member
from app.models.member_level import MemberLevel
from app.models.points_record import PointsRecord
from app.models.product import Product


class ConsumeService:
    """消费服务类"""

    @staticmethod
    def do_consume(db: Session, consume: Consume) -> None:
        """
        执行会员消费：按等级折扣扣费、扣库存、增加积分并记录
        :param db: 数据库会话
        :param consume: 消费信息
        """
        member = (
            db.query(Member)
            .filter(Member.id == consume.member_id, Member.deleted == 0)
            .first()
        )
        if member is None:
            raise BusinessException("会员不存在")
        if member.status is not None and member.status == 0:
            raise BusinessException("会员已冻结，无法消费")

        amount = consume.amount
        # 若选择了商品，以商品价格为准并扣库存
        if consume.product_id is not None:
            product = (
                db.query(Product)
                .filter(Product.id == consume.product_id, Product.deleted == 0)
                .first()
            )
            if product is None:
                raise BusinessException("商品不存在")
            if product.status is not None and product.status == 0:
                raise BusinessException("商品已下架")
            if product.stock is not None and product.stock <= 0:
                raise BusinessException("商品库存不足")
            amount = product.price
            product.stock = product.stock - 1
            db.add(product)

        if amount is None or amount <= 0:
            raise BusinessException("消费金额必须大于0")

        # 按会员等级计算折扣
        discount = Decimal("1")
        if member.level_id is not None:
            level = (
                db.query(MemberLevel)
                .filter(MemberLevel.id == member.level_id, MemberLevel.deleted == 0)
                .first()
            )
            if level is not None and level.discount is not None:
                discount = Decimal(str(level.discount))

        real_amount = (amount * discount).quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)
        balance = member.balance if member.balance is not None else Decimal("0")
        if balance < real_amount:
            raise BusinessException("会员余额不足")

        new_balance = balance - real_amount
        points_gained = int(real_amount.to_integral_value(rounding=ROUND_DOWN))
        current_points = member.points if member.points is not None else 0
        new_points = current_points + points_gained

        member.balance = new_balance
        member.points = new_points
        ConsumeService._upgrade_level(db, member, new_points)
        db.add(member)

        consume.amount = amount
        consume.real_amount = real_amount
        consume.points_gained = points_gained
        consume.balance_after = new_balance
        consume.deleted = 0
        db.add(consume)

        # 记录积分获取
        if points_gained > 0:
            record = PointsRecord(
                member_id=member.id,
                change_points=points_gained,
                type="获取",
                remark="消费获得积分",
                deleted=0,
            )
            db.add(record)

        db.commit()

    @staticmethod
    def _upgrade_level(db: Session, member: Member, new_points: int) -> None:
        """
        根据积分自动升级会员等级
        :param db: 数据库会话
        :param member: 会员
        :param new_points: 最新积分
        """
        levels = (
            db.query(MemberLevel)
            .filter(MemberLevel.deleted == 0)
            .order_by(MemberLevel.upgrade_points.desc())
            .all()
        )
        for level in levels:
            if level.upgrade_points is not None and new_points >= level.upgrade_points:
                member.level_id = level.id
                break

<template>
  <div class="page-card">
    <div class="search-bar">
      <el-select v-model="query.memberId" placeholder="选择会员" clearable filterable style="width: 200px">
        <el-option v-for="m in members" :key="m.id" :label="`${m.name}(${m.cardNo})`" :value="m.id" />
      </el-select>
      <el-button type="primary" @click="loadData"><el-icon><Search /></el-icon>查询</el-button>
      <el-button @click="query.memberId=null; query.pageNum=1; loadData()"><el-icon><Refresh /></el-icon>重置</el-button>
    </div>
    <div class="toolbar">
      <el-button type="primary" @click="openDialog()"><el-icon><Plus /></el-icon>会员消费</el-button>
    </div>
    <el-table :data="tableData" stripe border style="width: 100%">
      <el-table-column prop="cardNo" label="会员卡号" min-width="120" />
      <el-table-column prop="memberName" label="会员姓名" min-width="100" />
      <el-table-column prop="productName" label="商品" min-width="120" />
      <el-table-column prop="amount" label="原价" min-width="90" />
      <el-table-column prop="realAmount" label="实付" min-width="90" />
      <el-table-column prop="pointsGained" label="获得积分" min-width="90" />
      <el-table-column prop="balanceAfter" label="消费后余额" min-width="110" />
      <el-table-column prop="operator" label="操作人" min-width="90" />
      <el-table-column prop="createTime" label="消费时间" min-width="160" />
      <el-table-column label="操作" min-width="90" fixed="right">
        <template #default="{ row }">
          <el-button type="danger" link @click="handleDelete(row)">删除</el-button>
        </template>
      </el-table-column>
    </el-table>
    <div class="pagination-wrap">
      <el-pagination v-model:current-page="query.pageNum" v-model:page-size="query.pageSize" :total="total"
        :page-sizes="[10,20,50]" layout="total, sizes, prev, pager, next" @size-change="loadData" @current-change="loadData" />
    </div>

    <el-dialog v-model="dialogVisible" title="会员消费" width="480px" destroy-on-close>
      <el-form ref="formRef" :model="form" :rules="rules" label-width="90px">
        <el-form-item label="会员" prop="memberId">
          <el-select v-model="form.memberId" filterable placeholder="请选择会员" style="width: 100%">
            <el-option v-for="m in members" :key="m.id" :label="`${m.name}(${m.cardNo}) 余额:${m.balance}`" :value="m.id" />
          </el-select>
        </el-form-item>
        <el-form-item label="商品" prop="productId">
          <el-select v-model="form.productId" filterable placeholder="请选择商品" style="width: 100%">
            <el-option v-for="p in products" :key="p.id" :label="`${p.productName} ¥${p.price}`" :value="p.id" />
          </el-select>
        </el-form-item>
        <el-form-item label="备注">
          <el-input v-model="form.remark" />
        </el-form-item>
      </el-form>
      <template #footer>
        <el-button @click="dialogVisible = false">取消</el-button>
        <el-button type="primary" :loading="saving" @click="handleSave">确认消费</el-button>
      </template>
    </el-dialog>
  </div>
</template>

<script setup>
/**
 * 消费管理页面
 */
import { ref, reactive, onMounted } from 'vue'
import { ElMessage, ElMessageBox } from 'element-plus'
import request from '@/utils/request'

const tableData = ref([])
const members = ref([])
const products = ref([])
const total = ref(0)
const dialogVisible = ref(false)
const saving = ref(false)
const formRef = ref()
const query = reactive({ pageNum: 1, pageSize: 10, memberId: null })
const form = reactive({ memberId: null, productId: null, remark: '' })
const rules = {
  memberId: [{ required: true, message: '请选择会员', trigger: 'change' }],
  productId: [{ required: true, message: '请选择商品', trigger: 'change' }]
}

async function loadData() {
  const res = await request.get('/api/consume/list', { params: query })
  tableData.value = res.data.records
  total.value = res.data.total
}

async function loadOptions() {
  const [m, p] = await Promise.all([
    request.get('/api/member/all'),
    request.get('/api/product/all')
  ])
  members.value = m.data
  products.value = p.data
}

function openDialog() {
  Object.assign(form, { memberId: null, productId: null, remark: '' })
  dialogVisible.value = true
}

async function handleSave() {
  await formRef.value.validate()
  saving.value = true
  try {
    await request.post('/api/consume', form)
    ElMessage.success('消费成功')
    dialogVisible.value = false
    loadData()
    loadOptions()
  } finally { saving.value = false }
}

function handleDelete(row) {
  ElMessageBox.confirm('确定删除该消费记录吗？', '提示', { type: 'warning' }).then(async () => {
    await request.delete(`/api/consume/${row.id}`)
    ElMessage.success('删除成功')
    loadData()
  }).catch(() => {})
}

onMounted(() => { loadOptions(); loadData() })
</script>