마이페이지
쉽고 간편한 내차팔기, 견적산출,
최종 매각까지 어떤 수수료도 요구하지 않습니다.
$s_cd_dealer = $_SESSION['s_cd_dealer'];
$s_cd_dealer_p = $_SESSION['s_cd_dealer_p'];
$s_ds_type = $_SESSION['s_ds_type'];
$s_ds_status_p = $_SESSION['s_ds_status_p'];
if($s_ds_type == "D0"){ //딜러
$sql_ds_type = " cd_dealer_p = '$s_cd_dealer' ";
}else{ //딜러-관리자
$sql_ds_type = " cd_dealer = '$s_cd_dealer' ";
}
$rq_ds_status = $_REQUEST['ds_status']; //요청받은 상태값 : request ds_status (naming request->rq, response->rs)
if($rq_ds_status == "E0"){
$nm_title = "입찰대기 리스트";
}else if($rq_ds_status == "F0"){
$nm_title = "입찰중 리스트";
}else if($rq_ds_status == "Z0"){
$nm_title = "낙찰 리스트";
}else if($rq_ds_status == "ZS"){
$nm_title = "구매확정 리스트";
}
$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
, getRemainTime(".LIMIT_TIME_TENDER.", s.dt_approve, now()) as time_limit_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_recommend_sale = $col[nm_recommend_sale];
$nm_cont_return_sale = $col[nm_cont_return_sale];
$time_limit_tender = $col[time_limit_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("지정되지않은 요청입니다");
}
$sql ="SELECT *
FROM car_history_master mst
WHERE cd_car='$cd_car' AND ds_delind='N'";
$history_col=mysql_fetch_array(mysql_query($sql));
$r000 = $history_col["r000"];
$r001 = $history_col["r001"];
$r002 = $history_col["r002"];
$r004 = $history_col["r004"];
$r005 = $history_col["r005"];
$r101 = $history_col["r101"];
$r102 = $history_col["r102"];
$r103 = $history_col["r103"];
$r104 = $history_col["r104"];
$r105 = $history_col["r105"];
$r106 = $history_col["r106"];
$r107 = $history_col["r107"];
$r108 = $history_col["r108"];
$r109 = $history_col["r109"];
$r401 = $history_col["r401"];
$r402 = $history_col["r402"];
$r403 = $history_col["r403"];
$r404 = $history_col["r404"];
$r405 = $history_col["r405"];
$r406_01 = $history_col["r406_01"];
$r407 = $history_col["r407"];
$r408_01 = $history_col["r408_01"];
$r409 = $history_col["r409"];
$r410_01 = $history_col["r410_01"];
$r201 = $history_col["r201"];
$r202 = $history_col["r202"];
$r203 = $history_col["r203"];
$r204 = $history_col["r204"];
$r205 = $history_col["r205"];
$r510 = $history_col["r510"];
$r511_01 = $history_col["r511_01"];
$r501 = $history_col["r501"];
$r502 = $history_col["r502"];
$r301 = $history_col["r301"];
$r302 = $history_col["r302"];
$r303 = $history_col["r303"];
$r601 = $history_col["r601"];
$r602 = $history_col["r602"];
?>
차량 기본정보
=$col[nm_model]." ".$col[nm_model_sub]." ".$col[nm_grade]?>
if($ds_status_sale == "E0" || $ds_status_sale == "F0"){ ?>
입찰 마감 시간 : =$time_limit_tender?>
} ?>
| 차량번호 |
=$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_cont_accident?>
|
| 옵션 |
=$nm_cont?> |
| 판매희망지역 |
=$nm_area_user?>
|
| 필수사진 |
-
차량전면
-
차량후면
-
운전석 측면
-
조수석 측면
-
계기판
|
| 추가사진 |
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{
?>
}
?>
|
| 담당자코멘트 |
=$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?>원)
*/?>
- 차량번호 변경 =number_format($r201)?>회
- 소유자 변경 =number_format($r204)?> 회
- 자동차 보험 특수 사고 전손 : =number_format($r405)?> 회 / 침수전(분)손 : =number_format($r407)?> 회 / 도난 : =number_format($r409)?> 회
- 보험사고 (내차피해) =number_format($r401)?> 회 (=number_format($r402)?> 원)
- 보험사고 (타차가해) =number_format($r403)?>회 (=number_format($r404)?>원)
// $sql ="select count(*) cnt, max(case when ".$sql_ds_type." then nm_price else 0 end) nm_price_max from tender_master where cd_sale = $cd_sale ";
$sql ="select count(*) cnt
, max(case when ".$sql_ds_type." then cast(nm_price as UNSIGNED) else 0 end) nm_price_max
, min(cast(nm_price as UNSIGNED)) min_price
, avg(cast(nm_price as UNSIGNED)) avg_price
, max(cast(nm_price as UNSIGNED)) max_price
from tender_master where cd_sale = $cd_sale ";
// echo $sql;
$col1=mysql_fetch_array(mysql_query($sql));
// $col1=mysql_fetch_array(mysql_query($sql));
?>
#유찰의 경우만 visible
if($rq_ds_status == "ZE") {
?>
- 최고가 : =number_format($col1[max_price])?>만원
- 최저가 : =number_format($col1[min_price])?>만원
- 평균 입찰금액 : =number_format($col1[avg_price])?>만원
- 입찰자 수 : =$col1[cnt]?>곳
$col2_cnt = 1;
$col2_ord = 65;
$sql2 =mysql_query("select nm_price
,(select nm_company from dealer_master a where a.cd_dealer = b.cd_dealer_p limit 1) as nm_company
from tender_master b where cd_sale = $cd_sale
order by cast(nm_price as UNSIGNED) desc limit 3");
while($col2 = mysql_fetch_array($sql2)) {
?>
- =$col2_cnt?>위 : =number_format($col2[nm_price])?>만원 / =chr($col2_ord)?>상사//$col2[nm_company]?>
$col2_ord++;
$col2_cnt++;
}
?>
if($col1[nm_price_max]>0) {
?>
나의 입찰가는 =number_format($col1[nm_price_max])?>만원입니다.
}
?>
}else {
?>
0) { ?> ty2 } ?>>
- 입찰 진행 중
- =$col1[cnt]?>명의 딜러가 입찰하였습니다.
if($col1[nm_price_max]>0) {
?>
나의 입찰가는 =$col1[nm_price_max]?>만원입니다.
}
?>
//select count(*) cnt_tender, sum(case when cd_dealer = '55' then 1 else 0 end) cnt_tender_dealer from tender_master where ds_delind ='N' and cd_sale = '73' and cd_dealer_p = '52'
// $cd_tender = @mysql_result(mysql_query("select cd_tender from tender_master where ds_delind ='N' and cd_sale = '$cd_sale' and cd_dealer = '$s_cd_dealer' "),0,0);
$cd_tender = mysql_fetch_array(mysql_query("select count(*) cnt_tender, sum(case when cd_dealer = '$s_cd_dealer' then 1 else 0 end) cnt_tender_dealer from tender_master where ds_delind ='N' and cd_sale = '$cd_sale' and cd_dealer_p = '$s_cd_dealer_p' "));
//입찰하기 : 입찰대기건/부관리자/현재미입찰건(부관리자본인)
// if($rq_ds_status == "E0" && $s_ds_type == "D1" && empty($cd_tender) && $time_limit_tender != "0분"){ //딜러-관리자
//입찰하기 : 입찰대기건/부관리자/소속딜러입찰건1건이하일경우만(2건이상일경우제한)/현재미입찰건(부관리자본인)/소속총괄관리자 관리자에게 승인 받은 경우
if($rq_ds_status == "E0" && $s_ds_type == "D1" && ($cd_tender[cnt_tender] < 2 && $cd_tender[cnt_tender_dealer] == 0) && $time_limit_tender != "0분" && $s_ds_status_p == "Z0"){ //딜러-관리자
?>
} ?>
//입찰금액 수정은 딱히 정해 진게 없어서 정의 후 작업
/*
* 딜러가 입찰한 내역이 있어야 하고
* 현재 sale 상태가 입찰대기(E0)여야 하며
* 수정 내역이 3번까지만 가능
* 낙찰 마감일이 안지나야 가능
*/
$cd_tender_sql = "select cd_tender, nm_modify_cnt
, (select ds_status from sale_master s where s.cd_sale = t.cd_sale) as sale_ds_status
from tender_master t
where t.ds_delind ='N'
and t.cd_sale = '$cd_sale'
and t.cd_dealer_p = '$s_cd_dealer_p'
limit 1";
// echo $cd_tender_sql;
$cd_tender = mysql_fetch_array(mysql_query($cd_tender_sql));
if($rq_ds_status == "F0" && $s_ds_type == "D1" && $cd_tender[sale_ds_status] == 'E0' && !empty($cd_tender[cd_tender]) && $cd_tender[nm_modify_cnt] < 3 && $time_limit_tender != "0분" && $s_ds_status_p == "Z0"){ //딜러-관리자
?>
} ?>
}
?>