projects
/
gdymtsceshi


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149
							alter table x_email modify (InfoContent  VARCHAR(2000));


---知识库添加 20220430
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
VALUES ('09','知识库','0','/0/09/','0','','','false','true','complaint.repository.tree','menu','8.00');
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
VALUES ('0901','知识浏览','09','/0/09/0901/','1','/myconsole/complaint/repository/index1','','true','true','complaint.repository.index1','menu','3.00');
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
VALUES ('0902','知识维护','09','/0/09/0902/','1','/myconsole/webinfo','','true','true','work.web.weblist','menu','1.00');
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
VALUES ('090201','新建','0902','/0/09/0902/090201','2','/myconsole/webinfo/saveOrUpdate','','true','true','work.web.insert','function','1.00');
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
VALUES ('090202','编辑','0902','/0/09/0902/090202','2','/myconsole/webinfo/saveOrUpdate','','true','true','work.web.update','function','2.00');
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
VALUES ('090203','发布','0902','/0/09/0902/090203','2','/myconsole/webinfo/release','','true','true','work.web.release','function','3.00');
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
VALUES ('090204','撤稿','0902','/0/09/0902/090204','2','/myconsole/webinfo/setWithdraw','','true','true','work.web.withdraw','function','4.00');
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
VALUES ('090205','删除','0902','/0/09/0902/090205','2','/myconsole/webinfo/saveOrUpdate','','true','true','work.web.delete','function','5.00');
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 

