config.db.properties

CRM源码This file describes some issues that should be implemented in future and how it should be imple

## ===================================
## SQL queries for config DAO classes.
## ===================================


## View Objects config
select_view_objects = select pkey, name, parent_object, type, icon, order_in_group, inframelinks, grid from QX_VIEW_OBJECTS
delall_permission_in_set = delete from QX_PERMISSION where object_id in
delall_form_settings_in_set = delete from QX_FORM_SETTINGS where view_object_id in
delall_view_object_in_set = delete from QX_VIEW_OBJECTS where pkey in
updateall_role_in_set = update QX_ROLE set default_focus_id = null where default_focus_id in

#referencing settings tables
delall_external_set = DELETE FROM QX_EXTERNALSET
delall_external_form = DELETE FROM QX_EXTERNALFORM
delall_external_field = DELETE FROM QX_EXTERNALFIELD
delall_linked_datasource = DELETE FROM QX_LINKEDDATASET
delall_header = DELETE FROM QX_HEADER
delall_row = DELETE FROM QX_ROW
delall_col = DELETE FROM QX_COL
delall_button = DELETE FROM QX_BUTTON
delall_html_element = DELETE FROM QX_HTML_ELEMENT
delall_hiddencontrol = DELETE FROM QX_HIDDENCONTROL
delall_link = DELETE FROM QX_LINK

#view object params
focus_type_id = 0
subfocus_type_id = 1
tab_type_id = 2
form_type_id = 3
field_type_id = 4

#view objects
insert_focus = INSERT INTO QX_VIEW_OBJECTS ( pkey, name, type, parent_object, order_in_group, icon, inframelinks, grid ) VALUES (?, ?, 0, ?, ?, ?, ?, ?)
insert_subfocus = INSERT INTO QX_VIEW_OBJECTS ( pkey, name, type, parent_object, order_in_group, icon, inframelinks, grid ) VALUES (?, ?, 1, ?, ?, ?, ?, ?)
insert_tab = INSERT INTO QX_VIEW_OBJECTS ( pkey, name, type, parent_object, order_in_group, icon, inframelinks, grid ) VALUES (?, ?, 2, ?, ?, ?, ?, ?)
insert_form = INSERT INTO QX_VIEW_OBJECTS ( pkey, name, type, parent_object, order_in_group, icon, inframelinks, grid ) VALUES (?, ?, 3, ?, ?, ?, ?, ?)
update_object = UPDATE QX_VIEW_OBJECTS SET order_in_group=?, icon=?, inframelinks=?, grid=? WHERE pkey=?

#form settings
delete_form_settings = DELETE FROM QX_FORM_SETTINGS WHERE view_object_id=?
insert_form_settings = INSERT INTO QX_FORM_SETTINGS ( view_object_id, entity_id, grid, use_default_actions, labels_layout, myqueweb, autosearch) VALUES (?, ?, ?, ?, ?, ?, ?)

#tab settings
delall_helplink = DELETE FROM QX_HELPLINK
delete_helplink = DELETE FROM QX_HELPLINK WHERE TAB_ID = ?
insert_helplink = INSERT INTO QX_HELPLINK (TAB_ID, LINK) VALUES (?, ?)
select_helplink = SELECT LINK FROM QX_HELPLINK WHERE TAB_ID = ?

insert_external_set = INSERT INTO QX_EXTERNALSET ( FORM_ID, EXTERNALFORM_ID ) VALUES ( ?, ? )
insert_external_form = INSERT INTO QX_EXTERNALFORM ( FORM_ID, EXTERNALFORM_ID ) VALUES ( ?, ? )
insert_external_field = INSERT INTO QX_EXTERNALFIELD ( FORM_ID, EXTERNALFORM_ID, EXTERNALFIELD, SOURCEFIELD ) VALUES ( ?, ?, ?, ? )
insert_linked_datasource = INSERT INTO QX_LINKEDDATASET ( FORM_ID, ENTITY_ID, DATASET_ID ) VALUES ( ?, ?, ? )
insert_header = INSERT INTO QX_HEADER (FORM_ID, HEADER_ORDER, CLIENT_WIDTH) VALUES (?, ?, ?)
insert_row = INSERT INTO QX_ROW (FORM_ID, ROW_ORDER) VALUES (?, ?)
insert_col = INSERT INTO QX_COL (FORM_ID, ROW_ORDER, COL_ORDER, FIELD_ID, ROWSPAN, COLSPAN) VALUES (?, ?, ?, ?, ?, ?)
insert_button = INSERT INTO QX_BUTTON (FORM_ID, BUTTON_ID, BUTTON_ORDER, PERMISSION) VALUES (?, ?, ?, ?)
insert_html_element = INSERT INTO QX_HTML_ELEMENT (FORM_ID, HTML_ELEMENT_ID, HTML_ELEMENT_ORDER) VALUES (?, ?, ?)
insert_hiddencontrol = INSERT INTO QX_HIDDENCONTROL (FORM_ID, FIELD_ID) VALUES (?, ?)
insert_link = INSERT INTO QX_LINK (FORM_ID, FIELD_ID, LINKED_FORM_ID) VALUES (?, ?, ?)

