inc_ViewSuccess.php 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. <?php
  2. $price_sql ="select count(*) cnt
  3. , min(cast(nm_price as decimal)) min_price
  4. , avg(cast(nm_price as decimal)) avg_price
  5. , max(cast(nm_price as decimal)) max_price
  6. , max(case when ds_status = 'Z0' then nm_price else 0 end) tender_price
  7. from tender_master where cd_sale = $cd_sale ";
  8. // echo $price_sql;
  9. $price_col = mysql_fetch_array(mysql_query($price_sql));
  10. ?>
  11. <section class="mt-5 pt30">
  12. <div class="price--info--wrap">
  13. <?php if($ds_status_sale == 'ZS') { ?>
  14. <div>
  15. <div class="thumb ic--01"></div>
  16. <div class="desc">
  17. <h2>완료 금액</h2>
  18. <p><?=number_format($nm_price_final_sale)?><span>만원</span></p>
  19. </div>
  20. </div>
  21. <?php }else { ?>
  22. <div>
  23. <div class="thumb ic--01"></div>
  24. <div class="desc">
  25. <h2>낙찰 금액</h2>
  26. <p><?=number_format($price_col['tender_price'])?><span>만원</span></p>
  27. </div>
  28. </div>
  29. <?php } ?>
  30. <div>
  31. <div class="thumb ic--02"></div>
  32. <div class="desc">
  33. <h2>최고가</h2>
  34. <p><?=number_format($price_col['max_price'])?><span>만원</span></p>
  35. </div>
  36. </div>
  37. <div>
  38. <div class="thumb ic--03"></div>
  39. <div class="desc">
  40. <h2>최고가</h2>
  41. <p><?=number_format($price_col['min_price'])?><span>만원</span></p>
  42. </div>
  43. </div>
  44. <div>
  45. <div class="thumb ic--04"></div>
  46. <div class="desc">
  47. <h2>평균입찰가</h2>
  48. <p><?=number_format($price_col['avg_price'])?><span>만원</span></p>
  49. </div>
  50. </div>
  51. </div>
  52. </section>