SpeedNumCube/sncprojects/lib/SNCRiddle/formshkjfinished.cpp

#include "formshkjfinished.h"
#include "ui_formshkjfinished.h"
#include "shkjdb.h"
#include "sncdatabase.h"
#include "respdlshkjresultfile.h"
#include "respuserserviceverify.h"
#include "dialogsubmitresponsedetail.h"
#include "xprogressbar.h"
#include "dialogsubmit.h"
FormShkjFinished::FormShkjFinished(QWidget *parent) :
    QWidget(parent),
    ui(new Ui::FormShkjFinished)
{
    ui->setupUi(this);
    initVariables();
    initUI();
    setTableWidgetNoData(ui->tableWidget);
}

FormShkjFinished::~FormShkjFinished()
{
    m_movieBig->stop();
    delete m_movieBig;
    m_movie->stop();
    delete m_movie;
    m_cubews->abort();
    delete m_cubews;
    delete ui;
    qDebug()<<QDateTime::currentDateTime().toString("yyyy-MM-dd HH:mm:ss")\
           <<"FormRiddle.FormShkjFinished Destroyed.";
}
void FormShkjFinished::initVariables()
{
    m_movie = new QMovie(":/working.gif");
    m_movie->start();

    m_movieBig = new QMovie(":/fetchfromserver.gif");
    m_movieBig->start();

    m_keys<<"ltfid"<<"dealstatus"<<"detail"<<"uqrycode"<<"hmzs"\
          <<"ltf_tj"<<"ltf_list"<<"forecast_tj"<<"forecast_list"\
         <<"inserttime"<<"finishtime";
    m_keysUpload<<"fileid"<<"uploadstate"<<"filename"<<"memo"<<"hmzs"<<"shzs"<<"srvrtime"<<"percent"<<"opt"\
               <<"filepath"<<"rtnmsg"<<"rtndetail"<<"optstatus";
    m_keysDealing<<"dealstatus"<<"uqrycode"<<"hmzs"<<"inserttime"<<"finishtime"<<"detail";
    m_keysFinished<<"ltfid"<<"dealstatus"<<"detail"<<"memo"<<"hmzs"<<"shzs"<<"inserttime"<<"finishtime"<<"opt"\
          <<"ltf_tj"<<"ltf_list"<<"forecast_tj"<<"forecast_list"<<"uqrycode";
    m_state = NotLogin;
    m_headers<<""<<"状态"<<"原始文件"<<"备注信息"<<"号码总数"<<"实号总数"<<"提交时间"<<"耗时(秒)"<<"操作"<<"实时快检统计"\
            <<"实时快检列表"<<"预检统计"<<"预检列表"<<"uqrycode";

    m_curLtfid = "";
    m_curQryid = "";
    m_lastLtfid = "";

    m_cubews = new WSCube2();
}
void FormShkjFinished::setAccountInfo(QMap<QString, QString> info)
{
    m_account = info;
    QString ssoHash = info.value("ssohash");

    if(!ssoHash.isEmpty())
    {
        m_state = LoginOk;
        setTableWidgetSyncData(ui->tableWidget);
    }
    else
    {
        m_state = NotLogin;
    }
    if(m_state!=LoginOk)
    {
        setTableWidgetNoData(ui->tableWidget);
        setDetailNoData();
    }
}

void FormShkjFinished::initUI()
{
    ui->tableWidget->setColumnCount(m_headers.size());
    ui->tableWidget->setHorizontalHeaderLabels(m_headers);

    ui->tableWidget->setEditTriggers(QAbstractItemView::NoEditTriggers);
    ui->tableWidget->setShowGrid(false);
    ui->tableWidget->setAlternatingRowColors(true);
    ui->tableWidget->setSelectionBehavior(QAbstractItemView::SelectRows);
    ui->tableWidget->setSelectionMode(QAbstractItemView::SingleSelection);
    ui->tableWidget->verticalHeader()->setVisible(false);
    ui->tableWidget->horizontalHeader()->setStyleSheet("font:12px");
    ui->tableWidget->horizontalHeader()->setResizeMode(QHeaderView::Fixed);
    ui->tableWidget->verticalHeader()->setResizeMode(QHeaderView::Fixed);
    ui->tableWidget->setHorizontalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
    ui->tableWidget->setVerticalScrollBarPolicy(Qt::ScrollBarAlwaysOn);
    ui->tableWidget->verticalHeader()->setFixedWidth(30);
    ui->tableWidget->setSortingEnabled(true);

    int col = 0;
    ui->tableWidget->setColumnWidth(col++,20);
    ui->tableWidget->setColumnWidth(col++,30);
    ui->tableWidget->setColumnWidth(col++,160);
    ui->tableWidget->setColumnWidth(col++,95);//
    ui->tableWidget->setColumnWidth(col++,65);
    ui->tableWidget->setColumnWidth(col++,65);
    ui->tableWidget->setColumnWidth(col++,125);
    ui->tableWidget->setColumnWidth(col++,60);
    ui->tableWidget->setColumnWidth(col++,54);
    ui->tableWidget->setColumnWidth(col++,0);
    ui->tableWidget->setColumnWidth(col++,0);//
    ui->tableWidget->setColumnWidth(col++,0);
    ui->tableWidget->setColumnWidth(col++,0);
    ui->tableWidget->setColumnWidth(col++,0);



    //初始化实号快检结果框背景显示图片quick_default_bg.jpg，通过qss文件里进行设置
    ui->widgetQuicikCheck->setProperty("class","highframe");
    ui->widgetExactCheck->setProperty("class","lowframe");

    //初始化快速检测 实号和未知状态的对应的显示图片quick_result_bg.jpg
    QPixmap quick_result_bg(":/quick_result_bg.jpg");
    int nHeight = quick_result_bg.height()/2;
    int nWidth = quick_result_bg.width();
    ui->labelBarShiHao->setPixmap(quick_result_bg.copy(QRect(0 , 1 * nHeight, nWidth, nHeight)));
    ui->labelBarWeizhi->setPixmap(quick_result_bg.copy(QRect(0 , 0 * nHeight, nWidth, nHeight)));

    //初始化预检测 实号、空、停、关机对应的显示图片forcast_result_bg.jpg
    QPixmap forcast_result_bg(":/forcast_result_bg.jpg");
    nHeight = forcast_result_bg.height()/4;
    nWidth = forcast_result_bg.width();
    ui->labelBarShiHao2->setPixmap(forcast_result_bg.copy(QRect(0 , 0 * nHeight, nWidth, nHeight)));
    ui->labelBarKong->setPixmap(forcast_result_bg.copy(QRect(0 , 1 * nHeight, nWidth, nHeight)));
    ui->labelBarTing->setPixmap(forcast_result_bg.copy(QRect(0 , 2 * nHeight, nWidth, nHeight)));
    ui->labelBarGuan->setPixmap(forcast_result_bg.copy(QRect(0 , 3 * nHeight, nWidth, nHeight)));

    //初始化图例图标实号、空、停、关机对应的显示图片sample_small.jpg
    QPixmap sample_small(":/sample_small.jpg");
    nHeight = sample_small.height();
    nWidth = sample_small.width()/10;
    ui->labelSampleShiHao->setPixmap(sample_small.copy(QRect(0 * nWidth , 0 , nWidth, nHeight)));
    ui->labelSampleWeizhi->setPixmap(sample_small.copy(QRect(1 * nWidth , 0 , nWidth, nHeight)));
    ui->labelSampleShiHao2->setPixmap(sample_small.copy(QRect(2 * nWidth , 0 , nWidth, nHeight)));
    ui->labelSampleKong->setPixmap(sample_small.copy(QRect(3 * nWidth , 0 , nWidth, nHeight)));
    ui->labelSampleTing->setPixmap(sample_small.copy(QRect(4 * nWidth , 0 , nWidth, nHeight)));
    ui->labelSampleGuan->setPixmap(sample_small.copy(QRect(5 * nWidth , 0 , nWidth, nHeight)));

    //初始化分割线
    ui->labelSplitLine->setStyleSheet("background:#dadedf");
    ui->labelSplitLine->setFixedHeight(1);

    //设置上述状态比例的默认宽度为0
    ui->labelBarShiHao->setFixedWidth(0);
    ui->labelBarWeizhi->setFixedWidth(0);
    ui->labelBarShiHao2->setFixedWidth(0);
    ui->labelBarKong->setFixedWidth(0);
    ui->labelBarTing->setFixedWidth(0);
    ui->labelBarGuan->setFixedWidth(0);

}

