File: C:/xampp/htdocs/PBN/toSCCA6.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>Displayer Check</title>
</head>
<?php
extract($_REQUEST);
session_start();
$L = $_POST["L"];
$a = $_POST["a"];
$b = $_POST["b"];
?>
<body class="oneColElsCtr">
<?php
$sum=260;
$check=1;
$dtime=time();
$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!");
$query = "select id from SCCA6 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))
{
$dStr=$row->id+1;
}
$computername = "FRED-PC";
$ip = gethostbyname($computername);
echo $target."<br />";
if ($target == "Fogra39") {
$contents = file("Fogra39.txt");
$myFile =$dStr."-Fogra39toSCCA.txt";
$o1l=95;$o1a=0;$o1b=-2;}
elseif ($target == "CRPC6") {
$contents = file("CRPC6.txt");
$myFile =$dStr."-CRPC6toSCCA.txt";
$o1l=95;$o1a=1;$o1b=-4;}
elseif ($target == "GRACoL2006") {
$contents = file("GRACoL2006.txt");
$myFile =$dStr."-GRACoLtoSCCA.txt";
$o1l=95;$o1a=0;$o1b=-2;}
$string = implode($contents);
//echo $contents[20];
//echo $string;
$p = ereg_replace("\r\n?", "\n", $string);
$p = str_replace("\n", ' ', $p);
//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 $datastring;
$dot = explode(" ", $datastring);
//echo $dot[1268*8+6]."xx".$dot[1268*8+7];
$P6L=95;
$P6a=1;
$P6b=-4;
$PL=$L;
$Pa=$a;
$Pb=$b;
include 'lab2xyz.php';
include 'SCCA06.php';
include 'xyz2lab.php';
$Xp=lab2xyz("x",$PL,$Pa,$Pb);
$Yp=lab2xyz("y",$PL,$Pa,$Pb);
$Zp=lab2xyz("z",$PL,$Pa,$Pb);
//$icclab="upload/".$filename."T.ti1";
$fh = fopen($myFile, 'w') or die("can't open file");
//fwrite($fh, $p);
$viHead='ORIGINATOR "CGATS"
FILE_DESCRIPTOR "CGATS21-2"
# Characterized Reference Printing Condition 6, Universal Premium Coated
CREATED "December, 2012"
MEASUREMENT_GEOMETRY "ISO 13655 - Reflection, M1, white backing"
FILTER "D50"
# Reference White Point (LAB) = '. $PL . " " .$Pa. " ".$Pb.'
# Reference Black Point (LAB) = 9.05 0.20 0.39
NUMBER_OF_FIELDS 8
BEGIN_DATA_FORMAT
SAMPLE_ID CMYK_C CMYK_M CMYK_Y CMYK_K LAB_L LAB_A LAB_B
END_DATA_FORMAT
NUMBER_OF_SETS 1617
BEGIN_DATA
';
fwrite($fh, $viHead);
$data1="1 0 0 0 0 ".$PL." ".$Pa." ".$Pb."
";
fwrite($fh, $data1);
for ( $i = 0; $i <= 1615; $i+= 1) {
$line=$i+2 ." ";
fwrite($fh, $line);
// echo $dot[0]."x_";
$DataC = $dot[$line*8+1]." ";
$DataM = $dot[$line*8+2]." ";
$DataY = $dot[$line*8+3]." ";
$DataK = $dot[$line*8+4]." ";
$DataL = $dot[$line*8+5]." ";
$Dataa = $dot[$line*8+6]." ";
$Datab = $dot[$line*8+7]." ";
$X=lab2xyz("x",$DataL,$Dataa,$Datab);
$Y=lab2xyz("y",$DataL,$Dataa,$Datab);
$Z=lab2xyz("z",$DataL,$Dataa,$Datab);
$scX=SCCA06("x",$X,$Xp,$target);
$scY=SCCA06("y",$Y,$Yp,$target);
$scZ=SCCA06("z",$Z,$Zp,$target);
$scL=round(xyz2lab("l",$scX,$scY,$scZ),2)." ";
$sca=round(xyz2lab("a",$scX,$scY,$scZ),2)." ";
$scb=round(xyz2lab("b",$scX,$scY,$scZ),2);
// if ($i == 1266) {echo "..".$sca."zz".$scb;}
//if ($i == 0) {$o1l=$DataL;$o1a=$Dataa;$o1b=$Datab;$PL=$scL;$Pa=$sca;$Pb=$scb;}
if ($i == 71) {$o73l=$DataL;$o73a=$Dataa;$o73b=$Datab;$P73L=$scL;$P73a=$sca;$P73b=$scb;}
if ($i == 7) {$o9l=$DataL;$o9a=$Dataa;$o9b=$Datab;$P9L=$scL;$P9a=$sca;$P9b=$scb;}
if ($i == 647) {$o649l=$DataL;$o649a=$Dataa;$o649b=$Datab;$P649L=$scL;$P649a=$sca;$P649b=$scb;}
if ($i == 1258) {$o1260l=$DataL;$o1260a=$Dataa;$o1260b=$Datab;$P1260L=$scL;$P1260a=$sca;$P1260b=$scb;}
if ($i == 1294) {$o1296l=$DataL;$o1296a=$Dataa;$o1296b=$Datab;$P1296L=$scL;$P1296a=$sca;$P1296b=$scb;}
if ($i == 1314) {$o1316l=$DataL;$o1316a=$Dataa;$o1316b=$Datab;$P1316L=$scL;$P1316a=$sca;$P1316b=$scb;}
if ($i == 1334) {$o1336l=$DataL;$o1336a=$Dataa;$o1336b=$Datab;$P1336L=$scL;$P1336a=$sca;$P1336b=$scb;}
if ($i == 1354) {$o1356l=$DataL;$o1356a=$Dataa;$o1356b=$Datab;$P1356L=$scL;$P1356a=$sca;$P1356b=$scb;}
if ($i == 1609) {$o1611l=$DataL;$o1611a=$Dataa;$o1611b=$Datab;$P1611L=$scL;$P1611a=$sca;$P1611b=$scb;}
$stringData = $DataC.$DataM.$DataY.$DataK.$scL.$sca.$scb;
fwrite($fh, $stringData);
fwrite($fh, "
");
}
$viTail='END_DATA';
fwrite($fh, $viTail);
fclose($fh);
$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 SCCA6(company, contact, device) VALUES('$contact', '$contact', '$device')";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
mysql_close($connection);
?>
<table width="400" border="1" align="center">
<tr>
<td>
<td colspan = "3">Original data</td>
<td colspan = "3">SCCA data</td>
</tr>
<tr>
<td>Paper</td>
<td align='right'><?php echo round($o1l,1);?></td>
<td align='right'><?php echo round($o1a,1);?></td>
<td align='right'><?php echo round($o1b,1);?></td>
<td align='right'><?php echo round($PL,1);?></td>
<td align='right'><?php echo round($Pa,1);?></td>
<td align='right'><?php echo round($Pb,1);?></td>
</tr>
<tr>
<td bgcolor="#00FFFF">100C</td>
<td align='right' bgcolor="#00FFFF"><?php echo round($o73l,1);?></td>
<td align='right' bgcolor="#00FFFF"><?php echo round($o73a,1);?></td>
<td align='right' bgcolor="#00FFFF"><?php echo round($o73b,1);?></td>
<td align='right' bgcolor="#00FFFF"><?php echo round($P73L,1);?></td>
<td align='right' bgcolor="#00FFFF"><?php echo round($P73a,1);?></td>
<td align='right' bgcolor="#00FFFF"><?php echo round($P73b,1);?></td>
</tr>
<tr>
<td bgcolor="#FFCCFF">100M</td>
<td align='right' bgcolor="#FFCCFF"><?php echo round($o9l,1);?></td>
<td align='right' bgcolor="#FFCCFF"><?php echo round($o9a,1);?></td>
<td align='right' bgcolor="#FFCCFF"><?php echo round($o9b,1);?></td>
<td align='right' bgcolor="#FFCCFF"><?php echo round($P9L,1);?></td>
<td align='right' bgcolor="#FFCCFF"><?php echo round($P9a,1);?></td>
<td align='right' bgcolor="#FFCCFF"><?php echo round($P9b,1);?></td>
</tr>
<td bgcolor="#FFFF66">100Y</td>
<td align='right' bgcolor="#FFFF66"><?php echo round($o649l,1);?></td>
<td align='right' bgcolor="#FFFF66"><?php echo round($o649a,1);?></td>
<td align='right' bgcolor="#FFFF66"><?php echo round($o649b,1);?></td>
<td align='right' bgcolor="#FFFF66"><?php echo round($P649L,1);?></td>
<td align='right' bgcolor="#FFFF66"><?php echo round($P649a,1);?></td>
<td align='right' bgcolor="#FFFF66"><?php echo round($P649b,1);?></td>
</tr>
<td bgcolor="#BBBBBB">100K</td>
<td align='right' bgcolor="#BBBBBB"><?php echo round($o1260l,1);?></td>
<td align='right' bgcolor="#BBBBBB"><?php echo round($o1260a,1);?></td>
<td align='right' bgcolor="#BBBBBB"><?php echo round($o1260b,1);?></td>
<td align='right' bgcolor="#BBBBBB"><?php echo round($P1260L,1);?></td>
<td align='right' bgcolor="#BBBBBB"><?php echo round($P1260a,1);?></td>
<td align='right' bgcolor="#BBBBBB"><?php echo round($P1260b,1);?></td>
</tr>
<td bgcolor="#CCFFFF">50C</td>
<td align='right' bgcolor="#CCFFFF"><?php echo round($o1296l,1);?></td>
<td align='right' bgcolor="#CCFFFF"><?php echo round($o1296a,1);?></td>
<td align='right' bgcolor="#CCFFFF"><?php echo round($o1296b,1);?></td>
<td align='right' bgcolor="#CCFFFF"><?php echo round($P1296L,1);?></td>
<td align='right' bgcolor="#CCFFFF"><?php echo round($P1296a,1);?></td>
<td align='right' bgcolor="#CCFFFF"><?php echo round($P1296b,1);?></td>
</tr>
<td bgcolor="#FFDDFF">50M</td>
<td align='right' bgcolor="#FFDDFF"><?php echo round($o1316l,1);?></td>
<td align='right' bgcolor="#FFDDFF"><?php echo round($o1316a,1);?></td>
<td align='right' bgcolor="#FFDDFF"><?php echo round($o1316b,1);?></td>
<td align='right' bgcolor="#FFDDFF"><?php echo round($P1316L,1);?></td>
<td align='right' bgcolor="#FFDDFF"><?php echo round($P1316a,1);?></td>
<td align='right' bgcolor="#FFDDFF"><?php echo round($P1316b,1);?></td>
</tr>
<td bgcolor="#FFFFCC">50Y</td>
<td align='right' bgcolor="#FFFFCC"><?php echo round($o1336l,1);?></td>
<td align='right' bgcolor="#FFFFCC"><?php echo round($o1336a,1);?></td>
<td align='right' bgcolor="#FFFFCC"><?php echo round($o1336b,1);?></td>
<td align='right' bgcolor="#FFFFCC"><?php echo round($P1336L,1);?></td>
<td align='right' bgcolor="#FFFFCC"><?php echo round($P1336a,1);?></td>
<td align='right' bgcolor="#FFFFCC"><?php echo round($P1336b,1);?></td>
</tr>
<td bgcolor="#DDDDDD">50K</td>
<td align='right' bgcolor="#DDDDDD"><?php echo round($o1356l,1);?></td>
<td align='right' bgcolor="#DDDDDD"><?php echo round($o1356a,1);?></td>
<td align='right' bgcolor="#DDDDDD"><?php echo round($o1356b,1);?></td>
<td align='right' bgcolor="#DDDDDD"><?php echo round($P1356L,1);?></td>
<td align='right' bgcolor="#DDDDDD"><?php echo round($P1356a,1);?></td>
<td align='right' bgcolor="#DDDDDD"><?php echo round($P1356b,1);?></td>
</tr>
<td bgcolor="#DDDCCF">504040</td>
<td align='right' bgcolor="#DDDCCF"><?php echo round($o1611l,1);?></td>
<td align='right' bgcolor="#DDDCCF"><?php echo round($o1611a,1);?></td>
<td align='right' bgcolor="#DDDCCF"><?php echo round($o1611b,1);?></td>
<td align='right' bgcolor="#DDDCCF"><?php echo round($P1611L,1);?></td>
<td align='right' bgcolor="#DDDCCF"><?php echo round($P1611a,1);?></td>
<td align='right' bgcolor="#DDDCCF"><?php echo round($P1611b,1);?></td>
</tr>
</table>
<?php
if ($target == "Fogra39") { ?>
<SCRIPT LANGUAGE="JavaScript">
<!-- http://www.culturemark.com/redirectURL/
var spge = '<?php echo json_encode($dStr) ;?>';
window.location="remoteEXF.php?id=".concat(spge);
// -->
</script>
<?php }
elseif ($target == "CRPC6") { ?>
<SCRIPT LANGUAGE="JavaScript">
<!-- http://www.culturemark.com/redirectURL/
var spge = '<?php echo json_encode($dStr) ;?>';
window.location="remoteEX.php?id=".concat(spge);
// -->
</script>
<?php }
elseif ($target == "GRACoL2006") { ?>
<SCRIPT LANGUAGE="JavaScript">
<!-- http://www.culturemark.com/redirectURL/
var spge = '<?php echo json_encode($dStr) ;?>';
window.location="remoteEXG.php?id=".concat(spge);
// -->
</script>
<?php }
?>
</table>
<tr>
<br />
<td align="center"><font size="-2"> © <a href="mailto:[email protected]">Fred Kuo</a>, 2015. All rights reserved.<br><a href="http://www.fredkuo.idv.tw/wordpress/?p=1025">Read more.</a><br>
</td>
</tr>
</body>
</html>