Reposting my CFC outlines. Fixed some bad wrapping.
Joe
AdminEmpCFC USED FOR EMPLOYEE ADMIN
========================================================================
Variables.LOCK_NAME UNIQUE NAME (UUID) FOR NAMED LOCK
Variables.DSN APPLICATION DSN
Variables.SCOPE SCOPE IN WHICH INSTANCE EXISTS
Variables.USER_ID UNIQUE ID OF CURRENT USER
NOTE: "SPAN" REFERS TO USER'S SPAN OF
CONTROL
Variables.span_top_mgr_list LIST - TOP-LEVEL MGRS AND DIRECTORS IN
SPAN
Variables.span_all_mgr_list LIST - ALL MGRS AND DIRECTORS IN SPAN
Variables.span_all_mgr_data QUERY - DATA ON ALL MGRS AND DIRECTORS IN
SPAN
Variables.span_emp_data QUERY - DATA ON ALL EMPS IN SPAN
Variables.span_emp_data_html HTML CODE FOR EMPLOYEE ADMIN PAGE
Variables.span_all_mgr_js JAVASCRIPT CODE FOR MGR AND DIRECTOR JS
ARRAYS FOR DYNAMIC HTML SELECTS
Variables.active_dirs QUERY - DATA ON ACTIVE DIRECTORS
Variables.active_mgrs QUERY - DATA ON ACTIVE MANAGERS
Variables.active_emps QUERY - DATA ON ACTIVE EMPLOYEES
------------------------------------------------------------------------
init()
resetData() CLEARS INSTANCE PROPERTIES
getSpanTopMgrAndDirList() GETS VARIABLES.SPAN_TOP_MGR_LIST; IF IT IS
NOT SET, SETS IT USING DB QUERY
getSpanMgrAndDirList() GETS VARIABLES.SPAN_ALL_MGR_LIST; IF IT IS
NOT SET, SETS IT USING DB QUERY
getSpanMgrAndDirData() GETS VARIABLES.SPAN_ALL_MGR_DATA; IF IT IS
NOT SET, SETS IT USING DB QUERY
getMgrAndDirJSArrays() GETS VARIABLES.SPAN_ALL_MGR_JS
setMgrAndDirJSArrays() SETS VARIABLES.SPAN_ALL_MGR_JS USING
VARIABLES.SPAN_ALL_MGR_DATA
getUserData() GETS ALL EMPLOYEE DATA VIEWABLE BY THIS USER FROM
DATABASE
getUserDataHtml() GETS VARIABLES.SPAN_EMP_DATA_HTML
setUserDataHtml() SETS VARIABLES.SPAN_EMP_DATA_HTML
getAllDirs() GETS DATA FOR ALL DIRECTORS FROM DATABASE
getAllMgrs() GETS DATA FOR ALL MANAGERS FROM DATABASE
getAllEmps() GETS DATA FOR ALL EMPLOYEES (NON-MGMT) FROM DATABASE
getActiveDirs() GETS DATA FOR ACTIVE DIRECTORS FROM getAllDirs();
SETS VARIABLES.ACTIVE_DIRS
getActiveMgrs() GETS DATA FOR ACTIVE MANAGERS FROM getAllMgrs();
SETS VARIABLES.ACTIVE_MGRS
getActiveEmps() GETS DATA FOR ACTIVE EMPLOYEES FROM getAllEmps();
SETS VARIABLES.ACTIVE_EMPS
addUser() ADD A NEW USER TO DATABASE
editUser() EDIT AN EXISTING USER DB RECORD
deleteUser() DELETE AN EXISTING USER
isUserInSpan() RETURNS TRUE IF ARGUMENT EMP_ID IS IN
VARIABLES.SPAN_EMP_DATA (TODO: RENAME TO
isEmpInSpan)
getOneUserInfo() GETS ALL DATA FOR ONE EMPLOYEE FROM
VARIABLES.SPAN_EMP_DATA
(TODO: RENAME TO getOneEmpInfo)
getUserField() GETS ONE FIELD FOR ONE EMPLOYEE FROM
VARIABLES.SPAN_EMP_DATA
(TODO: RENAME TO getEmpField)
------------------------------------------------------------------------
ReportCFC
========================================================================
Variables.LOCK_NAME UNIQUE NAME FOR NAMED LOCK
Variables.DSN APPLICATION DSN
Variables.SCOPE SCOPE IN WHICH INSTANCE EXISTS
Variables.USER_ID UNIQUE ID OF CURRENT USER
Variables.USER_POSITION
Variables.USER_OBJECT REFERENCE TO SESSION.USER
(CTCSurveyUserCFC INSTANCE)
Variables.user_viewable_results QUERY - RESULTS USER IS ALLOWED TO
ACCESS
Variables.survey_questions QUERY - ALL SURVEY QUESTIONS
Variables.results_fields LIST - ALL SURVEY FIELDS FROM RESULTS
TABLE
Variables.recordset QUERY - CURRENT ACTIVE RECORDSET
Variables.filter REPORT PARAMETER
(ShowAll | FyAndQtr | DateRange)
Variables.fy REPORT PARAMETERS
Variables.qtr
Variables.start_date
Variables.end_date
------------------------------------------------------------------------
init()
refreshData() CLEARS INSTANCE PROPERTIES
getUserViewableResults() GET VARIABLES.USER_VIEWABLE_RESULTS
setUserViewableResults() SET VARIABLES.USER_VIEWABLE_RESULTS
USING readUserViewableResults()
readUserViewableResults() FETCH FROM DATABASE DATA FOR
VARIABLES.USER_VIEWABLE_RESULTS
getResultsFields()
setResultsFields()
readResultsFields()
setReportParams() SETTER/GETTER FOR REPORT PARAMETERS
getReportParams()
getSurveyQuestions() SETTER/GETTER FOR SURVEY QUESTIONS
setSurveyQuestions()
readSurveyQuestions() FETCH DATA FOR SURVEY QUESTIONS FROM DATABASE
getReportDataMyCTCs() THESE GET DATA FOR SPECIFIC REPORTS
getReportDataMyCTCMgrs()
getReportDataCTCDetail()
getReportDataCTCMgrSummary()
getReportDataMyAEs()
getReportDataMyAEMgrs()
getReportDataAEDetail()
getReportDataSalesMgrSummary()
------------------------------------------------------------------------
CTCSurveyUserCFC EXTENDS FDX_CFCs.FDX_User
========================================================================
Variables.DSN
Variables.SCOPE
Variables.LOCK_NAME
Variables.emp_id PROPERTIES FOR CURRENT USER FROM LDAP
Variables.first_name
Variables.last_name
Variables.nick_name
Variables.full_name
Variables.phone
Variables.email
Variables.title
Variables.mgr_id
Variables.dept
Variables.dept_num
Variables.address_1
Variables.address_2
Variables.state
Variables.zip
Variables.city
Variables.country
Variables.comat
Variables.mgmt_level
Variables.position PROPERTY UNIQUE TO CTC SURVEY APP
Variables.dir_id PROPERTY UNIQUE TO CTC SURVEY APP
Variables.active PROPERTY UNIQUE TO CTC SURVEY APP
Variables.shadow_id
Variables.logged_in
Variables.app_roles
Variables.page_roles
Variables.direct_reports_user_tbl LIST - IDS OF USER'S CURRENT DIRECT
REPORTS
Variables.direct_reports_rslt_tbl LIST - IDS OF USER'S DIRECT REPORTS
AT TIME OF SURVEY
Variables.direct_reports_all LIST - IDS OF ALL USER'S DIRECT
REPORTS (CURRENT AND AT TIME OF
SURVEY)
Variables.subordinates_user_tbl LIST - IDS OF USER'S CURRENT
SUBORDINATES, INCLUDING DIRECT
REPORTS
Variables.subordinates_rslt_tbl LIST - IDS OF USER'S SUBORDINATES,
INCLUDING DIRECT REPORTS, AT
TIME OF SURVEY
Variables.subordinates_all LIST - IDS OF ALL USER'S
SUBORDINATES, INCLUDING DIRECT
REPORTS (CURRENT AND AT TIME OF
SURVEY)
------------------------------------------------------------------------
init()
logout()
setUserInfo()
getUserInfo()
fetchUserInfo()
getDirectReportsUserTbl() SETTERS/GETTERS FOR
setDirectReportsUserTbl() VARIABLES.DIRECT_REPORTS_xxx
getDirectReportsResultsTbl() IF PROPERTY IS NOT SET, GETTER
setDirectReportsResultsTbl() INVOKES SETTER, WHICH READS FROM
getDirectReportsAll() DATABASE
setDirectReportsAll()
getSubordinatesUserTbl() SETTERS/GETTERS FOR
setSubordinatesUserTbl() VARIABLES.SUBORDINATES_xxx;
getSubordinatesResultsTbl() SUBORDINATES ARE ALL EMPLOYEES IN
setSubordinatesResultsTbl() SPAN OF CONTROL, INCLUDING DIRECT
getSubordinatesAll() REPORTS
setSubordinatesAll()
mergeEmpIdLists()
------------------------------------------------------------------------
FDX_CFCs.FDX_User
========================================================================
Variables.DSN
Variables.SCOPE
Variables.LOCK_NAME
Variables.emp_id PROPERTIES FOR CURRENT USER FROM LDAP
Variables.first_name
Variables.last_name
Variables.nick_name
Variables.full_name
Variables.phone
Variables.email
Variables.title
Variables.mgr_id
Variables.dept
Variables.dept_num
Variables.address1
Variables.address2
Variables.state
Variables.zip
Variables.city
Variables.country
Variables.comat
Variables.mgmt_level
Variables.shadow_id
Variables.logged_in
Variables.app_roles
Variables.page_roles
------------------------------------------------------------------------
init()
login() SETS VARIABLES.LOGGED_IN TO TRUE
loginAs() SETS Variables.shadow_id; ALLOWS ADMIN TO LOGIN AS
ANOTHER USER
logout() SETS VARIABLES.LOGGED_IN TO FALSE; CLEARS PROPERTY VALUES
setUserInfo() SETS PROPERTIES FOR CURRENT USER USING STRUCT FROM
getUserInfo
getUserInfo() RETURNS USER INFO FROM LDAP IN STRUCT
getShadowId()
isLoggedIn()
isInRole()
setAppRoles()
addAppRole()
removeAppRole()
getAppRoles()
setPageRoles()
addPageRole()
removePageRole()
getPageRoles()
getAllRoles()
------------------------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, please follow the instructions at
http://www.cfczone.org/listserv.cfm
CFCDev is supported by:
Katapult Media, Inc.
We are cool code geeks looking for fun projects to rock!
www.katapultmedia.com
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
