File: C:/xampp/htdocs/FograCT951/tvireportxbk1227.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>Production 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">
<br>
<br>
<?php
error_reporting(0);
$tvifile= $_GET['tvifile'];
$po= $_GET['po'];
$id= $_GET['id'];
$connection = mysql_connect("localhost:3306", "pbn", "fredsql5697") or die ("Unable to connect!");
mysql_query("SET NAMES 'utf8'");
$db = "pbn_db";
// select database
mysql_select_db($db) or die ("Unable to select database!");
$querys = "select * from production where id='$id'";
$results = mysql_query($querys) or die ("Error in query: $querys. " . mysql_error());
if (mysql_num_rows($results) > 0)
{
$row = mysql_fetch_object($results);
$sNo=$row->sNo+1;
$PLm=$row->pL;
$Pam=$row->pa;
$Pbm=$row->pb;
$cdm=$row->denC;
$mdm=$row->denM;
$ydm=$row->denY;
$kdm=$row->denK;
$c50dm=$row->TVIc;
$m50dm=$row->TVIm;
$y50dm=$row->TVIy;
$k50dm=$row->TVIk;
$dk76=$row->dek;
$dc76=$row->decc;
$dm76=$row->dem;
$dy76=$row->dey;
$k50TVI=$row->dek50;
$c50TVI=$row->dec50;
$m50TVI=$row->dem50;
$y50TVI=$row->dey50;
$df=$row->deg;
$gLm=$row->g50L;
$gam=$row->g50a;
$gbm=$row->g50b;
$Fscore=$row->Fscore;
$gdm=$row->gdm;
}
echo "操作員:".$contact." 機型:".$printer." 量測儀器:".$device ." 日期:" .$date. " 檔名:".$tvifile. " ok file:".$okfile;
?><br><br><?php
$sum=100;
$check=1;
echo "Report start: " . "<br />";
// echo "Stored in: " . "upload/" . $_FILES["file"]["name"]. "<br />";
///parsing start
?>
<!--
<table width="200" border="1" align="center">
<tr><td>
<img src=<?php echo 'graph/'.$id.'scatterC.png';?>></td><td>
<img src=<?php echo 'graph/'.$id.'scatterM.png';?>></td><td>
<img src=<?php echo 'graph/'.$id.'scatterY.png';?>></td><td>
<img src=<?php echo 'graph/'.$id.'scatterK.png';?>>
</td></tr>
</table>
<table width="200" border="1" align="center">
<tr><td>
<img src=<?php echo 'graph/'.$id.'graphT.gif';?>></td><td>
<img src=<?php echo 'graph/'.$id.'graph.gif';?>>
</td></tr>
</table>
-->
<p><p>
<?php
//////////////////////////////////////////////////Fogra Media Check
$dgd=$gdm-0.54;
$dgl=58.5-$gLm;
$dga=($Pam/2)-$gam;
$dgb=($Pbm/2)-$gbm;
$df=sqrt(pow($dga,2)+pow($dgb,2));
$dt=50;
$wa=$Pam*(100-$dt)/100;
$wb=$Pbm*(100-$dt)/100;
//$df= pow((pow(($gam-$wa),2))+(pow(($gbm-$wb),2)),0.5)*(1-max(0,($dt-50)/50*0.75));
//$df50=$df;
// echo "df".$df."<br>";
?>
<table width="200" border="1" align="center">
<tr>
<td><div align="center"> id<?php echo $sNo;?></div></td>
<td><font color="#666666">P</td>
<td><font color="#666666">C</td>
<td><font color="#666666">M</td>
<td><font color="#666666">Y</td>
<td><font color="#666666">K</td>
<td>TVI</td>
<td><font color="#666666">C50</td>
<td>M50</td>
<td>Y50</td>
<td>K50</td>
<td>G7</td>
<td>GL</td>
<td>Ga</td>
<td>Gb</td>
<td>df</td>
</tr>
<tr bgcolor="#aaaaaa">
<td><div align="center">色差</div></td>
<td><div align="right"></div></td>
<td bgcolor="#00FFFF"><font color='<?php if ($dc76>5){echo "red";}else {echo "black";}?>'><div align="right"><?php $sum=$sum-$dc76; echo round($dc76,2);?></div></td>
<td bgcolor="#FF99FF"><font color='<?php if ($dm76>5){echo "red";}else {echo "black";}?>'><div align="right"><?php $sum=$sum-$dm76; echo round($dm76,2);?></div></td>
<td bgcolor="#FFFF99"><font color='<?php if ($dy76>5){echo "red";}else {echo "black";}?>'><div align="right"><?php $sum=$sum-$dy76; echo round($dy76,2);?></div></td>
<td bgcolor="#aaaaaa"><font color='<?php if ($dk76>5){echo "red";}else {echo "black";}?>'><div align="right"><?php $sum=$sum-$dk76; echo round($dk76,2);?></div></td>
<td bgcolor="#ffffff">TVI</td>
<td bgcolor="#00FFFF"><font color='<?php if ($c50TVI>4 or $c50TVI<-4){echo "red";}else {echo "black";}?>'><div align="right"><?php $sum=$sum-$c50TVI; echo round($c50TVI,2);?></div></td>
<td bgcolor="#FF99FF"><font color='<?php if ($m50TVI>4 or $m50TVI<-4){echo "red";}else {echo "black";}?>'><div align="right"><?php $sum=$sum-$m50TVI; echo round($m50TVI,2);?></div></td>
<td bgcolor="#FFFF99"><font color='<?php if ($y50TVI>4 or $y50TVI<-4){echo "red";}else {echo "black";}?>'><div align="right"><?php $sum=$sum-$y50TVI; echo round($y50TVI,2);?></div></td>
<td bgcolor="#aaaaaa"><font color='<?php if ($k50TVI>4 or $k50TVI<-4){echo "red";}else {echo "black";}?>'><div align="right"><?php $sum=$sum-$k50TVI; echo round($k50TVI,2);?></div></td>
<td bgcolor="#ffffff">G7</td>
<td><div align="right"><font color='<?php if ($dgl>2.5){echo "red";}else {echo "black";}?>'><a href=" " title="<?php echo round($dgd,2);?>"><?php $sum=$sum-$df*6; $sum=$sum-abs($dgl)*2; echo round($dgl,2);?></a></div></td>
<td><div align="right"><font color='<?php if ($df>2.5){echo "red";}else {echo "black";}?>'><?php echo round($dga,2);?></div></td>
<td><div align="right"><font color='<?php if ($df>2.5){echo "red";}else {echo "black";}?>'><?php echo round($dgb,2);?></div></td>
<td><div align="right"><font color='<?php if ($df>2.5){echo "red";}else {echo "black";}?>'><?php echo round($df,2);?></div></td>
</tr>
<tr>
<td><div align="center">量測濃度</div></td>
<td bgcolor="#CCCCCC"></td>
<td bgcolor="#00FFFF"><div align="right"><font color='<?php if ($dc76>5){echo "red";}else {echo "black";}?>'><?php echo round($cdm,2);?></div></td>
<td bgcolor="#FF99FF"><div align="right"><font color='<?php if ($dm76>5){echo "red";}else {echo "black";}?>'><?php echo round($mdm,2);?></div></td>
<td bgcolor="#FFFF99"><div align="right"><font color='<?php if ($dy76>5){echo "red";}else {echo "black";}?>'><?php echo round($ydm,2);?></div></td>
<td bgcolor="#daffc2"><div align="right"><font color='<?php if ($dk76>5){echo "red";}else {echo "black";}?>'><?php echo round($kdm,2);?></div></td>
<td>TVI濃度</td>
<td bgcolor="#00FFFF"><div align="right"><?php echo round($c50dm,2);?></div></td>
<td bgcolor="#FF99FF"><div align="right"><?php echo round($m50dm,2);?></div></td>
<td bgcolor="#FFFF99"><div align="right"><?php echo round($y50dm,2);?></div></td>
<td bgcolor="#daffc2"><div align="right"><b><?php echo round($k50dm,2);?></div></td>
<td>G7量測</td>
<td bgcolor="#00FFFF"><div align="right"><?php echo round($gLm,2);?></div></td>
<td bgcolor="#FF99FF"><div align="right"><?php echo round($gam,2);?></div></td>
<td bgcolor="#FFFF99"><div align="right"><?php echo round($gbm,2);?></div></td>
<td bgcolor="#cccccc"><div align="right"><font color='<?php if (abs($dgl)>2.5){echo "red";}else {echo "black";}?>'><b><?php echo round($gdm,2);?></div></td>
</tr>
<tr>
<td><div align="center"></div></td>
<td bgcolor="#CCCCCC"></td>
<td bgcolor="#00FFFF"><div align="right"></div></td>
<td bgcolor="#FF99FF"><div align="right"></div></td>
<td bgcolor="#FFFF99"><div align="right"></div></td>
<td bgcolor="#daffc2"><div align="right"></div></td>
<td><?php echo"分數:<br>". round($Fscore,2);?></td>
<td bgcolor="#00FFFF"></td>
<td bgcolor="#FF99FF"></td>
<td bgcolor="#FFFF99"></td>
<td bgcolor="#daffc2"><div align="right"><b>0.5</div></td>
<td>G7目標</td>
<td bgcolor="#00FFFF"><div align="right" ><?php echo "58.5";?></div></td>
<td bgcolor="#FF99FF"><div align="right"><?php echo round($Pam/2,2);?></div></td>
<td bgcolor="#FFFF99"><div align="right"><?php echo round($Pbm/2,2);?></div></td>
<td bgcolor="#cccccc"><div align="right" ><b><?php echo "0.54";?></div></td>
</tr>
</table>
<tr></tr>
<?php
?>
<?php
///////target process
?>
<tr>
<td align="center"><font size="-2"> © <a href="mailto:[email protected]">Fred Kuo</a>, 2016. All rights reserved.<br><a href="http://www.fredkuo.idv.tw/wordpress/?p=1025">Read more.</a><br>
</td>
</tr>
</body>
</html>