view-one-day-display-postgresql.xql

  • last updated 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fixed bug 1677: One day view doesn't show items shorter than an hour and doesn't handle "dangling" minutes properly.

  1. … 2 more files in changeset.
Lumped all the different view-pages' query into one thus drastically slashing the amount of code that looks subtly different but effectively always retrieves calendar items for a particular interval.

    • -79
    • +0
    ./view-one-day-display-postgresql.xql
  1. … 13 more files in changeset.
The date format string is constant - it is always the ANSI date format. There is no need to create a variable in TCL and then pass it on as a bind variable to the database. Instead I have hard-wired the format string into the database which means less code and maybe even slightly more efficiency.

  1. … 12 more files in changeset.
removed obsolete start_clause and end_clause.

pay respect to start_display_hour and end_display_hour -> Added limiting clause to select_day_items_with_time query, brought back calendar_list_id (yuck)

  1. … 1 more file in changeset.
Make hours links to cal-item-new

  1. … 2 more files in changeset.
adding timezone support to the month/week/day/list view templates

    • -15
    • +10
    ./view-one-day-display-postgresql.xql
  1. … 9 more files in changeset.
More cleanup and bugfixes, moved cal-item-new to using ad_form, added timezones (peter marklund)

  1. … 14 more files in changeset.
starting to add timezone support to the calendar package. Have not finished this task yet as we are waiting for Dirk to help us fix some major breakages that are preventing us from testing

  1. … 26 more files in changeset.
sanitized the query: removed unnecessary subqueries and the query now uses the same permission clause like calendar::calendar_list

    • -10
    • +16
    ./view-one-day-display-postgresql.xql
  1. … 1 more file in changeset.
Fixed SQL query so that daily events and events with time are properly retrieved from the database

noquote fixes: moved as much html generation into adp files

    • -11
    • +48
    ./view-one-day-display-postgresql.xql
  1. … 42 more files in changeset.
draft version of noquoted calendar package

    • -0
    • +44
    ./view-one-day-display-postgresql.xql
  1. … 22 more files in changeset.