ui-do-54.sql

来自「国外的一套开源CRM」· SQL 代码 · 共 144 行

-- Insert UiDisplayObject
INSERT INTO UI_DISPLAY_OBJECT (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  '54'
 ,'SEARCH_TEXT'
 ,'Search Text - Activity'
 ,'Activity Search Text'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '54'
 ,'SEARCH_TEXT'
 ,'ANCHOR_HREF_DEF'
 ,'"javascript:var newWindow=window.open(''/sfa/control/activityPopup?action=show&activityId=";#currentField;"'', ''_blank'', ''menubar=no,scrollbars=no,toolbar=no,directories=no,top=10,left=10,height=560,width=900'', '''')"'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '54'
 ,'SEARCH_TEXT'
 ,'ANCHOR_TARGET'
 ,'content'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '54'
 ,'SEARCH_TEXT'
 ,'CLASS'
 ,'selectBox'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '54'
 ,'SEARCH_TEXT'
 ,'ENTITY'
 ,'Activity'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '54'
 ,'SEARCH_TEXT'
 ,'ENTITY_DISPLAY_DEF'
 ,'activityName'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '54'
 ,'SEARCH_TEXT'
 ,'ENTITY_ORDER_DEF'
 ,'activityName'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '54'
 ,'SEARCH_TEXT'
 ,'ENTITY_PK_FIND_DEF'
 ,'activityId:#currentField'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '54'
 ,'SEARCH_TEXT'
 ,'ENTITY_SEARCH_DEF'
 ,'activityName'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '54'
 ,'SEARCH_TEXT'
 ,'ENTITY_VALUE_DEF'
 ,'activityId'
);

-- Insert UiDisplayObjectAttrib
INSERT INTO UI_DISPLAY_OBJECT_ATTRIB (
  DISPLAY_OBJECT_ID
 ,DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,ATTRIBUTE_VALUE
) VALUES (
  '54'
 ,'SEARCH_TEXT'
 ,'SIZE'
 ,''
);