issues
search
ottlinger
/
hornherzogen
Project to manage Aikidō seminar registrations
GNU General Public License v3.0
0
stars
2
forks
source link
DB: ApplicantDatabaseWriter
#50
Closed
ottlinger
closed
7 years ago
ottlinger
commented
7 years ago
[x] getByNameAndMailadress($firstname, $lastname, $mail)
[x] persist($applicantInput)
set fullName if combination already exists
use Parser to map from bean to database structure / create a safe INSERT INTO ...
[x] getAllByWeek($week = NULL)
use in admin area as a self-submit list of applicants
[x] generate a combinedName in case an applicant with the same firstname, lastname combination does exist in the database => contains timestamp
[x] show lists of all applicants as a table in admin area
[x] show lists of applicants per week in admin area
[x] provide protection against SQL injection in BaseClass
[x] add length protection from form input to comply with the database (leave aside possible UTF-8mb4 encoding issues)
[x] show number of rows for each table in the db in admin area