<?
	require_once( "/home/mli/inc/define2.inc" );

	
	if( isset( $_REQUEST["posno"] ) ){
		$posno = $_REQUEST["posno"];
	}else{
		$posno = "00000";
	}

	//$kaisai_no=$_REQUEST["kaisai_no"];
	//$rc_code="1";
	$spImg = "";
	$kekka = 0;
	$seritime = "2359";
	$start_kakaku = "0";
	$last_kakaku = "0";
	$lane="-";
	$imgcnt=0;
	for( $n=0;$n<50;$n++ ){
		$baseImage[$n]="img/noimage.png";
		$optImg[$n]="img/noimage.png";
	}
	if( isset( $_REQUEST["spno"] ) ){

		$sql = sprintf( "SELECT a.*, a.teisei_code as spnkesi, b.rakusatsu_no, b.kubun, b.last_kakaku, b.syodan_kakaku, b.rakusatsu_kakaku, c.teisei_cnt, 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"] == 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';
				
				$spten_no = $l["spten_no"];
				$start_kakaku = $l["start_kakaku"];
				$seritime = $l["seritime"];
				$teisei = $l["teisei_info"];
				$teisei = str_replace( "'", "", $teisei );
				$teiseicnt = 0;
				if( $l["teisei_cnt"] > 0 ){
					$teiseicnt = $l["teisei_cnt"];
				}

				//ｿｿｿｿｿｿｿｿｿｿｿ
				if( (int)$spten_no == (int)$posno ){
					$spnkesi=1;
				}else{
					$spnkesi = $l["spnkesi"];
				}
				$kubun = $l["kubun"];
				if( $l["kubun"] == "0" ){
					//0 miseri 
					$kekka=0;
					$last_kakaku = 0;
				}else if( $l["kubun"]=="1" ){
					$kekka=4;
					//4 流札
					$last_kakaku = $l["syodan_kakaku"];
				}else if( $l["kubun"]=="2" ){
					if( $l["rakusatsu_no"] == $posno ){
						$kekka=1;
						//1 自社落札
					}else{
						$kekka=2;
						//2 他社落札
					}
					$last_kakaku = $l["rakusatsu_kakaku"];
				}else if( $l["kubun"]=="3" ){
					$kekka=6;
					//$last_kakaku = $l["syodan_kakaku"];
					$last_kakaku = $l["rakusatsu_kakaku"];
					//6 商談
				}else if( $l["kubun"]=="4" ){
					if( $l["rakusatsu_no"] == $posno ){
						$kekka=1;
						//1 自社落札
					}else{
						$kekka=2;
						//2 他社落札
					}
					$last_kakaku = $l["rakusatsu_kakaku"];
				}
			}
		}
		
		$prefn=sprintf( "%s/%04d.JPG", SPN_FOLDER, $_REQUEST["spno"] );
		if( file_exists( $prefn ) ){
			$baseImage[0]=sprintf( "image.php?f=SPN&fn=%04d.JPG", $_REQUEST["spno"] );
		}
		$prefn=sprintf( "%s/f01%05d.JPG", ILA_FOLDER, $_REQUEST["spno"] );
		if( file_exists( $prefn ) ){
			$baseImage[1]=sprintf( "image.php?f=ILA&fn=f01%05d.JPG", $_REQUEST["spno"] );
		}
		$prefn=sprintf( "%s/r01%05d.JPG", ILA_FOLDER, $_REQUEST["spno"] );
		if( file_exists( $prefn ) ){
			$baseImage[2]=sprintf( "image.php?f=ILA&fn=r01%05d.JPG", $_REQUEST["spno"] );
		}
		$prefn=sprintf( "%s/t01%05d.JPG", ILA_FOLDER, $_REQUEST["spno"] );
		if( file_exists( $prefn ) ){
			$baseImage[5]=sprintf( "image.php?f=ILA&fn=t01%05d.JPG", $_REQUEST["spno"] );
		}
		$prefn=sprintf( "%s/i01%05d.JPG", ILA_FOLDER, $_REQUEST["spno"] );
		if( file_exists( $prefn ) ){
			$baseImage[6]=sprintf( "image.php?f=ILA&fn=i01%05d.JPG", $_REQUEST["spno"] );
		}
		$prefn=sprintf( "%s/i02%05d.JPG", ILA_FOLDER, $_REQUEST["spno"] );
		if( file_exists( $prefn ) ){
			$baseImage[7]=sprintf( "image.php?f=ILA&fn=i02%05d.JPG", $_REQUEST["spno"] );
		}
		$preDat=sprintf( "%s/data//%05d.DAT", PRE_FOLDER, $_REQUEST["spno"] );
		if( file_exists( $preDat ) || true ){
			$index=0;
			$dlist=file_get_contents( $preDat );
			for( $n=0;$n<34;$n++ ){
				//567は除外
				$prefn=sprintf( "/home/fserver1/PRE/%02d/o%02d%05d.JPG", $n, $n, $_REQUEST["spno"] );
				if( file_exists( $prefn ) ){
					$optImg[$index]=sprintf( "image.php?f=PRE2&fn=%02d/o%02d%05d.JPG", $n, $n, $_REQUEST["spno"] );
					$index++;
				}
			}
			$imgcnt=$index;
		}
	}
	
	$result["baseImage"] = $baseImage;
	$result["optImg"] = $optImg;
	$result["imgcnt"] = $imgcnt;
	$result["kubun"] = $kubun;
	$result["kekka"] = $kekka;
	$result["start_kakaku"] = $start_kakaku;
	$result["seritime"] = $seritime;
	$result["last_kakaku"] = $last_kakaku;
	$result["teisei"] = $teisei;
	$result["lane"] = $lane;
	$result["teiseicnt"] = $teiseicnt;
	$result["spnkesi"] = $spnkesi;
	
	echo json_encode( $result );

?>