-- uses company structure
company/www/team/teams-tasks.tcl:company_structure_info_full
company/www/admin/team/add-edit.tcl: set rm_list [db_list_of_lists get_rms "select initcap(pretty_member_name), member_id from company_structure_info where parent_group_name = 'Regional Managers' order by lower(pretty_member_name)"]
mycsm/www/admin/report-object-view-detailed.tcl: from company_structure_info
projectcrew/www/sa-tree.tcl: select distinct(parent_group_id) from company_structure_info where parent_group_name = 'District Managers'}]
projectcrew/www/messaging.tcl: from company_structure_info csi,
projectcrew/www/admin/company-structure-upload.tcl: from company_structure_info
projectcrew/www/admin/company-structure-display.tcl: from company_structure_info_full s
projectcrew/www/admin/company-position-remove.tcl: from company_structure_info_full
projectcrew/www/admin/stores-structure-manage.tcl: from company_structure_info_full c
projectcrew/www/admin/company-structure-manage.xql: from company_structure_info_full
projectcrew/www/admin/company-position-manage.tcl: {![db_string get_a_name "select 1 from company_structure_info_full where group_name = :group_name and group_id <> :group_id" -default 0]}
projectcrew/sql/postgresql/company-and-store-views.sql:drop view company_structure_info;
projectcrew/sql/postgresql/company-structure.sql: join company_structure_info_full c
******** can change to company_dm_sa_map
visacard-db/www/index.tcl
stores/www/change-sa.tcl: from company_structure_info
stores/www/ae.tcl: from company_structure_info
******** can remove
csi-audit/www/audit-view-summary.tcl: left join company_structure_info i on
csi-audit/www/audit-view.tcl: left join company_structure_info i on
csi-audit/www/audit-view.tcl: LEFT OUTER JOIN company_structure_info i ON (s.dm_id = i.member_id and i.parent_group_name = 'District Managers'),
csi-audit/www/audit-view-summary.xql: LEFT OUTER JOIN company_structure_info i ON (s.dm_id = i.member_id and i.parent_group_name = 'District Managers')
csi-audit/www/audit-view-summary.xql: LEFT OUTER JOIN company_structure_info i ON (s.dm_id = i.member_id and i.parent_group_name = 'District Managers')
******** rels based
acs-admin/www/users/member-state-change.tcl: from company_structure_info
acs-admin/www/users/delete.tcl: from company_structure_info
acs-admin/www/users/users-bulk-upload-2.tcl: from company_structure_info
******** can move to dm_info rm_info tables
jobs-db/www/job-apply.tcl: company_structure_info_full f,
jobs-db/www/xmlhttp/controlpanel/form_wfperform.tcl: company_structure_info_full f2,
jobs-db/www/xmlhttp/controlpanel/data_reports_applicants.tcl: left join company_structure_info_full c on (c.member_id = f.dm_id and c.parent_group_name = 'District Managers'),
jobs-db/tcl/report-procs.tcl: company_structure_info_full f2,
projectcrew/www/quick-search.tcl: from company_structure_info
projectcrew/www/user-cal-nav.tcl:set rm_list [util_memoize {db_list_of_lists get_rum "select distinct(email) as dm_email, member_id as dm_id from company_structure_info where parent_group_name = 'Regional Managers'"} $max_age]
projectcrew/www/admin/dms-email.tcl: from company_structure_info csi2
projectcrew/tcl/project-procs.tcl: from company_structure_info i,
-- key on DM so just check if it still works
packages/csi-audit/www/audit-view.tcl
packages/projectcrew/www/admin/dms-email.tcl
-- key on SA so just check if it still works
packages/stores/www/change-sa.tcl
packages/stores/www/ae.tcl
-- key on RM so just check if it still works
packages/projectcrew/www/user-cal-nav.tcl
-- key on RM, DM, SA so just check if it still works
packages/projectcrew/www/sa-tree.tcl
-- uses full view but key on SA
-- needs thorough checking
* packages/company/www/team/teams-tasks.tcl
* packages/stores/www/update-from-csv.tcl
-- needs rewrite of views
packages/projectcrew/sql/postgresql/company-and-store-views.sql
packages/projectcrew/sql/postgresql/company-structure.sql
-- needs to check for PM support
packages/projectcrew/www/quick-search.tcl
packages/projectcrew/www/admin/company-structure-upload.tcl
packages/projectcrew/www/admin/company-structure-display.tcl
packages/projectcrew/www/admin/company-position-remove.tcl
packages/projectcrew/www/admin/stores-structure-manage.tcl
packages/projectcrew/www/admin/company-structure-manage.xql
packages/projectcrew/www/admin/company-position-manage.tcl
packages/mycsm/www/admin/report-object-view-detailed.tcl
packages/projectcrew/tcl/project-procs.tcl (used by autosuggest)
-- no change, PM support will be in another tab
packages/projectcrew/www/messaging.tcl