dealer_tender_view.php 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770
  1. <?php
  2. include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
  3. include $_SERVER['DOCUMENT_ROOT'].'/common/dealer_chk.php';
  4. ?>
  5. <? include("../include/inc_top.php") ?>
  6. <? include("../include/inc_header.php") ?>
  7. <section id="wrap">
  8. <section id="visual" class="visual_mypage">
  9. <h2>마이페이지</h2>
  10. <p>쉽고 간편한 내차팔기, 견적산출, 최종 매각까지 어떤 수수료도 요구하지 않습니다.</p>
  11. </section>
  12. <section id="content">
  13. <ul class="location">
  14. <li><a href="/" class="home">홈</a></li>
  15. <li><span class="depth1">마이페이지</span>
  16. <ul class="sub_depth">
  17. <li><a href="#">마이페이지</a></li>
  18. <li><a href="#">입찰정보</a></li>
  19. <li><a href="#">차량정보</a></li>
  20. <li><a href="#">문의내역</a></li>
  21. </ul>
  22. </li>
  23. <li><span class="depth2">딜러</span></li>
  24. </ul>
  25. <? include("./inc_menu_dealer.php") ?>
  26. <?
  27. $s_cd_dealer = $_SESSION['s_cd_dealer'];
  28. $s_cd_dealer_p = $_SESSION['s_cd_dealer_p'];
  29. $s_ds_type = $_SESSION['s_ds_type'];
  30. $s_ds_status_p = $_SESSION['s_ds_status_p'];
  31. if($s_ds_type == "D0"){ //딜러
  32. $sql_ds_type = " cd_dealer_p = '$s_cd_dealer' ";
  33. }else{ //딜러-관리자
  34. $sql_ds_type = " cd_dealer = '$s_cd_dealer' ";
  35. }
  36. $rq_ds_status = $_REQUEST['ds_status']; //요청받은 상태값 : request ds_status (naming request->rq, response->rs)
  37. if($rq_ds_status == "E0"){
  38. $nm_title = "입찰대기 상세";
  39. }else if($rq_ds_status == "F0"){
  40. $nm_title = "입찰중 상세";
  41. }else if($rq_ds_status == "Z0"){
  42. $nm_title = "낙찰 상세";
  43. }else if($rq_ds_status == "ZE"){
  44. $nm_title = "유찰 상세";
  45. }else if($rq_ds_status == "ZS"){
  46. $nm_title = "구매확정 상세";
  47. }
  48. $cd_sale = $_REQUEST["cd_sale"];
  49. $sql ="SELECT
  50. a.*
  51. , b.nm_model
  52. , c.nm_grade
  53. , d.nm_brand
  54. , e.nm_model_sub
  55. , getCode('car_master','ds_type',a.ds_type) as nm_type
  56. , getCode('car_master','ds_year',a.ds_year) as nm_year
  57. , getCode('car_master','ds_open',a.ds_open) as nm_open
  58. , getCode('car_master','ds_sales',a.ds_sales) as nm_sales
  59. , getCode('car_master','ds_transmission',a.ds_transmission) as nm_transmission
  60. , getCode('car_master','ds_oil',a.ds_oil) as nm_oil
  61. , getCode('car_master','ds_accident',a.ds_accident) as nm_accident
  62. , getCode('sale_master','ds_usertype',s.ds_usertype) as nm_usertype
  63. , getCode('member_master','ds_area',s.ds_area) as nm_area
  64. , getCode('member_master','ds_area',s.ds_area_user) as nm_area_user
  65. , getCode('sale_master','ds_status',s.ds_status) as nm_status
  66. , s.nm_name nm_name_sale
  67. , s.ds_status ds_status_sale
  68. , s.nm_hp nm_hp_sale
  69. , s.nm_email nm_email_sale
  70. , s.ds_area ds_area_sale
  71. , s.nm_recommend nm_recommend_sale
  72. , s.nm_cont_return nm_cont_return_sale
  73. , getRemainTime(".LIMIT_TIME_TENDER.", s.dt_approve, now()) as time_limit_tender
  74. FROM sale_master s
  75. inner join car_master a
  76. on (s.cd_car = a.cd_car)
  77. left outer join car_model b
  78. on (a.cd_model = b.cd_model)
  79. left outer join car_grade c
  80. on (a.cd_grade = c.cd_grade)
  81. left outer join car_brand d
  82. on (a.cd_brand = d.cd_brand)
  83. left outer join car_model_sub e
  84. on (a.cd_model_sub = e.cd_model_sub)
  85. WHERE s.cd_sale='$cd_sale' ";
  86. $col=mysql_fetch_array(mysql_query($sql));
  87. if (!empty($col[cd_car])){
  88. $cd_car = $col[cd_car];
  89. $cd_model = $col[cd_model];
  90. $cd_brand = $col[cd_brand];
  91. $ds_logo = $col[ds_logo];
  92. $cd_category = $col[cd_category];
  93. $cd_grade = $col[cd_grade];
  94. $ds_cate = $col[ds_cate];
  95. $ds_type = $col[ds_type];
  96. $ds_year = $col[ds_year];
  97. $nm_name = $col[nm_name];
  98. $nm_price = $col[nm_price];
  99. $nm_mileage = $col[nm_mileage];
  100. $ds_driving_system = $col[ds_driving_system];
  101. $ds_transmission = $col[ds_transmission];
  102. $nm_file_list = $col[nm_file_list];
  103. $nm_file_main = $col[nm_file_main];
  104. $nm_file_report = $col[nm_file_report];
  105. $nm_file_report_back = $col[nm_file_report_back];
  106. $nm_file_front = $col[nm_file_front];
  107. $nm_file_back = $col[nm_file_back];
  108. $nm_file_side1 = $col[nm_file_side1];
  109. $nm_file_side2 = $col[nm_file_side2];
  110. $nm_file_dashboard = $col[nm_file_dashboard];
  111. $ds_oil = $col[ds_oil];
  112. $nm_gearbox = $col[nm_gearbox];
  113. $nm_color = $col[nm_color];
  114. $nm_incolor = $col[nm_incolor];
  115. $ds_accident = $col[ds_accident];
  116. $nm_cont_accident = $col[nm_cont_accident];
  117. $nm_regdate = $col[nm_regdate];
  118. $ds_sales = $col[ds_sales];
  119. $nm_btitle = $col[nm_btitle];
  120. $nm_stitle = $col[nm_stitle];
  121. $nm_ltitle = $col[nm_ltitle];
  122. $nm_cont = $col[nm_cont];
  123. $nm_guide = $col[nm_guide];
  124. $ds_open = $col[ds_open];
  125. $ds_status = $col[ds_status];
  126. $dt_insert = $col[dt_insert];
  127. $nm_insert = $col[nm_insert];
  128. $dt_update = $col[dt_update];
  129. $nm_update = $col[nm_update];
  130. $ds_delind = $col[ds_delind];
  131. $nm_number = $col[nm_number];
  132. $nm_cc = $col[nm_cc];
  133. $ds_trade = $col[ds_trade];
  134. $ds_main = $col[ds_main];
  135. $nm_regdate_yyyy = $col[nm_regdate_yyyy];
  136. $nm_regdate_mm = $col[nm_regdate_mm];
  137. $nm_regdate_dd = $col[nm_regdate_dd];
  138. $nm_brand = $col[nm_brand];
  139. $nm_model = $col[nm_model];
  140. $nm_model_sub = $col[nm_model_sub];
  141. $nm_grade = $col[nm_grade];
  142. $nm_year = $col[nm_year];
  143. $nm_type = $col[nm_type];
  144. $nm_open = $col[nm_open];
  145. $nm_sales = $col[nm_sales];
  146. $nm_transmission = $col[nm_transmission];
  147. $nm_oil = $col[nm_oil];
  148. $nm_usertype = $col[nm_usertype];
  149. $nm_accident = $col[nm_accident];
  150. $nm_area = $col[nm_area];
  151. $nm_area_user = $col[nm_area_user];
  152. $nm_name_sale = $col[nm_name_sale];
  153. $ds_status_sale = $col[ds_status_sale];
  154. $nm_hp_sale = $col[nm_hp_sale];
  155. $nm_email_sale = $col[nm_email_sale];
  156. $ds_area_sale = $col[ds_area_sale];
  157. $nm_recommend_sale = $col[nm_recommend_sale];
  158. $nm_cont_return_sale = $col[nm_cont_return_sale];
  159. $time_limit_tender = $col[time_limit_tender];
  160. //보험처리
  161. $nm_act_chgno = $col[nm_act_chgno];
  162. $nm_act_chgnm = $col[nm_act_chgnm];
  163. $nm_act_s1 = $col[nm_act_s1];
  164. $nm_act_s2 = $col[nm_act_s2];
  165. $nm_act_s3 = $col[nm_act_s3];
  166. $nm_act_s4 = $col[nm_act_s4];
  167. $nm_act_my = $col[nm_act_my];
  168. $nm_act_my_amt = $col[nm_act_my_amt];
  169. $nm_act_other = $col[nm_act_other];
  170. $nm_act_other_amt = $col[nm_act_other_amt];
  171. $nm_act_searchdt = $col[nm_act_searchdt];
  172. $nm_act_cnt = $col[nm_act_cnt];
  173. $nm_act_general_spec = $col[nm_act_general_spec];
  174. $nm_act_use_record = $col[nm_act_use_record];
  175. $nm_act_use_record_lend = $col[nm_act_use_record_lend];
  176. $nm_act_use_record_biz = $col[nm_act_use_record_biz];
  177. $nm_act_use_record_official = $col[nm_act_use_record_official];
  178. $nm_act_ins_loss = $col[nm_act_ins_loss];
  179. $nm_act_ins_wet = $col[nm_act_ins_wet];
  180. $nm_act_ins_robbery = $col[nm_act_ins_robbery];
  181. $nm_file_act = $col[nm_file_act];
  182. $nm_act_yn = $col[nm_act_yn];
  183. $ds_g1_01 = $col[ds_g1_01];
  184. $ds_g1_02 = $col[ds_g1_02];
  185. $ds_g1_03 = $col[ds_g1_03];
  186. $ds_g1_04 = $col[ds_g1_04];
  187. $ds_g1_05 = $col[ds_g1_05];
  188. $ds_g2_01 = $col[ds_g2_01];
  189. $ds_g2_02 = $col[ds_g2_02];
  190. $ds_g2_03 = $col[ds_g2_03];
  191. $ds_g2_04 = $col[ds_g2_04];
  192. $ds_g2_05 = $col[ds_g2_05];
  193. $ds_g3_01 = $col[ds_g3_01];
  194. $ds_g3_02 = $col[ds_g3_02];
  195. $ds_g3_03 = $col[ds_g3_03];
  196. $ds_g3_04 = $col[ds_g3_04];
  197. $ds_g3_05 = $col[ds_g3_05];
  198. $ds_g4_01 = $col[ds_g4_01];
  199. $ds_g4_02 = $col[ds_g4_02];
  200. $ds_g4_03 = $col[ds_g4_03];
  201. $ds_g4_04 = $col[ds_g4_04];
  202. $ds_g4_05 = $col[ds_g4_05];
  203. /*
  204. $arr_nm_info1 = explode("-",$nm_info1);
  205. if(count($arr_nm_info1) == 3){
  206. $nm_info11 = $arr_nm_info1[0];
  207. $nm_info12 = $arr_nm_info1[1];
  208. $nm_info13 = $arr_nm_info1[2];
  209. }else{
  210. $nm_info11 = "";
  211. $nm_info12 = "";
  212. $nm_info13 = "";
  213. }
  214. $arr_nm_info3 = explode("@",$nm_info3);
  215. if(count($arr_nm_info3) == 2){
  216. $nm_info31 = $arr_nm_info3[0];
  217. $nm_info32 = $arr_nm_info3[1];
  218. }else{
  219. $nm_info31 = "";
  220. $nm_info32 = "";
  221. }
  222. $nm_info3 = $col[nm_info3];
  223. */
  224. }else{
  225. AlertBack("지정되지않은 요청입니다");
  226. }
  227. $sql ="SELECT *
  228. FROM car_history_master mst
  229. WHERE cd_car='$cd_car' AND ds_delind='N' and ds_type = 'user'";
  230. $history_col=mysql_fetch_array(mysql_query($sql));
  231. $r000 = $history_col["r000"];
  232. $r001 = $history_col["r001"];
  233. $r002 = $history_col["r002"];
  234. $r004 = $history_col["r004"];
  235. $r005 = $history_col["r005"];
  236. $r101 = $history_col["r101"];
  237. $r102 = $history_col["r102"];
  238. $r103 = $history_col["r103"];
  239. $r104 = $history_col["r104"];
  240. $r105 = $history_col["r105"];
  241. $r106 = $history_col["r106"];
  242. $r107 = $history_col["r107"];
  243. $r108 = $history_col["r108"];
  244. $r109 = $history_col["r109"];
  245. $r401 = $history_col["r401"];
  246. $r402 = $history_col["r402"];
  247. $r403 = $history_col["r403"];
  248. $r404 = $history_col["r404"];
  249. $r405 = $history_col["r405"];
  250. $r406_01 = $history_col["r406_01"];
  251. $r407 = $history_col["r407"];
  252. $r408_01 = $history_col["r408_01"];
  253. $r409 = $history_col["r409"];
  254. $r410_01 = $history_col["r410_01"];
  255. $r201 = $history_col["r201"];
  256. $r202 = $history_col["r202"];
  257. $r203 = $history_col["r203"];
  258. $r204 = $history_col["r204"];
  259. $r205 = $history_col["r205"];
  260. $r510 = $history_col["r510"];
  261. $r511_01 = $history_col["r511_01"];
  262. $r501 = $history_col["r501"];
  263. $r502 = $history_col["r502"];
  264. $r301 = $history_col["r301"];
  265. $r302 = $history_col["r302"];
  266. $r303 = $history_col["r303"];
  267. $r601 = $history_col["r601"];
  268. $r602 = $history_col["r602"];
  269. ?>
  270. <h3><?=$nm_title?></h3>
  271. <div class="car_model">
  272. <? if($ds_status_sale == "E0" || $ds_status_sale == "F0"){ ?>
  273. <p class="fr">입찰 마감 시간 : <em><?=$time_limit_tender?></em></p>
  274. <? } ?>
  275. </div>
  276. <table class="tbl_h">
  277. <colgroup>
  278. <col width="16%">
  279. <col width="34%">
  280. <col width="16%">
  281. <col width="*">
  282. </colgroup>
  283. <!--tr>
  284. <th>이름</th>
  285. <td>홍**</td>
  286. <th>회원</th>
  287. <td>비회원</td>
  288. </tr>
  289. <tr>
  290. <th>연락처</th>
  291. <td>010-****-****</td>
  292. <th>아이디</th>
  293. <td>dkjslfslfskg;ls@naver.com</td>
  294. </tr>
  295. <tr>
  296. <th>주소</th>
  297. <td>서울마포구 서교동*****</td>
  298. <th>판매지역</th>
  299. <td>서울</td>
  300. </tr-->
  301. <tr>
  302. <th>차량번호</th>
  303. <td><?=$nm_number?></td>
  304. <th>제조사</th>
  305. <td><?=$nm_brand?></td>
  306. </tr>
  307. <tr>
  308. <th>모델</th>
  309. <td><?=$nm_model?></td>
  310. <th>세부모델</th>
  311. <td><?=$nm_model_sub?></td>
  312. </tr>
  313. <tr>
  314. <th>등급</th>
  315. <td><?=$nm_grade?></td>
  316. <th>연식(최초등록일)</th>
  317. <td><?=$nm_regdate_yyyy."년 ".$nm_regdate_mm."월"?></td>
  318. </tr>
  319. <tr>
  320. <th>형식연도</th>
  321. <td><?=$nm_year?>년</td>
  322. <th>배기량</th>
  323. <td><?=$nm_cc?>cc</td>
  324. </tr>
  325. <tr>
  326. <th>변속기</th>
  327. <td><?=$nm_transmission?></td>
  328. <th>연료</th>
  329. <td><?=$nm_oil?></td>
  330. </tr>
  331. <tr>
  332. <th>색상</th>
  333. <td><?=$nm_color?></td>
  334. <th>주행거리</th>
  335. <td><?=$nm_mileage?>km</td>
  336. </tr>
  337. <tr>
  338. <th>사고유무</th>
  339. <td colspan="3"><?=$nm_accident?>
  340. &nbsp;<?=$nm_cont_accident?></td>
  341. <!--th>추천인</th>
  342. <td><?= ($nm_recommend_sale == "") ? "없음":$nm_recommend_sale ?></td-->
  343. </tr>
  344. <tr>
  345. <th>옵션</th>
  346. <td colspan="3"><?=$nm_cont?></td>
  347. </tr>
  348. <tr>
  349. <!-- 판매 희망지역 추가 -->
  350. <th>판매희망지역</th>
  351. <td colspan="3">
  352. <?=$nm_area_user?>
  353. </td>
  354. <!-- 판매 희망지역 추가 -->
  355. </tr>
  356. <tr>
  357. <th>필수사진</th>
  358. <td colspan="3">
  359. <ul class="photo_list">
  360. <li>
  361. <!-- img src="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_front?>" onclick="viewPhoto('<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_front?>')" -->
  362. <img data-sgallery="group1" data-full="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_front?>" data-thumb="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_front?>" src="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_front?>" title="차량전면">
  363. <span>차량전면</span>
  364. </li>
  365. <li>
  366. <img data-sgallery="group1" data-full="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_back?>" data-thumb="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_back?>" src="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_back?>" title="차량후면">
  367. <span>차량후면</span>
  368. </li>
  369. <li>
  370. <img data-sgallery="group1" data-full="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_side1?>" data-thumb="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_side1?>" src="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_side1?>" title="운전석 측면">
  371. <span>운전석 측면</span>
  372. </li>
  373. <li>
  374. <img data-sgallery="group1" data-full="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_side2?>" data-thumb="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_side2?>" src="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_side2?>" title="조수석 측면">
  375. <span>조수석 측면</span>
  376. </li>
  377. <li>
  378. <img data-sgallery="group1" data-full="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_dashboard?>" data-thumb="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_dashboard?>" src="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_dashboard?>" title="계기판">
  379. <span>계기판</span>
  380. </li>
  381. </ul>
  382. </td>
  383. </tr>
  384. <tr>
  385. <th>추가사진</th>
  386. <td colspan="3">
  387. <ul class="photo_list">
  388. <?
  389. if(!empty($col[cd_car])){
  390. $r = mysql_query("SELECT * FROM car_file WHERE cd_car = '$cd_car' and ds_type='' and ds_delind='N' Order by no_sort asc , cd_car ASC ");
  391. $i=1;
  392. while($imgs = mysql_fetch_array($r)) {
  393. ?>
  394. <li><img data-sgallery="group2" data-full="<?=UPLOAD_PATH_CAR?><?=$imgs[cd_car]?>_detail/<?=$imgs[nm_file]?>" data-thumb="<?=UPLOAD_PATH_CAR?><?=$imgs[cd_car]?>_detail/<?=$imgs[nm_file]?>" src="<?=UPLOAD_PATH_CAR?><?=$imgs[cd_car]?>_detail/<?=$imgs[nm_file]?>"></li>
  395. <?
  396. }
  397. }else{
  398. ?>
  399. <?
  400. }
  401. ?>
  402. </ul>
  403. </td>
  404. </tr>
  405. <tr>
  406. <th>담당자코멘트</th>
  407. <td colspan="3"><?=$nm_guide?></td>
  408. </tr>
  409. </table>
  410. <h3>사고이력정보</h3>
  411. <?
  412. /*
  413. <table class="tbl_h">
  414. <colgroup>
  415. <col width="16%">
  416. <col width="*">
  417. </colgroup>
  418. <tr>
  419. <th>차량번호 변경</th>
  420. <td><?=$nm_act_chgno?> 회</td>
  421. </tr>
  422. <tr>
  423. <th>소유자 변경</th>
  424. <td><?=$nm_act_chgnm?> 회</td>
  425. </tr>
  426. <tr>
  427. <th>자동차 보험 특수 사고</th>
  428. <td>전손 : <?=$nm_act_s1?>회 / 침수전손 : <?=$nm_act_s2?>회 / 침수분손 : <?=$nm_act_s3?>회 / 도난 : <?=$nm_act_s4?>회</td>
  429. </tr>
  430. <tr>
  431. <th>보험사고 (내차피해)</th>
  432. <td><?=$nm_act_my?> 회(<?=$nm_act_my_amt?> 원)</td>
  433. </tr>
  434. <tr>
  435. <th>보험사고 (타차가해)</th>
  436. <td><?=$nm_act_other?> 회(<?=$nm_act_other_amt?> 원)</td>
  437. </tr>
  438. <!--tr>
  439. <th>사고이력 조회일</th>
  440. <td>2018-12-05 </td>
  441. </tr-->
  442. </table>
  443. */
  444. ?>
  445. <table class="tbl_h">
  446. <colgroup>
  447. <col width="16%">
  448. <col width="*">
  449. </colgroup>
  450. <tr>
  451. <th>차량번호 변경</th>
  452. <td><?=number_format($r201)?> 회</td>
  453. </tr>
  454. <tr>
  455. <th>소유자 변경</th>
  456. <td><?=number_format($r204)?> 회</td>
  457. </tr>
  458. <tr>
  459. <th>자동차 보험 특수 사고</th>
  460. <td>전손 : <?=number_format($r405)?>회 / 침수전(분)손 : <?=number_format($r407)?>회 / 도난 : <?=number_format($r409)?>회</td>
  461. </tr>
  462. <tr>
  463. <th>보험사고 (내차피해)</th>
  464. <td><?=number_format($r401)?> 회(<?=number_format($r402)?> 원)</td>
  465. </tr>
  466. <tr>
  467. <th>보험사고 (타차가해)</th>
  468. <td><?=number_format($r403)?> 회(<?=number_format($r404)?> 원)</td>
  469. </tr>
  470. <!--tr>
  471. <th>사고이력 조회일</th>
  472. <td>2018-12-05 </td>
  473. </tr-->
  474. </table>
  475. <div class="btn_right">
  476. <a href="#" class="button" onclick="openLayer('car'); return false;">사고이력 정보 조회 보기</a>
  477. </div>
  478. <!-- layer popup -->
  479. <div class="layer_popup car_popup">
  480. <h3>중고차 보험처리 이력정보 보고서</h3>
  481. <p class="close">레이어팝업닫기</p>
  482. <?
  483. //차량 보험처리 이력 정보
  484. include_once($_SERVER['DOCUMENT_ROOT'].'/common/inc/inc_car_history.php');
  485. ?>
  486. </div>
  487. <!-- // layer popup -->
  488. <?
  489. // $sql ="select count(*) cnt, max(case when ".$sql_ds_type." then nm_price else 0 end) nm_price_max from tender_master where cd_sale = $cd_sale ";
  490. $sql ="select count(*) cnt
  491. , max(case when ".$sql_ds_type." then cast(nm_price as UNSIGNED) else 0 end) nm_price_max
  492. , min(cast(nm_price as UNSIGNED)) min_price
  493. , avg(cast(nm_price as UNSIGNED)) avg_price
  494. , max(cast(nm_price as UNSIGNED)) max_price
  495. from tender_master where cd_sale = $cd_sale ";
  496. // echo $sql;
  497. $col1=mysql_fetch_array(mysql_query($sql));
  498. // $col1=mysql_fetch_array(mysql_query($sql));
  499. ?>
  500. <?
  501. #유찰의 경우만 visible
  502. if($rq_ds_status == "ZE") {
  503. ?>
  504. <!-- 2020-01-23 유찰상세추가 -->
  505. <div class="price_info">
  506. <ul class="price_list">
  507. <li><strong>최고가 입찰금액 : <?=number_format($col1[max_price])?>만원</strong></li>
  508. <li><strong>최저가 입찰금액 : <?=number_format($col1[min_price])?>만원</strong></li>
  509. <li>평균 입찰금액 : <?=number_format($col1[avg_price])?>만원</li>
  510. <li>입찰자 수 : <?=$col1[cnt]?>곳</li>
  511. </ul>
  512. <ul class="ranking">
  513. <?
  514. $col2_cnt = 1;
  515. $col2_ord = 65;
  516. $sql2 =mysql_query("select nm_price
  517. ,(select nm_company from dealer_master a where a.cd_dealer = b.cd_dealer_p limit 1) as nm_company
  518. from tender_master b where cd_sale = $cd_sale
  519. order by cast(nm_price as UNSIGNED) desc limit 3");
  520. while($col2 = mysql_fetch_array($sql2)) {
  521. ?>
  522. <li><span class="rank"><?=$col2_cnt?>위</span> <?=number_format($col2[nm_price])?>만원 / <?=chr($col2_ord)?>상사<?//$col2[nm_company]?></li>
  523. <?
  524. $col2_ord++;
  525. $col2_cnt++;
  526. }
  527. ?>
  528. <!-- <li><span class="rank">1위</span> 3,000만원 / A상사</li>
  529. <li><span class="rank">2위</span> 2,850만원 / B상사</li>
  530. <li><span class="rank">3위</span> 2,500만원 / C상사</li> -->
  531. </ul>
  532. </div>
  533. <?
  534. if($col1[nm_price_max]>0) {
  535. ?>
  536. <div class="bidding_board">
  537. <p class="my_price">나의 입찰금액은 <strong><?=number_format($col1[nm_price_max])?></strong>만원입니다.</p>
  538. </div>
  539. <?
  540. }
  541. ?>
  542. <!-- // 2020-01-23 유찰상세추가 -->
  543. <?
  544. }else {
  545. ?>
  546. <div class="bidding_board<? if($col1[nm_price_max]>0) { ?> ty2<? } ?>">
  547. <dl>
  548. <dt>입찰 진행 중</dt>
  549. <dd><strong><?=$col1[cnt]?></strong>명의 딜러가 입찰하였습니다.</dd>
  550. </dl>
  551. <?
  552. if($col1[nm_price_max]>0) {
  553. ?>
  554. <p>나의 입찰가는 <strong><?=$col1[nm_price_max]?></strong>만원입니다.</p>
  555. <?
  556. }
  557. ?>
  558. </div>
  559. <?
  560. //select count(*) cnt_tender, sum(case when cd_dealer = '55' then 1 else 0 end) cnt_tender_dealer from tender_master where ds_delind ='N' and cd_sale = '73' and cd_dealer_p = '52'
  561. // $cd_tender = @mysql_result(mysql_query("select cd_tender from tender_master where ds_delind ='N' and cd_sale = '$cd_sale' and cd_dealer = '$s_cd_dealer' "),0,0);
  562. $cd_tender = mysql_fetch_array(mysql_query("select count(*) cnt_tender, sum(case when cd_dealer = '$s_cd_dealer' then 1 else 0 end) cnt_tender_dealer from tender_master where ds_delind ='N' and cd_sale = '$cd_sale' and cd_dealer_p = '$s_cd_dealer_p' "));
  563. //입찰하기 : 입찰대기건/부관리자/현재미입찰건(부관리자본인)
  564. // if($rq_ds_status == "E0" && $s_ds_type == "D1" && empty($cd_tender) && $time_limit_tender != "0분"){ //딜러-관리자
  565. //입찰하기 : 입찰대기건/부관리자/소속딜러입찰건1건이하일경우만(2건이상일경우제한)/현재미입찰건(부관리자본인)/소속총괄관리자 관리자에게 승인 받은 경우
  566. if($rq_ds_status == "E0" && $s_ds_type == "D1" && ($cd_tender[cnt_tender] < 2 && $cd_tender[cnt_tender_dealer] == 0) && $time_limit_tender != "0분" && $s_ds_status_p == "Z0"){ //딜러-관리자
  567. ?>
  568. <div class="btn_right">
  569. <a href="#" class="button" onclick="openLayer('price'); return false;">입찰하기</a>
  570. <!-- a href="#" class="button">목록가기</a -->
  571. </div>
  572. <!-- layer_popup -->
  573. <div class="layer_popup price_popup">
  574. <div class="popup_wrap">
  575. <p class="msg">
  576. 내 입찰금액은<br>
  577. <input type="text" class="inp_txt" style="width:355px;" name="nm_price_pop" id="nm_price_pop"> 만원입니다.
  578. <span class="sub_txt">(※ 입력 예시 : 1500만원일 경우 1500입력, 500만원일 경우 500입력)</span>
  579. </p>
  580. <div class="btn_center">
  581. <a href="#" class="button" id="btn_write">입찰하기</a>
  582. </div>
  583. <!-- p class="msg2">입찰금액은<br><strong>2500</strong>만원입니다.</p>
  584. <div class="btn_center">
  585. <a href="#" class="button">확인</a>
  586. <a href="#" class="button gray" onclick="closeLayer('price'); return false;">취소</a>
  587. </div -->
  588. </div>
  589. <div class="close">레이어팝업 닫기</div>
  590. </div>
  591. <!-- // layer_popup -->
  592. <? } ?>
  593. <?
  594. //입찰금액 수정은 딱히 정해 진게 없어서 정의 후 작업
  595. /*
  596. * 딜러가 입찰한 내역이 있어야 하고
  597. * 현재 sale 상태가 입찰대기(E0)여야 하며
  598. * 수정 내역이 3번까지만 가능
  599. * 낙찰 마감일이 안지나야 가능
  600. */
  601. $cd_tender_sql = "select cd_tender, nm_modify_cnt
  602. , (select ds_status from sale_master s where s.cd_sale = t.cd_sale) as sale_ds_status
  603. from tender_master t
  604. where t.ds_delind ='N'
  605. and t.cd_sale = '$cd_sale'
  606. and t.cd_dealer_p = '$s_cd_dealer_p'
  607. limit 1";
  608. // echo $cd_tender_sql;
  609. $cd_tender = mysql_fetch_array(mysql_query($cd_tender_sql));
  610. if($rq_ds_status == "F0" && $s_ds_type == "D1" && $cd_tender[sale_ds_status] == 'E0' && !empty($cd_tender[cd_tender]) && $cd_tender[nm_modify_cnt] < 3 && $time_limit_tender != "0분" && $s_ds_status_p == "Z0"){ //딜러-관리자
  611. ?>
  612. <style>
  613. .mod_price_popup{width:570px;}
  614. .mod_price_popup .msg{padding:25px 30px 0;font-size:23px;line-height:45px;}
  615. .mod_price_popup .msg .inp_txt{font-size:18px;color:#000;text-align:right;}
  616. .mod_price_popup .msg strong{font-size:30px;color:#0496bb;}
  617. .mod_price_popup .msg .sub_txt{display:block;font-size:13px;color:#b30303;}
  618. .mod_price_popup .msg2{padding-top:40px;font-size:28px;line-height:45px;text-align:center;}
  619. .mod_price_popup .msg2 strong{font-size:36px;color:#0496bb;vertical-align:bottom;}
  620. .mod_price_popup .btn_center{margin-top:40px;}
  621. </style>
  622. <div class="btn_right">
  623. <a href="#" class="button" onclick="openLayer('mod_price'); return false;">가격수정</a>
  624. <!-- a href="#" class="button">목록가기</a -->
  625. </div>
  626. <!-- layer_popup -->
  627. <div class="layer_popup mod_price_popup">
  628. <div class="popup_wrap">
  629. <p class="msg">
  630. 내 입찰금액은<br>
  631. <input type="text" class="inp_txt" style="width:355px;" name="mod_nm_price_pop" id="mod_nm_price_pop"> 만원입니다.
  632. <span class="sub_txt">(※ 입력 예시 : 1500만원일 경우 1500입력, 500만원일 경우 500입력)</span>
  633. </p>
  634. <div class="btn_center">
  635. <a href="#" class="button" id="btn_mod_write">수정하기</a>
  636. </div>
  637. <!-- p class="msg2">입찰금액은<br><strong>2500</strong>만원입니다.</p>
  638. <div class="btn_center">
  639. <a href="#" class="button">확인</a>
  640. <a href="#" class="button gray" onclick="closeLayer('price'); return false;">취소</a>
  641. </div -->
  642. </div>
  643. <div class="close">레이어팝업 닫기</div>
  644. </div>
  645. <!-- // layer_popup -->
  646. <? } ?>
  647. <form id="frmForm" name="frmForm" method="post" action="./dealer_proc.php">
  648. <input type="hidden" name="mode" id="mode" value="Tender"/>
  649. <input type="hidden" name="cd_sale" id="cd_sale" value="<?=$cd_sale?>"/>
  650. <input type="hidden" name="nm_price" id="nm_price"/>
  651. <input type="hidden" name="ListPageNo" value="<?=$ListPageNo?>"/>
  652. </form>
  653. <script language="javascript" type="text/javascript">
  654. var ds_mode ="<?=$mode?>";
  655. $(document).ready(function() {
  656. $("#btn_write").bind("click",function(){
  657. var fieldlist = [["nm_price_pop","입찰금액"]]
  658. if (!fnCheckForm(fieldlist)){
  659. return false;
  660. }
  661. $("#nm_price").val($("#nm_price_pop").val());
  662. var c = confirm("처리하시겠습니까?");
  663. if(c){
  664. $("#frmForm").submit();
  665. }else{
  666. return false;
  667. }
  668. });
  669. $("#btn_mod_write").bind("click",function(){
  670. var fieldlist = [["mod_nm_price_pop","입찰 수정금액"]]
  671. if (!fnCheckForm(fieldlist)){
  672. return false;
  673. }
  674. $("#nm_price").val($("#mod_nm_price_pop").val());
  675. var c = confirm("처리하시겠습니까?");
  676. if(c){
  677. $("#mode").val("TenderModify");
  678. $("#frmForm").submit();
  679. }else{
  680. return false;
  681. }
  682. });
  683. });
  684. </script>
  685. <?
  686. }
  687. ?>
  688. <!-- layer popup3 -->
  689. <div class="layer_popup photo_popup">
  690. <div class="popup_wrap">
  691. <img src="/img/sell/ic_car_photo1.png" id="photoBig">
  692. </div>
  693. <div class="close" onclick="closeLayer('photo');">레이어팝업 닫기</div>
  694. </div>
  695. <!-- // layer popup3 -->
  696. </div>
  697. <script laguage="javascript" type="text/javascript">
  698. function viewPhoto(arg1){
  699. $("#photoBig").attr("src", arg1);
  700. openLayer('photo'); return false;
  701. }
  702. </script>
  703. </section>
  704. </section>
  705. <script type="text/javascript" charset="utf-8" src="/js/jquery.sumogallery.js"></script>
  706. <? include("../include/inc_footer.php") ?>
  707. <? include("../include/inc_bottom.php") ?>
  708. <?
  709. mysql_close($connect);
  710. ?>