一道sql题case when 的用法

最新推荐文章于 2024-02-23 17:49:05 发布

小哥骑单车

最新推荐文章于 2024-02-23 17:49:05 发布

阅读量433

点赞数

分类专栏： SQL 数据库 mysql

本文链接：https://blog.csdn.net/lejustdoit/article/details/118997639

版权

SQL 数据库 mysql 专栏收录该内容

13 篇文章 1 订阅

订阅专栏

1、表结构，三张表，流程表wf_task2、自然人表cust_nature2、账户表account_info2、

orders订单表（订单表此处没有数据关联）；

CREATE TABLE `wf_task2` (
  `id` varchar(32) NOT NULL,
  `buss_no` varchar(128) NOT NULL DEFAULT '' COMMENT '订单号',
  `cust_id` varchar(32) DEFAULT NULL COMMENT '客户ID',
  `cust_name` varchar(64) DEFAULT NULL COMMENT '客户名称',
  `task_type` varchar(2) NOT NULL COMMENT '任务类型',
  `task_name` varchar(64) DEFAULT NULL COMMENT '任务类型名称',
  `owner_id` varchar(32) DEFAULT NULL COMMENT '任务员ID',
  `owner_name` varchar(64) DEFAULT NULL COMMENT '任务员姓名',
  `begin_time` timestamp NULL DEFAULT NULL COMMENT '任务开始时间',
  `finish_time` timestamp NULL DEFAULT NULL COMMENT '任务完成时间',
  `pre_id` varchar(32) DEFAULT NULL COMMENT '前一个任务ID',
  `remark` varchar(256) DEFAULT NULL COMMENT '备注',
  `is_current` varchar(1) NOT NULL DEFAULT 'Y' COMMENT '是否有效：Y-有效，N-无效，已删除',
  `status` varchar(8) NOT NULL DEFAULT '00' COMMENT '任务状态：00-待处理，01-处理中，02-已提交（审批通过等正向操作），03-已拒绝，04-已退回，...',
  `creator` varchar(32) NOT NULL DEFAULT '' COMMENT '创建人员ID',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `editor` varchar(32) NOT NULL DEFAULT '' COMMENT '修改人员ID',
  `edit_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `idx_buss_no` (`buss_no`),
  KEY `idx_task_type_status` (`task_type`,`status`),
  KEY `idx_buss_no_task_type_status` (`buss_no`,`task_type`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务流-任务节点表';



CREATE TABLE `cust_nature2` (
  `id` varchar(32) NOT NULL DEFAULT '' COMMENT '客户ID',
  `buss_no` varchar(128) DEFAULT '' COMMENT '业务编号',
  `partner_type` varchar(8) DEFAULT 'NAT' COMMENT '商业伙伴类型, NAT - 自然人， LEG - 法人',
  `identity_type` varchar(24) NOT NULL DEFAULT '' COMMENT '身份类型',
  `cust_name` varchar(128) DEFAULT '' COMMENT '客户姓名',
  `cust_sex` varchar(32) DEFAULT '' COMMENT '性别， F - 女， M - 男',
  `cust_nation` varchar(50) DEFAULT '' COMMENT '国籍',
  `cert_no` varchar(255) DEFAULT '' COMMENT '身份证号',
  `cert_type` varchar(16) DEFAULT 'ID_CARD' COMMENT '证件类型：ID_CARD - 身份证， MILITARY_ID - 军官证， PASSPORT - 护照',
  `cert_long_term` varchar(2) DEFAULT '' COMMENT '证件是否长期有效',
  `cert_start_date` date DEFAULT '1970-01-01' COMMENT '证件生效时间',
  `cert_end_date` date DEFAULT '1970-01-01' COMMENT '证件失效时间',
  `cust_homeplace` varchar(1024) DEFAULT '' COMMENT '户籍地址',
  `cust_age` varchar(24) DEFAULT '' COMMENT '客户年龄',
  `cust_type` varchar(24) DEFAULT '' COMMENT '客户类别',
  `cust_mobile` varchar(128) DEFAULT '' COMMENT '联系电话',
  `cust_wechat` varchar(256) DEFAULT '' COMMENT '微信',
  `cust_education` varchar(128) DEFAULT '' COMMENT '教育程度',
  `cust_marriage` varchar(64) DEFAULT '' COMMENT '婚姻状况： married- 已婚， unmarried - 未婚， divorced - 离异， widowed - 丧偶',
  `cust_relation` varchar(16) DEFAULT '' COMMENT '与承租人关系: FAMILY - 亲属、MATE - 同事、OTHER - 其他',
  `marriage_settlement` varchar(4) DEFAULT '' COMMENT '提供财产分割协议 Y/N(评分卡使用)',
  `residence_years` varchar(24) DEFAULT '' COMMENT '申请地居住年限',
  `culture_years` varchar(24) DEFAULT '' COMMENT '种植年限',
  `cust_address` varchar(2000) DEFAULT '' COMMENT '现住地址',
  `cust_profession` varchar(50) DEFAULT '' COMMENT '职业',
  `company` varchar(300) NOT NULL DEFAULT '' COMMENT '工作单位',
  `buss_type` varchar(8) DEFAULT '' COMMENT '业务类型， CZ - 承租人，BZ - 保证人，HG - 回购人（暂不支持） ',
  `cust_is_main` varchar(1) DEFAULT '' COMMENT '是否为主承租（担保人）， N - 否， Y - 是',
  `has_children` varchar(1) DEFAULT '' COMMENT '是否有子女： N - 无， Y - 有',
  `has_credit_report` varchar(32) DEFAULT '' COMMENT '征信报告有无 Y/N',
  `spouse_id` varchar(128) DEFAULT '' COMMENT ' 配偶id',
  `has_lawsuit` varchar(10) DEFAULT 'N' COMMENT '是否涉诉， N -  否， Y - 是',
  `has_enforced` varchar(10) DEFAULT 'N' COMMENT '是否被执行： N - 否， Y - 是',
  `partner_id` varchar(32) DEFAULT '' COMMENT '合作伙伴ID',
  `status` varchar(2) NOT NULL DEFAULT '1' COMMENT '是否有效：0 -无效， 1 - 有效',
  `parent_id` varchar(32) NOT NULL DEFAULT '' COMMENT '父母',
  `creator` varchar(32) DEFAULT '' COMMENT '创建人',
  `editor` varchar(32) DEFAULT '' COMMENT '编辑人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
  `edit_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录更新时间',
  `sort_index` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `has_black` varchar(2) DEFAULT NULL COMMENT '是否黑名单： N：否 Y：是',
  `black_info` varchar(500) DEFAULT NULL,
  `cust_address_code` varchar(16) DEFAULT '' COMMENT '户籍省市代码',
  `cust_address_value` varchar(1024) DEFAULT '' COMMENT '户籍省市值',
  `cust_homeplace_code` varchar(16) DEFAULT '' COMMENT '现住省市代码',
  `cust_homeplace_value` varchar(1024) DEFAULT '' COMMENT '现住省市值',
  `degree` varchar(16) DEFAULT '' COMMENT '学位',
  `query_type` varchar(2) DEFAULT NULL COMMENT 'Y：已查询同盾报告',
  `credit_balance` decimal(15,2) DEFAULT NULL COMMENT '授信余额',
  `loan_balance` decimal(15,2) DEFAULT NULL COMMENT '放款余额',
  `buss_balance` decimal(15,2) DEFAULT NULL COMMENT '业务余额',
  `cust_nation_code` varchar(2) DEFAULT '' COMMENT '自然人民族代码，值',
  `cust_nation_value` varchar(8) DEFAULT '' COMMENT '自然人民族代码，值',
  `credit_balance_bz` decimal(15,2) DEFAULT NULL COMMENT '保证人授信余额',
  `loan_balance_bz` decimal(15,2) DEFAULT NULL COMMENT '保证人放款余额',
  `buss_balance_bz` decimal(15,2) DEFAULT NULL COMMENT '保证人业务余额',
  `credit_balance_hg` decimal(15,2) DEFAULT NULL COMMENT '回购人授信余额',
  `loan_balance_hg` decimal(15,2) DEFAULT NULL COMMENT '回购人放款余额',
  `buss_balance_hg` decimal(15,2) DEFAULT NULL COMMENT '回购人业务余额',
  PRIMARY KEY (`id`),
  KEY `idx_buss_no` (`buss_no`),
  KEY `idx_cust_name` (`cust_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='承租人（自然人保证人与承租人结构相同，类型区分）';



CREATE TABLE `account_info2` (
  `id` varchar(32) NOT NULL COMMENT '主键ID',
  `buss_no` varchar(32) NOT NULL DEFAULT '' COMMENT '订单号',
  `type` varchar(30) NOT NULL DEFAULT '' COMMENT '类型',
  `task_type` varchar(2) NOT NULL DEFAULT '' COMMENT '任务流程号',
  `relation_id` varchar(32) NOT NULL DEFAULT '' COMMENT '关联ID',
  `account` varchar(30) NOT NULL DEFAULT '' COMMENT '账户',
  `account_bank` varchar(50) NOT NULL DEFAULT '' COMMENT '账户银行',
  `account_name` varchar(50) NOT NULL DEFAULT '' COMMENT '账户名',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `edit_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `creator` varchar(32) NOT NULL DEFAULT '' COMMENT '创建者',
  `editor` varchar(32) NOT NULL DEFAULT '' COMMENT '编辑者',
  `status` varchar(2) DEFAULT '1' COMMENT '有效位:1-有效;0-无效',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  `phone_no` varchar(32) DEFAULT NULL COMMENT '银行预留手机号',
  PRIMARY KEY (`id`),
  KEY `idx_relation_id` (`relation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='账户信息表';



CREATE TABLE `orders2` (
  `id` varchar(32) NOT NULL COMMENT '序列号',
  `lease_mode` varchar(8) DEFAULT '' COMMENT '租赁模式: ZZ02 -  直租，HZ01 - 回租',
  `buss_no` varchar(128) NOT NULL DEFAULT '' COMMENT '业务编号',
  `lease_model` varchar(64) DEFAULT '' COMMENT '租赁物规格型号',
  `place_use` varchar(3000) NOT NULL DEFAULT '' COMMENT '使用地点',
  `lease_term` int(10) unsigned DEFAULT '0' COMMENT '租赁期限（月）',
  `lease_time_day` int(10) DEFAULT '0' COMMENT '租赁期限 (天)',
  `first_payment` decimal(15,2) unsigned DEFAULT NULL COMMENT '首付款金额',
  `raise_funds` decimal(15,2) DEFAULT NULL COMMENT '融资金额',
  `lease_amount` decimal(15,2) unsigned DEFAULT NULL COMMENT '租金总额（元），含利息',
  `start_date` date DEFAULT NULL COMMENT '起租时间',
  `end_date` date DEFAULT NULL COMMENT '止租时间',
  `lease_rate` decimal(10,6) DEFAULT NULL COMMENT '租赁利率',
  `repay_rate` varchar(2) DEFAULT 'M' COMMENT '还款频率',
  `calc_type` varchar(10) DEFAULT NULL COMMENT '计息方式   DAY:按日计息   SCHEDULE:按期计息',
  `allowance_amt` decimal(15,2) DEFAULT '0.00' COMMENT '补贴金额',
  `allowance_date` date DEFAULT NULL COMMENT '补贴时间',
  `rebate_amount` decimal(15,2) DEFAULT '0.00' COMMENT '厂商返利金额',
  `rebate_firm_amount` decimal(15,2) DEFAULT '0.00' COMMENT '厂商贴息',
  `firm_rebate_intrest_date` varchar(10) NOT NULL DEFAULT '' COMMENT '厂商贴息时间',
  `other_expense` varchar(30) NOT NULL DEFAULT '0.00' COMMENT '返利厂商',
  `other_expense_date` varchar(10) NOT NULL DEFAULT '' COMMENT '返利厂商时间',
  `risk_capital` decimal(15,2) DEFAULT '0.00' COMMENT '承租人风险金',
  `risk_capital_other` decimal(15,2) DEFAULT '0.00' COMMENT '其他风险金',
  `payment_way` varchar(32) DEFAULT '' COMMENT '租金支付方式',
  `deposit` decimal(10,2) unsigned NOT NULL DEFAULT '1.00' COMMENT '留购价格',
  `settle_ahead` decimal(15,2) DEFAULT '0.00' COMMENT '提前结清',
  `earning_rate` decimal(12,8) DEFAULT NULL COMMENT '内部收益率',
  `task_type` varchar(2) NOT NULL DEFAULT '' COMMENT '任务流程号',
  `task_status` varchar(6) DEFAULT '' COMMENT '流程状态',
  `has_sign_contract` varchar(2) DEFAULT 'N' COMMENT '是否已签订合同， N - 否， Y - 是',
  `pass_loan_approve` varchar(2) DEFAULT 'N' COMMENT '贷款审批是否通过， N - 否， Y - 是',
  `pass_lend_approve` varchar(2) DEFAULT 'N' COMMENT '放款审批是否通过， N - 否， Y - 是',
  `lend_confirm` varchar(2) DEFAULT 'N' COMMENT '是否已经放款确认， N - 否， Y - 是',
  `status` varchar(2) DEFAULT '1' COMMENT '数据是否有效， 0 - 否， 1 - 是',
  `creator` varchar(32) DEFAULT '' COMMENT '创建人',
  `editor` varchar(32) DEFAULT '' COMMENT '修改人',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
  `edit_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录修改时间',
  `depart_id` varchar(32) DEFAULT NULL COMMENT '部门id',
  `sponsor_id` varchar(32) DEFAULT NULL COMMENT '主办人id',
  `jointly_id` varchar(32) DEFAULT NULL COMMENT '协办人id',
  `sponsor_name` varchar(32) DEFAULT NULL COMMENT '主办人姓名',
  `jointly_name` varchar(32) DEFAULT NULL COMMENT '协办人姓名',
  `come_from` varchar(10) DEFAULT 'app' COMMENT '订单来源:app,import',
  `leasee_risk_date` date DEFAULT NULL COMMENT '承租人风险金到账时间',
  `dealer_risk_date` date DEFAULT NULL COMMENT '经销商风险金到账时间',
  `audit_status` varchar(2) DEFAULT NULL COMMENT '自动审批状态：1-通过  2-审慎审核  3-一次拒决 4-二次拒绝',
  `product_type` varchar(2) DEFAULT NULL COMMENT '产品类型：00-正常业务 01- 02',
  `write_off_flag` varchar(10) NOT NULL DEFAULT 'NOT' COMMENT '核销与否,NOT:未核销;FULL:已核销',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_buss_no` (`buss_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='业务订单表rr';

2、需求：取主承租人 cust_nature2的字段姓名、身份证号，并且目前流程wf_task2状态字段status在 00,10 任务类型字段task_type在30的，对应的账户信息account_info2，如果账户表account_info2中有字段任务类型30的，那么取30任务类型的账户，如果只有10的任务类型，取10任务类型的账户；

3、测试数据（mysql数据库语句）：

INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('065151482c5e4acd87709561b2e576d4', 'NJZL-HZ-202009-1407', NULL, NULL, '20', '授信审批', NULL, NULL, NULL, NULL, '60b4f074d04c408abe6172e43817a635', NULL, 'N', '00', 'MY0007', '2020-09-29 14:54:14', '', '2021-07-22 14:32:51');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('08358ffd21c844b69cc3176bc721f030', 'NJZL-HZ-202009-0432', NULL, NULL, '30', '借款合同', NULL, NULL, NULL, NULL, 'bc0857494af14ca39d51b2bc92acb39e', NULL, 'Y', '00', 'admin0', '2020-09-10 18:21:19', 'admin0', '2021-07-22 14:32:51');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('0c52c7a0887f4ad19358b3cc6a9e3efd', 'NJZL-HZ-202010-0029', NULL, NULL, '30', '借款合同', NULL, NULL, '2021-02-02 17:24:36', NULL, '250f9fa4198e4b5e9be723803bed5f26', NULL, 'Y', '00', '0005', '2021-02-02 17:24:36', '0005', '2021-07-22 14:32:51');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('0c7e7408fa3846a78066f30d9ca6347d', 'NJZL-HZ-202105-0064', NULL, NULL, '30', '借款合同', NULL, NULL, NULL, NULL, 'c96a3d6dc75a48ccb78f1473e81749e3', NULL, 'Y', '00', '0005', '2021-06-24 15:21:41', '', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('0fa06f2f732a4aae96459f423f83aae7', 'NJZL-HZ-202010-0227', NULL, NULL, '30', '借款合同', NULL, NULL, NULL, NULL, 'aba1087d4d3f40ac9b429b87c9067573', NULL, 'Y', '00', '0007', '2021-07-22 09:40:54', '0007', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('1447bc6be5694f1abc212b9ea4b48700', 'NJZL-HZ-202010-0029', NULL, NULL, '41', '放款审批复核', '0005', 'admin5', '2021-02-02 17:07:45', '2021-02-02 17:11:57', 'a38587f9bcb840868983e0c96cd8c763', NULL, 'N', '02', '0005', '2021-02-02 17:07:45', '0005', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('17eaadb6b9c64bcbbc8612989042b29b', 'NJZL-HZ-202009-0432', NULL, NULL, '11', '协办处理', '0008', '戴', '2020-09-10 18:19:21', '2020-09-10 18:19:21', 'b63d3d0d78d944f7b021b45b595e548a', NULL, 'Y', '02', '0005', '2020-09-10 18:18:21', '0008', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('1be0ff0994aa4a468184da2521656093', 'NJZL-HZ-202009-1407', NULL, NULL, '30', '借款合同', NULL, NULL, NULL, NULL, '4af721cf746c4cfab1be6b82beecaf62', NULL, 'Y', '00', '0005', '2020-10-09 17:57:34', '', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('1cad728d7e0a44a49075c333438d308f', 'NJZL-HZ-202009-1308', NULL, NULL, '10', '报单申请', '0003', 'admin3', '2020-09-21 11:23:06', '2020-09-21 11:23:28', NULL, NULL, 'Y', '02', '0003', '2020-09-21 11:23:05', '0003', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('1dd1bba03ffe471cadf3ff71fb8e4292', 'NJZL-HZ-202104-0368', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2021-04-14 13:29:26', '2021-04-14 13:29:26', '504487417ce7417fb1f9e8a363722b3e', NULL, 'Y', '02', '0008', '2021-04-14 13:27:09', 'MY0007', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('1ddfc198c3044ef4af947957caf10a47', 'NJZL-HZ-202105-0064', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2021-06-21 10:29:56', '2021-06-21 10:29:56', 'b0e7eef6308d499ab146f71d2d24ddd6', NULL, 'Y', '02', '0008', '2021-06-21 10:15:38', 'MY0007', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('22862fbf0fcc417db763c769214d17cb', 'NJZL-HZ-202011-0517', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2020-11-24 18:01:21', '2020-11-24 18:01:21', '32930eeecb5c4bb984292a6c04a633ee', NULL, 'N', '02', '0003', '2020-11-24 18:01:04', 'MY0007', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('24261eac676745fa90fb691be8689648', 'NJZL-HZ-202010-0029', NULL, NULL, '10', '报单申请', 'MY0005', 'MY0005', '2020-10-12 13:34:55', '2020-10-12 14:24:03', NULL, NULL, 'Y', '02', 'MY0005', '2020-10-12 13:34:55', 'MY0005', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('245314e57d6b40969a17d49775efcde4', 'NJZL-HZ-202009-1308', NULL, NULL, '30', '借款合同', NULL, NULL, NULL, NULL, 'a529499aab45419da3e145e9e336ca55', NULL, 'Y', '00', '0004', '2021-07-05 14:06:49', '0004', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('250f9fa4198e4b5e9be723803bed5f26', 'NJZL-HZ-202010-0029', NULL, NULL, '40', '放款审批经办', '0005', 'admin5', '2021-02-02 17:24:05', '2021-02-02 17:24:36', '1447bc6be5694f1abc212b9ea4b48700', NULL, 'N', '02', '0005', '2021-02-02 17:11:57', '0005', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('2657ab64f2c0455faeae25f77798bf64', 'NJZL-HZ-202011-0517', NULL, NULL, '30', '借款合同', NULL, NULL, NULL, NULL, '851d3d41162a48dd8b73a6e06dcdb9fc', NULL, 'Y', '00', '0007', '2021-07-21 21:00:10', '0007', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('29b9ea8415e949bdbbf1d1025d455cf3', 'NJZL-HZ-202105-0064', NULL, NULL, '22', '秘书审批', '0005', 'admin5', '2021-06-24 14:59:15', '2021-06-24 14:59:15', '7daeae1fb3524d22b3f626a448cafe65', NULL, 'Y', '02', '0005', '2021-06-24 13:14:18', '0005', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('2c06e55834fb41a080199de622fcaffe', 'NJZL-HZ-202103-0018', NULL, NULL, '30', '借款合同', NULL, NULL, NULL, NULL, '759e49efdbf542a28fee7fd7b363f19d', NULL, 'Y', '00', '0004', '2021-07-05 14:10:02', '0004', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('2c3239cbbc19458081b6a72b9dc4b70a', 'NJZL-HZ-202010-0029', NULL, NULL, '21', '资深审批', NULL, NULL, NULL, '2020-10-12 15:03:25', 'a7842af4df464b1c9ec65434d82d32e8', NULL, 'N', '04', '0001', '2020-10-12 15:03:03', 'bdtest4', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('2cbebef252034f65afbc686905753abb', 'NJZL-HZ-202011-0517', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2020-12-29 11:57:44', '2020-12-29 11:57:44', 'edfaf09518aa47c8b39d4176c21a3f9d', NULL, 'Y', '02', 'yincong', '2020-12-09 11:02:15', 'yingge', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('2f46b17a8fad4f78851e135a30b04309', 'NJZL-HZ-202104-0368', NULL, NULL, '30', '借款合同', NULL, NULL, NULL, NULL, 'e4442982cb8f40e3a8b86951707190bd', NULL, 'Y', '00', '0004', '2021-07-05 14:08:31', '0004', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('32930eeecb5c4bb984292a6c04a633ee', 'NJZL-HZ-202011-0517', NULL, NULL, '11', '协办处理', '0003', 'admin3', '2020-11-24 18:01:04', '2020-11-24 18:01:04', '55113f0123b143b3904222ff40c19f97', NULL, 'Y', '02', '0008', '2020-11-24 18:00:39', '0003', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('37da3ba1f9c14afdb0cc5ba7ffe24230', 'NJZL-HZ-202103-0018', NULL, NULL, '11', '协办处理', '0008', '戴', '2021-03-01 13:58:06', '2021-03-01 13:58:06', '7d54a837376340fda57cb60f609ccc2b', NULL, 'Y', '02', 'MY0005', '2021-03-01 13:57:40', '0008', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('3804328dd5534f39944873ede1e7bfce', 'NJZL-HZ-202010-0029', NULL, NULL, '30', '借款合同', NULL, NULL, NULL, NULL, '79ed6ee1de844441918387fcedb71f23', NULL, 'N', '00', '0007', '2020-10-12 14:26:21', '0007', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('3d6f4f070d524b37aa3b61c546e32dd8', 'NJZL-HZ-202009-1407', NULL, NULL, '11', '协办处理', '0008', '戴', '2020-09-29 17:40:31', '2020-09-29 17:40:31', '8f145f87e80d4daa8fc4710e3ac6c993', NULL, 'Y', '02', '0005', '2020-09-29 17:39:46', '0008', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('42a3257f8a9c465f9b5f94970fa53bd8', 'NJZL-HZ-202010-0029', NULL, NULL, '22', '秘书审批', 'bdtest4', 'bdtest4', '2020-10-12 15:06:43', '2020-10-12 15:06:43', '9b7555a869074f82875d2f345f5041d5', NULL, 'Y', '02', '0007', '2020-10-12 15:04:05', 'bdtest4', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('46e74769de1644869e09b82ab7caea5a', 'NJZL-HZ-202009-1407', NULL, NULL, '11', '协办处理', '0008', '戴', '2020-09-29 17:08:28', '2020-09-29 17:08:28', '6c5053ae8fd04391afe7764ed03b7f0c', NULL, 'N', '02', '0005', '2020-09-29 17:06:17', '0008', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('486bad5cb3f24e5f9e515441d0ab3a54', 'NJZL-HZ-202012-0034', NULL, NULL, '30', '借款合同', NULL, NULL, NULL, NULL, '84ef4e0b9bef44edb3c2b9eda32de312', NULL, 'Y', '00', '0007', '2020-12-09 13:55:54', '0007', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('4af721cf746c4cfab1be6b82beecaf62', 'NJZL-HZ-202009-1407', NULL, NULL, '23', '主任审批', '0005', 'admin5', '2020-10-09 17:57:35', '2020-10-09 17:57:35', 'f5a2fd0d039b488688c171f9c0c134ee', NULL, 'Y', '02', '0005', '2020-10-09 17:57:16', '0005', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('4b17b0814701458392118e1437c706ce', 'NJZL-HZ-202010-0227', NULL, NULL, '11', '协办处理', '0008', '戴', '2020-12-29 11:57:17', '2020-12-29 11:57:17', 'eaf74c59c7d44edeb1d88ca2127edbe3', NULL, 'Y', '02', 'MY0005', '2020-10-30 16:43:13', 'yingge', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('4f893e797a7f45f6a76e6362041b6654', 'NJZL-HZ-202009-1407', NULL, NULL, '10', '报单申请', '0005', 'admin5', NULL, '2020-09-29 16:52:43', '065151482c5e4acd87709561b2e576d4', NULL, 'N', '02', '0005', '2020-09-29 16:50:06', '0005', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('504487417ce7417fb1f9e8a363722b3e', 'NJZL-HZ-202104-0368', NULL, NULL, '11', '协办处理', '0008', '戴', '2021-04-14 13:27:10', '2021-04-14 13:27:10', '944bcf56c39642ff9e1da1a1c3cfe5b0', NULL, 'Y', '02', 'MY0005', '2021-04-14 13:23:23', '0008', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('52dbe61cf00543808253dcdf1c4b84e7', 'NJZL-HZ-202011-0517', NULL, NULL, '22', '秘书审批', '0005', 'admin5', NULL, '2020-11-24 18:04:54', 'e1f098fdc0d340dba20f6adf254f108e', NULL, 'N', '04', '0005', '2020-11-24 18:04:39', '0005', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('5329bcfd3c604b019158750c8bf88aa6', 'NJZL-HZ-202012-0034', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2020-12-09 13:54:56', '2020-12-09 13:54:56', '6e01b3f45a214527949b14b61318d594', NULL, 'Y', '02', '0008', '2020-12-09 13:54:26', 'MY0007', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('53b57b83e5614a5d93abebaa74054546', 'NJZL-HZ-202009-1407', NULL, NULL, '20', '授信审批', NULL, NULL, NULL, NULL, 'e3419d9205a24cbdb8741bc4da822aae', NULL, 'N', '00', 'MY0007', '2020-09-29 17:08:44', '', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('55113f0123b143b3904222ff40c19f97', 'NJZL-HZ-202011-0517', NULL, NULL, '10', '报单申请', '0008', '戴', '2020-11-24 17:59:27', '2020-11-24 18:00:39', NULL, NULL, 'Y', '02', '0008', '2020-11-24 17:59:26', '0008', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('60b4f074d04c408abe6172e43817a635', 'NJZL-HZ-202009-1407', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2020-09-29 14:54:14', '2020-09-29 14:54:14', 'ad76c836c378450f81447d12f103cbb0', NULL, 'N', '02', '0008', '2020-09-29 14:53:58', 'MY0007', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('686e52360e1a4eff976fc6cdd3c304b6', 'NJZL-HZ-202010-0227', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2020-12-29 13:10:07', '2020-12-29 13:10:07', '4b17b0814701458392118e1437c706ce', NULL, 'Y', '02', 'yingge', '2020-12-29 11:57:17', 'MY0007', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('6c5053ae8fd04391afe7764ed03b7f0c', 'NJZL-HZ-202009-1407', NULL, NULL, '10', '报单申请', '0005', 'admin5', NULL, '2020-09-29 17:06:18', 'a82c7ef760484479b0c78b7fbb37482d', NULL, 'N', '02', '0005', '2020-09-29 17:04:47', '0005', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('6e01b3f45a214527949b14b61318d594', 'NJZL-HZ-202012-0034', NULL, NULL, '11', '协办处理', '0008', '戴', '2020-12-09 13:54:26', '2020-12-09 13:54:26', 'b2d96b96837a473fb4c59ae3a177479c', NULL, 'Y', '02', 'MY0005', '2020-12-09 13:53:56', '0008', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('7263aac06d3d4395bd239ca7a201da51', 'NJZL-HZ-202009-0432', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2020-09-10 18:20:04', '2020-09-10 18:20:04', '17eaadb6b9c64bcbbc8612989042b29b', NULL, 'Y', '02', '0008', '2020-09-10 18:19:21', 'MY0007', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('754191a635fb4561bdf469a6361f8055', 'NJZL-HZ-202009-0432', NULL, NULL, '10', '报单申请', 'MY0005', 'MY0005', '2020-09-10 17:21:36', '2020-09-10 17:21:36', NULL, NULL, 'N', '02', 'MY0005', '2020-09-08 17:47:54', '0008', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('759e49efdbf542a28fee7fd7b363f19d', 'NJZL-HZ-202103-0018', NULL, NULL, '20', '授信审批', '0004', 'admin4', '2021-07-05 14:10:03', '2021-07-05 14:10:03', 'a59bf76310c6427196c7525cb3c3d4c2', NULL, 'Y', '02', 'MY0007', '2021-03-01 13:58:21', '0004', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('78e272985b8349719829e11a7ba2aa69', 'NJZL-HZ-202009-1308', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2020-09-21 11:24:30', '2020-09-21 11:24:30', '7b3f9b496830448f9ad6d34b6bb32320', NULL, 'Y', '02', '0008', '2020-09-21 11:24:04', 'MY0007', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('79ed6ee1de844441918387fcedb71f23', 'NJZL-HZ-202010-0029', NULL, NULL, '20', '授信审批', '0007', 'AR', '2020-10-12 14:26:22', '2020-10-12 14:26:22', '81e6bfbf31ac4087aade12c7041b1805', NULL, 'N', '02', 'MY0007', '2020-10-12 14:25:20', '0007', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('7b3f9b496830448f9ad6d34b6bb32320', 'NJZL-HZ-202009-1308', NULL, NULL, '11', '协办处理', '0008', '戴', '2020-09-21 11:24:04', '2020-09-21 11:24:04', '1cad728d7e0a44a49075c333438d308f', NULL, 'Y', '02', '0003', '2020-09-21 11:23:28', '0008', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('7d54a837376340fda57cb60f609ccc2b', 'NJZL-HZ-202103-0018', NULL, NULL, '10', '报单申请', 'MY0005', 'MY0005', '2021-03-01 13:55:59', '2021-03-01 13:57:41', NULL, NULL, 'Y', '02', 'MY0005', '2021-03-01 13:55:58', 'MY0005', '2021-07-22 14:32:52');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('7daeae1fb3524d22b3f626a448cafe65', 'NJZL-HZ-202105-0064', NULL, NULL, '20', '授信审批', '0005', 'admin5', '2021-06-24 13:14:19', '2021-06-24 13:14:19', '1ddfc198c3044ef4af947957caf10a47', NULL, 'Y', '02', 'MY0007', '2021-06-21 10:29:55', '0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('81e6bfbf31ac4087aade12c7041b1805', 'NJZL-HZ-202010-0029', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2020-10-12 14:25:21', '2020-10-12 14:25:21', 'f8fd83088477439ba0ae269aea5843a6', NULL, 'Y', '02', '0008', '2020-10-12 14:24:53', 'MY0007', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('8452426f655e4f25acc1b56173b00e7d', 'NJZL-HZ-202011-0517', NULL, NULL, '20', '授信审批', '0005', 'admin5', '2020-11-24 18:04:10', '2020-11-24 18:04:54', 'e85c3bff95d344a28108285080426699', NULL, 'N', '02', '0004', '2020-11-24 18:03:52', '0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('84ef4e0b9bef44edb3c2b9eda32de312', 'NJZL-HZ-202012-0034', NULL, NULL, '20', '授信审批', '0007', 'AR', '2020-12-09 13:55:54', '2020-12-09 13:55:54', '5329bcfd3c604b019158750c8bf88aa6', NULL, 'Y', '02', 'MY0007', '2020-12-09 13:54:56', '0007', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('851d3d41162a48dd8b73a6e06dcdb9fc', 'NJZL-HZ-202011-0517', NULL, NULL, '20', '授信审批', '0007', 'AR', '2021-07-21 21:00:07', '2021-07-21 21:00:07', '2cbebef252034f65afbc686905753abb', NULL, 'Y', '02', 'yingge', '2020-12-29 11:57:43', '0007', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('87be6b0d28b6409fa05d77edf828fee5', 'NJZL-HZ-202010-0029', NULL, NULL, '20', '授信审批', '0007', 'AR', '2020-10-12 14:48:15', '2020-10-12 15:03:25', '3804328dd5534f39944873ede1e7bfce', NULL, 'N', '02', '0007', '2020-10-12 14:38:09', 'bdtest4', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('8bba0a361eaa4929be037bfc64302c20', 'NJZL-HZ-202010-0029', NULL, NULL, '23', '主任审批', 'bdtest4', 'bdtest4', '2020-10-12 15:11:29', '2020-10-12 15:11:29', '42a3257f8a9c465f9b5f94970fa53bd8', NULL, 'Y', '02', 'bdtest4', '2020-10-12 15:06:42', 'bdtest4', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('8f145f87e80d4daa8fc4710e3ac6c993', 'NJZL-HZ-202009-1407', NULL, NULL, '10', '报单申请', '0005', 'admin5', NULL, '2020-09-29 17:39:46', '53b57b83e5614a5d93abebaa74054546', NULL, 'Y', '02', '0005', '2020-09-29 17:38:30', '0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('944bcf56c39642ff9e1da1a1c3cfe5b0', 'NJZL-HZ-202104-0368', NULL, NULL, '10', '报单申请', 'MY0005', 'MY0005', '2021-04-14 13:19:37', '2021-04-14 13:23:24', NULL, NULL, 'Y', '02', 'MY0005', '2021-04-14 13:19:37', 'MY0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('97f0ac6d7fb84c9784965d7225119eac', 'NJZL-HZ-202105-0064', NULL, NULL, '10', '报单申请', 'liuqingyu1', 'liuqingyu1', '2021-05-25 11:09:34', '2021-05-25 11:16:35', NULL, NULL, 'Y', '02', 'liuqingyu1', '2021-05-25 11:09:34', 'liuqin', '2021-07-22 14:33:20');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('9b7555a869074f82875d2f345f5041d5', 'NJZL-HZ-202010-0029', NULL, NULL, '20', '授信审批', '0007', 'AR', '2020-10-12 15:04:05', '2020-10-12 15:04:05', '2c3239cbbc19458081b6a72b9dc4b70a', NULL, 'Y', '02', 'bdtest4', '2020-10-12 15:03:25', '0007', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('a38587f9bcb840868983e0c96cd8c763', 'NJZL-HZ-202010-0029', NULL, NULL, '40', '放款审批经办', '0005', 'admin5', '2020-10-12 15:51:19', '2021-02-02 17:07:45', 'aabe43097d6e49188bfac8781d07ce97', NULL, 'N', '02', '0001', '2020-10-12 15:51:19', '0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('a529499aab45419da3e145e9e336ca55', 'NJZL-HZ-202009-1308', NULL, NULL, '20', '授信审批', '0004', 'admin4', '2021-07-05 14:06:49', '2021-07-05 14:06:49', '78e272985b8349719829e11a7ba2aa69', NULL, 'Y', '02', 'MY0007', '2020-09-21 11:24:30', '0004', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('a59bf76310c6427196c7525cb3c3d4c2', 'NJZL-HZ-202103-0018', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2021-03-01 13:58:22', '2021-03-01 13:58:22', '37da3ba1f9c14afdb0cc5ba7ffe24230', NULL, 'Y', '02', '0008', '2021-03-01 13:58:05', 'MY0007', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('a7842af4df464b1c9ec65434d82d32e8', 'NJZL-HZ-202010-0029', NULL, NULL, '30', '借款合同', '0001', 'admin1', '2020-10-12 15:03:00', NULL, 'd8ac74515b1d4b3d9fc03c514900a7f2', NULL, 'N', '01', 'bdtest4', '2020-10-12 15:02:26', '0001', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('a82c7ef760484479b0c78b7fbb37482d', 'NJZL-HZ-202009-1407', NULL, NULL, '20', '授信审批', NULL, NULL, NULL, NULL, 'ee77bd792876461e9c4e2e3b7843a816', NULL, 'N', '00', 'MY0007', '2020-09-29 16:54:35', '', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('a9263582b48941918941846857f222c7', 'NJZL-HZ-202009-0432', NULL, NULL, '11', '协办处理', '0008', '戴', '2020-09-10 17:21:36', '2020-09-10 17:21:36', '754191a635fb4561bdf469a6361f8055', NULL, 'Y', '02', '0005', '2020-09-10 17:14:19', '0008', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('aabe43097d6e49188bfac8781d07ce97', 'NJZL-HZ-202010-0029', NULL, NULL, '30', '借款合同', '0001', 'admin1', '2020-10-12 15:51:15', '2020-10-12 15:51:19', '8bba0a361eaa4929be037bfc64302c20', NULL, 'N', '02', 'bdtest4', '2020-10-12 15:11:28', '0001', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('aba1087d4d3f40ac9b429b87c9067573', 'NJZL-HZ-202010-0227', NULL, NULL, '20', '授信审批', '0007', 'AR', '2021-07-22 09:40:48', '2021-07-22 09:40:49', '686e52360e1a4eff976fc6cdd3c304b6', NULL, 'Y', '02', 'MY0007', '2020-12-29 13:10:07', '0007', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('ad76c836c378450f81447d12f103cbb0', 'NJZL-HZ-202009-1407', NULL, NULL, '11', '协办处理', '0008', '戴', '2020-09-29 14:53:58', '2020-09-29 14:53:58', 'd544312ea4fb45b7998a2b4154f6e905', NULL, 'N', '02', '0005', '2020-09-29 14:53:31', '0008', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('ae8dee87a82943e882e56b04ac5e6948', 'NJZL-HZ-202009-1407', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2020-09-29 17:40:49', '2020-09-29 17:40:49', '3d6f4f070d524b37aa3b61c546e32dd8', NULL, 'Y', '02', '0008', '2020-09-29 17:40:31', 'MY0007', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('b0e7eef6308d499ab146f71d2d24ddd6', 'NJZL-HZ-202105-0064', NULL, NULL, '11', '协办处理', '0008', '戴', '2021-06-21 10:15:38', '2021-06-21 10:15:38', '97f0ac6d7fb84c9784965d7225119eac', NULL, 'Y', '02', 'liuqingyu1', '2021-05-25 11:16:35', '0008', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('b1514d62417745ea9db1011940fa1448', 'NJZL-HZ-202011-0517', NULL, NULL, '22', '秘书审批', NULL, NULL, NULL, '2020-11-24 18:02:44', 'f83a189744cc47cbbd180a22ec59cf18', NULL, 'N', '04', '0005', '2020-11-24 18:01:58', '0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('b2d96b96837a473fb4c59ae3a177479c', 'NJZL-HZ-202012-0034', NULL, NULL, '10', '报单申请', 'MY0005', 'MY0005', NULL, '2020-12-09 13:53:57', NULL, NULL, 'Y', '02', '', '2020-12-09 10:40:43', 'MY0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('b63d3d0d78d944f7b021b45b595e548a', 'NJZL-HZ-202009-0432', NULL, NULL, '10', '报单申请', 'MY0005', 'MY0005', '2020-09-10 17:21:36', '2020-09-10 18:18:21', 'a9263582b48941918941846857f222c7', NULL, 'Y', '02', '0008', '2020-09-10 17:21:35', '0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('bc0857494af14ca39d51b2bc92acb39e', 'NJZL-HZ-202009-0432', NULL, NULL, '20', '授信审批', 'admin0', 'admin0', '2020-09-10 18:21:19', '2020-09-10 18:21:19', '7263aac06d3d4395bd239ca7a201da51', NULL, 'Y', '02', 'MY0007', '2020-09-10 18:20:04', 'admin0', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('c96a3d6dc75a48ccb78f1473e81749e3', 'NJZL-HZ-202105-0064', NULL, NULL, '23', '主任审批', '0005', 'admin5', '2021-06-24 15:21:41', '2021-06-24 15:21:41', '29b9ea8415e949bdbbf1d1025d455cf3', NULL, 'Y', '02', '0005', '2021-06-24 14:59:15', '0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('cf10c675db2d4689896bb8b92911ec88', 'NJZL-HZ-202009-1407', NULL, NULL, '11', '协办处理', '0008', '戴', '2020-09-29 16:54:18', '2020-09-29 16:54:18', '4f893e797a7f45f6a76e6362041b6654', NULL, 'N', '02', '0005', '2020-09-29 16:52:43', '0008', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('cf5bc7e2c1654185b698f019a188a7cb', 'NJZL-HZ-202011-0517', NULL, NULL, '20', '授信审批', '0005', 'admin5', '2020-11-24 18:03:06', '2020-11-24 18:03:06', 'b1514d62417745ea9db1011940fa1448', NULL, 'N', '02', '0005', '2020-11-24 18:02:43', '0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('d544312ea4fb45b7998a2b4154f6e905', 'NJZL-HZ-202009-1407', NULL, NULL, '10', '报单申请', '0005', 'admin5', '2020-09-27 15:29:07', '2020-09-29 14:53:31', NULL, NULL, 'N', '02', '0005', '2020-09-27 15:29:06', '0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('d8ac74515b1d4b3d9fc03c514900a7f2', 'NJZL-HZ-202010-0029', NULL, NULL, '21', '资深审批', 'bdtest4', 'bdtest4', '2020-10-12 15:02:27', '2020-10-12 15:02:27', '87be6b0d28b6409fa05d77edf828fee5', NULL, 'N', '02', '0007', '2020-10-12 14:48:15', 'bdtest4', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('e1f098fdc0d340dba20f6adf254f108e', 'NJZL-HZ-202011-0517', NULL, NULL, '23', '主任审批', NULL, NULL, NULL, '2020-11-24 18:04:39', 'fef378d0480e4597838565444191891c', NULL, 'N', '04', '0005', '2020-11-24 18:04:25', '0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('e3419d9205a24cbdb8741bc4da822aae', 'NJZL-HZ-202009-1407', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2020-09-29 17:08:44', '2020-09-29 17:08:44', '46e74769de1644869e09b82ab7caea5a', NULL, 'N', '02', '0008', '2020-09-29 17:08:28', 'MY0007', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('e4442982cb8f40e3a8b86951707190bd', 'NJZL-HZ-202104-0368', NULL, NULL, '20', '授信审批', '0004', 'admin4', '2021-07-05 14:08:31', '2021-07-05 14:08:31', '1dd1bba03ffe471cadf3ff71fb8e4292', NULL, 'Y', '02', 'MY0007', '2021-04-14 13:29:25', '0004', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('e85c3bff95d344a28108285080426699', 'NJZL-HZ-202011-0517', NULL, NULL, '30', '借款合同', '0004', 'admin4', '2020-11-24 18:03:35', NULL, 'cf5bc7e2c1654185b698f019a188a7cb', NULL, 'N', '01', '0005', '2020-11-24 18:03:06', '0004', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('eaf74c59c7d44edeb1d88ca2127edbe3', 'NJZL-HZ-202010-0227', NULL, NULL, '10', '报单申请', 'MY0005', 'MY0005', '2020-10-30 16:17:29', '2020-10-30 16:43:13', NULL, NULL, 'Y', '02', 'MY0005', '2020-10-30 16:17:28', 'MY0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('edfaf09518aa47c8b39d4176c21a3f9d', 'NJZL-HZ-202011-0517', NULL, NULL, '20', '授信审批', 'yincong', 'yincong', '2020-12-09 11:02:16', '2020-12-09 11:02:16', '52dbe61cf00543808253dcdf1c4b84e7', NULL, 'N', '04', '0005', '2020-11-24 18:04:54', 'yin', '2021-07-22 14:33:13');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('ee77bd792876461e9c4e2e3b7843a816', 'NJZL-HZ-202009-1407', NULL, NULL, '12', '负责人处理', 'MY0007', '赵金', '2020-09-29 16:54:36', '2020-09-29 16:54:36', 'cf10c675db2d4689896bb8b92911ec88', NULL, 'N', '02', '0008', '2020-09-29 16:54:17', 'MY0007', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('f5a2fd0d039b488688c171f9c0c134ee', 'NJZL-HZ-202009-1407', NULL, NULL, '22', '秘书审批', '0005', 'admin5', '2020-10-09 17:57:17', '2020-10-09 17:57:17', 'f6608c4602b549f7935117875caa0f0e', NULL, 'Y', '02', '0005', '2020-10-09 17:56:54', '0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('f6608c4602b549f7935117875caa0f0e', 'NJZL-HZ-202009-1407', NULL, NULL, '20', '授信审批', '0005', 'admin5', '2020-10-09 17:56:55', '2020-10-09 17:56:55', 'ae8dee87a82943e882e56b04ac5e6948', NULL, 'Y', '02', 'MY0007', '2020-09-29 17:40:48', '0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('f83a189744cc47cbbd180a22ec59cf18', 'NJZL-HZ-202011-0517', NULL, NULL, '20', '授信审批', '0005', 'admin5', '2020-11-24 18:01:58', '2020-11-24 18:02:44', '22862fbf0fcc417db763c769214d17cb', NULL, 'N', '02', 'MY0007', '2020-11-24 18:01:20', '0005', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('f8fd83088477439ba0ae269aea5843a6', 'NJZL-HZ-202010-0029', NULL, NULL, '11', '协办处理', '0008', '戴', '2020-10-12 14:24:53', '2020-10-12 14:24:53', '24261eac676745fa90fb691be8689648', NULL, 'Y', '02', 'MY0005', '2020-10-12 14:24:03', '0008', '2021-07-22 14:32:53');
INSERT INTO `wf_task2`(`id`, `buss_no`, `cust_id`, `cust_name`, `task_type`, `task_name`, `owner_id`, `owner_name`, `begin_time`, `finish_time`, `pre_id`, `remark`, `is_current`, `status`, `creator`, `create_time`, `editor`, `edit_time`) VALUES ('fef378d0480e4597838565444191891c', 'NJZL-HZ-202011-0517', NULL, NULL, '22', '秘书审批', '0005', 'admin5', '2020-11-24 18:04:26', '2020-11-24 18:04:39', '8452426f655e4f25acc1b56173b00e7d', NULL, 'N', '02', '0005', '2020-11-24 18:04:09', '0005', '2021-07-22 14:32:53');














INSERT INTO `cust_nature2`(`id`, `buss_no`, `partner_type`, `identity_type`, `cust_name`, `cust_sex`, `cust_nation`, `cert_no`, `cert_type`, `cert_long_term`, `cert_start_date`, `cert_end_date`, `cust_homeplace`, `cust_age`, `cust_type`, `cust_mobile`, `cust_wechat`, `cust_education`, `cust_marriage`, `cust_relation`, `marriage_settlement`, `residence_years`, `culture_years`, `cust_address`, `cust_profession`, `company`, `buss_type`, `cust_is_main`, `has_children`, `has_credit_report`, `spouse_id`, `has_lawsuit`, `has_enforced`, `partner_id`, `status`, `parent_id`, `creator`, `editor`, `create_time`, `edit_time`, `sort_index`, `has_black`, `black_info`, `cust_address_code`, `cust_address_value`, `cust_homeplace_code`, `cust_homeplace_value`, `degree`, `query_type`, `credit_balance`, `loan_balance`, `buss_balance`, `cust_nation_code`, `cust_nation_value`, `credit_balance_bz`, `loan_balance_bz`, `buss_balance_bz`, `credit_balance_hg`, `loan_balance_hg`, `buss_balance_hg`) VALUES ('13cd40c8a210418cb297c03832b72b12', 'NJZL-HZ-202010-0029', 'NAT', '', '123', 'U+M1nzVVSxix4gfKC9DVjA==', '中国', '213', 'ID_CARD', 'Y', '2020-07-14', '1970-01-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SELF', '', NULL, NULL, NULL, '农民', 'HrqlKtkogqy0uF8u4mBimA==', 'CZ', 'Y', 'N', 'N', '', 'N', 'N', '', '1', '', 'MY0005', '0001', '2020-10-12 13:34:54', '2021-07-22 14:27:46', 1, 'Y', '蚂蚁逾期30天以上或历史存在90天以上逾期客户\r蚂蚁核销客户\r', '120101', NULL, '120102', NULL, '2', 'N', NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cust_nature2`(`id`, `buss_no`, `partner_type`, `identity_type`, `cust_name`, `cust_sex`, `cust_nation`, `cert_no`, `cert_type`, `cert_long_term`, `cert_start_date`, `cert_end_date`, `cust_homeplace`, `cust_age`, `cust_type`, `cust_mobile`, `cust_wechat`, `cust_education`, `cust_marriage`, `cust_relation`, `marriage_settlement`, `residence_years`, `culture_years`, `cust_address`, `cust_profession`, `company`, `buss_type`, `cust_is_main`, `has_children`, `has_credit_report`, `spouse_id`, `has_lawsuit`, `has_enforced`, `partner_id`, `status`, `parent_id`, `creator`, `editor`, `create_time`, `edit_time`, `sort_index`, `has_black`, `black_info`, `cust_address_code`, `cust_address_value`, `cust_homeplace_code`, `cust_homeplace_value`, `degree`, `query_type`, `credit_balance`, `loan_balance`, `buss_balance`, `cust_nation_code`, `cust_nation_value`, `credit_balance_bz`, `loan_balance_bz`, `buss_balance_bz`, `credit_balance_hg`, `loan_balance_hg`, `buss_balance_hg`) VALUES ('3828f0ecfa3644ce98fe1eed179a69fe', 'NJZL-HZ-202009-1308', 'NAT', '', '223', 'naxxDA0kCIlSDmz9Ugo1zw==', '中国', '1233213', 'ID_CARD', 'N', '2020-04-18', '2021-02-18', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SELF', '', NULL, NULL, NULL, '农民', 'HrqlKtkogqy0uF8u4mBimA==', 'CZ', 'Y', 'N', 'N', '', 'N', 'N', '', '1', '', '0003', '0003', '2020-09-21 11:23:05', '2021-07-22 14:27:46', 1, 'Y', '农贷政策性续贷(哈分、鸡西、双鸭山)\r信用卡中心黑名单\r行内自营业务历史存在收回再贷1的农贷客户\r行内自营业务月末时点存在90天以上逾期客户\r京东逾期30天以上或历史存在90天以上逾期客户\r京东核销客户\r村镇银行黑名单(逾期、不良、核销、转让)\r', '110101', NULL, '110101', NULL, '2', NULL, 44000.00, 44000.00, 0.00, '', '', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cust_nature2`(`id`, `buss_no`, `partner_type`, `identity_type`, `cust_name`, `cust_sex`, `cust_nation`, `cert_no`, `cert_type`, `cert_long_term`, `cert_start_date`, `cert_end_date`, `cust_homeplace`, `cust_age`, `cust_type`, `cust_mobile`, `cust_wechat`, `cust_education`, `cust_marriage`, `cust_relation`, `marriage_settlement`, `residence_years`, `culture_years`, `cust_address`, `cust_profession`, `company`, `buss_type`, `cust_is_main`, `has_children`, `has_credit_report`, `spouse_id`, `has_lawsuit`, `has_enforced`, `partner_id`, `status`, `parent_id`, `creator`, `editor`, `create_time`, `edit_time`, `sort_index`, `has_black`, `black_info`, `cust_address_code`, `cust_address_value`, `cust_homeplace_code`, `cust_homeplace_value`, `degree`, `query_type`, `credit_balance`, `loan_balance`, `buss_balance`, `cust_nation_code`, `cust_nation_value`, `credit_balance_bz`, `loan_balance_bz`, `buss_balance_bz`, `credit_balance_hg`, `loan_balance_hg`, `buss_balance_hg`) VALUES ('60ca7f9221444785aaf74119a7f87529', 'NJZL-HZ-202105-0064', 'NAT', '', '342342', 'naxxDA0kCIlSDmz9Ugo1zw==', '中国', '34354', 'ID_CARD', 'N', '2021-03-16', '2031-03-16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SELF', '', NULL, NULL, NULL, '农民', 'HrqlKtkogqy0uF8u4mBimA==', 'CZ', 'Y', 'N', '', '', 'N', 'N', '', '1', '', 'liuqin', 'liuqin', '2021-05-25 11:09:33', '2021-07-22 14:27:46', 1, 'N', '', '110101', NULL, '110102', NULL, '5', 'Y', NULL, NULL, NULL, '01', '汉族', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cust_nature2`(`id`, `buss_no`, `partner_type`, `identity_type`, `cust_name`, `cust_sex`, `cust_nation`, `cert_no`, `cert_type`, `cert_long_term`, `cert_start_date`, `cert_end_date`, `cust_homeplace`, `cust_age`, `cust_type`, `cust_mobile`, `cust_wechat`, `cust_education`, `cust_marriage`, `cust_relation`, `marriage_settlement`, `residence_years`, `culture_years`, `cust_address`, `cust_profession`, `company`, `buss_type`, `cust_is_main`, `has_children`, `has_credit_report`, `spouse_id`, `has_lawsuit`, `has_enforced`, `partner_id`, `status`, `parent_id`, `creator`, `editor`, `create_time`, `edit_time`, `sort_index`, `has_black`, `black_info`, `cust_address_code`, `cust_address_value`, `cust_homeplace_code`, `cust_homeplace_value`, `degree`, `query_type`, `credit_balance`, `loan_balance`, `buss_balance`, `cust_nation_code`, `cust_nation_value`, `credit_balance_bz`, `loan_balance_bz`, `buss_balance_bz`, `credit_balance_hg`, `loan_balance_hg`, `buss_balance_hg`) VALUES ('6b67ef5cc91d484a8c7380dca40fc59f', 'NJZL-HZ-202011-0517', 'NAT', '', '4454', 'naxxDA0kCIlSDmz9Ugo1zw==', '中国', '345345', 'ID_CARD', 'N', '2020-11-24', '2021-11-24', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SELF', '', NULL, NULL, NULL, '农民', 'HrqlKtkogqy0uF8u4mBimA==', 'CZ', 'Y', 'N', 'N', '', 'N', 'N', '', '1', '', '0008', '0004', '2020-11-24 17:59:26', '2021-07-22 14:27:46', 1, 'N', '', '110101', NULL, '110101', NULL, '2', 'Y', 0.00, 0.00, 0.00, '', '', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cust_nature2`(`id`, `buss_no`, `partner_type`, `identity_type`, `cust_name`, `cust_sex`, `cust_nation`, `cert_no`, `cert_type`, `cert_long_term`, `cert_start_date`, `cert_end_date`, `cust_homeplace`, `cust_age`, `cust_type`, `cust_mobile`, `cust_wechat`, `cust_education`, `cust_marriage`, `cust_relation`, `marriage_settlement`, `residence_years`, `culture_years`, `cust_address`, `cust_profession`, `company`, `buss_type`, `cust_is_main`, `has_children`, `has_credit_report`, `spouse_id`, `has_lawsuit`, `has_enforced`, `partner_id`, `status`, `parent_id`, `creator`, `editor`, `create_time`, `edit_time`, `sort_index`, `has_black`, `black_info`, `cust_address_code`, `cust_address_value`, `cust_homeplace_code`, `cust_homeplace_value`, `degree`, `query_type`, `credit_balance`, `loan_balance`, `buss_balance`, `cust_nation_code`, `cust_nation_value`, `credit_balance_bz`, `loan_balance_bz`, `buss_balance_bz`, `credit_balance_hg`, `loan_balance_hg`, `buss_balance_hg`) VALUES ('8c82846ff572471b9e39f03733ac6c2a', 'NJZL-HZ-202010-0227', 'NAT', '', '4545', 'naxxDA0kCIlSDmz9Ugo1zw==', '中国', '131321', 'ID_CARD', 'N', '2020-07-14', '2025-10-03', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SELF', '', NULL, NULL, NULL, '农民', 'HrqlKtkogqy0uF8u4mBimA==', 'CZ', 'Y', 'N', 'N', '', 'N', 'N', '', '1', '', 'MY0005', 'MY0005', '2020-10-30 16:17:28', '2021-07-22 14:27:47', 1, '', '', '120101', NULL, '110101', NULL, '1', NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cust_nature2`(`id`, `buss_no`, `partner_type`, `identity_type`, `cust_name`, `cust_sex`, `cust_nation`, `cert_no`, `cert_type`, `cert_long_term`, `cert_start_date`, `cert_end_date`, `cust_homeplace`, `cust_age`, `cust_type`, `cust_mobile`, `cust_wechat`, `cust_education`, `cust_marriage`, `cust_relation`, `marriage_settlement`, `residence_years`, `culture_years`, `cust_address`, `cust_profession`, `company`, `buss_type`, `cust_is_main`, `has_children`, `has_credit_report`, `spouse_id`, `has_lawsuit`, `has_enforced`, `partner_id`, `status`, `parent_id`, `creator`, `editor`, `create_time`, `edit_time`, `sort_index`, `has_black`, `black_info`, `cust_address_code`, `cust_address_value`, `cust_homeplace_code`, `cust_homeplace_value`, `degree`, `query_type`, `credit_balance`, `loan_balance`, `buss_balance`, `cust_nation_code`, `cust_nation_value`, `credit_balance_bz`, `loan_balance_bz`, `buss_balance_bz`, `credit_balance_hg`, `loan_balance_hg`, `buss_balance_hg`) VALUES ('b1ab7b556d53422db85ddddb4a871479', 'NJZL-HZ-202103-0018', 'NAT', '', 'aa', 'naxxDA0kCIlSDmz9Ugo1zw==', '中国', '687986', 'ID_CARD', 'Y', '2020-09-02', '1970-01-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SELF', '', NULL, NULL, NULL, '农民', 'HrqlKtkogqy0uF8u4mBimA==', 'CZ', 'Y', 'N', '', '', 'N', 'N', '', '1', '', 'MY0005', 'MY0005', '2021-03-01 13:55:58', '2021-07-22 14:27:47', 1, 'N', '', '140702', NULL, '370105', NULL, '1', 'Y', 16252000.00, 15472000.00, 1616559.78, '01', '汉族', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cust_nature2`(`id`, `buss_no`, `partner_type`, `identity_type`, `cust_name`, `cust_sex`, `cust_nation`, `cert_no`, `cert_type`, `cert_long_term`, `cert_start_date`, `cert_end_date`, `cust_homeplace`, `cust_age`, `cust_type`, `cust_mobile`, `cust_wechat`, `cust_education`, `cust_marriage`, `cust_relation`, `marriage_settlement`, `residence_years`, `culture_years`, `cust_address`, `cust_profession`, `company`, `buss_type`, `cust_is_main`, `has_children`, `has_credit_report`, `spouse_id`, `has_lawsuit`, `has_enforced`, `partner_id`, `status`, `parent_id`, `creator`, `editor`, `create_time`, `edit_time`, `sort_index`, `has_black`, `black_info`, `cust_address_code`, `cust_address_value`, `cust_homeplace_code`, `cust_homeplace_value`, `degree`, `query_type`, `credit_balance`, `loan_balance`, `buss_balance`, `cust_nation_code`, `cust_nation_value`, `credit_balance_bz`, `loan_balance_bz`, `buss_balance_bz`, `credit_balance_hg`, `loan_balance_hg`, `buss_balance_hg`) VALUES ('b70c870da70f41b9a8906bb9b9c57f0a', 'NJZL-HZ-202009-1407', 'NAT', '', 'bb', 'naxxDA0kCIlSDmz9Ugo1zw==', '中国', '2150', 'ID_CARD', 'Y', '2020-04-06', '1970-01-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SELF', '', NULL, NULL, NULL, '农民', 'HrqlKtkogqy0uF8u4mBimA==', 'CZ', 'Y', 'N', 'N', '', 'N', 'N', '', '1', '', '0005', '0005', '2020-09-27 15:29:06', '2021-07-22 14:27:47', 1, '', '', '110101', NULL, '110101', NULL, '5', 'Y', NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cust_nature2`(`id`, `buss_no`, `partner_type`, `identity_type`, `cust_name`, `cust_sex`, `cust_nation`, `cert_no`, `cert_type`, `cert_long_term`, `cert_start_date`, `cert_end_date`, `cust_homeplace`, `cust_age`, `cust_type`, `cust_mobile`, `cust_wechat`, `cust_education`, `cust_marriage`, `cust_relation`, `marriage_settlement`, `residence_years`, `culture_years`, `cust_address`, `cust_profession`, `company`, `buss_type`, `cust_is_main`, `has_children`, `has_credit_report`, `spouse_id`, `has_lawsuit`, `has_enforced`, `partner_id`, `status`, `parent_id`, `creator`, `editor`, `create_time`, `edit_time`, `sort_index`, `has_black`, `black_info`, `cust_address_code`, `cust_address_value`, `cust_homeplace_code`, `cust_homeplace_value`, `degree`, `query_type`, `credit_balance`, `loan_balance`, `buss_balance`, `cust_nation_code`, `cust_nation_value`, `credit_balance_bz`, `loan_balance_bz`, `buss_balance_bz`, `credit_balance_hg`, `loan_balance_hg`, `buss_balance_hg`) VALUES ('cb2e662c7f1d4c2791312cb5a12a2df7', 'NJZL-HZ-202009-0432', 'NAT', '', 'cc', 'naxxDA0kCIlSDmz9Ugo1zw==', '中国', '14415', 'ID_CARD', 'Y', '2020-07-14', '1970-01-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SELF', '', NULL, NULL, NULL, '农民', 'HrqlKtkogqy0uF8u4mBimA==', 'CZ', 'Y', 'Y', 'N', '', 'N', 'N', '', '1', '', 'MY0005', '0005', '2020-09-08 17:47:54', '2021-07-22 14:27:47', 1, 'N', '', '120101', NULL, '110101', NULL, '1', NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cust_nature2`(`id`, `buss_no`, `partner_type`, `identity_type`, `cust_name`, `cust_sex`, `cust_nation`, `cert_no`, `cert_type`, `cert_long_term`, `cert_start_date`, `cert_end_date`, `cust_homeplace`, `cust_age`, `cust_type`, `cust_mobile`, `cust_wechat`, `cust_education`, `cust_marriage`, `cust_relation`, `marriage_settlement`, `residence_years`, `culture_years`, `cust_address`, `cust_profession`, `company`, `buss_type`, `cust_is_main`, `has_children`, `has_credit_report`, `spouse_id`, `has_lawsuit`, `has_enforced`, `partner_id`, `status`, `parent_id`, `creator`, `editor`, `create_time`, `edit_time`, `sort_index`, `has_black`, `black_info`, `cust_address_code`, `cust_address_value`, `cust_homeplace_code`, `cust_homeplace_value`, `degree`, `query_type`, `credit_balance`, `loan_balance`, `buss_balance`, `cust_nation_code`, `cust_nation_value`, `credit_balance_bz`, `loan_balance_bz`, `buss_balance_bz`, `credit_balance_hg`, `loan_balance_hg`, `buss_balance_hg`) VALUES ('e288a40c9ec2443d8d07b84c138ba149', 'NJZL-HZ-202104-0368', 'NAT', '', 'dd', 'naxxDA0kCIlSDmz9Ugo1zw==', '中国', '14345', 'ID_CARD', 'N', '2021-03-16', '2031-03-16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SELF', '', NULL, NULL, NULL, '农民', 'HrqlKtkogqy0uF8u4mBimA==', 'CZ', 'Y', 'N', '', '', 'N', 'N', '', '1', '', 'MY0005', 'MY0005', '2021-04-14 13:19:36', '2021-07-22 14:27:47', 1, 'N', '', '110101', NULL, '110101', NULL, '5', 'Y', 35602000.10, 8846000.10, 2776181.05, '01', '汉族', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `cust_nature2`(`id`, `buss_no`, `partner_type`, `identity_type`, `cust_name`, `cust_sex`, `cust_nation`, `cert_no`, `cert_type`, `cert_long_term`, `cert_start_date`, `cert_end_date`, `cust_homeplace`, `cust_age`, `cust_type`, `cust_mobile`, `cust_wechat`, `cust_education`, `cust_marriage`, `cust_relation`, `marriage_settlement`, `residence_years`, `culture_years`, `cust_address`, `cust_profession`, `company`, `buss_type`, `cust_is_main`, `has_children`, `has_credit_report`, `spouse_id`, `has_lawsuit`, `has_enforced`, `partner_id`, `status`, `parent_id`, `creator`, `editor`, `create_time`, `edit_time`, `sort_index`, `has_black`, `black_info`, `cust_address_code`, `cust_address_value`, `cust_homeplace_code`, `cust_homeplace_value`, `degree`, `query_type`, `credit_balance`, `loan_balance`, `buss_balance`, `cust_nation_code`, `cust_nation_value`, `credit_balance_bz`, `loan_balance_bz`, `buss_balance_bz`, `credit_balance_hg`, `loan_balance_hg`, `buss_balance_hg`) VALUES ('ec0d1ab0fe6249b3bf4758176349d9b3', 'NJZL-HZ-202012-0034', 'NAT', '', 'ff', 'naxxDA0kCIlSDmz9Ugo1zw==', '中国', '43265', 'ID_CARD', 'Y', '2020-07-14', '1970-01-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SELF', '', NULL, NULL, NULL, '农民', 'HrqlKtkogqy0uF8u4mBimA==', 'CZ', 'N', 'N', 'N', '', 'N', 'N', '', '1', '', '1661990', 'MY0005', '2020-12-09 10:38:22', '2021-07-22 14:27:47', 1, 'N', '', '120101', NULL, '110101', NULL, '1', 'Y', 14272000.00, 6216000.00, 30001.00, '', '', NULL, NULL, NULL, NULL, NULL, NULL);










INSERT INTO `account_info2`(`id`, `buss_no`, `type`, `task_type`, `relation_id`, `account`, `account_bank`, `account_name`, `create_time`, `edit_time`, `creator`, `editor`, `status`, `remark`, `phone_no`) VALUES ('0684cd39669543c6b8366947e6870425', 'NJZL-HZ-202011-0517', 'estimated_return', '30', '6b67ef5cc91d484a8c7380dca40fc59f', '1234564', '工商', '于世', '2020-11-24 18:03:34', '2021-07-22 14:30:57', '0004', '', '1', '', NULL);
INSERT INTO `account_info2`(`id`, `buss_no`, `type`, `task_type`, `relation_id`, `account`, `account_bank`, `account_name`, `create_time`, `edit_time`, `creator`, `editor`, `status`, `remark`, `phone_no`) VALUES ('0c78e53d70334ce99345bd06b68a98dc', 'NJZL-HZ-202009-0432', 'estimated_return', '30', '78ab5ec06f7d4fb1b1f9cff5fe0be4cc', '123456', '工商', '共鸣', '2020-09-17 16:22:34', '2020-11-02 10:16:06', 'MY0002', '0001', '1', '', NULL);
INSERT INTO `account_info2`(`id`, `buss_no`, `type`, `task_type`, `relation_id`, `account`, `account_bank`, `account_name`, `create_time`, `edit_time`, `creator`, `editor`, `status`, `remark`, `phone_no`) VALUES ('1c0960d9ced54eeba09f9116809908af', 'NJZL-HZ-202012-0034', 'estimated_return', '10', 'ec0d1ab0fe6249b3bf4758176349d9b3', '6217000210001234569', '中国建设银行', '刘青', '2020-12-09 10:38:22', '2021-07-22 14:31:19', '166199', 'MY0005', '1', '', NULL);
INSERT INTO `account_info2`(`id`, `buss_no`, `type`, `task_type`, `relation_id`, `account`, `account_bank`, `account_name`, `create_time`, `edit_time`, `creator`, `editor`, `status`, `remark`, `phone_no`) VALUES ('3f13645db9324a16ad51d3eb3d218dd1', 'NJZL-HZ-202010-0029', 'estimated_return', '30', '13cd40c8a210418cb297c03832b72b12', '6217000210001234569', '中国建设银行', '智润', '2020-10-12 15:02:59', '2021-07-22 14:31:01', '0001', '0001', '1', '', NULL);
INSERT INTO `account_info2`(`id`, `buss_no`, `type`, `task_type`, `relation_id`, `account`, `account_bank`, `account_name`, `create_time`, `edit_time`, `creator`, `editor`, `status`, `remark`, `phone_no`) VALUES ('42cd649b00064e9f9ac88b17ea45654c', 'NJZL-HZ-202104-0368', 'estimated_return', '10', 'e288a40c9ec2443d8d07b84c138ba149', '62148300000', '中国农业银行', '刘青', '2021-04-14 13:19:36', '2021-07-22 14:31:02', 'MY0005', 'MY0005', '1', '', NULL);
INSERT INTO `account_info2`(`id`, `buss_no`, `type`, `task_type`, `relation_id`, `account`, `account_bank`, `account_name`, `create_time`, `edit_time`, `creator`, `editor`, `status`, `remark`, `phone_no`) VALUES ('46fcd75444d74d77ba02bfebafd4ad99', 'NJZL-HZ-202009-1407', 'estimated_return', '10', 'b70c870da70f41b9a8906bb9b9c57f0a', '123123213', '工商', '皮晴', '2020-09-27 15:29:06', '2021-07-22 14:31:03', '0005', '0005', '1', '', NULL);
INSERT INTO `account_info2`(`id`, `buss_no`, `type`, `task_type`, `relation_id`, `account`, `account_bank`, `account_name`, `create_time`, `edit_time`, `creator`, `editor`, `status`, `remark`, `phone_no`) VALUES ('832c871908714f88b9bc9d54c3b85015', 'NJZL-HZ-202103-0018', 'estimated_return', '10', 'b1ab7b556d53422db85ddddb4a871479', '6217000210001234569', '中国建设银行', '刘青', '2021-03-01 13:55:58', '2021-07-22 14:31:04', 'MY0005', 'MY0005', '1', '', NULL);
INSERT INTO `account_info2`(`id`, `buss_no`, `type`, `task_type`, `relation_id`, `account`, `account_bank`, `account_name`, `create_time`, `edit_time`, `creator`, `editor`, `status`, `remark`, `phone_no`) VALUES ('b9169af15a4d4c5c92240dbbd8e61ec2', 'NJZL-HZ-202010-0227', 'estimated_return', '10', '8c82846ff572471b9e39f03733ac6c2a', '6217000210001234569', '中国建设银行', '刘青', '2020-10-30 16:17:28', '2021-07-22 14:31:05', 'MY0005', 'MY0005', '1', '', NULL);
INSERT INTO `account_info2`(`id`, `buss_no`, `type`, `task_type`, `relation_id`, `account`, `account_bank`, `account_name`, `create_time`, `edit_time`, `creator`, `editor`, `status`, `remark`, `phone_no`) VALUES ('c71eaf52894f484c8e965e0a034962a1', 'NJZL-HZ-202009-1308', 'estimated_return', '10', '3828f0ecfa3644ce98fe1eed179a69fe', '1232131', 'gong', '杨东', '2020-09-21 11:23:05', '2021-07-22 14:31:06', '0003', '0003', '1', '', NULL);
INSERT INTO `account_info2`(`id`, `buss_no`, `type`, `task_type`, `relation_id`, `account`, `account_bank`, `account_name`, `create_time`, `edit_time`, `creator`, `editor`, `status`, `remark`, `phone_no`) VALUES ('fc99a6889d9544459d38544a97cfd948', 'NJZL-HZ-202105-0064', 'estimated_return', '10', '60ca7f9221444785aaf74119a7f87529', '62148300000', '中国农业银行', '刘青', '2021-05-25 11:09:33', '2021-07-22 14:31:23', 'liuqi', 'liuqin', '1', '', NULL);

4、sql语句：

SELECT
CASE
	
WHEN
	b.name30 <> 0 THEN
	name30 ELSE name10 
END AS account_name,
	a.cert_no,
	a.cert_type,
	a.buss_no,
CASE
		
		WHEN b.task30 <> 0 THEN
		task30 ELSE task10 
	END AS account 
FROM
	(
	SELECT
		cust_name,
		cert_no,
		cert_type,
		buss_no 
	FROM
		cust_nature2 
	WHERE
		cust_is_main = 'Y' 
		AND buss_no IN ( SELECT buss_no FROM wf_task2 WHERE STATUS IN ( '01', '00' ) AND task_type = '30' AND is_current = 'Y' ) 
	) a
	LEFT JOIN (
	SELECT
		buss_no,
		max( CASE WHEN task_type = '30' THEN account ELSE 0 END ) task30,
		max( CASE WHEN task_type = '10' THEN account ELSE 0 END ) task10,
		max( CASE WHEN task_type = '30' THEN account_name ELSE 0 END ) name30,
		max( CASE WHEN task_type = '10' THEN account_name ELSE 0 END ) name10 
	FROM
		account_info2 
	WHERE
		`status` = '1' 
	GROUP BY
	buss_no 
) b ON a.buss_no = b.buss_no

5、运行结果：

小哥骑单车

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
一道sql题case when 的用法

1、表结构，三张表，流程表、自然人表、账户表、订单表（订单表此处没有数据关联）；CREATE TABLE `wf_task2` ( `id` varchar(32) NOT NULL, `buss_no` varchar(128) NOT NULL DEFAULT '' COMMENT '订单号', `cust_id` varchar(32) DEFAULT NULL COMMENT '客户ID', `cust_name` varchar(64) DEFAULT NULL COMMEN
复制链接

扫一扫