schangxiang@126.com
2024-11-21 60735779c303c2dd10feea45d7fd761103b225e0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
<template>
  <div class="testStudent-container">
    <el-card shadow="hover" :body-style="{ paddingBottom: '0' }"> 
      <el-form :model="queryParamsTestStudent" ref="queryForm" labelWidth="90">
        <el-row>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10">
            <el-form-item label="关键字">
              <el-input v-model="queryParamsTestStudent.searchKey" clearable="" placeholder="重复性校验方式,学生姓名,别名(可空),创建人,修改人"/>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="重复性校验方式">
              <el-input v-model="queryParamsTestStudent.repCheckType" clearable="" placeholder="请输入重复性校验方式"/>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="老师ID(可空)">
              <el-input v-model="queryParamsTestStudent.teacherId" clearable="" placeholder="请输入老师ID(可空)"/>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="老师名字(可空)">
              <el-input v-model="queryParamsTestStudent.teacherName" clearable="" placeholder="请输入老师名字(可空)"/>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="学生姓名">
              <el-input v-model="queryParamsTestStudent.name" clearable="" placeholder="请输入学生姓名"/>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="别名(可空)">
              <el-input v-model="queryParamsTestStudent.aliName" clearable="" placeholder="请输入别名(可空)"/>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="学生年龄">
              <el-input-number v-model="queryParamsTestStudent.age"  clearable="" placeholder="请输入学生年龄"/>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="年纪(可空)">
              <el-input-number v-model="queryParamsTestStudent.nianJi"  clearable="" placeholder="请输入年纪(可空)"/>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="校长ID(可空)">
              <el-input v-model="queryParamsTestStudent.rectorId" clearable="" placeholder="请输入校长ID(可空)"/>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="零花钱">
              <el-input v-model="queryParamsTestStudent.hasMoney" clearable="" placeholder="请输入零花钱"/>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="身价(可空)">
              <el-input v-model="queryParamsTestStudent.shenJia" clearable="" placeholder="请输入身价(可空)"/>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="是否在校">
              <el-select clearable="" v-model="queryParamsTestStudent.isInSchool" placeholder="请选择是否在校">
                <el-option v-for="(item,index) in getEnumIsInSchoolData_Index" :key="index" :value="item.value" :label="`${item.describe}`" />
                
              </el-select>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="是否外地人(可空)">
              <el-select clearable="" v-model="queryParamsTestStudent.isWDR" placeholder="请选择是否外地人(可空)">
                <el-option v-for="(item,index) in getEnumIsWDRData_Index" :key="index" :value="item.value" :label="`${item.describe}`" />
                
              </el-select>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="性别">
              <el-select clearable="" v-model="queryParamsTestStudent.gender" placeholder="请选择性别">
                <el-option v-for="(item,index) in getEnumGenderData_Index" :key="index" :value="item.value" :label="`${item.describe}`" />
                
              </el-select>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="其他性别(可空)">
              <el-select clearable="" v-model="queryParamsTestStudent.otherGender" placeholder="请选择其他性别(可空)">
                <el-option v-for="(item,index) in getEnumOtherGenderData_Index" :key="index" :value="item.value" :label="`${item.describe}`" />
                
              </el-select>
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="出生日期">
              <el-date-picker placeholder="请选择出生日期" value-format="YYYY/MM/DD" type="daterange" v-model="queryParamsTestStudent.brithDateRange" />
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="8" :xl="4" class="mb10" v-if="showAdvanceQueryUITestStudent">
            <el-form-item label="入学日期(可空)">
              <el-date-picker placeholder="请选择入学日期(可空)" value-format="YYYY/MM/DD" type="daterange" v-model="queryParamsTestStudent.inSchoolDateRange" />
              
            </el-form-item>
          </el-col>
          <el-col :xs="24" :sm="12" :md="12" :lg="6" :xl="6" class="mb10">
            <el-form-item>
              <el-button-group style="display: flex; align-items: center;">
                <el-button type="primary"  icon="ele-Search" @click="handleQueryTestStudent" v-auth="'testStudent:page'" :disabled="disabled_btnTestStudent"> 查询 </el-button>
                      <el-button icon="ele-Refresh" @click="resetTestStudent"> 重置 </el-button>
                        <el-button icon="ele-ZoomIn" @click="changeAdvanceQueryUITestStudent" v-if="!showAdvanceQueryUITestStudent" style="margin-left:5px;"> 高级查询 </el-button>
                        <el-button icon="ele-ZoomOut" @click="changeAdvanceQueryUITestStudent" v-if="showAdvanceQueryUITestStudent" style="margin-left:5px;"> 隐藏 </el-button>
                <el-button type="primary" style="margin-left:5px;" icon="ele-Plus" @click="openAddTestStudent" v-auth="'testStudent:add'"> 新增 </el-button>
                <el-button type="primary" style="margin-left:5px;" icon="ele-Upload" @click="openImportExcelTestStudent"  v-auth="'testStudent:importExcel'" > 导入 </el-button>
                <el-button type="primary" style="margin-left:5px;" icon="ele-Download" @click="handleExportExcelTestStudent"  v-auth="'testStudent:exportExcel'" > 导出 </el-button>
              </el-button-group>
            </el-form-item>
            
          </el-col>
        </el-row>
      </el-form>
    </el-card>
    <el-card class="full-table" shadow="hover" style="margin-top: 5px">
      <el-table
                ref="tableRefTestStudent"
                :data="tableDataTestStudent"
                style="width: 100%"
                v-loading="loadingTestStudent"
                tooltip-effect="light"
                                row-key="id"
                @sort-change="sortChangeTestStudent"
                border="">
        <el-table-column type="index" label="序号" width="55" align="center"/>
        <el-table-column prop="repCheckType" label="重复性校验方式"  show-overflow-tooltip="" />
        <el-table-column prop="teacherId" label="老师ID(可空)"  show-overflow-tooltip="" />
        <el-table-column prop="teacherName" label="老师名字(可空)"  show-overflow-tooltip="" />
        <el-table-column prop="name" label="学生姓名"  show-overflow-tooltip="" />
        <el-table-column prop="aliName" label="别名(可空)"  show-overflow-tooltip="" />
        <el-table-column prop="age" label="学生年龄"  show-overflow-tooltip="" />
        <el-table-column prop="nianJi" label="年纪(可空)"  show-overflow-tooltip="" />
        <el-table-column prop="rectorId" label="校长ID(可空)"  show-overflow-tooltip="" />
        <el-table-column prop="hasMoney" label="零花钱"  show-overflow-tooltip="" />
        <el-table-column prop="shenJia" label="身价(可空)"  show-overflow-tooltip="" />
        <el-table-column prop="isInSchool" label="是否在校"  show-overflow-tooltip="">
          <template #default="scope">
            <el-tag v-if="scope.row.isInSchool"> 是 </el-tag>
            <el-tag type="danger" v-else> 否 </el-tag>
            
          </template>
          
        </el-table-column>
        <el-table-column prop="isWDR" label="是否外地人(可空)"  show-overflow-tooltip="">
          <template #default="scope">
            <el-tag v-if="scope.row.isWDR"> 是 </el-tag>
            <el-tag type="danger" v-else> 否 </el-tag>
            
          </template>
          
        </el-table-column>
          <el-table-column prop="gender" label="性别"  show-overflow-tooltip="" >
            <template #default="scope">
              <el-tag>{{ getEnumDesc(scope.row.gender, getEnumGenderData_Index)}}</el-tag>
            </template>
          </el-table-column>
          <el-table-column prop="otherGender" label="其他性别(可空)"  show-overflow-tooltip="" >
            <template #default="scope">
              <el-tag>{{ getEnumDesc(scope.row.otherGender, getEnumOtherGenderData_Index)}}</el-tag>
            </template>
          </el-table-column>
         <el-table-column prop="brithDate" label="出生日期" width="80" :formatter="formatDate_T_Date"  show-overflow-tooltip="" />
         <el-table-column prop="inSchoolDate" label="入学日期(可空)" width="80" :formatter="formatDate_T_Date"  show-overflow-tooltip="" />
         <el-table-column prop="createTime" label="创建时间" width="130" :formatter="formatDate_T_Time"  show-overflow-tooltip="" />
         <el-table-column prop="updateTime" label="更新时间" width="130" :formatter="formatDate_T_Time"  show-overflow-tooltip="" />
        <el-table-column prop="createUserName" label="创建人"  show-overflow-tooltip="" />
        <el-table-column prop="updateUserName" label="修改人"  show-overflow-tooltip="" />
        <el-table-column label="操作" width="200" align="center" fixed="right" show-overflow-tooltip="" v-if="auth('testStudent:update') || auth('testStudent:delete')">
          <template #default="scope">
            <el-button icon="ele-Printer" size="small" text="" type="primary" @click="openPrintTestStudent(scope.row)" v-auth="'testStudent:print'"> 打印 </el-button>
            <el-button icon="ele-Edit" size="small" text="" type="primary" @click="openEditTestStudent(scope.row)" v-auth="'testStudent:update'"> 编辑 </el-button>
            <el-button icon="ele-Delete" size="small" text="" type="primary" @click="delTestStudent(scope.row)" v-auth="'testStudent:delete'"> 删除 </el-button>
          </template>
        </el-table-column>
      </el-table>
      <el-pagination
                v-model:currentPage="tableParamsTestStudent.page"
                v-model:page-size="tableParamsTestStudent.pageSize"
                :total="tableParamsTestStudent.total"
                :page-sizes="[10, 20, 50, 100, 200, 500]"
                small=""
                background=""
                @size-change="handleSizeChangeTestStudent"
                @current-change="handleCurrentChangeTestStudent"
                layout="total, sizes, prev, pager, next, jumper"
    />
      <printDialogTestStudent
        ref="printDialogRefTestStudent"
        :title="printTestStudentTitle"
        @reloadTable="handleQueryTestStudent" />
      <editDialogTestStudent
        ref="editDialogRefTestStudent"
        :title="editTestStudentTitle"
        @reloadTable="handleQueryTestStudent"
      />
      <importExcelDialog
        ref="importExcelDialogRefTestStudent"
        :title="importExcelTitleTestStudent"
        @parentUploadFun="handleImportExcelTestStudent"
        @parentDownFun="handleDownExcelTestStudent"
      />
    </el-card>
  </div>
