File: C:/xampp/htdocs/cmykDe/CNYplate/tvireport.php
<!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>Fogra Plate Check</title>
<style type="text/css">
<!--
body {
font: 100% Verdana, Arial, Helvetica, sans-serif;
background: #ffffff;
margin: 0; /* 比較好的做法是將 Body 元素的邊界與欄位間隔調整為零，以處理不同的瀏覽器預設值 */
padding: 0;
text-align: center; /* 這樣會讓容器在 IE 5* 瀏覽器內置中對齊。然後，文字會在 #container 選取器中設定為靠左對齊預設值 */
color: #000000;
}
.oneColElsCtr #container {
width: 46em;
background: #FFFFFF;
margin: 0 auto; /* 自動邊界 (搭配寬度) 會讓頁面置中對齊 */
border: 0px solid #000000;
text-align: left; /* 這樣做會覆寫 Body 元素上的 text-align: center。 */
}
.oneColElsCtr #mainContent {
padding: 0 20px; /* 請記住，欄位間隔就是 Div 方塊內部的空間，而邊界就是 Div 方塊外部的空間 */
}
-->
</style></head>
<body class="oneColElsCtr">
<?php
$connection = mysql_connect("127.0.0.1", "root", "fredsql") or die ("Unable to connect!");
mysql_query("SET NAMES 'utf8'");
$db = "tvicheck-st";
// select database
mysql_select_db($db) or die ("Unable to select database!");
//$myip = $_SERVER['REMOTE_ADDR'];
//echo $myip;
//$myip='210.71.174.1';
// generate and execute query
$query = " SELECT * from fplate order by id desc limit 0,1 ";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
//$row = mysql_fetch_object($result);
$cct=0;
while($row = mysql_fetch_object($result))
{
if ($ctp=='') {$ctp=$row->ctp;}
if ($size==''){$size=$row->size;}
if ($fStep=='') {$fStep=$row->fStep;}
if ($dvTime=='') { $dvTime=$row->dvTime;}
if ($dvTemp=='') { $dvTemp=$row->dvTemp;}
if ($stf=='') { $stf=$row->stf;}
if ($plat=='' && $row->pt=='C') { echo "get M";$plat='M';}
if ($plat=='' && $row->pt=='M') { echo "get Y"; $plat='Y';}
if ($plat=='' && $row->pt=='Y') { echo "get K"; $plat='K';}
if ($pNo=='' ) { $pNo=($row->pNo)+1;}
$cid=$row->id;
}
// echo $stf."block ";
///////////////////////////////////////////////////////////////blocking 10
?>
<?php
$sum=260;
$check=1;
echo "Fogra Plate Checking form!" . "<br />";
echo "Report start: " . "<br />";
// echo "Stored in: " . "upload/" . $_FILES["file"]["name"]. "<br />";
///parsing start
$contents = file("upload/".$tvifile);
$string = implode($contents);
//echo $contents[20];
//echo $string;
$p = ereg_replace("\r\n?", "\n", $string);
$p = str_replace("\n", ',', $p);
//echo $p;
$dot = explode(",", $p);
//$dot = explode("\t", $p);
if ($dot[0]>75) {
$PL=$dot[0];//paper
$Pa=$dot[1];
$Pb=$dot[2];
//echo "__PL".$PL."end--<br>";
$c100L=$dot[7];///solid
$c100a=$dot[8];
$c100b=$dot[9];
//echo "__P6:".$c100L."end--<br>";
$T50L=$dot[14];//T50
$T50a=$dot[15];
$T50b=$dot[16];
//echo "__P14:".$T50L."end--<br>";
$T25L=$dot[21];//T25
$T25a=$dot[22];
$T25b=$dot[23];
//echo "__P21:".$T25L."end--<br>";
}
else { ///for 2 patch
$connection = mysql_connect("127.0.0.1", "root", "fredsql") or die ("Unable to connect!");
mysql_query("SET NAMES 'utf8'");
$db = "tvicheck-st";
// select database
mysql_select_db($db) or die ("Unable to select database!");
// generate and execute query
if ($plat=='M' ) {
$query = "select * from fplate where id ='$cid' ";}
if ($plat=='Y' ) {
$query = "select * from fplate where id =$cid-1 ";}
if ($plat=='K' ) {
$query = "select * from fplate where id =$cid-2 ";}
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
while($row = mysql_fetch_object($result))
{
$fileP=$row->filename;
echo "fileP=".$fileP;
}
$contentp = file("upload/".$fileP);
$stringp = implode($contentp);
//echo $contents[20];
//echo $string;
$pp = ereg_replace("\r\n?", "\n", $stringp);
$pp = str_replace("\n", ',', $pp);
//echo $p;
$dott = explode(",", $pp);
$PL=$dott[0];//paper
$Pa=$dott[1];
$Pb=$dott[2];
//echo "__PL".$PL."end--<br>";
$c100L=$dott[7];///solid
$c100a=$dott[8];
$c100b=$dott[9];
$T50L=$dot[0];//T50
$T50a=$dot[1];
$T50b=$dot[2];
//echo "__P14:".$T50L."end--<br>";
$T25L=$dot[7];//T25
$T25a=$dot[8];
$T25b=$dot[9];
}
//echo "__kT25b".$T25b."end--<br>";
//echo "__k100a".$k100a."end--<br>";
//echo "__k100b".$k100b."end--<br>";
?>
<table width="200" border="1" align="center">
<tr></tr>
<tr>
<td><div align="center">主色</div></td>
<td><font color="#aaaaaa">X</font></td>
<td><font color="#aaaaaa">Y</font></td>
<td><font color="#aaaaaa">Z</font></td>
<td><font color="#aaaaaa">TVI</font></td>
<td><font color="#aaaaaa">den</font></td>
</tr>
<tr>
<td bgcolor="#33CCFF"><div align="center">底色</div></td>
<?php
function getX($L,$a,$b){
$TT=(($a/500)+(($L+16)/116));
if($TT>0.206893) {
$X=96.422*$TT*$TT*$TT;}
else {
$X=96.422*((($a/500)+(($L+16)/116)-(16/116))/7.787);}
return round($X,2);
}
function getY($L,$a,$b){
$TL=($L+16)/116;
IF ($TL>0.206893) {
$Y=100*$TL*$TL*$TL;}
else {
$Y=100*(($L/116)/7.7873);}
return round($Y,2);
}
function getZ($L,$a,$b){
$Tb=(($L+16)/116)-($b/200);
IF($Tb>0.206893){
$Z=82.521*$Tb*$Tb*$Tb;}
else {
$Z=82.521*( (($L+16)/116)-($b/200)-(16/116))/7.787;}
return round($Z,2);
}
$PX=getX($PL,$Pa,$Pb);
$PY=getY($PL,$Pa,$Pb);
$PZ=getZ($PL,$Pa,$Pb);
$C100X=getX($c100L,$c100a,$c100b);//Solid xyz
$C100Y=getY($c100L,$c100a,$c100b);
$C100Z=getZ($c100L,$c100a,$c100b);
$T50X=getX($T50L,$T50a,$T50b);
$T50Y=getY($T50L,$T50a,$T50b);
$T50Z=getZ($T50L,$T50a,$T50b);
$T25X=getX($T25L,$T25a,$T25b);
$T25Y=gety($T25L,$T25a,$T25b);
$T25Z=getZ($T25L,$T25a,$T25b);
//$TVI_50d=(((1-(pow(10,(-($dot[18]-$dot[4])))))/(1-(pow(10,(-($dot[11]-$papc)))))))*100;
///////////////////C loop
//echo "Paper X=".$PX.", Y=".$PY.", Z=".$PZ."<br>";
//echo "Solid X=".$C100X.", Y=".$C100Y.", Z=".$C100Z."<br>";
//echo "T50 X=".$T50X.", Y=".$T50Y.", Z=".$T50Z."<br>";
$TVI_50=round(($PX-$T50X)/($PX-$C100X)*100,2);
//echo "T50 TVI=". $TVI_50;
$TVI_25=round(($PX-$T25X)/($PX-$C100X)*100,2);
//echo ", T25 TVI=". $TVI_25."<br>";
//echo ", T50D TVI=". $TVI_50d."<br>";
?>
<td bgcolor="#33CCFF"><div align="center"><?php echo $PX;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $PY;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $PZ;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo "";?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php if ($dot[0]>75) { $pap=$dot[4];echo $dot[4];} else {$pap=$dott[4];echo $dott[4];}?></div></td>
</tr>
<tr>
<td bgcolor="#33CCFF"><div align="center">滿版</div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $C100X;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $C100Y;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $C100Z;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo "";?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php if ($dot[0]>75) { $sid=$dot[11];echo $dot[11];} else { $sid=$dott[11];echo $dott[11];}?></div></td>
</tr>
<tr>
<td bgcolor="#33CCFF"><div align="center">40%</div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $T50X;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $T50Y;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $T50Z;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $TVI_50;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $dot[18];?></div></td>
</tr>
<tr>
<td bgcolor="#33CCFF"><div align="center">70%</div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $T25X;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $T25Y;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $T25Z;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $TVI_25;?></div></td>
<td bgcolor="#33CCFF"><div align="center"><?php echo $dot[25];?></div></td>
</tr>
</table>
<tr>
<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>