Commit Graph

117 Commits

Author SHA1 Message Date
Ralf Becker
346b580e25 Do NOT move start- and end-date, to the earliest exception, as they will NOT be found in CalDAV or ActiveSync, because
we only recognice recuring events which start before or in the current timerange and end in or after it or have no end-date.
--> give an error message, as it is a debuging/support nightmare, if this gets silently fixed when reading events.
No idea how this situation (exceptions before startdate) can be created anyway.
2011-09-12 11:06:38 +00:00
Ralf Becker
709ecc35d7 * Calendar: not using freebusy rights for searching calendar, as it would allow to probe for event contents
- optimised private event filter for searching to not query private grants (again) from database
2011-08-16 10:22:05 +00:00
Ralf Becker
78b40243b7 * CalDAV/calendar backported iterator from trunk to minimize resource usage
- move all filtering into SQL query in calendar_so, to be able to correctly return N rows starting from row M
- re-enabling propfind iterator again for calendar (fetching events in chunks of 500), to lower memory footprint
Please note: changed SQL queries used for CalDAV do not take changed participants (or status) in exceptions into account
- merged: r34529, r34584, r34592, r34594, r35948
2011-08-03 16:53:22 +00:00
Ralf Becker
ef559e486a * Calendar: show status set for the whole series at recurrences too, unless they have an individual status
removed previous participants call now completly, as the above changes archive the same thing, without enumerating all recurrences to the database
2011-08-03 13:06:07 +00:00
Klaus Leithoff
f3538e3f9a fix broken category search, selected cat=1 always, when only one category wasselected, as (int) of an array does not give the required/expected result 2011-07-19 07:46:22 +00:00
Ralf Becker
7aefeb5469 patch #2952: typo in class.calendar_so.inc.php 2011-05-03 17:28:17 +00:00
Ralf Becker
d5b44b8e56 * CalDAV: improved performance of ctag generation
using only a single and quick DB query, compared to multiple queries plus one for each recurring event
2011-04-06 12:59:52 +00:00
Ralf Becker
b1db66a28e * Calendar: store async job of alarm with alarm owner as owner to get eg. the correct from address 2011-03-21 14:14:18 +00:00
Ralf Becker
5c6a19d8ef * Calendar: fixed PostgreSQL error on transfering records of a delted user to an other one 2011-03-11 07:38:13 +00:00
Ralf Becker
01974225f8 * Calendar: fixed SQL error on search: Argument of OR must be of type boolean, not of type smallint 2011-03-10 17:57:11 +00:00
Ralf Becker
f85ca66d2f * Calendar: no longer returning private events of other user while searching, as it can reveal private information 2011-03-07 15:12:08 +00:00
Ralf Becker
4eb506b01b * CalDAV/Lightning: fixed under some conditions infinit poping up alarms and user not able to add alarms
- Lightning pops up alarm, until Sequence/etag get updated: if user has no edit rights on an other users calendar, etag never got updated, now we update it
- fixed user was not able to add alarms via CalDAV, if he had no edit rights for event (was always possible in web UI)
- alarms from other users calendars are not included any more, as they make no sense but a lot of trouble
- fixed wrong condition on adding alarms, causing some alarms no being saved
2011-03-05 10:26:17 +00:00
Ralf Becker
177711fa69 - fixed status of all recurrences get set to "unknown", if status of a single recurrence get changed
- merged again revert r32957: fixed conflict check of resource quantity and storage of changed quantity in existing events
(changed quantity was used for conflict check, but not stored!)
2011-01-07 07:59:21 +00:00
Jörg Lehrke
6edd9d13b0 Rollback r32958 2010-11-23 20:01:55 +00:00
Ralf Becker
59d7cd76b3 * fixed conflict check of resource quantity and storage of changed quantity in existing events
(changed quantity was used for conflict check, but not stored!)
There is still a bug with multiple non-overlapping events overlapping the checked event: check is against quantity sum, not the maximum
2010-11-11 08:53:07 +00:00
Ralf Becker
2fff99a676 fixed typo 2010-10-28 09:44:11 +00:00
Ralf Becker
6ba20abd97 an other PostgreSQL compatibility problem: cast to varchar necessary 2010-10-28 09:33:15 +00:00
Ralf Becker
ab019492aa removed never implemented cats_no_subs common pref and always include sub-cats (no change as currently only one was selectable) 2010-10-21 15:59:01 +00:00
Nathan Gray
f8e69a190a Add import / export support through importexport app 2010-10-13 17:49:34 +00:00
Nathan Gray
7c55020318 Use just set cal_id variable instead of potentially not set event['cal_id'] 2010-10-13 17:24:32 +00:00
Jörg Lehrke
07063ebf7a Update cal_modified for all required cases; adjust CalDAV ctag function 2010-09-11 18:08:48 +00:00
Ralf Becker
5a2ac9b987 fix for postgreSQL bug reported by Anthony Messina (amessina-at-messinet.com): sync_contentid is varchar(60) and needs explicit cast, fixed by letting egw_db do the quoting, which is more save anyway 2010-09-10 07:02:16 +00:00
Ralf Becker
ce35264ed9 fix for postgreSQL bug reported by Anthony Messina (amessina-at-messinet.com): sync_contentid is varchar(60) and needs explicit cast, fixed by letting egw_db do the quoting, which is more save anyway 2010-09-10 07:01:41 +00:00
Ralf Becker
8241be4091 storing deleted timestamp instead of a deleted flag, to allow to use calendar table instead of egw_api_content_history later on 2010-09-09 09:11:57 +00:00
Jörg Lehrke
f90e1da24f Fix alarm handling for recurring events starting in the past 2010-08-10 21:21:18 +00:00
Jörg Lehrke
346a5bf5a6 Fix alarm handling for recurring events starting in the past 2010-08-10 21:21:05 +00:00
Klaus Leithoff
f7847a1183 rework of calendar purge function 2010-07-06 08:25:13 +00:00
Klaus Leithoff
f2bc58898f rework of calendar purge function 2010-07-06 08:20:53 +00:00
Ralf Becker
0933a70651 removed columns from DELETE statement 2010-07-02 06:01:09 +00:00
Ralf Becker
419516c011 removed columns from DELETE statement 2010-07-02 06:00:25 +00:00
Ralf Becker
bb07a036ca backported Nathan r31245:
- Fix purging of old events so it doesnt delete everything
- Trick config into calling the hook when purging is turned off so cron job is cancelled
2010-07-01 16:08:54 +00:00
Nathan Gray
f8431b00a7 - Fix purging of old events so it doesn't delete everything
- Trick config into calling the hook when purging is turned off so cron job is cancelled
2010-07-01 15:27:37 +00:00
Jörg Lehrke
9184bc0f67 Fix SyncML replace and recur_enddate issue 2010-06-26 16:03:14 +00:00
Jörg Lehrke
c6b0f825d9 Fix SyncML replace and recur_enddate issue 2010-06-26 15:58:33 +00:00
Ralf Becker
a2b6b3fe58 backporting r30991-4: using egw_db->capabilities[egw_db::CASE_INSENSITIVE_LIKE] and other PostgreSQL 8.3 fixes 2010-06-22 17:03:05 +00:00
Ralf Becker
a4ae9df347 searching case insensitive for PostgreSQL too 2010-06-22 16:59:04 +00:00
Jörg Lehrke
74653d300e Fix recurring event alarm issue 2010-06-18 13:42:39 +00:00
Jörg Lehrke
ae1807c571 Fix recurring event alarm issue 2010-06-18 13:37:42 +00:00
Nathan Gray
e5ac08edab Backport 30789: Move purging of old calendar events to use less API and do more with the DB directly. Hopefully will be a little easier on the DB. 2010-06-14 11:46:03 +00:00
Nathan Gray
61099d4a89 Move purging of old calendar events to use less API and do more with the DB directly. Hopefully will be a little easier on the DB. 2010-06-14 11:45:00 +00:00
Jörg Lehrke
f6eb00e6a1 Allow alarms for recurring events starting in the past 2010-06-08 16:36:55 +00:00
Jörg Lehrke
015245d235 Improved alarm handling 2010-06-07 17:54:29 +00:00
Ralf Becker
b1682123c7 certain clean-ups, plus fixing wrong query passed to calendar integration (leftover from parameter change) 2010-06-01 09:28:37 +00:00
Ralf Becker
de1a64cacd "missing break in deleted filter (showing only unknow status)" 2010-05-21 15:09:11 +00:00
Ralf Becker
3a19b96589 "fixed not not changed old $_cols parameter to $params['cols']" 2010-05-21 15:05:31 +00:00
Ralf Becker
2d53603ccd replaced several calendar_so::search() parameter with new array $params parameter and added new $params[users] with raw users as passed to calendar_bo::search() (without members and memberships added) for calendar integration 2010-05-20 15:22:37 +00:00
Ralf Becker
06854c6301 replaced several calendar_so::search() parameter with new array $params parameter and added new $params[users] with raw users as passed to calendar_bo::search() (without members and memberships added) for calendar integration 2010-05-20 15:12:59 +00:00
Jörg Lehrke
7ab47224c9 Fix calendar_bo::search() returning all-day events one day later (bug#2602) 2010-05-17 15:40:06 +00:00
Jörg Lehrke
ec48d32681 Calendar recurrence horizont configurable; fix recur_enddate issue 2010-05-03 16:43:42 +00:00
Nathan Gray
a2daa3f5cc Add trailing / to regex to silence warning 2010-04-27 18:35:14 +00:00