SmartPDCode/Qt/Qt_Test/dataupdatethread.cpp

#include "dataupdatethread.h"
#include <QSqlQuery>
#include <QSqlError>
#include <stdio.h>
#include <stdlib.h>
#include <fcntl.h>           /* For O_* constants */
#include <sys/types.h>
#include <sys/stat.h>
#include <sys/mman.h>        /* For shm_open, mmap, ftruncate, etc */
#include <sys/stat.h>        /* For mode constants */
#include <errno.h>
#include <unistd.h>
#include <QtSql>
DataUpdateThread::DataUpdateThread(QObject *parent)
    :QThread(parent)
{
    isRunStats=true;
    nMaxCh=0;
    nReadType=0;
    m_shmData=0;
    bTacStatus=false;
}

DataUpdateThread::~DataUpdateThread()
{
    isRunStats=false;
    m_db.close();
}

void DataUpdateThread::InitSql()
{
    m_db=QSqlDatabase::addDatabase("QSQLITE");
    m_db.setDatabaseName(strSqliteAddress);
    qDebug()<<strSqliteAddress;
    if (m_db.open())
    {
        qDebug()<<"SQL Open Success";
        isDBOpen=true;
    }else
    {
        qDebug()<<"SQL Open Error";
        isDBOpen=false;
    }
    if(isDBOpen)
    {
        ReadMaxCh();
    }
    nReadType=0;
}

void DataUpdateThread::run()
{
    qDebug() <<"Start SQLThread";
    while (isRunStats)
    {

        if(pwidget)
        {
            if(nReadType==0)
            {
                int nMode=pwidget->getShowModeIndex();
                int nPage=pwidget->getShowPagIndex();
                if(nMode==0&&nPage!=0)
                {
                    int nSubPag=pwidget->getShowSubIndex();
                    ReadSqlData(nSubPag);
                    pwidget->SetV(strV);
                    pwidget->SetA(strA);
                    pwidget->SetW(strW);
                    pwidget->SetF(strF);
                    pwidget->SetSUM(strS);
                    pwidget->setCH(nSubPag);
                    pwidget->update();
                    //qDebug() <<"V:"<<strV<<";A"<<strA<<";W:"<<strW;
                }
                else if(nMode==0&&nPage==0)
                {
                    pwidget->UpdateDate();
                    pwidget->update();
                }
            }else
            {
                int nMode=pwidget->getShowModeIndex();
                int nPage=pwidget->getShowPagIndex();
                ReadShmMaxch();
                if(nMode==0&&nPage!=0)
                {
                    int nSubPag=pwidget->getShowSubIndex();
                    int nPHIndex=pwidget->getShowPHIndex();
                    setShmChRead(nSubPag,nPHIndex);
                    ReadShmData();
                    pwidget->SetV(strV);
                    pwidget->SetA(strA);
                    pwidget->SetW(strW);
                    pwidget->SetF(strF);
                    pwidget->SetSUM(strS);
                    pwidget->SetStatus(strStatus);
                    pwidget->setCH(nSubPag);
                    pwidget->SetT(strT);
                    pwidget->SetH(strH);
                    pwidget->update();
                    //qDebug() <<"V:"<<strV<<";A"<<strA<<";W:"<<strW;
                }
                else if(nMode==0&&nPage==0)
                {
                    pwidget->UpdateDate();
                    pwidget->update();
                }
            }
        }
        sleep(1);
    }
}

void DataUpdateThread::ReadSqlData(int nCHID)
{
    if(!isDBOpen)
    {
        return;
    }
    QSqlQuery sql_query(m_db);
    QString strSql=QString("SELECT * FROM Table_PowerInfo WHERE product_id=1 AND product_ch_id=%1 ORDER BY product_Index DESC LIMIT 1").arg(nCHID);
    //qDebug()<<strSql;
    if (sql_query.exec(strSql))
    {
        while (sql_query.next())
        {
            strV = sql_query.value("product_ch_voltage").toString();
            strA = sql_query.value("product_ch_current").toString();
            strW = sql_query.value("product_ch_power").toString();
            strF = sql_query.value("product_ch_power_freq").toString();
            strS = sql_query.value("product_ch_consumption").toString();
            //qDebug() <<"V:"<<strV<<";A"<<strA<<";W:"<<strW;
        }
    }else
    {
        qDebug()<<sql_query.lastError().text();
    }

}

