私募表结构
2016-05-06 14:06:55 2 举报AI智能生成
私募表结构是一种用于记录和管理私募基金信息的数据库结构。它通常包括以下几个主要字段：基金名称、基金代码、基金类型、基金规模、基金成立日期、基金经理、投资策略、历史收益率等。这些字段可以帮助投资者快速了解基金的基本信息和投资特点，从而做出更明智的投资决策。私募表结构还可以根据实际需求进行扩展，例如添加风险等级、费用标准、投资期限等字段，以满足不同投资者的需求。总之，私募表结构是一种有效的工具，可以帮助投资者更好地管理和跟踪私募基金的表现。
作者其他创作
大纲/内容
�깺������
-- Create table
create table PEF_PURCHASE_APPLY
(
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 '��������';
comment on column PEF_PURCHASE_APPLY.appsheetserialno
is '���뵥����';
comment on column PEF_PURCHASE_APPLY.currencytype
comment on column PEF_PURCHASE_APPLY.fundcode
comment on column PEF_PURCHASE_APPLY.transactiondate
is '����������';
comment on column PEF_PURCHASE_APPLY.transactionaccountid
is 'Ͷ���˻��������˺�';
comment on column PEF_PURCHASE_APPLY.distributorcode
is '�����˴���';
comment on column PEF_PURCHASE_APPLY.applicationamount
comment on column PEF_PURCHASE_APPLY.businesscode
is 'ҵ������';
comment on column PEF_PURCHASE_APPLY.taaccountid
is 'Ͷ���˻����˺�';
comment on column PEF_PURCHASE_APPLY.branchcode
comment on column PEF_PURCHASE_APPLY.transactiontime
is '������ʱ��';
comment on column PEF_PURCHASE_APPLY.shareclass
is '�շѷ�ʽ';
comment on column PEF_PURCHASE_APPLY.raisefee
is '�Ϲ��� ��0-ǰ�շѣ�1-���շѣ�';
comment on column PEF_PURCHASE_APPLY.plannerno
is '����ʦ����';
comment on column PEF_PURCHASE_APPLY.handletradedate
is '���������� ���ݹ鲢������������';
comment on column PEF_PURCHASE_APPLY.institutioncode
comment on column PEF_PURCHASE_APPLY.process_status
is '����״̬��0000�������룬0001���ɹ���0002��ʧ�ܣ�';
comment on column PEF_PURCHASE_APPLY.is_delete
is 'ɾ����ʾ(0δɾ����1ɾ��)';
comment on column PEF_PURCHASE_APPLY.create_by
is '������';
comment on column PEF_PURCHASE_APPLY.update_by
is '����';
comment on column PEF_PURCHASE_APPLY.create_date
comment on column PEF_PURCHASE_APPLY.update_date
is '������';
comment on column PEF_PURCHASE_APPLY.investorname
is 'Ͷ��������';
alter table PEF_PURCHASE_APPLY
add constraint PK_PEF_PURCHASE_APPLY primary key (ID)
using index
initrans 2
-- 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 PEF_PURCHASE_SURE
update_date DATE not null
-- Add comments to the table
comment on table PEF_PURCHASE_SURE
is '�깺ȷ��';
comment on column PEF_PURCHASE_SURE.id
comment on column PEF_PURCHASE_SURE.shareclass
comment on column PEF_PURCHASE_SURE.transferfee
comment on column PEF_PURCHASE_SURE.taserialno
is 'TAȷ�Ͻ�����ˮ��';
comment on column PEF_PURCHASE_SURE.transactiontime
comment on column PEF_PURCHASE_SURE.branchcode
comment on column PEF_PURCHASE_SURE.nav
is '������λ��ֵ';
comment on column PEF_PURCHASE_SURE.agencyfee
comment on column PEF_PURCHASE_SURE.charge
comment on column PEF_PURCHASE_SURE.downloaddate
is '���������´�����';
comment on column PEF_PURCHASE_SURE.taaccountid
comment on column PEF_PURCHASE_SURE.businesscode
comment on column PEF_PURCHASE_SURE.applicationamount
comment on column PEF_PURCHASE_SURE.distributorcode
comment on column PEF_PURCHASE_SURE.transactionaccountid
comment on column PEF_PURCHASE_SURE.returncode
is '���״������ش���';
comment on column PEF_PURCHASE_SURE.transactiondate
comment on column PEF_PURCHASE_SURE.fundcode
comment on column PEF_PURCHASE_SURE.confirmedamount
is 'ÿ�ʽ���ȷ�Ͻ���';
comment on column PEF_PURCHASE_SURE.confirmedvol
is '�����˻�����ȷ�Ϸ���';
comment on column PEF_PURCHASE_SURE.currencytype
comment on column PEF_PURCHASE_SURE.transactioncfmdate
is '����ȷ������';
comment on column PEF_PURCHASE_SURE.appsheetserialno
comment on column PEF_PURCHASE_SURE.handletradedate
comment on column PEF_PURCHASE_SURE.institutioncode
comment on column PEF_PURCHASE_SURE.is_delete
comment on column PEF_PURCHASE_SURE.create_by
comment on column PEF_PURCHASE_SURE.update_by
comment on column PEF_PURCHASE_SURE.create_date
comment on column PEF_PURCHASE_SURE.update_date
alter table PEF_PURCHASE_SURE
add constraint PK_PEF_PURCHASE_SURE primary key (ID)
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 PEF_RAISE_FAIL
feecalculator VARCHAR2(8)
comment on table PEF_RAISE_FAIL
is 'ļ��ʧ��';
comment on column PEF_RAISE_FAIL.id
comment on column PEF_RAISE_FAIL.transactioncfm_date
comment on column PEF_RAISE_FAIL.currency_type
comment on column PEF_RAISE_FAIL.confirmed_amount
comment on column PEF_RAISE_FAIL.fund_code
comment on column PEF_RAISE_FAIL.interest
is '�����˻���Ϣ����(�Ϲ�һ��ȷ�ϵĽ�����������Ϣ�����в�������Ϣ)';
comment on column PEF_RAISE_FAIL.transaction_date
is '����������(��ʽΪ��YYYYMMDD)';
comment on column PEF_RAISE_FAIL.transaction_account_id
is 'Ͷ���˻��������˺�(Ͷ���������ۻ����ڿ��������ڽ����˺�)';
comment on column PEF_RAISE_FAIL.distributor_code
comment on column PEF_RAISE_FAIL.application_amount
comment on column PEF_RAISE_FAIL.business_code
comment on column PEF_RAISE_FAIL.taaccount_id
comment on column PEF_RAISE_FAIL.interest_tax
is '��Ϣ˰';
comment on column PEF_RAISE_FAIL.deposit_acct
is 'Ͷ�����������˴����ڽ����ʽ��˺�';
comment on column PEF_RAISE_FAIL.trans_date_throughclear_age
is '�����ʽ��������˻�������';
comment on column PEF_RAISE_FAIL.download_date
comment on column PEF_RAISE_FAIL.ta_serialno
comment on column PEF_RAISE_FAIL.raise_interest
is '�Ϲ��ڼ���Ϣ';
comment on column PEF_RAISE_FAIL.refund_amount
is '�˿�����';
comment on column PEF_RAISE_FAIL.share_class
is '�շѷ�ʽ(0-ǰ�շѣ�1-���շ�)';
comment on column PEF_RAISE_FAIL.is_delete
comment on column PEF_RAISE_FAIL.create_by
comment on column PEF_RAISE_FAIL.create_date
comment on column PEF_RAISE_FAIL.update_by
comment on column PEF_RAISE_FAIL.update_date
comment on column PEF_RAISE_FAIL.appsheetserialno
comment on column PEF_RAISE_FAIL.confirmedvol
comment on column PEF_RAISE_FAIL.returncode
comment on column PEF_RAISE_FAIL.discountrateofcommission
is '����Ӷ���ۿ���';
comment on column PEF_RAISE_FAIL.regioncode
is '�������ڵ�������';
comment on column PEF_RAISE_FAIL.charge
comment on column PEF_RAISE_FAIL.agencyfee
comment on column PEF_RAISE_FAIL.branchcode
comment on column PEF_RAISE_FAIL.transactiontime
comment on column PEF_RAISE_FAIL.otherfee1
is '��������1';
comment on column PEF_RAISE_FAIL.individualorinstitution
is '����/������־';
comment on column PEF_RAISE_FAIL.tradingprice
is '���۸�';
comment on column PEF_RAISE_FAIL.stampduty
is 'ӡ��˰';
comment on column PEF_RAISE_FAIL.transferfee
comment on column PEF_RAISE_FAIL.volumebyinterest
is '��Ϣ�����Ļ�������';
comment on column PEF_RAISE_FAIL.feecalculator
is '�Ʒ���';
alter table PEF_RAISE_FAIL
add primary key (ID)
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 PEF_REDEMPTION_APPLY
comment on table PEF_REDEMPTION_APPLY
comment on column PEF_REDEMPTION_APPLY.id
comment on column PEF_REDEMPTION_APPLY.appsheetserialno
comment on column PEF_REDEMPTION_APPLY.fundcode
comment on column PEF_REDEMPTION_APPLY.largeredemptionflag
is '�����ش�����־';
comment on column PEF_REDEMPTION_APPLY.transactiondate
comment on column PEF_REDEMPTION_APPLY.transactionaccountid
comment on column PEF_REDEMPTION_APPLY.distributorcode
comment on column PEF_REDEMPTION_APPLY.applicationvol
is '������������';
comment on column PEF_REDEMPTION_APPLY.businesscode
comment on column PEF_REDEMPTION_APPLY.taaccountid
comment on column PEF_REDEMPTION_APPLY.branchcode
comment on column PEF_REDEMPTION_APPLY.transactiontime
comment on column PEF_REDEMPTION_APPLY.shareclass
comment on column PEF_REDEMPTION_APPLY.chargetype
is '�շ�����';
comment on column PEF_REDEMPTION_APPLY.handletradedate
comment on column PEF_REDEMPTION_APPLY.institutioncode
comment on column PEF_REDEMPTION_APPLY.processstatus
comment on column PEF_REDEMPTION_APPLY.is_delete
comment on column PEF_REDEMPTION_APPLY.create_by
comment on column PEF_REDEMPTION_APPLY.update_by
comment on column PEF_REDEMPTION_APPLY.create_date
comment on column PEF_REDEMPTION_APPLY.update_date
alter table PEF_REDEMPTION_APPLY
add constraint PK_PEF_REDEMPTION_APPLY primary key (ID)
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 PEF_REDEMPTION_SURE
comment on table PEF_REDEMPTION_SURE
is '����ȷ��';
comment on column PEF_REDEMPTION_SURE.id
comment on column PEF_REDEMPTION_SURE.appsheetserialno
comment on column PEF_REDEMPTION_SURE.fundcode
comment on column PEF_REDEMPTION_SURE.largeredemptionflag
is '�����ش�����־ (0-ȡ����1-˳��
)';
comment on column PEF_REDEMPTION_SURE.transactiondate
comment on column PEF_REDEMPTION_SURE.transactionaccountid
comment on column PEF_REDEMPTION_SURE.distributorcode
comment on column PEF_REDEMPTION_SURE.applicationvol
comment on column PEF_REDEMPTION_SURE.businesscode
comment on column PEF_REDEMPTION_SURE.taaccountid
comment on column PEF_REDEMPTION_SURE.branchcode
comment on column PEF_REDEMPTION_SURE.transactiontime
comment on column PEF_REDEMPTION_SURE.shareclass
is '�շѷ�ʽ (0-ǰ�շѣ�1-���շ�)';
comment on column PEF_REDEMPTION_SURE.handletradedate
comment on column PEF_REDEMPTION_SURE.institutioncode
comment on column PEF_REDEMPTION_SURE.achievementpay
comment on column PEF_REDEMPTION_SURE.achievementcompen
comment on column PEF_REDEMPTION_SURE.punishfee
is '�ͷ��Է���';
comment on column PEF_REDEMPTION_SURE.breachfeebacktofund
is 'ΥԼ���������ʲ�����';
\t
.tb-main{min-width:800px;}
.required{width:159px;}\t
������Ϣ
�ʲ����ţ�
*�������룺
*��Ʒ���ƣ�
*��Ʒ����״̬��
*��Ʒ��װģʽ��
*���ױ��֣�
��Ʒ��ȫ�ȼ���
*��Ʒ������
*��Ʒ�ṹ��
(��ʽΪ���ּ�/����:�Ӻ�=A:B/����:�в�:�Ӻ��ṹ��=A:B:C)
#--
*��Ʒ�������ڣ�
--
*ļ������ʼ���ڣ�
input type=\"text\" name=\"collectStartDate\" id=\"collectStartDate\" class=\"Wdate span-wid100 form-control date-start\"
onfocus=\
*ļ������ֹ���ڣ�
input type=\"text\" name=\"collectEndDate\" id=\"collectEndDate\" class=\"Wdate span-wid100 form-control date-end\"
*Ԥ�Ƴ���ʱ�䣺
input type=\"text\" name=\"planCreatDate\" id=\"planCreatDate\" class=\"Wdate span-wid100 form-control found-day\"
*Ԥ�Ƶ���ʱ�䣺
input type=\"text\" name=\"planEndDate\" id=\"planEndDate\" class=\"Wdate span-wid100 form-control end-day2\"
*��Ͷ���
Ԫ
*�Ƿ�֧���ķֺ췽ʽ��
*��Ʒ��ģ��
*���ͳ�����ģ��
*���������Ϲ����
*�����Ϲ����
*���ͳ��б���
���ͳ��б���
�ݶ�
*����Ͷ�ʽ��
#--*�������ͣ�
�������ͳ��б�������ʽ��
*�������ޣ�
*�����ڣ�
*�����ڣ�
*�������ڣ�
*���������ط��ʣ�
%
*��Ʒ����������
�Ƿ�����ת�ã�
*�깺���Ź�����
*���ؿ��Ź�����
*�깺�����գ�
*�깺�����£�
*���ؿ����գ�
*���ؿ����£�
*�깺������(N1)��
(��Ʒ�깺������(��)֮���������ŵ�ʱ�䣻�����翪��һ�죬��N1=1)
*���ؿ�����(N2)��
(��Ʒ���ؿ�����(��)֮���������ŵ�ʱ�䣻�����翪��һ�죬��N2=1)
*��Ͷ��������
��
*�����Ϲ�����(���˵���)��
*��Ʒ��С������
*��Ʒļ����ģ���ޣ�
��Ʒ������ģ���ޣ�
*�״��깺���ͽ��
*���깺���ͽ��
˳�ӱ�־��
*�Ƿ�ԤԼ�깺�Ǽǣ�
*��ʼԤԼ�깺�Ǽ���(������)��
input type=\"text\" name=\"startYyPurchaseDate\" id=\"startYyPurchaseDate\" class=\"Wdate span-wid100 form-control startYyPurchaseDate\"
*����ԤԼ�깺�Ǽ���(������)��
input type=\"text\" name=\"endYyPurchaseDate\" id=\"endYyPurchaseDate\" class=\"Wdate span-wid100 form-control endYyPurchaseDate\"
�������ԣ�
*�Ƿ�ԤԼ���صǼǣ�
*��ʼԤԼ���صǼ���(������)��
(ԤԼ���������ڿ�����/�ڵ���ǰN�տ�ʼ)
*����ԤԼ���صǼ���(������)��
(ԤԼ���������ڿ�����/�ڵ���ǰN�ս���)
*����������
*չʾ�ֺ췽ʽ��
*Ĭ�Ϸֺ췽ʽ��
\t\t\t
Ͷ�ʹ���(����)��
*Ͷ�ʹ���(����)��
����������(����)��
*����������(����)��
*���������˽��ܣ�
*�����������飺
���(����)��
*���(����)��
������������(����)��
*������������(����)��
֤ȯ���ͻ���(����)��
*֤ȯ���ͻ���(����)��
�ڻ����ͻ���(����)��
*�ڻ����ͻ���(����)��
���ع���(����)��
#--*�ۿ��ʣ�
%--
*Ԥ�������ʣ�
*�������ʣ�
*�йܷ��ʣ�
*�Ϲ����ʣ�
*�Ϲ��ۿ��ʣ�
*�깺���ʣ�
*�깺�ۿ��ʣ�
�����Ϲ��ѷֳɣ�
�����깺�ѷֳɣ�
�Ϲ��ѽ��շ�ʽ��
*�Ϲ�����ȡ��ʽ��
�깺�ѽ��շ�ʽ��
*�깺����ȡ��ʽ��
*���ط��ʣ�
���ط���ȡ��ʽ��
�Ƿ������طѷֳɣ�
�����������طѷֳɣ�
���طѷֳɽ���Ƶ�ʣ�
���طѷֳ��Ƿ�������ת��
(���طѾ���������ת)˰�ʣ�
(���طѾ���������ת)����˰/����˰��
�������������ѷֳɣ�
�����ѷֳɽ���Ƶ�ʣ�
�����ѷֳ��Ƿ�������ת��
(�����ѷֳɾ���������ת)˰�ʣ�
(�����ѷֳɾ���������ת����)����˰/����˰��
*�Ƿ���ȡҵ�����꣺
����ҵ�������ʣ�
��������ҵ�������ֳɣ�
�Ƿ��̶�ʱ����ȡҵ�����꣺
ҵ�������ֳɽ���Ƶ�ʣ�
��������ȡҵ�����꣺
�ֺ�ʱ��ȡҵ�����꣺
*ҵ��������ȡ������
ҵ�������ֳ��Ƿ�������ת��
(ҵ�������ֳɾ���������ת)˰�ʣ�
��ҵ�������ֳɾ���������ת������˰/����˰��
*�Ϲ�/�깺�ݶ������������ļ��㷽ʽ��
*���۷������ʣ�
���۷����ѽ���Ƶ�ʣ�
���۷������Ƿ�������ת��
(���۷����Ѿ�������)˰�ʣ�
(���۷����Ѿ�������)����˰/����˰��
�ͻ�ά�����ʣ�
�ͻ�ά���ѽ���Ƶ�ʣ�
�ͻ�ά�����Ƿ�������ת��
(�ͻ�ά���Ѿ���������ת)˰�ʣ�
(�ͻ�ά���Ѿ���������ת)����˰/����˰��
�������������룺
������������Ƶ�ʣ�
��Ϣ��¶��
��Ʒ˵��
*ҵ���Ƚϻ���
�����ֳɱ�����
��������Ƶ�ʣ�
�������䷽ʽ��
Ʊ�����
���м۸���
�ֻ��ο��۸���
�����ο��۸���
����ִ�мۣ�
*Ԥ���ߣ�
*ֹ���ߣ�
�����ʣ�
%
*��ֵ�˶�Ƶ�ʣ�
�μ������ˣ�
*Ͷ�ʷ�Χ/������
*Ͷ�����ƣ�
*Ͷ��Ŀ�꣺
*Ͷ�ʲ��ԣ�
������
����˵����
����������
��Ӫ��Ϣ
*�Ϲ�����������
*�Ϲ�ȷ��������
*�깺����������
*�깺ȷ��������
*���ؽ���������
*����ȷ��������
*����ȷ��ʧ���˿��������
*ļ��ʧ���˿��������
*�ֺ콻��������
*�������������
*ļ���˻��˻�����
*ļ���˻��˺ţ�
*ļ���˻������У�
*ļ�������кţ�
ļ������֧���ţ�
ļ������������־��
�����˻��˻�����
�����˻��˺ţ�
�����˻������У�
*���㻧���кţ�
��������֧���ţ�
���㻧��������־��
��ֵС��λ����
�ݶ�С��λ����
��ֵ������ʽ��
����������
��λ��ֵ��
*TA���룺
����
comment on column PEF_REDEMPTION_SURE.breachfee
is 'ΥԼ��';
comment on column PEF_REDEMPTION_SURE.transferfee
comment on column PEF_REDEMPTION_SURE.otherfee1
comment on column PEF_REDEMPTION_SURE.nav
comment on column PEF_REDEMPTION_SURE.agencyfee
comment on column PEF_REDEMPTION_SURE.charge
comment on column PEF_REDEMPTION_SURE.downloaddate
comment on column PEF_REDEMPTION_SURE.businessfinishflag
is 'ҵ��������ȫ������ʶ';
comment on column PEF_REDEMPTION_SURE.taserialno
comment on column PEF_REDEMPTION_SURE.returncode
comment on column PEF_REDEMPTION_SURE.confirmedamount
comment on column PEF_REDEMPTION_SURE.confirmedvol
comment on column PEF_REDEMPTION_SURE.currencytype
is '�������� ����������GB/T 12406-2008';
comment on column PEF_REDEMPTION_SURE.transactioncfmdate
comment on column PEF_REDEMPTION_SURE.is_delete
comment on column PEF_REDEMPTION_SURE.create_by
comment on column PEF_REDEMPTION_SURE.update_by
comment on column PEF_REDEMPTION_SURE.create_date
comment on column PEF_REDEMPTION_SURE.update_date
alter table PEF_REDEMPTION_SURE
add constraint PK_PEF_REDEMPTION_SURE primary key (ID)
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 PEF_SUBSCRIBE_APPLY
comment on table PEF_SUBSCRIBE_APPLY
is '�Ϲ�������';
comment on column PEF_SUBSCRIBE_APPLY.id
is 'ID(PK)';
comment on column PEF_SUBSCRIBE_APPLY.app_sheet_serialno
comment on column PEF_SUBSCRIBE_APPLY.currency_type
comment on column PEF_SUBSCRIBE_APPLY.fund_code
comment on column PEF_SUBSCRIBE_APPLY.transaction_date
comment on column PEF_SUBSCRIBE_APPLY.transaction_time
comment on column PEF_SUBSCRIBE_APPLY.transaction_account_id
comment on column PEF_SUBSCRIBE_APPLY.distributor_code
comment on column PEF_SUBSCRIBE_APPLY.application_amount
comment on column PEF_SUBSCRIBE_APPLY.business_code
comment on column PEF_SUBSCRIBE_APPLY.ta_account_id
comment on column PEF_SUBSCRIBE_APPLY.branch_code
comment on column PEF_SUBSCRIBE_APPLY.share_class
comment on column PEF_SUBSCRIBE_APPLY.subs_class
is '�깺��ʽ(�ջ�0��ʾ��ͨ��1-��ʾ�����깺)';
comment on column PEF_SUBSCRIBE_APPLY.is_agree_outrisk
comment on column PEF_SUBSCRIBE_APPLY.is_agree_nextday
comment on column PEF_SUBSCRIBE_APPLY.extension
is '��Ϣ��չ';
comment on column PEF_SUBSCRIBE_APPLY.process_status
comment on column PEF_SUBSCRIBE_APPLY.is_delete
comment on column PEF_SUBSCRIBE_APPLY.create_by
comment on column PEF_SUBSCRIBE_APPLY.create_date
comment on column PEF_SUBSCRIBE_APPLY.update_by
comment on column PEF_SUBSCRIBE_APPLY.update_date
comment on column PEF_SUBSCRIBE_APPLY.subscribe_amount
is '��Ҫ���ݻ������Ϲ��������Ϲ��ѣ�û����0';
comment on column PEF_SUBSCRIBE_APPLY.afp_no
comment on column PEF_SUBSCRIBE_APPLY.investorname
comment on column PEF_SUBSCRIBE_APPLY.discountrateofcommission
is '����Ӷ���ۿ��� ';
alter table PEF_SUBSCRIBE_APPLY
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 PEF_SUBSCRIBE_SURE
institutioncode VARCHAR2(6)
comment on table PEF_SUBSCRIBE_SURE
is '�Ϲ�ȷ�ϱ�';
comment on column PEF_SUBSCRIBE_SURE.id
comment on column PEF_SUBSCRIBE_SURE.app_sheet_serialno
comment on column PEF_SUBSCRIBE_SURE.fund_code
comment on column PEF_SUBSCRIBE_SURE.return_code
comment on column PEF_SUBSCRIBE_SURE.transaction_account_id
comment on column PEF_SUBSCRIBE_SURE.distributor_code
comment on column PEF_SUBSCRIBE_SURE.application_amount
comment on column PEF_SUBSCRIBE_SURE.business_code
comment on column PEF_SUBSCRIBE_SURE.ta_account_id
comment on column PEF_SUBSCRIBE_SURE.deposit_acct
is 'Ͷ�����������˴��������ʽ��˺�';
comment on column PEF_SUBSCRIBE_SURE.region_code
comment on column PEF_SUBSCRIBE_SURE.transaction_cfm_date
comment on column PEF_SUBSCRIBE_SURE.download_date
comment on column PEF_SUBSCRIBE_SURE.charge
comment on column PEF_SUBSCRIBE_SURE.agency_fee
comment on column PEF_SUBSCRIBE_SURE.confirmed_vol
comment on column PEF_SUBSCRIBE_SURE.confirmed_amount
comment on column PEF_SUBSCRIBE_SURE.branch_code
comment on column PEF_SUBSCRIBE_SURE.transaction_date
comment on column PEF_SUBSCRIBE_SURE.transaction_time
comment on column PEF_SUBSCRIBE_SURE.individual_or_institution
is '����/������־(0-������1-����)';
comment on column PEF_SUBSCRIBE_SURE.application_vol
comment on column PEF_SUBSCRIBE_SURE.trading_price
is '���۸�(��λ������ֵ+���ַ���)';
comment on column PEF_SUBSCRIBE_SURE.ta_serialno
comment on column PEF_SUBSCRIBE_SURE.stamp_duty
comment on column PEF_SUBSCRIBE_SURE.valid_period
is '��������������';
comment on column PEF_SUBSCRIBE_SURE.transfer_fee
comment on column PEF_SUBSCRIBE_SURE.from_ta_flag
is '�Ƿ�ע���Ǽ��˷���ҵ����־(0-�������˷�����1-��ע���Ǽ��˷���)';
comment on column PEF_SUBSCRIBE_SURE.share_class
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
comment on column PEF_SUBSCRIBE_SURE.create_by
comment on column PEF_SUBSCRIBE_SURE.create_date
comment on column PEF_SUBSCRIBE_SURE.update_by
comment on column PEF_SUBSCRIBE_SURE.update_date
comment on column PEF_SUBSCRIBE_SURE.nav
alter table PEF_SUBSCRIBE_SURE
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({
forceParse : 0
});
}
// ���߷���
pef.tool = {
checkLength : function() {
if (arguments.length 2)
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)
if (arguments[1] == 3) {
if (reg.test(arguments[0])) {
if (arguments[1] == 10) {
if (arguments[1] == 19) {
if (arguments[1] == 14) {
checkFloat : function() {
if (arguments.length = 2) {
result = false;
if (arguments[1] == 2) {
if (arguments[1] == 1) {
};
// ������ƷУ��
pef.formCheck = {
if (!minLength) {
_t.state = false;
alter.html(\"!\" + tip + \"������\");
obj.addClass(\"warncolor\");
} else if (!maxLength) {
alter.html(\"!\" + tip + \"���Ȳ��ܳ���\" + strmax + \"���ַ�\");
} else {
alter.html(\"\");
obj.removeClass(\"warncolor\");
\"option:selected\
if (v == \"\" || txt == '��ѡ��') {
alter.html(\"!\" + tip);
var _t = this;
if (arguments.length == 2) {
.parent(\".controls\").siblings(\".alter\");
if (empty) {
alter.html(\"!\" + tip1 + \"������\");
if (arguments.length == 4) {
alter.html(\"!\" + tip2 + \"������\");
if (!empty2) {
if (str2 str) {
alter.html(\"!\" + tip2 + \"������\" + tip1);
if (arguments.length == 5) {
} else if (str - str2 = limitMax) {
alter.html(\"!ļ���ڲ��ܳ���\" + limitMax + \"��\");
.siblings(\".alter\");
if (!(str == null || str == \"\")) {
obj.val(parseFloat(str));
if (tip1 == \"\") {
alter.html(\"!����������14λ���ڣ�С��2λ���ڵ�����\");
alter.html(\"!\" + tip1);
alter.html(\"!������14λ���ڵ�������\");
if (minLength) {
alter.html(\"!������С��1��С��2λ���ڵ�����\");
if (val == \"\") {
alter.html(\"!����������2λ���ڣ�С��λ2λ���ڵ�����\");
if (data == \"\") {
alter.html(\"!������\" + l + \"���������\");
} else if (parseInt(data) parseInt(min)) {
alter.html(\"!������\" + min);
} else if (parseInt(data) parseInt(max)) {
alter.html(\"!���ܴ���\" + max);
alter.html(\"!\" + tip + \"���Ȳ��ܳ���\" + l + \"���ַ�\");
var count = l - $.trim(obj.val()).length;
if (count = 0) {
count = 0;
obj.siblings(\".alter\").html(
\"����������\" + count + \"��\");
conditionSet : function(str) {
if (str == \"B\") {
_t.objReadOnly.removeAttr(\"readonly\");
_t.objReadOnly.parent().prev(\"td.tag-name\").find(\".required-field\")
.html(\"*\");
_t.objReadOnly.attr(\"readonly\
.removeClass(\"warncolor\");
_t.objReadOnly.siblings(\".alter\").html(\"\");
.html(\"\");
_t.objReadOnly.parent().find(\".form-control\").val(\"\");
bind : function() {
_t.txt.on(\"keyup\
$(this).siblings(\".alter\").html(\"\");
$(this).removeClass(\"warncolor\");
_t.sel.on(\"change\
_t.date.on(\"blur\
if ($(this).val() != \"\") {
$(\"textarea\").on(\"blur\
$(this).next(\".alter\").html(\"\");
_t.submitBtn
.on(
\"click\
function() {
_t.state = true;
/* base information */
var index = 0;
// \"���������˴���\");
\"��ѡ���Ƿ���ȡҵ������\");
_t
/* end base information */
\"��ʼԤԼ�깺�Ǽ���(������)\");
\"��ʼԤԼ���صǼ���(������)\
\"����ԤԼ���صǼ���(������)\
if ($(\"#isNotModefityShowMethod\").hasClass(
\"isNotModefityShowMethod\")) {
_t.isNotModefityShowMethod = $(
\".isNotModefityShowMethod\
\"��ѡ���Ƿ�֧���ķֺ췽ʽ\");
if ($(\"#purchaseOpenRule\").hasClass(
\"purchaseOpenRule\")) {
_t.purchaseOpenRule = $(\".purchaseOpenRule\
_t.f);
if ($(\"#redemptionOpenRule\").hasClass(
\"redemptionOpenRule\")) {
_t.redemptionOpenRule = $(
\".redemptionOpenRule\
if ($(\"#purchaseOpenMons\").hasClass(
\"purchaseOpenMons\")) {
_t.purchaseOpenMons = $(\".purchaseOpenMons\
if ($.trim(_t.lowestHoldNormalMoney.val()) == \"\") {
if ($.trim(_t.lowestHoldNormalShare.val()) == \"\") {
\"���ͳ��б�(Ԫ)\
\"���ͳ��б�(��)\
if ($(\"#redemptionOpenMons\").hasClass(
\"redemptionOpenMons\")) {
_t.redemptionOpenMons = $(
\".redemptionOpenMons\
if ($(\"#purchaseOpenDays\").hasClass(
\"purchaseOpenDays\")) {
_t.purchaseOpenDays = $(\".purchaseOpenDays\
if ($(\"#redemptionOpenDays\").hasClass(
\"redemptionOpenDays\")) {
_t.redemptionOpenDays = $(
\".redemptionOpenDays\
if ($(\"#purchaseOpenNumber\").hasClass(
\"purchaseOpenNumber\")) {
_t.purchaseOpenNumber = $(
\".purchaseOpenNumber\
if ($(\"#redemptionOpenNumber\").hasClass(
\"redemptionOpenNumber\")) {
_t.redemptionOpenNumber = $(
\".redemptionOpenNumber\
\"���ؿ�����\
/* organization */
\"Ͷ�ʹ���\");
\"���������ˣ����ƣ�\");
// \"���ع��ʣ����ƣ�\");
\"�ڻ����ͻ��������ƣ�\");
\"�����������������ƣ�\");
\"���������������ƣ�\");
\"֤ȯ���ͻ��������ƣ�\");
// \"��ҵ��������\");
\"������������\");
\"���������˽���\");
// \"���������ͻ�ά������\");
// \"���ع��ʣ����룩\");
// \"Ͷ�ʹ��ʣ����룩\");
// \"�й��ˣ����룩\");
// \"���������������룩\");
\"ҵ��������ȡ����\");
_t.briefIntroduction.on(\"keyup change\
_t.fundManagerIntro.on(\"keyup change\
_t.redemptiontj.on(\"keyup change\
_t.achievementPayTerm.on(\"keyup change\
/* end organization */
/* product description */
// \"�����ֳɱ���\");
//\t\t\t\t\t\t\tif ($(\"#earningsAllotWay\").hasClass(\"earningsAllotWay\")) {
//\t\t\t\t\t\t\t\t_t.earningsAllotWay = $(\".earningsAllotWay\
//\t\t\t\t\t\t\t}
if ($(\"#durationTime\").hasClass(\"duration\")) {
_t.durationTime = $(\".duration\
if ($(\"#fundStrategy\").hasClass(\"fundStrategy\")) {
_t.fundStrategy = $(\".fundStrategy\
\"Ͷ�ʷ�Χ/����\");
\"Ͷ�ʲ���\");
_t.investmentScope.on(\"keyup change\
_t.investmentLimit.on(\"keyup change\
_t.investmentTarget.on(\"keyup change\
_t.investmentStrategy.on(\"keyup change\
_t.popularOpinion.on(\"keyup change\
_t.otherInstrucetions.on(\"keyup change\
/* end product description */
/* running info --Start */
\"����ȷ��ʧ���˿������\
\"ļ��ʧ���˿������\
\"ļ���˻��˻���\");
\"ļ���˻�������\");
\"ļ�������к�\");
\"���㻧���к�\");
/* running info --End */
/* attachment */
_t.riskControlOpinion.on(\"keyup change\
_t.messageShow.on(\"keyup change\
/* end attachment */
if (_t.state) {
$('#baseInfo').ajaxSubmit({
success : function(rs) {
if (rs.success) {
layer.msg(\"�����ɹ�\
icon : 1
$('#infoSubmit').removeAttr('href');
$('#infoSubmit').unbind(\"click\");
if ($('#id').val() == '') {
$('#id').val(rs.data.id);
$('#assetId').val(rs.data.assetId);
$('#uuid').val(rs.data.uuid);
init : function() {
_t.f = $(\"#baseInfo\");
_t.submitBtn = $(\"#infoSubmit\
_t.name = $(\".name\
//\t\t_t.discountRate = $(\".discountRate\
_t.jname = $(\".jname\
_t.fundCode = $(\".fundCode\
//\t\t_t.riskLevel = $(\".riskLevel\
//\t\t_t.fundStrategy = $(\".fundStrategy\
_t.packagingModel = $(\".packagingModel\
_t.category = $(\".category\
_t.structure = $(\".structure\
_t.dateStart = $(\".date-start\
_t.dateEnd = $(\".date-end\
_t.dateFound = $(\".found-day\
_t.dateEnd2 = $(\".end-day2\
_t.currency1 = $(\".currency1\
_t.scale = $(\".scale\
_t.startAmount = $(\".startAmount\
_t.currency2 = $(\".currency2\
_t.lowest = $(\".lowest\
_t.currency3 = $(\".currency3\
_t.initialAmount = $(\".initialAmount\
_t.currency4 = $(\".currency4\
_t.incrementalAmount = $(\".incrementalAmount\
_t.maxInvestTZAmount = $(\".maxInvestTZAmount\
_t.processingMode = $(\".processingMode\
_t.duration = $(\".duration\
_t.openPeriod = $(\".openPeriod\
_t.closurePeriod = $(\".closurePeriod\
_t.closurePeriod2 = $(\".closurePeriod2\
_t.productIncome = $(\".productIncome\
_t.investmentNumber = $(\".investmentNumber\
_t.maxSubAmount = $(\".maxSubAmount\
_t.mixPerson = $(\".mixPerson\
_t.maxPerson = $(\".maxPerson\
_t.raiseLimit = $(\".raiseLimit\
// _t.subsistLimit = $(\".subsistLimit\
_t.firstMixMoney = $(\".firstMixMoney\
_t.againMixMoney = $(\".againMixMoney\
_t.redemptiontj = $(\".redemptiontj\
_t.productStatus = $(\".productStatus\
_t.closureRate = $(\".closureRate\
_t.lowestHoldNormalMoney = $(\".lowestHoldNormalMoney\
_t.lowestHoldNormalShare = $(\".lowestHoldNormalShare\
_t.modefityMethod = $(\".modefityMethod\
//\t\t_t.cllx = $(\".cllx\
_t.subscribeMethod = $(\".subscribeMethod\
_t.purchaseMethod = $(\".purchaseMethod\
_t.isNotAchievementGatherPay = $(\".isNotAchievementGatherPay\
_t.investmentAdviser = $(\".investmentAdviser\
_t.fundManager = $(\".fundManager\
_t.custodian = $(\".custodian\
// _t.riskControlConsultant = $(\".riskControlConsultant\
_t.futuresOrg = $(\".futuresOrg\
_t.administrationOrg = $(\".administrationOrg\
_t.consignamentOrg = $(\".consignamentOrg\
_t.securityOrg = $(\".securityOrg\
_t.managementRate = $(\".managementRate\
_t.manageCost = $(\".manageCost\
_t.subscriptionRate = $(\".subscriptionRate\
_t.purchaseReg = $(\".purchaseReg\
_t.redeemReg = $(\".redeemReg\
_t.redeemRate = $(\".redeemRate\
_t.formula = $(\".formula\
// _t.rewardRate = $(\".rewardRate\
_t.salesRate = $(\".salesRate\
//\t\t_t.maintenanceRate = $(\".maintenanceRate\
_t.briefIntroduction = $(\".briefIntroduction\
_t.warningLine = $(\".warningLine\
_t.stopLine = $(\".stopLine\
_t.fundManagerIntro = $(\".fundManagerIntro\
// _t.organizationServe = $(\".organizationServe\
_t.subscribeRebate = $(\".subscribeRebate\
_t.purchaseRate = $(\".purchaseRate\
//\t\t_t.excessAchievementPay = $(\".excessAchievementPay\
_t.purchaseRebate = $(\".purchaseRebate\
// _t.organizationCustomerFee = $(\".organizationCustomerFee\
// ���������ͻ�ά������
// _t.riskCounselorCode = $(\".riskCounselorCode\
// _t.investmentAdviserCode = $(\".investmentAdviserCode\
// Ͷ�ʹ���(����)
// _t.fundMandatorCode = $(\".fundMandatorCode\
// _t.administrativeManagerCode = $(\".administrativeManagerCode\
// // ������������(����)
// _t.salesOrganizationCode = $(\".salesOrganizationCode\
// ����������(����)
// _t.securityOrganizationCode = $(\".securityOrganizationCode\
// // ֤ȯ���ͻ���(����)
// _t.futuresOrganizationCode = $(\".futuresOrganizationCode\
// �ڻ����ͻ���(����)
_t.achievementPayTerm = $(\".achievementPayTerm\
// _t.fundManagerCode = $(\".fundManagerCode\
_t.expectedReturnRate = $(\".expectedReturnRate\
// _t.splitRatio = $(\".splitRatio\
// _t.frequency = $(\".frequency\
_t.startYyPurchaseDate = $(\".startYyPurchaseDate\
_t.endYyPurchaseDate = $(\".endYyPurchaseDate\
_t.startYyRedemptionDate = $(\".startYyRedemptionDate\
_t.endYyRedemptionDate = $(\".endYyRedemptionDate\
_t.benchmark = $(\".benchmark\
_t.parVal = $(\".parVal\
_t.issuePrice = $(\".issuePrice\
_t.spotPrice = $(\".spotPrice\
_t.clearingPrice = $(\".clearingPrice\
_t.upperLimit = $(\".upperLimit\
_t.lowerLimit = $(\".lowerLimit\
// _t.participationRate = $(\".participationRate\
// _t.warningLine = $(\".warningLine\
// _t.stopLine = $(\".stopLine\
// _t.guaranteedRate = $(\".guaranteedRate\
_t.checkFrequency = $(\".checkFrequency\
//_t.secInvestor = $(\".secInvestor\
_t.investmentScope = $(\".investmentScope\
_t.investmentLimit = $(\".investmentLimit\
_t.investmentTarget = $(\".investmentTarget\
_t.investmentStrategy = $(\".investmentStrategy\
_t.otherInstrucetions = $(\".otherInstrucetions\
/* Running info Start */
_t.subscribeDays = $(\".subscribeDays\
_t.cfmDays = $(\".cfmDays\
_t.purchaseCfmDays = $(\".purchaseCfmDays\
_t.redemptionDays = $(\".redemptionDays\
_t.redemptionCfmDays = $(\".redemptionCfmDays\
_t.dividendDeliveryDays = $(\".dividendDeliveryDays\
_t.lqdfundsDeliveryDays = $(\".lqdfundsDeliveryDays\
_t.raiseAccName = $(\".raiseAccName\
_t.seccfmFailrfndDeliveryDays = $(\".seccfmFailrfndDeliveryDays\
_t.raiseFailRfndDeliveryDays = $(\".raiseFailRfndDeliveryDays\
_t.raiseAccNo = $(\".raiseAccNo\
_t.raiseAccBankName = $(\".raiseAccBankName\
_t.purchaseDeliveryDays = $(\".purchaseDeliveryDays\
_t.raiseAccCnapsCode = $(\".raiseAccCnapsCode\
_t.lqdAccCnapsCode = $(\".lqdAccCnapsCode\
_t.taCode = $(\".taCode\
/* Running info End */
_t.popularOpinion = $(\".popularOpinion\
_t.riskControlOpinion = $(\".riskControlOpinion\
_t.messageShow = $(\".messageShow\
/*
* _t.startTime = $(\".startTime\
*/
_t.txt = $(\"input.form-control\
_t.sel = $(\"select.form-control\
_t.date = $(\
_t.objReadOnly = $(
\
_t.bind();
// init dom ready
$(function() {
pef.datetimepicker();
pef.formCheck.init();
// $(\".a-mun\").blur(function(){
// });
// 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(\"\");
// $(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(\"\");
$(textBox).val(objLi.html());
$(\"#investmentAdviser\").val(objLi.html());
$(\"#investmentAdviserCode\").val(objLi.attr(\"id\"));
// if (!$(\"#fundMandatorDesc\").attr(\"readonly\")) {
// $(\"#fundMandatorDesc\").jSuggest({
// $(\"#fundMandator\").val(\"\");
// $(\"#fundMandator\").val(objLi.html());
// if (!$(\"#riskCounselorDesc\").attr(\"readonly\")) {
// $(\"#riskCounselorDesc\").jSuggest({
// $(\"#riskCounselor\").val(\"\");
// $(\"#riskCounselor\").val(objLi.html());
$(\"#productYield\")
.bind(
\"change\
if ($(\"#productYield\").val() == '1') {
$(\"#openRule\").show();
$(\"#openNumber\").show();
$(\"#purchaseOpenNumber\").addClass(
\"purchaseOpenNumber\");
$(\"#redemptionOpenNumber\").addClass(
\"redemptionOpenNumber\");
$(\"#purchaseOpenRule\").addClass(\"purchaseOpenRule\");
$(\"#redemptionOpenRule\").addClass(
\"redemptionOpenRule\");
$(\"#isNotModefityShowMethod\").addClass(
\"isNotModefityShowMethod\");
$(\"#openRule\").hide();
$(\"#openNumber\").hide();
$(\"#purchaseMKRule\").hide();
$(\"#purchaseMVRule\").hide();
$(\"#purchaseDKRule\").hide();
$(\"#purchaseDVRule\").hide();
$(\"#redemptionMKRule\").hide();
$(\"#redemptionMVRule\").hide();
$(\"#redemptionDKRule\").hide();
$(\"#redemptionDVRule\").hide();
$(\"#purchaseOpenNumber\").removeClass(
$(\"#redemptionOpenNumber\").removeClass(
$(\"#purchaseOpenRule\").removeClass(
\"purchaseOpenRule\");
$(\"#redemptionOpenRule\").removeClass(
$(\"#purchaseOpenMons\").removeClass(
\"purchaseOpenMons\");
$(\"#purchaseOpenDays\").removeClass(
\"purchaseOpenDays\");
$(\"#redemptionOpenMons\").removeClass(
\"redemptionOpenMons\");
$(\"#redemptionOpenDays\").removeClass(
\"redemptionOpenDays\");
$(\"#isNotModefityShowMethod\").removeClass(
$(\"#purchaseOpenRule\").bind(
var purchaseOpenRule = $(\"#purchaseOpenRule\").val();
if (purchaseOpenRule == '0' || purchaseOpenRule == '1'
|| purchaseOpenRule == '5' || purchaseOpenRule == '16'
|| purchaseOpenRule == '17') {
$(\"#purchaseRule\").hide();
$(\"#purchaseOpenMons\").val(\"\");
$(\"#purchaseOpenDays\").val(\"\");
// $(\"#purchaseMRule\").hide();
// $(\"#purchaseDRule\").hide();
$(\"#purchaseOpenMons\").removeClass(\"purchaseOpenMons\");
$(\"#purchaseOpenDays\").removeClass(\"purchaseOpenDays\");
} else if (purchaseOpenRule == '2' || purchaseOpenRule == '3'
|| purchaseOpenRule == '4' || purchaseOpenRule == '6') {
$(\"#purchaseRule\").show();
$(\"#purchaseDKRule\").show();
$(\"#purchaseDVRule\").show();
$(\"#purchaseOpenDays\").addClass(\"purchaseOpenDays\");
} else if (purchaseOpenRule == '9' || purchaseOpenRule == '12'
|| purchaseOpenRule == '15') {
$(\"#purchaseMKRule\").show();
$(\"#purchaseMVRule\").show();
$(\"#purchaseOpenMons\").addClass(\"purchaseOpenMons\");
$(\"#redemptionOpenRule\").bind(
var redemptionOpenRule = $(\"#redemptionOpenRule\").val();
if (redemptionOpenRule == '0' || redemptionOpenRule == '1'
|| redemptionOpenRule == '5'
|| redemptionOpenRule == '16'
|| redemptionOpenRule == '17') {
$(\"#redemptionRule\").hide();
$(\"#redemptionOpenMons\").val(\"\");
$(\"#redemptionOpenDays\").val(\"\");
// $(\"#redemptionMRule\").hide();
// $(\"#redemptionDRule\").hide();
$(\"#redemptionOpenMons\").removeClass(\"redemptionOpenMons\");
$(\"#redemptionOpenDays\").removeClass(\"redemptionOpenDays\");
} else if (redemptionOpenRule == '2'
|| redemptionOpenRule == '3'
|| redemptionOpenRule == '4'
|| redemptionOpenRule == '6') {
$(\"#redemptionRule\").show();
$(\"#redemptionDKRule\").show();
$(\"#redemptionDVRule\").show();
$(\"#redemptionOpenDays\").addClass(\"redemptionOpenDays\");
} else if (redemptionOpenRule == '9'
|| redemptionOpenRule == '12'
|| redemptionOpenRule == '15') {
$(\"#redemptionMKRule\").show();
$(\"#redemptionMVRule\").show();
$(\"#redemptionOpenMons\").addClass(\"redemptionOpenMons\");
// ��ʼԤԼ���صǼ��գ������գ���\"�Ƿ���ҪԤԼ���صǼ�\"ѡ���ǣ������룬�����϶�Ϊ0
// ����ԤԼ���صǼ��գ������գ���\"�Ƿ���ҪԤԼ���صǼ�\"ѡ���ǣ������룬�����϶�Ϊ0
$(\"#isNotYyRedemptionRegister\").bind(
var isNotYyRedemptionRegister = $(\"#isNotYyRedemptionRegister\")
.val();
if (isNotYyRedemptionRegister == '1') {
$(\"#startYyRedemptionDate\").val(\"\");
$(\"#startYyRedemptionDate\").attr(\"readonly\
$(\"#endYyRedemptionDate\").val(\"\");
$(\"#endYyRedemptionDate\").attr(\"readonly\
} else if (isNotYyRedemptionRegister == '0') {
$(\"#startYyRedemptionDate\").val('0');
$(\"#endYyRedemptionDate\").val('0');
//\t $(\"#isNotYyPurchaseRegister\").bind(
//\t\t\t\"change\
//\t\t\tfunction() {
//\t\t\t\tvar isNotYyPurchaseRegister = $(\"#isNotYyPurchaseRegister\")
//\t\t\t\t\t\t.val();
//\t\t\t\tif (isNotYyPurchaseRegister == '1') {
//\t\t\t\t\t$(\"#startYyPurchaseDate\").val(\"\");
//\t\t\t\t\t$(\"#startYyPurchaseDate\").attr(\"readonly\
//\t\t\t\t\t$(\"#endYyPurchaseDate\").val(\"\");
//\t\t\t\t\t$(\"#endYyPurchaseDate\").attr(\"readonly\
//\t\t\t\t} else if (isNotYyPurchaseRegister == '0') {
//\t\t\t\t\t$(\"#startYyPurchaseDate\").val('0');
//\t\t\t\t\t$(\"#endYyPurchaseDate\").val('0');
//\t\t\t\t}
//\t\t\t});
// ��ҵ�������ֳɾ���������ת��˰��\"��ҵ�������ֳ��Ƿ�������ת\"Ҫ��Ϊ\"��\"������
$(\"#isNotRomAchievementPay\").bind(\"change\
var isNotRomAchievementPay = $(\"#isNotRomAchievementPay\").val() == '1';
if (isNotRomAchievementPay) {
$(\"#cessAchievementPay\").removeAttr(\"readonly\");
$(\"#cessAchievementPay\").attr(\"readonly\
$(\"#isNotSaleServe\").bind(\"change\
var isNotSaleServe = $(\"#isNotSaleServe\").val() == '1';
if (isNotSaleServe) {
$(\"#cessSaleServe\").removeAttr(\"readonly\");
$(\"#cessSaleServe\").attr(\"readonly\
// ���ͻ�ά���Ѿ���������ת��˰��\"���ͻ�ά�����Ƿ�������ת\"Ҫ��Ϊ\"��\"������
$(\"#isNotRomCustomerFee\").bind(\"change\
var isNotRomCustomerFee = $(\"#isNotRomCustomerFee\").val() == '1';
if (isNotRomCustomerFee) {
$(\"#cessCustomerFee\").removeAttr(\"readonly\");
$(\"#cessCustomerFee\").attr(\"readonly\
//���ͻ�ά������ѡ������0 �����ͻ�ά���ѽ���Ƶ�� ��Ӧ¼��
$(\"#customerServeRate\").bind(\"change\
var customerServeRate = $(\"#customerServeRate\").val() != '' && parseFloat($(\"#customerServeRate\").val()) != '0' && $(\"#customerServeRate\").val() != null
if (customerServeRate) {
$(\"#customerFeeMethod\").removeAttr(\"disabled\");
$(\"#customerFeeMethod\").val(\"0\");
$(\"#customerFeeMethod\").attr(\"disabled\
//�Ƿ������طѷֳ�ѡ���� ��ô�����������طѷֳ� �û�
$(\"#isNotRedemptionFallInto\").bind(\"change\
var isNotRedemptionFallInto = $(\"#isNotRedemptionFallInto\").val() =='0';
if (isNotRedemptionFallInto) {
$(\"#organizationRedemption\").val(\"\");
$(\"#organizationRedemption\").attr(\"disabled\
$(\"#organizationRedemption\").removeAttr(\"disabled\");
//�Ƿ���ȡҵ������ѡ���� ��ô����ҵ�������� �û�
$(\"#isNotAchievementGatherPay\").bind(\"change\
var isNotAchievementGatherPay = $(\"#isNotAchievementGatherPay\").val() =='0';
if (isNotAchievementGatherPay) {
$(\"#excessAchievementPay\").val(\"\");
$(\"#excessAchievementPay\").attr(\"disabled\
$(\"#excessAchievementPay\").removeAttr(\"disabled\");
//�����������䷽ʽ���ڷDZ��� �����ձ��� �������� earningsAllotWay
//\t$(\"#productYield\").bind(\"change\
//\t\tvar productYield = $(\"#productYield\").val() == '0';
//\t\tif (productYield) {
//\t\t\t$(\"#earningsAllotWaySpan\").html(\"*\");
//\t\t\t$(\"#earningsAllotWay\").addClass(\"earningsAllotWay\");
//\t\t} else {
//\t\t\t$(\"#earningsAllotWaySpan\").html(\"\");
//\t\t\t$(\"#earningsAllotWay\").removeClass(\"earningsAllotWay\");
//\t\t\tif($(\"#earningsAllotWay\").hasClass(\"warncolor\")) {
//\t\t\t\t$(\"#earningsAllotWay\").removeClass(\"warncolor\");
//\t\t\t\t$(\"#earningsAllotWay\").siblings(\".alter\").html(\"\");
//\t\t\t}
//\t\t}
//\t});
//����ѡ�������ڵ�λ�еġ�����������ô�������DZ�����
$(\"#durationTimeUnits\").bind(\"change\
var durationTimeUnits = $(\"#durationTimeUnits\").val() == '6';
if (durationTimeUnits) {
$(\"#durationTimeSpan\").html(\"\");
$(\"#durationTime\").val(\"\");
$(\"#durationTime\").attr(\"readonly\
$(\"#durationTime\").removeClass(\"warncolor\");
$(\"#durationTime\").removeClass(\"duration\");
$(\"#durationTimeSpan\").html(\"*\");
$(\"#durationTime\").removeAttr(\"readonly\");
$(\"#durationTime\").addClass(\"duration\");
if($(\"#durationTime\").hasClass(\"warncolor\")){
$(\"#durationTimeSpan\").removeClass(\"warncolor\");
// ������Ʒ����ѡ�����͡�ʱ�����������������ڱ�ѡ��;productSonType
$(\"#productSonType\").bind(\"change\
var productSonType = $(\"#productSonType\").val() == 'D';
if (productSonType) {
isRequired(\"fundStrategy\
// ���ط�
$(\"#isNotRomRedemption\").bind(\"change\
var isNotRomRedemption = $(\"#isNotRomRedemption\").val() == '1';
if (isNotRomRedemption) {
$(\"#cessRedemption\").removeAttr(\"readonly\");
$(\"#cessRedemption\").attr(\"readonly\
// ������
$(\"#managerFeeIsRoam\").bind(\"change\
var managerFeeIsRoam = $(\"#managerFeeIsRoam\").val() == '1';
if (managerFeeIsRoam) {
$(\"#managerFeeCess\").removeAttr(\"readonly\");
$(\"#managerFeeCess\").attr(\"readonly\
if (isRequired) {
$(\"#\" + id + \"Span\").html(\"*\");
if(!$(\"#\" + id).hasClass(id)) {
$(\"#\" + id).addClass(id);
$(\"#\" + 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) {
//\tif(id==\"customerServeRate\"){
//\t\tvar customerServeRate=$(\"#customerServeRate\").val();
//\t\tif(customerServeRate==\"\"||customerServeRate==\"0\" ||customerServeRate == null){
//\t\t\t$(\"#customerFeeMethod\").attr(\"readonly\
//\t\t}else{
//\t\t\t$(\"#customerFeeMethod\").removeAttr(\"readonly\");
//\t}
//}
function test1(id) {
if (id == \"lowestHoldNormalMoney\") {
var v1 = $(\"#lowestHoldNormalShare\").val();
if (v1 != \"\" && v1 != null) {
$(\"#lowestHoldNormalMoney\").attr(\"readonly\
$(\"#lowestHoldNormalShare\").attr(\"readonly\
if (id == \"lowestHoldNormalShare\") {
var v1 = $(\"#lowestHoldNormalMoney\").val();
0 条评论
回复 删除
下一页
