<?php
include_once '_common.php';
if(!$_SESSION['user_id']) exit;

// 변수선언
$idx = trim($_POST['idx']);
$vip_name = trim($_POST['vip_name']);
$vip_birth = trim($_POST['vip_birth']);
$vip_tel = addTelHyphen(trim($_POST['vip_tel']));
$vip_email = trim($_POST['vip_email']);
$vip_addr = trim($_POST['vip_addr']);
$vip_memo = trim($_POST['vip_memo']);
$vip_gender = trim($_POST['vip_gender']);
$vip_date = trim($_POST['vip_date']); 

$last_edit_name = trim($_POST['last_edit_name']);

// 현재 시간 저장
$time = date("Y-m-d H:i:s");

// 기존 카드 정보 가져오기
$q1 = "SELECT * FROM {$fg['vip_list_table']} WHERE idx = '{$idx}'";
$r = sql_fetch($q1);

	// 변수 값을 DB에 업데이트
	$query = "UPDATE {$fg['vip_list_table']} SET 
										vip_name 		= '{$vip_name}', 
										vip_tel 		= '{$vip_tel}', 
										vip_email 		= '{$vip_email}', 
										vip_birth 		= '{$vip_birth}', 
										vip_addr 		= '{$vip_addr}', 
										vip_memo 		= '{$vip_memo}', 
										vip_gender 		= '{$vip_gender}', 
										vip_date 		= '{$vip_date}', 
										last_edit_name 	= '{$last_edit_name}', 
										last_edit_date 	= '{$time}'";
	$query .= " WHERE idx='{$idx}'";
	
	$result = sql_query($query);

	// log 만들기
	$work = "VIP정보수정";
	$work_detail = "카드번호 : ".$r['vip_card_no'].", 처리자 : ".$_SESSION['user_name'].', ';
	$work_detail .= "수정내역 : ";
	if($r['vip_name'] != $vip_name){
		$work_detail .= $r['vip_name'].' -> '.$vip_name.', ';
	}
	if($r['vip_tel'] != $vip_tel){
		$work_detail .= $r['vip_tel'].' -> '.$vip_tel.', ';
	}
	if($r['vip_email'] != $vip_email){
		$work_detail .= $r['vip_email'].' -> '.$vip_email.', ';
	}
	if($r['vip_birth'] != $vip_birth){
		$work_detail .= $r['vip_birth'].' -> '.$vip_birth.', ';
	}
	if($r['vip_addr'] != $vip_addr){
		$work_detail .= $r['vip_addr'].' -> '.$vip_addr.', ';
	}
	if($r['vip_memo'] != $vip_memo){
		$work_detail .= $r['vip_memo'].' -> '.$vip_memo.', ';
	}
	if($r['vip_gender'] != $vip_gender){
		$work_detail .= $r['vip_gender'].' -> '.$vip_gender.', ';
	}
	if($r['vip_date'] != $vip_date){
		$work_detail .= $r['vip_date'].' -> '.$vip_date.', ';
	}
	// log 기록
	log_update($work, $work_detail, $_SESSION['user_id'], $time);

$data = array("isSuccess" => $result);
header("Content-Type: application/json");
echo json_encode($data);