회원정보
정보수정| 이름 | |
|---|---|
| 아이디 | |
| 연락처 | |
| 회원가입일 |
입찰내역
+더보기-
= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_SELL."' HOUR) ";
$totalrows = @mysql_result(mysql_query("select count(*) from sale_master s inner join car_master a on ( s.cd_car = a.cd_car ) $sql"),0,0);
$orderby = "order by s.dt_insert desc";
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.nm_price nm_price_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_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 0,2");
$i=1;
while($col = mysql_fetch_array($r)) {
$tmpNum =$totalrows-($PageSize*($PageNo-1));
$no = ($tmpNum - $i)+1;
?>
-
차종
년식 년
지역
판매일 2018.01.23
처리상태 거래마감
-
등록된 정보가 없습니다.
문의내역
+더보기-
0) {
$r = mysql_query("SELECT * FROM board_master $sql ORDER BY ds_top desc, no_famally ASC, no_order ASC LIMIT 0,2");
$i=1;
while($col = mysql_fetch_array($r)) {
$date = strtotime ($col[dt_insert]);
$view_date = strtotime ("-1 day",time());
if($date >= $view_date) {
$newicon = "
- 등록된 정보가 없습니다.
![](".ADMIN_PATH."img/i_new.gif)
";
} else {
$newicon = "";
}
if($col[no_step]>0){
$padding = $col[no_step] * 8;
$step = "";
}
$tmpNum =$totalrows-($PageSize*($PageNo-1));
$no = ($tmpNum - $i)+1;
?>