include("../include/inc_top.php") ?>
include("../include/inc_header.php") ?>
내차팔기
쉽고 간편한 내차팔기, 견적산출, 최종 매각까지 어떤 수수료도 요구하지 않습니다.
$mode = $_REQUEST["mode"];
$p_nm_name = $_REQUEST["nm_name"];
$p_nm_hp = $_REQUEST["nm_hp"];
$p_nm_number = $_REQUEST["nm_number"];
$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('sale_master','ds_area',s.ds_area) as nm_area
, getCode('sale_master','ds_status',s.ds_status) as nm_status
, s.cd_sale
, 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
, getRemainTimeByPhase(".LIMIT_TIME_TENDER.", ".LIMIT_TIME_SELL.", s.dt_approve, now()) as time_limit_sell
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.nm_name='$nm_name'
and s.nm_hp='$nm_hp'
and a.nm_number='$nm_number'
and s.ds_delind = 'N'
and s.ds_status in ('B0','C0','D0','E0','F0','Z0','ZS')
ORDER BY s.cd_sale desc LIMIT 0,1
";
$col=mysql_fetch_array(mysql_query($sql));
if (!empty($col[cd_car])){
$cd_sale = $col[cd_sale];
$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_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_sell = $col[time_limit_sell];
//보험처리
$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("진행중인 차량 정보가 존재하지 않습니다.");
}
?>
차량기본정보
=$nm_brand." ".$nm_model." ".$nm_model_sub." ".$nm_grade?>
if($ds_status_sale == "E0" || $ds_status_sale == "F0"){ ?>
입찰 마감 시간 : =$time_limit_sell?>
} ?>
차량번호
=$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?>=($ds_accident == "A0") ? " - ".$nm_cont_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{
?>
}
?>
if($ds_status_sale == "A0" || $ds_status_sale == "B0" || $ds_status_sale == "C0" || $ds_status_sale == "D0"){ //ds_status_sale=A0,B0,C0,D0 입력중,입력완료,승인대기,반려
?>
수정하기
}
?>
사고이력정보
차량번호 변경
=$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?> 원)
// $cd_sale = $_REQUEST["cd_sale"];
$PageNo = $_REQUEST['pageno'];
$PageSize = $_REQUEST['PageSize'];
if (empty($PageNo)) {$PageNo=1;}else{$PageNo=$PageNo;}
if (empty($PageSize)) {
$PageSize=10; //목록개수설정
}else{$PageSize=$PageSize;}
$pagestartpoint=($PageNo-1)*$PageSize;
$OrderBy = $_REQUEST['OrderBy'];
if ($OrderBy == "") $OrderBy = "cast(t.nm_price as unsigned) desc, t.cd_tender desc ";
$sOrderBy = "ORDER BY ".$OrderBy;
//$sql = "where ds_delind='N'";
$sql = "";
$totalrows = @mysql_result(mysql_query("select count(*) FROM dealer_master d inner join tender_master t on (d.cd_dealer = t.cd_dealer_p and t.cd_sale = $cd_sale and t.ds_delind='N' $sql) "),0,0);
?>
입찰리스트
번호
입찰업체
입찰금액
입찰일
업체정보
상태
if($totalrows>0) {
$r = mysql_query("SELECT t.*, d.nm_company nm_company_dealer, d.nm_name nm_name_dealer, s.ds_status ds_status_sale, getRemainTimeByPhase(".LIMIT_TIME_TENDER.", ".LIMIT_TIME_SELL.", s.dt_approve, now()) as time_limit_sell, d1.nm_name nm_name_dealer1 FROM dealer_master d inner join tender_master t on (d.cd_dealer = t.cd_dealer_p and t.cd_sale = $cd_sale and t.ds_delind='N' $sql) inner join dealer_master d1 on (t.cd_dealer = d1.cd_dealer) inner join sale_master s on (t.cd_sale = s.cd_sale) $sOrderBy LIMIT $pagestartpoint,$PageSize");
$i=1;
while($col = mysql_fetch_array($r)) {
?>
=$i?>
=$col[nm_company_dealer]?> / =$col[nm_name_dealer1]?>
=$col[nm_price]?> 만원
=$col[dt_insert]?>
후기 보기
if($col[ds_status_sale] == "Z0" || $col[ds_status_sale] == "ZS" || $col[ds_status_sale] == "ZE"){
?>
if($col[ds_status_sale] == "ZE"){
?>
거래실수
}else{
?>
= ($col[ds_status] == "Z0") ? "낙찰" : "낙첨" ?>
}
?>
}else{
?>
if($col[ds_status_sale] == "E0" || $col[ds_status_sale] == "F0"){
if($col[time_limit_sell]=="0분"){
?>
낙첨
}else{
?>
낙찰하기
}
?>
}
?>
}
?>
$i++;
}
}else{
?>
데이터가 존재 하지 않습니다.
}
?>
$url = "./sell_view_nomember.php?list_url=$list_url&cd_sale=$cd_sale&ds_status_sale=$ds_status_sale&ListPageNo=$ListPageNo&PageNo=$PageNo&nm_name=$p_nm_name&nm_hp=$p_nm_hp&nm_number=$p_nm_number&mode=$mode";
// ListPg1($url ,$PageNo,$PageSize,10,$totalrows,$leftboard[1],$rootpath);
?>
if ($ds_status_sale == "ZS"){
$sql = "SELECT
t.*
, d.nm_name nm_name_dealer_p
, d.nm_zip nm_zip_dealer_p
, d.nm_addr nm_addr_dealer_p
, d.nm_addr_sub nm_addr_sub_dealer_p
, d.nm_area nm_area_dealer_p
, p.nm_name nm_name_dealer
, p.nm_hp_01+'-'+p.nm_hp_02+'-'+p.nm_hp_03 nm_hp_dealer
, p.nm_file nm_file_dealer
, report.cd_dealer_p_min
, report.cd_dealer_p_max
, report.nm_price_min
, report.nm_price_max
, report.nm_price_avg
, report.nm_name_min
, report.nm_name_max
, report.cnt
, s.nm_price_final
, s.nm_score_postscript
, s.nm_cont_postscript
FROM tender_master t
inner join dealer_master d
on (t.cd_dealer_p = d.cd_dealer
and t.cd_sale = '$cd_sale'
and t.ds_delind = 'N'
and t.ds_status = 'Z0'
)
inner join dealer_master p
on (t.cd_dealer = p.cd_dealer
)
inner join (
select
ff.cd_sale
, ff.cd_dealer_p_min
, ff.cd_dealer_p_max
, ff.nm_price_min
, ff.nm_price_max
, ff.nm_price_avg
, ff.cnt
, d1.nm_name nm_name_min
, d2.nm_name nm_name_max
from (
select
max(cc.cd_sale) cd_sale
, max(cc.cd_dealer_p_min) cd_dealer_p_min
, max(cc.cd_dealer_p_max) cd_dealer_p_max
, max(cc.nm_price_min) nm_price_min
, max(cc.nm_price_max) nm_price_max
, max(cc.nm_price_avg) nm_price_avg
, max(cc.cnt) cnt
from (
select
aa.cd_sale
, case when aa.nm_price = bb.nm_price_min then aa.cd_dealer_p else 0 end cd_dealer_p_min
, case when aa.nm_price = bb.nm_price_max then aa.cd_dealer_p else 0 end cd_dealer_p_max
, bb.nm_price_min
, bb.nm_price_max
, bb.nm_price_avg
, bb.cnt
from (select * from tender_master where cd_sale = '$cd_sale' and ds_delind = 'N') aa
, (
select
min(nm_price) nm_price_min
, max(nm_price) nm_price_max
, avg(nm_price) nm_price_avg
, count(*) cnt
from tender_master
where cd_sale = '$cd_sale' and ds_delind = 'N'
) bb
) cc
) ff
inner join dealer_master d1
on (ff.cd_dealer_p_min = d1.cd_dealer)
inner join dealer_master d2
on (ff.cd_dealer_p_max = d2.cd_dealer)
) report
on (t.cd_sale = report.cd_sale
)
inner join sale_master s
on (t.cd_sale = s.cd_sale
)
";
$col=mysql_fetch_array(mysql_query($sql));
if (!empty($col[cd_sale])){
$cd_sale = $col[cd_sale];
$nm_price = $col[nm_price];
$nm_name_dealer_p = $col[nm_name_dealer_p];
$nm_zip_dealer_p = $col[nm_zip_dealer_p];
$nm_addr_dealer_p = $col[nm_addr_dealer_p];
$nm_addr_sub_dealer_p = $col[nm_addr_sub_dealer_p];
$nm_area_dealer_p = $col[nm_area_dealer_p];
$nm_name_dealer = $col[nm_name_dealer];
$nm_hp_dealer = $col[nm_hp_dealer];
$nm_file_dealer = $col[nm_file_dealer];
$cd_dealer_p_min = $col[cd_dealer_p_min];
$cd_dealer_p_max = $col[cd_dealer_p_max];
$nm_price_min = $col[nm_price_min];
$nm_price_max = $col[nm_price_max];
$nm_price_avg = $col[nm_price_avg];
$nm_name_min = $col[nm_name_min];
$nm_name_max = $col[nm_name_max];
$cnt = $col[cnt];
$nm_price_final = $col[nm_price_final];
$nm_score_postscript = $col[nm_score_postscript];
$nm_cont_postscript = $col[nm_cont_postscript];
/*
$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_name_dealer_p?>
약속드립니다. 정직하게 일하겠습니다.
참여업체 : =$cnt?>
평균견적 : =$nm_price_avg?> 만원
낙찰가 =$nm_price_final?> 만원
}
?>
if($ds_status_sale == "D0"){ //ds_status_sale=D0
?>
}
?>
include("../include/inc_footer.php") ?>
include("../include/inc_bottom.php") ?>
mysql_close($connect);
?>