WebSVN – svn1 – Diff – /Mara/trunk/qmdialogloadexternalteams.cpp

 #include "qmdialogloadexternalteams.h"
-#include "ui_qmdialogloadexternalteams.h"
+//#include "ui_qmdialogloadexternalteams.h"
 #include "QFile"
 #include "QTextStream"
 #include "mainwindow.h"
 #include <QRegExp>
 #include <QtGui/QHBoxLayout>
 #include <QtGui/QVBoxLayout>
 #include <QtGui/QWidget>
+#include <QHeaderView>
+#include <QtWebKit/QtWebKit>
 #include    "consts.h"
 #include    "structs.h"
 #include    "proto.h"
+/*----------------------------------------------------------------------------
+** FUNCTION           : QmDialogLoadExternalTeams
+**
+** DESCRIPTION        : Load team data from a CSV file
+**
+**
+** INPUTS             : efile       - name of file
+**                      parent      - parent widget
+**
+** RETURNS            :
+**
+----------------------------------------------------------------------------*/
 QmDialogLoadExternalTeams::QmDialogLoadExternalTeams(const QString &efile,QWidget *parent) :
-    QDialog(parent)
+        QDialog(parent)
+{
     //
     // Create Windows
     //
+    createWindow();
+    fileName->setText(efile);
+    // Open the users file
+    QFile file(efile);
+    if ( ! file.open(QIODevice::ReadOnly | QIODevice::Text) )
+    {
+        MainWindow::showMessage("Cannot open external data file");
+        return;
+    }
+    MainWindow::showMessage("Loading External Data");
+    // Process Each line of the file
+    QTextStream in(&file);
+    QRegExp csv_split("\"?,\"?");
+    while (!in.atEnd())
+    {
+        QString line = in.readLine();
+        line = line.trimmed();             // Remove leading and training White Space
+        line.remove(0xA0);                 // M$ special uglyness
+        line.remove(0xC2);                 // M$ special uglyness
+        bool has_RefError = hasRefError(line);
+        QStringList parts = splitCsvData(line);
+        insertParts( parts, has_RefError );
+    }
+    // Post Load fix up
+    tableWidget->resizeColumnsToContents();
+    reportErrors( bad_cat, bad_refs);
+}
+/*----------------------------------------------------------------------------
+** FUNCTION           : QmDialogLoadExternalTeams
+**
+** DESCRIPTION        : Load team data from a Web Page
+**
+**
+** INPUTS             : efile       - name of file (display only)
+**                      data        - Address of the webpage data loaded in memory
+**                      parent      - parent widget
+**
+** RETURNS            :
+**
+----------------------------------------------------------------------------*/
+QmDialogLoadExternalTeams::QmDialogLoadExternalTeams(const QString &efile, QByteArray *data ,QWidget *parent) :
+        QDialog(parent)
+{
+    // Create the basic Window
+    createWindow();
+    fileName->setText(efile);
+    // Parse the data. It is an html file
+    //
+    MainWindow::showMessage("Parsing HTML");
+    //qDebug("Data size: %d", data->length());
+    QWebPage page;
+    QWebFrame * frame = page.mainFrame();
+    frame->setContent(*data);
+    /*
+    **  Get the first table
+    **      Get all rows
+    **      Get all data items in each row
+    */
+    QWebElement document = frame->documentElement();
+    QWebElement firstTable = document.findFirst("table");
+    QWebElementCollection elements = firstTable.findAll("tr");
+    foreach(QWebElement e, elements){
+        //qDebug()<< "e element" <<e.tagName() << ":" << e.toPlainText();
+        //qDebug("-----Row");
+        bool has_RefError = hasRefError(e.toPlainText());
+        QWebElementCollection td = e.findAll("td");
+        QStringList parts;
+        foreach(QWebElement e, td)
+        {
+            //qDebug()<< e.tagName() << ":" << e.toPlainText();
+            parts.append(e.toPlainText());
+        }
+        insertParts( parts, has_RefError );
+    }
+    // Post Load fix up
+    tableWidget->resizeColumnsToContents();
+    reportErrors( bad_cat, bad_refs);
+}
+/*----------------------------------------------------------------------------
+** FUNCTION           : createWindow
+**
+** DESCRIPTION        : Create the basic window
+**                      Used in multiple places
+**
+**
+** INPUTS             :
+**
+** RETURNS            :
+**
+----------------------------------------------------------------------------*/
+void QmDialogLoadExternalTeams::createWindow(void)
+{
+    bad_cat = 0;
+    bad_refs = 0;
     resize(550, 500);
     setSizeGripEnabled(true);
     setWindowTitle("Load External Team Data");
     QVBoxLayout *verticalLayout;
     verticalLayout = new QVBoxLayout(this);
     verticalLayout->setContentsMargins(0, 0, 0, 0);
     QVBoxLayout *verticalLayout2;
-    verticalLayout2 = new QVBoxLayout(this);
+    verticalLayout2 = new QVBoxLayout();
     verticalLayout2->setContentsMargins(5, 5, 5, 5);
     QHBoxLayout *horizontalLayout;
     horizontalLayout = new QHBoxLayout();
     fileName = new QLineEdit(this);
     fileName->setObjectName(QString::fromUtf8("fileName"));
     fileName->setGeometry(QRect(20, 470, 331, 20));
     fileName->setReadOnly(true);
-    fileName->setText(efile);
     horizontalLayout->addWidget(fileName);
     load = new QPushButton(this);
     load->setObjectName(QString::fromUtf8("load"));
     load->setGeometry(QRect(370, 470, 75, 23));
     load->setText("Load");
     horizontalLayout->addWidget(load);
     cancel->setText("Cancel");
     horizontalLayout->addWidget(cancel);
     verticalLayout->addLayout(horizontalLayout);
-    // Open the users file
-    QFile file(efile);
-    if ( ! file.open(QIODevice::ReadOnly | QIODevice::Text) )
-    {
-        MainWindow::showMessage("Cannot open external data file");
-        return;
-    }
-    MainWindow::showMessage("Loading External Data");
     // Insert column headers
     tableWidget->setColumnCount(3 + ( 2 * config.num_legs) );
     QStringList labels;
     labels << "Team" << "Team Name" << "Cat";
     for (int ii = 1; ii <= config.num_legs; ii++ )
+    {
         labels += QString("Leg:%1").arg(QString::number(ii));
         labels += QString("Age:%1").arg(QString::number(ii));
+    }
     tableWidget->setHorizontalHeaderLabels(labels);
-    // Process Each line of the file
+    // Connect up buttons
-    QTextStream in(&file);
+    connect (load, SIGNAL(clicked()), this, SLOT(loadData()));
-    int ii = 0;
-    int bad_cat = 0;
-    QRegExp csv_split("\"?,\"?");
+    connect(cancel, SIGNAL(clicked()), this, SLOT(close()));
-    while (!in.atEnd())
-    {
+}
-        QString line = in.readLine();
-        line = line.trimmed();             // Remove leading and training White Space
-        line.remove(0xA0);                 // M$ special uglyness
-        QStringList parts = splitCsvData(line);
+/*----------------------------------------------------------------------------
-        QString first = parts.value(0);
+** FUNCTION           : insertParts
-        bool ok;
+**
-        if ( first.isEmpty() )
+** DESCRIPTION        : Insert raw data into the display table
+**
-            continue;
+**
-        int team = first.toInt(&ok);
+** INPUTS             : parts           - Ref to a list of parts
-        if ( ! ok || team <= 0 )
+**                      has_RefError    - Data has Ref Error
+**
-            continue;
+** RETURNS            :
+**
-        tableWidget->setRowCount(1+ii);
+----------------------------------------------------------------------------*/
+void QmDialogLoadExternalTeams::insertParts(QStringList &parts, bool has_RefError)
+{
-        // Insert Team number
+    QString first = parts.value(0);
+    bool ok;
-        tableWidget->setItem(ii, 0, new QTableWidgetItem(first));
+    if ( first.isEmpty() )
-        parts.removeFirst();
+        return;
-        // Extract Team Name
+    int team = first.toInt(&ok);
-        tableWidget->setItem(ii, 1, new QTableWidgetItem( parts.value(0) ) );
+    if ( ! ok || team <= 0 )
-        parts.removeFirst();
+        return;
-        // Extract Team Cat
+    int ii = tableWidget->rowCount();
-        QTableWidgetItem *item = new QTableWidgetItem( parts.value(0)) ;
-        tableWidget->setItem(ii, 2, item );
+    tableWidget->setRowCount(1 + ii );
+    // Insert Team number
+    QTableWidgetItem *item = new QTableWidgetItem(first);
+    tableWidget->setItem(ii, 0, item );
+    parts.removeFirst();
+    if ( has_RefError )
+    {
+        item->setBackgroundColor(QColor(0,0,200,50));
+        bad_refs++;
+    }
+    // Extract Team Name
+    item = new QTableWidgetItem( parts.value(0) );
+    tableWidget->setItem(ii, 1, item );
+    if ( hasRefError(parts.value(0)) )
+    {
+        item->setBackgroundColor(QColor(0,0,200,50));
+    }
+    parts.removeFirst();
+    // Extract Team Cat
+    item = new QTableWidgetItem( parts.value(0)) ;
+    tableWidget->setItem(ii, 2, item );
-        if (config.lookup_class(qPrintable(parts.value(0)) ) <= 0 )
+    if (config.lookup_class(qPrintable(parts.value(0)) ) <= 0 )
+    {
+        item->setBackgroundColor(QColor(200,0,0,50));
+        bad_cat++;
+    }
+    if ( hasRefError(parts.value(0)) )
+    {
+        item->setBackgroundColor(QColor(0,0,200,50));
+    }
+    parts.removeFirst();
+    int yy = 0;
+    while ( parts.count() > 0)
+    {
+        // Name of competitor
+        item = new QTableWidgetItem( parts.value(0));
+        tableWidget->setItem(ii, 3+yy, item);
+        if ( hasRefError(parts.value(0)) )
+        {
-            item->setBackgroundColor(QColor(200,0,0,50));
+            item->setBackgroundColor(QColor(0,0,200,50));
-            bad_cat++;
+        }
         parts.removeFirst();
-        int yy = 0;
-        while ( parts.count() > 0)
-        {
-            // Name of competitor
-            tableWidget->setItem(ii, 3+yy, new QTableWidgetItem( parts.value(0)));
-            parts.removeFirst();
-// Not loading age at the moment
+        // Not loading age at the moment
-// Reason: The CSV file is being create with a '0' for the NE teams
+        // Reason: The CSV file is being create with a '0' for the NE teams
 #if DO_AGE_LOAD
-            // Posible age - if its a number
+        // Posible age - if its a number
-            int age = parts.value(0).toInt(&ok);
+        int age = parts.value(0).toInt(&ok);
-            if ( ok )
+        if ( ok )
+        {
+            if ( age > 0 )
+            {
-                if ( age > 0 )
-                {
-                    tableWidget->setItem(ii, 4+yy, new QTableWidgetItem( parts.value(0)));
+                tableWidget->setItem(ii, 4+yy, new QTableWidgetItem( parts.value(0)));
-                }
-                parts.removeFirst();
+            }
-#endif
-            yy += 2;
+            parts.removeFirst();
+        }
-        ii++;
-    }
+#endif
-    tableWidget->resizeColumnsToContents();
-    // Report errors
-    if (bad_cat)
+        yy += 2;
-    {
-        MainWindow::showMessage("Invalid Categories in data");
+    }
-    // Connect up buttons
-    connect (load, SIGNAL(clicked()), this, SLOT(loadData()));
-    connect(cancel, SIGNAL(clicked()), this, SLOT(close()));
+}
+/*----------------------------------------------------------------------------
+** FUNCTION           : ~QmDialogLoadExternalTeams
+**
+** DESCRIPTION        : Class destructor
+**
+**
+** INPUTS             :
+**
+** RETURNS            :
+**
+----------------------------------------------------------------------------*/
 QmDialogLoadExternalTeams::~QmDialogLoadExternalTeams()
+{
+}
+/*----------------------------------------------------------------------------
+** FUNCTION           : loadData
+**
+** DESCRIPTION        : Store the data from the table into the database
+**
+**
+** INPUTS             :
+**
+** RETURNS            :
+**
+----------------------------------------------------------------------------*/
 void QmDialogLoadExternalTeams::loadData(void)
+{
     qDebug ("LoadData");
     team_type team_buf;
     int bad_cat = 0;
+    int bad_refs = 0;
     for ( int ii = 0; ii < tableWidget->rowCount(); ii++)
+    {
         if ( tableWidget->isRowHidden(ii))
+        {
             continue;
+                    }
                     item = tableWidget->item(ii,yy);
                     if (item)
+                    {
                         strncpy(team_buf.members[member].name , qPrintable(item->data(Qt::EditRole).toString()), sizeof(team_buf.members[member].name));
+                        if ( hasRefError(item->data(Qt::EditRole).toString()) )
+                        {
+                            bad = true;
+                            bad_refs++;
+                        }
+                    }
                     item = tableWidget->item(ii,1+yy);
                     if (item)
+                    {
                         int age = item->data(Qt::EditRole).toInt();
                             team_buf.members[member].age = age;
+                        }
+                    }
+                }
+                team_buf.flags.valid = TRUE;
                 put_team_record( team, &team_buf );
+            }
             else
+            {
                 bad = true;
             tableWidget->hideRow(ii);
+        }
+    }
     // Report errors
