Обновление:СМС рассылка — различия между версиями

Версия 16:23, 15 мая 2015

Создание/обновление справочников SP$WDICTS

UPDATE OR INSERT INTO SP$WDICTS (PARENT_ID, CAPTION, DESCRIPTION, SID, STATUS, INI, SORTING, FRAMECLASS)
                         VALUES (0, 'Контрагенты', NULL, 'AGENTS                         ', 2, '[insertsql]

[deletesql_selected]

[deletesql]
update agents set deletedt=current_date where id=:id

[refreshsql]
select * from vw_agents where id=:ID

[selectsqlwithdeleted]

[selectsql]
select * from vw_agents where id>3 and deletedt is null order by caption,id

[form_show]
position=0
left=0
Top=0
Width=800
Height=800
MaxWidth=0
MaxHeight=0
MinWidth=0
MinHeight=0

[form_get]
position=0
left=0
Top=0
Width=800
Height=800
MaxWidth=0
MaxHeight=0
MinWidth=0
MinHeight=0

[main]
sourcetablename=AGENTS
returnfieldname=ID
captionfieldname=CAPTION
keyfieldname=ID
ViewID=AGENTS2
RootGroupTableName=AGENTS
ShowCaption=Клиенты
GetCaption=Клиенты
GroupSelect=1
foldergroup=AGENTS.FOLDERS
initfolder_id=
dataset=0
InitTMSGroup_id=
folders_visible=0
Canfloating=0
hidetoppanel=0
ActivateDictAction=0

[cfSelect]
selectfieldexpression=coalesce(caption,'''')||'' ''||coalesce(phonenumbers,'''')||'' ''||coalesce(email,'''')
AllwaysPartial=1

[childs]
bottomdock_units=2
bottomdock_size=50
rightdock_units=0
rightdock_size=0

[child_0]
caption=Детализация покупок
wdict=AGENTS_SALE
oninit=tek_id=0
afterscroll=tek_id=id
onselectedchange=tek_id=id
efaultdocksite - где будет по-умолчанию: none - не показывается, right - справа, bottom - снизу в виде закладки, custom - просто показывается
defaultdocksite=bottom
ShortCut=
afterupd=tek_id=id
afterdatasetopen=

[TMS_1]
group_id=-601
caption=Рассылка

[editfields]
CAPTION=default
FULLNAME=default
INN=default
EMAIL=default
PHONENUMBERS=default
KREDITDAY=default
BANK=BANK_ID
BIK=default
RS=default
KS=default
KPP=default
BANK_ID=WDICTS.BANK(initvalue=bank_id)
DOVERKA=default
PHONENUMBERS2=default
PHONENUMBERS3=default

', NULL, NULL)
                       MATCHING (SID);
UPDATE OR INSERT INTO SP$WDICTS (PARENT_ID, CAPTION, DESCRIPTION, SID, STATUS, INI, SORTING, FRAMECLASS)
                         VALUES (0, 'Покупки клиента', NULL, 'AGENTS_SALE                    ', 1, '[insertsql]

[deletesql_selected]

[deletesql]

[refreshsql]
select * from PR_AGENTS_SALE(:tek_id) where id=:ID

[selectsqlwithdeleted]

[selectsql]
select * from PR_AGENTS_SALE(:tek_id)

[form_show]
position=1
left=0
Top=0
Width=600
Height=400
MaxWidth=0
MaxHeight=0
MinWidth=0
MinHeight=0

[form_get]
position=1
left=0
Top=0
Width=600
Height=400
MaxWidth=0
MaxHeight=0
MinWidth=0
MinHeight=0

[main]
sourcetablename=DOC_DETAIL
returnfieldname=ID
captionfieldname=ID
keyfieldname=ID
ViewID=AGENTS_SALE
RootGroupTableName=
ShowCaption=Детализация покупок
GetCaption=Детализация покупок
GroupSelect=0
foldergroup=
initfolder_id=
dataset=1
InitTMSGroup_id=
folders_visible=0
Canfloating=0
hidetoppanel=0
ActivateDictAction=0
folderscaption=Каталоги

[cfSelect]
selectfieldexpression=
AllwaysPartial=1

[childs]
bottomdock_units=2
bottomdock_size=50
rightdock_units=0
rightdock_size=0

[block_hl]
fieldname=DOC_ID
column=SPROFILE
color1=8421504
color2=8421376

', NULL, NULL)
                       MATCHING (SID);

COMMIT WORK;

 

Создание/обновление TMS

UPDATE OR INSERT INTO GROUPS (ID, PARENT_ID, CAPTION, GROUPTABLE, STATUS, SYSTEMFLAG, DESCRIPTION, IMAGEINDEX, COLOR, SORTING, BASE_AGENT_ID, SID)
                      VALUES (-602, -430, 'рассылка', 'TMS                            ', 0, 0, NULL, -1, NULL, NULL, 0, NULL)
                    MATCHING (ID);

COMMIT WORK;