view-week-display-postgresql.xql

  • last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7834 more files in changeset.
- remove broken and unuesed query

PG 8.3 tightened up type checking, thus enforcing the notion that "to_date"

converts a string to a date, not a date to another form of a date (sheesh).

Moved that query into the pg xql file then discovered that apparently it's

not a good query for oracle, either, so hopefully fixed that (though it will

need testing)

  1. … 2 more files in changeset.
merge the changes between 5.0.3 and 5.0.4 to head

  1. … 249 more files in changeset.
Fixed critical bug #1569 so that week queries don't bomb out if

there are category items.

Removed a broken query

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.

  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.
Make calendar play nice with calendar-portlets. I am slowly approaching alpha status with this.

  1. … 20 more files in changeset.
Renamed first_weekday_of_the_week_system to first_weekday_of_the_week_tz because Oracle does not approve of too long variable names, Moved calculation of weekday to SQL - impossible to calculate that in TCL

  1. … 1 more file in changeset.
Multiple i18n fixes

    • -34
    • +14
    ./view-week-display-postgresql.xql
  1. … 10 more files in changeset.
adding timezone support to the month/week/day/list view templates

    • -45
    • +23
    ./view-week-display-postgresql.xql
  1. … 9 more files in changeset.
sanitized the query: removed unnecessary subqueries and the query now uses the same permission clause like calendar::calendar_list

  1. … 1 more file in changeset.
noquote fixes: moved as much html generation into adp files

  1. … 42 more files in changeset.
draft version of noquoted calendar package

    • -0
    • +56
    ./view-week-display-postgresql.xql
  1. … 22 more files in changeset.