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

     // Process Each line of the file
     QTextStream in(&file);
     int ii = 0;
     int bad_cat = 0;
+    bool has_RefError;
+    int  bad_refs = 0;
     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
+        has_RefError = hasRefError(line);
         QStringList parts = splitCsvData(line);
         QString first = parts.value(0);
         bool ok;
         if ( first.isEmpty() )
             continue;
         if ( ! ok || team <= 0 )
             continue;
         tableWidget->setRowCount(1+ii);
         // Insert Team number
-        tableWidget->setItem(ii, 0, new QTableWidgetItem(first));
+        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
-        tableWidget->setItem(ii, 1, new QTableWidgetItem( parts.value(0) ) );
+        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
-        QTableWidgetItem *item = new QTableWidgetItem( parts.value(0)) ;
+        item = new QTableWidgetItem( parts.value(0)) ;
         tableWidget->setItem(ii, 2, item );
         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
-            tableWidget->setItem(ii, 3+yy, new QTableWidgetItem( parts.value(0)));
+            item = new QTableWidgetItem( parts.value(0));
+            tableWidget->setItem(ii, 3+yy, item);
+            if ( hasRefError(parts.value(0)) )
+            {
+                item->setBackgroundColor(QColor(0,0,200,50));
+            }
             parts.removeFirst();
 // Not loading age at the moment
 // Reason: The CSV file is being create with a '0' for the NE teams
 #if DO_AGE_LOAD
             // Posible age - if its a number
         ii++;
+    }
     tableWidget->resizeColumnsToContents();
     // Report errors
-    if (bad_cat)
+    reportErrors( bad_cat, bad_refs);
-    {
-        MainWindow::showMessage("Invalid Categories in data");
-    }
     // Connect up buttons
     connect (load, SIGNAL(clicked()), this, SLOT(loadData()));
     connect(cancel, SIGNAL(clicked()), this, SLOT(close()));
+}
 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();
             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
         */
         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
+ *

Subversion Repositories svn1-original

(root)/Mara/trunk/qmdialogloadexternalteams.cpp – Rev 253 → 275