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);