- 支持单列中文字段名自动生成拼音声母组成的列名
- 支持两列(中英文空格分隔开,不区分中英文字段名前后顺序,可以多个空格隔开,仅识别前两列空格分开的字符串)的方式之自动生成el-table-column代码片段
- 支持键值对描述字段英文名和字段中文名,生成el-table-column代码片段
sgCreateTableColumn源码
<template> <!-- 前往https://blog.csdn.net/qq_37860634/article/details/136126479 查看使用说明 --> <div :class="$options.name"> <div class="sg-head">表格列生成工具</div> <div class="sg-container"> <div class="sg-start"> <div style="margin-bottom: 10px">字段中文名</div> <div style="display: flex; margin-bottom: 10px"> <el-select style="width: 150px" v-model="selectValue_type" @change="(d) => {}" :placeholder="`请选择数据内容类型`" > <el-option v-for="(select, index) in selectOptions_type" :key="index" :value="select.value" :label="select.label" :disabled="select.disabled" ></el-option> </el-select> <template v-if="selectValue_type == 2"> <div style="display: flex; align-items: center; margin-left: 10px"> <label style="margin-right: 5px">fieldName</label> <el-input style="width: 150px" ref="fieldName" v-model.trim="fieldNameValue" maxlength="20" :show-word-limit="false" :placeholder="`字段名`" @focus="$refs.fieldName.select()" clearable /> <label style="margin-left: 10px; margin-right: 5px">keyName</label> <el-input style="width: 150px" ref="keyName" v-model.trim="keyNameValue" maxlength="20" :show-word-limit="false" :placeholder="`字段值名`" @focus="$refs.keyName.select()" clearable /> </div> </template> </div> <el-input ref="textareaValue1" style="margin-bottom: 10px" type="textarea" :placeholder=" this.selectOptions_type.find((v) => v.value == this.selectValue_type) .placeholder " v-model.trim="textareaValue1" show-word-limit /> <el-button type="primary" @click="createResult">生成表格列</el-button> </div> <div class="sg-center">→</div> <div class="sg-end"> <div style="margin-bottom: 10px">生成结果</div> <el-input style="margin-bottom: 10px; flex-grow: 1" type="textarea" :placeholder="`请复制结果`" v-model.trim="textareaValue2" show-word-limit /> <el-button type="primary" @click="copyResult">复制</el-button> </div> </div> </div> </template> <script> import pinyin from "@/js/pinyin"; export default { name: "sgCreateTableColumn", data() { return { selectOptions_type: [ { value: 1, label: "文本", placeholder: `请粘贴字段中文名(或者:字段英文名+空格+字段中文名)`, }, { value: 2, label: "json数据", placeholder: `请粘贴键值对描述json数组` }, ], selectValue_type: 1, fieldNameValue: `fieldName`, keyNameValue: `fieldName_TEXT`, textareaValue1: "", textareaValue2: "", }; }, watch: { textareaValue1(newValue, oldValue) { newValue && this.createResult(newValue); }, }, methods: { createResult(d) { let r = []; switch (this.selectValue_type) { case 1: let texts = this.textareaValue1 .split("\n") .map((v) => v.split("\t").join("").trim()); texts = texts.filter((v, i, ar) => v !== ``); r = texts.map((v) => { let strings = v.replace(/\s+/g, ` `).split(` `); //用空格分隔开两列字段名 let label = ``; let prop = ``; // 如果是多列内容 if (strings.length > 1) { // 如果第一列的字符串是中文 if (this.$g.checkEverything(`cn`, strings[0])) { label = strings[0]; prop = strings[1]; } else { label = strings[1]; prop = strings[0]; } } else { // 如果是单列内容 prop = pinyin.getCamelChars(v); label = v; } let r = `<el-table-column prop="${prop}" label="${label}" show-overflow-tooltip />`; return r; }); break; case 2: if (this.fieldNameValue && this.keyNameValue) { } else { return this.$message.error(`fieldName和keyName都要填写`); } if (this.$g.json.isJSON(this.textareaValue1)) { let arr = JSON.parse(this.textareaValue1); r = arr.map((v) => { let prop = v[this.fieldNameValue]; let label = v[this.keyNameValue]; let r = `<el-table-column prop="${prop}" label="${label}" show-overflow-tooltip />`; return r; }); } else { return this.$message.error(`请输入正确的json格式的对象数组内容`); } break; } this.textareaValue2 = r.join("\n"); this.copyResult(); //自动复制生成结果 }, copyResult(d) { this.$g.copy(this.textareaValue2, true); this.$nextTick(() => { this.$refs.textareaValue1.select(); }); }, }, }; </script> <style lang="scss" scoped> .sgCreateTableColumn { width: 100%; height: 100%; position: absolute; box-sizing: border-box; padding: 20px; .sg-head { display: flex; align-items: center; font-size: 24px; font-weight: bold; color: #409eff; margin-bottom: 10px; } .sg-container { display: flex; flex-wrap: nowrap; height: calc(100vh - 70px); & > .sg-start { width: calc(50% - 20px); height: 100%; flex-shrink: 0; display: flex; flex-direction: column; } & > .sg-center { display: flex; justify-content: center; align-items: center; flex-grow: 1; margin: 0 10px; font-size: 24px; color: #409eff; font-weight: bold; } & > .sg-end { width: calc(50% - 20px); height: 100%; flex-shrink: 0; display: flex; flex-direction: column; } >>> .el-textarea { width: 100%; height: 100%; textarea { width: 100%; height: 100%; max-height: revert; } } } } </style>