0) { //ds_status E0의 매물 갯수가 많으면 10초 걸려서 쿼리 튜닝 // $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_recommend nm_recommend_sale // , s.ds_status ds_status_sale // , s.ds_status_contract ds_status_contract_sale // , getRemainTimeByPhase(".LIMIT_TIME_TENDER.", ".LIMIT_TIME_SELL.", s.dt_approve, now()) as time_limit_sell // , 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 -- , getRemainTimeByPhase(".LIMIT_TIME_TENDER.", ".LIMIT_TIME_SELL.", dt_approve_sale, now()) as time_limit_sell -- , getRemainTimeByPhase(ds_auction_time, ".LIMIT_TIME_SELL.", dt_approve_sale, now()) as time_limit_sell , getRemainTimeByPhase(ds_auction_time, ds_auction_time, dt_approve_sale, now()) as time_limit_sell FROM ( SELECT a.* , b.nm_model , d.nm_brand , 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_approve dt_approve_sale , s.dt_update dt_update_sale , s.dt_insert dt_insert_sale , s.ds_auction_time , sa.nm_name sa_nm_name 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_brand d on (a.cd_brand = d.cd_brand) left outer join sa_master sa on (s.nm_name = sa.nm_name) $add_sql $orderby LIMIT $pagestartpoint,$PageSize ) as car"; if($_SERVER['REMOTE_ADDR'] == '220.86.24.199') { // echo $sql; // exit; } // echo $sql; $r = mysql_query($sql); if($_SERVER['REMOTE_ADDR'] == '106.251.80.237') { // $is_staff = $col['is_staff']; // // $sa = array(); // if($is_staff == 'Y') { // $sa_sql ="SELECT * FROM sa_master "; // $sa = mysql_fetch_array(mysql_query($sa_sql)); // } // echo var_dump($sa); } $i=1; while($col = mysql_fetch_array($r)) { $tmpNum =$totalrows-($PageSize*($PageNo-1)); $no = ($tmpNum - $i)+1; if($_SERVER['REMOTE_ADDR'] == '106.251.80.237') { // var_dump($col); } ?> ' uri='./buy_view.php?list_url=&cd_sale=&ds_status_sale=&ds_status_contract_sale=&ListPageNo=' _onclick="location.href=;" style="cursor:pointer;">

No	판매자	차종	차량번호	주행거리	색상	판매지역	판매시간	등록일	초기화	내역초기화
				km					입찰시간 초기화	입찰시간 및 내역 초기화
등록된 정보가 없습니다.