ui-dt-select.sql

国外的一套开源CRM

-- Insert UiDisplayType
INSERT INTO UI_DISPLAY_TYPE (
  DISPLAY_TYPE_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'Select List (Drop Down)'
 ,'Select list generated from fixed values or from SQL table<BR><BR>Translates to HTML tag < SELECT >'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'ANCHOR_HREF_DEF'
 ,'Anchor (Link) Reference Definition'
 ,'Anchor (Link) Reference Definition<BR><BR>If this parameter is set, the field will be displayed as an HTML < A > tag when in read only-mode.<BR><BR>Contents must be a semicolon-delimited list of attribute names from the listed entity.<BR>Literal strings may also be embedded with quotes around them.<BR>Values from the specified attributes will be concatentated along with any embedded quoted literals, and used as the HREF value for the < A > tag.<BR>"#currentField" can be used in place of an attribute name to use the current field value.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'ANCHOR_TARGET'
 ,'Anchor (Link) Target'
 ,'Anchor (Link) Target<BR><BR>If this parameter and the ANCHOR_HREF_DEF parameter are set, the field will be displayed as an HTML < A > tag when in read-only mode, and the value of this parameter will be used as the value for the TARGET attribute of the < A > tag.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'CLASS'
 ,'Class'
 ,'Style class<BR><BR>Defines what style from the style sheet to assign to the CLASS attribute of the select.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'DISABLED'
 ,'Disabled'
 ,'Disabled<BR><BR>Translates to the DISABLED attribute of the HTML < SELECT > tag.<BR>Value should be Y or N.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'EMPTY_FIRST'
 ,'Empty First'
 ,'Empty First<BR><BR>Defines whether to add an empty item at the top of the select list.<BR>Should be set to Y or N.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'ENTITY'
 ,'Entity'
 ,'Entity<BR><BR>Defines the data entity(ies) to use to create the data list.<BR>Required if fill method is "ENTITY"'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'ENTITY_DISPLAY_DEF'
 ,'Entity Display Definition'
 ,'Entity display definition<BR><BR>Required if fill method is "ENTITY".<BR>Defines which attribute(s) of the entity to display in the drop down list.<BR>Must be a semicolon-delimited list of attribute names from the listed entity.<BR>Quoted literal strings may also be embedded.<BR>Values from the specified attributes will be concatentated along with any embedded quoted literals and used in the VALUE attribute of the < INPUT > tag.<BR>"#currentField" can be used in place of an attribute name to use the current field value.<BR><BR>Example:<BR>contactId;" - (";contactName;")"'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'ENTITY_FIND_DEF'
 ,'Entity Find Definition'
 ,'Entity find definition<BR><BR>Required if fill method is "ENTITY" and find method is "ATTRIBUTE_MATCH".<BR>Defines which attribute(s) of the entity to use as search values.<BR>Must be a list of attribute name pairs.<BR>The pairs should be separted by semicolons (;) between pairs.<BR>The two values in each pair should be separated by a colon (:).<BR>In each attribute pair, the first attribute name should be from the listed entity, and the second attribute name should be from the primary entity on the screen section the drop down select object is being used on.<BR><BR>Examples:<BR>sectionId:sectionId;partyId:"-1"<BR>codeTypeId:"INDUSTRY"'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'ENTITY_FIND_METHOD'
 ,'Entity Find Method'
 ,'Entity Find Method<BR><BR>Defines how to find which instances of the entity to put in the list.<BR>Required if fill method is "ENTITY".<BR>Must be set to "ALL" or "ATTRIBUTE_MATCH".<BR>If value is "ATTRIBUTE_MATCH", the ENTITY_FIND_ATTRIBUTES must also be specified.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'ENTITY_ORDER_DEF'
 ,'Entity Order Definition'
 ,'Entity order definition<BR><BR>Defines which attribute(s) of the listed entity to sort by.<BR>May be used if fill method is "ENTITY".  Must be a semicolon-delimited list of attribute names from the listed entity.<BR><BR>Example:<BR>contactLastName;contactFirstName'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'ENTITY_PK_FIND_DEF'
 ,'Entity Primary Key Find Definition'
 ,'Entity primary key find definition<BR><BR>Required if fill method is "ENTITY".<BR>Defines the primary key of the entity represented bin the select list, and defines how to find the instance of the entity that is currently selected on the screen.<BR>This is used to display the selected item when not in edit mode (drop down list is not displayed in this case, just the display value according to the ENTITY_DISPLAY_DEF attribute.<BR>Should contain a list of attribute name pairs.<BR>The pairs should be separted by semicolons (;) between pairs.<BR>The two values in each pair should be separated by a colon (:).<BR>In each attribute pair, the first string of each pair should be the name of an attribute in the primary key of the listed entity.  The second string should either be an attribute name from the primary entity in the screen section the select list appears on, or a quoted literal string that will be used as a fixed value.<BR><BR>Examples:<BR>sectionId:sectionId;partyId:"-1";attributeId:attributeId<BR>codeTypeId:"INDUSTRY";codeId:industry'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'ENTITY_VALUE_DEF'
 ,'Entity Value Definition'
 ,'Entity value definition<BR><BR>Required if fill method is "ENTITY".<BR>Defines which attribute(s) of the entity to use as values for the drop down select object.<BR>Must be a semicolon-delimited list of attribute names from the listed entity.<BR>Values from the specified attributes will be concatentated and used in the VALUE attribute of the < OPTION > tags.<BR><BR>Example:<BR>codeTypeId;codeId'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'EVENT_HANDLING'
 ,'Event Handling'
 ,'Event Handling<BR><BR>Specifies a string to be inserted into the opening < SELECT > tag to call scripts when events occur.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'FILL_METHOD'
 ,'List Fill Method'
 ,'List fill method<BR><BR>Determines whether the list will be filled from a fixed values list ("FIXED") or from an entity in the database ("ENTITY").'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'FIXED_VALUES'
 ,'Fixed Values'
 ,'Fixed value list<BR><BR>Translates to VALUE attribute of HTML < OPTION > tags.<BR>Should contain a list of string values delimited by semicolons.'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'SELECT'
 ,'SIZE'
 ,'Size'
 ,'Field size<BR><BR>Translates to the SIZE attribute of the HTML < SELECT > tag'
);