game_event_admin/src/views/system/gameAthlete/index.vue

<template>
  <div class="p-2">
    <transition :enter-active-class="proxy?.animate.searchAnimate.enter" :leave-active-class="proxy?.animate.searchAnimate.leave">
      <div v-show="showSearch" class="mb-[10px]">
        <el-card shadow="hover">
          <el-form ref="queryFormRef" :model="queryParams" :inline="true">
            <el-form-item label="队伍名称" prop="teamName">
              <el-input v-model="queryParams.teamName" placeholder="请输入队伍名称" clearable @keyup.enter="handleQuery" />
            </el-form-item>
            <el-form-item label="号码" prop="athleteCode">
              <el-input v-model="queryParams.athleteCode" placeholder="请输入运动员号码" clearable @keyup.enter="handleQuery" />
            </el-form-item>
            <el-form-item label="姓名" prop="name">
              <el-input v-model="queryParams.name" placeholder="请输入姓名" clearable @keyup.enter="handleQuery" />
            </el-form-item>
            <el-form-item label="手机号" prop="phone">
              <el-input v-model="queryParams.phone" placeholder="请输入手机号" clearable @keyup.enter="handleQuery" />
            </el-form-item>
            <el-form-item label="居住地址" prop="location">
              <el-input v-model="queryParams.location" placeholder="请输入居住地址" clearable @keyup.enter="handleQuery" />
            </el-form-item>
            <el-form-item>
              <el-button type="primary" icon="Search" @click="handleQuery">搜索</el-button>
              <el-button icon="Refresh" @click="resetQuery">重置</el-button>
            </el-form-item>
          </el-form>
        </el-card>
      </div>
    </transition>

    <el-card shadow="never">
      <template #header>
        <el-row :gutter="10" class="mb8">
          <el-col :span="1.5">
            <el-button type="primary" plain icon="Plus" @click="handleAdd" v-hasPermi="['system:gameAthlete:add']"> 新增 </el-button>
          </el-col>
          <el-col :span="1.5">
            <el-button type="success" plain icon="Edit" :disabled="single" @click="handleUpdate()" v-hasPermi="['system:gameAthlete:edit']"
              >修改
            </el-button>
          </el-col>
          <el-col :span="1.5">
            <el-button type="danger" plain icon="Delete" :disabled="multiple" @click="handleDelete()" v-hasPermi="['system:gameAthlete:remove']"
              >删除
            </el-button>
          </el-col>
          <!-- <el-col :span="1.5">
            <el-button type="warning" plain icon="Download" @click="handleExport" v-hasPermi="['system:gameAthlete:export']">导出 </el-button>
          </el-col> -->
          <el-col :span="1.5">
            <el-button type="info" plain icon="Upload" @click="handleImport" v-hasPermi="['system:gameAthlete:import']"> 导入 </el-button>
          </el-col>
          <right-toolbar v-model:showSearch="showSearch" :columns="columns" @queryTable="getList"></right-toolbar>
        </el-row>
      </template>

      <el-table v-loading="loading" border :data="gameAthleteList" @selection-change="handleSelectionChange">
        <el-table-column type="selection" width="55" align="center" />
        <el-table-column label="运动员id" align="center" prop="athleteId" v-if="columns[0].visible" />
        <el-table-column label="赛事名称" align="center" prop="eventName" width="120px" v-if="columns[1].visible" />
        <el-table-column label="号码" align="center" prop="athleteCode" width="100px" v-if="columns[2].visible" />
        <el-table-column label="姓名" align="center" prop="name" v-if="columns[3].visible" />
        <el-table-column label="性别" align="center" prop="gender" v-if="columns[4].visible">
          <template #default="scope">
            <dict-tag :options="sys_user_sex" :value="scope.row.gender" />
          </template>
        </el-table-column>
        <el-table-column label="年龄" align="center" prop="age" v-if="columns[5].visible" />
        <el-table-column label="参与项目" align="center" prop="projectList" width="200px" v-if="columns[6].visible">
          <template #default="scope">
            {{ formatProjectList(scope.row.projectList) }}
          </template>
        </el-table-column>
        <el-table-column label="证件号" align="center" prop="idCard" v-if="columns[7].visible" />
        <el-table-column label="队伍" align="center" prop="teamId" v-if="columns[8].visible">
          <template #default="scope">
            {{ getTeamNameById(scope.row.teamId) }}
          </template>
        </el-table-column>
        <!-- <el-table-column label="芯片号" align="center" prop="chipCode" v-if="columns[9].visible" /> -->
        <!-- <el-table-column label="手机号" align="center" prop="phone" v-if="columns[10].visible" /> -->
        <!-- <el-table-column label="居住地址" align="center" prop="location" v-if="columns[11].visible" /> -->
        <!-- <el-table-column label="T恤尺码" align="center" prop="tshirtSize" v-if="columns[12].visible" /> -->
        <!-- <el-table-column label="组别" align="center" prop="groupType" v-if="columns[13].visible" /> -->
        <!-- <el-table-column label="号码" align="center" prop="number" v-if="columns[14].visible" /> -->
        <el-table-column label="状态" align="center" prop="status" v-if="columns[9].visible" />
        <el-table-column label="备注" align="center" prop="remark" v-if="columns[10].visible" />
        <el-table-column label="操作" align="center" class-name="small-padding fixed-width" fixed="right">
          <template #default="scope">
            <el-tooltip content="修改" placement="top">
              <el-button link type="primary" icon="Edit" @click="handleUpdate(scope.row)" v-hasPermi="['system:gameAthlete:edit']"></el-button>
            </el-tooltip>
            <el-tooltip content="删除" placement="top">
              <el-button link type="primary" icon="Delete" @click="handleDelete(scope.row)" v-hasPermi="['system:gameAthlete:remove']"></el-button>
            </el-tooltip>
          </template>
        </el-table-column>
      </el-table>

      <pagination v-show="total > 0" :total="total" v-model:page="queryParams.pageNum" v-model:limit="queryParams.pageSize" @pagination="getList" />
    </el-card>
    <!-- 添加或修改参赛队员对话框 -->
    <el-dialog :title="dialog.title" v-model="dialog.visible" width="800px" append-to-body>
      <el-form ref="gameAthleteFormRef" :model="form" :rules="rules" label-width="80px">
        <el-form-item label="队伍" prop="teamId">
          <el-select v-model="form.teamId" placeholder="请选择队伍">
            <el-option v-for="team in gameTeamList" :key="team.teamId" :label="team.teamName" :value="team.teamId" />
          </el-select>
        </el-form-item>
        <el-form-item label="号码" prop="athleteCode">
          <el-input v-model="form.athleteCode" placeholder="请输入运动员编号" />
        </el-form-item>
        <el-form-item label="姓名" prop="name">
          <el-input v-model="form.name" placeholder="请输入姓名" />
        </el-form-item>
        <el-form-item label="性别" prop="gender">
          <el-radio-group v-model="form.gender">
            <el-radio v-for="dict in sys_user_sex" :key="dict.value" :value="dict.value">{{ dict.label }}</el-radio>
          </el-radio-group>
        </el-form-item>
        <el-form-item label="年龄" prop="age">
          <el-input v-model="form.age" placeholder="请输入年龄" />
        </el-form-item>
        <el-form-item label="参与项目" prop="projectList">
          <el-transfer
            v-model="projectListStr"
            :data="gameEventProjectList"
            :titles="['可选项目', '已选项目']"
            :button-texts="['移除', '添加']"
            filterable
            style="width: 100%"
          />
        </el-form-item>
        <el-form-item label="备注" prop="remark">
          <el-input v-model="form.remark" type="textarea" placeholder="请输入内容" />
        </el-form-item>
      </el-form>
      <template #footer>
        <div class="dialog-footer">
          <el-button :loading="buttonLoading" type="primary" @click="submitForm">确 定</el-button>
          <el-button @click="cancel">取 消</el-button>
        </div>
      </template>
    </el-dialog>
    <!-- 用户导入对话框 -->
    <el-dialog v-model="upload.open" :title="upload.title" width="400px" append-to-body>
      <el-upload
        ref="uploadRef"
        :limit="1"
        accept=".xlsx, .xls"
        :headers="upload.headers"
        :action="upload.url + '?updateSupport=' + upload.updateSupport"
        :disabled="upload.isUploading"
        :on-progress="handleFileUploadProgress"
        :on-success="handleFileSuccess"
        :auto-upload="false"
        drag
      >
        <el-icon class="el-icon--upload">
          <i-ep-upload-filled />
        </el-icon>
        <div class="el-upload__text">将文件拖到此处，或<em>点击上传</em></div>
        <template #tip>
          <div class="text-center el-upload__tip">
            <!--            <div class="el-upload__tip">-->
            <!--              <el-checkbox v-model="upload.updateSupport" />-->
            <!--              是否更新已经存在的用户数据-->
            <!--            </div>-->
            <span>仅允许导入xls、xlsx格式文件。</span>
            <el-link type="primary" :underline="false" style="font-size: 12px; vertical-align: baseline" @click="importTemplate">下载模板 </el-link>
          </div>
        </template>
      </el-upload>
      <template #footer>
        <div class="dialog-footer">
          <el-button type="primary" @click="submitFileForm">确 定</el-button>
          <el-button @click="upload.open = false">取 消</el-button>
        </div>
      </template>
    </el-dialog>
  </div>