void FormShkjFinished::setTableWidgetNoData(QTableWidget *tableWidget)
{
    prepareTableWidgetCells(tableWidget,10);
    tableWidget->setEnabled(false);
    QTableWidgetItem *item = new QTableWidgetItem();
    item->setTextAlignment(Qt::AlignRight|Qt::AlignVCenter);
    item->setText("暂无信息");
    tableWidget->setItem(5,4,item);
}

void FormShkjFinished::setTableWidgetSyncData(QTableWidget *tableWidget)
{
    prepareTableWidgetCells(tableWidget,10);
    tableWidget->setEnabled(false);
    QLabel *lbl = new QLabel();

    QTableWidgetItem *item = new QTableWidgetItem("正在读取...");
    lbl->setMovie(m_movieBig);
    lbl->setAlignment(Qt::AlignCenter|Qt::AlignVCenter);
    item->setTextAlignment(Qt::AlignRight|Qt::AlignVCenter);
    tableWidget->setItem(5,4,item);
    tableWidget->setCellWidget(5,3,lbl);
}

void FormShkjFinished::setDetailNoData()
{
    ui->labelShiHao->setText("实号");
    ui->labelKong->setText("空号");
    ui->labelTing->setText("停机");
    ui->labelGuan->setText("关机");
    ui->labelValidNum->setText("实号");
    ui->labelInvalidNum->setText("未知");

    //设置上述状态比例的默认宽度为0
    ui->labelBarShiHao->setFixedWidth(0);
    ui->labelBarWeizhi->setFixedWidth(0);
    ui->labelBarShiHao2->setFixedWidth(0);
    ui->labelBarKong->setFixedWidth(0);
    ui->labelBarTing->setFixedWidth(0);
    ui->labelBarGuan->setFixedWidth(0);

    ui->pushButtonDownload->setEnabled(false);
}

void FormShkjFinished::prepareTableWidgetCells(QTableWidget *tableWidget, int rows)
{
    tableWidget->setRowCount(0);
    tableWidget->setRowCount(rows);
}

void FormShkjFinished::fillDataList(QTableWidget *tableWidget,QStringList keys,
                                   QMultiMap<QString, QString> list, int rowCount)
{
    setTableWidgetNoData(tableWidget);
    if(rowCount==0)
    {
        return ;
    }
    prepareTableWidgetCells(tableWidget,rowCount);
    tableWidget->setEnabled(true);
    for(int row = 0;row < rowCount;row++)
    {
        QMap<QString,QString> map;
        for(int col=0;col<keys.size();col++)
        {
            QString key = keys.at(col);
            QString value = list.values(key).at(row);
            map.insert(key,value);
        }
        for(int col=0;col<keys.size();col++)
        {
            QString key = keys.at(col);
            QString value = list.values(key).at(row);
            setCellElement(tableWidget,row,col,key,value,map);
        }
    }
    tableWidget->sortByColumn(0);
    tableWidget->sortByColumn(0);
}

