| Anand Doshi | 486f9df | 2012-07-19 13:40:31 +0530 | [diff] [blame] | 1 | from __future__ import unicode_literals |
| Rushabh Mehta | 5eb3764 | 2013-02-14 17:34:51 +0530 | [diff] [blame^] | 2 | |
| 3 | import webnotes |
| 4 | |
| 5 | @webnotes.whitelist() |
| 6 | def get_events(start, end): |
| 7 | roles = webnotes.get_roles() |
| 8 | events = webnotes.conn.sql("""select name as `id`, subject as title, |
| 9 | starts_on as `start`, ends_on as `end`, "Event" as doctype, owner |
| 10 | from tabEvent where event_date between %s and %s |
| 11 | and (event_type='Public' or owner=%s |
| 12 | or exists(select * from `tabEvent User` where |
| 13 | `tabEvent User`.parent=tabEvent.name and person=%s) |
| 14 | or exists(select * from `tabEvent Role` where |
| 15 | `tabEvent Role`.parent=tabEvent.name |
| 16 | and `tabEvent Role`.role in ('%s')))""" % ('%s', '%s', '%s', '%s', |
| 17 | "', '".join(roles)), (start, end, |
| 18 | webnotes.session.user, webnotes.session.user), as_dict=1, debug=1) |
| 19 | |
| 20 | return events |
| 21 | |
| 22 | block_days = webnotes.conn.sql("""select block_date as `start`, |
| 23 | name as `id`, reason as `title`, "Holiday List Block Date" as doctype, |
| 24 | where block_date between %s and %s |
| 25 | and """) |
| 26 | |
| 27 | @webnotes.whitelist() |
| 28 | def update_event(name, start, end): |
| 29 | webnotes.conn.sql("""update tabEvent set starts_on=%s, ends_on=%s where |
| 30 | name=%s""", (start, end, name)) |
| 31 | |