INSERT INTO t_menu (KeyID,Menuname,Parentid,Insertuserid,Inserttime,Updateuserid,Updatetime,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
VALUES ('0903', '文件夹目录维护', '09', NULL, NULL, NULL, NULL, '/0/09/0903/', '2', '/myconsole/column', NULL, 'true', 'true', 'web.column.columnlist', 'menu', '2.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) 
VALUES ('090301', '添加', '0903', NULL, NULL, NULL, NULL, '/0/09/0903/090301/', '3', '/myconsole/column/saveOrUpdate', NULL, 'true', 'true', 'web.column.insert', 'function', '1.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) 
VALUES ('090302', '编辑', '0903', NULL, NULL, NULL, NULL, '/0/09/0903/090302/', '3', '/myconsole/column/saveOrUpdate', NULL, 'true', 'true', 'web.column.update', 'function', '2.00');
INSERT INTO t_menu (KeyID, Menuname, Parentid, Insertuserid, Inserttime, Updateuserid, Updatetime, Treepath, Treelevel, Menuurl, Menudesc, Isleaf, IsShow, MenuID, SType, SortID) 
VALUES ('090303', '删除', '0903', NULL, NULL, NULL, NULL, '/0/09/0903/090303/', '3', '/myconsole/column/saveOrUpdate', NULL, 'true', 'true', 'web.column.delete', 'function', '3.00');


create table X_WEBCOLLECTION
(
  keyid      VARCHAR2(32) not null,
  userid     VARCHAR2(32),
  webkeyid   VARCHAR2(32),
  columnid   VARCHAR2(32),
  tstate     VARCHAR2(32),
  title      VARCHAR2(500),
  recordtime VARCHAR2(19),
  isornot    VARCHAR2(10)
)


---2022-05-02
alter table x_appeal add (GroupType    VARCHAR(20));
alter table x_preinflow add (NoNormalPay    int);

alter table x_result add (ReturnAudioNo    VARCHAR(40)); 


-- **************************************************
-- Name:        x_fund
-- Purpose:     基金总额表
-- Deviser:     韩林平
-- Devistime:   2022-05-01
-- **************************************************
drop table x_fund;
create table x_fund
(
   OrgID                VARCHAR(255)    not null, -- 机构编号
   OrgName              VARCHAR(255)            , -- 机构名称
   FundMoney            DECIMAL(10,2)           , -- 基金余额
   constraint PK_x_fund primary key (OrgID)
);

-- **************************************************
-- Name:        x_fundrecharge
-- Purpose:     基金充值表
-- Deviser:     韩林平
-- Devistime:   2022-05-01
-- **************************************************
--drop table x_fundrecharge;
create table x_fundrecharge
(
   KeyID                VARCHAR(60)     not null, -- 数据编号
   OrgID                VARCHAR(255)            , -- 机构编号
   OrgName              VARCHAR(255)            , -- 机构名称
   FundMoney            DECIMAL(10,2)           , -- 充值金额
   FundYear             VARCHAR(4)              , -- 基金所属年份
   RecordUserID         VARCHAR(50)             , -- 充值人编号 
   RecordUserName       VARCHAR(50)             , -- 充值人名称
   RecordTime           VARCHAR(19)             , -- 充值时间   存贮到年月日小时秒分 
   constraint PK_x_fundrecharge primary key (KeyID)
);

-- **************************************************
-- Name:        x_funduse
-- Purpose:     基金使用表
-- Deviser:     韩林平
-- Devistime:   2022-05-01
-- **************************************************
--drop table x_funduse;
create table x_funduse
(
   KeyID                VARCHAR(60)     not null, -- 数据编号
   AppealID             VARCHAR(40)             , -- 事项表ID
   TName                VARCHAR(50)             , -- 客诉人姓名
   SerialNumber         VARCHAR(60)             , -- 客诉件流水号 （事项信息冗余）
   AppealDate           VARCHAR(19)             , -- 投诉日期 存贮到年月日
   OrgID                VARCHAR(255)            , -- 机构编号
   OrgName              VARCHAR(255)            , -- 机构名称
   FundMoney            DECIMAL(10,2)           , -- 使用金额
   FundYear             VARCHAR(4)              , -- 基金所属年份
   RecordUserID         VARCHAR(50)             , -- 使用人编号 
   RecordUserName       VARCHAR(50)             , -- 使用人名称
   RecordTime           VARCHAR(19)             , -- 使用时间   存贮到年月日小时秒分 
   constraint PK_x_funduse primary key (KeyID)
);


INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
       VALUES ('0611','基金登记','06','/0/01/0611/','1','/myconsole/complaint/register/money','','true','true','complaint.register.money','menu','11.00');
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
      VALUES ('0612','基金查询','06','/0/01/0612/','1','/myconsole/complaint/transact/moneyList','','true','true','complaint.transact.moneyList','menu','12.00');
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
      VALUES ('0613','基金使用查詢','06','/0/01/0613/','1','/myconsole/complaint/transact/moneyListUse','','true','true','complaint.transact.moneyListUse','menu','13.00');
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
      VALUES ('0614','基金充值查询','06','/0/01/0614/','1','/myconsole/complaint/transact/moneyListAdd','','true','true','complaint.transact.moneyListAdd','menu','14.00');

 
---2022-05-05
alter table x_appeal add (CurDoUserInfo    VARCHAR(500));
alter table x_result add (CheckApproveInfo    VARCHAR(200)); 
alter table x_result add (CheckApproveResult    VARCHAR(20)); 
alter table x_result add (CheckApproveTime    VARCHAR(19)); 

---2022-05-07
INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
        VALUES ('0605','默认办理规则','06','/0/06/0605/','0','/myconsole/complaint/rule/defaultdo','','true','true','complaint.rule.defaultdo','menu','5.00');

delete from dic_complainttype;
insert into  dic_complainttype values ('01','01','一般投诉','','0','false',1.0,1,'/0/01/','admin','超级管理员','2017-01-31');
insert into  dic_complainttype values ('02','02','疑难投诉','','0','true',2.0,1,'/0/02/','admin','超级管理员','2017-01-31');
insert into  dic_complainttype values ('03','03','重大投诉','','0','true',3.0,1,'/0/03/','admin','超级管理员','2017-01-31');

alter table x_appeal add (AskMoney    DECIMAL(10,2)); 
alter table x_transact add (AskMoney    DECIMAL(10,2)); 

---2022-05-10
alter table x_result add (MediateUseDate    int); 

INSERT INTO t_menu (KeyID,Menuname,Parentid,Treepath,Treelevel,Menuurl,Menudesc,Isleaf,IsShow,MenuID,SType,SortID) 
VALUES ('0304','核查件查询','03','/0/03/0304/','1','/myconsole/complaint/list/check','','true','true','complaint.list.check','menu','1.5');