// /common/lib/func.php 1662에 정의됨
$is_upro_member = getUproMember($_SESSION['s_cd_user']);
$depth_info = array("NAME" => array("입찰정보", "거래완료"));
if($is_upro_member) {
include_once($_SERVER['DOCUMENT_ROOT']."/mypage/inc_menu_member_company.php");
}else {
include_once($_SERVER['DOCUMENT_ROOT']."/mypage/inc_menu_main_member.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;">
| =$no?> |
=$col[nm_brand]." ".$col[nm_model]?> |
=$col[nm_number]?> |
=$col[ds_year]?>년 |
=$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.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);
?>