$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?> } ?> | |||
| 검차사진 |
|
|||