마이페이지

쉽고 간편한 내차팔기, 견적산출, 최종 매각까지 어떤 수수료도 요구하지 않습니다.

레이어팝업 닫기

입찰요청 리스트

+더보기
= numbers . n-1 where cd_dealer = $s_cd_dealer_p ) "; $sql = $sql. " and s.ds_status in ('E0','F0')"; $sql = $sql. " and s.dt_approve >= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_TENDER."' HOUR) "; $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건 보다 작을 시만 입찰 요청 건에 보이게 한다. if($s_ds_type == "D1"){ //딜러-관리자 $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)"; //본인 입찰 건 제외한 입찰 건 } $r = mysql_query("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 , 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 , case when a.nm_act_yn in ('Y') then '유' else '무' end as nm_act_yn_name , getRemainTime(".LIMIT_TIME_TENDER.", s.dt_approve, now()) as time_limit_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 $orderby LIMIT $pagestartpoint,$PageSize"); $i=1; while($col = mysql_fetch_array($r)) { ?>
번호 판매자 지역 차종 주행거리 년식 등록일 입찰 마감시간
km

입찰중 리스트

+더보기
= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_SELL."' HOUR) "; $sql = $sql. " and s.cd_sale in (select cd_sale from tender_master where ds_delind = 'N' ".$sql_ds_type." group by cd_sale)"; $r = mysql_query("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 , 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 , case when a.nm_act_yn in ('Y') then '유' else '무' end as nm_act_yn_name 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 $orderby LIMIT $pagestartpoint,$PageSize"); $i=1; while($col = mysql_fetch_array($r)) { ?>
번호 판매자 지역 차종 주행거리 년식 등록일 상태
km

공지사항

+더보기
0) { $r = mysql_query("SELECT * FROM board_master $sql ORDER BY ds_top desc, no_famally ASC, no_order ASC LIMIT $pagestartpoint,$PageSize"); $i=1; while($col = mysql_fetch_array($r)) { $date = strtotime ($col[dt_insert]); $view_date = strtotime ("-1 day",time()); if($date >= $view_date) { $newicon = " "; } else { $newicon = ""; } if($col[no_step]>0){ $padding = $col[no_step] * 8; $step = ""; } $tmpNum =$totalrows-($PageSize*($PageNo-1)); $no = ($tmpNum - $i)+1; ?>
번호 제목 등록일
등록된 정보가 없습니다.