#include "bachistoricalrecords.h"
#include "ui_bachistoricalrecords.h"
#include <QFileDialog>
#include<QStandardItemModel>
#include<QMessageBox>
#include <QApplication>
#include <QWidget>
#include <QPainter>
#include <QImage>
#include <QFile>
#include <QTextDocument>
#include <QAxObject>
#include <QAxWidget>
#include<QGraphicsDropShadowEffect>
#include<QPrinter>
bachistoricalrecords::bachistoricalrecords(QWidget *parent) :
    QWidget(parent),
    ui(new Ui::bachistoricalrecords),
    currentPage(1),
    recordsPerPage(18),
    totalPages(0),
    currentModel(nullptr) // 初始化 currentModel
{
    ui->setupUi(this);
    this->setWindowFlags(Qt::FramelessWindowHint); // 隐藏标题栏
    ui->tableView->setEditTriggers(QAbstractItemView::NoEditTriggers);
    ui->tableView->setSelectionBehavior(QAbstractItemView::SelectItems);
    ui->tableView->setSelectionMode(QAbstractItemView::SingleSelection);
    ui->tableView->setAlternatingRowColors(true);

    model = new CheckBoxTableModel2(this);
    model->setTable("xijun");// 打开数据库中名为“xijun”的表
    model->select();
    ui->tableView->setModel(model);
    theSelection = new QItemSelectionModel(model);// 关联选择模型

    connect(theSelection, SIGNAL(currentChanged(QModelIndex, QModelIndex)),
            this, SLOT(on_currentChanged(QModelIndex, QModelIndex)));

    ui->tableView->setSelectionModel(theSelection); // 设置选择模型

    // 设置第一列的复选框初始状态
    for (int i = 0; i < model->rowCount(); ++i) {
        QModelIndex index = model->index(i, 0);
        model->setData(index, Qt::Unchecked, Qt::CheckStateRole);
    }
    // 连接信号槽，当复选框状态改变时选中整行
    connect(model, &CheckBoxTableModel2::dataChanged, this, &bachistoricalrecords::onDataChanged);

    // 启用整行选择模式，允许多行选中
    ui->tableView->setSelectionBehavior(QAbstractItemView::SelectRows);
    ui->tableView->setSelectionMode(QAbstractItemView::MultiSelection);

    // 连接点击信号
    connect(ui->tableView, &QTableView::clicked, this, &bachistoricalrecords::onTableViewClicked);

    // 设置自定义表头
    header = new CheckBoxHeader2(Qt::Horizontal, ui->tableView);
    ui->tableView->setHorizontalHeader(header);
    connect(header, &CheckBoxHeader2::checkStateChanged, this, &bachistoricalrecords::onHeaderCheckStateChanged);

    shuaxin();
    // 创建界面组件与数据模型的字段之间的数据映射
    dataMapper = new QDataWidgetMapper();
    dataMapper->setModel(model);// 设置数据模型
    dataMapper->setSubmitPolicy(QDataWidgetMapper::AutoSubmit);

    m_maxtu = new maxtu;
    connect(this, SIGNAL(yuan(QPixmap)), m_maxtu, SLOT(getyuan2(QPixmap)));
   // connect(this, SIGNAL(lujing(QString)), m_maxtu, SLOT(getlujing2(QString)));
    connect(this, SIGNAL(lujing(QString,QString)), m_maxtu, SLOT(getlujing2(QString,QString)));
    ui->pushButton->setFixedSize(76, 37);
    ui->pushButton_2->setFixedSize(76, 37);
    ui->pushButton_4->setFixedSize(76, 37);

    ui->frame->setFixedSize(170, 37);
    ui->frame_2->setFixedSize(170, 37);

    ui->tableView->setItemDelegateForColumn(2, &delegate);
    ui->tableView->setItemDelegateForColumn(3, &delegate);

    QTimer *timer;
    timer = new QTimer(this);
    connect(timer, &QTimer::timeout, this, [=]() {
        QDateTime dateTime = QDateTime::currentDateTime();// 获取系统当前的时间
        QString str = dateTime.toString("yyyy-MM-dd hh:mm:ss");// 格式化时间
        // ui->label_5->setText(str);
    });
    timer->start(1000);

    ui->tableView->setShowGrid(false);
    ui->tableView->verticalHeader()->setVisible(false);

    this->setWindowFlags(Qt::FramelessWindowHint); // 隐藏标题栏
    delegate2 = new ButtonDelegate4;
    ui->tableView->setItemDelegateForColumn(6, delegate2);

    connect(delegate2, &ButtonDelegate4::deleteButtonClicked, this, &bachistoricalrecords::shanchu);
    ui->tableView->setShowGrid(false);

    ui->tableView->setFixedSize(1730, 760);
    ui->tableView->setVerticalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
    connect(ui->tableView, &QTableView::clicked, this, &bachistoricalrecords::onCellClicked);
    m_date = new date;
    connect(m_date, SIGNAL(kaishi(QString)), this, SLOT(getkaishi(QString)));
    m_datee = new datee;
    connect(m_datee, SIGNAL(kaishi(QString)), this, SLOT(getkaishii(QString)));

    QGraphicsDropShadowEffect *shadow = new QGraphicsDropShadowEffect(this);
    // 设置阴影距离
    shadow->setOffset(0, 0);
    // 设置阴影颜色
    shadow->setColor(QColor(214, 214, 214));
    // 设置阴影圆角
    shadow->setBlurRadius(30);
    // 给嵌套QWidget设置阴影
    ui->frame_3->setFixedSize(1755, 907);
    ui->frame_3->setGraphicsEffect(shadow);

    CenteredItemDelegate2* delegate = new CenteredItemDelegate2();
    ui->tableView->setItemDelegate(delegate);
    for (int i = 1; i <= 7; ++i) {
        ui->tableView->setColumnWidth(i, 275);
    }
    ui->tableView->setColumnWidth(0, 80);
    ui->tableView->horizontalHeader()->setFixedHeight(40);
    connect(m_maxtu, &maxtu::guanmeng, this, [=]() { mask_window.close(); });

    ui->lineEdit_2->setFixedSize(56, 32);
    QWidget *buttonContainer = new QWidget(this);
    buttonLayout = new QHBoxLayout(buttonContainer);
    ui->scrollArea->setWidget(buttonContainer);
    ui->scrollArea->setWidgetResizable(true);

    buttonGroup = new QButtonGroup(this);
    totalPages = (model->rowCount() + recordsPerPage - 1) / recordsPerPage;
    updateButtons();

    ui->scrollArea->setHorizontalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
    ui->scrollArea->setVerticalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
    ui->lineEdit_2->setFixedSize(56, 32);
    getname();
    ui->tableView->setVerticalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
    ui->tableView->setHorizontalScrollBarPolicy(Qt::ScrollBarAlwaysOff);

}
bachistoricalrecords::~bachistoricalrecords()
{
    delete ui;
}
void bachistoricalrecords::onDataChanged(const QModelIndex &topLeft, const QModelIndex &bottomRight)
{
    if (topLeft.column() == 0) {
        bool checked = model->data(topLeft, Qt::CheckStateRole).toBool();
        if (checked) {
            // 选中整行
            ui->tableView->selectRow(topLeft.row());
        } else {
            // 取消当前行的选中状态
            QItemSelectionModel *selectionModel = ui->tableView->selectionModel();
            selectionModel->select(topLeft, QItemSelectionModel::Deselect | QItemSelectionModel::Rows);
        }
    }
}



