echajoa/sell/proc0203.php

<?php
	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
	
	$s_cd_sale = $_SESSION['s_cd_sale'];
	$s_cd_car = $_SESSION['s_cd_car'];
	$s_nm_email = $_SESSION['s_nm_email'];
	$s_nm_name = $_SESSION['s_nm_name'];
	$s_nm_hp = $_SESSION['s_nm_hp'];
//	$s_ds_type = $_SESSION['s_ds_type'];
//	$s_ds_level = $_SESSION['s_ds_level'];
	$s_cd_user = $_SESSION['s_cd_user'];
	$s_car_update_ing = $_SESSION['s_car_update_ing'] ;

	$s_ds_company_bp = $_SESSION['s_ds_company_bp'] ;
	$s_ds_branch = $_SESSION['s_ds_branch'] ;

	$ds_area = trim(avoid_crack($_POST["ds_area"]));
	$ds_area_sub = trim(avoid_crack($_POST["ds_area_sub"]));

	if(empty($ds_area) || $ds_area == ""){
		$ds_area = $_SESSION['s_ds_area'];
	}
	if(empty($ds_area_sub) || $ds_area_sub == ""){
		$ds_area_sub = $_SESSION['s_ds_area_sub'];
	}

	$mode= trim(avoid_crack($_POST["mode"]));
	$cd_car = trim(avoid_crack($_POST["cd_car"]));
	$cd_model  = trim(avoid_crack($_POST["cd_model"]));
	$cd_model_sub  = trim(avoid_crack($_POST["cd_model_sub"]));
	$cd_grade  = trim(avoid_crack($_POST["cd_grade"]));
	$cd_brand  = trim(avoid_crack($_POST["cd_brand"]));
	$cd_category  = trim(avoid_crack($_POST["cd_category"]));
	$ds_type  = trim(avoid_crack($_POST["ds_type"]));
	$ds_year  = trim(avoid_crack($_POST["ds_year"]));
	$nm_mileage  = trim(avoid_crack($_POST["nm_mileage"]));
	$ds_driving_system  = trim(avoid_crack($_POST["ds_driving_system"]));
	$ds_transmission  = trim(avoid_crack($_POST["ds_transmission"]));
	$ds_oil  = trim(avoid_crack($_POST["ds_oil"]));
	$nm_gearbox  = trim(avoid_crack($_POST["nm_gearbox"]));
	$ds_accident  = trim(avoid_crack($_POST["ds_accident"]));
	$nm_cont_accident  = trim(avoid_crack($_POST["nm_cont_accident"]));
	$nm_regdate  = trim(avoid_crack($_POST["nm_regdate"]));
	$ds_sales  = trim(avoid_crack($_POST["ds_sales"]));
	$nm_btitle  = trim(avoid_crack($_POST["nm_btitle"]));
	$nm_stitle  = trim(avoid_crack($_POST["nm_stitle"]));
	$nm_ltitle  = trim(avoid_crack($_POST["nm_ltitle"]));
	$ds_open  = trim(avoid_crack($_POST["ds_open"]));
	$ds_status  = trim(avoid_crack($_POST["ds_status"]));
	$nm_price  = trim(avoid_crack($_POST["nm_price"]));
	$nm_name  = trim(avoid_crack($_POST["nm_name"]));
	$nm_color = trim(avoid_crack($_POST["nm_color"]));
	$nm_incolor = trim(avoid_crack($_POST["nm_incolor"]));
	$nm_cc = trim(avoid_crack($_POST["nm_cc"]));
	$nm_number = trim(avoid_crack($_POST["nm_number"]));
	$ds_trade = trim(avoid_crack($_POST["ds_trade"]));
	$ds_main = trim(avoid_crack($_POST["ds_main"]));
	
	$nm_regdate_yyyy  = trim(avoid_crack($_POST["nm_regdate_yyyy"]));
	$nm_regdate_mm  = trim(avoid_crack($_POST["nm_regdate_mm"]));
	$nm_regdate_dd  = trim(avoid_crack($_POST["nm_regdate_dd"]));

	$nm_cont = addslashes($_POST["nm_cont"]);
	$nm_guide = addslashes($_POST["nm_guide"]);
	
	$upload_file_name = $_POST["upload_file_name"];
	$upload_file_report_name = $_POST["upload_file_report_name"];
	$upload_file_report_back_name = $_POST["upload_file_report_back_name"];

	$upload_file_main_name = $_POST["upload_file_main_name"];
	$upload_file_list_name = $_POST["upload_file_list_name"];

	//성능점검 
	$nm_chk_carno = trim(avoid_crack($_POST["nm_chk_carno"]));
	$nm_chk_cnt = trim(avoid_crack($_POST["nm_chk_cnt"]));
	$nm_chk_s1 = trim(avoid_crack($_POST["nm_chk_s1"]));
	$nm_chk_s2 = trim(avoid_crack($_POST["nm_chk_s2"]));
	$nm_chk_s3 = trim(avoid_crack($_POST["nm_chk_s3"]));
	$nm_chk_s4 = trim(avoid_crack($_POST["nm_chk_s4"]));
	$nm_chk_advisor = trim(avoid_crack($_POST["nm_chk_advisor"]));
	$nm_chk_date = trim(avoid_crack($_POST["nm_chk_date"]));
	$nm_chk_p1 = trim(avoid_crack($_POST["nm_chk_p1"]));
	$nm_chk_p2 = trim(avoid_crack($_POST["nm_chk_p2"]));
	$nm_chk_p3 = trim(avoid_crack($_POST["nm_chk_p3"]));
	$nm_file_chk = $_POST["nm_file_chk"];
	//사고이력조회 
	$nm_act_chgno = trim(avoid_crack($_POST["nm_act_chgno"]));
	$nm_act_chgnm = trim(avoid_crack($_POST["nm_act_chgnm"]));
	$nm_act_s1 = trim(avoid_crack($_POST["nm_act_s1"]));
	$nm_act_s2 = trim(avoid_crack($_POST["nm_act_s2"]));
	$nm_act_s3 = trim(avoid_crack($_POST["nm_act_s3"]));
	$nm_act_s4 = trim(avoid_crack($_POST["nm_act_s4"]));
	$nm_act_my = trim(avoid_crack($_POST["nm_act_my"]));
	$nm_act_my_amt =trim(avoid_crack($_POST["nm_act_my_amt"]));
	$nm_act_other = trim(avoid_crack($_POST["nm_act_other"]));
	$nm_actr_other_amt = trim(avoid_crack($_POST["nm_actr_other_amt"]));
	$nm_act_searchdt = trim(avoid_crack($_POST["nm_act_searchdt"]));
	$nm_act_cnt= trim(avoid_crack($_POST["nm_act_cnt"]));
	$nm_act_general_spec  = trim(avoid_crack($_POST["nm_act_general_spec"]));
	$nm_act_use_record  = trim(avoid_crack($_POST["nm_act_use_record"]));
	$nm_act_use_record_lend  = trim(avoid_crack($_POST["nm_act_use_record_lend"]));
	$nm_act_use_record_biz  = trim(avoid_crack($_POST["nm_act_use_record_biz"]));
	$nm_act_use_record_official  = trim(avoid_crack($_POST["nm_act_use_record_official"]));
	$nm_act_ins_loss  = trim(avoid_crack($_POST["nm_act_ins_loss"]));
	$nm_act_ins_wet  = trim(avoid_crack($_POST["nm_act_ins_wet"]));
	$nm_act_ins_robbery  = trim(avoid_crack($_POST["nm_act_ins_robbery"]));
	$nm_file_act = $_POST["nm_file_act"];


	$no_sort = $_POST["no_sort"];
	
	$cd_userid = $_SESSION[admin_cd_userid];
	$PageNo = trim(avoid_crack($_POST["PageNo"]));
	

	$nm_recommend = trim(avoid_crack($_POST["nm_recommend"]));

	//$upload_path = $_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR;	
	$upload_path = $_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR;	
	//$upload_path = $_SERVER['DOCUMENT_ROOT']."/uploadfile/se2/";	
	
	
	$ds_cate = trim(avoid_crack($_POST["ds_cate"]));
	
	if(!$ds_cate) $ds_cate='A0';
	
	$ds_logo = trim(avoid_crack($_POST["ds_logo"]));

	$cd_sale = trim(avoid_crack($_POST["cd_sale"]));

	switch($mode) {
//게시판 글쓰기  
		
		//게시판 글쓰기  
		case "Add" :
			
		//print_r($_REQEUST);
			/*if (is_uploaded_file($_FILES['nm_file_report_back']['tmp_name'])) { 
				if($_FILES['nm_file_report_back']['size'] > 0 ){
					$upload_file_report_back_name = upload($_FILES['nm_file_report_back'],$upload_path, 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));
				
					if($upload_file_report_back_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}
				}
			}
				
			
			if (is_uploaded_file($_FILES['nm_file_report']['tmp_name'])) {
				if($_FILES['nm_file_report']['size'] > 0 ){
					$upload_file_report_name = upload($_FILES['nm_file_report'],$upload_path, 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));
					if($upload_file_report_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}
				}
			}*/

			if (is_uploaded_file($_FILES['nm_file_chk']['tmp_name'])) {
				if($_FILES['nm_file_chk']['size'] > 0 ){
					$upload_file_chk_name = upload($_FILES['nm_file_chk'],$upload_path."nm_file_chk/", 800, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));
					if($upload_file_chk_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}
				}
			}

			if (is_uploaded_file($_FILES['nm_file_act']['tmp_name'])) {
				if($_FILES['nm_file_act']['size'] > 0 ){
					$upload_file_act_name = upload($_FILES['nm_file_act'],$upload_path."nm_file_act/", 800, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));
					if($upload_file_act_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}
				}
			}

			$sql="insert into car_master
						(cd_model, cd_grade, ds_type, ds_year, nm_mileage , nm_price, nm_name
						, ds_driving_system, ds_oil, nm_gearbox , nm_color, nm_incolor, ds_accident
						, nm_cont_accident 
						, ds_transmission 
						, nm_regdate, ds_sales , nm_btitle, nm_stitle, nm_cont , nm_file_report , nm_file_report_back
						, nm_file_main, nm_file_list, ds_logo,  cd_brand, cd_category
						, ds_open, ds_status, dt_insert, nm_insert, dt_update, nm_update, ds_delind
						, nm_number, nm_cc, ds_trade, nm_regdate_yyyy, nm_regdate_mm, nm_regdate_dd, nm_guide, ds_main , nm_ltitle , ds_cate
						, nm_chk_178_q1 
						, nm_chk_178_q2 
						, nm_chk_178_q3 
						, nm_chk_178_q4 
						, nm_chk_178_q5 
						, nm_chk_178_q6 
						, nm_chk_178_q7 
						, nm_chk_178_q8 
						, nm_chk_178_q9 
						, nm_chk_178_q10
						, nm_chk_178_q11
						, nm_chk_178_q12
						, nm_chk_178_q13
						, nm_chk_carno , nm_chk_cnt , nm_chk_s1 , nm_chk_s2 , nm_chk_s3, nm_chk_s4, nm_chk_advisor, nm_chk_date, nm_chk_p1, nm_chk_p2 , nm_chk_p3, nm_file_chk 
						, 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
						, nm_act_searchdt , nm_act_cnt, nm_file_act 
						)
					values
						('$cd_model', '$cd_grade' , '$ds_type', '$ds_year', '$nm_mileage' , '$nm_price', '$nm_name'
						, '$ds_driving_system', '$ds_oil', '$nm_gearbox', '$nm_color' , '$nm_incolor', '$ds_accident' 
						, '$nm_cont_accident' 
						, '$ds_transmission' 
						, '$nm_regdate','$ds_sales','$nm_btitle','$nm_stitle','$nm_cont','$upload_file_report_name','$upload_file_report_back_name'
						, '$upload_file_main_name','$upload_file_list_name', '$ds_logo', '$cd_brand', '$cd_category'
						, '$ds_open','$ds_status',now(),'$cd_userid', now(), '$cd_userid','N'
						, '$nm_number','$nm_cc','$ds_trade','$nm_regdate_yyyy','$nm_regdate_mm','$nm_regdate_dd','$nm_guide','$ds_main','$nm_ltitle' ,'$ds_cate'
						, '$nm_chk_178_q1' 
						, '$nm_chk_178_q2' 
						, '$nm_chk_178_q3' 
						, '$nm_chk_178_q4' 
						, '$nm_chk_178_q5' 
						, '$nm_chk_178_q6' 
						, '$nm_chk_178_q7' 
						, '$nm_chk_178_q8' 
						, '$nm_chk_178_q9' 
						,  '$nm_chk_178_q10' 
						,  '$nm_chk_178_q11' 
						,  '$nm_chk_178_q12' 
						,  '$nm_chk_178_q13' 
						, '$nm_chk_carno' , '$nm_chk_cnt' , '$nm_chk_s1' , '$nm_chk_s2' , '$nm_chk_s3', '$nm_chk_s4', '$nm_chk_advisor', '$nm_chk_date', '$nm_chk_p1', '$nm_chk_p2' , '$nm_chk_p3', '$upload_file_chk_name'
						, '$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'
						, '$nm_act_searchdt' , '$nm_act_cnt', '$upload_file_act_name')";
	
			$result  = mysql_query($sql,$connect);		
			$cd_car  = mysql_insert_id();
			
			
			if($cd_car>0){

				//차량옵션정보 등록 
				fnSetCarDtlInfo($cd_car,$connect);
				fnSetCarImgCreate($cd_car,$connect);	

			}
			
			if ($result) {
				echo "200";
				//AlertRedirect("입력 완료되었습니다.","./list.php?ds_cate=".$ds_cate); 

			}else{
				echo "600";
				//AlertRedirect("입력 실패 하였습니다.","./list.php?ds_cate=".$ds_cate);  
			}
		break;
		
		// update 모드시 파일 업로드
		case "AddFileAjax" :

			$result = fnSetCarImgCreateAjax($cd_car,$connect);	
			echo $result;
			/*if ($result) {
				echo "Y";
			}else{
				echo "N";
			}*/
		break;
	
		//글수정
		case "Update":


			//print_r($_REQUEST);
			/*
			
			if (is_uploaded_file($_FILES['nm_file_report']['tmp_name'])) { 
				if($_FILES['nm_file_report']['size'] > 0 ){
					$upload_file_report_name = upload($_FILES['nm_file_report'],$upload_path, 500, array('gif',  'jpeg', 'jpg','png','bmp','hwp','doc','ppt','docx','pptx' ,'pdf' ,'ttif'));
	
					if($upload_file_report_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}
				}
			}


			if (is_uploaded_file($_FILES['nm_file_report_back']['tmp_name'])) { 
				if($_FILES['nm_file_report_back']['size'] > 0 ){
					$upload_file_report_back_name = upload($_FILES['nm_file_report_back'],$upload_path, 50, array('gif',  'jpeg', 'jpg','png','bmp' ));
					
					if($upload_file_report_back_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}
				}
			}
			*/
			if (is_uploaded_file($_FILES['nm_file_report']['tmp_name'])) {
				if($_FILES['nm_file_report']['size'] > 0 ){
					$upload_file_report_name = upload($_FILES['nm_file_report'],$upload_path, 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));
					if($upload_file_report_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}
				}
			}
				
			if (is_uploaded_file($_FILES['nm_file_report_back']['tmp_name'])) { 
				if($_FILES['nm_file_report_back']['size'] > 0 ){
					$upload_file_report_back_name = upload($_FILES['nm_file_report_back'],$upload_path, 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));
				
					if($upload_file_report_back_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}
				}
			}

			if (is_uploaded_file($_FILES['nm_file_chk']['tmp_name'])) {
				if($_FILES['nm_file_chk']['size'] > 0 ){
					$upload_file_chk_name = upload($_FILES['nm_file_chk'],$upload_path."nm_file_chk/", 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));
					if($upload_file_chk_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}
				}
			}

			if (is_uploaded_file($_FILES['nm_file_act']['tmp_name'])) {
				if($_FILES['nm_file_act']['size'] > 0 ){
					$upload_file_act_name = upload($_FILES['nm_file_act'],$upload_path."nm_file_act/", 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));
					if($upload_file_act_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}
				}
			}

			$sql="update car_master 
					set 
						cd_model = '$cd_model'
						,cd_grade = '$cd_grade'
						,cd_category = '$cd_category'
						,cd_brand = '$cd_brand'
						,ds_type = '$ds_type'
						,ds_year = '$ds_year'
						,nm_name = '$nm_name'
						,nm_mileage = '$nm_mileage'
						,ds_driving_system = '$ds_driving_system'
						,ds_transmission = '$ds_transmission'
						,ds_oil = '$ds_oil'
						,nm_price = '$nm_price'
						,nm_gearbox = '$nm_gearbox'
						,nm_color = '$nm_color'
						,nm_incolor = '$nm_incolor'
						,ds_accident = '$ds_accident'
						,nm_cont_accident = '$nm_cont_accident'
						,nm_regdate = '$nm_regdate'
						,ds_sales = '$ds_sales'
						,nm_btitle = '$nm_btitle'
						,nm_stitle = '$nm_stitle'
						,nm_cont = '$nm_cont'				
						,ds_open = '$ds_open'
						,ds_logo = '$ds_logo'
						,ds_status = '$ds_status'
						,nm_file_report = '$upload_file_report_name'
						,nm_file_report_back = '$upload_file_report_back_name'
						,nm_file_main = '$upload_file_main_name'
						,nm_file_list = '$upload_file_list_name'
						,dt_update = now()
						,nm_update = '$cd_userid'
						,nm_number = '$nm_number'
						,nm_cc = '$nm_cc'
						,nm_ltitle = '$nm_ltitle'
						,ds_trade = '$ds_trade'
						,ds_cate = '$ds_cate'
						,ds_main= '$ds_main'
						,nm_regdate_yyyy = '$nm_regdate_yyyy'
						,nm_regdate_mm = '$nm_regdate_mm'
						,nm_regdate_dd = '$nm_regdate_dd'
						,nm_guide = '$nm_guide'
						, nm_chk_178_q1  = '$nm_chk_178_q1' 
						, nm_chk_178_q2  = '$nm_chk_178_q2' 
						, nm_chk_178_q3  = '$nm_chk_178_q3' 
						, nm_chk_178_q4  = '$nm_chk_178_q4' 
						, nm_chk_178_q5  = '$nm_chk_178_q5' 
						, nm_chk_178_q6  = '$nm_chk_178_q6' 
						, nm_chk_178_q7  = '$nm_chk_178_q7' 
						, nm_chk_178_q8  = '$nm_chk_178_q8' 
						, nm_chk_178_q9  = '$nm_chk_178_q9' 
						, nm_chk_178_q10  = '$nm_chk_178_q10' 
						, nm_chk_178_q11  = '$nm_chk_178_q11' 
						, nm_chk_178_q12  = '$nm_chk_178_q12' 
						, nm_chk_178_q13  = '$nm_chk_178_q13' 
						, nm_chk_carno  = '$nm_chk_carno'
						, nm_chk_cnt  = '$nm_chk_cnt'
						, nm_chk_s1 = '$nm_chk_s1'
						, nm_chk_s2 = '$nm_chk_s2'
						, nm_chk_s3 = '$nm_chk_s3'
						, nm_chk_s4 = '$nm_chk_s4'
						, nm_chk_advisor = '$nm_chk_advisor'
						, nm_chk_date = '$nm_chk_date'
						, nm_chk_p1 = '$nm_chk_p1'
						, nm_chk_p2 = '$nm_chk_p2'
						, nm_chk_p3 = '$nm_chk_p3'
						, nm_file_chk = case when '$upload_file_chk_name' = '' then nm_file_chk else '$upload_file_chk_name' end 
						, nm_act_chgno = '$nm_act_chgno'
						, nm_act_chgnm = '$nm_act_chgnm'
						, nm_act_s1 = '$nm_act_s1'
						, nm_act_s2 = '$nm_act_s2'
						, nm_act_s3 = '$nm_act_s3'
						, nm_act_s4 = '$nm_act_s4'
						, nm_act_my = '$nm_act_my'
						, nm_act_my_amt = '$nm_act_my_amt'
						, nm_act_other = '$nm_act_other'
						, nm_act_other_amt = '$nm_act_other_amt'
						, nm_act_searchdt  = '$nm_act_searchdt'
						, nm_act_cnt = '$nm_act_cnt'
						, nm_file_act = case when '$upload_file_act_name' = '' then nm_file_act else '$upload_file_act_name' end 
					WHERE  cd_car =$cd_car"; 
			

			$result  = mysql_query($sql,$connect);

			fnSetCarDtlInfo($cd_car,$connect);
			//fnSetCarImgCreate($cd_car,$connect);

			if ($result) {
				echo  "200";
				//Redirect("./form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); 
			}else{
				echo "600";
				//AlertRedirect("수정 실패 하였습니다.","./list.php&PageNo=$PageNo&ds_cate=".$ds_cate); 
			}
		break;

		//sale -> updateCar 내차팔기->차량정보 수정 승인 정보 셋팅(내차팔기 시 화면 사용을 위한 세션값)
		case "updateCar":

			$_SESSION['s_cd_car'] = $cd_car;
			$_SESSION['s_car_update_ing_cd_sale'] = trim(avoid_crack($_POST["cd_sale"]));
			$_SESSION['s_car_update_ing'] = "Y";

			echo "Y";