</template>

<script setup name="GameAthlete" lang="ts">
import { nextTick, ref, onMounted } from 'vue';
import { listGameAthlete, getGameAthlete, delGameAthlete, addGameAthlete, updateGameAthlete } from '@/api/system/gameAthlete';
import { listGameTeam, updateTeamAthletes } from '@/api/system/gameTeam';
import { listGameEventProject } from '@/api/system/gameEventProject';
// import { getDefaultEvent } from '@/api/system/gameEvent';
import { GameAthleteVO, GameAthleteQuery, GameAthleteForm } from '@/api/system/gameAthlete/types';
import { GameTeamVO } from '@/api/system/gameTeam/types';
import { GameEventVO } from '@/api/system/gameEvent/types';
import { globalHeaders } from '@/utils/request';

const { proxy } = getCurrentInstance() as ComponentInternalInstance;
const { sys_user_sex } = toRefs<any>(proxy?.useDict('sys_user_sex'));
const defaultEvent = ref<GameEventVO | null>(null); // 默认赛事信息

const gameTeamList = ref<GameTeamVO[]>([]); // 队伍列表
const gameAthleteList = ref<GameAthleteVO[]>([]);
const gameEventProjectList = ref<Array<{ key: string; label: string }>>([]); // 赛事项目列表（用于穿梭框）
const buttonLoading = ref(false);
const loading = ref(true);
const showSearch = ref(true);
const ids = ref<Array<string | number>>([]);
const single = ref(true);
const multiple = ref(true);
const total = ref(0);

