#include "problemrectificationresult.h"
#include "ui_problemrectificationresult.h"
#include <QMessageBox>
#include <QSqlQuery>
#include <QSqlError>
#include <QDebug>

#pragma execution_character_set("utf-8")

ProblemRectificationResult::ProblemRectificationResult(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::ProblemRectificationResult)
{
    ui->setupUi(this);
    initUi();
}

ProblemRectificationResult::~ProblemRectificationResult()
{
    delete ui;
}

void ProblemRectificationResult::initUi()
{
    ui->tableWidget->setSpan(0,0,1,5);
    ui->tableWidget->setItem(0,0,new QTableWidgetItem("整改成果"));
    ui->tableWidget->item(0,0)->setTextAlignment(Qt::AlignCenter);

    ui->tableWidget->setSpan(1,0,1,2);
    ui->tableWidget->setItem(1,0,new QTableWidgetItem("制度建设"));
    ui->tableWidget->item(1,0)->setTextAlignment(Qt::AlignCenter);
    ui->tableWidget->setSpan(1,2,1,3);
    ui->tableWidget->setItem(1,2,new QTableWidgetItem("资金收回"));
    ui->tableWidget->item(1,2)->setTextAlignment(Qt::AlignCenter);
    ui->tableWidget->setSpan(0,5,3,1);
    ui->tableWidget->setItem(0,5,new QTableWidgetItem("处理人"));
    ui->tableWidget->setSpan(0,6,3,1);
    ui->tableWidget->setItem(0,6,new QTableWidgetItem("宣贯培训"));
    ui->tableWidget->setSpan(0,7,3,1);
    ui->tableWidget->setItem(0,7,new QTableWidgetItem("其他"));
    ui->tableWidget->setSpan(0,8,3,1);
    ui->tableWidget->setItem(0,8,new QTableWidgetItem("审核结果"));
    ui->tableWidget->setSpan(0,9,3,1);
    ui->tableWidget->setItem(0,9,new QTableWidgetItem("注销"));

    // 下级标题
    ui->tableWidget->setItem(2,0,new QTableWidgetItem("修订制度"));
    ui->tableWidget->setItem(2,1,new QTableWidgetItem("新增制度"));
    ui->tableWidget->setItem(2,2,new QTableWidgetItem("挽回损失"));
    ui->tableWidget->setItem(2,3,new QTableWidgetItem("剔除"));
    ui->tableWidget->setItem(2,4,new QTableWidgetItem("审减"));

    // 禁止编辑
    for(int i=0;i<3;++i){
        ui->tableWidget->setItemDelegateForRow(i,new TableItemDelegate());
    }

    // 右键菜单
    m_menu = new QMenu(this);
    m_menu->addAction("删除当前行");
    ui->tableWidget->setContextMenuPolicy(Qt::CustomContextMenu);
    connect(ui->tableWidget,SIGNAL(customContextMenuRequested(QPoint)),this,SLOT(showMenuSlot(QPoint)));
    connect(m_menu->actions().at(0),SIGNAL(triggered(bool)),this,SLOT(deleteAction()));

    // 加载下拉框的公司名
    readCompanyFromSQL();

}

void ProblemRectificationResult::readCompanyFromSQL()
{
    ui->comboBox_company->clear();

    QString sql = "select DISTINCT name from all_company_info";
    QSqlQuery query;
    if(query.exec(sql)){
        qDebug()<<QString("select DISTINCT all_company_info ok");

        while(query.next()){ // 添加公司名
            QString name = query.value(0).toString();
            ui->comboBox_company->addItem(name);
        }

    }else{
        qDebug()<<QString("select all_company_info fail...")<<query.lastError().text();

    }
}

void ProblemRectificationResult::showMenuSlot(QPoint){
    m_menu->exec(QCursor::pos());
}

void ProblemRectificationResult::deleteAction(){

    int row = ui->tableWidget->currentRow();
    if(row>=3){
        qDebug()<<"ok";
        ui->tableWidget->removeRow(row);
    }else{
        qDebug()<<"fail";
    }
}

void ProblemRectificationResult::on_pushButton_addRow_clicked()
{
    ui->tableWidget->insertRow(ui->tableWidget->rowCount());
}

void ProblemRectificationResult::on_pushButton_save_clicked()
{
    QString sql = QString("insert into rectify_result_info (name,修订制度,新增制度,挽回损失,剔除,审减,处理人,宣贯培训,其他,审核结果,注销) values ");
    QString name = ui->comboBox_company->currentText();

    for(int i=3;i<ui->tableWidget->rowCount();++i){
        QStringList labels;

        for(int j=0;j<ui->tableWidget->columnCount();++j){
            QTableWidgetItem *item = ui->tableWidget->item(i,j);;
            qDebug() <<i<<j <<item;
            if(item){
                qDebug()<<"OK";
                labels<<item->data(Qt::EditRole).toString();
            }else{
                labels<<" ";
            }
        }
        qDebug()<<labels;
        if(labels.at(0)==" ")continue;
        if(name.size()==0){
            QMessageBox::information(this,"单位信息为空 ","请输入单位名称");
            continue;
        }
        sql += QString("('%1',").arg(name);
        for(int k=0;k<labels.size()-1;++k){
            sql += QString("'%1',").arg(labels[k]);
        }
        sql += QString("'%1'),").arg(labels.back());
    }
    sql = sql.left(sql.size()-1); // 去掉最后一个逗号
    qDebug()<<"sql="<<sql;
    QSqlQuery query;
    if(query.exec(sql))
    {
      qDebug()<<QString("insert  rectify_result_info ok...");
      QMessageBox::information(this,"OK","添加成功");
    }else{
      qDebug()<<QString("insert rectify_result_info fail...")<<query.lastError().text();
      QMessageBox::information(this,"添加失败","可能添加的数据不全导致的，得确认每行的首项有数据");
    }
}

void ProblemRectificationResult::on_comboBox_company_currentIndexChanged(const QString &arg1)
{
    // 要清除上一家公司的数据
    ui->tableWidget->setRowCount(3);
    ui->tableWidget->setRowCount(6);
    // 加载表格信息
    qDebug()<<"current :"<<arg1;

    QString sql = QString("select * from rectify_result_info where name='%1'").arg(arg1);
    QSqlQuery query;
    if(query.exec(sql)){
        qDebug()<<QString("select rectify_result_info ok");
        int row=0;
        while(query.next()){ // 添加行数据
            for(int i=0;i<10;++i){
                ui->tableWidget->setItem(row+3,i,new QTableWidgetItem(query.value(2+i).toString()));
            }
            row++;
            ui->tableWidget->setRowCount(ui->tableWidget->rowCount()+1); // 增加一个新的行
        }
        qDebug()<<"row:"<<row;

    }else{
        qDebug()<<QString("select rectify_result_info fail...")<<query.lastError().text();

    }
}