//			echo $cd_car."-".$_SESSION['s_cd_car']."-".$_SESSION['s_car_update_ing'];

		break;

		//sale -> sellNoMember
		case "sellNoMember":
//nm_name,nm_hp,nm_number

// 차량 별 진행중 차량 체크
				//현재 진행중인 차량 체크(회원/비회원)
				$table_name = " car_master c inner join sale_master s on (c.cd_car = s.cd_car and s.ds_delind = 'N' and s.ds_status in ('B0','C0','D0','E0','F0','Z0') and c.nm_number = '".$nm_number."' and (s.dt_approve is null or s.dt_approve >= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_SELL."' HOUR) ) ) ";

				$cnt = $dbCon->getOneDAO("count(*)",$table_name, $_whereis, 1);		
				if($cnt>0) {
					AlertBack("현재 등록되어 진행 중인 차량입니다.");
				}

			if($s_cd_car !="" || $s_cd_car != null){
				$sql="update car_master 
						set 
							  dt_update = now()
							, nm_update = '$cd_userid'
							, nm_number = '$nm_number'
						WHERE  cd_car = $s_cd_car"; 
				$result  = mysql_query($sql,$connect);
			}else{
				$sql="insert into car_master
							(nm_number, dt_insert, nm_insert, dt_update, nm_update, ds_delind
							)
						values
							('$nm_number', now(), '$cd_userid', now(), '$cd_userid','N'
							)";
		
				$result  = mysql_query($sql,$connect);		
				$cd_car  = mysql_insert_id();

				$_SESSION['s_cd_car'] = $cd_car;
			}

				$_SESSION['s_nomem_hp'] = $nm_hp;
				$_SESSION['s_nm_hp'] = $nm_hp;
				$_SESSION['s_nm_name']= $nm_name;
				$_SESSION['s_ds_area']= $ds_area;
				$_SESSION['s_ds_type']= "C0";	//$ds_type -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자
				$_SESSION['s_ds_usertype']= "C0";	//$ds_usertypeds_type 상세 사용 가능) -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자		예)(($row[ds_type] == "A0")?"D0":"D1");

			if ($result) {
				Redirect("sell_step1.php?mode=Step1"); 
//				AlertRedirect("저장 되었습니다.","sell_step2.php?mode=Step2"); 
			}else{
				AlertBack("등록 실패 하였습니다."); 
			}
		break;

		//sale -> sellNoMember
		case "sellNoMemberSearch":
