//유프로직원일 경우에만 아래 메뉴 출력
// /common/lib/func.php 1662에 정의됨
$buy_menu = "05"; //메뉴 active 용
$is_upro_member = getUproMember($_SESSION['s_cd_user']);
if($is_upro_member) {
include_once($_SERVER['DOCUMENT_ROOT']."/m/mypage/inc_menu_member_company.php");
}
?>
거래완료
년
월
if($totalrows>0) {
$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
, s.nm_contract_date nm_contract_date_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') and s.ds_status_contract in ('B0') then '거래연기' when s.ds_status in ('Z0') and s.ds_status_contract in ('C0') then '거래실패' when s.ds_status in ('Z0') then '낙찰' when s.ds_status in ('ZE') 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_SELL.", s.dt_approve, now()) as time_limit_sell
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)) {
$tmpNum =$totalrows-($PageSize*($PageNo-1));
$no = ($tmpNum - $i)+1;
?>
- sell_view2.php }else{ ?>sell_view.php } ?>?list_url==$list_url?>&cd_sale==$col[cd_sale]?>&ds_status_sale==$col[ds_status_sale]?>&ListPageNo==$PageNo?>&nm_contract_date_year==$nm_contract_date_year?>&nm_contract_date_month==$nm_contract_date_month?>';" style="cursor:pointer;">
- =$col[nm_brand]." ".$col[nm_model]?>
- 차량번호 : =$col[nm_number]?>
- 주행거리 : =$col[nm_mileage]?>km
- 년식 : =$col[ds_year]?>년
- 사고유무 : =$col[nm_act_yn_name]?>
- 판매지역 : =$col[nm_area]?>
- 거래완료일 : =$col[nm_contract_date_sale]?>
if($col[time_limit_sell]=="0분" && ($col[ds_status_sale] == "E0" || $col[ds_status_sale] == "F0")){ ?>
거래마감
}else{ ?>
=$col[nm_status_sale]?>
} ?>
$i++;
}
}else{
?>
-
등록된 정보가 없습니다.
}
?>
$url = "./sell_list_03.php?searchtype=$searchtype&searchword=$searchword&ds_status=$ds_status&ds_usertype=$ds_usertype&nm_contract_date_year=$nm_contract_date_year&nm_contract_date_month=$nm_contract_date_month";
ListPg1($url ,$PageNo,$PageSize,10,$totalrows,$leftboard[1],$rootpath);
?>