workflow.sql

OA编程 源代码

insert into 处理记录 values('3','2','吴文华','总经理审批','同意','','3.doc','20011128')
insert into 处理记录 values('3','2','吴文华','总经理审批','同意','','3.doc','20011128')
insert into 处理记录 values('3','4','吴文华','结束','同意','','3.doc','20011128')
insert into 处理记录 values('9','1','吴文华','部门经理审批','第一个处理','','9.doc','20011128')
insert into 处理记录 values('9','2','王卫','车库派车','同意','','9.doc','20011128')
insert into 处理记录 values('9','4','吴文华','结束','同意','ok','9.doc','20011128')
insert into 处理记录 values('10','1','王卫','部门经理审批','第一个处理','','10.doc','20011218')
insert into 处理记录 values('10','2','王卫','    车库派车','同意','','10.doc','20011218')
insert into 处理记录 values('13','1','苏燕','会计','第一个处理','','13.doc','20020405')
insert into 处理记录 values('13','2','齐江林','出纳','同意','','13.doc','20020405')
insert into 处理记录 values('13','3','苏燕','结束','同意','','13.doc','20020405')
insert into 处理记录 values('12','1','齐江林','A2','第一个处理','','12.doc','20020410')
insert into 处理记录 values('12','2','齐江林','A3','同意','同意','12.doc','20020410')
insert into 处理记录 values('12','4','齐江林','A4','同意','','12.doc','20020410')
insert into 处理记录 values('12','6','齐江林','A5','同意','','12.doc','20020410')
insert into 处理记录 values('12','8','齐江林','结束','同意','','12.doc','20020410')
insert into 实例路线 values('1','1','1','财务','报销人','同意','部门经理','1','0','王卫报销','2001-9-20','1')
insert into 实例路线 values('1','2','2','财务','部门经理','同意','总经理','1','0','王卫报销','2001-9-20','1')
insert into 实例路线 values('1','2','3','财务','部门经理','不同意','报销人','1','0','王卫报销','2001-9-20','1')
insert into 实例路线 values('1','3','4','财务','总经理','同意','财务','1','0','王卫报销','2001-9-20','1')
insert into 实例路线 values('1','3','5','财务','总经理','不同意','报销人','1','0','王卫报销','2001-9-20','1')
insert into 实例路线 values('1','4','6','财务','财务','同意','结束','1','0','王卫报销','2001-9-20','1')
insert into 实例路线 values('2','1','1','用车申请','用车申请人','同意','部门经理核实','1','1','','2001-11-27','2')
insert into 实例路线 values('2','2','2','用车申请','部门经理核实','同意','总经理审批','1','1','','2001-11-27','2')
insert into 实例路线 values('2','2','3','用车申请','部门经理核实','不同意','用车申请人','1','1','','2001-11-27','2')
insert into 实例路线 values('2','3','4','用车申请','总经理审批','同意','结束','1','1','','2001-11-27','2')
insert into 实例路线 values('2','3','5','用车申请','总经理审批','不同意','用车申请人','1','1','','2001-11-27','2')
insert into 实例路线 values('3','1','1','用车申请','用车申请人','同意','部门经理核实','1','1','','2001-11-27','4')
insert into 实例路线 values('3','2','2','用车申请','部门经理核实','同意','总经理审批','1','1','','2001-11-27','4')
insert into 实例路线 values('3','2','3','用车申请','部门经理核实','不同意','用车申请人','1','1','','2001-11-27','4')
insert into 实例路线 values('3','3','4','用车申请','总经理审批','同意','结束','1','1','','2001-11-27','4')
insert into 实例路线 values('3','3','5','用车申请','总经理审批','不同意','用车申请人','1','1','','2001-11-27','4')
insert into 实例路线 values('4','1','1','出差申请','出差申请人','同意','部分经理审批','1','1','','2001-11-27','5')
insert into 实例路线 values('4','2','2','出差申请','部分经理审批','同意','财务提备用金','1','1','','2001-11-27','5')
insert into 实例路线 values('4','2','3','出差申请','部分经理审批','不同意','出差申请人','1','1','','2001-11-27','5')
insert into 实例路线 values('4','3','4','出差申请','财务提备用金','同意','结束','1','1','','2001-11-27','5')
insert into 实例路线 values('4','3','5','出差申请','财务提备用金','不同意','出差申请人','1','1','','2001-11-27','5')
insert into 实例路线 values('5','1','1','用车申请','用车申请人','同意','部门经理核实','1','1','','2001-11-27','6')
insert into 实例路线 values('5','2','2','用车申请','部门经理核实','同意','总经理审批','1','1','','2001-11-27','6')
insert into 实例路线 values('5','2','3','用车申请','部门经理核实','不同意','用车申请人','1','1','','2001-11-27','6')
insert into 实例路线 values('5','3','4','用车申请','总经理审批','同意','结束','1','1','','2001-11-27','6')
insert into 实例路线 values('5','3','5','用车申请','总经理审批','不同意','用车申请人','1','1','','2001-11-27','6')
insert into 实例路线 values('6','1','1','财务','报销人','同意','部门经理','1','1','','2001-11-27','7')
insert into 实例路线 values('6','2','2','财务','部门经理','同意','总经理','1','1','','2001-11-27','7')
insert into 实例路线 values('6','2','3','财务','部门经理','不同意','报销人','1','1','','2001-11-27','7')
insert into 实例路线 values('6','3','4','财务','总经理','同意','财务','1','1','','2001-11-27','7')
insert into 实例路线 values('6','3','5','财务','总经理','不同意','报销人','1','1','','2001-11-27','7')
insert into 实例路线 values('6','4','6','财务','财务','同意','结束','1','1','','2001-11-27','7')
insert into 实例路线 values('7','1','1','test','a','同意','b','1','1','','2001-11-27','8')
insert into 实例路线 values('7','2','2','test','b','同意','c','1','1','','2001-11-27','8')
insert into 实例路线 values('7','3','3','test','c','同意','结束','0','1','','2001-11-27','8')
insert into 实例路线 values('8','1','1','用车申请','用车申请人','同意','部门经理核实','1','1','','2001-11-27','9')
insert into 实例路线 values('8','2','2','用车申请','部门经理核实','同意','总经理审批','1','1','','2001-11-27','9')
insert into 实例路线 values('8','2','3','用车申请','部门经理核实','不同意','用车申请人','1','1','','2001-11-27','9')
insert into 实例路线 values('8','3','4','用车申请','总经理审批','同意','结束','1','1','','2001-11-27','9')
insert into 实例路线 values('8','3','5','用车申请','总经理审批','不同意','用车申请人','1','1','','2001-11-27','9')
insert into 实例路线 values('9','1','1','用车申请','用车申请','同意','部门经理审批','1','0','222','2001-11-28','10')
insert into 实例路线 values('9','2','2','用车申请','部门经理审批','同意','车库派车','1','0','222','2001-11-28','10')
insert into 实例路线 values('9','2','3','用车申请','部门经理审批','不同意','用车申请','1','0','222','2001-11-28','10')
insert into 实例路线 values('9','3','4','用车申请','车库派车','同意','结束','1','1','222','2001-11-28','10')
insert into 实例路线 values('9','3','5','用车申请','车库派车','不同意','用车申请','1','1','222','2001-11-28','10')
insert into 实例路线 values('9','3','6','用车申请','车库派车','取消','取消','1','1','222','2001-11-28','10')
insert into 实例路线 values('10','1','1','用车申请','用车申请','同意','    部门经理审批','1','0','wangweitest','2001-12-18','11')
insert into 实例路线 values('10','2','2','用车申请','部门经理审批','同意','    车库派车','1','0','wangweitest','2001-12-18','11')
insert into 实例路线 values('10','2','3','用车申请','部门经理审批','不同意','用车申请','1','0','wangweitest','2001-12-18','11')
insert into 实例路线 values('10','3','4','用车申请','车库派车','同意','结束','0','0','wangweitest','2001-12-18','11')
insert into 实例路线 values('10','3','5','用车申请','车库派车','不同意','用车申请','0','0','wangweitest','2001-12-18','11')
insert into 实例路线 values('10','3','6','用车申请','车库派车','取消','取消','0','0','wangweitest','2001-12-18','11')
insert into 实例路线 values('12','1','1','练习','A1','同意','A2','1','0','','2002-3-22','12')
insert into 实例路线 values('12','2','2','练习','A2','同意','A3','1','0','','2002-3-22','12')
insert into 实例路线 values('12','2','3','练习','A2','不同意','A1','1','0','','2002-3-22','12')
insert into 实例路线 values('12','3','4','练习','A3','同意','A4','1','0','','2002-3-22','12')
insert into 实例路线 values('12','3','5','练习','A3','不同意','A2','1','0','','2002-3-22','12')
insert into 实例路线 values('12','4','6','练习','A4','同意','A5','1','0','','2002-3-22','12')
insert into 实例路线 values('12','4','7','练习','A4','不同意','A1','1','0','','2002-3-22','12')
insert into 实例路线 values('12','5','8','练习','A5','同意','结束','1','0','','2002-3-22','12')
insert into 实例路线 values('13','1','1','支出','支出人','同意','会计','1','0','支出凭证','2002-4-5','13')
insert into 实例路线 values('13','2','2','支出','会计','同意','出纳','1','0','支出凭证','2002-4-5','13')
insert into 实例路线 values('13','3','3','支出','出纳','同意','结束','1','0','支出凭证','2002-4-5','13')
insert into 实例路线 values('14','1','1','支出','支出人','同意','    会计','0','0','李德安','2002-4-17','15')
insert into 实例路线 values('14','2','2','支出','会计','同意','    出纳','0','0','李德安','2002-4-17','15')
insert into 实例路线 values('14','3','3','支出','出纳','同意','结束','0','0','李德安','2002-4-17','15')
insert into 实例路线 values('15','1','1','支出','支出人','同意','    会计','0','0','李德安','2002-4-17','16')
insert into 实例路线 values('15','2','2','支出','会计','同意','    出纳','0','0','李德安','2002-4-17','16')
insert into 实例路线 values('15','3','3','支出','出纳','同意','结束','0','0','李德安','2002-4-17','16')
insert into 实例路线 values('16','1','1','支出','支出人','同意','    会计','0','0','李德安','2002-4-17','17')
insert into 实例路线 values('16','2','2','支出','会计','同意','    出纳','0','0','李德安','2002-4-17','17')
insert into 实例路线 values('16','3','3','支出','出纳','同意','结束','0','0','李德安','2002-4-17','17')
insert into 实例路线 values('17','1','1','支出','支出人','同意','    会计','0','0','李德安','2002-4-17','18')
insert into 实例路线 values('17','2','2','支出','会计','同意','    出纳','0','0','李德安','2002-4-17','18')
insert into 实例路线 values('17','3','3','支出','出纳','同意','结束','0','0','李德安','2002-4-17','18')
insert into 实例路线 values('18','1','1','支出','支出人','同意','    会计','0','0','李德安','2002-4-23','19')
insert into 实例路线 values('18','2','2','支出','会计','同意','    出纳','0','0','李德安','2002-4-23','19')
insert into 实例路线 values('18','3','3','支出','出纳','同意','结束','0','0','李德安','2002-4-23','19')
insert into 实例路线 values('19','1','1','支出','支出人','同意','会计','0','0','iiiiiiiiiiiiiiiii','2002-4-24','20')
insert into 实例路线 values('19','2','2','支出','会计','同意','出纳','0','0','iiiiiiiiiiiiiiiii','2002-4-24','20')
insert into 实例路线 values('19','3','3','支出','出纳','同意','结束','0','0','iiiiiiiiiiiiiiiii','2002-4-24','20')
insert into 实例路线 values('20','1','1','支出','支出人','同意','会计','0','0','ppppp','2002-4-24','21')
insert into 实例路线 values('20','2','2','支出','会计','同意','出纳','0','0','ppppp','2002-4-24','21')
insert into 实例路线 values('20','3','3','支出','出纳','同意','结束','0','0','ppppp','2002-4-24','21')
insert into 实例路线 values('21','1','1','支出','支出人','同意','会计','0','0','罗东1','2002-4-24','22')
insert into 实例路线 values('21','2','2','支出','会计','同意','出纳','0','0','罗东1','2002-4-24','22')
insert into 实例路线 values('21','3','3','支出','出纳','同意','结束','0','0','罗东1','2002-4-24','22')
insert into 实例路线 values('22','1','1','购车申请','j1','同意','j2','0','0','LE1','2002-4-24','23')
insert into 实例路线 values('22','2','2','购车申请','j2','同意','结束','0','0','LE1','2002-4-24','23')
insert into 实例路线 values('23','1','1','购车申请','j1','同意','j2','0','0','luo3','2002-4-24','24')
insert into 实例路线 values('23','2','2','购车申请','j2','同意','结束','0','0','luo3','2002-4-24','24')
insert into 实例路线 values('24','1','1','定义流程','定义流程名称','同意','定义流程路线','0','1','','2002-4-26','25')
insert into 实例路线 values('24','2','2','定义流程','定义流程路线','同意','流程实例','0','1','','2002-4-26','25')
insert into 实例路线 values('24','2','3','定义流程','定义流程路线','不同意','定义流程名称','0','1','','2002-4-26','25')
insert into 实例路线 values('24','3','4','定义流程','流程实例','同意','流程执行','0','0','','2002-4-26','25')
insert into 实例路线 values('24','4','5','定义流程','流程执行','同意','选择操作人','0','0','','2002-4-26','25')
insert into 实例路线 values('24','5','6','定义流程','选择操作人','同意','结束','0','0','','2002-4-26','25')
insert into 实例路线 values('24','5','7','定义流程','选择操作人','不同意','流程执行','0','0','','2002-4-26','25')
insert into 实例路线 values('24','6','8','定义流程','结束','同意','结束','0','0','','2002-4-26','25')
insert into 实例路线 values('25','1','1','支出','支出人','同意','会计','0','0','支出凭证','2002-4-26','26')
insert into 实例路线 values('25','2','2','支出','会计','同意','出纳','0','0','支出凭证','2002-4-26','26')
insert into 实例路线 values('25','3','3','支出','出纳','同意','结束','0','0','支出凭证','2002-4-26','26')
insert into 实例路线 values('28','1','1','abc','a','同意','b','0','0','','2002-4-28','29')
insert into 实例路线 values('28','2','2','abc','b','同意','c','0','0','','2002-4-28','29')
insert into 实例路线 values('28','3','3','abc','c','同意','结束','0','0','','2002-4-28','29')
insert into 实例路线 values('29','1','1','abc','a','同意','b','0','0','','2002-4-28','30')
insert into 实例路线 values('29','2','2','abc','b','同意','c','0','0','','2002-4-28','30')
insert into 实例路线 values('29','3','3','abc','c','同意','结束','0','0','','2002-4-28','30')
insert into 实例路线 values('30','1','1','abc','申请人','同意','部门经理','0','0','请假单','2002-4-30','31')
insert into 实例路线 values('30','2','2','abc','部门经理','同意','总经理','0','0','请假单','2002-4-30','31')
insert into 实例路线 values('27','1','1','练习','拟稿人','同意','部门经理','0','0','练习栏目','2002-4-28','28')
insert into 实例路线 values('27','2','2','练习','部门经理','同意','公司经理','0','0','练习栏目','2002-4-28','28')
insert into 实例路线 values('27','2','3','练习','部门经理','不同意','拟稿人','0','0','练习栏目','2002-4-28','28')
insert into 实例路线 values('27','3','4','练习','公司经理','同意','公司总经理','0','0','练习栏目','2002-4-28','28')
insert into 实例路线 values('27','3','5','练习','公司经理','不同意','部门经理','0','0','练习栏目','2002-4-28','28')
insert into 实例路线 values('27','4','6','练习','公司总经理','同意','总裁','0','0','练习栏目','2002-4-28','28')
insert into 实例路线 values('27','4','7','练习','公司总经理','不同意','公司经理','0','0','练习栏目','2002-4-28','28')
insert into 实例路线 values('27','5','8','练习','总裁','同意','结束','0','0','练习栏目','2002-4-28','28')
insert into 实例路线 values('30','2','3','abc','部门经理','不同意','申请人','0','0','请假单','2002-4-30','31')
insert into 实例路线 values('30','3','4','abc','总经理','同意','企管部','0','0','请假单','2002-4-30','31')
insert into 实例路线 values('30','3','5','abc','总经理','不同意','申请人','0','0','请假单','2002-4-30','31')
insert into 实例路线 values('30','4','6','abc','企管部','同意','结束','0','0','请假单','2002-4-30','31')
insert into 实例路线 values('30','4','7','abc','企管部','不同意','申请人','0','0','请假单','2002-4-30','31')
insert into 实例路线 values('31','1','1','abc','申请人','同意','部门经理','0','0','请假单','2002-4-30','32')
insert into 实例路线 values('31','2','2','abc','部门经理','同意','总经理','0','0','请假单','2002-4-30','32')
insert into 实例路线 values('31','2','3','abc','部门经理','不同意','申请人','0','0','请假单','2002-4-30','32')
insert into 实例路线 values('31','3','4','abc','总经理','同意','企管部','0','0','请假单','2002-4-30','32')
insert into 实例路线 values('31','3','5','abc','总经理','不同意','申请人','0','0','请假单','2002-4-30','32')
insert into 实例路线 values('31','4','6','abc','企管部','同意','结束','0','0','请假单','2002-4-30','32')
insert into 实例路线 values('31','4','7','abc','企管部','不同意','申请人','0','0','请假单','2002-4-30','32')