更新内容
1、修复对接监控无法同步商品名称和状态的问题
2、新增后台可统计指定时间段内的每个会员消费汇总
3、对接监控新增同步商品状态开关
4、重构工单模块，全新的工单系统，更快捷处理售后
5、优化卡密二维码标记功能，以免客户误以为是被扫过的码
6、API新增IP白名单功能
7、API支持会员重置对接秘钥（需配置短信SMS服务）
8、修复后台设置库存隐藏不生效的问题
9、新增后台可设置隐藏销量
10、新版后台UI
11、...还有一些更新项目记不得了，自己体验吧
执行SQL
CREATE INDEX idx_order_daily_stats ON sd_order (time, daili, goodid, status);
CREATE TABLE sd_userConsumption (id VARCHAR(30) NOT NULL , user_id VARCHAR(10) NOT NULL , date DATE NOT NULL , order_count INT(11) NOT NULL , total_amount DECIMAL(10,2) NOT NULL ) ENGINE = InnoDB;
ALTER TABLE sd_userConsumption ADD PRIMARY KEY(id);
ALTER TABLE sd_user ADD balanceThreshold DECIMAL(6,2) NOT NULL DEFAULT '20' AFTER phone;
ALTER TABLE sd_user ADD ipWhitelist TEXT NULL AFTER balanceThreshold;
ALTER TABLE sd_user ADD INDEX(id, money);
ALTER TABLE sd_order ADD INDEX(status, goodtype);
TRUNCATE TABLE sd_wo;
TRUNCATE TABLE sd_wo_comment;
ALTER TABLE sd_wo DROP ip;
ALTER TABLE sd_wo CHANGE type status INT(1) NOT NULL DEFAULT '1';
ALTER TABLE sd_wo CHANGE time created_at TIMESTAMP NOT NULL;
ALTER TABLE sd_wo CHANGE content title VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE sd_wo ADD updated_at TIMESTAMP NOT NULL;
ALTER TABLE sd_wo ADD last_sender_type INT(1) NOT NULL DEFAULT '1';
ALTER TABLE sd_wo ADD last_reply_at TIMESTAMP NOT NULL;
ALTER TABLE sd_wo ADD user_id VARCHAR(10) NOT NULL DEFAULT '0';
ALTER TABLE sd_wo_comment CHANGE order_id wo_id VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE sd_wo_comment CHANGE content message TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE sd_wo_comment DROP role;
ALTER TABLE sd_wo_comment ADD sender_type INT(1) NOT NULL DEFAULT '1' AFTER ip;
ALTER TABLE sd_wo_comment ADD message_type INT(1) NOT NULL DEFAULT '1' AFTER sender_type;
ALTER TABLE sd_wo_comment CHANGE time created_at TIMESTAMP NOT NULL;
ALTER TABLE sd_wo_comment CHANGE ip created_ip VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE sd_goods DROP count_set;
ALTER TABLE sd_goodDetail ADD count_set INT(1) NOT NULL DEFAULT '1';
ALTER TABLE sd_goodDetail ADD sales_set INT(1) NOT NULL DEFAULT '1';
必做的一步
sourceguardian.enable_vm_hybrid=1
请将上面这一行代码，放在php8.2的配置文件里，然后保存重启php8.2即可，如下图所示