</template>
 
<script lang="ts" setup="" name="testStudent">
  import { ref,onMounted } from "vue";
  import { ElMessageBox, ElMessage } from "element-plus";
  import { auth } from '/@/utils/authFunction';
  import { getDictDataItem as di, getDictDataList as dl } from '/@/utils/dict-utils';
  import { formatDate,formatDate_T_Date,formatDate_T_Time,defaultTimeRange } from '/@/utils/formatTime';
  import importExcelDialog from '/@/components/importExcel/index.vue' //引入导入组件
  import { exportPageExcel } from '/@/utils/exportPageExcel' //引入导出方法
 
  // 推荐设置操作 width 为 200
  import { hiprint } from 'vue-plugin-hiprint';
  import { SysPrintApi } from '/@/api-services/api';
  import { SysPrint } from '/@/api-services/models';
 
  import printDialogTestStudent from '/@/views/system/print/component/hiprint/preview.vue'
  import editDialogTestStudent from '/@/views/main/TestDemo/testStudent/component/editDialog.vue'
  import { pageTestStudent, deleteTestStudent,importExcelTestStudent,downloadExcelTemplateTestStudent } from '/@/api/main/TestDemo/testStudent';
    import { getAPI } from '/@/utils/axios-utils';
    import { SysEnumApi } from '/@/api-services/api';
  import commonFunction from '/@/utils/commonFunction';
 
  const getEnumIsInSchoolData_Index = ref<any>([]);
  const getEnumIsWDRData_Index = ref<any>([]);
  const getEnumGenderData_Index = ref<any>([]);
  const getEnumOtherGenderData_Index = ref<any>([]);
 
    const { getEnumDesc } = commonFunction();
  
  /***************************************************[测试学生表操作]开始***************************************************/
  const showAdvanceQueryUITestStudent = ref(false);
  const tableRefTestStudent = ref(null);
  const printDialogRefTestStudent = ref();
  const editDialogRefTestStudent = ref();
  const loadingTestStudent = ref(false);
  const disabled_btnTestStudent = ref(false);
  const tableDataTestStudent = ref<any>([]);
  const queryParamsTestStudent = ref<any>({});
  const tableParamsTestStudent = ref({
    page: 1,
    pageSize: 10,
    total: 0,
  });
 
  const printTestStudentTitle = ref("");
  const editTestStudentTitle = ref("");
 
  // 改变高级查询的控件显示状态
  const changeAdvanceQueryUITestStudent = () => {
    showAdvanceQueryUITestStudent.value = !showAdvanceQueryUITestStudent.value;
  }
 
  // 查询测试学生表
  const handleQueryTestStudent = async () => {
    loadingTestStudent.value = true;
    disabled_btnTestStudent.value = true;
    var res = await pageTestStudent(Object.assign(queryParamsTestStudent.value, tableParamsTestStudent.value));
    if(res.data.type=="success"){
      tableDataTestStudent.value = res.data.result?.items ?? [];
      tableParamsTestStudent.value.total = res.data.result?.total;
    }
    loadingTestStudent.value = false;
    disabled_btnTestStudent.value = false;
  };
 
  // 重置测试学生表查询
  const resetTestStudent = async () => {
    queryParamsTestStudent.value = {}
  };
 
  // 测试学生表列排序
  const sortChangeTestStudent = async (column: any) => {
    queryParamsTestStudent.value.field = column.prop;
    queryParamsTestStudent.value.order = column.order;
    await handleQueryTestStudent();
  };
 
  // 打开新增测试学生表页面
  const openAddTestStudent = () => {
    editTestStudentTitle.value = '添加测试学生表';
    editDialogRefTestStudent.value.openDialog(1,{});
  };
 
  // 打开打印测试学生表页面
  const openPrintTestStudent = async (row: any) => {
    printTestStudentTitle.value = '打印测试学生表';
    var res = await getAPI(SysPrintApi).apiSysPrintPrintNameGet('测试打印模版');
      var printTemplate = res.data.result as SysPrint;
    var template = JSON.parse(printTemplate.template);
    row['printDate'] = formatDate(new Date(), 'YYYY-mm-dd HH:MM:SS')
    printDialogRefTestStudent.value.showDialog(new hiprint.PrintTemplate({template: template}), row, template.panels[0].width);
  }
  
  // 打开编辑测试学生表页面
  const openEditTestStudent = (row: any) => {
    editTestStudentTitle.value = '编辑测试学生表';
    editDialogRefTestStudent.value.openDialog(2,row);
  };
 
  // 删除测试学生表
  const delTestStudent = (row: any) => {
    ElMessageBox.confirm(`确定要删除吗?`, "提示", {
    confirmButtonText: "确定",
    cancelButtonText: "取消",
    type: "warning",
  })
  .then(async () => {
    loadingTestStudent.value = true;
    var ret = await deleteTestStudent(row);
    if(ret.data.type=="success"){
        ElMessage.success("删除成功");
    }
    loadingTestStudent.value = false;
    handleQueryTestStudent();
  })
  .catch(() => {});
  };
 
  // 改变测试学生表页面容量
  const handleSizeChangeTestStudent = (val: number) => {
    tableParamsTestStudent.value.pageSize = val;
    handleQueryTestStudent();
  };
 
  // 改变测试学生表页码序号
  const handleCurrentChangeTestStudent = (val: number) => {
    tableParamsTestStudent.value.page = val;
    handleQueryTestStudent();
  };
 
