# Date: 16/02/06
# Version: 105

$DOC(PIF_COMIS)
 name=Комиссии ПИФ
 class=1
 product=ALD_UKPIF
 name_formula=null
 remark_formula=null

 $STATE(CRT)
  name=Создан
  class=0
 $ENDSTATE

 $STATE(DEL)
  name=Удален
  class=2
 $ENDSTATE

 $STATE(NEW)
  name=Начальный
  class=1
 $ENDSTATE

 $PROP(SETTINGS_ID)
  name=Договор
  field_name=settings_id
  table_name=t_pif_comis
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=1
  init_class=0
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(PROFIT_TYPE_ID)
  name=Тип вознаграждения
  field_name=profit_type_id
  table_name=t_pif_comis
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=2
  init_class=0
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(COMISSION_NULL_LEVEL)
  name=Пороговое значение комиссии
  field_name=comission_null_level
  table_name=t_pif_comis
  field_type=money
  field_length=8
  field_scale=4
  field_prec=19
  page=1
  order=3
  init_class=0
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(COMISSION_VALUE)
  name=Ставка комиссии
  field_name=comission_value
  table_name=t_pif_comis
  field_type=money
  field_length=8
  field_scale=4
  field_prec=19
  page=1
  order=4
  init_class=0
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(COMISSION_PERCENT)
  name=Процент комиссии
  field_name=comission_percent
  table_name=t_pif_comis
  field_type=money
  field_length=8
  field_scale=4
  field_prec=19
  page=1
  order=5
  init_class=0
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(COMISSION_CUR_ID)
  name=Валюта
  field_name=comission_cur_id
  table_name=t_pif_comis
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=6
  init_class=1
  init_formula=(select comission_cur_id from tb_contracts where id=@settings_id)
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(COMISSION_DATE_LEVEL)
  name=Порог во времени
  field_name=comission_date_level
  table_name=t_pif_comis
  field_type=int
  field_length=4
  field_scale=0
  field_prec=10
  page=1
  order=7
  init_class=0
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(COMISSION_DATE_TYPE_1)
  name=Измерение порога
  field_name=comission_date_type
  table_name=t_pif_comis
  field_type=smallint
  field_length=null
  field_scale=null
  field_prec=null
  page=1
  order=8
  init_class=1
  init_formula=1
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $RELATION(REL1)
  class=0
  type=SIMPLES
  form=null
  prop=PROFIT_TYPE_ID
  idname=null
  order=10
 $ENDRELATION

 $RELATION(REL2)
  class=0
  type=TYPE_TUNING_CLIENT_DOG
  form=null
  prop=SETTINGS_ID
  idname=null
  order=null
 $ENDRELATION

 $FORM(FORM1)
  name=Просмотр
  class=5
  filter=null
  target_state=
  uo=uo_edit
  dw=d_sd_comis_edit
  procedure=ap_21535000000537936
  patterns=GENERIC_VIEW_ITEM
  user_define=0
  isvisible=1
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(15213912)
create procedure dbo.%PROC%
  @sid varchar(30) = null
as
declare
        @id numeric,
        @action_id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric,
        @type_id_s varchar(30),
        @new_state_id numeric,
        @state_name_id_s varchar(30)

begin

  select @id = convert(numeric, @sid)
  select @action_id = %ACTION_ID%
 select @type_id_s = NULL
select  @state_name_id_s = NULL

.CHECK_USER
.CHECK_VIEW_ITEM


if @id = -1
begin
begin tran
.GET_PROPS
.CHECK_INSERT
.INIT_VARS(B)
.INSERT_ITEMS
.INSERT
commit tran
end
.VIEW_ITEM
/*
.ACTION_HISTORY
*/
end
  $ENDTEXT(15213912)
 $ENDFORM

 $FORM(FORM2)
  name=Ставки комиссии
  class=4
  filter=null
  target_state=
  uo=uo_list
  dw=d_sd_comis_list
  procedure=ap_21535000000537937
  patterns=GENERIC_VIEW_LIST
  user_define=0
  isvisible=1
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(15213912)
create procedure dbo.%PROC% @sid varchar(30) = null
   .ARGLIST_FILTER
as
declare
        @action_id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric,
        @new_state_id numeric

begin

  select @action_id = %ACTION_ID%

.CHECK_USER
.CHECK_VIEW

.ARGCONVERT_FILTER

.VIEW_LIST


end
  $ENDTEXT(15213912)

  $ACTION2RELATION(REL1.SIMPLE_NAME)
   relation=REL1
   where=type_id=5015
   prop=SIMPLE_NAME
   order=1
   alias=type_revard_name
  $ENDACTION2RELATION

  $FILTER(SETTINGS_ID)
   type=11
   label=Ключ
   prop=SETTINGS_ID
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER
 $ENDFORM

 $ACTION(ACTION1)
  name=Добавить
  class=1
  form=FORM1
  target_state=CRT
  procedure=ap_21535000000537940
  patterns=GENERIC_INSERT
  user_define=0
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=2240
  height=600
  proc_text=$TEXT(15213914)