select_focus = SELECT order_in_group, icon FROM QX_VIEW_OBJECTS WHERE name = ?
select_all_focuses  = SELECT name, order_in_group, icon FROM QX_VIEW_OBJECTS where type = 0 order by order_in_group
select_all_subfocus = SELECT VO.NAME, VO.order_in_group, VO.icon \
  FROM QX_VIEW_OBJECTS VO LEFT JOIN QX_VIEW_OBJECTS PARENT_VO ON VO.PARENT_OBJECT = PARENT_VO.PKEY \
  WHERE PARENT_VO.NAME = ? AND VO.TYPE = 1 ORDER BY VO.order_in_group
select_all_tabs     = SELECT VO.NAME, VO.order_in_group, VO.inframelinks, VO.grid \
  FROM QX_VIEW_OBJECTS VO LEFT JOIN QX_VIEW_OBJECTS PARENT_VO ON VO.PARENT_OBJECT = PARENT_VO.PKEY \
  WHERE PARENT_VO.NAME = ? AND VO.TYPE = 2 ORDER BY VO.order_in_group
select_all_forms    = SELECT VO.NAME, FS.ENTITY_ID, VO.order_in_group, FS.GRID, FS.USE_DEFAULT_ACTIONS, FS.LABELS_LAYOUT, FS.MYQUEWEB, FS.AUTOSEARCH \
  FROM \
  QX_VIEW_OBJECTS VO \
  LEFT JOIN QX_VIEW_OBJECTS PARENT_VO ON VO.PARENT_OBJECT = PARENT_VO.PKEY \
  LEFT JOIN QX_FORM_SETTINGS FS ON VO.PKEY=FS.VIEW_OBJECT_ID   \
  WHERE \
  PARENT_VO.NAME = ? AND VO.TYPE = 3 ORDER BY VO.order_in_group

select_external_set = SELECT EXTERNALFORM_ID FROM QX_EXTERNALSET WHERE FORM_ID = ?
select_external_form = SELECT EXTERNALFORM_ID FROM QX_EXTERNALFORM WHERE FORM_ID = ?
select_external_field = SELECT EXTERNALFORM_ID, EXTERNALFIELD, SOURCEFIELD FROM QX_EXTERNALFIELD WHERE FORM_ID = ?
select_internal_field = SELECT FORM_ID, EXTERNALFIELD FROM QX_EXTERNALFIELD WHERE EXTERNALFORM_ID = ?
select_linked_datasource = SELECT ENTITY_ID, DATASET_ID FROM QX_LINKEDDATASET WHERE FORM_ID = ?
select_header = SELECT CLIENT_WIDTH FROM QX_HEADER WHERE FORM_ID = ? ORDER BY HEADER_ORDER
select_row = SELECT ROW_ORDER FROM QX_ROW WHERE FORM_ID = ? ORDER BY ROW_ORDER
select_col = SELECT FIELD_ID, ROWSPAN, COLSPAN FROM QX_COL WHERE FORM_ID = ? AND ROW_ORDER = ? ORDER BY COL_ORDER
select_button = SELECT BUTTON_ID, PERMISSION FROM QX_BUTTON WHERE FORM_ID = ? ORDER BY BUTTON_ORDER
select_html_element = SELECT HTML_ELEMENT_ID FROM QX_HTML_ELEMENT WHERE FORM_ID = ? ORDER BY HTML_ELEMENT_ORDER
select_hiddencontrol = SELECT FIELD_ID FROM QX_HIDDENCONTROL WHERE FORM_ID = ?
select_link = SELECT FIELD_ID, LINKED_FORM_ID FROM QX_LINK WHERE FORM_ID = ?


## ContextMenuConfig.
## ==============

delall_contextMenu = DELETE FROM QX_CONTEXTMENU
delall_menuItem = DELETE FROM QX_MENUITEM
delall_menuForm = DELETE FROM QX_CONTEXTMENU_FORM

