<el-table-column prop="storeName" align="center" label="B2B店铺名/客户号" width="200" sortable :sort-method="sortDevName"></el-table-column>
直接在el-table-column 里面添加 sortable 和自定义排序方法:sort-method="sortDevName"
sortDevName(column1, column2) {
//这里我的列数据需要从字符串的括号里取 先取你排序的字段值
let regex = /\((.+?)\)/g;
let str1 = column1.storeName.match(regex)[0].replace("(", "").replace(")", "");
let str2 = column2.storeName.match(regex)[0].replace("(", "").replace(")", "");
let res = 0
for (let i = 0;; i++) {
if (!str1[i] || !str2[i]) {
res = str1.length - str2.length
break
}
const char1 = str1[i]
const char1Type = this.getChartType(char1)
const char2 = str2[i]
const char2Type = this.getChartType(char2)
// 类型相同的逐个比较字符
if (char1Type[0] === char2Type[0]) {
if (char1 === char2) {
continue
} else {
if (char1Type[0] === 'zh') {
res = char1.localeCompare(char2)
} else if (char1Type[0] === 'en') {
res = char1.charCodeAt(0) - char2.charCodeAt(0)
} else {
res = char1 - char2
}
break
}
} else {
// 类型不同的,直接用返回的数字相减
res = char1Type[1] - char2Type[1]
break
}
}
return res
},
getChartType(char) {
// 数字可按照排序的要求进行自定义
// 数字(0->9)->大写字母(A->Z)->小写字母(a->z)->中文拼音(a->z)
if (/^[\u4e00-\u9fa5]$/.test(char)) {
return ['zh', 300]
}
if (/^[a-zA-Z]$/.test(char)) {
return ['en', 200]
}
if (/^[0-9]$/.test(char)) {
return ['number', 100]
}
return ['others', 999]
}