<?
	//5019 / 5020 /2021-
	require_once( "/home/mli/inc/define2.inc" );


	if( $_SERVER["REMOTE_ADDR"] == "172.29.1.111" ){
		$webhost = "113.35.199.238:8080";
	}else{
		$webhost = "10.23.1.121";
	}
	
	if( isset($_REQUEST["posno"]) ){
		$posno=$_REQUEST["posno"];
	}else{
		$posno="00000";
	}
	

	$spImg = "";
	$kekka = 0;
	for( $n=0;$n<30;$n++ ){
		$optImg[$n]="";
	}
	
	
	$start_kakaku=0;
	$last_kakaku=0;
	$seritime="0000";
	$lane="A";
	$kekka=0;
	$teisei="";

	$result="";
	if( isset( $_REQUEST["spno"] ) ){
		
		$sql = sprintf( "SELECT a.*, b.rakusatsu_no, b.kubun, b.last_kakaku, b.syodan_kakaku, b.rakusatsu_kakaku, c.teisei_code, c.teisei_info FROM sp_info a LEFT JOIN seri_result b ON a.sp_link_cd = b.sp_link_cd AND a.kaisai_no = b.kaisai_no AND a.sp_no = b.sp_no LEFT JOIN seri_teisei c ON a.sp_link_cd = c.sp_link_cd AND a.kaisai_no = c.kaisai_no AND a.sp_no = c.sp_no WHERE a.sp_link_cd = %d AND a.kaisai_no = %d AND a.sp_no = '%d' ORDER BY a.sp_no;", $rc_code, $kaisai_no, $_REQUEST["spno"] );
	
		$r = pg_query( $dbconn, $sql );
		if( $r ){
			$num = pg_num_rows( $r );
			
			if( $num>0 ){
				$l=pg_fetch_array( $r );
				if( $l["lene"] == 0 ) $lane = 'A';
				if( $l["lene"] == 1 ) $lane = 'A';
				if( $l["lene"] == 2 ) $lane = 'B';
				if( $l["lene"] == 3 ) $lane = 'C';
				if( $l["lene"] == 4 ) $lane = 'D';
				if( $l["lene"] == 5 ) $lane = 'E';
				if( $l["lene"] == 6 ) $lane = 'F';
				

				$result["server"] = $_SERVER;
				$result["data"] = $l;

				$result["lane"] = $lane;
				$result["start_kakaku"] = $l["start_kakaku"];
				$result["seritime"] = $l["seritime"];
				$result["teisei"] = str_replace( "'", "", $l["teisei_info"] );

				if( $l["kubun"] == "0" ){
					//0 miseri 
					$result["kekka"]=0;
					$result["last_kakaku"]=0;
				}else if( $l["kubun"]=="1" ){
					$kekka=4;
					//4 流札
					$result["kekka"]=4;
					$result["last_kakaku"]=$l["syodan_kakaku"];
				}else if( $l["kubun"]=="2" ){
					if( $l["rakusatsu_no"] == $posno ){
						$result["kekka"]=1;
						//1 自社落札
					}else{
						$result["kekka"]=2;
						//2 他社落札
					}
					$result["last_kakaku"]=$l["rakusatsu_kakaku"];
				}else if( $l["kubun"]=="3" ){
					$result["kekka"]=6;
					$result["last_kakaku"]=$l["syodan_kakaku"];
					//6 商談
				}else if( $l["kubun"]=="4" ){
					if( $l["rakusatsu_no"] == $posno ){
						$result["kekka"]=1;
						//1 自社落札
					}else{
						$result["kekka"]=2;
						//2 他社落札
					}
					$result["last_kakaku"]=$l["rakusatsu_kakaku"];
					$last_kakaku = $l["rakusatsu_kakaku"];
				}
			}
		}
		
		$prefn=sprintf( "%s/%04d.JPG", SPN_FOLDER, $_REQUEST["spno"] );
		if( file_exists( $prefn ) ){
			$result["SP"]=sprintf( "http://%s/image.php?f=SPN&fn=%04d.JPG", $webhost, $_REQUEST["spno"] );
		}
		$prefn=sprintf( "%s/ILA%04d2.JPG", ILA_FOLDER, $_REQUEST["spno"] );
		if( file_exists( $prefn ) ){
			$result["FR"]=sprintf( "http://%s/image.php?f=ILA&fn=ILA%04d2.JPG", $webhost, $_REQUEST["spno"] );
		}
		$prefn=sprintf( "%s/ILA%04d3.JPG", ILA_FOLDER, $_REQUEST["spno"] );
		if( file_exists( $prefn ) ){
			$result["RR"]=sprintf( "http://%s/image.php?f=ILA&fn=ILA%04d3.JPG", $webhost, $_REQUEST["spno"] );
		}
		$preDat=sprintf( "%s/data//%05d.DAT", PRE_FOLDER, $_REQUEST["spno"] );
		if( file_exists( $preDat ) ){
			$index=0;
			$dlist=file_get_contents( $preDat );
			for( $n=0;$n<30;$n++ ){
				//567は除外
				if( $dlist{$n}=="5" ){
					$prefn=sprintf( "%s/PRE/%s/%05d.JPG", PRE_FOLDER, $dlist{$n}, $_REQUEST["spno"] );
					if( file_exists( $prefn ) ){
						$result["P5"]=sprintf( "http://%s/image.php?f=PRE&fn=PRE/%s/%05d.JPG", $webhost, $dlist{$n}, $_REQUEST["spno"] );
					}
				}else if( $dlist{$n}=="6" ){
					$prefn=sprintf( "%s/PRE/%s/%05d.JPG", PRE_FOLDER, $dlist{$n}, $_REQUEST["spno"] );
					if( file_exists( $prefn ) ){
						$result["P6"]=sprintf( "http://%s/image.php?f=PRE&fn=PRE/%s/%05d.JPG", $webhost, $dlist{$n}, $_REQUEST["spno"] );
					}
				}else if( $dlist{$n}=="7" ){
					$prefn=sprintf( "%s/PRE/%s/%05d.JPG", PRE_FOLDER, $dlist{$n}, $_REQUEST["spno"] );
					if( file_exists( $prefn ) ){
						$result["P7"]=sprintf( "http://%s/image.php?f=PRE&fn=PRE/%s/%05d.JPG", $webhost, $dlist{$n}, $_REQUEST["spno"] );
					}
				}else{
					$prefn=sprintf( "%s/PRE/%s/%05d.JPG", PRE_FOLDER, $dlist{$n}, $_REQUEST["spno"] );
					if( file_exists( $prefn ) ){
						$optImg[$index]=sprintf( "http://%s/image.php?f=PRE&fn=PRE/%s/%05d.JPG", $webhost, $dlist{$n}, $_REQUEST["spno"] );
						$index++;
					}
				}
			}
		}
		$result["OPT"] = $optImg;
	}
	echo json_encode( $result );
?>