void FormShkjFinished::fillDataListUpload(QTableWidget *tableWidget, QStringList keys, QMultiMap<QString, QString> list, int rowCount)
{
    if(rowCount==0)
    {
        return ;
    }
    int startrow = ui->tableWidget->rowCount();
    appendRow(tableWidget,rowCount);
    tableWidget->setEnabled(true);
    for(int row = 0;row < rowCount;row++)
    {
        QMap<QString,QString> map;
        for(int col=0;col<keys.size();col++)
        {
            QString key = keys.at(col);
            QString value ;
            if(list.values(key).count()>row)
                value = list.values(key).at(row);
            map.insert(key,value);
        }
        for(int col=0;col<keys.size();col++)
        {
            QString key = keys.at(col);
            QString value ;
            if(list.values(key).count()>row)
                value = list.values(key).at(row);
            setCellElementUpload(tableWidget,startrow+row,col,key,value,map);
        }
    }
    //添加按钮
    for(int row = 0;row < rowCount;row++)
    {
        QPushButton *button = new QPushButton();
        button->setText("查看");
        button->setProperty("class","txt-green");
        button->setCursor(Qt::PointingHandCursor);
        connect(button,SIGNAL(clicked()),this,SLOT(onPushButtonViewsUploadClicked()));
        QTableWidgetItem *item = tableWidget->item(row+startrow,9);
        if(item)
        {
            if(item->data(Qt::UserRole).toString().isEmpty())
            {
                button->setEnabled(false);
            }
        }
        ui->tableWidget->setCellWidget(row+startrow,8,button);
    }
//    tableWidget->sortByColumn(0);
//    tableWidget->sortByColumn(0);
}

void FormShkjFinished::fillDataListDealing(QTableWidget *tableWidget, QStringList keys, QMultiMap<QString, QString> list, int rowCount)
{
    if(rowCount==0)
    {
        return ;
    }
    int startrow = tableWidget->rowCount();
    appendRow(tableWidget,rowCount);
    tableWidget->setEnabled(true);
    for(int row = 0;row < rowCount;row++)
    {
        QMap<QString,QString> map;
        for(int col=0;col<keys.size();col++)
        {
            QString key = keys.at(col);
            QString value ;
            if(list.values(key).count()>row)
                value = list.values(key).at(row);
            map.insert(key,value);
        }
        for(int col=0;col<keys.size();col++)
        {
            QString key = keys.at(col);
            QString value ;
            if(list.values(key).count()>row)
                value = list.values(key).at(row);
            setCellElementDealing(tableWidget,row+startrow,col,key,value,map);
        }
    }

    tableWidget->sortByColumn(0);
    tableWidget->sortByColumn(0);
}

void FormShkjFinished::fillDataListFinished(QTableWidget *tableWidget, QStringList keys, QMultiMap<QString, QString> list, int rowCount)
{

    int startrow = tableWidget->rowCount();
    appendRow(tableWidget,rowCount);
    tableWidget->setEnabled(true);
    for(int row = 0;row < rowCount;row++)
    {
        QMap<QString,QString> map;
        for(int col=0;col<keys.size();col++)
        {
            QString key = keys.at(col);
            QString value ;
            if(list.values(key).count()>row)
                value = list.values(key).at(row);
            map.insert(key,value);
        }
        for(int col=0;col<keys.size();col++)
        {
            QString key = keys.at(col);
            QString value ;
            if(list.values(key).count()>row)
                value = list.values(key).at(row);
            setCellElementFinished(tableWidget,row+startrow,col,key,value,map);
        }
    }
    //添加按钮
    for(int row = 0;row < rowCount;row++)
    {
        QPushButton *button = new QPushButton();
        button->setText("查看");
        button->setProperty("class","txt-green");
        button->setCursor(Qt::PointingHandCursor);
        connect(button,SIGNAL(clicked()),this,SLOT(onPushButtonViewsFinishedClicked()));
        QTableWidgetItem *item = tableWidget->item(row+startrow,9);
        if(item)
        {
            if(item->data(Qt::UserRole).toString().isEmpty())
            {
                button->setEnabled(false);
            }
        }
        ui->tableWidget->setCellWidget(row+startrow,8,button);
    }
    tableWidget->setEnabled(true);
    on_tableWidget_cellClicked(startrow, 2);
    ui->tableWidget->selectRow(startrow);
    ui->tableWidget->item(startrow,0)->setCheckState(Qt::Checked);
//    tableWidget->sortByColumn(0);
//    tableWidget->sortByColumn(0);
}
void FormShkjFinished::setCellElement(QTableWidget *tableWidget, int row, int col,
                                     QString key,QString value,QMap<QString,QString> data)
{
    QTableWidgetItem* item = new QTableWidgetItem();
    QVariant display = value;
    QVariant tooltip = value;
    item->setTextAlignment(Qt::AlignHCenter|Qt::AlignVCenter);
    //进行数据翻译

    if(key=="uqrycode")
    {
        tooltip = display;
    }
    else if(key=="ltfid")
    {
        tooltip = "";
        display = "";
        item->setCheckState(Qt::Unchecked);
    }
    else if(key=="dealstatus")
    {
        if(value=="2")
        {
            tooltip = "未下载";
        }
        else if(value=="3")
        {
            tooltip = "已下载";
        }
    }
    else if(key=="detail")
    {
        QStringList info = display.toString().split("\r\n");
        QString filename;
        if(info.size()>0)
        {
            if(info.at(0).split("：").size()>1)
            {
                filename = info.at(0).split("：").at(1);
            }
            display = filename;
        }
        item->setTextAlignment(Qt::AlignLeft|Qt::AlignVCenter);
    }
    else if(key=="ltfid")
    {
        display = "";
        tooltip = "";
        item->setCheckState(Qt::Unchecked);
    }
    else if(key=="hmzs")
    {
        display = value.toInt();
        QString ltfid = data.value("ltfid");
        QString fileName = QCoreApplication::applicationDirPath()+\
                QString("/../data/%1/cache/shkj/upload/%2.rtn").arg(m_account.value("usercode")).arg(ltfid);
        if(QFile::exists(fileName))
            item->setIcon(QIcon(":/yellow-information.png"));
        else
            item->setIcon(QIcon(":/blank.png"));
        item->setTextAlignment(Qt::AlignLeft|Qt::AlignVCenter);
        tooltip = "点击查看详情";
    }
    else if(key=="finishtime")
    {
        QDateTime inserttime =  QDateTime::fromString(data.value("inserttime"),"yyyy-MM-dd hh:mm:ss");
        QDateTime finishtime =  QDateTime::fromString(data.value("finishtime"),"yyyy-MM-dd hh:mm:ss");
        int seconds  = inserttime.msecsTo(finishtime)/1000 ;
        display = seconds;
        tooltip = display;
    }
    if(key == "dealstatus")
    {
        delete item;
        QLabel *lbl = new QLabel(this);
        lbl->setAlignment(Qt::AlignCenter|Qt::AlignHCenter);
        lbl->setProperty("value",value);
        if(value=="2")
        {
            lbl->setPixmap(QPixmap(":/todown.png"));
            lbl->setToolTip(tooltip.toString());
        }
        else if(value=="3")
        {
            lbl->setPixmap(QPixmap(":/task_ok.png"));
            lbl->setToolTip(tooltip.toString());
        }
        tableWidget->setCellWidget(row,col,lbl);
    }
    else
    {
        item->setData(Qt::DisplayRole,display);
        item->setData(Qt::UserRole,value);
        item->setData(Qt::ToolTipRole,tooltip);
        tableWidget->setItem(row,col,item);
    }


}

