<?
/* date_default_timezone_set('Asia/Bangkok');
$date = date('Y-m-d H:i:s'); */
ini_set('max_execution_time', 300);
if ($_SERVER['REQUEST_METHOD'] === 'POST')
    $barcode = $_POST['barcode'];
else
	$barcode = $_GET['barcode'];
if(strlen(trim($barcode))!=13)
	exit;
	$fp = fopen('data.txt', 'w');
	fwrite($fp,$barcode);
	fclose($fp);
include("connect.php");
mysqli_query($mysqli,"SET character_set_results=utf8");
mysqli_query($mysqli,"SET character_set_client=utf8");
mysqli_query($mysqli,"SET character_set_connection=utf8");
$alldata = "";
$BigC = str_repeat(' ',7)."0.00";
$Lotus = str_repeat(' ',7)."0.00";
$Tops = str_repeat(' ',7)."0.00";
$Others = str_repeat(' ',7)."0.00";
$productname = str_repeat(".",300);
$result = $mysqli->query("SELECT * FROM allstores WHERE barcode = '$barcode' ORDER BY productname");
$num_rows = mysqli_num_rows($result);
if($num_rows>0)
{
	while($row=mysqli_fetch_array($result))
	{
		if(strlen(trim($row[1]))<strlen(trim($productname)))
			$productname = $row[1];
		$price = $row[2];
		$store = $row[6];
		if(trim($store)=="BigC")
		{
			$data = number_format($price,2);
			$data = (string) $price;
			$dlen = strlen($data);
			$data = str_repeat(" ",11-$dlen).$data;
			$BigC = $data;
		}
		if(trim($store)=="Lotus")
		{
			$data = number_format($price,2);
			$data = (string) $price;
			$dlen = strlen($data);
			$data = str_repeat(" ",11-$dlen).$data;
			$Lotus = $data;
		}
		if(trim($store)=="Tops")
		{
			$data = number_format($price,2);
			$data = (string) $price;
			$dlen = strlen($data);
			$data = str_repeat(" ",11-$dlen).$data;
			$Tops = $data;
		}
		if(strpos(trim($store),".BigCLotusTops")==0)
		{
			$data = number_format($price,2);
			$data = (string) $price;
			$dlen = strlen($data);
			$data = str_repeat(" ",11-$dlen).$data;
			$Other = $data;
		}
	}
	$alldata = $BigC.$Lotus.$Tops.$Other;
	echo $productname."\n".$alldata;
	$fp = fopen('data1.txt', 'w');
	fwrite($fp,$productname."\n".$alldata);
	fclose($fp);
}
else
{
	$sql = $mysqli->query("SELECT * FROM notfound WHERE barcode = '$barcode'");
	$num_rows = mysqli_num_rows($sql);
	if($num_rows==0)
	{
		$sql = "INSERT INTO notfound (barcode,ctime) VALUES ('$barcode','$date')";
		if (!mysqli_query($mysqli, $sql))
				echo "";
	}
}
?>