Quasar Q-Table中Checkbox无法切换的问题排查与需求实现

问题说明 #

在Quasar Q-Table的isBlackListed列中，点击弹窗内的Checkbox无法切换状态，需要实现状态切换功能并触发数据库保存逻辑。

错误原因 #

1. Q-Popup-Edit的作用域变量应为scope.value，原代码错误绑定为scope.isBlackListed，导致状态无法同步
2. 手动添加的@click事件干扰了Checkbox的原生双向绑定逻辑

解决方案 #

修改模板部分

调整Checkbox的绑定目标，移除多余点击事件，并给Q-Popup-Edit添加保存事件监听：

<div id="q-app" style="min-height: 100vh;">
<div class="q-pa-md">
    <q-table
      flat bordered
      title="Treats"
      :rows="rows"
      :columns="columns"
      row-key="name"
      binary-state-sort
    >
      <template v-slot:body="props">
        <q-tr :props="props">
          <q-td key="name" :props="props">
            {{ props.row.name }}
            <q-popup-edit v-model="props.row.name" v-slot="scope">
              <q-input v-model="scope.value" dense autofocus counter @keyup.enter="scope.set"></q-input>
            </q-popup-edit>
          </q-td>
           <q-td key="isBlackListed" :props="props">
            {{ props.row.isBlackListed }}
             <q-popup-edit
              v-model="props.row.isBlackListed"
              buttons
              v-slot="scope"
              @save="handleSaveBlackListStatus(props.row, scope.value)"
            >
              <q-checkbox
                v-model="scope.value"
                dense
                label="BlackListed"
                autofocus
              />
            </q-popup-edit>
           </q-td>        
          <q-td key="calories" :props="props">
            {{ props.row.calories }}
            <q-popup-edit v-model="props.row.calories" title="Update calories" buttons v-slot="scope">
              <q-input type="number" v-model="scope.value" dense autofocus></q-input>
            </q-popup-edit>
          </q-td>
          <q-td key="fat" :props="props">
            <div class="text-pre-wrap">{{ props.row.fat }}</div>
            <q-popup-edit v-model="props.row.fat" v-slot="scope">
              <q-input type="textarea" v-model="scope.value" dense autofocus></q-input>
            </q-popup-edit>
          </q-td>
          <q-td key="carbs" :props="props">
            {{ props.row.carbs }}
            <q-popup-edit v-model="props.row.carbs" title="Update carbs" buttons persistent v-slot="scope">
              <q-input type="number" v-model="scope.value" dense autofocus hint="Use buttons to close"></q-input>
            </q-popup-edit>
          </q-td>
          <q-td key="protein" :props="props">{{ props.row.protein }}</q-td>
          <q-td key="sodium" :props="props">{{ props.row.sodium }}</q-td>
          <q-td key="calcium" :props="props">{{ props.row.calcium }}</q-td>
          <q-td key="iron" :props="props">{{ props.row.iron }}</q-td>
        </q-tr>
      </template>
    </q-table>
  </div>
</div>

修改脚本部分

添加保存逻辑函数，处理数据库存储操作：

const { ref } = Vue

const columns = [
  {
    name: 'name',
    required: true,
    label: 'Dessert (100g serving)',
    align: 'left',
    field: row => row.name,
    format: val => `${val}`,
    sortable: true
  },
  { name: 'isBlackListed', align: 'center', label: 'BlackListed', field: 'isBlackListed', sortable: false },
  { name: 'calories', align: 'center', label: 'Calories', field: 'calories', sortable: true },
  { name: 'fat', label: 'Fat (g)', field: 'fat', sortable: true, style: 'width: 10px' },
  { name: 'carbs', label: 'Carbs (g)', field: 'carbs' },
  { name: 'protein', label: 'Protein (g)', field: 'protein' },
  { name: 'sodium', label: 'Sodium (mg)', field: 'sodium' },
  { name: 'calcium', label: 'Calcium (%)', field: 'calcium', sortable: true, sort: (a, b) => parseInt(a, 10) - parseInt(b, 10) },
  { name: 'iron', label: 'Iron (%)', field: 'iron', sortable: true, sort: (a, b) => parseInt(a, 10) - parseInt(b, 10) }
]

const rows = [
  {
    name: 'Frozen Yogurt',
    isBlackListed:false,
    calories: 159,
    fat: 6.0,
    carbs: 24,
    protein: 4.0,
    sodium: 87,
    calcium: '14%',
    iron: '1%'
  },
  {
    name: 'Ice cream sandwich',
    isBlackListed:false,
    calories: 237,
    fat: 9.0,
    carbs: 37,
    protein: 4.3,
    sodium: 129,
    calcium: '8%',
    iron: '1%'
  },
  {
    name: 'Eclair',
    isBlackListed:false,
    calories: 262,
    fat: 16.0,
    carbs: 23,
    protein: 6.0,
    sodium: 337,
    calcium: '6%',
    iron: '7%'
  },
  {
    name: 'Cupcake',
    isBlackListed:false,
    calories: 305,
    fat: 3.7,
    carbs: 67,
    protein: 4.3,
    sodium: 413,
    calcium: '3%',
    iron: '8%'
  },
  {
    name: 'Gingerbread',
    isBlackListed:false,
    calories: 356,
    fat: 16.0,
    carbs: 49,
    protein: 3.9,
    sodium: 327,
    calcium: '7%',
    iron: '16%'
  },
  {
    name: 'Jelly bean',
    isBlackListed:false,
    calories: 375,
    fat: 0.0,
    carbs: 94,
    protein: 0.0,
    sodium: 50,
    calcium: '0%',
    iron: '0%'
  },
  {
    name: 'Lollipop',
    isBlackListed:false,
    calories: 392,
    fat: 0.2,
    carbs: 98,
    protein: 0,
    sodium: 38,
    calcium: '0%',
    iron: '2%'
  },
  {
    name: 'Honeycomb',
    isBlackListed:false,
    calories: 408,
    fat: 3.2,
    carbs: 87,
    protein: 6.5,
    sodium: 562,
    calcium: '0%',
    iron: '45%'
  },
  {
    name: 'Donut',
    isBlackListed:false,
    calories: 452,
    fat: 25.0,
    carbs: 51,
    protein: 4.9,
    sodium: 326,
    calcium: '2%',
    iron: '22%'
  },
  {
    name: 'KitKat',
    isBlackListed:false,
    calories: 518,
    fat: 26.0,
    carbs: 65,
    protein: 7,
    sodium: 54,
    calcium: '12%',
    iron: '6%'
  }
]

const app = Vue.createApp({
  setup () {
    const handleSaveBlackListStatus = (row, newStatus) => {
      // 此处编写数据库保存逻辑
      console.log(`保存状态：${row.name} 的黑名单状态改为 ${newStatus}`)
      // 示例API调用（替换为实际接口）
      // await fetch('/api/update-blacklist', {
      //   method: 'POST',
      //   headers: { 'Content-Type': 'application/json' },
      //   body: JSON.stringify({ name: row.name, isBlackListed: newStatus })
      // })
    }

    return {
      columns,
      rows: ref(rows),
      handleSaveBlackListStatus
    }
  }
})

app.use(Quasar, { config: {} })
app.mount('#q-app')

关键修改点 #

• 将Checkbox的v-model绑定到scope.value，与Q-Popup-Edit的v-model保持一致，实现状态同步
• 移除手动修改状态的@click事件，依赖Checkbox原生双向绑定
• 通过Q-Popup-Edit的@save事件触发保存函数，传入当前行数据和新状态，完成数据库存储操作

内容的提问来源于stack exchange，提问作者Luiz Alves