как проверить состояние у динамически созданного CheckBox в qml

sqlquerymodel.h



#ifndef SQLQUERYMODEL_H
#define SQLQUERYMODEL_H

#include <QObject>
#include <QSqlQueryModel>
#include <QSqlRecord>
#include <QSqlField>

class SqlQueryModel : public QSqlQueryModel
{
    Q_OBJECT
public:
    explicit SqlQueryModel(QObject *parent=0);

    void setQuery(const QString &query, const QSqlDatabase &db=QSqlDatabase());
    void setQuery(const QSqlQuery &query);
    QVariant data(const QModelIndex &index, int role) const;
    QHash <int,QByteArray> roleNames() const{return m_roleNames;}

private:
    void generateRoleNames();
    QHash <int,QByteArray> m_roleNames;
};


sqlquerymodel.cpp

#include "sqlquerymodel.h"

SqlQueryModel::SqlQueryModel(QObject *parent) : QSqlQueryModel(parent)
{

}

void SqlQueryModel::setQuery(const QString &query, const QSqlDatabase &db)
{
    QSqlQueryModel::setQuery(query,db);
    generateRoleNames();
}

void SqlQueryModel::setQuery(const QSqlQuery &query)
{
    QSqlQueryModel::setQuery(query);
    generateRoleNames();
}

QVariant SqlQueryModel::data(const QModelIndex &index, int role) const
{
    QVariant value;
    if(index.isValid())
    {
        if(role<Qt::UserRole)
        {
            value=QSqlQueryModel::data(index,role);
        }
        else
        {
            int columnIdx=role - Qt::UserRole -1;
            QModelIndex modelIndex=this->index(index.row(),columnIdx);
            value = QSqlQueryModel::data(modelIndex,Qt::DisplayRole);
        }
    }
    return value;
}

void SqlQueryModel::generateRoleNames()
{
    m_roleNames.clear();
    for (int i=0;i<record().count();i++)
    {
        m_roleNames.insert(Qt::UserRole+i+1,record().fieldName(i).toUtf8());
    }
}

sqldoorsmodel.h

#ifndef SQLDOORSMODEL_H
#define SQLDOORSMODEL_H

#include <QObject>
#include <QSqlQueryModel>
#include <QMap>
#include <QDebug>

class SqlDoorsModel : public QSqlQueryModel
{
    Q_OBJECT
public:
    enum Roles
    {
        doornRole=Qt::UserRole+1,
        doorNameRole,
        doorModeRole,
        openLockTimeRole,
        openDoorTimeRole,
        verifyTimeRole,
        openAlarmTimeRole,
        enterVerifyModeRole,
        exitVerifyModeRole,
        duressPasswRole,
        emergencyPasswRole,
        passModeRole
    };
    explicit SqlDoorsModel(QObject *parent = nullptr);

    Q_INVOKABLE QVariant data(const QModelIndex & index, int role = Qt::DisplayRole) const;
    Q_INVOKABLE QVariantMap get(int idx) const;
    Q_INVOKABLE void set(const int &item, const QVariant &value);
    Q_INVOKABLE QVariant get_door(const int &item);

protected:

    QHash<int, QByteArray> roleNames() const;

signals:
    void statusChanged();

public slots:
    void updateModel();
    int getId(int row);

private:
    QMap<int, QVariant> m_Data;
};

#endif // SQLDOORSMODEL_H


sqldoorsmodel.cpp
#include "sqldoorsmodel.h"

SqlDoorsModel::SqlDoorsModel(QObject *parent): QSqlQueryModel(parent)
{
    this->updateModel();
}

QVariant SqlDoorsModel::data(const QModelIndex &index, int role) const
{
    int columnId = role - Qt::UserRole - 1;
     QModelIndex modelIndex = this->index(index.row(), columnId);
    return QSqlQueryModel::data(modelIndex, Qt::DisplayRole);
}

QVariantMap SqlDoorsModel::get(int idx) const
{
    QVariantMap map;
    foreach(int k, roleNames().keys()) {
        map[roleNames().value(k)] = data(index(idx, 0), k);
    }
    return map;
}

void SqlDoorsModel::set(const int &item, const QVariant &value)
{
    m_Data.insert(item,value);
    qDebug()<<"insert";

}

QVariant SqlDoorsModel::get_door(const int &item)
{
    QVariant door;
    door=m_Data.value(item);
    return door;
}


QHash<int, QByteArray> SqlDoorsModel::roleNames() const
{
    QHash<int, QByteArray> roles;
    roles[doornRole] = "doorn";
    roles[doorNameRole] = "doorName";
    roles[doorModeRole] = "doorMode";
    roles[openLockTimeRole] = "openLockTime";
    roles[openDoorTimeRole] = "openDoorTime";
    roles[verifyTimeRole] = "verifyTime";
    roles[openAlarmTimeRole] = "openAlarmTime";
    roles[enterVerifyModeRole] = "enterVerifyMode";
    roles[exitVerifyModeRole] = "exitVerifyMode";
    roles[duressPasswRole] = "duressPassw";
    roles[emergencyPasswRole] = "emergencyPassw";
    roles[passModeRole] = "passMode";
    return roles;
}

void SqlDoorsModel::updateModel()
{
   this->setQuery("select doorn, doorname, doormode, openlocktime, opendoortime, verifytime, openalarmtime, enterverifymode, exitverifymode, duresspassw, emergencypassw, passmode from param");
}

int SqlDoorsModel::getId(int row)
{
    return this->data(this->index(row, 0), doornRole).toInt();
}

в qml

                     onCheckedChanged: {

                         if (checkBoxDelegate.checked==false)
                         {
                         doorModel.set(doorn,"unchecked")
                         }
                         else doorModel.set(doorn,"checked")
                     }