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.ds_status_contract_step1 ds_status_contract_step1_sale // , s.ds_status_contract_step2 ds_status_contract_step2_sale // , s.ds_status_contract_step3 ds_status_contract_step3_sale // , s.ds_status_contract_step4 ds_status_contract_step4_sale // , f.ds_underway_depth ds_underway_depth // , f.cd_tender cd_tender // , f.ds_lock_status ds_lock_status // , 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) // left outer join tender_master f on (s.cd_sale = f.cd_sale and f.ds_status = 'Z0' and f.ds_delind = 'N') // $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 dt_success_sale , s.nm_price nm_price_sale , s.nm_price_final nm_price_final_sale , s.ds_status_contract_step1 ds_status_contract_step1_sale , s.ds_status_contract_step2 ds_status_contract_step2_sale , s.ds_status_contract_step3 ds_status_contract_step3_sale , s.ds_status_contract_step4 ds_status_contract_step4_sale , 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 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) 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 "; $r = mysql_query($sql); $i=1; while($col = mysql_fetch_array($r)) { $tmpNum =$totalrows-($PageSize*($PageNo-1)); $no = ($tmpNum - $i)+1; //단계 추가 $step = ""; if($col['ds_status_contract_step4_sale'] == "Y") { $step = "거래마무리"; }else if($col['ds_status_contract_step3_sale'] == "Y") { $step = "계약상황"; }else if($col['ds_status_contract_step2_sale'] == "Y") { $step = "일정잡기"; }else if($col['ds_status_contract_step1_sale'] == "Y") { $step = "차량정보확인"; } //SMS 상태 $sms_class = ""; $clear_btn = ""; $ds_underway_depth = ""; switch($col['ds_underway_depth']) { case '0': $sms_class = "sms_send"; //미발송일 경우에만 클래스 지정으로 발송할 수 있게 처리 $ds_underway_depth = "미발송"; break; case '1': case '2': case '3': $ds_underway_depth = $col['ds_underway_depth']."단계"; break; } if($col['ds_underway_depth'] == 3 && $col['ds_lock_status'] == 'A0') { $sms_class = "sms_unlock"; $clear_btn = ""; } ?> ' cd_tender='' uri='./buy_view.php?list_url=&cd_sale=&ds_status_sale=&ds_status_contract_sale=&ds_status_contract_step1_sale=&ListPageNo=' _onclick="location.href=;" style="cursor:pointer;">

번호	판매자	차종	차량번호	판매지역	단계	등록일	낙찰일	SMS상태
등록된 정보가 없습니다.