📄 init.orasql
字号:
insert into T_KBS_CONSULTITEM (CITYID, SERVERID, ITEMID, ITEMNAME, ITEMTYPE, PARENTDIR, STAFFNO, HOTFLAG, DEFAULTFLAG, RECORDFILENAME, LASTMODIFYDATE, LASTFTPDATE, MODIFYFLAG, FILESIZE, FILEEXISTFLAG, BEGINTIME, ENDTIME, MAINFLAG, CHANNELID, PASTHANDLEMODE, DEFAULTORDERMODE, ITEMCOUNT, AUTHKEY, CLICKNUM, CUSTOMGRADE, ENABLEFAX, ENABLEEMAIL, ENABLEWEB)
values ('00', 0, '003', '业务代表', 0, '/', '101', 0, 0, null, to_date('24-09-2003', 'dd-mm-yyyy'), to_date('25-09-2003', 'dd-mm-yyyy'), 0, 0, 1, to_date('24-09-2003', 'dd-mm-yyyy'), to_date('30-09-2003', 'dd-mm-yyyy'), 1, null, 0, 2, 2, '11111111111111111111', 4, 0, 1, 1, 1);
insert into t_AGT_TestDegree(DegreeID,DegreeName) values(1,'初级');
insert into t_AGT_TestDegree(DegreeID,DegreeName) values(2,'中级');
insert into t_AGT_TestDegree(DegreeID,DegreeName) values(3,'高级');
insert into t_AGT_TestMeans(MeansID,MeansName) values(1,'理论测试');
insert into t_AGT_TestMeans(MeansID,MeansName) values(2,'案例分析');
insert into t_AGT_TestMeans(MeansID,MeansName) values(3,'情景模拟');
insert into t_AGT_TestMeans(MeansID,MeansName) values(4,'模拟上机');
insert into t_AGT_TestType(TypeID,TypeName,AddPagePath,ModPagePath) values(1,'判断题','/agt/testman/TestAddVerdict.jsp','modifyverdict');
insert into t_AGT_TestType(TypeID,TypeName,AddPagePath,ModPagePath) values(2,'单选题','/agt/testman/TestAddSingle.jsp','modifysingle');
insert into t_AGT_TestType(TypeID,TypeName,AddPagePath,ModPagePath) values(3,'多选题','/agt/testman/TestAddMany.jsp','modifymany');
insert into t_AGT_TestType(TypeID,TypeName,AddPagePath,ModPagePath) values(4,'填空题','/agt/testman/TestAddVacancy.jsp','modifyvacancy');
insert into t_AGT_TestType(TypeID,TypeName,AddPagePath,ModPagePath) values(5,'问答题','/agt/testman/TestAddQuestion.jsp','modifyquestion');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('01','试题类别','试题类别说明','00');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('02','课程类别','课程类别说明','00');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('03','试卷类别','试卷类别说明','00');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('04','考试类别','考试类别说明','00');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('05','资料类别','资料类别说明','00');
--权限初始数据---------
delete t_AGT_Auth;
insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('01','0','业务代表档案管理','业务代表档案管理','1');
insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('02','0','培训档案管理','培训档案管理','1');
insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('03','0','教师档案管理','教师档案管理','1');
insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('04','0','制定学习计划','制定学习计划','1');
insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('05','0','综合考评','综合考评','1');
insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('06','0','试题管理','试题管理','1');
insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('07','0','考试管理','考试管理','1');
insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('08','0','评阅考卷','评阅考卷','1');
insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('09','0','类别管理','类别管理','1');
insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('10','0','配置管理','配置管理','1');
insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('11','0','课程管理','课程管理','1');
insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('12','0','制定日程','制定日程','1');
insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('00','0','基本权限','基本权限','1');
----------归为基本权限----------------
--insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('13','0','在线考试','在线考试','1');
--insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('14','0','个人培训档案','个人培训档案','1');
--insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('15','0','个人学习计划','个人学习计划','1');
--insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('16','0','课程学习','课程学习','1');
--insert into t_AGT_Auth(AuthID,SuperID,AuthName,Description,ItemFlag) values('17','0','我的日程','我的日程','1');
----------归为基本权限----------------
-------------菜单数据---------
delete t_AGT_Menu;
set define off;
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M01','档案管理','M0','1','','','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0101','个人档案','M01','2','/TrnmngAction.do?operatorflag=TRNMNG_QUERYDETAIL1','/agt/public/images/dagl_xzda.gif','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0102','业务代表档案','M01','2','','/agt/public/images/dagl_cxda.gif','01');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M010201','新增档案','M0102','3','/AgtmngStaffAction.do?operatorflag=AGTMNG_QUERY_TOBEADD','','01');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M010202','查询档案','M0102','3','/agt/agtmng/agtmngstaffquery.jsp','','01');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M010203','查询操作日志','M0102','3','/agt/agtmng/querylog.jsp','','01');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0103','培训档案','M01','2','','/agt/public/images/xxjh_bfkjh.gif','02');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M010301','新增档案','M0103','3','/agt/trnmng/newtrnarchive.jsp','','02');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M010302','查询档案','M0103','3','/agt/trnmng/querytrnstaff.jsp','','02');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0104','教师档案','M01','2','','/agt/public/images/xxjh_dqzrrjh.gif','03');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M010401','新增档案','M0104','3','/agt/teachmng/newteacher.jsp','','03');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M010402','查询档案','M0104','3','/agt/teachmng/queryteacher.jsp','','03');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M04','学习计划','M0','1','','','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0401','计划管理','M04','2','','/agt/public/images/ksgl_cl_cllb.gif','04');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M040101','制订计划','M0401','3','/agt/planmng/newplan.jsp','','04');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M040102','计划查询','M0401','3','/agt/planmng/queryplan.jsp','','04');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M040103','未下发计划','M0401','3','/PlanmngAction.do?operatorflag=PLANMNG_QUERY_LIST&status=0','','04');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M040104','未被反馈计划','M0401','3','/PlanmngAction.do?operatorflag=PLANMNG_QUERY_SYNLIST1&status=1','','04');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M040105','被反馈计划','M0401','3','/PlanmngAction.do?operatorflag=PLANMNG_QUERY_SYNLIST1&status=2','','04');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0402','个人学习计划','M04','2','','rcgl_wdrc','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M040201','当前责任人计划','M0402','3','/PlanmngAction.do?operatorflag=PLANMNG_QUERY_RESPONSELIST','','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M040202','计划查询','M0402','3','/agt/planmng/queryplan.jsp','','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M040203','反馈计划','M0402','3','/PlanmngAction.do?operatorflag=PLANMNG_QUERY_SYNLIST2&status=1','','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M040204','已反馈的接收计划','M0402','3','/PlanmngAction.do?operatorflag=PLANMNG_QUERY_SYNLIST2&status=2','','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M05','综合考评','M0','1','','','05');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0501','规则新增','M05','2','/agt/synevaluate/newrule.jsp','/agt/public/images/ksgl_ks_scx.gif','05');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0502','规则查询','M05','2','/agt/synevaluate/queryrule.jsp','/agt/public/images/ksgl_sj_lbcx.gif','05');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0503','计算评分','M05','2','/agt/synevaluate/doevaluate.jsp','/agt/public/images/ksgl_sj_fbsjlb.gif','05');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0504','查询评分','M05','2','/agt/synevaluate/queryresult.jsp','/agt/public/images/xxjh_jhcx.gif','05');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M06','试题管理','M0','1','','','06');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0601','录入试题','M06','2','/agt/testman/TestAddEditor.jsp','/agt/public/images/ksgl_sj_scsj.gif','06');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0602','查询试题','M06','2','/agt/testman/TestQueryInput.jsp','/agt/public/images/ksgl_ks_cgx.gif','06');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M07','考试管理','M0','1','','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0701','策略','M07','2','','/agt/public/images/xxjh_wbfkjh.gif','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070101','增加策略','M0701','3','/agt/policy/PolicyAddInput.jsp','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070102','策略列表','M0701','3','/PolicyMan.do?opeType=4','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070103','查询策略','M0701','3','/agt/policy/PolicyQueryInput.jsp','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0702','试卷','M07','2','','/agt/public/images/pzgl_pzfwq.gif','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070201','生成试卷','M0702','3','/ExamPaperMan.do?opeType=1','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070202','发布试卷列表','M0702','3','/ExamPaperMan.do?opeType=6&statusTerm=1','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070203','按类别查找','M0702','3','/agt/public/jsp/QueryByClass.jsp?classID=03&pagePath=/ExamPaperMan.do?opeType=6','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070204','按条件查找','M0702','3','/agt/epaper/EPaperQueryInput.jsp','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0703','考试','M07','2','','/agt/public/images/stgl_lrsj.gif','05');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070301','草稿箱','M0703','3','/ExamMan.do?opeType=2','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070302','审查箱','M0703','3','/ExamMan.do?opeType=3','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070303','审批箱','M0703','3','/ExamMan.do?opeType=4','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070304','增加考试','M0703','3','/agt/exam/ExamAddInput.jsp','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070305','发布考试列表','M0703','3','/ExamMan.do?opeType=13&stateTerm=5','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070306','按类别查找','M0703','3','/agt/public/jsp/QueryByClass.jsp?classID=04&pagePath=/ExamMan.do?opeType=13','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M070307','按条件查找','M0703','3','/agt/exam/ExamQueryInput.jsp','','07');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M08','评阅考卷','M0','1','','','08');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0801','答卷列表','M08','2','/ScoreMan.do?opeType=1','/agt/public/images/pykj_djlb.gif','08');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -