/**
* Process SDIF records from the Queue
*
* @return int number of records purged
*/
function ProcessQueueC1Records()
{
// Need C1 record to add or update the swim meet
$this->setQuery(sprintf('SELECT sdifrecord FROM %s WHERE recordtype="C1"', FT_SDIFQUEUE_TABLE));
$this->runSelectQuery(true);
//$sdifrecord = new SDIFC1Record() ;
$sdifrecord = new SwimTeam();
$rslts = $this->getQueryResults();
$rsltscnt = $this->getQueryCount();
// Process each C1 record in the file.
foreach ($rslts as $rslt) {
$sdifrecord->setSDIFRecord($rslt["sdifrecord"]);
$sdifrecord->ParseRecord();
if (!$sdifrecord->SwimTeamExistsByName()) {
$sdifrecord->AddSwimTeam();
} else {
$this->add_status_message(sprintf('Swim Team "%s" already exists in the database, ignored.', $sdifrecord->getTeamName()), FT_WARNING);
}
}
//return $this->getAffectedRows() ;
return $rsltscnt;
}