void bachistoricalrecords::onTableViewClicked(const QModelIndex &index)
{
    // 如果点击的是第一列，直接返回
    if (index.column() == 0) {
        return;
    }


    // 获取复选框索引
    QModelIndex checkBoxIndex = model->index(index.row(), 0);
    // 切换复选框状态
    bool isChecked = model->data(checkBoxIndex, Qt::CheckStateRole).toBool();
    model->setData(checkBoxIndex, !isChecked ? Qt::Checked : Qt::Unchecked, Qt::CheckStateRole);
    // 确保整行选择状态与复选框状态一致
    if (!isChecked) {
        ui->tableView->selectRow(index.row());
    } else {
        ui->tableView->selectionModel()->select(index, QItemSelectionModel::Deselect | QItemSelectionModel::Rows);
    }

}

void bachistoricalrecords::onHeaderCheckStateChanged(Qt::CheckState state)
{
    model->setAllCheckState(state);
    if (state == Qt::Checked) {
        for (int i = 0; i < model->rowCount(); ++i) {
            ui->tableView->selectRow(i);
            ui->tableView->selectAll();
        }
    } else {
        ui->tableView->clearSelection();
    }
}
void bachistoricalrecords::getname()
{/*
    QString queryString2 = QString("SELECT id FROM users");
    QSqlQuery mquery2;
    if (!mquery2.exec(queryString2)) {


    }
    while (mquery2.next()) {
        QVariant value = mquery2.value(0);
        ui->comboBox->addItem(value.toString());
    }*/

}
void bachistoricalrecords::getshuaxin()
{
    qDebug()<<"刷新了";
    QTimer::singleShot(100,this,[=](){shuaxin();});
}
void bachistoricalrecords::shanchu(const QModelIndex& index)
{
      qDebug() << "删除按钮被点击，行: " << index.row() << " 列: " << index.column();

    int result = QMessageBox::information(NULL, "提示", "确定要删除本行内容吗", QMessageBox::Ok | QMessageBox::Cancel);
    if (result == QMessageBox::Ok) {

        if (model->removeRow(index.row())) {
            if (model->submitAll()) {
                shuaxin();  // 重置视图，强制刷新界面显示

            } else {

            }
        } else {

        }
    }
}
//刷新字段
void bachistoricalrecords::shuaxin()
{

    // ui->lineEdit_3->setText("2025-01-01");

    // // ...
    // // 获取当前日期
    // QDate currentDate = QDate::currentDate();
    // // 日期加一天
    // QDate nextDay = currentDate.addDays(1);
    // // 将加一天后的日期以 "yyyy-MM-dd" 格式转为字符串并设置到 lineEdit_4 中
    // ui->lineEdit_4->setText(nextDay.toString("yyyy-MM-dd"));


    // QSqlQuery query;

    // QString str=QString("SELECT * FROM xijun WHERE  time BETWEEN '%1' AND '%2' ")

    //                   .arg(ui->lineEdit_3->text())
    //                   .arg(ui->lineEdit_4->text());


    // qDebug() <<str;

    // query.prepare(str);
    // if (query.exec()) { // 确保查询执行成功
    //   //  model = new QSqlQueryModel; // 更新 model
    //     model->setQuery(query); // 先设置查询，这样模型就会包含查询结果
    model->setTable("xijun");
    ui->tableView->setModel(model);
    model->select();

        ui->tableView->show();


        model->setHeaderData(0, Qt::Horizontal, "序号");
        model->setHeaderData(1, Qt::Horizontal, "用户");
        model->setHeaderData(2, Qt::Horizontal, "原始照片");
        model->setHeaderData(3, Qt::Horizontal, "结果照片");
        model->setHeaderData(4, Qt::Horizontal, "计数");
        model->setHeaderData(5, Qt::Horizontal, "时间");
        model->setHeaderData(6, Qt::Horizontal, "操作");

            qDebug() << "Model row count: " << model->rowCount();
               totalPages = (model->rowCount() + recordsPerPage - 1) / recordsPerPage;
               QString s = "共" + QString::number(totalPages) + "页";
               ui->label_7->setText(s);

            for (int i=0;i<=model->rowCount() ;i++ ) {
                ui->tableView->setRowHeight(i,40);

            }

            for (int i=1;i<=7 ;i++ ) {
                ui->tableView->setColumnWidth(i,275);

            }



            ui->tableView->setColumnWidth(0,80);



    // } else {

    //     qDebug() << "Query failed:" << query.lastError().text();
    // }


}

