echajoa/m/sa/mypage_proc.php

<?php

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

	$table_name = "sa_master";

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

	$mode = trim(avoid_crack($_POST["mode"]));
	$cd_user = trim(avoid_crack($_POST["cd_user"]));
    $cd_userid = trim(avoid_crack($_POST["cd_userid"]));
	$nm_name = trim(avoid_crack($_POST["nm_name"]));
    $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_birth = trim(avoid_crack($_POST["nm_birth"]));
//	$nm_tel = trim(avoid_crack($_POST["nm_tel"]));
//	$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 = trim(avoid_crack($_POST["nm_hp"]));
	$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_email = trim(avoid_crack($_POST["nm_email"]));
	$ds_company_bp = trim(avoid_crack($_POST["ds_company_bp"]));
	$ds_branch = trim(avoid_crack($_POST["ds_branch"]));
	$ds_area = trim(avoid_crack($_POST["ds_area"]));
	$ds_area_sub = trim(avoid_crack($_POST["ds_area_sub"]));
	$ds_agree1 = trim(avoid_crack($_POST["ds_agree1"]));
	$ds_agree2 = trim(avoid_crack($_POST["ds_agree2"]));
	$ds_agree3 = trim(avoid_crack($_POST["ds_agree3"]));
	$ds_agree4 = trim(avoid_crack($_POST["ds_agree4"]));
/*
	$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"]));
	$ds_job = trim(avoid_crack($_POST["ds_job"]));
	$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"]));
	$ds_delind = trim(avoid_crack($_POST["ds_delind"]));

	$cd_procid = $_SESSION['s_staff_userid'];


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

			$nm_hp = preg_replace("/[^0-9]*/s", "", $nm_hp);
			$nm_hp = add_hyphen($nm_hp);


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


			$sql = "UPDATE $table_name SET
						nm_name = '$nm_name'
						, nm_hp = '$nm_hp'
						, nm_email = '$nm_email'
						, ds_company_bp = '$ds_company_bp'
						, ds_branch = '$ds_branch'
						, ds_area = '$ds_area'
						, ds_area_sub = '$ds_area_sub'
						, dt_update = now()
						, nm_update = '$cd_procid'
						$add_pwd_sql
					WHERE cd_userid = '$cd_procid'
			";



			// echo $sql;
			// exit;
			$result  = mysql_query($sql,$connect);

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

			$_SESSION['s_staff_userid'] = null;
			$_SESSION['s_staff_user']=null;
			$_SESSION['s_nm_email'] = null;
			$_SESSION['s_nm_name'] = null;
			$_SESSION['s_nm_hp'] = null;
			$_SESSION['s_ds_type'] = null;
			$_SESSION['s_ds_level'] = null;
			$_SESSION['s_cd_user'] = null;
			$_SESSION['s_ds_area'] = null;
			$_SESSION['s_ds_area_sub'] = null;
			$_SESSION['s_ds_usertype'] = null;
			$_SESSION['s_ds_company_bp']=null;	//관계사
			$_SESSION['s_ds_branch']=null;			//지점

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

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

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

			$_SESSION['s_staff_userid'] = null;
			$_SESSION['s_staff_user']=null;
			$_SESSION['s_nm_email'] = null;
			$_SESSION['s_nm_name'] = null;
			$_SESSION['s_nm_hp'] = null;
			$_SESSION['s_ds_type'] = null;
			$_SESSION['s_ds_level'] = null;
			$_SESSION['s_cd_user'] = null;
			$_SESSION['s_ds_area'] = null;
			$_SESSION['s_ds_area_sub'] = null;
			$_SESSION['s_ds_usertype'] = null;
			$_SESSION['s_ds_company_bp']=null;	//관계사
			$_SESSION['s_ds_branch']=null;			//지점

			setcookie ('ESMotorsStaff', '', 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);
?>