fail_view.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343
  1. <?php
  2. include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
  3. include $_SERVER['DOCUMENT_ROOT'].'/common/user_chk.php';
  4. $HEADER_LOC = 'main';
  5. $nav_title = "유찰";
  6. $list_url = "fail_list.php";
  7. $s_cd_user = $_SESSION['s_cd_user'];
  8. $cd_sale = $_REQUEST['cd_sale'];
  9. $ds_status_sale = $_REQUEST['ds_status'];
  10. // if($ds_status_contract_sale == "Z0"){
  11. // $mp = "33"; //set top nav
  12. // //거래마감 : "Z0" : "거래마감"
  13. // $STitle = "거래중"; //: 페이지 제목
  14. // $bViewCar = false; //: 차 내용
  15. // $bViewSuccess = true; //: 낙찰 내용
  16. // $bViewTender = false; //: 입찰업체 내용
  17. // $bViewBtn = false; //: 버튼&실행 내용
  18. // $bViewContract = true; //: 계약 내용
  19. // }else if($ds_status_contract_sale == "B0"){
  20. // $mp = "35"; //set top nav
  21. // //거래연기 : "B0" : "거래연기"
  22. // $STitle = "거래연기 리스트"; //: 페이지 제목
  23. // $bViewCar = false; //: 차 내용
  24. // $bViewSuccess = true; //: 낙찰 내용
  25. // $bViewTender = false; //: 입찰업체 내용
  26. // $bViewBtn = false; //: 버튼&실행 내용
  27. // $bViewContract = true; //: 계약 내용
  28. // }else if($ds_status_contract_sale == "C0"){
  29. // $mp = "37"; //set top nav
  30. // //거래실패 : "C0" : "거래실패"
  31. // $STitle = "거래실패 리스트"; //: 페이지 제목
  32. // $bViewCar = false; //: 차 내용
  33. // $bViewSuccess = true; //: 낙찰 내용
  34. // $bViewTender = false; //: 입찰업체 내용
  35. // $bViewBtn = false; //: 버튼&실행 내용
  36. // $bViewContract = true; //: 계약 내용
  37. // }else if($ds_status_contract_step1_sale == "Y"){
  38. // $mp = "33"; //set top nav
  39. // //거래중 : ds_status_contract_step1 == "Y" : "거래중"
  40. // $STitle = "거래중 리스트"; //: 페이지 제목
  41. // $bViewCar = false; //: 차 내용
  42. // $bViewSuccess = true; //: 낙찰 내용
  43. // $bViewTender = false; //: 입찰업체 내용
  44. // $bViewBtn = false; //: 버튼&실행 내용
  45. // $bViewContract = true; //: 계약 내용
  46. // }else{
  47. // $mp = "32"; //set top nav
  48. //
  49. // $STitle = "입찰완료 리스트"; //: 페이지 제목
  50. // $bViewCar = true; //: 차 내용
  51. // $bViewSuccess = true; //: 낙찰 내용
  52. // $bViewTender = true; //: 입찰업체 내용
  53. // $bViewBtn = false; //: 버튼&실행 내용
  54. // $bViewContract = false; //: 계약 내용
  55. // }
  56. //
  57. //견적실수 : "ZE" : "견적실수"
  58. // case "ZE":
  59. $mp = "36"; //set top nav
  60. $STitle = "견적실수 리스트"; //: 페이지 제목
  61. $bViewCar = true; //: 차 내용
  62. $bViewSuccess = true; //: 낙찰 내용
  63. $bViewTender = true; //: 입찰업체 내용
  64. $bViewBtn = false; //: 버튼&실행 내용
  65. $bViewContract = false; //: 계약 내용
  66. //차량 정보는 여기서 가져오도록 수정
  67. $sql ="SELECT
  68. a.*
  69. , b.nm_model
  70. , c.nm_grade
  71. , d.nm_brand
  72. , e.nm_model_sub
  73. , getCode('car_master','ds_type',a.ds_type) as nm_type
  74. , getCode('car_master','ds_year',a.ds_year) as nm_year
  75. , getCode('car_master','ds_open',a.ds_open) as nm_open
  76. , getCode('car_master','ds_sales',a.ds_sales) as nm_sales
  77. , getCode('car_master','ds_transmission',a.ds_transmission) as nm_transmission
  78. , getCode('car_master','ds_oil',a.ds_oil) as nm_oil
  79. , getCode('car_master','ds_accident',a.ds_accident) as nm_accident
  80. , getCode('sale_master','ds_usertype',s.ds_usertype) as nm_usertype
  81. , getCode('member_master','ds_area',s.ds_area) as nm_area
  82. , getCode('member_master','ds_area',s.ds_area_user) as nm_area_user
  83. , getCode('sale_master','ds_status',s.ds_status) as nm_status
  84. , s.nm_name nm_name_sale
  85. , s.ds_status ds_status_sale
  86. , s.ds_status_contract ds_status_contract_sale
  87. , s.nm_contract_fail_reason nm_contract_fail_reason_sale
  88. , s.nm_cont_tender_error nm_cont_tender_error_sale
  89. , s.nm_hp nm_hp_sale
  90. , s.nm_email nm_email_sale
  91. , s.ds_area ds_area_sale
  92. , s.nm_recommend nm_recommend_sale
  93. , s.nm_cont_return nm_cont_return_sale
  94. , s.nm_file_chk1 nm_file_chk1_sale
  95. , s.nm_file_chk2 nm_file_chk2_sale
  96. , s.nm_file_chk3 nm_file_chk3_sale
  97. , s.nm_file_chk4 nm_file_chk4_sale
  98. , s.nm_file_chk5 nm_file_chk5_sale
  99. , s.ds_sale_period ds_sale_period
  100. , s.nm_cont_return nm_cont_return
  101. , s.ds_tradein ds_tradein
  102. , s.ds_buy_method ds_buy_method
  103. , s.ds_auction_time ds_auction_time
  104. , aap.nm_name aap_nm_name
  105. , chm.cd_car_history
  106. FROM sale_master s
  107. inner join car_master a on (s.cd_car = a.cd_car)
  108. left outer join car_history_master chm on chm.cd_car = a.cd_car
  109. left outer join car_model b on (a.cd_model = b.cd_model)
  110. left outer join car_grade c on (a.cd_grade = c.cd_grade)
  111. left outer join car_brand d on (a.cd_brand = d.cd_brand)
  112. left outer join car_model_sub e on (a.cd_model_sub = e.cd_model_sub)
  113. left outer join aap_master aap on (aap.cd_dealer = s.cd_aap_dealer)
  114. WHERE s.cd_sale='$cd_sale'
  115. AND s.cd_user = '$s_cd_user'
  116. AND s.is_staff = 'N'
  117. AND s.ds_delind = 'N'";
  118. // echo $sql;
  119. // exit;
  120. $col=mysql_fetch_array(mysql_query($sql));
  121. if (!empty($col['cd_car'])){
  122. $cd_car = $col['cd_car'];
  123. $cd_model = $col['cd_model'];
  124. $cd_brand = $col['cd_brand'];
  125. $ds_logo = $col['ds_logo'];
  126. $cd_category = $col['cd_category'];
  127. $cd_grade = $col['cd_grade'];
  128. $cd_model_sub = $col['cd_model_sub'];
  129. $ds_cate = $col['ds_cate'];
  130. $ds_type = $col['ds_type'];
  131. $ds_year = $col['ds_year'];
  132. $nm_name = $col['nm_name'];
  133. $nm_price = $col['nm_price'];
  134. $nm_mileage = $col['nm_mileage'];
  135. $ds_driving_system = $col['ds_driving_system'];
  136. $ds_transmission = $col['ds_transmission'];
  137. $nm_file_list = $col['nm_file_list'];
  138. $nm_file_main = $col['nm_file_main'];
  139. $nm_file_report = $col['nm_file_report'];
  140. $nm_file_report_back = $col['nm_file_report_back'];
  141. $nm_file_front = $col['nm_file_front'];
  142. $nm_file_back = $col['nm_file_back'];
  143. $nm_file_side1 = $col['nm_file_side1'];
  144. $nm_file_side2 = $col['nm_file_side2'];
  145. $nm_file_dashboard = $col['nm_file_dashboard'];
  146. $ds_oil = $col['ds_oil'];
  147. $nm_gearbox = $col['nm_gearbox'];
  148. $nm_color = $col['nm_color'];
  149. $nm_incolor = $col['nm_incolor'];
  150. $ds_accident = $col['ds_accident'];
  151. $nm_cont_accident = $col['nm_cont_accident'];
  152. $nm_regdate = $col['nm_regdate'];
  153. $ds_sales = $col['ds_sales'];
  154. $nm_btitle = $col['nm_btitle'];
  155. $nm_stitle = $col['nm_stitle'];
  156. $nm_ltitle = $col['nm_ltitle'];
  157. $nm_cont = $col['nm_cont'];
  158. $nm_cont_pac = $col['nm_cont_pac'];
  159. $nm_cont_detail = $col['nm_cont_detail'];
  160. $nm_desc = $col['nm_desc'];
  161. $nm_guide = $col['nm_guide'];
  162. $ds_open = $col['ds_open'];
  163. $ds_status = $col['ds_status'];
  164. $dt_insert = $col['dt_insert'];
  165. $nm_insert = $col['nm_insert'];
  166. $dt_update = $col['dt_update'];
  167. $nm_update = $col['nm_update'];
  168. $ds_delind = $col['ds_delind'];
  169. $nm_number = $col['nm_number'];
  170. $nm_cc = $col['nm_cc'];
  171. $ds_trade = $col['ds_trade'];
  172. $ds_main = $col['ds_main'];
  173. $nm_regdate_yyyy = $col['nm_regdate_yyyy'];
  174. $nm_regdate_mm = $col['nm_regdate_mm'];
  175. $nm_regdate_dd = $col['nm_regdate_dd'];
  176. $ds_sale_period = $col['ds_sale_period'];
  177. $nm_brand = $col['nm_brand'];
  178. $nm_model = $col['nm_model'];
  179. $nm_model_sub = $col['nm_model_sub'];
  180. $nm_grade = $col['nm_grade'];
  181. $nm_year = $col['nm_year'];
  182. $nm_type = $col['nm_type'];
  183. $nm_open = $col['nm_open'];
  184. $nm_sales = $col['nm_sales'];
  185. $nm_transmission = $col['nm_transmission'];
  186. $nm_oil = $col['nm_oil'];
  187. $nm_usertype = $col['nm_usertype'];
  188. $nm_accident = $col['nm_accident'];
  189. $nm_area = $col['nm_area'];
  190. $nm_name_sale = $col['nm_name_sale'];
  191. $ds_status_sale = $col['ds_status_sale'];
  192. $ds_status_contract_sale = $col['ds_status_contract_sale'];
  193. $nm_contract_fail_reason_sale = $col['nm_contract_fail_reason_sale'];
  194. $nm_cont_tender_error_sale = $col['nm_cont_tender_error_sale'];
  195. $nm_hp_sale = $col['nm_hp_sale'];
  196. $nm_email_sale = $col['nm_email_sale'];
  197. $ds_area_sale = $col['ds_area_sale'];
  198. $nm_area_user = $col['nm_area_user'];
  199. $ds_business_num = $col['ds_business_num'];
  200. $nm_recommend_sale = $col['nm_recommend_sale'];
  201. $nm_cont_return_sale = $col['nm_cont_return_sale'];
  202. $ds_accident_check = $col['ds_accident_check'];
  203. $ds_damage_check = $col['ds_damage_check'];
  204. //보험처리
  205. $nm_act_chgno = $col['nm_act_chgno'];
  206. $nm_act_chgnm = $col['nm_act_chgnm'];
  207. $nm_act_s1 = $col['nm_act_s1'];
  208. $nm_act_s2 = $col['nm_act_s2'];
  209. $nm_act_s3 = $col['nm_act_s3'];
  210. $nm_act_s4 = $col['nm_act_s4'];
  211. $nm_act_my = $col['nm_act_my'];
  212. $nm_act_my_amt = $col['nm_act_my_amt'];
  213. $nm_act_other = $col['nm_act_other'];
  214. $nm_act_other_amt = $col['nm_act_other_amt'];
  215. $nm_act_searchdt = $col['nm_act_searchdt'];
  216. $nm_act_cnt = $col['nm_act_cnt'];
  217. $nm_act_general_spec = $col['nm_act_general_spec'];
  218. $nm_act_use_record = $col['nm_act_use_record'];
  219. $nm_act_use_record_lend = $col['nm_act_use_record_lend'];
  220. $nm_act_use_record_biz = $col['nm_act_use_record_biz'];
  221. $nm_act_use_record_official = $col['nm_act_use_record_official'];
  222. $nm_act_ins_loss = $col['nm_act_ins_loss'];
  223. $nm_act_ins_wet = $col['nm_act_ins_wet'];
  224. $nm_act_ins_robbery = $col['nm_act_ins_robbery'];
  225. $nm_file_act = $col['nm_file_act'];
  226. $nm_act_yn = $col['nm_act_yn'];
  227. $nm_cont_return = $col['nm_cont_return'];
  228. $aap_nm_name = $col['aap_nm_name'];
  229. $cd_car_history = $col['cd_car_history'];
  230. $ds_tradein = $col['ds_tradein'];
  231. $ds_buy_method = $col['ds_buy_method'];
  232. $ds_auction_time = $col['ds_auction_time'];
  233. /*
  234. $arr_nm_info1 = explode("-",$nm_info1);
  235. if(count($arr_nm_info1) == 3){
  236. $nm_info11 = $arr_nm_info1[0];
  237. $nm_info12 = $arr_nm_info1[1];
  238. $nm_info13 = $arr_nm_info1[2];
  239. }else{
  240. $nm_info11 = "";
  241. $nm_info12 = "";
  242. $nm_info13 = "";
  243. }
  244. $arr_nm_info3 = explode("@",$nm_info3);
  245. if(count($arr_nm_info3) == 2){
  246. $nm_info31 = $arr_nm_info3[0];
  247. $nm_info32 = $arr_nm_info3[1];
  248. }else{
  249. $nm_info31 = "";
  250. $nm_info32 = "";
  251. }
  252. $nm_info3 = $col[nm_info3];
  253. */
  254. }else{
  255. AlertBack("지정되지않은 요청입니다");
  256. }
  257. list($nm_hp_sale1, $nm_hp_sale2, $nm_hp_sale3) = explode("-", $nm_hp_sale);
  258. //입찰대기, 입찰중 화면에서는 차량 정보가 수정 가능함
  259. $able_status = array("A0", "B0", "C0", "D0", "E0", "F0", "G0");
  260. $able_modify = false;
  261. if(in_array($ds_status_sale, $able_status)) {
  262. $able_modify = true;
  263. }
  264. ?>
  265. <?php include("../include/inc_header.php") ?>
  266. <main class="pb123">
  267. <section>
  268. <div class="sub--top--visual">
  269. <div class="contents--inner">
  270. <h2><?=$STitle?></h2>
  271. <p>이차조아에서는 사고 이력 조회 후 최고가 내차를 판매할 수 있습니다.</p>
  272. </div>
  273. </div>
  274. </section>
  275. <section>
  276. <div class="top--nav--wrap">
  277. <div class="contents--inner">
  278. <?php
  279. $sale_nav_title = '유찰';
  280. include_once("inc_sale_nav.php");
  281. ?>
  282. </div>
  283. </div>
  284. </section>
  285. <?php
  286. if($bViewCar){
  287. include("./inc_ViewCar.php");
  288. }
  289. if($bViewSuccess){
  290. include("./inc_ViewSuccess.php");
  291. }
  292. if($bViewContract){
  293. include("./inc_ViewContract.php");
  294. }
  295. if($bViewTender){
  296. include("./inc_ViewTender.php");
  297. }
  298. if($bViewBtn){
  299. include("./inc_ViewBtn.php");
  300. }
  301. include("./inc_ViewFail.php");
  302. ?>
  303. </main>
  304. <?php include("inc_Popup.php") ?>
  305. <?php include("../include/inc_footer.php") ?>