include("../inc/inc_top.php") ?>
include("../inc/inc_header.php") ?>
딜러 회원관리
include("../inc/inc_header_dealer.php") ?>
$s_cd_dealer = $_REQUEST["cd_dealer"];
$s_cd_dealer_p = $s_cd_dealer;
$sql1 = " cd_dealer_p = '$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_recommend nm_recommend_sale
, s.nm_cont_return nm_cont_return_sale
, case when s.ds_status in ('B0','C0') then '미승인' when s.ds_status in ('D0') then '반려' when s.ds_status in ('E0','F0') then '입찰중' when s.ds_status in ('G0') then '입찰마감' when s.ds_status in ('Z0') then '낙찰' when s.ds_status in ('ZS') then '구매확정' else '' end as nm_status_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_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_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'];
/*
$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("지정되지않은 요청입니다");
}
?>
| 차량번호 |
=$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?> |
추천인 |
= ($nm_recommend_sale == "") ? "없음":$nm_recommend_sale ?> |
| 옵션 |
=$nm_cont?> |
| 필수사진 |
-
차량전면
-
차량후면
-
운전석 측면
-
조수석 측면
-
계기판
|
| 추가사진 |
if(!empty($col['cd_car'])){
$r = mysql_query("SELECT * FROM car_file WHERE cd_car = '$cd_car' and ds_type='' and ds_delind='N' Order by no_sort asc , cd_car ASC ");
$i=1;
while($imgs = mysql_fetch_array($r)) {
?>

}
}else{
?>
}
?>
|
$sql ="select * from tender_master where cd_sale = $cd_sale and cd_dealer_p = '$s_cd_dealer' ";
$col1=mysql_fetch_array(mysql_query($sql));
?>
| 입찰금액 |
=$col1['nm_price']?>만원 |
상태 |
if ($ds_status_sale == "ZS" && $col1['ds_status'] == "Z0"){ ?>
구매확정
}else if ($ds_status_sale == "Z0" && $col1['ds_status'] == "Z0"){ ?>
낙찰
}else if (($ds_status_sale == "Z0" || $ds_status_sale == "ZS") && $col1['ds_status'] == "A0"){ ?>
유찰
}else{ ?>
입찰대기
} ?>
|
입찰자 |
=$col1['nm_name']?> |
include("../inc/inc_footer.php") ?>
include("../inc/inc_bottom.php") ?>
mysql_close($connect);
?>