void FormShkjFinished::setCellElementUpload(QTableWidget *tableWidget, int row, int col, QString key, QString value, QMap<QString, QString> data)
{
    QTableWidgetItem* item = new QTableWidgetItem();
    QVariant display = value;
    QVariant tooltip = value;
    item->setTextAlignment(Qt::AlignHCenter|Qt::AlignVCenter);
    //进行数据翻译
    if(key=="filetype")
    {
        if(value=="1")
            display = "号码文件";
        else if(value=="2")
            display = "号段文件";
        else
            display = "未知";
        tooltip = display;
    }
    else if(key=="fileid")
    {
        display = "";
        tooltip = "";
        item->setCheckState(Qt::Unchecked);
    }
    else if(key=="filename")
    {
        QString filePath = data.value("filepath");
        QString fileMemo = data.value("memo");
        tooltip =  QString("文件：%1\r\n备注：%2").arg(filePath).arg(fileMemo);
        item->setTextAlignment(Qt::AlignLeft|Qt::AlignVCenter);
    }

    //设置单元格显示形式,是用item填充还是widget填充
    if(key=="uploadstate")
    {
        delete item;

        int uploadstate = value.toInt();
        QLabel *lbl = new QLabel();
        lbl->setAlignment(Qt::AlignCenter|Qt::AlignHCenter);
        lbl->setProperty("value",uploadstate);
        if(uploadstate < 0 )//上传失败，发生了错误
        {
            lbl->setPixmap(QPixmap(":/task_error.png"));
            lbl->setToolTip("上传失败，详细原因请点击查看按钮");
        }
        else if(uploadstate>=0 && uploadstate<3)//等待上传或上传中
        {
            lbl->setToolTip("正在上传，请稍候");
            lbl->setMovie(m_movie);
        }
        else if(uploadstate>3)//未知状态
        {
           lbl->setText("未知");
        }
        else  //(uploadstate == 3)
        {
            lbl->setPixmap(QPixmap(":/task_ok.png"));
            lbl->setToolTip("上传成功");
        }
        tableWidget->setCellWidget(row,col,lbl);
    }
    else if(key=="percent")
    {
        delete item;
        int uploadstate = data.value("uploadstate").toInt();
        double percent = value.toDouble();
        QLabel *lbl = new QLabel();
        lbl->setAlignment(Qt::AlignHCenter|Qt::AlignVCenter);
        XProgressBar *progress = 0;
        if(uploadstate<0)
        {
            lbl->setText("<font color=red>上传失败</>");
        }
        else if(uploadstate>=0 && uploadstate<3)//等待上传或上传中
        {
            delete lbl;
            lbl = 0;
            progress = new XProgressBar();
        }
        else
        {
            lbl->setText("上传成功");
        }
        if(lbl)
        {
            tableWidget->setCellWidget(row,col,lbl);
        }
        else
        {
            progress->setProgress(uploadstate,percent);
            tableWidget->setCellWidget(row,col,progress);
        }
    }
    else
    {
        item->setData(Qt::DisplayRole,display);
        item->setData(Qt::UserRole,value);
        item->setData(Qt::ToolTipRole,tooltip);
        tableWidget->setItem(row,col,item);
    }
}

void FormShkjFinished::setCellElementDealing(QTableWidget *tableWidget, int row, int col, QString key, QString value, QMap<QString, QString> data)
{
    QTableWidgetItem* item = new QTableWidgetItem();
    QVariant display = value;
    QVariant tooltip = value;
    item->setTextAlignment(Qt::AlignHCenter|Qt::AlignVCenter);
    //进行数据翻译

    if(key=="detail")
    {
        QStringList info = display.toString().split("\r\n");
        QString filename;
        if(info.size()>0)
        {
            if(info.at(0).split("：").size()>1)
            {
                filename = info.at(0).split("：").at(1);
            }
            display = filename;
        }
        item->setTextAlignment(Qt::AlignLeft|Qt::AlignVCenter);
    }
    else if(key=="hmzs")
    {
        display = value.toInt();
        tooltip = display;
    }
    else if(key=="finishtime")
    {
        QDateTime inserttime =  QDateTime::fromString(data.value("inserttime"),"yyyy-MM-dd hh:mm:ss");
        QDateTime finishtime =  QDateTime::fromString(data.value("finishtime"),"yyyy-MM-dd hh:mm:ss");
        int seconds  = inserttime.msecsTo(finishtime)/1000 ;
        display =   seconds;
        tooltip = display;
    }
    if(key == "dealstatus")
    {
        delete item;
        QLabel *lbl = new QLabel(this);
        lbl->setAlignment(Qt::AlignCenter|Qt::AlignHCenter);
        lbl->setProperty("value",value);
        lbl->setPixmap(QPixmap(":/task_play.png"));
        lbl->setToolTip(tooltip.toString());
        tableWidget->setCellWidget(row,col,lbl);
    }
    else
    {
        item->setData(Qt::DisplayRole,display);
        item->setData(Qt::UserRole,value);
        item->setData(Qt::ToolTipRole,tooltip);
        tableWidget->setItem(row,col,item);
    }
}

