<?php

	include $_SERVER["DOCUMENT_ROOT"].'/common/lib/comm.php';
	include $_SERVER['DOCUMENT_ROOT'].'/common/aap_chk_m.php';

	$table_name = "aap_master";

	$PageNo = trim(avoid_crack($_REQUEST["PageNo"]));

	$mode = trim(avoid_crack($_POST["mode"]));
	$cd_dealer  = trim(avoid_crack($_POST["cd_dealer"]));
	$cd_dealerid  = trim(avoid_crack($_POST["cd_dealerid"]));
	$cd_dealer_p  = trim(avoid_crack($_POST["cd_dealer_p"]));
	$nm_pass  = trim(avoid_crack($_POST["nm_pass"]));
	$ds_type  = trim(avoid_crack($_POST["ds_type"]));
	$ds_level  = trim(avoid_crack($_POST["ds_level"]));
	$nm_company  = trim(avoid_crack($_POST["nm_company"]));
	$nm_name  = trim(avoid_crack($_POST["nm_name"]));
	$nm_birth  = trim(avoid_crack($_POST["nm_birth"]));
	$nm_tel_01  = trim(avoid_crack($_POST["nm_tel_01"]));
	$nm_tel_02  = trim(avoid_crack($_POST["nm_tel_02"]));
	$nm_tel_03  = trim(avoid_crack($_POST["nm_tel_03"]));
	$nm_hp_01  = trim(avoid_crack($_POST["nm_hp_01"]));
	$nm_hp_02  = trim(avoid_crack($_POST["nm_hp_02"]));
	$nm_hp_03  = trim(avoid_crack($_POST["nm_hp_03"]));
	$nm_fax_01  = trim(avoid_crack($_POST["nm_fax_01"]));
	$nm_fax_02  = trim(avoid_crack($_POST["nm_fax_02"]));
	$nm_fax_03  = trim(avoid_crack($_POST["nm_fax_03"]));
	$nm_email  = trim(avoid_crack($_POST["nm_email"]));
	$nm_zip  = trim(avoid_crack($_POST["nm_zip"]));
	$nm_addr  = trim(avoid_crack($_POST["nm_addr"]));
	$nm_addr_sub  = trim(avoid_crack($_POST["nm_addr_sub"]));
	$nm_etc_01  = trim(avoid_crack($_POST["nm_etc_01"]));
	$nm_etc_02  = trim(avoid_crack($_POST["nm_etc_02"]));
	$nm_etc_03  = trim(avoid_crack($_POST["nm_etc_03"]));
	$ds_status  = trim(avoid_crack($_POST["ds_status"]));
	$nm_company_biz  = trim(avoid_crack($_POST["nm_company_biz"]));
	$nm_name_biz  = trim(avoid_crack($_POST["nm_name_biz"]));
	$nm_no_biz  = trim(avoid_crack($_POST["nm_no_biz"]));
	$nm_date_biz  = trim(avoid_crack($_POST["nm_date_biz"]));
	$nm_type_biz  = trim(avoid_crack($_POST["nm_type_biz"]));
	$nm_condition_biz  = trim(avoid_crack($_POST["nm_condition_biz"]));
	$nm_tel_biz_01  = trim(avoid_crack($_POST["nm_tel_biz_01"]));
	$nm_tel_biz_02  = trim(avoid_crack($_POST["nm_tel_biz_02"]));
	$nm_tel_biz_03  = trim(avoid_crack($_POST["nm_tel_biz_03"]));
	$nm_hp_biz_01  = trim(avoid_crack($_POST["nm_hp_biz_01"]));
	$nm_hp_biz_02  = trim(avoid_crack($_POST["nm_hp_biz_02"]));
	$nm_hp_biz_03  = trim(avoid_crack($_POST["nm_hp_biz_03"]));
	$nm_fax_biz_01  = trim(avoid_crack($_POST["nm_fax_biz_01"]));
	$nm_fax_biz_02  = trim(avoid_crack($_POST["nm_fax_biz_02"]));
	$nm_fax_biz_03  = trim(avoid_crack($_POST["nm_fax_biz_03"]));
	$nm_email_biz  = trim(avoid_crack($_POST["nm_email_biz"]));
	$nm_zip_biz  = trim(avoid_crack($_POST["nm_zip_biz"]));
	$nm_addr_biz  = trim(avoid_crack($_POST["nm_addr_biz"]));
	$nm_addr_sub_biz  = trim(avoid_crack($_POST["nm_addr_sub_biz"]));
	$ds_company_bp1 = trim(avoid_crack($_POST["ds_company_bp1"]));
	$ds_branch1 = trim(avoid_crack($_POST["ds_branch1"]));
	$ds_company_bp2 = trim(avoid_crack($_POST["ds_company_bp2"]));
	$ds_branch2 = trim(avoid_crack($_POST["ds_branch2"]));
	$ds_company_bp3 = trim(avoid_crack($_POST["ds_company_bp3"]));
	$ds_branch3 = trim(avoid_crack($_POST["ds_branch3"]));
	$ds_company_bp = trim(avoid_crack($_POST["ds_company_bp"]));
	$ds_branch = trim(avoid_crack($_POST["ds_branch"]));
	$nm_area  = trim(avoid_crack($_POST["nm_area"]));
