musicList.vue 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373
  1. <template>
  2. <div class="table-box">
  3. <div class="card table-search">
  4. <el-form ref="elSearchFormRef" :inline="true" size="small" :model="searchForm" class="demo-form-inline" @keyup.enter="onSubmit">
  5. <el-form-item label="歌曲名称">
  6. <el-input v-model="searchForm.title" placeholder="歌曲名称" style="width:150px"></el-input>
  7. </el-form-item>
  8. <el-form-item label="歌手">
  9. <el-input v-model="searchForm.artist" placeholder="歌手" style="width:120px"></el-input>
  10. </el-form-item>
  11. <el-form-item label="歌单">
  12. <el-select v-model="searchForm.groupId" placeholder="选择歌单" clearable style="width:150px">
  13. <el-option v-for="g in groupOptions" :key="g.id" :label="g.name" :value="g.id" />
  14. </el-select>
  15. </el-form-item>
  16. <el-form-item label="状态">
  17. <el-select v-model="searchForm.status" placeholder="状态" clearable style="width:100px">
  18. <el-option label="启用" :value="1" />
  19. <el-option label="禁用" :value="0" />
  20. </el-select>
  21. </el-form-item>
  22. <div class="operation">
  23. <el-button type="primary" icon="search" @click="onSubmit">查询</el-button>
  24. <el-button icon="refresh" @click="onResetSearch">重置</el-button>
  25. </div>
  26. </el-form>
  27. </div>
  28. <div class="card table-main">
  29. <div class="table-header">
  30. <div class="header-button-lf">
  31. <el-button type="primary" icon="Plus" @click="openDialog()">新增歌曲</el-button>
  32. </div>
  33. <div class="header-button-ri">
  34. <el-button :icon="Refresh" circle @click="refresh" />
  35. </div>
  36. </div>
  37. <el-table ref="myTable" :data="tableData" border size="small">
  38. <el-table-column prop="id" label="ID" align="center" width="80" />
  39. <el-table-column prop="title" label="歌曲名称" align="center" min-width="150" />
  40. <el-table-column prop="artist" label="歌手" align="center" width="120" />
  41. <el-table-column label="所属歌单" align="center" width="120">
  42. <template #default="{ row }">
  43. {{ getGroupName(row.groupId) }}
  44. </template>
  45. </el-table-column>
  46. <el-table-column label="试听" align="center" width="80">
  47. <template #default="{ row }">
  48. <el-button v-if="row.url" type="primary" link size="small" @click="playAudio(row.url)">
  49. <el-icon><VideoPlay /></el-icon>
  50. </el-button>
  51. <span v-else>-</span>
  52. </template>
  53. </el-table-column>
  54. <el-table-column prop="duration" label="时长(秒)" align="center" width="80" />
  55. <el-table-column prop="sort" label="排序" align="center" width="70" />
  56. <el-table-column prop="status" label="状态" align="center" width="80">
  57. <template #default="{ row }">
  58. <el-tag :type="row.status === 1 ? 'success' : 'info'">
  59. {{ row.status === 1 ? '启用' : '禁用' }}
  60. </el-tag>
  61. </template>
  62. </el-table-column>
  63. <el-table-column prop="createdAt" label="创建时间" align="center" min-width="160">
  64. <template #default="{ row }">
  65. <span v-if="row.createdAt">{{ formatUnix(row.createdAt) }}</span>
  66. </template>
  67. </el-table-column>
  68. <el-table-column fixed="right" label="操作" align="center" width="150">
  69. <template #default="scope">
  70. <el-button type="primary" link @click="openDialog(scope.row)">编辑</el-button>
  71. <el-button type="danger" link @click="handleDelete(scope.row)">删除</el-button>
  72. </template>
  73. </el-table-column>
  74. </el-table>
  75. <Pagination :pageable="pageable" @handleCurrent="handleCurrent" />
  76. </div>
  77. </div>
  78. <!-- 编辑弹窗 -->
  79. <el-dialog v-model="dialogVisible" :title="isEdit ? '编辑歌曲' : '新增歌曲'" width="600px" center destroy-on-close>
  80. <el-form ref="formRef" :model="formData" :rules="formRules" label-width="100px">
  81. <el-form-item label="所属歌单" prop="groupId">
  82. <el-select v-model="formData.groupId" placeholder="请选择歌单" style="width: 100%">
  83. <el-option v-for="g in groupOptions" :key="g.id" :label="g.name" :value="g.id" />
  84. </el-select>
  85. </el-form-item>
  86. <el-form-item label="歌曲名称" prop="title">
  87. <el-input v-model="formData.title" placeholder="请输入歌曲名称" />
  88. </el-form-item>
  89. <el-form-item label="歌手" prop="artist">
  90. <el-input v-model="formData.artist" placeholder="请输入歌手名称" />
  91. </el-form-item>
  92. <el-form-item label="音频文件" prop="url">
  93. <div class="upload-audio-wrapper">
  94. <div v-if="formData.url" class="audio-preview">
  95. <audio :src="audioPreviewUrl || formData.url" controls style="width: 100%"></audio>
  96. <div class="audio-actions">
  97. <el-button type="primary" size="small" @click="triggerAudioUpload">重新上传</el-button>
  98. <el-button type="danger" size="small" @click="clearAudio">删除</el-button>
  99. </div>
  100. </div>
  101. <el-upload
  102. v-else
  103. ref="audioUploadRef"
  104. class="audio-uploader"
  105. drag
  106. action="#"
  107. :auto-upload="false"
  108. :on-change="handleAudioChange"
  109. :show-file-list="false"
  110. accept=".mp3"
  111. >
  112. <el-icon class="el-icon--upload"><UploadFilled /></el-icon>
  113. <div class="el-upload__text">拖拽 MP3 文件到此处 或 <em>点击上传</em></div>
  114. </el-upload>
  115. <el-upload
  116. v-show="false"
  117. ref="audioReuploadRef"
  118. action="#"
  119. :auto-upload="false"
  120. :on-change="handleAudioChange"
  121. :show-file-list="false"
  122. accept=".mp3"
  123. />
  124. <div v-if="audioUploading" class="upload-progress">
  125. <el-progress :percentage="audioUploadProgress" :status="audioUploadProgress === 100 ? 'success' : undefined" />
  126. </div>
  127. </div>
  128. </el-form-item>
  129. <el-form-item label="排序" prop="sort">
  130. <el-input-number v-model="formData.sort" :min="0" style="width: 100%" />
  131. </el-form-item>
  132. <el-form-item label="状态" prop="status">
  133. <el-radio-group v-model="formData.status">
  134. <el-radio :value="1">启用</el-radio>
  135. <el-radio :value="0">禁用</el-radio>
  136. </el-radio-group>
  137. </el-form-item>
  138. </el-form>
  139. <template #footer>
  140. <el-button @click="dialogVisible = false">取消</el-button>
  141. <el-button type="primary" :loading="submitLoading" @click="handleSubmit">确定</el-button>
  142. </template>
  143. </el-dialog>
  144. <!-- 试听弹窗 -->
  145. <el-dialog v-model="playerVisible" title="试听" width="400px" center destroy-on-close>
  146. <audio :src="playerUrl" controls autoplay style="width: 100%"></audio>
  147. </el-dialog>
  148. </template>
  149. <script setup>
  150. import { ref, reactive, onMounted } from "vue";
  151. import dayjs from "dayjs";
  152. import { Refresh, UploadFilled, VideoPlay } from "@element-plus/icons-vue";
  153. import { ElNotification, ElMessageBox } from "element-plus";
  154. import Pagination from "@/components/Pangination/Pagination.vue";
  155. import { getMusicList, createMusic, updateMusic, deleteMusic, getMusicGroupList } from "@/api/modules/daytask.js";
  156. import { uploadImg } from "@/api/modules/upload.js";
  157. const formatUnix = (ts) => ts ? dayjs.unix(ts).format("YYYY-MM-DD HH:mm:ss") : "";
  158. // 歌单选项
  159. const groupOptions = ref([]);
  160. const loadGroupOptions = async () => {
  161. const res = await getMusicGroupList({ pageSize: 100 });
  162. if (res.data) groupOptions.value = res.data.list || [];
  163. };
  164. const getGroupName = (id) => {
  165. const g = groupOptions.value.find(g => g.id === id);
  166. return g ? g.name : "-";
  167. };
  168. // 试听
  169. const playerVisible = ref(false);
  170. const playerUrl = ref("");
  171. const playAudio = (url) => {
  172. playerUrl.value = url;
  173. playerVisible.value = true;
  174. };
  175. // 搜索
  176. const searchForm = reactive({ title: "", artist: "", groupId: null, status: null });
  177. const tableData = ref([]);
  178. const pageable = reactive({ current: 1, pageSize: 20, total: 0 });
  179. const getList = async () => {
  180. const params = { current: pageable.current, pageSize: pageable.pageSize, ...searchForm };
  181. Object.keys(params).forEach(k => { if (params[k] === "" || params[k] === null) delete params[k]; });
  182. const res = await getMusicList(params);
  183. if (res.data) {
  184. tableData.value = res.data.list || [];
  185. pageable.total = res.data.paging?.total || 0;
  186. }
  187. };
  188. const onSubmit = () => { pageable.current = 1; getList(); };
  189. const onResetSearch = () => { searchForm.title = ""; searchForm.artist = ""; searchForm.groupId = null; searchForm.status = null; onSubmit(); };
  190. const handleCurrent = (val) => { pageable.current = val; getList(); };
  191. const refresh = () => getList();
  192. // 弹窗
  193. const dialogVisible = ref(false);
  194. const isEdit = ref(false);
  195. const formRef = ref(null);
  196. const submitLoading = ref(false);
  197. const formData = reactive({ id: null, groupId: null, title: "", artist: "", url: "", duration: 0, sort: 0, status: 1 });
  198. const formRules = {
  199. groupId: [{ required: true, message: "请选择歌单", trigger: "change" }],
  200. title: [{ required: true, message: "请输入歌曲名称", trigger: "blur" }],
  201. url: [{ required: true, message: "请上传音频文件", trigger: "change" }],
  202. };
  203. // 音频上传
  204. const audioUploadRef = ref(null);
  205. const audioReuploadRef = ref(null);
  206. const audioPreviewUrl = ref("");
  207. const audioUploading = ref(false);
  208. const audioUploadProgress = ref(0);
  209. const handleAudioChange = async (file) => {
  210. const rawFile = file.raw;
  211. audioPreviewUrl.value = URL.createObjectURL(rawFile);
  212. // 自动获取音频时长
  213. const audio = new Audio(audioPreviewUrl.value);
  214. audio.addEventListener("loadedmetadata", () => {
  215. formData.duration = Math.round(audio.duration);
  216. });
  217. // 自动填充歌曲名称(如果为空)
  218. if (!formData.title) {
  219. formData.title = rawFile.name.replace(/\.[^/.]+$/, "");
  220. }
  221. // 上传
  222. audioUploading.value = true;
  223. audioUploadProgress.value = 0;
  224. try {
  225. const fd = new FormData();
  226. fd.append("file", rawFile);
  227. fd.append("autoSave", "false");
  228. const progressInterval = setInterval(() => {
  229. if (audioUploadProgress.value < 90) audioUploadProgress.value += 10;
  230. }, 100);
  231. const res = await uploadImg(fd);
  232. clearInterval(progressInterval);
  233. if (res.code === 200) {
  234. audioUploadProgress.value = 100;
  235. formData.url = res.data.path;
  236. if (formRef.value) formRef.value.clearValidate("url");
  237. ElNotification.success("音频上传成功");
  238. } else {
  239. ElNotification.error(res.msg || "音频上传失败");
  240. clearAudio();
  241. }
  242. } catch (e) {
  243. ElNotification.error("音频上传失败");
  244. clearAudio();
  245. } finally {
  246. audioUploading.value = false;
  247. }
  248. };
  249. const triggerAudioUpload = () => {
  250. audioReuploadRef.value?.$el.querySelector("input")?.click();
  251. };
  252. const clearAudio = () => {
  253. formData.url = "";
  254. formData.duration = 0;
  255. audioPreviewUrl.value = "";
  256. };
  257. const openDialog = (row) => {
  258. isEdit.value = !!row;
  259. audioPreviewUrl.value = "";
  260. if (row) {
  261. Object.assign(formData, {
  262. id: row.id,
  263. groupId: row.groupId,
  264. title: row.title,
  265. artist: row.artist || "",
  266. url: row.url,
  267. duration: row.duration || 0,
  268. sort: row.sort || 0,
  269. status: row.status,
  270. });
  271. } else {
  272. Object.assign(formData, { id: null, groupId: null, title: "", artist: "", url: "", duration: 0, sort: 0, status: 1 });
  273. }
  274. dialogVisible.value = true;
  275. };
  276. const handleSubmit = async () => {
  277. await formRef.value?.validate();
  278. submitLoading.value = true;
  279. try {
  280. // 后端期望格式: { id, data: { ...fields } }
  281. const { id, ...fields } = formData;
  282. if (isEdit.value) {
  283. await updateMusic({ id, data: fields });
  284. } else {
  285. await createMusic({ data: fields });
  286. }
  287. ElNotification.success({ title: "成功", message: isEdit.value ? "编辑成功" : "新增成功" });
  288. dialogVisible.value = false;
  289. getList();
  290. } catch (e) {
  291. ElNotification.error({ title: "错误", message: e.message || "操作失败" });
  292. } finally {
  293. submitLoading.value = false;
  294. }
  295. };
  296. const handleDelete = (row) => {
  297. ElMessageBox.confirm("确定删除该歌曲吗?", "提示", { type: "warning" }).then(async () => {
  298. await deleteMusic({ id: row.id });
  299. ElNotification.success({ title: "成功", message: "删除成功" });
  300. getList();
  301. }).catch(() => {});
  302. };
  303. onMounted(() => { loadGroupOptions(); getList(); });
  304. </script>
  305. <style scoped>
  306. .upload-audio-wrapper {
  307. width: 100%;
  308. }
  309. .audio-uploader {
  310. width: 100%;
  311. }
  312. .audio-uploader :deep(.el-upload) {
  313. width: 100%;
  314. }
  315. .audio-uploader :deep(.el-upload-dragger) {
  316. width: 100%;
  317. height: auto;
  318. min-height: 120px;
  319. display: flex;
  320. flex-direction: column;
  321. justify-content: center;
  322. align-items: center;
  323. padding: 15px;
  324. }
  325. .audio-preview {
  326. display: flex;
  327. flex-direction: column;
  328. gap: 10px;
  329. width: 100%;
  330. }
  331. .audio-actions {
  332. display: flex;
  333. gap: 10px;
  334. }
  335. .upload-progress {
  336. margin-top: 10px;
  337. width: 100%;
  338. }
  339. </style>