levelManager.vue 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348
  1. <template>
  2. <div class="m-container">
  3. <h2>
  4. <div class="squrt"></div>考级报名列表
  5. </h2>
  6. <div class="m-core">
  7. <!-- 搜索标题 -->
  8. <el-form :inline="true" class="searchForm" v-model.trim="searchForm">
  9. <el-form-item>
  10. <el-input v-model.trim="searchForm.orderNo" placeholder="请输入订单编号"></el-input>
  11. </el-form-item>
  12. <el-form-item>
  13. <el-input v-model.trim="searchForm.transNo" placeholder="请输入交易流水号"></el-input>
  14. </el-form-item>
  15. <el-form-item>
  16. <el-input v-model.trim="searchForm.city" @keyup.enter.native="city" placeholder="请输入城市名"></el-input>
  17. </el-form-item>
  18. <el-form-item>
  19. <el-select v-model.trim="searchForm.organId" filterable clearable placeholder="请选择分部">
  20. <el-option
  21. v-for="item in branchList"
  22. :key="item.id"
  23. :label="item.label"
  24. :value="item.value"
  25. ></el-option>
  26. </el-select>
  27. </el-form-item>
  28. <el-form-item>
  29. <el-select
  30. class="multiple"
  31. v-model.trim="searchForm.status"
  32. filterable
  33. clearable
  34. placeholder="请选择缴费状态"
  35. >
  36. <el-option value="reg" label="未缴费"></el-option>
  37. <el-option value="pay" label="已缴费"></el-option>
  38. </el-select>
  39. </el-form-item>
  40. <el-form-item>
  41. <el-date-picker
  42. v-model.trim="orderDate"
  43. style="width:410px;"
  44. type="daterange"
  45. value-format="yyyy-MM-dd"
  46. @change="searchOrderDate"
  47. range-separator="至"
  48. start-placeholder="开始日期"
  49. end-placeholder="结束日期"
  50. ></el-date-picker>
  51. </el-form-item>
  52. <el-form-item>
  53. <el-button @click="onSearch" type="danger">搜索</el-button>
  54. <!-- <el-button @click="onReSet" type="primary">重置</el-button> -->
  55. <el-button
  56. @click="onExport"
  57. v-permission="'export/degreeRegistration/825'"
  58. type="primary"
  59. >导出</el-button>
  60. </el-form-item>
  61. </el-form>
  62. <div style="font-size: 14px; color: #F85043; padding-bottom: 10px;">
  63. 报考总人数:{{ totalNumber }}人
  64. <i style="width: 10px; display: inline-block"></i>
  65. 实收总金额:{{ totalAmount }}元
  66. </div>
  67. <div class="tableWrap">
  68. <el-table :data="tableList" :header-cell-style="{background:'#EDEEF0',color:'#444'}">
  69. >
  70. <el-table-column width="90px" align="center" prop="id" label="编号"></el-table-column>
  71. <el-table-column align="center" prop="name" label="姓名"></el-table-column>
  72. <el-table-column align="center" prop="orderNo" label="订单编号"></el-table-column>
  73. <el-table-column align="center" prop="transNo" label="交易流水号">
  74. <template slot-scope="scope">
  75. <el-tooltip placement="top-start">
  76. <div slot="content">{{ scope.row.transNo }}</div>
  77. <span>{{ scope.row.transNo }}</span>
  78. </el-tooltip>
  79. </template>
  80. </el-table-column>
  81. <el-table-column align="center" prop="gender" label="性别">
  82. <template slot-scope="scope">{{ scope.row.gender == 1 ? '男' : '女' }}</template>
  83. </el-table-column>
  84. <el-table-column align="center" prop="idcard" label="身份证号"></el-table-column>
  85. <el-table-column align="center" prop="mobile" label="联系电话"></el-table-column>
  86. <el-table-column align="center" prop="city" label="城市"></el-table-column>
  87. <el-table-column align="center" prop="subject" label="报考乐器"></el-table-column>
  88. <el-table-column align="center" prop="level" label="报考级别"></el-table-column>
  89. <el-table-column align="center" prop="theoryLevel" label="乐理级别"></el-table-column>
  90. <el-table-column align="center" label="缴费状态">
  91. <template slot-scope="scope">{{ scope.row.status == 2 ? '已缴费' : '未缴费' }}</template>
  92. </el-table-column>
  93. <el-table-column align="center" prop="money" label="报考级别费用">
  94. <template slot-scope="scope">{{ scope.row.money }}元</template>
  95. </el-table-column>
  96. <el-table-column align="center" prop="theoryMoney" label="乐理级别费用">
  97. <template slot-scope="scope">{{ scope.row.theoryMoney }}元</template>
  98. </el-table-column>
  99. <el-table-column align="center" label="证书">
  100. <template slot-scope="scope">
  101. <div v-if="scope.row.theoryCert">
  102. <el-image
  103. fit="cover"
  104. style="width: 100px; height: 100px"
  105. :src="scope.row.theoryCert"
  106. :preview-src-list="[scope.row.theoryCert]"
  107. ></el-image>
  108. </div>
  109. <div v-else>--</div>
  110. </template>
  111. </el-table-column>
  112. <el-table-column align="center" prop="createTime" label="报名时间"></el-table-column>
  113. <el-table-column align="center" prop="memo" label="备注"></el-table-column>
  114. <!-- <el-table-column align="center" label="操作">
  115. <template slot-scope="scope">
  116. <el-button @click="onTypeDelOpeation(scope.row)"
  117. v-permission="'helpCenterContent/delete'" type="text">删除</el-button>
  118. </template>
  119. </el-table-column>-->
  120. </el-table>
  121. <pagination
  122. :total="pageInfo.total"
  123. :page.sync="pageInfo.page"
  124. :limit.sync="pageInfo.limit"
  125. :page-sizes="pageInfo.page_size"
  126. @pagination="getList"
  127. />
  128. </div>
  129. </div>
  130. </div>
  131. </template>
  132. <script>
  133. import pagination from "@/components/Pagination/index";
  134. import axios from "axios";
  135. // import store from '@/store'
  136. import { degreeQueryPage } from "./levelManageApi";
  137. import { getToken } from "@/utils/auth";
  138. import { getEmployeeOrgan } from "@/api/buildTeam";
  139. import load from "@/utils/loading";
  140. export default {
  141. components: { pagination },
  142. name: "helpCategory",
  143. data() {
  144. return {
  145. orderDate: null,
  146. searchForm: {
  147. orderNo: null,
  148. transNo: null,
  149. city: null,
  150. status: null,
  151. startTime: null,
  152. organId: null,
  153. endTime: null,
  154. },
  155. totalNumber: 0,
  156. totalAmount: 0,
  157. tableList: [],
  158. branchList: [], // 分部列表
  159. pageInfo: {
  160. // 分页规则
  161. limit: 10, // 限制显示条数
  162. page: 1, // 当前页
  163. total: 0, // 总条数
  164. page_size: [10, 20, 40, 50], // 选择限制显示条数
  165. },
  166. tempTreeList: [],
  167. };
  168. },
  169. activated() {
  170. this.getList();
  171. this.__init();
  172. },
  173. mounted() {
  174. this.getList();
  175. this.__init();
  176. },
  177. methods: {
  178. __init() {
  179. getEmployeeOrgan().then((res) => {
  180. if (res.code == 200) {
  181. this.branchList = [];
  182. res.data.forEach((item) => {
  183. this.branchList.push({
  184. label: item.name,
  185. value: item.id,
  186. });
  187. });
  188. }
  189. });
  190. },
  191. onSearch() {
  192. let pageInfo = this.pageInfo;
  193. pageInfo.page = 1;
  194. this.getList();
  195. },
  196. onReSet() {
  197. // 重置搜索
  198. this.orderDate = null;
  199. this.searchForm = {
  200. orderNo: null,
  201. transNo: null,
  202. city: null,
  203. status: null,
  204. startTime: null,
  205. organId: null,
  206. endTime: null,
  207. };
  208. this.getList();
  209. },
  210. getList() {
  211. let searchForm = this.searchForm;
  212. let params = {
  213. orderNo: searchForm.orderNo ? searchForm.orderNo : null,
  214. transNo: searchForm.transNo ? searchForm.transNo : null,
  215. city: searchForm.city ? searchForm.city : null,
  216. status: searchForm.status ? searchForm.status : null,
  217. startTime: searchForm.startTime ? searchForm.startTime : null,
  218. endTime: searchForm.endTime ? searchForm.endTime : null,
  219. organId: searchForm.organId ? searchForm.organId : null,
  220. page: this.pageInfo.page,
  221. rows: this.pageInfo.limit,
  222. };
  223. degreeQueryPage(params).then((res) => {
  224. let result = res.data;
  225. if (res.code == 200) {
  226. this.totalNumber = result.total;
  227. this.totalAmount = result.totalAmount;
  228. this.tableList = result.rows;
  229. this.pageInfo.total = result.total;
  230. }
  231. });
  232. },
  233. searchOrderDate(value) {
  234. if (value) {
  235. this.searchForm.startTime = value[0];
  236. this.searchForm.endTime = value[1];
  237. } else {
  238. this.searchForm.startTime = null;
  239. this.searchForm.endTime = null;
  240. }
  241. },
  242. // 导出
  243. onExport() {
  244. let url = "/api-web/export/degreeRegistration";
  245. let searchForm = this.searchForm;
  246. let params = {
  247. orderNo: searchForm.orderNo ? searchForm.orderNo : null,
  248. transNo: searchForm.transNo ? searchForm.transNo : null,
  249. city: searchForm.city ? searchForm.city : null,
  250. status: searchForm.status ? searchForm.status : null,
  251. startTime: searchForm.startTime ? searchForm.startTime : null,
  252. endTime: searchForm.endTime ? searchForm.endTime : null,
  253. };
  254. const options = {
  255. method: "get",
  256. headers: {
  257. Authorization: getToken(),
  258. },
  259. url,
  260. params: params,
  261. responseType: "blob",
  262. };
  263. this.$confirm("您确定导出列表?", "提示", {
  264. confirmButtonText: "确定",
  265. cancelButtonText: "取消",
  266. type: "warning",
  267. })
  268. .then(() => {
  269. load.startLoading();
  270. axios(options)
  271. .then((res) => {
  272. let blob = new Blob([res.data], {
  273. // type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8'
  274. type: "application/vnd.ms-excel;charset=utf-8",
  275. //word文档为application/msword,pdf文档为application/pdf,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8
  276. });
  277. let text = new Response(blob).text();
  278. text.then((res) => {
  279. // 判断是否报错
  280. if (res.indexOf("code") != -1) {
  281. let json = JSON.parse(res);
  282. this.$message.error(json.msg);
  283. } else {
  284. let objectUrl = URL.createObjectURL(blob);
  285. let link = document.createElement("a");
  286. let nowTime = new Date();
  287. let ymd =
  288. nowTime.getFullYear() +
  289. "" +
  290. (nowTime.getMonth() + 1) +
  291. "" +
  292. nowTime.getDate() +
  293. "" +
  294. nowTime.getHours() +
  295. "" +
  296. nowTime.getMinutes();
  297. let fname = ymd + "考级报名列表";
  298. link.href = objectUrl;
  299. link.setAttribute("download", fname);
  300. document.body.appendChild(link);
  301. link.click();
  302. }
  303. });
  304. load.endLoading();
  305. })
  306. .catch((error) => {
  307. this.$message.error("导出数据失败,请联系管理员");
  308. load.endLoading();
  309. });
  310. })
  311. .catch(() => {});
  312. },
  313. },
  314. };
  315. </script>
  316. <style lang="scss" scoped>
  317. .el-button--primary {
  318. background: #14928a;
  319. border-color: #14928a;
  320. color: #fff;
  321. &:hover,
  322. &:active,
  323. &:focus {
  324. background: #14928a;
  325. border-color: #14928a;
  326. color: #fff;
  327. }
  328. }
  329. /deep/.el-image-viewer__close {
  330. color: #fff;
  331. opacity: 1;
  332. }
  333. /deep/.el-date-editor.el-input {
  334. width: 100% !important;
  335. }
  336. /deep/.el-select {
  337. width: 100% !important;
  338. }
  339. /deep/.el-table .cell {
  340. display: -webkit-box;
  341. overflow: hidden;
  342. text-overflow: ellipsis;
  343. -webkit-line-clamp: 3;
  344. -webkit-box-orient: vertical;
  345. }
  346. </style>