<?php
ini_set("memory_limit", "500M");
require_once 'config.php';
require_once 'common.php';
require_once 'functions.php';
require_once 'createupdown.php';
require_once 'regulatory_db.php';
dashboardInit();
$version = $_GET['version'];
$build = $_GET['build'];
$caseID = $_GET['case'];
//echo " version = $version <br> build = $build <br> caseID = $caseID <br> ";
$linkID = regulatory_dbconnect();
//$linkID = connectDB('10.4.107.12','root','','regulatory');
$sql_cmd = "select versionID from versions where buildNum like '%{$build}%' and versionDottedQuad like '%{$version}%' ";
$result = mysql_query($sql_cmd);
$num_rows = mysql_num_rows($result);
if ($num_rows == 0) {
echo "<br> version & build not found <br>";
exit(1);
}
$row = mysql_fetch_array($result);
$versionID = $row['versionID'];
$sql_cmd = "select scriptResultID from caseResults where caseID={$caseID}";
// echo "<br> $sql_cmd <br>";
// exit(1);
$result = mysql_query($sql_cmd);
$num_rows = mysql_num_rows($result);
if ($num_rows == 0) {
echo "<br> No script results found for caseID={$caseID} <br>";
private function initalizeRegulatoryTableWithVersions()
{
$runStatusData = array();
$con = regulatory_dbconnect();
$sql_query = "select * from runStatus";
$result = mysql_query($sql_query);
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
$runStatusData[$row['runStatusID']] = $row['runStatus'];
}
$loopStart = count($this->versions) - 1;
for ($index = $loopStart; $index >= 1; $index--) {
$version = $this->versions[$index];
$sql_query = "select * from runs where versionID={$version['versionID']}";
$result = mysql_query($sql_query);
$num_rows = mysql_num_rows($result);
$i = 1;
while ($row = mysql_fetch_assoc($result)) {
if ($i == 1) {
$firstRun = $row['startedRun'];
}
if ($i == $num_rows) {
$lastRun = $row['startedRun'];
$runStatus = $row['runStatusID'];
}
// if end
$i++;
}
// while end
mysql_close($con);
$countersInfo = $this->calculateCounters($version, $lastRun);
$con = regulatory_dbconnect();
if ($countersInfo['channelTotal'] != 0 || $countersInfo['EIRPTotal'] != 0) {
if ($countersInfo['newEntry'] == 1) {
$sql_query = "INSERT INTO regulatoryResults (versionID,build,version, firstRun, lastRun,channelTotal,channelPass,channelFail,channelStatus,channelResult,eirpTotal,eirpPass,eirpFail, eirpStatus,eirpResult,channelCountries,eirpCountries) VALUES ({$version['versionID']},'{$version['buildNum']}', '{$version['versionDottedQuad']}','{$firstRun}','{$lastRun}',{$countersInfo['channelTotal']}, {$countersInfo['channelPass']},{$countersInfo['channelFail']}, 'Running','',{$countersInfo['EIRPTotal']},{$countersInfo['EIRPPass']},{$countersInfo['EIRPFail']},'Running','',{$countersInfo['channelCountries']},{$countersInfo['eirpCountries']})";
$result = mysql_query($sql_query);
if ($result != 1) {
echo "<br> Failed to insert a row into regulatoryResults table <br>";
exit(1);
}
// echo "<h1> New Entry </h1>";
// printArray($countersInfo);
}
//if
if ($countersInfo['updateCounters'] == 1) {
$sql_query = "update regulatoryResults set channelTotal={$countersInfo['channelTotal']},channelPass={$countersInfo['channelPass']},channelFail={$countersInfo['channelFail']},EIRPTotal={$countersInfo['EIRPTotal']},EIRPPass={$countersInfo['EIRPPass']},EIRPFail={$countersInfo['EIRPFail']},lastRun='{$lastRun}',channelCountries={$countersInfo['channelCountries']},eirpCountries={$countersInfo['eirpCountries']} where versionID={$version['versionID']}";
$result = mysql_query($sql_query);
if ($result != 1) {
echo "<br> Failed to Update a row in regulatoryResults table <br>";
exit(1);
}
// echo "<h1> Update Entry </h1>";
// printArray($countersInfo);
}
}
// if end
}
//for end
mysql_close($con);
}
public function getRegulatoryBugs($build, $platform)
{
$con2 = regulatory_dbconnect();
$regulatoryBugs = array();
$sql_query = "select * from RegulatoryBugs where buildNum like '%{$build}%' and platform like '%{$platform}%' ";
$result = mysql_query($sql_query);
$num_rows = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
$bugs = explode(",", $row['bugs']);
$regulatoryBugs[$build][$platform][$row['countryId']][$row['apId']] = array();
array_push($regulatoryBugs[$build][$platform][$row['countryId']][$row['apId']], $bugs);
}
// while end
regulatory_dbclose($con2);
return $regulatoryBugs;
}
