【7/20】冒険応援パス #2930

https://docs.google.com/spreadsheets/d/1clgzWBhe8EkYAXkPaWoa33gSogdbp7NI8Q_5hQBD76g/edit#gid=444713796
消費コイン、機能のON/OFFを変更できるように

• [x] 期限付きアイテムをプレゼントするか
• [x] 購入処理
• [x] 集計、ログ関連修正

テーブル

CREATE TABLE `cpanel_daily_monthly_pass_log` (
  `date` date NOT NULL,
  `cumulative_uu` int(11) NOT NULL COMMENT '累計購入者数',
  `repeat_uu` int(11) NOT NULL COMMENT '再購入者数',
  `potential_uu` int(11) NOT NULL COMMENT '潜在購入者',
  `validity_uu` int(11) NOT NULL,
  `new_uu` int(11) NOT NULL,
  `subscriber_uu` int(11) NOT NULL,
  `expired_uu` int(11) NOT NULL,
  PRIMARY KEY (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `user_monthly_pass` (
  `user_no` int(10) unsigned NOT NULL,
  `type` int(11) NOT NULL,
  `receive_count` int(11) NOT NULL,
  `last_receive` timestamp NULL DEFAULT NULL,
  `limit_time` timestamp NOT NULL,
  `last_limit_time` timestamp NULL DEFAULT NULL,
  `first_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `log_monthly_pass_daliy_item` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_no` int(10) unsigned NOT NULL,
  `type` smallint(5) unsigned NOT NULL,
  `item_type` int(10) unsigned NOT NULL,
  `item_no` int(10) unsigned NOT NULL,
  `item_count` int(10) unsigned NOT NULL,
  `reg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `type` (`type`,`reg_date`),
  KEY `user_no` (`user_no`,`reg_date`),
  KEY `reg_date` (`reg_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

修正画像

• ボタン

monthlypass/buy_btn.png
monthlypass/continue_btn.png

• バナー

monthlypass/pass_banner_first.png
monthlypass/pass_banner.png

• ショップバナー

shop/itembanner_86.jpg
shop/itembanner_186.jpg