某电商网站的数据库设计（2）

某电商网站的数据库设计（2）——商品销售相关数据表的设计

四、销售信息表

1、非套装商品销售数据表

表结构如下：

-- ====================================================================================
-- 四、销售信息表
-- 包含 3 张表：
-- （1）非套装商品销售数据表（tb_goods_sales_info）
-- （2）套装商品对应的单品销售数据表（tb_packaged_product_sales_info）
-- （3）产品套装销售数据表（tb_packaged_sales_info）
-- ====================================================================================


====================================================================================
-- 1、非套装商品销售数据表
-- 表名：tb_goods_sales_info
-- 列名：gs_id（销售数据id）,gs_date（销售日期），goods_no（商品编号），
--      product_no（单品编号），store_no（店铺编号）,team_no（小组编号），
--      visitors（访客），buyers（买家），pay（支付），refund（退款），brush_order（刷单），
--      brush_amount（刷金额），commission（佣金），goods_sales_remark(销售备注)
-- 外键：goods_no，与商品表（tb_goods）的主键（goods_no）对应。
-- 外键：product_no，与产品表（tb_product）的主键（product_no）对应。
-- 外键：store_no，与店铺表（tb_store）的主键（store_no）对应。
-- 外键：team_no，与小组表（tb_team）的主键（team_no）对应。
-- 说明：如果商品不属于任何套装，则一种商品每天只生成一条记录。
-- ====================================================================================

DROP TABLE IF EXISTS  `tb_goods_sales_info`;

