-
Notifications
You must be signed in to change notification settings - Fork 7
/
UPG_TODO.php
157 lines (135 loc) · 5.04 KB
/
UPG_TODO.php
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
<?
// Upgrage Todos UPG
/*
Done
## Todos Docker/MySQL57/PHP72
* TODO DB: change collation to utf8_german2_ci
* TODO Use charset utf8mb4
* TODO Alter table to DYNAMIC or COMPRESSED row format (https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format-dynamic.html, https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format-specification.html)
* TODO improve DB scripts for 3307 port
* TODO clever mechanism for docker container names in scripts (env variable)
* TODO handle partions with nonalphabetic name starts like ."«
* TODO Check utils.createLoadingModalDialog(localizer.getString('Deleting')).modal();
* TODO Improve and update security
* TODO Use public_html/bearbeitung/components/common_utils.php
* TODO improve custom/custom_page.php
* TODO upgrade tabula
## 2nd Prio
* TODO Count IB
* TODO Enable ONLY_FULL_GROUP_BY sql_mode after MySQL 8.0 migration having window functions, update code, test
* TODO replace CONCAT() with CONCAT_WS() in db_views.sql
* TODO enable sql_mode NO_ZERO_IN_DATE,NO_ZERO_DATE, fix db_views.sql
## Done PHP 7.2 and MySQL 5.7
* check debian PHP 5.7 and MySQL 5.7
* abel: docker mysql respect my.cnf config
* abel: PHP 7.2
* abel: setup php.ini for PHP 7.2
* abel: setup Apache2.4
* abel: docker MySQL 5.7
* abel: setup my.cnf for docker MySQL 5.7
* forms: fix sql_mode=only_full_group_by
* abel: create docker MySQL aliases
* abel: change back to 127.0.0.1 instead of localhost/socket (php.ini, my.cnf)
* run views refresh
* use docker mysqldump
* generate forms
* run ws.p
* abel: setup PhpMyAdmin
* abel: start mariaDB 10.2 on 3307
* upgrade scripts to PHP 7.2
* change scripts to docker MySQL 5.7
* RPIW: upgrade RPIW PHP 7.2
* RPIW: upgrade RPIW MySQL 5.7/MariaDB 10.2 --> create docker container based on RPIW using sid 5.7.22 image, see presentation
* RPIW: run ws.p
* understand /debian/pool/main
* drupal see PHP 7.2 errors
* patch Drupal
* cyon: patch Drupal
* abel: import mariaDB 10.2 on 3307
* abel: docker map into new file, do not override /etc/my.cnf
* tag new lw version
* forms: upload forms
* test Drupal PHP 7.2
* cyon: set PHP 7.2
* forms: utf-8 problem in partition
* infomail schreiben (deselect, upgraded PHP, MySQL, nichts sehen, benutzer Docker (neue Technologie), etwa 1w Arbeit, spam filter von Webseite gibt es nicht mehr)
* Update website with current requirements
* docker: tag and images upload
* write blog article inputrc (useful for Docker commands, only certain type)
* write blog article MySQL 5.7 docker debian for RPi
* restore full backup on RPIW (structure may change)
* send bug report to SQLMaestro because of wrong array init / query_utils.php (create_function()) / mpdf.php (each())
* v_organisation_beziehung should use v_organisation_simple
* OK understand and see entrypoints
## Done PHPGen migration:
* Test application features
* Remove calls to $this->RenderText()
* Check UID WS Call from Button in Organisation Edit
* Remove UPG todo tags
* AJAX broken: Quick search
* AJAX broken: Detail records with +
* Update custom_templates
* Afterburner which necessary, clean up
* SelectedOperationGridState migration
* export lobbywatch.sql
* Migrate Sources to UTF-8
* Find latin-1 files
* Delete all public_html/bearbeitung files and detect unnecessary files
* remove convert_utf8() calls
* check custom files for changes
## Done PG Import
* check interessenbingung to delete
* review code
* integrate pull request
* fix migration typo organisation -> interessenbingung
* NO change organisation.sekretariat to textfield
* make DB migration
* marker für importierte fields updaten (updated_by_import, sekretariat)
* check my changes survive
* run pg script
* add fields of Céline
* generate froms
* make DB migration on PROD
* archive pg PDFs like zb PDFs
* upload forms
* update lobbywatch.sql file
* add pg summary to mail
* info benutzer (* sekretariat, * Beschreibung, * updated_by_import, * doppelte gelöscht, * PG PDF von Hand, Rechreschreib Fehler, Margrit vs Margret Kiener-Nellen, * HP von Gruppe wenn Sekretariat, * leider schlecht formatiert)
* Debian upgrade
* Pull Request
* Upgrade to PHPGen 18.3.0.3
* increase adresse_zusatz
* Gen Forms after adresse_zusatz increase
* Verschieben lobbygruppe, homepage
* Update form managed fields
* Status setzen
* Add guess lib to wstadt
## Refused Todos
* Remove ^M in generated *.js files
* Remove trailing whitespace in generated code, https://stackoverflow.com/questions/9532340/how-do-i-remove-trailing-whitespace-using-a-regular-expression
*/
/*
## Custom features added to PHPGen framework
* Comments on edit forms
* Bulk Ops
* Enhanced comments on grid header
* Call UID WS
* Marked fields on edit/insert form
* Custom main.css
* Custom main.js
* Preview parlamentarier
* Default filter out retired parlamentarier [rework]
* Improved security [rework]
*/
/*
Test report 01.07.2018/Osaka
* Enhanced comments on grid header → OK
* Bulk Ops → OK
* Comments on edit forms → OK
* Marked fields on edit/insert form → OK
* Call UID WS → OK
* Custom main.css → OK
* Custom main.js → OK
* Preview parlamentarier
* Default filter out retired parlamentarier [rework]
* Improved security [rework]