2024-08-24 12:59:17,289 INFO ipython === bench console session ===
2024-08-24 12:59:17,290 INFO ipython frappe.throw("Anything here")
2024-08-24 12:59:17,290 INFO ipython frappe.call({method: "erpnext.selling.page.custom_point_of_sale.custom_point_of_sale.get_items",
args: { start:'0', page_length:'5', price_list:'vk_preise', item_group:'4-fach',pos_profile:'Kassen Profil', search_term:'' }});
2024-08-24 12:59:17,290 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],
filters={"price_list": 'vk_preise',"item_code": '098919-442' or '098919'"selling": True,},)
2024-08-24 12:59:17,291 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],
filters={"price_list": 'vk_preise',"item_code": '098919-442' or '098919',
"selling": True,},)
2024-08-24 12:59:17,291 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],
filters={"price_list": 'vk_preise',"item_code": '098919', "selling": True,},)
2024-08-24 12:59:17,291 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],
filters={"price_list": 'vk_preise',"item_code": '098919', "selling": True,},)
2024-08-24 12:59:17,291 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"])
2024-08-24 12:59:17,291 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"]
,filters={"price_list": 'vk_preise'})
2024-08-24 12:59:17,291 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"]
,filters={"price_list": 'VK Preise'})
2024-08-24 12:59:17,292 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"]
,filters={"price_list": 'VK Preise',"item_code": '098919' or '098919-444',})
2024-08-24 12:59:17,292 INFO ipython === session end ===
2024-08-24 13:11:41,664 INFO ipython === bench console session ===
2024-08-24 13:11:41,665 INFO ipython erpnext.selling.page.custom_point_of_sale.custom_point_of_sale.get_items()
2024-08-24 13:11:41,665 INFO ipython erpnext.custom_point_of_sale.get_items()
2024-08-24 13:11:41,665 INFO ipython === session end ===
2024-08-24 13:31:00,278 INFO ipython === bench console session ===
2024-08-24 13:31:00,278 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"]
,filters={"price_list": 'VK Preise',"item_code": '098919' or '098919-444',"selling": True,})
2024-08-24 13:31:00,278 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"]
,filters={"price_list": 'VK Preise',"item_code": '098919' or '098919-444',"selling": True,}).get("price_list_rate")
2024-08-24 13:31:00,278 INFO ipython === session end ===
2024-08-24 14:01:20,608 INFO ipython === bench console session ===
2024-08-24 14:01:20,608 INFO ipython frappe.db.get_value("POS Profile", 'Kassen Profil', "selling_price_list");
2024-08-24 14:01:20,608 INFO ipython === session end ===
2024-08-26 09:45:52,557 INFO ipython === bench console session ===
2024-08-26 09:45:53,107 INFO ipython erpnext.custom_point_of_sale.get_items()
2024-08-26 09:45:53,108 INFO ipython frappe.call({method: "erpnext.selling.page.custom_point_of_sale.custom_point_of_sale.get_items",
args: { start:'0', page_length:'5', price_list:'VK Preise', item_group:'4-fach',pos_profile:'Kassen Profil', search_term:'' }})
2024-08-26 09:45:53,108 INFO ipython frappe.get_doc("Item", "098919-442").get("variant_of", [])
2024-08-26 09:45:53,108 INFO ipython === session end ===
2024-08-26 11:31:02,753 INFO ipython === bench console session ===
2024-08-26 11:31:02,773 INFO ipython frappe.ui.form.qz_connect()
2024-08-26 11:31:02,774 INFO ipython === session end ===
2024-08-26 17:54:54,881 INFO ipython === bench console session ===
2024-08-26 17:54:54,888 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": "0252-1650" or "0252","selling": True,},)
2024-08-26 17:54:54,888 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": "0252","selling": True,},)
2024-08-26 17:54:54,889 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": ("0252-1650" or "0252"),"selling": True,},)
2024-08-26 17:54:54,889 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": ("0252-1650" , "0252"),"selling": True,},)
2024-08-26 17:54:54,889 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": in  ("0252-1650" , "0252"),"selling": True,},)
2024-08-26 17:54:54,889 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": "in"  ("0252-1650" , "0252"),"selling": True,},)
2024-08-26 17:54:54,889 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": {"in" : ("0252-1650" , "0252")},"selling": True,},)
2024-08-26 17:54:54,890 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": ("like", "%0252"),"selling": True,},)
2024-08-26 17:54:54,890 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": "0252-1650" or "0252","selling": True,},)
2024-08-26 17:54:54,890 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": "0252" or "0252-1650","selling": True,},)
2024-08-26 17:54:54,890 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": ("0252-1650" or "0252"),"selling": True,},)
2024-08-26 17:54:54,890 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": {"0252-1650" or "0252"},"selling": True,},)
2024-08-26 17:54:54,891 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": ("0252-1650" or "0252"),"selling": True,},)
2024-08-26 17:54:54,891 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code":{ "in": ["0252-1650", "0252"] } ,"selling": True,},)
2024-08-26 17:54:54,891 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": ( "in": ["0252-1650", "0252"] ) ,"selling": True,},)
2024-08-26 17:54:54,891 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": ( "in" ["0252-1650", "0252"] ) ,"selling": True,},)
2024-08-26 17:54:54,891 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": ( in ["0252-1650", "0252"] ) ,"selling": True,},)
2024-08-26 17:54:54,892 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": ["0252-1650","or", "0252"],"selling": True,},)
2024-08-26 17:54:54,892 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": ("0252-1650","or", "0252"),"selling": True,},)
2024-08-26 17:54:54,892 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": "in" ("0252-1650", "0252"),"selling": True,},)
2024-08-26 17:54:54,892 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": in ("0252-1650", "0252"),"selling": True,},)
2024-08-26 17:54:54,892 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code":  ("in", "0252-1650", "0252"),"selling": True,},)
2024-08-26 17:54:54,892 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code" : ("in", ("0252-1650", "0252")),"selling": True,},)
2024-08-26 17:54:54,893 INFO ipython === session end ===
2024-08-27 09:17:33,293 INFO ipython === bench console session ===
2024-08-27 09:17:33,303 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code" : ("in", ("3912-002", "3912")),"selling": True,},)
2024-08-27 09:17:33,303 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no","valid_from"],filters={"price_list": "VK Preise","item_code" : ("in", ("3912-002", "3912")),"selling": True,},)
2024-08-27 09:17:33,304 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no","valid_from"],filters={"price_list": "VK Preise","item_code" : "11010","selling": True,},)
2024-08-27 09:17:33,304 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code" : "11010","selling": True,},)
2024-08-27 09:17:33,304 INFO ipython === session end ===
2024-08-27 11:23:30,216 INFO ipython === bench console session ===
2024-08-27 11:23:30,236 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": "in" ("0252-1650", "0252"),"selling": True,},)
2024-08-27 11:23:30,236 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": ("in" ("0252-1650", "0252")),"selling": True,},)
2024-08-27 11:23:30,237 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,},)
2024-08-27 11:23:30,237 INFO ipython === session end ===
2024-08-27 12:12:16,327 INFO ipython === bench console session ===
2024-08-27 12:12:16,345 INFO ipython frappe.get_doc("Item", "0252-1650")
2024-08-27 12:12:16,345 INFO ipython frappe.get_doc("Item", "0252-1650").get("uoms", [])
2024-08-27 12:12:16,345 INFO ipython === session end ===
2024-08-27 12:23:18,186 INFO ipython === bench console session ===
2024-08-27 12:23:18,187 INFO ipython === session end ===
2024-08-27 12:48:00,248 INFO ipython === bench console session ===
2024-08-27 12:48:00,285 INFO ipython frappe.get_doc("Item", "0252-1650").get("uoms", [])
2024-08-27 12:48:00,285 INFO ipython frappe.get_doc("Item", "0252-1650").get("prices", [])
2024-08-27 12:48:00,285 INFO ipython frappe.get_doc("Item", "0252").get("prices", [])
2024-08-27 12:48:00,285 INFO ipython === session end ===
2024-08-27 14:18:36,377 INFO ipython === bench console session ===
2024-08-27 14:18:36,377 INFO ipython frappe.get_doc("Item", "11010").get("uoms", [])
2024-08-27 14:18:36,378 INFO ipython frappe.get_doc("Item", "11010")
2024-08-27 14:18:36,378 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,},)
2024-08-27 14:18:36,378 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("3912-002", "3912")),"selling": True,},)
2024-08-27 14:18:36,378 INFO ipython max([{'price_list_rate': 4.95,
  'currency': 'EUR',
  'uom': None,
  'batch_no': None,
  'valid_from': None},
 {'price_list_rate': 5.95,
  'currency': 'EUR',
  'uom': None,
  'batch_no': None,
  'valid_from': datetime.date(2023, 4, 13)}], key='valid_from')
