require_once( "/home/mli/inc/define2.inc" );
session_start();
if( isset($_REQUEST["posno"]) ){
$posno=1*$_REQUEST["posno"];
}else{
$posno=0;
}
if( isset($_REQUEST["edano"]) ){
$edano=$_REQUEST["edano"];
}else{
$edano=0;
}
if( isset($_GET["FUZAI"]) ){
$_SESSION["FUZAI"] = $_GET["FUZAI"];
}
if( isset($_GET["SHODAN"]) ){
$_SESSION["SHODAN"] = $_GET["SHODAN"];
}
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 TO_NUMBER( a.kaiin_cd, '99999999') = '%d' ORDER BY TO_NUMBER( b.sp_no, '99999' );", $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 TO_NUMBER( a.spten_no, '99999999' ) = '%d' ORDER BY TO_NUMBER( a.sp_no, '99999' );", $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 TO_NUMBER( b.rakusatsu_no, '99999999' ) = '%d' AND b.kubun in ( 2,4 ) ORDER BY TO_NUMBER( a.sp_no, '99999' );", $rc_code, $kaisai_no, $posno );
}else if( $_REQUEST["l"] == "4" ){
$subj="商 談 一 覧";
$sql = sprintf( "SELECT * FROM shodan_list WHERE kaisai_no = %d AND TO_NUMBER( posno, '99999999' ) = %d ORDER BY TO_NUMBER( sp_no, '99999' ) , uketsuke_time DESC;", $kaisai_no, $posno );
}
$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 ){
?>
レーン |
出品番号 |
年式 |
車種名 |
グレード |
訂正 |
評価点 |
スタート価格 |
せり結果 |
落札価格 |
}else if( $mode == 4 ){
?>
レーン |
出品番号 |
年式 |
車種名 |
グレード |
商談スタート価格 |
申込価格 |
申込時間 |
商談結果 |
}
}
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"]);
$last = "";
}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"] == "5" ){
$ret="キャンセル
";
$last = number_format( $list[$i]["last_kakaku"]);
}else{
//$ret="";
$ret="".$list[$i]["kubun"]."
";
$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 |
} ?>
0000 |
年 |
|
|
if( $_REQUEST["l"]==4 ){
$shodanStart = number_format( $list[$i]["shodan_start"] * 1000);
$shodanPrice = number_format( $list[$i]["shodan_price"] * 1000);
$ukeTime = Date( "H:i", strtotime( $list[$i]["uketsuke_time"] ));
if( $list[$i]["shodan_kekka"]=="0"
|| $list[$i]["shodan_kekka"]=="1"){
if( $list[$i]["shodan_result"] == "00" ){
if( $list[$i]["kubun"] == "4" ){
if( $list[$i]["rakusatsu_no"] == $posno ){
$ret="商落
";
}else{
$ret="他社落
";
}
}else if( $list[$i]["kubun"] == "2" ){
if( $list[$i]["rakusatsu_no"] == $posno ){
$ret="商落
";
}else{
$ret="他社落
";
}
}else{
if( $list[$i]["shodan_kekka"]=="1" ){
$ret="商成立
";
}else{
$ret="受付済
";
}
}
}else{
$ret="エラー
";
}
}else if( $list[$i]["shodan_kekka"]=="3"){
if( $list[$i]["kubun"] == "4" ){
if( $list[$i]["rakusatsu_no"] == $posno ){
$ret="商落
";
}else{
$ret="他社落
";
}
}else{
$ret="商談中
";
}
}else if( $list[$i]["shodan_kekka"]=="8"){
$ret="他社落
";
}else if( $list[$i]["shodan_kekka"]=="9"){
$ret="商取消
";
}
?>
|
|
|
|
}else{ ?>
|
|
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"] ); ?>
検索結果:件