echajoa/m/sell/proc.php

<?php
	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/comm.php';
	include $_SERVER['DOCUMENT_ROOT'].'/common/lib/aligo.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"]));
	$ds_area_user = trim(avoid_crack($_POST["ds_area_user"]));

	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'];
	}
	if(empty($ds_area_user) || $ds_area_user == ""){
		$ds_area_user = $_SESSION['s_ds_area_user'];
	}

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

	$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['s_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";

			$sql = "select ds_area from car_master c
						inner join sale_master s on (c.cd_car = s.cd_car and s.ds_delind = 'N' and s.cd_sale = '".trim(avoid_crack($_POST["cd_sale"]))."'  )
					limit 1";
			$col=mysql_fetch_array(mysql_query($sql));
			if (!empty($col[ds_area_user])){
				$_SESSION['s_ds_area_user'] = $col['ds_area_user'];
			}

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

		break;
		//사용자가 유찰사유를 선택해서 저장
		case "updateFail":
			$ds_fail = trim(avoid_crack($_POST["ds_fail"]));

			$sql="update sale_master set
						  dt_update = now()
						, nm_update = '$cd_userid'
						, ds_fail = '$ds_fail'
					WHERE  cd_sale = $cd_sale
						and cd_user = '$s_cd_user'
			";

			$result  = mysql_query($sql,$connect);
			if($result) {
				echo "Y";
			}else {
				echo "N";
			}
		break;

		//sale -> sellNoMember
		case "sellNoMember":
			exit;
			$RES = array('CODE'=>'9999', 'MSG'=>'');
			try {

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

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

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

				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'
								)";
					echo $sql;
					exit;
					$result  = mysql_query($sql,$connect);

					if (!$result) {
						throw new Exception("차량 저장에 실패했습니다.", "9900");
					}


					$cd_car  = mysql_insert_id();
					// echo $sql;;
					// echo '<br/>'.$cd_car;
					// exit;

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

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

			}catch(Exception $e){
				$RES['CODE'] = $e->getCode();
				$RES['MSG'] = $e->getMessage();
			}
			@mysql_close($connect);

			echo json_encode($RES);
			exit;
		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;

		case 'PreStep':
			$RES = array('CODE'=>'9999', 'MSG'=>'');
			try {

				$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_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'] 	= "정상.";

			}catch(Exception $e){
				$RES['CODE'] = $e->getCode();
				$RES['MSG'] = $e->getMessage();
			}
			@mysql_close($connect);

			echo json_encode($RES);

			break;
		//sale -> Step1
		case "Step1":
			include $_SERVER['DOCUMENT_ROOT'].'/common/auth_chk_m.php';

			$RES = array('CODE'=>'9999', 'MSG'=>'');
			try {


				//sale_mater 에 등록될 변수들은 세션에 담는다
				$nm_hp = $_POST['nm_hp1'].'-'.$_POST['nm_hp2'].'-'.$_POST['nm_hp3'];


				$sql="UPDATE car_master SET
							ds_transmission 	= '$ds_transmission'
							, nm_cc 			= '$nm_cc'
							, ds_oil 			= '$ds_oil'
							, nm_color 			= '$nm_color'
							, nm_mileage 		= '$nm_mileage'
							, ds_accident 		= '$ds_accident'
							, ds_business_num 	= '$ds_business_num'
							, nm_cont_pac 		= '$nm_cont_pac'
							, ds_accident_check 	= '$ds_accident_check'
							, ds_damage_check 		= '$ds_damage_check'
							, dt_update 		= now()
							, nm_update 		= '$cd_userid'
							, nm_name 			= '$nm_name'
						WHERE  cd_car = $s_cd_car";
				//, ds_sale_period 	= '$ds_sale_period'
				// echo $sql;
				// exit;
				$result  = mysql_query($sql,$connect);
				if(!$result) {
					throw new Exception("저장에 실패 하였습니다.", "9990");
				}

				$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,		//중고 시세가
					"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['s_sale_master']= json_encode($sale_master);

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

				$RES['CODE'] 	= "0000";
				$RES['MSG'] 	= "저장 되었습니다.";
				$RES['DATAS'] 	= $DATAS;
				// $_SESSION['s_ds_area_user']= $ds_area_user;
			}catch(Exception $e){
				$RES['CODE'] = $e->getCode();
				$RES['MSG'] = $e->getMessage();
			}
			@mysql_close($connect);

			echo json_encode($RES);
			exit;
		break;

		case "Step1-1":
			exit;
//nm_cont
				//사고 유무 추가
				// $sql="update car_master
				// 		set
				// 			ds_accident = '$ds_accident'
				// 			,nm_cont_accident = '$nm_cont_accident'
				// 			,dt_update = now()
				// 			,nm_update = '$cd_userid'
				// 		WHERE  cd_car = $cd_car";
				// $result  = mysql_query($sql,$connect);
				//
				// if ($result) {
				// 	Redirect("sell_step2.php?mode=Step2");
				// //				AlertRedirect("저장 되었습니다.","sell_step3.php?mode=Step3");
				// }else{
				// 	AlertRedirect("저장 실패하였습니다.","sell_step1_1.php?mode=Step1-1");
				// }
				// Redirect("sell_step2.php?mode=Step2");
//
		break;

		//sale -> Step2
		case "Step2":
			include $_SERVER['DOCUMENT_ROOT'].'/common/auth_chk_m.php';
