$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("지정되지않은 요청입니다"); } ?>
차량정보 확인 if($ds_status_contract_step1_sale != "Y"){ ?>미확인 }else{ ?>확인 } ?>
| 차량번호 | =$nm_number?> | 제조사 | =$nm_brand?> |
|---|---|---|---|
| 모델 | =$nm_model?> | 세부모델 | =$nm_model_sub?> |
| 등급 | =$nm_grade?> | 연식(최초등록일) | =$nm_regdate_yyyy."년 ".$nm_regdate_mm."월"?> |
| 형식연도 | =$nm_year?>년 | 배기량 | =$nm_cc?>cc |
| 변속기 | =$nm_transmission?> | 연료 | =$nm_oil?> |
| 색상 | =$nm_color?> | 주행거리 | =$nm_mileage?>km |
| 사고유무 | =$nm_accident?>=($ds_accident == "A0") ? " - ".$nm_cont_accident : "" ?> | 추천인 | = ($nm_recommend_sale == "") ? "없음":$nm_recommend_sale ?> |
| 옵션 | =$nm_cont?> | ||
| 필수사진 |
|
||
| 추가사진 |
|
||
| 코멘트 | =$nm_guide?> | ||
| 검차사진 |
|
||
| 차량번호 변경 | =$nm_act_chgno?> 회 |
|---|---|
| 소유자 변경 | =$nm_act_chgnm?> 회 |
| 자동차 보험 특수 사고 | 전손 : =$nm_act_s1?>회 / 침수전손 : =$nm_act_s2?>회 / 침수분손 : =$nm_act_s3?>회 / 도난 : =$nm_act_s4?>회 |
| 보험사고 (내차피해) | =$nm_act_my?> 회(=$nm_act_my_amt?> 원) |
| 보험사고 (타차가해) | =$nm_act_other?> 회(=$nm_act_other_amt?> 원) |
고객통화 후 일정잡기 if($ds_status_contract_step2_sale != "Y"){ ?>미확인 }else{ ?>확인 } ?>
검차 결과 / 계약상황 입력하기 if($ds_status_contract_step3_sale != "Y"){ ?>미확인 }else{ ?>확인 } ?>
거래마무리 관리 if($ds_status_contract_step4_sale != "Y"){ ?>미확인 }else{ ?>확인 } ?>
레이어팝업닫기
| 자동차 일반사양 | =$nm_act_general_spec?> |
|---|---|
| 자동차 용도이력 | =$nm_act_use_record?> |
| 자동차 번호 / 소유자 변경횟수 | =$nm_act_chgno?> 회 / =$nm_act_chgnm?> 회 |
| 자동차보험 특수 사고이력(전손, 침수, 도난) | 전손 : =$nm_act_s1?>, 도난 : =$nm_act_s4?>, 침수(전손 : =$nm_act_s2?>, 분손 : =$nm_act_s3?>) |
| 보험사고이력(내차 피해) | =$nm_act_my?> 회, =$nm_act_my_amt?> 원 |
| 보험사고이력(타차 피해) | =$nm_act_other?> 회, =$nm_act_other_amt?> 원 |
자동차보험 사고기록이 없었다고 해서 반드시 무사고라고 할 수는 없습니다.
| 대여용도 사용이력(렌터카) | =$nm_act_use_record_lend?> |
|---|---|
| 영업용도 사용이력 | =$nm_act_use_record_biz?> |
| 관용용도 사용이력 | =$nm_act_use_record_official?> |
과거 자동차번호 변경기록을 모두 검색하여 제공하는 것으로 대여용(렌트카), 영업용(택시 등)으로 사용된 적이 있는지 확인할 수 있습니다.
| 전손 보험사고 | =$nm_act_ins_loss?> |
|---|---|
| 침수 보험사고 | =$nm_act_ins_wet?> |
| 도난 보험사고 | =$nm_act_ins_robbery?> |
| 사고일자 | 부품 | 공임 | 도장 | 총 수리비용 |
|---|---|---|---|---|
| =$ds_g1_01?> | =$ds_g1_02?>원 | =$ds_g1_03?>원 | =$ds_g1_04?>원 | =$ds_g1_05?>원 |
| =$ds_g2_01?> | =$ds_g2_02?>원 | =$ds_g2_03?>원 | =$ds_g2_04?>원 | =$ds_g2_05?>원 |
| =$ds_g3_01?> | =$ds_g3_02?>원 | =$ds_g3_03?>원 | =$ds_g3_04?>원 | =$ds_g3_05?>원 |
| =$ds_g4_01?> | =$ds_g4_02?>원 | =$ds_g4_03?>원 | =$ds_g4_04?>원 | =$ds_g4_05?>원 |