//nm_name,nm_hp,nm_number

			if($s_cd_car !="" || $s_cd_car != null){
				$sql="update car_master 
						set 
							  dt_update = now()
							, nm_update = '$cd_userid'
							, nm_number = '$nm_number'
						WHERE  cd_car = $s_cd_car"; 
				$result  = mysql_query($sql,$connect);
			}else{
				$sql="insert into car_master
							(nm_number, dt_insert, nm_insert, dt_update, nm_update, ds_delind
							)
						values
							('$nm_number', now(), '$cd_userid', now(), '$cd_userid','N'
							)";
		
				$result  = mysql_query($sql,$connect);		
				$cd_car  = mysql_insert_id();

				$_SESSION['s_cd_car'] = $cd_car;
				$_SESSION['s_nomem_hp'] = $nm_hp;
				$_SESSION['s_nm_hp'] = $nm_hp;
				$_SESSION['s_nm_name']= $nm_name;
				$_SESSION['s_ds_area']= $ds_area;
				$_SESSION['s_ds_type']= "C0";	//$ds_type -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자
				$_SESSION['s_ds_usertype']= "C0";	//$ds_usertypeds_type 상세 사용 가능) -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자		예)(($row[ds_type] == "A0")?"D0":"D1");

			}

			if ($result) {
				Redirect("sell_step1.php?mode=Step1"); 
//				AlertRedirect("저장 되었습니다.","sell_step2.php?mode=Step2"); 
			}else{
				AlertBack("등록 실패 하였습니다."); 
			}
		break;

		//sale -> Step1
		case "Step1":