//nm_cont

			$RES = array('CODE'=>'9999', 'MSG'=>'');
			try {


				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_cd_car";
				// echo $sql;
				// exit;
				$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;

			}catch(Exception $e){
				$RES['CODE'] = $e->getCode();
				$RES['MSG'] = $e->getMessage();
			}
			@mysql_close($connect);

			echo json_encode($RES);
			exit;

		break;

		//sale -> Step3
		case "Step3":
			include $_SERVER['DOCUMENT_ROOT'].'/common/auth_chk_m.php';

			$RES = array('CODE'=>'9999', 'MSG'=>'');
			try {

				$file_sql = "";
				$upload_path =  $upload_path.$s_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_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;

			}catch(Exception $e){
				$RES['CODE'] = $e->getCode();
				$RES['MSG'] = $e->getMessage();
			}
			@mysql_close($connect);

			echo json_encode($RES);
			exit;

		break;

		case "Step4":
			include $_SERVER['DOCUMENT_ROOT'].'/common/auth_chk_m.php';

			$RES = array('CODE'=>'9999', 'MSG'=>'');
			try {
				// 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;
				}
				// print_r($_FILES);
				// exit;

				//추가 이미지 등록
				if(count($_FILES) > 0) {
					$file_result = fnSetCarImgCreate($s_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;


			}catch(Exception $e){
				$RES['CODE'] = $e->getCode();
				$RES['MSG'] = $e->getMessage();
			}
			@mysql_close($connect);

			echo json_encode($RES);
			exit;
		break;

		case "Step5":
			include $_SERVER['DOCUMENT_ROOT'].'/common/auth_chk_m.php';

			$RES = array('CODE'=>'9999', 'MSG'=>'');
			try {
				// if($s_car_update_ing != "Y"){		//차량 수정 중에는 진행중 차량 체크 안함
				// 	// 차량 별 진행중 차량 체크
				// 	//현재 진행중인 차량 체크(회원/비회원)
				//
				// 	$regist_car = fnGetCarInfoByCdCar($s_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($sale_master);
				// exit;
				// 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_cd_car'
								LIMIT 1";
				// echo $sale_sql;
				// exit;
				$car_res = mysql_query($car_sql);
				$car_col = mysql_fetch_array($car_res);

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

				//$ds_usertype -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자
				$ds_usertype = "A0";

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

				$sql="INSERT INTO sale_master SET
							cd_car						= '$s_cd_car'
							, cd_user					= '$s_cd_user'
							, nm_email					= ''
							, nm_name					= '{$sale_master['sell_nm_name']}'
							, nm_hp						= '{$sale_master['sell_nm_hp']}'
							, 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					= 'N'
							, ds_auction_time			= '72'
							, cd_aap_dealer				= '{$sale_master['s_cd_aap_dealer']}'
				";
				// echo $sql;
				// exit;

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

				$cd_sale  = mysql_insert_id();

				$_SESSION['s_sale_master'] = NULL;
				$_SESSION['sell_nm_name'] = '';
				$_SESSION['sell_ds_area'] = '';
				$_SESSION['s_cd_car'] = '';

				# SMS 발송
				# 1. 사용자에게
				$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'] 	= $sale_master['sell_nm_hp'];


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

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

				# 2. 관리자에게
				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;

						// print_r($ALIGO_DATA);

						$response = $aligo->send_user_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;


			}catch(Exception $e){
				$RES['CODE'] = $e->getCode();
				$RES['MSG'] = $e->getMessage();
			}
			@mysql_close($connect);

			echo json_encode($RES);
			exit;



		break;

		// 담당자코멘트 저장
		case "Guide":
		exit;
			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":
			exit;
//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":
			//관리자 단으로 이동함
			exit;
			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":
			//관리자 단으로 이동함
			exit;
			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);
			}

			$table_name = " car_master a
							inner join sale_master f on (a.cd_car = f.cd_car)
							left outer join car_model b on (a.cd_model = b.cd_model)
							left outer join car_grade c on (a.cd_grade = c.cd_grade)
							left outer join car_brand d on (a.cd_brand = d.cd_brand)
							left outer join car_model_sub e on (a.cd_model_sub = e.cd_model_sub)";
			$_whereis = "  f.cd_sale = '".$cd_sale."' ";
			$col = $dbCon->selectDAO(" a.cd_brand, a.cd_model, a.cd_grade, b.nm_model, c.nm_grade, d.nm_brand, e.nm_model_sub, f.nm_hp, f.nm_name, a.nm_mileage, f.ds_area, f.ds_area_user, a.nm_regdate_yyyy , a.nm_regdate_mm, a.ds_year", $table_name, $_whereis);
			//해당 딜러 매칭은 ds_area_user : 사용자가 지정한 판매 희망지역으로 설정

			$nm_regdate_full = substr($col['ds_year'], 2, 2).'MY';
			$contents = $col['nm_brand'].' '.$col['nm_model'].' '.$col['nm_grade'].' '.$col['nm_mileage'].'km';
	        $contents = $col['nm_model'].' '.$nm_regdate_full;

	        $sql = "INSERT INTO sale_master_standby ( cd_brand, ds_area, cd_model, cd_grade, nm_mileage, contents)
	                SELECT '$col[cd_brand]', '$col[ds_area]', '$col[cd_model]', '$col[cd_grade]', '$nm_regdate_full', '$contents' FROM dual
	                    WHERE not EXISTS
	                    (
	                        SELECT cd_brand, ds_area, cd_model, cd_grade, nm_mileage
	                            FROM sale_master_standby
	                                WHERE cd_brand = '$col[cd_brand]'
	                                    and ds_area = '$col[ds_area]'
	                                    and cd_model = '$col[cd_model]'
	                                    and cd_grade = '$col[cd_grade]'
	                                    and nm_mileage = '$nm_regdate_full'
	                    )
	        ";
	        mysql_query($sql);

			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['s_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'", $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;

	}


	//진행중인 차량이 있는지 체크
	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);
?>