功能_20161219_TA4_开通统一业绩提成自营账户自动强赎功能

--**************************************************************************************************
--脚本功能:TA4.0系统 开通统一业绩提成自营账户自动强制赎回功能
--特殊说明:
--生效版本:
-- 1. 20140303Build，版本，开始生效
--注意事项:
--修改记录:
--**************************************************************************************************

INSERT INTO TOPERCONFIG(C_CALLNO,C_OPERTYPE,L_NO,L_GROUPNO,C_GRPLASTSTEP,C_SVCNAME,C_TABLENAME0,C_TABLENAME1,C_TABLE1TYPE,L_CONCURRENT,C_BUSINFLAG,C_DEALED,C_CAPTION,C_BUSINFLAGS)
VALUES('UniteDeduct','5',51,51,'1',NULL,'TREQUEST','P_DEAL','1',NULL,NULL,'0',NULL,NULL);
INSERT INTO TOPERCONFIG(C_CALLNO,C_OPERTYPE,L_NO,L_GROUPNO,C_GRPLASTSTEP,C_SVCNAME,C_TABLENAME0,C_TABLENAME1,C_TABLE1TYPE,L_CONCURRENT,C_BUSINFLAG,C_DEALED,C_CAPTION,C_BUSINFLAGS)
VALUES('UniteDeduct','6',52,52,'1','HS_MACCO_REDEEM',NULL,NULL,NULL,1,NULL,'0',NULL,NULL);
INSERT INTO TOPERCONFIG(C_CALLNO,C_OPERTYPE,L_NO,L_GROUPNO,C_GRPLASTSTEP,C_SVCNAME,C_TABLENAME0,C_TABLENAME1,C_TABLE1TYPE,L_CONCURRENT,C_BUSINFLAG,C_DEALED,C_CAPTION,C_BUSINFLAGS)
VALUES('UniteDeduct','3',53,53,'1',NULL,'TREQUEST','P_DEAL','1',NULL,'03','0',NULL,NULL);
INSERT INTO TOPERCONFIG(C_CALLNO,C_OPERTYPE,L_NO,L_GROUPNO,C_GRPLASTSTEP,C_SVCNAME,C_TABLENAME0,C_TABLENAME1,C_TABLE1TYPE,L_CONCURRENT,C_BUSINFLAG,C_DEALED,C_CAPTION,C_BUSINFLAGS)
VALUES('UniteDeduct','9',54,54,'1',NULL,NULL,NULL,NULL,0,'03','0','赎回准备明细数据',NULL);
INSERT INTO TOPERCONFIG(C_CALLNO,C_OPERTYPE,L_NO,L_GROUPNO,C_GRPLASTSTEP,C_SVCNAME,C_TABLENAME0,C_TABLENAME1,C_TABLE1TYPE,L_CONCURRENT,C_BUSINFLAG,C_DEALED,C_CAPTION,C_BUSINFLAGS)
VALUES('UniteDeduct','6',55,55,'1','HS_REDEEM',NULL,NULL,NULL,0,'03','0','统一业绩提成自营账户强制赎回','03');

insert into tdictionary (L_KEYNO, C_KEYVALUE, C_CAPTION, C_MODIFY, C_MEMO, C_ENGLISH)
values (1080, 'SELFACCO', '统一业绩提成自营账户强赎', '1', '', '');

delete from tqueryfieldvalue where c_code = '2470';
insert into tqueryfieldvalue (C_CODE, C_TYPE, C_VALUE, C_FIELDNAME)
select '2470', '2', '0:不赎回;1:全部赎回;2:赎回业绩提成强增的份额', null
from dual a
where upper((select b.c_value from tsysparameter b where b.c_item='DatabaseVer')
||(select b.c_value from tsysparameter b where b.c_item='PatchVer')
) < upper('20161010Sp2');

insert into tqueryfieldvalue (C_CODE, C_TYPE, C_VALUE, C_FIELDNAME)
select '2470', '2', '0:不赎回;1:当日全部赎回;2:当日赎回业绩提成强增的份额;3:次日全部赎回;4:次日赎回业绩提成强增的份额', null
from dual a
where upper((select b.c_value from tsysparameter b where b.c_item='DatabaseVer')
||(select b.c_value from tsysparameter b where b.c_item='PatchVer')
) >= upper('20161010Sp2');

