-
Notifications
You must be signed in to change notification settings - Fork 1
/
todo.sql
243 lines (216 loc) · 10.8 KB
/
todo.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
#region fm #############################################################################################################
#clean & update list
##remove entries with no identification
##outsource redundant information to validatable items and add validation
#equipment management
#endregion
#region curricula ######################################################################################################
#the program/pool add x feature has weird state problems
#the program/pool add x feature should not attempt to close implicitly if no selection has been made
#restyle the curriculum view to use css grids for container items
#endregion
#region schedule #######################################################################################################
#add loading overlay
#add email notification for schedule changes
#extend delta implementation for explicit created and removed dates
##extend personal profiles for opt-in for notifications
##add function comparing former and current personal and professional plans
##add button to explicitly use said function
#add filter style to more explicitly signal that the filter bar and the filter button are dependent on one another
#firefox is resubmitting forms after the newtab button has been used
#valarm options for the ics export from the export view
#no actions, no checkbox
#export aggregates 'the same' appointment for teachers
#schedule export link includes filter/list selections made
##add to form/state and redirect w/o GET
#add dedicated placeholders for no person responsible
#instances export options to suppress columns/resources
#endregion
#region HIT ############################################################################################################
#expand event templates for new type 'information course' or something similar
#- expand course participants table to include
#-- travel options (public transportation, car, ...)
#-- meal options (cafeteria, eat out, ...)
#- expand profiles with school information
#-- new resource school?
#-- diploma type & year
#- expand profiles for gender?
#coordinate with organizations
#- codes for individual events
#statistical analysis?
#endregion
#region participants ###################################################################################################
#rename instance participants to participations
#add start and end time fields to participations
#purge data
#add a checkout view
#add checkin for appointments where no person is responsible
#endregion
#region tables #########################################################################################################
#move simple get/set functions from helpers/models to tables
#overwrite bind function to use types (and attributes)
#endregion
#region Features #######################################################################################################
#finish subject <=> event handling
#unit publishing & untis unit statistic key for organizer unpublished
#further integrate the status wait list into course participant handling
#integrate 'active' attributes for person, pool & program into documentation output
#add relevance output/toggle to the methods view
#online evaluation portal? open to people who have attended at least x times?
#region thm groups
#crawler?
#extend profiles to allow thm groups profile urls
#link groups profiles
#endregion
#region rooms
#add batch processing for rooms (types, equipment, properties,...)
#capacity filters
#endregion
#add color coding for organizations and legend to the room overview
#region routing
#redo url building and parsing
#add breadcrumbs for appropriate views
#endregion
#tagging
#region interfaces to system landscape
#reading access to his-in-one for student information -> not stored!!!
## has the student completed the requirements of this semester/pool...
## gpa
#endregion
#list and item view pdf exports
#system plugin function for participation change detection
#editor-xtd plugin(s) for resources
#content plugin(s) for resource resolution
#region extend delta information
#add new columns created & removed
#adjust handling to avoid hard coded new/removed
#endregion
#region on schedule upload
#makes as many updates to participant schedules as possible
## event/method context dependent substitutions
# participant notifications
# person notifications
#endregion
#region department views
#resources
#endregion
#endregion
#region Meta ###########################################################################################################
#rework so that classDecode/-Encode is not necessary??
#replace unnecessary double quotes
#update phpexcel
#standardize tooltip use across component 'hasPopover' vs 'hasTooltip' vs 'hasTip'?
#replace JComponentTitle use
#error suppression through inheritance
#associate organizations with campuses
#associated programs with organization (ranked)
#component setting for currency
#media queries for individual list views
#rename instance participants to participations
#rename event coordinators to coordinators
#move constants to helpers
#region update
#create update.xml
#implement update mechanisms
#rudimentary...
##increment v# in manifest
##create new zip
##increment v# in update.xml
#endregion
#region message handling
##messages created in models specific to action
##no message - user interaction where nothing was done such as saving without changing any resource attributes
##success - successful user dm interaction
##notice - unsuccessful user dm interaction due to inconsistent data or any other non-critical error where the user is not at fault
##warning - unsuccessful user dm interaction where form manipulation most likely occurred
##error - unsuccessful user dm where hard db errors occurred or form url manipulation definitely occurred
#endregion
#remove roomtypes from untis
#region adapters
#application adapter (organizer helper)
#html adapter
#language adapter (after com_thm_organizer dies)
#input adapter
#endregion
#replace tcpdf use
#move date formatting to the languages helper
#replace numeric instances layout handling with strings
#endregion
#region Quality ########################################################################################################
#reformat text constant word order so that they are written as spoken: organizer_resource_edit => organizer_edit_resource
#change the delta column to a signed int -1 'remove', 0 'no change from previous schedule', 1 'new'
#sql binding
#shorten the OEs of lengthy instances view titles
#minimize helper use of input functions
#minimize helper data manipulation => only read as far as possible
#move standard data manipulation functions to the base table
#clean up text constants
#add descriptive texts to organizations from organization websites or ask the dean's offices
#endregion
#region Projects #######################################################################################################
#degrees views
#lesson_statistics view
#programs view for frontend
#room_display / upcoming view
#terms views
#region Documentation Export ###########################################################################################
#export the documentation of an individual subject as pdf
#export the documentation of a program's subjects as pdf (catalog)
#catalogs should have navigation
#catalogs should have requisite links
#catalogs should have curriculum related texts
#endregion
#region Frequencies ####################################################################################################
#change the frequency ids from 0-5 to 1-6
#add the new ids to the frequencies helper as constants
#update frequencies, programs, subjects
#adjust lsf import to compensate
#make the frequencies field reference the table
#endregion
#region Internal Planning###############################################################################################
#bind grids to runs?
#complete implementation
#allow organizations to add optional/manual holidays that are only valid for themselves
#region Blocks & Terms Strategy
#come up with a longer term and more inclusive strategy for blocks
#create during planning process or after the creation of new terms
#endregion
#endregion##############################################################################################################
#region Merging ########################################################################################################
#Categories, Events & Participants
#delete unused events
#add unique key for event entry key items
#reactivate new functions as appropriate
#endregion
#region MultiSelect ####################################################################################################
#create a standard fix for default multiple select handling and include it per default, especially for curriculum resources
#endregion
#region Notification ###################################################################################################
#create a notification function for the delta between two schedules
#create a notification function for schedule changes made which impact personal schedules
#expand participants profiles as necessary for notification and other feature opt-ins
#endregion
#region Participants ###################################################################################################
#anonymize 'external' participants
#endregion
#region Programs #######################################################################################################
#adjust/expand inclusive structural adjustments to organizer tables for programs
#migrate program data from the main page
#create program views
#endregion
#region PDF/XLS Output #################################################################################################
#work towards 100% parity
#endregion
#region Tagging ########################################################################################################
#add resource_field tables to associate resources with multiple fields in addition to the existing reference
#rename the existing reference for pools and subjects to display field with appropriate texts
#field associations with curriculum resources should carry over to the scheduling resources they are associated with
#endregion##############################################################################################################
#endregion
#region Miscellaneous ##################################################################################################
#create a strategy around required image files: logo, signature, ...
#decide what to do with inactive campuses and buildings
#replace jquery use with plain js
#add a addScript/addStyleSheet wrapper function to the html helper which automatically loads the de-/mined files
#create a coherent strategy for the structured output of organization related resources
#endregion##############################################################################################################