vxe-table 如何實現對單元格數據校驗不通過的單元格顯示背景顏色,通過設置 valid-config.theme='beautify' 設置為高亮樣式,調用 fullValidate 方法可以同時顯示多個錯誤提示。

https://vxetable.cn

通過設置 valid-config.showErrorBackground 顯示校驗錯誤單元格背景色

<template>
  <div>
    <div>
      <vxe-button @click="validEvent">多個校驗變動數據</vxe-button>
      <vxe-button @click="fullValidEvent">多個校驗全量數據</vxe-button>
    </div>
    <vxe-grid ref="gridRef" v-bind="gridOptions"></vxe-grid>
  </div>
</template>

<script setup>
import { ref, reactive } from 'vue'
import { VxeUI } from 'vxe-table'

const gridRef = ref()

const gridOptions = reactive({
  border: true,
  showOverflow: true,
  keepSource: true,
  height: 300,
  editConfig: {
    trigger: 'click',
    mode: 'row',
    showStatus: true
  },
  validConfig: {
    msgMode: 'full',
    theme: 'beautify',
    showErrorBackground: true
  },
  editRules: {
    name: [
      { required: true, message: '必須填寫' }
    ],
    role: [
      { required: true, message: '必須填寫' }
    ]
  },
  columns: [
    { type: 'checkbox', width: 60 },
    { type: 'seq', width: 70 },
    { field: 'name', title: 'Name', editRender: { name: 'VxeInput' } },
    { field: 'role', title: 'Role', editRender: { name: 'VxeInput' } },
    { field: 'sex', title: 'Sex', editRender: { name: 'VxeInput' } },
    { field: 'age', title: 'Age', editRender: { name: 'VxeInput' } },
    { field: 'date', title: 'Date', editRender: { name: 'VxeInput' } }
  ],
  data: [
    { id: 10001, name: 'Test1', role: 'Develop', sex: '0', age: 28, address: 'test abc' },
    { id: 10002, name: '', role: 'Test', sex: '1', age: 22, address: 'Guangzhou' },
    { id: 10003, name: 'Test3', role: 'PM', sex: '', age: 32, address: 'Shanghai' },
    { id: 10004, name: 'Test4', role: 'Designer', sex: '', age: 23, address: 'test abc' },
    { id: 10005, name: '', role: '', sex: '1', age: 30, address: 'Shanghai' },
    { id: 10006, name: 'Test6', role: 'Designer', sex: '1', age: 21, address: 'test abc' }
  ]
})

const validEvent = async () => {
  const $grid = gridRef.value
  if ($grid) {
    const errMap = await $grid.fullValidate()
    if (errMap) {
      VxeUI.modal.message({ status: 'error', content: '校驗不通過！' })
    } else {
      VxeUI.modal.message({ status: 'success', content: '校驗成功！' })
    }
  }
}

const fullValidEvent = async () => {
  const $grid = gridRef.value
  if ($grid) {
    const errMap = await $grid.fullValidate(true)
    if (errMap) {
      VxeUI.modal.message({ status: 'error', content: '校驗不通過！' })
    } else {
      VxeUI.modal.message({ status: 'success', content: '校驗成功！' })
    }
  }
}
</script>

https://gitee.com/x-extends/vxe-table