| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455 |
- <?php
- $price_sql ="select count(*) cnt
- , min(cast(nm_price as decimal)) min_price
- , avg(cast(nm_price as decimal)) avg_price
- , max(cast(nm_price as decimal)) max_price
- , max(case when ds_status = 'Z0' then nm_price else 0 end) tender_price
- from tender_master where cd_sale = $cd_sale ";
- // echo $price_sql;
- // exit;
- $price_col = mysql_fetch_array(mysql_query($price_sql));
- ?>
- <!-- 금액 이슈 -->
- <section class="mt-5 pt30">
- <div class="price--info--wrap">
- <?php if($ds_status_sale == 'ZS') { ?>
- <div>
- <div class="thumb ic--01"></div>
- <div class="desc">
- <h2>완료 금액</h2>
- <p><?=number_format($nm_price_final_sale)?><span>만원</span></p>
- </div>
- </div>
- <?php }else { ?>
- <div>
- <div class="thumb ic--01"></div>
- <div class="desc">
- <h2>낙찰 금액</h2>
- <p><?=number_format($price_col['tender_price'])?><span>만원</span></p>
- </div>
- </div>
- <?php } ?>
- <div>
- <div class="thumb ic--02"></div>
- <div class="desc">
- <h2>최고가</h2>
- <p><?=number_format($price_col['max_price'])?><span>만원</span></p>
- </div>
- </div>
- <div>
- <div class="thumb ic--03"></div>
- <div class="desc">
- <h2>최저가</h2>
- <p><?=number_format($price_col['min_price'])?><span>만원</span></p>
- </div>
- </div>
- <div>
- <div class="thumb ic--04"></div>
- <div class="desc">
- <h2>평균입찰가</h2>
- <p><?=number_format($price_col['avg_price'])?><span>만원</span></p>
- </div>
- </div>
- </div>
- </section>
|