GitHub Repository for the university project Webentwicklung WS2024/25

Goal

A KanBan board with CodeIgniter 4 as backend

//TODO: explain what a KanBan is

How to remove index.php from URLs in CodeIgniter 4 and Apache

https://codeigniter.com/user_guide/general/urls.html#removing-the-index-php-file

httpd.conf:=

1. Enable rewrite_module
2. Allow override for the DocumentRoot or add a own directory configuration for the project
3. Add .htaccess to /public

ToDos:

• Aufgabe 1: Die erste statische Webseite

  1. Integrate Bootstrap CSS and JS
  2. Implement own CSS
  3. Place logo in nav
  4. Add Tasks, Spalten, Boards to nav
  5. Let nav have a color
  6. Tasks:
     • As startpage it will contain the future KanBan board
     • for now:
       • contain 1 container element
       • contain 1 card element
  7. Footer:
     • contain Copyright Web-Entwicklung Team 2024
     • contain Impressum
     • contain Datenschutz
     • contain Kontakt
     • get styled

• 2. Aufgabe 3: Bootstrap Tables

  • create new webpage, referenced by Spalten in nav
  • create a table containing:
    • ID
    • Board
    • Sortid
    • Spalte
    • Spaltenbeschreibung
    • Bearbeiten
  • create 2 example rows
  • place button "Erstellen" above the table

• 3. Aufgabe 4: Formulare

  • aim the button from the previous assignment towards a new webpage
  • add following elements to the page using bootstrap:
    • field type text for Spaltenbezeichnung
    • textarea for Spaltenbezeichnung
    • field type text for Sortid
    • dropdown
    • buttons for save and reset
  • pair every element with an label
  • make button "Speichern" visual different to "Abbrechen"
  • give the formular a heading

• Uebung 3: Datenbankmodellierung in phpMyAdmin

  • Deadline: 11.12.2024
  1. create new database
  2. create 'boards' table:
     • id
     • board
  3. create 'personen' table:
     • id
     • vorname
     • name
     • email
     • passwort
  4. create 'spalten' table:
     • id
     • boardsid
     • spalte
     • spaltenbeschreibung
     • adding foreign keys
  5. create 'taskarten' table:
     • id
     • taskart
     • taskartenicon
  6. create 'tasks' table:
     • id
     • personenid
     • taskartenid
     • spaltenid
     • sortid
     • tasks
     • erstelldatum
     • erinnerung
     • notizen
     • erledigt
     • geloescht
     • adding foreign keys
  7. adding constaints
  8. export database 9.[ ] test the database