void FormShkjFinished::setCellElementFinished(QTableWidget *tableWidget, int row, int col, QString key, QString value, QMap<QString, QString> data)
{
    QTableWidgetItem* item = new QTableWidgetItem();
    QVariant display = value;
    QVariant tooltip = value;
    item->setTextAlignment(Qt::AlignHCenter|Qt::AlignVCenter);
    //进行数据翻译

    if(key=="uqrycode")
    {
        tooltip = display;
    }
    else if(key=="ltfid")
    {
        tooltip = "";
        display = "";
        item->setCheckState(Qt::Unchecked);
    }
    else if(key=="dealstatus")
    {
        if(value=="2")
        {
            tooltip = "未下载";
        }
        else if(value=="3")
        {
            tooltip = "已下载";
        }
    }
    else if(key=="detail")
    {
        QStringList info = display.toString().split("\r\n");
        QString filename;
        if(info.size()>0)
        {
            if(info.at(0).split("：").size()>1)
            {
                filename = info.at(0).split("：").at(1);
            }
            display = filename;
        }
        item->setTextAlignment(Qt::AlignLeft|Qt::AlignVCenter);
    }
    else if(key=="ltfid")
    {
        display = "";
        tooltip = "";
        item->setCheckState(Qt::Unchecked);
    }
    else if(key=="hmzs")
    {
        display = value.toInt();
        QString ltfid = data.value("ltfid");
        QString fileName = QCoreApplication::applicationDirPath()+\
                QString("/../data/%1/cache/shkj/upload/%2.rtn").arg(m_account.value("usercode")).arg(ltfid);
//        if(QFile::exists(fileName))
//            item->setIcon(QIcon(":/yellow-information.png"));
//        else
//            item->setIcon(QIcon(":/blank.png"));
        item->setTextAlignment(Qt::AlignLeft|Qt::AlignVCenter);
        tooltip = "点击查看详情";
    }
    else if(key=="shzs")
    {
        QString ltf_list = data.value("ltf_list");
        int rpnum;
        QStringList list = ltf_list.split(",");
        rpnum = 0;
        if(list.size()>2)
        {
            rpnum = list.at(2).toInt();
        }
        display = rpnum;
        tooltip = display;
        value = QString::number(rpnum);
        item->setTextAlignment(Qt::AlignLeft|Qt::AlignVCenter);
    }
    else if(key=="finishtime")
    {
        QDateTime inserttime =  QDateTime::fromString(data.value("inserttime"),"yyyy-MM-dd hh:mm:ss");
        QDateTime finishtime =  QDateTime::fromString(data.value("finishtime"),"yyyy-MM-dd hh:mm:ss");
        int seconds  = inserttime.msecsTo(finishtime)/1000 ;
        display = seconds;
        tooltip = display;
    }
    if(key == "dealstatus")
    {
        delete item;
        QLabel *lbl = new QLabel(this);
        lbl->setAlignment(Qt::AlignCenter|Qt::AlignHCenter);
        lbl->setProperty("value",value);
        if(value=="2")
        {
            lbl->setPixmap(QPixmap(":/todown.png"));
            lbl->setToolTip(tooltip.toString());
        }
        else if(value=="3")
        {
            lbl->setPixmap(QPixmap(":/task_ok.png"));
            lbl->setToolTip(tooltip.toString());
        }
        tableWidget->setCellWidget(row,col,lbl);
    }
    else
    {
        item->setData(Qt::DisplayRole,display);
        item->setData(Qt::UserRole,value);
        item->setData(Qt::ToolTipRole,tooltip);
        tableWidget->setItem(row,col,item);
    }
}

void FormShkjFinished::query(QString dealstatus)
{
    QString userCode= m_account.value("usercode");

    QMultiMap<QString,QString> listUpload = SNCDataBase::getAllUpload("shkj","",userCode);
    QMultiMap<QString,QString> listFinished = ShkjDB::getShkjCheckInfos(userCode,dealstatus);

    int colsUpload,colsDealing,colsFinished;
    int rowsUpload,rowsDealing,rowsFinished;
    colsUpload = listUpload.uniqueKeys().size();
    if(colsUpload!=0)
        rowsUpload = listUpload.size()/colsUpload;

    colsFinished = listFinished.uniqueKeys().size();
    if(colsFinished!=0)
        rowsFinished = listFinished.size()/colsFinished;
    if(listUpload.size()==0&&listFinished.size()==0)
    {
        setTableWidgetNoData(ui->tableWidget);
        setDetailNoData();
        return ;
    }
    ui->tableWidget->setRowCount(0);
    if(dealstatus=="0" || dealstatus=="")
    {
        if(listUpload.size()!=0)
        {
            fillDataListUpload(ui->tableWidget,m_keysUpload,listUpload,rowsUpload);
        }
    }
    if(listFinished.size()!=0)
    {
        fillDataListFinished(ui->tableWidget,m_keysFinished,listFinished,rowsFinished);
    }
    else
    {
        setDetailNoData();
    }
    ui->checkBox->setChecked(false);
}
//void FormShkjFinished::query(QString dealstatus)
//{
//    QString userCode= m_account.value("usercode");
//    QMultiMap<QString,QString> list = SNCDataBase::getShkjCheckInfos(userCode,dealstatus);
//    int cols = list.uniqueKeys().size();
//    int rows = 0;
//    if(cols!=0)
//        rows = list.size()/cols;
//    if(list.size()==0)
//    {
//        setTableWidgetNoData(ui->tableWidget);
//        setDetailNoData();
//        return ;
//    }
//    QStringList ids;
//    QString curId;
//    for(int i=0;i<ui->tableWidget->rowCount();i++)
//    {
//        QTableWidgetItem *item = ui->tableWidget->item(i,0);
//        if(item)
//        {
//            if(item->checkState()==Qt::Checked)
//            {
//                ids<<item->data(Qt::UserRole).toString();
//            }
//            if(item->isSelected())
//            {
//                curId = item->data(Qt::UserRole).toString();
//            }
//        }
//    }
//    fillDataList(ui->tableWidget,m_keys,list,rows);
//    for(int i=0;i<ui->tableWidget->rowCount();i++)
//    {
//        if(curId.isEmpty())
//        {
//            ui->tableWidget->selectRow(i);
//            on_tableWidget_cellClicked(i,0);
//            break;
//        }
//        QTableWidgetItem *item = ui->tableWidget->item(i,0);
//        if(item)
//        {
//            QString id = item->data(Qt::UserRole).toString();
//            if(curId==id)
//            {
//                ui->tableWidget->selectRow(i);
//                on_tableWidget_cellClicked(i,0);
//            }
//            for(int i=0;i<ids.size();i++)
//            {
//                if(id==ids.at(i))
//                {
//                    item->setCheckState(Qt::Checked);
//                    break;
//                }
//            }
//        }
//    }


