| # For license information, please see license.txt |
| |
| from __future__ import unicode_literals |
| import webnotes |
| |
| @webnotes.whitelist() |
| def get_time_log_list(doctype, txt, searchfield, start, page_len, filters): |
| return webnotes.conn.get_values("Time Log", filters, ["name", "activity_type", "owner"]) |
| |
| @webnotes.whitelist() |
| def query_task(doctype, txt, searchfield, start, page_len, filters): |
| search_string = "%%%s%%" % txt |
| order_by_string = "%s%%" % txt |
| return webnotes.conn.sql("""select name, subject from `tabTask` |
| where `%s` like %s or `subject` like %s |
| order by |
| case when `subject` like %s then 0 else 1 end, |
| case when `%s` like %s then 0 else 1 end, |
| `%s`, |
| subject |
| limit %s, %s""" % |
| (searchfield, "%s", "%s", "%s", searchfield, "%s", searchfield, "%s", "%s"), |
| (search_string, search_string, order_by_string, order_by_string, start, page_len)) |