require_once( "/home/mli/inc/define2.inc" );
if( isset($_REQUEST["posno"]) ){
$posno=1*$_REQUEST["posno"];
}else{
$posno=0;
}
if( $_REQUEST["l"] == "1" ){
$subj="不 在 入 札 一 覧";
$sql = sprintf( "SELECT a.kaiin_cd, a.price_yen, a.plus_yen, a.goukei_yen, a.charge_tax, a.howto, a.fzflg, b.*, c.rakusatsu_no, c.kubun, c.last_kakaku, c.syodan_kakaku, c.rakusatsu_kakaku FROM fz_log a LEFT JOIN sp_info 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_result 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.kaiin_cd = '%d' ORDER BY a.sp_no;", $rc_code, $kaisai_no, $posno );
}else if( $_REQUEST["l"] == "2" ){
$subj="自 社 出 品 一 覧";
$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.spten_no = '%d' ORDER BY a.sp_no;", $rc_code, $kaisai_no, $posno );
}else if( $_REQUEST["l"] == "3" ){
$subj="落 札 一 覧";
$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 b.rakusatsu_no = '%d' AND b.kubun in ( 2,4 ) ORDER BY a.sp_no;", $rc_code, $kaisai_no, $posno );
}
if( $_REQUEST["l"] == "1" ){
$subj="不 在 入 札 一 覧";
$sql = sprintf( "SELECT a.kaiin_cd, a.price_yen, a.plus_yen, a.goukei_yen, a.charge_tax, a.howto, a.fzflg, b.*, c.rakusatsu_no, c.kubun, c.last_kakaku, c.syodan_kakaku, c.rakusatsu_kakaku FROM fz_log a LEFT JOIN sp_info 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_result 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 ORDER BY a.sp_no;", $rc_code, $kaisai_no );
}else if( $_REQUEST["l"] == "2" ){
$subj="自 社 出 品 一 覧";
$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 ORDER BY a.sp_no;", $rc_code, $kaisai_no );
}else if( $_REQUEST["l"] == "3" ){
$subj="落 札 一 覧";
$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 b.kubun in ( 2,4 ) ORDER BY a.sp_no;", $rc_code, $kaisai_no );
}
$num = 0;
$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;
}
}
?>
function table_header( $mode ){
if( $mode == 1 ){
?>
レーン |
出品番号 |
年式 |
車種名 |
グレード |
訂正 |
評価点 |
スタート価格 |
入札価格 |
落札価格 |
入札結果 |
せり時間 |
}else if( $mode == 2 ){
?>
レーン |
出品番号 |
年式 |
車種名 |
グレード |
訂正 |
評価点 |
スタート価格 |
せり結果 |
最終応札 |
せり時間 |
}else if( $mode == 3 ){
?>
レーン |
出品番号 |
年式 |
車種名 |
グレード |
訂正 |
評価点 |
スタート価格 |
せり結果 |
落札価格 |
}
}
table_header( $_REQUEST["l"] );
$back=0;
for( $i=0;$i<$num;$i++ ){
$className = "list-back" . $back;
$teisei = "";
$carName = trim( str_replace( " ", "", $list[$i]["car_name"] ));
$carName = mb_strimwidth ( trim($carName), 0, 24, "...", "UTF-8" );
$gradeName = trim( str_replace( " ", "", $list[$i]["grade_name"] ));
$gradeName = mb_strimwidth ( trim($gradeName), 0, 24, "...", "UTF-8" );
$seritime = "23:59";
if( preg_match( "/^([0-9][0-9])([0-9][0-9])$/", $list[$i]["seritime"], $rst ) ){
$seritime = $rst[1].":".$rst[2];
}
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"]);
}
?>
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 |
if( $_REQUEST["l"]==1 ){
$price_yen = number_format( $list[$i]["goukei_yen"]);
if( $list[$i]["rakusatsu_no"]*1 <> $posno ){
if( $list[$i]["kubun"] == 2 || $list[$i]["kubun"] == 4 ){
$ret="他社
";
}
}
?>
|
|
|
|
}else if( $_REQUEST["l"]==2 ){ ?>
|
|
|
}else if( $_REQUEST["l"]==3 ){ ?>
|
|
} ?>
$back^=1;
} ?>
table_header( $_REQUEST["l"] ); ?>
検索結果:件