//pdf导出
void bachistoricalrecords::on_pushButton_2_clicked()
{
    // QAbstractItemModel *model = ui->tableView->model();
    // if (!model) {
    //     qDebug() << "No model set on the table view.";
    //     return;
    // }

    // // 获取选中的行
    // QItemSelectionModel *selectionModel = ui->tableView->selectionModel();
    // QModelIndexList selectedRows = selectionModel->selectedRows();
    // if (selectedRows.isEmpty()) {
    //     qDebug() << "No rows selected.";
    //     return;
    // }

    // QString filePath = QFileDialog::getSaveFileName(this, "Export to CSV", "", "CSV Files (*.csv)");
    // qDebug() << filePath;

    // if (filePath.isEmpty()) {
    //     return;
    // }

    // QFile file(filePath);
    // if (!file.open(QIODevice::WriteOnly | QIODevice::Text)) {
    //     qDebug() << "Could not open file for writing:" << file.errorString();
    //     return;
    // }

    // QTextStream out(&file);

    // // 写入表头（可选），跳过第七列（索引为6）
    // int columnCount = model->columnCount();
    // for (int col = 0; col < columnCount; ++col) {
    //     if (col == 6) {
    //         continue;
    //     }
    //     out << model->headerData(col, Qt::Horizontal, Qt::DisplayRole).toString();
    //     if (col < columnCount - 1 && col != 6) {
    //         out << ",";
    //     }
    // }
    // out << "\n";

    // // 写入选中行的数据，跳过第七列（索引为6）
    // for (const QModelIndex &index : selectedRows) {
    //     int row = index.row();
    //     for (int col = 0; col < columnCount; ++col) {
    //         if (col == 6) {
    //             continue;
    //         }
    //         QVariant data = model->data(model->index(row, col), Qt::DisplayRole);
    //         out << data.toString().replace(",", ";");
    //         if (col < columnCount - 1 && col != 6) {
    //             out << ",";
    //         }
    //     }
    //     out << "\n";
    // }

    // file.close();
    // qDebug() << "Selected data exported to CSV successfully.";
    // 获取选中的行
    QItemSelectionModel *selectionModel = ui->tableView->selectionModel();
    QModelIndexList selectedRows = selectionModel->selectedRows();

    if (selectedRows.isEmpty()) {
        qDebug() << "没有选中任何行";
            QMessageBox::warning(this, "导出失败", "未选中任何行。");
        return;
    }

    // 弹出文件保存对话框，获取用户选择的PDF文件路径
    QString filePath = QFileDialog::getSaveFileName(this, "保存PDF文件", "", "PDF文件 (*.pdf)");
    if (filePath.isEmpty()) {
        qDebug() << "用户取消保存";
        return;
    }

    // 创建QPrinter对象，设置输出格式为PDF
    QPrinter printer(QPrinter::HighResolution);
    printer.setOutputFormat(QPrinter::PdfFormat);
    printer.setOutputFileName(filePath);

    // 创建QPainter对象，用于绘制PDF内容
    QPainter painter;
    if (!painter.begin(&printer)) {
        qDebug() << "无法创建PDF文件";
        return;
    }

    // 列宽设置
    const int columnWidths[] = {300, 450, 2800, 2800, 400, 1500}; // 一到七列宽度
    int columnSpacing = 100; // 列间距
    int x = 400; // 起始横坐标
    int y = 400; // 起始纵坐标
    int lineHeight = 150; // 文字行高
    int rowHeight = 2800; // 修改行高度为3000
    int rowSpacing = 300; // 行间距300
    int currentPage = 1;
    int totalPages = (selectedRows.size() + 3) / 4; // 一页存放四条数据，重新计算总页数

    // 绘制表头
    QStringList headers = {"序号", "用户", "原始照片", "结果照片", "计数", "时间"};
    for (int col = 0; col < headers.size(); ++col) {
        painter.drawText(x, y, columnWidths[col], lineHeight, Qt::AlignCenter, headers[col]);
        x += columnWidths[col] + columnSpacing;
    }
    y += 500; // 表头高度
    x = 400;

    // 遍历选中的行，分页绘制
    for (int rowIndex = 0; rowIndex < selectedRows.size(); ++rowIndex) {
        const QModelIndex &index = selectedRows[rowIndex];
        QStringList rowData;
        for (int col = 0; col < model->columnCount(); ++col) {
            QModelIndex cellIndex = model->index(index.row(), col);
            rowData << model->data(cellIndex).toString();
        }

        // 绘制行数据
        x = 400;
        for (int col = 0; col < rowData.size(); ++col) {
            if (col == 2 || col == 3) { // 图片列
                QString imagePath = rowData[col];
                QPixmap pixmap(imagePath);
                if (!pixmap.isNull()) {
                    pixmap = pixmap.scaled(columnWidths[col], columnWidths[col],
                                           Qt::KeepAspectRatio, Qt::SmoothTransformation);
                    painter.drawPixmap(x, y - lineHeight, pixmap);
                }
            } else {
                painter.drawText(x, y, columnWidths[col], lineHeight,
                                 Qt::AlignCenter, rowData[col]);
            }
            x += columnWidths[col] + columnSpacing;
        }

        y += rowHeight + rowSpacing; // 加上行间距
        x = 400;

        // 分页处理
        if ((rowIndex + 1) % 4 == 0 || rowIndex == selectedRows.size() - 1) {
            // 绘制页码
            QString pageText = QString("第 %1 页 共 %2 页").arg(currentPage).arg(totalPages);
            painter.drawText(4300, y + 100, pageText);

            if (rowIndex != selectedRows.size() - 1) {
                printer.newPage();
                y = 400;
                currentPage++;

                // 重新绘制表头
                x = 400;
                for (int col = 0; col < headers.size(); ++col) {
                    painter.drawText(x, y, columnWidths[col], lineHeight,
                                     Qt::AlignCenter, headers[col]);
                    x += columnWidths[col] + columnSpacing;
                }
                y += 500;
                x = 400;
            }
        }
    }

    painter.end();
    qDebug() << "PDF文件已保存到: " << filePath;
      QMessageBox::information(this, "导出","导出成功");
}