delete from tinfomginterface t1 where t1.c_infoname = 'PROFITPROJ' and t1.c_fieldname in ('C_MGRACCOSHARESDEALTYPE','F_FIXEDSTANDARDNET','F_HWCMPNET');
insert into tinfomginterface (C_INFONAME, C_FIELDNAME, C_DESCRIBE, C_TYPE, C_VALUEBOUND, C_VALUE, C_SHOWTITLE, C_SHOWSUBTITLE, L_ORDER, C_MODIFY, C_CRYPTFLAG, C_FULLDESCRIBE, C_ISNULL, D_ADDDATE, L_SHOWTITLENO, L_SHOWSUBTITLENO, L_HEADWIDTH, C_SHOWHEAD, L_LEFT, L_CONTROLLEFT, L_CONTROLWIDTH, L_COLCOUNT, C_QUERYNAME, C_ISQUERY, C_CODE, C_BATCHMODIFYFLAG, C_KEYFIELDFLAG, C_DEPENDSYSPARAMETER, C_DEPENDTACODE)
values ('PROFITPROJ', 'C_MGRACCOSHARESDEALTYPE', '自营账户份额赎回处理方式', '1', '', '0', '业绩提成方案设置', '', 340, '1', '0', '自营账户份额赎回处理方式', '1', '', 1, 101, 120, '1', 400, 155, 215, 2, 'Tprofitproj', '', '2470', '0', '', '', '');
insert into tinfomginterface (C_INFONAME, C_FIELDNAME, C_DESCRIBE, C_TYPE, C_VALUEBOUND, C_VALUE, C_SHOWTITLE, C_SHOWSUBTITLE, L_ORDER, C_MODIFY, C_CRYPTFLAG, C_FULLDESCRIBE, C_ISNULL, D_ADDDATE, L_SHOWTITLENO, L_SHOWSUBTITLENO, L_HEADWIDTH, C_SHOWHEAD, L_LEFT, L_CONTROLLEFT, L_CONTROLWIDTH, L_COLCOUNT, C_QUERYNAME, C_ISQUERY, C_CODE, C_BATCHMODIFYFLAG, C_KEYFIELDFLAG, C_DEPENDSYSPARAMETER, C_DEPENDTACODE)
values ('PROFITPROJ', 'F_FIXEDSTANDARDNET', '业绩提成基准单位净值', '4', '0,999.9999,#,##0.0000', '0', '业绩提成方案设置', null, 350, '1', '0', '业绩提成基准单位净值', '1', null, 1, 101, 120, '1', 10, 130, 240, 2, 'Tprofitproj', null, null, '0', null, null, null);
insert into tinfomginterface (C_INFONAME, C_FIELDNAME, C_DESCRIBE, C_TYPE, C_VALUEBOUND, C_VALUE, C_SHOWTITLE, C_SHOWSUBTITLE, L_ORDER, C_MODIFY, C_CRYPTFLAG, C_FULLDESCRIBE, C_ISNULL, D_ADDDATE, L_SHOWTITLENO, L_SHOWSUBTITLENO, L_HEADWIDTH, C_SHOWHEAD, L_LEFT, L_CONTROLLEFT, L_CONTROLWIDTH, L_COLCOUNT, C_QUERYNAME, C_ISQUERY, C_CODE, C_BATCHMODIFYFLAG, C_KEYFIELDFLAG, C_DEPENDSYSPARAMETER, C_DEPENDTACODE)
values ('PROFITPROJ', 'F_HWCMPNET', '高水位计提基准净值', '4', '0,999.9999,#,##0.0000', '0', '业绩提成方案设置', null, 360, '1', '0', '高水位计提基准净值', '1', null, 1, 101, 120, '1', 400, 155, 240, 2, 'Tprofitproj', null, null, '0', null, null, null);

commit;

--更新规则，对于已经开通了该功能的参数值默认为1，否则默认为0
UPDATE TPROFITPROJ a SET a.c_MgrAccoSharesDealType = '1'
WHERE c_MgrAccoSharesDealType IS NULL
AND EXISTS(SELECT 1 FROM TOPERCONFIG b WHERE b.c_callno = 'UniteDeduct' AND b.l_no = 53);

