فلتر حسب الوقت

Time.py

sql_date_cond = ""
if filters.get("date_from") and filters.get("date_to"):
    date_from = frappe.db.escape(filters.get("date_from"))
    date_to = frappe.db.escape(filters.get("date_to"))
    
    sql_date_cond = f"""and posting_date between {date_from} and {date_to} """
    
elif filters.get("date_from"):
    date_from = frappe.db.escape(filters.get("date_from"))
    sql_date_cond = f"""and posting_date >= {date_from}"""

elif filters.get("date_to"):
    date_to = frappe.db.escape(filters.get("date_to"))
    
    sql_date_cond = f"""and posting_date <= {date_to} """
    
sql_time_cond = ""
if filters.get("time_from") and filters.get("time_to"):
    time_from = frappe.db.escape(filters.get("time_from"))
    time_to = frappe.db.escape(filters.get("time_to"))
    
    sql_time_cond = f"""and posting_time between {time_from} and {time_to} """
    
elif filters.get("time_from"):
    time_from = frappe.db.escape(filters.get("time_from"))
    sql_time_cond = f"""and posting_time >= {time_from}"""

elif filters.get("time_to"):
    date_to = frappe.db.escape(filters.get("time_to"))
    
    sql_time_cond = f"""and posting_time <= {time_to} """

res = frappe.db.sql(f"""select 
`tabSales Invoice`.name,
`tabSales Invoice`.posting_date,
`tabSales Invoice`.posting_time
from `tabSales Invoice`
where 
`tabSales Invoice`.status != 'Cancelled'
{sql_date_cond}
{sql_time_cond}
   """, as_dict=True)
result = res