$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_recommend nm_recommend_sale , s.nm_cont_return nm_cont_return_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 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]; $cd_model_sub = $col[cd_model_sub]; $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_area_user = $col[nm_area_user]; $nm_recommend_sale = $col[nm_recommend_sale]; $nm_cont_return_sale = $col[nm_cont_return_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("지정되지않은 요청입니다"); } //입찰대기, 입찰중 화면에서는 차량 정보가 수정 가능함 $able_status = array("A0", "B0", "C0", "D0", "E0", "F0", "G0"); $able_modify = false; if(in_array($ds_status_sale, $able_status)) { $able_modify = true; } ?>
| 이름 | =$nm_name_sale?> | 회원 | =$nm_usertype?> | |
|---|---|---|---|---|
| 연락처 | =$nm_hp_sale?> | 아이디 | =$nm_email_sale?> | |
| 차량 소유주명 | =$nm_name?> | 판매지역 | if($able_modify) { ?> } else { ?> =$nm_area?> } ?> | |
| 차량번호 | =$nm_number?> | 제조사 | =$nm_brand?> | |
| 모델 | =$nm_model?> | 세부모델 | =$nm_model_sub?> | |
| 등급 | if($able_modify) { ?> } else { ?> =$nm_grade?> } ?> | 연식(최초등록일) | =$nm_regdate_yyyy."년 ".$nm_regdate_mm."월"?> | |
| 형식연도 | =$nm_year?>년 | 배기량 | =$nm_cc?>cc | |
| 변속기 | =$nm_transmission?> | 연료 | =$nm_oil?> | |
| 색상 | =$nm_color?> | 주행거리 | if($able_modify) { ?>km | }else { ?>=$nm_mileage?>km | } ?>
| 사고유무 | if($able_modify) { ?> }else{ ?> =$nm_accident?> =$nm_cont_accident?> } ?> | 추천인 | = ($nm_recommend_sale == "") ? "없음":$nm_recommend_sale ?> | |
| 옵션 | =$nm_cont?> | |||
| 판매희망지역 | =$nm_area_user?> | |||
| 필수사진 |
|
|||
| 추가사진 |
|
|||
| 코멘트 | if($able_modify) { ?> } else { ?> =$nm_guide?> } ?> | |||
| 검차사진 |
|
|||