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; } } ?>
レーン | 出品番号 | 年式 | 車種名 | グレード | 訂正 | 評価点 | スタート価格 | 入札価格 | 落札価格 | 入札結果 | せり時間 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
レーン | 出品番号 | 年式 | 車種名 | グレード | 訂正 | 評価点 | スタート価格 | せり結果 | 最終応札 | せり時間 | ||||||||||
レーン | 出品番号 | 年式 | 車種名 | グレード | 訂正 | 評価点 | スタート価格 | せり結果 | 落札価格 | |||||||||||
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 ){ ?> | } ?> |