void bachistoricalrecords::onCellClicked(const QModelIndex &index) {
    if (!model) {
        qDebug() << "Model is null!";
        return;
    }
    // 检查是否点击了第三行（索引为 2）或第四行（索引为 3）
    if (index.column() == 2 || index.column() == 3) {
        int curRecNo = index.row();
        QSqlRecord curRec = model->record(curRecNo);
        qDebug() << "Record values:";
        for (int i = 0; i < curRec.count(); ++i) {
            qDebug() << curRec.fieldName(i) << ": " << curRec.value(i).toString();
        }
        // 获取 "yuanshi" 和 "jieguo" 字段的值
        QString yuanshi = curRec.value("yuanshi").toString();
        QString jieguo = curRec.value("jieguo").toString();
        qDebug() << "yuanshi:" << yuanshi;
        qDebug() << "jieguo:" << jieguo;
        // 发送信号 lujing，传递 yuanshi 和 jieguo 的值
        emit lujing(yuanshi, jieguo);

        mask_window.setWindowOpacity(0.2);
        mask_window.setStyleSheet("background-color: black;");
        mask_window.setGeometry(0, 0, 1920, 1080);
        mask_window.setWindowFlags(Qt::FramelessWindowHint);
        mask_window.show();

        m_maxtu->setWindowModality(Qt::ApplicationModal);
        m_maxtu->show();
    }
}

