echajoa/manage/member/dealer_view4_detail.php

<?php

	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
	include $_SERVER['DOCUMENT_ROOT'].ADMIN_PATH.'common/auth_chk.php';

	$cd_dealer = $_REQUEST["cd_dealer"];
	$PageNo = $_REQUEST["ListPageNo"];
?>
<? include("../inc/inc_top.php") ?>
<? include("../inc/inc_header.php") ?>

<section id="contents">
	<h2>딜러 회원관리</h2>

<? 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("지정되지않은 요청입니다");
	}

?>

	<div class="tbl_wrap">
		<table class="tbl_list2 ty2">
			<colgroup>
				<col width="12%">
				<col width="38%">
				<col width="12%">
				<col width="38%">
			</colgroup>
			<tr>
				<th>차량번호</th>
				<td><?=$nm_number?></td>
				<th>제조사</th>
				<td><?=$nm_brand?></td>
			</tr>
			<tr>
				<th>모델</th>
				<td><?=$nm_model?></td>
				<th>세부모델</th>
				<td><?=$nm_model_sub?></td>
			</tr>
			<tr>
				<th>등급</th>
				<td><?=$nm_grade?></td>
				<th>연식(최초등록일)</th>
				<td><?=$nm_regdate_yyyy."년 ".$nm_regdate_mm."월"?></td>
			</tr>
			<tr>
				<th>형식연도</th>
				<td><?=$nm_year?>년</td>
				<th>배기량</th>
				<td><?=$nm_cc?>cc</td>
			</tr>
			<tr>
				<th>변속기</th>
				<td><?=$nm_transmission?></td>
				<th>연료</th>
				<td><?=$nm_oil?></td>
			</tr>
			<tr>
				<th>색상</th>
				<td><?=$nm_color?></td>
				<th>주행거리</th>
				<td><?=$nm_mileage?>km</td>
			</tr>
			<tr>
				<th>사고유무</th>
				<td><?=$nm_accident?></td>
				<th>추천인</th>
				<td><?= ($nm_recommend_sale == "") ? "없음":$nm_recommend_sale ?></td>
			</tr>
			<tr>
				<th>옵션</th>
				<td colspan="3"><?=$nm_cont?></td>
			</tr>
			<tr>
				<th>필수사진</th>
				<td colspan="3">
					<ul class="photo_list">
						<li>
							<img src="<?=UPLOAD_PATH_CAR?>nm_file_main/<?=$nm_file_front?>" onclick="viewPhoto('<?=UPLOAD_PATH_CAR?>nm_file_main/<?=$nm_file_front?>')">
							<span>차량전면</span>
						</li>
						<li>
							<img src="<?=UPLOAD_PATH_CAR?>nm_file_main/<?=$nm_file_back?>" onclick="viewPhoto('<?=UPLOAD_PATH_CAR?>nm_file_main/<?=$nm_file_back?>')">
							<span>차량후면</span>
						</li>
						<li>
							<img src="<?=UPLOAD_PATH_CAR?>nm_file_main/<?=$nm_file_side1?>" onclick="viewPhoto('<?=UPLOAD_PATH_CAR?>nm_file_main/<?=$nm_file_side1?>')">
							<span>운전석 측면</span>
						</li>
						<li>
							<img src="<?=UPLOAD_PATH_CAR?>nm_file_main/<?=$nm_file_side2?>" onclick="viewPhoto('<?=UPLOAD_PATH_CAR?>nm_file_main/<?=$nm_file_side2?>')">
							<span>조수석 측면</span>
						</li>
						<li>
							<img src="<?=UPLOAD_PATH_CAR?>nm_file_main/<?=$nm_file_dashboard?>" onclick="viewPhoto('<?=UPLOAD_PATH_CAR?>nm_file_main/<?=$nm_file_dashboard?>')">
							<span>계기판</span>
						</li>
					</ul>
				</td>
			</tr>
			<tr>
				<th>추가사진</th>
				<td colspan="3">
					<ul class="photo_list">
					<?
						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)) {
					?>
						<li><img src="<?=UPLOAD_PATH_CAR?><?=$imgs['cd_car']?>_detail/<?=$imgs['nm_file']?>" onclick="viewPhoto('<?=UPLOAD_PATH_CAR?><?=$imgs['cd_car']?>_detail/<?=$imgs['nm_file']?>')"></li>
					<?
							}
						}else{
					?>
					<?
						}
					?>
					</ul>
				</td>
			</tr>
		</table>
	</div>

<?

	$sql ="select * from tender_master where cd_sale = $cd_sale and cd_dealer_p = '$s_cd_dealer' ";

	$col1=mysql_fetch_array(mysql_query($sql));

?>
	<table class="tbl_list3">
		<colgroup>
			<col width="13%">
			<col width="25%">
			<col width="13%">
			<col width="20%">
			<col width="13%">
			<col width="*">
		</colgroup>
		<tr>
			<th>입찰금액</th>
			<td><em class="txt_blue"><?=$col1['nm_price']?>만원</em></td>
			<th>상태</th>
			<td>
			<? if ($ds_status_sale == "ZS" && $col1['ds_status'] == "Z0"){ ?>
            <em class="txt_green">구매확정</em>
		<? }else if ($ds_status_sale == "Z0" && $col1['ds_status'] == "Z0"){ ?>
			<em class="txt_red">낙찰</em>
		<? }else if (($ds_status_sale == "Z0" || $ds_status_sale == "ZS") && $col1['ds_status'] == "A0"){ ?>
			<em>유찰</em>
			<? }else{ ?>
			<em class="txt_blue">입찰대기</em>
			<? } ?>
            </td>
			<th>입찰자</th>
			<td><?=$col1['nm_name']?></td>
		</tr>
	</table>

	<div class="btn_right">
		<a href="dealer_view4.php?cd_dealer=<?=$cd_dealer?>&PageNo=<?=$PageNo?>" class="rnd_btn ty2 gray">목록</a>
		<!--a href="#" class="rnd_btn ty2 black">저장</a-->
	</div>
</section>

		<!-- layer popup3 -->
		<div class="layer_popup photo_popup">
			<div class="popup_wrap">
				<div class="btn_center">
					<img src="/img/sell/ic_car_photo1.png" id="photoBig">
				</div>
				<div class="btn_center">
					<a href="#" class="button gray" onclick="closeLayer('photo'); return false;">취소</a>
				</div>
			</div>
		</div>
		<!-- // layer popup3 -->

	</div>

<script laguage="javascript" type="text/javascript">

	function viewPhoto(arg1){

		$("#photoBig").attr("src", arg1);

		openLayer('photo'); return false;

	}

</script>

<? include("../inc/inc_footer.php") ?>
<? include("../inc/inc_bottom.php") ?>
<?
mysql_close($connect);
?>