exam_timer_teacher/tmodel.h

#ifndef TMODEL_H
#define TMODEL_H

#include <cwf/model.h>

class UserModel : public CWF::Model
{
    Q_OBJECT
    Q_PROPERTY(QString name READ getName WRITE setName)
    Q_PROPERTY(QString swID READ getSwID WRITE setSwID)
    Q_PROPERTY(QString state READ getState WRITE setState)
    Q_PROPERTY(QString examineeNumber READ getExamineeNumber WRITE setExamineeNumber)
    Q_PROPERTY(QString examTest READ getExamTest WRITE setExamTest)
    Q_PROPERTY(QString checkinNumber READ getCheckinNumber WRITE setCheckinNumber)
    Q_PROPERTY(QString groupName READ getGroup WRITE setGroup)
    Q_PROPERTY(int maxTime READ getMaxTime WRITE setMaxTime)
    Q_PROPERTY(int answerTime READ getAnswerTime WRITE setAnswerTime)
    Q_PROPERTY(QString answerFileName READ getAnswerFileName WRITE setAnswerFileName)
    Q_PROPERTY(QString school READ getSchool WRITE setSchool)
public:
    explicit UserModel(CWF::SqlDatabaseStorage &connection)
        : CWF::Model(connection, "user")
    {}
    void customizeField(const QString &fieldName,
                        const QVariant::Type &type,
                        const QString &tableName) const override;

public slots:

    QString getName() const { return name; }
    void setName(const QString &value) { name = value; }

    QString getSwID() const { return swID; }
    void setSwID(const QString &value) { swID = value; }

    QString getState() const { return state; }
    void setState(const QString &value) { state = value; }

    QString getExamineeNumber() const { return examineeNumber; }
    void setExamineeNumber(const QString &value) { examineeNumber = value; }

    QString getExamTest() const { return examTest; }
    void setExamTest(const QString &value) { examTest = value; }

    QString getGroup() const { return groupName; }
    void setGroup(const QString &value) { groupName = value; }

    QString getCheckinNumber() const { return checkinNumber; }
    void setCheckinNumber(const QString &value) { checkinNumber = value; }

    int getMaxTime() const { return maxTime; }
    void setMaxTime(const int &value) { maxTime = value; }

    int getAnswerTime() const { return answerTime; }
    void setAnswerTime(const int &value) { answerTime = value; }

    QString getAnswerFileName() const { return answerFileName; }
    void setAnswerFileName(const QString &value) { answerFileName = value; }

    QString getSchool() const { return school; }
    void setSchool(const QString &value) { school = value; }

private:
    QString name;           // 姓名
    QString swID;           // SW_ID
    QString state;          // 在线状态
    QString examineeNumber; // 考试编号
    QString examTest;       // 考试内容
    QString checkinNumber;  // 签到号
    QString groupName;      // 组别
    int maxTime;            // 最大完成时间
    int answerTime;         // 完成时间
    QString answerFileName; // 答案名称
    QString school;         // 学校
    // QVariant AnswerFileNameValue = xlsx.read(row, AnswerFileNameIndex);

    const QStringList columns;
};

// 考试题目
class ExamsQuestionModel : public CWF::Model
{
    Q_OBJECT
    Q_PROPERTY(QString fileDir READ getFileDir WRITE setfileDir)
    Q_PROPERTY(QString name READ getName WRITE setName)
    Q_PROPERTY(bool isSelect READ getIsSelect WRITE setIsSelect)
public:
    explicit ExamsQuestionModel(CWF::SqlDatabaseStorage &connection)
        : CWF::Model(connection, "exams_question")
    {}

public slots:
    QString getFileDir() const { return fileDir; }
    void setfileDir(const QString &value) { fileDir = value; }

    QString getName() const { return name; }
    void setName(const QString &value) { name = value; }

    bool getIsSelect() const { return isSelect; }
    void setIsSelect(const bool &value) { isSelect = value; }

private:
    QString fileDir;
    QString name;
    bool isSelect;
};

// 考试
class ExamsTestModel : public CWF::Model
{
    Q_OBJECT
    Q_PROPERTY(quint64 user_id READ getUserId WRITE setUserId)
    Q_PROPERTY(quint64 exams_id READ getExamsId WRITE setExamsId)
    Q_PROPERTY(quint64 start_time READ getStartTime WRITE setStartTime)
    Q_PROPERTY(quint64 end_time READ getEndTime WRITE setEndTime)

    Q_PROPERTY(QString exam_room READ getExamRoom WRITE setExamRoom)
    Q_PROPERTY(QString exam_sessions READ getExamSessions WRITE setExamSessions)

    Q_PROPERTY(QString answerFileName READ getAnswerFileName WRITE setAnswerFileName)
public:
    explicit ExamsTestModel(CWF::SqlDatabaseStorage &connection)
        : CWF::Model(connection, "exams_test")
    {}

public slots:
    quint64 getUserId() const { return user_id; }
    void setUserId(const quint64 &value) { user_id = value; }

    quint64 getExamsId() const { return exams_id; }
    void setExamsId(const quint64 &value) { exams_id = value; }

    quint64 getStartTime() const { return start_time; }
    void setStartTime(const quint64 &value) { start_time = value; }

    quint64 getEndTime() const { return end_time; }
    void setEndTime(const quint64 &value) { end_time = value; }

    QString getExamRoom() const { return exam_room; }
    void setExamRoom(const QString &value) { exam_room = value; }

    QString getExamSessions() const { return exam_sessions; }
    void setExamSessions(const QString &value) { exam_sessions = value; }

    QString getAnswerFileName() const { return answerFileName; }
    void setAnswerFileName(const QString &value) { answerFileName = value; }

private:
    quint64 user_id;       // 用户id
    quint64 exams_id;      // 考试id
    quint64 start_time;    // 开始时间 目前弃用
    quint64 end_time;      // 结束时间 当作考试时间使用
    QString exam_room;     // 考试教师
    QString exam_sessions; // 考试场次
    QString answerFileName; // 答案名称
};

#endif // TMODEL_H