//}

void FormShkjFinished::showRtnMessage(int row)
{
    QTableWidgetItem *itemMsg = ui->tableWidget->item(row,10);
    QTableWidgetItem *itemDetail = ui->tableWidget->item(row,11);
    QString errMsg = "";
    QString errDetail = "";
    if(itemMsg)
    {
        errMsg = itemMsg->data(Qt::UserRole).toString();
    }
    if(itemDetail)
    {
        errDetail = itemDetail->data(Qt::UserRole).toString();
    }
    if(errDetail.isEmpty())
    {
        if(!errMsg.isEmpty())
        {
             QMessageBox::critical(this,"提示",errMsg,QMessageBox::Ok);
        }
    }
    else
    {
        DialogSubmitResponseDetail dialog;
        dialog.setDetailText(errDetail);
        dialog.exec();
    }
}


void FormShkjFinished::onDataUpdated()
{
    if(ui->radioButtonAll->isChecked())
    {
        query("");
    }
    else if(ui->radioButtonUndownoad->isChecked())
    {
        query("2");
    }
    else if(ui->radioButtonDownload->isChecked())
    {
        query("3");
    }
    else if(ui->radioButtonDownload->isChecked())
    {
        query("0");
    }
}

void FormShkjFinished::onPushButtonViewsUploadClicked()
{
    QPushButton *btn = qobject_cast<QPushButton*>(sender());
    for(int i=0;i<ui->tableWidget->rowCount();i++)
    {
       QWidget *widget = ui->tableWidget->cellWidget(i,8);
       if(widget)
       {
           if(btn==qobject_cast<QPushButton*>(widget))
           {
               showRtnMessage(i);
               break;
           }
       }
    }
}

void FormShkjFinished::onPushButtonViewsFinishedClicked()
{
    QPushButton *btn = qobject_cast<QPushButton*>(sender());
    for(int i=0;i<ui->tableWidget->rowCount();i++)
    {
       QWidget *widget = ui->tableWidget->cellWidget(i,8);
       if(widget)
       {
           if(btn==qobject_cast<QPushButton*>(widget))
           {
               QTableWidgetItem *item = ui->tableWidget->item(i,0);
               if(item)
               {
                   m_curLtfid = item->data(Qt::UserRole).toString();
                   showDetailDialog(m_curLtfid);
               }
               break;
           }
       }
    }

}

void FormShkjFinished::displayDetail(QString hmzs, QStringList infos, QStringList nums,QString dealstatus)
{

    double r11 = 0;//快速检测实号数
    double r31 = 0;//精准检测空号数
    double r32 = 0;//精准检测停机数
    double r33 = 0;//精准检测关机数
    double r34 = 0;//精准检测实号数
    int sum = hmzs.toInt();
    int barLength = 500;
    setDetailNoData();

    if(infos.size()==2&&nums.size()==2)
    {
        int i=0;
        int j=0;
        QStringList list = infos.at(i++).split("|");
        QStringList list2 = nums.at(j++).split(",");
        if(list.size()==3 && list2.size()==3)
        {
            r11= list2.at(2).toDouble();
            QString rate = QString::number(100*(sum-r11)/sum,'f',2);
            ui->labelValidNum->setText(list.at(2));
            ui->labelInvalidNum->setText(QString("未知:%1(%2%)").arg(sum-r11).arg(rate));
        }

        list = infos.at(i++).split("|");
        list2 = nums.at(j++).split(",");
        if(list.size()==5 && list2.size()==4)
        {
            r31= list2.at(0).toDouble();//kong
            r32= list2.at(1).toDouble();//ting
            r33= list2.at(2).toDouble();//guan
            r34 = list2.at(3).toDouble();//shihao
            ui->labelKong->setText(list.at(0));
            ui->labelTing->setText(list.at(1));
            ui->labelGuan->setText(list.at(2));
            ui->labelShiHao->setText(list.at(3));

            ui->labelTip->setText("");
        }
        else
        {
            ui->labelTip->setText("<font color=red>数量不足，无法预测。</font");
        }
    }



    if(sum>0)
    {
        ui->labelBarShiHao->setFixedWidth(barLength*r11/sum);
        ui->labelBarWeizhi->setFixedWidth(barLength*(1-r11/sum));
        ui->labelBarShiHao2->setFixedWidth(barLength*r34/sum);
        ui->labelBarKong->setFixedWidth(barLength*r31/sum);
        ui->labelBarTing->setFixedWidth(barLength*r32/sum);
        ui->labelBarGuan->setFixedWidth(barLength*r33/sum);

    }
    else
    {
        ui->labelTip->setText("");
    }
    bool isok = (dealstatus=="2") || (dealstatus == "3");
    ui->pushButtonDownload->setEnabled(isok);
}



void FormShkjFinished::on_tableWidget_cellClicked(int row, int column)
{
    QStringList infos,nums;
    if(row>=0&&column>=0)
    {
        m_curLtfid = ui->tableWidget->item(row,0)->data(Qt::UserRole).toString();
        if(ui->tableWidget->item(row,13))
            m_curQryid = ui->tableWidget->item(row,13)->data(Qt::UserRole).toString();
        m_lastLtfid = m_curLtfid;
        QList<int> indexs;
        indexs<<9<<11;
        for(int i=0;i<indexs.size();i++)
        {
            QString str = ui->tableWidget->item(row,indexs.at(i))->data(Qt::DisplayRole).toString();
            str.replace(" ","");
            infos<<str;
            str = ui->tableWidget->item(row,indexs.at(i)+1)->data(Qt::DisplayRole).toString();
            str.replace(" ","");
            nums<<str;
        }

        QString dealstatus = "2";
        displayDetail(ui->tableWidget->item(row,4)->data(Qt::DisplayRole).toString(),infos,nums,dealstatus);

    }
}

