75 lines
2.3 KiB
PHP
75 lines
2.3 KiB
PHP
<?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);
|