// 列显隐数据
const columns = ref<FieldOption[]>([
  { key: 0, label: '运动员id', visible: false },
  { key: 1, label: '赛事名称', visible: false },
  { key: 2, label: '号码', visible: true },
  { key: 3, label: '姓名', visible: true },
  { key: 4, label: '性别', visible: true },
  { key: 5, label: '年龄', visible: true },
  { key: 6, label: '参与项目', visible: true },
  { key: 7, label: '证件号', visible: true },
  { key: 8, label: '队伍', visible: true },
  // { key: 9, label: '芯片号', visible: true },
  // { key: 10, label: '手机号', visible: true },
  // { key: 11, label: '居住地址', visible: true },
  // { key: 12, label: 'T恤尺码', visible: true },
  // { key: 13, label: '组别', visible: true },
  // { key: 14, label: '号码', visible: true },
  { key: 9, label: '状态', visible: true },
  { key: 10, label: '备注', visible: true },
]);

const queryFormRef = ref<ElFormInstance>();
const gameAthleteFormRef = ref<ElFormInstance>();
const uploadRef = ref<ElUploadInstance>();

const dialog = reactive<DialogOption>({
  visible: false,
  title: ''
});

/*** 用户导入参数 */
const upload = reactive<ImportOption>({
  // 是否显示弹出层（用户导入）
  open: false,
  // 弹出层标题（用户导入）
  title: '',
  // 是否禁用上传
  isUploading: false,
  // 是否更新已经存在的用户数据
  updateSupport: 0,
  // 设置上传的请求头部
  headers: globalHeaders(),
  // 上传的地址
  url: import.meta.env.VITE_APP_BASE_API + '/system/gameAthlete/import'
});

