--
-- Host: localhost    Database: doto_yoyaku
-- ------------------------------------------------------


--
-- Table structure for table `group_bookings`
--

CREATE TABLE `group_bookings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gb_number` char(6) DEFAULT NULL,
  `organization_id` int(11) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `organization_group_id` int(11) DEFAULT NULL,
  `organization_name` varchar(255) NOT NULL,
  `contact_person` varchar(100) DEFAULT NULL,
  `contact_phone` varchar(20) DEFAULT NULL,
  `contact_email` varchar(100) DEFAULT NULL,
  `total_passengers` int(11) NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `payment_status` enum('pending','paid','cancelled','refunded') DEFAULT 'pending',
  `payment_method` varchar(50) DEFAULT NULL,
  `payment_date` datetime DEFAULT NULL,
  `booking_status` enum('confirmed','cancelled') DEFAULT 'confirmed',
  `checkin_status` enum('not_checked_in','checked_in') DEFAULT 'not_checked_in',
  `checkin_at` datetime DEFAULT NULL,
  `checkin_by` int(11) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `commission_value` decimal(10,2) DEFAULT 0.00 COMMENT '手数料の値',
  `commission_type` enum('fixed','percentage') DEFAULT 'fixed' COMMENT '手数料タイプ: fixed=円, percentage=%',
  `commission_amount` decimal(10,2) DEFAULT 0.00 COMMENT '計算された手数料金額',
  `subtotal_amount` decimal(10,2) DEFAULT 0.00 COMMENT '小計金額（手数料適用前）',
  `final_amount` decimal(10,2) DEFAULT 0.00 COMMENT '見積合計金額（手数料適用後）',
  PRIMARY KEY (`id`),
  KEY `idx_organization` (`organization_name`),
  KEY `idx_status` (`booking_status`),
  KEY `idx_payment` (`payment_status`)
) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `group_bookings`
--