2024-08-27 14:18:36,378 INFO ipython max([{'price_list_rate': 4.95,
  'currency': 'EUR',
  'uom': None,
  'batch_no': None,
  'valid_from': None},
 {'price_list_rate': 5.95,
  'currency': 'EUR',
  'uom': None,
  'batch_no': None,
  'valid_from': '2023-04-13'}], key='valid_from')
2024-08-27 14:18:36,379 INFO ipython max([{'price_list_rate': 4.95,
  'currency': 'EUR',
  'uom': None,
  'batch_no': None,
  'valid_from': None},
 {'price_list_rate': 5.95,
  'currency': 'EUR',
  'uom': None,
  'batch_no': None,
  'valid_from': 1000}], key='valid_from')
2024-08-27 14:18:36,379 INFO ipython frappe.get_last_doc("Item Price", filters={"item_code": ("in", ("3912-002", "3912"))}).get("valid_from", [])
2024-08-27 14:18:36,379 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("3912-002", "3912")),"selling": True,"valid_from":"datetime.date(2023, 4, 13)"},)
2024-08-27 14:18:36,379 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("3912-002", "3912")),"selling": True,"valid_from":"2023-4-13"},)
2024-08-27 14:18:36,379 INFO ipython frappe.get_last_doc("Item Price", filters={"item_code": ("in", ("3912-002", "3912"))}).get("valid_from", []).strftime('%Y-%m-%d')
2024-08-27 14:18:36,380 INFO ipython === session end ===
2024-08-27 16:07:57,174 INFO ipython === bench console session ===
2024-08-27 16:07:57,198 INFO ipython frappe.get_last_doc("Item Price", filters={"item_code": ("in", ("3912-002", "3912"))}).get("valid_from", [])
2024-08-27 16:07:57,198 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,},)
2024-08-27 16:07:57,198 INFO ipython frappe.get_last_doc("Item Price", filters={"item_code": ("in", ("3912-002", "3912"))}).get("valid_from", []).strftime('%Y-%m-%d')
2024-08-27 16:07:57,198 INFO ipython frappe.get_last_doc("Item Price", filters={"item_code": ("in", ("0252-1650", "0252"))}).get("valid_from", []).strftime('%Y-%m-%d')
2024-08-27 16:07:57,199 INFO ipython frappe.get_last_doc("Item Price", filters={"item_code": ("in", ("0252-1650", "0252"))}).get("valid_from", [])
2024-08-27 16:07:57,199 INFO ipython frappe.get_last_doc("Item Price", filters={"item_code": ("in", ("0252-1650", "0252"))}).get("valid_from", [])
2024-08-27 16:07:57,199 INFO ipython === session end ===
2024-08-27 17:25:32,554 INFO ipython === bench console session ===
2024-08-27 17:25:32,604 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,"valid_from": "",)}
2024-08-27 17:25:32,605 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,"valid_from": "",})
2024-08-27 17:25:32,605 INFO ipython frappe.get_last_doc("Item Price", filters={"item_code": ("in", ("0252-1650", "0252"))}).get("valid_from", [])
2024-08-27 17:25:32,605 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,"valid_from": NONE,})
2024-08-27 17:25:32,605 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,"valid_from": 0,})
2024-08-27 17:25:32,605 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,"valid_from": None,})
2024-08-27 17:25:32,606 INFO ipython === session end ===
2024-08-27 17:51:26,811 INFO ipython === bench console session ===
2024-08-27 17:51:26,838 INFO ipython frappe.get_last_doc("Item Price", filters={"item_code": ("in", ("0252-1650", "0252"))}).get("valid_from", [])
2024-08-27 17:51:26,838 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True})
2024-08-27 17:51:26,838 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,"valid_from": "",})
2024-08-27 17:51:26,838 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,"valid_from": ?,})
2024-08-27 17:51:26,838 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,"valid_from": None,})
2024-08-27 17:51:26,838 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,"valid_from": "None",})
2024-08-27 17:51:26,838 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,"valid_from": 0,})
2024-08-27 17:51:26,839 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True,"valid_from": "0001-01-01",})
2024-08-27 17:51:26,839 INFO ipython frappe.db.format_date(NULL)
2024-08-27 17:51:26,839 INFO ipython frappe.db.format_date(None)
2024-08-27 17:51:26,839 INFO ipython frappe.db.format_date("")
2024-08-27 17:51:26,839 INFO ipython frappe.get_all("Item Price",fields=["price_list_rate", "currency", "uom", "batch_no", "valid_from"],filters={"price_list": "VK Preise","item_code": ("in", ("0252-1650", "0252")),"selling": True})
2024-08-27 17:51:26,839 INFO ipython === session end ===
2024-08-28 09:14:22,677 INFO ipython === bench console session ===
2024-08-28 09:14:22,701 INFO ipython frappe.utils.nestedset.get_root_of("Item Group")
2024-08-28 09:14:22,701 INFO ipython frappe.utils.get_root_of("Item Group")
2024-08-28 09:14:22,701 INFO ipython frappe.get_root_of("Item Group")
2024-08-28 09:14:22,702 INFO ipython get_root_of("Item Group")
2024-08-28 09:14:22,702 INFO ipython get_root_of("Item Group")
2024-08-28 09:14:22,702 INFO ipython from frappe.utils.nestedset import get_root_of
2024-08-28 09:14:22,702 INFO ipython get_root_of("Item Group")
2024-08-28 09:14:22,702 INFO ipython === session end ===
2024-09-18 13:53:05,734 INFO ipython === bench console session ===
2024-09-18 13:53:05,738 INFO ipython invoice = frappe.qb.DocType('POS Invoice')
item = frappe.qb.DocType('POS Invoice Item')