const initFormData: GameAthleteForm = {
  athleteId: undefined,
  userId: undefined,
  eventId: undefined,
  teamId: undefined,
  athleteCode: undefined,
  name: undefined,
  gender: undefined,
  age: undefined,
  idCard: undefined,
  chipCode: undefined,
  phone: undefined,
  location: undefined,
  tshirtSize: undefined,
  groupType: undefined,
  projectValue: undefined,
  projectList: [],
  selectedProjects: [], // 添加已选项目列表
  status: undefined,
  remark: undefined
};
const data = reactive<PageData<GameAthleteForm, GameAthleteQuery>>({
  form: { ...initFormData},
  queryParams: {
    pageNum: 1,
    pageSize: 10,
    eventId: undefined,
    eventName: undefined,
    teamId: undefined,
    teamName: undefined,
    athleteCode: undefined,
    name: undefined,
    groupType: undefined,
    status: undefined,
    phone: undefined,
    location: undefined,
    params: {},
    orderByColumn: '',
    isAsc: ''
  },
  rules: {
    teamId: [{ required: true, message: '队伍ID不能为空', trigger: 'blur' }],
    athleteCode: [{ required: true, message: '运动员编号不能为空', trigger: 'blur' }],
    gender: [{ required: true, message: '性别不能为空', trigger: 'blur' }],
  }
});

// 添加额外的ref用于处理默认事件ID
const defaultEventId = computed(() => defaultEvent.value?.eventId);

// 监听默认事件变化
watchEffect(() => {
  if (defaultEventId.value) {
    form.value.eventId = defaultEventId.value;
    queryParams.value.eventId = defaultEventId.value;
  }
});

const { queryParams, form, rules } = toRefs(data);

/** 获取默认赛事 */
// const getDefaultEventInfo = async () => {
//   try {
//     const res = await getDefaultEvent();
//     defaultEvent.value = res.data;
//   } catch (error) {
//     proxy?.$modal.msgError('获取默认赛事信息失败');
//   }
// };

/** 获取队伍名称 */
const getTeamNameById = (teamId: string | number | null | undefined) => {
  if (!teamId) return '';
  const team = gameTeamList.value.find((team) => team.teamId === teamId);
  return team ? team.teamName : '';
};

// 获取赛事项目列表
const getProjectList = async (eventId?: string) => {
  const res = await listGameEventProject({
    pageNum: 1,
    pageSize: 1000,
    orderByColumn: '',
    isAsc: ''
  });
  console.log(res);
  gameEventProjectList.value = res.rows.map((item) => ({
    key: String(item.projectId),
    label: `${item.projectName}`
  }));
};

// 格式化项目列表显示
const formatProjectList = (projectList: number[]) => {
  if (!projectList) return '';
  // 将逗号分隔的ID列表转换为项目名称列表
  // const projectIds = projectValue.split(',');
  // const projectNames = projectIds.map((id) => {
  //   const project = gameEventProjectList.value.find((p) => p.key === id);
  //   return project ? project.label : id;
  // });
  const projectNames = gameEventProjectList.value.filter((p) => projectList.includes(Number(p.key))).map((p) => p.label);
  return projectNames.join(',');
};

/** 查询参赛队员列表 */
const getList = async () => {
  loading.value = true;
  const res = await listGameAthlete(queryParams.value);
  gameAthleteList.value = res.rows;
  total.value = res.total;
  loading.value = false;
};

// 获取队伍列表
const getTeamList = async () => {
  const res = await listGameTeam({
    pageNum: 1,
    pageSize: 1000,
    orderByColumn: '',
    isAsc: ''
  });
  gameTeamList.value = res.rows || [];
};

/** 取消按钮 */
const cancel = () => {
  reset();
  dialog.visible = false;
};

/** 表单重置 */
const reset = () => {
  form.value = { ...initFormData };
  gameAthleteFormRef.value?.resetFields();
};

