판매완료 리스트
| 번호 |
판매자 |
차종 |
차량번호 |
판매지역 |
판매완료 금액(낙찰금액) |
등록증 |
성능지 |
등록일 |
판매완료일 |
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.nm_price_final nm_price_final_sale
// , s.nm_recommend nm_recommend_sale
// , s.ds_status ds_status_sale
// , s.ds_status_contract ds_status_contract_sale
// , s.nm_file_trading ds_nm_file_trading
// , s.nm_file_performance ds_nm_file_performance
// , s.dt_update dt_update_sale
// , s.dt_insert dt_insert_sale
// 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");
$sql = "SELECT *
, getCode('car_master','ds_type',ds_type) as nm_type
, getCode('car_master','ds_open',ds_open) as nm_open
, getCode('car_master','ds_sales',ds_sales) as nm_sales
, getCode('car_master','ds_transmission',ds_transmission) as nm_transmission
, getCode('member_master','ds_area',ds_area_sale) as nm_area
, getCode('sale_master','ds_status',ds_status_sale) as nm_status
FROM (
SELECT
a.*
, b.nm_model
, c.nm_grade
, d.nm_brand
, e.nm_model_sub
, s.cd_sale
, s.nm_name nm_name_sale
, s.nm_recommend nm_recommend_sale
, s.ds_status ds_status_sale
, s.ds_status_contract ds_status_contract_sale
, s.ds_area ds_area_sale
, s.dt_update dt_update_sale
, s.dt_insert dt_insert_sale
, s.dt_success
, s.dt_end dt_end_sale
, s.nm_price nm_price_sale
, s.nm_price_final nm_price_final_sale
, s.nm_file_trading ds_nm_file_trading
, s.nm_file_performance ds_nm_file_performance
, t.nm_price as nm_price_tender
, t.nm_commission as nm_commission_tender
FROM sale_master s
inner join car_master a on (s.cd_car = a.cd_car)
inner join tender_master t on (t.cd_sale = s.cd_sale AND t.ds_delind = 'N' AND t.ds_status = 'Z0')
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)
$add_sql $orderby LIMIT $pagestartpoint,$PageSize
) as car
";
if($_SERVER['REMOTE_ADDR'] == '220.86.24.199') {
// echo $sql;
}
$r = mysql_query($sql);
$i=1;
while($col = mysql_fetch_array($r)) {
$tmpNum =$totalrows-($PageSize*($PageNo-1));
$no = ($tmpNum - $i)+1;
$nm_file_trading = "X";
if(!empty($col['ds_nm_file_trading'])){
$nm_file_trading = "O";
}
$nm_file_performance = "X";
if(!empty($col['ds_nm_file_performance'])){
$nm_file_performance = "O";
}
// $nm_price = number_format($col['nm_price_final_sale'])."만원(".number_format($col['nm_price_tender'])."만원)";
//2023-11-12 변경 요청
$nm_price = number_format($col['nm_price_final_sale'])."만원,낙찰금액(".number_format($col['nm_price_tender'])."만원, 수수료 ".number_format($col['nm_commission_tender'])."만원)";
?>
|
|
|
|
|
|
|
|
|
|
| 등록된 정보가 없습니다. |