File: C:/xampp/htdocs/cmykDe/CNYplate/TVI-parsing12_2p.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>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;
margin-left: 1px;
margin-top: 1px;
margin-right: 1px;
margin-bottom: 1px;
}
.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=='' and $row->pt=='C') { $plat='M';)
if ($plat=='' and $row->pt=='M') { $plat='Y';)
if ($plat=='' and $row->pt=='Y') { $plat='K';)
if ($pNo=='' ) { $pNot=$row->pNo+1';)
}
// echo $stf."block ";
///////////////////////////////////////////////////////////////blocking 10
?>
<?php
function get_betweenC ($text, $s1, $s2) {
$mid_url = "";
$pos_s = strrpos($text,$s1);
$pos_e = strpos($text,$s2);
for ( $i=$pos_s+strlen($s1) ; (( $i<($pos_e)) && $i < strlen($text)) ; $i++ ) {
$mid_url .= $text[$i];
}
return $mid_url;
}
$dtime=time();
$dStr=substr($dtime,7,9)."-";
$sum=260;
$check=1;
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{
echo "Plate checking form! " . "<br />".$device;
echo "Upload: " . $_FILES["file"]["name"] . "<br />";
$filename=$dStr.$_FILES["file"]["name"];
//echo "Type: " . $_FILES["file"]["type"] . "<br />";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
// echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
if (file_exists("upload/" .$dStr. $_FILES["file"]["name"]))
{
echo $_FILES["file"]["name"] . " already exists. ". "<br />";
}
else
{
//move_uploaded_file($_FILES["file"]["tmp_name"],
//"upload/" .$dStr. $_FILES["file"]["name"]);
echo "upload sucess! f21" .$f321. "<br />";
echo "Report start: " . "<br />";
// echo "Stored in: " . "upload/" . $_FILES["file"]["name"]. "<br />";
///parsing start
$filenamex=substr($f321,7);
$rest = substr($f321, 0, -4);
$dbn=explode("-",$rest);
$pt=$dbn[1];
$po=$dbn[2];
echo "ptn:".$pt."-".$po."<br>";
$contents = file($f321);
$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);
$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>";
//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 echo $dot[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 echo $dot[11];?></div></td>
</tr>
<tr>
<td bgcolor="#33CCFF"><div align="center">50%</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">25%</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>
<?php
/////////////////////data base sector/////////
$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
$query = "INSERT INTO Fplate(contact,filename, ctp, pt, size, fStep, dvTime, dvTemp, pNo, filter, chem, wash, stf, date, plog, SID, paper, T50, T25) VALUES( '$contact', '$filenamex', '$ctp', '$plat', '$size', '$fStep', '$dvTime','$dvTemp','$pNo','$filter','$chem','$wash','$stf', NOW(), 'CNPT1', '$dot[11]', '$dot[4]', '$TVI_50', '$TVI_25')";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
mysql_close($connection);
////////////////////data base sector/////////////////
}//satrt parsing
}//upload sucess
?>
</table>
<td align="center"> <a href="rank.php">Report</a><br>
</td>
</tr>
<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>