/***************************************************[测试学生表操作]结束***************************************************/
/***************************************************[测试学生表导入]开始***************************************************/
const importExcelTitleTestStudent = ref("");
const importExcelDialogRefTestStudent = ref();
//打开导入界面
const openImportExcelTestStudent = () => {
    importExcelTitleTestStudent.value = '导入测试学生表';
    importExcelDialogRefTestStudent.value.openDialog({});
};
//导入数据
const handleImportExcelTestStudent = async (formData:Blob) => {
   var result = await importExcelTestStudent(formData);
   importExcelDialogRefTestStudent.value.callBackUploadFun(result.data);//回调导入子页面的方法
   if(result.data.type=="success"){
    handleQueryTestStudent();
   }
};
//下载导入模板
const handleDownExcelTestStudent = async () => {
   var result = await downloadExcelTemplateTestStudent();
   importExcelDialogRefTestStudent.value.callBackDownFun(result);//回调导入子页面的方法
};
/***************************************************[测试学生表导入]结束***************************************************/
/***************************************************[测试学生表导出]开始***************************************************/
//定义当前页面的方法组
const functionMapTestStudent = {
      getEnumIsInSchoolData_Index,
      getEnumIsWDRData_Index,
      getEnumGenderData_Index,
      getEnumOtherGenderData_Index,
      formatDate_T_Date,
      formatDate_T_Time
};
//点击导出按钮
const handleExportExcelTestStudent = async (formData:Blob) => {
    loadingTestStudent.value = true;
    disabled_btnTestStudent.value = true;
    var new_tableParamsTestStudent=JSON.parse(JSON.stringify(tableParamsTestStudent.value));
    new_tableParamsTestStudent.page = 1;
    new_tableParamsTestStudent.pageSize = 100000;
    var res = await pageTestStudent(Object.assign(queryParamsTestStudent.value, new_tableParamsTestStudent));
    if(res.data.type=="success"){
      exportExcelTestStudent(res.data.result?.items ?? []);
    }
    loadingTestStudent.value = false;
    disabled_btnTestStudent.value = false;
};
//导出
const exportExcelTestStudent  = async (exportDataList:Array) => {
  exportPageExcel(exportDataList, tableRefTestStudent,"测试学生表",functionMapTestStudent);
};
/***************************************************[测试学生表导出]结束***************************************************/
  // 测试学生表页面加载时
  onMounted(async () => {
    getEnumIsInSchoolData_Index.value = (await getAPI(SysEnumApi).apiSysEnumEnumDataListGet('TrueFalseEnum')).data.result ?? [];
    getEnumIsWDRData_Index.value = (await getAPI(SysEnumApi).apiSysEnumEnumDataListGet('TrueFalseEnum')).data.result ?? [];
    getEnumGenderData_Index.value = (await getAPI(SysEnumApi).apiSysEnumEnumDataListGet('AreaTypeEnum')).data.result ?? [];
    getEnumOtherGenderData_Index.value = (await getAPI(SysEnumApi).apiSysEnumEnumDataListGet('ActionLogTypeEnum')).data.result ?? [];
  });
 
  handleQueryTestStudent();
</script>
<style scoped>
:deep(.el-input),
:deep(.el-select),
:deep(.el-input-number) {
    width: 100%;
}
</style>