workflow.sql

OA编程 源代码

insert into 实例路线 values('32','1','1','test','a','同意','b','0','0','t1','2002-4-30','33')
insert into 实例路线 values('32','2','2','test','b','同意','c','0','1','t1','2002-4-30','33')
insert into 实例路线 values('32','2','3','test','b','不同意','a','0','1','t1','2002-4-30','33')
insert into 实例路线 values('32','3','4','test','c','同意','结束','0','1','t1','2002-4-30','33')
insert into 实例路线 values('32','3','5','test','c','不同意','a','0','1','t1','2002-4-30','33')
insert into 实例路线 values('33','1','1','test','a','同意','b','0','0','t1','2002-4-30','34')
insert into 实例路线 values('33','2','2','test','b','同意','c','0','0','t1','2002-4-30','34')
insert into 实例路线 values('33','2','3','test','b','不同意','a','0','0','t1','2002-4-30','34')
insert into 实例路线 values('33','3','4','test','c','同意','结束','0','0','t1','2002-4-30','34')
insert into 实例路线 values('33','3','5','test','c','不同意','a','0','0','t1','2002-4-30','34')
insert into 实例路线 values('34','1','1','报销流程','申请人','同意','主管','0','0','','2002-5-8','35')
insert into 实例路线 values('34','2','2','报销流程','主管','同意','销售部经理','0','0','','2002-5-8','35')
insert into 实例路线 values('34','3','3','报销流程','销售部经理','同意','总经理','0','0','','2002-5-8','35')
insert into 实例路线 values('34','4','4','报销流程','总经理','同意','审核人','0','0','','2002-5-8','35')
insert into 实例路线 values('34','5','5','报销流程','审核人','同意','结束','0','0','','2002-5-8','35')
insert into 实例路线 values('34','5','6','报销流程','审核人','不同意','申请人','0','0','','2002-5-8','35')
insert into 实例路线 values('35','1','1','123','1','同意','2','0','0','','2002-5-8','36')
insert into 实例路线 values('35','2','2','123','2','同意','3','0','0','','2002-5-8','36')
insert into 实例路线 values('35','2','3','123','2','不同意','1','0','0','','2002-5-8','36')
insert into 实例路线 values('35','3','4','123','3','同意','结束','0','0','','2002-5-8','36')
insert into 实例路线 values('35','3','5','123','3','不同意','2','0','0','','2002-5-8','36')
insert into 实例路线 values('36','1','1','123','1','同意','2','0','0','','2002-5-8','37')
insert into 实例路线 values('36','2','2','123','2','同意','3','0','0','','2002-5-8','37')
insert into 实例路线 values('36','2','3','123','2','不同意','1','0','0','','2002-5-8','37')
insert into 实例路线 values('36','3','4','123','3','同意','结束','0','0','','2002-5-8','37')
insert into 实例路线 values('36','3','5','123','3','不同意','2','0','0','','2002-5-8','37')
insert into 实例路线 values('37','1','1','测试','a','同意','b','0','0','ds','2002-5-10','38')
insert into 实例路线 values('37','2','2','测试','b','同意','c','0','0','ds','2002-5-10','38')
insert into 实例路线 values('37','2','3','测试','b','不同意','a','0','0','ds','2002-5-10','38')
insert into 实例路线 values('37','3','4','测试','c','同意','d','0','0','ds','2002-5-10','38')
insert into 实例路线 values('37','3','5','测试','c','不同意','b','0','0','ds','2002-5-10','38')
insert into 实例路线 values('37','4','6','测试','d','同意','结束','0','0','ds','2002-5-10','38')
insert into 实例路线 values('38','1','1','支出','支出人','同意','会计','0','0','支出凭证','2002-6-3','39')
insert into 实例路线 values('38','2','2','支出','会计','同意','出纳','0','0','支出凭证','2002-6-3','39')
insert into 实例路线 values('38','3','3','支出','出纳','同意','结束','0','0','支出凭证','2002-6-3','39')
insert into 实例路线 values('39','1','1','支出','支出人','同意','会计','0','0','支出凭证','2002-6-5','40')
insert into 实例路线 values('39','2','2','支出','会计','同意','出纳','0','0','支出凭证','2002-6-5','40')
insert into 实例路线 values('39','3','3','支出','出纳','同意','结束','0','0','支出凭证','2002-6-5','40')
insert into 实例路线 values('40','1','1','支出','支出人','同意','    会计','0','0','李德安','2002-6-7','41')
insert into 实例路线 values('40','2','2','支出','会计','同意','    出纳','0','0','李德安','2002-6-7','41')
insert into 实例路线 values('40','3','3','支出','出纳','同意','结束','0','0','李德安','2002-6-7','41')
insert into 流程 values('8','用车申请','ld','关于用车申请')
insert into 流程 values('5','公文','zhh','公文流转')
insert into 流程 values('4','购车申请','ld','注意细节')
insert into 流程 values('9','测试','ybx','')
insert into 流程 values('3','报告','ld','')
insert into 流程 values('7','请假','ltr','黑糊糊')
insert into 流程 values('12','实验','lyf','实验')
insert into 流程 values('13','支出','zhh','支出凭证')
insert into 流程 values('14','定义流程','qjl','定义流程需要哪些过程')
insert into 流程 values('15','出差申请管理','ld','333')
insert into 流程 values('16','练习','qjl','只是练习')
insert into 流程 values('17','abc','wky','')
insert into 流程 values('18','www','wxl','')
insert into 流程 values('19','abc','wxl','')
insert into 流程 values('20','test','wky','')
insert into 流程 values('21','123','sunyan','123')
insert into 流程 values('22','测试','qjl','测试流程')
insert into 流程 values('23','dsfasdf','ld','adsf')
insert into 流程 values('24','af','ld','asdf')
insert into 流程 values('25','asdf','ld','af')
insert into 流程路线 values('17','1','a','同意','2')
insert into 流程路线 values('17','2','b','同意','3')
insert into 流程路线 values('17','3','c','同意','100')
insert into 流程路线 values('18','1','wwww','同意','2')
insert into 流程路线 values('18','2','www','同意','3')
insert into 流程路线 values('18','2','www','不同意','1')
insert into 流程路线 values('18','3','ww','同意','4')
insert into 流程路线 values('18','4','w','同意','100')
insert into 流程路线 values('19','1','申请人','同意','2')
insert into 流程路线 values('19','2','部门经理','同意','3')
insert into 流程路线 values('19','2','部门经理','不同意','1')
insert into 流程路线 values('19','3','总经理','同意','4')
insert into 流程路线 values('19','3','总经理','不同意','1')
insert into 流程路线 values('19','4','企管部','同意','100')
insert into 流程路线 values('19','4','企管部','不同意','1')
insert into 流程路线 values('20','1','a','同意','2')
insert into 流程路线 values('20','2','b','同意','3')
insert into 流程路线 values('20','2','b','不同意','1')
insert into 流程路线 values('20','3','c','同意','100')
insert into 流程路线 values('20','3','c','不同意','1')
insert into 流程路线 values('21','1','1','同意','2')
insert into 流程路线 values('21','2','2','同意','3')
insert into 流程路线 values('21','2','2','不同意','1')
insert into 流程路线 values('21','3','3','同意','100')
insert into 流程路线 values('21','3','3','不同意','2')
insert into 流程路线 values('22','1','a','同意','2')
insert into 流程路线 values('22','2','b','同意','3')
insert into 流程路线 values('22','2','b','不同意','1')
insert into 流程路线 values('22','3','c','同意','4')
insert into 流程路线 values('22','3','c','不同意','2')
insert into 流程路线 values('22','4','d','同意','100')
insert into 流程路线 values('8','1','asdf','同意','2')
insert into 流程路线 values('8','2','fdsad','同意','3')
insert into 流程路线 values('8','3','weaw','同意','4')
insert into 流程路线 values('8','4','fdsa','同意','5')
insert into 流程路线 values('8','5','ddsa','同意','6')
insert into 流程路线 values('8','6','ewer','同意','7')
insert into 流程路线 values('8','7','asdfe','同意','8')
insert into 流程路线 values('8','8','asfe','同意','9')
insert into 流程路线 values('8','9','efas','同意','10')
insert into 流程路线 values('8','10','werw','同意','100')
insert into 角色 values('1','报销人','王卫','无','0','1','1')
insert into 角色 values('1','部门经理','王卫','无','0','2','2')
insert into 角色 values('1','总经理','王卫','无','0','3','3')
insert into 角色 values('1','财务','王卫','无','0','4','4')
insert into 角色 values('2','用车申请人','吴文华','无','0','1','1')
insert into 角色 values('2','部门经理核实','王卫','无','1','2','2')
insert into 角色 values('2','总经理审批','李洪兵','无','1','3','3')
insert into 角色 values('3','用车申请人','王卫','无','0','1','1')
insert into 角色 values('3','部门经理核实','吴文华','无','1','2','2')
insert into 角色 values('3','总经理审批','吴文华','无','1','3','3')
insert into 角色 values('4','出差申请人','吴文华','无','0','1','1')
insert into 角色 values('4','部分经理审批','王卫','无','1','2','2')
insert into 角色 values('4','财务提备用金','吴文华','无','1','3','3')
insert into 角色 values('5','用车申请人','吴文华','无','0','1','1')
insert into 角色 values('5','部门经理核实','王卫','无','1','2','2')
insert into 角色 values('5','总经理审批','吴文华','无','1','3','3')
insert into 角色 values('6','报销人','吴文华','无','0','1','1')
insert into 角色 values('6','部门经理','吴文华','无','1','2','2')
insert into 角色 values('6','总经理','吴文华','无','1','3','3')
insert into 角色 values('6','财务','吴文华','无','1','4','4')
insert into 角色 values('7','a','吴文华','无','0','1','1')
insert into 角色 values('7','b','王卫','无','1','2','2')
insert into 角色 values('7','c','王卫','无','0','3','3')
insert into 角色 values('8','用车申请人','王卫','无','0','1','1')
insert into 角色 values('8','部门经理核实','吴文华','无','1','2','2')
insert into 角色 values('8','总经理审批','吴文华','无','1','3','3')
insert into 角色 values('9','用车申请','吴文华','无','0','1','1')
insert into 角色 values('9','部门经理审批','王卫','无','0','2','2')
insert into 角色 values('9','车库派车','吴文华','无','1','3','3')
insert into 角色 values('10','用车申请','王卫','无','0','1','1')
insert into 角色 values('10','部门经理审批','王卫','无','0','2','2')
insert into 角色 values('10','车库派车','王卫','无','0','3','3')
insert into 角色 values('12','A1','齐江林','无','0','1','1')
insert into 角色 values('12','A2','齐江林','无','0','2','2')
insert into 角色 values('12','A3','齐江林','无','0','3','3')
insert into 角色 values('12','A4','齐江林','无','0','4','4')
insert into 角色 values('12','A5','齐江林','无','0','5','5')
insert into 角色 values('13','支出人','苏燕','无','0','1','1')
insert into 角色 values('13','会计','齐江林','无','0','2','2')
insert into 角色 values('13','出纳','苏燕','无','0','3','3')

/*  流程输入结束  */