/** 搜索按钮操作 */
const handleQuery = () => {
  queryParams.value.pageNum = 1;
  getList();
};

/** 重置按钮操作 */
const resetQuery = () => {
  queryFormRef.value?.resetFields();
  // // 保留默认赛事ID
  // queryParams.value.eventId = defaultEvent.value?.eventId;
  handleQuery();
};

/** 多选框选中数据 */
const handleSelectionChange = (selection: GameAthleteVO[]) => {
  ids.value = selection.map((item) => item.athleteId);
  single.value = selection.length != 1;
  multiple.value = !selection.length;
};

/** 新增按钮操作 */
const handleAdd = () => {
  reset();
  dialog.visible = true;
  dialog.title = '添加参赛队员';
  // 获取项目列表
  // nextTick(() => {
  //   if (form.value.eventId) {
  //     getProjectList(String(form.value.eventId));
  //   }
  // });
};

/** 修改按钮操作 */
const handleUpdate = async (row?: GameAthleteVO) => {
  reset();
  const _athleteId = row?.athleteId || ids.value[0];
  const res = await getGameAthlete(_athleteId);
  Object.assign(form.value, res.data);

  // 处理项目列表，将逗号分隔的字符串转换为数组
  if (res.data.projectList) {
    form.value.selectedProjects = res.data.projectList;
  } else if (res.data.projectValue) {
    form.value.selectedProjects = res.data.projectValue.split(',').map(Number);
  } else {
    form.value.selectedProjects = [];
  }

  dialog.visible = true;
  dialog.title = '修改参赛队员';
  // 获取项目列表
  // nextTick(() => {
  //   if (form.value.eventId) {
  //     getProjectList(String(form.value.eventId));
  //   }
  // });
};

// 添加一个计算属性用于处理projectList2的类型转换
const projectListStr = computed({
  get: () => form.value.selectedProjects.map(id => String(id)),
  set: (value) => {
    form.value.selectedProjects = value.map(id => Number(id));
  }
});

/** 提交按钮 */
const submitForm = () => {
  gameAthleteFormRef.value?.validate(async (valid: boolean) => {
    if (valid) {
      buttonLoading.value = true;
      try {
        // 处理项目列表数据，将数组转换为逗号分隔的字符串
        const submitForm = { ...form.value };
        if (submitForm.selectedProjects && submitForm.selectedProjects.length > 0) {
          submitForm.projectList = submitForm.selectedProjects;
          // submitForm.projectValue = submitForm.selectedProjects.join(',');
        } else {
          // submitForm.projectValue = '';
          submitForm.projectList = [];
        }
        // 删除selectedProjects属性，因为它不需要提交到后端
        delete submitForm.selectedProjects;

        let result;
        if (form.value.athleteId) {
          result = await updateGameAthlete(submitForm);
        } else {
          result = await addGameAthlete(submitForm);
        }

        // 更新队伍表中的运动员列表
        if (submitForm.teamId) {
          try {
            // 获取当前队伍的所有运动员
            const currentTeamAthletes = gameAthleteList.value
              .filter(athlete => athlete.teamId === submitForm.teamId)
              .map(athlete => athlete.athleteId);
            
            // 添加新运动员到列表中
            if (!form.value.athleteId) {
              // 新增运动员，需要从返回结果中获取新ID
              const newAthleteId = result.data?.athleteId || submitForm.athleteId;
              if (newAthleteId) {
                currentTeamAthletes.push(newAthleteId);
              }
            } else {
              // 更新运动员，检查是否改变了队伍
              const originalAthlete = gameAthleteList.value.find(a => a.athleteId === form.value.athleteId);
              if (originalAthlete && originalAthlete.teamId !== submitForm.teamId) {
                // 运动员改变了队伍，需要从原队伍中移除，添加到新队伍中
                
                // 从原队伍中移除运动员
                if (originalAthlete.teamId) {
                  const originalTeamAthletes = gameAthleteList.value
                    .filter(athlete => athlete.teamId === originalAthlete.teamId && athlete.athleteId !== form.value.athleteId)
                    .map(athlete => athlete.athleteId);
                  
                  await updateTeamAthletes(originalAthlete.teamId, originalTeamAthletes);
                }
                
                // 添加到新队伍中
                if (!currentTeamAthletes.includes(form.value.athleteId)) {
                  currentTeamAthletes.push(form.value.athleteId);
                }
              } else if (originalAthlete && originalAthlete.teamId === submitForm.teamId) {
                // 运动员在同一队伍中，确保在列表中
                if (!currentTeamAthletes.includes(form.value.athleteId)) {
                  currentTeamAthletes.push(form.value.athleteId);
                }
              }
            }
            
            // 更新队伍表中的运动员列表
            await updateTeamAthletes(submitForm.teamId, currentTeamAthletes);
          } catch (error) {
            console.error('更新队伍运动员列表失败:', error);
            proxy?.$modal.msgWarning('运动员信息保存成功，但更新队伍运动员列表失败');
          }
        }

        proxy?.$modal.msgSuccess('操作成功');
        dialog.visible = false;
        await getList();
      } catch (error) {
        console.error('操作失败:', error);
        proxy?.$modal.msgError('操作失败');
      } finally {
        buttonLoading.value = false;
      }
    }
  });
};

