include("../include/inc_top.php") ?>
include("../include/inc_header.php") ?>
마이페이지
쉽고 간편한 내차팔기, 견적산출, 최종 매각까지 어떤 수수료도 요구하지 않습니다.
include("./inc_menu_dealer.php") ?>
$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('member_master','ds_area',s.ds_area_user) as nm_area_user
, 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
, (select min(nm_price) from tender_master where cd_sale = '$cd_sale' and cd_dealer_p = '$s_cd_dealer_p' and ds_status = 'Z0') nm_price_tender
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_area_user = $col[nm_area_user];
$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_price_tender = $col[nm_price_tender];
//보험처리
$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{ ?>확인 } ?>
noauth } ?>>고객통화 후 일정잡기 if($ds_status_contract_step2_sale != "Y"){ ?>미확인 }else{ ?>확인 } ?>
noauth } ?>>검차 결과 / 계약상황 입력하기 if($ds_status_contract_step3_sale != "Y"){ ?>미확인 }else{ ?>확인 } ?>
noauth } ?>>거래마무리 관리 if($ds_status_contract_step4_sale != "Y"){ ?>미확인 }else{ ?>확인 } ?>
include("../include/inc_footer.php") ?>
include("../include/inc_bottom.php") ?>
mysql_close($connect);
?>