void FormShkjFinished::on_radioButtonAll_clicked()
{
    if(!chkAccountState(m_state))
        return ;
    if(ui->radioButtonAll->isChecked())
    {
        query("");
    }
    else if(ui->radioButtonUndownoad->isChecked())
    {
        query("2");
    }
    else if(ui->radioButtonDownload->isChecked())
    {
        query("3");
    }
    else if(ui->radioButtonOther->isChecked())
    {
        query("0");
    }
}

void FormShkjFinished::on_radioButtonUndownoad_clicked()
{
    if(!chkAccountState(m_state))
        return ;
    on_radioButtonAll_clicked();
}

void FormShkjFinished::on_radioButtonDownload_clicked()
{
    if(!chkAccountState(m_state))
        return ;
    on_radioButtonAll_clicked();
}
void FormShkjFinished::download(QString srvID, QString qryID)
{
    QString ssoHash = m_account.value("ssohash");
    if(ssoHash.isEmpty())
    {
        QMessageBox::critical(this,"提示","您现在还没有登录系统，请登录后再操作！",QMessageBox::Ok);
        return;
    }
    if(srvID.isEmpty())
    {
        QMessageBox::critical(this,"提示","请先选择要下载的任务单！",QMessageBox::Ok);
        return ;
    }
    QString total;
    QString dealstatus;
    for(int i=0;i<ui->tableWidget->rowCount();i++)
    {
        QTableWidgetItem *item = ui->tableWidget->item(i,0);

        if(item)
        {
            if(srvID == item->data(Qt::UserRole).toString())
            {
                total = ui->tableWidget->item(i,5)->data(Qt::UserRole).toString();
                QLabel *lbl = qobject_cast<QLabel*>(ui->tableWidget->cellWidget(i,1));
                dealstatus = lbl->property("value").toString();
                break;
            }
        }

    }
    if(dealstatus.isEmpty()||total.isEmpty())
    {
        QMessageBox::critical(this,"提示","无法获取下载文件必要的信息！",QMessageBox::Ok);
        return ;
    }
    if(dealstatus=="2")
    {
        if(QMessageBox::Yes!=QMessageBox::question(NULL,
                                                   "确认",
                                                   QString("您确定要下载吗？")
                                                   ,QMessageBox::Yes,QMessageBox::No))
        {
            return ;
        }
    }
    QString saveZipFileName = getSaveZipFileName(qryID);
    if(saveZipFileName.isEmpty())
        return ;
    QString cachePath = ShkjDB::getShkjCachePath(srvID);
    bool iscached = false;

    if(!cachePath.isEmpty())
    {
        if(QFile::exists(cachePath))
        {
            iscached = true;
        }
    }
    this->setCursor(Qt::WaitCursor);
    if(iscached)
    {
        downloadFromLocal(saveZipFileName,cachePath);
    }
    else
    {
        downloadFromRemote(saveZipFileName,srvID,dealstatus,total);
    }
    this->setCursor(Qt::ArrowCursor);
}

void FormShkjFinished::downloadFromLocal(QString saveFileName,QString cacheFile)
{

    QFile::copy(cacheFile,saveFileName);
    QMessageBox::information(this,"提示","下载成功！",QMessageBox::Ok);
}

void FormShkjFinished::downloadFromRemote(QString saveFileName,QString srvID,QString dealstatus,QString total)
{
    QString ssoHash = m_account.value("ssohash");
    QString json = m_cubews->userServiceVerify("DlShkjResultFile",QString("%1,%2").arg(dealstatus).arg(total),ssoHash);

    RespUserServiceVerify    response1(json);
    if(response1.getRtnCode()<=0)
    {
        QMessageBox::critical(this,"提示",response1.getRtnMemo(),QMessageBox::Ok);
        return ;
    }

    json = m_cubews->dlShkjResultFile(srvID,ssoHash);
    RespDlShkjResultFile response(json);
    if(response.getRtnCode()==1)
    {
        QString fileContent = response.getFileContent();
        QByteArray array = QByteArray::fromBase64(fileContent.toAscii());
        QFile file(saveFileName);
        file.open(QIODevice::WriteOnly);
        file.write(array);
        file.close();
        QString cachPath = cacheDownloadFile(saveFileName);
        ShkjDB::updateShkjCachePath(srvID,cachPath);
        emit dataDownload();

        QMessageBox::information(this,"提示","下载成功！",QMessageBox::Ok);

    }
    else
    {
        QMessageBox::critical(this,"提示",response.getRtnMemo(),QMessageBox::Ok);
    }


}

QString FormShkjFinished::getSaveZipFileName(QString qryID)
{
    QFileDialog::Options options;
    QString selectedFilter;
    QString exportDir = SNCDataBase::getExportDir();
    if(exportDir.isEmpty())
    {
        QString path = QProcessEnvironment::systemEnvironment().value("HOMEDRIVE")+\
                QProcessEnvironment::systemEnvironment().value("HOMEPATH")+"\\DESKTOP";
        exportDir = path;
    }
    QString defaultZipFileName = QString("实号快检_%1.zip").arg(qryID);
    QString saveZipFileName = QFileDialog::getSaveFileName(this,"另存为",exportDir + "\\" + defaultZipFileName,
                                                           tr("ZIP Files (*.zip)"),
                                                           &selectedFilter,
                                                           options);
    if(!saveZipFileName.isEmpty())
    {
        QFileInfo fileInfo(saveZipFileName);
        exportDir = fileInfo.absolutePath();
        SNCDataBase::updateExportDir(exportDir);
    }
    return saveZipFileName;
}

QString FormShkjFinished::cacheDownloadFile(QString fileName)
{
    QString userCode = m_account.value("usercode");
    QString date = QDate::currentDate().toString("yyyyMM");
    QString cachePath = QCoreApplication::applicationDirPath()+\
            QString("/../data/%1/cache/shkj/download/%2/").arg(userCode).arg(date);
    QDir dir;
    dir.mkpath(cachePath);
    QFileInfo fileinfo(fileName);
    QFile::copy(fileName,cachePath + fileinfo.fileName());
    return cachePath + fileinfo.fileName();
}

