101 lines
3.0 KiB
Transact-SQL
101 lines
3.0 KiB
Transact-SQL
--INSERT INTO TBDD_GUI_LANGUAGE_PHRASE (
|
|
-- MODULE, INTERNAL, OBJ_NAME, TITLE, LANGUAGE,CAPT_TYPE, STRING1,String2)
|
|
-- VALUES
|
|
-- ( 'MWF', 1, '1', 'Title 1', 'de-DE','Title', 'VA Freigabe','Freigabe in Rolle Verantwortlich')
|
|
--GO
|
|
--INSERT INTO TBDD_GUI_LANGUAGE_PHRASE (
|
|
-- MODULE, INTERNAL, OBJ_NAME, TITLE, LANGUAGE,CAPT_TYPE, STRING1,String2)
|
|
-- VALUES
|
|
-- ( 'MWF', 1, '3', 'Title 93', 'de-DE','Title', 'Finale Freigabe','Freigabe in Rolle Finaler Freigeber')
|
|
--GO
|
|
select * from TBMWF_PROFILE
|
|
|
|
INSERT INTO [dbo].[TBMWF_PROFILE]
|
|
([INTL_NAME]
|
|
,[PM_PROFILE_ID]
|
|
,[TYPE_ID]
|
|
,[ACTIVE]
|
|
,[FORE_COLOR]
|
|
,[BACK_COLOR] )
|
|
VALUES
|
|
('TEST PROFIL MobileWorkflow - '
|
|
,6
|
|
,1
|
|
,1
|
|
,'Yellow'
|
|
,'Black')
|
|
GO
|
|
|
|
INSERT INTO [dbo].[TBMWF_PROFILE]
|
|
([INTL_NAME]
|
|
,[PM_PROFILE_ID]
|
|
,[TYPE_ID]
|
|
,[ACTIVE]
|
|
,[FORE_COLOR]
|
|
,[BACK_COLOR] )
|
|
VALUES
|
|
('TEST PROFIL MobileWorkflow - Finale Freigabe'
|
|
,9
|
|
,1
|
|
,1
|
|
,'Green'
|
|
,'Black')
|
|
GO
|
|
select * from TBMWF_PROFILE_OBJ_STATE
|
|
|
|
INSERT INTO TBMWF_PROFILE_OBJ_STATE (MWF_PROFILE_ID,USR_ID,OBJ_ID,STATE_ID) VALUES
|
|
(1,1,12968,1);
|
|
DECLARE @GUID BIGINT
|
|
SELECT @GUID = MAX(GUID) FROM TBMWF_PROFILE_OBJ_STATE;
|
|
INSERT INTO TBMWF_PROF_CONTROLS_TF (
|
|
OBJ_STATE_ID,ATTR_NAME, CTRL_TYPE, CAPTION, TEXT, ICON, MANDATORY, CHOICE_LIST, READ_ONLY, SEQU)
|
|
VALUES (@GUID, 'INV_NO', 'TXT', 'Rechnungs-Nummer', 'RE-4711', 'bookmark', 0, '', 1, 0),
|
|
(@GUID, 'CREDITOR', 'TXT', 'Kreditor-Name', 'Europcar GmbH', 'credit-card', 0, '', 1, 1),
|
|
(@GUID, 'Combobox1','CMB', 'Ein Combo-Feld:', '', 'check2-circle',1, 'Eintrag1;Eintrag2', 0, 2),
|
|
(@GUID, 'Comment','TXT', 'Bemerkung', '', 'chat-square-text', 0, '', 0, 3);
|
|
|
|
|
|
INSERT INTO TBMWF_PROFILE_USER (MWF_PROFILE_ID,USR_ID) VALUES (1,1),(2,1);
|
|
INSERT INTO [dbo].[TBMWF_PROF_BUTTONS]
|
|
([MWF_PROFILE_ID]
|
|
,[BTN_TYPE]
|
|
,[TEXT]
|
|
,[ICON]
|
|
,[FORE_COLOR]
|
|
,[BACK_COLOR]
|
|
,[COMMAND]
|
|
,ADDED_WHO
|
|
)
|
|
VALUES
|
|
(1
|
|
,1
|
|
,'Genehmigen'
|
|
,'check-square-fill'
|
|
,''
|
|
,'Green'
|
|
,'UPDATE TBMWF_PROFILE_OBJ_STATE SET STATE_ID = 3 WHERE GUID = @OBJ_STATE_ID '
|
|
,'DD-MS')
|
|
GO
|
|
INSERT INTO [dbo].[TBMWF_PROF_BUTTONS]
|
|
([MWF_PROFILE_ID]
|
|
,[BTN_TYPE]
|
|
,[TEXT]
|
|
,[ICON]
|
|
,[FORE_COLOR]
|
|
,[BACK_COLOR]
|
|
,[COMMAND]
|
|
,ADDED_WHO
|
|
)
|
|
VALUES
|
|
(1
|
|
,2
|
|
,'Ablehnen'
|
|
,'sign-stop-fill'
|
|
,''
|
|
,'Red'
|
|
,'UPDATE TBMWF_PROFILE_OBJ_STATE SET STATE_ID = 4 WHERE GUID = @OBJ_STATE_ID '
|
|
,'DD-MS')
|
|
GO
|
|
|
|
|