运行截图
源码贡献
https://githubs.xyz/boot?app=40
--
-- 表的结构 `la_box_mark`
--CREATE TABLE `la_box_mark` (`id` int(10) UNSIGNED NOT NULL,`icon` varchar(191) COLLATE utf8_unicode_ci DEFAULT '',`bg_thumb` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,`title` varchar(191) COLLATE utf8_unicode_ci DEFAULT '',`sort` int(10) UNSIGNED DEFAULT '0',`color` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='抽盒 - 奖赏类型' ROW_FORMAT=DYNAMIC;--
-- 转存表中的数据 `la_box_mark`
--INSERT INTO `la_box_mark` (`id`, `icon`, `bg_thumb`, `title`, `sort`, `color`) VALUES
(1, '/uploads/other/mark1.png', '/uploads/other/mark_bg1.png', '传说款', 1, '#E6536D'),
(2, '/uploads/other/mark2.png', '/uploads/other/mark_bg2.png', '史诗款', 2, '#CC9933 '),
(3, '/uploads/other/mark3.png', '/uploads/other/mark_bg3.png', '稀有款', 3, '#1f19af'),
(4, '/uploads/other/mark4.png', '/uploads/other/mark_bg4.png', '普通款', 4, '#0D6BC9');-- ----------------------------------------------------------
-- 表的结构 `la_box_rating`
--CREATE TABLE `la_box_rating` (`id` int(10) UNSIGNED NOT NULL,`box_id` int(10) UNSIGNED NOT NULL COMMENT '盒子ID',`user_id` int(10) UNSIGNED NOT NULL COMMENT '用户ID',`goods_id` int(10) UNSIGNED NOT NULL COMMENT '奖品ID',`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '奖品名称',`star` int(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT '星级',`content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',`thumb` text COLLATE utf8mb4_unicode_ci COMMENT '图',`is_hidden` int(1) UNSIGNED DEFAULT '2' COMMENT '是否匿名：1匿名，2不匿名',`created_at` int(10) UNSIGNED DEFAULT NULL,`updated_at` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='抽盒 - 评价' ROW_FORMAT=DYNAMIC;-- ----------------------------------------------------------
-- 表的结构 `la_complain`
--CREATE TABLE `la_complain` (`id` int(10) UNSIGNED NOT NULL,`user_id` int(10) UNSIGNED NOT NULL COMMENT '用户ID',`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '分类名称',`mobile` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '联系电话',`content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',`thumb` text COLLATE utf8mb4_unicode_ci COMMENT '图',`reply` text COLLATE utf8mb4_unicode_ci COMMENT '回复内容',`status` int(1) UNSIGNED DEFAULT '0',`created_at` int(10) UNSIGNED DEFAULT NULL,`updated_at` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='投诉' ROW_FORMAT=DYNAMIC;--
-- 转存表中的数据 `la_complain`
--INSERT INTO `la_complain` (`id`, `user_id`, `title`, `mobile`, `content`, `thumb`, `reply`, `status`, `created_at`, `updated_at`) VALUES
(1, 93, '投诉退款', '18824852873', '小孩子乱点麻烦退款谢谢', NULL, NULL, 0, 1704296242, 1704296242),
(2, 133, '延迟发货', '15622996651', '支付了没有什么也没有', '/uploads/upload/index/2024/01/07/fd5d33231f7fb23ced04956c168f2ced.png', NULL, 0, 1704627665, 1704627665);-- ----------------------------------------------------------
-- 表的结构 `la_complain_type`
--CREATE TABLE `la_complain_type` (`id` int(10) UNSIGNED NOT NULL,`title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',`sort` int(10) UNSIGNED NOT NULL DEFAULT '0',`created_at` int(10) UNSIGNED DEFAULT NULL,`updated_at` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='投诉 - 分类' ROW_FORMAT=DYNAMIC;--
-- 转存表中的数据 `la_complain_type`
--INSERT INTO `la_complain_type` (`id`, `title`, `sort`, `created_at`, `updated_at`) VALUES
(1, '发货时间', 0, 1669619974, 1669619974),
(2, '投诉退款', 1, 1669620022, 1683104558),
(3, '延迟发货', 2, 1683104567, 1683104567);-- ----------------------------------------------------------
-- 表的结构 `la_configuration`
--CREATE TABLE `la_configuration` (`id` bigint(20) UNSIGNED NOT NULL,`group_id` int(11) NOT NULL DEFAULT '0' COMMENT '组ID',`label` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '配置项名称',`key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '配置项字段',`val` text COLLATE utf8mb4_unicode_ci COMMENT '配置项值',`type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'input' COMMENT '配置项类型，input输入框，radio单选，select下拉,image单图片',`content` text COLLATE utf8mb4_unicode_ci COMMENT '配置项类型的内容',`tips` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '输入提示',`sort` tinyint(4) NOT NULL DEFAULT '10' COMMENT '排序',`status` int(1) UNSIGNED NOT NULL DEFAULT '1',`translate` int(1) UNSIGNED NOT NULL DEFAULT '2',`created_at` timestamp NULL DEFAULT NULL,`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='后台 - 配置项表' ROW_FORMAT=DYNAMIC;--
-- 转存表中的数据 `la_configuration`
--INSERT INTO `la_configuration` (`id`, `group_id`, `label`, `key`, `val`, `type`, `content`, `tips`, `sort`, `status`, `translate`, `created_at`, `updated_at`) VALUES
(5, 1, '标题', 'site_title', '叮咚魔盒', 'input', '', '', 10, 1, 2, '2022-07-11 01:50:06', '2024-01-17 13:07:10'),
(17, 2, '上传图片类型', 'storage_image_type', 'jpg,png,gif,jpeg', 'input', NULL, NULL, 1, 1, 2, '2022-07-16 07:40:57', '2022-07-16 07:40:57'),
(18, 2, '上传图片最大(M)', 'storage_image_size', '5', 'input', NULL, NULL, 2, 1, 2, '2022-07-16 07:41:34', '2023-03-24 07:24:33'),
(21, 5, '项目Logo', 'app_logo', '/uploads/upload/image/0c467a84-834e-0766-500d-d5440e0c899b.png', 'image', NULL, '', 1, 1, 1, '2022-07-16 08:54:49', '2023-11-16 12:22:20'),
(28, 6, '是否开启真实短信', 'sms_switch', '2', 'radio', '{\"关闭\":\"2\",\"开启\":\"1\"}', '', 1, 1, 2, '2022-07-16 11:37:01', '2022-07-18 01:17:27'),
(29, 6, '短信类型', 'sms_type', 'aliyun', 'radio', '{\"阿里云\":\"aliyun\",\"腾讯云\":\"qcloud\"}', NULL, 2, 1, 2, '2022-07-16 11:39:34', '2022-07-16 13:01:20'),
(30, 6, '阿里云AccessKey', 'sms_aliyun_access_key', NULL, 'input', NULL, '', 3, 1, 2, '2022-07-16 11:42:01', '2022-11-22 06:22:57'),
(31, 6, '阿里云SecretKey', 'sms_aliyun_secret_key', NULL, 'input', NULL, NULL, 4, 1, 2, '2022-07-16 11:42:55', '2022-11-22 06:22:57'),
(32, 6, '阿里云Signname', 'sms_aliyun_signname', NULL, 'input', NULL, NULL, 5, 1, 2, '2022-07-16 11:44:21', '2022-11-22 06:22:57'),
(33, 6, '阿里云Template_id', 'sms_aliyun_template_id', NULL, 'input', NULL, NULL, 6, 1, 2, '2022-07-16 11:45:18', '2022-11-22 06:22:57'),
(34, 6, '腾讯云AccessKey', 'sms_qcloud_access_key', NULL, 'input', NULL, NULL, 7, 1, 2, '2022-07-16 11:50:11', '2022-09-08 03:18:15'),
(35, 6, '腾讯云SecretKey', 'sms_qcloud_secret_key', NULL, 'input', NULL, NULL, 8, 1, 2, '2022-07-16 11:50:51', '2022-09-08 03:18:15'),
(36, 6, '腾讯云Signname', 'sms_qcloud_signname', NULL, 'input', NULL, NULL, 9, 1, 2, '2022-07-16 11:51:28', '2022-07-16 11:51:28'),
(37, 6, '腾讯云Template_id', 'sms_qcloud_template_id', NULL, 'input', NULL, NULL, 10, 1, 2, '2022-07-16 11:52:05', '2022-09-08 03:18:15'),
(38, 7, '小程序Appid', 'mini_appid', 'www.zhankey.com', 'input', NULL, NULL, 1, 1, 2, '2022-07-16 12:03:12', '2024-04-14 04:17:51'),
(39, 7, '小程序Secret', 'mini_secret', 'www.zhankey.com', 'input', NULL, NULL, 2, 1, 2, '2022-07-16 12:08:47', '2024-04-14 04:17:51'),
(40, 7, '支付商户号Key', 'mini_key', 'www.zhankey.com', 'input', NULL, NULL, 3, 1, 2, '2022-07-16 12:08:49', '2024-04-14 04:17:37'),
(41, 7, '支付商户号', 'mini_mch', 'www.zhankey.com', 'input', NULL, NULL, 4, 1, 2, '2022-07-16 12:08:52', '2024-04-14 04:17:51'),
(49, 2, '上传音频类型', 'storage_audio_type', 'mp3', 'input', NULL, NULL, 3, 1, 2, '2022-09-23 06:50:17', '2022-09-23 06:50:17'),
(50, 2, '上传音频最大', 'storage_audio_size', '5', 'input', NULL, NULL, 4, 1, 2, '2022-09-23 06:51:04', '2022-09-23 06:51:04'),
(51, 2, '上传视频类型', 'storage_video_type', 'mp4', 'input', NULL, NULL, 5, 1, 2, '2022-09-23 06:52:03', '2022-09-23 06:52:03'),
(52, 2, '上传视频最大(M)', 'storage_video_size', '10', 'input', NULL, NULL, 6, 1, 2, '2022-09-23 06:52:53', '2022-09-23 06:52:53'),
(53, 2, '上传文件类型', 'storage_file_type', 'xlsl', 'input', NULL, NULL, 7, 1, 2, '2022-09-23 06:54:29', '2022-09-23 06:54:29'),
(54, 2, '上传文件最大(M)', 'storage_file_size', '10', 'input', NULL, NULL, 8, 1, 2, '2022-09-23 06:54:56', '2022-09-23 06:54:56'),
(71, 9, '普通地区运费', 'express_fare', '10', 'input', NULL, NULL, 1, 1, 2, '2022-10-09 10:06:14', '2023-10-12 11:07:32'),
(84, 9, '快递缓存时间', 'express_cache_times', '30', 'input', NULL, NULL, 2, 1, 2, '2022-10-21 09:57:01', '2022-10-21 09:57:01'),
(85, 9, '快递Appcode', 'express_appcode', '36972247bfa1478d8e9e4c753387170f', 'input', NULL, NULL, 3, 1, 2, '2022-10-21 09:59:22', '2023-06-04 13:34:11'),
(86, 9, '偏远地区运费', 'express_far_fare', '25', 'input', NULL, '分别是：新疆，西藏，甘肃，宁夏，青海，内蒙古。', 4, 1, 2, '2022-11-25 07:10:09', '2023-10-12 11:07:32'),
(87, 10, '提现手续费(%)', 'withdraw_handling_rate', '1', 'input', NULL, '', 1, 1, 2, '2022-11-30 08:01:21', '2023-05-24 14:15:43'),
(88, 10, '每日提现上限(次)', 'withdraw_day_max', '10', 'input', NULL, NULL, 2, 1, 2, '2022-11-30 08:02:39', '2022-11-30 08:02:39'),
(89, 11, '奖品比例', 'luckbox_award_rate', '1.00,3.00,26.00,70.00', 'input', NULL, '分别为：传说款，史诗款，稀有款，普通款（例：1.00,3.00,26.00,70.00 逗号拼接）', 1, 1, 2, '2022-12-05 06:48:03', '2022-12-05 06:50:50'),
(90, 11, '所需积分', 'luckbox_need_coin', '6', 'input', NULL, NULL, 2, 1, 2, '2022-12-05 10:08:46', '2022-12-05 10:08:46'),
(91, 11, '超值隐藏所需进度', 'luckbox_hiden_need', '10', 'input', NULL, NULL, 3, 1, 2, '2022-12-05 10:11:14', '2022-12-08 02:03:56'),
(92, 5, '分享海报', 'app_poster', '/uploads/upload/image/e87fa5a9-50f1-5bd4-beb8-f2c81af0c55a.jpeg', 'image', NULL, NULL, 2, 1, 1, '2022-12-08 06:39:43', '2023-12-19 08:41:51'),
(93, 7, '支付回调接口', 'mini_notify_url', 'api/v1/wxpay/notify', 'input', NULL, NULL, 5, 1, 2, '2022-12-10 03:51:10', '2022-12-10 03:51:50'),
(94, 12, '开启所需积分', 'open_redpack_coin', '888', 'input', NULL, NULL, 1, 1, 2, '2023-01-09 07:21:10', '2023-05-27 19:27:32'),
(95, 12, '最高红包金额', 'redpack_max_money', '888', 'input', NULL, '仅作为展示', 2, 1, 2, '2023-01-09 07:34:56', '2023-01-09 07:34:56'),
(96, 2, '阿里云accessid:', 'access_key_id', 'LTAI5tByMg8e2mtF3bU4szpY', 'input', NULL, '', 10, 1, 2, '2023-05-03 13:55:40', '2023-05-05 18:20:29'),
(97, 2, '阿里云accesskey', 'access_key_secret', 'NQSCPpFLeQvGk7LHNKrvIZcUwK9h2P', 'input', NULL, NULL, 11, 1, 2, '2023-05-03 13:56:36', '2023-05-05 18:20:29'),
(98, 2, '阿里云oss实例地址', 'endpoint', 'oss-cn-shanghai.aliyuncs.com', 'input', NULL, NULL, 13, 1, 2, '2023-05-03 13:59:25', '2023-05-03 14:06:19'),
(99, 2, '阿里云存储空间名称:', 'bucket', 'yundongmh', 'input', NULL, NULL, 14, 1, 2, '2023-05-03 13:59:53', '2023-05-05 18:20:29'),
(100, 5, '邀请好友背景图', 'share_bg', 'https://hdcs.xby6991282.xyz/uploads/upload/image/e55ca78f-27cb-afcd-52de-5e9a1903f692.png', 'image', NULL, NULL, 3, 1, 2, '2023-05-05 12:11:27', '2023-11-16 12:22:20'),
(101, 5, '邀请好友海报背景图', 'poster_bg', 'https://hdcs.xby6991282.xyz/uploads/upload/image/c6e92b21-ba20-8105-3ab0-c613e4af88a4.jpeg', 'image', NULL, NULL, 4, 1, 2, '2023-05-05 13:15:46', '2023-12-19 08:41:51'),
(102, 1, '一级分佣比例%:', 'rebate_one', '0', 'input', NULL, NULL, 1, 1, 2, '2023-05-05 16:00:32', '2024-04-10 18:40:01'),
(103, 1, '二级分佣比例%', 'rebate_two', '0', 'input', NULL, NULL, 2, 1, 2, '2023-05-05 16:00:52', '2024-04-10 18:40:01'),
(104, 1, '三级分佣比例%', 'rebate_three', '0', 'input', NULL, NULL, 3, 1, 2, '2023-05-05 16:01:10', '2023-05-06 07:30:23'),
(105, 1, '回收比例', 'dissolve_rate', '0.3', 'input', NULL, NULL, 0, 1, 2, '2023-05-23 20:09:02', '2023-10-12 11:06:12'),
(106, 1, '首页弹窗内容', 'pop_con', '测试', 'textarea', NULL, NULL, 6, 1, 2, '2023-06-05 04:02:11', '2023-10-30 14:28:13'),
(107, 1, '溶解开关', 'rongjie', '1', 'select', '{\"0\":\"关闭\",\"1\":\"开启\"}', '盲盒溶解开关', 20, 1, 2, '2023-09-07 07:39:28', '2023-12-12 16:17:56'),
(110, 1, '抽盒公告', 'chgg', '迎51拿好礼 100%中奖开盒即送 数码 手办 外设 等你来拿', 'input', NULL, NULL, 99, 1, 2, '2023-09-07 08:46:08', '2024-04-10 18:39:56'),
(111, 2, '本地图片', 'img_tyle', '1', 'select', '{\"0\":\"关闭\",\"1\":\"开启\"}', NULL, 0, 1, 2, '2023-09-27 05:28:10', '2023-10-12 10:43:40');-- ----------------------------------------------------------
-- 表的结构 `la_config_group`
--CREATE TABLE `la_config_group` (`id` bigint(20) UNSIGNED NOT NULL,`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',`sort` tinyint(4) NOT NULL DEFAULT '10' COMMENT '排序',`status` int(1) UNSIGNED NOT NULL DEFAULT '1',`created_at` timestamp NULL DEFAULT NULL,`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='后台 - 配置组表' ROW_FORMAT=DYNAMIC;--
-- 转存表中的数据 `la_config_group`
--INSERT INTO `la_config_group` (`id`, `name`, `sort`, `status`, `created_at`, `updated_at`) VALUES
(1, '站点配置', 1, 1, '2022-07-11 01:50:06', '2022-07-11 01:50:06'),
(2, '存储配置', 2, 1, '2022-07-11 01:50:06', '2022-07-11 01:50:06'),
(5, '项目配置', 5, 1, '2022-07-11 03:01:41', '2022-07-11 03:01:41'),
(6, '短信配置', 6, 2, '2022-07-16 11:36:01', '2022-07-16 11:36:01'),
(7, '小程序配置', 7, 1, '2022-07-16 12:02:15', '2022-07-16 12:02:17'),
(9, '快递配置', 10, 1, '2022-10-09 10:05:02', '2022-10-09 10:05:04'),
(10, '提现配置', 8, 1, '2022-11-30 08:00:04', '2022-11-30 08:00:05'),
(11, '幸运盲盒配置', 9, 1, '2022-12-05 06:45:02', '2022-12-05 06:45:03'),
(12, '开红包设置', 11, 1, '2023-01-09 07:19:36', '2023-01-09 07:19:37');