//nm_number,cd_brand,cd_model,cd_grade,nm_regdate_yyyy,nm_regdate_mm,ds_year,nm_cc,ds_transmission,ds_oil,nm_color,nm_mileage,ds_accident

			if($s_cd_car !="" || $s_cd_car != null){
				$sql="update car_master 
						set 
							cd_model = '$cd_model'
							,cd_model_sub = '$cd_model_sub'
							,cd_grade = '$cd_grade'
							,cd_category = '$cd_category'
							,cd_brand = '$cd_brand'
							,ds_type = '$ds_type'
							,ds_year = '$ds_year'
							,nm_mileage = '$nm_mileage'
							,ds_transmission = '$ds_transmission'
							,ds_oil = '$ds_oil'
							,nm_color = '$nm_color'
							,ds_accident = '$ds_accident'
							,nm_cont_accident = '$nm_cont_accident'
							,ds_open = '$ds_open'
							,ds_status = '$ds_status'
							,dt_update = now()
							,nm_update = '$cd_userid'
							,nm_name = '$nm_name'
							,nm_number = '$nm_number'
							,nm_cc = '$nm_cc'
							,nm_regdate_yyyy = '$nm_regdate_yyyy'
							,nm_regdate_mm = '$nm_regdate_mm'
							,nm_regdate_dd = '$nm_regdate_dd'
						WHERE  cd_car = $s_cd_car"; 
				$result  = mysql_query($sql,$connect);
			}else{

/* 차량/판매자(회원/비회원) 별 진행중 차량 체크
				//현재 진행중인 차량 체크(회원/비회원)
				$table_name = " car_master c inner join sale_master s on (c.cd_car = s.cd_car and s.ds_delind = 'N' and s.ds_status in ('B0','C0','D0','E0','F0','Z0')) ";

				if (empty($_SESSION[s_cd_user])){ //비회원
					$_whereis = "  c.nm_number = '".$nm_number."' and s.nm_name = '".$_SESSION['s_nm_name']."' and s.nm_hp = '".$_SESSION['s_nomem_hp']."' and (s.dt_approve is null or s.dt_approve >= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_SELL."' HOUR) ) ";
				}else{	//회원
					$_whereis = "  c.nm_number = '".$nm_number."' and s.cd_user = '".$_SESSION[s_cd_user]."' and (s.dt_approve is null or s.dt_approve >= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_SELL."' HOUR) ) ";
				}
*/

// 차량 별 진행중 차량 체크
				//현재 진행중인 차량 체크(회원/비회원)
				$table_name = " car_master c inner join sale_master s on (c.cd_car = s.cd_car and s.ds_delind = 'N' and s.ds_status in ('B0','C0','D0','E0','F0','Z0') and c.nm_number = '".$nm_number."' and (s.dt_approve is null or s.dt_approve >= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_SELL."' HOUR) ) ) ";

				$cnt = $dbCon->getOneDAO("count(*)",$table_name, $_whereis, 1);		
				if($cnt>0) {
					AlertRedirect("현재 등록되어 진행 중인 차량입니다.","sell_step1.php?mode=Step1"); 
				}

				$sql="insert into car_master
							(cd_model, cd_model_sub, cd_grade, cd_category, cd_brand, ds_type, ds_year, nm_mileage
							, ds_transmission, ds_oil
							, nm_color, ds_accident, nm_cont_accident
							, nm_name, nm_number, nm_cc
							, nm_regdate_yyyy, nm_regdate_mm, nm_regdate_dd
							, ds_open, ds_status, dt_insert, nm_insert, dt_update, nm_update, ds_delind
							)
						values
							('$cd_model', '$cd_model_sub', '$cd_grade', '$cd_category', '$cd_brand', '$ds_type', '$ds_year', '$nm_mileage' 
							, '$ds_transmission', '$ds_oil'
							, '$nm_color', '$ds_accident', '$nm_cont_accident'
							, '$nm_name', '$nm_number', '$nm_cc'
							, '$nm_regdate_yyyy', '$nm_regdate_mm', '$nm_regdate_dd'
							, '$ds_open','$ds_status',now(),'$cd_userid', now(), '$cd_userid','N'
							)";
		
				$result  = mysql_query($sql,$connect);		
				$cd_car  = mysql_insert_id();

				$_SESSION['s_cd_car']= $cd_car;

			}

			if ($result) {
				Redirect("sell_step2.php?mode=Step2"); 
//				AlertRedirect("저장 되었습니다.","sell_step2.php?mode=Step2"); 
			}else{
				AlertRedirect("저장 실패하였습니다.","sell_step1.php?mode=Step1"); 
			}
		break;

		//sale -> Step2
		case "Step2":
//nm_cont

			$sql="update car_master 
					set 
						nm_cont = '$nm_cont'
						,dt_update = now()
						,nm_update = '$cd_userid'
					WHERE  cd_car = $cd_car"; 
			$result  = mysql_query($sql,$connect);

			if ($result) {
				Redirect("sell_step3.php?mode=Step3"); 
//				AlertRedirect("저장 되었습니다.","sell_step3.php?mode=Step3"); 
			}else{
				AlertRedirect("저장 실패하였습니다.","sell_step2.php?mode=Step2"); 
			}
		break;

		//sale -> Step3
		case "Step3":
//nm_file_front,nm_file_back,nm_file_side1,nm_file_side2,nm_file_dashboard,nm_file_act,nm_recommend

