ui-dt-radio.sql

国外的一套开源CRM

-- Insert UiDisplayType
INSERT INTO UI_DISPLAY_TYPE (
  DISPLAY_TYPE_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'RADIO'
 ,'Radio Buttons'
 ,'Set of radio buttons generated from fixed values or from SQL table<BR><BR>Translates to a multiple HTML < INPUT type=RADIO > tags '
);

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

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

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'RADIO'
 ,'EMPTY_FIRST'
 ,'Empty First'
 ,'Empty First<BR><BR>Defines whether to add a radio button for blank response.<BR>Should be set to "Y" or "N".'
);

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'RADIO'
 ,'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 (
  'RADIO'
 ,'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 next to the radio buttons.<BR>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 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 (
  'RADIO'
 ,'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 radio buttons are 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 (
  'RADIO'
 ,'ENTITY_FIND_METHOD'
 ,'Entity Find Method'
 ,'Entity Find Method<BR><BR>Used if fill method is "ENTITY".<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 (
  'RADIO'
 ,'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".<BR>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 (
  'RADIO'
 ,'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 by the radio buttons, 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 (the radio buttons are 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 entity represented by the radio buttons.  The second string should either be an attribute name from the primary entity in the screen section the radio buttons are being used 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 (
  'RADIO'
 ,'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 radio buttons.<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 < INPUT > tag.<BR><BR>Example:<BR>codeTypeId;codeId'
);

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

-- Insert UiDisplayAttrib
INSERT INTO UI_DISPLAY_ATTRIB (
  DISPLAY_TYPE_ID
 ,DISPLAY_ATTRIB_ID
 ,NAME
 ,DESCRIPTION
) VALUES (
  'RADIO'
 ,'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 (
  'RADIO'
 ,'FIXED_VALUES'
 ,'Fixed Values'
 ,'Fixed value list<BR><BR>Translates to VALUE attribute of HTML < INPUT > tag.<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 (
  'RADIO'
 ,'READONLY'
 ,'Read Only'
 ,'Read only<BR><BR>Translates to READONLY attribute of the HTML < INPUT > tags.<BR>Value should be Y or N.'
);

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