jfmartel
/
ZTStats
1
0
Çatalla 0
Kod Konular 0 Değişiklik İstekleri 0 Sürümler 0 Wiki Aktivite
25'ten fazla konu seçemezsiniz Konular bir harf veya rakamla başlamalı, kısa çizgiler ('-') içerebilir ve en fazla 35 karakter uzunluğunda olabilir.
2 İşleme
1 Dal
140 KiB
 
 
 
 
Dal: master
Dallar Biçim İmleri
${ item.name }
${ searchTerm } dalı oluştur
'master'den
${ noResults }
ZTStats/Sources/ReportGenerator.cpp

526 satır
23 KiB
Ham Kalıcı Bağlantı Suçlama Geçmiş 

  1. #include "ReportGenerator.h"

  2. #include <QtXlsx>

  3. #include <QStringList>

  4. #include "ZTData.h"

  5. #include "LogMgr.h"

  6. #include "GlobalDefine.h"

  7. #include "ZTStats.h"

  8. 

  9. CReportGenerator::CReportGenerator()

  10. {

  11.     mDirParserThread = new QThread();

  12.     mDirParserWorkerThread = new CDirParserThread();

  13.     mDirParserWorkerThread->moveToThread(mDirParserThread);

  14.     connect(mDirParserThread,SIGNAL(started()),mDirParserWorkerThread,SLOT(ParseDirectories()));

  15.     connect(mDirParserThread,SIGNAL(finished()),this,SLOT(ThreadQuit()));

  16.     connect(mDirParserWorkerThread,SIGNAL(ParsingFinished(int)),this,SLOT(DirParsingFinished(int)));

  17.     connect(mDirParserWorkerThread,SIGNAL(ReportProgressStatus(QString)),this,SLOT(ThreadReportStatus(QString)));

  18.     connect(mDirParserWorkerThread,SIGNAL(ThreadAborted()),this,SLOT(DirThreadAborted()));

  19. 

  20.    mStationNames << "Angrignon" << "Beaugrand" << "Longueuil" << "Berri" << "Snowdon" << "St-Michel" << "Vertu" << "Bourassa" << "Montmorency";

  21. 

  22.     //Allocate report data structure for each station

  23.     for(int i = 0; i < NB_ZT_ID; i++)

  24.     {   QList<CLogElement*> *ElementList = new QList<CLogElement*>;

  25.         mReportData.append(ElementList);

  26.     }

  27. }

  28. 

  29. CReportGenerator::~CReportGenerator()

  30. {

  31.     mDirParserThread->quit();

  32.     delete mDirParserWorkerThread;

  33.     //delete mDirParserThread;

  34. }

  35. 

  36. int CReportGenerator::GenerateReport(QString ReportFileName, CReportProgramSettingsData ReportSettings, CReportConfigData ReportFilters)

  37. {

  38. 

  39.     mReportFilename = ReportFileName;

  40.     mReportFilters = ReportFilters;

  41. 

  42.     ClearReportData();

  43. 

  44.     mDirParserWorkerThread->SetParsingInfo(ReportSettings,ReportFilters,&mReportData);

  45.     mDirParserThread->start();

  46. 

  47. 

  48.     return RET_OK;

  49. }

  50. 

  51. int CReportGenerator::ClearReportData()

  52. {

  53.     for(int station = 0; station < mReportData.size(); station++)

  54.     {

  55.         QList<CLogElement*> *LogsList = mReportData.at(station);

  56.         for(int log = 0; log < LogsList->size(); log++)

  57.         {

  58.             delete LogsList->at(log);

  59.         }

  60.         LogsList->clear();

  61.     }

  62.     return RET_OK;

  63. }

  64. 

  65. 

  66. 

  67. void CReportGenerator::ThreadQuit()

  68. {

  69.     qDebug("Parsing thread quit");

  70. }

  71. 

  72. void CReportGenerator::ThreadTerminated()

  73. {

  74.     qDebug("Parsing thread terminated");

  75. }

  76. 

  77. void CReportGenerator::DirParsingFinished(int Res)

  78. {

  79.     mDirParserThread->exit();

  80.     if(Res == 0)

  81.     {

  82.         ClearReportData();

  83.         ThreadReportStatus("La génération du rapport a échoué...");

  84.         mProgramPtr->ReportCreationFinished(QString());

  85.         return;

  86.     }

  87. 

  88.     //Generate report

  89.     GenerateExcelReport();

  90. }

  91. 

  92. void CReportGenerator::DirThreadAborted()

  93. {

  94.     mDirParserThread->exit();

  95.     ClearReportData();

  96.     ThreadReportStatus("La génération du rapport a été annulée");

  97.     mProgramPtr->ReportCreationFinished(QString());

  98. }

  99. 

  100. int CReportGenerator::GenerateExcelReport()

  101. {

  102.     if(mReportFilename.isEmpty())

  103.     {

  104.         return RET_ERROR;

  105.     }

  106.     ThreadReportStatus("Passages analysés... création du fichier Excel.");

  107. 

  108.     QXlsx::Document ExcelDoc(mReportFilename);

  109.     //Clean the file if it already exist

  110.     for(int station = 0; station < mStationNames.size(); station++)

  111.     {

  112.         ExcelDoc.deleteSheet(mStationNames.at(station));

  113.     }

  114. 

  115.     for(int station = 0; station < mReportData.size(); station++)

  116.     {

  117.         int PassageID = 1;

  118.         if(mReportData.at(station)->isEmpty() == false)

  119.         {

  120.             QList<CLogElement*> *PassageLogData = mReportData.at(station);

  121.             int row = 6;

  122.             ExcelDoc.addSheet(mStationNames.at(station));

  123.             ExcelDoc.selectSheet(mStationNames.at(station));

  124. 

  125.             //Create Header

  126.             ExcelDoc.write(1,1,QString("Rapport de déclenchements ZT de la station %1").arg(mStationNames.at(station)));

  127.             ExcelDoc.write(2,1,QString("Date de début %1").arg(mReportFilters.mReportStartDate.toString("yyyy-MM-dd")));

  128.             ExcelDoc.write(3,1,QString("Date de fin %1").arg(mReportFilters.mReportEndDate.toString("yyyy-MM-dd")));

  129. 

  130.             ExcelDoc.write(5,1,QString("ID Passage"));

  131.             ExcelDoc.write(5,2,QString("Date et Heure"));

  132.             ExcelDoc.write(5,3,QString("Nb Décl (passage)"));

  133.             ExcelDoc.write(5,4,QString("Zone"));

  134.             ExcelDoc.write(5,5,QString("Composition"));

  135.             ExcelDoc.write(5,6,QString("Déclenchement"));

  136.             ExcelDoc.write(5,7,QString("Rang"));

  137.             ExcelDoc.write(5,8,QString("Fonction FN"));

  138.             ExcelDoc.write(5,9,QString("Fonction PG"));

  139.             ExcelDoc.write(5,10,QString("Fonction PP"));

  140.             ExcelDoc.write(5,11,QString("Fonction ZT1"));

  141.             ExcelDoc.write(5,12,QString("Fonction ZT2"));

  142. 

  143. 

  144. 

  145.             for(int log = 0; log < PassageLogData->size(); log++)

  146.             {

  147.                 if(PassageLogData->at(log)->mZTLogType == ZT1_LOG_TYPE)

  148.                 {

  149.                     bool IncPassage = false;

  150.                     CZT1LogElement *Element = (CZT1LogElement*)PassageLogData->at(log);

  151.                     if(mReportFilters.mReportIncludeSansDeclZT1 == true)

  152.                     {

  153.                         ExcelDoc.write(row,1,PassageID);

  154.                         ExcelDoc.write(row,2,Element->mPassageDateTime.toString("yyyy-MM-dd hh:mm:ss"));

  155.                         ExcelDoc.write(row,3,Element->mZTDetections.size());

  156.                         ExcelDoc.write(row,4,"ZT1");

  157.                         ExcelDoc.write(row,5,QString("%1-%2-%3").arg(Element->mFlags.mTrainCompo1).arg(Element->mFlags.mTrainCompo2).arg(Element->mFlags.mTrainCompo3));

  158.                         ExcelDoc.write(row,6,"---");

  159.                         ExcelDoc.write(row,7,"---");

  160. 

  161.                         if(Element->mDetectionFlagsValid == false)

  162.                         {

  163.                             ExcelDoc.write(row,8,QString("N/D"));   //Fonction FN

  164.                             ExcelDoc.write(row,9,QString("N/D"));   //Fonction PG

  165.                             ExcelDoc.write(row,10,QString("N/D"));  //Fonction PPE

  166.                             ExcelDoc.write(row,11,QString("N/D"));  //Fonction ZT1

  167.                             ExcelDoc.write(row,12,QString("N/D"));  //Fonction ZT2

  168.                         }

  169.                         else

  170.                         {

  171.                             QString Status = "Hors service";

  172.                             if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_FN_MASK)

  173.                             {

  174.                                 Status = "En service";

  175.                             }

  176.                             ExcelDoc.write(row,8,Status);   //Fonction FN

  177. 

  178.                             Status = "Hors service";

  179.                             if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_PG_MASK)

  180.                             {

  181.                                 Status = "En service";

  182.                             }

  183.                             ExcelDoc.write(row,9,Status);   //Fonction PG

  184. 

  185.                             Status = "Hors service";

  186.                             if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_PP)

  187.                             {

  188.                                 Status = "En service";

  189.                             }

  190.                             ExcelDoc.write(row,10,Status);  //Fonction PP

  191. 

  192.                             Status = "Hors service";

  193.                             if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_ZT1_MASK)

  194.                             {

  195.                                 Status = "En service";

  196.                             }

  197.                             ExcelDoc.write(row,11,Status);        //ZT1

  198. 

  199. 

  200.                             Status = "Hors service";

  201.                             if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_ZT2_MASK)

  202.                             {

  203.                                 Status = "En service";

  204.                             }

  205.                             ExcelDoc.write(row,12,Status);        //ZT2

  206. 

  207.                         }

  208. 

  209.                         row++;

  210.                     }

  211. 

  212.                     if(Element->mZTDetections.size() != 0)

  213.                     {

  214.                         for(int detect = 0; detect < Element->mZTDetections.size(); detect++)

  215.                         {

  216.                             QString DetectionName = "";

  217.                             switch(Element->mZTDetections.at(detect)->mDetectionID)

  218.                             {

  219.                                 case DETECTION_FN_DETECTION:

  220.                                 {

  221.                                     if(mReportFilters.mReportFilterIncludeFN == true)

  222.                                     {

  223.                                         DetectionName = "FN";

  224.                                     }

  225.                                     break;

  226.                                 }

  227.                                 case DETECTION_MAGNETIC_SENSOR_COUNT:

  228.                                 {

  229.                                     if(mReportFilters.mReportfilterIncludeComptage1 == true)

  230.                                     {

  231.                                         DetectionName = "Erreur de comptage";

  232.                                     }

  233.                                     break;

  234.                                 }

  235.                                 case DETECTION_PG_DETECTION:

  236.                                 {

  237.                                     if(mReportFilters.mReportfilterIncludePG == true)

  238.                                     {

  239.                                         DetectionName = "PG";

  240.                                     }

  241.                                     break;

  242.                                 }

  243.                                 case DETECTION_PPI_DETECTION:

  244.                                 {

  245.                                     if(mReportFilters.mReportfilterIncludePPI1 == true)

  246.                                     {

  247.                                         DetectionName = "PPI";

  248.                                     }

  249.                                     break;

  250.                                 }

  251.                                 case DETECTION_PPE_DETECTION:

  252.                                 {

  253.                                     if(mReportFilters.mReportfilterIncludePPE1 == true)

  254.                                     {

  255.                                         DetectionName = "PPE";

  256.                                     }

  257.                                     break;

  258.                                 }

  259.                                 case DETECTION_PEQ1_DETECTION:

  260.                                 {

  261.                                     if(mReportFilters.mReportfilterIncludePEQ1 == true)

  262.                                     {

  263.                                         DetectionName = "Panne équipement";

  264.                                     }

  265.                                     break;

  266.                                 }

  267.                                 default:

  268.                                 {

  269.                                     DetectionName.clear();

  270.                                     break;

  271.                                 }

  272.                             }

  273. 

  274.                             if(DetectionName.isEmpty() == false)

  275.                             {

  276.                                 ExcelDoc.write(row,1,PassageID);

  277.                                 ExcelDoc.write(row,2,Element->mPassageDateTime.toString("yyyy-MM-dd hh:mm:ss"));

  278.                                 ExcelDoc.write(row,3,Element->mZTDetections.size());

  279.                                 ExcelDoc.write(row,4,"ZT1");

  280.                                 ExcelDoc.write(row,5,QString("%1-%2-%3").arg(Element->mFlags.mTrainCompo1).arg(Element->mFlags.mTrainCompo2).arg(Element->mFlags.mTrainCompo3));

  281.                                 ExcelDoc.write(row,6,DetectionName);

  282.                                 ExcelDoc.write(row,7,Element->mZTDetections.at(detect)->mRank);

  283. 

  284.                                 if(Element->mDetectionFlagsValid == false)

  285.                                 {

  286.                                     ExcelDoc.write(row,8,QString("N/D"));   //Fonction FN

  287.                                     ExcelDoc.write(row,9,QString("N/D"));   //Fonction PG

  288.                                     ExcelDoc.write(row,10,QString("N/D"));  //Fonction PPE

  289.                                     ExcelDoc.write(row,11,QString("N/D"));  //Fonction ZT1

  290.                                     ExcelDoc.write(row,12,QString("N/D"));  //Fonction ZT2

  291.                                 }

  292.                                 else

  293.                                 {

  294.                                     QString Status = "Hors service";

  295.                                     if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_FN_MASK)

  296.                                     {

  297.                                         Status = "En service";

  298.                                     }

  299.                                     ExcelDoc.write(row,8,Status);   //Fonction FN

  300. 

  301.                                     Status = "Hors service";

  302.                                     if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_PG_MASK)

  303.                                     {

  304.                                         Status = "En service";

  305.                                     }

  306.                                     ExcelDoc.write(row,9,Status);   //Fonction PG

  307. 

  308.                                     Status = "Hors service";

  309.                                     if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_PP)

  310.                                     {

  311.                                         Status = "En service";

  312.                                     }

  313.                                     ExcelDoc.write(row,10,Status);  //Fonction PP

  314. 

  315.                                     Status = "Hors service";

  316.                                     if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_ZT1_MASK)

  317.                                     {

  318.                                         Status = "En service";

  319.                                     }

  320.                                     ExcelDoc.write(row,11,Status);        //ZT1

  321. 

  322. 

  323.                                     Status = "Hors service";

  324.                                     if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_ZT2_MASK)

  325.                                     {

  326.                                         Status = "En service";

  327.                                     }

  328.                                     ExcelDoc.write(row,12,Status);        //ZT2

  329. 

  330.                                 }

  331. 

  332.                                 row++;

  333.                                 IncPassage = true;  //we had ad least one log added, this passage must count...

  334.                             }

  335.                         }

  336. 

  337.                     }

  338. 

  339.                     if(IncPassage == true || mReportFilters.mReportIncludeSansDeclZT1 == true)

  340.                     {

  341.                         PassageID++;

  342.                     }

  343.                 }

  344.                 else if(PassageLogData->at(log)->mZTLogType == ZT2_LOG_TYPE)

  345.                 {

  346.                     bool IncPassage = false;

  347.                     CZT2LogElement *Element = (CZT2LogElement*)PassageLogData->at(log);

  348.                     if(mReportFilters.mReportIncludeSansDeclZT2 == true)

  349.                     {

  350.                         ExcelDoc.write(row,1,PassageID);

  351.                         ExcelDoc.write(row,2,Element->mPassageDateTime.toString("yyyy-MM-dd hh:mm:ss"));

  352.                         ExcelDoc.write(row,3,Element->mZTDetections.size());

  353.                         ExcelDoc.write(row,4,"ZT2");

  354.                         ExcelDoc.write(row,5,QString("%1-%2-%3").arg(Element->mFlags.mTrainCompo1).arg(Element->mFlags.mTrainCompo2).arg(Element->mFlags.mTrainCompo3));

  355.                         ExcelDoc.write(row,6,"---");

  356.                         ExcelDoc.write(row,7,"---");

  357. 

  358.                         if(Element->mDetectionFlagsValid == false)

  359.                         {

  360.                             ExcelDoc.write(row,8,QString("N/D"));   //Fonction FN

  361.                             ExcelDoc.write(row,9,QString("N/D"));   //Fonction PG

  362.                             ExcelDoc.write(row,10,QString("N/D"));  //Fonction PPE

  363.                             ExcelDoc.write(row,11,QString("N/D"));  //Fonction ZT1

  364.                             ExcelDoc.write(row,12,QString("N/D"));  //Fonction ZT2

  365.                         }

  366.                         else

  367.                         {

  368.                             ExcelDoc.write(row,8,QString("N/A"));   //Fonction FN

  369.                             ExcelDoc.write(row,9,QString("N/A"));   //Fonction PG

  370. 

  371.                             QString Status = "Hors service";

  372.                             if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_PP2)

  373.                             {

  374.                                 Status = "En service";

  375.                             }

  376.                             ExcelDoc.write(row,10,Status);  //Fonction PP

  377. 

  378.                             Status = "Hors service";

  379.                             if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_ZT1_MASK)

  380.                             {

  381.                                 Status = "En service";

  382.                             }

  383.                             ExcelDoc.write(row,11,Status);        //ZT1

  384. 

  385. 

  386.                             Status = "Hors service";

  387.                             if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_ZT2_MASK)

  388.                             {

  389.                                 Status = "En service";

  390.                             }

  391.                             ExcelDoc.write(row,12,Status);        //ZT2

  392. 

  393.                         }

  394. 

  395. 

  396.                         row++;

  397.                     }

  398. 

  399.                     if(Element->mZTDetections.size() != 0)

  400.                     {

  401.                         for(int detect = 0; detect < Element->mZTDetections.size(); detect++)

  402.                         {

  403.                             QString DetectionName = "";

  404.                             switch(Element->mZTDetections.at(detect)->mDetectionID)

  405.                             {

  406.                                 case DETECTION_ZT2_MAGNETIC_SENCOR_COUNT:

  407.                                 {

  408.                                     if(mReportFilters.mReportfilterIncludeComptage2 == true)

  409.                                     {

  410.                                         DetectionName = "Erreur de comptage";

  411.                                     }

  412.                                     break;

  413.                                 }

  414.                                 case DETECTION_ZT2_PPI_DETECTION:

  415.                                 {

  416.                                     if(mReportFilters.mReportfilterIncludePPI2 == true)

  417.                                     {

  418.                                         DetectionName = "PPI";

  419.                                     }

  420.                                     break;

  421.                                 }

  422.                                 case DETECTION_ZT2_PPE_DETECTION:

  423.                                 {

  424.                                     if(mReportFilters.mReportfilterIncludePPE2 == true)

  425.                                     {

  426.                                         DetectionName = "PPE";

  427.                                     }

  428.                                     break;

  429.                                 }

  430.                                 case DETECTION_PEQ2_DETECTION:

  431.                                 {

  432.                                     if(mReportFilters.mReportfilterIncludePEQ2 == true)

  433.                                     {

  434.                                         DetectionName = "Panne Équipement";

  435.                                     }

  436.                                     break;

  437.                                 }

  438.                                 default:

  439.                                 {

  440.                                     DetectionName.clear();

  441.                                     break;

  442.                                 }

  443.                             }

  444. 

  445.                             if(DetectionName.isEmpty() == false)

  446.                             {

  447.                                 ExcelDoc.write(row,1,PassageID);

  448.                                 ExcelDoc.write(row,2,Element->mPassageDateTime.toString("yyyy-MM-dd hh:mm:ss"));

  449.                                 ExcelDoc.write(row,3,Element->mZTDetections.size());

  450.                                 ExcelDoc.write(row,4,"ZT2");

  451.                                 ExcelDoc.write(row,5,QString("%1-%2-%3").arg(Element->mFlags.mTrainCompo1).arg(Element->mFlags.mTrainCompo2).arg(Element->mFlags.mTrainCompo3));

  452.                                 ExcelDoc.write(row,6,DetectionName);

  453.                                 ExcelDoc.write(row,7,Element->mZTDetections.at(detect)->mRank);

  454. 

  455.                                 if(Element->mDetectionFlagsValid == false)

  456.                                 {

  457.                                     ExcelDoc.write(row,8,QString("N/D"));   //Fonction FN

  458.                                     ExcelDoc.write(row,9,QString("N/D"));   //Fonction PG

  459.                                     ExcelDoc.write(row,10,QString("N/D"));  //Fonction PPE

  460.                                     ExcelDoc.write(row,11,QString("N/D"));  //Fonction ZT1

  461.                                     ExcelDoc.write(row,12,QString("N/D"));  //Fonction ZT2

  462.                                 }

  463.                                 else

  464.                                 {

  465.                                     ExcelDoc.write(row,8,QString("N/A"));   //Fonction FN

  466.                                     ExcelDoc.write(row,9,QString("N/A"));   //Fonction PG

  467. 

  468.                                     QString Status = "Hors service";

  469.                                     if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_PP2)

  470.                                     {

  471.                                         Status = "En service";

  472.                                     }

  473.                                     ExcelDoc.write(row,10,Status);  //Fonction PP

  474. 

  475.                                     Status = "Hors service";

  476.                                     if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_ZT1_MASK)

  477.                                     {

  478.                                         Status = "En service";

  479.                                     }

  480.                                     ExcelDoc.write(row,11,Status);        //ZT1

  481. 

  482. 

  483.                                     Status = "Hors service";

  484.                                     if(Element->mFlags.mZTDetectionsConfig & DETECTION_FCT_ZT2_MASK)

  485.                                     {

  486.                                         Status = "En service";

  487.                                     }

  488.                                     ExcelDoc.write(row,12,Status);        //ZT2

  489. 

  490.                                 }

  491. 

  492. 

  493.                                 row++;

  494.                                 IncPassage = true;  //we had ad least one log added, this passage must count...

  495.                             }

  496.                         }

  497. 

  498.                     }

  499.                     if(IncPassage == true || mReportFilters.mReportIncludeSansDeclZT2)

  500.                     {

  501.                         PassageID++;

  502.                     }

  503.                 }

  504.             }

  505.         }

  506.     }

  507. 

  508.     ExcelDoc.save();

  509.     ThreadReportStatus("Rapport créé avec succès!");

  510.     mProgramPtr->ReportCreationFinished(mReportFilename);

  511.     qDebug("Création du rapport terminée");

  512. 

  513.     return RET_OK;

  514. }

  515. 

  516. void CReportGenerator::ThreadReportStatus(QString status)

  517. {

  518.     mProgramPtr->UpdateReportProgressStatus(status);

  519. }

  520. 

  521. int CReportGenerator::AbortReportCreation()

  522. {

  523.     mDirParserWorkerThread->KillThread();

  524.     return RET_OK;

  525. }