CREATE TABLE `tb_goods_sales_info` (
  `gs_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '销售数据id',
  `gs_date` datetime DEFAULT NULL COMMENT '销售日期',
  `goods_no` char(20) NOT NULL DEFAULT '' COMMENT '商品编号',
  `product_no` char(20) NOT NULL DEFAULT '' COMMENT '单品编号：此列为冗余列，需要从【商品链接tb_goods】表查询得到，自动填入！！',
  `team_no` char(20) NOT NULL DEFAULT '' COMMENT '小组编号：此列为冗余列，需要从【单品tb_product】表查询得到，自动填入！！',
  `store_no` char(20) NOT NULL DEFAULT '' COMMENT '店铺编号：此列为冗余列，需要从【商品链接tb_goods】表查询得到，自动填入！！',
  `visitors` int(11) NOT NULL DEFAULT '0' COMMENT '访客',
  `buyers` int(11) NOT NULL DEFAULT '0' COMMENT '买家',
  `pay` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '支付',
  `refund` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '退款',
  `brush_order` int(11) NOT NULL DEFAULT '0' COMMENT '刷单',
  `brush_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '刷金额',
  `commission` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '佣金',
  `user_create_by` int comment '插入记录的用户id',
  `created_at`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP comment '插入时间',
  `user_update_by` int comment '更新记录的用户id',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '最后更新时间',
  `deleted_at` timestamp NULL comment '记录删除时间',
  `sales_goods_remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '销售数据备注',
  PRIMARY KEY (`gs_id`),
  KEY `gs_goods_no` (`goods_no`),
  KEY `gs_store_no` (`store_no`),
  KEY `gs_team_no` (`team_no`),
  KEY `gs_product_no` (`product_no`),
  UNIQUE KEY `ppr_gs_date_goods_no` (`gs_date`,`goods_no`),
  CONSTRAINT `fk_gs_product` FOREIGN KEY (`product_no`) REFERENCES `tb_product` (`product_no`),
  CONSTRAINT `fk_gs_goods` FOREIGN KEY (`goods_no`) REFERENCES `tb_goods` (`goods_no`),
  CONSTRAINT `fk_gs_team` FOREIGN KEY (`team_no`) REFERENCES `tb_team` (`team_no`),
  CONSTRAINT `fk_gs_store` FOREIGN KEY (`store_no`) REFERENCES `tb_store` (`store_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT '非套装商品销售数据表。外键1：goods_no，与商品表（tb_goods）的主键（goods_no）对应。外键2：store_no，与店铺表（tb_store）的主键（store_no）对应。外键3：team_no，与小组表（tb_team）的主键（team_no）对应。外键4：product_no，与产品表（tb_product）的主键（product_no）对应。';
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56

表中的模拟数据如下：

insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071245001','FZ-NS-01','DZ01-XZ01','FZDN-TM001',300,139,8273.37,2746.48,66,1234.81,407.8);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071245002','FZ-NS-01','DZ01-XZ01','FZDN-TM001',287,71,6437.43,3299.16,75,1021.05,203.51);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071245003','FZ-NS-02','DZ01-XZ01','FZDN-TM001',258,64,8095.83,2565.73,78,1231.27,364.72);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245723001','FZ-NS-01','DZ01-XZ01','FZDN-JD001',279,42,13761.65,1904.13,61,313.57,432.91);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245723002','FZ-NS-01','DZ01-XZ01','FZDN-JD001',225,96,4475.7,1588.75,87,1018.12,382.58);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245723003','FZ-NS-02','DZ01-XZ01','FZDN-JD001',257,65,8580.66,1785.1,110,412.52,76.35);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071302001','SZ_HF-01','DZ01-XZ01','SZDN-TM001',251,117,8467.85,2983.38,100,373.93,403.48);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071302002','SZ_HF-02','DZ01-XZ01','SZDN-TM001',257,47,13397.06,1051.69,70,995.23,96.06);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071302003','SZ_HF-02','DZ01-XZ01','SZDN-TM001',303,46,11195.32,2525.83,110,625.24,220.34);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245487001','SZ_HF-01','DZ01-XZ01','SZDN-JD001',155,67,5345.17,2166.55,69,970.33,182.28);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245487002','SZ_HF-02','DZ01-XZ01','SZDN-JD001',265,121,4721.41,1284.26,73,1140.01,305.85);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245487003','SZ_HF-02','DZ01-XZ01','SZDN-JD001',261,136,11393.86,1955.55,96,791.48,186.37);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071307001','DER-NS-01','DZ01-XZ02','DERDN-TM001',190,64,10749.21,2312.61,62,1164.58,257.59);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071307002','DER-NS-01','DZ01-XZ02','DERDN-TM001',208,70,6050.49,1207.79,89,336.67,192.66);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071307003','DER-NS-02','DZ01-XZ02','DERDN-TM001',173,46,13282.7,2337.02,62,325.33,260.46);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245206001','DER-NS-01','DZ01-XZ02','DERDN-JD001',262,70,5216.39,2530.22,66,681.48,93.56);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245206002','DER-NS-01','DZ01-XZ02','DERDN-JD001',248,89,13110.96,1704.36,91,673.9,418.88);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245206003','DER-NS-02','DZ01-XZ02','DERDN-JD001',187,54,9192.21,2453.46,75,1249.44,135.01);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071482001','HP-NS-04','DZ01-XZ02','HPDN-TM001',151,54,4495.2,2445.35,103,854.12,90.52);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071482002','HP-NS-05','DZ01-XZ02','HPDN-TM001',224,61,12770.82,1618.08,92,1049.45,454.89);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071482003','HP-NS-05','DZ01-XZ02','HPDN-TM001',259,137,8489.51,2672.39,78,1066.27,436.24);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245377001','HP-NS-04','DZ01-XZ02','HPDN-JD001',348,123,6654.78,2601.57,84,731.63,333.82);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245377002','HP-NS-05','DZ01-XZ02','HPDN-JD001',248,88,8292.29,1023.08,67,571.89,372.86);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245377003','HP-NS-05','DZ01-XZ02','HPDN-JD001',315,40,11773.61,2024.83,105,523.85,99.97);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071333001','LX-HF-01','DZ02-XZ03','LX-TM001',235,41,8222.48,1392.13,82,1002.09,289.74);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071333002','LX-HF-01','DZ02-XZ03','LX-TM001',276,45,7446.66,2807.84,77,858.17,540.86);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071333003','LX-HF-02','DZ02-XZ03','LX-TM001',248,55,11483.68,2196.3,101,328.47,459.48);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245444001','LX-HF-01','DZ02-XZ03','LX-JD001',271,121,8762.03,3478.64,68,554.56,534);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245444002','LX-HF-01','DZ02-XZ03','LX-JD001',196,107,9635.91,1676.39,88,633.15,366.16);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245444003','LX-HF-02','DZ02-XZ03','LX-JD001',197,122,4728.38,3189.92,105,370.79,205.16);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071566001','XD-HF-01','DZ02-XZ03','XD-TM001',281,47,9166.25,2695.08,74,714.8,393.43);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071566002','XD-HF-01','DZ02-XZ03','XD-TM001',244,139,5956.31,2972.13,84,943.31,87.66);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071566003','XD-HF-02','DZ02-XZ03','XD-TM001',272,60,12265.85,1240.51,82,1272.33,295.4);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245777001','XD-HF-01','DZ02-XZ03','XD-JD001',212,64,4883.09,1547.85,77,995.45,282.17);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245777002','XD-HF-01','DZ02-XZ03','XD-JD001',308,53,7883.11,1681.04,76,806.36,90.88);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245777003','XD-HF-02','DZ02-XZ03','XD-JD001',168,63,8780.37,2487.84,69,804.12,338.86);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071128001','JC-SF-01','DZ02-XZ04','JC-TM001',157,67,5387.61,2140.07,90,883.99,368.64);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071128002','JC-SF-01','DZ02-XZ04','JC-TM001',335,76,9162.28,3034.25,60,701.52,139.33);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071128003','JC-SF-02','DZ02-XZ04','JC-TM001',296,129,11767.42,2910.27,85,894.49,120.54);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245625001','JC-SF-01','DZ02-XZ04','JC-JD001',302,84,6177.74,1130.03,71,922.44,83.68);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245625002','JC-SF-01','DZ02-XZ04','JC-JD001',188,41,8753.99,1122.51,74,1254.19,436.34);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245625003','JC-SF-02','DZ02-XZ04','JC-JD001',317,61,6770.97,2330.7,94,543.21,64.37);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071317001','XP-SR-01','DZ02-XZ04','XP-TM001',289,96,7502,3407.29,101,316.69,224.19);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071317002','XP-SR-01','DZ02-XZ04','XP-TM001',316,71,4818.66,1016.14,91,984.61,321.27);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071317003','XP-SR-02','DZ02-XZ04','XP-TM001',208,51,10805.35,3264.46,101,1017.08,232.83);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245338001','XP-SR-01','DZ02-XZ04','XP-JD001',170,112,12771.72,2473.29,96,770.44,99.15);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245338002','XP-SR-01','DZ02-XZ04','XP-JD001',221,91,8693.37,2928.38,88,1189.05,536.05);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245338003','XP-SR-02','DZ02-XZ04','XP-JD001',276,119,5463.47,3113.18,77,1299.71,294.87);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071245001','FZ-NS-01','DZ01-XZ01','FZDN-TM001',347,103,13093.37,2034.51,83,335.44,406.03);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071245002','FZ-NS-01','DZ01-XZ01','FZDN-TM001',291,108,8073.36,2545.36,70,1291.57,154.71);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071245003','FZ-NS-02','DZ01-XZ01','FZDN-TM001',258,46,5776.03,2363.92,92,1161.61,320.42);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245723001','FZ-NS-01','DZ01-XZ01','FZDN-JD001',177,59,4408.88,2291.37,98,1048.98,160.43);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245723002','FZ-NS-01','DZ01-XZ01','FZDN-JD001',206,60,4494.72,1109.03,107,461.17,336.18);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245723003','FZ-NS-02','DZ01-XZ01','FZDN-JD001',333,105,8948.34,2376.13,99,884,452.97);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071302001','SZ_HF-01','DZ01-XZ01','SZDN-TM001',166,90,4283.84,3276.32,66,579.69,402.81);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071302002','SZ_HF-02','DZ01-XZ01','SZDN-TM001',288,90,5071.38,1622.11,108,1131.42,466.34);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071302003','SZ_HF-02','DZ01-XZ01','SZDN-TM001',163,103,9339.19,1743.46,68,828.36,314.75);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245487001','SZ_HF-01','DZ01-XZ01','SZDN-JD001',318,52,11918.52,2830.6,60,1152.42,171.7);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245487002','SZ_HF-02','DZ01-XZ01','SZDN-JD001',162,65,7410.32,3143.98,70,603.49,500.6);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245487003','SZ_HF-02','DZ01-XZ01','SZDN-JD001',164,95,5395.4,1662.45,80,1294.45,457.19);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071307001','DER-NS-01','DZ01-XZ02','DERDN-TM001',339,111,6957.44,2512.14,87,348.37,147.06);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071307002','DER-NS-01','DZ01-XZ02','DERDN-TM001',165,133,13139.4,2361.26,88,346.8,233.82);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071307003','DER-NS-02','DZ01-XZ02','DERDN-TM001',320,63,13997.06,2689.67,90,643.23,58.39);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245206001','DER-NS-01','DZ01-XZ02','DERDN-JD001',337,82,5015.92,1360.31,89,1027.3,247.21);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245206002','DER-NS-01','DZ01-XZ02','DERDN-JD001',286,125,8669.98,3268.81,90,587.53,455.49);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245206003','DER-NS-02','DZ01-XZ02','DERDN-JD001',251,56,7430.97,2386.83,96,990.17,200.07);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071482001','HP-NS-04','DZ01-XZ02','HPDN-TM001',155,114,7551.11,1493.61,83,986.94,247.75);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071482002','HP-NS-05','DZ01-XZ02','HPDN-TM001',175,58,9431.23,1179.6,77,413.65,328.29);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071482003','HP-NS-05','DZ01-XZ02','HPDN-TM001',245,97,7333.32,1250.22,75,527.77,264.77);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245377001','HP-NS-04','DZ01-XZ02','HPDN-JD001',206,137,8523.53,1416.17,99,897.97,304.41);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245377002','HP-NS-05','DZ01-XZ02','HPDN-JD001',310,97,10882.55,2052.07,65,564.39,364.68);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245377003','HP-NS-05','DZ01-XZ02','HPDN-JD001',254,46,5876.26,3102.15,77,1122.48,52.63);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071333001','LX-HF-01','DZ02-XZ03','LX-TM001',171,98,11730.03,1095.35,110,557.21,539.69);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071333002','LX-HF-01','DZ02-XZ03','LX-TM001',285,78,13120.04,3299.24,110,1281.13,293.41);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071333003','LX-HF-02','DZ02-XZ03','LX-TM001',256,107,12823.27,2358.85,90,1171.98,200.4);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245444001','LX-HF-01','DZ02-XZ03','LX-JD001',343,140,9342.01,1626.09,80,981.71,469.9);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245444002','LX-HF-01','DZ02-XZ03','LX-JD001',251,138,10444.43,2675.59,84,699.73,153.74);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245444003','LX-HF-02','DZ02-XZ03','LX-JD001',257,53,8775.54,2326.89,103,380.76,55.35);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071566001','XD-HF-01','DZ02-XZ03','XD-TM001',343,89,7366.54,3281.67,65,424.51,194.9);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071566002','XD-HF-01','DZ02-XZ03','XD-TM001',193,123,13403.4,1510.91,76,1144.9,201.87);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071566003','XD-HF-02','DZ02-XZ03','XD-TM001',155,108,6033.77,2009.61,72,307.56,153.86);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245777001','XD-HF-01','DZ02-XZ03','XD-JD001',308,129,6664.42,2198.09,94,554.49,342.54);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245777002','XD-HF-01','DZ02-XZ03','XD-JD001',218,101,10751.84,1869.92,82,786.61,350.6);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245777003','XD-HF-02','DZ02-XZ03','XD-JD001',326,63,9174.02,3430.27,60,1196.59,149.57);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071128001','JC-SF-01','DZ02-XZ04','JC-TM001',274,51,9979.34,2323.73,83,1047.63,150.74);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071128002','JC-SF-01','DZ02-XZ04','JC-TM001',183,138,10499.99,2102.9,101,335.14,473.09);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071128003','JC-SF-02','DZ02-XZ04','JC-TM001',220,128,13648.71,1896.11,72,1265.8,268.96);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245625001','JC-SF-01','DZ02-XZ04','JC-JD001',277,118,6112.59,1134.14,84,1010.17,249.16);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245625002','JC-SF-01','DZ02-XZ04','JC-JD001',341,129,13846.34,1236.41,65,793.04,399.22);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245625003','JC-SF-02','DZ02-XZ04','JC-JD001',214,79,11285.18,2254.71,84,921.56,179.13);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071317001','XP-SR-01','DZ02-XZ04','XP-TM001',343,121,10049.61,1861.64,71,1107.18,425.38);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071317002','XP-SR-01','DZ02-XZ04','XP-TM001',274,114,4692.25,1132.49,88,694.41,468.3);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071317003','XP-SR-02','DZ02-XZ04','XP-TM001',327,81,5331.38,2489.77,97,1284.58,72.04);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245338001','XP-SR-01','DZ02-XZ04','XP-JD001',247,78,13396.46,1369.23,76,445.08,507.88);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245338002','XP-SR-01','DZ02-XZ04','XP-JD001',198,98,5713.74,2770.64,81,674.87,499.06);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245338003','XP-SR-02','DZ02-XZ04','XP-JD001',219,63,10174.92,2568.17,70,447.12,384.57);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071245001','FZ-NS-01','DZ01-XZ01','FZDN-TM001',264,83,11532.19,1929.5,67,691.56,513.88);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071245002','FZ-NS-01','DZ01-XZ01','FZDN-TM001',242,71,5894.47,1368.13,65,1137.06,132.94);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071245003','FZ-NS-02','DZ01-XZ01','FZDN-TM001',309,96,7011.65,2101.62,72,665.42,363.71);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245723001','FZ-NS-01','DZ01-XZ01','FZDN-JD001',236,73,13611.07,2789.86,97,715.98,162.27);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245723002','FZ-NS-01','DZ01-XZ01','FZDN-JD001',327,85,7174.75,3445.81,60,519.12,124.07);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245723003','FZ-NS-02','DZ01-XZ01','FZDN-JD001',346,123,7099.52,1023.03,75,868.13,518.19);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071302001','SZ_HF-01','DZ01-XZ01','SZDN-TM001',302,83,4262.75,2959.7,104,942.78,57.96);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071302002','SZ_HF-02','DZ01-XZ01','SZDN-TM001',220,60,5024.13,3372.55,86,342.64,319.88);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071302003','SZ_HF-02','DZ01-XZ01','SZDN-TM001',166,51,4155.63,3038.48,90,558.66,144.47);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245487001','SZ_HF-01','DZ01-XZ01','SZDN-JD001',283,66,8732.1,2983.02,75,375.95,70.97);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245487002','SZ_HF-02','DZ01-XZ01','SZDN-JD001',267,132,9005.08,2004.55,97,1036.95,306.72);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245487003','SZ_HF-02','DZ01-XZ01','SZDN-JD001',163,111,6805.14,2096.73,70,724.4,148.2);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071307001','DER-NS-01','DZ01-XZ02','DERDN-TM001',191,120,6683.29,2259.57,77,1149.01,316.58);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071307002','DER-NS-01','DZ01-XZ02','DERDN-TM001',293,113,11646.55,2071.73,76,1042.63,524.43);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071307003','DER-NS-02','DZ01-XZ02','DERDN-TM001',331,48,7933.24,2791.56,77,887.07,123.28);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245206001','DER-NS-01','DZ01-XZ02','DERDN-JD001',302,68,6046.59,1247.92,95,885.9,259.23);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245206002','DER-NS-01','DZ01-XZ02','DERDN-JD001',258,98,4408.73,3301.34,90,844.46,149.91);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245206003','DER-NS-02','DZ01-XZ02','DERDN-JD001',192,121,8147.86,2543.43,77,942.3,451.66);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071482001','HP-NS-04','DZ01-XZ02','HPDN-TM001',150,98,5871.83,1884.1,97,1240.99,250.02);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071482002','HP-NS-05','DZ01-XZ02','HPDN-TM001',176,45,4050.38,1970.5,89,398.77,535.22);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071482003','HP-NS-05','DZ01-XZ02','HPDN-TM001',187,85,4201.97,1438.74,81,488.73,541.1);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245377001','HP-NS-04','DZ01-XZ02','HPDN-JD001',324,85,13515.6,2762.6,106,1286.29,361.12);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245377002','HP-NS-05','DZ01-XZ02','HPDN-JD001',212,50,7516.43,1971.37,94,844.43,163.49);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245377003','HP-NS-05','DZ01-XZ02','HPDN-JD001',205,49,7867.6,2441.14,68,577.01,87.51);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071333001','LX-HF-01','DZ02-XZ03','LX-TM001',223,88,5078.87,2090.44,104,764.86,280.89);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071333002','LX-HF-01','DZ02-XZ03','LX-TM001',293,77,11040.49,1847.56,63,1135.42,452.38);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071333003','LX-HF-02','DZ02-XZ03','LX-TM001',345,128,4113.21,3029.05,69,1113.51,104.86);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245444001','LX-HF-01','DZ02-XZ03','LX-JD001',163,118,4447.36,3124.29,67,941.96,157.58);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245444002','LX-HF-01','DZ02-XZ03','LX-JD001',299,131,8447.74,1263.27,98,427.61,158.37);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245444003','LX-HF-02','DZ02-XZ03','LX-JD001',197,105,11990.76,1071.19,95,352.23,392.5);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071566001','XD-HF-01','DZ02-XZ03','XD-TM001',282,75,12315,2234.73,76,1251.38,221.47);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071566002','XD-HF-01','DZ02-XZ03','XD-TM001',341,68,11654.83,2149.59,71,733.29,453.38);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071566003','XD-HF-02','DZ02-XZ03','XD-TM001',277,92,9410.52,1514.75,73,568.9,324.04);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245777001','XD-HF-01','DZ02-XZ03','XD-JD001',198,129,13780.08,1887.62,98,442.75,497.09);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245777002','XD-HF-01','DZ02-XZ03','XD-JD001',203,113,8826.97,3279.62,109,318.45,82.73);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245777003','XD-HF-02','DZ02-XZ03','XD-JD001',166,113,9064.76,2501.3,105,455.88,495.82);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071128001','JC-SF-01','DZ02-XZ04','JC-TM001',184,56,10178.46,1022.89,61,644.94,422.25);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071128002','JC-SF-01','DZ02-XZ04','JC-TM001',298,55,4629.58,1113.29,92,1292.41,186.03);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071128003','JC-SF-02','DZ02-XZ04','JC-TM001',339,98,13732.89,2774.22,81,1242.94,358.53);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245625001','JC-SF-01','DZ02-XZ04','JC-JD001',285,85,10114.64,1496.04,75,874.11,277.87);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245625002','JC-SF-01','DZ02-XZ04','JC-JD001',173,73,12133.2,2618.57,107,480.79,346.88);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245625003','JC-SF-02','DZ02-XZ04','JC-JD001',255,47,9280.08,1088.88,63,577.27,209.11);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071317001','XP-SR-01','DZ02-XZ04','XP-TM001',240,129,12448.04,1227.63,67,1121.24,132.29);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071317002','XP-SR-01','DZ02-XZ04','XP-TM001',270,127,9232.74,2108.08,97,710.74,118.61);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071317003','XP-SR-02','DZ02-XZ04','XP-TM001',208,53,7459.73,2122.19,61,1227.46,75.9);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245338001','XP-SR-01','DZ02-XZ04','XP-JD001',192,53,8839.59,2786.01,82,1049.65,400.99);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245338002','XP-SR-01','DZ02-XZ04','XP-JD001',231,67,6655.23,3418.94,78,992.69,548.74);
insert into tb_goods_sales_info(gs_date,goods_no,product_no,team_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245338003','XP-SR-02','DZ02-XZ04','XP-JD001',161,103,13833.57,1025.45,82,486.8,487.78);


/*
select gs_date,goods_no,product_no,team_no,store_no,
visitors,buyers,pay,refund,brush_order,brush_amount,commission
from tb_goods_sales_info;
*/
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151

查询结果如下：

mysql> select gs_date,goods_no,product_no,team_no,store_no,
    -> visitors,buyers,pay,refund,brush_order,brush_amount,commission
    -> from tb_goods_sales_info;
+---------------------+-------------+------------+-----------+-------------+----------+--------+----------+---------+-------------+--------------+------------+
| gs_date             | goods_no    | product_no | team_no   | store_no    | visitors | buyers | pay      | refund  | brush_order | brush_amount | commission |
+---------------------+-------------+------------+-----------+-------------+----------+--------+----------+---------+-------------+--------------+------------+
| 2022-01-01 00:00:00 | 62071245001 | FZ-NS-01   | DZ01-XZ01 | FZDN-TM001  |      300 |    139 |  8273.37 | 2746.48 |          66 |      1234.81 |     407.80 |
| 2022-01-01 00:00:00 | 62071245002 | FZ-NS-01   | DZ01-XZ01 | FZDN-TM001  |      287 |     71 |  6437.43 | 3299.16 |          75 |      1021.05 |     203.51 |
| 2022-01-01 00:00:00 | 62071245003 | FZ-NS-02   | DZ01-XZ01 | FZDN-TM001  |      258 |     64 |  8095.83 | 2565.73 |          78 |      1231.27 |     364.72 |
| 2022-01-01 00:00:00 | 73245723001 | FZ-NS-01   | DZ01-XZ01 | FZDN-JD001  |      279 |     42 | 13761.65 | 1904.13 |          61 |       313.57 |     432.91 |
| 2022-01-01 00:00:00 | 73245723002 | FZ-NS-01   | DZ01-XZ01 | FZDN-JD001  |      225 |     96 |  4475.70 | 1588.75 |          87 |      1018.12 |     382.58 |
| 2022-01-01 00:00:00 | 73245723003 | FZ-NS-02   | DZ01-XZ01 | FZDN-JD001  |      257 |     65 |  8580.66 | 1785.10 |         110 |       412.52 |      76.35 |
| 2022-01-01 00:00:00 | 62071302001 | SZ_HF-01   | DZ01-XZ01 | SZDN-TM001  |      251 |    117 |  8467.85 | 2983.38 |         100 |       373.93 |     403.48 |
| 2022-01-01 00:00:00 | 62071302002 | SZ_HF-02   | DZ01-XZ01 | SZDN-TM001  |      257 |     47 | 13397.06 | 1051.69 |          70 |       995.23 |      96.06 |
| 2022-01-01 00:00:00 | 62071302003 | SZ_HF-02   | DZ01-XZ01 | SZDN-TM001  |      303 |     46 | 11195.32 | 2525.83 |         110 |       625.24 |     220.34 |
| 2022-01-01 00:00:00 | 73245487001 | SZ_HF-01   | DZ01-XZ01 | SZDN-JD001  |      155 |     67 |  5345.17 | 2166.55 |          69 |       970.33 |     182.28 |
| 2022-01-01 00:00:00 | 73245487002 | SZ_HF-02   | DZ01-XZ01 | SZDN-JD001  |      265 |    121 |  4721.41 | 1284.26 |          73 |      1140.01 |     305.85 |
| 2022-01-01 00:00:00 | 73245487003 | SZ_HF-02   | DZ01-XZ01 | SZDN-JD001  |      261 |    136 | 11393.86 | 1955.55 |          96 |       791.48 |     186.37 |
| 2022-01-01 00:00:00 | 62071307001 | DER-NS-01  | DZ01-XZ02 | DERDN-TM001 |      190 |     64 | 10749.21 | 2312.61 |          62 |      1164.58 |     257.59 |
| 2022-01-01 00:00:00 | 62071307002 | DER-NS-01  | DZ01-XZ02 | DERDN-TM001 |      208 |     70 |  6050.49 | 1207.79 |          89 |       336.67 |     192.66 |
| 2022-01-01 00:00:00 | 62071307003 | DER-NS-02  | DZ01-XZ02 | DERDN-TM001 |      173 |     46 | 13282.70 | 2337.02 |          62 |       325.33 |     260.46 |
| 2022-01-01 00:00:00 | 73245206001 | DER-NS-01  | DZ01-XZ02 | DERDN-JD001 |      262 |     70 |  5216.39 | 2530.22 |          66 |       681.48 |      93.56 |
| 2022-01-01 00:00:00 | 73245206002 | DER-NS-01  | DZ01-XZ02 | DERDN-JD001 |      248 |     89 | 13110.96 | 1704.36 |          91 |       673.90 |     418.88 |
| 2022-01-01 00:00:00 | 73245206003 | DER-NS-02  | DZ01-XZ02 | DERDN-JD001 |      187 |     54 |  9192.21 | 2453.46 |          75 |      1249.44 |     135.01 |
| 2022-01-01 00:00:00 | 62071482001 | HP-NS-04   | DZ01-XZ02 | HPDN-TM001  |      151 |     54 |  4495.20 | 2445.35 |         103 |       854.12 |      90.52 |
| 2022-01-01 00:00:00 | 62071482002 | HP-NS-05   | DZ01-XZ02 | HPDN-TM001  |      224 |     61 | 12770.82 | 1618.08 |          92 |      1049.45 |     454.89 |
| 2022-01-01 00:00:00 | 62071482003 | HP-NS-05   | DZ01-XZ02 | HPDN-TM001  |      259 |    137 |  8489.51 | 2672.39 |          78 |      1066.27 |     436.24 |
| 2022-01-01 00:00:00 | 73245377001 | HP-NS-04   | DZ01-XZ02 | HPDN-JD001  |      348 |    123 |  6654.78 | 2601.57 |          84 |       731.63 |     333.82 |
| 2022-01-01 00:00:00 | 73245377002 | HP-NS-05   | DZ01-XZ02 | HPDN-JD001  |      248 |     88 |  8292.29 | 1023.08 |          67 |       571.89 |     372.86 |
| 2022-01-01 00:00:00 | 73245377003 | HP-NS-05   | DZ01-XZ02 | HPDN-JD001  |      315 |     40 | 11773.61 | 2024.83 |         105 |       523.85 |      99.97 |
| 2022-01-01 00:00:00 | 62071333001 | LX-HF-01   | DZ02-XZ03 | LX-TM001    |      235 |     41 |  8222.48 | 1392.13 |          82 |      1002.09 |     289.74 |
| 2022-01-01 00:00:00 | 62071333002 | LX-HF-01   | DZ02-XZ03 | LX-TM001    |      276 |     45 |  7446.66 | 2807.84 |          77 |       858.17 |     540.86 |
| 2022-01-01 00:00:00 | 62071333003 | LX-HF-02   | DZ02-XZ03 | LX-TM001    |      248 |     55 | 11483.68 | 2196.30 |         101 |       328.47 |     459.48 |
| 2022-01-01 00:00:00 | 73245444001 | LX-HF-01   | DZ02-XZ03 | LX-JD001    |      271 |    121 |  8762.03 | 3478.64 |          68 |       554.56 |     534.00 |
| 2022-01-01 00:00:00 | 73245444002 | LX-HF-01   | DZ02-XZ03 | LX-JD001    |      196 |    107 |  9635.91 | 1676.39 |          88 |       633.15 |     366.16 |
| 2022-01-01 00:00:00 | 73245444003 | LX-HF-02   | DZ02-XZ03 | LX-JD001    |      197 |    122 |  4728.38 | 3189.92 |         105 |       370.79 |     205.16 |
| 2022-01-01 00:00:00 | 62071566001 | XD-HF-01   | DZ02-XZ03 | XD-TM001    |      281 |     47 |  9166.25 | 2695.08 |          74 |       714.80 |     393.43 |
| 2022-01-01 00:00:00 | 62071566002 | XD-HF-01   | DZ02-XZ03 | XD-TM001    |      244 |    139 |  5956.31 | 2972.13 |          84 |       943.31 |      87.66 |
| 2022-01-01 00:00:00 | 62071566003 | XD-HF-02   | DZ02-XZ03 | XD-TM001    |      272 |     60 | 12265.85 | 1240.51 |          82 |      1272.33 |     295.40 |
| 2022-01-01 00:00:00 | 73245777001 | XD-HF-01   | DZ02-XZ03 | XD-JD001    |      212 |     64 |  4883.09 | 1547.85 |          77 |       995.45 |     282.17 |
| 2022-01-01 00:00:00 | 73245777002 | XD-HF-01   | DZ02-XZ03 | XD-JD001    |      308 |     53 |  7883.11 | 1681.04 |          76 |       806.36 |      90.88 |
| 2022-01-01 00:00:00 | 73245777003 | XD-HF-02   | DZ02-XZ03 | XD-JD001    |      168 |     63 |  8780.37 | 2487.84 |          69 |       804.12 |     338.86 |
| 2022-01-01 00:00:00 | 62071128001 | JC-SF-01   | DZ02-XZ04 | JC-TM001    |      157 |     67 |  5387.61 | 2140.07 |          90 |       883.99 |     368.64 |
| 2022-01-01 00:00:00 | 62071128002 | JC-SF-01   | DZ02-XZ04 | JC-TM001    |      335 |     76 |  9162.28 | 3034.25 |          60 |       701.52 |     139.33 |
| 2022-01-01 00:00:00 | 62071128003 | JC-SF-02   | DZ02-XZ04 | JC-TM001    |      296 |    129 | 11767.42 | 2910.27 |          85 |       894.49 |     120.54 |
| 2022-01-01 00:00:00 | 73245625001 | JC-SF-01   | DZ02-XZ04 | JC-JD001    |      302 |     84 |  6177.74 | 1130.03 |          71 |       922.44 |      83.68 |
| 2022-01-01 00:00:00 | 73245625002 | JC-SF-01   | DZ02-XZ04 | JC-JD001    |      188 |     41 |  8753.99 | 1122.51 |          74 |      1254.19 |     436.34 |
| 2022-01-01 00:00:00 | 73245625003 | JC-SF-02   | DZ02-XZ04 | JC-JD001    |      317 |     61 |  6770.97 | 2330.70 |          94 |       543.21 |      64.37 |
| 2022-01-01 00:00:00 | 62071317001 | XP-SR-01   | DZ02-XZ04 | XP-TM001    |      289 |     96 |  7502.00 | 3407.29 |         101 |       316.69 |     224.19 |
| 2022-01-01 00:00:00 | 62071317002 | XP-SR-01   | DZ02-XZ04 | XP-TM001    |      316 |     71 |  4818.66 | 1016.14 |          91 |       984.61 |     321.27 |
| 2022-01-01 00:00:00 | 62071317003 | XP-SR-02   | DZ02-XZ04 | XP-TM001    |      208 |     51 | 10805.35 | 3264.46 |         101 |      1017.08 |     232.83 |
| 2022-01-01 00:00:00 | 73245338001 | XP-SR-01   | DZ02-XZ04 | XP-JD001    |      170 |    112 | 12771.72 | 2473.29 |          96 |       770.44 |      99.15 |
| 2022-01-01 00:00:00 | 73245338002 | XP-SR-01   | DZ02-XZ04 | XP-JD001    |      221 |     91 |  8693.37 | 2928.38 |          88 |      1189.05 |     536.05 |
| 2022-01-01 00:00:00 | 73245338003 | XP-SR-02   | DZ02-XZ04 | XP-JD001    |      276 |    119 |  5463.47 | 3113.18 |          77 |      1299.71 |     294.87 |
| 2022-01-02 00:00:00 | 62071245001 | FZ-NS-01   | DZ01-XZ01 | FZDN-TM001  |      347 |    103 | 13093.37 | 2034.51 |          83 |       335.44 |     406.03 |
| 2022-01-02 00:00:00 | 62071245002 | FZ-NS-01   | DZ01-XZ01 | FZDN-TM001  |      291 |    108 |  8073.36 | 2545.36 |          70 |      1291.57 |     154.71 |
| 2022-01-02 00:00:00 | 62071245003 | FZ-NS-02   | DZ01-XZ01 | FZDN-TM001  |      258 |     46 |  5776.03 | 2363.92 |          92 |      1161.61 |     320.42 |
| 2022-01-02 00:00:00 | 73245723001 | FZ-NS-01   | DZ01-XZ01 | FZDN-JD001  |      177 |     59 |  4408.88 | 2291.37 |          98 |      1048.98 |     160.43 |
| 2022-01-02 00:00:00 | 73245723002 | FZ-NS-01   | DZ01-XZ01 | FZDN-JD001  |      206 |     60 |  4494.72 | 1109.03 |         107 |       461.17 |     336.18 |
| 2022-01-02 00:00:00 | 73245723003 | FZ-NS-02   | DZ01-XZ01 | FZDN-JD001  |      333 |    105 |  8948.34 | 2376.13 |          99 |       884.00 |     452.97 |
| 2022-01-02 00:00:00 | 62071302001 | SZ_HF-01   | DZ01-XZ01 | SZDN-TM001  |      166 |     90 |  4283.84 | 3276.32 |          66 |       579.69 |     402.81 |
| 2022-01-02 00:00:00 | 62071302002 | SZ_HF-02   | DZ01-XZ01 | SZDN-TM001  |      288 |     90 |  5071.38 | 1622.11 |         108 |      1131.42 |     466.34 |
| 2022-01-02 00:00:00 | 62071302003 | SZ_HF-02   | DZ01-XZ01 | SZDN-TM001  |      163 |    103 |  9339.19 | 1743.46 |          68 |       828.36 |     314.75 |
| 2022-01-02 00:00:00 | 73245487001 | SZ_HF-01   | DZ01-XZ01 | SZDN-JD001  |      318 |     52 | 11918.52 | 2830.60 |          60 |      1152.42 |     171.70 |
| 2022-01-02 00:00:00 | 73245487002 | SZ_HF-02   | DZ01-XZ01 | SZDN-JD001  |      162 |     65 |  7410.32 | 3143.98 |          70 |       603.49 |     500.60 |
| 2022-01-02 00:00:00 | 73245487003 | SZ_HF-02   | DZ01-XZ01 | SZDN-JD001  |      164 |     95 |  5395.40 | 1662.45 |          80 |      1294.45 |     457.19 |
| 2022-01-02 00:00:00 | 62071307001 | DER-NS-01  | DZ01-XZ02 | DERDN-TM001 |      339 |    111 |  6957.44 | 2512.14 |          87 |       348.37 |     147.06 |
| 2022-01-02 00:00:00 | 62071307002 | DER-NS-01  | DZ01-XZ02 | DERDN-TM001 |      165 |    133 | 13139.40 | 2361.26 |          88 |       346.80 |     233.82 |
| 2022-01-02 00:00:00 | 62071307003 | DER-NS-02  | DZ01-XZ02 | DERDN-TM001 |      320 |     63 | 13997.06 | 2689.67 |          90 |       643.23 |      58.39 |
| 2022-01-02 00:00:00 | 73245206001 | DER-NS-01  | DZ01-XZ02 | DERDN-JD001 |      337 |     82 |  5015.92 | 1360.31 |          89 |      1027.30 |     247.21 |
| 2022-01-02 00:00:00 | 73245206002 | DER-NS-01  | DZ01-XZ02 | DERDN-JD001 |      286 |    125 |  8669.98 | 3268.81 |          90 |       587.53 |     455.49 |
| 2022-01-02 00:00:00 | 73245206003 | DER-NS-02  | DZ01-XZ02 | DERDN-JD001 |      251 |     56 |  7430.97 | 2386.83 |          96 |       990.17 |     200.07 |
| 2022-01-02 00:00:00 | 62071482001 | HP-NS-04   | DZ01-XZ02 | HPDN-TM001  |      155 |    114 |  7551.11 | 1493.61 |          83 |       986.94 |     247.75 |
| 2022-01-02 00:00:00 | 62071482002 | HP-NS-05   | DZ01-XZ02 | HPDN-TM001  |      175 |     58 |  9431.23 | 1179.60 |          77 |       413.65 |     328.29 |
| 2022-01-02 00:00:00 | 62071482003 | HP-NS-05   | DZ01-XZ02 | HPDN-TM001  |      245 |     97 |  7333.32 | 1250.22 |          75 |       527.77 |     264.77 |
| 2022-01-02 00:00:00 | 73245377001 | HP-NS-04   | DZ01-XZ02 | HPDN-JD001  |      206 |    137 |  8523.53 | 1416.17 |          99 |       897.97 |     304.41 |
| 2022-01-02 00:00:00 | 73245377002 | HP-NS-05   | DZ01-XZ02 | HPDN-JD001  |      310 |     97 | 10882.55 | 2052.07 |          65 |       564.39 |     364.68 |
| 2022-01-02 00:00:00 | 73245377003 | HP-NS-05   | DZ01-XZ02 | HPDN-JD001  |      254 |     46 |  5876.26 | 3102.15 |          77 |      1122.48 |      52.63 |
| 2022-01-02 00:00:00 | 62071333001 | LX-HF-01   | DZ02-XZ03 | LX-TM001    |      171 |     98 | 11730.03 | 1095.35 |         110 |       557.21 |     539.69 |
| 2022-01-02 00:00:00 | 62071333002 | LX-HF-01   | DZ02-XZ03 | LX-TM001    |      285 |     78 | 13120.04 | 3299.24 |         110 |      1281.13 |     293.41 |
| 2022-01-02 00:00:00 | 62071333003 | LX-HF-02   | DZ02-XZ03 | LX-TM001    |      256 |    107 | 12823.27 | 2358.85 |          90 |      1171.98 |     200.40 |
| 2022-01-02 00:00:00 | 73245444001 | LX-HF-01   | DZ02-XZ03 | LX-JD001    |      343 |    140 |  9342.01 | 1626.09 |          80 |       981.71 |     469.90 |
| 2022-01-02 00:00:00 | 73245444002 | LX-HF-01   | DZ02-XZ03 | LX-JD001    |      251 |    138 | 10444.43 | 2675.59 |          84 |       699.73 |     153.74 |
| 2022-01-02 00:00:00 | 73245444003 | LX-HF-02   | DZ02-XZ03 | LX-JD001    |      257 |     53 |  8775.54 | 2326.89 |         103 |       380.76 |      55.35 |
| 2022-01-02 00:00:00 | 62071566001 | XD-HF-01   | DZ02-XZ03 | XD-TM001    |      343 |     89 |  7366.54 | 3281.67 |          65 |       424.51 |     194.90 |
| 2022-01-02 00:00:00 | 62071566002 | XD-HF-01   | DZ02-XZ03 | XD-TM001    |      193 |    123 | 13403.40 | 1510.91 |          76 |      1144.90 |     201.87 |
| 2022-01-02 00:00:00 | 62071566003 | XD-HF-02   | DZ02-XZ03 | XD-TM001    |      155 |    108 |  6033.77 | 2009.61 |          72 |       307.56 |     153.86 |
| 2022-01-02 00:00:00 | 73245777001 | XD-HF-01   | DZ02-XZ03 | XD-JD001    |      308 |    129 |  6664.42 | 2198.09 |          94 |       554.49 |     342.54 |
| 2022-01-02 00:00:00 | 73245777002 | XD-HF-01   | DZ02-XZ03 | XD-JD001    |      218 |    101 | 10751.84 | 1869.92 |          82 |       786.61 |     350.60 |
| 2022-01-02 00:00:00 | 73245777003 | XD-HF-02   | DZ02-XZ03 | XD-JD001    |      326 |     63 |  9174.02 | 3430.27 |          60 |      1196.59 |     149.57 |
| 2022-01-02 00:00:00 | 62071128001 | JC-SF-01   | DZ02-XZ04 | JC-TM001    |      274 |     51 |  9979.34 | 2323.73 |          83 |      1047.63 |     150.74 |
| 2022-01-02 00:00:00 | 62071128002 | JC-SF-01   | DZ02-XZ04 | JC-TM001    |      183 |    138 | 10499.99 | 2102.90 |         101 |       335.14 |     473.09 |
| 2022-01-02 00:00:00 | 62071128003 | JC-SF-02   | DZ02-XZ04 | JC-TM001    |      220 |    128 | 13648.71 | 1896.11 |          72 |      1265.80 |     268.96 |
| 2022-01-02 00:00:00 | 73245625001 | JC-SF-01   | DZ02-XZ04 | JC-JD001    |      277 |    118 |  6112.59 | 1134.14 |          84 |      1010.17 |     249.16 |
| 2022-01-02 00:00:00 | 73245625002 | JC-SF-01   | DZ02-XZ04 | JC-JD001    |      341 |    129 | 13846.34 | 1236.41 |          65 |       793.04 |     399.22 |
| 2022-01-02 00:00:00 | 73245625003 | JC-SF-02   | DZ02-XZ04 | JC-JD001    |      214 |     79 | 11285.18 | 2254.71 |          84 |       921.56 |     179.13 |
| 2022-01-02 00:00:00 | 62071317001 | XP-SR-01   | DZ02-XZ04 | XP-TM001    |      343 |    121 | 10049.61 | 1861.64 |          71 |      1107.18 |     425.38 |
| 2022-01-02 00:00:00 | 62071317002 | XP-SR-01   | DZ02-XZ04 | XP-TM001    |      274 |    114 |  4692.25 | 1132.49 |          88 |       694.41 |     468.30 |
| 2022-01-02 00:00:00 | 62071317003 | XP-SR-02   | DZ02-XZ04 | XP-TM001    |      327 |     81 |  5331.38 | 2489.77 |          97 |      1284.58 |      72.04 |
| 2022-01-02 00:00:00 | 73245338001 | XP-SR-01   | DZ02-XZ04 | XP-JD001    |      247 |     78 | 13396.46 | 1369.23 |          76 |       445.08 |     507.88 |
| 2022-01-02 00:00:00 | 73245338002 | XP-SR-01   | DZ02-XZ04 | XP-JD001    |      198 |     98 |  5713.74 | 2770.64 |          81 |       674.87 |     499.06 |
| 2022-01-02 00:00:00 | 73245338003 | XP-SR-02   | DZ02-XZ04 | XP-JD001    |      219 |     63 | 10174.92 | 2568.17 |          70 |       447.12 |     384.57 |
| 2022-01-03 00:00:00 | 62071245001 | FZ-NS-01   | DZ01-XZ01 | FZDN-TM001  |      264 |     83 | 11532.19 | 1929.50 |          67 |       691.56 |     513.88 |
| 2022-01-03 00:00:00 | 62071245002 | FZ-NS-01   | DZ01-XZ01 | FZDN-TM001  |      242 |     71 |  5894.47 | 1368.13 |          65 |      1137.06 |     132.94 |
| 2022-01-03 00:00:00 | 62071245003 | FZ-NS-02   | DZ01-XZ01 | FZDN-TM001  |      309 |     96 |  7011.65 | 2101.62 |          72 |       665.42 |     363.71 |
| 2022-01-03 00:00:00 | 73245723001 | FZ-NS-01   | DZ01-XZ01 | FZDN-JD001  |      236 |     73 | 13611.07 | 2789.86 |          97 |       715.98 |     162.27 |
| 2022-01-03 00:00:00 | 73245723002 | FZ-NS-01   | DZ01-XZ01 | FZDN-JD001  |      327 |     85 |  7174.75 | 3445.81 |          60 |       519.12 |     124.07 |
| 2022-01-03 00:00:00 | 73245723003 | FZ-NS-02   | DZ01-XZ01 | FZDN-JD001  |      346 |    123 |  7099.52 | 1023.03 |          75 |       868.13 |     518.19 |
| 2022-01-03 00:00:00 | 62071302001 | SZ_HF-01   | DZ01-XZ01 | SZDN-TM001  |      302 |     83 |  4262.75 | 2959.70 |         104 |       942.78 |      57.96 |
| 2022-01-03 00:00:00 | 62071302002 | SZ_HF-02   | DZ01-XZ01 | SZDN-TM001  |      220 |     60 |  5024.13 | 3372.55 |          86 |       342.64 |     319.88 |
| 2022-01-03 00:00:00 | 62071302003 | SZ_HF-02   | DZ01-XZ01 | SZDN-TM001  |      166 |     51 |  4155.63 | 3038.48 |          90 |       558.66 |     144.47 |
| 2022-01-03 00:00:00 | 73245487001 | SZ_HF-01   | DZ01-XZ01 | SZDN-JD001  |      283 |     66 |  8732.10 | 2983.02 |          75 |       375.95 |      70.97 |
| 2022-01-03 00:00:00 | 73245487002 | SZ_HF-02   | DZ01-XZ01 | SZDN-JD001  |      267 |    132 |  9005.08 | 2004.55 |          97 |      1036.95 |     306.72 |
| 2022-01-03 00:00:00 | 73245487003 | SZ_HF-02   | DZ01-XZ01 | SZDN-JD001  |      163 |    111 |  6805.14 | 2096.73 |          70 |       724.40 |     148.20 |
| 2022-01-03 00:00:00 | 62071307001 | DER-NS-01  | DZ01-XZ02 | DERDN-TM001 |      191 |    120 |  6683.29 | 2259.57 |          77 |      1149.01 |     316.58 |
| 2022-01-03 00:00:00 | 62071307002 | DER-NS-01  | DZ01-XZ02 | DERDN-TM001 |      293 |    113 | 11646.55 | 2071.73 |          76 |      1042.63 |     524.43 |
| 2022-01-03 00:00:00 | 62071307003 | DER-NS-02  | DZ01-XZ02 | DERDN-TM001 |      331 |     48 |  7933.24 | 2791.56 |          77 |       887.07 |     123.28 |
| 2022-01-03 00:00:00 | 73245206001 | DER-NS-01  | DZ01-XZ02 | DERDN-JD001 |      302 |     68 |  6046.59 | 1247.92 |          95 |       885.90 |     259.23 |
| 2022-01-03 00:00:00 | 73245206002 | DER-NS-01  | DZ01-XZ02 | DERDN-JD001 |      258 |     98 |  4408.73 | 3301.34 |          90 |       844.46 |     149.91 |
| 2022-01-03 00:00:00 | 73245206003 | DER-NS-02  | DZ01-XZ02 | DERDN-JD001 |      192 |    121 |  8147.86 | 2543.43 |          77 |       942.30 |     451.66 |
| 2022-01-03 00:00:00 | 62071482001 | HP-NS-04   | DZ01-XZ02 | HPDN-TM001  |      150 |     98 |  5871.83 | 1884.10 |          97 |      1240.99 |     250.02 |
| 2022-01-03 00:00:00 | 62071482002 | HP-NS-05   | DZ01-XZ02 | HPDN-TM001  |      176 |     45 |  4050.38 | 1970.50 |          89 |       398.77 |     535.22 |
| 2022-01-03 00:00:00 | 62071482003 | HP-NS-05   | DZ01-XZ02 | HPDN-TM001  |      187 |     85 |  4201.97 | 1438.74 |          81 |       488.73 |     541.10 |
| 2022-01-03 00:00:00 | 73245377001 | HP-NS-04   | DZ01-XZ02 | HPDN-JD001  |      324 |     85 | 13515.60 | 2762.60 |         106 |      1286.29 |     361.12 |
| 2022-01-03 00:00:00 | 73245377002 | HP-NS-05   | DZ01-XZ02 | HPDN-JD001  |      212 |     50 |  7516.43 | 1971.37 |          94 |       844.43 |     163.49 |
| 2022-01-03 00:00:00 | 73245377003 | HP-NS-05   | DZ01-XZ02 | HPDN-JD001  |      205 |     49 |  7867.60 | 2441.14 |          68 |       577.01 |      87.51 |
| 2022-01-03 00:00:00 | 62071333001 | LX-HF-01   | DZ02-XZ03 | LX-TM001    |      223 |     88 |  5078.87 | 2090.44 |         104 |       764.86 |     280.89 |
| 2022-01-03 00:00:00 | 62071333002 | LX-HF-01   | DZ02-XZ03 | LX-TM001    |      293 |     77 | 11040.49 | 1847.56 |          63 |      1135.42 |     452.38 |
| 2022-01-03 00:00:00 | 62071333003 | LX-HF-02   | DZ02-XZ03 | LX-TM001    |      345 |    128 |  4113.21 | 3029.05 |          69 |      1113.51 |     104.86 |
| 2022-01-03 00:00:00 | 73245444001 | LX-HF-01   | DZ02-XZ03 | LX-JD001    |      163 |    118 |  4447.36 | 3124.29 |          67 |       941.96 |     157.58 |
| 2022-01-03 00:00:00 | 73245444002 | LX-HF-01   | DZ02-XZ03 | LX-JD001    |      299 |    131 |  8447.74 | 1263.27 |          98 |       427.61 |     158.37 |
| 2022-01-03 00:00:00 | 73245444003 | LX-HF-02   | DZ02-XZ03 | LX-JD001    |      197 |    105 | 11990.76 | 1071.19 |          95 |       352.23 |     392.50 |
| 2022-01-03 00:00:00 | 62071566001 | XD-HF-01   | DZ02-XZ03 | XD-TM001    |      282 |     75 | 12315.00 | 2234.73 |          76 |      1251.38 |     221.47 |
| 2022-01-03 00:00:00 | 62071566002 | XD-HF-01   | DZ02-XZ03 | XD-TM001    |      341 |     68 | 11654.83 | 2149.59 |          71 |       733.29 |     453.38 |
| 2022-01-03 00:00:00 | 62071566003 | XD-HF-02   | DZ02-XZ03 | XD-TM001    |      277 |     92 |  9410.52 | 1514.75 |          73 |       568.90 |     324.04 |
| 2022-01-03 00:00:00 | 73245777001 | XD-HF-01   | DZ02-XZ03 | XD-JD001    |      198 |    129 | 13780.08 | 1887.62 |          98 |       442.75 |     497.09 |
| 2022-01-03 00:00:00 | 73245777002 | XD-HF-01   | DZ02-XZ03 | XD-JD001    |      203 |    113 |  8826.97 | 3279.62 |         109 |       318.45 |      82.73 |
| 2022-01-03 00:00:00 | 73245777003 | XD-HF-02   | DZ02-XZ03 | XD-JD001    |      166 |    113 |  9064.76 | 2501.30 |         105 |       455.88 |     495.82 |
| 2022-01-03 00:00:00 | 62071128001 | JC-SF-01   | DZ02-XZ04 | JC-TM001    |      184 |     56 | 10178.46 | 1022.89 |          61 |       644.94 |     422.25 |
| 2022-01-03 00:00:00 | 62071128002 | JC-SF-01   | DZ02-XZ04 | JC-TM001    |      298 |     55 |  4629.58 | 1113.29 |          92 |      1292.41 |     186.03 |
| 2022-01-03 00:00:00 | 62071128003 | JC-SF-02   | DZ02-XZ04 | JC-TM001    |      339 |     98 | 13732.89 | 2774.22 |          81 |      1242.94 |     358.53 |
| 2022-01-03 00:00:00 | 73245625001 | JC-SF-01   | DZ02-XZ04 | JC-JD001    |      285 |     85 | 10114.64 | 1496.04 |          75 |       874.11 |     277.87 |
| 2022-01-03 00:00:00 | 73245625002 | JC-SF-01   | DZ02-XZ04 | JC-JD001    |      173 |     73 | 12133.20 | 2618.57 |         107 |       480.79 |     346.88 |
| 2022-01-03 00:00:00 | 73245625003 | JC-SF-02   | DZ02-XZ04 | JC-JD001    |      255 |     47 |  9280.08 | 1088.88 |          63 |       577.27 |     209.11 |
| 2022-01-03 00:00:00 | 62071317001 | XP-SR-01   | DZ02-XZ04 | XP-TM001    |      240 |    129 | 12448.04 | 1227.63 |          67 |      1121.24 |     132.29 |
| 2022-01-03 00:00:00 | 62071317002 | XP-SR-01   | DZ02-XZ04 | XP-TM001    |      270 |    127 |  9232.74 | 2108.08 |          97 |       710.74 |     118.61 |
| 2022-01-03 00:00:00 | 62071317003 | XP-SR-02   | DZ02-XZ04 | XP-TM001    |      208 |     53 |  7459.73 | 2122.19 |          61 |      1227.46 |      75.90 |
| 2022-01-03 00:00:00 | 73245338001 | XP-SR-01   | DZ02-XZ04 | XP-JD001    |      192 |     53 |  8839.59 | 2786.01 |          82 |      1049.65 |     400.99 |
| 2022-01-03 00:00:00 | 73245338002 | XP-SR-01   | DZ02-XZ04 | XP-JD001    |      231 |     67 |  6655.23 | 3418.94 |          78 |       992.69 |     548.74 |
| 2022-01-03 00:00:00 | 73245338003 | XP-SR-02   | DZ02-XZ04 | XP-JD001    |      161 |    103 | 13833.57 | 1025.45 |          82 |       486.80 |     487.78 |
+---------------------+-------------+------------+-----------+-------------+----------+--------+----------+---------+-------------+--------------+------------+
144 rows in set (0.00 sec)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152

2、套装商品对应的单品销售数据表

该表不需要用户操作，在对表【套装商品销售数据表（tb_packaged_sales_info）】中的数据进行增、删、改时，由对应的触发器生成相应的数据自动填入该表。

表结构如下：

-- ====================================================================================
-- 2、套装商品对应的单品销售数据表
-- 表名：tb_packaged_product_sales_info
-- 列名：pps_id（销售数据id）,pps_date（销售日期），packaged_no（产品套装编号），
--       store_no（店铺编号），team_no（小组编号），visitors（访客），buyers（买家），pay（支付），
--       refund（退款），brush_order（刷单），brush_amount（刷金额），commission（佣金），

-- 该表不需要用户进行任何操作！！！

-- 表中的数据操作如下：
-- 在“tb_packaged_sales_info”表中添加记录时，使用触发器向该表自动插入数据
-- 在“tb_packaged_sales_info”表中删除记录时，使用触发器自动删除该表中对应的记录
-- 在“tb_packaged_sales_info”表中更新记录时，使用触发器自动更新该表中对应的记录
-- ====================================================================================

DROP TABLE IF EXISTS  `tb_packaged_product_sales_info`;

CREATE TABLE `tb_packaged_product_sales_info` (
  `pps_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '销售数据id',
  `pps_date` datetime DEFAULT NULL COMMENT '销售日期',
  `packaged_no` char(20) NOT NULL DEFAULT '' COMMENT '产品套装编号',
  `product_no` char(20) NOT NULL DEFAULT '' COMMENT '产品编号',
  `sales_proportion` decimal(4,3) NOT NULL DEFAULT '0.000' COMMENT '商品销售所占比例',
  `team_no` char(20) NOT NULL DEFAULT '' COMMENT '小组编号',
  `store_no` char(20) NOT NULL DEFAULT '' COMMENT '店铺编号',
  `visitors` int(11) NOT NULL DEFAULT '0' COMMENT '访客',
  `buyers` int(11) NOT NULL DEFAULT '0' COMMENT '买家',
  `pay` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '支付',
  `refund` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '退款',
  `brush_order` int(11) NOT NULL DEFAULT '0' COMMENT '刷单',
  `brush_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '刷金额',
  `commission` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '佣金',
  `user_create_by` int comment '插入记录的用户id',
  `created_at`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP comment '插入时间',
  `user_update_by` int comment '更新记录的用户id',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '最后更新时间',
  `deleted_at` timestamp NULL comment '记录删除时间',
  PRIMARY KEY (`pps_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT '套装商品对应的单品销售数据表。外键1：product_no，与产品表（tb_product）的主键（product_no）对应。外键2：store_no，与店铺表（tb_store）的主键（store_no）对应。外键3：team_no，与小组表（tb_team）的主键（team_no）对应。外键4：packaged_no，与小组表（tb_packaged）的主键（packaged_no）对应。';
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

3、套装商品销售数据表

表结构如下：

-- ====================================================================================
-- 3、套装商品销售数据表
-- 表名：tb_packaged_sales_info
-- 列名：ps_id（销售数据id）,ps_date（销售日期），packaged_no（产品套装编号），
--       store_no（店铺编号），visitors（访客），buyers（买家），pay（支付），
--       refund（退款），brush_order（刷单），brush_amount（刷金额），commission（佣金），
--       packaged_sales_remark(产品套装销售备注)
-- 外键：packaged_no，与产品套装表（tb_packaged）的主键（packaged_no）对应。
-- 外键：store_no，与店铺表（tb_store）的主键（store_no）对应。
-- #####################################################################################
-- ====================================================================================

DROP TABLE IF EXISTS  `tb_packaged_sales_info`;

CREATE TABLE `tb_packaged_sales_info` (
  `ps_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '产品套装销售数据id',
  `ps_date` datetime DEFAULT NULL COMMENT '产品套装销售日期',
  `packaged_no` char(20) NOT NULL DEFAULT '' COMMENT '产品套装编号',
  `store_no` char(20) NOT NULL DEFAULT '' COMMENT '店铺编号',
  `visitors` int(11) NOT NULL DEFAULT '0' COMMENT '访客',
  `buyers` int(11) NOT NULL DEFAULT '0' COMMENT '买家',
  `pay` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '支付',
  `refund` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '退款',
  `brush_order` int(11) NOT NULL DEFAULT '0' COMMENT '刷单',
  `brush_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '刷金额',
  `commission` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '佣金',
  `user_create_by` int comment '插入记录的用户id',
  `created_at`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP comment '插入时间',
  `user_update_by` int comment '更新记录的用户id',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP comment '最后更新时间',
  `deleted_at` timestamp NULL comment '记录删除时间',
  `packaged_sales_remark` varchar(2000) NOT NULL DEFAULT '' COMMENT '销售数据备注',
  PRIMARY KEY (`ps_id`),
  KEY `ps_packaged_no` (`packaged_no`),
  KEY `ps_store_no` (`store_no`),
  UNIQUE KEY `ppr_ps_date_packaged_no` (`ps_date`,`packaged_no`),
  CONSTRAINT `fk_ps_packaged` FOREIGN KEY (`packaged_no`) REFERENCES `tb_packaged` (`packaged_no`),
  CONSTRAINT `fk_ps_store` FOREIGN KEY (`store_no`) REFERENCES `tb_store` (`store_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT '产品套装销售数据表。外键1：packaged_no，与产品套装表（tb_packaged）的主键（packaged_no）对应。外键2：store_no，与店铺表（tb_store）的主键（store_no）对应。';
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

在该表中对数据进行增、删、改操作时，调用相应的触发器，对套装数据按设定的比例自动拆分后填充到【套装商品对应的单品销售数据表（tb_packaged_product_sales_info）】中。

相应的触发器如下：

-- ====================================================================================
-- 为“套装商品销售数据表（tb_packaged_sales_info）”创建触发器
-- 创建三个触发器：
-- （1）tg_insert_tb_packaged_sales_info：在“套装商品销售数据表（tb_packaged_sales_info）”表中
--      插入销售记录时，自动把套装商品的的销售数据拆分为每个单品的销售数据
-- （2）tg_delete_tb_packaged_sales_info：当删除“套装商品销售数据表（tb_packaged_sales_info）”表中
--      的数据时，自动删除某一个日期对应套装的销售数据
-- （3）tg_update_tb_packaged_sales_info：当删除“套装商品销售数据表（tb_packaged_sales_info）”表中
--      的数据时，自动删除某一个日期对应套装的销售数据
-- ====================================================================================
1
2
3
4
5
6
7
8
9
10

创建插入数据的触发器：tg_insert_tb_packaged_sales_info

-- 创建插入数据的触发器

DROP TRIGGER IF EXISTS `tg_insert_tb_packaged_sales_info`;

delimiter //
create trigger tg_insert_tb_packaged_sales_info
after insert on tb_packaged_sales_info
for each row
begin
insert into tb_packaged_product_sales_info(
       pps_date,
       packaged_no,
       product_no,
       sales_proportion,
       team_no,
       store_no,
       visitors,
       buyers,
       pay,
       refund,
       brush_order,
       brush_amount,
       commission
)
select 
       new.ps_date pps_date,
       new.packaged_no,
       p.product_no,
       ppr.sales_proportion,
       p.team_no,
       new.store_no,
       ppr.sales_proportion * new.visitors visitors,
       ppr.sales_proportion * new.buyers buyers,
       ppr.sales_proportion * new.pay pay,
       ppr.sales_proportion * new.refund refund,
       ppr.sales_proportion * new.brush_order brush_order,
       ppr.sales_proportion * new.brush_amount brush_amount,
       ppr.sales_proportion * new.commission commission
from tb_product p,tb_product_packaged_relation ppr
where p.product_no=ppr.product_no and 
      ppr.packaged_no=new.packaged_no;
end //
delimiter ;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43

创建删除数据的触发器：tg_delete_tb_packaged_sales_info

-- 创建删除数据的触发器

DROP TRIGGER IF EXISTS `tg_delete_tb_packaged_sales_info`;

delimiter //
create trigger tg_delete_tb_packaged_sales_info
after delete on tb_packaged_sales_info
for each row
begin
delete from tb_packaged_product_sales_info
where pps_date=old.ps_date and packaged_no=old.packaged_no;
end //
delimiter ;
1
2
3
4
5
6
7
8
9
10
11
12
13

创建更新数据的触发器：tg_update_tb_packaged_sales_info

-- 创建更新数据的触发器

DROP TRIGGER IF EXISTS `tg_update_tb_packaged_sales_info`;

delimiter //
create trigger tg_update_tb_packaged_sales_info
after update on tb_packaged_sales_info
for each row
begin
-- 删除原有数据
delete from tb_packaged_product_sales_info
where pps_date=old.ps_date and packaged_no=old.packaged_no;

-- 增加新数据
insert into tb_packaged_product_sales_info(
       pps_date,
       packaged_no,
       product_no,
       sales_proportion,
       team_no,
       store_no,
       visitors,
       buyers,
       pay,
       refund,
       brush_order,
       brush_amount,
       commission
)
select 
       new.ps_date pps_date,
       new.packaged_no,
       p.product_no,
       ppr.sales_proportion,
       p.team_no,
       new.store_no,
       ppr.sales_proportion * new.visitors visitors,
       ppr.sales_proportion * new.buyers buyers,
       ppr.sales_proportion * new.pay pay,
       ppr.sales_proportion * new.refund refund,
       ppr.sales_proportion * new.brush_order brush_order,
       ppr.sales_proportion * new.brush_amount brush_amount,
       ppr.sales_proportion * new.commission commission
from tb_product p,tb_product_packaged_relation ppr
where p.product_no=ppr.product_no and 
      ppr.packaged_no=new.packaged_no;
end //
delimiter ;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48

在表【tb_packaged_sales_info】中插入如下一条数据，验证触发器是否正确。

mysql> insert into tb_packaged_sales_info(ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071128773','JC-TM001',325,102,5898.5,1024.58,3,510,52);
Query OK, 1 row affected (0.01 sec)

-- 查询表【tb_packaged_sales_info】中的数据如下：
/*
select ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission
from tb_packaged_sales_info;
*/

mysql> select ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission
    -> from tb_packaged_sales_info;
+---------------------+-------------+----------+----------+--------+---------+---------+-------------+--------------+------------+
| ps_date             | packaged_no | store_no | visitors | buyers | pay     | refund  | brush_order | brush_amount | commission |
+---------------------+-------------+----------+----------+--------+---------+---------+-------------+--------------+------------+
| 2022-01-01 00:00:00 | 62071128773 | JC-TM001 |      325 |    102 | 5898.50 | 1024.58 |           3 |       510.00 |      52.00 |
+---------------------+-------------+----------+----------+--------+---------+---------+-------------+--------------+------------+
1 row in set (0.01 sec)

-- 查询表【tb_packaged_product_sales_info】中的数据如下：
/*
select pps_date,packaged_no,product_no,sales_proportion,team_no,store_no,
visitors,buyers,pay,refund,brush_order,brush_amount,commission
from tb_packaged_product_sales_info;
*/

mysql> select pps_date,packaged_no,product_no,sales_proportion,team_no,store_no,
    -> visitors,buyers,pay,refund,brush_order,brush_amount,commission
    -> from tb_packaged_product_sales_info;
+---------------------+-------------+------------+------------------+-----------+----------+----------+--------+---------+--------+-------------+--------------+------------+
| pps_date            | packaged_no | product_no | sales_proportion | team_no   | store_no | visitors | buyers | pay     | refund | brush_order | brush_amount | commission |
+---------------------+-------------+------------+------------------+-----------+----------+----------+--------+---------+--------+-------------+--------------+------------+
| 2022-01-01 00:00:00 | 62071128773 | JC-SF-01   |            0.720 | DZ02-XZ04 | JC-TM001 |      234 |     73 | 4246.92 | 737.70 |           2 |       367.20 |      37.44 |
| 2022-01-01 00:00:00 | 62071128773 | JC-SF-02   |            0.280 | DZ02-XZ04 | JC-TM001 |       91 |     29 | 1651.58 | 286.88 |           1 |       142.80 |      14.56 |
+---------------------+-------------+------------+------------------+-----------+----------+----------+--------+---------+--------+-------------+--------------+------------+
2 rows in set (0.00 sec)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

在表【tb_packaged_sales_info】中更新数据，验证触发器是否正确。

/*
update tb_packaged_sales_info
set visitors=1000,buyers=100,pay=10000,refund=1000,brush_order=10,
brush_amount=1000,commission=100
where ps_date='2022-1-1' and 
packaged_no='62071128773' and 
store_no='JC-TM001';
*/
mysql> update tb_packaged_sales_info
    -> set visitors=1000,buyers=100,pay=10000,refund=1000,brush_order=10,
    -> brush_amount=1000,commission=100
    -> where ps_date='2022-1-1' and 
    -> packaged_no='62071128773' and 
    -> store_no='JC-TM001';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

-- 查询表【tb_packaged_sales_info】中的数据如下：
/*
select ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission
from tb_packaged_sales_info;
*/
mysql> select ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission
    -> from tb_packaged_sales_info;
+---------------------+-------------+----------+----------+--------+----------+---------+-------------+--------------+------------+
| ps_date             | packaged_no | store_no | visitors | buyers | pay      | refund  | brush_order | brush_amount | commission |
+---------------------+-------------+----------+----------+--------+----------+---------+-------------+--------------+------------+
| 2022-01-01 00:00:00 | 62071128773 | JC-TM001 |     1000 |    100 | 10000.00 | 1000.00 |          10 |      1000.00 |     100.00 |
+---------------------+-------------+----------+----------+--------+----------+---------+-------------+--------------+------------+
1 row in set (0.00 sec)


-- 查询表【tb_packaged_product_sales_info】中的数据如下：
/*
select pps_date,packaged_no,product_no,sales_proportion,team_no,store_no,
visitors,buyers,pay,refund,brush_order,brush_amount,commission
from tb_packaged_product_sales_info;
*/

mysql> select pps_date,packaged_no,product_no,sales_proportion,team_no,store_no,
    -> visitors,buyers,pay,refund,brush_order,brush_amount,commission
    -> from tb_packaged_product_sales_info;
+---------------------+-------------+------------+------------------+-----------+----------+----------+--------+---------+--------+-------------+--------------+------------+
| pps_date            | packaged_no | product_no | sales_proportion | team_no   | store_no | visitors | buyers | pay     | refund | brush_order | brush_amount | commission |
+---------------------+-------------+------------+------------------+-----------+----------+----------+--------+---------+--------+-------------+--------------+------------+
| 2022-01-01 00:00:00 | 62071128773 | JC-SF-01   |            0.720 | DZ02-XZ04 | JC-TM001 |      720 |     72 | 7200.00 | 720.00 |           7 |       720.00 |      72.00 |
| 2022-01-01 00:00:00 | 62071128773 | JC-SF-02   |            0.280 | DZ02-XZ04 | JC-TM001 |      280 |     28 | 2800.00 | 280.00 |           3 |       280.00 |      28.00 |
+---------------------+-------------+------------+------------------+-----------+----------+----------+--------+---------+--------+-------------+--------------+------------+
2 rows in set (0.00 sec)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49

删除表【tb_packaged_sales_info】中的数据，验证触发器是否正确。

/*
delete from tb_packaged_sales_info
where ps_date='2022-1-1' and 
packaged_no='62071128773' and 
store_no='JC-TM001';
*/
mysql> delete from tb_packaged_sales_info
    -> where ps_date='2022-1-1' and 
    -> packaged_no='62071128773' and 
    -> store_no='JC-TM001';
Query OK, 1 row affected (0.01 sec)

-- 查询表【tb_packaged_sales_info】中的数据如下：
/*
select ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission
from tb_packaged_sales_info;
*/
mysql> select ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission
    -> from tb_packaged_sales_info;
Empty set (0.00 sec)

-- 查询表【tb_packaged_product_sales_info】中的数据如下：
/*
select pps_date,packaged_no,product_no,sales_proportion,team_no,store_no,
visitors,buyers,pay,refund,brush_order,brush_amount,commission
from tb_packaged_product_sales_info;
*/
mysql> select pps_date,packaged_no,product_no,sales_proportion,team_no,store_no,
    -> visitors,buyers,pay,refund,brush_order,brush_amount,commission
    -> from tb_packaged_product_sales_info;
Empty set (0.01 sec)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

通过验证，销售数据能够正常插入并能够正确拆分。插入示例数据如下：

insert into tb_packaged_sales_info(ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','62071128773','JC-TM001',325,102,5898.5,1024.58,3,510,52);
insert into tb_packaged_sales_info(ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-1','73245338652','XP-TM001',1258,125,12587.65,502.5,2,1025.7,120.63);
insert into tb_packaged_sales_info(ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','62071128773','JC-TM001',521,58,25878.69,1562.36,3,1502.3,210.36);
insert into tb_packaged_sales_info(ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-2','73245338652','XP-TM001',2015,112,9805.69,520.36,5,580.65,56.35);
insert into tb_packaged_sales_info(ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','62071128773','JC-TM001',1298,50,10253.63,1200.32,4,896.96,86.98);
insert into tb_packaged_sales_info(ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission) values('2022-1-3','73245338652','XP-TM001',526,36,6854.63,856.33,2,987.53,87.56);

-- 查询表【tb_packaged_sales_info】中的数据如下：
/*
select ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission
from tb_packaged_sales_info;
*/
mysql> select ps_date,packaged_no,store_no,visitors,buyers,pay,refund,brush_order,brush_amount,commission
    -> from tb_packaged_sales_info;
+---------------------+-------------+----------+----------+--------+----------+---------+-------------+--------------+------------+
| ps_date             | packaged_no | store_no | visitors | buyers | pay      | refund  | brush_order | brush_amount | commission |
+---------------------+-------------+----------+----------+--------+----------+---------+-------------+--------------+------------+
| 2022-01-01 00:00:00 | 62071128773 | JC-TM001 |      325 |    102 |  5898.50 | 1024.58 |           3 |       510.00 |      52.00 |
| 2022-01-01 00:00:00 | 73245338652 | XP-TM001 |     1258 |    125 | 12587.65 |  502.50 |           2 |      1025.70 |     120.63 |
| 2022-01-02 00:00:00 | 62071128773 | JC-TM001 |      521 |     58 | 25878.69 | 1562.36 |           3 |      1502.30 |     210.36 |
| 2022-01-02 00:00:00 | 73245338652 | XP-TM001 |     2015 |    112 |  9805.69 |  520.36 |           5 |       580.65 |      56.35 |
| 2022-01-03 00:00:00 | 62071128773 | JC-TM001 |     1298 |     50 | 10253.63 | 1200.32 |           4 |       896.96 |      86.98 |
| 2022-01-03 00:00:00 | 73245338652 | XP-TM001 |      526 |     36 |  6854.63 |  856.33 |           2 |       987.53 |      87.56 |
+---------------------+-------------+----------+----------+--------+----------+---------+-------------+--------------+------------+
6 rows in set (0.00 sec)

-- 查询表【tb_packaged_product_sales_info】中的数据如下：
/*
select pps_date,packaged_no,product_no,sales_proportion,team_no,store_no,
visitors,buyers,pay,refund,brush_order,brush_amount,commission
from tb_packaged_product_sales_info;
*/
mysql> select pps_date,packaged_no,product_no,sales_proportion,team_no,store_no,
    -> visitors,buyers,pay,refund,brush_order,brush_amount,commission
    -> from tb_packaged_product_sales_info;
+---------------------+-------------+------------+------------------+-----------+----------+----------+--------+----------+---------+-------------+--------------+------------+
| pps_date            | packaged_no | product_no | sales_proportion | team_no   | store_no | visitors | buyers | pay      | refund  | brush_order | brush_amount | commission |
+---------------------+-------------+------------+------------------+-----------+----------+----------+--------+----------+---------+-------------+--------------+------------+
| 2022-01-01 00:00:00 | 62071128773 | JC-SF-01   |            0.720 | DZ02-XZ04 | JC-TM001 |      234 |     73 |  4246.92 |  737.70 |           2 |       367.20 |      37.44 |
| 2022-01-01 00:00:00 | 62071128773 | JC-SF-02   |            0.280 | DZ02-XZ04 | JC-TM001 |       91 |     29 |  1651.58 |  286.88 |           1 |       142.80 |      14.56 |
| 2022-01-01 00:00:00 | 73245338652 | XP-SR-01   |            0.400 | DZ02-XZ04 | XP-TM001 |      503 |     50 |  5035.06 |  201.00 |           1 |       410.28 |      48.25 |
| 2022-01-01 00:00:00 | 73245338652 | XP-SR-02   |            0.600 | DZ02-XZ04 | XP-TM001 |      755 |     75 |  7552.59 |  301.50 |           1 |       615.42 |      72.38 |
| 2022-01-02 00:00:00 | 62071128773 | JC-SF-01   |            0.720 | DZ02-XZ04 | JC-TM001 |      375 |     42 | 18632.66 | 1124.90 |           2 |      1081.66 |     151.46 |
| 2022-01-02 00:00:00 | 62071128773 | JC-SF-02   |            0.280 | DZ02-XZ04 | JC-TM001 |      146 |     16 |  7246.03 |  437.46 |           1 |       420.64 |      58.90 |
| 2022-01-02 00:00:00 | 73245338652 | XP-SR-01   |            0.400 | DZ02-XZ04 | XP-TM001 |      806 |     45 |  3922.28 |  208.14 |           2 |       232.26 |      22.54 |
| 2022-01-02 00:00:00 | 73245338652 | XP-SR-02   |            0.600 | DZ02-XZ04 | XP-TM001 |     1209 |     67 |  5883.41 |  312.22 |           3 |       348.39 |      33.81 |
| 2022-01-03 00:00:00 | 62071128773 | JC-SF-01   |            0.720 | DZ02-XZ04 | JC-TM001 |      935 |     36 |  7382.61 |  864.23 |           3 |       645.81 |      62.63 |
| 2022-01-03 00:00:00 | 62071128773 | JC-SF-02   |            0.280 | DZ02-XZ04 | JC-TM001 |      363 |     14 |  2871.02 |  336.09 |           1 |       251.15 |      24.35 |
| 2022-01-03 00:00:00 | 73245338652 | XP-SR-01   |            0.400 | DZ02-XZ04 | XP-TM001 |      210 |     14 |  2741.85 |  342.53 |           1 |       395.01 |      35.02 |
| 2022-01-03 00:00:00 | 73245338652 | XP-SR-02   |            0.600 | DZ02-XZ04 | XP-TM001 |      316 |     22 |  4112.78 |  513.80 |           1 |       592.52 |      52.54 |
+---------------------+-------------+------------+------------------+-----------+----------+----------+--------+----------+---------+-------------+--------------+------------+
12 rows in set (0.01 sec)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52