main.test.php 29 KB

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