北京华夏安泰技术论坛

 找回密码
 立即注册

扫一扫,访问微社区

QQ登录

只需要一步,快速开始

只需一步,快速开始

搜索
热搜: 活动 交友 discuz
查看: 196|回复: 4

首页待办事项脚本

[复制链接]

13

主题

214

帖子

882

积分

内部工作人员

积分
882
发表于 2018-9-3 12:31:41 | 显示全部楼层 |阅读模式
首页待办事项脚本, 如果前台缺少某待办,请在此查找

//支出

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('0e46acd2-ac2f-4f22-9e50-046822f2fc26','业务申请单','queryGtasksController/findPayoutApplicationTasks.do',1);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('asdfh4dffg','借款单','queryGtasksController/findPayOutLoanTasks.do',3);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('3eabe7ca-7fae-412e-b316-41cd75345bfc','报销单','queryGtasksController/findPayOutPaymentTasks.do',4);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('3b779903-e44b-4381-bae6-5bbf8cc382a6','待执行申请审批单','queryGtasksController/findPayoutApplicationApproveTasks.do',2);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('89cb2d6b-fe6a-4023-8c26-d149aba31040','待借款/报销审批单','queryGtasksController/findPayoutLoanAndPaymentApproveTasks.do',5);

commit;

// 普通采购

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('361da74e-0bb5-4755-a36d-271c765f5ff8','采购登记','queryGtasksController/findPurchaseRegisterTask.do',13);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('030e1b65-fe05-457c-89e3-51bf0f4b6984','采购审批','queryGtasksController/findProcurementApprovalMatters.do',14);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('8c7d82c4-4b12-4bf2-b742-0511f1fdec91','供应商抽取',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('d17d82a9-2ca9-48d0-9aad-8696bf4b0619','代理机构抽取',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('722f9181-5a4f-4fbf-aa00-30a9f2ec9035','中标待登记',null,12);

commit;


// 广西采购

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('65c99a6e-b94e-401e-9408-9f32202ac710','采购申请审批','queryGtasksController/findPurchaseRequisitionApprovalTask.do',31);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('22e990f7-ddac-4f74-848c-68b7b12e4f19','采购项目审核审批','queryGtasksController/findPurchaseProjectApprovalTask.do',32);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('912e1236-7755-4ca1-851f-d90d3ffd4187','采购文件审核审批','queryGtasksController/findPurchaseFileApprovalTask.do',33);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('bb31f487-17f4-4d15-a36a-d822ed545304','采购评标活动审批','queryGtasksController/findPurchaseBidApprovalTask.do',34);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('5ffbab24-f667-4c92-a602-30b27b634abd','采购中标登记审批','queryGtasksController/findPurchaseBidRegistrationApprovalTask.do',35);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('3421c807-1a4f-4eb5-be79-1bea6286acad','采购申请',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('e97a850a-194d-488d-86c8-68803e20b9ee','采购项目审核待填单',null,14);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('77e81384-6aec-4c13-9220-6d9187514516','中标登记审核待填单',null,13);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('e953ebe3-bec9-499b-a3e9-1769ecd420ef','采购文件审核待填单',null,15);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('4de6eff7-c2d9-492e-a608-171abac788a5','评标活动审核待填单',null,15);

commit;





回复

使用道具 举报

13

主题

214

帖子

882

积分

内部工作人员

积分
882
 楼主| 发表于 2018-9-3 12:32:07 | 显示全部楼层
// 资产

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('20944dab-939a-4768-afe5-4809e366a682','资产借用审批',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('d893c653-3307-4de0-aec9-f3774b121948','资产入库审批',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('a450fca7-c447-4b9d-8ffc-c75926ded1e0','资产调配审批',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('016d423d-cb3f-4020-88c3-d244a0246b4c','资产报损审批',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('c558c782-dcd1-4209-893c-001c991ae762','资产报废审批',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('7aed6a38-fc34-4e87-9fd7-63247a1465c9','资产退库审批',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('6198f22e-ae54-4ebb-82db-0ca22b130317','资产领用审批',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('fc548b39-cdd8-4b34-a544-1867ce9fc916','资产归还审批',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('8845b154-eb87-4b12-8835-2c81f42069fb','资产领用',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('da048949-bfd8-4f18-957c-8376eae35c6b','资产入库',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('0bf69466-707f-463e-98e5-c552a8085d0a','资产报废',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('741a076f-604c-4564-9f0b-c2d11588229b','资产归还',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('6c191959-7b56-43e6-bff1-0b24061ec0d3','资产调配',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('ce849bdd-a75d-4b21-9227-f14c438d0423','资产借用',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('4185e853-824b-41b2-8b75-55a8412f58ce','资产退库',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('c36a274c-ca90-4434-99a2-7695923d2473','资产报损',null,null);

commit;
回复

使用道具 举报

13

主题

214

帖子

882

积分

内部工作人员

积分
882
 楼主| 发表于 2018-9-3 12:35:34 | 显示全部楼层
// 合同

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('8c68a318-1fb9-4aa0-8bdb-5e3bd821ff73','合同登记','queryGtasksController/findContractTasks.do',11);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('63289d62-648e-4729-9863-dee710f691f2','合同审核','queryGtasksController/findContractApproveTasks.do',12);

//易耗品
Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('50b5d4cc-21e2-4010-b42e-48d10cbbe5ae','易耗品申领',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('1332737e-4090-4c83-9c33-5027fcde6819','易耗品申领审批',null,null);

// 实有收入
Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('765c76e6-d3bc-4f45-a243-a2dab6215f8d','实有收入登记',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('aa08f492-29c5-45aa-bab1-46a72366503e','实有收入登记审批',null,null);

// 合同申请
Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('944954b2-9e23-4585-bb14-aa7924b24cee','合同申请',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('f0e45291-a1ce-4ecc-b3e8-40d402904851','合同申请审批',null,null);

// 收入合同审批
Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('4474f2e3-d0af-4d15-8c08-bbf16d7cdf5e','收入合同审批',null,null);

Insert into SYS_BACKLOG (MENU_ID,BUSINESS_NAME,ADDRESSEE,TASK_INDEX) values ('9393f9a1-941d-476a-b831-d94ea9c04116','收入合同申请',null,null);


commit;
回复

使用道具 举报

2

主题

24

帖子

104

积分

内部工作人员

积分
104
发表于 2018-9-6 10:45:29 | 显示全部楼层
//合同验收申请登记
insert into SYS_BACKLOG(MENU_ID,BUSINESS_NAME) VALUES ('37e56b88-e335-44ea-b8bd-f545a8de53d4','合同验收申请登记');
//合同验收申请审批
insert into SYS_BACKLOG(MENU_ID,BUSINESS_NAME) VALUES ('9eacc97d-9603-4342-977f-2d0fa905dca4','合同验收申请审批');
//合同验收书登记
insert into SYS_BACKLOG(MENU_ID,BUSINESS_NAME) VALUES ('8332527b-8274-4091-8d49-175542332576','合同验收书登记');
//合同验收书审批
insert into SYS_BACKLOG(MENU_ID,BUSINESS_NAME) VALUES ('29b813e2-51a8-4317-af5a-a4e7a0aeac91','合同验收书审批');

commit;
回复

使用道具 举报

13

主题

214

帖子

882

积分

内部工作人员

积分
882
 楼主| 发表于 2018-9-6 16:19:14 | 显示全部楼层
添加用车申请待办事项
INSERT INTO SYS_BACKLOG (MENU_ID,BUSINESS_NAME) VALUES ('0adee01b-8245-47fa-a50a-de0927e79647','用车申请');
COMMIT;
添加用车用车审批待办事项
INSERT INTO SYS_BACKLOG (MENU_ID,BUSINESS_NAME) VALUES ('1067ef5d-49c5-4025-9c90-1576c6655b2a','用车审批');
COMMIT;
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册  

本版积分规则


小黑屋|手机版|Archiver|北京华夏安泰技术论坛  

GMT+8, 2019-3-20 09:52 , Processed in 0.093767 second(s), 23 queries .

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表