You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
ocr/runstart/doc/sql/admin_oa_insert.sql

138 lines
16 KiB

INSERT INTO S_SYSTEMOPENURL_T(ID,URL,REMARK) VALUES(6000011101, '/flowable-task/app-api/**', '工作流发布');
INSERT INTO S_RESOURCES_T(ID,RESOURCENAME,RPARENTID,ROOTID,RESOURCETYPE,PRIORITYPE,RESOURCE,RESOURCELIST,RESOURCEDESC,ENABLED,RIOCNIMAGE,OTHERSHOW)
VALUES (60000, '流程管理', 0, 0, '0', '1', null, null, '流程管理', '1', 'fa fa-tachometer','0');
INSERT INTO S_RESOURCES_T(ID,RESOURCENAME,RPARENTID,ROOTID,RESOURCETYPE,PRIORITYPE,RESOURCE,RESOURCELIST,RESOURCEDESC,ENABLED,RIOCNIMAGE,OTHERSHOW)
VALUES (6000011,'流程定义',60000,60000, '1', '5','/flow/definitionhtml/tolist','/flow/definition/list','流程定义', '1', 'icon-diamond','0');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (6000011, '103','/flow/definition/deleteFlow','/flow/definition/sav');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (6000011, '104','/flow/definition/flowImg','/flow/definition/flowXML');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (6000011, '109','/flow/definition/deployFlow','/flow/definition/updateState');
INSERT INTO S_RESOURCES_T(ID,RESOURCENAME,RPARENTID,ROOTID,RESOURCETYPE,PRIORITYPE,RESOURCE,RESOURCELIST,RESOURCEDESC,ENABLED,RIOCNIMAGE,OTHERSHOW)
VALUES (6000012,'流程设计',60000,60000, '1', '5','/modeler/index.html','/app/rest/account','流程设计', '1', 'fa fa-sitemap','0');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (6000012, '104','/app/rest/models','/flowable-task/app-api/**');
INSERT INTO S_RESOURCES_T(ID,RESOURCENAME,RPARENTID,ROOTID,RESOURCETYPE,PRIORITYPE,RESOURCE,RESOURCELIST,RESOURCEDESC,ENABLED,RIOCNIMAGE,OTHERSHOW)
VALUES (6000013,'候选组管理',60000,60000, '1', '5','/backstage/oa/userdistionaryHtml/toList','/backstage/oa/userdistionary/list','候选组管理', '1', 'fa fa-group','0');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (6000013, '104','/flow/form/deployForm','/backstage/oa/userdistionary/listnoin');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (6000013, '101','/backstage/oa/userdistionaryHtml/toSave','/backstage/oa/userdistionary/save');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (6000013, '103','/backstage/oa/userdistionary/delmore','/backstage/oa/userdistionary/saveupdate');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (6000013, '104','/backstage/oa/userdistionary/getdata',null);
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (6000013, '1112','/backstage/oa/userdistionary/delmore',null);
INSERT INTO OA_CANDIDATE_T VALUES (60001101, '一级审批');
INSERT INTO OA_CANDIDATE_T VALUES (60001102, '二级审批');
INSERT INTO OA_CANDIDATE_T VALUES (60001103, '最终审批');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600921257, '/ocr/ocrBooknote/add', '个人笔记添加');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600921258, '/ocr/ocrBooknote/query', '个人笔记查看');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928248, '/ocr/ocrUsersearch/list', '个人过滤条件列表');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928259, '/ocr/ocrUsersearch/add', '个人添加过滤条件');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928260, '/ocr/ocrUsersearch/deleteBatch', '个人删除过滤条件');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928261, '/ocr/ocrUsersearch/queryById', '个人查询过滤条件详情');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928262, '/ocr/ocrConfiguration/getConfiguration', '获取配置信息');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928263, '/ocr/ocrSearchmanager/add', '自定义筛选设置');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928264, '/ocr/ocrSearchmanager/query', '自定义筛选设置查询');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928265, '/ocr/ocrPictureclass/rootList', '分类列表,无分页');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928266, '/ocr/ocrPicturetype/rootList', '图片类型列表,无分页');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928267, '/ocr/ocrUpuser/listall', '提报人列表,无分页');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928268, '/ocr/ocrPlan/listall', '任务计划列表,无分页');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928269, '/ocr/ocrPackagetask/upload', '上传参考图');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928270, '/ocr/ocrPicture/list', '图片查询');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928271, '/ocr/ocrPicture/createorder', '一键查重');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928272, '/ocr/ocrPicture/listorder', '工单查询');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928273, '/ocr/ocrPicture/closeorder', '关闭工单');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928274, '/ocr/ocrPackagetask/list', '任务包分页');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928275, '/ocr/ocrPackagetask/listorderbytask', '任务包详情');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928276, '/ocr/ocrPackagetask/orderpass', '设置是否合格状态');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928277, '/ocr/ocrPackagetask/ordertrueorfalse', '设置真假状态');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928278, '/flow/task/listdata', '我的任务审批');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928279, '/flow/task/completeFlow', '审批任务');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928280, '/ocr/ocrUsersearch/collect', '个人过滤条件收藏');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928281, '/ocr/ocrUsersearch/collectreset', '个人过滤条件收藏取消');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928282, '/ocr/ocrUsersearch/reorder', '个人过滤条件排序');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928283, '/ocr/ocrUsersearch/edit', '个人过滤条件修改');
INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196092352600928284, '/ocr/ocrarea/listall', '地区列表');
INSERT INTO `ocr_configuration` VALUES ('1', 'admin', 12345, 'admin', null, 'Y', 'Y', 0, 100, 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
INSERT INTO S_RESOURCES_T(ID,RESOURCENAME,RPARENTID,ROOTID,RESOURCETYPE,PRIORITYPE,RESOURCE,RESOURCELIST,RESOURCEDESC,ENABLED,RIOCNIMAGE,OTHERSHOW)
VALUES (160000, 'OCR管理', 0, 0, '0', '1', null, null, 'OCR管理', '1', 'fa fa-file-picture-o','0');
INSERT INTO S_RESOURCES_T(ID,RESOURCENAME,RPARENTID,ROOTID,RESOURCETYPE,PRIORITYPE,RESOURCE,RESOURCELIST,RESOURCEDESC,ENABLED,RIOCNIMAGE)
VALUES (1600001,'配置管理',160000,160000, '1', '5','/backstage/oa/ocrconfigurationHtml/toList','/ocr/ocrConfiguration/list','配置管理', '1', 'fa fa-hourglass-half');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600001, '101','/backstage/oa/ocrconfigurationHtml/toSave','/ocr/ocrConfiguration/save');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600001, '102','/backstage/oa/ocrconfigurationHtml/toEdit','/ocr/ocrConfiguration/edit');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600001, '103','/ocr/ocrConfiguration/delmore',null);
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600001, '104','/ocr/ocrConfiguration/getdata',null);
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600001, '111','/backstage/oa/ocrconfigurationHtml/toEdit','/ocr/ocrConfiguration/edit');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600001, '112','/ocr/ocrConfiguration/delmore',null);
INSERT INTO S_RESOURCES_T(ID,RESOURCENAME,RPARENTID,ROOTID,RESOURCETYPE,PRIORITYPE,RESOURCE,RESOURCELIST,RESOURCEDESC,ENABLED,RIOCNIMAGE)
VALUES (1600002,'图片分类管理',160000,160000, '1', '5','/backstage/oa/ocrpictureclassHtml/toList','/ocr/ocrPictureclass/list','图片分类管理', '1', 'fa fa-folder');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600002, '101','/backstage/oa/ocrpictureclassHtml/toSave','/ocr/ocrPictureclass/save');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600002, '102','/backstage/oa/ocrpictureclassHtml/toEdit','/ocr/ocrPictureclass/edit');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600002, '103','/ocr/ocrPictureclassl/delmore',null);
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600002, '104','/ocr/ocrPictureclassl/getdata',null);
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600002, '111','/backstage/oa/ocrpictureclassHtml/toEdit','/ocr/ocrPictureclassl/edit');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600002, '112','/ocr/ocrPictureclassl/delmore',null);
INSERT INTO S_RESOURCES_T(ID,RESOURCENAME,RPARENTID,ROOTID,RESOURCETYPE,PRIORITYPE,RESOURCE,RESOURCELIST,RESOURCEDESC,ENABLED,RIOCNIMAGE)
VALUES (1600003,'图片类型管理',160000,160000, '1', '5','/backstage/oa/ocrpicturetypeHtml/toList','/ocr/ocrPicturetype/list','图片类型管理', '1', 'fa fa-navicon');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600003, '101','/backstage/oa/ocrpicturetypeHtml/toSave','/ocr/ocrPicturetype/save');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600003, '102','/backstage/oa/ocrpicturetypeHtml/toEdit','/ocr/ocrPicturetype/edit');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600003, '103','/ocr/ocrPicturetype/delmore',null);
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600003, '104','/ocr/ocrPicturetype/getdata',null);
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600003, '111','/backstage/oa/ocrpicturetypeHtml/toEdit','/ocr/ocrPicturetype/edit');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600003, '112','/ocr/ocrPicturetype/delmore',null);
INSERT INTO S_RESOURCES_T(ID,RESOURCENAME,RPARENTID,ROOTID,RESOURCETYPE,PRIORITYPE,RESOURCE,RESOURCELIST,RESOURCEDESC,ENABLED,RIOCNIMAGE)
VALUES (1600004,'图片地区管理',160000,160000, '1', '5','/backstage/oa/ocrareaHtml/toList','/ocr/ocrarea/list','图片地区管理', '1', 'fa fa-map-marker');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600004, '101','/backstage/oa/ocrareaHtml/toSave','/ocr/ocrarea/save');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600004, '102','/backstage/oa/ocrareaHtml/toEdit','/ocr/ocrarea/edit');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600004, '103','/ocr/ocrarea/delmore',null);
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600004, '104','/ocr/ocrarea/getdata',null);
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600004, '111','/backstage/oa/ocrareaHtml/toEdit','/ocr/ocrarea/edit');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600004, '112','/ocr/ocrarea/delmore',null);
INSERT INTO S_RESOURCES_T(ID,RESOURCENAME,RPARENTID,ROOTID,RESOURCETYPE,PRIORITYPE,RESOURCE,RESOURCELIST,RESOURCEDESC,ENABLED,RIOCNIMAGE)
VALUES (1600005,'计划管理',160000,160000, '1', '5','/backstage/oa/ocrplanHtml/toList','/ocr/ocrPlan/list','计划管理', '1', 'fa fa-pencil-square-o');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600005, '101','/backstage/oa/ocrplanHtml/toSave','/ocr/ocrPlan/save');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600005, '102','/backstage/oa/ocrplanHtml/toEdit','/ocr/ocrPlan/edit');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600005, '103','/ocr/ocrPlan/delmore',null);
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600005, '104','/ocr/ocrPlan/getdata',null);
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600005, '111','/backstage/oa/ocrplanHtml/toEdit','/ocr/ocrPlan/edit');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600005, '112','/ocr/ocrPlan/delmore',null);
-- INSERT INTO S_RESOURCES_T(ID,RESOURCENAME,RPARENTID,ROOTID,RESOURCETYPE,PRIORITYPE,RESOURCE,RESOURCELIST,RESOURCEDESC,ENABLED,RIOCNIMAGE)
-- VALUES (1600006,'提报人管理',160000,160000, '1', '5','/backstage/jifen/ocrupuserHtml/toList','/backstage/jifen/ocrupuser/list','提报人管理', '1', 'icon-diamond');
-- INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600006, '101','/backstage/jifen/ocrupuserHtml/toSave','/backstage/jifen/ocrupuser/save');
-- INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600006, '102','/backstage/jifen/ocrupuserHtml/toEdit','/backstage/jifen/ocrupuser/edit');
-- INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600006, '103','/backstage/jifen/ocrupuser/delmore',null);
-- INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600006, '104','/backstage/jifen/ocrupuser/getdata',null);
-- INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600006, '111','/backstage/jifen/ocrupuserHtml/toEdit','/backstage/jifen/ocrupuser/edit');
-- INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600006, '112','/backstage/jifen/ocrupuser/delone',null);
-- INSERT INTO S_BACKSTAGEOPENURL_T(ID,URL,REMARK) VALUES(1196037754729197568, '/backstage/jifen/ocrupuser/getdata', '获取对象信息');
INSERT INTO S_RESOURCES_T(ID,RESOURCENAME,RPARENTID,ROOTID,RESOURCETYPE,PRIORITYPE,RESOURCE,RESOURCELIST,RESOURCEDESC,ENABLED,RIOCNIMAGE)
VALUES (1600007,'项目管理',160000,160000, '1', '5','/backstage/oa/categoryHtml/toList','/backstage/oa/category/list','项目管理', '1', 'fa fa-recycle');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600007, '101','/backstage/oa/categoryHtml/toSave','/backstage/oa/category/save');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600007, '102','/backstage/oa/categoryHtml/toEdit','/backstage/oa/category/edit');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600007, '103','/backstage/oa/category/delmore',null);
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600007, '104','/backstage/oa/category/getdata','/backstage/oa/category/update');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600007, '111','/backstage/oa/categoryHtml/toEdit','/backstage/oa/category/edit');
INSERT INTO S_RESOURCEMETHOD_T (RESOURCEID,METHODID,RESOURCEBEFOR,RESOURCEAFTER) VALUES (1600007, '112','/backstage/oa/category/delmore',null);