PR

【6/12】5周年特別客 #1084

kouho opened this at 2025-05-15T17:18:05; closed

Description

opened by kouho at 2025-05-15T17:18:05; updated 2025-06-13T15:23:15

概要

https://docs.google.com/spreadsheets/d/1FNwS6J7xLVARBywmDNE8iEz7fHtBN0j-IqoJgztFBbs/edit?gid=833960214#gid=833960214

半額はweb側で対応
仕様書に記載されているGOLD額は半額後

INSERT INTO `master_deluxe_bar_card_exec_list` (`card_no`, `start_date`, `next_reg_date`)
VALUES
(9024, 20250616, 20250616),
(9032, 20250616, 20250616),
(9107, 20250617, 20250617),
(9106, 20250617, 20250617),
(9008, 20250618, 20250618),
(9009, 20250618, 20250618),
(9010, 20250618, 20250618),
(9032, 20250619, 20250619),
(9002, 20250619, 20250619),
(9010, 20250620, 20250620),
(9009, 20250620, 20250620),
(9024, 20250621, 20250621),
(9008, 20250621, 20250621),
(9106, 20250622, 20250622),
(9032, 20250622, 20250622),
(9010, 20250623, 20250623),
(9009, 20250623, 20250623),
(9107, 20250624, 20250624),
(9002, 20250624, 20250624),
(9021, 20250625, 20250625),
(9107, 20250625, 20250625),
(9106, 20250625, 20250625),
(9024, 20250626, 20250626),
(9032, 20250626, 20250626),
(9002, 20250627, 20250627),
(9106, 20250627, 20250627),
(9105, 20250628, 20250628),
(9008, 20250628, 20250628),
(9107, 20250629, 20250629),
(9032, 20250629, 20250629),
(9024, 20250630, 20250630),
(9021, 20250701, 20250701);

クエリ実行時に特別客データ入っている場合、クエリ実行+既存設定の削除が必要

wada add_label at 2025-06-03T14:50:42: 和田 LGTM
kouho change_title at 2025-06-10T17:03:19: [WIP]5周年特別客 【6/12】5周年特別客
kouho merge at 2025-06-13T15:23:15: 【6/12】5周年特別客
kouho close at 2025-06-13T15:23:15: Close

Commit range

basecc8e5e509c4c1b6ed6a4a8e6d4593c6d11dd3c4d
head7c6d15dd3da35c1fe898ed1a680f5f4a0e0ca063
base branchjolly/jrye-db:master
head branchjolly/jrye-db:anniv_5th_bar_card

View commits

Commit details are loaded from Git when a dynamic archive server is running, or can be embedded with --include-commits.
Files changed1 filesView patch
statusfile
modifiedcsv/master_deluxe_bar_card.csv
Patch body is stored as a separate file to keep this page lightweight.