security.db.properties

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

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


## Users.
## ======

get_user_type_name = SELECT NAME FROM QX_USER_TYPE WHERE USER_TYPE_ID = ?
get_employee = SELECT LOGINNAME, FULLNAME, PASSWORD FROM QX_USERS WHERE PKEY = ?
get_employee_by_login = SELECT PKEY, FULLNAME, PASSWORD FROM QX_USERS WHERE LOGINNAME = ?
get_employee_usergroups_by_id = SELECT DISTINCT W.PKEY, G.TIER FROM QX_USERS E, QX_GROUPMEMBER G, QX_WORKGROUP W WHERE E.PKEY = G.EMPLOYEEGROUP AND G.WORKGROUPGROUP = W.PKEY AND E.PKEY = ?
get_employee_roles_by_id = SELECT DISTINCT S.SECURITY_ID FROM QX_USERS E, QX_GROUPMEMBER G, QX_WORKGROUP W, QX_SECURITY S WHERE E.PKEY = G.EMPLOYEEGROUP AND G.WORKGROUPGROUP = W.PKEY AND W.SECURITY_ID = S.SECURITY_ID AND E.PKEY = ?
get_employee_email_by_id = SELECT EMAIL FROM QX_USERS WHERE PKEY = ?
get_employees_by_group_id = SELECT E.PKEY, E.LOGINNAME, E.FULLNAME, E.PASSWORD FROM QX_USERS E, QX_GROUPMEMBER G WHERE E.PKEY = G.EMPLOYEEGROUP AND G.WORKGROUPGROUP = ?
get_employees_by_group_id_and_tier = SELECT E.PKEY, E.LOGINNAME, E.FULLNAME, E.PASSWORD FROM QX_USERS E, QX_GROUPMEMBER G WHERE E.PKEY = G.EMPLOYEEGROUP AND G.WORKGROUPGROUP = ? AND G.TIER = ?

update_employee_password = UPDATE SW_PERSON SET PASSWORD = ? WHERE SWPERSONID = ?

get_admin_focus = SELECT FOCUS_ID FROM QX_FOCUS WHERE FOCUS_ID LIKE '%admin%'

get_contact_center_id = SELECT SWCALLCENTERID FROM SW_PERSON WHERE SWLOGIN = ? 

# [ALB] not supported
#get_customer =
#get_customer_by_login =
#get_customer_roles_by_id =
#get_customer_email_by_id =
#update_customer_password =


## User Groups.
## ============
get_usergroup_notify_method = SELECT NOTIFYMETHOD FROM QX_GROUPMEMBER WHERE EMPLOYEEGROUP = ? AND 0 >= ? AND WORKGROUPGROUP = ?


## Groups.
## =======

get_group_by_id = SELECT NAME FROM QX_WORKGROUP WHERE PKEY = ?
get_group_email_by_id = SELECT NOTIFICATIONADDR FROM QX_WORKGROUP WHERE PKEY = ?
get_group_notify_method_by_id = SELECT NOTIFYMETHOD FROM QX_WORKGROUP WHERE PKEY = ?


## Security.
## =========

get_role_by_id = SELECT NAME, FOCUS_ID FROM QX_SECURITY WHERE SECURITY_ID = ?
check_focus_access = SELECT 1 FROM QX_RIGHT WHERE SECURITY_ID = ? AND ACCESS_LEVEL > 0 AND FOCUS_ID = ?
check_tab_access = SELECT 1 FROM QX_RIGHT WHERE SECURITY_ID = ? AND ACCESS_LEVEL > 0 AND TAB_ID = ?
get_form_access_level = SELECT ACCESS_LEVEL FROM QX_RIGHT WHERE SECURITY_ID = ? AND FORM_ID = ?
get_entity_access_level = SELECT ACCESS_LEVEL FROM QX_PERMISSION WHERE SECURITY_ID = ? AND ENTITY_ID = ?


## User parameters.
## ================

get_lang_by_id = SELECT NAME FROM QX_LANGUAGE WHERE LANGUAGE_ID = ?
get_all_langs = SELECT LANGUAGE_ID, NAME FROM QX_LANGUAGE ORDER BY LANGUAGE_ID
get_tz_by_id = SELECT NAME FROM QX_TIMEZONE WHERE TIMEZONE_ID = ?
get_all_timezones = SELECT TIMEZONE_ID,NAME FROM QX_TIMEZONE ORDER BY NAME
get_country_by_id = SELECT NAME FROM QX_COUNTRY WHERE COUNTRY_ID = ?
get_all_countries = SELECT COUNTRY_ID, NAME FROM QX_COUNTRY ORDER BY COUNTRY_ID
get_country_lang_by_id = SELECT LANGUAGE_ID FROM QX_LANGUAGE WHERE LANGUAGE_ID = (SELECT DEF_LANG_ID FROM QX_COUNTRY WHERE COUNTRY_ID = ?)
get_country_tz_by_id = SELECT TIMEZONE_ID FROM QX_TIMEZONE WHERE TIMEZONE_ID = (SELECT DEF_TIMEZONE_ID FROM QX_COUNTRY WHERE COUNTRY_ID = ?)