거래중
이차조아에서는 사고 이력 조회 후 최고가 내차를 판매할 수 있습니다.
-
0) {
$sql = "SELECT
a.*
, b.nm_model
, c.nm_grade
, d.nm_brand
, e.nm_model_sub
, getCode('car_master','ds_type',a.ds_type) as nm_type
, getCode('car_master','ds_open',a.ds_open) as nm_open
, getCode('car_master','ds_sales',a.ds_sales) as nm_sales
, getCode('car_master','ds_transmission',a.ds_transmission) as nm_transmission
, getCode('member_master','ds_area',s.ds_area) as nm_area
, getCode('sale_master','ds_status',s.ds_status) as nm_status
, s.cd_sale
, s.nm_name nm_name_sale
, s.ds_status ds_status_sale
, s.ds_aap_status ds_aap_status_sale
, case when s.ds_status in ('B0','C0') then '미승인' when s.ds_status in ('D0') then '반려' when s.ds_status in ('E0','F0') then case when s.ds_status = 'E0' then '입찰대기' else '입찰중' end 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
-- , case when a.ds_accident in ('A0') then '유' when a.ds_accident in ('B0') then '무' end as nm_act_yn_name
, getCode('car_master','ds_accident',a.ds_accident) as nm_act_yn_name
-- , getRemainTime(".LIMIT_TIME_TENDER.", s.dt_approve, now()) as time_limit_tender
, getRemainTime(".LIMIT_TIME_SELL.", s.dt_approve, now()) as time_limit_sell
, getRemainTime(s.ds_auction_time, s.dt_approve, now()) as time_limit_tender
, ifnull((select min(nm_price) from tender_master where ds_delind = 'N' and cd_sale = s.cd_sale ".$sql_ds_type."), '') nm_price_tender
FROM sale_master s
inner join car_master a on (s.cd_car = a.cd_car)
left outer join car_model b on (a.cd_model = b.cd_model)
left outer join car_grade c on (a.cd_grade = c.cd_grade)
left outer join car_brand d on (a.cd_brand = d.cd_brand)
left outer join car_model_sub e on (a.cd_model_sub = e.cd_model_sub)
$sql_from
$add_sql $orderby LIMIT $pagestartpoint,$PageSize";
// echo $sql;
$r = mysql_query($sql);
$i=1;
while($col = mysql_fetch_array($r)) {
$tmpNum =$totalrows-($PageSize*($PageNo-1));
$no = ($tmpNum - $i)+1;
// $car_image = "/images/common/bg_no_photo.png";
// if(file_exists($_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR."nm_file_main/ratio/".$col['nm_file_front'])) {
// $car_image = UPLOAD_PATH_CAR."nm_file_main/ratio/".$col['nm_file_front'];
// }
$car_image = getCarBasicThumbImage($col['cd_car'], $col['nm_file_front'], '차량전면', false, 'car_basic');
?>
-
- 주행거리 :
- km
- 최초 등록일 :
- /
- 사고유무 :
- 판매지역 :
거래중 -
등록된 정보가 없습니다.