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 car.* , 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 , f.ds_complete_depth ds_complete_depth , f.cd_tender cd_tender , f.ds_underway_depth ds_underway_depth , f.ds_lock_status ds_lock_status , f.nm_name nm_name_tender , f.nm_hp nm_tender_hp 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) LEFT OUTER JOIN tender_master f ON (s.cd_sale = f.cd_sale AND f.ds_status = 'Z0' AND f.ds_delind = 'N') $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'])."만원)"; ?>

번호	판매자	차종	차량번호	판매지역	판매완료 금액(낙찰금액)	등록증	성능지	등록일	판매완료일
등록된 정보가 없습니다.