<?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; }