// 차량 별 진행중 차량 체크
			if($s_car_update_ing != "Y"){		//차량 수정 중에는 진행중 차량 체크 안함
				//현재 진행중인 차량 체크(회원/비회원)
				$table_name = " car_master c inner join sale_master s on (c.cd_car = s.cd_car and s.ds_delind = 'N' and s.ds_status in ('B0','C0','D0','E0','F0','Z0') and c.cd_car = '".$cd_car."' and (s.dt_approve is null or s.dt_approve >= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_SELL."' HOUR) ) ) ";

				$cnt = $dbCon->getOneDAO("count(*)",$table_name, $_whereis, 1);		
				if($cnt>0) {
					Alert("현재 진행중인 차량이 존재합니다."); 
					die();
				}
			}

			$upload_path_ratio =  $upload_path."nm_file_main/ratio/";

			if (is_uploaded_file($_FILES['nm_file_front']['tmp_name'])) {
				if($_FILES['nm_file_front']['size'] > 0 ){
					$upload_file_front_name = upload($_FILES['nm_file_front'],$upload_path."nm_file_main/", 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));

					if($upload_file_front_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}

					$thumb_front = array(
								'o_path' => $upload_path.'nm_file_main/'.$upload_file_front_name, 'n_path' => $upload_path_ratio.$upload_file_front_name,
								'mode' => 'ratio', 'width' => CAR_THUM_WIDTH, 'height' => CAR_THUM_HEIGHT, 'preview_yn' => 'N','o_name' =>$upload_file_front_name
							);
					$thumb_front = getThumb($thumb_front);
				}
			}
				
			if (is_uploaded_file($_FILES['nm_file_back']['tmp_name'])) { 
				if($_FILES['nm_file_back']['size'] > 0 ){
					$upload_file_back_name = upload($_FILES['nm_file_back'],$upload_path."nm_file_main/", 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));
				
					if($upload_file_back_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}

					$thumb_back = array(
								'o_path' => $upload_path.'nm_file_main/'.$upload_file_back_name, 'n_path' => $upload_path_ratio.$upload_file_back_name,
								'mode' => 'ratio', 'width' => CAR_THUM_WIDTH, 'height' => CAR_THUM_HEIGHT, 'preview_yn' => 'N','o_name' =>$upload_file_back_name
							);
					$thumb_back = getThumb($thumb_back);
				}
			}

			if (is_uploaded_file($_FILES['nm_file_side1']['tmp_name'])) {
				if($_FILES['nm_file_side1']['size'] > 0 ){
					$upload_file_side1_name = upload($_FILES['nm_file_side1'],$upload_path."nm_file_main/", 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));

					if($upload_file_side1_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}

					$thumb_side1 = array(
								'o_path' => $upload_path.'nm_file_main/'.$upload_file_side1_name, 'n_path' => $upload_path_ratio.$upload_file_side1_name,
								'mode' => 'ratio', 'width' => CAR_THUM_WIDTH, 'height' => CAR_THUM_HEIGHT, 'preview_yn' => 'N','o_name' =>$upload_file_side1_name
							);
					$thumb_side1 = getThumb($thumb_side1);
				}
			}

			if (is_uploaded_file($_FILES['nm_file_side2']['tmp_name'])) {
				if($_FILES['nm_file_side2']['size'] > 0 ){
					$upload_file_side2_name = upload($_FILES['nm_file_side2'],$upload_path."nm_file_main/", 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));

					if($upload_file_side2_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}

					$thumb_side2 = array(
								'o_path' => $upload_path.'nm_file_main/'.$upload_file_side2_name, 'n_path' => $upload_path_ratio.$upload_file_side2_name,
								'mode' => 'ratio', 'width' => CAR_THUM_WIDTH, 'height' => CAR_THUM_HEIGHT, 'preview_yn' => 'N','o_name' =>$upload_file_side2_name
							);
					$thumb_side2 = getThumb($thumb_side2);
				}
			}

			if (is_uploaded_file($_FILES['nm_file_dashboard']['tmp_name'])) {
				if($_FILES['nm_file_dashboard']['size'] > 0 ){
					$upload_file_dashboard_name = upload($_FILES['nm_file_dashboard'],$upload_path."nm_file_main/", 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));

					if($upload_file_dashboard_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}

					$thumb_dashboard = array(
								'o_path' => $upload_path.'nm_file_main/'.$upload_file_dashboard_name, 'n_path' => $upload_path_ratio.$upload_file_dashboard_name,
								'mode' => 'ratio', 'width' => CAR_THUM_WIDTH, 'height' => CAR_THUM_HEIGHT, 'preview_yn' => 'N','o_name' =>$upload_file_dashboard_name
							);
					$thumb_dashboard = getThumb($thumb_dashboard);
				}
			}
/*
			if (is_uploaded_file($_FILES['nm_file_act']['tmp_name'])) {
				if($_FILES['nm_file_act']['size'] > 0 ){
					$upload_file_act_name = upload($_FILES['nm_file_act'],$upload_path."nm_file_act/", 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));
					if($upload_file_act_name==false){
						AlertBack("첨부파일 업로드 실패 하였습니다."); 
						die();
					}
				}
			}
*/
//nm_file_front,nm_file_back,nm_file_side1,nm_file_side2,nm_file_dashboard,nm_file_act,nm_recommend
			//ds_status : 'A0' = 입력중, 'B0' = '입력완료', ...
			$sql="update car_master 
					set 
						  nm_file_front = case when '$upload_file_front_name' = '' then nm_file_front else '$upload_file_front_name' end 
						, nm_file_back = case when '$upload_file_back_name' = '' then nm_file_back else '$upload_file_back_name' end 
						, nm_file_side1 = case when '$upload_file_side1_name' = '' then nm_file_side1 else '$upload_file_side1_name' end 
						, nm_file_side2 = case when '$upload_file_side2_name' = '' then nm_file_side2 else '$upload_file_side2_name' end 
						, nm_file_dashboard = case when '$upload_file_dashboard_name' = '' then nm_file_dashboard else '$upload_file_dashboard_name' end 
						, nm_file_act = case when '$upload_file_act_name' = '' then nm_file_act else '$upload_file_act_name' end 
						, ds_status = 'B0'
						, dt_update = now()
						, nm_update = '$cd_userid'
					WHERE  cd_car = $cd_car"; 
			$result  = mysql_query($sql,$connect);

			if($result){

				//차량옵션정보 등록 
//				fnSetCarDtlInfo($cd_car,$connect);
				$result1 = fnSetCarImgCreate($cd_car,$connect);	
				if(!$result1){
					AlertBack("차량옵션 첨부파일 업로드 실패 하였습니다."); 
					die();
				}

			}
			
/*
	$s_cd_sale = $_SESSION['s_cd_sale'];
	$s_cd_car = $_SESSION['s_cd_car'];
	$s_nm_email = $_SESSION['s_nm_email'];
	$s_nm_name = $_SESSION['s_nm_name'];
	$s_nm_hp = $_SESSION['s_nm_hp'];
//	$s_ds_type = $_SESSION['s_ds_type'];
//	$s_ds_level = $_SESSION['s_ds_level'];
	$s_cd_user = $_SESSION['s_cd_user'];
*/

/*
			if($s_cd_sale !="" || $s_cd_sale != null){
				$sql="update car_sale 
						set 
							cd_user = '$s_cd_user'
							,nm_email = '$s_nm_email'
							,nm_name = '$s_nm_name'
							,nm_hp = '$s_nm_hp'
							,ds_status = 'A0'
							,dt_update = now()
							,nm_update = '$cd_userid'
						WHERE  cd_sale = $s_cd_sale and cd_car = $s_cd_car"; 
				$result  = mysql_query($sql,$connect);
			}else{
*/
			if($s_car_update_ing == "Y"){		//차량 수정 중에는 sale_master 등록/수정 불가
				$s_car_update_ing_cd_sale = $_SESSION['s_car_update_ing_cd_sale'];

				$sql="update sale_master 
						set 
							ds_status = 'C0'
							, nm_recommend = '$nm_recommend'
							, dt_update = now()
							, nm_update = '$cd_userid'
						WHERE  cd_sale = $s_car_update_ing_cd_sale 
							and ds_status = 'D0' ";		//반려 상태일 경우 차량 수정 완료 시 승인대기 상태로 변경(D0 -> C0)
		
				$result  = mysql_query($sql,$connect);		
				
				$_SESSION['s_car_update_ing'] = null;	//세션 값 삭제 : car 정보 수정 중
				$_SESSION['s_car_update_ing_cd_sale'] = null;

			}else{
				//$ds_usertype -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자
				if(!empty($s_cd_user)){
					$ds_usertype = "A0";
				}else if (!empty($_SESSION[s_nomem_hp])){
					$ds_usertype = "C0";
				}else{
					$ds_usertype = "";
				}


				$sql="insert into sale_master
							(cd_car, cd_user, nm_email, nm_name, nm_hp
							, nm_recommend, ds_company_bp, ds_branch, ds_area, ds_area_sub, ds_usertype, ds_status
							, dt_insert, nm_insert, dt_update, nm_update, ds_delind
							)
						values
							('$s_cd_car', '$s_cd_user', '$s_nm_email', '$s_nm_name', '$s_nm_hp'
							, '$nm_recommend', '$s_ds_company_bp', '$s_ds_branch', '$ds_area', '$ds_area_sub', '$ds_usertype', 'B0' 
							, now(), '$cd_userid', now(), '$cd_userid','N'
							)";
		
				$result  = mysql_query($sql,$connect);		
				$cd_sale  = mysql_insert_id();
			}

//				$_SESSION['s_cd_sale'] = $cd_sale;

//	등록 중이던 Session s_cd_car 삭제하여 새로운 차량 등록하도록 한다.
//				$_SESSION['s_cd_car'] = null;

/*
			}
*/

			if ($result) {
//				$_SESSION['s_cd_sale']= $cd_sale;
				echo "200";
			}else{
				echo "600";
			}
