prepare("SELECT * FROM L_USER WHERE U_UUID = ?");
$stmt->execute([$_SESSION['ADMIN_SESSION_ID']]);
$myuser_data = $stmt->fetch(PDO::FETCH_ASSOC);
$stmt = $DBh->prepare("SELECT * FROM L_USER WHERE U_UUID = ?");
$stmt->execute([$_GET['id']]);
$user_data = $stmt->fetch(PDO::FETCH_ASSOC);
if ($user_data['U_UUID'] == '') {
header('Location: /control/account');
exit;
}
// 今日の日付を取得
$today = date('Y-m-d 00:00:00');
$week = array( "日", "月", "火", "水", "木", "金", "土" ); // 曜日設定
// 予約リストを取得
$stmt = $DBh->prepare('SELECT * FROM L_BOOKING WHERE B_USERID = :B_USERID AND B_STATUS = :B_STATUS AND B_BOO_START_DATE >= :B_BOO_START_DATE ORDER BY B_BOO_START_DATE ASC');
$stmt->bindValue(':B_USERID', $user_data['U_UUID']);
$stmt->bindValue(':B_STATUS', 0);
$stmt->bindValue(':B_BOO_START_DATE', $today);
$stmt->execute();
$calendar = $stmt->fetchAll();
$mylist = '';
foreach($calendar as $calendar_row) {
// 開始時間フォーマット
$start = new DateTime($calendar_row['B_BOO_START_DATE']);
$start_date = $start->format('m月d日');
$start_time = $start->format('H:i');
// 終了時間フォーマット
$end_date = new DateTime($calendar_row['B_BOO_END_DATE']);
$end_time = $end_date->format('H:i');
// 曜日設定
$disp_w = $week[$start->format("w")];
$dispdatetime = $start_date . '(' . $disp_w . ') ' . $start_time . '～' . $end_time;
$mylist .= '
'.$dispdatetime.'
'."\n";
}
if ($mylist == '') {
$mylist .= '
予約はありません
'."\n";
}
// 予約リストを取得
$stmt = $DBh->prepare('SELECT * FROM L_BOOKING WHERE B_USERID = :B_USERID AND B_STATUS = :B_STATUS AND B_BOO_START_DATE < :B_BOO_START_DATE ORDER BY B_BOO_START_DATE DESC LIMIT 0, 50');
$stmt->bindValue(':B_USERID', $user_data['U_UUID']);
$stmt->bindValue(':B_STATUS', 0);
$stmt->bindValue(':B_BOO_START_DATE', $today);
$stmt->execute();
$calendar = $stmt->fetchAll();
$oldlist = '';
foreach($calendar as $calendar_row) {
// 開始時間フォーマット
$start = new DateTime($calendar_row['B_BOO_START_DATE']);
$start_date = $start->format('m月d日');
$start_time = $start->format('H:i');
// 終了時間フォーマット
$end_date = new DateTime($calendar_row['B_BOO_END_DATE']);
$end_time = $end_date->format('H:i');
// 曜日設定
$disp_w = $week[$start->format("w")];
$dispdatetime = $start_date . '(' . $disp_w . ') ' . $start_time . '～' . $end_time;
$oldlist .= '
'.$dispdatetime.'
'."\n";
}
if ($oldlist == '') {
$oldlist .= '
過去の予約はありません
'."\n";
}
if ($user_data['U_PAYSTATUS'] == 0) {
// 初期登録
$paystatus = '支払い情報未登録';
$paybtn = '';
} elseif ($user_data['U_PAYSTATUS'] == 1) {
// 支払いOK
$paystatus = '支払いOK';
$paybtn = '支払い情報を削除する';
} elseif ($user_data['U_PAYSTATUS'] == 2) {
// 支払いエラー
$paystatus = '支払いエラー';
$paybtn = '支払い情報を削除する';
}
?>
会員詳細 | Life Widen
-
管理画面トップ
-
会員リスト
-
会員詳細
退会処理を行う
