private function calculateCounters($version, $lastRun)
{
$countersInfo = array('newEntry' => 0, 'updateCounters' => 0, 'channelCountries' => 0, 'channelTotal' => 0, 'channelPass' => 0, 'channelFail' => 0, 'channelNA' => 0, 'eirpCountries' => 0, 'EIRPTotal' => 0, 'EIRPPass' => 0, 'EIRPFail' => 0, 'EIRPNA' => 0);
$newEntry = 0;
$updateCounters = 0;
$con_3 = regulatory_dbconnect();
$sql_query = "select * from regulatoryResults where version like '%{$version['versionDottedQuad']}%' and build like '%{$version['buildNum']}%' ";
$result = mysql_query($sql_query);
$num_rows = mysql_num_rows($result);
if ($num_rows == 0) {
$newEntry = 1;
}
if ($newEntry == 0) {
$sql_query = "select * from regulatoryResults where version like '%{$version['versionDottedQuad']}%' and build like '%{$version['buildNum']}%' ";
$result = mysql_query($sql_query);
$num_rows = mysql_num_rows($result);
regulatory_dbclose($con_3);
if ($num_rows == 1) {
$updateCounters = 1;
}
}
$countersInfo['newEntry'] = $newEntry;
$countersInfo['updateCounters'] = $updateCounters;
if ($newEntry == 1 || $updateCounters == 1) {
$obj1 = new regulatoryResults($version[versionDottedQuad], $version[buildNum], "Channel", "");
$channelResult = $obj1->getRegulatoryData();
$countersInfo['channelCountries'] = count($channelResult);
$obj2 = new regulatoryResults($version[versionDottedQuad], $version[buildNum], "EIRP", "");
$EIRPResult = $obj2->getRegulatoryData();
$countersInfo['eirpCountries'] = count($EIRPResult);
foreach ($channelResult as $countryChannelResult) {
foreach ($countryChannelResult as $apChannelResult) {
switch ($apChannelResult['result']) {
case 'pass':
$countersInfo['channelPass']++;
break;
case 'fail':
$countersInfo['channelFail']++;
break;
case 'N/A':
$countersInfo['channelNA']++;
break;
}
// switch
$countersInfo['channelTotal']++;
}
}
// inner foreach
foreach ($EIRPResult as $countryEIRPResult) {
foreach ($countryEIRPResult as $apEIRPResult) {
switch ($apEIRPResult['result']) {
case 'pass':
$countersInfo['EIRPPass']++;
break;
case 'fail':
$countersInfo['EIRPFail']++;
break;
case 'N/A':
$countersInfo['EIRPNA']++;
break;
}
// switch
$countersInfo['EIRPTotal']++;
}
}
// inner foreach
}
// if
// printArray($countersInfo);
return $countersInfo;
}
if ($tokens[0] == "bug" && count($tokens) == 5) {
if (trim($value) != "") {
$regulatoryResults->saveRegulatoryBug($tokens[1], $tokens[2], $tokens[3], $tokens[4], $value);
}
}
// if
}
// foreach
}
// if
$runs = $regulatoryResults->getRuns();
$firstRun = $regulatoryResults->getFirstRun();
$lastRun = $regulatoryResults->getLastRun();
$noOfRuns = $regulatoryResults->getNoOfRuns();
$aps = $regulatoryResults->getAps();
$regulatoryData = $regulatoryResults->getRegulatoryData();
$regulatoryBugs = $regulatoryResults->getRegulatoryBugs($build, $platform);
$countries = $regulatoryResults->getCountries();
$smarty = new TLSmarty();
$smarty->assign('version', $version);
$smarty->assign('build', $build);
$smarty->assign('platform', $platform);
$smarty->assign('javaScript', "<script type='text/javascript'> \$(document).ready(function(){ \$('label').append(':'); }); </script>");
$smarty->assign('aps', $aps);
$smarty->assign('countries', $countries);
$smarty->assign('regulatoryData', $regulatoryData);
$smarty->assign('regulatoryBugs', $regulatoryBugs);
$smarty->assign('valid_user', $arr[0]);
$smarty->assign('none', $arr[1]);
$smarty->assign('userString', $arr[2]);
$smarty->display('regulatoryresults.tpl');
