休暇登録 | Life Widen

prepare('SELECT * FROM L_COOKING WHERE C_STATUS = :C_STATUS ORDER BY C_DATE ASC'); $stmt->bindValue(':C_STATUS', 1); $stmt->execute(); $cook = $stmt->fetchAll(); $cooklist = ''; if (!isset($_GET['id']) || $_GET['id'] == '') { // 新規 $formtype = 'newadd'; $breadcrumb = '予約を追加'; $boo_date = date('Y/m/d'); $boo_h = 0; $boo_m_0 = ''; $boo_m_30 = ''; $boo_remarks = ''; $cancelbtn = ''; } else { // 変更 $formtype = 'replace'; $stmt = $DBh->prepare("SELECT * FROM L_BOOKING WHERE B_UUID = ?"); $stmt->execute([$_GET['id']]); $booking_data = $stmt->fetch(PDO::FETCH_ASSOC); if ($booking_data['B_UUID'] == '') { header('Location: /control/top'); exit; } $boo_date = date('Y/m/d', strtotime($booking_data['B_BOO_START_DATE'])); $boo_h = date('G', strtotime($booking_data['B_BOO_START_DATE'])); $boo_remarks = $booking_data['B_REMARKS']; $boo_m = date('i', strtotime($booking_data['B_BOO_START_DATE'])); if ((int)$boo_m == 0) { $boo_m_0 = 'selected'; $boo_m_30 = ''; } elseif ((int)$boo_m == 30) { $boo_m_0 = ''; $boo_m_30 = 'selected'; } $breadcrumb = '予約の変更 '.$boo_date; $cancelbtn = '

予約をキャンセルする

'; // 予約料理情報 $stmt = $DBh->prepare("SELECT * FROM L_ADD_PAYMENT WHERE A_B_UUID = ?"); $stmt->execute([$_GET['id']]); $cooking_data = $stmt->fetch(PDO::FETCH_ASSOC); foreach($cook as $cook_row) { if ($cooking_data['A_COOKID'] == $cook_row['C_UUID']) { $cooklist .= ' '."\n"; } } if ($cooklist == '') { $cooklist .= ' '."\n"; } } $stmt = $DBh->prepare("SELECT * FROM L_USER WHERE U_UUID = ?"); $stmt->execute([$_SESSION['SESSION_ID']]); $aduser_data = $stmt->fetch(PDO::FETCH_ASSOC); $stmt = $DBh->prepare("SELECT * FROM L_USER WHERE U_UUID = ?"); $stmt->execute([$booking_data['B_USERID']]); $user_data = $stmt->fetch(PDO::FETCH_ASSOC); // カレンダー表示用ファイル require_once("../../common/_calendar.php"); ?> 休暇登録 | Life Widen