notes.txt

## Sequence

py -m venv

venv\Scipts\activate

py -m pip 

    install django

    install django-crispy-forms

    install crispy-bootstrap5

    freeze > requirements.txt

django-admin startproject timetable .

py manage.py 

    migrate
 
    createsuperuser

    runserver

django-admin startapp core

settings.py

    add 'core' to INSTALLED_APPS

    TIME_ZONE = 'Asia/Manila'

touch core\urls.py

create test view

create test template



## Ideas

- use table/cards
- sort by time
- filters
- add, edit/delete
- add models.py to common folder -NOT WORKING
- calculate rowspan: (endtime - starttime) * 2 = no. of rows

## Table display components

- queryset record sorter
- schedule conflict detector
- queryset to dense matrix converter
- dense matrix to html table renderer

## Table display steps

- fetch records
- group records by time ranges [def groupby(queryset, interval_minutes=30) return dict]
- sort each group by day [groupby() -> sort_day(dict):for e in dict sort e.x by x.day desc]
- if there are records within the time range that has the same day, mark those records as conflicting [for e in len(dict.e)-1 then set conflict if [x-1].day == [x].day]

## Timetable as object

structure of a timetable:

table->row->column

row 1: ['time', weekday headers]

row n: [time range header, event cells]

    table = [
        ['time', 'monday', 'tuesday',..], # row 1
        [time range 1, mon event, tue event,..], # row n
        [time range 2, mon event, tue event,..], # row n
    ]

attributes of a timetable:
- time range headers
    - index
    - string value
- weekday headers
    - index
    - string value
    - column span
- event cells
    - event text
    - row
    - column
    - row span

## Incremental development

v.1 
 - display basic timetable with 7-day week and 30-minute time range from 7:30 AM to 8:30 PM
 - using text choices for time fields and basic string matching
 - adding methods to models.Set such as get_matrix()



## References

https://www.w3schools.com/html/html_table_headers.asp