File: C:/xampp/htdocs/dpReport/lcdReportF.php
<?php session_start();?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Displayer Check</title>
</head>
<body class="oneColElsCtr">
<?php
$sum=260;
$check=1;
$dtime=time();
$dStr=substr($dtime,7,9)."-";
session_start();
/////////////////////////////////////transfer vi.ti3
$host="127.0.0.1";
$user="root";
$pass="fredsql";
$db="tvicheck-st";
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_query("SET NAMES 'utf8'");
//$link = mssql_connect("MACBOOK7", "sa", "fred5697");
mysql_select_db($db) or die ("Unable to select database!");
// generate and execute query
$query = "select filename from dpReport order by id desc limit 0,1";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
while($row = mysql_fetch_object($result))
{
copy("vx.ti3", "upload/".$row->filename."M.ti3");
}
//mysql_close($connection);
///////////////////////////////////////////////////////////////////////////////////////////////
//move_uploaded_file($_FILES["file"]["tmp_name"],$_FILES["file"]["name"]);
echo $_FILES["file"]["name"] ." upload sucess! " . "<br />";
echo "Report start: " . "<br />";
// echo "Stored in: " . "upload/" . $_FILES["file"]["name"]. "<br />";
$contents = file($f123);
$string = implode($contents);
//echo $contents[20];
//echo $string;
$p = ereg_replace("\r\n?", "\n", $string);
//$p = str_replace("\n", ' ', $p);
$targrt=file("targetlab.txt");
$stringT = implode($targrt);
$pT = ereg_replace("\r\n?", "\n", $stringT);
$pT = str_replace("\n", ' ', $pT);
$dotT=explode(" ", $pT);
//echo "TargrtL=".$dotT[4]."<br />";
//echo $p;
///////////////////////////////////////////////////
function get_between ($text, $s1, $s2) {
$mid_url = "";
$pos_s = strrpos($text,$s1);
$pos_e = strrpos($text,$s2);
for ( $i=$pos_s+strlen($s1) ; (( $i<($pos_e)) && $i < strlen($text)) ; $i++ ) {
$mid_url .= $text[$i];
}
return $mid_url;
}
$datastring=get_between($p,"BEGIN_DATA","END_DATA");
//echo "check here <br />".$datastring;
/////////////////////////////////////////////////////
///white ref
$wString=get_between($p,"LUMINANCE_XYZ_CDM2","KEYWORD");
//echo "check here <br />".$wString;
$dot = explode(" ", $datastring);
$dotw = explode(" ", $wString);
//$WX=substr($dotw[1],1);
$WX=$dot[4];
//$WY=$dotw[2];
$WY=$dot[5];
//$WZ=substr($dotw[3],0,-2);
$WZ=$dot[6];
echo "<br /><br />Luminance:".$WX.",".$WY.",".$WZ;
echo "<br />First set:".$dot[4];
echo ",".$dot[5];
echo ",".$dot[6]."<br />"."<br />";
$i=4;
function getL($WXi,$WYi,$WZi,$Xi,$Yi,$Zi){
$yr=$Yi/$WYi;
if ($yr>0.008856) {
$fy=pow($yr, 1/3);
}
else {
$fy=((903.3*$yr)+16)/116;
}
$Li=(116*$fy)-16;
return round($Li,2);
}
function geta($WXi,$WYi,$WZi,$Xi,$Yi,$Zi){
$yr=$Yi/$WYi;
if ($yr>0.008856) {
$fy=pow($yr, 1/3);
}
else {
$fy=((903.3*$yr)+16)/116;
}
$xr=$Xi/$WXi;
if ($xr>0.008856) {
$fx=pow($xr, 1/3);
}
else {
$fx=((903.3*$xr)+16)/116;
}
$ai=500*($fx-$fy);
return round($ai,2);
}
function getb($WXi,$WYi,$WZi,$Xi,$Yi,$Zi){
$yr=$Yi/$WYi;
if ($yr>0.008856) {
$fy=pow($yr, 1/3);
}
else {
$fy=((903.3*$yr)+16)/116;
}
$zr=$Zi/$WZi;
if ($zr>0.008856) {
$fz=pow($zr, 1/3);
}
else {
$fz=((903.3*$zr)+16)/116;
}
$bi=200*($fy-$fz);
return round($bi,2);
}
function de76($l1,$a1,$b1,$l2,$a2,$b2) {
$d76=sqrt(pow(($l1-$l2),2)+ pow(($a1-$a2),2)+pow(($b1-$b2),2));
return round($d76,2);
}
function de94($l1,$a1,$b1,$l2,$a2,$b2) {
$cp=SQRT(pow($a1,2)+pow($b1,2));
$ctp=SQRT(pow($a2,2)+pow($b2,2));
$d76=sqrt(pow(($l1-$l2),2)+ pow(($a1-$a2),2)+pow(($b1-$b2),2));
$dph=SQRT(ABS(pow($d76,2)-pow(($l1-$l2),2)-pow((SQRT(pow($a1,2)+pow($b1,2))-SQRT(pow($a2,2)+pow($b2,2))),2)));
$dcp=$ctp-$cp;
$d94=SQRT((pow((($l1-$l2)/(1*1)),2))+pow(($dcp/(1*(1+(0.045*$cp)))),2)+ pow(($dph/(1*(1+(0.015*$cp)))),2));
return round($d94,2);
}
?>
<table width="200" border="1" align="center">
<tr align='center'>
<td>RL</td><td>Ra</td><td>Rb</td><td>TL</td><td>Ta</td><td>Tb</td><td>dE(94)</td>
<?php
$TT76=0;
$max76=0;
$max1=0;
$max2=0;
for ( $j = 0; $j <= 23; $j+= 1) {
$X = $dot[$i+($j*7)];
$Y = $dot[$i+1+($j*7)];
$Z = $dot[$i+2+($j*7)];
$L= getL($WX,$WY,$WZ,$X,$Y,$Z);
$a= geta($WX,$WY,$WZ,$X,$Y,$Z);
$b= getb($WX,$WY,$WZ,$X,$Y,$Z);
$de76r=de76($L,$a,$b,$dotT[$j*3],$dotT[$j*3+1],$dotT[$j*3+2]);
$de94r=de94($L,$a,$b,$dotT[$j*3],$dotT[$j*3+1],$dotT[$j*3+2]);
echo "<tr align='right'><td>".round($dotT[$j*3],2)."</td><td>".round($dotT[$j*3+1],2)."</td><td>".round($dotT[$j*3+2],2)."</td><td>".$L."</td><td>".$a."</td><td>".$b."</td><td>";
if ($de94r>2) {
echo "<font color='red'>";}
else {"<font color='black'>";}
echo $de94r."</td></tr>";
$TT94=$de94r+$TT94;
$max1=max($max1,$de94r);
$max94=max($max1,$de94r);
}
echo "<tr align='center'><td>Avg</td><td>".round(($TT94/24),2)."</td><td>Max</td><td>".$max94."</td></tr>";
?>
</table>
<?php
?>
</table>
<tr>
<br />
<td align="center"><font size="-2"> © <a href="mailto:[email protected]">Fred Kuo</a>, 2010. All rights reserved.<br><a href="http://www.fredkuo.idv.tw/wordpress/?p=1025">Read more.</a><br>
</td>
</tr>
</body>
</html>