//5019 / 5020 /2021-
require_once( "/home/mli/inc/define2.inc" );
$use_fuzai = 1;
$use_shodan = 1;
$imgcount = 0;
$kubun="";
if( isset($_REQUEST["posno"]) ){
$posno=$_REQUEST["posno"];
}else{
$posno="00000";
}
if( $_SERVER["REMOTE_ADDR"] == "172.29.1.111" ){
$webhost = "113.35.199.238";
}else{
$webhost = "10.23.1.121";
}
if(!isset($kaisai_no))$kaisai_no=$_REQUEST["kaisai_no"];
//$rc_code="1";
$spImg = "";
$flImg = "";
$kekka = 0;
for( $n=0;$n<40;$n++ ){
$baseImage[$n]="img/noimage.png";
$optImg[$n]="img/noimage.png";
}
$start_kakaku=0;
$last_kakaku=0;
$seritime="0000";
$lane="A";
$kekka=0;
$teisei="";
$teiseicnt="0";
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"] == 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"]*1;
$seritime = $l["seritime"];
$teisei = $l["teisei_info"];
$teisei = str_replace( "'", "", $teisei );
$teiseicnt = $l["teisei_cnt"];
$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"];
//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"] );
// system( "echo $preDat > /tmp/aaa.log" );
if( file_exists( $preDat ) ){
$index=0;
$dlist=file_get_contents( $preDat );
for( $n=0;$n<34;$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++;
}
}
}
$imgcount = $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"];
}
?>
if( $mode==1 ){ ?>
レーン |
訂正 |
車種名 |
評価点 |
スタート価格 |
出品番号 |
年式 |
グレード |
結果 |
最終応札 |
$back=0;
for( $i=0;$i<$num;$i++ ){
if( $back==0 ) $ret = "落札
";
$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=落札価格をセット それ以外 商談価格
//それ以外のリスト 落札価格
?>
if( $list[$i]["lene"] == 1 ){ ?>
A |
}else if( $list[$i]["lene"] == 2 ){ ?>
B |
}else if( $list[$i]["lene"] == 3 ){ ?>
C |
}else if( $list[$i]["lene"] == 4 ){ ?>
D |
}else{ ?>
A |
} ?>
|
|
|
0 |
|
|
|
|
|
$back^=1;
} ?>
レーン |
訂正 |
車種名 |
評価点 |
スタート価格 |
出品番号 |
年式 |
グレード |
結果 |
最終応札 |
}else{ ?>
} ?>
if( $mode==0 ){ ?>
}else{ ?>
} ?>
|
|
|
|
if( $mode==0 ){
$rptmode=0;
if( isset( $_REQUEST["l"] ) ){
$rptmode=$_REQUEST["l"];
}
?>
if( $rptmode==1 ){ ?>
}else if( $rptmode==2 ){ ?>
}else if( $rptmode==3 ){ ?>
}
}else{ ?>
} ?>
|