frappe.qb.from_(invoice)
    .inner_join(item)
    .on(invoice.name == item.parent)
    .select(invoice.name, invoice.grand_total, invoice.currency, invoice.customer, invoice.posting_time, invoice.posting_date) 
2024-09-18 13:53:05,738 INFO ipython invoice = frappe.qb.DocType('POS Invoice')
item = frappe.qb.DocType('POS Invoice Item')

frappe.qb.from_(invoice).inner_join(item).on(invoice.name == item.parent).select(invoice.name, invoice.grand_total, invoice.currency, invoice.customer, invoice.posting_time, invoice.posting_date) 
2024-09-18 13:53:05,738 INFO ipython invoice = frappe.qb.DocType('POS Invoice')
item = frappe.qb.DocType('POS Invoice Item')
frappe.qb.from_(invoice).inner_join(item).on(invoice.name == item.parent).where(item.item_name.like('%Catania%') ).select(invoice.name, invoice.grand_total, invoice.currency, invoice.customer, invoice.posting_time, invoice.posting_date).run(as_dict=True) 
2024-09-18 13:53:05,738 INFO ipython invoice = frappe.qb.DocType('POS Invoice')
item = frappe.qb.DocType('POS Invoice Item')
frappe.qb.from_(invoice).inner_join(item).on(invoice.name == item.parent).where((item.item_name.like('%Catania%')) | (item.item_code.like('%9801210%')) ).select(invoice.name, invoice.grand_total, invoice.currency, invoice.customer, invoice.posting_time, invoice.posting_date).run(as_dict=True) 
2024-09-18 13:53:05,739 INFO ipython invoice = frappe.qb.DocType('POS Invoice')
item = frappe.qb.DocType('POS Invoice Item')
frappe.qb.from_(invoice).inner_join(item).on(invoice.name == item.parent).where((item.item_name.like('%Catania%')) | (item.item_code.like('%9801210%')) | (item.barcode.like('%4053859084499%')) ).select(invoice.name, invoice.grand_total, invoice.currency, invoice.customer, invoice.posting_time, invoice.posting_date).run(as_dict=True) 
2024-09-18 13:53:05,739 INFO ipython invoice = frappe.qb.DocType('POS Invoice')
item = frappe.qb.DocType('POS Invoice Item')
frappe.qb.from_(invoice).inner_join(item).on(invoice.name == item.parent).where((item.item_name.like('%4053859084499%')) | (item.item_code.like('%4053859084499%')) | (item.barcode.like('%4053859084499%')) ).select(invoice.name, invoice.grand_total, invoice.currency, invoice.customer, invoice.posting_time, invoice.posting_date).run(as_dict=True) 
2024-09-18 13:53:05,739 INFO ipython frappe.db.get_all("POS Invoice",filters={"name": ["like", f"%{"R-24-}%"],fields=["name", "grand_total", "currency", "customer", "posting_time", "posting_date"])
2024-09-18 13:53:05,739 INFO ipython === session end ===