echajoa/manage/buy/inc_ViewCar0226.php

<?
	$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;
	}
?>

	<div class="tbl_wrap">
		<table class="tbl_list2">
			<colgroup>
				<col width="12%">
				<col width="38%">
				<col width="12%">
				<col width="38%">
			</colgroup>
			<tr>
				<th>이름</th>
				<td><?=$nm_name_sale?></td>
				<th>회원</th>
				<td><?=$nm_usertype?></td>
			</tr>
			<tr>
				<th>연락처</th>
				<td><?=$nm_hp_sale?></td>
				<th>아이디</th>
				<td><?=$nm_email_sale?></td>
			</tr>
			<tr>
				<th>차량 소유주명 </th>
				<td><?=$nm_name?></td>
				<th>판매지역</th>
				<td>
			<?
				if($able_modify) {
			?>
				<select name="modify_ds_area" id="modify_ds_area" style='font: inherit;'>
				</select>
			<?}
				else {
			?>
				<?=$nm_area?>
			<?
				}
			?></td>
			</tr>
			<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>
			<?
				if($able_modify) {
			?>
				<select name="modify_cd_grade" id="modify_cd_grade" style='font: inherit;'>
				</select>
			<?}
				else {
			?>
				<?=$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>
			<?
				if($able_modify) {
			?>
				<td>
					<input type='text' class="inp_txt" style="width:60px;" id='modify_nm_mileage' name='modify_nm_mileage' value='<?=$nm_mileage?>' /> km
					<!-- <a href="#" class="rnd_btn ty2 blue" onclick="changeNmMileage('<?=$cd_car?>', '<?=$cd_sale?>');return false;">수정</a> -->
				</td>
			<?
				}else {
			?>
				<td><?=$nm_mileage?>km</td>
			<?
				}
			?>
			</tr>
			<tr>
				<th>사고유무</th>
				<td>
			<?
				if($able_modify) {
			?>
				<select name="modify_ds_accident" id="modify_ds_accident" style='font: inherit;'>
				</select>
				<input type='text' class="inp_txt" style="" id='modify_nm_cont_accident' name='nm_cont_accident' value='<?=$nm_cont_accident?>' />
			<?
				}else{
			?>
			<?=$nm_accident?>&nbsp;<?=$nm_cont_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">
					<?=$nm_area_user?>
				</td>
				<!-- 판매 희망지역 추가 -->
			</tr>
			<tr>
				<th>필수사진</th>
				<td colspan="3">
					<ul class="photo_list">
						<li>
							<img src="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_front?>" onclick="viewPhoto('<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_front?>')">
							<span>차량전면</span>
						</li>
						<li>
							<img src="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_back?>" onclick="viewPhoto('<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_back?>')">
							<span>차량후면</span>
						</li>
						<li>
							<img src="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_side1?>" onclick="viewPhoto('<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_side1?>')">
							<span>운전석 측면</span>
						</li>
						<li>
							<img src="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_side2?>" onclick="viewPhoto('<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_side2?>')">
							<span>조수석 측면</span>
						</li>
						<li>
							<img src="<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$nm_file_dashboard?>" onclick="viewPhoto('<?=UPLOAD_PATH_CAR?>nm_file_main/ratio/<?=$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>


        	<tr>
				<th>코멘트</th>
				<td colspan="3">
			<?
				if($able_modify) {
			?>
				<textarea name="modify_nm_guide" id="modify_nm_guide"><?=$nm_guide?></textarea>
			<?}
				else {
			?>
				<?=$nm_guide?>
			<?
				}
			?>

				</td>
			</tr>


<? if($ds_status_sale == "ZE"){ ?>
			<tr>
				<th>검차사진</th>
				<td colspan="3">
					<ul class="photo_list">
					<?
						for($i=1;$i<6;$i++){
							if(!empty($col["nm_file_chk".$i."_sale"])){
					?>
						<li><img src="<?=UPLOAD_PATH?>dealer/contract_step/<?=$cd_sale?>_detail/<?=$col["nm_file_chk".$i."_sale"]?>" onclick="viewPhoto('<?=UPLOAD_PATH?>dealer/contract_step/<?=$cd_sale?>_detail/<?=$col["nm_file_chk".$i."_sale"]?>')"></li>
					<?
							}
						}
					?>
					</ul>
				</td>
			</tr>
<? } ?>
		</table>

		<!-- layer popup3 -->
		<div class="layer_popup photo_popup">
			<img src="/img/sell/ic_car_photo1.png" id="photoBig" style="width:500px;">
			<div class="close" onclick="closeLayer('photo');">레이어팝업 닫기</div>
		</div>
		<!-- // layer popup3 -->

	</div>

	<div class="btn_right" style='padding-bottom:20px;'>
		<a href="#" class="rnd_btn ty1 blue" onclick="changeCarInfo('<?=$cd_car?>', '<?=$cd_sale?>');return false;">차량 정보 수정</a>
	</div>

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

	function viewPhoto(arg1){

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

		openLayer('photo'); return false;

	}

	function changeNmMileage(arg_cd_car, arg_cd_sale){

		$.post("proc.php", { mode:"changeMileage", cd_car: arg_cd_car, cd_sale: arg_cd_sale, nm_mileage: nm_mileage_val },function(data) {
			if(data=="Y"){
				alert("정상적으로 처리되었습니다.");
				return;
			}else if(data=="W") {
				alert("입찰대기, 입찰중 매물만 주행거리 수정이 가능합니다. ");
				return;
			}else if(data=="F") {
				alert("지정되지않은 요청입니다");
				return;
			}else{
				alert("정상적으로 처리되지 않았습니다.");
				return;
			}
		});

	}

	function changeCarInfo(arg_cd_car, arg_cd_sale) {
		var fieldlist = [["modify_cd_grade","등급"],["modify_ds_area","판매지역"],["modify_ds_accident","사고유무"],["modify_nm_mileage","주행거리"]] ;
		//,["modify_nm_guide","담당자코멘트"]

		if (!fnCheckForm(fieldlist)){
			return false;
		}

		var c = confirm("처리하시겠습니까?");
		if(c){
			var cd_grade = $("#modify_cd_grade").val();
			var ds_area = $("#modify_ds_area").val();
			var ds_accident = $("#modify_ds_accident").val();
			var nm_mileage_val = $("#modify_nm_mileage").val();
			var nm_guide_val = $("#modify_nm_guide").val();
			var nm_cont_accident = $("#modify_nm_cont_accident").val();


			$.post("proc.php", { mode:"changeCarInfo", cd_car: arg_cd_car, cd_sale: arg_cd_sale, cd_grade: cd_grade, ds_area: ds_area, ds_accident: ds_accident, nm_mileage: nm_mileage_val, nm_guide: nm_guide_val, nm_cont_accident : nm_cont_accident },function(data) {
				if(data=="Y"){
					alert("정상적으로 처리되었습니다.");
					return;
				}else if(data=="W") {
					alert("입찰대기, 입찰중 매물만 주행거리 수정이 가능합니다. ");
					return;
				}else if(data=="F") {
					alert("지정되지않은 요청입니다");
					return;
				}else{
					alert("정상적으로 처리되지 않았습니다.");
					return;
				}
			});
		}else{
			return false;
		}
	}

	$(function() {
		setCodeSelect("listGradeByModelSub","modify_cd_grade","car_grade","cd_grade",'<?=$cd_grade?>','선택하세요','<?=$cd_model_sub?>');
		setCodeSelect("listcode","modify_ds_accident", "car_master","ds_accident","<?=$ds_accident?>","선택하세요","");
		setCodeSelect("listcode","modify_ds_area", "member_master","ds_area","<?=$ds_area_sale?>","선택하세요","");
	});

</script>