// void bachistoricalrecords::onCellClicked(const QModelIndex &index) {
//     if (!model) {
//         qDebug() << "Model is null!";
//         return;
//     }
//     if (index.column() == 2 || index.column() == 3) {
//         int curRecNo = index.row();
//         QSqlRecord curRec = model->record(curRecNo);
//         qDebug() << "Record values:";
//         for (int i = 0; i < curRec.count(); ++i) {
//             qDebug() << curRec.fieldName(i) << ": " << curRec.value(i).toString();
//         }
//         QString fieldName = (index.column() == 2) ? "yuanshi" : "jieguo";
//         QString lu = curRec.value(fieldName).toString();
//         qDebug() << "lu:" << lu;
//         emit lujing(lu);
//         mask_window.setWindowOpacity(0.2);
//         mask_window.setStyleSheet("background-color: black;");
//         mask_window.setGeometry(0, 0, 1920, 1080);
//         mask_window.setWindowFlags(Qt::FramelessWindowHint);
//         mask_window.show();
//         m_maxtu->setWindowModality(Qt::ApplicationModal);
//         m_maxtu->show();
//     }
// }
// void bachistoricalrecords::onCellClicked(const QModelIndex &index) {
//     if (!model) {
//         qDebug() << "Model is null!";
//         return;
//     }
//     // 检查是否点击了第三行或第四行
//     if (index.row() == 2 || index.row() == 3) {
//         int curRecNo = index.row();
//         QSqlRecord curRec = model->record(curRecNo);
//         qDebug() << "Record values:";
//         for (int i = 0; i < curRec.count(); ++i) {
//             qDebug() << curRec.fieldName(i) << ": " << curRec.value(i).toString();
//         }
//         // 获取 "yuanshi" 和 "jieguo" 字段的值
//         QString yuanshiValue = curRec.value("yuanshi").toString();
//         QString jieguoValue = curRec.value("jieguo").toString();
//         qDebug() << "yuanshi:" << yuanshiValue;
//         qDebug() << "jieguo:" << jieguoValue;
//         // 发送信号 lujing 和 lujing2
//         emit lujing(yuanshiValue);
//         emit lujing2(jieguoValue);
//         mask_window.setWindowOpacity(0.2);
//         mask_window.setStyleSheet("background-color: black;");
//         mask_window.setGeometry(0, 0, 1920, 1080);
//         mask_window.setWindowFlags(Qt::FramelessWindowHint);
//         mask_window.show();
//         m_maxtu->setWindowModality(Qt::ApplicationModal);
//         m_maxtu->show();
//     }
// }
void bachistoricalrecords::on_pushButton_6_clicked()
{
    emit fanhui();
}