INSERT INTO `group_bookings` VALUES
(23,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',50,135000.00,'paid','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-06 11:39:41','2025-12-06 11:46:30',10.00,'percentage',13500.00,135000.00,121500.00),
(24,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',50,135000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-06 11:52:48','2025-12-06 13:16:29',10.00,'percentage',13500.00,135000.00,121500.00),
(25,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',50,135000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-06 11:53:06','2025-12-06 13:16:33',10.00,'percentage',13500.00,135000.00,121500.00),
(26,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',80,216000.00,'paid','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-06 12:00:08','2025-12-09 14:09:40',10.00,'percentage',21600.00,216000.00,194400.00),
(27,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',80,216000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-06 12:00:15','2025-12-06 13:16:16',10.00,'percentage',21600.00,216000.00,194400.00),
(28,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',80,216000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-06 12:00:31','2025-12-06 13:16:19',10.00,'percentage',21600.00,216000.00,194400.00),
(29,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',80,216000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-06 12:01:00','2025-12-09 14:06:39',10.00,'percentage',21600.00,216000.00,194400.00),
(30,NULL,NULL,NULL,NULL,'道東物産株式会社 - 営業部','高橋四郎','0154-555-5555','',100,270000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ああああ\n[キャンセル理由] 111',1,'2025-12-06 12:08:46','2025-12-06 12:18:07',10.00,'percentage',27000.00,270000.00,243000.00),
(31,NULL,NULL,NULL,NULL,'道東物産株式会社 - 営業部','高橋四郎','0154-555-5555','',100,270000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] 00',1,'2025-12-06 12:08:52','2025-12-06 12:21:06',10.00,'percentage',27000.00,270000.00,243000.00),
(32,NULL,NULL,NULL,NULL,'道東物産株式会社 - 営業部','高橋四郎','0154-555-5555','',100,270000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-06 12:09:08','2025-12-08 11:31:41',10.00,'percentage',27000.00,270000.00,243000.00),
(33,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',50,135000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-06 13:41:09','2025-12-06 13:41:30',10.00,'percentage',13500.00,135000.00,121500.00),
(34,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',20,54000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-06 13:46:37','2025-12-06 17:08:30',10.00,'percentage',5400.00,54000.00,48600.00),
(35,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 函館支店','田中二郎','0138-222-2222','',100,295000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-06 15:06:23','2025-12-06 15:06:23',10.00,'percentage',29500.00,295000.00,265500.00),
(36,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 函館支店','田中二郎','0138-222-2222','',100,300000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-06 15:06:51','2025-12-06 17:10:00',10.00,'percentage',30000.00,300000.00,270000.00),
(37,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',50,270000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] \n[キャンセル理由] ',1,'2025-12-06 16:12:30','2025-12-06 17:08:24',10.00,'percentage',27000.00,270000.00,243000.00),
(38,NULL,NULL,NULL,NULL,'てすとにっぽん','日本男児','てすと','',30,90000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-06 16:20:58','2025-12-06 16:20:58',12.00,'fixed',12.00,90000.00,89988.00),
(39,NULL,NULL,NULL,NULL,'てすとにっぽん','高橋四郎','てすと','',40,120000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-06 16:46:42','2025-12-06 16:46:42',12.00,'fixed',12.00,120000.00,119988.00),
(40,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',50,270000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-06 17:08:48','2025-12-08 11:23:25',10.00,'percentage',27000.00,270000.00,243000.00),
(41,NULL,NULL,NULL,NULL,'てすとにっぽん','日本男児','てすと','',30,90000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-06 17:12:08','2025-12-06 17:12:08',12.00,'fixed',12.00,90000.00,89988.00),
(42,NULL,NULL,NULL,NULL,'札幌市立第一中学校','山田先生','011-444-4444','',10,18000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-08 08:44:51','2025-12-08 13:56:34',0.00,'percentage',0.00,18000.00,18000.00),
(43,NULL,NULL,NULL,NULL,'札幌市立第一中学校','山田先生','011-444-4444','',10,27000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-08 09:35:01','2025-12-08 09:35:01',0.00,'percentage',0.00,27000.00,27000.00),
(44,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',80,141000.00,'paid','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-08 09:36:14','2025-12-08 11:39:32',10.00,'percentage',14100.00,141000.00,126900.00),
(45,NULL,NULL,NULL,NULL,'北海道観光株式会社','田中二郎','未設定','',10,25000.00,'paid','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-08 10:52:42','2025-12-08 11:40:10',10.00,'percentage',2500.00,25000.00,22500.00),
(46,NULL,NULL,NULL,NULL,'札幌市立第一中学校','山田先生','011-444-4444','',10,19500.00,'paid','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-08 11:31:09','2025-12-08 12:52:46',10.00,'percentage',1950.00,19500.00,17550.00),
(47,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',50,105000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-08 11:34:13','2025-12-08 11:34:37',10.00,'percentage',10500.00,105000.00,94500.00),
(48,NULL,NULL,NULL,NULL,'テスト団体 - 東京支社','山田太郎','09064002703','',20,108000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-08 14:04:06','2025-12-09 08:19:52',10.00,'percentage',10800.00,108000.00,97200.00),
(49,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',50,135000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-08 14:09:22','2025-12-09 08:19:40',10.00,'percentage',13500.00,135000.00,121500.00),
(50,NULL,NULL,NULL,NULL,'札幌市立第一中学校','山田先生','011-444-4444','',10,54000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] \n[キャンセル理由] ',1,'2025-12-08 14:10:28','2025-12-09 13:39:04',0.00,'percentage',0.00,54000.00,54000.00),
(51,NULL,NULL,NULL,NULL,'てすとにっぽん','花子','てすと','',55,148500.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-08 15:38:52','2025-12-09 08:19:57',12.00,'fixed',12.00,148500.00,148488.00),
(52,NULL,NULL,NULL,NULL,'船舶工業','船舶太郎','未設定','',30,81000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-09 08:39:10','2025-12-09 08:39:10',200.00,'fixed',200.00,81000.00,80800.00),
(53,NULL,NULL,NULL,NULL,'船舶工業','船舶太郎','未設定','',10,108000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] \n[キャンセル理由] \n[キャンセル理由] ',1,'2025-12-09 13:20:31','2025-12-09 13:31:34',200.00,'fixed',200.00,108000.00,107800.00),
(54,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',20,54000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-09 13:34:03','2025-12-09 13:34:03',10.00,'percentage',5400.00,54000.00,48600.00),
(55,NULL,NULL,NULL,NULL,'テスト団体 - 東京支社','山田太郎','09064002703','',30,66000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-09 13:40:06','2025-12-09 13:40:06',10.00,'percentage',6600.00,66000.00,59400.00),
(56,NULL,NULL,NULL,NULL,'JTB北海道 - 札幌支店','佐藤三郎','011-333-3333','',10,13000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-09 17:19:22','2025-12-12 17:10:19',5.00,'percentage',650.00,13000.00,12350.00),
(57,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 函館支店','田中二郎','0138-222-2222','',40,100000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-11 11:16:15','2025-12-11 16:43:02',10.00,'percentage',10000.00,100000.00,90000.00),
(58,NULL,NULL,NULL,NULL,'函館旅行代理店','函館太郎','48641654','',33,89100.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-11 11:21:47','2025-12-11 13:57:03',0.00,'fixed',0.00,89100.00,89100.00),
(59,NULL,NULL,NULL,NULL,'函館旅行代理店','函館太郎','48641654','',10,27000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-11 11:40:36','2025-12-11 11:42:52',0.00,'fixed',0.00,27000.00,27000.00),
(60,NULL,NULL,NULL,NULL,'船舶工業','船舶太郎','未設定','',10,27000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-11 11:42:24','2025-12-11 11:42:48',200.00,'fixed',200.00,27000.00,26800.00),
(61,NULL,NULL,NULL,NULL,'函館旅行代理店','函館太郎','48641654','',10,112220.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] a\n[キャンセル理由] a\n[キャンセル理由] a',1,'2025-12-11 11:51:16','2025-12-11 11:51:38',0.00,'fixed',0.00,112220.00,112220.00),
(62,NULL,NULL,NULL,NULL,'北海道観光株式会社 - 札幌本社','鈴木一郎','011-111-1111','',1,4500.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-11 11:57:41','2025-12-11 13:23:35',10.00,'percentage',450.00,4500.00,4050.00),
(63,NULL,NULL,NULL,NULL,'船舶工業','船舶太郎','未設定','',40,180000.00,'cancelled','bank_transfer','2025-12-11 17:00:27','cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-11 16:54:09','2025-12-12 15:28:48',200.00,'fixed',200.00,180000.00,179800.00),
(64,NULL,NULL,NULL,NULL,'函館旅行代理店','函館太郎','48641654','',13,35100.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-12 10:06:54','2025-12-12 10:22:35',0.00,'fixed',0.00,35100.00,35100.00),
(65,NULL,NULL,NULL,NULL,'札幌高等学校','札幌太郎','未設定','',20,50000.00,'paid','bank_transfer',NULL,'confirmed','checked_in','2025-12-12 16:03:25',NULL,'',1,'2025-12-12 10:21:22','2025-12-12 16:03:25',50.00,'percentage',25000.00,50000.00,25000.00),
(66,NULL,NULL,NULL,NULL,'船舶工業','船舶太郎','未設定','',10,27000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-12 10:32:23','2025-12-12 17:10:46',200.00,'fixed',200.00,27000.00,26800.00),
(67,NULL,NULL,NULL,NULL,'札幌高等学校','札幌太郎','未設定','',20,90000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-12 15:34:26','2025-12-12 15:40:28',50.00,'percentage',45000.00,90000.00,45000.00),
(68,NULL,NULL,NULL,NULL,'函館旅行代理店','函館太郎','48641654','',12,54000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2025-12-12 17:13:37','2025-12-12 17:18:26',0.00,'fixed',0.00,54000.00,54000.00),
(69,NULL,NULL,NULL,NULL,'札幌高等学校','札幌太郎','未設定','',30,101000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-12 17:35:09','2025-12-12 17:35:09',50.00,'percentage',50500.00,101000.00,50500.00),
(70,NULL,NULL,NULL,NULL,'てすとにっぽん','船舶太郎','026156165','',10,19500.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-12 17:39:01','2025-12-12 17:39:01',12.00,'fixed',12.00,19500.00,19488.00),
(71,NULL,NULL,NULL,NULL,'ゲスト','ゲスト','未設定','',5,5000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-19 13:20:51','2025-12-19 15:17:21',0.00,'fixed',0.00,10000.00,10000.00),
(72,NULL,NULL,NULL,NULL,'テスト団体 - 東京支社','山田太郎','09064002703','',10,45000.00,'paid','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-22 09:41:24','2025-12-22 11:31:15',10.00,'percentage',4500.00,45000.00,40500.00),
(73,NULL,NULL,NULL,NULL,'ゲスト','船舶太郎','未設定','',7,37000.00,'paid','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-22 09:54:29','2025-12-22 11:58:07',0.00,'fixed',0.00,31500.00,31500.00),
(74,NULL,NULL,NULL,NULL,'船舶工業','船舶太郎','未設定','',6,21150.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-22 11:04:04','2025-12-22 11:04:04',200.00,'fixed',200.00,21150.00,20950.00),
(75,NULL,NULL,NULL,NULL,'道東物産株式会社 - 営業部','高橋四郎','0154-555-5555','',12,54000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-22 11:28:34','2025-12-22 11:28:34',10.00,'percentage',5400.00,54000.00,48600.00),
(76,NULL,NULL,NULL,NULL,'札幌高等学校','札幌太郎','未設定','',3,6750.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-22 11:41:25','2025-12-22 11:41:25',50.00,'percentage',3375.00,6750.00,3375.00),
(77,NULL,NULL,NULL,NULL,'JTB北海道 - 札幌支店','佐藤三郎','011-333-3333','',38,127200.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-26 10:49:27','2025-12-26 10:59:49',10.00,'percentage',12720.00,127200.00,114480.00),
(78,NULL,NULL,NULL,NULL,'札幌市立第一中学校','山田先生','011-444-4444','',20,72000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2025-12-26 11:47:44','2025-12-26 12:01:28',0.00,'percentage',0.00,54000.00,54000.00),
(79,NULL,NULL,NULL,NULL,'テスト団体 - 東京支社','山田太郎','09064002703','',20,108000.00,'paid','bank_transfer','2026-01-06 14:26:07','confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-05 11:12:53','2026-01-06 14:26:07',10.00,'percentage',10800.00,108000.00,97200.00),
(80,NULL,NULL,NULL,NULL,'札幌高等学校','札幌太郎','未設定','',11,43200.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-09 14:54:00','2026-01-09 14:54:00',50.00,'percentage',21600.00,43200.00,21600.00),
(81,NULL,NULL,NULL,NULL,'じゃらん','未設定','未設定','',10,54000.00,'paid','bank_transfer','2026-01-13 11:15:14','confirmed','checked_in','2026-01-13 11:15:07',NULL,'',1,'2026-01-13 11:13:59','2026-01-13 11:15:14',0.00,'fixed',0.00,54000.00,54000.00),
(82,NULL,NULL,NULL,NULL,'JTB北海道 - 札幌支店','佐藤三郎','011-333-3333','',11,59400.00,'paid','bank_transfer','2026-01-13 15:48:37','confirmed','checked_in','2026-01-13 15:50:29',NULL,'',1,'2026-01-13 15:41:45','2026-01-13 15:50:29',10.00,'percentage',5940.00,59400.00,53460.00),
(83,NULL,NULL,NULL,NULL,'山富國際旅行社','未設定','未設定','',6,18900.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-13 16:18:38','2026-01-13 16:18:38',10.00,'percentage',1890.00,18900.00,17010.00),
(84,NULL,NULL,NULL,NULL,'JTB北海道 - 札幌支店','佐藤三郎','011-333-3333','',10,54000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] 11',1,'2026-01-14 14:33:25','2026-01-14 14:33:57',5.00,'percentage',2700.00,54000.00,51300.00),
(85,NULL,NULL,NULL,NULL,'JTB北海道 - 札幌支店','佐藤三郎','011-333-3333','',10,54000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] 11',1,'2026-01-14 14:34:28','2026-01-14 14:35:00',5.00,'percentage',2700.00,54000.00,51300.00),
(86,NULL,NULL,NULL,NULL,'JTB北海道 - 札幌支店','佐藤三郎','011-333-3333','',10,54000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-14 14:34:52','2026-01-14 14:34:52',5.00,'percentage',2700.00,54000.00,51300.00),
(87,NULL,NULL,NULL,NULL,'JTB北海道 - 札幌支店','佐藤三郎','011-333-3333','',80,432000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-14 14:41:25','2026-01-14 14:41:25',5.00,'percentage',21600.00,432000.00,410400.00),
(88,NULL,NULL,NULL,NULL,'テスト団体 - 東京支社','山田太郎','09064002703','',10,54000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-19 15:14:46','2026-01-19 15:14:46',10.00,'percentage',5400.00,54000.00,48600.00),
(89,'000089',NULL,NULL,NULL,'船舶工業','船舶太郎','未設定','',10,54000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-19 15:15:48','2026-01-22 16:13:29',200.00,'fixed',200.00,54000.00,53800.00),
(90,'000090',NULL,NULL,NULL,'テスト代理店 (2026)','山田太郎','09064002703','',20,74400.00,'paid','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-21 16:58:48','2026-01-22 16:13:22',0.00,'fixed',0.00,74400.00,74400.00),
(91,'000091',NULL,NULL,NULL,'じゃらん','未設定','未設定','',10,40000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2026-01-22 14:04:16','2026-01-23 08:15:21',0.00,'fixed',0.00,40000.00,40000.00),
(92,'000093',NULL,NULL,NULL,'トリバゴ団体','トリバゴ','未設定','',5,20000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-22 15:03:19','2026-01-22 15:03:32',0.00,'fixed',0.00,20000.00,20000.00),
(93,'000095',NULL,NULL,NULL,'テスト団体','山田太郎','09064002703','',5,20000.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2026-01-22 15:04:07','2026-01-23 08:15:25',10.00,'percentage',2000.00,20000.00,18000.00),
(94,'000096',NULL,NULL,NULL,'じゃらん','未設定','未設定','',6,24000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-22 15:34:21','2026-01-22 16:14:15',0.00,'fixed',0.00,24000.00,24000.00),
(95,'000092',NULL,NULL,NULL,'テスト団体','山田太郎','09064002703','',4,16000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-22 15:34:53','2026-01-22 16:10:27',10.00,'percentage',1600.00,16000.00,14400.00),
(96,'000097',NULL,NULL,NULL,'船舶工業','船舶太郎','未設定','',8,32000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-22 16:14:56','2026-01-22 16:14:56',200.00,'fixed',200.00,32000.00,31800.00),
(97,'000098',NULL,NULL,NULL,'JTB北海道','佐藤三郎','011-333-3333','',5,22500.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-23 13:58:36','2026-01-26 09:17:31',5.00,'percentage',1125.00,22500.00,21375.00),
(98,'000099',NULL,NULL,NULL,'じゃらん','未設定','未設定','',10,10800.00,'paid','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-26 09:30:00','2026-01-26 09:31:00',0.00,'fixed',0.00,10800.00,10800.00),
(99,'000100',NULL,NULL,NULL,'船舶工業','船舶太郎','未設定','',11,44000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-27 14:10:29','2026-01-27 15:13:54',200.00,'fixed',200.00,40000.00,39800.00),
(100,'000101',NULL,NULL,NULL,'じゃらん','未設定','未設定','',3,6600.00,'paid','bank_transfer',NULL,'confirmed','checked_in','2026-01-28 13:22:54',NULL,'',1,'2026-01-28 11:33:42','2026-01-28 13:40:43',100.00,'fixed',100.00,6600.00,6500.00),
(101,'000102',NULL,NULL,NULL,'船舶工業','船舶太郎','未設定','',2,8000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-28 13:59:31','2026-01-28 13:59:31',200.00,'fixed',200.00,8000.00,7800.00),
(102,'000103',NULL,NULL,NULL,'JTB北海道','佐藤三郎','011-333-3333','',2,8000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-28 18:15:08','2026-01-28 18:15:08',5.00,'percentage',400.00,8000.00,7600.00),
(103,'000104',NULL,NULL,NULL,'トリバゴ団体','トリバゴ','未設定','',1,4000.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-28 18:17:51','2026-01-28 18:17:51',0.00,'fixed',0.00,4000.00,4000.00),
(104,'000105',NULL,NULL,NULL,'Trip団体','未設定','未設定','',1,4500.00,'paid','bank_transfer','2026-01-29 15:07:52','confirmed','checked_in','2026-01-29 15:07:37',NULL,'',1,'2026-01-29 09:13:54','2026-01-29 15:07:52',4500.00,'fixed',4500.00,4500.00,0.00),
(105,'000106',NULL,NULL,NULL,'Trip団体2','未設定','未設定','',2,9000.00,'pending','bank_transfer',NULL,'confirmed','checked_in','2026-01-29 11:07:24',NULL,'',1,'2026-01-29 11:05:41','2026-01-29 11:07:31',0.00,'fixed',0.00,9000.00,9000.00),
(106,'000107',NULL,NULL,NULL,'じゃらん','未設定','未設定','',1,1200.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-01-30 10:17:13','2026-01-30 10:17:13',0.00,'fixed',0.00,1200.00,1200.00),
(107,'000108',NULL,NULL,NULL,'Trip団体','未設定','未設定','',6,17700.00,'paid','bank_transfer',NULL,'confirmed','checked_in','2026-01-30 10:36:18',NULL,'',1,'2026-01-30 10:24:55','2026-01-30 14:24:37',0.00,'fixed',0.00,17700.00,17700.00),
(108,'000109',NULL,NULL,NULL,'Trip団体','未設定','未設定','',4,14400.00,'paid','bank_transfer','2026-02-04 10:38:15','confirmed','not_checked_in',NULL,NULL,'',1,'2026-02-04 10:37:35','2026-02-04 10:38:15',14400.00,'fixed',14400.00,14400.00,0.00),
(109,'000110',NULL,NULL,NULL,'函館旅行','函館太郎','48641654','',3,5100.00,'paid','bank_transfer','2026-02-04 10:58:02','confirmed','not_checked_in',NULL,NULL,'',1,'2026-02-04 10:56:31','2026-02-04 10:58:02',0.00,'fixed',0.00,5100.00,5100.00),
(110,'000111',NULL,NULL,NULL,'テスト団体','山田太郎','09064002703','',2,5400.00,'cancelled','bank_transfer','2026-02-05 08:24:37','cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2026-02-05 08:24:09','2026-02-05 09:51:21',10.00,'percentage',540.00,5400.00,4860.00),
(111,'000112',NULL,NULL,NULL,'テスト団体','山田太郎','09064002703','',3,8100.00,'cancelled','bank_transfer','2026-02-05 09:22:57','cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2026-02-05 09:22:31','2026-02-05 09:51:32',10.00,'percentage',810.00,8100.00,7290.00),
(112,'000113',1,1,2,'テスト団体','山田太郎','09064002703','',3,6600.00,'paid','bank_transfer','2026-02-05 09:52:19','confirmed','not_checked_in',NULL,NULL,'',1,'2026-02-05 09:52:10','2026-02-05 10:59:04',10.00,'percentage',660.00,6600.00,5940.00),
(113,'000114',12,5,3,'じゃらん','未設定','未設定','',5,7800.00,'paid','bank_transfer','2026-02-05 11:10:44','confirmed','checked_in','2026-02-05 15:18:51',NULL,'',1,'2026-02-05 11:10:33','2026-02-05 15:20:16',100.00,'fixed',100.00,9000.00,8900.00),
(114,'000115',10,6,5,'船舶工業','船舶太郎','未設定','',2,3900.00,'paid','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-02-05 13:07:23','2026-02-05 13:07:33',200.00,'fixed',200.00,3900.00,3700.00),
(115,'000116',1,1,2,'テスト団体 - 東京支社','山田太郎','09064002703','',1,5400.00,'paid','bank_transfer','2026-02-05 15:48:42','confirmed','checked_in','2026-02-05 15:48:53',NULL,'',1,'2026-02-05 15:48:09','2026-02-05 15:48:53',10.00,'percentage',540.00,5400.00,4860.00),
(116,'000117',1,1,2,'テスト団体　組織名','山田太郎','09064002703','',5,17400.00,'paid','bank_transfer','2026-02-06 13:04:11','confirmed','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2026-02-06 08:49:32','2026-02-06 13:04:11',0.00,'fixed',0.00,13500.00,17400.00),
(117,'000118',12,5,3,'じゃらん 会社名','未設定','未設定','',3,16200.00,'cancelled','bank_transfer','2026-02-06 09:23:38','cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2026-02-06 09:03:37','2026-02-06 11:51:46',0.00,'fixed',0.00,16200.00,16200.00),
(118,'000119',17,10,13,'Trip団体 会社名','トリバゴ','未設定','',5,27000.00,'cancelled','bank_transfer','2026-02-06 09:28:21','cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2026-02-06 09:14:54','2026-02-06 11:51:43',0.00,'fixed',0.00,27000.00,27000.00),
(119,'000120',17,10,13,'Trip団体（領収書宛名）','未設定','未設定','',3,16200.00,'paid','bank_transfer','2026-02-06 14:25:39','confirmed','checked_in','2026-02-06 14:25:35',NULL,'',1,'2026-02-06 14:24:07','2026-02-06 15:35:11',10.00,'fixed',10.00,16200.00,16190.00),
(120,'000121',12,5,3,'じゃらん団体名','未設定','未設定','',6,14400.00,'paid','bank_transfer','2026-02-06 15:34:30','confirmed','not_checked_in',NULL,NULL,'',1,'2026-02-06 14:50:41','2026-02-06 15:34:30',0.00,'fixed',0.00,12000.00,14400.00),
(121,'000122',17,10,13,'Trip団体','未設定','未設定','',4,14400.00,'paid','bank_transfer','2026-02-09 10:40:57','confirmed','not_checked_in',NULL,NULL,'',1,'2026-02-09 09:23:30','2026-02-09 17:31:47',100.00,'fixed',100.00,14400.00,14300.00),
(122,'000123',12,5,3,'じゃらん団体名','未設定','未設定','',2,5400.00,'paid','bank_transfer','2026-02-10 10:11:40','confirmed','not_checked_in',NULL,NULL,'',1,'2026-02-10 10:11:21','2026-02-10 10:11:55',200.00,'fixed',200.00,5400.00,5200.00),
(123,'000124',17,10,13,'Trip団体','未設定','未設定','',3,16200.00,'cancelled','bank_transfer',NULL,'cancelled','not_checked_in',NULL,NULL,'\n[キャンセル理由] ',1,'2026-02-13 09:35:40','2026-02-13 09:36:15',0.00,'fixed',0.00,16200.00,16200.00),
(124,'000125',17,10,13,'Trip団体','未設定','未設定','',2,5400.00,'pending','bank_transfer',NULL,'confirmed','not_checked_in',NULL,NULL,'',1,'2026-02-13 09:47:50','2026-02-13 09:47:50',0.00,'fixed',0.00,5400.00,5400.00);


