complete_view.php 8.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283
  1. <?php
  2. include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
  3. include $_SERVER['DOCUMENT_ROOT'].'/common/aap_chk_m.php';
  4. $HEADER_LOC = 'main';
  5. $nav_title = "낙찰";
  6. $list_url = "complete_list.php";
  7. $s_cd_dealer = $_SESSION['s_cd_dealer'];
  8. $s_cd_dealer_p = $_SESSION['s_cd_dealer_p'];
  9. $s_aap_ds_type = $_SESSION['s_aap_ds_type'];
  10. $s_ds_status_p = $_SESSION['s_ds_status_p'];
  11. $ds_status_proc = 'F0';
  12. $STitle = "낙찰"; //: 페이지 제목
  13. $bViewCar = true; //: 차 내용
  14. $bViewSuccess = true; //: 낙찰 내용
  15. $bViewTender = true; //: 입찰업체 내용
  16. $bViewBtn = true; //: 버튼&실행 내용
  17. $bViewContract = false; //: 계약 내용
  18. //차량 정보는 여기서 가져오도록 수정
  19. $sql ="SELECT
  20. a.*
  21. , b.nm_model
  22. , d.nm_brand
  23. , getCode('car_master','ds_type',a.ds_type) as nm_type
  24. , getCode('car_master','ds_year',a.ds_year) as nm_year
  25. , getCode('car_master','ds_open',a.ds_open) as nm_open
  26. , getCode('car_master','ds_sales',a.ds_sales) as nm_sales
  27. , getCode('car_master','ds_transmission',a.ds_transmission) as nm_transmission
  28. , getCode('car_master','ds_oil',a.ds_oil) as nm_oil
  29. , getCode('car_master','ds_accident',a.ds_accident) as nm_accident
  30. , getCode('sale_master','ds_usertype',s.ds_usertype) as nm_usertype
  31. , getCode('member_master','ds_area',s.ds_area) as nm_area
  32. , getCode('member_master','ds_area',s.ds_area_user) as nm_area_user
  33. , getCode('sale_master','ds_status',s.ds_status) as nm_status
  34. -- , getRemainTime(".LIMIT_TIME_TENDER.", s.dt_approve, now()) as time_limit_tender
  35. , getRemainTime(s.ds_auction_time, s.dt_approve, now()) as time_limit_tender
  36. , s.nm_name nm_name_sale
  37. , s.ds_status ds_status_sale
  38. , s.nm_hp nm_hp_sale
  39. , s.nm_email nm_email_sale
  40. , s.ds_area ds_area_sale
  41. , s.nm_recommend nm_recommend_sale
  42. , s.nm_cont_return nm_cont_return_sale
  43. , s.nm_file_chk1 nm_file_chk1_sale
  44. , s.nm_file_chk2 nm_file_chk2_sale
  45. , s.nm_file_chk3 nm_file_chk3_sale
  46. , s.nm_file_chk4 nm_file_chk4_sale
  47. , s.nm_file_chk5 nm_file_chk5_sale
  48. , s.ds_sale_period ds_sale_period
  49. , s.nm_cont_return nm_cont_return
  50. , aap.nm_name aap_nm_name
  51. , s.ds_tradein ds_tradein
  52. , s.ds_buy_method ds_buy_method
  53. , s.ds_auction_time ds_auction_time
  54. , s.is_staff is_staff
  55. FROM sale_master s
  56. inner join car_master a on (s.cd_car = a.cd_car)
  57. left outer join car_model b on (a.cd_model = b.cd_model)
  58. left outer join car_brand d on (a.cd_brand = d.cd_brand)
  59. left outer join aap_master aap on (aap.cd_dealer = s.cd_aap_dealer)
  60. WHERE s.cd_sale='$cd_sale' ";
  61. // echo $sql;
  62. $col=mysql_fetch_array(mysql_query($sql));
  63. if (!empty($col['cd_car'])){
  64. $cd_car = $col['cd_car'];
  65. $cd_model = $col['cd_model'];
  66. $cd_brand = $col['cd_brand'];
  67. $ds_logo = $col['ds_logo'];
  68. $cd_category = $col['cd_category'];
  69. $cd_grade = $col['cd_grade'];
  70. $ds_cate = $col['ds_cate'];
  71. $ds_type = $col['ds_type'];
  72. $ds_year = $col['ds_year'];
  73. $nm_name = $col['nm_name'];
  74. $nm_price = $col['nm_price'];
  75. $nm_mileage = $col['nm_mileage'];
  76. $ds_driving_system = $col['ds_driving_system'];
  77. $ds_transmission = $col['ds_transmission'];
  78. $nm_file_list = $col['nm_file_list'];
  79. $nm_file_main = $col['nm_file_main'];
  80. $nm_file_report = $col['nm_file_report'];
  81. $nm_file_report_back = $col['nm_file_report_back'];
  82. $nm_file_front = $col['nm_file_front'];
  83. $nm_file_back = $col['nm_file_back'];
  84. $nm_file_side1 = $col['nm_file_side1'];
  85. $nm_file_side2 = $col['nm_file_side2'];
  86. $nm_file_dashboard = $col['nm_file_dashboard'];
  87. $nm_file_engine = $col['nm_file_engine'];
  88. $nm_file_registration = $col['nm_file_registration'];
  89. $ds_oil = $col['ds_oil'];
  90. $nm_gearbox = $col['nm_gearbox'];
  91. $nm_color = $col['nm_color'];
  92. $nm_incolor = $col['nm_incolor'];
  93. $ds_accident = $col['ds_accident'];
  94. $nm_cont_accident = $col['nm_cont_accident'];
  95. $nm_regdate = $col['nm_regdate'];
  96. $ds_sales = $col['ds_sales'];
  97. $nm_btitle = $col['nm_btitle'];
  98. $nm_stitle = $col['nm_stitle'];
  99. $nm_ltitle = $col['nm_ltitle'];
  100. $nm_cont = $col['nm_cont'];
  101. $nm_cont_pac = $col['nm_cont_pac'];
  102. $nm_cont_detail = $col['nm_cont_detail'];
  103. $nm_desc = $col['nm_desc'];
  104. $nm_business_num = $col['nm_business_num'];
  105. $ds_sale_period = $col['ds_sale_period'];
  106. $nm_guide = $col['nm_guide'];
  107. $ds_open = $col['ds_open'];
  108. $ds_status = $col['ds_status'];
  109. $dt_insert = $col['dt_insert'];
  110. $nm_insert = $col['nm_insert'];
  111. $dt_update = $col['dt_update'];
  112. $nm_update = $col['nm_update'];
  113. $ds_delind = $col['ds_delind'];
  114. $nm_number = $col['nm_number'];
  115. $nm_cc = $col['nm_cc'];
  116. $ds_trade = $col['ds_trade'];
  117. $ds_main = $col['ds_main'];
  118. $nm_regdate_yyyy = $col['nm_regdate_yyyy'];
  119. $nm_regdate_mm = $col['nm_regdate_mm'];
  120. $nm_regdate_dd = $col['nm_regdate_dd'];
  121. $nm_brand = $col['nm_brand'];
  122. $nm_model = $col['nm_model'];
  123. $nm_model_sub = $col['nm_model_sub'];
  124. $nm_grade = $col['nm_grade'];
  125. $cd_car_history = $col['cd_car_history'];
  126. $nm_year = $col['nm_year'];
  127. $nm_type = $col['nm_type'];
  128. $nm_open = $col['nm_open'];
  129. $nm_sales = $col['nm_sales'];
  130. $nm_transmission = $col['nm_transmission'];
  131. $nm_oil = $col['nm_oil'];
  132. $nm_usertype = $col['nm_usertype'];
  133. $nm_accident = $col['nm_accident'];
  134. $nm_area = $col['nm_area'];
  135. $nm_name_sale = $col['nm_name_sale'];
  136. $ds_status_sale = $col['ds_status_sale'];
  137. $nm_hp_sale = $col['nm_hp_sale'];
  138. $nm_email_sale = $col['nm_email_sale'];
  139. $ds_area_sale = $col['ds_area_sale'];
  140. $nm_recommend_sale = $col['nm_recommend_sale'];
  141. $nm_cont_return_sale = $col['nm_cont_return_sale'];
  142. $time_limit_tender = $col['time_limit_tender'];
  143. $nm_file_act = $col['nm_file_act'];
  144. $nm_act_yn = $col['nm_act_yn'];
  145. $aap_nm_name = $col['aap_nm_name'];
  146. $nm_branch = $col['nm_branch'];
  147. $is_staff = $col['is_staff'];
  148. $nm_company_bp = $col['nm_company_bp'];
  149. $ds_business_num = $col['ds_business_num'];
  150. $ds_tradein = $col['ds_tradein'];
  151. $ds_buy_method = $col['ds_buy_method'];
  152. $ds_auction_time = $col['ds_auction_time'];
  153. $ds_accident_check = $col['ds_accident_check'];
  154. $ds_damage_check = $col['ds_damage_check'];
  155. /*
  156. $arr_nm_info1 = explode("-",$nm_info1);
  157. if(count($arr_nm_info1) == 3){
  158. $nm_info11 = $arr_nm_info1[0];
  159. $nm_info12 = $arr_nm_info1[1];
  160. $nm_info13 = $arr_nm_info1[2];
  161. }else{
  162. $nm_info11 = "";
  163. $nm_info12 = "";
  164. $nm_info13 = "";
  165. }
  166. $arr_nm_info3 = explode("@",$nm_info3);
  167. if(count($arr_nm_info3) == 2){
  168. $nm_info31 = $arr_nm_info3[0];
  169. $nm_info32 = $arr_nm_info3[1];
  170. }else{
  171. $nm_info31 = "";
  172. $nm_info32 = "";
  173. }
  174. $nm_info3 = $col[nm_info3];
  175. */
  176. }else{
  177. AlertBack("지정되지않은 요청입니다");
  178. }
  179. list($nm_hp_sale1, $nm_hp_sale2, $nm_hp_sale3) = explode("-", $nm_hp_sale);
  180. $aap_sql = "SELECT * FROM aap_master a WHERE cd_dealer = '$s_cd_dealer' LIMIT 1";
  181. $aap_res = mysql_query($aap_sql);
  182. $aap = mysql_fetch_array($aap_res);
  183. // print_r($aap);
  184. // exit;
  185. //부관리자로 로그인시 입찰 정보
  186. $bid_price = "";
  187. if($aap['ds_type'] == 'D1') {
  188. $manager_tender_sql = "SELECT *
  189. FROM tender_master
  190. WHERE ds_delind ='N'
  191. AND cd_sale = '$cd_sale'
  192. AND cd_dealer = '{$_SESSION['s_cd_dealer']}' ";
  193. $manager_tender_col = mysql_fetch_array(mysql_query($manager_tender_sql));
  194. if(!empty($manager_tender_col['nm_price'])) {
  195. $bid_price = $manager_tender_col['nm_price'];
  196. }
  197. }
  198. ?>
  199. <?php include("include/header.php") ?>
  200. <main class="pb123">
  201. <section>
  202. <div class="sub--top--visual">
  203. <div class="contents--inner">
  204. <h2><?=$STitle?></h2>
  205. <p>이차조아에서는 사고 이력 조회 후 최고가 내차를 판매할 수 있습니다.</p>
  206. </div>
  207. </div>
  208. </section>
  209. <section>
  210. <div class="top--nav--wrap">
  211. <div class="contents--inner">
  212. <div class="breadcrumbs--wrap">
  213. <span></span>
  214. <span><?=$STitle?></span>
  215. <span><?=$STitle?></span>
  216. </div>
  217. </div>
  218. </div>
  219. </section>
  220. <?php
  221. if($bViewCar){
  222. include("./inc_ViewCar.php");
  223. }
  224. if($bViewSuccess){
  225. include("./inc_ViewSuccess.php");
  226. }
  227. if($bViewContract){
  228. include("./inc_ViewContract.php");
  229. }
  230. if($bViewTender){
  231. include("./inc_ViewTender.php");
  232. }
  233. if($bViewBtn){
  234. include("./inc_ViewBtn.php");
  235. }
  236. ?>
  237. </main>
  238. <?php
  239. include("./inc_Popup.php");
  240. ?>
  241. <?php include("include/footer.php") ?>