/** 删除按钮操作 */
const handleDelete = async (row?: GameAthleteVO) => {
  const _athleteIds = row?.athleteId || ids.value;
  await proxy?.$modal.confirm('是否确认删除参赛队员编号为"' + _athleteIds + '"的数据项？').finally(() => (loading.value = false));
  
  try {
    await delGameAthlete(_athleteIds);
    
    // 从队伍表中移除被删除的运动员
    const athleteIdsToRemove = Array.isArray(_athleteIds) ? _athleteIds : [_athleteIds];
    const teamsToUpdate = new Set<number | string>();
    
    // 收集需要更新的队伍ID
    athleteIdsToRemove.forEach(athleteId => {
      const athlete = gameAthleteList.value.find(a => a.athleteId === athleteId);
      if (athlete && athlete.teamId) {
        teamsToUpdate.add(athlete.teamId);
      }
    });
    
    // 更新每个相关队伍中的运动员列表
    for (const teamId of teamsToUpdate) {
      try {
        const currentTeamAthletes = gameAthleteList.value
          .filter(athlete => athlete.teamId === teamId && !athleteIdsToRemove.includes(athlete.athleteId))
          .map(athlete => athlete.athleteId);
        
        await updateTeamAthletes(teamId, currentTeamAthletes);
      } catch (error) {
        console.error(`更新队伍 ${teamId} 运动员列表失败:`, error);
        proxy?.$modal.msgWarning(`运动员删除成功，但更新队伍 ${teamId} 运动员列表失败`);
      }
    }
    
    proxy?.$modal.msgSuccess('删除成功');
    await getList();
  } catch (error) {
    console.error('删除失败:', error);
    proxy?.$modal.msgError('删除失败');
  }
};

/** 导出按钮操作 */
const handleExport = () => {
  proxy?.download(
    'system/gameAthlete/export',
    {
      ...queryParams.value
    },
    `gameAthlete_${new Date().getTime()}.xlsx`
  );
};

/** 导入按钮操作 */
const handleImport = () => {
  upload.title = '参赛队员导入';
  upload.open = true;
};

/**文件上传中处理 */
const handleFileUploadProgress = () => {
  upload.isUploading = true;
};

/** 文件上传成功处理 */
const handleFileSuccess = (response: any, file: UploadFile) => {
  upload.open = false;
  upload.isUploading = false;
  uploadRef.value?.handleRemove(file);
  ElMessageBox.alert("<div style='overflow: auto;overflow-x: hidden;max-height: 70vh;padding: 10px 20px 0;'>" + response.msg + '</div>', '导入结果', {
    dangerouslyUseHTMLString: true
  });
  getList();
};

/** 提交上传文件 */
function submitFileForm() {
  uploadRef.value?.submit();
}

/** 下载模板操作 */
const importTemplate = () => {
  proxy?.download('system/gameAthlete/importTemplate', {}, `game_athlete_template_${new Date().getTime()}.xlsx`);
};

onMounted(() => {
  getList();
  getTeamList();
  getProjectList();
});
</script>