$s_cd_dealer = $_SESSION['s_cd_dealer']; $s_cd_dealer_p = $_SESSION['s_cd_dealer_p']; $s_ds_type = $_SESSION['s_ds_type']; if($s_ds_type == "D0"){ //딜러 $sql1 = " cd_dealer_p = '$s_cd_dealer' "; }else{ //딜러-관리자 $sql1 = " cd_dealer = '$s_cd_dealer' "; } // $cd_sale = $_REQUEST["cd_sale"]; // // $sql ="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_year',a.ds_year) as nm_year // , 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('car_master','ds_oil',a.ds_oil) as nm_oil // , getCode('car_master','ds_accident',a.ds_accident) as nm_accident // , getCode('sale_master','ds_usertype',s.ds_usertype) as nm_usertype // , getCode('member_master','ds_area',s.ds_area) as nm_area // , getCode('sale_master','ds_status',s.ds_status) as nm_status // , s.nm_name nm_name_sale // , s.ds_status ds_status_sale // , s.nm_hp nm_hp_sale // , s.nm_email nm_email_sale // , s.ds_area ds_area_sale // , s.nm_price nm_price_sale // , s.nm_price_final nm_price_final_sale // , s.nm_recommend nm_recommend_sale // , s.nm_cont_return nm_cont_return_sale // , s.nm_cont_tender_error nm_cont_tender_error_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 // , s.nm_contract_date nm_contract_date_sale // , s.nm_contract_cont_final nm_contract_cont_final_sale // , s.nm_contract_fail_reason nm_contract_fail_reason_sale // , s.nm_file_chk1 nm_file_chk1_sale // , s.nm_file_chk2 nm_file_chk2_sale // , s.nm_file_chk3 nm_file_chk3_sale // , s.nm_file_chk4 nm_file_chk4_sale // , s.nm_file_chk5 nm_file_chk5_sale // , s.nm_file_trading nm_file_trading_sale // , s.nm_file_performance nm_file_performance_sale // , s.nm_file_postscript nm_file_postscript_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) // WHERE s.cd_sale='$cd_sale' "; // // $col=mysql_fetch_array(mysql_query($sql)); // if (!empty($col['cd_car'])){ // // $cd_car = $col['cd_car']; // $cd_model = $col['cd_model']; // $cd_brand = $col['cd_brand']; // $ds_logo = $col['ds_logo']; // $cd_category = $col['cd_category']; // $cd_grade = $col['cd_grade']; // $ds_cate = $col['ds_cate']; // $ds_type = $col['ds_type']; // $ds_year = $col['ds_year']; // $nm_name = $col['nm_name']; // $nm_price = $col['nm_price']; // $nm_mileage = $col['nm_mileage']; // $ds_driving_system = $col['ds_driving_system']; // $ds_transmission = $col['ds_transmission']; // $nm_file_list = $col['nm_file_list']; // $nm_file_main = $col['nm_file_main']; // $nm_file_report = $col['nm_file_report']; // $nm_file_report_back = $col['nm_file_report_back']; // $nm_file_front = $col['nm_file_front']; // $nm_file_back = $col['nm_file_back']; // $nm_file_side1 = $col['nm_file_side1']; // $nm_file_side2 = $col['nm_file_side2']; // $nm_file_dashboard = $col['nm_file_dashboard']; // $ds_oil = $col['ds_oil']; // $nm_gearbox = $col['nm_gearbox']; // $nm_color = $col['nm_color']; // $nm_incolor = $col['nm_incolor']; // $ds_accident = $col['ds_accident']; // $nm_cont_accident = $col['nm_cont_accident']; // $nm_regdate = $col['nm_regdate']; // $ds_sales = $col['ds_sales']; // $nm_btitle = $col['nm_btitle']; // $nm_stitle = $col['nm_stitle']; // $nm_ltitle = $col['nm_ltitle']; // $nm_cont = $col['nm_cont']; // $nm_guide = $col['nm_guide']; // $ds_open = $col['ds_open']; // $ds_status = $col['ds_status']; // $dt_insert = $col['dt_insert']; // $nm_insert = $col['nm_insert']; // $dt_update = $col['dt_update']; // $nm_update = $col['nm_update']; // $ds_delind = $col['ds_delind']; // $nm_number = $col['nm_number']; // $nm_cc = $col['nm_cc']; // $ds_trade = $col['ds_trade']; // $ds_main = $col['ds_main']; // $nm_regdate_yyyy = $col['nm_regdate_yyyy']; // $nm_regdate_mm = $col['nm_regdate_mm']; // $nm_regdate_dd = $col['nm_regdate_dd']; // // $nm_brand = $col['nm_brand']; // $nm_model = $col['nm_model']; // $nm_model_sub = $col['nm_model_sub']; // $nm_grade = $col['nm_grade']; // // $nm_year = $col['nm_year']; // $nm_type = $col['nm_type']; // $nm_open = $col['nm_open']; // $nm_sales = $col['nm_sales']; // $nm_transmission = $col['nm_transmission']; // $nm_oil = $col['nm_oil']; // $nm_usertype = $col['nm_usertype']; // $nm_accident = $col['nm_accident']; // $nm_area = $col['nm_area']; // $nm_name_sale = $col['nm_name_sale']; // $ds_status_sale = $col['ds_status_sale']; // $nm_hp_sale = $col['nm_hp_sale']; // $nm_email_sale = $col['nm_email_sale']; // $ds_area_sale = $col['ds_area_sale']; // $nm_price_sale = $col['nm_price_sale']; // $nm_price_final_sale = $col['nm_price_final_sale']; // $nm_recommend_sale = $col['nm_recommend_sale']; // $nm_cont_return_sale = $col['nm_cont_return_sale']; // $nm_cont_tender_error_sale = $col['nm_cont_tender_error_sale']; // $ds_status_contract_sale = $col['ds_status_contract_sale']; // $ds_status_contract_step1_sale = $col['ds_status_contract_step1_sale']; // $ds_status_contract_step2_sale = $col['ds_status_contract_step2_sale']; // $ds_status_contract_step3_sale = $col['ds_status_contract_step3_sale']; // $ds_status_contract_step4_sale = $col['ds_status_contract_step4_sale']; // $nm_contract_date_sale = $col['nm_contract_date_sale']; // $nm_contract_cont_final_sale = $col['nm_contract_cont_final_sale']; // $nm_contract_fail_reason_sale = $col['nm_contract_fail_reason_sale']; // $nm_file_chk1_sale = $col['nm_file_chk1_sale']; // $nm_file_chk2_sale = $col['nm_file_chk2_sale']; // $nm_file_chk3_sale = $col['nm_file_chk3_sale']; // $nm_file_chk4_sale = $col['nm_file_chk4_sale']; // $nm_file_chk5_sale = $col['nm_file_chk5_sale']; // $nm_file_trading_sale = $col['nm_file_trading_sale']; // $nm_file_performance_sale = $col['nm_file_performance_sale']; // $nm_file_postscript_sale = $col['nm_file_postscript_sale']; // // //보험처리 // $nm_act_chgno = $col['nm_act_chgno']; // $nm_act_chgnm = $col['nm_act_chgnm']; // $nm_act_s1 = $col['nm_act_s1']; // $nm_act_s2 = $col['nm_act_s2']; // $nm_act_s3 = $col['nm_act_s3']; // $nm_act_s4 = $col['nm_act_s4']; // $nm_act_my = $col['nm_act_my']; // $nm_act_my_amt = $col['nm_act_my_amt']; // $nm_act_other = $col['nm_act_other']; // $nm_act_other_amt = $col['nm_act_other_amt']; // $nm_act_searchdt = $col['nm_act_searchdt']; // $nm_act_cnt = $col['nm_act_cnt']; // $nm_act_general_spec = $col['nm_act_general_spec']; // $nm_act_use_record = $col['nm_act_use_record']; // $nm_act_use_record_lend = $col['nm_act_use_record_lend']; // $nm_act_use_record_biz = $col['nm_act_use_record_biz']; // $nm_act_use_record_official = $col['nm_act_use_record_official']; // $nm_act_ins_loss = $col['nm_act_ins_loss']; // $nm_act_ins_wet = $col['nm_act_ins_wet']; // $nm_act_ins_robbery = $col['nm_act_ins_robbery']; // $nm_file_act = $col['nm_file_act']; // $nm_act_yn = $col['nm_act_yn']; // // $ds_g1_01 = $col['ds_g1_01']; // $ds_g1_02 = $col['ds_g1_02']; // $ds_g1_03 = $col['ds_g1_03']; // $ds_g1_04 = $col['ds_g1_04']; // $ds_g1_05 = $col['ds_g1_05']; // $ds_g2_01 = $col['ds_g2_01']; // $ds_g2_02 = $col['ds_g2_02']; // $ds_g2_03 = $col['ds_g2_03']; // $ds_g2_04 = $col['ds_g2_04']; // $ds_g2_05 = $col['ds_g2_05']; // $ds_g3_01 = $col['ds_g3_01']; // $ds_g3_02 = $col['ds_g3_02']; // $ds_g3_03 = $col['ds_g3_03']; // $ds_g3_04 = $col['ds_g3_04']; // $ds_g3_05 = $col['ds_g3_05']; // $ds_g4_01 = $col['ds_g4_01']; // $ds_g4_02 = $col['ds_g4_02']; // $ds_g4_03 = $col['ds_g4_03']; // $ds_g4_04 = $col['ds_g4_04']; // $ds_g4_05 = $col['ds_g4_05']; // // /* // $arr_nm_info1 = explode("-",$nm_info1); // if(count($arr_nm_info1) == 3){ // $nm_info11 = $arr_nm_info1[0]; // $nm_info12 = $arr_nm_info1[1]; // $nm_info13 = $arr_nm_info1[2]; // }else{ // $nm_info11 = ""; // $nm_info12 = ""; // $nm_info13 = ""; // } // // $arr_nm_info3 = explode("@",$nm_info3); // if(count($arr_nm_info3) == 2){ // $nm_info31 = $arr_nm_info3[0]; // $nm_info32 = $arr_nm_info3[1]; // }else{ // $nm_info31 = ""; // $nm_info32 = ""; // } // $nm_info3 = $col[nm_info3]; // */ // // }else{ // AlertBack("지정되지않은 요청입니다"); // } $sql ="SELECT * FROM car_history_master mst WHERE cd_car='$cd_car' AND ds_delind='N'"; $history_col=mysql_fetch_array(mysql_query($sql)); $r000 = $history_col["r000"]; $r001 = $history_col["r001"]; $r002 = $history_col["r002"]; $r004 = $history_col["r004"]; $r005 = $history_col["r005"]; $r101 = $history_col["r101"]; $r102 = $history_col["r102"]; $r103 = $history_col["r103"]; $r104 = $history_col["r104"]; $r105 = $history_col["r105"]; $r106 = $history_col["r106"]; $r107 = $history_col["r107"]; $r108 = $history_col["r108"]; $r109 = $history_col["r109"]; $r401 = $history_col["r401"]; $r402 = $history_col["r402"]; $r403 = $history_col["r403"]; $r404 = $history_col["r404"]; $r405 = $history_col["r405"]; $r406_01 = $history_col["r406_01"]; $r407 = $history_col["r407"]; $r408_01 = $history_col["r408_01"]; $r409 = $history_col["r409"]; $r410_01 = $history_col["r410_01"]; $r201 = $history_col["r201"]; $r202 = $history_col["r202"]; $r203 = $history_col["r203"]; $r204 = $history_col["r204"]; $r205 = $history_col["r205"]; $r510 = $history_col["r510"]; $r511_01 = $history_col["r511_01"]; $r501 = $history_col["r501"]; $r502 = $history_col["r502"]; $r301 = $history_col["r301"]; $r302 = $history_col["r302"]; $r303 = $history_col["r303"]; $r601 = $history_col["r601"]; $r602 = $history_col["r602"]; ?>
고객통화 후 일정잡기 if($ds_status_contract_step2_sale != "Y"){ ?>미확인 }else{ ?>확인 } ?>
검차 결과 / 계약상황 입력하기 if($ds_status_contract_step3_sale != "Y"){ ?>미확인 }else{ ?>확인 } ?>
거래마무리 관리 if($ds_status_contract_step4_sale != "Y"){ ?>미확인 }else{ ?>확인 } ?>
거래완료 처리 if($ds_status_contract_step5_sale != "Y"){ ?>미확인 }else{ ?>확인 } ?>
레이어팝업닫기