create procedure dbo.%PROC% @sid varchar(30) = null,
.ARGLIST
as
declare @action_id numeric,
        @id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric,
        @item_name varchar(100),
        @new_state_id numeric
begin
begin tran

  select @action_id = %ACTION_ID%
   select @id = convert(numeric, @sid)

.CHECK_USER
.CHECK_UPDATE

.ARGCONVERT

.INIT_VARS

.TEST_UNIQUE

.UPDATE_ITEMS

.UPDATE

.RELGEN
.UPDATE_STATE
.ACTION_HISTORY

commit tran
select sid = convert(varchar, @id)
end
  $ENDTEXT(15213914)
 $ENDACTION

 $ACTION(ACTION2)
  name=Изменить
  class=2
  form=FORM1
  target_state=null
  procedure=ap_21535000000537941
  patterns=GENERIC_UPDATE
  user_define=0
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=2181
  height=600
  proc_text=$TEXT(15213914)
create procedure dbo.%PROC% @sid varchar(30) = null,
.ARGLIST
as
declare @action_id numeric,
        @id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric,
        @item_name varchar(100),
        @new_state_id numeric
begin tran

  select @action_id = %ACTION_ID%
   select @id = convert(numeric, @sid)

.CHECK_USER
.CHECK_UPDATE

.ARGCONVERT

.TEST_UNIQUE

.UPDATE_ITEMS

.UPDATE

.RELGEN
.UPDATE_STATE
.ACTION_HISTORY

commit tran
  $ENDTEXT(15213914)
 $ENDACTION

 $ACTION(ACTION3)
  name=Удалить
  class=9
  form=null
  target_state=DEL
  procedure=ap_21535000000537942
  patterns=GENERIC_MOVE
  user_define=0
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(15213914)
create procedure dbo.%PROC% @sid varchar(30) = null
as
declare @action_id numeric,
        @id numeric,
        @user_id numeric,
        @state_id numeric,
        @new_state_id numeric,
        @type_id numeric
begin tran

  select @action_id = %ACTION_ID%
   select @id = convert(numeric, @sid)

.CHECK_USER
.CHECK_UPDATE

.UPDATE_STATE
.ACTION_HISTORY

/*-------Проводки ----------*/


commit tran
  $ENDTEXT(15213914)
 $ENDACTION

 $STATE2ACTION(CRT.ACTION2)
  state=CRT
  action=ACTION2
 $ENDSTATE2ACTION

 $STATE2ACTION(CRT.ACTION3)
  state=CRT
  action=ACTION3
 $ENDSTATE2ACTION

 $STATE2ACTION(CRT.FORM1)
  state=CRT
  action=FORM1
 $ENDSTATE2ACTION

 $STATE2ACTION(CRT.FORM2)
  state=CRT
  action=FORM2
 $ENDSTATE2ACTION

 $STATE2ACTION(NEW.ACTION1)
  state=NEW
  action=ACTION1
 $ENDSTATE2ACTION

 $STATE2PROP(CRT.COMISSION_CUR_ID)
  state=CRT
  prop=COMISSION_CUR_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CRT.COMISSION_DATE_LEVEL)
  state=CRT
  prop=COMISSION_DATE_LEVEL
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CRT.COMISSION_DATE_TYPE_1)
  state=CRT
  prop=COMISSION_DATE_TYPE_1
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CRT.COMISSION_NULL_LEVEL)
  state=CRT
  prop=COMISSION_NULL_LEVEL
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CRT.COMISSION_PERCENT)
  state=CRT
  prop=COMISSION_PERCENT
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CRT.COMISSION_VALUE)
  state=CRT
  prop=COMISSION_VALUE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CRT.PROFIT_TYPE_ID)
  state=CRT
  prop=PROFIT_TYPE_ID
  enable=1
  mandatory=1
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CRT.SETTINGS_ID)
  state=CRT
  prop=SETTINGS_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.COMISSION_CUR_ID)
  state=NEW
  prop=COMISSION_CUR_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.COMISSION_DATE_LEVEL)
  state=NEW
  prop=COMISSION_DATE_LEVEL
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.COMISSION_DATE_TYPE_1)
  state=NEW
  prop=COMISSION_DATE_TYPE_1
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.COMISSION_NULL_LEVEL)
  state=NEW
  prop=COMISSION_NULL_LEVEL
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.COMISSION_PERCENT)
  state=NEW
  prop=COMISSION_PERCENT
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.COMISSION_VALUE)
  state=NEW
  prop=COMISSION_VALUE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.PROFIT_TYPE_ID)
  state=NEW
  prop=PROFIT_TYPE_ID
  enable=1
  mandatory=1
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.SETTINGS_ID)
  state=NEW
  prop=SETTINGS_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP
$ENDDOC