inc_ViewSuccess.php 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
  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. // exit;
  10. $price_col = mysql_fetch_array(mysql_query($price_sql));
  11. ?>
  12. <!-- 금액 이슈 -->
  13. <section class="mt-5 pt30">
  14. <div class="price--info--wrap">
  15. <?php if($ds_status_sale == 'ZS') { ?>
  16. <div>
  17. <div class="thumb ic--01"></div>
  18. <div class="desc">
  19. <h2>완료 금액</h2>
  20. <p><?=number_format($nm_price_final_sale)?><span>만원</span></p>
  21. </div>
  22. </div>
  23. <?php }else { ?>
  24. <div>
  25. <div class="thumb ic--01"></div>
  26. <div class="desc">
  27. <h2>낙찰 금액</h2>
  28. <p><?=number_format($price_col['tender_price'])?><span>만원</span></p>
  29. </div>
  30. </div>
  31. <?php } ?>
  32. <div>
  33. <div class="thumb ic--02"></div>
  34. <div class="desc">
  35. <h2>최고가</h2>
  36. <p><?=number_format($price_col['max_price'])?><span>만원</span></p>
  37. </div>
  38. </div>
  39. <div>
  40. <div class="thumb ic--03"></div>
  41. <div class="desc">
  42. <h2>최저가</h2>
  43. <p><?=number_format($price_col['min_price'])?><span>만원</span></p>
  44. </div>
  45. </div>
  46. <div>
  47. <div class="thumb ic--04"></div>
  48. <div class="desc">
  49. <h2>평균입찰가</h2>
  50. <p><?=number_format($price_col['avg_price'])?><span>만원</span></p>
  51. </div>
  52. </div>
  53. </div>
  54. </section>