void DataUpdateThread::ReadMaxCh()
{
    if(!isDBOpen)
    {
        return;
    }
    QSqlQuery sql_query(m_db);
    QString strSql=QString("SELECT MAX(product_ch_id) as maxCh FROM Table_PowerManage ");
    //qDebug()<<strSql;
    if (sql_query.exec(strSql))
    {
        while (sql_query.next())
        {
            nMaxCh = sql_query.value("maxCh").toInt();
            if(pwidget)
            {
                pwidget->nMAXChildIndex=nMaxCh;
            }
        }
    }else
    {
        qDebug()<<sql_query.lastError().text();
    }
}

int DataUpdateThread::initShm()
{
    /* 创建共享内存对象 */
    shm_fd = shm_open(SHM_NAME, O_CREAT | O_RDWR, 0666);
    if (shm_fd == -1) {
        perror("shm_open");
        return 1;
    }

    /* 设置共享内存对象的大小 */

    if (ftruncate(shm_fd, sizeof(smartPDU_shm_data)) == -1) {
        perror("ftruncate");
        return 2;
    }
    m_shmData = (smartPDU_shm_data*)mmap(NULL, sizeof(smartPDU_shm_data), PROT_READ|PROT_WRITE, MAP_SHARED, shm_fd, 0);
    memset(m_shmData,0,sizeof(smartPDU_shm_data));
    m_shmData->nSelectSensor=10;
    nReadType=1;
    return 0;
}

void DataUpdateThread::deleteShm()
{
    m_shmData->bPDUSet=-1;
    if (munmap(m_shmData, sizeof(smartPDU_shm_data)) == -1) {
        perror("munmap");
        return;
    }
    if (shm_unlink(SHM_NAME) == -1) {
        perror("shm_unlink");
        return;
    }
    m_shmData=nullptr;
}

void DataUpdateThread::setShmChRead(int nCh,int nPhID)
{
    if(nReadType!=1&&!m_shmData)
    {
        return;
    }
    if(m_shmData->bPDUSet>0)
    {
        if(m_shmData->nSelectPowerCH!=nCh)
        {
            m_shmData->nSelectPowerCH=nCh;
            bTacStatus=m_shmData->bT_ACType;
            pdu_Ctrl::instance()->isT_ACType=bTacStatus;
            if(bTacStatus)
            {
                m_shmData->nSelectPh=nPhID;
            }else
            {
                m_shmData->nSelectPh=0;
            }
            m_shmData->bPDUSet=0;            
        }

    }
}

void DataUpdateThread::ReadShmData()
{
    if(nReadType!=1&&!m_shmData)
    {
        return;
    }
    if(m_shmData->bPDUSet>0)
    {
        if(m_shmData->fV>=0.1)
        {
            strV = QString::number(m_shmData->fV,'f',2);
        }else
        {
            strV = "0.00";
        }

        if(m_shmData->fA>=0.01)
        {
            strA = QString::number(m_shmData->fA,'f',2);
        }else
        {
            strA="0.00";
        }
        strW = QString::number(m_shmData->fW,'f',2);
        strF = QString::number(m_shmData->fF,'f',2);
        strS = QString::number(m_shmData->fS,'f',2);
        if(m_shmData->nStatus==0)
        {
            strStatus="OFF";
        }else
        {
            strStatus="ON";
        }
        strT = QString::number(m_shmData->fT,'f',2);
        strH = QString::number(m_shmData->fH,'f',2);
    }
}

void DataUpdateThread::ReadShmMaxch()
{
    if(nReadType!=1&&!m_shmData)
    {
        if(pwidget)
        {
            pwidget->nMAXChildIndex=0;
        }
        return;
    }
    if(pwidget&&m_shmData->bPDUSet>0)
    {
        if(pwidget->nMAXChildIndex!=m_shmData->nMaxCh)
        {
           pwidget->nMAXChildIndex=m_shmData->nMaxCh;
        }
    }
}

bool DataUpdateThread::isT_ACType()
{
    return bTacStatus;
}