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'; $start_kakaku = $l["start_kakaku"]; $seritime = $l["seritime"]; $teisei = $l["teisei_info"]; $teisei = str_replace( "'", "", $teisei ); 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"]; //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/ILA%04d2.JPG", ILA_FOLDER, $_REQUEST["spno"] ); if( file_exists( $prefn ) ){ $baseImage[1]=sprintf( "image.php?f=ILA&fn=ILA%04d2.JPG", $_REQUEST["spno"] ); } $prefn=sprintf( "%s/ILA%04d3.JPG", ILA_FOLDER, $_REQUEST["spno"] ); if( file_exists( $prefn ) ){ $baseImage[2]=sprintf( "image.php?f=ILA&fn=ILA%04d3.JPG", $_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 ) ){ $baseImage[5]=sprintf( "image.php?f=PRE&fn=PRE/%s/%05d.JPG", $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 ) ){ $baseImage[6]=sprintf( "image.php?f=PRE&fn=PRE/%s/%05d.JPG", $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 ) ){ $baseImage[7]=sprintf( "image.php?f=PRE&fn=PRE/%s/%05d.JPG", $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( "image.php?f=PRE&fn=PRE/%s/%05d.JPG", $dlist{$n}, $_REQUEST["spno"] ); $index++; } } } } } if( isset( $_REQUEST["carname_code"] ) ){ $mode=1; $spno=0; $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.car_code = '%d' ORDER BY a.sp_no;", $rc_code, $kaisai_no, $_REQUEST["carname_code"] ); $r = pg_query( $dbconn, $sql ); if( $r ){ $num = pg_num_rows( $r ); for( $i=0;$i<$num;$i++ ){ $l=pg_fetch_array( $r ); $list[$i] = $l; if( $spno==0 ) $spno = $l["sp_no"]; } } }else{ $mode=0; $spno=$_REQUEST["spno"]; } ?>
落札"; $className = "list-back" . $back; if( $i==0 ) $className = "list-back2"; $carName = trim( str_replace( " ", "", $list[$i]["car_name"] )); $carName = mb_strimwidth ( $carName, 0, 16, "...", "UTF-8" ); $gradeName = trim( str_replace( " ", "", $list[$i]["grade_name"] )); $gradeName = mb_strimwidth ( $gradeName, 0, 16, "...", "UTF-8" ); $teisei = ""; if( $list[$i]["teisei_code"] > 0 ){ $teisei = "有"; } if( $list[$i]["kubun"] == "0" ){ $ret="
未せり
"; $last = number_format( $list[$i]["last_kakaku"]); }else if( $list[$i]["kubun"] == "1" ){ $ret="
流れ
"; $last = number_format( $list[$i]["last_kakaku"]); }else if( $list[$i]["kubun"] == "2" ){ $ret="
落札
"; $last = number_format( $list[$i]["last_kakaku"]); }else if( $list[$i]["kubun"] == "3" ){ $ret="
商中
"; $last = number_format( $list[$i]["last_kakaku"]); }else if( $list[$i]["kubun"] == "4" ){ $ret="
商落
"; $last = number_format( $list[$i]["last_kakaku"]); }else if( $list[$i]["kubun"] == "4" ){ $ret="
キャンセル
"; $last = number_format( $list[$i]["last_kakaku"]); }else{ $ret=""; $last = number_format( $list[$i]["last_kakaku"]); } //出品店の場合 落札NULL=0 2,3=落札価格をセット それ以外 最終価格 //下見検索中 落札NULL=0 2,3=落札価格をセット それ以外 商談価格 //それ以外のリスト 落札価格 ?>
レーン 訂正 車種名 評価点 スタート価格
出品番号 年式 グレード 結果 最終応札
A B C D A 0
レーン 訂正 車種名 評価点 スタート価格
出品番号 年式 グレード 結果 最終応札
検索結果: 件