select_contextMenu = SELECT CONTEXTMENU_ID FROM QX_CONTEXTMENU
select_menuItem = SELECT MENUITEM_ID, CONTEXTMENU_ID, MENUITEM_ORDER FROM QX_MENUITEM WHERE CONTEXTMENU_ID = ? ORDER BY MENUITEM_ORDER
select_menuForm = SELECT FORM_ID, CONTEXTMENU_ID FROM QX_CONTEXTMENU_FORM WHERE CONTEXTMENU_ID = ?

insert_contextMenu = INSERT INTO QX_CONTEXTMENU (CONTEXTMENU_ID) VALUES (?)
insert_menuItem = INSERT INTO QX_MENUITEM (MENUITEM_ID, CONTEXTMENU_ID, MENUITEM_ORDER) VALUES (?, ?, ?)
insert_menuForm = INSERT INTO QX_CONTEXTMENU_FORM (FORM_ID, CONTEXTMENU_ID) VALUES (?, ?)


## Localization.
## ==============

delete_localization = DELETE FROM QX_LOCALIZATION WHERE LOCALIZATION_ID = ? AND OBJECT_TYPE_ID = ? AND LOCALIZATION_TYPE_ID = ?
select_localization = SELECT LANGUAGE_ID, CONTENT FROM QX_LOCALIZATION WHERE LOCALIZATION_ID = ? AND OBJECT_TYPE_ID = ? AND LOCALIZATION_TYPE_ID = ?
insert_localization = INSERT INTO QX_LOCALIZATION (LOCALIZATION_ID, LOCALIZATION_TYPE_ID, OBJECT_TYPE_ID, LANGUAGE_ID, CONTENT) VALUES (?, ?, ?, ?, ?)


## EntityConfig.
## =============

delall_entity = DELETE FROM QX_ENTITY
del_entity = DELETE FROM QX_ENTITY WHERE ENTITY_ID = ?
insert_entity = INSERT INTO QX_ENTITY ( ENTITY_ID, ENTITYDATA ) VALUES ( ?, ? )
select_all_entity = SELECT ENTITY_ID, ENTITYDATA FROM QX_ENTITY
select_entity = SELECT ENTITYDATA FROM QX_ENTITY WHERE ENTITY_ID = ?


## HistoryConfig.
## =============

insert_his_table = INSERT INTO QX_HIS_TABLE ( HIS_TABLE_ID, NAME ) VALUES ( ?, ? )
select_his_table = SELECT HIS_TABLE_ID FROM QX_HIS_TABLE WHERE NAME = ?
insert_his_field = INSERT INTO QX_HIS_FIELD ( HIS_FIELD_ID, HIS_TABLE_ID, NAME ) VALUES ( ?, ?, ? )
select_his_field = SELECT HIS_FIELD_ID FROM QX_HIS_FIELD WHERE NAME = ? AND HIS_TABLE_ID = ?


## UserPropertyConfig.
## ===================

delete_user_prop = DELETE FROM QX_USER_PROP WHERE PROP_ID = ? AND USER_ID = ? AND USER_TYPE_ID = ?
delete_user_prop_starts_with = DELETE FROM QX_USER_PROP WHERE USER_ID = ? AND USER_TYPE_ID = ? AND PROP_ID LIKE ?
insert_user_prop = INSERT INTO QX_USER_PROP ( PROP_ID, USER_ID, USER_TYPE_ID, PROP_VAL ) VALUES ( ?, ?, ?, ? )
update_user_prop = UPDATE QX_USER_PROP SET PROP_VAL = ?  WHERE PROP_ID = ? AND USER_ID = ? AND USER_TYPE_ID = ?
select_all_user_prop = SELECT PROP_ID, PROP_VAL FROM QX_USER_PROP WHERE USER_ID = ? AND USER_TYPE_ID = ?
select_user_prop_starts_with = SELECT PROP_ID, PROP_VAL FROM QX_USER_PROP WHERE USER_ID = ? AND USER_TYPE_ID = ? AND PROP_ID LIKE ?
select_user_prop = SELECT PROP_VAL FROM QX_USER_PROP WHERE PROP_ID = ? AND USER_ID = ? AND USER_TYPE_ID = ?


## SysProperty.
## ============

delete_sys_prop = DELETE FROM QX_SYS_PROP WHERE PROP_ID = ?
insert_sys_prop = INSERT INTO QX_SYS_PROP ( PROP_ID, PROP_VAL ) VALUES ( ?, ? )
update_sys_prop = UPDATE QX_SYS_PROP SET PROP_VAL = ?  WHERE PROP_ID = ?
select_sys_prop = SELECT PROP_VAL FROM QX_SYS_PROP WHERE PROP_ID = ?