void bachistoricalrecords::on_toolButton_clicked()
{
    int result = QMessageBox::information(NULL, "提示", "确定要退出运行吗", QMessageBox::Ok| QMessageBox::Cancel);
    if (result == QMessageBox::Ok) {

        emit guan();
        emit tuichu2();
        QTimer::singleShot(500,this,[=](){qApp->quit();

        }) ;
    }
}




void bachistoricalrecords::handleErrorAndRelease(QAxObject *workbook, QAxObject *workbooks, QAxWidget *excel) {
    qDebug() << "操作出现错误，释放相关资源";
    if (workbook) {
        workbook->dynamicCall("Close()");
    }
    delete workbooks;
    delete excel;
}
void bachistoricalrecords::on_pushButton_3_clicked()
{
    m_date->move(200,170);
    m_date->exec();
}
void bachistoricalrecords::on_pushButton_5_clicked()
{
    m_datee->move(350,170);
    m_datee->exec();
}

void bachistoricalrecords::getkaishi(QString str)
{

    ui->lineEdit_3->setText(str);

}
void bachistoricalrecords::getkaishii(QString str)
{

    ui->lineEdit_4->setText(str);

}



void bachistoricalrecords::onPageButtonClicked(int id) {
    currentPage = id;
    qDebug()<<id;
    updatePage();
     updateButtons();
}

void bachistoricalrecords::on_pushButton_10_clicked()
{
    if (currentPage > 1) {
        currentPage--;
        updatePage();
          updateButtons();
    } else {
        qDebug() << "已经是第一页，无法继续上一页操作";
    }
}


void bachistoricalrecords::on_pushButton_9_clicked()
{
    if (currentPage < totalPages) {
        currentPage++;
        updatePage();
         updateButtons();
    } else {
        qDebug() << "已经是最后一页，无法继续下一页操作";
    }
}

