echajoa/sa/sell_proc.php

<?php
	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/aligo.php';
	// include $_SERVER['DOCUMENT_ROOT'].'/common/lib/infobank.php';
	// include $_SERVER['DOCUMENT_ROOT'].'/common/lib/notification.php';

	$s_cd_sale = $_SESSION['s_cd_sale'];
	$s_staff_cd_car = $_SESSION['s_staff_cd_car'];
	$sell_nm_email = $_SESSION['sell_nm_email'];
	$sell_nm_name = $_SESSION['sell_nm_name'];
	$sell_nm_hp = $_SESSION['sell_nm_hp'];
//	$s_ds_type = $_SESSION['s_ds_type'];
//	$s_ds_level = $_SESSION['s_ds_level'];
	// $s_cd_user = $_SESSION['s_cd_user'];
	$s_cd_user = $_SESSION['s_staff_user'];
	$s_staff_car_update_ing = $_SESSION['s_staff_car_update_ing'] ;

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


	$cd_car_history = trim(avoid_crack($_POST["cd_car_history"]));
	$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['sell_ds_area'];
	}
	if(empty($ds_area_sub) || $ds_area_sub == ""){
		$ds_area_sub = $_SESSION['sell_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"]));
	$ds_business_num  = trim(avoid_crack($_POST["ds_business_num"]));
	$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"]));
	$ds_sale_period = trim(avoid_crack($_POST["ds_sale_period"]));

	$cd_aap_dealer = trim(avoid_crack($_POST["cd_aap_dealer"]));
	if(empty($cd_aap_dealer) || $cd_aap_dealer == ""){
		$cd_aap_dealer = $_SESSION['cd_aap_dealer'];
	}
	$nm_cont_pac = $_POST["nm_cont_pac"];

	$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_desc = addslashes($_POST["nm_desc"]);
	$nm_cont_detail = $_POST["nm_cont_detail"];
	$nm_guide = addslashes($_POST["nm_guide"]);

	$ds_accident_check = addslashes($_POST["ds_accident_check"]);
	$ds_damage_check = addslashes($_POST["ds_damage_check"]);

	$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"]));
	$ds_dealer_type  = trim(avoid_crack($_POST["ds_dealer_type"]));
	$ds_tradein  = trim(avoid_crack($_POST["ds_tradein"]));
	$ds_buy_method  = trim(avoid_crack($_POST["ds_buy_method"]));
	$ds_auction_time  = trim(avoid_crack($_POST["ds_auction_time"]));
	$ds_tradein_group  = trim(avoid_crack($_POST["ds_tradein_group"]));

	$nm_file_act = $_POST["nm_file_act"];


	$no_sort = $_POST["no_sort"];

	$cd_user = $_SESSION['s_staff_user'];
	$cd_userid = $_SESSION['s_staff_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"]));
	$RES = array('CODE'=>'9999', 'MSG'=>'');
	try {

		switch($mode) {

			//게시판 글쓰기
			case "Add" :

				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":

				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_staff_cd_car'] = $cd_car;
				// $_SESSION['s_staff_car_update_ing_cd_sale'] = trim(avoid_crack($_POST["cd_sale"]));
				// $_SESSION['s_staff_car_update_ing'] = "Y";

				$_SESSION['s_staff_car_update_ing_cd_sale'] = trim(avoid_crack($_POST["cd_sale"]));
				$_SESSION['s_staff_car_update_ing'] = "Y";

				$_SESSION['sell_nm_name'] = trim(avoid_crack($_POST["nm_name"]));
				$_SESSION['sell_nm_hp'] = trim(avoid_crack($_POST["nm_hp"]));
				$_SESSION['sell_ds_area'] = trim(avoid_crack($_POST["ds_area"]));
				$_SESSION['sell_nm_number'] = trim(avoid_crack($_POST["nm_number"]));


				$RES['CODE'] 	= "0000";
				$RES['MSG'] 	= "정상.";
				$RES['DATAS'] 	= $DATAS;

	//			echo $cd_car."-".$_SESSION['s_cd_car']."-".$_SESSION['s_staff_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_staff_cd_car !="" || $s_staff_cd_car != null){
					if($_REQUEST['nm_mileage']) {
						$add_query.= " , nm_mileage = '$nm_mileage'";
					}
					if($_REQUEST['cd_grade']) {
						$add_query.= " , cd_grade = '$cd_grade'";
					}

					$sql="update car_master
							set
								  dt_update = now()
								$add_query
								, nm_update = '$cd_userid'
								, nm_number = '$nm_number'
							WHERE  cd_car = $s_staff_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,nm_mileage,cd_grade
								)
							values
								('$nm_number', now(), '$cd_userid', now(), '$cd_userid','N','$nm_mileage','$cd_grade'
								)";

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

					$_SESSION['s_staff_cd_car'] = $cd_car;
				}
	            $nm_hp = $_POST['nm_hp1'].'-'.$_POST['nm_hp2'].'-'.$_POST['nm_hp3'];

					$_SESSION['sell_nomem_hp'] = $nm_hp;
					$_SESSION['sell_nm_hp'] = $nm_hp;
					$_SESSION['sell_nm_name']= $nm_name;
					$_SESSION['sell_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_staff_cd_car !="" || $s_staff_cd_car != null){
					$sql="update car_master
							set
								  dt_update = now()
								, nm_update = '$cd_userid'
								, nm_number = '$nm_number'
							WHERE  cd_car = $s_staff_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_staff_cd_car'] = $cd_car;
					$_SESSION['sell_nomem_hp'] = $nm_hp;
					$_SESSION['sell_nm_hp'] = $nm_hp;
					$_SESSION['sell_nm_name']= $nm_name;
					$_SESSION['sell_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;

			case 'PreStep':

				$where = array();
				$where['nm_number'] = $nm_number;

				$is_sale = fnIsSale($where);
				unset($where);

				if($is_sale == true) {
					throw new Exception("현재 등록되어 진행 중인 차량입니다.", "9900");
				}

				$sql="insert into car_master SET
							cd_model 			= '$cd_model'
							, cd_grade 			= '0'
							, cd_model_sub 		= '0'
							, cd_category 		= '$cd_category'
							, cd_brand 			= '$cd_brand'
							, cd_car_history	= '$cd_car_history'
							, 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'
							, nm_cont_pac 		= '$nm_cont_pac'
							, ds_business_num 	= '$ds_business_num'
							, 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'
							, ds_status 		= '$ds_status'
							, dt_insert 		= now()
							, nm_insert 		= '$cd_userid'
							, dt_update 		= now()
							, nm_update 		= '$cd_userid'
							, ds_delind 		= 'N'
							, nm_price 			= '0'
							, nm_gearbox 		= ''
							, nm_incolor 		= ''
							, nm_regdate 		= ''
							, ds_sales 			= ''
							, nm_btitle 		= ''
							, nm_stitle 		= ''
							, nm_ltitle 		= ''
				";

				// echo $sql;
				// exit;
				//사고 유무는 1-1단계에서 처리 해달라함
				// , ds_accident, nm_cont_accident
				//, '$ds_accident', '$nm_cont_accident'
				$result  = mysql_query($sql,$connect);
				if(!$result) {
					throw new Exception("차량등록에 실패했습니다.", "9900");
				}
				$cd_car  = mysql_insert_id();

				$_SESSION['s_staff_cd_car']	= $cd_car;

				$_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");

				$RES['CODE'] 	= "0000";
				$RES['MSG'] 	= "정상.";

				break;

			//sale -> Step1
			case "Step1":
				// print_r($_POST);
				// exit;

				if($s_staff_cd_car !="" || $s_staff_cd_car != null){
					$sql="update car_master set
								cd_model 				= '$cd_model'
								, cd_category 			= '$cd_category'
								, cd_car_history		= '$cd_car_history'
								, 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_business_num 		= '$ds_business_num'
								, ds_accident_check 	= '$ds_accident_check'
								, ds_damage_check 		= '$ds_damage_check'
								, 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_cont_pac 			= '$nm_cont_pac'
								, nm_regdate_yyyy 		= '$nm_regdate_yyyy'
								, nm_regdate_mm 		= '$nm_regdate_mm'
								, nm_regdate_dd 		= '$nm_regdate_dd'
							WHERE  cd_car = $s_staff_cd_car";
					// ,cd_model_sub 			= '$cd_model_sub'
					// ,cd_grade 				= '$cd_grade'
					// ,ds_tradein 			= '$ds_tradein'
					// ,ds_tradein_group 		= '$ds_tradein_group'
					// , cd_brand 				= '$cd_brand'
					// echo $sql;
					// exit;
					$result  = mysql_query($sql,$connect);

					if(!$result) {
						throw new Exception("저장에 실패 하였습니다.", "9990");
					}

				}else{
					// 차량 별 진행중 차량 체크
					//현재 진행중인 차량 체크(회원/비회원)

					$where = array();
					$where['nm_number'] 	= $nm_number;

					$is_sale = fnIsSale($where);
					unset($where);

					if($is_sale == true) {
						throw new Exception("현재 등록되어 진행 중인 차량입니다.", "9900");
					}

					$sql="insert into car_master SET
								cd_model 			= '$cd_model'
								, cd_grade 			= '0'
								, cd_model_sub 		= '0'
								, cd_category 		= '$cd_category'
								, cd_brand 			= '$cd_brand'
								, cd_car_history		= '$cd_car_history'
								, 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'
								, nm_cont_pac 		= '$nm_cont_pac'
								, ds_business_num 	= '$ds_business_num'
								, ds_accident_check 	= '$ds_accident_check'
								, ds_damage_check 		= '$ds_damage_check'
								, 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'
								, ds_status 		= '$ds_status'
								, dt_insert 		= now()
								, nm_insert 		= '$cd_userid'
								, dt_update 		= now()
								, nm_update 		= '$cd_userid'
								, ds_delind 		= 'N'
								, nm_price 			= '0'
								, nm_gearbox 		= ''
								, nm_incolor 		= ''
								, nm_regdate 		= ''
								, ds_sales 			= ''
								, nm_btitle 		= ''
								, nm_stitle 		= ''
								, nm_ltitle 		= ''
					";
					//, ds_tradein, ds_tradein_group
					//, '$ds_tradein', '$ds_tradein_group'
					// echo $sql;
					// exit;
					$result  = mysql_query($sql,$connect);

					if(!$result) {
						throw new Exception("저장에 실패 하였습니다.", "9990");
					}
					$cd_car  = mysql_insert_id();

					$_SESSION['s_staff_cd_car']= $cd_car;

				}

				// //제조사
				// $car_brand_sql = "SELECT nm_brand FROM car_brand m WHERE m.cd_brand = '".$cd_brand."' LIMIT 1 ";
				// $car_brand_res = mysqli_query($connect, $car_brand_sql);
				// $car_brand_row = mysqli_fetch_assoc($car_brand_res);
				//
				// //모델
				// $car_model_sql = "SELECT nm_model FROM car_model m WHERE m.cd_model = '".$cd_model."' LIMIT 1 ";
				// $car_model_res = mysqli_query($connect, $car_model_sql);
				// $car_model_row = mysqli_fetch_assoc($car_model_res);
				//
				// //세부모델
				// $car_model_sub_sql = "SELECT nm_model_sub FROM car_model_sub m WHERE m.cd_model_sub = '".$cd_model_sub."' LIMIT 1 ";
				// $car_model_sub_res = mysqli_query($connect, $car_model_sub_sql);
				// $car_model_sub_row = mysqli_fetch_assoc($car_model_sub_res);
				//
				// //등급
				// $car_grade_sql = "SELECT nm_grade FROM car_grade m WHERE m.cd_grade = '".$cd_grade."' LIMIT 1 ";
				// $car_grade_res = mysqli_query($connect, $car_grade_sql);
				// $car_grade_row = mysqli_fetch_assoc($car_grade_res);
				//
				// //차량 검색시 사용할 컬럼
				// $nm_tag = $car_brand_row['nm_brand'].' '.$car_model_row['nm_model'].' '.$car_model_sub_row['nm_model_sub'].' '.$car_grade_row['nm_grade'];



				//sale_mater 에 등록될 변수들은 세션에 담는다

				$nm_hp = $_POST['nm_hp1'].'-'.$_POST['nm_hp2'].'-'.$_POST['nm_hp3'];


				$sale_master = array(
					"sell_nomem_hp" 		=> $nm_hp,			//차량 희망가
					"sell_nm_hp" 			=> $nm_hp,		//연락 가능시간
					"sell_nm_name" 			=> $nm_name,		//중고 시세가
					"sell_ds_area" 			=> $ds_area,		//중고 시세가
					"sell_ds_sale_period" 	=> $ds_sale_period,		//중고 시세가
					"s_cd_aap_dealer" 		=> $cd_aap_dealer,		//중고 시세가

					"sell_ds_tradein" 		=> $ds_tradein,		//중고 시세가
					"sell_ds_buy_method" 		=> $ds_buy_method,		//중고 시세가
					"sell_ds_auction_time" 		=> $ds_auction_time,		//중고 시세가

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


				//
				// $_SESSION['sell_nomem_hp'] = $nm_hp;
				// $_SESSION['sell_nm_hp'] = $nm_hp;
				// $_SESSION['sell_nm_name']= $nm_name;
				// $_SESSION['sell_ds_area']= $ds_area;
				// $_SESSION['sell_ds_sale_period']= $ds_sale_period;
				// $_SESSION['s_cd_aap_dealer']= $cd_aap_dealer;
				//
				//
				//
				// $_SESSION['s_ds_type']= "C0";
				// $_SESSION['s_ds_usertype']= "C0";


				$_SESSION['s_sale_master']= json_encode($sale_master);

				$DATAS = array();
				$DATAS['URL'] = "sell_step2.php";

				$RES['CODE'] 	= "0000";
				$RES['MSG'] 	= "저장 되었습니다.";
				$RES['DATAS'] 	= $DATAS;

				break;
			case "Step2":
	//nm_cont



				if($s_staff_car_update_ing != "Y"){		//차량 수정 중에는 진행중 차량 체크 안함
					// 차량 별 진행중 차량 체크

					//현재 진행중인 차량 체크(회원/비회원)

					$regist_car = fnGetCarInfoByCdCar($s_staff_cd_car);

					$where = array();
					$where['nm_number'] 	= $regist_car['nm_number'];

					$is_sale = fnIsSale($where);
					unset($where);

					if($is_sale == true) {
						throw new Exception("현재 등록되어 진행 중인 차량입니다.", "9900");
						// AlertBack("현재 등록되어 진행 중인 차량입니다.");
					}
				}

				if(is_array($nm_cont_detail)) {
					$nm_cont_detail_value = implode(",",$nm_cont_detail);
				}else {
					$nm_cont_detail_value = "";
				}

				$sql = "UPDATE car_master SET
							nm_cont = '$nm_cont'
							, nm_cont_detail = '".$nm_cont_detail_value."'
							, dt_update = now()
							, nm_update = '$cd_userid'
						WHERE cd_car = $s_staff_cd_car";
				$result  = mysql_query($sql, $connect);

				if(!$result) {
					throw new Exception("저장에 실패 하였습니다.", "9990");
				}

				$DATAS = array();
				$DATAS['URL'] = "sell_step3.php";

				$RES['CODE'] 	= "0000";
				$RES['MSG'] 	= "저장 되었습니다.";
				$RES['DATAS'] 	= $DATAS;

			break;

			case "Step3":
	//nm_file_front,nm_file_back,nm_file_side1,nm_file_side2,nm_file_dashboard,nm_file_act,nm_recommend
	            // print_r($_FILES);
	            // echo $upload_path."nm_file_main/ratio/";
	            // exit;

	// 차량 별 진행중 차량 체크

				$file_sql = "";
				$upload_path =  $upload_path.$cd_car."_main/";
				$upload_path_ratio =  $upload_path."ratio/";

				//차량전면 이미지 첨부파일 업로드
				$upload_image_info = _upload_car_image($upload_path, $upload_path_ratio, 'nm_file_front', 500, true);
				if($upload_image_info['result'] == false) {
					throw new Exception("첨부파일 업로드 실패 하였습니다.", "9979");
				}
				//차량전면 이미지
				if(!empty($upload_image_info['filename'])) {
					$file_sql.= " , nm_file_front = '".$upload_image_info['filename']."' ";
				}

				//운전석 측면 첨부파일 업로드
				$upload_image_info = _upload_car_image($upload_path, $upload_path_ratio, 'nm_file_side1', 500, true);
				if($upload_image_info['result'] == false) {
					throw new Exception("첨부파일 업로드 실패 하였습니다.", "9979");
				}
				//운전석 측면 이미지
				if(!empty($upload_image_info['filename'])) {
					$file_sql.= " , nm_file_side1 = '".$upload_image_info['filename']."' ";
				}

				//조수석 측면 첨부파일 업로드
				$upload_image_info = _upload_car_image($upload_path, $upload_path_ratio, 'nm_file_side2', 500, true);
				if($upload_image_info['result'] == false) {
					throw new Exception("첨부파일 업로드 실패 하였습니다.", "9979");
				}
				//조수석 측면 이미지
				if(!empty($upload_image_info['filename'])) {
					$file_sql.= " , nm_file_side2 = '".$upload_image_info['filename']."' ";
				}

				//차량 후면 첨부파일 업로드
				$upload_image_info = _upload_car_image($upload_path, $upload_path_ratio, 'nm_file_back', 500, true);
				if($upload_image_info['result'] == false) {
					throw new Exception("첨부파일 업로드 실패 하였습니다.", "9979");
				}
				//차량 후면 이미지
				if(!empty($upload_image_info['filename'])) {
					$file_sql.= " , nm_file_back = '".$upload_image_info['filename']."' ";
				}

				//계기판 첨부파일 업로드
				$upload_image_info = _upload_car_image($upload_path, $upload_path_ratio, 'nm_file_dashboard', 500, true);
				if($upload_image_info['result'] == false) {
					throw new Exception("첨부파일 업로드 실패 하였습니다.", "9979");
				}
				//계기판 이미지
				if(!empty($upload_image_info['filename'])) {
					$file_sql.= " , nm_file_dashboard = '".$upload_image_info['filename']."' ";
				}

				$sql="UPDATE car_master SET
							ds_status = 'B0'
							, dt_update = now()
							, nm_update = '$cd_userid'
							$file_sql
						WHERE  cd_car = $s_staff_cd_car";
					//, nm_file_engine = case when '$upload_file_engine_name' = '' then nm_file_engine else '$upload_file_engine_name' end
					// , nm_file_registration = case when '$upload_file_registration_name' = '' then nm_file_registration else '$upload_file_registration_name' end
				// echo $sql;
				// exit;
				$result  = mysql_query($sql,$connect);

				//AJAX 용

				if (!$result) {
					throw new Exception("차량 이미지 업로드에 실패하였습니다. 다시 시도해 주세요.", "9900");
				}

				$DATAS = array();
				$DATAS['URL'] = "sell_step3.php";

				$RES['CODE'] 	= "0000";
				$RES['MSG'] 	= "저장 되었습니다.";
				$RES['DATAS'] 	= $DATAS;

			break;

			case "Step4":

				if($s_staff_car_update_ing != "Y"){		//차량 수정 중에는 진행중 차량 체크 안함
					// 차량 별 진행중 차량 체크
					//현재 진행중인 차량 체크(회원/비회원)

					$regist_car = fnGetCarInfoByCdCar($s_staff_cd_car);

					$where = array();
					$where['nm_number'] 	= $regist_car['nm_number'];

					$is_sale = fnIsSale($where);
					unset($where);

					if($is_sale == true) {
						throw new Exception("현재 등록되어 진행 중인 차량입니다.", "9900");
						// AlertBack("현재 등록되어 진행 중인 차량입니다.");
					}
				}

				if(isset($_FILES['upload_file']) && count($_FILES['upload_file']) > 0) {
					$upload_files = array();
					for($i=0; $i < 10; $i++) {
						$file_name 		= "";
						$file_type 		= "";
						$file_tmp_name 	= "";
						$file_error 	= "";
						$file_size 		= "";

						//등록된 파일만
						if(isset($_FILES['upload_file']['name'][$i])) {
							$file_name 		= $_FILES['upload_file']['name'][$i];
							$file_type 		= $_FILES['upload_file']['type'][$i];
							$file_tmp_name 	= $_FILES['upload_file']['tmp_name'][$i];
							$file_error 	= $_FILES['upload_file']['error'][$i];
							$file_size 		= $_FILES['upload_file']['size'][$i];
						}


						$upload_files['name'][] 	= $file_name;
						$upload_files['type'][] 	= $file_type;
						$upload_files['tmp_name'][]	= $file_tmp_name;
						$upload_files['error'][] 	= $file_error;
						$upload_files['size'][] 	= $file_size;
					}

					$_FILES['file'] = $upload_files;
				}

				//추가 이미지 등록
				if(count($_FILES) > 0) {
					$file_result = fnSetCarImgCreate($s_staff_cd_car, $connect);
					if(!$file_result) {
						throw new Exception("파일 업로드에 실패 하였습니다.", "9991");
					}
				}

				$DATAS = array();
				$DATAS['URL'] = "sell_step5.php";//&uniqid=".$uniqid;

				$RES['CODE'] 	= "0000";
				$RES['MSG'] 	= "저장 되었습니다.";
				$RES['DATAS'] 	= $DATAS;


			// 	$table_name = " sa_master a ";
			// 	$_whereis = "  a.cd_userid = '".$cd_userid."' ";
			// 	$staff = $dbCon->selectDAO(" a.device_uuid, a.device_os", $table_name, $_whereis);
			//
			//
			// 	if($s_staff_car_update_ing == "Y"){		//차량 수정 중에는 sale_master 등록/수정 불가
			// 		$s_staff_car_update_ing_cd_sale = $_SESSION['s_staff_car_update_ing_cd_sale'];
			//
			// 		$sql="update sale_master
			// 				set
			// 					ds_status = 'C0'
			// 					, nm_recommend = '$nm_recommend'
			// 					, ds_area = '$ds_area'
			// 					, dt_update = now()
			// 					, device_os = '".$staff['device_os']."'
			// 					, device_uuid = '".$staff['device_uuid']."'
			// 					, is_staff = 'Y'
			// 					, nm_update = '$cd_userid'
			// 					, cd_aap_dealer = '$_SESSION[s_cd_aap_dealer]'
			// 				WHERE  cd_sale = $s_staff_car_update_ing_cd_sale
			// 					and ds_status = 'D0' ";		//반려 상태일 경우 차량 수정 완료 시 승인대기 상태로 변경(D0 -> C0)
			//
			// 		$result  = mysql_query($sql,$connect);
			//
			// 		// $_SESSION['s_staff_car_update_ing'] = null;	//세션 값 삭제 : car 정보 수정 중
			// 		// $_SESSION['s_staff_car_update_ing_cd_sale'] = null;
			//
			// 	}else{
			//
			// 	}
			//
			// 	if($result){
			//
			// 		//차량옵션정보 등록
			// //				fnSetCarDtlInfo($cd_car,$connect);
			// 		$result1 = fnSetCarImgCreate($s_staff_cd_car,$connect);
			// 		if(!$result1){
			// 			AlertBack("차량옵션 첨부파일 업로드 실패 하였습니다.");
			// 			die();
			// 		}
			//
			// 	}
			//
			// 	//AJAX 용
			//
			// 	if ($result) {
			// 		$res_json["CODE"] = "0000";
			// 		$res_json["MSG"] = "정상";
			// 		$res_json["cd_sale"] = $cd_sale;
			//
			// 	}else{
			// 		$res_json["CODE"] = "9999";
			// 		$res_json["MSG"] = "차량 이미지 업로드에 실패하였습니다. 다시 시도해 주세요.";
			// 	}
			// 	echo json_encode($res_json);

			break;

	        case "Step5":
				if($s_staff_car_update_ing != "Y"){		//차량 수정 중에는 진행중 차량 체크 안함
					// 차량 별 진행중 차량 체크
					//현재 진행중인 차량 체크(회원/비회원)

					$regist_car = fnGetCarInfoByCdCar($s_staff_cd_car);

					$where = array();
					$where['nm_number'] 	= $regist_car['nm_number'];

					$is_sale = fnIsSale($where);
					unset($where);

					if($is_sale == true) {
						throw new Exception("현재 등록되어 진행 중인 차량입니다.", "9900");
						// AlertBack("현재 등록되어 진행 중인 차량입니다.");
					}
				}

				// $table_name = " sa_master a ";
				// $_whereis = "  a.cd_userid = '".$cd_userid."' ";
				// $staff = $dbCon->selectDAO(" a.device_uuid, a.device_os", $table_name, $_whereis);

				//세션에서 sale_master 에 등록될 데이터를 가져온다
				$sale_master = json_decode($_SESSION['s_sale_master'], true);
				// print_r($_SESSION['s_sale_master']);

				// $sale_master = array(
				// 	"sell_nomem_hp" 		=> $nm_hp,			//차량 희망가
				// 	"sell_nm_hp" 	=> $nm_hp,		//연락 가능시간
				// 	"sell_nm_name" 	=> $sell_nm_name,		//중고 시세가
				// 	"sell_ds_area" 	=> $ds_area,		//중고 시세가
				// 	"sell_ds_sale_period" 	=> $ds_sale_period,		//중고 시세가
				// 	"s_cd_aap_dealer" 	=> $cd_aap_dealer,		//중고 시세가
				// 	"s_ds_type" 	=> 'C0',		//$ds_type -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자
				// 	"s_ds_usertype" 	=> 'C0',		//$ds_usertypeds_type 상세 사용 가능) -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자		예)(($row[ds_type] == "A0")?"D0":"D1");
				// );

				$car_sql = "SELECT c.*
								, b.nm_model
								, d.nm_brand
								FROM car_master c
								LEFT OUTER JOIN car_model b on (c.cd_model = b.cd_model)
								LEFT OUTER JOIN car_brand d on (c.cd_brand = d.cd_brand)
									WHERE cd_car = '$s_staff_cd_car'
								LIMIT 1";
				// echo $sale_sql;
				// exit;
				$car_res = mysql_query($car_sql);
				$car_col = mysql_fetch_array($car_res);
				// print_r($car_col);
				// exit;

				$sa_sql = "SELECT sa.*
								, getCode('sa_master','ds_branch',sa.ds_branch) as nm_branch
								FROM sa_master sa
									WHERE cd_userid = '{$_SESSION['s_staff_userid']}'
								LIMIT 1";
				// echo $sale_sql;
				// exit;
				$sa_res = mysql_query($sa_sql);
				$sa_col = mysql_fetch_array($sa_res);


				$aap_sql = "SELECT aap.*
								FROM aap_master aap
									WHERE cd_dealer = '{$sale_master['s_cd_aap_dealer']}'
								LIMIT 1";
				// echo $aap_sql;
				// exit;
				$aap_res = mysql_query($aap_sql);
				$aap_col = mysql_fetch_array($aap_res);
				// print_r($aap_col);
				// exit;



				//ds_status : 'A0' = 입력중, 'B0' = '입력완료', ...
				$sql="UPDATE car_master SET
							nm_desc = '$nm_desc'
							, dt_update = now()
							, nm_update = '$cd_userid'
						WHERE  cd_car = '$s_staff_cd_car' ";
				// echo $sql;
				// exit;
				$result  = mysql_query($sql, $connect);
				if(!$result) {
					throw new Exception("저장에 실패 하였습니다.", "9991");
				}


				if($s_staff_car_update_ing == "Y"){		//차량 수정 중에는 sale_master 등록/수정 불가
					$s_staff_car_update_ing_cd_sale = $_SESSION['s_staff_car_update_ing_cd_sale'];

					$sql="update sale_master set
								ds_status 			= 'B0'
								, ds_tradein 		= '{$sale_master['sell_ds_tradein']}'
								, ds_buy_method 	= '{$sale_master['sell_ds_buy_method']}'
								, ds_auction_time 	= '{$sale_master['sell_ds_auction_time']}'
								, ds_sale_period	= '{$sale_master['sell_ds_sale_period']}'
								, cd_aap_dealer		= '{$sale_master['s_cd_aap_dealer']}'
								, ds_company_bp		= '$s_ds_company_bp'
								, ds_branch			= '$s_ds_branch'
								, ds_area			= '{$sale_master['sell_ds_area']}'
								, ds_area_sub		= '$ds_area_sub'
								, ds_usertype		= '$ds_usertype'
								, dt_update 		= now()
								, nm_update 		= '$cd_userid'

							WHERE  cd_sale = $s_staff_car_update_ing_cd_sale
								and ds_status IN('B0', 'D0') ";		//반려 상태일 경우 차량 수정 완료 시 승인대기 상태로 변경(D0 -> C0)

					$result  = mysql_query($sql,$connect);
					// , device_os = '".$staff['device_os']."'
					// , device_uuid = '".$staff['device_uuid']."'
					$_SESSION['s_staff_car_update_ing'] = null;	//세션 값 삭제 : car 정보 수정 중
					$_SESSION['s_staff_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($sale_master['sell_nomem_hp'])){
						$ds_usertype = "C0";
					}else{
						$ds_usertype = "";
					}

					if(empty($sale_master['s_cd_aap_dealer'])) {
						$sale_master['s_cd_aap_dealer'] = 0;
					}


					$sql="INSERT INTO sale_master SET
								cd_car						= '$s_staff_cd_car'
								, cd_user					= '$s_cd_user'
								, nm_email					= ''
								, nm_name					= '{$sale_master['sell_nm_name']}'
								, nm_hp						= '{$sale_master['sell_nm_hp']}'
								, ds_tradein 				= '{$sale_master['sell_ds_tradein']}'
								, ds_buy_method 			= '{$sale_master['sell_ds_buy_method']}'
								, ds_auction_time 			= '{$sale_master['sell_ds_auction_time']}'
								, nm_tel					= ''
								, nm_price_exp				= '0'
								, nm_price					= '0'
								, ds_status_contract		= ''
								, ds_status_contract_step1	= ''
								, ds_status_contract_step2	= ''
								, ds_status_contract_step3	= ''
								, ds_status_contract_step4	= ''
								, ds_status_contract_step5	= ''
								, ds_company_bp				= '$s_ds_company_bp'
								, ds_branch					= '$s_ds_branch'
								, ds_area					= '{$sale_master['sell_ds_area']}'
								, ds_area_sub				= '$ds_area_sub'
								, ds_usertype				= '$ds_usertype'
								, ds_status					= 'B0'
								, ds_sale_period			= '{$sale_master['sell_ds_sale_period']}'
								, dt_insert					= now()
								, nm_insert					= '$cd_userid'
								, dt_update					= now()
								, nm_update					= '$cd_userid'
								, ds_delind					= 'N'
								, is_staff					= 'Y'
								, cd_aap_dealer				= '{$sale_master['s_cd_aap_dealer']}'
					";

					//
					// $sql="insert into sale_master
					// 			(cd_car, cd_user, nm_email, nm_name, nm_hp
					// 			, nm_tel, nm_price_exp, nm_price, ds_status_contract, ds_status_contract_step1, ds_status_contract_step2, ds_status_contract_step3, ds_status_contract_step4
					// 			, ds_company_bp, ds_branch, ds_area, ds_area_sub, ds_usertype, ds_status, ds_sale_period
					// 			, dt_insert, nm_insert, dt_update, nm_update, ds_delind, is_staff
					// 			, cd_aap_dealer
					// 			)
					// 		values
					// 			('$', '$s_cd_user', '', '{$sale_master['sell_nm_name']}', '{$sale_master['sell_nm_hp']}'
					// 			, '', '0', '0', '', '', '','',''
					// 			, '$s_ds_company_bp', '$s_ds_branch', '{$sale_master['sell_ds_area']}', '$ds_area_sub', '$ds_usertype', 'B0', '{$sale_master['sell_ds_sale_period']}'
					// 			, now(), '$cd_userid', now(), '$cd_userid','N', 'Y'
					// 			, '{$sale_master['s_cd_aap_dealer']}'
					// 			)";


	// , device_os, device_uuid
	// , '".$staff['device_os']."', '".$staff['device_uuid']."'
					// echo $sql;
					// exit;

					$result  = mysql_query($sql,$connect);
					$cd_sale  = mysql_insert_id();
				}

				if(!$result) {
					throw new Exception("정보 등록에 실패 하였습니다.", "9991");
				}

				// $_SESSION['s_sale_master'] = NULL;
				$_SESSION['sell_nm_name'] = '';
				$_SESSION['sell_ds_area'] = '';
				$_SESSION['s_staff_cd_car'] = '';

				//등록시에만 SMS 전송
				if($s_staff_car_update_ing != "Y"){
					# SMS 발송
					# 1. SA에게
					$aligo = new Aligo();
					$aligo->getToken();

					$ALIGO_DATA = array();
					$ALIGO_DATA['seller'] 		= $sale_master['sell_nm_name'];
					$ALIGO_DATA['car_brand'] 	= $car_col['nm_brand'];
					$ALIGO_DATA['car_model'] 	= $car_col['nm_model'];
					$ALIGO_DATA['car_number'] 	= $car_col['nm_number'];
					$ALIGO_DATA['recv_phone'] 	= $sa_col['nm_hp'];

					$response = $aligo->send_sa_sell_standby_to_sa($ALIGO_DATA);
					unset($ALIGO_DATA);

					if($response['code'] != "0") {
						// echo $response['message'];
					}

					# 3. AAP 에게
					//AAP에 발송은 관리자 승인시 발송되는 걸로 바뀜 2024-04-27
					// $ALIGO_DATA = array();
					// $ALIGO_DATA['car_brand'] 	= $car_col['nm_brand'];
					// $ALIGO_DATA['car_model'] 	= $car_col['nm_model'];
					// $ALIGO_DATA['car_number'] 	= $car_col['nm_number'];
					// $ALIGO_DATA['recv_phone'] 	= $aap_col['nm_hp'];
					// $ALIGO_DATA['sa_name'] 		= $sa_col['nm_name'];
					// $ALIGO_DATA['sa_area'] 		= $sa_col['nm_branch'];
					//
					// // print_r($ALIGO_DATA);
					// // exit;
					//
					// $response = $aligo->send_sa_sell_standby_to_aap($ALIGO_DATA);
					// unset($ALIGO_DATA);
					//
					// if($response['code'] != "0") {
					// 	// echo $response['message'];
					// }

					# 3. 관리자에게
					foreach($admin_phone as $phone) {
						if(!empty($phone)) {
							$ALIGO_DATA = array();
							$ALIGO_DATA['seller'] 		= $sale_master['sell_nm_name'];
							$ALIGO_DATA['car_brand'] 	= $car_col['nm_brand'];
							$ALIGO_DATA['car_model'] 	= $car_col['nm_model'];
							$ALIGO_DATA['car_number'] 	= $car_col['nm_number'];
							$ALIGO_DATA['recv_phone'] 	= $phone;
							$ALIGO_DATA['sa_name'] 		= $sa_col['nm_name'];
							$ALIGO_DATA['sa_area'] 		= $sa_col['nm_branch'];


							// print_r($ALIGO_DATA);

							$response = $aligo->send_sa_sell_standby_to_admin($ALIGO_DATA);
							// print_r($response);
							unset($ALIGO_DATA);
						}
					}

					// print_r($response);
					// exit;

					if($response['code'] != "0") {
						// echo $response['message'];
					}
				}


				$DATAS = array();
				$DATAS['URL'] = "sell_step5.php";

				$RES['CODE'] 	= "0000";
				$RES['MSG'] 	= "저장 되었습니다.";
				$RES['DATAS'] 	= $DATAS;

			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'
								, ds_dealer_type = '$ds_dealer_type'
							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);
				throw new Exception("지정되지않은 요청입니다.", "9999");
				$RES['DATAS']['URL'] = "index.php&ds_cate=".$ds_cate;
			break;
		}
	}catch(Exception $e){
		$RES['CODE'] = $e->getCode();
		$RES['MSG'] = $e->getMessage();
	}
	@mysql_close($connect);

	echo json_encode($RES);
	exit;

	//추가 이미지
	function fnSetCarImgCreate($cd_car,$connect){

		$upload_path = $_SERVER['DOCUMENT_ROOT'].UPLOAD_PATH_CAR.$cd_car."_detail/";
		$blnResult = true;
		$cd_userid =  $_SESSION['s_staff_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'", $connect),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'));
					if(file_exists($upload_path.$upload_file_name) && is_file($upload_path.$upload_file_name)) {
						// create_watermark($upload_path.$upload_file_name);
					}
					$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 = "delete from car_file  where cd_car='$cd_car' and no_sort = '$k'";
							$result  = mysql_query($sql, $connect);

							$sql = "INSERT INTO car_file SET
										cd_car		= '$cd_car',
										ds_type		= '',
										nm_file		= '$upload_file_name',
										nm_size		= '$nm_size',
										nm_mime		= '$nm_mime',
										no_sort 	= '$k',
										dt_insert	= now(),
										nm_insert	= '$cd_userid',
										dt_update	= now(),
										nm_update	= '$cd_userid',
										ds_delind	= 'N'
							";
							// echo $sql;

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

	}

	//cd_car로 차량정보 가져오기
	function fnGetCarInfoByCdCar($cd_car) {
		global $connect;

		$sql = "SELECT cd_car, nm_number FROM car_master c
					WHERE cd_car = '$cd_car'
				limit 1";
		$car_col = mysql_fetch_assoc(mysql_query($sql, $connect));

		return $car_col;
	}

	//진행중인 차량이 있는지 체크
	function fnIsSale($where) {
		global $connect;
		$ret = false;


		$add_query = "";
		foreach($where as $key => $val) {
			$add_query.= " AND c.".$key." = '$val' ";
		}

		$sql = "SELECT count(*)
					FROM 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 (s.dt_approve is null or s.dt_approve >= DATE_ADD(now(), INTERVAL '-".LIMIT_TIME_SELL."' HOUR) )
					)
					WHERE 1
						$add_query  ";
						//c.nm_number = '".$nm_number."'
		// if($_SERVER['REMOTE_ADDR'] == '106.243.211.195') {
		//
		// 	echo $sql;
		// 	print_r($where);
		// 	exit;
		// }
		// and c.cd_car = '".$cd_car."'
		$res  = mysql_query($sql,$connect);
		$cnt = mysql_result($res,0,0);
		if($cnt>0) {
			$ret = true;
		}
		return $ret;
	}

	mysql_close($connect);
?>