tableList.vue 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533
  1. <template>
  2. <div class="tableList">
  3. <save-form
  4. :inline="true"
  5. class="searchForm"
  6. @submit="onSearch"
  7. @reset="onReSet"
  8. ref="searchForm"
  9. :model.sync="searchForm"
  10. >
  11. <el-form-item prop="search">
  12. <el-input
  13. clearable
  14. placeholder="学生姓名/编号"
  15. @keyup.enter.native="onSearch"
  16. v-model.trim="searchForm.search"
  17. ></el-input>
  18. </el-form-item>
  19. <el-form-item prop="organId">
  20. <el-select
  21. class="multiple"
  22. filterable
  23. v-model.trim="searchForm.organId"
  24. multiple
  25. collapse-tags
  26. clearable
  27. placeholder="请选择分部"
  28. >
  29. <el-option
  30. v-for="(item, index) in selects.branchs"
  31. :key="index"
  32. :label="item.name"
  33. :value="item.id"
  34. ></el-option>
  35. </el-select>
  36. </el-form-item>
  37. <el-form-item prop="studentStatus">
  38. <el-select
  39. class="multiple"
  40. filterable
  41. v-model.trim="searchForm.studentStatus"
  42. clearable
  43. placeholder="请选择学员状态"
  44. >
  45. <el-option label="在读" value="NORMAL"></el-option>
  46. <el-option label="沉睡" value="SLEEPY"></el-option>
  47. <el-option label="流失" value="LOST"></el-option>
  48. </el-select>
  49. </el-form-item>
  50. <el-form-item prop="feedbackType">
  51. <el-select
  52. class="multiple"
  53. filterable
  54. v-model.trim="searchForm.feedbackType"
  55. clearable
  56. placeholder="请选择回访状态"
  57. >
  58. <el-option
  59. :label="item.label"
  60. :value="item.value"
  61. v-for="(item, index) in feedbackTypeList"
  62. :key="index"
  63. ></el-option>
  64. </el-select>
  65. </el-form-item>
  66. <el-form-item prop="latelyCourseConsumer">
  67. <el-input
  68. clearable
  69. placeholder="近30天课耗"
  70. v-model.trim="searchForm.latelyCourseConsumer"
  71. ></el-input>
  72. </el-form-item>
  73. <el-form-item prop="visitNum">
  74. <el-input
  75. clearable
  76. placeholder="回访次数"
  77. v-model.trim="searchForm.visitNum"
  78. ></el-input>
  79. </el-form-item>
  80. <el-form-item prop="teacherId">
  81. <remote-search :commit="'setTeachers'" v-model="searchForm.teacherId" />
  82. </el-form-item>
  83. <el-form-item prop="musicDirectorId">
  84. <remote-search
  85. :commit="'setEducations'"
  86. v-model="searchForm.musicDirectorId"
  87. />
  88. </el-form-item>
  89. <el-form-item prop="courseConsumerError">
  90. <el-select
  91. class="multiple"
  92. filterable
  93. v-model.trim="searchForm.courseConsumerError"
  94. clearable
  95. placeholder="请选择课耗是否异常"
  96. >
  97. <el-option label="是" :value="true"></el-option>
  98. <el-option label="否" :value="false"></el-option>
  99. </el-select>
  100. </el-form-item>
  101. <el-form-item prop="timer">
  102. <el-date-picker
  103. v-model.trim="searchForm.timer"
  104. type="daterange"
  105. value-format="yyyy-MM-dd"
  106. range-separator="-"
  107. start-placeholder="第一次课开始时间"
  108. end-placeholder="第一次课结束时间"
  109. :picker-options="{
  110. firstDayOfWeek: 1,
  111. }"
  112. ></el-date-picker>
  113. </el-form-item>
  114. <el-form-item>
  115. <el-button native-type="submit" type="danger">搜索</el-button>
  116. <el-button native-type="reset" type="primary">重置</el-button>
  117. <el-button
  118. type="primary"
  119. v-if="tableList.length > 0"
  120. v-permission="
  121. 'studentStatistics/exportStudentSmallClassStatisticsSum'
  122. "
  123. @click="smallStudentExport"
  124. >导出</el-button
  125. >
  126. </el-form-item>
  127. </save-form>
  128. <div class="tableWrap">
  129. <el-table
  130. :data="tableList"
  131. :header-cell-style="{ background: '#EDEEF0', color: '#444' }"
  132. >
  133. <el-table-column type="expand">
  134. <template slot-scope="props">
  135. <el-form
  136. label-position="left"
  137. class="demo-table-expand"
  138. :inline="true"
  139. >
  140. <el-row>
  141. <el-col :span="6">
  142. <el-form-item label="指导老师信息">
  143. <div
  144. class="schoolWrap"
  145. style="color: var(--color-primary); cursor: pointer"
  146. v-if="props.row.teacherId"
  147. @click="gototeacher(props.row.teacherId)"
  148. >
  149. <span>{{ props.row.teacherName }}</span>
  150. <span>({{ props.row.teacherId }})</span>
  151. </div>
  152. </el-form-item></el-col
  153. >
  154. <el-col :span="6">
  155. <el-form-item label="乐团主管">
  156. <div class="schoolWrap" v-if="props.row.musicDirectorId">
  157. <span>{{ props.row.musicDirectorName }}</span>
  158. <span>({{ props.row.musicDirectorId }})</span>
  159. </div>
  160. </el-form-item></el-col
  161. >
  162. <el-col :span="6">
  163. <el-form-item label="声部课老师">
  164. <div class="schoolWrap">
  165. <overflow-text
  166. width="100%"
  167. :text="props.row.studentBasicInfo.subjectTeacherName"
  168. ></overflow-text>
  169. </div> </el-form-item
  170. ></el-col>
  171. <el-col :span="6">
  172. <el-form-item label="年级">
  173. <div class="schoolWrap">
  174. <overflow-text
  175. width="100%"
  176. :text="props.row.studentBasicInfo.grade"
  177. ></overflow-text>
  178. </div> </el-form-item
  179. ></el-col>
  180. </el-row>
  181. <el-row>
  182. <el-col :span="6">
  183. <el-form-item label="近30天课耗">
  184. <div class="schoolWrap">
  185. <span>{{ props.row.latelyCourseConsumer }}</span>
  186. </div>
  187. </el-form-item></el-col
  188. >
  189. <el-col :span="6">
  190. <el-form-item label="回访次数">
  191. <div class="schoolWrap">
  192. <span>{{ props.row.visitNum }}</span>
  193. </div>
  194. </el-form-item></el-col
  195. >
  196. <el-col :span="6">
  197. <el-form-item label="回访状态">
  198. <div class="schoolWrap">
  199. {{ props.row.lastVisitStatus | feedbackTypeFilter }}
  200. </div>
  201. </el-form-item></el-col
  202. >
  203. <el-col :span="6">
  204. <el-form-item label="回访日期">
  205. <div class="schoolWrap" v-if="props.row.lastVisitTime">
  206. {{ props.row.lastVisitTime | dayjsFormat }}
  207. </div>
  208. </el-form-item></el-col
  209. >
  210. </el-row>
  211. <el-row>
  212. <el-col :span="6">
  213. <el-form-item label="第一次课时间">
  214. <div class="schoolWrap">
  215. <overflow-text
  216. width="100%"
  217. :text="props.row.firstCourseTime"
  218. ></overflow-text>
  219. </div> </el-form-item
  220. ></el-col>
  221. <el-col :span="6">
  222. <el-form-item label="最近上课时间">
  223. <div class="schoolWrap">
  224. <overflow-text
  225. width="100%"
  226. :text="props.row.lastCourseTime"
  227. ></overflow-text>
  228. </div> </el-form-item
  229. ></el-col>
  230. <el-col :span="6">
  231. <el-form-item label="原因">
  232. <div class="schoolWrap">
  233. <overflow-text
  234. width="100%"
  235. :text="props.row.visitReason"
  236. ></overflow-text>
  237. </div> </el-form-item
  238. ></el-col>
  239. </el-row>
  240. </el-form>
  241. </template>
  242. </el-table-column>
  243. <el-table-column align="center" prop="organName" label="所属分部">
  244. <template slot-scope="scope">
  245. <copy-text>{{
  246. scope.row.studentBasicInfo && scope.row.studentBasicInfo.organName
  247. }}</copy-text>
  248. </template>
  249. </el-table-column>
  250. <el-table-column
  251. align="center"
  252. prop="userId"
  253. label="学员信息"
  254. width="140px"
  255. >
  256. <template slot-scope="scope">
  257. <div
  258. style="color: var(--color-primary); cursor: pointer"
  259. v-if="scope.row.studentBasicInfo"
  260. @click="gotoStudent(scope.row.studentBasicInfo.userId)"
  261. >
  262. {{
  263. scope.row.studentBasicInfo &&
  264. scope.row.studentBasicInfo.userName
  265. }}<br />
  266. {{
  267. scope.row.studentBasicInfo && scope.row.studentBasicInfo.userId
  268. }}
  269. </div>
  270. </template>
  271. </el-table-column>
  272. <el-table-column
  273. align="center"
  274. prop="studentBasicInfo.phone"
  275. label="联系电话"
  276. >
  277. </el-table-column>
  278. <el-table-column
  279. align="center"
  280. prop="studentBasicInfo.subjectName"
  281. label="声部"
  282. >
  283. </el-table-column>
  284. <el-table-column
  285. align="center"
  286. prop="studentBasicInfo.cooperationOrganName"
  287. label="学校"
  288. >
  289. </el-table-column>
  290. <el-table-column align="center" prop="organName" label="学员状态">
  291. <template slot-scope="scope">
  292. <div>
  293. <p
  294. v-if="
  295. (scope.row.noScheduleNum || scope.row.subCourseNum) &&
  296. (scope.row.latelyYearCourseConsumer ||
  297. !scope.row.overCourseNum)
  298. "
  299. >
  300. 在读
  301. </p>
  302. <p
  303. v-if="
  304. scope.row.overCourseNum &&
  305. (scope.row.subCourseNum || scope.row.noScheduleNum) &&
  306. !scope.row.latelyYearCourseConsumer
  307. "
  308. >
  309. 沉睡
  310. </p>
  311. <p
  312. v-if="
  313. scope.row.overCourseNum &&
  314. !scope.row.noScheduleNum &&
  315. !scope.row.subCourseNum
  316. "
  317. >
  318. 流失
  319. </p>
  320. </div>
  321. </template>
  322. </el-table-column>
  323. <el-table-column align="center" prop="noScheduleNum" label="未排课时">
  324. <template slot-scope="scope">
  325. {{ scope.row.noScheduleNum }}节
  326. </template>
  327. </el-table-column>
  328. <el-table-column align="center" prop="totalCourseNum" label="总课时">
  329. <template slot-scope="scope">
  330. {{ scope.row.totalCourseNum }}节
  331. </template>
  332. </el-table-column>
  333. <el-table-column align="center" prop="overCourseNum" label="已完成课时">
  334. <template slot-scope="scope">
  335. {{ scope.row.overCourseNum }}节
  336. </template>
  337. </el-table-column>
  338. <el-table-column align="center" prop="subCourseNum" label="剩余课时">
  339. <template slot-scope="scope">
  340. {{ scope.row.subCourseNum }}节
  341. </template>
  342. </el-table-column>
  343. <el-table-column align="center" prop="preCourseFee" label="预收金额">
  344. <template slot-scope="scope">
  345. {{ scope.row.preCourseFee | moneyFormat }}元
  346. </template>
  347. </el-table-column>
  348. <el-table-column align="center" width="180px" label="操作">
  349. <template slot-scope="scope">
  350. <el-button type="text" @click="recordVisit(scope.row)"
  351. >回访记录</el-button
  352. >
  353. </template>
  354. </el-table-column>
  355. </el-table>
  356. <pagination
  357. sync
  358. :total.sync="pageInfo.total"
  359. :page.sync="pageInfo.page"
  360. :limit.sync="pageInfo.limit"
  361. :page-sizes="pageInfo.page_size"
  362. @pagination="getList"
  363. />
  364. </div>
  365. <el-dialog
  366. title="回访记录"
  367. width="1000px"
  368. v-if="visitVisiable"
  369. :close-on-click-modal="false"
  370. :visible.sync="visitVisiable"
  371. >
  372. <visiList
  373. :studentId="activeRow.userId"
  374. :studentName="activeRow.studentBasicInfo.userName"
  375. :groupType="groupType"
  376. @getList='getList'
  377. />
  378. </el-dialog>
  379. </div>
  380. </template>
  381. <script>
  382. import pagination from "@/components/Pagination/index";
  383. import { queryPage } from "../api";
  384. import { feedbackTypeList } from "@/utils/searchArray";
  385. import { getTimes } from "@/utils";
  386. import { Export } from "@/utils/downLoadFile";
  387. import cleanDeep from "clean-deep";
  388. import visiList from "./visiList.vue";
  389. import qs from "qs";
  390. export default {
  391. name: "tableList",
  392. props: ["groupType"],
  393. components: {
  394. pagination,
  395. visiList,
  396. },
  397. data() {
  398. return {
  399. searchForm: {
  400. search: "",
  401. organId: [],
  402. studentStatus: "",
  403. feedbackType: "",
  404. latelyCourseConsumer: "",
  405. visitNum: "",
  406. teacherId: "",
  407. musicDirectorId: "",
  408. courseConsumerError: "",
  409. timer:[],
  410. },
  411. tableList: [],
  412. feedbackTypeList,
  413. pageInfo: {
  414. // 分页规则
  415. limit: 10, // 限制显示条数
  416. page: 1, // 当前页
  417. total: 0, // 总条数
  418. page_size: [10, 20, 40, 50], // 选择限制显示条数
  419. },
  420. visitVisiable: false,
  421. activeRow: null,
  422. };
  423. },
  424. async mounted() {
  425. this.$store.dispatch("setBranchs");
  426. this.$store.dispatch("setTeachers");
  427. await this.getList();
  428. },
  429. methods: {
  430. onSearch() {
  431. this.pageInfo.page = 1;
  432. this.getList();
  433. },
  434. onReSet() {
  435. this.searchForm.timer = [];
  436. this.$refs.searchForm.resetFields();
  437. this.onSearch();
  438. },
  439. async getList() {
  440. const { timer, ...rest } = this.searchForm;
  441. console.log(timer)
  442. try {
  443. let obj = {
  444. groupType: this.groupType,
  445. ...rest,
  446. ...getTimes(timer, ["firstCourseStartTime", "firstCourseEndTime"]),
  447. rows: this.pageInfo.limit,
  448. page: this.pageInfo.page,
  449. organId: this.searchForm.organId.join(","),
  450. };
  451. let res = await queryPage({
  452. ...obj,
  453. });
  454. this.tableList = res.data.rows || [];
  455. this.pageInfo.total = res.data.total;
  456. } catch {}
  457. },
  458. gotoStudent(search) {
  459. this.$router.push({
  460. name: "studentList",
  461. params: { search: search },
  462. });
  463. },
  464. gototeacher(search) {
  465. this.$router.push({
  466. name: "teacherList",
  467. params: { search: search },
  468. });
  469. },
  470. recordVisit(row) {
  471. this.activeRow = row;
  472. this.visitVisiable = true;
  473. },
  474. smallStudentExport() {
  475. const { timer, ...rest } = this.searchForm;
  476. let str = "";
  477. if (this.groupType === "PRACTICE") {
  478. str = "网管课";
  479. } else if (this.groupType === "VIP") {
  480. str = "VIP课";
  481. } else {
  482. str = "乐理课";
  483. }
  484. Export(
  485. this,
  486. {
  487. url: "/api-web/studentStatistics/exportStudentSmallClassStatisticsSum",
  488. fileName: `${str}学员管理.xls`,
  489. method: "post",
  490. params: qs.stringify(
  491. cleanDeep({
  492. groupType: this.groupType,
  493. ...rest,
  494. ...getTimes(timer, [
  495. "firstCourseStartTime",
  496. "firstCourseEndTime",
  497. ]),
  498. rows: this.pageInfo.limit,
  499. page: this.pageInfo.page,
  500. organId: this.searchForm.organId.join(","),
  501. })
  502. ),
  503. },
  504. `您确定导出${str}学员管理?`
  505. );
  506. },
  507. },
  508. };
  509. </script>
  510. <style lang="scss" scoped>
  511. .rows {
  512. > div {
  513. margin-bottom: 20px;
  514. }
  515. }
  516. /deep/ .el-card__body .statistic {
  517. margin-bottom: 15px;
  518. padding: 0;
  519. }
  520. .statistic {
  521. .statistic-content > span {
  522. font-size: 22px !important;
  523. &:first-child {
  524. font-size: 14px !important;
  525. }
  526. }
  527. }
  528. </style>