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;
}
} else {
echo "<br> <b> build GET variable is not set </b> <br>";
exit(1);
}
if (isset($_GET[platform])) {
$platform = $_GET[platform];
} else {
echo "<br> <b> platform GET variable is not set </b> <br>";
exit(1);
}
// login user if required
$arr = loginUser($_POST);
$arr = logoutUser($_POST, $arr);
//printArray($arr);
$filter = isset($_GET['filter']) ? $_GET['filter'] : "";
$regulatoryResults = new regulatoryResults($version, $build, $platform, $filter);
if (isset($_POST[submit])) {
foreach ($_POST as $key => $value) {
$tokens = explode("_", $key);
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();
