= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_TENDER."' HOUR) "; $add_sql.= " AND s.dt_approve >= DATE_ADD(now(), INTERVAL concat('-', s.ds_auction_time) HOUR) "; //딜러 if($s_aap_ds_type == "D0"){ $sql_ds_type = " AND cd_dealer_p = '$s_cd_dealer' "; } //딜러-관리자 else{ $sql_ds_type = " AND cd_dealer = '$s_cd_dealer' "; } if($searchword != ""){ if($searchtype=="" || $searchtype==null){ $add_sql.= " AND (s.nm_name like '$searchword%' or a.nm_number like '$searchword%') "; }else{ $add_sql.= " AND $searchtype like '$searchword%'"; } } if($ds_usertype != ""){ $add_sql.= " AND s.ds_usertype = '$ds_usertype'"; } $add_sql.= " AND s.ds_status in ('E0','F0')"; // AND ds_aap_status = 'E0' //딜러 업체 소속 입찰 건이 2건 보다 작을 시만 입찰 요청 건에 보이게 한다. // $sql_from = $sql_from. " left outer join ( "; // $sql_from = $sql_from. " select cd_sale from tender_master where ds_delind = 'N' and cd_dealer_p = '$s_cd_dealer_p' group by cd_sale having count(*) > 0) f "; // $sql_from = $sql_from. " on (s.cd_sale = f.cd_sale) "; // $add_sql.= " and f.cd_sale is null "; //딜러 업체 소속 입찰 건이 2건 보다 작을 시만 입찰 요청 건에 보이게 한다. if($s_aap_ds_type == "D1"){ //딜러-관리자 //본인 입찰 건 제외한 입찰 건 $sql_from = $sql_from. " left outer join ( "; $sql_from = $sql_from. " select cd_sale from tender_master where ds_delind = 'N' and cd_dealer = '$s_cd_dealer' group by cd_sale) g "; $sql_from = $sql_from. " on (s.cd_sale = g.cd_sale) "; $add_sql.= " AND g.cd_sale is null "; //본인 입찰 건 제외한 입찰 건 } // $sql_from = $sql_from. " inner join aap_sale_master u on s.cd_sale = u.cd_sale and u.cd_dealer = '$s_cd_dealer' "; if(!empty($search_text) && !empty($search_type)) { $add_sql.= " AND $search_type like '$search_text%' "; } $sql = "SELECT count(*) 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_brand d on (a.cd_brand = d.cd_brand) $sql_from $add_sql"; // echo $sql; // exit; $totalrows = @mysql_result(mysql_query($sql),0,0); // if($_SERVER['REMOTE_ADDR'] == '220.86.24.199') { // echo $sql; // exit; // } ?>

입찰대기

이차조아에서는 사고 이력 조회 후 최고가 내차를 판매할 수 있습니다.

입찰대기 입찰대기

    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
    최초 등록일 :
    /
    사고유무 :
    판매지역 :
  • 등록된 정보가 없습니다.