main.php 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818
  1. <?php
  2. include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
  3. include $_SERVER['DOCUMENT_ROOT'].'/common/aap_chk.php';
  4. $s_cd_dealer = $_SESSION['s_cd_dealer'];
  5. $s_cd_dealer_p = $_SESSION['s_cd_dealer_p'];
  6. $s_aap_ds_type = $_SESSION['s_aap_ds_type'];
  7. $s_ds_usertype = $_SESSION['s_ds_usertype'];
  8. $PageNo = $_REQUEST['pageno'];
  9. $PageSize = 4;//$_REQUEST['PageSize'];
  10. if (empty($PageNo)) {$PageNo=1;}else{$PageNo=$PageNo;}
  11. if (empty($PageSize)) {
  12. $PageSize=2; //목록개수설정
  13. }else{$PageSize=$PageSize;}
  14. if(empty($ds_aap_status)) {
  15. $ds_aap_status = 'E0';
  16. }
  17. $pagestartpoint=($PageNo-1)*$PageSize;
  18. $orderby = "order by s.dt_insert desc";
  19. if($s_aap_ds_type == "D0"){ //딜러
  20. $sql_ds_type = " and cd_dealer_p = '$s_cd_dealer' ";
  21. }else{ //딜러-부관리자
  22. $sql_ds_type = " and cd_dealer = '$s_cd_dealer' ";
  23. }
  24. $sql = "where s.ds_delind='N'";
  25. $ds_type = "A0"; //A0 : 매입
  26. $sql = $sql. " and s.ds_type = '$ds_type' ";
  27. // $sql = $sql. " and s.ds_status in ('E0','F0','G0','Z0','ZE','ZS')";
  28. $sql = $sql. " and s.ds_dealer_type = 'A0' ";
  29. // $sql = $sql. " and s.cd_sale not in (select cd_sale from tender_master where ds_delind = 'N' and cd_dealer_p = '$s_cd_dealer_p' group by cd_sale having count(*) > 1)"; //딜러 업체 소속 입찰 건이 2건 보다 작을 시만 입찰 요청 건에 보이게 한다.
  30. // if($s_aap_ds_type == "D1"){ //딜러-관리자
  31. // // $sql = $sql. " and s.cd_sale not in (select cd_sale from tender_master where ds_delind = 'N' and cd_dealer = '$s_cd_dealer' group by cd_sale)"; //본인 입찰 건 제외한 입찰 건
  32. // }
  33. // echo $sql;
  34. // exit;
  35. // $total_sql = "SELECT
  36. // count(*) as total_cnt
  37. // , sum(case when s.ds_status = 'E0' and ifnull(t.cd_tender,0) < 1 AND s.dt_approve >= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_TENDER."' HOUR) then 1 else 0 end) as E0_cnt
  38. // , sum(case when s.ds_status = 'E0' and t.cd_tender > 0 then 1 else 0 end) as F0_cnt
  39. // , sum(case when s.ds_status = 'Z0' and (s.ds_status_contract = '' or s.ds_status_contract = 'Z0') and t.cd_tender > 0 then 1 else 0 end) as Z0_cnt
  40. // , sum(case when (s.ds_status = 'ZE' OR (s.ds_status = 'Z0' AND s.ds_status_contract IN ('C0', 'E0', 'M0'))) then 1 else 0 end) as ZE_cnt
  41. // , sum(case when s.ds_status = 'ZS' then 1 else 0 end) as ZS_cnt
  42. // FROM sale_master s
  43. // INNER JOIN car_master a on (s.cd_car = a.cd_car)
  44. // left outer join car_model b on (a.cd_model = b.cd_model)
  45. // left outer join tender_master t on (s.cd_sale = t.cd_sale AND t.ds_delind = 'N' $sql_ds_type )
  46. // left outer join car_brand d on (a.cd_brand = d.cd_brand)
  47. // $sql";
  48. //2023-08-28 query 문 LIMIT TIME TENDER가 ds_auction_time로 변경되어 쿼리문 수정
  49. //또한 동일날짜에 tender master left outer join을 inner join 으로 변경함
  50. //입찰대기
  51. $sum_sql = "SELECT
  52. sum(case when ifnull(t.cd_tender,0) < 1 then 1 else 0 end) as cnt
  53. FROM sale_master s
  54. INNER JOIN car_master a on (s.cd_car = a.cd_car)
  55. left outer join (
  56. SELECT * from tender_master tm
  57. where ds_delind = 'N'
  58. $sql_ds_type
  59. group by cd_sale
  60. ) t on ( s.cd_sale = t.cd_sale )
  61. $sql
  62. AND s.ds_status = 'E0'
  63. AND s.dt_approve >= DATE_ADD(now(), INTERVAL concat('-', s.ds_auction_time) HOUR) ";
  64. // echo $sum_sql;
  65. $sum = mysql_fetch_array(mysql_query($sum_sql));
  66. $E0_cnt = (!empty($sum['cnt']) ? $sum['cnt'] : 0);
  67. // echo $E0_cnt;
  68. // exit;
  69. //입찰중
  70. $sum_sql = "SELECT
  71. sum(case when t.cd_tender > 0 then 1 else 0 end) as cnt
  72. FROM sale_master s
  73. INNER JOIN car_master a on (s.cd_car = a.cd_car)
  74. INNER join (
  75. SELECT * from tender_master tm
  76. where ds_delind = 'N'
  77. $sql_ds_type
  78. group by cd_sale
  79. ) t on ( s.cd_sale = t.cd_sale )
  80. $sql
  81. AND s.ds_status = 'E0' ";
  82. // echo $sum_sql;
  83. $sum = mysql_fetch_array(mysql_query($sum_sql));
  84. $F0_cnt = (!empty($sum['cnt']) ? $sum['cnt'] : 0);
  85. // echo $F0_cnt;
  86. // exit;
  87. //거래중
  88. $sum_sql = "SELECT
  89. sum(case when t.cd_tender > 0 then 1 else 0 end) as cnt
  90. FROM sale_master s
  91. INNER JOIN car_master a on (s.cd_car = a.cd_car)
  92. INNER join (
  93. SELECT * from tender_master tm
  94. where ds_delind = 'N'
  95. AND ds_status = 'Z0'
  96. $sql_ds_type
  97. group by cd_sale
  98. ) t on ( s.cd_sale = t.cd_sale )
  99. $sql
  100. AND s.ds_status = 'Z0' and (s.ds_status_contract = '' or s.ds_status_contract = 'Z0') AND s.ds_status_contract_step1 = 'Y' ";
  101. // echo $sum_sql;
  102. $sum = mysql_fetch_array(mysql_query($sum_sql));
  103. $Z0_cnt = (!empty($sum['cnt']) ? $sum['cnt'] : 0);
  104. // echo $Z0_cnt;
  105. // exit;
  106. //유찰
  107. $sum_sql = "SELECT
  108. sum(case when ifnull(t.cd_tender,0) < 1 then 1 else 0 end) as cnt
  109. FROM sale_master s
  110. INNER JOIN car_master a on (s.cd_car = a.cd_car)
  111. inner join (
  112. SELECT * from tender_master tm
  113. where ds_delind = 'N'
  114. $sql_ds_type
  115. group by cd_sale
  116. ) t on ( s.cd_sale = t.cd_sale )
  117. $sql
  118. AND (s.ds_status = 'ZE' OR (s.ds_status = 'Z0' AND s.ds_status_contract IN ('C0', 'E0', 'M0'))) ";
  119. // echo $sum_sql;
  120. $sum = mysql_fetch_array(mysql_query($sum_sql));
  121. $ZE_cnt = (!empty($sum['cnt']) ? $sum['cnt'] : 0);
  122. if($_SERVER['REMOTE_ADDR'] == '220.86.24.199') {
  123. // echo $sum_sql;
  124. // exit;
  125. }
  126. // echo $ZE_cnt;
  127. // exit;
  128. //거래완료
  129. $sum_sql = "SELECT
  130. sum(case when t.cd_tender > 0 then 1 else 0 end) as cnt
  131. FROM sale_master s
  132. INNER JOIN car_master a on (s.cd_car = a.cd_car)
  133. INNER join (
  134. SELECT * from tender_master tm
  135. where ds_delind = 'N'
  136. AND ds_status = 'Z0'
  137. $sql_ds_type
  138. group by cd_sale
  139. ) t on ( s.cd_sale = t.cd_sale )
  140. $sql
  141. AND s.ds_status = 'ZS' ";
  142. // echo $sum_sql;
  143. $sum = mysql_fetch_array(mysql_query($sum_sql));
  144. $ZS_cnt = (!empty($sum['cnt']) ? $sum['cnt'] : 0);
  145. // echo $ZS_cnt;
  146. // exit;
  147. // $total_sql = "SELECT
  148. // count(*) as total_cnt
  149. // , sum(case when s.ds_status = 'E0' and ifnull(t.cd_tender,0) < 1 AND s.dt_approve >= DATE_ADD(now(), INTERVAL concat('-', s.ds_auction_time) HOUR) then 1 else 0 end) as E0_cnt
  150. // , sum(case when s.ds_status = 'E0' and t.cd_tender > 0 then 1 else 0 end) as F0_cnt
  151. // , sum(case when s.ds_status = 'Z0' and (s.ds_status_contract = '' or s.ds_status_contract = 'Z0') AND s.ds_status_contract_step1 = 'Y' and t.cd_tender > 0 then 1 else 0 end) as Z0_cnt
  152. // , sum(case when (s.ds_status = 'ZE' OR (s.ds_status = 'Z0' AND s.ds_status_contract IN ('C0', 'E0', 'M0'))) then 1 else 0 end) as ZE_cnt
  153. // , sum(case when s.ds_status = 'ZS' $sql_ds_type then 1 else 0 end) as ZS_cnt
  154. // FROM sale_master s
  155. // INNER JOIN car_master a on (s.cd_car = a.cd_car)
  156. // left outer join tender_master t on (s.cd_sale = t.cd_sale AND t.ds_delind = 'N' $sql_ds_type )
  157. // left outer join car_model b on (a.cd_model = b.cd_model)
  158. // left outer join car_brand d on (a.cd_brand = d.cd_brand)
  159. // $sql";
  160. //
  161. //
  162. // // echo $total_sql;
  163. // // exit;
  164. // if($_SERVER['REMOTE_ADDR'] == '220.86.24.199') {
  165. // echo $total_sql;
  166. // // exit;
  167. // }
  168. // $count_data = mysql_fetch_array(mysql_query($total_sql));
  169. // $totalrows = $count_data['total_cnt'];
  170. // $E0_cnt = $count_data['E0_cnt'];
  171. // $F0_cnt = $count_data['F0_cnt'];
  172. // $Z0_cnt = $count_data['Z0_cnt'];
  173. // $ZE_cnt = $count_data['ZE_cnt'];
  174. // $ZS_cnt = $count_data['ZS_cnt'];
  175. ?>
  176. <?php include("include/header.php") ?>
  177. <main class="pb123">
  178. <section>
  179. <!-- 개발 먼저 진행해주세요 디자인 추후 입힐 예정입니다. -->
  180. <div class="main--header--contents">
  181. <div class="d-flex align-items-center justify-content-center">
  182. <div onclick="location.href='/aap/standby_list.php'">
  183. <div>입찰대기</div>
  184. <div><?=number_format($E0_cnt)?></div>
  185. </div>
  186. <div onclick="location.href='/aap/prepare_list.php'">
  187. <div>입찰중</div>
  188. <div><?=number_format($F0_cnt)?></div>
  189. </div>
  190. <div onclick="location.href='/aap/underway_list.php'">
  191. <div>거래중</div>
  192. <div><?=number_format($Z0_cnt)?></div>
  193. </div>
  194. <div onclick="location.href='/aap/fail_list.php'">
  195. <div>유찰</div>
  196. <div><?=number_format($ZE_cnt)?></div>
  197. </div>
  198. <div onclick="location.href='/aap/end_list.php'">
  199. <div>매입완료</div>
  200. <div><?=number_format($ZS_cnt)?></div>
  201. </div>
  202. </div>
  203. </div>
  204. </section>
  205. <section>
  206. <div class="car--list--wrap">
  207. <div class="title--wrapper">
  208. <h2>입찰 대기중 차량</h2>
  209. <button type="button" class="more--btn" onclick="link('standby_list.php')">more+</button>
  210. </div>
  211. <ul>
  212. <?php
  213. $sql1 = $sql." and s.ds_status in ('E0') and t.cd_sale is null ";
  214. //2023-10-24 1개 매물에 부관리자가 여러명 입찰시 메인관리자는 매물이 2개가 나와 쿼리문 수정
  215. // "SELECT
  216. // a.*
  217. // , b.nm_model
  218. // , d.nm_brand
  219. // , getCode('car_master','ds_type',a.ds_type) as nm_type
  220. // , getCode('car_master','ds_open',a.ds_open) as nm_open
  221. // , getCode('car_master','ds_sales',a.ds_sales) as nm_sales
  222. // , getCode('car_master','ds_transmission',a.ds_transmission) as nm_transmission
  223. // , getCode('member_master','ds_area',s.ds_area) as nm_area
  224. // , getCode('sale_master','ds_status',s.ds_status) as nm_status
  225. // , s.cd_sale
  226. // , s.nm_name nm_name_sale
  227. // , s.ds_status ds_status_sale
  228. // , case when s.ds_status in ('B0','C0') then '미승인' when s.ds_status in ('D0') then '반려' when s.ds_status in ('E0','F0') then '입찰중' when s.ds_status in ('G0') then '입찰마감' when s.ds_status in ('Z0') then '낙찰' when s.ds_status in ('ZS') then '구매확정' else '' end as nm_status_sale
  229. // -- , case when a.nm_act_yn in ('Y') then '유' else '무' end as nm_act_yn_name
  230. // , getCode('car_master','ds_accident',a.ds_accident) as nm_act_yn_name
  231. // , getRemainTime(".LIMIT_TIME_TENDER.", s.dt_approve, now()) as time_limit_tender
  232. // FROM sale_master s
  233. // inner join car_master a on (s.cd_car = a.cd_car)
  234. // left outer join tender_master t on (s.cd_sale = t.cd_sale $sql_ds_type)
  235. // left outer join car_model b on (a.cd_model = b.cd_model)
  236. // left outer join car_brand d on (a.cd_brand = d.cd_brand)
  237. // $sql1
  238. // and s.dt_approve >= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_TENDER."' HOUR)
  239. // $orderby LIMIT $pagestartpoint,$PageSize"
  240. $r = mysql_query("SELECT
  241. a.*
  242. , b.nm_model
  243. , d.nm_brand
  244. , getCode('car_master','ds_type',a.ds_type) as nm_type
  245. , getCode('car_master','ds_open',a.ds_open) as nm_open
  246. , getCode('car_master','ds_sales',a.ds_sales) as nm_sales
  247. , getCode('car_master','ds_transmission',a.ds_transmission) as nm_transmission
  248. , getCode('member_master','ds_area',s.ds_area) as nm_area
  249. , getCode('sale_master','ds_status',s.ds_status) as nm_status
  250. , s.cd_sale
  251. , s.nm_name nm_name_sale
  252. , s.ds_status ds_status_sale
  253. , case when s.ds_status in ('B0','C0') then '미승인' when s.ds_status in ('D0') then '반려' when s.ds_status in ('E0','F0') then '입찰중' when s.ds_status in ('G0') then '입찰마감' when s.ds_status in ('Z0') then '낙찰' when s.ds_status in ('ZS') then '구매확정' else '' end as nm_status_sale
  254. -- , case when a.nm_act_yn in ('Y') then '유' else '무' end as nm_act_yn_name
  255. , getCode('car_master','ds_accident',a.ds_accident) as nm_act_yn_name
  256. , getRemainTime(".LIMIT_TIME_TENDER.", s.dt_approve, now()) as time_limit_tender
  257. FROM sale_master s
  258. inner join car_master a on (s.cd_car = a.cd_car)
  259. left outer join (
  260. SELECT * from tender_master tm
  261. where ds_delind = 'N'
  262. $sql_ds_type
  263. group by cd_sale
  264. ) t on ( s.cd_sale = t.cd_sale )
  265. left outer join car_model b on (a.cd_model = b.cd_model)
  266. left outer join car_brand d on (a.cd_brand = d.cd_brand)
  267. $sql1
  268. and s.dt_approve >= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_TENDER."' HOUR)
  269. $orderby LIMIT $pagestartpoint,$PageSize");
  270. $i=1;
  271. while($col = mysql_fetch_array($r)) {
  272. $car_image = getCarBasicThumbImage($col['cd_car'], $col['nm_file_front'], '차량전면', false, 'car_basic');
  273. // $car_image = "/images/common/bg_no_photo.png";
  274. // if(file_exists($_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR."nm_file_main/ratio/".$col['nm_file_front'])) {
  275. // $car_image = UPLOAD_PATH_CAR."nm_file_main/ratio/".$col['nm_file_front'];
  276. // }
  277. ?>
  278. <li class="">
  279. <div class="car--box--wrap ">
  280. <h2 class="car--name"><?=$col['nm_brand']." ".$col['nm_model']?></h2>
  281. <div class="thumb--wrap">
  282. <?=$car_image?>
  283. </div>
  284. <div class="car--info">
  285. <dl>
  286. <dt>주행거리 : </dt>
  287. <dd><?=number_format($col['nm_mileage'])?>km</dd>
  288. </dl>
  289. <dl>
  290. <dt>최초 등록일 : </dt>
  291. <dd><?=$col['nm_regdate_mm']?> / <?=$col['nm_regdate_yyyy']?></dd>
  292. </dl>
  293. <dl>
  294. <dt>사고유무 : </dt>
  295. <dd><?=$col['nm_act_yn_name']?></dd>
  296. </dl>
  297. <dl>
  298. <dt>판매지역 : </dt>
  299. <dd><?=$col['nm_area']?></dd>
  300. </dl>
  301. </div>
  302. <div class="status--wrap">
  303. <!-- <span><?=$col['nm_status_sale']?></span> -->
  304. <span>대기중</span>
  305. </div>
  306. <div class="btn--wrapper hide">
  307. <button type="button" onclick="link('standby_view.php?cd_sale=<?=$col['cd_sale']?>')">자동차 보러가기<i class="arrow--ic"></i></button>
  308. </div>
  309. </div>
  310. </li>
  311. <?php
  312. $i++;
  313. }
  314. if($i==1) {
  315. ?>
  316. <li class="info_no" style="width: 100%;text-align: center; ">
  317. <dl class="inner">
  318. <dt>등록된 정보가 없습니다.</dt>
  319. </dl>
  320. </li>
  321. <?php
  322. }
  323. ?>
  324. </ul>
  325. </div>
  326. </section>
  327. <section>
  328. <div class="car--list--wrap vertical--type">
  329. <div class="title--wrapper">
  330. <h2>입찰중 차량</h2>
  331. <button type="button" class="more--btn" onclick="link('prepare_list.php')">more+</button>
  332. </div>
  333. <ul>
  334. <?php
  335. $sql1 = $sql." and s.ds_status in ('E0') and t.cd_sale is not null ";
  336. //2023-10-24 1개 매물에 부관리자가 여러명 입찰시 메인관리자는 매물이 2개가 나와 쿼리문 수정
  337. // "SELECT
  338. // a.*
  339. // , b.nm_model
  340. // , d.nm_brand
  341. // , getCode('car_master','ds_type',a.ds_type) as nm_type
  342. // , getCode('car_master','ds_open',a.ds_open) as nm_open
  343. // , getCode('car_master','ds_sales',a.ds_sales) as nm_sales
  344. // , getCode('car_master','ds_transmission',a.ds_transmission) as nm_transmission
  345. // , getCode('member_master','ds_area',s.ds_area) as nm_area
  346. // , getCode('sale_master','ds_status',s.ds_status) as nm_status
  347. // , s.cd_sale
  348. // , s.nm_name nm_name_sale
  349. // , s.ds_status ds_status_sale
  350. // , case when s.ds_status in ('B0','C0') then '미승인' when s.ds_status in ('D0') then '반려' when s.ds_status in ('E0','F0') then '입찰중' when s.ds_status in ('G0') then '입찰마감' when s.ds_status in ('Z0') then '낙찰' when s.ds_status in ('ZS') then '구매확정' else '' end as nm_status_sale
  351. // , case when a.nm_act_yn in ('Y') then '유' else '무' end as nm_act_yn_name
  352. // , getRemainTime(".LIMIT_TIME_TENDER.", s.dt_approve, now()) as time_limit_tender
  353. // FROM sale_master s
  354. // inner join car_master a on (s.cd_car = a.cd_car)
  355. // left outer join tender_master t on (s.cd_sale = t.cd_sale $sql_ds_type )
  356. // left outer join car_model b on (a.cd_model = b.cd_model)
  357. // left outer join car_brand d on (a.cd_brand = d.cd_brand)
  358. // $sql1 $orderby LIMIT $pagestartpoint,$PageSize"
  359. $r = mysql_query("SELECT
  360. a.*
  361. , b.nm_model
  362. , d.nm_brand
  363. , getCode('car_master','ds_type',a.ds_type) as nm_type
  364. , getCode('car_master','ds_open',a.ds_open) as nm_open
  365. , getCode('car_master','ds_sales',a.ds_sales) as nm_sales
  366. , getCode('car_master','ds_transmission',a.ds_transmission) as nm_transmission
  367. , getCode('member_master','ds_area',s.ds_area) as nm_area
  368. , getCode('sale_master','ds_status',s.ds_status) as nm_status
  369. , s.cd_sale
  370. , s.nm_name nm_name_sale
  371. , s.ds_status ds_status_sale
  372. , case when s.ds_status in ('B0','C0') then '미승인' when s.ds_status in ('D0') then '반려' when s.ds_status in ('E0','F0') then '입찰중' when s.ds_status in ('G0') then '입찰마감' when s.ds_status in ('Z0') then '낙찰' when s.ds_status in ('ZS') then '구매확정' else '' end as nm_status_sale
  373. , case when a.nm_act_yn in ('Y') then '유' else '무' end as nm_act_yn_name
  374. , getRemainTime(".LIMIT_TIME_TENDER.", s.dt_approve, now()) as time_limit_tender
  375. FROM sale_master s
  376. inner join car_master a on (s.cd_car = a.cd_car)
  377. left outer join (
  378. SELECT * from tender_master tm
  379. where ds_delind = 'N'
  380. $sql_ds_type
  381. group by cd_sale
  382. ) t on ( s.cd_sale = t.cd_sale )
  383. left outer join car_model b on (a.cd_model = b.cd_model)
  384. left outer join car_brand d on (a.cd_brand = d.cd_brand)
  385. $sql1 $orderby LIMIT $pagestartpoint,$PageSize");
  386. if($_SERVER['REMOTE_ADDR'] == '220.86.24.199') {
  387. }
  388. $i=1;
  389. while($col = mysql_fetch_array($r)) {
  390. $car_image = getCarBasicThumbImage($col['cd_car'], $col['nm_file_front'], '차량전면', false, 'car_basic');
  391. // $car_image = "/images/common/bg_no_photo.png";
  392. // if(file_exists($_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR."nm_file_main/ratio/".$col['nm_file_front'])) {
  393. // $car_image = UPLOAD_PATH_CAR."nm_file_main/ratio/".$col['nm_file_front'];
  394. // }
  395. ?>
  396. <li class="">
  397. <div class="car--box--wrap ">
  398. <div class="thumb--wrap">
  399. <?=$car_image?>
  400. </div>
  401. <div>
  402. <div class="car--info">
  403. <h2 class="car--name"><?=$col['nm_brand']." ".$col['nm_model']?></h2>
  404. <dl>
  405. <dt>주행거리 : </dt>
  406. <dd><?=number_format($col['nm_mileage'])?>km</dd>
  407. </dl>
  408. <dl>
  409. <dt>최초 등록일 : </dt>
  410. <dd><?=$col['nm_regdate_mm']?> / <?=$col['nm_regdate_yyyy']?></dd>
  411. </dl>
  412. <dl>
  413. <dt>사고유무 : </dt>
  414. <dd><?=$col['nm_act_yn_name']?></dd>
  415. </dl>
  416. <dl>
  417. <dt>판매지역 : </dt>
  418. <dd><?=$col['nm_area']?></dd>
  419. </dl>
  420. </div>
  421. <div class="status--wrap">
  422. <span><?=$col['nm_status_sale']?></span>
  423. </div>
  424. <div class="btn--wrapper hide">
  425. <button type="button" onclick="link('prepare_view.php?cd_sale=<?=$col['cd_sale']?>')">자동차 보러가기<i class="arrow--ic"></i></button>
  426. </div>
  427. </div>
  428. </div>
  429. </li>
  430. <?php
  431. $i++;
  432. }
  433. if($i==1) {
  434. ?>
  435. <li class="info_no" style="width: 100%;text-align: center; ">
  436. <dl class="inner">
  437. <dt>등록된 정보가 없습니다.</dt>
  438. </dl>
  439. </li>
  440. <?php
  441. }
  442. ?>
  443. </ul>
  444. </div>
  445. </section>
  446. </main>
  447. <!-- <main class="pb-5">
  448. <section>
  449. <div class="main--visual">
  450. <div class="main--visual--title--wrap">
  451. <h2>이차조아 소개 카피라이터 부분입니다</h2>
  452. <p>
  453. 아치조아 소개글 상세 내용입니다. 아치조아 소개글 상세 내용입니다.<br />아치조아 소개글 상세 내용입니다. 아치조아 소개글 상세 내용입니다.
  454. </p>
  455. <div class="main--visual--contents">
  456. <div class="box--01">
  457. <h2>거래중</h2>
  458. <div>13</div>
  459. </div>
  460. <div class="box--02">
  461. <h2>판매완료</h2>
  462. <div>13</div>
  463. </div>
  464. <div class="car--find">
  465. <div>
  466. <h2>소유주명</h2>
  467. <div> <input type="text" class="form-control proprietor" id=""></div>
  468. </div>
  469. <div>
  470. <h2>차량 번호</h2>
  471. <div><input type="text" class="form-control carnumber" id=""></div>
  472. </div>
  473. <button class="car--find--btn">차량조회<i class="zoom--icon"></i></button>
  474. </div>
  475. </div>
  476. </div>
  477. </div>
  478. </section>
  479. <section>
  480. <div class="car--list--wrap">
  481. <div class="title--wrapper">
  482. <h2>입찰 대기중 차량</h2>
  483. <button class="more--btn">more+</button>
  484. </div>
  485. <ul>
  486. <li class="">
  487. <div class="car--box--wrap ">
  488. <h2 class="car--name">GLA-Class 200d 4M</h2>
  489. <div class="thumb--wrap">
  490. <img src="/design/staff/assets/img/samp.png" />
  491. </div>
  492. <div class="car--info">
  493. <dl>
  494. <dt>주행거리 : </dt>
  495. <dd>28,980km</dd>
  496. </dl>
  497. <dl>
  498. <dt>최초 등록일 : </dt>
  499. <dd>11 / 2017</dd>
  500. </dl>
  501. <dl>
  502. <dt>사고유무 : </dt>
  503. <dd>무</dd>
  504. </dl>
  505. <dl>
  506. <dt>판매지역 : </dt>
  507. <dd>서울</dd>
  508. </dl>
  509. </div>
  510. <div class="status--wrap">
  511. <span>반려</span>
  512. </div>
  513. </div>
  514. </li>
  515. <li>
  516. <div class="car--box--wrap on">
  517. <h2 class="car--name">GLA-Class 200d 4M</h2>
  518. <div class="thumb--wrap">
  519. <img src="/design/staff/assets/img/samp.png" />
  520. </div>
  521. <div class="car--info">
  522. <dl>
  523. <dt>주행거리 : </dt>
  524. <dd>28,980km</dd>
  525. </dl>
  526. <dl>
  527. <dt>최초 등록일 : </dt>
  528. <dd>11 / 2017</dd>
  529. </dl>
  530. <dl>
  531. <dt>사고유무 : </dt>
  532. <dd>무</dd>
  533. </dl>
  534. <dl>
  535. <dt>판매지역 : </dt>
  536. <dd>서울</dd>
  537. </dl>
  538. </div>
  539. <div class="btn--wrapper">
  540. <button type="button">자동차 보러가기<i class="arrow--ic"></i></button>
  541. </div>
  542. </div>
  543. </li>
  544. <li>
  545. <div class="car--box--wrap">
  546. <h2 class="car--name">GLA-Class 200d 4M</h2>
  547. <div class="thumb--wrap">
  548. <img src="/design/staff/assets/img/samp.png" />
  549. </div>
  550. <div class="car--info">
  551. <dl>
  552. <dt>주행거리 : </dt>
  553. <dd>28,980km</dd>
  554. </dl>
  555. <dl>
  556. <dt>최초 등록일 : </dt>
  557. <dd>11 / 2017</dd>
  558. </dl>
  559. <dl>
  560. <dt>사고유무 : </dt>
  561. <dd>무</dd>
  562. </dl>
  563. <dl>
  564. <dt>판매지역 : </dt>
  565. <dd>서울</dd>
  566. </dl>
  567. </div>
  568. <div class="status--wrap">
  569. <span class="ready">대기중</span>
  570. </div>
  571. </div>
  572. </li>
  573. <li>
  574. <div class="car--box--wrap">
  575. <h2 class="car--name">GLA-Class 200d 4M</h2>
  576. <div class="thumb--wrap">
  577. <img src="/design/staff/assets/img/samp.png" />
  578. </div>
  579. <div class="car--info">
  580. <dl>
  581. <dt>주행거리 : </dt>
  582. <dd>28,980km</dd>
  583. </dl>
  584. <dl>
  585. <dt>최초 등록일 : </dt>
  586. <dd>11 / 2017</dd>
  587. </dl>
  588. <dl>
  589. <dt>사고유무 : </dt>
  590. <dd>무</dd>
  591. </dl>
  592. <dl>
  593. <dt>판매지역 : </dt>
  594. <dd>서울</dd>
  595. </dl>
  596. </div>
  597. <div class="status--wrap">
  598. <span class="ready">대기중</span>
  599. </div>
  600. </div>
  601. </li>
  602. </ul>
  603. </div>
  604. </section>
  605. <section>
  606. <div class="car--list--wrap vertical--type">
  607. <div class="title--wrapper">
  608. <h2>입찰중 차량</h2>
  609. <button class="more--btn">more+</button>
  610. </div>
  611. <ul>
  612. <li class="">
  613. <div class="car--box--wrap ">
  614. <div class="thumb--wrap">
  615. <img src="/design/staff/assets/img/samp.png" />
  616. </div>
  617. <div>
  618. <div class="car--info">
  619. <h2 class="car--name">GLA-Class 200d 4M</h2>
  620. <dl>
  621. <dt>주행거리 : </dt>
  622. <dd>28,980km</dd>
  623. </dl>
  624. <dl>
  625. <dt>최초 등록일 : </dt>
  626. <dd>11 / 2017</dd>
  627. </dl>
  628. <dl>
  629. <dt>사고유무 : </dt>
  630. <dd>무</dd>
  631. </dl>
  632. <dl>
  633. <dt>판매지역 : </dt>
  634. <dd>서울</dd>
  635. </dl>
  636. </div>
  637. <div class="status--wrap">
  638. <span>반려</span>
  639. </div>
  640. </div>
  641. </div>
  642. </li>
  643. <li class="">
  644. <div class="car--box--wrap ">
  645. <div class="thumb--wrap">
  646. <img src="/design/staff/assets/img/samp.png" />
  647. </div>
  648. <div>
  649. <div class="car--info">
  650. <h2 class="car--name">GLA-Class 200d 4M</h2>
  651. <dl>
  652. <dt>주행거리 : </dt>
  653. <dd>28,980km</dd>
  654. </dl>
  655. <dl>
  656. <dt>최초 등록일 : </dt>
  657. <dd>11 / 2017</dd>
  658. </dl>
  659. <dl>
  660. <dt>사고유무 : </dt>
  661. <dd>무</dd>
  662. </dl>
  663. <dl>
  664. <dt>판매지역 : </dt>
  665. <dd>서울</dd>
  666. </dl>
  667. </div>
  668. <div class="status--wrap">
  669. <span>반려</span>
  670. </div>
  671. </div>
  672. </div>
  673. </li>
  674. <li class="">
  675. <div class="car--box--wrap ">
  676. <div class="thumb--wrap">
  677. <img src="/design/staff/assets/img/samp.png" />
  678. </div>
  679. <div>
  680. <div class="car--info">
  681. <h2 class="car--name">GLA-Class 200d 4M</h2>
  682. <dl>
  683. <dt>주행거리 : </dt>
  684. <dd>28,980km</dd>
  685. </dl>
  686. <dl>
  687. <dt>최초 등록일 : </dt>
  688. <dd>11 / 2017</dd>
  689. </dl>
  690. <dl>
  691. <dt>사고유무 : </dt>
  692. <dd>무</dd>
  693. </dl>
  694. <dl>
  695. <dt>판매지역 : </dt>
  696. <dd>서울</dd>
  697. </dl>
  698. </div>
  699. <div class="status--wrap">
  700. <span>반려</span>
  701. </div>
  702. </div>
  703. </div>
  704. </li>
  705. <li class="">
  706. <div class="car--box--wrap ">
  707. <div class="thumb--wrap">
  708. <img src="/design/staff/assets/img/samp.png" />
  709. </div>
  710. <div>
  711. <div class="car--info">
  712. <h2 class="car--name">GLA-Class 200d 4M</h2>
  713. <dl>
  714. <dt>주행거리 : </dt>
  715. <dd>28,980km</dd>
  716. </dl>
  717. <dl>
  718. <dt>최초 등록일 : </dt>
  719. <dd>11 / 2017</dd>
  720. </dl>
  721. <dl>
  722. <dt>사고유무 : </dt>
  723. <dd>무</dd>
  724. </dl>
  725. <dl>
  726. <dt>판매지역 : </dt>
  727. <dd>서울</dd>
  728. </dl>
  729. </div>
  730. <div class="status--wrap">
  731. <span>반려</span>
  732. </div>
  733. </div>
  734. </div>
  735. </li>
  736. </ul>
  737. </div>
  738. </section>
  739. </main> -->
  740. <script>
  741. $(function() {
  742. $(".car--list--wrap li").hover(function() {
  743. $(this).find(".car--box--wrap").addClass("on");
  744. $(this).find(".status--wrap").addClass("hide");
  745. $(this).find(".btn--wrapper").removeClass("hide");
  746. }, function() {
  747. $(this).find(".car--box--wrap").removeClass("on");
  748. $(this).find(".status--wrap").removeClass("hide");
  749. $(this).find(".btn--wrapper").addClass("hide");
  750. });
  751. })
  752. </script>
  753. <?php include("include/footer.php") ?>