bool FormShkjFinished::chkAccountState(AccountLoginState state)
{
    bool ret = false;
    switch(state)
    {
        case NotLogin:
            QMessageBox::critical(this,"提示","您现在还没有登录系统，请登录后再操作！",QMessageBox::Ok);
            break;
        case NotBind:
            QMessageBox::critical(this,"提示","此项服务尚未开通，请开通后再操作！",QMessageBox::Ok);
            break;
        case LoginError:
            QMessageBox::critical(this,"提示","此项服务暂时无法连接，请稍候重试！",QMessageBox::Ok);
            break;
        default:
            ret = true;
    }
    return ret;
}

void FormShkjFinished::showDetailDialog(QString ltfid)
{
    setCursor(Qt::WaitCursor);
    QString fileName = QCoreApplication::applicationDirPath()+\
            QString("/../data/%1/cache/shkj/upload/%2.rtn").arg(m_account.value("usercode")).arg(ltfid);
    QFile file(fileName);
    file.open(QIODevice::ReadOnly);
    QTextStream in(&file);
    QString content = in.readAll();
    file.close();
    if(content.isEmpty())
    {

        QMessageBox::information(this,"提示","号码已经全部接收!",QMessageBox::Ok);
    }
    else
    {
        DialogSubmitResponseDetail dialog;
        dialog.setDetailText(content);
        dialog.exec();
    }
    setCursor(Qt::ArrowCursor);
}

void FormShkjFinished::appendRow(QTableWidget *tableWidget, int row)
{
    if(tableWidget->rowCount()==0)
    {
        tableWidget->setRowCount(row);
    }
    else
    {
        for(int i=0;i<row;i++)
        {
            tableWidget->insertRow(ui->tableWidget->rowCount());
        }
    }

}

void FormShkjFinished::on_pushButtonDownload_clicked()
{
    if(!chkAccountState(m_state))
        return ;
    download(m_curLtfid,m_curQryid);
}

void FormShkjFinished::on_tableWidget_cellDoubleClicked(int row, int column)
{
    if(!chkAccountState(m_state))
        return ;
    download(m_curLtfid,m_curQryid);
}

void FormShkjFinished::on_pushButtonDel_clicked()
{
    if(!chkAccountState(m_state))
        return ;

    bool nodata = true;
    for(int i=0;i<ui->tableWidget->rowCount();i++)
    {
        QTableWidgetItem *item = ui->tableWidget->item(i,0);
        if(item)
        {
            if(item->checkState()==Qt::Checked)
            {
                nodata = false;
            }
        }
    }
    if(nodata)
    {
        QMessageBox::critical(this,"提示","请选择要删除的单子",QMessageBox::Ok);
        return ;
    }
    if(QMessageBox::Yes!=QMessageBox::question(NULL,
                                               "确认",
                                               QString("您确定要删除吗？")
                                               ,QMessageBox::Yes,QMessageBox::No))
    {
        return ;
    }
    for(int i=0;i<ui->tableWidget->rowCount();i++)
    {
        QTableWidgetItem *item = ui->tableWidget->item(i,0);
        QTableWidgetItem *item2 = ui->tableWidget->item(i,5);
        if(item)
        {
            if(item->checkState()==Qt::Checked)
            {
                QString id = item->data(Qt::UserRole).toString();
                if(!item2->data(Qt::UserRole).toString().isEmpty())
                {
                    ShkjDB::delShkjByID(id);

                }
                else
                {
                    SNCDataBase::deleteFileByFileID(id.toInt());
                }
            }
        }
    }
    ui->checkBox->setChecked(false);
    on_radioButtonAll_clicked();
}

void FormShkjFinished::on_checkBox_clicked()
{
    Qt::CheckState state;
    state = ui->checkBox->checkState();
    for(int i=0;i<ui->tableWidget->rowCount();i++)
    {
        QTableWidgetItem *item = ui->tableWidget->item(i,0);
        if(item)
        {
            item->setCheckState(state);
        }
    }
}

void FormShkjFinished::on_radioButtonOther_clicked()
{
    if(!chkAccountState(m_state))
        return ;
    on_radioButtonAll_clicked();
}

void FormShkjFinished::on_tableWidget_clicked(const QModelIndex &index)
{
//    if(index.column()==0)
//    {
//        QTableWidgetItem *item = ui->tableWidget->item(index.row(),index.column());
//        if(item)
//        {
//            if(item->checkState()==Qt::Checked)
//            {
//                ui->tableWidget->selectRow(index.row());
//                item->setCheckState(Qt::Checked);
//            }
//            else
//            {
//                ui->tableWidget->selectRow(index.row());
//                item->setCheckState(Qt::Checked);
//            }
//        }
//    }
//    else
//    {
//        ui->tableWidget->selectRow(index.row());
//    }
    ui->tableWidget->selectRow(index.row());
    QTableWidgetItem *item = ui->tableWidget->item(index.row(),0);
    item->setCheckState(Qt::Checked);
    for(int i=0;i<ui->tableWidget->rowCount();i++)
    {
        QTableWidgetItem *item = ui->tableWidget->item(i,0);
        if(i==index.row())
        {
           item->setCheckState(Qt::Checked);
        }
        else
        {
           item->setCheckState(Qt::Unchecked);
        }
    }
    ui->checkBox->setChecked(false);
}

void FormShkjFinished::on_tableWidget_itemSelectionChanged()
{
//    for(int i=0;i<ui->tableWidget->rowCount();i++)
//    {
//        QTableWidgetItem *item = ui->tableWidget->item(i,0);
//        if(item->isSelected())
//        {
//            item->setCheckState(Qt::Checked);
//        }
//        else
//        {
//           item->setCheckState(Qt::Unchecked);
//        }
//    }
}

void FormShkjFinished::on_pushButtonUpload_clicked()
{
    if(!chkAccountState(m_state))
            return;
    DialogSubmit dialog(this);
    dialog.setAccountInfo(m_account);
    int rtCode = dialog.exec();
    if(rtCode == QDialog::Accepted)
    {
        onDataUpdated();
    }
}