首页 思维导图 详情

私募表结构

2016-05-06 14:06:55 2 举报
AI智能生成
私募表结构是一种用于记录和管理私募基金信息的数据库结构。它通常包括以下几个主要字段：基金名称、基金代码、基金类型、基金规模、基金成立日期、基金经理、投资策略、历史收益率等。这些字段可以帮助投资者快速了解基金的基本信息和投资特点，从而做出更明智的投资决策。私募表结构还可以根据实际需求进行扩展，例如添加风险等级、费用标准、投资期限等字段，以满足不同投资者的需求。总之，私募表结构是一种有效的工具，可以帮助投资者更好地管理和跟踪私募基金的表现。
作者其他创作
大纲/内容
comment on column PEF_REDEMPTION_SURE.breachfee
is 'ΥԼ��';
comment on column PEF_REDEMPTION_SURE.transferfee
is '������';
comment on column PEF_REDEMPTION_SURE.otherfee1
is '��������1';
comment on column PEF_REDEMPTION_SURE.nav
is '������λ��ֵ';
comment on column PEF_REDEMPTION_SURE.agencyfee
is '������';
comment on column PEF_REDEMPTION_SURE.charge
is '������';
comment on column PEF_REDEMPTION_SURE.downloaddate
is '���������´�����';
comment on column PEF_REDEMPTION_SURE.businessfinishflag
is 'ҵ��������ȫ������ʶ';
comment on column PEF_REDEMPTION_SURE.taserialno
is 'TAȷ�Ͻ�����ˮ��';
comment on column PEF_REDEMPTION_SURE.returncode
is '���״������ش���';
comment on column PEF_REDEMPTION_SURE.confirmedamount
is 'ÿ�ʽ���ȷ�Ͻ���';
comment on column PEF_REDEMPTION_SURE.confirmedvol
is '�����˻�����ȷ�Ϸ���';
comment on column PEF_REDEMPTION_SURE.currencytype
is '�������� ����������GB/T 12406-2008';
comment on column PEF_REDEMPTION_SURE.transactioncfmdate
is '����ȷ������';
comment on column PEF_REDEMPTION_SURE.is_delete
is 'ɾ����ʾ(0δɾ����1ɾ��)';
comment on column PEF_REDEMPTION_SURE.create_by
is '������';
comment on column PEF_REDEMPTION_SURE.update_by
is '�޸���';
comment on column PEF_REDEMPTION_SURE.create_date
is '��������';
comment on column PEF_REDEMPTION_SURE.update_date
is '�޸�����';
-- Create/Recreate primary, unique and foreign key constraints
alter table PEF_REDEMPTION_SURE
add constraint PK_PEF_REDEMPTION_SURE primary key (ID)
using index
tablespace BSYS_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Grant/Revoke object privileges
grant insert on PEF_REDEMPTION_SURE to BSYSTEM_INSERT;
grant select on PEF_REDEMPTION_SURE to BSYSTEM_SELECT;
grant update on PEF_REDEMPTION_SURE to BSYSTEM_UPDATE;
�Ϲ�������
-----------------------------------------------------------
-- Create table
create table PEF_SUBSCRIBE_APPLY
(
id NUMBER(18) not null,
app_sheet_serialno VARCHAR2(32) not null,
currency_type VARCHAR2(32) not null,
fund_code VARCHAR2(32) not null,
transaction_date VARCHAR2(32) not null,
transaction_time VARCHAR2(32) not null,
transaction_account_id VARCHAR2(32) not null,
distributor_code VARCHAR2(32) not null,
application_amount NUMBER(32,2) not null,
business_code VARCHAR2(32) not null,
ta_account_id VARCHAR2(32),
branch_code VARCHAR2(32) not null,
share_class VARCHAR2(32) not null,
subs_class VARCHAR2(32),
is_agree_outrisk VARCHAR2(32),
is_agree_nextday VARCHAR2(32),
extension VARCHAR2(2000),
process_status VARCHAR2(32),
is_delete VARCHAR2(32) default 0 not null,
create_by VARCHAR2(64) not null,
create_date DATE not null,
update_by VARCHAR2(64) not null,
update_date DATE not null,
subscribe_amount NUMBER(32,2) not null,
afp_no VARCHAR2(16),
handletradedate VARCHAR2(8),
institutioncode VARCHAR2(6),
investorname VARCHAR2(120) not null,
discountrateofcommission NUMBER(5,4)
)
tablespace BSYS_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table PEF_SUBSCRIBE_APPLY
is '�Ϲ�������';
-- Add comments to the columns
comment on column PEF_SUBSCRIBE_APPLY.id
is 'ID(PK)';
comment on column PEF_SUBSCRIBE_APPLY.app_sheet_serialno
is '���뵥����';
comment on column PEF_SUBSCRIBE_APPLY.currency_type
is '��������';
comment on column PEF_SUBSCRIBE_APPLY.fund_code
is '��������';
comment on column PEF_SUBSCRIBE_APPLY.transaction_date
is '���׷�������';
comment on column PEF_SUBSCRIBE_APPLY.transaction_time
is '���׷���ʱ��';
comment on column PEF_SUBSCRIBE_APPLY.transaction_account_id
is 'Ͷ���˻��������˺�';
comment on column PEF_SUBSCRIBE_APPLY.distributor_code
is '�����˴���';
comment on column PEF_SUBSCRIBE_APPLY.application_amount
is '��������';
comment on column PEF_SUBSCRIBE_APPLY.business_code
is 'ҵ������';
comment on column PEF_SUBSCRIBE_APPLY.ta_account_id
is 'Ͷ���˻����˺�';
comment on column PEF_SUBSCRIBE_APPLY.branch_code
is '��������';
comment on column PEF_SUBSCRIBE_APPLY.share_class
is '�շѷ�ʽ(0-ǰ�շѣ�1-���շ�)';
comment on column PEF_SUBSCRIBE_APPLY.subs_class
is '�깺��ʽ(�ջ�0��ʾ��ͨ��1-��ʾ�����깺)';
comment on column PEF_SUBSCRIBE_APPLY.is_agree_outrisk
is '�Ƿ�ͬ�����ܳ�������(0-��ͬ��,1-ͬ��(�������ݡ��Ƿ�ǿ�ƹ��롱��־λ��)';
comment on column PEF_SUBSCRIBE_APPLY.is_agree_nextday
is '�Ƿ�ͬ��˳������һ������(0-��ͬ��,1-ͬ��)';
comment on column PEF_SUBSCRIBE_APPLY.extension
is '��Ϣ��չ';
comment on column PEF_SUBSCRIBE_APPLY.process_status
is '����״̬��0000�������룬0001���ɹ���0002��ʧ�ܣ�';
comment on column PEF_SUBSCRIBE_APPLY.is_delete
is 'ɾ����ʾ(0δɾ����1ɾ��)';
comment on column PEF_SUBSCRIBE_APPLY.create_by
is '������';
comment on column PEF_SUBSCRIBE_APPLY.create_date
is '��������';
comment on column PEF_SUBSCRIBE_APPLY.update_by
is '�޸���';
comment on column PEF_SUBSCRIBE_APPLY.update_date
is '�޸�����';
comment on column PEF_SUBSCRIBE_APPLY.subscribe_amount
is '��Ҫ���ݻ������Ϲ��������Ϲ��ѣ�û����0';
comment on column PEF_SUBSCRIBE_APPLY.afp_no
is '����ʦ����';
comment on column PEF_SUBSCRIBE_APPLY.investorname
is 'Ͷ��������';
comment on column PEF_SUBSCRIBE_APPLY.discountrateofcommission
is '����Ӷ���ۿ��� ';
-- Create/Recreate primary, unique and foreign key constraints
alter table PEF_SUBSCRIBE_APPLY
add primary key (ID)
using index
tablespace BSYS_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Grant/Revoke object privileges
grant select, insert on PEF_SUBSCRIBE_APPLY to BSYSTEM_APP;
grant insert on PEF_SUBSCRIBE_APPLY to BSYSTEM_INSERT;
grant select on PEF_SUBSCRIBE_APPLY to BSYSTEM_SELECT;
grant update on PEF_SUBSCRIBE_APPLY to BSYSTEM_UPDATE;
�Ϲ�ȷ�ϱ�
--------------------------------------------------------------
-- Create table
create table PEF_SUBSCRIBE_SURE
(
id NUMBER(18) not null,
app_sheet_serialno VARCHAR2(32) not null,
fund_code VARCHAR2(32) not null,
return_code VARCHAR2(32) not null,
transaction_account_id VARCHAR2(32) not null,
distributor_code VARCHAR2(32) not null,
application_amount NUMBER(32,2) not null,
business_code VARCHAR2(32) not null,
ta_account_id VARCHAR2(32) not null,
deposit_acct VARCHAR2(32),
region_code VARCHAR2(32),
transaction_cfm_date VARCHAR2(32) not null,
download_date VARCHAR2(32) not null,
charge NUMBER(16,2),
agency_fee NUMBER(16,2),
confirmed_vol NUMBER(32,2),
confirmed_amount NUMBER(32,2) not null,
branch_code VARCHAR2(32) not null,
transaction_date VARCHAR2(32) not null,
transaction_time VARCHAR2(32) not null,
individual_or_institution VARCHAR2(32),
application_vol NUMBER(32,2),
trading_price NUMBER(8,4),
ta_serialno VARCHAR2(32) not null,
stamp_duty NUMBER(32,2),
valid_period VARCHAR2(32),
transfer_fee NUMBER(16,2),
from_ta_flag VARCHAR2(32),
share_class VARCHAR2(32) not null,
fee_calculator VARCHAR2(32),
future_subscribe_date VARCHAR2(32),
balance_flg VARCHAR2(32),
is_delete VARCHAR2(32) default 0 not null,
create_by VARCHAR2(64) not null,
create_date DATE not null,
update_by VARCHAR2(64) not null,
update_date DATE not null,
nav NUMBER(16,4) not null,
handletradedate VARCHAR2(8),
institutioncode VARCHAR2(6)
)
tablespace BSYS_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table PEF_SUBSCRIBE_SURE
is '�Ϲ�ȷ�ϱ�';
-- Add comments to the columns
comment on column PEF_SUBSCRIBE_SURE.id
is 'ID(PK)';
comment on column PEF_SUBSCRIBE_SURE.app_sheet_serialno
is '���뵥����';
comment on column PEF_SUBSCRIBE_SURE.fund_code
is '��������';
comment on column PEF_SUBSCRIBE_SURE.return_code
is '���״������ش���';
comment on column PEF_SUBSCRIBE_SURE.transaction_account_id
is 'Ͷ���˻��������˺�';
comment on column PEF_SUBSCRIBE_SURE.distributor_code
is '�����˴���';
comment on column PEF_SUBSCRIBE_SURE.application_amount
is '��������';
comment on column PEF_SUBSCRIBE_SURE.business_code
is 'ҵ������';
comment on column PEF_SUBSCRIBE_SURE.ta_account_id
is 'Ͷ���˻����˺�';
comment on column PEF_SUBSCRIBE_SURE.deposit_acct
is 'Ͷ�����������˴��������ʽ��˺�';
comment on column PEF_SUBSCRIBE_SURE.region_code
is '�������ڵ�������';
comment on column PEF_SUBSCRIBE_SURE.transaction_cfm_date
is '����ȷ������';
comment on column PEF_SUBSCRIBE_SURE.download_date
is '���������´�����';
comment on column PEF_SUBSCRIBE_SURE.charge
is '������';
comment on column PEF_SUBSCRIBE_SURE.agency_fee
is '������';
comment on column PEF_SUBSCRIBE_SURE.confirmed_vol
is '�����˻�����ȷ�Ϸ���';
comment on column PEF_SUBSCRIBE_SURE.confirmed_amount
is 'ÿ�ʽ���ȷ�Ͻ���';
comment on column PEF_SUBSCRIBE_SURE.branch_code
is '��������';
comment on column PEF_SUBSCRIBE_SURE.transaction_date
is '���׷�������';
comment on column PEF_SUBSCRIBE_SURE.transaction_time
is '���׷���ʱ��';
comment on column PEF_SUBSCRIBE_SURE.individual_or_institution
is '����/������־(0-������1-����)';
comment on column PEF_SUBSCRIBE_SURE.application_vol
is '������������';
comment on column PEF_SUBSCRIBE_SURE.trading_price
is '���׼۸�(��λ������ֵ+���ַ���)';
comment on column PEF_SUBSCRIBE_SURE.ta_serialno
is 'TAȷ�Ͻ�����ˮ��';
comment on column PEF_SUBSCRIBE_SURE.stamp_duty
is 'ӡ��˰';
comment on column PEF_SUBSCRIBE_SURE.valid_period
is '��������������';
comment on column PEF_SUBSCRIBE_SURE.transfer_fee
is '������';
comment on column PEF_SUBSCRIBE_SURE.from_ta_flag
is '�Ƿ�ע���Ǽ��˷���ҵ����־(0-�������˷�����1-��ע���Ǽ��˷���)';
comment on column PEF_SUBSCRIBE_SURE.share_class
is '�շѷ�ʽ(0-ǰ�շѣ�1-���շ�)';
comment on column PEF_SUBSCRIBE_SURE.fee_calculator
is '�Ʒ���(0-TA�Ʒ� 1-�����Ʒ�)';
comment on column PEF_SUBSCRIBE_SURE.future_subscribe_date
is 'ָ���Ϲ�����';
comment on column PEF_SUBSCRIBE_SURE.balance_flg
is '����״̬��0������1�쳣��2�Ѵ�����';
comment on column PEF_SUBSCRIBE_SURE.is_delete
is 'ɾ����ʾ(0δɾ����1ɾ��)';
comment on column PEF_SUBSCRIBE_SURE.create_by
is '������';
comment on column PEF_SUBSCRIBE_SURE.create_date
is '��������';
comment on column PEF_SUBSCRIBE_SURE.update_by
is '�޸���';
comment on column PEF_SUBSCRIBE_SURE.update_date
is '�޸�����';
comment on column PEF_SUBSCRIBE_SURE.nav
is '������λ��ֵ';
-- Create/Recreate primary, unique and foreign key constraints
alter table PEF_SUBSCRIBE_SURE
add primary key (ID)
using index
tablespace BSYS_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Grant/Revoke object privileges
grant select, insert on PEF_SUBSCRIBE_SURE to BSYSTEM_APP;
grant insert on PEF_SUBSCRIBE_SURE to BSYSTEM_INSERT;
grant select on PEF_SUBSCRIBE_SURE to BSYSTEM_SELECT;
grant update on PEF_SUBSCRIBE_SURE to BSYSTEM_UPDATE;
���� ���ӣ�
-- Create sequence
create sequence S_PEF_REDEMPTION_SURE
minvalue 1
maxvalue 999999999999999999
start with 281
increment by 1
cache 20;
var pef = pef || {};
// ��������
pef.datetimepicker = function() {
var target = $(".form_date");
if (target.length == 0)
return;
target.datetimepicker({
language : 'zh-CN',
weekStart : 1,
todayBtn : 1,
autoclose : 1,
todayHighlight : 1,
startView : 2,
minView : 2,
forceParse : 0
});
}
// ���߷���
pef.tool = {
checkLength : function() {
if (arguments.length < 2)
return;
var str = $.trim(arguments[0]), l = arguments[1], s = 1, result = false;
if (arguments.length > 2)
s = arguments[2]; // 1->,2->=,3-<,4-<=,5-===
if ((s === 1 && str.length > l) || (s === 2 && str.length >= l)
|| (s === 3 && str.length < l) || (s === 4 && str.length <= l)
|| (s === 5 && str.length === l)) {
result = true;
}
return result;
},
checkInt : function() {
if (arguments.length < 1)
return;
if (arguments[1] == 3) {
var result = false, reg = /^[0-9]{1,3}?$/g;
if (reg.test(arguments[0])) {
result = true;
}
}
if (arguments[1] == 10) {
var result = false, reg = /^[0-9]{1,10}?$/g;
if (reg.test(arguments[0])) {
result = true;
}
}
if (arguments[1] == 19) {
var result = false, reg = /^[0-9]{1,19}?$/g;
if (reg.test(arguments[0])) {
result = true;
}
}
if (arguments[1] == 14) {
var result = false, reg = /^[0-9]{1,14}?$/g;
if (reg.test(arguments[0])) {
result = true;
}
}
return result;
},
checkFloat : function() {
if (arguments.length < 1)
return;
if (arguments.length >= 2) {
result = false;
if (arguments[1] == 2) {
var reg = /(^[0-9]{1,2})+(.[0-9]{1,2})?$/g;
if (reg.test(arguments[0])) {
result = true;
}
}
if (arguments[1] == 19) {
var reg = /(^[0-9]{1,19})+(.[0-9]{1,2})?$/g;
if (reg.test(arguments[0])) {
result = true;
}
}
if (arguments[1] == 14) {
var reg = /(^[0-9]{1,14})+(.[0-9]{1,2})?$/g;
if (reg.test(arguments[0])) {
result = true;
}
}
if (arguments[1] == 1) {
var reg = /(^[0]{1})+(.[0-9]{1,2})?$/g;
if (reg.test(arguments[0])) {
result = true;
}
}
return result;
}
}
};
// ������ƷУ��
pef.formCheck = {
txtCheck : function(obj, strmin, type1, strmax, type2, tip) {
var _t = this, str = obj.val(), minLength = pef.tool.checkLength(str,
strmin, type1), maxLength = pef.tool.checkLength(str, strmax,
type2), alter = obj.next(".alter");
if (!minLength) {
_t.state = false;
alter.html("!" + tip + "������");
obj.addClass("warncolor");
} else if (!maxLength) {
_t.state = false;
alter.html("!" + tip + "���Ȳ��ܳ���" + strmax + "���ַ�");
obj.addClass("warncolor");
} else {
alter.html("");
obj.removeClass("warncolor");
}
},
selectCheck : function(obj, tip) {
var _t = this, v = obj.find("option:selected").val(), txt = obj.find(
"option:selected").text(), alter = obj.next(".alter");
if (v == "" || txt == &apos;��ѡ��&apos;) {
_t.state = false;
alter.html("!" + tip);
obj.addClass("warncolor");
} else {
alter.html("");
obj.removeClass("warncolor");
}
},
dateCheck : function(obj1, tip1, obj2, tip2, limitMax) {
var _t = this;
if (arguments.length == 2) {
var str = obj1.val(), empty = pef.tool.checkLength(str, 0, 5), alter = obj1
.parent(".controls").siblings(".alter");
if (empty) {
_t.state = false;
alter.html("!" + tip1 + "������");
} else {
alter.html("");
}
}
if (arguments.length == 4) {
var str = obj2.val(), empty = pef.tool.checkLength(str, 0, 5), alter = obj2
.parent(".controls").siblings(".alter");
if (empty) {
_t.state = false;
alter.html("!" + tip2 + "������");
} else {
var str2 = obj1.val(), empty2 = pef.tool
.checkLength(str2, 0, 5);
if (!empty2) {
str = parseInt(str.replace(/-/g, ""), 10);
str2 = parseInt(str2.replace(/-/g, ""), 10);
if (str2 > str) {
_t.state = false;
alter.html("!" + tip2 + "������" + tip1);
} else {
alter.html("");
}
}
}
}
if (arguments.length == 5) {
var str = obj2.val(), empty = pef.tool.checkLength(str, 0, 5), alter = obj2
.parent(".controls").siblings(".alter");
if (empty) {
_t.state = false;
alter.html("!" + tip2 + "������");
} else {
var str2 = obj1.val(), empty2 = pef.tool
.checkLength(str2, 0, 5);
if (!empty2) {
str = parseInt(str.replace(/-/g, ""), 10);
str2 = parseInt(str2.replace(/-/g, ""), 10);
if (str2 > str) {
_t.state = false;
alter.html("!" + tip2 + "������" + tip1);
} else if (str - str2 >= limitMax) {
_t.state = false;
alter.html("!ļ���ڲ��ܳ���" + limitMax + "��");
} else {
alter.html("");
}
}
}
}
},
date2Check : function(obj1, tip1) {
var _t = this;
var str = obj1.val(), empty = pef.tool.checkLength(str, 0, 5), alter = obj1
.siblings(".alter");
if (empty) {
_t.state = false;
alter.html("!" + tip1 + "������");
} else {
alter.html("");
}
},
moneyCheck : function(obj, tip1) {
var _t = this, str = obj.val(), minLength = pef.tool
.checkLength(str, 0), maxLength = pef.tool.checkLength(str, 22,
4), alter = obj.siblings(".alter");
if (!(str == null || str == "")) {
obj.val(parseFloat(str));
}
if (tip1 == "") {
if (minLength && !pef.tool.checkFloat(str, 14)) {
_t.state = false;
alter.html("!����������14λ���ڣ�С��2λ���ڵ�����");
obj.addClass("warncolor");
} else {
alter.html("");
obj.removeClass("warncolor");
}
} else {
if (!minLength) {
_t.state = false;
alter.html("!" + tip1);
obj.addClass("warncolor");
} else if (!pef.tool.checkFloat(str, 14)) {
_t.state = false;
alter.html("!����������14λ���ڣ�С��2λ���ڵ�����");
obj.addClass("warncolor");
} else {
alter.html("");
obj.removeClass("warncolor");
}
}
},
moneyIntCheck : function(obj, tip1) {
var _t = this, str = obj.val(), minLength = pef.tool
.checkLength(str, 0), maxLength = pef.tool.checkLength(str, 14,
4), alter = obj.siblings(".alter");
if (!(str == null || str == "")) {
obj.val(parseFloat(str));
}
if (tip1 == "") {
if (minLength && !pef.tool.checkInt(str, 14)) {
_t.state = false;
alter.html("!������14λ���ڵ�������");
obj.addClass("warncolor");
} else {
alter.html("");
obj.removeClass("warncolor");
}
} else {
if (!minLength) {
_t.state = false;
alter.html("!" + tip1);
obj.addClass("warncolor");
} else if (!pef.tool.checkInt(str, 14)) {
_t.state = false;
alter.html("!������14λ���ڵ�������");
obj.addClass("warncolor");
} else {
alter.html("");
obj.removeClass("warncolor");
}
}
},
lineCheck : function(obj, tip1) {
var _t = this, str = obj.val(), minLength = pef.tool.checkLength(str,
0, 5), alter = obj.siblings(".alter");
if (minLength) {
_t.state = false;
alter.html("!" + tip1 + "������");
obj.addClass("warncolor");
} else if (!pef.tool.checkFloat(str, 1)) {
_t.state = false;
alter.html("!������С��1��С��2λ���ڵ�����");
obj.addClass("warncolor");
} else {
alter.html("");
obj.removeClass("warncolor");
}
},
rateCheck : function(obj, tip) {
var _t = this, val = $.trim(obj.val()), alter = obj.siblings(".alter");
if (val == "") {
_t.state = false;
alter.html("!" + tip + "������");
obj.addClass("warncolor");
} else if (!pef.tool.checkFloat(val, 2)) {
_t.state = false;
alter.html("!����������2λ���ڣ�С��λ2λ���ڵ�����");
obj.addClass("warncolor");
} else {
alter.html("");
obj.removeClass("warncolor");
}
},
intCheck : function(obj, tip, l, min, max) {
var _t = this, data = $.trim(obj.val()), alter = obj.siblings(".alter");
if (data == "") {
_t.state = false;
alter.html("!" + tip + "������");
obj.addClass("warncolor");
} else if (!pef.tool.checkInt(data, l)) {
_t.state = false;
alter.html("!������" + l + "���������");
obj.addClass("warncolor");
} else if (parseInt(data) < parseInt(min)) {
_t.state = false;
alter.html("!������" + min);
obj.addClass("warncolor");
} else if (parseInt(data) > parseInt(max)) {
_t.state = false;
alter.html("!���ܴ���" + max);
obj.addClass("warncolor");
} else {
alter.html("");
obj.removeClass("warncolor");
}
},
textareaCheck : function(obj, l, tip) {
var _t = this;
str = obj.val(), minLength = pef.tool.checkLength(str, 0),
maxLength = pef.tool.checkLength(str, l, 4), alter = obj
.siblings(".alter");
if (!minLength) {
_t.state = false;
alter.html("!" + tip + "������");
obj.addClass("warncolor");
} else if (!maxLength) {
_t.state = false;
alter.html("!" + tip + "���Ȳ��ܳ���" + l + "���ַ�");
obj.addClass("warncolor");
} else {
alter.html("");
obj.removeClass("warncolor");
}
},
textareaSet : function(obj, l) {
var count = l - $.trim(obj.val()).length;
if (count <= 0) {
count = 0;
obj.val($.trim(obj.val()).slice(0, l));
}
obj.siblings(".alter").html(
"����������" + count + "��");
obj.removeClass("warncolor");
},
conditionSet : function(str) {
var _t = this;
if (str == "B") {
_t.objReadOnly.removeAttr("readonly");
_t.objReadOnly.parent().prev("td.tag-name").find(".required-field")
.html("*");
} else {
_t.objReadOnly.attr("readonly", "readonly")
.removeClass("warncolor");
_t.objReadOnly.siblings(".alter").html("");
_t.objReadOnly.parent().prev("td.tag-name").find(".required-field")
.html("");
_t.objReadOnly.parent().find(".form-control").val("");
}
},
bind : function() {
var _t = this;
_t.txt.on("keyup", function() {
$(this).siblings(".alter").html("");
$(this).removeClass("warncolor");
});
_t.sel.on("change", function() {
$(this).siblings(".alter").html("");
$(this).removeClass("warncolor");
});
_t.date.on("blur", function() {
if ($(this).val() != "") {
$(this).siblings(".alter").html("");
}
});
$("textarea").on("blur", function() {
$(this).next(".alter").html("");
});
_t.submitBtn
.on(
"click",
function() {
_t.state = true;
/* base information */
var index = 0;
_t.txtCheck(_t.name, 0, 1, 66, 4, "��Ʒ����");
// _t.intCheck(_t.discountRate, "�ۿ���", 3, 1, 100);
_t.txtCheck(_t.jname, 0, 1, 66, 4, "��Ʒ����");
_t.txtCheck(_t.fundCode, 0, 1, 6, 4, "��������");
// _t.txtCheck(_t.fundManagerCode, 0, 1, 8, 4,
// "���������˴���");
_t.txtCheck(_t.structure, 0, 1, 150, 4, "��Ʒ�ṹ");
_t.selectCheck(_t.category, "��ѡ����Ʒ����");
_t.selectCheck(_t.packagingModel, "��ѡ����Ʒ��װģʽ");
_t.selectCheck(_t.modefityMethod, "��ѡ���Ƿ�֧���޸ķֺ췽ʽ");
// _t.selectCheck(_t.cllx, "��ѡ����������");
_t.selectCheck(_t.subscribeMethod, "��ѡ���Ϲ�����ȡ��ʽ");
_t.selectCheck(_t.purchaseMethod, "��ѡ���깺����ȡ��ʽ");
_t.selectCheck(_t.isNotAchievementGatherPay,
"��ѡ���Ƿ���ȡҵ������");
// _t.selectCheck(_t.riskLevel, "��ѡ����Ʒ���յȼ�");
_t.moneyCheck(_t.scale, "��Ʒ��ģ����Ϊ��");
// _t.selectCheck(_t.fundStrategy, "��ѡ����������");
_t.moneyCheck(_t.startAmount, "��Ͷ�����Ϊ��");
_t.moneyCheck(_t.lowest, "���ͳ�����ģ����Ϊ��");
_t.moneyCheck(_t.initialAmount, "���������Ϲ������Ϊ��");
_t.moneyCheck(_t.incrementalAmount, "�����Ϲ������Ϊ��");
_t.moneyCheck(_t.maxInvestTZAmount, "����Ͷ�ʽ����Ϊ��");
_t.date2Check(_t.dateStart, "ļ������ʼ����");
_t.date2Check(_t.dateEnd, "ļ������ֹ����");
_t.date2Check(_t.dateFound, "Ԥ�Ƴ���ʱ��");
_t.date2Check(_t.dateEnd2, "Ԥ�Ƶ���ʱ��");
// _t.intCheck(_t.duration, "��������", 3);
_t.txtCheck(_t.openPeriod, 0, 1, 150, 4, "��������");
_t.rateCheck(_t.closureRate, "׼���������ط���");
_t.intCheck(_t.closurePeriod, "������", 10);
_t.intCheck(_t.closurePeriod2, "׼������", 10);
_t.selectCheck(_t.productIncome, "��ѡ����Ʒ������֤");
_t
.intCheck(_t.investmentNumber, "��Ͷ������", 3,
1, 200);
_t.moneyCheck(_t.maxSubAmount, "�����Ϲ������Ϊ��");
_t.intCheck(_t.mixPerson, "��Ʒ��С����", 3);
_t.intCheck(_t.maxPerson, "��Ʒ��������", 3, 1, 200);
_t.moneyCheck(_t.raiseLimit, "��Ʒļ����ģ���޲���Ϊ��");
// _t.intCheck(_t.subsistLimit, "��Ʒ������ģ����", 3);
_t.moneyCheck(_t.firstMixMoney, "�״��깺���ͽ����Ϊ��");
_t.moneyCheck(_t.againMixMoney, "׷���깺���ͽ����Ϊ��");
_t.textareaCheck(_t.redemptiontj, 1200, "��������");
_t.selectCheck(_t.productStatus, "��ѡ����Ʒ����״̬");
/* end base information */
_t.date2Check(_t.startYyPurchaseDate,
"��ʼԤԼ�깺�Ǽ���(������)");
_t.date2Check(_t.endYyPurchaseDate, "����ԤԼ�깺�Ǽ���(������)");
_t.intCheck(_t.startYyRedemptionDate,
"��ʼԤԼ���صǼ���(������)", 3);
_t.intCheck(_t.endYyRedemptionDate,
"����ԤԼ���صǼ���(������)", 3);
if ($("#isNotModefityShowMethod").hasClass(
"isNotModefityShowMethod")) {
_t.isNotModefityShowMethod = $(
".isNotModefityShowMethod", _t.f);
_t.selectCheck(_t.isNotModefityShowMethod,
"��ѡ���Ƿ�֧���޸ķֺ췽ʽ");
}
if ($("#purchaseOpenRule").hasClass(
"purchaseOpenRule")) {
_t.purchaseOpenRule = $(".purchaseOpenRule",
_t.f);
_t.selectCheck(_t.purchaseOpenRule, "��ѡ���깺���Ź���");
}
if ($("#redemptionOpenRule").hasClass(
"redemptionOpenRule")) {
_t.redemptionOpenRule = $(
".redemptionOpenRule", _t.f);
_t.selectCheck(_t.redemptionOpenRule, "��ѡ�����ؿ��Ź���");
}
if ($("#purchaseOpenMons").hasClass(
"purchaseOpenMons")) {
_t.purchaseOpenMons = $(".purchaseOpenMons",
_t.f);
_t.intCheck(_t.purchaseOpenMons, "�깺������", 3);
}
if ($.trim(_t.lowestHoldNormalMoney.val()) == "") {
if ($.trim(_t.lowestHoldNormalShare.val()) == "") {
_t.intCheck(_t.lowestHoldNormalMoney,
"���ͳ��б�׼(Ԫ)", 14);
} else {
_t.intCheck(_t.lowestHoldNormalShare,
"���ͳ��б�׼(��)", 14);
}
} else {
_t.intCheck(_t.lowestHoldNormalMoney,
"���ͳ��б�׼(Ԫ)", 14);
}
if ($("#redemptionOpenMons").hasClass(
"redemptionOpenMons")) {
_t.redemptionOpenMons = $(
".redemptionOpenMons", _t.f);
_t.intCheck(_t.redemptionOpenMons, "���ؿ�����", 3);
}
if ($("#purchaseOpenDays").hasClass(
"purchaseOpenDays")) {
_t.purchaseOpenDays = $(".purchaseOpenDays",
_t.f);
_t.intCheck(_t.purchaseOpenDays, "�깺������", 3);
}
if ($("#redemptionOpenDays").hasClass(
"redemptionOpenDays")) {
_t.redemptionOpenDays = $(
".redemptionOpenDays", _t.f);
_t.intCheck(_t.redemptionOpenDays, "���ؿ�����", 3);
}
if ($("#purchaseOpenNumber").hasClass(
"purchaseOpenNumber")) {
_t.purchaseOpenNumber = $(
".purchaseOpenNumber", _t.f);
_t.intCheck(_t.purchaseOpenNumber, "�깺������", 3);
}
if ($("#redemptionOpenNumber").hasClass(
"redemptionOpenNumber")) {
_t.redemptionOpenNumber = $(
".redemptionOpenNumber", _t.f);
_t
.intCheck(_t.redemptionOpenNumber,
"���ؿ�����", 3);
}
/* organization */
_t.txtCheck(_t.investmentAdviser, 0, 1, 170, 4,
"Ͷ�ʹ���");
_t.txtCheck(_t.fundManager, 0, 1, 170, 4,
"���������ˣ����ƣ�");
_t.txtCheck(_t.custodian, 0, 1, 200, 4, "�й��ˣ����ƣ�");
// _t.txtCheck(_t.riskControlConsultant, 0, 1, 200,
// 4,
// "���ع��ʣ����ƣ�");
_t.txtCheck(_t.futuresOrg, 0, 1, 200, 4,
"�ڻ����ͻ��������ƣ�");
_t.txtCheck(_t.administrationOrg, 0, 1, 200, 4,
"�����������������ƣ�");
_t.txtCheck(_t.consignamentOrg, 0, 1, 200, 4,
"���������������ƣ�");
_t.txtCheck(_t.securityOrg, 0, 1, 200, 4,
"֤ȯ���ͻ��������ƣ�");
// _t.txtCheck(_t.rewardRate, 0, 1, 200, 4,
// "��ҵ��������");
_t.rateCheck(_t.managementRate, "��������");
_t.rateCheck(_t.redeemRate, "���ط���");
_t.rateCheck(_t.manageCost, "�йܷ���");
_t.rateCheck(_t.subscriptionRate, "�Ϲ�����");
_t.rateCheck(_t.salesRate, "���۷�������");
// _t.rateCheck(_t.maintenanceRate, "�ͻ�ά������");
_t.selectCheck(_t.formula, "��ѡ���Ϲ����깺�ݶ������ؽ����ļ��㷽ʽ");
_t.selectCheck(_t.purchaseReg, "��ѡ���Ƿ�ԤԼ�깺�Ǽ�");
_t.selectCheck(_t.redeemReg, "��ѡ���Ƿ�ԤԼ���صǼ�");
_t.textareaCheck(_t.briefIntroduction, 1000,
"������������");
_t.textareaCheck(_t.fundManagerIntro, 1200,
"���������˽���");
// _t.rateCheck(_t.organizationServe, "�����������۷�������");
_t.intCheck(_t.subscribeRebate, "�Ϲ��ۿ���", 3, 1, 100);
_t.rateCheck(_t.purchaseRate, "�깺����");
// _t.rateCheck(_t.excessAchievementPay, "����ҵ��������");
_t.intCheck(_t.purchaseRebate, "�깺�ۿ���", 3, 1, 100);
// _t.rateCheck(_t.organizationCustomerFee,
// "���������ͻ�ά������");
// _t.txtCheck(_t.riskCounselorCode, 0, 1, 50, 4,
// "���ع��ʣ����룩");
// _t.txtCheck(_t.investmentAdviserCode, 0, 1, 50,
// 4,
// "Ͷ�ʹ��ʣ����룩");
// _t.txtCheck(_t.fundMandatorCode, 0, 1, 50, 4,
// "�й��ˣ����룩");
// _t.txtCheck(_t.administrativeManagerCode, 0, 1,
// 50,
// 4, "�����������������룩");
// _t.txtCheck(_t.salesOrganizationCode, 0, 1, 50,
// 4,
// "���������������룩");
// _t.txtCheck(_t.securityOrganizationCode, 0, 1,
// 50,
// 4, "֤ȯ���ͻ��������룩");
// _t.txtCheck(_t.futuresOrganizationCode, 0, 1, 50,
// 4, "�ڻ����ͻ��������룩");
_t.textareaCheck(_t.achievementPayTerm, 300,
"ҵ��������ȡ����");
_t.briefIntroduction.on("keyup change", function() {
_t.textareaSet($(this), 1000);
});
_t.fundManagerIntro.on("keyup change", function() {
_t.textareaSet($(this), 1200);
});
_t.redemptiontj.on("keyup change", function() {
_t.textareaSet($(this), 1200);
});
_t.achievementPayTerm.on("keyup change",
function() {
_t.textareaSet($(this), 300);
});
/* end organization */
/* product description */
_t.rateCheck(_t.expectedReturnRate, "Ԥ��������");
// _t.txtCheck(_t.splitRatio, 0, 1, 50, 4,
// "�����ֳɱ���");
_t.txtCheck(_t.benchmark, 0, 1, 130, 4, "ҵ���Ƚϻ�׼");
//_t.txtCheck(_t.secInvestor, 0, 1, 200, 4, "�������");
// _t.rateCheck(_t.participationRate, "������");
_t.lineCheck(_t.warningLine, "Ԥ����");
_t.lineCheck(_t.stopLine, "ֹ����");
// _t.rateCheck(_t.guaranteedRate, "������");
// _t.selectCheck(_t.frequency, "��������Ƶ��");
// if ($("#earningsAllotWay").hasClass("earningsAllotWay")) {
// _t.earningsAllotWay = $(".earningsAllotWay", _t.f);
// _t.selectCheck(_t.earningsAllotWay, "��ѡ���������䷽ʽ");
// }
if ($("#durationTime").hasClass("duration")) {
_t.durationTime = $(".duration", _t.f);
_t.intCheck(_t.durationTime, "��������",10);
}
if ($("#fundStrategy").hasClass("fundStrategy")) {
_t.fundStrategy = $(".fundStrategy", _t.f);
_t.selectCheck(_t.fundStrategy, "��ѡ����������");
}
_t.selectCheck(_t.checkFrequency, "��ѡ����ֵ�˶�Ƶ��");
_t.textareaCheck(_t.investmentScope, 1200,
"Ͷ�ʷ�Χ/����");
_t.textareaCheck(_t.investmentLimit, 1200, "Ͷ������");
_t.textareaCheck(_t.investmentTarget, 1200, "Ͷ��Ŀ��");
_t.textareaCheck(_t.investmentStrategy, 1200,
"Ͷ�ʲ���");
_t.investmentScope.on("keyup change", function() {
_t.textareaSet($(this), 1200);
});
_t.investmentLimit.on("keyup change", function() {
_t.textareaSet($(this), 1200);
});
_t.investmentTarget.on("keyup change", function() {
_t.textareaSet($(this), 1200);
});
_t.investmentStrategy.on("keyup change",
function() {
_t.textareaSet($(this), 1200);
});
_t.popularOpinion.on("keyup change", function() {
_t.textareaSet($(this), 1300);
});
_t.otherInstrucetions.on("keyup change",
function() {
_t.textareaSet($(this), 1300);
});
/* end product description */
/* running info --Start */
_t.intCheck(_t.subscribeDays, "�Ϲ���������", 3);
_t.intCheck(_t.cfmDays, "�Ϲ�ȷ������", 3);
_t.intCheck(_t.purchaseDeliveryDays, "�깺��������", 3);
_t.intCheck(_t.purchaseCfmDays, "�깺ȷ������", 3);
_t.intCheck(_t.redemptionDays, "���ؽ�������", 3);
_t.intCheck(_t.redemptionCfmDays, "����ȷ������", 3);
_t.intCheck(_t.dividendDeliveryDays, "�ֺ콻������", 3);
_t.intCheck(_t.lqdfundsDeliveryDays, "�����������", 3);
_t.intCheck(_t.seccfmFailrfndDeliveryDays,
"����ȷ��ʧ���˿������", 3);
_t.intCheck(_t.raiseFailRfndDeliveryDays,
"ļ��ʧ���˿������", 3);
_t
.txtCheck(_t.raiseAccName, 0, 1, 50, 4,
"ļ���˻��˻���");
_t.txtCheck(_t.raiseAccNo, 0, 1, 30, 4, "ļ���˻��˺�");
_t.txtCheck(_t.raiseAccBankName, 0, 1, 50, 4,
"ļ���˻�������");
_t.txtCheck(_t.raiseAccCnapsCode, 0, 1, 30, 4,
"ļ�������к�");
_t.txtCheck(_t.lqdAccCnapsCode, 0, 1, 30, 4,
"���㻧���к�");
// _t.intCheck(_t.taCode, "TA����", 3);
_t.txtCheck(_t.taCode, 0, 1, 3, 4, "TA����");
/* running info --End */
/* attachment */
_t.popularOpinion.on("keyup change", function() {
_t.textareaSet($(this), 1300);
});
_t.riskControlOpinion.on("keyup change",
function() {
_t.textareaSet($(this), 1300);
});
_t.messageShow.on("keyup change",
function() {
_t.textareaSet($(this), 1300);
});
/* end attachment */
if (_t.state) {
$(&apos;#baseInfo&apos;).ajaxSubmit({
target : &apos;#mainbody&apos;,
type : &apos;POST&apos;,
dataType : &apos;json&apos;,
success : function(rs) {
if (rs.success) {
layer.msg("�����ɹ�", {
icon : 1
});
$(&apos;#infoSubmit&apos;).attr(&apos;disabled&apos;,&apos;disabled&apos;);
$(&apos;#infoSubmit&apos;).removeAttr(&apos;href&apos;);
$(&apos;#infoSubmit&apos;).unbind("click");
if ($(&apos;#id&apos;).val() == &apos;&apos;) {
$(&apos;#id&apos;).val(rs.data.id);
$(&apos;#assetId&apos;).val(rs.data.assetId);
$(&apos;#uuid&apos;).val(rs.data.uuid);
}
} else {
layer.msg(rs.errorMsg,{icon : 2});
}
}
});
}
});
},
init : function() {
var _t = this;
_t.f = $("#baseInfo");
_t.state = true;
_t.submitBtn = $("#infoSubmit", _t.f);
/* base information */
_t.name = $(".name", _t.f);
// _t.discountRate = $(".discountRate", _t.f);
_t.jname = $(".jname", _t.f);
_t.fundCode = $(".fundCode", _t.f);
// _t.riskLevel = $(".riskLevel", _t.f);
// _t.fundStrategy = $(".fundStrategy", _t.f);
_t.packagingModel = $(".packagingModel", _t.f)
_t.category = $(".category", _t.f);
_t.structure = $(".structure", _t.f);
_t.dateStart = $(".date-start", _t.f);
_t.dateEnd = $(".date-end", _t.f);
_t.dateFound = $(".found-day", _t.f);
_t.dateEnd2 = $(".end-day2", _t.f);
_t.currency1 = $(".currency1", _t.f);
_t.scale = $(".scale", _t.f);
_t.startAmount = $(".startAmount", _t.f);
_t.currency2 = $(".currency2", _t.f);
_t.lowest = $(".lowest", _t.f);
_t.currency3 = $(".currency3", _t.f);
_t.initialAmount = $(".initialAmount", _t.f);
_t.currency4 = $(".currency4", _t.f);
_t.incrementalAmount = $(".incrementalAmount", _t.f);
_t.maxInvestTZAmount = $(".maxInvestTZAmount", _t.f);
_t.processingMode = $(".processingMode", _t.f);
_t.duration = $(".duration", _t.f);
_t.openPeriod = $(".openPeriod", _t.f);
_t.closurePeriod = $(".closurePeriod", _t.f);
_t.closurePeriod2 = $(".closurePeriod2", _t.f);
_t.productIncome = $(".productIncome", _t.f);// ��Ʒ����ƾ֤
_t.investmentNumber = $(".investmentNumber", _t.f);// ��Ͷ������
_t.maxSubAmount = $(".maxSubAmount", _t.f);// �����Ϲ�����
_t.mixPerson = $(".mixPerson", _t.f);// ��Ʒ��С����
_t.maxPerson = $(".maxPerson", _t.f);// ��Ʒ��������
_t.raiseLimit = $(".raiseLimit", _t.f);// ��Ʒļ����ģ����Ԫ
// _t.subsistLimit = $(".subsistLimit", _t.f);// ��Ʒ������ģ���޷�
_t.firstMixMoney = $(".firstMixMoney", _t.f);// �״��깺���ͽ���Ԫ
_t.againMixMoney = $(".againMixMoney", _t.f);// ׷���깺���ͽ���
_t.redemptiontj = $(".redemptiontj", _t.f);// ��������
_t.productStatus = $(".productStatus", _t.f);// ��Ʒ����״̬
_t.closureRate = $(".closureRate", _t.f);
_t.lowestHoldNormalMoney = $(".lowestHoldNormalMoney", _t.f);
_t.lowestHoldNormalShare = $(".lowestHoldNormalShare", _t.f);
_t.modefityMethod = $(".modefityMethod", _t.f);
// _t.cllx = $(".cllx", _t.f);
_t.subscribeMethod = $(".subscribeMethod", _t.f);
_t.purchaseMethod = $(".purchaseMethod", _t.f);
_t.isNotAchievementGatherPay = $(".isNotAchievementGatherPay", _t.f);
/* end base information */
/* organization */
_t.investmentAdviser = $(".investmentAdviser", _t.f);
_t.fundManager = $(".fundManager", _t.f);
_t.custodian = $(".custodian", _t.f);
// _t.riskControlConsultant = $(".riskControlConsultant", _t.f);
_t.futuresOrg = $(".futuresOrg", _t.f);
_t.administrationOrg = $(".administrationOrg", _t.f);
_t.consignamentOrg = $(".consignamentOrg", _t.f);
_t.securityOrg = $(".securityOrg", _t.f);
_t.managementRate = $(".managementRate", _t.f);// ��������
_t.manageCost = $(".manageCost", _t.f);// �йܷ���
_t.subscriptionRate = $(".subscriptionRate", _t.f);
_t.purchaseReg = $(".purchaseReg", _t.f);
_t.redeemReg = $(".redeemReg", _t.f);
_t.redeemRate = $(".redeemRate", _t.f);
_t.formula = $(".formula", _t.f);
// _t.rewardRate = $(".rewardRate", _t.f);
_t.salesRate = $(".salesRate", _t.f);
// _t.maintenanceRate = $(".maintenanceRate", _t.f);
_t.briefIntroduction = $(".briefIntroduction", _t.f);
_t.warningLine = $(".warningLine", _t.f);
_t.stopLine = $(".stopLine", _t.f);
_t.fundManagerIntro = $(".fundManagerIntro", _t.f);
// _t.organizationServe = $(".organizationServe", _t.f);// �����������۷�������
_t.subscribeRebate = $(".subscribeRebate", _t.f);// �Ϲ��ۿ���
_t.purchaseRate = $(".purchaseRate", _t.f);// �깺����
// _t.excessAchievementPay = $(".excessAchievementPay", _t.f);// ����ҵ��������
_t.purchaseRebate = $(".purchaseRebate", _t.f); // �깺�ۿ���
// _t.organizationCustomerFee = $(".organizationCustomerFee", _t.f); //
// ���������ͻ�ά������
// _t.riskCounselorCode = $(".riskCounselorCode", _t.f); // ���ع���(����)
// _t.investmentAdviserCode = $(".investmentAdviserCode", _t.f); //
// Ͷ�ʹ���(����)
// _t.fundMandatorCode = $(".fundMandatorCode", _t.f); // ���(����)
// _t.administrativeManagerCode = $(".administrativeManagerCode", _t.f);
// // ������������(����)
// _t.salesOrganizationCode = $(".salesOrganizationCode", _t.f); //
// ����������(����)
// _t.securityOrganizationCode = $(".securityOrganizationCode", _t.f);
// // ֤ȯ���ͻ���(����)
// _t.futuresOrganizationCode = $(".futuresOrganizationCode", _t.f); //
// �ڻ����ͻ���(����)
_t.achievementPayTerm = $(".achievementPayTerm", _t.f);// ҵ��������ȡ����
// _t.fundManagerCode = $(".fundManagerCode", _t.f);
/* end organization */
/* product description */
_t.expectedReturnRate = $(".expectedReturnRate", _t.f);
// _t.splitRatio = $(".splitRatio", _t.f);
// _t.frequency = $(".frequency", _t.f);
_t.startYyPurchaseDate = $(".startYyPurchaseDate", _t.f);
_t.endYyPurchaseDate = $(".endYyPurchaseDate", _t.f);
_t.startYyRedemptionDate = $(".startYyRedemptionDate", _t.f);
_t.endYyRedemptionDate = $(".endYyRedemptionDate", _t.f);
_t.benchmark = $(".benchmark", _t.f);
_t.parVal = $(".parVal", _t.f);
_t.issuePrice = $(".issuePrice", _t.f);
_t.spotPrice = $(".spotPrice", _t.f);
_t.clearingPrice = $(".clearingPrice", _t.f);
_t.upperLimit = $(".upperLimit", _t.f);
_t.lowerLimit = $(".lowerLimit", _t.f);
// _t.participationRate = $(".participationRate", _t.f);
// _t.warningLine = $(".warningLine", _t.f);
// _t.stopLine = $(".stopLine", _t.f);
// _t.guaranteedRate = $(".guaranteedRate", _t.f);
_t.checkFrequency = $(".checkFrequency", _t.f);
//_t.secInvestor = $(".secInvestor", _t.f);
_t.investmentScope = $(".investmentScope", _t.f);
_t.investmentLimit = $(".investmentLimit", _t.f);
_t.investmentTarget = $(".investmentTarget", _t.f);
_t.investmentStrategy = $(".investmentStrategy", _t.f);
_t.otherInstrucetions = $(".otherInstrucetions", _t.f);
/* end product description */
/* Running info Start */
_t.subscribeDays = $(".subscribeDays", _t.f);
_t.cfmDays = $(".cfmDays", _t.f);
_t.purchaseCfmDays = $(".purchaseCfmDays", _t.f);
_t.redemptionDays = $(".redemptionDays", _t.f);
_t.redemptionCfmDays = $(".redemptionCfmDays", _t.f);
_t.redemptionDays = $(".redemptionDays", _t.f);
_t.dividendDeliveryDays = $(".dividendDeliveryDays", _t.f);// �ֺ콻������
_t.lqdfundsDeliveryDays = $(".lqdfundsDeliveryDays", _t.f);// �����������
_t.raiseAccName = $(".raiseAccName", _t.f);// ļ���˻��˻���
_t.seccfmFailrfndDeliveryDays = $(".seccfmFailrfndDeliveryDays", _t.f);// ����ȷ��ʧ���˿������
_t.raiseFailRfndDeliveryDays = $(".raiseFailRfndDeliveryDays", _t.f);// ļ��ʧ���˿������
_t.raiseAccNo = $(".raiseAccNo", _t.f);// ļ���˻��˺�
_t.raiseAccBankName = $(".raiseAccBankName", _t.f);// ļ���˻�������
_t.purchaseDeliveryDays = $(".purchaseDeliveryDays", _t.f);// �깺��������
_t.raiseAccCnapsCode = $(".raiseAccCnapsCode", _t.f);// ļ�������к�
_t.lqdAccCnapsCode = $(".lqdAccCnapsCode", _t.f);// ���㻧���к�
_t.taCode = $(".taCode", _t.f);// TA����
/* Running info End */
/* attachment */
_t.popularOpinion = $(".popularOpinion", _t.f);
_t.riskControlOpinion = $(".riskControlOpinion", _t.f);
_t.messageShow = $(".messageShow", _t.f);
/*
* _t.startTime = $(".startTime",_t.f); _t.endTime = $(".endTime",_t.f);
*/
/* end attachment */
_t.txt = $("input.form-control", _t.f)
_t.sel = $("select.form-control", _t.f);
_t.date = $(".date-start,.date-end,.found-day,.date-end2,.startYyPurchaseDate,.endYyPurchaseDate", _t.f);
_t.objReadOnly = $(
".parVal,.issuePrice,.spotPrice,.clearingPrice,.upperLimit,.lowerLimit",
_t.f);
_t.bind();
}
};
// init dom ready
$(function() {
pef.datetimepicker();
pef.formCheck.init();
// $(".a-mun").blur(function(){
// $(this).val(formatNumber($(this).val(),2));
// });
// if (!$("#fundManagerDesc").attr("readonly")) {
// $("#fundManagerDesc").jSuggest({
// loadingImg : getRootPath() + "/static/img/ajax-loader.gif",
// url : getRootPath() + "/jsuggest/getSupplierList",
// beforeSubmit : function() {
// $("#fundManager").val("");
// $("#fundManagerCode").val("");
// $("#fundManagerIntro").val("");
// },
// showBack : function(objLi, textBox, data) {
// $(textBox).val(objLi.html());
// $("#fundManager").val(objLi.html());
// $("#fundManagerCode").val(objLi.attr("id"));
// $("#fundManagerIntro").val(objLi.attr("compintro"));
// }
// });
// }
if (!$("#investmentAdviserDesc").attr("readonly")) {
$("#investmentAdviserDesc").jSuggest({
loadingImg : getRootPath() + "/static/img/ajax-loader.gif",
url : getRootPath() + "/jsuggest/getInvestmentAdviserList",
beforeSubmit : function() {
$("#investmentAdviser").val("");
$("#investmentAdviserCode").val("");
},
showBack : function(objLi, textBox, data) {
$(textBox).val(objLi.html());
$("#investmentAdviser").val(objLi.html());
$("#investmentAdviserCode").val(objLi.attr("id"));
}
});
}
// if (!$("#fundMandatorDesc").attr("readonly")) {
// $("#fundMandatorDesc").jSuggest({
// loadingImg : getRootPath() + "/static/img/ajax-loader.gif",
// url : getRootPath() + "/jsuggest/getSupplierList",
// beforeSubmit : function() {
// $("#fundMandator").val("");
// },
// showBack : function(objLi, textBox, data) {
// $(textBox).val(objLi.html());
// $("#fundMandator").val(objLi.html());
// }
// });
// }
// if (!$("#riskCounselorDesc").attr("readonly")) {
// $("#riskCounselorDesc").jSuggest({
// loadingImg : getRootPath() + "/static/img/ajax-loader.gif",
// url : getRootPath() + "/jsuggest/getSupplierList",
// beforeSubmit : function() {
// $("#riskCounselor").val("");
// },
// showBack : function(objLi, textBox, data) {
// $(textBox).val(objLi.html());
// $("#riskCounselor").val(objLi.html());
// }
// });
// }
$("#productYield")
.bind(
"change",
function() {
if ($("#productYield").val() == &apos;1&apos;) {
$("#openRule").show();
$("#openNumber").show();
$("#purchaseOpenNumber").addClass(
"purchaseOpenNumber");
$("#redemptionOpenNumber").addClass(
"redemptionOpenNumber");
$("#purchaseOpenRule").addClass("purchaseOpenRule");
$("#redemptionOpenRule").addClass(
"redemptionOpenRule");
$("#isNotModefityShowMethod").addClass(
"isNotModefityShowMethod");
} else {
$("#openRule").hide();
$("#openNumber").hide();
$("#purchaseMKRule").hide();
$("#purchaseMVRule").hide();
$("#purchaseDKRule").hide();
$("#purchaseDVRule").hide();
$("#redemptionMKRule").hide();
$("#redemptionMVRule").hide();
$("#redemptionDKRule").hide();
$("#redemptionDVRule").hide();
$("#purchaseOpenNumber").removeClass(
"purchaseOpenNumber");
$("#redemptionOpenNumber").removeClass(
"redemptionOpenNumber");
$("#purchaseOpenRule").removeClass(
"purchaseOpenRule");
$("#redemptionOpenRule").removeClass(
"redemptionOpenRule");
$("#purchaseOpenMons").removeClass(
"purchaseOpenMons");
$("#purchaseOpenDays").removeClass(
"purchaseOpenDays");
$("#redemptionOpenMons").removeClass(
"redemptionOpenMons");
$("#redemptionOpenDays").removeClass(
"redemptionOpenDays");
$("#isNotModefityShowMethod").removeClass(
"isNotModefityShowMethod");
}
});
$("#purchaseOpenRule").bind(
"change",
function() {
var purchaseOpenRule = $("#purchaseOpenRule").val();
if (purchaseOpenRule == &apos;0&apos; || purchaseOpenRule == &apos;1&apos;
|| purchaseOpenRule == &apos;5&apos; || purchaseOpenRule == &apos;16&apos;
|| purchaseOpenRule == &apos;17&apos;) {
$("#purchaseRule").hide();
$("#purchaseMKRule").hide();
$("#purchaseMVRule").hide();
$("#purchaseDKRule").hide();
$("#purchaseDVRule").hide();
$("#purchaseOpenMons").val("");
$("#purchaseOpenDays").val("");
// $("#purchaseMRule").hide();
// $("#purchaseDRule").hide();
$("#purchaseOpenMons").removeClass("purchaseOpenMons");
$("#purchaseOpenDays").removeClass("purchaseOpenDays");
} else if (purchaseOpenRule == &apos;2&apos; || purchaseOpenRule == &apos;3&apos;
|| purchaseOpenRule == &apos;4&apos; || purchaseOpenRule == &apos;6&apos;) {
$("#purchaseRule").show();
$("#purchaseMKRule").hide();
$("#purchaseMVRule").hide();
$("#purchaseOpenMons").val("");
$("#purchaseOpenMons").removeClass("purchaseOpenMons");
$("#purchaseDKRule").show();
$("#purchaseDVRule").show();
$("#purchaseOpenDays").addClass("purchaseOpenDays");
} else if (purchaseOpenRule == &apos;9&apos; || purchaseOpenRule == &apos;12&apos;
|| purchaseOpenRule == &apos;15&apos;) {
$("#purchaseRule").show();
$("#purchaseMKRule").show();
$("#purchaseMVRule").show();
$("#purchaseDKRule").hide();
$("#purchaseDVRule").hide();
$("#purchaseOpenDays").val("");
$("#purchaseOpenMons").addClass("purchaseOpenMons");
$("#purchaseOpenDays").removeClass("purchaseOpenDays");
} else {
$("#purchaseRule").show();
$("#purchaseMKRule").show();
$("#purchaseMVRule").show();
$("#purchaseDKRule").show();
$("#purchaseDVRule").show();
$("#purchaseOpenMons").addClass("purchaseOpenMons");
$("#purchaseOpenDays").addClass("purchaseOpenDays");
}
});
$("#redemptionOpenRule").bind(
"change",
function() {
var redemptionOpenRule = $("#redemptionOpenRule").val();
if (redemptionOpenRule == &apos;0&apos; || redemptionOpenRule == &apos;1&apos;
|| redemptionOpenRule == &apos;5&apos;
|| redemptionOpenRule == &apos;16&apos;
|| redemptionOpenRule == &apos;17&apos;) {
$("#redemptionRule").hide();
$("#redemptionMKRule").hide();
$("#redemptionMVRule").hide();
$("#redemptionDKRule").hide();
$("#redemptionDVRule").hide();
$("#redemptionOpenMons").val("");
$("#redemptionOpenDays").val("");
// $("#redemptionMRule").hide();
// $("#redemptionDRule").hide();
$("#redemptionOpenMons").removeClass("redemptionOpenMons");
$("#redemptionOpenDays").removeClass("redemptionOpenDays");
} else if (redemptionOpenRule == &apos;2&apos;
|| redemptionOpenRule == &apos;3&apos;
|| redemptionOpenRule == &apos;4&apos;
|| redemptionOpenRule == &apos;6&apos;) {
$("#redemptionRule").show();
$("#redemptionMKRule").hide();
$("#redemptionMVRule").hide();
$("#redemptionOpenMons").val("");
$("#redemptionDKRule").show();
$("#redemptionDVRule").show();
$("#redemptionOpenMons").removeClass("redemptionOpenMons");
$("#redemptionOpenDays").addClass("redemptionOpenDays");
} else if (redemptionOpenRule == &apos;9&apos;
|| redemptionOpenRule == &apos;12&apos;
|| redemptionOpenRule == &apos;15&apos;) {
$("#redemptionRule").show();
$("#redemptionMKRule").show();
$("#redemptionMVRule").show();
$("#redemptionDKRule").hide();
$("#redemptionDVRule").hide();
$("#redemptionOpenDays").val("");
$("#redemptionOpenMons").addClass("redemptionOpenMons");
$("#redemptionOpenDays").removeClass("redemptionOpenDays");
} else {
$("#redemptionRule").show();
$("#redemptionMKRule").show();
$("#redemptionMVRule").show();
$("#redemptionDKRule").show();
$("#redemptionDVRule").show();
$("#redemptionOpenMons").addClass("redemptionOpenMons");
$("#redemptionOpenDays").addClass("redemptionOpenDays");
}
});
// ��ʼԤԼ���صǼ��գ������գ���"�Ƿ���ҪԤԼ���صǼ�"ѡ���ǣ������룬�����϶�Ϊ0
// ����ԤԼ���صǼ��գ������գ���"�Ƿ���ҪԤԼ���صǼ�"ѡ���ǣ������룬�����϶�Ϊ0
$("#isNotYyRedemptionRegister").bind(
"change",
function() {
var isNotYyRedemptionRegister = $("#isNotYyRedemptionRegister")
.val();
if (isNotYyRedemptionRegister == &apos;1&apos;) {
$("#startYyRedemptionDate").val("");
$("#startYyRedemptionDate").attr("readonly", false);
$("#endYyRedemptionDate").val("");
$("#endYyRedemptionDate").attr("readonly", false);
} else if (isNotYyRedemptionRegister == &apos;0&apos;) {
$("#startYyRedemptionDate").val(&apos;0&apos;);
$("#startYyRedemptionDate").attr("readonly", true);
$("#endYyRedemptionDate").val(&apos;0&apos;);
$("#endYyRedemptionDate").attr("readonly", true);
}
});
// $("#isNotYyPurchaseRegister").bind(
// "change",
// function() {
// var isNotYyPurchaseRegister = $("#isNotYyPurchaseRegister")
// .val();
// if (isNotYyPurchaseRegister == &apos;1&apos;) {
// $("#startYyPurchaseDate").val("");
// $("#startYyPurchaseDate").attr("readonly", false);
// $("#endYyPurchaseDate").val("");
// $("#endYyPurchaseDate").attr("readonly", false);
// } else if (isNotYyPurchaseRegister == &apos;0&apos;) {
// $("#startYyPurchaseDate").val(&apos;0&apos;);
// $("#startYyPurchaseDate").attr("readonly", true);
// $("#endYyPurchaseDate").val(&apos;0&apos;);
// $("#endYyPurchaseDate").attr("readonly", true);
// }
// });
// ��ҵ�������ֳɾ���������ת��˰��"��ҵ�������ֳ��Ƿ񾭹�������ת"Ҫ��Ϊ"��"������
$("#isNotRomAchievementPay").bind("change", function() {
var isNotRomAchievementPay = $("#isNotRomAchievementPay").val() == &apos;1&apos;;
if (isNotRomAchievementPay) {
$("#cessAchievementPay").removeAttr("readonly");
} else {
$("#cessAchievementPay").attr("readonly", "readonly");
}
});
$("#isNotSaleServe").bind("change", function() {
var isNotSaleServe = $("#isNotSaleServe").val() == &apos;1&apos;;
if (isNotSaleServe) {
$("#cessSaleServe").removeAttr("readonly");
} else {
$("#cessSaleServe").attr("readonly", "readonly");
}
});
// ���ͻ�ά���Ѿ���������ת��˰��"���ͻ�ά�����Ƿ񾭹�������ת"Ҫ��Ϊ"��"������
$("#isNotRomCustomerFee").bind("change", function() {
var isNotRomCustomerFee = $("#isNotRomCustomerFee").val() == &apos;1&apos;;
if (isNotRomCustomerFee) {
$("#cessCustomerFee").removeAttr("readonly");
} else {
$("#cessCustomerFee").attr("readonly", "readonly");
}
});
//���ͻ�ά������ѡ���޻���0 �����ͻ�ά���ѽ���Ƶ�� ��Ӧ¼��
$("#customerServeRate").bind("change", function() {
var customerServeRate = $("#customerServeRate").val() != &apos;&apos; && parseFloat($("#customerServeRate").val()) != &apos;0&apos; && $("#customerServeRate").val() != null
if (customerServeRate) {
$("#customerFeeMethod").removeAttr("disabled");
} else {
$("#customerFeeMethod").val("0");
$("#customerFeeMethod").attr("disabled", "disabled");
}
});
//�Ƿ������طѷֳ�ѡ���� ��ô�����������طѷֳ� �û�
$("#isNotRedemptionFallInto").bind("change", function() {
var isNotRedemptionFallInto = $("#isNotRedemptionFallInto").val() ==&apos;0&apos;;
if (isNotRedemptionFallInto) {
$("#organizationRedemption").val("");
$("#organizationRedemption").attr("disabled", "disabled");
} else {
$("#organizationRedemption").removeAttr("disabled");
}
});
//�Ƿ���ȡҵ������ѡ���� ��ô����ҵ�������� �û�
$("#isNotAchievementGatherPay").bind("change", function() {
var isNotAchievementGatherPay = $("#isNotAchievementGatherPay").val() ==&apos;0&apos;;
if (isNotAchievementGatherPay) {
$("#excessAchievementPay").val("");
$("#excessAchievementPay").attr("disabled", "disabled");
} else {
$("#excessAchievementPay").removeAttr("disabled");
}
});
//�����������䷽ʽ���ڷDZ��� �����ձ��� �������� earningsAllotWay
// $("#productYield").bind("change", function() {
// var productYield = $("#productYield").val() == &apos;0&apos;;
// if (productYield) {
// $("#earningsAllotWaySpan").html("*");
// $("#earningsAllotWay").addClass("earningsAllotWay");
// } else {
// $("#earningsAllotWaySpan").html("");
// $("#earningsAllotWay").removeClass("earningsAllotWay");
// if($("#earningsAllotWay").hasClass("warncolor")) {
// $("#earningsAllotWay").removeClass("warncolor");
// $("#earningsAllotWay").siblings(".alter").html("");
// }
// }
// });
//����ѡ�������ڵ�λ�еġ�����������ô�������DZ�����
$("#durationTimeUnits").bind("change", function() {
var durationTimeUnits = $("#durationTimeUnits").val() == &apos;6&apos;;
if (durationTimeUnits) {
$("#durationTimeSpan").html("");
$("#durationTime").val("");
$("#durationTime").attr("readonly", "readonly");
$("#durationTime").removeClass("warncolor");
$("#durationTime").removeClass("duration");
} else {
$("#durationTimeSpan").html("*");
$("#durationTime").removeAttr("readonly");
$("#durationTime").addClass("duration");
if($("#durationTime").hasClass("warncolor")){
$("#durationTimeSpan").removeClass("warncolor");
}
}
});
// ������Ʒ����ѡ�񡰹����͡�ʱ�����������������ڱ�ѡ��;productSonType
$("#productSonType").bind("change", function() {
var productSonType = $("#productSonType").val() == &apos;D&apos;;
if (productSonType) {
isRequired("fundStrategy", true);
} else {
isRequired("fundStrategy", false);
}
});
// ���ط�
$("#isNotRomRedemption").bind("change", function() {
var isNotRomRedemption = $("#isNotRomRedemption").val() == &apos;1&apos;;
if (isNotRomRedemption) {
$("#cessRedemption").removeAttr("readonly");
} else {
$("#cessRedemption").attr("readonly", "readonly");
}
});
// ������
$("#managerFeeIsRoam").bind("change", function() {
var managerFeeIsRoam = $("#managerFeeIsRoam").val() == &apos;1&apos;;
if (managerFeeIsRoam) {
$("#managerFeeCess").removeAttr("readonly");
} else {
$("#managerFeeCess").attr("readonly", "readonly");
}
});
});
function isRequired(id, isRequired) {
if (isRequired) {
$("#" + id + "Span").html("*");
if(!$("#" + id).hasClass(id)) {
$("#" + id).addClass(id);
}
} else {
$("#" + id + "Span").html("");
$("#" + id).val("");
if($("#" + id).hasClass(id)) {
$("#" + id).removeClass(id);
}
if ($("#" + id).hasClass("warncolor")) {
$("#" + id).removeClass("warncolor");
$("#" + id).siblings(".alter").html("");
}
}
}
function test(id) {
var value = $("#" + id).val();
if (value == "" || value == null) {
$("#" + id).removeAttr("readonly");
}
}
//function customerChange(id) {
// if(id=="customerServeRate"){
// var customerServeRate=$("#customerServeRate").val();
// if(customerServeRate==""||customerServeRate=="0" ||customerServeRate == null){
// $("#customerFeeMethod").attr("readonly", "readonly");
// }else{
// $("#customerFeeMethod").removeAttr("readonly");
// }
// }
//}
function test1(id) {
if (id == "lowestHoldNormalMoney") {
var v1 = $("#lowestHoldNormalShare").val();
if (v1 != "" && v1 != null) {
$("#lowestHoldNormalMoney").attr("readonly", true);
} else {
$("#lowestHoldNormalShare").attr("readonly", true);
$("#lowestHoldNormalMoney").attr("readonly", false);
}
}
if (id == "lowestHoldNormalShare") {
var v1 = $("#lowestHoldNormalMoney").val();
if (v1 != "" && v1 != null) {
$("#lowestHoldNormalShare").attr("readonly", true);
} else {
$("#lowestHoldNormalShare").attr("readonly", false);
$("#lowestHoldNormalMoney").attr("readonly", true);
}
}
}
�깺������
-- Create table
create table PEF_PURCHASE_APPLY
(
id NUMBER(32) not null,
appsheetserialno VARCHAR2(24),
currencytype VARCHAR2(3),
fundcode VARCHAR2(6),
transactiondate VARCHAR2(8),
transactionaccountid VARCHAR2(17),
distributorcode VARCHAR2(9),
applicationamount NUMBER(16,2),
businesscode VARCHAR2(3),
taaccountid VARCHAR2(12),
branchcode VARCHAR2(9),
transactiontime VARCHAR2(6),
shareclass VARCHAR2(1),
raisefee NUMBER(16,2),
plannerno VARCHAR2(16),
handletradedate VARCHAR2(8),
institutioncode VARCHAR2(6),
process_status VARCHAR2(32),
is_delete VARCHAR2(20 CHAR) not null,
create_by VARCHAR2(20 CHAR) not null,
update_by VARCHAR2(20 CHAR) not null,
create_date DATE not null,
update_date DATE not null,
investorname VARCHAR2(120) not null
)
tablespace BSYS_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column PEF_PURCHASE_APPLY.id
is &apos;��������&apos;;
comment on column PEF_PURCHASE_APPLY.appsheetserialno
is &apos;���뵥����&apos;;
comment on column PEF_PURCHASE_APPLY.currencytype
is &apos;��������&apos;;
comment on column PEF_PURCHASE_APPLY.fundcode
is &apos;��������&apos;;
comment on column PEF_PURCHASE_APPLY.transactiondate
is &apos;���׷�������&apos;;
comment on column PEF_PURCHASE_APPLY.transactionaccountid
is &apos;Ͷ���˻��������˺�&apos;;
comment on column PEF_PURCHASE_APPLY.distributorcode
is &apos;�����˴���&apos;;
comment on column PEF_PURCHASE_APPLY.applicationamount
is &apos;��������&apos;;
comment on column PEF_PURCHASE_APPLY.businesscode
is &apos;ҵ������&apos;;
comment on column PEF_PURCHASE_APPLY.taaccountid
is &apos;Ͷ���˻����˺�&apos;;
comment on column PEF_PURCHASE_APPLY.branchcode
is &apos;��������&apos;;
comment on column PEF_PURCHASE_APPLY.transactiontime
is &apos;���׷���ʱ��&apos;;
comment on column PEF_PURCHASE_APPLY.shareclass
is &apos;�շѷ�ʽ&apos;;
comment on column PEF_PURCHASE_APPLY.raisefee
is &apos;�Ϲ��� ��0-ǰ�շѣ�1-���շѣ�&apos;;
comment on column PEF_PURCHASE_APPLY.plannerno
is &apos;����ʦ����&apos;;
comment on column PEF_PURCHASE_APPLY.handletradedate
is &apos;���������� ���ݹ鲢������������&apos;;
comment on column PEF_PURCHASE_APPLY.institutioncode
is &apos;��������&apos;;
comment on column PEF_PURCHASE_APPLY.process_status
is &apos;����״̬��0000�������룬0001���ɹ���0002��ʧ�ܣ�&apos;;
comment on column PEF_PURCHASE_APPLY.is_delete
is &apos;ɾ����ʾ(0δɾ����1ɾ��)&apos;;
comment on column PEF_PURCHASE_APPLY.create_by
is &apos;������&apos;;
comment on column PEF_PURCHASE_APPLY.update_by
is &apos;�޸���&apos;;
comment on column PEF_PURCHASE_APPLY.create_date
is &apos;��������&apos;;
comment on column PEF_PURCHASE_APPLY.update_date
is &apos;�޸�����&apos;;
comment on column PEF_PURCHASE_APPLY.investorname
is &apos;Ͷ��������&apos;;
-- Create/Recreate primary, unique and foreign key constraints
alter table PEF_PURCHASE_APPLY
add constraint PK_PEF_PURCHASE_APPLY primary key (ID)
using index
tablespace BSYS_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Grant/Revoke object privileges
grant insert on PEF_PURCHASE_APPLY to BSYSTEM_INSERT;
grant select on PEF_PURCHASE_APPLY to BSYSTEM_SELECT;
grant update on PEF_PURCHASE_APPLY to BSYSTEM_UPDATE;
�깺ȷ�ϱ�
--------------------------------------------------
-- Create table
create table PEF_PURCHASE_SURE
(
id NUMBER(32) not null,
shareclass VARCHAR2(1),
transferfee NUMBER(10,2),
taserialno VARCHAR2(20),
transactiontime VARCHAR2(6),
branchcode VARCHAR2(9),
nav NUMBER(7,4),
agencyfee NUMBER(10,2),
charge NUMBER(10,2),
downloaddate VARCHAR2(8),
taaccountid VARCHAR2(12),
businesscode VARCHAR2(3),
applicationamount NUMBER(16,2),
distributorcode VARCHAR2(9),
transactionaccountid VARCHAR2(17),
returncode VARCHAR2(4),
transactiondate VARCHAR2(8),
fundcode VARCHAR2(6),
confirmedamount NUMBER(16,2),
confirmedvol NUMBER(16,2),
currencytype VARCHAR2(3),
transactioncfmdate VARCHAR2(8),
appsheetserialno VARCHAR2(24),
handletradedate VARCHAR2(8),
institutioncode VARCHAR2(6),
is_delete VARCHAR2(20 CHAR) not null,
create_by VARCHAR2(20 CHAR) not null,
update_by VARCHAR2(20 CHAR) not null,
create_date DATE not null,
update_date DATE not null
)
tablespace BSYS_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table PEF_PURCHASE_SURE
is &apos;�깺ȷ��&apos;;
-- Add comments to the columns
comment on column PEF_PURCHASE_SURE.id
is &apos;��������&apos;;
comment on column PEF_PURCHASE_SURE.shareclass
is &apos;�շѷ�ʽ&apos;;
comment on column PEF_PURCHASE_SURE.transferfee
is &apos;������&apos;;
comment on column PEF_PURCHASE_SURE.taserialno
is &apos;TAȷ�Ͻ�����ˮ��&apos;;
comment on column PEF_PURCHASE_SURE.transactiontime
is &apos;���׷���ʱ��&apos;;
comment on column PEF_PURCHASE_SURE.branchcode
is &apos;��������&apos;;
comment on column PEF_PURCHASE_SURE.nav
is &apos;������λ��ֵ&apos;;
comment on column PEF_PURCHASE_SURE.agencyfee
is &apos;������&apos;;
comment on column PEF_PURCHASE_SURE.charge
is &apos;������&apos;;
comment on column PEF_PURCHASE_SURE.downloaddate
is &apos;���������´�����&apos;;
comment on column PEF_PURCHASE_SURE.taaccountid
is &apos;Ͷ���˻����˺�&apos;;
comment on column PEF_PURCHASE_SURE.businesscode
is &apos;ҵ������&apos;;
comment on column PEF_PURCHASE_SURE.applicationamount
is &apos;��������&apos;;
comment on column PEF_PURCHASE_SURE.distributorcode
is &apos;�����˴���&apos;;
comment on column PEF_PURCHASE_SURE.transactionaccountid
is &apos;Ͷ���˻��������˺�&apos;;
comment on column PEF_PURCHASE_SURE.returncode
is &apos;���״������ش���&apos;;
comment on column PEF_PURCHASE_SURE.transactiondate
is &apos;���׷�������&apos;;
comment on column PEF_PURCHASE_SURE.fundcode
is &apos;��������&apos;;
comment on column PEF_PURCHASE_SURE.confirmedamount
is &apos;ÿ�ʽ���ȷ�Ͻ���&apos;;
comment on column PEF_PURCHASE_SURE.confirmedvol
is &apos;�����˻�����ȷ�Ϸ���&apos;;
comment on column PEF_PURCHASE_SURE.currencytype
is &apos;��������&apos;;
comment on column PEF_PURCHASE_SURE.transactioncfmdate
is &apos;����ȷ������&apos;;
comment on column PEF_PURCHASE_SURE.appsheetserialno
is &apos;���뵥����&apos;;
comment on column PEF_PURCHASE_SURE.handletradedate
is &apos;���������� ���ݹ鲢������������&apos;;
comment on column PEF_PURCHASE_SURE.institutioncode
is &apos;��������&apos;;
comment on column PEF_PURCHASE_SURE.is_delete
is &apos;ɾ����ʾ(0δɾ����1ɾ��)&apos;;
comment on column PEF_PURCHASE_SURE.create_by
is &apos;������&apos;;
comment on column PEF_PURCHASE_SURE.update_by
is &apos;�޸���&apos;;
comment on column PEF_PURCHASE_SURE.create_date
is &apos;��������&apos;;
comment on column PEF_PURCHASE_SURE.update_date
is &apos;�޸�����&apos;;
-- Create/Recreate primary, unique and foreign key constraints
alter table PEF_PURCHASE_SURE
add constraint PK_PEF_PURCHASE_SURE primary key (ID)
using index
tablespace BSYS_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Grant/Revoke object privileges
grant insert on PEF_PURCHASE_SURE to BSYSTEM_INSERT;
grant select on PEF_PURCHASE_SURE to BSYSTEM_SELECT;
grant update on PEF_PURCHASE_SURE to BSYSTEM_UPDATE;
ļ��ʧ�ܱ�
-----------------------------------------------------
-- Create table
create table PEF_RAISE_FAIL
(
id NUMBER(18) not null,
transactioncfm_date VARCHAR2(32),
currency_type VARCHAR2(32),
confirmed_amount NUMBER(32,2),
fund_code VARCHAR2(32),
interest NUMBER(16,2),
transaction_date VARCHAR2(32),
transaction_account_id VARCHAR2(32),
distributor_code VARCHAR2(32),
application_amount NUMBER(32,2),
business_code VARCHAR2(32),
taaccount_id VARCHAR2(32),
interest_tax NUMBER(32,2),
deposit_acct VARCHAR2(32),
trans_date_throughclear_age VARCHAR2(32),
download_date VARCHAR2(32),
ta_serialno VARCHAR2(32),
raise_interest NUMBER(32,2),
refund_amount NUMBER(32,2),
share_class VARCHAR2(32),
is_delete VARCHAR2(32) default 0 not null,
create_by VARCHAR2(64) not null,
create_date DATE not null,
update_by VARCHAR2(64) not null,
update_date DATE not null,
handletradedate VARCHAR2(8),
institutioncode VARCHAR2(6),
appsheetserialno VARCHAR2(32),
confirmedvol NUMBER(16,2),
returncode VARCHAR2(8),
discountrateofcommission NUMBER(5,4),
regioncode VARCHAR2(8),
charge NUMBER(10,2),
agencyfee NUMBER(10,2),
branchcode VARCHAR2(16),
transactiontime VARCHAR2(8),
otherfee1 NUMBER(10,2),
individualorinstitution VARCHAR2(8),
tradingprice NUMBER(7,4),
stampduty NUMBER(16,2),
transferfee NUMBER(10,2),
volumebyinterest NUMBER(16,2),
feecalculator VARCHAR2(8)
)
tablespace BSYS_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table PEF_RAISE_FAIL
is &apos;ļ��ʧ��&apos;;
-- Add comments to the columns
comment on column PEF_RAISE_FAIL.id
is &apos;��������&apos;;
comment on column PEF_RAISE_FAIL.transactioncfm_date
is &apos;����ȷ������&apos;;
comment on column PEF_RAISE_FAIL.currency_type
is &apos;��������&apos;;
comment on column PEF_RAISE_FAIL.confirmed_amount
is &apos;ÿ�ʽ���ȷ�Ͻ���&apos;;
comment on column PEF_RAISE_FAIL.fund_code
is &apos;��������&apos;;
comment on column PEF_RAISE_FAIL.interest
is &apos;�����˻���Ϣ����(�Ϲ�һ��ȷ�ϵĽ�����������Ϣ�����в�������Ϣ)&apos;;
comment on column PEF_RAISE_FAIL.transaction_date
is &apos;���׷�������(��ʽΪ��YYYYMMDD)&apos;;
comment on column PEF_RAISE_FAIL.transaction_account_id
is &apos;Ͷ���˻��������˺�(Ͷ���������ۻ����ڿ��������ڽ��׵��˺�)&apos;;
comment on column PEF_RAISE_FAIL.distributor_code
is &apos;�����˴���&apos;;
comment on column PEF_RAISE_FAIL.application_amount
is &apos;��������&apos;;
comment on column PEF_RAISE_FAIL.business_code
is &apos;ҵ������&apos;;
comment on column PEF_RAISE_FAIL.taaccount_id
is &apos;Ͷ���˻����˺�&apos;;
comment on column PEF_RAISE_FAIL.interest_tax
is &apos;��Ϣ˰&apos;;
comment on column PEF_RAISE_FAIL.deposit_acct
is &apos;Ͷ�����������˴����ڽ��׵��ʽ��˺�&apos;;
comment on column PEF_RAISE_FAIL.trans_date_throughclear_age
is &apos;�����ʽ��������˻�������&apos;;
comment on column PEF_RAISE_FAIL.download_date
is &apos;���������´�����&apos;;
comment on column PEF_RAISE_FAIL.ta_serialno
is &apos;TAȷ�Ͻ�����ˮ��&apos;;
comment on column PEF_RAISE_FAIL.raise_interest
is &apos;�Ϲ��ڼ���Ϣ&apos;;
comment on column PEF_RAISE_FAIL.refund_amount
is &apos;�˿�����&apos;;
comment on column PEF_RAISE_FAIL.share_class
is &apos;�շѷ�ʽ(0-ǰ�շѣ�1-���շ�)&apos;;
comment on column PEF_RAISE_FAIL.is_delete
is &apos;ɾ����ʾ(0δɾ����1ɾ��)&apos;;
comment on column PEF_RAISE_FAIL.create_by
is &apos;������&apos;;
comment on column PEF_RAISE_FAIL.create_date
is &apos;��������&apos;;
comment on column PEF_RAISE_FAIL.update_by
is &apos;�޸���&apos;;
comment on column PEF_RAISE_FAIL.update_date
is &apos;�޸�����&apos;;
comment on column PEF_RAISE_FAIL.appsheetserialno
is &apos;���뵥����&apos;;
comment on column PEF_RAISE_FAIL.confirmedvol
is &apos;�����˻�����ȷ�Ϸ���&apos;;
comment on column PEF_RAISE_FAIL.returncode
is &apos;���״������ش���&apos;;
comment on column PEF_RAISE_FAIL.discountrateofcommission
is &apos;����Ӷ���ۿ���&apos;;
comment on column PEF_RAISE_FAIL.regioncode
is &apos;�������ڵ�������&apos;;
comment on column PEF_RAISE_FAIL.charge
is &apos;������&apos;;
comment on column PEF_RAISE_FAIL.agencyfee
is &apos;������&apos;;
comment on column PEF_RAISE_FAIL.branchcode
is &apos;��������&apos;;
comment on column PEF_RAISE_FAIL.transactiontime
is &apos;���׷���ʱ��&apos;;
comment on column PEF_RAISE_FAIL.otherfee1
is &apos;��������1&apos;;
comment on column PEF_RAISE_FAIL.individualorinstitution
is &apos;����/������־&apos;;
comment on column PEF_RAISE_FAIL.tradingprice
is &apos;���׼۸�&apos;;
comment on column PEF_RAISE_FAIL.stampduty
is &apos;ӡ��˰&apos;;
comment on column PEF_RAISE_FAIL.transferfee
is &apos;������&apos;;
comment on column PEF_RAISE_FAIL.volumebyinterest
is &apos;��Ϣ�����Ļ�������&apos;;
comment on column PEF_RAISE_FAIL.feecalculator
is &apos;�Ʒ���&apos;;
-- Create/Recreate primary, unique and foreign key constraints
alter table PEF_RAISE_FAIL
add primary key (ID)
using index
tablespace BSYS_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Grant/Revoke object privileges
grant select, insert on PEF_RAISE_FAIL to BSYSTEM_APP;
grant insert on PEF_RAISE_FAIL to BSYSTEM_INSERT;
grant select on PEF_RAISE_FAIL to BSYSTEM_SELECT;
grant update on PEF_RAISE_FAIL to BSYSTEM_UPDATE;
��������
--------------------------------------------------
-- Create table
create table PEF_REDEMPTION_APPLY
(
id NUMBER(32) not null,
appsheetserialno VARCHAR2(24),
fundcode VARCHAR2(6),
largeredemptionflag VARCHAR2(1),
transactiondate VARCHAR2(8),
transactionaccountid VARCHAR2(17),
distributorcode VARCHAR2(9),
applicationvol NUMBER(16,2),
businesscode VARCHAR2(3),
taaccountid VARCHAR2(12),
branchcode VARCHAR2(9),
transactiontime VARCHAR2(6),
shareclass VARCHAR2(1),
chargetype VARCHAR2(1),
handletradedate VARCHAR2(8),
institutioncode VARCHAR2(6),
processstatus VARCHAR2(32),
is_delete VARCHAR2(20 CHAR) not null,
create_by VARCHAR2(20 CHAR) not null,
update_by VARCHAR2(20 CHAR) not null,
create_date DATE not null,
update_date DATE not null
)
tablespace BSYS_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table PEF_REDEMPTION_APPLY
is &apos;��������&apos;;
-- Add comments to the columns
comment on column PEF_REDEMPTION_APPLY.id
is &apos;��������&apos;;
comment on column PEF_REDEMPTION_APPLY.appsheetserialno
is &apos;���뵥����&apos;;
comment on column PEF_REDEMPTION_APPLY.fundcode
is &apos;��������&apos;;
comment on column PEF_REDEMPTION_APPLY.largeredemptionflag
is &apos;�޶����ش�����־&apos;;
comment on column PEF_REDEMPTION_APPLY.transactiondate
is &apos;���׷�������&apos;;
comment on column PEF_REDEMPTION_APPLY.transactionaccountid
is &apos;Ͷ���˻��������˺�&apos;;
comment on column PEF_REDEMPTION_APPLY.distributorcode
is &apos;�����˴���&apos;;
comment on column PEF_REDEMPTION_APPLY.applicationvol
is &apos;������������&apos;;
comment on column PEF_REDEMPTION_APPLY.businesscode
is &apos;ҵ������&apos;;
comment on column PEF_REDEMPTION_APPLY.taaccountid
is &apos;Ͷ���˻����˺�&apos;;
comment on column PEF_REDEMPTION_APPLY.branchcode
is &apos;��������&apos;;
comment on column PEF_REDEMPTION_APPLY.transactiontime
is &apos;���׷���ʱ��&apos;;
comment on column PEF_REDEMPTION_APPLY.shareclass
is &apos;�շѷ�ʽ&apos;;
comment on column PEF_REDEMPTION_APPLY.chargetype
is &apos;�շ�����&apos;;
comment on column PEF_REDEMPTION_APPLY.handletradedate
is &apos;���������� ���ݹ鲢������������&apos;;
comment on column PEF_REDEMPTION_APPLY.institutioncode
is &apos;��������&apos;;
comment on column PEF_REDEMPTION_APPLY.processstatus
is &apos;����״̬��0000�������룬0001���ɹ���0002��ʧ�ܣ�&apos;;
comment on column PEF_REDEMPTION_APPLY.is_delete
is &apos;ɾ����ʾ(0δɾ����1ɾ��)&apos;;
comment on column PEF_REDEMPTION_APPLY.create_by
is &apos;������&apos;;
comment on column PEF_REDEMPTION_APPLY.update_by
is &apos;�޸���&apos;;
comment on column PEF_REDEMPTION_APPLY.create_date
is &apos;��������&apos;;
comment on column PEF_REDEMPTION_APPLY.update_date
is &apos;�޸�����&apos;;
-- Create/Recreate primary, unique and foreign key constraints
alter table PEF_REDEMPTION_APPLY
add constraint PK_PEF_REDEMPTION_APPLY primary key (ID)
using index
tablespace BSYS_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Grant/Revoke object privileges
grant insert on PEF_REDEMPTION_APPLY to BSYSTEM_INSERT;
grant select on PEF_REDEMPTION_APPLY to BSYSTEM_SELECT;
grant update on PEF_REDEMPTION_APPLY to BSYSTEM_UPDATE;
����ȷ�ϱ�
-------------------------------------------------------
-- Create table
create table PEF_REDEMPTION_SURE
(
id NUMBER(32) not null,
appsheetserialno VARCHAR2(24),
fundcode VARCHAR2(6),
largeredemptionflag VARCHAR2(1),
transactiondate VARCHAR2(8),
transactionaccountid VARCHAR2(17),
distributorcode VARCHAR2(9),
applicationvol NUMBER(16,2),
businesscode VARCHAR2(3),
taaccountid VARCHAR2(12),
branchcode VARCHAR2(9),
transactiontime VARCHAR2(6),
shareclass VARCHAR2(1),
handletradedate VARCHAR2(8),
institutioncode VARCHAR2(6),
achievementpay NUMBER(16,2),
achievementcompen NUMBER(16,2),
punishfee NUMBER(16,2),
breachfeebacktofund NUMBER(16,2),
breachfee NUMBER(16,2),
transferfee NUMBER(10,2),
otherfee1 NUMBER(10,2),
nav NUMBER(7,4),
agencyfee NUMBER(10,2),
charge NUMBER(10,2),
downloaddate VARCHAR2(8),
businessfinishflag VARCHAR2(1),
taserialno VARCHAR2(20),
returncode VARCHAR2(4),
confirmedamount NUMBER(16,2),
confirmedvol NUMBER(16,2),
currencytype VARCHAR2(3),
transactioncfmdate VARCHAR2(8),
is_delete VARCHAR2(20 CHAR) not null,
create_by VARCHAR2(20 CHAR) not null,
update_by VARCHAR2(20 CHAR) not null,
create_date DATE not null,
update_date DATE not null
)
tablespace BSYS_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table PEF_REDEMPTION_SURE
is &apos;����ȷ��&apos;;
-- Add comments to the columns
comment on column PEF_REDEMPTION_SURE.id
is &apos;��������&apos;;
comment on column PEF_REDEMPTION_SURE.appsheetserialno
is &apos;���뵥����&apos;;
comment on column PEF_REDEMPTION_SURE.fundcode
is &apos;��������&apos;;
comment on column PEF_REDEMPTION_SURE.largeredemptionflag
is &apos;�޶����ش�����־ (0-ȡ����1-˳��
)&apos;;
comment on column PEF_REDEMPTION_SURE.transactiondate
is &apos;���׷�������&apos;;
comment on column PEF_REDEMPTION_SURE.transactionaccountid
is &apos;Ͷ���˻��������˺�&apos;;
comment on column PEF_REDEMPTION_SURE.distributorcode
is &apos;�����˴���&apos;;
comment on column PEF_REDEMPTION_SURE.applicationvol
is &apos;������������&apos;;
comment on column PEF_REDEMPTION_SURE.businesscode
is &apos;ҵ������&apos;;
comment on column PEF_REDEMPTION_SURE.taaccountid
is &apos;Ͷ���˻����˺�&apos;;
comment on column PEF_REDEMPTION_SURE.branchcode
is &apos;��������&apos;;
comment on column PEF_REDEMPTION_SURE.transactiontime
is &apos;���׷���ʱ��&apos;;
comment on column PEF_REDEMPTION_SURE.shareclass
is &apos;�շѷ�ʽ (0-ǰ�շѣ�1-���շ�)&apos;;
comment on column PEF_REDEMPTION_SURE.handletradedate
is &apos;���������� ���ݹ鲢������������&apos;;
comment on column PEF_REDEMPTION_SURE.institutioncode
is &apos;��������&apos;;
comment on column PEF_REDEMPTION_SURE.achievementpay
is &apos;ҵ������&apos;;
comment on column PEF_REDEMPTION_SURE.achievementcompen
is &apos;ҵ������&apos;;
comment on column PEF_REDEMPTION_SURE.punishfee
is &apos;�ͷ��Է���&apos;;
comment on column PEF_REDEMPTION_SURE.breachfeebacktofund
is &apos;ΥԼ���������ʲ�����&apos;;
<#--
-->
<#--
-->
<#--
-->
<#--
-->

������Ϣ
�ʲ����ţ�

*�������룺

*��Ʒ���ƣ�

*��Ʒ���ƣ�

*��Ʒ����״̬�� <@dictionary.select selectId="productOnLineStatus" styleClass="required form-control productStatus" messageGroup="PEF_ONLINE_STATUS" selectedMessageKey="" selectName="productOnLineStatus" firstOptionName="��ѡ��" firstOptionValue=""/>

 *��Ʒ��װģʽ�� <@dictionary.select selectId="productModePack" styleClass="required form-control packagingModel" messageGroup="PRODUCT_PACKAGE_TYPE" selectedMessageKey="" selectName="productModePack" firstOptionName="��ѡ��" firstOptionValue="0" parentMessageKey="5"/>
*���ױ��֣� <@dictionary.select selectId="currencyType" styleClass="required form-control currencyType" messageGroup="su_currency_type" selectedMessageKey="CNY" selectName="currencyType" firstOptionName="��ѡ��" firstOptionValue="0"/>

 ��Ʒ��ȫ�ȼ���

*��Ʒ������ <@dictionary.select selectId="productSonType" styleClass="required form-control category" messageGroup="PEF_PRODUCT_SON_TYPE" selectedMessageKey="" selectName="productSonType" firstOptionName="��ѡ��" firstOptionValue="0" parentMessageKey="5"/>

 *��Ʒ�ṹ��

(��ʽΪ���޷ּ�/����:�Ӻ�=A:B/����:�в�:�Ӻ��ṹ��=A:B:C)
*��Ʒ�������ڣ�

*ļ������ʼ���ڣ� onfocus="WdatePicker({dateFmt:&apos;yyyy-MM-dd HH:mm&apos;,maxDate:&apos;#F{$dp.$D(\&apos;collectEndDate\&apos;)}&apos;})"/>

*ļ������ֹ���ڣ� onfocus="WdatePicker({dateFmt:&apos;yyyy-MM-dd HH:mm&apos;,minDate:&apos;#F{$dp.$D(\&apos;collectStartDate\&apos;)}&apos;})"/>

*Ԥ�Ƴ���ʱ�䣺 onfocus="WdatePicker({dateFmt:&apos;yyyy-MM-dd&apos;,maxDate:&apos;#F{$dp.$D(\&apos;planEndDate\&apos;)}&apos;})"/>

*Ԥ�Ƶ���ʱ�䣺
onfocus="WdatePicker({dateFmt:&apos;yyyy-MM-dd&apos;,minDate:&apos;#F{$dp.$D(\&apos;planCreatDate\&apos;)}&apos;})"/>

*��Ͷ��� Ԫ

 *�Ƿ�֧���޸ķֺ췽ʽ��
<@dictionary.select selectId="isNotModefityShowMethod" styleClass="form-control required modefityMethod" messageGroup="PEF_ISNOT_MODEFITY_SHOW_METHOD" selectedMessageKey="" selectName="isNotModefityShowMethod" firstOptionName="��ѡ��" firstOptionValue=""/>

*��Ʒ��ģ�� Ԫ

 *���ͳ�����ģ�� Ԫ
*���������Ϲ���� Ԫ

 *�����Ϲ���� Ԫ
*���ͳ��б�׼�� Ԫ

 ���ͳ��б�׼�� �ݶ�
*����Ͷ�ʽ�� Ԫ

 *�������ͣ�
<@dictionary.select selectId="policyType" styleClass="required form-control" messageGroup="PEF_POLICY_TYPE" selectedMessageKey="" selectName="policyType" firstOptionName="��ѡ��" firstOptionValue=""/>

�������ͳ��б�׼������ʽ��
<@dictionary.select selectId="lowestHoldWay" styleClass="required form-control" messageGroup="LOWEST_HOLD_WAY" selectedMessageKey="" selectName="lowestHoldWay" firstOptionName="��ѡ��" firstOptionValue="0"/>
*�������ޣ�
<@dictionary.select selectId="durationTimeUnits" styleClass="form-control width70" messageGroup="PEF_TIME_UNITS" selectedMessageKey="1" selectName="durationTimeUnits" firstOptionValue="0"/>

*�����ڣ�
<@dictionary.select selectId="closeTimeUnits" styleClass="form-control width70" messageGroup="PEF_TIME_UNITS" selectedMessageKey="1" selectName="closeTimeUnits" firstOptionValue="0" />

*׼�����ڣ�
<@dictionary.select selectId="planCloseFlag" styleClass="form-control width70" messageGroup="PEF_TIME_UNITS" selectedMessageKey="1" selectName="planCloseFlag" firstOptionValue="0" />

*�������ڣ�

*׼���������ط��ʣ� %
*��Ʒ����������
<@dictionary.select selectId="productYield" styleClass="required form-control productIncome" messageGroup="PEF_PRODUCT_YIELD" selectedMessageKey="" selectName="productYield" firstOptionName="��ѡ��" firstOptionValue=""/>

�Ƿ�����ת�ã�
<@dictionary.select selectId="isNotAllowAssignment" styleClass="required form-control" messageGroup="PEF_ACHIEVEMENT_PAY" selectedMessageKey="" selectName="isNotAllowAssignment" firstOptionName="��ѡ��" firstOptionValue="0"/>
*��Ͷ��������
��

 *�����Ϲ�����(���˵���)��
Ԫ
*��Ʒ��С������
��

 *��Ʒ����������
��
*��Ʒļ����ģ���ޣ�
Ԫ

 ��Ʒ������ģ���ޣ� ��
*�״��깺���ͽ��
Ԫ

 *׷���깺���ͽ��
Ԫ
˳�ӱ�־��
<@dictionary.select selectId="postponeFlag" styleClass="required form-control" messageGroup="PEF_POSTPONE_FLAG" selectedMessageKey="" selectName="postponeFlag" firstOptionName="��ѡ��" firstOptionValue="0"/>
*�Ƿ�ԤԼ�깺�Ǽǣ�
<@dictionary.select selectId="isNotYyPurchaseRegister" styleClass="required form-control purchaseReg" messageGroup="PEF_ISNOT_YYPURCHASE_REGISTER" selectedMessageKey="" selectName="isNotYyPurchaseRegister" firstOptionName="��ѡ��" firstOptionValue=""/>

*��ʼԤԼ�깺�Ǽ���(������)�� onfocus="WdatePicker({dateFmt:&apos;yyyy-MM-dd&apos;,maxDate:&apos;#F{$dp.$D(\&apos;endYyPurchaseDate\&apos;)}&apos;})"/>

*����ԤԼ�깺�Ǽ���(������)��
onfocus="WdatePicker({dateFmt:&apos;yyyy-MM-dd&apos;,minDate:&apos;#F{$dp.$D(\&apos;startYyPurchaseDate\&apos;)}&apos;})"/>

�������ԣ�
<@dictionary.select selectId="fundStrategy" styleClass="required form-control fundStrategy" messageGroup="FUND_STRATEGY" selectedMessageKey="" selectName="fundStrategy" firstOptionName="��ѡ��" firstOptionValue=""/>

*�Ƿ�ԤԼ���صǼǣ�
<@dictionary.select selectId="isNotYyRedemptionRegister" styleClass="required form-control redeemReg" messageGroup="PEF_ISNOT_YYPURCHASE_REGISTER" selectedMessageKey="" selectName="isNotYyRedemptionRegister" firstOptionName="��ѡ��" firstOptionValue=""/>

*��ʼԤԼ���صǼ���(������)��

(ԤԼ���������ڿ�����/�ڵ���ǰN�տ�ʼ)

 *����ԤԼ���صǼ���(������)��

(ԤԼ���������ڿ�����/�ڵ���ǰN�ս���)
*����������

*չʾ�ֺ췽ʽ��
<@dictionary.select selectId="showDividendMethod" styleClass="form-control required showMethod" messageGroup="PEF_SHOW_DIVIDEND_METHOD" selectedMessageKey="1" selectName="showDividendMethod" firstOptionName="��ѡ��" firstOptionValue="0"/>

*Ĭ�Ϸֺ췽ʽ��
<@dictionary.select selectId="defDividendMethod" styleClass="form-control required defMethod" messageGroup="PEF_DEF_DIVIDEND_METHOD" selectedMessageKey="CASH" selectName="defDividendMethod" firstOptionName="��ѡ��" firstOptionValue="0"/>

��������
Ͷ�ʹ���(����)�� *Ͷ�ʹ���(����)��

����������(����)��

*����������(����)��

*���������˽��ܣ�

*�����������飺

���(����)�� *���(����)��

������������(����)�� *������������(����)��

����������(����)�� *����������(����)��

֤ȯ���ͻ���(����)�� *֤ȯ���ͻ���(����)��

�ڻ����ͻ���(����)�� *�ڻ����ͻ���(����)��

���ع���(����)�� ���ع���(����)��

��������
*�ۿ��ʣ� %

 *Ԥ�������ʣ� %
*�������ʣ� %

 *�йܷ��ʣ� %
*�Ϲ����ʣ� %

 *�Ϲ��ۿ��ʣ� %
*�깺���ʣ� %

 *�깺�ۿ��ʣ� %
�����Ϲ��ѷֳɣ� %

 �����깺�ѷֳɣ� %
�Ϲ��ѽ��շ�ʽ��
<@dictionary.select selectId="subscribeDeliveryMethod" styleClass="required form-control" messageGroup="PEF_SUBSCRIBE_DELIVERY_METHOD" selectedMessageKey="1" selectName="subscribeDeliveryMethod" firstOptionName="��ѡ��" firstOptionValue="0"/>
*�Ϲ�����ȡ��ʽ��
<@dictionary.select selectId="subscribeMethod" styleClass="required form-control subscribeMethod" messageGroup="PEF_SUBSCRIBE_METHOD" selectedMessageKey="1" selectName="subscribeMethod" firstOptionName="" firstOptionValue="0"/>

�깺�ѽ��շ�ʽ��
<@dictionary.select selectId="purchaseDeliveryMethod" styleClass="required form-control" messageGroup="PEF_SUBSCRIBE_DELIVERY_METHOD" selectedMessageKey="2" selectName="purchaseDeliveryMethod" firstOptionName="" firstOptionValue="0"/>
*�깺����ȡ��ʽ��
<@dictionary.select selectId="purchaseMethod" styleClass="required form-control purchaseMethod" messageGroup="PEF_SUBSCRIBE_METHOD" selectedMessageKey="1" selectName="purchaseMethod" firstOptionName="" firstOptionValue="0"/>

*���ط��ʣ� %

 ���ط���ȡ��ʽ��
<@dictionary.select selectId="redemptionMethod" styleClass="required form-control" messageGroup="PEF_REDEMPTION_METHOD" selectedMessageKey="" selectName="redemptionMethod" firstOptionName="��ѡ��" firstOptionValue="0"/>
�Ƿ������طѷֳɣ�
<@dictionary.select selectId="isNotRedemptionFallInto" styleClass="required form-control" messageGroup="PEF_ACHIEVEMENT_PAY" selectedMessageKey="0" selectName="isNotRedemptionFallInto" firstOptionName="" firstOptionValue="0"/>
�����������طѷֳɣ� %
���طѷֳɽ���Ƶ�ʣ�
<@dictionary.select selectId="redemptionMethods" styleClass="required form-control" messageGroup="PEF_INCOME_METHOD" selectedMessageKey="" selectName="redemptionMethods" firstOptionName="��ѡ��" firstOptionValue="0"/>
���طѷֳ��Ƿ񾭹�������ת��
<@dictionary.select selectId="isNotRomRedemption" styleClass="required form-control" messageGroup="PEF_ISNOT_ROMREDEMPTION" selectedMessageKey="1" selectName="isNotRomRedemption" firstOptionName="" firstOptionValue="0"/>
(���طѾ���������ת)˰�ʣ� %

 (���طѾ���������ת)����˰/����˰��
<@dictionary.select selectId="redemptionpriceTaxMethod" styleClass="required form-control" messageGroup="PEF_PRICE_TAX_METHOD" selectedMessageKey="1" selectName="redemptionpriceTaxMethod" firstOptionName="" firstOptionValue="0"/>
�������������ѷֳɣ� %

 �����ѷֳɽ���Ƶ�ʣ�
<@dictionary.select selectId="managerBalanceMethod" styleClass="required form-control" messageGroup="PEF_INCOME_METHOD" selectedMessageKey="" selectName="managerBalanceMethod" firstOptionName="��ѡ��" firstOptionValue="0"/>
�����ѷֳ��Ƿ񾭹�������ת��
<@dictionary.select selectId="managerFeeIsRoam" styleClass="required form-control" messageGroup="PEF_MANAGER_FEEIS_ROAM" selectedMessageKey="1" selectName="managerFeeIsRoam" firstOptionName="" firstOptionValue="0"/>
(�����ѷֳɾ���������ת)˰�ʣ� %
(�����ѷֳɾ���������ת����)����˰/����˰��
<@dictionary.select selectId="priceTaxMethod" styleClass="required form-control" messageGroup="PEF_PRICE_TAX_METHOD" selectedMessageKey="1" selectName="priceTaxMethod" firstOptionName="" firstOptionValue="0"/>
*�Ƿ���ȡҵ�����꣺
<@dictionary.select selectId="isNotAchievementGatherPay" styleClass="required form-control isNotAchievementGatherPay" messageGroup="PEF_ISNOT_ACHIEVEMENT_GATHERPAY" selectedMessageKey="1" selectName="isNotAchievementGatherPay" firstOptionName="��ѡ��" firstOptionValue="0"/>

����ҵ�������ʣ� %

 ��������ҵ�������ֳɣ� %
�Ƿ��̶�ʱ����ȡҵ�����꣺
<@dictionary.select selectId="isNotAchievementPay" styleClass="required form-control" messageGroup="PEF_ACHIEVEMENT_PAY" selectedMessageKey="0" selectName="isNotAchievementPay" firstOptionName="" firstOptionValue="0"/>
ҵ�������ֳɽ���Ƶ�ʣ�
<@dictionary.select selectId="achievementPayMethod" styleClass="required form-control" messageGroup="PEF_INCOME_METHOD" selectedMessageKey="" selectName="achievementPayMethod" firstOptionName="��ѡ��" firstOptionValue="0"/>
��������ȡҵ�����꣺
<@dictionary.select selectId="achievementPayDate" styleClass="required form-control" messageGroup="PEF_ACHIEVEMENT_PAY" selectedMessageKey="1" selectName="achievementPayDate" firstOptionName="" firstOptionValue="0"/>
�ֺ�ʱ��ȡҵ�����꣺
<@dictionary.select selectId="achievementPayDividend" styleClass="required form-control" messageGroup="PEF_ACHIEVEMENT_PAY" selectedMessageKey="0" selectName="achievementPayDividend" firstOptionName="" firstOptionValue="0"/>
*ҵ��������ȡ������

ҵ�������ֳ��Ƿ񾭹�������ת��
<@dictionary.select selectId="isNotRomAchievementPay" styleClass="required form-control" messageGroup="PEF_ISNOT_ROMREDEMPTION" selectedMessageKey="1" selectName="isNotRomAchievementPay" firstOptionName="" firstOptionValue="0"/>
(ҵ�������ֳɾ���������ת)˰�ʣ� %
��ҵ�������ֳɾ���������ת������˰/����˰��
<@dictionary.select selectId="priceTaxAchievementPayMethod"styleClass="required form-control" messageGroup="PEF_PRICE_TAX_METHOD" selectedMessageKey="" selectName="priceTaxAchievementPayMethod" firstOptionName="��ѡ��" firstOptionValue="0"/>
*�Ϲ�/�깺�ݶ�������
�����ļ��㷽ʽ��
<@dictionary.select selectId="computingMethod" styleClass="required form-control formula" messageGroup="COMPUTING_METHOD" selectedMessageKey="" selectName="computingMethod" firstOptionName="��ѡ��" firstOptionValue="0"/>

*���۷������ʣ� %

 ���۷����ѽ���Ƶ�ʣ�
<@dictionary.select selectId="saleServeMethod" styleClass="required form-control" messageGroup="PEF_INCOME_METHOD" selectedMessageKey="" selectName="saleServeMethod" firstOptionName="��ѡ��" firstOptionValue="0"/>
���۷������Ƿ񾭹�������ת��
<@dictionary.select selectId="isNotSaleServe" styleClass="required form-control" messageGroup="PEF_ISNOT_ROMREDEMPTION" selectedMessageKey="1" selectName="isNotSaleServe" firstOptionName="" firstOptionValue=""/>
(���۷����Ѿ�������)˰�ʣ� %
(���۷����Ѿ�������)����˰/����˰��
<@dictionary.select selectId="saleServePriceTaxMethod" styleClass="required form-control" messageGroup="PEF_PRICE_TAX_METHOD" selectedMessageKey="1" selectName="saleServePriceTaxMethod" firstOptionName="" firstOptionValue="0"/>
�ͻ�ά�����ʣ� %
�ͻ�ά���ѽ���Ƶ�ʣ�
<@dictionary.select selectId="customerFeeMethod" disabled ="disabled" styleClass="required form-control" messageGroup="PEF_INCOME_METHOD" selectedMessageKey="" selectName="customerFeeMethod" firstOptionName="��ѡ��" firstOptionValue="0"/>
�ͻ�ά�����Ƿ񾭹�������ת��
<@dictionary.select selectId="isNotRomCustomerFee" styleClass="required form-control" messageGroup="PEF_ISNOT_ROMREDEMPTION" selectedMessageKey="1" selectName="isNotRomCustomerFee" firstOptionName="" firstOptionValue="0"/>
(�ͻ�ά���Ѿ���������ת)˰�ʣ� %

 (�ͻ�ά���Ѿ���������ת)����˰/����˰��
<@dictionary.select selectId="customerFeePriceMethod" styleClass="required form-control" messageGroup="PEF_PRICE_TAX_METHOD" selectedMessageKey="1" selectName="customerFeePriceMethod" firstOptionName="" firstOptionValue="0"/>
�������������룺

������������Ƶ�ʣ� <@dictionary.select selectId="otherIncomeMethod" styleClass="required form-control" messageGroup="PEF_INCOME_METHOD" selectedMessageKey="" selectName="otherIncomeMethod" firstOptionName="��ѡ��" firstOptionValue="0"/>
��Ϣ��¶��

��Ʒ˵��
*ҵ���Ƚϻ�׼��

�����ֳɱ�����
��������Ƶ�ʣ�
<@dictionary.select selectId="earningsAllotFrequency" styleClass="form-control required" messageGroup="EARNINGS_ALLOT_FREQUENCY" selectedMessageKey="" selectName="earningsAllotFrequency" firstOptionName="��ѡ��" firstOptionValue="0"/>

�������䷽ʽ��
<@dictionary.select selectId="earningsAllotWay" styleClass="form-control required earningsAllotWay" messageGroup="EARNINGS_ALLOT_WAY" selectedMessageKey="" selectName="earningsAllotWay" firstOptionName="��ѡ��" firstOptionValue="0"/>

Ʊ�����

���м۸���

�ֻ��ο��۸���

�����ο��۸���

����ִ�мۣ�

����ִ�мۣ�

*Ԥ���ߣ�

*ֹ���ߣ�

�����ʣ� %

 �����ʣ� %
*��ֵ�˶�Ƶ�ʣ�
<@dictionary.select selectId="appraisementCheckRate" styleClass="form-control required checkFrequency" messageGroup="PEF_APPRAISEMENT_CHECK_RATE" selectedMessageKey="" selectName="appraisementCheckRate" firstOptionName="��ѡ��" firstOptionValue="0"/>

�μ������ˣ�

*Ͷ�ʷ�Χ/������

*Ͷ�����ƣ�

*Ͷ��Ŀ�꣺

*Ͷ�ʲ��ԣ�

������

����˵����

������Ϣ
����������

����������

��Ӫ��Ϣ
*�Ϲ�����������

*�Ϲ�ȷ��������

*�깺����������

*�깺ȷ��������

*���ؽ���������

*����ȷ��������

*����ȷ��ʧ���˿��������

*ļ��ʧ���˿��������

*�ֺ콻��������

*�������������

*ļ���˻��˻�����

*ļ���˻��˺ţ�

*ļ���˻������У�

*ļ�������кţ�

ļ������֧���ţ�

ļ������������־��
<@dictionary.select selectId="raiseAccFlag" styleClass="form-control required" messageGroup="RAISE_ACC_FLAG" selectedMessageKey="0" selectName="raiseAccFlag" firstOptionName="" firstOptionValue="0"/>

�����˻��˻�����

�����˻��˺ţ�

�����˻������У�

*���㻧���кţ�

��������֧���ţ�

���㻧��������־��
<@dictionary.select selectId="lqdAccFlag" styleClass="form-control required" messageGroup="LQD_ACC_FLAG" selectedMessageKey="0" selectName="lqdAccFlag" firstOptionName="" firstOptionValue="0"/>

��ֵС��λ����

�ݶ�С��λ����

��ֵ������ʽ��

����׼������
<@dictionary.select selectId="yearBenchmarkDays" styleClass="form-control required" messageGroup="PEF_YEARBEN_CHMARK_DAYS" selectedMessageKey="" selectName="yearBenchmarkDays" firstOptionName="��ѡ��" firstOptionValue="0"/>

��λ��ֵ��

*TA���룺

����
����
评论
0 条评论
下一页
为你推荐
查看更多
用户表结构
用户表结构
用户表结构
用户表结构
用户表结构
用户表结构
投资学堂--私募证券基金
投资学堂--私募证券基金
用户表结构
用户表结构
私募系统
私募系统
用户表结构
用户表结构
私募场景
私募场景
用户表结构
用户表结构
私募预约
私募预约