UPDATE TPROFITPROJ a SET a.c_MgrAccoSharesDealType = '0'
WHERE c_MgrAccoSharesDealType IS NULL;

insert into toperconfig (C_CALLNO, C_OPERTYPE, L_NO, C_CALLFLAG, L_GROUPNO, C_GRPLASTSTEP, C_SVCNAME, C_TABLENAME0, C_TABLENAME1, C_TABLE1TYPE, L_CONCURRENT, C_BUSINFLAG, C_DEALED, C_CAPTION, C_BUSINFLAGS)
select 'BatchDeal', '6', 670.00, null, 670.00, '1', 'HS_MACCO_REDBAT', null, null, null, 1, null, '0', null, null
from dual a
where upper((select b.c_value from tsysparameter b where b.c_item='DatabaseVer')
||(select b.c_value from tsysparameter b where b.c_item='PatchVer')
) >= upper('20161010Sp2');

insert into toperconfig (C_CALLNO, C_OPERTYPE, L_NO, C_CALLFLAG, L_GROUPNO, C_GRPLASTSTEP, C_SVCNAME, C_TABLENAME0, C_TABLENAME1, C_TABLE1TYPE, L_CONCURRENT, C_BUSINFLAG, C_DEALED, C_CAPTION, C_BUSINFLAGS)
select 'BatchDeal', '3', 671.00, null, 671.00, '1', null, 'TREQUEST', 'P_DEAL', '1', null, '03', '0', null, null
from dual a
where upper((select b.c_value from tsysparameter b where b.c_item='DatabaseVer')
||(select b.c_value from tsysparameter b where b.c_item='PatchVer')
) >= upper('20161010Sp2');
insert into toperconfig (C_CALLNO, C_OPERTYPE, L_NO, C_CALLFLAG, L_GROUPNO, C_GRPLASTSTEP, C_SVCNAME, C_TABLENAME0, C_TABLENAME1, C_TABLE1TYPE, L_CONCURRENT, C_BUSINFLAG, C_DEALED, C_CAPTION, C_BUSINFLAGS)
select 'BatchDeal', '9', 672.00, null, 672.00, '1', null, null, null, null, 0, '03', '0', '赎回准备明细数据', null
from dual a
where upper((select b.c_value from tsysparameter b where b.c_item='DatabaseVer')
||(select b.c_value from tsysparameter b where b.c_item='PatchVer')
) >= upper('20161010Sp2');
insert into toperconfig (C_CALLNO, C_OPERTYPE, L_NO, C_CALLFLAG, L_GROUPNO, C_GRPLASTSTEP, C_SVCNAME, C_TABLENAME0, C_TABLENAME1, C_TABLE1TYPE, L_CONCURRENT, C_BUSINFLAG, C_DEALED, C_CAPTION, C_BUSINFLAGS)
select 'BatchDeal', '6', 673.00, null, 673.00, '1', 'HS_REDEEM', null, null, null, 0, '03', '0', '统一业绩提成自营账户强制赎回', '03'
from dual a
where upper((select b.c_value from tsysparameter b where b.c_item='DatabaseVer')
||(select b.c_value from tsysparameter b where b.c_item='PatchVer')
) >= upper('20161010Sp2');
insert into toperconfig (C_CALLNO, C_OPERTYPE, L_NO, C_CALLFLAG, L_GROUPNO, C_GRPLASTSTEP, C_SVCNAME, C_TABLENAME0, C_TABLENAME1, C_TABLE1TYPE, L_CONCURRENT, C_BUSINFLAG, C_DEALED, C_CAPTION, C_BUSINFLAGS)
select 'BatchDeal', '5', 674.00, null, 674.00, '1', null, 'TREQUEST', 'P_DEAL', '1', null, null, '0', null, null
from dual a
where upper((select b.c_value from tsysparameter b where b.c_item='DatabaseVer')
||(select b.c_value from tsysparameter b where b.c_item='PatchVer')
) >= upper('20161010Sp2');
commit;

COMMIT;