case when 的用法举例说明

1、数据库脚本(自己用)

    

/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.10.251
 Source Server Type    : MySQL
 Source Server Version : 50711
 Source Host           : 192.168.10.251:3306
 Source Schema         : zhqc_hyrd_bi

 Target Server Type    : MySQL
 Target Server Version : 50711
 File Encoding         : 65001

 Date: 15/01/2022 15:27:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dm_container_volume
-- ----------------------------
DROP TABLE IF EXISTS `dm_container_volume`;
CREATE TABLE `dm_container_volume`  (
  `company_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编码',
  `company_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司名称',
  `dept_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部分名称',
  `owner_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户名称',
  `owner_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户编码',
  `businessType` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务类型',
  `goodsTypeName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '货物类型',
  `sales_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '销售员名称',
  `actual_num` int(11) NOT NULL COMMENT '票数',
  `numberbox` int(11) NOT NULL COMMENT '箱数',
  `boxType` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '箱类型',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '箱量统计表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dm_container_volume
-- ----------------------------
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 8, 2, '20', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 3, 6, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 9, 7, '20', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 6, 8, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 2, 5, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 2, 4, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 6, 6, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 2, 5, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 1, 7, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 9, 1, '40RH', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 3, 2, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 7, 10, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 7, 1, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 2, 6, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 9, 9, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 2, 6, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 1, 4, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 10, 1, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 6, 3, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 0, 4, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 4, 0, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 7, 9, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 4, 3, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 10, 1, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 6, 4, '20GP', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 2, 6, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 1, 0, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 1, 2, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 0, 7, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 8, 3, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 2, 1, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 3, 6, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 1, 8, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 5, 1, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 2, 2, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 7, 5, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 7, 9, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 4, 9, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 7, 1, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 7, 7, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 0, 1, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 2, 4, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 8, 9, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 6, 10, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 5, 3, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 9, 7, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 7, 7, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 8, 3, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 2, 5, '20', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 4, 3, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 5, 2, '20RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 2, 1, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 4, 9, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 3, 2, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 6, 3, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 10, 0, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 0, 2, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 3, 10, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 2, 3, '40HC', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 1, 6, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 1, 9, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 1, 7, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 3, 9, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 10, 3, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 1, 8, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 4, 10, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 8, 6, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 7, 1, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 2, 9, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 8, 9, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 7, 10, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 8, 1, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 0, 7, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 8, 3, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 8, 1, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 5, 6, '20RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 2, 7, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 5, 8, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 7, 7, '40RH', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 2, 2, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 9, 9, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 9, 0, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 8, 4, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 5, 10, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 9, 6, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 0, 10, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 4, 2, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 8, 10, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 0, 4, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 7, 9, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 4, 2, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 7, 5, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 5, 0, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 5, 5, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 9, 6, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 9, 2, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 7, 3, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 0, 8, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 9, 2, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 6, 7, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 4, 10, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 1, 6, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 3, 3, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 4, 4, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 7, 4, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 7, 8, '20RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 1, 8, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 5, 4, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 3, 7, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 0, 2, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 1, 1, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 5, 7, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 2, 4, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 3, 8, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 1, 6, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 6, 8, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 8, 3, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 3, 9, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 9, 6, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 7, 6, '40HC', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 10, 8, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 5, 5, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 8, 10, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 2, 4, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 9, 2, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 9, 8, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 8, 2, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 4, 6, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 6, 6, '20', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 8, 1, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 0, 8, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 9, 8, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 2, 6, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 4, 3, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 6, 9, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 5, 6, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 9, 1, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 1, 0, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 9, 6, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 0, 10, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 4, 0, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 0, 2, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 8, 9, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 2, 0, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 4, 3, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 4, 5, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 7, 6, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 5, 4, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 3, 3, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 1, 4, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 7, 2, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 2, 7, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 10, 7, '20RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 1, 4, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 5, 8, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 2, 1, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 7, 10, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 7, 7, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 6, 3, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 9, 6, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 6, 9, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 1, 8, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 0, 1, '20GP', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 8, 4, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 7, 5, '40RH', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 2, 5, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 9, 7, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 1, 2, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 6, 8, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 8, 5, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 3, 1, '40HC', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 1, 1, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 5, 9, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 2, 5, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 7, 9, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 7, 9, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 6, 6, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 9, 4, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 5, 0, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 8, 10, '40RH', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 6, 9, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 7, 7, '20GP', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 7, 9, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 3, 1, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 5, 0, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 4, 7, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 5, 4, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 2, 8, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 7, 8, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 9, 5, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 3, 4, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 1, 2, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 2, 1, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 0, 8, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 4, 7, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 9, 0, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 2, 0, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 2, 10, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 5, 9, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 1, 4, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 7, 5, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 3, 2, '40HC', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 5, 6, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 5, 4, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 0, 2, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 7, 9, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 4, 9, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 1, 7, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 10, 10, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 7, 6, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 7, 1, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 4, 9, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 9, 1, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 3, 8, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 8, 6, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 10, 5, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 5, 9, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 4, 10, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 6, 2, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 10, 0, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 9, 5, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 5, 3, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 1, 0, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 8, 3, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 6, 5, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 9, 4, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 6, 6, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 1, 8, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 7, 2, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 4, 4, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 8, 6, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 8, 7, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 4, 7, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 8, 5, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 6, 2, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 9, 8, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 5, 2, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 9, 6, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 8, 6, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 5, 10, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 1, 2, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 0, 2, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 8, 2, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 10, 6, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 5, 4, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 5, 0, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 9, 10, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 2, 9, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 0, 6, '40RH', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 8, 2, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 6, 2, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 9, 2, '40RH', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 5, 6, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 8, 4, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 6, 3, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 5, 3, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 5, 4, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 3, 3, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 0, 1, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 1, 8, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 4, 5, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 9, 3, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 3, 8, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 8, 3, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 9, 0, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 3, 2, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 6, 1, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 0, 9, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 4, 3, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 8, 5, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 9, 6, '20RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 10, 6, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 3, 4, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 4, 0, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 4, 0, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 7, 9, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 1, 6, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 6, 2, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 5, 4, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 8, 3, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 5, 4, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 2, 2, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 6, 5, '40RH', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 3, 9, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 9, 1, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 5, 8, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 6, 6, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 5, 7, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 8, 8, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 4, 7, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 5, 10, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 2, 0, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 8, 1, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 2, 5, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 6, 3, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 4, 9, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 4, 8, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 5, 0, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 5, 9, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 8, 3, '20', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 7, 9, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 2, 7, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 9, 9, '20RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 0, 1, '20', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 3, 9, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 4, 1, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 2, 7, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 8, 4, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 5, 10, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 10, 6, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 3, 2, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 7, 9, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 5, 1, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 3, 8, '20', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 2, 5, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 1, 3, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 10, 9, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 5, 6, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 4, 4, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 8, 10, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 7, 9, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 9, 3, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 5, 9, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 9, 8, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 9, 2, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 8, 8, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 2, 2, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 7, 7, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 1, 9, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 2, 3, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 6, 9, '20RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 4, 4, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 2, 3, '40RH', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 8, 5, '20', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 3, 6, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 2, 6, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 0, 9, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 7, 0, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 1, 3, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 7, 4, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 10, 1, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 9, 2, '40RH', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 7, 9, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 6, 7, '20GP', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 1, 8, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 7, 9, '20RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 0, 1, '40HC', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 1, 6, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 3, 0, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 4, 3, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 1, 1, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 2, 10, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 6, 5, '20GP', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 3, 5, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 8, 10, '40HC', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 2, 3, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 6, 8, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 3, 0, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 6, 8, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 0, 7, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 4, 4, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 10, 8, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 6, 9, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 1, 1, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 8, 5, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 4, 6, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 9, 2, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 1, 3, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 10, 8, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 4, 0, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 2, 9, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 6, 3, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 3, 1, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 9, 3, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 6, 1, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 2, 9, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 2, 9, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 4, 10, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 4, 1, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 7, 6, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 3, 6, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 4, 3, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 3, 9, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 3, 4, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 6, 4, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 10, 7, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 2, 5, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 8, 1, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 7, 3, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 1, 10, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 4, 1, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 5, 6, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 5, 8, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 7, 0, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 3, 7, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 1, 7, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 7, 1, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 3, 3, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 5, 3, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 4, 6, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 8, 10, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 4, 3, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 9, 4, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 4, 0, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 1, 10, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 2, 8, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 8, 2, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 6, 6, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 4, 4, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 4, 0, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 5, 10, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 3, 8, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 2, 1, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 2, 1, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 3, 2, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 1, 8, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 3, 3, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 4, 2, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 2, 2, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 5, 2, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 1, 5, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 1, 8, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 0, 5, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 8, 3, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 1, 9, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 0, 4, '20RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 9, 6, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 3, 8, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 0, 2, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 2, 7, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 8, 7, '20RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 3, 5, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 1, 2, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 8, 8, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 7, 3, '20GP', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 1, 10, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 5, 0, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 0, 2, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 7, 9, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 3, 0, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 5, 4, '20RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 7, 9, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 0, 3, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 9, 9, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 5, 7, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 8, 5, '20RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 6, 5, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 4, 2, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 4, 2, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 5, 5, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 5, 9, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 0, 10, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 5, 3, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 5, 3, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 9, 9, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 1, 6, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 10, 2, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 4, 2, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 3, 4, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 1, 3, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 7, 5, '20RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 9, 6, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 8, 5, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 1, 8, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 2, 4, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 5, 4, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 9, 1, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 10, 2, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 2, 6, '40RH', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 0, 4, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 6, 2, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 9, 10, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 5, 2, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 10, 2, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 3, 2, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 8, 5, '20GP', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 9, 7, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 10, 3, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 2, 1, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 2, 9, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 4, 0, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 6, 5, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 6, 4, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 1, 5, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 7, 4, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 1, 5, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 4, 0, '20GP', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 10, 9, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 5, 2, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 6, 5, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 3, 10, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 8, 3, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 2, 7, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 7, 4, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 6, 1, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 1, 3, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 8, 2, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 6, 1, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 7, 1, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 7, 8, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 1, 10, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 8, 4, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 4, 10, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 9, 8, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 0, 10, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 5, 4, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 4, 2, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 5, 9, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 2, 6, '20GP', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 6, 5, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 5, 7, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 5, 1, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 2, 3, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 6, 1, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 3, 9, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 6, 9, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 1, 7, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 7, 9, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 2, 6, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 1, 4, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 8, 9, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 7, 2, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 10, 6, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 8, 3, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 2, 9, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 4, 4, '20GP', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 6, 5, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 6, 4, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 5, 2, '20', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 5, 8, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 9, 7, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 0, 8, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 4, 0, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 8, 6, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 1, 0, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 1, 3, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 10, 5, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 8, 7, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 9, 8, '20', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 1, 1, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 9, 2, '40HC', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 2, 5, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 3, 0, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 7, 5, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 7, 5, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 4, 1, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 8, 10, '20GP', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 10, 5, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 4, 7, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 2, 9, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 5, 2, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 3, 5, '20', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 7, 9, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 5, 9, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 6, 7, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 4, 7, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 3, 6, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 5, 9, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 3, 9, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 9, 5, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 8, 10, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 2, 3, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 5, 6, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 2, 1, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 2, 7, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 4, 2, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 4, 10, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 9, 2, '40HC', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 3, 3, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 8, 6, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 2, 0, '20RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 6, 5, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 2, 2, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 4, 6, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 4, 5, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 8, 5, '20RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 6, 1, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 9, 1, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 4, 2, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 2, 6, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 1, 3, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 9, 7, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 9, 7, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 1, 2, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 7, 10, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 2, 2, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 8, 3, '20GP', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 6, 7, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 6, 7, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 10, 6, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 3, 6, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 5, 2, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 4, 5, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 6, 7, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 7, 8, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 9, 2, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 3, 7, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 6, 8, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 3, 9, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 7, 3, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 4, 6, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 1, 1, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 4, 7, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 6, 3, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 7, 5, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 8, 7, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 8, 8, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 5, 9, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 3, 10, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 8, 4, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 1, 9, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 2, 2, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 9, 5, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 7, 9, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 7, 1, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 7, 9, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 2, 9, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 1, 9, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 7, 6, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 3, 6, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 3, 10, '20GP', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 5, 2, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 8, 2, '20GP', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 5, 1, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 2, 10, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 4, 5, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 5, 7, '40HC', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 1, 2, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 2, 6, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 7, 4, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 8, 5, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 9, 0, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 10, 8, '20GP', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 2, 7, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 1, 2, '40HC', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 9, 10, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 3, 3, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 8, 5, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 1, 7, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 1, 2, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 0, 5, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 0, 2, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 0, 3, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 9, 9, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 7, 8, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 6, 1, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 1, 0, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 5, 10, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 2, 8, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 7, 1, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 7, 9, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 4, 5, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 9, 5, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 2, 2, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 2, 5, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 7, 10, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 6, 4, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 2, 8, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 2, 1, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 5, 0, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 8, 9, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 3, 2, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 3, 4, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 6, 2, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 1, 1, '20RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 5, 10, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 2, 5, '40RH', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 4, 4, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 7, 7, '20GP', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 3, 2, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 5, 8, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 4, 6, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 5, 6, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 3, 9, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 1, 1, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 6, 6, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 8, 5, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 2, 10, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 4, 3, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 6, 7, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 9, 4, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 4, 10, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 4, 6, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 0, 3, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 7, 7, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 5, 4, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 4, 1, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 3, 3, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 5, 2, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 4, 3, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 7, 6, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 0, 1, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 2, 8, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 7, 6, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 0, 7, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 10, 6, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 8, 0, '40RH', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 10, 3, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 7, 4, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 3, 0, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 5, 9, '20RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 7, 7, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 9, 6, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 3, 9, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 7, 7, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 8, 9, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 0, 1, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 5, 2, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 6, 4, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 2, 6, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 4, 8, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 6, 1, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 5, 3, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 6, 1, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 7, 7, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 7, 3, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 5, 1, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 2, 8, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 6, 7, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 2, 2, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 3, 9, '40HC', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 10, 8, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 9, 4, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 7, 6, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 7, 7, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 3, 9, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 7, 4, '20GP', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 4, 4, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 1, 7, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 0, 1, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 8, 7, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 2, 0, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 3, 1, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 0, 4, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 3, 8, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 5, 8, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 4, 6, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 7, 7, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 0, 7, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 2, 2, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 8, 0, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 3, 4, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 1, 2, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 5, 6, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 2, 4, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 8, 1, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 2, 5, '40HC', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 5, 1, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 8, 10, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 8, 6, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 5, 0, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 10, 4, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 4, 9, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 9, 3, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 7, 9, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 4, 7, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 3, 7, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 10, 5, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 1, 5, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 7, 7, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 2, 1, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 8, 2, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 6, 10, '40HC', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 3, 2, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 7, 2, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 9, 2, '40HC', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 2, 5, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 3, 1, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 10, 7, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 9, 3, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 7, 4, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 9, 1, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 5, 4, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 5, 6, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 1, 7, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 2, 8, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 4, 9, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 6, 1, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 8, 7, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 2, 4, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 7, 9, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 7, 2, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 6, 4, '20GP', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 10, 4, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 10, 6, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 9, 10, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 5, 10, '40RH', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 8, 1, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 6, 4, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 4, 6, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 5, 0, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 1, 2, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 2, 10, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 7, 2, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 10, 2, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 6, 3, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 10, 10, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 3, 0, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 3, 2, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 7, 9, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 6, 10, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 8, 1, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 3, 7, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 0, 3, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 2, 3, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 0, 5, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 5, 7, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 3, 8, '40HC', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 0, 10, '20GP', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 2, 6, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 8, 9, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 6, 10, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 3, 9, '40RH', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 10, 9, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 10, 5, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 9, 1, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 6, 9, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 5, 2, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 5, 2, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 0, 7, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 7, 6, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 2, 8, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 9, 4, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 2, 7, '40HC', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 10, 1, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 5, 3, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 4, 4, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 5, 9, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 4, 4, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 6, 5, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 9, 2, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 4, 6, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 5, 1, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 2, 10, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 4, 5, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 5, 7, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 4, 8, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 6, 0, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 8, 8, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 2, 7, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 6, 2, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 2, 9, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 2, 1, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 4, 7, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 3, 2, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 2, 1, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 2, 6, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 5, 9, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 8, 5, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 5, 1, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 10, 7, '20RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 4, 1, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 2, 6, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 8, 7, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 4, 5, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 7, 6, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 4, 6, '20GP', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 6, 2, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 10, 3, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 1, 9, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 5, 7, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 2, 6, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 7, 1, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 9, 6, '20RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 2, 9, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 4, 4, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 2, 3, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 9, 6, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 7, 8, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 0, 4, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 1, 7, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 2, 3, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 10, 2, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 2, 3, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 1, 8, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 7, 9, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 3, 4, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 4, 1, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 10, 5, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 7, 2, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 8, 6, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 9, 4, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 0, 3, '20GP', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 3, 3, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 7, 4, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 5, 1, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 5, 2, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 0, 9, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 6, 9, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 9, 6, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 9, 3, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 6, 7, '40RH', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 3, 5, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 7, 5, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 8, 8, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 8, 7, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 4, 10, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 7, 8, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 3, 1, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 3, 3, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 5, 1, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 6, 6, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 8, 8, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 10, 2, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 6, 5, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 1, 10, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 8, 4, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 4, 0, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 9, 10, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 0, 9, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 6, 4, '20GP', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 7, 3, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 0, 2, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 9, 4, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 4, 3, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 5, 3, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 2, 7, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 5, 4, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 7, 0, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 3, 8, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 4, 0, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 8, 7, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 1, 2, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 9, 1, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 4, 9, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 4, 2, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 6, 3, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 8, 1, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 2, 3, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 6, 3, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 3, 6, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 10, 1, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 9, 6, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 5, 6, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 6, 2, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 7, 3, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 8, 0, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 7, 1, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 1, 5, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 3, 2, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 2, 3, '20RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 2, 10, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 4, 9, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 5, 7, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 0, 8, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 8, 0, '40HC', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 9, 5, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 9, 6, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 0, 5, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 4, 5, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 9, 9, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 2, 1, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 3, 10, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 1, 5, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 4, 7, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 6, 10, '20RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 9, 6, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 7, 4, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 10, 9, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 7, 4, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 5, 4, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 5, 8, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 1, 7, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 10, 3, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 5, 4, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 4, 2, '20RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 7, 5, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 1, 2, '40HC', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 3, 2, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 3, 4, '40HC', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 7, 3, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 4, 4, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 9, 2, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 5, 8, '40HC', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 8, 5, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 2, 1, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 9, 8, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 9, 8, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 9, 8, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 6, 3, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 4, 2, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 10, 2, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 8, 5, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 9, 9, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 1, 7, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 9, 0, '20RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 1, 10, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 10, 9, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 5, 4, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 6, 5, '20GP', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 5, 2, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 8, 6, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 5, 2, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 2, 4, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 5, 2, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 9, 9, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 9, 7, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 6, 10, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 6, 7, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 9, 4, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 8, 2, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 4, 7, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 4, 0, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 10, 0, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 7, 9, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 6, 6, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 10, 3, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 0, 5, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 2, 6, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 8, 4, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 6, 4, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 5, 8, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 8, 7, '20RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 3, 1, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 1, 2, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 6, 10, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 7, 2, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 8, 3, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 7, 6, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 2, 4, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 10, 9, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 3, 5, '40HC', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 4, 8, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 3, 3, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 1, 1, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 7, 5, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 3, 5, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 1, 7, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 8, 3, '20GP', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 8, 1, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 3, 6, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 2, 6, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 2, 4, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 5, 0, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 6, 0, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 8, 1, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 10, 3, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 5, 1, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 7, 8, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 1, 7, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 2, 0, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 8, 0, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 5, 10, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 2, 9, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 3, 4, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 8, 3, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 3, 3, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 2, 6, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 8, 3, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 6, 7, '40RH', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 6, 4, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 1, 0, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 6, 9, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 6, 3, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 4, 8, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 2, 2, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 7, 5, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 9, 0, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 3, 5, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 7, 4, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 7, 5, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 5, 2, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 2, 5, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 5, 9, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 10, 9, '40RH', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 4, 0, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 1, 3, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 2, 3, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 8, 6, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 4, 3, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 5, 6, '20', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 5, 0, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 10, 3, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 3, 6, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 6, 2, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 9, 9, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 9, 8, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 6, 6, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 4, 6, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 1, 3, '20GP', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 4, 7, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 6, 3, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 10, 8, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 1, 8, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 3, 5, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 4, 4, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 0, 2, '20GP', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 9, 10, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 7, 3, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 5, 5, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 3, 6, '40RH', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 3, 3, '20GP', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 4, 0, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 4, 1, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 5, 6, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 4, 7, '40HC', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 6, 6, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 9, 7, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 4, 10, '20', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 4, 7, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 9, 7, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 1, 3, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 9, 2, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 2, 5, '40RH', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 3, 5, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 9, 3, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 5, 9, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 8, 4, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 7, 5, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 1, 2, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 3, 6, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 2, 2, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 2, 2, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 2, 4, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 4, 5, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 5, 3, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 1, 10, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 1, 10, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 3, 0, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 1, 2, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 5, 9, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 1, 1, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 3, 7, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 10, 10, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 10, 8, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 1, 3, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 4, 9, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 6, 7, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 8, 10, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 3, 6, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 10, 9, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 1, 9, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 7, 8, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 3, 3, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 2, 9, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 10, 6, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 4, 4, '20GP', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 2, 4, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 7, 5, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 7, 6, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 7, 4, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 2, 1, '40', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 1, 2, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 0, 8, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 6, 5, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 1, 9, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 4, 3, '40HC', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 0, 6, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 8, 1, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 1, 9, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 1, 1, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 10, 8, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 7, 5, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 4, 4, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 10, 4, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 7, 9, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 7, 3, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 5, 6, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 4, 1, '40HC', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 3, 9, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 6, 10, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 8, 3, '20GP', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 2, 8, '40RF', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 8, 8, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 2, 5, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 8, 4, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 2, 2, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 9, 9, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员3', 6, 0, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员3', 5, 3, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 5, 3, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 1, 6, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 2, 0, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 4, 3, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员0', 3, 7, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 5, 5, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 5, 4, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 1, 3, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 1, 5, '特殊', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员5', 1, 5, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 4, 2, '40RH', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 4, 4, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 9, 3, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 2, 3, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员4', 5, 8, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 8, 9, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 4, 10, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 7, 4, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 2, 9, '40', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 8, 4, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 5, 3, '20RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 10, 2, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 5, 1, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 7, 1, '20', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 1, 9, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 1, 4, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 1, 1, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 5, 5, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 1, 0, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 1, 7, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 1, 3, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 1, 4, '20GP', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员5', 2, 0, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员9', 6, 10, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 5, 8, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 6, 1, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 5, 2, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员2', 6, 7, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员5', 6, 9, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 4, 5, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 8, 7, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 2, 10, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 4, 8, '40HC', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 5, 2, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 3, 5, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 8, 10, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 0, 3, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员9', 9, 5, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员1', 2, 7, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 5, 10, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 8, 7, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 5, 8, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 2, 7, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 6, 3, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员2', 1, 4, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员5', 10, 0, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 5, 9, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员8', 7, 6, '40HC', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员6', 9, 2, '40', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 3, 1, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 8, 1, '40RH', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 3, 1, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 9, 1, '40RH', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 8, 1, '40RF', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 2, 3, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员6', 7, 2, '20GP', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 7, 1, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 4, 7, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 9, 5, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 5, 4, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 9, 3, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员0', 8, 6, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 5, 8, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 0, 3, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 7, 0, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员7', 4, 2, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 7, 1, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 5, 8, '20', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 3, 9, '20', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员7', 9, 8, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 8, 3, '特殊', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 3, 1, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员6', 0, 5, '40', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员7', 2, 5, '40RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员6', 9, 8, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员2', 0, 7, '20RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 5, 1, '20GP', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员1', 2, 4, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员4', 6, 8, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 4, 9, '40HC', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员4', 1, 8, '40RF', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员1', 6, 3, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员4', 4, 10, '20', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 2, 1, '20GP', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员8', 0, 7, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 4, 1, '特殊', '2021-09-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 8, 4, '20RF', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员7', 8, 7, '特殊', '2021-11-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员0', 8, 3, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 5, 2, '40RF', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 3, 4, '20GP', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员3', 9, 4, '40HC', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员0', 8, 8, '40RF', '2021-08-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员2', 0, 9, '40', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员1', 8, 9, '特殊', '2021-10-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员8', 10, 8, '40', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门一', '客户一', 'kehu1', '', '', '销售员9', 4, 5, '20', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户一', 'kehu1', '', '', '销售员3', 3, 1, '特殊', '2021-07-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com1', '公司一', '部门二', '客户二', 'kehu2', '', '', '销售员8', 1, 8, '40RH', '2021-12-24 11:20:31');
INSERT INTO `dm_container_volume` VALUES ('com2', '公司二', '部门二', '客户一', 'kehu1', '', '', '销售员9', 5, 6, '40HC', '2021-12-24 11:20:31');

SET FOREIGN_KEY_CHECKS = 1;

2、写的sql语句

       


--  ---- 1、虚拟多列的需要用把case when分开单独写。
--  ---- 2.1、虚拟一列内容需要通过判断填写的,比如性别列,
--  ---- 2.2、内容需要填写(男/女),可以把casewhen写在一起,
--  ---- 2.3、一个end结束符,一个as 别名就ok了,
--  ---- 2.4、根据不同情况,用不同方法。

-- -------------------- 实现方法(完整版写法)
-- --------------------  ELSE 0  也可以不要

select *,
sum(ta.20GP+ta.20RF+ta.40RF+ta.40HC+ta.40RH) as 'TEU',
concat((Round(((sum(ta.20GP+ta.20RF+ta.40RF+ta.40HC+ta.40RH)/
sum(ta.20GP+ta.20RF+ta.40RF+ta.40HC+ta.40RH+ta.20n+ta.40n+ta.tsn))*100),2)),'%') as 'zhanbi'
from(
select t.company_name as 'company_n1',SUM(t.actual_num) as 'actual_n1', 
  sum(CASE t.boxType WHEN '20GP' THEN 1  ELSE 0   END) as '20GP',
  sum(CASE t.boxType WHEN '20RF' THEN 1  ELSE 0   END) as '20RF',
  sum(CASE t.boxType WHEN '40RF' THEN 1  ELSE 0   END) as '40RF',
  sum(CASE t.boxType WHEN '40HC' THEN 1  ELSE 0   END) as '40HC',
  sum(CASE t.boxType WHEN '40RH' THEN 1  ELSE 0   END) as '40RH',
  sum(CASE t.boxType WHEN '20' THEN 1  ELSE 0   END) as '20n',
  sum(CASE t.boxType WHEN '40' THEN 1  ELSE 0   END) as '40n',
  sum(CASE t.boxType WHEN '特殊' THEN 1  ELSE 0   END) as 'tsn'
from dm_container_volume t
GROUP BY t.company_name) ta
group by ta.company_n1



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值