| MCM ID | Run# | yymmdd | ChipID | ChipID(dec) | Wafer | I_PASA | I_1V8a | I_1V8d | I_3V3d | Function | Remark | \n";
}
Function print_table($sortpar, $mcmid, $chipid, $mcmdate){
include 'dbconfig.php.inc';
$sorting = " ORDER BY ".$sortpar;
if (strlen($mcmdate) > 0){
$query = "SELECT * FROM mcm_test WHERE yymmdd LIKE '$mcmdate%'".$sorting; // 60120110
} else if (strlen($chipid) > 0) {
if ( ( $chipid[1] != 'x') && ( $chipid[1] != 'X') ){
$chipid = "" . "0x" . dechex($chipid);
}
$query = "SELECT * FROM mcm_test WHERE ChipId LIKE '$chipid%'".$sorting; // 60120110
} else {
$query = "SELECT * FROM mcm_test WHERE mcm LIKE '$mcmid%'".$sorting; // 60120110
}
$result = pg_query($query) or die ("
dbases/test/print_table.php.inc - ERROR : Couldn't execute query");
$num = pg_num_rows($result);
if($num != 0 ){
print "
";
print "\n";
print_names();
$bad = 0; $good = 0; $nm = 0; $cm = 0; $bm = 0; $idx = 0;
while ($row = pg_fetch_array($result)){
extract($row);
$chipid_dec = hexdec($chipid);
print "| $mcm | $testrun | $yymmdd | $chipid | $chipid_dec | $wafer | $i_pasa | $i_1v8a | $i_1v8d | $i_3v3d | $function | $remark |
\n";
if ( preg_match ("/BAD/i", $function) ) $bad = $bad + 1;
if ( preg_match ("/GOOD/i", $function) ) $good = $good + 1;
if ( preg_match ("/BM/i", $function) ) $bm = $bm + 1;
if ( preg_match ("/NM/i", $function) ) $nm = $nm + 1;
if ( preg_match ("/CM/i", $function) ) $cm = $cm + 1;
$idx = $idx + 1;
if (($idx & 0x1F) == 0) print_names();
}
print "
\n
$num MCM(s) found. Of them $good good, $nm no merger, $cm column merger, $bm board merger and $bad bad.
";
print "
Run# - test run (1,2,3..)";
print "
yymmdd - year, month, day of the test";
print "
ChipID - lasered 18 bit ChipID in hex, the upper 8 bits determine the wafer, the lower 10 - the position on the wafer";
print "
Wafer - Wafer calculated from the ChipID";
print "
I_PASA - PASA current in mA";
print "
I_1V8a - ADC 1.8V current in mA after configuration";
print "
I_1V8d - digital core current after reset";
print "
I_3V3d - 3.3V digital current in mA after configuration";
print "
Function - Exit code used to mark the MCM (BAD, NM, CM, GOOD)";
print "
For more details for a particular MCM click on the MCMid
";
print "
Back";
} else {
print "
No MCMs found.
Back";
}
pg_close();
}
?>