zhuangxujie
01bc837fd4
Some checks failed
Server (Postgres) / Build & reinstall (setup) (push) Has been cancelled
Server (Postgres) / Python Unit Tests (1) (push) Has been cancelled
Server (Postgres) / Python Unit Tests (2) (push) Has been cancelled
Server (Postgres) / Python Unit Tests (3) (push) Has been cancelled
Server (Postgres) / Python Unit Tests (4) (push) Has been cancelled
Server (Mariadb) / Build & reinstall (setup) (push) Has been cancelled
Server (Mariadb) / Python Unit Tests (1) (push) Has been cancelled
Server (Mariadb) / Python Unit Tests (2) (push) Has been cancelled
Server (Mariadb) / Python Unit Tests (3) (push) Has been cancelled
Server (Mariadb) / Python Unit Tests (4) (push) Has been cancelled
Server (Mariadb) / Coverage Wrap Up (push) Has been cancelled
Lock threads / lock (push) Has been cancelled
Regenerate POT file (translatable strings) / Regenerate POT file (develop) (push) Has been cancelled
Regenerate POT file (translatable strings) / Regenerate POT file (version-16-hotfix) (push) Has been cancelled
Sync translations to hotfix branches / Trigger sync → version-16-hotfix (push) Has been cancelled
Create weekly release pull requests / Release (15) (push) Has been cancelled
Create weekly release pull requests / Release (16) (push) Has been cancelled
30 lines
908 B
Python
30 lines
908 B
Python
# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
|
|
# License: GNU General Public License v3. See license.txt
|
|
|
|
# For license information, please see license.txt
|
|
|
|
|
|
import frappe
|
|
from frappe.query_builder import Case
|
|
|
|
|
|
@frappe.whitelist()
|
|
@frappe.validate_and_sanitize_search_inputs
|
|
def query_task(doctype: str, txt: str, searchfield: str, start: int, page_len: int, filters: dict):
|
|
search_str = f"%{txt}%"
|
|
prefix_str = f"{txt}%"
|
|
|
|
Task = frappe.qb.DocType("Task")
|
|
query = frappe.qb.get_query("Task", fields=["name", "subject"], ignore_permissions=False)
|
|
|
|
return (
|
|
query.where(Task[searchfield].like(search_str) | Task.subject.like(search_str))
|
|
.orderby(Case().when(Task.subject.like(prefix_str), 0).else_(1))
|
|
.orderby(Case().when(Task[searchfield].like(prefix_str), 0).else_(1))
|
|
.orderby(Task[searchfield])
|
|
.orderby(Task.subject)
|
|
.limit(page_len)
|
|
.offset(start)
|
|
.run()
|
|
)
|