//跳转
void bachistoricalrecords::on_pushButton_11_clicked()
{
    bool ok;
    int page = ui->lineEdit_2->text().toInt(&ok);
    if (ok) {
        // 页码从 1 开始，所以减 1 转换为从 0 开始的索引
        int targetPage = page ;
        if (targetPage >= 0 && targetPage <= totalPages) {
            currentPage = targetPage;
            updatePage();
             updateButtons();
        } else {
            qDebug() << "输入的页码超出范围，请输入 1 到 " << totalPages << " 之间的页码";
        }
    } else {
        qDebug() << "输入的页码不合法，请输入一个有效的数字";
    }
}
//重置
void bachistoricalrecords::on_pushButton_4_clicked()
{

    shuaxin();
    updatePage();
    updateButtons();
}
//查询
void bachistoricalrecords::on_pushButton_clicked()
{

        QSqlQuery query;

        QString str=QString("SELECT * FROM xijun WHERE  time BETWEEN '%1' AND '%2' ")

                          .arg(ui->lineEdit_3->text())
                          .arg(ui->lineEdit_4->text());


        qDebug() <<str;

        query.prepare(str);
        if (query.exec()) { // 确保查询执行成功

            model->setQuery(query); // 先设置查询，这样模型就会包含查询结果


            ui->tableView->setModel(model);
            ui->tableView->show();

            model->setHeaderData(0, Qt::Horizontal, "序号");
            model->setHeaderData(1, Qt::Horizontal, "用户");
            model->setHeaderData(2, Qt::Horizontal, "原始照片");
            model->setHeaderData(3, Qt::Horizontal, "结果照片");
            model->setHeaderData(4, Qt::Horizontal, "计数");
            model->setHeaderData(5, Qt::Horizontal, "时间");
            model->setHeaderData(6, Qt::Horizontal, "操作");

            totalPages = (model->rowCount() + recordsPerPage - 1) / recordsPerPage;
            QString s = "共" + QString::number(totalPages) + "页";
            ui->label_7->setText(s);
            for (int i = 0; i <= model->rowCount(); i++) {
                ui->tableView->setRowHeight(i, 40);
            }

            updateButtons();

            qDebug() << "Model row count: " << model->rowCount();
            for (int i=0;i<=model->rowCount() ;i++ ) {
                ui->tableView->setRowHeight(i,40);

            }

            for (int i=0;i<=7 ;i++ ) {
                ui->tableView->setColumnWidth(i,275);

            }
            ui->tableView->setColumnWidth(0,80);
        } else {

            qDebug() << "Query failed:" << query.lastError().text();
        }

}


// void bachistoricalrecords::updateButtons()
// {
//     QLayoutItem *item;
//     while ((item = buttonLayout->takeAt(0)) != nullptr) {
//         delete item->widget();
//         delete item;
//     }

//     int startPage = std::max(1, currentPage - 4); // 计算起始页
//     int endPage = std::min(totalPages, startPage + 9); // 计算结束页

//     // 确保当前页在第五个位置
//     if (endPage - startPage < 9 && currentPage - 4 > 0) {
//         startPage = std::max(1, currentPage - (9 - (endPage - startPage)));
//         endPage = std::min(totalPages, startPage + 9);
//     }

//     for (int i = startPage; i <= endPage; i++) {
//         QPushButton *button = new QPushButton(QString::number(i), this);
//         buttonLayout->addWidget(button);
//         buttonGroup->addButton(button, i);

//         // 设置当前页按钮样式
//         if (i == currentPage) {
//             button->setStyleSheet("QPushButton {color:rgb(0, 170, 255); }");
//         } else {
//             button->setStyleSheet("");
//         }


//         // 连接按钮点击信号到槽函数
//         connect(button, &QPushButton::clicked, this, [=]() {
//             currentPage = i;
//             updatePage();
//             updateButtons(); // 更新按钮样式
//         });
//     }

//     for (int i = 0; i <= model->rowCount(); ++i) {
//         ui->tableView->setRowHeight(i, 40);
//     }

//     for (int i = 0; i <= 7; ++i) {
//         ui->tableView->setColumnWidth(i, 275);
//     }
//     ui->tableView->setColumnWidth(0, 80);

// }
// void bachistoricalrecords::updateButtons()
// {
//     QLayoutItem *item;
//     while ((item = buttonLayout->takeAt(0)) != nullptr) {
//         delete item->widget();
//         delete item;
//     }

//     int startPage = std::max(1, currentPage - 4); // 计算起始页
//     int endPage = std::min(totalPages, startPage + 9); // 计算结束页