//	$nm_area  = trim(avoid_crack(implode(",",$_POST["nm_area"])));
	$nm_title  = trim(avoid_crack($_POST["nm_title"]));
	$nm_file  = trim(avoid_crack($_POST["nm_file"]));
	$nm_etc  = trim(avoid_crack($_POST["nm_etc"]));
	$nm_deposit  = trim(avoid_crack($_POST["nm_deposit"]));
	$dt_insert  = trim(avoid_crack($_POST["dt_insert"]));
	$nm_insert  = trim(avoid_crack($_POST["nm_insert"]));
	$dt_update  = trim(avoid_crack($_POST["dt_update"]));
	$nm_update  = trim(avoid_crack($_POST["nm_update"]));
	$ds_delind  = trim(avoid_crack($_POST["ds_delind"]));

	$cd_procid = $_SESSION['s_cd_dealerid'];


//	$PageNo = trim(avoid_crack($_POST["PageNo"]));

	switch($mode) {

	//수정하기
	case "Update":
		$RES = array('CODE'=>'9999', 'MSG'=>'');
		try {
			if(!$_POST) {
				throw new Exception("정상적인 접근이 아닙니다.", "9999");
			}
			if(empty($nm_name)) {
				throw new Exception("이름이 없습니다.", "9995");
			}
			if(empty($nm_hp) || $nm_hp == "--") {
				throw new Exception("휴대번호가 없습니다.", "9993");
			}
			// if(empty($nm_email) || $nm_email == "@") {
			// 	throw new Exception("이메일이 없습니다.", "9993");
			// }

			$add_pwd_sql = "";
			if(!empty($nm_pass)) {
				$add_pwd_sql = " , nm_pass = password('".$nm_pass."') ";
			}


			$sql = "UPDATE $table_name SET
						nm_company 	= '$nm_company'
						, nm_name 	= '$nm_name'
						, nm_hp 	= '$nm_hp'
						, nm_hp_01 	= '$nm_hp1'
						, nm_hp_02 	= '$nm_hp2'
						, nm_hp_03 	= '$nm_hp3'
						, ds_company_bp = '$ds_company_bp'
						, ds_branch = '$ds_branch'
						, dt_update = now()
						, nm_update = '$cd_procid'
						$add_pwd_sql
					WHERE cd_dealerid = '$cd_procid'
			";
			// echo $sql;
			// exit;
			$result  = mysql_query($sql,$connect);

			if(!$result) {
				throw new Exception("정보 수정에 실패 하였습니다.잠시후 다시 시도해 주세요.", "9990");
			}


			$_SESSION['s_cd_dealer_type']=null;
			$_SESSION['s_cd_dealerid']=null;
			$_SESSION['s_nm_email']=null;
			$_SESSION['s_nm_name']=null;
			$_SESSION['s_nm_hp']=null;
			$_SESSION['s_nm_hp_form']=null;
			$_SESSION['s_aap_ds_type']=null;	//$ds_type -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자
			$_SESSION['s_ds_level']=null;
			$_SESSION['s_cd_dealer']=null;
			$_SESSION['s_cd_dealer_p']=null;
			$_SESSION['s_nm_area']=null;
		//				$_SESSION['s_ds_area_sub']=$row[ds_area_sub];
			$_SESSION['s_ds_usertype']=null;	//$ds_usertype	ds_type 상세 사용 가능 -> A0:개인,B0:업체,B1:업체1,B2:업체2,C0:비회원

			$_SESSION['s_ds_company_bp1']=null;	//관계사1
			$_SESSION['s_ds_branch1']=null;			//지점1
			$_SESSION['s_ds_company_bp2']=null;	//관계사2
			$_SESSION['s_ds_branch2']=null;			//지점2
			$_SESSION['s_ds_company_bp3']=null;	//관계사3
			$_SESSION['s_ds_branch3']=null;			//지점3

			$_SESSION['s_ds_kind']= null;	//$s_ds_kind -> A:개인, D:딜러,딜러-관리자		예)(($row[ds_type] == "A0")?"D0":"D1");
			$_SESSION['s_ds_status_p']=null;	//총괄관리자(딜러) 승인여부 : Z0-승인, 이외-미승인

			setcookie ('ESMotorsAAP', '', time() - 1, "/");

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

	case 'Withdrawal':
		$RES = array('CODE'=>'9999', 'MSG'=>'');
		try {
			if(!$_POST) {
				throw new Exception("정상적인 접근이 아닙니다.", "9999");
			}

			$sql = "UPDATE $table_name SET
						dt_withdrawal = now()
						, ds_status = 'W0'
						, dt_update = now()
						, nm_update = '$cd_procid'
					WHERE cd_dealerid = '$cd_procid'
			";
			// echo $sql;
			// exit;
			$result  = mysql_query($sql,$connect);

			if(!$result) {
				throw new Exception("탈퇴신청에 실패 하였습니다.잠시후 다시 시도해 주세요.", "9990");
			}

			// throw new Exception("정보 수정에 실패 하였습니다.잠시후 다시 시도해 주세요.", "9990");

			$_SESSION['s_cd_dealer_type']=null;
			$_SESSION['s_cd_dealerid']=null;
			$_SESSION['s_nm_email']=null;
			$_SESSION['s_nm_name']=null;
			$_SESSION['s_nm_hp']=null;
			$_SESSION['s_nm_hp_form']=null;
			$_SESSION['s_aap_ds_type']=null;	//$ds_type -> A0:개인,B0:업체,C0:비회원,D0:딜러,D1:딜러-관리자
			$_SESSION['s_ds_level']=null;
			$_SESSION['s_cd_dealer']=null;
			$_SESSION['s_cd_dealer_p']=null;
			$_SESSION['s_nm_area']=null;
		//				$_SESSION['s_ds_area_sub']=$row[ds_area_sub];
			$_SESSION['s_ds_usertype']=null;	//$ds_usertype	ds_type 상세 사용 가능 -> A0:개인,B0:업체,B1:업체1,B2:업체2,C0:비회원

			$_SESSION['s_ds_company_bp1']=null;	//관계사1
			$_SESSION['s_ds_branch1']=null;			//지점1
			$_SESSION['s_ds_company_bp2']=null;	//관계사2
			$_SESSION['s_ds_branch2']=null;			//지점2
			$_SESSION['s_ds_company_bp3']=null;	//관계사3
			$_SESSION['s_ds_branch3']=null;			//지점3

			$_SESSION['s_ds_kind']= null;	//$s_ds_kind -> A:개인, D:딜러,딜러-관리자		예)(($row[ds_type] == "A0")?"D0":"D1");
			$_SESSION['s_ds_status_p']=null;	//총괄관리자(딜러) 승인여부 : Z0-승인, 이외-미승인

			setcookie ('ESMotorsAAP', '', time() - 1, "/");

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

	default :
		AlertBack("지정되지않은 요청입니다");
	break;
}
mysql_close($connect);
?>