/*
			if ($result) {
				AlertRedirect("저장 되었습니다.","sell_step4.php?mode=Step4&cd_sale=$cd_sale"); 
			}else{
				AlertRedirect("저장 실패하였습니다.","sell_step3.php?mode=Step3"); 
			}
*/

		break;

		// 담당자코멘트 저장
		case "Guide":

			if($cd_car !="" || $cd_car != null){
				$sql="update car_master 
						set 
							nm_guide = '$nm_guide' 
							, dt_update = now()
							, nm_update = '$cd_userid'
						WHERE  cd_car = $cd_car"; 
				$result  = mysql_query($sql,$connect);
			}

			if ($result) {
				echo "200";
			}else{
				echo "600";
			}

		break;

		//보험처리 이력정보 등록 -> AddActIns
		case "AddActIns":
//nm_number,cd_brand,cd_model,cd_grade,nm_regdate_yyyy,nm_regdate_mm,ds_year,nm_cc,ds_transmission,ds_oil,nm_color,nm_mileage,ds_accident

			if($cd_car !="" || $cd_car != null){
				$sql="update car_master 
						set 
							nm_act_chgno = '$nm_act_chgno' 
							, nm_act_chgnm = '$nm_act_chgnm' 
							, nm_act_s1 = '$nm_act_s1' 
							, nm_act_s2 = '$nm_act_s2' 
							, nm_act_s3 = '$nm_act_s3' 
							, nm_act_s4 = '$nm_act_s4' 
							, nm_act_my = '$nm_act_my' 
							, nm_act_my_amt = '$nm_act_my_amt' 
							, nm_act_other = '$nm_act_other' 
							, nm_act_other_amt = '$nm_act_other_amt' 
							, nm_act_searchdt = '$nm_act_searchdt' 
							, nm_act_cnt = '$nm_act_cnt' 
							, nm_act_general_spec = '$nm_act_general_spec' 
							, nm_act_use_record = '$nm_act_use_record' 
							, nm_act_use_record_lend = '$nm_act_use_record_lend' 
							, nm_act_use_record_biz = '$nm_act_use_record_biz' 
							, nm_act_use_record_official = '$nm_act_use_record_official' 
							, nm_act_ins_loss = '$nm_act_ins_loss' 
							, nm_act_ins_wet = '$nm_act_ins_wet' 
							, nm_act_ins_robbery = '$nm_act_ins_robbery' 
							, nm_file_act = '$nm_file_act' 
							, nm_act_yn = 'Y' 
							, dt_act_insert = now() 
							, dt_update = now()
							, nm_update = '$cd_userid'
						WHERE  cd_car = $cd_car"; 
				$result  = mysql_query($sql,$connect);

				fnSetCarDtlInfo($cd_car,$connect);
			}

			if ($result) {
				echo "200";
			}else{
				echo "600";
			}

		break;

		//내차 팔기 반려 -> Return
		case "Return":

			if($cd_sale !="" || $cd_sale != null){
				$sql="update sale_master 
						set 
							nm_cont_return = '$nm_cont_return' 
							, ds_status = 'D0'
							, dt_update = now()
							, nm_update = '$cd_userid'
						WHERE  cd_sale = $cd_sale"; 
				$result  = mysql_query($sql,$connect);
			}

			if ($result) {
				echo "200";
			}else{
				echo "600";
			}

		break;

		//내차 팔기 승인 -> Confirm
		case "Confirm":

			if($cd_sale !="" || $cd_sale != null){
				$sql="update sale_master 
						set 
							ds_status = 'E0'
							, dt_approve = now()
							, dt_update = now()
							, nm_update = '$cd_userid'
						WHERE  cd_sale = $cd_sale"; 
				$result  = mysql_query($sql,$connect);
			}

			if ($result) {
				echo "200";
			}else{
				echo "600";
			}

		break;

		//sale -> Step2
		//글삭제 처리 
		case "Delete" :
	
			$sql = "update car_master set ds_delind='Y' ,  nm_update = '$cd_userid' , dt_update = now()  where cd_car='$cd_car'";
			$result  = mysql_query($sql,$connect);
			if ($result) {
				AlertRedirect("삭제 되었습니다.","list.php?PageNo=$PageNo&cd_category=".$cd_category); 
	
			 }else{
				AlertRedirect("삭제 실패하였습니다.","list.php?PageNo=$PageNo&cd_category=".$cd_category); 
			 }			 
		break;
		
		//리스트 Number 수정 처리 
		case "CarImgCreate" :
			
			$result = fnSetCarImgCreate($cd_car,$connect);
			
			if ($result) {
				Redirect("sell_step3.php?mode=Step3"); 
//				Redirect("form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); 
	
			 }else{
				AlertBack("처리 실패 하였습니다."); 
//				AlertRedirect("파일등록을 실패하였습니다.","form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); 
			 }
		break;
		
	
		case "CarImgDelete" :
			
			$sql = "update  car_file set ds_delind='Y' ,  nm_update = '$cd_userid' , dt_update = now()  where cd_file = '$cd_file' AND cd_car='$cd_car'";
			$result  = mysql_query($sql,$connect);
			
			if ($result) {
				Redirect("sell_step3.php?mode=Step3"); 
//				Redirect("form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); 
	
			 }else{
				AlertBack("처리 실패 하였습니다."); 
//				AlertRedirect("처리 실패 하였습니다.","form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); 
			 }
		break;	

		case "AllCarImgDelete" :
			
			$sql = "update  car_file set ds_delind='Y' ,  nm_update = '$cd_userid' , dt_update = now()  where cd_car='$cd_car'";
			$result  = mysql_query($sql,$connect);
			
			if ($result) {
				Redirect("sell_step3.php?mode=Step3"); 
//				Redirect("form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); 
	
			 }else{
				AlertBack("처리 실패 하였습니다."); 
//				AlertRedirect("처리 실패 하였습니다.","form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); 
			 }
		break;	
	
		case "UpdateSortFile" :
			
			$sql = "update  car_file set no_sort='$no_sort' ,  nm_update = '$cd_userid' , dt_update = now()  where cd_file = '$cd_file' AND cd_car='$cd_car'";
			$result  = mysql_query($sql,$connect);
			
			if ($result) {
				Redirect("sell_step3.php?mode=Step3"); 
//				Redirect("form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); 
	
			 }else{
				AlertBack("처리 실패 하였습니다."); 
//				AlertRedirect("처리 실패 하였습니다.","form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); 
			 }
		break;	

		case "UpdateSortFileAjax" :

			$cngsorts = explode ( "," , $cngsort);

			$result = true;
			for($k = 0; $k<count($cngsorts);$k++){
				if($result){
					if($k == 0){
						$fst_file_name = @mysql_result(mysql_query("select nm_file from car_file  Where cd_file = '$cngsorts[$k]' AND cd_car='$cd_car'"),0,0);
						$sqlThum = "update  car_master set nm_file_main='$fst_file_name',nm_file_list = '$fst_file_name' ,  nm_update = '$cd_userid' , dt_update = now()  where cd_car='$cd_car'";
						$mainResult  = mysql_query($sqlThum,$connect);
					}
					$sql = "update  car_file set no_sort='$k' ,  nm_update = '$cd_userid' , dt_update = now()  where cd_file = '$cngsorts[$k]' AND cd_car='$cd_car';";
					$result = mysql_query($sql,$connect);
				}
			}

			if ($result) {
				echo "Y";
			}else{
				echo "N";
			}

		break;
		
		case "DelFileReport":
			$sql = "update  car_master set nm_file_report='' ,  nm_update = '$cd_userid' , dt_update = now()  where cd_car='$cd_car'";
			$result  = mysql_query($sql,$connect);
			
			if ($result) {
				Redirect("sell_step3.php?mode=Step3"); 
//				Redirect("form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); 
	
			 }else{
				AlertBack("처리 실패 하였습니다."); 
//				AlertRedirect("처리 실패 하였습니다.","form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); 
			 }
		break;
			
		case "DelFileReportBack":
				$sql = "update  car_master set nm_file_report_back='' ,  nm_update = '$cd_userid' , dt_update = now()  where cd_car='$cd_car'";
			$result  = mysql_query($sql,$connect);
			
			if ($result) {
				Redirect("sell_step3.php?mode=Step3"); 
//				Redirect("form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); 
	
			 }else{
				AlertBack("처리 실패 하였습니다."); 
//				AlertRedirect("처리 실패 하였습니다.","form.php?cd_car=$cd_car&PageNo=$PageNo&ds_cate=".$ds_cate); 
			 }
		break;
		
		
		default :
			AlertRedirect("지정되지않은 요청입니다","index.php&ds_cate=".$ds_cate); 
		break;
	}
	
	function fnSetCarImgCreate($cd_car,$connect){

		$upload_path = $_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR.$cd_car."_detail/";			
		$blnResult = true;
		$cd_userid =  $_SESSION[admin_cd_userid];
		
		//먼지 모르겟는데 더
		$sql = "delete from car_file  where cd_car='$cd_car' and  nm_mime=''";
		$result  = mysql_query($sql,$connect);
		
		
		$maxVal = @mysql_result(mysql_query("select ifnull(max(no_sort),0)+1 from car_file  Where ds_delind='N' and cd_car = '$cd_car'"),0,0);
		if($maxVal==""){$maxVal=1;}
		for($k = 0; $k<count($_FILES["file"][size]);$k++){
					
				
				if (is_uploaded_file($_FILES['file']['tmp_name'][$k])) {
				
					if($_FILES['file']['size'][$k] > 0 ){
						$fileObj = array();
						$fileObj["tmp_name"] = $_FILES["file"]["tmp_name"][$k];
						$fileObj["name"] = $_FILES["file"]["name"][$k];
						$fileObj["error"] = $_FILES["file"]["error"][$k];
						$fileObj["size"] = $_FILES["file"]["size"][$k];
						$fileObj["type"] =  $_FILES["file"]["type"][$k];
						
						$upload_path =  $_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR.$cd_car."_detail/";
									
						$upload_file_name = upload($fileObj,$upload_path, 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));
						$thumb1 = array(
									'o_path' => $upload_path.$upload_file_name, 'n_path' => $upload_path.'ratio_'.$upload_file_name,
									'mode' => 'ratio', 'width' => CAR_THUM_WIDTH, 'height' => CAR_THUM_HEIGHT, 'preview_yn' => 'N','o_name' =>'ratio_'.$upload_file_name
								);
						$thumb1 = getThumb($thumb1);
						
						if(empty($thumb1['fileName']))		$thumb1['fileName'] = '';
						$upload_file_name = $thumb1['fileName'];
						$nm_size = $_FILES['file']['size'][$k];
						$nm_mime = $_FILES['file']['type'][$k];
						
						if($upload_file_name=="" || $nm_mime==""){
							$blnResult =  false;
						}else{
							if($k == 0 ){
								
								$upload_path2 = $_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR.$cd_car."_detail/";
								$upload_file_list_name = upload($fileObj,$upload_path2, 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));
								
								$thumb2 = array(
									'o_path' => $upload_path2.$upload_file_list_name, 'n_path' => $upload_path2.'ratio_'.$upload_file_list_name,
									'mode' => 'ratio', 'width' => CAR_THUM2_WIDTH, 'height' => CAR_THUM2_HEIGHT, 'preview_yn' => 'N','o_name' =>'ratio_'.$upload_file_list_name
								);
								$thumb2 = getThumb($thumb2);
								
								if(empty($thumb2['fileName']))		$thumb2['fileName'] = '';
								$upload_file_list_name = $thumb2['fileName'];
								
								$sqlThum = "update  car_master set nm_file_main='$upload_file_list_name',nm_file_list = '$upload_file_list_name' ,  nm_update = '$cd_userid' , dt_update = now()  where cd_car='$cd_car'";
								$mainResult  = mysql_query($sqlThum,$connect);
							}
							
							if($nm_mime!=="" && $blnResult){
								$sql = "insert into car_file(
									cd_car, nm_file, nm_size, nm_mime, no_sort, 
									dt_insert, nm_insert, dt_update, nm_update, ds_delind) VALUES 
									('$cd_car','$upload_file_name','$nm_size','$nm_mime', '$maxVal' , now(),'$cd_userid',now(),'$cd_userid','N')";
								$blnResult  = mysql_query($sql,$connect);
								$maxVal++;	
								
							}
							
						}
						$upload_file_name = "";
					}
			}	
			
		}
		return $blnResult;
	}
	
	// 이미지 update ajax
	function fnSetCarImgCreateAjax($cd_car,$connect){

		$upload_path = $_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR.$cd_car."_detail/";
		$blnResult = true;
		$cd_userid =  $_SESSION[admin_cd_userid];

		
		$maxVal = @mysql_result(mysql_query("select ifnull(max(no_sort),0)+1 from car_file  Where ds_delind='N' and cd_car = '$cd_car'"),0,0);
		if($maxVal==""){$maxVal=1;}
		$fileSrc = "";

		for($k = 0; $k<count($_FILES["file"][size]);$k++){
				
				if (is_uploaded_file($_FILES['file']['tmp_name'][$k])) {
				
					if($_FILES['file']['size'][$k] > 0 ){
						$fileObj = array();
						$fileObj["tmp_name"] = $_FILES["file"]["tmp_name"][$k];
						$fileObj["name"] = $_FILES["file"]["name"][$k];
						$fileObj["error"] = $_FILES["file"]["error"][$k];
						$fileObj["size"] = $_FILES["file"]["size"][$k];
						$fileObj["type"] =  $_FILES["file"]["type"][$k];
						
						$upload_path =  $_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR.$cd_car."_detail/";
									
						$upload_file_name = upload($fileObj,$upload_path, 500, array('gif',  'jpeg', 'jpg','png','bmp' ,'ttif'));
						$thumb1 = array(
									'o_path' => $upload_path.$upload_file_name, 'n_path' => $upload_path.'ratio_'.$upload_file_name,
									'mode' => 'ratio', 'width' => CAR_THUM_WIDTH, 'height' => CAR_THUM_HEIGHT, 'preview_yn' => 'N','o_name' =>'ratio_'.$upload_file_name
								);
						$thumb1 = getThumb($thumb1);
						
						if(empty($thumb1['fileName']))		$thumb1['fileName'] = '';
						$upload_file_name = $thumb1['fileName'];
						$nm_size = $_FILES['file']['size'][$k];
						$nm_mime = $_FILES['file']['type'][$k];
						

						$cd_file_var = "";
						if($upload_file_name=="" || $nm_mime==""){
							$blnResult =  false;
						}else{
							if($nm_mime!=="" && $blnResult){
								$sql = "insert into car_file(
									cd_car, nm_file, nm_size, nm_mime, no_sort, 
									dt_insert, nm_insert, dt_update, nm_update, ds_delind) VALUES 
									('$cd_car','$upload_file_name','$nm_size','$nm_mime', '$maxVal' , now(),'$cd_userid',now(),'$cd_userid','N')";
								$blnResult  = mysql_query($sql,$connect);
								if($blnResult){
									$cd_file_var = @mysql_result(mysql_query("select concat(concat(nm_file,'||'),cd_file) test from car_file  Where no_sort='$maxVal' and cd_car = '$cd_car' and ds_delind = 'N'"),0,0);
								}
								$maxVal++;
							}
						}
						$upload_file_name = "";

						$fileSrc = UPLOAD_PATH_CAR.$cd_car."_detail/".$cd_file_var;
					}
			}	
			
		}
		return $fileSrc;
	}
	
	//차량 내외부 옵션 저장 
	function fnSetCarDtlInfo($cd_car,$connect){
		
		//외관/내장
		$ds_g1_01= trim(avoid_crack($_POST["ds_g1_01"]));
		$ds_g1_02= trim(avoid_crack($_POST["ds_g1_02"]));
		$ds_g1_03= trim(avoid_crack($_POST["ds_g1_03"]));
		$ds_g1_04= trim(avoid_crack($_POST["ds_g1_04"]));
		$ds_g1_05= trim(avoid_crack($_POST["ds_g1_05"]));
		$ds_g1_06= trim(avoid_crack($_POST["ds_g1_06"]));
		$ds_g1_07= trim(avoid_crack($_POST["ds_g1_07"]));
		$ds_g1_08= trim(avoid_crack($_POST["ds_g1_08"]));
		$ds_g1_09= trim(avoid_crack($_POST["ds_g1_09"]));
		$ds_g1_10= trim(avoid_crack($_POST["ds_g1_10"]));
		$ds_g1_11= trim(avoid_crack($_POST["ds_g1_11"]));
		$ds_g1_12= trim(avoid_crack($_POST["ds_g1_12"]));
		$ds_g1_13= trim(avoid_crack($_POST["ds_g1_13"]));
		$ds_g1_14= trim(avoid_crack($_POST["ds_g1_14"]));
		$ds_g1_15= trim(avoid_crack($_POST["ds_g1_15"]));
		//안전
		$ds_g2_01= trim(avoid_crack($_POST["ds_g2_01"]));
		$ds_g2_02= trim(avoid_crack($_POST["ds_g2_02"]));
		$ds_g2_03= trim(avoid_crack($_POST["ds_g2_03"]));
		$ds_g2_04= trim(avoid_crack($_POST["ds_g2_04"]));
		$ds_g2_05= trim(avoid_crack($_POST["ds_g2_05"]));
		$ds_g2_06= trim(avoid_crack($_POST["ds_g2_06"]));
		$ds_g2_07= trim(avoid_crack($_POST["ds_g2_07"]));
		$ds_g2_08= trim(avoid_crack($_POST["ds_g2_08"]));
		$ds_g2_09= trim(avoid_crack($_POST["ds_g2_09"]));
		$ds_g2_10= trim(avoid_crack($_POST["ds_g2_10"]));
		$ds_g2_11= trim(avoid_crack($_POST["ds_g2_11"]));
		$ds_g2_12= trim(avoid_crack($_POST["ds_g2_12"]));
		$ds_g2_13= trim(avoid_crack($_POST["ds_g2_13"]));
		$ds_g2_14= trim(avoid_crack($_POST["ds_g2_14"]));
		$ds_g2_15= trim(avoid_crack($_POST["ds_g2_15"]));
		//편의멀티미디어
		$ds_g3_01= trim(avoid_crack($_POST["ds_g3_01"]));
		$ds_g3_02= trim(avoid_crack($_POST["ds_g3_02"]));
		$ds_g3_03= trim(avoid_crack($_POST["ds_g3_03"]));
		$ds_g3_04= trim(avoid_crack($_POST["ds_g3_04"]));
		$ds_g3_05= trim(avoid_crack($_POST["ds_g3_05"]));
		$ds_g3_06= trim(avoid_crack($_POST["ds_g3_06"]));
		$ds_g3_07= trim(avoid_crack($_POST["ds_g3_07"]));
		$ds_g3_08= trim(avoid_crack($_POST["ds_g3_08"]));
		$ds_g3_09= trim(avoid_crack($_POST["ds_g3_09"]));
		$ds_g3_10= trim(avoid_crack($_POST["ds_g3_10"]));
		$ds_g3_11= trim(avoid_crack($_POST["ds_g3_11"]));
		$ds_g3_12= trim(avoid_crack($_POST["ds_g3_12"]));
		$ds_g3_13= trim(avoid_crack($_POST["ds_g3_13"]));
		$ds_g3_14= trim(avoid_crack($_POST["ds_g3_14"]));
		$ds_g3_15= trim(avoid_crack($_POST["ds_g3_15"]));
		//시트 
		$ds_g4_01= trim(avoid_crack($_POST["ds_g4_01"]));
		$ds_g4_02= trim(avoid_crack($_POST["ds_g4_02"]));
		$ds_g4_03= trim(avoid_crack($_POST["ds_g4_03"]));
		$ds_g4_04= trim(avoid_crack($_POST["ds_g4_04"]));
		$ds_g4_05= trim(avoid_crack($_POST["ds_g4_05"]));
		$ds_g4_06= trim(avoid_crack($_POST["ds_g4_06"]));
		$ds_g4_07= trim(avoid_crack($_POST["ds_g4_07"]));
		$ds_g4_08= trim(avoid_crack($_POST["ds_g4_08"]));
		$ds_g4_09= trim(avoid_crack($_POST["ds_g4_09"]));
		$ds_g4_10= trim(avoid_crack($_POST["ds_g4_10"]));
		$ds_g4_11= trim(avoid_crack($_POST["ds_g4_11"]));
		$ds_g4_12= trim(avoid_crack($_POST["ds_g4_12"]));
		$ds_g4_13= trim(avoid_crack($_POST["ds_g4_13"]));
		$ds_g4_14= trim(avoid_crack($_POST["ds_g4_14"]));
		$ds_g4_15= trim(avoid_crack($_POST["ds_g4_15"]));

		$sql="update car_master 
				set 
					ds_g1_01 = '$ds_g1_01'
					,ds_g1_02 = '$ds_g1_02'
					,ds_g1_03 = '$ds_g1_03'
					,ds_g1_04 = '$ds_g1_04'
					,ds_g1_05 = '$ds_g1_05'
					,ds_g1_06 = '$ds_g1_06'
					,ds_g1_07 = '$ds_g1_07'
					,ds_g1_08 = '$ds_g1_08'
					,ds_g1_09 = '$ds_g1_09'
					,ds_g1_10 = '$ds_g1_10'
					,ds_g1_11 = '$ds_g1_11'
					,ds_g1_12 = '$ds_g1_12'
					,ds_g1_13 = '$ds_g1_13'
					,ds_g1_14 = '$ds_g1_14'
					,ds_g1_15 = '$ds_g1_15'
					,ds_g2_01 = '$ds_g2_01'
					,ds_g2_02 = '$ds_g2_02'
					,ds_g2_03 = '$ds_g2_03'
					,ds_g2_04 = '$ds_g2_04'
					,ds_g2_05 = '$ds_g2_05'
					,ds_g2_06 = '$ds_g2_06'
					,ds_g2_07 = '$ds_g2_07'
					,ds_g2_08 = '$ds_g2_08'
					,ds_g2_09 = '$ds_g2_09'
					,ds_g2_10 = '$ds_g2_10'
					,ds_g2_11 = '$ds_g2_11'
					,ds_g2_12 = '$ds_g2_12'
					,ds_g2_13 = '$ds_g2_13'
					,ds_g2_14 = '$ds_g2_14'
					,ds_g2_15 = '$ds_g2_15'
					,ds_g3_01 = '$ds_g3_01'
					,ds_g3_02 = '$ds_g3_02'
					,ds_g3_03 = '$ds_g3_03'
					,ds_g3_04 = '$ds_g3_04'
					,ds_g3_05 = '$ds_g3_05'
					,ds_g3_06 = '$ds_g3_06'
					,ds_g3_07 = '$ds_g3_07'
					,ds_g3_08 = '$ds_g3_08'
					,ds_g3_09 = '$ds_g3_09'
					,ds_g3_10 = '$ds_g3_10'
					,ds_g3_11 = '$ds_g3_11'
					,ds_g3_12 = '$ds_g3_12'
					,ds_g3_13 = '$ds_g3_13'
					,ds_g3_14 = '$ds_g3_14'
					,ds_g3_15 = '$ds_g3_15'
					,ds_g4_01 = '$ds_g4_01'
					,ds_g4_02 = '$ds_g4_02'
					,ds_g4_03 = '$ds_g4_03'
					,ds_g4_04 = '$ds_g4_04'
					,ds_g4_05 = '$ds_g4_05'
					,ds_g4_06 = '$ds_g4_06'
					,ds_g4_07 = '$ds_g4_07'
					,ds_g4_08 = '$ds_g4_08'
					,ds_g4_09 = '$ds_g4_09'
					,ds_g4_10 = '$ds_g4_10'
					,ds_g4_11 = '$ds_g4_11'
					,ds_g4_12 = '$ds_g4_12'
					,ds_g4_13 = '$ds_g4_13'
					,ds_g4_14 = '$ds_g4_14'
					,ds_g4_15 = '$ds_g4_15'
				WHERE  cd_car =$cd_car"; 
			
			$result  = mysql_query($sql,$connect);
			return $result;

	}

	mysql_close($connect);
?>