//     // 确保当前页在第五个位置
//     if (endPage - startPage < 9 && currentPage - 4 > 0) {
//         startPage = std::max(1, currentPage - (9 - (endPage - startPage)));
//         endPage = std::min(totalPages, startPage + 9);
//     }

//     int buttonCount = 0; // 用于记录按钮个数
//     for (int i = startPage; i <= endPage; i++) {
//         QPushButton *button = new QPushButton(QString::number(i), this);
//         buttonLayout->addWidget(button);
//         buttonGroup->addButton(button, i);

//         // 设置当前页按钮样式
//         if (i == currentPage) {
//             button->setStyleSheet("QPushButton {color:rgb(0, 170, 255); }");
//         } else {
//             button->setStyleSheet("");
//         }

//         // 连接按钮点击信号到槽函数
//         connect(button, &QPushButton::clicked, this, [=]() {
//             currentPage = i;
//             updatePage();
//             updateButtons(); // 更新按钮样式
//         });
//         buttonCount++;
//     }

//     // 根据按钮个数设置 scrollArea 的宽度
//     if (buttonCount == 1) {
//         ui->scrollArea->setFixedWidth(30);
//     } else if (buttonCount == 2) {
//         ui->scrollArea->setFixedWidth(60);
//     }

//     for (int i = 0; i <= model->rowCount(); ++i) {
//         ui->tableView->setRowHeight(i, 40);
//     }

//     for (int i = 0; i <= 7; ++i) {
//         ui->tableView->setColumnWidth(i, 275);
//     }
//     ui->tableView->setColumnWidth(0, 80);
// }
void bachistoricalrecords::updateButtons()
{
    QLayoutItem *item;
    while ((item = buttonLayout->takeAt(0)) != nullptr) {
        delete item->widget();
        delete item;
    }

    int startPage = std::max(1, currentPage - 4); // 计算起始页
    int endPage = std::min(totalPages, startPage + 9); // 计算结束页

    // 确保当前页在第五个位置
    if (endPage - startPage < 9 && currentPage - 4 > 0) {
        startPage = std::max(1, currentPage - (9 - (endPage - startPage)));
        endPage = std::min(totalPages, startPage + 9);
    }

    int buttonCount = 0; // 用于记录按钮个数
    for (int i = startPage; i <= endPage; i++) {
        QPushButton *button = new QPushButton(QString::number(i), this);
        buttonLayout->addWidget(button);
        buttonGroup->addButton(button, i);

        // 设置当前页按钮样式
        if (i == currentPage) {
            button->setStyleSheet("QPushButton {color:rgb(0, 170, 255); }");
        } else {
            button->setStyleSheet("");
        }

        // 连接按钮点击信号到槽函数
        connect(button, &QPushButton::clicked, this, [=]() {
            currentPage = i;
            updatePage();
            updateButtons(); // 更新按钮样式
        });
        buttonCount++;
    }

    // 根据按钮个数设置 scrollArea 的宽度
    if (buttonCount >= 1 && buttonCount <= 10) {
        ui->scrollArea->setFixedWidth(buttonCount * 40);
    }

    for (int i = 0; i <= model->rowCount(); ++i) {
        ui->tableView->setRowHeight(i, 40);
    }

    for (int i = 0; i <= 7; ++i) {
        ui->tableView->setColumnWidth(i, 275);
    }
    ui->tableView->setColumnWidth(0, 80);
}
void bachistoricalrecords::updatePage()
{
    if (model) {
        int startIndex = (currentPage - 1) * recordsPerPage;
        int endIndex = std::min(startIndex + recordsPerPage, model->rowCount());
        for (int i = 0; i < model->rowCount(); ++i) {
            ui->tableView->setRowHidden(i, i < startIndex || i >= endIndex);
        }
        for (int i = 0; i <= model->rowCount(); ++i) {
            ui->tableView->setRowHeight(i, 40);
        }
        for (int i = 0; i <= 7; ++i) {
            ui->tableView->setColumnWidth(i, 275);
        }
        ui->tableView->setColumnWidth(0, 80);
    }
}