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');