fix: Patch simplification
- Also, apply patch to all docs
diff --git a/erpnext/patches/v12_0/set_multi_uom_in_rfq.py b/erpnext/patches/v12_0/set_multi_uom_in_rfq.py
index 50725bb..70ca6b2 100644
--- a/erpnext/patches/v12_0/set_multi_uom_in_rfq.py
+++ b/erpnext/patches/v12_0/set_multi_uom_in_rfq.py
@@ -9,21 +9,8 @@
def execute():
frappe.reload_doc('buying', 'doctype', 'request_for_quotation_item')
- for rfq_item in frappe.db.sql("""SELECT name, item_code, uom, qty FROM `tabRequest for Quotation Item` WHERE docstatus<2""", as_dict=1):
- item_code, uom, qty = rfq_item.get("item_code"), rfq_item.get("uom"), rfq_item.get("qty")
- conversion_factor = get_conversion_factor(item_code, uom).get("conversion_factor") or 1.0
-
- filters = {
- "name" : rfq_item.get("name"),
- "stock_uom" : frappe.db.get_value("Item", item_code, "stock_uom"),
- "conversion_factor" : conversion_factor,
- "stock_qty" : flt(qty) * flt(conversion_factor)
- }
-
- frappe.db.sql("""UPDATE `tabRequest for Quotation Item`
+ frappe.db.sql("""UPDATE `tabRequest for Quotation Item`
SET
- stock_uom= %(stock_uom)s,
- conversion_factor = %(conversion_factor)s,
- stock_qty = %(stock_qty)s
- WHERE
- name = %(name)s""", filters)
\ No newline at end of file
+ stock_uom = uom,
+ conversion_factor = 1,
+ stock_qty = qty""")
\ No newline at end of file