+    reportErrors( bad_cat, bad_refs);
+}
+/*----------------------------------------------------------------------------
+** FUNCTION           : reportErrors
+**
+** DESCRIPTION        : Report errors on the main window
+**
+**
+** INPUTS             : bad_cat - count of category erors
+**                      bad_refs - count of Reference errors
+**
+** RETURNS            :
+**
+----------------------------------------------------------------------------*/
+void QmDialogLoadExternalTeams::reportErrors( int bad_cat, int bad_refs )
+{
+    if ( bad_cat && bad_refs )
+    {
+        MainWindow::showMessage("Invalid Categories in data and bad REFs");
+    }
-    if (bad_cat)
+    else if (bad_cat)
+    {
         MainWindow::showMessage("Invalid Categories in data");
+    }
+    else if (bad_refs)
+    {
+        MainWindow::showMessage("Imported data has bad REFs");
+    }
+}
 /*========================================================================
+ *
  *  Generate team name file
             data++;
             /*
             ** Ugly character from MS CSV files
+            ** Not too sure what the 194 is. It looks like a 0xA0 in the raw data
             */
-            if ( uch == (char) 0xA0 )
+            if ( uch == (char) 0xA0 || uch == (char)194 )
+            {
                 continue;
+            }
             if ( !quoted && uch == ',' )
         /*
         **  Clean up the extracted string
         */
         results += result.trimmed();
-     }
+    }
     return results;
+}
+/*----------------------------------------------------------------------------
+** FUNCTION           : hasRefError
+**
+** DESCRIPTION        : Determine if a string contains an Excel Reference
+**                      error: #REF!
+**
+**
+** INPUTS             : data - String to test
+**
+** RETURNS            : True: Is an error
+**
+----------------------------------------------------------------------------*/
+bool QmDialogLoadExternalTeams::hasRefError( const QString data)
+{
+    return data.contains("#REF!");
+}
 /*========================================================================
+ *
  *  Generate team name file
+ *
         MainWindow::showMessage("Cannot open external team info file");
         return;
+    }
     QTextStream out(&file);
-     /*
+    /*
      * Put the data into the file
      */
     team_type   team_buf;
     for(int i = config.min_team; i <= config.max_team; i++ )
+    {

Subversion Repositories svn1

(root)/Mara/trunk/qmdialogloadexternalteams.cpp – Rev 224 → 380